372: THEN
373: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
374: WHEN OTHERS
375: THEN
376: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
377: fnd_message.set_token('P_SQLCODE',SQLCODE);
378: fnd_message.set_token('P_SQLERRM',SQLERRM);
379: fnd_message.set_token('P_API_NAME',l_api_name);
380: FND_MSG_PUB.add;
373: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
374: WHEN OTHERS
375: THEN
376: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
377: fnd_message.set_token('P_SQLCODE',SQLCODE);
378: fnd_message.set_token('P_SQLERRM',SQLERRM);
379: fnd_message.set_token('P_API_NAME',l_api_name);
380: FND_MSG_PUB.add;
381: x_return_status := fnd_api.g_ret_sts_unexp_error;
374: WHEN OTHERS
375: THEN
376: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
377: fnd_message.set_token('P_SQLCODE',SQLCODE);
378: fnd_message.set_token('P_SQLERRM',SQLERRM);
379: fnd_message.set_token('P_API_NAME',l_api_name);
380: FND_MSG_PUB.add;
381: x_return_status := fnd_api.g_ret_sts_unexp_error;
382: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
375: THEN
376: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
377: fnd_message.set_token('P_SQLCODE',SQLCODE);
378: fnd_message.set_token('P_SQLERRM',SQLERRM);
379: fnd_message.set_token('P_API_NAME',l_api_name);
380: FND_MSG_PUB.add;
381: x_return_status := fnd_api.g_ret_sts_unexp_error;
382: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
383:
496: :9 := l_return_status;
497:
498: IF NOT (l_return_status = fnd_api.g_ret_sts_success) THEN
499: -- Unexpected Execution Error from call to Contracts API
500: fnd_message.set_name('||''''||'JTF'||''''||','||''''||'JTF_AM_ERROR_SERVICE_API'||''''||');'||
501: 'fnd_msg_pub.add;
502: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
503: RAISE fnd_api.g_exc_error;
504: ELSE
586: THEN
587: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
588: WHEN OTHERS
589: THEN
590: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
591: fnd_message.set_token('P_SQLCODE',SQLCODE);
592: fnd_message.set_token('P_SQLERRM',SQLERRM);
593: fnd_message.set_token('P_API_NAME',l_api_name);
594: FND_MSG_PUB.add;
587: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
588: WHEN OTHERS
589: THEN
590: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
591: fnd_message.set_token('P_SQLCODE',SQLCODE);
592: fnd_message.set_token('P_SQLERRM',SQLERRM);
593: fnd_message.set_token('P_API_NAME',l_api_name);
594: FND_MSG_PUB.add;
595: x_return_status := fnd_api.g_ret_sts_unexp_error;
588: WHEN OTHERS
589: THEN
590: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
591: fnd_message.set_token('P_SQLCODE',SQLCODE);
592: fnd_message.set_token('P_SQLERRM',SQLERRM);
593: fnd_message.set_token('P_API_NAME',l_api_name);
594: FND_MSG_PUB.add;
595: x_return_status := fnd_api.g_ret_sts_unexp_error;
596: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
589: THEN
590: fnd_message.set_name ('JTF', 'JTF_AM_UNEXP_ERROR');
591: fnd_message.set_token('P_SQLCODE',SQLCODE);
592: fnd_message.set_token('P_SQLERRM',SQLERRM);
593: fnd_message.set_token('P_API_NAME',l_api_name);
594: FND_MSG_PUB.add;
595: x_return_status := fnd_api.g_ret_sts_unexp_error;
596: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
597: