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.

APPS.WMS_RULE_PVT dependencies on FND_MESSAGE

Line 1119: l_error_string := fnd_message.get;

1115: retcode := 1;
1116:
1117: FOR i IN 1 .. l_msg_count LOOP
1118: --fnd_file.put_line(fnd_file.LOG, 'Error:');
1119: l_error_string := fnd_message.get;
1120: --fnd_file.put_line(fnd_file.LOG, l_error_string);
1121: errbuf := errbuf || ' Error: GenerateRuleExecPkgs ' || l_error_string;
1122: END LOOP;
1123: END IF;

Line 2176: fnd_message.set_name('WMS', 'WMS_BAD_CONTEXT_DEPT_FLAG');

2172: ELSIF l_context_dependent_flag = 'N' THEN
2173: l_outer_join := NULL;
2174: ELSE
2175: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2176: fnd_message.set_name('WMS', 'WMS_BAD_CONTEXT_DEPT_FLAG');
2177: fnd_message.set_token('CONTEXT_DEPENDENT_FLAG', l_context_dependent_flag);
2178: log_error_msg(l_api_name, 'bad_context_depend_flag');
2179: fnd_msg_pub.ADD;
2180: END IF;

Line 2177: fnd_message.set_token('CONTEXT_DEPENDENT_FLAG', l_context_dependent_flag);

2173: l_outer_join := NULL;
2174: ELSE
2175: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2176: fnd_message.set_name('WMS', 'WMS_BAD_CONTEXT_DEPT_FLAG');
2177: fnd_message.set_token('CONTEXT_DEPENDENT_FLAG', l_context_dependent_flag);
2178: log_error_msg(l_api_name, 'bad_context_depend_flag');
2179: fnd_msg_pub.ADD;
2180: END IF;
2181:

Line 2197: fnd_message.set_name('WMS', 'WMS_BAD_PARAMETER_TYPE_CODE');

2193: --g_rule_where := g_rule_where || l_expression || l_outer_join;
2194: g_rule_where := g_rule_where || l_expression ; -- || l_outer_join; --Bug #3719043
2195: ELSE
2196: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2197: fnd_message.set_name('WMS', 'WMS_BAD_PARAMETER_TYPE_CODE');
2198: fnd_message.set_token('PARAMETER_TYPE_CODE', l_parameter_type_code);
2199: log_error_msg(l_api_name, 'bad_param_type_code_joins');
2200: fnd_msg_pub.ADD;
2201: END IF;

Line 2198: fnd_message.set_token('PARAMETER_TYPE_CODE', l_parameter_type_code);

2194: g_rule_where := g_rule_where || l_expression ; -- || l_outer_join; --Bug #3719043
2195: ELSE
2196: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2197: fnd_message.set_name('WMS', 'WMS_BAD_PARAMETER_TYPE_CODE');
2198: fnd_message.set_token('PARAMETER_TYPE_CODE', l_parameter_type_code);
2199: log_error_msg(l_api_name, 'bad_param_type_code_joins');
2200: fnd_msg_pub.ADD;
2201: END IF;
2202:

Line 2216: fnd_message.set_name('WMS', 'WMS_BAD_PARENT_PARA_TYPE');

2212: ELSIF l_parent_parameter_type_code = 2 THEN
2213: g_rule_where := g_rule_where || l_parent_expression;
2214: ELSE
2215: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2216: fnd_message.set_name('WMS', 'WMS_BAD_PARENT_PARA_TYPE');
2217: fnd_message.set_token('PARENT_PARAMETER_TYPE_CODE', l_parent_parameter_type_code);
2218: log_error_msg(l_api_name, 'bad_parent_param_type_joins');
2219: fnd_msg_pub.ADD;
2220: END IF;

Line 2217: fnd_message.set_token('PARENT_PARAMETER_TYPE_CODE', l_parent_parameter_type_code);

2213: g_rule_where := g_rule_where || l_parent_expression;
2214: ELSE
2215: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2216: fnd_message.set_name('WMS', 'WMS_BAD_PARENT_PARA_TYPE');
2217: fnd_message.set_token('PARENT_PARAMETER_TYPE_CODE', l_parent_parameter_type_code);
2218: log_error_msg(l_api_name, 'bad_parent_param_type_joins');
2219: fnd_msg_pub.ADD;
2220: END IF;
2221:

Line 2262: fnd_message.set_name('WMS', 'WMS_QTY_FUNC_NOT_FOUND');

2258: IF qtyfnct%NOTFOUND THEN
2259: CLOSE qtyfnct;
2260:
2261: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2262: fnd_message.set_name('WMS', 'WMS_QTY_FUNC_NOT_FOUND');
2263: log_error_msg(l_api_name, 'qty_func_not_found');
2264: fnd_msg_pub.ADD;
2265: END IF;
2266:

Line 2280: fnd_message.set_name('WMS', 'WMS_BAD_QTY_FUNC_DATA_TYPE');

2276: log_statement(l_api_name, 'table_alias_qty', 'table_alias: ' || l_table_alias);
2277:
2278: IF l_data_type_code <> 1 THEN
2279: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2280: fnd_message.set_name('WMS', 'WMS_BAD_QTY_FUNC_DATA_TYPE');
2281: fnd_message.set_token('DATATYPE', l_data_type_code);
2282: log_error_msg(l_api_name, 'bad_qty_func_data_type');
2283: fnd_msg_pub.ADD;
2284: END IF;

Line 2281: fnd_message.set_token('DATATYPE', l_data_type_code);

2277:
2278: IF l_data_type_code <> 1 THEN
2279: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2280: fnd_message.set_name('WMS', 'WMS_BAD_QTY_FUNC_DATA_TYPE');
2281: fnd_message.set_token('DATATYPE', l_data_type_code);
2282: log_error_msg(l_api_name, 'bad_qty_func_data_type');
2283: fnd_msg_pub.ADD;
2284: END IF;
2285:

Line 2328: fnd_message.set_name('WMS', 'WMS_BAD_PARAMETER_TYPE_CODE');

2324: || ',base.grade_code ' || g_line_feed; -- new
2325: END IF;
2326: ELSE
2327: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2328: fnd_message.set_name('WMS', 'WMS_BAD_PARAMETER_TYPE_CODE');
2329: fnd_message.set_token('PARAMETER_TYPE_CODE', l_parameter_type_code);
2330: log_error_msg(l_api_name, 'bad_param_type_code_qty');
2331: fnd_msg_pub.ADD;
2332: END IF;

Line 2329: fnd_message.set_token('PARAMETER_TYPE_CODE', l_parameter_type_code);

2325: END IF;
2326: ELSE
2327: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2328: fnd_message.set_name('WMS', 'WMS_BAD_PARAMETER_TYPE_CODE');
2329: fnd_message.set_token('PARAMETER_TYPE_CODE', l_parameter_type_code);
2330: log_error_msg(l_api_name, 'bad_param_type_code_qty');
2331: fnd_msg_pub.ADD;
2332: END IF;
2333:

Line 2417: fnd_message.set_name('WMS', 'WMS_BAD_PARAMETER_TYPE_CODE');

2413: || l_operator
2414: || ' ';
2415: ELSE
2416: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2417: fnd_message.set_name('WMS', 'WMS_BAD_PARAMETER_TYPE_CODE');
2418: fnd_message.set_token('PARAMETER_TYPE_CODE', l_parameter_type_code);
2419: log_error_msg(l_api_name, 'bad_param_type_code_left_rest');
2420: fnd_msg_pub.ADD;
2421: END IF;

Line 2418: fnd_message.set_token('PARAMETER_TYPE_CODE', l_parameter_type_code);

2414: || ' ';
2415: ELSE
2416: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2417: fnd_message.set_name('WMS', 'WMS_BAD_PARAMETER_TYPE_CODE');
2418: fnd_message.set_token('PARAMETER_TYPE_CODE', l_parameter_type_code);
2419: log_error_msg(l_api_name, 'bad_param_type_code_left_rest');
2420: fnd_msg_pub.ADD;
2421: END IF;
2422:

Line 2510: fnd_message.set_name('WMS', 'WMS_BAD_PARENT_PARA_TYPE');

2506: || l_bracket_close
2507: || g_line_feed;
2508: ELSE
2509: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2510: fnd_message.set_name('WMS', 'WMS_BAD_PARENT_PARA_TYPE');
2511: fnd_message.set_token('PARENT_PARAMETER_TYPE_CODE', l_parent_parameter_type_code);
2512: log_error_msg(l_api_name, 'bad_parent_param_type_right_rest');
2513: fnd_msg_pub.ADD;
2514: END IF;

Line 2511: fnd_message.set_token('PARENT_PARAMETER_TYPE_CODE', l_parent_parameter_type_code);

2507: || g_line_feed;
2508: ELSE
2509: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2510: fnd_message.set_name('WMS', 'WMS_BAD_PARENT_PARA_TYPE');
2511: fnd_message.set_token('PARENT_PARAMETER_TYPE_CODE', l_parent_parameter_type_code);
2512: log_error_msg(l_api_name, 'bad_parent_param_type_right_rest');
2513: fnd_msg_pub.ADD;
2514: END IF;
2515:

Line 2557: fnd_message.set_name('WMS', 'WMS_BAD_REF_FLEXVSET_DATA');

2553: || l_bracket_close
2554: || g_line_feed;
2555: ELSE
2556: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2557: fnd_message.set_name('WMS', 'WMS_BAD_REF_FLEXVSET_DATA');
2558: fnd_message.set_token('DATATYPE', l_validation_type);
2559: log_error_msg(l_api_name, 'bad_ref_flexvset_data');
2560: fnd_msg_pub.ADD;
2561: END IF;

Line 2558: fnd_message.set_token('DATATYPE', l_validation_type);

2554: || g_line_feed;
2555: ELSE
2556: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2557: fnd_message.set_name('WMS', 'WMS_BAD_REF_FLEXVSET_DATA');
2558: fnd_message.set_token('DATATYPE', l_validation_type);
2559: log_error_msg(l_api_name, 'bad_ref_flexvset_data');
2560: fnd_msg_pub.ADD;
2561: END IF;
2562:

Line 2569: fnd_message.set_name('WMS', 'WMS_BAD_OPERAND_TYPE_CODE');

2565: ELSIF l_operand_type_code = 7 THEN -- right side = nothing
2566: g_rule_where := g_rule_where || l_bracket_close || g_line_feed;
2567: ELSE
2568: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2569: fnd_message.set_name('WMS', 'WMS_BAD_OPERAND_TYPE_CODE');
2570: fnd_message.set_token('OPERAND_TYPE_CODE', l_operand_type_code);
2571: fnd_msg_pub.ADD;
2572: END IF;
2573:

Line 2570: fnd_message.set_token('OPERAND_TYPE_CODE', l_operand_type_code);

2566: g_rule_where := g_rule_where || l_bracket_close || g_line_feed;
2567: ELSE
2568: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2569: fnd_message.set_name('WMS', 'WMS_BAD_OPERAND_TYPE_CODE');
2570: fnd_message.set_token('OPERAND_TYPE_CODE', l_operand_type_code);
2571: fnd_msg_pub.ADD;
2572: END IF;
2573:
2574: RAISE fnd_api.g_exc_error;

Line 2688: fnd_message.set_name('WMS', 'WMS_BAD_PARAMETER_TYPE_CODE');

2684: g_rule_group_by := g_rule_group_by || ',' || l_expression;
2685: END IF;
2686: ELSE
2687: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2688: fnd_message.set_name('WMS', 'WMS_BAD_PARAMETER_TYPE_CODE');
2689: fnd_message.set_token('OPERAND_TYPE_CODE', l_parameter_type_code);
2690: log_error_msg(l_api_name, 'bad_param_type_code_sort');
2691: fnd_msg_pub.ADD;
2692: END IF;

Line 2689: fnd_message.set_token('OPERAND_TYPE_CODE', l_parameter_type_code);

2685: END IF;
2686: ELSE
2687: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2688: fnd_message.set_name('WMS', 'WMS_BAD_PARAMETER_TYPE_CODE');
2689: fnd_message.set_token('OPERAND_TYPE_CODE', l_parameter_type_code);
2690: log_error_msg(l_api_name, 'bad_param_type_code_sort');
2691: fnd_msg_pub.ADD;
2692: END IF;
2693:

Line 2743: fnd_message.set_name('WMS', 'WMS_BAD_PARAMETER_TYPE_CODE');

2739: END IF;
2740:
2741: g_rule_group_by := g_rule_group_by || ',' || l_expression || g_line_feed;
2742: ELSE
2743: fnd_message.set_name('WMS', 'WMS_BAD_PARAMETER_TYPE_CODE');
2744: fnd_message.set_token('OPERAND_TYPE_CODE', l_parameter_type_code);
2745: log_error_msg(l_api_name, 'bad_param_type_code_consist');
2746: fnd_msg_pub.ADD;
2747: RAISE fnd_api.g_exc_error;

Line 2744: fnd_message.set_token('OPERAND_TYPE_CODE', l_parameter_type_code);

2740:
2741: g_rule_group_by := g_rule_group_by || ',' || l_expression || g_line_feed;
2742: ELSE
2743: fnd_message.set_name('WMS', 'WMS_BAD_PARAMETER_TYPE_CODE');
2744: fnd_message.set_token('OPERAND_TYPE_CODE', l_parameter_type_code);
2745: log_error_msg(l_api_name, 'bad_param_type_code_consist');
2746: fnd_msg_pub.ADD;
2747: RAISE fnd_api.g_exc_error;
2748: END IF;

Line 3376: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');

3372: EXCEPTION
3373: WHEN INVALID_PKG_STATE THEN
3374: x_return_status := fnd_api.g_ret_sts_unexp_error;
3375:
3376: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');
3377: fnd_message.set_token('LIST_PKG', l_list_pkg);
3378: fnd_message.set_token('RULE_NAME', l_package_name);
3379: fnd_msg_pub.ADD;
3380: IF l_debug = 1 THEN

Line 3377: fnd_message.set_token('LIST_PKG', l_list_pkg);

3373: WHEN INVALID_PKG_STATE THEN
3374: x_return_status := fnd_api.g_ret_sts_unexp_error;
3375:
3376: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');
3377: fnd_message.set_token('LIST_PKG', l_list_pkg);
3378: fnd_message.set_token('RULE_NAME', l_package_name);
3379: fnd_msg_pub.ADD;
3380: IF l_debug = 1 THEN
3381: log_error(l_api_name, 'execute_fetch_rule', 'Invalid Package, Contact your DBA - '

Line 3378: fnd_message.set_token('RULE_NAME', l_package_name);

3374: x_return_status := fnd_api.g_ret_sts_unexp_error;
3375:
3376: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');
3377: fnd_message.set_token('LIST_PKG', l_list_pkg);
3378: fnd_message.set_token('RULE_NAME', l_package_name);
3379: fnd_msg_pub.ADD;
3380: IF l_debug = 1 THEN
3381: log_error(l_api_name, 'execute_fetch_rule', 'Invalid Package, Contact your DBA - '
3382: || l_list_pkg || ' / ' || l_package_name);

Line 3537: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');

3533: --
3534: EXCEPTION
3535: WHEN INVALID_PKG_STATE THEN
3536: x_return_status := fnd_api.g_ret_sts_unexp_error;
3537: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');
3538: fnd_message.set_token('LIST_PKG', l_list_pkg);
3539: fnd_message.set_token('RULE_NAME', l_package_name);
3540: fnd_msg_pub.ADD;
3541:

Line 3538: fnd_message.set_token('LIST_PKG', l_list_pkg);

3534: EXCEPTION
3535: WHEN INVALID_PKG_STATE THEN
3536: x_return_status := fnd_api.g_ret_sts_unexp_error;
3537: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');
3538: fnd_message.set_token('LIST_PKG', l_list_pkg);
3539: fnd_message.set_token('RULE_NAME', l_package_name);
3540: fnd_msg_pub.ADD;
3541:
3542: IF l_debug = 1 THEN

Line 3539: fnd_message.set_token('RULE_NAME', l_package_name);

3535: WHEN INVALID_PKG_STATE THEN
3536: x_return_status := fnd_api.g_ret_sts_unexp_error;
3537: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');
3538: fnd_message.set_token('LIST_PKG', l_list_pkg);
3539: fnd_message.set_token('RULE_NAME', l_package_name);
3540: fnd_msg_pub.ADD;
3541:
3542: IF l_debug = 1 THEN
3543: log_error(l_api_name, 'execute_fetch_rule', 'Invalid Package, Contact your DBA - '

Line 3713: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');

3709: x_result := 0;
3710: wms_rule_pvt.g_rule_list_pick_ctr := wms_rule_gen_pkgs.get_count_no_lock('PICK');
3711:
3712: WMS_ENGINE_PVT.G_SUGG_FAILURE_MESSAGE := 'Invalid Package, Contact your DBA - '|| l_list_pkg || ' / ' || l_package_name;
3713: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');
3714: fnd_message.set_token('LIST_PKG', l_list_pkg);
3715: fnd_message.set_token('RULE_NAME', l_package_name);
3716: fnd_msg_pub.ADD;
3717:

Line 3714: fnd_message.set_token('LIST_PKG', l_list_pkg);

3710: wms_rule_pvt.g_rule_list_pick_ctr := wms_rule_gen_pkgs.get_count_no_lock('PICK');
3711:
3712: WMS_ENGINE_PVT.G_SUGG_FAILURE_MESSAGE := 'Invalid Package, Contact your DBA - '|| l_list_pkg || ' / ' || l_package_name;
3713: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');
3714: fnd_message.set_token('LIST_PKG', l_list_pkg);
3715: fnd_message.set_token('RULE_NAME', l_package_name);
3716: fnd_msg_pub.ADD;
3717:
3718: IF l_debug = 1 THEN

Line 3715: fnd_message.set_token('RULE_NAME', l_package_name);

3711:
3712: WMS_ENGINE_PVT.G_SUGG_FAILURE_MESSAGE := 'Invalid Package, Contact your DBA - '|| l_list_pkg || ' / ' || l_package_name;
3713: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');
3714: fnd_message.set_token('LIST_PKG', l_list_pkg);
3715: fnd_message.set_token('RULE_NAME', l_package_name);
3716: fnd_msg_pub.ADD;
3717:
3718: IF l_debug = 1 THEN
3719: log_error(l_api_name, 'execute_open_rule', 'Invalid Package, Contact your DBA - '

Line 3830: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');

3826: x_result := 0;
3827: wms_rule_pvt.g_rule_list_put_ctr := wms_rule_gen_pkgs.get_count_no_lock('PUTAWAY');
3828:
3829: WMS_ENGINE_PVT.G_SUGG_FAILURE_MESSAGE := 'Invalid Package, Contact your DBA - '|| l_list_pkg || ' / ' || l_package_name;
3830: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');
3831: fnd_message.set_token('LIST_PKG', l_list_pkg);
3832: fnd_message.set_token('RULE_NAME', l_package_name);
3833: fnd_msg_pub.ADD;
3834:

Line 3831: fnd_message.set_token('LIST_PKG', l_list_pkg);

3827: wms_rule_pvt.g_rule_list_put_ctr := wms_rule_gen_pkgs.get_count_no_lock('PUTAWAY');
3828:
3829: WMS_ENGINE_PVT.G_SUGG_FAILURE_MESSAGE := 'Invalid Package, Contact your DBA - '|| l_list_pkg || ' / ' || l_package_name;
3830: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');
3831: fnd_message.set_token('LIST_PKG', l_list_pkg);
3832: fnd_message.set_token('RULE_NAME', l_package_name);
3833: fnd_msg_pub.ADD;
3834:
3835: IF l_debug = 1 THEN

Line 3832: fnd_message.set_token('RULE_NAME', l_package_name);

3828:
3829: WMS_ENGINE_PVT.G_SUGG_FAILURE_MESSAGE := 'Invalid Package, Contact your DBA - '|| l_list_pkg || ' / ' || l_package_name;
3830: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');
3831: fnd_message.set_token('LIST_PKG', l_list_pkg);
3832: fnd_message.set_token('RULE_NAME', l_package_name);
3833: fnd_msg_pub.ADD;
3834:
3835: IF l_debug = 1 THEN
3836: log_error(l_api_name, 'execute_open_rule', 'Invalid Package, Contact your DBA - '

Line 3882: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');

3878: x_return_status := -1 ;
3879: wms_rule_pvt.g_rule_list_op_ctr := wms_rule_gen_pkgs.get_count_no_lock('OPERATION_PLAN');
3880: WMS_ENGINE_PVT.G_SUGG_FAILURE_MESSAGE := 'Invalid Package, Contact your DBA - '|| l_list_pkg || ' / ' || l_package_name;
3881: x_return_status := fnd_api.g_ret_sts_unexp_error;
3882: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');
3883: fnd_message.set_token('LIST_PKG', l_list_pkg);
3884: fnd_message.set_token('RULE_NAME', l_package_name);
3885: fnd_msg_pub.ADD;
3886: /*log_error(l_api_name, 'execute_op_rule', 'Invalid Package, Contact your DBA - '

Line 3883: fnd_message.set_token('LIST_PKG', l_list_pkg);

3879: wms_rule_pvt.g_rule_list_op_ctr := wms_rule_gen_pkgs.get_count_no_lock('OPERATION_PLAN');
3880: WMS_ENGINE_PVT.G_SUGG_FAILURE_MESSAGE := 'Invalid Package, Contact your DBA - '|| l_list_pkg || ' / ' || l_package_name;
3881: x_return_status := fnd_api.g_ret_sts_unexp_error;
3882: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');
3883: fnd_message.set_token('LIST_PKG', l_list_pkg);
3884: fnd_message.set_token('RULE_NAME', l_package_name);
3885: fnd_msg_pub.ADD;
3886: /*log_error(l_api_name, 'execute_op_rule', 'Invalid Package, Contact your DBA - '
3887: || l_list_pkg || ' / ' || l_package_name); */

Line 3884: fnd_message.set_token('RULE_NAME', l_package_name);

3880: WMS_ENGINE_PVT.G_SUGG_FAILURE_MESSAGE := 'Invalid Package, Contact your DBA - '|| l_list_pkg || ' / ' || l_package_name;
3881: x_return_status := fnd_api.g_ret_sts_unexp_error;
3882: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');
3883: fnd_message.set_token('LIST_PKG', l_list_pkg);
3884: fnd_message.set_token('RULE_NAME', l_package_name);
3885: fnd_msg_pub.ADD;
3886: /*log_error(l_api_name, 'execute_op_rule', 'Invalid Package, Contact your DBA - '
3887: || l_list_pkg || ' / ' || l_package_name); */
3888: END execute_op_rule;

Line 3932: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');

3928: x_return_status := -1 ;
3929: wms_rule_pvt.g_rule_list_task_ctr := wms_rule_gen_pkgs.get_count_no_lock('TASK');
3930: WMS_ENGINE_PVT.G_SUGG_FAILURE_MESSAGE := 'Invalid Package, Contact your DBA - '|| l_list_pkg || ' / ' || l_package_name;
3931: x_return_status := fnd_api.g_ret_sts_unexp_error;
3932: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');
3933: fnd_message.set_token('LIST_PKG', l_list_pkg);
3934: fnd_message.set_token('RULE_NAME', l_package_name);
3935: fnd_msg_pub.ADD;
3936: /*log_error(l_api_name, 'execute_task_rule', 'Invalid Package, Contact your DBA - '

Line 3933: fnd_message.set_token('LIST_PKG', l_list_pkg);

3929: wms_rule_pvt.g_rule_list_task_ctr := wms_rule_gen_pkgs.get_count_no_lock('TASK');
3930: WMS_ENGINE_PVT.G_SUGG_FAILURE_MESSAGE := 'Invalid Package, Contact your DBA - '|| l_list_pkg || ' / ' || l_package_name;
3931: x_return_status := fnd_api.g_ret_sts_unexp_error;
3932: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');
3933: fnd_message.set_token('LIST_PKG', l_list_pkg);
3934: fnd_message.set_token('RULE_NAME', l_package_name);
3935: fnd_msg_pub.ADD;
3936: /*log_error(l_api_name, 'execute_task_rule', 'Invalid Package, Contact your DBA - '
3937: || l_list_pkg || ' / ' || l_package_name); */

Line 3934: fnd_message.set_token('RULE_NAME', l_package_name);

3930: WMS_ENGINE_PVT.G_SUGG_FAILURE_MESSAGE := 'Invalid Package, Contact your DBA - '|| l_list_pkg || ' / ' || l_package_name;
3931: x_return_status := fnd_api.g_ret_sts_unexp_error;
3932: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');
3933: fnd_message.set_token('LIST_PKG', l_list_pkg);
3934: fnd_message.set_token('RULE_NAME', l_package_name);
3935: fnd_msg_pub.ADD;
3936: /*log_error(l_api_name, 'execute_task_rule', 'Invalid Package, Contact your DBA - '
3937: || l_list_pkg || ' / ' || l_package_name); */
3938:

Line 3985: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');

3981: x_return_status := -1 ;
3982: wms_rule_pvt.g_rule_list_label_ctr := wms_rule_gen_pkgs.get_count_no_lock('LABEL');
3983: WMS_ENGINE_PVT.G_SUGG_FAILURE_MESSAGE := 'Invalid Package, Contact your DBA - '|| l_list_pkg || ' / ' || l_package_name;
3984: x_return_status := fnd_api.g_ret_sts_unexp_error;
3985: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');
3986: fnd_message.set_token('LIST_PKG', l_list_pkg);
3987: fnd_message.set_token('RULE_NAME', l_package_name);
3988: fnd_msg_pub.ADD;
3989: /*log_error(l_api_name, 'execute_label_rule', 'Invalid Package, Contact your DBA - '

Line 3986: fnd_message.set_token('LIST_PKG', l_list_pkg);

3982: wms_rule_pvt.g_rule_list_label_ctr := wms_rule_gen_pkgs.get_count_no_lock('LABEL');
3983: WMS_ENGINE_PVT.G_SUGG_FAILURE_MESSAGE := 'Invalid Package, Contact your DBA - '|| l_list_pkg || ' / ' || l_package_name;
3984: x_return_status := fnd_api.g_ret_sts_unexp_error;
3985: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');
3986: fnd_message.set_token('LIST_PKG', l_list_pkg);
3987: fnd_message.set_token('RULE_NAME', l_package_name);
3988: fnd_msg_pub.ADD;
3989: /*log_error(l_api_name, 'execute_label_rule', 'Invalid Package, Contact your DBA - '
3990: || l_list_pkg || ' / ' || l_package_name); */

Line 3987: fnd_message.set_token('RULE_NAME', l_package_name);

3983: WMS_ENGINE_PVT.G_SUGG_FAILURE_MESSAGE := 'Invalid Package, Contact your DBA - '|| l_list_pkg || ' / ' || l_package_name;
3984: x_return_status := fnd_api.g_ret_sts_unexp_error;
3985: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');
3986: fnd_message.set_token('LIST_PKG', l_list_pkg);
3987: fnd_message.set_token('RULE_NAME', l_package_name);
3988: fnd_msg_pub.ADD;
3989: /*log_error(l_api_name, 'execute_label_rule', 'Invalid Package, Contact your DBA - '
3990: || l_list_pkg || ' / ' || l_package_name); */
3991:

Line 4027: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');

4023:
4024: EXCEPTION
4025: WHEN INVALID_PKG_STATE THEN
4026: /* -- WMS_ENGINE_PVT.G_SUGG_FAILURE_MESSAGE := 'Invalid Package, Contact your DBA - '|| l_list_pkg || ' / ' || l_package_name;
4027: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');
4028: fnd_message.set_token('LIST_PKG', l_list_pkg);
4029: fnd_message.set_token('RULE_NAME', l_package_name);
4030: fnd_msg_pub.ADD;
4031: log_error(l_api_name, 'execute_close_rule', 'Invalid Package, Contact your DBA - '

Line 4028: fnd_message.set_token('LIST_PKG', l_list_pkg);

4024: EXCEPTION
4025: WHEN INVALID_PKG_STATE THEN
4026: /* -- WMS_ENGINE_PVT.G_SUGG_FAILURE_MESSAGE := 'Invalid Package, Contact your DBA - '|| l_list_pkg || ' / ' || l_package_name;
4027: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');
4028: fnd_message.set_token('LIST_PKG', l_list_pkg);
4029: fnd_message.set_token('RULE_NAME', l_package_name);
4030: fnd_msg_pub.ADD;
4031: log_error(l_api_name, 'execute_close_rule', 'Invalid Package, Contact your DBA - '
4032: || l_list_pkg || ' / ' || l_package_name); */

Line 4029: fnd_message.set_token('RULE_NAME', l_package_name);

4025: WHEN INVALID_PKG_STATE THEN
4026: /* -- WMS_ENGINE_PVT.G_SUGG_FAILURE_MESSAGE := 'Invalid Package, Contact your DBA - '|| l_list_pkg || ' / ' || l_package_name;
4027: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');
4028: fnd_message.set_token('LIST_PKG', l_list_pkg);
4029: fnd_message.set_token('RULE_NAME', l_package_name);
4030: fnd_msg_pub.ADD;
4031: log_error(l_api_name, 'execute_close_rule', 'Invalid Package, Contact your DBA - '
4032: || l_list_pkg || ' / ' || l_package_name); */
4033: RAISE fnd_api.g_exc_unexpected_error;

Line 4064: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');

4060:
4061: EXCEPTION
4062: WHEN INVALID_PKG_STATE THEN
4063: /*WMS_ENGINE_PVT.G_SUGG_FAILURE_MESSAGE := 'Invalid Package, Contact your DBA - '|| l_list_pkg || ' / ' || l_package_name;
4064: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');
4065: fnd_message.set_token('LIST_PKG', l_list_pkg);
4066: fnd_message.set_token('RULE_NAME', l_package_name);
4067: fnd_msg_pub.ADD;
4068: log_error(l_api_name, 'execute_close_rule', 'Invalid Package, Contact your DBA - '

Line 4065: fnd_message.set_token('LIST_PKG', l_list_pkg);

4061: EXCEPTION
4062: WHEN INVALID_PKG_STATE THEN
4063: /*WMS_ENGINE_PVT.G_SUGG_FAILURE_MESSAGE := 'Invalid Package, Contact your DBA - '|| l_list_pkg || ' / ' || l_package_name;
4064: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');
4065: fnd_message.set_token('LIST_PKG', l_list_pkg);
4066: fnd_message.set_token('RULE_NAME', l_package_name);
4067: fnd_msg_pub.ADD;
4068: log_error(l_api_name, 'execute_close_rule', 'Invalid Package, Contact your DBA - '
4069: || l_list_pkg || ' / ' || l_package_name);*/

Line 4066: fnd_message.set_token('RULE_NAME', l_package_name);

4062: WHEN INVALID_PKG_STATE THEN
4063: /*WMS_ENGINE_PVT.G_SUGG_FAILURE_MESSAGE := 'Invalid Package, Contact your DBA - '|| l_list_pkg || ' / ' || l_package_name;
4064: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');
4065: fnd_message.set_token('LIST_PKG', l_list_pkg);
4066: fnd_message.set_token('RULE_NAME', l_package_name);
4067: fnd_msg_pub.ADD;
4068: log_error(l_api_name, 'execute_close_rule', 'Invalid Package, Contact your DBA - '
4069: || l_list_pkg || ' / ' || l_package_name);*/
4070: RAISE fnd_api.g_exc_unexpected_error;

Line 6839: fnd_message.set_name('WMS', 'WMS_RULE_TYPE_CODE_MISSING');

6835: IF p_validation_level <> fnd_api.g_valid_level_none THEN
6836: IF p_type_code IS NULL
6837: OR p_type_code = fnd_api.g_miss_num THEN
6838: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
6839: fnd_message.set_name('WMS', 'WMS_RULE_TYPE_CODE_MISSING');
6840: fnd_msg_pub.ADD;
6841:
6842: IF l_debug = 1 THEN
6843: log_error_msg(l_api_name, 'type_code_missing');

Line 6906: fnd_message.set_name('WMS', 'WMS_PARTIAL_SUCC_FLAG_MISS');

6902:
6903: IF p_partial_success_allowed_flag IS NULL
6904: OR p_partial_success_allowed_flag = fnd_api.g_miss_char THEN
6905: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
6906: fnd_message.set_name('WMS', 'WMS_PARTIAL_SUCC_FLAG_MISS');
6907: IF l_debug = 1 THEN
6908: log_error_msg(l_api_name, 'partial_succ_flag_missing');
6909: END IF;
6910: fnd_msg_pub.ADD;

Line 6918: fnd_message.set_name('WMS', 'WMS_TRX_REQ_LINE_ID_MISS');

6914:
6915: IF p_transaction_temp_id IS NULL
6916: OR p_transaction_temp_id = fnd_api.g_miss_num THEN
6917: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
6918: fnd_message.set_name('WMS', 'WMS_TRX_REQ_LINE_ID_MISS');
6919: fnd_msg_pub.ADD;
6920: IF l_debug = 1 THEN
6921: log_error_msg(l_api_name, 'trx_req_line_id_missing');
6922: END IF;

Line 6930: fnd_message.set_name('INV', 'INV_NO_ORG_INFORMATION');

6926:
6927: IF p_organization_id IS NULL
6928: OR p_organization_id = fnd_api.g_miss_num THEN
6929: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
6930: fnd_message.set_name('INV', 'INV_NO_ORG_INFORMATION');
6931: fnd_msg_pub.ADD;
6932: IF l_debug = 1 THEN
6933: log_error_msg(l_api_name, 'org_id_missing');
6934: END IF;

Line 6943: fnd_message.set_name('INV', 'INV_ITEM_ID_REQUIRED');

6939:
6940: IF p_inventory_item_id IS NULL
6941: OR p_inventory_item_id = fnd_api.g_miss_num THEN
6942: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
6943: fnd_message.set_name('INV', 'INV_ITEM_ID_REQUIRED');
6944: fnd_msg_pub.ADD;
6945: IF l_debug = 1 THEN
6946: log_error_msg(l_api_name, 'item_id_missing');
6947: END IF;

Line 6958: fnd_message.set_name('INV', 'INV_QTY_TREE_ID_MISSING');

6954: AND (p_tree_id IS NULL
6955: OR p_tree_id = fnd_api.g_miss_num
6956: ) THEN
6957: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
6958: fnd_message.set_name('INV', 'INV_QTY_TREE_ID_MISSING');
6959: fnd_msg_pub.ADD;
6960: IF l_debug = 1 THEN
6961: log_error_msg(l_api_name, 'qty_tree_id_missing');
6962: END IF;

Line 7629: fnd_message.set_name('WMS', 'WMS_PACKAGE_MISSING');

7625: log_statement(l_api_name, 'open_curs_err', 'Error calling open_curs');
7626: log_error_msg(l_api_name, 'rule_package_missing');
7627: log_statement(l_api_name, 'pack_name', 'Package name: ' || l_package_name);
7628: END IF;
7629: fnd_message.set_name('WMS', 'WMS_PACKAGE_MISSING');
7630: fnd_message.set_token('RULEID', l_rule_id);
7631: fnd_msg_pub.ADD;
7632: RAISE fnd_api.g_exc_unexpected_error;
7633: END IF;

Line 7630: fnd_message.set_token('RULEID', l_rule_id);

7626: log_error_msg(l_api_name, 'rule_package_missing');
7627: log_statement(l_api_name, 'pack_name', 'Package name: ' || l_package_name);
7628: END IF;
7629: fnd_message.set_name('WMS', 'WMS_PACKAGE_MISSING');
7630: fnd_message.set_token('RULEID', l_rule_id);
7631: fnd_msg_pub.ADD;
7632: RAISE fnd_api.g_exc_unexpected_error;
7633: END IF;
7634: END LOOP;

Line 11059: fnd_message.set_name('INV','INV_INVALID_LOC_CONTROL');

11055: x_return_status := fnd_api.g_ret_sts_success;
11056: RETURN l_locator_control;
11057: EXCEPTION
11058: WHEN invalid_loc_control_exception THEN
11059: fnd_message.set_name('INV','INV_INVALID_LOC_CONTROL');
11060: fnd_msg_pub.ADD;
11061: --
11062: x_return_status := fnd_api.g_ret_sts_error ;
11063: l_locator_control := -1 ;

Line 11181: fnd_message.set_name('INV','INV_NO_DEFAULT_SUB');

11177: FETCH l_subinventory_code_csr INTO l_putaway_sub;
11178: IF l_subinventory_code_csr%notfound OR
11179: l_putaway_sub IS NULL THEN
11180: CLOSE l_subinventory_code_csr;
11181: fnd_message.set_name('INV','INV_NO_DEFAULT_SUB');
11182: fnd_msg_pub.ADD;
11183: RAISE fnd_api.g_exc_error;
11184: END IF;
11185: CLOSE l_subinventory_code_csr;

Line 11196: fnd_message.set_name('INV','INV_NO_SUB_LOC_CONTROL');

11192: -- now get the locator control and then determine if
11193: -- default locator needs to be selected from item defaults
11194: --
11195: IF NOT l_sub_found THEN
11196: fnd_message.set_name('INV','INV_NO_SUB_LOC_CONTROL');
11197: fnd_msg_pub.ADD;
11198: RAISE fnd_api.g_exc_error;
11199: END if;
11200:

Line 11238: fnd_message.set_name('INV','INV_NO_DEFAULT_LOC');

11234: OPEN l_locator_csr;
11235: FETCH l_locator_csr INTO l_putaway_loc;
11236: IF l_locator_csr%notfound OR l_putaway_loc IS NULL THEN
11237: CLOSE l_locator_csr;
11238: fnd_message.set_name('INV','INV_NO_DEFAULT_LOC');
11239: fnd_msg_pub.ADD;
11240:
11241: RAISE fnd_api.g_exc_error;
11242: END IF;

Line 11278: fnd_message.set_name('INV','INV_NO_DEFAULT_COST_GROUP');

11274:
11275: If l_putaway_cg IS NULL Then
11276: l_putaway_cg := l_putaway_cg_org;
11277: if l_putaway_cg IS NULL then
11278: fnd_message.set_name('INV','INV_NO_DEFAULT_COST_GROUP');
11279: fnd_msg_pub.ADD;
11280: RAISE fnd_api.g_exc_error;
11281: end if;
11282: End If;

Line 11503: fnd_message.set_name('WMS','WMS_TRX_REQ_LINE_ID_MISS');

11499: IF p_validation_level <> fnd_api.g_valid_level_none THEN
11500: IF p_transaction_temp_id IS NULL OR
11501: p_transaction_temp_id = fnd_api.g_miss_num THEN
11502: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
11503: fnd_message.set_name('WMS','WMS_TRX_REQ_LINE_ID_MISS');
11504: If (l_debug = 1) then
11505: log_error_msg(l_api_name, 'trx_req_line_id_missing');
11506: End if;
11507: fnd_msg_pub.add;

Line 11514: fnd_message.set_name('INV','INV_NO_ORG_INFORMATION');

11510: END IF;
11511: IF p_organization_id IS NULL OR
11512: p_organization_id = fnd_api.g_miss_num THEN
11513: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
11514: fnd_message.set_name('INV','INV_NO_ORG_INFORMATION');
11515: If (l_debug = 1) then
11516: log_error_msg(l_api_name, 'org_id_missing');
11517: End if;
11518: fnd_msg_pub.add;

Line 11525: fnd_message.set_name('INV','INV_ITEM_ID_REQUIRED');

11521: END IF;
11522: IF p_inventory_item_id IS NULL OR
11523: p_inventory_item_id = fnd_api.g_miss_num THEN
11524: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
11525: fnd_message.set_name('INV','INV_ITEM_ID_REQUIRED');
11526: If (l_debug = 1) then
11527: log_error_msg(l_api_name, 'item_id_missing');
11528: End if;
11529: fnd_msg_pub.add;

Line 12593: fnd_message.set_name('WMS', 'WMS_RULE_ID_MISSING');

12589: IF p_validation_level <> fnd_api.g_valid_level_none THEN
12590: IF p_rule_id IS NULL
12591: OR p_rule_id = fnd_api.g_miss_num THEN
12592: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
12593: fnd_message.set_name('WMS', 'WMS_RULE_ID_MISSING');
12594: log_error_msg(l_api_name, 'rule_id_missing');
12595: fnd_msg_pub.ADD;
12596: END IF;
12597:

Line 13660: fnd_message.set_name('WMS','WMS_SYNTAX_CHECK_SUCCESS');

13656: --
13657:
13658: /*
13659: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
13660: fnd_message.set_name('WMS','WMS_SYNTAX_CHECK_SUCCESS');
13661: fnd_msg_pub.add;
13662: END IF;
13663: */ --
13664: -- end of debugging section

Line 13710: fnd_message.set_name('WMS', 'WMS_PACKAGE_GEN_FAILED');

13706: DBMS_SQL.close_cursor(l_cursor);
13707: END IF;
13708:
13709: freeglobals;
13710: fnd_message.set_name('WMS', 'WMS_PACKAGE_GEN_FAILED');
13711: fnd_msg_pub.ADD;
13712: x_return_status := fnd_api.g_ret_sts_unexp_error;
13713: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
13714: log_error(l_api_name, 'unexp_error', 'Unexpected error - ' || x_msg_data);

Line 13739: fnd_message.set_name('WMS', 'WMS_PACKAGE_GEN_FAILED');

13735: DBMS_SQL.close_cursor(l_cursor);
13736: END IF;
13737:
13738: freeglobals;
13739: fnd_message.set_name('WMS', 'WMS_PACKAGE_GEN_FAILED');
13740: fnd_msg_pub.ADD;
13741: x_return_status := fnd_api.g_ret_sts_unexp_error;
13742:
13743: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 13994: fnd_message.set_name('WMS', 'WMS_PACKAGE_MISSING');

13990: --- Execute op Rule
13991: For l_rule_counter IN 1..2 LOOP
13992: execute_op_rule(l_rule_id, p_task_id, l_return_status);
13993: IF (l_return_status = -1) and l_rule_counter = 2 THEN --error
13994: fnd_message.set_name('WMS', 'WMS_PACKAGE_MISSING');
13995: fnd_message.set_token('RULEID', l_rule_id);
13996: fnd_msg_pub.ADD;
13997: log_error_msg(l_api_name, 'rule_package_missing');
13998: log_statement(l_api_name, 'pack_name', 'Package name: ' || l_package_name);

Line 13995: fnd_message.set_token('RULEID', l_rule_id);

13991: For l_rule_counter IN 1..2 LOOP
13992: execute_op_rule(l_rule_id, p_task_id, l_return_status);
13993: IF (l_return_status = -1) and l_rule_counter = 2 THEN --error
13994: fnd_message.set_name('WMS', 'WMS_PACKAGE_MISSING');
13995: fnd_message.set_token('RULEID', l_rule_id);
13996: fnd_msg_pub.ADD;
13997: log_error_msg(l_api_name, 'rule_package_missing');
13998: log_statement(l_api_name, 'pack_name', 'Package name: ' || l_package_name);
13999: RAISE fnd_api.g_exc_unexpected_error;

Line 14384: fnd_message.set_name('WMS', 'WMS_PACKAGE_MISSING');

14380: log_error(l_api_name, 'Assigntt', 'Calling execute_Task :p_Tas k_id ' || p_task_id);
14381: END IF;
14382: execute_task_rule(l_rule_id, p_task_id, l_return_status);
14383: IF (l_return_status = -1) and l_rule_counter = 2 THEN --error
14384: fnd_message.set_name('WMS', 'WMS_PACKAGE_MISSING');
14385: fnd_message.set_token('RULEID', l_rule_id);
14386: fnd_msg_pub.ADD;
14387: IF l_debug = 1 THEN
14388: log_error_msg(l_api_name, 'rule_package_missing');

Line 14385: fnd_message.set_token('RULEID', l_rule_id);

14381: END IF;
14382: execute_task_rule(l_rule_id, p_task_id, l_return_status);
14383: IF (l_return_status = -1) and l_rule_counter = 2 THEN --error
14384: fnd_message.set_name('WMS', 'WMS_PACKAGE_MISSING');
14385: fnd_message.set_token('RULEID', l_rule_id);
14386: fnd_msg_pub.ADD;
14387: IF l_debug = 1 THEN
14388: log_error_msg(l_api_name, 'rule_package_missing');
14389: log_statement(l_api_name, 'pack_name', 'Package name: ' || l_package_name);

Line 14731: fnd_message.set_name('WMS', 'INVALID_LABEL_REQ');

14727: CLOSE l_label_requests_curs;
14728: IF l_debug = 1 THEN
14729: TRACE('Invalid Label Request Id : '|| p_label_request_id);
14730: END IF;
14731: fnd_message.set_name('WMS', 'INVALID_LABEL_REQ');
14732: fnd_msg_pub.ADD;
14733: RAISE fnd_api.g_exc_error;
14734: END IF;
14735:

Line 14763: fnd_message.set_name('WMS', 'WMS_PACKAGE_MISSING');

14759: log_statement(l_api_name, 'Inside Loop', 'l_return_status' || l_return_status);
14760: END IF;
14761: log_statement(l_api_name, 'pack_name', 'Package name: ' || l_package_name);
14762: IF (l_return_status = -1) and l_rule_counter = 2 THEN --error
14763: fnd_message.set_name('WMS', 'WMS_PACKAGE_MISSING');
14764: fnd_message.set_token('RULEID', l_rule_id);
14765: fnd_msg_pub.ADD;
14766: IF l_debug = 1 THEN
14767: log_error_msg(l_api_name, 'rule_package_missing');

Line 14764: fnd_message.set_token('RULEID', l_rule_id);

14760: END IF;
14761: log_statement(l_api_name, 'pack_name', 'Package name: ' || l_package_name);
14762: IF (l_return_status = -1) and l_rule_counter = 2 THEN --error
14763: fnd_message.set_name('WMS', 'WMS_PACKAGE_MISSING');
14764: fnd_message.set_token('RULEID', l_rule_id);
14765: fnd_msg_pub.ADD;
14766: IF l_debug = 1 THEN
14767: log_error_msg(l_api_name, 'rule_package_missing');
14768: log_error(l_api_name, 'Rule missing in the list pkg', 'l_rule_id ' || l_rule_id);

Line 14942: l_error_string := fnd_message.get;

14938: retcode := 1;
14939:
14940: FOR i IN 1 .. l_msg_count LOOP
14941: --fnd_file.put_line(fnd_file.LOG, 'Error:');
14942: l_error_string := fnd_message.get;
14943: --fnd_file.put_line(fnd_file.LOG, l_error_string);
14944: errbuf := errbuf || ' Error: Rule ' || l_rule_id || '
14945: ' || l_error_string;
14946: END LOOP;

Line 14962: l_error_string := fnd_message.get;

14958: retcode := 1;
14959:
14960: FOR i IN 1 .. l_msg_count LOOP
14961: --fnd_file.put_line(fnd_file.LOG, 'Error:');
14962: l_error_string := fnd_message.get;
14963: --fnd_file.put_line(fnd_file.LOG, l_error_string);
14964: errbuf := errbuf || ' Error: Creating WMS Rule List Package ' || l_error_string;
14965: END LOOP;
14966: END IF;

Line 15147: fnd_message.set_name('WMS', 'WMS_RULE_TYPE_CODE_MISSING');

15143: IF p_type_code IS NULL
15144: OR p_type_code = fnd_api.g_miss_num
15145: OR p_type_code = 1 THEN
15146: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
15147: fnd_message.set_name('WMS', 'WMS_RULE_TYPE_CODE_MISSING');
15148: log_error_msg(l_api_name, 'type_code_missing');
15149: fnd_msg_pub.ADD;
15150: END IF;
15151: RAISE fnd_api.g_exc_error;

Line 15162: fnd_message.set_name('WMS', 'WMS_TRX_REQ_LINE_ID_MISS');

15158:
15159: IF p_transaction_temp_id IS NULL
15160: OR p_transaction_temp_id = fnd_api.g_miss_num THEN
15161: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
15162: fnd_message.set_name('WMS', 'WMS_TRX_REQ_LINE_ID_MISS');
15163: log_error_msg(l_api_name, 'trx_req_line_id_missing');
15164: fnd_msg_pub.ADD;
15165: END IF;
15166:

Line 15178: fnd_message.set_name('INV', 'INV_NO_ORG_INFORMATION');

15174:
15175: IF p_organization_id IS NULL
15176: OR p_organization_id = fnd_api.g_miss_num THEN
15177: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
15178: fnd_message.set_name('INV', 'INV_NO_ORG_INFORMATION');
15179: log_error_msg(l_api_name, 'org_id_missing');
15180: fnd_msg_pub.ADD;
15181: END IF;
15182:

Line 15194: fnd_message.set_name('INV', 'INV_ITEM_ID_REQUIRED');

15190:
15191: IF p_inventory_item_id IS NULL
15192: OR p_inventory_item_id = fnd_api.g_miss_num THEN
15193: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
15194: fnd_message.set_name('INV', 'INV_ITEM_ID_REQUIRED');
15195: log_error_msg(l_api_name, 'item_id_missing');
15196: fnd_msg_pub.ADD;
15197: END IF;
15198:

Line 15211: fnd_message.set_name('INV', 'INV_QTY_TREE_ID_MISSING');

15207: IF (p_tree_id IS NULL
15208: OR p_tree_id = fnd_api.g_miss_num
15209: ) THEN
15210: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
15211: fnd_message.set_name('INV', 'INV_QTY_TREE_ID_MISSING');
15212: log_error_msg(l_api_name, 'qty_tree_id_missing');
15213: fnd_msg_pub.ADD;
15214: END IF;
15215:

Line 15341: fnd_message.set_name('WMS', 'WMS_ATT_SUB_STATUS_NA');

15337: , p_locator_id => l_from_locator_id
15338: , p_lot_number => l_lot_number );
15339: IF ( l_allowed = 'N') then
15340: WMS_ENGINE_PVT.G_SUGG_FAILURE_MESSAGE := 'WMS_ATT_SUB_STATUS_NA';
15341: fnd_message.set_name('WMS', 'WMS_ATT_SUB_STATUS_NA');
15342: fnd_msg_pub.ADD;
15343: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
15344: IF l_debug = 1 THEN
15345: log_error_msg(l_api_name, x_msg_data);

Line 15368: fnd_message.set_name('WMS', 'WMS_DISALLOW_TRANSACTION');

15364: END IF;
15365:
15366: IF (l_onhand_status_trx_allowed = 'N') then
15367: WMS_ENGINE_PVT.G_SUGG_FAILURE_MESSAGE := 'WMS_DISALLOW_TRANSACTION';
15368: fnd_message.set_name('WMS', 'WMS_DISALLOW_TRANSACTION');
15369: fnd_msg_pub.ADD;
15370: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
15371: IF l_debug = 1 THEN
15372: log_error_msg(l_api_name, x_msg_data);

Line 15550: fnd_message.set_name('WMS', 'WMS_LPN_UNAVAILABLE'); --- to be Added to Mesg Dict

15546: RAISE fnd_api.g_exc_error;
15547: END IF;
15548:
15549: IF l_inserted_record = FALSE OR l_allocated_quantity < l_needed_quantity THEN
15550: fnd_message.set_name('WMS', 'WMS_LPN_UNAVAILABLE'); --- to be Added to Mesg Dict
15551: fnd_msg_pub.ADD;
15552: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
15553: IF l_debug = 1 THEN
15554: log_error_msg(l_api_name, x_msg_data);

Line 15583: fnd_message.set_name('WMS', 'WMS_ATT_SUB_STATUS_NA');

15579: ELSE
15580:
15581: IF ( l_allowed = 'N') then
15582: WMS_ENGINE_PVT.G_SUGG_FAILURE_MESSAGE := 'WMS_ATT_SUB_STATUS_NA';
15583: fnd_message.set_name('WMS', 'WMS_ATT_SUB_STATUS_NA');
15584: fnd_msg_pub.ADD;
15585:
15586: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
15587: IF l_debug = 1 THEN

Line 15593: fnd_message.set_name('WMS', 'WMS_ATT_SUB_STATUS_NA');

15589: END IF;
15590:
15591: ELSIF l_serial_allowed = 'N' then
15592: WMS_ENGINE_PVT.G_SUGG_FAILURE_MESSAGE := 'WMS_ATT_SERIAL_STATUS_NA' ;
15593: fnd_message.set_name('WMS', 'WMS_ATT_SUB_STATUS_NA');
15594: fnd_msg_pub.ADD;
15595: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
15596:
15597: IF l_debug = 1 THEN

Line 15962: fnd_message.set_name('WMS', 'WMS_RULE_TYPE_CODE_MISSING');

15958: IF p_validation_level <> fnd_api.g_valid_level_none THEN
15959: IF p_type_code IS NULL
15960: OR p_type_code = fnd_api.g_miss_num THEN
15961: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
15962: fnd_message.set_name('WMS', 'WMS_RULE_TYPE_CODE_MISSING');
15963: fnd_msg_pub.ADD;
15964: IF l_debug = 1 THEN
15965: log_error_msg(l_api_name, 'type_code_missing');
15966: END IF;

Line 16031: fnd_message.set_name('WMS', 'WMS_PARTIAL_SUCC_FLAG_MISS');

16027: /* Lgao, Bug 5141737 select available will not check this flag, not used */
16028: /*IF p_partial_success_allowed_flag IS NULL
16029: OR p_partial_success_allowed_flag = fnd_api.g_miss_char THEN
16030: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
16031: fnd_message.set_name('WMS', 'WMS_PARTIAL_SUCC_FLAG_MISS');
16032:
16033: IF l_debug = 1 THEN
16034: log_error_msg(l_api_name, 'partial_succ_flag_missing');
16035: END IF;

Line 16046: fnd_message.set_name('WMS', 'WMS_TRX_REQ_LINE_ID_MISS');

16042:
16043: IF p_transaction_temp_id IS NULL
16044: OR p_transaction_temp_id = fnd_api.g_miss_num THEN
16045: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
16046: fnd_message.set_name('WMS', 'WMS_TRX_REQ_LINE_ID_MISS');
16047: fnd_msg_pub.ADD;
16048: IF l_debug = 1 THEN
16049: log_error_msg(l_api_name, 'trx_req_line_id_missing');
16050: END IF;

Line 16060: fnd_message.set_name('INV', 'INV_NO_ORG_INFORMATION');

16056:
16057: IF p_organization_id IS NULL
16058: OR p_organization_id = fnd_api.g_miss_num THEN
16059: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
16060: fnd_message.set_name('INV', 'INV_NO_ORG_INFORMATION');
16061: fnd_msg_pub.ADD;
16062: IF l_debug = 1 THEN
16063: log_error_msg(l_api_name, 'org_id_missing');
16064: END IF;

Line 16073: fnd_message.set_name('INV', 'INV_ITEM_ID_REQUIRED');

16069:
16070: IF p_inventory_item_id IS NULL
16071: OR p_inventory_item_id = fnd_api.g_miss_num THEN
16072: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
16073: fnd_message.set_name('INV', 'INV_ITEM_ID_REQUIRED');
16074: fnd_msg_pub.ADD;
16075: IF l_debug = 1 THEN
16076: log_error_msg(l_api_name, 'item_id_missing');
16077: END IF;

Line 16088: fnd_message.set_name('INV', 'INV_QTY_TREE_ID_MISSING');

16084: AND (p_tree_id IS NULL
16085: OR p_tree_id = fnd_api.g_miss_num
16086: ) THEN
16087: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
16088: fnd_message.set_name('INV', 'INV_QTY_TREE_ID_MISSING');
16089: fnd_msg_pub.ADD;
16090:
16091: IF l_debug = 1 THEN
16092: log_error_msg(l_api_name, 'qty_tree_id_missing');

Line 16448: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');

16444: END IF;
16445: EXCEPTION
16446: /*WHEN INVALID_PKG_STATE THEN
16447: x_return_status := fnd_api.g_ret_sts_unexp_error;
16448: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');
16449: fnd_message.set_token('LIST_PKG', l_list_pkg);
16450: fnd_message.set_token('RULE_NAME', l_package_name);
16451: fnd_msg_pub.ADD;
16452: log_error(l_api_name, 'execute_fetch_rule', 'Invalid Package, Contact your DBA - '

Line 16449: fnd_message.set_token('LIST_PKG', l_list_pkg);

16445: EXCEPTION
16446: /*WHEN INVALID_PKG_STATE THEN
16447: x_return_status := fnd_api.g_ret_sts_unexp_error;
16448: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');
16449: fnd_message.set_token('LIST_PKG', l_list_pkg);
16450: fnd_message.set_token('RULE_NAME', l_package_name);
16451: fnd_msg_pub.ADD;
16452: log_error(l_api_name, 'execute_fetch_rule', 'Invalid Package, Contact your DBA - '
16453: || l_list_pkg || ' / ' || l_package_name);

Line 16450: fnd_message.set_token('RULE_NAME', l_package_name);

16446: /*WHEN INVALID_PKG_STATE THEN
16447: x_return_status := fnd_api.g_ret_sts_unexp_error;
16448: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');
16449: fnd_message.set_token('LIST_PKG', l_list_pkg);
16450: fnd_message.set_token('RULE_NAME', l_package_name);
16451: fnd_msg_pub.ADD;
16452: log_error(l_api_name, 'execute_fetch_rule', 'Invalid Package, Contact your DBA - '
16453: || l_list_pkg || ' / ' || l_package_name);
16454: */

Line 16559: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');

16555: --
16556: EXCEPTION
16557: WHEN INVALID_PKG_STATE THEN
16558: x_return_status := fnd_api.g_ret_sts_unexp_error;
16559: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');
16560: fnd_message.set_token('LIST_PKG', l_list_pkg);
16561: fnd_message.set_token('RULE_NAME', l_package_name);
16562: fnd_msg_pub.ADD;
16563: log_error(l_api_name, 'execute_fetch_rule', 'Invalid Package, Contact your DBA - '

Line 16560: fnd_message.set_token('LIST_PKG', l_list_pkg);

16556: EXCEPTION
16557: WHEN INVALID_PKG_STATE THEN
16558: x_return_status := fnd_api.g_ret_sts_unexp_error;
16559: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');
16560: fnd_message.set_token('LIST_PKG', l_list_pkg);
16561: fnd_message.set_token('RULE_NAME', l_package_name);
16562: fnd_msg_pub.ADD;
16563: log_error(l_api_name, 'execute_fetch_rule', 'Invalid Package, Contact your DBA - '
16564: || l_list_pkg || ' / ' || l_package_name);

Line 16561: fnd_message.set_token('RULE_NAME', l_package_name);

16557: WHEN INVALID_PKG_STATE THEN
16558: x_return_status := fnd_api.g_ret_sts_unexp_error;
16559: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');
16560: fnd_message.set_token('LIST_PKG', l_list_pkg);
16561: fnd_message.set_token('RULE_NAME', l_package_name);
16562: fnd_msg_pub.ADD;
16563: log_error(l_api_name, 'execute_fetch_rule', 'Invalid Package, Contact your DBA - '
16564: || l_list_pkg || ' / ' || l_package_name);
16565: