DBA Data[Home] [Help]

APPS.AMS_EVENTSCHEDULE_COPY_PVT dependencies on AMS_UTILITY_PVT

Line 121: AMS_UTILITY_PVT.debug_message('the deliverable copying: ');

117: l_stmt_num := 1;
118: IF p_src_act_id IS NOT NULL THEN
119: IF (AMS_DEBUG_HIGH_ON) THEN
120:
121: AMS_UTILITY_PVT.debug_message('the deliverable copying: ');
122: END IF;
123: IF (AMS_DEBUG_HIGH_ON) THEN
124:
125: AMS_UTILITY_PVT.debug_message('the p_src_act_id: ' || p_src_act_id||'\n');

Line 125: AMS_UTILITY_PVT.debug_message('the p_src_act_id: ' || p_src_act_id||'\n');

121: AMS_UTILITY_PVT.debug_message('the deliverable copying: ');
122: END IF;
123: IF (AMS_DEBUG_HIGH_ON) THEN
124:
125: AMS_UTILITY_PVT.debug_message('the p_src_act_id: ' || p_src_act_id||'\n');
126: END IF;
127: IF (AMS_DEBUG_HIGH_ON) THEN
128:
129: AMS_UTILITY_PVT.debug_message('the p_new_act_id: ' || p_new_act_id||'\n');

Line 129: AMS_UTILITY_PVT.debug_message('the p_new_act_id: ' || p_new_act_id||'\n');

125: AMS_UTILITY_PVT.debug_message('the p_src_act_id: ' || p_src_act_id||'\n');
126: END IF;
127: IF (AMS_DEBUG_HIGH_ON) THEN
128:
129: AMS_UTILITY_PVT.debug_message('the p_new_act_id: ' || p_new_act_id||'\n');
130: END IF;
131: END IF;
132: FOR deliverable_rec IN deliverable_cur
133: LOOP

Line 376: ams_utility_pvt.get_lookup_meaning ( 'AMS_SYS_ARC_QUALIFIER',

372: BEGIN
373: p_errcode := NULL;
374: p_errnum := 0;
375: p_errmsg := NULL;
376: ams_utility_pvt.get_lookup_meaning ( 'AMS_SYS_ARC_QUALIFIER',
377: 'AGEN',
378: l_return_status,
379: l_lookup_meaning
380: );

Line 393: AMS_UTILITY_PVT.debug_message('the p_src_act_id: ' || p_src_act_id||'\n');

389: l_stmt_num := 1;
390: IF p_src_act_id IS NOT NULL THEN
391: IF (AMS_DEBUG_HIGH_ON) THEN
392:
393: AMS_UTILITY_PVT.debug_message('the p_src_act_id: ' || p_src_act_id||'\n');
394: END IF;
395: IF (AMS_DEBUG_HIGH_ON) THEN
396:
397: AMS_UTILITY_PVT.debug_message('the p_new_act_id: ' || p_new_act_id||'\n');

Line 397: AMS_UTILITY_PVT.debug_message('the p_new_act_id: ' || p_new_act_id||'\n');

393: AMS_UTILITY_PVT.debug_message('the p_src_act_id: ' || p_src_act_id||'\n');
394: END IF;
395: IF (AMS_DEBUG_HIGH_ON) THEN
396:
397: AMS_UTILITY_PVT.debug_message('the p_new_act_id: ' || p_new_act_id||'\n');
398: END IF;
399: END IF;
400: FOR agenda_rec IN agenda_cur
401: LOOP

Line 441: AMS_UTILITY_PVT.debug_message('the p_act_agenda_id: ' || l_act_agenda_id||'\n');

437: IF (AMS_DEBUG_HIGH_ON) THEN
438:
439:
440:
441: AMS_UTILITY_PVT.debug_message('the p_act_agenda_id: ' || l_act_agenda_id||'\n');
442:
443: END IF;
444:
445:

Line 587: ams_utility_pvt.get_lookup_meaning ( 'AMS_SYS_ARC_QUALIFIER',

583: p_errcode := NULL;
584: p_errnum := 0;
585: p_errmsg := NULL;
586:
587: ams_utility_pvt.get_lookup_meaning ( 'AMS_SYS_ARC_QUALIFIER',
588: 'AGEN',
589: l_return_status,
590: l_lookup_meaning
591: );

Line 606: AMS_UTILITY_PVT.debug_message('the p_src_act_id: ' || p_src_act_id||'\n');

602:
603: l_stmt_num := 1;
604: IF p_src_act_id IS NOT NULL THEN
605: IF (AMS_DEBUG_HIGH_ON) THEN
606: AMS_UTILITY_PVT.debug_message('the p_src_act_id: ' || p_src_act_id||'\n');
607: END IF;
608: IF (AMS_DEBUG_HIGH_ON) THEN
609: AMS_UTILITY_PVT.debug_message('the p_new_act_id: ' || p_new_act_id||'\n');
610: END IF;

Line 609: AMS_UTILITY_PVT.debug_message('the p_new_act_id: ' || p_new_act_id||'\n');

605: IF (AMS_DEBUG_HIGH_ON) THEN
606: AMS_UTILITY_PVT.debug_message('the p_src_act_id: ' || p_src_act_id||'\n');
607: END IF;
608: IF (AMS_DEBUG_HIGH_ON) THEN
609: AMS_UTILITY_PVT.debug_message('the p_new_act_id: ' || p_new_act_id||'\n');
610: END IF;
611: END IF;
612:
613: OPEN c_ev_offer_det (p_src_act_id);

Line 659: AMS_UTILITY_PVT.debug_message('the p_act_agenda_id: ' || l_act_track_id||'\n');

655: x_agenda_id => l_act_track_id
656: );
657:
658: IF (AMS_DEBUG_HIGH_ON) THEN
659: AMS_UTILITY_PVT.debug_message('the p_act_agenda_id: ' || l_act_track_id||'\n');
660: END IF;
661: IF l_return_status = fnd_api.g_ret_sts_error
662: OR l_return_status = fnd_api.g_ret_sts_unexp_error
663: THEN

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

904:
905: -- Debug Message
906: IF (AMS_DEBUG_HIGH_ON) THEN
907:
908: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
909: END IF;
910: IF (AMS_DEBUG_HIGH_ON) THEN
911:
912: AMS_UTILITY_PVT.debug_message('the source object id: ' || p_source_object_id||'\n');

Line 912: AMS_UTILITY_PVT.debug_message('the source object id: ' || p_source_object_id||'\n');

908: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
909: END IF;
910: IF (AMS_DEBUG_HIGH_ON) THEN
911:
912: AMS_UTILITY_PVT.debug_message('the source object id: ' || p_source_object_id||'\n');
913: END IF;
914: IF (AMS_DEBUG_HIGH_ON) THEN
915:
916: AMS_UTILITY_PVT.debug_message('the new source object id: ' || x_new_object_id||'\n');

Line 916: AMS_UTILITY_PVT.debug_message('the new source object id: ' || x_new_object_id||'\n');

912: AMS_UTILITY_PVT.debug_message('the source object id: ' || p_source_object_id||'\n');
913: END IF;
914: IF (AMS_DEBUG_HIGH_ON) THEN
915:
916: AMS_UTILITY_PVT.debug_message('the new source object id: ' || x_new_object_id||'\n');
917: END IF;
918: IF (AMS_DEBUG_HIGH_ON) THEN
919:
920: AMS_UTILITY_PVT.debug_message('the source custom setup id: ' || x_custom_setup_id||'\n');

Line 920: AMS_UTILITY_PVT.debug_message('the source custom setup id: ' || x_custom_setup_id||'\n');

916: AMS_UTILITY_PVT.debug_message('the new source object id: ' || x_new_object_id||'\n');
917: END IF;
918: IF (AMS_DEBUG_HIGH_ON) THEN
919:
920: AMS_UTILITY_PVT.debug_message('the source custom setup id: ' || x_custom_setup_id||'\n');
921: END IF;
922: FOR i IN 1..p_copy_columns_table.COUNT LOOP
923: IF (AMS_DEBUG_HIGH_ON) THEN
924:

Line 925: AMS_UTILITY_PVT.debug_message('the'||i||'copy column name: '|| p_copy_columns_table(i).column_name||'\n');

921: END IF;
922: FOR i IN 1..p_copy_columns_table.COUNT LOOP
923: IF (AMS_DEBUG_HIGH_ON) THEN
924:
925: AMS_UTILITY_PVT.debug_message('the'||i||'copy column name: '|| p_copy_columns_table(i).column_name||'\n');
926: END IF;
927: IF (AMS_DEBUG_HIGH_ON) THEN
928:
929: AMS_UTILITY_PVT.debug_message('the'||i||'copy column value: '|| p_copy_columns_table(i).column_value||'\n');

Line 929: AMS_UTILITY_PVT.debug_message('the'||i||'copy column value: '|| p_copy_columns_table(i).column_value||'\n');

925: AMS_UTILITY_PVT.debug_message('the'||i||'copy column name: '|| p_copy_columns_table(i).column_name||'\n');
926: END IF;
927: IF (AMS_DEBUG_HIGH_ON) THEN
928:
929: AMS_UTILITY_PVT.debug_message('the'||i||'copy column value: '|| p_copy_columns_table(i).column_value||'\n');
930: END IF;
931: END LOOP;
932: FOR i IN 1..p_attributes_table.COUNT LOOP
933: IF (AMS_DEBUG_HIGH_ON) THEN

Line 935: AMS_UTILITY_PVT.debug_message('the'||i||'attibute: '||p_attributes_table(i));

931: END LOOP;
932: FOR i IN 1..p_attributes_table.COUNT LOOP
933: IF (AMS_DEBUG_HIGH_ON) THEN
934:
935: AMS_UTILITY_PVT.debug_message('the'||i||'attibute: '||p_attributes_table(i));
936: END IF;
937: END LOOP;
938: -- Initialize API return status to SUCCESS
939: -- x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1052: AMS_UTILITY_PVT.debug_message('offerId: ' || l_event_offer_rec.event_offer_id || 'start\n');

1048: -- ----------------------------
1049: -- call create api
1050: IF (AMS_DEBUG_HIGH_ON) THEN
1051:
1052: AMS_UTILITY_PVT.debug_message('offerId: ' || l_event_offer_rec.event_offer_id || 'start\n');
1053: END IF;
1054: IF (AMS_DEBUG_HIGH_ON) THEN
1055:
1056: AMS_UTILITY_PVT.debug_message('deliverable stuff: ' || l_event_offer_rec.event_delivery_method_code);

Line 1056: AMS_UTILITY_PVT.debug_message('deliverable stuff: ' || l_event_offer_rec.event_delivery_method_code);

1052: AMS_UTILITY_PVT.debug_message('offerId: ' || l_event_offer_rec.event_offer_id || 'start\n');
1053: END IF;
1054: IF (AMS_DEBUG_HIGH_ON) THEN
1055:
1056: AMS_UTILITY_PVT.debug_message('deliverable stuff: ' || l_event_offer_rec.event_delivery_method_code);
1057: END IF;
1058:
1059: l_event_offer_rec.object_version_number := 2;
1060: -- DBMS_OUTPUT.put_line('calling create with ');

Line 1079: AMS_UTILITY_PVT.debug_message('the l_event_header_id: ' || l_event_offer_id||'\n');

1075: RAISE FND_API.G_EXC_ERROR;
1076: END IF;
1077: IF (AMS_DEBUG_HIGH_ON) THEN
1078:
1079: AMS_UTILITY_PVT.debug_message('the l_event_header_id: ' || l_event_offer_id||'\n');
1080: END IF;
1081: IF (AMS_DEBUG_HIGH_ON) THEN
1082:
1083: AMS_UTILITY_PVT.debug_message('the l_new_event_header_id: ' || l_new_event_offer_id||'\n');

Line 1083: AMS_UTILITY_PVT.debug_message('the l_new_event_header_id: ' || l_new_event_offer_id||'\n');

1079: AMS_UTILITY_PVT.debug_message('the l_event_header_id: ' || l_event_offer_id||'\n');
1080: END IF;
1081: IF (AMS_DEBUG_HIGH_ON) THEN
1082:
1083: AMS_UTILITY_PVT.debug_message('the l_new_event_header_id: ' || l_new_event_offer_id||'\n');
1084: END IF;
1085: -- copy agenda
1086:
1087: -- soagrawa 12-may-2003 uncommented for bug# 2949268 for 11.5.10

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

1237:
1238: -- Debug Message
1239: IF (AMS_DEBUG_HIGH_ON) THEN
1240:
1241: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1242: END IF;
1243:
1244: -- Standard call to get message count and if count is 1, get message info.
1245: FND_MSG_PUB.Count_And_Get