[Home] [Help]
1124: EXCEPTION
1125: WHEN OTHERS THEN
1126: X_RETURN_STATUS := fnd_api.g_ret_sts_unexp_error; -- Unexpecetd Error
1127: retcode := 2;
1128: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1129: fnd_msg_pub.add_exc_msg(g_pkg_name, 'BuildRulePkg');
1130: END IF;
1131:
1132: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);
1125: WHEN OTHERS THEN
1126: X_RETURN_STATUS := fnd_api.g_ret_sts_unexp_error; -- Unexpecetd Error
1127: retcode := 2;
1128: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1129: fnd_msg_pub.add_exc_msg(g_pkg_name, 'BuildRulePkg');
1130: END IF;
1131:
1132: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);
1133: --fnd_file.put_line(fnd_file.LOG, 'Exception');
1128: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1129: fnd_msg_pub.add_exc_msg(g_pkg_name, 'BuildRulePkg');
1130: END IF;
1131:
1132: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);
1133: --fnd_file.put_line(fnd_file.LOG, 'Exception');
1134: --fnd_file.put_line(fnd_file.LOG, l_msg_data);
1135: errbuf := errbuf || 'Error in BuildRulesPkg:' || l_msg_data;
1136: END buildrulespkg;
1693: --
1694: EXCEPTION
1695: WHEN fnd_api.g_exc_error THEN
1696: x_return_status := fnd_api.g_ret_sts_error;
1697: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1698: --
1699: log_error(l_api_name, 'error', 'Error - ' || x_msg_data);
1700: --
1701: WHEN fnd_api.g_exc_unexpected_error THEN
1699: log_error(l_api_name, 'error', 'Error - ' || x_msg_data);
1700: --
1701: WHEN fnd_api.g_exc_unexpected_error THEN
1702: x_return_status := fnd_api.g_ret_sts_unexp_error;
1703: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1704: --
1705: log_error(l_api_name, 'unexp_error', 'Unexpected error - ' || x_msg_data);
1706:
1707: --
1707: --
1708: WHEN OTHERS THEN
1709: x_return_status := fnd_api.g_ret_sts_unexp_error;
1710:
1711: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1712: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1713: END IF;
1714:
1715: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1708: WHEN OTHERS THEN
1709: x_return_status := fnd_api.g_ret_sts_unexp_error;
1710:
1711: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1712: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1713: END IF;
1714:
1715: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1716: --
1711: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1712: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1713: END IF;
1714:
1715: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1716: --
1717: log_error(l_api_name, 'other_error', 'Other error - ' || x_msg_data);
1718:
1719: END buildbasesql;
2171: l_outer_join := ' (+)';
2172: ELSIF l_context_dependent_flag = 'N' THEN
2173: l_outer_join := NULL;
2174: ELSE
2175: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2176: fnd_message.set_name('WMS', 'WMS_BAD_CONTEXT_DEPT_FLAG');
2177: fnd_message.set_token('CONTEXT_DEPENDENT_FLAG', l_context_dependent_flag);
2178: log_error_msg(l_api_name, 'bad_context_depend_flag');
2179: fnd_msg_pub.ADD;
2175: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2176: fnd_message.set_name('WMS', 'WMS_BAD_CONTEXT_DEPT_FLAG');
2177: fnd_message.set_token('CONTEXT_DEPENDENT_FLAG', l_context_dependent_flag);
2178: log_error_msg(l_api_name, 'bad_context_depend_flag');
2179: fnd_msg_pub.ADD;
2180: END IF;
2181:
2182: RAISE fnd_api.g_exc_error;
2183: END IF;
2192: ELSIF l_parameter_type_code = 2 THEN -- based on expression
2193: --g_rule_where := g_rule_where || l_expression || l_outer_join;
2194: g_rule_where := g_rule_where || l_expression ; -- || l_outer_join; --Bug #3719043
2195: ELSE
2196: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2197: fnd_message.set_name('WMS', 'WMS_BAD_PARAMETER_TYPE_CODE');
2198: fnd_message.set_token('PARAMETER_TYPE_CODE', l_parameter_type_code);
2199: log_error_msg(l_api_name, 'bad_param_type_code_joins');
2200: fnd_msg_pub.ADD;
2196: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2197: fnd_message.set_name('WMS', 'WMS_BAD_PARAMETER_TYPE_CODE');
2198: fnd_message.set_token('PARAMETER_TYPE_CODE', l_parameter_type_code);
2199: log_error_msg(l_api_name, 'bad_param_type_code_joins');
2200: fnd_msg_pub.ADD;
2201: END IF;
2202:
2203: RAISE fnd_api.g_exc_error;
2204: END IF;
2211: g_rule_where := g_rule_where || l_parent_table_alias || '.' || l_parent_column_name;
2212: ELSIF l_parent_parameter_type_code = 2 THEN
2213: g_rule_where := g_rule_where || l_parent_expression;
2214: ELSE
2215: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2216: fnd_message.set_name('WMS', 'WMS_BAD_PARENT_PARA_TYPE');
2217: fnd_message.set_token('PARENT_PARAMETER_TYPE_CODE', l_parent_parameter_type_code);
2218: log_error_msg(l_api_name, 'bad_parent_param_type_joins');
2219: fnd_msg_pub.ADD;
2215: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2216: fnd_message.set_name('WMS', 'WMS_BAD_PARENT_PARA_TYPE');
2217: fnd_message.set_token('PARENT_PARAMETER_TYPE_CODE', l_parent_parameter_type_code);
2218: log_error_msg(l_api_name, 'bad_parent_param_type_joins');
2219: fnd_msg_pub.ADD;
2220: END IF;
2221:
2222: RAISE fnd_api.g_exc_error;
2223: END IF;
2257:
2258: IF qtyfnct%NOTFOUND THEN
2259: CLOSE qtyfnct;
2260:
2261: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2262: fnd_message.set_name('WMS', 'WMS_QTY_FUNC_NOT_FOUND');
2263: log_error_msg(l_api_name, 'qty_func_not_found');
2264: fnd_msg_pub.ADD;
2265: END IF;
2260:
2261: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2262: fnd_message.set_name('WMS', 'WMS_QTY_FUNC_NOT_FOUND');
2263: log_error_msg(l_api_name, 'qty_func_not_found');
2264: fnd_msg_pub.ADD;
2265: END IF;
2266:
2267: RAISE fnd_api.g_exc_error;
2268: END IF;
2275: log_statement(l_api_name, 'data_type_code_qty', 'data_type_code: ' || l_data_type_code);
2276: log_statement(l_api_name, 'table_alias_qty', 'table_alias: ' || l_table_alias);
2277:
2278: IF l_data_type_code <> 1 THEN
2279: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2280: fnd_message.set_name('WMS', 'WMS_BAD_QTY_FUNC_DATA_TYPE');
2281: fnd_message.set_token('DATATYPE', l_data_type_code);
2282: log_error_msg(l_api_name, 'bad_qty_func_data_type');
2283: fnd_msg_pub.ADD;
2279: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2280: fnd_message.set_name('WMS', 'WMS_BAD_QTY_FUNC_DATA_TYPE');
2281: fnd_message.set_token('DATATYPE', l_data_type_code);
2282: log_error_msg(l_api_name, 'bad_qty_func_data_type');
2283: fnd_msg_pub.ADD;
2284: END IF;
2285:
2286: RAISE fnd_api.g_exc_error;
2287: END IF;
2323: || ',sum(base.secondary_quantity) ' || g_line_feed -- new
2324: || ',base.grade_code ' || g_line_feed; -- new
2325: END IF;
2326: ELSE
2327: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2328: fnd_message.set_name('WMS', 'WMS_BAD_PARAMETER_TYPE_CODE');
2329: fnd_message.set_token('PARAMETER_TYPE_CODE', l_parameter_type_code);
2330: log_error_msg(l_api_name, 'bad_param_type_code_qty');
2331: fnd_msg_pub.ADD;
2327: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2328: fnd_message.set_name('WMS', 'WMS_BAD_PARAMETER_TYPE_CODE');
2329: fnd_message.set_token('PARAMETER_TYPE_CODE', l_parameter_type_code);
2330: log_error_msg(l_api_name, 'bad_param_type_code_qty');
2331: fnd_msg_pub.ADD;
2332: END IF;
2333:
2334: RAISE fnd_api.g_exc_error;
2335: END IF; -- parameter type code = 1
2412: || ' '
2413: || l_operator
2414: || ' ';
2415: ELSE
2416: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2417: fnd_message.set_name('WMS', 'WMS_BAD_PARAMETER_TYPE_CODE');
2418: fnd_message.set_token('PARAMETER_TYPE_CODE', l_parameter_type_code);
2419: log_error_msg(l_api_name, 'bad_param_type_code_left_rest');
2420: fnd_msg_pub.ADD;
2416: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2417: fnd_message.set_name('WMS', 'WMS_BAD_PARAMETER_TYPE_CODE');
2418: fnd_message.set_token('PARAMETER_TYPE_CODE', l_parameter_type_code);
2419: log_error_msg(l_api_name, 'bad_param_type_code_left_rest');
2420: fnd_msg_pub.ADD;
2421: END IF;
2422:
2423: RAISE fnd_api.g_exc_error;
2424: END IF;
2505: || l_operand_expression
2506: || l_bracket_close
2507: || g_line_feed;
2508: ELSE
2509: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2510: fnd_message.set_name('WMS', 'WMS_BAD_PARENT_PARA_TYPE');
2511: fnd_message.set_token('PARENT_PARAMETER_TYPE_CODE', l_parent_parameter_type_code);
2512: log_error_msg(l_api_name, 'bad_parent_param_type_right_rest');
2513: fnd_msg_pub.ADD;
2509: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2510: fnd_message.set_name('WMS', 'WMS_BAD_PARENT_PARA_TYPE');
2511: fnd_message.set_token('PARENT_PARAMETER_TYPE_CODE', l_parent_parameter_type_code);
2512: log_error_msg(l_api_name, 'bad_parent_param_type_right_rest');
2513: fnd_msg_pub.ADD;
2514: END IF;
2515:
2516: RAISE fnd_api.g_exc_error;
2517: END IF;
2552: || 'END_DATE_ACTIVE,sysdate+1) )'
2553: || l_bracket_close
2554: || g_line_feed;
2555: ELSE
2556: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2557: fnd_message.set_name('WMS', 'WMS_BAD_REF_FLEXVSET_DATA');
2558: fnd_message.set_token('DATATYPE', l_validation_type);
2559: log_error_msg(l_api_name, 'bad_ref_flexvset_data');
2560: fnd_msg_pub.ADD;
2556: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2557: fnd_message.set_name('WMS', 'WMS_BAD_REF_FLEXVSET_DATA');
2558: fnd_message.set_token('DATATYPE', l_validation_type);
2559: log_error_msg(l_api_name, 'bad_ref_flexvset_data');
2560: fnd_msg_pub.ADD;
2561: END IF;
2562:
2563: RAISE fnd_api.g_exc_error;
2564: END IF;
2564: END IF;
2565: ELSIF l_operand_type_code = 7 THEN -- right side = nothing
2566: g_rule_where := g_rule_where || l_bracket_close || g_line_feed;
2567: ELSE
2568: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2569: fnd_message.set_name('WMS', 'WMS_BAD_OPERAND_TYPE_CODE');
2570: fnd_message.set_token('OPERAND_TYPE_CODE', l_operand_type_code);
2571: fnd_msg_pub.ADD;
2572: END IF;
2567: ELSE
2568: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2569: fnd_message.set_name('WMS', 'WMS_BAD_OPERAND_TYPE_CODE');
2570: fnd_message.set_token('OPERAND_TYPE_CODE', l_operand_type_code);
2571: fnd_msg_pub.ADD;
2572: END IF;
2573:
2574: RAISE fnd_api.g_exc_error;
2575: END IF;
2683:
2684: g_rule_group_by := g_rule_group_by || ',' || l_expression;
2685: END IF;
2686: ELSE
2687: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2688: fnd_message.set_name('WMS', 'WMS_BAD_PARAMETER_TYPE_CODE');
2689: fnd_message.set_token('OPERAND_TYPE_CODE', l_parameter_type_code);
2690: log_error_msg(l_api_name, 'bad_param_type_code_sort');
2691: fnd_msg_pub.ADD;
2687: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2688: fnd_message.set_name('WMS', 'WMS_BAD_PARAMETER_TYPE_CODE');
2689: fnd_message.set_token('OPERAND_TYPE_CODE', l_parameter_type_code);
2690: log_error_msg(l_api_name, 'bad_param_type_code_sort');
2691: fnd_msg_pub.ADD;
2692: END IF;
2693:
2694: RAISE fnd_api.g_exc_error;
2695: END IF;
2742: ELSE
2743: fnd_message.set_name('WMS', 'WMS_BAD_PARAMETER_TYPE_CODE');
2744: fnd_message.set_token('OPERAND_TYPE_CODE', l_parameter_type_code);
2745: log_error_msg(l_api_name, 'bad_param_type_code_consist');
2746: fnd_msg_pub.ADD;
2747: RAISE fnd_api.g_exc_error;
2748: END IF;
2749: END LOOP;
2750:
2883: -- end of debugging section
2884: EXCEPTION
2885: WHEN fnd_api.g_exc_error THEN
2886: x_return_status := fnd_api.g_ret_sts_error;
2887: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2888: --
2889: log_error(l_api_name, 'error', 'Error - ' || x_msg_data);
2890: --
2891: WHEN fnd_api.g_exc_unexpected_error THEN
2889: log_error(l_api_name, 'error', 'Error - ' || x_msg_data);
2890: --
2891: WHEN fnd_api.g_exc_unexpected_error THEN
2892: x_return_status := fnd_api.g_ret_sts_unexp_error;
2893: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2894: --
2895: log_error(l_api_name, 'unexp_error', 'Unexpected error - ' || x_msg_data);
2896:
2897: WHEN OTHERS THEN
2916: END IF;
2917:
2918: x_return_status := fnd_api.g_ret_sts_unexp_error;
2919:
2920: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2921: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2922: END IF;
2923:
2924: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2917:
2918: x_return_status := fnd_api.g_ret_sts_unexp_error;
2919:
2920: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2921: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2922: END IF;
2923:
2924: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2925: --
2920: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2921: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2922: END IF;
2923:
2924: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2925: --
2926: log_error(l_api_name, 'other_error', 'Other error - ' || x_msg_data);
2927: --
2928: END buildrulesql;
3157: EXCEPTION
3158: WHEN OTHERS THEN
3159: x_return_status := fnd_api.g_ret_sts_unexp_error;
3160:
3161: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3162: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3163: END IF;
3164:
3165: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3158: WHEN OTHERS THEN
3159: x_return_status := fnd_api.g_ret_sts_unexp_error;
3160:
3161: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3162: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3163: END IF;
3164:
3165: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3166: --
3161: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3162: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3163: END IF;
3164:
3165: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3166: --
3167: log_error(l_api_name, 'other_error', 'Other error - ' || x_msg_data);
3168: --
3169: END buildinputsql;
3375:
3376: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');
3377: fnd_message.set_token('LIST_PKG', l_list_pkg);
3378: fnd_message.set_token('RULE_NAME', l_package_name);
3379: fnd_msg_pub.ADD;
3380: IF l_debug = 1 THEN
3381: log_error(l_api_name, 'execute_fetch_rule', 'Invalid Package, Contact your DBA - '
3382: || l_list_pkg || ' / ' || l_package_name);
3383: END IF;
3385:
3386: WHEN OTHERS THEN
3387: x_return_status := fnd_api.g_ret_sts_unexp_error;
3388:
3389: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3390: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3391: END IF;
3392:
3393: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3386: WHEN OTHERS THEN
3387: x_return_status := fnd_api.g_ret_sts_unexp_error;
3388:
3389: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3390: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3391: END IF;
3392:
3393: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3394: IF l_debug = 1 THEN
3389: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3390: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3391: END IF;
3392:
3393: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3394: IF l_debug = 1 THEN
3395: log_error(l_api_name, 'other_error', 'Other error - ' || x_msg_data);
3396: END IF;
3397: RAISE fnd_api.g_exc_unexpected_error;
3536: x_return_status := fnd_api.g_ret_sts_unexp_error;
3537: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');
3538: fnd_message.set_token('LIST_PKG', l_list_pkg);
3539: fnd_message.set_token('RULE_NAME', l_package_name);
3540: fnd_msg_pub.ADD;
3541:
3542: IF l_debug = 1 THEN
3543: log_error(l_api_name, 'execute_fetch_rule', 'Invalid Package, Contact your DBA - '
3544: || l_list_pkg || ' / ' || l_package_name);
3546: RAISE fnd_api.g_exc_unexpected_error;
3547: WHEN OTHERS THEN
3548: x_return_status := fnd_api.g_ret_sts_unexp_error;
3549:
3550: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3551: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3552: END IF;
3553:
3554: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3547: WHEN OTHERS THEN
3548: x_return_status := fnd_api.g_ret_sts_unexp_error;
3549:
3550: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3551: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3552: END IF;
3553:
3554: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3555: IF l_debug = 1 THEN
3550: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3551: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3552: END IF;
3553:
3554: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3555: IF l_debug = 1 THEN
3556: log_error(l_api_name, 'other_error', 'Other error - ' || x_msg_data);
3557: END IF;
3558: RAISE fnd_api.g_exc_unexpected_error;
3712: WMS_ENGINE_PVT.G_SUGG_FAILURE_MESSAGE := 'Invalid Package, Contact your DBA - '|| l_list_pkg || ' / ' || l_package_name;
3713: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');
3714: fnd_message.set_token('LIST_PKG', l_list_pkg);
3715: fnd_message.set_token('RULE_NAME', l_package_name);
3716: fnd_msg_pub.ADD;
3717:
3718: IF l_debug = 1 THEN
3719: log_error(l_api_name, 'execute_open_rule', 'Invalid Package, Contact your DBA - '
3720: || l_list_pkg || ' / ' || l_package_name);
3829: WMS_ENGINE_PVT.G_SUGG_FAILURE_MESSAGE := 'Invalid Package, Contact your DBA - '|| l_list_pkg || ' / ' || l_package_name;
3830: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');
3831: fnd_message.set_token('LIST_PKG', l_list_pkg);
3832: fnd_message.set_token('RULE_NAME', l_package_name);
3833: fnd_msg_pub.ADD;
3834:
3835: IF l_debug = 1 THEN
3836: log_error(l_api_name, 'execute_open_rule', 'Invalid Package, Contact your DBA - '
3837: || l_list_pkg || ' / ' || l_package_name);
3881: x_return_status := fnd_api.g_ret_sts_unexp_error;
3882: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');
3883: fnd_message.set_token('LIST_PKG', l_list_pkg);
3884: fnd_message.set_token('RULE_NAME', l_package_name);
3885: fnd_msg_pub.ADD;
3886: /*log_error(l_api_name, 'execute_op_rule', 'Invalid Package, Contact your DBA - '
3887: || l_list_pkg || ' / ' || l_package_name); */
3888: END execute_op_rule;
3889:
3931: x_return_status := fnd_api.g_ret_sts_unexp_error;
3932: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');
3933: fnd_message.set_token('LIST_PKG', l_list_pkg);
3934: fnd_message.set_token('RULE_NAME', l_package_name);
3935: fnd_msg_pub.ADD;
3936: /*log_error(l_api_name, 'execute_task_rule', 'Invalid Package, Contact your DBA - '
3937: || l_list_pkg || ' / ' || l_package_name); */
3938:
3939: END execute_task_rule;
3984: x_return_status := fnd_api.g_ret_sts_unexp_error;
3985: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');
3986: fnd_message.set_token('LIST_PKG', l_list_pkg);
3987: fnd_message.set_token('RULE_NAME', l_package_name);
3988: fnd_msg_pub.ADD;
3989: /*log_error(l_api_name, 'execute_label_rule', 'Invalid Package, Contact your DBA - '
3990: || l_list_pkg || ' / ' || l_package_name); */
3991:
3992: END execute_label_rule;
4026: /* -- WMS_ENGINE_PVT.G_SUGG_FAILURE_MESSAGE := 'Invalid Package, Contact your DBA - '|| l_list_pkg || ' / ' || l_package_name;
4027: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');
4028: fnd_message.set_token('LIST_PKG', l_list_pkg);
4029: fnd_message.set_token('RULE_NAME', l_package_name);
4030: fnd_msg_pub.ADD;
4031: log_error(l_api_name, 'execute_close_rule', 'Invalid Package, Contact your DBA - '
4032: || l_list_pkg || ' / ' || l_package_name); */
4033: RAISE fnd_api.g_exc_unexpected_error;
4034: END close_pick_rule;
4063: /*WMS_ENGINE_PVT.G_SUGG_FAILURE_MESSAGE := 'Invalid Package, Contact your DBA - '|| l_list_pkg || ' / ' || l_package_name;
4064: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');
4065: fnd_message.set_token('LIST_PKG', l_list_pkg);
4066: fnd_message.set_token('RULE_NAME', l_package_name);
4067: fnd_msg_pub.ADD;
4068: log_error(l_api_name, 'execute_close_rule', 'Invalid Package, Contact your DBA - '
4069: || l_list_pkg || ' / ' || l_package_name);*/
4070: RAISE fnd_api.g_exc_unexpected_error;
4071: END close_put_rule;
4168: EXCEPTION
4169: WHEN OTHERS THEN
4170: x_return_status := fnd_api.g_ret_sts_unexp_error;
4171:
4172: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4173: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
4174: END IF;
4175:
4176: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4169: WHEN OTHERS THEN
4170: x_return_status := fnd_api.g_ret_sts_unexp_error;
4171:
4172: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4173: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
4174: END IF;
4175:
4176: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4177:
4172: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4173: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
4174: END IF;
4175:
4176: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4177:
4178: IF l_debug = 1 THEN
4179: log_error(l_api_name, 'other_error', 'Other error - ' || x_msg_data);
4180: END IF;
4806:
4807: EXCEPTION
4808: WHEN fnd_api.g_exc_error THEN
4809: x_return_status := fnd_api.g_ret_sts_error;
4810: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4811: --
4812: IF l_debug = 1 THEN
4813: log_error(l_api_name, 'error', 'Error - ' || x_msg_data);
4814: END IF;
4814: END IF;
4815:
4816: WHEN fnd_api.g_exc_unexpected_error THEN
4817: x_return_status := fnd_api.g_ret_sts_unexp_error;
4818: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4819: IF l_debug = 1 THEN
4820: log_error(l_api_name, 'unexp_error', 'Unexpected error - ' || x_msg_data);
4821: END IF;
4822:
4822:
4823: WHEN OTHERS THEN
4824: x_return_status := fnd_api.g_ret_sts_unexp_error;
4825:
4826: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4827: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
4828: END IF;
4829:
4830: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4823: WHEN OTHERS THEN
4824: x_return_status := fnd_api.g_ret_sts_unexp_error;
4825:
4826: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4827: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
4828: END IF;
4829:
4830: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4831: IF l_debug = 1 THEN
4826: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4827: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
4828: END IF;
4829:
4830: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4831: IF l_debug = 1 THEN
4832: log_error(l_api_name, 'other_error', 'Other error - ' || x_msg_data);
4833: END IF;
4834:
5372:
5373: EXCEPTION
5374: WHEN fnd_api.g_exc_error THEN
5375: x_return_status := fnd_api.g_ret_sts_error;
5376: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5377: --
5378: IF l_debug = 1 THEN
5379: log_error(l_api_name, 'error', 'Error - ' || x_msg_data);
5380: END IF;
5380: END IF;
5381:
5382: WHEN fnd_api.g_exc_unexpected_error THEN
5383: x_return_status := fnd_api.g_ret_sts_unexp_error;
5384: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5385: IF l_debug = 1 THEN
5386: log_error(l_api_name, 'unexp_error', 'Unexpected error - ' || x_msg_data);
5387: END IF;
5388:
5388:
5389: WHEN OTHERS THEN
5390: x_return_status := fnd_api.g_ret_sts_unexp_error;
5391:
5392: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
5393: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
5394: END IF;
5395:
5396: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5389: WHEN OTHERS THEN
5390: x_return_status := fnd_api.g_ret_sts_unexp_error;
5391:
5392: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
5393: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
5394: END IF;
5395:
5396: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5397: IF l_debug = 1 THEN
5392: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
5393: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
5394: END IF;
5395:
5396: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5397: IF l_debug = 1 THEN
5398: log_error(l_api_name, 'other_error', 'Other error - ' || x_msg_data);
5399: END IF;
5400:
5514: END IF;
5515: EXCEPTION
5516: WHEN fnd_api.g_exc_error THEN
5517: x_return_status := fnd_api.g_ret_sts_error;
5518: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5519: IF l_debug = 1 THEN
5520: log_error(l_api_name, 'error', 'Error - ' || x_msg_data);
5521: END IF;
5522:
5521: END IF;
5522:
5523: WHEN fnd_api.g_exc_unexpected_error THEN
5524: x_return_status := fnd_api.g_ret_sts_unexp_error;
5525: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5526: IF l_debug = 1 THEN
5527: log_error(l_api_name, 'unexp_error', 'Unexpected error - ' || x_msg_data);
5528: END IF;
5529:
5529:
5530: WHEN OTHERS THEN
5531: x_return_status := fnd_api.g_ret_sts_unexp_error;
5532:
5533: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
5534: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
5535: END IF;
5536:
5537: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5530: WHEN OTHERS THEN
5531: x_return_status := fnd_api.g_ret_sts_unexp_error;
5532:
5533: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
5534: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
5535: END IF;
5536:
5537: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5538: IF l_debug = 1 THEN
5533: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
5534: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
5535: END IF;
5536:
5537: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5538: IF l_debug = 1 THEN
5539: log_error(l_api_name, 'other_error', 'Other error - ' || x_msg_data);
5540: END IF;
5541:
6019: EXCEPTION
6020: WHEN fnd_api.g_exc_error THEN
6021: x_return_status := fnd_api.g_ret_sts_error;
6022: x_success := FALSE;
6023: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
6024: IF l_debug = 1 THEN
6025: log_error(l_api_name, 'error', 'Error - ' || x_msg_data);
6026: END IF;
6027:
6027:
6028: WHEN fnd_api.g_exc_unexpected_error THEN
6029: x_return_status := fnd_api.g_ret_sts_unexp_error;
6030: x_success := FALSE;
6031: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
6032: IF l_debug = 1 THEN
6033: log_error(l_api_name, 'unexp_error', 'Unexpected error - ' || x_msg_data);
6034: END IF;
6035: WHEN OTHERS THEN
6035: WHEN OTHERS THEN
6036: x_return_status := fnd_api.g_ret_sts_unexp_error;
6037: x_success := FALSE;
6038:
6039: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
6040: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
6041: END IF;
6042:
6043: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
6036: x_return_status := fnd_api.g_ret_sts_unexp_error;
6037: x_success := FALSE;
6038:
6039: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
6040: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
6041: END IF;
6042:
6043: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
6044: IF l_debug = 1 THEN
6039: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
6040: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
6041: END IF;
6042:
6043: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
6044: IF l_debug = 1 THEN
6045: log_error(l_api_name, 'other_error', 'Other error - ' || x_msg_data);
6046: END IF;
6047:
6284: END IF;
6285: EXCEPTION
6286: WHEN fnd_api.g_exc_error THEN
6287: x_return_status := fnd_api.g_ret_sts_error;
6288: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
6289: IF l_debug = 1 THEN
6290: log_error(l_api_name, 'error', 'Error - ' || x_msg_data);
6291: END IF;
6292: --
6291: END IF;
6292: --
6293: WHEN fnd_api.g_exc_unexpected_error THEN
6294: x_return_status := fnd_api.g_ret_sts_unexp_error;
6295: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
6296: IF l_debug = 1 THEN
6297: log_error(l_api_name, 'unexp_error', 'Unexpected error - ' || x_msg_data);
6298: END IF;
6299:
6299:
6300: WHEN OTHERS THEN
6301: x_return_status := fnd_api.g_ret_sts_unexp_error;
6302:
6303: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
6304: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
6305: END IF;
6306:
6307: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
6300: WHEN OTHERS THEN
6301: x_return_status := fnd_api.g_ret_sts_unexp_error;
6302:
6303: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
6304: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
6305: END IF;
6306:
6307: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
6308: IF l_debug = 1 THEN
6303: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
6304: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
6305: END IF;
6306:
6307: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
6308: IF l_debug = 1 THEN
6309: log_error(l_api_name, 'other_error', 'Other error - ' || x_msg_data);
6310: END IF;
6311:
6809: END IF;
6810:
6811: -- Initialize message list if p_init_msg_list is set to TRUE
6812: IF fnd_api.to_boolean(p_init_msg_list) THEN
6813: fnd_msg_pub.initialize;
6814: END IF;
6815:
6816: -- LPN Status Project
6817: if (inv_cache.set_org_rec(p_organization_id)) then
6834: -- requires this
6835: IF p_validation_level <> fnd_api.g_valid_level_none THEN
6836: IF p_type_code IS NULL
6837: OR p_type_code = fnd_api.g_miss_num THEN
6838: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
6839: fnd_message.set_name('WMS', 'WMS_RULE_TYPE_CODE_MISSING');
6840: fnd_msg_pub.ADD;
6841:
6842: IF l_debug = 1 THEN
6836: IF p_type_code IS NULL
6837: OR p_type_code = fnd_api.g_miss_num THEN
6838: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
6839: fnd_message.set_name('WMS', 'WMS_RULE_TYPE_CODE_MISSING');
6840: fnd_msg_pub.ADD;
6841:
6842: IF l_debug = 1 THEN
6843: log_error_msg(l_api_name, 'type_code_missing');
6844: END IF;
6901: END IF;
6902:
6903: IF p_partial_success_allowed_flag IS NULL
6904: OR p_partial_success_allowed_flag = fnd_api.g_miss_char THEN
6905: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
6906: fnd_message.set_name('WMS', 'WMS_PARTIAL_SUCC_FLAG_MISS');
6907: IF l_debug = 1 THEN
6908: log_error_msg(l_api_name, 'partial_succ_flag_missing');
6909: END IF;
6906: fnd_message.set_name('WMS', 'WMS_PARTIAL_SUCC_FLAG_MISS');
6907: IF l_debug = 1 THEN
6908: log_error_msg(l_api_name, 'partial_succ_flag_missing');
6909: END IF;
6910: fnd_msg_pub.ADD;
6911: END IF;
6912: RAISE fnd_api.g_exc_error;
6913: END IF;
6914:
6913: END IF;
6914:
6915: IF p_transaction_temp_id IS NULL
6916: OR p_transaction_temp_id = fnd_api.g_miss_num THEN
6917: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
6918: fnd_message.set_name('WMS', 'WMS_TRX_REQ_LINE_ID_MISS');
6919: fnd_msg_pub.ADD;
6920: IF l_debug = 1 THEN
6921: log_error_msg(l_api_name, 'trx_req_line_id_missing');
6915: IF p_transaction_temp_id IS NULL
6916: OR p_transaction_temp_id = fnd_api.g_miss_num THEN
6917: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
6918: fnd_message.set_name('WMS', 'WMS_TRX_REQ_LINE_ID_MISS');
6919: fnd_msg_pub.ADD;
6920: IF l_debug = 1 THEN
6921: log_error_msg(l_api_name, 'trx_req_line_id_missing');
6922: END IF;
6923: END IF;
6925: END IF;
6926:
6927: IF p_organization_id IS NULL
6928: OR p_organization_id = fnd_api.g_miss_num THEN
6929: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
6930: fnd_message.set_name('INV', 'INV_NO_ORG_INFORMATION');
6931: fnd_msg_pub.ADD;
6932: IF l_debug = 1 THEN
6933: log_error_msg(l_api_name, 'org_id_missing');
6927: IF p_organization_id IS NULL
6928: OR p_organization_id = fnd_api.g_miss_num THEN
6929: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
6930: fnd_message.set_name('INV', 'INV_NO_ORG_INFORMATION');
6931: fnd_msg_pub.ADD;
6932: IF l_debug = 1 THEN
6933: log_error_msg(l_api_name, 'org_id_missing');
6934: END IF;
6935: END IF;
6938: END IF;
6939:
6940: IF p_inventory_item_id IS NULL
6941: OR p_inventory_item_id = fnd_api.g_miss_num THEN
6942: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
6943: fnd_message.set_name('INV', 'INV_ITEM_ID_REQUIRED');
6944: fnd_msg_pub.ADD;
6945: IF l_debug = 1 THEN
6946: log_error_msg(l_api_name, 'item_id_missing');
6940: IF p_inventory_item_id IS NULL
6941: OR p_inventory_item_id = fnd_api.g_miss_num THEN
6942: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
6943: fnd_message.set_name('INV', 'INV_ITEM_ID_REQUIRED');
6944: fnd_msg_pub.ADD;
6945: IF l_debug = 1 THEN
6946: log_error_msg(l_api_name, 'item_id_missing');
6947: END IF;
6948: END IF;
6953: IF p_type_code = 2
6954: AND (p_tree_id IS NULL
6955: OR p_tree_id = fnd_api.g_miss_num
6956: ) THEN
6957: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
6958: fnd_message.set_name('INV', 'INV_QTY_TREE_ID_MISSING');
6959: fnd_msg_pub.ADD;
6960: IF l_debug = 1 THEN
6961: log_error_msg(l_api_name, 'qty_tree_id_missing');
6955: OR p_tree_id = fnd_api.g_miss_num
6956: ) THEN
6957: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
6958: fnd_message.set_name('INV', 'INV_QTY_TREE_ID_MISSING');
6959: fnd_msg_pub.ADD;
6960: IF l_debug = 1 THEN
6961: log_error_msg(l_api_name, 'qty_tree_id_missing');
6962: END IF;
6963: END IF;
7627: log_statement(l_api_name, 'pack_name', 'Package name: ' || l_package_name);
7628: END IF;
7629: fnd_message.set_name('WMS', 'WMS_PACKAGE_MISSING');
7630: fnd_message.set_token('RULEID', l_rule_id);
7631: fnd_msg_pub.ADD;
7632: RAISE fnd_api.g_exc_unexpected_error;
7633: END IF;
7634: END LOOP;
7635:
10894:
10895: ROLLBACK TO applyrulesp;
10896: freeglobals;
10897: x_return_status := fnd_api.g_ret_sts_error;
10898: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
10899: IF l_debug = 1 THEN
10900: log_error(l_api_name, 'error', 'Expected error - ' || x_msg_data);
10901: END IF;
10902: --
10937:
10938: ROLLBACK TO applyrulesp;
10939: freeglobals;
10940: x_return_status := fnd_api.g_ret_sts_unexp_error;
10941: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
10942: IF l_debug = 1 THEN
10943: log_error(l_api_name, 'unexp_error', 'Unexpected error - ' || x_msg_data);
10944: END IF;
10945: --
10981: ROLLBACK TO applyrulesp;
10982: freeglobals;
10983: x_return_status := fnd_api.g_ret_sts_unexp_error;
10984:
10985: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
10986: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
10987: END IF;
10988:
10989: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
10982: freeglobals;
10983: x_return_status := fnd_api.g_ret_sts_unexp_error;
10984:
10985: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
10986: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
10987: END IF;
10988:
10989: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
10990: IF l_debug = 1 THEN
10985: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
10986: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
10987: END IF;
10988:
10989: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
10990: IF l_debug = 1 THEN
10991: log_error(l_api_name, 'other_error', 'Other error - ' || x_msg_data);
10992: END IF;
10993: END apply;
11056: RETURN l_locator_control;
11057: EXCEPTION
11058: WHEN invalid_loc_control_exception THEN
11059: fnd_message.set_name('INV','INV_INVALID_LOC_CONTROL');
11060: fnd_msg_pub.ADD;
11061: --
11062: x_return_status := fnd_api.g_ret_sts_error ;
11063: l_locator_control := -1 ;
11064: RETURN l_locator_control ;
11075: --
11076: WHEN OTHERS THEN
11077: x_return_status := fnd_api.g_ret_sts_unexp_error ;
11078: --
11079: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)) THEN
11080: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
11081: END IF;
11082: --
11083: l_locator_control := -1 ;
11076: WHEN OTHERS THEN
11077: x_return_status := fnd_api.g_ret_sts_unexp_error ;
11078: --
11079: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)) THEN
11080: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
11081: END IF;
11082: --
11083: l_locator_control := -1 ;
11084: RETURN l_locator_control ;
11178: IF l_subinventory_code_csr%notfound OR
11179: l_putaway_sub IS NULL THEN
11180: CLOSE l_subinventory_code_csr;
11181: fnd_message.set_name('INV','INV_NO_DEFAULT_SUB');
11182: fnd_msg_pub.ADD;
11183: RAISE fnd_api.g_exc_error;
11184: END IF;
11185: CLOSE l_subinventory_code_csr;
11186: ELSE
11193: -- default locator needs to be selected from item defaults
11194: --
11195: IF NOT l_sub_found THEN
11196: fnd_message.set_name('INV','INV_NO_SUB_LOC_CONTROL');
11197: fnd_msg_pub.ADD;
11198: RAISE fnd_api.g_exc_error;
11199: END if;
11200:
11201: l_sub_loc_control := INV_CACHE.tosub_rec.locator_type;
11235: FETCH l_locator_csr INTO l_putaway_loc;
11236: IF l_locator_csr%notfound OR l_putaway_loc IS NULL THEN
11237: CLOSE l_locator_csr;
11238: fnd_message.set_name('INV','INV_NO_DEFAULT_LOC');
11239: fnd_msg_pub.ADD;
11240:
11241: RAISE fnd_api.g_exc_error;
11242: END IF;
11243: ELSE
11275: If l_putaway_cg IS NULL Then
11276: l_putaway_cg := l_putaway_cg_org;
11277: if l_putaway_cg IS NULL then
11278: fnd_message.set_name('INV','INV_NO_DEFAULT_COST_GROUP');
11279: fnd_msg_pub.ADD;
11280: RAISE fnd_api.g_exc_error;
11281: end if;
11282: End If;
11283: ELSE
11320: x_putaway_loc := NULL;
11321: x_putaway_sub := NULL;
11322: x_putaway_cost_group_id := NULL;
11323: --
11324: IF (fnd_msg_pub.check_msg_level
11325: (fnd_msg_pub.g_msg_lvl_unexp_error)) THEN
11326: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
11327: END IF;
11328: --
11321: x_putaway_sub := NULL;
11322: x_putaway_cost_group_id := NULL;
11323: --
11324: IF (fnd_msg_pub.check_msg_level
11325: (fnd_msg_pub.g_msg_lvl_unexp_error)) THEN
11326: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
11327: END IF;
11328: --
11329:
11322: x_putaway_cost_group_id := NULL;
11323: --
11324: IF (fnd_msg_pub.check_msg_level
11325: (fnd_msg_pub.g_msg_lvl_unexp_error)) THEN
11326: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
11327: END IF;
11328: --
11329:
11330: END get_putaway_defaults ;
11484: END IF;
11485:
11486: -- Initialize message list if p_init_msg_list is set to TRUE
11487: IF fnd_api.to_boolean( p_init_msg_list ) THEN
11488: fnd_msg_pub.initialize;
11489: END IF;
11490: --
11491: -- Initialize API return status to success
11492: x_return_status := fnd_api.g_ret_sts_success;
11498: -- requires this
11499: IF p_validation_level <> fnd_api.g_valid_level_none THEN
11500: IF p_transaction_temp_id IS NULL OR
11501: p_transaction_temp_id = fnd_api.g_miss_num THEN
11502: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
11503: fnd_message.set_name('WMS','WMS_TRX_REQ_LINE_ID_MISS');
11504: If (l_debug = 1) then
11505: log_error_msg(l_api_name, 'trx_req_line_id_missing');
11506: End if;
11503: fnd_message.set_name('WMS','WMS_TRX_REQ_LINE_ID_MISS');
11504: If (l_debug = 1) then
11505: log_error_msg(l_api_name, 'trx_req_line_id_missing');
11506: End if;
11507: fnd_msg_pub.add;
11508: END IF;
11509: RAISE fnd_api.g_exc_error;
11510: END IF;
11511: IF p_organization_id IS NULL OR
11509: RAISE fnd_api.g_exc_error;
11510: END IF;
11511: IF p_organization_id IS NULL OR
11512: p_organization_id = fnd_api.g_miss_num THEN
11513: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
11514: fnd_message.set_name('INV','INV_NO_ORG_INFORMATION');
11515: If (l_debug = 1) then
11516: log_error_msg(l_api_name, 'org_id_missing');
11517: End if;
11514: fnd_message.set_name('INV','INV_NO_ORG_INFORMATION');
11515: If (l_debug = 1) then
11516: log_error_msg(l_api_name, 'org_id_missing');
11517: End if;
11518: fnd_msg_pub.add;
11519: END IF;
11520: RAISE fnd_api.g_exc_error;
11521: END IF;
11522: IF p_inventory_item_id IS NULL OR
11520: RAISE fnd_api.g_exc_error;
11521: END IF;
11522: IF p_inventory_item_id IS NULL OR
11523: p_inventory_item_id = fnd_api.g_miss_num THEN
11524: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
11525: fnd_message.set_name('INV','INV_ITEM_ID_REQUIRED');
11526: If (l_debug = 1) then
11527: log_error_msg(l_api_name, 'item_id_missing');
11528: End if;
11525: fnd_message.set_name('INV','INV_ITEM_ID_REQUIRED');
11526: If (l_debug = 1) then
11527: log_error_msg(l_api_name, 'item_id_missing');
11528: End if;
11529: fnd_msg_pub.add;
11530: END IF;
11531: RAISE fnd_api.g_exc_error;
11532: END IF;
11533: END IF;
12108:
12109: ROLLBACK TO ApplyRuleSP;
12110: FreeGlobals;
12111: x_return_status := fnd_api.g_ret_sts_error;
12112: fnd_msg_pub.count_and_get( p_count => x_msg_count
12113: ,p_data => x_msg_data );
12114: If (l_debug = 1) then
12115: log_error(l_api_name, 'error', 'Expected error - ' || x_msg_data);
12116: End if;
12119: WHEN fnd_api.g_exc_unexpected_error THEN
12120: ROLLBACK TO ApplyRuleSP;
12121: FreeGlobals;
12122: x_return_status := fnd_api.g_ret_sts_unexp_error;
12123: fnd_msg_pub.count_and_get( p_count => x_msg_count
12124: ,p_data => x_msg_data );
12125: If (l_debug = 1) then
12126: log_error(l_api_name, 'unexp_error', 'Unexpected error - ' || x_msg_data);
12127: End if;
12131:
12132: ROLLBACK TO ApplyRuleSP;
12133: FreeGlobals;
12134: x_return_status := fnd_api.g_ret_sts_unexp_error;
12135: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
12136: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
12137: END IF;
12138: fnd_msg_pub.count_and_get( p_count => x_msg_count
12139: ,p_data => x_msg_data );
12132: ROLLBACK TO ApplyRuleSP;
12133: FreeGlobals;
12134: x_return_status := fnd_api.g_ret_sts_unexp_error;
12135: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
12136: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
12137: END IF;
12138: fnd_msg_pub.count_and_get( p_count => x_msg_count
12139: ,p_data => x_msg_data );
12140: If (l_debug = 1) then
12134: x_return_status := fnd_api.g_ret_sts_unexp_error;
12135: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
12136: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
12137: END IF;
12138: fnd_msg_pub.count_and_get( p_count => x_msg_count
12139: ,p_data => x_msg_data );
12140: If (l_debug = 1) then
12141: log_error(l_api_name, 'other_error', 'Other error - ' || x_msg_data);
12142: End if;
12193: END IF;
12194:
12195: -- Initialize message list if p_init_msg_list is set to TRUE
12196: IF fnd_api.to_boolean(p_init_msg_list) THEN
12197: fnd_msg_pub.initialize;
12198: END IF;
12199:
12200: --
12201: -- Initialize API return status to success
12211: EXCEPTION
12212: WHEN fnd_api.g_exc_error THEN
12213: --
12214: x_return_status := fnd_api.g_ret_sts_error;
12215: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
12216: --
12217: WHEN fnd_api.g_exc_unexpected_error THEN
12218: x_return_status := fnd_api.g_ret_sts_unexp_error;
12219: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
12215: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
12216: --
12217: WHEN fnd_api.g_exc_unexpected_error THEN
12218: x_return_status := fnd_api.g_ret_sts_unexp_error;
12219: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
12220: --
12221: WHEN OTHERS THEN
12222: freeglobals;
12223: x_return_status := fnd_api.g_ret_sts_unexp_error;
12221: WHEN OTHERS THEN
12222: freeglobals;
12223: x_return_status := fnd_api.g_ret_sts_unexp_error;
12224:
12225: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
12226: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
12227: END IF;
12228:
12229: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
12222: freeglobals;
12223: x_return_status := fnd_api.g_ret_sts_unexp_error;
12224:
12225: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
12226: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
12227: END IF;
12228:
12229: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
12230: --
12225: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
12226: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
12227: END IF;
12228:
12229: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
12230: --
12231: END checksyntax;
12232:
12233: --
12312: --
12313: EXCEPTION
12314: WHEN fnd_api.g_exc_error THEN
12315: x_return_status := fnd_api.g_ret_sts_error;
12316: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
12317: --
12318: WHEN fnd_api.g_exc_unexpected_error THEN
12319: x_return_status := fnd_api.g_ret_sts_unexp_error;
12320: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
12316: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
12317: --
12318: WHEN fnd_api.g_exc_unexpected_error THEN
12319: x_return_status := fnd_api.g_ret_sts_unexp_error;
12320: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
12321: --
12322: WHEN OTHERS THEN
12323: x_return_status := fnd_api.g_ret_sts_unexp_error;
12324:
12321: --
12322: WHEN OTHERS THEN
12323: x_return_status := fnd_api.g_ret_sts_unexp_error;
12324:
12325: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
12326: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
12327: END IF;
12328:
12329: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
12322: WHEN OTHERS THEN
12323: x_return_status := fnd_api.g_ret_sts_unexp_error;
12324:
12325: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
12326: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
12327: END IF;
12328:
12329: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
12330: --
12325: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
12326: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
12327: END IF;
12328:
12329: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
12330: --
12331: END find_rule;
12332:
12333: --GetPackageName
12573:
12574: --
12575: -- Initialize message list if p_init_msg_list is set to TRUE
12576: IF fnd_api.to_boolean(p_init_msg_list) THEN
12577: fnd_msg_pub.initialize;
12578: END IF;
12579:
12580: --
12581: -- Initialize API return status to success
12588: -- Validate input parameter, if validation level requires this
12589: IF p_validation_level <> fnd_api.g_valid_level_none THEN
12590: IF p_rule_id IS NULL
12591: OR p_rule_id = fnd_api.g_miss_num THEN
12592: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
12593: fnd_message.set_name('WMS', 'WMS_RULE_ID_MISSING');
12594: log_error_msg(l_api_name, 'rule_id_missing');
12595: fnd_msg_pub.ADD;
12596: END IF;
12591: OR p_rule_id = fnd_api.g_miss_num THEN
12592: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
12593: fnd_message.set_name('WMS', 'WMS_RULE_ID_MISSING');
12594: log_error_msg(l_api_name, 'rule_id_missing');
12595: fnd_msg_pub.ADD;
12596: END IF;
12597:
12598: RAISE fnd_api.g_exc_error;
12599: END IF;
13655:
13656: --
13657:
13658: /*
13659: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
13660: fnd_message.set_name('WMS','WMS_SYNTAX_CHECK_SUCCESS');
13661: fnd_msg_pub.add;
13662: END IF;
13663: */ --
13657:
13658: /*
13659: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
13660: fnd_message.set_name('WMS','WMS_SYNTAX_CHECK_SUCCESS');
13661: fnd_msg_pub.add;
13662: END IF;
13663: */ --
13664: -- end of debugging section
13665: log_procedure(l_api_name, 'end', 'End GenerateRulePackage');
13669: --
13670: -- debugging portion
13671: -- can be commented ut for final code
13672: IF inv_pp_debug.is_debug_mode THEN
13673: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
13674: -- the message retrieved here since it is no longer on the stack
13675: inv_pp_debug.set_last_error_message(SQLERRM);
13676: inv_pp_debug.send_message_to_pipe('exception in '|| l_api_name);
13677: inv_pp_debug.send_last_error_message;
13684: END IF;
13685:
13686: freeglobals;
13687: x_return_status := fnd_api.g_ret_sts_error;
13688: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
13689: log_error(l_api_name, 'error', 'Expected error - ' || x_msg_data);
13690: --
13691: WHEN fnd_api.g_exc_unexpected_error THEN
13692: --
13692: --
13693: -- debugging portion
13694: -- can be commented ut for final code
13695: IF inv_pp_debug.is_debug_mode THEN
13696: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
13697: -- the message retrieved here since it is no longer on the stack
13698: inv_pp_debug.set_last_error_message(SQLERRM);
13699: inv_pp_debug.send_message_to_pipe('exception in '|| l_api_name);
13700: inv_pp_debug.send_last_error_message;
13707: END IF;
13708:
13709: freeglobals;
13710: fnd_message.set_name('WMS', 'WMS_PACKAGE_GEN_FAILED');
13711: fnd_msg_pub.ADD;
13712: x_return_status := fnd_api.g_ret_sts_unexp_error;
13713: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
13714: log_error(l_api_name, 'unexp_error', 'Unexpected error - ' || x_msg_data);
13715: --
13709: freeglobals;
13710: fnd_message.set_name('WMS', 'WMS_PACKAGE_GEN_FAILED');
13711: fnd_msg_pub.ADD;
13712: x_return_status := fnd_api.g_ret_sts_unexp_error;
13713: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
13714: log_error(l_api_name, 'unexp_error', 'Unexpected error - ' || x_msg_data);
13715: --
13716: WHEN OTHERS THEN
13717: --
13717: --
13718: -- debugging portion
13719: -- can be commented ut for final code
13720: IF inv_pp_debug.is_debug_mode THEN
13721: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
13722: -- the message retrieved here since it is no longer on the stack
13723: inv_pp_debug.set_last_error_message(SQLERRM);
13724: inv_pp_debug.send_message_to_pipe('exception in '|| l_api_name);
13725: inv_pp_debug.send_last_error_message;
13736: END IF;
13737:
13738: freeglobals;
13739: fnd_message.set_name('WMS', 'WMS_PACKAGE_GEN_FAILED');
13740: fnd_msg_pub.ADD;
13741: x_return_status := fnd_api.g_ret_sts_unexp_error;
13742:
13743: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
13744: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
13739: fnd_message.set_name('WMS', 'WMS_PACKAGE_GEN_FAILED');
13740: fnd_msg_pub.ADD;
13741: x_return_status := fnd_api.g_ret_sts_unexp_error;
13742:
13743: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
13744: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
13745: END IF;
13746:
13747: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
13740: fnd_msg_pub.ADD;
13741: x_return_status := fnd_api.g_ret_sts_unexp_error;
13742:
13743: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
13744: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
13745: END IF;
13746:
13747: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
13748: log_error(l_api_name, 'other_error', 'Other error - ' || x_msg_data);
13743: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
13744: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
13745: END IF;
13746:
13747: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
13748: log_error(l_api_name, 'other_error', 'Other error - ' || x_msg_data);
13749: --
13750: END generaterulepackage;
13751:
13962: END IF;
13963:
13964: -- Initialize message list if p_init_msg_list is set to TRUE
13965: IF fnd_api.to_boolean(p_init_msg_list) THEN
13966: fnd_msg_pub.initialize;
13967: END IF;
13968:
13969: --
13970: -- Initialize API return status to success
13992: execute_op_rule(l_rule_id, p_task_id, l_return_status);
13993: IF (l_return_status = -1) and l_rule_counter = 2 THEN --error
13994: fnd_message.set_name('WMS', 'WMS_PACKAGE_MISSING');
13995: fnd_message.set_token('RULEID', l_rule_id);
13996: fnd_msg_pub.ADD;
13997: log_error_msg(l_api_name, 'rule_package_missing');
13998: log_statement(l_api_name, 'pack_name', 'Package name: ' || l_package_name);
13999: RAISE fnd_api.g_exc_unexpected_error;
14000: ELSIF l_return_status <> -1 THEN
14071: ROLLBACK TO assign_operation_plan_sp;
14072: freeglobals;
14073: x_return_status := fnd_api.g_ret_sts_error;
14074:
14075: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
14076: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
14077: END IF;
14078:
14079: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
14072: freeglobals;
14073: x_return_status := fnd_api.g_ret_sts_error;
14074:
14075: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
14076: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
14077: END IF;
14078:
14079: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
14080: WHEN OTHERS THEN
14075: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
14076: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
14077: END IF;
14078:
14079: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
14080: WHEN OTHERS THEN
14081: ROLLBACK TO assign_operation_plan_sp;
14082: freeglobals;
14083: x_return_status := fnd_api.g_ret_sts_unexp_error;
14081: ROLLBACK TO assign_operation_plan_sp;
14082: freeglobals;
14083: x_return_status := fnd_api.g_ret_sts_unexp_error;
14084:
14085: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
14086: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
14087: END IF;
14088:
14089: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
14082: freeglobals;
14083: x_return_status := fnd_api.g_ret_sts_unexp_error;
14084:
14085: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
14086: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
14087: END IF;
14088:
14089: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
14090: END assign_operation_plan;
14085: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
14086: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
14087: END IF;
14088:
14089: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
14090: END assign_operation_plan;
14091:
14092: --**************************************
14093:
14343: END IF;
14344:
14345: -- Initialize message list if p_init_msg_list is set to TRUE
14346: IF fnd_api.to_boolean(p_init_msg_list) THEN
14347: fnd_msg_pub.initialize;
14348: END IF;
14349:
14350: --
14351: -- Initialize API return status to success
14382: execute_task_rule(l_rule_id, p_task_id, l_return_status);
14383: IF (l_return_status = -1) and l_rule_counter = 2 THEN --error
14384: fnd_message.set_name('WMS', 'WMS_PACKAGE_MISSING');
14385: fnd_message.set_token('RULEID', l_rule_id);
14386: fnd_msg_pub.ADD;
14387: IF l_debug = 1 THEN
14388: log_error_msg(l_api_name, 'rule_package_missing');
14389: log_statement(l_api_name, 'pack_name', 'Package name: ' || l_package_name);
14390: END IF;
14516: ROLLBACK TO assignttsp;
14517: freeglobals;
14518: x_return_status := fnd_api.g_ret_sts_error;
14519:
14520: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
14521: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
14522: END IF;
14523:
14524: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
14517: freeglobals;
14518: x_return_status := fnd_api.g_ret_sts_error;
14519:
14520: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
14521: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
14522: END IF;
14523:
14524: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
14525: WHEN OTHERS THEN
14520: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
14521: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
14522: END IF;
14523:
14524: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
14525: WHEN OTHERS THEN
14526: ROLLBACK TO assignttsp;
14527: freeglobals;
14528: x_return_status := fnd_api.g_ret_sts_unexp_error;
14526: ROLLBACK TO assignttsp;
14527: freeglobals;
14528: x_return_status := fnd_api.g_ret_sts_unexp_error;
14529:
14530: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
14531: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
14532: END IF;
14533:
14534: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
14527: freeglobals;
14528: x_return_status := fnd_api.g_ret_sts_unexp_error;
14529:
14530: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
14531: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
14532: END IF;
14533:
14534: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
14535: END assigntt;
14530: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
14531: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
14532: END IF;
14533:
14534: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
14535: END assigntt;
14536:
14537: --
14538: -- API name : CalcRuleWeight
14702: END IF;
14703:
14704: -- Initialize message list if p_init_msg_list is set to TRUE
14705: IF fnd_api.to_boolean(p_init_msg_list) THEN
14706: fnd_msg_pub.initialize;
14707: END IF;
14708:
14709: --
14710: -- Initialize API return status to success
14728: IF l_debug = 1 THEN
14729: TRACE('Invalid Label Request Id : '|| p_label_request_id);
14730: END IF;
14731: fnd_message.set_name('WMS', 'INVALID_LABEL_REQ');
14732: fnd_msg_pub.ADD;
14733: RAISE fnd_api.g_exc_error;
14734: END IF;
14735:
14736: CLOSE l_label_requests_curs;
14761: log_statement(l_api_name, 'pack_name', 'Package name: ' || l_package_name);
14762: IF (l_return_status = -1) and l_rule_counter = 2 THEN --error
14763: fnd_message.set_name('WMS', 'WMS_PACKAGE_MISSING');
14764: fnd_message.set_token('RULEID', l_rule_id);
14765: fnd_msg_pub.ADD;
14766: IF l_debug = 1 THEN
14767: log_error_msg(l_api_name, 'rule_package_missing');
14768: log_error(l_api_name, 'Rule missing in the list pkg', 'l_rule_id ' || l_rule_id);
14769: END IF;
14850:
14851: ROLLBACK TO assignlabelsp;
14852: freeglobals;
14853: x_return_status := fnd_api.g_ret_sts_error;
14854: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
14855: WHEN OTHERS THEN
14856: l_msg_data := SQLERRM;
14857: IF l_debug = 1 THEN
14858: TRACE('EXCEPTION OTHERS: '|| l_msg_data);
14859: END IF;
14860: ROLLBACK TO assignlabelsp;
14861: freeglobals;
14862: x_return_status := fnd_api.g_ret_sts_unexp_error;
14863: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
14864: END applylabel;
14865:
14866: PROCEDURE get_wms_sys_task_type(
14867: p_move_order_type IN NUMBER
14966: END IF;
14967: EXCEPTION
14968: WHEN OTHERS THEN
14969: retcode := 2;
14970: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
14971: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Compile All Rule Packages');
14972: END IF;
14973:
14974: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);
14967: EXCEPTION
14968: WHEN OTHERS THEN
14969: retcode := 2;
14970: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
14971: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Compile All Rule Packages');
14972: END IF;
14973:
14974: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);
14975: --fnd_file.put_line(fnd_file.LOG, 'Exception in compile_all_rule_packages');
14970: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
14971: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Compile All Rule Packages');
14972: END IF;
14973:
14974: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);
14975: --fnd_file.put_line(fnd_file.LOG, 'Exception in compile_all_rule_packages');
14976: --fnd_file.put_line(fnd_file.LOG, l_msg_data);
14977: errbuf := errbuf || 'Error: ' || l_msg_data;
14978: END compile_all_rule_packages;
15124: RAISE fnd_api.g_exc_unexpected_error;
15125: END IF;
15126: -- Initialize message list if p_init_msg_list is set to TRUE
15127: IF fnd_api.to_boolean(p_init_msg_list) THEN
15128: fnd_msg_pub.initialize;
15129: END IF;
15130: -- Initialize API return status to success
15131: x_return_status := fnd_api.g_ret_sts_success;
15132: -- Initialize functional return status to completed
15142:
15143: IF p_type_code IS NULL
15144: OR p_type_code = fnd_api.g_miss_num
15145: OR p_type_code = 1 THEN
15146: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
15147: fnd_message.set_name('WMS', 'WMS_RULE_TYPE_CODE_MISSING');
15148: log_error_msg(l_api_name, 'type_code_missing');
15149: fnd_msg_pub.ADD;
15150: END IF;
15145: OR p_type_code = 1 THEN
15146: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
15147: fnd_message.set_name('WMS', 'WMS_RULE_TYPE_CODE_MISSING');
15148: log_error_msg(l_api_name, 'type_code_missing');
15149: fnd_msg_pub.ADD;
15150: END IF;
15151: RAISE fnd_api.g_exc_error;
15152: END IF;
15153:
15157: END IF;
15158:
15159: IF p_transaction_temp_id IS NULL
15160: OR p_transaction_temp_id = fnd_api.g_miss_num THEN
15161: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
15162: fnd_message.set_name('WMS', 'WMS_TRX_REQ_LINE_ID_MISS');
15163: log_error_msg(l_api_name, 'trx_req_line_id_missing');
15164: fnd_msg_pub.ADD;
15165: END IF;
15160: OR p_transaction_temp_id = fnd_api.g_miss_num THEN
15161: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
15162: fnd_message.set_name('WMS', 'WMS_TRX_REQ_LINE_ID_MISS');
15163: log_error_msg(l_api_name, 'trx_req_line_id_missing');
15164: fnd_msg_pub.ADD;
15165: END IF;
15166:
15167: RAISE fnd_api.g_exc_error;
15168: END IF;
15173: END IF;
15174:
15175: IF p_organization_id IS NULL
15176: OR p_organization_id = fnd_api.g_miss_num THEN
15177: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
15178: fnd_message.set_name('INV', 'INV_NO_ORG_INFORMATION');
15179: log_error_msg(l_api_name, 'org_id_missing');
15180: fnd_msg_pub.ADD;
15181: END IF;
15176: OR p_organization_id = fnd_api.g_miss_num THEN
15177: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
15178: fnd_message.set_name('INV', 'INV_NO_ORG_INFORMATION');
15179: log_error_msg(l_api_name, 'org_id_missing');
15180: fnd_msg_pub.ADD;
15181: END IF;
15182:
15183: RAISE fnd_api.g_exc_error;
15184: END IF;
15189: END IF;
15190:
15191: IF p_inventory_item_id IS NULL
15192: OR p_inventory_item_id = fnd_api.g_miss_num THEN
15193: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
15194: fnd_message.set_name('INV', 'INV_ITEM_ID_REQUIRED');
15195: log_error_msg(l_api_name, 'item_id_missing');
15196: fnd_msg_pub.ADD;
15197: END IF;
15192: OR p_inventory_item_id = fnd_api.g_miss_num THEN
15193: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
15194: fnd_message.set_name('INV', 'INV_ITEM_ID_REQUIRED');
15195: log_error_msg(l_api_name, 'item_id_missing');
15196: fnd_msg_pub.ADD;
15197: END IF;
15198:
15199: RAISE fnd_api.g_exc_error;
15200: END IF;
15206:
15207: IF (p_tree_id IS NULL
15208: OR p_tree_id = fnd_api.g_miss_num
15209: ) THEN
15210: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
15211: fnd_message.set_name('INV', 'INV_QTY_TREE_ID_MISSING');
15212: log_error_msg(l_api_name, 'qty_tree_id_missing');
15213: fnd_msg_pub.ADD;
15214: END IF;
15209: ) THEN
15210: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
15211: fnd_message.set_name('INV', 'INV_QTY_TREE_ID_MISSING');
15212: log_error_msg(l_api_name, 'qty_tree_id_missing');
15213: fnd_msg_pub.ADD;
15214: END IF;
15215:
15216: RAISE fnd_api.g_exc_error;
15217: END IF;
15338: , p_lot_number => l_lot_number );
15339: IF ( l_allowed = 'N') then
15340: WMS_ENGINE_PVT.G_SUGG_FAILURE_MESSAGE := 'WMS_ATT_SUB_STATUS_NA';
15341: fnd_message.set_name('WMS', 'WMS_ATT_SUB_STATUS_NA');
15342: fnd_msg_pub.ADD;
15343: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
15344: IF l_debug = 1 THEN
15345: log_error_msg(l_api_name, x_msg_data);
15346: END IF;
15339: IF ( l_allowed = 'N') then
15340: WMS_ENGINE_PVT.G_SUGG_FAILURE_MESSAGE := 'WMS_ATT_SUB_STATUS_NA';
15341: fnd_message.set_name('WMS', 'WMS_ATT_SUB_STATUS_NA');
15342: fnd_msg_pub.ADD;
15343: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
15344: IF l_debug = 1 THEN
15345: log_error_msg(l_api_name, x_msg_data);
15346: END IF;
15347: END IF;
15365:
15366: IF (l_onhand_status_trx_allowed = 'N') then
15367: WMS_ENGINE_PVT.G_SUGG_FAILURE_MESSAGE := 'WMS_DISALLOW_TRANSACTION';
15368: fnd_message.set_name('WMS', 'WMS_DISALLOW_TRANSACTION');
15369: fnd_msg_pub.ADD;
15370: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
15371: IF l_debug = 1 THEN
15372: log_error_msg(l_api_name, x_msg_data);
15373: END IF;
15366: IF (l_onhand_status_trx_allowed = 'N') then
15367: WMS_ENGINE_PVT.G_SUGG_FAILURE_MESSAGE := 'WMS_DISALLOW_TRANSACTION';
15368: fnd_message.set_name('WMS', 'WMS_DISALLOW_TRANSACTION');
15369: fnd_msg_pub.ADD;
15370: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
15371: IF l_debug = 1 THEN
15372: log_error_msg(l_api_name, x_msg_data);
15373: END IF;
15374: END IF;
15547: END IF;
15548:
15549: IF l_inserted_record = FALSE OR l_allocated_quantity < l_needed_quantity THEN
15550: fnd_message.set_name('WMS', 'WMS_LPN_UNAVAILABLE'); --- to be Added to Mesg Dict
15551: fnd_msg_pub.ADD;
15552: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
15553: IF l_debug = 1 THEN
15554: log_error_msg(l_api_name, x_msg_data);
15555: END IF;
15548:
15549: IF l_inserted_record = FALSE OR l_allocated_quantity < l_needed_quantity THEN
15550: fnd_message.set_name('WMS', 'WMS_LPN_UNAVAILABLE'); --- to be Added to Mesg Dict
15551: fnd_msg_pub.ADD;
15552: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
15553: IF l_debug = 1 THEN
15554: log_error_msg(l_api_name, x_msg_data);
15555: END IF;
15556:
15580:
15581: IF ( l_allowed = 'N') then
15582: WMS_ENGINE_PVT.G_SUGG_FAILURE_MESSAGE := 'WMS_ATT_SUB_STATUS_NA';
15583: fnd_message.set_name('WMS', 'WMS_ATT_SUB_STATUS_NA');
15584: fnd_msg_pub.ADD;
15585:
15586: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
15587: IF l_debug = 1 THEN
15588: log_error_msg(l_api_name, x_msg_data);
15582: WMS_ENGINE_PVT.G_SUGG_FAILURE_MESSAGE := 'WMS_ATT_SUB_STATUS_NA';
15583: fnd_message.set_name('WMS', 'WMS_ATT_SUB_STATUS_NA');
15584: fnd_msg_pub.ADD;
15585:
15586: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
15587: IF l_debug = 1 THEN
15588: log_error_msg(l_api_name, x_msg_data);
15589: END IF;
15590:
15590:
15591: ELSIF l_serial_allowed = 'N' then
15592: WMS_ENGINE_PVT.G_SUGG_FAILURE_MESSAGE := 'WMS_ATT_SERIAL_STATUS_NA' ;
15593: fnd_message.set_name('WMS', 'WMS_ATT_SUB_STATUS_NA');
15594: fnd_msg_pub.ADD;
15595: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
15596:
15597: IF l_debug = 1 THEN
15598: log_error_msg(l_api_name, x_msg_data);
15591: ELSIF l_serial_allowed = 'N' then
15592: WMS_ENGINE_PVT.G_SUGG_FAILURE_MESSAGE := 'WMS_ATT_SERIAL_STATUS_NA' ;
15593: fnd_message.set_name('WMS', 'WMS_ATT_SUB_STATUS_NA');
15594: fnd_msg_pub.ADD;
15595: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
15596:
15597: IF l_debug = 1 THEN
15598: log_error_msg(l_api_name, x_msg_data);
15599: END IF;
15609:
15610: ROLLBACK TO QuickPicksp;
15611: freeglobals;
15612: x_return_status := fnd_api.g_ret_sts_error;
15613: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
15614:
15615: IF l_debug = 1 THEN
15616: log_error(l_api_name, 'error', 'Expected error - ' || x_msg_data);
15617: END IF;
15619: WHEN fnd_api.g_exc_unexpected_error THEN
15620: ROLLBACK TO QuickPicksp;
15621: freeglobals;
15622: x_return_status := fnd_api.g_ret_sts_unexp_error;
15623: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
15624:
15625: IF l_debug = 1 THEN
15626: log_error(l_api_name, 'unexp_error', 'Unexpected error - ' || x_msg_data);
15627: END IF;
15629: WHEN OTHERS THEN
15630: ROLLBACK TO QuickPicksp;
15631: freeglobals;
15632: x_return_status := fnd_api.g_ret_sts_unexp_error;
15633: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
15634: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
15635: END IF;
15636: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
15637:
15630: ROLLBACK TO QuickPicksp;
15631: freeglobals;
15632: x_return_status := fnd_api.g_ret_sts_unexp_error;
15633: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
15634: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
15635: END IF;
15636: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
15637:
15638: IF l_debug = 1 THEN
15632: x_return_status := fnd_api.g_ret_sts_unexp_error;
15633: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
15634: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
15635: END IF;
15636: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
15637:
15638: IF l_debug = 1 THEN
15639: log_error(l_api_name, 'other_error', 'Other error - ' || x_msg_data);
15640: END IF;
15941: END IF;
15942:
15943: -- Initialize message list if p_init_msg_list is set to TRUE
15944: IF fnd_api.to_boolean(p_init_msg_list) THEN
15945: fnd_msg_pub.initialize;
15946: END IF;
15947:
15948: --
15949: -- Initialize API return status to success
15957: -- requires this
15958: IF p_validation_level <> fnd_api.g_valid_level_none THEN
15959: IF p_type_code IS NULL
15960: OR p_type_code = fnd_api.g_miss_num THEN
15961: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
15962: fnd_message.set_name('WMS', 'WMS_RULE_TYPE_CODE_MISSING');
15963: fnd_msg_pub.ADD;
15964: IF l_debug = 1 THEN
15965: log_error_msg(l_api_name, 'type_code_missing');
15959: IF p_type_code IS NULL
15960: OR p_type_code = fnd_api.g_miss_num THEN
15961: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
15962: fnd_message.set_name('WMS', 'WMS_RULE_TYPE_CODE_MISSING');
15963: fnd_msg_pub.ADD;
15964: IF l_debug = 1 THEN
15965: log_error_msg(l_api_name, 'type_code_missing');
15966: END IF;
15967: END IF;
16026:
16027: /* Lgao, Bug 5141737 select available will not check this flag, not used */
16028: /*IF p_partial_success_allowed_flag IS NULL
16029: OR p_partial_success_allowed_flag = fnd_api.g_miss_char THEN
16030: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
16031: fnd_message.set_name('WMS', 'WMS_PARTIAL_SUCC_FLAG_MISS');
16032:
16033: IF l_debug = 1 THEN
16034: log_error_msg(l_api_name, 'partial_succ_flag_missing');
16032:
16033: IF l_debug = 1 THEN
16034: log_error_msg(l_api_name, 'partial_succ_flag_missing');
16035: END IF;
16036: fnd_msg_pub.ADD;
16037: END IF;
16038:
16039: RAISE fnd_api.g_exc_error;
16040: END IF;
16041: */
16042:
16043: IF p_transaction_temp_id IS NULL
16044: OR p_transaction_temp_id = fnd_api.g_miss_num THEN
16045: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
16046: fnd_message.set_name('WMS', 'WMS_TRX_REQ_LINE_ID_MISS');
16047: fnd_msg_pub.ADD;
16048: IF l_debug = 1 THEN
16049: log_error_msg(l_api_name, 'trx_req_line_id_missing');
16043: IF p_transaction_temp_id IS NULL
16044: OR p_transaction_temp_id = fnd_api.g_miss_num THEN
16045: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
16046: fnd_message.set_name('WMS', 'WMS_TRX_REQ_LINE_ID_MISS');
16047: fnd_msg_pub.ADD;
16048: IF l_debug = 1 THEN
16049: log_error_msg(l_api_name, 'trx_req_line_id_missing');
16050: END IF;
16051:
16055: END IF;
16056:
16057: IF p_organization_id IS NULL
16058: OR p_organization_id = fnd_api.g_miss_num THEN
16059: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
16060: fnd_message.set_name('INV', 'INV_NO_ORG_INFORMATION');
16061: fnd_msg_pub.ADD;
16062: IF l_debug = 1 THEN
16063: log_error_msg(l_api_name, 'org_id_missing');
16057: IF p_organization_id IS NULL
16058: OR p_organization_id = fnd_api.g_miss_num THEN
16059: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
16060: fnd_message.set_name('INV', 'INV_NO_ORG_INFORMATION');
16061: fnd_msg_pub.ADD;
16062: IF l_debug = 1 THEN
16063: log_error_msg(l_api_name, 'org_id_missing');
16064: END IF;
16065: END IF;
16068: END IF;
16069:
16070: IF p_inventory_item_id IS NULL
16071: OR p_inventory_item_id = fnd_api.g_miss_num THEN
16072: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
16073: fnd_message.set_name('INV', 'INV_ITEM_ID_REQUIRED');
16074: fnd_msg_pub.ADD;
16075: IF l_debug = 1 THEN
16076: log_error_msg(l_api_name, 'item_id_missing');
16070: IF p_inventory_item_id IS NULL
16071: OR p_inventory_item_id = fnd_api.g_miss_num THEN
16072: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
16073: fnd_message.set_name('INV', 'INV_ITEM_ID_REQUIRED');
16074: fnd_msg_pub.ADD;
16075: IF l_debug = 1 THEN
16076: log_error_msg(l_api_name, 'item_id_missing');
16077: END IF;
16078: END IF;
16083: IF p_type_code = 2
16084: AND (p_tree_id IS NULL
16085: OR p_tree_id = fnd_api.g_miss_num
16086: ) THEN
16087: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
16088: fnd_message.set_name('INV', 'INV_QTY_TREE_ID_MISSING');
16089: fnd_msg_pub.ADD;
16090:
16091: IF l_debug = 1 THEN
16085: OR p_tree_id = fnd_api.g_miss_num
16086: ) THEN
16087: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
16088: fnd_message.set_name('INV', 'INV_QTY_TREE_ID_MISSING');
16089: fnd_msg_pub.ADD;
16090:
16091: IF l_debug = 1 THEN
16092: log_error_msg(l_api_name, 'qty_tree_id_missing');
16093: END IF;
16447: x_return_status := fnd_api.g_ret_sts_unexp_error;
16448: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');
16449: fnd_message.set_token('LIST_PKG', l_list_pkg);
16450: fnd_message.set_token('RULE_NAME', l_package_name);
16451: fnd_msg_pub.ADD;
16452: log_error(l_api_name, 'execute_fetch_rule', 'Invalid Package, Contact your DBA - '
16453: || l_list_pkg || ' / ' || l_package_name);
16454: */
16455: WHEN OTHERS THEN
16454: */
16455: WHEN OTHERS THEN
16456: x_return_status := fnd_api.g_ret_sts_unexp_error;
16457:
16458: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
16459: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
16460: END IF;
16461:
16462: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
16455: WHEN OTHERS THEN
16456: x_return_status := fnd_api.g_ret_sts_unexp_error;
16457:
16458: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
16459: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
16460: END IF;
16461:
16462: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
16463: --
16458: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
16459: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
16460: END IF;
16461:
16462: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
16463: --
16464: log_error(l_api_name, 'other_error', 'Other error - ' || x_msg_data);
16465:
16466: -- debugging portion
16465:
16466: -- debugging portion
16467: -- can be commented ut for final code
16468: IF inv_pp_debug.is_debug_mode THEN
16469: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
16470: -- the message retrieved here since it is no longer on the stack
16471: inv_pp_debug.set_last_error_message(SQLERRM);
16472: inv_pp_debug.send_message_to_pipe('exception in '|| l_api_name);
16473: inv_pp_debug.send_last_error_message;
16558: x_return_status := fnd_api.g_ret_sts_unexp_error;
16559: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');
16560: fnd_message.set_token('LIST_PKG', l_list_pkg);
16561: fnd_message.set_token('RULE_NAME', l_package_name);
16562: fnd_msg_pub.ADD;
16563: log_error(l_api_name, 'execute_fetch_rule', 'Invalid Package, Contact your DBA - '
16564: || l_list_pkg || ' / ' || l_package_name);
16565:
16566: WHEN OTHERS THEN
16565:
16566: WHEN OTHERS THEN
16567: x_return_status := fnd_api.g_ret_sts_unexp_error;
16568:
16569: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
16570: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
16571: END IF;
16572:
16573: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
16566: WHEN OTHERS THEN
16567: x_return_status := fnd_api.g_ret_sts_unexp_error;
16568:
16569: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
16570: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
16571: END IF;
16572:
16573: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
16574: --
16569: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
16570: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
16571: END IF;
16572:
16573: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
16574: --
16575: log_error(l_api_name, 'other_error', 'Other error - ' || x_msg_data);
16576:
16577: -- debugging portion
16576:
16577: -- debugging portion
16578: -- can be commented ut for final code
16579: IF inv_pp_debug.is_debug_mode THEN
16580: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
16581: -- the message retrieved here since it is no longer on the stack
16582: inv_pp_debug.set_last_error_message(SQLERRM);
16583: inv_pp_debug.send_message_to_pipe('exception in '|| l_api_name);
16584: inv_pp_debug.send_last_error_message;