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

Line 49: IF (l_Return_Status <> FND_API.G_RET_STS_SUCCESS) THEN

45: p_filename_val => NULL,
46: x_Return_Status => l_Return_Status
47: );
48:
49: IF (l_Return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
50: raise FND_API.G_EXC_ERROR;
51: END IF;*/
52:
53: IF(g_state_level >= g_debug_level) THEN

Line 50: raise FND_API.G_EXC_ERROR;

46: x_Return_Status => l_Return_Status
47: );
48:
49: IF (l_Return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
50: raise FND_API.G_EXC_ERROR;
51: END IF;*/
52:
53: IF(g_state_level >= g_debug_level) THEN
54: FND_LOG.STRING(g_state_level, p_path, p_debug_msg);

Line 64: /*WHEN FND_API.G_EXC_ERROR THEN

60: -- Exception handler section for the Output_Debug procedure.
61: -- --------------------------------------------------------------------
62: EXCEPTION
63:
64: /*WHEN FND_API.G_EXC_ERROR THEN
65: RETURN;*/
66:
67: WHEN OTHERS THEN
68: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

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

78: ===============================================================================*/
79:
80: PROCEDURE Insert_Row(
81: p_api_version IN NUMBER,
82: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
83: p_commit IN VARCHAR2 := FND_API.G_FALSE,
84: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
85: X_return_status OUT NOCOPY VARCHAR2,
86: X_msg_count OUT NOCOPY NUMBER,

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

79:
80: PROCEDURE Insert_Row(
81: p_api_version IN NUMBER,
82: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
83: p_commit IN VARCHAR2 := FND_API.G_FALSE,
84: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
85: X_return_status OUT NOCOPY VARCHAR2,
86: X_msg_count OUT NOCOPY NUMBER,
87: X_msg_data OUT NOCOPY VARCHAR2,

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

80: PROCEDURE Insert_Row(
81: p_api_version IN NUMBER,
82: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
83: p_commit IN VARCHAR2 := FND_API.G_FALSE,
84: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
85: X_return_status OUT NOCOPY VARCHAR2,
86: X_msg_count OUT NOCOPY NUMBER,
87: X_msg_data OUT NOCOPY VARCHAR2,
88: p_Rowid IN OUT NOCOPY VARCHAR2,

Line 189: IF NOT FND_API.Compatible_API_Call ( l_api_version,

185: -- -----------------------------------------------------------------
186: -- Ensure that the version requested to be used is correct for
187: -- this API.
188: -- -----------------------------------------------------------------
189: IF NOT FND_API.Compatible_API_Call ( l_api_version,
190: p_api_version,
191: l_api_name,
192: G_PKG_NAME )
193: THEN

Line 194: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

190: p_api_version,
191: l_api_name,
192: G_PKG_NAME )
193: THEN
194: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
195: END IF;
196:
197: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
198: FND_MSG_PUB.initialize ;

Line 197: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

193: THEN
194: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
195: END IF;
196:
197: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
198: FND_MSG_PUB.initialize ;
199: END IF;
200:
201:

Line 202: X_return_status := FND_API.G_RET_STS_SUCCESS ;

198: FND_MSG_PUB.initialize ;
199: END IF;
200:
201:
202: X_return_status := FND_API.G_RET_STS_SUCCESS ;
203: -- l_debug := FND_PROFILE.VALUE('IGC_DEBUG_ENABLED');
204:
205: -- IF (l_debug = 'Y') THEN
206: -- l_debug := FND_API.G_TRUE;

Line 206: -- l_debug := FND_API.G_TRUE;

202: X_return_status := FND_API.G_RET_STS_SUCCESS ;
203: -- l_debug := FND_PROFILE.VALUE('IGC_DEBUG_ENABLED');
204:
205: -- IF (l_debug = 'Y') THEN
206: -- l_debug := FND_API.G_TRUE;
207: -- ELSE
208: -- l_debug := FND_API.G_FALSE;
209: -- END IF;
210: -- IGC_MSGS_PKG.g_debug_mode := FND_API.TO_BOOLEAN(l_debug);

Line 208: -- l_debug := FND_API.G_FALSE;

204:
205: -- IF (l_debug = 'Y') THEN
206: -- l_debug := FND_API.G_TRUE;
207: -- ELSE
208: -- l_debug := FND_API.G_FALSE;
209: -- END IF;
210: -- IGC_MSGS_PKG.g_debug_mode := FND_API.TO_BOOLEAN(l_debug);
211:
212: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

Line 210: -- IGC_MSGS_PKG.g_debug_mode := FND_API.TO_BOOLEAN(l_debug);

206: -- l_debug := FND_API.G_TRUE;
207: -- ELSE
208: -- l_debug := FND_API.G_FALSE;
209: -- END IF;
210: -- IGC_MSGS_PKG.g_debug_mode := FND_API.TO_BOOLEAN(l_debug);
211:
212: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
213: IF (g_debug_mode = 'Y') THEN
214: g_debug_msg := ' IGCCACLB -- Begin Insert account line ID ....' || ' for Header ID .... ' || p_cc_header_id;

Line 341: FND_API.G_FALSE,

337: IF (l_Version_Num > 0) THEN
338:
339: IGC_CC_ACCT_LINE_HISTORY_PKG.Insert_Row(
340: l_api_version ,
341: FND_API.G_FALSE,
342: FND_API.G_FALSE,
343: p_validation_level,
344: l_return_status,
345: X_msg_count,

Line 342: FND_API.G_FALSE,

338:
339: IGC_CC_ACCT_LINE_HISTORY_PKG.Insert_Row(
340: l_api_version ,
341: FND_API.G_FALSE,
342: FND_API.G_FALSE,
343: p_validation_level,
344: l_return_status,
345: X_msg_count,
346: X_msg_data,

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

397:
398: -- ------------------------------------------------------------------
399: -- Make sure that the insertion was a success
400: -- ------------------------------------------------------------------
401: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
402: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
403: IF (g_debug_mode = 'Y') THEN
404: g_debug_msg := ' IGCCACLB -- Failure returned from insert History row...';
405: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

Line 407: RAISE FND_API.G_EXC_ERROR;

403: IF (g_debug_mode = 'Y') THEN
404: g_debug_msg := ' IGCCACLB -- Failure returned from insert History row...';
405: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
406: END IF;
407: RAISE FND_API.G_EXC_ERROR;
408: END IF;
409:
410: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
411: IF (g_debug_mode = 'Y') THEN

Line 444: RAISE FND_API.G_EXC_ERROR;

440: IF (g_debug_mode = 'Y') THEN
441: g_debug_msg := ' IGCCACLB -- Failure obtaining acct line inserted rowid...';
442: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
443: END IF;
444: RAISE FND_API.G_EXC_ERROR;
445: END IF;
446:
447: CLOSE c_acct_row_id;
448:

Line 466: RAISE FND_API.G_EXC_ERROR;

462: IF (g_debug_mode = 'Y') THEN
463: g_debug_msg := ' IGCCACLB -- Failure obtaining application ID...';
464: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
465: END IF;
466: RAISE FND_API.G_EXC_ERROR;
467: END IF;
468:
469: CLOSE c_igc_app_id;
470:

Line 490: RAISE FND_API.G_EXC_ERROR;

486: IF (g_debug_mode = 'Y') THEN
487: g_debug_msg := ' IGCCACLB -- Failure obtaining CC Info conversion date...';
488: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
489: END IF;
490: RAISE FND_API.G_EXC_ERROR;
491: END IF;
492:
493: CLOSE c_cc_info;
494:

Line 526: FND_API.G_FALSE,

522: -- ------------------------------------------------------------------
523:
524: IGC_CC_MC_MAIN_PVT.get_rsobs_Acct_Lines (
525: l_api_version,
526: FND_API.G_FALSE,
527: FND_API.G_FALSE,
528: p_validation_level,
529: l_return_status,
530: X_msg_count,

Line 527: FND_API.G_FALSE,

523:
524: IGC_CC_MC_MAIN_PVT.get_rsobs_Acct_Lines (
525: l_api_version,
526: FND_API.G_FALSE,
527: FND_API.G_FALSE,
528: p_validation_level,
529: l_return_status,
530: X_msg_count,
531: X_msg_data,

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

540: l_flag);
541: -- ------------------------------------------------------------------
542: -- Make sure that the insertion was a success
543: -- ------------------------------------------------------------------
544: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
545: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
546: IF (g_debug_mode = 'Y') THEN
547: g_debug_msg := ' IGCCACLB -- Failure returned from MC.get_rsobs_Acct_Lines...';
548: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

Line 550: RAISE FND_API.G_EXC_ERROR;

546: IF (g_debug_mode = 'Y') THEN
547: g_debug_msg := ' IGCCACLB -- Failure returned from MC.get_rsobs_Acct_Lines...';
548: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
549: END IF;
550: RAISE FND_API.G_EXC_ERROR;
551: END IF;
552: END IF;
553:
554: -- -----------------------------------------------------------------

Line 559: IF FND_API.To_Boolean ( p_commit ) THEN

555: -- If the records are to be commited in this procedure then
556: -- commit the work now otherwise wait for the caller to do COMMIT.
557: -- -----------------------------------------------------------------
558:
559: IF FND_API.To_Boolean ( p_commit ) THEN
560: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
561: IF (g_debug_mode = 'Y') THEN
562: g_debug_msg := ' IGCCACLB -- Committing Inserted account line...';
563: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

Line 583: WHEN FND_API.G_EXC_ERROR THEN

579:
580:
581: EXCEPTION
582:
583: WHEN FND_API.G_EXC_ERROR THEN
584:
585: ROLLBACK TO Insert_Row_Pvt;
586: X_return_status := FND_API.G_RET_STS_ERROR;
587:

Line 586: X_return_status := FND_API.G_RET_STS_ERROR;

582:
583: WHEN FND_API.G_EXC_ERROR THEN
584:
585: ROLLBACK TO Insert_Row_Pvt;
586: X_return_status := FND_API.G_RET_STS_ERROR;
587:
588: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
589: IF (g_debug_mode = 'Y') THEN
590: g_debug_msg := ' IGCCACLB -- Failure Execute Error...' || p_CC_Acct_Line_Id ||

Line 611: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_ERROR Exception Raised');

607: END IF;
608: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
609: p_data => X_msg_data );
610: IF (g_excep_level >= g_debug_level ) THEN
611: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_ERROR Exception Raised');
612: END IF;
613:
614: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
615:

Line 614: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

610: IF (g_excep_level >= g_debug_level ) THEN
611: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_ERROR Exception Raised');
612: END IF;
613:
614: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
615:
616: ROLLBACK TO Insert_Row_Pvt ;
617: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
618: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

Line 617: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

613:
614: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
615:
616: ROLLBACK TO Insert_Row_Pvt ;
617: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
618: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
619: IF (g_debug_mode = 'Y') THEN
620: g_debug_msg := ' IGCCACLB -- Failure Unexpected Error...' || p_CC_Acct_Line_Id ||
621: ' for Header ID .... ' || p_cc_header_id;

Line 639: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_UNEXPECTED_ERROR Exception Raised');

635: END IF;
636: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
637: p_data => X_msg_data );
638: IF (g_excep_level >= g_debug_level ) THEN
639: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_UNEXPECTED_ERROR Exception Raised');
640: END IF;
641:
642: WHEN OTHERS THEN
643:

Line 645: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

641:
642: WHEN OTHERS THEN
643:
644: ROLLBACK TO Insert_Row_Pvt ;
645: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
646: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
647: IF (g_debug_mode = 'Y') THEN
648: g_debug_msg := ' IGCCACLB -- Failure Others Error...'|| p_CC_Acct_Line_Id ||
649: ' for Header ID .... ' || p_cc_header_id;

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

686:
687:
688: PROCEDURE Lock_Row(
689: p_api_version IN NUMBER,
690: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
691: p_commit IN VARCHAR2 := FND_API.G_FALSE,
692: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
693: X_return_status OUT NOCOPY VARCHAR2,
694: X_msg_count OUT NOCOPY NUMBER,

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

687:
688: PROCEDURE Lock_Row(
689: p_api_version IN NUMBER,
690: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
691: p_commit IN VARCHAR2 := FND_API.G_FALSE,
692: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
693: X_return_status OUT NOCOPY VARCHAR2,
694: X_msg_count OUT NOCOPY NUMBER,
695: X_msg_data OUT NOCOPY VARCHAR2,

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

688: PROCEDURE Lock_Row(
689: p_api_version IN NUMBER,
690: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
691: p_commit IN VARCHAR2 := FND_API.G_FALSE,
692: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
693: X_return_status OUT NOCOPY VARCHAR2,
694: X_msg_count OUT NOCOPY NUMBER,
695: X_msg_data OUT NOCOPY VARCHAR2,
696: p_Rowid IN OUT NOCOPY VARCHAR2,

Line 768: IF NOT FND_API.Compatible_API_Call ( l_api_version,

764: l_full_path := g_path || 'Lock_Row';
765:
766: SAVEPOINT Lock_Row_Pvt ;
767:
768: IF NOT FND_API.Compatible_API_Call ( l_api_version,
769: p_api_version,
770: l_api_name,
771: G_PKG_NAME )
772: THEN

Line 773: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

769: p_api_version,
770: l_api_name,
771: G_PKG_NAME )
772: THEN
773: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
774: END IF;
775:
776:
777: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 777: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

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

Line 781: X_return_status := FND_API.G_RET_STS_SUCCESS ;

777: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
778: FND_MSG_PUB.initialize ;
779: END IF;
780:
781: X_return_status := FND_API.G_RET_STS_SUCCESS ;
782: X_row_locked := FND_API.G_TRUE ;
783: -- l_debug := FND_PROFILE.VALUE('IGC_DEBUG_ENABLED');
784:
785: -- IF (l_debug = 'Y') THEN

Line 782: X_row_locked := FND_API.G_TRUE ;

778: FND_MSG_PUB.initialize ;
779: END IF;
780:
781: X_return_status := FND_API.G_RET_STS_SUCCESS ;
782: X_row_locked := FND_API.G_TRUE ;
783: -- l_debug := FND_PROFILE.VALUE('IGC_DEBUG_ENABLED');
784:
785: -- IF (l_debug = 'Y') THEN
786: -- l_debug := FND_API.G_TRUE;

Line 786: -- l_debug := FND_API.G_TRUE;

782: X_row_locked := FND_API.G_TRUE ;
783: -- l_debug := FND_PROFILE.VALUE('IGC_DEBUG_ENABLED');
784:
785: -- IF (l_debug = 'Y') THEN
786: -- l_debug := FND_API.G_TRUE;
787: -- ELSE
788: -- l_debug := FND_API.G_FALSE;
789: -- END IF;
790: -- IGC_MSGS_PKG.g_debug_mode := FND_API.TO_BOOLEAN(l_debug);

Line 788: -- l_debug := FND_API.G_FALSE;

784:
785: -- IF (l_debug = 'Y') THEN
786: -- l_debug := FND_API.G_TRUE;
787: -- ELSE
788: -- l_debug := FND_API.G_FALSE;
789: -- END IF;
790: -- IGC_MSGS_PKG.g_debug_mode := FND_API.TO_BOOLEAN(l_debug);
791:
792: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

Line 790: -- IGC_MSGS_PKG.g_debug_mode := FND_API.TO_BOOLEAN(l_debug);

786: -- l_debug := FND_API.G_TRUE;
787: -- ELSE
788: -- l_debug := FND_API.G_FALSE;
789: -- END IF;
790: -- IGC_MSGS_PKG.g_debug_mode := FND_API.TO_BOOLEAN(l_debug);
791:
792: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
793: IF (g_debug_mode = 'Y') THEN
794: g_debug_msg := ' IGCCACLB -- Beginning Lock account line ID ...' || p_CC_Acct_Line_Id ||

Line 809: RAISE FND_API.G_EXC_ERROR ;

805: FND_MSG_PUB.Add;
806: IF (g_excep_level >= g_debug_level ) THEN
807: FND_LOG.MESSAGE (g_excep_level ,l_full_path ,FALSE);
808: END IF;
809: RAISE FND_API.G_EXC_ERROR ;
810: END IF;
811:
812: CLOSE C;
813:

Line 952: RAISE FND_API.G_EXC_ERROR ;

948: IF (g_excep_level >= g_debug_level ) THEN
949: FND_LOG.MESSAGE (g_excep_level,l_full_path,FALSE);
950: END IF;
951: FND_MSG_PUB.Add;
952: RAISE FND_API.G_EXC_ERROR ;
953: END IF;
954:
955: IF FND_API.To_Boolean ( p_commit ) THEN
956: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

Line 955: IF FND_API.To_Boolean ( p_commit ) THEN

951: FND_MSG_PUB.Add;
952: RAISE FND_API.G_EXC_ERROR ;
953: END IF;
954:
955: IF FND_API.To_Boolean ( p_commit ) THEN
956: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
957: IF (g_debug_mode = 'Y') THEN
958: g_debug_msg := ' IGCCACLB -- Committing Locked account line';
959: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

Line 979: X_row_locked := FND_API.G_FALSE;

975:
976: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
977:
978: ROLLBACK TO Lock_Row_Pvt ;
979: X_row_locked := FND_API.G_FALSE;
980: X_return_status := FND_API.G_RET_STS_ERROR;
981: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
982: IF (g_debug_mode = 'Y') THEN
983: g_debug_msg := ' IGCCACLB -- Record Lock exception...' || p_CC_Acct_Line_Id ||

Line 980: X_return_status := FND_API.G_RET_STS_ERROR;

976: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
977:
978: ROLLBACK TO Lock_Row_Pvt ;
979: X_row_locked := FND_API.G_FALSE;
980: X_return_status := FND_API.G_RET_STS_ERROR;
981: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
982: IF (g_debug_mode = 'Y') THEN
983: g_debug_msg := ' IGCCACLB -- Record Lock exception...' || p_CC_Acct_Line_Id ||
984: ' for Header ID .... ' || p_cc_header_id;

Line 993: WHEN FND_API.G_EXC_ERROR THEN

989: IF (g_excep_level >= g_debug_level ) THEN
990: FND_LOG.STRING (g_excep_level,l_full_path,'APP_EXCEPTION.RECORD_LOCK_EXCEPTION Exception Raised');
991: END IF;
992:
993: WHEN FND_API.G_EXC_ERROR THEN
994:
995: ROLLBACK TO Lock_Row_Pvt ;
996: X_return_status := FND_API.G_RET_STS_ERROR;
997: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

Line 996: X_return_status := FND_API.G_RET_STS_ERROR;

992:
993: WHEN FND_API.G_EXC_ERROR THEN
994:
995: ROLLBACK TO Lock_Row_Pvt ;
996: X_return_status := FND_API.G_RET_STS_ERROR;
997: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
998: IF (g_debug_mode = 'Y') THEN
999: g_debug_msg := ' IGCCACLB -- Execute exception...' || p_CC_Acct_Line_Id ||
1000: ' for Header ID .... ' || p_cc_header_id;

Line 1006: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_ERROR Exception Raised');

1002: END IF;
1003: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
1004: p_data => X_msg_data );
1005: IF (g_excep_level >= g_debug_level ) THEN
1006: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_ERROR Exception Raised');
1007: END IF;
1008:
1009: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1010:

Line 1009: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1005: IF (g_excep_level >= g_debug_level ) THEN
1006: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_ERROR Exception Raised');
1007: END IF;
1008:
1009: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1010:
1011: ROLLBACK TO Lock_Row_Pvt ;
1012: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1013: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

Line 1012: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1008:
1009: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1010:
1011: ROLLBACK TO Lock_Row_Pvt ;
1012: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1013: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
1014: IF (g_debug_mode = 'Y') THEN
1015: g_debug_msg := ' IGCCACLB -- Unexpected exception...' || p_CC_Acct_Line_Id ||
1016: ' for Header ID .... ' || p_cc_header_id;

Line 1022: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_UNEXPECTED_ERROR Exception Raised');

1018: END IF;
1019: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
1020: p_data => X_msg_data );
1021: IF (g_excep_level >= g_debug_level ) THEN
1022: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_UNEXPECTED_ERROR Exception Raised');
1023: END IF;
1024:
1025: WHEN OTHERS THEN
1026:

Line 1028: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1024:
1025: WHEN OTHERS THEN
1026:
1027: ROLLBACK TO Lock_Row_Pvt ;
1028: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1029: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
1030: IF (g_debug_mode = 'Y') THEN
1031: g_debug_msg := ' IGCCACLB -- Others exception...' || p_CC_Acct_Line_Id ||
1032: ' for Header ID .... ' || p_cc_header_id;

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

1054: ===============================================================================*/
1055:
1056: PROCEDURE Update_Row(
1057: p_api_version IN NUMBER,
1058: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1059: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1060: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1061: X_return_status OUT NOCOPY VARCHAR2,
1062: X_msg_count OUT NOCOPY NUMBER,

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

1055:
1056: PROCEDURE Update_Row(
1057: p_api_version IN NUMBER,
1058: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1059: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1060: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1061: X_return_status OUT NOCOPY VARCHAR2,
1062: X_msg_count OUT NOCOPY NUMBER,
1063: X_msg_data OUT NOCOPY VARCHAR2,

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

1056: PROCEDURE Update_Row(
1057: p_api_version IN NUMBER,
1058: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1059: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1060: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1061: X_return_status OUT NOCOPY VARCHAR2,
1062: X_msg_count OUT NOCOPY NUMBER,
1063: X_msg_data OUT NOCOPY VARCHAR2,
1064: p_Rowid IN OUT NOCOPY VARCHAR2,

Line 1150: IF NOT FND_API.Compatible_API_Call ( l_api_version,

1146: -- -----------------------------------------------------------------
1147: -- Ensure that the version requested to be used is correct for
1148: -- this API.
1149: -- -----------------------------------------------------------------
1150: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1151: p_api_version,
1152: l_api_name,
1153: G_PKG_NAME )
1154: THEN

Line 1155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1151: p_api_version,
1152: l_api_name,
1153: G_PKG_NAME )
1154: THEN
1155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1156: END IF;
1157:
1158: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
1159: FND_MSG_PUB.initialize ;

Line 1158: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

1154: THEN
1155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1156: END IF;
1157:
1158: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
1159: FND_MSG_PUB.initialize ;
1160: END IF;
1161:
1162: X_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 1162: X_return_status := FND_API.G_RET_STS_SUCCESS ;

1158: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
1159: FND_MSG_PUB.initialize ;
1160: END IF;
1161:
1162: X_return_status := FND_API.G_RET_STS_SUCCESS ;
1163: -- l_debug := FND_PROFILE.VALUE('IGC_DEBUG_ENABLED');
1164:
1165: -- IF (l_debug = 'Y') THEN
1166: -- l_debug := FND_API.G_TRUE;

Line 1166: -- l_debug := FND_API.G_TRUE;

1162: X_return_status := FND_API.G_RET_STS_SUCCESS ;
1163: -- l_debug := FND_PROFILE.VALUE('IGC_DEBUG_ENABLED');
1164:
1165: -- IF (l_debug = 'Y') THEN
1166: -- l_debug := FND_API.G_TRUE;
1167: -- ELSE
1168: -- l_debug := FND_API.G_FALSE;
1169: -- END IF;
1170: -- IGC_MSGS_PKG.g_debug_mode := FND_API.TO_BOOLEAN(l_debug);

Line 1168: -- l_debug := FND_API.G_FALSE;

1164:
1165: -- IF (l_debug = 'Y') THEN
1166: -- l_debug := FND_API.G_TRUE;
1167: -- ELSE
1168: -- l_debug := FND_API.G_FALSE;
1169: -- END IF;
1170: -- IGC_MSGS_PKG.g_debug_mode := FND_API.TO_BOOLEAN(l_debug);
1171:
1172: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

Line 1170: -- IGC_MSGS_PKG.g_debug_mode := FND_API.TO_BOOLEAN(l_debug);

1166: -- l_debug := FND_API.G_TRUE;
1167: -- ELSE
1168: -- l_debug := FND_API.G_FALSE;
1169: -- END IF;
1170: -- IGC_MSGS_PKG.g_debug_mode := FND_API.TO_BOOLEAN(l_debug);
1171:
1172: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
1173: IF (g_debug_mode = 'Y') THEN
1174: g_debug_msg := ' IGCCACLB -- Starting Update Account for Header ID .... ' || p_cc_header_id;

Line 1257: RAISE FND_API.G_EXC_ERROR;

1253: IF (g_debug_mode = 'Y') THEN
1254: g_debug_msg := ' IGCCACLB -- Failure obtaining application ID.....';
1255: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
1256: END IF;
1257: RAISE FND_API.G_EXC_ERROR;
1258: END IF;
1259:
1260: CLOSE c_igc_app_id;
1261:

Line 1315: FND_API.G_FALSE,

1311: -- the reporting set of books for this PRIMARY set of books.
1312: -- ------------------------------------------------------------------
1313: IGC_CC_MC_MAIN_PVT.get_rsobs_ACCT_LINES(
1314: l_api_version,
1315: FND_API.G_FALSE,
1316: FND_API.G_FALSE,
1317: p_validation_level,
1318: l_return_status,
1319: X_msg_count,

Line 1316: FND_API.G_FALSE,

1312: -- ------------------------------------------------------------------
1313: IGC_CC_MC_MAIN_PVT.get_rsobs_ACCT_LINES(
1314: l_api_version,
1315: FND_API.G_FALSE,
1316: FND_API.G_FALSE,
1317: p_validation_level,
1318: l_return_status,
1319: X_msg_count,
1320: X_msg_data,

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

1330:
1331: -- ------------------------------------------------------------------
1332: -- Make sure that the insertion was a success
1333: -- ------------------------------------------------------------------
1334: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1335: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
1336: IF (g_debug_mode = 'Y') THEN
1337: g_debug_msg := ' IGCCACLB -- Failure returned from MRC update account line.....';
1338: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

Line 1340: RAISE FND_API.G_EXC_ERROR;

1336: IF (g_debug_mode = 'Y') THEN
1337: g_debug_msg := ' IGCCACLB -- Failure returned from MRC update account line.....';
1338: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
1339: END IF;
1340: RAISE FND_API.G_EXC_ERROR;
1341: END IF;
1342:
1343: END IF;
1344:

Line 1349: IF FND_API.To_Boolean ( p_commit ) THEN

1345: -- -----------------------------------------------------------------
1346: -- If the records are to be commited in this procedure then
1347: -- commit the work now otherwise wait for the caller to do COMMIT.
1348: -- -----------------------------------------------------------------
1349: IF FND_API.To_Boolean ( p_commit ) THEN
1350: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
1351: IF (g_debug_mode = 'Y') THEN
1352: g_debug_msg := ' IGCCACLB -- Committing account line update.....';
1353: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

Line 1372: WHEN FND_API.G_EXC_ERROR THEN

1368: RETURN;
1369:
1370: EXCEPTION
1371:
1372: WHEN FND_API.G_EXC_ERROR THEN
1373:
1374: ROLLBACK TO Update_Row_Pvt ;
1375: X_return_status := FND_API.G_RET_STS_ERROR;
1376: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

Line 1375: X_return_status := FND_API.G_RET_STS_ERROR;

1371:
1372: WHEN FND_API.G_EXC_ERROR THEN
1373:
1374: ROLLBACK TO Update_Row_Pvt ;
1375: X_return_status := FND_API.G_RET_STS_ERROR;
1376: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
1377: IF (g_debug_mode = 'Y') THEN
1378: g_debug_msg := ' IGCCACLB -- Failure update execute error.....' || p_CC_Acct_Line_Id ||
1379: ' for Header ID .... ' || p_cc_header_id;

Line 1391: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_ERROR Exception Raised');

1387: END IF;
1388: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
1389: p_data => X_msg_data );
1390: IF (g_excep_level >= g_debug_level ) THEN
1391: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_ERROR Exception Raised');
1392: END IF;
1393:
1394: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1395:

Line 1394: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1390: IF (g_excep_level >= g_debug_level ) THEN
1391: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_ERROR Exception Raised');
1392: END IF;
1393:
1394: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1395:
1396: ROLLBACK TO Update_Row_Pvt ;
1397: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1398: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

Line 1397: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1393:
1394: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1395:
1396: ROLLBACK TO Update_Row_Pvt ;
1397: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1398: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
1399: IF (g_debug_mode = 'Y') THEN
1400: g_debug_msg := ' IGCCACLB -- Failure update Unexpected error.....' || p_CC_Acct_Line_Id ||
1401: ' for Header ID .... ' || p_cc_header_id;

Line 1413: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_UNEXPECTED_ERROR Exception Raised');

1409: END IF;
1410: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
1411: p_data => X_msg_data );
1412: IF (g_excep_level >= g_debug_level ) THEN
1413: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_UNEXPECTED_ERROR Exception Raised');
1414: END IF;
1415:
1416: WHEN OTHERS THEN
1417:

Line 1419: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1415:
1416: WHEN OTHERS THEN
1417:
1418: ROLLBACK TO Update_Row_Pvt ;
1419: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1420: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
1421: IF (g_debug_mode = 'Y') THEN
1422: g_debug_msg := ' IGCCACLB -- Failure update Others error.....' || p_CC_Acct_Line_Id ||
1423: ' for Header ID .... ' || p_cc_header_id;

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

1452: ===============================================================================*/
1453:
1454: PROCEDURE Delete_Row(
1455: p_api_version IN NUMBER,
1456: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1457: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1458: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1459: X_return_status OUT NOCOPY VARCHAR2,
1460: X_msg_count OUT NOCOPY NUMBER,

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

1453:
1454: PROCEDURE Delete_Row(
1455: p_api_version IN NUMBER,
1456: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1457: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1458: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1459: X_return_status OUT NOCOPY VARCHAR2,
1460: X_msg_count OUT NOCOPY NUMBER,
1461: X_msg_data OUT NOCOPY VARCHAR2,

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

1454: PROCEDURE Delete_Row(
1455: p_api_version IN NUMBER,
1456: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1457: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1458: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1459: X_return_status OUT NOCOPY VARCHAR2,
1460: X_msg_count OUT NOCOPY NUMBER,
1461: X_msg_data OUT NOCOPY VARCHAR2,
1462: p_Rowid IN OUT NOCOPY VARCHAR2,

Line 1529: IF NOT FND_API.Compatible_API_Call ( l_api_version,

1525: -- -----------------------------------------------------------------
1526: -- Ensure that the version requested to be used is correct for
1527: -- this API.
1528: -- -----------------------------------------------------------------
1529: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1530: p_api_version,
1531: l_api_name,
1532: G_PKG_NAME )
1533: THEN

Line 1534: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1530: p_api_version,
1531: l_api_name,
1532: G_PKG_NAME )
1533: THEN
1534: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1535: END IF;
1536:
1537: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
1538: FND_MSG_PUB.initialize ;

Line 1537: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

1533: THEN
1534: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1535: END IF;
1536:
1537: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
1538: FND_MSG_PUB.initialize ;
1539: END IF ;
1540:
1541: X_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 1541: X_return_status := FND_API.G_RET_STS_SUCCESS ;

1537: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
1538: FND_MSG_PUB.initialize ;
1539: END IF ;
1540:
1541: X_return_status := FND_API.G_RET_STS_SUCCESS ;
1542: -- l_debug := FND_PROFILE.VALUE('IGC_DEBUG_ENABLED');
1543:
1544: -- IF (l_debug = 'Y') THEN
1545: -- l_debug := FND_API.G_TRUE;

Line 1545: -- l_debug := FND_API.G_TRUE;

1541: X_return_status := FND_API.G_RET_STS_SUCCESS ;
1542: -- l_debug := FND_PROFILE.VALUE('IGC_DEBUG_ENABLED');
1543:
1544: -- IF (l_debug = 'Y') THEN
1545: -- l_debug := FND_API.G_TRUE;
1546: -- ELSE
1547: -- l_debug := FND_API.G_FALSE;
1548: -- END IF;
1549: -- IGC_MSGS_PKG.g_debug_mode := FND_API.TO_BOOLEAN(l_debug);

Line 1547: -- l_debug := FND_API.G_FALSE;

1543:
1544: -- IF (l_debug = 'Y') THEN
1545: -- l_debug := FND_API.G_TRUE;
1546: -- ELSE
1547: -- l_debug := FND_API.G_FALSE;
1548: -- END IF;
1549: -- IGC_MSGS_PKG.g_debug_mode := FND_API.TO_BOOLEAN(l_debug);
1550:
1551: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

Line 1549: -- IGC_MSGS_PKG.g_debug_mode := FND_API.TO_BOOLEAN(l_debug);

1545: -- l_debug := FND_API.G_TRUE;
1546: -- ELSE
1547: -- l_debug := FND_API.G_FALSE;
1548: -- END IF;
1549: -- IGC_MSGS_PKG.g_debug_mode := FND_API.TO_BOOLEAN(l_debug);
1550:
1551: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
1552: IF (g_debug_mode = 'Y') THEN
1553: g_debug_msg := ' IGCCACLB -- Starting account line delete Rowid ...' || p_rowid;

Line 1610: FND_API.G_FALSE,

1606: -- Insert the deleted history record for the account line
1607: -- ----------------------------------------------------------------
1608: IGC_CC_ACCT_LINE_HISTORY_PKG.Insert_Row(
1609: l_api_version ,
1610: FND_API.G_FALSE,
1611: FND_API.G_FALSE,
1612: p_validation_level,
1613: l_return_status,
1614: X_msg_count,

Line 1611: FND_API.G_FALSE,

1607: -- ----------------------------------------------------------------
1608: IGC_CC_ACCT_LINE_HISTORY_PKG.Insert_Row(
1609: l_api_version ,
1610: FND_API.G_FALSE,
1611: FND_API.G_FALSE,
1612: p_validation_level,
1613: l_return_status,
1614: X_msg_count,
1615: X_msg_data,

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

1666:
1667: -- ------------------------------------------------------------------
1668: -- Make sure that the insertion was a success
1669: -- ------------------------------------------------------------------
1670: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1671: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
1672: IF (g_debug_mode = 'Y') THEN
1673: g_debug_msg := ' IGCCACLB -- Failure returned from history delete action.....';
1674: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

Line 1676: RAISE FND_API.G_EXC_ERROR;

1672: IF (g_debug_mode = 'Y') THEN
1673: g_debug_msg := ' IGCCACLB -- Failure returned from history delete action.....';
1674: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
1675: END IF;
1676: RAISE FND_API.G_EXC_ERROR;
1677: END IF;
1678:
1679: -- ------------------------------------------------------------------
1680: -- Obtain the application ID for IGC to be used for the MRC check

Line 1696: RAISE FND_API.G_EXC_ERROR;

1692: IF (g_debug_mode = 'Y') THEN
1693: g_debug_msg := ' IGCCACLB -- Failure obtaining application ID in delete operation...';
1694: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
1695: END IF;
1696: RAISE FND_API.G_EXC_ERROR;
1697: END IF;
1698:
1699: CLOSE c_igc_app_id;
1700:

Line 1721: RAISE FND_API.G_EXC_ERROR;

1717: IF (g_debug_mode = 'Y') THEN
1718: g_debug_msg := ' IGCCACLB -- Failure obtaining CC Info conversion date in delete...';
1719: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
1720: END IF;
1721: RAISE FND_API.G_EXC_ERROR;
1722: END IF;
1723:
1724: CLOSE c_cc_info;
1725:

Line 1756: FND_API.G_FALSE,

1752: -- the reporting set of books for this PRIMARY set of books.
1753: -- ------------------------------------------------------------------
1754: IGC_CC_MC_MAIN_PVT.get_rsobs_Acct_Lines (
1755: l_api_version,
1756: FND_API.G_FALSE,
1757: FND_API.G_FALSE,
1758: p_validation_level,
1759: l_return_status,
1760: X_msg_count,

Line 1757: FND_API.G_FALSE,

1753: -- ------------------------------------------------------------------
1754: IGC_CC_MC_MAIN_PVT.get_rsobs_Acct_Lines (
1755: l_api_version,
1756: FND_API.G_FALSE,
1757: FND_API.G_FALSE,
1758: p_validation_level,
1759: l_return_status,
1760: X_msg_count,
1761: X_msg_data,

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

1771:
1772: -- ------------------------------------------------------------------
1773: -- Make sure that the insertion was a success
1774: -- ------------------------------------------------------------------
1775: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1776: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
1777: IF (g_debug_mode = 'Y') THEN
1778: g_debug_msg := ' IGCCACLB -- Failure returned from MC.get_rsobs_Acct_Lines delete...';
1779: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

Line 1781: RAISE FND_API.G_EXC_ERROR;

1777: IF (g_debug_mode = 'Y') THEN
1778: g_debug_msg := ' IGCCACLB -- Failure returned from MC.get_rsobs_Acct_Lines delete...';
1779: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
1780: END IF;
1781: RAISE FND_API.G_EXC_ERROR;
1782: END IF;
1783:
1784: END IF;
1785:

Line 1800: FND_API.G_FALSE,

1796:
1797: WHILE (c_get_all_pf_lines%FOUND) LOOP
1798:
1799: IGC_CC_DET_PF_PKG.Delete_Row (l_api_version,
1800: FND_API.G_FALSE,
1801: FND_API.G_FALSE,
1802: p_validation_level,
1803: l_return_status,
1804: X_msg_count,

Line 1801: FND_API.G_FALSE,

1797: WHILE (c_get_all_pf_lines%FOUND) LOOP
1798:
1799: IGC_CC_DET_PF_PKG.Delete_Row (l_api_version,
1800: FND_API.G_FALSE,
1801: FND_API.G_FALSE,
1802: p_validation_level,
1803: l_return_status,
1804: X_msg_count,
1805: X_msg_data,

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

1808:
1809: -- ------------------------------------------------------------------
1810: -- Make sure that the insertion was a success
1811: -- ------------------------------------------------------------------
1812: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1813: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
1814: IF (g_debug_mode = 'Y') THEN
1815: g_debug_msg := ' IGCCACLB -- Failure returned from Delete Row DET PF...';
1816: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

Line 1818: RAISE FND_API.G_EXC_ERROR;

1814: IF (g_debug_mode = 'Y') THEN
1815: g_debug_msg := ' IGCCACLB -- Failure returned from Delete Row DET PF...';
1816: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
1817: END IF;
1818: RAISE FND_API.G_EXC_ERROR;
1819: END IF;
1820:
1821: -- ------------------------------------------------------------------
1822: -- Get the next row of Payment forcast record

Line 1864: IF FND_API.To_Boolean ( p_commit ) THEN

1860: -- -----------------------------------------------------------------
1861: -- If the records are to be commited in this procedure then
1862: -- commit the work now otherwise wait for the caller to do COMMIT.
1863: -- -----------------------------------------------------------------
1864: IF FND_API.To_Boolean ( p_commit ) THEN
1865: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
1866: IF (g_debug_mode = 'Y') THEN
1867: g_debug_msg := ' IGCCACLB -- Committing account line delete.....';
1868: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

Line 1905: WHEN FND_API.G_EXC_ERROR THEN

1901: RETURN;
1902:
1903: EXCEPTION
1904:
1905: WHEN FND_API.G_EXC_ERROR THEN
1906:
1907: ROLLBACK TO Delete_Row_Pvt ;
1908: X_return_status := FND_API.G_RET_STS_ERROR;
1909: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

Line 1908: X_return_status := FND_API.G_RET_STS_ERROR;

1904:
1905: WHEN FND_API.G_EXC_ERROR THEN
1906:
1907: ROLLBACK TO Delete_Row_Pvt ;
1908: X_return_status := FND_API.G_RET_STS_ERROR;
1909: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
1910: IF (g_debug_mode = 'Y') THEN
1911: g_debug_msg := ' IGCCACLB -- Failure Delete Execute Error Rowid ...' || p_rowid;
1912: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

Line 1932: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_ERROR Exception Raised');

1928: END IF;
1929: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
1930: p_data => X_msg_data );
1931: IF (g_excep_level >= g_debug_level ) THEN
1932: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_ERROR Exception Raised');
1933: END IF;
1934:
1935: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1936:

Line 1935: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1931: IF (g_excep_level >= g_debug_level ) THEN
1932: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_ERROR Exception Raised');
1933: END IF;
1934:
1935: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1936:
1937: ROLLBACK TO Delete_Row_Pvt ;
1938: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1939: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

Line 1938: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1934:
1935: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1936:
1937: ROLLBACK TO Delete_Row_Pvt ;
1938: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1939: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
1940: IF (g_debug_mode = 'Y') THEN
1941: g_debug_msg := ' IGCCACLB -- Failure Delete Unexpected Error Rowid ...' || p_rowid;
1942: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

Line 1962: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_UNEXPECTED_ERROR Exception Raised');

1958: END IF;
1959: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
1960: p_data => X_msg_data );
1961: IF (g_excep_level >= g_debug_level ) THEN
1962: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_UNEXPECTED_ERROR Exception Raised');
1963: END IF;
1964:
1965: WHEN OTHERS THEN
1966:

Line 1968: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1964:
1965: WHEN OTHERS THEN
1966:
1967: ROLLBACK TO Delete_Row_Pvt ;
1968: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1969: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
1970: IF (g_debug_mode = 'Y') THEN
1971: g_debug_msg := ' IGCCACLB -- Failure Delete Others Error Rowid ...' || p_rowid;
1972: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);