DBA Data[Home] [Help]

APPS.GMF_PERIODCLOSE_PUB dependencies on FND_API

Line 59: IF NOT FND_API.Compatible_API_Call

55: Log_Msg(C_LOG_FILE, 'Parameters: Api Version: ' || p_api_version||' org id :'||p_org_id ||
56: ' Closing period :' ||p_closing_period||' Schedule Close date: '||
57: TO_CHAR(p_sched_close_date,'yyyy/mm/dd hh24:mi:ss'));
58: -- Check for call compatibility
59: IF NOT FND_API.Compatible_API_Call
60: ( p_current_version_number => l_api_version,
61: p_caller_version_number => p_api_version,
62: p_api_name => l_api_name,
63: p_pkg_name => G_PKG_NAME

Line 66: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

62: p_api_name => l_api_name,
63: p_pkg_name => G_PKG_NAME
64: )
65: THEN
66: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
67: END IF;
68:
69: -- Check for message level threshold
70: l_msg_level_threshold := FND_PROFILE.Value('FND_AS_MSG_LEVEL_THRESHOLD');

Line 88: l_return_status := fnd_api.g_ret_sts_success;

84: )
85: );
86: END IF;
87:
88: l_return_status := fnd_api.g_ret_sts_success;
89: l_msg_count := 0;
90: l_msg_data := '';
91:
92: l_stmt_num := 5;

Line 184: IF l_return_status <> FND_API.g_ret_sts_success THEN

180: x_msg_count => l_msg_count,
181: x_msg_data => l_msg_data);
182: Log_Msg(C_LOG_FILE, 'Completed WSH_INTEGRATION.Get_Untrxd_Shpg_Lines_Count.. ');
183:
184: IF l_return_status <> FND_API.g_ret_sts_success THEN
185: x_pending_ship := -1;
186: END IF;
187:
188: x_pending_ship := l_out_rec_type.untrxd_rec_count;

Line 301: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

297: x_uncost_prod_batches := -1;
298: END;
299: */
300: EXCEPTION
301: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
302: ROLLBACK TO Get_PendingTcount_PUB;
303: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
304: WHEN OTHERS THEN
305: ROLLBACK TO Get_PendingTcount_PUB;

Line 303: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

299: */
300: EXCEPTION
301: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
302: ROLLBACK TO Get_PendingTcount_PUB;
303: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
304: WHEN OTHERS THEN
305: ROLLBACK TO Get_PendingTcount_PUB;
306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
307: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

302: ROLLBACK TO Get_PendingTcount_PUB;
303: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
304: WHEN OTHERS THEN
305: ROLLBACK TO Get_PendingTcount_PUB;
306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
307: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
308: THEN
309: FND_MSG_PUB.Add_Exc_Msg(
310: p_pkg_name => G_PKG_NAME,

Line 400: IF NOT FND_API.Compatible_API_Call

396: Log_Msg(C_LOG_FILE, 'Parameters: Api Version: ' || p_api_version||' org id :'||p_org_id ||
397: ' Closing Acct period :' ||p_closing_acct_period_id||' Closing End date: '||
398: TO_CHAR(p_closing_end_date ,'yyyy/mm/dd hh24:mi:ss'));
399: -- Check for call compatibility
400: IF NOT FND_API.Compatible_API_Call
401: ( p_current_version_number => l_api_version,
402: p_caller_version_number => p_api_version,
403: p_api_name => l_api_name,
404: p_pkg_name => G_PKG_NAME

Line 407: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

403: p_api_name => l_api_name,
404: p_pkg_name => G_PKG_NAME
405: )
406: THEN
407: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
408: END IF;
409:
410: -- Check for message level threshold
411: l_msg_level_threshold := FND_PROFILE.Value('FND_AS_MSG_LEVEL_THRESHOLD');

Line 512: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

508: <>
509: NULL;
510:
511: EXCEPTION
512: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
513: ROLLBACK TO Verify_PeriodClose_PUB;
514: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
515: WHEN OTHERS THEN
516: ROLLBACK TO Verify_PeriodClose_PUB;

Line 514: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

510:
511: EXCEPTION
512: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
513: ROLLBACK TO Verify_PeriodClose_PUB;
514: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
515: WHEN OTHERS THEN
516: ROLLBACK TO Verify_PeriodClose_PUB;
517: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
518: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 517: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

513: ROLLBACK TO Verify_PeriodClose_PUB;
514: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
515: WHEN OTHERS THEN
516: ROLLBACK TO Verify_PeriodClose_PUB;
517: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
518: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
519: THEN
520: FND_MSG_PUB.Add_Exc_Msg(
521: p_pkg_name => G_PKG_NAME,

Line 574: IF NOT FND_API.Compatible_API_Call

570: TO_CHAR(p_period_close_date ,'yyyy/mm/dd hh24:mi:ss')||' Schedule Close date: '||
571: TO_CHAR(p_schedule_close_date ,'yyyy/mm/dd hh24:mi:ss'));
572:
573: -- Check for call compatibility
574: IF NOT FND_API.Compatible_API_Call
575: ( p_current_version_number => l_api_version,
576: p_caller_version_number => p_api_version,
577: p_api_name => l_api_name,
578: p_pkg_name => G_PKG_NAME

Line 581: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

577: p_api_name => l_api_name,
578: p_pkg_name => G_PKG_NAME
579: )
580: THEN
581: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
582: END IF;
583:
584: -- Check for message level threshold
585: l_msg_level_threshold := FND_PROFILE.Value('FND_AS_MSG_LEVEL_THRESHOLD');

Line 662: x_return_status := FND_API.G_RET_STS_ERROR;

658: EXCEPTION
659: WHEN e_perbal_failed THEN
660: /* rseshadr */
661: ROLLBACK TO Close_Period_PUB;
662: x_return_status := FND_API.G_RET_STS_ERROR;
663: x_close_failed := TRUE;
664:
665: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
666: ROLLBACK TO Close_Period_PUB;

Line 665: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

661: ROLLBACK TO Close_Period_PUB;
662: x_return_status := FND_API.G_RET_STS_ERROR;
663: x_close_failed := TRUE;
664:
665: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
666: ROLLBACK TO Close_Period_PUB;
667: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
668: x_close_failed := TRUE;
669:

Line 667: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

663: x_close_failed := TRUE;
664:
665: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
666: ROLLBACK TO Close_Period_PUB;
667: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
668: x_close_failed := TRUE;
669:
670: WHEN NO_DATA_FOUND THEN
671: ROLLBACK TO Close_Period_PUB;

Line 676: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

672: x_close_failed := TRUE;
673:
674: WHEN OTHERS THEN
675: ROLLBACK TO Close_Period_PUB;
676: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
677: x_close_failed := TRUE;
678: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
679: THEN
680: FND_MSG_PUB.Add_Exc_Msg(