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.IGC_CC_MC_MAIN_PVT dependencies on FND_API

Line 13: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

9: ===============================================================================*/
10:
11: PROCEDURE get_rsobs_Headers (
12: p_api_version IN NUMBER,
13: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
14: p_commit IN VARCHAR2 := FND_API.G_FALSE,
15: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
16: X_return_status OUT NOCOPY VARCHAR2,
17: X_msg_count OUT NOCOPY NUMBER,

Line 14: p_commit IN VARCHAR2 := FND_API.G_FALSE,

10:
11: PROCEDURE get_rsobs_Headers (
12: p_api_version IN NUMBER,
13: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
14: p_commit IN VARCHAR2 := FND_API.G_FALSE,
15: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
16: X_return_status OUT NOCOPY VARCHAR2,
17: X_msg_count OUT NOCOPY NUMBER,
18: X_msg_data OUT NOCOPY VARCHAR2,

Line 15: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

11: PROCEDURE get_rsobs_Headers (
12: p_api_version IN NUMBER,
13: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
14: p_commit IN VARCHAR2 := FND_API.G_FALSE,
15: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
16: X_return_status OUT NOCOPY VARCHAR2,
17: X_msg_count OUT NOCOPY NUMBER,
18: X_msg_data OUT NOCOPY VARCHAR2,
19: p_CC_Header_Id IN NUMBER,

Line 58: IF NOT FND_API.Compatible_API_Call ( l_api_version,

54: BEGIN
55:
56: SAVEPOINT get_rsobs_Headers_PT;
57:
58: IF NOT FND_API.Compatible_API_Call ( l_api_version,
59: p_api_version,
60: l_api_name,
61: G_PKG_NAME )
62: THEN

Line 63: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

59: p_api_version,
60: l_api_name,
61: G_PKG_NAME )
62: THEN
63: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
64: END IF;
65:
66:
67: IF FND_API.to_Boolean (p_init_msg_list ) THEN

Line 67: IF FND_API.to_Boolean (p_init_msg_list ) THEN

63: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
64: END IF;
65:
66:
67: IF FND_API.to_Boolean (p_init_msg_list ) THEN
68: FND_MSG_PUB.initialize;
69: END IF;
70:
71: X_return_status := FND_API.G_RET_STS_SUCCESS;

Line 71: X_return_status := FND_API.G_RET_STS_SUCCESS;

67: IF FND_API.to_Boolean (p_init_msg_list ) THEN
68: FND_MSG_PUB.initialize;
69: END IF;
70:
71: X_return_status := FND_API.G_RET_STS_SUCCESS;
72:
73: -- -------------------------------------------------------------------------
74: -- Obtain all sets of books associated to the Primary set of books ID
75: -- received from the caller.

Line 148: FND_API.G_FALSE,

144: IF (l_flag = 'I') THEN
145:
146: IGC_CC_MC_HEADERS_PKG.Insert_Row (
147: l_api_version,
148: FND_API.G_FALSE,
149: FND_API.G_FALSE,
150: FND_API.G_VALID_LEVEL_FULL,
151: l_return_status,
152: X_msg_count,

Line 149: FND_API.G_FALSE,

145:
146: IGC_CC_MC_HEADERS_PKG.Insert_Row (
147: l_api_version,
148: FND_API.G_FALSE,
149: FND_API.G_FALSE,
150: FND_API.G_VALID_LEVEL_FULL,
151: l_return_status,
152: X_msg_count,
153: X_msg_data,

Line 150: FND_API.G_VALID_LEVEL_FULL,

146: IGC_CC_MC_HEADERS_PKG.Insert_Row (
147: l_api_version,
148: FND_API.G_FALSE,
149: FND_API.G_FALSE,
150: FND_API.G_VALID_LEVEL_FULL,
151: l_return_status,
152: X_msg_count,
153: X_msg_data,
154: l_row_id,

Line 165: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

161:
162: -- ------------------------------------------------------------------
163: -- Make sure that the insertion was a success
164: -- ------------------------------------------------------------------
165: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
166: RAISE FND_API.G_EXC_ERROR;
167: END IF;
168:
169: -- ----------------------------------------------------------------------

Line 166: RAISE FND_API.G_EXC_ERROR;

162: -- ------------------------------------------------------------------
163: -- Make sure that the insertion was a success
164: -- ------------------------------------------------------------------
165: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
166: RAISE FND_API.G_EXC_ERROR;
167: END IF;
168:
169: -- ----------------------------------------------------------------------
170: -- If Update is requested then update the appropriate record in the MRC

Line 186: FND_API.G_FALSE,

182: AND set_of_books_id = l_sob_list(rec1).r_sob_id;
183:
184: IGC_CC_MC_HEADERS_PKG.Update_Row (
185: l_api_version,
186: FND_API.G_FALSE,
187: FND_API.G_FALSE,
188: FND_API.G_VALID_LEVEL_FULL,
189: l_return_status,
190: X_msg_count,

Line 187: FND_API.G_FALSE,

183:
184: IGC_CC_MC_HEADERS_PKG.Update_Row (
185: l_api_version,
186: FND_API.G_FALSE,
187: FND_API.G_FALSE,
188: FND_API.G_VALID_LEVEL_FULL,
189: l_return_status,
190: X_msg_count,
191: X_msg_data,

Line 188: FND_API.G_VALID_LEVEL_FULL,

184: IGC_CC_MC_HEADERS_PKG.Update_Row (
185: l_api_version,
186: FND_API.G_FALSE,
187: FND_API.G_FALSE,
188: FND_API.G_VALID_LEVEL_FULL,
189: l_return_status,
190: X_msg_count,
191: X_msg_data,
192: l_row_id,

Line 203: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

199:
200: -- ------------------------------------------------------------------
201: -- Make sure that the insertion was a success
202: -- ------------------------------------------------------------------
203: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
204: RAISE FND_API.G_EXC_ERROR;
205: END IF;
206:
207: ELSE

Line 204: RAISE FND_API.G_EXC_ERROR;

200: -- ------------------------------------------------------------------
201: -- Make sure that the insertion was a success
202: -- ------------------------------------------------------------------
203: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
204: RAISE FND_API.G_EXC_ERROR;
205: END IF;
206:
207: ELSE
208:

Line 209: RAISE FND_API.G_EXC_ERROR;

205: END IF;
206:
207: ELSE
208:
209: RAISE FND_API.G_EXC_ERROR;
210:
211: END IF; -- Insert / Update Flag
212:
213: END IF; -- Rate exists

Line 222: IF FND_API.To_Boolean ( p_commit ) THEN

218:
219: -- ------------------------------------------------------------------------
220: -- Only commit the information if the caller has requested it to be.
221: -- ------------------------------------------------------------------------
222: IF FND_API.To_Boolean ( p_commit ) THEN
223: COMMIT WORK;
224: END iF;
225:
226: -- ------------------------------------------------------------------------

Line 240: WHEN FND_API.G_EXC_ERROR THEN

236: RETURN;
237:
238: EXCEPTION
239:
240: WHEN FND_API.G_EXC_ERROR THEN
241:
242: ROLLBACK TO get_rsobs_Headers_PT;
243: X_return_status := FND_API.G_RET_STS_ERROR;
244: IF (c_conversion_type%ISOPEN) THEN

Line 243: X_return_status := FND_API.G_RET_STS_ERROR;

239:
240: WHEN FND_API.G_EXC_ERROR THEN
241:
242: ROLLBACK TO get_rsobs_Headers_PT;
243: X_return_status := FND_API.G_RET_STS_ERROR;
244: IF (c_conversion_type%ISOPEN) THEN
245: CLOSE c_conversion_type;
246: END IF;
247: FND_MSG_PUB.Count_And_Get (p_count => X_msg_count,

Line 250: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

246: END IF;
247: FND_MSG_PUB.Count_And_Get (p_count => X_msg_count,
248: p_data => X_msg_data);
249:
250: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
251:
252: ROLLBACK TO get_rsobs_Headers_PT;
253: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
254: IF (c_conversion_type%ISOPEN) THEN

Line 253: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

249:
250: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
251:
252: ROLLBACK TO get_rsobs_Headers_PT;
253: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
254: IF (c_conversion_type%ISOPEN) THEN
255: CLOSE c_conversion_type;
256: END IF;
257: FND_MSG_PUB.Count_And_Get (p_count => X_msg_count,

Line 263: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

259:
260: WHEN OTHERS THEN
261:
262: ROLLBACK TO get_rsobs_Headers_PT;
263: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
264: IF (c_conversion_type%ISOPEN) THEN
265: CLOSE c_conversion_type;
266: END IF;
267:

Line 284: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

280: ===============================================================================*/
281:
282: PROCEDURE get_rsobs_Acct_Lines (
283: p_api_version IN NUMBER,
284: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
285: p_commit IN VARCHAR2 := FND_API.G_FALSE,
286: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
287: X_return_status OUT NOCOPY VARCHAR2,
288: X_msg_count OUT NOCOPY NUMBER,

Line 285: p_commit IN VARCHAR2 := FND_API.G_FALSE,

281:
282: PROCEDURE get_rsobs_Acct_Lines (
283: p_api_version IN NUMBER,
284: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
285: p_commit IN VARCHAR2 := FND_API.G_FALSE,
286: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
287: X_return_status OUT NOCOPY VARCHAR2,
288: X_msg_count OUT NOCOPY NUMBER,
289: X_msg_data OUT NOCOPY VARCHAR2,

Line 286: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

282: PROCEDURE get_rsobs_Acct_Lines (
283: p_api_version IN NUMBER,
284: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
285: p_commit IN VARCHAR2 := FND_API.G_FALSE,
286: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
287: X_return_status OUT NOCOPY VARCHAR2,
288: X_msg_count OUT NOCOPY NUMBER,
289: X_msg_data OUT NOCOPY VARCHAR2,
290: p_CC_Acct_Line_Id IN NUMBER,

Line 335: IF NOT FND_API.Compatible_API_Call ( l_api_version,

331: BEGIN
332:
333: SAVEPOINT get_rsobs_Acct_Lines_PT;
334:
335: IF NOT FND_API.Compatible_API_Call ( l_api_version,
336: p_api_version,
337: l_api_name,
338: G_PKG_NAME )
339: THEN

Line 340: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

336: p_api_version,
337: l_api_name,
338: G_PKG_NAME )
339: THEN
340: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
341: END IF;
342:
343:
344: IF FND_API.to_Boolean (p_init_msg_list ) THEN

Line 344: IF FND_API.to_Boolean (p_init_msg_list ) THEN

340: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
341: END IF;
342:
343:
344: IF FND_API.to_Boolean (p_init_msg_list ) THEN
345: FND_MSG_PUB.initialize;
346: END IF;
347:
348: X_return_status := FND_API.G_RET_STS_SUCCESS;

Line 348: X_return_status := FND_API.G_RET_STS_SUCCESS;

344: IF FND_API.to_Boolean (p_init_msg_list ) THEN
345: FND_MSG_PUB.initialize;
346: END IF;
347:
348: X_return_status := FND_API.G_RET_STS_SUCCESS;
349:
350: -- -------------------------------------------------------------------------
351: -- Obtain all sets of books associated to the Primary set of books ID
352: -- received from the caller.

Line 442: FND_API.G_FALSE,

438: IF (l_flag = 'I') THEN
439:
440: IGC_CC_MC_ACCT_LINES_PKG.Insert_Row (
441: l_api_version,
442: FND_API.G_FALSE,
443: FND_API.G_FALSE,
444: FND_API.G_VALID_LEVEL_FULL,
445: l_return_status,
446: X_msg_count,

Line 443: FND_API.G_FALSE,

439:
440: IGC_CC_MC_ACCT_LINES_PKG.Insert_Row (
441: l_api_version,
442: FND_API.G_FALSE,
443: FND_API.G_FALSE,
444: FND_API.G_VALID_LEVEL_FULL,
445: l_return_status,
446: X_msg_count,
447: X_msg_data,

Line 444: FND_API.G_VALID_LEVEL_FULL,

440: IGC_CC_MC_ACCT_LINES_PKG.Insert_Row (
441: l_api_version,
442: FND_API.G_FALSE,
443: FND_API.G_FALSE,
444: FND_API.G_VALID_LEVEL_FULL,
445: l_return_status,
446: X_msg_count,
447: X_msg_data,
448: l_row_id,

Line 462: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

458:
459: -- ------------------------------------------------------------------
460: -- Make sure that the insertion was a success
461: -- ------------------------------------------------------------------
462: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
463: RAISE FND_API.G_EXC_ERROR;
464: END IF;
465:
466: -- ----------------------------------------------------------------------

Line 463: RAISE FND_API.G_EXC_ERROR;

459: -- ------------------------------------------------------------------
460: -- Make sure that the insertion was a success
461: -- ------------------------------------------------------------------
462: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
463: RAISE FND_API.G_EXC_ERROR;
464: END IF;
465:
466: -- ----------------------------------------------------------------------
467: -- If delete is requested then delete the appropriate record in the MRC

Line 483: FND_API.G_FALSE,

479: AND set_of_books_id = l_sob_list(rec1).r_sob_id;
480:
481: IGC_CC_MC_ACCT_LINES_PKG.Delete_Row (
482: l_api_version,
483: FND_API.G_FALSE,
484: FND_API.G_FALSE,
485: FND_API.G_VALID_LEVEL_FULL,
486: l_return_status,
487: X_msg_count,

Line 484: FND_API.G_FALSE,

480:
481: IGC_CC_MC_ACCT_LINES_PKG.Delete_Row (
482: l_api_version,
483: FND_API.G_FALSE,
484: FND_API.G_FALSE,
485: FND_API.G_VALID_LEVEL_FULL,
486: l_return_status,
487: X_msg_count,
488: X_msg_data,

Line 485: FND_API.G_VALID_LEVEL_FULL,

481: IGC_CC_MC_ACCT_LINES_PKG.Delete_Row (
482: l_api_version,
483: FND_API.G_FALSE,
484: FND_API.G_FALSE,
485: FND_API.G_VALID_LEVEL_FULL,
486: l_return_status,
487: X_msg_count,
488: X_msg_data,
489: l_row_id

Line 495: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

491:
492: -- ------------------------------------------------------------------
493: -- Make sure that the insertion was a success
494: -- ------------------------------------------------------------------
495: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
496: RAISE FND_API.G_EXC_ERROR;
497: END IF;
498:
499: -- ----------------------------------------------------------------------

Line 496: RAISE FND_API.G_EXC_ERROR;

492: -- ------------------------------------------------------------------
493: -- Make sure that the insertion was a success
494: -- ------------------------------------------------------------------
495: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
496: RAISE FND_API.G_EXC_ERROR;
497: END IF;
498:
499: -- ----------------------------------------------------------------------
500: -- If Update is requested then update the appropriate record in the MRC

Line 516: FND_API.G_FALSE,

512: AND set_of_books_id = l_sob_list(rec1).r_sob_id;
513:
514: IGC_CC_MC_ACCT_LINES_PKG.Update_Row (
515: l_api_version,
516: FND_API.G_FALSE,
517: FND_API.G_FALSE,
518: FND_API.G_VALID_LEVEL_FULL,
519: l_return_status,
520: X_msg_count,

Line 517: FND_API.G_FALSE,

513:
514: IGC_CC_MC_ACCT_LINES_PKG.Update_Row (
515: l_api_version,
516: FND_API.G_FALSE,
517: FND_API.G_FALSE,
518: FND_API.G_VALID_LEVEL_FULL,
519: l_return_status,
520: X_msg_count,
521: X_msg_data,

Line 518: FND_API.G_VALID_LEVEL_FULL,

514: IGC_CC_MC_ACCT_LINES_PKG.Update_Row (
515: l_api_version,
516: FND_API.G_FALSE,
517: FND_API.G_FALSE,
518: FND_API.G_VALID_LEVEL_FULL,
519: l_return_status,
520: X_msg_count,
521: X_msg_data,
522: l_row_id,

Line 536: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

532:
533: -- ------------------------------------------------------------------
534: -- Make sure that the insertion was a success
535: -- ------------------------------------------------------------------
536: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
537: RAISE FND_API.G_EXC_ERROR;
538: END IF;
539:
540: ELSE

Line 537: RAISE FND_API.G_EXC_ERROR;

533: -- ------------------------------------------------------------------
534: -- Make sure that the insertion was a success
535: -- ------------------------------------------------------------------
536: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
537: RAISE FND_API.G_EXC_ERROR;
538: END IF;
539:
540: ELSE
541:

Line 542: RAISE FND_API.G_EXC_ERROR;

538: END IF;
539:
540: ELSE
541:
542: RAISE FND_API.G_EXC_ERROR;
543:
544: END IF; -- Insert / Update Flag
545:
546: END IF; -- Rate exists

Line 555: IF FND_API.To_Boolean ( p_commit ) THEN

551:
552: -- ------------------------------------------------------------------------
553: -- Only commit the information if the caller has requested it to be.
554: -- ------------------------------------------------------------------------
555: IF FND_API.To_Boolean ( p_commit ) THEN
556: COMMIT WORK;
557: END iF;
558:
559: -- ------------------------------------------------------------------------

Line 574: WHEN FND_API.G_EXC_ERROR THEN

570:
571:
572: EXCEPTION
573:
574: WHEN FND_API.G_EXC_ERROR THEN
575:
576: ROLLBACK TO get_rsobs_Acct_Lines_PT;
577: X_return_status := FND_API.G_RET_STS_ERROR;
578: IF (c_conversion_type%ISOPEN) THEN

Line 577: X_return_status := FND_API.G_RET_STS_ERROR;

573:
574: WHEN FND_API.G_EXC_ERROR THEN
575:
576: ROLLBACK TO get_rsobs_Acct_Lines_PT;
577: X_return_status := FND_API.G_RET_STS_ERROR;
578: IF (c_conversion_type%ISOPEN) THEN
579: CLOSE c_conversion_type;
580: END IF;
581: FND_MSG_PUB.Count_And_Get (p_count => X_msg_count,

Line 584: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

580: END IF;
581: FND_MSG_PUB.Count_And_Get (p_count => X_msg_count,
582: p_data => X_msg_data);
583:
584: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
585:
586: ROLLBACK TO get_rsobs_Acct_Lines_PT;
587: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
588: IF (c_conversion_type%ISOPEN) THEN

Line 587: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

583:
584: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
585:
586: ROLLBACK TO get_rsobs_Acct_Lines_PT;
587: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
588: IF (c_conversion_type%ISOPEN) THEN
589: CLOSE c_conversion_type;
590: END IF;
591: FND_MSG_PUB.Count_And_Get (p_count => X_msg_count,

Line 597: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

593:
594: WHEN OTHERS THEN
595:
596: ROLLBACK TO get_rsobs_Acct_Lines_PT;
597: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
598: IF (c_conversion_type%ISOPEN) THEN
599: CLOSE c_conversion_type;
600: END IF;
601:

Line 619: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

615: ===============================================================================*/
616:
617: PROCEDURE get_rsobs_DET_PF (
618: p_api_version IN NUMBER,
619: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
620: p_commit IN VARCHAR2 := FND_API.G_FALSE,
621: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
622: X_return_status OUT NOCOPY VARCHAR2,
623: X_msg_count OUT NOCOPY NUMBER,

Line 620: p_commit IN VARCHAR2 := FND_API.G_FALSE,

616:
617: PROCEDURE get_rsobs_DET_PF (
618: p_api_version IN NUMBER,
619: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
620: p_commit IN VARCHAR2 := FND_API.G_FALSE,
621: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
622: X_return_status OUT NOCOPY VARCHAR2,
623: X_msg_count OUT NOCOPY NUMBER,
624: X_msg_data OUT NOCOPY VARCHAR2,

Line 621: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

617: PROCEDURE get_rsobs_DET_PF (
618: p_api_version IN NUMBER,
619: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
620: p_commit IN VARCHAR2 := FND_API.G_FALSE,
621: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
622: X_return_status OUT NOCOPY VARCHAR2,
623: X_msg_count OUT NOCOPY NUMBER,
624: X_msg_data OUT NOCOPY VARCHAR2,
625: p_CC_DET_PF_Line_Id IN NUMBER,

Line 668: IF NOT FND_API.Compatible_API_Call ( l_api_version,

664: BEGIN
665:
666: SAVEPOINT get_rsobs_DET_PF_PT;
667:
668: IF NOT FND_API.Compatible_API_Call ( l_api_version,
669: p_api_version,
670: l_api_name,
671: G_PKG_NAME )
672: THEN

Line 673: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

669: p_api_version,
670: l_api_name,
671: G_PKG_NAME )
672: THEN
673: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
674: END IF;
675:
676:
677: IF FND_API.to_Boolean (p_init_msg_list ) THEN

Line 677: IF FND_API.to_Boolean (p_init_msg_list ) THEN

673: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
674: END IF;
675:
676:
677: IF FND_API.to_Boolean (p_init_msg_list ) THEN
678: FND_MSG_PUB.initialize;
679: END IF;
680:
681: X_return_status := FND_API.G_RET_STS_SUCCESS;

Line 681: X_return_status := FND_API.G_RET_STS_SUCCESS;

677: IF FND_API.to_Boolean (p_init_msg_list ) THEN
678: FND_MSG_PUB.initialize;
679: END IF;
680:
681: X_return_status := FND_API.G_RET_STS_SUCCESS;
682:
683: -- -------------------------------------------------------------------------
684: -- Obtain all sets of books associated to the Primary set of books ID
685: -- received from the caller.

Line 773: FND_API.G_FALSE,

769: IF (l_flag = 'I') THEN
770:
771: IGC_CC_MC_DET_PF_PKG.Insert_Row (
772: l_api_version,
773: FND_API.G_FALSE,
774: FND_API.G_FALSE,
775: FND_API.G_VALID_LEVEL_FULL,
776: l_return_status,
777: X_msg_count,

Line 774: FND_API.G_FALSE,

770:
771: IGC_CC_MC_DET_PF_PKG.Insert_Row (
772: l_api_version,
773: FND_API.G_FALSE,
774: FND_API.G_FALSE,
775: FND_API.G_VALID_LEVEL_FULL,
776: l_return_status,
777: X_msg_count,
778: X_msg_data,

Line 775: FND_API.G_VALID_LEVEL_FULL,

771: IGC_CC_MC_DET_PF_PKG.Insert_Row (
772: l_api_version,
773: FND_API.G_FALSE,
774: FND_API.G_FALSE,
775: FND_API.G_VALID_LEVEL_FULL,
776: l_return_status,
777: X_msg_count,
778: X_msg_data,
779: l_row_id,

Line 792: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

788:
789: -- ------------------------------------------------------------------
790: -- Make sure that the insertion was a success
791: -- ------------------------------------------------------------------
792: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
793: RAISE FND_API.G_EXC_ERROR;
794: END IF;
795:
796: -- ----------------------------------------------------------------------

Line 793: RAISE FND_API.G_EXC_ERROR;

789: -- ------------------------------------------------------------------
790: -- Make sure that the insertion was a success
791: -- ------------------------------------------------------------------
792: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
793: RAISE FND_API.G_EXC_ERROR;
794: END IF;
795:
796: -- ----------------------------------------------------------------------
797: -- If delete is requested then delete the appropriate record in the MRC

Line 813: FND_API.G_FALSE,

809: AND set_of_books_id = l_sob_list(rec1).r_sob_id;
810:
811: IGC_CC_MC_DET_PF_PKG.Delete_Row (
812: l_api_version,
813: FND_API.G_FALSE,
814: FND_API.G_FALSE,
815: FND_API.G_VALID_LEVEL_FULL,
816: l_return_status,
817: X_msg_count,

Line 814: FND_API.G_FALSE,

810:
811: IGC_CC_MC_DET_PF_PKG.Delete_Row (
812: l_api_version,
813: FND_API.G_FALSE,
814: FND_API.G_FALSE,
815: FND_API.G_VALID_LEVEL_FULL,
816: l_return_status,
817: X_msg_count,
818: X_msg_data,

Line 815: FND_API.G_VALID_LEVEL_FULL,

811: IGC_CC_MC_DET_PF_PKG.Delete_Row (
812: l_api_version,
813: FND_API.G_FALSE,
814: FND_API.G_FALSE,
815: FND_API.G_VALID_LEVEL_FULL,
816: l_return_status,
817: X_msg_count,
818: X_msg_data,
819: l_row_id

Line 825: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

821:
822: -- ------------------------------------------------------------------
823: -- Make sure that the insertion was a success
824: -- ------------------------------------------------------------------
825: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
826: RAISE FND_API.G_EXC_ERROR;
827: END IF;
828:
829: -- ----------------------------------------------------------------------

Line 826: RAISE FND_API.G_EXC_ERROR;

822: -- ------------------------------------------------------------------
823: -- Make sure that the insertion was a success
824: -- ------------------------------------------------------------------
825: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
826: RAISE FND_API.G_EXC_ERROR;
827: END IF;
828:
829: -- ----------------------------------------------------------------------
830: -- If Update is requested then update the appropriate record in the MRC

Line 846: FND_API.G_FALSE,

842: AND set_of_books_id = l_sob_list(rec1).r_sob_id;
843:
844: IGC_CC_MC_DET_PF_PKG.Update_Row (
845: l_api_version,
846: FND_API.G_FALSE,
847: FND_API.G_FALSE,
848: FND_API.G_VALID_LEVEL_FULL,
849: l_return_status,
850: X_msg_count,

Line 847: FND_API.G_FALSE,

843:
844: IGC_CC_MC_DET_PF_PKG.Update_Row (
845: l_api_version,
846: FND_API.G_FALSE,
847: FND_API.G_FALSE,
848: FND_API.G_VALID_LEVEL_FULL,
849: l_return_status,
850: X_msg_count,
851: X_msg_data,

Line 848: FND_API.G_VALID_LEVEL_FULL,

844: IGC_CC_MC_DET_PF_PKG.Update_Row (
845: l_api_version,
846: FND_API.G_FALSE,
847: FND_API.G_FALSE,
848: FND_API.G_VALID_LEVEL_FULL,
849: l_return_status,
850: X_msg_count,
851: X_msg_data,
852: l_row_id,

Line 865: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

861:
862: -- ------------------------------------------------------------------
863: -- Make sure that the insertion was a success
864: -- ------------------------------------------------------------------
865: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
866: RAISE FND_API.G_EXC_ERROR;
867: END IF;
868:
869: ELSE

Line 866: RAISE FND_API.G_EXC_ERROR;

862: -- ------------------------------------------------------------------
863: -- Make sure that the insertion was a success
864: -- ------------------------------------------------------------------
865: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
866: RAISE FND_API.G_EXC_ERROR;
867: END IF;
868:
869: ELSE
870:

Line 871: RAISE FND_API.G_EXC_ERROR;

867: END IF;
868:
869: ELSE
870:
871: RAISE FND_API.G_EXC_ERROR;
872:
873: END IF; -- Insert / Update Flag
874:
875: END IF; -- Rate exists

Line 884: IF FND_API.To_Boolean ( p_commit ) THEN

880:
881: -- ------------------------------------------------------------------------
882: -- Only commit the information if the caller has requested it to be.
883: -- ------------------------------------------------------------------------
884: IF FND_API.To_Boolean ( p_commit ) THEN
885: COMMIT WORK;
886: END iF;
887:
888: -- ------------------------------------------------------------------------

Line 902: WHEN FND_API.G_EXC_ERROR THEN

898: RETURN;
899:
900: EXCEPTION
901:
902: WHEN FND_API.G_EXC_ERROR THEN
903:
904: ROLLBACK TO get_rsobs_Headers_PT;
905: X_return_status := FND_API.G_RET_STS_ERROR;
906: IF (c_conversion_type%ISOPEN) THEN

Line 905: X_return_status := FND_API.G_RET_STS_ERROR;

901:
902: WHEN FND_API.G_EXC_ERROR THEN
903:
904: ROLLBACK TO get_rsobs_Headers_PT;
905: X_return_status := FND_API.G_RET_STS_ERROR;
906: IF (c_conversion_type%ISOPEN) THEN
907: CLOSE c_conversion_type;
908: END IF;
909: FND_MSG_PUB.Count_And_Get (p_count => X_msg_count,

Line 912: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

908: END IF;
909: FND_MSG_PUB.Count_And_Get (p_count => X_msg_count,
910: p_data => X_msg_data);
911:
912: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
913:
914: ROLLBACK TO get_rsobs_Headers_PT;
915: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
916: IF (c_conversion_type%ISOPEN) THEN

Line 915: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

911:
912: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
913:
914: ROLLBACK TO get_rsobs_Headers_PT;
915: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
916: IF (c_conversion_type%ISOPEN) THEN
917: CLOSE c_conversion_type;
918: END IF;
919: FND_MSG_PUB.Count_And_Get (p_count => X_msg_count,

Line 925: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

921:
922: WHEN OTHERS THEN
923:
924: ROLLBACK TO get_rsobs_Headers_PT;
925: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
926: IF (c_conversion_type%ISOPEN) THEN
927: CLOSE c_conversion_type;
928: END IF;
929: