APPS.WMS_ATF_DESTINATION_LPN dependencies on FND_API

Line 525: x_return_status := FND_API.G_RET_STS_SUCCESS;

521: -- ### End of Cursor and Variable Declaration section
522: --
523: begin
524: -- ### Initialize API return status to success
525: x_return_status := FND_API.G_RET_STS_SUCCESS;
526:
527: -- ### Initialize message stack since p_init_msg_list is set to TRUE
528: -- ### The p_init_msg_list is set to 'TRUE' in this code and so the message stack will always be initialised.
529: -- if fnd_api.to_boolean(p_init_msg_list) then

Line 529: -- if fnd_api.to_boolean(p_init_msg_list) then

525: x_return_status := FND_API.G_RET_STS_SUCCESS;
526:
527: -- ### Initialize message stack since p_init_msg_list is set to TRUE
528: -- ### The p_init_msg_list is set to 'TRUE' in this code and so the message stack will always be initialised.
529: -- if fnd_api.to_boolean(p_init_msg_list) then
530: -- fnd_msg_pub.initialize;
531: -- end if;
532:
533: l_prog := 10;

Line 558: raise fnd_api.g_exc_error; -- Added after Code Review on Sept 11th 2003.

554: if c_oper_plan_details%NOTFOUND
555: then
556: fnd_message.set_name('WMS', 'WMS_OPERTN_PLAN_ID_INVALID');
557: fnd_msg_pub.ADD;
558: raise fnd_api.g_exc_error; -- Added after Code Review on Sept 11th 2003.
559: else
560: -- ### Print values detived from teh cursor in nthe log file.
561: if (l_debug = 1) then
562: trace(l_proc || ' Printing Operation Plan Detail Information...');

Line 587: raise fnd_api.g_exc_error; -- Added after Code Review on Sept 11th 2003.

583: -- ### are that either there is a value which is valid or a null value. Hence check only for null.
584: if l_lpn_mtrl_grp_rule_id is null then
585: fnd_message.set_name('WMS', 'WMS_MTRL_GRP_RULE_ID_IS_NULL');
586: fnd_msg_pub.ADD;
587: raise fnd_api.g_exc_error; -- Added after Code Review on Sept 11th 2003.
588: end if;
589: end if;
590:
591: l_prog := 20;

Line 907: when fnd_api.g_exc_error then

903: end if;
904:
905:
906: exception
907: when fnd_api.g_exc_error then
908: x_return_status := fnd_api.g_ret_sts_error;
909:
910: if (l_debug = 1) then
911: trace(' Progress at the time of failure is ' || l_prog, 1);

Line 908: x_return_status := fnd_api.g_ret_sts_error;

904:
905:
906: exception
907: when fnd_api.g_exc_error then
908: x_return_status := fnd_api.g_ret_sts_error;
909:
910: if (l_debug = 1) then
911: trace(' Progress at the time of failure is ' || l_prog, 1);
912: trace(' Error Code, Error Message...' || sqlerrm(sqlcode), 1);