DBA Data[Home] [Help]

APPS.AHL_VWP_COST_PVT dependencies on CST_EAMCOST_PUB

Line 31: -- 24-SEP-2003 SHBHANDA Made call for CST_eamCost_PUB.Compute_Job_Estimate API

27: -- Insert_Cst_Wo_Hierarchy -- Srini
28: -- Create_Wo_Cost_Structure -- Srini
29: -- Create_Wo_Dependencies -- ShivaK
30: --
31: -- 24-SEP-2003 SHBHANDA Made call for CST_eamCost_PUB.Compute_Job_Estimate API
32: -- in Rollup_MR_Cost_Hierarchy API
33: --
34: -- 08-OCT-2003 SHBHANDA Made call for CST_eamCost_PUB.Delete_eamPerBal API
35: -- prior to calling the Compute_Job_Estimate API

Line 34: -- 08-OCT-2003 SHBHANDA Made call for CST_eamCost_PUB.Delete_eamPerBal API

30: --
31: -- 24-SEP-2003 SHBHANDA Made call for CST_eamCost_PUB.Compute_Job_Estimate API
32: -- in Rollup_MR_Cost_Hierarchy API
33: --
34: -- 08-OCT-2003 SHBHANDA Made call for CST_eamCost_PUB.Delete_eamPerBal API
35: -- prior to calling the Compute_Job_Estimate API
36: -- in Rollup_MR_Cost_Hierarchy API
37: --
38: -- 14-OCT-2003 SHBHANDA Incorporated Estimate_WO_Cost to be called from

Line 2079: -- Call for CST_EAMCOST_PUB.Delete_eamPerBal API

2075: OPEN c_visit_details(p_visit_id);
2076: FETCH c_visit_details INTO visit_rec;
2077: CLOSE c_visit_details;
2078:
2079: -- Call for CST_EAMCOST_PUB.Delete_eamPerBal API
2080: -- To reset WIP_EAM_PERIOD_BALANCES for the work
2081: -- orders before calling the Work Order Cost Rollup API
2082:
2083: -- yazhou 22Sept2005 starts

Line 2104: 'Before Calling CST_EAMCOST_PUB.Delete_eamPerBal' );

2100:
2101: IF (l_log_statement >= l_log_current_level) THEN
2102: fnd_log.string(l_log_statement,
2103: L_DEBUG_KEY,
2104: 'Before Calling CST_EAMCOST_PUB.Delete_eamPerBal' );
2105: END IF;
2106:
2107: CST_EAMCOST_PUB.Delete_eamPerBal (
2108: p_api_version => 1.0,

Line 2107: CST_EAMCOST_PUB.Delete_eamPerBal (

2103: L_DEBUG_KEY,
2104: 'Before Calling CST_EAMCOST_PUB.Delete_eamPerBal' );
2105: END IF;
2106:
2107: CST_EAMCOST_PUB.Delete_eamPerBal (
2108: p_api_version => 1.0,
2109: p_init_msg_list => Fnd_Api.G_FALSE,
2110: p_commit => Fnd_Api.G_FALSE,
2111: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,

Line 2124: 'After Calling CST_EAMCOST_PUB.Delete_eamPerBal, Return Status = ' || l_return_status );

2120:
2121: IF (l_log_statement >= l_log_current_level) THEN
2122: fnd_log.string(l_log_statement,
2123: L_DEBUG_KEY,
2124: 'After Calling CST_EAMCOST_PUB.Delete_eamPerBal, Return Status = ' || l_return_status );
2125: END IF;
2126:
2127: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2128:

Line 2132: 'Errors from CST_EAMCOST_PUB.Delete_eamPerBal API -COST SESSION' || l_msg_count );

2128:
2129: IF (l_log_statement >= l_log_current_level) THEN
2130: fnd_log.string(l_log_statement,
2131: L_DEBUG_KEY,
2132: 'Errors from CST_EAMCOST_PUB.Delete_eamPerBal API -COST SESSION' || l_msg_count );
2133: END IF;
2134:
2135: RAISE Fnd_Api.g_exc_error;
2136: END IF;

Line 2140: -- Call for CST_EAMCOST_PUB.Compute_Job_Estimate API

2136: END IF;
2137:
2138: -- yazhou 22Sept2005 ends
2139:
2140: -- Call for CST_EAMCOST_PUB.Compute_Job_Estimate API
2141: -- To generate the estimates for the work orders before
2142: -- calling the Work Order Cost Rollup API
2143:
2144: OPEN c_wip_jobs(p_visit_id);

Line 2153: 'Before calling CST_EAMCOST_PUB.Compute_Job_Estimate' );

2149:
2150: IF (l_log_statement >= l_log_current_level) THEN
2151: fnd_log.string(l_log_statement,
2152: L_DEBUG_KEY,
2153: 'Before calling CST_EAMCOST_PUB.Compute_Job_Estimate' );
2154: END IF;
2155:
2156: CST_EAMCOST_PUB.Compute_Job_Estimate (
2157: p_api_version => 1.0,

Line 2156: CST_EAMCOST_PUB.Compute_Job_Estimate (

2152: L_DEBUG_KEY,
2153: 'Before calling CST_EAMCOST_PUB.Compute_Job_Estimate' );
2154: END IF;
2155:
2156: CST_EAMCOST_PUB.Compute_Job_Estimate (
2157: p_api_version => 1.0,
2158: p_init_msg_list => Fnd_Api.G_FALSE,
2159: p_commit => Fnd_Api.G_FALSE,
2160: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,

Line 2175: 'After calling CST_EAMCOST_PUB.Compute_Job_Estimate, Return Status = ' || l_return_status);

2171:
2172: IF (l_log_statement >= l_log_current_level) THEN
2173: fnd_log.string(l_log_statement,
2174: L_DEBUG_KEY,
2175: 'After calling CST_EAMCOST_PUB.Compute_Job_Estimate, Return Status = ' || l_return_status);
2176: END IF;
2177:
2178: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2179:

Line 2183: 'Errors from CST_EAMCOST_PUB.Delete_eamPerBal API -COST SESSION' || l_msg_count );

2179:
2180: IF (l_log_statement >= l_log_current_level) THEN
2181: fnd_log.string(l_log_statement,
2182: L_DEBUG_KEY,
2183: 'Errors from CST_EAMCOST_PUB.Delete_eamPerBal API -COST SESSION' || l_msg_count );
2184: END IF;
2185:
2186: CLOSE c_wip_jobs;
2187: RAISE Fnd_Api.g_exc_error;

Line 2198: 'Before Calling CST_EAMCOST_PUB.Rollup_WorkOrderCost-COST SESSION' );

2194:
2195: IF (l_log_statement >= l_log_current_level) THEN
2196: fnd_log.string(l_log_statement,
2197: L_DEBUG_KEY,
2198: 'Before Calling CST_EAMCOST_PUB.Rollup_WorkOrderCost-COST SESSION' );
2199: END IF;
2200:
2201:
2202: -- Call for CST_EAMCOST_PUB.Rollup_WorkOrderCost API

Line 2202: -- Call for CST_EAMCOST_PUB.Rollup_WorkOrderCost API

2198: 'Before Calling CST_EAMCOST_PUB.Rollup_WorkOrderCost-COST SESSION' );
2199: END IF;
2200:
2201:
2202: -- Call for CST_EAMCOST_PUB.Rollup_WorkOrderCost API
2203: -- FOR VISIT COST STRUCTURE
2204: -- To calculate the cumulative costs of each hierarchy node
2205: -- and populate the CST_EAM_ROLLUP_COSTS with that information.
2206:

Line 2207: CST_EAMCOST_PUB.Rollup_WorkOrderCost

2203: -- FOR VISIT COST STRUCTURE
2204: -- To calculate the cumulative costs of each hierarchy node
2205: -- and populate the CST_EAM_ROLLUP_COSTS with that information.
2206:
2207: CST_EAMCOST_PUB.Rollup_WorkOrderCost
2208: (
2209: p_api_version => 1.0,
2210: p_init_msg_list => Fnd_Api.G_FALSE,
2211: p_commit => Fnd_Api.G_FALSE,

Line 2223: 'After Calling CST_EAMCOST_PUB.Rollup_WorkOrderCost-COST SESSION, Return Status = ' || l_return_status );

2219:
2220: IF (l_log_statement >= l_log_current_level) THEN
2221: fnd_log.string(l_log_statement,
2222: L_DEBUG_KEY,
2223: 'After Calling CST_EAMCOST_PUB.Rollup_WorkOrderCost-COST SESSION, Return Status = ' || l_return_status );
2224: END IF;
2225:
2226:
2227: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 2232: 'Errors from CST_EAMCOST_PUB.Rollup_WorkOrderCosts API -COST SESSION' || l_msg_count );

2228:
2229: IF (l_log_statement >= l_log_current_level) THEN
2230: fnd_log.string(l_log_statement,
2231: L_DEBUG_KEY,
2232: 'Errors from CST_EAMCOST_PUB.Rollup_WorkOrderCosts API -COST SESSION' || l_msg_count );
2233: END IF;
2234:
2235: RAISE Fnd_Api.g_exc_error;
2236: ELSE

Line 2243: 'Before Calling CST_EAMCOST_PUB.Rollup_WorkOrderCost-MR SESSION' );

2239:
2240: IF (l_log_statement >= l_log_current_level) THEN
2241: fnd_log.string(l_log_statement,
2242: L_DEBUG_KEY,
2243: 'Before Calling CST_EAMCOST_PUB.Rollup_WorkOrderCost-MR SESSION' );
2244: END IF;
2245:
2246: -- Call for CST_EAMCOST_PUB.Rollup_WorkOrderCost API
2247: -- FOR WORKORDER SCHEDULLING DEPENDENCIES

Line 2246: -- Call for CST_EAMCOST_PUB.Rollup_WorkOrderCost API

2242: L_DEBUG_KEY,
2243: 'Before Calling CST_EAMCOST_PUB.Rollup_WorkOrderCost-MR SESSION' );
2244: END IF;
2245:
2246: -- Call for CST_EAMCOST_PUB.Rollup_WorkOrderCost API
2247: -- FOR WORKORDER SCHEDULLING DEPENDENCIES
2248: -- To calculate the cumulative costs of each hierarchy node
2249: -- and populate the CST_EAM_ROLLUP_COSTS with that information.
2250:

Line 2252: CST_EAMCOST_PUB.Rollup_WorkOrderCost

2248: -- To calculate the cumulative costs of each hierarchy node
2249: -- and populate the CST_EAM_ROLLUP_COSTS with that information.
2250:
2251:
2252: CST_EAMCOST_PUB.Rollup_WorkOrderCost
2253: (
2254: p_api_version => 1.0,
2255: p_init_msg_list => Fnd_Api.G_FALSE,
2256: p_commit => Fnd_Api.G_FALSE,

Line 2268: 'After Calling CST_EAMCOST_PUB.Rollup_WorkOrderCost-MR SESSION, Return Status = ' || l_return_status);

2264:
2265: IF (l_log_statement >= l_log_current_level) THEN
2266: fnd_log.string(l_log_statement,
2267: L_DEBUG_KEY,
2268: 'After Calling CST_EAMCOST_PUB.Rollup_WorkOrderCost-MR SESSION, Return Status = ' || l_return_status);
2269: END IF;
2270:
2271: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2272:

Line 2276: 'Errors from CST_EAMCOST_PUB.Rollup_WorkOrderCosts API -MR SESSION' || l_msg_count);

2272:
2273: IF (l_log_statement >= l_log_current_level) THEN
2274: fnd_log.string(l_log_statement,
2275: L_DEBUG_KEY,
2276: 'Errors from CST_EAMCOST_PUB.Rollup_WorkOrderCosts API -MR SESSION' || l_msg_count);
2277: END IF;
2278:
2279: RAISE Fnd_Api.g_exc_error;
2280: ELSE