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.

[Home] [Help]

APPS.WMS_STRATEGY_PVT dependencies on FND_API

Line 255: x_return_status := fnd_api.g_ret_sts_success;

251: If (l_debug = 1) then
252: log_procedure(l_api_name,'start', 'start InitInput');
253: End if;
254: -- Initialize API return status to success
255: x_return_status := fnd_api.g_ret_sts_success;
256: If l_debug = 1 THEN
257: log_procedure(l_api_name,'start', 'p_type_code '||p_type_code);
258: log_procedure(l_api_name,'start', 'p_transaction_temp_id '||p_transaction_temp_id);
259: END IF;

Line 479: x_return_status := fnd_api.g_ret_sts_unexp_error;

475: end if; */
476: if inpline%isopen then
477: close inpline;
478: end if;
479: x_return_status := fnd_api.g_ret_sts_unexp_error;
480: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
481: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
482: end if;
483: fnd_msg_pub.count_and_get( p_count => x_msg_count

Line 552: x_return_status := fnd_api.g_ret_sts_success;

548: log_procedure(l_api_name, 'start', 'Start InitStrategyRules');
549: End if;
550: -- nothing to init if p_strategy_id is null (no rule detailing)
551: IF p_strategy_id IS NULL THEN
552: x_return_status := fnd_api.g_ret_sts_success;
553: RETURN;
554: END IF;
555: /*--
556: --

Line 565: x_return_status := fnd_api.g_ret_sts_success;

561: END IF;
562: -- end of debugging section
563: -- */
564: -- Initialize API return status to success
565: x_return_status := fnd_api.g_ret_sts_success;
566:
567: -- Initialize local input line counter
568: l_rule_counter := 0;
569:

Line 640: x_return_status := fnd_api.g_ret_sts_unexp_error;

636: -- */
637: if rules%isopen then
638: close rules;
639: end if;
640: x_return_status := fnd_api.g_ret_sts_unexp_error;
641: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
642: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
643: end if;
644: fnd_msg_pub.count_and_get( p_count => x_msg_count

Line 786: --,p_init_msg_list => fnd_api.g_false

782:
783: INV_Quantity_Tree_PVT.Create_Tree
784: (
785: p_api_version_number => g_qty_tree_api_version
786: --,p_init_msg_list => fnd_api.g_false
787: ,x_return_status => x_return_status
788: ,x_msg_count => x_msg_count
789: ,x_msg_data => x_msg_data
790: ,p_organization_id => p_organization_id

Line 841: x_return_status := fnd_api.g_ret_sts_unexp_error;

837: -- */
838: if iteminfo%isopen then
839: close iteminfo;
840: end if;
841: x_return_status := fnd_api.g_ret_sts_unexp_error;
842: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
843: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
844: end if;
845: fnd_msg_pub.count_and_get( p_count => x_msg_count

Line 898: -- p_init_msg_list in varchar2 optional default = fnd_api.g_false

894: -- identified by parameters p_transaction_temp_id and
895: -- p_type_code ( base table MTL_MATERIAL_TRANSACTIONS_TEMP )
896: -- Parameters :
897: -- p_api_version in number required
898: -- p_init_msg_list in varchar2 optional default = fnd_api.g_false
899: -- p_validation_level in number optional default =
900: -- fnd_api.g_valid_level_full
901: -- x_return_status out varchar2(1)
902: -- x_msg_count out number

Line 900: -- fnd_api.g_valid_level_full

896: -- Parameters :
897: -- p_api_version in number required
898: -- p_init_msg_list in varchar2 optional default = fnd_api.g_false
899: -- p_validation_level in number optional default =
900: -- fnd_api.g_valid_level_full
901: -- x_return_status out varchar2(1)
902: -- x_msg_count out number
903: -- x_msg_data out varchar2(2000)
904: -- p_transaction_temp_id in number required default = NULL

Line 919: ,p_init_msg_list in varchar2 := fnd_api.g_false

915: -- End of comments
916:
917: procedure Search (
918: p_api_version in number
919: ,p_init_msg_list in varchar2 := fnd_api.g_false
920: ,p_validation_level in number := fnd_api.g_valid_level_full
921: ,x_return_status out NOCOPY varchar2
922: ,x_msg_count out NOCOPY number
923: ,x_msg_data out NOCOPY varchar2

Line 920: ,p_validation_level in number := fnd_api.g_valid_level_full

916:
917: procedure Search (
918: p_api_version in number
919: ,p_init_msg_list in varchar2 := fnd_api.g_false
920: ,p_validation_level in number := fnd_api.g_valid_level_full
921: ,x_return_status out NOCOPY varchar2
922: ,x_msg_count out NOCOPY number
923: ,x_msg_data out NOCOPY varchar2
924: ,p_transaction_temp_id in number := NULL

Line 1077: if not fnd_api.compatible_api_call( l_api_version

1073: END IF;
1074: -- end of debugging section
1075: -- */
1076: -- Standard call to check for call compatibility
1077: if not fnd_api.compatible_api_call( l_api_version
1078: ,p_api_version
1079: ,l_api_name
1080: ,g_pkg_name ) then
1081: raise fnd_api.g_exc_unexpected_error;

Line 1081: raise fnd_api.g_exc_unexpected_error;

1077: if not fnd_api.compatible_api_call( l_api_version
1078: ,p_api_version
1079: ,l_api_name
1080: ,g_pkg_name ) then
1081: raise fnd_api.g_exc_unexpected_error;
1082: end if;
1083:
1084: -- Initialize message list if p_init_msg_list is set to TRUE
1085: if fnd_api.to_boolean( p_init_msg_list ) then

Line 1085: if fnd_api.to_boolean( p_init_msg_list ) then

1081: raise fnd_api.g_exc_unexpected_error;
1082: end if;
1083:
1084: -- Initialize message list if p_init_msg_list is set to TRUE
1085: if fnd_api.to_boolean( p_init_msg_list ) then
1086: fnd_msg_pub.initialize;
1087: end if;
1088:
1089: -- Initialize API return status to success

Line 1090: x_return_status := fnd_api.g_ret_sts_success;

1086: fnd_msg_pub.initialize;
1087: end if;
1088:
1089: -- Initialize API return status to success
1090: x_return_status := fnd_api.g_ret_sts_success;
1091:
1092: -- Validate input parameters and pre-requisites, if validation level
1093: -- requires this
1094: if p_validation_level <> fnd_api.g_valid_level_none then

Line 1094: if p_validation_level <> fnd_api.g_valid_level_none then

1090: x_return_status := fnd_api.g_ret_sts_success;
1091:
1092: -- Validate input parameters and pre-requisites, if validation level
1093: -- requires this
1094: if p_validation_level <> fnd_api.g_valid_level_none then
1095: if p_transaction_temp_id is null or
1096: p_transaction_temp_id = fnd_api.g_miss_num then
1097: fnd_message.set_name('WMS','WMS_TRX_REQ_LINE_ID_MISS');
1098: fnd_msg_pub.add;

Line 1096: p_transaction_temp_id = fnd_api.g_miss_num then

1092: -- Validate input parameters and pre-requisites, if validation level
1093: -- requires this
1094: if p_validation_level <> fnd_api.g_valid_level_none then
1095: if p_transaction_temp_id is null or
1096: p_transaction_temp_id = fnd_api.g_miss_num then
1097: fnd_message.set_name('WMS','WMS_TRX_REQ_LINE_ID_MISS');
1098: fnd_msg_pub.add;
1099: If (l_debug = 1) then
1100: log_error_msg(l_api_name, 'missing_txn_temp_id');

Line 1102: raise fnd_api.g_exc_unexpected_error;

1098: fnd_msg_pub.add;
1099: If (l_debug = 1) then
1100: log_error_msg(l_api_name, 'missing_txn_temp_id');
1101: End if;
1102: raise fnd_api.g_exc_unexpected_error;
1103: end if;
1104: if p_type_code is null or
1105: p_type_code = fnd_api.g_miss_num then
1106: fnd_message.set_name('WMS','WMS_STRA_TYPE_CODE_MISS');

Line 1105: p_type_code = fnd_api.g_miss_num then

1101: End if;
1102: raise fnd_api.g_exc_unexpected_error;
1103: end if;
1104: if p_type_code is null or
1105: p_type_code = fnd_api.g_miss_num then
1106: fnd_message.set_name('WMS','WMS_STRA_TYPE_CODE_MISS');
1107: fnd_msg_pub.add;
1108: If (l_debug = 1) then
1109: log_error_msg(l_api_name, 'missing_type_code');

Line 1111: raise fnd_api.g_exc_unexpected_error;

1107: fnd_msg_pub.add;
1108: If (l_debug = 1) then
1109: log_error_msg(l_api_name, 'missing_type_code');
1110: End if;
1111: raise fnd_api.g_exc_unexpected_error;
1112: end if;
1113: end if;
1114:
1115: -- get actual inventory org to search for strategy

Line 1128: raise fnd_api.g_exc_unexpected_error;

1124: fnd_msg_pub.add;
1125: If (l_debug = 1) then
1126: log_error_msg(l_api_name, 'missing_org_id_cg');
1127: End if;
1128: raise fnd_api.g_exc_unexpected_error;
1129: end if;
1130: close cg_org;
1131: Else -- pick/put strategy
1132: open input;

Line 1141: raise fnd_api.g_exc_unexpected_error;

1137: fnd_msg_pub.add;
1138: If (l_debug = 1) then
1139: log_error_msg(l_api_name, 'missing_org_id_pp');
1140: End if;
1141: raise fnd_api.g_exc_unexpected_error;
1142: end if;
1143: close input;
1144: End If;
1145: ELSE

Line 1160: if x_return_status = fnd_api.g_ret_sts_success then

1156: ,p_type_code
1157: ,l_strategy_id
1158: );
1159: -- leave the actual procedure, if stub procedure already found a strategy
1160: if x_return_status = fnd_api.g_ret_sts_success then
1161: If (l_debug = 1) then
1162: log_event(l_api_name, 'custom_search',
1163: 'Strategy found using custom strategy search function. ' ||
1164: 'Strategy: ' || l_strategy_id);

Line 1169: elsif x_return_status = fnd_api.g_ret_sts_unexp_error then

1165: End if;
1166: x_strategy_id := l_strategy_id;
1167: return;
1168: -- leave the actual procedure, if stub procedure got an unexpected error
1169: elsif x_return_status = fnd_api.g_ret_sts_unexp_error then
1170: raise fnd_api.g_exc_unexpected_error;
1171: -- continue strategy search, if stub procedure didn't find strategy already
1172: elsif x_return_status = fnd_api.g_ret_sts_error then
1173: -- Re-Initialize API return status to success

Line 1170: raise fnd_api.g_exc_unexpected_error;

1166: x_strategy_id := l_strategy_id;
1167: return;
1168: -- leave the actual procedure, if stub procedure got an unexpected error
1169: elsif x_return_status = fnd_api.g_ret_sts_unexp_error then
1170: raise fnd_api.g_exc_unexpected_error;
1171: -- continue strategy search, if stub procedure didn't find strategy already
1172: elsif x_return_status = fnd_api.g_ret_sts_error then
1173: -- Re-Initialize API return status to success
1174: x_return_status := fnd_api.g_ret_sts_success;

Line 1172: elsif x_return_status = fnd_api.g_ret_sts_error then

1168: -- leave the actual procedure, if stub procedure got an unexpected error
1169: elsif x_return_status = fnd_api.g_ret_sts_unexp_error then
1170: raise fnd_api.g_exc_unexpected_error;
1171: -- continue strategy search, if stub procedure didn't find strategy already
1172: elsif x_return_status = fnd_api.g_ret_sts_error then
1173: -- Re-Initialize API return status to success
1174: x_return_status := fnd_api.g_ret_sts_success;
1175: -- every other return status seems to be unexpected: leave
1176: else

Line 1174: x_return_status := fnd_api.g_ret_sts_success;

1170: raise fnd_api.g_exc_unexpected_error;
1171: -- continue strategy search, if stub procedure didn't find strategy already
1172: elsif x_return_status = fnd_api.g_ret_sts_error then
1173: -- Re-Initialize API return status to success
1174: x_return_status := fnd_api.g_ret_sts_success;
1175: -- every other return status seems to be unexpected: leave
1176: else
1177: fnd_message.set_name('WMS','WMS_INVALID_RETURN_STATUS');
1178: -- WMS_re_Custom_PUB.SearchForStrategy returned wrong status

Line 1183: raise fnd_api.g_exc_unexpected_error;

1179: fnd_msg_pub.add;
1180: If (l_debug = 1) then
1181: log_error_msg(l_api_name, 'bad_return_status');
1182: End if;
1183: raise fnd_api.g_exc_unexpected_error;
1184: end if;
1185:
1186: --two different type codes at work here
1187: --p_type_code tells us which engine is calling this procedure

Line 1366: raise fnd_api.g_exc_unexpected_error;

1362: fnd_msg_pub.add;
1363: If (g_debug = 1) then
1364: log_error_msg(l_api_name, 'bad_db_object_chain');
1365: End if;
1366: raise fnd_api.g_exc_unexpected_error;
1367: end if;
1368:
1369: -- ----------------------------------------------------------------
1370: -- EXECUTE DYNAMIC SQL TO FIND STRATEGY

Line 1437: --raise fnd_api.g_exc_error;

1433: If (g_debug = 1) then
1434: log_event(l_api_name, 'no_hierarchy',
1435: 'No strategy search order defined for this organization');
1436: End if;
1437: --raise fnd_api.g_exc_error;
1438: end if;
1439: if l_strategy_id is null then
1440: fnd_message.set_name('WMS','WMS_NO_STRATEGY_ASSIGN');
1441: -- inv_pp_debug.send_message_to_pipe('no strategy assigned');

Line 1449: --raise fnd_api.g_exc_error;

1445: log_event(l_api_name, 'no_strategy',
1446: 'The strategy search function failed to find a valid ' ||
1447: 'strategy.');
1448: End if;
1449: --raise fnd_api.g_exc_error;
1450: IF p_type_code = 1 THEN
1451: wms_search_order_globals_pvt.g_putaway_strategy_id := -999;
1452: ELSIF p_type_code = 2 THEN
1453: wms_search_order_globals_pvt.g_pick_strategy_id := -999;

Line 1515: when fnd_api.g_exc_error then

1511:
1512: g_debug := NULL;
1513: --
1514: exception
1515: when fnd_api.g_exc_error then
1516: --
1517: -- debugging portion
1518: -- can be commented ut for final code
1519: IF inv_pp_debug.is_debug_mode THEN

Line 1534: x_return_status := fnd_api.g_ret_sts_error;

1530: END IF;
1531: -- end of debugging section
1532: --
1533: inv_sql_binding_pvt.InitBindTables;
1534: x_return_status := fnd_api.g_ret_sts_error;
1535: fnd_msg_pub.count_and_get( p_count => x_msg_count
1536: ,p_data => x_msg_data );
1537: If (g_debug = 1) then
1538: log_error(l_api_name, 'error', 'Error in Search - ' || x_msg_data);

Line 1543: when fnd_api.g_exc_unexpected_error then

1539: End if;
1540:
1541: g_debug := NULL;
1542:
1543: when fnd_api.g_exc_unexpected_error then
1544: --
1545: -- debugging portion
1546: -- can be commented ut for final code
1547: IF inv_pp_debug.is_debug_mode THEN

Line 1561: x_return_status := fnd_api.g_ret_sts_unexp_error;

1557: END IF;
1558: -- end of debugging section
1559: --
1560: inv_sql_binding_pvt.InitBindTables;
1561: x_return_status := fnd_api.g_ret_sts_unexp_error;
1562: fnd_msg_pub.count_and_get( p_count => x_msg_count
1563: ,p_data => x_msg_data );
1564: If (g_debug = 1) then
1565: log_error(l_api_name, 'unexp_error',

Line 1600: x_return_status := fnd_api.g_ret_sts_unexp_error;

1596: end if;
1597: if conditions%isopen then
1598: close conditions;
1599: end if;
1600: x_return_status := fnd_api.g_ret_sts_unexp_error;
1601: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
1602: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1603: end if;
1604: fnd_msg_pub.count_and_get( p_count => x_msg_count

Line 1670: l_return_status := FND_API.G_RET_STS_SUCCESS;

1666: BEGIN
1667: IF (l_debug = 1) THEN
1668: log_statement(l_api_name, 'Entering get_max_tolerance', '-------------------');
1669: END IF;
1670: l_return_status := FND_API.G_RET_STS_SUCCESS;
1671: l_mo_quantity := WMS_Engine_PVT.g_mo_quantity;
1672: l_mo_sec_qty := WMS_Engine_PVT.g_mo_sec_qty;
1673:
1674: -- l_other_alloc is sum of allocation for all MO except current MO, with same p_trx_source_line_id

Line 1779: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1775: log_statement(l_api_name, 'l_max_sec_qty ' , l_max_sec_qty);
1776: log_statement(l_api_name, 'l_avail_req_qty ', l_avail_req_qty);
1777: log_statement(l_api_name, 'l_avail_req_sec_qty ', l_avail_req_sec_qty);
1778: END IF;
1779: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1780: RAISE FND_API.G_EXC_ERROR;
1781: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1782: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1783: END IF;

Line 1780: RAISE FND_API.G_EXC_ERROR;

1776: log_statement(l_api_name, 'l_avail_req_qty ', l_avail_req_qty);
1777: log_statement(l_api_name, 'l_avail_req_sec_qty ', l_avail_req_sec_qty);
1778: END IF;
1779: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1780: RAISE FND_API.G_EXC_ERROR;
1781: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1782: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1783: END IF;
1784:

Line 1781: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1777: log_statement(l_api_name, 'l_avail_req_sec_qty ', l_avail_req_sec_qty);
1778: END IF;
1779: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1780: RAISE FND_API.G_EXC_ERROR;
1781: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1782: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1783: END IF;
1784:
1785: -- l_cur_mo_alloc is any existing allocation for the current MO

Line 1782: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1778: END IF;
1779: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1780: RAISE FND_API.G_EXC_ERROR;
1781: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1782: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1783: END IF;
1784:
1785: -- l_cur_mo_alloc is any existing allocation for the current MO
1786: SELECT NVL(SUM(transaction_quantity), 0)

Line 1846: WHEN FND_API.G_EXC_ERROR THEN

1842: IF (l_debug = 1) THEN
1843: log_statement(l_api_name, 'Exiting get_max_tolerance', '--------------------');
1844: END IF;
1845: EXCEPTION
1846: WHEN FND_API.G_EXC_ERROR THEN
1847: x_return_status := FND_API.G_RET_STS_ERROR;
1848: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1849: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1850: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1847: x_return_status := FND_API.G_RET_STS_ERROR;

1843: log_statement(l_api_name, 'Exiting get_max_tolerance', '--------------------');
1844: END IF;
1845: EXCEPTION
1846: WHEN FND_API.G_EXC_ERROR THEN
1847: x_return_status := FND_API.G_RET_STS_ERROR;
1848: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1849: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1850: x_return_status := FND_API.G_RET_STS_ERROR;
1851: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 1849: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1845: EXCEPTION
1846: WHEN FND_API.G_EXC_ERROR THEN
1847: x_return_status := FND_API.G_RET_STS_ERROR;
1848: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1849: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1850: x_return_status := FND_API.G_RET_STS_ERROR;
1851: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1852: WHEN OTHERS THEN
1853: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1850: x_return_status := FND_API.G_RET_STS_ERROR;

1846: WHEN FND_API.G_EXC_ERROR THEN
1847: x_return_status := FND_API.G_RET_STS_ERROR;
1848: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1849: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1850: x_return_status := FND_API.G_RET_STS_ERROR;
1851: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1852: WHEN OTHERS THEN
1853: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1854: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 1853: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1849: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1850: x_return_status := FND_API.G_RET_STS_ERROR;
1851: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1852: WHEN OTHERS THEN
1853: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1854: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1855: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1856: END IF;
1857: END get_max_tolerance;

Line 1879: -- p_init_msg_list in varchar2 optional default = fnd_api.g_false

1875: -- WMS_STRATEGY_MEMBERS identified by parameter
1876: -- p_strategy_id
1877: -- Parameters :
1878: -- p_api_version in number required
1879: -- p_init_msg_list in varchar2 optional default = fnd_api.g_false
1880: -- p_commit in varchar2 optional default = fnd_api.g_false
1881: -- p_validation_level in number optional default =
1882: -- fnd_api.g_valid_level_full
1883: -- x_return_status out varchar2(1)

Line 1880: -- p_commit in varchar2 optional default = fnd_api.g_false

1876: -- p_strategy_id
1877: -- Parameters :
1878: -- p_api_version in number required
1879: -- p_init_msg_list in varchar2 optional default = fnd_api.g_false
1880: -- p_commit in varchar2 optional default = fnd_api.g_false
1881: -- p_validation_level in number optional default =
1882: -- fnd_api.g_valid_level_full
1883: -- x_return_status out varchar2(1)
1884: -- x_msg_count out number

Line 1882: -- fnd_api.g_valid_level_full

1878: -- p_api_version in number required
1879: -- p_init_msg_list in varchar2 optional default = fnd_api.g_false
1880: -- p_commit in varchar2 optional default = fnd_api.g_false
1881: -- p_validation_level in number optional default =
1882: -- fnd_api.g_valid_level_full
1883: -- x_return_status out varchar2(1)
1884: -- x_msg_count out number
1885: -- x_msg_data out varchar2(2000)
1886: -- p_transaction_temp_id in number required default = NULL

Line 1907: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

1903: -- End of comments
1904:
1905: procedure Apply (
1906: p_api_version IN NUMBER
1907: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1908: ,p_commit IN VARCHAR2 := fnd_api.g_false
1909: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
1910: ,x_return_status OUT NOCOPY VARCHAR2
1911: ,x_msg_count OUT NOCOPY NUMBER

Line 1908: ,p_commit IN VARCHAR2 := fnd_api.g_false

1904:
1905: procedure Apply (
1906: p_api_version IN NUMBER
1907: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1908: ,p_commit IN VARCHAR2 := fnd_api.g_false
1909: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
1910: ,x_return_status OUT NOCOPY VARCHAR2
1911: ,x_msg_count OUT NOCOPY NUMBER
1912: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1909: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full

1905: procedure Apply (
1906: p_api_version IN NUMBER
1907: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1908: ,p_commit IN VARCHAR2 := fnd_api.g_false
1909: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
1910: ,x_return_status OUT NOCOPY VARCHAR2
1911: ,x_msg_count OUT NOCOPY NUMBER
1912: ,x_msg_data OUT NOCOPY VARCHAR2
1913: ,p_transaction_temp_id IN NUMBER := NULL

Line 2045: if not fnd_api.compatible_api_call( l_api_version

2041: -- Standard start of API savepoint
2042: savepoint ApplyStrategySP;
2043:
2044: -- Standard call to check for call compatibility
2045: if not fnd_api.compatible_api_call( l_api_version
2046: ,p_api_version
2047: ,l_api_name
2048: ,g_pkg_name ) then
2049: raise fnd_api.g_exc_unexpected_error;

Line 2049: raise fnd_api.g_exc_unexpected_error;

2045: if not fnd_api.compatible_api_call( l_api_version
2046: ,p_api_version
2047: ,l_api_name
2048: ,g_pkg_name ) then
2049: raise fnd_api.g_exc_unexpected_error;
2050: end if;
2051:
2052: -- Initialize message list if p_init_msg_list is set to TRUE
2053: if fnd_api.to_boolean( p_init_msg_list ) then

Line 2053: if fnd_api.to_boolean( p_init_msg_list ) then

2049: raise fnd_api.g_exc_unexpected_error;
2050: end if;
2051:
2052: -- Initialize message list if p_init_msg_list is set to TRUE
2053: if fnd_api.to_boolean( p_init_msg_list ) then
2054: fnd_msg_pub.initialize;
2055: end if;
2056:
2057: -- Initialize API return status to success

Line 2058: x_return_status := fnd_api.g_ret_sts_success;

2054: fnd_msg_pub.initialize;
2055: end if;
2056:
2057: -- Initialize API return status to success
2058: x_return_status := fnd_api.g_ret_sts_success;
2059:
2060: -- Initialize functional return status to 'missing'
2061: --l_finished := fnd_api.g_miss_char; --bug 3673962
2062: l_finished := fnd_api.g_false; --bug3673962

Line 2061: --l_finished := fnd_api.g_miss_char; --bug 3673962

2057: -- Initialize API return status to success
2058: x_return_status := fnd_api.g_ret_sts_success;
2059:
2060: -- Initialize functional return status to 'missing'
2061: --l_finished := fnd_api.g_miss_char; --bug 3673962
2062: l_finished := fnd_api.g_false; --bug3673962
2063:
2064: -- Validate input parameters and pre-requisites, if validation level
2065: -- requires this

Line 2062: l_finished := fnd_api.g_false; --bug3673962

2058: x_return_status := fnd_api.g_ret_sts_success;
2059:
2060: -- Initialize functional return status to 'missing'
2061: --l_finished := fnd_api.g_miss_char; --bug 3673962
2062: l_finished := fnd_api.g_false; --bug3673962
2063:
2064: -- Validate input parameters and pre-requisites, if validation level
2065: -- requires this
2066: if p_validation_level <> fnd_api.g_valid_level_none then

Line 2066: if p_validation_level <> fnd_api.g_valid_level_none then

2062: l_finished := fnd_api.g_false; --bug3673962
2063:
2064: -- Validate input parameters and pre-requisites, if validation level
2065: -- requires this
2066: if p_validation_level <> fnd_api.g_valid_level_none then
2067: if p_transaction_temp_id is null or
2068: p_transaction_temp_id = fnd_api.g_miss_num
2069: then
2070: fnd_message.set_name('WMS','WMS_TRX_REQ_LINE_ID_MISS');

Line 2068: p_transaction_temp_id = fnd_api.g_miss_num

2064: -- Validate input parameters and pre-requisites, if validation level
2065: -- requires this
2066: if p_validation_level <> fnd_api.g_valid_level_none then
2067: if p_transaction_temp_id is null or
2068: p_transaction_temp_id = fnd_api.g_miss_num
2069: then
2070: fnd_message.set_name('WMS','WMS_TRX_REQ_LINE_ID_MISS');
2071: -- Transaction input identifier required but not provided
2072: fnd_msg_pub.add;

Line 2076: raise fnd_api.g_exc_unexpected_error;

2072: fnd_msg_pub.add;
2073: If (l_debug = 1) then
2074: log_error_msg(l_api_name,'missing_txn_temp_id');
2075: End if;
2076: raise fnd_api.g_exc_unexpected_error;
2077: end if;
2078: if p_type_code is null or
2079: p_type_code = fnd_api.g_miss_num
2080: then

Line 2079: p_type_code = fnd_api.g_miss_num

2075: End if;
2076: raise fnd_api.g_exc_unexpected_error;
2077: end if;
2078: if p_type_code is null or
2079: p_type_code = fnd_api.g_miss_num
2080: then
2081: fnd_message.set_name('WMS','WMS_STRA_TYPE_CODE_MISS');
2082: -- Strategy type code required but not provided
2083: fnd_msg_pub.add;

Line 2087: raise fnd_api.g_exc_unexpected_error;

2083: fnd_msg_pub.add;
2084: If (l_debug = 1) then
2085: log_error_msg(l_api_name,'missing_type_code');
2086: End if;
2087: raise fnd_api.g_exc_unexpected_error;
2088: end if;
2089: /* Strategy Id is no longer required
2090: if p_strategy_id is null or
2091: p_strategy_id = fnd_api.g_miss_num then

Line 2091: p_strategy_id = fnd_api.g_miss_num then

2087: raise fnd_api.g_exc_unexpected_error;
2088: end if;
2089: /* Strategy Id is no longer required
2090: if p_strategy_id is null or
2091: p_strategy_id = fnd_api.g_miss_num then
2092: fnd_message.set_name('WMS','WMS_STRATEGY_ID_MISSING');
2093: -- Strategy identifier required but not provided
2094: fnd_msg_pub.add;
2095: raise fnd_api.g_exc_unexpected_error;

Line 2095: raise fnd_api.g_exc_unexpected_error;

2091: p_strategy_id = fnd_api.g_miss_num then
2092: fnd_message.set_name('WMS','WMS_STRATEGY_ID_MISSING');
2093: -- Strategy identifier required but not provided
2094: fnd_msg_pub.add;
2095: raise fnd_api.g_exc_unexpected_error;
2096: end if;
2097: */
2098: end if;
2099:

Line 2148: if x_return_status = fnd_api.g_ret_sts_unexp_error then

2144: ,l_transaction_source_name
2145: ,l_transaction_type_id
2146: ,l_tree_mode
2147: );
2148: if x_return_status = fnd_api.g_ret_sts_unexp_error then
2149: raise fnd_api.g_exc_unexpected_error;
2150: elsif x_return_status = fnd_api.g_ret_sts_error then
2151: raise fnd_api.g_exc_error;
2152: end if;

Line 2149: raise fnd_api.g_exc_unexpected_error;

2145: ,l_transaction_type_id
2146: ,l_tree_mode
2147: );
2148: if x_return_status = fnd_api.g_ret_sts_unexp_error then
2149: raise fnd_api.g_exc_unexpected_error;
2150: elsif x_return_status = fnd_api.g_ret_sts_error then
2151: raise fnd_api.g_exc_error;
2152: end if;
2153:

Line 2150: elsif x_return_status = fnd_api.g_ret_sts_error then

2146: ,l_tree_mode
2147: );
2148: if x_return_status = fnd_api.g_ret_sts_unexp_error then
2149: raise fnd_api.g_exc_unexpected_error;
2150: elsif x_return_status = fnd_api.g_ret_sts_error then
2151: raise fnd_api.g_exc_error;
2152: end if;
2153:
2154: select NVL(WMS_ENABLED_FLAG, 'N') INTO l_wms_enabled_flag

Line 2151: raise fnd_api.g_exc_error;

2147: );
2148: if x_return_status = fnd_api.g_ret_sts_unexp_error then
2149: raise fnd_api.g_exc_unexpected_error;
2150: elsif x_return_status = fnd_api.g_ret_sts_error then
2151: raise fnd_api.g_exc_error;
2152: end if;
2153:
2154: select NVL(WMS_ENABLED_FLAG, 'N') INTO l_wms_enabled_flag
2155: from mtl_parameters

Line 2175: if x_return_status = fnd_api.g_ret_sts_unexp_error then

2171: ,l_transaction_source_name
2172: ,l_tree_mode
2173: ,l_tree_id
2174: );
2175: if x_return_status = fnd_api.g_ret_sts_unexp_error then
2176: raise fnd_api.g_exc_unexpected_error;
2177: elsif x_return_status = fnd_api.g_ret_sts_error then
2178: raise fnd_api.g_exc_error;
2179: end if;

Line 2176: raise fnd_api.g_exc_unexpected_error;

2172: ,l_tree_mode
2173: ,l_tree_id
2174: );
2175: if x_return_status = fnd_api.g_ret_sts_unexp_error then
2176: raise fnd_api.g_exc_unexpected_error;
2177: elsif x_return_status = fnd_api.g_ret_sts_error then
2178: raise fnd_api.g_exc_error;
2179: end if;
2180: end if;

Line 2177: elsif x_return_status = fnd_api.g_ret_sts_error then

2173: ,l_tree_id
2174: );
2175: if x_return_status = fnd_api.g_ret_sts_unexp_error then
2176: raise fnd_api.g_exc_unexpected_error;
2177: elsif x_return_status = fnd_api.g_ret_sts_error then
2178: raise fnd_api.g_exc_error;
2179: end if;
2180: end if;
2181: ---

Line 2178: raise fnd_api.g_exc_error;

2174: );
2175: if x_return_status = fnd_api.g_ret_sts_unexp_error then
2176: raise fnd_api.g_exc_unexpected_error;
2177: elsif x_return_status = fnd_api.g_ret_sts_error then
2178: raise fnd_api.g_exc_error;
2179: end if;
2180: end if;
2181: ---
2182:

Line 2199: , p_init_msg_list => fnd_api.g_false

2195: log_event(l_api_name, 'APPLY', 'WMS_RULES_PVT.Calling QuickPick() ');
2196: End if;
2197: WMS_Rule_PVT.QuickPick (
2198: p_api_version => g_pp_rule_api_version
2199: , p_init_msg_list => fnd_api.g_false
2200: , p_commit => fnd_api.g_false
2201: , p_validation_level => fnd_api.g_valid_level_full
2202: , x_return_status => x_return_status
2203: , x_msg_count => l_msg_count

Line 2200: , p_commit => fnd_api.g_false

2196: End if;
2197: WMS_Rule_PVT.QuickPick (
2198: p_api_version => g_pp_rule_api_version
2199: , p_init_msg_list => fnd_api.g_false
2200: , p_commit => fnd_api.g_false
2201: , p_validation_level => fnd_api.g_valid_level_full
2202: , x_return_status => x_return_status
2203: , x_msg_count => l_msg_count
2204: , x_msg_data => l_msg_data

Line 2201: , p_validation_level => fnd_api.g_valid_level_full

2197: WMS_Rule_PVT.QuickPick (
2198: p_api_version => g_pp_rule_api_version
2199: , p_init_msg_list => fnd_api.g_false
2200: , p_commit => fnd_api.g_false
2201: , p_validation_level => fnd_api.g_valid_level_full
2202: , x_return_status => x_return_status
2203: , x_msg_count => l_msg_count
2204: , x_msg_data => l_msg_data
2205: , p_type_code => p_type_code

Line 2232: IF x_return_status <> fnd_api.g_ret_sts_success THEN

2228: , p_project_id => p_project_id
2229: , p_task_id => p_task_id
2230: );
2231:
2232: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2233: raise fnd_api.g_exc_error;
2234: END IF;
2235: Else ---- Patchset H , I and non Invt. Moves
2236: log_event(l_api_name,'', 'no quick pick');

Line 2233: raise fnd_api.g_exc_error;

2229: , p_task_id => p_task_id
2230: );
2231:
2232: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2233: raise fnd_api.g_exc_error;
2234: END IF;
2235: Else ---- Patchset H , I and non Invt. Moves
2236: log_event(l_api_name,'', 'no quick pick');
2237: -- Initialize the internal rules table

Line 2243: if x_return_status = fnd_api.g_ret_sts_unexp_error then

2239: ,l_msg_count
2240: ,l_msg_data
2241: ,p_strategy_id );
2242:
2243: if x_return_status = fnd_api.g_ret_sts_unexp_error then
2244: raise fnd_api.g_exc_unexpected_error;
2245: elsif x_return_status = fnd_api.g_ret_sts_error then
2246: raise fnd_api.g_exc_error;
2247: end if;

Line 2244: raise fnd_api.g_exc_unexpected_error;

2240: ,l_msg_data
2241: ,p_strategy_id );
2242:
2243: if x_return_status = fnd_api.g_ret_sts_unexp_error then
2244: raise fnd_api.g_exc_unexpected_error;
2245: elsif x_return_status = fnd_api.g_ret_sts_error then
2246: raise fnd_api.g_exc_error;
2247: end if;
2248:

Line 2245: elsif x_return_status = fnd_api.g_ret_sts_error then

2241: ,p_strategy_id );
2242:
2243: if x_return_status = fnd_api.g_ret_sts_unexp_error then
2244: raise fnd_api.g_exc_unexpected_error;
2245: elsif x_return_status = fnd_api.g_ret_sts_error then
2246: raise fnd_api.g_exc_error;
2247: end if;
2248:
2249: log_event(l_api_name,'', 'after init strategyrules ');

Line 2246: raise fnd_api.g_exc_error;

2242:
2243: if x_return_status = fnd_api.g_ret_sts_unexp_error then
2244: raise fnd_api.g_exc_unexpected_error;
2245: elsif x_return_status = fnd_api.g_ret_sts_error then
2246: raise fnd_api.g_exc_error;
2247: end if;
2248:
2249: log_event(l_api_name,'', 'after init strategyrules ');
2250:

Line 2297: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

2293: log_statement(l_api_name, 'l_max_sec_tolerance is ', l_max_sec_tolerance);
2294: log_statement(l_api_name, 'x_return_status is ', x_return_status);
2295: END IF;
2296:
2297: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2298: IF l_debug = 1 THEN
2299: log_statement(l_api_name, 'get_max_tolerance', 'Unexpected error in get_max_tolerance Call');
2300: END IF;
2301: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

Line 2301: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

2297: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2298: IF l_debug = 1 THEN
2299: log_statement(l_api_name, 'get_max_tolerance', 'Unexpected error in get_max_tolerance Call');
2300: END IF;
2301: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
2302: IF l_debug = 1 THEN
2303: log_statement(l_api_name, 'get_max_tolerance', 'Error in get_max_tolerance Call');
2304: END IF;
2305: END IF;

Line 2340: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2336: x_return_status => x_return_status,
2337: x_msg_count => x_msg_count,
2338: x_msg_data => x_msg_data
2339: );
2340: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2341: IF l_debug = 1 THEN
2342: log_statement(l_api_name, 'get_max_tolerance', 'Unexpected error in get_max_tolerance Call');
2343: END IF;
2344: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 2344: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

2340: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2341: IF l_debug = 1 THEN
2342: log_statement(l_api_name, 'get_max_tolerance', 'Unexpected error in get_max_tolerance Call');
2343: END IF;
2344: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2345: IF l_debug = 1 THEN
2346: log_statement(l_api_name, 'get_max_tolerance', 'Error in get_max_tolerance Call');
2347: END IF;
2348: END IF;

Line 2419: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

2415: x_return_status => x_return_status,
2416: x_msg_count => x_msg_count,
2417: x_msg_data => x_msg_data
2418: );
2419: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2420: IF l_debug = 1 THEN
2421: log_statement(l_api_name, 'get_max_tolerance', 'Unexpected error in get_max_tolerance Call');
2422: END IF;
2423: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

Line 2423: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

2419: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2420: IF l_debug = 1 THEN
2421: log_statement(l_api_name, 'get_max_tolerance', 'Unexpected error in get_max_tolerance Call');
2422: END IF;
2423: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
2424: IF l_debug = 1 THEN
2425: log_statement(l_api_name, 'get_max_tolerance', 'Error in get_max_tolerance Call');
2426: END IF;
2427: END IF;

Line 2545: p_init_msg_list => fnd_api.g_false,

2541: END IF;
2542: WMS_rule_PVT.applydefloc
2543: (
2544: p_api_version => g_pp_rule_api_version,
2545: p_init_msg_list => fnd_api.g_false,
2546: p_commit => p_commit,
2547: p_validation_level => fnd_api.g_valid_level_none,
2548: x_return_status => x_return_status,
2549: x_msg_count => l_msg_count,

Line 2547: p_validation_level => fnd_api.g_valid_level_none,

2543: (
2544: p_api_version => g_pp_rule_api_version,
2545: p_init_msg_list => fnd_api.g_false,
2546: p_commit => p_commit,
2547: p_validation_level => fnd_api.g_valid_level_none,
2548: x_return_status => x_return_status,
2549: x_msg_count => l_msg_count,
2550: x_msg_data => l_msg_data,
2551: p_transaction_temp_id => p_transaction_temp_id,

Line 2571: , p_init_msg_list => fnd_api.g_false

2567: ElsIF p_simulation_mode = 10 THEN --mode is manual alloc
2568: log_event(l_api_name, 'APPLY()', 'get_availabe_inv ');
2569: WMS_Rule_PVT.get_available_inventory(
2570: p_api_version => g_pp_rule_api_version
2571: , p_init_msg_list => fnd_api.g_false
2572: , p_commit => fnd_api.g_false
2573: , p_validation_level => fnd_api.g_valid_level_full
2574: , x_return_status => x_return_status
2575: , x_msg_count => l_msg_count

Line 2572: , p_commit => fnd_api.g_false

2568: log_event(l_api_name, 'APPLY()', 'get_availabe_inv ');
2569: WMS_Rule_PVT.get_available_inventory(
2570: p_api_version => g_pp_rule_api_version
2571: , p_init_msg_list => fnd_api.g_false
2572: , p_commit => fnd_api.g_false
2573: , p_validation_level => fnd_api.g_valid_level_full
2574: , x_return_status => x_return_status
2575: , x_msg_count => l_msg_count
2576: , x_msg_data => l_msg_data

Line 2573: , p_validation_level => fnd_api.g_valid_level_full

2569: WMS_Rule_PVT.get_available_inventory(
2570: p_api_version => g_pp_rule_api_version
2571: , p_init_msg_list => fnd_api.g_false
2572: , p_commit => fnd_api.g_false
2573: , p_validation_level => fnd_api.g_valid_level_full
2574: , x_return_status => x_return_status
2575: , x_msg_count => l_msg_count
2576: , x_msg_data => l_msg_data
2577: , p_rule_id => l_rule_id

Line 2607: p_init_msg_lst => fnd_api.g_false,

2603:
2604: --bug#6867434 start
2605: INV_Quantity_Tree_PVT.release_lock(
2606: p_api_version_number => g_qty_tree_api_version,
2607: p_init_msg_lst => fnd_api.g_false,
2608: x_return_status => x_return_status,
2609: x_msg_count => l_msg_count,
2610: x_msg_data => l_msg_data,
2611: p_organization_id => l_organization_id,

Line 2645: , p_init_msg_list => fnd_api.g_false

2641: End If;
2642:
2643: WMS_Rule_PVT.Apply (
2644: p_api_version => g_pp_rule_api_version
2645: , p_init_msg_list => fnd_api.g_false
2646: , p_commit => fnd_api.g_false
2647: , p_validation_level => fnd_api.g_valid_level_full
2648: , x_return_status => x_return_status
2649: , x_msg_count => l_msg_count

Line 2646: , p_commit => fnd_api.g_false

2642:
2643: WMS_Rule_PVT.Apply (
2644: p_api_version => g_pp_rule_api_version
2645: , p_init_msg_list => fnd_api.g_false
2646: , p_commit => fnd_api.g_false
2647: , p_validation_level => fnd_api.g_valid_level_full
2648: , x_return_status => x_return_status
2649: , x_msg_count => l_msg_count
2650: , x_msg_data => l_msg_data

Line 2647: , p_validation_level => fnd_api.g_valid_level_full

2643: WMS_Rule_PVT.Apply (
2644: p_api_version => g_pp_rule_api_version
2645: , p_init_msg_list => fnd_api.g_false
2646: , p_commit => fnd_api.g_false
2647: , p_validation_level => fnd_api.g_valid_level_full
2648: , x_return_status => x_return_status
2649: , x_msg_count => l_msg_count
2650: , x_msg_data => l_msg_data
2651: , p_rule_id => l_rule_id

Line 2686: , p_init_msg_list => fnd_api.g_false

2682:
2683: log_event(l_api_name, 'APPLY()', 'rule apply ');
2684: WMS_Rule_PVT.Apply (
2685: p_api_version => g_pp_rule_api_version
2686: , p_init_msg_list => fnd_api.g_false
2687: , p_commit => fnd_api.g_false
2688: , p_validation_level => fnd_api.g_valid_level_full
2689: , x_return_status => x_return_status
2690: , x_msg_count => l_msg_count

Line 2687: , p_commit => fnd_api.g_false

2683: log_event(l_api_name, 'APPLY()', 'rule apply ');
2684: WMS_Rule_PVT.Apply (
2685: p_api_version => g_pp_rule_api_version
2686: , p_init_msg_list => fnd_api.g_false
2687: , p_commit => fnd_api.g_false
2688: , p_validation_level => fnd_api.g_valid_level_full
2689: , x_return_status => x_return_status
2690: , x_msg_count => l_msg_count
2691: , x_msg_data => l_msg_data

Line 2688: , p_validation_level => fnd_api.g_valid_level_full

2684: WMS_Rule_PVT.Apply (
2685: p_api_version => g_pp_rule_api_version
2686: , p_init_msg_list => fnd_api.g_false
2687: , p_commit => fnd_api.g_false
2688: , p_validation_level => fnd_api.g_valid_level_full
2689: , x_return_status => x_return_status
2690: , x_msg_count => l_msg_count
2691: , x_msg_data => l_msg_data
2692: , p_rule_id => l_rule_id

Line 2733: if x_return_status = fnd_api.g_ret_sts_unexp_error then

2729: wms_parameter_pvt.g_bulkCollect_Locator.DELETE;
2730: wms_parameter_pvt.g_bulkCollect_quantity.DELETE;
2731: -- end of Bug# 3413372
2732: END IF;
2733: if x_return_status = fnd_api.g_ret_sts_unexp_error then
2734: raise fnd_api.g_exc_unexpected_error;
2735: elsif x_return_status = fnd_api.g_ret_sts_error then
2736: raise fnd_api.g_exc_error;
2737: end if;

Line 2734: raise fnd_api.g_exc_unexpected_error;

2730: wms_parameter_pvt.g_bulkCollect_quantity.DELETE;
2731: -- end of Bug# 3413372
2732: END IF;
2733: if x_return_status = fnd_api.g_ret_sts_unexp_error then
2734: raise fnd_api.g_exc_unexpected_error;
2735: elsif x_return_status = fnd_api.g_ret_sts_error then
2736: raise fnd_api.g_exc_error;
2737: end if;
2738: END IF;

Line 2735: elsif x_return_status = fnd_api.g_ret_sts_error then

2731: -- end of Bug# 3413372
2732: END IF;
2733: if x_return_status = fnd_api.g_ret_sts_unexp_error then
2734: raise fnd_api.g_exc_unexpected_error;
2735: elsif x_return_status = fnd_api.g_ret_sts_error then
2736: raise fnd_api.g_exc_error;
2737: end if;
2738: END IF;
2739: if (l_debug = 1) then

Line 2736: raise fnd_api.g_exc_error;

2732: END IF;
2733: if x_return_status = fnd_api.g_ret_sts_unexp_error then
2734: raise fnd_api.g_exc_unexpected_error;
2735: elsif x_return_status = fnd_api.g_ret_sts_error then
2736: raise fnd_api.g_exc_error;
2737: end if;
2738: END IF;
2739: if (l_debug = 1) then
2740: log_statement(l_api_name, 'l_finished ', l_finished);

Line 2750: l_finished := fnd_api.g_false;

2746: and added following if condition
2747: */
2748:
2749: IF l_simulation_mode = 10 and p_strategy_id IS NOT NULL THEN
2750: l_finished := fnd_api.g_false;
2751: END IF;
2752:
2753: exit when fnd_api.to_boolean(l_finished) OR p_strategy_id IS NULL
2754: OR l_simulation_mode IN (2,4);

Line 2753: exit when fnd_api.to_boolean(l_finished) OR p_strategy_id IS NULL

2749: IF l_simulation_mode = 10 and p_strategy_id IS NOT NULL THEN
2750: l_finished := fnd_api.g_false;
2751: END IF;
2752:
2753: exit when fnd_api.to_boolean(l_finished) OR p_strategy_id IS NULL
2754: OR l_simulation_mode IN (2,4);
2755: end loop;
2756:
2757:

Line 2761: if fnd_api.to_boolean(p_commit) then

2757:
2758: END IF; -- end Patchset J changes
2759:
2760: -- Standard check of p_commit
2761: if fnd_api.to_boolean(p_commit) then
2762: commit work;
2763: end if;
2764:
2765: --

Line 2782: when fnd_api.g_exc_error then

2778: End if;
2779: -- g_debug := NULL;
2780: --
2781: exception
2782: when fnd_api.g_exc_error then
2783: /* --
2784: -- debugging portion
2785: -- can be commented ut for final code
2786: IF inv_pp_debug.is_debug_mode THEN

Line 2804: when fnd_api.g_exc_unexpected_error then

2800: log_error(l_api_name, 'error', 'Error in Apply - ' || x_msg_data);
2801: End if;
2802: g_debug := NULL;
2803:
2804: when fnd_api.g_exc_unexpected_error then
2805: /*--
2806: -- debugging portion
2807: -- can be commented ut for final code
2808: IF inv_pp_debug.is_debug_mode THEN

Line 2819: x_return_status := fnd_api.g_ret_sts_unexp_error;

2815: -- end of debugging section
2816: -- */
2817: rollback to ApplyStrategySP;
2818: FreeGlobals;
2819: x_return_status := fnd_api.g_ret_sts_unexp_error;
2820: fnd_msg_pub.count_and_get( p_count => x_msg_count
2821: ,p_data => x_msg_data );
2822: If (l_debug = 1) then
2823: log_error(l_api_name, 'unexp_error',

Line 2843: x_return_status := fnd_api.g_ret_sts_unexp_error;

2839: -- end of debugging section
2840: -- */
2841: rollback to ApplyStrategySP;
2842: FreeGlobals;
2843: x_return_status := fnd_api.g_ret_sts_unexp_error;
2844: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
2845: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2846: end if;
2847: fnd_msg_pub.count_and_get( p_count => x_msg_count