DBA Data[Home] [Help]

APPS.JL_AR_DOC_NUMBERING_PKG dependencies on JG_ZZ_AUTO_INVOICE

Line 46: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL',

42: EXCEPTION
43: WHEN NO_DATA_FOUND THEN
44: IF p_created_from = 'RAXTRX' THEN
45: l_return_code := 'ERROR';
46: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL',
47: 'JL_AR_AR_INVALID_TRANS_TYPE',
48: 'p_interface_line_id',
49: 'p_trx_type') THEN
50: RAISE error_condition;

Line 59: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL',

55: END IF;
56: WHEN TOO_MANY_ROWS THEN
57: IF p_created_from = 'RAXTRX' THEN
58: l_return_code := 'ERROR';
59: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL',
60: 'JL_AR_AR_BT_SRC_MORE_FOUND',
61: 'p_interface_line_id',
62: 'p_trx_type') THEN
63: RAISE error_condition;

Line 92: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL',

88: END IF;
89: IF l_count > 0 THEN
90: IF p_created_from = 'RAXTRX' THEN
91: l_return_code := 'ERROR';
92: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL',
93: 'JL_AR_AR_BT_SRC_MORE_FOUND',
94: 'p_interface_line_id',
95: 'p_trx_type') THEN
96: RAISE error_condition;

Line 113: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL',

109: l_return_code := 'JL_AR_AR_TRXTYP_BTSRC_NOT_ASSO';
110: RAISE error_condition;
111: ELSE
112: l_return_code := 'JL_AR_AR_INVALID_TRANS_TYPE';
113: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL',
114: 'JL_AR_AR_INVALID_TRANS_TYPE',
115: 'p_interface_line_id',
116: 'p_trx_type') THEN
117: RAISE error_condition;

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

169: EXCEPTION
170: WHEN NO_DATA_FOUND THEN
171: IF p_created_from = 'RAXTRX' THEN
172: l_return_code := 'ERROR';
173: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL',
174: 'JL_AR_AR_INVALID_ITEM_CODE',
175: p_interface_line_id,
176: p_inventory_item_id) THEN
177: RAISE error_condition;

Line 195: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL',

191: EXCEPTION
192: WHEN NO_DATA_FOUND THEN
193: IF p_created_from = 'RAXTRX' THEN
194: l_return_code := 'ERROR';
195: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL',
196: 'JL_AR_AR_INVALID_MEMO_LINE',
197: p_interface_line_id,
198: p_memo_line_id) THEN
199: RAISE error_condition;

Line 218: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL',

214: EXCEPTION
215: WHEN NO_DATA_FOUND THEN
216: IF p_created_from = 'RAXTRX' THEN
217: l_return_code := 'ERROR';
218: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL',
219: 'JL_AR_AR_INV_PROD_LINE_CODE',
220: p_interface_line_id,
221: l_product_line_code) THEN
222: RAISE error_condition;

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

232: WHEN OTHERS THEN
233: IF l_return_code is null then
234: IF p_created_from = 'RAXTRX' THEN
235: l_return_code := 'JL_AR_AR_AI_BR_NUM_NOT_DEF';
236: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL',
237: 'JL_AR_AR_AI_BR_NUM_NOT_DEF',
238: p_interface_line_id,
239: p_batch_source_id) THEN
240: RAISE error_condition;

Line 430: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL',

426: EXCEPTION
427: WHEN NO_DATA_FOUND THEN
428: IF p_created_from = 'RAXTRX' THEN
429: l_return_code := 'ERROR';
430: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL',
431: 'JL_AR_AR_INVALID_ORGANIZATION',
432: p_interface_line_id,
433: l_so_org_id) THEN
434: RAISE error_condition;

Line 451: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL',

447: WHERE hrou.organization_id = l_so_org_id
448: AND hrl.location_id = hrou.location_id;
449: EXCEPTION WHEN NO_DATA_FOUND THEN
450: IF p_created_from = 'RAXTRX' THEN
451: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL',
452: 'JL_AR_AR_INVALID_ORGANIZATION',
453: p_interface_line_id,
454: l_so_org_id) THEN
455: RAISE error_condition;

Line 469: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL',

465: END IF;
466: IF l_organization_class_code is null then
467: IF p_created_from = 'RAXTRX' THEN
468: l_return_code := 'JL_AR_AR_AI_ORG_CLS_NOT_DEF';
469: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL',
470: 'JL_AR_AR_AI_ORG_CLS_NOT_DEF',
471: p_interface_line_id,
472: l_so_org_id) THEN
473: RAISE error_condition;

Line 506: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL',

502: WHERE cas.cust_acct_site_id = p_ship_to_address_id;
503: END;
504: IF l_contributor_class_code is null then
505: l_return_code := 'ERROR';
506: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL',
507: 'JL_AR_AR_AI_CONT_CLS_NOT_DEF',
508: p_interface_line_id,
509: p_ship_to_address_id) THEN
510: RAISE error_condition;

Line 644: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL',

640: l_return_code := 'JL_AR_AR_DOC_LET_NOT_FOUND';
641: END IF;
642:
643: IF p_created_from = 'RAXTRX' THEN
644: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL',
645: l_return_code,
646: p_interface_line_id,
647: p_batch_source_id) THEN
648:

Line 811: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL',

807: arp_standard.debug('validate_interface_lines: ' || '-- date validation problem');
808: END IF;
809: l_return_code := 1;
810: IF p_trx_date < l_last_trx_date THEN
811: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL',
812: 'JL_AR_AR_INVALID_TRANS_DATE',
813: to_char(p_interface_line_id),
814: to_char(l_batch_source_id)) THEN
815: RAISE error_condition;

Line 818: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL',

814: to_char(l_batch_source_id)) THEN
815: RAISE error_condition;
816: END IF;
817: ELSE
818: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL',
819: 'JL_AR_AR_INVALID_TRX_DT_AFT',
820: to_char(p_interface_line_id),
821: to_char(l_batch_source_id)) THEN
822: RAISE error_condition;