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.JL_INTERFACE_VAL dependencies on JG_GLOBE_FLEX_VAL_SHARED

Line 401: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',

397: END IF;
398: End;
399: -- Validate Mul BS by distribution lines.
400: IF (validate_error = 'Error') THEN
401: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
402: invo_id,
403: 'MULTIPLE BAL SEG FOUND',
404: p_default_last_updated_by,
405: p_default_last_update_login,

Line 526: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',

522: AND nvl(end_date_active,sysdate) >= sysdate
523: AND enabled_flag = 'Y';
524: EXCEPTION
525: WHEN OTHERS THEN
526: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
527: p_parent_id,
528: 'INVALID_GLOBAL_ATTR11',
529: p_default_last_updated_by,
530: p_default_last_update_login,

Line 536: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',

532: p_current_invoice_status := 'N';
533:
534: END;
535: ELSE -- The Global Attribute11 is Required
536: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
537: p_parent_id,
538: 'INVALID_GLOBAL_ATTR11',
539: p_default_last_updated_by,
540: p_default_last_update_login,

Line 560: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',

556: AND nvl(end_date_active,sysdate) >= sysdate
557: AND enabled_flag = 'Y' ;
558: EXCEPTION
559: WHEN OTHERS THEN
560: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
561: p_parent_id,
562: 'INVALID_GLOBAL_ATTR12',
563: p_default_last_updated_by,
564: p_default_last_update_login,

Line 570: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',

566: p_current_invoice_status := 'N';
567:
568: END;
569: ELSE -- The Global Attribute12 is Required
570: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
571: p_parent_id,
572: 'INVALID_GLOBAL_ATTR12',
573: p_default_last_updated_by,
574: p_default_last_update_login,

Line 590: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',

586: WHERE trx_category = p_global_attribute11
587: and trx_letter = p_global_attribute12;
588: EXCEPTION
589: WHEN OTHERS THEN
590: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
591: p_parent_id,
592: 'INVALID_GLOBAL_ATTR13',
593: p_default_last_updated_by,
594: p_default_last_update_login,

Line 600: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',

596:
597: p_current_invoice_status := 'N';
598: END;
599: ELSE -- The Global Attribute13 is Required
600: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
601: p_parent_id,
602: 'INVALID_GLOBAL_ATTR13',
603: p_default_last_updated_by,
604: p_default_last_update_login,

Line 624: IF NOT (jg_globe_flex_val_shared.Check_Format (l_global_attribute15,'D',9,'','','','','','')) THEN

620: l_global_attribute15 := to_char(fnd_date.canonical_to_date(p_global_attribute15));
621: Length_Date := length (l_global_attribute15);
622:
623: IF (Length_Date = 9) THEN
624: IF NOT (jg_globe_flex_val_shared.Check_Format (l_global_attribute15,'D',9,'','','','','','')) THEN
625:
626: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
627: p_parent_id,
628: 'INVALID_GLOBAL_ATTR15',

Line 626: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',

622:
623: IF (Length_Date = 9) THEN
624: IF NOT (jg_globe_flex_val_shared.Check_Format (l_global_attribute15,'D',9,'','','','','','')) THEN
625:
626: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
627: p_parent_id,
628: 'INVALID_GLOBAL_ATTR15',
629: p_default_last_updated_by,
630: p_default_last_update_login,

Line 638: IF NOT(jg_globe_flex_val_shared.Check_Format (l_global_attribute15,'D', 11,'','','' ,'','','')) THEN

634:
635: END IF; -- Check_Format 9
636: ELSIF (Length_Date = 11) THEN
637:
638: IF NOT(jg_globe_flex_val_shared.Check_Format (l_global_attribute15,'D', 11,'','','' ,'','','')) THEN
639:
640: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
641: p_parent_id,
642: 'INVALID_GLOBAL_ATTR15',

Line 640: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',

636: ELSIF (Length_Date = 11) THEN
637:
638: IF NOT(jg_globe_flex_val_shared.Check_Format (l_global_attribute15,'D', 11,'','','' ,'','','')) THEN
639:
640: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
641: p_parent_id,
642: 'INVALID_GLOBAL_ATTR15',
643: p_default_last_updated_by,
644: p_default_last_update_login,

Line 651: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',

647: p_current_invoice_status := 'N';
648:
649: END IF; -- Check_Format 11
650: ELSE -- No Date Format.
651: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
652: p_parent_id,
653: 'INVALID_GLOBAL_ATTR15',
654: p_default_last_updated_by,
655: p_default_last_update_login,

Line 668: IF NOT(jg_globe_flex_val_shared.Check_Format (p_global_attribute16,'C',15,'','', '','','','')) THEN

664: IF (p_global_attribute16 IS NOT NULL) THEN
665: -- Bug 2729151
666: -- Changed the 3rd paramter of check_format from '0' to '15'
667:
668: IF NOT(jg_globe_flex_val_shared.Check_Format (p_global_attribute16,'C',15,'','', '','','','')) THEN
669:
670: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
671: p_parent_id,
672: 'INVALID_GLOBAL_ATTR16',

Line 670: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',

666: -- Changed the 3rd paramter of check_format from '0' to '15'
667:
668: IF NOT(jg_globe_flex_val_shared.Check_Format (p_global_attribute16,'C',15,'','', '','','','')) THEN
669:
670: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
671: p_parent_id,
672: 'INVALID_GLOBAL_ATTR16',
673: p_default_last_updated_by,
674: p_default_last_update_login,

Line 696: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',

692: AND enabled_flag = 'Y' ;
693: EXCEPTION
694: WHEN OTHERS THEN
695:
696: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
697: p_parent_id,
698: 'INVALID_GLOBAL_ATTR17',
699: p_default_last_updated_by,
700: p_default_last_update_login,

Line 706: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',

702: p_current_invoice_status := 'N';
703:
704: END;
705: ELSE -- The Global Attribute17 is Required
706: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
707: p_parent_id,
708: 'INVALID_GLOBAL_ATTR17',
709: p_default_last_updated_by,
710: p_default_last_update_login,

Line 732: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',

728: (p_global_attribute18 IS NOT NULL) --OR
729: --(p_global_attribute19 IS NOT NULL) OR
730: --(p_global_attribute20 IS NOT NULL)
731: ) THEN
732: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
733: p_parent_id,
734: 'GLOBAL_ATTR_VALUE_FOUND',
735: p_default_last_updated_by,
736: p_default_last_update_login,

Line 793: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',

789: END IF;
790: End;
791: -- Validate Mul BS by distribution lines.
792: IF (validate_error = 'Error') THEN
793: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
794: p_parent_id,
795: 'MULTIPLE BAL SEG FOUND',
796: p_default_last_updated_by,
797: p_default_last_update_login,

Line 865: jg_globe_flex_val_shared.insert_rejections('AP_INVOICE_LINES_INTERFACE',

861: AND sysdate < nvl(inactive_date, sysdate+1); -- Bug 3463869
862: EXCEPTION
863:
864: WHEN OTHERS THEN
865: jg_globe_flex_val_shared.insert_rejections('AP_INVOICE_LINES_INTERFACE',
866: p_parent_id,
867: 'INVALID_GLOBAL_ATTR3',
868: p_default_last_updated_by,
869: p_default_last_update_login,

Line 876: jg_globe_flex_val_shared.insert_rejections('AP_INVOICE_LINES_INTERFACE',

872:
873: END;
874: ELSE -- The Global Attribute3 is Required
875:
876: jg_globe_flex_val_shared.insert_rejections('AP_INVOICE_LINES_INTERFACE',
877: p_parent_id,
878: 'INVALID_GLOBAL_ATTR3',
879: p_default_last_updated_by,
880: p_default_last_update_login,

Line 887: IF NOT (jg_globe_flex_val_shared.Check_Format (p_global_attribute4,'N',0, '','','','','','')) THEN

883: END IF; -- p_global_attribute3 is not null
884:
885: -- Tax Inclusive Amount
886: IF (p_global_attribute4 IS NOT NULL) THEN
887: IF NOT (jg_globe_flex_val_shared.Check_Format (p_global_attribute4,'N',0, '','','','','','')) THEN
888: jg_globe_flex_val_shared.insert_rejections('AP_INVOICE_LINES_INTERFACE',
889: p_parent_id,
890: 'INVALID_GLOBAL_ATTR4',
891: p_default_last_updated_by,

Line 888: jg_globe_flex_val_shared.insert_rejections('AP_INVOICE_LINES_INTERFACE',

884:
885: -- Tax Inclusive Amount
886: IF (p_global_attribute4 IS NOT NULL) THEN
887: IF NOT (jg_globe_flex_val_shared.Check_Format (p_global_attribute4,'N',0, '','','','','','')) THEN
888: jg_globe_flex_val_shared.insert_rejections('AP_INVOICE_LINES_INTERFACE',
889: p_parent_id,
890: 'INVALID_GLOBAL_ATTR4',
891: p_default_last_updated_by,
892: p_default_last_update_login,

Line 920: jg_globe_flex_val_shared.insert_rejections('AP_INVOICE_LINES_INTERFACE',

916: (p_global_attribute18 IS NOT NULL) OR
917: (p_global_attribute19 IS NOT NULL) OR
918: (p_global_attribute20 IS NOT NULL))
919: THEN
920: jg_globe_flex_val_shared.insert_rejections('AP_INVOICE_LINES_INTERFACE',
921: p_parent_id,
922: 'GLOBAL_ATTR_VALUE_FOUND',
923: p_default_last_updated_by,
924: p_default_last_update_login,

Line 986: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',

982: AND sysdate < nvl(inactive_date, sysdate+1); -- Bug 3463869
983: EXCEPTION
984:
985: WHEN OTHERS THEN
986: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
987: p_parent_id,
988: 'INVALID_GLOBAL_ATTR18',
989: p_default_last_updated_by,
990: p_default_last_update_login,

Line 1018: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',

1014: (p_global_attribute17 IS NOT NULL) OR
1015: (p_global_attribute19 IS NOT NULL) OR
1016: (p_global_attribute20 IS NOT NULL))
1017: THEN
1018: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
1019: p_parent_id,
1020: 'GLOBAL_ATTR_VALUE_FOUND',
1021: p_default_last_updated_by,
1022: p_default_last_update_login,

Line 1090: jg_globe_flex_val_shared.insert_rejections('AP_INVOICE_LINES_INTERFACE',

1086: EXCEPTION
1087:
1088: WHEN OTHERS THEN
1089:
1090: jg_globe_flex_val_shared.insert_rejections('AP_INVOICE_LINES_INTERFACE',
1091: p_parent_id,
1092: 'INVALID_GLOBAL_ATTR2',
1093: p_default_last_updated_by,
1094: p_default_last_update_login,

Line 1115: jg_globe_flex_val_shared.insert_rejections('AP_INVOICE_LINES_INTERFACE',

1111: EXCEPTION
1112:
1113: WHEN OTHERS THEN
1114:
1115: jg_globe_flex_val_shared.insert_rejections('AP_INVOICE_LINES_INTERFACE',
1116: p_parent_id,
1117: 'INVALID_GLOBAL_ATTR3',
1118: p_default_last_updated_by,
1119: p_default_last_update_login,

Line 1125: jg_globe_flex_val_shared.insert_rejections('AP_INVOICE_LINES_INTERFACE',

1121: p_current_invoice_status := 'N';
1122:
1123: END;
1124: ELSE -- The Global Attribute3 is Required
1125: jg_globe_flex_val_shared.insert_rejections('AP_INVOICE_LINES_INTERFACE',
1126: p_parent_id,
1127: 'INVALID_GLOBAL_ATTR3',
1128: p_default_last_updated_by,
1129: p_default_last_update_login,

Line 1155: jg_globe_flex_val_shared.insert_rejections('AP_INVOICE_LINES_INTERFACE',

1151: (p_global_attribute18 IS NOT NULL) OR
1152: (p_global_attribute19 IS NOT NULL) OR
1153: (p_global_attribute20 IS NOT NULL))
1154: THEN
1155: jg_globe_flex_val_shared.insert_rejections('AP_INVOICE_LINES_INTERFACE',
1156: p_parent_id,
1157: 'GLOBAL_ATTR_VALUE_FOUND',
1158: p_default_last_updated_by,
1159: p_default_last_update_login,

Line 1362: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,

1358: -- Modification to the passing of parameters to ar_business_rules for TCA model
1359:
1360: PROCEDURE ar_business_rules
1361: (p_int_table_name IN VARCHAR2,
1362: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
1363: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
1364: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
1365: p_misc_prod_arg IN jg_globe_flex_val_shared.GenRec,
1366: p_current_record_status OUT NOCOPY VARCHAR2) IS

Line 1363: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,

1359:
1360: PROCEDURE ar_business_rules
1361: (p_int_table_name IN VARCHAR2,
1362: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
1363: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
1364: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
1365: p_misc_prod_arg IN jg_globe_flex_val_shared.GenRec,
1366: p_current_record_status OUT NOCOPY VARCHAR2) IS
1367:

Line 1364: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,

1360: PROCEDURE ar_business_rules
1361: (p_int_table_name IN VARCHAR2,
1362: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
1363: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
1364: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
1365: p_misc_prod_arg IN jg_globe_flex_val_shared.GenRec,
1366: p_current_record_status OUT NOCOPY VARCHAR2) IS
1367:
1368: l_current_record_status VARCHAR2(1); -- := 'S';

Line 1365: p_misc_prod_arg IN jg_globe_flex_val_shared.GenRec,

1361: (p_int_table_name IN VARCHAR2,
1362: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
1363: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
1364: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
1365: p_misc_prod_arg IN jg_globe_flex_val_shared.GenRec,
1366: p_current_record_status OUT NOCOPY VARCHAR2) IS
1367:
1368: l_current_record_status VARCHAR2(1); -- := 'S';
1369: l_ou_id NUMBER;

Line 1475: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,

1471: END ar_business_rules;
1472:
1473:
1474: PROCEDURE jl_zz_arxcudci_cust_txid(
1475: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
1476: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
1477: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
1478: p_misc_prod_arg IN jg_globe_flex_val_shared.GenRec,
1479: p_record_status OUT NOCOPY VARCHAR2) IS

Line 1476: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,

1472:
1473:
1474: PROCEDURE jl_zz_arxcudci_cust_txid(
1475: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
1476: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
1477: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
1478: p_misc_prod_arg IN jg_globe_flex_val_shared.GenRec,
1479: p_record_status OUT NOCOPY VARCHAR2) IS
1480:

Line 1477: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,

1473:
1474: PROCEDURE jl_zz_arxcudci_cust_txid(
1475: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
1476: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
1477: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
1478: p_misc_prod_arg IN jg_globe_flex_val_shared.GenRec,
1479: p_record_status OUT NOCOPY VARCHAR2) IS
1480:
1481: l_record_status VARCHAR2(1); -- := 'S';

Line 1478: p_misc_prod_arg IN jg_globe_flex_val_shared.GenRec,

1474: PROCEDURE jl_zz_arxcudci_cust_txid(
1475: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
1476: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
1477: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
1478: p_misc_prod_arg IN jg_globe_flex_val_shared.GenRec,
1479: p_record_status OUT NOCOPY VARCHAR2) IS
1480:
1481: l_record_status VARCHAR2(1); -- := 'S';
1482:

Line 1524: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,

1520: -- 2 Primary ID Validation Digit GLOBAL_ATTRIBUTE12 JLCL_TAXID_VAL_DIGIT
1521:
1522: -----------------------------------------------------------------------------------
1523: PROCEDURE jl_cl_arxcudci_customers(
1524: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
1525: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
1526: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
1527: p_misc_prod_arg IN jg_globe_flex_val_shared.GenRec,
1528: p_record_status OUT NOCOPY VARCHAR2) IS

Line 1525: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,

1521:
1522: -----------------------------------------------------------------------------------
1523: PROCEDURE jl_cl_arxcudci_customers(
1524: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
1525: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
1526: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
1527: p_misc_prod_arg IN jg_globe_flex_val_shared.GenRec,
1528: p_record_status OUT NOCOPY VARCHAR2) IS
1529:

Line 1526: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,

1522: -----------------------------------------------------------------------------------
1523: PROCEDURE jl_cl_arxcudci_customers(
1524: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
1525: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
1526: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
1527: p_misc_prod_arg IN jg_globe_flex_val_shared.GenRec,
1528: p_record_status OUT NOCOPY VARCHAR2) IS
1529:
1530: l_record_status VARCHAR2(1); -- := 'S';

Line 1527: p_misc_prod_arg IN jg_globe_flex_val_shared.GenRec,

1523: PROCEDURE jl_cl_arxcudci_customers(
1524: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
1525: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
1526: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
1527: p_misc_prod_arg IN jg_globe_flex_val_shared.GenRec,
1528: p_record_status OUT NOCOPY VARCHAR2) IS
1529:
1530: l_record_status VARCHAR2(1); -- := 'S';
1531: l_taxid_record_status VARCHAR2(1); -- := 'S';

Line 1602: jg_globe_flex_val_shared.update_interface_status (l_row_id,

1598:
1599: END IF;
1600:
1601: IF (l_record_status = 'E') THEN
1602: jg_globe_flex_val_shared.update_interface_status (l_row_id,
1603: 'RA_CUSTOMERS_INTERFACE',
1604: l_mesg_code,
1605: l_record_status);
1606: END IF;

Line 1636: jg_globe_flex_val_shared.update_interface_status (l_row_id,

1632: END IF; -- End IF taxpayer ID is not null.
1633: END IF; -- End IF l_record_status = 'S'
1634:
1635: IF (l_taxid_record_status = 'E') THEN
1636: jg_globe_flex_val_shared.update_interface_status (l_row_id,
1637: 'RA_CUSTOMERS_INTERFACE',
1638: l_taxid_mesg_code,
1639: l_taxid_record_status);
1640: ELSIF (l_taxid_record_status = 'W') THEN

Line 1641: jg_globe_flex_val_shared.update_interface_status (l_row_id,

1637: 'RA_CUSTOMERS_INTERFACE',
1638: l_taxid_mesg_code,
1639: l_taxid_record_status);
1640: ELSIF (l_taxid_record_status = 'W') THEN
1641: jg_globe_flex_val_shared.update_interface_status (l_row_id,
1642: 'RA_CUSTOMERS_INTERFACE',
1643: l_taxid_mesg_code,
1644: l_taxid_record_status);
1645: END IF;

Line 1669: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,

1665:
1666: -------------------------------------------------------------------------------------
1667:
1668: PROCEDURE jl_co_arxcudci_customers(
1669: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
1670: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
1671: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
1672: p_misc_prod_arg IN jg_globe_flex_val_shared.GenRec,
1673: p_record_status OUT NOCOPY VARCHAR2) IS

Line 1670: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,

1666: -------------------------------------------------------------------------------------
1667:
1668: PROCEDURE jl_co_arxcudci_customers(
1669: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
1670: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
1671: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
1672: p_misc_prod_arg IN jg_globe_flex_val_shared.GenRec,
1673: p_record_status OUT NOCOPY VARCHAR2) IS
1674:

Line 1671: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,

1667:
1668: PROCEDURE jl_co_arxcudci_customers(
1669: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
1670: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
1671: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
1672: p_misc_prod_arg IN jg_globe_flex_val_shared.GenRec,
1673: p_record_status OUT NOCOPY VARCHAR2) IS
1674:
1675: l_record_status VARCHAR2(1); -- := 'S';

Line 1672: p_misc_prod_arg IN jg_globe_flex_val_shared.GenRec,

1668: PROCEDURE jl_co_arxcudci_customers(
1669: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
1670: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
1671: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
1672: p_misc_prod_arg IN jg_globe_flex_val_shared.GenRec,
1673: p_record_status OUT NOCOPY VARCHAR2) IS
1674:
1675: l_record_status VARCHAR2(1); -- := 'S';
1676: l_taxid_record_status VARCHAR2(1); -- := 'S';

Line 1749: jg_globe_flex_val_shared.update_interface_status (l_row_id,

1745: l_record_status := 'E';
1746: END IF;
1747:
1748: IF (l_record_status = 'E') THEN
1749: jg_globe_flex_val_shared.update_interface_status (l_row_id,
1750: 'RA_CUSTOMERS_INTERFACE',
1751: l_mesg_code,
1752: l_record_status);
1753: END IF;

Line 1781: jg_globe_flex_val_shared.update_interface_status (l_row_id,

1777: END IF; -- End IF l_record_status = 'S'
1778:
1779:
1780: IF (l_taxid_record_status = 'E') THEN
1781: jg_globe_flex_val_shared.update_interface_status (l_row_id,
1782: 'RA_CUSTOMERS_INTERFACE',
1783: l_taxid_mesg_code,
1784: l_taxid_record_status);
1785:

Line 1787: jg_globe_flex_val_shared.update_interface_status (l_row_id,

1783: l_taxid_mesg_code,
1784: l_taxid_record_status);
1785:
1786: ELSIF (l_taxid_record_status = 'W') THEN
1787: jg_globe_flex_val_shared.update_interface_status (l_row_id,
1788: 'RA_CUSTOMERS_INTERFACE',
1789: l_taxid_mesg_code,
1790: l_taxid_record_status);
1791: END IF;

Line 1816: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,

1812: -- 3 Primary ID Validation Digit GLOBAL_ATTRIBUTE12 JLZZ_TAXID_VAL_DIGIT
1813:
1814: -------------------------------------------------------------------------------
1815: PROCEDURE jl_ar_arxcudci_customers(
1816: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
1817: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
1818: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
1819: p_misc_prod_arg IN jg_globe_flex_val_shared.GenRec,
1820: p_record_status OUT NOCOPY VARCHAR2) IS

Line 1817: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,

1813:
1814: -------------------------------------------------------------------------------
1815: PROCEDURE jl_ar_arxcudci_customers(
1816: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
1817: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
1818: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
1819: p_misc_prod_arg IN jg_globe_flex_val_shared.GenRec,
1820: p_record_status OUT NOCOPY VARCHAR2) IS
1821:

Line 1818: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,

1814: -------------------------------------------------------------------------------
1815: PROCEDURE jl_ar_arxcudci_customers(
1816: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
1817: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
1818: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
1819: p_misc_prod_arg IN jg_globe_flex_val_shared.GenRec,
1820: p_record_status OUT NOCOPY VARCHAR2) IS
1821:
1822: l_lookup_code VARCHAR2(2);

Line 1819: p_misc_prod_arg IN jg_globe_flex_val_shared.GenRec,

1815: PROCEDURE jl_ar_arxcudci_customers(
1816: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
1817: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
1818: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
1819: p_misc_prod_arg IN jg_globe_flex_val_shared.GenRec,
1820: p_record_status OUT NOCOPY VARCHAR2) IS
1821:
1822: l_lookup_code VARCHAR2(2);
1823: l_record_status VARCHAR2(1); --:= 'S';

Line 1915: jg_globe_flex_val_shared.update_interface_status (l_row_id,

1911:
1912: END IF;
1913:
1914: IF (l_record_status = 'E') THEN
1915: jg_globe_flex_val_shared.update_interface_status (l_row_id,
1916: 'RA_CUSTOMERS_INTERFACE',
1917: l_mesg_code,
1918: l_record_status);
1919: END IF;

Line 1946: jg_globe_flex_val_shared.update_interface_status (l_row_id,

1942: END IF; -- End IF taxpayer ID is not null.
1943: END IF; -- End IF l_record_status = 'S'
1944:
1945: IF (l_taxid_record_status = 'E') THEN
1946: jg_globe_flex_val_shared.update_interface_status (l_row_id,
1947: 'RA_CUSTOMERS_INTERFACE',
1948: l_taxid_mesg_code,
1949: l_taxid_record_status);
1950: ELSIF (l_taxid_record_status = 'W') THEN

Line 1951: jg_globe_flex_val_shared.update_interface_status (l_row_id,

1947: 'RA_CUSTOMERS_INTERFACE',
1948: l_taxid_mesg_code,
1949: l_taxid_record_status);
1950: ELSIF (l_taxid_record_status = 'W') THEN
1951: jg_globe_flex_val_shared.update_interface_status (l_row_id,
1952: 'RA_CUSTOMERS_INTERFACE',
1953: l_taxid_mesg_code,
1954: l_taxid_record_status);
1955: END IF;

Line 2395: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',

2391: AND enabled_flag = 'Y';
2392: EXCEPTION
2393:
2394: WHEN OTHERS THEN
2395: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
2396: p_parent_id,
2397: 'INVALID_GLOBAL_ATTR1',
2398: p_default_last_updated_by,
2399: p_default_last_update_login,

Line 2405: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',

2401: p_current_invoice_status := 'N';
2402:
2403: END;
2404: ELSE -- The Global Attribute1 is Required
2405: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
2406: p_parent_id,
2407: 'INVALID_GLOBAL_ATTR1',
2408: p_default_last_updated_by,
2409: p_default_last_update_login,

Line 2425: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',

2421: FROM jl_br_ap_operations
2422: WHERE cfo_code = p_global_attribute2;
2423: EXCEPTION
2424: WHEN OTHERS THEN
2425: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
2426: p_parent_id,
2427: 'INVALID_GLOBAL_ATTR2',
2428: p_default_last_updated_by,
2429: p_default_last_update_login,

Line 2450: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',

2446: AND enabled_flag = 'Y';
2447: EXCEPTION
2448:
2449: WHEN OTHERS THEN
2450: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
2451: p_parent_id,
2452: 'INVALID_GLOBAL_ATTR3',
2453: p_default_last_updated_by,
2454: p_default_last_update_login,

Line 2476: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',

2472: AND enabled_flag = 'Y';
2473: EXCEPTION
2474:
2475: WHEN OTHERS THEN
2476: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
2477: p_parent_id,
2478: 'INVALID_GLOBAL_ATTR4',
2479: p_default_last_updated_by,
2480: p_default_last_update_login,

Line 2490: IF (NOT jg_globe_flex_val_shared.check_format(p_global_attribute5,'N',15,2,'N','N','N','','')) THEN

2486:
2487: -- Format for ICMS Base Amount
2488:
2489: /* NUMBER(15,2),Numbers Only (0-9)*/
2490: IF (NOT jg_globe_flex_val_shared.check_format(p_global_attribute5,'N',15,2,'N','N','N','','')) THEN
2491: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
2492: p_parent_id,
2493: 'INVALID_GLOBAL_ATTR5',
2494: p_default_last_updated_by,

Line 2491: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',

2487: -- Format for ICMS Base Amount
2488:
2489: /* NUMBER(15,2),Numbers Only (0-9)*/
2490: IF (NOT jg_globe_flex_val_shared.check_format(p_global_attribute5,'N',15,2,'N','N','N','','')) THEN
2491: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
2492: p_parent_id,
2493: 'INVALID_GLOBAL_ATTR5',
2494: p_default_last_updated_by,
2495: p_default_last_update_login,

Line 2529: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',

2525: AND nvl(enabled_flag,'Y') = 'Y';
2526: EXCEPTION
2527:
2528: WHEN OTHERS THEN
2529: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
2530: p_parent_id,
2531: 'INVALID_GLOBAL_ATTR6',
2532: p_default_last_updated_by,
2533: p_default_last_update_login,

Line 2543: IF (NOT jg_globe_flex_val_shared.check_format(p_global_attribute7,'N',15,2,'N','N','N','','')) THEN

2539:
2540: -- Format for ICMS Amount
2541:
2542: /* NUMBER(15,2),Numbers Only (0-9)*/
2543: IF (NOT jg_globe_flex_val_shared.check_format(p_global_attribute7,'N',15,2,'N','N','N','','')) THEN
2544: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
2545: p_parent_id,
2546: 'INVALID_GLOBAL_ATTR7',
2547: p_default_last_updated_by,

Line 2544: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',

2540: -- Format for ICMS Amount
2541:
2542: /* NUMBER(15,2),Numbers Only (0-9)*/
2543: IF (NOT jg_globe_flex_val_shared.check_format(p_global_attribute7,'N',15,2,'N','N','N','','')) THEN
2544: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
2545: p_parent_id,
2546: 'INVALID_GLOBAL_ATTR7',
2547: p_default_last_updated_by,
2548: p_default_last_update_login,

Line 2556: IF (NOT jg_globe_flex_val_shared.check_format(p_global_attribute8,'N',15,2,'N','N','N','','')) THEN

2552:
2553: -- Format for IPI Amount
2554:
2555: /* NUMBER(15,2),Numbers Only (0-9)*/
2556: IF (NOT jg_globe_flex_val_shared.check_format(p_global_attribute8,'N',15,2,'N','N','N','','')) THEN
2557: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
2558: p_parent_id,
2559: 'INVALID_GLOBAL_ATTR8',
2560: p_default_last_updated_by,

Line 2557: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',

2553: -- Format for IPI Amount
2554:
2555: /* NUMBER(15,2),Numbers Only (0-9)*/
2556: IF (NOT jg_globe_flex_val_shared.check_format(p_global_attribute8,'N',15,2,'N','N','N','','')) THEN
2557: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
2558: p_parent_id,
2559: 'INVALID_GLOBAL_ATTR8',
2560: p_default_last_updated_by,
2561: p_default_last_update_login,

Line 2569: IF (NOT jg_globe_flex_val_shared.check_format(p_global_attribute9,'N',15,2,'Y','N','N','','')) THEN

2565:
2566: -- Format for Withholding Base Amount
2567:
2568: /* NUMBER(15,2)*/
2569: IF (NOT jg_globe_flex_val_shared.check_format(p_global_attribute9,'N',15,2,'Y','N','N','','')) THEN
2570: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
2571: p_parent_id,
2572: 'INVALID_GLOBAL_ATTR9',
2573: p_default_last_updated_by,

Line 2570: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',

2566: -- Format for Withholding Base Amount
2567:
2568: /* NUMBER(15,2)*/
2569: IF (NOT jg_globe_flex_val_shared.check_format(p_global_attribute9,'N',15,2,'Y','N','N','','')) THEN
2570: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
2571: p_parent_id,
2572: 'INVALID_GLOBAL_ATTR9',
2573: p_default_last_updated_by,
2574: p_default_last_update_login,

Line 2582: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',

2578:
2579: -- Validation for Consolidated Invoice Number (Should be NULL at this point)
2580:
2581: IF (p_global_attribute10 IS NOT NULL) THEN
2582: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
2583: p_parent_id,
2584: 'INVALID_GLOBAL_ATTR10',
2585: p_default_last_updated_by,
2586: p_default_last_update_login,

Line 2606: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',

2602: (p_global_attribute18 IS NOT NULL) OR
2603: (p_global_attribute19 IS NOT NULL) OR
2604: (p_global_attribute20 IS NOT NULL))
2605: THEN
2606: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
2607: p_parent_id,
2608: 'GLOBAL_ATTR_VALUE_FOUND',
2609: p_default_last_updated_by,
2610: p_default_last_update_login,

Line 2670: jg_globe_flex_val_shared.insert_rejections('AP_INVOICE_LINES_INTERFACE',

2666: WHERE p_line_type_lookup_code = 'ITEM'
2667: AND CFO_CODE = p_global_attribute1;
2668: EXCEPTION
2669: WHEN OTHERS THEN
2670: jg_globe_flex_val_shared.insert_rejections('AP_INVOICE_LINES_INTERFACE',
2671: p_parent_id,
2672: 'INVALID_GLOBAL_ATTR1',
2673: p_default_last_updated_by,
2674: p_default_last_update_login,

Line 2702: jg_globe_flex_val_shared.insert_rejections('AP_INVOICE_LINES_INTERFACE',

2698: (p_global_attribute18 IS NOT NULL) OR
2699: (p_global_attribute19 IS NOT NULL) OR
2700: (p_global_attribute20 IS NOT NULL))
2701: THEN
2702: jg_globe_flex_val_shared.insert_rejections('AP_INVOICE_LINES_INTERFACE',
2703: p_parent_id,
2704: 'GLOBAL_ATTR_VALUE_FOUND',
2705: p_default_last_updated_by,
2706: p_default_last_update_login,

Line 2759: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',

2755: AND parent_table = 'AP_INVOICES_INTERFACE'
2756: AND REJECT_LOOKUP_CODE = 'INVALID_GLOBAL_ATTR2';
2757: EXCEPTION
2758: WHEN NO_DATA_FOUND THEN
2759: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
2760: l_invoice_id,
2761: 'INVALID_GLOBAL_ATTR2',
2762: p_default_last_updated_by,
2763: p_default_last_update_login,

Line 2780: ( p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,

2776: -- IF any validation fails, this procedure writes the error code
2777: -- in the interface_status column of RA_CUSTOMERS_INTERFACE
2778: --========================================================================
2779: Procedure jl_br_arxcudci_additional
2780: ( p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
2781: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
2782: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
2783: p_misc_prod_arg IN jg_globe_flex_val_shared.GenRec,
2784: p_record_status OUT NOCOPY VARCHAR2)

Line 2781: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,

2777: -- in the interface_status column of RA_CUSTOMERS_INTERFACE
2778: --========================================================================
2779: Procedure jl_br_arxcudci_additional
2780: ( p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
2781: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
2782: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
2783: p_misc_prod_arg IN jg_globe_flex_val_shared.GenRec,
2784: p_record_status OUT NOCOPY VARCHAR2)
2785: IS

Line 2782: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,

2778: --========================================================================
2779: Procedure jl_br_arxcudci_additional
2780: ( p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
2781: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
2782: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
2783: p_misc_prod_arg IN jg_globe_flex_val_shared.GenRec,
2784: p_record_status OUT NOCOPY VARCHAR2)
2785: IS
2786: l_inscription_type varchar2(1);

Line 2783: p_misc_prod_arg IN jg_globe_flex_val_shared.GenRec,

2779: Procedure jl_br_arxcudci_additional
2780: ( p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
2781: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
2782: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
2783: p_misc_prod_arg IN jg_globe_flex_val_shared.GenRec,
2784: p_record_status OUT NOCOPY VARCHAR2)
2785: IS
2786: l_inscription_type varchar2(1);
2787: l_inscription_number varchar2(9);

Line 2875: jg_globe_flex_val_shared.update_interface_status

2871: IF l_error_code IS NULL THEN
2872: p_record_status := 'S';
2873: ELSE
2874: p_record_status := 'E';
2875: jg_globe_flex_val_shared.update_interface_status
2876: (l_row_id,
2877: 'RA_CUSTOMERS_INTERFACE',
2878: l_error_code,
2879: p_record_status);

Line 2893: ( p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,

2889: --INTERFACE
2890: --========================================================================+
2891:
2892: PROCEDURE jl_br_customer_profiles
2893: ( p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
2894: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
2895: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
2896: p_misc_prod_arg IN jg_globe_flex_val_shared.GenRec,
2897: p_record_status OUT NOCOPY VARCHAR2)

Line 2894: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,

2890: --========================================================================+
2891:
2892: PROCEDURE jl_br_customer_profiles
2893: ( p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
2894: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
2895: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
2896: p_misc_prod_arg IN jg_globe_flex_val_shared.GenRec,
2897: p_record_status OUT NOCOPY VARCHAR2)
2898: IS

Line 2895: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,

2891:
2892: PROCEDURE jl_br_customer_profiles
2893: ( p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
2894: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
2895: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
2896: p_misc_prod_arg IN jg_globe_flex_val_shared.GenRec,
2897: p_record_status OUT NOCOPY VARCHAR2)
2898: IS
2899:

Line 2896: p_misc_prod_arg IN jg_globe_flex_val_shared.GenRec,

2892: PROCEDURE jl_br_customer_profiles
2893: ( p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
2894: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
2895: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
2896: p_misc_prod_arg IN jg_globe_flex_val_shared.GenRec,
2897: p_record_status OUT NOCOPY VARCHAR2)
2898: IS
2899:
2900: dummy_code NUMBER;

Line 2951: jg_globe_flex_val_shared.update_interface_status

2947: IF l_error_code IS NULL THEN
2948: p_record_status := 'S';
2949: ELSE
2950: p_record_status := 'E';
2951: jg_globe_flex_val_shared.update_interface_status
2952: (l_row_id,
2953: 'RA_CUSTOMER_PROFILES_INTERFACE',
2954: l_error_code,
2955: p_record_status);

Line 2966: ( p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,

2962: -- IF any validation fails, this procedure writes the error code
2963: -- in the interface_status column of RA_CUSTOMERS_INTERFACE
2964: --========================================================================
2965: procedure jl_zz_ar_tx_arxcudci_address
2966: ( p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
2967: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
2968: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
2969: p_misc_prod_arg IN jg_globe_flex_val_shared.GenRec,
2970: p_record_status OUT NOCOPY VARCHAR2) IS

Line 2967: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,

2963: -- in the interface_status column of RA_CUSTOMERS_INTERFACE
2964: --========================================================================
2965: procedure jl_zz_ar_tx_arxcudci_address
2966: ( p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
2967: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
2968: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
2969: p_misc_prod_arg IN jg_globe_flex_val_shared.GenRec,
2970: p_record_status OUT NOCOPY VARCHAR2) IS
2971:

Line 2968: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,

2964: --========================================================================
2965: procedure jl_zz_ar_tx_arxcudci_address
2966: ( p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
2967: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
2968: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
2969: p_misc_prod_arg IN jg_globe_flex_val_shared.GenRec,
2970: p_record_status OUT NOCOPY VARCHAR2) IS
2971:
2972: l_error_code varchar2(50) DEFAULT NULL;

Line 2969: p_misc_prod_arg IN jg_globe_flex_val_shared.GenRec,

2965: procedure jl_zz_ar_tx_arxcudci_address
2966: ( p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
2967: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
2968: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
2969: p_misc_prod_arg IN jg_globe_flex_val_shared.GenRec,
2970: p_record_status OUT NOCOPY VARCHAR2) IS
2971:
2972: l_error_code varchar2(50) DEFAULT NULL;
2973: l_row_id ROWID; -- := p_misc_prod_arg.core_prod_arg2;

Line 3046: jg_globe_flex_val_shared.update_interface_status (l_row_id,

3042: IF l_error_code IS NULL THEN
3043: p_record_status := 'S';
3044: ELSE
3045: p_record_status := 'E';
3046: jg_globe_flex_val_shared.update_interface_status (l_row_id,
3047: 'RA_CUSTOMERS_INTERFACE',
3048: l_error_code,
3049: p_record_status);
3050: END IF;

Line 3113: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',

3109: AND enabled_flag = 'Y';
3110: EXCEPTION
3111:
3112: WHEN OTHERS THEN
3113: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
3114: p_parent_id,
3115: 'INVALID_GLOBAL_ATTR19',
3116: p_default_last_updated_by,
3117: p_default_last_update_login,

Line 3147: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',

3143: (p_global_attribute17 IS NOT NULL) OR
3144: (p_global_attribute18 IS NOT NULL) OR
3145: (p_global_attribute20 IS NOT NULL))
3146: THEN
3147: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
3148: p_parent_id,
3149: 'GLOBAL_ATTR_VALUE_FOUND',
3150: p_default_last_updated_by,
3151: p_default_last_update_login,