[Home] [Help]
1207: EXCEPTION
1208: WHEN OTHERS THEN
1209: X_RETURN_STATUS := fnd_api.g_ret_sts_unexp_error; -- Unexpecetd Error
1210: retcode := 2;
1211: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1212: fnd_msg_pub.add_exc_msg(g_pkg_name, 'BuildRulePkg');
1213: END IF;
1214:
1215: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);
1208: WHEN OTHERS THEN
1209: X_RETURN_STATUS := fnd_api.g_ret_sts_unexp_error; -- Unexpecetd Error
1210: retcode := 2;
1211: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1212: fnd_msg_pub.add_exc_msg(g_pkg_name, 'BuildRulePkg');
1213: END IF;
1214:
1215: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);
1216: --fnd_file.put_line(fnd_file.LOG, 'Exception');
1211: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1212: fnd_msg_pub.add_exc_msg(g_pkg_name, 'BuildRulePkg');
1213: END IF;
1214:
1215: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);
1216: --fnd_file.put_line(fnd_file.LOG, 'Exception');
1217: --fnd_file.put_line(fnd_file.LOG, l_msg_data);
1218: errbuf := errbuf || 'Error in BuildRulesPkg:' || l_msg_data;
1219: END buildrulespkg;
1776: --
1777: EXCEPTION
1778: WHEN fnd_api.g_exc_error THEN
1779: x_return_status := fnd_api.g_ret_sts_error;
1780: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1781: --
1782: log_error(l_api_name, 'error', 'Error - ' || x_msg_data);
1783: --
1784: WHEN fnd_api.g_exc_unexpected_error THEN
1782: log_error(l_api_name, 'error', 'Error - ' || x_msg_data);
1783: --
1784: WHEN fnd_api.g_exc_unexpected_error THEN
1785: x_return_status := fnd_api.g_ret_sts_unexp_error;
1786: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1787: --
1788: log_error(l_api_name, 'unexp_error', 'Unexpected error - ' || x_msg_data);
1789:
1790: --
1790: --
1791: WHEN OTHERS THEN
1792: x_return_status := fnd_api.g_ret_sts_unexp_error;
1793:
1794: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1795: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1796: END IF;
1797:
1798: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1791: WHEN OTHERS THEN
1792: x_return_status := fnd_api.g_ret_sts_unexp_error;
1793:
1794: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1795: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1796: END IF;
1797:
1798: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1799: --
1794: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1795: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1796: END IF;
1797:
1798: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1799: --
1800: log_error(l_api_name, 'other_error', 'Other error - ' || x_msg_data);
1801:
1802: END buildbasesql;
2284: ELSE
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;
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:
2295: RAISE fnd_api.g_exc_error;
2296: END IF;
2308: g_rule_where := g_rule_where || ' NVL(' || l_table_alias || '.' || l_column_name || ','|| l_left_part_conv_fct || l_parent_table_alias || '.' || l_parent_column_name|| l_right_part_conv_fct || ') ';
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;
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;
2319: END IF;
2320:
2325: ELSIF l_parameter_type_code = 2 THEN -- based on expression
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;
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:
2336: RAISE fnd_api.g_exc_error;
2337: END IF;
2359: END IF;
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;
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:
2370: RAISE fnd_api.g_exc_error;
2371: END IF;
2405:
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;
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:
2415: RAISE fnd_api.g_exc_error;
2416: END IF;
2423: log_statement(l_api_name, 'data_type_code_qty', 'data_type_code: ' || l_data_type_code);
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;
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:
2434: RAISE fnd_api.g_exc_error;
2435: END IF;
2471: || ',sum(base.secondary_quantity) ' || g_line_feed -- new
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;
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:
2482: RAISE fnd_api.g_exc_error;
2483: END IF; -- parameter type code = 1
2560: || ' '
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;
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:
2571: RAISE fnd_api.g_exc_error;
2572: END IF;
2653: || l_operand_expression
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;
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:
2664: RAISE fnd_api.g_exc_error;
2665: END IF;
2700: || 'END_DATE_ACTIVE,sysdate+1) )'
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;
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:
2711: RAISE fnd_api.g_exc_error;
2712: END IF;
2712: END IF;
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;
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;
2723: END IF;
2950: g_rule_group_by := g_rule_group_by || ',' || l_expression;
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;
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:
2961: RAISE fnd_api.g_exc_error;
2962: END IF;
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;
3023: END LOOP;
3024:
3212: -- end of debugging section
3213: EXCEPTION
3214: WHEN fnd_api.g_exc_error THEN
3215: x_return_status := fnd_api.g_ret_sts_error;
3216: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3217: --
3218: log_error(l_api_name, 'error', 'Error - ' || x_msg_data);
3219: --
3220: WHEN fnd_api.g_exc_unexpected_error THEN
3218: log_error(l_api_name, 'error', 'Error - ' || x_msg_data);
3219: --
3220: WHEN fnd_api.g_exc_unexpected_error THEN
3221: x_return_status := fnd_api.g_ret_sts_unexp_error;
3222: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3223: --
3224: log_error(l_api_name, 'unexp_error', 'Unexpected error - ' || x_msg_data);
3225:
3226: WHEN OTHERS THEN
3245: END IF;
3246:
3247: x_return_status := fnd_api.g_ret_sts_unexp_error;
3248:
3249: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3250: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3251: END IF;
3252:
3253: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3246:
3247: x_return_status := fnd_api.g_ret_sts_unexp_error;
3248:
3249: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3250: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3251: END IF;
3252:
3253: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3254: --
3249: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3250: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3251: END IF;
3252:
3253: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3254: --
3255: log_error(l_api_name, 'other_error', 'Other error - ' || x_msg_data);
3256: --
3257: END buildrulesql;
3510: EXCEPTION
3511: WHEN OTHERS THEN
3512: x_return_status := fnd_api.g_ret_sts_unexp_error;
3513:
3514: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3515: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3516: END IF;
3517:
3518: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3511: WHEN OTHERS THEN
3512: x_return_status := fnd_api.g_ret_sts_unexp_error;
3513:
3514: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3515: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3516: END IF;
3517:
3518: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3519: --
3514: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3515: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3516: END IF;
3517:
3518: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3519: --
3520: log_error(l_api_name, 'other_error', 'Other error - ' || x_msg_data);
3521: --
3522: END buildinputsql;
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);
3736: END IF;
3738:
3739: WHEN OTHERS THEN
3740: x_return_status := fnd_api.g_ret_sts_unexp_error;
3741:
3742: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3743: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3744: END IF;
3745:
3746: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3739: WHEN OTHERS THEN
3740: x_return_status := fnd_api.g_ret_sts_unexp_error;
3741:
3742: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3743: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3744: END IF;
3745:
3746: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3747: IF l_debug = 1 THEN
3742: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3743: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3744: END IF;
3745:
3746: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3747: IF l_debug = 1 THEN
3748: log_error(l_api_name, 'other_error', 'Other error - ' || x_msg_data);
3749: END IF;
3750: RAISE fnd_api.g_exc_unexpected_error;
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 - '
3897: || l_list_pkg || ' / ' || l_package_name);
3899: RAISE fnd_api.g_exc_unexpected_error;
3900: WHEN OTHERS THEN
3901: x_return_status := fnd_api.g_ret_sts_unexp_error;
3902:
3903: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3904: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3905: END IF;
3906:
3907: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3900: WHEN OTHERS THEN
3901: x_return_status := fnd_api.g_ret_sts_unexp_error;
3902:
3903: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3904: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3905: END IF;
3906:
3907: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3908: IF l_debug = 1 THEN
3903: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3904: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3905: END IF;
3906:
3907: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3908: IF l_debug = 1 THEN
3909: log_error(l_api_name, 'other_error', 'Other error - ' || x_msg_data);
3910: END IF;
3911: RAISE fnd_api.g_exc_unexpected_error;
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 - '
4073: || l_list_pkg || ' / ' || l_package_name);
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 - '
4190: || 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;
4242:
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:
4292: END execute_task_rule;
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:
4345: END execute_label_rule;
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;
4387: END close_pick_rule;
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;
4424: END close_put_rule;
4521: EXCEPTION
4522: WHEN OTHERS THEN
4523: x_return_status := fnd_api.g_ret_sts_unexp_error;
4524:
4525: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4526: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
4527: END IF;
4528:
4529: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4522: WHEN OTHERS THEN
4523: x_return_status := fnd_api.g_ret_sts_unexp_error;
4524:
4525: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4526: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
4527: END IF;
4528:
4529: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4530:
4525: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4526: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
4527: END IF;
4528:
4529: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4530:
4531: IF l_debug = 1 THEN
4532: log_error(l_api_name, 'other_error', 'Other error - ' || x_msg_data);
4533: END IF;
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
5041: log_statement(l_api_name,'l_allocation_quantity from UOM conversion ', l_allocation_quantity);
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;
5130: IF l_debug = 1 THEN
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; --}
5178:
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
5336: log_statement(l_api_name,'(1) l_lot_sallocation_quantity ', l_lot_sallocation_quantity);
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;
5421: IF l_debug = 1 THEN
6470:
6471: EXCEPTION
6472: WHEN fnd_api.g_exc_error THEN
6473: x_return_status := fnd_api.g_ret_sts_error;
6474: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
6475: --
6476: IF l_debug = 1 THEN
6477: log_error(l_api_name, 'error', 'Error - ' || x_msg_data);
6478: END IF;
6478: END IF;
6479:
6480: WHEN fnd_api.g_exc_unexpected_error THEN
6481: x_return_status := fnd_api.g_ret_sts_unexp_error;
6482: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
6483: IF l_debug = 1 THEN
6484: log_error(l_api_name, 'unexp_error', 'Unexpected error - ' || x_msg_data);
6485: END IF;
6486:
6486:
6487: WHEN OTHERS THEN
6488: x_return_status := fnd_api.g_ret_sts_unexp_error;
6489:
6490: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
6491: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
6492: END IF;
6493:
6494: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
6487: WHEN OTHERS THEN
6488: x_return_status := fnd_api.g_ret_sts_unexp_error;
6489:
6490: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
6491: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
6492: END IF;
6493:
6494: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
6495: IF l_debug = 1 THEN
6490: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
6491: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
6492: END IF;
6493:
6494: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
6495: IF l_debug = 1 THEN
6496: log_error(l_api_name, 'other_error', 'Other error - ' || x_msg_data);
6497: END IF;
6498:
7103:
7104: EXCEPTION
7105: WHEN fnd_api.g_exc_error THEN
7106: x_return_status := fnd_api.g_ret_sts_error;
7107: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
7108: --
7109: IF l_debug = 1 THEN
7110: log_error(l_api_name, 'error', 'Error - ' || x_msg_data);
7111: END IF;
7111: END IF;
7112:
7113: WHEN fnd_api.g_exc_unexpected_error THEN
7114: x_return_status := fnd_api.g_ret_sts_unexp_error;
7115: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
7116: IF l_debug = 1 THEN
7117: log_error(l_api_name, 'unexp_error', 'Unexpected error - ' || x_msg_data);
7118: END IF;
7119:
7119:
7120: WHEN OTHERS THEN
7121: x_return_status := fnd_api.g_ret_sts_unexp_error;
7122:
7123: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
7124: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
7125: END IF;
7126:
7127: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
7120: WHEN OTHERS THEN
7121: x_return_status := fnd_api.g_ret_sts_unexp_error;
7122:
7123: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
7124: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
7125: END IF;
7126:
7127: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
7128: IF l_debug = 1 THEN
7123: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
7124: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
7125: END IF;
7126:
7127: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
7128: IF l_debug = 1 THEN
7129: log_error(l_api_name, 'other_error', 'Other error - ' || x_msg_data);
7130: END IF;
7131:
7246: END IF;
7247: EXCEPTION
7248: WHEN fnd_api.g_exc_error THEN
7249: x_return_status := fnd_api.g_ret_sts_error;
7250: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
7251: IF l_debug = 1 THEN
7252: log_error(l_api_name, 'error', 'Error - ' || x_msg_data);
7253: END IF;
7254:
7253: END IF;
7254:
7255: WHEN fnd_api.g_exc_unexpected_error THEN
7256: x_return_status := fnd_api.g_ret_sts_unexp_error;
7257: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
7258: IF l_debug = 1 THEN
7259: log_error(l_api_name, 'unexp_error', 'Unexpected error - ' || x_msg_data);
7260: END IF;
7261:
7261:
7262: WHEN OTHERS THEN
7263: x_return_status := fnd_api.g_ret_sts_unexp_error;
7264:
7265: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
7266: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
7267: END IF;
7268:
7269: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
7262: WHEN OTHERS THEN
7263: x_return_status := fnd_api.g_ret_sts_unexp_error;
7264:
7265: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
7266: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
7267: END IF;
7268:
7269: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
7270: IF l_debug = 1 THEN
7265: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
7266: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
7267: END IF;
7268:
7269: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
7270: IF l_debug = 1 THEN
7271: log_error(l_api_name, 'other_error', 'Other error - ' || x_msg_data);
7272: END IF;
7273: END rollback_consist_allocations;
7850: EXCEPTION
7851: WHEN fnd_api.g_exc_error THEN
7852: x_return_status := fnd_api.g_ret_sts_error;
7853: x_success := FALSE;
7854: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
7855: IF l_debug = 1 THEN
7856: log_error(l_api_name, 'error', 'Error - ' || x_msg_data);
7857: END IF;
7858:
7858:
7859: WHEN fnd_api.g_exc_unexpected_error THEN
7860: x_return_status := fnd_api.g_ret_sts_unexp_error;
7861: x_success := FALSE;
7862: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
7863: IF l_debug = 1 THEN
7864: log_error(l_api_name, 'unexp_error', 'Unexpected error - ' || x_msg_data);
7865: END IF;
7866: WHEN OTHERS THEN
7866: WHEN OTHERS THEN
7867: x_return_status := fnd_api.g_ret_sts_unexp_error;
7868: x_success := FALSE;
7869:
7870: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
7871: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
7872: END IF;
7873:
7874: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
7867: x_return_status := fnd_api.g_ret_sts_unexp_error;
7868: x_success := FALSE;
7869:
7870: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
7871: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
7872: END IF;
7873:
7874: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
7875: IF l_debug = 1 THEN
7870: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
7871: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
7872: END IF;
7873:
7874: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
7875: IF l_debug = 1 THEN
7876: log_error(l_api_name, 'other_error', 'Other error - ' || x_msg_data);
7877: END IF;
7878:
8246: END IF;
8247: EXCEPTION
8248: WHEN fnd_api.g_exc_error THEN
8249: x_return_status := fnd_api.g_ret_sts_error;
8250: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
8251: IF l_debug = 1 THEN
8252: log_error(l_api_name, 'error', 'Error - ' || x_msg_data);
8253: END IF;
8254: --
8253: END IF;
8254: --
8255: WHEN fnd_api.g_exc_unexpected_error THEN
8256: x_return_status := fnd_api.g_ret_sts_unexp_error;
8257: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
8258: IF l_debug = 1 THEN
8259: log_error(l_api_name, 'unexp_error', 'Unexpected error - ' || x_msg_data);
8260: END IF;
8261:
8261:
8262: WHEN OTHERS THEN
8263: x_return_status := fnd_api.g_ret_sts_unexp_error;
8264:
8265: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
8266: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
8267: END IF;
8268:
8269: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
8262: WHEN OTHERS THEN
8263: x_return_status := fnd_api.g_ret_sts_unexp_error;
8264:
8265: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
8266: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
8267: END IF;
8268:
8269: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
8270: IF l_debug = 1 THEN
8265: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
8266: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
8267: END IF;
8268:
8269: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
8270: IF l_debug = 1 THEN
8271: log_error(l_api_name, 'other_error', 'Other error - ' || x_msg_data);
8272: END IF;
8273:
8748: END IF;
8749:
8750: -- Initialize message list if p_init_msg_list is set to TRUE
8751: IF fnd_api.to_boolean(p_init_msg_list) THEN
8752: fnd_msg_pub.initialize;
8753: END IF;
8754:
8755: -- LPN Status Project
8756: IF (inv_cache.set_org_rec(p_organization_id)) THEN
8773: -- requires this
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
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');
8783: END IF;
8841: END IF;
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;
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;
8851: END IF;
8852: RAISE fnd_api.g_exc_error;
8853: END IF;
8854:
8853: END IF;
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');
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;
8863: END IF;
8865: END IF;
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');
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;
8875: END IF;
8878: END IF;
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');
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;
8888: END IF;
8894: AND (p_tree_id IS NULL
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');
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;
8904: END IF;
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; --}
9622:
13477:
13478: ROLLBACK TO applyrulesp;
13479: freeglobals;
13480: x_return_status := fnd_api.g_ret_sts_error;
13481: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
13482: IF l_debug = 1 THEN
13483: log_error(l_api_name, 'error', 'Expected error - ' || x_msg_data);
13484: END IF;
13485: --
13520:
13521: ROLLBACK TO applyrulesp;
13522: freeglobals;
13523: x_return_status := fnd_api.g_ret_sts_unexp_error;
13524: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
13525: IF l_debug = 1 THEN
13526: log_error(l_api_name, 'unexp_error', 'Unexpected error - ' || x_msg_data);
13527: END IF;
13528: --
13564: ROLLBACK TO applyrulesp;
13565: freeglobals;
13566: x_return_status := fnd_api.g_ret_sts_unexp_error;
13567:
13568: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
13569: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
13570: END IF;
13571:
13572: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
13565: freeglobals;
13566: x_return_status := fnd_api.g_ret_sts_unexp_error;
13567:
13568: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
13569: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
13570: END IF;
13571:
13572: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
13573: IF l_debug = 1 THEN
13568: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
13569: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
13570: END IF;
13571:
13572: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
13573: IF l_debug = 1 THEN
13574: log_error(l_api_name, 'other_error', 'Other error - ' || x_msg_data);
13575: END IF;
13576: END apply;
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 ;
13647: RETURN l_locator_control ;
13658: --
13659: WHEN OTHERS THEN
13660: x_return_status := fnd_api.g_ret_sts_unexp_error ;
13661: --
13662: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)) THEN
13663: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
13664: END IF;
13665: --
13666: l_locator_control := -1 ;
13659: WHEN OTHERS THEN
13660: x_return_status := fnd_api.g_ret_sts_unexp_error ;
13661: --
13662: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)) THEN
13663: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
13664: END IF;
13665: --
13666: l_locator_control := -1 ;
13667: RETURN l_locator_control ;
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;
13769: ELSE
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:
13784: l_sub_loc_control := INV_CACHE.tosub_rec.locator_type;
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;
13826: ELSE
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;
13866: ELSE
13903: x_putaway_loc := NULL;
13904: x_putaway_sub := NULL;
13905: x_putaway_cost_group_id := NULL;
13906: --
13907: IF (fnd_msg_pub.check_msg_level
13908: (fnd_msg_pub.g_msg_lvl_unexp_error)) THEN
13909: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
13910: END IF;
13911: --
13904: x_putaway_sub := NULL;
13905: x_putaway_cost_group_id := NULL;
13906: --
13907: IF (fnd_msg_pub.check_msg_level
13908: (fnd_msg_pub.g_msg_lvl_unexp_error)) THEN
13909: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
13910: END IF;
13911: --
13912:
13905: x_putaway_cost_group_id := NULL;
13906: --
13907: IF (fnd_msg_pub.check_msg_level
13908: (fnd_msg_pub.g_msg_lvl_unexp_error)) THEN
13909: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
13910: END IF;
13911: --
13912:
13913: END get_putaway_defaults ;
14068: END IF;
14069:
14070: -- Initialize message list if p_init_msg_list is set to TRUE
14071: IF fnd_api.to_boolean( p_init_msg_list ) THEN
14072: fnd_msg_pub.initialize;
14073: END IF;
14074: --
14075: -- Initialize API return status to success
14076: x_return_status := fnd_api.g_ret_sts_success;
14082: -- requires this
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;
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;
14092: END IF;
14093: RAISE fnd_api.g_exc_error;
14094: END IF;
14095: IF p_organization_id IS NULL OR
14093: RAISE fnd_api.g_exc_error;
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;
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;
14103: END IF;
14104: RAISE fnd_api.g_exc_error;
14105: END IF;
14106: IF p_inventory_item_id IS NULL OR
14104: RAISE fnd_api.g_exc_error;
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;
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;
14114: END IF;
14115: RAISE fnd_api.g_exc_error;
14116: END IF;
14117: END IF;
14709:
14710: ROLLBACK TO ApplyRuleSP;
14711: FreeGlobals;
14712: x_return_status := fnd_api.g_ret_sts_error;
14713: fnd_msg_pub.count_and_get( p_count => x_msg_count
14714: ,p_data => x_msg_data );
14715: If (l_debug = 1) then
14716: log_error(l_api_name, 'error', 'Expected error - ' || x_msg_data);
14717: End if;
14720: WHEN fnd_api.g_exc_unexpected_error THEN
14721: ROLLBACK TO ApplyRuleSP;
14722: FreeGlobals;
14723: x_return_status := fnd_api.g_ret_sts_unexp_error;
14724: fnd_msg_pub.count_and_get( p_count => x_msg_count
14725: ,p_data => x_msg_data );
14726: If (l_debug = 1) then
14727: log_error(l_api_name, 'unexp_error', 'Unexpected error - ' || x_msg_data);
14728: End if;
14732:
14733: ROLLBACK TO ApplyRuleSP;
14734: FreeGlobals;
14735: x_return_status := fnd_api.g_ret_sts_unexp_error;
14736: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
14737: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
14738: END IF;
14739: fnd_msg_pub.count_and_get( p_count => x_msg_count
14740: ,p_data => x_msg_data );
14733: ROLLBACK TO ApplyRuleSP;
14734: FreeGlobals;
14735: x_return_status := fnd_api.g_ret_sts_unexp_error;
14736: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
14737: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
14738: END IF;
14739: fnd_msg_pub.count_and_get( p_count => x_msg_count
14740: ,p_data => x_msg_data );
14741: If (l_debug = 1) then
14735: x_return_status := fnd_api.g_ret_sts_unexp_error;
14736: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
14737: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
14738: END IF;
14739: fnd_msg_pub.count_and_get( p_count => x_msg_count
14740: ,p_data => x_msg_data );
14741: If (l_debug = 1) then
14742: log_error(l_api_name, 'other_error', 'Other error - ' || x_msg_data);
14743: End if;
14794: END IF;
14795:
14796: -- Initialize message list if p_init_msg_list is set to TRUE
14797: IF fnd_api.to_boolean(p_init_msg_list) THEN
14798: fnd_msg_pub.initialize;
14799: END IF;
14800:
14801: --
14802: -- Initialize API return status to success
14812: EXCEPTION
14813: WHEN fnd_api.g_exc_error THEN
14814: --
14815: x_return_status := fnd_api.g_ret_sts_error;
14816: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
14817: --
14818: WHEN fnd_api.g_exc_unexpected_error THEN
14819: x_return_status := fnd_api.g_ret_sts_unexp_error;
14820: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
14816: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
14817: --
14818: WHEN fnd_api.g_exc_unexpected_error THEN
14819: x_return_status := fnd_api.g_ret_sts_unexp_error;
14820: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
14821: --
14822: WHEN OTHERS THEN
14823: freeglobals;
14824: x_return_status := fnd_api.g_ret_sts_unexp_error;
14822: WHEN OTHERS THEN
14823: freeglobals;
14824: x_return_status := fnd_api.g_ret_sts_unexp_error;
14825:
14826: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
14827: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
14828: END IF;
14829:
14830: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
14823: freeglobals;
14824: x_return_status := fnd_api.g_ret_sts_unexp_error;
14825:
14826: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
14827: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
14828: END IF;
14829:
14830: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
14831: --
14826: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
14827: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
14828: END IF;
14829:
14830: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
14831: --
14832: END checksyntax;
14833:
14834: --
14913: --
14914: EXCEPTION
14915: WHEN fnd_api.g_exc_error THEN
14916: x_return_status := fnd_api.g_ret_sts_error;
14917: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
14918: --
14919: WHEN fnd_api.g_exc_unexpected_error THEN
14920: x_return_status := fnd_api.g_ret_sts_unexp_error;
14921: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
14917: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
14918: --
14919: WHEN fnd_api.g_exc_unexpected_error THEN
14920: x_return_status := fnd_api.g_ret_sts_unexp_error;
14921: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
14922: --
14923: WHEN OTHERS THEN
14924: x_return_status := fnd_api.g_ret_sts_unexp_error;
14925:
14922: --
14923: WHEN OTHERS THEN
14924: x_return_status := fnd_api.g_ret_sts_unexp_error;
14925:
14926: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
14927: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
14928: END IF;
14929:
14930: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
14923: WHEN OTHERS THEN
14924: x_return_status := fnd_api.g_ret_sts_unexp_error;
14925:
14926: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
14927: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
14928: END IF;
14929:
14930: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
14931: --
14926: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
14927: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
14928: END IF;
14929:
14930: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
14931: --
14932: END find_rule;
14933:
14934: --GetPackageName
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:
15039: --open cursor
15185:
15186: --
15187: -- Initialize message list if p_init_msg_list is set to TRUE
15188: IF fnd_api.to_boolean(p_init_msg_list) THEN
15189: fnd_msg_pub.initialize;
15190: END IF;
15191:
15192: --
15193: -- Initialize API return status to success
15200: -- Validate input parameter, if validation level requires this
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;
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:
15210: RAISE fnd_api.g_exc_error;
15211: END IF;
15302: ||' and ( mlna.EXPIRATION_DATE is NULL OR mlna.EXPIRATION_DATE > sysdate OR wms_rule_pvt.g_allow_expired_lot_txn = ''Y'' ) ' ;
15303: END IF;
15304:
15305: IF inv_pp_debug.is_debug_mode THEN
15306: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
15307: -- the message retrieved here since it is no longer on the stack
15308: inv_pp_debug.set_last_error_message(SQLERRM);
15309: inv_pp_debug.send_message_to_pipe(g_base_from_serial);
15310: inv_pp_debug.send_last_error_message;
16319:
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: */ --
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
16329: log_procedure(l_api_name, 'end', 'End GenerateRulePackage');
16333: --
16334: -- debugging portion
16335: -- can be commented ut for final code
16336: IF inv_pp_debug.is_debug_mode THEN
16337: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
16338: -- the message retrieved here since it is no longer on the stack
16339: inv_pp_debug.set_last_error_message(SQLERRM);
16340: inv_pp_debug.send_message_to_pipe('exception in '|| l_api_name);
16341: inv_pp_debug.send_last_error_message;
16348: END IF;
16349:
16350: freeglobals;
16351: x_return_status := fnd_api.g_ret_sts_error;
16352: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
16353: log_error(l_api_name, 'error', 'Expected error - ' || x_msg_data);
16354: --
16355: WHEN fnd_api.g_exc_unexpected_error THEN
16356: --
16356: --
16357: -- debugging portion
16358: -- can be commented ut for final code
16359: IF inv_pp_debug.is_debug_mode THEN
16360: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
16361: -- the message retrieved here since it is no longer on the stack
16362: inv_pp_debug.set_last_error_message(SQLERRM);
16363: inv_pp_debug.send_message_to_pipe('exception in '|| l_api_name);
16364: inv_pp_debug.send_last_error_message;
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);
16379: --
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);
16379: --
16380: WHEN OTHERS THEN
16381: --
16381: --
16382: -- debugging portion
16383: -- can be commented ut for final code
16384: IF inv_pp_debug.is_debug_mode THEN
16385: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
16386: -- the message retrieved here since it is no longer on the stack
16387: inv_pp_debug.set_last_error_message(SQLERRM);
16388: inv_pp_debug.send_message_to_pipe('exception in '|| l_api_name);
16389: inv_pp_debug.send_last_error_message;
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
16408: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
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
16408: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
16409: END IF;
16410:
16411: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
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
16408: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
16409: END IF;
16410:
16411: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
16412: log_error(l_api_name, 'other_error', 'Other error - ' || x_msg_data);
16407: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
16408: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
16409: END IF;
16410:
16411: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
16412: log_error(l_api_name, 'other_error', 'Other error - ' || x_msg_data);
16413: --
16414: END generaterulepackage;
16415:
16620: END IF;
16621:
16622: -- Initialize message list if p_init_msg_list is set to TRUE
16623: IF fnd_api.to_boolean(p_init_msg_list) THEN
16624: fnd_msg_pub.initialize;
16625: END IF;
16626:
16627: --
16628: -- Initialize API return status to success
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;
16658: ELSIF l_return_status <> -1 THEN
16729: ROLLBACK TO assign_operation_plan_sp;
16730: freeglobals;
16731: x_return_status := fnd_api.g_ret_sts_error;
16732:
16733: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
16734: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
16735: END IF;
16736:
16737: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
16730: freeglobals;
16731: x_return_status := fnd_api.g_ret_sts_error;
16732:
16733: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
16734: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
16735: END IF;
16736:
16737: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
16738: WHEN OTHERS THEN
16733: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
16734: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
16735: END IF;
16736:
16737: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
16738: WHEN OTHERS THEN
16739: ROLLBACK TO assign_operation_plan_sp;
16740: freeglobals;
16741: x_return_status := fnd_api.g_ret_sts_unexp_error;
16739: ROLLBACK TO assign_operation_plan_sp;
16740: freeglobals;
16741: x_return_status := fnd_api.g_ret_sts_unexp_error;
16742:
16743: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
16744: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
16745: END IF;
16746:
16747: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
16740: freeglobals;
16741: x_return_status := fnd_api.g_ret_sts_unexp_error;
16742:
16743: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
16744: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
16745: END IF;
16746:
16747: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
16748: END assign_operation_plan;
16743: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
16744: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
16745: END IF;
16746:
16747: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
16748: END assign_operation_plan;
16749:
16750: --**************************************
16751:
16994: END IF;
16995:
16996: -- Initialize message list if p_init_msg_list is set to TRUE
16997: IF fnd_api.to_boolean(p_init_msg_list) THEN
16998: fnd_msg_pub.initialize;
16999: END IF;
17000:
17001: --
17002: -- Initialize API return status to success
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);
17041: END IF;
17167: ROLLBACK TO assignttsp;
17168: freeglobals;
17169: x_return_status := fnd_api.g_ret_sts_error;
17170:
17171: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
17172: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
17173: END IF;
17174:
17175: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
17168: freeglobals;
17169: x_return_status := fnd_api.g_ret_sts_error;
17170:
17171: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
17172: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
17173: END IF;
17174:
17175: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
17176: WHEN OTHERS THEN
17171: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
17172: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
17173: END IF;
17174:
17175: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
17176: WHEN OTHERS THEN
17177: ROLLBACK TO assignttsp;
17178: freeglobals;
17179: x_return_status := fnd_api.g_ret_sts_unexp_error;
17177: ROLLBACK TO assignttsp;
17178: freeglobals;
17179: x_return_status := fnd_api.g_ret_sts_unexp_error;
17180:
17181: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
17182: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
17183: END IF;
17184:
17185: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
17178: freeglobals;
17179: x_return_status := fnd_api.g_ret_sts_unexp_error;
17180:
17181: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
17182: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
17183: END IF;
17184:
17185: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
17186: END assigntt;
17181: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
17182: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
17183: END IF;
17184:
17185: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
17186: END assigntt;
17187:
17188: --
17189: -- API name : CalcRuleWeight
17347: END IF;
17348:
17349: -- Initialize message list if p_init_msg_list is set to TRUE
17350: IF fnd_api.to_boolean(p_init_msg_list) THEN
17351: fnd_msg_pub.initialize;
17352: END IF;
17353:
17354: --
17355: -- Initialize API return status to success
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:
17381: CLOSE l_label_requests_curs;
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);
17414: END IF;
17495:
17496: ROLLBACK TO assignlabelsp;
17497: freeglobals;
17498: x_return_status := fnd_api.g_ret_sts_error;
17499: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
17500: WHEN OTHERS THEN
17501: l_msg_data := SQLERRM;
17502: IF l_debug = 1 THEN
17503: TRACE('EXCEPTION OTHERS: '|| l_msg_data);
17504: END IF;
17505: ROLLBACK TO assignlabelsp;
17506: freeglobals;
17507: x_return_status := fnd_api.g_ret_sts_unexp_error;
17508: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
17509: END applylabel;
17510:
17511: PROCEDURE get_wms_sys_task_type(
17512: p_move_order_type IN NUMBER
17623: END IF;
17624: EXCEPTION
17625: WHEN OTHERS THEN
17626: retcode := 2;
17627: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
17628: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Compile All Rule Packages');
17629: END IF;
17630:
17631: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);
17624: EXCEPTION
17625: WHEN OTHERS THEN
17626: retcode := 2;
17627: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
17628: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Compile All Rule Packages');
17629: END IF;
17630:
17631: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);
17632: --fnd_file.put_line(fnd_file.LOG, 'Exception in compile_all_rule_packages');
17627: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
17628: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Compile All Rule Packages');
17629: END IF;
17630:
17631: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);
17632: --fnd_file.put_line(fnd_file.LOG, 'Exception in compile_all_rule_packages');
17633: --fnd_file.put_line(fnd_file.LOG, l_msg_data);
17634: errbuf := errbuf || 'Error: ' || l_msg_data;
17635: END;
17782: RAISE fnd_api.g_exc_unexpected_error;
17783: END IF;
17784: -- Initialize message list if p_init_msg_list is set to TRUE
17785: IF fnd_api.to_boolean(p_init_msg_list) THEN
17786: fnd_msg_pub.initialize;
17787: END IF;
17788: -- Initialize API return status to success
17789: x_return_status := fnd_api.g_ret_sts_success;
17790: -- Initialize functional return status to completed
17800:
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;
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;
17810: END IF;
17811:
17815: END IF;
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;
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:
17825: RAISE fnd_api.g_exc_error;
17826: END IF;
17831: END IF;
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;
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:
17841: RAISE fnd_api.g_exc_error;
17842: END IF;
17847: END IF;
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;
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:
17857: RAISE fnd_api.g_exc_error;
17858: END IF;
17864:
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;
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:
17874: RAISE fnd_api.g_exc_error;
17875: END IF;
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);
18004: END IF;
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);
18004: END IF;
18005: 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);
18031: END IF;
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);
18031: END IF;
18032: END IF;
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);
18215: END IF;
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);
18215: END IF;
18216:
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
18253: log_error_msg(l_api_name, x_msg_data);
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
18253: log_error_msg(l_api_name, x_msg_data);
18254: END IF;
18255:
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
18263: log_error_msg(l_api_name, x_msg_data);
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
18263: log_error_msg(l_api_name, x_msg_data);
18264: END IF;
18274:
18275: ROLLBACK TO QuickPicksp;
18276: freeglobals;
18277: x_return_status := fnd_api.g_ret_sts_error;
18278: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
18279:
18280: IF l_debug = 1 THEN
18281: log_error(l_api_name, 'error', 'Expected error - ' || x_msg_data);
18282: END IF;
18284: WHEN fnd_api.g_exc_unexpected_error THEN
18285: ROLLBACK TO QuickPicksp;
18286: freeglobals;
18287: x_return_status := fnd_api.g_ret_sts_unexp_error;
18288: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
18289:
18290: IF l_debug = 1 THEN
18291: log_error(l_api_name, 'unexp_error', 'Unexpected error - ' || x_msg_data);
18292: END IF;
18294: WHEN OTHERS THEN
18295: ROLLBACK TO QuickPicksp;
18296: freeglobals;
18297: x_return_status := fnd_api.g_ret_sts_unexp_error;
18298: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
18299: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
18300: END IF;
18301: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
18302:
18295: ROLLBACK TO QuickPicksp;
18296: freeglobals;
18297: x_return_status := fnd_api.g_ret_sts_unexp_error;
18298: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
18299: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
18300: END IF;
18301: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
18302:
18303: IF l_debug = 1 THEN
18297: x_return_status := fnd_api.g_ret_sts_unexp_error;
18298: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
18299: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
18300: END IF;
18301: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
18302:
18303: IF l_debug = 1 THEN
18304: log_error(l_api_name, 'other_error', 'Other error - ' || x_msg_data);
18305: END IF;
18581: END IF;
18582:
18583: -- Initialize message list if p_init_msg_list is set to TRUE
18584: IF fnd_api.to_boolean(p_init_msg_list) THEN
18585: fnd_msg_pub.initialize;
18586: END IF;
18587:
18588: --
18589: -- Initialize API return status to success
18597: -- requires this
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');
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;
18607: END IF;
18667:
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');
18673:
18674: IF l_debug = 1 THEN
18675: log_error_msg(l_api_name, 'partial_succ_flag_missing');
18676: END IF;
18677: fnd_msg_pub.ADD;
18678: END IF;
18679:
18680: RAISE fnd_api.g_exc_error;
18681: END IF;
18682: */
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');
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;
18692:
18696: END IF;
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');
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;
18706: END IF;
18709: END IF;
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');
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;
18719: END IF;
18724: IF p_type_code = 2
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
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');
18734: END IF;
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: */
19097: WHEN OTHERS THEN
19096: */
19097: WHEN OTHERS THEN
19098: x_return_status := fnd_api.g_ret_sts_unexp_error;
19099:
19100: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
19101: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
19102: END IF;
19103:
19104: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
19097: WHEN OTHERS THEN
19098: x_return_status := fnd_api.g_ret_sts_unexp_error;
19099:
19100: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
19101: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
19102: END IF;
19103:
19104: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
19105: --
19100: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
19101: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
19102: END IF;
19103:
19104: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
19105: --
19106: log_error(l_api_name, 'other_error', 'Other error - ' || x_msg_data);
19107:
19108: -- debugging portion
19107:
19108: -- debugging portion
19109: -- can be commented ut for final code
19110: IF inv_pp_debug.is_debug_mode THEN
19111: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
19112: -- the message retrieved here since it is no longer on the stack
19113: inv_pp_debug.set_last_error_message(SQLERRM);
19114: inv_pp_debug.send_message_to_pipe('exception in '|| l_api_name);
19115: inv_pp_debug.send_last_error_message;
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:
19208: WHEN OTHERS THEN
19207:
19208: WHEN OTHERS THEN
19209: x_return_status := fnd_api.g_ret_sts_unexp_error;
19210:
19211: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
19212: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
19213: END IF;
19214:
19215: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
19208: WHEN OTHERS THEN
19209: x_return_status := fnd_api.g_ret_sts_unexp_error;
19210:
19211: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
19212: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
19213: END IF;
19214:
19215: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
19216: --
19211: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
19212: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
19213: END IF;
19214:
19215: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
19216: --
19217: log_error(l_api_name, 'other_error', 'Other error - ' || x_msg_data);
19218:
19219: -- debugging portion
19218:
19219: -- debugging portion
19220: -- can be commented ut for final code
19221: IF inv_pp_debug.is_debug_mode THEN
19222: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
19223: -- the message retrieved here since it is no longer on the stack
19224: inv_pp_debug.set_last_error_message(SQLERRM);
19225: inv_pp_debug.send_message_to_pipe('exception in '|| l_api_name);
19226: inv_pp_debug.send_last_error_message;