DBA Data[Home] [Help]

APPS.CSF_TASK_ASSIGNMENTS_PUB dependencies on FND_MSG_PUB

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

279: EXCEPTION
280: WHEN fnd_api.g_exc_error THEN
281: x_trip_id := NULL;
282: x_return_status := fnd_api.g_ret_sts_error;
283: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
284: WHEN fnd_api.g_exc_unexpected_error THEN
285: x_trip_id := NULL;
286: x_return_status := fnd_api.g_ret_sts_unexp_error;
287: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

283: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
284: WHEN fnd_api.g_exc_unexpected_error THEN
285: x_trip_id := NULL;
286: x_return_status := fnd_api.g_ret_sts_unexp_error;
287: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
288: WHEN OTHERS THEN
289: x_return_status := fnd_api.g_ret_sts_unexp_error;
290: x_trip_id := NULL;
291: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

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

287: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
288: WHEN OTHERS THEN
289: x_return_status := fnd_api.g_ret_sts_unexp_error;
290: x_trip_id := NULL;
291: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
292: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
293: END IF;
294: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
295: END update_trip_info;

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

288: WHEN OTHERS THEN
289: x_return_status := fnd_api.g_ret_sts_unexp_error;
290: x_trip_id := NULL;
291: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
292: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
293: END IF;
294: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
295: END update_trip_info;
296:

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

