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_ZZ_AUTO_INVOICE dependencies on JG_ZZ_AUTO_INVOICE

Line 56: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'

52: IF p_line_type = 'LINE' THEN
53:
54: IF p_warehouse_id IS NULL AND
55: p_inventory_item_id IS NOT NULL THEN
56: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'
57: ,'JL_ZZ_AR_TX_SHIP_FROM_ORG_REQ'
58: ,p_interface_line_id , p_warehouse_id) THEN
59: RAISE error_condition;
60: END IF;

Line 73: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'

69: AND hl.location_id = hou.location_id
70: AND hl.global_attribute1 IS NOT NULL;
71: EXCEPTION
72: WHEN NO_DATA_FOUND THEN
73: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'
74: ,'JL_ZZ_AR_TX_ORG_CLASS_INVALID'
75: ,p_interface_line_id ,p_warehouse_id) THEN
76: RAISE error_condition;
77: END IF;

Line 95: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'

91: l_contributor_class := NULL;
92: END;
93:
94: IF l_contributor_class IS NULL THEN
95: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'
96: ,'JL_ZZ_AR_TX_CONTRIB_CLASS_INV'
97: ,p_interface_line_id
98: ,p_address_id) THEN
99: RAISE error_condition;

Line 125: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'

121: END;
122: END IF;
123:
124: IF l_count = 0 THEN
125: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'
126: ,'JL_ZZ_AR_TX_CUS_SITE_PROF_REQ'
127: ,p_interface_line_id
128: ,p_address_id) THEN
129: RAISE error_condition;

Line 153: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'

149: AND sysdate between nvl(start_date_active,sysdate)
150: and nvl(end_date_active,sysdate);
151: EXCEPTION
152: WHEN NO_DATA_FOUND THEN
153: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'
154: ,'JL_ZZ_AR_TX_RAXTRX_FSC_CLS_INV'
155: ,p_interface_line_id , p_product_fiscal_class) THEN
156: RAISE error_condition;
157: END IF;

Line 162: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'

158: WHEN OTHERS THEN
159: RAISE error_condition;
160: END; -- p_product_fiscal_class
161: ELSE
162: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'
163: ,'JL_ZZ_AR_TX_RAXTRX_FSC_CLS_MND'
164: ,p_interface_line_id
165: ,p_product_fiscal_class) THEN
166: RAISE error_condition;

Line 173: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'

169: */
170:
171: /* IF p_product_fiscal_class IS NULL AND
172: p_product_category IS NULL THEN
173: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'
174: ,'JL_ZZ_AR_TX_RAXTRX_FSC_CLS_MND'
175: ,p_interface_line_id
176: ,p_product_fiscal_class) THEN
177: RAISE error_condition;

Line 211: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'

207: AND sysdate BETWEEN nvl(start_date_active,sysdate)
208: AND nvl(end_date_active,sysdate);
209: EXCEPTION
210: WHEN NO_DATA_FOUND THEN
211: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'
212: ,'JL_ZZ_AR_TX_RAXTRX_TRX_NAT_INV'
213: ,p_interface_line_id
214: ,p_trx_business_category) THEN
215: RAISE error_condition;

Line 221: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'

217: WHEN OTHERS THEN
218: RAISE error_condition;
219: END; -- p_line_attribute3
220: ELSE
221: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'
222: ,'JL_ZZ_AR_TX_RAXTRX_TRX_NAT_MND'
223: ,p_interface_line_id
224: ,p_trx_business_category) THEN
225: RAISE error_condition;

Line 239: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'

235: INTO l_dummy_code
236: FROM sys.dual;
237: EXCEPTION
238: WHEN INVALID_NUMBER OR VALUE_ERROR THEN
239: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'
240: ,'JL_ZZ_AR_TX_RAXTRX_BS_AMT_INV'
241: ,p_interface_line_id
242: ,p_line_attribute11) THEN
243: RAISE error_condition;

Line 258: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'

254: INTO l_dummy_code
255: FROM sys.dual;
256: EXCEPTION
257: WHEN INVALID_NUMBER OR VALUE_ERROR THEN
258: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'
259: ,'JL_ZZ_AR_TX_RAXTRX_BS_RATE_INV'
260: ,p_interface_line_id
261: ,p_line_attribute12) THEN
262: RAISE error_condition;

Line 315: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'

311: AND nvl(end_date_active,sysdate+1) >= sysdate;
312:
313: EXCEPTION
314: WHEN NO_DATA_FOUND THEN
315: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'
316: , 'JL_BR_AR_RAXTRX_INT_TYPE_INV'
317: , p_interface_line_id
318: , p_header_attribute1) THEN
319: RAISE error_condition;

Line 341: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'

337:
338: IF p_header_attribute1 = 'R' AND
339: p_header_attribute2 NOT BETWEEN 0 AND 100 THEN
340:
341: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'
342: , 'JL_BR_AR_RAXTRX_INT_RATE_INV'
343: , p_interface_line_id
344: , p_header_attribute2) THEN
345: RAISE error_condition;

Line 352: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'

348: END IF;
349:
350: IF p_header_attribute1 = 'A' AND p_header_attribute2 < 0 THEN
351:
352: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'
353: , 'JL_BR_AR_RAXTRX_AMNT_INV'
354: , p_interface_line_id
355: , p_header_attribute2) THEN
356: RAISE error_condition;

Line 381: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'

377: WHERE to_number (p_header_attribute3) >= 0;
378:
379: EXCEPTION
380: WHEN NO_DATA_FOUND OR INVALID_NUMBER OR VALUE_ERROR THEN
381: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'
382: , 'JL_BR_AR_RAXTRX_INT_DAY_INV'
383: , p_interface_line_id
384: , p_header_attribute3) THEN
385: RAISE error_condition;

Line 392: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'

388: RAISE error_condition;
389: END; -- p_header_attribute3
390:
391: ELSE
392: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'
393: , 'JL_BR_AR_RAXTRX_INT_DAY_INV'
394: , p_interface_line_id
395: , p_header_attribute3) THEN
396: RAISE error_condition;

Line 425: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'

421: AND nvl(end_date_active,sysdate+1) >= sysdate;
422:
423: EXCEPTION
424: WHEN NO_DATA_FOUND THEN
425: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'
426: , 'JL_BR_AR_RAXTRX_INT_FORM_INV'
427: , p_interface_line_id
428: , p_header_attribute4) THEN
429: RAISE error_condition;

Line 455: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'

451: WHERE to_number (p_header_attribute5) >= 0;
452:
453: EXCEPTION
454: WHEN NO_DATA_FOUND OR INVALID_NUMBER OR VALUE_ERROR THEN
455: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'
456: , 'JL_BR_AR_RAXTRX_INT_GRACE_INV'
457: , p_interface_line_id
458: , p_header_attribute5) THEN
459: RAISE error_condition;

Line 491: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'

487: AND nvl(end_date_active,sysdate+1) >= sysdate;
488:
489: EXCEPTION
490: WHEN NO_DATA_FOUND THEN
491: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'
492: , 'JL_BR_AR_RAXTRX_PEN_TYPE_INV'
493: , p_interface_line_id
494: , p_header_attribute6) THEN
495: RAISE error_condition;

Line 518: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'

514: IF p_line_type = 'LINE' THEN
515:
516: IF p_header_attribute6 = 'R' AND
517: p_header_attribute7 NOT BETWEEN 0 AND 100 THEN
518: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'
519: , 'JL_BR_AR_RAXTRX_PEN_RATE_INV'
520: , p_interface_line_id
521: , p_header_attribute7) THEN
522: RAISE error_condition;

Line 528: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'

524:
525: END IF;
526:
527: IF p_header_attribute6 = 'A' AND p_header_attribute7 < 0 THEN
528: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'
529: , 'JL_BR_AR_RAXTRX_PEN_AMNT_INV'
530: , p_interface_line_id
531: , p_header_attribute7) THEN
532: RAISE error_condition;

Line 598: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'

594: FROM sys.dual;
595:
596: EXCEPTION
597: WHEN INVALID_NUMBER OR VALUE_ERROR THEN
598: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'
599: , 'JL_BR_AR_RAXTRX_FRT_EXP_INV'
600: , p_interface_line_id
601: , p_header_attribute9) THEN
602: RAISE error_condition;

Line 626: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'

622: FROM sys.dual;
623:
624: EXCEPTION
625: WHEN INVALID_NUMBER OR VALUE_ERROR THEN
626: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'
627: , 'JL_BR_AR_RAXTRX_INS_EXP_INV'
628: , p_interface_line_id
629: , p_header_attribute10) THEN
630: RAISE error_condition;

Line 655: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'

651: FROM sys.dual;
652:
653: EXCEPTION
654: WHEN INVALID_NUMBER OR VALUE_ERROR THEN
655: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'
656: , 'JL_BR_AR_RAXTRX_OTH_EXP_INV'
657: , p_interface_line_id
658: , p_header_attribute11) THEN
659: RAISE error_condition;

Line 684: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'

680: FROM sys.dual;
681:
682: EXCEPTION
683: WHEN INVALID_NUMBER OR VALUE_ERROR THEN
684: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'
685: , 'JL_BR_AR_RAXTRX_VOL_QTY_INV'
686: , p_interface_line_id
687: , p_header_attribute13) THEN
688: RAISE error_condition;

Line 709: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'

705: FROM sys.dual;
706:
707: EXCEPTION
708: WHEN INVALID_NUMBER OR VALUE_ERROR THEN
709: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'
710: , 'JL_BR_AR_RAXTRX_GRS_WGT_INV'
711: , p_interface_line_id
712: , p_header_attribute16) THEN
713: RAISE error_condition;

Line 736: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'

732: FROM sys.dual;
733:
734: EXCEPTION
735: WHEN INVALID_NUMBER OR VALUE_ERROR THEN
736: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'
737: , 'JL_BR_AR_RAXTRX_NET_WGT_INV'
738: , p_interface_line_id
739: , p_header_attribute17) THEN
740: RAISE error_condition;

Line 766: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'

762: WHERE cfo_code = p_line_attribute1;
763:
764: EXCEPTION
765: WHEN NO_DATA_FOUND THEN
766: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'
767: , 'JL_BR_AR_RAXTRX_OP_FISC_INV'
768: , p_interface_line_id
769: , p_line_attribute1) THEN
770: RAISE error_condition;

Line 777: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'

773: RAISE error_condition;
774: END; -- p_line_attribute1
775: ELSE
776: IF x_return_context IS NULL THEN
777: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'
778: , 'JL_BR_AR_RAXTRX_OP_FISC_MND'
779: , p_interface_line_id
780: , p_line_attribute1) THEN
781: RAISE error_condition;

Line 833: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'

829: /* End of New Code */
830:
831: EXCEPTION
832: WHEN NO_DATA_FOUND THEN
833: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'
834: , 'JL_BR_AR_RAXTRX_IT_ORIG_INV'
835: , p_interface_line_id
836: , p_line_attribute4) THEN
837: RAISE error_condition;

Line 845: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'

841:
842: END; --p_line_attribute4
843: ELSE
844: IF x_return_context IS NULL THEN
845: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'
846: , 'JL_BR_AR_RAXTRX_IT_ORIG_MND'
847: , p_interface_line_id
848: , p_line_attribute4) THEN
849: RAISE error_condition;

Line 901: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'

897: /* End of New Code */
898:
899: EXCEPTION
900: WHEN NO_DATA_FOUND THEN
901: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'
902: , 'JL_BR_AR_RAXTRX_IT_FISC_TP_INV'
903: , p_interface_line_id
904: , p_line_attribute5) THEN
905: RAISE error_condition;

Line 913: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'

909:
910: END; -- p_line_attribute5
911: ELSE
912: IF x_return_context IS NULL THEN
913: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'
914: , 'JL_BR_AR_RAXTRX_IT_FISC_TP_MND'
915: , p_interface_line_id
916: , p_line_attribute5) THEN
917: RAISE error_condition;

Line 969: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'

965: /* End of New Code */
966:
967: EXCEPTION
968: WHEN NO_DATA_FOUND THEN
969: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'
970: , 'JL_BR_AR_RAXTRX_FED_TR_SIT_INV'
971: , p_interface_line_id
972: , p_line_attribute6) THEN
973: RAISE error_condition;

Line 980: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'

976: RAISE error_condition;
977: END; -- p_line_attribute6
978: ELSE
979: IF x_return_context IS NULL THEN
980: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'
981: , 'JL_BR_AR_RAXTRX_FED_TR_SIT_MND'
982: , p_interface_line_id
983: , p_line_attribute5) THEN
984: RAISE error_condition;

Line 1037: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'

1033: /* End of New Code */
1034:
1035: EXCEPTION
1036: WHEN NO_DATA_FOUND THEN
1037: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'
1038: , 'JL_BR_AR_RAXTRX_STA_TR_SIT_INV'
1039: , p_interface_line_id
1040: , p_line_attribute7) THEN
1041: RAISE error_condition;

Line 1049: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'

1045:
1046: END; -- p_line_attribute7
1047: ELSE
1048: IF x_return_context IS NULL THEN
1049: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'
1050: , 'JL_BR_AR_RAXTRX_STA_TR_SIT_MND'
1051: , p_interface_line_id
1052: , p_line_attribute5) THEN
1053: RAISE error_condition;