eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_AM_FILTER_RESOURCE_PVT dependencies on FND_API

Line 81: x_return_status := fnd_api.g_ret_sts_success;

77: l_bind_counter number := 0;
78: bind_table bind_tbl_type;
79:
80: BEGIN
81: x_return_status := fnd_api.g_ret_sts_success;
82:
83: --Standard Call to check API compatibility
84: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
85: THEN

Line 84: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)

80: BEGIN
81: x_return_status := fnd_api.g_ret_sts_success;
82:
83: --Standard Call to check API compatibility
84: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
85: THEN
86: RAISE FND_API.G_EXC_ERROR;
87: END IF;
88:

Line 86: RAISE FND_API.G_EXC_ERROR;

82:
83: --Standard Call to check API compatibility
84: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
85: THEN
86: RAISE FND_API.G_EXC_ERROR;
87: END IF;
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)

Line 90: IF FND_API.To_boolean(P_INIT_MSG_LIST)

86: RAISE FND_API.G_EXC_ERROR;
87: END IF;
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

Line 368: WHEN fnd_api.g_exc_unexpected_error

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
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

Line 371: WHEN fnd_api.g_exc_error

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
375: THEN

Line 381: x_return_status := fnd_api.g_ret_sts_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;
385:

Line 412: x_return_status := fnd_api.g_ret_sts_success;

408: i number := 0;
409: l_current_rec number := 0;
410: l_temp number := 0;
411: BEGIN
412: x_return_status := fnd_api.g_ret_sts_success;
413: --Standard Call to check API compatibility
414: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
415: THEN
416: RAISE FND_API.G_EXC_ERROR;

Line 414: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)

410: l_temp number := 0;
411: BEGIN
412: x_return_status := fnd_api.g_ret_sts_success;
413: --Standard Call to check API compatibility
414: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
415: THEN
416: RAISE FND_API.G_EXC_ERROR;
417: END IF;
418:

Line 416: RAISE FND_API.G_EXC_ERROR;

412: x_return_status := fnd_api.g_ret_sts_success;
413: --Standard Call to check API compatibility
414: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
415: THEN
416: RAISE FND_API.G_EXC_ERROR;
417: END IF;
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)

Line 420: IF FND_API.To_boolean(P_INIT_MSG_LIST)

416: RAISE FND_API.G_EXC_ERROR;
417: END IF;
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:

Line 486: ,p_commit => FND_API.g_false

482: CS_SR_SECURITY_GRP.validate_resource
483: (
484: p_api_version => :5
485: ,p_init_msg_list => :6
486: ,p_commit => FND_API.g_false
487: ,p_sr_rec => l_sr_rec
488: ,px_resource_tbl => l_sr_resource_tbl
489: ,x_return_status => l_return_status
490: ,x_msg_count => l_msg_count

Line 498: IF NOT (l_return_status = fnd_api.g_ret_sts_success) THEN

494: :7 := l_msg_count;
495: :8 := l_msg_data;
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

Line 502: IF (l_return_status = fnd_api.g_ret_sts_error) THEN

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;
506: END IF;

Line 503: RAISE fnd_api.g_exc_error;

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;
506: END IF;
507: END IF;

Line 505: RAISE fnd_api.g_exc_unexpected_error;

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;
506: END IF;
507: END IF;
508:
509: --assign values to out tables

Line 582: WHEN fnd_api.g_exc_unexpected_error

578: END IF; -- end of check for count in x_assign_resources_tbl
579:
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

Line 585: WHEN fnd_api.g_exc_error

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
589: THEN

Line 595: x_return_status := fnd_api.g_ret_sts_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;
599: