[Home] [Help]
85:
86: EXCEPTION WHEN NO_DATA_FOUND THEN
87: arp_file.write_log('Address Id invalid '||
88: trx_lines_rec.orig_system_address_id,0);
89: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message1 ('JL',
90: 'JL_ZZ_AR_INVALID_ADDRESS',
91: trx_lines_rec.interface_line_attribute1,
92: 'JLERRUBS') THEN
93: RAISE error_condition;
93: RAISE error_condition;
94: END IF;
95: END;
96: IF l_contributor_class_code is null then
97: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message1 ('JL',
98: 'JL_AR_AR_AI_CONT_CLS_NOT_DEF',
99: trx_lines_rec.interface_line_attribute1,
100: 'JLERRUBS') THEN
101: RAISE error_condition;
140: arp_file.write_log('Organization class code '||l_organization_class_code,0);
141:
142: EXCEPTION WHEN NO_DATA_FOUND THEN
143: arp_file.write_log('No Org Class Code for SO_ORGANIZATION_ID '|| l_so_org_id,0);
144: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message1 ('JL',
145: 'JL_AR_AR_INVALID_ORGANIZATION',
146: trx_lines_rec.interface_line_attribute1,
147: 'JLERRUBS') THEN
148: RAISE error_condition;
151: END IF;
152: -- Bug 16471013 - End
153:
154: IF l_organization_class_code IS NULL THEN
155: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message1 ('JL',
156: 'JL_AR_AR_AI_ORG_CLS_NOT_DEF',
157: trx_lines_rec.interface_line_attribute1,
158: 'JLERRUBS') THEN
159: RAISE error_condition;
167: FROM jl_ar_ar_doc_letter;
168:
169: EXCEPTION WHEN NO_DATA_FOUND THEN
170: arp_file.write_log('Document letter not set up',0);
171: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message1 ('JL',
172: 'JL_AR_AR_DOC_LET_NOT_FOUND ',
173: trx_lines_rec.interface_line_attribute1,
174: 'JLERRUBS') THEN
175: RAISE error_condition;
193: arp_file.write_log('Organization condition value '||l_org_attribute_value,0);
194:
195: EXCEPTION WHEN NO_DATA_FOUND THEN
196: arp_file.write_log('Organization attributes not found',0);
197: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message1 ('JL',
198: 'JL_AR_AR_AI_ATT_CLS_NOT_DEF',
199: trx_lines_rec.interface_line_attribute1,
200: 'JLERRUBS') THEN
201: RAISE error_condition;
226: arp_file.write_log('Contributor condition value '||l_cust_attribute_value,0);
227:
228: EXCEPTION WHEN NO_DATA_FOUND THEN
229: arp_file.write_log('Contributor condition not found ',0);
230: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message1 ('JL',
231: 'JL_AR_AR_AI_CU_SIT_PRO_NOT_DEF',
232: trx_lines_rec.interface_line_attribute1,
233: 'JLERRUBS') THEN
234: RAISE error_condition;
249: arp_file.write_log('Contributor condition value '||l_cust_attribute_value,0);
250:
251: EXCEPTION WHEN NO_DATA_FOUND THEN
252: arp_file.write_log('Contributor condition not found ',0);
253: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message1 ('JL',
254: 'JL_AR_AR_AI_CU_SIT_PRO_NOT_DEF',
255: trx_lines_rec.interface_line_attribute1,
256: 'JLERRUBS') THEN
257: RAISE error_condition;
278: arp_file.write_log('Document letter is '||l_document_letter,0);
279:
280: EXCEPTION WHEN NO_DATA_FOUND THEN
281: arp_file.write_log('Document letter not found ',0);
282: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message1 ('JL',
283: 'JL_AR_AR_DOC_LET_NOT_FOUND',
284: trx_lines_rec.interface_line_attribute1,
285: 'JLERRUBS') THEN
286: RAISE error_condition;
302: arp_file.write_log('Correct Batch source id is '||l_batch_source_id,0);
303:
304: EXCEPTION WHEN NO_DATA_FOUND THEN
305: arp_file.write_log('Batch source not found',0);
306: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message1 ('JL',
307: 'JL_AR_AR_BT_SRC_NOT_FOUND',
308: trx_lines_rec.interface_line_attribute1,
309: 'JLERRUBS') THEN
310: RAISE error_condition;
310: RAISE error_condition;
311: END IF;
312: WHEN TOO_MANY_ROWS THEN
313: arp_file.write_log('More than one batch source found',0);
314: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message1 ('JL',
315: 'JL_AR_AR_BT_SRC_MORE_FOUND',
316: trx_lines_rec.interface_line_attribute1,
317: 'JLERRUBS') THEN
318: RAISE error_condition;