DBA Data[Home] [Help]

APPS.AR_VIEW_TERM_GRP dependencies on FND_API

Line 108: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

104: arp_util.debug('AR_VIEW_TERM_GRP.pay_now_amounts()+');
105: END IF;
106:
107: -- Standard call to check for call compatibility.
108: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
109: p_api_version ,
110: l_api_name ,
111: G_PKG_NAME )
112: THEN

Line 117: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

113: IF PG_DEBUG in ('Y', 'C') THEN
114: arp_util.debug('Unexpected error: wrong API version '||sqlerrm||
115: ' at AR_VIEW_TERM_GRP.pay_now_amounts()+');
116: END IF;
117: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
118: END IF;
119: -- Initialize message list if p_init_msg_list is set to TRUE.
120: IF FND_API.to_Boolean( p_init_msg_list )
121: THEN

Line 120: IF FND_API.to_Boolean( p_init_msg_list )

116: END IF;
117: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
118: END IF;
119: -- Initialize message list if p_init_msg_list is set to TRUE.
120: IF FND_API.to_Boolean( p_init_msg_list )
121: THEN
122: FND_MSG_PUB.initialize;
123: END IF;
124: -- Initialize API return status to success

Line 125: x_return_status := FND_API.G_RET_STS_SUCCESS;

121: THEN
122: FND_MSG_PUB.initialize;
123: END IF;
124: -- Initialize API return status to success
125: x_return_status := FND_API.G_RET_STS_SUCCESS;
126:
127: -- Check if term_id is in cache, and insert if not
128: IF NOT pay_now_cache.EXISTS(p_term_id) THEN
129: OPEN c_term(p_term_id);

Line 136: RAISE FND_API.G_EXC_ERROR;

132: IF c_term%NOTFOUND THEN
133: FND_MESSAGE.set_name('AR','AR_TAPI_INVALID_TERMS_ID');
134: FND_MESSAGE.set_token('INVALID_VALUE',p_term_id);
135: FND_MSG_PUB.Add;
136: RAISE FND_API.G_EXC_ERROR;
137: END IF;
138: CLOSE c_term;
139:
140: OPEN c_term_line(p_term_id);

Line 156: RAISE FND_API.G_EXC_ERROR;

152: EXCEPTION
153: WHEN NO_DATA_FOUND THEN
154: FND_MESSAGE.set_name('AR','AR_CC_INVALID_CURRENCY');
155: FND_MSG_PUB.Add;
156: RAISE FND_API.G_EXC_ERROR;
157: END;
158:
159: x_pay_now_line_amount := l_pay_now_line_amt_rnd;
160: IF pay_now_cache(p_term_id).first_installment_code = 'ALLOCATE' THEN

Line 179: WHEN FND_API.G_EXC_ERROR THEN

175: arp_util.debug('AR_VIEW_TERM_GRP.pay_now_amounts()-');
176: END IF;
177:
178: EXCEPTION
179: WHEN FND_API.G_EXC_ERROR THEN
180: x_return_status := FND_API.G_RET_STS_ERROR ;
181: FND_MSG_PUB.Count_And_Get
182: (p_encoded => FND_API.G_FALSE,
183: p_count => x_msg_count,

Line 180: x_return_status := FND_API.G_RET_STS_ERROR ;

176: END IF;
177:
178: EXCEPTION
179: WHEN FND_API.G_EXC_ERROR THEN
180: x_return_status := FND_API.G_RET_STS_ERROR ;
181: FND_MSG_PUB.Count_And_Get
182: (p_encoded => FND_API.G_FALSE,
183: p_count => x_msg_count,
184: p_data => x_msg_data);

Line 182: (p_encoded => FND_API.G_FALSE,

178: EXCEPTION
179: WHEN FND_API.G_EXC_ERROR THEN
180: x_return_status := FND_API.G_RET_STS_ERROR ;
181: FND_MSG_PUB.Count_And_Get
182: (p_encoded => FND_API.G_FALSE,
183: p_count => x_msg_count,
184: p_data => x_msg_data);
185: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
186: IF PG_DEBUG in ('Y', 'C') THEN

Line 185: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

181: FND_MSG_PUB.Count_And_Get
182: (p_encoded => FND_API.G_FALSE,
183: p_count => x_msg_count,
184: p_data => x_msg_data);
185: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
186: IF PG_DEBUG in ('Y', 'C') THEN
187: arp_util.debug('Unexpected error '||sqlerrm||
188: ' at ar_view_term_grp.pay_now_amounts()+');
189: END IF;

Line 190: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

186: IF PG_DEBUG in ('Y', 'C') THEN
187: arp_util.debug('Unexpected error '||sqlerrm||
188: ' at ar_view_term_grp.pay_now_amounts()+');
189: END IF;
190: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
191: FND_MSG_PUB.Count_And_Get
192: (p_encoded => FND_API.G_FALSE,
193: p_count => x_msg_count,
194: p_data => x_msg_data);

Line 192: (p_encoded => FND_API.G_FALSE,

188: ' at ar_view_term_grp.pay_now_amounts()+');
189: END IF;
190: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
191: FND_MSG_PUB.Count_And_Get
192: (p_encoded => FND_API.G_FALSE,
193: p_count => x_msg_count,
194: p_data => x_msg_data);
195: WHEN OTHERS THEN
196: IF (SQLCODE = -20001)

Line 202: x_return_status := FND_API.G_RET_STS_ERROR ;

198: IF PG_DEBUG in ('Y', 'C') THEN
199: arp_util.debug('20001 error '||
200: ' at ar_view_term_grp.pay_now_amounts()+');
201: END IF;
202: x_return_status := FND_API.G_RET_STS_ERROR ;
203: ELSE
204: IF PG_DEBUG in ('Y', 'C') THEN
205: arp_util.debug('Unexpected error '||sqlerrm||
206: ' at ar_view_term_grp.pay_now_amounts()+');

Line 208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

204: IF PG_DEBUG in ('Y', 'C') THEN
205: arp_util.debug('Unexpected error '||sqlerrm||
206: ' at ar_view_term_grp.pay_now_amounts()+');
207: END IF;
208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
209: IF FND_MSG_PUB.Check_Msg_Level
210: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
211: THEN
212: FND_MSG_PUB.Add_Exc_Msg

Line 219: (p_encoded => FND_API.G_FALSE,

215: );
216: END IF;
217: END IF;
218: FND_MSG_PUB.Count_And_Get
219: (p_encoded => FND_API.G_FALSE,
220: p_count => x_msg_count,
221: p_data => x_msg_data);
222: END pay_now_amounts;
223:

Line 275: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

271: arp_util.debug('AR_VIEW_TERM_GRP.pay_now_amounts(2)+');
272: END IF;
273:
274: -- Standard call to check for call compatibility.
275: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
276: p_api_version ,
277: l_api_name ,
278: G_PKG_NAME )
279: THEN

Line 284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

280: IF PG_DEBUG in ('Y', 'C') THEN
281: arp_util.debug('Unexpected error: wrong API version '||sqlerrm||
282: ' at AR_VIEW_TERM_GRP.pay_now_amounts()+');
283: END IF;
284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
285: END IF;
286: -- Initialize message list if p_init_msg_list is set to TRUE.
287: IF FND_API.to_Boolean( p_init_msg_list )
288: THEN

Line 287: IF FND_API.to_Boolean( p_init_msg_list )

283: END IF;
284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
285: END IF;
286: -- Initialize message list if p_init_msg_list is set to TRUE.
287: IF FND_API.to_Boolean( p_init_msg_list )
288: THEN
289: FND_MSG_PUB.initialize;
290: END IF;
291: -- Initialize API return status to success

Line 292: x_return_status := FND_API.G_RET_STS_SUCCESS;

288: THEN
289: FND_MSG_PUB.initialize;
290: END IF;
291: -- Initialize API return status to success
292: x_return_status := FND_API.G_RET_STS_SUCCESS;
293: x_msg_count := 0;
294:
295: l_pay_now_line_amt_sum := 0;
296: l_pay_now_tax_amt_sum := 0;

Line 304: p_init_msg_list => FND_API.G_FALSE,

300: FOR i in p_amounts_tbl.FIRST..p_amounts_tbl.LAST LOOP
301:
302: ar_view_term_grp.pay_now_amounts
303: (p_api_version => 1.0,
304: p_init_msg_list => FND_API.G_FALSE,
305: p_term_id => p_amounts_tbl(i).term_id,
306: p_currency_code => p_currency_code,
307: p_line_amount => p_amounts_tbl(i).line_amount,
308: p_tax_amount => p_amounts_tbl(i).tax_amount,

Line 325: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

321: p_amounts_tbl(i).total_amount := l_pay_now_total_amount;
322:
323: x_msg_count := x_msg_count + l_msg_count;
324:
325: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
326: RAISE FND_API.G_EXC_ERROR;
327: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
328: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
329: END IF;

Line 326: RAISE FND_API.G_EXC_ERROR;

322:
323: x_msg_count := x_msg_count + l_msg_count;
324:
325: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
326: RAISE FND_API.G_EXC_ERROR;
327: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
328: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
329: END IF;
330:

Line 327: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

323: x_msg_count := x_msg_count + l_msg_count;
324:
325: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
326: RAISE FND_API.G_EXC_ERROR;
327: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
328: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
329: END IF;
330:
331: l_pay_now_line_amt_sum := l_pay_now_line_amt_sum + l_pay_now_line_amount;

Line 328: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

324:
325: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
326: RAISE FND_API.G_EXC_ERROR;
327: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
328: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
329: END IF;
330:
331: l_pay_now_line_amt_sum := l_pay_now_line_amt_sum + l_pay_now_line_amount;
332: l_pay_now_tax_amt_sum := l_pay_now_tax_amt_sum + l_pay_now_tax_amount;

Line 348: WHEN FND_API.G_EXC_ERROR THEN

344: arp_util.debug('AR_VIEW_TERM_GRP.pay_now_amounts(2)-');
345: END IF;
346:
347: EXCEPTION
348: WHEN FND_API.G_EXC_ERROR THEN
349: x_return_status := FND_API.G_RET_STS_ERROR ;
350: FND_MSG_PUB.Count_And_Get
351: (p_encoded => FND_API.G_FALSE,
352: p_count => x_msg_count,

Line 349: x_return_status := FND_API.G_RET_STS_ERROR ;

345: END IF;
346:
347: EXCEPTION
348: WHEN FND_API.G_EXC_ERROR THEN
349: x_return_status := FND_API.G_RET_STS_ERROR ;
350: FND_MSG_PUB.Count_And_Get
351: (p_encoded => FND_API.G_FALSE,
352: p_count => x_msg_count,
353: p_data => x_msg_data);

Line 351: (p_encoded => FND_API.G_FALSE,

347: EXCEPTION
348: WHEN FND_API.G_EXC_ERROR THEN
349: x_return_status := FND_API.G_RET_STS_ERROR ;
350: FND_MSG_PUB.Count_And_Get
351: (p_encoded => FND_API.G_FALSE,
352: p_count => x_msg_count,
353: p_data => x_msg_data);
354: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
355: IF PG_DEBUG in ('Y', 'C') THEN

Line 354: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

350: FND_MSG_PUB.Count_And_Get
351: (p_encoded => FND_API.G_FALSE,
352: p_count => x_msg_count,
353: p_data => x_msg_data);
354: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
355: IF PG_DEBUG in ('Y', 'C') THEN
356: arp_util.debug('Unexpected error '||sqlerrm||
357: ' at ar_view_term_grp.pay_now_amounts(2)+');
358: END IF;

Line 359: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

355: IF PG_DEBUG in ('Y', 'C') THEN
356: arp_util.debug('Unexpected error '||sqlerrm||
357: ' at ar_view_term_grp.pay_now_amounts(2)+');
358: END IF;
359: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
360: FND_MSG_PUB.Count_And_Get
361: (p_encoded => FND_API.G_FALSE,
362: p_count => x_msg_count,
363: p_data => x_msg_data);

Line 361: (p_encoded => FND_API.G_FALSE,

357: ' at ar_view_term_grp.pay_now_amounts(2)+');
358: END IF;
359: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
360: FND_MSG_PUB.Count_And_Get
361: (p_encoded => FND_API.G_FALSE,
362: p_count => x_msg_count,
363: p_data => x_msg_data);
364: WHEN OTHERS THEN
365: IF (SQLCODE = -20001)

Line 371: x_return_status := FND_API.G_RET_STS_ERROR ;

367: IF PG_DEBUG in ('Y', 'C') THEN
368: arp_util.debug('20001 error '||
369: ' at ar_view_term_grp.pay_now_amounts(2)+');
370: END IF;
371: x_return_status := FND_API.G_RET_STS_ERROR ;
372: ELSE
373: IF PG_DEBUG in ('Y', 'C') THEN
374: arp_util.debug('Unexpected error '||sqlerrm||
375: ' at ar_view_term_grp.pay_now_amounts(2)+');

Line 377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

373: IF PG_DEBUG in ('Y', 'C') THEN
374: arp_util.debug('Unexpected error '||sqlerrm||
375: ' at ar_view_term_grp.pay_now_amounts(2)+');
376: END IF;
377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
378: IF FND_MSG_PUB.Check_Msg_Level
379: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
380: THEN
381: FND_MSG_PUB.Add_Exc_Msg

Line 388: (p_encoded => FND_API.G_FALSE,

384: );
385: END IF;
386: END IF;
387: FND_MSG_PUB.Count_And_Get
388: (p_encoded => FND_API.G_FALSE,
389: p_count => x_msg_count,
390: p_data => x_msg_data);
391: END pay_now_amounts;
392: