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.

[Home] [Help]

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 2258: arp_util.debug('create_linelevel_adjustment: ' || ' Init_context_rec has errors ' );

2254: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
2255: THEN
2256: p_return_status := l_return_status ;
2257: IF PG_DEBUG in ('Y', 'C') THEN
2258: arp_util.debug('create_linelevel_adjustment: ' || ' Init_context_rec has errors ' );
2259: END IF;
2260: END IF;
2261:
2262:

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

2275: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
2276: THEN
2277: p_return_status := l_return_status ;
2278: IF PG_DEBUG in ('Y', 'C') THEN
2279: arp_util.debug('create_linelevel_adjustment: ' || ' Cache_details has errors ' );
2280: END IF;
2281: END IF;
2282:
2283: /*------------------------------------------+

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

2323:
2324: p_return_status := FND_API.G_RET_STS_ERROR ;
2325:
2326: IF PG_DEBUG in ('Y', 'C') THEN
2327: arp_util.debug('create_linelevel_adjustment : ' || 'Error(s) occurred. Rolling back and setting status to ERROR');
2328: arp_util.debug('create_linelevel_adjustment : ' || 'Error while populating GT table');
2329: END IF;
2330:
2331: END IF;

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

2324: p_return_status := FND_API.G_RET_STS_ERROR ;
2325:
2326: IF PG_DEBUG in ('Y', 'C') THEN
2327: arp_util.debug('create_linelevel_adjustment : ' || 'Error(s) occurred. Rolling back and setting status to ERROR');
2328: arp_util.debug('create_linelevel_adjustment : ' || 'Error while populating GT table');
2329: END IF;
2330:
2331: END IF;
2332:

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

2353: THEN
2354: p_return_status := FND_API.G_RET_STS_ERROR ;
2355:
2356: IF PG_DEBUG in ('Y', 'C') THEN
2357: arp_util.debug('create_linelevel_adjustment : ' || 'Error(s) occurred. Rolling back and setting status to ERROR');
2358: arp_util.debug('create_linelevel_adjustment : ' || 'Error while populating GT table');
2359: END IF;
2360:
2361: END IF;

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

2354: p_return_status := FND_API.G_RET_STS_ERROR ;
2355:
2356: IF PG_DEBUG in ('Y', 'C') THEN
2357: arp_util.debug('create_linelevel_adjustment : ' || 'Error(s) occurred. Rolling back and setting status to ERROR');
2358: arp_util.debug('create_linelevel_adjustment : ' || 'Error while populating GT table');
2359: END IF;
2360:
2361: END IF;
2362:

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

2452: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
2453: THEN
2454: l_line_return_status := l_return_status ;
2455: IF PG_DEBUG in ('Y', 'C') THEN
2456: arp_util.debug('create_linelevel_adjustment: ' || 'Validation error(s) occurred.');
2457: END IF;
2458: END IF;
2459:
2460:

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

2475: THEN
2476:
2477: l_line_return_status := l_return_status ;
2478: IF PG_DEBUG in ('Y', 'C') THEN
2479: arp_util.debug('create_linelevel_adjustment: ' ||
2480: 'Validation error(s) occurred.');
2481: END IF;
2482:
2483: END IF;

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

2495: l_override_flag := 'Y';
2496: END IF;
2497:
2498: IF PG_DEBUG in ('Y', 'C') THEN
2499: arp_util.debug('create_linelevel_adjustment: ' || 'l_inp_adj_rec.line_adjusted = ' || to_char(l_inp_adj_rec.line_adjusted));
2500: arp_util.debug('create_linelevel_adjustment: ' || 'l_inp_adj_rec.tax_adjusted = ' || to_char(l_inp_adj_rec.tax_adjusted));
2501: END IF;
2502:
2503: BEGIN

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

2496: END IF;
2497:
2498: IF PG_DEBUG in ('Y', 'C') THEN
2499: arp_util.debug('create_linelevel_adjustment: ' || 'l_inp_adj_rec.line_adjusted = ' || to_char(l_inp_adj_rec.line_adjusted));
2500: arp_util.debug('create_linelevel_adjustment: ' || 'l_inp_adj_rec.tax_adjusted = ' || to_char(l_inp_adj_rec.tax_adjusted));
2501: END IF;
2502:
2503: BEGIN
2504: arp_process_adjustment.insert_adjustment (

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

2541: p_count => p_msg_count,
2542: p_data => p_msg_data
2543: );
2544: IF PG_DEBUG in ('Y', 'C') THEN
2545: arp_util.debug('create_linelevel_adjustment: ' ||
2546: 'Error in Insert Entity handler. Rolling back ' ||
2547: 'and setting status to ERROR');
2548: END IF;
2549: RETURN;

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

2583:
2584: IF FND_API.To_Boolean( p_commit_flag )
2585: THEN
2586: IF PG_DEBUG in ('Y', 'C') THEN
2587: arp_util.debug('create_linelevel_adjustment: ' || 'committing');
2588: END IF;
2589: Commit;
2590: END IF;
2591:

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

2589: Commit;
2590: END IF;
2591:
2592: IF PG_DEBUG in ('Y', 'C') THEN
2593: arp_util.debug('create_linelevel_adjustment()- ');
2594: END IF;
2595:
2596: IF (FND_MSG_PUB.Check_Msg_Level (G_MSG_LOW)) THEN
2597: select TO_CHAR( (hsecs - G_START_TIME) / 100)

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

2597: select TO_CHAR( (hsecs - G_START_TIME) / 100)
2598: into l_hsec
2599: from v$timer;
2600: IF PG_DEBUG in ('Y', 'C') THEN
2601: arp_util.debug('create_linelevel_adjustment: ' || 'Elapsed Time : '||l_hsec||' seconds');
2602: END IF;
2603: END IF;
2604:
2605: EXCEPTION

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

2605: EXCEPTION
2606: WHEN FND_API.G_EXC_ERROR THEN
2607:
2608: IF PG_DEBUG in ('Y', 'C') THEN
2609: arp_util.debug('create_linelevel_adjustment: ' || SQLCODE);
2610: arp_util.debug('create_linelevel_adjustment: ' || SQLERRM);
2611: END IF;
2612:
2613: ROLLBACK TO ar_adjust_line_PUB;

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

2606: WHEN FND_API.G_EXC_ERROR THEN
2607:
2608: IF PG_DEBUG in ('Y', 'C') THEN
2609: arp_util.debug('create_linelevel_adjustment: ' || SQLCODE);
2610: arp_util.debug('create_linelevel_adjustment: ' || SQLERRM);
2611: END IF;
2612:
2613: ROLLBACK TO ar_adjust_line_PUB;
2614: p_return_status := FND_API.G_RET_STS_ERROR ;

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

2619:
2620: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2621:
2622: IF PG_DEBUG in ('Y', 'C') THEN
2623: arp_util.debug('create_linelevel_adjustment: ' || SQLERRM);
2624: END IF;
2625: ROLLBACK TO ar_adjust_line_PUB ;
2626: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2627: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

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

2641: THEN
2642: p_return_status := FND_API.G_RET_STS_ERROR ;
2643: ROLLBACK TO ar_adjust_line_PUB;
2644: IF PG_DEBUG in ('Y', 'C') THEN
2645: arp_util.debug('create_linelevel_adjustment: ' ||
2646: 'Completion validation error(s) occurred. ' ||
2647: 'Rolling back and setting status to ERROR');
2648: END IF;
2649:

Line 2659: arp_util.disable_debug;

2655: ELSE
2656: NULL;
2657: END IF;
2658:
2659: arp_util.disable_debug;
2660:
2661: END create_linelevel_adjustment;
2662:
2663:

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

2773: G_PKG_NAME
2774: )
2775: THEN
2776: IF PG_DEBUG in ('Y', 'C') THEN
2777: arp_util.debug('Modify_Adjustment: ' || 'Compatility error occurred.');
2778: END IF;
2779: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2780: END IF;
2781:

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

2787: THEN
2788: FND_MSG_PUB.initialize;
2789: END IF;
2790:
2791: -- arp_util.enable_debug(100000);
2792:
2793:
2794: IF PG_DEBUG in ('Y', 'C') THEN
2795: arp_util.debug('Modify_Adjustment()+ ');

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

2791: -- arp_util.enable_debug(100000);
2792:
2793:
2794: IF PG_DEBUG in ('Y', 'C') THEN
2795: arp_util.debug('Modify_Adjustment()+ ');
2796: END IF;
2797:
2798: /*-----------------------------------------+
2799: | Initialize return status to SUCCESS |

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

2837: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
2838: THEN
2839: p_return_status := l_return_status ;
2840: IF PG_DEBUG in ('Y', 'C') THEN
2841: arp_util.debug('Modify_Adjustment: ' || 'failed to initialize the profile options ');
2842: END IF;
2843: END IF;
2844:
2845: /*------------------------------------------------+

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

2856: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
2857: THEN
2858: p_return_status := l_return_status ;
2859: IF PG_DEBUG in ('Y', 'C') THEN
2860: arp_util.debug('Modify_Adjustment: ' || 'failed to cache details ');
2861: END IF;
2862: END IF;
2863:
2864: /*------------------------------------------------+

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

2902:
2903: IF l_count_chk <> 0 THEN
2904: p_return_status := FND_API.G_RET_STS_ERROR ;
2905: IF PG_DEBUG in ('Y', 'C') THEN
2906: arp_util.debug('Modify_Adjustment: ' ||
2907: 'Validation error(s) occurred. Rolling back ' ||
2908: 'and setting status to ERROR');
2909: END IF;
2910:

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

2953: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
2954: THEN
2955: p_return_status := l_return_status ;
2956: IF PG_DEBUG in ('Y', 'C') THEN
2957: arp_util.debug('Modify_Adjustment: ' ||
2958: 'Validation error(s) occurred. Rolling back ' ||
2959: 'and setting status to ERROR');
2960: END IF;
2961: END IF;

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

3009: p_count => p_msg_count,
3010: p_data => p_msg_data
3011: );
3012: IF PG_DEBUG in ('Y', 'C') THEN
3013: arp_util.debug('Modify_Adjustment: ' ||
3014: 'Error in Insert Entity handler. Rolling back '||
3015: 'and setting status to ERROR');
3016: END IF;
3017:

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

3040:
3041: IF FND_API.To_Boolean( p_commit_flag )
3042: THEN
3043: IF PG_DEBUG in ('Y', 'C') THEN
3044: arp_util.debug('Modify_Adjustment: ' || 'committing');
3045: END IF;
3046: Commit;
3047: END IF;
3048:

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

3046: Commit;
3047: END IF;
3048:
3049: IF PG_DEBUG in ('Y', 'C') THEN
3050: arp_util.debug('Modify_Adjustment()- ');
3051: END IF;
3052:
3053: IF (FND_MSG_PUB.Check_Msg_Level (G_MSG_LOW)) THEN
3054: select TO_CHAR( (hsecs - G_START_TIME) / 100)

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

3054: select TO_CHAR( (hsecs - G_START_TIME) / 100)
3055: into l_hsec
3056: from v$timer;
3057: IF PG_DEBUG in ('Y', 'C') THEN
3058: arp_util.debug('Modify_Adjustment: ' || 'Elapsed Time : '||l_hsec||' seconds');
3059: END IF;
3060: END IF;
3061:
3062:

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

3064: EXCEPTION
3065: WHEN FND_API.G_EXC_ERROR THEN
3066:
3067: IF PG_DEBUG in ('Y', 'C') THEN
3068: arp_util.debug('Modify_Adjustment: ' || SQLCODE);
3069: arp_util.debug('Modify_Adjustment: ' || SQLERRM);
3070: END IF;
3071:
3072: ROLLBACK TO ar_adjust_PUB;

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

3065: WHEN FND_API.G_EXC_ERROR THEN
3066:
3067: IF PG_DEBUG in ('Y', 'C') THEN
3068: arp_util.debug('Modify_Adjustment: ' || SQLCODE);
3069: arp_util.debug('Modify_Adjustment: ' || SQLERRM);
3070: END IF;
3071:
3072: ROLLBACK TO ar_adjust_PUB;
3073: p_return_status := FND_API.G_RET_STS_ERROR ;

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

3078:
3079: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3080:
3081: IF PG_DEBUG in ('Y', 'C') THEN
3082: arp_util.debug('Modify_Adjustment: ' || SQLERRM);
3083: END IF;
3084: ROLLBACK TO ar_adjust_PUB ;
3085: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3086: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

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

3100: THEN
3101: p_return_status := FND_API.G_RET_STS_ERROR ;
3102: ROLLBACK TO ar_adjust_PUB;
3103: IF PG_DEBUG in ('Y', 'C') THEN
3104: arp_util.debug('Modify_Adjustment: ' ||
3105: 'Completion validation error(s) occurred. ' ||
3106: 'Rolling back and setting status to ERROR');
3107: END IF;
3108: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

Line 3117: arp_util.disable_debug;

3113: ELSE
3114: NULL;
3115: END IF;
3116:
3117: arp_util.disable_debug;
3118:
3119: END Modify_Adjustment;
3120:
3121:

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

3247: G_PKG_NAME
3248: )
3249: THEN
3250: IF PG_DEBUG in ('Y', 'C') THEN
3251: arp_util.debug('Reverse_Adjustment: ' || 'Compatility error occurred.');
3252: END IF;
3253: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3254: END IF;
3255:

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

3261: THEN
3262: FND_MSG_PUB.initialize;
3263: END IF;
3264:
3265: -- arp_util.enable_debug(100000);
3266:
3267:
3268: IF PG_DEBUG in ('Y', 'C') THEN
3269: arp_util.debug('Reverse_Adjustment()+ ');

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

3265: -- arp_util.enable_debug(100000);
3266:
3267:
3268: IF PG_DEBUG in ('Y', 'C') THEN
3269: arp_util.debug('Reverse_Adjustment()+ ');
3270: END IF;
3271:
3272: /*-----------------------------------------+
3273: | Initialize return status to SUCCESS |

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

3305: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
3306: THEN
3307: p_return_status := l_return_status ;
3308: IF PG_DEBUG in ('Y', 'C') THEN
3309: arp_util.debug('Reverse_Adjustment: ' || ' failed to Initialize the profile options ');
3310: END IF;
3311: END IF;
3312:
3313: /*------------------------------------------------+

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

3349: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
3350: THEN
3351: p_return_status := l_return_status ;
3352: IF PG_DEBUG in ('Y', 'C') THEN
3353: arp_util.debug('Reverse_Adjustment: ' || ' failed to Cache_Details ');
3354: END IF;
3355: END IF;
3356:
3357: /*--------------------------------------------+

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

3378: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
3379: THEN
3380: p_return_status := l_return_status ;
3381: IF PG_DEBUG in ('Y', 'C') THEN
3382: arp_util.debug('Reverse_Adjustment: ' ||
3383: 'Validation error(s) occurred. Rolling back '||
3384: 'and setting status to ERROR');
3385: END IF;
3386: END IF;

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

3401: | The new adjustment record should have the date and gl_date |
3402: | same as the reversal date and gl_date. |
3403: +------------------------------------------------------------*/
3404: IF PG_DEBUG in ('Y', 'C') THEN
3405: arp_util.debug('Reverse_Adjustment: ' || 'Preparing the values for the new adjustment');
3406: END IF;
3407:
3408: -- setting all the new values for the new adjustment
3409:

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

3471: l_adj_rec.doc_sequence_id := NULL;
3472: l_adj_rec.doc_sequence_value := NULL;
3473:
3474: IF PG_DEBUG in ('Y', 'C') THEN
3475: arp_util.debug('Reverse_Adjustment: ' || '--------------------------------------------------');
3476: arp_util.debug('Reverse_Adjustment: ' || 'New values for the new adjustment');
3477: arp_util.debug('Reverse_Adjustment: ' || 'status = ' || l_adj_rec.status );
3478: arp_util.debug('Reverse_Adjustment: ' || 'adjustment_id = ' || l_adj_rec.adjustment_id );
3479: arp_util.debug('Reverse_Adjustment: ' || 'apply_date = ' || l_adj_rec.apply_date );

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

3472: l_adj_rec.doc_sequence_value := NULL;
3473:
3474: IF PG_DEBUG in ('Y', 'C') THEN
3475: arp_util.debug('Reverse_Adjustment: ' || '--------------------------------------------------');
3476: arp_util.debug('Reverse_Adjustment: ' || 'New values for the new adjustment');
3477: arp_util.debug('Reverse_Adjustment: ' || 'status = ' || l_adj_rec.status );
3478: arp_util.debug('Reverse_Adjustment: ' || 'adjustment_id = ' || l_adj_rec.adjustment_id );
3479: arp_util.debug('Reverse_Adjustment: ' || 'apply_date = ' || l_adj_rec.apply_date );
3480: arp_util.debug('Reverse_Adjustment: ' || 'gl_date = ' || l_adj_rec.gl_date );

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

3473:
3474: IF PG_DEBUG in ('Y', 'C') THEN
3475: arp_util.debug('Reverse_Adjustment: ' || '--------------------------------------------------');
3476: arp_util.debug('Reverse_Adjustment: ' || 'New values for the new adjustment');
3477: arp_util.debug('Reverse_Adjustment: ' || 'status = ' || l_adj_rec.status );
3478: arp_util.debug('Reverse_Adjustment: ' || 'adjustment_id = ' || l_adj_rec.adjustment_id );
3479: arp_util.debug('Reverse_Adjustment: ' || 'apply_date = ' || l_adj_rec.apply_date );
3480: arp_util.debug('Reverse_Adjustment: ' || 'gl_date = ' || l_adj_rec.gl_date );
3481: arp_util.debug('Reverse_Adjustment: ' || 'amount = ' || l_adj_rec.amount );

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

3474: IF PG_DEBUG in ('Y', 'C') THEN
3475: arp_util.debug('Reverse_Adjustment: ' || '--------------------------------------------------');
3476: arp_util.debug('Reverse_Adjustment: ' || 'New values for the new adjustment');
3477: arp_util.debug('Reverse_Adjustment: ' || 'status = ' || l_adj_rec.status );
3478: arp_util.debug('Reverse_Adjustment: ' || 'adjustment_id = ' || l_adj_rec.adjustment_id );
3479: arp_util.debug('Reverse_Adjustment: ' || 'apply_date = ' || l_adj_rec.apply_date );
3480: arp_util.debug('Reverse_Adjustment: ' || 'gl_date = ' || l_adj_rec.gl_date );
3481: arp_util.debug('Reverse_Adjustment: ' || 'amount = ' || l_adj_rec.amount );
3482: arp_util.debug('Reverse_Adjustment: ' || 'acctd_amount = ' || l_adj_rec.acctd_amount );

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

3475: arp_util.debug('Reverse_Adjustment: ' || '--------------------------------------------------');
3476: arp_util.debug('Reverse_Adjustment: ' || 'New values for the new adjustment');
3477: arp_util.debug('Reverse_Adjustment: ' || 'status = ' || l_adj_rec.status );
3478: arp_util.debug('Reverse_Adjustment: ' || 'adjustment_id = ' || l_adj_rec.adjustment_id );
3479: arp_util.debug('Reverse_Adjustment: ' || 'apply_date = ' || l_adj_rec.apply_date );
3480: arp_util.debug('Reverse_Adjustment: ' || 'gl_date = ' || l_adj_rec.gl_date );
3481: arp_util.debug('Reverse_Adjustment: ' || 'amount = ' || l_adj_rec.amount );
3482: arp_util.debug('Reverse_Adjustment: ' || 'acctd_amount = ' || l_adj_rec.acctd_amount );
3483: arp_util.debug('Reverse_Adjustment: ' || 'line_adjusted = ' || l_adj_rec.line_adjusted);

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

3476: arp_util.debug('Reverse_Adjustment: ' || 'New values for the new adjustment');
3477: arp_util.debug('Reverse_Adjustment: ' || 'status = ' || l_adj_rec.status );
3478: arp_util.debug('Reverse_Adjustment: ' || 'adjustment_id = ' || l_adj_rec.adjustment_id );
3479: arp_util.debug('Reverse_Adjustment: ' || 'apply_date = ' || l_adj_rec.apply_date );
3480: arp_util.debug('Reverse_Adjustment: ' || 'gl_date = ' || l_adj_rec.gl_date );
3481: arp_util.debug('Reverse_Adjustment: ' || 'amount = ' || l_adj_rec.amount );
3482: arp_util.debug('Reverse_Adjustment: ' || 'acctd_amount = ' || l_adj_rec.acctd_amount );
3483: arp_util.debug('Reverse_Adjustment: ' || 'line_adjusted = ' || l_adj_rec.line_adjusted);
3484: arp_util.debug('Reverse_Adjustment: ' || 'freight_adjusted = ' || l_adj_rec.freight_adjusted );

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

3477: arp_util.debug('Reverse_Adjustment: ' || 'status = ' || l_adj_rec.status );
3478: arp_util.debug('Reverse_Adjustment: ' || 'adjustment_id = ' || l_adj_rec.adjustment_id );
3479: arp_util.debug('Reverse_Adjustment: ' || 'apply_date = ' || l_adj_rec.apply_date );
3480: arp_util.debug('Reverse_Adjustment: ' || 'gl_date = ' || l_adj_rec.gl_date );
3481: arp_util.debug('Reverse_Adjustment: ' || 'amount = ' || l_adj_rec.amount );
3482: arp_util.debug('Reverse_Adjustment: ' || 'acctd_amount = ' || l_adj_rec.acctd_amount );
3483: arp_util.debug('Reverse_Adjustment: ' || 'line_adjusted = ' || l_adj_rec.line_adjusted);
3484: arp_util.debug('Reverse_Adjustment: ' || 'freight_adjusted = ' || l_adj_rec.freight_adjusted );
3485: arp_util.debug('Reverse_Adjustment: ' || 'tax_adjusted = ' || l_adj_rec.tax_adjusted);

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

3478: arp_util.debug('Reverse_Adjustment: ' || 'adjustment_id = ' || l_adj_rec.adjustment_id );
3479: arp_util.debug('Reverse_Adjustment: ' || 'apply_date = ' || l_adj_rec.apply_date );
3480: arp_util.debug('Reverse_Adjustment: ' || 'gl_date = ' || l_adj_rec.gl_date );
3481: arp_util.debug('Reverse_Adjustment: ' || 'amount = ' || l_adj_rec.amount );
3482: arp_util.debug('Reverse_Adjustment: ' || 'acctd_amount = ' || l_adj_rec.acctd_amount );
3483: arp_util.debug('Reverse_Adjustment: ' || 'line_adjusted = ' || l_adj_rec.line_adjusted);
3484: arp_util.debug('Reverse_Adjustment: ' || 'freight_adjusted = ' || l_adj_rec.freight_adjusted );
3485: arp_util.debug('Reverse_Adjustment: ' || 'tax_adjusted = ' || l_adj_rec.tax_adjusted);
3486: arp_util.debug('Reverse_Adjustment: ' || 'receivables_charges_adjusted = ' || l_adj_rec.receivables_charges_adjusted );

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

3479: arp_util.debug('Reverse_Adjustment: ' || 'apply_date = ' || l_adj_rec.apply_date );
3480: arp_util.debug('Reverse_Adjustment: ' || 'gl_date = ' || l_adj_rec.gl_date );
3481: arp_util.debug('Reverse_Adjustment: ' || 'amount = ' || l_adj_rec.amount );
3482: arp_util.debug('Reverse_Adjustment: ' || 'acctd_amount = ' || l_adj_rec.acctd_amount );
3483: arp_util.debug('Reverse_Adjustment: ' || 'line_adjusted = ' || l_adj_rec.line_adjusted);
3484: arp_util.debug('Reverse_Adjustment: ' || 'freight_adjusted = ' || l_adj_rec.freight_adjusted );
3485: arp_util.debug('Reverse_Adjustment: ' || 'tax_adjusted = ' || l_adj_rec.tax_adjusted);
3486: arp_util.debug('Reverse_Adjustment: ' || 'receivables_charges_adjusted = ' || l_adj_rec.receivables_charges_adjusted );
3487: arp_util.debug('Reverse_Adjustment: ' || 'created_from = ' || l_adj_rec.created_from );

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

3480: arp_util.debug('Reverse_Adjustment: ' || 'gl_date = ' || l_adj_rec.gl_date );
3481: arp_util.debug('Reverse_Adjustment: ' || 'amount = ' || l_adj_rec.amount );
3482: arp_util.debug('Reverse_Adjustment: ' || 'acctd_amount = ' || l_adj_rec.acctd_amount );
3483: arp_util.debug('Reverse_Adjustment: ' || 'line_adjusted = ' || l_adj_rec.line_adjusted);
3484: arp_util.debug('Reverse_Adjustment: ' || 'freight_adjusted = ' || l_adj_rec.freight_adjusted );
3485: arp_util.debug('Reverse_Adjustment: ' || 'tax_adjusted = ' || l_adj_rec.tax_adjusted);
3486: arp_util.debug('Reverse_Adjustment: ' || 'receivables_charges_adjusted = ' || l_adj_rec.receivables_charges_adjusted );
3487: arp_util.debug('Reverse_Adjustment: ' || 'created_from = ' || l_adj_rec.created_from );
3488: arp_util.debug('Reverse_Adjustment: ' || 'comments = ' || l_adj_rec.comments);

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

3481: arp_util.debug('Reverse_Adjustment: ' || 'amount = ' || l_adj_rec.amount );
3482: arp_util.debug('Reverse_Adjustment: ' || 'acctd_amount = ' || l_adj_rec.acctd_amount );
3483: arp_util.debug('Reverse_Adjustment: ' || 'line_adjusted = ' || l_adj_rec.line_adjusted);
3484: arp_util.debug('Reverse_Adjustment: ' || 'freight_adjusted = ' || l_adj_rec.freight_adjusted );
3485: arp_util.debug('Reverse_Adjustment: ' || 'tax_adjusted = ' || l_adj_rec.tax_adjusted);
3486: arp_util.debug('Reverse_Adjustment: ' || 'receivables_charges_adjusted = ' || l_adj_rec.receivables_charges_adjusted );
3487: arp_util.debug('Reverse_Adjustment: ' || 'created_from = ' || l_adj_rec.created_from );
3488: arp_util.debug('Reverse_Adjustment: ' || 'comments = ' || l_adj_rec.comments);
3489: arp_util.debug('Reverse_Adjustment: ' || '--------------------------------------------------');

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

3482: arp_util.debug('Reverse_Adjustment: ' || 'acctd_amount = ' || l_adj_rec.acctd_amount );
3483: arp_util.debug('Reverse_Adjustment: ' || 'line_adjusted = ' || l_adj_rec.line_adjusted);
3484: arp_util.debug('Reverse_Adjustment: ' || 'freight_adjusted = ' || l_adj_rec.freight_adjusted );
3485: arp_util.debug('Reverse_Adjustment: ' || 'tax_adjusted = ' || l_adj_rec.tax_adjusted);
3486: arp_util.debug('Reverse_Adjustment: ' || 'receivables_charges_adjusted = ' || l_adj_rec.receivables_charges_adjusted );
3487: arp_util.debug('Reverse_Adjustment: ' || 'created_from = ' || l_adj_rec.created_from );
3488: arp_util.debug('Reverse_Adjustment: ' || 'comments = ' || l_adj_rec.comments);
3489: arp_util.debug('Reverse_Adjustment: ' || '--------------------------------------------------');
3490: END IF;

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

3483: arp_util.debug('Reverse_Adjustment: ' || 'line_adjusted = ' || l_adj_rec.line_adjusted);
3484: arp_util.debug('Reverse_Adjustment: ' || 'freight_adjusted = ' || l_adj_rec.freight_adjusted );
3485: arp_util.debug('Reverse_Adjustment: ' || 'tax_adjusted = ' || l_adj_rec.tax_adjusted);
3486: arp_util.debug('Reverse_Adjustment: ' || 'receivables_charges_adjusted = ' || l_adj_rec.receivables_charges_adjusted );
3487: arp_util.debug('Reverse_Adjustment: ' || 'created_from = ' || l_adj_rec.created_from );
3488: arp_util.debug('Reverse_Adjustment: ' || 'comments = ' || l_adj_rec.comments);
3489: arp_util.debug('Reverse_Adjustment: ' || '--------------------------------------------------');
3490: END IF;
3491:

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

3484: arp_util.debug('Reverse_Adjustment: ' || 'freight_adjusted = ' || l_adj_rec.freight_adjusted );
3485: arp_util.debug('Reverse_Adjustment: ' || 'tax_adjusted = ' || l_adj_rec.tax_adjusted);
3486: arp_util.debug('Reverse_Adjustment: ' || 'receivables_charges_adjusted = ' || l_adj_rec.receivables_charges_adjusted );
3487: arp_util.debug('Reverse_Adjustment: ' || 'created_from = ' || l_adj_rec.created_from );
3488: arp_util.debug('Reverse_Adjustment: ' || 'comments = ' || l_adj_rec.comments);
3489: arp_util.debug('Reverse_Adjustment: ' || '--------------------------------------------------');
3490: END IF;
3491:
3492:

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

3485: arp_util.debug('Reverse_Adjustment: ' || 'tax_adjusted = ' || l_adj_rec.tax_adjusted);
3486: arp_util.debug('Reverse_Adjustment: ' || 'receivables_charges_adjusted = ' || l_adj_rec.receivables_charges_adjusted );
3487: arp_util.debug('Reverse_Adjustment: ' || 'created_from = ' || l_adj_rec.created_from );
3488: arp_util.debug('Reverse_Adjustment: ' || 'comments = ' || l_adj_rec.comments);
3489: arp_util.debug('Reverse_Adjustment: ' || '--------------------------------------------------');
3490: END IF;
3491:
3492:
3493: l_check_amount := FND_API.G_FALSE;

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

3526: p_return_status := FND_API.G_RET_STS_ERROR;
3527: ELSE
3528: IF PG_DEBUG in ('Y', 'C') THEN
3529: p_new_adj_id := l_llca_adj_create_tbl_type(1).adjustment_id;
3530: arp_util.debug('Reverse_Adjustment: ' ||
3531: 'After Create_Adjustment , new_adjustment_id = ' ||
3532: p_new_adj_id || ' new_adjustment_num = ' || l_llca_adj_create_tbl_type(1).adjustment_number);
3533: END IF;
3534: END IF;

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

3555: IF p_new_adj_id IS NULL THEN
3556: p_return_status := FND_API.G_RET_STS_ERROR;
3557: ELSE
3558: IF PG_DEBUG in ('Y', 'C') THEN
3559: arp_util.debug('Reverse_Adjustment: ' ||
3560: 'After Create_Adjustment , new_adjustment_id = ' ||
3561: p_new_adj_id || ' new_adjustment_num = ' || l_new_adj_num);
3562: END IF;
3563: END IF;

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

3581: p_count => p_msg_count,
3582: p_data => p_msg_data
3583: );
3584: IF PG_DEBUG in ('Y', 'C') THEN
3585: arp_util.debug('Reverse_Adjustment: ' ||
3586: 'Error in Insert Entity handler. Rolling back ' ||
3587: 'and setting status to ERROR');
3588: END IF;
3589: if (l_msg_count > 0) then

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

3587: 'and setting status to ERROR');
3588: END IF;
3589: if (l_msg_count > 0) then
3590: IF PG_DEBUG in ('Y', 'C') THEN
3591: arp_util.debug('Reverse_Adjustment: ' || l_msg_data);
3592: END IF;
3593: end if;
3594:
3595: RETURN;

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

3618:
3619: IF FND_API.To_Boolean( p_commit_flag )
3620: THEN
3621: IF PG_DEBUG in ('Y', 'C') THEN
3622: arp_util.debug('Reverse_Adjustment: ' || 'committing');
3623: END IF;
3624: Commit;
3625: END IF;
3626:

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

3624: Commit;
3625: END IF;
3626:
3627: IF PG_DEBUG in ('Y', 'C') THEN
3628: arp_util.debug('Reverse_Adjustment()- ');
3629: END IF;
3630:
3631: IF (FND_MSG_PUB.Check_Msg_Level (G_MSG_LOW)) THEN
3632: select TO_CHAR( (hsecs - G_START_TIME) / 100)

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

3632: select TO_CHAR( (hsecs - G_START_TIME) / 100)
3633: into l_hsec
3634: from v$timer;
3635: IF PG_DEBUG in ('Y', 'C') THEN
3636: arp_util.debug('Reverse_Adjustment: ' || 'Elapsed Time : '||l_hsec||' seconds');
3637: END IF;
3638: END IF;
3639:
3640:

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

3641: EXCEPTION
3642: WHEN FND_API.G_EXC_ERROR THEN
3643:
3644: IF PG_DEBUG in ('Y', 'C') THEN
3645: arp_util.debug('Reverse_Adjustment: ' || SQLCODE);
3646: arp_util.debug('Reverse_Adjustment: ' || SQLERRM);
3647: END IF;
3648:
3649: ROLLBACK TO ar_adjust_PUB;

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

3642: WHEN FND_API.G_EXC_ERROR THEN
3643:
3644: IF PG_DEBUG in ('Y', 'C') THEN
3645: arp_util.debug('Reverse_Adjustment: ' || SQLCODE);
3646: arp_util.debug('Reverse_Adjustment: ' || SQLERRM);
3647: END IF;
3648:
3649: ROLLBACK TO ar_adjust_PUB;
3650: p_return_status := FND_API.G_RET_STS_ERROR ;

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

3655:
3656: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3657:
3658: IF PG_DEBUG in ('Y', 'C') THEN
3659: arp_util.debug('Reverse_Adjustment: ' || SQLERRM);
3660: END IF;
3661: ROLLBACK TO ar_adjust_PUB ;
3662: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3663: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

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

3677: THEN
3678: p_return_status := FND_API.G_RET_STS_ERROR ;
3679: ROLLBACK TO ar_adjust_PUB;
3680: IF PG_DEBUG in ('Y', 'C') THEN
3681: arp_util.debug('Reverse_Adjustment: ' ||
3682: 'Completion validation error(s) occurred. ' ||
3683: 'Rolling back and setting status to ERROR');
3684: END IF;
3685:

Line 3695: arp_util.disable_debug;

3691: ELSE
3692: NULL;
3693: END IF;
3694:
3695: arp_util.disable_debug;
3696:
3697: END Reverse_Adjustment;
3698:
3699:

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

3811: G_PKG_NAME
3812: )
3813: THEN
3814: IF PG_DEBUG in ('Y', 'C') THEN
3815: arp_util.debug('Approve_Adjustment: ' || 'Compatility error occurred.');
3816: END IF;
3817: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3818: END IF;
3819:

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

3825: THEN
3826: FND_MSG_PUB.initialize;
3827: END IF;
3828:
3829: -- arp_util.enable_debug(100000);
3830:
3831:
3832: IF PG_DEBUG in ('Y', 'C') THEN
3833: arp_util.debug('Approve_Adjustment()+ ');

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

3829: -- arp_util.enable_debug(100000);
3830:
3831:
3832: IF PG_DEBUG in ('Y', 'C') THEN
3833: arp_util.debug('Approve_Adjustment()+ ');
3834: END IF;
3835:
3836: /*-----------------------------------------+
3837: | Initialize return status to SUCCESS |

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

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

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

3899: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
3900: THEN
3901: p_return_status := l_return_status ;
3902: IF PG_DEBUG in ('Y', 'C') THEN
3903: arp_util.debug('Approve_Adjustment: ' || 'failed to Initialize the profile options ');
3904: END IF;
3905: END IF;
3906:
3907: /*------------------------------------------------+

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

3957: THEN
3958:
3959: p_return_status := l_return_status ;
3960: IF PG_DEBUG in ('Y', 'C') THEN
3961: arp_util.debug('Approve_Adjustment: ' ||
3962: 'Validation error(s) occurred. Rolling back ' ||
3963: 'and setting status to ERROR');
3964: END IF;
3965: END IF;

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

4020: p_data => p_msg_data
4021: );
4022:
4023: IF PG_DEBUG in ('Y', 'C') THEN
4024: arp_util.debug('Approve_Adjustment: ' ||
4025: 'Error in Insert Entity handler. Rolling back ' ||
4026: 'and setting status to ERROR');
4027: END IF;
4028:

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

4052:
4053: IF FND_API.To_Boolean( p_commit_flag )
4054: THEN
4055: IF PG_DEBUG in ('Y', 'C') THEN
4056: arp_util.debug('Approve_Adjustment: ' || 'committing');
4057: END IF;
4058: Commit;
4059: END IF;
4060:

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

4058: Commit;
4059: END IF;
4060:
4061: IF PG_DEBUG in ('Y', 'C') THEN
4062: arp_util.debug('Approve_Adjustment()- ');
4063: END IF;
4064:
4065: IF (FND_MSG_PUB.Check_Msg_Level (G_MSG_LOW)) THEN
4066: select TO_CHAR( (hsecs - G_START_TIME) / 100)

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

4066: select TO_CHAR( (hsecs - G_START_TIME) / 100)
4067: into l_hsec
4068: from v$timer;
4069: IF PG_DEBUG in ('Y', 'C') THEN
4070: arp_util.debug('Approve_Adjustment: ' || 'Elapsed Time : '||l_hsec||' seconds');
4071: END IF;
4072: END IF;
4073:
4074:

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

4075: EXCEPTION
4076: WHEN FND_API.G_EXC_ERROR THEN
4077:
4078: IF PG_DEBUG in ('Y', 'C') THEN
4079: arp_util.debug('Approve_Adjustment: ' || SQLCODE);
4080: arp_util.debug('Approve_Adjustment: ' || SQLERRM);
4081: END IF;
4082:
4083: ROLLBACK TO ar_adjust_PUB;

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

4076: WHEN FND_API.G_EXC_ERROR THEN
4077:
4078: IF PG_DEBUG in ('Y', 'C') THEN
4079: arp_util.debug('Approve_Adjustment: ' || SQLCODE);
4080: arp_util.debug('Approve_Adjustment: ' || SQLERRM);
4081: END IF;
4082:
4083: ROLLBACK TO ar_adjust_PUB;
4084: p_return_status := FND_API.G_RET_STS_ERROR ;

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

4089:
4090: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4091:
4092: IF PG_DEBUG in ('Y', 'C') THEN
4093: arp_util.debug('Approve_Adjustment: ' || SQLERRM);
4094: END IF;
4095: ROLLBACK TO ar_adjust_PUB ;
4096: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4097: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

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

4111: THEN
4112: p_return_status := FND_API.G_RET_STS_ERROR ;
4113: ROLLBACK TO ar_adjust_PUB;
4114: IF PG_DEBUG in ('Y', 'C') THEN
4115: arp_util.debug('Approve_Adjustment: ' ||
4116: 'Completion validation error(s) occurred. ' ||
4117: 'Rolling back and setting status to ERROR');
4118: END IF;
4119:

Line 4129: arp_util.disable_debug;

4125: ELSE
4126: NULL;
4127: END IF;
4128:
4129: arp_util.disable_debug;
4130:
4131: END Approve_Adjustment;
4132:
4133: