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

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

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

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

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

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

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

Line 112: IF NOT FND_API.Compatible_API_Call ( l_api_version,

108: -- -----------------------------------------------------------------
109: -- Ensure that the version requested to be used is correct for
110: -- this API.
111: -- -----------------------------------------------------------------
112: IF NOT FND_API.Compatible_API_Call ( l_api_version,
113: p_api_version,
114: l_api_name,
115: G_PKG_NAME )
116: THEN

Line 117: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

113: p_api_version,
114: l_api_name,
115: G_PKG_NAME )
116: THEN
117: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
118: END IF;
119:
120:
121: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 121: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

117: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
118: END IF;
119:
120:
121: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
122: FND_MSG_PUB.initialize ;
123: END IF;
124:
125: X_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 125: X_return_status := FND_API.G_RET_STS_SUCCESS ;

121: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
122: FND_MSG_PUB.initialize ;
123: END IF;
124:
125: X_return_status := FND_API.G_RET_STS_SUCCESS ;
126:
127: -- -----------------------------------------------------------------
128: -- Insert the account line history record as requested.
129: -- -----------------------------------------------------------------

Line 244: RAISE FND_API.G_EXC_ERROR ;

240: -- -------------------------------------------------------------------
241: -- If no ROWID can be obtained then exit the procedure with a failure
242: -- -------------------------------------------------------------------
243: IF (C_acct_hst_row_id %NOTFOUND) then
244: RAISE FND_API.G_EXC_ERROR ;
245: END IF;
246:
247: CLOSE C_acct_hst_row_id ;
248:

Line 261: RAISE FND_API.G_EXC_ERROR;

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

Line 280: RAISE FND_API.G_EXC_ERROR;

276: -- ------------------------------------------------------------------
277: -- Exit procedure if the values can not be obtained.
278: -- ------------------------------------------------------------------
279: IF (c_cc_info%NOTFOUND) THEN
280: RAISE FND_API.G_EXC_ERROR;
281: END IF;
282:
283: CLOSE c_cc_info;
284:

Line 310: FND_API.G_FALSE,

306: -- the reporting set of books for this PRIMARY set of books.
307: -- ------------------------------------------------------------------
308: IGC_CC_MC_MAIN_HST_PVT.get_rsobs_ACCT_LINES (
309: l_api_version,
310: FND_API.G_FALSE,
311: FND_API.G_FALSE,
312: p_validation_level,
313: l_return_status,
314: X_msg_count,

Line 311: FND_API.G_FALSE,

307: -- ------------------------------------------------------------------
308: IGC_CC_MC_MAIN_HST_PVT.get_rsobs_ACCT_LINES (
309: l_api_version,
310: FND_API.G_FALSE,
311: FND_API.G_FALSE,
312: p_validation_level,
313: l_return_status,
314: X_msg_count,
315: X_msg_data,

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

327:
328: -- ------------------------------------------------------------------
329: -- Make sure that the insertion was a success
330: -- ------------------------------------------------------------------
331: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
332: RAISE FND_API.G_EXC_ERROR;
333: END IF;
334:
335: END IF;

Line 332: RAISE FND_API.G_EXC_ERROR;

328: -- ------------------------------------------------------------------
329: -- Make sure that the insertion was a success
330: -- ------------------------------------------------------------------
331: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
332: RAISE FND_API.G_EXC_ERROR;
333: END IF;
334:
335: END IF;
336:

Line 342: IF FND_API.To_Boolean ( p_commit ) THEN

338: -- If the records are to be commited in this procedure then
339: -- commit the work now otherwise wait for the caller to do COMMIT.
340: -- -----------------------------------------------------------------
341:
342: IF FND_API.To_Boolean ( p_commit ) THEN
343: COMMIT WORK;
344: END IF;
345:
346: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

Line 352: WHEN FND_API.G_EXC_ERROR THEN

348: RETURN;
349:
350: EXCEPTION
351:
352: WHEN FND_API.G_EXC_ERROR THEN
353:
354: ROLLBACK TO Insert_Row_Pvt ;
355: X_return_status := FND_API.G_RET_STS_ERROR;
356: IF (C_acct_hst_row_id %ISOPEN) THEN

Line 355: X_return_status := FND_API.G_RET_STS_ERROR;

351:
352: WHEN FND_API.G_EXC_ERROR THEN
353:
354: ROLLBACK TO Insert_Row_Pvt ;
355: X_return_status := FND_API.G_RET_STS_ERROR;
356: IF (C_acct_hst_row_id %ISOPEN) THEN
357: CLOSE C_acct_hst_row_id ;
358: END IF;
359: IF (c_igc_app_id%ISOPEN) THEN

Line 369: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

365:
366: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
367: p_data => X_msg_data );
368:
369: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
370:
371: ROLLBACK TO Insert_Row_Pvt ;
372: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
373: IF (C_acct_hst_row_id %ISOPEN) THEN

Line 372: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

368:
369: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
370:
371: ROLLBACK TO Insert_Row_Pvt ;
372: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
373: IF (C_acct_hst_row_id %ISOPEN) THEN
374: CLOSE C_acct_hst_row_id ;
375: END IF;
376: IF (c_igc_app_id%ISOPEN) THEN

Line 389: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

385:
386: WHEN OTHERS THEN
387:
388: ROLLBACK TO Insert_Row_Pvt ;
389: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
390: IF (C_acct_hst_row_id %ISOPEN) THEN
391: CLOSE C_acct_hst_row_id ;
392: END IF;
393: IF (c_igc_app_id%ISOPEN) THEN

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

415:
416:
417: PROCEDURE Lock_Row(
418: p_api_version IN NUMBER,
419: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
420: p_commit IN VARCHAR2 := FND_API.G_FALSE,
421: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
422: X_return_status OUT NOCOPY VARCHAR2,
423: X_msg_count OUT NOCOPY NUMBER,

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

416:
417: PROCEDURE Lock_Row(
418: p_api_version IN NUMBER,
419: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
420: p_commit IN VARCHAR2 := FND_API.G_FALSE,
421: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
422: X_return_status OUT NOCOPY VARCHAR2,
423: X_msg_count OUT NOCOPY NUMBER,
424: X_msg_data OUT NOCOPY VARCHAR2,

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

417: PROCEDURE Lock_Row(
418: p_api_version IN NUMBER,
419: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
420: p_commit IN VARCHAR2 := FND_API.G_FALSE,
421: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
422: X_return_status OUT NOCOPY VARCHAR2,
423: X_msg_count OUT NOCOPY NUMBER,
424: X_msg_data OUT NOCOPY VARCHAR2,
425: p_Rowid IN OUT NOCOPY VARCHAR2,

Line 494: IF NOT FND_API.Compatible_API_Call ( l_api_version,

490: BEGIN
491:
492: SAVEPOINT Lock_Row_Pvt ;
493:
494: IF NOT FND_API.Compatible_API_Call ( l_api_version,
495: p_api_version,
496: l_api_name,
497: G_PKG_NAME )
498: THEN

Line 499: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

495: p_api_version,
496: l_api_name,
497: G_PKG_NAME )
498: THEN
499: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
500: END IF;
501:
502:
503: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 503: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

499: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
500: END IF;
501:
502:
503: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
504: FND_MSG_PUB.initialize ;
505: END IF;
506:
507: X_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 507: X_return_status := FND_API.G_RET_STS_SUCCESS ;

503: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
504: FND_MSG_PUB.initialize ;
505: END IF;
506:
507: X_return_status := FND_API.G_RET_STS_SUCCESS ;
508: X_row_locked := FND_API.G_TRUE ;
509:
510: OPEN C;
511: FETCH C

Line 508: X_row_locked := FND_API.G_TRUE ;

504: FND_MSG_PUB.initialize ;
505: END IF;
506:
507: X_return_status := FND_API.G_RET_STS_SUCCESS ;
508: X_row_locked := FND_API.G_TRUE ;
509:
510: OPEN C;
511: FETCH C
512: INTO Recinfo;

Line 518: RAISE FND_API.G_EXC_ERROR ;

514: IF (C%NOTFOUND) THEN
515: CLOSE C;
516: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
517: FND_MSG_PUB.Add;
518: RAISE FND_API.G_EXC_ERROR ;
519: END IF;
520:
521: CLOSE C;
522: IF (

Line 650: RAISE FND_API.G_EXC_ERROR ;

646: ELSE
647:
648: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
649: FND_MSG_PUB.Add;
650: RAISE FND_API.G_EXC_ERROR ;
651: END IF;
652:
653: IF FND_API.To_Boolean ( p_commit ) THEN
654: COMMIT WORK;

Line 653: IF FND_API.To_Boolean ( p_commit ) THEN

649: FND_MSG_PUB.Add;
650: RAISE FND_API.G_EXC_ERROR ;
651: END IF;
652:
653: IF FND_API.To_Boolean ( p_commit ) THEN
654: COMMIT WORK;
655: END iF;
656:
657: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

Line 665: X_row_locked := FND_API.G_FALSE;

661:
662: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
663:
664: ROLLBACK TO Lock_Row_Pvt ;
665: X_row_locked := FND_API.G_FALSE;
666: X_return_status := FND_API.G_RET_STS_ERROR;
667: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
668: p_data => X_msg_data );
669:

Line 666: X_return_status := FND_API.G_RET_STS_ERROR;

662: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
663:
664: ROLLBACK TO Lock_Row_Pvt ;
665: X_row_locked := FND_API.G_FALSE;
666: X_return_status := FND_API.G_RET_STS_ERROR;
667: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
668: p_data => X_msg_data );
669:
670: WHEN FND_API.G_EXC_ERROR THEN

Line 670: WHEN FND_API.G_EXC_ERROR THEN

666: X_return_status := FND_API.G_RET_STS_ERROR;
667: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
668: p_data => X_msg_data );
669:
670: WHEN FND_API.G_EXC_ERROR THEN
671:
672: ROLLBACK TO Lock_Row_Pvt ;
673: X_return_status := FND_API.G_RET_STS_ERROR;
674: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

Line 673: X_return_status := FND_API.G_RET_STS_ERROR;

669:
670: WHEN FND_API.G_EXC_ERROR THEN
671:
672: ROLLBACK TO Lock_Row_Pvt ;
673: X_return_status := FND_API.G_RET_STS_ERROR;
674: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
675: p_data => X_msg_data );
676:
677: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 677: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

673: X_return_status := FND_API.G_RET_STS_ERROR;
674: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
675: p_data => X_msg_data );
676:
677: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
678:
679: ROLLBACK TO Lock_Row_Pvt ;
680: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
681: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

Line 680: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

676:
677: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
678:
679: ROLLBACK TO Lock_Row_Pvt ;
680: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
681: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
682: p_data => X_msg_data );
683:
684: WHEN OTHERS THEN

Line 687: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

683:
684: WHEN OTHERS THEN
685:
686: ROLLBACK TO Lock_Row_Pvt ;
687: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
688:
689: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
690: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
691: l_api_name);

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

702: ===============================================================================*/
703:
704: PROCEDURE Update_Row(
705: p_api_version IN NUMBER,
706: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
707: p_commit IN VARCHAR2 := FND_API.G_FALSE,
708: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
709: X_return_status OUT NOCOPY VARCHAR2,
710: X_msg_count OUT NOCOPY NUMBER,

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

703:
704: PROCEDURE Update_Row(
705: p_api_version IN NUMBER,
706: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
707: p_commit IN VARCHAR2 := FND_API.G_FALSE,
708: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
709: X_return_status OUT NOCOPY VARCHAR2,
710: X_msg_count OUT NOCOPY NUMBER,
711: X_msg_data OUT NOCOPY VARCHAR2,

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

704: PROCEDURE Update_Row(
705: p_api_version IN NUMBER,
706: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
707: p_commit IN VARCHAR2 := FND_API.G_FALSE,
708: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
709: X_return_status OUT NOCOPY VARCHAR2,
710: X_msg_count OUT NOCOPY NUMBER,
711: X_msg_data OUT NOCOPY VARCHAR2,
712: p_Rowid IN OUT NOCOPY VARCHAR2,

Line 771: IF NOT FND_API.Compatible_API_Call ( l_api_version,

767: BEGIN
768:
769: SAVEPOINT Update_Row_Pvt ;
770:
771: IF NOT FND_API.Compatible_API_Call ( l_api_version,
772: p_api_version,
773: l_api_name,
774: G_PKG_NAME )
775: THEN

Line 776: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

772: p_api_version,
773: l_api_name,
774: G_PKG_NAME )
775: THEN
776: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
777: END IF;
778:
779:
780: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 780: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

776: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
777: END IF;
778:
779:
780: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
781: FND_MSG_PUB.initialize ;
782: END IF;
783:
784: X_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 784: X_return_status := FND_API.G_RET_STS_SUCCESS ;

780: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
781: FND_MSG_PUB.initialize ;
782: END IF;
783:
784: X_return_status := FND_API.G_RET_STS_SUCCESS ;
785:
786: UPDATE IGC_CC_ACCT_LINE_HISTORY
787: SET CC_Acct_Line_Id = p_CC_Acct_Line_Id,
788: CC_Header_Id = p_CC_Header_Id,

Line 841: IF FND_API.To_Boolean ( p_commit ) THEN

837: IF (SQL%NOTFOUND) THEN
838: RAISE NO_DATA_FOUND;
839: END IF;
840:
841: IF FND_API.To_Boolean ( p_commit ) THEN
842: COMMIT WORK;
843: END iF;
844:
845: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

Line 850: WHEN FND_API.G_EXC_ERROR THEN

846: p_data => X_msg_data );
847:
848: EXCEPTION
849:
850: WHEN FND_API.G_EXC_ERROR THEN
851:
852: ROLLBACK TO Update_Row_Pvt ;
853: X_return_status := FND_API.G_RET_STS_ERROR;
854: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

Line 853: X_return_status := FND_API.G_RET_STS_ERROR;

849:
850: WHEN FND_API.G_EXC_ERROR THEN
851:
852: ROLLBACK TO Update_Row_Pvt ;
853: X_return_status := FND_API.G_RET_STS_ERROR;
854: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
855: p_data => X_msg_data );
856:
857: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 857: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

853: X_return_status := FND_API.G_RET_STS_ERROR;
854: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
855: p_data => X_msg_data );
856:
857: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
858:
859: ROLLBACK TO Update_Row_Pvt ;
860: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
861: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

Line 860: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

856:
857: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
858:
859: ROLLBACK TO Update_Row_Pvt ;
860: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
861: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
862: p_data => X_msg_data );
863:
864: WHEN OTHERS THEN

Line 867: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

863:
864: WHEN OTHERS THEN
865:
866: ROLLBACK TO Update_Row_Pvt ;
867: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
868:
869: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
870: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
871: l_api_name);

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

882: ===============================================================================*/
883:
884: PROCEDURE Delete_Row(
885: p_api_version IN NUMBER,
886: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
887: p_commit IN VARCHAR2 := FND_API.G_FALSE,
888: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
889: X_return_status OUT NOCOPY VARCHAR2,
890: X_msg_count OUT NOCOPY NUMBER,

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

883:
884: PROCEDURE Delete_Row(
885: p_api_version IN NUMBER,
886: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
887: p_commit IN VARCHAR2 := FND_API.G_FALSE,
888: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
889: X_return_status OUT NOCOPY VARCHAR2,
890: X_msg_count OUT NOCOPY NUMBER,
891: X_msg_data OUT NOCOPY VARCHAR2,

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

884: PROCEDURE Delete_Row(
885: p_api_version IN NUMBER,
886: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
887: p_commit IN VARCHAR2 := FND_API.G_FALSE,
888: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
889: X_return_status OUT NOCOPY VARCHAR2,
890: X_msg_count OUT NOCOPY NUMBER,
891: X_msg_data OUT NOCOPY VARCHAR2,
892: p_Rowid VARCHAR2,

Line 907: IF NOT FND_API.Compatible_API_Call ( l_api_version,

903: BEGIN
904:
905: SAVEPOINT Delete_Row_Pvt ;
906:
907: IF NOT FND_API.Compatible_API_Call ( l_api_version,
908: p_api_version,
909: l_api_name,
910: G_PKG_NAME )
911: THEN

Line 912: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

908: p_api_version,
909: l_api_name,
910: G_PKG_NAME )
911: THEN
912: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
913: END IF;
914:
915:
916: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 916: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

912: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
913: END IF;
914:
915:
916: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
917: FND_MSG_PUB.initialize ;
918: END IF ;
919:
920: X_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 920: X_return_status := FND_API.G_RET_STS_SUCCESS ;

916: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
917: FND_MSG_PUB.initialize ;
918: END IF ;
919:
920: X_return_status := FND_API.G_RET_STS_SUCCESS ;
921:
922: DELETE
923: FROM IGC_CC_ACCT_LINE_HISTORY
924: WHERE rowid = p_Rowid;

Line 930: IF FND_API.To_Boolean ( p_commit ) THEN

926: IF (SQL%NOTFOUND) THEN
927: RAISE NO_DATA_FOUND;
928: END IF;
929:
930: IF FND_API.To_Boolean ( p_commit ) THEN
931: COMMIT WORK;
932: END iF;
933:
934: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

Line 939: WHEN FND_API.G_EXC_ERROR THEN

935: p_data => X_msg_data );
936:
937: EXCEPTION
938:
939: WHEN FND_API.G_EXC_ERROR THEN
940:
941: ROLLBACK TO Delete_Row_Pvt ;
942: X_return_status := FND_API.G_RET_STS_ERROR;
943: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

Line 942: X_return_status := FND_API.G_RET_STS_ERROR;

938:
939: WHEN FND_API.G_EXC_ERROR THEN
940:
941: ROLLBACK TO Delete_Row_Pvt ;
942: X_return_status := FND_API.G_RET_STS_ERROR;
943: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
944: p_data => X_msg_data );
945:
946: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 946: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

942: X_return_status := FND_API.G_RET_STS_ERROR;
943: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
944: p_data => X_msg_data );
945:
946: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
947:
948: ROLLBACK TO Delete_Row_Pvt ;
949: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
950: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

Line 949: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

945:
946: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
947:
948: ROLLBACK TO Delete_Row_Pvt ;
949: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
950: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
951: p_data => X_msg_data );
952:
953: WHEN OTHERS THEN

Line 956: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

952:
953: WHEN OTHERS THEN
954:
955: ROLLBACK TO Delete_Row_Pvt ;
956: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
957:
958: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
959: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
960: l_api_name);