DBA Data[Home] [Help]

APPS.JTF_RS_IMP_RES_PVT dependencies on FND_MSG_PUB

Line 436: fnd_msg_pub.initialize;

432: RAISE fnd_api.g_exc_unexpected_error;
433: END IF;
434:
435: IF fnd_api.to_boolean(p_init_msg_list) THEN
436: fnd_msg_pub.initialize;
437: END IF;
438:
439: -- initializing the transaction number
440: l_transaction_number := null;

Line 574: fnd_msg_pub.add;

570: IF (p_imp_res_tbl(i).create_salesperson = 'Y') THEN
571: IF p_imp_res_tbl(i).salesperson_number IS NULL THEN
572: fnd_message.set_name('JTF','JTF_RS_NO_SRP_NUM_ENT_FOR_EMP');
573: fnd_message.set_token('P_EMP_NAME',p_imp_res_tbl(i).name);
574: fnd_msg_pub.add;
575: RAISE fnd_api.g_exc_error;
576: ELSE
577: --Create a Salesperson for the Resource Created above
578: JTF_RS_SALESREPS_PUB.CREATE_SALESREP (

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

910: IF fnd_api.to_boolean(p_commit) THEN
911: COMMIT WORK;
912: END IF;
913:
914: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
915:
916: EXCEPTION
917: WHEN fnd_api.g_exc_error THEN
918: ROLLBACK TO import_resources;

Line 921: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

917: WHEN fnd_api.g_exc_error THEN
918: ROLLBACK TO import_resources;
919: x_return_status := fnd_api.g_ret_sts_error;
920: x_transaction_num := NULL;
921: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
922: p_data => x_msg_data);
923: WHEN fnd_api.g_exc_unexpected_error THEN
924: ROLLBACK TO import_resources;
925: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 927: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

923: WHEN fnd_api.g_exc_unexpected_error THEN
924: ROLLBACK TO import_resources;
925: x_return_status := fnd_api.g_ret_sts_unexp_error;
926: x_transaction_num := NULL;
927: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
928: p_data => x_msg_data);
929: WHEN OTHERS THEN
930: ROLLBACK TO import_resources;
931: fnd_message.set_name ('JTF','JTF_RS_UNEXP_ERROR');

Line 935: FND_MSG_PUB.add;

931: fnd_message.set_name ('JTF','JTF_RS_UNEXP_ERROR');
932: fnd_message.set_token('P_SQLCODE',SQLCODE);
933: fnd_message.set_token('P_SQLERRM',SQLERRM);
934: fnd_message.set_token('P_API_NAME',l_api_name);
935: FND_MSG_PUB.add;
936: x_return_status := fnd_api.g_ret_sts_unexp_error;
937: x_transaction_num := NULL;
938: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
939: p_data => x_msg_data);

Line 938: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

934: fnd_message.set_token('P_API_NAME',l_api_name);
935: FND_MSG_PUB.add;
936: x_return_status := fnd_api.g_ret_sts_unexp_error;
937: x_transaction_num := NULL;
938: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
939: p_data => x_msg_data);
940:
941: END import_resources;
942: