APPS.AMS_CONTCAMPAIGN_PVT dependencies on AMS_UTILITY_PVT

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

273:
274:
275:
276:
277: AMS_Utility_PVT.debug_message(l_full_name||': start');
278:
279:
280: END IF;
281:

Line 364: AMS_Utility_PVT.debug_message(l_full_name||': PARSE SQL start');

360: IF (AMS_DEBUG_HIGH_ON) THEN
361:
362:
363:
364: AMS_Utility_PVT.debug_message(l_full_name||': PARSE SQL start');
365:
366: END IF;
367:
368: DBMS_SQL.Parse(l_cur_hdl ,

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

460: IF (AMS_DEBUG_HIGH_ON) THEN
461:
462:
463:
464: AMS_Utility_PVT.debug_message(l_full_name ||': end');
465:
466: END IF;
467:
468: EXCEPTION

Line 495: AMS_Utility_PVT.debug_message(l_full_name ||': Execute Native SQL');

491: l_count := l_count + 1 ;
492: END LOOP ;
493: IF (AMS_DEBUG_HIGH_ON) THEN
494:
495: AMS_Utility_PVT.debug_message(l_full_name ||': Execute Native SQL');
496: END IF;
497:
498: -- First Check for no of columns
499: BEGIN

Line 518: AMS_Utility_PVT.debug_message(l_full_name ||': Query Returns One row');

514: -- The query Returns only one row , So the query is right
515: -- dbms_output.put_line('Query Returns only one row');
516: IF (AMS_DEBUG_HIGH_ON) THEN
517:
518: AMS_Utility_PVT.debug_message(l_full_name ||': Query Returns One row');
519: END IF;
520: Null;
521: WHEN OTHERS THEN
522: x_return_status := FND_API.G_RET_STS_ERROR;

Line 580: AMS_Utility_PVT.debug_message(l_full_name ||': Execute native SQL: End');

576: -- Debug Message
577: --
578: IF (AMS_DEBUG_HIGH_ON) THEN
579:
580: AMS_Utility_PVT.debug_message(l_full_name ||': Execute native SQL: End');
581: END IF;
582:
583: END IF ;
584: -- Return the result of the query

Line 596: AMS_Utility_PVT.debug_message(l_full_name ||':End');

592: -- Debug Message
593: --
594: IF (AMS_DEBUG_HIGH_ON) THEN
595:
596: AMS_Utility_PVT.debug_message(l_full_name ||':End');
597: END IF;
598:
599:
600: -- Standard call to get message count AND IF count is 1, get message info.

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

860: -- Debug Message
861: --
862: IF (AMS_DEBUG_HIGH_ON) THEN
863:
864: AMS_Utility_PVT.debug_message(l_full_name||': start');
865: END IF;
866:
867: --
868: -- Initialize message list IF p_init_msg_list is set to TRUE.

Line 915: AMS_Utility_PVT.Create_Log (

911: l_cur_date := sysdate;
912: l_last_run_date := sysdate;
913: END IF;
914:
915: AMS_Utility_PVT.Create_Log (
916: x_return_status => x_return_status,
917: p_arc_log_used_by => 'TRIG',
918: p_log_used_by_id => l_trigger_id,
919: p_msg_data => 'Schedule_Next_Trigger_Run : repeat_frequency_type = ' || l_trigger.repeat_frequency_type,

Line 949: AMS_Utility_PVT.Convert_Timezone(

945: --
946: -- Following code is added by ptendulk on 26 Apr 2000
947: -- The calls added to calculate the time in User's timezone
948:
949: AMS_Utility_PVT.Convert_Timezone(
950: p_init_msg_list => p_init_msg_list,
951: x_return_status => x_return_status,
952: x_msg_count => x_msg_count,
953: x_msg_data => x_msg_data,

Line 968: AMS_Utility_PVT.Convert_Timezone(

964: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
965: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
966: END IF;
967:
968: AMS_Utility_PVT.Convert_Timezone(
969: p_init_msg_list => p_init_msg_list,
970: x_return_status => x_return_status,
971: x_msg_count => x_msg_count,
972: x_msg_data => x_msg_data,

Line 995: AMS_Utility_PVT.debug_message(l_full_name||': Update Schedule Date');

991: -- Debug Message
992: --
993: IF (AMS_DEBUG_HIGH_ON) THEN
994:
995: AMS_Utility_PVT.debug_message(l_full_name||': Update Schedule Date');
996: END IF;
997:
998:
999: UPDATE ams_triggers

Line 1027: AMS_Utility_PVT.debug_message(l_full_name ||': delete');

1023: -- Debug Message
1024: --
1025: IF (AMS_DEBUG_HIGH_ON) THEN
1026:
1027: AMS_Utility_PVT.debug_message(l_full_name ||': delete');
1028: END IF;
1029:
1030: --
1031: -- END of API body.

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

1185: -- Debug Message
1186: --
1187: IF (AMS_DEBUG_HIGH_ON) THEN
1188:
1189: AMS_Utility_PVT.debug_message(l_full_name||': start');
1190: END IF;
1191:
1192: --
1193: -- Initialize message list IF p_init_msg_list is set to TRUE.

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

1505: IF (AMS_DEBUG_HIGH_ON) THEN
1506:
1507:
1508:
1509: AMS_Utility_PVT.debug_message(l_full_name ||': end');
1510:
1511: END IF;
1512:
1513: