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 620: FND_MSG_PUB.Initialize;

616: --BUG 3630159:
617: --Added to clear message cache in case of API call wrong version.
618: -- Initialize message list if p_init_msg_list is set to TRUE
619: IF FND_API.To_Boolean(p_init_msg_list) THEN
620: FND_MSG_PUB.Initialize;
621: END IF;
622:
623: -- Standard call to check for call compatibility
624: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,

Line 677: FND_MSG_PUB.Count_And_Get

673: EXCEPTION
674: WHEN FND_API.G_EXC_ERROR THEN
675: ROLLBACK TO Create_ServiceRequest_PUB;
676: x_return_status := FND_API.G_RET_STS_ERROR;
677: FND_MSG_PUB.Count_And_Get
678: ( p_count => x_msg_count,
679: p_data => x_msg_data
680: );
681: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 684: FND_MSG_PUB.Count_And_Get

680: );
681: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
682: ROLLBACK TO Create_ServiceRequest_PUB;
683: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
684: FND_MSG_PUB.Count_And_Get
685: ( p_count => x_msg_count,
686: p_data => x_msg_data
687: );
688: WHEN OTHERS THEN

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

687: );
688: WHEN OTHERS THEN
689: ROLLBACK TO Create_ServiceRequest_PUB;
690: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
691: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
692: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
693: END IF;
694: FND_MSG_PUB.Count_And_Get
695: ( p_count => x_msg_count,

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

688: WHEN OTHERS THEN
689: ROLLBACK TO Create_ServiceRequest_PUB;
690: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
691: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
692: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
693: END IF;
694: FND_MSG_PUB.Count_And_Get
695: ( p_count => x_msg_count,
696: p_data => x_msg_data

Line 694: FND_MSG_PUB.Count_And_Get

690: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
691: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
692: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
693: END IF;
694: FND_MSG_PUB.Count_And_Get
695: ( p_count => x_msg_count,
696: p_data => x_msg_data
697: );
698:

Line 1112: FND_MSG_PUB.Initialize;

1108: --BUG 3630159:
1109: --Added to clear message cache in case of API call wrong version.
1110: -- Initialize message list if p_init_msg_list is set to TRUE
1111: IF FND_API.To_Boolean(p_init_msg_list) THEN
1112: FND_MSG_PUB.Initialize;
1113: END IF;
1114:
1115: -- Standard call to check for call compatibility
1116: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,

Line 1207: FND_MSG_PUB.ADD_DETAIL

1203: FND_MESSAGE.set_token
1204: ( 'API_NAME'
1205: , 'CS_SERVICEREQUEST_PUB.create_servicerequest'
1206: );
1207: FND_MSG_PUB.ADD_DETAIL
1208: ( p_associated_column1 => 'CS_INCIDENTS_ALL_B.ITEM_SERIAL_NUMBER'
1209: );
1210: RAISE FND_API.G_EXC_ERROR;
1211: END IF;

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

1422: );
1423: END IF;
1424:
1425: IF (l_key_flex_code IS NULL) THEN
1426: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1427: FND_MESSAGE.Set_Name('FND', 'PROFILES-CANNOT READ');
1428: FND_MESSAGE.Set_Token('OPTION', 'CS_ID_FLEX_CODE');
1429: FND_MESSAGE.Set_Token('ROUTINE', l_api_name_full);
1430: FND_MSG_PUB.Add;

Line 1430: FND_MSG_PUB.Add;

1426: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1427: FND_MESSAGE.Set_Name('FND', 'PROFILES-CANNOT READ');
1428: FND_MESSAGE.Set_Token('OPTION', 'CS_ID_FLEX_CODE');
1429: FND_MESSAGE.Set_Token('ROUTINE', l_api_name_full);
1430: FND_MSG_PUB.Add;
1431: END IF;
1432: RAISE FND_API.G_EXC_ERROR;
1433: END IF;
1434:

Line 2166: FND_MSG_PUB.Count_And_Get

2162: COMMIT WORK;
2163: END IF;
2164:
2165: -- Standard call to get message count and if count is 1, get message info
2166: FND_MSG_PUB.Count_And_Get
2167: ( p_count => x_msg_count,
2168: p_data => x_msg_data
2169: );
2170:

Line 2175: FND_MSG_PUB.Count_And_Get

2171: EXCEPTION
2172: WHEN FND_API.G_EXC_ERROR THEN
2173: ROLLBACK TO Create_ServiceRequest_PUB;
2174: x_return_status := FND_API.G_RET_STS_ERROR;
2175: FND_MSG_PUB.Count_And_Get
2176: ( p_count => x_msg_count,
2177: p_data => x_msg_data
2178: );
2179: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2182: FND_MSG_PUB.Count_And_Get

2178: );
2179: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2180: ROLLBACK TO Create_ServiceRequest_PUB;
2181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2182: FND_MSG_PUB.Count_And_Get
2183: ( p_count => x_msg_count,
2184: p_data => x_msg_data
2185: );
2186: WHEN OTHERS THEN

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

2185: );
2186: WHEN OTHERS THEN
2187: ROLLBACK TO Create_ServiceRequest_PUB;
2188: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2189: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2190: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2191: END IF;
2192: FND_MSG_PUB.Count_And_Get
2193: ( p_count => x_msg_count,

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

2186: WHEN OTHERS THEN
2187: ROLLBACK TO Create_ServiceRequest_PUB;
2188: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2189: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2190: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2191: END IF;
2192: FND_MSG_PUB.Count_And_Get
2193: ( p_count => x_msg_count,
2194: p_data => x_msg_data

Line 2192: FND_MSG_PUB.Count_And_Get

2188: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2189: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2190: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2191: END IF;
2192: FND_MSG_PUB.Count_And_Get
2193: ( p_count => x_msg_count,
2194: p_data => x_msg_data
2195: );
2196:

Line 2260: FND_MSG_PUB.Initialize;

2256: --BUG 3630159:
2257: --Added to clear message cache in case of API call wrong version.
2258: -- Initialize message list if p_init_msg_list is set to TRUE
2259: IF FND_API.To_Boolean(p_init_msg_list) THEN
2260: FND_MSG_PUB.Initialize;
2261: END IF;
2262:
2263: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
2264: AND NOT FND_API.Compatible_API_Call(l_api_version_back, p_api_version, l_api_name, G_PKG_NAME) THEN

Line 2317: FND_MSG_PUB.Count_And_Get

2313: COMMIT WORK;
2314: END IF;
2315:
2316: -- Standard call to get message count and if count is 1, get message info
2317: FND_MSG_PUB.Count_And_Get
2318: ( p_count => x_msg_count,
2319: p_data => x_msg_data
2320: );
2321:

Line 2326: FND_MSG_PUB.Count_And_Get

2322: EXCEPTION
2323: WHEN FND_API.G_EXC_ERROR THEN
2324: ROLLBACK TO Update_ServiceRequest_PUB;
2325: x_return_status := FND_API.G_RET_STS_ERROR;
2326: FND_MSG_PUB.Count_And_Get
2327: ( p_count => x_msg_count,
2328: p_data => x_msg_data
2329: );
2330: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2333: FND_MSG_PUB.Count_And_Get

2329: );
2330: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2331: ROLLBACK TO Update_ServiceRequest_PUB;
2332: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2333: FND_MSG_PUB.Count_And_Get
2334: ( p_count => x_msg_count,
2335: p_data => x_msg_data
2336: );
2337: WHEN OTHERS THEN

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

2336: );
2337: WHEN OTHERS THEN
2338: ROLLBACK TO Update_ServiceRequest_PUB;
2339: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2340: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2341: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2342: END IF;
2343: FND_MSG_PUB.Count_And_Get
2344: ( p_count => x_msg_count,

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

2337: WHEN OTHERS THEN
2338: ROLLBACK TO Update_ServiceRequest_PUB;
2339: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2340: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2341: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2342: END IF;
2343: FND_MSG_PUB.Count_And_Get
2344: ( p_count => x_msg_count,
2345: p_data => x_msg_data

Line 2343: FND_MSG_PUB.Count_And_Get

2339: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2340: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2341: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2342: END IF;
2343: FND_MSG_PUB.Count_And_Get
2344: ( p_count => x_msg_count,
2345: p_data => x_msg_data
2346: );
2347:

Line 2459: FND_MSG_PUB.Initialize;

2455: --BUG 3630159:
2456: --Added to clear message cache in case of API call wrong version.
2457: -- Initialize message list if p_init_msg_list is set to TRUE
2458: IF FND_API.To_Boolean(p_init_msg_list) THEN
2459: FND_MSG_PUB.Initialize;
2460: END IF;
2461:
2462: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2463: -- Support for previous version, 3.0, not required as overloaded procedure supports that version --anmukher --08/12/03

Line 2570: FND_MSG_PUB.ADD_DETAIL

2566: FND_MESSAGE.set_token
2567: ( 'API_NAME'
2568: , 'CS_SERVICEREQUEST_PUB.update_servicerequest'
2569: );
2570: FND_MSG_PUB.ADD_DETAIL
2571: ( p_associated_column1 => 'CS_INCIDENTS_ALL_B.ITEM_SERIAL_NUMBER'
2572: );
2573: RAISE FND_API.G_EXC_ERROR;
2574: END IF;

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

2870: END IF;
2871:
2872:
2873: IF l_key_flex_code IS NULL THEN
2874: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2875: FND_MESSAGE.Set_Name('FND', 'PROFILES-CANNOT READ');
2876: FND_MESSAGE.Set_Token('OPTION', 'CS_ID_FLEX_CODE');
2877: FND_MESSAGE.Set_Token('ROUTINE', l_api_name_full);
2878: FND_MSG_PUB.Add;

Line 2878: FND_MSG_PUB.Add;

2874: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2875: FND_MESSAGE.Set_Name('FND', 'PROFILES-CANNOT READ');
2876: FND_MESSAGE.Set_Token('OPTION', 'CS_ID_FLEX_CODE');
2877: FND_MESSAGE.Set_Token('ROUTINE', l_api_name_full);
2878: FND_MSG_PUB.Add;
2879: END IF;
2880: RAISE FND_API.G_EXC_ERROR;
2881: END IF;
2882:

Line 3390: FND_MSG_PUB.Count_And_Get

3386: COMMIT WORK;
3387: END IF;
3388:
3389: -- Standard call to get message count and if count is 1, get message info
3390: FND_MSG_PUB.Count_And_Get
3391: ( p_count => x_msg_count,
3392: p_data => x_msg_data
3393: );
3394:

Line 3399: FND_MSG_PUB.Count_And_Get

3395: EXCEPTION
3396: WHEN FND_API.G_EXC_ERROR THEN
3397: ROLLBACK TO Update_ServiceRequest_PUB;
3398: x_return_status := FND_API.G_RET_STS_ERROR;
3399: FND_MSG_PUB.Count_And_Get
3400: ( p_count => x_msg_count,
3401: p_data => x_msg_data
3402: );
3403: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3406: FND_MSG_PUB.Count_And_Get

3402: );
3403: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3404: ROLLBACK TO Update_ServiceRequest_PUB;
3405: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3406: FND_MSG_PUB.Count_And_Get
3407: ( p_count => x_msg_count,
3408: p_data => x_msg_data
3409: );
3410: WHEN OTHERS THEN

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

3409: );
3410: WHEN OTHERS THEN
3411: ROLLBACK TO Update_ServiceRequest_PUB;
3412: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3413: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3414: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3415: END IF;
3416: FND_MSG_PUB.Count_And_Get
3417: ( p_count => x_msg_count,

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

3410: WHEN OTHERS THEN
3411: ROLLBACK TO Update_ServiceRequest_PUB;
3412: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3413: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3414: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3415: END IF;
3416: FND_MSG_PUB.Count_And_Get
3417: ( p_count => x_msg_count,
3418: p_data => x_msg_data

Line 3416: FND_MSG_PUB.Count_And_Get

3412: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3413: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3414: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3415: END IF;
3416: FND_MSG_PUB.Count_And_Get
3417: ( p_count => x_msg_count,
3418: p_data => x_msg_data
3419: );
3420:

Line 3484: FND_MSG_PUB.Initialize;

3480: --BUG 3630159:
3481: --Added to clear message cache in case of API call wrong version.
3482: -- Initialize message list if p_init_msg_list is set to TRUE
3483: IF FND_API.To_Boolean(p_init_msg_list) THEN
3484: FND_MSG_PUB.Initialize;
3485: END IF;
3486:
3487: -- Check version number
3488: IF NOT FND_API.Compatible_API_Call( l_api_version,

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

3699: IF FND_API.To_Boolean( p_commit ) THEN
3700: COMMIT WORK;
3701: END IF;
3702:
3703: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
3704: p_data => x_msg_data );
3705:
3706: EXCEPTION
3707: WHEN FND_API.G_EXC_ERROR THEN

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

3706: EXCEPTION
3707: WHEN FND_API.G_EXC_ERROR THEN
3708: ROLLBACK TO Update_Status_PUB;
3709: x_return_status := FND_API.G_RET_STS_ERROR;
3710: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
3711: p_data => x_msg_data );
3712:
3713: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3714: ROLLBACK TO Update_Status_PUB;

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

3712:
3713: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3714: ROLLBACK TO Update_Status_PUB;
3715: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3716: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
3717: p_data => x_msg_data );
3718:
3719: WHEN OTHERS THEN
3720: ROLLBACK TO Update_Status_PUB;

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

3718:
3719: WHEN OTHERS THEN
3720: ROLLBACK TO Update_Status_PUB;
3721: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3722: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3723: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
3724: l_api_name );
3725: END IF;
3726: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

Line 3723: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,

3719: WHEN OTHERS THEN
3720: ROLLBACK TO Update_Status_PUB;
3721: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3722: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3723: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
3724: l_api_name );
3725: END IF;
3726: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
3727: p_data => x_msg_data );

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

3722: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3723: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
3724: l_api_name );
3725: END IF;
3726: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
3727: p_data => x_msg_data );
3728:
3729: END Update_Status;
3730:

Line 3848: FND_MSG_PUB.Initialize;

3844: --BUG 3630159:
3845: --Added to clear message cache in case of API call wrong version.
3846: -- Initialize message list if p_init_msg_list is set to TRUE
3847: IF FND_API.To_Boolean(p_init_msg_list) THEN
3848: FND_MSG_PUB.Initialize;
3849: END IF;
3850:
3851: -- Check version number
3852: IF NOT FND_API.Compatible_API_Call( l_api_version,

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

4028: IF FND_API.To_Boolean( p_commit ) THEN
4029: COMMIT WORK;
4030: END IF;
4031:
4032: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
4033: p_data => x_msg_data );
4034:
4035: EXCEPTION
4036: WHEN FND_API.G_EXC_ERROR THEN

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

4035: EXCEPTION
4036: WHEN FND_API.G_EXC_ERROR THEN
4037: ROLLBACK TO Update_Owner_PUB;
4038: x_return_status := FND_API.G_RET_STS_ERROR;
4039: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
4040: p_data => x_msg_data );
4041:
4042: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4043: ROLLBACK TO Update_Owner_PUB;

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

4041:
4042: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4043: ROLLBACK TO Update_Owner_PUB;
4044: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4045: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
4046: p_data => x_msg_data );
4047:
4048: WHEN OTHERS THEN
4049: ROLLBACK TO Update_Owner_PUB;

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

4047:
4048: WHEN OTHERS THEN
4049: ROLLBACK TO Update_Owner_PUB;
4050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4051: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4052: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
4053: l_api_name );
4054: END IF;
4055: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

Line 4052: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,

4048: WHEN OTHERS THEN
4049: ROLLBACK TO Update_Owner_PUB;
4050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4051: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4052: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
4053: l_api_name );
4054: END IF;
4055: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
4056: p_data => x_msg_data );

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

4051: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4052: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
4053: l_api_name );
4054: END IF;
4055: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
4056: p_data => x_msg_data );
4057:
4058: END Update_Owner;
4059:

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

4753: BEGIN
4754: IF (p_str <> FND_API.G_MISS_CHAR) THEN
4755: l_len := LENGTHB(p_str);
4756: IF (l_len > p_len) THEN
4757: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
4758: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_VALUE_TRUNCATED');
4759: FND_MESSAGE.Set_Token('API_NAME', p_api_name);
4760: FND_MESSAGE.Set_Token('TRUNCATED_PARAM', p_parameter_name);
4761: FND_MESSAGE.Set_Token('VAL_LEN', l_len);

Line 4763: FND_MSG_PUB.Add;

4759: FND_MESSAGE.Set_Token('API_NAME', p_api_name);
4760: FND_MESSAGE.Set_Token('TRUNCATED_PARAM', p_parameter_name);
4761: FND_MESSAGE.Set_Token('VAL_LEN', l_len);
4762: FND_MESSAGE.Set_Token('DB_LEN', p_len);
4763: FND_MSG_PUB.Add;
4764: END IF;
4765: p_str_out := SUBSTRB(p_str, 1, p_len);
4766: ELSE
4767: p_str_out := p_str;

Line 4982: FND_MSG_PUB.Initialize;

4978: --BUG 3630159:
4979: --Added to clear message cache in case of API call wrong version.
4980: -- Initialize message list if p_init_msg_list is set to TRUE
4981: IF FND_API.To_Boolean(p_init_msg_list) THEN
4982: FND_MSG_PUB.Initialize;
4983: END IF;
4984:
4985: --3630159 -- 30th June, 2004 -- Added to conform to public API coding standards
4986: IF NOT FND_API.Compatible_API_Call

Line 5037: FND_MSG_PUB.Count_And_Get

5033: EXCEPTION
5034: WHEN FND_API.G_EXC_ERROR
5035: THEN
5036: x_return_status := FND_API.G_RET_STS_ERROR;
5037: FND_MSG_PUB.Count_And_Get
5038: (
5039: p_count => x_msg_count,
5040: p_data => x_msg_data
5041: );

Line 5045: FND_MSG_PUB.Count_And_Get

5041: );
5042: WHEN OTHERS
5043: THEN
5044: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5045: FND_MSG_PUB.Count_And_Get
5046: (
5047: p_count => x_msg_count,
5048: p_data => x_msg_data
5049: );

Line 5091: FND_MSG_PUB.Initialize;

5087: --BUG 3630159:
5088: --Added to clear message cache in case of API call wrong version.
5089: -- Initialize message list if p_init_msg_list is set to TRUE
5090: IF FND_API.To_Boolean(p_init_msg_list) THEN
5091: FND_MSG_PUB.Initialize;
5092: END IF;
5093:
5094: --3630159 -- 30th June, 2004 -- Added to conform to public API coding standards
5095: IF NOT FND_API.Compatible_API_Call

Line 5112: fnd_msg_pub.add;

5108: fnd_message.set_name('CS', 'CS_API_ALL_INVALID_ARGUMENT');
5109: fnd_message.set_token('API_NAME', l_api_name_full);
5110: fnd_message.set_token('VALUE', p_is_solution_true);
5111: fnd_message.set_token('PARAMETER', 'p_is_solution_true');
5112: fnd_msg_pub.add;
5113: RETURN;
5114: end if;
5115:
5116: -- Set up the link record

Line 5155: FND_MSG_PUB.Count_And_Get

5151: --3630159 - 30th June, 2004 -- Handled errors should return status 'E'
5152: WHEN FND_API.G_EXC_ERROR
5153: THEN
5154: x_return_status := FND_API.G_RET_STS_ERROR;
5155: FND_MSG_PUB.Count_And_Get
5156: (
5157: p_count => x_msg_count,
5158: p_data => x_msg_data
5159: );

Line 5164: fnd_msg_pub.add;

5160: when others then
5161: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5162: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
5163: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
5164: fnd_msg_pub.add;
5165:
5166: END Link_KB_Solution;
5167:
5168: /* This is a overloaded procedure for create service request which is mainly

Line 5215: FND_MSG_PUB.Initialize;

5211: --BUG 3630159:
5212: --Added to clear message cache in case of API call wrong version.
5213: -- Initialize message list if p_init_msg_list is set to TRUE
5214: IF FND_API.To_Boolean(p_init_msg_list) THEN
5215: FND_MSG_PUB.Initialize;
5216: END IF;
5217:
5218: -- Standard call to check for call compatibility
5219: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,

Line 5266: FND_MSG_PUB.Count_And_Get

5262: EXCEPTION
5263: WHEN FND_API.G_EXC_ERROR THEN
5264: ROLLBACK TO Create_ServiceRequest_PUB;
5265: x_return_status := FND_API.G_RET_STS_ERROR;
5266: FND_MSG_PUB.Count_And_Get
5267: ( p_count => x_msg_count,
5268: p_data => x_msg_data
5269: );
5270: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 5273: FND_MSG_PUB.Count_And_Get

5269: );
5270: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5271: ROLLBACK TO Create_ServiceRequest_PUB;
5272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5273: FND_MSG_PUB.Count_And_Get
5274: ( p_count => x_msg_count,
5275: p_data => x_msg_data
5276: );
5277: WHEN OTHERS THEN

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

5276: );
5277: WHEN OTHERS THEN
5278: ROLLBACK TO Create_ServiceRequest_PUB;
5279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5280: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5281: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
5282: END IF;
5283: FND_MSG_PUB.Count_And_Get
5284: ( p_count => x_msg_count,

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

5277: WHEN OTHERS THEN
5278: ROLLBACK TO Create_ServiceRequest_PUB;
5279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5280: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5281: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
5282: END IF;
5283: FND_MSG_PUB.Count_And_Get
5284: ( p_count => x_msg_count,
5285: p_data => x_msg_data

Line 5283: FND_MSG_PUB.Count_And_Get

5279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5280: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5281: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
5282: END IF;
5283: FND_MSG_PUB.Count_And_Get
5284: ( p_count => x_msg_count,
5285: p_data => x_msg_data
5286: );
5287:

Line 6900: FND_MSG_PUB.Count_And_Get

6896:
6897: EXCEPTION
6898: WHEN FND_API.G_EXC_ERROR THEN
6899: x_return_status := FND_API.G_RET_STS_ERROR;
6900: FND_MSG_PUB.Count_And_Get
6901: ( p_count => x_msg_count,
6902: p_data => x_msg_data
6903: );
6904: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 6906: FND_MSG_PUB.Count_And_Get

6902: p_data => x_msg_data
6903: );
6904: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6905: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6906: FND_MSG_PUB.Count_And_Get
6907: ( p_count => x_msg_count,
6908: p_data => x_msg_data
6909: );
6910: WHEN OTHERS THEN

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

6908: p_data => x_msg_data
6909: );
6910: WHEN OTHERS THEN
6911: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6912: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6913: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
6914: END IF;
6915: FND_MSG_PUB.Count_And_Get
6916: ( p_count => x_msg_count,

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

6909: );
6910: WHEN OTHERS THEN
6911: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6912: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6913: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
6914: END IF;
6915: FND_MSG_PUB.Count_And_Get
6916: ( p_count => x_msg_count,
6917: p_data => x_msg_data

Line 6915: FND_MSG_PUB.Count_And_Get

6911: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6912: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6913: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
6914: END IF;
6915: FND_MSG_PUB.Count_And_Get
6916: ( p_count => x_msg_count,
6917: p_data => x_msg_data
6918: );
6919: