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.CSD_COST_ANALYSIS_PVT dependencies on CSD_COST_ANALYSIS_PVT

Line 1: PACKAGE BODY CSD_COST_ANALYSIS_PVT AS

1: PACKAGE BODY CSD_COST_ANALYSIS_PVT AS
2: /* $Header: csdvanab.pls 120.1 2005/06/06 16:14:40 appldev $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSD_COST_ANALYSIS_PVT';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csdvanab.pls';

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSD_COST_ANALYSIS_PVT';

1: PACKAGE BODY CSD_COST_ANALYSIS_PVT AS
2: /* $Header: csdvanab.pls 120.1 2005/06/06 16:14:40 appldev $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSD_COST_ANALYSIS_PVT';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csdvanab.pls';
6:
7:
8: -- Global variable for storing the debug level

Line 104: l_mod_name varchar2(2000) := 'csd.plsql.csd_cost_analysis_pvt.get_totalestcosts';

100: l_event_level number := FND_LOG.LEVEL_EVENT;
101: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
102: l_error_level number := FND_LOG.LEVEL_ERROR;
103: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
104: l_mod_name varchar2(2000) := 'csd.plsql.csd_cost_analysis_pvt.get_totalestcosts';
105:
106: BEGIN
107:
108: -- Standard Start of API savepoint

Line 141: 'csd.plsql.csd_cost_analysis_pvt.get_totalestcosts.BEGIN',

137:
138: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
139: THEN
140: FND_LOG.STRING(Fnd_Log.Level_Procedure,
141: 'csd.plsql.csd_cost_analysis_pvt.get_totalestcosts.BEGIN',
142: 'Entered Get_TotalEstCosts');
143: END IF;
144:
145: -- IF not costing enabled then throw exception

Line 238: 'csd.plsql.csd_cost_analysis_pvt.get_totalestcosts.END',

234:
235: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
236: THEN
237: FND_LOG.STRING(Fnd_Log.Level_Procedure,
238: 'csd.plsql.csd_cost_analysis_pvt.get_totalestcosts.END',
239: 'Leaving Get_TotalEstCosts');
240: END IF;
241:
242: --

Line 268: 'csd.plsql.csd_cost_analysis_pvt.Get_TotalEstCosts',

264: p_encoded => 'F');
265: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
266: THEN
267: FND_LOG.STRING(Fnd_Log.Level_Exception,
268: 'csd.plsql.csd_cost_analysis_pvt.Get_TotalEstCosts',
269: 'EXC_ERROR['
270: || x_msg_data
271: || ']');
272: END IF;

Line 284: 'csd.plsql.csd_cost_analysis_pvt.Get_TotalEstCosts',

280: p_encoded => 'F');
281: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
282: THEN
283: FND_LOG.STRING(Fnd_Log.Level_Exception,
284: 'csd.plsql.csd_cost_analysis_pvt.Get_TotalEstCosts',
285: 'EXC_ERROR['
286: || x_msg_data
287: || ']');
288: END IF;

Line 304: 'csd.plsql.csd_cost_analysis_pvt.Get_TotalEstCosts',

300: p_encoded => 'F');
301: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
302: THEN
303: FND_LOG.STRING(Fnd_Log.Level_Exception,
304: 'csd.plsql.csd_cost_analysis_pvt.Get_TotalEstCosts',
305: 'SQL Message['
306: || sqlerrm
307: || ']');
308: END IF;

Line 386: l_mod_name varchar2(2000) := 'csd.plsql.csd_cost_analysis_pvt.get_totalestcharges';

382: l_event_level number := FND_LOG.LEVEL_EVENT;
383: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
384: l_error_level number := FND_LOG.LEVEL_ERROR;
385: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
386: l_mod_name varchar2(2000) := 'csd.plsql.csd_cost_analysis_pvt.get_totalestcharges';
387:
388: BEGIN
389:
390: -- Standard Start of API savepoint

Line 422: 'csd.plsql.csd_cost_analysis_pvt.get_totalestcosts.BEGIN',

418:
419: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
420: THEN
421: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
422: 'csd.plsql.csd_cost_analysis_pvt.get_totalestcosts.BEGIN',
423: 'Entered Get_TotalEstCharges');
424: END IF;
425:
426: -- No need to check if costing enabled because these are charges.

Line 479: 'csd.plsql.csd_cost_analysis_pvt.get_totalestcharges.END',

475:
476: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
477: THEN
478: FND_LOG.STRING(Fnd_Log.Level_Procedure,
479: 'csd.plsql.csd_cost_analysis_pvt.get_totalestcharges.END',
480: ' Exiting Get_TotalEstCharges');
481: END IF;
482:
483: --

Line 509: 'csd.plsql.csd_cost_analysis_pvt.Get_TotalEstCharges',

505: p_encoded => 'F');
506: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
507: THEN
508: FND_LOG.STRING(Fnd_Log.Level_Exception,
509: 'csd.plsql.csd_cost_analysis_pvt.Get_TotalEstCharges',
510: 'EXC_ERROR['
511: || x_msg_data
512: || ']');
513: END IF;

Line 525: 'csd.plsql.csd_cost_analysis_pvt.Get_TotalEstCharges',

521: p_encoded => 'F');
522: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
523: THEN
524: FND_LOG.STRING(Fnd_Log.Level_Exception,
525: 'csd.plsql.csd_cost_analysis_pvt.Get_TotalEstCharges',
526: 'EXC_ERROR['
527: || x_msg_data
528: || ']');
529: END IF;

Line 545: 'csd.plsql.csd_cost_analysis_pvt.Get_TotalEstCharges',

541: p_encoded => 'F');
542: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
543: THEN
544: FND_LOG.STRING(Fnd_Log.Level_Exception,
545: 'csd.plsql.csd_cost_analysis_pvt.Get_TotalEstCharges',
546: 'SQL Message['
547: || sqlerrm
548: || ']');
549: END IF;

Line 619: l_mod_name varchar2(2000) := 'csd.plsql.csd_cost_analysis_pvt.Compare_EstChargesAndCosts';

615: l_event_level number := FND_LOG.LEVEL_EVENT;
616: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
617: l_error_level number := FND_LOG.LEVEL_ERROR;
618: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
619: l_mod_name varchar2(2000) := 'csd.plsql.csd_cost_analysis_pvt.Compare_EstChargesAndCosts';
620:
621: BEGIN
622:
623: -- Standard Start of API savepoint to the database

Line 742: 'csd.plsql.csd_cost_analysis_pvt.Compare_EstChargesAndCosts.END',

738: END IF;
739: IF (FND_LOG.LEVEL_PROCEDURE >= Fnd_Log.G_Current_Runtime_Level)
740: THEN
741: FND_LOG.STRING(Fnd_Log.Level_Procedure,
742: 'csd.plsql.csd_cost_analysis_pvt.Compare_EstChargesAndCosts.END',
743: 'Exiting Compare_EstChargesAndCosts');
744: END IF;
745:
746: --

Line 772: 'csd.plsql.csd_cost_analysis_pvt.Compare_EstChargesAndCosts',

768: p_encoded => 'F');
769: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
770: THEN
771: FND_LOG.STRING(Fnd_Log.Level_Exception,
772: 'csd.plsql.csd_cost_analysis_pvt.Compare_EstChargesAndCosts',
773: 'EXC_ERROR['
774: || x_msg_data
775: || ']');
776: END IF;

Line 788: 'csd.plsql.csd_cost_analysis_pvt.Compare_EstChargesAndCosts',

784: p_encoded => 'F');
785: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
786: THEN
787: FND_LOG.STRING(Fnd_Log.Level_Exception,
788: 'csd.plsql.csd_cost_analysis_pvt.Compare_EstChargesAndCosts',
789: 'EXC_ERROR['
790: || x_msg_data
791: || ']');
792: END IF;

Line 808: 'csd.plsql.csd_cost_analysis_pvt. Compare_EstChargesAndCosts',

804: p_encoded => 'F');
805: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
806: THEN
807: FND_LOG.STRING(Fnd_Log.Level_Exception,
808: 'csd.plsql.csd_cost_analysis_pvt. Compare_EstChargesAndCosts',
809: 'SQL Message['
810: || sqlerrm
811: || ']');
812: END IF;

Line 906: l_mod_name varchar2(2000) := 'csd.plsql.csd_cost_analysis_pvt.Get_InvItemCost';

902: l_event_level number := FND_LOG.LEVEL_EVENT;
903: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
904: l_error_level number := FND_LOG.LEVEL_ERROR;
905: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
906: l_mod_name varchar2(2000) := 'csd.plsql.csd_cost_analysis_pvt.Get_InvItemCost';
907:
908: BEGIN
909:
910: -- Standard Start of API savepoint

Line 942: 'csd.plsql.csd_cost_analysis_pvt.Get_InvItemCost.BEGIN',

938:
939: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
940: THEN
941: FND_LOG.STRING(Fnd_Log.Level_Procedure,
942: 'csd.plsql.csd_cost_analysis_pvt.Get_InvItemCost.BEGIN',
943: 'Entering Get_InvItemCost');
944: END IF;
945:
946: --Check if costing enabled

Line 1037: 'csd.plsql.csd_cost_analysis_pvt.Get_InvItemCost.END',

1033: END IF;
1034: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
1035: THEN
1036: FND_LOG.STRING(Fnd_Log.Level_Procedure,
1037: 'csd.plsql.csd_cost_analysis_pvt.Get_InvItemCost.END',
1038: 'Exiting Get_InvItemCost');
1039: END IF;
1040:
1041: --

Line 1066: 'csd.plsql.csd_cost_analysis_pvt.Get_InvItemCost',

1062: p_encoded => 'F');
1063: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
1064: THEN
1065: FND_LOG.STRING(Fnd_Log.Level_Exception,
1066: 'csd.plsql.csd_cost_analysis_pvt.Get_InvItemCost',
1067: 'EXC_ERROR['
1068: || x_msg_data
1069: || ']');
1070: END IF;

Line 1081: 'csd.plsql.csd_cost_analysis_pvt.Get_InvItemCost',

1077: p_encoded => 'F');
1078: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
1079: THEN
1080: FND_LOG.STRING(Fnd_Log.Level_Exception,
1081: 'csd.plsql.csd_cost_analysis_pvt.Get_InvItemCost',
1082: 'EXC_ERROR['
1083: || x_msg_data
1084: || ']');
1085: END IF;

Line 1100: 'csd.plsql.csd_cost_analysis_pvt.Get_InvItemCost',

1096: p_encoded => 'F');
1097: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
1098: THEN
1099: FND_LOG.STRING(Fnd_Log.Level_Exception,
1100: 'csd.plsql.csd_cost_analysis_pvt.Get_InvItemCost',
1101: 'SQL Message['
1102: || sqlerrm
1103: || ']');
1104: END IF;

Line 1205: l_mod_name varchar2(2000) := 'csd.plsql.csd_cost_analysis_pvt.Get_InvItemCost';

1201: l_event_level number := FND_LOG.LEVEL_EVENT;
1202: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
1203: l_error_level number := FND_LOG.LEVEL_ERROR;
1204: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
1205: l_mod_name varchar2(2000) := 'csd.plsql.csd_cost_analysis_pvt.Get_InvItemCost';
1206:
1207: BEGIN
1208: -- Initialize API return status to success
1209:

Line 1219: 'csd.plsql.csd_cost_analysis_pvt.Get_ResItemCost.BEGIN',

1215:
1216: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
1217: THEN
1218: FND_LOG.STRING(Fnd_Log.Level_Procedure,
1219: 'csd.plsql.csd_cost_analysis_pvt.Get_ResItemCost.BEGIN',
1220: 'Entering Get_ResItemCost');
1221: END IF;
1222:
1223: --Check if costing enabled

Line 1233: 'csd.plsql.csd_cost_analysis_pvt.Get_ResItemCost',

1229: If p_bom_resource_id is not null THEN
1230: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)
1231: THEN
1232: FND_LOG.STRING(Fnd_Log.Level_Statement,
1233: 'csd.plsql.csd_cost_analysis_pvt.Get_ResItemCost',
1234: 'Resource id :'|| p_bom_resource_id);
1235: END IF;
1236:
1237: -- Check if the resource UOM is different from Charge line UOM.

Line 1273: 'csd.plsql.csd_cost_analysis_pvt.Get_ResItemCost',

1269: IF ( p_bom_resource_id is null OR l_item_cost is null ) then
1270: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)
1271: THEN
1272: FND_LOG.STRING(Fnd_Log.Level_Statement,
1273: 'csd.plsql.csd_cost_analysis_pvt.Get_ResItemCost',
1274: 'No resource information. Deriving Labor item cost');
1275: END IF;
1276: OPEN cur_getItemCost(p_inventory_item_id, p_organization_id);
1277: FETCH cur_getItemCost INTO l_item_cost;

Line 1328: 'csd.plsql.csd_cost_analysis_pvt.Get_ResItemCost.END',

1324: END IF;
1325: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
1326: THEN
1327: FND_LOG.STRING(Fnd_Log.Level_Procedure,
1328: 'csd.plsql.csd_cost_analysis_pvt.Get_ResItemCost.END',
1329: 'Exiting Get_InvItemCost');
1330: END IF;
1331:
1332: --

Line 1349: 'csd.plsql.csd_cost_analysis_pvt.Get_ResItemCost',

1345: p_encoded => 'F');
1346: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
1347: THEN
1348: FND_LOG.STRING(Fnd_Log.Level_Exception,
1349: 'csd.plsql.csd_cost_analysis_pvt.Get_ResItemCost',
1350: 'EXC_ERROR['
1351: || x_msg_data
1352: || ']');
1353: END IF;

Line 1364: 'csd.plsql.csd_cost_analysis_pvt.Get_ResItemCost',

1360: p_encoded => 'F');
1361: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
1362: THEN
1363: FND_LOG.STRING(Fnd_Log.Level_Exception,
1364: 'csd.plsql.csd_cost_analysis_pvt.Get_ResItemCost',
1365: 'EXC_ERROR['
1366: || x_msg_data
1367: || ']');
1368: END IF;

Line 1382: 'csd.plsql.csd_cost_analysis_pvt.Get_ResItemCost',

1378: p_encoded => 'F');
1379: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
1380: THEN
1381: FND_LOG.STRING(Fnd_Log.Level_Exception,
1382: 'csd.plsql.csd_cost_analysis_pvt.Get_ResItemCost',
1383: 'SQL Message['
1384: || sqlerrm
1385: || ']');
1386: END IF;

Line 1390: END CSD_COST_ANALYSIS_PVT;

1386: END IF;
1387: END get_ResItemCost;
1388:
1389:
1390: END CSD_COST_ANALYSIS_PVT;