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_ADJUSTAPI_PUB dependencies on FND_API

Line 24: | fnd_api.compatible_api_call |

20: | |
21: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
22: | arp_util.disable_debug |
23: | arp_util.enable_debug |
24: | fnd_api.compatible_api_call |
25: | fnd_api.g_exc_unexpected_error |
26: | fnd_api.g_ret_sts_error |
27: | fnd_api.g_ret_sts_error |
28: | fnd_api.g_ret_sts_success |

Line 25: | fnd_api.g_exc_unexpected_error |

21: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
22: | arp_util.disable_debug |
23: | arp_util.enable_debug |
24: | fnd_api.compatible_api_call |
25: | fnd_api.g_exc_unexpected_error |
26: | fnd_api.g_ret_sts_error |
27: | fnd_api.g_ret_sts_error |
28: | fnd_api.g_ret_sts_success |
29: | fnd_api.to_boolean |

Line 26: | fnd_api.g_ret_sts_error |

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

Line 27: | fnd_api.g_ret_sts_error |

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

Line 28: | fnd_api.g_ret_sts_success |

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

Line 29: | fnd_api.to_boolean |

25: | fnd_api.g_exc_unexpected_error |
26: | fnd_api.g_ret_sts_error |
27: | fnd_api.g_ret_sts_error |
28: | fnd_api.g_ret_sts_success |
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 |

Line 82: IF ( p_validation_status <> FND_API.G_RET_STS_SUCCESS )

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 )
83: THEN
84: RETURN ;
85: END IF;
86:

Line 96: IF ( p_validation_status <> FND_API.G_RET_STS_SUCCESS )

92: p_adj_rec,
93: l_ps_rec,
94: p_validation_status
95: );
96: IF ( p_validation_status <> FND_API.G_RET_STS_SUCCESS )
97: THEN
98: RETURN ;
99: END IF;
100:

Line 111: IF ( p_validation_status <> FND_API.G_RET_STS_SUCCESS )

107: p_adj_rec.gl_date,
108: l_ps_rec,
109: p_validation_status
110: );
111: IF ( p_validation_status <> FND_API.G_RET_STS_SUCCESS )
112: THEN
113: RETURN ;
114: ELSE
115: p_adj_rec.apply_date := trunc(p_adj_rec.apply_date);

Line 128: IF ( p_validation_status <> FND_API.G_RET_STS_SUCCESS )

124: p_adj_rec,
125: l_ps_rec,
126: p_validation_status
127: );
128: IF ( p_validation_status <> FND_API.G_RET_STS_SUCCESS )
129: THEN
130: RETURN ;
131: END IF;
132:

Line 142: IF ( p_validation_status <> FND_API.G_RET_STS_SUCCESS )

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 )
143: THEN
144: RETURN ;
145: END IF;
146:

Line 154: IF ( p_validation_status <> FND_API.G_RET_STS_SUCCESS )

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 )
155: THEN
156: RETURN ;
157: END IF;
158:

Line 166: IF ( p_validation_status <> FND_API.G_RET_STS_SUCCESS )

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 )
167: THEN
168: RETURN ;
169: END IF;
170:

Line 178: IF ( p_validation_status <> FND_API.G_RET_STS_SUCCESS )

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 )
179: THEN
180: RETURN ;
181: END IF;
182:

Line 190: IF ( p_validation_status <> FND_API.G_RET_STS_SUCCESS )

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 )
191: THEN
192: RETURN ;
193: END IF;
194:

Line 202: IF ( p_validation_status <> FND_API.G_RET_STS_SUCCESS )

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 )
203: THEN
204: RETURN ;
205: END IF;
206:

Line 227: p_validation_status := FND_API.G_RET_STS_UNEXP_ERROR ;

223: IF PG_DEBUG in ('Y', 'C') THEN
224: arp_util.debug('EXCEPTION: Validate_Adj_Insert() ', G_MSG_UERROR);
225: END IF;
226: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Validate_Adj_Insert');
227: p_validation_status := FND_API.G_RET_STS_UNEXP_ERROR ;
228: RETURN;
229:
230:
231: END Validate_Adj_Insert;

Line 279: p_return_status := FND_API.G_RET_STS_SUCCESS ;

275:
276: /*-----------------------------------------------+
277: | Set the status to success |
278: +-----------------------------------------------*/
279: p_return_status := FND_API.G_RET_STS_SUCCESS ;
280:
281: /*-----------------------------------------------+
282: | Set Adjustment Type and Postable attributes |
283: +-----------------------------------------------*/

Line 310: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

306: IF PG_DEBUG in ('Y', 'C') THEN
307: arp_util.debug('EXCEPTION: Set_Remaining_Attributes() ', G_MSG_UERROR);
308: END IF;
309: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Set_Remaining_Attributes');
310: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
311: RETURN;
312:
313: END Set_Remaining_Attributes;
314:

Line 376: p_validation_status := FND_API.G_RET_STS_ERROR;

372: p_token1_name => 'STATUS',
373: p_token1_value => p_old_adj_rec.status
374: );
375:
376: p_validation_status := FND_API.G_RET_STS_ERROR;
377: RETURN;
378: END IF;
379:
380: /*----------------------------------------------------+

Line 394: p_validation_status := FND_API.G_RET_STS_ERROR;

390: p_token1_name => 'STATUS',
391: p_token1_value => p_adj_rec.status
392: );
393:
394: p_validation_status := FND_API.G_RET_STS_ERROR;
395: RETURN;
396: END IF;
397:
398: /*---------------------------------------------------+

Line 426: p_validation_status := FND_API.G_RET_STS_ERROR;

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)
425: ) ;
426: p_validation_status := FND_API.G_RET_STS_ERROR;
427: RETURN ;
428: END ;
429:
430: IF ( p_adj_rec.status = 'A' )

Line 444: IF ( p_validation_status <> FND_API.G_RET_STS_SUCCESS )

440: l_approved_flag,
441: p_validation_status
442: ) ;
443:
444: IF ( p_validation_status <> FND_API.G_RET_STS_SUCCESS )
445: THEN
446: RETURN;
447: END IF;
448:

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

445: THEN
446: RETURN;
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'

Line 455: p_validation_status := FND_API.G_RET_STS_ERROR;

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;
456: RETURN ;
457: END IF;
458:
459: /*-------------------------------------------------+

Line 479: IF ( p_validation_status <> FND_API.G_RET_STS_SUCCESS )

475: p_adj_rec.gl_date,
476: l_ps_rec,
477: p_validation_status
478: ) ;
479: IF ( p_validation_status <> FND_API.G_RET_STS_SUCCESS )
480: THEN
481: RETURN;
482: END IF;
483: END IF;

Line 523: p_validation_status := FND_API.G_RET_STS_UNEXP_ERROR ;

519: IF PG_DEBUG in ('Y', 'C') THEN
520: arp_util.debug('EXCEPTION: Validate_Adj_Modify() ', G_MSG_UERROR);
521: END IF;
522: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Validate_Adj_Modify');
523: p_validation_status := FND_API.G_RET_STS_UNEXP_ERROR ;
524: RETURN;
525:
526:
527: END Validate_Adj_Modify;

Line 591: p_validation_status := FND_API.G_RET_STS_ERROR;

587: p_token1_name => 'STATUS',
588: p_token1_value => p_old_adj_rec.status
589: );
590:
591: p_validation_status := FND_API.G_RET_STS_ERROR;
592: RETURN;
593: END IF;
594:
595:

Line 635: p_validation_status := FND_API.G_RET_STS_ERROR;

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)
634: ) ;
635: p_validation_status := FND_API.G_RET_STS_ERROR;
636: RETURN ;
637: END ;
638:
639: ar_adjvalidate_pub.Validate_dates (

Line 645: IF ( p_validation_status <> FND_API.G_RET_STS_SUCCESS )

641: p_reversal_gl_date,
642: l_ps_rec,
643: p_validation_status
644: ) ;
645: IF ( p_validation_status <> FND_API.G_RET_STS_SUCCESS )
646: THEN
647: RETURN;
648: END IF;
649:

Line 664: p_validation_status := FND_API.G_RET_STS_UNEXP_ERROR ;

660: IF PG_DEBUG in ('Y', 'C') THEN
661: arp_util.debug('EXCEPTION: Validate_Adj_Reverse() ', G_MSG_UERROR);
662: END IF;
663: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Validate_Adj_Reverse');
664: p_validation_status := FND_API.G_RET_STS_UNEXP_ERROR ;
665: RETURN;
666:
667:
668: END Validate_Adj_Reverse;

Line 732: p_validation_status := FND_API.G_RET_STS_ERROR;

728: p_message_name => 'AR_AAPI_NO_CHANGE_OR_REVERSE',
729: p_token1_name => 'STATUS',
730: p_token1_value => p_old_adj_rec.status
731: );
732: p_validation_status := FND_API.G_RET_STS_ERROR;
733: RETURN;
734: END IF;
735:
736: /*----------------------------------------------------+

Line 759: p_validation_status := FND_API.G_RET_STS_ERROR;

755: p_token1_name => 'STATUS',
756: p_token1_value => p_adj_rec.status
757: );
758:
759: p_validation_status := FND_API.G_RET_STS_ERROR;
760: RETURN;
761: END IF;
762:
763:

Line 793: p_validation_status := FND_API.G_RET_STS_ERROR;

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)
792: ) ;
793: p_validation_status := FND_API.G_RET_STS_ERROR;
794: RETURN ;
795: END ;
796:
797: IF ( p_adj_rec.status = 'A' )

Line 811: IF ( p_validation_status <> FND_API.G_RET_STS_SUCCESS )

807: l_approved_flag,
808: p_validation_status
809: ) ;
810:
811: IF ( p_validation_status <> FND_API.G_RET_STS_SUCCESS )
812: THEN
813: RETURN;
814: END IF;
815:

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

812: THEN
813: RETURN;
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'

Line 822: p_validation_status := FND_API.G_RET_STS_ERROR;

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;
823: RETURN ;
824: END IF;
825:
826: /*-------------------------------------------------+

Line 846: IF ( p_validation_status <> FND_API.G_RET_STS_SUCCESS )

842: p_adj_rec.gl_date,
843: l_ps_rec,
844: p_validation_status
845: ) ;
846: IF ( p_validation_status <> FND_API.G_RET_STS_SUCCESS )
847: THEN
848: RETURN;
849: END IF;
850: END IF;

Line 892: p_validation_status := FND_API.G_RET_STS_UNEXP_ERROR ;

888: IF PG_DEBUG in ('Y', 'C') THEN
889: arp_util.debug('EXCEPTION: Validate_Adj_Approve() ', G_MSG_UERROR);
890: END IF;
891: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Validate_Adj_Approve');
892: p_validation_status := FND_API.G_RET_STS_UNEXP_ERROR ;
893: RETURN;
894:
895:
896: END Validate_Adj_Approve;

Line 910: | fnd_api.compatible_api_call |

906: | |
907: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
908: | arp_util.disable_debug |
909: | arp_util.enable_debug |
910: | fnd_api.compatible_api_call |
911: | fnd_api.g_exc_unexpected_error |
912: | fnd_api.g_ret_sts_error |
913: | fnd_api.g_ret_sts_error |
914: | fnd_api.g_ret_sts_success |

Line 911: | fnd_api.g_exc_unexpected_error |

907: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
908: | arp_util.disable_debug |
909: | arp_util.enable_debug |
910: | fnd_api.compatible_api_call |
911: | fnd_api.g_exc_unexpected_error |
912: | fnd_api.g_ret_sts_error |
913: | fnd_api.g_ret_sts_error |
914: | fnd_api.g_ret_sts_success |
915: | fnd_api.to_boolean |

Line 912: | fnd_api.g_ret_sts_error |

908: | arp_util.disable_debug |
909: | arp_util.enable_debug |
910: | fnd_api.compatible_api_call |
911: | fnd_api.g_exc_unexpected_error |
912: | fnd_api.g_ret_sts_error |
913: | fnd_api.g_ret_sts_error |
914: | fnd_api.g_ret_sts_success |
915: | fnd_api.to_boolean |
916: | fnd_msg_pub.check_msg_level |

Line 913: | fnd_api.g_ret_sts_error |

909: | arp_util.enable_debug |
910: | fnd_api.compatible_api_call |
911: | fnd_api.g_exc_unexpected_error |
912: | fnd_api.g_ret_sts_error |
913: | fnd_api.g_ret_sts_error |
914: | fnd_api.g_ret_sts_success |
915: | fnd_api.to_boolean |
916: | fnd_msg_pub.check_msg_level |
917: | fnd_msg_pub.count_and_get |

Line 914: | fnd_api.g_ret_sts_success |

910: | fnd_api.compatible_api_call |
911: | fnd_api.g_exc_unexpected_error |
912: | fnd_api.g_ret_sts_error |
913: | fnd_api.g_ret_sts_error |
914: | fnd_api.g_ret_sts_success |
915: | fnd_api.to_boolean |
916: | fnd_msg_pub.check_msg_level |
917: | fnd_msg_pub.count_and_get |
918: | fnd_msg_pub.initialize |

Line 915: | fnd_api.to_boolean |

911: | fnd_api.g_exc_unexpected_error |
912: | fnd_api.g_ret_sts_error |
913: | fnd_api.g_ret_sts_error |
914: | fnd_api.g_ret_sts_success |
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 |

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

948:
949: PROCEDURE Create_Adjustment (
950: p_api_name IN varchar2,
951: p_api_version IN number,
952: p_init_msg_list IN varchar2 := FND_API.G_FALSE,
953: p_commit_flag IN varchar2 := FND_API.G_FALSE,
954: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,
955: p_msg_count OUT NOCOPY number,
956: p_msg_data OUT NOCOPY varchar2,

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

949: PROCEDURE Create_Adjustment (
950: p_api_name IN varchar2,
951: p_api_version IN number,
952: p_init_msg_list IN varchar2 := FND_API.G_FALSE,
953: p_commit_flag IN varchar2 := FND_API.G_FALSE,
954: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,
955: p_msg_count OUT NOCOPY number,
956: p_msg_data OUT NOCOPY varchar2,
957: p_return_status OUT NOCOPY varchar2 ,

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

950: p_api_name IN varchar2,
951: p_api_version IN number,
952: p_init_msg_list IN varchar2 := FND_API.G_FALSE,
953: p_commit_flag IN varchar2 := FND_API.G_FALSE,
954: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,
955: p_msg_count OUT NOCOPY number,
956: p_msg_data OUT NOCOPY varchar2,
957: p_return_status OUT NOCOPY varchar2 ,
958: p_adj_rec IN ar_adjustments%rowtype,

Line 989: IF NOT FND_API.Compatible_API_Call(

985: /*--------------------------------------------------+
986: | Standard call to check for call compatibility |
987: +--------------------------------------------------*/
988:
989: IF NOT FND_API.Compatible_API_Call(
990: l_api_version,
991: p_api_version,
992: l_api_name,
993: G_PKG_NAME

Line 996: p_return_status := FND_API.G_RET_STS_ERROR ;

992: l_api_name,
993: G_PKG_NAME
994: )
995: THEN
996: p_return_status := FND_API.G_RET_STS_ERROR ;
997:
998: /*--------------------------------------------------+
999: | Get message count and if 1, return message data |
1000: +---------------------------------------------------*/

Line 1003: p_encoded => FND_API.G_FALSE,

999: | Get message count and if 1, return message data |
1000: +---------------------------------------------------*/
1001:
1002: FND_MSG_PUB.Count_And_Get(
1003: p_encoded => FND_API.G_FALSE,
1004: p_count => p_msg_count,
1005: p_data => p_msg_data
1006: );
1007: IF PG_DEBUG in ('Y', 'C') THEN

Line 1018: IF FND_API.to_Boolean( p_init_msg_list )

1014: /*-------------------------------------------------------------+
1015: | Initialize message list if p_init_msg_list is set to TRUE |
1016: +-------------------------------------------------------------*/
1017:
1018: IF FND_API.to_Boolean( p_init_msg_list )
1019: THEN
1020: FND_MSG_PUB.initialize;
1021: END IF;
1022:

Line 1044: p_return_status := FND_API.G_RET_STS_SUCCESS;

1040: /*-----------------------------------------+
1041: | Initialize return status to SUCCESS |
1042: +-----------------------------------------*/
1043:
1044: p_return_status := FND_API.G_RET_STS_SUCCESS;
1045:
1046: /*---------------------------------------------+
1047: | ========== Start of API Body ========== |
1048: +---------------------------------------------*/

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

1065: /*------------------------------------------------+
1066: | Check status and return if error |
1067: +------------------------------------------------*/
1068:
1069: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
1070: THEN
1071: /*---------------------------------------------------+
1072: | Rollback to the defined Savepoint |
1073: +---------------------------------------------------*/

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

1087: /*------------------------------------------------+
1088: | Check status and return if error |
1089: +------------------------------------------------*/
1090:
1091: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
1092: THEN
1093: /*---------------------------------------------------+
1094: | Rollback to the defined Savepoint |
1095: +---------------------------------------------------*/

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

1108: l_inp_adj_rec,
1109: l_return_status
1110: );
1111:
1112: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
1113: THEN
1114:
1115: /*---------------------------------------------------+
1116: | Rollback to the defined Savepoint |

Line 1128: p_encoded => FND_API.G_FALSE,

1124: | Get message count and if 1, return message data |
1125: +---------------------------------------------------*/
1126:
1127: FND_MSG_PUB.Count_And_Get(
1128: p_encoded => FND_API.G_FALSE,
1129: p_count => p_msg_count,
1130: p_data => p_msg_data
1131: );
1132:

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

1149: l_inp_adj_rec,
1150: l_return_status
1151: ) ;
1152:
1153: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
1154: THEN
1155:
1156: /*---------------------------------------------------+
1157: | Rollback to the defined Savepoint |

Line 1169: p_encoded => FND_API.G_FALSE,

1165: | Get message count and if 1, return message data |
1166: +---------------------------------------------------*/
1167:
1168: FND_MSG_PUB.Count_And_Get(
1169: p_encoded => FND_API.G_FALSE,
1170: p_count => p_msg_count,
1171: p_data => p_msg_data
1172: );
1173:

Line 1204: p_return_status := FND_API.G_RET_STS_ERROR ;

1200: +---------------------------------------------------*/
1201:
1202: ROLLBACK TO AR_ADJUSTAPI_PUB;
1203:
1204: p_return_status := FND_API.G_RET_STS_ERROR ;
1205:
1206: /*--------------------------------------------------+
1207: | Get message count and if 1, return message data |
1208: +---------------------------------------------------*/

Line 1211: p_encoded => FND_API.G_FALSE,

1207: | Get message count and if 1, return message data |
1208: +---------------------------------------------------*/
1209:
1210: FND_MSG_PUB.Count_And_Get(
1211: p_encoded => FND_API.G_FALSE,
1212: p_count => p_msg_count,
1213: p_data => p_msg_data
1214: );
1215:

Line 1239: p_encoded => FND_API.G_FALSE,

1235: | Get message count and if 1, return message data |
1236: +---------------------------------------------------*/
1237:
1238: FND_MSG_PUB.Count_And_Get(
1239: p_encoded => FND_API.G_FALSE,
1240: p_count => p_msg_count,
1241: p_data => p_msg_data
1242: );
1243:

Line 1248: IF FND_API.To_Boolean( p_commit_flag )

1244: /*--------------------------------+
1245: | Standard check of p_commit |
1246: +--------------------------------*/
1247:
1248: IF FND_API.To_Boolean( p_commit_flag )
1249: THEN
1250: IF PG_DEBUG in ('Y', 'C') THEN
1251: arp_util.debug('Create_Adjustment: ' || 'committing', G_MSG_HIGH);
1252: END IF;

Line 1270: WHEN FND_API.G_EXC_ERROR THEN

1266: END IF;
1267:
1268:
1269: EXCEPTION
1270: WHEN FND_API.G_EXC_ERROR THEN
1271:
1272: IF PG_DEBUG in ('Y', 'C') THEN
1273: arp_util.debug(SQLCODE, G_MSG_ERROR);
1274: arp_util.debug(SQLERRM, G_MSG_ERROR);

Line 1278: p_return_status := FND_API.G_RET_STS_ERROR ;

1274: arp_util.debug(SQLERRM, G_MSG_ERROR);
1275: END IF;
1276:
1277: ROLLBACK TO AR_ADJUSTAPI_PUB;
1278: p_return_status := FND_API.G_RET_STS_ERROR ;
1279: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
1280: p_count => p_msg_count,
1281: p_data => p_msg_data
1282: );

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

1275: END IF;
1276:
1277: ROLLBACK TO AR_ADJUSTAPI_PUB;
1278: p_return_status := FND_API.G_RET_STS_ERROR ;
1279: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
1280: p_count => p_msg_count,
1281: p_data => p_msg_data
1282: );
1283:

Line 1284: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1280: p_count => p_msg_count,
1281: p_data => p_msg_data
1282: );
1283:
1284: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1285:
1286: IF PG_DEBUG in ('Y', 'C') THEN
1287: arp_util.debug(SQLERRM, G_MSG_ERROR);
1288: END IF;

Line 1290: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1286: IF PG_DEBUG in ('Y', 'C') THEN
1287: arp_util.debug(SQLERRM, G_MSG_ERROR);
1288: END IF;
1289: ROLLBACK TO AR_ADJUSTAPI_PUB ;
1290: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1291: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
1292: p_count => p_msg_count,
1293: p_data => p_msg_data
1294: );

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

1287: arp_util.debug(SQLERRM, G_MSG_ERROR);
1288: END IF;
1289: ROLLBACK TO AR_ADJUSTAPI_PUB ;
1290: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1291: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
1292: p_count => p_msg_count,
1293: p_data => p_msg_data
1294: );
1295:

Line 1306: p_return_status := FND_API.G_RET_STS_ERROR ;

1302: +-------------------------------------------------------*/
1303:
1304: IF (SQLCODE = -20001)
1305: THEN
1306: p_return_status := FND_API.G_RET_STS_ERROR ;
1307: ROLLBACK TO AR_ADJUSTAPI_PUB;
1308: IF PG_DEBUG in ('Y', 'C') THEN
1309: arp_util.debug('Create_Adjustment: ' ||
1310: 'Completion validation error(s) occurred. ' ||

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

1311: 'Rolling back and setting status to ERROR',
1312: G_MSG_ERROR);
1313: END IF;
1314:
1315: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
1316: p_count => p_msg_count,
1317: p_data => p_msg_data
1318: );
1319: RETURN;

Line 1341: | fnd_api.compatible_api_call |

1337: | |
1338: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1339: | arp_util.disable_debug |
1340: | arp_util.enable_debug |
1341: | fnd_api.compatible_api_call |
1342: | fnd_api.g_exc_unexpected_error |
1343: | fnd_api.g_ret_sts_error |
1344: | fnd_api.g_ret_sts_error |
1345: | fnd_api.g_ret_sts_success |

Line 1342: | fnd_api.g_exc_unexpected_error |

1338: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1339: | arp_util.disable_debug |
1340: | arp_util.enable_debug |
1341: | fnd_api.compatible_api_call |
1342: | fnd_api.g_exc_unexpected_error |
1343: | fnd_api.g_ret_sts_error |
1344: | fnd_api.g_ret_sts_error |
1345: | fnd_api.g_ret_sts_success |
1346: | fnd_api.to_boolean |

Line 1343: | fnd_api.g_ret_sts_error |

1339: | arp_util.disable_debug |
1340: | arp_util.enable_debug |
1341: | fnd_api.compatible_api_call |
1342: | fnd_api.g_exc_unexpected_error |
1343: | fnd_api.g_ret_sts_error |
1344: | fnd_api.g_ret_sts_error |
1345: | fnd_api.g_ret_sts_success |
1346: | fnd_api.to_boolean |
1347: | fnd_msg_pub.check_msg_level |

Line 1344: | fnd_api.g_ret_sts_error |

1340: | arp_util.enable_debug |
1341: | fnd_api.compatible_api_call |
1342: | fnd_api.g_exc_unexpected_error |
1343: | fnd_api.g_ret_sts_error |
1344: | fnd_api.g_ret_sts_error |
1345: | fnd_api.g_ret_sts_success |
1346: | fnd_api.to_boolean |
1347: | fnd_msg_pub.check_msg_level |
1348: | fnd_msg_pub.count_and_get |

Line 1345: | fnd_api.g_ret_sts_success |

1341: | fnd_api.compatible_api_call |
1342: | fnd_api.g_exc_unexpected_error |
1343: | fnd_api.g_ret_sts_error |
1344: | fnd_api.g_ret_sts_error |
1345: | fnd_api.g_ret_sts_success |
1346: | fnd_api.to_boolean |
1347: | fnd_msg_pub.check_msg_level |
1348: | fnd_msg_pub.count_and_get |
1349: | fnd_msg_pub.initialize |

Line 1346: | fnd_api.to_boolean |

1342: | fnd_api.g_exc_unexpected_error |
1343: | fnd_api.g_ret_sts_error |
1344: | fnd_api.g_ret_sts_error |
1345: | fnd_api.g_ret_sts_success |
1346: | fnd_api.to_boolean |
1347: | fnd_msg_pub.check_msg_level |
1348: | fnd_msg_pub.count_and_get |
1349: | fnd_msg_pub.initialize |
1350: | ar_adjustments_pkg.fetch_p |

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

1378:
1379: PROCEDURE Modify_Adjustment (
1380: p_api_name IN varchar2,
1381: p_api_version IN number,
1382: p_init_msg_list IN varchar2 := FND_API.G_FALSE,
1383: p_commit_flag IN varchar2 := FND_API.G_FALSE,
1384: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,
1385: p_msg_count OUT NOCOPY number,
1386: p_msg_data OUT NOCOPY varchar2,

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

1379: PROCEDURE Modify_Adjustment (
1380: p_api_name IN varchar2,
1381: p_api_version IN number,
1382: p_init_msg_list IN varchar2 := FND_API.G_FALSE,
1383: p_commit_flag IN varchar2 := FND_API.G_FALSE,
1384: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,
1385: p_msg_count OUT NOCOPY number,
1386: p_msg_data OUT NOCOPY varchar2,
1387: p_return_status OUT NOCOPY varchar2 ,

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

1380: p_api_name IN varchar2,
1381: p_api_version IN number,
1382: p_init_msg_list IN varchar2 := FND_API.G_FALSE,
1383: p_commit_flag IN varchar2 := FND_API.G_FALSE,
1384: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,
1385: p_msg_count OUT NOCOPY number,
1386: p_msg_data OUT NOCOPY varchar2,
1387: p_return_status OUT NOCOPY varchar2 ,
1388: p_adj_rec IN ar_adjustments%rowtype,

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

1394: l_old_adj_rec ar_adjustments%rowtype;
1395: l_hsec VARCHAR2(10);
1396: l_status number;
1397: l_inp_adj_rec ar_adjustments%rowtype;
1398: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
1399:
1400:
1401: BEGIN
1402: select hsecs

Line 1416: IF NOT FND_API.Compatible_API_Call(

1412: /*--------------------------------------------------+
1413: | Standard call to check for call compatibility |
1414: +--------------------------------------------------*/
1415:
1416: IF NOT FND_API.Compatible_API_Call(
1417: l_api_version,
1418: p_api_version,
1419: l_api_name,
1420: G_PKG_NAME

Line 1423: p_return_status := FND_API.G_RET_STS_ERROR ;

1419: l_api_name,
1420: G_PKG_NAME
1421: )
1422: THEN
1423: p_return_status := FND_API.G_RET_STS_ERROR ;
1424: /*--------------------------------------------------+
1425: | Get message count and if 1, return message data |
1426: +---------------------------------------------------*/
1427:

Line 1429: p_encoded => FND_API.G_FALSE,

1425: | Get message count and if 1, return message data |
1426: +---------------------------------------------------*/
1427:
1428: FND_MSG_PUB.Count_And_Get(
1429: p_encoded => FND_API.G_FALSE,
1430: p_count => p_msg_count,
1431: p_data => p_msg_data
1432: );
1433: IF PG_DEBUG in ('Y', 'C') THEN

Line 1444: IF FND_API.to_Boolean( p_init_msg_list )

1440: /*-------------------------------------------------------------+
1441: | Initialize message list if p_init_msg_list is set to TRUE |
1442: +-------------------------------------------------------------*/
1443:
1444: IF FND_API.to_Boolean( p_init_msg_list )
1445: THEN
1446: FND_MSG_PUB.initialize;
1447: END IF;
1448:

Line 1471: p_return_status := FND_API.G_RET_STS_SUCCESS;

1467: /*-----------------------------------------+
1468: | Initialize return status to SUCCESS |
1469: +-----------------------------------------*/
1470:
1471: p_return_status := FND_API.G_RET_STS_SUCCESS;
1472:
1473: /*---------------------------------------------+
1474: | ========== Start of API Body ========== |
1475: +---------------------------------------------*/

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

1492: /*------------------------------------------------+
1493: | Check status and return if error |
1494: +------------------------------------------------*/
1495:
1496: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
1497: THEN
1498: /*---------------------------------------------------+
1499: | Rollback to the defined Savepoint |
1500: +---------------------------------------------------*/

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

1514: /*------------------------------------------------+
1515: | Check status and return if error |
1516: +------------------------------------------------*/
1517:
1518: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
1519: THEN
1520: /*---------------------------------------------------+
1521: | Rollback to the defined Savepoint |
1522: +---------------------------------------------------*/

Line 1547: p_return_status := FND_API.G_RET_STS_ERROR ;

1543: +---------------------------------------------------*/
1544:
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',

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

1567: l_return_status
1568: );
1569:
1570:
1571: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
1572: THEN
1573:
1574: /*---------------------------------------------------+
1575: | Rollback to the defined Savepoint |

Line 1587: p_encoded => FND_API.G_FALSE,

1583: | Get message count and if 1, return message data |
1584: +---------------------------------------------------*/
1585:
1586: FND_MSG_PUB.Count_And_Get(
1587: p_encoded => FND_API.G_FALSE,
1588: p_count => p_msg_count,
1589: p_data => p_msg_data
1590: );
1591:

Line 1623: p_return_status := FND_API.G_RET_STS_ERROR ;

1619: +---------------------------------------------------*/
1620:
1621: ROLLBACK TO AR_ADJUSTAPI_PUB;
1622:
1623: p_return_status := FND_API.G_RET_STS_ERROR ;
1624:
1625: /*--------------------------------------------------+
1626: | Get message count and if 1, return message data |
1627: +---------------------------------------------------*/

Line 1630: p_encoded => FND_API.G_FALSE,

1626: | Get message count and if 1, return message data |
1627: +---------------------------------------------------*/
1628:
1629: FND_MSG_PUB.Count_And_Get(
1630: p_encoded => FND_API.G_FALSE,
1631: p_count => p_msg_count,
1632: p_data => p_msg_data
1633: );
1634: IF PG_DEBUG in ('Y', 'C') THEN

Line 1653: p_encoded => FND_API.G_FALSE,

1649: | Get message count and if 1, return message data |
1650: +---------------------------------------------------*/
1651:
1652: FND_MSG_PUB.Count_And_Get(
1653: p_encoded => FND_API.G_FALSE,
1654: p_count => p_msg_count,
1655: p_data => p_msg_data
1656: );
1657:

Line 1662: IF FND_API.To_Boolean( p_commit_flag )

1658: /*--------------------------------+
1659: | Standard check of p_commit |
1660: +--------------------------------*/
1661:
1662: IF FND_API.To_Boolean( p_commit_flag )
1663: THEN
1664: IF PG_DEBUG in ('Y', 'C') THEN
1665: arp_util.debug('Modify_Adjustment: ' || 'committing', G_MSG_HIGH);
1666: END IF;

Line 1684: WHEN FND_API.G_EXC_ERROR THEN

1680: END IF;
1681:
1682:
1683: EXCEPTION
1684: WHEN FND_API.G_EXC_ERROR THEN
1685:
1686: IF PG_DEBUG in ('Y', 'C') THEN
1687: arp_util.debug('Modify_Adjustment: ' || SQLCODE, G_MSG_ERROR);
1688: arp_util.debug('Modify_Adjustment: ' || SQLERRM, G_MSG_ERROR);

Line 1692: p_return_status := FND_API.G_RET_STS_ERROR ;

1688: arp_util.debug('Modify_Adjustment: ' || SQLERRM, G_MSG_ERROR);
1689: END IF;
1690:
1691: ROLLBACK TO AR_ADJUSTAPI_PUB;
1692: p_return_status := FND_API.G_RET_STS_ERROR ;
1693: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
1694: p_count => p_msg_count,
1695: p_data => p_msg_data
1696: );

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

1689: END IF;
1690:
1691: ROLLBACK TO AR_ADJUSTAPI_PUB;
1692: p_return_status := FND_API.G_RET_STS_ERROR ;
1693: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
1694: p_count => p_msg_count,
1695: p_data => p_msg_data
1696: );
1697:

Line 1698: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1694: p_count => p_msg_count,
1695: p_data => p_msg_data
1696: );
1697:
1698: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1699:
1700: IF PG_DEBUG in ('Y', 'C') THEN
1701: arp_util.debug('Modify_Adjustment: ' || SQLERRM, G_MSG_ERROR);
1702: END IF;

Line 1704: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1700: IF PG_DEBUG in ('Y', 'C') THEN
1701: arp_util.debug('Modify_Adjustment: ' || SQLERRM, G_MSG_ERROR);
1702: END IF;
1703: ROLLBACK TO AR_ADJUSTAPI_PUB ;
1704: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1705: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
1706: p_count => p_msg_count,
1707: p_data => p_msg_data
1708: );

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

1701: arp_util.debug('Modify_Adjustment: ' || SQLERRM, G_MSG_ERROR);
1702: END IF;
1703: ROLLBACK TO AR_ADJUSTAPI_PUB ;
1704: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1705: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
1706: p_count => p_msg_count,
1707: p_data => p_msg_data
1708: );
1709:

Line 1720: p_return_status := FND_API.G_RET_STS_ERROR ;

1716: +-------------------------------------------------------*/
1717:
1718: IF (SQLCODE = -20001)
1719: THEN
1720: p_return_status := FND_API.G_RET_STS_ERROR ;
1721: ROLLBACK TO AR_ADJUSTAPI_PUB;
1722: IF PG_DEBUG in ('Y', 'C') THEN
1723: arp_util.debug('Modify_Adjustment: ' ||
1724: 'Completion validation error(s) occurred. ' ||

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

1724: 'Completion validation error(s) occurred. ' ||
1725: 'Rolling back and setting status to ERROR',
1726: G_MSG_ERROR);
1727: END IF;
1728: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
1729: p_count => p_msg_count,
1730: p_data => p_msg_data
1731: );
1732: RETURN;

Line 1754: | fnd_api.compatible_api_call |

1750: | |
1751: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
1752: | arp_util.disable_debug |
1753: | arp_util.enable_debug |
1754: | fnd_api.compatible_api_call |
1755: | fnd_api.g_exc_unexpected_error |
1756: | fnd_api.g_ret_sts_error |
1757: | fnd_api.g_ret_sts_error |
1758: | fnd_api.g_ret_sts_success |

Line 1755: | fnd_api.g_exc_unexpected_error |

1751: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
1752: | arp_util.disable_debug |
1753: | arp_util.enable_debug |
1754: | fnd_api.compatible_api_call |
1755: | fnd_api.g_exc_unexpected_error |
1756: | fnd_api.g_ret_sts_error |
1757: | fnd_api.g_ret_sts_error |
1758: | fnd_api.g_ret_sts_success |
1759: | fnd_api.to_boolean |

Line 1756: | fnd_api.g_ret_sts_error |

1752: | arp_util.disable_debug |
1753: | arp_util.enable_debug |
1754: | fnd_api.compatible_api_call |
1755: | fnd_api.g_exc_unexpected_error |
1756: | fnd_api.g_ret_sts_error |
1757: | fnd_api.g_ret_sts_error |
1758: | fnd_api.g_ret_sts_success |
1759: | fnd_api.to_boolean |
1760: | fnd_msg_pub.check_msg_level |

Line 1757: | fnd_api.g_ret_sts_error |

1753: | arp_util.enable_debug |
1754: | fnd_api.compatible_api_call |
1755: | fnd_api.g_exc_unexpected_error |
1756: | fnd_api.g_ret_sts_error |
1757: | fnd_api.g_ret_sts_error |
1758: | fnd_api.g_ret_sts_success |
1759: | fnd_api.to_boolean |
1760: | fnd_msg_pub.check_msg_level |
1761: | fnd_msg_pub.count_and_get |

Line 1758: | fnd_api.g_ret_sts_success |

1754: | fnd_api.compatible_api_call |
1755: | fnd_api.g_exc_unexpected_error |
1756: | fnd_api.g_ret_sts_error |
1757: | fnd_api.g_ret_sts_error |
1758: | fnd_api.g_ret_sts_success |
1759: | fnd_api.to_boolean |
1760: | fnd_msg_pub.check_msg_level |
1761: | fnd_msg_pub.count_and_get |
1762: | fnd_msg_pub.initialize |

Line 1759: | fnd_api.to_boolean |

1755: | fnd_api.g_exc_unexpected_error |
1756: | fnd_api.g_ret_sts_error |
1757: | fnd_api.g_ret_sts_error |
1758: | fnd_api.g_ret_sts_success |
1759: | fnd_api.to_boolean |
1760: | fnd_msg_pub.check_msg_level |
1761: | fnd_msg_pub.count_and_get |
1762: | fnd_msg_pub.initialize |
1763: | ar_adjustments_pkg.fetch_p |

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

1789:
1790: PROCEDURE Reverse_Adjustment (
1791: p_api_name IN varchar2,
1792: p_api_version IN number,
1793: p_init_msg_list IN varchar2 := FND_API.G_FALSE,
1794: p_commit_flag IN varchar2 := FND_API.G_FALSE,
1795: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,
1796: p_msg_count OUT NOCOPY number,
1797: p_msg_data OUT NOCOPY varchar2,

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

1790: PROCEDURE Reverse_Adjustment (
1791: p_api_name IN varchar2,
1792: p_api_version IN number,
1793: p_init_msg_list IN varchar2 := FND_API.G_FALSE,
1794: p_commit_flag IN varchar2 := FND_API.G_FALSE,
1795: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,
1796: p_msg_count OUT NOCOPY number,
1797: p_msg_data OUT NOCOPY varchar2,
1798: p_return_status OUT NOCOPY varchar2 ,

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

1791: p_api_name IN varchar2,
1792: p_api_version IN number,
1793: p_init_msg_list IN varchar2 := FND_API.G_FALSE,
1794: p_commit_flag IN varchar2 := FND_API.G_FALSE,
1795: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,
1796: p_msg_count OUT NOCOPY number,
1797: p_msg_data OUT NOCOPY varchar2,
1798: p_return_status OUT NOCOPY varchar2 ,
1799: p_old_adjust_id IN ar_adjustments.adjustment_id%type,

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

1808: l_reversal_gl_date ar_adjustments.gl_date%type;
1809: l_hsec VARCHAR2(10);
1810: l_status number;
1811: l_old_adj_rec ar_adjustments%rowtype;
1812: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
1813:
1814:
1815: BEGIN
1816: select hsecs

Line 1830: IF NOT FND_API.Compatible_API_Call(

1826: /*--------------------------------------------------+
1827: | Standard call to check for call compatibility |
1828: +--------------------------------------------------*/
1829:
1830: IF NOT FND_API.Compatible_API_Call(
1831: l_api_version,
1832: p_api_version,
1833: l_api_name,
1834: G_PKG_NAME

Line 1837: p_return_status := FND_API.G_RET_STS_ERROR ;

1833: l_api_name,
1834: G_PKG_NAME
1835: )
1836: THEN
1837: p_return_status := FND_API.G_RET_STS_ERROR ;
1838:
1839: /*--------------------------------------------------+
1840: | Get message count and if 1, return message data |
1841: +---------------------------------------------------*/

Line 1844: p_encoded =>FND_API.G_FALSE,

1840: | Get message count and if 1, return message data |
1841: +---------------------------------------------------*/
1842:
1843: FND_MSG_PUB.Count_And_Get(
1844: p_encoded =>FND_API.G_FALSE,
1845: p_count => p_msg_count,
1846: p_data => p_msg_data
1847: );
1848: IF PG_DEBUG in ('Y', 'C') THEN

Line 1859: IF FND_API.to_Boolean( p_init_msg_list )

1855: /*-------------------------------------------------------------+
1856: | Initialize message list if p_init_msg_list is set to TRUE |
1857: +-------------------------------------------------------------*/
1858:
1859: IF FND_API.to_Boolean( p_init_msg_list )
1860: THEN
1861: FND_MSG_PUB.initialize;
1862: END IF;
1863:

Line 1886: p_return_status := FND_API.G_RET_STS_SUCCESS;

1882: /*-----------------------------------------+
1883: | Initialize return status to SUCCESS |
1884: +-----------------------------------------*/
1885:
1886: p_return_status := FND_API.G_RET_STS_SUCCESS;
1887:
1888: /*---------------------------------------------+
1889: | ========== Start of API Body ========== |
1890: +---------------------------------------------*/

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

1901: /*------------------------------------------------+
1902: | Check status and return if error |
1903: +------------------------------------------------*/
1904:
1905: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
1906: THEN
1907: /*---------------------------------------------------+
1908: | Rollback to the defined Savepoint |
1909: +---------------------------------------------------*/

Line 1933: p_return_status := FND_API.G_RET_STS_ERROR ;

1929: +---------------------------------------------------*/
1930:
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',

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

1952: /*------------------------------------------------+
1953: | Check status and return if error |
1954: +------------------------------------------------*/
1955:
1956: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
1957: THEN
1958: /*---------------------------------------------------+
1959: | Rollback to the defined Savepoint |
1960: +---------------------------------------------------*/

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

1984: l_return_status
1985: );
1986:
1987:
1988: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
1989: THEN
1990:
1991: /*---------------------------------------------------+
1992: | Rollback to the defined Savepoint |

Line 2004: p_encoded =>FND_API.G_FALSE,

2000: | Get message count and if 1, return message data |
2001: +---------------------------------------------------*/
2002:
2003: FND_MSG_PUB.Count_And_Get(
2004: p_encoded =>FND_API.G_FALSE,
2005: p_count => p_msg_count,
2006: p_data => p_msg_data
2007: );
2008:

Line 2040: p_return_status := FND_API.G_RET_STS_ERROR ;

2036: +---------------------------------------------------*/
2037:
2038: ROLLBACK TO AR_ADJUSTAPI_PUB;
2039:
2040: p_return_status := FND_API.G_RET_STS_ERROR ;
2041:
2042: /*--------------------------------------------------+
2043: | Get message count and if 1, return message data |
2044: +---------------------------------------------------*/

Line 2047: p_encoded =>FND_API.G_FALSE,

2043: | Get message count and if 1, return message data |
2044: +---------------------------------------------------*/
2045:
2046: FND_MSG_PUB.Count_And_Get(
2047: p_encoded =>FND_API.G_FALSE,
2048: p_count => p_msg_count,
2049: p_data => p_msg_data
2050: );
2051:

Line 2072: p_encoded =>FND_API.G_FALSE,

2068: | Get message count and if 1, return message data |
2069: +---------------------------------------------------*/
2070:
2071: FND_MSG_PUB.Count_And_Get(
2072: p_encoded =>FND_API.G_FALSE,
2073: p_count => p_msg_count,
2074: p_data => p_msg_data
2075: );
2076:

Line 2081: IF FND_API.To_Boolean( p_commit_flag )

2077: /*--------------------------------+
2078: | Standard check of p_commit |
2079: +--------------------------------*/
2080:
2081: IF FND_API.To_Boolean( p_commit_flag )
2082: THEN
2083: IF PG_DEBUG in ('Y', 'C') THEN
2084: arp_util.debug('Reverse_Adjustment: ' || 'committing', G_MSG_HIGH);
2085: END IF;

Line 2103: WHEN FND_API.G_EXC_ERROR THEN

2099: END IF;
2100:
2101:
2102: EXCEPTION
2103: WHEN FND_API.G_EXC_ERROR THEN
2104:
2105: IF PG_DEBUG in ('Y', 'C') THEN
2106: arp_util.debug('Reverse_Adjustment: ' || SQLCODE, G_MSG_ERROR);
2107: arp_util.debug('Reverse_Adjustment: ' || SQLERRM, G_MSG_ERROR);

Line 2111: p_return_status := FND_API.G_RET_STS_ERROR ;

2107: arp_util.debug('Reverse_Adjustment: ' || SQLERRM, G_MSG_ERROR);
2108: END IF;
2109:
2110: ROLLBACK TO AR_ADJUSTAPI_PUB;
2111: p_return_status := FND_API.G_RET_STS_ERROR ;
2112: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
2113: p_count => p_msg_count,
2114: p_data => p_msg_data
2115: );

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

2108: END IF;
2109:
2110: ROLLBACK TO AR_ADJUSTAPI_PUB;
2111: p_return_status := FND_API.G_RET_STS_ERROR ;
2112: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
2113: p_count => p_msg_count,
2114: p_data => p_msg_data
2115: );
2116:

Line 2117: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2113: p_count => p_msg_count,
2114: p_data => p_msg_data
2115: );
2116:
2117: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2118:
2119: IF PG_DEBUG in ('Y', 'C') THEN
2120: arp_util.debug('Reverse_Adjustment: ' || SQLERRM, G_MSG_ERROR);
2121: END IF;

Line 2123: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2119: IF PG_DEBUG in ('Y', 'C') THEN
2120: arp_util.debug('Reverse_Adjustment: ' || SQLERRM, G_MSG_ERROR);
2121: END IF;
2122: ROLLBACK TO AR_ADJUSTAPI_PUB ;
2123: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2124: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
2125: p_count => p_msg_count,
2126: p_data => p_msg_data
2127: );

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

2120: arp_util.debug('Reverse_Adjustment: ' || SQLERRM, G_MSG_ERROR);
2121: END IF;
2122: ROLLBACK TO AR_ADJUSTAPI_PUB ;
2123: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2124: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
2125: p_count => p_msg_count,
2126: p_data => p_msg_data
2127: );
2128:

Line 2139: p_return_status := FND_API.G_RET_STS_ERROR ;

2135: +-------------------------------------------------------*/
2136:
2137: IF (SQLCODE = -20001)
2138: THEN
2139: p_return_status := FND_API.G_RET_STS_ERROR ;
2140: ROLLBACK TO AR_ADJUSTAPI_PUB;
2141: IF PG_DEBUG in ('Y', 'C') THEN
2142: arp_util.debug('Reverse_Adjustment: ' ||
2143: 'Completion validation error(s) occurred. ' ||

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

2144: 'Rolling back and setting status to ERROR',
2145: G_MSG_ERROR);
2146: END IF;
2147:
2148: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
2149: p_count => p_msg_count,
2150: p_data => p_msg_data
2151: );
2152: RETURN;

Line 2174: | fnd_api.compatible_api_call |

2170: | |
2171: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
2172: | arp_util.disable_debug |
2173: | arp_util.enable_debug |
2174: | fnd_api.compatible_api_call |
2175: | fnd_api.g_exc_unexpected_error |
2176: | fnd_api.g_ret_sts_error |
2177: | fnd_api.g_ret_sts_error |
2178: | fnd_api.g_ret_sts_success |

Line 2175: | fnd_api.g_exc_unexpected_error |

2171: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
2172: | arp_util.disable_debug |
2173: | arp_util.enable_debug |
2174: | fnd_api.compatible_api_call |
2175: | fnd_api.g_exc_unexpected_error |
2176: | fnd_api.g_ret_sts_error |
2177: | fnd_api.g_ret_sts_error |
2178: | fnd_api.g_ret_sts_success |
2179: | fnd_api.to_boolean |

Line 2176: | fnd_api.g_ret_sts_error |

2172: | arp_util.disable_debug |
2173: | arp_util.enable_debug |
2174: | fnd_api.compatible_api_call |
2175: | fnd_api.g_exc_unexpected_error |
2176: | fnd_api.g_ret_sts_error |
2177: | fnd_api.g_ret_sts_error |
2178: | fnd_api.g_ret_sts_success |
2179: | fnd_api.to_boolean |
2180: | fnd_msg_pub.check_msg_level |

Line 2177: | fnd_api.g_ret_sts_error |

2173: | arp_util.enable_debug |
2174: | fnd_api.compatible_api_call |
2175: | fnd_api.g_exc_unexpected_error |
2176: | fnd_api.g_ret_sts_error |
2177: | fnd_api.g_ret_sts_error |
2178: | fnd_api.g_ret_sts_success |
2179: | fnd_api.to_boolean |
2180: | fnd_msg_pub.check_msg_level |
2181: | fnd_msg_pub.count_and_get |

Line 2178: | fnd_api.g_ret_sts_success |

2174: | fnd_api.compatible_api_call |
2175: | fnd_api.g_exc_unexpected_error |
2176: | fnd_api.g_ret_sts_error |
2177: | fnd_api.g_ret_sts_error |
2178: | fnd_api.g_ret_sts_success |
2179: | fnd_api.to_boolean |
2180: | fnd_msg_pub.check_msg_level |
2181: | fnd_msg_pub.count_and_get |
2182: | fnd_msg_pub.initialize |

Line 2179: | fnd_api.to_boolean |

2175: | fnd_api.g_exc_unexpected_error |
2176: | fnd_api.g_ret_sts_error |
2177: | fnd_api.g_ret_sts_error |
2178: | fnd_api.g_ret_sts_success |
2179: | fnd_api.to_boolean |
2180: | fnd_msg_pub.check_msg_level |
2181: | fnd_msg_pub.count_and_get |
2182: | fnd_msg_pub.initialize |
2183: | ar_adjustments_pkg.fetch_p |

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

2210:
2211: PROCEDURE Approve_Adjustment (
2212: p_api_name IN varchar2,
2213: p_api_version IN number,
2214: p_init_msg_list IN varchar2 := FND_API.G_FALSE,
2215: p_commit_flag IN varchar2 := FND_API.G_FALSE,
2216: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,
2217: p_msg_count OUT NOCOPY number,
2218: p_msg_data OUT NOCOPY varchar2,

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

2211: PROCEDURE Approve_Adjustment (
2212: p_api_name IN varchar2,
2213: p_api_version IN number,
2214: p_init_msg_list IN varchar2 := FND_API.G_FALSE,
2215: p_commit_flag IN varchar2 := FND_API.G_FALSE,
2216: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,
2217: p_msg_count OUT NOCOPY number,
2218: p_msg_data OUT NOCOPY varchar2,
2219: p_return_status OUT NOCOPY varchar2 ,

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

2212: p_api_name IN varchar2,
2213: p_api_version IN number,
2214: p_init_msg_list IN varchar2 := FND_API.G_FALSE,
2215: p_commit_flag IN varchar2 := FND_API.G_FALSE,
2216: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,
2217: p_msg_count OUT NOCOPY number,
2218: p_msg_data OUT NOCOPY varchar2,
2219: p_return_status OUT NOCOPY varchar2 ,
2220: p_adj_rec IN ar_adjustments%rowtype,

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

2228: l_inp_adj_rec ar_adjustments%rowtype;
2229: l_hsec VARCHAR2(10);
2230: l_status number;
2231:
2232: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
2233:
2234:
2235: BEGIN
2236: select hsecs

Line 2250: IF NOT FND_API.Compatible_API_Call(

2246: /*--------------------------------------------------+
2247: | Standard call to check for call compatibility |
2248: +--------------------------------------------------*/
2249:
2250: IF NOT FND_API.Compatible_API_Call(
2251: l_api_version,
2252: p_api_version,
2253: l_api_name,
2254: G_PKG_NAME

Line 2257: p_return_status := FND_API.G_RET_STS_ERROR ;

2253: l_api_name,
2254: G_PKG_NAME
2255: )
2256: THEN
2257: p_return_status := FND_API.G_RET_STS_ERROR ;
2258: /*--------------------------------------------------+
2259: | Get message count and if 1, return message data |
2260: +---------------------------------------------------*/
2261:

Line 2263: p_encoded => FND_API.G_FALSE,

2259: | Get message count and if 1, return message data |
2260: +---------------------------------------------------*/
2261:
2262: FND_MSG_PUB.Count_And_Get(
2263: p_encoded => FND_API.G_FALSE,
2264: p_count => p_msg_count,
2265: p_data => p_msg_data
2266: );
2267: IF PG_DEBUG in ('Y', 'C') THEN

Line 2278: IF FND_API.to_Boolean( p_init_msg_list )

2274: /*-------------------------------------------------------------+
2275: | Initialize message list if p_init_msg_list is set to TRUE |
2276: +-------------------------------------------------------------*/
2277:
2278: IF FND_API.to_Boolean( p_init_msg_list )
2279: THEN
2280: FND_MSG_PUB.initialize;
2281: END IF;
2282:

Line 2305: p_return_status := FND_API.G_RET_STS_SUCCESS;

2301: /*-----------------------------------------+
2302: | Initialize return status to SUCCESS |
2303: +-----------------------------------------*/
2304:
2305: p_return_status := FND_API.G_RET_STS_SUCCESS;
2306:
2307: /*---------------------------------------------+
2308: | ========== Start of API Body ========== |
2309: +---------------------------------------------*/

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

2327: /*------------------------------------------------+
2328: | Check status and return if error |
2329: +------------------------------------------------*/
2330:
2331: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
2332: THEN
2333: /*---------------------------------------------------+
2334: | Rollback to the defined Savepoint |
2335: +---------------------------------------------------*/

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

2349: /*------------------------------------------------+
2350: | Check status and return if error |
2351: +------------------------------------------------*/
2352:
2353: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
2354: THEN
2355: /*---------------------------------------------------+
2356: | Rollback to the defined Savepoint |
2357: +---------------------------------------------------*/

Line 2382: p_return_status := FND_API.G_RET_STS_ERROR ;

2378: +---------------------------------------------------*/
2379:
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',

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

2402: l_return_status
2403: );
2404:
2405:
2406: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
2407: THEN
2408:
2409: /*---------------------------------------------------+
2410: | Rollback to the defined Savepoint |

Line 2422: p_encoded => FND_API.G_FALSE,

2418: | Get message count and if 1, return message data |
2419: +---------------------------------------------------*/
2420:
2421: FND_MSG_PUB.Count_And_Get(
2422: p_encoded => FND_API.G_FALSE,
2423: p_count => p_msg_count,
2424: p_data => p_msg_data
2425: );
2426:

Line 2459: p_return_status := FND_API.G_RET_STS_ERROR ;

2455: +---------------------------------------------------*/
2456:
2457: ROLLBACK TO AR_ADJUSTAPI_PUB;
2458:
2459: p_return_status := FND_API.G_RET_STS_ERROR ;
2460:
2461: /*--------------------------------------------------+
2462: | Get message count and if 1, return message data |
2463: +---------------------------------------------------*/

Line 2466: p_encoded => FND_API.G_FALSE,

2462: | Get message count and if 1, return message data |
2463: +---------------------------------------------------*/
2464:
2465: FND_MSG_PUB.Count_And_Get(
2466: p_encoded => FND_API.G_FALSE,
2467: p_count => p_msg_count,
2468: p_data => p_msg_data
2469: );
2470:

Line 2491: p_encoded => FND_API.G_FALSE,

2487: | Get message count and if 1, return message data |
2488: +---------------------------------------------------*/
2489:
2490: FND_MSG_PUB.Count_And_Get(
2491: p_encoded => FND_API.G_FALSE,
2492: p_count => p_msg_count,
2493: p_data => p_msg_data
2494: );
2495:

Line 2500: IF FND_API.To_Boolean( p_commit_flag )

2496: /*--------------------------------+
2497: | Standard check of p_commit |
2498: +--------------------------------*/
2499:
2500: IF FND_API.To_Boolean( p_commit_flag )
2501: THEN
2502: IF PG_DEBUG in ('Y', 'C') THEN
2503: arp_util.debug('Approve_Adjustment: ' || 'committing', G_MSG_HIGH);
2504: END IF;

Line 2522: WHEN FND_API.G_EXC_ERROR THEN

2518: END IF;
2519:
2520:
2521: EXCEPTION
2522: WHEN FND_API.G_EXC_ERROR THEN
2523:
2524: IF PG_DEBUG in ('Y', 'C') THEN
2525: arp_util.debug('Approve_Adjustment: ' || SQLCODE, G_MSG_ERROR);
2526: arp_util.debug('Approve_Adjustment: ' || SQLERRM, G_MSG_ERROR);

Line 2530: p_return_status := FND_API.G_RET_STS_ERROR ;

2526: arp_util.debug('Approve_Adjustment: ' || SQLERRM, G_MSG_ERROR);
2527: END IF;
2528:
2529: ROLLBACK TO AR_ADJUSTAPI_PUB;
2530: p_return_status := FND_API.G_RET_STS_ERROR ;
2531: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
2532: p_count => p_msg_count,
2533: p_data => p_msg_data
2534: );

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

2527: END IF;
2528:
2529: ROLLBACK TO AR_ADJUSTAPI_PUB;
2530: p_return_status := FND_API.G_RET_STS_ERROR ;
2531: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
2532: p_count => p_msg_count,
2533: p_data => p_msg_data
2534: );
2535:

Line 2536: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2532: p_count => p_msg_count,
2533: p_data => p_msg_data
2534: );
2535:
2536: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2537:
2538: IF PG_DEBUG in ('Y', 'C') THEN
2539: arp_util.debug('Approve_Adjustment: ' || SQLERRM, G_MSG_ERROR);
2540: END IF;

Line 2542: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2538: IF PG_DEBUG in ('Y', 'C') THEN
2539: arp_util.debug('Approve_Adjustment: ' || SQLERRM, G_MSG_ERROR);
2540: END IF;
2541: ROLLBACK TO AR_ADJUSTAPI_PUB ;
2542: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2543: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
2544: p_count => p_msg_count,
2545: p_data => p_msg_data
2546: );

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

2539: arp_util.debug('Approve_Adjustment: ' || SQLERRM, G_MSG_ERROR);
2540: END IF;
2541: ROLLBACK TO AR_ADJUSTAPI_PUB ;
2542: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2543: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
2544: p_count => p_msg_count,
2545: p_data => p_msg_data
2546: );
2547:

Line 2558: p_return_status := FND_API.G_RET_STS_ERROR ;

2554: +-------------------------------------------------------*/
2555:
2556: IF (SQLCODE = -20001)
2557: THEN
2558: p_return_status := FND_API.G_RET_STS_ERROR ;
2559: ROLLBACK TO AR_ADJUSTAPI_PUB;
2560: IF PG_DEBUG in ('Y', 'C') THEN
2561: arp_util.debug('Approve_Adjustment: ' ||
2562: 'Completion validation error(s) occurred. ' ||

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

2563: 'Rolling back and setting status to ERROR',
2564: G_MSG_ERROR);
2565: END IF;
2566:
2567: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
2568: p_count => p_msg_count,
2569: p_data => p_msg_data
2570: );
2571: RETURN;