APPS.AR_REVENUE_ADJUSTMENT_PVT dependencies on FND_API

Line 33: -- Default = FND_API.G_FALSE

29: -- Pre-reqs : Sufficient earned revenue must exist.
30: -- Parameters :
31: -- IN : p_api_version NUMBER Required
32: -- p_init_msg_list VARCHAR2 Optional
33: -- Default = FND_API.G_FALSE
34: -- p_commit VARCHAR2 Optional
35: -- Default = FND_API.G_FALSE
36: -- p_validation_level NUMBER Optional
37: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 35: -- Default = FND_API.G_FALSE

31: -- IN : p_api_version NUMBER Required
32: -- p_init_msg_list VARCHAR2 Optional
33: -- Default = FND_API.G_FALSE
34: -- p_commit VARCHAR2 Optional
35: -- Default = FND_API.G_FALSE
36: -- p_validation_level NUMBER Optional
37: -- Default = FND_API.G_VALID_LEVEL_FULL
38: -- p_rev_adj_rec Rev_Adj_Rec_Type Required
39: -- OUT NOCOPY : x_return_status VARCHAR2(1)

Line 37: -- Default = FND_API.G_VALID_LEVEL_FULL

33: -- Default = FND_API.G_FALSE
34: -- p_commit VARCHAR2 Optional
35: -- Default = FND_API.G_FALSE
36: -- p_validation_level NUMBER Optional
37: -- Default = FND_API.G_VALID_LEVEL_FULL
38: -- p_rev_adj_rec Rev_Adj_Rec_Type Required
39: -- OUT NOCOPY : x_return_status VARCHAR2(1)
40: -- x_msg_count NUMBER
41: -- x_msg_data VARCHAR2(2000)

Line 77: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

73: END IF;
74: -- Standard Start of API savepoint
75: SAVEPOINT Unearn_Revenue_PVT;
76: -- Standard call to check for call compatibility.
77: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
78: p_api_version ,
79: l_api_name ,
80: G_PKG_NAME )
81: THEN

Line 86: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

82: IF PG_DEBUG in ('Y', 'C') THEN
83: arp_util.debug('Unearn_Revenue: ' || '.Unexpected error '||sqlerrm||
84: ' at AR_Revenue_Adjustment_PVT.Unearn_Revenue()+');
85: END IF;
86: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
87: END IF;
88: -- Initialize message list if p_init_msg_list is set to TRUE.
89: IF FND_API.to_Boolean( p_init_msg_list )
90: THEN

Line 89: IF FND_API.to_Boolean( p_init_msg_list )

85: END IF;
86: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
87: END IF;
88: -- Initialize message list if p_init_msg_list is set to TRUE.
89: IF FND_API.to_Boolean( p_init_msg_list )
90: THEN
91: FND_MSG_PUB.initialize;
92: END IF;
93: -- Initialize API return status to success

Line 94: x_return_status := FND_API.G_RET_STS_SUCCESS;

90: THEN
91: FND_MSG_PUB.initialize;
92: END IF;
93: -- Initialize API return status to success
94: x_return_status := FND_API.G_RET_STS_SUCCESS;
95:
96: l_rev_adj_rec := p_rev_adj_rec;
97:
98: /*Bug 6731185 JVARKEY Making sure GL date has no timestamp*/

Line 110: IF x_return_status = FND_API.G_RET_STS_ERROR

106: ,x_msg_count => x_msg_count
107: ,x_msg_data => x_msg_data
108: ,x_adjustment_id => x_adjustment_id
109: ,x_adjustment_number => x_adjustment_number);
110: IF x_return_status = FND_API.G_RET_STS_ERROR
111: THEN
112: RAISE FND_API.G_EXC_ERROR;
113: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
114: THEN

Line 112: RAISE FND_API.G_EXC_ERROR;

108: ,x_adjustment_id => x_adjustment_id
109: ,x_adjustment_number => x_adjustment_number);
110: IF x_return_status = FND_API.G_RET_STS_ERROR
111: THEN
112: RAISE FND_API.G_EXC_ERROR;
113: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
114: THEN
115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
116: END IF;

Line 113: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

109: ,x_adjustment_number => x_adjustment_number);
110: IF x_return_status = FND_API.G_RET_STS_ERROR
111: THEN
112: RAISE FND_API.G_EXC_ERROR;
113: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
114: THEN
115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
116: END IF;
117:

Line 115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

111: THEN
112: RAISE FND_API.G_EXC_ERROR;
113: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
114: THEN
115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
116: END IF;
117:
118: -- Standard check of p_commit.
119: IF FND_API.To_Boolean( p_commit )

Line 119: IF FND_API.To_Boolean( p_commit )

115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
116: END IF;
117:
118: -- Standard check of p_commit.
119: IF FND_API.To_Boolean( p_commit )
120: THEN
121: COMMIT WORK;
122: END IF;
123: -- Standard call to get message count and if count is 1, get message info.

Line 125: (p_encoded => FND_API.G_FALSE,

121: COMMIT WORK;
122: END IF;
123: -- Standard call to get message count and if count is 1, get message info.
124: FND_MSG_PUB.Count_And_Get
125: (p_encoded => FND_API.G_FALSE,
126: p_count => x_msg_count,
127: p_data => x_msg_data);
128: IF PG_DEBUG in ('Y', 'C') THEN
129: arp_util.debug('AR_Revenue_Adjustment_PVT.Unearn_Revenue()-');

Line 132: WHEN FND_API.G_EXC_ERROR THEN

128: IF PG_DEBUG in ('Y', 'C') THEN
129: arp_util.debug('AR_Revenue_Adjustment_PVT.Unearn_Revenue()-');
130: END IF;
131: EXCEPTION
132: WHEN FND_API.G_EXC_ERROR THEN
133: ROLLBACK TO Unearn_Revenue_PVT;
134: x_return_status := FND_API.G_RET_STS_ERROR ;
135: FND_MSG_PUB.Count_And_Get
136: (p_encoded => FND_API.G_FALSE,

Line 134: x_return_status := FND_API.G_RET_STS_ERROR ;

130: END IF;
131: EXCEPTION
132: WHEN FND_API.G_EXC_ERROR THEN
133: ROLLBACK TO Unearn_Revenue_PVT;
134: x_return_status := FND_API.G_RET_STS_ERROR ;
135: FND_MSG_PUB.Count_And_Get
136: (p_encoded => FND_API.G_FALSE,
137: p_count => x_msg_count,
138: p_data => x_msg_data);

Line 136: (p_encoded => FND_API.G_FALSE,

132: WHEN FND_API.G_EXC_ERROR THEN
133: ROLLBACK TO Unearn_Revenue_PVT;
134: x_return_status := FND_API.G_RET_STS_ERROR ;
135: FND_MSG_PUB.Count_And_Get
136: (p_encoded => FND_API.G_FALSE,
137: p_count => x_msg_count,
138: p_data => x_msg_data);
139: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
140: IF PG_DEBUG in ('Y', 'C') THEN

Line 139: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

135: FND_MSG_PUB.Count_And_Get
136: (p_encoded => FND_API.G_FALSE,
137: p_count => x_msg_count,
138: p_data => x_msg_data);
139: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
140: IF PG_DEBUG in ('Y', 'C') THEN
141: arp_util.debug('Unearn_Revenue: ' || 'Unexpected error '||sqlerrm||
142: ' at AR_Revenue_Adjustment_PVT.Unearn_Revenue()+');
143: END IF;

Line 145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

141: arp_util.debug('Unearn_Revenue: ' || 'Unexpected error '||sqlerrm||
142: ' at AR_Revenue_Adjustment_PVT.Unearn_Revenue()+');
143: END IF;
144: ROLLBACK TO Unearn_Revenue_PVT;
145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
146: FND_MSG_PUB.Count_And_Get
147: (p_encoded => FND_API.G_FALSE,
148: p_count => x_msg_count,
149: p_data => x_msg_data);

Line 147: (p_encoded => FND_API.G_FALSE,

143: END IF;
144: ROLLBACK TO Unearn_Revenue_PVT;
145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
146: FND_MSG_PUB.Count_And_Get
147: (p_encoded => FND_API.G_FALSE,
148: p_count => x_msg_count,
149: p_data => x_msg_data);
150: WHEN OTHERS THEN
151: IF (SQLCODE = -20001)

Line 157: x_return_status := FND_API.G_RET_STS_ERROR ;

153: IF PG_DEBUG in ('Y', 'C') THEN
154: arp_util.debug('Unearn_Revenue: ' || '20001 error '||
155: ' at AR_Revenue_Adjustment_PVT.Unearn_Revenue()+');
156: END IF;
157: x_return_status := FND_API.G_RET_STS_ERROR ;
158: ELSE
159: IF PG_DEBUG in ('Y', 'C') THEN
160: arp_util.debug('Unearn_Revenue: ' || 'Unexpected error '||sqlerrm||
161: ' at AR_Revenue_Adjustment_PVT.Unearn_Revenue()+');

Line 163: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

159: IF PG_DEBUG in ('Y', 'C') THEN
160: arp_util.debug('Unearn_Revenue: ' || 'Unexpected error '||sqlerrm||
161: ' at AR_Revenue_Adjustment_PVT.Unearn_Revenue()+');
162: END IF;
163: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
164: IF FND_MSG_PUB.Check_Msg_Level
165: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
166: THEN
167: FND_MSG_PUB.Add_Exc_Msg

Line 175: (p_encoded => FND_API.G_FALSE,

171: END IF;
172: END IF;
173: ROLLBACK TO Unearn_Revenue_PVT;
174: FND_MSG_PUB.Count_And_Get
175: (p_encoded => FND_API.G_FALSE,
176: p_count => x_msg_count,
177: p_data => x_msg_data);
178: END Unearn_Revenue;
179:

Line 189: -- Default = FND_API.G_FALSE

185: -- Pre-reqs : Sufficient unearned revenue must exist.
186: -- Parameters :
187: -- IN : p_api_version NUMBER Required
188: -- p_init_msg_list VARCHAR2 Optional
189: -- Default = FND_API.G_FALSE
190: -- p_commit VARCHAR2 Optional
191: -- Default = FND_API.G_FALSE
192: -- p_validation_level NUMBER Optional
193: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 191: -- Default = FND_API.G_FALSE

187: -- IN : p_api_version NUMBER Required
188: -- p_init_msg_list VARCHAR2 Optional
189: -- Default = FND_API.G_FALSE
190: -- p_commit VARCHAR2 Optional
191: -- Default = FND_API.G_FALSE
192: -- p_validation_level NUMBER Optional
193: -- Default = FND_API.G_VALID_LEVEL_FULL
194: -- p_rev_adj_rec Rev_Adj_Rec_Type Required
195: -- OUT NOCOPY : x_return_status VARCHAR2(1)

Line 193: -- Default = FND_API.G_VALID_LEVEL_FULL

189: -- Default = FND_API.G_FALSE
190: -- p_commit VARCHAR2 Optional
191: -- Default = FND_API.G_FALSE
192: -- p_validation_level NUMBER Optional
193: -- Default = FND_API.G_VALID_LEVEL_FULL
194: -- p_rev_adj_rec Rev_Adj_Rec_Type Required
195: -- OUT NOCOPY : x_return_status VARCHAR2(1)
196: -- x_msg_count NUMBER
197: -- x_msg_data VARCHAR2(2000)

Line 231: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

227: END IF;
228: -- Standard Start of API savepoint
229: SAVEPOINT Earn_Revenue_PVT;
230: -- Standard call to check for call compatibility.
231: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
232: p_api_version ,
233: l_api_name ,
234: G_PKG_NAME )
235: THEN

Line 240: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

236: IF PG_DEBUG in ('Y', 'C') THEN
237: arp_util.debug('Earn_Revenue: ' || 'Unexpected error '||sqlerrm||
238: ' at AR_Revenue_Adjustment_PVT.Earn_Revenue()+');
239: END IF;
240: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
241: END IF;
242: -- Initialize message list if p_init_msg_list is set to TRUE.
243: IF FND_API.to_Boolean( p_init_msg_list )
244: THEN

Line 243: IF FND_API.to_Boolean( p_init_msg_list )

239: END IF;
240: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
241: END IF;
242: -- Initialize message list if p_init_msg_list is set to TRUE.
243: IF FND_API.to_Boolean( p_init_msg_list )
244: THEN
245: FND_MSG_PUB.initialize;
246: END IF;
247: -- Initialize API return status to success

Line 248: x_return_status := FND_API.G_RET_STS_SUCCESS;

244: THEN
245: FND_MSG_PUB.initialize;
246: END IF;
247: -- Initialize API return status to success
248: x_return_status := FND_API.G_RET_STS_SUCCESS;
249:
250: l_rev_adj_rec := p_rev_adj_rec;
251:
252: /*Bug 6731185 JVARKEY Making sure GL date has no timestamp*/

Line 264: IF x_return_status = FND_API.G_RET_STS_ERROR

260: ,x_msg_count => x_msg_count
261: ,x_msg_data => x_msg_data
262: ,x_adjustment_id => x_adjustment_id
263: ,x_adjustment_number => x_adjustment_number);
264: IF x_return_status = FND_API.G_RET_STS_ERROR
265: THEN
266: RAISE FND_API.G_EXC_ERROR;
267: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
268: THEN

Line 266: RAISE FND_API.G_EXC_ERROR;

262: ,x_adjustment_id => x_adjustment_id
263: ,x_adjustment_number => x_adjustment_number);
264: IF x_return_status = FND_API.G_RET_STS_ERROR
265: THEN
266: RAISE FND_API.G_EXC_ERROR;
267: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
268: THEN
269: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
270: END IF;

Line 267: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

263: ,x_adjustment_number => x_adjustment_number);
264: IF x_return_status = FND_API.G_RET_STS_ERROR
265: THEN
266: RAISE FND_API.G_EXC_ERROR;
267: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
268: THEN
269: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
270: END IF;
271: -- Standard check of p_commit.

Line 269: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

265: THEN
266: RAISE FND_API.G_EXC_ERROR;
267: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
268: THEN
269: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
270: END IF;
271: -- Standard check of p_commit.
272: IF FND_API.To_Boolean( p_commit )
273: THEN

Line 272: IF FND_API.To_Boolean( p_commit )

268: THEN
269: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
270: END IF;
271: -- Standard check of p_commit.
272: IF FND_API.To_Boolean( p_commit )
273: THEN
274: COMMIT WORK;
275: END IF;
276: -- Standard call to get message count and if count is 1, get message info.

Line 278: (p_encoded => FND_API.G_FALSE,

274: COMMIT WORK;
275: END IF;
276: -- Standard call to get message count and if count is 1, get message info.
277: FND_MSG_PUB.Count_And_Get
278: (p_encoded => FND_API.G_FALSE,
279: p_count => x_msg_count,
280: p_data => x_msg_data);
281: IF PG_DEBUG in ('Y', 'C') THEN
282: arp_util.debug('AR_Revenue_Adjustment_PVT.Earn_Revenue()-');

Line 285: WHEN FND_API.G_EXC_ERROR THEN

281: IF PG_DEBUG in ('Y', 'C') THEN
282: arp_util.debug('AR_Revenue_Adjustment_PVT.Earn_Revenue()-');
283: END IF;
284: EXCEPTION
285: WHEN FND_API.G_EXC_ERROR THEN
286: ROLLBACK TO Earn_Revenue_PVT;
287: x_return_status := FND_API.G_RET_STS_ERROR ;
288: FND_MSG_PUB.Count_And_Get
289: (p_encoded => FND_API.G_FALSE,

Line 287: x_return_status := FND_API.G_RET_STS_ERROR ;

283: END IF;
284: EXCEPTION
285: WHEN FND_API.G_EXC_ERROR THEN
286: ROLLBACK TO Earn_Revenue_PVT;
287: x_return_status := FND_API.G_RET_STS_ERROR ;
288: FND_MSG_PUB.Count_And_Get
289: (p_encoded => FND_API.G_FALSE,
290: p_count => x_msg_count,
291: p_data => x_msg_data);

Line 289: (p_encoded => FND_API.G_FALSE,

285: WHEN FND_API.G_EXC_ERROR THEN
286: ROLLBACK TO Earn_Revenue_PVT;
287: x_return_status := FND_API.G_RET_STS_ERROR ;
288: FND_MSG_PUB.Count_And_Get
289: (p_encoded => FND_API.G_FALSE,
290: p_count => x_msg_count,
291: p_data => x_msg_data);
292: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
293: IF PG_DEBUG in ('Y', 'C') THEN

Line 292: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

288: FND_MSG_PUB.Count_And_Get
289: (p_encoded => FND_API.G_FALSE,
290: p_count => x_msg_count,
291: p_data => x_msg_data);
292: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
293: IF PG_DEBUG in ('Y', 'C') THEN
294: arp_util.debug('Earn_Revenue: ' || 'Unexpected error '||sqlerrm||
295: ' at AR_Revenue_Adjustment_PVT.Earn_Revenue()+');
296: END IF;

Line 298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

294: arp_util.debug('Earn_Revenue: ' || 'Unexpected error '||sqlerrm||
295: ' at AR_Revenue_Adjustment_PVT.Earn_Revenue()+');
296: END IF;
297: ROLLBACK TO Earn_Revenue_PVT;
298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
299: FND_MSG_PUB.Count_And_Get
300: (p_encoded => FND_API.G_FALSE,
301: p_count => x_msg_count,
302: p_data => x_msg_data);

Line 300: (p_encoded => FND_API.G_FALSE,

296: END IF;
297: ROLLBACK TO Earn_Revenue_PVT;
298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
299: FND_MSG_PUB.Count_And_Get
300: (p_encoded => FND_API.G_FALSE,
301: p_count => x_msg_count,
302: p_data => x_msg_data);
303: WHEN OTHERS THEN
304: IF (SQLCODE = -20001)

Line 310: x_return_status := FND_API.G_RET_STS_ERROR ;

306: IF PG_DEBUG in ('Y', 'C') THEN
307: arp_util.debug('Earn_Revenue: ' || '20001 error '||
308: ' at AR_Revenue_Adjustment_PVT.Earn_Revenue()+');
309: END IF;
310: x_return_status := FND_API.G_RET_STS_ERROR ;
311: ELSE
312: IF PG_DEBUG in ('Y', 'C') THEN
313: arp_util.debug('Earn_Revenue: ' || 'Unexpected error '||sqlerrm||
314: ' at AR_Revenue_Adjustment_PVT.Earn_Revenue()+');

Line 316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

312: IF PG_DEBUG in ('Y', 'C') THEN
313: arp_util.debug('Earn_Revenue: ' || 'Unexpected error '||sqlerrm||
314: ' at AR_Revenue_Adjustment_PVT.Earn_Revenue()+');
315: END IF;
316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
317: IF FND_MSG_PUB.Check_Msg_Level
318: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
319: THEN
320: FND_MSG_PUB.Add_Exc_Msg

Line 328: (p_encoded => FND_API.G_FALSE,

324: END IF;
325: END IF;
326: ROLLBACK TO Earn_Revenue_PVT;
327: FND_MSG_PUB.Count_And_Get
328: (p_encoded => FND_API.G_FALSE,
329: p_count => x_msg_count,
330: p_data => x_msg_data);
331: END Earn_Revenue;
332:

Line 345: -- Default = FND_API.G_FALSE

341: -- Pre-reqs : Sufficient unearned revenue must exist.
342: -- Parameters :
343: -- IN : p_api_version NUMBER Required
344: -- p_init_msg_list VARCHAR2 Optional
345: -- Default = FND_API.G_FALSE
346: -- p_commit VARCHAR2 Optional
347: -- Default = FND_API.G_FALSE
348: -- p_validation_level NUMBER Optional
349: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 347: -- Default = FND_API.G_FALSE

343: -- IN : p_api_version NUMBER Required
344: -- p_init_msg_list VARCHAR2 Optional
345: -- Default = FND_API.G_FALSE
346: -- p_commit VARCHAR2 Optional
347: -- Default = FND_API.G_FALSE
348: -- p_validation_level NUMBER Optional
349: -- Default = FND_API.G_VALID_LEVEL_FULL
350: -- p_rev_adj_rec Rev_Adj_Rec_Type Required
351: -- OUT NOCOPY : x_return_status VARCHAR2(1)

Line 349: -- Default = FND_API.G_VALID_LEVEL_FULL

345: -- Default = FND_API.G_FALSE
346: -- p_commit VARCHAR2 Optional
347: -- Default = FND_API.G_FALSE
348: -- p_validation_level NUMBER Optional
349: -- Default = FND_API.G_VALID_LEVEL_FULL
350: -- p_rev_adj_rec Rev_Adj_Rec_Type Required
351: -- OUT NOCOPY : x_return_status VARCHAR2(1)
352: -- x_msg_count NUMBER
353: -- x_msg_data VARCHAR2(2000)

Line 399: ,p_init_msg_list => FND_API.G_TRUE

395: g_update_db_flag := 'N';
396:
397: Earn_Revenue
398: ( p_api_version => 2.0
399: ,p_init_msg_list => FND_API.G_TRUE
400: ,p_commit => FND_API.G_FALSE
401: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
402: ,x_return_status => x_return_status
403: ,x_msg_count => x_msg_count

Line 400: ,p_commit => FND_API.G_FALSE

396:
397: Earn_Revenue
398: ( p_api_version => 2.0
399: ,p_init_msg_list => FND_API.G_TRUE
400: ,p_commit => FND_API.G_FALSE
401: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
402: ,x_return_status => x_return_status
403: ,x_msg_count => x_msg_count
404: ,x_msg_data => x_msg_data

Line 401: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

397: Earn_Revenue
398: ( p_api_version => 2.0
399: ,p_init_msg_list => FND_API.G_TRUE
400: ,p_commit => FND_API.G_FALSE
401: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
402: ,x_return_status => x_return_status
403: ,x_msg_count => x_msg_count
404: ,x_msg_data => x_msg_data
405: ,p_rev_adj_rec => p_rev_adj_rec

Line 515: AR_RAAPI_UTIL.Validate_Parameters (p_init_msg_list => FND_API.G_FALSE

511: l_rev_adj_rec.gl_date := trunc(p_rev_adj_rec.gl_date);
512:
513: AR_RAAPI_UTIL.Constant_System_Values;
514: AR_RAAPI_UTIL.Initialize_Globals;
515: AR_RAAPI_UTIL.Validate_Parameters (p_init_msg_list => FND_API.G_FALSE
516: ,p_rev_adj_rec => l_rev_adj_rec
517: ,p_validation_level => p_validation_level
518: ,x_return_status => x_return_status
519: ,x_msg_count => x_msg_count

Line 521: IF x_return_status = FND_API.G_RET_STS_SUCCESS

517: ,p_validation_level => p_validation_level
518: ,x_return_status => x_return_status
519: ,x_msg_count => x_msg_count
520: ,x_msg_data => x_msg_data);
521: IF x_return_status = FND_API.G_RET_STS_SUCCESS
522: THEN
523: l_total_adjusted := 0;
524:
525: AR_RAAPI_UTIL.Validate_Amount

Line 526: (p_init_msg_list => FND_API.G_FALSE

522: THEN
523: l_total_adjusted := 0;
524:
525: AR_RAAPI_UTIL.Validate_Amount
526: (p_init_msg_list => FND_API.G_FALSE
527: ,p_customer_trx_line_id => AR_RAAPI_UTIL.g_from_cust_trx_line_id
528: ,p_adjustment_type => p_rev_adj_rec.adjustment_type
529: ,p_amount_mode => p_rev_adj_rec.amount_mode
530: ,p_customer_trx_id => AR_RAAPI_UTIL.g_customer_trx_id

Line 546: IF x_return_status = FND_API.G_RET_STS_SUCCESS

542: ,x_msg_count => x_msg_count
543: ,x_msg_data => x_msg_data);
544: END IF;
545:
546: IF x_return_status = FND_API.G_RET_STS_SUCCESS
547: THEN
548: l_rev_adj_rec.amount := l_revenue_amount;
549: l_line_count := 0;
550:

Line 565: RAISE FND_API.G_EXC_ERROR;

561: IF l_gl_date_valid IS NULL
562: THEN
563: FND_MESSAGE.set_name('AR','AR_VAL_GL_DATE');
564: FND_MSG_PUB.Add;
565: RAISE FND_API.G_EXC_ERROR;
566: ELSE
567: /* date was returned, use it */
568: l_rev_adj_rec.gl_date := l_gl_date_valid;
569:

Line 626: x_return_status := FND_API.G_RET_STS_SUCCESS;

622: /* Bug 2651996 - a null return status is being passed back from revenue
623: synchronizer - assume successful */
624: IF x_return_status IS NULL
625: THEN
626: x_return_status := FND_API.G_RET_STS_SUCCESS;
627: END IF;
628: IF PG_DEBUG in ('Y', 'C') THEN
629: arp_util.debug('x_return_status : '||x_return_status);
630: END IF;

Line 815: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

811: previously recorded in ar_rev_line_adj_gt */
812: IF (arp_rounding.correct_rev_adj_by_line = 0)
813: THEN
814: arp_util.debug('ERROR: arp_rounding.correct_rev_adj_by_line');
815: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
816: END IF;
817: END IF;
818:
819: END IF;

Line 833: RAISE FND_API.G_EXC_ERROR;

829: IF PG_DEBUG in ('Y', 'C') THEN
830: arp_util.debug
831: ('20001 error at AR_Revenue_Adjustment_PVT.earn_or_unearn');
832: END IF;
833: RAISE FND_API.G_EXC_ERROR;
834: ELSE
835: IF PG_DEBUG in ('Y', 'C') THEN
836: arp_util.debug('earn_or_unearn: ' || 'Unexpected error '||sqlerrm||
837: ' at AR_Revenue_Adjustment_PVT.earn_or_unearn()+');

Line 839: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

835: IF PG_DEBUG in ('Y', 'C') THEN
836: arp_util.debug('earn_or_unearn: ' || 'Unexpected error '||sqlerrm||
837: ' at AR_Revenue_Adjustment_PVT.earn_or_unearn()+');
838: END IF;
839: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
840: END IF;
841: END earn_or_unearn;
842:
843: -----------------------------------------------------------------------

Line 855: -- Default = FND_API.G_FALSE

851: -- from whom sales credits are being transferred.
852: -- Parameters :
853: -- IN : p_api_version NUMBER Required
854: -- p_init_msg_list VARCHAR2 Optional
855: -- Default = FND_API.G_FALSE
856: -- p_commit VARCHAR2 Optional
857: -- Default = FND_API.G_FALSE
858: -- p_validation_level NUMBER Optional
859: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 857: -- Default = FND_API.G_FALSE

853: -- IN : p_api_version NUMBER Required
854: -- p_init_msg_list VARCHAR2 Optional
855: -- Default = FND_API.G_FALSE
856: -- p_commit VARCHAR2 Optional
857: -- Default = FND_API.G_FALSE
858: -- p_validation_level NUMBER Optional
859: -- Default = FND_API.G_VALID_LEVEL_FULL
860: -- p_rev_adj_rec Rev_Adj_Rec_Type Required
861: -- OUT NOCOPY : x_return_status VARCHAR2(1)

Line 859: -- Default = FND_API.G_VALID_LEVEL_FULL

855: -- Default = FND_API.G_FALSE
856: -- p_commit VARCHAR2 Optional
857: -- Default = FND_API.G_FALSE
858: -- p_validation_level NUMBER Optional
859: -- Default = FND_API.G_VALID_LEVEL_FULL
860: -- p_rev_adj_rec Rev_Adj_Rec_Type Required
861: -- OUT NOCOPY : x_return_status VARCHAR2(1)
862: -- x_msg_count NUMBER
863: -- x_msg_data VARCHAR2(2000)

Line 1214: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

1210: END IF;
1211: -- Standard Start of API savepoint
1212: SAVEPOINT Transfer_Sales_Credits_PVT;
1213: -- Standard call to check for call compatibility.
1214: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
1215: p_api_version ,
1216: l_api_name ,
1217: G_PKG_NAME )
1218: THEN

Line 1223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1219: IF PG_DEBUG in ('Y', 'C') THEN
1220: arp_util.debug('Transfer_Sales_Credits: ' || 'Unexpected error '||sqlerrm||
1221: ' at AR_Revenue_Adjustment_PVT.Transfer_Sales_Credits()+');
1222: END IF;
1223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1224: END IF;
1225: -- Initialize message list if p_init_msg_list is set to TRUE.
1226: IF FND_API.to_Boolean( p_init_msg_list )
1227: THEN

Line 1226: IF FND_API.to_Boolean( p_init_msg_list )

1222: END IF;
1223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1224: END IF;
1225: -- Initialize message list if p_init_msg_list is set to TRUE.
1226: IF FND_API.to_Boolean( p_init_msg_list )
1227: THEN
1228: FND_MSG_PUB.initialize;
1229: END IF;
1230: -- Initialize API return status to success

Line 1231: x_return_status := FND_API.G_RET_STS_SUCCESS;

1227: THEN
1228: FND_MSG_PUB.initialize;
1229: END IF;
1230: -- Initialize API return status to success
1231: x_return_status := FND_API.G_RET_STS_SUCCESS;
1232:
1233: l_rev_adj_rec := p_rev_adj_rec;
1234:
1235: /*Bug 6731185 JVARKEY Making sure GL date has no timestamp*/

Line 1242: AR_RAAPI_UTIL.Validate_Parameters (p_init_msg_list => FND_API.G_FALSE

1238: l_rev_adj_rec.adjustment_type := 'SA';
1239:
1240: AR_RAAPI_UTIL.Constant_System_Values;
1241: AR_RAAPI_UTIL.Initialize_Globals;
1242: AR_RAAPI_UTIL.Validate_Parameters (p_init_msg_list => FND_API.G_FALSE
1243: ,p_rev_adj_rec => l_rev_adj_rec
1244: ,p_validation_level => p_validation_level
1245: ,x_return_status => x_return_status
1246: ,x_msg_count => x_msg_count

Line 1248: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

1244: ,p_validation_level => p_validation_level
1245: ,x_return_status => x_return_status
1246: ,x_msg_count => x_msg_count
1247: ,x_msg_data => x_msg_data);
1248: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1249: THEN
1250: RAISE FND_API.G_EXC_ERROR;
1251: END IF;
1252:

Line 1250: RAISE FND_API.G_EXC_ERROR;

1246: ,x_msg_count => x_msg_count
1247: ,x_msg_data => x_msg_data);
1248: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1249: THEN
1250: RAISE FND_API.G_EXC_ERROR;
1251: END IF;
1252:
1253: --
1254: -- Inner PL/SQL Block to optimize error handling

Line 1290: (p_init_msg_list => FND_API.G_FALSE

1286: --
1287: IF p_rev_adj_rec.sales_credit_type IN ('R','B')
1288: THEN
1289: AR_RAAPI_UTIL.Validate_Amount
1290: (p_init_msg_list => FND_API.G_FALSE
1291: ,p_customer_trx_line_id => AR_RAAPI_UTIL.g_from_cust_trx_line_id
1292: ,p_adjustment_type => 'SA'
1293: ,p_amount_mode => p_rev_adj_rec.amount_mode
1294: ,p_customer_trx_id => AR_RAAPI_UTIL.g_customer_trx_id

Line 1308: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

1304: ,p_line_count_out => l_no_of_lines
1305: ,x_return_status => x_return_status
1306: ,x_msg_count => x_msg_count
1307: ,x_msg_data => x_msg_data);
1308: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1309: THEN
1310: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1311: ELSIF x_return_status = FND_API.G_RET_STS_ERROR
1312: THEN

Line 1310: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1306: ,x_msg_count => x_msg_count
1307: ,x_msg_data => x_msg_data);
1308: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1309: THEN
1310: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1311: ELSIF x_return_status = FND_API.G_RET_STS_ERROR
1312: THEN
1313: RAISE FND_API.G_EXC_ERROR;
1314: END IF;

Line 1311: ELSIF x_return_status = FND_API.G_RET_STS_ERROR

1307: ,x_msg_data => x_msg_data);
1308: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1309: THEN
1310: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1311: ELSIF x_return_status = FND_API.G_RET_STS_ERROR
1312: THEN
1313: RAISE FND_API.G_EXC_ERROR;
1314: END IF;
1315: l_rev_adj_rec.amount := l_revenue_amount;

Line 1313: RAISE FND_API.G_EXC_ERROR;

1309: THEN
1310: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1311: ELSIF x_return_status = FND_API.G_RET_STS_ERROR
1312: THEN
1313: RAISE FND_API.G_EXC_ERROR;
1314: END IF;
1315: l_rev_adj_rec.amount := l_revenue_amount;
1316: /* Bug 2146970 - validate the GL date passed in */
1317: l_gl_date_valid := AR_RAAPI_UTIL.bump_gl_date_if_closed

Line 1323: RAISE FND_API.G_EXC_ERROR;

1319: IF l_gl_date_valid IS NULL
1320: THEN
1321: FND_MESSAGE.set_name('AR','AR_VAL_GL_DATE');
1322: FND_MSG_PUB.Add;
1323: RAISE FND_API.G_EXC_ERROR;
1324: END IF;
1325: END IF;
1326: --
1327: -- Determine non revenue amount to be transferred

Line 1874: RAISE FND_API.G_EXC_ERROR;

1870: arp_global.sysparam.sales_credit_pct_limit);
1871: FND_MESSAGE.set_token('SALESREP_NAME',l_new_salesrep_name);
1872: FND_MESSAGE.set_token('LINE_NUMBER',l_line_number);
1873: FND_MSG_PUB.Add;
1874: RAISE FND_API.G_EXC_ERROR;
1875:
1876: WHEN invalid_amount THEN
1877: IF p_rev_adj_rec.amount_mode = 'P'
1878: THEN

Line 1890: RAISE FND_API.G_EXC_ERROR;

1886: FND_MESSAGE.set_token('TOT_AVAIL_REV',
1887: AR_RAAPI_UTIL.g_trx_currency||' '||l_adj_trx_total);
1888: END IF;
1889: FND_MSG_PUB.Add;
1890: RAISE FND_API.G_EXC_ERROR;
1891: WHEN invalid_zero THEN
1892: FND_MESSAGE.set_name
1893: (application => 'AR', name => 'AR_RA_ZERO_AMOUNT');
1894: FND_MSG_PUB.Add;

Line 1895: RAISE FND_API.G_EXC_ERROR;

1891: WHEN invalid_zero THEN
1892: FND_MESSAGE.set_name
1893: (application => 'AR', name => 'AR_RA_ZERO_AMOUNT');
1894: FND_MSG_PUB.Add;
1895: RAISE FND_API.G_EXC_ERROR;
1896: WHEN invalid_ccid THEN
1897: FND_MSG_PUB.Add;
1898: FND_MESSAGE.SET_NAME(application => 'AR',
1899: name => 'AR_RA_INVALID_CODE_COMB');

Line 1902: RAISE FND_API.G_EXC_ERROR;

1898: FND_MESSAGE.SET_NAME(application => 'AR',
1899: name => 'AR_RA_INVALID_CODE_COMB');
1900: FND_MESSAGE.SET_TOKEN('CODE_COMBINATION',l_concat_segments);
1901: FND_MSG_PUB.Add;
1902: RAISE FND_API.G_EXC_ERROR;
1903: WHEN OTHERS then
1904: IF (SQLCODE = -20001)
1905: THEN
1906: IF PG_DEBUG in ('Y', 'C') THEN

Line 1910: RAISE FND_API.G_EXC_ERROR;

1906: IF PG_DEBUG in ('Y', 'C') THEN
1907: arp_util.debug
1908: ('20001 error at AR_Revenue_Adjustment_PVT.Transfer_Sales_Credits()');
1909: END IF;
1910: RAISE FND_API.G_EXC_ERROR;
1911: ELSE
1912: IF PG_DEBUG in ('Y', 'C') THEN
1913: arp_util.debug('Transfer_Sales_Credits: ' || 'Unexpected error '||sqlerrm||
1914: ' at AR_Revenue_Adjustment_PVT.Transfer_Sales_Credits()+');

Line 1916: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1912: IF PG_DEBUG in ('Y', 'C') THEN
1913: arp_util.debug('Transfer_Sales_Credits: ' || 'Unexpected error '||sqlerrm||
1914: ' at AR_Revenue_Adjustment_PVT.Transfer_Sales_Credits()+');
1915: END IF;
1916: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1917: END IF;
1918: END;
1919: --
1920: -- End of Inner Block

Line 1924: IF FND_API.To_Boolean( p_commit )

1920: -- End of Inner Block
1921: --
1922:
1923: -- Standard check of p_commit.
1924: IF FND_API.To_Boolean( p_commit )
1925: THEN
1926: COMMIT WORK;
1927: END IF;
1928: -- Standard call to get message count and if count is 1, get message info.

Line 1930: (p_encoded => FND_API.G_FALSE,

1926: COMMIT WORK;
1927: END IF;
1928: -- Standard call to get message count and if count is 1, get message info.
1929: FND_MSG_PUB.Count_And_Get
1930: (p_encoded => FND_API.G_FALSE,
1931: p_count => x_msg_count,
1932: p_data => x_msg_data);
1933: IF PG_DEBUG in ('Y', 'C') THEN
1934: arp_util.debug('AR_Revenue_Adjustment_PVT.Transfer_Sales_Credits()-');

Line 1937: WHEN FND_API.G_EXC_ERROR THEN

1933: IF PG_DEBUG in ('Y', 'C') THEN
1934: arp_util.debug('AR_Revenue_Adjustment_PVT.Transfer_Sales_Credits()-');
1935: END IF;
1936: EXCEPTION
1937: WHEN FND_API.G_EXC_ERROR THEN
1938: ROLLBACK TO Transfer_Sales_Credits_PVT;
1939: x_return_status := FND_API.G_RET_STS_ERROR ;
1940: FND_MSG_PUB.Count_And_Get
1941: (p_encoded => FND_API.G_FALSE,

Line 1939: x_return_status := FND_API.G_RET_STS_ERROR ;

1935: END IF;
1936: EXCEPTION
1937: WHEN FND_API.G_EXC_ERROR THEN
1938: ROLLBACK TO Transfer_Sales_Credits_PVT;
1939: x_return_status := FND_API.G_RET_STS_ERROR ;
1940: FND_MSG_PUB.Count_And_Get
1941: (p_encoded => FND_API.G_FALSE,
1942: p_count => x_msg_count,
1943: p_data => x_msg_data);

Line 1941: (p_encoded => FND_API.G_FALSE,

1937: WHEN FND_API.G_EXC_ERROR THEN
1938: ROLLBACK TO Transfer_Sales_Credits_PVT;
1939: x_return_status := FND_API.G_RET_STS_ERROR ;
1940: FND_MSG_PUB.Count_And_Get
1941: (p_encoded => FND_API.G_FALSE,
1942: p_count => x_msg_count,
1943: p_data => x_msg_data);
1944: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1945: IF PG_DEBUG in ('Y', 'C') THEN

Line 1944: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1940: FND_MSG_PUB.Count_And_Get
1941: (p_encoded => FND_API.G_FALSE,
1942: p_count => x_msg_count,
1943: p_data => x_msg_data);
1944: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1945: IF PG_DEBUG in ('Y', 'C') THEN
1946: arp_util.debug('Transfer_Sales_Credits: ' || 'Unexpected error '||sqlerrm||
1947: ' at AR_Revenue_Adjustment_PVT.Transfer_Sales_Credits()+');
1948: END IF;

Line 1950: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1946: arp_util.debug('Transfer_Sales_Credits: ' || 'Unexpected error '||sqlerrm||
1947: ' at AR_Revenue_Adjustment_PVT.Transfer_Sales_Credits()+');
1948: END IF;
1949: ROLLBACK TO Transfer_Sales_Credits_PVT;
1950: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1951: FND_MSG_PUB.Count_And_Get
1952: (p_encoded => FND_API.G_FALSE,
1953: p_count => x_msg_count,
1954: p_data => x_msg_data);

Line 1952: (p_encoded => FND_API.G_FALSE,

1948: END IF;
1949: ROLLBACK TO Transfer_Sales_Credits_PVT;
1950: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1951: FND_MSG_PUB.Count_And_Get
1952: (p_encoded => FND_API.G_FALSE,
1953: p_count => x_msg_count,
1954: p_data => x_msg_data);
1955: WHEN OTHERS THEN
1956: IF (SQLCODE = -20001)

Line 1962: x_return_status := FND_API.G_RET_STS_ERROR ;

1958: IF PG_DEBUG in ('Y', 'C') THEN
1959: arp_util.debug('Transfer_Sales_Credits: ' || '20001 error '||
1960: ' at AR_Revenue_Adjustment_PVT.Transfer_Sales_Credits()+');
1961: END IF;
1962: x_return_status := FND_API.G_RET_STS_ERROR ;
1963: ELSE
1964: IF PG_DEBUG in ('Y', 'C') THEN
1965: arp_util.debug('Transfer_Sales_Credits: ' || 'Unexpected error '||sqlerrm||
1966: ' at AR_Revenue_Adjustment_PVT.Transfer_Sales_Credits()+');

Line 1968: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1964: IF PG_DEBUG in ('Y', 'C') THEN
1965: arp_util.debug('Transfer_Sales_Credits: ' || 'Unexpected error '||sqlerrm||
1966: ' at AR_Revenue_Adjustment_PVT.Transfer_Sales_Credits()+');
1967: END IF;
1968: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1969: IF FND_MSG_PUB.Check_Msg_Level
1970: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1971: THEN
1972: FND_MSG_PUB.Add_Exc_Msg

Line 1980: (p_encoded => FND_API.G_FALSE,

1976: END IF;
1977: END IF;
1978: ROLLBACK TO Transfer_Sales_Credits_PVT;
1979: FND_MSG_PUB.Count_And_Get
1980: (p_encoded => FND_API.G_FALSE,
1981: p_count => x_msg_count,
1982: p_data => x_msg_data);
1983:
1984: END Transfer_Sales_Credits;

Line 1999: -- Default = FND_API.G_FALSE

1995: --
1996: -- Parameters :
1997: -- IN : p_api_version NUMBER Required
1998: -- p_init_msg_list VARCHAR2 Optional
1999: -- Default = FND_API.G_FALSE
2000: -- p_commit VARCHAR2 Optional
2001: -- Default = FND_API.G_FALSE
2002: -- p_validation_level NUMBER Optional
2003: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 2001: -- Default = FND_API.G_FALSE

1997: -- IN : p_api_version NUMBER Required
1998: -- p_init_msg_list VARCHAR2 Optional
1999: -- Default = FND_API.G_FALSE
2000: -- p_commit VARCHAR2 Optional
2001: -- Default = FND_API.G_FALSE
2002: -- p_validation_level NUMBER Optional
2003: -- Default = FND_API.G_VALID_LEVEL_FULL
2004: -- p_rev_adj_rec Rev_Adj_Rec_Type Required
2005: -- OUT NOCOPY : x_return_status VARCHAR2(1)

Line 2003: -- Default = FND_API.G_VALID_LEVEL_FULL

1999: -- Default = FND_API.G_FALSE
2000: -- p_commit VARCHAR2 Optional
2001: -- Default = FND_API.G_FALSE
2002: -- p_validation_level NUMBER Optional
2003: -- Default = FND_API.G_VALID_LEVEL_FULL
2004: -- p_rev_adj_rec Rev_Adj_Rec_Type Required
2005: -- OUT NOCOPY : x_return_status VARCHAR2(1)
2006: -- x_msg_count NUMBER
2007: -- x_msg_data VARCHAR2(2000)

Line 2142: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

2138: END IF;
2139: -- Standard Start of API savepoint
2140: SAVEPOINT Add_Non_Rev_Sales_Credits_PVT;
2141: -- Standard call to check for call compatibility.
2142: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
2143: p_api_version ,
2144: l_api_name ,
2145: G_PKG_NAME )
2146: THEN

Line 2151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2147: IF PG_DEBUG in ('Y', 'C') THEN
2148: arp_util.debug('Add_Non_Revenue_Sales_Credits: ' || 'Unexpected error '||sqlerrm||
2149: ' at AR_Revenue_Adjustment_PVT.Add_Non_Revenue_Sales_Credits()+');
2150: END IF;
2151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2152: END IF;
2153: -- Initialize message list if p_init_msg_list is set to TRUE.
2154: IF FND_API.to_Boolean( p_init_msg_list )
2155: THEN

Line 2154: IF FND_API.to_Boolean( p_init_msg_list )

2150: END IF;
2151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2152: END IF;
2153: -- Initialize message list if p_init_msg_list is set to TRUE.
2154: IF FND_API.to_Boolean( p_init_msg_list )
2155: THEN
2156: FND_MSG_PUB.initialize;
2157: END IF;
2158: -- Initialize API return status to success

Line 2159: x_return_status := FND_API.G_RET_STS_SUCCESS;

2155: THEN
2156: FND_MSG_PUB.initialize;
2157: END IF;
2158: -- Initialize API return status to success
2159: x_return_status := FND_API.G_RET_STS_SUCCESS;
2160:
2161: l_rev_adj_rec := p_rev_adj_rec;
2162:
2163: /*Bug 6731185 JVARKEY Making sure GL date has no timestamp*/

Line 2170: AR_RAAPI_UTIL.Validate_Parameters (p_init_msg_list => FND_API.G_FALSE

2166: l_rev_adj_rec.adjustment_type := 'NR';
2167:
2168: AR_RAAPI_UTIL.Constant_System_Values;
2169: AR_RAAPI_UTIL.Initialize_Globals;
2170: AR_RAAPI_UTIL.Validate_Parameters (p_init_msg_list => FND_API.G_FALSE
2171: ,p_rev_adj_rec => l_rev_adj_rec
2172: ,p_validation_level => p_validation_level
2173: ,x_return_status => x_return_status
2174: ,x_msg_count => x_msg_count

Line 2176: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

2172: ,p_validation_level => p_validation_level
2173: ,x_return_status => x_return_status
2174: ,x_msg_count => x_msg_count
2175: ,x_msg_data => x_msg_data);
2176: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
2177: THEN
2178: RAISE FND_API.G_EXC_ERROR;
2179: END IF;
2180:

Line 2178: RAISE FND_API.G_EXC_ERROR;

2174: ,x_msg_count => x_msg_count
2175: ,x_msg_data => x_msg_data);
2176: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
2177: THEN
2178: RAISE FND_API.G_EXC_ERROR;
2179: END IF;
2180:
2181: --
2182: -- Inner PL/SQL block to ensure consistent error handling

Line 2309: RAISE FND_API.G_EXC_ERROR;

2305: arp_global.sysparam.sales_credit_pct_limit);
2306: FND_MESSAGE.set_token('SALESREP_NAME',l_new_salesrep_name);
2307: FND_MESSAGE.set_token('LINE_NUMBER',l_line_number);
2308: FND_MSG_PUB.Add;
2309: RAISE FND_API.G_EXC_ERROR;
2310: WHEN invalid_amount THEN
2311: FND_MESSAGE.SET_NAME
2312: (application => 'AR', name => 'AR_RA_AMT_EXCEEDS_AVAIL_REV');
2313: FND_MESSAGE.set_token('TOT_AVAIL_REV',

Line 2316: RAISE FND_API.G_EXC_ERROR;

2312: (application => 'AR', name => 'AR_RA_AMT_EXCEEDS_AVAIL_REV');
2313: FND_MESSAGE.set_token('TOT_AVAIL_REV',
2314: AR_RAAPI_UTIL.g_trx_currency||' '||'0');
2315: FND_MSG_PUB.Add;
2316: RAISE FND_API.G_EXC_ERROR;
2317: WHEN OTHERS then
2318: IF (SQLCODE = -20001)
2319: THEN
2320: IF PG_DEBUG in ('Y', 'C') THEN

Line 2324: RAISE FND_API.G_EXC_ERROR;

2320: IF PG_DEBUG in ('Y', 'C') THEN
2321: arp_util.debug
2322: ('20001 error at AR_Revenue_Adjustment_PVT.Add_Non_Revenue_Sales_Credits()');
2323: END IF;
2324: RAISE FND_API.G_EXC_ERROR;
2325: ELSE
2326: IF PG_DEBUG in ('Y', 'C') THEN
2327: arp_util.debug('Add_Non_Revenue_Sales_Credits: ' || 'Unexpected error '||sqlerrm||
2328: ' at AR_Revenue_Adjustment_PVT.Add_Non_Revenue_Sales_Credits()+');

Line 2330: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2326: IF PG_DEBUG in ('Y', 'C') THEN
2327: arp_util.debug('Add_Non_Revenue_Sales_Credits: ' || 'Unexpected error '||sqlerrm||
2328: ' at AR_Revenue_Adjustment_PVT.Add_Non_Revenue_Sales_Credits()+');
2329: END IF;
2330: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2331: END IF;
2332:
2333: END;
2334: --

Line 2339: IF FND_API.To_Boolean( p_commit )

2335: -- End of Inner Block
2336: --
2337:
2338: -- Standard check of p_commit.
2339: IF FND_API.To_Boolean( p_commit )
2340: THEN
2341: COMMIT WORK;
2342: END IF;
2343: -- Standard call to get message count and if count is 1, get message info.

Line 2345: (p_encoded => FND_API.G_FALSE,

2341: COMMIT WORK;
2342: END IF;
2343: -- Standard call to get message count and if count is 1, get message info.
2344: FND_MSG_PUB.Count_And_Get
2345: (p_encoded => FND_API.G_FALSE,
2346: p_count => x_msg_count,
2347: p_data => x_msg_data);
2348: IF PG_DEBUG in ('Y', 'C') THEN
2349: arp_util.debug('AR_Revenue_Adjustment_PVT.Add_Non_Revenue_Sales_Credits()-');

Line 2352: WHEN FND_API.G_EXC_ERROR THEN

2348: IF PG_DEBUG in ('Y', 'C') THEN
2349: arp_util.debug('AR_Revenue_Adjustment_PVT.Add_Non_Revenue_Sales_Credits()-');
2350: END IF;
2351: EXCEPTION
2352: WHEN FND_API.G_EXC_ERROR THEN
2353: ROLLBACK TO Add_Non_Rev_Sales_Credits_PVT;
2354: x_return_status := FND_API.G_RET_STS_ERROR ;
2355: FND_MSG_PUB.Count_And_Get
2356: (p_encoded => FND_API.G_FALSE,

Line 2354: x_return_status := FND_API.G_RET_STS_ERROR ;

2350: END IF;
2351: EXCEPTION
2352: WHEN FND_API.G_EXC_ERROR THEN
2353: ROLLBACK TO Add_Non_Rev_Sales_Credits_PVT;
2354: x_return_status := FND_API.G_RET_STS_ERROR ;
2355: FND_MSG_PUB.Count_And_Get
2356: (p_encoded => FND_API.G_FALSE,
2357: p_count => x_msg_count,
2358: p_data => x_msg_data);

Line 2356: (p_encoded => FND_API.G_FALSE,

2352: WHEN FND_API.G_EXC_ERROR THEN
2353: ROLLBACK TO Add_Non_Rev_Sales_Credits_PVT;
2354: x_return_status := FND_API.G_RET_STS_ERROR ;
2355: FND_MSG_PUB.Count_And_Get
2356: (p_encoded => FND_API.G_FALSE,
2357: p_count => x_msg_count,
2358: p_data => x_msg_data);
2359: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2360: IF PG_DEBUG in ('Y', 'C') THEN

Line 2359: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2355: FND_MSG_PUB.Count_And_Get
2356: (p_encoded => FND_API.G_FALSE,
2357: p_count => x_msg_count,
2358: p_data => x_msg_data);
2359: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2360: IF PG_DEBUG in ('Y', 'C') THEN
2361: arp_util.debug('Add_Non_Revenue_Sales_Credits: ' || 'Unexpected error '||sqlerrm||
2362: ' at AR_Revenue_Adjustment_PVT.Add_Non_Revenue_Sales_Credits()+');
2363: END IF;

Line 2365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2361: arp_util.debug('Add_Non_Revenue_Sales_Credits: ' || 'Unexpected error '||sqlerrm||
2362: ' at AR_Revenue_Adjustment_PVT.Add_Non_Revenue_Sales_Credits()+');
2363: END IF;
2364: ROLLBACK TO Add_Non_Rev_Sales_Credits_PVT;
2365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2366: FND_MSG_PUB.Count_And_Get
2367: (p_encoded => FND_API.G_FALSE,
2368: p_count => x_msg_count,
2369: p_data => x_msg_data);

Line 2367: (p_encoded => FND_API.G_FALSE,

2363: END IF;
2364: ROLLBACK TO Add_Non_Rev_Sales_Credits_PVT;
2365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2366: FND_MSG_PUB.Count_And_Get
2367: (p_encoded => FND_API.G_FALSE,
2368: p_count => x_msg_count,
2369: p_data => x_msg_data);
2370: WHEN OTHERS THEN
2371: IF (SQLCODE = -20001)

Line 2377: x_return_status := FND_API.G_RET_STS_ERROR ;

2373: IF PG_DEBUG in ('Y', 'C') THEN
2374: arp_util.debug('Add_Non_Revenue_Sales_Credits: ' || '20001 error '||
2375: ' at AR_Revenue_Adjustment_PVT.Add_Non_Revenue_Sales_Credits()+');
2376: END IF;
2377: x_return_status := FND_API.G_RET_STS_ERROR ;
2378: ELSE
2379: IF PG_DEBUG in ('Y', 'C') THEN
2380: arp_util.debug('Add_Non_Revenue_Sales_Credits: ' || 'Unexpected error '||sqlerrm||
2381: ' at AR_Revenue_Adjustment_PVT.Add_Non_Revenue_Sales_Credits()+');

Line 2383: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2379: IF PG_DEBUG in ('Y', 'C') THEN
2380: arp_util.debug('Add_Non_Revenue_Sales_Credits: ' || 'Unexpected error '||sqlerrm||
2381: ' at AR_Revenue_Adjustment_PVT.Add_Non_Revenue_Sales_Credits()+');
2382: END IF;
2383: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2384: IF FND_MSG_PUB.Check_Msg_Level
2385: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2386: THEN
2387: FND_MSG_PUB.Add_Exc_Msg

Line 2395: (p_encoded => FND_API.G_FALSE,

2391: END IF;
2392: END IF;
2393: ROLLBACK TO Add_Non_Rev_Sales_Credits_PVT;
2394: FND_MSG_PUB.Count_And_Get
2395: (p_encoded => FND_API.G_FALSE,
2396: p_count => x_msg_count,
2397: p_data => x_msg_data);
2398: END Add_Non_Revenue_Sales_Credits;
2399:

Line 2619: RAISE FND_API.G_EXC_ERROR;

2615: IF l_gl_date_valid IS NULL
2616: THEN
2617: FND_MESSAGE.set_name('AR','AR_RA_NO_OPEN_PERIODS');
2618: FND_MSG_PUB.Add;
2619: RAISE FND_API.G_EXC_ERROR;
2620: ELSE
2621: l_gl_date := l_gl_date_valid;
2622: END IF;
2623:

Line 2669: RAISE FND_API.G_EXC_ERROR;

2665: IF PG_DEBUG in ('Y', 'C') THEN
2666: arp_util.debug
2667: ('20001 error at AR_Revenue_Adjustment_PVT.transfer_salesrep_revenue()');
2668: END IF;
2669: RAISE FND_API.G_EXC_ERROR;
2670: ELSE
2671: IF PG_DEBUG in ('Y', 'C') THEN
2672: arp_util.debug('transfer_salesrep_revenue: ' || 'Unexpected error '||sqlerrm||
2673: ' at AR_Revenue_Adjustment_PVT.transfer_salesrep_revenue()+');

Line 2675: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2671: IF PG_DEBUG in ('Y', 'C') THEN
2672: arp_util.debug('transfer_salesrep_revenue: ' || 'Unexpected error '||sqlerrm||
2673: ' at AR_Revenue_Adjustment_PVT.transfer_salesrep_revenue()+');
2674: END IF;
2675: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2676: END IF;
2677:
2678: END transfer_salesrep_revenue;
2679:

Line 3235: RAISE FND_API.G_EXC_ERROR;

3231: IF l_gl_date_valid IS NULL
3232: THEN
3233: FND_MESSAGE.set_name('AR','AR_RA_NO_OPEN_PERIODS');
3234: FND_MSG_PUB.Add;
3235: RAISE FND_API.G_EXC_ERROR;
3236: END IF;
3237:
3238: --
3239: -- Step 1: Debit earned revenue account

Line 3285: RAISE FND_API.G_EXC_ERROR;

3281: FND_MESSAGE.SET_NAME(application => 'AR',
3282: name => 'AR_RA_NO_REV_SALES_CREDIT');
3283: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_number);
3284: FND_MSG_PUB.Add;
3285: RAISE FND_API.G_EXC_ERROR;
3286: WHEN invalid_ccid THEN
3287: FND_MSG_PUB.Add;
3288: FND_MESSAGE.SET_NAME(application => 'AR',
3289: name => 'AR_RA_INVALID_CODE_COMB');

Line 3292: RAISE FND_API.G_EXC_ERROR;

3288: FND_MESSAGE.SET_NAME(application => 'AR',
3289: name => 'AR_RA_INVALID_CODE_COMB');
3290: FND_MESSAGE.SET_TOKEN('CODE_COMBINATION',l_concat_segments);
3291: FND_MSG_PUB.Add;
3292: RAISE FND_API.G_EXC_ERROR;
3293: WHEN OTHERS then
3294: IF (SQLCODE = -20001)
3295: THEN
3296: IF PG_DEBUG in ('Y', 'C') THEN

Line 3300: RAISE FND_API.G_EXC_ERROR;

3296: IF PG_DEBUG in ('Y', 'C') THEN
3297: arp_util.debug
3298: ('20001 error at AR_Revenue_Adjustment_PVT.debit_credit()');
3299: END IF;
3300: RAISE FND_API.G_EXC_ERROR;
3301: ELSE
3302: IF PG_DEBUG in ('Y', 'C') THEN
3303: arp_util.debug('debit_credit: ' || 'Unexpected error '||sqlerrm||
3304: ' at AR_Revenue_Adjustment_PVT.debit_credit()+');

Line 3306: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3302: IF PG_DEBUG in ('Y', 'C') THEN
3303: arp_util.debug('debit_credit: ' || 'Unexpected error '||sqlerrm||
3304: ' at AR_Revenue_Adjustment_PVT.debit_credit()+');
3305: END IF;
3306: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3307: END IF;
3308:
3309: END debit_credit;
3310:

Line 3627: RAISE FND_API.G_EXC_ERROR;

3623: FND_MESSAGE.SET_NAME(application => 'AR',
3624: name => 'AR_RA_NO_REV_SALES_CREDIT');
3625: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_number);
3626: FND_MSG_PUB.Add;
3627: RAISE FND_API.G_EXC_ERROR;
3628: WHEN invalid_ccid THEN
3629: FND_MSG_PUB.Add;
3630: FND_MESSAGE.SET_NAME(application => 'AR',
3631: name => 'AR_RA_INVALID_CODE_COMB');

Line 3634: RAISE FND_API.G_EXC_ERROR;

3630: FND_MESSAGE.SET_NAME(application => 'AR',
3631: name => 'AR_RA_INVALID_CODE_COMB');
3632: FND_MESSAGE.SET_TOKEN('CODE_COMBINATION',l_concat_segments);
3633: FND_MSG_PUB.Add;
3634: RAISE FND_API.G_EXC_ERROR;
3635: WHEN OTHERS then
3636: IF (SQLCODE = -20001)
3637: THEN
3638: IF PG_DEBUG in ('Y', 'C') THEN

Line 3642: RAISE FND_API.G_EXC_ERROR;

3638: IF PG_DEBUG in ('Y', 'C') THEN
3639: arp_util.debug
3640: ('20001 error at AR_Revenue_Adjustment_PVT.no_rule_debit_credit()');
3641: END IF;
3642: RAISE FND_API.G_EXC_ERROR;
3643: ELSE
3644: IF PG_DEBUG in ('Y', 'C') THEN
3645: arp_util.debug('no_rule_debit_credit: ' || 'Unexpected error '||sqlerrm||
3646: ' at AR_Revenue_Adjustment_PVT.no_rule_debit_credit()+');

Line 3648: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3644: IF PG_DEBUG in ('Y', 'C') THEN
3645: arp_util.debug('no_rule_debit_credit: ' || 'Unexpected error '||sqlerrm||
3646: ' at AR_Revenue_Adjustment_PVT.no_rule_debit_credit()+');
3647: END IF;
3648: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3649: END IF;
3650:
3651: END no_rule_debit_credit;
3652:

Line 3896: RAISE FND_API.G_EXC_ERROR;

3892: FND_MESSAGE.SET_NAME(application => 'AR',
3893: name => 'AR_RA_INVALID_CODE_COMB');
3894: FND_MESSAGE.SET_TOKEN('CODE_COMBINATION',l_concat_segments);
3895: FND_MSG_PUB.Add;
3896: RAISE FND_API.G_EXC_ERROR;
3897: WHEN OTHERS then
3898: IF (SQLCODE = -20001)
3899: THEN
3900: IF PG_DEBUG in ('Y', 'C') THEN

Line 3904: RAISE FND_API.G_EXC_ERROR;

3900: IF PG_DEBUG in ('Y', 'C') THEN
3901: arp_util.debug
3902: ('20001 error at AR_Revenue_Adjustment_PVT.no_rule_debit_credit_no_sr()');
3903: END IF;
3904: RAISE FND_API.G_EXC_ERROR;
3905: ELSE
3906: IF PG_DEBUG in ('Y', 'C') THEN
3907: arp_util.debug('no_rule_debit_credit_no_sr: ' || 'Unexpected error '||sqlerrm||
3908: ' at AR_Revenue_Adjustment_PVT.no_rule_debit_credit()+');

Line 3910: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3906: IF PG_DEBUG in ('Y', 'C') THEN
3907: arp_util.debug('no_rule_debit_credit_no_sr: ' || 'Unexpected error '||sqlerrm||
3908: ' at AR_Revenue_Adjustment_PVT.no_rule_debit_credit()+');
3909: END IF;
3910: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3911: END IF;
3912:
3913: END no_rule_debit_credit_no_sr;
3914:

Line 3925: -- Default = FND_API.G_FALSE

3921: -- Pre-reqs : Sufficient earned revenue must exist.
3922: -- Parameters :
3923: -- IN : p_api_version NUMBER Required
3924: -- p_init_msg_list VARCHAR2 Optional
3925: -- Default = FND_API.G_FALSE
3926: -- p_commit VARCHAR2 Optional
3927: -- Default = FND_API.G_FALSE
3928: -- p_validation_level NUMBER Optional
3929: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 3927: -- Default = FND_API.G_FALSE

3923: -- IN : p_api_version NUMBER Required
3924: -- p_init_msg_list VARCHAR2 Optional
3925: -- Default = FND_API.G_FALSE
3926: -- p_commit VARCHAR2 Optional
3927: -- Default = FND_API.G_FALSE
3928: -- p_validation_level NUMBER Optional
3929: -- Default = FND_API.G_VALID_LEVEL_FULL
3930: -- p_rev_adj_rec Rev_Adj_Rec_Type Required
3931: -- OUT NOCOPY : x_return_status VARCHAR2(1)

Line 3929: -- Default = FND_API.G_VALID_LEVEL_FULL

3925: -- Default = FND_API.G_FALSE
3926: -- p_commit VARCHAR2 Optional
3927: -- Default = FND_API.G_FALSE
3928: -- p_validation_level NUMBER Optional
3929: -- Default = FND_API.G_VALID_LEVEL_FULL
3930: -- p_rev_adj_rec Rev_Adj_Rec_Type Required
3931: -- OUT NOCOPY : x_return_status VARCHAR2(1)
3932: -- x_msg_count NUMBER
3933: -- x_msg_data VARCHAR2(2000)

Line 4160: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

4156: END IF;
4157: -- Standard Start of API savepoint
4158: SAVEPOINT Transfer_Rev_Between_Lines_PVT;
4159: -- Standard call to check for call compatibility.
4160: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
4161: p_api_version ,
4162: l_api_name ,
4163: G_PKG_NAME )
4164: THEN

Line 4169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4165: IF PG_DEBUG in ('Y', 'C') THEN
4166: arp_util.debug('Transfer_Revenue_Between_Lines: ' || 'Unexpected error '||sqlerrm||
4167: ' at AR_Revenue_Adjustment_PVT.Transfer_Revenue_Between_Lines()+');
4168: END IF;
4169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4170: END IF;
4171: -- Initialize message list if p_init_msg_list is set to TRUE.
4172: IF FND_API.to_Boolean( p_init_msg_list )
4173: THEN

Line 4172: IF FND_API.to_Boolean( p_init_msg_list )

4168: END IF;
4169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4170: END IF;
4171: -- Initialize message list if p_init_msg_list is set to TRUE.
4172: IF FND_API.to_Boolean( p_init_msg_list )
4173: THEN
4174: FND_MSG_PUB.initialize;
4175: END IF;
4176: -- Initialize API return status to success

Line 4177: x_return_status := FND_API.G_RET_STS_SUCCESS;

4173: THEN
4174: FND_MSG_PUB.initialize;
4175: END IF;
4176: -- Initialize API return status to success
4177: x_return_status := FND_API.G_RET_STS_SUCCESS;
4178:
4179: BEGIN
4180: IF PG_DEBUG in ('Y', 'C') THEN
4181: arp_util.debug('AR_Revenue_Adjustment_PVT.Transfer_Revenue_Between_Lines(2)+');

Line 4193: AR_RAAPI_UTIL.Validate_Parameters (p_init_msg_list => FND_API.G_FALSE

4189: l_rev_adj_rec.adjustment_type := 'LL';
4190:
4191: AR_RAAPI_UTIL.Constant_System_Values;
4192: AR_RAAPI_UTIL.Initialize_Globals;
4193: AR_RAAPI_UTIL.Validate_Parameters (p_init_msg_list => FND_API.G_FALSE
4194: ,p_rev_adj_rec => l_rev_adj_rec
4195: ,p_validation_level => p_validation_level
4196: ,x_return_status => x_return_status
4197: ,x_msg_count => x_msg_count

Line 4199: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

4195: ,p_validation_level => p_validation_level
4196: ,x_return_status => x_return_status
4197: ,x_msg_count => x_msg_count
4198: ,x_msg_data => x_msg_data);
4199: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
4200: THEN
4201: RAISE FND_API.G_EXC_ERROR;
4202: END IF;
4203:

Line 4201: RAISE FND_API.G_EXC_ERROR;

4197: ,x_msg_count => x_msg_count
4198: ,x_msg_data => x_msg_data);
4199: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
4200: THEN
4201: RAISE FND_API.G_EXC_ERROR;
4202: END IF;
4203:
4204: IF NVL(AR_RAAPI_UTIL.g_from_cust_trx_line_id,-100) =
4205: NVL(AR_RAAPI_UTIL.g_to_cust_trx_line_id,-200)

Line 4240: (p_init_msg_list => FND_API.G_FALSE

4236: FETCH c_lines_from_total INTO l_lines_from_total;
4237: CLOSE c_lines_from_total;
4238:
4239: AR_RAAPI_UTIL.Validate_Amount
4240: (p_init_msg_list => FND_API.G_FALSE
4241: ,p_customer_trx_line_id => AR_RAAPI_UTIL.g_from_cust_trx_line_id
4242: ,p_adjustment_type => 'LL'
4243: ,p_amount_mode => p_rev_adj_rec.amount_mode
4244: ,p_customer_trx_id => AR_RAAPI_UTIL.g_customer_trx_id

Line 4258: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

4254: ,p_line_count_out => l_no_of_lines_from
4255: ,x_return_status => x_return_status
4256: ,x_msg_count => x_msg_count
4257: ,x_msg_data => x_msg_data);
4258: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
4259: THEN
4260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4261: ELSIF x_return_status = FND_API.G_RET_STS_ERROR
4262: THEN

Line 4260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4256: ,x_msg_count => x_msg_count
4257: ,x_msg_data => x_msg_data);
4258: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
4259: THEN
4260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4261: ELSIF x_return_status = FND_API.G_RET_STS_ERROR
4262: THEN
4263: RAISE FND_API.G_EXC_ERROR;
4264: END IF;

Line 4261: ELSIF x_return_status = FND_API.G_RET_STS_ERROR

4257: ,x_msg_data => x_msg_data);
4258: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
4259: THEN
4260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4261: ELSIF x_return_status = FND_API.G_RET_STS_ERROR
4262: THEN
4263: RAISE FND_API.G_EXC_ERROR;
4264: END IF;
4265: l_rev_adj_rec.amount := l_revenue_amount;

Line 4263: RAISE FND_API.G_EXC_ERROR;

4259: THEN
4260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4261: ELSIF x_return_status = FND_API.G_RET_STS_ERROR
4262: THEN
4263: RAISE FND_API.G_EXC_ERROR;
4264: END IF;
4265: l_rev_adj_rec.amount := l_revenue_amount;
4266:
4267: OPEN c_lines_to_total;

Line 4408: RAISE FND_API.G_EXC_ERROR;

4404:
4405: EXCEPTION
4406: WHEN invalid_same_lines THEN
4407: FND_MSG_PUB.Add;
4408: RAISE FND_API.G_EXC_ERROR;
4409: WHEN invalid_lines THEN
4410: FND_MESSAGE.SET_NAME (application => 'AR',
4411: name => 'AR_RA_NO_TSFR_LINES_AVAIL');
4412: FND_MSG_PUB.Add;

Line 4413: RAISE FND_API.G_EXC_ERROR;

4409: WHEN invalid_lines THEN
4410: FND_MESSAGE.SET_NAME (application => 'AR',
4411: name => 'AR_RA_NO_TSFR_LINES_AVAIL');
4412: FND_MSG_PUB.Add;
4413: RAISE FND_API.G_EXC_ERROR;
4414: WHEN invalid_tax THEN
4415: FND_MESSAGE.SET_NAME (application => 'AR',
4416: name => 'AR_RA_TAX_TREATMENTS_VARY');
4417: FND_MSG_PUB.Add;

Line 4418: RAISE FND_API.G_EXC_ERROR;

4414: WHEN invalid_tax THEN
4415: FND_MESSAGE.SET_NAME (application => 'AR',
4416: name => 'AR_RA_TAX_TREATMENTS_VARY');
4417: FND_MSG_PUB.Add;
4418: RAISE FND_API.G_EXC_ERROR;
4419: WHEN OTHERS then
4420: IF (SQLCODE = -20001)
4421: THEN
4422: IF PG_DEBUG in ('Y', 'C') THEN

Line 4426: RAISE FND_API.G_EXC_ERROR;

4422: IF PG_DEBUG in ('Y', 'C') THEN
4423: arp_util.debug
4424: ('20001 error at AR_Revenue_Adjustment_PVT.Transfer_Revenue_Between_Lines()');
4425: END IF;
4426: RAISE FND_API.G_EXC_ERROR;
4427: ELSE
4428: IF PG_DEBUG in ('Y', 'C') THEN
4429: arp_util.debug('Transfer_Revenue_Between_Lines: ' || 'Unexpected error '||sqlerrm||
4430: ' at AR_Revenue_Adjustment_PVT.Transfer_Revenue_Between_Lines()+');

Line 4432: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4428: IF PG_DEBUG in ('Y', 'C') THEN
4429: arp_util.debug('Transfer_Revenue_Between_Lines: ' || 'Unexpected error '||sqlerrm||
4430: ' at AR_Revenue_Adjustment_PVT.Transfer_Revenue_Between_Lines()+');
4431: END IF;
4432: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4433: END IF;
4434: END;
4435: --
4436: -- End of Inner Block

Line 4440: IF FND_API.To_Boolean( p_commit )

4436: -- End of Inner Block
4437: --
4438:
4439: -- Standard check of p_commit.
4440: IF FND_API.To_Boolean( p_commit )
4441: THEN
4442: COMMIT WORK;
4443: END IF;
4444: -- Standard call to get message count and if count is 1, get message info.

Line 4446: (p_encoded => FND_API.G_FALSE,

4442: COMMIT WORK;
4443: END IF;
4444: -- Standard call to get message count and if count is 1, get message info.
4445: FND_MSG_PUB.Count_And_Get
4446: (p_encoded => FND_API.G_FALSE,
4447: p_count => x_msg_count,
4448: p_data => x_msg_data);
4449: IF PG_DEBUG in ('Y', 'C') THEN
4450: arp_util.debug('AR_Revenue_Adjustment_PVT.Transfer_Revenue_Between_Lines()-');

Line 4453: WHEN FND_API.G_EXC_ERROR THEN

4449: IF PG_DEBUG in ('Y', 'C') THEN
4450: arp_util.debug('AR_Revenue_Adjustment_PVT.Transfer_Revenue_Between_Lines()-');
4451: END IF;
4452: EXCEPTION
4453: WHEN FND_API.G_EXC_ERROR THEN
4454: ROLLBACK TO Transfer_Rev_Between_Lines_PVT;
4455: x_return_status := FND_API.G_RET_STS_ERROR ;
4456: FND_MSG_PUB.Count_And_Get
4457: (p_encoded => FND_API.G_FALSE,

Line 4455: x_return_status := FND_API.G_RET_STS_ERROR ;

4451: END IF;
4452: EXCEPTION
4453: WHEN FND_API.G_EXC_ERROR THEN
4454: ROLLBACK TO Transfer_Rev_Between_Lines_PVT;
4455: x_return_status := FND_API.G_RET_STS_ERROR ;
4456: FND_MSG_PUB.Count_And_Get
4457: (p_encoded => FND_API.G_FALSE,
4458: p_count => x_msg_count,
4459: p_data => x_msg_data);

Line 4457: (p_encoded => FND_API.G_FALSE,

4453: WHEN FND_API.G_EXC_ERROR THEN
4454: ROLLBACK TO Transfer_Rev_Between_Lines_PVT;
4455: x_return_status := FND_API.G_RET_STS_ERROR ;
4456: FND_MSG_PUB.Count_And_Get
4457: (p_encoded => FND_API.G_FALSE,
4458: p_count => x_msg_count,
4459: p_data => x_msg_data);
4460: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4461: IF PG_DEBUG in ('Y', 'C') THEN

Line 4460: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4456: FND_MSG_PUB.Count_And_Get
4457: (p_encoded => FND_API.G_FALSE,
4458: p_count => x_msg_count,
4459: p_data => x_msg_data);
4460: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4461: IF PG_DEBUG in ('Y', 'C') THEN
4462: arp_util.debug('Transfer_Revenue_Between_Lines: ' || 'Unexpected error '||sqlerrm||
4463: ' at AR_Revenue_Adjustment_PVT.Transfer_Revenue_Between_Lines()+');
4464: END IF;

Line 4466: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4462: arp_util.debug('Transfer_Revenue_Between_Lines: ' || 'Unexpected error '||sqlerrm||
4463: ' at AR_Revenue_Adjustment_PVT.Transfer_Revenue_Between_Lines()+');
4464: END IF;
4465: ROLLBACK TO Transfer_Rev_Between_Lines_PVT;
4466: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4467: FND_MSG_PUB.Count_And_Get
4468: (p_encoded => FND_API.G_FALSE,
4469: p_count => x_msg_count,
4470: p_data => x_msg_data);

Line 4468: (p_encoded => FND_API.G_FALSE,

4464: END IF;
4465: ROLLBACK TO Transfer_Rev_Between_Lines_PVT;
4466: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4467: FND_MSG_PUB.Count_And_Get
4468: (p_encoded => FND_API.G_FALSE,
4469: p_count => x_msg_count,
4470: p_data => x_msg_data);
4471: WHEN OTHERS THEN
4472: IF (SQLCODE = -20001)

Line 4478: x_return_status := FND_API.G_RET_STS_ERROR ;

4474: IF PG_DEBUG in ('Y', 'C') THEN
4475: arp_util.debug('Transfer_Revenue_Between_Lines: ' || '20001 error '||
4476: ' at AR_Revenue_Adjustment_PVT.Transfer_Revenue_Between_Lines()+');
4477: END IF;
4478: x_return_status := FND_API.G_RET_STS_ERROR ;
4479: ELSE
4480: IF PG_DEBUG in ('Y', 'C') THEN
4481: arp_util.debug('Transfer_Revenue_Between_Lines: ' || 'Unexpected error '||sqlerrm||
4482: ' at AR_Revenue_Adjustment_PVT.Transfer_Revenue_Between_Lines()+');

Line 4484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4480: IF PG_DEBUG in ('Y', 'C') THEN
4481: arp_util.debug('Transfer_Revenue_Between_Lines: ' || 'Unexpected error '||sqlerrm||
4482: ' at AR_Revenue_Adjustment_PVT.Transfer_Revenue_Between_Lines()+');
4483: END IF;
4484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4485: IF FND_MSG_PUB.Check_Msg_Level
4486: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4487: THEN
4488: FND_MSG_PUB.Add_Exc_Msg

Line 4496: (p_encoded => FND_API.G_FALSE,

4492: END IF;
4493: END IF;
4494: ROLLBACK TO Transfer_Rev_Between_Lines_PVT;
4495: FND_MSG_PUB.Count_And_Get
4496: (p_encoded => FND_API.G_FALSE,
4497: p_count => x_msg_count,
4498: p_data => x_msg_data);
4499:
4500: END Transfer_Revenue_Between_Lines;

Line 4569: RAISE FND_API.G_EXC_ERROR;

4565: IF PG_DEBUG in ('Y', 'C') THEN
4566: arp_util.debug
4567: ('20001 error at AR_Revenue_Adjustment_PVT.reset_dist_percent()');
4568: END IF;
4569: RAISE FND_API.G_EXC_ERROR;
4570: ELSE
4571: IF PG_DEBUG in ('Y', 'C') THEN
4572: arp_util.debug('reset_dist_percent: ' || 'Unexpected error '||sqlerrm||
4573: ' at AR_Revenue_Adjustment_PVT.reset_dist_percent()+');

Line 4575: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4571: IF PG_DEBUG in ('Y', 'C') THEN
4572: arp_util.debug('reset_dist_percent: ' || 'Unexpected error '||sqlerrm||
4573: ' at AR_Revenue_Adjustment_PVT.reset_dist_percent()+');
4574: END IF;
4575: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4576: END IF;
4577: END reset_dist_percent;
4578:
4579: PROCEDURE create_adjustment

Line 4713: RAISE FND_API.G_EXC_ERROR;

4709: IF PG_DEBUG in ('Y', 'C') THEN
4710: arp_util.debug
4711: ('20001 error at AR_Revenue_Adjustment_PVT.create_adjustment()');
4712: END IF;
4713: RAISE FND_API.G_EXC_ERROR;
4714: ELSE
4715: IF PG_DEBUG in ('Y', 'C') THEN
4716: arp_util.debug('create_adjustment: ' || 'Unexpected error '||sqlerrm||
4717: ' at AR_Revenue_Adjustment_PVT.create_adjustment()+');

Line 4719: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4715: IF PG_DEBUG in ('Y', 'C') THEN
4716: arp_util.debug('create_adjustment: ' || 'Unexpected error '||sqlerrm||
4717: ' at AR_Revenue_Adjustment_PVT.create_adjustment()+');
4718: END IF;
4719: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4720: END IF;
4721: END create_adjustment;
4722:
4723: PROCEDURE cr_target_line_unearned

Line 4913: RAISE FND_API.G_EXC_ERROR;

4909: FND_MESSAGE.SET_NAME(application => 'AR',
4910: name => 'AR_RA_INVALID_CODE_COMB');
4911: FND_MESSAGE.SET_TOKEN('CODE_COMBINATION',l_concat_segments);
4912: FND_MSG_PUB.Add;
4913: RAISE FND_API.G_EXC_ERROR;
4914: WHEN OTHERS THEN
4915: IF (SQLCODE = -20001)
4916: THEN
4917: IF PG_DEBUG in ('Y', 'C') THEN

Line 4921: RAISE FND_API.G_EXC_ERROR;

4917: IF PG_DEBUG in ('Y', 'C') THEN
4918: arp_util.debug
4919: ('20001 error at AR_Revenue_Adjustment_PVT.cr_target_line_unearned()');
4920: END IF;
4921: RAISE FND_API.G_EXC_ERROR;
4922: ELSE
4923: IF PG_DEBUG in ('Y', 'C') THEN
4924: arp_util.debug('cr_target_line_unearned: ' || 'Unexpected error '||sqlerrm||
4925: ' at AR_Revenue_Adjustment_PVT.cr_target_line_unearned()+');

Line 4927: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4923: IF PG_DEBUG in ('Y', 'C') THEN
4924: arp_util.debug('cr_target_line_unearned: ' || 'Unexpected error '||sqlerrm||
4925: ' at AR_Revenue_Adjustment_PVT.cr_target_line_unearned()+');
4926: END IF;
4927: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4928: END IF;
4929:
4930: END cr_target_line_unearned;
4931:

Line 5347: RAISE FND_API.G_EXC_ERROR;

5343: FND_MESSAGE.SET_NAME(application => 'AR',
5344: name => 'AR_RA_INVALID_CODE_COMB');
5345: FND_MESSAGE.SET_TOKEN('CODE_COMBINATION',l_concat_segments);
5346: FND_MSG_PUB.Add;
5347: RAISE FND_API.G_EXC_ERROR;
5348: WHEN OTHERS THEN
5349: IF (SQLCODE = -20001)
5350: THEN
5351: IF PG_DEBUG in ('Y', 'C') THEN

Line 5355: RAISE FND_API.G_EXC_ERROR;

5351: IF PG_DEBUG in ('Y', 'C') THEN
5352: arp_util.debug
5353: ('20001 error at AR_Revenue_Adjustment_PVT.insert_sales_credit()');
5354: END IF;
5355: RAISE FND_API.G_EXC_ERROR;
5356: ELSE
5357: IF PG_DEBUG in ('Y', 'C') THEN
5358: arp_util.debug('insert_sales_credit: ' || 'Unexpected error '||sqlerrm||
5359: ' at AR_Revenue_Adjustment_PVT.insert_sales_credit()+');

Line 5361: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5357: IF PG_DEBUG in ('Y', 'C') THEN
5358: arp_util.debug('insert_sales_credit: ' || 'Unexpected error '||sqlerrm||
5359: ' at AR_Revenue_Adjustment_PVT.insert_sales_credit()+');
5360: END IF;
5361: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5362: END IF;
5363:
5364: END insert_sales_credit;
5365:

Line 5553: RAISE FND_API.G_EXC_ERROR;

5549: IF PG_DEBUG in ('Y', 'C') THEN
5550: arp_util.debug
5551: ('20001 error at AR_Revenue_Adjustment_PVT.record_acceptance()');
5552: END IF;
5553: RAISE FND_API.G_EXC_ERROR;
5554: ELSE
5555: IF PG_DEBUG in ('Y', 'C') THEN
5556: arp_util.debug('Record_Acceptance: ' || 'Unexpected error '||sqlerrm||
5557: ' at AR_Revenue_Adjustment_PVT.record_acceptance()+');

Line 5559: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5555: IF PG_DEBUG in ('Y', 'C') THEN
5556: arp_util.debug('Record_Acceptance: ' || 'Unexpected error '||sqlerrm||
5557: ' at AR_Revenue_Adjustment_PVT.record_acceptance()+');
5558: END IF;
5559: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5560: END IF;
5561: END Record_Acceptance;
5562:
5563: /* Initialization section */