DBA Data[Home] [Help]

APPS.ARP_CORRECT_CC_ERRORS dependencies on STANDARD

Line 140: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.get_collector_name()+' );

136: l_collector_name ar_collectors.name%TYPE;
137: l_collector_id NUMBER;
138: BEGIN
139: IF PG_DEBUG in ('Y', 'C') THEN
140: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.get_collector_name()+' );
141: END IF;
142: SELECT prof.collector_id INTO l_collector_id
143: FROM hz_customer_profiles prof
144: WHERE prof.cust_account_id = p_customer_id AND

Line 153: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.get_collector_name()-' );

149: FROM ar_collectors
150: WHERE collector_id = l_collector_id;
151:
152: IF PG_DEBUG in ('Y', 'C') THEN
153: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.get_collector_name()-' );
154: END IF;
155: RETURN l_collector_name;
156: EXCEPTION
157: WHEN NO_DATA_FOUND THEN

Line 168: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.get_collector_name()-' );

164: INTO l_collector_name
165: FROM ar_collectors
166: WHERE collector_id = l_collector_id;
167: IF PG_DEBUG in ('Y', 'C') THEN
168: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.get_collector_name()-' );
169: END IF;
170: RETURN l_collector_name;
171: WHEN OTHERS THEN
172: RETURN null;

Line 209: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.cc_mapping_exist()+' );

205: RETURN VARCHAR2 IS
206: l_return VARCHAR2(1);
207: BEGIN
208: IF PG_DEBUG in ('Y', 'C') THEN
209: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.cc_mapping_exist()+' );
210: END IF;
211: SELECT 'Y'
212: INTO l_return
213: FROM dual

Line 220: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.cc_mapping_exist()-' );

216: WHERE cc_error_code = p_cc_error_code
217: AND cc_trx_category = p_cc_trx_category
218: AND receipt_method_id = p_receipt_method_id);
219: IF PG_DEBUG in ('Y', 'C') THEN
220: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.cc_mapping_exist()-' );
221: END IF;
222: RETURN l_return;
223: EXCEPTION
224: WHEN OTHERS THEN

Line 282: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.get_action_code()+' );

278: l_instr_assignment_id NUMBER;
279:
280: BEGIN
281: IF PG_DEBUG in ('Y', 'C') THEN
282: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.get_action_code()+' );
283: END IF;
284:
285: IF PG_DEBUG in ('Y', 'C') THEN
286: ---Print input parameters

Line 287: arp_standard.debug( '--- Input Parameters : ---');

283: END IF;
284:
285: IF PG_DEBUG in ('Y', 'C') THEN
286: ---Print input parameters
287: arp_standard.debug( '--- Input Parameters : ---');
288: arp_standard.debug( 'p_cc_trx_id :'|| p_cc_trx_id);
289: arp_standard.debug( 'p_cc_trx_category :'|| p_cc_trx_category);
290: arp_standard.debug( 'p_payment_trxn_extension_id: ' ||
291: p_payment_trxn_extension_id);

Line 288: arp_standard.debug( 'p_cc_trx_id :'|| p_cc_trx_id);

284:
285: IF PG_DEBUG in ('Y', 'C') THEN
286: ---Print input parameters
287: arp_standard.debug( '--- Input Parameters : ---');
288: arp_standard.debug( 'p_cc_trx_id :'|| p_cc_trx_id);
289: arp_standard.debug( 'p_cc_trx_category :'|| p_cc_trx_category);
290: arp_standard.debug( 'p_payment_trxn_extension_id: ' ||
291: p_payment_trxn_extension_id);
292: arp_standard.debug( 'p_cc_error_code: ' || p_cc_error_code);

Line 289: arp_standard.debug( 'p_cc_trx_category :'|| p_cc_trx_category);

