eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AR_BILLS_MAINTAIN_LIB_PVT dependencies on ARP_UTIL

Line 109: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Get_Doc_Seq ()+');

105:
106: BEGIN
107:
108: IF PG_DEBUG in ('Y', 'C') THEN
109: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Get_Doc_Seq ()+');
110: END IF;
111:
112:
113: SELECT count(*)

Line 128: arp_util.debug( 'SEQ : '||NVL( pg_profile_doc_seq, 'N'));

124:
125: pg_profile_doc_seq := fnd_profile.value('UNIQUE:SEQ_NUMBERS');
126:
127: IF PG_DEBUG in ('Y', 'C') THEN
128: arp_util.debug( 'SEQ : '||NVL( pg_profile_doc_seq, 'N'));
129: END IF;
130:
131: SELECT name
132: INTO l_cat_code

Line 140: arp_util.debug( 'Seq numbering on');

136: IF ( NVL( pg_profile_doc_seq, 'N') <> 'N' )
137: THEN
138: BEGIN
139: IF PG_DEBUG in ('Y', 'C') THEN
140: arp_util.debug( 'Seq numbering on');
141: END IF;
142:
143: /*------------------------------+
144: | Get the document sequence. |

Line 165: --arp_util.debug('Doc sequence return status : '||to_char(nvl(l_doc_seq_ret_stat,-99)));

161: msg_flag => l_msg_flag ,
162: suppress_error => 'N' ,
163: suppress_warn => 'Y' );
164:
165: --arp_util.debug('Doc sequence return status : '||to_char(nvl(l_doc_seq_ret_stat,-99)));
166: --arp_util.debug('l_doc_sequence_name : '||l_doc_sequence_name);
167: --arp_util.debug('l_doc_sequence_id : '||to_char(nvl(l_doc_sequence_id,-99)));
168:
169:

Line 166: --arp_util.debug('l_doc_sequence_name : '||l_doc_sequence_name);

162: suppress_error => 'N' ,
163: suppress_warn => 'Y' );
164:
165: --arp_util.debug('Doc sequence return status : '||to_char(nvl(l_doc_seq_ret_stat,-99)));
166: --arp_util.debug('l_doc_sequence_name : '||l_doc_sequence_name);
167: --arp_util.debug('l_doc_sequence_id : '||to_char(nvl(l_doc_sequence_id,-99)));
168:
169:
170: IF (l_doc_seq_ret_stat = -8) THEN

Line 167: --arp_util.debug('l_doc_sequence_id : '||to_char(nvl(l_doc_sequence_id,-99)));

163: suppress_warn => 'Y' );
164:
165: --arp_util.debug('Doc sequence return status : '||to_char(nvl(l_doc_seq_ret_stat,-99)));
166: --arp_util.debug('l_doc_sequence_name : '||l_doc_sequence_name);
167: --arp_util.debug('l_doc_sequence_id : '||to_char(nvl(l_doc_sequence_id,-99)));
168:
169:
170: IF (l_doc_seq_ret_stat = -8) THEN
171:

Line 176: arp_util.debug( '>>>>>>>>>> The doc sequence does not exist for the current document');

172: -- Sequential Numbering is always used and there is
173: -- no assignment for this set of parameters
174:
175: IF PG_DEBUG in ('Y', 'C') THEN
176: arp_util.debug( '>>>>>>>>>> The doc sequence does not exist for the current document');
177: END IF;
178:
179: FND_MESSAGE.Set_Name( 'AR','AR_BR_DOC_SEQ_NOT_EXIST_A');
180: app_exception.raise_exception;

Line 188: arp_util.debug( '>>>>>>>>>> Warning : The doc sequence does not exist for the current document');

184: -- No assignment exists for the set of parameters
185: -- this is the case of Partially Used
186:
187: IF PG_DEBUG in ('Y', 'C') THEN
188: arp_util.debug( '>>>>>>>>>> Warning : The doc sequence does not exist for the current document');
189: END IF;
190:
191: END IF;
192:

Line 208: arp_util.debug( 'Automatic Document Numbering case ');

204: | Automatic Document Numbering case |
205: +------------------------------------*/
206:
207: IF PG_DEBUG in ('Y', 'C') THEN
208: arp_util.debug( 'Automatic Document Numbering case ');
209: END IF;
210:
211: l_doc_seq_ret_stat := fnd_seqnum.get_seq_val (
212: p_appid ,

Line 224: arp_util.debug( '>>>>>>>>>> The user is not supposed to pass in a value in this case');

220: IF (p_trx_rec.doc_sequence_value IS NOT NULL) THEN
221: --raise an error message because the user is not supposed to pass
222: --in a value for the document sequence number in this case.
223: IF PG_DEBUG in ('Y', 'C') THEN
224: arp_util.debug( '>>>>>>>>>> The user is not supposed to pass in a value in this case');
225: END IF;
226: FND_MESSAGE.Set_Name('AR', 'AR_BR_DOC_SEQ_AUTOMATIC');
227: app_exception.raise_exception;
228: END IF;

Line 231: arp_util.debug('l_doc_sequence_value :'||to_char(nvl(p_trx_rec.doc_sequence_value,-99)));

227: app_exception.raise_exception;
228: END IF;
229:
230: p_trx_rec.doc_sequence_value := l_doc_sequence_value;
231: arp_util.debug('l_doc_sequence_value :'||to_char(nvl(p_trx_rec.doc_sequence_value,-99)));
232:
233:
234:
235: ELSIF (p_trx_rec.doc_sequence_id IS NOT NULL) AND (p_trx_rec.doc_sequence_value IS NOT NULL)

Line 260: arp_util.debug( '>>>>>>>>>> A - pg_profile_doc_seq : ' || pg_profile_doc_seq);

256:
257: IF (NVL(pg_profile_doc_seq,'N') = 'A')
258: THEN
259: IF PG_DEBUG in ('Y', 'C') THEN
260: arp_util.debug( '>>>>>>>>>> A - pg_profile_doc_seq : ' || pg_profile_doc_seq);
261: END IF;
262: FND_MESSAGE.Set_Name('AR', 'AR_BR_DOC_SEQ_VALUE_NULL_A');
263: FND_MESSAGE.Set_Token('SEQUENCE', l_doc_sequence_name);
264: app_exception.raise_exception;

Line 270: arp_util.debug( '>>>>>>>>>> P - pg_profile_doc_seq : ' || pg_profile_doc_seq);

266: ELSIF (NVL(pg_profile_doc_seq,'N') = 'P')
267: THEN
268: --Warning
269: IF PG_DEBUG in ('Y', 'C') THEN
270: arp_util.debug( '>>>>>>>>>> P - pg_profile_doc_seq : ' || pg_profile_doc_seq);
271: END IF;
272: FND_MESSAGE.SET_NAME('AR','AR_BR_DOC_SEQ_VALUE_NULL_P');
273: app_exception.raise_exception;
274:

Line 288: arp_util.debug( 'no_data_found raised');

284: | Generate an error if document numbering |
285: | is mandatory. |
286: +------------------------------------------*/
287: IF PG_DEBUG in ('Y', 'C') THEN
288: arp_util.debug( 'no_data_found raised');
289: END IF;
290:
291: IF (pg_profile_doc_seq = 'A' ) THEN
292: IF PG_DEBUG in ('Y', 'C') THEN

Line 293: arp_util.debug( '>>>>>>>>>> no_data_found raised - pg_profile_doc_seq = A');

289: END IF;
290:
291: IF (pg_profile_doc_seq = 'A' ) THEN
292: IF PG_DEBUG in ('Y', 'C') THEN
293: arp_util.debug( '>>>>>>>>>> no_data_found raised - pg_profile_doc_seq = A');
294: END IF;
295: FND_MESSAGE.Set_Name( 'FND','UNIQUE-ALWAYS USED');
296: app_exception.raise_exception;
297: ELSE

Line 299: arp_util.debug( '>>>>>>>>>> no_data_found raised - pg_profile_doc_seq : ' || pg_profile_doc_seq);

295: FND_MESSAGE.Set_Name( 'FND','UNIQUE-ALWAYS USED');
296: app_exception.raise_exception;
297: ELSE
298: IF PG_DEBUG in ('Y', 'C') THEN
299: arp_util.debug( '>>>>>>>>>> no_data_found raised - pg_profile_doc_seq : ' || pg_profile_doc_seq);
300: END IF;
301: p_trx_rec.doc_sequence_id := NULL;
302: p_trx_rec.doc_sequence_value := NULL;
303: END IF;

Line 307: arp_util.debug( '>>>>>>>>>> Unhandled exception in doc sequence assignment');

303: END IF;
304:
305: WHEN OTHERS THEN
306: IF PG_DEBUG in ('Y', 'C') THEN
307: arp_util.debug( '>>>>>>>>>> Unhandled exception in doc sequence assignment');
308: END IF;
309: raise;
310:
311: END;

Line 331: arp_util.debug( '>>>>>>>>>> Bacth Source does not exist');

327:
328: EXCEPTION
329: WHEN NO_DATA_FOUND THEN
330: IF PG_DEBUG in ('Y', 'C') THEN
331: arp_util.debug( '>>>>>>>>>> Bacth Source does not exist');
332: END IF;
333: FND_MESSAGE.Set_Name( 'AR','AR_BR_INVALID_BATCH_SOURCE');
334: app_exception.raise_exception;
335: WHEN OTHERS THEN

Line 337: arp_util.debug( '>>>>>>>>>> Failed when fetching copy doc number flag');

333: FND_MESSAGE.Set_Name( 'AR','AR_BR_INVALID_BATCH_SOURCE');
334: app_exception.raise_exception;
335: WHEN OTHERS THEN
336: IF PG_DEBUG in ('Y', 'C') THEN
337: arp_util.debug( '>>>>>>>>>> Failed when fetching copy doc number flag');
338: END IF;
339: END;
340:
341: IF PG_DEBUG in ('Y', 'C') THEN

Line 342: arp_util.debug( 'Copy Doc Number Flag : ' || l_copy_doc_number_flag);

338: END IF;
339: END;
340:
341: IF PG_DEBUG in ('Y', 'C') THEN
342: arp_util.debug( 'Copy Doc Number Flag : ' || l_copy_doc_number_flag);
343: END IF;
344:
345: IF (NVL(l_copy_doc_number_flag,'N') = 'Y') AND
346: (p_trx_rec.doc_sequence_value IS NOT NULL) AND

Line 354: arp_util.debug( 'Old Trx Number : ' || p_trx_rec.trx_number);

350: p_trx_rec.trx_number := p_trx_rec.doc_sequence_value;
351: END IF;
352:
353: IF PG_DEBUG in ('Y', 'C') THEN
354: arp_util.debug( 'Old Trx Number : ' || p_trx_rec.trx_number);
355: arp_util.debug( 'New Trx Number : ' || p_trx_rec.trx_number);
356: END IF;
357:
358: END IF;

Line 355: arp_util.debug( 'New Trx Number : ' || p_trx_rec.trx_number);

351: END IF;
352:
353: IF PG_DEBUG in ('Y', 'C') THEN
354: arp_util.debug( 'Old Trx Number : ' || p_trx_rec.trx_number);
355: arp_util.debug( 'New Trx Number : ' || p_trx_rec.trx_number);
356: END IF;
357:
358: END IF;
359:

Line 361: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Get_Doc_Seq ()-');

357:
358: END IF;
359:
360: IF PG_DEBUG in ('Y', 'C') THEN
361: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Get_Doc_Seq ()-');
362: END IF;
363:
364: EXCEPTION
365: WHEN OTHERS THEN

Line 367: arp_util.debug('>>>>>>>>>> EXCEPTION : Get_Doc_Seq () ');

363:
364: EXCEPTION
365: WHEN OTHERS THEN
366: IF PG_DEBUG in ('Y', 'C') THEN
367: arp_util.debug('>>>>>>>>>> EXCEPTION : Get_Doc_Seq () ');
368: arp_util.debug( 'p_appid = ' || p_appid);
369: arp_util.debug( 'p_sob_id = ' || p_sob_id);
370: arp_util.debug( 'p_met_code = ' || p_met_code);
371: END IF;

Line 368: arp_util.debug( 'p_appid = ' || p_appid);

364: EXCEPTION
365: WHEN OTHERS THEN
366: IF PG_DEBUG in ('Y', 'C') THEN
367: arp_util.debug('>>>>>>>>>> EXCEPTION : Get_Doc_Seq () ');
368: arp_util.debug( 'p_appid = ' || p_appid);
369: arp_util.debug( 'p_sob_id = ' || p_sob_id);
370: arp_util.debug( 'p_met_code = ' || p_met_code);
371: END IF;
372: RAISE;

Line 369: arp_util.debug( 'p_sob_id = ' || p_sob_id);

365: WHEN OTHERS THEN
366: IF PG_DEBUG in ('Y', 'C') THEN
367: arp_util.debug('>>>>>>>>>> EXCEPTION : Get_Doc_Seq () ');
368: arp_util.debug( 'p_appid = ' || p_appid);
369: arp_util.debug( 'p_sob_id = ' || p_sob_id);
370: arp_util.debug( 'p_met_code = ' || p_met_code);
371: END IF;
372: RAISE;
373:

Line 370: arp_util.debug( 'p_met_code = ' || p_met_code);

366: IF PG_DEBUG in ('Y', 'C') THEN
367: arp_util.debug('>>>>>>>>>> EXCEPTION : Get_Doc_Seq () ');
368: arp_util.debug( 'p_appid = ' || p_appid);
369: arp_util.debug( 'p_sob_id = ' || p_sob_id);
370: arp_util.debug( 'p_met_code = ' || p_met_code);
371: END IF;
372: RAISE;
373:
374: END Get_Doc_Seq;

Line 394: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Set_API_Error ()+');

390: l_data varchar2(4000);
391: l_msg_index_out number;
392:
393: BEGIN
394: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Set_API_Error ()+');
395:
396: FND_MSG_PUB.Get (FND_MSG_PUB.G_FIRST, FND_API.G_TRUE, l_data, l_msg_index_out);
397: FND_MESSAGE.Set_Encoded (l_data);
398: app_exception.raise_exception;

Line 399: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Set_API_Error ()-');

395:
396: FND_MSG_PUB.Get (FND_MSG_PUB.G_FIRST, FND_API.G_TRUE, l_data, l_msg_index_out);
397: FND_MESSAGE.Set_Encoded (l_data);
398: app_exception.raise_exception;
399: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Set_API_Error ()-');
400:
401: EXCEPTION
402: WHEN OTHERS THEN
403: arp_util.debug('>>>>>>>>>> EXCEPTION : Set_API_Error () ');

Line 403: arp_util.debug('>>>>>>>>>> EXCEPTION : Set_API_Error () ');

399: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Set_API_Error ()-');
400:
401: EXCEPTION
402: WHEN OTHERS THEN
403: arp_util.debug('>>>>>>>>>> EXCEPTION : Set_API_Error () ');
404: RAISE;
405:
406: END Set_API_Error;
407:

Line 429: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Get_Remittance_Batch ()+');

425: l_nocopy_batch_id ar_batches.batch_id%TYPE;
426:
427: BEGIN
428: IF PG_DEBUG in ('Y', 'C') THEN
429: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Get_Remittance_Batch ()+');
430: END IF;
431:
432:
433: -- Get the remittance batch id in ra_customer_trx_id

Line 436: arp_util.debug ( 'Customer_Trx_Id : ' || p_customer_trx_id);

432:
433: -- Get the remittance batch id in ra_customer_trx_id
434:
435: IF PG_DEBUG in ('Y', 'C') THEN
436: arp_util.debug ( 'Customer_Trx_Id : ' || p_customer_trx_id);
437: END IF;
438:
439: SELECT remittance_batch_id
440: INTO p_batch_rec.batch_id

Line 451: arp_util.debug ( 'Remittance Batch ID : ' || p_batch_rec.batch_id);

447: l_nocopy_batch_id := p_batch_rec.batch_id;
448: arp_cr_batches_pkg.fetch_p(l_nocopy_batch_id, p_batch_rec);
449:
450: IF PG_DEBUG in ('Y', 'C') THEN
451: arp_util.debug ( 'Remittance Batch ID : ' || p_batch_rec.batch_id);
452: arp_util.debug ( 'Remittance Method : ' || p_batch_rec.remit_method_code);
453: arp_util.debug ( 'With Recourse Flag : ' || p_batch_rec.with_recourse_flag);
454: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Get_Remittance_Batch ()-');
455: END IF;

Line 452: arp_util.debug ( 'Remittance Method : ' || p_batch_rec.remit_method_code);

448: arp_cr_batches_pkg.fetch_p(l_nocopy_batch_id, p_batch_rec);
449:
450: IF PG_DEBUG in ('Y', 'C') THEN
451: arp_util.debug ( 'Remittance Batch ID : ' || p_batch_rec.batch_id);
452: arp_util.debug ( 'Remittance Method : ' || p_batch_rec.remit_method_code);
453: arp_util.debug ( 'With Recourse Flag : ' || p_batch_rec.with_recourse_flag);
454: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Get_Remittance_Batch ()-');
455: END IF;
456:

Line 453: arp_util.debug ( 'With Recourse Flag : ' || p_batch_rec.with_recourse_flag);

449:
450: IF PG_DEBUG in ('Y', 'C') THEN
451: arp_util.debug ( 'Remittance Batch ID : ' || p_batch_rec.batch_id);
452: arp_util.debug ( 'Remittance Method : ' || p_batch_rec.remit_method_code);
453: arp_util.debug ( 'With Recourse Flag : ' || p_batch_rec.with_recourse_flag);
454: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Get_Remittance_Batch ()-');
455: END IF;
456:
457: EXCEPTION

Line 454: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Get_Remittance_Batch ()-');

450: IF PG_DEBUG in ('Y', 'C') THEN
451: arp_util.debug ( 'Remittance Batch ID : ' || p_batch_rec.batch_id);
452: arp_util.debug ( 'Remittance Method : ' || p_batch_rec.remit_method_code);
453: arp_util.debug ( 'With Recourse Flag : ' || p_batch_rec.with_recourse_flag);
454: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Get_Remittance_Batch ()-');
455: END IF;
456:
457: EXCEPTION
458: WHEN NO_DATA_FOUND THEN

Line 460: arp_util.debug( '>>>>>>>>>> The BR has not been remitted yet');

456:
457: EXCEPTION
458: WHEN NO_DATA_FOUND THEN
459: IF PG_DEBUG in ('Y', 'C') THEN
460: arp_util.debug( '>>>>>>>>>> The BR has not been remitted yet');
461: END IF;
462:
463: WHEN OTHERS THEN
464: IF PG_DEBUG in ('Y', 'C') THEN

Line 465: arp_util.debug('>>>>>>>>>> EXCEPTION : Get_Remittance_Batch () ');

461: END IF;
462:
463: WHEN OTHERS THEN
464: IF PG_DEBUG in ('Y', 'C') THEN
465: arp_util.debug('>>>>>>>>>> EXCEPTION : Get_Remittance_Batch () ');
466: arp_util.debug( 'p_customer_trx_id = ' || p_customer_trx_id);
467: END IF;
468: RAISE;
469:

Line 466: arp_util.debug( 'p_customer_trx_id = ' || p_customer_trx_id);

462:
463: WHEN OTHERS THEN
464: IF PG_DEBUG in ('Y', 'C') THEN
465: arp_util.debug('>>>>>>>>>> EXCEPTION : Get_Remittance_Batch () ');
466: arp_util.debug( 'p_customer_trx_id = ' || p_customer_trx_id);
467: END IF;
468: RAISE;
469:
470: END Get_Remittance_Batch;

Line 492: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Update_Reserved_Columns ()+ ');

488: l_ps_rec ar_payment_schedules%ROWTYPE;
489:
490: BEGIN
491: IF PG_DEBUG in ('Y', 'C') THEN
492: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Update_Reserved_Columns ()+ ');
493: END IF;
494:
495: arp_ps_pkg.lock_p(p_payment_schedule_id);
496:

Line 506: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Update_Reserved_Columns ()- ');

502:
503: arp_ps_pkg.update_p (l_ps_rec, l_ps_rec.payment_schedule_id);
504:
505: IF PG_DEBUG in ('Y', 'C') THEN
506: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Update_Reserved_Columns ()- ');
507: END IF;
508:
509: EXCEPTION
510: WHEN OTHERS THEN

Line 512: arp_util.debug('>>>>>>>>>> EXCEPTION : Update_Reserved_Columns () ');

508:
509: EXCEPTION
510: WHEN OTHERS THEN
511: IF PG_DEBUG in ('Y', 'C') THEN
512: arp_util.debug('>>>>>>>>>> EXCEPTION : Update_Reserved_Columns () ');
513: arp_util.debug( 'p_payment_schedule_id = ' || p_payment_schedule_id);
514: arp_util.debug( 'p_reserved_type = ' || p_reserved_type);
515: arp_util.debug( 'p_reserved_value = ' || p_reserved_value);
516: END IF;

Line 513: arp_util.debug( 'p_payment_schedule_id = ' || p_payment_schedule_id);

509: EXCEPTION
510: WHEN OTHERS THEN
511: IF PG_DEBUG in ('Y', 'C') THEN
512: arp_util.debug('>>>>>>>>>> EXCEPTION : Update_Reserved_Columns () ');
513: arp_util.debug( 'p_payment_schedule_id = ' || p_payment_schedule_id);
514: arp_util.debug( 'p_reserved_type = ' || p_reserved_type);
515: arp_util.debug( 'p_reserved_value = ' || p_reserved_value);
516: END IF;
517: RAISE;

Line 514: arp_util.debug( 'p_reserved_type = ' || p_reserved_type);

510: WHEN OTHERS THEN
511: IF PG_DEBUG in ('Y', 'C') THEN
512: arp_util.debug('>>>>>>>>>> EXCEPTION : Update_Reserved_Columns () ');
513: arp_util.debug( 'p_payment_schedule_id = ' || p_payment_schedule_id);
514: arp_util.debug( 'p_reserved_type = ' || p_reserved_type);
515: arp_util.debug( 'p_reserved_value = ' || p_reserved_value);
516: END IF;
517: RAISE;
518:

Line 515: arp_util.debug( 'p_reserved_value = ' || p_reserved_value);

511: IF PG_DEBUG in ('Y', 'C') THEN
512: arp_util.debug('>>>>>>>>>> EXCEPTION : Update_Reserved_Columns () ');
513: arp_util.debug( 'p_payment_schedule_id = ' || p_payment_schedule_id);
514: arp_util.debug( 'p_reserved_type = ' || p_reserved_type);
515: arp_util.debug( 'p_reserved_value = ' || p_reserved_value);
516: END IF;
517: RAISE;
518:
519: END Update_Reserved_Columns;

Line 544: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Default_Action_Dates()+ ');

540:
541: BEGIN
542:
543: IF PG_DEBUG in ('Y', 'C') THEN
544: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Default_Action_Dates()+ ');
545: END IF;
546:
547: ---- Default the action date if NULL
548: IF (p_trx_date IS NULL) THEN

Line 568: arp_util.debug( 'Default_gl_date Return_status : '||l_return_status);

564: AR_BILLS_CREATION_VAL_PVT.Validate_GL_Date (p_gl_date);
565: END IF;
566:
567: IF PG_DEBUG in ('Y', 'C') THEN
568: arp_util.debug( 'Default_gl_date Return_status : '||l_return_status);
569: arp_util.debug( 'GL Date defaulted : ' || p_gl_date);
570: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Default_Action_Dates()-');
571: END IF;
572:

Line 569: arp_util.debug( 'GL Date defaulted : ' || p_gl_date);

565: END IF;
566:
567: IF PG_DEBUG in ('Y', 'C') THEN
568: arp_util.debug( 'Default_gl_date Return_status : '||l_return_status);
569: arp_util.debug( 'GL Date defaulted : ' || p_gl_date);
570: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Default_Action_Dates()-');
571: END IF;
572:
573: EXCEPTION

Line 570: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Default_Action_Dates()-');

566:
567: IF PG_DEBUG in ('Y', 'C') THEN
568: arp_util.debug( 'Default_gl_date Return_status : '||l_return_status);
569: arp_util.debug( 'GL Date defaulted : ' || p_gl_date);
570: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Default_Action_Dates()-');
571: END IF;
572:
573: EXCEPTION
574: WHEN OTHERS THEN

Line 576: arp_util.debug('>>>>>>>>>> EXCEPTION : Default_Action_Dates () ');

572:
573: EXCEPTION
574: WHEN OTHERS THEN
575: IF PG_DEBUG in ('Y', 'C') THEN
576: arp_util.debug('>>>>>>>>>> EXCEPTION : Default_Action_Dates () ');
577: arp_util.debug( 'p_trx_date = ' || p_trx_date);
578: arp_util.debug( 'p_gl_date = ' || p_gl_date);
579: END IF;
580: RAISE;

Line 577: arp_util.debug( 'p_trx_date = ' || p_trx_date);

573: EXCEPTION
574: WHEN OTHERS THEN
575: IF PG_DEBUG in ('Y', 'C') THEN
576: arp_util.debug('>>>>>>>>>> EXCEPTION : Default_Action_Dates () ');
577: arp_util.debug( 'p_trx_date = ' || p_trx_date);
578: arp_util.debug( 'p_gl_date = ' || p_gl_date);
579: END IF;
580: RAISE;
581:

Line 578: arp_util.debug( 'p_gl_date = ' || p_gl_date);

574: WHEN OTHERS THEN
575: IF PG_DEBUG in ('Y', 'C') THEN
576: arp_util.debug('>>>>>>>>>> EXCEPTION : Default_Action_Dates () ');
577: arp_util.debug( 'p_trx_date = ' || p_trx_date);
578: arp_util.debug( 'p_gl_date = ' || p_gl_date);
579: END IF;
580: RAISE;
581:
582: END Default_Action_Dates;

Line 622: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Complete_Or_Accept ()+');

618:
619: BEGIN
620:
621: IF PG_DEBUG in ('Y', 'C') THEN
622: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Complete_Or_Accept ()+');
623: END IF;
624:
625: /*----------------------------------------------+
626: | For each assignment, create a non accounting |

Line 707: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Complete_Or_Accept ()-');

703:
704: END LOOP;
705:
706: IF PG_DEBUG in ('Y', 'C') THEN
707: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Complete_Or_Accept ()-');
708: END IF;
709:
710: EXCEPTION
711: WHEN OTHERS THEN

Line 713: arp_util.debug('>>>>>>>>>> EXCEPTION : Complete_Or_Accept () ');

709:
710: EXCEPTION
711: WHEN OTHERS THEN
712: IF PG_DEBUG in ('Y', 'C') THEN
713: arp_util.debug('>>>>>>>>>> EXCEPTION : Complete_Or_Accept () ');
714: END IF;
715: IF (assignment_cur%ISOPEN)
716: THEN
717: CLOSE assignment_cur;

Line 751: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Complete_Acc_Required ()+');

747:
748: BEGIN
749:
750: IF PG_DEBUG in ('Y', 'C') THEN
751: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Complete_Acc_Required ()+');
752: END IF;
753:
754: /*----------------------------------------------+
755: | For each assignment, update the reserved |

Line 764: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Complete_Acc_Required ()-');

760: update_reserved_columns (assignment_rec.br_ref_payment_schedule_id, 'TRANSACTION', p_customer_trx_id);
761: END LOOP;
762:
763: IF PG_DEBUG in ('Y', 'C') THEN
764: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Complete_Acc_Required ()-');
765: END IF;
766:
767: EXCEPTION
768: WHEN OTHERS THEN

Line 770: arp_util.debug('Complete_Acc_Required: ' || '>>>>>>>>>> EXCEPTION : Complete_Or_Accept () ');

766:
767: EXCEPTION
768: WHEN OTHERS THEN
769: IF PG_DEBUG in ('Y', 'C') THEN
770: arp_util.debug('Complete_Acc_Required: ' || '>>>>>>>>>> EXCEPTION : Complete_Or_Accept () ');
771: arp_util.debug('Complete_Acc_Required: ' || 'p_customer_trx_id : ' || p_customer_trx_id);
772: END IF;
773: IF (assignment_cur%ISOPEN)
774: THEN

Line 771: arp_util.debug('Complete_Acc_Required: ' || 'p_customer_trx_id : ' || p_customer_trx_id);

767: EXCEPTION
768: WHEN OTHERS THEN
769: IF PG_DEBUG in ('Y', 'C') THEN
770: arp_util.debug('Complete_Acc_Required: ' || '>>>>>>>>>> EXCEPTION : Complete_Or_Accept () ');
771: arp_util.debug('Complete_Acc_Required: ' || 'p_customer_trx_id : ' || p_customer_trx_id);
772: END IF;
773: IF (assignment_cur%ISOPEN)
774: THEN
775: CLOSE assignment_cur;

Line 815: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Create_Adjustment ()+');

811:
812: BEGIN
813:
814: IF PG_DEBUG in ('Y', 'C') THEN
815: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Create_Adjustment ()+');
816: END IF;
817:
818: /* SSA change */
819: l_org_id := p_trh_rec.org_id;

Line 826: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Create_adjustment : l_org_return_status <> SUCCESS');

822: p_return_status =>l_org_return_status);
823:
824: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN
825:
826: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Create_adjustment : l_org_return_status <> SUCCESS');
827: ELSE
828:
829: adj_rec.type := 'INVOICE' ;
830: adj_rec.payment_schedule_id := p_ps_rec.payment_schedule_id ;

