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_IBA_PLCMNT_PVT dependencies on AMS_UTILITY_PVT

Line 95: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

91:
92: -- Debug Message
93: IF (AMS_DEBUG_HIGH_ON) THEN
94:
95: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
96: END IF;
97:
98:
99: -- Initialize API return status to SUCCESS

Line 141: AMS_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

137: -- =========================================================================
138:
139: IF FND_GLOBAL.User_Id IS NULL
140: THEN
141: AMS_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
142: RAISE FND_API.G_EXC_ERROR;
143: END IF;
144:
145: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)

Line 150: AMS_UTILITY_PVT.debug_message('Private API: Validate_Iba_Plcmnt');

146: THEN
147: -- Debug message
148: IF (AMS_DEBUG_HIGH_ON) THEN
149:
150: AMS_UTILITY_PVT.debug_message('Private API: Validate_Iba_Plcmnt');
151: END IF;
152:
153: -- Invoke validation procedures
154: IF (AMS_DEBUG_HIGH_ON) THEN

Line 156: AMS_UTILITY_PVT.debug_message('In Create_Iba_Plcmnt: before Validate_iba_plcmnt call ' );

152:
153: -- Invoke validation procedures
154: IF (AMS_DEBUG_HIGH_ON) THEN
155:
156: AMS_UTILITY_PVT.debug_message('In Create_Iba_Plcmnt: before Validate_iba_plcmnt call ' );
157: END IF;
158: Validate_iba_plcmnt(
159: p_api_version_number => 1.0
160: , p_init_msg_list => FND_API.G_FALSE

Line 178: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');

174:
175: -- Debug Message
176: IF (AMS_DEBUG_HIGH_ON) THEN
177:
178: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
179: END IF;
180:
181: -- Invoke table handler(AMS_IBA_PL_PLACEMENTS_B_PKG.Insert_Row)
182: AMS_IBA_PL_PLACEMENTS_B_PKG.Insert_Row(

Line 224: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

220:
221: -- Debug Message
222: IF (AMS_DEBUG_HIGH_ON) THEN
223:
224: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
225: END IF;
226:
227: -- Standard call to get message count and if count is 1, get message info.
228: FND_MSG_PUB.Count_And_Get

Line 234: WHEN AMS_Utility_PVT.resource_locked THEN

230: p_data => x_msg_data
231: );
232: EXCEPTION
233:
234: WHEN AMS_Utility_PVT.resource_locked THEN
235: x_return_status := FND_API.g_ret_sts_error;
236: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
237:
238: WHEN FND_API.G_EXC_ERROR THEN

Line 236: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');

232: EXCEPTION
233:
234: WHEN AMS_Utility_PVT.resource_locked THEN
235: x_return_status := FND_API.g_ret_sts_error;
236: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
237:
238: WHEN FND_API.G_EXC_ERROR THEN
239: ROLLBACK TO CREATE_Iba_Plcmnt_PVT;
240: x_return_status := FND_API.G_RET_STS_ERROR;

Line 326: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

322:
323: -- Debug Message
324: IF (AMS_DEBUG_HIGH_ON) THEN
325:
326: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
327: END IF;
328:
329:
330: -- Initialize API return status to SUCCESS

Line 336: AMS_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');

332:
333: -- Debug Message
334: IF (AMS_DEBUG_HIGH_ON) THEN
335:
336: AMS_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');
337: END IF;
338:
339: --/*
340: OPEN c_get_Iba_Plcmnt( l_tar_iba_plcmnt_rec.placement_id);

Line 345: AMS_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',

341:
342: FETCH c_get_Iba_Plcmnt INTO l_ref_iba_plcmnt_rec ;
343:
344: If ( c_get_Iba_Plcmnt%NOTFOUND) THEN
345: AMS_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
346: p_token_name => 'INFO',
347: p_token_value => 'Iba_Plcmnt') ;
348: RAISE FND_API.G_EXC_ERROR;
349: END IF;

Line 353: AMS_UTILITY_PVT.debug_message('Private API: - Close Cursor');

349: END IF;
350: -- Debug Message
351: IF (AMS_DEBUG_HIGH_ON) THEN
352:
353: AMS_UTILITY_PVT.debug_message('Private API: - Close Cursor');
354: END IF;
355: CLOSE c_get_Iba_Plcmnt;
356: --*/
357:

Line 361: AMS_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',

357:
358:
359: If (l_tar_iba_plcmnt_rec.object_version_number is NULL or
360: l_tar_iba_plcmnt_rec.object_version_number = FND_API.G_MISS_NUM ) Then
361: AMS_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',
362: p_token_name => 'COLUMN',
363: p_token_value => 'Last_Update_Date') ;
364: raise FND_API.G_EXC_ERROR;
365: End if;

Line 368: AMS_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',

364: raise FND_API.G_EXC_ERROR;
365: End if;
366: -- Check Whether record has been changed by someone else
367: If (l_tar_iba_plcmnt_rec.object_version_number <> l_ref_iba_plcmnt_rec.object_version_number) Then
368: AMS_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',
369: p_token_name => 'INFO',
370: p_token_value => 'Iba_Plcmnt') ;
371: raise FND_API.G_EXC_ERROR;
372: End if;

Line 378: AMS_UTILITY_PVT.debug_message('Private API: Validate_Iba_Plcmnt');

374: THEN
375: -- Debug message
376: IF (AMS_DEBUG_HIGH_ON) THEN
377:
378: AMS_UTILITY_PVT.debug_message('Private API: Validate_Iba_Plcmnt');
379: END IF;
380:
381: -- Invoke validation procedures
382: Validate_iba_plcmnt(

Line 400: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler'); END IF;

396: END IF;
397:
398:
399: -- Debug Message
400: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler'); END IF;
401:
402: -- Invoke table handler(AMS_IBA_PL_PLACEMENTS_B_PKG.Update_Row)
403: AMS_IBA_PL_PLACEMENTS_B_PKG.Update_Row(
404: p_placement_id => p_iba_plcmnt_rec.placement_id,

Line 442: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

438:
439: -- Debug Message
440: IF (AMS_DEBUG_HIGH_ON) THEN
441:
442: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
443: END IF;
444:
445: -- Standard call to get message count and if count is 1, get message info.
446: FND_MSG_PUB.Count_And_Get

Line 452: WHEN AMS_Utility_PVT.resource_locked THEN

448: p_data => x_msg_data
449: );
450: EXCEPTION
451:
452: WHEN AMS_Utility_PVT.resource_locked THEN
453: x_return_status := FND_API.g_ret_sts_error;
454: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
455:
456: WHEN FND_API.G_EXC_ERROR THEN

Line 454: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');

450: EXCEPTION
451:
452: WHEN AMS_Utility_PVT.resource_locked THEN
453: x_return_status := FND_API.g_ret_sts_error;
454: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
455:
456: WHEN FND_API.G_EXC_ERROR THEN
457: ROLLBACK TO UPDATE_Iba_Plcmnt_PVT;
458: x_return_status := FND_API.G_RET_STS_ERROR;

Line 531: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

527:
528: -- Debug Message
529: IF (AMS_DEBUG_HIGH_ON) THEN
530:
531: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
532: END IF;
533:
534:
535: -- Initialize API return status to SUCCESS

Line 544: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');

540: --
541: -- Debug Message
542: IF (AMS_DEBUG_HIGH_ON) THEN
543:
544: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
545: END IF;
546:
547: -- Invoke table handler(AMS_IBA_PL_PLACEMENTS_B_PKG.Delete_Row)
548: AMS_IBA_PL_PLACEMENTS_B_PKG.Delete_Row(

Line 564: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

560:
561: -- Debug Message
562: IF (AMS_DEBUG_HIGH_ON) THEN
563:
564: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
565: END IF;
566:
567: -- Standard call to get message count and if count is 1, get message info.
568: FND_MSG_PUB.Count_And_Get

Line 574: WHEN AMS_Utility_PVT.resource_locked THEN

570: p_data => x_msg_data
571: );
572: EXCEPTION
573:
574: WHEN AMS_Utility_PVT.resource_locked THEN
575: x_return_status := FND_API.g_ret_sts_error;
576: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
577:
578: WHEN FND_API.G_EXC_ERROR THEN

Line 576: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');

572: EXCEPTION
573:
574: WHEN AMS_Utility_PVT.resource_locked THEN
575: x_return_status := FND_API.g_ret_sts_error;
576: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
577:
578: WHEN FND_API.G_EXC_ERROR THEN
579: ROLLBACK TO DELETE_Iba_Plcmnt_PVT;
580: x_return_status := FND_API.G_RET_STS_ERROR;

Line 646: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

642:
643: -- Debug Message
644: IF (AMS_DEBUG_HIGH_ON) THEN
645:
646: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
647: END IF;
648:
649: -- Initialize message list if p_init_msg_list is set to TRUE.
650: IF FND_API.to_Boolean( p_init_msg_list )

Line 675: AMS_Utility_PVT.debug_message(l_full_name||': start');

671: IF (AMS_DEBUG_HIGH_ON) THEN
672:
673:
674:
675: AMS_Utility_PVT.debug_message(l_full_name||': start');
676:
677: END IF;
678: OPEN c_Iba_Plcmnt;
679:

Line 700: AMS_Utility_PVT.debug_message(l_full_name ||': end');

696: p_count => x_msg_count,
697: p_data => x_msg_data);
698: IF (AMS_DEBUG_HIGH_ON) THEN
699:
700: AMS_Utility_PVT.debug_message(l_full_name ||': end');
701: END IF;
702: EXCEPTION
703:
704: WHEN AMS_Utility_PVT.resource_locked THEN

Line 704: WHEN AMS_Utility_PVT.resource_locked THEN

700: AMS_Utility_PVT.debug_message(l_full_name ||': end');
701: END IF;
702: EXCEPTION
703:
704: WHEN AMS_Utility_PVT.resource_locked THEN
705: x_return_status := FND_API.g_ret_sts_error;
706: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
707:
708: WHEN FND_API.G_EXC_ERROR THEN

Line 706: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');

702: EXCEPTION
703:
704: WHEN AMS_Utility_PVT.resource_locked THEN
705: x_return_status := FND_API.g_ret_sts_error;
706: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
707:
708: WHEN FND_API.G_EXC_ERROR THEN
709: ROLLBACK TO LOCK_Iba_Plcmnt_PVT;
710: x_return_status := FND_API.G_RET_STS_ERROR;

Line 864: -- AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_PLACEMENT_NAME_DUPLICATE');

860: FND_MSG_PUB.add;
861: END IF;
862: x_return_status := FND_API.g_ret_sts_error;
863: RAISE FND_API.g_exc_error;
864: -- AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_PLACEMENT_NAME_DUPLICATE');
865: END IF;
866:
867:
868: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

Line 871: AMS_UTILITY_PVT.debug_message('In check_iba_plcmnt_uk_items : before check_uniqueness call plcmnt_name = ' || p_iba_plcmnt_rec.name );

867:
868: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
869: IF (AMS_DEBUG_HIGH_ON) THEN
870:
871: AMS_UTILITY_PVT.debug_message('In check_iba_plcmnt_uk_items : before check_uniqueness call plcmnt_name = ' || p_iba_plcmnt_rec.name );
872: END IF;
873: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
874: 'AMS_IBA_PL_PLACEMENTS_VL',
875: 'NAME = ''' || p_iba_plcmnt_rec.name ||''''

Line 873: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

869: IF (AMS_DEBUG_HIGH_ON) THEN
870:
871: AMS_UTILITY_PVT.debug_message('In check_iba_plcmnt_uk_items : before check_uniqueness call plcmnt_name = ' || p_iba_plcmnt_rec.name );
872: END IF;
873: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
874: 'AMS_IBA_PL_PLACEMENTS_VL',
875: 'NAME = ''' || p_iba_plcmnt_rec.name ||''''
876: );
877: ELSE

Line 878: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

874: 'AMS_IBA_PL_PLACEMENTS_VL',
875: 'NAME = ''' || p_iba_plcmnt_rec.name ||''''
876: );
877: ELSE
878: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
879: 'AMS_IBA_PL_PLACEMENTS_VL',
880: 'NAME = ''' || p_iba_plcmnt_rec.name ||''' AND PLACEMENT_ID <> ' || p_iba_plcmnt_rec.PLACEMENT_ID
881: );
882: END IF;

Line 892: -- AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_PLACEMENT_NAME_DUPLICATE');

888: FND_MSG_PUB.add;
889: END IF;
890: x_return_status := FND_API.g_ret_sts_error;
891: RAISE FND_API.g_exc_error;
892: -- AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_PLACEMENT_NAME_DUPLICATE');
893: END IF;
894:
895: END check_iba_plcmnt_uk_items;
896:

Line 910: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_plcmnt_NO_placement_id');

906: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
907:
908:
909: IF p_iba_plcmnt_rec.placement_id = FND_API.g_miss_num OR p_iba_plcmnt_rec.placement_id IS NULL THEN
910: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_plcmnt_NO_placement_id');
911: x_return_status := FND_API.g_ret_sts_error;
912: RETURN;
913: END IF;
914:

Line 917: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_plcmnt_NO_site_id');

913: END IF;
914:
915:
916: IF p_iba_plcmnt_rec.site_id = FND_API.g_miss_num OR p_iba_plcmnt_rec.site_id IS NULL THEN
917: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_plcmnt_NO_site_id');
918: x_return_status := FND_API.g_ret_sts_error;
919: RETURN;
920: END IF;
921:

Line 924: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_plcmnt_NO_site_ref_code');

920: END IF;
921:
922:
923: IF p_iba_plcmnt_rec.site_ref_code = FND_API.g_miss_char OR p_iba_plcmnt_rec.site_ref_code IS NULL THEN
924: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_plcmnt_NO_site_ref_code');
925: x_return_status := FND_API.g_ret_sts_error;
926: RETURN;
927: END IF;
928:

Line 931: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_plcmnt_NO_page_id');

927: END IF;
928:
929:
930: IF p_iba_plcmnt_rec.page_id = FND_API.g_miss_num OR p_iba_plcmnt_rec.page_id IS NULL THEN
931: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_plcmnt_NO_page_id');
932: x_return_status := FND_API.g_ret_sts_error;
933: RETURN;
934: END IF;
935:

Line 938: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_plcmnt_NO_page_ref_code');

934: END IF;
935:
936:
937: IF p_iba_plcmnt_rec.page_ref_code = FND_API.g_miss_char OR p_iba_plcmnt_rec.page_ref_code IS NULL THEN
938: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_plcmnt_NO_page_ref_code');
939: x_return_status := FND_API.g_ret_sts_error;
940: RETURN;
941: END IF;
942:

Line 945: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_plcmnt_NO_location_code');

941: END IF;
942:
943:
944: IF p_iba_plcmnt_rec.location_code = FND_API.g_miss_char OR p_iba_plcmnt_rec.location_code IS NULL THEN
945: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_plcmnt_NO_location_code');
946: x_return_status := FND_API.g_ret_sts_error;
947: RETURN;
948: END IF;
949:

Line 952: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_plcmnt_NO_status_code');

948: END IF;
949:
950:
951: IF p_iba_plcmnt_rec.status_code = FND_API.g_miss_char OR p_iba_plcmnt_rec.status_code IS NULL THEN
952: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_plcmnt_NO_status_code');
953: x_return_status := FND_API.g_ret_sts_error;
954: RETURN;
955: END IF;
956:

Line 959: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_plcmnt_NO_created_by');

955: END IF;
956:
957:
958: IF p_iba_plcmnt_rec.created_by = FND_API.g_miss_num OR p_iba_plcmnt_rec.created_by IS NULL THEN
959: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_plcmnt_NO_created_by');
960: x_return_status := FND_API.g_ret_sts_error;
961: RETURN;
962: END IF;
963:

Line 966: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_plcmnt_NO_creation_date');

962: END IF;
963:
964:
965: IF p_iba_plcmnt_rec.creation_date = FND_API.g_miss_date OR p_iba_plcmnt_rec.creation_date IS NULL THEN
966: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_plcmnt_NO_creation_date');
967: x_return_status := FND_API.g_ret_sts_error;
968: RETURN;
969: END IF;
970:

Line 973: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_plcmnt_NO_last_updated_by');

969: END IF;
970:
971:
972: IF p_iba_plcmnt_rec.last_updated_by = FND_API.g_miss_num OR p_iba_plcmnt_rec.last_updated_by IS NULL THEN
973: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_plcmnt_NO_last_updated_by');
974: x_return_status := FND_API.g_ret_sts_error;
975: RETURN;
976: END IF;
977:

Line 980: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_plcmnt_NO_last_update_date');

976: END IF;
977:
978:
979: IF p_iba_plcmnt_rec.last_update_date = FND_API.g_miss_date OR p_iba_plcmnt_rec.last_update_date IS NULL THEN
980: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_plcmnt_NO_last_update_date');
981: x_return_status := FND_API.g_ret_sts_error;
982: RETURN;
983: END IF;
984: ELSE

Line 988: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_plcmnt_NO_placement_id');

984: ELSE
985:
986:
987: IF p_iba_plcmnt_rec.placement_id IS NULL THEN
988: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_plcmnt_NO_placement_id');
989: x_return_status := FND_API.g_ret_sts_error;
990: RETURN;
991: END IF;
992:

Line 995: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_plcmnt_NO_site_id');

991: END IF;
992:
993:
994: IF p_iba_plcmnt_rec.site_id IS NULL THEN
995: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_plcmnt_NO_site_id');
996: x_return_status := FND_API.g_ret_sts_error;
997: RETURN;
998: END IF;
999:

Line 1002: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_plcmnt_NO_site_ref_code');

998: END IF;
999:
1000:
1001: IF p_iba_plcmnt_rec.site_ref_code IS NULL THEN
1002: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_plcmnt_NO_site_ref_code');
1003: x_return_status := FND_API.g_ret_sts_error;
1004: RETURN;
1005: END IF;
1006:

Line 1009: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_plcmnt_NO_page_id');

1005: END IF;
1006:
1007:
1008: IF p_iba_plcmnt_rec.page_id IS NULL THEN
1009: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_plcmnt_NO_page_id');
1010: x_return_status := FND_API.g_ret_sts_error;
1011: RETURN;
1012: END IF;
1013:

Line 1016: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_plcmnt_NO_page_ref_code');

1012: END IF;
1013:
1014:
1015: IF p_iba_plcmnt_rec.page_ref_code IS NULL THEN
1016: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_plcmnt_NO_page_ref_code');
1017: x_return_status := FND_API.g_ret_sts_error;
1018: RETURN;
1019: END IF;
1020:

Line 1023: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_plcmnt_NO_location_code');

1019: END IF;
1020:
1021:
1022: IF p_iba_plcmnt_rec.location_code IS NULL THEN
1023: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_plcmnt_NO_location_code');
1024: x_return_status := FND_API.g_ret_sts_error;
1025: RETURN;
1026: END IF;
1027:

Line 1030: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_plcmnt_NO_status_code');

1026: END IF;
1027:
1028:
1029: IF p_iba_plcmnt_rec.status_code IS NULL THEN
1030: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_plcmnt_NO_status_code');
1031: x_return_status := FND_API.g_ret_sts_error;
1032: RETURN;
1033: END IF;
1034:

Line 1037: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_plcmnt_NO_created_by');

1033: END IF;
1034:
1035:
1036: IF p_iba_plcmnt_rec.created_by IS NULL THEN
1037: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_plcmnt_NO_created_by');
1038: x_return_status := FND_API.g_ret_sts_error;
1039: RETURN;
1040: END IF;
1041:

Line 1044: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_plcmnt_NO_creation_date');

1040: END IF;
1041:
1042:
1043: IF p_iba_plcmnt_rec.creation_date IS NULL THEN
1044: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_plcmnt_NO_creation_date');
1045: x_return_status := FND_API.g_ret_sts_error;
1046: RETURN;
1047: END IF;
1048:

Line 1051: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_plcmnt_NO_last_updated_by');

1047: END IF;
1048:
1049:
1050: IF p_iba_plcmnt_rec.last_updated_by IS NULL THEN
1051: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_plcmnt_NO_last_updated_by');
1052: x_return_status := FND_API.g_ret_sts_error;
1053: RETURN;
1054: END IF;
1055:

Line 1058: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_plcmnt_NO_last_update_date');

1054: END IF;
1055:
1056:
1057: IF p_iba_plcmnt_rec.last_update_date IS NULL THEN
1058: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_plcmnt_NO_last_update_date');
1059: x_return_status := FND_API.g_ret_sts_error;
1060: RETURN;
1061: END IF;
1062: END IF;

Line 1104: AMS_UTILITY_PVT.debug_message('In Check_iba_plcmnt_Items: before check_iba_plcmnt_uk_items call plcmnt_name = ' || p_iba_plcmnt_rec.name );

1100: IF (AMS_DEBUG_HIGH_ON) THEN
1101:
1102:
1103:
1104: AMS_UTILITY_PVT.debug_message('In Check_iba_plcmnt_Items: before check_iba_plcmnt_uk_items call plcmnt_name = ' || p_iba_plcmnt_rec.name );
1105:
1106: END IF;
1107: check_iba_plcmnt_uk_items(
1108: p_iba_plcmnt_rec => p_iba_plcmnt_rec,

Line 1308: AMS_UTILITY_PVT.debug_message('In Validate: before Check_iba_plcmnt_Items call plcmnt_name = ' || p_iba_plcmnt_rec.name );

1304: END IF;
1305: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1306: IF (AMS_DEBUG_HIGH_ON) THEN
1307:
1308: AMS_UTILITY_PVT.debug_message('In Validate: before Check_iba_plcmnt_Items call plcmnt_name = ' || p_iba_plcmnt_rec.name );
1309: END IF;
1310: Check_iba_plcmnt_Items(
1311: p_iba_plcmnt_rec => p_iba_plcmnt_rec,
1312: p_validation_mode => p_validation_mode,

Line 1331: AMS_UTILITY_PVT.debug_message('In Validate: before Validate_iba_plcmnt_Rec call ' );

1327:
1328: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1329: IF (AMS_DEBUG_HIGH_ON) THEN
1330:
1331: AMS_UTILITY_PVT.debug_message('In Validate: before Validate_iba_plcmnt_Rec call ' );
1332: END IF;
1333: Validate_iba_plcmnt_Rec(
1334: p_api_version_number => 1.0,
1335: p_init_msg_list => FND_API.G_FALSE,

Line 1352: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

1348:
1349: -- Debug Message
1350: IF (AMS_DEBUG_HIGH_ON) THEN
1351:
1352: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1353: END IF;
1354:
1355:
1356: -- Initialize API return status to SUCCESS

Line 1363: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

1359:
1360: -- Debug Message
1361: IF (AMS_DEBUG_HIGH_ON) THEN
1362:
1363: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1364: END IF;
1365:
1366: -- Standard call to get message count and if count is 1, get message info.
1367: FND_MSG_PUB.Count_And_Get

Line 1373: WHEN AMS_Utility_PVT.resource_locked THEN

1369: p_data => x_msg_data
1370: );
1371: EXCEPTION
1372:
1373: WHEN AMS_Utility_PVT.resource_locked THEN
1374: x_return_status := FND_API.g_ret_sts_error;
1375: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1376:
1377: WHEN FND_API.G_EXC_ERROR THEN

Line 1375: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');

1371: EXCEPTION
1372:
1373: WHEN AMS_Utility_PVT.resource_locked THEN
1374: x_return_status := FND_API.g_ret_sts_error;
1375: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1376:
1377: WHEN FND_API.G_EXC_ERROR THEN
1378: ROLLBACK TO VALIDATE_Iba_Plcmnt_;
1379: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1391: AMS_UTILITY_PVT.debug_message('In Validate - unexpected err: validation_mode= ' || p_validation_mode);

1387: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1388: ROLLBACK TO VALIDATE_Iba_Plcmnt_;
1389: IF (AMS_DEBUG_HIGH_ON) THEN
1390:
1391: AMS_UTILITY_PVT.debug_message('In Validate - unexpected err: validation_mode= ' || p_validation_mode);
1392: END IF;
1393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1394: -- Standard call to get message count and if count=1, get the message
1395: FND_MSG_PUB.Count_And_Get (

Line 1405: AMS_UTILITY_PVT.debug_message('In Validate - others err: validation_mode= ' || p_validation_mode);

1401: WHEN OTHERS THEN
1402: ROLLBACK TO VALIDATE_Iba_Plcmnt_;
1403: IF (AMS_DEBUG_HIGH_ON) THEN
1404:
1405: AMS_UTILITY_PVT.debug_message('In Validate - others err: validation_mode= ' || p_validation_mode);
1406: END IF;
1407: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1408: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1409: THEN

Line 1448: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');

1444:
1445: -- Debug Message
1446: IF (AMS_DEBUG_HIGH_ON) THEN
1447:
1448: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1449: END IF;
1450: -- Standard call to get message count and if count is 1, get message info.
1451: FND_MSG_PUB.Count_And_Get
1452: (p_count => x_msg_count,