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

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

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

Line 52: raise FND_API.G_EXC_ERROR;

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

Line 66: /*WHEN FND_API.G_EXC_ERROR THEN

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

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

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

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

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

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

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

Line 176: IF NOT FND_API.Compatible_API_Call ( l_api_version,

172: -- -----------------------------------------------------------------
173: -- Ensure that the version requested to be used is correct for
174: -- this API.
175: -- -----------------------------------------------------------------
176: IF NOT FND_API.Compatible_API_Call ( l_api_version,
177: p_api_version,
178: l_api_name,
179: G_PKG_NAME )
180: THEN

Line 181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

177: p_api_version,
178: l_api_name,
179: G_PKG_NAME )
180: THEN
181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
182: END IF;
183:
184:
185: IF FND_API.to_Boolean (p_init_msg_list ) THEN

Line 185: IF FND_API.to_Boolean (p_init_msg_list ) THEN

181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
182: END IF;
183:
184:
185: IF FND_API.to_Boolean (p_init_msg_list ) THEN
186: FND_MSG_PUB.initialize ;
187: END IF;
188:
189: X_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 189: X_return_status := FND_API.G_RET_STS_SUCCESS ;

185: IF FND_API.to_Boolean (p_init_msg_list ) THEN
186: FND_MSG_PUB.initialize ;
187: END IF;
188:
189: X_return_status := FND_API.G_RET_STS_SUCCESS ;
190: -- l_debug := FND_PROFILE.VALUE('IGC_DEBUG_ENABLED');
191:
192: -- IF (l_debug = 'Y') THEN
193: -- l_debug := FND_API.G_TRUE;

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

189: X_return_status := FND_API.G_RET_STS_SUCCESS ;
190: -- l_debug := FND_PROFILE.VALUE('IGC_DEBUG_ENABLED');
191:
192: -- IF (l_debug = 'Y') THEN
193: -- l_debug := FND_API.G_TRUE;
194: -- ELSE
195: -- l_debug := FND_API.G_FALSE;
196: -- END IF;
197: -- IGC_MSGS_PKG.g_debug_mode := FND_API.TO_BOOLEAN(l_debug);

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

191:
192: -- IF (l_debug = 'Y') THEN
193: -- l_debug := FND_API.G_TRUE;
194: -- ELSE
195: -- l_debug := FND_API.G_FALSE;
196: -- END IF;
197: -- IGC_MSGS_PKG.g_debug_mode := FND_API.TO_BOOLEAN(l_debug);
198:
199: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

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

193: -- l_debug := FND_API.G_TRUE;
194: -- ELSE
195: -- l_debug := FND_API.G_FALSE;
196: -- END IF;
197: -- IGC_MSGS_PKG.g_debug_mode := FND_API.TO_BOOLEAN(l_debug);
198:
199: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
200: IF g_debug_mode = 'Y' THEN
201: g_debug_msg := ' IGCCHDRB -- Begin Insert Header ID Overload .....' || p_cc_header_id;

Line 335: RAISE FND_API.G_EXC_ERROR ;

331: IF g_debug_mode = 'Y' THEN
332: g_debug_msg := ' IGCCHDRB -- Failure getting rowid for Header ID Overload.....' || p_cc_header_id;
333: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
334: END IF;
335: RAISE FND_API.G_EXC_ERROR ;
336: END IF;
337:
338: CLOSE c_cc_header_row_id;
339:

Line 357: RAISE FND_API.G_EXC_ERROR;

353: IF g_debug_mode = 'Y' THEN
354: g_debug_msg := ' IGCCHDRB -- failure getting appl id for Header ID Overload .....' || p_cc_header_id;
355: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
356: END IF;
357: RAISE FND_API.G_EXC_ERROR;
358: END IF;
359:
360: CLOSE c_igc_app_id;
361:

Line 392: FND_API.G_FALSE,

388: -- MRC Handler For IGC_CC_HEADERS to insert all MRC records for
389: -- the reporting set of books for this PRIMARY set of books.
390: -- ------------------------------------------------------------------
391: IGC_CC_MC_MAIN_PVT.get_rsobs_Headers (l_api_version,
392: FND_API.G_FALSE,
393: FND_API.G_FALSE,
394: p_validation_level,
395: l_return_status,
396: X_msg_count,

Line 393: FND_API.G_FALSE,

389: -- the reporting set of books for this PRIMARY set of books.
390: -- ------------------------------------------------------------------
391: IGC_CC_MC_MAIN_PVT.get_rsobs_Headers (l_api_version,
392: FND_API.G_FALSE,
393: FND_API.G_FALSE,
394: p_validation_level,
395: l_return_status,
396: X_msg_count,
397: X_msg_data,

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

404:
405: -- ------------------------------------------------------------------
406: -- Make sure that the insertion was a success
407: -- ------------------------------------------------------------------
408: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
409: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
410: IF g_debug_mode = 'Y' THEN
411: g_debug_msg := ' IGCCHDRB -- Failure returned from MRC call ID Overload .....' || p_cc_header_id;
412: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

Line 414: RAISE FND_API.G_EXC_ERROR;

410: IF g_debug_mode = 'Y' THEN
411: g_debug_msg := ' IGCCHDRB -- Failure returned from MRC call ID Overload .....' || p_cc_header_id;
412: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
413: END IF;
414: RAISE FND_API.G_EXC_ERROR;
415: END IF;
416:
417: END IF;
418:

Line 423: IF FND_API.To_Boolean ( p_commit ) THEN

419: -- -----------------------------------------------------------------
420: -- If the records are to be commited in this procedure then
421: -- commit the work now otherwise wait for the caller to do COMMIT.
422: -- -----------------------------------------------------------------
423: IF FND_API.To_Boolean ( p_commit ) THEN
424: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
425: IF g_debug_mode = 'Y' THEN
426: g_debug_msg := ' IGCCHDRB -- Committing Insert Header ID Overload .....' || p_cc_header_id;
427: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

Line 445: WHEN FND_API.G_EXC_ERROR THEN

441: RETURN;
442:
443: EXCEPTION
444:
445: WHEN FND_API.G_EXC_ERROR THEN
446:
447: ROLLBACK TO Insert_Row_Pvt ;
448: X_return_status := FND_API.G_RET_STS_ERROR;
449: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

Line 448: X_return_status := FND_API.G_RET_STS_ERROR;

444:
445: WHEN FND_API.G_EXC_ERROR THEN
446:
447: ROLLBACK TO Insert_Row_Pvt ;
448: X_return_status := FND_API.G_RET_STS_ERROR;
449: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
450: IF g_debug_mode = 'Y' THEN
451: g_debug_msg := ' IGCCHDRB -- Failure Execution on Header ID Overload .....' || p_cc_header_id;
452: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

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

459: END IF;
460: FND_MSG_PUB.Count_And_Get (p_count => X_msg_count,
461: p_data => X_msg_data );
462: IF (g_excep_level >= g_debug_level ) THEN
463: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_ERROR Exception Raised');
464: END IF;
465:
466: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
467:

Line 466: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

462: IF (g_excep_level >= g_debug_level ) THEN
463: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_ERROR Exception Raised');
464: END IF;
465:
466: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
467:
468: ROLLBACK TO Insert_Row_Pvt ;
469: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
470: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

Line 469: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

465:
466: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
467:
468: ROLLBACK TO Insert_Row_Pvt ;
469: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
470: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
471: IF g_debug_mode = 'Y' THEN
472: g_debug_msg := ' IGCCHDRB -- Failure Unexpected on Header ID Overload .....' || p_cc_header_id;
473: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

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

480: END IF;
481: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
482: p_data => X_msg_data );
483: IF (g_excep_level >= g_debug_level ) THEN
484: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_UNEXPECTED_ERROR Exception Raised');
485: END IF;
486:
487: WHEN OTHERS THEN
488:

Line 490: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

486:
487: WHEN OTHERS THEN
488:
489: ROLLBACK TO Insert_Row_Pvt ;
490: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
491: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
492: IF g_debug_mode = 'Y' THEN
493: g_debug_msg := ' IGCCHDRB -- Failure Others on Header ID Overload .....' || p_cc_header_id;
494: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

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

522: ===============================================================================*/
523:
524: PROCEDURE Insert_Row(
525: p_api_version IN NUMBER,
526: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
527: p_commit IN VARCHAR2 := FND_API.G_FALSE,
528: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
529: X_return_status OUT NOCOPY VARCHAR2,
530: X_msg_count OUT NOCOPY NUMBER,

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

523:
524: PROCEDURE Insert_Row(
525: p_api_version IN NUMBER,
526: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
527: p_commit IN VARCHAR2 := FND_API.G_FALSE,
528: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
529: X_return_status OUT NOCOPY VARCHAR2,
530: X_msg_count OUT NOCOPY NUMBER,
531: X_msg_data OUT NOCOPY VARCHAR2,

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

524: PROCEDURE Insert_Row(
525: p_api_version IN NUMBER,
526: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
527: p_commit IN VARCHAR2 := FND_API.G_FALSE,
528: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
529: X_return_status OUT NOCOPY VARCHAR2,
530: X_msg_count OUT NOCOPY NUMBER,
531: X_msg_data OUT NOCOPY VARCHAR2,
532: p_Rowid IN OUT NOCOPY VARCHAR2,

Line 618: IF NOT FND_API.Compatible_API_Call ( l_api_version,

614: -- -----------------------------------------------------------------
615: -- Ensure that the version requested to be used is correct for
616: -- this API.
617: -- -----------------------------------------------------------------
618: IF NOT FND_API.Compatible_API_Call ( l_api_version,
619: p_api_version,
620: l_api_name,
621: G_PKG_NAME )
622: THEN

Line 623: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

619: p_api_version,
620: l_api_name,
621: G_PKG_NAME )
622: THEN
623: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
624: END IF;
625:
626:
627: IF FND_API.to_Boolean (p_init_msg_list ) THEN

Line 627: IF FND_API.to_Boolean (p_init_msg_list ) THEN

623: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
624: END IF;
625:
626:
627: IF FND_API.to_Boolean (p_init_msg_list ) THEN
628: FND_MSG_PUB.initialize ;
629: END IF;
630:
631: X_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 631: X_return_status := FND_API.G_RET_STS_SUCCESS ;

627: IF FND_API.to_Boolean (p_init_msg_list ) THEN
628: FND_MSG_PUB.initialize ;
629: END IF;
630:
631: X_return_status := FND_API.G_RET_STS_SUCCESS ;
632: -- l_debug := FND_PROFILE.VALUE('IGC_DEBUG_ENABLED');
633:
634: -- IF (l_debug = 'Y') THEN
635: -- l_debug := FND_API.G_TRUE;

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

631: X_return_status := FND_API.G_RET_STS_SUCCESS ;
632: -- l_debug := FND_PROFILE.VALUE('IGC_DEBUG_ENABLED');
633:
634: -- IF (l_debug = 'Y') THEN
635: -- l_debug := FND_API.G_TRUE;
636: -- ELSE
637: -- l_debug := FND_API.G_FALSE;
638: -- END IF;
639: -- IGC_MSGS_PKG.g_debug_mode := FND_API.TO_BOOLEAN(l_debug);

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

633:
634: -- IF (l_debug = 'Y') THEN
635: -- l_debug := FND_API.G_TRUE;
636: -- ELSE
637: -- l_debug := FND_API.G_FALSE;
638: -- END IF;
639: -- IGC_MSGS_PKG.g_debug_mode := FND_API.TO_BOOLEAN(l_debug);
640:
641: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

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

635: -- l_debug := FND_API.G_TRUE;
636: -- ELSE
637: -- l_debug := FND_API.G_FALSE;
638: -- END IF;
639: -- IGC_MSGS_PKG.g_debug_mode := FND_API.TO_BOOLEAN(l_debug);
640:
641: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
642: IF g_debug_mode = 'Y' THEN
643: g_debug_msg := ' IGCCHDRB -- Begin Insert Header ID .....' || p_cc_header_id;

Line 775: RAISE FND_API.G_EXC_ERROR ;

771: IF g_debug_mode = 'Y' THEN
772: g_debug_msg := ' IGCCHDRB -- Failure getting rowid for Header ID .....' || p_cc_header_id;
773: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
774: END IF;
775: RAISE FND_API.G_EXC_ERROR ;
776: END IF;
777:
778: CLOSE c_cc_header_row_id;
779:

Line 797: RAISE FND_API.G_EXC_ERROR;

793: IF g_debug_mode = 'Y' THEN
794: g_debug_msg := ' IGCCHDRB -- failure getting appl id for Header ID .....' || p_cc_header_id;
795: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
796: END IF;
797: RAISE FND_API.G_EXC_ERROR;
798: END IF;
799:
800: CLOSE c_igc_app_id;
801:

Line 832: FND_API.G_FALSE,

828: -- MRC Handler For IGC_CC_HEADERS to insert all MRC records for
829: -- the reporting set of books for this PRIMARY set of books.
830: -- ------------------------------------------------------------------
831: IGC_CC_MC_MAIN_PVT.get_rsobs_Headers (l_api_version,
832: FND_API.G_FALSE,
833: FND_API.G_FALSE,
834: p_validation_level,
835: l_return_status,
836: X_msg_count,

Line 833: FND_API.G_FALSE,

829: -- the reporting set of books for this PRIMARY set of books.
830: -- ------------------------------------------------------------------
831: IGC_CC_MC_MAIN_PVT.get_rsobs_Headers (l_api_version,
832: FND_API.G_FALSE,
833: FND_API.G_FALSE,
834: p_validation_level,
835: l_return_status,
836: X_msg_count,
837: X_msg_data,

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

844:
845: -- ------------------------------------------------------------------
846: -- Make sure that the insertion was a success
847: -- ------------------------------------------------------------------
848: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
849: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
850: IF g_debug_mode = 'Y' THEN
851: g_debug_msg := ' IGCCHDRB -- Failure returned from MRC call ID .....' || p_cc_header_id;
852: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

Line 854: RAISE FND_API.G_EXC_ERROR;

850: IF g_debug_mode = 'Y' THEN
851: g_debug_msg := ' IGCCHDRB -- Failure returned from MRC call ID .....' || p_cc_header_id;
852: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
853: END IF;
854: RAISE FND_API.G_EXC_ERROR;
855: END IF;
856:
857: END IF;
858:

Line 863: IF FND_API.To_Boolean ( p_commit ) THEN

859: -- -----------------------------------------------------------------
860: -- If the records are to be commited in this procedure then
861: -- commit the work now otherwise wait for the caller to do COMMIT.
862: -- -----------------------------------------------------------------
863: IF FND_API.To_Boolean ( p_commit ) THEN
864: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
865: IF g_debug_mode = 'Y' THEN
866: g_debug_msg := ' IGCCHDRB -- Committing Insert Header ID .....' || p_cc_header_id;
867: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

Line 885: WHEN FND_API.G_EXC_ERROR THEN

881: RETURN;
882:
883: EXCEPTION
884:
885: WHEN FND_API.G_EXC_ERROR THEN
886:
887: ROLLBACK TO Insert_Row_Pvt ;
888: X_return_status := FND_API.G_RET_STS_ERROR;
889: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

Line 888: X_return_status := FND_API.G_RET_STS_ERROR;

884:
885: WHEN FND_API.G_EXC_ERROR THEN
886:
887: ROLLBACK TO Insert_Row_Pvt ;
888: X_return_status := FND_API.G_RET_STS_ERROR;
889: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
890: IF g_debug_mode = 'Y' THEN
891: g_debug_msg := ' IGCCHDRB -- Failure Execution on Header ID .....' || p_cc_header_id;
892: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

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

899: END IF;
900: FND_MSG_PUB.Count_And_Get (p_count => X_msg_count,
901: p_data => X_msg_data );
902: IF (g_excep_level >= g_debug_level ) THEN
903: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_ERROR Exception Raised');
904: END IF;
905:
906: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
907:

Line 906: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

902: IF (g_excep_level >= g_debug_level ) THEN
903: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_ERROR Exception Raised');
904: END IF;
905:
906: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
907:
908: ROLLBACK TO Insert_Row_Pvt ;
909: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
910: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

Line 909: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

905:
906: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
907:
908: ROLLBACK TO Insert_Row_Pvt ;
909: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
910: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
911: IF g_debug_mode = 'Y' THEN
912: g_debug_msg := ' IGCCHDRB -- Failure Unexpected on Header ID .....' || p_cc_header_id;
913: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

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

920: END IF;
921: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
922: p_data => X_msg_data );
923: IF (g_excep_level >= g_debug_level ) THEN
924: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_UNEXPECTED_ERROR Exception Raised');
925: END IF;
926:
927:
928: WHEN OTHERS THEN

Line 931: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

927:
928: WHEN OTHERS THEN
929:
930: ROLLBACK TO Insert_Row_Pvt ;
931: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
932: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
933: IF g_debug_mode = 'Y' THEN
934: g_debug_msg := ' IGCCHDRB -- Failure Others on Header ID .....' || p_cc_header_id;
935: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

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

962: ===============================================================================*/
963:
964: PROCEDURE Lock_Row(
965: p_api_version IN NUMBER,
966: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
967: p_commit IN VARCHAR2 := FND_API.G_FALSE,
968: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
969: X_return_status OUT NOCOPY VARCHAR2,
970: X_msg_count OUT NOCOPY NUMBER,

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

963:
964: PROCEDURE Lock_Row(
965: p_api_version IN NUMBER,
966: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
967: p_commit IN VARCHAR2 := FND_API.G_FALSE,
968: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
969: X_return_status OUT NOCOPY VARCHAR2,
970: X_msg_count OUT NOCOPY NUMBER,
971: X_msg_data OUT NOCOPY VARCHAR2,

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

964: PROCEDURE Lock_Row(
965: p_api_version IN NUMBER,
966: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
967: p_commit IN VARCHAR2 := FND_API.G_FALSE,
968: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
969: X_return_status OUT NOCOPY VARCHAR2,
970: X_msg_count OUT NOCOPY NUMBER,
971: X_msg_data OUT NOCOPY VARCHAR2,
972: p_Rowid IN OUT NOCOPY VARCHAR2,

Line 1049: IF NOT FND_API.Compatible_API_Call ( l_api_version,

1045: l_full_path := g_path || 'Lock_Row';
1046:
1047: SAVEPOINT Lock_Row_Pvt ;
1048:
1049: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1050: p_api_version,
1051: l_api_name,
1052: G_PKG_NAME )
1053: THEN

Line 1054: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1050: p_api_version,
1051: l_api_name,
1052: G_PKG_NAME )
1053: THEN
1054: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1055: END IF;
1056:
1057:
1058: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 1058: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

1054: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1055: END IF;
1056:
1057:
1058: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
1059: FND_MSG_PUB.initialize ;
1060: END IF;
1061:
1062: X_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 1062: X_return_status := FND_API.G_RET_STS_SUCCESS ;

1058: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
1059: FND_MSG_PUB.initialize ;
1060: END IF;
1061:
1062: X_return_status := FND_API.G_RET_STS_SUCCESS ;
1063: X_row_locked := FND_API.G_TRUE ;
1064: -- l_debug := FND_PROFILE.VALUE('IGC_DEBUG_ENABLED');
1065:
1066: -- IF (l_debug = 'Y') THEN

Line 1063: X_row_locked := FND_API.G_TRUE ;

1059: FND_MSG_PUB.initialize ;
1060: END IF;
1061:
1062: X_return_status := FND_API.G_RET_STS_SUCCESS ;
1063: X_row_locked := FND_API.G_TRUE ;
1064: -- l_debug := FND_PROFILE.VALUE('IGC_DEBUG_ENABLED');
1065:
1066: -- IF (l_debug = 'Y') THEN
1067: -- l_debug := FND_API.G_TRUE;

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

1063: X_row_locked := FND_API.G_TRUE ;
1064: -- l_debug := FND_PROFILE.VALUE('IGC_DEBUG_ENABLED');
1065:
1066: -- IF (l_debug = 'Y') THEN
1067: -- l_debug := FND_API.G_TRUE;
1068: -- ELSE
1069: -- l_debug := FND_API.G_FALSE;
1070: -- END IF;
1071: -- IGC_MSGS_PKG.g_debug_mode := FND_API.TO_BOOLEAN(l_debug);

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

1065:
1066: -- IF (l_debug = 'Y') THEN
1067: -- l_debug := FND_API.G_TRUE;
1068: -- ELSE
1069: -- l_debug := FND_API.G_FALSE;
1070: -- END IF;
1071: -- IGC_MSGS_PKG.g_debug_mode := FND_API.TO_BOOLEAN(l_debug);
1072:
1073: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

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

1067: -- l_debug := FND_API.G_TRUE;
1068: -- ELSE
1069: -- l_debug := FND_API.G_FALSE;
1070: -- END IF;
1071: -- IGC_MSGS_PKG.g_debug_mode := FND_API.TO_BOOLEAN(l_debug);
1072:
1073: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
1074: IF g_debug_mode = 'Y' THEN
1075: g_debug_msg := ' IGCCHDRB -- Begin Lock Row Header ID .....' || p_cc_header_id;

Line 1090: RAISE FND_API.G_EXC_ERROR;

1086: FND_MSG_PUB.Add;
1087: IF (g_excep_level >= g_debug_level ) THEN
1088: FND_LOG.MESSAGE (g_excep_level ,l_full_path,FALSE);
1089: END IF;
1090: RAISE FND_API.G_EXC_ERROR;
1091: END IF;
1092:
1093: CLOSE C;
1094:

Line 1235: RAISE FND_API.G_EXC_ERROR ;

1231: FND_MSG_PUB.Add;
1232: IF (g_excep_level >= g_debug_level ) THEN
1233: FND_LOG.MESSAGE (g_excep_level , l_full_path,FALSE);
1234: END IF;
1235: RAISE FND_API.G_EXC_ERROR ;
1236:
1237: END IF;
1238:
1239: IF FND_API.To_Boolean ( p_commit ) THEN

Line 1239: IF FND_API.To_Boolean ( p_commit ) THEN

1235: RAISE FND_API.G_EXC_ERROR ;
1236:
1237: END IF;
1238:
1239: IF FND_API.To_Boolean ( p_commit ) THEN
1240: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
1241: IF g_debug_mode = 'Y' THEN
1242: g_debug_msg := ' IGCCHDRB -- Committing Lock Row Header ID .....' || p_cc_header_id;
1243: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

Line 1265: X_row_locked := FND_API.G_FALSE;

1261:
1262: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
1263:
1264: ROLLBACK TO Lock_Row_Pvt ;
1265: X_row_locked := FND_API.G_FALSE;
1266: X_return_status := FND_API.G_RET_STS_ERROR;
1267: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
1268: IF g_debug_mode = 'Y' THEN
1269: g_debug_msg := ' IGCCHDRB -- Failure Record Lock Exc Header ID .....' || p_cc_header_id;

Line 1266: X_return_status := FND_API.G_RET_STS_ERROR;

1262: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
1263:
1264: ROLLBACK TO Lock_Row_Pvt ;
1265: X_row_locked := FND_API.G_FALSE;
1266: X_return_status := FND_API.G_RET_STS_ERROR;
1267: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
1268: IF g_debug_mode = 'Y' THEN
1269: g_debug_msg := ' IGCCHDRB -- Failure Record Lock Exc Header ID .....' || p_cc_header_id;
1270: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

Line 1279: WHEN FND_API.G_EXC_ERROR THEN

1275: IF (g_excep_level >= g_debug_level ) THEN
1276: FND_LOG.STRING (g_excep_level,l_full_path,'APP_EXCEPTION.RECORD_LOCK_EXCEPTION Exception Raised');
1277: END IF;
1278:
1279: WHEN FND_API.G_EXC_ERROR THEN
1280:
1281: ROLLBACK TO Lock_Row_Pvt ;
1282: X_return_status := FND_API.G_RET_STS_ERROR;
1283: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

Line 1282: X_return_status := FND_API.G_RET_STS_ERROR;

1278:
1279: WHEN FND_API.G_EXC_ERROR THEN
1280:
1281: ROLLBACK TO Lock_Row_Pvt ;
1282: X_return_status := FND_API.G_RET_STS_ERROR;
1283: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
1284: IF g_debug_mode = 'Y' THEN
1285: g_debug_msg := ' IGCCHDRB -- Failure Execute Lock Header ID .....' || p_cc_header_id;
1286: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

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

1288:
1289: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
1290: p_data => X_msg_data );
1291: IF (g_excep_level >= g_debug_level ) THEN
1292: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_ERROR Exception Raised');
1293: END IF;
1294:
1295: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1296:

Line 1295: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1291: IF (g_excep_level >= g_debug_level ) THEN
1292: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_ERROR Exception Raised');
1293: END IF;
1294:
1295: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1296:
1297: ROLLBACK TO Lock_Row_Pvt ;
1298: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1299: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

Line 1298: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1294:
1295: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1296:
1297: ROLLBACK TO Lock_Row_Pvt ;
1298: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1299: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
1300: IF g_debug_mode = 'Y' THEN
1301: g_debug_msg := ' IGCCHDRB -- Failure Unexpected Lock Header ID .....' || p_cc_header_id;
1302: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

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

1303: END IF;
1304: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
1305: p_data => X_msg_data );
1306: IF (g_excep_level >= g_debug_level ) THEN
1307: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_UNEXPECTED_ERROR Exception Raised');
1308: END IF;
1309:
1310: WHEN OTHERS THEN
1311:

Line 1313: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1309:
1310: WHEN OTHERS THEN
1311:
1312: ROLLBACK TO Lock_Row_Pvt ;
1313: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1314: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
1315: IF g_debug_mode = 'Y' THEN
1316: g_debug_msg := ' IGCCHDRB -- Failure Others Lock Header ID .....' || p_cc_header_id;
1317: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

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

1338: ===============================================================================*/
1339:
1340: PROCEDURE Update_Row(
1341: p_api_version IN NUMBER,
1342: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1343: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1344: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1345: X_return_status OUT NOCOPY VARCHAR2,
1346: X_msg_count OUT NOCOPY NUMBER,

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

1339:
1340: PROCEDURE Update_Row(
1341: p_api_version IN NUMBER,
1342: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1343: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1344: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1345: X_return_status OUT NOCOPY VARCHAR2,
1346: X_msg_count OUT NOCOPY NUMBER,
1347: X_msg_data OUT NOCOPY VARCHAR2,

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

1340: PROCEDURE Update_Row(
1341: p_api_version IN NUMBER,
1342: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1343: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1344: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1345: X_return_status OUT NOCOPY VARCHAR2,
1346: X_msg_count OUT NOCOPY NUMBER,
1347: X_msg_data OUT NOCOPY VARCHAR2,
1348: p_Rowid IN OUT NOCOPY VARCHAR2,

Line 1430: IF NOT FND_API.Compatible_API_Call ( l_api_version,

1426: -- -----------------------------------------------------------------
1427: -- Ensure that the version requested to be used is correct for
1428: -- this API.
1429: -- -----------------------------------------------------------------
1430: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1431: p_api_version,
1432: l_api_name,
1433: G_PKG_NAME )
1434: THEN

Line 1435: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1431: p_api_version,
1432: l_api_name,
1433: G_PKG_NAME )
1434: THEN
1435: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1436: END IF;
1437:
1438: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
1439: FND_MSG_PUB.initialize ;

Line 1438: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

1434: THEN
1435: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1436: END IF;
1437:
1438: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
1439: FND_MSG_PUB.initialize ;
1440: END IF;
1441:
1442: X_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 1442: X_return_status := FND_API.G_RET_STS_SUCCESS ;

1438: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
1439: FND_MSG_PUB.initialize ;
1440: END IF;
1441:
1442: X_return_status := FND_API.G_RET_STS_SUCCESS ;
1443: -- l_debug := FND_PROFILE.VALUE('IGC_DEBUG_ENABLED');
1444:
1445: -- IF (l_debug = 'Y') THEN
1446: -- l_debug := FND_API.G_TRUE;

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

1442: X_return_status := FND_API.G_RET_STS_SUCCESS ;
1443: -- l_debug := FND_PROFILE.VALUE('IGC_DEBUG_ENABLED');
1444:
1445: -- IF (l_debug = 'Y') THEN
1446: -- l_debug := FND_API.G_TRUE;
1447: -- ELSE
1448: -- l_debug := FND_API.G_FALSE;
1449: -- END IF;
1450: -- IGC_MSGS_PKG.g_debug_mode := FND_API.TO_BOOLEAN(l_debug);

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

1444:
1445: -- IF (l_debug = 'Y') THEN
1446: -- l_debug := FND_API.G_TRUE;
1447: -- ELSE
1448: -- l_debug := FND_API.G_FALSE;
1449: -- END IF;
1450: -- IGC_MSGS_PKG.g_debug_mode := FND_API.TO_BOOLEAN(l_debug);
1451:
1452: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

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

1446: -- l_debug := FND_API.G_TRUE;
1447: -- ELSE
1448: -- l_debug := FND_API.G_FALSE;
1449: -- END IF;
1450: -- IGC_MSGS_PKG.g_debug_mode := FND_API.TO_BOOLEAN(l_debug);
1451:
1452: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
1453: IF g_debug_mode = 'Y' THEN
1454: g_debug_msg := ' IGCCHDRB -- Begin Update Row Header ID Overload .....' || p_cc_header_id;

Line 1542: RAISE FND_API.G_EXC_ERROR;

1538: IF g_debug_mode = 'Y' THEN
1539: g_debug_msg := ' IGCCHDRB -- Failure getting appl ID for Upd Header Overload .....' || p_cc_header_id;
1540: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
1541: END IF;
1542: RAISE FND_API.G_EXC_ERROR;
1543: END IF;
1544:
1545: CLOSE c_igc_app_id;
1546:

Line 1576: FND_API.G_FALSE,

1572: -- MRC Handler For IGC_CC_CC_HEADERS to insert all MRC records for
1573: -- the reporting set of books for this PRIMARY set of books.
1574: -- ------------------------------------------------------------------
1575: IGC_CC_MC_MAIN_PVT.get_rsobs_Headers (l_api_version,
1576: FND_API.G_FALSE,
1577: FND_API.G_FALSE,
1578: p_validation_level,
1579: l_return_status,
1580: X_msg_count,

Line 1577: FND_API.G_FALSE,

1573: -- the reporting set of books for this PRIMARY set of books.
1574: -- ------------------------------------------------------------------
1575: IGC_CC_MC_MAIN_PVT.get_rsobs_Headers (l_api_version,
1576: FND_API.G_FALSE,
1577: FND_API.G_FALSE,
1578: p_validation_level,
1579: l_return_status,
1580: X_msg_count,
1581: X_msg_data,

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

1588:
1589: -- ------------------------------------------------------------------
1590: -- Make sure that the insertion was a success
1591: -- ------------------------------------------------------------------
1592: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1593: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
1594: IF g_debug_mode = 'Y' THEN
1595: g_debug_msg := ' IGCCHDRB -- Failure Update MRC return Header ID Overload .....' || p_cc_header_id;
1596: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

Line 1598: RAISE FND_API.G_EXC_ERROR;

1594: IF g_debug_mode = 'Y' THEN
1595: g_debug_msg := ' IGCCHDRB -- Failure Update MRC return Header ID Overload .....' || p_cc_header_id;
1596: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
1597: END IF;
1598: RAISE FND_API.G_EXC_ERROR;
1599: END IF;
1600:
1601: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
1602: IF g_debug_mode = 'Y' THEN

Line 1613: IF FND_API.To_Boolean ( p_commit ) THEN

1609: -- -----------------------------------------------------------------
1610: -- If the records are to be commited in this procedure then
1611: -- commit the work now otherwise wait for the caller to do COMMIT.
1612: -- -----------------------------------------------------------------
1613: IF FND_API.To_Boolean ( p_commit ) THEN
1614: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
1615: IF g_debug_mode = 'Y' THEN
1616: g_debug_msg := ' IGCCHDRB -- Committing Update Row Header ID Overload .....' || p_cc_header_id;
1617: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

Line 1635: WHEN FND_API.G_EXC_ERROR THEN

1631: RETURN;
1632:
1633: EXCEPTION
1634:
1635: WHEN FND_API.G_EXC_ERROR THEN
1636:
1637: ROLLBACK TO Update_Row_Pvt ;
1638: X_return_status := FND_API.G_RET_STS_ERROR;
1639: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

Line 1638: X_return_status := FND_API.G_RET_STS_ERROR;

1634:
1635: WHEN FND_API.G_EXC_ERROR THEN
1636:
1637: ROLLBACK TO Update_Row_Pvt ;
1638: X_return_status := FND_API.G_RET_STS_ERROR;
1639: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
1640: IF g_debug_mode = 'Y' THEN
1641: g_debug_msg := ' IGCCHDRB -- Failure Execute Update Header ID Overload .....' || p_cc_header_id;
1642: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

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

1646: END IF;
1647: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
1648: p_data => X_msg_data );
1649: IF (g_excep_level >= g_debug_level ) THEN
1650: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_ERROR Exception Raised');
1651: END IF;
1652:
1653: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1654:

Line 1653: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1649: IF (g_excep_level >= g_debug_level ) THEN
1650: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_ERROR Exception Raised');
1651: END IF;
1652:
1653: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1654:
1655: ROLLBACK TO Update_Row_Pvt ;
1656: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1657: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

Line 1656: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1652:
1653: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1654:
1655: ROLLBACK TO Update_Row_Pvt ;
1656: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1657: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
1658: IF g_debug_mode = 'Y' THEN
1659: g_debug_msg := ' IGCCHDRB -- Failure Unexpected Update Header ID Overload .....' || p_cc_header_id;
1660: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

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

1664: END IF;
1665: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
1666: p_data => X_msg_data );
1667: IF (g_excep_level >= g_debug_level ) THEN
1668: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_UNEXPECTED_ERROR Exception Raised');
1669: END IF;
1670:
1671: WHEN OTHERS THEN
1672:

Line 1674: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1670:
1671: WHEN OTHERS THEN
1672:
1673: ROLLBACK TO Update_Row_Pvt ;
1674: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1675: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
1676: IF g_debug_mode = 'Y' THEN
1677: g_debug_msg := ' IGCCHDRB -- Failure Others Update Header ID Overload .....' || p_cc_header_id;
1678: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

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

1702: ===============================================================================*/
1703:
1704: PROCEDURE Update_Row(
1705: p_api_version IN NUMBER,
1706: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1707: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1708: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1709: X_return_status OUT NOCOPY VARCHAR2,
1710: X_msg_count OUT NOCOPY NUMBER,

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

1703:
1704: PROCEDURE Update_Row(
1705: p_api_version IN NUMBER,
1706: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1707: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1708: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1709: X_return_status OUT NOCOPY VARCHAR2,
1710: X_msg_count OUT NOCOPY NUMBER,
1711: X_msg_data OUT NOCOPY VARCHAR2,

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

1704: PROCEDURE Update_Row(
1705: p_api_version IN NUMBER,
1706: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1707: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1708: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1709: X_return_status OUT NOCOPY VARCHAR2,
1710: X_msg_count OUT NOCOPY NUMBER,
1711: X_msg_data OUT NOCOPY VARCHAR2,
1712: p_Rowid IN OUT NOCOPY VARCHAR2,

Line 1793: IF NOT FND_API.Compatible_API_Call ( l_api_version,

1789: -- -----------------------------------------------------------------
1790: -- Ensure that the version requested to be used is correct for
1791: -- this API.
1792: -- -----------------------------------------------------------------
1793: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1794: p_api_version,
1795: l_api_name,
1796: G_PKG_NAME )
1797: THEN

Line 1798: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1794: p_api_version,
1795: l_api_name,
1796: G_PKG_NAME )
1797: THEN
1798: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1799: END IF;
1800:
1801: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
1802: FND_MSG_PUB.initialize ;

Line 1801: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

1797: THEN
1798: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1799: END IF;
1800:
1801: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
1802: FND_MSG_PUB.initialize ;
1803: END IF;
1804:
1805: X_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 1805: X_return_status := FND_API.G_RET_STS_SUCCESS ;

1801: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
1802: FND_MSG_PUB.initialize ;
1803: END IF;
1804:
1805: X_return_status := FND_API.G_RET_STS_SUCCESS ;
1806: -- l_debug := FND_PROFILE.VALUE('IGC_DEBUG_ENABLED');
1807:
1808: -- IF (l_debug = 'Y') THEN
1809: -- l_debug := FND_API.G_TRUE;

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

1805: X_return_status := FND_API.G_RET_STS_SUCCESS ;
1806: -- l_debug := FND_PROFILE.VALUE('IGC_DEBUG_ENABLED');
1807:
1808: -- IF (l_debug = 'Y') THEN
1809: -- l_debug := FND_API.G_TRUE;
1810: -- ELSE
1811: -- l_debug := FND_API.G_FALSE;
1812: -- END IF;
1813: -- IGC_MSGS_PKG.g_debug_mode := FND_API.TO_BOOLEAN(l_debug);

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

1807:
1808: -- IF (l_debug = 'Y') THEN
1809: -- l_debug := FND_API.G_TRUE;
1810: -- ELSE
1811: -- l_debug := FND_API.G_FALSE;
1812: -- END IF;
1813: -- IGC_MSGS_PKG.g_debug_mode := FND_API.TO_BOOLEAN(l_debug);
1814:
1815: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

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

1809: -- l_debug := FND_API.G_TRUE;
1810: -- ELSE
1811: -- l_debug := FND_API.G_FALSE;
1812: -- END IF;
1813: -- IGC_MSGS_PKG.g_debug_mode := FND_API.TO_BOOLEAN(l_debug);
1814:
1815: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
1816: IF g_debug_mode = 'Y' THEN
1817: g_debug_msg := ' IGCCHDRB -- Begin Update Row Header ID .....' || p_cc_header_id;

Line 1904: RAISE FND_API.G_EXC_ERROR;

1900: IF g_debug_mode = 'Y' THEN
1901: g_debug_msg := ' IGCCHDRB -- Failure getting appl ID for Upd Header.....' || p_cc_header_id;
1902: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
1903: END IF;
1904: RAISE FND_API.G_EXC_ERROR;
1905: END IF;
1906:
1907: CLOSE c_igc_app_id;
1908:

Line 1937: FND_API.G_FALSE,

1933: -- MRC Handler For IGC_CC_CC_HEADERS to insert all MRC records for
1934: -- the reporting set of books for this PRIMARY set of books.
1935: -- ------------------------------------------------------------------
1936: IGC_CC_MC_MAIN_PVT.get_rsobs_Headers (l_api_version,
1937: FND_API.G_FALSE,
1938: FND_API.G_FALSE,
1939: p_validation_level,
1940: l_return_status,
1941: X_msg_count,

Line 1938: FND_API.G_FALSE,

1934: -- the reporting set of books for this PRIMARY set of books.
1935: -- ------------------------------------------------------------------
1936: IGC_CC_MC_MAIN_PVT.get_rsobs_Headers (l_api_version,
1937: FND_API.G_FALSE,
1938: FND_API.G_FALSE,
1939: p_validation_level,
1940: l_return_status,
1941: X_msg_count,
1942: X_msg_data,

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

1949:
1950: -- ------------------------------------------------------------------
1951: -- Make sure that the insertion was a success
1952: -- ------------------------------------------------------------------
1953: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1954: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
1955: IF g_debug_mode = 'Y' THEN
1956: g_debug_msg := ' IGCCHDRB -- Failure Update MRC return Header ID .....' || p_cc_header_id;
1957: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

Line 1959: RAISE FND_API.G_EXC_ERROR;

1955: IF g_debug_mode = 'Y' THEN
1956: g_debug_msg := ' IGCCHDRB -- Failure Update MRC return Header ID .....' || p_cc_header_id;
1957: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
1958: END IF;
1959: RAISE FND_API.G_EXC_ERROR;
1960: END IF;
1961:
1962: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
1963: IF g_debug_mode = 'Y' THEN

Line 1974: IF FND_API.To_Boolean ( p_commit ) THEN

1970: -- -----------------------------------------------------------------
1971: -- If the records are to be commited in this procedure then
1972: -- commit the work now otherwise wait for the caller to do COMMIT.
1973: -- -----------------------------------------------------------------
1974: IF FND_API.To_Boolean ( p_commit ) THEN
1975: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
1976: IF g_debug_mode = 'Y' THEN
1977: g_debug_msg := ' IGCCHDRB -- Committing Update Row Header ID .....' || p_cc_header_id;
1978: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

Line 1996: WHEN FND_API.G_EXC_ERROR THEN

1992: RETURN;
1993:
1994: EXCEPTION
1995:
1996: WHEN FND_API.G_EXC_ERROR THEN
1997:
1998: ROLLBACK TO Update_Row_Pvt ;
1999: X_return_status := FND_API.G_RET_STS_ERROR;
2000: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

Line 1999: X_return_status := FND_API.G_RET_STS_ERROR;

1995:
1996: WHEN FND_API.G_EXC_ERROR THEN
1997:
1998: ROLLBACK TO Update_Row_Pvt ;
1999: X_return_status := FND_API.G_RET_STS_ERROR;
2000: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
2001: IF g_debug_mode = 'Y' THEN
2002: g_debug_msg := ' IGCCHDRB -- Failure Execute Update Header ID .....' || p_cc_header_id;
2003: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

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

2007: END IF;
2008: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
2009: p_data => X_msg_data );
2010: IF (g_excep_level >= g_debug_level ) THEN
2011: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_ERROR Exception Raised');
2012: END IF;
2013:
2014: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2015:

Line 2014: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2010: IF (g_excep_level >= g_debug_level ) THEN
2011: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_ERROR Exception Raised');
2012: END IF;
2013:
2014: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2015:
2016: ROLLBACK TO Update_Row_Pvt ;
2017: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2018: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

Line 2017: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2013:
2014: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2015:
2016: ROLLBACK TO Update_Row_Pvt ;
2017: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2018: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
2019: IF g_debug_mode = 'Y' THEN
2020: g_debug_msg := ' IGCCHDRB -- Failure Unexpected Update Header ID .....' || p_cc_header_id;
2021: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

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

2025: END IF;
2026: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
2027: p_data => X_msg_data );
2028: IF (g_excep_level >= g_debug_level ) THEN
2029: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_UNEXPECTED_ERROR Exception Raised');
2030: END IF;
2031:
2032: WHEN OTHERS THEN
2033:

Line 2035: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2031:
2032: WHEN OTHERS THEN
2033:
2034: ROLLBACK TO Update_Row_Pvt ;
2035: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2036: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
2037: IF g_debug_mode = 'Y' THEN
2038: g_debug_msg := ' IGCCHDRB -- Failure Others Update Header ID .....' || p_cc_header_id;
2039: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

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

2065: ===============================================================================*/
2066:
2067: PROCEDURE Delete_Row(
2068: p_api_version IN NUMBER,
2069: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2070: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2071: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2072: X_return_status OUT NOCOPY VARCHAR2,
2073: X_msg_count OUT NOCOPY NUMBER,

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

2066:
2067: PROCEDURE Delete_Row(
2068: p_api_version IN NUMBER,
2069: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2070: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2071: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2072: X_return_status OUT NOCOPY VARCHAR2,
2073: X_msg_count OUT NOCOPY NUMBER,
2074: X_msg_data OUT NOCOPY VARCHAR2,

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

2067: PROCEDURE Delete_Row(
2068: p_api_version IN NUMBER,
2069: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2070: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2071: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2072: X_return_status OUT NOCOPY VARCHAR2,
2073: X_msg_count OUT NOCOPY NUMBER,
2074: X_msg_data OUT NOCOPY VARCHAR2,
2075: p_Rowid IN OUT NOCOPY VARCHAR2,

Line 2113: IF NOT FND_API.Compatible_API_Call ( l_api_version,

2109: -- -----------------------------------------------------------------
2110: -- Ensure that the version requested to be used is correct for
2111: -- this API.
2112: -- -----------------------------------------------------------------
2113: IF NOT FND_API.Compatible_API_Call ( l_api_version,
2114: p_api_version,
2115: l_api_name,
2116: G_PKG_NAME )
2117: THEN

Line 2118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

2114: p_api_version,
2115: l_api_name,
2116: G_PKG_NAME )
2117: THEN
2118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2119: END IF;
2120:
2121: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
2122: FND_MSG_PUB.initialize ;

Line 2121: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

2117: THEN
2118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2119: END IF;
2120:
2121: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
2122: FND_MSG_PUB.initialize ;
2123: END IF ;
2124:
2125: X_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 2125: X_return_status := FND_API.G_RET_STS_SUCCESS ;

2121: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
2122: FND_MSG_PUB.initialize ;
2123: END IF ;
2124:
2125: X_return_status := FND_API.G_RET_STS_SUCCESS ;
2126: -- l_debug := FND_PROFILE.VALUE('IGC_DEBUG_ENABLED');
2127:
2128: -- IF (l_debug = 'Y') THEN
2129: -- l_debug := FND_API.G_TRUE;

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

2125: X_return_status := FND_API.G_RET_STS_SUCCESS ;
2126: -- l_debug := FND_PROFILE.VALUE('IGC_DEBUG_ENABLED');
2127:
2128: -- IF (l_debug = 'Y') THEN
2129: -- l_debug := FND_API.G_TRUE;
2130: -- ELSE
2131: -- l_debug := FND_API.G_FALSE;
2132: -- END IF;
2133: -- IGC_MSGS_PKG.g_debug_mode := FND_API.TO_BOOLEAN(l_debug);

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

2127:
2128: -- IF (l_debug = 'Y') THEN
2129: -- l_debug := FND_API.G_TRUE;
2130: -- ELSE
2131: -- l_debug := FND_API.G_FALSE;
2132: -- END IF;
2133: -- IGC_MSGS_PKG.g_debug_mode := FND_API.TO_BOOLEAN(l_debug);
2134:
2135: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

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

2129: -- l_debug := FND_API.G_TRUE;
2130: -- ELSE
2131: -- l_debug := FND_API.G_FALSE;
2132: -- END IF;
2133: -- IGC_MSGS_PKG.g_debug_mode := FND_API.TO_BOOLEAN(l_debug);
2134:
2135: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
2136: IF g_debug_mode = 'Y' THEN
2137: g_debug_msg := ' IGCCHDRB -- Starting Header delete Rowid ...' || p_rowid;

Line 2179: p_conc_proc => FND_API.G_FALSE);

2175: p_ret_status => l_bc_return_status,
2176: p_batch_result_code => l_batch_result_code,
2177: p_doc_type => 'CC',
2178: p_debug => g_debug_mode,
2179: p_conc_proc => FND_API.G_FALSE);
2180:
2181: IF l_bc_success = TRUE --No fatal errors
2182: AND substr(l_bc_return_status,1,1) IN ('N','S','A') --CBC successfull
2183: AND substr(l_bc_return_status,2,1) IN ('N','S','A') --SBC successfull

Line 2186: l_Return_Status := FND_API.G_TRUE;

2182: AND substr(l_bc_return_status,1,1) IN ('N','S','A') --CBC successfull
2183: AND substr(l_bc_return_status,2,1) IN ('N','S','A') --SBC successfull
2184:
2185: THEN
2186: l_Return_Status := FND_API.G_TRUE;
2187: ELSE
2188: l_Return_Status := FND_API.G_FALSE;
2189: END IF;
2190:

Line 2188: l_Return_Status := FND_API.G_FALSE;

2184:
2185: THEN
2186: l_Return_Status := FND_API.G_TRUE;
2187: ELSE
2188: l_Return_Status := FND_API.G_FALSE;
2189: END IF;
2190:
2191: IF g_debug_mode = 'Y' THEN
2192: IF l_Return_Status = FND_API.G_TRUE THEN

Line 2192: IF l_Return_Status = FND_API.G_TRUE THEN

2188: l_Return_Status := FND_API.G_FALSE;
2189: END IF;
2190:
2191: IF g_debug_mode = 'Y' THEN
2192: IF l_Return_Status = FND_API.G_TRUE THEN
2193: g_debug_msg := ' IGCCHDRB -- Succesfully Unreserved the Encubracnes';
2194: ELSE
2195: g_debug_msg := ' IGCCHDRB -- Failed to unreserve the Encubracnes';
2196: END IF;

Line 2200: IF l_Return_Status = FND_API.G_TRUE THEN

2196: END IF;
2197: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
2198: END IF;
2199:
2200: IF l_Return_Status = FND_API.G_TRUE THEN
2201: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2202: END IF;
2203:
2204: END IF;

Line 2201: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2197: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
2198: END IF;
2199:
2200: IF l_Return_Status = FND_API.G_TRUE THEN
2201: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2202: END IF;
2203:
2204: END IF;
2205:

Line 2493: IF FND_API.To_Boolean ( p_commit ) THEN

2489: -- -----------------------------------------------------------------
2490: -- If the records are to be commited in this procedure then
2491: -- commit the work now otherwise wait for the caller to do COMMIT.
2492: -- -----------------------------------------------------------------
2493: IF FND_API.To_Boolean ( p_commit ) THEN
2494: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
2495: IF g_debug_mode = 'Y' THEN
2496: g_debug_msg := ' IGCCHDRB -- Committing Header delete Rowid ...' || p_rowid;
2497: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

Line 2515: WHEN FND_API.G_EXC_ERROR THEN

2511: RETURN;
2512:
2513: EXCEPTION
2514:
2515: WHEN FND_API.G_EXC_ERROR THEN
2516:
2517: ROLLBACK TO Delete_Row_Pvt ;
2518: X_return_status := FND_API.G_RET_STS_ERROR;
2519: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

Line 2518: X_return_status := FND_API.G_RET_STS_ERROR;

2514:
2515: WHEN FND_API.G_EXC_ERROR THEN
2516:
2517: ROLLBACK TO Delete_Row_Pvt ;
2518: X_return_status := FND_API.G_RET_STS_ERROR;
2519: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
2520: IF g_debug_mode = 'Y' THEN
2521: g_debug_msg := ' IGCCHDRB -- Failure Execute Header delete Rowid ...' || p_rowid;
2522: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

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

2526: END IF;
2527: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
2528: p_data => X_msg_data );
2529: IF (g_excep_level >= g_debug_level ) THEN
2530: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_ERROR Exception Raised');
2531: END IF;
2532:
2533: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2534:

Line 2533: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2529: IF (g_excep_level >= g_debug_level ) THEN
2530: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_ERROR Exception Raised');
2531: END IF;
2532:
2533: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2534:
2535: ROLLBACK TO Delete_Row_Pvt ;
2536: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2537: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

Line 2536: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2532:
2533: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2534:
2535: ROLLBACK TO Delete_Row_Pvt ;
2536: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2537: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
2538: IF g_debug_mode = 'Y' THEN
2539: g_debug_msg := ' IGCCHDRB -- Failure Unexpected Header delete Rowid ...' || p_rowid;
2540: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

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

2544: END IF;
2545: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
2546: p_data => X_msg_data );
2547: IF (g_excep_level >= g_debug_level ) THEN
2548: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_UNEXPECTED_ERROR Exception Raised');
2549: END IF;
2550:
2551: WHEN OTHERS THEN
2552:

Line 2554: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2550:
2551: WHEN OTHERS THEN
2552:
2553: ROLLBACK TO Delete_Row_Pvt ;
2554: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2555: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
2556: IF g_debug_mode = 'Y' THEN
2557: g_debug_msg := ' IGCCHDRB -- Failure Others Header delete Rowid ...' || p_rowid;
2558: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);