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.AMS_LIST_ENTRIES_PVT dependencies on FND_MSG_PUB

Line 21: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);

17: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_List_Entries_PVT';
18: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amsvlieb.pls';
19:
20:
21: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
22: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
23: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
24:
25: PROCEDURE Complete_list_entries_Rec (

Line 22: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

18: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amsvlieb.pls';
19:
20:
21: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
22: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
23: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
24:
25: PROCEDURE Complete_list_entries_Rec (
26: P_list_entries_rec IN list_entries_rec_type,

Line 23: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);

19:
20:
21: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
22: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
23: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
24:
25: PROCEDURE Complete_list_entries_Rec (
26: P_list_entries_rec IN list_entries_rec_type,
27: x_complete_rec OUT NOCOPY list_entries_rec_type

Line 432: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

428: OPEN c_listentries;
429: FETCH c_listentries INTO l_listentries_rec;
430: IF c_listentries%NOTFOUND THEN
431: CLOSE c_listentries;
432: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
433: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
434: FND_MSG_PUB.add;
435: END IF;
436: RAISE FND_API.g_exc_error;

Line 434: FND_MSG_PUB.add;

430: IF c_listentries%NOTFOUND THEN
431: CLOSE c_listentries;
432: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
433: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
434: FND_MSG_PUB.add;
435: END IF;
436: RAISE FND_API.g_exc_error;
437: END IF;
438: CLOSE c_listentries;

Line 1908: FND_MSG_PUB.initialize;

1904:
1905: -- Initialize message list if p_init_msg_list is set to TRUE.
1906: IF FND_API.to_Boolean( p_init_msg_list )
1907: THEN
1908: FND_MSG_PUB.initialize;
1909: END IF;
1910:
1911: -- Debug Message
1912: IF (AMS_DEBUG_HIGH_ON) THEN

Line 2403: FND_MSG_PUB.Count_And_Get

2399: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
2400: END IF;
2401:
2402: -- Standard call to get message count and if count is 1, get message info.
2403: FND_MSG_PUB.Count_And_Get
2404: (p_count => x_msg_count,
2405: p_data => x_msg_data
2406: );
2407: EXCEPTION

Line 2417: FND_MSG_PUB.Count_And_Get (

2413: WHEN FND_API.G_EXC_ERROR THEN
2414: ROLLBACK TO CREATE_List_Entries_PVT;
2415: x_return_status := FND_API.G_RET_STS_ERROR;
2416: -- Standard call to get message count and if count=1, get the message
2417: FND_MSG_PUB.Count_And_Get (
2418: p_encoded => FND_API.G_FALSE,
2419: p_count => x_msg_count,
2420: p_data => x_msg_data
2421: );

Line 2427: FND_MSG_PUB.Count_And_Get (

2423: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2424: ROLLBACK TO CREATE_List_Entries_PVT;
2425: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2426: -- Standard call to get message count and if count=1, get the message
2427: FND_MSG_PUB.Count_And_Get (
2428: p_encoded => FND_API.G_FALSE,
2429: p_count => x_msg_count,
2430: p_data => x_msg_data
2431: );

Line 2436: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2432:
2433: WHEN OTHERS THEN
2434: ROLLBACK TO CREATE_List_Entries_PVT;
2435: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2436: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2437: THEN
2438: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2439: END IF;
2440: -- Standard call to get message count and if count=1, get the message

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

2434: ROLLBACK TO CREATE_List_Entries_PVT;
2435: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2436: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2437: THEN
2438: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2439: END IF;
2440: -- Standard call to get message count and if count=1, get the message
2441: FND_MSG_PUB.Count_And_Get (
2442: p_encoded => FND_API.G_FALSE,

Line 2441: FND_MSG_PUB.Count_And_Get (

2437: THEN
2438: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2439: END IF;
2440: -- Standard call to get message count and if count=1, get the message
2441: FND_MSG_PUB.Count_And_Get (
2442: p_encoded => FND_API.G_FALSE,
2443: p_count => x_msg_count,
2444: p_data => x_msg_data
2445: );

Line 2499: FND_MSG_PUB.initialize;

2495:
2496: -- Initialize message list if p_init_msg_list is set to TRUE.
2497: IF FND_API.to_Boolean( p_init_msg_list )
2498: THEN
2499: FND_MSG_PUB.initialize;
2500: END IF;
2501:
2502: -- Debug Message
2503: IF (AMS_DEBUG_HIGH_ON) THEN

Line 2993: FND_MSG_PUB.Count_And_Get

2989: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
2990: END IF;
2991:
2992: -- Standard call to get message count and if count is 1, get message info.
2993: FND_MSG_PUB.Count_And_Get
2994: (p_count => x_msg_count,
2995: p_data => x_msg_data
2996: );
2997: EXCEPTION

Line 3007: FND_MSG_PUB.Count_And_Get (

3003: WHEN FND_API.G_EXC_ERROR THEN
3004: ROLLBACK TO UPDATE_List_Entries_PVT;
3005: x_return_status := FND_API.G_RET_STS_ERROR;
3006: -- Standard call to get message count and if count=1, get the message
3007: FND_MSG_PUB.Count_And_Get (
3008: p_encoded => FND_API.G_FALSE,
3009: p_count => x_msg_count,
3010: p_data => x_msg_data
3011: );

Line 3017: FND_MSG_PUB.Count_And_Get (

3013: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3014: ROLLBACK TO UPDATE_List_Entries_PVT;
3015: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3016: -- Standard call to get message count and if count=1, get the message
3017: FND_MSG_PUB.Count_And_Get (
3018: p_encoded => FND_API.G_FALSE,
3019: p_count => x_msg_count,
3020: p_data => x_msg_data
3021: );

Line 3026: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3022:
3023: WHEN OTHERS THEN
3024: ROLLBACK TO UPDATE_List_Entries_PVT;
3025: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3026: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3027: THEN
3028: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3029: END IF;
3030: -- Standard call to get message count and if count=1, get the message

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

3024: ROLLBACK TO UPDATE_List_Entries_PVT;
3025: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3026: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3027: THEN
3028: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3029: END IF;
3030: -- Standard call to get message count and if count=1, get the message
3031: FND_MSG_PUB.Count_And_Get (
3032: p_encoded => FND_API.G_FALSE,

Line 3031: FND_MSG_PUB.Count_And_Get (

3027: THEN
3028: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3029: END IF;
3030: -- Standard call to get message count and if count=1, get the message
3031: FND_MSG_PUB.Count_And_Get (
3032: p_encoded => FND_API.G_FALSE,
3033: p_count => x_msg_count,
3034: p_data => x_msg_data
3035: );

Line 3072: FND_MSG_PUB.initialize;

3068:
3069: -- Initialize message list if p_init_msg_list is set to TRUE.
3070: IF FND_API.to_Boolean( p_init_msg_list )
3071: THEN
3072: FND_MSG_PUB.initialize;
3073: END IF;
3074:
3075: -- Debug Message
3076: IF (AMS_DEBUG_HIGH_ON) THEN

Line 3115: FND_MSG_PUB.Count_And_Get

3111: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
3112: END IF;
3113:
3114: -- Standard call to get message count and if count is 1, get message info.
3115: FND_MSG_PUB.Count_And_Get
3116: (p_count => x_msg_count,
3117: p_data => x_msg_data
3118: );
3119: EXCEPTION

Line 3129: FND_MSG_PUB.Count_And_Get (

3125: WHEN FND_API.G_EXC_ERROR THEN
3126: ROLLBACK TO DELETE_List_Entries_PVT;
3127: x_return_status := FND_API.G_RET_STS_ERROR;
3128: -- Standard call to get message count and if count=1, get the message
3129: FND_MSG_PUB.Count_And_Get (
3130: p_encoded => FND_API.G_FALSE,
3131: p_count => x_msg_count,
3132: p_data => x_msg_data
3133: );

Line 3139: FND_MSG_PUB.Count_And_Get (

3135: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3136: ROLLBACK TO DELETE_List_Entries_PVT;
3137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3138: -- Standard call to get message count and if count=1, get the message
3139: FND_MSG_PUB.Count_And_Get (
3140: p_encoded => FND_API.G_FALSE,
3141: p_count => x_msg_count,
3142: p_data => x_msg_data
3143: );

Line 3148: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3144:
3145: WHEN OTHERS THEN
3146: ROLLBACK TO DELETE_List_Entries_PVT;
3147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3148: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3149: THEN
3150: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3151: END IF;
3152: -- Standard call to get message count and if count=1, get the message

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

3146: ROLLBACK TO DELETE_List_Entries_PVT;
3147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3148: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3149: THEN
3150: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3151: END IF;
3152: -- Standard call to get message count and if count=1, get the message
3153: FND_MSG_PUB.Count_And_Get (
3154: p_encoded => FND_API.G_FALSE,

Line 3153: FND_MSG_PUB.Count_And_Get (

3149: THEN
3150: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3151: END IF;
3152: -- Standard call to get message count and if count=1, get the message
3153: FND_MSG_PUB.Count_And_Get (
3154: p_encoded => FND_API.G_FALSE,
3155: p_count => x_msg_count,
3156: p_data => x_msg_data
3157: );

Line 3199: FND_MSG_PUB.initialize;

3195:
3196: -- Initialize message list if p_init_msg_list is set to TRUE.
3197: IF FND_API.to_Boolean( p_init_msg_list )
3198: THEN
3199: FND_MSG_PUB.initialize;
3200: END IF;
3201:
3202: -- Standard call to check for call compatibility.
3203: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 3231: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

3227: FETCH c_List_Entries INTO l_LIST_ENTRY_ID;
3228:
3229: IF (c_List_Entries%NOTFOUND) THEN
3230: CLOSE c_List_Entries;
3231: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3232: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
3233: FND_MSG_PUB.add;
3234: END IF;
3235: RAISE FND_API.g_exc_error;

Line 3233: FND_MSG_PUB.add;

3229: IF (c_List_Entries%NOTFOUND) THEN
3230: CLOSE c_List_Entries;
3231: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3232: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
3233: FND_MSG_PUB.add;
3234: END IF;
3235: RAISE FND_API.g_exc_error;
3236: END IF;
3237:

Line 3241: FND_MSG_PUB.count_and_get(

3237:
3238: CLOSE c_List_Entries;
3239:
3240: -------------------- finish --------------------------
3241: FND_MSG_PUB.count_and_get(
3242: p_encoded => FND_API.g_false,
3243: p_count => x_msg_count,
3244: p_data => x_msg_data);
3245: IF (AMS_DEBUG_HIGH_ON) THEN

Line 3259: FND_MSG_PUB.Count_And_Get (

3255: WHEN FND_API.G_EXC_ERROR THEN
3256: ROLLBACK TO LOCK_List_Entries_PVT;
3257: x_return_status := FND_API.G_RET_STS_ERROR;
3258: -- Standard call to get message count and if count=1, get the message
3259: FND_MSG_PUB.Count_And_Get (
3260: p_encoded => FND_API.G_FALSE,
3261: p_count => x_msg_count,
3262: p_data => x_msg_data
3263: );

Line 3269: FND_MSG_PUB.Count_And_Get (

3265: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3266: ROLLBACK TO LOCK_List_Entries_PVT;
3267: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3268: -- Standard call to get message count and if count=1, get the message
3269: FND_MSG_PUB.Count_And_Get (
3270: p_encoded => FND_API.G_FALSE,
3271: p_count => x_msg_count,
3272: p_data => x_msg_data
3273: );

Line 3278: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3274:
3275: WHEN OTHERS THEN
3276: ROLLBACK TO LOCK_List_Entries_PVT;
3277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3278: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3279: THEN
3280: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3281: END IF;
3282: -- Standard call to get message count and if count=1, get the message

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

3276: ROLLBACK TO LOCK_List_Entries_PVT;
3277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3278: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3279: THEN
3280: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3281: END IF;
3282: -- Standard call to get message count and if count=1, get the message
3283: FND_MSG_PUB.Count_And_Get (
3284: p_encoded => FND_API.G_FALSE,

Line 3283: FND_MSG_PUB.Count_And_Get (

3279: THEN
3280: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3281: END IF;
3282: -- Standard call to get message count and if count=1, get the message
3283: FND_MSG_PUB.Count_And_Get (
3284: p_encoded => FND_API.G_FALSE,
3285: p_count => x_msg_count,
3286: p_data => x_msg_data
3287: );

Line 3843: FND_MSG_PUB.initialize;

3839:
3840: -- Initialize message list if p_init_msg_list is set to TRUE.
3841: IF FND_API.to_Boolean( p_init_msg_list )
3842: THEN
3843: FND_MSG_PUB.initialize;
3844: END IF;
3845: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
3846: Check_list_entries_Items(
3847: p_list_entries_rec => p_list_entries_rec,

Line 3899: FND_MSG_PUB.Count_And_Get

3895: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
3896: END IF;
3897:
3898: -- Standard call to get message count and if count is 1, get message info.
3899: FND_MSG_PUB.Count_And_Get
3900: (p_count => x_msg_count,
3901: p_data => x_msg_data
3902: );
3903: EXCEPTION

Line 3913: FND_MSG_PUB.Count_And_Get (

3909: WHEN FND_API.G_EXC_ERROR THEN
3910: ROLLBACK TO VALIDATE_List_Entries_;
3911: x_return_status := FND_API.G_RET_STS_ERROR;
3912: -- Standard call to get message count and if count=1, get the message
3913: FND_MSG_PUB.Count_And_Get (
3914: p_encoded => FND_API.G_FALSE,
3915: p_count => x_msg_count,
3916: p_data => x_msg_data
3917: );

Line 3923: FND_MSG_PUB.Count_And_Get (

3919: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3920: ROLLBACK TO VALIDATE_List_Entries_;
3921: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3922: -- Standard call to get message count and if count=1, get the message
3923: FND_MSG_PUB.Count_And_Get (
3924: p_encoded => FND_API.G_FALSE,
3925: p_count => x_msg_count,
3926: p_data => x_msg_data
3927: );

Line 3932: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3928:
3929: WHEN OTHERS THEN
3930: ROLLBACK TO VALIDATE_List_Entries_;
3931: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3932: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3933: THEN
3934: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3935: END IF;
3936: -- Standard call to get message count and if count=1, get the message

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

3930: ROLLBACK TO VALIDATE_List_Entries_;
3931: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3932: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3933: THEN
3934: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3935: END IF;
3936: -- Standard call to get message count and if count=1, get the message
3937: FND_MSG_PUB.Count_And_Get (
3938: p_encoded => FND_API.G_FALSE,

Line 3937: FND_MSG_PUB.Count_And_Get (

3933: THEN
3934: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3935: END IF;
3936: -- Standard call to get message count and if count=1, get the message
3937: FND_MSG_PUB.Count_And_Get (
3938: p_encoded => FND_API.G_FALSE,
3939: p_count => x_msg_count,
3940: p_data => x_msg_data
3941: );

Line 3958: FND_MSG_PUB.initialize;

3954: BEGIN
3955: -- Initialize message list if p_init_msg_list is set to TRUE.
3956: IF FND_API.to_Boolean( p_init_msg_list )
3957: THEN
3958: FND_MSG_PUB.initialize;
3959: END IF;
3960:
3961: -- Initialize API return status to SUCCESS
3962: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3975: FND_MSG_PUB.Count_And_Get

3971:
3972: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
3973: END IF;
3974: -- Standard call to get message count and if count is 1, get message info.
3975: FND_MSG_PUB.Count_And_Get
3976: (p_count => x_msg_count,
3977: p_data => x_msg_data
3978: );
3979: END Validate_list_entries_Rec;

Line 4430: FND_MSG_PUB.initialize;

4426:
4427:
4428: -- Initialize message list IF p_init_msg_list is set to TRUE.
4429: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4430: FND_MSG_PUB.initialize;
4431: END IF;
4432:
4433: -- Debug Message
4434: IF (AMS_DEBUG_HIGH_ON) THEN

Line 4437: FND_MSG_PUB.Add;

4433: -- Debug Message
4434: IF (AMS_DEBUG_HIGH_ON) THEN
4435: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
4436: FND_MESSAGE.Set_Token('ROW', 'AMS_ListHeaders_PVT.Copy_List_Entries: Start', TRUE);
4437: FND_MSG_PUB.Add;
4438: END IF;
4439:
4440: -- Initialize API return status to success
4441: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5195: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)

5191: COMMIT WORK;
5192: END IF;
5193:
5194: -- Success Message
5195: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
5196: THEN
5197: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
5198: FND_MESSAGE.Set_Token('ROW', 'AMS_listheaders_PVT.Copy_List_Entries', TRUE);
5199: FND_MSG_PUB.Add;

Line 5199: FND_MSG_PUB.Add;

5195: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
5196: THEN
5197: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
5198: FND_MESSAGE.Set_Token('ROW', 'AMS_listheaders_PVT.Copy_List_Entries', TRUE);
5199: FND_MSG_PUB.Add;
5200: END IF;
5201:
5202: IF (AMS_DEBUG_HIGH_ON) THEN
5203: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');

Line 5205: FND_MSG_PUB.Add;

5201:
5202: IF (AMS_DEBUG_HIGH_ON) THEN
5203: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
5204: FND_MESSAGE.Set_Token('ROW', 'AMS_listheaders_PVT.Copy_List_Entries: END', TRUE);
5205: FND_MSG_PUB.Add;
5206: END IF;
5207:
5208:
5209: -- Standard call to get message count AND IF count is 1, get message info.

Line 5210: FND_MSG_PUB.Count_AND_Get

5206: END IF;
5207:
5208:
5209: -- Standard call to get message count AND IF count is 1, get message info.
5210: FND_MSG_PUB.Count_AND_Get
5211: ( p_count => x_msg_count,
5212: p_data => x_msg_data,
5213: p_encoded => FND_API.G_FALSE
5214: );

Line 5221: FND_MSG_PUB.Count_AND_Get

5217: WHEN FND_API.G_EXC_ERROR THEN
5218: ROLLBACK TO Copy_List_Entries_PVT;
5219: x_return_status := FND_API.G_RET_STS_ERROR ;
5220:
5221: FND_MSG_PUB.Count_AND_Get
5222: ( p_count => x_msg_count,
5223: p_data => x_msg_data,
5224: p_encoded => FND_API.G_FALSE
5225: );

Line 5231: FND_MSG_PUB.Count_AND_Get

5227:
5228: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5229: ROLLBACK TO Copy_List_Entries_PVT;
5230: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5231: FND_MSG_PUB.Count_AND_Get
5232: ( p_count => x_msg_count,
5233: p_data => x_msg_data,
5234: p_encoded => FND_API.G_FALSE
5235: );

Line 5240: FND_MSG_PUB.Add;

5236:
5237: WHEN OTHERS THEN
5238: ROLLBACK TO Copy_List_Entries_PVT;
5239: FND_MESSAGE.set_name('AMS','SQL ERROR ->' || sqlerrm );
5240: FND_MSG_PUB.Add;
5241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5242: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
5243: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5244: END IF;

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

5238: ROLLBACK TO Copy_List_Entries_PVT;
5239: FND_MESSAGE.set_name('AMS','SQL ERROR ->' || sqlerrm );
5240: FND_MSG_PUB.Add;
5241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5242: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
5243: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5244: END IF;
5245:
5246: FND_MSG_PUB.Count_AND_Get

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

5239: FND_MESSAGE.set_name('AMS','SQL ERROR ->' || sqlerrm );
5240: FND_MSG_PUB.Add;
5241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5242: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
5243: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5244: END IF;
5245:
5246: FND_MSG_PUB.Count_AND_Get
5247: ( p_count => x_msg_count,

Line 5246: FND_MSG_PUB.Count_AND_Get

5242: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
5243: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5244: END IF;
5245:
5246: FND_MSG_PUB.Count_AND_Get
5247: ( p_count => x_msg_count,
5248: p_data => x_msg_data,
5249: p_encoded => FND_API.G_FALSE
5250: );