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_ADJUST_PUB dependencies on ARP_UTIL

Line 90: arp_util.debug('Validate_Adj_Insert()+');

86:
87: BEGIN
88:
89: IF PG_DEBUG in ('Y', 'C') THEN
90: arp_util.debug('Validate_Adj_Insert()+');
91: arp_util.debug('p_llca_from_call :'|| p_llca_from_call);
92: END IF;
93:
94:

Line 91: arp_util.debug('p_llca_from_call :'|| p_llca_from_call);

87: BEGIN
88:
89: IF PG_DEBUG in ('Y', 'C') THEN
90: arp_util.debug('Validate_Adj_Insert()+');
91: arp_util.debug('p_llca_from_call :'|| p_llca_from_call);
92: END IF;
93:
94:
95: /*-------------------------------------------------+

Line 111: arp_util.debug ('Validate_Adj_Insert: ' || ' failed to validate type ');

107: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
108: THEN
109: p_validation_status := l_return_status ;
110: IF PG_DEBUG in ('Y', 'C') THEN
111: arp_util.debug ('Validate_Adj_Insert: ' || ' failed to validate type ');
112: END IF;
113: END IF;
114:
115: /*-------------------------------------------------+

Line 129: arp_util.debug ('Validate_Adj_Insert: ' || ' failed to validate payment_schedule id ');

125: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
126: THEN
127: p_validation_status := l_return_status ;
128: IF PG_DEBUG in ('Y', 'C') THEN
129: arp_util.debug ('Validate_Adj_Insert: ' || ' failed to validate payment_schedule id ');
130: END IF;
131: END IF;
132:
133: /*-------------------------------------------------+

Line 147: arp_util.debug ('Validate_Adj_Insert: ' || ' failed to validate dates ');

143: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
144: THEN
145: p_validation_status := l_return_status ;
146: IF PG_DEBUG in ('Y', 'C') THEN
147: arp_util.debug ('Validate_Adj_Insert: ' || ' failed to validate dates ');
148: END IF;
149: ELSE
150: p_adj_rec.apply_date := trunc(p_adj_rec.apply_date);
151: p_adj_rec.gl_date := trunc(p_adj_rec.gl_date);

Line 177: arp_util.debug ('Validate_Adj_Insert: ' || ' failed to validate amount '|| p_validation_status);

173: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
174: THEN
175: p_validation_status := l_return_status ;
176: IF PG_DEBUG in ('Y', 'C') THEN
177: arp_util.debug ('Validate_Adj_Insert: ' || ' failed to validate amount '|| p_validation_status);
178: END IF;
179: END IF;
180:
181: /*-------------------------------------------------+

Line 200: arp_util.debug ('Validate_Adj_Insert: ' || ' failed to validate receivables trx ccid');

196: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
197: THEN
198: p_validation_status := l_return_status ;
199: IF PG_DEBUG in ('Y', 'C') THEN
200: arp_util.debug ('Validate_Adj_Insert: ' || ' failed to validate receivables trx ccid');
201: END IF;
202: END IF;
203:
204:

Line 232: arp_util.debug('Validate_Adj_Insert: ' || 'cal_prorated_amount failed - error num 1');

228: p_adj_rec.customer_trx_line_id);
229:
230: IF (l_error_num = 1) THEN
231: IF PG_DEBUG in ('Y', 'C') THEN
232: arp_util.debug('Validate_Adj_Insert: ' || 'cal_prorated_amount failed - error num 1');
233: END IF;
234: /*-----------------------------------------------+
235: | Set the message |
236: +-----------------------------------------------*/

Line 242: arp_util.debug('Validate_Adj_Insert: ' || 'cal_prorated_amount failed - error num 2');

238: FND_MSG_PUB.ADD ;
239: p_validation_status := FND_API.G_RET_STS_ERROR;
240: ELSIF (l_error_num = 2) THEN
241: IF PG_DEBUG in ('Y', 'C') THEN
242: arp_util.debug('Validate_Adj_Insert: ' || 'cal_prorated_amount failed - error num 2');
243: END IF;
244: /*-----------------------------------------------+
245: | Set the message |
246: +-----------------------------------------------*/

Line 252: arp_util.debug('Validate_Adj_Insert: ' || 'cal_prorated_amount failed - error num 3');

248: FND_MSG_PUB.ADD ;
249: p_validation_status := FND_API.G_RET_STS_ERROR;
250: ELSIF (l_error_num = 3) THEN
251: IF PG_DEBUG in ('Y', 'C') THEN
252: arp_util.debug('Validate_Adj_Insert: ' || 'cal_prorated_amount failed - error num 3');
253: END IF;
254: /*-----------------------------------------------+
255: | Set the message |
256: +-----------------------------------------------*/

Line 285: arp_util.debug ('Validate_Adj_Insert: ' || ' failed over-application check ');

