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

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

52: p_filename_val => NULL,
53: x_Return_Status => l_Return_Status
54: );
55:
56: IF (l_Return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
57: raise FND_API.G_EXC_ERROR;
58: END IF;
59:
60: RETURN;

Line 57: raise FND_API.G_EXC_ERROR;

53: x_Return_Status => l_Return_Status
54: );
55:
56: IF (l_Return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
57: raise FND_API.G_EXC_ERROR;
58: END IF;
59:
60: RETURN;
61:

Line 64: WHEN FND_API.G_EXC_ERROR THEN

60: RETURN;
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 177: IF NOT FND_API.Compatible_API_Call ( l_api_version,

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

Line 182: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

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

Line 185: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

181: THEN
182: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
183: END IF;
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_row_id := p_Rowid;
191: -- l_debug := FND_PROFILE.VALUE('IGC_DEBUG_ENABLED');
192:
193: -- IF (l_debug = 'Y') THEN

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

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

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

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

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

194: -- l_debug := FND_API.G_TRUE;
195: -- ELSE
196: -- l_debug := FND_API.G_FALSE;
197: -- END IF;
198: -- IGC_MSGS_PKG.g_debug_mode := FND_API.TO_BOOLEAN(l_debug);
199:
200: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
201: IF (g_debug_mode = 'Y') THEN
202: g_debug_msg := ' IGCCDPFB -- Begin Insert Payment Forcast for Account Line ID...' || p_cc_acct_line_id;

Line 304: FND_API.G_FALSE,

300: IF (l_Version_Num > 0) THEN
301:
302: IGC_CC_DET_PF_HISTORY_PKG.Insert_Row (
303: l_api_version,
304: FND_API.G_FALSE,
305: FND_API.G_FALSE,
306: p_validation_level,
307: l_return_status,
308: X_msg_count,

Line 305: FND_API.G_FALSE,

301:
302: IGC_CC_DET_PF_HISTORY_PKG.Insert_Row (
303: l_api_version,
304: FND_API.G_FALSE,
305: FND_API.G_FALSE,
306: p_validation_level,
307: l_return_status,
308: X_msg_count,
309: X_msg_data,

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

348:
349: -- ------------------------------------------------------------------
350: -- Make sure that the insertion was a success
351: -- ------------------------------------------------------------------
352: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
353: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
354: IF (g_debug_mode = 'Y') THEN
355: g_debug_msg := ' IGCCDPFB -- Failure returned from History Insert Payment Forcast Row';
356: Output_Debug (p_path => l_full_path ,p_debug_msg => g_debug_msg);

Line 358: RAISE FND_API.G_EXC_ERROR;

354: IF (g_debug_mode = 'Y') THEN
355: g_debug_msg := ' IGCCDPFB -- Failure returned from History Insert Payment Forcast Row';
356: Output_Debug (p_path => l_full_path ,p_debug_msg => g_debug_msg);
357: END IF;
358: RAISE FND_API.G_EXC_ERROR;
359: END IF;
360:
361: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
362: IF (g_debug_mode = 'Y') THEN

Line 388: RAISE FND_API.G_EXC_ERROR;

384: IF (g_debug_mode = 'Y') THEN
385: g_debug_msg := ' IGCCDPFB -- Failure getting Payment Forcast Row ID';
386: Output_Debug (p_path => l_full_path ,p_debug_msg => g_debug_msg);
387: END IF;
388: RAISE FND_API.G_EXC_ERROR;
389: END IF;
390:
391: CLOSE c_det_pf_row_id;
392:

Line 410: RAISE FND_API.G_EXC_ERROR;

406: IF (g_debug_mode = 'Y') THEN
407: g_debug_msg := ' IGCCDPFB -- Failure getting Application ID in Payment FC Insert';
408: Output_Debug (p_path => l_full_path ,p_debug_msg => g_debug_msg);
409: END IF;
410: RAISE FND_API.G_EXC_ERROR;
411: END IF;
412:
413: CLOSE c_igc_app_id;
414:

Line 434: RAISE FND_API.G_EXC_ERROR;

430: IF (g_debug_mode = 'Y') THEN
431: g_debug_msg := ' IGCCDPFB -- Failure getting Payment Forcast Info';
432: Output_Debug (p_path => l_full_path ,p_debug_msg => g_debug_msg);
433: END IF;
434: RAISE FND_API.G_EXC_ERROR;
435: END IF;
436:
437: CLOSE c_det_pf_info;
438:

Line 470: FND_API.G_FALSE,

466: -- MRC Handler For IGC_CC_DET_PF to insert all MRC records for
467: -- the reporting set of books for this PRIMARY set of books.
468: -- ------------------------------------------------------------------
469: IGC_CC_MC_MAIN_PVT.get_rsobs_DET_PF (l_api_version,
470: FND_API.G_FALSE,
471: FND_API.G_FALSE,
472: p_validation_level,
473: l_return_status,
474: X_msg_count,

Line 471: FND_API.G_FALSE,

467: -- the reporting set of books for this PRIMARY set of books.
468: -- ------------------------------------------------------------------
469: IGC_CC_MC_MAIN_PVT.get_rsobs_DET_PF (l_api_version,
470: FND_API.G_FALSE,
471: FND_API.G_FALSE,
472: p_validation_level,
473: l_return_status,
474: X_msg_count,
475: X_msg_data,

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

484:
485: -- ------------------------------------------------------------------
486: -- Make sure that the insertion was a success
487: -- ------------------------------------------------------------------
488: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
489: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
490: IF (g_debug_mode = 'Y') THEN
491: g_debug_msg := ' IGCCDPFB -- Failure returned from MRC processing';
492: Output_Debug (p_path => l_full_path ,p_debug_msg => g_debug_msg);

Line 494: RAISE FND_API.G_EXC_ERROR;

490: IF (g_debug_mode = 'Y') THEN
491: g_debug_msg := ' IGCCDPFB -- Failure returned from MRC processing';
492: Output_Debug (p_path => l_full_path ,p_debug_msg => g_debug_msg);
493: END IF;
494: RAISE FND_API.G_EXC_ERROR;
495: END IF;
496:
497: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
498: IF (g_debug_mode = 'Y') THEN

Line 509: IF FND_API.To_Boolean ( p_commit ) THEN

505: -- -----------------------------------------------------------------
506: -- If the records are to be commited in this procedure then
507: -- commit the work now otherwise wait for the caller to do COMMIT.
508: -- -----------------------------------------------------------------
509: IF FND_API.To_Boolean ( p_commit ) THEN
510: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
511: IF (g_debug_mode = 'Y') THEN
512: g_debug_msg := ' IGCCDPFB -- Committing Payment Forcast Insert';
513: Output_Debug (p_path => l_full_path ,p_debug_msg => g_debug_msg);

Line 532: WHEN FND_API.G_EXC_ERROR THEN

528: RETURN;
529:
530: EXCEPTION
531:
532: WHEN FND_API.G_EXC_ERROR THEN
533:
534: ROLLBACK TO Insert_Row_Pvt ;
535: X_return_status := FND_API.G_RET_STS_ERROR;
536: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

Line 535: X_return_status := FND_API.G_RET_STS_ERROR;

531:
532: WHEN FND_API.G_EXC_ERROR THEN
533:
534: ROLLBACK TO Insert_Row_Pvt ;
535: X_return_status := FND_API.G_RET_STS_ERROR;
536: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
537: IF (g_debug_mode = 'Y') THEN
538: g_debug_msg := ' IGCCDPFB -- Failure Execute Payment Forcast ID ...' || p_CC_Det_PF_Line_Id ||
539: ' For account Line ID ... ' || p_cc_acct_line_id;

Line 557: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

553: END IF;
554: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
555: p_data => X_msg_data );
556:
557: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
558:
559: ROLLBACK TO Insert_Row_Pvt ;
560: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
561: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

Line 560: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

556:
557: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
558:
559: ROLLBACK TO Insert_Row_Pvt ;
560: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
561: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
562: IF (g_debug_mode = 'Y') THEN
563: g_debug_msg := ' IGCCDPFB -- Failure Unexpected Payment Forcast ID...' || p_CC_Det_PF_Line_Id ||
564: ' For account Line ID ... ' || p_cc_acct_line_id;

Line 585: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

581:
582: WHEN OTHERS THEN
583:
584: ROLLBACK TO Insert_Row_Pvt ;
585: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
586: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
587: IF (g_debug_mode = 'Y') THEN
588: g_debug_msg := ' IGCCDPFB -- Failure Others Payment Forcast ID ...' || p_CC_Det_PF_Line_Id ||
589: ' For account Line ID ... ' || p_cc_acct_line_id;

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

623: ===============================================================================*/
624:
625: PROCEDURE Lock_Row(
626: p_api_version IN NUMBER,
627: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
628: p_commit IN VARCHAR2 := FND_API.G_FALSE,
629: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
630: X_return_status OUT NOCOPY VARCHAR2,
631: X_msg_count OUT NOCOPY NUMBER,

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

624:
625: PROCEDURE Lock_Row(
626: p_api_version IN NUMBER,
627: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
628: p_commit IN VARCHAR2 := FND_API.G_FALSE,
629: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
630: X_return_status OUT NOCOPY VARCHAR2,
631: X_msg_count OUT NOCOPY NUMBER,
632: X_msg_data OUT NOCOPY VARCHAR2,

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

625: PROCEDURE Lock_Row(
626: p_api_version IN NUMBER,
627: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
628: p_commit IN VARCHAR2 := FND_API.G_FALSE,
629: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
630: X_return_status OUT NOCOPY VARCHAR2,
631: X_msg_count OUT NOCOPY NUMBER,
632: X_msg_data OUT NOCOPY VARCHAR2,
633: p_Rowid IN OUT NOCOPY VARCHAR2,

Line 692: IF NOT FND_API.Compatible_API_Call ( l_api_version,

688: l_full_path := g_path||'Lock_Row';--bug 3199488
689:
690: SAVEPOINT Lock_Row_Pvt ;
691:
692: IF NOT FND_API.Compatible_API_Call ( l_api_version,
693: p_api_version,
694: l_api_name,
695: G_PKG_NAME )
696: THEN

Line 697: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

693: p_api_version,
694: l_api_name,
695: G_PKG_NAME )
696: THEN
697: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
698: END IF;
699:
700: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
701: FND_MSG_PUB.initialize ;

Line 700: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

696: THEN
697: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
698: END IF;
699:
700: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
701: FND_MSG_PUB.initialize ;
702: END IF;
703:
704: X_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 704: X_return_status := FND_API.G_RET_STS_SUCCESS ;

700: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
701: FND_MSG_PUB.initialize ;
702: END IF;
703:
704: X_return_status := FND_API.G_RET_STS_SUCCESS ;
705: X_row_locked := FND_API.G_TRUE ;
706: -- l_debug := FND_PROFILE.VALUE('IGC_DEBUG_ENABLED');
707:
708: -- IF (l_debug = 'Y') THEN

Line 705: X_row_locked := FND_API.G_TRUE ;

701: FND_MSG_PUB.initialize ;
702: END IF;
703:
704: X_return_status := FND_API.G_RET_STS_SUCCESS ;
705: X_row_locked := FND_API.G_TRUE ;
706: -- l_debug := FND_PROFILE.VALUE('IGC_DEBUG_ENABLED');
707:
708: -- IF (l_debug = 'Y') THEN
709: -- l_debug := FND_API.G_TRUE;

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

705: X_row_locked := FND_API.G_TRUE ;
706: -- l_debug := FND_PROFILE.VALUE('IGC_DEBUG_ENABLED');
707:
708: -- IF (l_debug = 'Y') THEN
709: -- l_debug := FND_API.G_TRUE;
710: -- ELSE
711: -- l_debug := FND_API.G_FALSE;
712: -- END IF;
713: -- IGC_MSGS_PKG.g_debug_mode := FND_API.TO_BOOLEAN(l_debug);

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

707:
708: -- IF (l_debug = 'Y') THEN
709: -- l_debug := FND_API.G_TRUE;
710: -- ELSE
711: -- l_debug := FND_API.G_FALSE;
712: -- END IF;
713: -- IGC_MSGS_PKG.g_debug_mode := FND_API.TO_BOOLEAN(l_debug);
714:
715: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

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

709: -- l_debug := FND_API.G_TRUE;
710: -- ELSE
711: -- l_debug := FND_API.G_FALSE;
712: -- END IF;
713: -- IGC_MSGS_PKG.g_debug_mode := FND_API.TO_BOOLEAN(l_debug);
714:
715: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
716: IF (g_debug_mode = 'Y') THEN
717: g_debug_msg := ' IGCCDPFB -- Begin Lock Payment Forcast Line ID ...' || p_CC_Det_PF_Line_Id ||

Line 733: RAISE FND_API.G_EXC_ERROR ;

729: IF(g_excep_level >= g_debug_level) THEN
730: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);
731: END IF;
732: FND_MSG_PUB.Add;
733: RAISE FND_API.G_EXC_ERROR ;
734: END IF;
735:
736: CLOSE C;
737:

Line 838: RAISE FND_API.G_EXC_ERROR ;

834: IF(g_excep_level >= g_debug_level) THEN
835: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);
836: END IF;
837: FND_MSG_PUB.Add;
838: RAISE FND_API.G_EXC_ERROR ;
839:
840: END IF;
841:
842: IF FND_API.To_Boolean ( p_commit ) THEN

Line 842: IF FND_API.To_Boolean ( p_commit ) THEN

838: RAISE FND_API.G_EXC_ERROR ;
839:
840: END IF;
841:
842: IF FND_API.To_Boolean ( p_commit ) THEN
843: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
844: IF (g_debug_mode = 'Y') THEN
845: g_debug_msg := ' IGCCDPFB -- Committing Lock Payment Forcast line';
846: Output_Debug (p_path => l_full_path ,p_debug_msg => g_debug_msg);

Line 868: X_row_locked := FND_API.G_FALSE;

864:
865: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
866:
867: ROLLBACK TO Lock_Row_Pvt ;
868: X_row_locked := FND_API.G_FALSE;
869: X_return_status := FND_API.G_RET_STS_ERROR;
870: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
871: IF (g_debug_mode = 'Y') THEN
872: g_debug_msg := ' IGCCDPFB -- Failure Record Lock exception Payment Forcast line';

Line 869: X_return_status := FND_API.G_RET_STS_ERROR;

865: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
866:
867: ROLLBACK TO Lock_Row_Pvt ;
868: X_row_locked := FND_API.G_FALSE;
869: X_return_status := FND_API.G_RET_STS_ERROR;
870: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
871: IF (g_debug_mode = 'Y') THEN
872: g_debug_msg := ' IGCCDPFB -- Failure Record Lock exception Payment Forcast line';
873: Output_Debug (p_path => l_full_path ,p_debug_msg => g_debug_msg,p_sev_level => g_excep_level);

Line 878: WHEN FND_API.G_EXC_ERROR THEN

874: END IF;
875: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
876: p_data => X_msg_data );
877:
878: WHEN FND_API.G_EXC_ERROR THEN
879:
880: ROLLBACK TO Lock_Row_Pvt ;
881: X_return_status := FND_API.G_RET_STS_ERROR;
882: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

Line 881: X_return_status := FND_API.G_RET_STS_ERROR;

877:
878: WHEN FND_API.G_EXC_ERROR THEN
879:
880: ROLLBACK TO Lock_Row_Pvt ;
881: X_return_status := FND_API.G_RET_STS_ERROR;
882: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
883: IF (g_debug_mode = 'Y') THEN
884: g_debug_msg := ' IGCCDPFB -- Failure Execute exception Payment Forcast line';
885: Output_Debug (p_path => l_full_path ,p_debug_msg => g_debug_msg,p_sev_level => g_excep_level);

Line 890: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

886: END IF;
887: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
888: p_data => X_msg_data );
889:
890: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
891:
892: ROLLBACK TO Lock_Row_Pvt ;
893: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
894: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

Line 893: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

889:
890: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
891:
892: ROLLBACK TO Lock_Row_Pvt ;
893: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
894: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
895: IF (g_debug_mode = 'Y') THEN
896: g_debug_msg := ' IGCCDPFB -- Failure Unexpected exception Payment Forcast line';
897: Output_Debug (p_path => l_full_path ,p_debug_msg => g_debug_msg,p_sev_level => g_excep_level);

Line 905: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

901:
902: WHEN OTHERS THEN
903:
904: ROLLBACK TO Lock_Row_Pvt ;
905: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
906: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
907: IF (g_debug_mode = 'Y') THEN
908: g_debug_msg := ' IGCCDPFB -- Failure Others exception Payment Forcast line';
909: Output_Debug (p_path => l_full_path ,p_debug_msg => g_debug_msg,p_sev_level => g_excep_level);

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

931: ===============================================================================*/
932:
933: PROCEDURE Update_Row(
934: p_api_version IN NUMBER,
935: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
936: p_commit IN VARCHAR2 := FND_API.G_FALSE,
937: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
938: X_return_status OUT NOCOPY VARCHAR2,
939: X_msg_count OUT NOCOPY NUMBER,

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

932:
933: PROCEDURE Update_Row(
934: p_api_version IN NUMBER,
935: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
936: p_commit IN VARCHAR2 := FND_API.G_FALSE,
937: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
938: X_return_status OUT NOCOPY VARCHAR2,
939: X_msg_count OUT NOCOPY NUMBER,
940: X_msg_data OUT NOCOPY VARCHAR2,

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

933: PROCEDURE Update_Row(
934: p_api_version IN NUMBER,
935: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
936: p_commit IN VARCHAR2 := FND_API.G_FALSE,
937: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
938: X_return_status OUT NOCOPY VARCHAR2,
939: X_msg_count OUT NOCOPY NUMBER,
940: X_msg_data OUT NOCOPY VARCHAR2,
941: p_Rowid IN OUT NOCOPY VARCHAR2,

Line 1016: IF NOT FND_API.Compatible_API_Call ( l_api_version,

1012: -- -----------------------------------------------------------------
1013: -- Ensure that the version requested to be used is correct for
1014: -- this API.
1015: -- -----------------------------------------------------------------
1016: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1017: p_api_version,
1018: l_api_name,
1019: G_PKG_NAME )
1020: THEN

Line 1021: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1017: p_api_version,
1018: l_api_name,
1019: G_PKG_NAME )
1020: THEN
1021: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1022: END IF;
1023:
1024: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
1025: FND_MSG_PUB.initialize ;

Line 1024: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

1020: THEN
1021: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1022: END IF;
1023:
1024: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
1025: FND_MSG_PUB.initialize ;
1026: END IF;
1027:
1028: X_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 1028: X_return_status := FND_API.G_RET_STS_SUCCESS ;

1024: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
1025: FND_MSG_PUB.initialize ;
1026: END IF;
1027:
1028: X_return_status := FND_API.G_RET_STS_SUCCESS ;
1029: -- l_debug := FND_PROFILE.VALUE('IGC_DEBUG_ENABLED');
1030:
1031: -- IF (l_debug = 'Y') THEN
1032: -- l_debug := FND_API.G_TRUE;

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

1028: X_return_status := FND_API.G_RET_STS_SUCCESS ;
1029: -- l_debug := FND_PROFILE.VALUE('IGC_DEBUG_ENABLED');
1030:
1031: -- IF (l_debug = 'Y') THEN
1032: -- l_debug := FND_API.G_TRUE;
1033: -- ELSE
1034: -- l_debug := FND_API.G_FALSE;
1035: -- END IF;
1036: -- IGC_MSGS_PKG.g_debug_mode := FND_API.TO_BOOLEAN(l_debug);

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

1030:
1031: -- IF (l_debug = 'Y') THEN
1032: -- l_debug := FND_API.G_TRUE;
1033: -- ELSE
1034: -- l_debug := FND_API.G_FALSE;
1035: -- END IF;
1036: -- IGC_MSGS_PKG.g_debug_mode := FND_API.TO_BOOLEAN(l_debug);
1037:
1038: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

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

1032: -- l_debug := FND_API.G_TRUE;
1033: -- ELSE
1034: -- l_debug := FND_API.G_FALSE;
1035: -- END IF;
1036: -- IGC_MSGS_PKG.g_debug_mode := FND_API.TO_BOOLEAN(l_debug);
1037:
1038: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
1039: IF (g_debug_mode = 'Y') THEN
1040: g_debug_msg := ' IGCCDPFB -- Starting Update Payment Forcast Line ID ...' || p_CC_Det_PF_Line_Id ||

Line 1111: RAISE FND_API.G_EXC_ERROR;

1107: IF (g_debug_mode = 'Y') THEN
1108: g_debug_msg := ' IGCCDPFB -- Failure getting application ID for Payment Forcast Update.....';
1109: Output_Debug (p_path => l_full_path ,p_debug_msg => g_debug_msg);
1110: END IF;
1111: RAISE FND_API.G_EXC_ERROR;
1112: END IF;
1113:
1114: CLOSE c_igc_app_id;
1115:

Line 1130: RAISE FND_API.G_EXC_ERROR;

1126: IF (g_debug_mode = 'Y') THEN
1127: g_debug_msg := ' IGCCDPFB -- Failure getting Payment Forcast info for Update.....';
1128: Output_Debug (p_path => l_full_path ,p_debug_msg => g_debug_msg);
1129: END IF;
1130: RAISE FND_API.G_EXC_ERROR;
1131: END IF;
1132:
1133: CLOSE c_det_pf_info;
1134:

Line 1166: FND_API.G_FALSE,

1162: -- MRC Handler For IGC_CC_DET_PF to insert all MRC records for
1163: -- the reporting set of books for this PRIMARY set of books.
1164: -- ------------------------------------------------------------------
1165: IGC_CC_MC_MAIN_PVT.get_rsobs_DET_PF (l_api_version,
1166: FND_API.G_FALSE,
1167: FND_API.G_FALSE,
1168: p_validation_level,
1169: l_return_status,
1170: X_msg_count,

Line 1167: FND_API.G_FALSE,

1163: -- the reporting set of books for this PRIMARY set of books.
1164: -- ------------------------------------------------------------------
1165: IGC_CC_MC_MAIN_PVT.get_rsobs_DET_PF (l_api_version,
1166: FND_API.G_FALSE,
1167: FND_API.G_FALSE,
1168: p_validation_level,
1169: l_return_status,
1170: X_msg_count,
1171: X_msg_data,

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

1181:
1182: -- ------------------------------------------------------------------
1183: -- Make sure that the insertion was a success
1184: -- ------------------------------------------------------------------
1185: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1186: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
1187: IF (g_debug_mode = 'Y') THEN
1188: g_debug_msg := ' IGCCDPFB -- Failure returned from MRC for update.....';
1189: Output_Debug (p_path => l_full_path ,p_debug_msg => g_debug_msg);

Line 1191: RAISE FND_API.G_EXC_ERROR;

1187: IF (g_debug_mode = 'Y') THEN
1188: g_debug_msg := ' IGCCDPFB -- Failure returned from MRC for update.....';
1189: Output_Debug (p_path => l_full_path ,p_debug_msg => g_debug_msg);
1190: END IF;
1191: RAISE FND_API.G_EXC_ERROR;
1192: END IF;
1193:
1194: END IF;
1195:

Line 1200: IF FND_API.To_Boolean ( p_commit ) THEN

1196: -- -----------------------------------------------------------------
1197: -- If the records are to be commited in this procedure then
1198: -- commit the work now otherwise wait for the caller to do COMMIT.
1199: -- -----------------------------------------------------------------
1200: IF FND_API.To_Boolean ( p_commit ) THEN
1201: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
1202: IF (g_debug_mode = 'Y') THEN
1203: g_debug_msg := ' IGCCDPFB -- Committing work for Payment Forcast update.....';
1204: Output_Debug (p_path => l_full_path ,p_debug_msg => g_debug_msg);

Line 1223: WHEN FND_API.G_EXC_ERROR THEN

1219: RETURN;
1220:
1221: EXCEPTION
1222:
1223: WHEN FND_API.G_EXC_ERROR THEN
1224:
1225: ROLLBACK TO Update_Row_Pvt ;
1226: X_return_status := FND_API.G_RET_STS_ERROR;
1227: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

Line 1226: X_return_status := FND_API.G_RET_STS_ERROR;

1222:
1223: WHEN FND_API.G_EXC_ERROR THEN
1224:
1225: ROLLBACK TO Update_Row_Pvt ;
1226: X_return_status := FND_API.G_RET_STS_ERROR;
1227: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
1228: IF (g_debug_mode = 'Y') THEN
1229: g_debug_msg := ' IGCCDPFB -- Failure Execute Payment Forcast Update.....';
1230: Output_Debug (p_path => l_full_path ,p_debug_msg => g_debug_msg,p_sev_level => g_excep_level);

Line 1241: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1237: END IF;
1238: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
1239: p_data => X_msg_data );
1240:
1241: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1242:
1243: ROLLBACK TO Update_Row_Pvt ;
1244: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1245: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

Line 1244: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1240:
1241: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1242:
1243: ROLLBACK TO Update_Row_Pvt ;
1244: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1245: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
1246: IF (g_debug_mode = 'Y') THEN
1247: g_debug_msg := ' IGCCDPFB -- Failure Unexpected Payment Forcast Update.....';
1248: Output_Debug (p_path => l_full_path ,p_debug_msg => g_debug_msg,p_sev_level => g_excep_level);

Line 1262: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1258:
1259: WHEN OTHERS THEN
1260:
1261: ROLLBACK TO Update_Row_Pvt ;
1262: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1263: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
1264: IF (g_debug_mode = 'Y') THEN
1265: g_debug_msg := ' IGCCDPFB -- Failure Others Payment Forcast Update.....';
1266: Output_Debug (p_path => l_full_path ,p_debug_msg => g_debug_msg,p_sev_level => g_excep_level);

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

1295:
1296:
1297: PROCEDURE Delete_Row(
1298: p_api_version IN NUMBER,
1299: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1300: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1301: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1302: X_return_status OUT NOCOPY VARCHAR2,
1303: X_msg_count OUT NOCOPY NUMBER,

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

1296:
1297: PROCEDURE Delete_Row(
1298: p_api_version IN NUMBER,
1299: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1300: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1301: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1302: X_return_status OUT NOCOPY VARCHAR2,
1303: X_msg_count OUT NOCOPY NUMBER,
1304: X_msg_data OUT NOCOPY VARCHAR2,

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

1297: PROCEDURE Delete_Row(
1298: p_api_version IN NUMBER,
1299: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1300: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1301: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1302: X_return_status OUT NOCOPY VARCHAR2,
1303: X_msg_count OUT NOCOPY NUMBER,
1304: X_msg_data OUT NOCOPY VARCHAR2,
1305: p_Rowid IN OUT NOCOPY VARCHAR2,

Line 1368: IF NOT FND_API.Compatible_API_Call ( l_api_version,

1364: -- -----------------------------------------------------------------
1365: -- Ensure that the version requested to be used is correct for
1366: -- this API.
1367: -- -----------------------------------------------------------------
1368: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1369: p_api_version,
1370: l_api_name,
1371: G_PKG_NAME )
1372: THEN

Line 1373: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1369: p_api_version,
1370: l_api_name,
1371: G_PKG_NAME )
1372: THEN
1373: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1374: END IF;
1375:
1376: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
1377: FND_MSG_PUB.initialize ;

Line 1376: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

1372: THEN
1373: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1374: END IF;
1375:
1376: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
1377: FND_MSG_PUB.initialize ;
1378: END IF ;
1379:
1380: X_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 1380: X_return_status := FND_API.G_RET_STS_SUCCESS ;

1376: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
1377: FND_MSG_PUB.initialize ;
1378: END IF ;
1379:
1380: X_return_status := FND_API.G_RET_STS_SUCCESS ;
1381: -- l_debug := FND_PROFILE.VALUE('IGC_DEBUG_ENABLED');
1382:
1383: -- IF (l_debug = 'Y') THEN
1384: -- l_debug := FND_API.G_TRUE;

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

1380: X_return_status := FND_API.G_RET_STS_SUCCESS ;
1381: -- l_debug := FND_PROFILE.VALUE('IGC_DEBUG_ENABLED');
1382:
1383: -- IF (l_debug = 'Y') THEN
1384: -- l_debug := FND_API.G_TRUE;
1385: -- ELSE
1386: -- l_debug := FND_API.G_FALSE;
1387: -- END IF;
1388: -- IGC_MSGS_PKG.g_debug_mode := FND_API.TO_BOOLEAN(l_debug);

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

1382:
1383: -- IF (l_debug = 'Y') THEN
1384: -- l_debug := FND_API.G_TRUE;
1385: -- ELSE
1386: -- l_debug := FND_API.G_FALSE;
1387: -- END IF;
1388: -- IGC_MSGS_PKG.g_debug_mode := FND_API.TO_BOOLEAN(l_debug);
1389:
1390: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

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

1384: -- l_debug := FND_API.G_TRUE;
1385: -- ELSE
1386: -- l_debug := FND_API.G_FALSE;
1387: -- END IF;
1388: -- IGC_MSGS_PKG.g_debug_mode := FND_API.TO_BOOLEAN(l_debug);
1389:
1390: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
1391: IF (g_debug_mode = 'Y') THEN
1392: g_debug_msg := ' IGCCDPFB -- Starting Payment Forcast delete Row ID ... ' || p_rowid;

Line 1434: FND_API.G_FALSE,

1430: CLOSE c_det_pf_row_info;
1431:
1432: IGC_CC_DET_PF_HISTORY_PKG.Insert_Row(
1433: l_api_version,
1434: FND_API.G_FALSE,
1435: FND_API.G_FALSE,
1436: p_validation_level,
1437: l_return_status,
1438: X_msg_count,

Line 1435: FND_API.G_FALSE,

1431:
1432: IGC_CC_DET_PF_HISTORY_PKG.Insert_Row(
1433: l_api_version,
1434: FND_API.G_FALSE,
1435: FND_API.G_FALSE,
1436: p_validation_level,
1437: l_return_status,
1438: X_msg_count,
1439: X_msg_data,

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

1479:
1480: -- ------------------------------------------------------------------
1481: -- Make sure that the insertion of History Record was a success
1482: -- ------------------------------------------------------------------
1483: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1484: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
1485: IF (g_debug_mode = 'Y') THEN
1486: g_debug_msg := ' IGCCDPFB -- Failure returned from Payment FC History insert.....';
1487: Output_Debug (p_path => l_full_path ,p_debug_msg => g_debug_msg);

Line 1489: RAISE FND_API.G_EXC_ERROR;

1485: IF (g_debug_mode = 'Y') THEN
1486: g_debug_msg := ' IGCCDPFB -- Failure returned from Payment FC History insert.....';
1487: Output_Debug (p_path => l_full_path ,p_debug_msg => g_debug_msg);
1488: END IF;
1489: RAISE FND_API.G_EXC_ERROR;
1490: END IF;
1491:
1492: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
1493: IF (g_debug_mode = 'Y') THEN

Line 1515: RAISE FND_API.G_EXC_ERROR;

1511: IF (g_debug_mode = 'Y') THEN
1512: g_debug_msg := ' IGCCDPFB -- Failure obtaining application ID in delete operation...';
1513: Output_Debug (p_path => l_full_path ,p_debug_msg => g_debug_msg);
1514: END IF;
1515: RAISE FND_API.G_EXC_ERROR;
1516: END IF;
1517:
1518: CLOSE c_igc_app_id;
1519:

Line 1539: RAISE FND_API.G_EXC_ERROR;

1535: IF (g_debug_mode = 'Y') THEN
1536: g_debug_msg := ' IGCCDPFB -- Failure obtaining CC Info conversion date in delete...';
1537: Output_Debug (p_path => l_full_path ,p_debug_msg => g_debug_msg);
1538: END IF;
1539: RAISE FND_API.G_EXC_ERROR;
1540: END IF;
1541:
1542: CLOSE c_cc_info;
1543:

Line 1573: FND_API.G_FALSE,

1569: -- MRC Handler For IGC_CC_DET_PF to insert all MRC records for
1570: -- the reporting set of books for this PRIMARY set of books.
1571: -- ------------------------------------------------------------------
1572: IGC_CC_MC_MAIN_PVT.get_rsobs_DET_PF (l_api_version,
1573: FND_API.G_FALSE,
1574: FND_API.G_FALSE,
1575: p_validation_level,
1576: l_return_status,
1577: X_msg_count,

Line 1574: FND_API.G_FALSE,

1570: -- the reporting set of books for this PRIMARY set of books.
1571: -- ------------------------------------------------------------------
1572: IGC_CC_MC_MAIN_PVT.get_rsobs_DET_PF (l_api_version,
1573: FND_API.G_FALSE,
1574: FND_API.G_FALSE,
1575: p_validation_level,
1576: l_return_status,
1577: X_msg_count,
1578: X_msg_data,

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

1587:
1588: -- ------------------------------------------------------------------
1589: -- Make sure that the insertion was a success
1590: -- ------------------------------------------------------------------
1591: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1592: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
1593: IF (g_debug_mode = 'Y') THEN
1594: g_debug_msg := ' IGCCACLB -- Failure returned from MC.get_rsobs_Acct_Lines delete...';
1595: Output_Debug (p_path => l_full_path ,p_debug_msg => g_debug_msg);

Line 1597: RAISE FND_API.G_EXC_ERROR;

1593: IF (g_debug_mode = 'Y') THEN
1594: g_debug_msg := ' IGCCACLB -- Failure returned from MC.get_rsobs_Acct_Lines delete...';
1595: Output_Debug (p_path => l_full_path ,p_debug_msg => g_debug_msg);
1596: END IF;
1597: RAISE FND_API.G_EXC_ERROR;
1598: END IF;
1599:
1600: END IF;
1601:

Line 1624: IF FND_API.To_Boolean ( p_commit ) THEN

1620: -- -----------------------------------------------------------------
1621: -- If the records are to be commited in this procedure then
1622: -- commit the work now otherwise wait for the caller to do COMMIT.
1623: -- -----------------------------------------------------------------
1624: IF FND_API.To_Boolean ( p_commit ) THEN
1625: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
1626: IF (g_debug_mode = 'Y') THEN
1627: g_debug_msg := ' IGCCDPFB -- Payment FC Delete being Committed.....';
1628: Output_Debug (p_path => l_full_path ,p_debug_msg => g_debug_msg);

Line 1646: WHEN FND_API.G_EXC_ERROR THEN

1642: RETURN;
1643:
1644: EXCEPTION
1645:
1646: WHEN FND_API.G_EXC_ERROR THEN
1647:
1648: ROLLBACK TO Delete_Row_Pvt ;
1649: X_return_status := FND_API.G_RET_STS_ERROR;
1650: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

Line 1649: X_return_status := FND_API.G_RET_STS_ERROR;

1645:
1646: WHEN FND_API.G_EXC_ERROR THEN
1647:
1648: ROLLBACK TO Delete_Row_Pvt ;
1649: X_return_status := FND_API.G_RET_STS_ERROR;
1650: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
1651: IF (g_debug_mode = 'Y') THEN
1652: g_debug_msg := ' IGCCDPFB -- Failure Delete Execute Error.....';
1653: Output_Debug (p_path => l_full_path ,p_debug_msg => g_debug_msg,p_sev_level => g_excep_level);

Line 1664: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1660: END IF;
1661: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
1662: p_data => X_msg_data );
1663:
1664: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1665:
1666: ROLLBACK TO Delete_Row_Pvt ;
1667: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1668: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

Line 1667: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1663:
1664: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1665:
1666: ROLLBACK TO Delete_Row_Pvt ;
1667: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1668: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
1669: IF (g_debug_mode = 'Y') THEN
1670: g_debug_msg := ' IGCCDPFB -- Failure Delete Unexpected Error.....';
1671: Output_Debug (p_path => l_full_path ,p_debug_msg => g_debug_msg,p_sev_level => g_excep_level);

Line 1685: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1681:
1682: WHEN OTHERS THEN
1683:
1684: ROLLBACK TO Delete_Row_Pvt ;
1685: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1686: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
1687: IF (g_debug_mode = 'Y') THEN
1688: g_debug_msg := ' IGCCDPFB -- Failure Delete Others Error.....';
1689: Output_Debug (p_path => l_full_path ,p_debug_msg => g_debug_msg,p_sev_level => g_excep_level);