DBA Data[Home] [Help]

APPS.CST_EAMJOB_ACTESTIMATE dependencies on FND_MSG_PUB

Line 85: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)

81: FND_FILE.PUT_LINE(FND_FILE.LOG,'Get_eamCostElement - statement '
82: || l_stmt_num || ': '
83: || substr(SQLERRM,1,200));
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)

Line 87: FND_MSG_PUB.add_exc_msg

83: || substr(SQLERRM,1,200));
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;

Line 175: FND_MSG_PUB.initialize;

171:
172: l_stmt_num := 10;
173:
174: IF FND_API.to_Boolean(p_init_msg_list) THEN
175: FND_MSG_PUB.initialize;
176: END IF;
177:
178:
179: -------------------------------------------------------------------------

Line 233: FND_MSG_PUB.ADD_EXC_MSG('CST_EAMJOB_ACTESTIMATE', 'Get_DeptCostCatg('

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:

Line 254: FND_MSG_PUB.Count_And_Get (

250: ---------------------------------------------------------------------------
251: -- Standard Call to get message count and if count = 1, get message info
252: ---------------------------------------------------------------------------
253:
254: FND_MSG_PUB.Count_And_Get (
255: p_count => x_msg_count,
256: p_data => x_msg_data );
257:
258:

Line 265: fnd_msg_pub.count_and_get

261: WHEN fnd_api.g_exc_error THEN
262: x_return_status := fnd_api.g_ret_sts_error;
263:
264: -- Get message count and data
265: fnd_msg_pub.count_and_get
266: ( p_count => x_msg_count
267: , p_data => x_msg_data
268: );
269: --

Line 274: fnd_msg_pub.count_and_get

270: WHEN fnd_api.g_exc_unexpected_error THEN
271: x_return_status := fnd_api.g_ret_sts_unexp_error ;
272:
273: -- Get message count and data
274: fnd_msg_pub.count_and_get
275: ( p_count => x_msg_count
276: , p_data => x_msg_data
277: );
278: --

Line 282: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)

278: --
279: WHEN OTHERS THEN
280: x_return_status := fnd_api.g_ret_sts_unexp_error ;
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)

Line 284: fnd_msg_pub.add_exc_msg

280: x_return_status := fnd_api.g_ret_sts_unexp_error ;
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:

Line 291: fnd_msg_pub.count_and_get

287: );
288:
289: END IF;
290: -- Get message count and data
291: fnd_msg_pub.count_and_get
292: ( p_count => x_msg_count
293: , p_data => x_msg_data
294: );
295:

Line 597: FND_MSG_PUB.initialize;

593: -- Initialize message list if p_init_msg_list is set to TRUE
594: -------------------------------------------------------------------------
595:
596: IF FND_API.to_Boolean(p_init_msg_list) THEN
597: FND_MSG_PUB.initialize;
598: END IF;
599:
600:
601: -------------------------------------------------------------------------

Line 625: FND_MSG_PUB.ADD_EXC_MSG('CST_EAMJOB_ACTESTIMATE', 'COMPUTE_ACTIVITY_EST('

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:

Line 683: FND_MSG_PUB.ADD_EXC_MSG('CST_EAMJOB_ACTESTIMATE', 'COMPUTE_ACTIVITY_EST('

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:

Line 721: FND_MSG_PUB.add;

717: ||TO_CHAR(l_primary_cost_method);
718:
719: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
720: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
721: FND_MSG_PUB.add;
722:
723:
724: END IF;
725:

Line 746: FND_MSG_PUB.add;

742: ||TO_CHAR(c_bor_rec.resource_value);
743:
744: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
745: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
746: FND_MSG_PUB.add;
747:
748: END IF;
749:
750: l_stmt_num := 45;

Line 771: FND_MSG_PUB.ADD_EXC_MSG('CST_EAMJOB_ACTESTIMATE', 'COMPUTE_Activty_Estimate('

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:

Line 788: FND_MSG_PUB.ADD_EXC_MSG('CST_EAMJOB_ACTESTIMATE', 'COMPUTE_JOB_ESTIMATES('

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:

Line 803: FND_MSG_PUB.add;

799: l_api_message :=l_api_message||' CE: '||TO_CHAR(l_eam_cost_element);
800: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
801: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
802:
803: FND_MSG_PUB.add;
804:
805: END IF;
806:
807: l_stmt_num := 55;

Line 849: FND_MSG_PUB.add;

845: l_api_message :=l_api_message||TO_CHAR(l_maint_cost_category);
846: l_api_message :=l_api_message||' CE: '||TO_CHAR(l_eam_cost_element);
847: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
848: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
849: FND_MSG_PUB.add;
850:
851: END IF;
852:
853: l_stmt_num := 65;

Line 898: FND_MSG_PUB.add;

894: l_api_message :=l_api_message||' WRO,Value: '
895: ||TO_CHAR(c_bbom_rec.mat_value);
896: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
897: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
898: FND_MSG_PUB.add;
899:
900: END IF;
901:
902: l_stmt_num := 80;

Line 924: FND_MSG_PUB.ADD_EXC_MSG('CST_EAMJOAB_ACTESTIMATE', 'COMPUTE_ACTIVITY_EST('

920: IF l_return_status <> FND_API.g_ret_sts_success THEN
921:
922: l_api_message := 'Get_DeptCostCatg returned error';
923:
924: FND_MSG_PUB.ADD_EXC_MSG('CST_EAMJOAB_ACTESTIMATE', 'COMPUTE_ACTIVITY_EST('
925: ||TO_CHAR(l_stmt_num)
926: ||'): ', l_api_message);
927: RAISE FND_API.g_exc_error;
928:

Line 941: FND_MSG_PUB.ADD_EXC_MSG('CST_EAMJOB_ACTESTIMATE', 'COMPUTE_ACTIVITY_ESTIMATE('

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:

Line 956: FND_MSG_PUB.add;

952: l_api_message :=l_api_message||TO_CHAR(l_maint_cost_category);
953: l_api_message :=l_api_message||' CE: '||TO_CHAR(l_eam_cost_element);
954: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
955: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
956: FND_MSG_PUB.add;
957:
958: END IF;
959:
960: l_stmt_num := 90;

Line 995: FND_MSG_PUB.Count_And_Get (

991: ---------------------------------------------------------------------------
992: -- Standard Call to get message count and if count = 1, get message info
993: ---------------------------------------------------------------------------
994:
995: FND_MSG_PUB.Count_And_Get (
996: p_count => x_msg_count,
997: p_data => x_msg_data );
998:
999: EXCEPTION

Line 1005: fnd_msg_pub.count_and_get

1001: WHEN fnd_api.g_exc_error THEN
1002: x_return_status := fnd_api.g_ret_sts_error;
1003:
1004: -- Get message count and data
1005: fnd_msg_pub.count_and_get
1006: ( p_count => x_msg_count
1007: , p_data => x_msg_data
1008: );
1009: --

Line 1014: fnd_msg_pub.count_and_get

1010: WHEN fnd_api.g_exc_unexpected_error THEN
1011: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1012:
1013: -- Get message count and data
1014: fnd_msg_pub.count_and_get
1015: ( p_count => x_msg_count
1016: , p_data => x_msg_data
1017: );
1018: --

Line 1022: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)

1018: --
1019: WHEN OTHERS THEN
1020: x_return_status := fnd_api.g_ret_sts_unexp_error ;
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:

Line 1024: fnd_msg_pub.add_exc_msg

1020: x_return_status := fnd_api.g_ret_sts_unexp_error ;
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: );

Line 1032: fnd_msg_pub.count_and_get

1028: );
1029:
1030: END IF;
1031: -- Get message count and data
1032: fnd_msg_pub.count_and_get
1033: ( p_count => x_msg_count
1034: , p_data => x_msg_data
1035: );
1036:

Line 1126: FND_MSG_PUB.initialize;

1122: -- Initialize message list if p_init_msg_list is set to TRUE
1123: -------------------------------------------------------------------------
1124:
1125: IF FND_API.to_Boolean(p_init_msg_list) THEN
1126: FND_MSG_PUB.initialize;
1127: END IF;
1128:
1129:
1130: -------------------------------------------------------------------------

Line 1162: FND_MSG_PUB.ADD_EXC_MSG('CST_EAMJOB_ACTESTIMATE', 'GET_ACTIVITY_EST('

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:

Line 1239: FND_MSG_PUB.Count_And_Get (

1235: ---------------------------------------------------------------------------
1236: -- Standard Call to get message count and if count = 1, get message info
1237: ---------------------------------------------------------------------------
1238:
1239: FND_MSG_PUB.Count_And_Get (
1240: p_count => x_msg_count,
1241: p_data => x_msg_data );
1242:
1243:

Line 1250: fnd_msg_pub.count_and_get

1246: WHEN fnd_api.g_exc_error THEN
1247: x_return_status := fnd_api.g_ret_sts_error;
1248:
1249: -- Get message count and data
1250: fnd_msg_pub.count_and_get
1251: ( p_count => x_msg_count
1252: , p_data => x_msg_data
1253: );
1254: --

Line 1259: fnd_msg_pub.count_and_get

1255: WHEN fnd_api.g_exc_unexpected_error THEN
1256: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1257:
1258: -- Get message count and data
1259: fnd_msg_pub.count_and_get
1260: ( p_count => x_msg_count
1261: , p_data => x_msg_data
1262: );
1263: --

Line 1267: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)

1263: --
1264: WHEN OTHERS THEN
1265: x_return_status := fnd_api.g_ret_sts_unexp_error ;
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:

Line 1269: fnd_msg_pub.add_exc_msg

1265: x_return_status := fnd_api.g_ret_sts_unexp_error ;
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: );

Line 1277: fnd_msg_pub.count_and_get

1273: );
1274:
1275: END IF;
1276: -- Get message count and data
1277: fnd_msg_pub.count_and_get
1278: ( p_count => x_msg_count
1279: , p_data => x_msg_data
1280: );
1281: