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_COPYELEMENTS_PVT dependencies on AMS_CPYUTILITY_PVT

Line 107: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,

103:
104: fnd_message.set_name ('AMS', 'AMS_COPY_ELEMENTS');
105: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
106: l_mesg_text := fnd_message.get;
107: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
108: p_src_act_id,
109: l_mesg_text,
110: 'GENERAL'
111: );

Line 175: ams_cpyutility_pvt.write_log_mesg( p_src_act_type,

171: p_errnum := 1;
172: p_errmsg := substr(l_mesg_text||' , '|| TO_CHAR (l_stmt_num) ||
173: ' , ' || '): ' || l_counter ||
174: ' OF ' || x_msg_count, 1, 4000);
175: ams_cpyutility_pvt.write_log_mesg( p_src_act_type,
176: p_src_act_id,
177: p_errmsg,
178: 'ERROR'
179: );

Line 187: ams_cpyutility_pvt.get_product_name

183: fnd_message.set_name ('AMS', 'AMS_COPY_ERROR2');
184: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
185: l_mesg_text := fnd_message.get;
186: p_errmsg := SUBSTR ( l_mesg_text || ' - ' ||
187: ams_cpyutility_pvt.get_product_name
188: (prod_rec.category_id),
189: 1, 4000);
190: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
191: p_src_act_id,

Line 190: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,

186: p_errmsg := SUBSTR ( l_mesg_text || ' - ' ||
187: ams_cpyutility_pvt.get_product_name
188: (prod_rec.category_id),
189: 1, 4000);
190: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
191: p_src_act_id,
192: p_errmsg,
193: 'ERROR'
194: );

Line 213: ams_cpyutility_pvt.get_product_name

209: fnd_message.set_name ('AMS', 'AMS_COPY_ERROR2');
210: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
211: l_mesg_text := fnd_message.get;
212: p_errmsg := l_mesg_text ||
213: ams_cpyutility_pvt.get_product_name
214: (prod_rec.category_id) || p_errmsg;
215: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
216: p_src_act_id,
217: p_errmsg,

Line 215: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,

211: l_mesg_text := fnd_message.get;
212: p_errmsg := l_mesg_text ||
213: ams_cpyutility_pvt.get_product_name
214: (prod_rec.category_id) || p_errmsg;
215: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
216: p_src_act_id,
217: p_errmsg,
218: 'ERROR'
219: );

Line 227: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,

223: fnd_message.set_name ('AMS', 'AMS_END_COPY_ELEMENTS');
224: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
225: fnd_message.set_token('ELEMENT_NAME',' ' ,TRUE);
226: l_mesg_text := fnd_message.get;
227: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
228: p_src_act_id,
229: l_mesg_text,
230: 'GENERAL'
231: );

Line 243: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,

239: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
240: l_mesg_text := fnd_message.get;
241: p_errmsg := SUBSTR ( l_mesg_text || TO_CHAR (l_stmt_num) || ',' ||
242: '): ' || p_errcode || SQLERRM, 1, 4000);
243: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
244: p_src_act_id,
245: p_errmsg,
246: 'ERROR'
247: );

Line 289: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,

285:
286: fnd_message.set_name ('AMS', 'AMS_COPY_ELEMENTS');
287: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
288: l_mesg_text := fnd_message.get;
289: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
290: p_src_act_id,
291: l_mesg_text,
292: 'GENERAL'
293: );

Line 329: ams_cpyutility_pvt.write_log_mesg( p_src_act_type,

325: p_errnum := 1;
326: p_errmsg := substr(l_mesg_text||' , '|| TO_CHAR (l_stmt_num) ||
327: ' , ' || '): ' || l_counter ||
328: ' OF ' || x_msg_count, 1, 4000);
329: ams_cpyutility_pvt.write_log_mesg( p_src_act_type,
330: p_src_act_id,
331: p_errmsg,
332: 'ERROR'
333: );

Line 337: ams_cpyutility_pvt.get_message_name

333: );
334: END LOOP;
335:
336: p_errmsg := SUBSTR( l_mesg_text || ' - ' ||
337: ams_cpyutility_pvt.get_message_name
338: (message_rec.message_id), 1, 4000);
339: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
340: p_src_act_id,
341: p_errmsg,

Line 339: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,

335:
336: p_errmsg := SUBSTR( l_mesg_text || ' - ' ||
337: ams_cpyutility_pvt.get_message_name
338: (message_rec.message_id), 1, 4000);
339: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
340: p_src_act_id,
341: p_errmsg,
342: 'ERROR'
343: );

Line 361: ams_cpyutility_pvt.get_message_name

357: fnd_message.set_name ('AMS', 'AMS_COPY_ERROR2');
358: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
359: l_mesg_text := fnd_message.get;
360: p_errmsg := l_mesg_text || ': - ' ||
361: ams_cpyutility_pvt.get_message_name
362: (message_rec.message_id) || p_errmsg;
363: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
364: p_src_act_id,
365: p_errmsg,

Line 363: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,

359: l_mesg_text := fnd_message.get;
360: p_errmsg := l_mesg_text || ': - ' ||
361: ams_cpyutility_pvt.get_message_name
362: (message_rec.message_id) || p_errmsg;
363: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
364: p_src_act_id,
365: p_errmsg,
366: 'ERROR'
367: );

Line 374: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,

370: fnd_message.set_name ('AMS', 'AMS_END_COPY_ELEMENTS');
371: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
372: fnd_message.set_token('ELEMENT_NAME',' ' ,TRUE);
373: l_mesg_text := fnd_message.get;
374: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
375: p_src_act_id,
376: l_mesg_text,
377: 'GENERAL'
378: );

Line 390: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,