290: x_trip_id := NULL;
291: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
292: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
293: END IF;
294: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
295: END update_trip_info;
296:
297: /**
298: * Propagate the Assignment Status Change to its dependent Objects like

Line 593: fnd_msg_pub.initialize;

589: RAISE fnd_api.g_exc_unexpected_error;
590: END IF;
591:
592: IF fnd_api.to_boolean(p_init_msg_list) THEN
593: fnd_msg_pub.initialize;
594: END IF;
595:
596: x_return_status := fnd_api.g_ret_sts_success;
597: l_trip_id := p_object_capacity_id;

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

768: EXCEPTION
769: WHEN fnd_api.g_exc_error THEN
770: ROLLBACK TO csf_create_task_assignment_pub;
771: x_return_status := fnd_api.g_ret_sts_error;
772: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
773: WHEN fnd_api.g_exc_unexpected_error THEN
774: ROLLBACK TO csf_create_task_assignment_pub;
775: x_return_status := fnd_api.g_ret_sts_unexp_error;
776: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

772: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
773: WHEN fnd_api.g_exc_unexpected_error THEN
774: ROLLBACK TO csf_create_task_assignment_pub;
775: x_return_status := fnd_api.g_ret_sts_unexp_error;
776: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
777: WHEN OTHERS THEN
778: x_return_status := fnd_api.g_ret_sts_unexp_error;
779: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
780: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

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

775: x_return_status := fnd_api.g_ret_sts_unexp_error;
776: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
777: WHEN OTHERS THEN
778: x_return_status := fnd_api.g_ret_sts_unexp_error;
779: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
780: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
781: END IF;
782: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
783: ROLLBACK TO csf_create_task_assignment_pub;

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

776: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
777: WHEN OTHERS THEN
778: x_return_status := fnd_api.g_ret_sts_unexp_error;
779: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
780: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
781: END IF;
782: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
783: ROLLBACK TO csf_create_task_assignment_pub;
784: END create_task_assignment;

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

778: x_return_status := fnd_api.g_ret_sts_unexp_error;
779: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
780: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
781: END IF;
782: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
783: ROLLBACK TO csf_create_task_assignment_pub;
784: END create_task_assignment;
785:
786: /**

Line 948: fnd_msg_pub.initialize;

944: RAISE fnd_api.g_exc_unexpected_error;
945: END IF;
946:
947: IF fnd_api.to_boolean(p_init_msg_list) THEN
948: fnd_msg_pub.initialize;
949: END IF;
950:
951: x_return_status := fnd_api.g_ret_sts_success;
952:

Line 1017: fnd_msg_pub.add;

1013: fnd_message.set_name('CSF','CSF_CROSSTASK_VALIDATION');
1014: fnd_message.set_token('TASK_NUMBER',l_task_number);
1015: fnd_message.set_token('TASK_ASSIGNMENT_STATUS',l_task_name);
1016: --fnd_message.set_token('TRIP_START_DATE',TO_CHAR(L_TRIP_START,'DD/MM/YYYY HH24:MI:SS'));
1017: fnd_msg_pub.add;
1018: raise fnd_api.g_exc_error;
1019: END IF;
1020: END IF;
1021: END LOOP;

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_task_assignment_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_task_assignment_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_task_assignment_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_task_assignment_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_task_assignment_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_task_assignment_pub;
1187: END update_task_assignment;

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_task_assignment_pub;
1187: END update_task_assignment;
1188:
1189: /**

Line 1340: fnd_msg_pub.initialize;

1336: RAISE fnd_api.g_exc_unexpected_error;
1337: END IF;
1338:
1339: IF fnd_api.to_boolean(p_init_msg_list) THEN
1340: fnd_msg_pub.initialize;
1341: END IF;
1342:
1343: x_return_status := fnd_api.g_ret_sts_success;
1344:

Line 1408: fnd_msg_pub.add;

1404: fnd_message.set_name('CSF','CSF_CROSSTASK_VALIDATION');
1405: fnd_message.set_token('TASK_NUMBER',l_task_number);
1406: fnd_message.set_token('TASK_ASSIGNMENT_STATUS',l_task_name);
1407: --fnd_message.set_token('TRIP_START_DATE',TO_CHAR(L_TRIP_START,'DD/MM/YYYY HH24:MI:SS'));
1408: fnd_msg_pub.add;
1409: raise fnd_api.g_exc_error;
1410: END IF;
1411: END IF;
1412: END LOOP;

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

1462: IF fnd_api.to_boolean(p_commit) THEN
1463: COMMIT WORK;
1464: END IF;
1465:
1466: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1467: EXCEPTION
1468: WHEN fnd_api.g_exc_error THEN
1469: ROLLBACK TO csf_update_assign_status_pub;
1470: x_return_status := fnd_api.g_ret_sts_error;

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

1467: EXCEPTION
1468: WHEN fnd_api.g_exc_error THEN
1469: ROLLBACK TO csf_update_assign_status_pub;
1470: x_return_status := fnd_api.g_ret_sts_error;
1471: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1472: WHEN fnd_api.g_exc_unexpected_error THEN
1473: ROLLBACK TO csf_update_assign_status_pub;
1474: x_return_status := fnd_api.g_ret_sts_unexp_error;
1475: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

1471: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1472: WHEN fnd_api.g_exc_unexpected_error THEN
1473: ROLLBACK TO csf_update_assign_status_pub;
1474: x_return_status := fnd_api.g_ret_sts_unexp_error;
1475: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1476: WHEN OTHERS THEN
1477: x_return_status := fnd_api.g_ret_sts_unexp_error;
1478: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1479: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

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

1474: x_return_status := fnd_api.g_ret_sts_unexp_error;
1475: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1476: WHEN OTHERS THEN
1477: x_return_status := fnd_api.g_ret_sts_unexp_error;
1478: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1479: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1480: END IF;
1481: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1482: ROLLBACK TO csf_update_assign_status_pub;

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

1475: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1476: WHEN OTHERS THEN
1477: x_return_status := fnd_api.g_ret_sts_unexp_error;
1478: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1479: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1480: END IF;
1481: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1482: ROLLBACK TO csf_update_assign_status_pub;
1483: END update_assignment_status;

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

1477: x_return_status := fnd_api.g_ret_sts_unexp_error;
1478: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1479: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1480: END IF;
1481: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1482: ROLLBACK TO csf_update_assign_status_pub;
1483: END update_assignment_status;
1484:
1485: FUNCTION cross_task_val(p_task_assignment_id NUMBER,p_assignment_status NUMBER,p_task out NOCOPY NUMBER)

Line 1871: fnd_msg_pub.add;

1867: fnd_message.set_name('CSF','CSF_CROSSTASK_VALIDATION');
1868: fnd_message.set_token('TASK_NUMBER',l_task_number);
1869: fnd_message.set_token('TASK_ASSIGNMENT_STATUS',l_task_name);
1870: --fnd_message.set_token('TRIP_START_DATE',TO_CHAR(L_TRIP_START,'DD/MM/YYYY HH24:MI:SS'));
1871: fnd_msg_pub.add;
1872: raise fnd_api.g_exc_error;
1873: END IF;
1874: END IF;
1875: END LOOP;

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

1878: x_return_status := fnd_api.g_ret_sts_success;
1879: EXCEPTION
1880: WHEN others THEN
1881: x_return_status := fnd_api.g_ret_sts_unexp_error;
1882: IF fnd_msg_pub.check_msg_level ( fnd_msg_pub.g_msg_lvl_unexp_error )
1883: THEN
1884: fnd_msg_pub.add_exc_msg ( g_pkg_name, l_api_name );
1885: END IF;
1886:

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

1880: WHEN others THEN
1881: x_return_status := fnd_api.g_ret_sts_unexp_error;
1882: IF fnd_msg_pub.check_msg_level ( fnd_msg_pub.g_msg_lvl_unexp_error )
1883: THEN
1884: fnd_msg_pub.add_exc_msg ( g_pkg_name, l_api_name );
1885: END IF;
1886:
1887: END;
1888: