[Home] [Help]
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');
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');
1110: End if;
1119: open cg_org;
1120: fetch cg_org into l_organization_id;
1121: if cg_org%notfound then
1122: close cg_org;
1123: fnd_message.set_name('WMS','WMS_TRX_REQ_REC_NOTFOUND');
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;
1132: open input;
1133: fetch input into l_organization_id;
1134: if input%notfound then
1135: close input;
1136: fnd_message.set_name('WMS','WMS_TRX_REQ_REC_NOTFOUND');
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;
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
1179: fnd_msg_pub.add;
1180: If (l_debug = 1) then
1181: log_error_msg(l_api_name, 'bad_return_status');
1356: end loop;
1357: close objects;
1358: if l_last_object_found = FALSE then
1359: close hierarchy;
1360: fnd_message.set_name('WMS','WMS_DB_OBJECT_CHAIN');
1361: -- Seed data corrupted: DB object chain
1362: fnd_msg_pub.add;
1363: If (g_debug = 1) then
1364: log_error_msg(l_api_name, 'bad_db_object_chain');
1425: --commenting out exception calls; if strategy can't be found,
1426: -- we don't want to raise error. calling function will have to
1427: -- use some sort of default. We should create a log message, though.
1428: if l_hierarchy = 0 then
1429: fnd_message.set_name('WMS','WMS_SEARCH_ORDER_EMPTY');
1430: --inv_pp_debug.send_message_to_pipe('no search order defined for this org');
1431: -- Strategy search object hierarchy contains no entry
1432: --fnd_msg_pub.add;
1433: If (g_debug = 1) then
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');
1442: --No active strategy assignment detected according to provided input
1443: --fnd_msg_pub.add;
1444: If (g_debug = 1) then
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;
2073: If (l_debug = 1) then
2074: log_error_msg(l_api_name,'missing_txn_temp_id');
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;
2084: If (l_debug = 1) then
2085: log_error_msg(l_api_name,'missing_type_code');
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;
2096: end if;