386: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
387: l_mesg_text := fnd_message.get;
388: p_errmsg := SUBSTR ( l_mesg_text || TO_CHAR (l_stmt_num) ||
389: ',' || '): ' || p_errcode || SQLERRM, 1, 4000);
390: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
391: p_src_act_id,
392: p_errmsg,
393: 'ERROR'
394: );

Line 455: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,

451: l_obj_association_id := 0;
452: fnd_message.set_name ('AMS', 'AMS_COPY_ELEMENTS');
453: fnd_message.set_token ('ELEMENTS', 'AMS_COPY_ASSOCIATIONS', TRUE);
454: l_mesg_text := fnd_message.get;
455: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
456: p_src_act_id,
457: l_mesg_text,
458: 'GENERAL'
459: );

Line 559: ams_cpyutility_pvt.write_log_mesg( p_src_act_type,

555: p_errnum := 1;
556: p_errmsg := substr(l_mesg_text||' , '|| TO_CHAR (l_stmt_num) ||
557: ' , ' || '): ' || l_counter ||
558: ' OF ' || x_msg_count, 1, 4000);
559: ams_cpyutility_pvt.write_log_mesg( p_src_act_type,
560: p_src_act_id,
561: p_errmsg,
562: 'ERROR'
563: );

Line 580: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,

576: l_association_rec.using_object_id),
577: 1,
578: 4000
579: );
580: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
581: p_src_act_id,
582: p_errmsg,
583: 'ERROR'
584: );

Line 611: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,

607: ams_utility_pvt.get_object_name (
608: l_association_rec.master_object_type,
609: l_association_rec.master_object_id)
610: || p_errmsg;
611: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
612: p_src_act_id,
613: p_errmsg,
614: 'ERROR'
615: );

Line 629: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,

625: l_mesg_text := fnd_message.get;
626: p_errmsg := SUBSTR ( l_mesg_text || TO_CHAR (l_stmt_num) ||
627: ',' || '): ' || p_errcode || SQLERRM, 1,
628: 4000);
629: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
630: p_src_act_id,
631: p_errmsg,
632: 'ERROR'
633: );

Line 688: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,

684: );
685: fnd_message.set_name ('AMS', 'AMS_COPY_ELEMENTS');
686: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
687: l_mesg_text := fnd_message.get;
688: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
689: p_src_act_id,
690: l_mesg_text,
691: 'GENERAL'
692: );

Line 750: ams_cpyutility_pvt.write_log_mesg( p_src_act_type,

746: p_errnum := 1;
747: p_errmsg := substr(l_mesg_text||' , '|| TO_CHAR (l_stmt_num) ||
748: ' , ' || '): ' || l_counter ||
749: ' OF ' || x_msg_count, 1, 4000);
750: ams_cpyutility_pvt.write_log_mesg( p_src_act_type,
751: p_src_act_id,
752: p_errmsg,
753: 'ERROR'
754: );

Line 763: ams_cpyutility_pvt.get_geo_area_name (

759: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
760: l_mesg_text := fnd_message.get;
761: p_errmsg := SUBSTR ( l_mesg_text ||
762: ' - ' ||
763: ams_cpyutility_pvt.get_geo_area_name (
764: geo_areas_rec.geo_hierarchy_id,
765: geo_areas_rec.geo_area_type_code
766: ),
767: 1, 4000);

Line 768: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,

764: geo_areas_rec.geo_hierarchy_id,
765: geo_areas_rec.geo_area_type_code
766: ),
767: 1, 4000);
768: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
769: p_src_act_id,
770: p_errmsg,
771: 'ERROR'
772: );

Line 782: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,

778: fnd_message.set_name ('AMS', 'AMS_END_COPY_ELEMENTS');
779: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
780: fnd_message.set_token('ELEMENT_NAME',l_location_name,TRUE);
781: l_mesg_text := fnd_message.get;
782: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
783: p_src_act_id,
784: l_mesg_text,
785: 'GENERAL'
786: );

Line 804: ams_cpyutility_pvt.get_geo_area_name (

800: fnd_message.set_name ('AMS', 'AMS_COPY_ERROR2');
801: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
802: l_mesg_text := fnd_message.get;
803: p_errmsg := l_mesg_text ||
804: ams_cpyutility_pvt.get_geo_area_name (
805: geo_areas_rec.geo_hierarchy_id,
806: geo_areas_rec.geo_area_type_code
807: ) || p_errmsg;
808: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,

Line 808: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,

804: ams_cpyutility_pvt.get_geo_area_name (
805: geo_areas_rec.geo_hierarchy_id,
806: geo_areas_rec.geo_area_type_code
807: ) || p_errmsg;
808: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
809: p_src_act_id,
810: p_errmsg,
811: 'ERROR'
812: );

Line 826: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,

822: l_mesg_text := fnd_message.get;
823: p_errmsg := SUBSTR ( l_mesg_text ||
824: TO_CHAR (l_stmt_num) || ',' || '): ' ||
825: p_errcode || SQLERRM, 1, 4000);
826: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
827: p_src_act_id,
828: p_errmsg,
829: 'ERROR'
830: );

Line 877: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,

873: );
874: fnd_message.set_name ('AMS', 'AMS_COPY_ELEMENTS');
875: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
876: l_mesg_text := fnd_message.get;
877: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
878: p_src_act_id,
879: l_mesg_text,
880: 'GENERAL'
881: );

Line 941: ams_cpyutility_pvt.write_log_mesg( p_src_act_type,

937: p_errnum := 1;
938: p_errmsg := substr(l_mesg_text||' , '|| TO_CHAR (l_stmt_num) ||
939: ' , ' || '): ' || l_counter ||
940: ' OF ' || x_msg_count, 1, 4000);
941: ams_cpyutility_pvt.write_log_mesg( p_src_act_type,
942: p_src_act_id,
943: p_errmsg,
944: 'ERROR'
945: );

Line 953: ams_cpyutility_pvt.get_resource_name (

949: fnd_message.set_name ('AMS', 'AMS_COPY_ERROR2');
950: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
951: l_mesg_text := fnd_message.get;
952: p_errmsg := SUBSTR ( l_mesg_text || ' - ' ||
953: ams_cpyutility_pvt.get_resource_name (
954: resource_rec.resource_id),
955: 1, 4000);
956: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
957: p_src_act_id,

Line 956: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,

952: p_errmsg := SUBSTR ( l_mesg_text || ' - ' ||
953: ams_cpyutility_pvt.get_resource_name (
954: resource_rec.resource_id),
955: 1, 4000);
956: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
957: p_src_act_id,
958: p_errmsg,
959: 'ERROR'
960: );

Line 977: ams_cpyutility_pvt.get_resource_name (

973: fnd_message.set_name ('AMS', 'AMS_COPY_ERROR2');
974: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
975: l_mesg_text := fnd_message.get;
976: p_errmsg := l_mesg_text ||
977: ams_cpyutility_pvt.get_resource_name (
978: resource_rec.resource_id) || p_errmsg;
979: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
980: p_src_act_id,
981: p_errmsg,

Line 979: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,

975: l_mesg_text := fnd_message.get;
976: p_errmsg := l_mesg_text ||
977: ams_cpyutility_pvt.get_resource_name (
978: resource_rec.resource_id) || p_errmsg;
979: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
980: p_src_act_id,
981: p_errmsg,
982: 'ERROR'
983: );

Line 997: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,

993: l_mesg_text := fnd_message.get;
994: p_errmsg := SUBSTR ( l_mesg_text || TO_CHAR (l_stmt_num) ||
995: ',' || '): ' || p_errcode ||
996: SQLERRM, 1, 4000);
997: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
998: p_src_act_id,
999: p_errmsg,
1000: 'ERROR'
1001: );

Line 1083: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,

1079: );
1080: fnd_message.set_name ('AMS', 'AMS_COPY_ELEMENTS');
1081: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
1082: l_mesg_text := fnd_message.get;
1083: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
1084: p_src_act_id ,
1085: l_mesg_text,
1086: 'GENERAL'
1087: );

Line 1155: ams_cpyutility_pvt.write_log_mesg( p_src_act_type,

1151: p_errmsg := substr(l_mesg_text||' , '||
1152: TO_CHAR (l_stmt_num) ||
1153: ' , ' || '): ' || l_counter ||
1154: ' OF ' || x_msg_count, 1, 4000);
1155: ams_cpyutility_pvt.write_log_mesg( p_src_act_type,
1156: p_new_act_id,
1157: p_errmsg,
1158: 'ERROR'
1159: );

Line 1167: ams_cpyutility_pvt.get_attachment_name (

1163: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
1164: l_mesg_text := fnd_message.get;
1165: p_errmsg := SUBSTR ( l_mesg_text ||
1166: ' - ' ||
1167: ams_cpyutility_pvt.get_attachment_name (
1168: attachments_rec.attachment_id),
1169: 1, 4000);
1170: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
1171: p_src_act_id,

Line 1170: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,

1166: ' - ' ||
1167: ams_cpyutility_pvt.get_attachment_name (
1168: attachments_rec.attachment_id),
1169: 1, 4000);
1170: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
1171: p_src_act_id,
1172: p_errmsg,
1173: 'ERROR');
1174: END IF;

Line 1258: ams_cpyutility_pvt.write_log_mesg( p_src_act_type,

1254: p_errmsg := substr(l_mesg_text||' , '||
1255: TO_CHAR (l_stmt_num) ||
1256: ' , ' || '): ' || l_counter ||
1257: ' OF ' || x_msg_count, 1, 4000);
1258: ams_cpyutility_pvt.write_log_mesg( p_src_act_type,
1259: p_new_act_id,
1260: p_errmsg,
1261: 'ERROR'
1262: );

Line 1270: ams_cpyutility_pvt.get_attachment_name (

1266: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
1267: l_mesg_text := fnd_message.get;
1268: p_errmsg := SUBSTR ( l_mesg_text ||
1269: ' - ' ||
1270: ams_cpyutility_pvt.get_attachment_name (
1271: attachments_rec.attachment_id),
1272: 1, 4000);
1273: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
1274: p_src_act_id,

Line 1273: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,

1269: ' - ' ||
1270: ams_cpyutility_pvt.get_attachment_name (
1271: attachments_rec.attachment_id),
1272: 1, 4000);
1273: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
1274: p_src_act_id,
1275: p_errmsg,
1276: 'ERROR');
1277: END IF;

Line 1365: ams_cpyutility_pvt.write_log_mesg( p_src_act_type,

1361: p_errmsg := substr(l_mesg_text||' , '||
1362: TO_CHAR (l_stmt_num) ||
1363: ' , ' || '): ' || l_counter ||
1364: ' OF ' || x_msg_count, 1, 4000);
1365: ams_cpyutility_pvt.write_log_mesg( p_src_act_type,
1366: p_new_act_id,
1367: p_errmsg,
1368: 'ERROR'
1369: );

Line 1377: ams_cpyutility_pvt.get_attachment_name (

1373: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
1374: l_mesg_text := fnd_message.get;
1375: p_errmsg := SUBSTR ( l_mesg_text ||
1376: ' - ' ||
1377: ams_cpyutility_pvt.get_attachment_name (
1378: attachments_rec.attachment_id),
1379: 1, 4000);
1380: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
1381: p_src_act_id,

Line 1380: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,

1376: ' - ' ||
1377: ams_cpyutility_pvt.get_attachment_name (
1378: attachments_rec.attachment_id),
1379: 1, 4000);
1380: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
1381: p_src_act_id,
1382: p_errmsg,
1383: 'ERROR');
1384: END IF;

Line 1408: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,

1404: fnd_message.set_name ('AMS', 'AMS_END_COPY_ELEMENTS');
1405: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
1406: fnd_message.set_token('ELEMENT_NAME',' ' ,TRUE);
1407: l_mesg_text := fnd_message.get;
1408: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
1409: p_src_act_id,
1410: l_mesg_text,
1411: 'GENERAL'
1412: );

Line 1429: ams_cpyutility_pvt.get_attachment_name (

1425: fnd_message.set_name ('AMS', 'AMS_COPY_ERROR2');
1426: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
1427: l_mesg_text := fnd_message.get;
1428: p_errmsg := SUBSTR ( l_mesg_text ||
1429: ams_cpyutility_pvt.get_attachment_name (
1430: attachments_rec.attachment_id) ||
1431: p_errmsg, 1, 4000);
1432: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
1433: p_src_act_id,

Line 1432: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,

1428: p_errmsg := SUBSTR ( l_mesg_text ||
1429: ams_cpyutility_pvt.get_attachment_name (
1430: attachments_rec.attachment_id) ||
1431: p_errmsg, 1, 4000);
1432: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
1433: p_src_act_id,
1434: p_errmsg,
1435: 'ERROR'
1436: );

Line 1453: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,

1449: l_mesg_text := fnd_message.get;
1450: p_errmsg := SUBSTR ( l_mesg_text || ' , ' ||
1451: TO_CHAR (l_stmt_num) || ' , ' || '): ' ||
1452: p_errcode || SQLERRM, 1, 4000);
1453: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
1454: p_src_act_id ,
1455: p_errmsg,
1456: 'ERROR'
1457: );

Line 1503: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,

1499: p_errmsg := NULL;
1500: fnd_message.set_name ('AMS', 'AMS_COPY_ELEMENTS');
1501: fnd_message.set_token ('ELEMENTS', 'AMS_COPY_ACCESS', TRUE);
1502: l_mesg_text := fnd_message.get;
1503: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
1504: p_src_act_id,
1505: l_mesg_text,
1506: 'GENERAL'
1507: );

Line 1559: ams_cpyutility_pvt.write_log_mesg( p_src_act_type,

1555: p_errnum := 1;
1556: p_errmsg := substr(l_mesg_text||' , '|| TO_CHAR (l_stmt_num) ||
1557: ' , ' || '): ' || l_counter ||
1558: ' OF ' || x_msg_count, 1, 4000);
1559: ams_cpyutility_pvt.write_log_mesg( p_src_act_type,
1560: p_src_act_id,
1561: p_errmsg,
1562: 'ERROR'
1563: );

Line 1569: ams_cpyutility_pvt.write_log_mesg (

1565: fnd_message.set_name ('AMS', 'AMS_COPY_ERROR2');
1566: fnd_message.set_token ('ELEMENTS', 'AMS_COPY_ACCESS', TRUE);
1567: l_mesg_text := fnd_message.get;
1568: p_errmsg := SUBSTR (l_mesg_text || access_rec.user_or_role_id, 1, 4000);
1569: ams_cpyutility_pvt.write_log_mesg (
1570: p_src_act_type,
1571: p_src_act_id,
1572: p_errmsg,
1573: 'ERROR'

Line 1594: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,

1590: l_mesg_text := fnd_message.get;
1591: p_errmsg := SUBSTR ( l_mesg_text ||
1592: access_rec.user_or_role_id || p_errmsg,
1593: 1, 4000);
1594: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
1595: p_src_act_id,
1596: p_errmsg,
1597: 'ERROR'
1598: );

Line 1613: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,

1609: l_mesg_text := fnd_message.get;
1610: p_errmsg := SUBSTR ( l_mesg_text || '): ' ||
1611: TO_CHAR (l_stmt_num) || ',' || '): ' ||
1612: p_errcode || SQLERRM, 1, 4000);
1613: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
1614: p_src_act_id,
1615: p_errmsg,
1616: 'ERROR'
1617: );

Line 1667: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,

1663: );
1664: fnd_message.set_name ('AMS', 'AMS_COPY_ELEMENTS');
1665: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
1666: l_mesg_text := fnd_message.get;
1667: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
1668: p_src_act_id,
1669: l_mesg_text,
1670: 'GENERAL'
1671: );

Line 1728: ams_cpyutility_pvt.write_log_mesg( p_src_act_type,

1724: p_errnum := 1;
1725: p_errmsg := substr(l_mesg_text||' , '|| TO_CHAR (l_stmt_num) ||
1726: ' , ' || '): ' || l_counter ||
1727: ' OF ' || x_msg_count, 1, 4000);
1728: ams_cpyutility_pvt.write_log_mesg( p_src_act_type,
1729: p_src_act_id,
1730: p_errmsg,
1731: 'ERROR'
1732: );

Line 1738: ams_cpyutility_pvt.get_segment_name (

1734: fnd_message.set_name ('AMS', 'AMS_COPY_ERROR2');
1735: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
1736: l_mesg_text := fnd_message.get;
1737: p_errmsg := SUBSTR ( l_mesg_text || ' - ' ||
1738: ams_cpyutility_pvt.get_segment_name (
1739: segments_rec.market_segment_id),
1740: 1, 4000);
1741: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
1742: p_src_act_id,

Line 1741: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,

1737: p_errmsg := SUBSTR ( l_mesg_text || ' - ' ||
1738: ams_cpyutility_pvt.get_segment_name (
1739: segments_rec.market_segment_id),
1740: 1, 4000);
1741: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
1742: p_src_act_id,
1743: p_errmsg,
1744: 'ERROR'
1745: );

Line 1754: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,

1750: fnd_message.set_name ('AMS', 'AMS_END_COPY_ELEMENTS');
1751: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
1752: fnd_message.set_token('ELEMENT_NAME',l_segment_name,TRUE);
1753: l_mesg_text := fnd_message.get;
1754: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
1755: p_src_act_id,
1756: l_mesg_text,
1757: 'GENERAL'
1758: );

Line 1777: ams_cpyutility_pvt.get_segment_name (

1773: fnd_message.set_name ('AMS', 'AMS_COPY_ERROR2');
1774: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
1775: l_mesg_text := fnd_message.get;
1776: p_errmsg := SUBSTR ( l_mesg_text ||
1777: ams_cpyutility_pvt.get_segment_name (
1778: segments_rec.market_segment_id
1779: ) || p_errmsg, 1, 4000);
1780: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
1781: p_src_act_id,

Line 1780: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,

1776: p_errmsg := SUBSTR ( l_mesg_text ||
1777: ams_cpyutility_pvt.get_segment_name (
1778: segments_rec.market_segment_id
1779: ) || p_errmsg, 1, 4000);
1780: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
1781: p_src_act_id,
1782: p_errmsg,
1783: 'ERROR'
1784: );

Line 1799: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,

1795: l_mesg_text := fnd_message.get;
1796: p_errmsg := SUBSTR ( l_mesg_text ||
1797: TO_CHAR (l_stmt_num) || ',' || '): ' ||
1798: p_errcode || SQLERRM, 1, 4000);
1799: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
1800: p_src_act_id,
1801: p_errmsg,
1802: 'ERROR'
1803: );

Line 1846: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,

1842: );
1843: fnd_message.set_name ('AMS', 'AMS_COPY_ELEMENTS');
1844: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
1845: l_mesg_text := fnd_message.get;
1846: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
1847: p_src_act_id,
1848: l_mesg_text,
1849: 'GENERAL'
1850: );

Line 1906: ams_cpyutility_pvt.write_log_mesg( p_src_act_type,

1902: p_errnum := 1;
1903: p_errmsg := substr(l_mesg_text||' , '|| TO_CHAR (l_stmt_num) ||
1904: ' , ' || '): ' || l_counter ||
1905: ' OF ' || x_msg_count, 1, 4000);
1906: ams_cpyutility_pvt.write_log_mesg( p_src_act_type,
1907: p_src_act_id,
1908: p_errmsg,
1909: 'ERROR'
1910: );

Line 1916: ams_cpyutility_pvt.get_category_name (

1912: fnd_message.set_name ('AMS', 'AMS_COPY_ERROR2');
1913: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
1914: l_mesg_text := fnd_message.get;
1915: p_errmsg := SUBSTR ( l_mesg_text || ' - ' ||
1916: ams_cpyutility_pvt.get_category_name (
1917: categories_rec.category_id
1918: ), 1, 4000);
1919: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
1920: p_src_act_id,

Line 1919: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,

1915: p_errmsg := SUBSTR ( l_mesg_text || ' - ' ||
1916: ams_cpyutility_pvt.get_category_name (
1917: categories_rec.category_id
1918: ), 1, 4000);
1919: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
1920: p_src_act_id,
1921: p_errmsg,
1922: 'ERROR'
1923: );

Line 1941: ams_cpyutility_pvt.get_category_name (

1937: fnd_message.set_name ('AMS', 'AMS_COPY_ERROR2');
1938: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
1939: l_mesg_text := fnd_message.get;
1940: p_errmsg := SUBSTR ( l_mesg_text ||
1941: ams_cpyutility_pvt.get_category_name (
1942: categories_rec.category_id
1943: ) || p_errmsg, 1, 4000);
1944: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
1945: p_src_act_id,

Line 1944: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,

1940: p_errmsg := SUBSTR ( l_mesg_text ||
1941: ams_cpyutility_pvt.get_category_name (
1942: categories_rec.category_id
1943: ) || p_errmsg, 1, 4000);
1944: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
1945: p_src_act_id,
1946: p_errmsg,
1947: 'ERROR'
1948: );

Line 1963: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,

1959: l_mesg_text := fnd_message.get;
1960: p_errmsg := SUBSTR ( l_mesg_text || TO_CHAR (l_stmt_num) ||
1961: ',' || '): ' || p_errcode || SQLERRM,
1962: 1, 4000);
1963: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
1964: p_src_act_id,
1965: p_errmsg,
1966: 'ERROR'
1967: );

Line 2006: ams_cpyutility_pvt.write_log_mesg (

2002: p_errmsg := NULL;
2003: fnd_message.set_name ('AMS', 'COPY_ACT_ELEMENTS');
2004: fnd_message.set_token ('ELEMENTS', 'AMS_COPY_DELIVMETHODS', TRUE);
2005: l_mesg_text := fnd_message.get;
2006: ams_cpyutility_pvt.write_log_mesg (
2007: p_src_act_type,
2008: p_src_act_id,
2009: l_mesg_text,
2010: 'GENERAL'

Line 2067: ams_cpyutility_pvt.write_log_mesg( p_src_act_type,

2063: p_errnum := 1;
2064: p_errmsg := substr(l_mesg_text||' , '|| TO_CHAR (l_stmt_num) ||
2065: ' , ' || '): ' || l_counter ||
2066: ' OF ' || x_msg_count, 1, 4000);
2067: ams_cpyutility_pvt.write_log_mesg( p_src_act_type,
2068: p_src_act_id,
2069: p_errmsg,
2070: 'ERROR'
2071: );

Line 2079: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,

2075: l_mesg_text := fnd_message.get;
2076: p_errmsg := SUBSTR ( l_mesg_text || ' - ' ||
2077: deliv_method_rec.activity_delivery_method_id,
2078: 1, 4000);
2079: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
2080: p_src_act_id,
2081: p_errmsg,
2082: 'ERROR'
2083: );

Line 2097: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,

2093: p_errmsg := SUBSTR ( l_mesg_text || ',' || TO_CHAR (l_stmt_num)
2094: || ',' || '): ' || p_errcode || SQLERRM ||
2095: deliv_method_rec.activity_delivery_method_id,
2096: 1, 4000);
2097: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
2098: p_src_act_id,
2099: p_errmsg,
2100: 'ERROR'
2101: );

Line 2115: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,

2111: fnd_message.set_token ('ELEMENTS','AMS_COPY_DELIVMETHODS', TRUE);
2112: l_mesg_text := fnd_message.get;
2113: p_errmsg := SUBSTR ( l_mesg_text || TO_CHAR (l_stmt_num) ||
2114: ',' || '): ' || p_errcode || SQLERRM, 1, 4000);
2115: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
2116: p_src_act_id,
2117: p_errmsg,
2118: 'ERROR'
2119: );

Line 2156: ams_cpyutility_pvt.write_log_mesg ('DELV',

2152: p_errmsg := NULL;
2153: fnd_message.set_name ('AMS', 'COPY_ACT_ELEMENTS');
2154: fnd_message.set_token ('ELEMENTS', 'AMS_COPY_DELIV_KITS', TRUE);
2155: l_mesg_text := fnd_message.get;
2156: ams_cpyutility_pvt.write_log_mesg ('DELV',
2157: p_src_deli_id,
2158: l_mesg_text,
2159: 'GENERAL');
2160: l_stmt_num := 1;

Line 2216: ams_cpyutility_pvt.write_log_mesg (

2212: p_errnum := 1;
2213: p_errmsg := substr(l_mesg_text||' , '|| TO_CHAR (l_stmt_num) ||
2214: ' , ' || '): ' || l_counter ||
2215: ' OF ' || x_msg_count, 1, 4000);
2216: ams_cpyutility_pvt.write_log_mesg (
2217: 'DELV',
2218: p_src_deli_id,
2219: p_errmsg,
2220: 'ERROR'

Line 2230: ams_cpyutility_pvt.write_log_mesg ( 'DELV',

2226: fnd_message.set_token ('ELEMENTS','AMS_COPY_DELIV_KITS', TRUE);
2227: l_mesg_text := fnd_message.get;
2228: p_errmsg := SUBSTR (l_mesg_text || ' - '
2229: ||deliv_kit_rec.deliverable_kit_id , 1, 4000);
2230: ams_cpyutility_pvt.write_log_mesg ( 'DELV',
2231: p_src_deli_id,
2232: p_errmsg,
2233: 'ERROR'
2234: );

Line 2252: ams_cpyutility_pvt.write_log_mesg ( 'DELV',

2248: fnd_message.set_token ('ELEMENTS','AMS_COPY_DELIV_KITS', TRUE);
2249: l_mesg_text := fnd_message.get;
2250: p_errmsg := l_mesg_text ||deliv_kit_rec.deliverable_kit_id
2251: ||p_errmsg;
2252: ams_cpyutility_pvt.write_log_mesg ( 'DELV',
2253: p_src_deli_id,
2254: p_errmsg,
2255: 'ERROR'
2256: );

Line 2271: ams_cpyutility_pvt.write_log_mesg ('DELV',

2267: l_mesg_text := fnd_message.get;
2268: p_errmsg := SUBSTR ( l_mesg_text || TO_CHAR (l_stmt_num) ||
2269: ',' || '): ' || p_errcode || SQLERRM, 1, 4000);
2270:
2271: ams_cpyutility_pvt.write_log_mesg ('DELV',
2272: p_src_deli_id,
2273: p_errmsg,
2274: 'ERROR');
2275:

Line 2354: ams_cpyutility_pvt.write_log_mesg ( 'CAMP',

2350: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
2351: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);
2352:
2353: -- Writing to the Pl/SQLtable
2354: ams_cpyutility_pvt.write_log_mesg ( 'CAMP',
2355: p_src_camp_schedule_id,
2356: l_mesg_text,
2357: 'GENERAL'
2358: );

Line 2425: ams_cpyutility_pvt.write_log_mesg ( 'CSCH',

2421: LOOP
2422: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);
2423: p_errmsg := substr(l_mesg_text || '): ' || l_counter ||
2424: ' OF ' || x_msg_count, 1, 3000);
2425: ams_cpyutility_pvt.write_log_mesg ( 'CSCH',
2426: p_src_camp_schedule_id,
2427: p_errmsg,
2428: 'ERROR'
2429: );

Line 2431: ams_cpyutility_pvt.write_log_mesg ( 'CSCH',

2427: p_errmsg,
2428: 'ERROR'
2429: );
2430: END LOOP;
2431: ams_cpyutility_pvt.write_log_mesg ( 'CSCH',
2432: p_src_camp_schedule_id,
2433: p_errmsg,
2434: 'ERROR'
2435: );

Line 2443: ams_cpyutility_pvt.write_log_mesg ( 'CSCH',

2439: l_mesg_text := fnd_message.get;
2440: p_errmsg := l_mesg_text ||
2441: ams_utility_pvt.get_object_name ('CAMP', p_new_camp_id)
2442: || p_errmsg;
2443: ams_cpyutility_pvt.write_log_mesg ( 'CSCH',
2444: p_src_camp_schedule_id,
2445: p_errmsg,
2446: 'ERROR'
2447: );

Line 2574: ams_cpyutility_pvt.write_log_mesg ( 'CAMP',

2570: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
2571: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);
2572:
2573: -- Writing to the Pl/SQLtable
2574: ams_cpyutility_pvt.write_log_mesg ( 'CAMP',
2575: p_old_camp_id,
2576: l_mesg_text,
2577: 'GENERAL'
2578: );

Line 2616: ams_cpyutility_pvt.write_log_mesg ( 'CAMP',

2612: LOOP
2613: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);
2614: p_errmsg := substr(l_mesg_text || '): ' || l_counter ||
2615: ' OF ' || x_msg_count, 1, 3000);
2616: ams_cpyutility_pvt.write_log_mesg ( 'CAMP',
2617: p_old_camp_id,
2618: p_errmsg,
2619: 'ERROR'
2620: );

Line 2628: ams_cpyutility_pvt.write_log_mesg ( 'CAMP',

2624: l_mesg_text := fnd_message.get;
2625: p_errmsg := l_mesg_text ||
2626: ams_utility_pvt.get_object_name ('CAMP', p_new_camp_id)
2627: || p_errmsg;
2628: ams_cpyutility_pvt.write_log_mesg ( 'CAMP',
2629: p_old_camp_id,
2630: p_errmsg,
2631: 'ERROR'
2632: );

Line 2663: ams_cpyutility_pvt.write_log_mesg ( 'CAMP',

2659: LOOP
2660: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);
2661: p_errmsg := SUBSTR ( l_mesg_text || '): ' || l_counter ||
2662: ' OF ' || x_msg_count, 1, 3000);
2663: ams_cpyutility_pvt.write_log_mesg ( 'CAMP',
2664: p_old_camp_id,
2665: p_errmsg,
2666: 'ERROR'
2667: );

Line 2676: ams_cpyutility_pvt.write_log_mesg ( 'CAMP',

2672: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
2673: l_mesg_text := fnd_message.get;
2674: p_errmsg := l_mesg_text || ams_utility_pvt.get_object_name
2675: ('CAMP', p_new_camp_id) || p_errmsg;
2676: ams_cpyutility_pvt.write_log_mesg ( 'CAMP',
2677: p_old_camp_id,
2678: p_errmsg,
2679: 'ERROR');
2680: if l_return_status = fnd_api.g_ret_sts_unexp_error then

Line 2801: ams_cpyutility_pvt.write_log_mesg ( 'CAMP',

2797: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
2798: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);
2799:
2800: -- Writing to the Pl/SQLtable
2801: ams_cpyutility_pvt.write_log_mesg ( 'CAMP',
2802: p_old_camp_id,
2803: l_mesg_text,
2804: 'GENERAL'
2805: );

Line 2869: ams_cpyutility_pvt.write_log_mesg (

2865: x_msg_count,
2866: 1,
2867: 3000
2868: );
2869: ams_cpyutility_pvt.write_log_mesg (
2870: 'CAMP',
2871: p_old_camp_id,
2872: p_errmsg,
2873: 'ERROR'

Line 2890: ams_cpyutility_pvt.write_log_mesg (

2886: x_msg_count,
2887: 1,
2888: 4000
2889: );
2890: ams_cpyutility_pvt.write_log_mesg (
2891: 'CAMP',
2892: p_old_camp_id,
2893: p_errmsg,
2894: 'ERROR'

Line 2906: ams_cpyutility_pvt.write_log_mesg ( 'CAMP',

2902: p_errmsg := l_mesg_text ||
2903: ams_utility_pvt.get_object_name ('CAMP',
2904: p_new_camp_id) ||
2905: p_errmsg;
2906: ams_cpyutility_pvt.write_log_mesg ( 'CAMP',
2907: p_old_camp_id,
2908: p_errmsg,
2909: 'ERROR'
2910: );

Line 2922: ams_cpyutility_pvt.write_log_mesg (

2918: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);
2919: p_errmsg := SUBSTR ( l_mesg_text || ' , ' || '): ' ||
2920: x_msg_count || ' OF ' || x_msg_count,
2921: 1, 4000);
2922: ams_cpyutility_pvt.write_log_mesg (
2923: 'CAMP',
2924: p_old_camp_id,
2925: p_errmsg,
2926: 'ERROR'

Line 2937: ams_cpyutility_pvt.write_log_mesg ( 'CAMP',

2933: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
2934: l_mesg_text := fnd_message.get;
2935: p_errmsg := l_mesg_text || ams_utility_pvt.get_object_name
2936: ('CAMP', p_new_camp_id) || p_errmsg;
2937: ams_cpyutility_pvt.write_log_mesg ( 'CAMP',
2938: p_old_camp_id,
2939: p_errmsg,
2940: 'ERROR'
2941: );

Line 3217: ams_cpyutility_pvt.write_log_mesg ( p_type,

3213: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
3214: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);
3215:
3216: -- Writing to the Pl/SQLtable
3217: ams_cpyutility_pvt.write_log_mesg ( p_type,
3218: p_old_id,
3219: l_mesg_text,
3220: 'GENERAL'
3221: );

Line 3277: ams_cpyutility_pvt.write_log_mesg (

3273: x_msg_count,
3274: 1,
3275: 3000
3276: );
3277: ams_cpyutility_pvt.write_log_mesg (
3278: p_type,
3279: p_old_id,
3280: p_errmsg,
3281: 'ERROR'

Line 3298: ams_cpyutility_pvt.write_log_mesg (

3294: x_msg_count,
3295: 1,
3296: 4000
3297: );
3298: ams_cpyutility_pvt.write_log_mesg (
3299: p_type,
3300: p_old_id,
3301: p_errmsg,
3302: 'ERROR'

Line 3314: ams_cpyutility_pvt.write_log_mesg ( p_type,

3310: p_errmsg := l_mesg_text ||
3311: ams_utility_pvt.get_object_name (p_type,
3312: p_new_id) ||
3313: p_errmsg;
3314: ams_cpyutility_pvt.write_log_mesg ( p_type,
3315: p_old_id,
3316: p_errmsg,
3317: 'ERROR'
3318: );

Line 3330: ams_cpyutility_pvt.write_log_mesg (

3326: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);
3327: p_errmsg := SUBSTR ( l_mesg_text || ' , ' || '): ' ||
3328: x_msg_count || ' OF ' || x_msg_count,
3329: 1, 4000);
3330: ams_cpyutility_pvt.write_log_mesg (
3331: p_type,
3332: p_old_id,
3333: p_errmsg,
3334: 'ERROR'

Line 3345: ams_cpyutility_pvt.write_log_mesg ( p_type,

3341: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
3342: l_mesg_text := fnd_message.get;
3343: p_errmsg := l_mesg_text || ams_utility_pvt.get_object_name
3344: (p_type, p_new_id) || p_errmsg;
3345: ams_cpyutility_pvt.write_log_mesg ( p_type,
3346: p_old_id,
3347: p_errmsg,
3348: 'ERROR'
3349: );

Line 4174: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,

4170: );
4171: fnd_message.set_name ('AMS', 'AMS_COPY_ELEMENTS');
4172: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
4173: l_mesg_text := fnd_message.get;
4174: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
4175: p_src_act_id ,
4176: l_mesg_text,
4177: 'GENERAL'
4178: );

Line 4263: ams_cpyutility_pvt.write_log_mesg( p_src_act_type,

4259: p_errmsg := substr(l_mesg_text||' , '||
4260: TO_CHAR (l_stmt_num) ||
4261: ' , ' || '): ' || l_counter ||
4262: ' OF ' || x_msg_count, 1, 4000);
4263: ams_cpyutility_pvt.write_log_mesg( p_src_act_type,
4264: p_new_act_id,
4265: p_errmsg,
4266: 'ERROR'
4267: );

Line 4275: ams_cpyutility_pvt.get_attachment_name (

4271: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
4272: l_mesg_text := fnd_message.get;
4273: p_errmsg := SUBSTR ( l_mesg_text ||
4274: ' - ' ||
4275: ams_cpyutility_pvt.get_attachment_name (
4276: attachments_rec.attachment_id),
4277: 1, 4000);
4278: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
4279: p_src_act_id,

Line 4278: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,

4274: ' - ' ||
4275: ams_cpyutility_pvt.get_attachment_name (
4276: attachments_rec.attachment_id),
4277: 1, 4000);
4278: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
4279: p_src_act_id,
4280: p_errmsg,
4281: 'ERROR');
4282: END IF;

Line 4304: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,

4300: l_mesg_text := fnd_message.get;
4301: p_errmsg := SUBSTR ( l_mesg_text || ' , ' ||
4302: TO_CHAR (l_stmt_num) || ' , ' || '): ' ||
4303: p_errcode || SQLERRM, 1, 4000);
4304: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
4305: p_src_act_id ,
4306: p_errmsg,
4307: 'ERROR'
4308: );

Line 4378: ams_cpyutility_pvt.write_log_mesg( p_src_act_type,

4374: p_errnum := 1;
4375: p_errmsg := substr(l_mesg_text||' , '|| TO_CHAR (l_stmt_num) ||
4376: ' , ' || '): ' || l_counter ||
4377: ' OF ' || l_msg_count, 1, 4000);
4378: ams_cpyutility_pvt.write_log_mesg( p_src_act_type,
4379: p_src_act_id,
4380: p_errmsg,
4381: 'ERROR'
4382: );

Line 4443: ams_cpyutility_pvt.write_log_mesg( p_src_act_type,

4439: p_errnum := 1;
4440: p_errmsg := substr(l_mesg_text||' , '|| TO_CHAR (l_stmt_num) ||
4441: ' , ' || '): ' || l_counter ||
4442: ' OF ' || l_msg_count, 1, 4000);
4443: ams_cpyutility_pvt.write_log_mesg( p_src_act_type,
4444: p_src_act_id,
4445: p_errmsg,
4446: 'ERROR'
4447: );

Line 4501: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,

4497:
4498: fnd_message.set_name ('AMS', 'AMS_COPY_ELEMENTS');
4499: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
4500: l_mesg_text := fnd_message.get;
4501: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
4502: p_src_act_id,
4503: l_mesg_text,
4504: 'GENERAL'
4505: );

Line 4587: ams_cpyutility_pvt.write_log_mesg( p_src_act_type,

4583: p_errnum := 1;
4584: p_errmsg := substr(l_mesg_text||' , '|| TO_CHAR (l_stmt_num) ||
4585: ' , ' || '): ' || l_counter ||
4586: ' OF ' || x_msg_count, 1, 4000);
4587: ams_cpyutility_pvt.write_log_mesg( p_src_act_type,
4588: p_src_act_id,
4589: p_errmsg,
4590: 'ERROR'
4591: );

Line 4599: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,

4595: fnd_message.set_name ('AMS', 'AMS_COPY_ERROR2');
4596: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
4597: l_mesg_text := fnd_message.get;
4598: p_errmsg := SUBSTR ( l_mesg_text || ' - ' || task_rec.task_name,1, 4000);
4599: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
4600: p_src_act_id,
4601: p_errmsg,
4602: 'ERROR'
4603: );

Line 4622: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,

4618: fnd_message.set_name ('AMS', 'AMS_COPY_ERROR2');
4619: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
4620: l_mesg_text := fnd_message.get;
4621: p_errmsg := l_mesg_text || task_rec.task_name || p_errmsg;
4622: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
4623: p_src_act_id,
4624: p_errmsg,
4625: 'ERROR'
4626: );

Line 4634: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,

4630: fnd_message.set_name ('AMS', 'AMS_END_COPY_ELEMENTS');
4631: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
4632: fnd_message.set_token('ELEMENT_NAME',' ' ,TRUE);
4633: l_mesg_text := fnd_message.get;
4634: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
4635: p_src_act_id,
4636: l_mesg_text,
4637: 'GENERAL'
4638: );

Line 4650: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,

4646: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
4647: l_mesg_text := fnd_message.get;
4648: p_errmsg := SUBSTR ( l_mesg_text || TO_CHAR (l_stmt_num) || ',' ||
4649: '): ' || p_errcode || SQLERRM, 1, 4000);
4650: ams_cpyutility_pvt.write_log_mesg ( p_src_act_type,
4651: p_src_act_id,
4652: p_errmsg,
4653: 'ERROR'
4654: );