DBA Data[Home] [Help]

APPS.JTF_AM_FILTER_RESOURCE_PVT dependencies on FND_MSG_PUB

Line 92: FND_MSG_PUB.Initialize;

88:
89: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
90: IF FND_API.To_boolean(P_INIT_MSG_LIST)
91: THEN
92: FND_MSG_PUB.Initialize;
93: END IF;
94: -- create statement
95: l_stmt_more := 'SELECT s.skill_level , s.level_name '||
96: ' FROM jtf_rs_resource_skills r, jtf_rs_skill_levels_vl s ' ||

Line 365: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

361: end if; -- end if c_rule found
362:
363: close c_rule;
364:
365: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
366:
367: EXCEPTION
368: WHEN fnd_api.g_exc_unexpected_error
369: THEN

Line 370: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

366:
367: EXCEPTION
368: WHEN fnd_api.g_exc_unexpected_error
369: THEN
370: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
371: WHEN fnd_api.g_exc_error
372: THEN
373: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
374: WHEN OTHERS

Line 373: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

369: THEN
370: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
371: WHEN fnd_api.g_exc_error
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);

Line 380: FND_MSG_PUB.add;

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:
384: END SEARCH_SKILL;

Line 382: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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:
384: END SEARCH_SKILL;
385:
386: -- this is called JTF_ASSIGN_PUB.get_assign_sr_resources

Line 422: FND_MSG_PUB.Initialize;

418:
419: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
420: IF FND_API.To_boolean(P_INIT_MSG_LIST)
421: THEN
422: FND_MSG_PUB.Initialize;
423: END IF;
424:
425: IF(x_assign_resources_tbl.count > 0)
426: THEN

Line 501: 'fnd_msg_pub.add;

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
505: RAISE fnd_api.g_exc_unexpected_error;

Line 584: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

580:
581: EXCEPTION
582: WHEN fnd_api.g_exc_unexpected_error
583: THEN
584: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
585: WHEN fnd_api.g_exc_error
586: THEN
587: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
588: WHEN OTHERS

Line 587: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

583: THEN
584: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
585: WHEN fnd_api.g_exc_error
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);

Line 594: FND_MSG_PUB.add;

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:
598: END SERVICE_SECURITY_CHECK;

Line 596: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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:
598: END SERVICE_SECURITY_CHECK;
599:
600: END JTF_AM_FILTER_RESOURCE_PVT;