29: | fnd_api.to_boolean |
30: | fnd_msg_pub.check_msg_level |
31: | fnd_msg_pub.count_and_get |
32: | fnd_msg_pub.initialize |
33: | ar_adjvalidate_pub.Validate_Type |
34: | ar_adjvalidate_pub.Validate_Payschd |
35: | ar_adjvalidate_pub.Validate_amount |
36: | ar_adjvalidate_pub.Validate_Rcvtrxccid |
37: | ar_adjvalidate_pub.Validate_dates |
30: | fnd_msg_pub.check_msg_level |
31: | fnd_msg_pub.count_and_get |
32: | fnd_msg_pub.initialize |
33: | ar_adjvalidate_pub.Validate_Type |
34: | ar_adjvalidate_pub.Validate_Payschd |
35: | ar_adjvalidate_pub.Validate_amount |
36: | ar_adjvalidate_pub.Validate_Rcvtrxccid |
37: | ar_adjvalidate_pub.Validate_dates |
38: | ar_adjvalidate_pub.Validate_Reason_code |
31: | fnd_msg_pub.count_and_get |
32: | fnd_msg_pub.initialize |
33: | ar_adjvalidate_pub.Validate_Type |
34: | ar_adjvalidate_pub.Validate_Payschd |
35: | ar_adjvalidate_pub.Validate_amount |
36: | ar_adjvalidate_pub.Validate_Rcvtrxccid |
37: | ar_adjvalidate_pub.Validate_dates |
38: | ar_adjvalidate_pub.Validate_Reason_code |
39: | ar_adjvalidate_pub.Validate_doc_seq |
32: | fnd_msg_pub.initialize |
33: | ar_adjvalidate_pub.Validate_Type |
34: | ar_adjvalidate_pub.Validate_Payschd |
35: | ar_adjvalidate_pub.Validate_amount |
36: | ar_adjvalidate_pub.Validate_Rcvtrxccid |
37: | ar_adjvalidate_pub.Validate_dates |
38: | ar_adjvalidate_pub.Validate_Reason_code |
39: | ar_adjvalidate_pub.Validate_doc_seq |
40: | ar_adjvalidate_pub.Validate_Associated_Receipt |
33: | ar_adjvalidate_pub.Validate_Type |
34: | ar_adjvalidate_pub.Validate_Payschd |
35: | ar_adjvalidate_pub.Validate_amount |
36: | ar_adjvalidate_pub.Validate_Rcvtrxccid |
37: | ar_adjvalidate_pub.Validate_dates |
38: | ar_adjvalidate_pub.Validate_Reason_code |
39: | ar_adjvalidate_pub.Validate_doc_seq |
40: | ar_adjvalidate_pub.Validate_Associated_Receipt |
41: | ar_adjvalidate_pub.Validate_Ussgl_code |
34: | ar_adjvalidate_pub.Validate_Payschd |
35: | ar_adjvalidate_pub.Validate_amount |
36: | ar_adjvalidate_pub.Validate_Rcvtrxccid |
37: | ar_adjvalidate_pub.Validate_dates |
38: | ar_adjvalidate_pub.Validate_Reason_code |
39: | ar_adjvalidate_pub.Validate_doc_seq |
40: | ar_adjvalidate_pub.Validate_Associated_Receipt |
41: | ar_adjvalidate_pub.Validate_Ussgl_code |
42: | ar_adjvalidate_pub.Validate_Desc_Flexfield |
35: | ar_adjvalidate_pub.Validate_amount |
36: | ar_adjvalidate_pub.Validate_Rcvtrxccid |
37: | ar_adjvalidate_pub.Validate_dates |
38: | ar_adjvalidate_pub.Validate_Reason_code |
39: | ar_adjvalidate_pub.Validate_doc_seq |
40: | ar_adjvalidate_pub.Validate_Associated_Receipt |
41: | ar_adjvalidate_pub.Validate_Ussgl_code |
42: | ar_adjvalidate_pub.Validate_Desc_Flexfield |
43: | ar_adjvalidate_pub.Validate_Created_From |
36: | ar_adjvalidate_pub.Validate_Rcvtrxccid |
37: | ar_adjvalidate_pub.Validate_dates |
38: | ar_adjvalidate_pub.Validate_Reason_code |
39: | ar_adjvalidate_pub.Validate_doc_seq |
40: | ar_adjvalidate_pub.Validate_Associated_Receipt |
41: | ar_adjvalidate_pub.Validate_Ussgl_code |
42: | ar_adjvalidate_pub.Validate_Desc_Flexfield |
43: | ar_adjvalidate_pub.Validate_Created_From |
44: | |
37: | ar_adjvalidate_pub.Validate_dates |
38: | ar_adjvalidate_pub.Validate_Reason_code |
39: | ar_adjvalidate_pub.Validate_doc_seq |
40: | ar_adjvalidate_pub.Validate_Associated_Receipt |
41: | ar_adjvalidate_pub.Validate_Ussgl_code |
42: | ar_adjvalidate_pub.Validate_Desc_Flexfield |
43: | ar_adjvalidate_pub.Validate_Created_From |
44: | |
45: | ARGUMENTS : IN: |
38: | ar_adjvalidate_pub.Validate_Reason_code |
39: | ar_adjvalidate_pub.Validate_doc_seq |
40: | ar_adjvalidate_pub.Validate_Associated_Receipt |
41: | ar_adjvalidate_pub.Validate_Ussgl_code |
42: | ar_adjvalidate_pub.Validate_Desc_Flexfield |
43: | ar_adjvalidate_pub.Validate_Created_From |
44: | |
45: | ARGUMENTS : IN: |
46: | OUT: |
39: | ar_adjvalidate_pub.Validate_doc_seq |
40: | ar_adjvalidate_pub.Validate_Associated_Receipt |
41: | ar_adjvalidate_pub.Validate_Ussgl_code |
42: | ar_adjvalidate_pub.Validate_Desc_Flexfield |
43: | ar_adjvalidate_pub.Validate_Created_From |
44: | |
45: | ARGUMENTS : IN: |
46: | OUT: |
47: | IN/ OUT: |
74:
75: /*-------------------------------------------------+
76: | 1. Validate type |
77: +-------------------------------------------------*/
78: ar_adjvalidate_pub.Validate_Type (
79: p_adj_rec,
80: p_validation_status
81: ) ;
82: IF ( p_validation_status <> FND_API.G_RET_STS_SUCCESS )
87: /*-------------------------------------------------+
88: | 2. Validate payment_schedule_id and |
89: | customer_trx_line_id |
90: +-------------------------------------------------*/
91: ar_adjvalidate_pub.Validate_Payschd (
92: p_adj_rec,
93: l_ps_rec,
94: p_validation_status
95: );
101: /*-------------------------------------------------+
102: | 3. Validate adjustment apply_date and GL date |
103: +-------------------------------------------------*/
104:
105: ar_adjvalidate_pub.Validate_dates (
106: p_adj_rec.apply_date,
107: p_adj_rec.gl_date,
108: l_ps_rec,
109: p_validation_status
119: /*-------------------------------------------------+
120: | 4. Validate amount and status |
121: +-------------------------------------------------*/
122:
123: ar_adjvalidate_pub.Validate_amount (
124: p_adj_rec,
125: l_ps_rec,
126: p_validation_status
127: );
134: | 5. Validate receivables_trx_id and code |
135: | combination |
136: +-------------------------------------------------*/
137:
138: ar_adjvalidate_pub.Validate_Rcvtrxccid (
139: p_adj_rec ,
140: p_validation_status
141: );
142: IF ( p_validation_status <> FND_API.G_RET_STS_SUCCESS )
146:
147: /*-------------------------------------------------+
148: | 6. Validate doc_sequence_value |
149: +-------------------------------------------------*/
150: ar_adjvalidate_pub.Validate_doc_seq (
151: p_adj_rec,
152: p_validation_status
153: ) ;
154: IF ( p_validation_status <> FND_API.G_RET_STS_SUCCESS )
158:
159: /*-------------------------------------------------+
160: | 7. Validate reason_code |
161: +-------------------------------------------------*/
162: ar_adjvalidate_pub.Validate_Reason_code (
163: p_adj_rec,
164: p_validation_status
165: );
166: IF ( p_validation_status <> FND_API.G_RET_STS_SUCCESS )
170:
171: /*-------------------------------------------------+
172: | 8. Validate associated cash_receipt_id |
173: +-------------------------------------------------*/
174: ar_adjvalidate_pub.Validate_Associated_Receipt (
175: p_adj_rec,
176: p_validation_status
177: );
178: IF ( p_validation_status <> FND_API.G_RET_STS_SUCCESS )
182:
183: /*-------------------------------------------------+
184: | 9. Validate ussgl transaction code |
185: +-------------------------------------------------*/
186: ar_adjvalidate_pub.Validate_Ussgl_code (
187: p_adj_rec,
188: p_validation_status
189: );
190: IF ( p_validation_status <> FND_API.G_RET_STS_SUCCESS )
194:
195: /*-------------------------------------------------+
196: | 10. Validate descriptive flex |
197: +-------------------------------------------------*/
198: ar_adjvalidate_pub.Validate_Desc_Flexfield(
199: p_adj_rec,
200: p_validation_status
201: );
202: IF ( p_validation_status <> FND_API.G_RET_STS_SUCCESS )
206:
207: /*-------------------------------------------------+
208: | 11. Validate created form |
209: +-------------------------------------------------*/
210: ar_adjvalidate_pub.Validate_Created_From (
211: p_adj_rec,
212: p_validation_status
213: );
214:
365: +----------------------------------------------*/
366:
367: IF ( p_old_adj_rec.status = 'A' )
368: THEN
369: ar_adjvalidate_pub.aapi_message (
370: p_application_name => 'AR',
371: p_message_name => 'AR_AAPI_NO_CHANGE_OR_REVERSE',
372: p_token1_name => 'STATUS',
373: p_token1_value => p_old_adj_rec.status
383:
384: IF ( (p_adj_rec.status IS NOT NULL) AND
385: (p_adj_rec.status NOT IN ('A', 'R', 'W', 'M')) )
386: THEN
387: ar_adjvalidate_pub.aapi_message (
388: p_application_name => 'AR',
389: p_message_name => 'AR_AAPI_INVALID_CHANGE_STATUS',
390: p_token1_name => 'STATUS',
391: p_token1_value => p_adj_rec.status
416: /*-----------------------------------------------+
417: | Payment schedule Id does not exist |
418: | Set the message and status accordingly |
419: +-----------------------------------------------*/
420: ar_adjvalidate_pub.aapi_message(
421: p_application_name =>'AR',
422: p_message_name => 'AR_AAPI_INVALID_PAYMENT_SCHEDULE',
423: p_token1_name => 'PAYMENT_SCHEDULE_ID',
424: p_token1_value => to_char(p_old_adj_rec.payment_schedule_id)
433: /*-----------------------------------+
434: | Get the approval limits and check |
435: +-----------------------------------*/
436:
437: ar_adjvalidate_pub.Within_approval_limits(
438: p_old_adj_rec.amount,
439: l_ps_rec.invoice_currency_code,
440: l_approved_flag,
441: p_validation_status
447: END IF;
448:
449: IF ( l_approved_flag <> FND_API.G_TRUE )
450: THEN
451: ar_adjvalidate_pub.aapi_message
452: ( p_application_name => 'AR',
453: p_message_name => 'AR_VAL_AMT_APPROVAL_LIMIT'
454: );
455: p_validation_status := FND_API.G_RET_STS_ERROR;
469: +-------------------------------------------------*/
470:
471: IF ( p_adj_rec.gl_date IS NOT NULL )
472: THEN
473: ar_adjvalidate_pub.Validate_dates (
474: p_old_adj_rec.apply_date,
475: p_adj_rec.gl_date,
476: l_ps_rec,
477: p_validation_status
580: +----------------------------------------------*/
581:
582: IF ( p_old_adj_rec.status <> 'A' )
583: THEN
584: ar_adjvalidate_pub.aapi_message (
585: p_application_name => 'AR',
586: p_message_name => 'AR_AAPI_NO_CHANGE_OR_REVERSE',
587: p_token1_name => 'STATUS',
588: p_token1_value => p_old_adj_rec.status
625: /*-----------------------------------------------+
626: | Payment schedule Id does not exist |
627: | Set the message and status accordingly |
628: +-----------------------------------------------*/
629: ar_adjvalidate_pub.aapi_message(
630: p_application_name =>'AR',
631: p_message_name => 'AR_AAPI_INVALID_PAYMENT_SCHEDULE',
632: p_token1_name => 'PAYMENT_SCHEDULE_ID',
633: p_token1_value => to_char(p_old_adj_rec.payment_schedule_id)
635: p_validation_status := FND_API.G_RET_STS_ERROR;
636: RETURN ;
637: END ;
638:
639: ar_adjvalidate_pub.Validate_dates (
640: p_reversal_date,
641: p_reversal_gl_date,
642: l_ps_rec,
643: p_validation_status
722: +----------------------------------------------*/
723:
724: IF ( p_old_adj_rec.status = 'A' )
725: THEN
726: ar_adjvalidate_pub.aapi_message (
727: p_application_name => 'AR',
728: p_message_name => 'AR_AAPI_NO_CHANGE_OR_REVERSE',
729: p_token1_name => 'STATUS',
730: p_token1_value => p_old_adj_rec.status
748:
749: IF ( (p_adj_rec.status IS NOT NULL) AND
750: (p_adj_rec.status NOT IN ('A', 'R', 'W', 'M')) )
751: THEN
752: ar_adjvalidate_pub.aapi_message (
753: p_application_name => 'AR',
754: p_message_name => 'AR_AAPI_INVALID_CHANGE_STATUS',
755: p_token1_name => 'STATUS',
756: p_token1_value => p_adj_rec.status
783: /*-----------------------------------------------+
784: | Payment schedule Id does not exist |
785: | Set the message and status accordingly |
786: +-----------------------------------------------*/
787: ar_adjvalidate_pub.aapi_message(
788: p_application_name =>'AR',
789: p_message_name => 'AR_AAPI_INVALID_PAYMENT_SCHEDULE',
790: p_token1_name => 'PAYMENT_SCHEDULE_ID',
791: p_token1_value => to_char(p_old_adj_rec.payment_schedule_id)
800: /*-----------------------------------+
801: | Get the approval limits and check |
802: +-----------------------------------*/
803:
804: ar_adjvalidate_pub.Within_approval_limits(
805: p_old_adj_rec.amount,
806: l_ps_rec.invoice_currency_code,
807: l_approved_flag,
808: p_validation_status
814: END IF;
815:
816: IF ( l_approved_flag <> FND_API.G_TRUE )
817: THEN
818: ar_adjvalidate_pub.aapi_message
819: ( p_application_name => 'AR',
820: p_message_name => 'AR_VAL_AMT_APPROVAL_LIMIT'
821: );
822: p_validation_status := FND_API.G_RET_STS_ERROR;
836: +-------------------------------------------------*/
837:
838: IF ( p_adj_rec.gl_date IS NOT NULL )
839: THEN
840: ar_adjvalidate_pub.Validate_dates (
841: p_old_adj_rec.apply_date,
842: p_adj_rec.gl_date,
843: l_ps_rec,
844: p_validation_status
915: | fnd_api.to_boolean |
916: | fnd_msg_pub.check_msg_level |
917: | fnd_msg_pub.count_and_get |
918: | fnd_msg_pub.initialize |
919: | ar_adjvalidate_pub.Init_Context_Rec |
920: | ar_adjvalidate_pub.Cache_Details |
921: | |
922: | ARGUMENTS : IN: |
923: | p_api_name |
916: | fnd_msg_pub.check_msg_level |
917: | fnd_msg_pub.count_and_get |
918: | fnd_msg_pub.initialize |
919: | ar_adjvalidate_pub.Init_Context_Rec |
920: | ar_adjvalidate_pub.Cache_Details |
921: | |
922: | ARGUMENTS : IN: |
923: | p_api_name |
924: | p_api_version |
1057: /*------------------------------------------------+
1058: | Initialize the profile options and cache data |
1059: +------------------------------------------------*/
1060:
1061: ar_adjvalidate_pub.Init_Context_Rec (
1062: p_validation_level,
1063: l_return_status
1064: );
1065: /*------------------------------------------------+
1080: /*------------------------------------------------+
1081: | Cache details |
1082: +------------------------------------------------*/
1083:
1084: ar_adjvalidate_pub.Cache_Details (
1085: l_return_status
1086: );
1087: /*------------------------------------------------+
1088: | Check status and return if error |
1348: | fnd_msg_pub.count_and_get |
1349: | fnd_msg_pub.initialize |
1350: | ar_adjustments_pkg.fetch_p |
1351: | ar_process_adjustment.update_adjustment |
1352: | ar_adjvalidate_pub.within_approval_limit |
1353: | |
1354: | ARGUMENTS : IN: |
1355: | p_api_name |
1356: | p_api_version |
1484: /*------------------------------------------------+
1485: | Initialize the profile options and cache data |
1486: +------------------------------------------------*/
1487:
1488: ar_adjvalidate_pub.Init_Context_Rec (
1489: p_validation_level,
1490: l_return_status
1491: );
1492: /*------------------------------------------------+
1507: /*------------------------------------------------+
1508: | Cache details |
1509: +------------------------------------------------*/
1510:
1511: ar_adjvalidate_pub.Cache_Details (
1512: l_return_status
1513: );
1514: /*------------------------------------------------+
1515: | Check status and return if error |
1545: ROLLBACK TO AR_ADJUSTAPI_PUB;
1546:
1547: p_return_status := FND_API.G_RET_STS_ERROR ;
1548:
1549: ar_adjvalidate_pub.aapi_message (
1550: p_application_name => 'AR',
1551: p_message_name => 'AR_AAPI_INVALID_ADJ_ID',
1552: p_token1_name => 'ADJUSTMENT_ID',
1553: p_token1_value => to_char(p_old_adjust_id)
1893: /*------------------------------------------------+
1894: | Initialize the profile options and cache data |
1895: +------------------------------------------------*/
1896:
1897: ar_adjvalidate_pub.Init_Context_Rec (
1898: p_validation_level,
1899: l_return_status
1900: );
1901: /*------------------------------------------------+
1931: ROLLBACK TO AR_ADJUSTAPI_PUB;
1932:
1933: p_return_status := FND_API.G_RET_STS_ERROR ;
1934:
1935: ar_adjvalidate_pub.aapi_message (
1936: p_application_name => 'AR',
1937: p_message_name => 'AR_AAPI_INVALID_ADJ_ID',
1938: p_token1_name => 'ADJUSTMENT_ID',
1939: p_token1_value => to_char(p_old_adjust_id)
1945: /*------------------------------------------------+
1946: | Cache details |
1947: +------------------------------------------------*/
1948:
1949: ar_adjvalidate_pub.Cache_Details (
1950: l_return_status
1951: );
1952: /*------------------------------------------------+
1953: | Check status and return if error |
2319: /*------------------------------------------------+
2320: | Initialize the profile options and cache data |
2321: +------------------------------------------------*/
2322:
2323: ar_adjvalidate_pub.Init_Context_Rec (
2324: p_validation_level,
2325: l_return_status
2326: );
2327: /*------------------------------------------------+
2342: /*------------------------------------------------+
2343: | Cache details |
2344: +------------------------------------------------*/
2345:
2346: ar_adjvalidate_pub.Cache_Details (
2347: l_return_status
2348: );
2349: /*------------------------------------------------+
2350: | Check status and return if error |
2380: ROLLBACK TO AR_ADJUSTAPI_PUB;
2381:
2382: p_return_status := FND_API.G_RET_STS_ERROR ;
2383:
2384: ar_adjvalidate_pub.aapi_message (
2385: p_application_name => 'AR',
2386: p_message_name => 'AR_AAPI_INVALID_ADJ_ID',
2387: p_token1_name => 'ADJUSTMENT_ID',
2388: p_token1_value => to_char(p_old_adjust_id)