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

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

136: p_sub_comp => l_sub_comp,
137: p_filename_val => NULL,
138: x_Return_Status => l_Return_Status
139: );
140: IF (l_Return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
141: raise FND_API.G_EXC_ERROR;
142: END IF;*/
143:
144: RETURN;

Line 141: raise FND_API.G_EXC_ERROR;

137: p_filename_val => NULL,
138: x_Return_Status => l_Return_Status
139: );
140: IF (l_Return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
141: raise FND_API.G_EXC_ERROR;
142: END IF;*/
143:
144: RETURN;
145:

Line 151: /*WHEN FND_API.G_EXC_ERROR THEN

147: -- Exception handler section for the Put_Debug_Msg procedure.
148: -- --------------------------------------------------------------------
149: EXCEPTION
150:
151: /*WHEN FND_API.G_EXC_ERROR THEN
152: RETURN;*/
153:
154: WHEN OTHERS THEN
155: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

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

198: +=======================================================================*/
199: PROCEDURE Validate_CCID
200: (
201: p_api_version IN NUMBER,
202: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
203: p_commit IN VARCHAR2 := FND_API.G_FALSE,
204: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
205: p_return_status OUT NOCOPY VARCHAR2,
206: p_msg_count OUT NOCOPY NUMBER,

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

199: PROCEDURE Validate_CCID
200: (
201: p_api_version IN NUMBER,
202: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
203: p_commit IN VARCHAR2 := FND_API.G_FALSE,
204: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
205: p_return_status OUT NOCOPY VARCHAR2,
206: p_msg_count OUT NOCOPY NUMBER,
207: p_msg_data OUT NOCOPY VARCHAR2,

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

200: (
201: p_api_version IN NUMBER,
202: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
203: p_commit IN VARCHAR2 := FND_API.G_FALSE,
204: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
205: p_return_status OUT NOCOPY VARCHAR2,
206: p_msg_count OUT NOCOPY NUMBER,
207: p_msg_data OUT NOCOPY VARCHAR2,
208:

Line 261: IF NOT FND_API.Compatible_API_Call ( l_api_version,

257: l_full_path := g_path || 'Validate_CCID';
258:
259: SAVEPOINT Validate_CCID_Pub;
260:
261: IF NOT FND_API.Compatible_API_Call ( l_api_version,
262: p_api_version,
263: l_api_name,
264: G_PKG_NAME )
265: THEN

Line 266: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

262: p_api_version,
263: l_api_name,
264: G_PKG_NAME )
265: THEN
266: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
267: END IF;
268:
269: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
270: FND_MSG_PUB.initialize ;

Line 269: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

265: THEN
266: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
267: END IF;
268:
269: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
270: FND_MSG_PUB.initialize ;
271: END IF;
272:
273: -- --------------------------------------------------------------------

Line 276: p_return_status := FND_API.G_RET_STS_SUCCESS;

272:
273: -- --------------------------------------------------------------------
274: -- Initialize Return status
275: -- --------------------------------------------------------------------
276: p_return_status := FND_API.G_RET_STS_SUCCESS;
277: p_result_code := NULL;
278:
279: -- --------------------------------------------------------------------
280: -- Retrieve data to check that the CCID is a valid to check flags that

Line 365: IF FND_API.To_Boolean ( p_commit ) THEN

361: IF (c_validate_ccid_values%ISOPEN) THEN
362: CLOSE c_validate_ccid_values;
363: END IF;
364:
365: IF FND_API.To_Boolean ( p_commit ) THEN
366: COMMIT WORK;
367: END iF;
368:
369: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 379: WHEN FND_API.G_EXC_ERROR THEN

375: -- Exception handler section for the Validate_CCID procedure.
376: -- -------------------------------------------------------------------------
377: EXCEPTION
378:
379: WHEN FND_API.G_EXC_ERROR THEN
380:
381: ROLLBACK TO Validate_CCID_Pub;
382: p_return_status := FND_API.G_RET_STS_ERROR;
383: p_result_code := NULL;

Line 382: p_return_status := FND_API.G_RET_STS_ERROR;

378:
379: WHEN FND_API.G_EXC_ERROR THEN
380:
381: ROLLBACK TO Validate_CCID_Pub;
382: p_return_status := FND_API.G_RET_STS_ERROR;
383: p_result_code := NULL;
384: IF (c_validate_ccid_values%ISOPEN) THEN
385: CLOSE c_validate_ccid_values;
386: END IF;

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

386: END IF;
387: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
388: p_data => p_msg_data );
389: IF (g_excep_level >= g_debug_level ) THEN
390: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_ERROR Exception Raised');
391: END IF;
392: RETURN;
393:
394: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 394: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

390: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_ERROR Exception Raised');
391: END IF;
392: RETURN;
393:
394: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
395:
396: ROLLBACK TO Validate_CCID_Pub;
397: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
398: p_result_code := NULL;

Line 397: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

393:
394: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
395:
396: ROLLBACK TO Validate_CCID_Pub;
397: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
398: p_result_code := NULL;
399: IF (c_validate_ccid_values%ISOPEN) THEN
400: CLOSE c_validate_ccid_values;
401: END IF;

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

401: END IF;
402: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
403: p_data => p_msg_data );
404: IF (g_excep_level >= g_debug_level ) THEN
405: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_UNEXPECTED_ERROR Exception Raised');
406: END IF;
407: RETURN;
408:
409: WHEN OTHERS THEN

Line 412: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

408:
409: WHEN OTHERS THEN
410:
411: ROLLBACK TO Validate_CCID_Pub;
412: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
413: p_result_code := NULL;
414: IF (c_validate_ccid_values%ISOPEN) THEN
415: CLOSE c_validate_ccid_values;
416: END IF;

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

473: +=======================================================================*/
474: PROCEDURE Validate_Get_CCID_Budget_Info
475: (
476: p_api_version IN NUMBER,
477: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
478: p_commit IN VARCHAR2 := FND_API.G_FALSE,
479: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
480: p_return_status OUT NOCOPY VARCHAR2,
481: p_msg_count OUT NOCOPY NUMBER,

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

474: PROCEDURE Validate_Get_CCID_Budget_Info
475: (
476: p_api_version IN NUMBER,
477: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
478: p_commit IN VARCHAR2 := FND_API.G_FALSE,
479: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
480: p_return_status OUT NOCOPY VARCHAR2,
481: p_msg_count OUT NOCOPY NUMBER,
482: p_msg_data OUT NOCOPY VARCHAR2,

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

475: (
476: p_api_version IN NUMBER,
477: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
478: p_commit IN VARCHAR2 := FND_API.G_FALSE,
479: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
480: p_return_status OUT NOCOPY VARCHAR2,
481: p_msg_count OUT NOCOPY NUMBER,
482: p_msg_data OUT NOCOPY VARCHAR2,
483:

Line 640: IF NOT FND_API.Compatible_API_Call ( l_api_version,

636: l_full_path := g_path || 'Validate_Get_CCID_Budget_Info';
637:
638: SAVEPOINT Valid_Get_CCID_Bdg_Info_Pub;
639:
640: IF NOT FND_API.Compatible_API_Call ( l_api_version,
641: p_api_version,
642: l_api_name,
643: G_PKG_NAME )
644: THEN

Line 645: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

641: p_api_version,
642: l_api_name,
643: G_PKG_NAME )
644: THEN
645: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
646: END IF;
647:
648: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
649: FND_MSG_PUB.initialize ;

Line 648: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

644: THEN
645: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
646: END IF;
647:
648: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
649: FND_MSG_PUB.initialize ;
650: END IF;
651:
652: -- -------------------------------------------------------------------

Line 655: p_return_status := FND_API.G_RET_STS_SUCCESS ;

651:
652: -- -------------------------------------------------------------------
653: -- Initialize return status to Success.
654: -- -------------------------------------------------------------------
655: p_return_status := FND_API.G_RET_STS_SUCCESS ;
656:
657: -- --------------------------------------------------------------------
658: -- Obtain the application ID that will be used throughout this process.
659: -- --------------------------------------------------------------------

Line 687: IF FND_API.TO_BOOLEAN(p_efc_enabled) THEN

683: IF (c_igc_je_detail_info%NOTFOUND) THEN
684:
685: l_funds_level_code := 'N';
686:
687: IF FND_API.TO_BOOLEAN(p_efc_enabled) THEN
688:
689: BEGIN
690:
691: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

Line 799: IF (NOT FND_API.TO_BOOLEAN(p_efc_enabled)) THEN

795: END IF;
796:
797: END IF;
798:
799: IF (NOT FND_API.TO_BOOLEAN(p_efc_enabled)) THEN
800:
801: l_funds_level_code := 'N';
802:
803: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

Line 836: RAISE FND_API.G_EXC_ERROR;

832: END IF;
833: message_token ('CCID', to_char(p_ccid));
834: message_token ('SOB_ID', to_char(p_set_of_books_id));
835: add_message ('IGC', 'IGC_BUDGET_NOT_FOUND');
836: RAISE FND_API.G_EXC_ERROR;
837:
838: END IF;
839:
840: IF ((l_funds_level_code <> 'N') AND

Line 852: RAISE FND_API.G_EXC_ERROR;

848: END IF;
849: message_token ('CCID', to_char(p_ccid));
850: message_token ('SOB_ID', to_char(p_set_of_books_id));
851: add_message ('IGC', 'IGC_INVALID_BUDGET_STATE');
852: RAISE FND_API.G_EXC_ERROR;
853:
854: END IF;
855:
856: -- -------------------------------------------------------------------------

Line 883: IF FND_API.To_Boolean ( p_commit ) THEN

879: CLOSE c_igc_je_summary_info;
880: END IF;
881: */
882:
883: IF FND_API.To_Boolean ( p_commit ) THEN
884: COMMIT WORK;
885: END iF;
886:
887: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 897: WHEN FND_API.G_EXC_ERROR THEN

893: -- Exception handler section for the Get_CCID_Budget_Info procedure.
894: -- -------------------------------------------------------------------------
895: EXCEPTION
896:
897: WHEN FND_API.G_EXC_ERROR THEN
898:
899: ROLLBACK TO Valid_Get_CCID_Bdg_Info_Pub;
900: p_return_status := FND_API.G_RET_STS_ERROR;
901: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 900: p_return_status := FND_API.G_RET_STS_ERROR;

896:
897: WHEN FND_API.G_EXC_ERROR THEN
898:
899: ROLLBACK TO Valid_Get_CCID_Bdg_Info_Pub;
900: p_return_status := FND_API.G_RET_STS_ERROR;
901: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
902: p_data => p_msg_data );
903: IF (g_excep_level >= g_debug_level ) THEN
904: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_ERROR Exception Raised');

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

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

Line 907: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

903: IF (g_excep_level >= g_debug_level ) THEN
904: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_ERROR Exception Raised');
905: END IF;
906:
907: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
908:
909: ROLLBACK TO Valid_Get_CCID_Bdg_Info_Pub;
910: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
911: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 910: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

906:
907: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
908:
909: ROLLBACK TO Valid_Get_CCID_Bdg_Info_Pub;
910: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
911: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
912: p_data => p_msg_data );
913: IF (g_excep_level >= g_debug_level ) THEN
914: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_UNEXPECTED_ERROR Exception Raised');

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

910: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
911: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
912: p_data => p_msg_data );
913: IF (g_excep_level >= g_debug_level ) THEN
914: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_UNEXPECTED_ERROR Exception Raised');
915: END IF;
916:
917: WHEN OTHERS THEN
918:

Line 920: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

916:
917: WHEN OTHERS THEN
918:
919: ROLLBACK TO Valid_Get_CCID_Bdg_Info_Pub;
920: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
921:
922: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
923: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
924: l_api_name);

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

975: +=======================================================================*/
976: PROCEDURE Validate_Get_CCID_Period_Name
977: (
978: p_api_version IN NUMBER,
979: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
980: p_commit IN VARCHAR2 := FND_API.G_FALSE,
981: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
982: p_return_status OUT NOCOPY VARCHAR2,
983: p_msg_count OUT NOCOPY NUMBER,

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

976: PROCEDURE Validate_Get_CCID_Period_Name
977: (
978: p_api_version IN NUMBER,
979: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
980: p_commit IN VARCHAR2 := FND_API.G_FALSE,
981: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
982: p_return_status OUT NOCOPY VARCHAR2,
983: p_msg_count OUT NOCOPY NUMBER,
984: p_msg_data OUT NOCOPY VARCHAR2,

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

977: (
978: p_api_version IN NUMBER,
979: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
980: p_commit IN VARCHAR2 := FND_API.G_FALSE,
981: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
982: p_return_status OUT NOCOPY VARCHAR2,
983: p_msg_count OUT NOCOPY NUMBER,
984: p_msg_data OUT NOCOPY VARCHAR2,
985:

Line 1055: IF NOT FND_API.Compatible_API_Call ( l_api_version,

1051: l_full_path := g_path || 'Validate_Get_CCID_Period_Name';
1052:
1053: SAVEPOINT Valid_Get_CCID_Per_Name_Pub;
1054:
1055: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1056: p_api_version,
1057: l_api_name,
1058: G_PKG_NAME )
1059: THEN

Line 1060: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1056: p_api_version,
1057: l_api_name,
1058: G_PKG_NAME )
1059: THEN
1060: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1061: END IF;
1062:
1063: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
1064: FND_MSG_PUB.initialize ;

Line 1063: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

1059: THEN
1060: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1061: END IF;
1062:
1063: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
1064: FND_MSG_PUB.initialize ;
1065: END IF;
1066:
1067: -- -------------------------------------------------------------------------

Line 1070: p_return_status := FND_API.G_RET_STS_SUCCESS ;

1066:
1067: -- -------------------------------------------------------------------------
1068: -- Initialize variables here.
1069: -- -------------------------------------------------------------------------
1070: p_return_status := FND_API.G_RET_STS_SUCCESS ;
1071: p_period_name := NULL;
1072: p_period_set_name := NULL;
1073: p_quarter_num := 0;
1074: p_period_num := 0;

Line 1147: IF FND_API.To_Boolean ( p_commit ) THEN

1143: IF (c_igc_legacy_period_info%ISOPEN) THEN
1144: CLOSE c_igc_legacy_period_info;
1145: END IF;
1146:
1147: IF FND_API.To_Boolean ( p_commit ) THEN
1148: COMMIT WORK;
1149: END IF;
1150:
1151: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 1161: WHEN FND_API.G_EXC_ERROR THEN

1157: -- Exception handler section for the Validate_Get_CCID_Period_Name procedure.
1158: -- -------------------------------------------------------------------------
1159: EXCEPTION
1160:
1161: WHEN FND_API.G_EXC_ERROR THEN
1162:
1163: ROLLBACK TO Valid_Get_CCID_Per_Name_Pub;
1164: p_return_status := FND_API.G_RET_STS_ERROR;
1165: IF (c_igc_fc_period_info%ISOPEN) THEN

Line 1164: p_return_status := FND_API.G_RET_STS_ERROR;

1160:
1161: WHEN FND_API.G_EXC_ERROR THEN
1162:
1163: ROLLBACK TO Valid_Get_CCID_Per_Name_Pub;
1164: p_return_status := FND_API.G_RET_STS_ERROR;
1165: IF (c_igc_fc_period_info%ISOPEN) THEN
1166: CLOSE c_igc_fc_period_info;
1167: END IF;
1168: IF (c_igc_legacy_period_info%ISOPEN) THEN

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

1171:
1172: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
1173: p_data => p_msg_data );
1174: IF (g_excep_level >= g_debug_level ) THEN
1175: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_ERROR Exception Raised');
1176: END IF;
1177: RETURN;
1178:
1179: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1179: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1175: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_ERROR Exception Raised');
1176: END IF;
1177: RETURN;
1178:
1179: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1180:
1181: ROLLBACK TO Valid_Get_CCID_Per_Name_Pub;
1182: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1183: IF (c_igc_fc_period_info%ISOPEN) THEN

Line 1182: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1178:
1179: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1180:
1181: ROLLBACK TO Valid_Get_CCID_Per_Name_Pub;
1182: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1183: IF (c_igc_fc_period_info%ISOPEN) THEN
1184: CLOSE c_igc_fc_period_info;
1185: END IF;
1186: IF (c_igc_legacy_period_info%ISOPEN) THEN

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

1189:
1190: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
1191: p_data => p_msg_data );
1192: IF (g_excep_level >= g_debug_level ) THEN
1193: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_UNEXPECTED_ERROR Exception Raised');
1194: END IF;
1195: RETURN;
1196:
1197: WHEN OTHERS THEN

Line 1200: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1196:
1197: WHEN OTHERS THEN
1198:
1199: ROLLBACK TO Valid_Get_CCID_Per_Name_Pub;
1200: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1201: IF (c_igc_fc_period_info%ISOPEN) THEN
1202: CLOSE c_igc_fc_period_info;
1203: END IF;
1204: IF (c_igc_legacy_period_info%ISOPEN) THEN

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

1257: +=======================================================================*/
1258: PROCEDURE Validate_Check_EFC_Enabled
1259: (
1260: p_api_version IN NUMBER,
1261: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1262: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1263: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1264: p_return_status OUT NOCOPY VARCHAR2,
1265: p_msg_count OUT NOCOPY NUMBER,

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

1258: PROCEDURE Validate_Check_EFC_Enabled
1259: (
1260: p_api_version IN NUMBER,
1261: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1262: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1263: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1264: p_return_status OUT NOCOPY VARCHAR2,
1265: p_msg_count OUT NOCOPY NUMBER,
1266: p_msg_data OUT NOCOPY VARCHAR2,

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

1259: (
1260: p_api_version IN NUMBER,
1261: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1262: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1263: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1264: p_return_status OUT NOCOPY VARCHAR2,
1265: p_msg_count OUT NOCOPY NUMBER,
1266: p_msg_data OUT NOCOPY VARCHAR2,
1267:

Line 1301: IF NOT FND_API.Compatible_API_Call ( l_api_version,

1297: l_full_path := g_path || 'Validate_Check_EFC_Enabled';
1298:
1299: SAVEPOINT Validate_Check_EFC_Enabled_Pub;
1300:
1301: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1302: p_api_version,
1303: l_api_name,
1304: G_PKG_NAME )
1305: THEN

Line 1306: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1302: p_api_version,
1303: l_api_name,
1304: G_PKG_NAME )
1305: THEN
1306: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1307: END IF;
1308:
1309: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
1310: FND_MSG_PUB.initialize ;

Line 1309: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

1305: THEN
1306: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1307: END IF;
1308:
1309: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
1310: FND_MSG_PUB.initialize ;
1311: END IF;
1312:
1313: -- --------------------------------------------------------------------

Line 1316: p_return_status := FND_API.G_RET_STS_SUCCESS;

1312:
1313: -- --------------------------------------------------------------------
1314: -- Initialize variables here.
1315: -- --------------------------------------------------------------------
1316: p_return_status := FND_API.G_RET_STS_SUCCESS;
1317: p_efc_enabled := FND_API.G_FALSE;
1318:
1319: -- Bug 3432148, added schema name in the query
1320: IF NOT fnd_installation.get_app_info (application_short_name => 'PSA',

Line 1317: p_efc_enabled := FND_API.G_FALSE;

1313: -- --------------------------------------------------------------------
1314: -- Initialize variables here.
1315: -- --------------------------------------------------------------------
1316: p_return_status := FND_API.G_RET_STS_SUCCESS;
1317: p_efc_enabled := FND_API.G_FALSE;
1318:
1319: -- Bug 3432148, added schema name in the query
1320: IF NOT fnd_installation.get_app_info (application_short_name => 'PSA',
1321: status => l_prod_status,

Line 1329: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1325: IF g_debug_mode = 'Y' THEN
1326: Put_Debug_Msg (l_full_path, 'fnd_installation.get_app_info returned FALSE ');
1327: END IF;
1328:
1329: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1330: END IF;
1331:
1332: OPEN c_efc_table(l_schema);
1333: FETCH c_efc_table INTO l_enable;

Line 1351: p_efc_enabled := FND_API.G_TRUE;

1347:
1348: CLOSE c_efc_table;
1349:
1350: IF (l_enable = 'Y') THEN
1351: p_efc_enabled := FND_API.G_TRUE;
1352: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
1353: IF g_debug_mode = 'Y' THEN
1354: Put_Debug_Msg (l_full_path, 'EFC is enabled ');
1355: END IF;

Line 1357: p_efc_enabled := FND_API.G_FALSE;

1353: IF g_debug_mode = 'Y' THEN
1354: Put_Debug_Msg (l_full_path, 'EFC is enabled ');
1355: END IF;
1356: ELSE
1357: p_efc_enabled := FND_API.G_FALSE;
1358: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
1359: IF g_debug_mode = 'Y' THEN
1360: Put_Debug_Msg (l_full_path, 'EFC is NOT enabled ');
1361: END IF;

Line 1364: IF FND_API.To_Boolean ( p_commit ) THEN

1360: Put_Debug_Msg (l_full_path, 'EFC is NOT enabled ');
1361: END IF;
1362: END IF;
1363:
1364: IF FND_API.To_Boolean ( p_commit ) THEN
1365: COMMIT WORK;
1366: END IF;
1367:
1368: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 1378: WHEN FND_API.G_EXC_ERROR THEN

1374: -- Exception handler section for the Validate_Get_CCID_Period_Name procedure.
1375: -- --------------------------------------------------------------------
1376: EXCEPTION
1377:
1378: WHEN FND_API.G_EXC_ERROR THEN
1379:
1380: ROLLBACK TO Validate_Check_EFC_Enabled_Pub;
1381: p_return_status := FND_API.G_RET_STS_ERROR;
1382: p_efc_enabled := FND_API.G_FALSE;

Line 1381: p_return_status := FND_API.G_RET_STS_ERROR;

1377:
1378: WHEN FND_API.G_EXC_ERROR THEN
1379:
1380: ROLLBACK TO Validate_Check_EFC_Enabled_Pub;
1381: p_return_status := FND_API.G_RET_STS_ERROR;
1382: p_efc_enabled := FND_API.G_FALSE;
1383: IF (c_efc_table%ISOPEN) THEN
1384: CLOSE c_efc_table;
1385: END IF;

Line 1382: p_efc_enabled := FND_API.G_FALSE;

1378: WHEN FND_API.G_EXC_ERROR THEN
1379:
1380: ROLLBACK TO Validate_Check_EFC_Enabled_Pub;
1381: p_return_status := FND_API.G_RET_STS_ERROR;
1382: p_efc_enabled := FND_API.G_FALSE;
1383: IF (c_efc_table%ISOPEN) THEN
1384: CLOSE c_efc_table;
1385: END IF;
1386:

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

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

Line 1394: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1390: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_ERROR Exception Raised');
1391: END IF;
1392: RETURN;
1393:
1394: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1395:
1396: ROLLBACK TO Validate_Check_EFC_Enabled_Pub;
1397: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1398: p_efc_enabled := FND_API.G_FALSE;

Line 1397: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1393:
1394: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1395:
1396: ROLLBACK TO Validate_Check_EFC_Enabled_Pub;
1397: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1398: p_efc_enabled := FND_API.G_FALSE;
1399: IF (c_efc_table%ISOPEN) THEN
1400: CLOSE c_efc_table;
1401: END IF;

Line 1398: p_efc_enabled := FND_API.G_FALSE;

1394: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1395:
1396: ROLLBACK TO Validate_Check_EFC_Enabled_Pub;
1397: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1398: p_efc_enabled := FND_API.G_FALSE;
1399: IF (c_efc_table%ISOPEN) THEN
1400: CLOSE c_efc_table;
1401: END IF;
1402:

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

1402:
1403: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
1404: p_data => p_msg_data );
1405: IF (g_excep_level >= g_debug_level ) THEN
1406: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_UNEXPECTED_ERROR Exception Raised');
1407: END IF;
1408: RETURN;
1409:
1410: WHEN OTHERS THEN

Line 1413: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1409:
1410: WHEN OTHERS THEN
1411:
1412: ROLLBACK TO Validate_Check_EFC_Enabled_Pub;
1413: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1414: p_efc_enabled := FND_API.G_FALSE;
1415: IF (c_efc_table%ISOPEN) THEN
1416: CLOSE c_efc_table;
1417: END IF;

Line 1414: p_efc_enabled := FND_API.G_FALSE;

1410: WHEN OTHERS THEN
1411:
1412: ROLLBACK TO Validate_Check_EFC_Enabled_Pub;
1413: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1414: p_efc_enabled := FND_API.G_FALSE;
1415: IF (c_efc_table%ISOPEN) THEN
1416: CLOSE c_efc_table;
1417: END IF;
1418:

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

1474: +=======================================================================*/
1475: PROCEDURE Validate_CC_Interface
1476: (
1477: p_api_version IN NUMBER,
1478: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1479: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1480: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1481: p_return_status OUT NOCOPY VARCHAR2,
1482: p_msg_count OUT NOCOPY NUMBER,

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

1475: PROCEDURE Validate_CC_Interface
1476: (
1477: p_api_version IN NUMBER,
1478: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1479: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1480: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1481: p_return_status OUT NOCOPY VARCHAR2,
1482: p_msg_count OUT NOCOPY NUMBER,
1483: p_msg_data OUT NOCOPY VARCHAR2,

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

1476: (
1477: p_api_version IN NUMBER,
1478: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1479: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1480: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1481: p_return_status OUT NOCOPY VARCHAR2,
1482: p_msg_count OUT NOCOPY NUMBER,
1483: p_msg_data OUT NOCOPY VARCHAR2,
1484:

Line 1591: IF NOT FND_API.Compatible_API_Call ( l_api_version,

1587: l_full_path := g_path || 'Validate_CC_Interface';
1588:
1589: SAVEPOINT Validate_CC_Interface_Pub;
1590:
1591: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1592: p_api_version,
1593: l_api_name,
1594: G_PKG_NAME )
1595: THEN

Line 1596: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1592: p_api_version,
1593: l_api_name,
1594: G_PKG_NAME )
1595: THEN
1596: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1597: END IF;
1598:
1599: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
1600: FND_MSG_PUB.initialize ;

Line 1599: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

1595: THEN
1596: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1597: END IF;
1598:
1599: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
1600: FND_MSG_PUB.initialize ;
1601: END IF;
1602:
1603: -- -------------------------------------------------------------------------

Line 1606: p_return_status := FND_API.G_RET_STS_SUCCESS ;

1602:
1603: -- -------------------------------------------------------------------------
1604: -- Initialize variables here.
1605: -- -------------------------------------------------------------------------
1606: p_return_status := FND_API.G_RET_STS_SUCCESS ;
1607: p_cbc_flag := FND_API.G_TRUE;
1608: p_sbc_flag := FND_API.G_TRUE;
1609:
1610:

Line 1607: p_cbc_flag := FND_API.G_TRUE;

1603: -- -------------------------------------------------------------------------
1604: -- Initialize variables here.
1605: -- -------------------------------------------------------------------------
1606: p_return_status := FND_API.G_RET_STS_SUCCESS ;
1607: p_cbc_flag := FND_API.G_TRUE;
1608: p_sbc_flag := FND_API.G_TRUE;
1609:
1610:
1611: -- ssmales 29/01/02 bug 2201905 - added if block below

Line 1608: p_sbc_flag := FND_API.G_TRUE;

1604: -- Initialize variables here.
1605: -- -------------------------------------------------------------------------
1606: p_return_status := FND_API.G_RET_STS_SUCCESS ;
1607: p_cbc_flag := FND_API.G_TRUE;
1608: p_sbc_flag := FND_API.G_TRUE;
1609:
1610:
1611: -- ssmales 29/01/02 bug 2201905 - added if block below
1612: -- bug 2201905 start block

Line 1641: p_cbc_flag := FND_API.G_FALSE;

1637: -- ssmales 29/01/02 bug 2201905 - added end if statement below
1638: -- END IF ;
1639:
1640: IF (l_cbc_count = 0) THEN
1641: p_cbc_flag := FND_API.G_FALSE;
1642: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
1643: IF g_debug_mode = 'Y' THEN
1644: Put_Debug_Msg (l_full_path, ' No CBC Records in CC Interface ');
1645: END IF;

Line 1650: IF FND_API.TO_BOOLEAN(p_cbc_flag) AND (NOT FND_API.TO_BOOLEAN(p_cbc_enabled)) THEN

1646: END IF;
1647:
1648: Put_Debug_Msg (l_full_path, 'CBC flag: ' || p_cbc_flag || ' CBC Enabled: ' || p_cbc_enabled);
1649:
1650: IF FND_API.TO_BOOLEAN(p_cbc_flag) AND (NOT FND_API.TO_BOOLEAN(p_cbc_enabled)) THEN
1651: message_token ('SOB_ID', p_sob_id);
1652: add_message ('IGC', 'IGC_BC_NOT_ENABLED'); -- BC is disabled, no encumbrances allowed
1653: raise FND_API.G_EXC_ERROR;
1654: END IF;

Line 1653: raise FND_API.G_EXC_ERROR;

1649:
1650: IF FND_API.TO_BOOLEAN(p_cbc_flag) AND (NOT FND_API.TO_BOOLEAN(p_cbc_enabled)) THEN
1651: message_token ('SOB_ID', p_sob_id);
1652: add_message ('IGC', 'IGC_BC_NOT_ENABLED'); -- BC is disabled, no encumbrances allowed
1653: raise FND_API.G_EXC_ERROR;
1654: END IF;
1655:
1656: -- ssmales 29/01/02 bug 2201905 - added if block below
1657: -- bug 2201905 start block

Line 1684: p_sbc_flag := FND_API.G_FALSE;

1680: -- ssmales 29/01/02 bug 2201905 - added end if statement below
1681: -- END IF ;
1682:
1683: IF (l_sbc_count = 0) THEN
1684: p_sbc_flag := FND_API.G_FALSE;
1685: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
1686: IF g_debug_mode = 'Y' THEN
1687: Put_Debug_Msg (l_full_path, ' No SBC Records in CC Interface ');
1688: END IF;

Line 1694: IF ((NOT FND_API.TO_BOOLEAN(p_sbc_flag)) AND

1690:
1691:
1692: /* Changed per change request. No rows - no erorr thrown
1693:
1694: IF ((NOT FND_API.TO_BOOLEAN(p_sbc_flag)) AND
1695: (NOT FND_API.TO_BOOLEAN(p_cbc_flag))) THEN
1696: message_token ('CC_HEADER_ID', to_char(p_cc_head_id));
1697: message_token ('ACTUAL_FLAG', p_actl_flag);
1698: add_message ('IGC', 'IGC_VALIDATE_NO_ROWS'); --No rows in the interface table to check

Line 1695: (NOT FND_API.TO_BOOLEAN(p_cbc_flag))) THEN

1691:
1692: /* Changed per change request. No rows - no erorr thrown
1693:
1694: IF ((NOT FND_API.TO_BOOLEAN(p_sbc_flag)) AND
1695: (NOT FND_API.TO_BOOLEAN(p_cbc_flag))) THEN
1696: message_token ('CC_HEADER_ID', to_char(p_cc_head_id));
1697: message_token ('ACTUAL_FLAG', p_actl_flag);
1698: add_message ('IGC', 'IGC_VALIDATE_NO_ROWS'); --No rows in the interface table to check
1699: raise FND_API.G_EXC_ERROR;

Line 1699: raise FND_API.G_EXC_ERROR;

1695: (NOT FND_API.TO_BOOLEAN(p_cbc_flag))) THEN
1696: message_token ('CC_HEADER_ID', to_char(p_cc_head_id));
1697: message_token ('ACTUAL_FLAG', p_actl_flag);
1698: add_message ('IGC', 'IGC_VALIDATE_NO_ROWS'); --No rows in the interface table to check
1699: raise FND_API.G_EXC_ERROR;
1700: END IF;
1701: */
1702:
1703: /*

Line 1717: raise FND_API.G_EXC_ERROR;

1713: IF (NVL(l_sob_count,0) > 1) THEN
1714: message_token ('CC_HEADER_ID', to_char(p_cc_head_id));
1715: message_token ('ACTUAL_FLAG', p_actl_flag);
1716: add_message ('IGC', 'IGC_VALIDATE_SOB'); --Not one set of books in the batch
1717: raise FND_API.G_EXC_ERROR;
1718: END IF;
1719: */
1720:
1721:

Line 1752: raise FND_API.G_EXC_ERROR;

1748: IF (l_enc_count <> 0) THEN
1749: message_token ('CC_HEADER_ID', to_char(p_cc_head_id));
1750: message_token ('ACTUAL_FLAG', 'E');
1751: add_message ('IGC', 'IGC_VALIDATE_ENC_CODE'); -- Records without encumbrance type id
1752: raise FND_API.G_EXC_ERROR;
1753: END IF;
1754: */
1755: IF FND_API.To_Boolean ( p_commit ) THEN
1756: COMMIT WORK;

Line 1755: IF FND_API.To_Boolean ( p_commit ) THEN

1751: add_message ('IGC', 'IGC_VALIDATE_ENC_CODE'); -- Records without encumbrance type id
1752: raise FND_API.G_EXC_ERROR;
1753: END IF;
1754: */
1755: IF FND_API.To_Boolean ( p_commit ) THEN
1756: COMMIT WORK;
1757: END IF;
1758:
1759: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 1769: WHEN FND_API.G_EXC_ERROR THEN

1765: -- Exception handler section for the Validate_Get_CCID_Period_Name procedure.
1766: -- -------------------------------------------------------------------------
1767: EXCEPTION
1768:
1769: WHEN FND_API.G_EXC_ERROR THEN
1770:
1771: ROLLBACK TO Validate_CC_Interface_Pub;
1772: p_return_status := FND_API.G_RET_STS_ERROR;
1773: IF (c_cbc_count%ISOPEN) THEN

Line 1772: p_return_status := FND_API.G_RET_STS_ERROR;

1768:
1769: WHEN FND_API.G_EXC_ERROR THEN
1770:
1771: ROLLBACK TO Validate_CC_Interface_Pub;
1772: p_return_status := FND_API.G_RET_STS_ERROR;
1773: IF (c_cbc_count%ISOPEN) THEN
1774: CLOSE c_cbc_count;
1775: END IF;
1776: IF (c_sbc_count%ISOPEN) THEN

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

1800: -- bug 2201905 end block
1801: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
1802: p_data => p_msg_data );
1803: IF (g_excep_level >= g_debug_level ) THEN
1804: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_ERROR Exception Raised');
1805: END IF;
1806:
1807: RETURN;
1808:

Line 1809: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1805: END IF;
1806:
1807: RETURN;
1808:
1809: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1810:
1811: ROLLBACK TO Validate_CC_Interface_Pub;
1812: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1813: IF (c_cbc_count%ISOPEN) THEN

Line 1812: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1808:
1809: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1810:
1811: ROLLBACK TO Validate_CC_Interface_Pub;
1812: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1813: IF (c_cbc_count%ISOPEN) THEN
1814: CLOSE c_cbc_count;
1815: END IF;
1816: IF (c_sbc_count%ISOPEN) THEN

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

1835: -- bug 2201905 end block
1836: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
1837: p_data => p_msg_data );
1838: IF (g_excep_level >= g_debug_level ) THEN
1839: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_UNEXPECTED_ERROR Exception Raised');
1840: END IF;
1841:
1842: RETURN;
1843:

Line 1847: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1843:
1844: WHEN OTHERS THEN
1845:
1846: ROLLBACK TO Validate_CC_Interface_Pub;
1847: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1848: IF (c_cbc_count%ISOPEN) THEN
1849: CLOSE c_cbc_count;
1850: END IF;
1851: IF (c_sbc_count%ISOPEN) THEN