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 152: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

589: FROM sys.dual;
590:
591: EXCEPTION
592: WHEN INVALID_NUMBER OR VALUE_ERROR THEN
593: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'
594: , 'JL_BR_AR_RAXTRX_FRT_EXP_INV'
595: , p_interface_line_id
596: , p_header_attribute9) THEN
597: RAISE error_condition;

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

615: FROM sys.dual;
616:
617: EXCEPTION
618: WHEN INVALID_NUMBER OR VALUE_ERROR THEN
619: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'
620: , 'JL_BR_AR_RAXTRX_INS_EXP_INV'
621: , p_interface_line_id
622: , p_header_attribute10) THEN
623: RAISE error_condition;

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

642: FROM sys.dual;
643:
644: EXCEPTION
645: WHEN INVALID_NUMBER OR VALUE_ERROR THEN
646: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'
647: , 'JL_BR_AR_RAXTRX_OTH_EXP_INV'
648: , p_interface_line_id
649: , p_header_attribute11) THEN
650: RAISE error_condition;

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

669: FROM sys.dual;
670:
671: EXCEPTION
672: WHEN INVALID_NUMBER OR VALUE_ERROR THEN
673: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'
674: , 'JL_BR_AR_RAXTRX_VOL_QTY_INV'
675: , p_interface_line_id
676: , p_header_attribute13) THEN
677: RAISE error_condition;

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

694: FROM sys.dual;
695:
696: EXCEPTION
697: WHEN INVALID_NUMBER OR VALUE_ERROR THEN
698: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'
699: , 'JL_BR_AR_RAXTRX_GRS_WGT_INV'
700: , p_interface_line_id
701: , p_header_attribute16) THEN
702: RAISE error_condition;

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

721: FROM sys.dual;
722:
723: EXCEPTION
724: WHEN INVALID_NUMBER OR VALUE_ERROR THEN
725: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'
726: , 'JL_BR_AR_RAXTRX_NET_WGT_INV'
727: , p_interface_line_id
728: , p_header_attribute17) THEN
729: RAISE error_condition;

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

751: WHERE cfo_code = p_line_attribute1;
752:
753: EXCEPTION
754: WHEN NO_DATA_FOUND THEN
755: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'
756: , 'JL_BR_AR_RAXTRX_OP_FISC_INV'
757: , p_interface_line_id
758: , p_line_attribute1) THEN
759: RAISE error_condition;

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

762: RAISE error_condition;
763: END; -- p_line_attribute1
764: ELSE
765: IF x_return_context IS NULL THEN
766: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'
767: , 'JL_BR_AR_RAXTRX_OP_FISC_MND'
768: , p_interface_line_id
769: , p_line_attribute1) THEN
770: RAISE error_condition;

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

818: /* End of New Code */
819:
820: EXCEPTION
821: WHEN NO_DATA_FOUND THEN
822: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'
823: , 'JL_BR_AR_RAXTRX_IT_ORIG_INV'
824: , p_interface_line_id
825: , p_line_attribute4) THEN
826: RAISE error_condition;

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

830:
831: END; --p_line_attribute4
832: ELSE
833: IF x_return_context IS NULL THEN
834: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'
835: , 'JL_BR_AR_RAXTRX_IT_ORIG_MND'
836: , p_interface_line_id
837: , p_line_attribute4) THEN
838: RAISE error_condition;

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

886: /* End of New Code */
887:
888: EXCEPTION
889: WHEN NO_DATA_FOUND THEN
890: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'
891: , 'JL_BR_AR_RAXTRX_IT_FISC_TP_INV'
892: , p_interface_line_id
893: , p_line_attribute5) THEN
894: RAISE error_condition;

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

898:
899: END; -- p_line_attribute5
900: ELSE
901: IF x_return_context IS NULL THEN
902: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'
903: , 'JL_BR_AR_RAXTRX_IT_FISC_TP_MND'
904: , p_interface_line_id
905: , p_line_attribute5) THEN
906: RAISE error_condition;

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

954: /* End of New Code */
955:
956: EXCEPTION
957: WHEN NO_DATA_FOUND THEN
958: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'
959: , 'JL_BR_AR_RAXTRX_FED_TR_SIT_INV'
960: , p_interface_line_id
961: , p_line_attribute6) THEN
962: RAISE error_condition;

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

965: RAISE error_condition;
966: END; -- p_line_attribute6
967: ELSE
968: IF x_return_context IS NULL THEN
969: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'
970: , 'JL_BR_AR_RAXTRX_FED_TR_SIT_MND'
971: , p_interface_line_id
972: , p_line_attribute5) THEN
973: RAISE error_condition;

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

1022: /* End of New Code */
1023:
1024: EXCEPTION
1025: WHEN NO_DATA_FOUND THEN
1026: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'
1027: , 'JL_BR_AR_RAXTRX_STA_TR_SIT_INV'
1028: , p_interface_line_id
1029: , p_line_attribute7) THEN
1030: RAISE error_condition;

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

1034:
1035: END; -- p_line_attribute7
1036: ELSE
1037: IF x_return_context IS NULL THEN
1038: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'
1039: , 'JL_BR_AR_RAXTRX_STA_TR_SIT_MND'
1040: , p_interface_line_id
1041: , p_line_attribute5) THEN
1042: RAISE error_condition;