APPS.WMS_ATF_DEST_LOC dependencies on FND_API

Line 1483: x_return_status := FND_API.G_RET_STS_SUCCESS;

1479: --
1480: --
1481: begin
1482: -- ### Initialize API return status to success
1483: x_return_status := FND_API.G_RET_STS_SUCCESS;
1484:
1485: -- Initialize message stack since p_init_msg_list is set to TRUE
1486: -- The p_init_msg_list is set to 'TRUE' in this code and so the message stack will always be initialised.
1487: --if fnd_api.to_boolean(p_init_msg_list) then

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

1483: x_return_status := FND_API.G_RET_STS_SUCCESS;
1484:
1485: -- Initialize message stack since p_init_msg_list is set to TRUE
1486: -- The p_init_msg_list is set to 'TRUE' in this code and so the message stack will always be initialised.
1487: --if fnd_api.to_boolean(p_init_msg_list) then
1488: -- fnd_msg_pub.initialize;
1489: --end if;
1490:
1491: if (l_debug = 1) then

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

1521:
1522: if c_oper_plan_details%NOTFOUND then
1523: fnd_message.set_name('WMS', 'WMS_OPERTN_PLAN_ID_INVALID');
1524: fnd_msg_pub.ADD;
1525: raise fnd_api.g_exc_error; -- Added after Code Review on Sept 11th 2003.
1526: else
1527: if (l_debug = 1) then
1528: trace(l_proc || ' Operation Plan ID => ' || nvl(l_operation_plan_id, -99));
1529: trace(l_proc || ' Locator ID => ' || nvl(l_locator_id, -99));

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

1555: if (l_loc_mtrl_grp_rule_id not in (1,2,3)) then
1556: trace('Incorrect Material Group ID stamped on the operation plan detail line ... Cannot Proceed');
1557: fnd_message.set_name('WMS', 'WMS_MTRL_GRP_RULE_ID_IS_NULL');
1558: fnd_msg_pub.ADD;
1559: raise fnd_api.g_exc_error; -- Added after Code Review on Sept 11th 2003.
1560: end if;
1561: -- ### Added after review with Amin on Oct 3rd 2003.
1562: -- ### Check to make sure for valid data.
1563: -- ### Changes effected Oct. 6th 2003.

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

1572: if (l_is_in_inventory not in ('Y','N')) then
1573: trace('Incorrect is_in_inventory flag stamped on the operation plan detail line ... Cannot Proceed');
1574: fnd_message.set_name('WMS', 'WMS_INVALID_ISININVFLAG');
1575: fnd_msg_pub.ADD;
1576: raise fnd_api.g_exc_error; -- Added after Code Review on Sept 11th 2003.
1577: end if;
1578: end if;
1579:
1580: l_prog := 20;

Line 2665: when fnd_api.g_exc_error then

2661: end if;
2662: end if;
2663:
2664: exception
2665: when fnd_api.g_exc_error then
2666: x_return_status := fnd_api.g_ret_sts_error;
2667:
2668: if (l_debug = 1) then
2669: trace(' Progress at the time of failure is ' || l_prog, 1);

Line 2666: x_return_status := fnd_api.g_ret_sts_error;

2662: end if;
2663:
2664: exception
2665: when fnd_api.g_exc_error then
2666: x_return_status := fnd_api.g_ret_sts_error;
2667:
2668: if (l_debug = 1) then
2669: trace(' Progress at the time of failure is ' || l_prog, 1);
2670: trace(' Error Code, Error Message...' || sqlerrm(sqlcode), 1);

Line 2730: x_return_status := fnd_api.g_ret_sts_error;

2726: , x_loc_valid => x_loc_valid
2727: , l_proc => l_proc);
2728:
2729: when others then
2730: x_return_status := fnd_api.g_ret_sts_error;
2731: if (l_debug = 1) then
2732: trace(' Progress at the time of failure is ' || l_prog, 1);
2733: trace(' Error Code, Error Message...' || sqlerrm(sqlcode), 1);
2734: end if;