DBA Data[Home] [Help]

APPS.CSF_TASK_ASSIGNMENTS_PUB dependencies on FND_MSG_PUB

Line 261: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

257: EXCEPTION
258: WHEN fnd_api.g_exc_error THEN
259: x_trip_id := NULL;
260: x_return_status := fnd_api.g_ret_sts_error;
261: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
262: WHEN fnd_api.g_exc_unexpected_error THEN
263: x_trip_id := NULL;
264: x_return_status := fnd_api.g_ret_sts_unexp_error;
265: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 265: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

261: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
262: WHEN fnd_api.g_exc_unexpected_error THEN
263: x_trip_id := NULL;
264: x_return_status := fnd_api.g_ret_sts_unexp_error;
265: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
266: WHEN OTHERS THEN
267: x_return_status := fnd_api.g_ret_sts_unexp_error;
268: x_trip_id := NULL;
269: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 269: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

265: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
266: WHEN OTHERS THEN
267: x_return_status := fnd_api.g_ret_sts_unexp_error;
268: x_trip_id := NULL;
269: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
270: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
271: END IF;
272: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
273: END update_trip_info;

Line 270: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

266: WHEN OTHERS THEN
267: x_return_status := fnd_api.g_ret_sts_unexp_error;
268: x_trip_id := NULL;
269: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
270: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
271: END IF;
272: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
273: END update_trip_info;
274:

Line 272: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

268: x_trip_id := NULL;
269: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
270: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
271: END IF;
272: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
273: END update_trip_info;
274:
275: /**
276: * Propagate the Assignment Status Change to its dependent Objects like

Line 538: fnd_msg_pub.initialize;

534: RAISE fnd_api.g_exc_unexpected_error;
535: END IF;
536:
537: IF fnd_api.to_boolean(p_init_msg_list) THEN
538: fnd_msg_pub.initialize;
539: END IF;
540:
541: x_return_status := fnd_api.g_ret_sts_success;
542: l_trip_id := p_object_capacity_id;

Line 685: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

681: EXCEPTION
682: WHEN fnd_api.g_exc_error THEN
683: ROLLBACK TO csf_create_task_assignment_pub;
684: x_return_status := fnd_api.g_ret_sts_error;
685: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
686: WHEN fnd_api.g_exc_unexpected_error THEN
687: ROLLBACK TO csf_create_task_assignment_pub;
688: x_return_status := fnd_api.g_ret_sts_unexp_error;
689: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 689: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

685: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
686: WHEN fnd_api.g_exc_unexpected_error THEN
687: ROLLBACK TO csf_create_task_assignment_pub;
688: x_return_status := fnd_api.g_ret_sts_unexp_error;
689: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
690: WHEN OTHERS THEN
691: x_return_status := fnd_api.g_ret_sts_unexp_error;
692: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
693: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

Line 692: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

688: x_return_status := fnd_api.g_ret_sts_unexp_error;
689: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
690: WHEN OTHERS THEN
691: x_return_status := fnd_api.g_ret_sts_unexp_error;
692: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
693: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
694: END IF;
695: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
696: ROLLBACK TO csf_create_task_assignment_pub;

Line 693: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

689: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
690: WHEN OTHERS THEN
691: x_return_status := fnd_api.g_ret_sts_unexp_error;
692: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
693: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
694: END IF;
695: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
696: ROLLBACK TO csf_create_task_assignment_pub;
697: END create_task_assignment;

Line 695: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

691: x_return_status := fnd_api.g_ret_sts_unexp_error;
692: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
693: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
694: END IF;
695: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
696: ROLLBACK TO csf_create_task_assignment_pub;
697: END create_task_assignment;
698:
699: /**

Line 808: fnd_msg_pub.initialize;

804: RAISE fnd_api.g_exc_unexpected_error;
805: END IF;
806:
807: IF fnd_api.to_boolean(p_init_msg_list) THEN
808: fnd_msg_pub.initialize;
809: END IF;
810:
811: x_return_status := fnd_api.g_ret_sts_success;
812:

Line 972: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

968: IF fnd_api.to_boolean(p_commit) THEN
969: COMMIT WORK;
970: END IF;
971:
972: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
973: EXCEPTION
974: WHEN fnd_api.g_exc_error THEN
975: ROLLBACK TO csf_update_task_assignment_pub;
976: x_return_status := fnd_api.g_ret_sts_error;

Line 977: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

973: EXCEPTION
974: WHEN fnd_api.g_exc_error THEN
975: ROLLBACK TO csf_update_task_assignment_pub;
976: x_return_status := fnd_api.g_ret_sts_error;
977: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
978: WHEN fnd_api.g_exc_unexpected_error THEN
979: ROLLBACK TO csf_update_task_assignment_pub;
980: x_return_status := fnd_api.g_ret_sts_unexp_error;
981: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 981: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

977: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
978: WHEN fnd_api.g_exc_unexpected_error THEN
979: ROLLBACK TO csf_update_task_assignment_pub;
980: x_return_status := fnd_api.g_ret_sts_unexp_error;
981: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
982: WHEN OTHERS THEN
983: x_return_status := fnd_api.g_ret_sts_unexp_error;
984: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
985: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

Line 984: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

980: x_return_status := fnd_api.g_ret_sts_unexp_error;
981: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
982: WHEN OTHERS THEN
983: x_return_status := fnd_api.g_ret_sts_unexp_error;
984: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
985: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
986: END IF;
987: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
988: ROLLBACK TO csf_update_task_assignment_pub;

Line 985: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

981: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
982: WHEN OTHERS THEN
983: x_return_status := fnd_api.g_ret_sts_unexp_error;
984: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
985: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
986: END IF;
987: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
988: ROLLBACK TO csf_update_task_assignment_pub;
989: END update_task_assignment;

Line 987: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

983: x_return_status := fnd_api.g_ret_sts_unexp_error;
984: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
985: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
986: END IF;
987: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
988: ROLLBACK TO csf_update_task_assignment_pub;
989: END update_task_assignment;
990:
991: /**

Line 1082: fnd_msg_pub.initialize;

1078: RAISE fnd_api.g_exc_unexpected_error;
1079: END IF;
1080:
1081: IF fnd_api.to_boolean(p_init_msg_list) THEN
1082: fnd_msg_pub.initialize;
1083: END IF;
1084:
1085: x_return_status := fnd_api.g_ret_sts_success;
1086:

Line 1170: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

1166: IF fnd_api.to_boolean(p_commit) THEN
1167: COMMIT WORK;
1168: END IF;
1169:
1170: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1171: EXCEPTION
1172: WHEN fnd_api.g_exc_error THEN
1173: ROLLBACK TO csf_update_assign_status_pub;
1174: x_return_status := fnd_api.g_ret_sts_error;

Line 1175: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

1171: EXCEPTION
1172: WHEN fnd_api.g_exc_error THEN
1173: ROLLBACK TO csf_update_assign_status_pub;
1174: x_return_status := fnd_api.g_ret_sts_error;
1175: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1176: WHEN fnd_api.g_exc_unexpected_error THEN
1177: ROLLBACK TO csf_update_assign_status_pub;
1178: x_return_status := fnd_api.g_ret_sts_unexp_error;
1179: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 1179: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

1175: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1176: WHEN fnd_api.g_exc_unexpected_error THEN
1177: ROLLBACK TO csf_update_assign_status_pub;
1178: x_return_status := fnd_api.g_ret_sts_unexp_error;
1179: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1180: WHEN OTHERS THEN
1181: x_return_status := fnd_api.g_ret_sts_unexp_error;
1182: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1183: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

Line 1182: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1178: x_return_status := fnd_api.g_ret_sts_unexp_error;
1179: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1180: WHEN OTHERS THEN
1181: x_return_status := fnd_api.g_ret_sts_unexp_error;
1182: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1183: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1184: END IF;
1185: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1186: ROLLBACK TO csf_update_assign_status_pub;

Line 1183: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

1179: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1180: WHEN OTHERS THEN
1181: x_return_status := fnd_api.g_ret_sts_unexp_error;
1182: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1183: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1184: END IF;
1185: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1186: ROLLBACK TO csf_update_assign_status_pub;
1187: END update_assignment_status;

Line 1185: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

1181: x_return_status := fnd_api.g_ret_sts_unexp_error;
1182: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1183: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1184: END IF;
1185: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1186: ROLLBACK TO csf_update_assign_status_pub;
1187: END update_assignment_status;
1188:
1189: