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

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

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

Line 121: AMS_UTILITY_PVT.debug_message( l_api_name || ' New Target ID to Insert = ' || l_dm_target_rec.TARGET_ID );

117: IF (AMS_DEBUG_HIGH_ON) THEN
118:
119:
120:
121: AMS_UTILITY_PVT.debug_message( l_api_name || ' New Target ID to Insert = ' || l_dm_target_rec.TARGET_ID );
122:
123: END IF;
124:
125: -- =========================================================================

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

126: -- Validate Environment
127: -- =========================================================================
128:
129: IF FND_GLOBAL.User_Id IS NULL THEN
130: AMS_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
131: RAISE FND_API.G_EXC_ERROR;
132: END IF;
133:
134: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)

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

152:
153: -- Debug Message
154: IF (AMS_DEBUG_HIGH_ON) THEN
155:
156: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
157: END IF;
158:
159: -- Invoke table handler(AMS_DM_TARGETS_B_PKG.Insert_Row)
160: AMS_DM_TARGETS_B_PKG.Insert_Row(

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

202:
203: -- Debug Message
204: IF (AMS_DEBUG_HIGH_ON) THEN
205:
206: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
207: END IF;
208:
209: -- Standard call to get message count and if count is 1, get message info.
210: FND_MSG_PUB.Count_And_Get

Line 216: WHEN AMS_Utility_PVT.resource_locked THEN

212: p_data => x_msg_data
213: );
214: EXCEPTION
215:
216: WHEN AMS_Utility_PVT.resource_locked THEN
217: x_return_status := FND_API.g_ret_sts_error;
218: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
219:
220: WHEN FND_API.G_EXC_ERROR THEN

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

214: EXCEPTION
215:
216: WHEN AMS_Utility_PVT.resource_locked THEN
217: x_return_status := FND_API.g_ret_sts_error;
218: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
219:
220: WHEN FND_API.G_EXC_ERROR THEN
221: ROLLBACK TO CREATE_Dmtarget_PVT;
222: x_return_status := FND_API.G_RET_STS_ERROR;

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

305:
306: -- Debug Message
307: IF (AMS_DEBUG_HIGH_ON) THEN
308:
309: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
310: END IF;
311:
312:
313: -- Initialize API return status to SUCCESS

Line 325: AMS_UTILITY_PVT.debug_message('Private API: - Open Target Reference Cursor');

321:
322: -- Debug Message
323: IF (AMS_DEBUG_HIGH_ON) THEN
324:
325: AMS_UTILITY_PVT.debug_message('Private API: - Open Target Reference Cursor');
326: END IF;
327:
328: -- get the reference target, which contains
329: -- data before the update operation.

Line 334: AMS_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET', p_token_name => 'INFO', p_token_value => 'Dmtarget') ;

330: OPEN c_get_Dmtarget( l_tar_dm_target_rec.target_id);
331: FETCH c_get_Dmtarget INTO l_ref_dm_target_rec ;
332:
333: IF ( c_get_Dmtarget%NOTFOUND) THEN
334: AMS_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET', p_token_name => 'INFO', p_token_value => 'Dmtarget') ;
335: RAISE FND_API.G_EXC_ERROR;
336: END IF;
337:
338: -- Debug Message

Line 341: AMS_UTILITY_PVT.debug_message('Private API: - Close Target Reference Cursor');

337:
338: -- Debug Message
339: IF (AMS_DEBUG_HIGH_ON) THEN
340:
341: AMS_UTILITY_PVT.debug_message('Private API: - Close Target Reference Cursor');
342: END IF;
343: CLOSE c_get_Dmtarget;
344:
345: IF (l_tar_dm_target_rec.object_version_number is NULL or

Line 347: AMS_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING', p_token_name => 'COLUMN', p_token_value => 'Last_Update_Date') ;

343: CLOSE c_get_Dmtarget;
344:
345: IF (l_tar_dm_target_rec.object_version_number is NULL or
346: l_tar_dm_target_rec.object_version_number = FND_API.G_MISS_NUM ) Then
347: AMS_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING', p_token_name => 'COLUMN', p_token_value => 'Last_Update_Date') ;
348: raise FND_API.G_EXC_ERROR;
349: End if;
350:
351: -- Check Whether record has been changed by someone else

Line 353: AMS_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED', p_token_name => 'INFO', p_token_value => 'Dmtarget') ;

349: End if;
350:
351: -- Check Whether record has been changed by someone else
352: IF (l_tar_dm_target_rec.object_version_number <> l_ref_dm_target_rec.object_version_number) Then
353: AMS_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED', p_token_name => 'INFO', p_token_value => 'Dmtarget') ;
354: raise FND_API.G_EXC_ERROR;
355: End if;
356:
357: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)

Line 380: AMS_UTILITY_PVT.debug_message('Private API: Calling update table handler');

376:
377: -- Debug Message
378: IF (AMS_DEBUG_HIGH_ON) THEN
379:
380: AMS_UTILITY_PVT.debug_message('Private API: Calling update table handler');
381: END IF;
382: IF (AMS_DEBUG_HIGH_ON) THEN
383:
384: AMS_UTILITY_PVT.debug_message('Updating .........');

Line 384: AMS_UTILITY_PVT.debug_message('Updating .........');

380: AMS_UTILITY_PVT.debug_message('Private API: Calling update table handler');
381: END IF;
382: IF (AMS_DEBUG_HIGH_ON) THEN
383:
384: AMS_UTILITY_PVT.debug_message('Updating .........');
385: END IF;
386: IF (AMS_DEBUG_HIGH_ON) THEN
387:
388: AMS_UTILITY_PVT.debug_message('p_target_id = ' || p_dm_target_rec.target_id);

Line 388: AMS_UTILITY_PVT.debug_message('p_target_id = ' || p_dm_target_rec.target_id);

384: AMS_UTILITY_PVT.debug_message('Updating .........');
385: END IF;
386: IF (AMS_DEBUG_HIGH_ON) THEN
387:
388: AMS_UTILITY_PVT.debug_message('p_target_id = ' || p_dm_target_rec.target_id);
389: END IF;
390: IF (AMS_DEBUG_HIGH_ON) THEN
391:
392: AMS_UTILITY_PVT.debug_message('p_last_update_date = ' || SYSDATE);

Line 392: AMS_UTILITY_PVT.debug_message('p_last_update_date = ' || SYSDATE);

388: AMS_UTILITY_PVT.debug_message('p_target_id = ' || p_dm_target_rec.target_id);
389: END IF;
390: IF (AMS_DEBUG_HIGH_ON) THEN
391:
392: AMS_UTILITY_PVT.debug_message('p_last_update_date = ' || SYSDATE);
393: END IF;
394: IF (AMS_DEBUG_HIGH_ON) THEN
395:
396: AMS_UTILITY_PVT.debug_message('p_last_updated_by = ' || G_USER_ID);

Line 396: AMS_UTILITY_PVT.debug_message('p_last_updated_by = ' || G_USER_ID);

392: AMS_UTILITY_PVT.debug_message('p_last_update_date = ' || SYSDATE);
393: END IF;
394: IF (AMS_DEBUG_HIGH_ON) THEN
395:
396: AMS_UTILITY_PVT.debug_message('p_last_updated_by = ' || G_USER_ID);
397: END IF;
398: IF (AMS_DEBUG_HIGH_ON) THEN
399:
400: AMS_UTILITY_PVT.debug_message('p_creation_date = ' || SYSDATE);

Line 400: AMS_UTILITY_PVT.debug_message('p_creation_date = ' || SYSDATE);

396: AMS_UTILITY_PVT.debug_message('p_last_updated_by = ' || G_USER_ID);
397: END IF;
398: IF (AMS_DEBUG_HIGH_ON) THEN
399:
400: AMS_UTILITY_PVT.debug_message('p_creation_date = ' || SYSDATE);
401: END IF;
402: IF (AMS_DEBUG_HIGH_ON) THEN
403:
404: AMS_UTILITY_PVT.debug_message('p_created_by = ' || G_USER_ID);

Line 404: AMS_UTILITY_PVT.debug_message('p_created_by = ' || G_USER_ID);

400: AMS_UTILITY_PVT.debug_message('p_creation_date = ' || SYSDATE);
401: END IF;
402: IF (AMS_DEBUG_HIGH_ON) THEN
403:
404: AMS_UTILITY_PVT.debug_message('p_created_by = ' || G_USER_ID);
405: END IF;
406: IF (AMS_DEBUG_HIGH_ON) THEN
407:
408: AMS_UTILITY_PVT.debug_message('p_last_update_login = ' || G_LOGIN_ID);

Line 408: AMS_UTILITY_PVT.debug_message('p_last_update_login = ' || G_LOGIN_ID);

404: AMS_UTILITY_PVT.debug_message('p_created_by = ' || G_USER_ID);
405: END IF;
406: IF (AMS_DEBUG_HIGH_ON) THEN
407:
408: AMS_UTILITY_PVT.debug_message('p_last_update_login = ' || G_LOGIN_ID);
409: END IF;
410: IF (AMS_DEBUG_HIGH_ON) THEN
411:
412: AMS_UTILITY_PVT.debug_message('p_object_version_number = ' || l_tar_dm_target_rec.object_version_number);

Line 412: AMS_UTILITY_PVT.debug_message('p_object_version_number = ' || l_tar_dm_target_rec.object_version_number);

408: AMS_UTILITY_PVT.debug_message('p_last_update_login = ' || G_LOGIN_ID);
409: END IF;
410: IF (AMS_DEBUG_HIGH_ON) THEN
411:
412: AMS_UTILITY_PVT.debug_message('p_object_version_number = ' || l_tar_dm_target_rec.object_version_number);
413: END IF;
414: IF (AMS_DEBUG_HIGH_ON) THEN
415:
416: AMS_UTILITY_PVT.debug_message('p_active_flag = ' || l_tar_dm_target_rec.active_flag);

Line 416: AMS_UTILITY_PVT.debug_message('p_active_flag = ' || l_tar_dm_target_rec.active_flag);

412: AMS_UTILITY_PVT.debug_message('p_object_version_number = ' || l_tar_dm_target_rec.object_version_number);
413: END IF;
414: IF (AMS_DEBUG_HIGH_ON) THEN
415:
416: AMS_UTILITY_PVT.debug_message('p_active_flag = ' || l_tar_dm_target_rec.active_flag);
417: END IF;
418: IF (AMS_DEBUG_HIGH_ON) THEN
419:
420: AMS_UTILITY_PVT.debug_message('p_model_type = ' || l_tar_dm_target_rec.model_type);

Line 420: AMS_UTILITY_PVT.debug_message('p_model_type = ' || l_tar_dm_target_rec.model_type);

416: AMS_UTILITY_PVT.debug_message('p_active_flag = ' || l_tar_dm_target_rec.active_flag);
417: END IF;
418: IF (AMS_DEBUG_HIGH_ON) THEN
419:
420: AMS_UTILITY_PVT.debug_message('p_model_type = ' || l_tar_dm_target_rec.model_type);
421: END IF;
422: IF (AMS_DEBUG_HIGH_ON) THEN
423:
424: AMS_UTILITY_PVT.debug_message('p_data_source_id = ' || l_tar_dm_target_rec.data_source_id);

Line 424: AMS_UTILITY_PVT.debug_message('p_data_source_id = ' || l_tar_dm_target_rec.data_source_id);

420: AMS_UTILITY_PVT.debug_message('p_model_type = ' || l_tar_dm_target_rec.model_type);
421: END IF;
422: IF (AMS_DEBUG_HIGH_ON) THEN
423:
424: AMS_UTILITY_PVT.debug_message('p_data_source_id = ' || l_tar_dm_target_rec.data_source_id);
425: END IF;
426: IF (AMS_DEBUG_HIGH_ON) THEN
427:
428: AMS_UTILITY_PVT.debug_message('p_source_field_id = ' || l_tar_dm_target_rec.source_field_id);

Line 428: AMS_UTILITY_PVT.debug_message('p_source_field_id = ' || l_tar_dm_target_rec.source_field_id);

424: AMS_UTILITY_PVT.debug_message('p_data_source_id = ' || l_tar_dm_target_rec.data_source_id);
425: END IF;
426: IF (AMS_DEBUG_HIGH_ON) THEN
427:
428: AMS_UTILITY_PVT.debug_message('p_source_field_id = ' || l_tar_dm_target_rec.source_field_id);
429: END IF;
430: IF (AMS_DEBUG_HIGH_ON) THEN
431:
432: AMS_UTILITY_PVT.debug_message('p_target_name = ' || l_tar_dm_target_rec.target_name);

Line 432: AMS_UTILITY_PVT.debug_message('p_target_name = ' || l_tar_dm_target_rec.target_name);

428: AMS_UTILITY_PVT.debug_message('p_source_field_id = ' || l_tar_dm_target_rec.source_field_id);
429: END IF;
430: IF (AMS_DEBUG_HIGH_ON) THEN
431:
432: AMS_UTILITY_PVT.debug_message('p_target_name = ' || l_tar_dm_target_rec.target_name);
433: END IF;
434: IF (AMS_DEBUG_HIGH_ON) THEN
435:
436: AMS_UTILITY_PVT.debug_message('p_description = ' || l_tar_dm_target_rec.description);

Line 436: AMS_UTILITY_PVT.debug_message('p_description = ' || l_tar_dm_target_rec.description);

432: AMS_UTILITY_PVT.debug_message('p_target_name = ' || l_tar_dm_target_rec.target_name);
433: END IF;
434: IF (AMS_DEBUG_HIGH_ON) THEN
435:
436: AMS_UTILITY_PVT.debug_message('p_description = ' || l_tar_dm_target_rec.description);
437: END IF;
438:
439: BEGIN
440: -- Invoke table handler(AMS_DM_TARGETS_B_PKG.Update_Row)

Line 460: AMS_Utility_PVT.error_message ('AMS_API_RECORD_NOT_FOUND');

456: );
457:
458: EXCEPTION
459: WHEN NO_DATA_FOUND THEN
460: AMS_Utility_PVT.error_message ('AMS_API_RECORD_NOT_FOUND');
461: RAISE FND_API.G_EXC_ERROR;
462: END;
463:
464: x_object_version_number := l_tar_dm_target_rec.object_version_number + 1;

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

476:
477: -- Debug Message
478: IF (AMS_DEBUG_HIGH_ON) THEN
479:
480: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
481: END IF;
482:
483: -- Standard call to get message count and if count is 1, get message info.
484: FND_MSG_PUB.Count_And_Get

Line 490: WHEN AMS_Utility_PVT.resource_locked THEN

486: p_data => x_msg_data
487: );
488: EXCEPTION
489:
490: WHEN AMS_Utility_PVT.resource_locked THEN
491: x_return_status := FND_API.g_ret_sts_error;
492: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
493:
494: WHEN FND_API.G_EXC_ERROR THEN

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

488: EXCEPTION
489:
490: WHEN AMS_Utility_PVT.resource_locked THEN
491: x_return_status := FND_API.g_ret_sts_error;
492: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
493:
494: WHEN FND_API.G_EXC_ERROR THEN
495: ROLLBACK TO UPDATE_Dmtarget_PVT;
496: x_return_status := FND_API.G_RET_STS_ERROR;

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

589:
590: -- Debug Message
591: IF (AMS_DEBUG_HIGH_ON) THEN
592:
593: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
594: END IF;
595:
596:
597: -- Initialize API return status to SUCCESS

Line 605: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_DM_TARGET_USED');

601: OPEN c_target_used(p_target_id);
602: FETCH c_target_used INTO l_no_of_models;
603: CLOSE c_target_used;
604: IF l_no_of_models > 0 THEN
605: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_DM_TARGET_USED');
606: x_return_status := FND_API.g_ret_sts_error;
607: RAISE FND_API.G_EXC_ERROR;
608: END IF;
609:

Line 613: AMS_UTILITY_PVT.debug_message( 'Private API: Going to Delete Target Values Associated with this Target ');

609:
610: -- First Delete Target Values associated with this target (if any)
611: IF (AMS_DEBUG_HIGH_ON) THEN
612:
613: AMS_UTILITY_PVT.debug_message( 'Private API: Going to Delete Target Values Associated with this Target ');
614: END IF;
615:
616: AMS_Dm_Target_Value_PVT.Delete_TgtValues_For_Target ( p_TARGET_ID );
617:

Line 622: AMS_UTILITY_PVT.debug_message( 'Private API: After Deleting Target Values Associated with this Target ');

618: IF (AMS_DEBUG_HIGH_ON) THEN
619:
620:
621:
622: AMS_UTILITY_PVT.debug_message( 'Private API: After Deleting Target Values Associated with this Target ');
623:
624: END IF;
625:
626: -- added rosharma for audience DS uptake

Line 630: AMS_UTILITY_PVT.debug_message( 'Private API: Going to Delete Child Data Sources Associated with this Target ');

626: -- added rosharma for audience DS uptake
627: -- Delete Child Data Sources associated with this target (if any)
628: IF (AMS_DEBUG_HIGH_ON) THEN
629:
630: AMS_UTILITY_PVT.debug_message( 'Private API: Going to Delete Child Data Sources Associated with this Target ');
631: END IF;
632:
633: AMS_Dm_Target_Sources_PVT.delete_tgtsources_for_target ( p_TARGET_ID );
634:

Line 639: AMS_UTILITY_PVT.debug_message( 'Private API: After Deleting Child Data Sources Associated with this Target ');

635: IF (AMS_DEBUG_HIGH_ON) THEN
636:
637:
638:
639: AMS_UTILITY_PVT.debug_message( 'Private API: After Deleting Child Data Sources Associated with this Target ');
640:
641: END IF;
642:
643: /* obsoleted rosharma 11.5.10 for Audience data source uptake

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

653: --
654: -- Debug Message
655: IF (AMS_DEBUG_HIGH_ON) THEN
656:
657: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
658: END IF;
659:
660: -- Invoke table handler(AMS_DM_TARGETS_B_PKG.Delete_Row)
661: AMS_DM_TARGETS_B_PKG.Delete_Row(

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

688:
689: -- Debug Message
690: IF (AMS_DEBUG_HIGH_ON) THEN
691:
692: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
693: END IF;
694:
695: -- Standard call to get message count and if count is 1, get message info.
696: FND_MSG_PUB.Count_And_Get

Line 702: WHEN AMS_Utility_PVT.resource_locked THEN

698: p_data => x_msg_data
699: );
700: EXCEPTION
701:
702: WHEN AMS_Utility_PVT.resource_locked THEN
703: x_return_status := FND_API.g_ret_sts_error;
704: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
705:
706: WHEN FND_API.G_EXC_ERROR THEN

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

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

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

770:
771: -- Debug Message
772: IF (AMS_DEBUG_HIGH_ON) THEN
773:
774: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
775: END IF;
776:
777: -- Initialize message list if p_init_msg_list is set to TRUE.
778: IF FND_API.to_Boolean( p_init_msg_list )

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

799: IF (AMS_DEBUG_HIGH_ON) THEN
800:
801:
802:
803: AMS_Utility_PVT.debug_message(l_full_name||': start');
804:
805: END IF;
806: OPEN c_Dmtarget;
807:

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

824: p_count => x_msg_count,
825: p_data => x_msg_data);
826: IF (AMS_DEBUG_HIGH_ON) THEN
827:
828: AMS_Utility_PVT.debug_message(l_full_name ||': end');
829: END IF;
830: EXCEPTION
831:
832: WHEN AMS_Utility_PVT.resource_locked THEN

Line 832: WHEN AMS_Utility_PVT.resource_locked THEN

828: AMS_Utility_PVT.debug_message(l_full_name ||': end');
829: END IF;
830: EXCEPTION
831:
832: WHEN AMS_Utility_PVT.resource_locked THEN
833: x_return_status := FND_API.g_ret_sts_error;
834: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
835:
836: WHEN FND_API.G_EXC_ERROR THEN

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

830: EXCEPTION
831:
832: WHEN AMS_Utility_PVT.resource_locked THEN
833: x_return_status := FND_API.g_ret_sts_error;
834: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
835:
836: WHEN FND_API.G_EXC_ERROR THEN
837: ROLLBACK TO LOCK_Dmtarget_PVT;
838: x_return_status := FND_API.G_RET_STS_ERROR;

Line 905: AMS_UTILITY_PVT.debug_message('Private API:check_dm_target_uk_items');

901:
902: BEGIN
903: IF (AMS_DEBUG_HIGH_ON) THEN
904:
905: AMS_UTILITY_PVT.debug_message('Private API:check_dm_target_uk_items');
906: END IF;
907: x_return_status := FND_API.g_ret_sts_success;
908:
909: --Validate unique target_id

Line 911: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

907: x_return_status := FND_API.g_ret_sts_success;
908:
909: --Validate unique target_id
910: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
911: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
912: 'AMS_DM_TARGETS_B',
913: 'TARGET_ID = ''' || p_dm_target_rec.TARGET_ID ||''''
914: );
915: ELSE

Line 916: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

912: 'AMS_DM_TARGETS_B',
913: 'TARGET_ID = ''' || p_dm_target_rec.TARGET_ID ||''''
914: );
915: ELSE
916: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
917: 'AMS_DM_TARGETS_B',
918: 'TARGET_ID = ''' || p_dm_target_rec.TARGET_ID ||
919: ''' AND TARGET_ID <> ' || p_dm_target_rec.TARGET_ID
920: );

Line 924: AMS_Utility_PVT.Error_Message('AMS_API_DUPLICATE_ID', 'ID_FIELD','TARGET_ID');

920: );
921: END IF;
922:
923: IF l_valid_flag = FND_API.g_false THEN
924: AMS_Utility_PVT.Error_Message('AMS_API_DUPLICATE_ID', 'ID_FIELD','TARGET_ID');
925: x_return_status := FND_API.g_ret_sts_error;
926: RETURN;
927: END IF;
928:

Line 941: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_DM_DUP_TARGET_NAME');

937: CLOSE c_target_name_updt ;
938: END IF;
939:
940: IF l_dummy IS NOT NULL THEN
941: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_DM_DUP_TARGET_NAME');
942: x_return_status := FND_API.g_ret_sts_error;
943: RETURN;
944: END IF;
945:

Line 954: AMS_UTILITY_PVT.debug_message('l_number ' || l_number);

950: FETCH c_unique_values INTO l_number;
951: CLOSE c_unique_values;
952: IF (AMS_DEBUG_HIGH_ON) THEN
953:
954: AMS_UTILITY_PVT.debug_message('l_number ' || l_number);
955: END IF;
956: IF l_number > 0 THEN
957: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_DM_DUP_MODEL_TARGET');
958: x_return_status := FND_API.g_ret_sts_error;

Line 957: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_DM_DUP_MODEL_TARGET');

953:
954: AMS_UTILITY_PVT.debug_message('l_number ' || l_number);
955: END IF;
956: IF l_number > 0 THEN
957: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_DM_DUP_MODEL_TARGET');
958: x_return_status := FND_API.g_ret_sts_error;
959: RETURN;
960: END IF;
961: */

Line 982: ams_utility_pvt.debug_message('Private API:check_dm_target_req_items for CREATE');

978: IF (AMS_DEBUG_HIGH_ON) THEN
979:
980:
981:
982: ams_utility_pvt.debug_message('Private API:check_dm_target_req_items for CREATE');
983:
984: END IF;
985:
986: IF p_dm_target_rec.target_id = FND_API.g_miss_num OR p_dm_target_rec.target_id IS NULL THEN

Line 987: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','TARGET_ID');

983:
984: END IF;
985:
986: IF p_dm_target_rec.target_id = FND_API.g_miss_num OR p_dm_target_rec.target_id IS NULL THEN
987: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','TARGET_ID');
988: x_return_status := FND_API.g_ret_sts_error;
989: END IF;
990: IF p_dm_target_rec.active_flag = FND_API.g_miss_char OR p_dm_target_rec.active_flag IS NULL THEN
991: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','ACTIVE_FLAG');

Line 991: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','ACTIVE_FLAG');

987: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','TARGET_ID');
988: x_return_status := FND_API.g_ret_sts_error;
989: END IF;
990: IF p_dm_target_rec.active_flag = FND_API.g_miss_char OR p_dm_target_rec.active_flag IS NULL THEN
991: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','ACTIVE_FLAG');
992: x_return_status := FND_API.g_ret_sts_error;
993: END IF;
994: IF p_dm_target_rec.model_type = FND_API.g_miss_char OR p_dm_target_rec.model_type IS NULL THEN
995: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','MODEL_TYPE');

Line 995: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','MODEL_TYPE');

991: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','ACTIVE_FLAG');
992: x_return_status := FND_API.g_ret_sts_error;
993: END IF;
994: IF p_dm_target_rec.model_type = FND_API.g_miss_char OR p_dm_target_rec.model_type IS NULL THEN
995: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','MODEL_TYPE');
996: x_return_status := FND_API.g_ret_sts_error;
997: END IF;
998: IF p_dm_target_rec.data_source_id = FND_API.g_miss_num OR p_dm_target_rec.data_source_id IS NULL THEN
999: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','DATA_SOURCE_ID');

Line 999: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','DATA_SOURCE_ID');

995: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','MODEL_TYPE');
996: x_return_status := FND_API.g_ret_sts_error;
997: END IF;
998: IF p_dm_target_rec.data_source_id = FND_API.g_miss_num OR p_dm_target_rec.data_source_id IS NULL THEN
999: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','DATA_SOURCE_ID');
1000: x_return_status := FND_API.g_ret_sts_error;
1001: END IF;
1002: IF p_dm_target_rec.source_field_id = FND_API.g_miss_num OR p_dm_target_rec.source_field_id IS NULL THEN
1003: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','SOURCE_FIELD_ID');

Line 1003: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','SOURCE_FIELD_ID');

999: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','DATA_SOURCE_ID');
1000: x_return_status := FND_API.g_ret_sts_error;
1001: END IF;
1002: IF p_dm_target_rec.source_field_id = FND_API.g_miss_num OR p_dm_target_rec.source_field_id IS NULL THEN
1003: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','SOURCE_FIELD_ID');
1004: x_return_status := FND_API.g_ret_sts_error;
1005: END IF;
1006: -- added rosharma for audience DS uptake
1007: IF p_dm_target_rec.target_source_id = FND_API.g_miss_num OR p_dm_target_rec.target_source_id IS NULL THEN

Line 1008: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','TARGET_SOURCE_ID');

1004: x_return_status := FND_API.g_ret_sts_error;
1005: END IF;
1006: -- added rosharma for audience DS uptake
1007: IF p_dm_target_rec.target_source_id = FND_API.g_miss_num OR p_dm_target_rec.target_source_id IS NULL THEN
1008: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','TARGET_SOURCE_ID');
1009: x_return_status := FND_API.g_ret_sts_error;
1010: END IF;
1011: ELSE
1012: IF (AMS_DEBUG_HIGH_ON) THEN

Line 1014: ams_utility_pvt.debug_message('Private API:check_dm_target_req_items for UPDATE');

1010: END IF;
1011: ELSE
1012: IF (AMS_DEBUG_HIGH_ON) THEN
1013:
1014: ams_utility_pvt.debug_message('Private API:check_dm_target_req_items for UPDATE');
1015: END IF;
1016:
1017: IF p_dm_target_rec.target_id IS NULL THEN
1018: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','TARGET_ID');

Line 1018: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','TARGET_ID');

1014: ams_utility_pvt.debug_message('Private API:check_dm_target_req_items for UPDATE');
1015: END IF;
1016:
1017: IF p_dm_target_rec.target_id IS NULL THEN
1018: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','TARGET_ID');
1019: x_return_status := FND_API.g_ret_sts_error;
1020: END IF;
1021: IF p_dm_target_rec.last_update_date IS NULL THEN
1022: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','LAST_UPDATE_DATE');

Line 1022: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','LAST_UPDATE_DATE');

1018: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','TARGET_ID');
1019: x_return_status := FND_API.g_ret_sts_error;
1020: END IF;
1021: IF p_dm_target_rec.last_update_date IS NULL THEN
1022: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','LAST_UPDATE_DATE');
1023: x_return_status := FND_API.g_ret_sts_error;
1024: END IF;
1025: IF p_dm_target_rec.last_updated_by IS NULL THEN
1026: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','LAST_UPDATED_BY');

Line 1026: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','LAST_UPDATED_BY');

1022: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','LAST_UPDATE_DATE');
1023: x_return_status := FND_API.g_ret_sts_error;
1024: END IF;
1025: IF p_dm_target_rec.last_updated_by IS NULL THEN
1026: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','LAST_UPDATED_BY');
1027: x_return_status := FND_API.g_ret_sts_error;
1028: END IF;
1029: IF p_dm_target_rec.creation_date IS NULL THEN
1030: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','CREATION_DATE');

Line 1030: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','CREATION_DATE');

1026: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','LAST_UPDATED_BY');
1027: x_return_status := FND_API.g_ret_sts_error;
1028: END IF;
1029: IF p_dm_target_rec.creation_date IS NULL THEN
1030: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','CREATION_DATE');
1031: x_return_status := FND_API.g_ret_sts_error;
1032: END IF;
1033: IF p_dm_target_rec.created_by IS NULL THEN
1034: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','CREATED_BY');

Line 1034: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','CREATED_BY');

1030: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','CREATION_DATE');
1031: x_return_status := FND_API.g_ret_sts_error;
1032: END IF;
1033: IF p_dm_target_rec.created_by IS NULL THEN
1034: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','CREATED_BY');
1035: x_return_status := FND_API.g_ret_sts_error;
1036: END IF;
1037: IF p_dm_target_rec.active_flag IS NULL THEN
1038: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','ACTIVE_FLAG');

Line 1038: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','ACTIVE_FLAG');

1034: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','CREATED_BY');
1035: x_return_status := FND_API.g_ret_sts_error;
1036: END IF;
1037: IF p_dm_target_rec.active_flag IS NULL THEN
1038: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','ACTIVE_FLAG');
1039: x_return_status := FND_API.g_ret_sts_error;
1040: END IF;
1041: IF p_dm_target_rec.model_type IS NULL THEN
1042: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','MODEL_TYPE');

Line 1042: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','MODEL_TYPE');

1038: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','ACTIVE_FLAG');
1039: x_return_status := FND_API.g_ret_sts_error;
1040: END IF;
1041: IF p_dm_target_rec.model_type IS NULL THEN
1042: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','MODEL_TYPE');
1043: x_return_status := FND_API.g_ret_sts_error;
1044: END IF;
1045: IF p_dm_target_rec.data_source_id IS NULL THEN
1046: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','DATA_SOURCE_ID');

Line 1046: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','DATA_SOURCE_ID');

1042: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','MODEL_TYPE');
1043: x_return_status := FND_API.g_ret_sts_error;
1044: END IF;
1045: IF p_dm_target_rec.data_source_id IS NULL THEN
1046: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','DATA_SOURCE_ID');
1047: x_return_status := FND_API.g_ret_sts_error;
1048: END IF;
1049: IF p_dm_target_rec.source_field_id IS NULL THEN
1050: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','SOURCE_FIELD_ID');

Line 1050: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','SOURCE_FIELD_ID');

1046: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','DATA_SOURCE_ID');
1047: x_return_status := FND_API.g_ret_sts_error;
1048: END IF;
1049: IF p_dm_target_rec.source_field_id IS NULL THEN
1050: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','SOURCE_FIELD_ID');
1051: x_return_status := FND_API.g_ret_sts_error;
1052: END IF;
1053: IF (p_dm_target_rec.object_version_number IS NULL OR p_dm_target_rec.object_version_number = FND_API.G_MISS_NUM) THEN
1054: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','OBJECT_VERSION_NUMBER');

Line 1054: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','OBJECT_VERSION_NUMBER');

1050: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','SOURCE_FIELD_ID');
1051: x_return_status := FND_API.g_ret_sts_error;
1052: END IF;
1053: IF (p_dm_target_rec.object_version_number IS NULL OR p_dm_target_rec.object_version_number = FND_API.G_MISS_NUM) THEN
1054: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','OBJECT_VERSION_NUMBER');
1055: x_return_status := FND_API.g_ret_sts_error;
1056: END IF;
1057: -- added rosharma for audience DS uptake
1058: IF p_dm_target_rec.target_source_id = FND_API.g_miss_num OR p_dm_target_rec.target_source_id IS NULL THEN

Line 1059: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','TARGET_SOURCE_ID');

1055: x_return_status := FND_API.g_ret_sts_error;
1056: END IF;
1057: -- added rosharma for audience DS uptake
1058: IF p_dm_target_rec.target_source_id = FND_API.g_miss_num OR p_dm_target_rec.target_source_id IS NULL THEN
1059: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','TARGET_SOURCE_ID');
1060: x_return_status := FND_API.g_ret_sts_error;
1061: END IF;
1062: END IF;
1063:

Line 1074: AMS_UTILITY_PVT.debug_message('Private API:check_dm_target_FK_items');

1070: IS
1071: BEGIN
1072: IF (AMS_DEBUG_HIGH_ON) THEN
1073:
1074: AMS_UTILITY_PVT.debug_message('Private API:check_dm_target_FK_items');
1075: END IF;
1076: x_return_status := FND_API.g_ret_sts_success;
1077:
1078: --------------------data_source_id---------------------------

Line 1080: IF AMS_Utility_PVT.check_fk_exists(

1076: x_return_status := FND_API.g_ret_sts_success;
1077:
1078: --------------------data_source_id---------------------------
1079: IF p_dm_target_rec.data_source_id <> FND_API.g_miss_num THEN
1080: IF AMS_Utility_PVT.check_fk_exists(
1081: 'ams_list_src_types',
1082: 'list_source_type_id',
1083: p_dm_target_rec.data_source_id
1084: ) = FND_API.g_false

Line 1086: AMS_Utility_PVT.error_message ('AMS_API_INVALID_FK', 'COLUMN_NAME', 'DATA_SOURCE_ID');

1082: 'list_source_type_id',
1083: p_dm_target_rec.data_source_id
1084: ) = FND_API.g_false
1085: THEN
1086: AMS_Utility_PVT.error_message ('AMS_API_INVALID_FK', 'COLUMN_NAME', 'DATA_SOURCE_ID');
1087: x_return_status := FND_API.g_ret_sts_error;
1088: END IF;
1089: END IF;
1090:

Line 1094: IF AMS_Utility_PVT.check_fk_exists(

1090:
1091:
1092: --------------------source_field_id---------------------------
1093: IF p_dm_target_rec.source_field_id <> FND_API.g_miss_num THEN
1094: IF AMS_Utility_PVT.check_fk_exists(
1095: 'ams_list_src_fields',
1096: 'list_source_field_id',
1097: p_dm_target_rec.source_field_id
1098: ) = FND_API.g_false

Line 1100: AMS_Utility_PVT.error_message ('AMS_API_INVALID_FK', 'COLUMN_NAME', 'SOURCE_FIELD_ID');

1096: 'list_source_field_id',
1097: p_dm_target_rec.source_field_id
1098: ) = FND_API.g_false
1099: THEN
1100: AMS_Utility_PVT.error_message ('AMS_API_INVALID_FK', 'COLUMN_NAME', 'SOURCE_FIELD_ID');
1101: x_return_status := FND_API.g_ret_sts_error;
1102: END IF;
1103: END IF;
1104:

Line 1109: IF AMS_Utility_PVT.check_fk_exists(

1105:
1106: -- added rosharma for audience DS uptake
1107: --------------------target_source_id---------------------------
1108: IF p_dm_target_rec.target_source_id <> FND_API.g_miss_num THEN
1109: IF AMS_Utility_PVT.check_fk_exists(
1110: 'ams_list_src_types',
1111: 'list_source_type_id',
1112: p_dm_target_rec.target_source_id
1113: ) = FND_API.g_false

Line 1115: AMS_Utility_PVT.error_message ('AMS_API_INVALID_FK', 'COLUMN_NAME', 'TARGET_SOURCE_ID');

1111: 'list_source_type_id',
1112: p_dm_target_rec.target_source_id
1113: ) = FND_API.g_false
1114: THEN
1115: AMS_Utility_PVT.error_message ('AMS_API_INVALID_FK', 'COLUMN_NAME', 'TARGET_SOURCE_ID');
1116: x_return_status := FND_API.g_ret_sts_error;
1117: END IF;
1118: END IF;
1119: END check_dm_target_FK_items;

Line 1129: AMS_UTILITY_PVT.debug_message('Private API:check_dm_target_Lookup_items');

1125: IS
1126: BEGIN
1127: IF (AMS_DEBUG_HIGH_ON) THEN
1128:
1129: AMS_UTILITY_PVT.debug_message('Private API:check_dm_target_Lookup_items');
1130: END IF;
1131: x_return_status := FND_API.g_ret_sts_success;
1132:
1133: ----------------------- model_type ------------------------

Line 1135: IF AMS_Utility_PVT.check_lookup_exists(

1131: x_return_status := FND_API.g_ret_sts_success;
1132:
1133: ----------------------- model_type ------------------------
1134: IF p_dm_target_rec.model_type <> FND_API.g_miss_char THEN
1135: IF AMS_Utility_PVT.check_lookup_exists(
1136: p_lookup_type => 'AMS_DM_MODEL_TYPE',
1137: p_lookup_code => p_dm_target_rec.model_type
1138: ) = FND_API.g_false
1139: THEN

Line 1217: AMS_UTILITY_PVT.debug_message('Private API: Complete_dm_target_Rec start');

1213: BEGIN
1214: -- Debug Message
1215: IF (AMS_DEBUG_HIGH_ON) THEN
1216:
1217: AMS_UTILITY_PVT.debug_message('Private API: Complete_dm_target_Rec start');
1218: END IF;
1219:
1220: x_complete_rec := p_dm_target_rec;
1221:

Line 1292: AMS_UTILITY_PVT.debug_message('Private API: Complete_dm_target_Rec end');

1288:
1289: -- Debug Message
1290: IF (AMS_DEBUG_HIGH_ON) THEN
1291:
1292: AMS_UTILITY_PVT.debug_message('Private API: Complete_dm_target_Rec end');
1293: END IF;
1294:
1295: END Complete_dm_target_Rec;
1296:

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

1316:
1317: -- Debug Message
1318: IF (AMS_DEBUG_HIGH_ON) THEN
1319:
1320: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1321: END IF;
1322:
1323:
1324: -- Standard call to check for call compatibility.

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

1373:
1374: -- Debug Message
1375: IF (AMS_DEBUG_HIGH_ON) THEN
1376:
1377: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1378: END IF;
1379:
1380: -- Standard call to get message count and if count is 1, get message info.
1381: FND_MSG_PUB.Count_And_Get

Line 1387: WHEN AMS_Utility_PVT.resource_locked THEN

1383: p_data => x_msg_data
1384: );
1385: EXCEPTION
1386:
1387: WHEN AMS_Utility_PVT.resource_locked THEN
1388: x_return_status := FND_API.g_ret_sts_error;
1389: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1390:
1391: WHEN FND_API.G_EXC_ERROR THEN

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

1385: EXCEPTION
1386:
1387: WHEN AMS_Utility_PVT.resource_locked THEN
1388: x_return_status := FND_API.g_ret_sts_error;
1389: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1390:
1391: WHEN FND_API.G_EXC_ERROR THEN
1392: ROLLBACK TO VALIDATE_Dmtarget_;
1393: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1440: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_target_rec');

1436: BEGIN
1437: -- Debug Message
1438: IF (AMS_DEBUG_HIGH_ON) THEN
1439:
1440: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_target_rec');
1441: END IF;
1442:
1443: -- Initialize message list if p_init_msg_list is set to TRUE.
1444: IF FND_API.to_Boolean( p_init_msg_list )

Line 1488: l_owner_user_id NUMBER := AMS_Utility_PVT.get_resource_id (FND_GLOBAL.user_id);

1484: L_TARGET_QUALIFIER CONSTANT VARCHAR2(30) := 'TARGET';
1485: L_ACCESS_TYPE_USER CONSTANT VARCHAR2(30) := 'USER';
1486:
1487: -- user id of the currently logged in user.
1488: l_owner_user_id NUMBER := AMS_Utility_PVT.get_resource_id (FND_GLOBAL.user_id);
1489: BEGIN
1490: -- Initialize API return status to SUCCESS
1491: x_return_status := FND_API.G_RET_STS_SUCCESS;
1492:

Line 1497: ams_utility_pvt.debug_message ('qualifier: ' || l_target_qualifier || ' id: ' || p_dm_target_rec.target_id || ' resource: ' || l_owner_user_id);

1493: IF (AMS_DEBUG_HIGH_ON) THEN
1494:
1495:
1496:
1497: ams_utility_pvt.debug_message ('qualifier: ' || l_target_qualifier || ' id: ' || p_dm_target_rec.target_id || ' resource: ' || l_owner_user_id);
1498:
1499: END IF;
1500: -- validate access privileges
1501: IF AMS_Access_PVT.check_update_access (

Line 1506: AMS_Utility_PVT.error_message ('AMS_TARGET_NO_UPDATE_ACCESS');

1502: p_object_id => p_dm_target_rec.target_id,
1503: p_object_type => L_TARGET_QUALIFIER,
1504: p_user_or_role_id => l_owner_user_id,
1505: p_user_or_role_type => L_ACCESS_TYPE_USER) = 'N' THEN
1506: AMS_Utility_PVT.error_message ('AMS_TARGET_NO_UPDATE_ACCESS');
1507: x_return_status := FND_API.G_RET_STS_ERROR;
1508: END IF;
1509: END check_access;
1510: