DBA Data[Home] [Help]

APPS.IGI_IAC_PROJ_PKG dependencies on IGI_IAC_PROJ_PKG

Line 1: PACKAGE BODY IGI_IAC_PROJ_PKG AS

1: PACKAGE BODY IGI_IAC_PROJ_PKG AS
2: -- $Header: igiiacpb.pls 120.25 2007/08/01 10:47:04 npandya ship $
3:
4: --===========================FND_LOG.START=====================================
5:

Line 12: g_path VARCHAR2(100) := 'IGI.PLSQL.igiiacpb.IGI_IAC_PROJ_PKG.';

8: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
9: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
10: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;
11: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;
12: g_path VARCHAR2(100) := 'IGI.PLSQL.igiiacpb.IGI_IAC_PROJ_PKG.';
13:
14: --===========================FND_LOG.END=====================================
15:
16: -- ===================================================================

Line 1367: FND_MESSAGE.SET_TOKEN('PACKAGE','igi_iac_proj_pkg');

1363: ELSE
1364: RAISE NO_ASSETS_TO_PROJECT;
1365: END IF;
1366: FND_MESSAGE.SET_NAME('IGI', 'IGI_IAC_EXCEPTION');
1367: FND_MESSAGE.SET_TOKEN('PACKAGE','igi_iac_proj_pkg');
1368: FND_MESSAGE.SET_TOKEN('ERROR_MESSAGE','Projections completed successfully');
1369:
1370: igi_iac_debug_pkg.debug_other_msg(g_event_level,g_path||'Do_Proj_Calc',TRUE);
1371: errbuf := fnd_message.get;

Line 1379: FND_MESSAGE.SET_TOKEN('PACKAGE','igi_iac_proj_pkg');

1375: WHEN NO_PROJ_MAIN_DATA then
1376: Update_Status(p_projection_id, 'ERROR');
1377: igi_iac_debug_pkg.debug_other_string(g_error_level,g_path||'Do_Proj_Calc' ,'Projection submission information could not be found ');
1378: FND_MESSAGE.SET_NAME('IGI', 'IGI_IAC_EXCEPTION');
1379: FND_MESSAGE.SET_TOKEN('PACKAGE','igi_iac_proj_pkg');
1380: FND_MESSAGE.SET_TOKEN('ERROR_MESSAGE','Projection submission information could not be found ');
1381:
1382: igi_iac_debug_pkg.debug_other_msg(g_error_level,g_path||'Do_Proj_Calc',FALSE);
1383: errbuf := fnd_message.get;

Line 1389: FND_MESSAGE.SET_TOKEN('PACKAGE','igi_iac_proj_pkg');

1385: WHEN NO_DATA_FOUND then
1386: Update_Status(p_projection_id, 'ERROR');
1387: igi_iac_debug_pkg.debug_other_string(g_error_level,g_path||'Do_Proj_Calc' ,'No data found '||sqlerrm);
1388: FND_MESSAGE.SET_NAME('IGI', 'IGI_IAC_EXCEPTION');
1389: FND_MESSAGE.SET_TOKEN('PACKAGE','igi_iac_proj_pkg');
1390: FND_MESSAGE.SET_TOKEN('ERROR_MESSAGE','No data found '||sqlerrm);
1391:
1392: igi_iac_debug_pkg.debug_other_msg(g_error_level,g_path||'Do_Proj_Calc',FALSE);
1393: errbuf := fnd_message.get;

Line 1399: FND_MESSAGE.SET_TOKEN('PACKAGE','igi_iac_proj_pkg');

1395: WHEN NO_ASSETS_FOUND then
1396: Update_Status(p_projection_id, 'ERROR');
1397: igi_iac_debug_pkg.debug_other_string(g_error_level,g_path||'Do_Proj_Calc' ,'No assets are present for this book and category . Hence projections is not run ');
1398: FND_MESSAGE.SET_NAME('IGI', 'IGI_IAC_EXCEPTION');
1399: FND_MESSAGE.SET_TOKEN('PACKAGE','igi_iac_proj_pkg');
1400: FND_MESSAGE.SET_TOKEN('ERROR_MESSAGE','No assets are present for this book and category . Hence projections is not run ');
1401:
1402: igi_iac_debug_pkg.debug_other_msg(g_error_level,g_path||'Do_Proj_Calc',FALSE);
1403: errbuf := fnd_message.get;

Line 1409: FND_MESSAGE.SET_TOKEN('PACKAGE','igi_iac_proj_pkg');

1405: WHEN NO_INDEX_FOUND then
1406: Update_Status(p_projection_id, 'ERROR');
1407: igi_iac_debug_pkg.debug_other_string(g_error_level,g_path||'Do_Proj_Calc' ,'No Price index value found for this calendar and price index ');
1408: FND_MESSAGE.SET_NAME('IGI', 'IGI_IAC_EXCEPTION');
1409: FND_MESSAGE.SET_TOKEN('PACKAGE','igi_iac_proj_pkg');
1410: FND_MESSAGE.SET_TOKEN('ERROR_MESSAGE','No Price index value found for this calendar and price index ');
1411:
1412: igi_iac_debug_pkg.debug_other_msg(g_error_level,g_path||'Do_Proj_Calc',FALSE);
1413: errbuf := fnd_message.get;

Line 1418: FND_MESSAGE.SET_TOKEN('PACKAGE','igi_iac_proj_pkg');

1414: retcode := 2;
1415: WHEN NO_ASSETS_TO_PROJECT then
1416: igi_iac_debug_pkg.debug_other_string(g_error_level,g_path||'Do_Proj_Calc' ,'No assets have been selected for Projections. Hence, report not submitted');
1417: FND_MESSAGE.SET_NAME('IGI', 'IGI_IAC_EXCEPTION');
1418: FND_MESSAGE.SET_TOKEN('PACKAGE','igi_iac_proj_pkg');
1419: FND_MESSAGE.SET_TOKEN('ERROR_MESSAGE','No assets have been selected for Projections. Hence, report not submitted');
1420:
1421: igi_iac_debug_pkg.debug_other_msg(g_error_level,g_path||'Do_Proj_Calc',FALSE);
1422: errbuf := fnd_message.get;

Line 1428: FND_MESSAGE.SET_TOKEN('PACKAGE','igi_iac_proj_pkg');

1424: WHEN OTHERS THEN
1425: Update_Status(p_projection_id, 'ERROR');
1426: igi_iac_debug_pkg.debug_other_string(g_unexp_level,g_path||'Do_Proj_Calc' ,sqlerrm);
1427: FND_MESSAGE.SET_NAME('IGI', 'IGI_IAC_EXCEPTION');
1428: FND_MESSAGE.SET_TOKEN('PACKAGE','igi_iac_proj_pkg');
1429: FND_MESSAGE.SET_TOKEN('ERROR_MESSAGE',sqlerrm);
1430:
1431: igi_iac_debug_pkg.debug_other_msg(g_error_level,g_path||'Do_Proj_Calc',FALSE);
1432: errbuf := fnd_message.get;

Line 1456: END igi_iac_proj_pkg; -- Package body

1452:
1453: END Delete_Projections;
1454:
1455:
1456: END igi_iac_proj_pkg; -- Package body
1457: