DBA Data[Home] [Help]

APPS.WMS_RULE_PVT_EXT_PSETJ dependencies on FND_API

Line 79: x_return_status := fnd_api.g_ret_sts_success;

75: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
76: END IF;
77: l_debug := g_debug;
78: -- Initialize API return status to success
79: x_return_status := fnd_api.g_ret_sts_success;
80:
81: if (l_debug = 1) then
82: trace(' Entering procedure update_mmtt '|| to_char(sysdate, 'YYYY-MM-DD HH:DD:SS'), 1);
83: trace( ' p_task_id => ' || p_task_id

Line 102: x_return_status := fnd_api.g_ret_sts_error;

98: end if;
99: exception
100: when others then
101: -- Update return status.
102: x_return_status := fnd_api.g_ret_sts_error;
103:
104: if (l_debug =1) then
105: trace(' Unable to update MMTT due to Error : ' || sqlerrm(sqlcode), 1);
106: trace(' Exiting procedure update_mmtt '|| to_char(sysdate, 'YYYY-MM-DD HH:DD:SS'), 1);

Line 339: if not fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) then

335: IF l_debug = 1 THEN
336: trace(' Task ID passed to the inner call is ' || p_task_id, 1);
337: END IF;
338: -- ### Standard call to check for call compatibility
339: if not fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) then
340: raise fnd_api.g_exc_unexpected_error;
341: end if;
342:
343: -- ### Initialize message list if p_init_msg_list is set to TRUE

Line 340: raise fnd_api.g_exc_unexpected_error;

336: trace(' Task ID passed to the inner call is ' || p_task_id, 1);
337: END IF;
338: -- ### Standard call to check for call compatibility
339: if not fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) then
340: raise fnd_api.g_exc_unexpected_error;
341: end if;
342:
343: -- ### Initialize message list if p_init_msg_list is set to TRUE
344: if p_init_msg_list = 'G_TRUE' then

Line 350: x_return_status := fnd_api.g_ret_sts_success;

346: end if;
347:
348: --
349: -- ### Initialize API return status to success
350: x_return_status := fnd_api.g_ret_sts_success;
351:
352: -- ### Validate input parameters and pre-requisites, if validation level
353: -- ### requires this
354: if p_validation_level <> fnd_api.g_valid_level_none then

Line 354: if p_validation_level <> fnd_api.g_valid_level_none then

350: x_return_status := fnd_api.g_ret_sts_success;
351:
352: -- ### Validate input parameters and pre-requisites, if validation level
353: -- ### requires this
354: if p_validation_level <> fnd_api.g_valid_level_none then
355: -- in case further needs for validation
356: null;
357: end if;
358:

Line 673: when fnd_api.g_exc_error then

669: -- return;
670: end if;
671:
672: EXCEPTION
673: when fnd_api.g_exc_error then
674:
675: rollback to assign_operation_plan_sp;
676: -- @@@ wms_rule_pvt.freeglobals;
677: x_return_status := fnd_api.g_ret_sts_error;

Line 677: x_return_status := fnd_api.g_ret_sts_error;

673: when fnd_api.g_exc_error then
674:
675: rollback to assign_operation_plan_sp;
676: -- @@@ wms_rule_pvt.freeglobals;
677: x_return_status := fnd_api.g_ret_sts_error;
678:
679: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
680: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
681: end if;

Line 700: x_return_status := fnd_api.g_ret_sts_unexp_error;

696: end if;
697:
698:
699: rollback to assign_operation_plan_sp;
700: x_return_status := fnd_api.g_ret_sts_unexp_error;
701:
702: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
703: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
704: end if;