285: IF PG_DEBUG in ('Y', 'C') THEN
286: ---Print input parameters
287: arp_standard.debug( '--- Input Parameters : ---');
288: arp_standard.debug( 'p_cc_trx_id :'|| p_cc_trx_id);
289: arp_standard.debug( 'p_cc_trx_category :'|| p_cc_trx_category);
290: arp_standard.debug( 'p_payment_trxn_extension_id: ' ||
291: p_payment_trxn_extension_id);
292: arp_standard.debug( 'p_cc_error_code: ' || p_cc_error_code);
293: arp_standard.debug( 'p_receipt_method_id: ' || p_receipt_method_id);

Line 290: arp_standard.debug( 'p_payment_trxn_extension_id: ' ||

286: ---Print input parameters
287: arp_standard.debug( '--- Input Parameters : ---');
288: arp_standard.debug( 'p_cc_trx_id :'|| p_cc_trx_id);
289: arp_standard.debug( 'p_cc_trx_category :'|| p_cc_trx_category);
290: arp_standard.debug( 'p_payment_trxn_extension_id: ' ||
291: p_payment_trxn_extension_id);
292: arp_standard.debug( 'p_cc_error_code: ' || p_cc_error_code);
293: arp_standard.debug( 'p_receipt_method_id: ' || p_receipt_method_id);
294:

Line 292: arp_standard.debug( 'p_cc_error_code: ' || p_cc_error_code);

288: arp_standard.debug( 'p_cc_trx_id :'|| p_cc_trx_id);
289: arp_standard.debug( 'p_cc_trx_category :'|| p_cc_trx_category);
290: arp_standard.debug( 'p_payment_trxn_extension_id: ' ||
291: p_payment_trxn_extension_id);
292: arp_standard.debug( 'p_cc_error_code: ' || p_cc_error_code);
293: arp_standard.debug( 'p_receipt_method_id: ' || p_receipt_method_id);
294:
295: END IF;
296:

Line 293: arp_standard.debug( 'p_receipt_method_id: ' || p_receipt_method_id);

289: arp_standard.debug( 'p_cc_trx_category :'|| p_cc_trx_category);
290: arp_standard.debug( 'p_payment_trxn_extension_id: ' ||
291: p_payment_trxn_extension_id);
292: arp_standard.debug( 'p_cc_error_code: ' || p_cc_error_code);
293: arp_standard.debug( 'p_receipt_method_id: ' || p_receipt_method_id);
294:
295: END IF;
296:
297:

Line 301: arp_standard.debug( 'get_action_code()+' );

297:
298: -- Check if there is action code in ar_cc_error_mappings
299: BEGIN
300: IF PG_DEBUG in ('Y', 'C') THEN
301: arp_standard.debug( 'get_action_code()+' );
302: END IF;
303: SELECT cc_action_code,
304: cc_error_text,
305: no_days,

Line 320: arp_standard.debug( 'cc_action_code: '|| l_cc_action_code );

316: AND receipt_method_id = p_receipt_method_id;
317:
318:
319: IF PG_DEBUG in ('Y', 'C') THEN
320: arp_standard.debug( 'cc_action_code: '|| l_cc_action_code );
321: arp_standard.debug( 'no_days: '|| l_no_days );
322: arp_standard.debug( 'subsequent_action_code: '|| l_subsequent_action_code );
323:
324: END IF;

Line 321: arp_standard.debug( 'no_days: '|| l_no_days );

317:
318:
319: IF PG_DEBUG in ('Y', 'C') THEN
320: arp_standard.debug( 'cc_action_code: '|| l_cc_action_code );
321: arp_standard.debug( 'no_days: '|| l_no_days );
322: arp_standard.debug( 'subsequent_action_code: '|| l_subsequent_action_code );
323:
324: END IF;
325:

Line 322: arp_standard.debug( 'subsequent_action_code: '|| l_subsequent_action_code );

318:
319: IF PG_DEBUG in ('Y', 'C') THEN
320: arp_standard.debug( 'cc_action_code: '|| l_cc_action_code );
321: arp_standard.debug( 'no_days: '|| l_no_days );
322: arp_standard.debug( 'subsequent_action_code: '|| l_subsequent_action_code );
323:
324: END IF;
325:
326:

Line 336: arp_standard.debug( 'EXCEPTION ARP_CORRECT_CC_ERRORS.get_action_code()' );

332: x_error_notes := NULL;
333: RETURN;
334: WHEN OTHERS THEN
335: IF PG_DEBUG in ('Y', 'C') THEN
336: arp_standard.debug( 'EXCEPTION ARP_CORRECT_CC_ERRORS.get_action_code()' );
337: END IF;
338: raise;
339: END;
340:

Line 344: arp_standard.debug( 'Checking for subsequent action code');

340:
341:
342: -- Check if subsequent action code already performed on this entity
343: BEGIN
344: arp_standard.debug( 'Checking for subsequent action code');
345:
346: SELECT INSTR_ASSIGNMENT_ID INTO l_instr_assignment_id
347: FROM IBY_FNDCPT_TX_EXTENSIONS
348: WHERE TRXN_EXTENSION_ID = p_payment_trxn_extension_id;

Line 363: arp_standard.debug( 'No Data Found for subsequent action code');

359: AND cc.cc_error_code = p_cc_error_code
360: AND cc.cc_action_type_flag = 'S' );
361: EXCEPTION
362: WHEN NO_DATA_FOUND THEN
363: arp_standard.debug( 'No Data Found for subsequent action code');
364: x_cc_action_code := 'Not available';
365: x_cc_action_type := NULL;
366: x_first_record_flag := NULL;
367: x_error_notes := NULL;

Line 371: arp_standard.debug( 'EXCEPTION ARP_CORRECT_CC_ERRORS.get_action_code()' );

367: x_error_notes := NULL;
368: RETURN;
369: WHEN OTHERS THEN
370: IF PG_DEBUG in ('Y', 'C') THEN
371: arp_standard.debug( 'EXCEPTION ARP_CORRECT_CC_ERRORS.get_action_code()' );
372: END IF;
373: raise;
374: END;
375:

Line 378: arp_standard.debug( 'Checking if it is first time error');

374: END;
375:
376: -- Check if this a first time error
377: BEGIN
378: arp_standard.debug( 'Checking if it is first time error');
379: SELECT cc.cc_error_date
380: INTO l_first_cc_error_date
381: FROM ar_cc_error_history cc, iby_fndcpt_tx_extensions b
382: WHERE cc.cc_trx_id = p_cc_trx_id

Line 390: arp_standard.debug( 'First CC error Date; '|| l_first_cc_error_date );

386: AND cc.cc_error_code = p_cc_error_code
387: AND cc.first_record_flag = 'Y';
388:
389: IF PG_DEBUG in ('Y', 'C') THEN
390: arp_standard.debug( 'First CC error Date; '|| l_first_cc_error_date );
391: END IF;
392:
393: EXCEPTION
394: WHEN NO_DATA_FOUND THEN

Line 395: arp_standard.debug( 'No Data Found for first time error check');

391: END IF;
392:
393: EXCEPTION
394: WHEN NO_DATA_FOUND THEN
395: arp_standard.debug( 'No Data Found for first time error check');
396: x_cc_action_code := l_cc_action_code;
397: x_cc_action_type := 'A';
398: x_first_record_flag := 'Y';
399: RETURN;

Line 402: arp_standard.debug( 'EXCEPTION ARP_CORRECT_CC_ERRORS.get_action_code()' );

398: x_first_record_flag := 'Y';
399: RETURN;
400: WHEN OTHERS THEN
401: IF PG_DEBUG in ('Y', 'C') THEN
402: arp_standard.debug( 'EXCEPTION ARP_CORRECT_CC_ERRORS.get_action_code()' );
403: END IF;
404: raise;
405: END;
406:

Line 409: arp_standard.debug( 'Setting action for subsequent action');

405: END;
406:
407: -- Determine action to perform or subsequent action.
408: --Bug 4192014 change the sign from < to > for action/subsequent action logic
409: arp_standard.debug( 'Setting action for subsequent action');
410: IF trunc(NVL(l_first_cc_error_date,to_date('01/01/1951','dd/mm/yyyy')))+l_no_days
411: > trunc(sysdate)
412: THEN /* Action */
413: x_cc_action_code := l_cc_action_code;

Line 424: arp_standard.debug( ' Action or Subsequent Action x_cc_action_type : ' ||

420: x_first_record_flag := 'N';
421: END IF;
422:
423: IF PG_DEBUG in ('Y', 'C') THEN
424: arp_standard.debug( ' Action or Subsequent Action x_cc_action_type : ' ||
425: x_cc_action_type );
426: END IF;
427:
428: IF PG_DEBUG in ('Y', 'C') THEN

Line 429: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.get_action_code()-' );

425: x_cc_action_type );
426: END IF;
427:
428: IF PG_DEBUG in ('Y', 'C') THEN
429: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.get_action_code()-' );
430: END IF;
431: END get_action_code;
432:
433: /*===========================================================================+

Line 459: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.insert_p()+' );

455: +===========================================================================*/
456: PROCEDURE insert_p(p_cc_error_hist IN ar_cc_error_history%ROWTYPE) IS
457: BEGIN
458: IF PG_DEBUG in ('Y', 'C') THEN
459: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.insert_p()+' );
460: END IF;
461: INSERT INTO ar_cc_error_history
462: (
463: request_id,

Line 502: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.insert_p()-' );

498: NVL(pg_login_id,pg_conc_login_id),
499: pg_user_id
500: );
501: IF PG_DEBUG in ('Y', 'C') THEN
502: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.insert_p()-' );
503: END IF;
504: EXCEPTION
505: WHEN OTHERS THEN
506: arp_standard.debug( 'EXCEPTION ARP_CORRECT_CC_ERRORS.insert_p()' );

Line 506: arp_standard.debug( 'EXCEPTION ARP_CORRECT_CC_ERRORS.insert_p()' );

502: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.insert_p()-' );
503: END IF;
504: EXCEPTION
505: WHEN OTHERS THEN
506: arp_standard.debug( 'EXCEPTION ARP_CORRECT_CC_ERRORS.insert_p()' );
507: raise;
508: END insert_p;
509:
510: /*===========================================================================+

Line 571: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.clear_invoice_pay_info()+' );

567: l_billto_contact varchar2(150);
568: l_salesrep_name ra_salesreps.name%TYPE;
569: BEGIN
570: IF PG_DEBUG in ('Y', 'C') THEN
571: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.clear_invoice_pay_info()+' );
572: END IF;
573: SELECT NVL(trx.cc_error_code,'Unknown'),
574: NVL(trx.cc_error_text,'Unknown Error'),
575: ARPT_SQL_FUNC_UTIL.get_lookup_meaning('CC_TRX_CATEGORY',p_cc_trx_category),

Line 695: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.clear_invoice_pay_info()-' );

691:
692:
693:
694: IF PG_DEBUG in ('Y', 'C') THEN
695: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.clear_invoice_pay_info()-' );
696: END IF;
697: EXCEPTION
698: WHEN OTHERS THEN
699: IF PG_DEBUG in ('Y', 'C') THEN

Line 700: arp_standard.debug( 'Exception ARP_CORRECT_CC_ERRORS.clear_invoice_pay_info()' );

696: END IF;
697: EXCEPTION
698: WHEN OTHERS THEN
699: IF PG_DEBUG in ('Y', 'C') THEN
700: arp_standard.debug( 'Exception ARP_CORRECT_CC_ERRORS.clear_invoice_pay_info()' );
701: END IF;
702: raise;
703: END clear_invoice_pay_info;
704:

Line 736: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.default_reversal_gl_date()+' );

732: l_default_gl_date DATE;
733: l_gl_date DATE;
734: BEGIN
735: IF PG_DEBUG in ('Y', 'C') THEN
736: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.default_reversal_gl_date()+' );
737: END IF;
738: SELECT max(gl_date)
739: INTO l_gl_date
740: FROM ar_cash_receipt_history

Line 776: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.default_reversal_gl_date()-' );

772: FND_MSG_PUB.Add;
773: app_exception.raise_exception;
774: END IF;
775: IF PG_DEBUG in ('Y', 'C') THEN
776: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.default_reversal_gl_date()-' );
777: END IF;
778: EXCEPTION
779: WHEN OTHERS THEN
780: IF PG_DEBUG in ('Y', 'C') THEN

Line 781: arp_standard.debug( 'EXCEPTION ARP_CORRECT_CC_ERRORS.default_reversal_gl_date()' );

777: END IF;
778: EXCEPTION
779: WHEN OTHERS THEN
780: IF PG_DEBUG in ('Y', 'C') THEN
781: arp_standard.debug( 'EXCEPTION ARP_CORRECT_CC_ERRORS.default_reversal_gl_date()' );
782: END IF;
783: raise;
784: END default_reversal_gl_date;
785:

Line 813: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.default_reversal_date()+' );

809: FUNCTION default_reversal_date(p_cash_receipt_id IN NUMBER) RETURN DATE IS
810: l_receipt_date DATE;
811: BEGIN
812: IF PG_DEBUG in ('Y', 'C') THEN
813: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.default_reversal_date()+' );
814: END IF;
815: SELECT receipt_date
816: INTO l_receipt_date
817: FROM ar_cash_receipts

Line 826: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.default_reversal_date()+' );

822: ELSE
823: RETURN l_receipt_date;
824: END IF;
825: IF PG_DEBUG in ('Y', 'C') THEN
826: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.default_reversal_date()+' );
827: END IF;
828: END default_reversal_date;
829:
830: /*===========================================================================+

Line 866: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.reverse_receipt()+' );

862: l_msg_index NUMBER;
863: API_exception EXCEPTION;
864: BEGIN
865: IF PG_DEBUG in ('Y', 'C') THEN
866: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.reverse_receipt()+' );
867: END IF;
868: --
869: -- Populate the arguments to pass to AR_RECEIPT_API_PUB.Reverse
870: --

Line 948: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.reverse_receipt()-' );

944:
945: END IF; -- l_return_status
946:
947: IF PG_DEBUG in ('Y', 'C') THEN
948: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.reverse_receipt()-' );
949: END IF;
950: EXCEPTION
951: WHEN API_exception THEN
952: IF PG_DEBUG in ('Y', 'C') THEN

Line 2163: l_trxn_attribs_rec.originating_application_id := arp_standard.application_id;

2159: l_payer_rec.org_id := l_org_id;
2160: l_payer_rec.org_type := l_org_type;
2161:
2162: /* Set Transction Attributes in Transaction Atrribs Rec. */
2163: l_trxn_attribs_rec.originating_application_id := arp_standard.application_id;
2164: l_trxn_attribs_rec.order_id := l_receipt_number;
2165: l_trxn_attribs_rec.trxn_ref_number1 := 'RECEIPT';
2166: l_trxn_attribs_rec.trxn_ref_number2 := p_cc_trx_id;
2167:

Line 2190: arp_standard.debug('Processing cash_receipt_id :- ' || p_cc_trx_id);

2186: payment_trxn_extension_id = l_payment_trxn_extension_id
2187: where cash_receipt_id = p_cc_trx_id;
2188:
2189: ELSE
2190: arp_standard.debug('Processing cash_receipt_id :- ' || p_cc_trx_id);
2191: arp_standard.debug('result_code :- ' || l_response_rec.result_code);
2192: arp_standard.debug('result_category :- ' || l_response_rec.result_category);
2193: arp_standard.debug('result_message :- ' || l_response_rec.result_message);
2194: arp_standard.debug('l_return_status :- ' || l_return_status);

Line 2191: arp_standard.debug('result_code :- ' || l_response_rec.result_code);

2187: where cash_receipt_id = p_cc_trx_id;
2188:
2189: ELSE
2190: arp_standard.debug('Processing cash_receipt_id :- ' || p_cc_trx_id);
2191: arp_standard.debug('result_code :- ' || l_response_rec.result_code);
2192: arp_standard.debug('result_category :- ' || l_response_rec.result_category);
2193: arp_standard.debug('result_message :- ' || l_response_rec.result_message);
2194: arp_standard.debug('l_return_status :- ' || l_return_status);
2195: arp_standard.debug('l_msg_count :- ' || l_msg_count);

Line 2192: arp_standard.debug('result_category :- ' || l_response_rec.result_category);

2188:
2189: ELSE
2190: arp_standard.debug('Processing cash_receipt_id :- ' || p_cc_trx_id);
2191: arp_standard.debug('result_code :- ' || l_response_rec.result_code);
2192: arp_standard.debug('result_category :- ' || l_response_rec.result_category);
2193: arp_standard.debug('result_message :- ' || l_response_rec.result_message);
2194: arp_standard.debug('l_return_status :- ' || l_return_status);
2195: arp_standard.debug('l_msg_count :- ' || l_msg_count);
2196: arp_standard.debug('l_msg_data :- ' || l_msg_data);

Line 2193: arp_standard.debug('result_message :- ' || l_response_rec.result_message);

2189: ELSE
2190: arp_standard.debug('Processing cash_receipt_id :- ' || p_cc_trx_id);
2191: arp_standard.debug('result_code :- ' || l_response_rec.result_code);
2192: arp_standard.debug('result_category :- ' || l_response_rec.result_category);
2193: arp_standard.debug('result_message :- ' || l_response_rec.result_message);
2194: arp_standard.debug('l_return_status :- ' || l_return_status);
2195: arp_standard.debug('l_msg_count :- ' || l_msg_count);
2196: arp_standard.debug('l_msg_data :- ' || l_msg_data);
2197: END IF;

Line 2194: arp_standard.debug('l_return_status :- ' || l_return_status);

2190: arp_standard.debug('Processing cash_receipt_id :- ' || p_cc_trx_id);
2191: arp_standard.debug('result_code :- ' || l_response_rec.result_code);
2192: arp_standard.debug('result_category :- ' || l_response_rec.result_category);
2193: arp_standard.debug('result_message :- ' || l_response_rec.result_message);
2194: arp_standard.debug('l_return_status :- ' || l_return_status);
2195: arp_standard.debug('l_msg_count :- ' || l_msg_count);
2196: arp_standard.debug('l_msg_data :- ' || l_msg_data);
2197: END IF;
2198: END IF;

Line 2195: arp_standard.debug('l_msg_count :- ' || l_msg_count);

2191: arp_standard.debug('result_code :- ' || l_response_rec.result_code);
2192: arp_standard.debug('result_category :- ' || l_response_rec.result_category);
2193: arp_standard.debug('result_message :- ' || l_response_rec.result_message);
2194: arp_standard.debug('l_return_status :- ' || l_return_status);
2195: arp_standard.debug('l_msg_count :- ' || l_msg_count);
2196: arp_standard.debug('l_msg_data :- ' || l_msg_data);
2197: END IF;
2198: END IF;
2199:

Line 2196: arp_standard.debug('l_msg_data :- ' || l_msg_data);

2192: arp_standard.debug('result_category :- ' || l_response_rec.result_category);
2193: arp_standard.debug('result_message :- ' || l_response_rec.result_message);
2194: arp_standard.debug('l_return_status :- ' || l_return_status);
2195: arp_standard.debug('l_msg_count :- ' || l_msg_count);
2196: arp_standard.debug('l_msg_data :- ' || l_msg_data);
2197: END IF;
2198: END IF;
2199:
2200: END IF;