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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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:
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;
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;