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 FND_API

Line 22: | fnd_api.compatible_api_call |

18: | |
19: | SCOPE - PRIVATE |
20: | |
21: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
22: | fnd_api.compatible_api_call |
23: | fnd_api.g_exc_unexpected_error |
24: | fnd_api.g_ret_sts_error |
25: | fnd_api.g_ret_sts_error |
26: | fnd_api.g_ret_sts_success |

Line 23: | fnd_api.g_exc_unexpected_error |

19: | SCOPE - PRIVATE |
20: | |
21: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
22: | fnd_api.compatible_api_call |
23: | fnd_api.g_exc_unexpected_error |
24: | fnd_api.g_ret_sts_error |
25: | fnd_api.g_ret_sts_error |
26: | fnd_api.g_ret_sts_success |
27: | fnd_api.to_boolean |

Line 24: | fnd_api.g_ret_sts_error |

20: | |
21: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
22: | fnd_api.compatible_api_call |
23: | fnd_api.g_exc_unexpected_error |
24: | fnd_api.g_ret_sts_error |
25: | fnd_api.g_ret_sts_error |
26: | fnd_api.g_ret_sts_success |
27: | fnd_api.to_boolean |
28: | fnd_msg_pub.check_msg_level |

Line 25: | fnd_api.g_ret_sts_error |

21: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
22: | fnd_api.compatible_api_call |
23: | fnd_api.g_exc_unexpected_error |
24: | fnd_api.g_ret_sts_error |
25: | fnd_api.g_ret_sts_error |
26: | fnd_api.g_ret_sts_success |
27: | fnd_api.to_boolean |
28: | fnd_msg_pub.check_msg_level |
29: | fnd_msg_pub.count_and_get |

Line 26: | fnd_api.g_ret_sts_success |

22: | fnd_api.compatible_api_call |
23: | fnd_api.g_exc_unexpected_error |
24: | fnd_api.g_ret_sts_error |
25: | fnd_api.g_ret_sts_error |
26: | fnd_api.g_ret_sts_success |
27: | fnd_api.to_boolean |
28: | fnd_msg_pub.check_msg_level |
29: | fnd_msg_pub.count_and_get |
30: | fnd_msg_pub.initialize |

Line 27: | fnd_api.to_boolean |

23: | fnd_api.g_exc_unexpected_error |
24: | fnd_api.g_ret_sts_error |
25: | fnd_api.g_ret_sts_error |
26: | fnd_api.g_ret_sts_success |
27: | fnd_api.to_boolean |
28: | fnd_msg_pub.check_msg_level |
29: | fnd_msg_pub.count_and_get |
30: | fnd_msg_pub.initialize |
31: | ar_adjvalidate_pvt.Validate_Type |

Line 98: p_validation_status := FND_API.G_RET_STS_SUCCESS;

94:
95: /*-------------------------------------------------+
96: | Initialize return status to SUCCESS |
97: +-------------------------------------------------*/
98: p_validation_status := FND_API.G_RET_STS_SUCCESS;
99:
100: /*-------------------------------------------------+
101: | 1. Validate type |
102: +-------------------------------------------------*/

Line 107: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )

103: ar_adjvalidate_pvt.Validate_Type (
104: p_adj_rec,
105: l_return_status
106: ) ;
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 ');

Line 125: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )

121: l_ps_rec,
122: l_return_status,
123: p_llca_from_call
124: );
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 ');

Line 143: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )

139: p_adj_rec.gl_date,
140: l_ps_rec,
141: l_return_status
142: );
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 ');

Line 173: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )

169: p_check_amount,
170: l_return_status
171: );
172:
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);

Line 196: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )

192: l_ps_rec,
193: l_return_status,
194: p_llca_from_call
195: );
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');

Line 217: p_check_amount = FND_API.G_TRUE AND

213: +--------------------------------------------------*/
214: --Bug 1395396 Calculate prorate only if adjustment amount <> 0
215: -- Added call to customer_trx_line_id for Line level Adjustment
216: IF (p_adj_rec.type in ('LINE', 'CHARGES') AND
217: p_check_amount = FND_API.G_TRUE AND
218: p_adj_rec.amount <> 0) THEN
219:
220: ARP_PROCESS_ADJUSTMENT.cal_prorated_amounts(p_adj_rec.amount,
221: p_adj_rec.payment_schedule_id,

Line 239: p_validation_status := FND_API.G_RET_STS_ERROR;

235: | Set the message |
236: +-----------------------------------------------*/
237: FND_MESSAGE.SET_NAME('AR','AR_TW_PRORATE_ADJ_NO_TAX_RATE');
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;

Line 249: p_validation_status := FND_API.G_RET_STS_ERROR;

245: | Set the message |
246: +-----------------------------------------------*/
247: FND_MESSAGE.SET_NAME('AR','AR_TW_PRORATE_ADJ_OVERAPPLY');
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;

Line 257: p_validation_status := FND_API.G_RET_STS_ERROR;

253: END IF;
254: /*-----------------------------------------------+
255: | Set the message |
256: +-----------------------------------------------*/
257: p_validation_status := FND_API.G_RET_STS_ERROR;
258: ELSE
259: IF (p_adj_rec.type = 'LINE') THEN
260: p_adj_rec.line_adjusted := l_prorated_amt;
261: ELSE

Line 273: IF (p_check_amount = FND_API.G_TRUE)

269: | Check for over-application (Bug 3766262) |
270: +-------------------------------------------------*/
271: /*We need to check for over-application only when it's not an adjustment
272: reversal*/
273: IF (p_check_amount = FND_API.G_TRUE)
274: THEN
275: ar_adjvalidate_pvt.Validate_Over_Application(
276: p_adj_rec,
277: l_ps_rec,

Line 281: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )

277: l_ps_rec,
278: l_return_status);
279: END IF;
280:
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 ');

Line 295: IF (p_check_amount = FND_API.G_TRUE)

291: +-------------------------------------------------*/
292: IF p_llca_from_call = 'Y' AND p_adj_rec.type = 'LINE'
293: THEN
294:
295: IF (p_check_amount = FND_API.G_TRUE)
296: THEN
297: ar_adjvalidate_pvt.Validate_Over_Application_llca(
298: p_adj_rec,
299: l_ps_rec,

Line 303: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )

299: l_ps_rec,
300: l_return_status);
301: END IF;
302:
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 ');

Line 325: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )

321: ar_adjvalidate_pvt.Validate_doc_seq (
322: p_adj_rec,
323: l_return_status
324: ) ;
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 ');

Line 342: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )

338: ar_adjvalidate_pvt.Validate_Reason_code (
339: p_adj_rec,
340: l_return_status
341: );
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 ');

Line 357: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )

353: ar_adjvalidate_pvt.Validate_Associated_Receipt (
354: p_adj_rec,
355: l_return_status
356: );
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 ');

Line 372: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )

368: ar_adjvalidate_pvt.Validate_Ussgl_code (
369: p_adj_rec,
370: l_return_status
371: );
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');

Line 387: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )

383: ar_adjvalidate_pvt.Validate_Desc_Flexfield(
384: p_adj_rec,
385: l_return_status
386: );
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');

Line 403: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )

399: p_adj_rec,
400: l_return_status
401: );
402:
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 ');

Line 425: p_validation_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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;
427:
428:
429: END Validate_Adj_Insert;

Line 477: p_return_status := FND_API.G_RET_STS_SUCCESS ;

473:
474: /*-----------------------------------------------+
475: | Set the status to success |
476: +-----------------------------------------------*/
477: p_return_status := FND_API.G_RET_STS_SUCCESS ;
478:
479: /*-----------------------------------------------+
480: | Set Adjustment Type and Postable attributes |
481: +-----------------------------------------------*/

Line 513: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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;
515:
516: END Set_Remaining_Attributes;
517:

Line 589: p_validation_status := FND_API.G_RET_STS_ERROR;

585: THEN
586: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_NO_CHANGE_OR_REVERSE');
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;

Line 605: p_validation_status := FND_API.G_RET_STS_ERROR;

601: (p_adj_rec.associated_cash_receipt_id IS NULL)
602: ) THEN
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;

Line 623: p_validation_status := FND_API.G_RET_STS_ERROR;

619: THEN
620: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_NO_CHANGE_OR_REVERSE');
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;

Line 640: p_validation_status := FND_API.G_RET_STS_ERROR;

636: THEN
637: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_INVALID_CHANGE_STATUS');
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;

Line 672: p_validation_status := FND_API.G_RET_STS_ERROR;

668: FND_MESSAGE.SET_NAME ( 'AR', 'AR_AAPI_INVALID_PAYMENT_SCHEDULE');
669: FND_MESSAGE.SET_TOKEN('PAYMENT_SCHEDULE_ID',to_char(p_old_adj_rec.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 ;

Line 685: p_chk_approval_limits = FND_API.G_TRUE )

681: | will be done only if p_chk_approval_limits is set to |
682: | 'T'. |
683: +------------------------------------------------------*/
684: IF ( p_adj_rec.status = 'A' and
685: p_chk_approval_limits = FND_API.G_TRUE )
686: THEN
687:
688: /*-----------------------------------+
689: | Get the approval limits and check |

Line 699: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )

695: l_approved_flag,
696: l_return_status
697: ) ;
698:
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');

Line 707: IF ( l_approved_flag <> FND_API.G_TRUE )

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 )
708: THEN
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;

Line 711: p_validation_status := FND_API.G_RET_STS_ERROR;

707: IF ( l_approved_flag <> FND_API.G_TRUE )
708: THEN
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;

Line 736: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )

732: NVL(p_adj_rec.gl_date,p_old_adj_rec.gl_date),
733: l_ps_rec,
734: l_return_status
735: ) ;
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');

Line 755: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )

751: ar_adjvalidate_pvt.Validate_Associated_Receipt (
752: p_adj_rec,
753: l_return_status
754: );
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 ');

Line 782: p_validation_status := FND_API.G_RET_STS_ERROR;

778: EXCEPTION
779: WHEN no_data_found THEN
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;

Line 799: p_validation_status := FND_API.G_RET_STS_ERROR;

795: ( l_cash_receipt_id IS NULL )) THEN
796:
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;

Line 863: p_validation_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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;
865:
866:
867: END Validate_Adj_Modify;

Line 928: p_validation_status := FND_API.G_RET_STS_ERROR;

924: THEN
925: FND_MESSAGE.SET_NAME ( 'AR', 'AR_AAPI_NO_CHANGE_OR_REVERSE');
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;

Line 973: p_validation_status := FND_API.G_RET_STS_ERROR;

969: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_INVALID_PAYMENT_SCHEDULE');
970: FND_MESSAGE.SET_TOKEN ( 'PAYMENT_SCHEDULE_ID', to_char(p_old_adj_rec.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 ;

Line 985: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )

981: p_reversal_gl_date,
982: l_ps_rec,
983: l_return_status
984: ) ;
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');

Line 1007: p_validation_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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;
1009:
1010:
1011: END Validate_Adj_Reverse;

Line 1075: p_validation_status := FND_API.G_RET_STS_ERROR;

1071:
1072: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_NO_CHANGE_OR_REVERSE');
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;

Line 1101: p_validation_status := FND_API.G_RET_STS_ERROR;

1097:
1098: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_INVALID_CHANGE_STATUS');
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:

Line 1136: p_validation_status := FND_API.G_RET_STS_ERROR;

1132:
1133: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_INVALID_PAYMENT_SCHEDULE');
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:

Line 1149: p_chk_approval_limits = FND_API.G_TRUE)

1145: | Special processing for bypassing limit check if |
1146: | p_chk_approval_limits is set to 'F' |
1147: +--------------------------------------------------- */
1148: IF ( p_adj_rec.status = 'A' and
1149: p_chk_approval_limits = FND_API.G_TRUE)
1150: THEN
1151:
1152: /*-----------------------------------+
1153: | Get the approval limits and check |

Line 1163: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )

1159: l_approved_flag,
1160: l_return_status
1161: ) ;
1162:
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 ');

Line 1171: IF ( l_approved_flag <> FND_API.G_TRUE )

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 )
1172: THEN
1173: FND_MESSAGE.SET_NAME ('AR', 'AR_VAL_AMT_APPROVAL_LIMIT');
1174: FND_MSG_PUB.ADD ;
1175:

Line 1176: p_validation_status := FND_API.G_RET_STS_ERROR;

1172: THEN
1173: FND_MESSAGE.SET_NAME ('AR', 'AR_VAL_AMT_APPROVAL_LIMIT');
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;

Line 1201: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )

1197: NVL(p_adj_rec.gl_date,p_old_adj_rec.gl_date),
1198: l_ps_rec,
1199: l_return_status
1200: ) ;
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');

Line 1249: p_validation_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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;
1251:
1252:
1253: END Validate_Adj_Approve;

Line 1299: p_return_status := FND_API.G_RET_STS_SUCCESS;

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:
1301: -- Clean the GT Table first.
1302: delete from ar_llca_adj_trx_lines_gt
1303: where customer_trx_id = p_customer_trx_id;

Line 1360: p_return_status := FND_API.G_RET_STS_ERROR;

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;
1363:
1364:

Line 1418: p_return_status := FND_API.G_RET_STS_SUCCESS;

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:
1420:
1421: IF p_adj_rec.type NOT IN ('LINE')
1422: THEN

Line 1424: l_return_status := FND_API.G_RET_STS_ERROR ;

1420:
1421: IF p_adj_rec.type NOT IN ('LINE')
1422: THEN
1423:
1424: l_return_status := FND_API.G_RET_STS_ERROR ;
1425: FND_MESSAGE.SET_NAME ('AR', 'AR_ADJ_API_TYPE_DISALLOW');
1426: FND_MESSAGE.SET_TOKEN ( 'TYPE', p_adj_rec.TYPE ) ;
1427: FND_MSG_PUB.ADD ;
1428:

Line 1487: l_return_status := FND_API.G_RET_STS_ERROR ;

1483: and customer_trx_id = p_adj_rec.customer_trx_id;
1484:
1485: IF nvl(ll_installment,0) > 1
1486: THEN
1487: l_return_status := FND_API.G_RET_STS_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

Line 1508: l_return_status := FND_API.G_RET_STS_ERROR ;

1504: x_11i_app => ll_leg_app,
1505: x_mfar_app => ll_mfar_app );
1506: IF (ll_leg_adj = 'Y') OR (ll_leg_app = 'Y')
1507: THEN
1508: l_return_status := FND_API.G_RET_STS_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

Line 1521: p_return_status := FND_API.G_RET_STS_ERROR;

1517: END IF;
1518:
1519: Exception
1520: when others then
1521: p_return_status := FND_API.G_RET_STS_ERROR;
1522: raise;
1523: End;
1524:
1525: p_return_status := l_return_status;

Line 1536: p_return_status := FND_API.G_RET_STS_ERROR;

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:
1539: END validate_hdr_level;
1540:

Line 1553: | fnd_api.compatible_api_call |

1549: | |
1550: | SCOPE - PUBLIC |
1551: | |
1552: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1553: | fnd_api.compatible_api_call |
1554: | fnd_api.g_exc_unexpected_error |
1555: | fnd_api.g_ret_sts_error |
1556: | fnd_api.g_ret_sts_error |
1557: | fnd_api.g_ret_sts_success |

Line 1554: | fnd_api.g_exc_unexpected_error |

1550: | SCOPE - PUBLIC |
1551: | |
1552: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1553: | fnd_api.compatible_api_call |
1554: | fnd_api.g_exc_unexpected_error |
1555: | fnd_api.g_ret_sts_error |
1556: | fnd_api.g_ret_sts_error |
1557: | fnd_api.g_ret_sts_success |
1558: | fnd_api.to_boolean |

Line 1555: | fnd_api.g_ret_sts_error |

1551: | |
1552: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1553: | fnd_api.compatible_api_call |
1554: | fnd_api.g_exc_unexpected_error |
1555: | fnd_api.g_ret_sts_error |
1556: | fnd_api.g_ret_sts_error |
1557: | fnd_api.g_ret_sts_success |
1558: | fnd_api.to_boolean |
1559: | fnd_msg_pub.check_msg_level |

Line 1556: | fnd_api.g_ret_sts_error |

1552: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1553: | fnd_api.compatible_api_call |
1554: | fnd_api.g_exc_unexpected_error |
1555: | fnd_api.g_ret_sts_error |
1556: | fnd_api.g_ret_sts_error |
1557: | fnd_api.g_ret_sts_success |
1558: | fnd_api.to_boolean |
1559: | fnd_msg_pub.check_msg_level |
1560: | fnd_msg_pub.count_and_get |

Line 1557: | fnd_api.g_ret_sts_success |

1553: | fnd_api.compatible_api_call |
1554: | fnd_api.g_exc_unexpected_error |
1555: | fnd_api.g_ret_sts_error |
1556: | fnd_api.g_ret_sts_error |
1557: | fnd_api.g_ret_sts_success |
1558: | fnd_api.to_boolean |
1559: | fnd_msg_pub.check_msg_level |
1560: | fnd_msg_pub.count_and_get |
1561: | fnd_msg_pub.initialize |

Line 1558: | fnd_api.to_boolean |

1554: | fnd_api.g_exc_unexpected_error |
1555: | fnd_api.g_ret_sts_error |
1556: | fnd_api.g_ret_sts_error |
1557: | fnd_api.g_ret_sts_success |
1558: | fnd_api.to_boolean |
1559: | fnd_msg_pub.check_msg_level |
1560: | fnd_msg_pub.count_and_get |
1561: | fnd_msg_pub.initialize |
1562: | ar_adjvalidate_pvt.Init_Context_Rec |

Line 1619: p_init_msg_list IN varchar2 := FND_API.G_FALSE,

1615:
1616: PROCEDURE Create_Adjustment (
1617: p_api_name IN varchar2,
1618: p_api_version IN number,
1619: p_init_msg_list IN varchar2 := FND_API.G_FALSE,
1620: p_commit_flag IN varchar2 := FND_API.G_FALSE,
1621: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,
1622: p_msg_count OUT NOCOPY number,
1623: p_msg_data OUT NOCOPY varchar2,

Line 1620: p_commit_flag IN varchar2 := FND_API.G_FALSE,

1616: PROCEDURE Create_Adjustment (
1617: p_api_name IN varchar2,
1618: p_api_version IN number,
1619: p_init_msg_list IN varchar2 := FND_API.G_FALSE,
1620: p_commit_flag IN varchar2 := FND_API.G_FALSE,
1621: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,
1622: p_msg_count OUT NOCOPY number,
1623: p_msg_data OUT NOCOPY varchar2,
1624: p_return_status OUT NOCOPY varchar2 ,

Line 1621: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,

1617: p_api_name IN varchar2,
1618: p_api_version IN number,
1619: p_init_msg_list IN varchar2 := FND_API.G_FALSE,
1620: p_commit_flag IN varchar2 := FND_API.G_FALSE,
1621: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,
1622: p_msg_count OUT NOCOPY number,
1623: p_msg_data OUT NOCOPY varchar2,
1624: p_return_status OUT NOCOPY varchar2 ,
1625: p_adj_rec IN ar_adjustments%rowtype,

Line 1626: p_chk_approval_limits IN varchar2 := FND_API.G_TRUE,

1622: p_msg_count OUT NOCOPY number,
1623: p_msg_data OUT NOCOPY varchar2,
1624: p_return_status OUT NOCOPY varchar2 ,
1625: p_adj_rec IN ar_adjustments%rowtype,
1626: p_chk_approval_limits IN varchar2 := FND_API.G_TRUE,
1627: p_check_amount IN varchar2 := FND_API.G_TRUE,
1628: p_move_deferred_tax IN varchar2,
1629: p_new_adjust_number OUT NOCOPY ar_adjustments.adjustment_number%type,
1630: p_new_adjust_id OUT NOCOPY ar_adjustments.adjustment_id%type,

Line 1627: p_check_amount IN varchar2 := FND_API.G_TRUE,

1623: p_msg_data OUT NOCOPY varchar2,
1624: p_return_status OUT NOCOPY varchar2 ,
1625: p_adj_rec IN ar_adjustments%rowtype,
1626: p_chk_approval_limits IN varchar2 := FND_API.G_TRUE,
1627: p_check_amount IN varchar2 := FND_API.G_TRUE,
1628: p_move_deferred_tax IN varchar2,
1629: p_new_adjust_number OUT NOCOPY ar_adjustments.adjustment_number%type,
1630: p_new_adjust_id OUT NOCOPY ar_adjustments.adjustment_id%type,
1631: p_called_from IN varchar2,

Line 1674: IF NOT FND_API.Compatible_API_Call(

1670: /*--------------------------------------------------+
1671: | Standard call to check for call compatibility |
1672: +--------------------------------------------------*/
1673:
1674: IF NOT FND_API.Compatible_API_Call(
1675: l_api_version,
1676: p_api_version,
1677: l_api_name,
1678: G_PKG_NAME

Line 1684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:
1687: /*-------------------------------------------------------------+
1688: | Initialize message list if p_init_msg_list is set to TRUE |

Line 1691: IF FND_API.to_Boolean( p_init_msg_list )

1687: /*-------------------------------------------------------------+
1688: | Initialize message list if p_init_msg_list is set to TRUE |
1689: +-------------------------------------------------------------*/
1690:
1691: IF FND_API.to_Boolean( p_init_msg_list )
1692: THEN
1693: FND_MSG_PUB.initialize;
1694: END IF;
1695:

Line 1706: p_return_status := FND_API.G_RET_STS_SUCCESS;

1702: /*-----------------------------------------+
1703: | Initialize return status to SUCCESS |
1704: +-----------------------------------------*/
1705:
1706: p_return_status := FND_API.G_RET_STS_SUCCESS;
1707:
1708: /* SSA change */
1709: l_org_id := p_org_id;
1710: l_org_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1710: l_org_return_status := FND_API.G_RET_STS_SUCCESS;

1706: p_return_status := FND_API.G_RET_STS_SUCCESS;
1707:
1708: /* SSA change */
1709: l_org_id := p_org_id;
1710: l_org_return_status := FND_API.G_RET_STS_SUCCESS;
1711: ar_mo_cache_utils.set_org_context_in_api(p_org_id =>l_org_id,
1712: p_return_status =>l_org_return_status);
1713: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1714: p_return_status := FND_API.G_RET_STS_ERROR;

Line 1713: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1709: l_org_id := p_org_id;
1710: l_org_return_status := FND_API.G_RET_STS_SUCCESS;
1711: ar_mo_cache_utils.set_org_context_in_api(p_org_id =>l_org_id,
1712: p_return_status =>l_org_return_status);
1713: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1714: p_return_status := FND_API.G_RET_STS_ERROR;
1715: ELSE
1716:
1717: /*---------------------------------------------+

Line 1714: p_return_status := FND_API.G_RET_STS_ERROR;

1710: l_org_return_status := FND_API.G_RET_STS_SUCCESS;
1711: ar_mo_cache_utils.set_org_context_in_api(p_org_id =>l_org_id,
1712: p_return_status =>l_org_return_status);
1713: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1714: p_return_status := FND_API.G_RET_STS_ERROR;
1715: ELSE
1716:
1717: /*---------------------------------------------+
1718: | ========== Start of API Body ========== |

Line 1742: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )

1738: | Check the return status |
1739: /*---------------------------------------------------+
1740:
1741:
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 ' );

Line 1763: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )

1759: /*---------------------------------------------------+
1760: | Check the return status |
1761: /*---------------------------------------------------+
1762:
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 ' );

Line 1830: l_chk_approval_limits := FND_API.G_TRUE;

1826: l_chk_approval_limits := p_chk_approval_limits;
1827: l_check_amount := p_check_amount;
1828:
1829: IF (l_chk_approval_limits IS NULL) THEN
1830: l_chk_approval_limits := FND_API.G_TRUE;
1831: END IF;
1832:
1833: IF (l_check_amount IS NULL) THEN
1834: l_check_amount := FND_API.G_TRUE;

Line 1834: l_check_amount := FND_API.G_TRUE;

1830: l_chk_approval_limits := FND_API.G_TRUE;
1831: END IF;
1832:
1833: IF (l_check_amount IS NULL) THEN
1834: l_check_amount := FND_API.G_TRUE;
1835: END IF;
1836:
1837: ar_adjust_pub.Validate_Adj_Insert(
1838: l_inp_adj_rec,

Line 1844: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )

1840: l_check_amount,
1841: l_return_status
1842: );
1843:
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. '||

Line 1857: IF (p_return_status = FND_API.G_RET_STS_ERROR)

1853:
1854: /*-----------------------------------------------+
1855: | Handling all the validation exceptions |
1856: +-----------------------------------------------*/
1857: IF (p_return_status = FND_API.G_RET_STS_ERROR)
1858: THEN
1859: RAISE FND_API.G_EXC_ERROR;
1860:
1861: ELSIF (p_return_status = FND_API.G_RET_STS_UNEXP_ERROR)

Line 1859: RAISE FND_API.G_EXC_ERROR;

1855: | Handling all the validation exceptions |
1856: +-----------------------------------------------*/
1857: IF (p_return_status = FND_API.G_RET_STS_ERROR)
1858: THEN
1859: RAISE FND_API.G_EXC_ERROR;
1860:
1861: ELSIF (p_return_status = FND_API.G_RET_STS_UNEXP_ERROR)
1862: THEN
1863: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1861: ELSIF (p_return_status = FND_API.G_RET_STS_UNEXP_ERROR)

1857: IF (p_return_status = FND_API.G_RET_STS_ERROR)
1858: THEN
1859: RAISE FND_API.G_EXC_ERROR;
1860:
1861: ELSIF (p_return_status = FND_API.G_RET_STS_UNEXP_ERROR)
1862: THEN
1863: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1864: END IF;
1865:

Line 1863: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1859: RAISE FND_API.G_EXC_ERROR;
1860:
1861: ELSIF (p_return_status = FND_API.G_RET_STS_UNEXP_ERROR)
1862: THEN
1863: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1864: END IF;
1865:
1866:
1867: /*-----------------------------------------------+

Line 1877: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )

1873: l_inp_adj_rec,
1874: l_return_status
1875: ) ;
1876:
1877: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
1878: THEN
1879:
1880: p_return_status := l_return_status ;
1881: IF PG_DEBUG in ('Y', 'C') THEN

Line 1887: IF (p_return_status = FND_API.G_RET_STS_ERROR)

1883: 'Validation error(s) occurred. Rolling back '||
1884: 'and setting status to ERROR');
1885: END IF;
1886:
1887: IF (p_return_status = FND_API.G_RET_STS_ERROR)
1888: THEN
1889: RAISE FND_API.G_EXC_ERROR;
1890: ELSIF (p_return_status = FND_API.G_RET_STS_UNEXP_ERROR)
1891: THEN

Line 1889: RAISE FND_API.G_EXC_ERROR;

1885: END IF;
1886:
1887: IF (p_return_status = FND_API.G_RET_STS_ERROR)
1888: THEN
1889: RAISE FND_API.G_EXC_ERROR;
1890: ELSIF (p_return_status = FND_API.G_RET_STS_UNEXP_ERROR)
1891: THEN
1892: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1893: END IF;

Line 1890: ELSIF (p_return_status = FND_API.G_RET_STS_UNEXP_ERROR)

1886:
1887: IF (p_return_status = FND_API.G_RET_STS_ERROR)
1888: THEN
1889: RAISE FND_API.G_EXC_ERROR;
1890: ELSIF (p_return_status = FND_API.G_RET_STS_UNEXP_ERROR)
1891: THEN
1892: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1893: END IF;
1894: END IF;

Line 1892: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1888: THEN
1889: RAISE FND_API.G_EXC_ERROR;
1890: ELSIF (p_return_status = FND_API.G_RET_STS_UNEXP_ERROR)
1891: THEN
1892: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1893: END IF;
1894: END IF;
1895:
1896: /*-----------------------------------------------+

Line 1939: p_return_status := FND_API.G_RET_STS_ERROR ;

1935: | Rollback to the defined Savepoint |
1936: +---------------------------------------------------*/
1937:
1938: ROLLBACK TO ar_adjust_PUB;
1939: p_return_status := FND_API.G_RET_STS_ERROR ;
1940:
1941: FND_MESSAGE.set_name( 'AR', 'GENERIC_MESSAGE' );
1942: FND_MESSAGE.set_token( 'GENERIC_TEXT', 'arp_process_adjustment.insert_adjustment exception: '||SQLERRM );
1943: --2920926

Line 1950: p_encoded => FND_API.G_FALSE,

1946: | Get message count and if 1, return message data |
1947: +---------------------------------------------------*/
1948:
1949: FND_MSG_PUB.Count_And_Get(
1950: p_encoded => FND_API.G_FALSE,
1951: p_count => p_msg_count,
1952: p_data => p_msg_data
1953: );
1954: IF PG_DEBUG in ('Y', 'C') THEN

Line 1976: p_encoded => FND_API.G_FALSE,

1972: | Get message count and if 1, return message data |
1973: +---------------------------------------------------*/
1974:
1975: FND_MSG_PUB.Count_And_Get(
1976: p_encoded => FND_API.G_FALSE,
1977: p_count => p_msg_count,
1978: p_data => p_msg_data
1979: );
1980:

Line 1985: IF FND_API.To_Boolean( p_commit_flag )

1981: /*--------------------------------+
1982: | Standard check of p_commit |
1983: +--------------------------------*/
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;

Line 2007: WHEN FND_API.G_EXC_ERROR THEN

2003: END IF;
2004: END IF;
2005:
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);

Line 2015: p_return_status := FND_API.G_RET_STS_ERROR ;

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 ;
2016: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
2017: p_count => p_msg_count,
2018: p_data => p_msg_data
2019: );

Line 2016: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

2012: END IF;
2013:
2014: ROLLBACK TO ar_adjust_PUB;
2015: p_return_status := FND_API.G_RET_STS_ERROR ;
2016: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
2017: p_count => p_msg_count,
2018: p_data => p_msg_data
2019: );
2020:

Line 2021: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2017: p_count => p_msg_count,
2018: p_data => p_msg_data
2019: );
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;

Line 2027: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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,
2029: p_count => p_msg_count,
2030: p_data => p_msg_data
2031: );

Line 2028: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

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,
2029: p_count => p_msg_count,
2030: p_data => p_msg_data
2031: );
2032:

Line 2043: p_return_status := FND_API.G_RET_STS_ERROR ;

2039: +-------------------------------------------------------*/
2040:
2041: IF (SQLCODE = -20001)
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. ' ||

Line 2051: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

2047: 'Completion validation error(s) occurred. ' ||
2048: 'Rolling back and setting status to ERROR');
2049: END IF;
2050:
2051: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
2052: p_count => p_msg_count,
2053: p_data => p_msg_data
2054: );
2055: RETURN;

Line 2076: | fnd_api.compatible_api_call |

2072: | |
2073: | SCOPE - PUBLIC |
2074: | |
2075: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
2076: | fnd_api.compatible_api_call |
2077: | fnd_api.g_exc_unexpected_error |
2078: | fnd_api.g_ret_sts_error |
2079: | fnd_api.g_ret_sts_error |
2080: | fnd_api.g_ret_sts_success |

Line 2077: | fnd_api.g_exc_unexpected_error |

2073: | SCOPE - PUBLIC |
2074: | |
2075: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
2076: | fnd_api.compatible_api_call |
2077: | fnd_api.g_exc_unexpected_error |
2078: | fnd_api.g_ret_sts_error |
2079: | fnd_api.g_ret_sts_error |
2080: | fnd_api.g_ret_sts_success |
2081: | fnd_api.to_boolean |

Line 2078: | fnd_api.g_ret_sts_error |

2074: | |
2075: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
2076: | fnd_api.compatible_api_call |
2077: | fnd_api.g_exc_unexpected_error |
2078: | fnd_api.g_ret_sts_error |
2079: | fnd_api.g_ret_sts_error |
2080: | fnd_api.g_ret_sts_success |
2081: | fnd_api.to_boolean |
2082: | fnd_msg_pub.check_msg_level |

Line 2079: | fnd_api.g_ret_sts_error |

2075: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
2076: | fnd_api.compatible_api_call |
2077: | fnd_api.g_exc_unexpected_error |
2078: | fnd_api.g_ret_sts_error |
2079: | fnd_api.g_ret_sts_error |
2080: | fnd_api.g_ret_sts_success |
2081: | fnd_api.to_boolean |
2082: | fnd_msg_pub.check_msg_level |
2083: | fnd_msg_pub.count_and_get |

Line 2080: | fnd_api.g_ret_sts_success |

2076: | fnd_api.compatible_api_call |
2077: | fnd_api.g_exc_unexpected_error |
2078: | fnd_api.g_ret_sts_error |
2079: | fnd_api.g_ret_sts_error |
2080: | fnd_api.g_ret_sts_success |
2081: | fnd_api.to_boolean |
2082: | fnd_msg_pub.check_msg_level |
2083: | fnd_msg_pub.count_and_get |
2084: | fnd_msg_pub.initialize |

Line 2081: | fnd_api.to_boolean |

2077: | fnd_api.g_exc_unexpected_error |
2078: | fnd_api.g_ret_sts_error |
2079: | fnd_api.g_ret_sts_error |
2080: | fnd_api.g_ret_sts_success |
2081: | fnd_api.to_boolean |
2082: | fnd_msg_pub.check_msg_level |
2083: | fnd_msg_pub.count_and_get |
2084: | fnd_msg_pub.initialize |
2085: | ar_adjvalidate_pvt.Init_Context_Rec |

Line 2121: p_init_msg_list IN varchar2 := FND_API.G_FALSE,

2117:
2118: PROCEDURE create_linelevel_adjustment (
2119: p_api_name IN varchar2,
2120: p_api_version IN number,
2121: p_init_msg_list IN varchar2 := FND_API.G_FALSE,
2122: p_commit_flag IN varchar2 := FND_API.G_FALSE,
2123: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,
2124: p_msg_count OUT NOCOPY number,
2125: p_msg_data OUT NOCOPY varchar2,

Line 2122: p_commit_flag IN varchar2 := FND_API.G_FALSE,

2118: PROCEDURE create_linelevel_adjustment (
2119: p_api_name IN varchar2,
2120: p_api_version IN number,
2121: p_init_msg_list IN varchar2 := FND_API.G_FALSE,
2122: p_commit_flag IN varchar2 := FND_API.G_FALSE,
2123: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,
2124: p_msg_count OUT NOCOPY number,
2125: p_msg_data OUT NOCOPY varchar2,
2126: p_return_status OUT NOCOPY varchar2 ,

Line 2123: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,

2119: p_api_name IN varchar2,
2120: p_api_version IN number,
2121: p_init_msg_list IN varchar2 := FND_API.G_FALSE,
2122: p_commit_flag IN varchar2 := FND_API.G_FALSE,
2123: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,
2124: p_msg_count OUT NOCOPY number,
2125: p_msg_data OUT NOCOPY varchar2,
2126: p_return_status OUT NOCOPY varchar2 ,
2127: p_adj_rec IN ar_adjustments%rowtype,

Line 2128: p_chk_approval_limits IN varchar2 := FND_API.G_TRUE,

2124: p_msg_count OUT NOCOPY number,
2125: p_msg_data OUT NOCOPY varchar2,
2126: p_return_status OUT NOCOPY varchar2 ,
2127: p_adj_rec IN ar_adjustments%rowtype,
2128: p_chk_approval_limits IN varchar2 := FND_API.G_TRUE,
2129: p_llca_adj_trx_lines_tbl IN llca_adj_trx_line_tbl_type,
2130: p_check_amount IN varchar2 := FND_API.G_TRUE,
2131: p_move_deferred_tax IN varchar2,
2132: p_llca_adj_create_tbl_type OUT NOCOPY llca_adj_create_tbl_type,

Line 2130: p_check_amount IN varchar2 := FND_API.G_TRUE,

2126: p_return_status OUT NOCOPY varchar2 ,
2127: p_adj_rec IN ar_adjustments%rowtype,
2128: p_chk_approval_limits IN varchar2 := FND_API.G_TRUE,
2129: p_llca_adj_trx_lines_tbl IN llca_adj_trx_line_tbl_type,
2130: p_check_amount IN varchar2 := FND_API.G_TRUE,
2131: p_move_deferred_tax IN varchar2,
2132: p_llca_adj_create_tbl_type OUT NOCOPY llca_adj_create_tbl_type,
2133: p_called_from IN varchar2,
2134: p_old_adjust_id IN ar_adjustments.adjustment_id%type,

Line 2186: IF NOT FND_API.Compatible_API_Call(

2182: /*--------------------------------------------------+
2183: | Standard call to check for call compatibility |
2184: +--------------------------------------------------*/
2185:
2186: IF NOT FND_API.Compatible_API_Call(
2187: l_api_version,
2188: p_api_version,
2189: l_api_name,
2190: G_PKG_NAME

Line 2196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:
2199: /*-------------------------------------------------------------+
2200: | Initialize message list if p_init_msg_list is set to TRUE |

Line 2203: IF FND_API.to_Boolean( p_init_msg_list )

2199: /*-------------------------------------------------------------+
2200: | Initialize message list if p_init_msg_list is set to TRUE |
2201: +-------------------------------------------------------------*/
2202:
2203: IF FND_API.to_Boolean( p_init_msg_list )
2204: THEN
2205: FND_MSG_PUB.initialize;
2206: END IF;
2207:

Line 2218: p_return_status := FND_API.G_RET_STS_SUCCESS;

2214: /*-----------------------------------------+
2215: | Initialize return status to SUCCESS |
2216: +-----------------------------------------*/
2217:
2218: p_return_status := FND_API.G_RET_STS_SUCCESS;
2219:
2220: /* SSA change */
2221: l_org_id := p_org_id;
2222: l_org_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2222: l_org_return_status := FND_API.G_RET_STS_SUCCESS;

2218: p_return_status := FND_API.G_RET_STS_SUCCESS;
2219:
2220: /* SSA change */
2221: l_org_id := p_org_id;
2222: l_org_return_status := FND_API.G_RET_STS_SUCCESS;
2223: ar_mo_cache_utils.set_org_context_in_api(p_org_id =>l_org_id,
2224: p_return_status =>l_org_return_status);
2225: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2226: p_return_status := FND_API.G_RET_STS_ERROR;

Line 2225: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2221: l_org_id := p_org_id;
2222: l_org_return_status := FND_API.G_RET_STS_SUCCESS;
2223: ar_mo_cache_utils.set_org_context_in_api(p_org_id =>l_org_id,
2224: p_return_status =>l_org_return_status);
2225: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2226: p_return_status := FND_API.G_RET_STS_ERROR;
2227: ELSE
2228: --Verify whether line level adjustment is allowed for given org/invoice
2229: IF NOT arp_standard.is_llca_allowed(l_org_id,p_adj_rec.customer_trx_id) THEN

Line 2226: p_return_status := FND_API.G_RET_STS_ERROR;

2222: l_org_return_status := FND_API.G_RET_STS_SUCCESS;
2223: ar_mo_cache_utils.set_org_context_in_api(p_org_id =>l_org_id,
2224: p_return_status =>l_org_return_status);
2225: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2226: p_return_status := FND_API.G_RET_STS_ERROR;
2227: ELSE
2228: --Verify whether line level adjustment is allowed for given org/invoice
2229: IF NOT arp_standard.is_llca_allowed(l_org_id,p_adj_rec.customer_trx_id) THEN
2230: FND_MESSAGE.set_name('AR', 'AR_SUMMARIZED_DIST_NO_LLCA_ADJ');

Line 2232: l_return_status := FND_API.G_RET_STS_ERROR;

2228: --Verify whether line level adjustment is allowed for given org/invoice
2229: IF NOT arp_standard.is_llca_allowed(l_org_id,p_adj_rec.customer_trx_id) THEN
2230: FND_MESSAGE.set_name('AR', 'AR_SUMMARIZED_DIST_NO_LLCA_ADJ');
2231: FND_MSG_PUB.Add;
2232: l_return_status := FND_API.G_RET_STS_ERROR;
2233: RAISE FND_API.G_EXC_ERROR;
2234: END IF;
2235:
2236: /*---------------------------------------------+

Line 2233: RAISE FND_API.G_EXC_ERROR;

2229: IF NOT arp_standard.is_llca_allowed(l_org_id,p_adj_rec.customer_trx_id) THEN
2230: FND_MESSAGE.set_name('AR', 'AR_SUMMARIZED_DIST_NO_LLCA_ADJ');
2231: FND_MSG_PUB.Add;
2232: l_return_status := FND_API.G_RET_STS_ERROR;
2233: RAISE FND_API.G_EXC_ERROR;
2234: END IF;
2235:
2236: /*---------------------------------------------+
2237: | ========== Start of API Body ========== |

Line 2261: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )

2257: | Check the return status |
2258: /*---------------------------------------------------+
2259:
2260:
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 ' );

Line 2282: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )

2278: /*---------------------------------------------------+
2279: | Check the return status |
2280: /*---------------------------------------------------+
2281:
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 ' );

Line 2314: l_chk_approval_limits := FND_API.G_TRUE;

2310: l_chk_approval_limits := p_chk_approval_limits;
2311: l_check_amount := p_check_amount;
2312:
2313: IF (l_chk_approval_limits IS NULL) THEN
2314: l_chk_approval_limits := FND_API.G_TRUE;
2315: END IF;
2316:
2317: IF (l_check_amount IS NULL) THEN
2318: l_check_amount := FND_API.G_TRUE;

Line 2318: l_check_amount := FND_API.G_TRUE;

2314: l_chk_approval_limits := FND_API.G_TRUE;
2315: END IF;
2316:
2317: IF (l_check_amount IS NULL) THEN
2318: l_check_amount := FND_API.G_TRUE;
2319: END IF;
2320:
2321:
2322: populate_adj_llca_gt (

Line 2328: IF l_gt_return_status <> FND_API.G_RET_STS_SUCCESS

2324: p_llca_adj_trx_lines_tbl => p_llca_adj_trx_lines_tbl,
2325: p_return_status => l_gt_return_status);
2326:
2327:
2328: IF l_gt_return_status <> FND_API.G_RET_STS_SUCCESS
2329: THEN
2330:
2331: p_return_status := FND_API.G_RET_STS_ERROR ;
2332:

Line 2331: p_return_status := FND_API.G_RET_STS_ERROR ;

2327:
2328: IF l_gt_return_status <> FND_API.G_RET_STS_SUCCESS
2329: THEN
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');

Line 2340: IF (p_return_status = FND_API.G_RET_STS_ERROR)

2336: END IF;
2337:
2338: END IF;
2339:
2340: IF (p_return_status = FND_API.G_RET_STS_ERROR)
2341: THEN
2342: RAISE FND_API.G_EXC_ERROR;
2343:
2344: ELSIF (p_return_status = FND_API.G_RET_STS_UNEXP_ERROR)

Line 2342: RAISE FND_API.G_EXC_ERROR;

2338: END IF;
2339:
2340: IF (p_return_status = FND_API.G_RET_STS_ERROR)
2341: THEN
2342: RAISE FND_API.G_EXC_ERROR;
2343:
2344: ELSIF (p_return_status = FND_API.G_RET_STS_UNEXP_ERROR)
2345: THEN
2346: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2344: ELSIF (p_return_status = FND_API.G_RET_STS_UNEXP_ERROR)

2340: IF (p_return_status = FND_API.G_RET_STS_ERROR)
2341: THEN
2342: RAISE FND_API.G_EXC_ERROR;
2343:
2344: ELSIF (p_return_status = FND_API.G_RET_STS_UNEXP_ERROR)
2345: THEN
2346: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2347: END IF;
2348:

Line 2346: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2342: RAISE FND_API.G_EXC_ERROR;
2343:
2344: ELSIF (p_return_status = FND_API.G_RET_STS_UNEXP_ERROR)
2345: THEN
2346: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2347: END IF;
2348:
2349: /*--------------------------------------------------+
2350: | Header level Validation Call |

Line 2359: IF l_hdr_return_status <> FND_API.G_RET_STS_SUCCESS

2355: p_adj_rec,
2356: l_hdr_return_status);
2357:
2358:
2359: IF l_hdr_return_status <> FND_API.G_RET_STS_SUCCESS
2360: THEN
2361: p_return_status := FND_API.G_RET_STS_ERROR ;
2362:
2363: IF PG_DEBUG in ('Y', 'C') THEN

Line 2361: p_return_status := FND_API.G_RET_STS_ERROR ;

2357:
2358:
2359: IF l_hdr_return_status <> FND_API.G_RET_STS_SUCCESS
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');

Line 2371: IF (p_return_status = FND_API.G_RET_STS_ERROR)

2367:
2368: END IF;
2369:
2370:
2371: IF (p_return_status = FND_API.G_RET_STS_ERROR)
2372: THEN
2373: RAISE FND_API.G_EXC_ERROR;
2374:
2375: ELSIF (p_return_status = FND_API.G_RET_STS_UNEXP_ERROR)

Line 2373: RAISE FND_API.G_EXC_ERROR;

2369:
2370:
2371: IF (p_return_status = FND_API.G_RET_STS_ERROR)
2372: THEN
2373: RAISE FND_API.G_EXC_ERROR;
2374:
2375: ELSIF (p_return_status = FND_API.G_RET_STS_UNEXP_ERROR)
2376: THEN
2377: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2375: ELSIF (p_return_status = FND_API.G_RET_STS_UNEXP_ERROR)

2371: IF (p_return_status = FND_API.G_RET_STS_ERROR)
2372: THEN
2373: RAISE FND_API.G_EXC_ERROR;
2374:
2375: ELSIF (p_return_status = FND_API.G_RET_STS_UNEXP_ERROR)
2376: THEN
2377: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2378: END IF;
2379:

Line 2377: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2373: RAISE FND_API.G_EXC_ERROR;
2374:
2375: ELSIF (p_return_status = FND_API.G_RET_STS_UNEXP_ERROR)
2376: THEN
2377: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2378: END IF;
2379:
2380:
2381: IF ( p_return_status = FND_API.G_RET_STS_SUCCESS ) -- Start of for loop processing

Line 2381: IF ( p_return_status = FND_API.G_RET_STS_SUCCESS ) -- Start of for loop processing

2377: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2378: END IF;
2379:
2380:
2381: IF ( p_return_status = FND_API.G_RET_STS_SUCCESS ) -- Start of for loop processing
2382: THEN
2383:
2384:
2385: --For i in p_llca_adj_trx_lines_tbl.FIRST..p_llca_adj_trx_lines_tbl.LAST

Line 2393: l_line_return_status := FND_API.G_RET_STS_SUCCESS;

2389: /* l_inp_adj_rec.customer_trx_line_id := p_llca_adj_trx_lines_tbl(i).customer_trx_line_id;
2390: l_inp_adj_rec.receivables_trx_id := p_llca_adj_trx_lines_tbl(i).receivables_trx_id;
2391: l_inp_adj_rec.amount := p_llca_adj_trx_lines_tbl(i).line_amount;*/
2392:
2393: l_line_return_status := FND_API.G_RET_STS_SUCCESS;
2394:
2395:
2396: l_inp_adj_rec.customer_trx_line_id := gt_adj_lines_row.customer_trx_line_id;
2397: l_inp_adj_rec.receivables_trx_id := gt_adj_lines_row.receivables_trx_id;

Line 2425: l_line_return_status := FND_API.G_RET_STS_ERROR;

2421: 'AR_RAPI_TRX_LINE_ID_INVALID ',
2422: 'customer_trx_line_id'
2423: );
2424:
2425: l_line_return_status := FND_API.G_RET_STS_ERROR;
2426:
2427: ELSIF gt_adj_lines_row.receivables_trx_id IS NULL
2428: THEN
2429:

Line 2447: l_line_return_status := FND_API.G_RET_STS_ERROR;

2443: 'AR_RAPI_RECEIVABLES_TRX_ID_INVALID ',
2444: 'receivables_trx_id'
2445: );
2446:
2447: l_line_return_status := FND_API.G_RET_STS_ERROR;
2448:
2449: ELSE
2450:
2451: ar_adjust_pub.Validate_Adj_Insert(

Line 2459: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )

2455: l_return_status,
2456: 'Y'
2457: );
2458:
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.');

Line 2475: IF ( l_line_return_status = FND_API.G_RET_STS_SUCCESS ) THEN

2471: | Reset attributes which should not be populated |
2472: +-----------------------------------------------*/
2473:
2474:
2475: IF ( l_line_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
2476: ar_adjust_pub.Set_Remaining_Attributes (
2477: l_inp_adj_rec,
2478: l_return_status
2479: ) ;

Line 2481: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )

2477: l_inp_adj_rec,
2478: l_return_status
2479: ) ;
2480:
2481: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
2482: THEN
2483:
2484: l_line_return_status := l_return_status ;
2485: IF PG_DEBUG in ('Y', 'C') THEN

Line 2492: p_return_status := FND_API.G_RET_STS_ERROR ; -- Bug 12635650

2488: END IF;
2489:
2490: END IF;
2491: ELSE
2492: p_return_status := FND_API.G_RET_STS_ERROR ; -- Bug 12635650
2493:
2494: END IF;
2495:
2496: END IF; -- Check for null Customer Trx Line Id

Line 2502: IF ( l_line_return_status = FND_API.G_RET_STS_SUCCESS ) THEN -- Processing the adjustment

2498: /*-----------------------------------------------+
2499: | Call the entity Handler for insert |
2500: +-----------------------------------------------*/
2501:
2502: IF ( l_line_return_status = FND_API.G_RET_STS_SUCCESS ) THEN -- Processing the adjustment
2503:
2504: IF (l_inp_adj_rec.code_combination_id is NOT NULL) THEN
2505: l_override_flag := 'Y';
2506: END IF;

Line 2539: p_return_status := FND_API.G_RET_STS_ERROR ;

2535: | Rollback to the defined Savepoint |
2536: +---------------------------------------------------*/
2537:
2538: ROLLBACK TO ar_adjust_line_PUB;
2539: p_return_status := FND_API.G_RET_STS_ERROR ;
2540:
2541: FND_MESSAGE.set_name( 'AR', 'GENERIC_MESSAGE' );
2542: FND_MESSAGE.set_token( 'GENERIC_TEXT', 'arp_process_adjustment.insert_adjustment exception: '||SQLERRM );
2543: --2920926

Line 2550: p_encoded => FND_API.G_FALSE,

2546: | Get message count and if 1, return message data |
2547: +---------------------------------------------------*/
2548:
2549: FND_MSG_PUB.Count_And_Get(
2550: p_encoded => FND_API.G_FALSE,
2551: p_count => p_msg_count,
2552: p_data => p_msg_data
2553: );
2554: IF PG_DEBUG in ('Y', 'C') THEN

Line 2585: p_encoded => FND_API.G_FALSE,

2581: | Get message count and if 1, return message data |
2582: +---------------------------------------------------*/
2583:
2584: FND_MSG_PUB.Count_And_Get(
2585: p_encoded => FND_API.G_FALSE,
2586: p_count => p_msg_count,
2587: p_data => p_msg_data
2588: );
2589:

Line 2594: IF FND_API.To_Boolean( p_commit_flag )

2590: /*--------------------------------+
2591: | Standard check of p_commit |
2592: +--------------------------------*/
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;

Line 2616: WHEN FND_API.G_EXC_ERROR THEN

2612: END IF;
2613: END IF;
2614:
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);

Line 2624: p_return_status := FND_API.G_RET_STS_ERROR ;

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 ;
2625: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
2626: p_count => p_msg_count,
2627: p_data => p_msg_data
2628: );

Line 2625: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

2621: END IF;
2622:
2623: ROLLBACK TO ar_adjust_line_PUB;
2624: p_return_status := FND_API.G_RET_STS_ERROR ;
2625: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
2626: p_count => p_msg_count,
2627: p_data => p_msg_data
2628: );
2629:

Line 2630: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2626: p_count => p_msg_count,
2627: p_data => p_msg_data
2628: );
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;

Line 2636: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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,
2638: p_count => p_msg_count,
2639: p_data => p_msg_data
2640: );

Line 2637: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

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,
2638: p_count => p_msg_count,
2639: p_data => p_msg_data
2640: );
2641:

Line 2652: p_return_status := FND_API.G_RET_STS_ERROR ;

2648: +-------------------------------------------------------*/
2649:
2650: IF (SQLCODE = -20001)
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. ' ||

Line 2660: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

2656: 'Completion validation error(s) occurred. ' ||
2657: 'Rolling back and setting status to ERROR');
2658: END IF;
2659:
2660: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
2661: p_count => p_msg_count,
2662: p_data => p_msg_data
2663: );
2664: RETURN;

Line 2684: | fnd_api.compatible_api_call |

2680: | |
2681: | SCOPE - PUBLIC |
2682: | |
2683: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
2684: | fnd_api.compatible_api_call |
2685: | fnd_api.g_exc_unexpected_error |
2686: | fnd_api.g_ret_sts_error |
2687: | fnd_api.g_ret_sts_error |
2688: | fnd_api.g_ret_sts_success |

Line 2685: | fnd_api.g_exc_unexpected_error |

2681: | SCOPE - PUBLIC |
2682: | |
2683: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
2684: | fnd_api.compatible_api_call |
2685: | fnd_api.g_exc_unexpected_error |
2686: | fnd_api.g_ret_sts_error |
2687: | fnd_api.g_ret_sts_error |
2688: | fnd_api.g_ret_sts_success |
2689: | fnd_api.to_boolean |

Line 2686: | fnd_api.g_ret_sts_error |

2682: | |
2683: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
2684: | fnd_api.compatible_api_call |
2685: | fnd_api.g_exc_unexpected_error |
2686: | fnd_api.g_ret_sts_error |
2687: | fnd_api.g_ret_sts_error |
2688: | fnd_api.g_ret_sts_success |
2689: | fnd_api.to_boolean |
2690: | fnd_msg_pub.check_msg_level |

Line 2687: | fnd_api.g_ret_sts_error |

2683: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
2684: | fnd_api.compatible_api_call |
2685: | fnd_api.g_exc_unexpected_error |
2686: | fnd_api.g_ret_sts_error |
2687: | fnd_api.g_ret_sts_error |
2688: | fnd_api.g_ret_sts_success |
2689: | fnd_api.to_boolean |
2690: | fnd_msg_pub.check_msg_level |
2691: | fnd_msg_pub.count_and_get |

Line 2688: | fnd_api.g_ret_sts_success |

2684: | fnd_api.compatible_api_call |
2685: | fnd_api.g_exc_unexpected_error |
2686: | fnd_api.g_ret_sts_error |
2687: | fnd_api.g_ret_sts_error |
2688: | fnd_api.g_ret_sts_success |
2689: | fnd_api.to_boolean |
2690: | fnd_msg_pub.check_msg_level |
2691: | fnd_msg_pub.count_and_get |
2692: | fnd_msg_pub.initialize |

Line 2689: | fnd_api.to_boolean |

2685: | fnd_api.g_exc_unexpected_error |
2686: | fnd_api.g_ret_sts_error |
2687: | fnd_api.g_ret_sts_error |
2688: | fnd_api.g_ret_sts_success |
2689: | fnd_api.to_boolean |
2690: | fnd_msg_pub.check_msg_level |
2691: | fnd_msg_pub.count_and_get |
2692: | fnd_msg_pub.initialize |
2693: | ar_adjustments_pkg.fetch_p |

Line 2736: p_init_msg_list IN varchar2 := FND_API.G_FALSE,

2732:
2733: PROCEDURE Modify_Adjustment (
2734: p_api_name IN varchar2,
2735: p_api_version IN number,
2736: p_init_msg_list IN varchar2 := FND_API.G_FALSE,
2737: p_commit_flag IN varchar2 := FND_API.G_FALSE,
2738: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,
2739: p_msg_count OUT NOCOPY number,
2740: p_msg_data OUT NOCOPY varchar2,

Line 2737: p_commit_flag IN varchar2 := FND_API.G_FALSE,

2733: PROCEDURE Modify_Adjustment (
2734: p_api_name IN varchar2,
2735: p_api_version IN number,
2736: p_init_msg_list IN varchar2 := FND_API.G_FALSE,
2737: p_commit_flag IN varchar2 := FND_API.G_FALSE,
2738: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,
2739: p_msg_count OUT NOCOPY number,
2740: p_msg_data OUT NOCOPY varchar2,
2741: p_return_status OUT NOCOPY varchar2 ,

Line 2738: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,

2734: p_api_name IN varchar2,
2735: p_api_version IN number,
2736: p_init_msg_list IN varchar2 := FND_API.G_FALSE,
2737: p_commit_flag IN varchar2 := FND_API.G_FALSE,
2738: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,
2739: p_msg_count OUT NOCOPY number,
2740: p_msg_data OUT NOCOPY varchar2,
2741: p_return_status OUT NOCOPY varchar2 ,
2742: p_adj_rec IN ar_adjustments%rowtype,

Line 2743: p_chk_approval_limits IN varchar2 := FND_API.G_TRUE,

2739: p_msg_count OUT NOCOPY number,
2740: p_msg_data OUT NOCOPY varchar2,
2741: p_return_status OUT NOCOPY varchar2 ,
2742: p_adj_rec IN ar_adjustments%rowtype,
2743: p_chk_approval_limits IN varchar2 := FND_API.G_TRUE,
2744: p_move_deferred_tax IN varchar2,
2745: p_old_adjust_id IN ar_adjustments.adjustment_id%type,
2746: p_org_id IN NUMBER DEFAULT NULL
2747: ) IS

Line 2755: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;

2751: l_old_adj_rec ar_adjustments%rowtype;
2752: l_hsec VARCHAR2(10);
2753: l_status number;
2754: l_inp_adj_rec ar_adjustments%rowtype;
2755: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
2756: l_chk_approval_limits varchar2(1);
2757: l_org_return_status VARCHAR2(1);
2758: l_org_id NUMBER;
2759:

Line 2778: IF NOT FND_API.Compatible_API_Call(

2774: /*--------------------------------------------------+
2775: | Standard call to check for call compatibility |
2776: +--------------------------------------------------*/
2777:
2778: IF NOT FND_API.Compatible_API_Call(
2779: l_api_version,
2780: p_api_version,
2781: l_api_name,
2782: G_PKG_NAME

Line 2788: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:
2791: /*-------------------------------------------------------------+
2792: | Initialize message list if p_init_msg_list is set to TRUE |

Line 2795: IF FND_API.to_Boolean( p_init_msg_list )

2791: /*-------------------------------------------------------------+
2792: | Initialize message list if p_init_msg_list is set to TRUE |
2793: +-------------------------------------------------------------*/
2794:
2795: IF FND_API.to_Boolean( p_init_msg_list )
2796: THEN
2797: FND_MSG_PUB.initialize;
2798: END IF;
2799:

Line 2811: p_return_status := FND_API.G_RET_STS_SUCCESS;

2807: /*-----------------------------------------+
2808: | Initialize return status to SUCCESS |
2809: +-----------------------------------------*/
2810:
2811: p_return_status := FND_API.G_RET_STS_SUCCESS;
2812:
2813:
2814:
2815: /* SSA change */

Line 2817: l_org_return_status := FND_API.G_RET_STS_SUCCESS;

2813:
2814:
2815: /* SSA change */
2816: l_org_id := p_org_id;
2817: l_org_return_status := FND_API.G_RET_STS_SUCCESS;
2818: ar_mo_cache_utils.set_org_context_in_api(p_org_id =>l_org_id,
2819: p_return_status =>l_org_return_status);
2820: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2821: p_return_status := FND_API.G_RET_STS_ERROR;

Line 2820: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2816: l_org_id := p_org_id;
2817: l_org_return_status := FND_API.G_RET_STS_SUCCESS;
2818: ar_mo_cache_utils.set_org_context_in_api(p_org_id =>l_org_id,
2819: p_return_status =>l_org_return_status);
2820: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2821: p_return_status := FND_API.G_RET_STS_ERROR;
2822: ELSE
2823: /*---------------------------------------------+
2824: | ========== Start of API Body ========== |

Line 2821: p_return_status := FND_API.G_RET_STS_ERROR;

2817: l_org_return_status := FND_API.G_RET_STS_SUCCESS;
2818: ar_mo_cache_utils.set_org_context_in_api(p_org_id =>l_org_id,
2819: p_return_status =>l_org_return_status);
2820: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2821: p_return_status := FND_API.G_RET_STS_ERROR;
2822: ELSE
2823: /*---------------------------------------------+
2824: | ========== Start of API Body ========== |
2825: +---------------------------------------------*/

Line 2846: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )

2842: /*------------------------------------------------+
2843: | Check status and return if error |
2844: +------------------------------------------------*/
2845:
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 ');

Line 2865: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )

2861: /*------------------------------------------------+
2862: | Check status and return if error |
2863: +------------------------------------------------*/
2864:
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 ');

Line 2887: p_return_status := FND_API.G_RET_STS_ERROR ;

2883: /*---------------------------------------------------+
2884: | Rollback to the defined Savepoint |
2885: +---------------------------------------------------*/
2886: ROLLBACK TO ar_adjust_PUB;
2887: p_return_status := FND_API.G_RET_STS_ERROR ;
2888: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_INVALID_ADJ_ID');
2889: FND_MESSAGE.SET_TOKEN ( 'ADJUSTMENT_ID', to_char(p_old_adjust_id) ) ;
2890: FND_MSG_PUB.ADD ;
2891: RETURN;

Line 2900: IF (p_return_status = FND_API.G_RET_STS_ERROR)

2896:
2897: /*-----------------------------------------------+
2898: | Handling Line level the validation exceptions |
2899: +-----------------------------------------------*/
2900: IF (p_return_status = FND_API.G_RET_STS_ERROR)
2901: THEN
2902: RAISE FND_API.G_EXC_ERROR;
2903: ELSIF (p_return_status = FND_API.G_RET_STS_UNEXP_ERROR)
2904: THEN

Line 2902: RAISE FND_API.G_EXC_ERROR;

2898: | Handling Line level the validation exceptions |
2899: +-----------------------------------------------*/
2900: IF (p_return_status = FND_API.G_RET_STS_ERROR)
2901: THEN
2902: RAISE FND_API.G_EXC_ERROR;
2903: ELSIF (p_return_status = FND_API.G_RET_STS_UNEXP_ERROR)
2904: THEN
2905: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2906: END IF;

Line 2903: ELSIF (p_return_status = FND_API.G_RET_STS_UNEXP_ERROR)

2899: +-----------------------------------------------*/
2900: IF (p_return_status = FND_API.G_RET_STS_ERROR)
2901: THEN
2902: RAISE FND_API.G_EXC_ERROR;
2903: ELSIF (p_return_status = FND_API.G_RET_STS_UNEXP_ERROR)
2904: THEN
2905: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2906: END IF;
2907:

Line 2905: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2901: THEN
2902: RAISE FND_API.G_EXC_ERROR;
2903: ELSIF (p_return_status = FND_API.G_RET_STS_UNEXP_ERROR)
2904: THEN
2905: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2906: END IF;
2907:
2908:
2909:

Line 2921: l_chk_approval_limits := FND_API.G_TRUE;

2917: | parameter p_chk_approval_limits is being passed. |
2918: +--------------------------------------------------*/
2919: l_chk_approval_limits := p_chk_approval_limits;
2920: IF (l_chk_approval_limits IS NULL) THEN
2921: l_chk_approval_limits := FND_API.G_TRUE;
2922: END IF;
2923:
2924: ar_adjust_pub.Validate_Adj_Modify (
2925: l_inp_adj_rec,

Line 2932: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )

2928: l_return_status
2929: );
2930:
2931:
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: ' ||

Line 2946: IF (p_return_status = FND_API.G_RET_STS_ERROR)

2942:
2943: /*-----------------------------------------------+
2944: | Handling all the validation exceptions |
2945: +-----------------------------------------------*/
2946: IF (p_return_status = FND_API.G_RET_STS_ERROR)
2947: THEN
2948: RAISE FND_API.G_EXC_ERROR;
2949: ELSIF (p_return_status = FND_API.G_RET_STS_UNEXP_ERROR)
2950: THEN

Line 2948: RAISE FND_API.G_EXC_ERROR;

2944: | Handling all the validation exceptions |
2945: +-----------------------------------------------*/
2946: IF (p_return_status = FND_API.G_RET_STS_ERROR)
2947: THEN
2948: RAISE FND_API.G_EXC_ERROR;
2949: ELSIF (p_return_status = FND_API.G_RET_STS_UNEXP_ERROR)
2950: THEN
2951: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2952: END IF;

Line 2949: ELSIF (p_return_status = FND_API.G_RET_STS_UNEXP_ERROR)

2945: +-----------------------------------------------*/
2946: IF (p_return_status = FND_API.G_RET_STS_ERROR)
2947: THEN
2948: RAISE FND_API.G_EXC_ERROR;
2949: ELSIF (p_return_status = FND_API.G_RET_STS_UNEXP_ERROR)
2950: THEN
2951: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2952: END IF;
2953:

Line 2951: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2947: THEN
2948: RAISE FND_API.G_EXC_ERROR;
2949: ELSIF (p_return_status = FND_API.G_RET_STS_UNEXP_ERROR)
2950: THEN
2951: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2952: END IF;
2953:
2954:
2955: /*-----------------------------------------------+

Line 2975: p_return_status := FND_API.G_RET_STS_ERROR ;

2971: +---------------------------------------------------*/
2972:
2973: ROLLBACK TO ar_adjust_PUB;
2974:
2975: p_return_status := FND_API.G_RET_STS_ERROR ;
2976:
2977: FND_MESSAGE.set_name( 'AR', 'GENERIC_MESSAGE' );
2978: FND_MESSAGE.set_token( 'GENERIC_TEXT', 'arp_process_adjustment.update_adjustment exception: '||SQLERRM );
2979: --2920926

Line 2987: p_encoded => FND_API.G_FALSE,

2983: | Get message count and if 1, return message data |
2984: +---------------------------------------------------*/
2985:
2986: FND_MSG_PUB.Count_And_Get(
2987: p_encoded => FND_API.G_FALSE,
2988: p_count => p_msg_count,
2989: p_data => p_msg_data
2990: );
2991: IF PG_DEBUG in ('Y', 'C') THEN

Line 3011: p_encoded => FND_API.G_FALSE,

3007: | Get message count and if 1, return message data |
3008: +---------------------------------------------------*/
3009:
3010: FND_MSG_PUB.Count_And_Get(
3011: p_encoded => FND_API.G_FALSE,
3012: p_count => p_msg_count,
3013: p_data => p_msg_data
3014: );
3015:

Line 3020: IF FND_API.To_Boolean( p_commit_flag )

3016: /*--------------------------------+
3017: | Standard check of p_commit |
3018: +--------------------------------*/
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;

Line 3044: WHEN FND_API.G_EXC_ERROR THEN

3040:
3041:
3042:
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);

Line 3052: p_return_status := FND_API.G_RET_STS_ERROR ;

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 ;
3053: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
3054: p_count => p_msg_count,
3055: p_data => p_msg_data
3056: );

Line 3053: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

3049: END IF;
3050:
3051: ROLLBACK TO ar_adjust_PUB;
3052: p_return_status := FND_API.G_RET_STS_ERROR ;
3053: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
3054: p_count => p_msg_count,
3055: p_data => p_msg_data
3056: );
3057:

Line 3058: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3054: p_count => p_msg_count,
3055: p_data => p_msg_data
3056: );
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;

Line 3064: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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,
3066: p_count => p_msg_count,
3067: p_data => p_msg_data
3068: );

Line 3065: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

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,
3066: p_count => p_msg_count,
3067: p_data => p_msg_data
3068: );
3069:

Line 3080: p_return_status := FND_API.G_RET_STS_ERROR ;

3076: +-------------------------------------------------------*/
3077:
3078: IF (SQLCODE = -20001)
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. ' ||

Line 3087: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

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,
3088: p_count => p_msg_count,
3089: p_data => p_msg_data
3090: );
3091: RETURN;

Line 3111: | fnd_api.compatible_api_call |

3107: | |
3108: | SCOPE - PUBLIC |
3109: | |
3110: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
3111: | fnd_api.compatible_api_call |
3112: | fnd_api.g_exc_unexpected_error |
3113: | fnd_api.g_ret_sts_error |
3114: | fnd_api.g_ret_sts_error |
3115: | fnd_api.g_ret_sts_success |

Line 3112: | fnd_api.g_exc_unexpected_error |

3108: | SCOPE - PUBLIC |
3109: | |
3110: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
3111: | fnd_api.compatible_api_call |
3112: | fnd_api.g_exc_unexpected_error |
3113: | fnd_api.g_ret_sts_error |
3114: | fnd_api.g_ret_sts_error |
3115: | fnd_api.g_ret_sts_success |
3116: | fnd_api.to_boolean |

Line 3113: | fnd_api.g_ret_sts_error |

3109: | |
3110: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
3111: | fnd_api.compatible_api_call |
3112: | fnd_api.g_exc_unexpected_error |
3113: | fnd_api.g_ret_sts_error |
3114: | fnd_api.g_ret_sts_error |
3115: | fnd_api.g_ret_sts_success |
3116: | fnd_api.to_boolean |
3117: | fnd_msg_pub.check_msg_level |

Line 3114: | fnd_api.g_ret_sts_error |

3110: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
3111: | fnd_api.compatible_api_call |
3112: | fnd_api.g_exc_unexpected_error |
3113: | fnd_api.g_ret_sts_error |
3114: | fnd_api.g_ret_sts_error |
3115: | fnd_api.g_ret_sts_success |
3116: | fnd_api.to_boolean |
3117: | fnd_msg_pub.check_msg_level |
3118: | fnd_msg_pub.count_and_get |

Line 3115: | fnd_api.g_ret_sts_success |

3111: | fnd_api.compatible_api_call |
3112: | fnd_api.g_exc_unexpected_error |
3113: | fnd_api.g_ret_sts_error |
3114: | fnd_api.g_ret_sts_error |
3115: | fnd_api.g_ret_sts_success |
3116: | fnd_api.to_boolean |
3117: | fnd_msg_pub.check_msg_level |
3118: | fnd_msg_pub.count_and_get |
3119: | fnd_msg_pub.initialize |

Line 3116: | fnd_api.to_boolean |

3112: | fnd_api.g_exc_unexpected_error |
3113: | fnd_api.g_ret_sts_error |
3114: | fnd_api.g_ret_sts_error |
3115: | fnd_api.g_ret_sts_success |
3116: | fnd_api.to_boolean |
3117: | fnd_msg_pub.check_msg_level |
3118: | fnd_msg_pub.count_and_get |
3119: | fnd_msg_pub.initialize |
3120: | ar_adjustments_pkg.fetch_p |

Line 3163: p_init_msg_list IN varchar2 := FND_API.G_FALSE,

3159:
3160: PROCEDURE Reverse_Adjustment (
3161: p_api_name IN varchar2,
3162: p_api_version IN number,
3163: p_init_msg_list IN varchar2 := FND_API.G_FALSE,
3164: p_commit_flag IN varchar2 := FND_API.G_FALSE,
3165: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,
3166: p_msg_count OUT NOCOPY number,
3167: p_msg_data OUT NOCOPY varchar2,

Line 3164: p_commit_flag IN varchar2 := FND_API.G_FALSE,

3160: PROCEDURE Reverse_Adjustment (
3161: p_api_name IN varchar2,
3162: p_api_version IN number,
3163: p_init_msg_list IN varchar2 := FND_API.G_FALSE,
3164: p_commit_flag IN varchar2 := FND_API.G_FALSE,
3165: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,
3166: p_msg_count OUT NOCOPY number,
3167: p_msg_data OUT NOCOPY varchar2,
3168: p_return_status OUT NOCOPY varchar2,

Line 3165: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,

3161: p_api_name IN varchar2,
3162: p_api_version IN number,
3163: p_init_msg_list IN varchar2 := FND_API.G_FALSE,
3164: p_commit_flag IN varchar2 := FND_API.G_FALSE,
3165: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,
3166: p_msg_count OUT NOCOPY number,
3167: p_msg_data OUT NOCOPY varchar2,
3168: p_return_status OUT NOCOPY varchar2,
3169: p_old_adjust_id IN ar_adjustments.adjustment_id%type,

Line 3173: p_chk_approval_limits IN varchar2 := FND_API.G_TRUE,

3169: p_old_adjust_id IN ar_adjustments.adjustment_id%type,
3170: p_reversal_gl_date IN date,
3171: p_reversal_date IN date,
3172: p_comments IN ar_adjustments.comments%type,
3173: p_chk_approval_limits IN varchar2 := FND_API.G_TRUE,
3174: p_move_deferred_tax IN varchar2,
3175: p_new_adj_id OUT NOCOPY ar_adjustments.adjustment_id%type,
3176: p_called_from IN varchar2,
3177: p_org_id IN NUMBER DEFAULT NULL

Line 3193: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;

3189: l_msg_data varchar2(250);
3190: l_new_adj_num ar_adjustments.adjustment_number%type;
3191: l_check_amount varchar2(1);
3192:
3193: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
3194: l_chk_approval_limits varchar2(1);
3195: l_org_return_status VARCHAR2(1);
3196: l_org_id NUMBER;
3197:

Line 3222: IF NOT FND_API.Compatible_API_Call(

3218: /*--------------------------------------------------+
3219: | Standard call to check for call compatibility |
3220: +--------------------------------------------------*/
3221:
3222: IF NOT FND_API.Compatible_API_Call(
3223: l_api_version,
3224: p_api_version,
3225: l_api_name,
3226: G_PKG_NAME

Line 3232: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:
3235: /*-------------------------------------------------------------+
3236: | Initialize message list if p_init_msg_list is set to TRUE |

Line 3239: IF FND_API.to_Boolean( p_init_msg_list )

3235: /*-------------------------------------------------------------+
3236: | Initialize message list if p_init_msg_list is set to TRUE |
3237: +-------------------------------------------------------------*/
3238:
3239: IF FND_API.to_Boolean( p_init_msg_list )
3240: THEN
3241: FND_MSG_PUB.initialize;
3242: END IF;
3243:

Line 3255: p_return_status := FND_API.G_RET_STS_SUCCESS;

3251: /*-----------------------------------------+
3252: | Initialize return status to SUCCESS |
3253: +-----------------------------------------*/
3254:
3255: p_return_status := FND_API.G_RET_STS_SUCCESS;
3256:
3257:
3258:
3259: /* SSA change */

Line 3261: l_org_return_status := FND_API.G_RET_STS_SUCCESS;

3257:
3258:
3259: /* SSA change */
3260: l_org_id := p_org_id;
3261: l_org_return_status := FND_API.G_RET_STS_SUCCESS;
3262: ar_mo_cache_utils.set_org_context_in_api(p_org_id =>l_org_id,
3263: p_return_status =>l_org_return_status);
3264: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3265: p_return_status := FND_API.G_RET_STS_ERROR;

Line 3264: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3260: l_org_id := p_org_id;
3261: l_org_return_status := FND_API.G_RET_STS_SUCCESS;
3262: ar_mo_cache_utils.set_org_context_in_api(p_org_id =>l_org_id,
3263: p_return_status =>l_org_return_status);
3264: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3265: p_return_status := FND_API.G_RET_STS_ERROR;
3266: ELSE
3267: /*---------------------------------------------+
3268: | ========== Start of API Body ========== |

Line 3265: p_return_status := FND_API.G_RET_STS_ERROR;

3261: l_org_return_status := FND_API.G_RET_STS_SUCCESS;
3262: ar_mo_cache_utils.set_org_context_in_api(p_org_id =>l_org_id,
3263: p_return_status =>l_org_return_status);
3264: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3265: p_return_status := FND_API.G_RET_STS_ERROR;
3266: ELSE
3267: /*---------------------------------------------+
3268: | ========== Start of API Body ========== |
3269: +---------------------------------------------*/

Line 3284: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )

3280: /*------------------------------------------------+
3281: | Check status and return if error |
3282: +------------------------------------------------*/
3283:
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 ');

Line 3309: p_return_status := FND_API.G_RET_STS_ERROR ;

3305: +---------------------------------------------------*/
3306:
3307: ROLLBACK TO ar_adjust_PUB;
3308:
3309: p_return_status := FND_API.G_RET_STS_ERROR ;
3310:
3311: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_INVALID_ADJ_ID');
3312: FND_MESSAGE.SET_TOKEN ( 'ADJUSTMENT_ID', to_char(p_old_adjust_id) ) ;
3313: FND_MSG_PUB.ADD ;

Line 3328: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )

3324: /*------------------------------------------------+
3325: | Check status and return if error |
3326: +------------------------------------------------*/
3327:
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 ');

Line 3357: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )

3353: l_return_status
3354: );
3355:
3356:
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: ' ||

Line 3370: IF (p_return_status = FND_API.G_RET_STS_ERROR)

3366:
3367: /*-----------------------------------------------+
3368: | Handling all the validation exceptions |
3369: +-----------------------------------------------*/
3370: IF (p_return_status = FND_API.G_RET_STS_ERROR)
3371: THEN
3372: RAISE FND_API.G_EXC_ERROR;
3373: ELSIF (p_return_status = FND_API.G_RET_STS_UNEXP_ERROR)
3374: THEN

Line 3372: RAISE FND_API.G_EXC_ERROR;

3368: | Handling all the validation exceptions |
3369: +-----------------------------------------------*/
3370: IF (p_return_status = FND_API.G_RET_STS_ERROR)
3371: THEN
3372: RAISE FND_API.G_EXC_ERROR;
3373: ELSIF (p_return_status = FND_API.G_RET_STS_UNEXP_ERROR)
3374: THEN
3375: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3376: END IF;

Line 3373: ELSIF (p_return_status = FND_API.G_RET_STS_UNEXP_ERROR)

3369: +-----------------------------------------------*/
3370: IF (p_return_status = FND_API.G_RET_STS_ERROR)
3371: THEN
3372: RAISE FND_API.G_EXC_ERROR;
3373: ELSIF (p_return_status = FND_API.G_RET_STS_UNEXP_ERROR)
3374: THEN
3375: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3376: END IF;
3377:

Line 3375: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3371: THEN
3372: RAISE FND_API.G_EXC_ERROR;
3373: ELSIF (p_return_status = FND_API.G_RET_STS_UNEXP_ERROR)
3374: THEN
3375: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3376: END IF;
3377:
3378: /*------------------------------------------------------------+
3379: | Reverse the amounts and create a new adj adjustment record.|

Line 3472: l_check_amount := FND_API.G_FALSE;

3468: arp_util.debug('Reverse_Adjustment: ' || '--------------------------------------------------');
3469: END IF;
3470:
3471:
3472: l_check_amount := FND_API.G_FALSE;
3473:
3474: l_chk_approval_limits := p_chk_approval_limits;
3475: IF (l_chk_approval_limits IS NULL) THEN
3476: l_chk_approval_limits := FND_API.G_TRUE;

Line 3476: l_chk_approval_limits := FND_API.G_TRUE;

3472: l_check_amount := FND_API.G_FALSE;
3473:
3474: l_chk_approval_limits := p_chk_approval_limits;
3475: IF (l_chk_approval_limits IS NULL) THEN
3476: l_chk_approval_limits := FND_API.G_TRUE;
3477: END IF;
3478:
3479: /*--------------------------------------------------------------+
3480: | Call the create adjustment api to insert the new adjustment. |

Line 3505: p_return_status := FND_API.G_RET_STS_ERROR;

3501: p_called_from => p_called_from,
3502: p_old_adjust_id => p_old_adjust_id);
3503:
3504: IF l_llca_adj_create_tbl_type(1).adjustment_id IS NULL THEN
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: ' ||

Line 3535: p_return_status := FND_API.G_RET_STS_ERROR;

3531:
3532:
3533: /* Bugfix 2734179. Check if the new adjustment record was created. */
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 = ' ||

Line 3552: p_return_status := FND_API.G_RET_STS_ERROR ;

3548: | Rollback to the defined Savepoint |
3549: +---------------------------------------------------*/
3550:
3551: ROLLBACK TO ar_adjust_PUB;
3552: p_return_status := FND_API.G_RET_STS_ERROR ;
3553:
3554: /*--------------------------------------------------+
3555: | Get message count and if 1, return message data |
3556: +---------------------------------------------------*/

Line 3559: p_encoded => FND_API.G_FALSE,

3555: | Get message count and if 1, return message data |
3556: +---------------------------------------------------*/
3557:
3558: FND_MSG_PUB.Count_And_Get(
3559: p_encoded => FND_API.G_FALSE,
3560: p_count => p_msg_count,
3561: p_data => p_msg_data
3562: );
3563: IF PG_DEBUG in ('Y', 'C') THEN

Line 3589: p_encoded =>FND_API.G_FALSE,

3585: | Get message count and if 1, return message data |
3586: +---------------------------------------------------*/
3587:
3588: FND_MSG_PUB.Count_And_Get(
3589: p_encoded =>FND_API.G_FALSE,
3590: p_count => p_msg_count,
3591: p_data => p_msg_data
3592: );
3593:

Line 3598: IF FND_API.To_Boolean( p_commit_flag )

3594: /*--------------------------------+
3595: | Standard check of p_commit |
3596: +--------------------------------*/
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;

Line 3621: WHEN FND_API.G_EXC_ERROR THEN

3617: END IF;
3618:
3619:
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);

Line 3629: p_return_status := FND_API.G_RET_STS_ERROR ;

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 ;
3630: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
3631: p_count => p_msg_count,
3632: p_data => p_msg_data
3633: );

Line 3630: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

3626: END IF;
3627:
3628: ROLLBACK TO ar_adjust_PUB;
3629: p_return_status := FND_API.G_RET_STS_ERROR ;
3630: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
3631: p_count => p_msg_count,
3632: p_data => p_msg_data
3633: );
3634:

Line 3635: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3631: p_count => p_msg_count,
3632: p_data => p_msg_data
3633: );
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;

Line 3641: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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,
3643: p_count => p_msg_count,
3644: p_data => p_msg_data
3645: );

Line 3642: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

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,
3643: p_count => p_msg_count,
3644: p_data => p_msg_data
3645: );
3646:

Line 3657: p_return_status := FND_API.G_RET_STS_ERROR ;

3653: +-------------------------------------------------------*/
3654:
3655: IF (SQLCODE = -20001)
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. ' ||

Line 3665: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

3661: 'Completion validation error(s) occurred. ' ||
3662: 'Rolling back and setting status to ERROR');
3663: END IF;
3664:
3665: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
3666: p_count => p_msg_count,
3667: p_data => p_msg_data
3668: );
3669: RETURN;

Line 3689: | fnd_api.compatible_api_call |

3685: | |
3686: | SCOPE - PUBLIC |
3687: | |
3688: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
3689: | fnd_api.compatible_api_call |
3690: | fnd_api.g_exc_unexpected_error |
3691: | fnd_api.g_ret_sts_error |
3692: | fnd_api.g_ret_sts_error |
3693: | fnd_api.g_ret_sts_success |

Line 3690: | fnd_api.g_exc_unexpected_error |

3686: | SCOPE - PUBLIC |
3687: | |
3688: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
3689: | fnd_api.compatible_api_call |
3690: | fnd_api.g_exc_unexpected_error |
3691: | fnd_api.g_ret_sts_error |
3692: | fnd_api.g_ret_sts_error |
3693: | fnd_api.g_ret_sts_success |
3694: | fnd_api.to_boolean |

Line 3691: | fnd_api.g_ret_sts_error |

3687: | |
3688: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
3689: | fnd_api.compatible_api_call |
3690: | fnd_api.g_exc_unexpected_error |
3691: | fnd_api.g_ret_sts_error |
3692: | fnd_api.g_ret_sts_error |
3693: | fnd_api.g_ret_sts_success |
3694: | fnd_api.to_boolean |
3695: | fnd_msg_pub.check_msg_level |

Line 3692: | fnd_api.g_ret_sts_error |

3688: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
3689: | fnd_api.compatible_api_call |
3690: | fnd_api.g_exc_unexpected_error |
3691: | fnd_api.g_ret_sts_error |
3692: | fnd_api.g_ret_sts_error |
3693: | fnd_api.g_ret_sts_success |
3694: | fnd_api.to_boolean |
3695: | fnd_msg_pub.check_msg_level |
3696: | fnd_msg_pub.count_and_get |

Line 3693: | fnd_api.g_ret_sts_success |

3689: | fnd_api.compatible_api_call |
3690: | fnd_api.g_exc_unexpected_error |
3691: | fnd_api.g_ret_sts_error |
3692: | fnd_api.g_ret_sts_error |
3693: | fnd_api.g_ret_sts_success |
3694: | fnd_api.to_boolean |
3695: | fnd_msg_pub.check_msg_level |
3696: | fnd_msg_pub.count_and_get |
3697: | fnd_msg_pub.initialize |

Line 3694: | fnd_api.to_boolean |

3690: | fnd_api.g_exc_unexpected_error |
3691: | fnd_api.g_ret_sts_error |
3692: | fnd_api.g_ret_sts_error |
3693: | fnd_api.g_ret_sts_success |
3694: | fnd_api.to_boolean |
3695: | fnd_msg_pub.check_msg_level |
3696: | fnd_msg_pub.count_and_get |
3697: | fnd_msg_pub.initialize |
3698: | ar_adjustments_pkg.fetch_p |

Line 3742: p_init_msg_list IN varchar2 := FND_API.G_FALSE,

3738:
3739: PROCEDURE Approve_Adjustment (
3740: p_api_name IN varchar2,
3741: p_api_version IN number,
3742: p_init_msg_list IN varchar2 := FND_API.G_FALSE,
3743: p_commit_flag IN varchar2 := FND_API.G_FALSE,
3744: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,
3745: p_msg_count OUT NOCOPY number,
3746: p_msg_data OUT NOCOPY varchar2,

Line 3743: p_commit_flag IN varchar2 := FND_API.G_FALSE,

3739: PROCEDURE Approve_Adjustment (
3740: p_api_name IN varchar2,
3741: p_api_version IN number,
3742: p_init_msg_list IN varchar2 := FND_API.G_FALSE,
3743: p_commit_flag IN varchar2 := FND_API.G_FALSE,
3744: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,
3745: p_msg_count OUT NOCOPY number,
3746: p_msg_data OUT NOCOPY varchar2,
3747: p_return_status OUT NOCOPY varchar2 ,

Line 3744: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,

3740: p_api_name IN varchar2,
3741: p_api_version IN number,
3742: p_init_msg_list IN varchar2 := FND_API.G_FALSE,
3743: p_commit_flag IN varchar2 := FND_API.G_FALSE,
3744: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,
3745: p_msg_count OUT NOCOPY number,
3746: p_msg_data OUT NOCOPY varchar2,
3747: p_return_status OUT NOCOPY varchar2 ,
3748: p_adj_rec IN ar_adjustments%rowtype,

Line 3749: p_chk_approval_limits IN varchar2 := FND_API.G_TRUE,

3745: p_msg_count OUT NOCOPY number,
3746: p_msg_data OUT NOCOPY varchar2,
3747: p_return_status OUT NOCOPY varchar2 ,
3748: p_adj_rec IN ar_adjustments%rowtype,
3749: p_chk_approval_limits IN varchar2 := FND_API.G_TRUE,
3750: p_move_deferred_tax IN varchar2,
3751: p_old_adjust_id IN ar_adjustments.adjustment_id%type,
3752: p_org_id IN NUMBER DEFAULT NULL
3753: ) IS

Line 3763: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;

3759: l_inp_adj_rec ar_adjustments%rowtype;
3760: l_hsec VARCHAR2(10);
3761: l_status number;
3762:
3763: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
3764: l_chk_approval_limits varchar2(1);
3765: l_org_return_status VARCHAR2(1);
3766: l_org_id NUMBER;
3767:

Line 3786: IF NOT FND_API.Compatible_API_Call(

3782: /*--------------------------------------------------+
3783: | Standard call to check for call compatibility |
3784: +--------------------------------------------------*/
3785:
3786: IF NOT FND_API.Compatible_API_Call(
3787: l_api_version,
3788: p_api_version,
3789: l_api_name,
3790: G_PKG_NAME

Line 3796: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:
3799: /*-------------------------------------------------------------+
3800: | Initialize message list if p_init_msg_list is set to TRUE |

Line 3803: IF FND_API.to_Boolean( p_init_msg_list )

3799: /*-------------------------------------------------------------+
3800: | Initialize message list if p_init_msg_list is set to TRUE |
3801: +-------------------------------------------------------------*/
3802:
3803: IF FND_API.to_Boolean( p_init_msg_list )
3804: THEN
3805: FND_MSG_PUB.initialize;
3806: END IF;
3807:

Line 3819: p_return_status := FND_API.G_RET_STS_SUCCESS;

3815: /*-----------------------------------------+
3816: | Initialize return status to SUCCESS |
3817: +-----------------------------------------*/
3818:
3819: p_return_status := FND_API.G_RET_STS_SUCCESS;
3820:
3821:
3822:
3823:

Line 3827: l_org_return_status := FND_API.G_RET_STS_SUCCESS;

3823:
3824:
3825: /* SSA change */
3826: l_org_id := p_org_id;
3827: l_org_return_status := FND_API.G_RET_STS_SUCCESS;
3828: ar_mo_cache_utils.set_org_context_in_api(p_org_id =>l_org_id,
3829: p_return_status =>l_org_return_status);
3830: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3831: p_return_status := FND_API.G_RET_STS_ERROR;

Line 3830: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3826: l_org_id := p_org_id;
3827: l_org_return_status := FND_API.G_RET_STS_SUCCESS;
3828: ar_mo_cache_utils.set_org_context_in_api(p_org_id =>l_org_id,
3829: p_return_status =>l_org_return_status);
3830: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3831: p_return_status := FND_API.G_RET_STS_ERROR;
3832: ELSE
3833:
3834:

Line 3831: p_return_status := FND_API.G_RET_STS_ERROR;

3827: l_org_return_status := FND_API.G_RET_STS_SUCCESS;
3828: ar_mo_cache_utils.set_org_context_in_api(p_org_id =>l_org_id,
3829: p_return_status =>l_org_return_status);
3830: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3831: p_return_status := FND_API.G_RET_STS_ERROR;
3832: ELSE
3833:
3834:
3835: /*---------------------------------------------+

Line 3859: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )

3855: /*------------------------------------------------+
3856: | Check status and return if error |
3857: +------------------------------------------------*/
3858:
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 ');

Line 3878: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )

3874: /*------------------------------------------------+
3875: | Check status and return if error |
3876: +------------------------------------------------*/
3877:
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 ');

Line 3904: p_return_status := FND_API.G_RET_STS_ERROR ;

3900: +---------------------------------------------------*/
3901:
3902: ROLLBACK TO ar_adjust_PUB;
3903:
3904: p_return_status := FND_API.G_RET_STS_ERROR ;
3905:
3906: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_INVALID_ADJ_ID');
3907: FND_MESSAGE.SET_TOKEN ( 'ADJUSTMENT_ID', to_char(p_old_adjust_id) ) ;
3908: FND_MSG_PUB.ADD ;

Line 3924: l_chk_approval_limits := FND_API.G_TRUE;

3920: +--------------------------------------------------*/
3921:
3922: l_chk_approval_limits := p_chk_approval_limits;
3923: IF (l_chk_approval_limits IS NULL) THEN
3924: l_chk_approval_limits := FND_API.G_TRUE;
3925: END IF;
3926:
3927: ar_adjust_pub.Validate_Adj_Approve (
3928: l_inp_adj_rec,

Line 3935: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )

3931: l_return_status
3932: );
3933:
3934:
3935: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
3936: THEN
3937:
3938: p_return_status := l_return_status ;
3939: IF PG_DEBUG in ('Y', 'C') THEN

Line 3949: IF (p_return_status = FND_API.G_RET_STS_ERROR)

3945:
3946: /*-----------------------------------------------+
3947: | Handling all the validation exceptions |
3948: +-----------------------------------------------*/
3949: IF (p_return_status = FND_API.G_RET_STS_ERROR)
3950: THEN
3951: RAISE FND_API.G_EXC_ERROR;
3952: ELSIF (p_return_status = FND_API.G_RET_STS_UNEXP_ERROR)
3953: THEN

Line 3951: RAISE FND_API.G_EXC_ERROR;

3947: | Handling all the validation exceptions |
3948: +-----------------------------------------------*/
3949: IF (p_return_status = FND_API.G_RET_STS_ERROR)
3950: THEN
3951: RAISE FND_API.G_EXC_ERROR;
3952: ELSIF (p_return_status = FND_API.G_RET_STS_UNEXP_ERROR)
3953: THEN
3954: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3955: END IF;

Line 3952: ELSIF (p_return_status = FND_API.G_RET_STS_UNEXP_ERROR)

3948: +-----------------------------------------------*/
3949: IF (p_return_status = FND_API.G_RET_STS_ERROR)
3950: THEN
3951: RAISE FND_API.G_EXC_ERROR;
3952: ELSIF (p_return_status = FND_API.G_RET_STS_UNEXP_ERROR)
3953: THEN
3954: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3955: END IF;
3956:

Line 3954: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3950: THEN
3951: RAISE FND_API.G_EXC_ERROR;
3952: ELSIF (p_return_status = FND_API.G_RET_STS_UNEXP_ERROR)
3953: THEN
3954: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3955: END IF;
3956:
3957: /*-----------------------------------------------+
3958: | Call the entity Handler for Approve |

Line 3986: p_return_status := FND_API.G_RET_STS_ERROR ;

3982: +---------------------------------------------------*/
3983:
3984: ROLLBACK TO ar_adjust_PUB;
3985:
3986: p_return_status := FND_API.G_RET_STS_ERROR ;
3987:
3988: FND_MESSAGE.set_name( 'AR', 'GENERIC_MESSAGE' );
3989: FND_MESSAGE.set_token( 'GENERIC_TEXT', 'arp_process_adjustment.update_approve_adj exception: '||SQLERRM );
3990: --2920926

Line 3997: p_encoded => FND_API.G_FALSE,

3993: | Get message count and if 1, return message data |
3994: +---------------------------------------------------*/
3995:
3996: FND_MSG_PUB.Count_And_Get(
3997: p_encoded => FND_API.G_FALSE,
3998: p_count => p_msg_count,
3999: p_data => p_msg_data
4000: );
4001:

Line 4023: p_encoded => FND_API.G_FALSE,

4019: | Get message count and if 1, return message data |
4020: +---------------------------------------------------*/
4021:
4022: FND_MSG_PUB.Count_And_Get(
4023: p_encoded => FND_API.G_FALSE,
4024: p_count => p_msg_count,
4025: p_data => p_msg_data
4026: );
4027:

Line 4032: IF FND_API.To_Boolean( p_commit_flag )

4028: /*--------------------------------+
4029: | Standard check of p_commit |
4030: +--------------------------------*/
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;

Line 4055: WHEN FND_API.G_EXC_ERROR THEN

4051: END IF;
4052:
4053:
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);

Line 4063: p_return_status := FND_API.G_RET_STS_ERROR ;

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 ;
4064: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
4065: p_count => p_msg_count,
4066: p_data => p_msg_data
4067: );

Line 4064: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

4060: END IF;
4061:
4062: ROLLBACK TO ar_adjust_PUB;
4063: p_return_status := FND_API.G_RET_STS_ERROR ;
4064: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
4065: p_count => p_msg_count,
4066: p_data => p_msg_data
4067: );
4068:

Line 4069: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4065: p_count => p_msg_count,
4066: p_data => p_msg_data
4067: );
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;

Line 4075: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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,
4077: p_count => p_msg_count,
4078: p_data => p_msg_data
4079: );

Line 4076: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

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,
4077: p_count => p_msg_count,
4078: p_data => p_msg_data
4079: );
4080:

Line 4091: p_return_status := FND_API.G_RET_STS_ERROR ;

4087: +-------------------------------------------------------*/
4088:
4089: IF (SQLCODE = -20001)
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. ' ||

Line 4099: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

4095: 'Completion validation error(s) occurred. ' ||
4096: 'Rolling back and setting status to ERROR');
4097: END IF;
4098:
4099: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
4100: p_count => p_msg_count,
4101: p_data => p_msg_data
4102: );
4103: RETURN;