[Home] [Help]
107: WHEN INVALID_PKG_STATE THEN
108: x_sql_return := -1;
109: wms_costgroupengine_pvt.g_rule_list_cg_ctr := wms_rule_gen_pkgs.get_count_no_lock('COST_GROUP' );
110: WMS_ENGINE_PVT.G_SUGG_FAILURE_MESSAGE := 'Invalid Package, Contact your DBA - '|| l_list_pkg || ' / ' || l_package_name;
111: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');
112: fnd_message.set_token('LIST_PKG', l_list_pkg);
113: fnd_message.set_token('RULE_NAME', l_package_name);
114: fnd_msg_pub.ADD;
115: log_error(l_api_name, 'execute_open_rule', 'Invalid Package, Contact your DBA - '
108: x_sql_return := -1;
109: wms_costgroupengine_pvt.g_rule_list_cg_ctr := wms_rule_gen_pkgs.get_count_no_lock('COST_GROUP' );
110: WMS_ENGINE_PVT.G_SUGG_FAILURE_MESSAGE := 'Invalid Package, Contact your DBA - '|| l_list_pkg || ' / ' || l_package_name;
111: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');
112: fnd_message.set_token('LIST_PKG', l_list_pkg);
113: fnd_message.set_token('RULE_NAME', l_package_name);
114: fnd_msg_pub.ADD;
115: log_error(l_api_name, 'execute_open_rule', 'Invalid Package, Contact your DBA - '
116: || l_list_pkg || ' / ' || l_package_name);
109: wms_costgroupengine_pvt.g_rule_list_cg_ctr := wms_rule_gen_pkgs.get_count_no_lock('COST_GROUP' );
110: WMS_ENGINE_PVT.G_SUGG_FAILURE_MESSAGE := 'Invalid Package, Contact your DBA - '|| l_list_pkg || ' / ' || l_package_name;
111: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');
112: fnd_message.set_token('LIST_PKG', l_list_pkg);
113: fnd_message.set_token('RULE_NAME', l_package_name);
114: fnd_msg_pub.ADD;
115: log_error(l_api_name, 'execute_open_rule', 'Invalid Package, Contact your DBA - '
116: || l_list_pkg || ' / ' || l_package_name);
117:
246: IF p_validation_level <> fnd_api.g_valid_level_none THEN
247:
248: --check for null line_id
249: if (p_line_id IS NULL) then
250: fnd_message.set_name('WMS','WMS_CG_MISSING_LINE_ID');
251: fnd_msg_pub.add;
252: log_error_msg(l_api_name, 'missing_line_id');
253: raise fnd_api.g_exc_error;
254: end if;
254: end if;
255:
256: --check for null type code
257: if (p_input_type IS NULL) then
258: fnd_message.set_name('WMS','WMS_CG_MISSING_INPUT_TYPE');
259: fnd_msg_pub.add;
260: log_error_msg(l_api_name, 'missing_input_type');
261: raise fnd_api.g_exc_error;
262: end if;
273: log_event(l_api_name, 'mmtt_line', 'Update a move order with ' ||
274: 'move order line id: ' || p_line_id);
275: end if;
276: ELSE
277: fnd_message.set_name('WMS','WMS_CG_MISSING_INPUT_TYPE');
278: fnd_msg_pub.add;
279: log_error_msg(l_api_name, 'invalid_input_type');
280: raise fnd_api.g_exc_error;
281: END IF;
301: ,l_transaction_action_id
302: ,l_transfer_organization_id;
303: IF (c_input_line%NOTFOUND) THEN
304: CLOSE c_input_line;
305: fnd_message.set_name('WMS','WMS_CG_LINE_NOT_FOUND');
306: fnd_msg_pub.add;
307: log_error_msg(l_api_name, 'line_not_found');
308: raise fnd_api.g_exc_error;
309: END IF;
552: log_statement(l_api_name, 'l_sql_return ', l_sql_return );
553: END IF;
554:
555: IF (l_sql_return = -1 ) and l_rule_counter = 2 THEN --error
556: fnd_message.set_name('WMS', 'WMS_PACKAGE_MISSING');
557: fnd_message.set_token('RULEID', l_rule_id);
558: fnd_msg_pub.ADD;
559: if l_debug = 1 then
560: log_statement(l_api_name, 'l_sql_return ', l_sql_return );
553: END IF;
554:
555: IF (l_sql_return = -1 ) and l_rule_counter = 2 THEN --error
556: fnd_message.set_name('WMS', 'WMS_PACKAGE_MISSING');
557: fnd_message.set_token('RULEID', l_rule_id);
558: fnd_msg_pub.ADD;
559: if l_debug = 1 then
560: log_statement(l_api_name, 'l_sql_return ', l_sql_return );
561: log_error_msg(l_api_name, 'rule_package_missing');
674: FETCH l_default_cg_org into l_cost_group_id;
675: IF (l_default_cg_org%NOTFOUND OR l_cost_group_id IS NULL) THEN
676: --raise error here
677: CLOSE l_default_cg_org;
678: fnd_message.set_name('INV','INV_NO_DEFAULT_COST_GROUP');
679: fnd_msg_pub.add;
680: if l_debug = 1 then
681: log_error_msg(l_api_name, 'no_default_org_cg');
682: end if;