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_HEADERS_SV6 dependencies on PO_HEADERS

Line 1: PACKAGE BODY PO_HEADERS_SV6 AS

1: PACKAGE BODY PO_HEADERS_SV6 AS
2: /* $Header: POXPIV2B.pls 120.3 2007/10/31 12:50:27 adbharga ship $ */
3: /* Changed the file name to POXPIV2B.pls from POXPIVHB.pls since
4: the file was corrupted . checking in with new name */
5:

Line 22: /* check to see if the segment1 is unique in po_headers table */

18:
19: BEGIN
20: x_progress := '010';
21:
22: /* check to see if the segment1 is unique in po_headers table */
23: --
24: if X_type_lookup_code in ('BLANKET', 'STANDARD') then
25: x_progress := '020';
26:

Line 29: FROM po_headers

25: x_progress := '020';
26:
27: SELECT count(*)
28: INTO x_temp
29: FROM po_headers
30: WHERE segment1 = x_segment1
31: AND type_lookup_code in ('BLANKET', 'CONTRACT', 'PLANNED', 'STANDARD')
32: AND (rowid <> x_rowid OR x_rowid is null);
33:

Line 39: FROM po_headers

35: x_progress := '030';
36:
37: SELECT count(*)
38: INTO x_temp
39: FROM po_headers
40: WHERE segment1 = x_segment1
41: AND type_lookup_code = X_type_lookup_code
42: AND (rowid <> x_rowid OR x_rowid is null);
43: else

Line 79: /* check to see if the po_header_id already exists in po_headers table,

75:
76: BEGIN
77: x_progress := '010';
78:
79: /* check to see if the po_header_id already exists in po_headers table,
80: if so, FALSE, otherwise, TRUE */
81:
82: SELECT COUNT(*)
83: INTO x_temp

Line 84: FROM po_headers

80: if so, FALSE, otherwise, TRUE */
81:
82: SELECT COUNT(*)
83: INTO x_temp
84: FROM po_headers
85: WHERE po_header_id = x_po_header_id
86: AND (rowid <> x_rowid OR x_rowid is null);
87:
88: IF x_temp = 0 THEN -- no duplicated po_header_id is found

Line 210: ** whereas in default_po_headers we are calling

206:
207: /* Bug 1769714
208: ** Added round to x_temp_rate.
209: ** The issue is that here we are calling the gl api directly
210: ** whereas in default_po_headers we are calling
211: ** po_currency_sv.get_rate which rounds the resultant rate.
212: ** Later when we compare the two rates from the two functions,
213: ** they might not compare since one is rounded the other isn't.
214: */

Line 346: PROCEDURE NAME: validate_po_headers()

342:
343:
344: /*================================================================
345:
346: PROCEDURE NAME: validate_po_headers()
347:
348: ==================================================================*/
349: PROCEDURE validate_po_headers(
350: X_PO_HEADER_ID IN NUMBER,

Line 349: PROCEDURE validate_po_headers(

345:
346: PROCEDURE NAME: validate_po_headers()
347:
348: ==================================================================*/
349: PROCEDURE validate_po_headers(
350: X_PO_HEADER_ID IN NUMBER,
351: X_AGENT_ID IN NUMBER,
352: X_TYPE_LOOKUP_CODE IN VARCHAR2,
353: X_LAST_UPDATE_DATE IN DATE,

Line 485: 'PO_HEADERS_INTERAFCE',

481: null,
482: X_interface_header_id,
483: X_interface_line_id,
484: 'PO_PDOI_COLUMN_NOT_NULL',
485: 'PO_HEADERS_INTERAFCE',
486: 'TYPE_LOOKUP_CODE',
487: 'COLUMN_NAME',
488: null,null,null,null,null,
489: 'TYPE_LOOKUP_CODE',

Line 504: 'PO_HEADERS_INTERAFCE',

500: null,
501: X_interface_header_id,
502: X_interface_line_id,
503: 'PO_PDOI_INVALID_TYPE_LKUP_CD',
504: 'PO_HEADERS_INTERAFCE',
505: 'TYPE_LOOKUP_CODE',
506: 'VALUE',
507: null,null,null,null,null,
508: x_type_lookup_code,

Line 530: 'PO_HEADERS_INTERFACE',

526: null,
527: X_interface_header_id,
528: X_interface_line_id,
529: 'PO_PDOI_INVALID_QUOTE_TYPE_CD',
530: 'PO_HEADERS_INTERFACE',
531: 'QUOTE_TYPE_LOOKUP_CODE',
532: 'VALUE',
533: null,null,null,null,null,
534: X_quote_type_lookup_code,

Line 550: 'PO_HEADERS_INTERFACE',

546: null,
547: X_interface_header_id,
548: X_interface_line_id,
549: 'PO_PDOI_COLUMN_NOT_NULL',
550: 'PO_HEADERS_INTERFACE',
551: 'QUOTE_WARNING_DELAY',
552: 'COLUMN_NAME',
553: null,null,null,null,null,
554: 'QUOTE_WARNING_DELAY',

Line 568: 'PO_HEADERS_INTERFACE',

564: null,
565: X_interface_header_id,
566: X_interface_line_id,
567: 'PO_PDOI_COLUMN_NOT_NULL',
568: 'PO_HEADERS_INTERFACE',
569: 'APPROVAL_REQUIRED_FLAG',
570: 'COLUMN_NAME',
571: null,null,null,null,null,
572: 'APPROVAL_REQUIRED_FLAG',

Line 586: 'PO_HEADERS_INTERFACE',

582: null,
583: X_interface_header_id,
584: X_interface_line_id,
585: 'PO_PDOI_COLUMN_NOT_NULL',
586: 'PO_HEADERS_INTERFACE',
587: 'CREATED_BY',
588: 'COLUMN_NAME',
589: null,null,null,null,null,
590: 'CREATED_BY',

Line 604: 'PO_HEADERS_INTERFACE',

600: null,
601: X_interface_header_id,
602: X_interface_line_id,
603: 'PO_PDOI_COLUMN_NOT_NULL',
604: 'PO_HEADERS_INTERFACE',
605: 'CREATION_DATE',
606: 'COLUMN_NAME',
607: null,null,null,null,null,
608: 'CREATION_DATE',

Line 624: 'PO_HEADERS_INTERFACE',

620: null,
621: X_interface_header_id,
622: X_interface_line_id,
623: 'PO_PDOI_COLUMN_NULL',
624: 'PO_HEADERS_INTERFACE',
625: 'DOCUMENT_SUBTYPE',
626: 'COLUMN_NAME',
627: 'VALUE',
628: null,null,null,null,

Line 645: 'PO_HEADERS_INTERFACE',

641: null,
642: X_interface_header_id,
643: X_interface_line_id,
644: 'PO_PDOI_COLUMN_NOT_NULL',
645: 'PO_HEADERS_INTERFACE',
646: 'ACCEPTANCE_REQUIRED_FLAG',
647: 'COLUMN_NAME',
648: null,null,null,null,null,
649: 'ACCEPTANCE_REQUIRED_FLAG',

Line 668: 'PO_HEADERS_INTERFACE',

664: null,
665: X_interface_header_id,
666: X_interface_line_id,
667: 'PO_PDOI_COLUMN_NOT_ZERO',
668: 'PO_HEADERS_INTERFACE',
669: 'REVISION_NUM',
670: 'COLUMN_NAME',
671: null,null,null,null,null,
672: 'REVISION_NUM',

Line 691: 'PO_HEADERS_INTERFACE',

687: null,
688: X_interface_header_id,
689: X_interface_line_id,
690: 'PO_PDOI_COLUMN_NOT_NULL',
691: 'PO_HEADERS_INTERFACE',
692: 'DOCUMENT_NUM',
693: 'COLUMN_NAME',
694: null,null,null,null,null,
695: 'DOCUMENT_NUM',

Line 709: 'PO_HEADERS_INTERFACE',

705: null,
706: X_interface_header_id,
707: X_interface_line_id,
708: 'PO_PDOI_COLUMN_NOT_NULL',
709: 'PO_HEADERS_INTERFACE',
710: 'PO_HEADER_ID',
711: 'COLUMN_NAME',
712: null,null,null,null,null,
713: 'PO_HEADER_ID',

Line 728: 'PO_HEADERS_INTERFACE',

724: null,
725: X_interface_header_id,
726: X_interface_line_id,
727: 'PO_PDOI_COLUMN_NOT_NULL',
728: 'PO_HEADERS_INTERFACE',
729: 'CURRENCY_CODE',
730: 'COLUMN_NAME',
731: null,null,null,null,null,
732: 'CURRENCY_CODE',

Line 747: 'PO_HEADERS_INTERFACE',

743: null,
744: X_interface_header_id,
745: X_interface_line_id,
746: 'PO_PDOI_COLUMN_NOT_NULL',
747: 'PO_HEADERS_INTERFACE',
748: 'AGENT_ID',
749: 'COLUMN_NAME',
750: null,null,null,null,null,
751: 'AGENT_ID',

Line 766: 'PO_HEADERS_INTERFACE',

762: null,
763: X_interface_header_id,
764: X_interface_line_id,
765: 'PO_PDOI_COLUMN_NOT_NULL',
766: 'PO_HEADERS_INTERFACE',
767: 'VENDOR_ID',
768: 'COLUMN_NAME',
769: null,null,null,null,null,
770: 'VENDOR_ID',

Line 789: 'PO_HEADERS_INTERFACE',

785: null,
786: X_interface_header_id,
787: X_interface_line_id,
788: 'PO_PDOI_COLUMN_NOT_NULL',
789: 'PO_HEADERS_INTERFACE',
790: 'VENDOR_SITE_ID',
791: 'COLUMN_NAME',
792: null,null,null,null,null,
793: 'VENDOR_SITE_ID',

Line 808: 'PO_HEADERS_INTERFACE',

804: null,
805: X_interface_header_id,
806: X_interface_line_id,
807: 'PO_PDOI_COLUMN_NOT_NULL',
808: 'PO_HEADERS_INTERFACE',
809: 'SHIP_TO_LOCATION_ID',
810: 'COLUMN_NAME',
811: null,null,null,null,null,
812: 'SHIP_TO_LOCATION_ID',

Line 828: 'PO_HEADERS_INTERFACE',

824: null,
825: X_interface_header_id,
826: X_interface_line_id,
827: 'PO_PDOI_COLUMN_NOT_NULL',
828: 'PO_HEADERS_INTERFACE',
829: 'BILL_TO_LOCATION_ID',
830: 'COLUMN_NAME',
831: null,null,null,null,null,
832: 'BILL_TO_LOCATION_ID',

Line 848: 'PO_HEADERS_INTERFACE',

844: null,
845: X_interface_header_id,
846: X_interface_line_id,
847: 'PO_PDOI_COLUMN_NOT_NULL',
848: 'PO_HEADERS_INTERFACE',
849: 'LAST_UPDATED_BY',
850: 'COLUMN_NAME',
851: null,null,null,null,null,
852: 'LAST_UPDATED_BY',

Line 867: 'PO_HEADERS_INTERFACE',

863: null,
864: X_interface_header_id,
865: X_interface_line_id,
866: 'PO_PDOI_COLUMN_NOT_NULL',
867: 'PO_HEADERS_INTERFACE',
868: 'LAST_UPDATE_DATE',
869: 'COLUMN_NAME',
870: null,null,null,null,null,
871: 'LAST_UPDATE_DATE',

Line 889: 'PO_HEADERS_INTERFACE',

885: null,
886: X_interface_header_id,
887: X_interface_line_id,
888: 'PO_PDOI_COLUMN_NULL',
889: 'PO_HEADERS_INTERFACE',
890: 'RELEASE_NUM',
891: 'COLUMN_NAME',
892: 'VALUE',
893: null,null,null,null,

Line 910: 'PO_HEADERS_INTERFACE',

906: null,
907: X_interface_header_id,
908: X_interface_line_id,
909: 'PO_PDOI_COLUMN_NULL',
910: 'PO_HEADERS_INTERFACE',
911: 'PO_RELEASE_ID',
912: 'COLUMN_NAME',
913: 'VALUE',
914: null,null,null,null,

Line 931: 'PO_HEADERS_INTERFACE',

927: null,
928: X_interface_header_id,
929: X_interface_line_id,
930: 'PO_PDOI_COLUMN_NULL',
931: 'PO_HEADERS_INTERFACE',
932: 'RELEASE_DATE',
933: 'COLUMN_NAME',
934: 'VALUE',
935: null,null,null,null,

Line 952: 'PO_HEADERS_INTERFACE',

948: null,
949: X_interface_header_id,
950: X_interface_line_id,
951: 'PO_PDOI_COLUMN_NULL',
952: 'PO_HEADERS_INTERFACE',
953: 'REVISED_DATE',
954: 'COLUMN_NAME',
955: 'VALUE',
956: null,null,null,null,

Line 977: 'PO_HEADERS_INTERFACE',

973: null,
974: X_interface_header_id,
975: X_interface_line_id,
976: 'PO_PDOI_COLUMN_NULL',
977: 'PO_HEADERS_INTERFACE',
978: 'USER_HOLD_FLAG',
979: 'COLUMN_NAME',
980: 'VALUE',
981: null,null,null,null,

Line 998: 'PO_HEADERS_INTERFACE',

994: null,
995: X_interface_header_id,
996: X_interface_line_id,
997: 'PO_PDOI_COLUMN_NULL',
998: 'PO_HEADERS_INTERFACE',
999: 'PRINTED_DATE',
1000: 'COLUMN_NAME',
1001: 'VALUE',
1002: null,null,null,null,

Line 1018: 'PO_HEADERS_INTERFACE',

1014: null,
1015: X_interface_header_id,
1016: X_interface_line_id,
1017: 'PO_PDOI_COLUMN_NULL',
1018: 'PO_HEADERS_INTERFACE',
1019: 'CLOSED_DATE',
1020: 'COLUMN_NAME',
1021: 'VALUE',
1022: null,null,null,null,

Line 1033: X_temp_val := po_headers_sv6.val_header_id_uniqueness(X_po_header_id,

1029: END IF; /* X_type_lookup_code in ('QUOTATION', 'BLANKET') */
1030:
1031: X_progress := '210';
1032: IF (X_po_header_id IS NOT NULL ) THEN
1033: X_temp_val := po_headers_sv6.val_header_id_uniqueness(X_po_header_id,
1034: null /* rowid */);
1035: IF ( X_temp_val = FALSE ) THEN
1036: po_interface_errors_sv1.handle_interface_errors(
1037: 'PO_DOCS_OPEN_INTERFACE',

Line 1043: 'PO_HEADERS_INTERFACE',

1039: null,
1040: X_interface_header_id,
1041: X_interface_line_id,
1042: 'PO_PDOI_PO_HDR_ID_UNIQUE',
1043: 'PO_HEADERS_INTERFACE',
1044: 'PO_HEADER_ID',
1045: 'VALUE',
1046: null,null,null,null,null,
1047: X_po_header_id,

Line 1061: X_temp_val := po_headers_sv6.val_doc_num(

1057: -- Validation will only be skipped if no document number is provided in the flat file
1058:
1059: IF (X_segment1 IS NOT NULL and X_segment1 <> 'POI_Temp_PO_b679535') THEN
1060:
1061: X_temp_val := po_headers_sv6.val_doc_num(
1062: X_type_lookup_code,
1063: X_segment1,
1064: X_manual_quote_num_type,
1065: X_manual_po_num_type,

Line 1077: 'PO_HEADERS_INTERFACE',

1073: null,
1074: X_interface_header_id,
1075: X_interface_line_id,
1076: X_error_code,
1077: 'PO_HEADERS_INTERFACE',
1078: 'DOCUMENT_NUM',
1079: 'VALUE',
1080: null,null,null,null,null,
1081: X_segment1,

Line 1093: 'PO_HEADERS_INTERFACE',

1089: null,
1090: X_interface_header_id,
1091: X_interface_line_id,
1092: X_error_code,
1093: 'PO_HEADERS_INTERFACE',
1094: 'DOCUMENT_NUM',
1095: 'COLUMN_NAME',
1096: 'VALUE',
1097: null,null,null,null,

Line 1111: 'PO_HEADERS_INTERFACE',

1107: null,
1108: X_interface_header_id,
1109: X_interface_line_id,
1110: X_error_code,
1111: 'PO_HEADERS_INTERFACE',
1112: 'DOCUMENT_NUM',
1113: 'COLUMN_NAME',
1114: 'VALUE',
1115: null,null,null,null,

Line 1129: 'PO_HEADERS_INTERFACE',

1125: null,
1126: X_interface_header_id,
1127: X_interface_line_id,
1128: X_error_code,
1129: 'PO_HEADERS_INTERFACE',
1130: 'TYPE_LOOKUP_CODE',
1131: 'VALUE',
1132: null,null,null,null,null,
1133: X_type_lookup_code,

Line 1151: 'PO_HEADERS_INTERFACE',

1147: null,
1148: X_interface_header_id,
1149: X_interface_line_id,
1150: 'PO_PDOI_INVALID_CURRENCY',
1151: 'PO_HEADERS_INTERFACE',
1152: 'CURRENCY_CODE',
1153: 'VALUE',
1154: null,null,null,null,null,
1155: X_currency_code,

Line 1165: X_temp_val := po_headers_sv6.val_rate_info(X_base_currency_code,

1161: X_progress := '240';
1162: IF (X_base_currency_code is not null) AND
1163: (x_currency_code is not null)
1164: THEN
1165: X_temp_val := po_headers_sv6.val_rate_info(X_base_currency_code,
1166: X_currency_code,
1167: X_rate_type,
1168: X_rate_date,
1169: X_rate,

Line 1180: 'PO_HEADERS_INTERFACE',

1176: null,
1177: X_interface_header_id,
1178: X_interface_line_id,
1179: X_error_code,
1180: 'PO_HEADERS_INTERFACE',
1181: 'RATE',
1182: 'CURRENCY',
1183: 'RATE_TYPE',
1184: null,null,null,null,

Line 1198: 'PO_HEADERS_INTERFACE',

1194: null,
1195: X_interface_header_id,
1196: X_interface_line_id,
1197: X_error_code,
1198: 'PO_HEADERS_INTERFACE',
1199: NULL,
1200: null,null,null,null,null,null,
1201: null,
1202: null,null,null,null,null,

Line 1213: 'PO_HEADERS_INTERFACE',

1209: null,
1210: X_interface_header_id,
1211: X_interface_line_id,
1212: X_error_code,
1213: 'PO_HEADERS_INTERFACE',
1214: 'RATE_TYPE' ,
1215: 'VALUE',
1216: null,null,null,null,null,
1217: X_rate_type,

Line 1229: 'PO_HEADERS_INTERFACE',

1225: null,
1226: X_interface_header_id,
1227: X_interface_line_id,
1228: X_error_code,
1229: 'PO_HEADERS_INTERFACE',
1230: 'RATE',
1231: 'COLUMN_NAME',
1232: null,null,null,null,null,
1233: 'RATE',

Line 1245: 'PO_HEADERS_INTERFACE',

1241: null,
1242: X_interface_header_id,
1243: X_interface_line_id,
1244: X_error_code,
1245: 'PO_HEADERS_INTERFACE',
1246: 'RATE',
1247: 'VALUE',
1248: null,null,null,null,null,
1249: X_rate,

Line 1261: 'PO_HEADERS_INTERFACE',

1257: null,
1258: X_interface_header_id,
1259: X_interface_line_id,
1260: X_error_code,
1261: 'PO_HEADERS_INTERFACE',
1262: 'RATE',
1263: 'COLUMN_NAME',
1264: 'VALUE',
1265: null,null,null,null,

Line 1286: 'PO_HEADERS_INTERFACE',

1282: null,
1283: X_interface_header_id,
1284: X_interface_line_id,
1285: 'PO_PDOI_INVALID_BUYER',
1286: 'PO_HEADERS_INTERFACE',
1287: 'AGENT_ID',
1288: 'VALUE',
1289: null,null,null,null,null,
1290: X_agent_id,

Line 1314: 'PO_HEADERS_INTERFACE',

1310: null,
1311: X_interface_header_id,
1312: X_interface_line_id,
1313: X_error_code,
1314: 'PO_HEADERS_INTERFACE',
1315: 'VENDOR_ID',
1316: 'VALUE',
1317: null,null,null,null,null,
1318: X_vendor_id,

Line 1330: 'PO_HEADERS_INTERFACE',

1326: null,
1327: X_interface_header_id,
1328: X_interface_line_id,
1329: X_error_code,
1330: 'PO_HEADERS_INTERFACE',
1331: 'VENDOR_SITE_ID',
1332: 'VALUE',
1333: null,null,null,null,null,
1334: X_vendor_site_id,

Line 1346: 'PO_HEADERS_INTERFACE',

1342: null,
1343: X_interface_header_id,
1344: X_interface_line_id,
1345: X_error_code,
1346: 'PO_HEADERS_INTERFACE',
1347: 'VENDOR_CONTACT_ID',
1348: 'VALUE',
1349: null,null,null,null,null,
1350: X_vendor_contact_id,

Line 1371: 'PO_HEADERS_INTERFACE',

1367: null,
1368: X_interface_header_id,
1369: X_interface_line_id,
1370: 'PO_PDOI_INVALID_SHIP_LOC_ID',
1371: 'PO_HEADERS_INTERFACE',
1372: 'SHIP_TO_LOCATION_ID',
1373: 'VALUE',
1374: null,null,null,null,null,
1375: X_ship_to_location_id,

Line 1395: 'PO_HEADERS_INTERFACE',

1391: null,
1392: X_interface_header_id,
1393: X_interface_line_id,
1394: 'PO_PDOI_INVALID_BILL_LOC_ID',
1395: 'PO_HEADERS_INTERFACE',
1396: 'BILL_TO_LOCATION_ID',
1397: 'VALUE',
1398: null,null,null,null,null,
1399: X_bill_to_location_id,

Line 1416: 'PO_HEADERS_INTERFACE',

1412: null,
1413: X_interface_header_id,
1414: X_interface_line_id,
1415: 'PO_PDOI_INVALID_PAY_TERMS',
1416: 'PO_HEADERS_INTERFACE',
1417: 'TERMS_ID',
1418: 'VALUE',
1419: null,null,null,null,null,
1420: X_terms_id,

Line 1440: 'PO_HEADERS_INTERFACE',

1436: null,
1437: X_interface_header_id,
1438: X_interface_line_id,
1439: 'PO_PDOI_INVALID_FREIGHT_CARR',
1440: 'PO_HEADERS_INTERFACE',
1441: 'SHIP_VIA_LOOKUP_CODE',
1442: 'VALUE',
1443: null,null,null,null,null,
1444: X_ship_via_lookup_code,

Line 1461: 'PO_HEADERS_INTERFACE',

1457: null,
1458: X_interface_header_id,
1459: X_interface_line_id,
1460: 'PO_PDOI_INVALID_FOB',
1461: 'PO_HEADERS_INTERFACE',
1462: 'FOB_LOOKUP_CODE',
1463: 'VALUE',
1464: null,null,null,null,null,
1465: X_fob_lookup_code,

Line 1484: 'PO_HEADERS_INTERFACE',

1480: null,
1481: X_interface_header_id,
1482: X_interface_line_id,
1483: 'PO_PDOI_INVALID_FREIGHT_TERMS',
1484: 'PO_HEADERS_INTERFACE',
1485: 'FREIGHT_TERMS_LOOKUP_CODE',
1486: 'VALUE',
1487: null,null,null,null,null,
1488: X_freight_terms_lookup_code,

Line 1507: 'PO_HEADERS_INTERFACE',

1503: NULL,
1504: X_interface_header_id,
1505: X_interface_line_id,
1506: 'PO_PDOI_INVALID_SHIPPING_CTRL',
1507: 'PO_HEADERS_INTERFACE',
1508: 'SHIPPING_CONTROL',
1509: 'VALUE',
1510: NULL,NULL,NULL,NULL,NULL,
1511: p_shipping_control,

Line 1530: 'PO_HEADERS_INTERFACE',

1526: null,
1527: X_interface_header_id,
1528: X_interface_line_id,
1529: 'PO_PDOI_INVALID_FLAG_VALUE',
1530: 'PO_HEADERS_INTERFACE',
1531: 'APPROVAL_REQUIRED_FLAG',
1532: 'COLUMN_NAME',
1533: 'VALUE',
1534: null,null,null,null,

Line 1551: 'PO_HEADERS_INTERFACE',

1547: null,
1548: X_interface_header_id,
1549: X_interface_line_id,
1550: 'PO_PDOI_LT_ZERO',
1551: 'PO_HEADERS_INTERFACE',
1552: 'QUOTE_WARNING_DELAY',
1553: 'COLUMN_NAME',
1554: 'VALUE',
1555: null,null,null,null,

Line 1565: X_temp_val := po_headers_sv6.val_lookup_code(

1561: END IF;
1562:
1563: X_progress := '350';
1564: IF (X_reply_method_lookup_code IS NOT NULL ) THEN
1565: X_temp_val := po_headers_sv6.val_lookup_code(
1566: X_reply_method_lookup_code,
1567: 'REPLY/RECEIVE VIA');
1568: IF ( X_temp_val = FALSE ) THEN
1569: po_interface_errors_sv1.handle_interface_errors(

Line 1576: 'PO_HEADERS_INTERFACE',

1572: null,
1573: X_interface_header_id,
1574: X_interface_line_id,
1575: 'PO_PDOI_INVALID_REPLY_METHOD',
1576: 'PO_HEADERS_INTERFACE',
1577: 'REPLY_METHOD_LOOKUP_CODE',
1578: 'VALUE',
1579: null,null,null,null,null,
1580: X_reply_method_lookup_code,

Line 1602: 'PO_HEADERS_INTERFACE',

1598: null,
1599: X_interface_header_id,
1600: X_interface_line_id,
1601: 'PO_PDOI_INVALID_FLAG_VALUE',
1602: 'PO_HEADERS_INTERFACE',
1603: 'CONFIRMING_ORDER_FLAG',
1604: 'COLUMN_NAME',
1605: 'VALUE',
1606: null,null,null,null,

Line 1626: 'PO_HEADERS_INTERFACE',

1622: null,
1623: X_interface_header_id,
1624: X_interface_line_id,
1625: 'PO_PDOI_INVALID_FLAG_VALUE',
1626: 'PO_HEADERS_INTERFACE',
1627: 'ACCEPTANCE_REQUIRED_FLAG',
1628: 'COLUMN_NAME',
1629: 'VALUE',
1630: null,null,null,null,

Line 1654: 'PO_HEADERS_INTERFACE',

1650: null,
1651: X_interface_header_id,
1652: X_interface_line_id,
1653: 'PO_PDOI_COLUMN_NOT_NULL',
1654: 'PO_HEADERS_INTERFACE',
1655: 'ACCEPTANCE_DUE_DATE',
1656: 'COLUMN_NAME',
1657: null,null,null,null,null,
1658: 'ACCEPTANCE_DUE_DATE',

Line 1674: 'PO_HEADERS_INTERFACE',

1670: null,
1671: X_interface_header_id,
1672: X_interface_line_id,
1673: 'PO_PDOI_COLUMN_NULL',
1674: 'PO_HEADERS_INTERFACE',
1675: 'ACCEPTANCE_DUE_DATE',
1676: 'COLUMN_NAME',
1677: null,null,null,null,null,
1678: 'ACCEPTANCE_DUE_DATE',

Line 1694: 'PO_HEADERS_INTERFACE',

1690: null,
1691: X_interface_header_id,
1692: X_interface_line_id,
1693: 'PO_PDOI_LT_ZERO',
1694: 'PO_HEADERS_INTERFACE',
1695: 'AMOUNT_AGREED',
1696: 'COLUMN_NAME',
1697: 'VALUE',
1698: null,null,null,null,

Line 1720: 'PO_HEADERS_INTERFACE',

1716: null,
1717: X_interface_header_id,
1718: X_interface_line_id,
1719: 'PO_PDOI_INVALID_FLAG_VALUE',
1720: 'PO_HEADERS_INTERFACE',
1721: 'FIRM_STATUS_LOOKUP_CODE',
1722: 'COLUMN_NAME',
1723: 'VALUE',
1724: null,null,null,null,

Line 1740: 'PO_HEADERS_INTERFACE',

1736: null,
1737: X_interface_header_id,
1738: X_interface_line_id,
1739: 'PO_PDOI_INVALID_VALUE',
1740: 'PO_HEADERS_INTERFACE',
1741: 'CANCEL_FLAG',
1742: 'COLUMN_NAME',
1743: 'VALUE',null,null,null,null,
1744: 'CANCEL_FLAG',

Line 1759: 'PO_HEADERS_INTERFACE',

1755: null,
1756: X_interface_header_id,
1757: X_interface_line_id,
1758: 'PO_PDOI_INVALID_VALUE',
1759: 'PO_HEADERS_INTERFACE',
1760: 'CLOSED_CODE',
1761: 'COLUMN_NAME',
1762: 'VALUE',null,null,null,null,
1763: 'CLOSED_CODE',

Line 1779: 'PO_HEADERS_INTERFACE',

1775: null,
1776: X_interface_header_id,
1777: X_interface_line_id,
1778: 'PO_PDOI_INVALID_VALUE',
1779: 'PO_HEADERS_INTERFACE',
1780: 'PRINT_COUNT',
1781: 'COLUMN_NAME',
1782: 'VALUE',null,null,null,null,
1783: 'PRINT_COUNT',

Line 1802: 'PO_HEADERS_INTERFACE',

1798: null,
1799: X_interface_header_id,
1800: X_interface_line_id,
1801: 'PO_PDOI_INVALID_VALUE',
1802: 'PO_HEADERS_INTERFACE',
1803: 'FROZEN_FLAG',
1804: 'COLUMN_NAME',
1805: 'VALUE',null,null,null,null,
1806: 'FROZEN_FLAG',

Line 1821: 'PO_HEADERS_INTERFACE',

1817: null,
1818: X_interface_header_id,
1819: X_interface_line_id,
1820: 'PO_PDOI_COLUMN_NOT_NULL',
1821: 'PO_HEADERS_INTERFACE',
1822: 'VENDOR_SITE_ID',
1823: 'COLUMN_NAME',
1824: null,null,null,null,null,
1825: 'VENDOR_SITE_ID',

Line 1846: 'PO_HEADERS_INTERFACE',

1842: null,
1843: X_interface_header_id,
1844: X_interface_line_id,
1845: 'PO_PDOI_INVALID_START_DATE',
1846: 'PO_HEADERS_INTERFACE',
1847: 'START_DATE',
1848: 'VALUE',
1849: null,null,null,null,null,
1850: X_start_date,

Line 1883: x_table_name => 'PO_HEADERS_INTERFACE',

1879: x_batch_id => null,
1880: x_interface_header_id => x_interface_header_id,
1881: x_interface_line_id => x_interface_line_id,
1882: x_error_message_name => 'PO_PDOI_VENDOR_SITE_CCR_INV',
1883: x_table_name => 'PO_HEADERS_INTERFACE',
1884: x_column_name => 'VENDOR_SITE_ID',
1885: x_tokenname1 => 'VENDOR_ID',
1886: x_tokenname2 => 'VENDOR_SITE_ID',
1887: x_tokenname3 => null,

Line 1915: 'PO_HEADERS_INTERFACE',

1911: null,
1912: X_interface_header_id,
1913: X_interface_line_id,
1914: 'PO_PDOI_INVALID_STATUS',
1915: 'PO_HEADERS_INTERFACE',
1916: 'APPROVAL_STATUS',
1917: null,null,null,null,null,null,
1918: null,null,null,null,null,null,
1919: x_header_processable_flag );

Line 1926: po_message_s.sql_error('validate_po_headers', x_progress, sqlcode);

1922:
1923: EXCEPTION
1924:
1925: WHEN others THEN
1926: po_message_s.sql_error('validate_po_headers', x_progress, sqlcode);
1927: raise;
1928: END validate_po_headers;
1929:
1930:

Line 1928: END validate_po_headers;

1924:
1925: WHEN others THEN
1926: po_message_s.sql_error('validate_po_headers', x_progress, sqlcode);
1927: raise;
1928: END validate_po_headers;
1929:
1930:
1931: END PO_HEADERS_SV6;

Line 1931: END PO_HEADERS_SV6;

1927: raise;
1928: END validate_po_headers;
1929:
1930:
1931: END PO_HEADERS_SV6;