Line 844: arp_util.debug ( '-----------------------------------------');

840: adj_rec.org_id := p_trh_rec.org_id ;
841:
842:
843: IF PG_DEBUG in ('Y', 'C') THEN
844: arp_util.debug ( '-----------------------------------------');
845: arp_util.debug ('PARAMETERS PASSED TO AR_ADJUST_PUB.Create_Adjustment :');
846: arp_util.debug ( 'adj_rec.payment_schedule_id : ' || adj_rec.payment_schedule_id);
847: arp_util.debug ( 'adj_rec.amount : ' || adj_rec.amount);
848: arp_util.debug ( 'adj_rec.customer_trx_id : ' || adj_rec.customer_trx_id);

Line 845: arp_util.debug ('PARAMETERS PASSED TO AR_ADJUST_PUB.Create_Adjustment :');

841:
842:
843: IF PG_DEBUG in ('Y', 'C') THEN
844: arp_util.debug ( '-----------------------------------------');
845: arp_util.debug ('PARAMETERS PASSED TO AR_ADJUST_PUB.Create_Adjustment :');
846: arp_util.debug ( 'adj_rec.payment_schedule_id : ' || adj_rec.payment_schedule_id);
847: arp_util.debug ( 'adj_rec.amount : ' || adj_rec.amount);
848: arp_util.debug ( 'adj_rec.customer_trx_id : ' || adj_rec.customer_trx_id);
849: arp_util.debug ( 'adj_rec.receivables_trx_id : ' || adj_rec.receivables_trx_id);

Line 846: arp_util.debug ( 'adj_rec.payment_schedule_id : ' || adj_rec.payment_schedule_id);

842:
843: IF PG_DEBUG in ('Y', 'C') THEN
844: arp_util.debug ( '-----------------------------------------');
845: arp_util.debug ('PARAMETERS PASSED TO AR_ADJUST_PUB.Create_Adjustment :');
846: arp_util.debug ( 'adj_rec.payment_schedule_id : ' || adj_rec.payment_schedule_id);
847: arp_util.debug ( 'adj_rec.amount : ' || adj_rec.amount);
848: arp_util.debug ( 'adj_rec.customer_trx_id : ' || adj_rec.customer_trx_id);
849: arp_util.debug ( 'adj_rec.receivables_trx_id : ' || adj_rec.receivables_trx_id);
850: arp_util.debug ( 'adj_rec.apply_date : ' || adj_rec.apply_date);

Line 847: arp_util.debug ( 'adj_rec.amount : ' || adj_rec.amount);

843: IF PG_DEBUG in ('Y', 'C') THEN
844: arp_util.debug ( '-----------------------------------------');
845: arp_util.debug ('PARAMETERS PASSED TO AR_ADJUST_PUB.Create_Adjustment :');
846: arp_util.debug ( 'adj_rec.payment_schedule_id : ' || adj_rec.payment_schedule_id);
847: arp_util.debug ( 'adj_rec.amount : ' || adj_rec.amount);
848: arp_util.debug ( 'adj_rec.customer_trx_id : ' || adj_rec.customer_trx_id);
849: arp_util.debug ( 'adj_rec.receivables_trx_id : ' || adj_rec.receivables_trx_id);
850: arp_util.debug ( 'adj_rec.apply_date : ' || adj_rec.apply_date);
851: arp_util.debug ( 'adj_rec.gl_date : ' || adj_rec.gl_date);

Line 848: arp_util.debug ( 'adj_rec.customer_trx_id : ' || adj_rec.customer_trx_id);

844: arp_util.debug ( '-----------------------------------------');
845: arp_util.debug ('PARAMETERS PASSED TO AR_ADJUST_PUB.Create_Adjustment :');
846: arp_util.debug ( 'adj_rec.payment_schedule_id : ' || adj_rec.payment_schedule_id);
847: arp_util.debug ( 'adj_rec.amount : ' || adj_rec.amount);
848: arp_util.debug ( 'adj_rec.customer_trx_id : ' || adj_rec.customer_trx_id);
849: arp_util.debug ( 'adj_rec.receivables_trx_id : ' || adj_rec.receivables_trx_id);
850: arp_util.debug ( 'adj_rec.apply_date : ' || adj_rec.apply_date);
851: arp_util.debug ( 'adj_rec.gl_date : ' || adj_rec.gl_date);
852: arp_util.debug ( 'adj_rec.comments : ' || adj_rec.comments);

Line 849: arp_util.debug ( 'adj_rec.receivables_trx_id : ' || adj_rec.receivables_trx_id);

845: arp_util.debug ('PARAMETERS PASSED TO AR_ADJUST_PUB.Create_Adjustment :');
846: arp_util.debug ( 'adj_rec.payment_schedule_id : ' || adj_rec.payment_schedule_id);
847: arp_util.debug ( 'adj_rec.amount : ' || adj_rec.amount);
848: arp_util.debug ( 'adj_rec.customer_trx_id : ' || adj_rec.customer_trx_id);
849: arp_util.debug ( 'adj_rec.receivables_trx_id : ' || adj_rec.receivables_trx_id);
850: arp_util.debug ( 'adj_rec.apply_date : ' || adj_rec.apply_date);
851: arp_util.debug ( 'adj_rec.gl_date : ' || adj_rec.gl_date);
852: arp_util.debug ( 'adj_rec.comments : ' || adj_rec.comments);
853: arp_util.debug ( 'adj_rec.status : ' || adj_rec.status);

Line 850: arp_util.debug ( 'adj_rec.apply_date : ' || adj_rec.apply_date);

846: arp_util.debug ( 'adj_rec.payment_schedule_id : ' || adj_rec.payment_schedule_id);
847: arp_util.debug ( 'adj_rec.amount : ' || adj_rec.amount);
848: arp_util.debug ( 'adj_rec.customer_trx_id : ' || adj_rec.customer_trx_id);
849: arp_util.debug ( 'adj_rec.receivables_trx_id : ' || adj_rec.receivables_trx_id);
850: arp_util.debug ( 'adj_rec.apply_date : ' || adj_rec.apply_date);
851: arp_util.debug ( 'adj_rec.gl_date : ' || adj_rec.gl_date);
852: arp_util.debug ( 'adj_rec.comments : ' || adj_rec.comments);
853: arp_util.debug ( 'adj_rec.status : ' || adj_rec.status);
854: arp_util.debug ( 'adj_rec.org_id : ' || adj_rec.org_id);

Line 851: arp_util.debug ( 'adj_rec.gl_date : ' || adj_rec.gl_date);

847: arp_util.debug ( 'adj_rec.amount : ' || adj_rec.amount);
848: arp_util.debug ( 'adj_rec.customer_trx_id : ' || adj_rec.customer_trx_id);
849: arp_util.debug ( 'adj_rec.receivables_trx_id : ' || adj_rec.receivables_trx_id);
850: arp_util.debug ( 'adj_rec.apply_date : ' || adj_rec.apply_date);
851: arp_util.debug ( 'adj_rec.gl_date : ' || adj_rec.gl_date);
852: arp_util.debug ( 'adj_rec.comments : ' || adj_rec.comments);
853: arp_util.debug ( 'adj_rec.status : ' || adj_rec.status);
854: arp_util.debug ( 'adj_rec.org_id : ' || adj_rec.org_id);
855: arp_util.debug ( 'p_move_deferred_tax : ' || p_move_deferred_tax);

Line 852: arp_util.debug ( 'adj_rec.comments : ' || adj_rec.comments);

848: arp_util.debug ( 'adj_rec.customer_trx_id : ' || adj_rec.customer_trx_id);
849: arp_util.debug ( 'adj_rec.receivables_trx_id : ' || adj_rec.receivables_trx_id);
850: arp_util.debug ( 'adj_rec.apply_date : ' || adj_rec.apply_date);
851: arp_util.debug ( 'adj_rec.gl_date : ' || adj_rec.gl_date);
852: arp_util.debug ( 'adj_rec.comments : ' || adj_rec.comments);
853: arp_util.debug ( 'adj_rec.status : ' || adj_rec.status);
854: arp_util.debug ( 'adj_rec.org_id : ' || adj_rec.org_id);
855: arp_util.debug ( 'p_move_deferred_tax : ' || p_move_deferred_tax);
856: arp_util.debug ( '-----------------------------------------');

Line 853: arp_util.debug ( 'adj_rec.status : ' || adj_rec.status);

849: arp_util.debug ( 'adj_rec.receivables_trx_id : ' || adj_rec.receivables_trx_id);
850: arp_util.debug ( 'adj_rec.apply_date : ' || adj_rec.apply_date);
851: arp_util.debug ( 'adj_rec.gl_date : ' || adj_rec.gl_date);
852: arp_util.debug ( 'adj_rec.comments : ' || adj_rec.comments);
853: arp_util.debug ( 'adj_rec.status : ' || adj_rec.status);
854: arp_util.debug ( 'adj_rec.org_id : ' || adj_rec.org_id);
855: arp_util.debug ( 'p_move_deferred_tax : ' || p_move_deferred_tax);
856: arp_util.debug ( '-----------------------------------------');
857: END IF;

Line 854: arp_util.debug ( 'adj_rec.org_id : ' || adj_rec.org_id);

850: arp_util.debug ( 'adj_rec.apply_date : ' || adj_rec.apply_date);
851: arp_util.debug ( 'adj_rec.gl_date : ' || adj_rec.gl_date);
852: arp_util.debug ( 'adj_rec.comments : ' || adj_rec.comments);
853: arp_util.debug ( 'adj_rec.status : ' || adj_rec.status);
854: arp_util.debug ( 'adj_rec.org_id : ' || adj_rec.org_id);
855: arp_util.debug ( 'p_move_deferred_tax : ' || p_move_deferred_tax);
856: arp_util.debug ( '-----------------------------------------');
857: END IF;
858:

Line 855: arp_util.debug ( 'p_move_deferred_tax : ' || p_move_deferred_tax);

851: arp_util.debug ( 'adj_rec.gl_date : ' || adj_rec.gl_date);
852: arp_util.debug ( 'adj_rec.comments : ' || adj_rec.comments);
853: arp_util.debug ( 'adj_rec.status : ' || adj_rec.status);
854: arp_util.debug ( 'adj_rec.org_id : ' || adj_rec.org_id);
855: arp_util.debug ( 'p_move_deferred_tax : ' || p_move_deferred_tax);
856: arp_util.debug ( '-----------------------------------------');
857: END IF;
858:
859: AR_ADJUST_PUB.Create_Adjustment (

Line 856: arp_util.debug ( '-----------------------------------------');

852: arp_util.debug ( 'adj_rec.comments : ' || adj_rec.comments);
853: arp_util.debug ( 'adj_rec.status : ' || adj_rec.status);
854: arp_util.debug ( 'adj_rec.org_id : ' || adj_rec.org_id);
855: arp_util.debug ( 'p_move_deferred_tax : ' || p_move_deferred_tax);
856: arp_util.debug ( '-----------------------------------------');
857: END IF;
858:
859: AR_ADJUST_PUB.Create_Adjustment (
860: p_api_name => 'AR_ADJUST_PUB' ,

Line 875: arp_util.debug ( 'return status : ' || l_return_status);

871: p_new_adjust_id => p_adj_id ,
872: p_org_id => adj_rec.org_id);
873:
874: IF PG_DEBUG in ('Y', 'C') THEN
875: arp_util.debug ( 'return status : ' || l_return_status);
876: arp_util.debug ( 'msg_count : ' || l_msg_count);
877: arp_util.debug ( 'msg_data : ' || l_msg_data);
878: END IF;
879:

Line 876: arp_util.debug ( 'msg_count : ' || l_msg_count);

872: p_org_id => adj_rec.org_id);
873:
874: IF PG_DEBUG in ('Y', 'C') THEN
875: arp_util.debug ( 'return status : ' || l_return_status);
876: arp_util.debug ( 'msg_count : ' || l_msg_count);
877: arp_util.debug ( 'msg_data : ' || l_msg_data);
878: END IF;
879:
880:

Line 877: arp_util.debug ( 'msg_data : ' || l_msg_data);

873:
874: IF PG_DEBUG in ('Y', 'C') THEN
875: arp_util.debug ( 'return status : ' || l_return_status);
876: arp_util.debug ( 'msg_count : ' || l_msg_count);
877: arp_util.debug ( 'msg_data : ' || l_msg_data);
878: END IF;
879:
880:
881: IF (l_return_status <> 'S')

Line 884: arp_util.debug( '>>>>>>>>>> Problems during Adjustment Creation');

880:
881: IF (l_return_status <> 'S')
882: THEN
883: IF PG_DEBUG in ('Y', 'C') THEN
884: arp_util.debug( '>>>>>>>>>> Problems during Adjustment Creation');
885: arp_util.debug( 'l_return_status : ' || l_return_status);
886: arp_util.debug( 'l_msg_count : ' || l_msg_count);
887: arp_util.debug( 'l_msg_data : ' || l_msg_data);
888: END IF;

Line 885: arp_util.debug( 'l_return_status : ' || l_return_status);

881: IF (l_return_status <> 'S')
882: THEN
883: IF PG_DEBUG in ('Y', 'C') THEN
884: arp_util.debug( '>>>>>>>>>> Problems during Adjustment Creation');
885: arp_util.debug( 'l_return_status : ' || l_return_status);
886: arp_util.debug( 'l_msg_count : ' || l_msg_count);
887: arp_util.debug( 'l_msg_data : ' || l_msg_data);
888: END IF;
889:

Line 886: arp_util.debug( 'l_msg_count : ' || l_msg_count);

882: THEN
883: IF PG_DEBUG in ('Y', 'C') THEN
884: arp_util.debug( '>>>>>>>>>> Problems during Adjustment Creation');
885: arp_util.debug( 'l_return_status : ' || l_return_status);
886: arp_util.debug( 'l_msg_count : ' || l_msg_count);
887: arp_util.debug( 'l_msg_data : ' || l_msg_data);
888: END IF;
889:
890: IF (l_msg_count > 0)

Line 887: arp_util.debug( 'l_msg_data : ' || l_msg_data);

883: IF PG_DEBUG in ('Y', 'C') THEN
884: arp_util.debug( '>>>>>>>>>> Problems during Adjustment Creation');
885: arp_util.debug( 'l_return_status : ' || l_return_status);
886: arp_util.debug( 'l_msg_count : ' || l_msg_count);
887: arp_util.debug( 'l_msg_data : ' || l_msg_data);
888: END IF;
889:
890: IF (l_msg_count > 0)
891: THEN

Line 902: arp_util.debug ( 'Adjustment ID created : ' || p_adj_id);

898: END IF;
899: END IF;
900:
901: IF PG_DEBUG in ('Y', 'C') THEN
902: arp_util.debug ( 'Adjustment ID created : ' || p_adj_id);
903: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Create_Adjustment ()-');
904: END IF;
905:
906: EXCEPTION

Line 903: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Create_Adjustment ()-');

899: END IF;
900:
901: IF PG_DEBUG in ('Y', 'C') THEN
902: arp_util.debug ( 'Adjustment ID created : ' || p_adj_id);
903: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Create_Adjustment ()-');
904: END IF;
905:
906: EXCEPTION
907: WHEN OTHERS THEN

Line 909: arp_util.debug('>>>>>>>>>> EXCEPTION : Create_Adjustment () ');

905:
906: EXCEPTION
907: WHEN OTHERS THEN
908: IF PG_DEBUG in ('Y', 'C') THEN
909: arp_util.debug('>>>>>>>>>> EXCEPTION : Create_Adjustment () ');
910: arp_util.debug( 'p_customer_trx_id : ' || p_customer_trx_id);
911: arp_util.debug( 'p_receivables_trx_id : ' || p_receivables_trx_id);
912: arp_util.debug( 'p_status : ' || p_status);
913: arp_util.debug( 'p_amount : ' || p_amount);

Line 910: arp_util.debug( 'p_customer_trx_id : ' || p_customer_trx_id);

906: EXCEPTION
907: WHEN OTHERS THEN
908: IF PG_DEBUG in ('Y', 'C') THEN
909: arp_util.debug('>>>>>>>>>> EXCEPTION : Create_Adjustment () ');
910: arp_util.debug( 'p_customer_trx_id : ' || p_customer_trx_id);
911: arp_util.debug( 'p_receivables_trx_id : ' || p_receivables_trx_id);
912: arp_util.debug( 'p_status : ' || p_status);
913: arp_util.debug( 'p_amount : ' || p_amount);
914: arp_util.debug( 'p_move_deferred_tax : ' || p_move_deferred_tax);

Line 911: arp_util.debug( 'p_receivables_trx_id : ' || p_receivables_trx_id);

907: WHEN OTHERS THEN
908: IF PG_DEBUG in ('Y', 'C') THEN
909: arp_util.debug('>>>>>>>>>> EXCEPTION : Create_Adjustment () ');
910: arp_util.debug( 'p_customer_trx_id : ' || p_customer_trx_id);
911: arp_util.debug( 'p_receivables_trx_id : ' || p_receivables_trx_id);
912: arp_util.debug( 'p_status : ' || p_status);
913: arp_util.debug( 'p_amount : ' || p_amount);
914: arp_util.debug( 'p_move_deferred_tax : ' || p_move_deferred_tax);
915: END IF;

Line 912: arp_util.debug( 'p_status : ' || p_status);

908: IF PG_DEBUG in ('Y', 'C') THEN
909: arp_util.debug('>>>>>>>>>> EXCEPTION : Create_Adjustment () ');
910: arp_util.debug( 'p_customer_trx_id : ' || p_customer_trx_id);
911: arp_util.debug( 'p_receivables_trx_id : ' || p_receivables_trx_id);
912: arp_util.debug( 'p_status : ' || p_status);
913: arp_util.debug( 'p_amount : ' || p_amount);
914: arp_util.debug( 'p_move_deferred_tax : ' || p_move_deferred_tax);
915: END IF;
916: RAISE;

Line 913: arp_util.debug( 'p_amount : ' || p_amount);

909: arp_util.debug('>>>>>>>>>> EXCEPTION : Create_Adjustment () ');
910: arp_util.debug( 'p_customer_trx_id : ' || p_customer_trx_id);
911: arp_util.debug( 'p_receivables_trx_id : ' || p_receivables_trx_id);
912: arp_util.debug( 'p_status : ' || p_status);
913: arp_util.debug( 'p_amount : ' || p_amount);
914: arp_util.debug( 'p_move_deferred_tax : ' || p_move_deferred_tax);
915: END IF;
916: RAISE;
917:

Line 914: arp_util.debug( 'p_move_deferred_tax : ' || p_move_deferred_tax);

