DBA Data[Home] [Help]

APPS.JL_AR_DOC_NUMBERING_PKG dependencies on JG_ZZ_AUTO_INVOICE

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

49: EXCEPTION
50: WHEN NO_DATA_FOUND THEN
51: IF p_created_from = 'RAXTRX' THEN
52: l_return_code := 'ERROR';
53: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL',
54: 'JL_AR_AR_INVALID_TRANS_TYPE',
55: 'p_interface_line_id',
56: 'p_trx_type') THEN
57: RAISE error_condition;

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

62: END IF;
63: WHEN TOO_MANY_ROWS THEN
64: IF p_created_from = 'RAXTRX' THEN
65: l_return_code := 'ERROR';
66: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL',
67: 'JL_AR_AR_BT_SRC_MORE_FOUND',
68: 'p_interface_line_id',
69: 'p_trx_type') THEN
70: RAISE error_condition;

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

95: END IF;
96: IF l_count > 0 THEN
97: IF p_created_from = 'RAXTRX' THEN
98: l_return_code := 'ERROR';
99: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL',
100: 'JL_AR_AR_BT_SRC_MORE_FOUND',
101: 'p_interface_line_id',
102: 'p_trx_type') THEN
103: RAISE error_condition;

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

116: l_return_code := 'JL_AR_AR_TRXTYP_BTSRC_NOT_ASSO';
117: RAISE error_condition;
118: ELSE
119: l_return_code := 'JL_AR_AR_INVALID_TRANS_TYPE';
120: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL',
121: 'JL_AR_AR_INVALID_TRANS_TYPE',
122: 'p_interface_line_id',
123: 'p_trx_type') THEN
124: RAISE error_condition;

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

176: EXCEPTION
177: WHEN NO_DATA_FOUND THEN
178: IF p_created_from = 'RAXTRX' THEN
179: l_return_code := 'ERROR';
180: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL',
181: 'JL_AR_AR_INVALID_ITEM_CODE',
182: p_interface_line_id,
183: p_inventory_item_id) THEN
184: RAISE error_condition;

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

198: EXCEPTION
199: WHEN NO_DATA_FOUND THEN
200: IF p_created_from = 'RAXTRX' THEN
201: l_return_code := 'ERROR';
202: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL',
203: 'JL_AR_AR_INVALID_MEMO_LINE',
204: p_interface_line_id,
205: p_memo_line_id) THEN
206: RAISE error_condition;

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

221: EXCEPTION
222: WHEN NO_DATA_FOUND THEN
223: IF p_created_from = 'RAXTRX' THEN
224: l_return_code := 'ERROR';
225: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL',
226: 'JL_AR_AR_INV_PROD_LINE_CODE',
227: p_interface_line_id,
228: l_product_line_code) THEN
229: RAISE error_condition;

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

239: WHEN OTHERS THEN
240: IF l_return_code is null then
241: IF p_created_from = 'RAXTRX' THEN
242: l_return_code := 'JL_AR_AR_AI_BR_NUM_NOT_DEF';
243: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL',
244: 'JL_AR_AR_AI_BR_NUM_NOT_DEF',
245: p_interface_line_id,
246: p_batch_source_id) THEN
247: RAISE error_condition;

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

440: EXCEPTION
441: WHEN NO_DATA_FOUND THEN
442: IF p_created_from = 'RAXTRX' THEN
443: l_return_code := 'ERROR';
444: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL',
445: 'JL_AR_AR_INVALID_ORGANIZATION',
446: p_interface_line_id,
447: l_so_org_id) THEN
448: RAISE error_condition;

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

461: WHERE hrou.organization_id = l_so_org_id
462: AND hrl.location_id = hrou.location_id;
463: EXCEPTION WHEN NO_DATA_FOUND THEN
464: IF p_created_from = 'RAXTRX' THEN
465: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL',
466: 'JL_AR_AR_INVALID_ORGANIZATION',
467: p_interface_line_id,
468: l_so_org_id) THEN
469: RAISE error_condition;

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

479: END IF;
480: IF l_organization_class_code is null then
481: IF p_created_from = 'RAXTRX' THEN
482: l_return_code := 'JL_AR_AR_AI_ORG_CLS_NOT_DEF';
483: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL',
484: 'JL_AR_AR_AI_ORG_CLS_NOT_DEF',
485: p_interface_line_id,
486: l_so_org_id) THEN
487: RAISE error_condition;

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

516: WHERE cas.cust_acct_site_id = p_ship_to_address_id;
517: END;
518: IF l_contributor_class_code is null then
519: l_return_code := 'ERROR';
520: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL',
521: 'JL_AR_AR_AI_CONT_CLS_NOT_DEF',
522: p_interface_line_id,
523: p_ship_to_address_id) THEN
524: RAISE error_condition;

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

654: l_return_code := 'JL_AR_AR_DOC_LET_NOT_FOUND';
655: END IF;
656:
657: IF p_created_from = 'RAXTRX' THEN
658: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL',
659: l_return_code,
660: p_interface_line_id,
661: p_batch_source_id) THEN
662:

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

821: arp_standard.debug('validate_interface_lines: ' || '-- date validation problem');
822: END IF;
823: l_return_code := 1;
824: IF p_trx_date < l_last_trx_date THEN
825: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL',
826: 'JL_AR_AR_INVALID_TRANS_DATE',
827: to_char(p_interface_line_id),
828: to_char(l_batch_source_id)) THEN
829: RAISE error_condition;

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

828: to_char(l_batch_source_id)) THEN
829: RAISE error_condition;
830: END IF;
831: ELSE
832: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL',
833: 'JL_AR_AR_INVALID_TRX_DT_AFT',
834: to_char(p_interface_line_id),
835: to_char(l_batch_source_id)) THEN
836: RAISE error_condition;