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 FND_MESSAGE

Line 406: fnd_message.set_name('PO', 'PO_MISSING_FSP_VALUES');

402: x_ship_via_lookup_code := NULL;
403: x_fob_lookup_code := NULL;
404: x_freight_terms_lu_code := NULL;
405: x_terms_id := NULL;
406: fnd_message.set_name('PO', 'PO_MISSING_FSP_VALUES');
407: po_copydoc_s1.online_report(x_online_report_id,
408: x_sequence,
409: substr(fnd_message.get, 1, 240),
410: 0, 0, 0);

Line 409: substr(fnd_message.get, 1, 240),

405: x_terms_id := NULL;
406: fnd_message.set_name('PO', 'PO_MISSING_FSP_VALUES');
407: po_copydoc_s1.online_report(x_online_report_id,
408: x_sequence,
409: substr(fnd_message.get, 1, 240),
410: 0, 0, 0);
411: WHEN OTHERS THEN
412: x_ship_to_location_id := NULL;
413: x_bill_to_location_id := NULL;

Line 565: fnd_message.set_name('PO', 'PO_PO_MISSING_BUYER_ID');

561: -- This field has to be not NULL, because it's a mandatory field.
562: -- unless DB is corrupted.
563:
564: IF (x_buyer_id IS NULL) THEN
565: fnd_message.set_name('PO', 'PO_PO_MISSING_BUYER_ID');
566: po_copydoc_s1.online_report(x_online_report_id,
567: x_sequence,
568: substr(fnd_message.get, 1, 240),
569: 0, 0, 0);

Line 568: substr(fnd_message.get, 1, 240),

564: IF (x_buyer_id IS NULL) THEN
565: fnd_message.set_name('PO', 'PO_PO_MISSING_BUYER_ID');
566: po_copydoc_s1.online_report(x_online_report_id,
567: x_sequence,
568: substr(fnd_message.get, 1, 240),
569: 0, 0, 0);
570:
571: ELSE
572: x_progress := '001';

Line 587: fnd_message.set_name('PO', 'PO_RI_INVALID_SUGGESTED_BUYER');

583:
584: EXCEPTION
585: WHEN NO_DATA_FOUND THEN
586: x_buyer_id := NULL;
587: fnd_message.set_name('PO', 'PO_RI_INVALID_SUGGESTED_BUYER');
588: po_copydoc_s1.online_report(x_online_report_id,
589: x_sequence,
590: substr(fnd_message.get, 1, 240),
591: 0, 0, 0);

Line 590: substr(fnd_message.get, 1, 240),

586: x_buyer_id := NULL;
587: fnd_message.set_name('PO', 'PO_RI_INVALID_SUGGESTED_BUYER');
588: po_copydoc_s1.online_report(x_online_report_id,
589: x_sequence,
590: substr(fnd_message.get, 1, 240),
591: 0, 0, 0);
592: WHEN OTHERS THEN
593: x_buyer_id := NULL;
594: po_copydoc_s1.copydoc_sql_error('validate_buyer_id', x_progress, sqlcode,

Line 633: fnd_message.set_name('PO', 'PO_PDOI_INVALID_VENDOR');

629: AND SYSDATE BETWEEN nvl(start_date_active, SYSDATE-1)
630: AND nvl(end_date_active, SYSDATE+1);
631: EXCEPTION
632: WHEN NO_DATA_FOUND THEN
633: fnd_message.set_name('PO', 'PO_PDOI_INVALID_VENDOR');
634: fnd_message.set_token('VALUE', to_char(x_vendor_id), FALSE);
635: x_vendor_id := NULL;
636: po_copydoc_s1.online_report(x_online_report_id,
637: x_sequence,

Line 634: fnd_message.set_token('VALUE', to_char(x_vendor_id), FALSE);

630: AND nvl(end_date_active, SYSDATE+1);
631: EXCEPTION
632: WHEN NO_DATA_FOUND THEN
633: fnd_message.set_name('PO', 'PO_PDOI_INVALID_VENDOR');
634: fnd_message.set_token('VALUE', to_char(x_vendor_id), FALSE);
635: x_vendor_id := NULL;
636: po_copydoc_s1.online_report(x_online_report_id,
637: x_sequence,
638: substr(fnd_message.get, 1, 240),

Line 638: substr(fnd_message.get, 1, 240),

634: fnd_message.set_token('VALUE', to_char(x_vendor_id), FALSE);
635: x_vendor_id := NULL;
636: po_copydoc_s1.online_report(x_online_report_id,
637: x_sequence,
638: substr(fnd_message.get, 1, 240),
639: 0, 0, 0);
640: WHEN OTHERS THEN
641: x_vendor_id := NULL;
642: po_copydoc_s1.copydoc_sql_error('validate_vendor', x_progress, sqlcode,

Line 664: fnd_message.set_name('PO', 'PO_PDOI_INVALID_VENDOR_SITE');

660: AND purchasing_site_flag = 'Y'
661: AND SYSDATE < nvl(inactive_date, SYSDATE + 1);
662: EXCEPTION
663: WHEN NO_DATA_FOUND THEN
664: fnd_message.set_name('PO', 'PO_PDOI_INVALID_VENDOR_SITE');
665: fnd_message.set_token('VALUE', to_char(x_vendor_site_id), FALSE);
666: x_vendor_site_id := NULL;
667: po_copydoc_s1.online_report(x_online_report_id,
668: x_sequence,

Line 665: fnd_message.set_token('VALUE', to_char(x_vendor_site_id), FALSE);

661: AND SYSDATE < nvl(inactive_date, SYSDATE + 1);
662: EXCEPTION
663: WHEN NO_DATA_FOUND THEN
664: fnd_message.set_name('PO', 'PO_PDOI_INVALID_VENDOR_SITE');
665: fnd_message.set_token('VALUE', to_char(x_vendor_site_id), FALSE);
666: x_vendor_site_id := NULL;
667: po_copydoc_s1.online_report(x_online_report_id,
668: x_sequence,
669: substr(fnd_message.get, 1, 240),

Line 669: substr(fnd_message.get, 1, 240),

665: fnd_message.set_token('VALUE', to_char(x_vendor_site_id), FALSE);
666: x_vendor_site_id := NULL;
667: po_copydoc_s1.online_report(x_online_report_id,
668: x_sequence,
669: substr(fnd_message.get, 1, 240),
670: 0, 0, 0);
671: WHEN OTHERS THEN
672: x_vendor_site_id := NULL;
673: po_copydoc_s1.copydoc_sql_error('validate_vendor', x_progress, sqlcode,

Line 693: fnd_message.set_name('PO', 'PO_PDOI_INVALID_VDR_CNTCT');

689: AND vendor_site_id = x_vendor_site_id
690: AND SYSDATE < nvl(inactive_date, SYSDATE+1);
691: EXCEPTION
692: WHEN NO_DATA_FOUND THEN
693: fnd_message.set_name('PO', 'PO_PDOI_INVALID_VDR_CNTCT');
694: fnd_message.set_token('VALUE', to_char(x_vendor_contact_id), FALSE);
695: x_vendor_contact_id := NULL;
696: po_copydoc_s1.online_report(x_online_report_id,
697: x_sequence,

Line 694: fnd_message.set_token('VALUE', to_char(x_vendor_contact_id), FALSE);

690: AND SYSDATE < nvl(inactive_date, SYSDATE+1);
691: EXCEPTION
692: WHEN NO_DATA_FOUND THEN
693: fnd_message.set_name('PO', 'PO_PDOI_INVALID_VDR_CNTCT');
694: fnd_message.set_token('VALUE', to_char(x_vendor_contact_id), FALSE);
695: x_vendor_contact_id := NULL;
696: po_copydoc_s1.online_report(x_online_report_id,
697: x_sequence,
698: substr(fnd_message.get, 1, 240),

Line 698: substr(fnd_message.get, 1, 240),

694: fnd_message.set_token('VALUE', to_char(x_vendor_contact_id), FALSE);
695: x_vendor_contact_id := NULL;
696: po_copydoc_s1.online_report(x_online_report_id,
697: x_sequence,
698: substr(fnd_message.get, 1, 240),
699: 0, 0, 0);
700: WHEN OTHERS THEN
701: x_vendor_contact_id := NULL;
702: po_copydoc_s1.copydoc_sql_error('validate_vendor', x_progress, sqlcode,

Line 790: fnd_message.set_name('PO', 'PO_PO_SHIP_LOCN_INVALID');

786: AND (set_of_books_id IS NULL OR set_of_books_id = x_sob_id);
787: EXCEPTION
788: WHEN NO_DATA_FOUND THEN
789: x_ship_to_location_id := NULL;
790: fnd_message.set_name('PO', 'PO_PO_SHIP_LOCN_INVALID');
791: po_copydoc_s1.online_report(x_online_report_id,
792: x_sequence,
793: substr(fnd_message.get, 1, 240),
794: 0, 0, 0);

Line 793: substr(fnd_message.get, 1, 240),

789: x_ship_to_location_id := NULL;
790: fnd_message.set_name('PO', 'PO_PO_SHIP_LOCN_INVALID');
791: po_copydoc_s1.online_report(x_online_report_id,
792: x_sequence,
793: substr(fnd_message.get, 1, 240),
794: 0, 0, 0);
795: WHEN OTHERS THEN
796: x_ship_to_location_id := NULL;
797: po_copydoc_s1.copydoc_sql_error('validate_location_terms', x_progress, sqlcode,

Line 813: fnd_message.set_name('PO', 'PO_PDOI_INVALID_BILL_LOC_ID');

809: FROM HR_BILLING_LOCATIONS_PO_V
810: WHERE location_id = x_bill_to_location_id;
811: EXCEPTION
812: WHEN NO_DATA_FOUND THEN
813: fnd_message.set_name('PO', 'PO_PDOI_INVALID_BILL_LOC_ID');
814: fnd_message.set_token('VALUE', to_char(x_bill_to_location_id));
815: x_bill_to_location_id := NULL;
816: po_copydoc_s1.online_report(x_online_report_id,
817: x_sequence,

Line 814: fnd_message.set_token('VALUE', to_char(x_bill_to_location_id));

810: WHERE location_id = x_bill_to_location_id;
811: EXCEPTION
812: WHEN NO_DATA_FOUND THEN
813: fnd_message.set_name('PO', 'PO_PDOI_INVALID_BILL_LOC_ID');
814: fnd_message.set_token('VALUE', to_char(x_bill_to_location_id));
815: x_bill_to_location_id := NULL;
816: po_copydoc_s1.online_report(x_online_report_id,
817: x_sequence,
818: substr(fnd_message.get, 1, 240),

Line 818: substr(fnd_message.get, 1, 240),

814: fnd_message.set_token('VALUE', to_char(x_bill_to_location_id));
815: x_bill_to_location_id := NULL;
816: po_copydoc_s1.online_report(x_online_report_id,
817: x_sequence,
818: substr(fnd_message.get, 1, 240),
819: 0, 0, 0);
820: WHEN OTHERS THEN
821: x_bill_to_location_id := NULL;
822: po_copydoc_s1.copydoc_sql_error('validate_location_terms', x_progress, sqlcode,

Line 841: fnd_message.set_name('PO', 'PO_PDOI_INVALID_FOB');

837: AND SYSDATE < nvl(inactive_date, SYSDATE+1)
838: AND lookup_code = x_fob_lookup_code;
839: EXCEPTION
840: WHEN NO_DATA_FOUND THEN
841: fnd_message.set_name('PO', 'PO_PDOI_INVALID_FOB');
842: fnd_message.set_token('VALUE', x_fob_lookup_code, FALSE);
843: x_fob_lookup_code := NULL;
844: po_copydoc_s1.online_report(x_online_report_id,
845: x_sequence,

Line 842: fnd_message.set_token('VALUE', x_fob_lookup_code, FALSE);

838: AND lookup_code = x_fob_lookup_code;
839: EXCEPTION
840: WHEN NO_DATA_FOUND THEN
841: fnd_message.set_name('PO', 'PO_PDOI_INVALID_FOB');
842: fnd_message.set_token('VALUE', x_fob_lookup_code, FALSE);
843: x_fob_lookup_code := NULL;
844: po_copydoc_s1.online_report(x_online_report_id,
845: x_sequence,
846: substr(fnd_message.get, 1, 240),

Line 846: substr(fnd_message.get, 1, 240),

842: fnd_message.set_token('VALUE', x_fob_lookup_code, FALSE);
843: x_fob_lookup_code := NULL;
844: po_copydoc_s1.online_report(x_online_report_id,
845: x_sequence,
846: substr(fnd_message.get, 1, 240),
847: 0, 0, 0);
848: WHEN OTHERS THEN
849: x_fob_lookup_code := NULL;
850: po_copydoc_s1.copydoc_sql_error('validate_location_terms', x_progress, sqlcode,

Line 868: fnd_message.set_name('PO', 'PO_PDOI_INVALID_FREIGHT_TERMS');

864: AND SYSDATE < nvl(inactive_date, SYSDATE+1)
865: AND lookup_code = x_freight_terms_lu_code;
866: EXCEPTION
867: WHEN NO_DATA_FOUND THEN
868: fnd_message.set_name('PO', 'PO_PDOI_INVALID_FREIGHT_TERMS');
869: fnd_message.set_token('VALUE', x_freight_terms_lu_code, FALSE);
870: x_freight_terms_lu_code := NULL;
871: po_copydoc_s1.online_report(x_online_report_id,
872: x_sequence,

Line 869: fnd_message.set_token('VALUE', x_freight_terms_lu_code, FALSE);

865: AND lookup_code = x_freight_terms_lu_code;
866: EXCEPTION
867: WHEN NO_DATA_FOUND THEN
868: fnd_message.set_name('PO', 'PO_PDOI_INVALID_FREIGHT_TERMS');
869: fnd_message.set_token('VALUE', x_freight_terms_lu_code, FALSE);
870: x_freight_terms_lu_code := NULL;
871: po_copydoc_s1.online_report(x_online_report_id,
872: x_sequence,
873: substr(fnd_message.get, 1, 240),

Line 873: substr(fnd_message.get, 1, 240),

869: fnd_message.set_token('VALUE', x_freight_terms_lu_code, FALSE);
870: x_freight_terms_lu_code := NULL;
871: po_copydoc_s1.online_report(x_online_report_id,
872: x_sequence,
873: substr(fnd_message.get, 1, 240),
874: 0, 0, 0);
875: WHEN OTHERS THEN
876: x_freight_terms_lu_code := NULL;
877: po_copydoc_s1.copydoc_sql_error('validate_location_terms', x_progress, sqlcode,

Line 893: fnd_message.set_name('PO', 'PO_PDOI_INVALID_PAY_TERMS');

889: FROM AP_TERMS_VAL_V
890: WHERE term_id = x_terms_id;
891: EXCEPTION
892: WHEN NO_DATA_FOUND THEN
893: fnd_message.set_name('PO', 'PO_PDOI_INVALID_PAY_TERMS');
894: fnd_message.set_token('VALUE', to_char(x_terms_id), FALSE);
895: x_terms_id := NULL;
896: po_copydoc_s1.online_report(x_online_report_id,
897: x_sequence,

Line 894: fnd_message.set_token('VALUE', to_char(x_terms_id), FALSE);

890: WHERE term_id = x_terms_id;
891: EXCEPTION
892: WHEN NO_DATA_FOUND THEN
893: fnd_message.set_name('PO', 'PO_PDOI_INVALID_PAY_TERMS');
894: fnd_message.set_token('VALUE', to_char(x_terms_id), FALSE);
895: x_terms_id := NULL;
896: po_copydoc_s1.online_report(x_online_report_id,
897: x_sequence,
898: substr(fnd_message.get, 1, 240),

Line 898: substr(fnd_message.get, 1, 240),

894: fnd_message.set_token('VALUE', to_char(x_terms_id), FALSE);
895: x_terms_id := NULL;
896: po_copydoc_s1.online_report(x_online_report_id,
897: x_sequence,
898: substr(fnd_message.get, 1, 240),
899: 0, 0, 0);
900: WHEN OTHERS THEN
901: x_terms_id := NULL;
902: po_copydoc_s1.copydoc_sql_error('validate_location_terms', x_progress, sqlcode,

Line 943: fnd_message.set_name('PO', 'PO_PDOI_ITEM_INVALID');

939: AND purchasing_enabled_flag = 'Y'
940: AND organization_id = x_inv_org_id;
941: EXCEPTION
942: WHEN NO_DATA_FOUND THEN
943: fnd_message.set_name('PO', 'PO_PDOI_ITEM_INVALID');
944: fnd_message.set_token('ITEM', to_char(x_item_id), FALSE);
945: x_item_id := NULL;
946: po_copydoc_s1.online_report(x_online_report_id,
947: x_sequence,

Line 944: fnd_message.set_token('ITEM', to_char(x_item_id), FALSE);

940: AND organization_id = x_inv_org_id;
941: EXCEPTION
942: WHEN NO_DATA_FOUND THEN
943: fnd_message.set_name('PO', 'PO_PDOI_ITEM_INVALID');
944: fnd_message.set_token('ITEM', to_char(x_item_id), FALSE);
945: x_item_id := NULL;
946: po_copydoc_s1.online_report(x_online_report_id,
947: x_sequence,
948: substr(fnd_message.get, 1, 240),

Line 948: substr(fnd_message.get, 1, 240),

944: fnd_message.set_token('ITEM', to_char(x_item_id), FALSE);
945: x_item_id := NULL;
946: po_copydoc_s1.online_report(x_online_report_id,
947: x_sequence,
948: substr(fnd_message.get, 1, 240),
949: x_line_num, 0, 0);
950: x_return_code := -1;
951: RETURN;
952: WHEN OTHERS THEN

Line 984: fnd_message.set_name('PO', 'PO_RI_LINE_TYPE_ITEM_MISMATCH');

980: EXCEPTION
981: WHEN NO_DATA_FOUND THEN
982: x_item_id := NULL;
983: -- Bug 3488117: Truncate at 2000 characters instead of 240.
984: fnd_message.set_name('PO', 'PO_RI_LINE_TYPE_ITEM_MISMATCH');
985: po_copydoc_s1.online_report(x_online_report_id,
986: x_sequence,
987: substr(fnd_message.get, 1, 2000),
988: x_line_num, 0, 0);

Line 987: substr(fnd_message.get, 1, 2000),

983: -- Bug 3488117: Truncate at 2000 characters instead of 240.
984: fnd_message.set_name('PO', 'PO_RI_LINE_TYPE_ITEM_MISMATCH');
985: po_copydoc_s1.online_report(x_online_report_id,
986: x_sequence,
987: substr(fnd_message.get, 1, 2000),
988: x_line_num, 0, 0);
989: x_return_code := -1;
990: RETURN;
991: WHEN OTHERS THEN

Line 1012: fnd_message.set_name('PO', 'PO_PDOI_MISMATCH_ITEM_ITEMTYPE');

1008: AND order_type_lookup_code <> 'AMOUNT';
1009: EXCEPTION
1010: WHEN NO_DATA_FOUND THEN
1011: x_item_id := NULL;
1012: fnd_message.set_name('PO', 'PO_PDOI_MISMATCH_ITEM_ITEMTYPE');
1013: po_copydoc_s1.online_report(x_online_report_id,
1014: x_sequence,
1015: substr(fnd_message.get, 1, 240),
1016: x_line_num, 0, 0);

Line 1015: substr(fnd_message.get, 1, 240),

1011: x_item_id := NULL;
1012: fnd_message.set_name('PO', 'PO_PDOI_MISMATCH_ITEM_ITEMTYPE');
1013: po_copydoc_s1.online_report(x_online_report_id,
1014: x_sequence,
1015: substr(fnd_message.get, 1, 240),
1016: x_line_num, 0, 0);
1017: x_return_code := -1;
1018: RETURN;
1019: WHEN OTHERS THEN

Line 1039: fnd_message.set_name('PO', 'PO_RI_INVALID_ITEM_REVISION');

1035: WHERE revision = x_item_revision
1036: AND inventory_item_id = x_item_id;
1037: EXCEPTION
1038: WHEN NO_DATA_FOUND THEN
1039: fnd_message.set_name('PO', 'PO_RI_INVALID_ITEM_REVISION');
1040: fnd_message.set_token('VALUE', x_item_revision);
1041: x_item_revision := NULL;
1042: po_copydoc_s1.online_report(x_online_report_id,
1043: x_sequence,

Line 1040: fnd_message.set_token('VALUE', x_item_revision);

1036: AND inventory_item_id = x_item_id;
1037: EXCEPTION
1038: WHEN NO_DATA_FOUND THEN
1039: fnd_message.set_name('PO', 'PO_RI_INVALID_ITEM_REVISION');
1040: fnd_message.set_token('VALUE', x_item_revision);
1041: x_item_revision := NULL;
1042: po_copydoc_s1.online_report(x_online_report_id,
1043: x_sequence,
1044: substr(fnd_message.get, 1, 240),

Line 1044: substr(fnd_message.get, 1, 240),

1040: fnd_message.set_token('VALUE', x_item_revision);
1041: x_item_revision := NULL;
1042: po_copydoc_s1.online_report(x_online_report_id,
1043: x_sequence,
1044: substr(fnd_message.get, 1, 240),
1045: x_line_num, 0, 0);
1046: WHEN OTHERS THEN
1047: x_item_revision := NULL;
1048: po_copydoc_s1.copydoc_sql_error('validate_item', x_progress, sqlcode,

Line 1068: fnd_message.set_name('PO', 'PO_PO_MISSING_CATEGORY');

1064: AND MIC.category_set_id = MDSV.category_set_id
1065: AND MDSV.functional_area_id = 2;
1066: EXCEPTION
1067: WHEN NO_DATA_FOUND THEN
1068: fnd_message.set_name('PO', 'PO_PO_MISSING_CATEGORY');
1069: fnd_message.set_token('ITEM', to_char(x_item_id), FALSE);
1070: x_category_id := NULL;
1071: po_copydoc_s1.online_report(x_online_report_id,
1072: x_sequence,

Line 1069: fnd_message.set_token('ITEM', to_char(x_item_id), FALSE);

1065: AND MDSV.functional_area_id = 2;
1066: EXCEPTION
1067: WHEN NO_DATA_FOUND THEN
1068: fnd_message.set_name('PO', 'PO_PO_MISSING_CATEGORY');
1069: fnd_message.set_token('ITEM', to_char(x_item_id), FALSE);
1070: x_category_id := NULL;
1071: po_copydoc_s1.online_report(x_online_report_id,
1072: x_sequence,
1073: substr(fnd_message.get, 1, 240),

Line 1073: substr(fnd_message.get, 1, 240),

1069: fnd_message.set_token('ITEM', to_char(x_item_id), FALSE);
1070: x_category_id := NULL;
1071: po_copydoc_s1.online_report(x_online_report_id,
1072: x_sequence,
1073: substr(fnd_message.get, 1, 240),
1074: x_line_num, 0, 0);
1075: x_return_code := -1;
1076: RETURN;
1077: WHEN OTHERS THEN

Line 1111: fnd_message.set_name('PO', 'PO_RI_INVALID_CATEGORY_ID');

1107: EXCEPTION
1108: WHEN NO_DATA_FOUND THEN
1109: x_category_id := NULL;
1110: -- Bug 3488117: Truncate at 2000 characters instead of 240.
1111: fnd_message.set_name('PO', 'PO_RI_INVALID_CATEGORY_ID');
1112: po_copydoc_s1.online_report(x_online_report_id,
1113: x_sequence,
1114: substr(fnd_message.get, 1, 2000),
1115: x_line_num, 0, 0);

Line 1114: substr(fnd_message.get, 1, 2000),

1110: -- Bug 3488117: Truncate at 2000 characters instead of 240.
1111: fnd_message.set_name('PO', 'PO_RI_INVALID_CATEGORY_ID');
1112: po_copydoc_s1.online_report(x_online_report_id,
1113: x_sequence,
1114: substr(fnd_message.get, 1, 2000),
1115: x_line_num, 0, 0);
1116: x_return_code := -1;
1117: RETURN;
1118: WHEN OTHERS THEN

Line 1135: fnd_message.set_name('PO', 'PO_RI_CAT_ID_ITEM_DESC_MISSING');

1131: ELSE
1132: x_item_revision := NULL;
1133: IF x_clm_info_flag = 'N' THEN --CLM
1134: IF (x_category_id IS NULL) THEN
1135: fnd_message.set_name('PO', 'PO_RI_CAT_ID_ITEM_DESC_MISSING');
1136: po_copydoc_s1.online_report(x_online_report_id,
1137: x_sequence,
1138: substr(fnd_message.get, 1, 240),
1139: x_line_num, 0, 0);

Line 1138: substr(fnd_message.get, 1, 240),

1134: IF (x_category_id IS NULL) THEN
1135: fnd_message.set_name('PO', 'PO_RI_CAT_ID_ITEM_DESC_MISSING');
1136: po_copydoc_s1.online_report(x_online_report_id,
1137: x_sequence,
1138: substr(fnd_message.get, 1, 240),
1139: x_line_num, 0, 0);
1140: x_return_code := -1;
1141: RETURN;
1142: ELSE

Line 1199: fnd_message.set_name('PO', 'PO_RI_INVALID_CATEGORY_ID');

1195:
1196: EXCEPTION
1197: WHEN NO_DATA_FOUND THEN
1198: x_category_id := NULL;
1199: fnd_message.set_name('PO', 'PO_RI_INVALID_CATEGORY_ID');
1200: po_copydoc_s1.online_report(x_online_report_id,
1201: x_sequence,
1202: substr(fnd_message.get, 1, 240),
1203: x_line_num, 0, 0);

Line 1202: substr(fnd_message.get, 1, 240),

1198: x_category_id := NULL;
1199: fnd_message.set_name('PO', 'PO_RI_INVALID_CATEGORY_ID');
1200: po_copydoc_s1.online_report(x_online_report_id,
1201: x_sequence,
1202: substr(fnd_message.get, 1, 240),
1203: x_line_num, 0, 0);
1204: x_return_code := -1;
1205: RETURN;
1206: WHEN OTHERS THEN

Line 1218: fnd_message.set_name('PO', 'PO_RI_CAT_ID_ITEM_DESC_MISSING');

1214: END;
1215: END IF;
1216: END IF; -- x_clm_info_flag = 'N' -- CLM
1217: IF (x_item_description IS NULL) THEN
1218: fnd_message.set_name('PO', 'PO_RI_CAT_ID_ITEM_DESC_MISSING');
1219: po_copydoc_s1.online_report(x_online_report_id,
1220: x_sequence,
1221: substr(fnd_message.get, 1, 240),
1222: x_line_num, 0, 0);

Line 1221: substr(fnd_message.get, 1, 240),

1217: IF (x_item_description IS NULL) THEN
1218: fnd_message.set_name('PO', 'PO_RI_CAT_ID_ITEM_DESC_MISSING');
1219: po_copydoc_s1.online_report(x_online_report_id,
1220: x_sequence,
1221: substr(fnd_message.get, 1, 240),
1222: x_line_num, 0, 0);
1223: x_return_code := -1;
1224: RETURN;
1225: END IF;

Line 1279: fnd_message.set_name('PO', 'PO_RI_INVALID_BUDGET_ACC_ID');

1275: EXCEPTION
1276: WHEN NO_DATA_FOUND THEN
1277: x_account_id := NULL;
1278: IF x_account_type = 'BUDGET' THEN
1279: fnd_message.set_name('PO', 'PO_RI_INVALID_BUDGET_ACC_ID');
1280: ELSIF x_account_type = 'ACCRUAL' THEN
1281: fnd_message.set_name('PO', 'PO_RI_INVALID_ACCRUAL_ACC_ID');
1282: ELSIF x_account_type = 'CHARGE' THEN
1283: fnd_message.set_name('PO', 'PO_RI_INVALID_CHARGE_ACC_ID');

Line 1281: fnd_message.set_name('PO', 'PO_RI_INVALID_ACCRUAL_ACC_ID');

1277: x_account_id := NULL;
1278: IF x_account_type = 'BUDGET' THEN
1279: fnd_message.set_name('PO', 'PO_RI_INVALID_BUDGET_ACC_ID');
1280: ELSIF x_account_type = 'ACCRUAL' THEN
1281: fnd_message.set_name('PO', 'PO_RI_INVALID_ACCRUAL_ACC_ID');
1282: ELSIF x_account_type = 'CHARGE' THEN
1283: fnd_message.set_name('PO', 'PO_RI_INVALID_CHARGE_ACC_ID');
1284: ELSIF x_account_type = 'VARIANCE' THEN
1285: fnd_message.set_name('PO', 'PO_RI_INVALID_VARIANCE_ACC_ID');

Line 1283: fnd_message.set_name('PO', 'PO_RI_INVALID_CHARGE_ACC_ID');

1279: fnd_message.set_name('PO', 'PO_RI_INVALID_BUDGET_ACC_ID');
1280: ELSIF x_account_type = 'ACCRUAL' THEN
1281: fnd_message.set_name('PO', 'PO_RI_INVALID_ACCRUAL_ACC_ID');
1282: ELSIF x_account_type = 'CHARGE' THEN
1283: fnd_message.set_name('PO', 'PO_RI_INVALID_CHARGE_ACC_ID');
1284: ELSIF x_account_type = 'VARIANCE' THEN
1285: fnd_message.set_name('PO', 'PO_RI_INVALID_VARIANCE_ACC_ID');
1286: END IF;
1287: po_copydoc_s1.online_report(x_online_report_id,

Line 1285: fnd_message.set_name('PO', 'PO_RI_INVALID_VARIANCE_ACC_ID');

1281: fnd_message.set_name('PO', 'PO_RI_INVALID_ACCRUAL_ACC_ID');
1282: ELSIF x_account_type = 'CHARGE' THEN
1283: fnd_message.set_name('PO', 'PO_RI_INVALID_CHARGE_ACC_ID');
1284: ELSIF x_account_type = 'VARIANCE' THEN
1285: fnd_message.set_name('PO', 'PO_RI_INVALID_VARIANCE_ACC_ID');
1286: END IF;
1287: po_copydoc_s1.online_report(x_online_report_id,
1288: x_sequence,
1289: substr(fnd_message.get, 1, 240),

Line 1289: substr(fnd_message.get, 1, 240),

1285: fnd_message.set_name('PO', 'PO_RI_INVALID_VARIANCE_ACC_ID');
1286: END IF;
1287: po_copydoc_s1.online_report(x_online_report_id,
1288: x_sequence,
1289: substr(fnd_message.get, 1, 240),
1290: x_line_num, x_shipment_num, x_distribution_num);
1291:
1292: WHEN OTHERS THEN
1293: x_account_id :=NULL;

Line 1368: fnd_message.set_name('PO', 'PO_RI_INVALID_PA_INFO');

1364: EXCEPTION
1365: WHEN NO_DATA_FOUND THEN
1366: x_project_id := NULL;
1367: -- Bug 3488117: 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);

Line 1371: substr(fnd_message.get, 1, 2000),

1367: -- Bug 3488117: 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:
1374: WHEN OTHERS THEN
1375: x_project_id :=NULL;

Line 1416: fnd_message.set_name('PO', 'PO_RI_INVALID_PA_INFO');

1412: EXCEPTION
1413: WHEN NO_DATA_FOUND THEN
1414: x_task_id := NULL;
1415: -- Bug 3488177: Truncate at 2000 characters instead of 240.
1416: fnd_message.set_name('PO', 'PO_RI_INVALID_PA_INFO');
1417: po_copydoc_s1.online_report(x_online_report_id,
1418: x_sequence,
1419: substr(fnd_message.get, 1, 2000),
1420: x_line_num, x_shipment_num, x_distribution_num);

Line 1419: substr(fnd_message.get, 1, 2000),

1415: -- Bug 3488177: Truncate at 2000 characters instead of 240.
1416: fnd_message.set_name('PO', 'PO_RI_INVALID_PA_INFO');
1417: po_copydoc_s1.online_report(x_online_report_id,
1418: x_sequence,
1419: substr(fnd_message.get, 1, 2000),
1420: x_line_num, x_shipment_num, x_distribution_num);
1421:
1422: WHEN OTHERS THEN
1423: x_task_id :=NULL;

Line 1471: fnd_message.set_name('PO', 'PO_RI_INVALID_PA_INFO');

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

Line 1474: substr(fnd_message.get, 1, 2000),

1470: x_exp_item_date := NULL;
1471: fnd_message.set_name('PO', 'PO_RI_INVALID_PA_INFO');
1472: po_copydoc_s1.online_report(x_online_report_id,
1473: x_sequence,
1474: substr(fnd_message.get, 1, 2000),
1475: x_line_num, x_shipment_num, x_distribution_num);
1476:
1477: WHEN OTHERS THEN
1478: x_exp_item_date := NULL;

Line 1516: fnd_message.set_name('PO', 'PO_RI_INVALID_PA_INFO');

1512:
1513: EXCEPTION
1514: WHEN NO_DATA_FOUND THEN
1515: x_exp_type := NULL;
1516: fnd_message.set_name('PO', 'PO_RI_INVALID_PA_INFO');
1517: po_copydoc_s1.online_report(x_online_report_id,
1518: x_sequence,
1519: substr(fnd_message.get, 1, 2000),
1520: x_line_num, x_shipment_num, x_distribution_num);

Line 1519: substr(fnd_message.get, 1, 2000),

1515: x_exp_type := NULL;
1516: fnd_message.set_name('PO', 'PO_RI_INVALID_PA_INFO');
1517: po_copydoc_s1.online_report(x_online_report_id,
1518: x_sequence,
1519: substr(fnd_message.get, 1, 2000),
1520: x_line_num, x_shipment_num, x_distribution_num);
1521:
1522: WHEN OTHERS THEN
1523: x_exp_type := NULL;

Line 1555: fnd_message.set_name('PO', 'PO_RI_INVALID_PA_INFO');

1551:
1552: EXCEPTION
1553: WHEN NO_DATA_FOUND THEN
1554: x_org_id := NULL;
1555: fnd_message.set_name('PO', 'PO_RI_INVALID_PA_INFO');
1556: po_copydoc_s1.online_report(x_online_report_id,
1557: x_sequence,
1558: substr(fnd_message.get, 1, 2000),
1559: x_line_num, x_shipment_num, x_distribution_num);

Line 1558: substr(fnd_message.get, 1, 2000),

1554: x_org_id := NULL;
1555: fnd_message.set_name('PO', 'PO_RI_INVALID_PA_INFO');
1556: po_copydoc_s1.online_report(x_online_report_id,
1557: x_sequence,
1558: substr(fnd_message.get, 1, 2000),
1559: x_line_num, x_shipment_num, x_distribution_num);
1560:
1561: WHEN OTHERS THEN
1562: x_org_id := NULL;

Line 1595: fnd_message.set_name('PO', 'PO_PA_PROJ_EXPIRED');

1591: and nvl(prj.completion_date,sysdate) >= sysdate;
1592:
1593: EXCEPTION
1594: WHEN NO_DATA_FOUND THEN
1595: fnd_message.set_name('PO', 'PO_PA_PROJ_EXPIRED');
1596: po_copydoc_s1.online_report(x_online_report_id,
1597: x_sequence,
1598: substr(fnd_message.get, 1, 2000),
1599: x_line_num, x_shipment_num, x_distribution_num);

Line 1598: substr(fnd_message.get, 1, 2000),

1594: WHEN NO_DATA_FOUND THEN
1595: fnd_message.set_name('PO', 'PO_PA_PROJ_EXPIRED');
1596: po_copydoc_s1.online_report(x_online_report_id,
1597: x_sequence,
1598: substr(fnd_message.get, 1, 2000),
1599: x_line_num, x_shipment_num, x_distribution_num);
1600:
1601:
1602: WHEN OTHERS THEN

Line 1642: fnd_message.set_name('PO', 'PO_PA_TASK_EXPIRED');

1638: and nvl(tsk.completion_date,sysdate) >= sysdate;
1639:
1640: EXCEPTION
1641: WHEN NO_DATA_FOUND THEN
1642: fnd_message.set_name('PO', 'PO_PA_TASK_EXPIRED');
1643: po_copydoc_s1.online_report(x_online_report_id,
1644: x_sequence,
1645: substr(fnd_message.get, 1, 2000),
1646: x_line_num, x_shipment_num, x_distribution_num);

Line 1645: substr(fnd_message.get, 1, 2000),

1641: WHEN NO_DATA_FOUND THEN
1642: fnd_message.set_name('PO', 'PO_PA_TASK_EXPIRED');
1643: po_copydoc_s1.online_report(x_online_report_id,
1644: x_sequence,
1645: substr(fnd_message.get, 1, 2000),
1646: x_line_num, x_shipment_num, x_distribution_num);
1647:
1648:
1649: WHEN OTHERS THEN

Line 1809: fnd_message.set_name('PO', 'PO_RI_INVALID_DEST_TYPE_CODE');

1805: END IF; --Bug 3557910
1806: EXCEPTION
1807: WHEN NO_DATA_FOUND THEN
1808: x_destination_type_code := NULL;
1809: fnd_message.set_name('PO', 'PO_RI_INVALID_DEST_TYPE_CODE');
1810: po_copydoc_s1.online_report(x_online_report_id,
1811: x_sequence,
1812: substr(fnd_message.get, 1, 240),
1813: x_line_num, x_shipment_num, x_distribution_num);

Line 1812: substr(fnd_message.get, 1, 240),

1808: x_destination_type_code := NULL;
1809: fnd_message.set_name('PO', 'PO_RI_INVALID_DEST_TYPE_CODE');
1810: po_copydoc_s1.online_report(x_online_report_id,
1811: x_sequence,
1812: substr(fnd_message.get, 1, 240),
1813: x_line_num, x_shipment_num, x_distribution_num);
1814:
1815: WHEN OTHERS THEN
1816: x_destination_type_code := NULL;

Line 1865: fnd_message.set_name('PO', 'PO_PO_INVALID_DEL_TO_PERSON');

1861:
1862: EXCEPTION
1863: WHEN NO_DATA_FOUND THEN
1864: x_deliver_to_person_id := NULL;
1865: fnd_message.set_name('PO', 'PO_PO_INVALID_DEL_TO_PERSON');
1866: po_copydoc_s1.online_report(x_online_report_id,
1867: x_sequence,
1868: substr(fnd_message.get, 1, 240),
1869: x_line_num, x_shipment_num, x_distribution_num);

Line 1868: substr(fnd_message.get, 1, 240),

1864: x_deliver_to_person_id := NULL;
1865: fnd_message.set_name('PO', 'PO_PO_INVALID_DEL_TO_PERSON');
1866: po_copydoc_s1.online_report(x_online_report_id,
1867: x_sequence,
1868: substr(fnd_message.get, 1, 240),
1869: x_line_num, x_shipment_num, x_distribution_num);
1870:
1871: WHEN OTHERS THEN
1872: x_deliver_to_person_id := NULL;

Line 1934: fnd_message.set_name('PO', 'PO_PO_INVALID_JOB');

1930: and task.task_id (+) = job.task_id;
1931: end if;
1932: if (x_count < 1) then
1933: -- register error
1934: fnd_message.set_name('PO', 'PO_PO_INVALID_JOB');
1935: po_copydoc_s1.online_report(x_online_report_id,
1936: x_sequence,
1937: substr(fnd_message.get, 1, 240),
1938: x_line_num, x_shipment_num,

Line 1937: substr(fnd_message.get, 1, 240),

1933: -- register error
1934: fnd_message.set_name('PO', 'PO_PO_INVALID_JOB');
1935: po_copydoc_s1.online_report(x_online_report_id,
1936: x_sequence,
1937: substr(fnd_message.get, 1, 240),
1938: x_line_num, x_shipment_num,
1939: x_distribution_num);
1940: end if;
1941: end if;

Line 1953: fnd_message.set_name('PO', 'PO_PO_INVALID_JOB_LINE');

1949: where line_id = x_wip_line_id
1950: and organization_id = x_destination_organization_id;
1951: if (x_count < 1) then
1952: -- register error
1953: fnd_message.set_name('PO', 'PO_PO_INVALID_JOB_LINE');
1954: po_copydoc_s1.online_report(x_online_report_id,
1955: x_sequence,
1956: substr(fnd_message.get, 1, 240),
1957: x_line_num, x_shipment_num,

Line 1956: substr(fnd_message.get, 1, 240),

1952: -- register error
1953: fnd_message.set_name('PO', 'PO_PO_INVALID_JOB_LINE');
1954: po_copydoc_s1.online_report(x_online_report_id,
1955: x_sequence,
1956: substr(fnd_message.get, 1, 240),
1957: x_line_num, x_shipment_num,
1958: x_distribution_num);
1959: end if;
1960: END IF;

Line 1997: fnd_message.set_name('PO', 'PO_PO_INVALID_OPERATION_SEQ');

1993: end if;
1994: end if; /* x_entity_type =6 */
1995: if (x_count < 1) then
1996: -- register error
1997: fnd_message.set_name('PO', 'PO_PO_INVALID_OPERATION_SEQ');
1998: po_copydoc_s1.online_report(x_online_report_id,
1999: x_sequence,
2000: substr(fnd_message.get, 1, 240),
2001: x_line_num, x_shipment_num,

Line 2000: substr(fnd_message.get, 1, 240),

1996: -- register error
1997: fnd_message.set_name('PO', 'PO_PO_INVALID_OPERATION_SEQ');
1998: po_copydoc_s1.online_report(x_online_report_id,
1999: x_sequence,
2000: substr(fnd_message.get, 1, 240),
2001: x_line_num, x_shipment_num,
2002: x_distribution_num);
2003: end if;
2004: end if; /*x_wip_operation_seq_num is not null */

Line 2021: fnd_message.set_name('PO', 'PO_PO_INVALID_RESOURCE_SEQ');

2017: and operation_seq_num = x_wip_operation_seq_num;
2018:
2019: if (x_count < 1) then
2020: -- register error
2021: fnd_message.set_name('PO', 'PO_PO_INVALID_RESOURCE_SEQ');
2022: po_copydoc_s1.online_report(x_online_report_id,
2023: x_sequence,
2024: substr(fnd_message.get, 1, 240),
2025: x_line_num, x_shipment_num,

Line 2024: substr(fnd_message.get, 1, 240),

2020: -- register error
2021: fnd_message.set_name('PO', 'PO_PO_INVALID_RESOURCE_SEQ');
2022: po_copydoc_s1.online_report(x_online_report_id,
2023: x_sequence,
2024: substr(fnd_message.get, 1, 240),
2025: x_line_num, x_shipment_num,
2026: x_distribution_num);
2027: end if;
2028: end if;

Line 2085: fnd_message.set_name('PO', 'PO_RI_INVALID_DEL_LOC_ID_DEST');

2081:
2082: EXCEPTION
2083: WHEN NO_DATA_FOUND THEN
2084: x_deliver_to_location_id := NULL;
2085: fnd_message.set_name('PO', 'PO_RI_INVALID_DEL_LOC_ID_DEST');
2086: -- Bug 3488117: Changed trunc size from 240 to 2000.
2087: po_copydoc_s1.online_report(x_online_report_id,
2088: x_sequence,
2089: substr(fnd_message.get, 1, 2000),

Line 2089: substr(fnd_message.get, 1, 2000),

2085: fnd_message.set_name('PO', 'PO_RI_INVALID_DEL_LOC_ID_DEST');
2086: -- Bug 3488117: Changed trunc size from 240 to 2000.
2087: po_copydoc_s1.online_report(x_online_report_id,
2088: x_sequence,
2089: substr(fnd_message.get, 1, 2000),
2090: x_line_num, x_shipment_num, x_distribution_num);
2091:
2092: WHEN OTHERS THEN
2093: x_deliver_to_location_id := NULL;

Line 2149: fnd_message.set_name('PO', 'PO_RI_INVALID_DEST_SUBINV');

2145:
2146: EXCEPTION
2147: WHEN NO_DATA_FOUND THEN
2148: x_destination_subinventory := NULL;
2149: fnd_message.set_name('PO', 'PO_RI_INVALID_DEST_SUBINV');
2150: po_copydoc_s1.online_report(x_online_report_id,
2151: x_sequence,
2152: substr(fnd_message.get, 1, 240),
2153: x_line_num, x_shipment_num, x_distribution_num);

Line 2152: substr(fnd_message.get, 1, 240),

2148: x_destination_subinventory := NULL;
2149: fnd_message.set_name('PO', 'PO_RI_INVALID_DEST_SUBINV');
2150: po_copydoc_s1.online_report(x_online_report_id,
2151: x_sequence,
2152: substr(fnd_message.get, 1, 240),
2153: x_line_num, x_shipment_num, x_distribution_num);
2154:
2155: WHEN OTHERS THEN
2156: x_destination_subinventory :=NULL;

Line 2217: fnd_message.set_name('PO', 'PO_PO_INVALID_CONTRACT');

2213: l_contract_doc_num := PO_HEADERS_SV4.get_doc_num
2214: ( p_po_header_id => p_contract_id
2215: );
2216:
2217: fnd_message.set_name('PO', 'PO_PO_INVALID_CONTRACT');
2218: fnd_message.set_token('VALUE', l_contract_doc_num, FALSE); --
2219:
2220: po_copydoc_s1.online_report(x_online_report_id,
2221: x_sequence,

Line 2218: fnd_message.set_token('VALUE', l_contract_doc_num, FALSE); --

2214: ( p_po_header_id => p_contract_id
2215: );
2216:
2217: fnd_message.set_name('PO', 'PO_PO_INVALID_CONTRACT');
2218: fnd_message.set_token('VALUE', l_contract_doc_num, FALSE); --
2219:
2220: po_copydoc_s1.online_report(x_online_report_id,
2221: x_sequence,
2222: substr(fnd_message.get, 1, 240),

Line 2222: substr(fnd_message.get, 1, 240),

2218: fnd_message.set_token('VALUE', l_contract_doc_num, FALSE); --
2219:
2220: po_copydoc_s1.online_report(x_online_report_id,
2221: x_sequence,
2222: substr(fnd_message.get, 1, 240),
2223: x_line_num, 0, 0);
2224: WHEN OTHERS THEN
2225:
2226: po_copydoc_s1.copydoc_sql_error('validate_contract_num', x_progress, sqlcode,

Line 2263: fnd_message.set_name('PO', 'PO_SUB_CP_INVALID_GA_REF');

2259: AND nvl(cancel_flag,'N') <> 'Y';
2260:
2261: EXCEPTION
2262: WHEN NO_DATA_FOUND THEN
2263: fnd_message.set_name('PO', 'PO_SUB_CP_INVALID_GA_REF');
2264: po_copydoc_s1.online_report(p_online_report_id,
2265: p_sequence,
2266: substr(fnd_message.get, 1, 240),
2267: p_line_num, 0, 0);

Line 2266: substr(fnd_message.get, 1, 240),

2262: WHEN NO_DATA_FOUND THEN
2263: fnd_message.set_name('PO', 'PO_SUB_CP_INVALID_GA_REF');
2264: po_copydoc_s1.online_report(p_online_report_id,
2265: p_sequence,
2266: substr(fnd_message.get, 1, 240),
2267: p_line_num, 0, 0);
2268: WHEN OTHERS THEN
2269: po_copydoc_s1.copydoc_sql_error('validate_global_ref', l_progress, sqlcode,
2270: p_online_report_id,

Line 2358: fnd_message.set_name('PO', 'PO_SVC_JOB_INVALID_IN_HR_BG');

2354:
2355: When no_data_found Then
2356:
2357: IF nvl(hr_general.get_xbg_profile,'N') = 'Y' THEN
2358: fnd_message.set_name('PO', 'PO_SVC_JOB_INVALID_IN_HR_BG');
2359: fnd_message.set_token('JOB', l_job_name);
2360: fnd_message.set_token('BG', l_bg_name);
2361: ELSE
2362: fnd_message.set_name('PO', 'PO_SVC_JOB_INVALID_IN_HR');

Line 2359: fnd_message.set_token('JOB', l_job_name);

2355: When no_data_found Then
2356:
2357: IF nvl(hr_general.get_xbg_profile,'N') = 'Y' THEN
2358: fnd_message.set_name('PO', 'PO_SVC_JOB_INVALID_IN_HR_BG');
2359: fnd_message.set_token('JOB', l_job_name);
2360: fnd_message.set_token('BG', l_bg_name);
2361: ELSE
2362: fnd_message.set_name('PO', 'PO_SVC_JOB_INVALID_IN_HR');
2363: fnd_message.set_token('JOB', l_job_name);

Line 2360: fnd_message.set_token('BG', l_bg_name);

2356:
2357: IF nvl(hr_general.get_xbg_profile,'N') = 'Y' THEN
2358: fnd_message.set_name('PO', 'PO_SVC_JOB_INVALID_IN_HR_BG');
2359: fnd_message.set_token('JOB', l_job_name);
2360: fnd_message.set_token('BG', l_bg_name);
2361: ELSE
2362: fnd_message.set_name('PO', 'PO_SVC_JOB_INVALID_IN_HR');
2363: fnd_message.set_token('JOB', l_job_name);
2364: END IF;

Line 2362: fnd_message.set_name('PO', 'PO_SVC_JOB_INVALID_IN_HR');

2358: fnd_message.set_name('PO', 'PO_SVC_JOB_INVALID_IN_HR_BG');
2359: fnd_message.set_token('JOB', l_job_name);
2360: fnd_message.set_token('BG', l_bg_name);
2361: ELSE
2362: fnd_message.set_name('PO', 'PO_SVC_JOB_INVALID_IN_HR');
2363: fnd_message.set_token('JOB', l_job_name);
2364: END IF;
2365:
2366: po_copydoc_s1.online_report(p_online_report_id,

Line 2363: fnd_message.set_token('JOB', l_job_name);

2359: fnd_message.set_token('JOB', l_job_name);
2360: fnd_message.set_token('BG', l_bg_name);
2361: ELSE
2362: fnd_message.set_name('PO', 'PO_SVC_JOB_INVALID_IN_HR');
2363: fnd_message.set_token('JOB', l_job_name);
2364: END IF;
2365:
2366: po_copydoc_s1.online_report(p_online_report_id,
2367: p_sequence,

Line 2368: substr(fnd_message.get, 1, 240),

2364: END IF;
2365:
2366: po_copydoc_s1.online_report(p_online_report_id,
2367: p_sequence,
2368: substr(fnd_message.get, 1, 240),
2369: p_line_num, 0, 0);
2370: End;
2371:
2372: -- Sql What : Check if the job exists in the Jobs table

Line 2395: fnd_message.set_name('PO', 'PO_SVC_JOB_ASSOC_INVALID');

2391:
2392: Exception
2393:
2394: When no_data_found Then
2395: fnd_message.set_name('PO', 'PO_SVC_JOB_ASSOC_INVALID');
2396: fnd_message.set_token('JOB', l_job_name);
2397: fnd_message.set_token('CATEGORY', l_category);
2398: po_copydoc_s1.online_report(p_online_report_id,
2399: p_sequence,

Line 2396: fnd_message.set_token('JOB', l_job_name);

2392: Exception
2393:
2394: When no_data_found Then
2395: fnd_message.set_name('PO', 'PO_SVC_JOB_ASSOC_INVALID');
2396: fnd_message.set_token('JOB', l_job_name);
2397: fnd_message.set_token('CATEGORY', l_category);
2398: po_copydoc_s1.online_report(p_online_report_id,
2399: p_sequence,
2400: substr(fnd_message.get, 1, 240),

Line 2397: fnd_message.set_token('CATEGORY', l_category);

2393:
2394: When no_data_found Then
2395: fnd_message.set_name('PO', 'PO_SVC_JOB_ASSOC_INVALID');
2396: fnd_message.set_token('JOB', l_job_name);
2397: fnd_message.set_token('CATEGORY', l_category);
2398: po_copydoc_s1.online_report(p_online_report_id,
2399: p_sequence,
2400: substr(fnd_message.get, 1, 240),
2401: p_line_num, 0, 0);

Line 2400: substr(fnd_message.get, 1, 240),

2396: fnd_message.set_token('JOB', l_job_name);
2397: fnd_message.set_token('CATEGORY', l_category);
2398: po_copydoc_s1.online_report(p_online_report_id,
2399: p_sequence,
2400: substr(fnd_message.get, 1, 240),
2401: p_line_num, 0, 0);
2402: End;
2403:
2404: l_progress := '050';

Line 2919: x_sequence, FND_MESSAGE.get,

2915:
2916: IF ( l_val_proj_result = PO_PROJECT_DETAILS_SV.pjm_validate_failure) THEN
2917: -- Write the message to the PO_ONLINE_REPORT_TEXT table as an error.
2918: po_copydoc_s1.online_report(x_online_report_id,
2919: x_sequence, FND_MESSAGE.get,
2920: x_line_num, x_shipment_num, x_distribution_num,
2921: PO_COPYDOC_S1.G_ERROR_MESSAGE_TYPE);
2922: ELSIF ( l_val_proj_result = PO_PROJECT_DETAILS_SV.pjm_validate_warning) THEN
2923: -- Write the message to the PO_ONLINE_REPORT_TEXT table as a warning.

Line 2925: x_sequence, FND_MESSAGE.get,

2921: PO_COPYDOC_S1.G_ERROR_MESSAGE_TYPE);
2922: ELSIF ( l_val_proj_result = PO_PROJECT_DETAILS_SV.pjm_validate_warning) THEN
2923: -- Write the message to the PO_ONLINE_REPORT_TEXT table as a warning.
2924: po_copydoc_s1.online_report(x_online_report_id,
2925: x_sequence, FND_MESSAGE.get,
2926: x_line_num, x_shipment_num, x_distribution_num,
2927: PO_COPYDOC_S1.G_WARNING_MESSAGE_TYPE);
2928: END IF;
2929: --< Bug 3265539 End >

Line 3080: FND_MESSAGE.set_encoded(encoded_message => FND_MSG_PUB.get);

3076:
3077: l_progress := '020';
3078:
3079: IF (l_return_status <> FND_API.g_ret_sts_success) THEN
3080: FND_MESSAGE.set_encoded(encoded_message => FND_MSG_PUB.get);
3081: RAISE FND_API.g_exc_error;
3082: END IF;
3083:
3084: l_progress := '030';

Line 3090: FND_MESSAGE.set_name(application => 'PO',

3086: IF (NOT l_is_valid) OR
3087: (p_transaction_flow_header_id <>
3088: NVL(l_transaction_flow_header_id, -99))
3089: THEN
3090: FND_MESSAGE.set_name(application => 'PO',
3091: name => 'PO_COPY_DOC_INVALID_TXN_FLOW');
3092: RAISE FND_API.g_exc_error;
3093: END IF;
3094:

Line 3102: x_message => FND_MESSAGE.get,

3098: WHEN FND_API.g_exc_error THEN
3099: PO_COPYDOC_S1.online_report
3100: (x_online_report_id => p_online_report_id,
3101: x_sequence => x_sequence,
3102: x_message => FND_MESSAGE.get,
3103: x_line_num => p_line_num,
3104: x_shipment_num => p_shipment_num,
3105: x_distribution_num => 0);
3106: WHEN OTHERS THEN

Line 3190: l_err_prefix := FND_MESSAGE.get_string(appin => 'PO',

3186:
3187: l_user_id := FND_GLOBAL.user_id;
3188: l_login_id := FND_GLOBAL.login_id;
3189: l_message_type := PO_COPYDOC_S1.g_error_message_type;
3190: l_err_prefix := FND_MESSAGE.get_string(appin => 'PO',
3191: namein => 'PO_GA_ORG_ASSIGN_PREFIX');
3192:
3193: --------------------------------------------------------------
3194: l_progress := '020';

Line 3197: l_text_line := FND_MESSAGE.get_string

3193: --------------------------------------------------------------
3194: l_progress := '020';
3195:
3196: -- Validate the Requesting Orgs for all enabled org assignments
3197: l_text_line := FND_MESSAGE.get_string
3198: (appin => 'PO',
3199: namein => 'PO_GA_INVALID_REQUESTING_ORG');
3200: INSERT INTO po_online_report_text
3201: (

Line 3245: l_text_line := FND_MESSAGE.get_string

3241: --------------------------------------------------------------
3242: l_progress := '030';
3243:
3244: -- Validate the Purchasing Orgs for all enabled org assignments
3245: l_text_line := FND_MESSAGE.get_string
3246: (appin => 'PO',
3247: namein => 'PO_GA_INVALID_PURCHASING_ORG');
3248: INSERT INTO po_online_report_text
3249: (

Line 3321: l_text_line := FND_MESSAGE.get_string

3317: --------------------------------------------------------------
3318: l_progress := '040';
3319:
3320: -- Validate the Purchasing Sites for all enabled org assignments
3321: l_text_line := FND_MESSAGE.get_string
3322: (appin => 'PO',
3323: namein => 'PO_GA_INVALID_PURCHASING_SITE');
3324: INSERT INTO po_online_report_text
3325: (

Line 3529: fnd_message.get_string('PO', 'PO_SUB_REF_UNAPPROVED_CONTRACT'),

3525: WHEN NO_DATA_FOUND THEN
3526: po_copydoc_s1.online_report(
3527: x_online_report_id,
3528: x_sequence,
3529: fnd_message.get_string('PO', 'PO_SUB_REF_UNAPPROVED_CONTRACT'),
3530: x_line_num, 0, 0);
3531: WHEN OTHERS THEN
3532: po_copydoc_s1.copydoc_sql_error('validate_blanket_ref', l_progress, sqlcode,
3533: x_online_report_id,

Line 3569: fnd_message.get_string('PO', 'PO_INVALID_IDV_REF'),

3565: IF NVL(l_frozen_flag, 'N') = 'Y' THEN
3566: po_copydoc_s1.online_report(
3567: x_online_report_id,
3568: x_sequence,
3569: fnd_message.get_string('PO', 'PO_INVALID_IDV_REF'),
3570: 0, 0, 0);
3571: END IF;
3572:
3573: EXCEPTION