1: PACKAGE BODY CST_EAMJOB_ACTESTIMATE AS
2: /* $Header: CSTPJACB.pls 115.3 2003/11/25 02:30:10 lsoo ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CST_EAMJOB_ACTESTIMATE';
5:
1: PACKAGE BODY CST_EAMJOB_ACTESTIMATE AS
2: /* $Header: CSTPJACB.pls 115.3 2003/11/25 02:30:10 lsoo ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CST_EAMJOB_ACTESTIMATE';
5:
6: /* ============================================================== */
7: -- FUNCTION
8: -- Get_eamCostElement()
84:
85: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
86: THEN
87: FND_MSG_PUB.add_exc_msg
88: ( 'CST_EAMJOB_ACTESTIMATE'
89: , '.Get_eamCostElement : Statement -'||to_char(l_stmt_num)
90: );
91: END IF;
92:
229: l_stmt_num := 45;
230:
231: l_api_message := 'Could not obtain Cost Category for Dept: '
232: ||TO_CHAR(p_department_id);
233: FND_MSG_PUB.ADD_EXC_MSG('CST_EAMJOB_ACTESTIMATE', 'Get_DeptCostCatg('
234: ||TO_CHAR(l_stmt_num)
235: ||'): ', l_api_message);
236: RAISE FND_API.g_exc_error;
237:
281: --
282: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
283: THEN
284: fnd_msg_pub.add_exc_msg
285: ( 'CST_EAMJOB_ACTESTIMATE'
286: , 'Get_DeptCostCatg : l_stmt_num - '||to_char(l_stmt_num)
287: );
288:
289: END IF;
621:
622: l_api_message := 'The following Item is not of type Activity: '
623: ||TO_CHAR(p_activity_item_id);
624:
625: FND_MSG_PUB.ADD_EXC_MSG('CST_EAMJOB_ACTESTIMATE', 'COMPUTE_ACTIVITY_EST('
626: ||TO_CHAR(l_stmt_num)
627: ||'): ', l_api_message);
628: RAISE FND_API.g_exc_error;
629:
679: IF (l_rates_ct = -1) THEN
680: l_api_message := 'Rates Type not defined for Org: '
681: ||TO_CHAR(p_organization_id);
682:
683: FND_MSG_PUB.ADD_EXC_MSG('CST_EAMJOB_ACTESTIMATE', 'COMPUTE_ACTIVITY_EST('
684: ||TO_CHAR(l_stmt_num)
685: ||'): ', l_api_message);
686: RAISE FND_API.g_exc_error;
687:
767:
768: IF l_return_status <> FND_API.g_ret_sts_success THEN
769:
770: l_api_message := 'Get_DeptCostCatg returned error';
771: FND_MSG_PUB.ADD_EXC_MSG('CST_EAMJOB_ACTESTIMATE', 'COMPUTE_Activty_Estimate('
772: ||TO_CHAR(l_stmt_num)
773: ||'): ', l_api_message);
774: RAISE FND_API.g_exc_error;
775:
784:
785: IF l_eam_cost_element = 0 THEN
786:
787: l_api_message := 'Get_eamCostElement returned error';
788: FND_MSG_PUB.ADD_EXC_MSG('CST_EAMJOB_ACTESTIMATE', 'COMPUTE_JOB_ESTIMATES('
789: ||TO_CHAR(l_stmt_num)
790: ||'): ', l_api_message);
791: RAISE FND_API.g_exc_error;
792:
937: IF l_eam_cost_element = 0 THEN
938:
939: l_api_message := 'Get_eamCostElement returned error';
940:
941: FND_MSG_PUB.ADD_EXC_MSG('CST_EAMJOB_ACTESTIMATE', 'COMPUTE_ACTIVITY_ESTIMATE('
942: ||TO_CHAR(l_stmt_num)
943: ||'): ', l_api_message);
944: RAISE FND_API.g_exc_error;
945:
1021: --
1022: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1023: THEN
1024: fnd_msg_pub.add_exc_msg
1025: ( 'CST_EAMJOB_ACTESTIMATE'
1026:
1027: , 'Compute_Activity_Estimate: l_stmt_num - '||to_char(l_stmt_num)
1028: );
1029:
1158: IF (l_return_status <> FND_API.g_ret_sts_success) THEN
1159:
1160: l_api_message := 'Compute_Activity_Estimate returned error';
1161:
1162: FND_MSG_PUB.ADD_EXC_MSG('CST_EAMJOB_ACTESTIMATE', 'GET_ACTIVITY_EST('
1163: ||TO_CHAR(l_stmt_num)
1164: ||'): ', l_api_message);
1165: RAISE FND_API.g_exc_error;
1166:
1266: --
1267: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1268: THEN
1269: fnd_msg_pub.add_exc_msg
1270: ( 'CST_EAMJOB_ACTESTIMATE'
1271:
1272: , 'Get_Activity_Estimate: l_stmt_num - '||to_char(l_stmt_num)
1273: );
1274:
1282:
1283: END Get_Activity_Estimate;
1284:
1285:
1286: END CST_EAMJOB_ACTESTIMATE;
1287: