DBA Data[Home] [Help]

APPS.IGC_CBC_VALIDATIONS_PKG dependencies on FND_MSG_PUB

Line 155: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

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
156: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
157: END IF;
158: NULL;
159: RETURN;

Line 156: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);

152: RETURN;*/
153:
154: WHEN OTHERS THEN
155: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
156: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
157: END IF;
158: NULL;
159: RETURN;
160:

Line 270: FND_MSG_PUB.initialize ;

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: -- --------------------------------------------------------------------
274: -- Initialize Return status

Line 369: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

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,
370: p_data => p_msg_data );
371:
372: RETURN;
373:

Line 387: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

383: p_result_code := NULL;
384: IF (c_validate_ccid_values%ISOPEN) THEN
385: CLOSE c_validate_ccid_values;
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;

Line 402: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

398: p_result_code := NULL;
399: IF (c_validate_ccid_values%ISOPEN) THEN
400: CLOSE c_validate_ccid_values;
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;

Line 417: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

413: p_result_code := NULL;
414: IF (c_validate_ccid_values%ISOPEN) THEN
415: CLOSE c_validate_ccid_values;
416: END IF;
417: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
418: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
419: l_api_name);
420: END IF;
421:

Line 418: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

414: IF (c_validate_ccid_values%ISOPEN) THEN
415: CLOSE c_validate_ccid_values;
416: END IF;
417: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
418: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
419: l_api_name);
420: END IF;
421:
422: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 422: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

418: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
419: l_api_name);
420: END IF;
421:
422: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
423: p_data => p_msg_data );
424: IF ( g_unexp_level >= g_debug_level ) THEN
425: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
426: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

Line 649: FND_MSG_PUB.initialize ;

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: -- -------------------------------------------------------------------
653: -- Initialize return status to Success.

Line 887: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

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,
888: p_data => p_msg_data );
889:
890: RETURN;
891:

Line 901: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

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');
905: END IF;

Line 911: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

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');
915: END IF;

Line 922: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) 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);
925: END IF;
926:

Line 923: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

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);
925: END IF;
926:
927: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 927: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

923: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
924: l_api_name);
925: END IF;
926:
927: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
928: p_data => p_msg_data );
929: IF ( g_unexp_level >= g_debug_level ) THEN
930: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
931: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

Line 1064: FND_MSG_PUB.initialize ;

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: -- -------------------------------------------------------------------------
1068: -- Initialize variables here.

Line 1151: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

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,
1152: p_data => p_msg_data );
1153:
1154: RETURN;
1155:

Line 1172: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

1168: IF (c_igc_legacy_period_info%ISOPEN) THEN
1169: CLOSE c_igc_legacy_period_info;
1170: END IF;
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;

Line 1190: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

1186: IF (c_igc_legacy_period_info%ISOPEN) THEN
1187: CLOSE c_igc_legacy_period_info;
1188: END IF;
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;

Line 1208: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1204: IF (c_igc_legacy_period_info%ISOPEN) THEN
1205: CLOSE c_igc_legacy_period_info;
1206: END IF;
1207:
1208: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1209: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
1210: l_api_name);
1211: END IF;
1212:

Line 1209: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

1205: CLOSE c_igc_legacy_period_info;
1206: END IF;
1207:
1208: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1209: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
1210: l_api_name);
1211: END IF;
1212:
1213: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 1213: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

1209: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
1210: l_api_name);
1211: END IF;
1212:
1213: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
1214: p_data => p_msg_data );
1215:
1216: IF ( g_unexp_level >= g_debug_level ) THEN
1217: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');

Line 1310: FND_MSG_PUB.initialize ;

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: -- --------------------------------------------------------------------
1314: -- Initialize variables here.

Line 1368: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

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,
1369: p_data => p_msg_data );
1370:
1371: RETURN;
1372:

Line 1387: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

1383: IF (c_efc_table%ISOPEN) THEN
1384: CLOSE c_efc_table;
1385: END IF;
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;

Line 1403: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

1399: IF (c_efc_table%ISOPEN) THEN
1400: CLOSE c_efc_table;
1401: END IF;
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;

Line 1419: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1415: IF (c_efc_table%ISOPEN) THEN
1416: CLOSE c_efc_table;
1417: END IF;
1418:
1419: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1420: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
1421: l_api_name);
1422: END IF;
1423:

Line 1420: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

1416: CLOSE c_efc_table;
1417: END IF;
1418:
1419: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1420: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
1421: l_api_name);
1422: END IF;
1423:
1424: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 1424: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

1420: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
1421: l_api_name);
1422: END IF;
1423:
1424: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
1425: p_data => p_msg_data );
1426: IF ( g_unexp_level >= g_debug_level ) THEN
1427: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
1428: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

Line 1600: FND_MSG_PUB.initialize ;

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: -- -------------------------------------------------------------------------
1604: -- Initialize variables here.

Line 1759: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

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,
1760: p_data => p_msg_data );
1761:
1762: RETURN;
1763:

Line 1801: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

1797: CLOSE c_enc_count_packet;
1798: END IF;
1799: */
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;

Line 1836: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

1832: CLOSE c_enc_count_packet;
1833: END IF;
1834: */
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;

Line 1871: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1867: CLOSE c_enc_count_packet;
1868: END IF;
1869: */
1870: -- bug 2201905 end block
1871: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1872: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
1873: l_api_name);
1874: END IF;
1875:

Line 1872: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

1868: END IF;
1869: */
1870: -- bug 2201905 end block
1871: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1872: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
1873: l_api_name);
1874: END IF;
1875:
1876: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 1876: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

1872: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
1873: l_api_name);
1874: END IF;
1875:
1876: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
1877: p_data => p_msg_data );
1878: IF ( g_unexp_level >= g_debug_level ) THEN
1879: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
1880: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);