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_COPYDOC_SUB dependencies on PO_COPYDOC_S1

Line 364: po_copydoc_s1.online_report(x_online_report_id,

360: x_fob_lookup_code := NULL;
361: x_freight_terms_lu_code := NULL;
362: x_terms_id := NULL;
363: fnd_message.set_name('PO', 'PO_MISSING_FSP_VALUES');
364: po_copydoc_s1.online_report(x_online_report_id,
365: x_sequence,
366: substr(fnd_message.get, 1, 240),
367: 0, 0, 0);
368: WHEN OTHERS THEN

Line 375: po_copydoc_s1.copydoc_sql_error('get_fsp_values', x_progress, sqlcode,

371: x_ship_via_lookup_code := NULL;
372: x_fob_lookup_code := NULL;
373: x_freight_terms_lu_code := NULL;
374: x_terms_id := NULL;
375: po_copydoc_s1.copydoc_sql_error('get_fsp_values', x_progress, sqlcode,
376: x_online_report_id,
377: x_sequence,
378: 0, 0, 0);
379: END get_fsp_values;

Line 428: po_copydoc_s1.copydoc_sql_error('get_vendor_values', x_progress, sqlcode,

424: x_terms_id,
425: x_online_report_id,
426: x_sequence);
427: WHEN OTHERS THEN
428: po_copydoc_s1.copydoc_sql_error('get_vendor_values', x_progress, sqlcode,
429: x_online_report_id,
430: x_sequence,
431: 0, 0, 0);
432: get_fsp_values(x_ship_to_location_id,

Line 491: po_copydoc_s1.copydoc_sql_error('get_vendor_site_values', x_progress, sqlcode,

487: x_terms_id,
488: x_online_report_id,
489: x_sequence);
490: WHEN OTHERS THEN
491: po_copydoc_s1.copydoc_sql_error('get_vendor_site_values', x_progress, sqlcode,
492: x_online_report_id,
493: x_sequence,
494: 0, 0, 0);
495: get_vendor_values(x_vendor_id,

Line 523: po_copydoc_s1.online_report(x_online_report_id,

519: -- unless DB is corrupted.
520:
521: IF (x_buyer_id IS NULL) THEN
522: fnd_message.set_name('PO', 'PO_PO_MISSING_BUYER_ID');
523: po_copydoc_s1.online_report(x_online_report_id,
524: x_sequence,
525: substr(fnd_message.get, 1, 240),
526: 0, 0, 0);
527:

Line 545: po_copydoc_s1.online_report(x_online_report_id,

541: EXCEPTION
542: WHEN NO_DATA_FOUND THEN
543: x_buyer_id := NULL;
544: fnd_message.set_name('PO', 'PO_RI_INVALID_SUGGESTED_BUYER');
545: po_copydoc_s1.online_report(x_online_report_id,
546: x_sequence,
547: substr(fnd_message.get, 1, 240),
548: 0, 0, 0);
549: WHEN OTHERS THEN

Line 551: po_copydoc_s1.copydoc_sql_error('validate_buyer_id', x_progress, sqlcode,

547: substr(fnd_message.get, 1, 240),
548: 0, 0, 0);
549: WHEN OTHERS THEN
550: x_buyer_id := NULL;
551: po_copydoc_s1.copydoc_sql_error('validate_buyer_id', x_progress, sqlcode,
552: x_online_report_id,
553: x_sequence,
554: 0, 0, 0);
555:

Line 593: po_copydoc_s1.online_report(x_online_report_id,

589: WHEN NO_DATA_FOUND THEN
590: fnd_message.set_name('PO', 'PO_PDOI_INVALID_VENDOR');
591: fnd_message.set_token('VALUE', to_char(x_vendor_id), FALSE);
592: x_vendor_id := NULL;
593: po_copydoc_s1.online_report(x_online_report_id,
594: x_sequence,
595: substr(fnd_message.get, 1, 240),
596: 0, 0, 0);
597: WHEN OTHERS THEN

Line 599: po_copydoc_s1.copydoc_sql_error('validate_vendor', x_progress, sqlcode,

595: substr(fnd_message.get, 1, 240),
596: 0, 0, 0);
597: WHEN OTHERS THEN
598: x_vendor_id := NULL;
599: po_copydoc_s1.copydoc_sql_error('validate_vendor', x_progress, sqlcode,
600: x_online_report_id,
601: x_sequence,
602: 0, 0, 0);
603: END;

Line 624: po_copydoc_s1.online_report(x_online_report_id,

620: WHEN NO_DATA_FOUND THEN
621: fnd_message.set_name('PO', 'PO_PDOI_INVALID_VENDOR_SITE');
622: fnd_message.set_token('VALUE', to_char(x_vendor_site_id), FALSE);
623: x_vendor_site_id := NULL;
624: po_copydoc_s1.online_report(x_online_report_id,
625: x_sequence,
626: substr(fnd_message.get, 1, 240),
627: 0, 0, 0);
628: WHEN OTHERS THEN

Line 630: po_copydoc_s1.copydoc_sql_error('validate_vendor', x_progress, sqlcode,

626: substr(fnd_message.get, 1, 240),
627: 0, 0, 0);
628: WHEN OTHERS THEN
629: x_vendor_site_id := NULL;
630: po_copydoc_s1.copydoc_sql_error('validate_vendor', x_progress, sqlcode,
631: x_online_report_id,
632: x_sequence,
633: 0, 0, 0);
634: END;

Line 653: po_copydoc_s1.online_report(x_online_report_id,

649: WHEN NO_DATA_FOUND THEN
650: fnd_message.set_name('PO', 'PO_PDOI_INVALID_VDR_CNTCT');
651: fnd_message.set_token('VALUE', to_char(x_vendor_contact_id), FALSE);
652: x_vendor_contact_id := NULL;
653: po_copydoc_s1.online_report(x_online_report_id,
654: x_sequence,
655: substr(fnd_message.get, 1, 240),
656: 0, 0, 0);
657: WHEN OTHERS THEN

Line 659: po_copydoc_s1.copydoc_sql_error('validate_vendor', x_progress, sqlcode,

655: substr(fnd_message.get, 1, 240),
656: 0, 0, 0);
657: WHEN OTHERS THEN
658: x_vendor_contact_id := NULL;
659: po_copydoc_s1.copydoc_sql_error('validate_vendor', x_progress, sqlcode,
660: x_online_report_id,
661: x_sequence,
662: 0, 0, 0);
663: END;

Line 747: po_copydoc_s1.online_report(x_online_report_id,

743: EXCEPTION
744: WHEN NO_DATA_FOUND THEN
745: x_ship_to_location_id := NULL;
746: fnd_message.set_name('PO', 'PO_PO_SHIP_LOCN_INVALID');
747: po_copydoc_s1.online_report(x_online_report_id,
748: x_sequence,
749: substr(fnd_message.get, 1, 240),
750: 0, 0, 0);
751: WHEN OTHERS THEN

Line 753: po_copydoc_s1.copydoc_sql_error('validate_location_terms', x_progress, sqlcode,

749: substr(fnd_message.get, 1, 240),
750: 0, 0, 0);
751: WHEN OTHERS THEN
752: x_ship_to_location_id := NULL;
753: po_copydoc_s1.copydoc_sql_error('validate_location_terms', x_progress, sqlcode,
754: x_online_report_id,
755: x_sequence,
756: 0, 0, 0);
757: END;

Line 772: po_copydoc_s1.online_report(x_online_report_id,

768: WHEN NO_DATA_FOUND THEN
769: fnd_message.set_name('PO', 'PO_PDOI_INVALID_BILL_LOC_ID');
770: fnd_message.set_token('VALUE', to_char(x_bill_to_location_id));
771: x_bill_to_location_id := NULL;
772: po_copydoc_s1.online_report(x_online_report_id,
773: x_sequence,
774: substr(fnd_message.get, 1, 240),
775: 0, 0, 0);
776: WHEN OTHERS THEN

Line 778: po_copydoc_s1.copydoc_sql_error('validate_location_terms', x_progress, sqlcode,

774: substr(fnd_message.get, 1, 240),
775: 0, 0, 0);
776: WHEN OTHERS THEN
777: x_bill_to_location_id := NULL;
778: po_copydoc_s1.copydoc_sql_error('validate_location_terms', x_progress, sqlcode,
779: x_online_report_id,
780: x_sequence,
781: 0, 0, 0);
782: END;

Line 799: po_copydoc_s1.online_report(x_online_report_id,

795: WHEN NO_DATA_FOUND THEN
796: fnd_message.set_name('PO', 'PO_PDOI_INVALID_FOB');
797: fnd_message.set_token('VALUE', x_fob_lookup_code, FALSE);
798: x_fob_lookup_code := NULL;
799: po_copydoc_s1.online_report(x_online_report_id,
800: x_sequence,
801: substr(fnd_message.get, 1, 240),
802: 0, 0, 0);
803: WHEN OTHERS THEN

Line 805: po_copydoc_s1.copydoc_sql_error('validate_location_terms', x_progress, sqlcode,

801: substr(fnd_message.get, 1, 240),
802: 0, 0, 0);
803: WHEN OTHERS THEN
804: x_fob_lookup_code := NULL;
805: po_copydoc_s1.copydoc_sql_error('validate_location_terms', x_progress, sqlcode,
806: x_online_report_id,
807: x_sequence,
808: 0, 0, 0);
809: END;

Line 826: po_copydoc_s1.online_report(x_online_report_id,

822: WHEN NO_DATA_FOUND THEN
823: fnd_message.set_name('PO', 'PO_PDOI_INVALID_FREIGHT_TERMS');
824: fnd_message.set_token('VALUE', x_freight_terms_lu_code, FALSE);
825: x_freight_terms_lu_code := NULL;
826: po_copydoc_s1.online_report(x_online_report_id,
827: x_sequence,
828: substr(fnd_message.get, 1, 240),
829: 0, 0, 0);
830: WHEN OTHERS THEN

Line 832: po_copydoc_s1.copydoc_sql_error('validate_location_terms', x_progress, sqlcode,

828: substr(fnd_message.get, 1, 240),
829: 0, 0, 0);
830: WHEN OTHERS THEN
831: x_freight_terms_lu_code := NULL;
832: po_copydoc_s1.copydoc_sql_error('validate_location_terms', x_progress, sqlcode,
833: x_online_report_id,
834: x_sequence,
835: 0, 0, 0);
836: END;

Line 851: po_copydoc_s1.online_report(x_online_report_id,

847: WHEN NO_DATA_FOUND THEN
848: fnd_message.set_name('PO', 'PO_PDOI_INVALID_PAY_TERMS');
849: fnd_message.set_token('VALUE', to_char(x_terms_id), FALSE);
850: x_terms_id := NULL;
851: po_copydoc_s1.online_report(x_online_report_id,
852: x_sequence,
853: substr(fnd_message.get, 1, 240),
854: 0, 0, 0);
855: WHEN OTHERS THEN

Line 857: po_copydoc_s1.copydoc_sql_error('validate_location_terms', x_progress, sqlcode,

853: substr(fnd_message.get, 1, 240),
854: 0, 0, 0);
855: WHEN OTHERS THEN
856: x_terms_id := NULL;
857: po_copydoc_s1.copydoc_sql_error('validate_location_terms', x_progress, sqlcode,
858: x_online_report_id,
859: x_sequence,
860: 0, 0, 0);
861: END;

Line 900: po_copydoc_s1.online_report(x_online_report_id,

896: WHEN NO_DATA_FOUND THEN
897: fnd_message.set_name('PO', 'PO_PDOI_ITEM_INVALID');
898: fnd_message.set_token('ITEM', to_char(x_item_id), FALSE);
899: x_item_id := NULL;
900: po_copydoc_s1.online_report(x_online_report_id,
901: x_sequence,
902: substr(fnd_message.get, 1, 240),
903: x_line_num, 0, 0);
904: x_return_code := -1;

Line 908: po_copydoc_s1.copydoc_sql_error('validate_item', x_progress, sqlcode,

904: x_return_code := -1;
905: RETURN;
906: WHEN OTHERS THEN
907: x_item_id := NULL;
908: po_copydoc_s1.copydoc_sql_error('validate_item', x_progress, sqlcode,
909: x_online_report_id,
910: x_sequence,
911: x_line_num, 0, 0);
912: RETURN;

Line 939: po_copydoc_s1.online_report(x_online_report_id,

935: WHEN NO_DATA_FOUND THEN
936: x_item_id := NULL;
937: -- Bug 3488117: Truncate at 2000 characters instead of 240.
938: fnd_message.set_name('PO', 'PO_RI_LINE_TYPE_ITEM_MISMATCH');
939: po_copydoc_s1.online_report(x_online_report_id,
940: x_sequence,
941: substr(fnd_message.get, 1, 2000),
942: x_line_num, 0, 0);
943: x_return_code := -1;

Line 947: po_copydoc_s1.copydoc_sql_error('validate_item', x_progress, sqlcode,

943: x_return_code := -1;
944: RETURN;
945: WHEN OTHERS THEN
946: x_item_id := NULL;
947: po_copydoc_s1.copydoc_sql_error('validate_item', x_progress, sqlcode,
948: x_online_report_id,
949: x_sequence,
950: x_line_num, 0, 0);
951: x_return_code := -1;

Line 967: po_copydoc_s1.online_report(x_online_report_id,

963: EXCEPTION
964: WHEN NO_DATA_FOUND THEN
965: x_item_id := NULL;
966: fnd_message.set_name('PO', 'PO_PDOI_MISMATCH_ITEM_ITEMTYPE');
967: po_copydoc_s1.online_report(x_online_report_id,
968: x_sequence,
969: substr(fnd_message.get, 1, 240),
970: x_line_num, 0, 0);
971: x_return_code := -1;

Line 975: po_copydoc_s1.copydoc_sql_error('validate_item', x_progress, sqlcode,

971: x_return_code := -1;
972: RETURN;
973: WHEN OTHERS THEN
974: x_item_id := NULL;
975: po_copydoc_s1.copydoc_sql_error('validate_item', x_progress, sqlcode,
976: x_online_report_id,
977: x_sequence,
978: x_line_num, 0, 0);
979: x_return_code := -1;

Line 996: po_copydoc_s1.online_report(x_online_report_id,

992: WHEN NO_DATA_FOUND THEN
993: fnd_message.set_name('PO', 'PO_RI_INVALID_ITEM_REVISION');
994: fnd_message.set_token('VALUE', x_item_revision);
995: x_item_revision := NULL;
996: po_copydoc_s1.online_report(x_online_report_id,
997: x_sequence,
998: substr(fnd_message.get, 1, 240),
999: x_line_num, 0, 0);
1000: WHEN OTHERS THEN

Line 1002: po_copydoc_s1.copydoc_sql_error('validate_item', x_progress, sqlcode,

998: substr(fnd_message.get, 1, 240),
999: x_line_num, 0, 0);
1000: WHEN OTHERS THEN
1001: x_item_revision := NULL;
1002: po_copydoc_s1.copydoc_sql_error('validate_item', x_progress, sqlcode,
1003: x_online_report_id,
1004: x_sequence,
1005: x_line_num, 0, 0);
1006: END;

Line 1025: po_copydoc_s1.online_report(x_online_report_id,

1021: WHEN NO_DATA_FOUND THEN
1022: fnd_message.set_name('PO', 'PO_PO_MISSING_CATEGORY');
1023: fnd_message.set_token('ITEM', to_char(x_item_id), FALSE);
1024: x_category_id := NULL;
1025: po_copydoc_s1.online_report(x_online_report_id,
1026: x_sequence,
1027: substr(fnd_message.get, 1, 240),
1028: x_line_num, 0, 0);
1029: x_return_code := -1;

Line 1033: po_copydoc_s1.copydoc_sql_error('validate_item', x_progress, sqlcode,

1029: x_return_code := -1;
1030: RETURN;
1031: WHEN OTHERS THEN
1032: x_category_id := NULL;
1033: po_copydoc_s1.copydoc_sql_error('validate_item', x_progress, sqlcode,
1034: x_online_report_id,
1035: x_sequence,
1036: x_line_num, 0, 0);
1037: x_return_code := -1;

Line 1066: po_copydoc_s1.online_report(x_online_report_id,

1062: WHEN NO_DATA_FOUND THEN
1063: x_category_id := NULL;
1064: -- Bug 3488117: Truncate at 2000 characters instead of 240.
1065: fnd_message.set_name('PO', 'PO_RI_INVALID_CATEGORY_ID');
1066: po_copydoc_s1.online_report(x_online_report_id,
1067: x_sequence,
1068: substr(fnd_message.get, 1, 2000),
1069: x_line_num, 0, 0);
1070: x_return_code := -1;

Line 1074: po_copydoc_s1.copydoc_sql_error('validate_item', x_progress, sqlcode,

1070: x_return_code := -1;
1071: RETURN;
1072: WHEN OTHERS THEN
1073: x_category_id := NULL;
1074: po_copydoc_s1.copydoc_sql_error('validate_item', x_progress, sqlcode,
1075: x_online_report_id,
1076: x_sequence,
1077: x_line_num, 0, 0);
1078: x_return_code := -1;

Line 1089: po_copydoc_s1.online_report(x_online_report_id,

1085: ELSE
1086: x_item_revision := NULL;
1087: IF (x_category_id IS NULL) THEN
1088: fnd_message.set_name('PO', 'PO_RI_CAT_ID_ITEM_DESC_MISSING');
1089: po_copydoc_s1.online_report(x_online_report_id,
1090: x_sequence,
1091: substr(fnd_message.get, 1, 240),
1092: x_line_num, 0, 0);
1093: x_return_code := -1;

Line 1153: po_copydoc_s1.online_report(x_online_report_id,

1149: EXCEPTION
1150: WHEN NO_DATA_FOUND THEN
1151: x_category_id := NULL;
1152: fnd_message.set_name('PO', 'PO_RI_INVALID_CATEGORY_ID');
1153: po_copydoc_s1.online_report(x_online_report_id,
1154: x_sequence,
1155: substr(fnd_message.get, 1, 240),
1156: x_line_num, 0, 0);
1157: x_return_code := -1;

Line 1161: po_copydoc_s1.copydoc_sql_error('validate_item', x_progress, sqlcode,

1157: x_return_code := -1;
1158: RETURN;
1159: WHEN OTHERS THEN
1160: x_category_id := NULL;
1161: po_copydoc_s1.copydoc_sql_error('validate_item', x_progress, sqlcode,
1162: x_online_report_id,
1163: x_sequence,
1164: x_line_num, 0, 0);
1165: x_return_code := -1;

Line 1171: po_copydoc_s1.online_report(x_online_report_id,

1167: END;
1168: END IF;
1169: IF (x_item_description IS NULL) THEN
1170: fnd_message.set_name('PO', 'PO_RI_CAT_ID_ITEM_DESC_MISSING');
1171: po_copydoc_s1.online_report(x_online_report_id,
1172: x_sequence,
1173: substr(fnd_message.get, 1, 240),
1174: x_line_num, 0, 0);
1175: x_return_code := -1;

Line 1184: po_copydoc_s1.copydoc_sql_error('validate_item', x_progress, sqlcode,

1180: x_return_code := 0;
1181:
1182: EXCEPTION
1183: WHEN OTHERS THEN
1184: po_copydoc_s1.copydoc_sql_error('validate_item', x_progress, sqlcode,
1185: x_online_report_id,
1186: x_sequence,
1187: x_line_num, 0, 0);
1188: x_return_code := -1;

Line 1239: po_copydoc_s1.online_report(x_online_report_id,

1235: fnd_message.set_name('PO', 'PO_RI_INVALID_CHARGE_ACC_ID');
1236: ELSIF x_account_type = 'VARIANCE' THEN
1237: fnd_message.set_name('PO', 'PO_RI_INVALID_VARIANCE_ACC_ID');
1238: END IF;
1239: po_copydoc_s1.online_report(x_online_report_id,
1240: x_sequence,
1241: substr(fnd_message.get, 1, 240),
1242: x_line_num, x_shipment_num, x_distribution_num);
1243:

Line 1246: po_copydoc_s1.copydoc_sql_error('validate_account_id', x_progress, sqlcode,

1242: x_line_num, x_shipment_num, x_distribution_num);
1243:
1244: WHEN OTHERS THEN
1245: x_account_id :=NULL;
1246: po_copydoc_s1.copydoc_sql_error('validate_account_id', x_progress, sqlcode,
1247: x_online_report_id,
1248: x_sequence,
1249: x_line_num, x_shipment_num, x_distribution_num);
1250: -- RAISE COPYDOC_DIST_FAILURE;

Line 1321: po_copydoc_s1.online_report(x_online_report_id,

1317: WHEN NO_DATA_FOUND THEN
1318: x_project_id := NULL;
1319: -- Bug 3488117: Truncate at 2000 characters instead of 240.
1320: fnd_message.set_name('PO', 'PO_RI_INVALID_PA_INFO');
1321: po_copydoc_s1.online_report(x_online_report_id,
1322: x_sequence,
1323: substr(fnd_message.get, 1, 2000),
1324: x_line_num, x_shipment_num, x_distribution_num);
1325:

Line 1328: po_copydoc_s1.copydoc_sql_error('validate_project_id', x_progress, sqlcode,

1324: x_line_num, x_shipment_num, x_distribution_num);
1325:
1326: WHEN OTHERS THEN
1327: x_project_id :=NULL;
1328: po_copydoc_s1.copydoc_sql_error('validate_project_id', x_progress, sqlcode,
1329: x_online_report_id,
1330: x_sequence,
1331: x_line_num, x_shipment_num, x_distribution_num);
1332:

Line 1369: po_copydoc_s1.online_report(x_online_report_id,

1365: WHEN NO_DATA_FOUND THEN
1366: x_task_id := NULL;
1367: -- Bug 3488177: Truncate at 2000 characters instead of 240.
1368: fnd_message.set_name('PO', 'PO_RI_INVALID_PA_INFO');
1369: po_copydoc_s1.online_report(x_online_report_id,
1370: x_sequence,
1371: substr(fnd_message.get, 1, 2000),
1372: x_line_num, x_shipment_num, x_distribution_num);
1373:

Line 1376: po_copydoc_s1.copydoc_sql_error('validate_task_id', x_progress, sqlcode,

1372: x_line_num, x_shipment_num, x_distribution_num);
1373:
1374: WHEN OTHERS THEN
1375: x_task_id :=NULL;
1376: po_copydoc_s1.copydoc_sql_error('validate_task_id', x_progress, sqlcode,
1377: x_online_report_id,
1378: x_sequence,
1379: x_line_num, x_shipment_num, x_distribution_num);
1380: -- RAISE COPYDOC_DIST_FAILURE;

Line 1423: po_copydoc_s1.online_report(x_online_report_id,

1419: EXCEPTION
1420: WHEN NO_DATA_FOUND THEN
1421: x_exp_item_date := NULL;
1422: fnd_message.set_name('PO', 'PO_RI_INVALID_PA_INFO');
1423: po_copydoc_s1.online_report(x_online_report_id,
1424: x_sequence,
1425: substr(fnd_message.get, 1, 2000),
1426: x_line_num, x_shipment_num, x_distribution_num);
1427:

Line 1430: po_copydoc_s1.copydoc_sql_error('validate_exp_item_date', x_progress, sqlcode,

1426: x_line_num, x_shipment_num, x_distribution_num);
1427:
1428: WHEN OTHERS THEN
1429: x_exp_item_date := NULL;
1430: po_copydoc_s1.copydoc_sql_error('validate_exp_item_date', x_progress, sqlcode,
1431: x_online_report_id,
1432: x_sequence,
1433: x_line_num, x_shipment_num, x_distribution_num);
1434: END validate_exp_item_date;

Line 1468: po_copydoc_s1.online_report(x_online_report_id,

1464: EXCEPTION
1465: WHEN NO_DATA_FOUND THEN
1466: x_exp_type := NULL;
1467: fnd_message.set_name('PO', 'PO_RI_INVALID_PA_INFO');
1468: po_copydoc_s1.online_report(x_online_report_id,
1469: x_sequence,
1470: substr(fnd_message.get, 1, 2000),
1471: x_line_num, x_shipment_num, x_distribution_num);
1472:

Line 1475: po_copydoc_s1.copydoc_sql_error('validate_exp_type', x_progress, sqlcode,

1471: x_line_num, x_shipment_num, x_distribution_num);
1472:
1473: WHEN OTHERS THEN
1474: x_exp_type := NULL;
1475: po_copydoc_s1.copydoc_sql_error('validate_exp_type', x_progress, sqlcode,
1476: x_online_report_id,
1477: x_sequence,
1478: x_line_num, x_shipment_num, x_distribution_num);
1479: END validate_exp_type;

Line 1507: po_copydoc_s1.online_report(x_online_report_id,

1503: EXCEPTION
1504: WHEN NO_DATA_FOUND THEN
1505: x_org_id := NULL;
1506: fnd_message.set_name('PO', 'PO_RI_INVALID_PA_INFO');
1507: po_copydoc_s1.online_report(x_online_report_id,
1508: x_sequence,
1509: substr(fnd_message.get, 1, 2000),
1510: x_line_num, x_shipment_num, x_distribution_num);
1511:

Line 1514: po_copydoc_s1.copydoc_sql_error('validate_exp_org', x_progress, sqlcode,

1510: x_line_num, x_shipment_num, x_distribution_num);
1511:
1512: WHEN OTHERS THEN
1513: x_org_id := NULL;
1514: po_copydoc_s1.copydoc_sql_error('validate_exp_org', x_progress, sqlcode,
1515: x_online_report_id,
1516: x_sequence,
1517: x_line_num, x_shipment_num, x_distribution_num);
1518: END validate_exp_org;

Line 1674: po_copydoc_s1.online_report(x_online_report_id,

1670: EXCEPTION
1671: WHEN NO_DATA_FOUND THEN
1672: x_destination_type_code := NULL;
1673: fnd_message.set_name('PO', 'PO_RI_INVALID_DEST_TYPE_CODE');
1674: po_copydoc_s1.online_report(x_online_report_id,
1675: x_sequence,
1676: substr(fnd_message.get, 1, 240),
1677: x_line_num, x_shipment_num, x_distribution_num);
1678:

Line 1681: po_copydoc_s1.copydoc_sql_error('validate_destination_type_code', x_progress, sqlcode,

1677: x_line_num, x_shipment_num, x_distribution_num);
1678:
1679: WHEN OTHERS THEN
1680: x_destination_type_code := NULL;
1681: po_copydoc_s1.copydoc_sql_error('validate_destination_type_code', x_progress, sqlcode,
1682: x_online_report_id,
1683: x_sequence,
1684: x_line_num, x_shipment_num, x_distribution_num);
1685:

Line 1721: po_copydoc_s1.online_report(x_online_report_id,

1717: EXCEPTION
1718: WHEN NO_DATA_FOUND THEN
1719: x_deliver_to_person_id := NULL;
1720: fnd_message.set_name('PO', 'PO_PO_INVALID_DEL_TO_PERSON');
1721: po_copydoc_s1.online_report(x_online_report_id,
1722: x_sequence,
1723: substr(fnd_message.get, 1, 240),
1724: x_line_num, x_shipment_num, x_distribution_num);
1725:

Line 1728: po_copydoc_s1.copydoc_sql_error('validate_deliver_to_person_id', x_progress, sqlcode,

1724: x_line_num, x_shipment_num, x_distribution_num);
1725:
1726: WHEN OTHERS THEN
1727: x_deliver_to_person_id := NULL;
1728: po_copydoc_s1.copydoc_sql_error('validate_deliver_to_person_id', x_progress, sqlcode,
1729: x_online_report_id,
1730: x_sequence,
1731: x_line_num, x_shipment_num, x_distribution_num);
1732: -- RAISE COPYDOC_DIST_FAILURE;

Line 1790: po_copydoc_s1.online_report(x_online_report_id,

1786: end if;
1787: if (x_count < 1) then
1788: -- register error
1789: fnd_message.set_name('PO', 'PO_PO_INVALID_JOB');
1790: po_copydoc_s1.online_report(x_online_report_id,
1791: x_sequence,
1792: substr(fnd_message.get, 1, 240),
1793: x_line_num, x_shipment_num,
1794: x_distribution_num);

Line 1809: po_copydoc_s1.online_report(x_online_report_id,

1805: and organization_id = x_destination_organization_id;
1806: if (x_count < 1) then
1807: -- register error
1808: fnd_message.set_name('PO', 'PO_PO_INVALID_JOB_LINE');
1809: po_copydoc_s1.online_report(x_online_report_id,
1810: x_sequence,
1811: substr(fnd_message.get, 1, 240),
1812: x_line_num, x_shipment_num,
1813: x_distribution_num);

Line 1853: po_copydoc_s1.online_report(x_online_report_id,

1849: end if; /* x_entity_type =6 */
1850: if (x_count < 1) then
1851: -- register error
1852: fnd_message.set_name('PO', 'PO_PO_INVALID_OPERATION_SEQ');
1853: po_copydoc_s1.online_report(x_online_report_id,
1854: x_sequence,
1855: substr(fnd_message.get, 1, 240),
1856: x_line_num, x_shipment_num,
1857: x_distribution_num);

Line 1877: po_copydoc_s1.online_report(x_online_report_id,

1873:
1874: if (x_count < 1) then
1875: -- register error
1876: fnd_message.set_name('PO', 'PO_PO_INVALID_RESOURCE_SEQ');
1877: po_copydoc_s1.online_report(x_online_report_id,
1878: x_sequence,
1879: substr(fnd_message.get, 1, 240),
1880: x_line_num, x_shipment_num,
1881: x_distribution_num);

Line 1887: po_copydoc_s1.copydoc_sql_error('PO_COPYDOC_SUB.validate_osp_data',

1883: end if;
1884:
1885: EXCEPTION
1886: WHEN OTHERS THEN
1887: po_copydoc_s1.copydoc_sql_error('PO_COPYDOC_SUB.validate_osp_data',
1888: x_progress, sqlcode,
1889: x_online_report_id,
1890: x_sequence,
1891: x_line_num,

Line 1942: po_copydoc_s1.online_report(x_online_report_id,

1938: WHEN NO_DATA_FOUND THEN
1939: x_deliver_to_location_id := NULL;
1940: fnd_message.set_name('PO', 'PO_RI_INVALID_DEL_LOC_ID_DEST');
1941: -- Bug 3488117: Changed trunc size from 240 to 2000.
1942: po_copydoc_s1.online_report(x_online_report_id,
1943: x_sequence,
1944: substr(fnd_message.get, 1, 2000),
1945: x_line_num, x_shipment_num, x_distribution_num);
1946:

Line 1949: po_copydoc_s1.copydoc_sql_error('validate_deliver_to_loc_id', x_progress, sqlcode,

1945: x_line_num, x_shipment_num, x_distribution_num);
1946:
1947: WHEN OTHERS THEN
1948: x_deliver_to_location_id := NULL;
1949: po_copydoc_s1.copydoc_sql_error('validate_deliver_to_loc_id', x_progress, sqlcode,
1950: x_online_report_id,
1951: x_sequence,
1952: x_line_num, x_shipment_num, x_distribution_num);
1953: -- RAISE COPYDOC_DIST_FAILURE;

Line 2005: po_copydoc_s1.online_report(x_online_report_id,

2001: EXCEPTION
2002: WHEN NO_DATA_FOUND THEN
2003: x_destination_subinventory := NULL;
2004: fnd_message.set_name('PO', 'PO_RI_INVALID_DEST_SUBINV');
2005: po_copydoc_s1.online_report(x_online_report_id,
2006: x_sequence,
2007: substr(fnd_message.get, 1, 240),
2008: x_line_num, x_shipment_num, x_distribution_num);
2009:

Line 2012: po_copydoc_s1.copydoc_sql_error('validate_dest_subinventory', x_progress, sqlcode,

2008: x_line_num, x_shipment_num, x_distribution_num);
2009:
2010: WHEN OTHERS THEN
2011: x_destination_subinventory :=NULL;
2012: po_copydoc_s1.copydoc_sql_error('validate_dest_subinventory', x_progress, sqlcode,
2013: x_online_report_id,
2014: x_sequence,
2015: x_line_num, x_shipment_num, x_distribution_num);
2016:

Line 2074: po_copydoc_s1.online_report(x_online_report_id,

2070:
2071: fnd_message.set_name('PO', 'PO_PO_INVALID_CONTRACT');
2072: fnd_message.set_token('VALUE', l_contract_doc_num, FALSE); --
2073:
2074: po_copydoc_s1.online_report(x_online_report_id,
2075: x_sequence,
2076: substr(fnd_message.get, 1, 240),
2077: x_line_num, 0, 0);
2078: WHEN OTHERS THEN

Line 2080: po_copydoc_s1.copydoc_sql_error('validate_contract_num', x_progress, sqlcode,

2076: substr(fnd_message.get, 1, 240),
2077: x_line_num, 0, 0);
2078: WHEN OTHERS THEN
2079:
2080: po_copydoc_s1.copydoc_sql_error('validate_contract_num', x_progress, sqlcode,
2081: x_online_report_id,
2082: x_sequence,
2083: x_line_num, 0, 0);
2084:

Line 2118: po_copydoc_s1.online_report(p_online_report_id,

2114:
2115: EXCEPTION
2116: WHEN NO_DATA_FOUND THEN
2117: fnd_message.set_name('PO', 'PO_SUB_CP_INVALID_GA_REF');
2118: po_copydoc_s1.online_report(p_online_report_id,
2119: p_sequence,
2120: substr(fnd_message.get, 1, 240),
2121: p_line_num, 0, 0);
2122: WHEN OTHERS THEN

Line 2123: po_copydoc_s1.copydoc_sql_error('validate_global_ref', l_progress, sqlcode,

2119: p_sequence,
2120: substr(fnd_message.get, 1, 240),
2121: p_line_num, 0, 0);
2122: WHEN OTHERS THEN
2123: po_copydoc_s1.copydoc_sql_error('validate_global_ref', l_progress, sqlcode,
2124: p_online_report_id,
2125: p_sequence,
2126: p_line_num, 0, 0);
2127:

Line 2220: po_copydoc_s1.online_report(p_online_report_id,

2216: fnd_message.set_name('PO', 'PO_SVC_JOB_INVALID_IN_HR');
2217: fnd_message.set_token('JOB', l_job_name);
2218: END IF;
2219:
2220: po_copydoc_s1.online_report(p_online_report_id,
2221: p_sequence,
2222: substr(fnd_message.get, 1, 240),
2223: p_line_num, 0, 0);
2224: End;

Line 2252: po_copydoc_s1.online_report(p_online_report_id,

2248: When no_data_found Then
2249: fnd_message.set_name('PO', 'PO_SVC_JOB_ASSOC_INVALID');
2250: fnd_message.set_token('JOB', l_job_name);
2251: fnd_message.set_token('CATEGORY', l_category);
2252: po_copydoc_s1.online_report(p_online_report_id,
2253: p_sequence,
2254: substr(fnd_message.get, 1, 240),
2255: p_line_num, 0, 0);
2256: End;

Line 2262: po_copydoc_s1.copydoc_sql_error('validate_job', l_progress, sqlcode,

2258: l_progress := '050';
2259:
2260: EXCEPTION
2261: WHEN OTHERS THEN
2262: po_copydoc_s1.copydoc_sql_error('validate_job', l_progress, sqlcode,
2263: p_online_report_id,
2264: p_sequence,
2265: p_line_num, 0, 0);
2266: END;

Line 2694: po_copydoc_s1.online_report(x_online_report_id,

2690: , X_billable_flag => X_billable_flag);
2691:
2692: IF x_msg_type = 'E' and x_msg_data is not NULL THEN
2693: -- Write the message to the PO_ONLINE_REPORT_TEXT table as an error.
2694: po_copydoc_s1.online_report(x_online_report_id,
2695: x_sequence, x_msg_data,
2696: x_line_num, x_shipment_num, x_distribution_num,
2697: PO_COPYDOC_S1.G_ERROR_MESSAGE_TYPE);
2698: ELSIF x_msg_type = 'W' and x_msg_data is not NULL THEN

Line 2697: PO_COPYDOC_S1.G_ERROR_MESSAGE_TYPE);

2693: -- Write the message to the PO_ONLINE_REPORT_TEXT table as an error.
2694: po_copydoc_s1.online_report(x_online_report_id,
2695: x_sequence, x_msg_data,
2696: x_line_num, x_shipment_num, x_distribution_num,
2697: PO_COPYDOC_S1.G_ERROR_MESSAGE_TYPE);
2698: ELSIF x_msg_type = 'W' and x_msg_data is not NULL THEN
2699: -- Write the message to the PO_ONLINE_REPORT_TEXT table as a warning.
2700: po_copydoc_s1.online_report(x_online_report_id,
2701: x_sequence, x_msg_data,

Line 2700: po_copydoc_s1.online_report(x_online_report_id,

2696: x_line_num, x_shipment_num, x_distribution_num,
2697: PO_COPYDOC_S1.G_ERROR_MESSAGE_TYPE);
2698: ELSIF x_msg_type = 'W' and x_msg_data is not NULL THEN
2699: -- Write the message to the PO_ONLINE_REPORT_TEXT table as a warning.
2700: po_copydoc_s1.online_report(x_online_report_id,
2701: x_sequence, x_msg_data,
2702: x_line_num, x_shipment_num, x_distribution_num,
2703: PO_COPYDOC_S1.G_WARNING_MESSAGE_TYPE);
2704: END IF;

Line 2703: PO_COPYDOC_S1.G_WARNING_MESSAGE_TYPE);

2699: -- Write the message to the PO_ONLINE_REPORT_TEXT table as a warning.
2700: po_copydoc_s1.online_report(x_online_report_id,
2701: x_sequence, x_msg_data,
2702: x_line_num, x_shipment_num, x_distribution_num,
2703: PO_COPYDOC_S1.G_WARNING_MESSAGE_TYPE);
2704: END IF;
2705: --
2706:
2707: --

Line 2724: po_copydoc_s1.online_report(x_online_report_id,

2720: x_return_code => l_val_proj_result);
2721:
2722: IF ( l_val_proj_result = PO_PROJECT_DETAILS_SV.pjm_validate_failure) THEN
2723: -- Write the message to the PO_ONLINE_REPORT_TEXT table as an error.
2724: po_copydoc_s1.online_report(x_online_report_id,
2725: x_sequence, FND_MESSAGE.get,
2726: x_line_num, x_shipment_num, x_distribution_num,
2727: PO_COPYDOC_S1.G_ERROR_MESSAGE_TYPE);
2728: ELSIF ( l_val_proj_result = PO_PROJECT_DETAILS_SV.pjm_validate_warning) THEN

Line 2727: PO_COPYDOC_S1.G_ERROR_MESSAGE_TYPE);

2723: -- Write the message to the PO_ONLINE_REPORT_TEXT table as an error.
2724: po_copydoc_s1.online_report(x_online_report_id,
2725: x_sequence, FND_MESSAGE.get,
2726: x_line_num, x_shipment_num, x_distribution_num,
2727: PO_COPYDOC_S1.G_ERROR_MESSAGE_TYPE);
2728: ELSIF ( l_val_proj_result = PO_PROJECT_DETAILS_SV.pjm_validate_warning) THEN
2729: -- Write the message to the PO_ONLINE_REPORT_TEXT table as a warning.
2730: po_copydoc_s1.online_report(x_online_report_id,
2731: x_sequence, FND_MESSAGE.get,

Line 2730: po_copydoc_s1.online_report(x_online_report_id,

2726: x_line_num, x_shipment_num, x_distribution_num,
2727: PO_COPYDOC_S1.G_ERROR_MESSAGE_TYPE);
2728: ELSIF ( l_val_proj_result = PO_PROJECT_DETAILS_SV.pjm_validate_warning) THEN
2729: -- Write the message to the PO_ONLINE_REPORT_TEXT table as a warning.
2730: po_copydoc_s1.online_report(x_online_report_id,
2731: x_sequence, FND_MESSAGE.get,
2732: x_line_num, x_shipment_num, x_distribution_num,
2733: PO_COPYDOC_S1.G_WARNING_MESSAGE_TYPE);
2734: END IF;

Line 2733: PO_COPYDOC_S1.G_WARNING_MESSAGE_TYPE);

2729: -- Write the message to the PO_ONLINE_REPORT_TEXT table as a warning.
2730: po_copydoc_s1.online_report(x_online_report_id,
2731: x_sequence, FND_MESSAGE.get,
2732: x_line_num, x_shipment_num, x_distribution_num,
2733: PO_COPYDOC_S1.G_WARNING_MESSAGE_TYPE);
2734: END IF;
2735: --< Bug 3265539 End >
2736:
2737: END IF; /* destination type is 'EXPENSE' */

Line 2808: po_copydoc_s1.copydoc_sql_error('submission_check_copydoc', x_progress, sqlcode,

2804: END IF; -- doc is encumbered BPA check
2805:
2806: EXCEPTION
2807: WHEN OTHERS THEN
2808: po_copydoc_s1.copydoc_sql_error('submission_check_copydoc', x_progress, sqlcode,
2809: x_online_report_id,
2810: x_sequence,
2811: x_line_num,x_shipment_num,x_distribution_num);
2812:

Line 2905: PO_COPYDOC_S1.online_report

2901: END IF; --< if txn flow header ID not null >
2902:
2903: EXCEPTION
2904: WHEN FND_API.g_exc_error THEN
2905: PO_COPYDOC_S1.online_report
2906: (x_online_report_id => p_online_report_id,
2907: x_sequence => x_sequence,
2908: x_message => FND_MESSAGE.get,
2909: x_line_num => p_line_num,

Line 2913: PO_COPYDOC_S1.copydoc_sql_error

2909: x_line_num => p_line_num,
2910: x_shipment_num => p_shipment_num,
2911: x_distribution_num => 0);
2912: WHEN OTHERS THEN
2913: PO_COPYDOC_S1.copydoc_sql_error
2914: (x_routine => 'PO_COPYDOC_SUB.validate_transaction_flow',
2915: x_progress => l_progress,
2916: x_sqlcode => SQLCODE,
2917: x_online_report_id => p_online_report_id,

Line 2995: l_message_type := PO_COPYDOC_S1.g_error_message_type;

2991: l_progress := '010';
2992:
2993: l_user_id := FND_GLOBAL.user_id;
2994: l_login_id := FND_GLOBAL.login_id;
2995: l_message_type := PO_COPYDOC_S1.g_error_message_type;
2996: l_err_prefix := FND_MESSAGE.get_string(appin => 'PO',
2997: namein => 'PO_GA_ORG_ASSIGN_PREFIX');
2998:
2999: --------------------------------------------------------------

Line 3175: PO_COPYDOC_S1.copydoc_sql_error

3171: WHEN l_populate_failed_exc THEN
3172: -- If caught, error already inserted, so do nothing here.
3173: NULL;
3174: WHEN OTHERS THEN
3175: PO_COPYDOC_S1.copydoc_sql_error
3176: (x_routine => 'PO_COPYDOC_SUB.validate_org_assignments',
3177: x_progress => l_progress,
3178: x_sqlcode => SQLCODE,
3179: x_online_report_id => p_online_report_id,

Line 3279: PO_COPYDOC_S1.copydoc_sql_error

3275:
3276: EXCEPTION
3277: WHEN OTHERS THEN
3278: x_return_status := FND_API.g_ret_sts_unexp_error;
3279: PO_COPYDOC_S1.copydoc_sql_error
3280: (x_routine => 'PO_COPYDOC_SUB.populate_session_gt',
3281: x_progress => l_progress,
3282: x_sqlcode => SQLCODE,
3283: x_online_report_id => p_online_report_id,