281: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
282: THEN
283: p_validation_status := l_return_status ;
284: IF PG_DEBUG in ('Y', 'C') THEN
285: arp_util.debug ('Validate_Adj_Insert: ' || ' failed over-application check ');
286: END IF;
287: END IF;
288:
289: /*-------------------------------------------------+

Line 307: arp_util.debug ('Validate_Adj_Insert: ' || ' failed over_application_llca check ');

303: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
304: THEN
305: p_validation_status := l_return_status ;
306: IF PG_DEBUG in ('Y', 'C') THEN
307: arp_util.debug ('Validate_Adj_Insert: ' || ' failed over_application_llca check ');
308: END IF;
309: END IF;
310: END IF;
311:

Line 329: arp_util.debug ('Validate_Adj_Insert: ' || ' failed to validate doc seq ');

325: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
326: THEN
327: p_validation_status := l_return_status ;
328: IF PG_DEBUG in ('Y', 'C') THEN
329: arp_util.debug ('Validate_Adj_Insert: ' || ' failed to validate doc seq ');
330: END IF;
331: END IF;
332: end if;
333:

Line 346: arp_util.debug ('Validate_Adj_Insert: ' || ' failed to validate reason code ');

342: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
343: THEN
344: p_validation_status := l_return_status ;
345: IF PG_DEBUG in ('Y', 'C') THEN
346: arp_util.debug ('Validate_Adj_Insert: ' || ' failed to validate reason code ');
347: END IF;
348: END IF;
349:
350: /*-------------------------------------------------+

Line 361: arp_util.debug ('Validate_Adj_Insert: ' || ' failed to validate associated receipt id ');

357: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
358: THEN
359: p_validation_status := l_return_status ;
360: IF PG_DEBUG in ('Y', 'C') THEN
361: arp_util.debug ('Validate_Adj_Insert: ' || ' failed to validate associated receipt id ');
362: END IF;
363: END IF;
364:
365: /*-------------------------------------------------+

Line 376: arp_util.debug ('Validate_Adj_Insert: ' || ' failed to validate ussgl_code');

372: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
373: THEN
374: p_validation_status := l_return_status ;
375: IF PG_DEBUG in ('Y', 'C') THEN
376: arp_util.debug ('Validate_Adj_Insert: ' || ' failed to validate ussgl_code');
377: END IF;
378: END IF;
379:
380: /*-------------------------------------------------+

Line 391: arp_util.debug ('Validate_Adj_Insert: ' || ' failed to validate ussgl_code');

387: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
388: THEN
389: p_validation_status := l_return_status ;
390: IF PG_DEBUG in ('Y', 'C') THEN
391: arp_util.debug ('Validate_Adj_Insert: ' || ' failed to validate ussgl_code');
392: END IF;
393: END IF;
394:
395: /*-------------------------------------------------+

Line 407: arp_util.debug ('Validate_Adj_Insert: ' || ' failed to validate created from ');

403: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
404: THEN
405: p_validation_status := l_return_status ;
406: IF PG_DEBUG in ('Y', 'C') THEN
407: arp_util.debug ('Validate_Adj_Insert: ' || ' failed to validate created from ');
408: END IF;
409: END IF;
410:
411: IF PG_DEBUG in ('Y', 'C') THEN

Line 412: arp_util.debug('Validate_Adj_Insert()-');

408: END IF;
409: END IF;
410:
411: IF PG_DEBUG in ('Y', 'C') THEN
412: arp_util.debug('Validate_Adj_Insert()-');
413: arp_util.debug('Validate_Adj_Insert: ' || 'value of the status flag ' || p_validation_status);
414: END IF;
415: RETURN;
416:

Line 413: arp_util.debug('Validate_Adj_Insert: ' || 'value of the status flag ' || p_validation_status);

409: END IF;
410:
411: IF PG_DEBUG in ('Y', 'C') THEN
412: arp_util.debug('Validate_Adj_Insert()-');
413: arp_util.debug('Validate_Adj_Insert: ' || 'value of the status flag ' || p_validation_status);
414: END IF;
415: RETURN;
416:
417:

Line 422: arp_util.debug('EXCEPTION: Validate_Adj_Insert() ');

418: EXCEPTION
419:
420: WHEN OTHERS THEN
421: IF PG_DEBUG in ('Y', 'C') THEN
422: arp_util.debug('EXCEPTION: Validate_Adj_Insert() ');
423: END IF;
424: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Validate_Adj_Insert');
425: p_validation_status := FND_API.G_RET_STS_UNEXP_ERROR ;
426: RETURN;

Line 471: arp_util.debug('Set_Remaining_Attributes()+');

467:
468: BEGIN
469:
470: IF PG_DEBUG in ('Y', 'C') THEN
471: arp_util.debug('Set_Remaining_Attributes()+');
472: END IF;
473:
474: /*-----------------------------------------------+
475: | Set the status to success |

Line 503: arp_util.debug('Set_Remaining_Attributes()-' );

499: p_adj_rec.subsequent_trx_id := NULL ;
500:
501:
502: IF PG_DEBUG in ('Y', 'C') THEN
503: arp_util.debug('Set_Remaining_Attributes()-' );
504: END IF;
505:
506: EXCEPTION
507:

Line 510: arp_util.debug('EXCEPTION: Set_Remaining_Attributes() ');

506: EXCEPTION
507:
508: WHEN OTHERS THEN
509: IF PG_DEBUG in ('Y', 'C') THEN
510: arp_util.debug('EXCEPTION: Set_Remaining_Attributes() ');
511: END IF;
512: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Set_Remaining_Attributes');
513: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
514: RETURN;

Line 572: arp_util.debug('Validate_Adj_modify()+' );

568:
569: BEGIN
570:
571: IF PG_DEBUG in ('Y', 'C') THEN
572: arp_util.debug('Validate_Adj_modify()+' );
573: END IF;
574:
575: /*----------------------------------------------+
576: | Validate Old Adjustment status. Cannot modify |

Line 591: arp_util.debug('Validate_Adj_modify: ' || 'The old adjustment status is A, cannot modify');

587: FND_MESSAGE.SET_TOKEN ( 'STATUS', p_old_adj_rec.status ) ;
588: FND_MSG_PUB.ADD ;
589: p_validation_status := FND_API.G_RET_STS_ERROR;
590: IF PG_DEBUG in ('Y', 'C') THEN
591: arp_util.debug('Validate_Adj_modify: ' || 'The old adjustment status is A, cannot modify');
592: END IF;
593: END IF;
594:
595: --If approved adjustment is being modified for associating receipt,

Line 607: arp_util.debug('Validate_Adj_modify: ' || 'Invalid associated cash_receipt_id or application id -should not be null');

603: FND_MESSAGE.SET_NAME ('AR', 'AR_RAPI_RCPT_RA_ID_X_INVALID');
604: FND_MSG_PUB.ADD ;
605: p_validation_status := FND_API.G_RET_STS_ERROR;
606: IF PG_DEBUG in ('Y', 'C') THEN
607: arp_util.debug('Validate_Adj_modify: ' || 'Invalid associated cash_receipt_id or application id -should not be null');
608: END IF;
609: END IF;
610:
611: --If approved adjustment is being modified for associating receipt,

Line 625: arp_util.debug('Validate_Adj_modify: ' || 'Cannot modify comments,status or gl date of an approved adjustment');

621: FND_MESSAGE.SET_TOKEN ( 'STATUS', p_old_adj_rec.status ) ;
622: FND_MSG_PUB.ADD ;
623: p_validation_status := FND_API.G_RET_STS_ERROR;
624: IF PG_DEBUG in ('Y', 'C') THEN
625: arp_util.debug('Validate_Adj_modify: ' || 'Cannot modify comments,status or gl date of an approved adjustment');
626: END IF;
627: END IF;
628:
629:

Line 642: arp_util.debug('Validate_Adj_modify: ' || 'The new adjustment status is not valid, cannot modify');

638: FND_MESSAGE.SET_TOKEN ( 'STATUS', p_adj_rec.status ) ;
639: FND_MSG_PUB.ADD ;
640: p_validation_status := FND_API.G_RET_STS_ERROR;
641: IF PG_DEBUG in ('Y', 'C') THEN
642: arp_util.debug('Validate_Adj_modify: ' || 'The new adjustment status is not valid, cannot modify');
643: END IF;
644: END IF;
645:
646: /*---------------------------------------------------+

Line 674: arp_util.debug('Validate_Adj_modify: ' || 'Invalid Payment Schedule Id');

670: FND_MSG_PUB.ADD ;
671:
672: p_validation_status := FND_API.G_RET_STS_ERROR;
673: IF PG_DEBUG in ('Y', 'C') THEN
674: arp_util.debug('Validate_Adj_modify: ' || 'Invalid Payment Schedule Id');
675: END IF;
676: END ;
677:
678: /*------------------------------------------------------+

Line 703: arp_util.debug('Validate_Adj_modify: ' || 'failure in get approval limits and check');

699: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
700: THEN
701: p_validation_status := l_return_status;
702: IF PG_DEBUG in ('Y', 'C') THEN
703: arp_util.debug('Validate_Adj_modify: ' || 'failure in get approval limits and check');
704: END IF;
705: END IF;
706:
707: IF ( l_approved_flag <> FND_API.G_TRUE )

Line 713: arp_util.debug('Validate_Adj_modify: ' || 'amount not in approval limits ');

709: FND_MESSAGE.SET_NAME ( 'AR', 'AR_VAL_AMT_APPROVAL_LIMIT');
710: FND_MSG_PUB.ADD ;
711: p_validation_status := FND_API.G_RET_STS_ERROR;
712: IF PG_DEBUG in ('Y', 'C') THEN
713: arp_util.debug('Validate_Adj_modify: ' || 'amount not in approval limits ');
714: END IF;
715: END IF;
716:
717: /*-------------------------------------------------+

Line 740: arp_util.debug('Validate_Adj_modify: ' || 'failure in validating dates');

736: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
737: THEN
738: p_validation_status := l_return_status;
739: IF PG_DEBUG in ('Y', 'C') THEN
740: arp_util.debug('Validate_Adj_modify: ' || 'failure in validating dates');
741: END IF;
742: END IF;
743:
744:

Line 759: arp_util.debug ('Validate_Adj_modify: ' || ' failed to validate associated receipt id ');

755: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
756: THEN
757: p_validation_status := l_return_status ;
758: IF PG_DEBUG in ('Y', 'C') THEN
759: arp_util.debug ('Validate_Adj_modify: ' || ' failed to validate associated receipt id ');
760: END IF;
761: END IF;
762: END IF;
763:

Line 784: arp_util.debug('Validate_Adj_modify: ' || 'Associated Application ID passed is invalid');

780: FND_MESSAGE.SET_NAME ( 'AR', 'AR_RAPI_REC_APP_ID_INVALID');
781: FND_MSG_PUB.ADD ;
782: p_validation_status := FND_API.G_RET_STS_ERROR;
783: IF PG_DEBUG in ('Y', 'C') THEN
784: arp_util.debug('Validate_Adj_modify: ' || 'Associated Application ID passed is invalid');
785: END IF;
786: END;
787:
788: END IF;

Line 801: arp_util.debug('Validate_Adj_modify: ' || 'Associated Application ID should belongs to valid Receipt,pass cash receipt id');

797: FND_MESSAGE.SET_NAME ( 'AR', 'AR_RAPI_REC_APP_ID_INVALID');
798: FND_MSG_PUB.ADD ;
799: p_validation_status := FND_API.G_RET_STS_ERROR;
800: IF PG_DEBUG in ('Y', 'C') THEN
801: arp_util.debug('Validate_Adj_modify: ' || 'Associated Application ID should belongs to valid Receipt,pass cash receipt id');
802: END IF;
803: END IF;
804:
805: /*---------------------------------------------------+

Line 853: arp_util.debug('Validate_Adj_modify()-' );

849: p_adj_rec.associated_application_id := l_temp_adj_rec.associated_application_id ;
850: END IF ;
851:
852: IF PG_DEBUG in ('Y', 'C') THEN
853: arp_util.debug('Validate_Adj_modify()-' );
854: END IF;
855:
856: EXCEPTION
857:

Line 860: arp_util.debug('EXCEPTION: Validate_Adj_Modify() ');

856: EXCEPTION
857:
858: WHEN OTHERS THEN
859: IF PG_DEBUG in ('Y', 'C') THEN
860: arp_util.debug('EXCEPTION: Validate_Adj_Modify() ');
861: END IF;
862: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Validate_Adj_Modify');
863: p_validation_status := FND_API.G_RET_STS_UNEXP_ERROR ;
864: RETURN;

Line 915: arp_util.debug('Validate_Adj_Reverse()+');

911:
912: BEGIN
913:
914: IF PG_DEBUG in ('Y', 'C') THEN
915: arp_util.debug('Validate_Adj_Reverse()+');
916: END IF;
917:
918: /*----------------------------------------------+
919: | Validate Old Adjustment status. Cannot reverse|

Line 930: arp_util.debug('Validate_Adj_Reverse: ' || 'the status of the old adj is not A ');

926: FND_MESSAGE.SET_TOKEN ( 'STATUS', p_old_adj_rec.status);
927: FND_MSG_PUB.ADD ;
928: p_validation_status := FND_API.G_RET_STS_ERROR;
929: IF PG_DEBUG in ('Y', 'C') THEN
930: arp_util.debug('Validate_Adj_Reverse: ' || 'the status of the old adj is not A ');
931: END IF;
932: END IF;
933:
934:

Line 975: arp_util.debug('Validate_Adj_Reverse: ' || 'invalid payment schedule id');

971: FND_MSG_PUB.ADD ;
972:
973: p_validation_status := FND_API.G_RET_STS_ERROR;
974: IF PG_DEBUG in ('Y', 'C') THEN
975: arp_util.debug('Validate_Adj_Reverse: ' || 'invalid payment schedule id');
976: END IF;
977: END ;
978:
979: ar_adjvalidate_pvt.Validate_dates (

Line 989: arp_util.debug('Validate_Adj_Reverse: ' || 'invalid dates');

985: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
986: THEN
987: p_validation_status := l_return_status;
988: IF PG_DEBUG in ('Y', 'C') THEN
989: arp_util.debug('Validate_Adj_Reverse: ' || 'invalid dates');
990: END IF;
991: END IF;
992:
993: p_reversal_gl_date := trunc(p_reversal_gl_date);

Line 997: arp_util.debug('Validate_Adj_Reverse()-' );

993: p_reversal_gl_date := trunc(p_reversal_gl_date);
994: p_reversal_date := trunc(p_reversal_date);
995:
996: IF PG_DEBUG in ('Y', 'C') THEN
997: arp_util.debug('Validate_Adj_Reverse()-' );
998: END IF;
999:
1000: EXCEPTION
1001:

Line 1004: arp_util.debug('EXCEPTION: Validate_Adj_Reverse() ');

1000: EXCEPTION
1001:
1002: WHEN OTHERS THEN
1003: IF PG_DEBUG in ('Y', 'C') THEN
1004: arp_util.debug('EXCEPTION: Validate_Adj_Reverse() ');
1005: END IF;
1006: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Validate_Adj_Reverse');
1007: p_validation_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1008: RETURN;

Line 1061: arp_util.debug('Validate_Adj_Approve()+');

1057:
1058: BEGIN
1059:
1060: IF PG_DEBUG in ('Y', 'C') THEN
1061: arp_util.debug('Validate_Adj_Approve()+');
1062: END IF;
1063:
1064: /*-----------------------------------------------+
1065: | Validate Old Adjustment status. Cannot approve|

Line 1077: arp_util.debug('Validate_Adj_Approve: ' || 'the adjustment is already approved or rejected');

1073: FND_MESSAGE.SET_TOKEN ( 'STATUS', p_old_adj_rec.status ) ;
1074: FND_MSG_PUB.ADD ;
1075: p_validation_status := FND_API.G_RET_STS_ERROR;
1076: IF PG_DEBUG in ('Y', 'C') THEN
1077: arp_util.debug('Validate_Adj_Approve: ' || 'the adjustment is already approved or rejected');
1078: END IF;
1079: END IF;
1080:
1081: /*----------------------------------------------------+

Line 1103: arp_util.debug('Validate_Adj_Approve: ' || 'the value of the new status is not in A, R, W, M');

1099: FND_MESSAGE.SET_TOKEN ( 'STATUS', p_adj_rec.status ) ;
1100: FND_MSG_PUB.ADD ;
1101: p_validation_status := FND_API.G_RET_STS_ERROR;
1102: IF PG_DEBUG in ('Y', 'C') THEN
1103: arp_util.debug('Validate_Adj_Approve: ' || 'the value of the new status is not in A, R, W, M');
1104: END IF;
1105:
1106: END IF;
1107:

Line 1138: arp_util.debug('Validate_Adj_Approve: ' || 'Invalid payment schedule id');

1134: FND_MESSAGE.SET_TOKEN('PAYMENT_SCHEDULE_ID',to_char(p_old_adj_rec.payment_schedule_id));
1135: FND_MSG_PUB.ADD ;
1136: p_validation_status := FND_API.G_RET_STS_ERROR;
1137: IF PG_DEBUG in ('Y', 'C') THEN
1138: arp_util.debug('Validate_Adj_Approve: ' || 'Invalid payment schedule id');
1139: END IF;
1140:
1141: END ;
1142:

Line 1167: arp_util.debug('Validate_Adj_Approve: ' || ' Error in Get the approval limits and check ');

1163: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
1164: THEN
1165: p_validation_status := l_return_status;
1166: IF PG_DEBUG in ('Y', 'C') THEN
1167: arp_util.debug('Validate_Adj_Approve: ' || ' Error in Get the approval limits and check ');
1168: END IF;
1169: END IF;
1170:
1171: IF ( l_approved_flag <> FND_API.G_TRUE )

Line 1178: arp_util.debug('Validate_Adj_Approve: ' || 'not within approval limits');

1174: FND_MSG_PUB.ADD ;
1175:
1176: p_validation_status := FND_API.G_RET_STS_ERROR;
1177: IF PG_DEBUG in ('Y', 'C') THEN
1178: arp_util.debug('Validate_Adj_Approve: ' || 'not within approval limits');
1179: END IF;
1180: END IF;
1181:
1182: /*-------------------------------------------------+

Line 1205: arp_util.debug('Validate_Adj_Approve: ' || 'invalid gl_date');

1201: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
1202: THEN
1203: p_validation_status := l_return_status ;
1204: IF PG_DEBUG in ('Y', 'C') THEN
1205: arp_util.debug('Validate_Adj_Approve: ' || 'invalid gl_date');
1206: END IF;
1207: END IF;
1208:
1209: p_adj_rec.gl_date := trunc(p_adj_rec.gl_date);

Line 1239: arp_util.debug('Validate_Adj_Approve ()-' );

1235: p_adj_rec.gl_date := l_temp_adj_rec.gl_date ;
1236: END IF ;
1237:
1238: IF PG_DEBUG in ('Y', 'C') THEN
1239: arp_util.debug('Validate_Adj_Approve ()-' );
1240: END IF;
1241:
1242: EXCEPTION
1243:

Line 1246: arp_util.debug('EXCEPTION: Validate_Adj_Approve() ');

1242: EXCEPTION
1243:
1244: WHEN OTHERS THEN
1245: IF PG_DEBUG in ('Y', 'C') THEN
1246: arp_util.debug('EXCEPTION: Validate_Adj_Approve() ');
1247: END IF;
1248: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Validate_Adj_Approve');
1249: p_validation_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1250: RETURN;

Line 1296: arp_util.debug('Populate_adj_llca_gt ()+ ');

1292: p_return_status OUT NOCOPY VARCHAR2)
1293: IS
1294: BEGIN
1295: IF PG_DEBUG in ('Y', 'C') THEN
1296: arp_util.debug('Populate_adj_llca_gt ()+ ');
1297: END IF;
1298:
1299: p_return_status := FND_API.G_RET_STS_SUCCESS;
1300:

Line 1312: arp_util.debug('=======================================================');

1308:
1309:
1310: If p_llca_adj_trx_lines_tbl.count = 0 Then
1311: IF PG_DEBUG in ('Y', 'C') THEN
1312: arp_util.debug('=======================================================');
1313: arp_util.debug(' PL SQL TABLE ( INPUT PARAMETERS ........)+ ');
1314: arp_util.debug('=======================================================');
1315: arp_util.debug('create_linelevel_adjustment: ' || 'Pl Sql Table is empty ..
1316: All Lines ');

Line 1313: arp_util.debug(' PL SQL TABLE ( INPUT PARAMETERS ........)+ ');

1309:
1310: If p_llca_adj_trx_lines_tbl.count = 0 Then
1311: IF PG_DEBUG in ('Y', 'C') THEN
1312: arp_util.debug('=======================================================');
1313: arp_util.debug(' PL SQL TABLE ( INPUT PARAMETERS ........)+ ');
1314: arp_util.debug('=======================================================');
1315: arp_util.debug('create_linelevel_adjustment: ' || 'Pl Sql Table is empty ..
1316: All Lines ');
1317: END IF;

Line 1314: arp_util.debug('=======================================================');

1310: If p_llca_adj_trx_lines_tbl.count = 0 Then
1311: IF PG_DEBUG in ('Y', 'C') THEN
1312: arp_util.debug('=======================================================');
1313: arp_util.debug(' PL SQL TABLE ( INPUT PARAMETERS ........)+ ');
1314: arp_util.debug('=======================================================');
1315: arp_util.debug('create_linelevel_adjustment: ' || 'Pl Sql Table is empty ..
1316: All Lines ');
1317: END IF;
1318: Else

Line 1315: arp_util.debug('create_linelevel_adjustment: ' || 'Pl Sql Table is empty ..

1311: IF PG_DEBUG in ('Y', 'C') THEN
1312: arp_util.debug('=======================================================');
1313: arp_util.debug(' PL SQL TABLE ( INPUT PARAMETERS ........)+ ');
1314: arp_util.debug('=======================================================');
1315: arp_util.debug('create_linelevel_adjustment: ' || 'Pl Sql Table is empty ..
1316: All Lines ');
1317: END IF;
1318: Else
1319: IF PG_DEBUG in ('Y', 'C') THEN

Line 1320: arp_util.debug('No of records in PLSQL Table

1316: All Lines ');
1317: END IF;
1318: Else
1319: IF PG_DEBUG in ('Y', 'C') THEN
1320: arp_util.debug('No of records in PLSQL Table
1321: =>'||to_char(p_llca_adj_trx_lines_tbl.count));
1322: END IF;
1323: For i in p_llca_adj_trx_lines_tbl.FIRST..p_llca_adj_trx_lines_tbl.LAST
1324: Loop

Line 1340: arp_util.debug('=======================================================');

1336: p_llca_adj_trx_lines_tbl(i).line_amount
1337: );
1338:
1339: IF PG_DEBUG in ('Y', 'C') THEN
1340: arp_util.debug('=======================================================');
1341: arp_util.debug(' Line .............=> '||to_char(i));
1342: arp_util.debug('customer_trx_id => '||to_char(p_customer_trx_id));
1343: arp_util.debug('customer_trx_line_id => '||to_char(p_llca_adj_trx_lines_tbl(i).customer_trx_line_id));
1344: arp_util.debug('line_amount => '||to_char(p_llca_adj_trx_lines_tbl(i).line_amount));

Line 1341: arp_util.debug(' Line .............=> '||to_char(i));

1337: );
1338:
1339: IF PG_DEBUG in ('Y', 'C') THEN
1340: arp_util.debug('=======================================================');
1341: arp_util.debug(' Line .............=> '||to_char(i));
1342: arp_util.debug('customer_trx_id => '||to_char(p_customer_trx_id));
1343: arp_util.debug('customer_trx_line_id => '||to_char(p_llca_adj_trx_lines_tbl(i).customer_trx_line_id));
1344: arp_util.debug('line_amount => '||to_char(p_llca_adj_trx_lines_tbl(i).line_amount));
1345: arp_util.debug('receivables_trx_id => '||to_char(p_llca_adj_trx_lines_tbl(i).receivables_trx_id));

Line 1342: arp_util.debug('customer_trx_id => '||to_char(p_customer_trx_id));

1338:
1339: IF PG_DEBUG in ('Y', 'C') THEN
1340: arp_util.debug('=======================================================');
1341: arp_util.debug(' Line .............=> '||to_char(i));
1342: arp_util.debug('customer_trx_id => '||to_char(p_customer_trx_id));
1343: arp_util.debug('customer_trx_line_id => '||to_char(p_llca_adj_trx_lines_tbl(i).customer_trx_line_id));
1344: arp_util.debug('line_amount => '||to_char(p_llca_adj_trx_lines_tbl(i).line_amount));
1345: arp_util.debug('receivables_trx_id => '||to_char(p_llca_adj_trx_lines_tbl(i).receivables_trx_id));
1346: arp_util.debug('=======================================================');

Line 1343: arp_util.debug('customer_trx_line_id => '||to_char(p_llca_adj_trx_lines_tbl(i).customer_trx_line_id));

1339: IF PG_DEBUG in ('Y', 'C') THEN
1340: arp_util.debug('=======================================================');
1341: arp_util.debug(' Line .............=> '||to_char(i));
1342: arp_util.debug('customer_trx_id => '||to_char(p_customer_trx_id));
1343: arp_util.debug('customer_trx_line_id => '||to_char(p_llca_adj_trx_lines_tbl(i).customer_trx_line_id));
1344: arp_util.debug('line_amount => '||to_char(p_llca_adj_trx_lines_tbl(i).line_amount));
1345: arp_util.debug('receivables_trx_id => '||to_char(p_llca_adj_trx_lines_tbl(i).receivables_trx_id));
1346: arp_util.debug('=======================================================');
1347: END IF;

Line 1344: arp_util.debug('line_amount => '||to_char(p_llca_adj_trx_lines_tbl(i).line_amount));

1340: arp_util.debug('=======================================================');
1341: arp_util.debug(' Line .............=> '||to_char(i));
1342: arp_util.debug('customer_trx_id => '||to_char(p_customer_trx_id));
1343: arp_util.debug('customer_trx_line_id => '||to_char(p_llca_adj_trx_lines_tbl(i).customer_trx_line_id));
1344: arp_util.debug('line_amount => '||to_char(p_llca_adj_trx_lines_tbl(i).line_amount));
1345: arp_util.debug('receivables_trx_id => '||to_char(p_llca_adj_trx_lines_tbl(i).receivables_trx_id));
1346: arp_util.debug('=======================================================');
1347: END IF;
1348: End Loop;

Line 1345: arp_util.debug('receivables_trx_id => '||to_char(p_llca_adj_trx_lines_tbl(i).receivables_trx_id));

1341: arp_util.debug(' Line .............=> '||to_char(i));
1342: arp_util.debug('customer_trx_id => '||to_char(p_customer_trx_id));
1343: arp_util.debug('customer_trx_line_id => '||to_char(p_llca_adj_trx_lines_tbl(i).customer_trx_line_id));
1344: arp_util.debug('line_amount => '||to_char(p_llca_adj_trx_lines_tbl(i).line_amount));
1345: arp_util.debug('receivables_trx_id => '||to_char(p_llca_adj_trx_lines_tbl(i).receivables_trx_id));
1346: arp_util.debug('=======================================================');
1347: END IF;
1348: End Loop;
1349: End If;

Line 1346: arp_util.debug('=======================================================');

1342: arp_util.debug('customer_trx_id => '||to_char(p_customer_trx_id));
1343: arp_util.debug('customer_trx_line_id => '||to_char(p_llca_adj_trx_lines_tbl(i).customer_trx_line_id));
1344: arp_util.debug('line_amount => '||to_char(p_llca_adj_trx_lines_tbl(i).line_amount));
1345: arp_util.debug('receivables_trx_id => '||to_char(p_llca_adj_trx_lines_tbl(i).receivables_trx_id));
1346: arp_util.debug('=======================================================');
1347: END IF;
1348: End Loop;
1349: End If;
1350:

Line 1352: arp_util.debug('populate_adj_llca_gt ()- ');

1348: End Loop;
1349: End If;
1350:
1351: IF PG_DEBUG in ('Y', 'C') THEN
1352: arp_util.debug('populate_adj_llca_gt ()- ');
1353: END IF;
1354:
1355: EXCEPTION
1356: WHEN others THEN

Line 1358: arp_util.debug('EXCEPTION: (populate_adj_llca_gt)');

1354:
1355: EXCEPTION
1356: WHEN others THEN
1357: IF PG_DEBUG in ('Y', 'C') THEN
1358: arp_util.debug('EXCEPTION: (populate_adj_llca_gt)');
1359: END IF;
1360: p_return_status := FND_API.G_RET_STS_ERROR;
1361: raise;
1362: End populate_adj_llca_gt;

Line 1415: arp_util.debug('validate_hdr_level ()+ ');

1411: ll_mfar_adj varchar2(1);
1412:
1413: BEGIN
1414: IF PG_DEBUG in ('Y', 'C') THEN
1415: arp_util.debug('validate_hdr_level ()+ ');
1416: END IF;
1417:
1418: p_return_status := FND_API.G_RET_STS_SUCCESS;
1419:

Line 1430: arp_util.debug('create_linelevel_adjustment : ' || 'Error(s) occurred. Rolling back and setting status to ERROR');

1426: FND_MESSAGE.SET_TOKEN ( 'TYPE', p_adj_rec.TYPE ) ;
1427: FND_MSG_PUB.ADD ;
1428:
1429: IF PG_DEBUG in ('Y', 'C') THEN
1430: arp_util.debug('create_linelevel_adjustment : ' || 'Error(s) occurred. Rolling back and setting status to ERROR');
1431: arp_util.debug('create_linelevel_adjustment : ' || 'line level adjustment can only allowed for type LINE');
1432: END IF;
1433:
1434: END IF;

Line 1431: arp_util.debug('create_linelevel_adjustment : ' || 'line level adjustment can only allowed for type LINE');

1427: FND_MSG_PUB.ADD ;
1428:
1429: IF PG_DEBUG in ('Y', 'C') THEN
1430: arp_util.debug('create_linelevel_adjustment : ' || 'Error(s) occurred. Rolling back and setting status to ERROR');
1431: arp_util.debug('create_linelevel_adjustment : ' || 'line level adjustment can only allowed for type LINE');
1432: END IF;
1433:
1434: END IF;
1435:

Line 1444: arp_util.debug('create_linelevel_adjustment : ' || 'Warning(s) occurred. Ignoring header level customer trx line id');

1440: FND_MESSAGE.SET_TOKEN ( 'CUSTOMER_TRX_LINE_ID', p_adj_rec.customer_trx_line_id ) ;
1441: FND_MSG_PUB.ADD ;
1442:
1443: IF PG_DEBUG in ('Y', 'C') THEN
1444: arp_util.debug('create_linelevel_adjustment : ' || 'Warning(s) occurred. Ignoring header level customer trx line id');
1445:
1446: END IF;
1447:
1448: END IF;

Line 1459: arp_util.debug('create_linelevel_adjustment : ' || 'Warning(s) occurred. Ignoring header level receivables trx id');

1455: FND_MESSAGE.SET_TOKEN ( 'RECEIVABLES_TRX_ID', p_adj_rec.receivables_trx_id ) ;
1456: FND_MSG_PUB.ADD ;
1457:
1458: IF PG_DEBUG in ('Y', 'C') THEN
1459: arp_util.debug('create_linelevel_adjustment : ' || 'Warning(s) occurred. Ignoring header level receivables trx id');
1460:
1461: END IF;
1462:
1463: END IF;

Line 1472: arp_util.debug('create_linelevel_adjustment : ' || 'Warning(s) occurred. Ignoring header level Amount');

1468: FND_MESSAGE.SET_TOKEN ( 'AMOUNT', p_adj_rec.amount ) ;
1469: FND_MSG_PUB.ADD ;
1470:
1471: IF PG_DEBUG in ('Y', 'C') THEN
1472: arp_util.debug('create_linelevel_adjustment : ' || 'Warning(s) occurred. Ignoring header level Amount');
1473:
1474: END IF;
1475:
1476: END IF;

Line 1492: arp_util.debug('create_linelevel_adjustment : ' || 'Error(s) occurred. Rolling back and setting status to ERROR');

1488: FND_MESSAGE.SET_NAME ('AR', 'AR_LL_ADJ_INSTALL_NOT_ALLOWED');
1489: FND_MESSAGE.SET_TOKEN ( 'CUST_TRX_ID', p_adj_rec.customer_trx_id ) ;
1490: FND_MSG_PUB.ADD ;
1491: IF PG_DEBUG in ('Y', 'C') THEN
1492: arp_util.debug('create_linelevel_adjustment : ' || 'Error(s) occurred. Rolling back and setting status to ERROR');
1493: arp_util.debug('create_linelevel_adjustment : ' || 'Multiple Installment transaction not allowed at line-level');
1494: END IF;
1495:
1496: END IF;

Line 1493: arp_util.debug('create_linelevel_adjustment : ' || 'Multiple Installment transaction not allowed at line-level');

1489: FND_MESSAGE.SET_TOKEN ( 'CUST_TRX_ID', p_adj_rec.customer_trx_id ) ;
1490: FND_MSG_PUB.ADD ;
1491: IF PG_DEBUG in ('Y', 'C') THEN
1492: arp_util.debug('create_linelevel_adjustment : ' || 'Error(s) occurred. Rolling back and setting status to ERROR');
1493: arp_util.debug('create_linelevel_adjustment : ' || 'Multiple Installment transaction not allowed at line-level');
1494: END IF;
1495:
1496: END IF;
1497:

Line 1513: arp_util.debug('create_linelevel_adjustment : ' || 'Error(s) occurred. Rolling back and setting status to ERROR');

1509: FND_MESSAGE.SET_NAME ('AR', 'AR_LL_ADJ_LEGACY_NOT_ALLOWED');
1510: FND_MESSAGE.SET_TOKEN ( 'CUST_TRX_ID', p_adj_rec.customer_trx_id ) ;
1511: FND_MSG_PUB.ADD ;
1512: IF PG_DEBUG in ('Y', 'C') THEN
1513: arp_util.debug('create_linelevel_adjustment : ' || 'Error(s) occurred. Rolling back and setting status to ERROR');
1514: arp_util.debug('create_linelevel_adjustment : ' || 'Legacy data with activity not allowed at line-level');
1515: END IF;
1516:
1517: END IF;

Line 1514: arp_util.debug('create_linelevel_adjustment : ' || 'Legacy data with activity not allowed at line-level');

1510: FND_MESSAGE.SET_TOKEN ( 'CUST_TRX_ID', p_adj_rec.customer_trx_id ) ;
1511: FND_MSG_PUB.ADD ;
1512: IF PG_DEBUG in ('Y', 'C') THEN
1513: arp_util.debug('create_linelevel_adjustment : ' || 'Error(s) occurred. Rolling back and setting status to ERROR');
1514: arp_util.debug('create_linelevel_adjustment : ' || 'Legacy data with activity not allowed at line-level');
1515: END IF;
1516:
1517: END IF;
1518:

Line 1528: arp_util.debug('validate_hdr_level ()- ');

1524:
1525: p_return_status := l_return_status;
1526:
1527: IF PG_DEBUG in ('Y', 'C') THEN
1528: arp_util.debug('validate_hdr_level ()- ');
1529: END IF;
1530:
1531: EXCEPTION
1532: when others then

Line 1534: arp_util.debug('EXCEPTION: (validate_hdr_level)');

1530:
1531: EXCEPTION
1532: when others then
1533: IF PG_DEBUG in ('Y', 'C') THEN
1534: arp_util.debug('EXCEPTION: (validate_hdr_level)');
1535: END IF;
1536: p_return_status := FND_API.G_RET_STS_ERROR;
1537: raise;
1538:

Line 1682: arp_util.debug('Create_Adjustment: ' || 'Compatility error occurred.');

1678: G_PKG_NAME
1679: )
1680: THEN
1681: IF PG_DEBUG in ('Y', 'C') THEN
1682: arp_util.debug('Create_Adjustment: ' || 'Compatility error occurred.');
1683: END IF;
1684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1685: END IF;
1686:

Line 1696: -- arp_util.enable_debug(100000);

1692: THEN
1693: FND_MSG_PUB.initialize;
1694: END IF;
1695:
1696: -- arp_util.enable_debug(100000);
1697:
1698: IF PG_DEBUG in ('Y', 'C') THEN
1699: arp_util.debug('Create_Adjustment()+ ');
1700: END IF;

Line 1699: arp_util.debug('Create_Adjustment()+ ');

1695:
1696: -- arp_util.enable_debug(100000);
1697:
1698: IF PG_DEBUG in ('Y', 'C') THEN
1699: arp_util.debug('Create_Adjustment()+ ');
1700: END IF;
1701:
1702: /*-----------------------------------------+
1703: | Initialize return status to SUCCESS |

Line 1746: arp_util.debug('Create_Adjustment: ' || ' Init_context_rec has errors ' );

1742: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
1743: THEN
1744: p_return_status := l_return_status ;
1745: IF PG_DEBUG in ('Y', 'C') THEN
1746: arp_util.debug('Create_Adjustment: ' || ' Init_context_rec has errors ' );
1747: END IF;
1748: END IF;
1749:
1750:

Line 1767: arp_util.debug('Create_Adjustment: ' || ' Cache_details has errors ' );

1763: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
1764: THEN
1765: p_return_status := l_return_status ;
1766: IF PG_DEBUG in ('Y', 'C') THEN
1767: arp_util.debug('Create_Adjustment: ' || ' Cache_details has errors ' );
1768: END IF;
1769: END IF;
1770:
1771: /*------------------------------------------+

Line 1848: arp_util.debug('Create_Adjustment: ' || 'Validation error(s) occurred. '||

1844: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
1845: THEN
1846: p_return_status := l_return_status ;
1847: IF PG_DEBUG in ('Y', 'C') THEN
1848: arp_util.debug('Create_Adjustment: ' || 'Validation error(s) occurred. '||
1849: 'and setting status to ERROR');
1850: END IF;
1851: END IF;
1852:

Line 1882: arp_util.debug('Create_Adjustment: ' ||

1878: THEN
1879:
1880: p_return_status := l_return_status ;
1881: IF PG_DEBUG in ('Y', 'C') THEN
1882: arp_util.debug('Create_Adjustment: ' ||
1883: 'Validation error(s) occurred. Rolling back '||
1884: 'and setting status to ERROR');
1885: END IF;
1886:

Line 1911: arp_util.debug('Create_Adjustment: ' || 'l_inp_adj_rec.line_adjusted = ' || to_char(l_inp_adj_rec.line_adjusted));

1907: l_override_flag := 'Y';
1908: END IF;
1909:
1910: IF PG_DEBUG in ('Y', 'C') THEN
1911: arp_util.debug('Create_Adjustment: ' || 'l_inp_adj_rec.line_adjusted = ' || to_char(l_inp_adj_rec.line_adjusted));
1912: arp_util.debug('Create_Adjustment: ' || 'l_inp_adj_rec.tax_adjusted = ' || to_char(l_inp_adj_rec.tax_adjusted));
1913: END IF;
1914:
1915: BEGIN

Line 1912: arp_util.debug('Create_Adjustment: ' || 'l_inp_adj_rec.tax_adjusted = ' || to_char(l_inp_adj_rec.tax_adjusted));

1908: END IF;
1909:
1910: IF PG_DEBUG in ('Y', 'C') THEN
1911: arp_util.debug('Create_Adjustment: ' || 'l_inp_adj_rec.line_adjusted = ' || to_char(l_inp_adj_rec.line_adjusted));
1912: arp_util.debug('Create_Adjustment: ' || 'l_inp_adj_rec.tax_adjusted = ' || to_char(l_inp_adj_rec.tax_adjusted));
1913: END IF;
1914:
1915: BEGIN
1916: arp_process_adjustment.insert_adjustment (

Line 1955: arp_util.debug('Create_Adjustment: ' ||

1951: p_count => p_msg_count,
1952: p_data => p_msg_data
1953: );
1954: IF PG_DEBUG in ('Y', 'C') THEN
1955: arp_util.debug('Create_Adjustment: ' ||
1956: 'Error in Insert Entity handler. Rolling back ' ||
1957: 'and setting status to ERROR');
1958: END IF;
1959: RETURN;

Line 1988: arp_util.debug('Create_Adjustment: ' || 'committing');

1984:
1985: IF FND_API.To_Boolean( p_commit_flag )
1986: THEN
1987: IF PG_DEBUG in ('Y', 'C') THEN
1988: arp_util.debug('Create_Adjustment: ' || 'committing');
1989: END IF;
1990: Commit;
1991: END IF;
1992:

Line 1994: arp_util.debug('Create_Adjustment()- ');

1990: Commit;
1991: END IF;
1992:
1993: IF PG_DEBUG in ('Y', 'C') THEN
1994: arp_util.debug('Create_Adjustment()- ');
1995: END IF;
1996:
1997: IF (FND_MSG_PUB.Check_Msg_Level (G_MSG_LOW)) THEN
1998: select TO_CHAR( (hsecs - G_START_TIME) / 100)

Line 2002: arp_util.debug('Create_Adjustment: ' || 'Elapsed Time : '||l_hsec||' seconds');

1998: select TO_CHAR( (hsecs - G_START_TIME) / 100)
1999: into l_hsec
2000: from v$timer;
2001: IF PG_DEBUG in ('Y', 'C') THEN
2002: arp_util.debug('Create_Adjustment: ' || 'Elapsed Time : '||l_hsec||' seconds');
2003: END IF;
2004: END IF;
2005:
2006: EXCEPTION

Line 2010: arp_util.debug('Create_Adjustment: ' || SQLCODE);

2006: EXCEPTION
2007: WHEN FND_API.G_EXC_ERROR THEN
2008:
2009: IF PG_DEBUG in ('Y', 'C') THEN
2010: arp_util.debug('Create_Adjustment: ' || SQLCODE);
2011: arp_util.debug('Create_Adjustment: ' || SQLERRM);
2012: END IF;
2013:
2014: ROLLBACK TO ar_adjust_PUB;

Line 2011: arp_util.debug('Create_Adjustment: ' || SQLERRM);

2007: WHEN FND_API.G_EXC_ERROR THEN
2008:
2009: IF PG_DEBUG in ('Y', 'C') THEN
2010: arp_util.debug('Create_Adjustment: ' || SQLCODE);
2011: arp_util.debug('Create_Adjustment: ' || SQLERRM);
2012: END IF;
2013:
2014: ROLLBACK TO ar_adjust_PUB;
2015: p_return_status := FND_API.G_RET_STS_ERROR ;

Line 2024: arp_util.debug('Create_Adjustment: ' || SQLERRM);

2020:
2021: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2022:
2023: IF PG_DEBUG in ('Y', 'C') THEN
2024: arp_util.debug('Create_Adjustment: ' || SQLERRM);
2025: END IF;
2026: ROLLBACK TO ar_adjust_PUB ;
2027: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2028: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

Line 2046: arp_util.debug('Create_Adjustment: ' ||

2042: THEN
2043: p_return_status := FND_API.G_RET_STS_ERROR ;
2044: ROLLBACK TO ar_adjust_PUB;
2045: IF PG_DEBUG in ('Y', 'C') THEN
2046: arp_util.debug('Create_Adjustment: ' ||
2047: 'Completion validation error(s) occurred. ' ||
2048: 'Rolling back and setting status to ERROR');
2049: END IF;
2050:

Line 2060: arp_util.disable_debug;

2056: ELSE
2057: NULL;
2058: END IF;
2059:
2060: arp_util.disable_debug;
2061:
2062: END Create_Adjustment;
2063:
2064:

Line 2194: arp_util.debug('create_linelevel_adjustment : ' || 'Compatility error occurred.');

2190: G_PKG_NAME
2191: )
2192: THEN
2193: IF PG_DEBUG in ('Y', 'C') THEN
2194: arp_util.debug('create_linelevel_adjustment : ' || 'Compatility error occurred.');
2195: END IF;
2196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2197: END IF;
2198:

Line 2208: -- arp_util.enable_debug(100000);

2204: THEN
2205: FND_MSG_PUB.initialize;
2206: END IF;
2207:
2208: -- arp_util.enable_debug(100000);
2209:
2210: IF PG_DEBUG in ('Y', 'C') THEN
2211: arp_util.debug('create_linelevel_adjustment()+ ');
2212: END IF;

Line 2211: arp_util.debug('create_linelevel_adjustment()+ ');

2207:
2208: -- arp_util.enable_debug(100000);
2209:
2210: IF PG_DEBUG in ('Y', 'C') THEN
2211: arp_util.debug('create_linelevel_adjustment()+ ');
2212: END IF;
2213:
2214: /*-----------------------------------------+
2215: | Initialize return status to SUCCESS |

Line 2265: arp_util.debug('create_linelevel_adjustment: ' || ' Init_context_rec has errors ' );

2261: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
2262: THEN
2263: p_return_status := l_return_status ;
2264: IF PG_DEBUG in ('Y', 'C') THEN
2265: arp_util.debug('create_linelevel_adjustment: ' || ' Init_context_rec has errors ' );
2266: END IF;
2267: END IF;
2268:
2269:

Line 2286: arp_util.debug('create_linelevel_adjustment: ' || ' Cache_details has errors ' );

2282: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
2283: THEN
2284: p_return_status := l_return_status ;
2285: IF PG_DEBUG in ('Y', 'C') THEN
2286: arp_util.debug('create_linelevel_adjustment: ' || ' Cache_details has errors ' );
2287: END IF;
2288: END IF;
2289:
2290: /*------------------------------------------+

Line 2334: arp_util.debug('create_linelevel_adjustment : ' || 'Error(s) occurred. Rolling back and setting status to ERROR');

2330:
2331: p_return_status := FND_API.G_RET_STS_ERROR ;
2332:
2333: IF PG_DEBUG in ('Y', 'C') THEN
2334: arp_util.debug('create_linelevel_adjustment : ' || 'Error(s) occurred. Rolling back and setting status to ERROR');
2335: arp_util.debug('create_linelevel_adjustment : ' || 'Error while populating GT table');
2336: END IF;
2337:
2338: END IF;

Line 2335: arp_util.debug('create_linelevel_adjustment : ' || 'Error while populating GT table');

2331: p_return_status := FND_API.G_RET_STS_ERROR ;
2332:
2333: IF PG_DEBUG in ('Y', 'C') THEN
2334: arp_util.debug('create_linelevel_adjustment : ' || 'Error(s) occurred. Rolling back and setting status to ERROR');
2335: arp_util.debug('create_linelevel_adjustment : ' || 'Error while populating GT table');
2336: END IF;
2337:
2338: END IF;
2339:

Line 2364: arp_util.debug('create_linelevel_adjustment : ' || 'Error(s) occurred. Rolling back and setting status to ERROR');

2360: THEN
2361: p_return_status := FND_API.G_RET_STS_ERROR ;
2362:
2363: IF PG_DEBUG in ('Y', 'C') THEN
2364: arp_util.debug('create_linelevel_adjustment : ' || 'Error(s) occurred. Rolling back and setting status to ERROR');
2365: arp_util.debug('create_linelevel_adjustment : ' || 'Error while populating GT table');
2366: END IF;
2367:
2368: END IF;

Line 2365: arp_util.debug('create_linelevel_adjustment : ' || 'Error while populating GT table');

2361: p_return_status := FND_API.G_RET_STS_ERROR ;
2362:
2363: IF PG_DEBUG in ('Y', 'C') THEN
2364: arp_util.debug('create_linelevel_adjustment : ' || 'Error(s) occurred. Rolling back and setting status to ERROR');
2365: arp_util.debug('create_linelevel_adjustment : ' || 'Error while populating GT table');
2366: END IF;
2367:
2368: END IF;
2369:

Line 2463: arp_util.debug('create_linelevel_adjustment: ' || 'Validation error(s) occurred.');

2459: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
2460: THEN
2461: l_line_return_status := l_return_status ;
2462: IF PG_DEBUG in ('Y', 'C') THEN
2463: arp_util.debug('create_linelevel_adjustment: ' || 'Validation error(s) occurred.');
2464: END IF;
2465: END IF;
2466:
2467:

Line 2486: arp_util.debug('create_linelevel_adjustment: ' ||

2482: THEN
2483:
2484: l_line_return_status := l_return_status ;
2485: IF PG_DEBUG in ('Y', 'C') THEN
2486: arp_util.debug('create_linelevel_adjustment: ' ||
2487: 'Validation error(s) occurred.');
2488: END IF;
2489:
2490: END IF;

Line 2509: arp_util.debug('create_linelevel_adjustment: ' || 'l_inp_adj_rec.line_adjusted = ' || to_char(l_inp_adj_rec.line_adjusted));

2505: l_override_flag := 'Y';
2506: END IF;
2507:
2508: IF PG_DEBUG in ('Y', 'C') THEN
2509: arp_util.debug('create_linelevel_adjustment: ' || 'l_inp_adj_rec.line_adjusted = ' || to_char(l_inp_adj_rec.line_adjusted));
2510: arp_util.debug('create_linelevel_adjustment: ' || 'l_inp_adj_rec.tax_adjusted = ' || to_char(l_inp_adj_rec.tax_adjusted));
2511: END IF;
2512:
2513: BEGIN

Line 2510: arp_util.debug('create_linelevel_adjustment: ' || 'l_inp_adj_rec.tax_adjusted = ' || to_char(l_inp_adj_rec.tax_adjusted));

2506: END IF;
2507:
2508: IF PG_DEBUG in ('Y', 'C') THEN
2509: arp_util.debug('create_linelevel_adjustment: ' || 'l_inp_adj_rec.line_adjusted = ' || to_char(l_inp_adj_rec.line_adjusted));
2510: arp_util.debug('create_linelevel_adjustment: ' || 'l_inp_adj_rec.tax_adjusted = ' || to_char(l_inp_adj_rec.tax_adjusted));
2511: END IF;
2512:
2513: BEGIN
2514: arp_process_adjustment.insert_adjustment (

Line 2555: arp_util.debug('create_linelevel_adjustment: ' ||

2551: p_count => p_msg_count,
2552: p_data => p_msg_data
2553: );
2554: IF PG_DEBUG in ('Y', 'C') THEN
2555: arp_util.debug('create_linelevel_adjustment: ' ||
2556: 'Error in Insert Entity handler. Rolling back ' ||
2557: 'and setting status to ERROR');
2558: END IF;
2559: RETURN;

Line 2597: arp_util.debug('create_linelevel_adjustment: ' || 'committing');

2593:
2594: IF FND_API.To_Boolean( p_commit_flag )
2595: THEN
2596: IF PG_DEBUG in ('Y', 'C') THEN
2597: arp_util.debug('create_linelevel_adjustment: ' || 'committing');
2598: END IF;
2599: Commit;
2600: END IF;
2601:

Line 2603: arp_util.debug('create_linelevel_adjustment()- ');

2599: Commit;
2600: END IF;
2601:
2602: IF PG_DEBUG in ('Y', 'C') THEN
2603: arp_util.debug('create_linelevel_adjustment()- ');
2604: END IF;
2605:
2606: IF (FND_MSG_PUB.Check_Msg_Level (G_MSG_LOW)) THEN
2607: select TO_CHAR( (hsecs - G_START_TIME) / 100)

Line 2611: arp_util.debug('create_linelevel_adjustment: ' || 'Elapsed Time : '||l_hsec||' seconds');

2607: select TO_CHAR( (hsecs - G_START_TIME) / 100)
2608: into l_hsec
2609: from v$timer;
2610: IF PG_DEBUG in ('Y', 'C') THEN
2611: arp_util.debug('create_linelevel_adjustment: ' || 'Elapsed Time : '||l_hsec||' seconds');
2612: END IF;
2613: END IF;
2614:
2615: EXCEPTION

Line 2619: arp_util.debug('create_linelevel_adjustment: ' || SQLCODE);

2615: EXCEPTION
2616: WHEN FND_API.G_EXC_ERROR THEN
2617:
2618: IF PG_DEBUG in ('Y', 'C') THEN
2619: arp_util.debug('create_linelevel_adjustment: ' || SQLCODE);
2620: arp_util.debug('create_linelevel_adjustment: ' || SQLERRM);
2621: END IF;
2622:
2623: ROLLBACK TO ar_adjust_line_PUB;

Line 2620: arp_util.debug('create_linelevel_adjustment: ' || SQLERRM);

2616: WHEN FND_API.G_EXC_ERROR THEN
2617:
2618: IF PG_DEBUG in ('Y', 'C') THEN
2619: arp_util.debug('create_linelevel_adjustment: ' || SQLCODE);
2620: arp_util.debug('create_linelevel_adjustment: ' || SQLERRM);
2621: END IF;
2622:
2623: ROLLBACK TO ar_adjust_line_PUB;
2624: p_return_status := FND_API.G_RET_STS_ERROR ;

Line 2633: arp_util.debug('create_linelevel_adjustment: ' || SQLERRM);

2629:
2630: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2631:
2632: IF PG_DEBUG in ('Y', 'C') THEN
2633: arp_util.debug('create_linelevel_adjustment: ' || SQLERRM);
2634: END IF;
2635: ROLLBACK TO ar_adjust_line_PUB ;
2636: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2637: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

Line 2655: arp_util.debug('create_linelevel_adjustment: ' ||

2651: THEN
2652: p_return_status := FND_API.G_RET_STS_ERROR ;
2653: ROLLBACK TO ar_adjust_line_PUB;
2654: IF PG_DEBUG in ('Y', 'C') THEN
2655: arp_util.debug('create_linelevel_adjustment: ' ||
2656: 'Completion validation error(s) occurred. ' ||
2657: 'Rolling back and setting status to ERROR');
2658: END IF;
2659:

Line 2669: arp_util.disable_debug;

2665: ELSE
2666: NULL;
2667: END IF;
2668:
2669: arp_util.disable_debug;
2670:
2671: END create_linelevel_adjustment;
2672:
2673:

Line 2786: arp_util.debug('Modify_Adjustment: ' || 'Compatility error occurred.');

2782: G_PKG_NAME
2783: )
2784: THEN
2785: IF PG_DEBUG in ('Y', 'C') THEN
2786: arp_util.debug('Modify_Adjustment: ' || 'Compatility error occurred.');
2787: END IF;
2788: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2789: END IF;
2790:

Line 2800: -- arp_util.enable_debug(100000);

2796: THEN
2797: FND_MSG_PUB.initialize;
2798: END IF;
2799:
2800: -- arp_util.enable_debug(100000);
2801:
2802:
2803: IF PG_DEBUG in ('Y', 'C') THEN
2804: arp_util.debug('Modify_Adjustment()+ ');

Line 2804: arp_util.debug('Modify_Adjustment()+ ');

2800: -- arp_util.enable_debug(100000);
2801:
2802:
2803: IF PG_DEBUG in ('Y', 'C') THEN
2804: arp_util.debug('Modify_Adjustment()+ ');
2805: END IF;
2806:
2807: /*-----------------------------------------+
2808: | Initialize return status to SUCCESS |

Line 2850: arp_util.debug('Modify_Adjustment: ' || 'failed to initialize the profile options ');

2846: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
2847: THEN
2848: p_return_status := l_return_status ;
2849: IF PG_DEBUG in ('Y', 'C') THEN
2850: arp_util.debug('Modify_Adjustment: ' || 'failed to initialize the profile options ');
2851: END IF;
2852: END IF;
2853:
2854: /*------------------------------------------------+

Line 2869: arp_util.debug('Modify_Adjustment: ' || 'failed to cache details ');

2865: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
2866: THEN
2867: p_return_status := l_return_status ;
2868: IF PG_DEBUG in ('Y', 'C') THEN
2869: arp_util.debug('Modify_Adjustment: ' || 'failed to cache details ');
2870: END IF;
2871: END IF;
2872:
2873: /*------------------------------------------------+

Line 2936: arp_util.debug('Modify_Adjustment: ' ||

2932: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
2933: THEN
2934: p_return_status := l_return_status ;
2935: IF PG_DEBUG in ('Y', 'C') THEN
2936: arp_util.debug('Modify_Adjustment: ' ||
2937: 'Validation error(s) occurred. Rolling back ' ||
2938: 'and setting status to ERROR');
2939: END IF;
2940: END IF;

Line 2992: arp_util.debug('Modify_Adjustment: ' ||

2988: p_count => p_msg_count,
2989: p_data => p_msg_data
2990: );
2991: IF PG_DEBUG in ('Y', 'C') THEN
2992: arp_util.debug('Modify_Adjustment: ' ||
2993: 'Error in Insert Entity handler. Rolling back '||
2994: 'and setting status to ERROR');
2995: END IF;
2996:

Line 3023: arp_util.debug('Modify_Adjustment: ' || 'committing');

3019:
3020: IF FND_API.To_Boolean( p_commit_flag )
3021: THEN
3022: IF PG_DEBUG in ('Y', 'C') THEN
3023: arp_util.debug('Modify_Adjustment: ' || 'committing');
3024: END IF;
3025: Commit;
3026: END IF;
3027:

Line 3029: arp_util.debug('Modify_Adjustment()- ');

3025: Commit;
3026: END IF;
3027:
3028: IF PG_DEBUG in ('Y', 'C') THEN
3029: arp_util.debug('Modify_Adjustment()- ');
3030: END IF;
3031:
3032: IF (FND_MSG_PUB.Check_Msg_Level (G_MSG_LOW)) THEN
3033: select TO_CHAR( (hsecs - G_START_TIME) / 100)

Line 3037: arp_util.debug('Modify_Adjustment: ' || 'Elapsed Time : '||l_hsec||' seconds');

3033: select TO_CHAR( (hsecs - G_START_TIME) / 100)
3034: into l_hsec
3035: from v$timer;
3036: IF PG_DEBUG in ('Y', 'C') THEN
3037: arp_util.debug('Modify_Adjustment: ' || 'Elapsed Time : '||l_hsec||' seconds');
3038: END IF;
3039: END IF;
3040:
3041:

Line 3047: arp_util.debug('Modify_Adjustment: ' || SQLCODE);

3043: EXCEPTION
3044: WHEN FND_API.G_EXC_ERROR THEN
3045:
3046: IF PG_DEBUG in ('Y', 'C') THEN
3047: arp_util.debug('Modify_Adjustment: ' || SQLCODE);
3048: arp_util.debug('Modify_Adjustment: ' || SQLERRM);
3049: END IF;
3050:
3051: ROLLBACK TO ar_adjust_PUB;

Line 3048: arp_util.debug('Modify_Adjustment: ' || SQLERRM);

3044: WHEN FND_API.G_EXC_ERROR THEN
3045:
3046: IF PG_DEBUG in ('Y', 'C') THEN
3047: arp_util.debug('Modify_Adjustment: ' || SQLCODE);
3048: arp_util.debug('Modify_Adjustment: ' || SQLERRM);
3049: END IF;
3050:
3051: ROLLBACK TO ar_adjust_PUB;
3052: p_return_status := FND_API.G_RET_STS_ERROR ;

Line 3061: arp_util.debug('Modify_Adjustment: ' || SQLERRM);

3057:
3058: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3059:
3060: IF PG_DEBUG in ('Y', 'C') THEN
3061: arp_util.debug('Modify_Adjustment: ' || SQLERRM);
3062: END IF;
3063: ROLLBACK TO ar_adjust_PUB ;
3064: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3065: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

Line 3083: arp_util.debug('Modify_Adjustment: ' ||

3079: THEN
3080: p_return_status := FND_API.G_RET_STS_ERROR ;
3081: ROLLBACK TO ar_adjust_PUB;
3082: IF PG_DEBUG in ('Y', 'C') THEN
3083: arp_util.debug('Modify_Adjustment: ' ||
3084: 'Completion validation error(s) occurred. ' ||
3085: 'Rolling back and setting status to ERROR');
3086: END IF;
3087: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

Line 3096: arp_util.disable_debug;

3092: ELSE
3093: NULL;
3094: END IF;
3095:
3096: arp_util.disable_debug;
3097:
3098: END Modify_Adjustment;
3099:
3100:

Line 3230: arp_util.debug('Reverse_Adjustment: ' || 'Compatility error occurred.');

3226: G_PKG_NAME
3227: )
3228: THEN
3229: IF PG_DEBUG in ('Y', 'C') THEN
3230: arp_util.debug('Reverse_Adjustment: ' || 'Compatility error occurred.');
3231: END IF;
3232: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3233: END IF;
3234:

Line 3244: -- arp_util.enable_debug(100000);

3240: THEN
3241: FND_MSG_PUB.initialize;
3242: END IF;
3243:
3244: -- arp_util.enable_debug(100000);
3245:
3246:
3247: IF PG_DEBUG in ('Y', 'C') THEN
3248: arp_util.debug('Reverse_Adjustment()+ ');

Line 3248: arp_util.debug('Reverse_Adjustment()+ ');

3244: -- arp_util.enable_debug(100000);
3245:
3246:
3247: IF PG_DEBUG in ('Y', 'C') THEN
3248: arp_util.debug('Reverse_Adjustment()+ ');
3249: END IF;
3250:
3251: /*-----------------------------------------+
3252: | Initialize return status to SUCCESS |

Line 3288: arp_util.debug('Reverse_Adjustment: ' || ' failed to Initialize the profile options ');

3284: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
3285: THEN
3286: p_return_status := l_return_status ;
3287: IF PG_DEBUG in ('Y', 'C') THEN
3288: arp_util.debug('Reverse_Adjustment: ' || ' failed to Initialize the profile options ');
3289: END IF;
3290: END IF;
3291:
3292: /*------------------------------------------------+

Line 3332: arp_util.debug('Reverse_Adjustment: ' || ' failed to Cache_Details ');

3328: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
3329: THEN
3330: p_return_status := l_return_status ;
3331: IF PG_DEBUG in ('Y', 'C') THEN
3332: arp_util.debug('Reverse_Adjustment: ' || ' failed to Cache_Details ');
3333: END IF;
3334: END IF;
3335:
3336: /*--------------------------------------------+

Line 3361: arp_util.debug('Reverse_Adjustment: ' ||

3357: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
3358: THEN
3359: p_return_status := l_return_status ;
3360: IF PG_DEBUG in ('Y', 'C') THEN
3361: arp_util.debug('Reverse_Adjustment: ' ||
3362: 'Validation error(s) occurred. Rolling back '||
3363: 'and setting status to ERROR');
3364: END IF;
3365: END IF;

Line 3384: arp_util.debug('Reverse_Adjustment: ' || 'Preparing the values for the new adjustment');

3380: | The new adjustment record should have the date and gl_date |
3381: | same as the reversal date and gl_date. |
3382: +------------------------------------------------------------*/
3383: IF PG_DEBUG in ('Y', 'C') THEN
3384: arp_util.debug('Reverse_Adjustment: ' || 'Preparing the values for the new adjustment');
3385: END IF;
3386:
3387: -- setting all the new values for the new adjustment
3388:

Line 3454: arp_util.debug('Reverse_Adjustment: ' || '--------------------------------------------------');

3450: l_adj_rec.doc_sequence_id := NULL;
3451: l_adj_rec.doc_sequence_value := NULL;
3452:
3453: IF PG_DEBUG in ('Y', 'C') THEN
3454: arp_util.debug('Reverse_Adjustment: ' || '--------------------------------------------------');
3455: arp_util.debug('Reverse_Adjustment: ' || 'New values for the new adjustment');
3456: arp_util.debug('Reverse_Adjustment: ' || 'status = ' || l_adj_rec.status );
3457: arp_util.debug('Reverse_Adjustment: ' || 'adjustment_id = ' || l_adj_rec.adjustment_id );
3458: arp_util.debug('Reverse_Adjustment: ' || 'apply_date = ' || l_adj_rec.apply_date );

Line 3455: arp_util.debug('Reverse_Adjustment: ' || 'New values for the new adjustment');

3451: l_adj_rec.doc_sequence_value := NULL;
3452:
3453: IF PG_DEBUG in ('Y', 'C') THEN
3454: arp_util.debug('Reverse_Adjustment: ' || '--------------------------------------------------');
3455: arp_util.debug('Reverse_Adjustment: ' || 'New values for the new adjustment');
3456: arp_util.debug('Reverse_Adjustment: ' || 'status = ' || l_adj_rec.status );
3457: arp_util.debug('Reverse_Adjustment: ' || 'adjustment_id = ' || l_adj_rec.adjustment_id );
3458: arp_util.debug('Reverse_Adjustment: ' || 'apply_date = ' || l_adj_rec.apply_date );
3459: arp_util.debug('Reverse_Adjustment: ' || 'gl_date = ' || l_adj_rec.gl_date );

Line 3456: arp_util.debug('Reverse_Adjustment: ' || 'status = ' || l_adj_rec.status );

3452:
3453: IF PG_DEBUG in ('Y', 'C') THEN
3454: arp_util.debug('Reverse_Adjustment: ' || '--------------------------------------------------');
3455: arp_util.debug('Reverse_Adjustment: ' || 'New values for the new adjustment');
3456: arp_util.debug('Reverse_Adjustment: ' || 'status = ' || l_adj_rec.status );
3457: arp_util.debug('Reverse_Adjustment: ' || 'adjustment_id = ' || l_adj_rec.adjustment_id );
3458: arp_util.debug('Reverse_Adjustment: ' || 'apply_date = ' || l_adj_rec.apply_date );
3459: arp_util.debug('Reverse_Adjustment: ' || 'gl_date = ' || l_adj_rec.gl_date );
3460: arp_util.debug('Reverse_Adjustment: ' || 'amount = ' || l_adj_rec.amount );

Line 3457: arp_util.debug('Reverse_Adjustment: ' || 'adjustment_id = ' || l_adj_rec.adjustment_id );

3453: IF PG_DEBUG in ('Y', 'C') THEN
3454: arp_util.debug('Reverse_Adjustment: ' || '--------------------------------------------------');
3455: arp_util.debug('Reverse_Adjustment: ' || 'New values for the new adjustment');
3456: arp_util.debug('Reverse_Adjustment: ' || 'status = ' || l_adj_rec.status );
3457: arp_util.debug('Reverse_Adjustment: ' || 'adjustment_id = ' || l_adj_rec.adjustment_id );
3458: arp_util.debug('Reverse_Adjustment: ' || 'apply_date = ' || l_adj_rec.apply_date );
3459: arp_util.debug('Reverse_Adjustment: ' || 'gl_date = ' || l_adj_rec.gl_date );
3460: arp_util.debug('Reverse_Adjustment: ' || 'amount = ' || l_adj_rec.amount );
3461: arp_util.debug('Reverse_Adjustment: ' || 'acctd_amount = ' || l_adj_rec.acctd_amount );

Line 3458: arp_util.debug('Reverse_Adjustment: ' || 'apply_date = ' || l_adj_rec.apply_date );

3454: arp_util.debug('Reverse_Adjustment: ' || '--------------------------------------------------');
3455: arp_util.debug('Reverse_Adjustment: ' || 'New values for the new adjustment');
3456: arp_util.debug('Reverse_Adjustment: ' || 'status = ' || l_adj_rec.status );
3457: arp_util.debug('Reverse_Adjustment: ' || 'adjustment_id = ' || l_adj_rec.adjustment_id );
3458: arp_util.debug('Reverse_Adjustment: ' || 'apply_date = ' || l_adj_rec.apply_date );
3459: arp_util.debug('Reverse_Adjustment: ' || 'gl_date = ' || l_adj_rec.gl_date );
3460: arp_util.debug('Reverse_Adjustment: ' || 'amount = ' || l_adj_rec.amount );
3461: arp_util.debug('Reverse_Adjustment: ' || 'acctd_amount = ' || l_adj_rec.acctd_amount );
3462: arp_util.debug('Reverse_Adjustment: ' || 'line_adjusted = ' || l_adj_rec.line_adjusted);

Line 3459: arp_util.debug('Reverse_Adjustment: ' || 'gl_date = ' || l_adj_rec.gl_date );

3455: arp_util.debug('Reverse_Adjustment: ' || 'New values for the new adjustment');
3456: arp_util.debug('Reverse_Adjustment: ' || 'status = ' || l_adj_rec.status );
3457: arp_util.debug('Reverse_Adjustment: ' || 'adjustment_id = ' || l_adj_rec.adjustment_id );
3458: arp_util.debug('Reverse_Adjustment: ' || 'apply_date = ' || l_adj_rec.apply_date );
3459: arp_util.debug('Reverse_Adjustment: ' || 'gl_date = ' || l_adj_rec.gl_date );
3460: arp_util.debug('Reverse_Adjustment: ' || 'amount = ' || l_adj_rec.amount );
3461: arp_util.debug('Reverse_Adjustment: ' || 'acctd_amount = ' || l_adj_rec.acctd_amount );
3462: arp_util.debug('Reverse_Adjustment: ' || 'line_adjusted = ' || l_adj_rec.line_adjusted);
3463: arp_util.debug('Reverse_Adjustment: ' || 'freight_adjusted = ' || l_adj_rec.freight_adjusted );

Line 3460: arp_util.debug('Reverse_Adjustment: ' || 'amount = ' || l_adj_rec.amount );

3456: arp_util.debug('Reverse_Adjustment: ' || 'status = ' || l_adj_rec.status );
3457: arp_util.debug('Reverse_Adjustment: ' || 'adjustment_id = ' || l_adj_rec.adjustment_id );
3458: arp_util.debug('Reverse_Adjustment: ' || 'apply_date = ' || l_adj_rec.apply_date );
3459: arp_util.debug('Reverse_Adjustment: ' || 'gl_date = ' || l_adj_rec.gl_date );
3460: arp_util.debug('Reverse_Adjustment: ' || 'amount = ' || l_adj_rec.amount );
3461: arp_util.debug('Reverse_Adjustment: ' || 'acctd_amount = ' || l_adj_rec.acctd_amount );
3462: arp_util.debug('Reverse_Adjustment: ' || 'line_adjusted = ' || l_adj_rec.line_adjusted);
3463: arp_util.debug('Reverse_Adjustment: ' || 'freight_adjusted = ' || l_adj_rec.freight_adjusted );
3464: arp_util.debug('Reverse_Adjustment: ' || 'tax_adjusted = ' || l_adj_rec.tax_adjusted);

Line 3461: arp_util.debug('Reverse_Adjustment: ' || 'acctd_amount = ' || l_adj_rec.acctd_amount );

3457: arp_util.debug('Reverse_Adjustment: ' || 'adjustment_id = ' || l_adj_rec.adjustment_id );
3458: arp_util.debug('Reverse_Adjustment: ' || 'apply_date = ' || l_adj_rec.apply_date );
3459: arp_util.debug('Reverse_Adjustment: ' || 'gl_date = ' || l_adj_rec.gl_date );
3460: arp_util.debug('Reverse_Adjustment: ' || 'amount = ' || l_adj_rec.amount );
3461: arp_util.debug('Reverse_Adjustment: ' || 'acctd_amount = ' || l_adj_rec.acctd_amount );
3462: arp_util.debug('Reverse_Adjustment: ' || 'line_adjusted = ' || l_adj_rec.line_adjusted);
3463: arp_util.debug('Reverse_Adjustment: ' || 'freight_adjusted = ' || l_adj_rec.freight_adjusted );
3464: arp_util.debug('Reverse_Adjustment: ' || 'tax_adjusted = ' || l_adj_rec.tax_adjusted);
3465: arp_util.debug('Reverse_Adjustment: ' || 'receivables_charges_adjusted = ' || l_adj_rec.receivables_charges_adjusted );

Line 3462: arp_util.debug('Reverse_Adjustment: ' || 'line_adjusted = ' || l_adj_rec.line_adjusted);

3458: arp_util.debug('Reverse_Adjustment: ' || 'apply_date = ' || l_adj_rec.apply_date );
3459: arp_util.debug('Reverse_Adjustment: ' || 'gl_date = ' || l_adj_rec.gl_date );
3460: arp_util.debug('Reverse_Adjustment: ' || 'amount = ' || l_adj_rec.amount );
3461: arp_util.debug('Reverse_Adjustment: ' || 'acctd_amount = ' || l_adj_rec.acctd_amount );
3462: arp_util.debug('Reverse_Adjustment: ' || 'line_adjusted = ' || l_adj_rec.line_adjusted);
3463: arp_util.debug('Reverse_Adjustment: ' || 'freight_adjusted = ' || l_adj_rec.freight_adjusted );
3464: arp_util.debug('Reverse_Adjustment: ' || 'tax_adjusted = ' || l_adj_rec.tax_adjusted);
3465: arp_util.debug('Reverse_Adjustment: ' || 'receivables_charges_adjusted = ' || l_adj_rec.receivables_charges_adjusted );
3466: arp_util.debug('Reverse_Adjustment: ' || 'created_from = ' || l_adj_rec.created_from );

Line 3463: arp_util.debug('Reverse_Adjustment: ' || 'freight_adjusted = ' || l_adj_rec.freight_adjusted );

3459: arp_util.debug('Reverse_Adjustment: ' || 'gl_date = ' || l_adj_rec.gl_date );
3460: arp_util.debug('Reverse_Adjustment: ' || 'amount = ' || l_adj_rec.amount );
3461: arp_util.debug('Reverse_Adjustment: ' || 'acctd_amount = ' || l_adj_rec.acctd_amount );
3462: arp_util.debug('Reverse_Adjustment: ' || 'line_adjusted = ' || l_adj_rec.line_adjusted);
3463: arp_util.debug('Reverse_Adjustment: ' || 'freight_adjusted = ' || l_adj_rec.freight_adjusted );
3464: arp_util.debug('Reverse_Adjustment: ' || 'tax_adjusted = ' || l_adj_rec.tax_adjusted);
3465: arp_util.debug('Reverse_Adjustment: ' || 'receivables_charges_adjusted = ' || l_adj_rec.receivables_charges_adjusted );
3466: arp_util.debug('Reverse_Adjustment: ' || 'created_from = ' || l_adj_rec.created_from );
3467: arp_util.debug('Reverse_Adjustment: ' || 'comments = ' || l_adj_rec.comments);

Line 3464: arp_util.debug('Reverse_Adjustment: ' || 'tax_adjusted = ' || l_adj_rec.tax_adjusted);

3460: arp_util.debug('Reverse_Adjustment: ' || 'amount = ' || l_adj_rec.amount );
3461: arp_util.debug('Reverse_Adjustment: ' || 'acctd_amount = ' || l_adj_rec.acctd_amount );
3462: arp_util.debug('Reverse_Adjustment: ' || 'line_adjusted = ' || l_adj_rec.line_adjusted);
3463: arp_util.debug('Reverse_Adjustment: ' || 'freight_adjusted = ' || l_adj_rec.freight_adjusted );
3464: arp_util.debug('Reverse_Adjustment: ' || 'tax_adjusted = ' || l_adj_rec.tax_adjusted);
3465: arp_util.debug('Reverse_Adjustment: ' || 'receivables_charges_adjusted = ' || l_adj_rec.receivables_charges_adjusted );
3466: arp_util.debug('Reverse_Adjustment: ' || 'created_from = ' || l_adj_rec.created_from );
3467: arp_util.debug('Reverse_Adjustment: ' || 'comments = ' || l_adj_rec.comments);
3468: arp_util.debug('Reverse_Adjustment: ' || '--------------------------------------------------');

Line 3465: arp_util.debug('Reverse_Adjustment: ' || 'receivables_charges_adjusted = ' || l_adj_rec.receivables_charges_adjusted );

3461: arp_util.debug('Reverse_Adjustment: ' || 'acctd_amount = ' || l_adj_rec.acctd_amount );
3462: arp_util.debug('Reverse_Adjustment: ' || 'line_adjusted = ' || l_adj_rec.line_adjusted);
3463: arp_util.debug('Reverse_Adjustment: ' || 'freight_adjusted = ' || l_adj_rec.freight_adjusted );
3464: arp_util.debug('Reverse_Adjustment: ' || 'tax_adjusted = ' || l_adj_rec.tax_adjusted);
3465: arp_util.debug('Reverse_Adjustment: ' || 'receivables_charges_adjusted = ' || l_adj_rec.receivables_charges_adjusted );
3466: arp_util.debug('Reverse_Adjustment: ' || 'created_from = ' || l_adj_rec.created_from );
3467: arp_util.debug('Reverse_Adjustment: ' || 'comments = ' || l_adj_rec.comments);
3468: arp_util.debug('Reverse_Adjustment: ' || '--------------------------------------------------');
3469: END IF;

Line 3466: arp_util.debug('Reverse_Adjustment: ' || 'created_from = ' || l_adj_rec.created_from );

3462: arp_util.debug('Reverse_Adjustment: ' || 'line_adjusted = ' || l_adj_rec.line_adjusted);
3463: arp_util.debug('Reverse_Adjustment: ' || 'freight_adjusted = ' || l_adj_rec.freight_adjusted );
3464: arp_util.debug('Reverse_Adjustment: ' || 'tax_adjusted = ' || l_adj_rec.tax_adjusted);
3465: arp_util.debug('Reverse_Adjustment: ' || 'receivables_charges_adjusted = ' || l_adj_rec.receivables_charges_adjusted );
3466: arp_util.debug('Reverse_Adjustment: ' || 'created_from = ' || l_adj_rec.created_from );
3467: arp_util.debug('Reverse_Adjustment: ' || 'comments = ' || l_adj_rec.comments);
3468: arp_util.debug('Reverse_Adjustment: ' || '--------------------------------------------------');
3469: END IF;
3470:

Line 3467: arp_util.debug('Reverse_Adjustment: ' || 'comments = ' || l_adj_rec.comments);

3463: arp_util.debug('Reverse_Adjustment: ' || 'freight_adjusted = ' || l_adj_rec.freight_adjusted );
3464: arp_util.debug('Reverse_Adjustment: ' || 'tax_adjusted = ' || l_adj_rec.tax_adjusted);
3465: arp_util.debug('Reverse_Adjustment: ' || 'receivables_charges_adjusted = ' || l_adj_rec.receivables_charges_adjusted );
3466: arp_util.debug('Reverse_Adjustment: ' || 'created_from = ' || l_adj_rec.created_from );
3467: arp_util.debug('Reverse_Adjustment: ' || 'comments = ' || l_adj_rec.comments);
3468: arp_util.debug('Reverse_Adjustment: ' || '--------------------------------------------------');
3469: END IF;
3470:
3471:

Line 3468: arp_util.debug('Reverse_Adjustment: ' || '--------------------------------------------------');

3464: arp_util.debug('Reverse_Adjustment: ' || 'tax_adjusted = ' || l_adj_rec.tax_adjusted);
3465: arp_util.debug('Reverse_Adjustment: ' || 'receivables_charges_adjusted = ' || l_adj_rec.receivables_charges_adjusted );
3466: arp_util.debug('Reverse_Adjustment: ' || 'created_from = ' || l_adj_rec.created_from );
3467: arp_util.debug('Reverse_Adjustment: ' || 'comments = ' || l_adj_rec.comments);
3468: arp_util.debug('Reverse_Adjustment: ' || '--------------------------------------------------');
3469: END IF;
3470:
3471:
3472: l_check_amount := FND_API.G_FALSE;

Line 3509: arp_util.debug('Reverse_Adjustment: ' ||

3505: p_return_status := FND_API.G_RET_STS_ERROR;
3506: ELSE
3507: IF PG_DEBUG in ('Y', 'C') THEN
3508: p_new_adj_id := l_llca_adj_create_tbl_type(1).adjustment_id;
3509: arp_util.debug('Reverse_Adjustment: ' ||
3510: 'After Create_Adjustment , new_adjustment_id = ' ||
3511: p_new_adj_id || ' new_adjustment_num = ' || l_llca_adj_create_tbl_type(1).adjustment_number);
3512: END IF;
3513: END IF;

Line 3538: arp_util.debug('Reverse_Adjustment: ' ||

3534: IF p_new_adj_id IS NULL THEN
3535: p_return_status := FND_API.G_RET_STS_ERROR;
3536: ELSE
3537: IF PG_DEBUG in ('Y', 'C') THEN
3538: arp_util.debug('Reverse_Adjustment: ' ||
3539: 'After Create_Adjustment , new_adjustment_id = ' ||
3540: p_new_adj_id || ' new_adjustment_num = ' || l_new_adj_num);
3541: END IF;
3542: END IF;

Line 3564: arp_util.debug('Reverse_Adjustment: ' ||

3560: p_count => p_msg_count,
3561: p_data => p_msg_data
3562: );
3563: IF PG_DEBUG in ('Y', 'C') THEN
3564: arp_util.debug('Reverse_Adjustment: ' ||
3565: 'Error in Insert Entity handler. Rolling back ' ||
3566: 'and setting status to ERROR');
3567: END IF;
3568: if (l_msg_count > 0) then

Line 3570: arp_util.debug('Reverse_Adjustment: ' || l_msg_data);

3566: 'and setting status to ERROR');
3567: END IF;
3568: if (l_msg_count > 0) then
3569: IF PG_DEBUG in ('Y', 'C') THEN
3570: arp_util.debug('Reverse_Adjustment: ' || l_msg_data);
3571: END IF;
3572: end if;
3573:
3574: RETURN;

Line 3601: arp_util.debug('Reverse_Adjustment: ' || 'committing');

3597:
3598: IF FND_API.To_Boolean( p_commit_flag )
3599: THEN
3600: IF PG_DEBUG in ('Y', 'C') THEN
3601: arp_util.debug('Reverse_Adjustment: ' || 'committing');
3602: END IF;
3603: Commit;
3604: END IF;
3605:

Line 3607: arp_util.debug('Reverse_Adjustment()- ');

3603: Commit;
3604: END IF;
3605:
3606: IF PG_DEBUG in ('Y', 'C') THEN
3607: arp_util.debug('Reverse_Adjustment()- ');
3608: END IF;
3609:
3610: IF (FND_MSG_PUB.Check_Msg_Level (G_MSG_LOW)) THEN
3611: select TO_CHAR( (hsecs - G_START_TIME) / 100)

Line 3615: arp_util.debug('Reverse_Adjustment: ' || 'Elapsed Time : '||l_hsec||' seconds');

3611: select TO_CHAR( (hsecs - G_START_TIME) / 100)
3612: into l_hsec
3613: from v$timer;
3614: IF PG_DEBUG in ('Y', 'C') THEN
3615: arp_util.debug('Reverse_Adjustment: ' || 'Elapsed Time : '||l_hsec||' seconds');
3616: END IF;
3617: END IF;
3618:
3619:

Line 3624: arp_util.debug('Reverse_Adjustment: ' || SQLCODE);

3620: EXCEPTION
3621: WHEN FND_API.G_EXC_ERROR THEN
3622:
3623: IF PG_DEBUG in ('Y', 'C') THEN
3624: arp_util.debug('Reverse_Adjustment: ' || SQLCODE);
3625: arp_util.debug('Reverse_Adjustment: ' || SQLERRM);
3626: END IF;
3627:
3628: ROLLBACK TO ar_adjust_PUB;

Line 3625: arp_util.debug('Reverse_Adjustment: ' || SQLERRM);

3621: WHEN FND_API.G_EXC_ERROR THEN
3622:
3623: IF PG_DEBUG in ('Y', 'C') THEN
3624: arp_util.debug('Reverse_Adjustment: ' || SQLCODE);
3625: arp_util.debug('Reverse_Adjustment: ' || SQLERRM);
3626: END IF;
3627:
3628: ROLLBACK TO ar_adjust_PUB;
3629: p_return_status := FND_API.G_RET_STS_ERROR ;

Line 3638: arp_util.debug('Reverse_Adjustment: ' || SQLERRM);

3634:
3635: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3636:
3637: IF PG_DEBUG in ('Y', 'C') THEN
3638: arp_util.debug('Reverse_Adjustment: ' || SQLERRM);
3639: END IF;
3640: ROLLBACK TO ar_adjust_PUB ;
3641: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3642: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

Line 3660: arp_util.debug('Reverse_Adjustment: ' ||

3656: THEN
3657: p_return_status := FND_API.G_RET_STS_ERROR ;
3658: ROLLBACK TO ar_adjust_PUB;
3659: IF PG_DEBUG in ('Y', 'C') THEN
3660: arp_util.debug('Reverse_Adjustment: ' ||
3661: 'Completion validation error(s) occurred. ' ||
3662: 'Rolling back and setting status to ERROR');
3663: END IF;
3664:

Line 3674: arp_util.disable_debug;

3670: ELSE
3671: NULL;
3672: END IF;
3673:
3674: arp_util.disable_debug;
3675:
3676: END Reverse_Adjustment;
3677:
3678:

Line 3794: arp_util.debug('Approve_Adjustment: ' || 'Compatility error occurred.');

3790: G_PKG_NAME
3791: )
3792: THEN
3793: IF PG_DEBUG in ('Y', 'C') THEN
3794: arp_util.debug('Approve_Adjustment: ' || 'Compatility error occurred.');
3795: END IF;
3796: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3797: END IF;
3798:

Line 3808: -- arp_util.enable_debug(100000);

3804: THEN
3805: FND_MSG_PUB.initialize;
3806: END IF;
3807:
3808: -- arp_util.enable_debug(100000);
3809:
3810:
3811: IF PG_DEBUG in ('Y', 'C') THEN
3812: arp_util.debug('Approve_Adjustment()+ ');

Line 3812: arp_util.debug('Approve_Adjustment()+ ');

3808: -- arp_util.enable_debug(100000);
3809:
3810:
3811: IF PG_DEBUG in ('Y', 'C') THEN
3812: arp_util.debug('Approve_Adjustment()+ ');
3813: END IF;
3814:
3815: /*-----------------------------------------+
3816: | Initialize return status to SUCCESS |

Line 3863: arp_util.debug('Approve_Adjustment: ' || 'failed to Initialize the profile options ');

3859: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
3860: THEN
3861: p_return_status := l_return_status ;
3862: IF PG_DEBUG in ('Y', 'C') THEN
3863: arp_util.debug('Approve_Adjustment: ' || 'failed to Initialize the profile options ');
3864: END IF;
3865: END IF;
3866:
3867: /*------------------------------------------------+

Line 3882: arp_util.debug('Approve_Adjustment: ' || 'failed to Initialize the profile options ');

3878: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
3879: THEN
3880: p_return_status := l_return_status ;
3881: IF PG_DEBUG in ('Y', 'C') THEN
3882: arp_util.debug('Approve_Adjustment: ' || 'failed to Initialize the profile options ');
3883: END IF;
3884: END IF;
3885:
3886: /*------------------------------------------------+

Line 3940: arp_util.debug('Approve_Adjustment: ' ||

3936: THEN
3937:
3938: p_return_status := l_return_status ;
3939: IF PG_DEBUG in ('Y', 'C') THEN
3940: arp_util.debug('Approve_Adjustment: ' ||
3941: 'Validation error(s) occurred. Rolling back ' ||
3942: 'and setting status to ERROR');
3943: END IF;
3944: END IF;

Line 4003: arp_util.debug('Approve_Adjustment: ' ||

3999: p_data => p_msg_data
4000: );
4001:
4002: IF PG_DEBUG in ('Y', 'C') THEN
4003: arp_util.debug('Approve_Adjustment: ' ||
4004: 'Error in Insert Entity handler. Rolling back ' ||
4005: 'and setting status to ERROR');
4006: END IF;
4007:

Line 4035: arp_util.debug('Approve_Adjustment: ' || 'committing');

4031:
4032: IF FND_API.To_Boolean( p_commit_flag )
4033: THEN
4034: IF PG_DEBUG in ('Y', 'C') THEN
4035: arp_util.debug('Approve_Adjustment: ' || 'committing');
4036: END IF;
4037: Commit;
4038: END IF;
4039:

Line 4041: arp_util.debug('Approve_Adjustment()- ');

4037: Commit;
4038: END IF;
4039:
4040: IF PG_DEBUG in ('Y', 'C') THEN
4041: arp_util.debug('Approve_Adjustment()- ');
4042: END IF;
4043:
4044: IF (FND_MSG_PUB.Check_Msg_Level (G_MSG_LOW)) THEN
4045: select TO_CHAR( (hsecs - G_START_TIME) / 100)

Line 4049: arp_util.debug('Approve_Adjustment: ' || 'Elapsed Time : '||l_hsec||' seconds');

4045: select TO_CHAR( (hsecs - G_START_TIME) / 100)
4046: into l_hsec
4047: from v$timer;
4048: IF PG_DEBUG in ('Y', 'C') THEN
4049: arp_util.debug('Approve_Adjustment: ' || 'Elapsed Time : '||l_hsec||' seconds');
4050: END IF;
4051: END IF;
4052:
4053:

Line 4058: arp_util.debug('Approve_Adjustment: ' || SQLCODE);

4054: EXCEPTION
4055: WHEN FND_API.G_EXC_ERROR THEN
4056:
4057: IF PG_DEBUG in ('Y', 'C') THEN
4058: arp_util.debug('Approve_Adjustment: ' || SQLCODE);
4059: arp_util.debug('Approve_Adjustment: ' || SQLERRM);
4060: END IF;
4061:
4062: ROLLBACK TO ar_adjust_PUB;

Line 4059: arp_util.debug('Approve_Adjustment: ' || SQLERRM);

4055: WHEN FND_API.G_EXC_ERROR THEN
4056:
4057: IF PG_DEBUG in ('Y', 'C') THEN
4058: arp_util.debug('Approve_Adjustment: ' || SQLCODE);
4059: arp_util.debug('Approve_Adjustment: ' || SQLERRM);
4060: END IF;
4061:
4062: ROLLBACK TO ar_adjust_PUB;
4063: p_return_status := FND_API.G_RET_STS_ERROR ;

Line 4072: arp_util.debug('Approve_Adjustment: ' || SQLERRM);

4068:
4069: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4070:
4071: IF PG_DEBUG in ('Y', 'C') THEN
4072: arp_util.debug('Approve_Adjustment: ' || SQLERRM);
4073: END IF;
4074: ROLLBACK TO ar_adjust_PUB ;
4075: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4076: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

Line 4094: arp_util.debug('Approve_Adjustment: ' ||

4090: THEN
4091: p_return_status := FND_API.G_RET_STS_ERROR ;
4092: ROLLBACK TO ar_adjust_PUB;
4093: IF PG_DEBUG in ('Y', 'C') THEN
4094: arp_util.debug('Approve_Adjustment: ' ||
4095: 'Completion validation error(s) occurred. ' ||
4096: 'Rolling back and setting status to ERROR');
4097: END IF;
4098:

Line 4108: arp_util.disable_debug;

4104: ELSE
4105: NULL;
4106: END IF;
4107:
4108: arp_util.disable_debug;
4109:
4110: END Approve_Adjustment;
4111:
4112: