eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CS_SERVICEREQUEST_PUB dependencies on FND_MSG_PUB

Line 601: FND_MSG_PUB.Initialize;

597: --BUG 3630159:
598: --Added to clear message cache in case of API call wrong version.
599: -- Initialize message list if p_init_msg_list is set to TRUE
600: IF FND_API.To_Boolean(p_init_msg_list) THEN
601: FND_MSG_PUB.Initialize;
602: END IF;
603:
604: -- Standard call to check for call compatibility
605: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,

Line 658: FND_MSG_PUB.Count_And_Get

654: EXCEPTION
655: WHEN FND_API.G_EXC_ERROR THEN
656: ROLLBACK TO Create_ServiceRequest_PUB;
657: x_return_status := FND_API.G_RET_STS_ERROR;
658: FND_MSG_PUB.Count_And_Get
659: ( p_count => x_msg_count,
660: p_data => x_msg_data
661: );
662: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 665: FND_MSG_PUB.Count_And_Get

661: );
662: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
663: ROLLBACK TO Create_ServiceRequest_PUB;
664: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
665: FND_MSG_PUB.Count_And_Get
666: ( p_count => x_msg_count,
667: p_data => x_msg_data
668: );
669: WHEN OTHERS THEN

Line 672: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

668: );
669: WHEN OTHERS THEN
670: ROLLBACK TO Create_ServiceRequest_PUB;
671: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
672: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
673: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
674: END IF;
675: FND_MSG_PUB.Count_And_Get
676: ( p_count => x_msg_count,

Line 673: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

669: WHEN OTHERS THEN
670: ROLLBACK TO Create_ServiceRequest_PUB;
671: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
672: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
673: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
674: END IF;
675: FND_MSG_PUB.Count_And_Get
676: ( p_count => x_msg_count,
677: p_data => x_msg_data

Line 675: FND_MSG_PUB.Count_And_Get

671: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
672: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
673: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
674: END IF;
675: FND_MSG_PUB.Count_And_Get
676: ( p_count => x_msg_count,
677: p_data => x_msg_data
678: );
679:

Line 1088: FND_MSG_PUB.Initialize;

1084: --BUG 3630159:
1085: --Added to clear message cache in case of API call wrong version.
1086: -- Initialize message list if p_init_msg_list is set to TRUE
1087: IF FND_API.To_Boolean(p_init_msg_list) THEN
1088: FND_MSG_PUB.Initialize;
1089: END IF;
1090:
1091: -- Standard call to check for call compatibility
1092: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,

Line 1183: FND_MSG_PUB.ADD_DETAIL

1179: FND_MESSAGE.set_token
1180: ( 'API_NAME'
1181: , 'CS_SERVICEREQUEST_PUB.create_servicerequest'
1182: );
1183: FND_MSG_PUB.ADD_DETAIL
1184: ( p_associated_column1 => 'CS_INCIDENTS_ALL_B.ITEM_SERIAL_NUMBER'
1185: );
1186: RAISE FND_API.G_EXC_ERROR;
1187: END IF;

Line 1402: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1398: );
1399: END IF;
1400:
1401: IF (l_key_flex_code IS NULL) THEN
1402: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1403: FND_MESSAGE.Set_Name('FND', 'PROFILES-CANNOT READ');
1404: FND_MESSAGE.Set_Token('OPTION', 'CS_ID_FLEX_CODE');
1405: FND_MESSAGE.Set_Token('ROUTINE', l_api_name_full);
1406: FND_MSG_PUB.Add;

Line 1406: FND_MSG_PUB.Add;

1402: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1403: FND_MESSAGE.Set_Name('FND', 'PROFILES-CANNOT READ');
1404: FND_MESSAGE.Set_Token('OPTION', 'CS_ID_FLEX_CODE');
1405: FND_MESSAGE.Set_Token('ROUTINE', l_api_name_full);
1406: FND_MSG_PUB.Add;
1407: END IF;
1408: RAISE FND_API.G_EXC_ERROR;
1409: END IF;
1410:

Line 2106: FND_MSG_PUB.Count_And_Get

2102: COMMIT WORK;
2103: END IF;
2104:
2105: -- Standard call to get message count and if count is 1, get message info
2106: FND_MSG_PUB.Count_And_Get
2107: ( p_count => x_msg_count,
2108: p_data => x_msg_data
2109: );
2110:

Line 2115: FND_MSG_PUB.Count_And_Get

2111: EXCEPTION
2112: WHEN FND_API.G_EXC_ERROR THEN
2113: ROLLBACK TO Create_ServiceRequest_PUB;
2114: x_return_status := FND_API.G_RET_STS_ERROR;
2115: FND_MSG_PUB.Count_And_Get
2116: ( p_count => x_msg_count,
2117: p_data => x_msg_data
2118: );
2119: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2122: FND_MSG_PUB.Count_And_Get

2118: );
2119: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2120: ROLLBACK TO Create_ServiceRequest_PUB;
2121: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2122: FND_MSG_PUB.Count_And_Get
2123: ( p_count => x_msg_count,
2124: p_data => x_msg_data
2125: );
2126: WHEN OTHERS THEN

Line 2129: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2125: );
2126: WHEN OTHERS THEN
2127: ROLLBACK TO Create_ServiceRequest_PUB;
2128: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2129: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2130: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2131: END IF;
2132: FND_MSG_PUB.Count_And_Get
2133: ( p_count => x_msg_count,

Line 2130: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

2126: WHEN OTHERS THEN
2127: ROLLBACK TO Create_ServiceRequest_PUB;
2128: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2129: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2130: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2131: END IF;
2132: FND_MSG_PUB.Count_And_Get
2133: ( p_count => x_msg_count,
2134: p_data => x_msg_data

Line 2132: FND_MSG_PUB.Count_And_Get

2128: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2129: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2130: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2131: END IF;
2132: FND_MSG_PUB.Count_And_Get
2133: ( p_count => x_msg_count,
2134: p_data => x_msg_data
2135: );
2136:

Line 2200: FND_MSG_PUB.Initialize;

2196: --BUG 3630159:
2197: --Added to clear message cache in case of API call wrong version.
2198: -- Initialize message list if p_init_msg_list is set to TRUE
2199: IF FND_API.To_Boolean(p_init_msg_list) THEN
2200: FND_MSG_PUB.Initialize;
2201: END IF;
2202:
2203: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
2204: AND NOT FND_API.Compatible_API_Call(l_api_version_back, p_api_version, l_api_name, G_PKG_NAME) THEN

Line 2257: FND_MSG_PUB.Count_And_Get

2253: COMMIT WORK;
2254: END IF;
2255:
2256: -- Standard call to get message count and if count is 1, get message info
2257: FND_MSG_PUB.Count_And_Get
2258: ( p_count => x_msg_count,
2259: p_data => x_msg_data
2260: );
2261:

Line 2266: FND_MSG_PUB.Count_And_Get

2262: EXCEPTION
2263: WHEN FND_API.G_EXC_ERROR THEN
2264: ROLLBACK TO Update_ServiceRequest_PUB;
2265: x_return_status := FND_API.G_RET_STS_ERROR;
2266: FND_MSG_PUB.Count_And_Get
2267: ( p_count => x_msg_count,
2268: p_data => x_msg_data
2269: );
2270: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2273: FND_MSG_PUB.Count_And_Get

2269: );
2270: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2271: ROLLBACK TO Update_ServiceRequest_PUB;
2272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2273: FND_MSG_PUB.Count_And_Get
2274: ( p_count => x_msg_count,
2275: p_data => x_msg_data
2276: );
2277: WHEN OTHERS THEN

Line 2280: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2276: );
2277: WHEN OTHERS THEN
2278: ROLLBACK TO Update_ServiceRequest_PUB;
2279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2280: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2281: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2282: END IF;
2283: FND_MSG_PUB.Count_And_Get
2284: ( p_count => x_msg_count,

Line 2281: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

2277: WHEN OTHERS THEN
2278: ROLLBACK TO Update_ServiceRequest_PUB;
2279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2280: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2281: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2282: END IF;
2283: FND_MSG_PUB.Count_And_Get
2284: ( p_count => x_msg_count,
2285: p_data => x_msg_data

Line 2283: FND_MSG_PUB.Count_And_Get

2279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2280: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2281: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2282: END IF;
2283: FND_MSG_PUB.Count_And_Get
2284: ( p_count => x_msg_count,
2285: p_data => x_msg_data
2286: );
2287:

Line 2394: FND_MSG_PUB.Initialize;

2390: --BUG 3630159:
2391: --Added to clear message cache in case of API call wrong version.
2392: -- Initialize message list if p_init_msg_list is set to TRUE
2393: IF FND_API.To_Boolean(p_init_msg_list) THEN
2394: FND_MSG_PUB.Initialize;
2395: END IF;
2396:
2397: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2398: -- Support for previous version, 3.0, not required as overloaded procedure supports that version --anmukher --08/12/03

Line 2501: FND_MSG_PUB.ADD_DETAIL

2497: FND_MESSAGE.set_token
2498: ( 'API_NAME'
2499: , 'CS_SERVICEREQUEST_PUB.update_servicerequest'
2500: );
2501: FND_MSG_PUB.ADD_DETAIL
2502: ( p_associated_column1 => 'CS_INCIDENTS_ALL_B.ITEM_SERIAL_NUMBER'
2503: );
2504: RAISE FND_API.G_EXC_ERROR;
2505: END IF;

Line 2805: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2801: END IF;
2802:
2803:
2804: IF l_key_flex_code IS NULL THEN
2805: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2806: FND_MESSAGE.Set_Name('FND', 'PROFILES-CANNOT READ');
2807: FND_MESSAGE.Set_Token('OPTION', 'CS_ID_FLEX_CODE');
2808: FND_MESSAGE.Set_Token('ROUTINE', l_api_name_full);
2809: FND_MSG_PUB.Add;

Line 2809: FND_MSG_PUB.Add;

2805: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2806: FND_MESSAGE.Set_Name('FND', 'PROFILES-CANNOT READ');
2807: FND_MESSAGE.Set_Token('OPTION', 'CS_ID_FLEX_CODE');
2808: FND_MESSAGE.Set_Token('ROUTINE', l_api_name_full);
2809: FND_MSG_PUB.Add;
2810: END IF;
2811: RAISE FND_API.G_EXC_ERROR;
2812: END IF;
2813:

Line 3283: FND_MSG_PUB.Count_And_Get

3279: COMMIT WORK;
3280: END IF;
3281:
3282: -- Standard call to get message count and if count is 1, get message info
3283: FND_MSG_PUB.Count_And_Get
3284: ( p_count => x_msg_count,
3285: p_data => x_msg_data
3286: );
3287:

Line 3292: FND_MSG_PUB.Count_And_Get

3288: EXCEPTION
3289: WHEN FND_API.G_EXC_ERROR THEN
3290: ROLLBACK TO Update_ServiceRequest_PUB;
3291: x_return_status := FND_API.G_RET_STS_ERROR;
3292: FND_MSG_PUB.Count_And_Get
3293: ( p_count => x_msg_count,
3294: p_data => x_msg_data
3295: );
3296: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3299: FND_MSG_PUB.Count_And_Get

3295: );
3296: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3297: ROLLBACK TO Update_ServiceRequest_PUB;
3298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3299: FND_MSG_PUB.Count_And_Get
3300: ( p_count => x_msg_count,
3301: p_data => x_msg_data
3302: );
3303: WHEN OTHERS THEN

Line 3306: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3302: );
3303: WHEN OTHERS THEN
3304: ROLLBACK TO Update_ServiceRequest_PUB;
3305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3306: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3307: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3308: END IF;
3309: FND_MSG_PUB.Count_And_Get
3310: ( p_count => x_msg_count,

Line 3307: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

3303: WHEN OTHERS THEN
3304: ROLLBACK TO Update_ServiceRequest_PUB;
3305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3306: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3307: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3308: END IF;
3309: FND_MSG_PUB.Count_And_Get
3310: ( p_count => x_msg_count,
3311: p_data => x_msg_data

Line 3309: FND_MSG_PUB.Count_And_Get

3305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3306: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3307: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3308: END IF;
3309: FND_MSG_PUB.Count_And_Get
3310: ( p_count => x_msg_count,
3311: p_data => x_msg_data
3312: );
3313:

Line 3375: FND_MSG_PUB.Initialize;

3371: --BUG 3630159:
3372: --Added to clear message cache in case of API call wrong version.
3373: -- Initialize message list if p_init_msg_list is set to TRUE
3374: IF FND_API.To_Boolean(p_init_msg_list) THEN
3375: FND_MSG_PUB.Initialize;
3376: END IF;
3377:
3378: -- Check version number
3379: IF NOT FND_API.Compatible_API_Call( l_api_version,

Line 3588: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

3584: IF FND_API.To_Boolean( p_commit ) THEN
3585: COMMIT WORK;
3586: END IF;
3587:
3588: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
3589: p_data => x_msg_data );
3590:
3591: EXCEPTION
3592: WHEN FND_API.G_EXC_ERROR THEN

Line 3595: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

3591: EXCEPTION
3592: WHEN FND_API.G_EXC_ERROR THEN
3593: ROLLBACK TO Update_Status_PUB;
3594: x_return_status := FND_API.G_RET_STS_ERROR;
3595: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
3596: p_data => x_msg_data );
3597:
3598: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3599: ROLLBACK TO Update_Status_PUB;

Line 3601: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

3597:
3598: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3599: ROLLBACK TO Update_Status_PUB;
3600: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3601: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
3602: p_data => x_msg_data );
3603:
3604: WHEN OTHERS THEN
3605: ROLLBACK TO Update_Status_PUB;

Line 3607: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3603:
3604: WHEN OTHERS THEN
3605: ROLLBACK TO Update_Status_PUB;
3606: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3607: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3608: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
3609: l_api_name );
3610: END IF;
3611: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

Line 3608: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,

3604: WHEN OTHERS THEN
3605: ROLLBACK TO Update_Status_PUB;
3606: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3607: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3608: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
3609: l_api_name );
3610: END IF;
3611: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
3612: p_data => x_msg_data );

Line 3611: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

3607: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3608: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
3609: l_api_name );
3610: END IF;
3611: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
3612: p_data => x_msg_data );
3613:
3614: END Update_Status;
3615:

Line 3733: FND_MSG_PUB.Initialize;

3729: --BUG 3630159:
3730: --Added to clear message cache in case of API call wrong version.
3731: -- Initialize message list if p_init_msg_list is set to TRUE
3732: IF FND_API.To_Boolean(p_init_msg_list) THEN
3733: FND_MSG_PUB.Initialize;
3734: END IF;
3735:
3736: -- Check version number
3737: IF NOT FND_API.Compatible_API_Call( l_api_version,

Line 3917: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

3913: IF FND_API.To_Boolean( p_commit ) THEN
3914: COMMIT WORK;
3915: END IF;
3916:
3917: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
3918: p_data => x_msg_data );
3919:
3920: EXCEPTION
3921: WHEN FND_API.G_EXC_ERROR THEN

Line 3924: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

3920: EXCEPTION
3921: WHEN FND_API.G_EXC_ERROR THEN
3922: ROLLBACK TO Update_Owner_PUB;
3923: x_return_status := FND_API.G_RET_STS_ERROR;
3924: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
3925: p_data => x_msg_data );
3926:
3927: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3928: ROLLBACK TO Update_Owner_PUB;

Line 3930: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

3926:
3927: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3928: ROLLBACK TO Update_Owner_PUB;
3929: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3930: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
3931: p_data => x_msg_data );
3932:
3933: WHEN OTHERS THEN
3934: ROLLBACK TO Update_Owner_PUB;

Line 3936: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3932:
3933: WHEN OTHERS THEN
3934: ROLLBACK TO Update_Owner_PUB;
3935: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3936: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3937: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
3938: l_api_name );
3939: END IF;
3940: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

Line 3937: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,

3933: WHEN OTHERS THEN
3934: ROLLBACK TO Update_Owner_PUB;
3935: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3936: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3937: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
3938: l_api_name );
3939: END IF;
3940: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
3941: p_data => x_msg_data );

Line 3940: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

3936: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3937: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
3938: l_api_name );
3939: END IF;
3940: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
3941: p_data => x_msg_data );
3942:
3943: END Update_Owner;
3944:

Line 4638: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN

4634: BEGIN
4635: IF (p_str <> FND_API.G_MISS_CHAR) THEN
4636: l_len := LENGTHB(p_str);
4637: IF (l_len > p_len) THEN
4638: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
4639: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_VALUE_TRUNCATED');
4640: FND_MESSAGE.Set_Token('API_NAME', p_api_name);
4641: FND_MESSAGE.Set_Token('TRUNCATED_PARAM', p_parameter_name);
4642: FND_MESSAGE.Set_Token('VAL_LEN', l_len);

Line 4644: FND_MSG_PUB.Add;

4640: FND_MESSAGE.Set_Token('API_NAME', p_api_name);
4641: FND_MESSAGE.Set_Token('TRUNCATED_PARAM', p_parameter_name);
4642: FND_MESSAGE.Set_Token('VAL_LEN', l_len);
4643: FND_MESSAGE.Set_Token('DB_LEN', p_len);
4644: FND_MSG_PUB.Add;
4645: END IF;
4646: p_str_out := SUBSTRB(p_str, 1, p_len);
4647: ELSE
4648: p_str_out := p_str;

Line 4863: FND_MSG_PUB.Initialize;

4859: --BUG 3630159:
4860: --Added to clear message cache in case of API call wrong version.
4861: -- Initialize message list if p_init_msg_list is set to TRUE
4862: IF FND_API.To_Boolean(p_init_msg_list) THEN
4863: FND_MSG_PUB.Initialize;
4864: END IF;
4865:
4866: --3630159 -- 30th June, 2004 -- Added to conform to public API coding standards
4867: IF NOT FND_API.Compatible_API_Call

Line 4918: FND_MSG_PUB.Count_And_Get

4914: EXCEPTION
4915: WHEN FND_API.G_EXC_ERROR
4916: THEN
4917: x_return_status := FND_API.G_RET_STS_ERROR;
4918: FND_MSG_PUB.Count_And_Get
4919: (
4920: p_count => x_msg_count,
4921: p_data => x_msg_data
4922: );

Line 4926: FND_MSG_PUB.Count_And_Get

4922: );
4923: WHEN OTHERS
4924: THEN
4925: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4926: FND_MSG_PUB.Count_And_Get
4927: (
4928: p_count => x_msg_count,
4929: p_data => x_msg_data
4930: );

Line 4972: FND_MSG_PUB.Initialize;

4968: --BUG 3630159:
4969: --Added to clear message cache in case of API call wrong version.
4970: -- Initialize message list if p_init_msg_list is set to TRUE
4971: IF FND_API.To_Boolean(p_init_msg_list) THEN
4972: FND_MSG_PUB.Initialize;
4973: END IF;
4974:
4975: --3630159 -- 30th June, 2004 -- Added to conform to public API coding standards
4976: IF NOT FND_API.Compatible_API_Call

Line 4993: fnd_msg_pub.add;

4989: fnd_message.set_name('CS', 'CS_API_ALL_INVALID_ARGUMENT');
4990: fnd_message.set_token('API_NAME', l_api_name_full);
4991: fnd_message.set_token('VALUE', p_is_solution_true);
4992: fnd_message.set_token('PARAMETER', 'p_is_solution_true');
4993: fnd_msg_pub.add;
4994: RETURN;
4995: end if;
4996:
4997: -- Set up the link record

Line 5036: FND_MSG_PUB.Count_And_Get

5032: --3630159 - 30th June, 2004 -- Handled errors should return status 'E'
5033: WHEN FND_API.G_EXC_ERROR
5034: THEN
5035: x_return_status := FND_API.G_RET_STS_ERROR;
5036: FND_MSG_PUB.Count_And_Get
5037: (
5038: p_count => x_msg_count,
5039: p_data => x_msg_data
5040: );

Line 5045: fnd_msg_pub.add;

5041: when others then
5042: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5043: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
5044: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
5045: fnd_msg_pub.add;
5046:
5047: END Link_KB_Solution;
5048:
5049: /* This is a overloaded procedure for create service request which is mainly

Line 5096: FND_MSG_PUB.Initialize;

5092: --BUG 3630159:
5093: --Added to clear message cache in case of API call wrong version.
5094: -- Initialize message list if p_init_msg_list is set to TRUE
5095: IF FND_API.To_Boolean(p_init_msg_list) THEN
5096: FND_MSG_PUB.Initialize;
5097: END IF;
5098:
5099: -- Standard call to check for call compatibility
5100: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,

Line 5147: FND_MSG_PUB.Count_And_Get

5143: EXCEPTION
5144: WHEN FND_API.G_EXC_ERROR THEN
5145: ROLLBACK TO Create_ServiceRequest_PUB;
5146: x_return_status := FND_API.G_RET_STS_ERROR;
5147: FND_MSG_PUB.Count_And_Get
5148: ( p_count => x_msg_count,
5149: p_data => x_msg_data
5150: );
5151: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 5154: FND_MSG_PUB.Count_And_Get

5150: );
5151: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5152: ROLLBACK TO Create_ServiceRequest_PUB;
5153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5154: FND_MSG_PUB.Count_And_Get
5155: ( p_count => x_msg_count,
5156: p_data => x_msg_data
5157: );
5158: WHEN OTHERS THEN

Line 5161: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

5157: );
5158: WHEN OTHERS THEN
5159: ROLLBACK TO Create_ServiceRequest_PUB;
5160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5161: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5162: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
5163: END IF;
5164: FND_MSG_PUB.Count_And_Get
5165: ( p_count => x_msg_count,

Line 5162: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

5158: WHEN OTHERS THEN
5159: ROLLBACK TO Create_ServiceRequest_PUB;
5160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5161: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5162: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
5163: END IF;
5164: FND_MSG_PUB.Count_And_Get
5165: ( p_count => x_msg_count,
5166: p_data => x_msg_data

Line 5164: FND_MSG_PUB.Count_And_Get

5160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5161: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5162: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
5163: END IF;
5164: FND_MSG_PUB.Count_And_Get
5165: ( p_count => x_msg_count,
5166: p_data => x_msg_data
5167: );
5168: