[Home] [Help]
1055: -- requires this
1056: if p_validation_level <> fnd_api.g_valid_level_none then
1057: if p_transaction_temp_id is null or
1058: p_transaction_temp_id = fnd_api.g_miss_num then
1059: fnd_message.set_name('WMS','WMS_TRX_REQ_LINE_ID_MISS');
1060: fnd_msg_pub.add;
1061: If (l_debug = 1) then
1062: log_error_msg(l_api_name, 'missing_txn_temp_id');
1063: End if;
1064: raise fnd_api.g_exc_unexpected_error;
1065: end if;
1066: if p_type_code is null or
1067: p_type_code = fnd_api.g_miss_num then
1068: fnd_message.set_name('WMS','WMS_STRA_TYPE_CODE_MISS');
1069: fnd_msg_pub.add;
1070: If (l_debug = 1) then
1071: log_error_msg(l_api_name, 'missing_type_code');
1072: End if;
1081: open cg_org;
1082: fetch cg_org into l_organization_id;
1083: if cg_org%notfound then
1084: close cg_org;
1085: fnd_message.set_name('WMS','WMS_TRX_REQ_REC_NOTFOUND');
1086: fnd_msg_pub.add;
1087: If (l_debug = 1) then
1088: log_error_msg(l_api_name, 'missing_org_id_cg');
1089: End if;
1094: open input;
1095: fetch input into l_organization_id;
1096: if input%notfound then
1097: close input;
1098: fnd_message.set_name('WMS','WMS_TRX_REQ_REC_NOTFOUND');
1099: fnd_msg_pub.add;
1100: If (l_debug = 1) then
1101: log_error_msg(l_api_name, 'missing_org_id_pp');
1102: End if;
1135: -- Re-Initialize API return status to success
1136: x_return_status := fnd_api.g_ret_sts_success;
1137: -- every other return status seems to be unexpected: leave
1138: else
1139: fnd_message.set_name('WMS','WMS_INVALID_RETURN_STATUS');
1140: -- WMS_re_Custom_PUB.SearchForStrategy returned wrong status
1141: fnd_msg_pub.add;
1142: If (l_debug = 1) then
1143: log_error_msg(l_api_name, 'bad_return_status');
1318: end loop;
1319: close objects;
1320: if l_last_object_found = FALSE then
1321: close hierarchy;
1322: fnd_message.set_name('WMS','WMS_DB_OBJECT_CHAIN');
1323: -- Seed data corrupted: DB object chain
1324: fnd_msg_pub.add;
1325: If (g_debug = 1) then
1326: log_error_msg(l_api_name, 'bad_db_object_chain');
1387: --commenting out exception calls; if strategy can't be found,
1388: -- we don't want to raise error. calling function will have to
1389: -- use some sort of default. We should create a log message, though.
1390: if l_hierarchy = 0 then
1391: fnd_message.set_name('WMS','WMS_SEARCH_ORDER_EMPTY');
1392: --inv_pp_debug.send_message_to_pipe('no search order defined for this org');
1393: -- Strategy search object hierarchy contains no entry
1394: --fnd_msg_pub.add;
1395: If (g_debug = 1) then
1398: End if;
1399: --raise fnd_api.g_exc_error;
1400: end if;
1401: if l_strategy_id is null then
1402: fnd_message.set_name('WMS','WMS_NO_STRATEGY_ASSIGN');
1403: -- inv_pp_debug.send_message_to_pipe('no strategy assigned');
1404: --No active strategy assignment detected according to provided input
1405: --fnd_msg_pub.add;
1406: If (g_debug = 1) then
1913: if p_validation_level <> fnd_api.g_valid_level_none then
1914: if p_transaction_temp_id is null or
1915: p_transaction_temp_id = fnd_api.g_miss_num
1916: then
1917: fnd_message.set_name('WMS','WMS_TRX_REQ_LINE_ID_MISS');
1918: -- Transaction input identifier required but not provided
1919: fnd_msg_pub.add;
1920: If (l_debug = 1) then
1921: log_error_msg(l_api_name,'missing_txn_temp_id');
1924: end if;
1925: if p_type_code is null or
1926: p_type_code = fnd_api.g_miss_num
1927: then
1928: fnd_message.set_name('WMS','WMS_STRA_TYPE_CODE_MISS');
1929: -- Strategy type code required but not provided
1930: fnd_msg_pub.add;
1931: If (l_debug = 1) then
1932: log_error_msg(l_api_name,'missing_type_code');
1935: end if;
1936: /* Strategy Id is no longer required
1937: if p_strategy_id is null or
1938: p_strategy_id = fnd_api.g_miss_num then
1939: fnd_message.set_name('WMS','WMS_STRATEGY_ID_MISSING');
1940: -- Strategy identifier required but not provided
1941: fnd_msg_pub.add;
1942: raise fnd_api.g_exc_unexpected_error;
1943: end if;