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 1202: l_error_string := fnd_message.get;

1198: retcode := 1;
1199:
1200: FOR i IN 1 .. l_msg_count LOOP
1201: --fnd_file.put_line(fnd_file.LOG, 'Error:');
1202: l_error_string := fnd_message.get;
1203: --fnd_file.put_line(fnd_file.LOG, l_error_string);
1204: errbuf := errbuf || ' Error: GenerateRuleExecPkgs ' || l_error_string;
1205: END LOOP;
1206: END IF;

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

2285: l_outer_join := NULL;
2286: END IF;
2287: ELSE
2288: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2289: fnd_message.set_name('WMS', 'WMS_BAD_CONTEXT_DEPT_FLAG');
2290: fnd_message.set_token('CONTEXT_DEPENDENT_FLAG', l_context_dependent_flag);
2291: log_error_msg(l_api_name, 'bad_context_depend_flag');
2292: fnd_msg_pub.ADD;
2293: END IF;

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

2286: END IF;
2287: ELSE
2288: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2289: fnd_message.set_name('WMS', 'WMS_BAD_CONTEXT_DEPT_FLAG');
2290: fnd_message.set_token('CONTEXT_DEPENDENT_FLAG', l_context_dependent_flag);
2291: log_error_msg(l_api_name, 'bad_context_depend_flag');
2292: fnd_msg_pub.ADD;
2293: END IF;
2294:

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

2309: ELSIF l_parent_parameter_type_code = 2 THEN
2310: g_rule_where := g_rule_where || ' NVL(' || l_table_alias || '.' || l_column_name || ','|| l_left_part_conv_fct || l_parent_expression|| l_right_part_conv_fct || ') ';
2311: ELSE
2312: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2313: fnd_message.set_name('WMS', 'WMS_BAD_PARENT_PARA_TYPE');
2314: fnd_message.set_token('PARENT_PARAMETER_TYPE_CODE', l_parent_parameter_type_code);
2315: log_error_msg(l_api_name, 'bad_parent_param_type_joins');
2316: fnd_msg_pub.ADD;
2317: END IF;

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

2310: g_rule_where := g_rule_where || ' NVL(' || l_table_alias || '.' || l_column_name || ','|| l_left_part_conv_fct || l_parent_expression|| l_right_part_conv_fct || ') ';
2311: ELSE
2312: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2313: fnd_message.set_name('WMS', 'WMS_BAD_PARENT_PARA_TYPE');
2314: fnd_message.set_token('PARENT_PARAMETER_TYPE_CODE', l_parent_parameter_type_code);
2315: log_error_msg(l_api_name, 'bad_parent_param_type_joins');
2316: fnd_msg_pub.ADD;
2317: END IF;
2318: RAISE fnd_api.g_exc_error;

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

2326: --g_rule_where := g_rule_where || l_expression || l_outer_join;
2327: g_rule_where := g_rule_where || l_expression ; -- || l_outer_join; --Bug #3719043
2328: ELSE
2329: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2330: fnd_message.set_name('WMS', 'WMS_BAD_PARAMETER_TYPE_CODE');
2331: fnd_message.set_token('PARAMETER_TYPE_CODE', l_parameter_type_code);
2332: log_error_msg(l_api_name, 'bad_param_type_code_joins');
2333: fnd_msg_pub.ADD;
2334: END IF;

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

2327: g_rule_where := g_rule_where || l_expression ; -- || l_outer_join; --Bug #3719043
2328: ELSE
2329: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2330: fnd_message.set_name('WMS', 'WMS_BAD_PARAMETER_TYPE_CODE');
2331: fnd_message.set_token('PARAMETER_TYPE_CODE', l_parameter_type_code);
2332: log_error_msg(l_api_name, 'bad_param_type_code_joins');
2333: fnd_msg_pub.ADD;
2334: END IF;
2335:

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

2360: ELSIF l_parent_parameter_type_code = 2 THEN
2361: g_rule_where := g_rule_where || l_parent_expression;
2362: ELSE
2363: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2364: fnd_message.set_name('WMS', 'WMS_BAD_PARENT_PARA_TYPE');
2365: fnd_message.set_token('PARENT_PARAMETER_TYPE_CODE', l_parent_parameter_type_code);
2366: log_error_msg(l_api_name, 'bad_parent_param_type_joins');
2367: fnd_msg_pub.ADD;
2368: END IF;

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

2361: g_rule_where := g_rule_where || l_parent_expression;
2362: ELSE
2363: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2364: fnd_message.set_name('WMS', 'WMS_BAD_PARENT_PARA_TYPE');
2365: fnd_message.set_token('PARENT_PARAMETER_TYPE_CODE', l_parent_parameter_type_code);
2366: log_error_msg(l_api_name, 'bad_parent_param_type_joins');
2367: fnd_msg_pub.ADD;
2368: END IF;
2369:

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

2406: IF qtyfnct%NOTFOUND THEN
2407: CLOSE qtyfnct;
2408:
2409: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2410: fnd_message.set_name('WMS', 'WMS_QTY_FUNC_NOT_FOUND');
2411: log_error_msg(l_api_name, 'qty_func_not_found');
2412: fnd_msg_pub.ADD;
2413: END IF;
2414:

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

2424: log_statement(l_api_name, 'table_alias_qty', 'table_alias: ' || l_table_alias);
2425:
2426: IF l_data_type_code <> 1 THEN
2427: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2428: fnd_message.set_name('WMS', 'WMS_BAD_QTY_FUNC_DATA_TYPE');
2429: fnd_message.set_token('DATATYPE', l_data_type_code);
2430: log_error_msg(l_api_name, 'bad_qty_func_data_type');
2431: fnd_msg_pub.ADD;
2432: END IF;

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

2425:
2426: IF l_data_type_code <> 1 THEN
2427: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2428: fnd_message.set_name('WMS', 'WMS_BAD_QTY_FUNC_DATA_TYPE');
2429: fnd_message.set_token('DATATYPE', l_data_type_code);
2430: log_error_msg(l_api_name, 'bad_qty_func_data_type');
2431: fnd_msg_pub.ADD;
2432: END IF;
2433:

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

2472: || ',base.grade_code ' || g_line_feed; -- new
2473: END IF;
2474: ELSE
2475: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2476: fnd_message.set_name('WMS', 'WMS_BAD_PARAMETER_TYPE_CODE');
2477: fnd_message.set_token('PARAMETER_TYPE_CODE', l_parameter_type_code);
2478: log_error_msg(l_api_name, 'bad_param_type_code_qty');
2479: fnd_msg_pub.ADD;
2480: END IF;

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

2473: END IF;
2474: ELSE
2475: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2476: fnd_message.set_name('WMS', 'WMS_BAD_PARAMETER_TYPE_CODE');
2477: fnd_message.set_token('PARAMETER_TYPE_CODE', l_parameter_type_code);
2478: log_error_msg(l_api_name, 'bad_param_type_code_qty');
2479: fnd_msg_pub.ADD;
2480: END IF;
2481:

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

2561: || l_operator
2562: || ' ';
2563: ELSE
2564: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2565: fnd_message.set_name('WMS', 'WMS_BAD_PARAMETER_TYPE_CODE');
2566: fnd_message.set_token('PARAMETER_TYPE_CODE', l_parameter_type_code);
2567: log_error_msg(l_api_name, 'bad_param_type_code_left_rest');
2568: fnd_msg_pub.ADD;
2569: END IF;

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

2562: || ' ';
2563: ELSE
2564: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2565: fnd_message.set_name('WMS', 'WMS_BAD_PARAMETER_TYPE_CODE');
2566: fnd_message.set_token('PARAMETER_TYPE_CODE', l_parameter_type_code);
2567: log_error_msg(l_api_name, 'bad_param_type_code_left_rest');
2568: fnd_msg_pub.ADD;
2569: END IF;
2570:

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

2654: || l_bracket_close
2655: || g_line_feed;
2656: ELSE
2657: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2658: fnd_message.set_name('WMS', 'WMS_BAD_PARENT_PARA_TYPE');
2659: fnd_message.set_token('PARENT_PARAMETER_TYPE_CODE', l_parent_parameter_type_code);
2660: log_error_msg(l_api_name, 'bad_parent_param_type_right_rest');
2661: fnd_msg_pub.ADD;
2662: END IF;

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

2655: || g_line_feed;
2656: ELSE
2657: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2658: fnd_message.set_name('WMS', 'WMS_BAD_PARENT_PARA_TYPE');
2659: fnd_message.set_token('PARENT_PARAMETER_TYPE_CODE', l_parent_parameter_type_code);
2660: log_error_msg(l_api_name, 'bad_parent_param_type_right_rest');
2661: fnd_msg_pub.ADD;
2662: END IF;
2663:

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

2701: || l_bracket_close
2702: || g_line_feed;
2703: ELSE
2704: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2705: fnd_message.set_name('WMS', 'WMS_BAD_REF_FLEXVSET_DATA');
2706: fnd_message.set_token('DATATYPE', l_validation_type);
2707: log_error_msg(l_api_name, 'bad_ref_flexvset_data');
2708: fnd_msg_pub.ADD;
2709: END IF;

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

2702: || g_line_feed;
2703: ELSE
2704: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2705: fnd_message.set_name('WMS', 'WMS_BAD_REF_FLEXVSET_DATA');
2706: fnd_message.set_token('DATATYPE', l_validation_type);
2707: log_error_msg(l_api_name, 'bad_ref_flexvset_data');
2708: fnd_msg_pub.ADD;
2709: END IF;
2710:

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

2713: ELSIF l_operand_type_code = 7 THEN -- right side = nothing
2714: g_rule_where := g_rule_where || l_bracket_close || g_line_feed;
2715: ELSE
2716: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2717: fnd_message.set_name('WMS', 'WMS_BAD_OPERAND_TYPE_CODE');
2718: fnd_message.set_token('OPERAND_TYPE_CODE', l_operand_type_code);
2719: fnd_msg_pub.ADD;
2720: END IF;
2721:

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

2714: g_rule_where := g_rule_where || l_bracket_close || g_line_feed;
2715: ELSE
2716: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2717: fnd_message.set_name('WMS', 'WMS_BAD_OPERAND_TYPE_CODE');
2718: fnd_message.set_token('OPERAND_TYPE_CODE', l_operand_type_code);
2719: fnd_msg_pub.ADD;
2720: END IF;
2721:
2722: RAISE fnd_api.g_exc_error;

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

2951: g_rule_group_by_new := g_rule_group_by_new || ',' || l_expression; -- Added for Bug 13448337
2952: END IF;
2953: ELSE
2954: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2955: fnd_message.set_name('WMS', 'WMS_BAD_PARAMETER_TYPE_CODE');
2956: fnd_message.set_token('OPERAND_TYPE_CODE', l_parameter_type_code);
2957: log_error_msg(l_api_name, 'bad_param_type_code_sort');
2958: fnd_msg_pub.ADD;
2959: END IF;

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

2952: END IF;
2953: ELSE
2954: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2955: fnd_message.set_name('WMS', 'WMS_BAD_PARAMETER_TYPE_CODE');
2956: fnd_message.set_token('OPERAND_TYPE_CODE', l_parameter_type_code);
2957: log_error_msg(l_api_name, 'bad_param_type_code_sort');
2958: fnd_msg_pub.ADD;
2959: END IF;
2960:

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

3013:
3014: g_rule_group_by := g_rule_group_by || ',' || l_expression || g_line_feed;
3015: g_rule_group_by_new := g_rule_group_by_new || ',' || l_expression || g_line_feed; -- Added for Bug 13448337
3016: ELSE
3017: fnd_message.set_name('WMS', 'WMS_BAD_PARAMETER_TYPE_CODE');
3018: fnd_message.set_token('OPERAND_TYPE_CODE', l_parameter_type_code);
3019: log_error_msg(l_api_name, 'bad_param_type_code_consist');
3020: fnd_msg_pub.ADD;
3021: RAISE fnd_api.g_exc_error;

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

3014: g_rule_group_by := g_rule_group_by || ',' || l_expression || g_line_feed;
3015: g_rule_group_by_new := g_rule_group_by_new || ',' || l_expression || g_line_feed; -- Added for Bug 13448337
3016: ELSE
3017: fnd_message.set_name('WMS', 'WMS_BAD_PARAMETER_TYPE_CODE');
3018: fnd_message.set_token('OPERAND_TYPE_CODE', l_parameter_type_code);
3019: log_error_msg(l_api_name, 'bad_param_type_code_consist');
3020: fnd_msg_pub.ADD;
3021: RAISE fnd_api.g_exc_error;
3022: END IF;

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

3725: EXCEPTION
3726: WHEN INVALID_PKG_STATE THEN
3727: x_return_status := fnd_api.g_ret_sts_unexp_error;
3728:
3729: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');
3730: fnd_message.set_token('LIST_PKG', l_list_pkg);
3731: fnd_message.set_token('RULE_NAME', l_package_name);
3732: fnd_msg_pub.ADD;
3733: IF l_debug = 1 THEN

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

3726: WHEN INVALID_PKG_STATE THEN
3727: x_return_status := fnd_api.g_ret_sts_unexp_error;
3728:
3729: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');
3730: fnd_message.set_token('LIST_PKG', l_list_pkg);
3731: fnd_message.set_token('RULE_NAME', l_package_name);
3732: fnd_msg_pub.ADD;
3733: IF l_debug = 1 THEN
3734: log_error(l_api_name, 'execute_fetch_rule', 'Invalid Package, Contact your DBA - '

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

3727: x_return_status := fnd_api.g_ret_sts_unexp_error;
3728:
3729: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');
3730: fnd_message.set_token('LIST_PKG', l_list_pkg);
3731: fnd_message.set_token('RULE_NAME', l_package_name);
3732: fnd_msg_pub.ADD;
3733: IF l_debug = 1 THEN
3734: log_error(l_api_name, 'execute_fetch_rule', 'Invalid Package, Contact your DBA - '
3735: || l_list_pkg || ' / ' || l_package_name);

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

3886: --
3887: EXCEPTION
3888: WHEN INVALID_PKG_STATE THEN
3889: x_return_status := fnd_api.g_ret_sts_unexp_error;
3890: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');
3891: fnd_message.set_token('LIST_PKG', l_list_pkg);
3892: fnd_message.set_token('RULE_NAME', l_package_name);
3893: fnd_msg_pub.ADD;
3894:

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

3887: EXCEPTION
3888: WHEN INVALID_PKG_STATE THEN
3889: x_return_status := fnd_api.g_ret_sts_unexp_error;
3890: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');
3891: fnd_message.set_token('LIST_PKG', l_list_pkg);
3892: fnd_message.set_token('RULE_NAME', l_package_name);
3893: fnd_msg_pub.ADD;
3894:
3895: IF l_debug = 1 THEN

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

3888: WHEN INVALID_PKG_STATE THEN
3889: x_return_status := fnd_api.g_ret_sts_unexp_error;
3890: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');
3891: fnd_message.set_token('LIST_PKG', l_list_pkg);
3892: fnd_message.set_token('RULE_NAME', l_package_name);
3893: fnd_msg_pub.ADD;
3894:
3895: IF l_debug = 1 THEN
3896: log_error(l_api_name, 'execute_fetch_rule', 'Invalid Package, Contact your DBA - '

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

4062: x_result := 0;
4063: wms_rule_pvt.g_rule_list_pick_ctr := wms_rule_gen_pkgs.get_count_no_lock('PICK');
4064:
4065: WMS_ENGINE_PVT.G_SUGG_FAILURE_MESSAGE := 'Invalid Package, Contact your DBA - '|| l_list_pkg || ' / ' || l_package_name;
4066: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');
4067: fnd_message.set_token('LIST_PKG', l_list_pkg);
4068: fnd_message.set_token('RULE_NAME', l_package_name);
4069: fnd_msg_pub.ADD;
4070:

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

4063: wms_rule_pvt.g_rule_list_pick_ctr := wms_rule_gen_pkgs.get_count_no_lock('PICK');
4064:
4065: WMS_ENGINE_PVT.G_SUGG_FAILURE_MESSAGE := 'Invalid Package, Contact your DBA - '|| l_list_pkg || ' / ' || l_package_name;
4066: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');
4067: fnd_message.set_token('LIST_PKG', l_list_pkg);
4068: fnd_message.set_token('RULE_NAME', l_package_name);
4069: fnd_msg_pub.ADD;
4070:
4071: IF l_debug = 1 THEN

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

4064:
4065: WMS_ENGINE_PVT.G_SUGG_FAILURE_MESSAGE := 'Invalid Package, Contact your DBA - '|| l_list_pkg || ' / ' || l_package_name;
4066: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');
4067: fnd_message.set_token('LIST_PKG', l_list_pkg);
4068: fnd_message.set_token('RULE_NAME', l_package_name);
4069: fnd_msg_pub.ADD;
4070:
4071: IF l_debug = 1 THEN
4072: log_error(l_api_name, 'execute_open_rule', 'Invalid Package, Contact your DBA - '

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

4179: x_result := 0;
4180: wms_rule_pvt.g_rule_list_put_ctr := wms_rule_gen_pkgs.get_count_no_lock('PUTAWAY');
4181:
4182: WMS_ENGINE_PVT.G_SUGG_FAILURE_MESSAGE := 'Invalid Package, Contact your DBA - '|| l_list_pkg || ' / ' || l_package_name;
4183: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');
4184: fnd_message.set_token('LIST_PKG', l_list_pkg);
4185: fnd_message.set_token('RULE_NAME', l_package_name);
4186: fnd_msg_pub.ADD;
4187:

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

4180: wms_rule_pvt.g_rule_list_put_ctr := wms_rule_gen_pkgs.get_count_no_lock('PUTAWAY');
4181:
4182: WMS_ENGINE_PVT.G_SUGG_FAILURE_MESSAGE := 'Invalid Package, Contact your DBA - '|| l_list_pkg || ' / ' || l_package_name;
4183: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');
4184: fnd_message.set_token('LIST_PKG', l_list_pkg);
4185: fnd_message.set_token('RULE_NAME', l_package_name);
4186: fnd_msg_pub.ADD;
4187:
4188: IF l_debug = 1 THEN

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

4181:
4182: WMS_ENGINE_PVT.G_SUGG_FAILURE_MESSAGE := 'Invalid Package, Contact your DBA - '|| l_list_pkg || ' / ' || l_package_name;
4183: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');
4184: fnd_message.set_token('LIST_PKG', l_list_pkg);
4185: fnd_message.set_token('RULE_NAME', l_package_name);
4186: fnd_msg_pub.ADD;
4187:
4188: IF l_debug = 1 THEN
4189: log_error(l_api_name, 'execute_open_rule', 'Invalid Package, Contact your DBA - '

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

4231: x_return_status := -1 ;
4232: wms_rule_pvt.g_rule_list_op_ctr := wms_rule_gen_pkgs.get_count_no_lock('OPERATION_PLAN');
4233: WMS_ENGINE_PVT.G_SUGG_FAILURE_MESSAGE := 'Invalid Package, Contact your DBA - '|| l_list_pkg || ' / ' || l_package_name;
4234: x_return_status := fnd_api.g_ret_sts_unexp_error;
4235: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');
4236: fnd_message.set_token('LIST_PKG', l_list_pkg);
4237: fnd_message.set_token('RULE_NAME', l_package_name);
4238: fnd_msg_pub.ADD;
4239: /*log_error(l_api_name, 'execute_op_rule', 'Invalid Package, Contact your DBA - '

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

4232: wms_rule_pvt.g_rule_list_op_ctr := wms_rule_gen_pkgs.get_count_no_lock('OPERATION_PLAN');
4233: WMS_ENGINE_PVT.G_SUGG_FAILURE_MESSAGE := 'Invalid Package, Contact your DBA - '|| l_list_pkg || ' / ' || l_package_name;
4234: x_return_status := fnd_api.g_ret_sts_unexp_error;
4235: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');
4236: fnd_message.set_token('LIST_PKG', l_list_pkg);
4237: fnd_message.set_token('RULE_NAME', l_package_name);
4238: fnd_msg_pub.ADD;
4239: /*log_error(l_api_name, 'execute_op_rule', 'Invalid Package, Contact your DBA - '
4240: || l_list_pkg || ' / ' || l_package_name); */

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

4233: WMS_ENGINE_PVT.G_SUGG_FAILURE_MESSAGE := 'Invalid Package, Contact your DBA - '|| l_list_pkg || ' / ' || l_package_name;
4234: x_return_status := fnd_api.g_ret_sts_unexp_error;
4235: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');
4236: fnd_message.set_token('LIST_PKG', l_list_pkg);
4237: fnd_message.set_token('RULE_NAME', l_package_name);
4238: fnd_msg_pub.ADD;
4239: /*log_error(l_api_name, 'execute_op_rule', 'Invalid Package, Contact your DBA - '
4240: || l_list_pkg || ' / ' || l_package_name); */
4241: END execute_op_rule;

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

4281: x_return_status := -1 ;
4282: wms_rule_pvt.g_rule_list_task_ctr := wms_rule_gen_pkgs.get_count_no_lock('TASK');
4283: WMS_ENGINE_PVT.G_SUGG_FAILURE_MESSAGE := 'Invalid Package, Contact your DBA - '|| l_list_pkg || ' / ' || l_package_name;
4284: x_return_status := fnd_api.g_ret_sts_unexp_error;
4285: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');
4286: fnd_message.set_token('LIST_PKG', l_list_pkg);
4287: fnd_message.set_token('RULE_NAME', l_package_name);
4288: fnd_msg_pub.ADD;
4289: /*log_error(l_api_name, 'execute_task_rule', 'Invalid Package, Contact your DBA - '

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

4282: wms_rule_pvt.g_rule_list_task_ctr := wms_rule_gen_pkgs.get_count_no_lock('TASK');
4283: WMS_ENGINE_PVT.G_SUGG_FAILURE_MESSAGE := 'Invalid Package, Contact your DBA - '|| l_list_pkg || ' / ' || l_package_name;
4284: x_return_status := fnd_api.g_ret_sts_unexp_error;
4285: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');
4286: fnd_message.set_token('LIST_PKG', l_list_pkg);
4287: fnd_message.set_token('RULE_NAME', l_package_name);
4288: fnd_msg_pub.ADD;
4289: /*log_error(l_api_name, 'execute_task_rule', 'Invalid Package, Contact your DBA - '
4290: || l_list_pkg || ' / ' || l_package_name); */

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

4283: WMS_ENGINE_PVT.G_SUGG_FAILURE_MESSAGE := 'Invalid Package, Contact your DBA - '|| l_list_pkg || ' / ' || l_package_name;
4284: x_return_status := fnd_api.g_ret_sts_unexp_error;
4285: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');
4286: fnd_message.set_token('LIST_PKG', l_list_pkg);
4287: fnd_message.set_token('RULE_NAME', l_package_name);
4288: fnd_msg_pub.ADD;
4289: /*log_error(l_api_name, 'execute_task_rule', 'Invalid Package, Contact your DBA - '
4290: || l_list_pkg || ' / ' || l_package_name); */
4291:

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

4334: x_return_status := -1 ;
4335: wms_rule_pvt.g_rule_list_label_ctr := wms_rule_gen_pkgs.get_count_no_lock('LABEL');
4336: WMS_ENGINE_PVT.G_SUGG_FAILURE_MESSAGE := 'Invalid Package, Contact your DBA - '|| l_list_pkg || ' / ' || l_package_name;
4337: x_return_status := fnd_api.g_ret_sts_unexp_error;
4338: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');
4339: fnd_message.set_token('LIST_PKG', l_list_pkg);
4340: fnd_message.set_token('RULE_NAME', l_package_name);
4341: fnd_msg_pub.ADD;
4342: /*log_error(l_api_name, 'execute_label_rule', 'Invalid Package, Contact your DBA - '

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

4335: wms_rule_pvt.g_rule_list_label_ctr := wms_rule_gen_pkgs.get_count_no_lock('LABEL');
4336: WMS_ENGINE_PVT.G_SUGG_FAILURE_MESSAGE := 'Invalid Package, Contact your DBA - '|| l_list_pkg || ' / ' || l_package_name;
4337: x_return_status := fnd_api.g_ret_sts_unexp_error;
4338: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');
4339: fnd_message.set_token('LIST_PKG', l_list_pkg);
4340: fnd_message.set_token('RULE_NAME', l_package_name);
4341: fnd_msg_pub.ADD;
4342: /*log_error(l_api_name, 'execute_label_rule', 'Invalid Package, Contact your DBA - '
4343: || l_list_pkg || ' / ' || l_package_name); */

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

4336: WMS_ENGINE_PVT.G_SUGG_FAILURE_MESSAGE := 'Invalid Package, Contact your DBA - '|| l_list_pkg || ' / ' || l_package_name;
4337: x_return_status := fnd_api.g_ret_sts_unexp_error;
4338: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');
4339: fnd_message.set_token('LIST_PKG', l_list_pkg);
4340: fnd_message.set_token('RULE_NAME', l_package_name);
4341: fnd_msg_pub.ADD;
4342: /*log_error(l_api_name, 'execute_label_rule', 'Invalid Package, Contact your DBA - '
4343: || l_list_pkg || ' / ' || l_package_name); */
4344:

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

4376:
4377: EXCEPTION
4378: WHEN INVALID_PKG_STATE THEN
4379: /* -- WMS_ENGINE_PVT.G_SUGG_FAILURE_MESSAGE := 'Invalid Package, Contact your DBA - '|| l_list_pkg || ' / ' || l_package_name;
4380: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');
4381: fnd_message.set_token('LIST_PKG', l_list_pkg);
4382: fnd_message.set_token('RULE_NAME', l_package_name);
4383: fnd_msg_pub.ADD;
4384: log_error(l_api_name, 'execute_close_rule', 'Invalid Package, Contact your DBA - '

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

4377: EXCEPTION
4378: WHEN INVALID_PKG_STATE THEN
4379: /* -- WMS_ENGINE_PVT.G_SUGG_FAILURE_MESSAGE := 'Invalid Package, Contact your DBA - '|| l_list_pkg || ' / ' || l_package_name;
4380: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');
4381: fnd_message.set_token('LIST_PKG', l_list_pkg);
4382: fnd_message.set_token('RULE_NAME', l_package_name);
4383: fnd_msg_pub.ADD;
4384: log_error(l_api_name, 'execute_close_rule', 'Invalid Package, Contact your DBA - '
4385: || l_list_pkg || ' / ' || l_package_name); */

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

4378: WHEN INVALID_PKG_STATE THEN
4379: /* -- WMS_ENGINE_PVT.G_SUGG_FAILURE_MESSAGE := 'Invalid Package, Contact your DBA - '|| l_list_pkg || ' / ' || l_package_name;
4380: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');
4381: fnd_message.set_token('LIST_PKG', l_list_pkg);
4382: fnd_message.set_token('RULE_NAME', l_package_name);
4383: fnd_msg_pub.ADD;
4384: log_error(l_api_name, 'execute_close_rule', 'Invalid Package, Contact your DBA - '
4385: || l_list_pkg || ' / ' || l_package_name); */
4386: RAISE fnd_api.g_exc_unexpected_error;

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

4413:
4414: EXCEPTION
4415: WHEN INVALID_PKG_STATE THEN
4416: /*WMS_ENGINE_PVT.G_SUGG_FAILURE_MESSAGE := 'Invalid Package, Contact your DBA - '|| l_list_pkg || ' / ' || l_package_name;
4417: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');
4418: fnd_message.set_token('LIST_PKG', l_list_pkg);
4419: fnd_message.set_token('RULE_NAME', l_package_name);
4420: fnd_msg_pub.ADD;
4421: log_error(l_api_name, 'execute_close_rule', 'Invalid Package, Contact your DBA - '

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

4414: EXCEPTION
4415: WHEN INVALID_PKG_STATE THEN
4416: /*WMS_ENGINE_PVT.G_SUGG_FAILURE_MESSAGE := 'Invalid Package, Contact your DBA - '|| l_list_pkg || ' / ' || l_package_name;
4417: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');
4418: fnd_message.set_token('LIST_PKG', l_list_pkg);
4419: fnd_message.set_token('RULE_NAME', l_package_name);
4420: fnd_msg_pub.ADD;
4421: log_error(l_api_name, 'execute_close_rule', 'Invalid Package, Contact your DBA - '
4422: || l_list_pkg || ' / ' || l_package_name);*/

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

4415: WHEN INVALID_PKG_STATE THEN
4416: /*WMS_ENGINE_PVT.G_SUGG_FAILURE_MESSAGE := 'Invalid Package, Contact your DBA - '|| l_list_pkg || ' / ' || l_package_name;
4417: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');
4418: fnd_message.set_token('LIST_PKG', l_list_pkg);
4419: fnd_message.set_token('RULE_NAME', l_package_name);
4420: fnd_msg_pub.ADD;
4421: log_error(l_api_name, 'execute_close_rule', 'Invalid Package, Contact your DBA - '
4422: || l_list_pkg || ' / ' || l_package_name);*/
4423: RAISE fnd_api.g_exc_unexpected_error;

Line 5036: FND_MESSAGE.SET_NAME('INV','INV_NO_CONVERSION_ERR');

5032: IF (l_lot_allocation_quantity = -99999) THEN
5033: IF l_debug = 1 THEN
5034: log_statement(l_api_name, 'lot uom conversion error','');
5035: END IF;
5036: FND_MESSAGE.SET_NAME('INV','INV_NO_CONVERSION_ERR');
5037: fnd_msg_pub.ADD;
5038: RAISE FND_API.G_EXC_ERROR;
5039: END IF;
5040: IF l_debug = 1 THEN

Line 5125: FND_MESSAGE.SET_NAME('INV','INV_NO_CONVERSION_ERR');

5121: IF (l_lot_allocation_quantity = -99999) THEN
5122: IF l_debug = 1 THEN
5123: log_statement(l_api_name, 'lot uom conversion error','');
5124: END IF;
5125: FND_MESSAGE.SET_NAME('INV','INV_NO_CONVERSION_ERR');
5126: fnd_msg_pub.ADD;
5127: RAISE FND_API.G_EXC_ERROR;
5128: END IF;
5129: l_allocation_quantity := l_lot_allocation_quantity;

Line 5173: FND_MESSAGE.SET_NAME('INV','INV_NO_CONVERSION_ERR');

5169: ELSE
5170: IF l_debug = 1 THEN
5171: log_error(l_api_name,'validate and insert','UOM conversion error');
5172: END IF;
5173: FND_MESSAGE.SET_NAME('INV','INV_NO_CONVERSION_ERR');
5174: fnd_msg_pub.ADD;
5175: RAISE FND_API.G_EXC_ERROR;
5176: END IF;
5177: END IF; --}

Line 5331: FND_MESSAGE.SET_NAME('INV','INV_NO_CONVERSION_ERR');

5327: IF (l_lot_sallocation_quantity = -99999) THEN
5328: IF l_debug = 1 THEN
5329: log_statement(l_api_name, '(2)lot uom conversion error','');
5330: END IF;
5331: FND_MESSAGE.SET_NAME('INV','INV_NO_CONVERSION_ERR');
5332: fnd_msg_pub.ADD;
5333: RAISE FND_API.G_EXC_ERROR;
5334: END IF;
5335: IF l_debug = 1 THEN

Line 5416: FND_MESSAGE.SET_NAME('INV','INV_NO_CONVERSION_ERR');

5412: IF (l_lot_sallocation_quantity = -99999) THEN
5413: IF l_debug = 1 THEN
5414: log_statement(l_api_name, '(2)lot uom conversion error','');
5415: END IF;
5416: FND_MESSAGE.SET_NAME('INV','INV_NO_CONVERSION_ERR');
5417: fnd_msg_pub.ADD;
5418: RAISE FND_API.G_EXC_ERROR;
5419: END IF;
5420: l_sallocation_quantity := l_lot_sallocation_quantity;

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

8774: IF p_validation_level <> fnd_api.g_valid_level_none THEN
8775: IF p_type_code IS NULL
8776: OR p_type_code = fnd_api.g_miss_num THEN
8777: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
8778: fnd_message.set_name('WMS', 'WMS_RULE_TYPE_CODE_MISSING');
8779: fnd_msg_pub.ADD;
8780:
8781: IF l_debug = 1 THEN
8782: log_error_msg(l_api_name, 'type_code_missing');

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

8842:
8843: IF p_partial_success_allowed_flag IS NULL
8844: OR p_partial_success_allowed_flag = fnd_api.g_miss_char THEN
8845: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
8846: fnd_message.set_name('WMS', 'WMS_PARTIAL_SUCC_FLAG_MISS');
8847: IF l_debug = 1 THEN
8848: log_error_msg(l_api_name, 'partial_succ_flag_missing');
8849: END IF;
8850: fnd_msg_pub.ADD;

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

8854:
8855: IF p_transaction_temp_id IS NULL
8856: OR p_transaction_temp_id = fnd_api.g_miss_num THEN
8857: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
8858: fnd_message.set_name('WMS', 'WMS_TRX_REQ_LINE_ID_MISS');
8859: fnd_msg_pub.ADD;
8860: IF l_debug = 1 THEN
8861: log_error_msg(l_api_name, 'trx_req_line_id_missing');
8862: END IF;

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

8866:
8867: IF p_organization_id IS NULL
8868: OR p_organization_id = fnd_api.g_miss_num THEN
8869: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
8870: fnd_message.set_name('INV', 'INV_NO_ORG_INFORMATION');
8871: fnd_msg_pub.ADD;
8872: IF l_debug = 1 THEN
8873: log_error_msg(l_api_name, 'org_id_missing');
8874: END IF;

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

8879:
8880: IF p_inventory_item_id IS NULL
8881: OR p_inventory_item_id = fnd_api.g_miss_num THEN
8882: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
8883: fnd_message.set_name('INV', 'INV_ITEM_ID_REQUIRED');
8884: fnd_msg_pub.ADD;
8885: IF l_debug = 1 THEN
8886: log_error_msg(l_api_name, 'item_id_missing');
8887: END IF;

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

8895: OR p_tree_id = fnd_api.g_miss_num
8896: )
8897: THEN
8898: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
8899: fnd_message.set_name('INV', 'INV_QTY_TREE_ID_MISSING');
8900: fnd_msg_pub.ADD;
8901: IF l_debug = 1 THEN
8902: log_error_msg(l_api_name, 'qty_tree_id_missing');
8903: END IF;

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

9612: log_statement(l_api_name, 'open_curs_err', 'Error calling open_curs');
9613: log_error_msg(l_api_name, 'rule_package_missing');
9614: log_statement(l_api_name, 'pack_name', 'Package name: ' || l_package_name);
9615: END IF;
9616: fnd_message.set_name('WMS', 'WMS_PACKAGE_MISSING');
9617: fnd_message.set_token('RULEID', l_rule_id);
9618: fnd_msg_pub.ADD;
9619: RAISE fnd_api.g_exc_unexpected_error;
9620: END IF;

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

9613: log_error_msg(l_api_name, 'rule_package_missing');
9614: log_statement(l_api_name, 'pack_name', 'Package name: ' || l_package_name);
9615: END IF;
9616: fnd_message.set_name('WMS', 'WMS_PACKAGE_MISSING');
9617: fnd_message.set_token('RULEID', l_rule_id);
9618: fnd_msg_pub.ADD;
9619: RAISE fnd_api.g_exc_unexpected_error;
9620: END IF;
9621: END LOOP; --}

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

13638: x_return_status := fnd_api.g_ret_sts_success;
13639: RETURN l_locator_control;
13640: EXCEPTION
13641: WHEN invalid_loc_control_exception THEN
13642: fnd_message.set_name('INV','INV_INVALID_LOC_CONTROL');
13643: fnd_msg_pub.ADD;
13644: --
13645: x_return_status := fnd_api.g_ret_sts_error ;
13646: l_locator_control := -1 ;

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

13760: FETCH l_subinventory_code_csr INTO l_putaway_sub;
13761: IF l_subinventory_code_csr%notfound OR
13762: l_putaway_sub IS NULL THEN
13763: CLOSE l_subinventory_code_csr;
13764: fnd_message.set_name('INV','INV_NO_DEFAULT_SUB');
13765: fnd_msg_pub.ADD;
13766: RAISE fnd_api.g_exc_error;
13767: END IF;
13768: CLOSE l_subinventory_code_csr;

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

13775: -- now get the locator control and then determine if
13776: -- default locator needs to be selected from item defaults
13777: --
13778: IF NOT l_sub_found THEN
13779: fnd_message.set_name('INV','INV_NO_SUB_LOC_CONTROL');
13780: fnd_msg_pub.ADD;
13781: RAISE fnd_api.g_exc_error;
13782: END if;
13783:

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

13817: OPEN l_locator_csr;
13818: FETCH l_locator_csr INTO l_putaway_loc;
13819: IF l_locator_csr%notfound OR l_putaway_loc IS NULL THEN
13820: CLOSE l_locator_csr;
13821: fnd_message.set_name('INV','INV_NO_DEFAULT_LOC');
13822: fnd_msg_pub.ADD;
13823:
13824: RAISE fnd_api.g_exc_error;
13825: END IF;

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

13857:
13858: If l_putaway_cg IS NULL Then
13859: l_putaway_cg := l_putaway_cg_org;
13860: if l_putaway_cg IS NULL then
13861: fnd_message.set_name('INV','INV_NO_DEFAULT_COST_GROUP');
13862: fnd_msg_pub.ADD;
13863: RAISE fnd_api.g_exc_error;
13864: end if;
13865: End If;

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

14083: IF p_validation_level <> fnd_api.g_valid_level_none THEN
14084: IF p_transaction_temp_id IS NULL OR
14085: p_transaction_temp_id = fnd_api.g_miss_num THEN
14086: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
14087: fnd_message.set_name('WMS','WMS_TRX_REQ_LINE_ID_MISS');
14088: If (l_debug = 1) then
14089: log_error_msg(l_api_name, 'trx_req_line_id_missing');
14090: End if;
14091: fnd_msg_pub.add;

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

14094: END IF;
14095: IF p_organization_id IS NULL OR
14096: p_organization_id = fnd_api.g_miss_num THEN
14097: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
14098: fnd_message.set_name('INV','INV_NO_ORG_INFORMATION');
14099: If (l_debug = 1) then
14100: log_error_msg(l_api_name, 'org_id_missing');
14101: End if;
14102: fnd_msg_pub.add;

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

14105: END IF;
14106: IF p_inventory_item_id IS NULL OR
14107: p_inventory_item_id = fnd_api.g_miss_num THEN
14108: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
14109: fnd_message.set_name('INV','INV_ITEM_ID_REQUIRED');
14110: If (l_debug = 1) then
14111: log_error_msg(l_api_name, 'item_id_missing');
14112: End if;
14113: fnd_msg_pub.add;

Line 15033: fnd_message.set_name('FND', 'AD_ZD_DISABLED_FEATURE');

15029: x_return_status := fnd_api.g_ret_sts_unexp_error;
15030:
15031: if ad_zd.get_edition('PATCH') is not null then
15032: -- an online patch is in progress, return error
15033: fnd_message.set_name('FND', 'AD_ZD_DISABLED_FEATURE');
15034: -- bug#13565649 raise_application_error ('-20000', fnd_message.get);
15035: fnd_msg_pub.ADD; -- bug#13565649
15036: RAISE fnd_api.g_exc_error; -- bug#13565649
15037: end if;

Line 15034: -- bug#13565649 raise_application_error ('-20000', fnd_message.get);

15030:
15031: if ad_zd.get_edition('PATCH') is not null then
15032: -- an online patch is in progress, return error
15033: fnd_message.set_name('FND', 'AD_ZD_DISABLED_FEATURE');
15034: -- bug#13565649 raise_application_error ('-20000', fnd_message.get);
15035: fnd_msg_pub.ADD; -- bug#13565649
15036: RAISE fnd_api.g_exc_error; -- bug#13565649
15037: end if;
15038:

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

15201: IF p_validation_level <> fnd_api.g_valid_level_none THEN
15202: IF p_rule_id IS NULL
15203: OR p_rule_id = fnd_api.g_miss_num THEN
15204: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
15205: fnd_message.set_name('WMS', 'WMS_RULE_ID_MISSING');
15206: log_error_msg(l_api_name, 'rule_id_missing');
15207: fnd_msg_pub.ADD;
15208: END IF;
15209:

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

16320: --
16321:
16322: /*
16323: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
16324: fnd_message.set_name('WMS','WMS_SYNTAX_CHECK_SUCCESS');
16325: fnd_msg_pub.add;
16326: END IF;
16327: */ --
16328: -- end of debugging section

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

16370: DBMS_SQL.close_cursor(l_cursor);
16371: END IF;
16372:
16373: freeglobals;
16374: fnd_message.set_name('WMS', 'WMS_PACKAGE_GEN_FAILED');
16375: fnd_msg_pub.ADD;
16376: x_return_status := fnd_api.g_ret_sts_unexp_error;
16377: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
16378: log_error(l_api_name, 'unexp_error', 'Unexpected error - ' || x_msg_data);

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

16399: DBMS_SQL.close_cursor(l_cursor);
16400: END IF;
16401:
16402: freeglobals;
16403: fnd_message.set_name('WMS', 'WMS_PACKAGE_GEN_FAILED');
16404: fnd_msg_pub.ADD;
16405: x_return_status := fnd_api.g_ret_sts_unexp_error;
16406:
16407: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

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

16648: --- Execute op Rule
16649: For l_rule_counter IN 1..2 LOOP
16650: execute_op_rule(l_rule_id, p_task_id, l_return_status);
16651: IF (l_return_status = -1) and l_rule_counter = 2 THEN --error
16652: fnd_message.set_name('WMS', 'WMS_PACKAGE_MISSING');
16653: fnd_message.set_token('RULEID', l_rule_id);
16654: fnd_msg_pub.ADD;
16655: log_error_msg(l_api_name, 'rule_package_missing');
16656: log_statement(l_api_name, 'pack_name', 'Package name: ' || l_package_name);

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

16649: For l_rule_counter IN 1..2 LOOP
16650: execute_op_rule(l_rule_id, p_task_id, l_return_status);
16651: IF (l_return_status = -1) and l_rule_counter = 2 THEN --error
16652: fnd_message.set_name('WMS', 'WMS_PACKAGE_MISSING');
16653: fnd_message.set_token('RULEID', l_rule_id);
16654: fnd_msg_pub.ADD;
16655: log_error_msg(l_api_name, 'rule_package_missing');
16656: log_statement(l_api_name, 'pack_name', 'Package name: ' || l_package_name);
16657: RAISE fnd_api.g_exc_unexpected_error;

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

17031: log_error(l_api_name, 'Assigntt', 'Calling execute_Task :p_Tas k_id ' || p_task_id);
17032: END IF;
17033: execute_task_rule(l_rule_id, p_task_id, l_return_status);
17034: IF (l_return_status = -1) and l_rule_counter = 2 THEN --error
17035: fnd_message.set_name('WMS', 'WMS_PACKAGE_MISSING');
17036: fnd_message.set_token('RULEID', l_rule_id);
17037: fnd_msg_pub.ADD;
17038: IF l_debug = 1 THEN
17039: log_error_msg(l_api_name, 'rule_package_missing');

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

17032: END IF;
17033: execute_task_rule(l_rule_id, p_task_id, l_return_status);
17034: IF (l_return_status = -1) and l_rule_counter = 2 THEN --error
17035: fnd_message.set_name('WMS', 'WMS_PACKAGE_MISSING');
17036: fnd_message.set_token('RULEID', l_rule_id);
17037: fnd_msg_pub.ADD;
17038: IF l_debug = 1 THEN
17039: log_error_msg(l_api_name, 'rule_package_missing');
17040: log_statement(l_api_name, 'pack_name', 'Package name: ' || l_package_name);

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

17372: CLOSE l_label_requests_curs;
17373: IF l_debug = 1 THEN
17374: TRACE('Invalid Label Request Id : '|| p_label_request_id);
17375: END IF;
17376: fnd_message.set_name('WMS', 'INVALID_LABEL_REQ');
17377: fnd_msg_pub.ADD;
17378: RAISE fnd_api.g_exc_error;
17379: END IF;
17380:

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

17404: log_statement(l_api_name, 'Inside Loop', 'l_return_status' || l_return_status);
17405: END IF;
17406: log_statement(l_api_name, 'pack_name', 'Package name: ' || l_package_name);
17407: IF (l_return_status = -1) and l_rule_counter = 2 THEN --error
17408: fnd_message.set_name('WMS', 'WMS_PACKAGE_MISSING');
17409: fnd_message.set_token('RULEID', l_rule_id);
17410: fnd_msg_pub.ADD;
17411: IF l_debug = 1 THEN
17412: log_error_msg(l_api_name, 'rule_package_missing');

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

17405: END IF;
17406: log_statement(l_api_name, 'pack_name', 'Package name: ' || l_package_name);
17407: IF (l_return_status = -1) and l_rule_counter = 2 THEN --error
17408: fnd_message.set_name('WMS', 'WMS_PACKAGE_MISSING');
17409: fnd_message.set_token('RULEID', l_rule_id);
17410: fnd_msg_pub.ADD;
17411: IF l_debug = 1 THEN
17412: log_error_msg(l_api_name, 'rule_package_missing');
17413: log_error(l_api_name, 'Rule missing in the list pkg', 'l_rule_id ' || l_rule_id);

Line 17561: fnd_message.set_name('FND', 'AD_ZD_DISABLED_FEATURE');

17557:
17558: /* Adding for bug#13565649*/
17559: IF ad_zd.get_edition('PATCH') IS NOT NULL THEN
17560: -- an online patch is in progress, return error
17561: fnd_message.set_name('FND', 'AD_ZD_DISABLED_FEATURE');
17562: retcode := 2;
17563: errbuf := errbuf || 'Error: ' || fnd_message.get;
17564: --inv_log_util.trace( 'errbuf : '||errbuf ,'compile_all_rule_packages' , 9);
17565: RETURN;

Line 17563: errbuf := errbuf || 'Error: ' || fnd_message.get;

17559: IF ad_zd.get_edition('PATCH') IS NOT NULL THEN
17560: -- an online patch is in progress, return error
17561: fnd_message.set_name('FND', 'AD_ZD_DISABLED_FEATURE');
17562: retcode := 2;
17563: errbuf := errbuf || 'Error: ' || fnd_message.get;
17564: --inv_log_util.trace( 'errbuf : '||errbuf ,'compile_all_rule_packages' , 9);
17565: RETURN;
17566: END IF;
17567:

Line 17599: l_error_string := fnd_message.get;

17595: retcode := 1;
17596:
17597: FOR i IN 1 .. l_msg_count LOOP
17598: --fnd_file.put_line(fnd_file.LOG, 'Error:');
17599: l_error_string := fnd_message.get;
17600: --fnd_file.put_line(fnd_file.LOG, l_error_string);
17601: errbuf := errbuf || ' Error: Rule ' || l_rule_id || '
17602: ' || l_error_string;
17603: END LOOP;

Line 17619: l_error_string := fnd_message.get;

17615: retcode := 1;
17616:
17617: FOR i IN 1 .. l_msg_count LOOP
17618: --fnd_file.put_line(fnd_file.LOG, 'Error:');
17619: l_error_string := fnd_message.get;
17620: --fnd_file.put_line(fnd_file.LOG, l_error_string);
17621: errbuf := errbuf || ' Error: Creating WMS Rule List Package ' || l_error_string;
17622: END LOOP;
17623: END IF;

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

17801: IF p_type_code IS NULL
17802: OR p_type_code = fnd_api.g_miss_num
17803: OR p_type_code = 1 THEN
17804: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
17805: fnd_message.set_name('WMS', 'WMS_RULE_TYPE_CODE_MISSING');
17806: log_error_msg(l_api_name, 'type_code_missing');
17807: fnd_msg_pub.ADD;
17808: END IF;
17809: RAISE fnd_api.g_exc_error;

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

17816:
17817: IF p_transaction_temp_id IS NULL
17818: OR p_transaction_temp_id = fnd_api.g_miss_num THEN
17819: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
17820: fnd_message.set_name('WMS', 'WMS_TRX_REQ_LINE_ID_MISS');
17821: log_error_msg(l_api_name, 'trx_req_line_id_missing');
17822: fnd_msg_pub.ADD;
17823: END IF;
17824:

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

17832:
17833: IF p_organization_id IS NULL
17834: OR p_organization_id = fnd_api.g_miss_num THEN
17835: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
17836: fnd_message.set_name('INV', 'INV_NO_ORG_INFORMATION');
17837: log_error_msg(l_api_name, 'org_id_missing');
17838: fnd_msg_pub.ADD;
17839: END IF;
17840:

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

17848:
17849: IF p_inventory_item_id IS NULL
17850: OR p_inventory_item_id = fnd_api.g_miss_num THEN
17851: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
17852: fnd_message.set_name('INV', 'INV_ITEM_ID_REQUIRED');
17853: log_error_msg(l_api_name, 'item_id_missing');
17854: fnd_msg_pub.ADD;
17855: END IF;
17856:

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

17865: IF (p_tree_id IS NULL
17866: OR p_tree_id = fnd_api.g_miss_num
17867: ) THEN
17868: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
17869: fnd_message.set_name('INV', 'INV_QTY_TREE_ID_MISSING');
17870: log_error_msg(l_api_name, 'qty_tree_id_missing');
17871: fnd_msg_pub.ADD;
17872: END IF;
17873:

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

17995: , p_locator_id => l_from_locator_id
17996: , p_lot_number => l_lot_number );
17997: IF ( l_allowed = 'N') then
17998: WMS_ENGINE_PVT.G_SUGG_FAILURE_MESSAGE := 'WMS_ATT_SUB_STATUS_NA';
17999: fnd_message.set_name('WMS', 'WMS_ATT_SUB_STATUS_NA');
18000: fnd_msg_pub.ADD;
18001: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
18002: IF l_debug = 1 THEN
18003: log_error_msg(l_api_name, x_msg_data);

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

18022: END IF;
18023:
18024: IF (l_onhand_status_trx_allowed = 'N') then
18025: WMS_ENGINE_PVT.G_SUGG_FAILURE_MESSAGE := 'WMS_DISALLOW_TRANSACTION';
18026: fnd_message.set_name('WMS', 'WMS_DISALLOW_TRANSACTION');
18027: fnd_msg_pub.ADD;
18028: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
18029: IF l_debug = 1 THEN
18030: log_error_msg(l_api_name, x_msg_data);

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

18206:
18207: --IF l_inserted_record = FALSE OR l_allocated_quantity < l_needed_quantity THEN
18208: IF l_inserted_record = FALSE OR ABS(l_allocated_quantity - l_needed_quantity) > 0.00005
18209: THEN -- made by when testing 13591755
18210: fnd_message.set_name('WMS', 'WMS_LPN_UNAVAILABLE'); --- to be Added to Mesg Dict
18211: fnd_msg_pub.ADD;
18212: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
18213: IF l_debug = 1 THEN
18214: log_error_msg(l_api_name, x_msg_data);

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

18244: ELSE
18245:
18246: IF ( l_allowed = 'N') then
18247: WMS_ENGINE_PVT.G_SUGG_FAILURE_MESSAGE := 'WMS_ATT_SUB_STATUS_NA';
18248: fnd_message.set_name('WMS', 'WMS_ATT_SUB_STATUS_NA');
18249: fnd_msg_pub.ADD;
18250:
18251: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
18252: IF l_debug = 1 THEN

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

18254: END IF;
18255:
18256: ELSIF l_serial_allowed = 'N' then
18257: WMS_ENGINE_PVT.G_SUGG_FAILURE_MESSAGE := 'WMS_ATT_SERIAL_STATUS_NA' ;
18258: fnd_message.set_name('WMS', 'WMS_ATT_SUB_STATUS_NA');
18259: fnd_msg_pub.ADD;
18260: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
18261:
18262: IF l_debug = 1 THEN

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

18598: IF p_validation_level <> fnd_api.g_valid_level_none THEN
18599: IF p_type_code IS NULL
18600: OR p_type_code = fnd_api.g_miss_num THEN
18601: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
18602: fnd_message.set_name('WMS', 'WMS_RULE_TYPE_CODE_MISSING');
18603: fnd_msg_pub.ADD;
18604: IF l_debug = 1 THEN
18605: log_error_msg(l_api_name, 'type_code_missing');
18606: END IF;

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

18668: /* Lgao, Bug 5141737 select available will not check this flag, not used */
18669: /*IF p_partial_success_allowed_flag IS NULL
18670: OR p_partial_success_allowed_flag = fnd_api.g_miss_char THEN
18671: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
18672: fnd_message.set_name('WMS', 'WMS_PARTIAL_SUCC_FLAG_MISS');
18673:
18674: IF l_debug = 1 THEN
18675: log_error_msg(l_api_name, 'partial_succ_flag_missing');
18676: END IF;

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

18683:
18684: IF p_transaction_temp_id IS NULL
18685: OR p_transaction_temp_id = fnd_api.g_miss_num THEN
18686: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
18687: fnd_message.set_name('WMS', 'WMS_TRX_REQ_LINE_ID_MISS');
18688: fnd_msg_pub.ADD;
18689: IF l_debug = 1 THEN
18690: log_error_msg(l_api_name, 'trx_req_line_id_missing');
18691: END IF;

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

18697:
18698: IF p_organization_id IS NULL
18699: OR p_organization_id = fnd_api.g_miss_num THEN
18700: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
18701: fnd_message.set_name('INV', 'INV_NO_ORG_INFORMATION');
18702: fnd_msg_pub.ADD;
18703: IF l_debug = 1 THEN
18704: log_error_msg(l_api_name, 'org_id_missing');
18705: END IF;

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

18710:
18711: IF p_inventory_item_id IS NULL
18712: OR p_inventory_item_id = fnd_api.g_miss_num THEN
18713: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
18714: fnd_message.set_name('INV', 'INV_ITEM_ID_REQUIRED');
18715: fnd_msg_pub.ADD;
18716: IF l_debug = 1 THEN
18717: log_error_msg(l_api_name, 'item_id_missing');
18718: END IF;

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

18725: AND (p_tree_id IS NULL
18726: OR p_tree_id = fnd_api.g_miss_num
18727: ) THEN
18728: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
18729: fnd_message.set_name('INV', 'INV_QTY_TREE_ID_MISSING');
18730: fnd_msg_pub.ADD;
18731:
18732: IF l_debug = 1 THEN
18733: log_error_msg(l_api_name, 'qty_tree_id_missing');

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

19086: END IF;
19087: EXCEPTION
19088: /*WHEN INVALID_PKG_STATE THEN
19089: x_return_status := fnd_api.g_ret_sts_unexp_error;
19090: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');
19091: fnd_message.set_token('LIST_PKG', l_list_pkg);
19092: fnd_message.set_token('RULE_NAME', l_package_name);
19093: fnd_msg_pub.ADD;
19094: log_error(l_api_name, 'execute_fetch_rule', 'Invalid Package, Contact your DBA - '

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

19087: EXCEPTION
19088: /*WHEN INVALID_PKG_STATE THEN
19089: x_return_status := fnd_api.g_ret_sts_unexp_error;
19090: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');
19091: fnd_message.set_token('LIST_PKG', l_list_pkg);
19092: fnd_message.set_token('RULE_NAME', l_package_name);
19093: fnd_msg_pub.ADD;
19094: log_error(l_api_name, 'execute_fetch_rule', 'Invalid Package, Contact your DBA - '
19095: || l_list_pkg || ' / ' || l_package_name);

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

19088: /*WHEN INVALID_PKG_STATE THEN
19089: x_return_status := fnd_api.g_ret_sts_unexp_error;
19090: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');
19091: fnd_message.set_token('LIST_PKG', l_list_pkg);
19092: fnd_message.set_token('RULE_NAME', l_package_name);
19093: fnd_msg_pub.ADD;
19094: log_error(l_api_name, 'execute_fetch_rule', 'Invalid Package, Contact your DBA - '
19095: || l_list_pkg || ' / ' || l_package_name);
19096: */

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

19197: --
19198: EXCEPTION
19199: WHEN INVALID_PKG_STATE THEN
19200: x_return_status := fnd_api.g_ret_sts_unexp_error;
19201: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');
19202: fnd_message.set_token('LIST_PKG', l_list_pkg);
19203: fnd_message.set_token('RULE_NAME', l_package_name);
19204: fnd_msg_pub.ADD;
19205: log_error(l_api_name, 'execute_fetch_rule', 'Invalid Package, Contact your DBA - '

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

19198: EXCEPTION
19199: WHEN INVALID_PKG_STATE THEN
19200: x_return_status := fnd_api.g_ret_sts_unexp_error;
19201: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');
19202: fnd_message.set_token('LIST_PKG', l_list_pkg);
19203: fnd_message.set_token('RULE_NAME', l_package_name);
19204: fnd_msg_pub.ADD;
19205: log_error(l_api_name, 'execute_fetch_rule', 'Invalid Package, Contact your DBA - '
19206: || l_list_pkg || ' / ' || l_package_name);

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

19199: WHEN INVALID_PKG_STATE THEN
19200: x_return_status := fnd_api.g_ret_sts_unexp_error;
19201: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');
19202: fnd_message.set_token('LIST_PKG', l_list_pkg);
19203: fnd_message.set_token('RULE_NAME', l_package_name);
19204: fnd_msg_pub.ADD;
19205: log_error(l_api_name, 'execute_fetch_rule', 'Invalid Package, Contact your DBA - '
19206: || l_list_pkg || ' / ' || l_package_name);
19207: