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

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

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

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

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

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

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

Line 105: IF NOT FND_API.Compatible_API_Call (l_api_version,

101: -- -----------------------------------------------------------------
102: -- Ensure that the version requested to be used is correct for
103: -- this API.
104: -- -----------------------------------------------------------------
105: IF NOT FND_API.Compatible_API_Call (l_api_version,
106: p_api_version,
107: l_api_name,
108: G_PKG_NAME )
109: THEN

Line 110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

106: p_api_version,
107: l_api_name,
108: G_PKG_NAME )
109: THEN
110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
111: END IF;
112:
113:
114: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 114: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
111: END IF;
112:
113:
114: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
115: FND_MSG_PUB.initialize ;
116: END IF;
117:
118: X_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 118: X_return_status := FND_API.G_RET_STS_SUCCESS ;

114: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
115: FND_MSG_PUB.initialize ;
116: END IF;
117:
118: X_return_status := FND_API.G_RET_STS_SUCCESS ;
119:
120: -- -----------------------------------------------------------------
121: -- Insert the CC Header History record as requested.
122: -- -----------------------------------------------------------------

Line 247: RAISE FND_API.G_EXC_ERROR ;

243: -- -------------------------------------------------------------------
244: -- If no ROWID can be obtained then exit the procedure with a failure
245: -- -------------------------------------------------------------------
246: IF (C_header_hst_rowid %NOTFOUND) THEN
247: RAISE FND_API.G_EXC_ERROR ;
248: END IF;
249:
250: CLOSE C_header_hst_rowid ;
251:

Line 264: RAISE FND_API.G_EXC_ERROR;

260: -- ------------------------------------------------------------------
261: -- If the application ID can not be attained then exit the procedure
262: -- ------------------------------------------------------------------
263: IF (c_igc_app_id%NOTFOUND) THEN
264: RAISE FND_API.G_EXC_ERROR;
265: END IF;
266:
267: CLOSE c_igc_app_id;
268:

Line 293: FND_API.G_FALSE,

289: -- the reporting set of books for this PRIMARY set of books.
290: -- ------------------------------------------------------------------
291: IGC_CC_MC_MAIN_HST_PVT.get_rsobs_Headers(
292: l_api_version,
293: FND_API.G_FALSE,
294: FND_API.G_FALSE,
295: p_validation_level,
296: l_return_status,
297: X_msg_count,

Line 294: FND_API.G_FALSE,

290: -- ------------------------------------------------------------------
291: IGC_CC_MC_MAIN_HST_PVT.get_rsobs_Headers(
292: l_api_version,
293: FND_API.G_FALSE,
294: FND_API.G_FALSE,
295: p_validation_level,
296: l_return_status,
297: X_msg_count,
298: X_msg_data,

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

306:
307: -- ------------------------------------------------------------------
308: -- Make sure that the insertion was a success
309: -- ------------------------------------------------------------------
310: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
311: RAISE FND_API.G_EXC_ERROR;
312: END IF;
313:
314: END IF;

Line 311: RAISE FND_API.G_EXC_ERROR;

307: -- ------------------------------------------------------------------
308: -- Make sure that the insertion was a success
309: -- ------------------------------------------------------------------
310: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
311: RAISE FND_API.G_EXC_ERROR;
312: END IF;
313:
314: END IF;
315:

Line 320: IF FND_API.To_Boolean ( p_commit ) THEN

316: -- -----------------------------------------------------------------
317: -- If the records are to be commited in this procedure then
318: -- commit the work now otherwise wait for the caller to do COMMIT.
319: -- -----------------------------------------------------------------
320: IF FND_API.To_Boolean ( p_commit ) THEN
321: COMMIT WORK;
322: END iF;
323:
324: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

Line 331: WHEN FND_API.G_EXC_ERROR THEN

327: RETURN;
328:
329: EXCEPTION
330:
331: WHEN FND_API.G_EXC_ERROR THEN
332:
333: ROLLBACK TO Insert_Row_Pvt ;
334: X_return_status := FND_API.G_RET_STS_ERROR;
335: IF (C_header_hst_rowid %ISOPEN) THEN

Line 334: X_return_status := FND_API.G_RET_STS_ERROR;

330:
331: WHEN FND_API.G_EXC_ERROR THEN
332:
333: ROLLBACK TO Insert_Row_Pvt ;
334: X_return_status := FND_API.G_RET_STS_ERROR;
335: IF (C_header_hst_rowid %ISOPEN) THEN
336: CLOSE C_header_hst_rowid ;
337: END IF;
338: IF (c_igc_app_id%ISOPEN) THEN

Line 345: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

341:
342: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
343: p_data => X_msg_data );
344:
345: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
346:
347: ROLLBACK TO Insert_Row_Pvt ;
348: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
349: IF (C_header_hst_rowid %ISOPEN) THEN

Line 348: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

344:
345: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
346:
347: ROLLBACK TO Insert_Row_Pvt ;
348: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
349: IF (C_header_hst_rowid %ISOPEN) THEN
350: CLOSE C_header_hst_rowid ;
351: END IF;
352: IF (c_igc_app_id%ISOPEN) THEN

Line 362: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

358:
359: WHEN OTHERS THEN
360:
361: ROLLBACK TO Insert_Row_Pvt ;
362: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
363: IF (C_header_hst_rowid %ISOPEN) THEN
364: CLOSE C_header_hst_rowid ;
365: END IF;
366: IF (c_igc_app_id%ISOPEN) THEN

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

383: ===============================================================================*/
384:
385: PROCEDURE Insert_Row(
386: p_api_version IN NUMBER,
387: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
388: p_commit IN VARCHAR2 := FND_API.G_FALSE,
389: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
390: X_return_status OUT NOCOPY VARCHAR2,
391: X_msg_count OUT NOCOPY NUMBER,

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

384:
385: PROCEDURE Insert_Row(
386: p_api_version IN NUMBER,
387: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
388: p_commit IN VARCHAR2 := FND_API.G_FALSE,
389: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
390: X_return_status OUT NOCOPY VARCHAR2,
391: X_msg_count OUT NOCOPY NUMBER,
392: X_msg_data OUT NOCOPY VARCHAR2,

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

385: PROCEDURE Insert_Row(
386: p_api_version IN NUMBER,
387: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
388: p_commit IN VARCHAR2 := FND_API.G_FALSE,
389: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
390: X_return_status OUT NOCOPY VARCHAR2,
391: X_msg_count OUT NOCOPY NUMBER,
392: X_msg_data OUT NOCOPY VARCHAR2,
393: p_Rowid IN OUT NOCOPY VARCHAR2,

Line 477: IF NOT FND_API.Compatible_API_Call (l_api_version,

473: -- -----------------------------------------------------------------
474: -- Ensure that the version requested to be used is correct for
475: -- this API.
476: -- -----------------------------------------------------------------
477: IF NOT FND_API.Compatible_API_Call (l_api_version,
478: p_api_version,
479: l_api_name,
480: G_PKG_NAME )
481: THEN

Line 482: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

478: p_api_version,
479: l_api_name,
480: G_PKG_NAME )
481: THEN
482: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
483: END IF;
484:
485:
486: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 486: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

482: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
483: END IF;
484:
485:
486: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
487: FND_MSG_PUB.initialize ;
488: END IF;
489:
490: X_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 490: X_return_status := FND_API.G_RET_STS_SUCCESS ;

486: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
487: FND_MSG_PUB.initialize ;
488: END IF;
489:
490: X_return_status := FND_API.G_RET_STS_SUCCESS ;
491:
492: -- -----------------------------------------------------------------
493: -- Insert the CC Header History record as requested.
494: -- -----------------------------------------------------------------

Line 617: RAISE FND_API.G_EXC_ERROR ;

613: -- -------------------------------------------------------------------
614: -- If no ROWID can be obtained then exit the procedure with a failure
615: -- -------------------------------------------------------------------
616: IF (C_header_hst_rowid %NOTFOUND) THEN
617: RAISE FND_API.G_EXC_ERROR ;
618: END IF;
619:
620: CLOSE C_header_hst_rowid ;
621:

Line 634: RAISE FND_API.G_EXC_ERROR;

630: -- ------------------------------------------------------------------
631: -- If the application ID can not be attained then exit the procedure
632: -- ------------------------------------------------------------------
633: IF (c_igc_app_id%NOTFOUND) THEN
634: RAISE FND_API.G_EXC_ERROR;
635: END IF;
636:
637: CLOSE c_igc_app_id;
638:

Line 663: FND_API.G_FALSE,

659: -- the reporting set of books for this PRIMARY set of books.
660: -- ------------------------------------------------------------------
661: IGC_CC_MC_MAIN_HST_PVT.get_rsobs_Headers(
662: l_api_version,
663: FND_API.G_FALSE,
664: FND_API.G_FALSE,
665: p_validation_level,
666: l_return_status,
667: X_msg_count,

Line 664: FND_API.G_FALSE,

660: -- ------------------------------------------------------------------
661: IGC_CC_MC_MAIN_HST_PVT.get_rsobs_Headers(
662: l_api_version,
663: FND_API.G_FALSE,
664: FND_API.G_FALSE,
665: p_validation_level,
666: l_return_status,
667: X_msg_count,
668: X_msg_data,

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

676:
677: -- ------------------------------------------------------------------
678: -- Make sure that the insertion was a success
679: -- ------------------------------------------------------------------
680: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
681: RAISE FND_API.G_EXC_ERROR;
682: END IF;
683:
684: END IF;

Line 681: RAISE FND_API.G_EXC_ERROR;

677: -- ------------------------------------------------------------------
678: -- Make sure that the insertion was a success
679: -- ------------------------------------------------------------------
680: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
681: RAISE FND_API.G_EXC_ERROR;
682: END IF;
683:
684: END IF;
685:

Line 690: IF FND_API.To_Boolean ( p_commit ) THEN

686: -- -----------------------------------------------------------------
687: -- If the records are to be commited in this procedure then
688: -- commit the work now otherwise wait for the caller to do COMMIT.
689: -- -----------------------------------------------------------------
690: IF FND_API.To_Boolean ( p_commit ) THEN
691: COMMIT WORK;
692: END iF;
693:
694: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

Line 701: WHEN FND_API.G_EXC_ERROR THEN

697: RETURN;
698:
699: EXCEPTION
700:
701: WHEN FND_API.G_EXC_ERROR THEN
702:
703: ROLLBACK TO Insert_Row_Pvt ;
704: X_return_status := FND_API.G_RET_STS_ERROR;
705: IF (C_header_hst_rowid %ISOPEN) THEN

Line 704: X_return_status := FND_API.G_RET_STS_ERROR;

700:
701: WHEN FND_API.G_EXC_ERROR THEN
702:
703: ROLLBACK TO Insert_Row_Pvt ;
704: X_return_status := FND_API.G_RET_STS_ERROR;
705: IF (C_header_hst_rowid %ISOPEN) THEN
706: CLOSE C_header_hst_rowid ;
707: END IF;
708: IF (c_igc_app_id%ISOPEN) THEN

Line 715: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

711:
712: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
713: p_data => X_msg_data );
714:
715: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
716:
717: ROLLBACK TO Insert_Row_Pvt ;
718: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
719: IF (C_header_hst_rowid %ISOPEN) THEN

Line 718: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

714:
715: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
716:
717: ROLLBACK TO Insert_Row_Pvt ;
718: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
719: IF (C_header_hst_rowid %ISOPEN) THEN
720: CLOSE C_header_hst_rowid ;
721: END IF;
722: IF (c_igc_app_id%ISOPEN) THEN

Line 732: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

728:
729: WHEN OTHERS THEN
730:
731: ROLLBACK TO Insert_Row_Pvt ;
732: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
733: IF (C_header_hst_rowid %ISOPEN) THEN
734: CLOSE C_header_hst_rowid ;
735: END IF;
736: IF (c_igc_app_id%ISOPEN) THEN

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

753: ===============================================================================*/
754:
755: PROCEDURE Lock_Row(
756: p_api_version IN NUMBER,
757: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
758: p_commit IN VARCHAR2 := FND_API.G_FALSE,
759: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
760: X_return_status OUT NOCOPY VARCHAR2,
761: X_msg_count OUT NOCOPY NUMBER,

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

754:
755: PROCEDURE Lock_Row(
756: p_api_version IN NUMBER,
757: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
758: p_commit IN VARCHAR2 := FND_API.G_FALSE,
759: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
760: X_return_status OUT NOCOPY VARCHAR2,
761: X_msg_count OUT NOCOPY NUMBER,
762: X_msg_data OUT NOCOPY VARCHAR2,

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

755: PROCEDURE Lock_Row(
756: p_api_version IN NUMBER,
757: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
758: p_commit IN VARCHAR2 := FND_API.G_FALSE,
759: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
760: X_return_status OUT NOCOPY VARCHAR2,
761: X_msg_count OUT NOCOPY NUMBER,
762: X_msg_data OUT NOCOPY VARCHAR2,
763: p_Rowid IN OUT NOCOPY VARCHAR2,

Line 836: IF NOT FND_API.Compatible_API_Call ( l_api_version,

832: BEGIN
833:
834: SAVEPOINT Lock_Row_Pvt ;
835:
836: IF NOT FND_API.Compatible_API_Call ( l_api_version,
837: p_api_version,
838: l_api_name,
839: G_PKG_NAME )
840: THEN

Line 841: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

837: p_api_version,
838: l_api_name,
839: G_PKG_NAME )
840: THEN
841: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
842: END IF;
843:
844:
845: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 845: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

841: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
842: END IF;
843:
844:
845: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
846: FND_MSG_PUB.initialize ;
847: END IF;
848:
849: X_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 849: X_return_status := FND_API.G_RET_STS_SUCCESS ;

845: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
846: FND_MSG_PUB.initialize ;
847: END IF;
848:
849: X_return_status := FND_API.G_RET_STS_SUCCESS ;
850: X_row_locked := FND_API.G_TRUE ;
851:
852:
853: OPEN C;

Line 850: X_row_locked := FND_API.G_TRUE ;

846: FND_MSG_PUB.initialize ;
847: END IF;
848:
849: X_return_status := FND_API.G_RET_STS_SUCCESS ;
850: X_row_locked := FND_API.G_TRUE ;
851:
852:
853: OPEN C;
854: FETCH C

Line 861: RAISE FND_API.G_EXC_ERROR ;

857: IF (C%NOTFOUND) THEN
858: CLOSE C;
859: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
860: FND_MSG_PUB.Add;
861: RAISE FND_API.G_EXC_ERROR ;
862: END IF;
863:
864: CLOSE C;
865:

Line 1005: RAISE FND_API.G_EXC_ERROR ;

1001: ELSE
1002:
1003: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
1004: FND_MSG_PUB.Add;
1005: RAISE FND_API.G_EXC_ERROR ;
1006:
1007: END IF;
1008:
1009: IF FND_API.To_Boolean ( p_commit ) THEN

Line 1009: IF FND_API.To_Boolean ( p_commit ) THEN

1005: RAISE FND_API.G_EXC_ERROR ;
1006:
1007: END IF;
1008:
1009: IF FND_API.To_Boolean ( p_commit ) THEN
1010: COMMIT WORK;
1011: END iF;
1012:
1013: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

Line 1023: X_row_locked := FND_API.G_FALSE;

1019:
1020: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
1021:
1022: ROLLBACK TO Lock_Row_Pvt ;
1023: X_row_locked := FND_API.G_FALSE;
1024: X_return_status := FND_API.G_RET_STS_ERROR;
1025: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
1026: p_data => X_msg_data );
1027:

Line 1024: X_return_status := FND_API.G_RET_STS_ERROR;

1020: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
1021:
1022: ROLLBACK TO Lock_Row_Pvt ;
1023: X_row_locked := FND_API.G_FALSE;
1024: X_return_status := FND_API.G_RET_STS_ERROR;
1025: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
1026: p_data => X_msg_data );
1027:
1028: WHEN FND_API.G_EXC_ERROR THEN

Line 1028: WHEN FND_API.G_EXC_ERROR THEN

1024: X_return_status := FND_API.G_RET_STS_ERROR;
1025: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
1026: p_data => X_msg_data );
1027:
1028: WHEN FND_API.G_EXC_ERROR THEN
1029:
1030: ROLLBACK TO Lock_Row_Pvt ;
1031: X_return_status := FND_API.G_RET_STS_ERROR;
1032: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

Line 1031: X_return_status := FND_API.G_RET_STS_ERROR;

1027:
1028: WHEN FND_API.G_EXC_ERROR THEN
1029:
1030: ROLLBACK TO Lock_Row_Pvt ;
1031: X_return_status := FND_API.G_RET_STS_ERROR;
1032: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
1033: p_data => X_msg_data );
1034:
1035: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1035: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1031: X_return_status := FND_API.G_RET_STS_ERROR;
1032: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
1033: p_data => X_msg_data );
1034:
1035: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1036:
1037: ROLLBACK TO Lock_Row_Pvt ;
1038: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1039: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

Line 1038: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1034:
1035: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1036:
1037: ROLLBACK TO Lock_Row_Pvt ;
1038: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1039: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
1040: p_data => X_msg_data );
1041:
1042: WHEN OTHERS THEN

Line 1045: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1041:
1042: WHEN OTHERS THEN
1043:
1044: ROLLBACK TO Lock_Row_Pvt ;
1045: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1046:
1047: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1048: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
1049: l_api_name);

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

1059: ===============================================================================*/
1060:
1061: PROCEDURE Update_Row(
1062: p_api_version IN NUMBER,
1063: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1064: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1065: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1066: X_return_status OUT NOCOPY VARCHAR2,
1067: X_msg_count OUT NOCOPY NUMBER,

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

1060:
1061: PROCEDURE Update_Row(
1062: p_api_version IN NUMBER,
1063: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1064: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1065: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1066: X_return_status OUT NOCOPY VARCHAR2,
1067: X_msg_count OUT NOCOPY NUMBER,
1068: X_msg_data OUT NOCOPY VARCHAR2,

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

1061: PROCEDURE Update_Row(
1062: p_api_version IN NUMBER,
1063: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1064: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1065: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1066: X_return_status OUT NOCOPY VARCHAR2,
1067: X_msg_count OUT NOCOPY NUMBER,
1068: X_msg_data OUT NOCOPY VARCHAR2,
1069: p_Rowid IN OUT NOCOPY VARCHAR2,

Line 1133: IF NOT FND_API.Compatible_API_Call ( l_api_version,

1129: BEGIN
1130:
1131: SAVEPOINT Update_Row_Pvt ;
1132:
1133: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1134: p_api_version,
1135: l_api_name,
1136: G_PKG_NAME )
1137: THEN

Line 1138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1134: p_api_version,
1135: l_api_name,
1136: G_PKG_NAME )
1137: THEN
1138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1139: END IF;
1140:
1141:
1142: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 1142: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

1138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1139: END IF;
1140:
1141:
1142: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
1143: FND_MSG_PUB.initialize ;
1144: END IF;
1145:
1146: X_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 1146: X_return_status := FND_API.G_RET_STS_SUCCESS ;

1142: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
1143: FND_MSG_PUB.initialize ;
1144: END IF;
1145:
1146: X_return_status := FND_API.G_RET_STS_SUCCESS ;
1147:
1148: UPDATE IGC_CC_HEADER_HISTORY
1149: SET CC_Header_Id = p_CC_Header_Id,
1150: Parent_Header_Id = p_Parent_Header_Id,

Line 1208: IF FND_API.To_Boolean ( p_commit ) THEN

1204: IF (SQL%NOTFOUND) THEN
1205: Raise NO_DATA_FOUND;
1206: END IF;
1207:
1208: IF FND_API.To_Boolean ( p_commit ) THEN
1209: COMMIT WORK;
1210: END IF;
1211:
1212: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

Line 1217: WHEN FND_API.G_EXC_ERROR THEN

1213: p_data => X_msg_data );
1214:
1215: EXCEPTION
1216:
1217: WHEN FND_API.G_EXC_ERROR THEN
1218:
1219: ROLLBACK TO Update_Row_Pvt ;
1220: X_return_status := FND_API.G_RET_STS_ERROR;
1221: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

Line 1220: X_return_status := FND_API.G_RET_STS_ERROR;

1216:
1217: WHEN FND_API.G_EXC_ERROR THEN
1218:
1219: ROLLBACK TO Update_Row_Pvt ;
1220: X_return_status := FND_API.G_RET_STS_ERROR;
1221: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
1222: p_data => X_msg_data );
1223:
1224: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1224: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1220: X_return_status := FND_API.G_RET_STS_ERROR;
1221: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
1222: p_data => X_msg_data );
1223:
1224: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1225:
1226: ROLLBACK TO Update_Row_Pvt ;
1227: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1228: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

Line 1227: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1223:
1224: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1225:
1226: ROLLBACK TO Update_Row_Pvt ;
1227: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1228: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
1229: p_data => X_msg_data );
1230:
1231: WHEN OTHERS THEN

Line 1234: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1230:
1231: WHEN OTHERS THEN
1232:
1233: ROLLBACK TO Update_Row_Pvt ;
1234: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1235:
1236: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1237: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
1238: l_api_name);

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

1249: ===============================================================================*/
1250:
1251: PROCEDURE Update_Row(
1252: p_api_version IN NUMBER,
1253: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1254: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1255: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1256: X_return_status OUT NOCOPY VARCHAR2,
1257: X_msg_count OUT NOCOPY NUMBER,

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

1250:
1251: PROCEDURE Update_Row(
1252: p_api_version IN NUMBER,
1253: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1254: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1255: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1256: X_return_status OUT NOCOPY VARCHAR2,
1257: X_msg_count OUT NOCOPY NUMBER,
1258: X_msg_data OUT NOCOPY VARCHAR2,

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

1251: PROCEDURE Update_Row(
1252: p_api_version IN NUMBER,
1253: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1254: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1255: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1256: X_return_status OUT NOCOPY VARCHAR2,
1257: X_msg_count OUT NOCOPY NUMBER,
1258: X_msg_data OUT NOCOPY VARCHAR2,
1259: p_Rowid IN OUT NOCOPY VARCHAR2,

Line 1323: IF NOT FND_API.Compatible_API_Call ( l_api_version,

1319: BEGIN
1320:
1321: SAVEPOINT Update_Row_Pvt ;
1322:
1323: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1324: p_api_version,
1325: l_api_name,
1326: G_PKG_NAME )
1327: THEN

Line 1328: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1324: p_api_version,
1325: l_api_name,
1326: G_PKG_NAME )
1327: THEN
1328: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1329: END IF;
1330:
1331:
1332: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 1332: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

1328: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1329: END IF;
1330:
1331:
1332: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
1333: FND_MSG_PUB.initialize ;
1334: END IF;
1335:
1336: X_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 1336: X_return_status := FND_API.G_RET_STS_SUCCESS ;

1332: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
1333: FND_MSG_PUB.initialize ;
1334: END IF;
1335:
1336: X_return_status := FND_API.G_RET_STS_SUCCESS ;
1337:
1338: UPDATE IGC_CC_HEADER_HISTORY
1339: SET CC_Header_Id = p_CC_Header_Id,
1340: Parent_Header_Id = p_Parent_Header_Id,

Line 1397: IF FND_API.To_Boolean ( p_commit ) THEN

1393: IF (SQL%NOTFOUND) THEN
1394: Raise NO_DATA_FOUND;
1395: END IF;
1396:
1397: IF FND_API.To_Boolean ( p_commit ) THEN
1398: COMMIT WORK;
1399: END iF;
1400:
1401: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

Line 1406: WHEN FND_API.G_EXC_ERROR THEN

1402: p_data => X_msg_data );
1403:
1404: EXCEPTION
1405:
1406: WHEN FND_API.G_EXC_ERROR THEN
1407:
1408: ROLLBACK TO Update_Row_Pvt ;
1409: X_return_status := FND_API.G_RET_STS_ERROR;
1410: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

Line 1409: X_return_status := FND_API.G_RET_STS_ERROR;

1405:
1406: WHEN FND_API.G_EXC_ERROR THEN
1407:
1408: ROLLBACK TO Update_Row_Pvt ;
1409: X_return_status := FND_API.G_RET_STS_ERROR;
1410: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
1411: p_data => X_msg_data );
1412:
1413: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1413: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1409: X_return_status := FND_API.G_RET_STS_ERROR;
1410: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
1411: p_data => X_msg_data );
1412:
1413: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1414:
1415: ROLLBACK TO Update_Row_Pvt ;
1416: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1417: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

Line 1416: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1412:
1413: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1414:
1415: ROLLBACK TO Update_Row_Pvt ;
1416: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1417: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
1418: p_data => X_msg_data );
1419:
1420: WHEN OTHERS THEN

Line 1423: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1419:
1420: WHEN OTHERS THEN
1421:
1422: ROLLBACK TO Update_Row_Pvt ;
1423: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1424:
1425: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1426: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
1427: l_api_name);

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

1438: ===============================================================================*/
1439:
1440: PROCEDURE Delete_Row(
1441: p_api_version IN NUMBER,
1442: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1443: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1444: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1445: X_return_status OUT NOCOPY VARCHAR2,
1446: X_msg_count OUT NOCOPY NUMBER,

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

1439:
1440: PROCEDURE Delete_Row(
1441: p_api_version IN NUMBER,
1442: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1443: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1444: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1445: X_return_status OUT NOCOPY VARCHAR2,
1446: X_msg_count OUT NOCOPY NUMBER,
1447: X_msg_data OUT NOCOPY VARCHAR2,

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

1440: PROCEDURE Delete_Row(
1441: p_api_version IN NUMBER,
1442: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1443: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1444: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1445: X_return_status OUT NOCOPY VARCHAR2,
1446: X_msg_count OUT NOCOPY NUMBER,
1447: X_msg_data OUT NOCOPY VARCHAR2,
1448: p_Rowid VARCHAR2,

Line 1462: IF NOT FND_API.Compatible_API_Call ( l_api_version,

1458: BEGIN
1459:
1460: SAVEPOINT Delete_Row_Pvt ;
1461:
1462: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1463: p_api_version,
1464: l_api_name,
1465: G_PKG_NAME )
1466: THEN

Line 1467: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1463: p_api_version,
1464: l_api_name,
1465: G_PKG_NAME )
1466: THEN
1467: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1468: END IF;
1469:
1470: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
1471: FND_MSG_PUB.initialize ;

Line 1470: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

1466: THEN
1467: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1468: END IF;
1469:
1470: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
1471: FND_MSG_PUB.initialize ;
1472: END IF ;
1473:
1474: X_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 1474: X_return_status := FND_API.G_RET_STS_SUCCESS ;

1470: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
1471: FND_MSG_PUB.initialize ;
1472: END IF ;
1473:
1474: X_return_status := FND_API.G_RET_STS_SUCCESS ;
1475:
1476: DELETE
1477: FROM IGC_CC_HEADER_HISTORY
1478: WHERE rowid = p_Rowid;

Line 1484: IF FND_API.To_Boolean ( p_commit ) THEN

1480: IF (SQL%NOTFOUND) THEN
1481: Raise NO_DATA_FOUND;
1482: END IF;
1483:
1484: IF FND_API.To_Boolean ( p_commit ) THEN
1485: COMMIT WORK;
1486: END iF;
1487:
1488: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

Line 1493: WHEN FND_API.G_EXC_ERROR THEN

1489: p_data => X_msg_data );
1490:
1491: EXCEPTION
1492:
1493: WHEN FND_API.G_EXC_ERROR THEN
1494:
1495: ROLLBACK TO Delete_Row_Pvt ;
1496: X_return_status := FND_API.G_RET_STS_ERROR;
1497: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

Line 1496: X_return_status := FND_API.G_RET_STS_ERROR;

1492:
1493: WHEN FND_API.G_EXC_ERROR THEN
1494:
1495: ROLLBACK TO Delete_Row_Pvt ;
1496: X_return_status := FND_API.G_RET_STS_ERROR;
1497: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
1498: p_data => X_msg_data );
1499:
1500: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1500: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1496: X_return_status := FND_API.G_RET_STS_ERROR;
1497: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
1498: p_data => X_msg_data );
1499:
1500: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1501:
1502: ROLLBACK TO Delete_Row_Pvt ;
1503: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1504: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

Line 1503: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1499:
1500: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1501:
1502: ROLLBACK TO Delete_Row_Pvt ;
1503: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1504: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
1505: p_data => X_msg_data );
1506:
1507: WHEN OTHERS THEN

Line 1510: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1506:
1507: WHEN OTHERS THEN
1508:
1509: ROLLBACK TO Delete_Row_Pvt ;
1510: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1511:
1512: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1513: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
1514: l_api_name);