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 2082: -- Call for CST_EAMCOST_PUB.Delete_eamPerBal API

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

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

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

Line 2110: CST_EAMCOST_PUB.Delete_eamPerBal (

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

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

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

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

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

Line 2143: -- Call for CST_EAMCOST_PUB.Compute_Job_Estimate API

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

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

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

Line 2159: CST_EAMCOST_PUB.Compute_Job_Estimate (

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

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

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

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

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

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

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

Line 2205: -- Call for CST_EAMCOST_PUB.Rollup_WorkOrderCost API

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

Line 2210: CST_EAMCOST_PUB.Rollup_WorkOrderCost

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

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

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

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

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

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

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

Line 2249: -- Call for CST_EAMCOST_PUB.Rollup_WorkOrderCost API

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

Line 2255: CST_EAMCOST_PUB.Rollup_WorkOrderCost

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

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

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

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

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