APPS.JL_INTERFACE_VAL dependencies on AP_INVOICE_LINES_INTERFACE

Line 353: FROM ap_invoice_lines_interface

349: l_ignore NUMBER;
350: Begin
351: SELECT invoice_id
352: INTO invo_id
353: FROM ap_invoice_lines_interface
354: WHERE invoice_line_id = P_parent_id;
355:
356: ----------------------------------------------------------------------------------------
357: -- Get Set of Books and Auto-offsets Option info

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 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 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 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 2732: FROM ap_invoice_lines_interface

2728: BEGIN
2729: BEGIN
2730: SELECT invoice_id,po_number
2731: INTO l_invoice_id,l_po_number
2732: FROM ap_invoice_lines_interface
2733: WHERE invoice_line_id = p_parent_id;
2734: EXCEPTION
2735: WHEN OTHERS THEN
2736: null;