910: arp_util.debug( 'p_customer_trx_id : ' || p_customer_trx_id);
911: arp_util.debug( 'p_receivables_trx_id : ' || p_receivables_trx_id);
912: arp_util.debug( 'p_status : ' || p_status);
913: arp_util.debug( 'p_amount : ' || p_amount);
914: arp_util.debug( 'p_move_deferred_tax : ' || p_move_deferred_tax);
915: END IF;
916: RAISE;
917:
918: END Create_Adjustment;

Line 940: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Find_Last_Adjustment ()+');

936:
937: BEGIN
938:
939: IF PG_DEBUG in ('Y', 'C') THEN
940: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Find_Last_Adjustment ()+');
941: END IF;
942:
943: SELECT max(adjustment_id)
944: INTO p_adj_id

Line 949: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Find_Last_Adjustment ()-');

945: FROM ar_adjustments
946: WHERE customer_trx_id = p_customer_trx_id;
947:
948: IF PG_DEBUG in ('Y', 'C') THEN
949: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Find_Last_Adjustment ()-');
950: END IF;
951:
952: EXCEPTION
953: WHEN NO_DATA_FOUND THEN

Line 955: arp_util.debug ('Find_Last_Adjustment: ' || 'No Endorsement Adjustment was found for the BR');

951:
952: EXCEPTION
953: WHEN NO_DATA_FOUND THEN
954: IF PG_DEBUG in ('Y', 'C') THEN
955: arp_util.debug ('Find_Last_Adjustment: ' || 'No Endorsement Adjustment was found for the BR');
956: END IF;
957: RAISE;
958:
959: WHEN OTHERS THEN

Line 961: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.Find_Last_Adjustment () ');

957: RAISE;
958:
959: WHEN OTHERS THEN
960: IF PG_DEBUG in ('Y', 'C') THEN
961: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.Find_Last_Adjustment () ');
962: arp_util.debug('Find_Last_Adjustment: ' || 'p_customer_trx_id : ' || p_customer_trx_id);
963: END IF;
964: RAISE;
965:

Line 962: arp_util.debug('Find_Last_Adjustment: ' || 'p_customer_trx_id : ' || p_customer_trx_id);

958:
959: WHEN OTHERS THEN
960: IF PG_DEBUG in ('Y', 'C') THEN
961: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.Find_Last_Adjustment () ');
962: arp_util.debug('Find_Last_Adjustment: ' || 'p_customer_trx_id : ' || p_customer_trx_id);
963: END IF;
964: RAISE;
965:
966: END Find_Last_Adjustment;

Line 995: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Approve_Adjustment ()+');

991:
992: BEGIN
993:
994: IF PG_DEBUG in ('Y', 'C') THEN
995: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Approve_Adjustment ()+');
996: END IF;
997:
998: /* SSA change */
999: select org_id

Line 1009: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Approve_Adjustment : l_org_return_status <> SUCCESS');

1005: p_return_status =>l_org_return_status);
1006:
1007: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1008:
1009: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Approve_Adjustment : l_org_return_status <> SUCCESS');
1010: ELSE
1011:
1012:
1013: IF PG_DEBUG in ('Y', 'C') THEN

Line 1014: arp_util.debug( '--------------------------------------------------------------');

1010: ELSE
1011:
1012:
1013: IF PG_DEBUG in ('Y', 'C') THEN
1014: arp_util.debug( '--------------------------------------------------------------');
1015: arp_util.debug('PARAMETERS PASSED TO AR_ADJUST_PUB.Approve_Adjustment : ');
1016: arp_util.debug( 'p_old_adjust_id : ' || p_adj_id);
1017: arp_util.debug( 'p_chk_approval_limits : ' || 'F');
1018: arp_util.debug( 'p_move_deferred_tax : ' || p_move_deferred_tax);

Line 1015: arp_util.debug('PARAMETERS PASSED TO AR_ADJUST_PUB.Approve_Adjustment : ');

1011:
1012:
1013: IF PG_DEBUG in ('Y', 'C') THEN
1014: arp_util.debug( '--------------------------------------------------------------');
1015: arp_util.debug('PARAMETERS PASSED TO AR_ADJUST_PUB.Approve_Adjustment : ');
1016: arp_util.debug( 'p_old_adjust_id : ' || p_adj_id);
1017: arp_util.debug( 'p_chk_approval_limits : ' || 'F');
1018: arp_util.debug( 'p_move_deferred_tax : ' || p_move_deferred_tax);
1019: arp_util.debug( 'p_adj_rec.status : ' || l_adj_rec.status);

Line 1016: arp_util.debug( 'p_old_adjust_id : ' || p_adj_id);

1012:
1013: IF PG_DEBUG in ('Y', 'C') THEN
1014: arp_util.debug( '--------------------------------------------------------------');
1015: arp_util.debug('PARAMETERS PASSED TO AR_ADJUST_PUB.Approve_Adjustment : ');
1016: arp_util.debug( 'p_old_adjust_id : ' || p_adj_id);
1017: arp_util.debug( 'p_chk_approval_limits : ' || 'F');
1018: arp_util.debug( 'p_move_deferred_tax : ' || p_move_deferred_tax);
1019: arp_util.debug( 'p_adj_rec.status : ' || l_adj_rec.status);
1020: arp_util.debug( 'p_org_id : ' || l_org_id);

Line 1017: arp_util.debug( 'p_chk_approval_limits : ' || 'F');

1013: IF PG_DEBUG in ('Y', 'C') THEN
1014: arp_util.debug( '--------------------------------------------------------------');
1015: arp_util.debug('PARAMETERS PASSED TO AR_ADJUST_PUB.Approve_Adjustment : ');
1016: arp_util.debug( 'p_old_adjust_id : ' || p_adj_id);
1017: arp_util.debug( 'p_chk_approval_limits : ' || 'F');
1018: arp_util.debug( 'p_move_deferred_tax : ' || p_move_deferred_tax);
1019: arp_util.debug( 'p_adj_rec.status : ' || l_adj_rec.status);
1020: arp_util.debug( 'p_org_id : ' || l_org_id);
1021: arp_util.debug( '--------------------------------------------------------------');

Line 1018: arp_util.debug( 'p_move_deferred_tax : ' || p_move_deferred_tax);

1014: arp_util.debug( '--------------------------------------------------------------');
1015: arp_util.debug('PARAMETERS PASSED TO AR_ADJUST_PUB.Approve_Adjustment : ');
1016: arp_util.debug( 'p_old_adjust_id : ' || p_adj_id);
1017: arp_util.debug( 'p_chk_approval_limits : ' || 'F');
1018: arp_util.debug( 'p_move_deferred_tax : ' || p_move_deferred_tax);
1019: arp_util.debug( 'p_adj_rec.status : ' || l_adj_rec.status);
1020: arp_util.debug( 'p_org_id : ' || l_org_id);
1021: arp_util.debug( '--------------------------------------------------------------');
1022: END IF;

Line 1019: arp_util.debug( 'p_adj_rec.status : ' || l_adj_rec.status);

1015: arp_util.debug('PARAMETERS PASSED TO AR_ADJUST_PUB.Approve_Adjustment : ');
1016: arp_util.debug( 'p_old_adjust_id : ' || p_adj_id);
1017: arp_util.debug( 'p_chk_approval_limits : ' || 'F');
1018: arp_util.debug( 'p_move_deferred_tax : ' || p_move_deferred_tax);
1019: arp_util.debug( 'p_adj_rec.status : ' || l_adj_rec.status);
1020: arp_util.debug( 'p_org_id : ' || l_org_id);
1021: arp_util.debug( '--------------------------------------------------------------');
1022: END IF;
1023:

Line 1020: arp_util.debug( 'p_org_id : ' || l_org_id);

1016: arp_util.debug( 'p_old_adjust_id : ' || p_adj_id);
1017: arp_util.debug( 'p_chk_approval_limits : ' || 'F');
1018: arp_util.debug( 'p_move_deferred_tax : ' || p_move_deferred_tax);
1019: arp_util.debug( 'p_adj_rec.status : ' || l_adj_rec.status);
1020: arp_util.debug( 'p_org_id : ' || l_org_id);
1021: arp_util.debug( '--------------------------------------------------------------');
1022: END IF;
1023:
1024:

Line 1021: arp_util.debug( '--------------------------------------------------------------');

1017: arp_util.debug( 'p_chk_approval_limits : ' || 'F');
1018: arp_util.debug( 'p_move_deferred_tax : ' || p_move_deferred_tax);
1019: arp_util.debug( 'p_adj_rec.status : ' || l_adj_rec.status);
1020: arp_util.debug( 'p_org_id : ' || l_org_id);
1021: arp_util.debug( '--------------------------------------------------------------');
1022: END IF;
1023:
1024:
1025: AR_ADJUST_PUB.Approve_Adjustment (

Line 1041: arp_util.debug( '>>>>>>>>>> Problems during Adjustment Approval');

1037:
1038: IF (l_return_status <> 'S')
1039: THEN
1040: IF PG_DEBUG in ('Y', 'C') THEN
1041: arp_util.debug( '>>>>>>>>>> Problems during Adjustment Approval');
1042: arp_util.debug( 'l_return_status : ' || l_return_status);
1043: arp_util.debug( 'l_msg_count : ' || l_msg_count);
1044: arp_util.debug( 'l_msg_data : ' || l_msg_data);
1045: END IF;

Line 1042: arp_util.debug( 'l_return_status : ' || l_return_status);

1038: IF (l_return_status <> 'S')
1039: THEN
1040: IF PG_DEBUG in ('Y', 'C') THEN
1041: arp_util.debug( '>>>>>>>>>> Problems during Adjustment Approval');
1042: arp_util.debug( 'l_return_status : ' || l_return_status);
1043: arp_util.debug( 'l_msg_count : ' || l_msg_count);
1044: arp_util.debug( 'l_msg_data : ' || l_msg_data);
1045: END IF;
1046:

Line 1043: arp_util.debug( 'l_msg_count : ' || l_msg_count);

1039: THEN
1040: IF PG_DEBUG in ('Y', 'C') THEN
1041: arp_util.debug( '>>>>>>>>>> Problems during Adjustment Approval');
1042: arp_util.debug( 'l_return_status : ' || l_return_status);
1043: arp_util.debug( 'l_msg_count : ' || l_msg_count);
1044: arp_util.debug( 'l_msg_data : ' || l_msg_data);
1045: END IF;
1046:
1047:

Line 1044: arp_util.debug( 'l_msg_data : ' || l_msg_data);

1040: IF PG_DEBUG in ('Y', 'C') THEN
1041: arp_util.debug( '>>>>>>>>>> Problems during Adjustment Approval');
1042: arp_util.debug( 'l_return_status : ' || l_return_status);
1043: arp_util.debug( 'l_msg_count : ' || l_msg_count);
1044: arp_util.debug( 'l_msg_data : ' || l_msg_data);
1045: END IF;
1046:
1047:
1048: IF (l_msg_count > 0)

Line 1060: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Approve_Adjustment ()-');

1056: END IF;
1057: END IF;
1058:
1059: IF PG_DEBUG in ('Y', 'C') THEN
1060: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Approve_Adjustment ()-');
1061: END IF;
1062:
1063: EXCEPTION
1064: WHEN OTHERS THEN

Line 1066: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.Approve_Adjustment : ' || SQLERRM);

1062:
1063: EXCEPTION
1064: WHEN OTHERS THEN
1065: IF PG_DEBUG in ('Y', 'C') THEN
1066: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.Approve_Adjustment : ' || SQLERRM);
1067: arp_util.debug( 'p_adj_id : ' || p_adj_id);
1068: END IF;
1069: RAISE;
1070:

Line 1067: arp_util.debug( 'p_adj_id : ' || p_adj_id);

1063: EXCEPTION
1064: WHEN OTHERS THEN
1065: IF PG_DEBUG in ('Y', 'C') THEN
1066: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.Approve_Adjustment : ' || SQLERRM);
1067: arp_util.debug( 'p_adj_id : ' || p_adj_id);
1068: END IF;
1069: RAISE;
1070:
1071: END Approve_Adjustment;

Line 1099: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Modify_Adjustment ()+');

1095:
1096: BEGIN
1097:
1098: IF PG_DEBUG in ('Y', 'C') THEN
1099: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Modify_Adjustment ()+');
1100: END IF;
1101:
1102: /* SSA change */
1103: select org_id

Line 1113: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Modify_Adjustment : l_org_return_status <> SUCCESS');

1109: p_return_status =>l_org_return_status);
1110:
1111: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1112:
1113: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Modify_Adjustment : l_org_return_status <> SUCCESS');
1114: ELSE
1115:
1116: l_adj_rec.status := p_status;
1117:

Line 1119: arp_util.debug( '--------------------------------------------------------------');

1115:
1116: l_adj_rec.status := p_status;
1117:
1118: IF PG_DEBUG in ('Y', 'C') THEN
1119: arp_util.debug( '--------------------------------------------------------------');
1120: arp_util.debug('PARAMETERS PASSED TO AR_ADJUST_PUB.Modify_Adjustment : ');
1121: arp_util.debug( 'p_old_adjust_id : ' || p_adj_id);
1122: arp_util.debug( 'p_chk_approval_limits : ' || 'F');
1123: arp_util.debug( 'p_adj_rec.status : ' || l_adj_rec.status);

Line 1120: arp_util.debug('PARAMETERS PASSED TO AR_ADJUST_PUB.Modify_Adjustment : ');

1116: l_adj_rec.status := p_status;
1117:
1118: IF PG_DEBUG in ('Y', 'C') THEN
1119: arp_util.debug( '--------------------------------------------------------------');
1120: arp_util.debug('PARAMETERS PASSED TO AR_ADJUST_PUB.Modify_Adjustment : ');
1121: arp_util.debug( 'p_old_adjust_id : ' || p_adj_id);
1122: arp_util.debug( 'p_chk_approval_limits : ' || 'F');
1123: arp_util.debug( 'p_adj_rec.status : ' || l_adj_rec.status);
1124: arp_util.debug( 'p_org_id : ' || l_org_id);

Line 1121: arp_util.debug( 'p_old_adjust_id : ' || p_adj_id);

1117:
1118: IF PG_DEBUG in ('Y', 'C') THEN
1119: arp_util.debug( '--------------------------------------------------------------');
1120: arp_util.debug('PARAMETERS PASSED TO AR_ADJUST_PUB.Modify_Adjustment : ');
1121: arp_util.debug( 'p_old_adjust_id : ' || p_adj_id);
1122: arp_util.debug( 'p_chk_approval_limits : ' || 'F');
1123: arp_util.debug( 'p_adj_rec.status : ' || l_adj_rec.status);
1124: arp_util.debug( 'p_org_id : ' || l_org_id);
1125: arp_util.debug( '--------------------------------------------------------------');

Line 1122: arp_util.debug( 'p_chk_approval_limits : ' || 'F');

1118: IF PG_DEBUG in ('Y', 'C') THEN
1119: arp_util.debug( '--------------------------------------------------------------');
1120: arp_util.debug('PARAMETERS PASSED TO AR_ADJUST_PUB.Modify_Adjustment : ');
1121: arp_util.debug( 'p_old_adjust_id : ' || p_adj_id);
1122: arp_util.debug( 'p_chk_approval_limits : ' || 'F');
1123: arp_util.debug( 'p_adj_rec.status : ' || l_adj_rec.status);
1124: arp_util.debug( 'p_org_id : ' || l_org_id);
1125: arp_util.debug( '--------------------------------------------------------------');
1126: END IF;

Line 1123: arp_util.debug( 'p_adj_rec.status : ' || l_adj_rec.status);

1119: arp_util.debug( '--------------------------------------------------------------');
1120: arp_util.debug('PARAMETERS PASSED TO AR_ADJUST_PUB.Modify_Adjustment : ');
1121: arp_util.debug( 'p_old_adjust_id : ' || p_adj_id);
1122: arp_util.debug( 'p_chk_approval_limits : ' || 'F');
1123: arp_util.debug( 'p_adj_rec.status : ' || l_adj_rec.status);
1124: arp_util.debug( 'p_org_id : ' || l_org_id);
1125: arp_util.debug( '--------------------------------------------------------------');
1126: END IF;
1127:

Line 1124: arp_util.debug( 'p_org_id : ' || l_org_id);

1120: arp_util.debug('PARAMETERS PASSED TO AR_ADJUST_PUB.Modify_Adjustment : ');
1121: arp_util.debug( 'p_old_adjust_id : ' || p_adj_id);
1122: arp_util.debug( 'p_chk_approval_limits : ' || 'F');
1123: arp_util.debug( 'p_adj_rec.status : ' || l_adj_rec.status);
1124: arp_util.debug( 'p_org_id : ' || l_org_id);
1125: arp_util.debug( '--------------------------------------------------------------');
1126: END IF;
1127:
1128:

Line 1125: arp_util.debug( '--------------------------------------------------------------');

1121: arp_util.debug( 'p_old_adjust_id : ' || p_adj_id);
1122: arp_util.debug( 'p_chk_approval_limits : ' || 'F');
1123: arp_util.debug( 'p_adj_rec.status : ' || l_adj_rec.status);
1124: arp_util.debug( 'p_org_id : ' || l_org_id);
1125: arp_util.debug( '--------------------------------------------------------------');
1126: END IF;
1127:
1128:
1129: AR_ADJUST_PUB.Modify_Adjustment(

Line 1145: arp_util.debug( '>>>>>>>>>> Problems during Adjustment Modification');

1141:
1142: IF (l_return_status <> 'S')
1143: THEN
1144: IF PG_DEBUG in ('Y', 'C') THEN
1145: arp_util.debug( '>>>>>>>>>> Problems during Adjustment Modification');
1146: arp_util.debug( 'l_return_status : ' || l_return_status);
1147: arp_util.debug( 'l_msg_count : ' || l_msg_count);
1148: arp_util.debug( 'l_msg_data : ' || l_msg_data);
1149: END IF;

Line 1146: arp_util.debug( 'l_return_status : ' || l_return_status);

1142: IF (l_return_status <> 'S')
1143: THEN
1144: IF PG_DEBUG in ('Y', 'C') THEN
1145: arp_util.debug( '>>>>>>>>>> Problems during Adjustment Modification');
1146: arp_util.debug( 'l_return_status : ' || l_return_status);
1147: arp_util.debug( 'l_msg_count : ' || l_msg_count);
1148: arp_util.debug( 'l_msg_data : ' || l_msg_data);
1149: END IF;
1150:

Line 1147: arp_util.debug( 'l_msg_count : ' || l_msg_count);

1143: THEN
1144: IF PG_DEBUG in ('Y', 'C') THEN
1145: arp_util.debug( '>>>>>>>>>> Problems during Adjustment Modification');
1146: arp_util.debug( 'l_return_status : ' || l_return_status);
1147: arp_util.debug( 'l_msg_count : ' || l_msg_count);
1148: arp_util.debug( 'l_msg_data : ' || l_msg_data);
1149: END IF;
1150:
1151:

Line 1148: arp_util.debug( 'l_msg_data : ' || l_msg_data);

1144: IF PG_DEBUG in ('Y', 'C') THEN
1145: arp_util.debug( '>>>>>>>>>> Problems during Adjustment Modification');
1146: arp_util.debug( 'l_return_status : ' || l_return_status);
1147: arp_util.debug( 'l_msg_count : ' || l_msg_count);
1148: arp_util.debug( 'l_msg_data : ' || l_msg_data);
1149: END IF;
1150:
1151:
1152: IF (l_msg_count > 0)

Line 1165: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Modify_Adjustment ()-');

1161: END IF;
1162:
1163:
1164: IF PG_DEBUG in ('Y', 'C') THEN
1165: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Modify_Adjustment ()-');
1166: END IF;
1167:
1168: EXCEPTION
1169: WHEN OTHERS THEN

Line 1171: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.Modify_Adjustment : ' || SQLERRM);

1167:
1168: EXCEPTION
1169: WHEN OTHERS THEN
1170: IF PG_DEBUG in ('Y', 'C') THEN
1171: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.Modify_Adjustment : ' || SQLERRM);
1172: arp_util.debug( 'p_adj_id : ' || p_adj_id);
1173: arp_util.debug( 'p_status : ' || p_status);
1174: END IF;
1175: RAISE;

Line 1172: arp_util.debug( 'p_adj_id : ' || p_adj_id);

1168: EXCEPTION
1169: WHEN OTHERS THEN
1170: IF PG_DEBUG in ('Y', 'C') THEN
1171: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.Modify_Adjustment : ' || SQLERRM);
1172: arp_util.debug( 'p_adj_id : ' || p_adj_id);
1173: arp_util.debug( 'p_status : ' || p_status);
1174: END IF;
1175: RAISE;
1176:

Line 1173: arp_util.debug( 'p_status : ' || p_status);

1169: WHEN OTHERS THEN
1170: IF PG_DEBUG in ('Y', 'C') THEN
1171: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.Modify_Adjustment : ' || SQLERRM);
1172: arp_util.debug( 'p_adj_id : ' || p_adj_id);
1173: arp_util.debug( 'p_status : ' || p_status);
1174: END IF;
1175: RAISE;
1176:
1177: END Modify_Adjustment;

Line 1207: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Reverse_Adjustment ()+');

1203:
1204: BEGIN
1205:
1206: IF PG_DEBUG in ('Y', 'C') THEN
1207: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Reverse_Adjustment ()+');
1208: END IF;
1209:
1210: /* SSA change */
1211: l_org_id := p_trh_rec.org_id;

Line 1218: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Reverse_Adjustment : l_org_return_status <> SUCCESS');

1214: p_return_status =>l_org_return_status);
1215:
1216: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1217:
1218: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Reverse_Adjustment : l_org_return_status <> SUCCESS');
1219: ELSE
1220:
1221: IF PG_DEBUG in ('Y', 'C') THEN
1222: arp_util.debug( '--------------------------------------------------------------');

Line 1222: arp_util.debug( '--------------------------------------------------------------');

1218: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Reverse_Adjustment : l_org_return_status <> SUCCESS');
1219: ELSE
1220:
1221: IF PG_DEBUG in ('Y', 'C') THEN
1222: arp_util.debug( '--------------------------------------------------------------');
1223: arp_util.debug('PARAMETERS PASSED TO AR_ADJUST_PUB.Reverse_Adjustment : ');
1224: arp_util.debug( 'p_old_adjust_id : ' || p_adj_id);
1225: arp_util.debug( 'p_reversal_date : ' || p_trh_rec.trx_date);
1226: arp_util.debug( 'p_reversal_gl_date : ' || p_trh_rec.gl_date);

Line 1223: arp_util.debug('PARAMETERS PASSED TO AR_ADJUST_PUB.Reverse_Adjustment : ');

1219: ELSE
1220:
1221: IF PG_DEBUG in ('Y', 'C') THEN
1222: arp_util.debug( '--------------------------------------------------------------');
1223: arp_util.debug('PARAMETERS PASSED TO AR_ADJUST_PUB.Reverse_Adjustment : ');
1224: arp_util.debug( 'p_old_adjust_id : ' || p_adj_id);
1225: arp_util.debug( 'p_reversal_date : ' || p_trh_rec.trx_date);
1226: arp_util.debug( 'p_reversal_gl_date : ' || p_trh_rec.gl_date);
1227: arp_util.debug( 'p_comments : ' || p_trh_rec.comments);

Line 1224: arp_util.debug( 'p_old_adjust_id : ' || p_adj_id);

1220:
1221: IF PG_DEBUG in ('Y', 'C') THEN
1222: arp_util.debug( '--------------------------------------------------------------');
1223: arp_util.debug('PARAMETERS PASSED TO AR_ADJUST_PUB.Reverse_Adjustment : ');
1224: arp_util.debug( 'p_old_adjust_id : ' || p_adj_id);
1225: arp_util.debug( 'p_reversal_date : ' || p_trh_rec.trx_date);
1226: arp_util.debug( 'p_reversal_gl_date : ' || p_trh_rec.gl_date);
1227: arp_util.debug( 'p_comments : ' || p_trh_rec.comments);
1228: arp_util.debug( 'p_chk_approval_limits : ' || 'F');

Line 1225: arp_util.debug( 'p_reversal_date : ' || p_trh_rec.trx_date);

1221: IF PG_DEBUG in ('Y', 'C') THEN
1222: arp_util.debug( '--------------------------------------------------------------');
1223: arp_util.debug('PARAMETERS PASSED TO AR_ADJUST_PUB.Reverse_Adjustment : ');
1224: arp_util.debug( 'p_old_adjust_id : ' || p_adj_id);
1225: arp_util.debug( 'p_reversal_date : ' || p_trh_rec.trx_date);
1226: arp_util.debug( 'p_reversal_gl_date : ' || p_trh_rec.gl_date);
1227: arp_util.debug( 'p_comments : ' || p_trh_rec.comments);
1228: arp_util.debug( 'p_chk_approval_limits : ' || 'F');
1229: arp_util.debug( 'p_move_deferred_tax : ' || 'Y');

Line 1226: arp_util.debug( 'p_reversal_gl_date : ' || p_trh_rec.gl_date);

1222: arp_util.debug( '--------------------------------------------------------------');
1223: arp_util.debug('PARAMETERS PASSED TO AR_ADJUST_PUB.Reverse_Adjustment : ');
1224: arp_util.debug( 'p_old_adjust_id : ' || p_adj_id);
1225: arp_util.debug( 'p_reversal_date : ' || p_trh_rec.trx_date);
1226: arp_util.debug( 'p_reversal_gl_date : ' || p_trh_rec.gl_date);
1227: arp_util.debug( 'p_comments : ' || p_trh_rec.comments);
1228: arp_util.debug( 'p_chk_approval_limits : ' || 'F');
1229: arp_util.debug( 'p_move_deferred_tax : ' || 'Y');
1230: arp_util.debug( 'p_called_from : ' || p_called_from);

Line 1227: arp_util.debug( 'p_comments : ' || p_trh_rec.comments);

1223: arp_util.debug('PARAMETERS PASSED TO AR_ADJUST_PUB.Reverse_Adjustment : ');
1224: arp_util.debug( 'p_old_adjust_id : ' || p_adj_id);
1225: arp_util.debug( 'p_reversal_date : ' || p_trh_rec.trx_date);
1226: arp_util.debug( 'p_reversal_gl_date : ' || p_trh_rec.gl_date);
1227: arp_util.debug( 'p_comments : ' || p_trh_rec.comments);
1228: arp_util.debug( 'p_chk_approval_limits : ' || 'F');
1229: arp_util.debug( 'p_move_deferred_tax : ' || 'Y');
1230: arp_util.debug( 'p_called_from : ' || p_called_from);
1231: arp_util.debug( 'p_org_id : ' || p_trh_rec.org_id);

Line 1228: arp_util.debug( 'p_chk_approval_limits : ' || 'F');

1224: arp_util.debug( 'p_old_adjust_id : ' || p_adj_id);
1225: arp_util.debug( 'p_reversal_date : ' || p_trh_rec.trx_date);
1226: arp_util.debug( 'p_reversal_gl_date : ' || p_trh_rec.gl_date);
1227: arp_util.debug( 'p_comments : ' || p_trh_rec.comments);
1228: arp_util.debug( 'p_chk_approval_limits : ' || 'F');
1229: arp_util.debug( 'p_move_deferred_tax : ' || 'Y');
1230: arp_util.debug( 'p_called_from : ' || p_called_from);
1231: arp_util.debug( 'p_org_id : ' || p_trh_rec.org_id);
1232: arp_util.debug( '--------------------------------------------------------------');

Line 1229: arp_util.debug( 'p_move_deferred_tax : ' || 'Y');

1225: arp_util.debug( 'p_reversal_date : ' || p_trh_rec.trx_date);
1226: arp_util.debug( 'p_reversal_gl_date : ' || p_trh_rec.gl_date);
1227: arp_util.debug( 'p_comments : ' || p_trh_rec.comments);
1228: arp_util.debug( 'p_chk_approval_limits : ' || 'F');
1229: arp_util.debug( 'p_move_deferred_tax : ' || 'Y');
1230: arp_util.debug( 'p_called_from : ' || p_called_from);
1231: arp_util.debug( 'p_org_id : ' || p_trh_rec.org_id);
1232: arp_util.debug( '--------------------------------------------------------------');
1233: END IF;

Line 1230: arp_util.debug( 'p_called_from : ' || p_called_from);

1226: arp_util.debug( 'p_reversal_gl_date : ' || p_trh_rec.gl_date);
1227: arp_util.debug( 'p_comments : ' || p_trh_rec.comments);
1228: arp_util.debug( 'p_chk_approval_limits : ' || 'F');
1229: arp_util.debug( 'p_move_deferred_tax : ' || 'Y');
1230: arp_util.debug( 'p_called_from : ' || p_called_from);
1231: arp_util.debug( 'p_org_id : ' || p_trh_rec.org_id);
1232: arp_util.debug( '--------------------------------------------------------------');
1233: END IF;
1234:

Line 1231: arp_util.debug( 'p_org_id : ' || p_trh_rec.org_id);

1227: arp_util.debug( 'p_comments : ' || p_trh_rec.comments);
1228: arp_util.debug( 'p_chk_approval_limits : ' || 'F');
1229: arp_util.debug( 'p_move_deferred_tax : ' || 'Y');
1230: arp_util.debug( 'p_called_from : ' || p_called_from);
1231: arp_util.debug( 'p_org_id : ' || p_trh_rec.org_id);
1232: arp_util.debug( '--------------------------------------------------------------');
1233: END IF;
1234:
1235: AR_ADJUST_PUB.Reverse_Adjustment (

Line 1232: arp_util.debug( '--------------------------------------------------------------');

1228: arp_util.debug( 'p_chk_approval_limits : ' || 'F');
1229: arp_util.debug( 'p_move_deferred_tax : ' || 'Y');
1230: arp_util.debug( 'p_called_from : ' || p_called_from);
1231: arp_util.debug( 'p_org_id : ' || p_trh_rec.org_id);
1232: arp_util.debug( '--------------------------------------------------------------');
1233: END IF;
1234:
1235: AR_ADJUST_PUB.Reverse_Adjustment (
1236: p_api_name => 'AR_ADJUST_PUB' ,

Line 1255: arp_util.debug( '>>>>>>>>>> Problems during Adjustment Reversal');

1251:
1252: IF (l_return_status <> 'S')
1253: THEN
1254: IF PG_DEBUG in ('Y', 'C') THEN
1255: arp_util.debug( '>>>>>>>>>> Problems during Adjustment Reversal');
1256: arp_util.debug( 'l_return_status : ' || l_return_status);
1257: arp_util.debug( 'l_msg_count : ' || l_msg_count);
1258: arp_util.debug( 'l_msg_data : ' || l_msg_data);
1259: END IF;

Line 1256: arp_util.debug( 'l_return_status : ' || l_return_status);

1252: IF (l_return_status <> 'S')
1253: THEN
1254: IF PG_DEBUG in ('Y', 'C') THEN
1255: arp_util.debug( '>>>>>>>>>> Problems during Adjustment Reversal');
1256: arp_util.debug( 'l_return_status : ' || l_return_status);
1257: arp_util.debug( 'l_msg_count : ' || l_msg_count);
1258: arp_util.debug( 'l_msg_data : ' || l_msg_data);
1259: END IF;
1260:

Line 1257: arp_util.debug( 'l_msg_count : ' || l_msg_count);

1253: THEN
1254: IF PG_DEBUG in ('Y', 'C') THEN
1255: arp_util.debug( '>>>>>>>>>> Problems during Adjustment Reversal');
1256: arp_util.debug( 'l_return_status : ' || l_return_status);
1257: arp_util.debug( 'l_msg_count : ' || l_msg_count);
1258: arp_util.debug( 'l_msg_data : ' || l_msg_data);
1259: END IF;
1260:
1261:

Line 1258: arp_util.debug( 'l_msg_data : ' || l_msg_data);

1254: IF PG_DEBUG in ('Y', 'C') THEN
1255: arp_util.debug( '>>>>>>>>>> Problems during Adjustment Reversal');
1256: arp_util.debug( 'l_return_status : ' || l_return_status);
1257: arp_util.debug( 'l_msg_count : ' || l_msg_count);
1258: arp_util.debug( 'l_msg_data : ' || l_msg_data);
1259: END IF;
1260:
1261:
1262: IF (l_msg_count > 0)

Line 1274: arp_util.debug ( 'Adjustment ID : ' || l_new_adjust_id);

1270: END IF;
1271: END IF;
1272:
1273: IF PG_DEBUG in ('Y', 'C') THEN
1274: arp_util.debug ( 'Adjustment ID : ' || l_new_adjust_id);
1275: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Reverse_Adjustment ()-');
1276: END IF;
1277:
1278: EXCEPTION

Line 1275: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Reverse_Adjustment ()-');

1271: END IF;
1272:
1273: IF PG_DEBUG in ('Y', 'C') THEN
1274: arp_util.debug ( 'Adjustment ID : ' || l_new_adjust_id);
1275: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Reverse_Adjustment ()-');
1276: END IF;
1277:
1278: EXCEPTION
1279: WHEN OTHERS THEN

Line 1281: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.Reverse_Adjustment : ' || SQLERRM);

1277:
1278: EXCEPTION
1279: WHEN OTHERS THEN
1280: IF PG_DEBUG in ('Y', 'C') THEN
1281: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.Reverse_Adjustment : ' || SQLERRM);
1282: arp_util.debug( 'p_adj_id : ' || p_adj_id);
1283: END IF;
1284: RAISE;
1285:

Line 1282: arp_util.debug( 'p_adj_id : ' || p_adj_id);

1278: EXCEPTION
1279: WHEN OTHERS THEN
1280: IF PG_DEBUG in ('Y', 'C') THEN
1281: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.Reverse_Adjustment : ' || SQLERRM);
1282: arp_util.debug( 'p_adj_id : ' || p_adj_id);
1283: END IF;
1284: RAISE;
1285:
1286: END Reverse_Adjustment;

Line 1326: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Reverse_Assignments_Adjustment ()+');

1322:
1323: BEGIN
1324:
1325: IF PG_DEBUG in ('Y', 'C') THEN
1326: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Reverse_Assignments_Adjustment ()+');
1327: END IF;
1328:
1329: /*------------------------------------------------------+
1330: | For each assignment, non accounting adjustment |

Line 1399: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Reverse_Assignments_Adjustment ()-');

1395:
1396: END LOOP;
1397:
1398: IF PG_DEBUG in ('Y', 'C') THEN
1399: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Reverse_Assignments_Adjustment ()-');
1400: END IF;
1401:
1402: EXCEPTION
1403: WHEN OTHERS THEN

Line 1405: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.Reverse_Assignments_Adjustment () ');

1401:
1402: EXCEPTION
1403: WHEN OTHERS THEN
1404: IF PG_DEBUG in ('Y', 'C') THEN
1405: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.Reverse_Assignments_Adjustment () ');
1406: arp_util.debug('Reverse_Assignments_Adjustment: ' || 'p_customer_trx_id : ' || p_trh_rec.customer_trx_id);
1407: arp_util.debug('Reverse_Assignments_Adjustment: ' || 'p_acceptance_flag : ' || p_acceptance_flag);
1408: END IF;
1409: IF (assignment_cur%ISOPEN)

Line 1406: arp_util.debug('Reverse_Assignments_Adjustment: ' || 'p_customer_trx_id : ' || p_trh_rec.customer_trx_id);

1402: EXCEPTION
1403: WHEN OTHERS THEN
1404: IF PG_DEBUG in ('Y', 'C') THEN
1405: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.Reverse_Assignments_Adjustment () ');
1406: arp_util.debug('Reverse_Assignments_Adjustment: ' || 'p_customer_trx_id : ' || p_trh_rec.customer_trx_id);
1407: arp_util.debug('Reverse_Assignments_Adjustment: ' || 'p_acceptance_flag : ' || p_acceptance_flag);
1408: END IF;
1409: IF (assignment_cur%ISOPEN)
1410: THEN

Line 1407: arp_util.debug('Reverse_Assignments_Adjustment: ' || 'p_acceptance_flag : ' || p_acceptance_flag);

1403: WHEN OTHERS THEN
1404: IF PG_DEBUG in ('Y', 'C') THEN
1405: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.Reverse_Assignments_Adjustment () ');
1406: arp_util.debug('Reverse_Assignments_Adjustment: ' || 'p_customer_trx_id : ' || p_trh_rec.customer_trx_id);
1407: arp_util.debug('Reverse_Assignments_Adjustment: ' || 'p_acceptance_flag : ' || p_acceptance_flag);
1408: END IF;
1409: IF (assignment_cur%ISOPEN)
1410: THEN
1411: CLOSE assignment_cur;

Line 1436: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Find_Last_Receipt ()+');

1432:
1433: BEGIN
1434:
1435: IF PG_DEBUG in ('Y', 'C') THEN
1436: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Find_Last_Receipt ()+');
1437: END IF;
1438:
1439: SELECT cash_receipt_id
1440: INTO p_cash_receipt_id

Line 1448: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Find_Last_Receipt ()-');

1444: WHERE applied_customer_trx_id = p_customer_trx_id
1445: AND status = 'APP' );
1446:
1447: IF PG_DEBUG in ('Y', 'C') THEN
1448: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Find_Last_Receipt ()-');
1449: END IF;
1450:
1451: EXCEPTION
1452: WHEN NO_DATA_FOUND THEN

Line 1454: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.AR_BILLS_MAINTAIN_LIB_PVT.Find_Last_Receipt () ');

1450:
1451: EXCEPTION
1452: WHEN NO_DATA_FOUND THEN
1453: IF PG_DEBUG in ('Y', 'C') THEN
1454: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.AR_BILLS_MAINTAIN_LIB_PVT.Find_Last_Receipt () ');
1455: arp_util.debug ('Find_Last_Receipt: ' || 'No receipt was found for the BR');
1456: END IF;
1457: RAISE;
1458:

Line 1455: arp_util.debug ('Find_Last_Receipt: ' || 'No receipt was found for the BR');

1451: EXCEPTION
1452: WHEN NO_DATA_FOUND THEN
1453: IF PG_DEBUG in ('Y', 'C') THEN
1454: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.AR_BILLS_MAINTAIN_LIB_PVT.Find_Last_Receipt () ');
1455: arp_util.debug ('Find_Last_Receipt: ' || 'No receipt was found for the BR');
1456: END IF;
1457: RAISE;
1458:
1459: WHEN OTHERS THEN

Line 1461: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.AR_BILLS_MAINTAIN_LIB_PVT.Find_Last_Receipt () ');

1457: RAISE;
1458:
1459: WHEN OTHERS THEN
1460: IF PG_DEBUG in ('Y', 'C') THEN
1461: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.AR_BILLS_MAINTAIN_LIB_PVT.Find_Last_Receipt () ');
1462: arp_util.debug('Find_Last_Receipt: ' || 'p_customer_trx_id : ' || p_customer_trx_id);
1463: END IF;
1464: RAISE;
1465:

Line 1462: arp_util.debug('Find_Last_Receipt: ' || 'p_customer_trx_id : ' || p_customer_trx_id);

1458:
1459: WHEN OTHERS THEN
1460: IF PG_DEBUG in ('Y', 'C') THEN
1461: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.AR_BILLS_MAINTAIN_LIB_PVT.Find_Last_Receipt () ');
1462: arp_util.debug('Find_Last_Receipt: ' || 'p_customer_trx_id : ' || p_customer_trx_id);
1463: END IF;
1464: RAISE;
1465:
1466: END Find_Last_Receipt;

Line 1500: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Find_Last_STD ()+');

1496:
1497: BEGIN
1498:
1499: IF PG_DEBUG in ('Y', 'C') THEN
1500: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Find_Last_STD ()+');
1501: END IF;
1502:
1503: /*-----------------------------------------------+
1504: | Fetch last Short Term Debt Application |

Line 1513: arp_util.debug ('Find_Last_STD: ' || '>>>>>>>>>> Last Short Term Debt Application could not be found');

1509:
1510: IF (last_std_application_cur%NOTFOUND)
1511: THEN
1512: IF PG_DEBUG in ('Y', 'C') THEN
1513: arp_util.debug ('Find_Last_STD: ' || '>>>>>>>>>> Last Short Term Debt Application could not be found');
1514: END IF;
1515: CLOSE last_std_application_cur;
1516: APP_EXCEPTION.raise_exception;
1517: END IF;

Line 1526: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Find_Last_STD ()-');

1522: CLOSE last_std_application_cur;
1523:
1524:
1525: IF PG_DEBUG in ('Y', 'C') THEN
1526: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Find_Last_STD ()-');
1527: END IF;
1528:
1529: EXCEPTION
1530:

Line 1533: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.Find_Last_STD : ' || SQLERRM);

1529: EXCEPTION
1530:
1531: WHEN OTHERS THEN
1532: IF PG_DEBUG in ('Y', 'C') THEN
1533: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.Find_Last_STD : ' || SQLERRM);
1534: END IF;
1535: IF (last_std_application_cur%ISOPEN)
1536: THEN
1537: CLOSE last_std_application_cur;

Line 1571: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Reverse_Receipt ()+');

1567:
1568: BEGIN
1569:
1570: IF PG_DEBUG in ('Y', 'C') THEN
1571: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Reverse_Receipt ()+');
1572: END IF;
1573:
1574: /* SSA change */
1575: l_org_id := p_trh_rec.org_id;

Line 1582: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Reverse_receipt : l_org_return_status <> SUCCESS');

1578: p_return_status =>l_org_return_status);
1579:
1580: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1581:
1582: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Reverse_receipt : l_org_return_status <> SUCCESS');
1583: ELSE
1584: /*------------------------------------------------------+
1585: | Reverse a receipt using Receipt API |
1586: +-------------------------------------------------------*/

Line 1589: arp_util.debug( '--------------------------------------------------------------');

1585: | Reverse a receipt using Receipt API |
1586: +-------------------------------------------------------*/
1587:
1588: IF PG_DEBUG in ('Y', 'C') THEN
1589: arp_util.debug( '--------------------------------------------------------------');
1590: arp_util.debug( 'PARAMETERS PASSED TO AR_RECEIPT_API_PUB.Reverse : ' );
1591: arp_util.debug( 'p_cash_receipt_id : ' || p_cash_receipt_id );
1592: arp_util.debug( 'p_reversal_category_code : ' || 'REV' );
1593: arp_util.debug( 'p_reversal_gl_date : ' || p_trh_rec.gl_date );

Line 1590: arp_util.debug( 'PARAMETERS PASSED TO AR_RECEIPT_API_PUB.Reverse : ' );

1586: +-------------------------------------------------------*/
1587:
1588: IF PG_DEBUG in ('Y', 'C') THEN
1589: arp_util.debug( '--------------------------------------------------------------');
1590: arp_util.debug( 'PARAMETERS PASSED TO AR_RECEIPT_API_PUB.Reverse : ' );
1591: arp_util.debug( 'p_cash_receipt_id : ' || p_cash_receipt_id );
1592: arp_util.debug( 'p_reversal_category_code : ' || 'REV' );
1593: arp_util.debug( 'p_reversal_gl_date : ' || p_trh_rec.gl_date );
1594: arp_util.debug( 'p_reversal_date : ' || p_trh_rec.trx_date );

Line 1591: arp_util.debug( 'p_cash_receipt_id : ' || p_cash_receipt_id );

1587:
1588: IF PG_DEBUG in ('Y', 'C') THEN
1589: arp_util.debug( '--------------------------------------------------------------');
1590: arp_util.debug( 'PARAMETERS PASSED TO AR_RECEIPT_API_PUB.Reverse : ' );
1591: arp_util.debug( 'p_cash_receipt_id : ' || p_cash_receipt_id );
1592: arp_util.debug( 'p_reversal_category_code : ' || 'REV' );
1593: arp_util.debug( 'p_reversal_gl_date : ' || p_trh_rec.gl_date );
1594: arp_util.debug( 'p_reversal_date : ' || p_trh_rec.trx_date );
1595: arp_util.debug( 'p_called_from : ' || p_called_from );

Line 1592: arp_util.debug( 'p_reversal_category_code : ' || 'REV' );

1588: IF PG_DEBUG in ('Y', 'C') THEN
1589: arp_util.debug( '--------------------------------------------------------------');
1590: arp_util.debug( 'PARAMETERS PASSED TO AR_RECEIPT_API_PUB.Reverse : ' );
1591: arp_util.debug( 'p_cash_receipt_id : ' || p_cash_receipt_id );
1592: arp_util.debug( 'p_reversal_category_code : ' || 'REV' );
1593: arp_util.debug( 'p_reversal_gl_date : ' || p_trh_rec.gl_date );
1594: arp_util.debug( 'p_reversal_date : ' || p_trh_rec.trx_date );
1595: arp_util.debug( 'p_called_from : ' || p_called_from );
1596: arp_util.debug( 'p_reversal_reason_code : ' || p_reversal_reason );

Line 1593: arp_util.debug( 'p_reversal_gl_date : ' || p_trh_rec.gl_date );

1589: arp_util.debug( '--------------------------------------------------------------');
1590: arp_util.debug( 'PARAMETERS PASSED TO AR_RECEIPT_API_PUB.Reverse : ' );
1591: arp_util.debug( 'p_cash_receipt_id : ' || p_cash_receipt_id );
1592: arp_util.debug( 'p_reversal_category_code : ' || 'REV' );
1593: arp_util.debug( 'p_reversal_gl_date : ' || p_trh_rec.gl_date );
1594: arp_util.debug( 'p_reversal_date : ' || p_trh_rec.trx_date );
1595: arp_util.debug( 'p_called_from : ' || p_called_from );
1596: arp_util.debug( 'p_reversal_reason_code : ' || p_reversal_reason );
1597: arp_util.debug( 'p_org_id : ' || to_char(p_trh_rec.org_id));

Line 1594: arp_util.debug( 'p_reversal_date : ' || p_trh_rec.trx_date );

1590: arp_util.debug( 'PARAMETERS PASSED TO AR_RECEIPT_API_PUB.Reverse : ' );
1591: arp_util.debug( 'p_cash_receipt_id : ' || p_cash_receipt_id );
1592: arp_util.debug( 'p_reversal_category_code : ' || 'REV' );
1593: arp_util.debug( 'p_reversal_gl_date : ' || p_trh_rec.gl_date );
1594: arp_util.debug( 'p_reversal_date : ' || p_trh_rec.trx_date );
1595: arp_util.debug( 'p_called_from : ' || p_called_from );
1596: arp_util.debug( 'p_reversal_reason_code : ' || p_reversal_reason );
1597: arp_util.debug( 'p_org_id : ' || to_char(p_trh_rec.org_id));
1598: arp_util.debug( '--------------------------------------------------------------');

Line 1595: arp_util.debug( 'p_called_from : ' || p_called_from );

1591: arp_util.debug( 'p_cash_receipt_id : ' || p_cash_receipt_id );
1592: arp_util.debug( 'p_reversal_category_code : ' || 'REV' );
1593: arp_util.debug( 'p_reversal_gl_date : ' || p_trh_rec.gl_date );
1594: arp_util.debug( 'p_reversal_date : ' || p_trh_rec.trx_date );
1595: arp_util.debug( 'p_called_from : ' || p_called_from );
1596: arp_util.debug( 'p_reversal_reason_code : ' || p_reversal_reason );
1597: arp_util.debug( 'p_org_id : ' || to_char(p_trh_rec.org_id));
1598: arp_util.debug( '--------------------------------------------------------------');
1599: END IF;

Line 1596: arp_util.debug( 'p_reversal_reason_code : ' || p_reversal_reason );

1592: arp_util.debug( 'p_reversal_category_code : ' || 'REV' );
1593: arp_util.debug( 'p_reversal_gl_date : ' || p_trh_rec.gl_date );
1594: arp_util.debug( 'p_reversal_date : ' || p_trh_rec.trx_date );
1595: arp_util.debug( 'p_called_from : ' || p_called_from );
1596: arp_util.debug( 'p_reversal_reason_code : ' || p_reversal_reason );
1597: arp_util.debug( 'p_org_id : ' || to_char(p_trh_rec.org_id));
1598: arp_util.debug( '--------------------------------------------------------------');
1599: END IF;
1600:

Line 1597: arp_util.debug( 'p_org_id : ' || to_char(p_trh_rec.org_id));

1593: arp_util.debug( 'p_reversal_gl_date : ' || p_trh_rec.gl_date );
1594: arp_util.debug( 'p_reversal_date : ' || p_trh_rec.trx_date );
1595: arp_util.debug( 'p_called_from : ' || p_called_from );
1596: arp_util.debug( 'p_reversal_reason_code : ' || p_reversal_reason );
1597: arp_util.debug( 'p_org_id : ' || to_char(p_trh_rec.org_id));
1598: arp_util.debug( '--------------------------------------------------------------');
1599: END IF;
1600:
1601: AR_RECEIPT_API_PUB.Reverse (

Line 1598: arp_util.debug( '--------------------------------------------------------------');

1594: arp_util.debug( 'p_reversal_date : ' || p_trh_rec.trx_date );
1595: arp_util.debug( 'p_called_from : ' || p_called_from );
1596: arp_util.debug( 'p_reversal_reason_code : ' || p_reversal_reason );
1597: arp_util.debug( 'p_org_id : ' || to_char(p_trh_rec.org_id));
1598: arp_util.debug( '--------------------------------------------------------------');
1599: END IF;
1600:
1601: AR_RECEIPT_API_PUB.Reverse (
1602: p_api_version => 1.0 ,

Line 1617: arp_util.debug ( 'REVERSAL RECEIPT API Return status : ' || l_return_status);

1613: p_org_id => p_trh_rec.org_id);
1614:
1615:
1616: IF PG_DEBUG in ('Y', 'C') THEN
1617: arp_util.debug ( 'REVERSAL RECEIPT API Return status : ' || l_return_status);
1618: arp_util.debug ( ' l_msg_count : ' || to_char(l_msg_count));
1619: END IF;
1620:
1621:

Line 1618: arp_util.debug ( ' l_msg_count : ' || to_char(l_msg_count));

1614:
1615:
1616: IF PG_DEBUG in ('Y', 'C') THEN
1617: arp_util.debug ( 'REVERSAL RECEIPT API Return status : ' || l_return_status);
1618: arp_util.debug ( ' l_msg_count : ' || to_char(l_msg_count));
1619: END IF;
1620:
1621:
1622: IF (l_return_status <> 'S')

Line 1625: arp_util.debug( '>>>>>>>>>> Problems during Receipt Reversal');

1621:
1622: IF (l_return_status <> 'S')
1623: THEN
1624: IF PG_DEBUG in ('Y', 'C') THEN
1625: arp_util.debug( '>>>>>>>>>> Problems during Receipt Reversal');
1626: arp_util.debug( 'l_return_status : ' || l_return_status);
1627: arp_util.debug( 'l_msg_count : ' || l_msg_count);
1628: arp_util.debug( 'l_msg_data : ' || l_msg_data);
1629: END IF;

Line 1626: arp_util.debug( 'l_return_status : ' || l_return_status);

1622: IF (l_return_status <> 'S')
1623: THEN
1624: IF PG_DEBUG in ('Y', 'C') THEN
1625: arp_util.debug( '>>>>>>>>>> Problems during Receipt Reversal');
1626: arp_util.debug( 'l_return_status : ' || l_return_status);
1627: arp_util.debug( 'l_msg_count : ' || l_msg_count);
1628: arp_util.debug( 'l_msg_data : ' || l_msg_data);
1629: END IF;
1630:

Line 1627: arp_util.debug( 'l_msg_count : ' || l_msg_count);

1623: THEN
1624: IF PG_DEBUG in ('Y', 'C') THEN
1625: arp_util.debug( '>>>>>>>>>> Problems during Receipt Reversal');
1626: arp_util.debug( 'l_return_status : ' || l_return_status);
1627: arp_util.debug( 'l_msg_count : ' || l_msg_count);
1628: arp_util.debug( 'l_msg_data : ' || l_msg_data);
1629: END IF;
1630:
1631: IF (l_msg_count > 0)

Line 1628: arp_util.debug( 'l_msg_data : ' || l_msg_data);

1624: IF PG_DEBUG in ('Y', 'C') THEN
1625: arp_util.debug( '>>>>>>>>>> Problems during Receipt Reversal');
1626: arp_util.debug( 'l_return_status : ' || l_return_status);
1627: arp_util.debug( 'l_msg_count : ' || l_msg_count);
1628: arp_util.debug( 'l_msg_data : ' || l_msg_data);
1629: END IF;
1630:
1631: IF (l_msg_count > 0)
1632: THEN

Line 1643: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Reverse_Receipt ()-');

1639: END IF;
1640: END IF;
1641:
1642: IF PG_DEBUG in ('Y', 'C') THEN
1643: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Reverse_Receipt ()-');
1644: END IF;
1645:
1646: EXCEPTION
1647: WHEN OTHERS THEN

Line 1649: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.Reverse_Receipt : ' || SQLERRM);

1645:
1646: EXCEPTION
1647: WHEN OTHERS THEN
1648: IF PG_DEBUG in ('Y', 'C') THEN
1649: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.Reverse_Receipt : ' || SQLERRM);
1650: arp_util.debug ( 'p_cash_receipt_id : ' || p_cash_receipt_id);
1651: arp_util.debug ( 'p_reversal_reason : ' || p_reversal_reason);
1652: arp_util.debug ( 'p_called_from : ' || p_called_from);
1653: END IF;

Line 1650: arp_util.debug ( 'p_cash_receipt_id : ' || p_cash_receipt_id);

1646: EXCEPTION
1647: WHEN OTHERS THEN
1648: IF PG_DEBUG in ('Y', 'C') THEN
1649: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.Reverse_Receipt : ' || SQLERRM);
1650: arp_util.debug ( 'p_cash_receipt_id : ' || p_cash_receipt_id);
1651: arp_util.debug ( 'p_reversal_reason : ' || p_reversal_reason);
1652: arp_util.debug ( 'p_called_from : ' || p_called_from);
1653: END IF;
1654: RAISE;

Line 1651: arp_util.debug ( 'p_reversal_reason : ' || p_reversal_reason);

1647: WHEN OTHERS THEN
1648: IF PG_DEBUG in ('Y', 'C') THEN
1649: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.Reverse_Receipt : ' || SQLERRM);
1650: arp_util.debug ( 'p_cash_receipt_id : ' || p_cash_receipt_id);
1651: arp_util.debug ( 'p_reversal_reason : ' || p_reversal_reason);
1652: arp_util.debug ( 'p_called_from : ' || p_called_from);
1653: END IF;
1654: RAISE;
1655:

Line 1652: arp_util.debug ( 'p_called_from : ' || p_called_from);

1648: IF PG_DEBUG in ('Y', 'C') THEN
1649: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.Reverse_Receipt : ' || SQLERRM);
1650: arp_util.debug ( 'p_cash_receipt_id : ' || p_cash_receipt_id);
1651: arp_util.debug ( 'p_reversal_reason : ' || p_reversal_reason);
1652: arp_util.debug ( 'p_called_from : ' || p_called_from);
1653: END IF;
1654: RAISE;
1655:
1656: END Reverse_Receipt;

Line 1685: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Unapply_Receipt ()+');

1681:
1682: BEGIN
1683:
1684: IF PG_DEBUG in ('Y', 'C') THEN
1685: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Unapply_Receipt ()+');
1686: END IF;
1687:
1688: /* SSA change */
1689: l_org_id := p_trh_rec.org_id;

Line 1696: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Unapply_Receipt : l_org_return_status <> SUCCESS');

1692: p_return_status =>l_org_return_status);
1693:
1694: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1695:
1696: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Unapply_Receipt : l_org_return_status <> SUCCESS');
1697: ELSE
1698:
1699: /*------------------------------------------------------+
1700: | Unapply a receipt using Receipt API |

Line 1704: arp_util.debug( '--------------------------------------------------------------');

1700: | Unapply a receipt using Receipt API |
1701: +-------------------------------------------------------*/
1702:
1703: IF PG_DEBUG in ('Y', 'C') THEN
1704: arp_util.debug( '--------------------------------------------------------------');
1705: arp_util.debug( 'PARAMETERS PASSED TO AR_RECEIPT_API_PUB.Unapply : ' );
1706: arp_util.debug( 'p_cash_receipt_id : ' || p_cash_receipt_id);
1707: arp_util.debug( 'p_customer_trx_id : ' || p_trh_rec.customer_trx_id);
1708: arp_util.debug( 'p_applied_payment_schedule_id : ' || p_ps_id);

Line 1705: arp_util.debug( 'PARAMETERS PASSED TO AR_RECEIPT_API_PUB.Unapply : ' );

1701: +-------------------------------------------------------*/
1702:
1703: IF PG_DEBUG in ('Y', 'C') THEN
1704: arp_util.debug( '--------------------------------------------------------------');
1705: arp_util.debug( 'PARAMETERS PASSED TO AR_RECEIPT_API_PUB.Unapply : ' );
1706: arp_util.debug( 'p_cash_receipt_id : ' || p_cash_receipt_id);
1707: arp_util.debug( 'p_customer_trx_id : ' || p_trh_rec.customer_trx_id);
1708: arp_util.debug( 'p_applied_payment_schedule_id : ' || p_ps_id);
1709: arp_util.debug( 'p_reversal_gl_date : ' || p_trh_rec.gl_date);

Line 1706: arp_util.debug( 'p_cash_receipt_id : ' || p_cash_receipt_id);

1702:
1703: IF PG_DEBUG in ('Y', 'C') THEN
1704: arp_util.debug( '--------------------------------------------------------------');
1705: arp_util.debug( 'PARAMETERS PASSED TO AR_RECEIPT_API_PUB.Unapply : ' );
1706: arp_util.debug( 'p_cash_receipt_id : ' || p_cash_receipt_id);
1707: arp_util.debug( 'p_customer_trx_id : ' || p_trh_rec.customer_trx_id);
1708: arp_util.debug( 'p_applied_payment_schedule_id : ' || p_ps_id);
1709: arp_util.debug( 'p_reversal_gl_date : ' || p_trh_rec.gl_date);
1710: arp_util.debug( 'p_called_from : ' || p_called_from);

Line 1707: arp_util.debug( 'p_customer_trx_id : ' || p_trh_rec.customer_trx_id);

1703: IF PG_DEBUG in ('Y', 'C') THEN
1704: arp_util.debug( '--------------------------------------------------------------');
1705: arp_util.debug( 'PARAMETERS PASSED TO AR_RECEIPT_API_PUB.Unapply : ' );
1706: arp_util.debug( 'p_cash_receipt_id : ' || p_cash_receipt_id);
1707: arp_util.debug( 'p_customer_trx_id : ' || p_trh_rec.customer_trx_id);
1708: arp_util.debug( 'p_applied_payment_schedule_id : ' || p_ps_id);
1709: arp_util.debug( 'p_reversal_gl_date : ' || p_trh_rec.gl_date);
1710: arp_util.debug( 'p_called_from : ' || p_called_from);
1711: arp_util.debug( 'p_org_id : ' || to_char(p_trh_rec.org_id));

Line 1708: arp_util.debug( 'p_applied_payment_schedule_id : ' || p_ps_id);

1704: arp_util.debug( '--------------------------------------------------------------');
1705: arp_util.debug( 'PARAMETERS PASSED TO AR_RECEIPT_API_PUB.Unapply : ' );
1706: arp_util.debug( 'p_cash_receipt_id : ' || p_cash_receipt_id);
1707: arp_util.debug( 'p_customer_trx_id : ' || p_trh_rec.customer_trx_id);
1708: arp_util.debug( 'p_applied_payment_schedule_id : ' || p_ps_id);
1709: arp_util.debug( 'p_reversal_gl_date : ' || p_trh_rec.gl_date);
1710: arp_util.debug( 'p_called_from : ' || p_called_from);
1711: arp_util.debug( 'p_org_id : ' || to_char(p_trh_rec.org_id));
1712: arp_util.debug( '--------------------------------------------------------------');

Line 1709: arp_util.debug( 'p_reversal_gl_date : ' || p_trh_rec.gl_date);

1705: arp_util.debug( 'PARAMETERS PASSED TO AR_RECEIPT_API_PUB.Unapply : ' );
1706: arp_util.debug( 'p_cash_receipt_id : ' || p_cash_receipt_id);
1707: arp_util.debug( 'p_customer_trx_id : ' || p_trh_rec.customer_trx_id);
1708: arp_util.debug( 'p_applied_payment_schedule_id : ' || p_ps_id);
1709: arp_util.debug( 'p_reversal_gl_date : ' || p_trh_rec.gl_date);
1710: arp_util.debug( 'p_called_from : ' || p_called_from);
1711: arp_util.debug( 'p_org_id : ' || to_char(p_trh_rec.org_id));
1712: arp_util.debug( '--------------------------------------------------------------');
1713: END IF;

Line 1710: arp_util.debug( 'p_called_from : ' || p_called_from);

1706: arp_util.debug( 'p_cash_receipt_id : ' || p_cash_receipt_id);
1707: arp_util.debug( 'p_customer_trx_id : ' || p_trh_rec.customer_trx_id);
1708: arp_util.debug( 'p_applied_payment_schedule_id : ' || p_ps_id);
1709: arp_util.debug( 'p_reversal_gl_date : ' || p_trh_rec.gl_date);
1710: arp_util.debug( 'p_called_from : ' || p_called_from);
1711: arp_util.debug( 'p_org_id : ' || to_char(p_trh_rec.org_id));
1712: arp_util.debug( '--------------------------------------------------------------');
1713: END IF;
1714:

Line 1711: arp_util.debug( 'p_org_id : ' || to_char(p_trh_rec.org_id));

1707: arp_util.debug( 'p_customer_trx_id : ' || p_trh_rec.customer_trx_id);
1708: arp_util.debug( 'p_applied_payment_schedule_id : ' || p_ps_id);
1709: arp_util.debug( 'p_reversal_gl_date : ' || p_trh_rec.gl_date);
1710: arp_util.debug( 'p_called_from : ' || p_called_from);
1711: arp_util.debug( 'p_org_id : ' || to_char(p_trh_rec.org_id));
1712: arp_util.debug( '--------------------------------------------------------------');
1713: END IF;
1714:
1715: AR_RECEIPT_API_PUB.Unapply (

Line 1712: arp_util.debug( '--------------------------------------------------------------');

1708: arp_util.debug( 'p_applied_payment_schedule_id : ' || p_ps_id);
1709: arp_util.debug( 'p_reversal_gl_date : ' || p_trh_rec.gl_date);
1710: arp_util.debug( 'p_called_from : ' || p_called_from);
1711: arp_util.debug( 'p_org_id : ' || to_char(p_trh_rec.org_id));
1712: arp_util.debug( '--------------------------------------------------------------');
1713: END IF;
1714:
1715: AR_RECEIPT_API_PUB.Unapply (
1716: p_api_version => 1.0 ,

Line 1730: arp_util.debug ( 'UNAPPLY RECEIPT API Return status : ' || l_return_status);

1726: p_org_id => p_trh_rec.org_id);
1727:
1728:
1729: IF PG_DEBUG in ('Y', 'C') THEN
1730: arp_util.debug ( 'UNAPPLY RECEIPT API Return status : ' || l_return_status);
1731: arp_util.debug ( ' l_msg_count : ' || to_char(l_msg_count));
1732: END IF;
1733:
1734:

Line 1731: arp_util.debug ( ' l_msg_count : ' || to_char(l_msg_count));

1727:
1728:
1729: IF PG_DEBUG in ('Y', 'C') THEN
1730: arp_util.debug ( 'UNAPPLY RECEIPT API Return status : ' || l_return_status);
1731: arp_util.debug ( ' l_msg_count : ' || to_char(l_msg_count));
1732: END IF;
1733:
1734:
1735: IF (l_return_status <> 'S')

Line 1738: arp_util.debug( '>>>>>>>>>> Problems during Receipt Unapplication');

1734:
1735: IF (l_return_status <> 'S')
1736: THEN
1737: IF PG_DEBUG in ('Y', 'C') THEN
1738: arp_util.debug( '>>>>>>>>>> Problems during Receipt Unapplication');
1739: arp_util.debug( 'l_return_status : ' || l_return_status);
1740: arp_util.debug( 'l_msg_count : ' || l_msg_count);
1741: arp_util.debug( 'l_msg_data : ' || l_msg_data);
1742: END IF;

Line 1739: arp_util.debug( 'l_return_status : ' || l_return_status);

1735: IF (l_return_status <> 'S')
1736: THEN
1737: IF PG_DEBUG in ('Y', 'C') THEN
1738: arp_util.debug( '>>>>>>>>>> Problems during Receipt Unapplication');
1739: arp_util.debug( 'l_return_status : ' || l_return_status);
1740: arp_util.debug( 'l_msg_count : ' || l_msg_count);
1741: arp_util.debug( 'l_msg_data : ' || l_msg_data);
1742: END IF;
1743:

Line 1740: arp_util.debug( 'l_msg_count : ' || l_msg_count);

1736: THEN
1737: IF PG_DEBUG in ('Y', 'C') THEN
1738: arp_util.debug( '>>>>>>>>>> Problems during Receipt Unapplication');
1739: arp_util.debug( 'l_return_status : ' || l_return_status);
1740: arp_util.debug( 'l_msg_count : ' || l_msg_count);
1741: arp_util.debug( 'l_msg_data : ' || l_msg_data);
1742: END IF;
1743:
1744:

Line 1741: arp_util.debug( 'l_msg_data : ' || l_msg_data);

1737: IF PG_DEBUG in ('Y', 'C') THEN
1738: arp_util.debug( '>>>>>>>>>> Problems during Receipt Unapplication');
1739: arp_util.debug( 'l_return_status : ' || l_return_status);
1740: arp_util.debug( 'l_msg_count : ' || l_msg_count);
1741: arp_util.debug( 'l_msg_data : ' || l_msg_data);
1742: END IF;
1743:
1744:
1745: IF (l_msg_count > 0)

Line 1758: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Unapply_Receipt ()-');

1754: END IF;
1755:
1756:
1757: IF PG_DEBUG in ('Y', 'C') THEN
1758: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Unapply_Receipt ()-');
1759: END IF;
1760:
1761: EXCEPTION
1762: WHEN OTHERS THEN

Line 1764: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.Unapply_Receipt : ' || SQLERRM);

1760:
1761: EXCEPTION
1762: WHEN OTHERS THEN
1763: IF PG_DEBUG in ('Y', 'C') THEN
1764: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.Unapply_Receipt : ' || SQLERRM);
1765: arp_util.debug ( 'p_cash_receipt_id : ' || p_cash_receipt_id );
1766: arp_util.debug ( 'p_called_from : ' || p_called_from );
1767: arp_util.debug ( 'p_ps_id : ' || p_ps_id );
1768: arp_util.debug ( 'p_trh_rec.customer_trx_id : ' || p_trh_rec.customer_trx_id );

Line 1765: arp_util.debug ( 'p_cash_receipt_id : ' || p_cash_receipt_id );

1761: EXCEPTION
1762: WHEN OTHERS THEN
1763: IF PG_DEBUG in ('Y', 'C') THEN
1764: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.Unapply_Receipt : ' || SQLERRM);
1765: arp_util.debug ( 'p_cash_receipt_id : ' || p_cash_receipt_id );
1766: arp_util.debug ( 'p_called_from : ' || p_called_from );
1767: arp_util.debug ( 'p_ps_id : ' || p_ps_id );
1768: arp_util.debug ( 'p_trh_rec.customer_trx_id : ' || p_trh_rec.customer_trx_id );
1769: END IF;

Line 1766: arp_util.debug ( 'p_called_from : ' || p_called_from );

1762: WHEN OTHERS THEN
1763: IF PG_DEBUG in ('Y', 'C') THEN
1764: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.Unapply_Receipt : ' || SQLERRM);
1765: arp_util.debug ( 'p_cash_receipt_id : ' || p_cash_receipt_id );
1766: arp_util.debug ( 'p_called_from : ' || p_called_from );
1767: arp_util.debug ( 'p_ps_id : ' || p_ps_id );
1768: arp_util.debug ( 'p_trh_rec.customer_trx_id : ' || p_trh_rec.customer_trx_id );
1769: END IF;
1770: RAISE;

Line 1767: arp_util.debug ( 'p_ps_id : ' || p_ps_id );

1763: IF PG_DEBUG in ('Y', 'C') THEN
1764: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.Unapply_Receipt : ' || SQLERRM);
1765: arp_util.debug ( 'p_cash_receipt_id : ' || p_cash_receipt_id );
1766: arp_util.debug ( 'p_called_from : ' || p_called_from );
1767: arp_util.debug ( 'p_ps_id : ' || p_ps_id );
1768: arp_util.debug ( 'p_trh_rec.customer_trx_id : ' || p_trh_rec.customer_trx_id );
1769: END IF;
1770: RAISE;
1771:

Line 1768: arp_util.debug ( 'p_trh_rec.customer_trx_id : ' || p_trh_rec.customer_trx_id );

1764: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.Unapply_Receipt : ' || SQLERRM);
1765: arp_util.debug ( 'p_cash_receipt_id : ' || p_cash_receipt_id );
1766: arp_util.debug ( 'p_called_from : ' || p_called_from );
1767: arp_util.debug ( 'p_ps_id : ' || p_ps_id );
1768: arp_util.debug ( 'p_trh_rec.customer_trx_id : ' || p_trh_rec.customer_trx_id );
1769: END IF;
1770: RAISE;
1771:
1772: END Unapply_Receipt;

Line 1811: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Apply_STD ()+');

1807: l_org_id NUMBER;
1808: BEGIN
1809:
1810: IF PG_DEBUG in ('Y', 'C') THEN
1811: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Apply_STD ()+');
1812: END IF;
1813:
1814:
1815: /* SSA change */

Line 1823: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Apply_STD l_org_return_status <> SUCCESS');

1819: p_return_status =>l_org_return_status);
1820:
1821: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1822:
1823: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Apply_STD l_org_return_status <> SUCCESS');
1824: ELSE
1825:
1826: /*------------------------------------------------------+
1827: | Fetch the Cash Receipt Information |

Line 1851: arp_util.debug( '--------------------------------------------------------------');

1847: | Apply receipt to Short Term Debt using Receipt API |
1848: +-------------------------------------------------------*/
1849:
1850: IF PG_DEBUG in ('Y', 'C') THEN
1851: arp_util.debug( '--------------------------------------------------------------');
1852: arp_util.debug( 'PARAMETERS PASSED TO AR_RECEIPT_API_PUB.Activity_Application : ');
1853: arp_util.debug( 'p_cash_receipt_id : ' || p_cash_receipt_id);
1854: arp_util.debug( 'p_amount_applied : ' || l_cr_rec.amount);
1855: arp_util.debug( 'p_applied_payment_schedule : ' || '-2');

Line 1852: arp_util.debug( 'PARAMETERS PASSED TO AR_RECEIPT_API_PUB.Activity_Application : ');

1848: +-------------------------------------------------------*/
1849:
1850: IF PG_DEBUG in ('Y', 'C') THEN
1851: arp_util.debug( '--------------------------------------------------------------');
1852: arp_util.debug( 'PARAMETERS PASSED TO AR_RECEIPT_API_PUB.Activity_Application : ');
1853: arp_util.debug( 'p_cash_receipt_id : ' || p_cash_receipt_id);
1854: arp_util.debug( 'p_amount_applied : ' || l_cr_rec.amount);
1855: arp_util.debug( 'p_applied_payment_schedule : ' || '-2');
1856: arp_util.debug( 'p_link_to_customer_trx_id : ' || p_customer_trx_id);

Line 1853: arp_util.debug( 'p_cash_receipt_id : ' || p_cash_receipt_id);

1849:
1850: IF PG_DEBUG in ('Y', 'C') THEN
1851: arp_util.debug( '--------------------------------------------------------------');
1852: arp_util.debug( 'PARAMETERS PASSED TO AR_RECEIPT_API_PUB.Activity_Application : ');
1853: arp_util.debug( 'p_cash_receipt_id : ' || p_cash_receipt_id);
1854: arp_util.debug( 'p_amount_applied : ' || l_cr_rec.amount);
1855: arp_util.debug( 'p_applied_payment_schedule : ' || '-2');
1856: arp_util.debug( 'p_link_to_customer_trx_id : ' || p_customer_trx_id);
1857: arp_util.debug( 'p_receivables_trx_id : ' || l_receivables_trx_id);

Line 1854: arp_util.debug( 'p_amount_applied : ' || l_cr_rec.amount);

1850: IF PG_DEBUG in ('Y', 'C') THEN
1851: arp_util.debug( '--------------------------------------------------------------');
1852: arp_util.debug( 'PARAMETERS PASSED TO AR_RECEIPT_API_PUB.Activity_Application : ');
1853: arp_util.debug( 'p_cash_receipt_id : ' || p_cash_receipt_id);
1854: arp_util.debug( 'p_amount_applied : ' || l_cr_rec.amount);
1855: arp_util.debug( 'p_applied_payment_schedule : ' || '-2');
1856: arp_util.debug( 'p_link_to_customer_trx_id : ' || p_customer_trx_id);
1857: arp_util.debug( 'p_receivables_trx_id : ' || l_receivables_trx_id);
1858: arp_util.debug( 'p_apply_date : ' || p_apply_date);

Line 1855: arp_util.debug( 'p_applied_payment_schedule : ' || '-2');

1851: arp_util.debug( '--------------------------------------------------------------');
1852: arp_util.debug( 'PARAMETERS PASSED TO AR_RECEIPT_API_PUB.Activity_Application : ');
1853: arp_util.debug( 'p_cash_receipt_id : ' || p_cash_receipt_id);
1854: arp_util.debug( 'p_amount_applied : ' || l_cr_rec.amount);
1855: arp_util.debug( 'p_applied_payment_schedule : ' || '-2');
1856: arp_util.debug( 'p_link_to_customer_trx_id : ' || p_customer_trx_id);
1857: arp_util.debug( 'p_receivables_trx_id : ' || l_receivables_trx_id);
1858: arp_util.debug( 'p_apply_date : ' || p_apply_date);
1859: arp_util.debug( 'p_apply_gl_date : ' || p_apply_gl_date);

Line 1856: arp_util.debug( 'p_link_to_customer_trx_id : ' || p_customer_trx_id);

1852: arp_util.debug( 'PARAMETERS PASSED TO AR_RECEIPT_API_PUB.Activity_Application : ');
1853: arp_util.debug( 'p_cash_receipt_id : ' || p_cash_receipt_id);
1854: arp_util.debug( 'p_amount_applied : ' || l_cr_rec.amount);
1855: arp_util.debug( 'p_applied_payment_schedule : ' || '-2');
1856: arp_util.debug( 'p_link_to_customer_trx_id : ' || p_customer_trx_id);
1857: arp_util.debug( 'p_receivables_trx_id : ' || l_receivables_trx_id);
1858: arp_util.debug( 'p_apply_date : ' || p_apply_date);
1859: arp_util.debug( 'p_apply_gl_date : ' || p_apply_gl_date);
1860: arp_util.debug( 'p_org_id : ' || to_char(l_cr_rec.org_id));

Line 1857: arp_util.debug( 'p_receivables_trx_id : ' || l_receivables_trx_id);

1853: arp_util.debug( 'p_cash_receipt_id : ' || p_cash_receipt_id);
1854: arp_util.debug( 'p_amount_applied : ' || l_cr_rec.amount);
1855: arp_util.debug( 'p_applied_payment_schedule : ' || '-2');
1856: arp_util.debug( 'p_link_to_customer_trx_id : ' || p_customer_trx_id);
1857: arp_util.debug( 'p_receivables_trx_id : ' || l_receivables_trx_id);
1858: arp_util.debug( 'p_apply_date : ' || p_apply_date);
1859: arp_util.debug( 'p_apply_gl_date : ' || p_apply_gl_date);
1860: arp_util.debug( 'p_org_id : ' || to_char(l_cr_rec.org_id));
1861: arp_util.debug( '--------------------------------------------------------------');

Line 1858: arp_util.debug( 'p_apply_date : ' || p_apply_date);

1854: arp_util.debug( 'p_amount_applied : ' || l_cr_rec.amount);
1855: arp_util.debug( 'p_applied_payment_schedule : ' || '-2');
1856: arp_util.debug( 'p_link_to_customer_trx_id : ' || p_customer_trx_id);
1857: arp_util.debug( 'p_receivables_trx_id : ' || l_receivables_trx_id);
1858: arp_util.debug( 'p_apply_date : ' || p_apply_date);
1859: arp_util.debug( 'p_apply_gl_date : ' || p_apply_gl_date);
1860: arp_util.debug( 'p_org_id : ' || to_char(l_cr_rec.org_id));
1861: arp_util.debug( '--------------------------------------------------------------');
1862: END IF;

Line 1859: arp_util.debug( 'p_apply_gl_date : ' || p_apply_gl_date);

1855: arp_util.debug( 'p_applied_payment_schedule : ' || '-2');
1856: arp_util.debug( 'p_link_to_customer_trx_id : ' || p_customer_trx_id);
1857: arp_util.debug( 'p_receivables_trx_id : ' || l_receivables_trx_id);
1858: arp_util.debug( 'p_apply_date : ' || p_apply_date);
1859: arp_util.debug( 'p_apply_gl_date : ' || p_apply_gl_date);
1860: arp_util.debug( 'p_org_id : ' || to_char(l_cr_rec.org_id));
1861: arp_util.debug( '--------------------------------------------------------------');
1862: END IF;
1863:

Line 1860: arp_util.debug( 'p_org_id : ' || to_char(l_cr_rec.org_id));

1856: arp_util.debug( 'p_link_to_customer_trx_id : ' || p_customer_trx_id);
1857: arp_util.debug( 'p_receivables_trx_id : ' || l_receivables_trx_id);
1858: arp_util.debug( 'p_apply_date : ' || p_apply_date);
1859: arp_util.debug( 'p_apply_gl_date : ' || p_apply_gl_date);
1860: arp_util.debug( 'p_org_id : ' || to_char(l_cr_rec.org_id));
1861: arp_util.debug( '--------------------------------------------------------------');
1862: END IF;
1863:
1864: ar_receipt_api_pub.activity_application(

Line 1861: arp_util.debug( '--------------------------------------------------------------');

1857: arp_util.debug( 'p_receivables_trx_id : ' || l_receivables_trx_id);
1858: arp_util.debug( 'p_apply_date : ' || p_apply_date);
1859: arp_util.debug( 'p_apply_gl_date : ' || p_apply_gl_date);
1860: arp_util.debug( 'p_org_id : ' || to_char(l_cr_rec.org_id));
1861: arp_util.debug( '--------------------------------------------------------------');
1862: END IF;
1863:
1864: ar_receipt_api_pub.activity_application(
1865: p_api_version => 1.0,

Line 1888: arp_util.debug( '>>>>>>>>>> Problems during SHORT TERM DEBT APPLICATION');

1884:
1885: IF (l_return_status <> 'S')
1886: THEN
1887: IF PG_DEBUG in ('Y', 'C') THEN
1888: arp_util.debug( '>>>>>>>>>> Problems during SHORT TERM DEBT APPLICATION');
1889: arp_util.debug( 'l_return_status : ' || l_return_status);
1890: arp_util.debug( 'l_msg_count : ' || l_msg_count);
1891: arp_util.debug( 'l_msg_data : ' || l_msg_data);
1892: END IF;

Line 1889: arp_util.debug( 'l_return_status : ' || l_return_status);

1885: IF (l_return_status <> 'S')
1886: THEN
1887: IF PG_DEBUG in ('Y', 'C') THEN
1888: arp_util.debug( '>>>>>>>>>> Problems during SHORT TERM DEBT APPLICATION');
1889: arp_util.debug( 'l_return_status : ' || l_return_status);
1890: arp_util.debug( 'l_msg_count : ' || l_msg_count);
1891: arp_util.debug( 'l_msg_data : ' || l_msg_data);
1892: END IF;
1893:

Line 1890: arp_util.debug( 'l_msg_count : ' || l_msg_count);

1886: THEN
1887: IF PG_DEBUG in ('Y', 'C') THEN
1888: arp_util.debug( '>>>>>>>>>> Problems during SHORT TERM DEBT APPLICATION');
1889: arp_util.debug( 'l_return_status : ' || l_return_status);
1890: arp_util.debug( 'l_msg_count : ' || l_msg_count);
1891: arp_util.debug( 'l_msg_data : ' || l_msg_data);
1892: END IF;
1893:
1894:

Line 1891: arp_util.debug( 'l_msg_data : ' || l_msg_data);

1887: IF PG_DEBUG in ('Y', 'C') THEN
1888: arp_util.debug( '>>>>>>>>>> Problems during SHORT TERM DEBT APPLICATION');
1889: arp_util.debug( 'l_return_status : ' || l_return_status);
1890: arp_util.debug( 'l_msg_count : ' || l_msg_count);
1891: arp_util.debug( 'l_msg_data : ' || l_msg_data);
1892: END IF;
1893:
1894:
1895: IF (l_msg_count > 0)

Line 1908: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Apply_STD ()-');

1904: END IF;
1905:
1906:
1907: IF PG_DEBUG in ('Y', 'C') THEN
1908: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Apply_STD ()-');
1909: END IF;
1910:
1911: EXCEPTION
1912: WHEN OTHERS THEN

Line 1914: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.Apply_STD : ' || SQLERRM);

1910:
1911: EXCEPTION
1912: WHEN OTHERS THEN
1913: IF PG_DEBUG in ('Y', 'C') THEN
1914: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.Apply_STD : ' || SQLERRM);
1915: END IF;
1916: RAISE;
1917:
1918: END Apply_STD;

Line 1951: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Unapply_STD ()+');

1947:
1948: BEGIN
1949:
1950: IF PG_DEBUG in ('Y', 'C') THEN
1951: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Unapply_STD ()+');
1952: END IF;
1953:
1954: /* SSA change */
1955: l_org_id := p_trh_rec.org_id;

Line 1962: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Unapply_STD : l_org_return_status <> SUCCESS');

1958: p_return_status =>l_org_return_status);
1959:
1960: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1961:
1962: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Unapply_STD : l_org_return_status <> SUCCESS');
1963: ELSE
1964:
1965: /*-----------------------------------------------+
1966: | Fetch last Short Term Debt Application |

Line 1977: arp_util.debug( '----------------------------------------------------------------');

1973: | Unapply from Short Term Debt using Receipt API |
1974: +------------------------------------------------*/
1975:
1976: IF PG_DEBUG in ('Y', 'C') THEN
1977: arp_util.debug( '----------------------------------------------------------------');
1978: arp_util.debug( 'PARAMETERS PASSED TO AR_RECEIPT_API_PUB.ACTIVITY_UNAPPLICATION : ');
1979: arp_util.debug( 'p_cash_receipt_id : ' || p_cash_receipt_id);
1980: arp_util.debug( 'p_receivable_application_id: ' || l_receivable_application_id);
1981: arp_util.debug( 'p_reversal_gl_date : ' || p_trh_rec.gl_date);

Line 1978: arp_util.debug( 'PARAMETERS PASSED TO AR_RECEIPT_API_PUB.ACTIVITY_UNAPPLICATION : ');

1974: +------------------------------------------------*/
1975:
1976: IF PG_DEBUG in ('Y', 'C') THEN
1977: arp_util.debug( '----------------------------------------------------------------');
1978: arp_util.debug( 'PARAMETERS PASSED TO AR_RECEIPT_API_PUB.ACTIVITY_UNAPPLICATION : ');
1979: arp_util.debug( 'p_cash_receipt_id : ' || p_cash_receipt_id);
1980: arp_util.debug( 'p_receivable_application_id: ' || l_receivable_application_id);
1981: arp_util.debug( 'p_reversal_gl_date : ' || p_trh_rec.gl_date);
1982: arp_util.debug( 'p_called_from : ' || p_called_from);

Line 1979: arp_util.debug( 'p_cash_receipt_id : ' || p_cash_receipt_id);

1975:
1976: IF PG_DEBUG in ('Y', 'C') THEN
1977: arp_util.debug( '----------------------------------------------------------------');
1978: arp_util.debug( 'PARAMETERS PASSED TO AR_RECEIPT_API_PUB.ACTIVITY_UNAPPLICATION : ');
1979: arp_util.debug( 'p_cash_receipt_id : ' || p_cash_receipt_id);
1980: arp_util.debug( 'p_receivable_application_id: ' || l_receivable_application_id);
1981: arp_util.debug( 'p_reversal_gl_date : ' || p_trh_rec.gl_date);
1982: arp_util.debug( 'p_called_from : ' || p_called_from);
1983: arp_util.debug( 'p_org_id : ' || to_char(p_trh_rec.org_id));

Line 1980: arp_util.debug( 'p_receivable_application_id: ' || l_receivable_application_id);

1976: IF PG_DEBUG in ('Y', 'C') THEN
1977: arp_util.debug( '----------------------------------------------------------------');
1978: arp_util.debug( 'PARAMETERS PASSED TO AR_RECEIPT_API_PUB.ACTIVITY_UNAPPLICATION : ');
1979: arp_util.debug( 'p_cash_receipt_id : ' || p_cash_receipt_id);
1980: arp_util.debug( 'p_receivable_application_id: ' || l_receivable_application_id);
1981: arp_util.debug( 'p_reversal_gl_date : ' || p_trh_rec.gl_date);
1982: arp_util.debug( 'p_called_from : ' || p_called_from);
1983: arp_util.debug( 'p_org_id : ' || to_char(p_trh_rec.org_id));
1984: arp_util.debug( '----------------------------------------------------------------');

Line 1981: arp_util.debug( 'p_reversal_gl_date : ' || p_trh_rec.gl_date);

1977: arp_util.debug( '----------------------------------------------------------------');
1978: arp_util.debug( 'PARAMETERS PASSED TO AR_RECEIPT_API_PUB.ACTIVITY_UNAPPLICATION : ');
1979: arp_util.debug( 'p_cash_receipt_id : ' || p_cash_receipt_id);
1980: arp_util.debug( 'p_receivable_application_id: ' || l_receivable_application_id);
1981: arp_util.debug( 'p_reversal_gl_date : ' || p_trh_rec.gl_date);
1982: arp_util.debug( 'p_called_from : ' || p_called_from);
1983: arp_util.debug( 'p_org_id : ' || to_char(p_trh_rec.org_id));
1984: arp_util.debug( '----------------------------------------------------------------');
1985: END IF;

Line 1982: arp_util.debug( 'p_called_from : ' || p_called_from);

1978: arp_util.debug( 'PARAMETERS PASSED TO AR_RECEIPT_API_PUB.ACTIVITY_UNAPPLICATION : ');
1979: arp_util.debug( 'p_cash_receipt_id : ' || p_cash_receipt_id);
1980: arp_util.debug( 'p_receivable_application_id: ' || l_receivable_application_id);
1981: arp_util.debug( 'p_reversal_gl_date : ' || p_trh_rec.gl_date);
1982: arp_util.debug( 'p_called_from : ' || p_called_from);
1983: arp_util.debug( 'p_org_id : ' || to_char(p_trh_rec.org_id));
1984: arp_util.debug( '----------------------------------------------------------------');
1985: END IF;
1986:

Line 1983: arp_util.debug( 'p_org_id : ' || to_char(p_trh_rec.org_id));

1979: arp_util.debug( 'p_cash_receipt_id : ' || p_cash_receipt_id);
1980: arp_util.debug( 'p_receivable_application_id: ' || l_receivable_application_id);
1981: arp_util.debug( 'p_reversal_gl_date : ' || p_trh_rec.gl_date);
1982: arp_util.debug( 'p_called_from : ' || p_called_from);
1983: arp_util.debug( 'p_org_id : ' || to_char(p_trh_rec.org_id));
1984: arp_util.debug( '----------------------------------------------------------------');
1985: END IF;
1986:
1987: AR_RECEIPT_API_PUB.Activity_Unapplication(

Line 1984: arp_util.debug( '----------------------------------------------------------------');

1980: arp_util.debug( 'p_receivable_application_id: ' || l_receivable_application_id);
1981: arp_util.debug( 'p_reversal_gl_date : ' || p_trh_rec.gl_date);
1982: arp_util.debug( 'p_called_from : ' || p_called_from);
1983: arp_util.debug( 'p_org_id : ' || to_char(p_trh_rec.org_id));
1984: arp_util.debug( '----------------------------------------------------------------');
1985: END IF;
1986:
1987: AR_RECEIPT_API_PUB.Activity_Unapplication(
1988: p_api_version => 1.0 ,

Line 2003: arp_util.debug( '>>>>>>>>>> Problems during SHORT TERM DEBT UNAPPLICATION');

1999:
2000: IF (l_return_status <> 'S')
2001: THEN
2002: IF PG_DEBUG in ('Y', 'C') THEN
2003: arp_util.debug( '>>>>>>>>>> Problems during SHORT TERM DEBT UNAPPLICATION');
2004: arp_util.debug( 'l_return_status : ' || l_return_status);
2005: arp_util.debug( 'l_msg_count : ' || l_msg_count);
2006: arp_util.debug( 'l_msg_data : ' || l_msg_data);
2007: END IF;

Line 2004: arp_util.debug( 'l_return_status : ' || l_return_status);

2000: IF (l_return_status <> 'S')
2001: THEN
2002: IF PG_DEBUG in ('Y', 'C') THEN
2003: arp_util.debug( '>>>>>>>>>> Problems during SHORT TERM DEBT UNAPPLICATION');
2004: arp_util.debug( 'l_return_status : ' || l_return_status);
2005: arp_util.debug( 'l_msg_count : ' || l_msg_count);
2006: arp_util.debug( 'l_msg_data : ' || l_msg_data);
2007: END IF;
2008:

Line 2005: arp_util.debug( 'l_msg_count : ' || l_msg_count);

2001: THEN
2002: IF PG_DEBUG in ('Y', 'C') THEN
2003: arp_util.debug( '>>>>>>>>>> Problems during SHORT TERM DEBT UNAPPLICATION');
2004: arp_util.debug( 'l_return_status : ' || l_return_status);
2005: arp_util.debug( 'l_msg_count : ' || l_msg_count);
2006: arp_util.debug( 'l_msg_data : ' || l_msg_data);
2007: END IF;
2008:
2009:

Line 2006: arp_util.debug( 'l_msg_data : ' || l_msg_data);

2002: IF PG_DEBUG in ('Y', 'C') THEN
2003: arp_util.debug( '>>>>>>>>>> Problems during SHORT TERM DEBT UNAPPLICATION');
2004: arp_util.debug( 'l_return_status : ' || l_return_status);
2005: arp_util.debug( 'l_msg_count : ' || l_msg_count);
2006: arp_util.debug( 'l_msg_data : ' || l_msg_data);
2007: END IF;
2008:
2009:
2010: IF (l_msg_count > 0)

Line 2022: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Unapply_STD ()-');

2018: END IF;
2019: END IF;
2020:
2021: IF PG_DEBUG in ('Y', 'C') THEN
2022: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Unapply_STD ()-');
2023: END IF;
2024:
2025: EXCEPTION
2026: WHEN OTHERS THEN

Line 2028: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.Unapply_STD : ' || SQLERRM);

2024:
2025: EXCEPTION
2026: WHEN OTHERS THEN
2027: IF PG_DEBUG in ('Y', 'C') THEN
2028: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.Unapply_STD : ' || SQLERRM);
2029: END IF;
2030: RAISE;
2031:
2032: END Unapply_STD;

Line 2061: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Unpaid ()+');

2057:
2058: BEGIN
2059:
2060: IF PG_DEBUG in ('Y', 'C') THEN
2061: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Unpaid ()+');
2062: END IF;
2063:
2064: -- Fetch the remittance method if it exists
2065:

Line 2094: arp_util.debug ( 'Previous Relevant Status : ' || l_prev_trh_rec.status);

2090:
2091: AR_BILLS_MAINTAIN_STATUS_PUB.Find_Last_Relevant_trh (l_prev_trh_rec);
2092:
2093: IF PG_DEBUG in ('Y', 'C') THEN
2094: arp_util.debug ( 'Previous Relevant Status : ' || l_prev_trh_rec.status);
2095: END IF;
2096:
2097:
2098:

Line 2199: arp_util.debug( '>>>>>>>>>> Invalid Action - Case not implemented ');

2195: p_trh_rec.current_accounted_flag:= 'Y';
2196:
2197: ELSE
2198: IF PG_DEBUG in ('Y', 'C') THEN
2199: arp_util.debug( '>>>>>>>>>> Invalid Action - Case not implemented ');
2200: END IF;
2201: FND_MESSAGE.set_name ( 'AR', 'AR_BR_ACTION_FORBIDDEN' );
2202: FND_MESSAGE.Set_token ( 'ACTION', C_UNPAID);
2203: app_exception.raise_exception;

Line 2209: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Unpaid ()-');

2205: END IF;
2206:
2207:
2208: IF PG_DEBUG in ('Y', 'C') THEN
2209: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Unpaid ()-');
2210: END IF;
2211:
2212: EXCEPTION
2213: WHEN OTHERS THEN

Line 2215: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.Unpaid () ');

2211:
2212: EXCEPTION
2213: WHEN OTHERS THEN
2214: IF PG_DEBUG in ('Y', 'C') THEN
2215: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.Unpaid () ');
2216: END IF;
2217: RAISE;
2218:
2219: END Unpaid;

Line 2257: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Factore_Recourse ()+');

2253:
2254: BEGIN
2255:
2256: IF PG_DEBUG in ('Y', 'C') THEN
2257: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Factore_Recourse ()+');
2258: END IF;
2259:
2260:
2261: /* SSA change */

Line 2269: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Factore_Recourse : l_org_return_status <> SUCCESS');

2265: p_return_status =>l_org_return_status);
2266:
2267: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2268:
2269: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Factore_Recourse : l_org_return_status <> SUCCESS');
2270: ELSE
2271:
2272: /*-----------------------------------------------+
2273: | Check if the receipt number is inherited |

Line 2284: arp_util.debug ( 'Receipt_inherit_inv_num_flag : ' || l_receipt_inherit_inv_num_flag);

2280: FROM AR_RECEIPT_METHODS
2281: WHERE receipt_method_id = p_batch_rec.receipt_method_id;
2282:
2283: IF PG_DEBUG in ('Y', 'C') THEN
2284: arp_util.debug ( 'Receipt_inherit_inv_num_flag : ' || l_receipt_inherit_inv_num_flag);
2285: END IF;
2286:
2287: IF (l_receipt_inherit_inv_num_flag = 'Y')
2288: THEN

Line 2307: arp_util.debug( '----------------------------------------------------------------');

2303: l_exch_rate := p_ps_rec.exchange_rate;
2304: end if;
2305:
2306: IF PG_DEBUG in ('Y', 'C') THEN
2307: arp_util.debug( '----------------------------------------------------------------');
2308: arp_util.debug( 'PARAMETERS PASSED TO AR_RECEIPT_API_PUB.CREATE_CASH : ');
2309: arp_util.debug('p_currency_code : ' || p_ps_rec.invoice_currency_code);
2310: arp_util.debug('p_exchange_rate_type : ' || p_ps_rec.exchange_rate_type);
2311: arp_util.debug('p_exchange_rate : ' || l_exch_rate);

Line 2308: arp_util.debug( 'PARAMETERS PASSED TO AR_RECEIPT_API_PUB.CREATE_CASH : ');

2304: end if;
2305:
2306: IF PG_DEBUG in ('Y', 'C') THEN
2307: arp_util.debug( '----------------------------------------------------------------');
2308: arp_util.debug( 'PARAMETERS PASSED TO AR_RECEIPT_API_PUB.CREATE_CASH : ');
2309: arp_util.debug('p_currency_code : ' || p_ps_rec.invoice_currency_code);
2310: arp_util.debug('p_exchange_rate_type : ' || p_ps_rec.exchange_rate_type);
2311: arp_util.debug('p_exchange_rate : ' || l_exch_rate);
2312: arp_util.debug('p_exchange_rate_date : ' || p_ps_rec.exchange_date);

Line 2309: arp_util.debug('p_currency_code : ' || p_ps_rec.invoice_currency_code);

2305:
2306: IF PG_DEBUG in ('Y', 'C') THEN
2307: arp_util.debug( '----------------------------------------------------------------');
2308: arp_util.debug( 'PARAMETERS PASSED TO AR_RECEIPT_API_PUB.CREATE_CASH : ');
2309: arp_util.debug('p_currency_code : ' || p_ps_rec.invoice_currency_code);
2310: arp_util.debug('p_exchange_rate_type : ' || p_ps_rec.exchange_rate_type);
2311: arp_util.debug('p_exchange_rate : ' || l_exch_rate);
2312: arp_util.debug('p_exchange_rate_date : ' || p_ps_rec.exchange_date);
2313: arp_util.debug('p_remittance_bank_account_id : ' || p_batch_rec.remit_bank_acct_use_id);

Line 2310: arp_util.debug('p_exchange_rate_type : ' || p_ps_rec.exchange_rate_type);

2306: IF PG_DEBUG in ('Y', 'C') THEN
2307: arp_util.debug( '----------------------------------------------------------------');
2308: arp_util.debug( 'PARAMETERS PASSED TO AR_RECEIPT_API_PUB.CREATE_CASH : ');
2309: arp_util.debug('p_currency_code : ' || p_ps_rec.invoice_currency_code);
2310: arp_util.debug('p_exchange_rate_type : ' || p_ps_rec.exchange_rate_type);
2311: arp_util.debug('p_exchange_rate : ' || l_exch_rate);
2312: arp_util.debug('p_exchange_rate_date : ' || p_ps_rec.exchange_date);
2313: arp_util.debug('p_remittance_bank_account_id : ' || p_batch_rec.remit_bank_acct_use_id);
2314: arp_util.debug('p_amount : ' || p_ps_rec.amount_due_original);

Line 2311: arp_util.debug('p_exchange_rate : ' || l_exch_rate);

2307: arp_util.debug( '----------------------------------------------------------------');
2308: arp_util.debug( 'PARAMETERS PASSED TO AR_RECEIPT_API_PUB.CREATE_CASH : ');
2309: arp_util.debug('p_currency_code : ' || p_ps_rec.invoice_currency_code);
2310: arp_util.debug('p_exchange_rate_type : ' || p_ps_rec.exchange_rate_type);
2311: arp_util.debug('p_exchange_rate : ' || l_exch_rate);
2312: arp_util.debug('p_exchange_rate_date : ' || p_ps_rec.exchange_date);
2313: arp_util.debug('p_remittance_bank_account_id : ' || p_batch_rec.remit_bank_acct_use_id);
2314: arp_util.debug('p_amount : ' || p_ps_rec.amount_due_original);
2315: arp_util.debug('p_receipt_method_id : ' || p_batch_rec.receipt_method_id);

Line 2312: arp_util.debug('p_exchange_rate_date : ' || p_ps_rec.exchange_date);

2308: arp_util.debug( 'PARAMETERS PASSED TO AR_RECEIPT_API_PUB.CREATE_CASH : ');
2309: arp_util.debug('p_currency_code : ' || p_ps_rec.invoice_currency_code);
2310: arp_util.debug('p_exchange_rate_type : ' || p_ps_rec.exchange_rate_type);
2311: arp_util.debug('p_exchange_rate : ' || l_exch_rate);
2312: arp_util.debug('p_exchange_rate_date : ' || p_ps_rec.exchange_date);
2313: arp_util.debug('p_remittance_bank_account_id : ' || p_batch_rec.remit_bank_acct_use_id);
2314: arp_util.debug('p_amount : ' || p_ps_rec.amount_due_original);
2315: arp_util.debug('p_receipt_method_id : ' || p_batch_rec.receipt_method_id);
2316: arp_util.debug('p_receipt_number : ' || l_receipt_number);

Line 2313: arp_util.debug('p_remittance_bank_account_id : ' || p_batch_rec.remit_bank_acct_use_id);

2309: arp_util.debug('p_currency_code : ' || p_ps_rec.invoice_currency_code);
2310: arp_util.debug('p_exchange_rate_type : ' || p_ps_rec.exchange_rate_type);
2311: arp_util.debug('p_exchange_rate : ' || l_exch_rate);
2312: arp_util.debug('p_exchange_rate_date : ' || p_ps_rec.exchange_date);
2313: arp_util.debug('p_remittance_bank_account_id : ' || p_batch_rec.remit_bank_acct_use_id);
2314: arp_util.debug('p_amount : ' || p_ps_rec.amount_due_original);
2315: arp_util.debug('p_receipt_method_id : ' || p_batch_rec.receipt_method_id);
2316: arp_util.debug('p_receipt_number : ' || l_receipt_number);
2317: arp_util.debug('p_customer_id : ' || p_ps_rec.customer_id);

Line 2314: arp_util.debug('p_amount : ' || p_ps_rec.amount_due_original);

2310: arp_util.debug('p_exchange_rate_type : ' || p_ps_rec.exchange_rate_type);
2311: arp_util.debug('p_exchange_rate : ' || l_exch_rate);
2312: arp_util.debug('p_exchange_rate_date : ' || p_ps_rec.exchange_date);
2313: arp_util.debug('p_remittance_bank_account_id : ' || p_batch_rec.remit_bank_acct_use_id);
2314: arp_util.debug('p_amount : ' || p_ps_rec.amount_due_original);
2315: arp_util.debug('p_receipt_method_id : ' || p_batch_rec.receipt_method_id);
2316: arp_util.debug('p_receipt_number : ' || l_receipt_number);
2317: arp_util.debug('p_customer_id : ' || p_ps_rec.customer_id);
2318: arp_util.debug('p_called_from : ' || l_called_from);

Line 2315: arp_util.debug('p_receipt_method_id : ' || p_batch_rec.receipt_method_id);

2311: arp_util.debug('p_exchange_rate : ' || l_exch_rate);
2312: arp_util.debug('p_exchange_rate_date : ' || p_ps_rec.exchange_date);
2313: arp_util.debug('p_remittance_bank_account_id : ' || p_batch_rec.remit_bank_acct_use_id);
2314: arp_util.debug('p_amount : ' || p_ps_rec.amount_due_original);
2315: arp_util.debug('p_receipt_method_id : ' || p_batch_rec.receipt_method_id);
2316: arp_util.debug('p_receipt_number : ' || l_receipt_number);
2317: arp_util.debug('p_customer_id : ' || p_ps_rec.customer_id);
2318: arp_util.debug('p_called_from : ' || l_called_from);
2319: arp_util.debug('p_receipt_date : ' || p_batch_rec.batch_date);

Line 2316: arp_util.debug('p_receipt_number : ' || l_receipt_number);

2312: arp_util.debug('p_exchange_rate_date : ' || p_ps_rec.exchange_date);
2313: arp_util.debug('p_remittance_bank_account_id : ' || p_batch_rec.remit_bank_acct_use_id);
2314: arp_util.debug('p_amount : ' || p_ps_rec.amount_due_original);
2315: arp_util.debug('p_receipt_method_id : ' || p_batch_rec.receipt_method_id);
2316: arp_util.debug('p_receipt_number : ' || l_receipt_number);
2317: arp_util.debug('p_customer_id : ' || p_ps_rec.customer_id);
2318: arp_util.debug('p_called_from : ' || l_called_from);
2319: arp_util.debug('p_receipt_date : ' || p_batch_rec.batch_date);
2320: arp_util.debug('p_gl_date : ' || p_batch_rec.gl_date);

Line 2317: arp_util.debug('p_customer_id : ' || p_ps_rec.customer_id);

2313: arp_util.debug('p_remittance_bank_account_id : ' || p_batch_rec.remit_bank_acct_use_id);
2314: arp_util.debug('p_amount : ' || p_ps_rec.amount_due_original);
2315: arp_util.debug('p_receipt_method_id : ' || p_batch_rec.receipt_method_id);
2316: arp_util.debug('p_receipt_number : ' || l_receipt_number);
2317: arp_util.debug('p_customer_id : ' || p_ps_rec.customer_id);
2318: arp_util.debug('p_called_from : ' || l_called_from);
2319: arp_util.debug('p_receipt_date : ' || p_batch_rec.batch_date);
2320: arp_util.debug('p_gl_date : ' || p_batch_rec.gl_date);
2321: arp_util.debug('p_cr_id : ' || l_cr_id);

Line 2318: arp_util.debug('p_called_from : ' || l_called_from);

2314: arp_util.debug('p_amount : ' || p_ps_rec.amount_due_original);
2315: arp_util.debug('p_receipt_method_id : ' || p_batch_rec.receipt_method_id);
2316: arp_util.debug('p_receipt_number : ' || l_receipt_number);
2317: arp_util.debug('p_customer_id : ' || p_ps_rec.customer_id);
2318: arp_util.debug('p_called_from : ' || l_called_from);
2319: arp_util.debug('p_receipt_date : ' || p_batch_rec.batch_date);
2320: arp_util.debug('p_gl_date : ' || p_batch_rec.gl_date);
2321: arp_util.debug('p_cr_id : ' || l_cr_id);
2322: arp_util.debug('p_org_id : ' || p_ps_rec.org_id);

Line 2319: arp_util.debug('p_receipt_date : ' || p_batch_rec.batch_date);

2315: arp_util.debug('p_receipt_method_id : ' || p_batch_rec.receipt_method_id);
2316: arp_util.debug('p_receipt_number : ' || l_receipt_number);
2317: arp_util.debug('p_customer_id : ' || p_ps_rec.customer_id);
2318: arp_util.debug('p_called_from : ' || l_called_from);
2319: arp_util.debug('p_receipt_date : ' || p_batch_rec.batch_date);
2320: arp_util.debug('p_gl_date : ' || p_batch_rec.gl_date);
2321: arp_util.debug('p_cr_id : ' || l_cr_id);
2322: arp_util.debug('p_org_id : ' || p_ps_rec.org_id);
2323: arp_util.debug('----------------------------------------------------------------');

Line 2320: arp_util.debug('p_gl_date : ' || p_batch_rec.gl_date);

2316: arp_util.debug('p_receipt_number : ' || l_receipt_number);
2317: arp_util.debug('p_customer_id : ' || p_ps_rec.customer_id);
2318: arp_util.debug('p_called_from : ' || l_called_from);
2319: arp_util.debug('p_receipt_date : ' || p_batch_rec.batch_date);
2320: arp_util.debug('p_gl_date : ' || p_batch_rec.gl_date);
2321: arp_util.debug('p_cr_id : ' || l_cr_id);
2322: arp_util.debug('p_org_id : ' || p_ps_rec.org_id);
2323: arp_util.debug('----------------------------------------------------------------');
2324: END IF;

Line 2321: arp_util.debug('p_cr_id : ' || l_cr_id);

2317: arp_util.debug('p_customer_id : ' || p_ps_rec.customer_id);
2318: arp_util.debug('p_called_from : ' || l_called_from);
2319: arp_util.debug('p_receipt_date : ' || p_batch_rec.batch_date);
2320: arp_util.debug('p_gl_date : ' || p_batch_rec.gl_date);
2321: arp_util.debug('p_cr_id : ' || l_cr_id);
2322: arp_util.debug('p_org_id : ' || p_ps_rec.org_id);
2323: arp_util.debug('----------------------------------------------------------------');
2324: END IF;
2325:

Line 2322: arp_util.debug('p_org_id : ' || p_ps_rec.org_id);

2318: arp_util.debug('p_called_from : ' || l_called_from);
2319: arp_util.debug('p_receipt_date : ' || p_batch_rec.batch_date);
2320: arp_util.debug('p_gl_date : ' || p_batch_rec.gl_date);
2321: arp_util.debug('p_cr_id : ' || l_cr_id);
2322: arp_util.debug('p_org_id : ' || p_ps_rec.org_id);
2323: arp_util.debug('----------------------------------------------------------------');
2324: END IF;
2325:
2326: ar_receipt_api_pub.create_cash(

Line 2323: arp_util.debug('----------------------------------------------------------------');

2319: arp_util.debug('p_receipt_date : ' || p_batch_rec.batch_date);
2320: arp_util.debug('p_gl_date : ' || p_batch_rec.gl_date);
2321: arp_util.debug('p_cr_id : ' || l_cr_id);
2322: arp_util.debug('p_org_id : ' || p_ps_rec.org_id);
2323: arp_util.debug('----------------------------------------------------------------');
2324: END IF;
2325:
2326: ar_receipt_api_pub.create_cash(
2327: p_api_version => 1.0 ,

Line 2349: arp_util.debug( 'Cash Receipt Id created : ' || l_cr_id);

2345: p_org_id => p_ps_rec.org_id);
2346:
2347:
2348: IF PG_DEBUG in ('Y', 'C') THEN
2349: arp_util.debug( 'Cash Receipt Id created : ' || l_cr_id);
2350: arp_util.debug( 'Return status : ' || l_return_status);
2351: END IF;
2352:
2353: IF (l_return_status <> 'S')

Line 2350: arp_util.debug( 'Return status : ' || l_return_status);

2346:
2347:
2348: IF PG_DEBUG in ('Y', 'C') THEN
2349: arp_util.debug( 'Cash Receipt Id created : ' || l_cr_id);
2350: arp_util.debug( 'Return status : ' || l_return_status);
2351: END IF;
2352:
2353: IF (l_return_status <> 'S')
2354: THEN

Line 2356: arp_util.debug( '>>>>>>>>>> Problems during receipt creation');

2352:
2353: IF (l_return_status <> 'S')
2354: THEN
2355: IF PG_DEBUG in ('Y', 'C') THEN
2356: arp_util.debug( '>>>>>>>>>> Problems during receipt creation');
2357: arp_util.debug( 'l_return_status : ' || l_return_status);
2358: arp_util.debug( 'l_msg_count : ' || l_msg_count);
2359: arp_util.debug( 'l_msg_data : ' || l_msg_data);
2360: END IF;

Line 2357: arp_util.debug( 'l_return_status : ' || l_return_status);

2353: IF (l_return_status <> 'S')
2354: THEN
2355: IF PG_DEBUG in ('Y', 'C') THEN
2356: arp_util.debug( '>>>>>>>>>> Problems during receipt creation');
2357: arp_util.debug( 'l_return_status : ' || l_return_status);
2358: arp_util.debug( 'l_msg_count : ' || l_msg_count);
2359: arp_util.debug( 'l_msg_data : ' || l_msg_data);
2360: END IF;
2361:

Line 2358: arp_util.debug( 'l_msg_count : ' || l_msg_count);

2354: THEN
2355: IF PG_DEBUG in ('Y', 'C') THEN
2356: arp_util.debug( '>>>>>>>>>> Problems during receipt creation');
2357: arp_util.debug( 'l_return_status : ' || l_return_status);
2358: arp_util.debug( 'l_msg_count : ' || l_msg_count);
2359: arp_util.debug( 'l_msg_data : ' || l_msg_data);
2360: END IF;
2361:
2362:

Line 2359: arp_util.debug( 'l_msg_data : ' || l_msg_data);

2355: IF PG_DEBUG in ('Y', 'C') THEN
2356: arp_util.debug( '>>>>>>>>>> Problems during receipt creation');
2357: arp_util.debug( 'l_return_status : ' || l_return_status);
2358: arp_util.debug( 'l_msg_count : ' || l_msg_count);
2359: arp_util.debug( 'l_msg_data : ' || l_msg_data);
2360: END IF;
2361:
2362:
2363: IF (l_msg_count > 0)

Line 2392: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Factore_Recourse ()-');

2388:
2389: END IF;
2390:
2391: IF PG_DEBUG in ('Y', 'C') THEN
2392: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Factore_Recourse ()-');
2393: END IF;
2394:
2395: EXCEPTION
2396: WHEN OTHERS THEN

Line 2398: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.Factore_Recourse : ' || SQLERRM);

2394:
2395: EXCEPTION
2396: WHEN OTHERS THEN
2397: IF PG_DEBUG in ('Y', 'C') THEN
2398: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.Factore_Recourse : ' || SQLERRM);
2399: END IF;
2400: RAISE;
2401:
2402: END Factore_Recourse;

Line 2435: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Factore_Without_Recourse ()+');

2431:
2432: BEGIN
2433:
2434: IF PG_DEBUG in ('Y', 'C') THEN
2435: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Factore_Without_Recourse ()+');
2436: END IF;
2437:
2438: /* SSA change */
2439: l_org_id := p_ps_rec.org_id;

Line 2446: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Factore_Without_Recourse : l_org_return_status <> SUCCESS');

2442: p_return_status =>l_org_return_status);
2443:
2444: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2445:
2446: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Factore_Without_Recourse : l_org_return_status <> SUCCESS');
2447: ELSE
2448:
2449: /*-----------------------------------------------+
2450: | Check if the receipt number is inherited |

Line 2461: arp_util.debug ( 'Receipt_inherit_inv_num_flag : ' || l_receipt_inherit_inv_num_flag);

2457: FROM AR_RECEIPT_METHODS
2458: WHERE receipt_method_id = p_batch_rec.receipt_method_id;
2459:
2460: IF PG_DEBUG in ('Y', 'C') THEN
2461: arp_util.debug ( 'Receipt_inherit_inv_num_flag : ' || l_receipt_inherit_inv_num_flag);
2462: END IF;
2463:
2464: IF (l_receipt_inherit_inv_num_flag = 'Y')
2465: THEN

Line 2471: arp_util.debug( '----------------------------------------------------------------');

2467: END IF;
2468:
2469:
2470: IF PG_DEBUG in ('Y', 'C') THEN
2471: arp_util.debug( '----------------------------------------------------------------');
2472: arp_util.debug( 'PARAMETERS PASSED TO AR_RECEIPT_API_PUB.CREATE_AND_APPLY : ');
2473: arp_util.debug( 'p_applied_payment_schedule_id : ' || p_ps_rec.payment_schedule_id );
2474: arp_util.debug( 'p_amount : ' || p_ps_rec.amount_due_remaining);
2475: arp_util.debug( 'p_currency_code : ' || p_ps_rec.invoice_currency_code);

Line 2472: arp_util.debug( 'PARAMETERS PASSED TO AR_RECEIPT_API_PUB.CREATE_AND_APPLY : ');

2468:
2469:
2470: IF PG_DEBUG in ('Y', 'C') THEN
2471: arp_util.debug( '----------------------------------------------------------------');
2472: arp_util.debug( 'PARAMETERS PASSED TO AR_RECEIPT_API_PUB.CREATE_AND_APPLY : ');
2473: arp_util.debug( 'p_applied_payment_schedule_id : ' || p_ps_rec.payment_schedule_id );
2474: arp_util.debug( 'p_amount : ' || p_ps_rec.amount_due_remaining);
2475: arp_util.debug( 'p_currency_code : ' || p_ps_rec.invoice_currency_code);
2476: arp_util.debug( 'p_exchange_rate : ' || p_ps_rec.exchange_rate);

Line 2473: arp_util.debug( 'p_applied_payment_schedule_id : ' || p_ps_rec.payment_schedule_id );

2469:
2470: IF PG_DEBUG in ('Y', 'C') THEN
2471: arp_util.debug( '----------------------------------------------------------------');
2472: arp_util.debug( 'PARAMETERS PASSED TO AR_RECEIPT_API_PUB.CREATE_AND_APPLY : ');
2473: arp_util.debug( 'p_applied_payment_schedule_id : ' || p_ps_rec.payment_schedule_id );
2474: arp_util.debug( 'p_amount : ' || p_ps_rec.amount_due_remaining);
2475: arp_util.debug( 'p_currency_code : ' || p_ps_rec.invoice_currency_code);
2476: arp_util.debug( 'p_exchange_rate : ' || p_ps_rec.exchange_rate);
2477: arp_util.debug( 'p_receipt_number : ' || l_receipt_number);

Line 2474: arp_util.debug( 'p_amount : ' || p_ps_rec.amount_due_remaining);

2470: IF PG_DEBUG in ('Y', 'C') THEN
2471: arp_util.debug( '----------------------------------------------------------------');
2472: arp_util.debug( 'PARAMETERS PASSED TO AR_RECEIPT_API_PUB.CREATE_AND_APPLY : ');
2473: arp_util.debug( 'p_applied_payment_schedule_id : ' || p_ps_rec.payment_schedule_id );
2474: arp_util.debug( 'p_amount : ' || p_ps_rec.amount_due_remaining);
2475: arp_util.debug( 'p_currency_code : ' || p_ps_rec.invoice_currency_code);
2476: arp_util.debug( 'p_exchange_rate : ' || p_ps_rec.exchange_rate);
2477: arp_util.debug( 'p_receipt_number : ' || l_receipt_number);
2478: arp_util.debug( 'p_receipt_method_id : ' || p_batch_rec.receipt_method_id);

Line 2475: arp_util.debug( 'p_currency_code : ' || p_ps_rec.invoice_currency_code);

2471: arp_util.debug( '----------------------------------------------------------------');
2472: arp_util.debug( 'PARAMETERS PASSED TO AR_RECEIPT_API_PUB.CREATE_AND_APPLY : ');
2473: arp_util.debug( 'p_applied_payment_schedule_id : ' || p_ps_rec.payment_schedule_id );
2474: arp_util.debug( 'p_amount : ' || p_ps_rec.amount_due_remaining);
2475: arp_util.debug( 'p_currency_code : ' || p_ps_rec.invoice_currency_code);
2476: arp_util.debug( 'p_exchange_rate : ' || p_ps_rec.exchange_rate);
2477: arp_util.debug( 'p_receipt_number : ' || l_receipt_number);
2478: arp_util.debug( 'p_receipt_method_id : ' || p_batch_rec.receipt_method_id);
2479: arp_util.debug( 'p_customer_id : ' || p_ps_rec.customer_id);

Line 2476: arp_util.debug( 'p_exchange_rate : ' || p_ps_rec.exchange_rate);

2472: arp_util.debug( 'PARAMETERS PASSED TO AR_RECEIPT_API_PUB.CREATE_AND_APPLY : ');
2473: arp_util.debug( 'p_applied_payment_schedule_id : ' || p_ps_rec.payment_schedule_id );
2474: arp_util.debug( 'p_amount : ' || p_ps_rec.amount_due_remaining);
2475: arp_util.debug( 'p_currency_code : ' || p_ps_rec.invoice_currency_code);
2476: arp_util.debug( 'p_exchange_rate : ' || p_ps_rec.exchange_rate);
2477: arp_util.debug( 'p_receipt_number : ' || l_receipt_number);
2478: arp_util.debug( 'p_receipt_method_id : ' || p_batch_rec.receipt_method_id);
2479: arp_util.debug( 'p_customer_id : ' || p_ps_rec.customer_id);
2480: arp_util.debug( 'remit bank account use id : ' || p_batch_rec.remit_bank_acct_use_id);

Line 2477: arp_util.debug( 'p_receipt_number : ' || l_receipt_number);

2473: arp_util.debug( 'p_applied_payment_schedule_id : ' || p_ps_rec.payment_schedule_id );
2474: arp_util.debug( 'p_amount : ' || p_ps_rec.amount_due_remaining);
2475: arp_util.debug( 'p_currency_code : ' || p_ps_rec.invoice_currency_code);
2476: arp_util.debug( 'p_exchange_rate : ' || p_ps_rec.exchange_rate);
2477: arp_util.debug( 'p_receipt_number : ' || l_receipt_number);
2478: arp_util.debug( 'p_receipt_method_id : ' || p_batch_rec.receipt_method_id);
2479: arp_util.debug( 'p_customer_id : ' || p_ps_rec.customer_id);
2480: arp_util.debug( 'remit bank account use id : ' || p_batch_rec.remit_bank_acct_use_id);
2481: arp_util.debug( 'p_called_from : ' || C_BR_FACTORED);

Line 2478: arp_util.debug( 'p_receipt_method_id : ' || p_batch_rec.receipt_method_id);

2474: arp_util.debug( 'p_amount : ' || p_ps_rec.amount_due_remaining);
2475: arp_util.debug( 'p_currency_code : ' || p_ps_rec.invoice_currency_code);
2476: arp_util.debug( 'p_exchange_rate : ' || p_ps_rec.exchange_rate);
2477: arp_util.debug( 'p_receipt_number : ' || l_receipt_number);
2478: arp_util.debug( 'p_receipt_method_id : ' || p_batch_rec.receipt_method_id);
2479: arp_util.debug( 'p_customer_id : ' || p_ps_rec.customer_id);
2480: arp_util.debug( 'remit bank account use id : ' || p_batch_rec.remit_bank_acct_use_id);
2481: arp_util.debug( 'p_called_from : ' || C_BR_FACTORED);
2482: arp_util.debug( 'p_link_to_trx_hist_id : ' || NULL);

Line 2479: arp_util.debug( 'p_customer_id : ' || p_ps_rec.customer_id);

2475: arp_util.debug( 'p_currency_code : ' || p_ps_rec.invoice_currency_code);
2476: arp_util.debug( 'p_exchange_rate : ' || p_ps_rec.exchange_rate);
2477: arp_util.debug( 'p_receipt_number : ' || l_receipt_number);
2478: arp_util.debug( 'p_receipt_method_id : ' || p_batch_rec.receipt_method_id);
2479: arp_util.debug( 'p_customer_id : ' || p_ps_rec.customer_id);
2480: arp_util.debug( 'remit bank account use id : ' || p_batch_rec.remit_bank_acct_use_id);
2481: arp_util.debug( 'p_called_from : ' || C_BR_FACTORED);
2482: arp_util.debug( 'p_link_to_trx_hist_id : ' || NULL);
2483: arp_util.debug( 'p_org_id : ' || to_char(p_ps_rec.org_id));

Line 2480: arp_util.debug( 'remit bank account use id : ' || p_batch_rec.remit_bank_acct_use_id);

2476: arp_util.debug( 'p_exchange_rate : ' || p_ps_rec.exchange_rate);
2477: arp_util.debug( 'p_receipt_number : ' || l_receipt_number);
2478: arp_util.debug( 'p_receipt_method_id : ' || p_batch_rec.receipt_method_id);
2479: arp_util.debug( 'p_customer_id : ' || p_ps_rec.customer_id);
2480: arp_util.debug( 'remit bank account use id : ' || p_batch_rec.remit_bank_acct_use_id);
2481: arp_util.debug( 'p_called_from : ' || C_BR_FACTORED);
2482: arp_util.debug( 'p_link_to_trx_hist_id : ' || NULL);
2483: arp_util.debug( 'p_org_id : ' || to_char(p_ps_rec.org_id));
2484: arp_util.debug( '----------------------------------------------------------------');

Line 2481: arp_util.debug( 'p_called_from : ' || C_BR_FACTORED);

2477: arp_util.debug( 'p_receipt_number : ' || l_receipt_number);
2478: arp_util.debug( 'p_receipt_method_id : ' || p_batch_rec.receipt_method_id);
2479: arp_util.debug( 'p_customer_id : ' || p_ps_rec.customer_id);
2480: arp_util.debug( 'remit bank account use id : ' || p_batch_rec.remit_bank_acct_use_id);
2481: arp_util.debug( 'p_called_from : ' || C_BR_FACTORED);
2482: arp_util.debug( 'p_link_to_trx_hist_id : ' || NULL);
2483: arp_util.debug( 'p_org_id : ' || to_char(p_ps_rec.org_id));
2484: arp_util.debug( '----------------------------------------------------------------');
2485: END IF;

Line 2482: arp_util.debug( 'p_link_to_trx_hist_id : ' || NULL);

2478: arp_util.debug( 'p_receipt_method_id : ' || p_batch_rec.receipt_method_id);
2479: arp_util.debug( 'p_customer_id : ' || p_ps_rec.customer_id);
2480: arp_util.debug( 'remit bank account use id : ' || p_batch_rec.remit_bank_acct_use_id);
2481: arp_util.debug( 'p_called_from : ' || C_BR_FACTORED);
2482: arp_util.debug( 'p_link_to_trx_hist_id : ' || NULL);
2483: arp_util.debug( 'p_org_id : ' || to_char(p_ps_rec.org_id));
2484: arp_util.debug( '----------------------------------------------------------------');
2485: END IF;
2486:

Line 2483: arp_util.debug( 'p_org_id : ' || to_char(p_ps_rec.org_id));

2479: arp_util.debug( 'p_customer_id : ' || p_ps_rec.customer_id);
2480: arp_util.debug( 'remit bank account use id : ' || p_batch_rec.remit_bank_acct_use_id);
2481: arp_util.debug( 'p_called_from : ' || C_BR_FACTORED);
2482: arp_util.debug( 'p_link_to_trx_hist_id : ' || NULL);
2483: arp_util.debug( 'p_org_id : ' || to_char(p_ps_rec.org_id));
2484: arp_util.debug( '----------------------------------------------------------------');
2485: END IF;
2486:
2487: -- bug 3506385/3572968 : pass rate ONLY when exchange_rate_type = 'User'

Line 2484: arp_util.debug( '----------------------------------------------------------------');

2480: arp_util.debug( 'remit bank account use id : ' || p_batch_rec.remit_bank_acct_use_id);
2481: arp_util.debug( 'p_called_from : ' || C_BR_FACTORED);
2482: arp_util.debug( 'p_link_to_trx_hist_id : ' || NULL);
2483: arp_util.debug( 'p_org_id : ' || to_char(p_ps_rec.org_id));
2484: arp_util.debug( '----------------------------------------------------------------');
2485: END IF;
2486:
2487: -- bug 3506385/3572968 : pass rate ONLY when exchange_rate_type = 'User'
2488: -- this is the only case where Receipt API expects a rate

Line 2523: arp_util.debug( 'Cash Receipt Id created : ' || l_cr_id);

2519: p_cr_id => l_cr_id ,
2520: p_org_id => p_ps_rec.org_id);
2521:
2522: IF PG_DEBUG in ('Y', 'C') THEN
2523: arp_util.debug( 'Cash Receipt Id created : ' || l_cr_id);
2524: arp_util.debug( 'Return status : ' || l_return_status);
2525: arp_util.debug( 'l_msg_count : ' || to_char(l_msg_count));
2526: END IF;
2527:

Line 2524: arp_util.debug( 'Return status : ' || l_return_status);

2520: p_org_id => p_ps_rec.org_id);
2521:
2522: IF PG_DEBUG in ('Y', 'C') THEN
2523: arp_util.debug( 'Cash Receipt Id created : ' || l_cr_id);
2524: arp_util.debug( 'Return status : ' || l_return_status);
2525: arp_util.debug( 'l_msg_count : ' || to_char(l_msg_count));
2526: END IF;
2527:
2528:

Line 2525: arp_util.debug( 'l_msg_count : ' || to_char(l_msg_count));

2521:
2522: IF PG_DEBUG in ('Y', 'C') THEN
2523: arp_util.debug( 'Cash Receipt Id created : ' || l_cr_id);
2524: arp_util.debug( 'Return status : ' || l_return_status);
2525: arp_util.debug( 'l_msg_count : ' || to_char(l_msg_count));
2526: END IF;
2527:
2528:
2529: IF (l_return_status <> 'S')

Line 2532: arp_util.debug( '>>>>>>>>>> Problems during Receipt Creation and Application');

2528:
2529: IF (l_return_status <> 'S')
2530: THEN
2531: IF PG_DEBUG in ('Y', 'C') THEN
2532: arp_util.debug( '>>>>>>>>>> Problems during Receipt Creation and Application');
2533: arp_util.debug( 'l_return_status : ' || l_return_status);
2534: arp_util.debug( 'l_msg_count : ' || l_msg_count);
2535: arp_util.debug( 'l_msg_data : ' || l_msg_data);
2536: END IF;

Line 2533: arp_util.debug( 'l_return_status : ' || l_return_status);

2529: IF (l_return_status <> 'S')
2530: THEN
2531: IF PG_DEBUG in ('Y', 'C') THEN
2532: arp_util.debug( '>>>>>>>>>> Problems during Receipt Creation and Application');
2533: arp_util.debug( 'l_return_status : ' || l_return_status);
2534: arp_util.debug( 'l_msg_count : ' || l_msg_count);
2535: arp_util.debug( 'l_msg_data : ' || l_msg_data);
2536: END IF;
2537:

Line 2534: arp_util.debug( 'l_msg_count : ' || l_msg_count);

2530: THEN
2531: IF PG_DEBUG in ('Y', 'C') THEN
2532: arp_util.debug( '>>>>>>>>>> Problems during Receipt Creation and Application');
2533: arp_util.debug( 'l_return_status : ' || l_return_status);
2534: arp_util.debug( 'l_msg_count : ' || l_msg_count);
2535: arp_util.debug( 'l_msg_data : ' || l_msg_data);
2536: END IF;
2537:
2538:

Line 2535: arp_util.debug( 'l_msg_data : ' || l_msg_data);

2531: IF PG_DEBUG in ('Y', 'C') THEN
2532: arp_util.debug( '>>>>>>>>>> Problems during Receipt Creation and Application');
2533: arp_util.debug( 'l_return_status : ' || l_return_status);
2534: arp_util.debug( 'l_msg_count : ' || l_msg_count);
2535: arp_util.debug( 'l_msg_data : ' || l_msg_data);
2536: END IF;
2537:
2538:
2539: IF (l_msg_count > 0)

Line 2561: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Factore_Without_Recourse ()-');

2557: END IF;
2558:
2559:
2560: IF PG_DEBUG in ('Y', 'C') THEN
2561: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Factore_Without_Recourse ()-');
2562: END IF;
2563:
2564: EXCEPTION
2565: WHEN OTHERS THEN

Line 2567: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.Factore_Without_Recourse : ' || SQLERRM);

2563:
2564: EXCEPTION
2565: WHEN OTHERS THEN
2566: IF PG_DEBUG in ('Y', 'C') THEN
2567: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.Factore_Without_Recourse : ' || SQLERRM);
2568: END IF;
2569: RAISE;
2570:
2571: END Factore_Without_Recourse;

Line 2601: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Apply_Receipt ()+');

2597:
2598: BEGIN
2599:
2600: IF PG_DEBUG in ('Y', 'C') THEN
2601: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Apply_Receipt ()+');
2602: END IF;
2603:
2604: /* SSA change */
2605: l_org_id := p_trh_rec.org_id;

Line 2612: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Apply_receipt : l_org_return_status <> SUCCESS');

2608: p_return_status =>l_org_return_status);
2609:
2610: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2611:
2612: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Apply_receipt : l_org_return_status <> SUCCESS');
2613: ELSE
2614:
2615: /*----------------------------------------------+
2616: | Create normal application using Receipt API |

Line 2629: arp_util.debug( '------------------------------------------------');

2625: END IF;
2626:
2627:
2628: IF PG_DEBUG in ('Y', 'C') THEN
2629: arp_util.debug( '------------------------------------------------');
2630: arp_util.debug( 'PARAMETERS PASSED TO AR_RECEIPT_API_PUB.APPLY : ');
2631: arp_util.debug( 'p_cash_receipt_id : ' || p_cash_receipt_id);
2632: arp_util.debug( 'p_customer_trx_id : ' || p_trh_rec.customer_trx_id);
2633: arp_util.debug( 'p_applied_payment_schedule_id : ' || p_ps_rec.payment_schedule_id);

Line 2630: arp_util.debug( 'PARAMETERS PASSED TO AR_RECEIPT_API_PUB.APPLY : ');

2626:
2627:
2628: IF PG_DEBUG in ('Y', 'C') THEN
2629: arp_util.debug( '------------------------------------------------');
2630: arp_util.debug( 'PARAMETERS PASSED TO AR_RECEIPT_API_PUB.APPLY : ');
2631: arp_util.debug( 'p_cash_receipt_id : ' || p_cash_receipt_id);
2632: arp_util.debug( 'p_customer_trx_id : ' || p_trh_rec.customer_trx_id);
2633: arp_util.debug( 'p_applied_payment_schedule_id : ' || p_ps_rec.payment_schedule_id);
2634: arp_util.debug( 'p_amount_applied : ' || p_ps_rec.amount_due_remaining);

Line 2631: arp_util.debug( 'p_cash_receipt_id : ' || p_cash_receipt_id);

2627:
2628: IF PG_DEBUG in ('Y', 'C') THEN
2629: arp_util.debug( '------------------------------------------------');
2630: arp_util.debug( 'PARAMETERS PASSED TO AR_RECEIPT_API_PUB.APPLY : ');
2631: arp_util.debug( 'p_cash_receipt_id : ' || p_cash_receipt_id);
2632: arp_util.debug( 'p_customer_trx_id : ' || p_trh_rec.customer_trx_id);
2633: arp_util.debug( 'p_applied_payment_schedule_id : ' || p_ps_rec.payment_schedule_id);
2634: arp_util.debug( 'p_amount_applied : ' || p_ps_rec.amount_due_remaining);
2635: arp_util.debug( 'p_apply_date : ' || p_trh_rec.trx_date);

Line 2632: arp_util.debug( 'p_customer_trx_id : ' || p_trh_rec.customer_trx_id);

2628: IF PG_DEBUG in ('Y', 'C') THEN
2629: arp_util.debug( '------------------------------------------------');
2630: arp_util.debug( 'PARAMETERS PASSED TO AR_RECEIPT_API_PUB.APPLY : ');
2631: arp_util.debug( 'p_cash_receipt_id : ' || p_cash_receipt_id);
2632: arp_util.debug( 'p_customer_trx_id : ' || p_trh_rec.customer_trx_id);
2633: arp_util.debug( 'p_applied_payment_schedule_id : ' || p_ps_rec.payment_schedule_id);
2634: arp_util.debug( 'p_amount_applied : ' || p_ps_rec.amount_due_remaining);
2635: arp_util.debug( 'p_apply_date : ' || p_trh_rec.trx_date);
2636: arp_util.debug( 'p_apply_gl_date : ' || p_trh_rec.gl_date);

Line 2633: arp_util.debug( 'p_applied_payment_schedule_id : ' || p_ps_rec.payment_schedule_id);

2629: arp_util.debug( '------------------------------------------------');
2630: arp_util.debug( 'PARAMETERS PASSED TO AR_RECEIPT_API_PUB.APPLY : ');
2631: arp_util.debug( 'p_cash_receipt_id : ' || p_cash_receipt_id);
2632: arp_util.debug( 'p_customer_trx_id : ' || p_trh_rec.customer_trx_id);
2633: arp_util.debug( 'p_applied_payment_schedule_id : ' || p_ps_rec.payment_schedule_id);
2634: arp_util.debug( 'p_amount_applied : ' || p_ps_rec.amount_due_remaining);
2635: arp_util.debug( 'p_apply_date : ' || p_trh_rec.trx_date);
2636: arp_util.debug( 'p_apply_gl_date : ' || p_trh_rec.gl_date);
2637: arp_util.debug( 'p_move_deffered_tax : ' || l_move_deferred_tax);

Line 2634: arp_util.debug( 'p_amount_applied : ' || p_ps_rec.amount_due_remaining);

2630: arp_util.debug( 'PARAMETERS PASSED TO AR_RECEIPT_API_PUB.APPLY : ');
2631: arp_util.debug( 'p_cash_receipt_id : ' || p_cash_receipt_id);
2632: arp_util.debug( 'p_customer_trx_id : ' || p_trh_rec.customer_trx_id);
2633: arp_util.debug( 'p_applied_payment_schedule_id : ' || p_ps_rec.payment_schedule_id);
2634: arp_util.debug( 'p_amount_applied : ' || p_ps_rec.amount_due_remaining);
2635: arp_util.debug( 'p_apply_date : ' || p_trh_rec.trx_date);
2636: arp_util.debug( 'p_apply_gl_date : ' || p_trh_rec.gl_date);
2637: arp_util.debug( 'p_move_deffered_tax : ' || l_move_deferred_tax);
2638: arp_util.debug( 'p_org_id : ' || to_char(p_trh_rec.org_id));

Line 2635: arp_util.debug( 'p_apply_date : ' || p_trh_rec.trx_date);

2631: arp_util.debug( 'p_cash_receipt_id : ' || p_cash_receipt_id);
2632: arp_util.debug( 'p_customer_trx_id : ' || p_trh_rec.customer_trx_id);
2633: arp_util.debug( 'p_applied_payment_schedule_id : ' || p_ps_rec.payment_schedule_id);
2634: arp_util.debug( 'p_amount_applied : ' || p_ps_rec.amount_due_remaining);
2635: arp_util.debug( 'p_apply_date : ' || p_trh_rec.trx_date);
2636: arp_util.debug( 'p_apply_gl_date : ' || p_trh_rec.gl_date);
2637: arp_util.debug( 'p_move_deffered_tax : ' || l_move_deferred_tax);
2638: arp_util.debug( 'p_org_id : ' || to_char(p_trh_rec.org_id));
2639: arp_util.debug( '------------------------------------------------');

Line 2636: arp_util.debug( 'p_apply_gl_date : ' || p_trh_rec.gl_date);

2632: arp_util.debug( 'p_customer_trx_id : ' || p_trh_rec.customer_trx_id);
2633: arp_util.debug( 'p_applied_payment_schedule_id : ' || p_ps_rec.payment_schedule_id);
2634: arp_util.debug( 'p_amount_applied : ' || p_ps_rec.amount_due_remaining);
2635: arp_util.debug( 'p_apply_date : ' || p_trh_rec.trx_date);
2636: arp_util.debug( 'p_apply_gl_date : ' || p_trh_rec.gl_date);
2637: arp_util.debug( 'p_move_deffered_tax : ' || l_move_deferred_tax);
2638: arp_util.debug( 'p_org_id : ' || to_char(p_trh_rec.org_id));
2639: arp_util.debug( '------------------------------------------------');
2640: END IF;

Line 2637: arp_util.debug( 'p_move_deffered_tax : ' || l_move_deferred_tax);

2633: arp_util.debug( 'p_applied_payment_schedule_id : ' || p_ps_rec.payment_schedule_id);
2634: arp_util.debug( 'p_amount_applied : ' || p_ps_rec.amount_due_remaining);
2635: arp_util.debug( 'p_apply_date : ' || p_trh_rec.trx_date);
2636: arp_util.debug( 'p_apply_gl_date : ' || p_trh_rec.gl_date);
2637: arp_util.debug( 'p_move_deffered_tax : ' || l_move_deferred_tax);
2638: arp_util.debug( 'p_org_id : ' || to_char(p_trh_rec.org_id));
2639: arp_util.debug( '------------------------------------------------');
2640: END IF;
2641:

Line 2638: arp_util.debug( 'p_org_id : ' || to_char(p_trh_rec.org_id));

2634: arp_util.debug( 'p_amount_applied : ' || p_ps_rec.amount_due_remaining);
2635: arp_util.debug( 'p_apply_date : ' || p_trh_rec.trx_date);
2636: arp_util.debug( 'p_apply_gl_date : ' || p_trh_rec.gl_date);
2637: arp_util.debug( 'p_move_deffered_tax : ' || l_move_deferred_tax);
2638: arp_util.debug( 'p_org_id : ' || to_char(p_trh_rec.org_id));
2639: arp_util.debug( '------------------------------------------------');
2640: END IF;
2641:
2642: AR_RECEIPT_API_PUB.Apply (

Line 2639: arp_util.debug( '------------------------------------------------');

2635: arp_util.debug( 'p_apply_date : ' || p_trh_rec.trx_date);
2636: arp_util.debug( 'p_apply_gl_date : ' || p_trh_rec.gl_date);
2637: arp_util.debug( 'p_move_deffered_tax : ' || l_move_deferred_tax);
2638: arp_util.debug( 'p_org_id : ' || to_char(p_trh_rec.org_id));
2639: arp_util.debug( '------------------------------------------------');
2640: END IF;
2641:
2642: AR_RECEIPT_API_PUB.Apply (
2643: p_api_version => 1.0 ,

Line 2661: arp_util.debug( '>>>>>>>>>> Problems during Receipt Application');

2657:
2658: IF (l_return_status <> 'S')
2659: THEN
2660: IF PG_DEBUG in ('Y', 'C') THEN
2661: arp_util.debug( '>>>>>>>>>> Problems during Receipt Application');
2662: arp_util.debug( 'l_return_status : ' || l_return_status);
2663: arp_util.debug( 'l_msg_count : ' || l_msg_count);
2664: arp_util.debug( 'l_msg_data : ' || l_msg_data);
2665: END IF;

Line 2662: arp_util.debug( 'l_return_status : ' || l_return_status);

2658: IF (l_return_status <> 'S')
2659: THEN
2660: IF PG_DEBUG in ('Y', 'C') THEN
2661: arp_util.debug( '>>>>>>>>>> Problems during Receipt Application');
2662: arp_util.debug( 'l_return_status : ' || l_return_status);
2663: arp_util.debug( 'l_msg_count : ' || l_msg_count);
2664: arp_util.debug( 'l_msg_data : ' || l_msg_data);
2665: END IF;
2666:

Line 2663: arp_util.debug( 'l_msg_count : ' || l_msg_count);

2659: THEN
2660: IF PG_DEBUG in ('Y', 'C') THEN
2661: arp_util.debug( '>>>>>>>>>> Problems during Receipt Application');
2662: arp_util.debug( 'l_return_status : ' || l_return_status);
2663: arp_util.debug( 'l_msg_count : ' || l_msg_count);
2664: arp_util.debug( 'l_msg_data : ' || l_msg_data);
2665: END IF;
2666:
2667:

Line 2664: arp_util.debug( 'l_msg_data : ' || l_msg_data);

2660: IF PG_DEBUG in ('Y', 'C') THEN
2661: arp_util.debug( '>>>>>>>>>> Problems during Receipt Application');
2662: arp_util.debug( 'l_return_status : ' || l_return_status);
2663: arp_util.debug( 'l_msg_count : ' || l_msg_count);
2664: arp_util.debug( 'l_msg_data : ' || l_msg_data);
2665: END IF;
2666:
2667:
2668: IF (l_msg_count > 0)

Line 2681: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Apply_Receipt ()-');

2677: END IF;
2678:
2679:
2680: IF PG_DEBUG in ('Y', 'C') THEN
2681: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Apply_Receipt ()-');
2682: END IF;
2683:
2684: EXCEPTION
2685: WHEN OTHERS THEN

Line 2687: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.Apply_Receipt : ' || SQLERRM);

2683:
2684: EXCEPTION
2685: WHEN OTHERS THEN
2686: IF PG_DEBUG in ('Y', 'C') THEN
2687: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.Apply_Receipt : ' || SQLERRM);
2688: END IF;
2689: RAISE;
2690:
2691: END Apply_Receipt;

Line 2723: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Link_Application_History ()+');

2719:
2720: BEGIN
2721:
2722: IF PG_DEBUG in ('Y', 'C') THEN
2723: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Link_Application_History ()+');
2724: END IF;
2725:
2726: /*----------------------------------------------+
2727: | Fetch last Application |

Line 2736: arp_util.debug ('Link_Application_History: ' || '>>>>>>>>>> Last Application could not be found');

2732:
2733: IF (last_application_cur%NOTFOUND)
2734: THEN
2735: IF PG_DEBUG in ('Y', 'C') THEN
2736: arp_util.debug ('Link_Application_History: ' || '>>>>>>>>>> Last Application could not be found');
2737: END IF;
2738: CLOSE last_application_cur;
2739: APP_EXCEPTION.raise_exception;
2740: END IF;

Line 2765: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Link_Application_History ()-');

2761: WHERE receivable_application_id = last_application_rec.receivable_application_id;
2762:
2763:
2764: IF PG_DEBUG in ('Y', 'C') THEN
2765: arp_util.debug('AR_BILLS_MAINTAIN_LIB_PVT.Link_Application_History ()-');
2766: END IF;
2767:
2768: EXCEPTION
2769: WHEN OTHERS THEN

Line 2771: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.Link_Application_History : ' || SQLERRM);

2767:
2768: EXCEPTION
2769: WHEN OTHERS THEN
2770: IF PG_DEBUG in ('Y', 'C') THEN
2771: arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_MAINTAIN_LIB_PVT.Link_Application_History : ' || SQLERRM);
2772: END IF;
2773: IF (last_application_cur%ISOPEN)
2774: THEN
2775: CLOSE last_application_cur;