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.PO_SOURCING_PVT dependencies on PO_DEBUG

Line 31: g_debug_stmt CONSTANT BOOLEAN := PO_DEBUG.is_debug_stmt_on;

27: --------------------------------------------------------------------------------
28:
29: g_pkg_name CONSTANT VARCHAR2(30) := 'PO_SOURCING_PVT';
30: g_log_head CONSTANT VARCHAR2(30) := 'po.plsql.PO_SOURCING_PVT.';
31: g_debug_stmt CONSTANT BOOLEAN := PO_DEBUG.is_debug_stmt_on;
32: g_debug_unexp CONSTANT BOOLEAN := PO_DEBUG.is_debug_unexp_on;
33:
34:
35: --SQL WHAT: Selects the records from the po_headers_interface table

Line 32: g_debug_unexp CONSTANT BOOLEAN := PO_DEBUG.is_debug_unexp_on;

28:
29: g_pkg_name CONSTANT VARCHAR2(30) := 'PO_SOURCING_PVT';
30: g_log_head CONSTANT VARCHAR2(30) := 'po.plsql.PO_SOURCING_PVT.';
31: g_debug_stmt CONSTANT BOOLEAN := PO_DEBUG.is_debug_stmt_on;
32: g_debug_unexp CONSTANT BOOLEAN := PO_DEBUG.is_debug_unexp_on;
33:
34:
35: --SQL WHAT: Selects the records from the po_headers_interface table
36: --SQL WHY: These values are used in creating a Purchase Order

Line 203: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);

199: x_date date;
200: l_api_name CONSTANT VARCHAR2(30) := 'get_system_defaults';
201: BEGIN
202: IF g_debug_stmt THEN
203: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);
204: END IF;
205:
206: -- Get WHO column values
207: g_who_rec.user_id := nvl(fnd_global.user_id,0);

Line 271: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);

267: x_gl_date => x_date);
268: END IF;
269:
270: IF g_debug_stmt THEN
271: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);
272: END IF;
273:
274: EXCEPTION
275: WHEN OTHERS THEN

Line 278: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

274: EXCEPTION
275: WHEN OTHERS THEN
276: g_progress:='030';
277: IF g_debug_unexp THEN
278: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
279: p_token => g_progress,
280: p_message => SQLERRM);
281: END IF;
282:

Line 340: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

336: --Using the procedure po_core_s.get_po_parameters
337: g_progress := '200';
338:
339: IF g_debug_stmt THEN
340: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
341: p_token => g_progress,
342: p_message => 'Before calling get_system_defaults');
343: END IF;
344:

Line 349: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

345: get_system_defaults(p_interface_header_id => g_cpa_csr.interface_header_id);
346:
347: g_progress := '201';
348: IF g_debug_stmt THEN
349: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
350: p_token => g_progress,
351: p_message => 'After calling get_system_defaults');
352: END IF;
353:

Line 364: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

360: -- Default the relevant vendor information
361: IF(g_cpa_csr.vendor_id is not null) THEN
362: g_progress := '202';
363: IF g_debug_stmt THEN
364: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
365: p_token => g_progress,
366: p_message => 'Before calling get_vendor_info');
367: END IF;
368:

Line 388: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

384: );
385:
386: g_progress := '203';
387: IF g_debug_stmt THEN
388: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
389: p_token => g_progress,
390: p_message => 'After calling get_vendor_info');
391: END IF;
392:

Line 400: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

396: -- po_vendor_sites_sv.get_vendor_site_info
397: IF(g_cpa_csr.vendor_site_id is not null) THEN
398: g_progress := '204';
399: IF g_debug_stmt THEN
400: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
401: p_token => g_progress,
402: p_message => 'Before calling get_vendor_site_info');
403: END IF;
404:

Line 420: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

416: );
417:
418: g_progress := '205';
419: IF g_debug_stmt THEN
420: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
421: p_token => g_progress,
422: p_message => 'After calling get_vendor_site_info');
423: END IF;
424:

Line 547: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

543: WHEN FND_API.G_EXC_ERROR THEN
544: x_return_status := FND_API.G_RET_STS_ERROR;
545: g_progress := '210';
546: IF g_debug_stmt THEN
547: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
548: p_token => g_progress,
549: p_message => 'Expected Error');
550: END IF;
551: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 555: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

551: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
552: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
553: g_progress := '211';
554: IF g_debug_unexp THEN
555: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
556: p_token => g_progress,
557: p_message => 'Unexpected Error');
558: END IF;
559: WHEN OTHERS THEN

Line 563: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

559: WHEN OTHERS THEN
560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
561: g_progress := '212';
562: IF g_debug_unexp THEN
563: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
564: p_token => g_progress,
565: p_message => SQLERRM);
566: END IF;
567: FND_MSG_PUB.add_exc_msg(

Line 618: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

614: IF g_cpa_csr.document_num IS NOT NULL THEN
615: IF g_cpa_csr.document_num <> 'CPA 11.5.10+' THEN
616: g_progress := '300';
617: IF g_debug_stmt THEN
618: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
619: p_token => g_progress,
620: p_message => 'Before calling PO_HEADERS_SV6.val_doc_num');
621: END IF;
622: is_valid := PO_HEADERS_SV6.val_doc_num(

Line 630: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

626: X_user_defined_po_num_code => g_params_rec.po_num_code,
627: X_error_code => l_error_code);
628: g_progress := '301';
629: IF g_debug_stmt THEN
630: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
631: p_token => g_progress,
632: p_message => 'After calling PO_HEADERS_SV6.val_doc_num. X_error_code = '||l_error_code);
633: END IF;
634:

Line 639: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

635: IF (is_valid = FALSE ) THEN
636: IF (l_error_code = 'PO_PDOI_DOC_NUM_UNIQUE') THEN
637: g_progress := '302';
638: IF g_debug_stmt THEN
639: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
640: p_token => g_progress,
641: p_message => 'PO_PDOI_DOC_NUM_UNIQUE');
642: END IF;
643: Fnd_message.set_name('PO','PO_PDOI_DOC_NUM_UNIQUE');

Line 653: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

649:
650: ELSIF (l_error_code = 'PO_PDOI_VALUE_NUMERIC') THEN
651: g_progress := '303';
652: IF g_debug_stmt THEN
653: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
654: p_token => g_progress,
655: p_message => 'PO_PDOI_VALUE_NUMERIC');
656: END IF;
657: Fnd_message.set_name('PO','PO_PDOI_VALUE_NUMERIC');

Line 667: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

663: RAISE FND_API.G_EXC_ERROR;
664: ELSIF (l_error_code = 'PO_PDOI_LT_ZERO') THEN
665: g_progress := '304';
666: IF g_debug_stmt THEN
667: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
668: p_token => g_progress,
669: p_message => 'PO_PDOI_LT_ZERO');
670: END IF;
671: Fnd_message.set_name('PO','PO_PDOI_LT_ZERO');

Line 686: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

682: -- This code executes when the document num creation is manual
683: -- and no data is passed from sourcing for document num
684: g_progress := '305';
685: IF g_debug_stmt THEN
686: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
687: p_token => g_progress,
688: p_message => 'PO_PDOI_COLUMN_NOT_NULL');
689: END IF;
690: Fnd_message.set_name('PO','PO_PDOI_COLUMN_NOT_NULL');

Line 701: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

697: -- Validate ship_to_location
698: IF g_cpa_csr.ship_to_location_id IS NOT NULL THEN
699: g_progress := '306';
700: IF g_debug_stmt THEN
701: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
702: p_token => g_progress,
703: p_message => 'Before calling PO_LINE_LOCATIONS_SV1.val_location_id for Ship to location');
704: END IF;
705:

Line 711: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

707: X_location_id => g_cpa_csr.ship_to_location_id,
708: X_location_type => 'SHIP_TO');
709: g_progress := '307';
710: IF g_debug_stmt THEN
711: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
712: p_token => g_progress,
713: p_message => 'After calling PO_LINE_LOCATIONS_SV1.val_location_id for Ship to Location');
714: END IF;
715: IF (is_valid = FALSE) THEN

Line 718: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

714: END IF;
715: IF (is_valid = FALSE) THEN
716: g_progress := '308';
717: IF g_debug_stmt THEN
718: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
719: p_token => g_progress,
720: p_message => 'PO_PDOI_INVALID_SHIP_LOC_ID');
721: END IF;
722: g_cpa_csr.ship_to_location_id := NULL;

Line 730: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

726: -- Validate bill_to_location
727: IF g_cpa_csr.bill_to_location_id IS NOT NULL THEN
728: g_progress := '309';
729: IF g_debug_stmt THEN
730: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
731: p_token => g_progress,
732: p_message => 'Before calling PO_LINE_LOCATIONS_SV1.val_location_id for Bill to location');
733: END IF;
734:

Line 740: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

736: X_location_id => g_cpa_csr.bill_to_location_id,
737: X_location_type => 'BILL_TO');
738: g_progress := '310';
739: IF g_debug_stmt THEN
740: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
741: p_token => g_progress,
742: p_message => 'After calling PO_LINE_LOCATIONS_SV1.val_location_id for Bill to location');
743: END IF;
744:

Line 748: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

744:
745: IF (is_valid = FALSE) THEN
746: g_progress := '311';
747: IF g_debug_stmt THEN
748: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
749: p_token => g_progress,
750: p_message => 'PO_PDOI_INVALID_BILL_LOC_ID');
751: END IF;
752: g_cpa_csr.bill_to_location_id := NULL;

Line 760: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

756: WHEN FND_API.G_EXC_ERROR THEN
757: x_return_status := FND_API.G_RET_STS_ERROR;
758: g_progress := '320';
759: IF g_debug_stmt THEN
760: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
761: p_token => g_progress,
762: p_message => 'Expected Error');
763: END IF;
764: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 768: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

764: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
765: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
766: g_progress := '321';
767: IF g_debug_unexp THEN
768: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
769: p_token => g_progress,
770: p_message => 'Unexpected Error');
771: END IF;
772: WHEN OTHERS THEN

Line 776: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

772: WHEN OTHERS THEN
773: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
774: g_progress := '322';
775: IF g_debug_unexp THEN
776: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
777: p_token => g_progress,
778: p_message => SQLERRM);
779: END IF;
780: FND_MSG_PUB.add_exc_msg(

Line 866: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

862: END IF;
863:
864: g_progress := '400';
865: IF g_debug_stmt THEN
866: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
867: p_token => g_progress,
868: p_message => 'Before calling PO_HEADERS_PKG_S0.Insert_Row');
869: END IF;
870: l_current_org := PO_GA_PVT.get_current_org; --

Line 994: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

990:
991: x_document_id := l_po_header_id;
992: g_progress := '401';
993: IF g_debug_stmt THEN
994: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
995: p_token => g_progress,
996: p_message => 'After calling PO_HEADERS_PKG_S0.Insert_Row. po_header_id = '||l_po_header_id||': Segment1 = '||l_document_num);
997:
998: END IF;

Line 1020: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

1016: l_org_assign_rec.last_update_login := g_cpa_csr.last_update_login;
1017:
1018: g_progress := '402';
1019: IF g_debug_stmt THEN
1020: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
1021: p_token => g_progress,
1022: p_message => 'Before calling PO_GA_ORG_ASSIGN_PVT.Insert_Row');
1023: END IF;
1024:

Line 1032: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

1028: p_org_assign_rec => l_org_assign_rec,
1029: x_row_id => l_org_row_id);
1030: g_progress := '403';
1031: IF g_debug_stmt THEN
1032: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
1033: p_token => g_progress,
1034: p_message => 'After calling PO_GA_ORG_ASSIGN_PVT.Insert_Row');
1035: END IF;
1036:

Line 1049: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

1045: END IF;
1046:
1047: g_progress := '404';
1048: IF g_debug_stmt THEN
1049: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
1050: p_token => g_progress,
1051: p_message => 'Before calling PO_NEGOTIATIONS_SV2.copy_attachments fro PON_AUCTION_HEADERS_ALL');
1052: END IF;
1053:

Line 1077: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

1073: X_column1 => 'NEG');
1074:
1075: g_progress := '405';
1076: IF g_debug_stmt THEN
1077: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
1078: p_token => g_progress,
1079: p_message => 'After calling PO_NEGOTIATIONS_SV2.copy_attachments for PON_AUCTION_HEADERS_ALL');
1080: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
1081: p_token => g_progress,

Line 1080: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

1076: IF g_debug_stmt THEN
1077: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
1078: p_token => g_progress,
1079: p_message => 'After calling PO_NEGOTIATIONS_SV2.copy_attachments for PON_AUCTION_HEADERS_ALL');
1080: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
1081: p_token => g_progress,
1082: p_message => 'Before calling PO_NEGOTIATIONS_SV2.copy_attachments for PON_BID_HEADERS');
1083: END IF;
1084:

Line 1108: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

1104: X_column1 => 'NEG');
1105:
1106: g_progress := '406';
1107: IF g_debug_stmt THEN
1108: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
1109: p_token => g_progress,
1110: p_message => 'After calling PO_NEGOTIATIONS_SV2.copy_attachments for PON_BID_HEADERS');
1111: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
1112: p_token => g_progress,

Line 1111: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

1107: IF g_debug_stmt THEN
1108: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
1109: p_token => g_progress,
1110: p_message => 'After calling PO_NEGOTIATIONS_SV2.copy_attachments for PON_BID_HEADERS');
1111: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
1112: p_token => g_progress,
1113: p_message => 'Before calling PO_NEGOTIATIONS_SV2.add_attch_dynamic for PON_BID_BUYER_NOTES');
1114: END IF;
1115:

Line 1133: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

1129: x_request_id => NULL);
1130:
1131: g_progress := '407';
1132: IF g_debug_stmt THEN
1133: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
1134: p_token => g_progress,
1135: p_message => 'After calling PO_NEGOTIATIONS_SV2.add_attch_dynamic for PON_BID_BUYER_NOTES');
1136: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
1137: p_token => g_progress,

Line 1136: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

1132: IF g_debug_stmt THEN
1133: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
1134: p_token => g_progress,
1135: p_message => 'After calling PO_NEGOTIATIONS_SV2.add_attch_dynamic for PON_BID_BUYER_NOTES');
1136: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
1137: p_token => g_progress,
1138: p_message => 'Before calling PO_NEGOTIATIONS_SV2.add_attch_dynamic for PON_AUC_SUPPLIER_HEADER_NOTES');
1139: END IF;
1140:

Line 1158: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

1154: x_request_id => NULL);
1155:
1156: g_progress := '408';
1157: IF g_debug_stmt THEN
1158: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
1159: p_token => g_progress,
1160: p_message => 'After calling PO_NEGOTIATIONS_SV2.add_attch_dynamic for PON_AUC_SUPPLIER_HEADER_NOTES');
1161: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
1162: p_token => g_progress,

Line 1161: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

1157: IF g_debug_stmt THEN
1158: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
1159: p_token => g_progress,
1160: p_message => 'After calling PO_NEGOTIATIONS_SV2.add_attch_dynamic for PON_AUC_SUPPLIER_HEADER_NOTES');
1161: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
1162: p_token => g_progress,
1163: p_message => 'Before calling PO_NEGOTIATIONS_SV2.add_attch_dynamic for PON_BID_HEADER_ATTRIBUTES');
1164: END IF;
1165: -- Build and attach negotiation/bid header attributes as 'To Supplier'attachment on CPA Header

Line 1182: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

1178: x_request_id => NULL);
1179:
1180: g_progress := '409';
1181: IF g_debug_stmt THEN
1182: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
1183: p_token => g_progress,
1184: p_message => 'After calling PO_NEGOTIATIONS_SV2.add_attch_dynamic for PON_BID_HEADER_ATTRIBUTES');
1185: END IF;
1186: IF (g_params_rec.po_num_code='AUTOMATIC') AND

Line 1191: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

1187: (g_cpa_csr.document_num = 'CPA 11.5.10+') THEN
1188:
1189: g_progress:= '410';
1190: IF g_debug_stmt THEN
1191: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
1192: p_token => g_progress,
1193: p_message => 'Before Selecting document number from po_unique_identifier_cont_all');
1194: END IF;
1195:

Line 1207: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

1203: );
1204:
1205: g_progress:= '411';
1206: IF g_debug_stmt THEN
1207: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
1208: p_token => g_progress,
1209: p_message => 'After Selecting document number from po_unique_identifier_cont_all');
1210: END IF;
1211:

Line 1218: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

1214: END IF;
1215:
1216: g_progress:= '412';
1217: IF g_debug_stmt THEN
1218: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
1219: p_token => g_progress,
1220: p_message => 'Before updating po_headers_all for conterms_exist_flag and document number');
1221: END IF;
1222:

Line 1238: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

1234: WHERE po_header_id = l_po_header_id;
1235:
1236: g_progress:= '413';
1237: IF g_debug_stmt THEN
1238: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
1239: p_token => g_progress,
1240: p_message => 'Before updating po_headers_all for conterms_exist_flag and document number');
1241: END IF;
1242:

Line 1250: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

1246: l_contract_doc_type:= PO_CONTERMS_UTL_GRP.GET_PO_CONTRACT_DOCTYPE(
1247: p_sub_doc_type=>g_cpa_csr.document_subtype);
1248: g_progress:= '414';
1249: IF g_debug_stmt THEN
1250: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
1251: p_token => g_progress,
1252: p_message => 'Contracts template attached'||'-'||'l_contract_doc_type:'||l_contract_doc_type);
1253: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
1254: p_token => g_progress,

Line 1253: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

1249: IF g_debug_stmt THEN
1250: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
1251: p_token => g_progress,
1252: p_message => 'Contracts template attached'||'-'||'l_contract_doc_type:'||l_contract_doc_type);
1253: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
1254: p_token => g_progress,
1255: p_message => 'before call okc_terms_copy_grp.copy_doc');
1256: END IF;
1257:

Line 1278: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

1274: );
1275:
1276: g_progress:='415';
1277: IF g_debug_stmt THEN
1278: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
1279: p_token => g_progress,
1280: p_message => 'after call okc_terms_copy_grp.copy_doc.Return status:'||l_return_status);
1281: END IF;
1282:

Line 1295: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

1291: x_return_status := FND_API.G_RET_STS_ERROR;
1292:
1293: -- put error messages in log
1294: IF g_debug_stmt THEN
1295: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
1296: p_token => g_progress,
1297: p_message => 'Insert_CPA: Inside l_contracts_call_exception');
1298: END IF;
1299: Fnd_message.set_name('PO','PO_API_ERROR');

Line 1309: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

1305:
1306: IF g_debug_stmt THEN
1307: l_msg_count := FND_MSG_PUB.Count_Msg;
1308: FOR i IN 1..l_msg_count LOOP
1309: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
1310: p_token => g_progress||'_EXCEPTION_'||i,
1311: p_message => FND_MSG_PUB.Get(p_msg_index=>i,p_encoded =>'F'));
1312: END LOOP;
1313: END IF;

Line 1318: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

1314: WHEN OTHERS THEN
1315: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1316: g_progress := '417';
1317: IF g_debug_unexp THEN
1318: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
1319: p_token => g_progress,
1320: p_message => SQLERRM);
1321: END IF;
1322: FND_MSG_PUB.add_exc_msg(

Line 1404: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

1400:
1401: IF g_interface_cursor%NOTFOUND THEN
1402: CLOSE g_interface_cursor;
1403: IF g_debug_stmt THEN
1404: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
1405: p_token => g_progress,
1406: p_message => 'PO_ALL_NO_DRILLDOWN: '||SQLERRM);
1407: END IF;
1408: Fnd_message.set_name('PO','PO_ALL_NO_DRILLDOWN');

Line 1421: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

1417: IF l_document_subtype = 'CONTRACT' THEN
1418: IF l_action = 'NEW' THEN
1419: g_progress := '501';
1420: IF g_debug_stmt THEN
1421: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
1422: p_token => g_progress,
1423: p_message => 'Before calling po_sourcing_pvt.default_cpa');
1424: END IF;
1425: -- Default the required fields in the record

Line 1432: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

1428: );
1429:
1430: g_progress := '502';
1431: IF g_debug_stmt THEN
1432: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
1433: p_token => g_progress,
1434: p_message => 'After calling po_sourcing_pvt.default_cpa');
1435: END IF;
1436:

Line 1448: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

1444:
1445: -- Validate the required fields in the record
1446: g_progress := '503';
1447: IF g_debug_stmt THEN
1448: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
1449: p_token => g_progress,
1450: p_message => 'Before calling po_sourcing_pvt.validate_cpa');
1451: END IF;
1452:

Line 1459: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

1455: );
1456:
1457: g_progress := '504';
1458: IF g_debug_stmt THEN
1459: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
1460: p_token => g_progress,
1461: p_message => 'After calling po_sourcing_pvt.validate_cpa');
1462: END IF;
1463:

Line 1475: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

1471:
1472: -- Insert record in the po_headers table and add attachments and contract terms
1473: g_progress := '505';
1474: IF g_debug_stmt THEN
1475: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
1476: p_token => g_progress,
1477: p_message => 'Before calling po_sourcing_pvt.insert_cpa');
1478: END IF;
1479:

Line 1493: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

1489: );
1490:
1491: g_progress := '506';
1492: IF g_debug_stmt THEN
1493: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
1494: p_token => g_progress,
1495: p_message => 'After calling po_sourcing_pvt.insert_cpa');
1496: END IF;
1497:

Line 1509: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

1505:
1506: ELSE
1507: g_progress := '507';
1508: IF g_debug_stmt THEN
1509: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
1510: p_token => g_progress,
1511: p_message => 'Invalid Action in the interface table');
1512: END IF;
1513: Fnd_message.set_name('PO','PO_PDOI_INVALID_ACTION');

Line 1522: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

1518: END IF; -- End of l_action = 'NEW'
1519: ELSE
1520: g_progress := '508';
1521: IF g_debug_stmt THEN
1522: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
1523: p_token => g_progress,
1524: p_message => 'Invalid Document Subtype Code in the interface table');
1525: END IF;
1526: Fnd_message.set_name('PO','PO_PDOI_INVALID_VALUE');

Line 1542: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

1538: x_document_id := NULL;
1539: x_return_status := FND_API.G_RET_STS_ERROR;
1540: g_progress := '510';
1541: IF g_debug_stmt THEN
1542: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
1543: p_token => g_progress,
1544: p_message => 'Expected Error');
1545: END IF;
1546:

Line 1553: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

1549: x_document_id := NULL;
1550: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1551: g_progress := '511';
1552: IF g_debug_unexp THEN
1553: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
1554: p_token => g_progress,
1555: p_message => 'Unexpected Error');
1556: END IF;
1557: WHEN OTHERS THEN

Line 1563: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

1559: x_document_id := NULL;
1560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1561: g_progress := '512';
1562: IF g_debug_unexp THEN
1563: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
1564: p_token => g_progress,
1565: p_message => SQLERRM);
1566: END IF;
1567:

Line 1616: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

1612: WHERE interface_header_id = p_interface_header_id;
1613:
1614: g_progress := '600';
1615: IF g_debug_stmt THEN
1616: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
1617: p_token => g_progress,
1618: p_message => 'No of Records deleted from PO_HEADERS_INTERFACE'||SQL%rowcount);
1619: END IF;
1620: EXCEPTION

Line 1625: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

1621: WHEN OTHERS THEN
1622: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1623: g_progress := '601';
1624: IF g_debug_unexp THEN
1625: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
1626: p_token => g_progress,
1627: p_message => SQLERRM);
1628: END IF;
1629: FND_MSG_PUB.add_exc_msg(