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_HST_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 60: IF NOT FND_API.COMPATIBLE_API_CALL ( l_api_version,

56: BEGIN
57:
58: SAVEPOINT get_rsobs_Headers_PT;
59:
60: IF NOT FND_API.COMPATIBLE_API_CALL ( l_api_version,
61: p_api_version,
62: l_api_name,
63: G_PKG_NAME) THEN
64: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 64: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

60: IF NOT FND_API.COMPATIBLE_API_CALL ( l_api_version,
61: p_api_version,
62: l_api_name,
63: G_PKG_NAME) THEN
64: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
65: END IF;
66:
67: IF FND_API.to_Boolean (p_init_msg_list) THEN
68: FND_MSG_PUB.initialize;

Line 67: IF FND_API.to_Boolean (p_init_msg_list) THEN

63: G_PKG_NAME) THEN
64: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
65: END IF;
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 145: FND_API.G_FALSE,

141: -- for the reporting set of books.
142: -- -----------------------------------------------------------------------
143: IGC_CC_MC_HEADER_HST_PKG.Insert_Row (
144: l_api_version,
145: FND_API.G_FALSE,
146: FND_API.G_FALSE,
147: FND_API.G_VALID_LEVEL_FULL,
148: l_return_status,
149: X_msg_count,

Line 146: FND_API.G_FALSE,

142: -- -----------------------------------------------------------------------
143: IGC_CC_MC_HEADER_HST_PKG.Insert_Row (
144: l_api_version,
145: FND_API.G_FALSE,
146: FND_API.G_FALSE,
147: FND_API.G_VALID_LEVEL_FULL,
148: l_return_status,
149: X_msg_count,
150: X_msg_data,

Line 147: FND_API.G_VALID_LEVEL_FULL,

143: IGC_CC_MC_HEADER_HST_PKG.Insert_Row (
144: l_api_version,
145: FND_API.G_FALSE,
146: FND_API.G_FALSE,
147: FND_API.G_VALID_LEVEL_FULL,
148: l_return_status,
149: X_msg_count,
150: X_msg_data,
151: l_row_id,

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

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

Line 165: RAISE FND_API.G_EXC_ERROR;

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

Line 177: IF FND_API.To_Boolean ( p_commit ) THEN

173:
174: -- ------------------------------------------------------------------------
175: -- Only commit the information if the caller has requested it to be.
176: -- ------------------------------------------------------------------------
177: IF FND_API.To_Boolean ( p_commit ) THEN
178: COMMIT WORK;
179: END IF;
180:
181: -- ------------------------------------------------------------------------

Line 195: WHEN FND_API.G_EXC_ERROR THEN

191: RETURN;
192:
193: EXCEPTION
194:
195: WHEN FND_API.G_EXC_ERROR THEN
196:
197: ROLLBACK TO get_rsobs_Headers_PT;
198: X_return_status := FND_API.G_RET_STS_ERROR;
199: IF (c_conversion_type%ISOPEN) THEN

Line 198: X_return_status := FND_API.G_RET_STS_ERROR;

194:
195: WHEN FND_API.G_EXC_ERROR THEN
196:
197: ROLLBACK TO get_rsobs_Headers_PT;
198: X_return_status := FND_API.G_RET_STS_ERROR;
199: IF (c_conversion_type%ISOPEN) THEN
200: CLOSE c_conversion_type;
201: END IF;
202: FND_MSG_PUB.Count_And_Get (p_count => X_msg_count,

Line 205: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

201: END IF;
202: FND_MSG_PUB.Count_And_Get (p_count => X_msg_count,
203: p_data => X_msg_data);
204:
205: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
206:
207: ROLLBACK TO get_rsobs_Headers_PT;
208: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
209: IF (c_conversion_type%ISOPEN) THEN

Line 208: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

204:
205: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
206:
207: ROLLBACK TO get_rsobs_Headers_PT;
208: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
209: IF (c_conversion_type%ISOPEN) THEN
210: CLOSE c_conversion_type;
211: END IF;
212: FND_MSG_PUB.Count_And_Get (p_count => X_msg_count,

Line 218: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

214:
215: WHEN OTHERS THEN
216:
217: ROLLBACK TO get_rsobs_Headers_PT;
218: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
219: IF (c_conversion_type%ISOPEN) THEN
220: CLOSE c_conversion_type;
221: END IF;
222:

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

236: ===============================================================================*/
237:
238: PROCEDURE get_rsobs_Acct_Lines(
239: p_api_version IN NUMBER,
240: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
241: p_commit IN VARCHAR2 := FND_API.G_FALSE,
242: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
243: X_return_status OUT NOCOPY VARCHAR2,
244: x_msg_count OUT NOCOPY NUMBER,

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

237:
238: PROCEDURE get_rsobs_Acct_Lines(
239: p_api_version IN NUMBER,
240: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
241: p_commit IN VARCHAR2 := FND_API.G_FALSE,
242: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
243: X_return_status OUT NOCOPY VARCHAR2,
244: x_msg_count OUT NOCOPY NUMBER,
245: x_msg_data OUT NOCOPY VARCHAR2,

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

238: PROCEDURE get_rsobs_Acct_Lines(
239: p_api_version IN NUMBER,
240: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
241: p_commit IN VARCHAR2 := FND_API.G_FALSE,
242: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
243: X_return_status OUT NOCOPY VARCHAR2,
244: x_msg_count OUT NOCOPY NUMBER,
245: x_msg_data OUT NOCOPY VARCHAR2,
246: p_CC_Acct_Line_Id IN NUMBER,

Line 294: IF NOT FND_API.COMPATIBLE_API_CALL ( l_api_version,

290: BEGIN
291:
292: SAVEPOINT get_rsobs_Acct_Lines_PT;
293:
294: IF NOT FND_API.COMPATIBLE_API_CALL ( l_api_version,
295: p_api_version,
296: l_api_name,
297: G_PKG_NAME) THEN
298: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 298: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

294: IF NOT FND_API.COMPATIBLE_API_CALL ( l_api_version,
295: p_api_version,
296: l_api_name,
297: G_PKG_NAME) THEN
298: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
299: END IF;
300:
301: IF FND_API.to_Boolean (p_init_msg_list) THEN
302: FND_MSG_PUB.initialize;

Line 301: IF FND_API.to_Boolean (p_init_msg_list) THEN

297: G_PKG_NAME) THEN
298: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
299: END IF;
300:
301: IF FND_API.to_Boolean (p_init_msg_list) THEN
302: FND_MSG_PUB.initialize;
303: END IF;
304:
305: X_return_status := FND_API.G_RET_STS_SUCCESS;

Line 305: X_return_status := FND_API.G_RET_STS_SUCCESS;

301: IF FND_API.to_Boolean (p_init_msg_list) THEN
302: FND_MSG_PUB.initialize;
303: END IF;
304:
305: X_return_status := FND_API.G_RET_STS_SUCCESS;
306:
307: -- -------------------------------------------------------------------------
308: -- Obtain all sets of books associated to the Primary set of books ID
309: -- received from the caller.

Line 402: FND_API.G_FALSE,

398: -- books being processed.
399: -- -----------------------------------------------------------------------
400: IGC_CC_MC_ACCT_LINE_HST_PKG.Insert_Row (
401: l_api_version,
402: FND_API.G_FALSE,
403: FND_API.G_FALSE,
404: FND_API.G_VALID_LEVEL_FULL,
405: l_return_status,
406: X_msg_count,

Line 403: FND_API.G_FALSE,

399: -- -----------------------------------------------------------------------
400: IGC_CC_MC_ACCT_LINE_HST_PKG.Insert_Row (
401: l_api_version,
402: FND_API.G_FALSE,
403: FND_API.G_FALSE,
404: FND_API.G_VALID_LEVEL_FULL,
405: l_return_status,
406: X_msg_count,
407: X_msg_data,

Line 404: FND_API.G_VALID_LEVEL_FULL,

400: IGC_CC_MC_ACCT_LINE_HST_PKG.Insert_Row (
401: l_api_version,
402: FND_API.G_FALSE,
403: FND_API.G_FALSE,
404: FND_API.G_VALID_LEVEL_FULL,
405: l_return_status,
406: X_msg_count,
407: X_msg_data,
408: l_row_id,

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

420:
421: -- ------------------------------------------------------------------
422: -- Make sure that the insertion was a success
423: -- ------------------------------------------------------------------
424: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
425: RAISE FND_API.G_EXC_ERROR;
426: END IF;
427:
428: END IF; -- Rate exists

Line 425: RAISE FND_API.G_EXC_ERROR;

421: -- ------------------------------------------------------------------
422: -- Make sure that the insertion was a success
423: -- ------------------------------------------------------------------
424: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
425: RAISE FND_API.G_EXC_ERROR;
426: END IF;
427:
428: END IF; -- Rate exists
429:

Line 437: IF FND_API.To_Boolean ( p_commit ) THEN

433:
434: -- ------------------------------------------------------------------------
435: -- Only commit the information if the caller has requested it to be.
436: -- ------------------------------------------------------------------------
437: IF FND_API.To_Boolean ( p_commit ) THEN
438: COMMIT WORK;
439: END IF;
440:
441: -- ------------------------------------------------------------------------

Line 455: WHEN FND_API.G_EXC_ERROR THEN

451: RETURN;
452:
453: EXCEPTION
454:
455: WHEN FND_API.G_EXC_ERROR THEN
456:
457: ROLLBACK TO get_rsobs_Acct_Lines_PT;
458: X_return_status := FND_API.G_RET_STS_ERROR;
459: IF (c_conversion_type%ISOPEN) THEN

Line 458: X_return_status := FND_API.G_RET_STS_ERROR;

454:
455: WHEN FND_API.G_EXC_ERROR THEN
456:
457: ROLLBACK TO get_rsobs_Acct_Lines_PT;
458: X_return_status := FND_API.G_RET_STS_ERROR;
459: IF (c_conversion_type%ISOPEN) THEN
460: CLOSE c_conversion_type;
461: END IF;
462: FND_MSG_PUB.Count_And_Get (p_count => X_msg_count,

Line 465: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

461: END IF;
462: FND_MSG_PUB.Count_And_Get (p_count => X_msg_count,
463: p_data => X_msg_data);
464:
465: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
466:
467: ROLLBACK TO get_rsobs_Acct_Lines_PT;
468: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
469: IF (c_conversion_type%ISOPEN) THEN

Line 468: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

464:
465: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
466:
467: ROLLBACK TO get_rsobs_Acct_Lines_PT;
468: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
469: IF (c_conversion_type%ISOPEN) THEN
470: CLOSE c_conversion_type;
471: END IF;
472: FND_MSG_PUB.Count_And_Get (p_count => X_msg_count,

Line 478: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

474:
475: WHEN OTHERS THEN
476:
477: ROLLBACK TO get_rsobs_Acct_Lines_PT;
478: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
479: IF (c_conversion_type%ISOPEN) THEN
480: CLOSE c_conversion_type;
481: END IF;
482:

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

496: ===============================================================================*/
497:
498: PROCEDURE get_rsobs_DET_PF (
499: p_api_version IN NUMBER,
500: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
501: p_commit IN VARCHAR2 := FND_API.G_FALSE,
502: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
503: X_return_status OUT NOCOPY VARCHAR2,
504: x_msg_count OUT NOCOPY NUMBER,

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

497:
498: PROCEDURE get_rsobs_DET_PF (
499: p_api_version IN NUMBER,
500: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
501: p_commit IN VARCHAR2 := FND_API.G_FALSE,
502: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
503: X_return_status OUT NOCOPY VARCHAR2,
504: x_msg_count OUT NOCOPY NUMBER,
505: x_msg_data OUT NOCOPY VARCHAR2,

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

498: PROCEDURE get_rsobs_DET_PF (
499: p_api_version IN NUMBER,
500: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
501: p_commit IN VARCHAR2 := FND_API.G_FALSE,
502: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
503: X_return_status OUT NOCOPY VARCHAR2,
504: x_msg_count OUT NOCOPY NUMBER,
505: x_msg_data OUT NOCOPY VARCHAR2,
506: p_CC_DET_PF_Line_Id IN NUMBER,

Line 550: IF NOT FND_API.COMPATIBLE_API_CALL ( l_api_version,

546: BEGIN
547:
548: SAVEPOINT get_rsobs_DET_PF_PT;
549:
550: IF NOT FND_API.COMPATIBLE_API_CALL ( l_api_version,
551: p_api_version,
552: l_api_name,
553: G_PKG_NAME) THEN
554: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 554: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

550: IF NOT FND_API.COMPATIBLE_API_CALL ( l_api_version,
551: p_api_version,
552: l_api_name,
553: G_PKG_NAME) THEN
554: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
555: END IF;
556:
557: IF FND_API.to_Boolean (p_init_msg_list) THEN
558: FND_MSG_PUB.initialize;

Line 557: IF FND_API.to_Boolean (p_init_msg_list) THEN

553: G_PKG_NAME) THEN
554: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
555: END IF;
556:
557: IF FND_API.to_Boolean (p_init_msg_list) THEN
558: FND_MSG_PUB.initialize;
559: END IF;
560:
561: X_return_status := FND_API.G_RET_STS_SUCCESS;

Line 561: X_return_status := FND_API.G_RET_STS_SUCCESS;

557: IF FND_API.to_Boolean (p_init_msg_list) THEN
558: FND_MSG_PUB.initialize;
559: END IF;
560:
561: X_return_status := FND_API.G_RET_STS_SUCCESS;
562:
563: -- -------------------------------------------------------------------------
564: -- Obtain all sets of books associated to the Primary set of books ID
565: -- received from the caller.

Line 645: FND_API.G_FALSE,

641: -- of books being processed.
642: -- -----------------------------------------------------------------------
643: IGC_CC_MC_DET_PF_HST_PKG.Insert_Row (
644: l_api_version,
645: FND_API.G_FALSE,
646: FND_API.G_FALSE,
647: FND_API.G_VALID_LEVEL_FULL,
648: l_return_status,
649: X_msg_count,

Line 646: FND_API.G_FALSE,

642: -- -----------------------------------------------------------------------
643: IGC_CC_MC_DET_PF_HST_PKG.Insert_Row (
644: l_api_version,
645: FND_API.G_FALSE,
646: FND_API.G_FALSE,
647: FND_API.G_VALID_LEVEL_FULL,
648: l_return_status,
649: X_msg_count,
650: X_msg_data,

Line 647: FND_API.G_VALID_LEVEL_FULL,

643: IGC_CC_MC_DET_PF_HST_PKG.Insert_Row (
644: l_api_version,
645: FND_API.G_FALSE,
646: FND_API.G_FALSE,
647: FND_API.G_VALID_LEVEL_FULL,
648: l_return_status,
649: X_msg_count,
650: X_msg_data,
651: l_row_id,

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

662:
663: -- ------------------------------------------------------------------
664: -- Make sure that the insertion was a success
665: -- ------------------------------------------------------------------
666: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
667: RAISE FND_API.G_EXC_ERROR;
668: END IF;
669:
670: END IF; -- Rate exists

Line 667: RAISE FND_API.G_EXC_ERROR;

663: -- ------------------------------------------------------------------
664: -- Make sure that the insertion was a success
665: -- ------------------------------------------------------------------
666: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
667: RAISE FND_API.G_EXC_ERROR;
668: END IF;
669:
670: END IF; -- Rate exists
671:

Line 679: IF FND_API.To_Boolean ( p_commit ) THEN

675:
676: -- ------------------------------------------------------------------------
677: -- Only commit the information if the caller has requested it to be.
678: -- ------------------------------------------------------------------------
679: IF FND_API.To_Boolean ( p_commit ) THEN
680: COMMIT WORK;
681: END iF;
682:
683: -- ------------------------------------------------------------------------

Line 697: WHEN FND_API.G_EXC_ERROR THEN

693: RETURN;
694:
695: EXCEPTION
696:
697: WHEN FND_API.G_EXC_ERROR THEN
698: ROLLBACK TO SAVEPOINT get_rsobs_DET_PF_PT;
699: X_return_status := FND_API.G_RET_STS_ERROR;
700: IF (c_conversion_type%ISOPEN) THEN
701: CLOSE c_conversion_type;

Line 699: X_return_status := FND_API.G_RET_STS_ERROR;

695: EXCEPTION
696:
697: WHEN FND_API.G_EXC_ERROR THEN
698: ROLLBACK TO SAVEPOINT get_rsobs_DET_PF_PT;
699: X_return_status := FND_API.G_RET_STS_ERROR;
700: IF (c_conversion_type%ISOPEN) THEN
701: CLOSE c_conversion_type;
702: END IF;
703: FND_MSG_PUB.Count_And_Get (p_count => X_msg_count,

Line 706: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

702: END IF;
703: FND_MSG_PUB.Count_And_Get (p_count => X_msg_count,
704: p_data => X_msg_data);
705:
706: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
707: ROLLBACK TO SAVEPOINT get_rsobs_DET_PF_PT;
708: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
709: IF (c_conversion_type%ISOPEN) THEN
710: CLOSE c_conversion_type;

Line 708: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

704: p_data => X_msg_data);
705:
706: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
707: ROLLBACK TO SAVEPOINT get_rsobs_DET_PF_PT;
708: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
709: IF (c_conversion_type%ISOPEN) THEN
710: CLOSE c_conversion_type;
711: END IF;
712: FND_MSG_PUB.Count_And_Get (p_count => X_msg_count,

Line 717: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

713: p_data => X_msg_data);
714:
715: WHEN OTHERS THEN
716: ROLLBACK TO SAVEPOINT get_rsobs_DET_PF_PT;
717: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
718: IF (c_conversion_type%ISOPEN) THEN
719: CLOSE c_conversion_type;
720: END IF;
721: