eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WMS_RULE_PVT dependencies on FND_API

Line 1084: X_RETURN_STATUS := fnd_api.g_ret_sts_success;

1080: -- Initialized the value of X_RETURN_STATUS to Success
1081: -- at the start of the procedure and set its value accordingly
1082: -- when the procedure returns Failure/Error.
1083: --
1084: X_RETURN_STATUS := fnd_api.g_ret_sts_success;
1085:
1086: --- Updates the table wms_rule_list_package ,
1087: --- for all rule type package counter with value 3
1088: --- so that all three "rules list packages" for all type of

Line 1096: , p_init_msg_list => fnd_api.g_true

1092: SET package_name_count = 3;
1093:
1094: wms_rule_gen_pkgs.generateruleexecpkgs(
1095: p_api_version => 1.0
1096: , p_init_msg_list => fnd_api.g_true
1097: , p_validation_level => fnd_api.g_valid_level_full
1098: , x_return_status => l_return_status
1099: , x_msg_count => l_msg_count
1100: , x_msg_data => l_msg_data

Line 1097: , p_validation_level => fnd_api.g_valid_level_full

1093:
1094: wms_rule_gen_pkgs.generateruleexecpkgs(
1095: p_api_version => 1.0
1096: , p_init_msg_list => fnd_api.g_true
1097: , p_validation_level => fnd_api.g_valid_level_full
1098: , x_return_status => l_return_status
1099: , x_msg_count => l_msg_count
1100: , x_msg_data => l_msg_data
1101: , p_pick_code => 2

Line 1110: IF (l_return_status = fnd_api.g_ret_sts_success) THEN

1106: , p_op_code => 7
1107: , p_pkg_type => 'B'
1108: );
1109:
1110: IF (l_return_status = fnd_api.g_ret_sts_success) THEN
1111: FND_FILE.put_line(FND_FILE.LOG, 'Success from GenerateRuleExecPkgs');
1112: ELSE
1113: FND_FILE.put_line(FND_FILE.LOG, 'Error from GenerateRuleExecPkgs:');
1114: X_RETURN_STATUS := fnd_api.g_ret_sts_error; -- Expected Error

Line 1114: X_RETURN_STATUS := fnd_api.g_ret_sts_error; -- Expected Error

1110: IF (l_return_status = fnd_api.g_ret_sts_success) THEN
1111: FND_FILE.put_line(FND_FILE.LOG, 'Success from GenerateRuleExecPkgs');
1112: ELSE
1113: FND_FILE.put_line(FND_FILE.LOG, 'Error from GenerateRuleExecPkgs:');
1114: X_RETURN_STATUS := fnd_api.g_ret_sts_error; -- Expected Error
1115: retcode := 1;
1116:
1117: FOR i IN 1 .. l_msg_count LOOP
1118: --fnd_file.put_line(fnd_file.LOG, 'Error:');

Line 1126: X_RETURN_STATUS := fnd_api.g_ret_sts_unexp_error; -- Unexpecetd Error

1122: END LOOP;
1123: END IF;
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;

Line 1255: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

1251: , p_type_code IN NUMBER
1252: , p_allocation_mode_id IN NUMBER
1253: ) IS
1254: l_api_name VARCHAR2(30) := 'BuildBaseSQL';
1255: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
1256: --
1257: -- variables needed for dynamic SQL
1258: l_identifier VARCHAR2(10);
1259: -- variables for the base and input representing DB objects

Line 1276: x_return_status := fnd_api.g_ret_sts_success;

1272: --
1273: BEGIN
1274: --
1275: -- Initialize API return status to success
1276: x_return_status := fnd_api.g_ret_sts_success;
1277:
1278: --
1279: -- debugging portion
1280: -- can be commented ut for final code

Line 1429: *IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

1425: *inv_detail_util_pvt.build_sql
1426: *( x_return_status => l_return_status ,
1427: * x_sql_statement => g_pick_base
1428: * );
1429: *IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1430: * log_statement(l_api_name, 'err_build_sql',
1431: * 'Error in inv_detail_util_pvt.build_sql');
1432: * RAISE fnd_api.g_exc_unexpected_error;
1433: *ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

Line 1432: * RAISE fnd_api.g_exc_unexpected_error;

1428: * );
1429: *IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1430: * log_statement(l_api_name, 'err_build_sql',
1431: * 'Error in inv_detail_util_pvt.build_sql');
1432: * RAISE fnd_api.g_exc_unexpected_error;
1433: *ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1434: * log_statement(l_api_name, 'unexp_err_build_sql',
1435: * 'Unexp. error in inv_detail_util_pvt.build_sql');
1436: * RAISE fnd_api.g_exc_error;

Line 1433: *ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

1429: *IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1430: * log_statement(l_api_name, 'err_build_sql',
1431: * 'Error in inv_detail_util_pvt.build_sql');
1432: * RAISE fnd_api.g_exc_unexpected_error;
1433: *ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1434: * log_statement(l_api_name, 'unexp_err_build_sql',
1435: * 'Unexp. error in inv_detail_util_pvt.build_sql');
1436: * RAISE fnd_api.g_exc_error;
1437: *END IF;

Line 1436: * RAISE fnd_api.g_exc_error;

1432: * RAISE fnd_api.g_exc_unexpected_error;
1433: *ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1434: * log_statement(l_api_name, 'unexp_err_build_sql',
1435: * 'Unexp. error in inv_detail_util_pvt.build_sql');
1436: * RAISE fnd_api.g_exc_error;
1437: *END IF;
1438: *log_statement(l_api_name, 'success_build_sql',
1439: * 'Inv_detail_util_pvt.build_sql successful');
1440:

Line 1695: WHEN fnd_api.g_exc_error THEN

1691: log_procedure(l_api_name, 'end', 'End BuildBaseSql');
1692: -- end of debugging section
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);

Line 1696: x_return_status := fnd_api.g_ret_sts_error;

1692: -- end of debugging section
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: --

Line 1701: WHEN fnd_api.g_exc_unexpected_error THEN

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
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);

Line 1702: x_return_status := fnd_api.g_ret_sts_unexp_error;

1698: --
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:

Line 1709: x_return_status := fnd_api.g_ret_sts_unexp_error;

1705: log_error(l_api_name, 'unexp_error', 'Unexpected error - ' || x_msg_data);
1706:
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;

Line 2070: x_return_status := fnd_api.g_ret_sts_success;

2066: AND wpb.parameter_id = wrc.parameter_id
2067: AND wdo.db_object_id(+) = wpb.db_object_id;
2068: BEGIN
2069: -- Initialize API return status to success
2070: x_return_status := fnd_api.g_ret_sts_success;
2071:
2072: log_procedure(l_api_name, 'start', 'Start BuildRuleSql');
2073: log_statement(l_api_name, 'rule_id', 'rule_id: ' || p_rule_id);
2074: log_statement(l_api_name, 'type_code', 'type_code: ' || p_type_code);

Line 2113: x_return_status := fnd_api.g_ret_sts_success;

2109: END IF;
2110:
2111: g_rule_order := NULL;
2112: --
2113: x_return_status := fnd_api.g_ret_sts_success;
2114: RETURN;
2115: END IF;
2116:
2117: -- Find all DB objects referenced within the rule and add them to the

Line 2182: RAISE fnd_api.g_exc_error;

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;
2184:
2185: --
2186: -- add join conditions to where clause

Line 2203: RAISE fnd_api.g_exc_error;

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;
2205:
2206: -- add equal sign
2207: g_rule_where := g_rule_where || ' = ' || l_left_part_conv_fct;

Line 2222: RAISE fnd_api.g_exc_error;

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;
2224:
2225: g_rule_where := g_rule_where || l_right_part_conv_fct || g_line_feed;
2226: END LOOP;

Line 2267: RAISE fnd_api.g_exc_error;

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;
2269:
2270: CLOSE qtyfnct;
2271: --

Line 2286: RAISE fnd_api.g_exc_error;

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;
2288:
2289: --
2290:

Line 2334: RAISE fnd_api.g_exc_error;

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
2336: END IF; -- type code in 1,2
2337:
2338: --

Line 2423: RAISE fnd_api.g_exc_error;

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;
2425:
2426: --
2427: log_statement(l_api_name, 'right_part', 'add right part of res');

Line 2516: RAISE fnd_api.g_exc_error;

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;
2518: ELSIF l_operand_type_code = 5 THEN -- right side = expression
2519: --changed by jcearley on 12/8/99 - automatically put expression
2520: -- in parentheses - prevents syntax error during rule generation

Line 2563: RAISE fnd_api.g_exc_error;

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;
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

Line 2574: RAISE fnd_api.g_exc_error;

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;
2576: END LOOP;
2577:
2578: CLOSE RESTRICT;

Line 2694: RAISE fnd_api.g_exc_error;

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;
2696: END LOOP;
2697:
2698: CLOSE sortcrit;

Line 2747: RAISE fnd_api.g_exc_error;

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:
2751: --add consist_string to the select clause

Line 2885: WHEN fnd_api.g_exc_error THEN

2881: --
2882: log_procedure(l_api_name, 'end', 'End BuildRuleSql');
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);

Line 2886: x_return_status := fnd_api.g_ret_sts_error;

2882: log_procedure(l_api_name, 'end', 'End BuildRuleSql');
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: --

Line 2891: WHEN fnd_api.g_exc_unexpected_error THEN

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
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);

Line 2892: x_return_status := fnd_api.g_ret_sts_unexp_error;

2888: --
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:

Line 2918: x_return_status := fnd_api.g_ret_sts_unexp_error;

2914: IF sortcrit%ISOPEN THEN
2915: CLOSE sortcrit;
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;

Line 2948: x_return_status := fnd_api.g_ret_sts_success;

2944: l_api_name VARCHAR2(30) := 'BuildIputSQL';
2945: l_is_mat_status_used NUMBER := NVL(FND_PROFILE.VALUE('INV_MATERIAL_STATUS'), 2);
2946: BEGIN
2947: -- Initialize API return status to success
2948: x_return_status := fnd_api.g_ret_sts_success;
2949:
2950: log_procedure(l_api_name, 'start', 'Start BuildInputSql');
2951: -- end of debugging section
2952: --

Line 3159: x_return_status := fnd_api.g_ret_sts_unexp_error;

3155: log_procedure(l_api_name, 'end', 'End BuildInputSql');
3156: --
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;

Line 3252: x_return_status := fnd_api.g_ret_sts_success;

3248: l_debug NUMBER;
3249:
3250: BEGIN
3251: -- Initialize API return status to success
3252: x_return_status := fnd_api.g_ret_sts_success;
3253: --get package name based on rule id
3254: getpackagename(p_rule_id, l_package_name);
3255: --- calling the static fetch cursor. The name of the rule package will be
3256: --- determined based on the rule_id

Line 3374: x_return_status := fnd_api.g_ret_sts_unexp_error;

3370: END IF;
3371: --
3372: EXCEPTION
3373: WHEN INVALID_PKG_STATE THEN
3374: x_return_status := fnd_api.g_ret_sts_unexp_error;
3375:
3376: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');
3377: fnd_message.set_token('LIST_PKG', l_list_pkg);
3378: fnd_message.set_token('RULE_NAME', l_package_name);

Line 3384: RAISE fnd_api.g_exc_unexpected_error;

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;
3384: RAISE fnd_api.g_exc_unexpected_error;
3385:
3386: WHEN OTHERS THEN
3387: x_return_status := fnd_api.g_ret_sts_unexp_error;
3388:

Line 3387: x_return_status := fnd_api.g_ret_sts_unexp_error;

3383: END IF;
3384: RAISE fnd_api.g_exc_unexpected_error;
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;

Line 3397: RAISE fnd_api.g_exc_unexpected_error;

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;
3398: END fetchcursor;
3399:
3400: --
3401: -- Name : FetchPutAway

Line 3437: x_return_status := fnd_api.g_ret_sts_success;

3433:
3434:
3435: BEGIN
3436: -- Initialize API return status to success
3437: x_return_status := fnd_api.g_ret_sts_success;
3438:
3439: IF NOT(inv_cache.is_pickrelease AND g_debug IS NOT NULL) THEN
3440: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3441: END IF;

Line 3536: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

Line 3546: RAISE fnd_api.g_exc_unexpected_error;

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);
3545: END IF;
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

Line 3548: x_return_status := fnd_api.g_ret_sts_unexp_error;

3544: || l_list_pkg || ' / ' || l_package_name);
3545: END IF;
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;

Line 3558: RAISE fnd_api.g_exc_unexpected_error;

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;
3559: END fetchputaway;
3560:
3561: ------------
3562: ---

Line 3881: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

Line 3931: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

Line 3984: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

Line 4033: RAISE fnd_api.g_exc_unexpected_error;

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;
4035:
4036: -- Procedure to close Putaway rule Cursor ---
4037: --

Line 4070: RAISE fnd_api.g_exc_unexpected_error;

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;
4072:
4073: --------------
4074: --

Line 4123: l_return_status := fnd_api.g_ret_sts_success;

4119: If l_debug = 1 THEN
4120: log_procedure(l_api_name, 'start', 'Start rollback_capacity_update');
4121: END IF;
4122:
4123: l_return_status := fnd_api.g_ret_sts_success;
4124: l_no_error := TRUE;
4125:
4126: FOR l_line IN l_output_lines LOOP
4127: -- We don't track capacity at Subinventory level, so no need

Line 4152: AND l_return_status <> fnd_api.g_ret_sts_success THEN

4148: );
4149:
4150: --return only the first error message
4151: IF l_no_error
4152: AND l_return_status <> fnd_api.g_ret_sts_success THEN
4153: x_return_status := l_return_status;
4154: x_msg_count := l_msg_count;
4155: x_msg_data := l_msg_data;
4156: l_no_error := FALSE;

Line 4170: x_return_status := fnd_api.g_ret_sts_unexp_error;

4166: END IF;
4167:
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;

Line 4306: x_return_status := fnd_api.g_ret_sts_success;

4302: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4303: END IF;
4304: l_debug := g_debug;
4305:
4306: x_return_status := fnd_api.g_ret_sts_success;
4307: l_allocation_quantity := p_needed_quantity;
4308: l_sallocation_quantity := p_needed_sec_quantity;
4309: l_to_locator_id := p_to_locator_id;
4310: /*

Line 4405: , p_init_msg_lst => fnd_api.g_false -- p_init_msg_lst

4401:
4402: inv_quantity_tree_pvt.query_tree
4403: (
4404: p_api_version_number => g_qty_tree_api_version
4405: , p_init_msg_lst => fnd_api.g_false -- p_init_msg_lst
4406: , x_return_status => x_return_status
4407: , x_msg_count => x_msg_count
4408: , x_msg_data => x_msg_data
4409: , p_tree_id => p_tree_id

Line 4430: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

4426: , p_transfer_subinventory_code => chk_for_passing_xfer_sub ( TO_NUMBER(p_transaction_temp_id) , p_to_subinventory_code) -- Bug # 4099907
4427: , p_cost_group_id => g_locs(p_record_id).cost_group_id
4428: , p_lpn_id => g_locs(p_record_id).lpn_id
4429: );
4430: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4431: IF l_debug = 1 THEN
4432: log_statement(l_api_name, 'uerr_qty_tree', 'Unexpected error in inv_quantity_tree_Pvt.query_tree');
4433: END IF;
4434: RAISE fnd_api.g_exc_unexpected_error;

Line 4434: RAISE fnd_api.g_exc_unexpected_error;

4430: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4431: IF l_debug = 1 THEN
4432: log_statement(l_api_name, 'uerr_qty_tree', 'Unexpected error in inv_quantity_tree_Pvt.query_tree');
4433: END IF;
4434: RAISE fnd_api.g_exc_unexpected_error;
4435: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
4436: IF l_debug = 1 THEN
4437: log_statement(l_api_name, 'err_qty_tree', 'Error in inv_quantity_tree_Pvt.query_tree');
4438: END IF;

Line 4435: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

4431: IF l_debug = 1 THEN
4432: log_statement(l_api_name, 'uerr_qty_tree', 'Unexpected error in inv_quantity_tree_Pvt.query_tree');
4433: END IF;
4434: RAISE fnd_api.g_exc_unexpected_error;
4435: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
4436: IF l_debug = 1 THEN
4437: log_statement(l_api_name, 'err_qty_tree', 'Error in inv_quantity_tree_Pvt.query_tree');
4438: END IF;
4439: RAISE fnd_api.g_exc_error;

Line 4439: RAISE fnd_api.g_exc_error;

4435: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
4436: IF l_debug = 1 THEN
4437: log_statement(l_api_name, 'err_qty_tree', 'Error in inv_quantity_tree_Pvt.query_tree');
4438: END IF;
4439: RAISE fnd_api.g_exc_error;
4440: END IF;
4441:
4442: IF l_debug = 1 THEN
4443: log_statement(l_api_name, 'att_qty', 'Available quantity = ' || l_att);

Line 4529: And g_locs(p_record_id).serial_number <> FND_API.G_MISS_CHAR)

4525: END IF;
4526:
4527: --check to see if serial number has already been used
4528: IF (g_locs(p_record_id).serial_number IS NOT NULL
4529: And g_locs(p_record_id).serial_number <> FND_API.G_MISS_CHAR)
4530: THEN
4531: IF l_debug = 1 THEN
4532: log_statement(l_api_name, 'search_sn', 'Calling Search Serial Numbers');
4533: END IF;

Line 4545: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

4541: , x_msg_count => x_msg_count
4542: , x_msg_data => x_msg_data
4543: );
4544:
4545: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4546: IF l_debug = 1 THEN
4547: log_statement(l_api_name, 'uerr_search_sn', 'Unexpected error in search_serial_numbers');
4548: END IF;
4549: RAISE fnd_api.g_exc_unexpected_error;

Line 4549: RAISE fnd_api.g_exc_unexpected_error;

4545: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4546: IF l_debug = 1 THEN
4547: log_statement(l_api_name, 'uerr_search_sn', 'Unexpected error in search_serial_numbers');
4548: END IF;
4549: RAISE fnd_api.g_exc_unexpected_error;
4550: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
4551: IF l_debug = 1 THEN
4552: log_statement(l_api_name, 'err_search_sn', 'Error in search_serial_numbers');
4553: END IF;

Line 4550: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

4546: IF l_debug = 1 THEN
4547: log_statement(l_api_name, 'uerr_search_sn', 'Unexpected error in search_serial_numbers');
4548: END IF;
4549: RAISE fnd_api.g_exc_unexpected_error;
4550: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
4551: IF l_debug = 1 THEN
4552: log_statement(l_api_name, 'err_search_sn', 'Error in search_serial_numbers');
4553: END IF;
4554: RAISE fnd_api.g_exc_error;

Line 4554: RAISE fnd_api.g_exc_error;

4550: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
4551: IF l_debug = 1 THEN
4552: log_statement(l_api_name, 'err_search_sn', 'Error in search_serial_numbers');
4553: END IF;
4554: RAISE fnd_api.g_exc_error;
4555: END IF;
4556:
4557: IF l_found THEN
4558: IF p_debug_on THEN

Line 4650: And g_locs(p_record_id).serial_number <> FND_API.G_MISS_CHAR)

4646:
4647: --Lock Serial number, so that no other detailing process
4648: -- can use it.
4649: IF (g_locs(p_record_id).serial_number IS NOT NULL
4650: And g_locs(p_record_id).serial_number <> FND_API.G_MISS_CHAR)
4651: THEN
4652: l_found := inv_detail_util_pvt.lock_serial_number(p_inventory_item_id, g_locs(p_record_id).serial_number);
4653:
4654: IF l_found = FALSE THEN

Line 4683: , p_init_msg_lst => fnd_api.g_false

4679:
4680: inv_quantity_tree_pvt.update_quantities
4681: (
4682: p_api_version_number => g_qty_tree_api_version
4683: , p_init_msg_lst => fnd_api.g_false
4684: , x_return_status => x_return_status
4685: , x_msg_count => x_msg_count
4686: , x_msg_data => x_msg_data
4687: , p_tree_id => p_tree_id

Line 4712: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

4708: , p_cost_group_id => g_locs(p_record_id).cost_group_id
4709: , p_lpn_id => g_locs(p_record_id).lpn_id
4710: );
4711:
4712: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4713: IF l_debug = 1 THEN
4714: log_statement(l_api_name, 'uerr_update_qty', 'Unexpected error in inv_quantity_tree_pvt.update_quantities');
4715: END IF;
4716:

Line 4717: RAISE fnd_api.g_exc_unexpected_error;

4713: IF l_debug = 1 THEN
4714: log_statement(l_api_name, 'uerr_update_qty', 'Unexpected error in inv_quantity_tree_pvt.update_quantities');
4715: END IF;
4716:
4717: RAISE fnd_api.g_exc_unexpected_error;
4718: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
4719: IF l_debug = 1 THEN
4720: log_statement(l_api_name, 'err_update_qty', 'Error in inv_quantity_tree_pvt.update_quantities');
4721: END IF;

Line 4718: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

4714: log_statement(l_api_name, 'uerr_update_qty', 'Unexpected error in inv_quantity_tree_pvt.update_quantities');
4715: END IF;
4716:
4717: RAISE fnd_api.g_exc_unexpected_error;
4718: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
4719: IF l_debug = 1 THEN
4720: log_statement(l_api_name, 'err_update_qty', 'Error in inv_quantity_tree_pvt.update_quantities');
4721: END IF;
4722: RAISE fnd_api.g_exc_error;

Line 4722: RAISE fnd_api.g_exc_error;

4718: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
4719: IF l_debug = 1 THEN
4720: log_statement(l_api_name, 'err_update_qty', 'Error in inv_quantity_tree_pvt.update_quantities');
4721: END IF;
4722: RAISE fnd_api.g_exc_error;
4723: END IF;
4724:
4725: --If quantity remaining to allocate is greater than 0, update the
4726: --quantity tree and insert the record into WTT

Line 4808: WHEN fnd_api.g_exc_error THEN

4804: log_procedure(l_api_name, 'end', 'End Validate_and_Insert');
4805: 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

Line 4809: x_return_status := fnd_api.g_ret_sts_error;

4805: 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);

Line 4816: WHEN fnd_api.g_exc_unexpected_error THEN

4812: IF l_debug = 1 THEN
4813: log_error(l_api_name, 'error', 'Error - ' || x_msg_data);
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);

Line 4817: x_return_status := fnd_api.g_ret_sts_unexp_error;

4813: log_error(l_api_name, 'error', 'Error - ' || x_msg_data);
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;

Line 4824: x_return_status := fnd_api.g_ret_sts_unexp_error;

4820: log_error(l_api_name, 'unexp_error', 'Unexpected error - ' || x_msg_data);
4821: END IF;
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;

Line 5083: x_return_status := fnd_api.g_ret_sts_success;

5079: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5080: END IF;
5081: l_debug := g_debug;
5082:
5083: x_return_status := fnd_api.g_ret_sts_success;
5084: l_allocation_quantity := p_needed_quantity;
5085:
5086: IF l_debug = 1 THEN
5087: log_procedure(l_api_name, 'start', 'Start Validate_N_Insert');

Line 5112: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

5108: , x_msg_count => x_msg_count
5109: , x_msg_data => x_msg_data );
5110:
5111:
5112: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
5113: IF l_debug = 1 THEN
5114: log_statement(l_api_name, 'uerr_qty_tree', 'Unexpected error in inv_quantity_tree_Pvt.query_tree');
5115: END IF;
5116: RAISE fnd_api.g_exc_unexpected_error;

Line 5116: RAISE fnd_api.g_exc_unexpected_error;

5112: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
5113: IF l_debug = 1 THEN
5114: log_statement(l_api_name, 'uerr_qty_tree', 'Unexpected error in inv_quantity_tree_Pvt.query_tree');
5115: END IF;
5116: RAISE fnd_api.g_exc_unexpected_error;
5117: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
5118: IF l_debug = 1 THEN
5119: log_statement(l_api_name, 'err_qty_tree', 'Error in inv_quantity_tree_Pvt.query_tree');
5120: END IF;

Line 5117: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

5113: IF l_debug = 1 THEN
5114: log_statement(l_api_name, 'uerr_qty_tree', 'Unexpected error in inv_quantity_tree_Pvt.query_tree');
5115: END IF;
5116: RAISE fnd_api.g_exc_unexpected_error;
5117: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
5118: IF l_debug = 1 THEN
5119: log_statement(l_api_name, 'err_qty_tree', 'Error in inv_quantity_tree_Pvt.query_tree');
5120: END IF;
5121: RAISE fnd_api.g_exc_error;

Line 5121: RAISE fnd_api.g_exc_error;

5117: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
5118: IF l_debug = 1 THEN
5119: log_statement(l_api_name, 'err_qty_tree', 'Error in inv_quantity_tree_Pvt.query_tree');
5120: END IF;
5121: RAISE fnd_api.g_exc_error;
5122: END IF;
5123:
5124: IF l_debug = 1 THEN
5125: log_statement(l_api_name, 'att_qty', 'Available quantity = ' || l_att);

Line 5179: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

5175: , x_msg_count => x_msg_count
5176: , x_msg_data => x_msg_data
5177: );
5178:
5179: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
5180: IF l_debug = 1 THEN
5181: log_statement(l_api_name, 'uerr_search_sn', 'Unexpected error in search_serial_numbers');
5182: END IF;
5183: RAISE fnd_api.g_exc_unexpected_error;

Line 5183: RAISE fnd_api.g_exc_unexpected_error;

5179: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
5180: IF l_debug = 1 THEN
5181: log_statement(l_api_name, 'uerr_search_sn', 'Unexpected error in search_serial_numbers');
5182: END IF;
5183: RAISE fnd_api.g_exc_unexpected_error;
5184: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
5185: IF l_debug = 1 THEN
5186: log_statement(l_api_name, 'err_search_sn', 'Error in search_serial_numbers');
5187: END IF;

Line 5184: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

5180: IF l_debug = 1 THEN
5181: log_statement(l_api_name, 'uerr_search_sn', 'Unexpected error in search_serial_numbers');
5182: END IF;
5183: RAISE fnd_api.g_exc_unexpected_error;
5184: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
5185: IF l_debug = 1 THEN
5186: log_statement(l_api_name, 'err_search_sn', 'Error in search_serial_numbers');
5187: END IF;
5188: RAISE fnd_api.g_exc_error;

Line 5188: RAISE fnd_api.g_exc_error;

5184: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
5185: IF l_debug = 1 THEN
5186: log_statement(l_api_name, 'err_search_sn', 'Error in search_serial_numbers');
5187: END IF;
5188: RAISE fnd_api.g_exc_error;
5189: END IF;
5190:
5191: IF l_found THEN
5192: IF p_debug_on THEN

Line 5374: WHEN fnd_api.g_exc_error THEN

5370: log_procedure(l_api_name, 'end', 'End Validate_and_Insert');
5371: END IF;
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

Line 5375: x_return_status := fnd_api.g_ret_sts_error;

5371: END IF;
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);

Line 5382: WHEN fnd_api.g_exc_unexpected_error THEN

5378: IF l_debug = 1 THEN
5379: log_error(l_api_name, 'error', 'Error - ' || x_msg_data);
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);

Line 5383: x_return_status := fnd_api.g_ret_sts_unexp_error;

5379: log_error(l_api_name, 'error', 'Error - ' || x_msg_data);
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;

Line 5390: x_return_status := fnd_api.g_ret_sts_unexp_error;

5386: log_error(l_api_name, 'unexp_error', 'Unexpected error - ' || x_msg_data);
5387: END IF;
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;

Line 5438: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

5434: log_statement(l_api_name, 'restore_tree', 'Calling restore_tree');
5435: END IF;
5436: inv_quantity_tree_pvt.restore_tree(x_return_status => x_return_status, p_tree_id => p_tree_id);
5437:
5438: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
5439: IF l_debug = 1 THEN
5440: log_error(l_api_name, 'uerr_restore_tree', 'Unexpected error in restore_tree');
5441: END IF;
5442: RAISE fnd_api.g_exc_unexpected_error;

Line 5442: RAISE fnd_api.g_exc_unexpected_error;

5438: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
5439: IF l_debug = 1 THEN
5440: log_error(l_api_name, 'uerr_restore_tree', 'Unexpected error in restore_tree');
5441: END IF;
5442: RAISE fnd_api.g_exc_unexpected_error;
5443: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
5444: IF l_debug = 1 THEN
5445: log_error(l_api_name, 'err_restore_tree', 'Error in restore_tree');
5446: END IF;

Line 5443: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

5439: IF l_debug = 1 THEN
5440: log_error(l_api_name, 'uerr_restore_tree', 'Unexpected error in restore_tree');
5441: END IF;
5442: RAISE fnd_api.g_exc_unexpected_error;
5443: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
5444: IF l_debug = 1 THEN
5445: log_error(l_api_name, 'err_restore_tree', 'Error in restore_tree');
5446: END IF;
5447: RAISE fnd_api.g_exc_error;

Line 5447: RAISE fnd_api.g_exc_error;

5443: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
5444: IF l_debug = 1 THEN
5445: log_error(l_api_name, 'err_restore_tree', 'Error in restore_tree');
5446: END IF;
5447: RAISE fnd_api.g_exc_error;
5448: END IF;
5449:
5450: --put pick UOM records back into the list;
5451: --we need to put this records between after the last

Line 5516: WHEN fnd_api.g_exc_error THEN

5512: log_statement(l_api_name, 'finish_delete_sugs', 'Finished deleting suggestions and restored quantity tree');
5513: log_procedure(l_api_name, 'End', 'End Rollback_Consist_Allocations');
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);

Line 5517: x_return_status := fnd_api.g_ret_sts_error;

5513: log_procedure(l_api_name, 'End', 'End Rollback_Consist_Allocations');
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;

Line 5523: WHEN fnd_api.g_exc_unexpected_error THEN

5519: IF l_debug = 1 THEN
5520: log_error(l_api_name, 'error', 'Error - ' || x_msg_data);
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);

Line 5524: x_return_status := fnd_api.g_ret_sts_unexp_error;

5520: log_error(l_api_name, 'error', 'Error - ' || x_msg_data);
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;

Line 5531: x_return_status := fnd_api.g_ret_sts_unexp_error;

5527: log_error(l_api_name, 'unexp_error', 'Unexpected error - ' || x_msg_data);
5528: END IF;
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;

Line 5666: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

5662: , x_sec_allocated_quantity => l_sec_allocated_quantity
5663: , x_sec_remaining_quantity => l_sec_remaining_quantity
5664: );
5665:
5666: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
5667: IF l_debug = 1 THEN
5668: log_statement(l_api_name, 'uerr_validate_insert', 'Unexpected error in validate_and_insert');
5669: END IF;
5670: RAISE fnd_api.g_exc_unexpected_error;

Line 5670: RAISE fnd_api.g_exc_unexpected_error;

5666: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
5667: IF l_debug = 1 THEN
5668: log_statement(l_api_name, 'uerr_validate_insert', 'Unexpected error in validate_and_insert');
5669: END IF;
5670: RAISE fnd_api.g_exc_unexpected_error;
5671: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
5672: IF l_debug = 1 THEN
5673: log_statement(l_api_name, 'err_validate_insert', 'Error in validate_and_insert');
5674: END IF;

Line 5671: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

5667: IF l_debug = 1 THEN
5668: log_statement(l_api_name, 'uerr_validate_insert', 'Unexpected error in validate_and_insert');
5669: END IF;
5670: RAISE fnd_api.g_exc_unexpected_error;
5671: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
5672: IF l_debug = 1 THEN
5673: log_statement(l_api_name, 'err_validate_insert', 'Error in validate_and_insert');
5674: END IF;
5675: RAISE fnd_api.g_exc_error;

Line 5675: RAISE fnd_api.g_exc_error;

5671: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
5672: IF l_debug = 1 THEN
5673: log_statement(l_api_name, 'err_validate_insert', 'Error in validate_and_insert');
5674: END IF;
5675: RAISE fnd_api.g_exc_error;
5676: END IF;
5677:
5678: --If function did not insert full quantity, decrease group qty
5679: IF l_expected_quantity > l_allocated_quantity THEN

Line 5715: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

5711: , p_next_rec => l_loc_id
5712: , p_debug_on => p_debug_on
5713: );
5714:
5715: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
5716: IF l_debug = 1 THEN
5717: log_error(l_api_name, 'uerr_rollback_consist', 'Unexpected error in rollback_consist_allocations');
5718: END IF;
5719: RAISE fnd_api.g_exc_unexpected_error;

Line 5719: RAISE fnd_api.g_exc_unexpected_error;

5715: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
5716: IF l_debug = 1 THEN
5717: log_error(l_api_name, 'uerr_rollback_consist', 'Unexpected error in rollback_consist_allocations');
5718: END IF;
5719: RAISE fnd_api.g_exc_unexpected_error;
5720: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
5721: IF l_debug = 1 THEN
5722: log_error(l_api_name, 'err_rollback_consist', 'Error in rollback_consist_allocations');
5723: END IF;

Line 5720: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

5716: IF l_debug = 1 THEN
5717: log_error(l_api_name, 'uerr_rollback_consist', 'Unexpected error in rollback_consist_allocations');
5718: END IF;
5719: RAISE fnd_api.g_exc_unexpected_error;
5720: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
5721: IF l_debug = 1 THEN
5722: log_error(l_api_name, 'err_rollback_consist', 'Error in rollback_consist_allocations');
5723: END IF;
5724: RAISE fnd_api.g_exc_error;

Line 5724: RAISE fnd_api.g_exc_error;

5720: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
5721: IF l_debug = 1 THEN
5722: log_error(l_api_name, 'err_rollback_consist', 'Error in rollback_consist_allocations');
5723: END IF;
5724: RAISE fnd_api.g_exc_error;
5725: END IF;
5726: IF l_debug = 1 THEN
5727: log_statement(l_api_name, 'after_rollback_consist', 'Rolled back the allocations. Exiting');
5728: END IF;

Line 5806: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

5802: , x_sec_allocated_quantity => l_sec_allocated_quantity
5803: , x_sec_remaining_quantity => l_sec_remaining_quantity
5804: );
5805:
5806: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
5807: IF l_debug = 1 THEN
5808: log_statement(l_api_name, 'uerr_validate_insert', 'Unexpected error in validate_and_insert');
5809: END IF;
5810: RAISE fnd_api.g_exc_unexpected_error;

Line 5810: RAISE fnd_api.g_exc_unexpected_error;

5806: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
5807: IF l_debug = 1 THEN
5808: log_statement(l_api_name, 'uerr_validate_insert', 'Unexpected error in validate_and_insert');
5809: END IF;
5810: RAISE fnd_api.g_exc_unexpected_error;
5811: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
5812: IF l_debug = 1 THEN
5813: log_statement(l_api_name, 'err_validate_insert', 'Error in validate_and_insert');
5814: END IF;

Line 5811: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

5807: IF l_debug = 1 THEN
5808: log_statement(l_api_name, 'uerr_validate_insert', 'Unexpected error in validate_and_insert');
5809: END IF;
5810: RAISE fnd_api.g_exc_unexpected_error;
5811: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
5812: IF l_debug = 1 THEN
5813: log_statement(l_api_name, 'err_validate_insert', 'Error in validate_and_insert');
5814: END IF;
5815: RAISE fnd_api.g_exc_error;

Line 5815: RAISE fnd_api.g_exc_error;

5811: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
5812: IF l_debug = 1 THEN
5813: log_statement(l_api_name, 'err_validate_insert', 'Error in validate_and_insert');
5814: END IF;
5815: RAISE fnd_api.g_exc_error;
5816: END IF;
5817: END IF; -- End of If 5258131
5818: --If function did not insert full quantity, decrease group qty
5819: IF l_expected_quantity > l_allocated_quantity THEN

Line 5851: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

5847: , p_next_rec => NULL
5848: , p_debug_on => p_debug_on
5849: );
5850:
5851: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
5852: IF l_debug = 1 THEN
5853: log_error(l_api_name, 'uerr_rollback_consist', 'Unexpected error in rollback_consist_allocations');
5854: END IF;
5855: RAISE fnd_api.g_exc_unexpected_error;

Line 5855: RAISE fnd_api.g_exc_unexpected_error;

5851: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
5852: IF l_debug = 1 THEN
5853: log_error(l_api_name, 'uerr_rollback_consist', 'Unexpected error in rollback_consist_allocations');
5854: END IF;
5855: RAISE fnd_api.g_exc_unexpected_error;
5856: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
5857: IF l_debug = 1 THEN
5858: log_error(l_api_name, 'err_rollback_consist', 'Error in rollback_consist_allocations');
5859: END IF;

Line 5856: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

5852: IF l_debug = 1 THEN
5853: log_error(l_api_name, 'uerr_rollback_consist', 'Unexpected error in rollback_consist_allocations');
5854: END IF;
5855: RAISE fnd_api.g_exc_unexpected_error;
5856: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
5857: IF l_debug = 1 THEN
5858: log_error(l_api_name, 'err_rollback_consist', 'Error in rollback_consist_allocations');
5859: END IF;
5860: RAISE fnd_api.g_exc_error;

Line 5860: RAISE fnd_api.g_exc_error;

5856: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
5857: IF l_debug = 1 THEN
5858: log_error(l_api_name, 'err_rollback_consist', 'Error in rollback_consist_allocations');
5859: END IF;
5860: RAISE fnd_api.g_exc_error;
5861: END IF;
5862: IF l_debug = 1 THEN
5863: log_statement(l_api_name, 'after_rollback_consist', 'Rolled back the allocations. Exiting');
5864: END IF;

Line 6002: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

5998: , p_next_rec => 0
5999: , p_debug_on => p_debug_on
6000: );
6001:
6002: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
6003: IF l_debug = 1 THEN
6004: log_error(l_api_name, 'uerr_rollback_consist', 'Unexpected error in rollback_consist_allocations');
6005: END IF;
6006: RAISE fnd_api.g_exc_unexpected_error;

Line 6006: RAISE fnd_api.g_exc_unexpected_error;

6002: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
6003: IF l_debug = 1 THEN
6004: log_error(l_api_name, 'uerr_rollback_consist', 'Unexpected error in rollback_consist_allocations');
6005: END IF;
6006: RAISE fnd_api.g_exc_unexpected_error;
6007: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
6008: IF l_debug = 1 THEN
6009: log_error(l_api_name, 'err_rollback_consist', 'Error in rollback_consist_allocations');
6010: END IF;

Line 6007: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

6003: IF l_debug = 1 THEN
6004: log_error(l_api_name, 'uerr_rollback_consist', 'Unexpected error in rollback_consist_allocations');
6005: END IF;
6006: RAISE fnd_api.g_exc_unexpected_error;
6007: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
6008: IF l_debug = 1 THEN
6009: log_error(l_api_name, 'err_rollback_consist', 'Error in rollback_consist_allocations');
6010: END IF;
6011: RAISE fnd_api.g_exc_error;

Line 6011: RAISE fnd_api.g_exc_error;

6007: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
6008: IF l_debug = 1 THEN
6009: log_error(l_api_name, 'err_rollback_consist', 'Error in rollback_consist_allocations');
6010: END IF;
6011: RAISE fnd_api.g_exc_error;
6012: END IF;
6013:
6014: x_success := FALSE;
6015: END IF;

Line 6020: WHEN fnd_api.g_exc_error THEN

6016: IF l_debug = 1 THEN
6017: log_procedure(l_api_name, 'end', 'End Allocate_Consist_Group');
6018: END IF;
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

Line 6021: x_return_status := fnd_api.g_ret_sts_error;

6017: log_procedure(l_api_name, 'end', 'End Allocate_Consist_Group');
6018: END IF;
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);

Line 6028: WHEN fnd_api.g_exc_unexpected_error THEN

6024: IF l_debug = 1 THEN
6025: log_error(l_api_name, 'error', 'Error - ' || x_msg_data);
6026: END IF;
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

Line 6029: x_return_status := fnd_api.g_ret_sts_unexp_error;

6025: log_error(l_api_name, 'error', 'Error - ' || x_msg_data);
6026: END IF;
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);

Line 6036: x_return_status := fnd_api.g_ret_sts_unexp_error;

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
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);

Line 6268: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

6264: , p_lot_divisible_flag => inv_cache.item_rec.lot_divisible_flag
6265: , x_success => x_finished
6266: );
6267:
6268: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
6269: IF l_debug = 1 THEN
6270: log_error(l_api_name, 'uerr_alloc_consist_group', 'Unexpected error in allocate_consist_group');
6271: END IF;
6272: RAISE fnd_api.g_exc_unexpected_error;

Line 6272: RAISE fnd_api.g_exc_unexpected_error;

6268: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
6269: IF l_debug = 1 THEN
6270: log_error(l_api_name, 'uerr_alloc_consist_group', 'Unexpected error in allocate_consist_group');
6271: END IF;
6272: RAISE fnd_api.g_exc_unexpected_error;
6273: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
6274: IF l_debug = 1 THEN
6275: log_error(l_api_name, 'err_alloc_consist_group', 'Error in allocate_consist_group');
6276: END IF;

Line 6273: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

6269: IF l_debug = 1 THEN
6270: log_error(l_api_name, 'uerr_alloc_consist_group', 'Unexpected error in allocate_consist_group');
6271: END IF;
6272: RAISE fnd_api.g_exc_unexpected_error;
6273: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
6274: IF l_debug = 1 THEN
6275: log_error(l_api_name, 'err_alloc_consist_group', 'Error in allocate_consist_group');
6276: END IF;
6277: RAISE fnd_api.g_exc_error;

Line 6277: RAISE fnd_api.g_exc_error;

6273: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
6274: IF l_debug = 1 THEN
6275: log_error(l_api_name, 'err_alloc_consist_group', 'Error in allocate_consist_group');
6276: END IF;
6277: RAISE fnd_api.g_exc_error;
6278: END IF;
6279: END IF;
6280:
6281: x_return_status := fnd_api.g_ret_sts_success;

Line 6281: x_return_status := fnd_api.g_ret_sts_success;

6277: RAISE fnd_api.g_exc_error;
6278: END IF;
6279: END IF;
6280:
6281: x_return_status := fnd_api.g_ret_sts_success;
6282: IF l_debug = 1 THEN
6283: log_procedure(l_api_name, 'end', 'End Insert_Consist_Record');
6284: END IF;
6285: EXCEPTION

Line 6286: WHEN fnd_api.g_exc_error THEN

6282: IF l_debug = 1 THEN
6283: log_procedure(l_api_name, 'end', 'End Insert_Consist_Record');
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);

Line 6287: x_return_status := fnd_api.g_ret_sts_error;

6283: log_procedure(l_api_name, 'end', 'End Insert_Consist_Record');
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;

Line 6293: WHEN fnd_api.g_exc_unexpected_error THEN

6289: IF l_debug = 1 THEN
6290: log_error(l_api_name, 'error', 'Error - ' || x_msg_data);
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);

Line 6294: x_return_status := fnd_api.g_ret_sts_unexp_error;

6290: log_error(l_api_name, 'error', 'Error - ' || x_msg_data);
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;

Line 6301: x_return_status := fnd_api.g_ret_sts_unexp_error;

6297: log_error(l_api_name, 'unexp_error', 'Unexpected error - ' || x_msg_data);
6298: END IF;
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;

Line 6807: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

6803: -- Standard start of API savepoint
6804: SAVEPOINT applyrulesp;
6805:
6806: -- Standard call to check for call compatibility
6807: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
6808: RAISE fnd_api.g_exc_unexpected_error;
6809: END IF;
6810:
6811: -- Initialize message list if p_init_msg_list is set to TRUE

Line 6808: RAISE fnd_api.g_exc_unexpected_error;

6804: SAVEPOINT applyrulesp;
6805:
6806: -- Standard call to check for call compatibility
6807: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
6808: RAISE fnd_api.g_exc_unexpected_error;
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

Line 6812: IF fnd_api.to_boolean(p_init_msg_list) THEN

6808: RAISE fnd_api.g_exc_unexpected_error;
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

Line 6827: x_return_status := fnd_api.g_ret_sts_success;

6823: -- LPN Status Project
6824:
6825: --
6826: -- Initialize API return status to success
6827: x_return_status := fnd_api.g_ret_sts_success;
6828: --
6829: -- Initialize functional return status to completed
6830: x_finished := fnd_api.g_true;
6831:

Line 6830: x_finished := fnd_api.g_true;

6826: -- Initialize API return status to success
6827: x_return_status := fnd_api.g_ret_sts_success;
6828: --
6829: -- Initialize functional return status to completed
6830: x_finished := fnd_api.g_true;
6831:
6832: --
6833: -- Validate input parameters and pre-requisites, if validation level
6834: -- requires this

Line 6835: IF p_validation_level <> fnd_api.g_valid_level_none THEN

6831:
6832: --
6833: -- Validate input parameters and pre-requisites, if validation level
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');

Line 6837: OR p_type_code = fnd_api.g_miss_num THEN

6833: -- Validate input parameters and pre-requisites, if validation level
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:

Line 6848: RAISE fnd_api.g_exc_error;

6844: END IF;
6845:
6846: END IF;
6847:
6848: RAISE fnd_api.g_exc_error;
6849: END IF;
6850:
6851: /* get the org defaults */
6852: IF l_debug = 1 THEN

Line 6873: OR p_rule_id = fnd_api.g_miss_num THEN

6869:
6870: --changed by jcearley on 11/22/99, b/c a null rule_id is now allowed
6871: -- if rule_id is null, use default rule (0 for put away, 1 for pick)
6872: IF p_rule_id IS NULL
6873: OR p_rule_id = fnd_api.g_miss_num THEN
6874: --query org parameters to get user's default rule
6875: --if default rule not defined, use default seeded rule
6876: IF p_type_code = 1 THEN --put away
6877: l_rule_id := l_default_put_rule;

Line 6904: OR p_partial_success_allowed_flag = fnd_api.g_miss_char THEN

6900: l_rule_id := p_rule_id;
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');

Line 6912: RAISE fnd_api.g_exc_error;

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:
6915: IF p_transaction_temp_id IS NULL
6916: OR p_transaction_temp_id = fnd_api.g_miss_num THEN

Line 6916: OR p_transaction_temp_id = fnd_api.g_miss_num THEN

6912: RAISE fnd_api.g_exc_error;
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

Line 6924: RAISE fnd_api.g_exc_error;

6920: IF l_debug = 1 THEN
6921: log_error_msg(l_api_name, 'trx_req_line_id_missing');
6922: END IF;
6923: END IF;
6924: RAISE fnd_api.g_exc_error;
6925: END IF;
6926:
6927: IF p_organization_id IS NULL
6928: OR p_organization_id = fnd_api.g_miss_num THEN

Line 6928: OR p_organization_id = fnd_api.g_miss_num THEN

6924: RAISE fnd_api.g_exc_error;
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

Line 6937: RAISE fnd_api.g_exc_error;

6933: log_error_msg(l_api_name, 'org_id_missing');
6934: END IF;
6935: END IF;
6936:
6937: RAISE fnd_api.g_exc_error;
6938: END IF;
6939:
6940: IF p_inventory_item_id IS NULL
6941: OR p_inventory_item_id = fnd_api.g_miss_num THEN

Line 6941: OR p_inventory_item_id = fnd_api.g_miss_num THEN

6937: RAISE fnd_api.g_exc_error;
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

Line 6950: RAISE fnd_api.g_exc_error;

6946: log_error_msg(l_api_name, 'item_id_missing');
6947: END IF;
6948: END IF;
6949:
6950: RAISE fnd_api.g_exc_error;
6951: END IF;
6952:
6953: IF p_type_code = 2
6954: AND (p_tree_id IS NULL

Line 6955: OR p_tree_id = fnd_api.g_miss_num

6951: END IF;
6952:
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;

Line 6964: RAISE fnd_api.g_exc_error;

6960: IF l_debug = 1 THEN
6961: log_error_msg(l_api_name, 'qty_tree_id_missing');
6962: END IF;
6963: END IF;
6964: RAISE fnd_api.g_exc_error;
6965: END IF;
6966: END IF;
6967:
6968: --inv_pp_debug.send_message_to_pipe('finished validations and qty tree init');

Line 6978: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

6974: log_statement(l_api_name, 'backup_tree',
6975: 'Calling inv_quantity_tree_pvt.backup_tree');
6976: END IF;
6977: inv_quantity_tree_pvt.backup_tree(x_return_status, p_tree_id);
6978: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
6979: IF l_debug = 1 THEN
6980: log_statement(l_api_name, 'backup_tree_unexp_err',
6981: 'Unexpected error from inv_quantity_tree_pvt.backup_tree');
6982: END IF;

Line 6983: RAISE fnd_api.g_exc_unexpected_error;

6979: IF l_debug = 1 THEN
6980: log_statement(l_api_name, 'backup_tree_unexp_err',
6981: 'Unexpected error from inv_quantity_tree_pvt.backup_tree');
6982: END IF;
6983: RAISE fnd_api.g_exc_unexpected_error;
6984: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
6985: IF l_debug = 1 THEN
6986: log_statement(l_api_name, 'backup_tree_err',
6987: 'Error from inv_quantity_tree_pvt.backup_tree');

Line 6984: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

6980: log_statement(l_api_name, 'backup_tree_unexp_err',
6981: 'Unexpected error from inv_quantity_tree_pvt.backup_tree');
6982: END IF;
6983: RAISE fnd_api.g_exc_unexpected_error;
6984: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
6985: IF l_debug = 1 THEN
6986: log_statement(l_api_name, 'backup_tree_err',
6987: 'Error from inv_quantity_tree_pvt.backup_tree');
6988: END IF;

Line 6989: RAISE fnd_api.g_exc_error;

6985: IF l_debug = 1 THEN
6986: log_statement(l_api_name, 'backup_tree_err',
6987: 'Error from inv_quantity_tree_pvt.backup_tree');
6988: END IF;
6989: RAISE fnd_api.g_exc_error;
6990: END IF;
6991: --does the rule have any consistency restrictions?
6992: OPEN l_consist;
6993: FETCH l_consist INTO l_dummy;

Line 7072: RAISE fnd_api.g_exc_unexpected_error;

7068: If NOT l_return_value Then
7069: If l_debug = 1 then
7070: log_statement(l_api_name, '-', 'Error setting from sub cache');
7071: end if;
7072: RAISE fnd_api.g_exc_unexpected_error;
7073: End If;
7074:
7075: l_serial_control_code := NVL(inv_cache.item_rec.serial_number_control_code,1);
7076: l_restrict_subs_code := NVL(inv_cache.item_rec.restrict_subinventories_code, 2);

Line 7524: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

7520: , x_remaining_quantity => l_remaining_quantity
7521: , x_sec_allocated_quantity => l_sec_allocated_quantity
7522: , x_sec_remaining_quantity => l_sec_remaining_quantity
7523: );
7524: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
7525: IF l_debug = 1 THEN
7526: log_statement(l_api_name, 'uerr_validate_insert', 'Unexpected error in validate_and_insert');
7527: END IF;
7528: RAISE fnd_api.g_exc_unexpected_error;

Line 7528: RAISE fnd_api.g_exc_unexpected_error;

7524: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
7525: IF l_debug = 1 THEN
7526: log_statement(l_api_name, 'uerr_validate_insert', 'Unexpected error in validate_and_insert');
7527: END IF;
7528: RAISE fnd_api.g_exc_unexpected_error;
7529: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
7530: IF l_debug = 1 THEN
7531: log_statement(l_api_name, 'err_validate_insert', 'Error in validate_and_insert');
7532: END IF;

Line 7529: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

7525: IF l_debug = 1 THEN
7526: log_statement(l_api_name, 'uerr_validate_insert', 'Unexpected error in validate_and_insert');
7527: END IF;
7528: RAISE fnd_api.g_exc_unexpected_error;
7529: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
7530: IF l_debug = 1 THEN
7531: log_statement(l_api_name, 'err_validate_insert', 'Error in validate_and_insert');
7532: END IF;
7533: RAISE fnd_api.g_exc_error;

Line 7533: RAISE fnd_api.g_exc_error;

7529: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
7530: IF l_debug = 1 THEN
7531: log_statement(l_api_name, 'err_validate_insert', 'Error in validate_and_insert');
7532: END IF;
7533: RAISE fnd_api.g_exc_error;
7534: END IF;
7535: /* done with this res go to the next */
7536: GOTO nextINputrecord;
7537: END IF;

Line 7632: RAISE fnd_api.g_exc_unexpected_error;

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:
7636: IF (p_type_code = 2) THEN --pick

Line 7706: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

7702: , l_rows
7703: );
7704:
7705: EXIT WHEN nvl(l_rows, 0) = 0 ; -- [ Added to to exit , if the rule is not returning any rows
7706: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
7707: IF l_debug = 1 THEN
7708: log_error(l_api_name, 'uerr_fetch_cursor', 'Unexpected error in FetchCursor');
7709: END IF;
7710: RAISE fnd_api.g_exc_unexpected_error;

Line 7710: RAISE fnd_api.g_exc_unexpected_error;

7706: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
7707: IF l_debug = 1 THEN
7708: log_error(l_api_name, 'uerr_fetch_cursor', 'Unexpected error in FetchCursor');
7709: END IF;
7710: RAISE fnd_api.g_exc_unexpected_error;
7711: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
7712: IF l_debug = 1 THEN
7713: log_error(l_api_name, 'fetch_cursor ', 'Error in FetchCursor');
7714: END IF;

Line 7711: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

7707: IF l_debug = 1 THEN
7708: log_error(l_api_name, 'uerr_fetch_cursor', 'Unexpected error in FetchCursor');
7709: END IF;
7710: RAISE fnd_api.g_exc_unexpected_error;
7711: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
7712: IF l_debug = 1 THEN
7713: log_error(l_api_name, 'fetch_cursor ', 'Error in FetchCursor');
7714: END IF;
7715: RAISE fnd_api.g_exc_error;

Line 7715: RAISE fnd_api.g_exc_error;

7711: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
7712: IF l_debug = 1 THEN
7713: log_error(l_api_name, 'fetch_cursor ', 'Error in FetchCursor');
7714: END IF;
7715: RAISE fnd_api.g_exc_error;
7716: END IF;
7717:
7718: IF l_debug = 1 THEN
7719: log_statement(l_api_name, 'Serial Status - l_detail_serial ', l_detail_serial);

Line 7747: IF ( x_return_status = fnd_api.g_ret_sts_unexp_error ) THEN

7743: , p_demand_source_header_id => NULL --p_demand_source_header_id
7744: , p_demand_source_line_id => NULL --p_demand_source_line_id
7745: , x_serial_numbers => l_custom_select_serials );
7746:
7747: IF ( x_return_status = fnd_api.g_ret_sts_unexp_error ) THEN
7748: IF ( l_debug = 1 ) THEN
7749: log_error(l_api_name, 'uerr_Get_User_Serial_Numbers', 'Unexpected error in Get_User_Serial_Numbers');
7750: END IF;
7751: RAISE fnd_api.g_exc_unexpected_error;

Line 7751: RAISE fnd_api.g_exc_unexpected_error;

7747: IF ( x_return_status = fnd_api.g_ret_sts_unexp_error ) THEN
7748: IF ( l_debug = 1 ) THEN
7749: log_error(l_api_name, 'uerr_Get_User_Serial_Numbers', 'Unexpected error in Get_User_Serial_Numbers');
7750: END IF;
7751: RAISE fnd_api.g_exc_unexpected_error;
7752: ELSIF ( x_return_status = fnd_api.g_ret_sts_error ) THEN
7753: IF ( l_debug = 1 ) THEN
7754: log_error(l_api_name, 'Get_User_Serial_Numbers', 'Error in Get_User_Serial_Numbers');
7755: END IF;

Line 7752: ELSIF ( x_return_status = fnd_api.g_ret_sts_error ) THEN

7748: IF ( l_debug = 1 ) THEN
7749: log_error(l_api_name, 'uerr_Get_User_Serial_Numbers', 'Unexpected error in Get_User_Serial_Numbers');
7750: END IF;
7751: RAISE fnd_api.g_exc_unexpected_error;
7752: ELSIF ( x_return_status = fnd_api.g_ret_sts_error ) THEN
7753: IF ( l_debug = 1 ) THEN
7754: log_error(l_api_name, 'Get_User_Serial_Numbers', 'Error in Get_User_Serial_Numbers');
7755: END IF;
7756: RAISE fnd_api.g_exc_error;

Line 7756: RAISE fnd_api.g_exc_error;

7752: ELSIF ( x_return_status = fnd_api.g_ret_sts_error ) THEN
7753: IF ( l_debug = 1 ) THEN
7754: log_error(l_api_name, 'Get_User_Serial_Numbers', 'Error in Get_User_Serial_Numbers');
7755: END IF;
7756: RAISE fnd_api.g_exc_error;
7757: END IF;
7758:
7759: l_custom_serial_index := l_custom_select_serials.serial_number.FIRST;
7760: v_current_row.serial_number := l_custom_select_serials.serial_number(l_custom_serial_index);

Line 7924: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

7920: , x_sec_allocated_quantity => l_sec_allocated_quantity
7921: , x_sec_remaining_quantity => l_sec_remaining_quantity
7922: );
7923:
7924: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
7925: IF l_debug = 1 THEN
7926: log_statement(l_api_name, 'uerr_validate_insert', 'Unexpected error in validate_and_insert');
7927: END IF;
7928: RAISE fnd_api.g_exc_unexpected_error;

Line 7928: RAISE fnd_api.g_exc_unexpected_error;

7924: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
7925: IF l_debug = 1 THEN
7926: log_statement(l_api_name, 'uerr_validate_insert', 'Unexpected error in validate_and_insert');
7927: END IF;
7928: RAISE fnd_api.g_exc_unexpected_error;
7929: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
7930: IF l_debug = 1 THEN
7931: log_statement(l_api_name, 'err_validate_insert', 'Error in validate_and_insert');
7932: END IF;

Line 7929: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

7925: IF l_debug = 1 THEN
7926: log_statement(l_api_name, 'uerr_validate_insert', 'Unexpected error in validate_and_insert');
7927: END IF;
7928: RAISE fnd_api.g_exc_unexpected_error;
7929: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
7930: IF l_debug = 1 THEN
7931: log_statement(l_api_name, 'err_validate_insert', 'Error in validate_and_insert');
7932: END IF;
7933: RAISE fnd_api.g_exc_error;

Line 7933: RAISE fnd_api.g_exc_error;

7929: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
7930: IF l_debug = 1 THEN
7931: log_statement(l_api_name, 'err_validate_insert', 'Error in validate_and_insert');
7932: END IF;
7933: RAISE fnd_api.g_exc_error;
7934: END IF;
7935: --if returns false
7936: IF l_inserted_record = FALSE
7937: OR l_allocated_quantity < l_expected_quantity THEN

Line 7944: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

7940: -- rollback quantity tree
7941: log_statement(l_api_name, 'restore_tree', 'Calling restore_tree');
7942: END IF;
7943: inv_quantity_tree_pvt.restore_tree(x_return_status => x_return_status, p_tree_id => p_tree_id);
7944: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
7945: IF l_debug = 1 THEN
7946: log_error(l_api_name, 'uerr_restore_tree', 'Unexpected error in restore_tree');
7947: END IF;
7948: RAISE fnd_api.g_exc_unexpected_error;

Line 7948: RAISE fnd_api.g_exc_unexpected_error;

7944: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
7945: IF l_debug = 1 THEN
7946: log_error(l_api_name, 'uerr_restore_tree', 'Unexpected error in restore_tree');
7947: END IF;
7948: RAISE fnd_api.g_exc_unexpected_error;
7949: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
7950: IF l_debug = 1 THEN
7951: log_error(l_api_name, 'err_restore_tree', 'Error in restore_tree');
7952: END IF;

Line 7949: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

7945: IF l_debug = 1 THEN
7946: log_error(l_api_name, 'uerr_restore_tree', 'Unexpected error in restore_tree');
7947: END IF;
7948: RAISE fnd_api.g_exc_unexpected_error;
7949: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
7950: IF l_debug = 1 THEN
7951: log_error(l_api_name, 'err_restore_tree', 'Error in restore_tree');
7952: END IF;
7953: RAISE fnd_api.g_exc_error;

Line 7953: RAISE fnd_api.g_exc_error;

7949: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
7950: IF l_debug = 1 THEN
7951: log_error(l_api_name, 'err_restore_tree', 'Error in restore_tree');
7952: END IF;
7953: RAISE fnd_api.g_exc_error;
7954: END IF;
7955: -- delete allocations
7956: DELETE FROM wms_transactions_temp
7957: WHERE line_type_code = 2

Line 8118: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

8114: , x_sec_allocated_quantity => l_sec_allocated_quantity
8115: , x_sec_remaining_quantity => l_sec_remaining_quantity
8116: );
8117:
8118: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
8119: IF l_debug = 1 THEN
8120: log_statement(l_api_name, 'uerr_validate_insert', 'Unexpected error in validate_and_insert');
8121: END IF;
8122: RAISE fnd_api.g_exc_unexpected_error;

Line 8122: RAISE fnd_api.g_exc_unexpected_error;

8118: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
8119: IF l_debug = 1 THEN
8120: log_statement(l_api_name, 'uerr_validate_insert', 'Unexpected error in validate_and_insert');
8121: END IF;
8122: RAISE fnd_api.g_exc_unexpected_error;
8123: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
8124: IF l_debug = 1 THEN
8125: log_statement(l_api_name, 'err_validate_insert', 'Error in validate_and_insert');
8126: END IF;

Line 8123: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

8119: IF l_debug = 1 THEN
8120: log_statement(l_api_name, 'uerr_validate_insert', 'Unexpected error in validate_and_insert');
8121: END IF;
8122: RAISE fnd_api.g_exc_unexpected_error;
8123: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
8124: IF l_debug = 1 THEN
8125: log_statement(l_api_name, 'err_validate_insert', 'Error in validate_and_insert');
8126: END IF;
8127: RAISE fnd_api.g_exc_error;

Line 8127: RAISE fnd_api.g_exc_error;

8123: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
8124: IF l_debug = 1 THEN
8125: log_statement(l_api_name, 'err_validate_insert', 'Error in validate_and_insert');
8126: END IF;
8127: RAISE fnd_api.g_exc_error;
8128: END IF;
8129:
8130: --if returns false
8131: IF l_inserted_record = FALSE

Line 8141: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

8137: END IF;
8138:
8139: inv_quantity_tree_pvt.restore_tree(x_return_status => x_return_status, p_tree_id => p_tree_id);
8140:
8141: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
8142: IF l_debug = 1 THEN
8143: log_error(l_api_name, 'uerr_restore_tree', 'Unexpected error in restore_tree');
8144: END IF;
8145: RAISE fnd_api.g_exc_unexpected_error;

Line 8145: RAISE fnd_api.g_exc_unexpected_error;

8141: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
8142: IF l_debug = 1 THEN
8143: log_error(l_api_name, 'uerr_restore_tree', 'Unexpected error in restore_tree');
8144: END IF;
8145: RAISE fnd_api.g_exc_unexpected_error;
8146: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
8147: IF l_debug = 1 THEN
8148: log_error(l_api_name, 'err_restore_tree', 'Error in restore_tree');
8149: END IF;

Line 8146: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

8142: IF l_debug = 1 THEN
8143: log_error(l_api_name, 'uerr_restore_tree', 'Unexpected error in restore_tree');
8144: END IF;
8145: RAISE fnd_api.g_exc_unexpected_error;
8146: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
8147: IF l_debug = 1 THEN
8148: log_error(l_api_name, 'err_restore_tree', 'Error in restore_tree');
8149: END IF;
8150: RAISE fnd_api.g_exc_error;

Line 8150: RAISE fnd_api.g_exc_error;

8146: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
8147: IF l_debug = 1 THEN
8148: log_error(l_api_name, 'err_restore_tree', 'Error in restore_tree');
8149: END IF;
8150: RAISE fnd_api.g_exc_error;
8151: END IF;
8152:
8153: -- set lpn quantity to -1
8154: --no need to call invalidate, since we'll never see this

Line 8489: , p_init_msg_lst => fnd_api.g_false -- p_init_msg_lst

8485: -- by removing l_to_subinevntory_code.
8486: inv_quantity_tree_pvt.query_tree
8487: (
8488: p_api_version_number => g_qty_tree_api_version
8489: , p_init_msg_lst => fnd_api.g_false -- p_init_msg_lst
8490: , x_return_status => x_return_status
8491: , x_msg_count => x_msg_count
8492: , x_msg_data => x_msg_data
8493: , p_tree_id => p_tree_id

Line 8515: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

8511: , p_cost_group_id => v_current_row.cost_group_id
8512: , p_lpn_id => v_current_row.lpn_id
8513: );
8514:
8515: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
8516: IF l_debug = 1 THEN
8517: log_statement(l_api_name, 'uerr_qty_tree', 'Unexpected error in inv_quantity_tree_Pvt.query_tree');
8518: END IF;
8519: RAISE fnd_api.g_exc_unexpected_error;

Line 8519: RAISE fnd_api.g_exc_unexpected_error;

8515: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
8516: IF l_debug = 1 THEN
8517: log_statement(l_api_name, 'uerr_qty_tree', 'Unexpected error in inv_quantity_tree_Pvt.query_tree');
8518: END IF;
8519: RAISE fnd_api.g_exc_unexpected_error;
8520: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
8521: IF l_debug = 1 THEN
8522: log_statement(l_api_name, 'err_qty_tree', 'Error in inv_quantity_tree_Pvt.query_tree');
8523: END if;

Line 8520: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

8516: IF l_debug = 1 THEN
8517: log_statement(l_api_name, 'uerr_qty_tree', 'Unexpected error in inv_quantity_tree_Pvt.query_tree');
8518: END IF;
8519: RAISE fnd_api.g_exc_unexpected_error;
8520: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
8521: IF l_debug = 1 THEN
8522: log_statement(l_api_name, 'err_qty_tree', 'Error in inv_quantity_tree_Pvt.query_tree');
8523: END if;
8524: RAISE fnd_api.g_exc_error;

Line 8524: RAISE fnd_api.g_exc_error;

8520: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
8521: IF l_debug = 1 THEN
8522: log_statement(l_api_name, 'err_qty_tree', 'Error in inv_quantity_tree_Pvt.query_tree');
8523: END if;
8524: RAISE fnd_api.g_exc_error;
8525: END IF;
8526:
8527: IF l_debug = 1 THEN
8528: log_statement(l_api_name, 'att_qty', 'Available quantity = ' || l_att);

Line 8729: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

8725: , x_sec_allocated_quantity => l_sec_allocated_quantity
8726: , x_sec_remaining_quantity => l_sec_remaining_quantity
8727: );
8728:
8729: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
8730:
8731: IF l_debug = 1 THEN
8732: log_statement(l_api_name, 'uerr_validate_insert', 'Unexpected error in validate_and_insert');
8733: END IF;

Line 8735: RAISE fnd_api.g_exc_unexpected_error;

8731: IF l_debug = 1 THEN
8732: log_statement(l_api_name, 'uerr_validate_insert', 'Unexpected error in validate_and_insert');
8733: END IF;
8734:
8735: RAISE fnd_api.g_exc_unexpected_error;
8736: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
8737:
8738: IF l_debug = 1 THEN
8739: log_statement(l_api_name, 'err_validate_insert', 'Error in validate_and_insert');

Line 8736: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

8732: log_statement(l_api_name, 'uerr_validate_insert', 'Unexpected error in validate_and_insert');
8733: END IF;
8734:
8735: RAISE fnd_api.g_exc_unexpected_error;
8736: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
8737:
8738: IF l_debug = 1 THEN
8739: log_statement(l_api_name, 'err_validate_insert', 'Error in validate_and_insert');
8740: END IF;

Line 8742: RAISE fnd_api.g_exc_error;

8738: IF l_debug = 1 THEN
8739: log_statement(l_api_name, 'err_validate_insert', 'Error in validate_and_insert');
8740: END IF;
8741:
8742: RAISE fnd_api.g_exc_error;
8743: END IF;
8744:
8745: --If this fails
8746: IF l_inserted_record = FALSE

Line 8784: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

8780: END IF;
8781:
8782: inv_quantity_tree_pvt.restore_tree(x_return_status => x_return_status, p_tree_id => p_tree_id);
8783:
8784: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
8785:
8786: IF l_debug = 1 THEN
8787: log_error(l_api_name, 'uerr_restore_tree', 'Unexpected error in restore_tree');
8788: END IF;

Line 8790: RAISE fnd_api.g_exc_unexpected_error;

8786: IF l_debug = 1 THEN
8787: log_error(l_api_name, 'uerr_restore_tree', 'Unexpected error in restore_tree');
8788: END IF;
8789:
8790: RAISE fnd_api.g_exc_unexpected_error;
8791: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
8792:
8793: IF l_debug = 1 THEN
8794: log_error(l_api_name, 'err_restore_tree', 'Error in restore_tree');

Line 8791: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

8787: log_error(l_api_name, 'uerr_restore_tree', 'Unexpected error in restore_tree');
8788: END IF;
8789:
8790: RAISE fnd_api.g_exc_unexpected_error;
8791: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
8792:
8793: IF l_debug = 1 THEN
8794: log_error(l_api_name, 'err_restore_tree', 'Error in restore_tree');
8795: END IF;

Line 8797: RAISE fnd_api.g_exc_error;

8793: IF l_debug = 1 THEN
8794: log_error(l_api_name, 'err_restore_tree', 'Error in restore_tree');
8795: END IF;
8796:
8797: RAISE fnd_api.g_exc_error;
8798: END IF;
8799:
8800: --delete allocations
8801: --is this okay?? what if multiple input lines?

Line 8927: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

8923: , v_current_row.order_by_string
8924: , l_rows
8925: );
8926:
8927: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
8928: IF l_debug = 1 THEN
8929: log_error(l_api_name, 'uerr_fetch_cursor', 'Unexpected error in FetchCursor');
8930: END IF;
8931: RAISE fnd_api.g_exc_unexpected_error;

Line 8931: RAISE fnd_api.g_exc_unexpected_error;

8927: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
8928: IF l_debug = 1 THEN
8929: log_error(l_api_name, 'uerr_fetch_cursor', 'Unexpected error in FetchCursor');
8930: END IF;
8931: RAISE fnd_api.g_exc_unexpected_error;
8932: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
8933: IF l_debug = 1 THEN
8934: log_error(l_api_name, 'err_fetch_cursor', 'Error in FetchCursor');
8935: END IF;

Line 8932: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

8928: IF l_debug = 1 THEN
8929: log_error(l_api_name, 'uerr_fetch_cursor', 'Unexpected error in FetchCursor');
8930: END IF;
8931: RAISE fnd_api.g_exc_unexpected_error;
8932: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
8933: IF l_debug = 1 THEN
8934: log_error(l_api_name, 'err_fetch_cursor', 'Error in FetchCursor');
8935: END IF;
8936: RAISE fnd_api.g_exc_error;

Line 8936: RAISE fnd_api.g_exc_error;

8932: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
8933: IF l_debug = 1 THEN
8934: log_error(l_api_name, 'err_fetch_cursor', 'Error in FetchCursor');
8935: END IF;
8936: RAISE fnd_api.g_exc_error;
8937: END IF;
8938:
8939: -- is_serial_trx_allowed is_sub_loc_lot_trx_allowed
8940: EXIT WHEN nvl(l_rows, 0) = 0 ; -- [ Added to to exit , if the rule is not returning any rows

Line 9110: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

9106: , x_finished => l_finished
9107: , x_remaining_quantity => l_remaining_quantity
9108: );
9109:
9110: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
9111: IF l_debug = 1 THEN
9112: log_statement(l_api_name, 'uerr_insert_consist', 'Unexpected error in insert_consist_record');
9113: END IF;
9114: RAISE fnd_api.g_exc_unexpected_error;

Line 9114: RAISE fnd_api.g_exc_unexpected_error;

9110: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
9111: IF l_debug = 1 THEN
9112: log_statement(l_api_name, 'uerr_insert_consist', 'Unexpected error in insert_consist_record');
9113: END IF;
9114: RAISE fnd_api.g_exc_unexpected_error;
9115: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
9116: IF l_debug = 1 THEN
9117: log_statement(l_api_name, 'err_insert_consist', 'Error in insert_consist_record');
9118: END IF;

Line 9115: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

9111: IF l_debug = 1 THEN
9112: log_statement(l_api_name, 'uerr_insert_consist', 'Unexpected error in insert_consist_record');
9113: END IF;
9114: RAISE fnd_api.g_exc_unexpected_error;
9115: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
9116: IF l_debug = 1 THEN
9117: log_statement(l_api_name, 'err_insert_consist', 'Error in insert_consist_record');
9118: END IF;
9119: RAISE fnd_api.g_exc_error;

Line 9119: RAISE fnd_api.g_exc_error;

9115: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
9116: IF l_debug = 1 THEN
9117: log_statement(l_api_name, 'err_insert_consist', 'Error in insert_consist_record');
9118: END IF;
9119: RAISE fnd_api.g_exc_error;
9120: END IF;
9121:
9122: --if allocated a consist group, exit pick uom loop
9123: IF l_finished THEN

Line 9167: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

9163: , x_sec_allocated_quantity => l_sec_allocated_quantity
9164: , x_sec_remaining_quantity => l_sec_remaining_quantity
9165: );
9166:
9167: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
9168: IF l_debug = 1 THEN
9169: log_statement(l_api_name, 'uerr_validate_insert', 'Unexpected error in validate_and_insert');
9170: END IF;
9171: RAISE fnd_api.g_exc_unexpected_error;

Line 9171: RAISE fnd_api.g_exc_unexpected_error;

9167: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
9168: IF l_debug = 1 THEN
9169: log_statement(l_api_name, 'uerr_validate_insert', 'Unexpected error in validate_and_insert');
9170: END IF;
9171: RAISE fnd_api.g_exc_unexpected_error;
9172: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
9173: IF l_debug = 1 THEN
9174: log_statement(l_api_name, 'err_validate_insert', 'Error in validate_and_insert');
9175: END IF;

Line 9172: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

9168: IF l_debug = 1 THEN
9169: log_statement(l_api_name, 'uerr_validate_insert', 'Unexpected error in validate_and_insert');
9170: END IF;
9171: RAISE fnd_api.g_exc_unexpected_error;
9172: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
9173: IF l_debug = 1 THEN
9174: log_statement(l_api_name, 'err_validate_insert', 'Error in validate_and_insert');
9175: END IF;
9176: RAISE fnd_api.g_exc_error;

Line 9176: RAISE fnd_api.g_exc_error;

9172: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
9173: IF l_debug = 1 THEN
9174: log_statement(l_api_name, 'err_validate_insert', 'Error in validate_and_insert');
9175: END IF;
9176: RAISE fnd_api.g_exc_error;
9177: END IF;
9178:
9179: --If returns true, decrease needed quantity
9180: IF l_inserted_record THEN

Line 9273: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

9269: , p_lot_divisible_flag => inv_cache.item_rec.lot_divisible_flag
9270: , x_success => l_finished
9271: );
9272:
9273: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
9274: IF l_debug = 1 THEN
9275: log_statement(l_api_name, 'uerr_allocate_consist', 'Unexpected error in allocate_consist_group');
9276: END IF;
9277: RAISE fnd_api.g_exc_unexpected_error;

Line 9277: RAISE fnd_api.g_exc_unexpected_error;

9273: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
9274: IF l_debug = 1 THEN
9275: log_statement(l_api_name, 'uerr_allocate_consist', 'Unexpected error in allocate_consist_group');
9276: END IF;
9277: RAISE fnd_api.g_exc_unexpected_error;
9278: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
9279: IF l_debug = 1 THEN
9280: log_statement(l_api_name, 'err_allocate_consist', 'Error in allocate_consist_group');
9281: END IF;

Line 9278: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

9274: IF l_debug = 1 THEN
9275: log_statement(l_api_name, 'uerr_allocate_consist', 'Unexpected error in allocate_consist_group');
9276: END IF;
9277: RAISE fnd_api.g_exc_unexpected_error;
9278: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
9279: IF l_debug = 1 THEN
9280: log_statement(l_api_name, 'err_allocate_consist', 'Error in allocate_consist_group');
9281: END IF;
9282: RAISE fnd_api.g_exc_error;

Line 9282: RAISE fnd_api.g_exc_error;

9278: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
9279: IF l_debug = 1 THEN
9280: log_statement(l_api_name, 'err_allocate_consist', 'Error in allocate_consist_group');
9281: END IF;
9282: RAISE fnd_api.g_exc_error;
9283: END IF;
9284:
9285: --if finished = true
9286: --exit consist restrictions loop

Line 9369: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

9365: , x_finished => l_finished
9366: , x_remaining_quantity => l_remaining_quantity
9367: );
9368:
9369: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
9370: IF l_debug = 1 THEN
9371: log_statement(l_api_name, 'uerr_insert_consist', 'Unexpected error in insert_consist_record');
9372: END IF;
9373: RAISE fnd_api.g_exc_unexpected_error;

Line 9373: RAISE fnd_api.g_exc_unexpected_error;

9369: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
9370: IF l_debug = 1 THEN
9371: log_statement(l_api_name, 'uerr_insert_consist', 'Unexpected error in insert_consist_record');
9372: END IF;
9373: RAISE fnd_api.g_exc_unexpected_error;
9374: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
9375: IF l_debug = 1 THEN
9376: log_statement(l_api_name, 'err_insert_consist', 'Error in insert_consist_record');
9377: END IF;

Line 9374: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

9370: IF l_debug = 1 THEN
9371: log_statement(l_api_name, 'uerr_insert_consist', 'Unexpected error in insert_consist_record');
9372: END IF;
9373: RAISE fnd_api.g_exc_unexpected_error;
9374: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
9375: IF l_debug = 1 THEN
9376: log_statement(l_api_name, 'err_insert_consist', 'Error in insert_consist_record');
9377: END IF;
9378: RAISE fnd_api.g_exc_error;

Line 9378: RAISE fnd_api.g_exc_error;

9374: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
9375: IF l_debug = 1 THEN
9376: log_statement(l_api_name, 'err_insert_consist', 'Error in insert_consist_record');
9377: END IF;
9378: RAISE fnd_api.g_exc_error;
9379: END IF;
9380:
9381: --if allocated a consist group, exit pick uom loop
9382: IF l_finished THEN

Line 9430: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

9426: , x_sec_allocated_quantity => l_sec_allocated_quantity
9427: , x_sec_remaining_quantity => l_sec_remaining_quantity
9428: );
9429:
9430: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
9431: IF l_debug = 1 THEN
9432: log_statement(l_api_name, 'uerr_validate_insert', 'Unexpected error in validate_and_insert');
9433: END IF;
9434: RAISE fnd_api.g_exc_unexpected_error;

Line 9434: RAISE fnd_api.g_exc_unexpected_error;

9430: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
9431: IF l_debug = 1 THEN
9432: log_statement(l_api_name, 'uerr_validate_insert', 'Unexpected error in validate_and_insert');
9433: END IF;
9434: RAISE fnd_api.g_exc_unexpected_error;
9435: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
9436: IF l_debug = 1 THEN
9437: log_statement(l_api_name, 'err_validate_insert', 'Error in validate_and_insert');
9438: END IF;

Line 9435: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

9431: IF l_debug = 1 THEN
9432: log_statement(l_api_name, 'uerr_validate_insert', 'Unexpected error in validate_and_insert');
9433: END IF;
9434: RAISE fnd_api.g_exc_unexpected_error;
9435: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
9436: IF l_debug = 1 THEN
9437: log_statement(l_api_name, 'err_validate_insert', 'Error in validate_and_insert');
9438: END IF;
9439: RAISE fnd_api.g_exc_error;

Line 9439: RAISE fnd_api.g_exc_error;

9435: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
9436: IF l_debug = 1 THEN
9437: log_statement(l_api_name, 'err_validate_insert', 'Error in validate_and_insert');
9438: END IF;
9439: RAISE fnd_api.g_exc_error;
9440: END IF;
9441:
9442: --If returns true, decrease needed quantity
9443: IF l_inserted_record THEN

Line 9636: , p_init_msg_lst => fnd_api.g_false -- p_init_msg_lst

9632: --Validate available quantity
9633: inv_quantity_tree_pvt.query_tree
9634: (
9635: p_api_version_number => g_qty_tree_api_version
9636: , p_init_msg_lst => fnd_api.g_false -- p_init_msg_lst
9637: , x_return_status => x_return_status
9638: , x_msg_count => x_msg_count
9639: , x_msg_data => x_msg_data
9640: , p_tree_id => p_tree_id

Line 9662: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

9658: , p_cost_group_id => v_current_row.cost_group_id
9659: , p_lpn_id => v_current_row.lpn_id
9660: );
9661:
9662: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
9663: IF l_debug = 1 THEN
9664: log_statement(l_api_name, 'uerr_qty_tree', 'Unexpected error in inv_quantity_tree_Pvt.query_tree');
9665: END IF;
9666: RAISE fnd_api.g_exc_unexpected_error;

Line 9666: RAISE fnd_api.g_exc_unexpected_error;

9662: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
9663: IF l_debug = 1 THEN
9664: log_statement(l_api_name, 'uerr_qty_tree', 'Unexpected error in inv_quantity_tree_Pvt.query_tree');
9665: END IF;
9666: RAISE fnd_api.g_exc_unexpected_error;
9667: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
9668: IF l_debug = 1 THEN
9669: log_statement(l_api_name, 'err_qty_tree', 'Error in inv_quantity_tree_Pvt.query_tree');
9670: END IF;

Line 9667: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

9663: IF l_debug = 1 THEN
9664: log_statement(l_api_name, 'uerr_qty_tree', 'Unexpected error in inv_quantity_tree_Pvt.query_tree');
9665: END IF;
9666: RAISE fnd_api.g_exc_unexpected_error;
9667: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
9668: IF l_debug = 1 THEN
9669: log_statement(l_api_name, 'err_qty_tree', 'Error in inv_quantity_tree_Pvt.query_tree');
9670: END IF;
9671: RAISE fnd_api.g_exc_error;

Line 9671: RAISE fnd_api.g_exc_error;

9667: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
9668: IF l_debug = 1 THEN
9669: log_statement(l_api_name, 'err_qty_tree', 'Error in inv_quantity_tree_Pvt.query_tree');
9670: END IF;
9671: RAISE fnd_api.g_exc_error;
9672: END IF;
9673:
9674: IF l_debug = 1 THEN
9675: log_statement(l_api_name, 'att', 'ATT : ' || l_att);

Line 9747: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

9743: , x_finished => l_finished
9744: , x_remaining_quantity => l_remaining_quantity
9745: );
9746:
9747: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
9748: IF l_debug = 1 THEN
9749: log_statement(l_api_name, 'uerr_insert_consist', 'Unexpected error in insert_consist_record');
9750: END IF;
9751: RAISE fnd_api.g_exc_unexpected_error;

Line 9751: RAISE fnd_api.g_exc_unexpected_error;

9747: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
9748: IF l_debug = 1 THEN
9749: log_statement(l_api_name, 'uerr_insert_consist', 'Unexpected error in insert_consist_record');
9750: END IF;
9751: RAISE fnd_api.g_exc_unexpected_error;
9752: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
9753: IF l_debug = 1 THEN
9754: log_statement(l_api_name, 'err_insert_consist', 'Error in insert_consist_record');
9755: END IF;

Line 9752: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

9748: IF l_debug = 1 THEN
9749: log_statement(l_api_name, 'uerr_insert_consist', 'Unexpected error in insert_consist_record');
9750: END IF;
9751: RAISE fnd_api.g_exc_unexpected_error;
9752: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
9753: IF l_debug = 1 THEN
9754: log_statement(l_api_name, 'err_insert_consist', 'Error in insert_consist_record');
9755: END IF;
9756: RAISE fnd_api.g_exc_error;

Line 9756: RAISE fnd_api.g_exc_error;

9752: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
9753: IF l_debug = 1 THEN
9754: log_statement(l_api_name, 'err_insert_consist', 'Error in insert_consist_record');
9755: END IF;
9756: RAISE fnd_api.g_exc_error;
9757: END IF;
9758:
9759: --if finished, needed qty = 0
9760: IF l_finished THEN

Line 9804: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

9800: , x_sec_allocated_quantity => l_sec_allocated_quantity
9801: , x_sec_remaining_quantity => l_sec_remaining_quantity
9802: );
9803:
9804: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
9805: IF l_debug = 1 THEN
9806: log_statement(l_api_name, 'uerr_validate_insert', 'Unexpected error in validate_and_insert');
9807: END IF;
9808: RAISE fnd_api.g_exc_unexpected_error;

Line 9808: RAISE fnd_api.g_exc_unexpected_error;

9804: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
9805: IF l_debug = 1 THEN
9806: log_statement(l_api_name, 'uerr_validate_insert', 'Unexpected error in validate_and_insert');
9807: END IF;
9808: RAISE fnd_api.g_exc_unexpected_error;
9809: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
9810: IF l_debug = 1 THEN
9811: log_statement(l_api_name, 'err_validate_insert', 'Error in validate_and_insert');
9812: END IF;

Line 9809: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

9805: IF l_debug = 1 THEN
9806: log_statement(l_api_name, 'uerr_validate_insert', 'Unexpected error in validate_and_insert');
9807: END IF;
9808: RAISE fnd_api.g_exc_unexpected_error;
9809: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
9810: IF l_debug = 1 THEN
9811: log_statement(l_api_name, 'err_validate_insert', 'Error in validate_and_insert');
9812: END IF;
9813: RAISE fnd_api.g_exc_error;

Line 9813: RAISE fnd_api.g_exc_error;

9809: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
9810: IF l_debug = 1 THEN
9811: log_statement(l_api_name, 'err_validate_insert', 'Error in validate_and_insert');
9812: END IF;
9813: RAISE fnd_api.g_exc_error;
9814: END IF;
9815:
9816: --if returns true, decrease needed qty
9817: IF l_inserted_record THEN

Line 9939: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

9935: , l_otask_id
9936: , l_rows
9937: );
9938:
9939: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
9940: IF l_debug = 1 THEN
9941: log_statement(l_api_name, 'uerr_fetch_cursor',
9942: 'Unexpected error in FetchCursor');
9943: END IF;

Line 9944: RAISE fnd_api.g_exc_unexpected_error;

9940: IF l_debug = 1 THEN
9941: log_statement(l_api_name, 'uerr_fetch_cursor',
9942: 'Unexpected error in FetchCursor');
9943: END IF;
9944: RAISE fnd_api.g_exc_unexpected_error;
9945: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
9946: IF l_debug = 1 THEN
9947: log_statement(l_api_name,'err_fetch_cursor','Error in FetchCursor');
9948: END IF;

Line 9945: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

9941: log_statement(l_api_name, 'uerr_fetch_cursor',
9942: 'Unexpected error in FetchCursor');
9943: END IF;
9944: RAISE fnd_api.g_exc_unexpected_error;
9945: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
9946: IF l_debug = 1 THEN
9947: log_statement(l_api_name,'err_fetch_cursor','Error in FetchCursor');
9948: END IF;
9949: RAISE fnd_api.g_exc_error;

Line 9949: RAISE fnd_api.g_exc_error;

9945: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
9946: IF l_debug = 1 THEN
9947: log_statement(l_api_name,'err_fetch_cursor','Error in FetchCursor');
9948: END IF;
9949: RAISE fnd_api.g_exc_error;
9950: END IF;
9951:
9952: -- Exit if no more records from rule cursor
9953: EXIT WHEN nvl(l_rows, 0) = 0 ; -- [ Added to to exit , if the rule is not returning any rows

Line 10421: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

10417: , p_lpn_id => NULL
10418: , p_cost_group_id => l_to_cost_group_id
10419: );
10420:
10421: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
10422: IF l_debug = 1 THEN
10423: log_statement(l_api_name, 'uerr_comingle_check', 'Unexpected error in comingle_check');
10424: END IF;
10425: RAISE fnd_api.g_exc_unexpected_error;

Line 10425: RAISE fnd_api.g_exc_unexpected_error;

10421: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
10422: IF l_debug = 1 THEN
10423: log_statement(l_api_name, 'uerr_comingle_check', 'Unexpected error in comingle_check');
10424: END IF;
10425: RAISE fnd_api.g_exc_unexpected_error;
10426: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
10427: IF l_debug = 1 THEN
10428: log_statement(l_api_name, 'err_comingle_check', 'Error in comingle_check');
10429: END IF;

Line 10426: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

10422: IF l_debug = 1 THEN
10423: log_statement(l_api_name, 'uerr_comingle_check', 'Unexpected error in comingle_check');
10424: END IF;
10425: RAISE fnd_api.g_exc_unexpected_error;
10426: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
10427: IF l_debug = 1 THEN
10428: log_statement(l_api_name, 'err_comingle_check', 'Error in comingle_check');
10429: END IF;
10430: RAISE fnd_api.g_exc_error;

Line 10430: RAISE fnd_api.g_exc_error;

10426: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
10427: IF l_debug = 1 THEN
10428: log_statement(l_api_name, 'err_comingle_check', 'Error in comingle_check');
10429: END IF;
10430: RAISE fnd_api.g_exc_error;
10431: END IF;
10432:
10433: -- Skip record if it would cause comingling
10434: IF l_comingle = 'Y' THEN

Line 10473: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

10469: , p_transaction_uom_code => NULL
10470: , p_quantity => l_possible_quantity
10471: );
10472:
10473: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
10474: IF l_debug = 1 THEN
10475: log_statement(l_api_name, 'uerr_update_capacity', 'Unexpected error in update_loc_suggested_capacity');
10476: END IF;
10477: RAISE fnd_api.g_exc_unexpected_error;

Line 10477: RAISE fnd_api.g_exc_unexpected_error;

10473: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
10474: IF l_debug = 1 THEN
10475: log_statement(l_api_name, 'uerr_update_capacity', 'Unexpected error in update_loc_suggested_capacity');
10476: END IF;
10477: RAISE fnd_api.g_exc_unexpected_error;
10478: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
10479: IF l_debug = 1 THEN
10480: log_statement(l_api_name, 'err_update_capacity', 'Error in update_loc_suggested_capacity');
10481: END IF;

Line 10478: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

10474: IF l_debug = 1 THEN
10475: log_statement(l_api_name, 'uerr_update_capacity', 'Unexpected error in update_loc_suggested_capacity');
10476: END IF;
10477: RAISE fnd_api.g_exc_unexpected_error;
10478: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
10479: IF l_debug = 1 THEN
10480: log_statement(l_api_name, 'err_update_capacity', 'Error in update_loc_suggested_capacity');
10481: END IF;
10482: RAISE fnd_api.g_exc_error;

Line 10482: RAISE fnd_api.g_exc_error;

10478: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
10479: IF l_debug = 1 THEN
10480: log_statement(l_api_name, 'err_update_capacity', 'Error in update_loc_suggested_capacity');
10481: END IF;
10482: RAISE fnd_api.g_exc_error;
10483: ELSE
10484: l_capacity_updated := TRUE;
10485: END IF;
10486: END IF;

Line 10615: x_finished := fnd_api.g_false;

10611: )
10612: )
10613: THEN
10614: -- notice, that at least one input record couldn't get satisfied
10615: x_finished := fnd_api.g_false;
10616:
10617: IF l_needed_quantity = l_initial_pri_quantity THEN
10618: -- Bug #3396532
10619: IF WMS_ENGINE_PVT.G_SUGG_FAILURE_MESSAGE IS NULL THEN

Line 10697: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

10693: /*End of fix for Bug 5251221 */
10694:
10695:
10696: --
10697: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
10698: IF l_debug = 1 THEN
10699: log_statement(l_api_name, 'uerr_restore_tree', 'Unexpected error in restore_tree');
10700: END IF;
10701: RAISE fnd_api.g_exc_unexpected_error;

Line 10701: RAISE fnd_api.g_exc_unexpected_error;

10697: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
10698: IF l_debug = 1 THEN
10699: log_statement(l_api_name, 'uerr_restore_tree', 'Unexpected error in restore_tree');
10700: END IF;
10701: RAISE fnd_api.g_exc_unexpected_error;
10702: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
10703: IF l_debug = 1 THEN
10704: log_statement(l_api_name, 'err_restore_tree', 'Error in restore_tree');
10705: END IF;

Line 10702: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

10698: IF l_debug = 1 THEN
10699: log_statement(l_api_name, 'uerr_restore_tree', 'Unexpected error in restore_tree');
10700: END IF;
10701: RAISE fnd_api.g_exc_unexpected_error;
10702: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
10703: IF l_debug = 1 THEN
10704: log_statement(l_api_name, 'err_restore_tree', 'Error in restore_tree');
10705: END IF;
10706: RAISE fnd_api.g_exc_error;

Line 10706: RAISE fnd_api.g_exc_error;

10702: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
10703: IF l_debug = 1 THEN
10704: log_statement(l_api_name, 'err_restore_tree', 'Error in restore_tree');
10705: END IF;
10706: RAISE fnd_api.g_exc_error;
10707: END IF;
10708: ELSE --for put away, restore capacity
10709: --this function reduces the suggested units in the location
10710: -- for each record inserted in wms_transaction_temp as a

Line 10720: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

10716: , p_organization_id => p_organization_id
10717: , p_inventory_item_id => p_inventory_item_id
10718: );
10719:
10720: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
10721: IF l_debug = 1 THEN
10722: log_statement(l_api_name, 'uerr_rollback_cap', 'Unexpected error in rollback_capacity_update');
10723: END IF;
10724: RAISE fnd_api.g_exc_unexpected_error;

Line 10724: RAISE fnd_api.g_exc_unexpected_error;

10720: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
10721: IF l_debug = 1 THEN
10722: log_statement(l_api_name, 'uerr_rollback_cap', 'Unexpected error in rollback_capacity_update');
10723: END IF;
10724: RAISE fnd_api.g_exc_unexpected_error;
10725: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
10726: IF l_debug = 1 THEN
10727: log_statement(l_api_name, 'err_rollback_cap', 'Error in rollback_capacity_update');
10728: END IF;

Line 10725: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

10721: IF l_debug = 1 THEN
10722: log_statement(l_api_name, 'uerr_rollback_cap', 'Unexpected error in rollback_capacity_update');
10723: END IF;
10724: RAISE fnd_api.g_exc_unexpected_error;
10725: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
10726: IF l_debug = 1 THEN
10727: log_statement(l_api_name, 'err_rollback_cap', 'Error in rollback_capacity_update');
10728: END IF;
10729: RAISE fnd_api.g_exc_error;

Line 10729: RAISE fnd_api.g_exc_error;

10725: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
10726: IF l_debug = 1 THEN
10727: log_statement(l_api_name, 'err_rollback_cap', 'Error in rollback_capacity_update');
10728: END IF;
10729: RAISE fnd_api.g_exc_error;
10730: END IF;
10731:
10732: --if error occurred after capacity got updated but before
10733: -- insertion into WTT, fix the capacity for that record

Line 10750: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

10746: , p_transaction_uom_code => NULL
10747: , p_quantity => l_possible_quantity
10748: );
10749:
10750: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
10751: IF l_debug = 1 THEN
10752: log_statement(l_api_name, 'uerr_revert_capacity', 'Unexpected error in revert_loc_suggested_capacity');
10753: END IF;
10754: RAISE fnd_api.g_exc_unexpected_error;

Line 10754: RAISE fnd_api.g_exc_unexpected_error;

10750: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
10751: IF l_debug = 1 THEN
10752: log_statement(l_api_name, 'uerr_revert_capacity', 'Unexpected error in revert_loc_suggested_capacity');
10753: END IF;
10754: RAISE fnd_api.g_exc_unexpected_error;
10755: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
10756: IF l_debug = 1 THEN
10757: log_statement(l_api_name, 'err_revert_capacity', 'Error in revert_loc_suggested_capacity');
10758: END IF;

Line 10755: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

10751: IF l_debug = 1 THEN
10752: log_statement(l_api_name, 'uerr_revert_capacity', 'Unexpected error in revert_loc_suggested_capacity');
10753: END IF;
10754: RAISE fnd_api.g_exc_unexpected_error;
10755: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
10756: IF l_debug = 1 THEN
10757: log_statement(l_api_name, 'err_revert_capacity', 'Error in revert_loc_suggested_capacity');
10758: END IF;
10759: RAISE fnd_api.g_exc_error;

Line 10759: RAISE fnd_api.g_exc_error;

10755: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
10756: IF l_debug = 1 THEN
10757: log_statement(l_api_name, 'err_revert_capacity', 'Error in revert_loc_suggested_capacity');
10758: END IF;
10759: RAISE fnd_api.g_exc_error;
10760: END IF;
10761:
10762: l_capacity_updated := FALSE;
10763: END IF;

Line 10784: , p_init_msg_list => fnd_api.g_false

10780: END LOOP;
10781:
10782: wms_search_order_globals_pvt.insert_trace_lines(
10783: p_api_version => 1.0
10784: , p_init_msg_list => fnd_api.g_false
10785: , p_validation_level => fnd_api.g_valid_level_full
10786: , x_return_status => l_return_status
10787: , x_msg_count => x_msg_count
10788: , x_msg_data => x_msg_data

Line 10785: , p_validation_level => fnd_api.g_valid_level_full

10781:
10782: wms_search_order_globals_pvt.insert_trace_lines(
10783: p_api_version => 1.0
10784: , p_init_msg_list => fnd_api.g_false
10785: , p_validation_level => fnd_api.g_valid_level_full
10786: , x_return_status => l_return_status
10787: , x_msg_count => x_msg_count
10788: , x_msg_data => x_msg_data
10789: , p_header_id => wms_engine_pvt.g_trace_header_id

Line 10814: x_finished := fnd_api.g_true;

10810: wms_re_common_pvt.updateinputline(l_needed_quantity,l_sec_needed_quantity);
10811: END IF;
10812: END IF;
10813: ELSE
10814: x_finished := fnd_api.g_true;
10815: -- if input line could get satisfied
10816: -- delete the input line in the wms_transactions_temp table
10817: IF l_debug = 1 THEN
10818: log_statement(l_api_name, 'deleting_input_rec', 'Deleting the input line in WTT and pl/sql table');

Line 10832: , p_init_msg_list => fnd_api.g_false

10828:
10829: IF l_debug_on THEN
10830: wms_search_order_globals_pvt.insert_trace_lines(
10831: p_api_version => 1.0
10832: , p_init_msg_list => fnd_api.g_false
10833: , p_validation_level => fnd_api.g_valid_level_full
10834: , x_return_status => l_return_status
10835: , x_msg_count => x_msg_count
10836: , x_msg_data => x_msg_data

Line 10833: , p_validation_level => fnd_api.g_valid_level_full

10829: IF l_debug_on THEN
10830: wms_search_order_globals_pvt.insert_trace_lines(
10831: p_api_version => 1.0
10832: , p_init_msg_list => fnd_api.g_false
10833: , p_validation_level => fnd_api.g_valid_level_full
10834: , x_return_status => l_return_status
10835: , x_msg_count => x_msg_count
10836: , x_msg_data => x_msg_data
10837: , p_header_id => wms_engine_pvt.g_trace_header_id

Line 10849: IF fnd_api.to_boolean(p_commit) THEN

10845: END LOOP; -- input records
10846:
10847: --
10848: -- Standard check of p_commit
10849: IF fnd_api.to_boolean(p_commit) THEN
10850: COMMIT WORK;
10851: END IF;
10852:
10853: -- end of debugging section

Line 10859: WHEN fnd_api.g_exc_error THEN

10855: log_procedure(l_api_name, 'end', 'End Apply');
10856: END IF;
10857: --
10858: EXCEPTION
10859: WHEN fnd_api.g_exc_error THEN
10860: --
10861: --if l_pack_exists <>2, then open_curs was never called, so no need to
10862: -- close the cursor
10863: IF (l_pack_exists = 2) THEN

Line 10897: x_return_status := fnd_api.g_ret_sts_error;

10893: END IF;
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;

Line 10903: WHEN fnd_api.g_exc_unexpected_error THEN

10899: IF l_debug = 1 THEN
10900: log_error(l_api_name, 'error', 'Expected error - ' || x_msg_data);
10901: END IF;
10902: --
10903: WHEN fnd_api.g_exc_unexpected_error THEN
10904: --if l_pack_exists <>2, then open_curs was never called, so no need to
10905: -- close the cursor
10906: IF (l_pack_exists = 2) THEN
10907: close_put_rule(l_rule_id, v_put_cursor);

Line 10940: x_return_status := fnd_api.g_ret_sts_unexp_error;

10936: END IF;
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;

Line 10983: x_return_status := fnd_api.g_ret_sts_unexp_error;

10979: END IF;
10980:
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;

Line 11055: x_return_status := fnd_api.g_ret_sts_success;

11051: ELSE
11052: RAISE invalid_loc_control_exception;
11053: END IF;
11054: --
11055: x_return_status := fnd_api.g_ret_sts_success;
11056: RETURN l_locator_control;
11057: EXCEPTION
11058: WHEN invalid_loc_control_exception THEN
11059: fnd_message.set_name('INV','INV_INVALID_LOC_CONTROL');

Line 11062: x_return_status := fnd_api.g_ret_sts_error ;

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 ;
11065: --
11066: WHEN fnd_api.g_exc_error THEN

Line 11066: WHEN fnd_api.g_exc_error THEN

11062: x_return_status := fnd_api.g_ret_sts_error ;
11063: l_locator_control := -1 ;
11064: RETURN l_locator_control ;
11065: --
11066: WHEN fnd_api.g_exc_error THEN
11067: x_return_status := fnd_api.g_ret_sts_error ;
11068: l_locator_control := -1 ;
11069: RETURN l_locator_control ;
11070: --

Line 11067: x_return_status := fnd_api.g_ret_sts_error ;

11063: l_locator_control := -1 ;
11064: RETURN l_locator_control ;
11065: --
11066: WHEN fnd_api.g_exc_error THEN
11067: x_return_status := fnd_api.g_ret_sts_error ;
11068: l_locator_control := -1 ;
11069: RETURN l_locator_control ;
11070: --
11071: WHEN fnd_api.g_exc_unexpected_error THEN

Line 11071: WHEN fnd_api.g_exc_unexpected_error THEN

11067: x_return_status := fnd_api.g_ret_sts_error ;
11068: l_locator_control := -1 ;
11069: RETURN l_locator_control ;
11070: --
11071: WHEN fnd_api.g_exc_unexpected_error THEN
11072: x_return_status := fnd_api.g_ret_sts_unexp_error ;
11073: l_locator_control := -1 ;
11074: RETURN l_locator_control ;
11075: --

Line 11072: x_return_status := fnd_api.g_ret_sts_unexp_error ;

11068: l_locator_control := -1 ;
11069: RETURN l_locator_control ;
11070: --
11071: WHEN fnd_api.g_exc_unexpected_error THEN
11072: x_return_status := fnd_api.g_ret_sts_unexp_error ;
11073: l_locator_control := -1 ;
11074: RETURN l_locator_control ;
11075: --
11076: WHEN OTHERS THEN

Line 11077: x_return_status := fnd_api.g_ret_sts_unexp_error ;

11073: l_locator_control := -1 ;
11074: 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;

Line 11116: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

11112: )
11113: IS
11114: -- constants
11115: l_api_name CONSTANT VARCHAR(30) := 'get_putaway_defaults';
11116: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
11117: --
11118: -- variable
11119: l_sub_loc_control NUMBER;
11120: l_loc_control NUMBER;

Line 11183: RAISE fnd_api.g_exc_error;

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
11187: l_putaway_sub := p_to_subinventory_code ;

Line 11198: RAISE fnd_api.g_exc_error;

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;
11202:

Line 11224: IF l_return_status = fnd_api.g_ret_sts_error THEN

11220: log_statement(l_api_name, 'l_sub_loc_control ', l_sub_loc_control);
11221: log_statement(l_api_name, 'l_loc_control ' , l_loc_control);
11222: END IF;
11223:
11224: IF l_return_status = fnd_api.g_ret_sts_error THEN
11225: RAISE fnd_api.g_exc_error ;
11226: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
11227: RAISE fnd_api.g_exc_unexpected_error;
11228: END IF;

Line 11225: RAISE fnd_api.g_exc_error ;

11221: log_statement(l_api_name, 'l_loc_control ' , l_loc_control);
11222: END IF;
11223:
11224: IF l_return_status = fnd_api.g_ret_sts_error THEN
11225: RAISE fnd_api.g_exc_error ;
11226: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
11227: RAISE fnd_api.g_exc_unexpected_error;
11228: END IF;
11229:

Line 11226: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

11222: END IF;
11223:
11224: IF l_return_status = fnd_api.g_ret_sts_error THEN
11225: RAISE fnd_api.g_exc_error ;
11226: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
11227: RAISE fnd_api.g_exc_unexpected_error;
11228: END IF;
11229:
11230: --

Line 11227: RAISE fnd_api.g_exc_unexpected_error;

11223:
11224: IF l_return_status = fnd_api.g_ret_sts_error THEN
11225: RAISE fnd_api.g_exc_error ;
11226: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
11227: RAISE fnd_api.g_exc_unexpected_error;
11228: END IF;
11229:
11230: --
11231: IF l_loc_control = 2 THEN -- has locator control

Line 11241: RAISE fnd_api.g_exc_error;

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
11244: l_putaway_loc := p_to_locator_id ;
11245: IF l_debug = 1 THEN

Line 11280: RAISE fnd_api.g_exc_error;

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
11284: l_putaway_cg := p_to_cost_group_id;

Line 11306: WHEN fnd_api.g_exc_error THEN

11302: END IF;
11303:
11304:
11305: EXCEPTION
11306: WHEN fnd_api.g_exc_error THEN
11307: x_return_status := fnd_api.g_ret_sts_error ;
11308: x_putaway_loc := NULL;
11309: x_putaway_sub := NULL;
11310: x_putaway_cost_group_id := NULL;

Line 11307: x_return_status := fnd_api.g_ret_sts_error ;

11303:
11304:
11305: EXCEPTION
11306: WHEN fnd_api.g_exc_error THEN
11307: x_return_status := fnd_api.g_ret_sts_error ;
11308: x_putaway_loc := NULL;
11309: x_putaway_sub := NULL;
11310: x_putaway_cost_group_id := NULL;
11311: --

Line 11312: WHEN fnd_api.g_exc_unexpected_error THEN

11308: x_putaway_loc := NULL;
11309: x_putaway_sub := NULL;
11310: x_putaway_cost_group_id := NULL;
11311: --
11312: WHEN fnd_api.g_exc_unexpected_error THEN
11313: x_return_status := fnd_api.g_ret_sts_unexp_error ;
11314: x_putaway_loc := NULL;
11315: x_putaway_sub := NULL;
11316: x_putaway_cost_group_id := NULL;

Line 11313: x_return_status := fnd_api.g_ret_sts_unexp_error ;

11309: x_putaway_sub := NULL;
11310: x_putaway_cost_group_id := NULL;
11311: --
11312: WHEN fnd_api.g_exc_unexpected_error THEN
11313: x_return_status := fnd_api.g_ret_sts_unexp_error ;
11314: x_putaway_loc := NULL;
11315: x_putaway_sub := NULL;
11316: x_putaway_cost_group_id := NULL;
11317: --

Line 11319: x_return_status := fnd_api.g_ret_sts_unexp_error ;

11315: x_putaway_sub := NULL;
11316: x_putaway_cost_group_id := NULL;
11317: --
11318: WHEN OTHERS THEN
11319: x_return_status := fnd_api.g_ret_sts_unexp_error ;
11320: x_putaway_loc := NULL;
11321: x_putaway_sub := NULL;
11322: x_putaway_cost_group_id := NULL;
11323: --

Line 11479: IF NOT fnd_api.compatible_api_call( l_api_version

11475: --
11476:
11477:
11478: -- Standard call to check for call compatibility
11479: IF NOT fnd_api.compatible_api_call( l_api_version
11480: ,p_api_version
11481: ,l_api_name
11482: ,g_pkg_name ) THEN
11483: RAISE fnd_api.g_exc_unexpected_error;

Line 11483: RAISE fnd_api.g_exc_unexpected_error;

11479: IF NOT fnd_api.compatible_api_call( l_api_version
11480: ,p_api_version
11481: ,l_api_name
11482: ,g_pkg_name ) THEN
11483: RAISE fnd_api.g_exc_unexpected_error;
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

Line 11487: IF fnd_api.to_boolean( p_init_msg_list ) THEN

11483: RAISE fnd_api.g_exc_unexpected_error;
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

Line 11492: x_return_status := fnd_api.g_ret_sts_success;

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;
11493: --
11494: -- Initialize functional return status to completed
11495: x_finished := fnd_api.g_true;
11496: --

Line 11495: x_finished := fnd_api.g_true;

11491: -- Initialize API return status to success
11492: x_return_status := fnd_api.g_ret_sts_success;
11493: --
11494: -- Initialize functional return status to completed
11495: x_finished := fnd_api.g_true;
11496: --
11497: -- Validate input parameters and pre-requisites, if validation level
11498: -- requires this
11499: IF p_validation_level <> fnd_api.g_valid_level_none THEN

Line 11499: IF p_validation_level <> fnd_api.g_valid_level_none THEN

11495: x_finished := fnd_api.g_true;
11496: --
11497: -- Validate input parameters and pre-requisites, if validation level
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');

Line 11501: p_transaction_temp_id = fnd_api.g_miss_num THEN

11497: -- Validate input parameters and pre-requisites, if validation level
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');

Line 11509: RAISE fnd_api.g_exc_error;

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
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

Line 11512: p_organization_id = fnd_api.g_miss_num THEN

11508: END IF;
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');

Line 11520: RAISE fnd_api.g_exc_error;

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
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

Line 11523: p_inventory_item_id = fnd_api.g_miss_num THEN

11519: END IF;
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');

Line 11531: RAISE fnd_api.g_exc_error;

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;
11534: --inv_pp_debug.send_message_to_pipe('finished validations');
11535:

Line 11633: IF l_return_status = fnd_api.g_ret_sts_error THEN

11629: x_msg_data );
11630:
11631: -- log_statement(l_api_name, 'Default Putaway values l_return_status ', l_return_status);
11632:
11633: IF l_return_status = fnd_api.g_ret_sts_error THEN
11634: RAISE fnd_api.g_exc_error ;
11635: -- log_statement(l_api_name, 'ApplyDef()', 'Dest Loct is NUll' );
11636: -- GOTO NextOutputRecord;
11637: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 11634: RAISE fnd_api.g_exc_error ;

11630:
11631: -- log_statement(l_api_name, 'Default Putaway values l_return_status ', l_return_status);
11632:
11633: IF l_return_status = fnd_api.g_ret_sts_error THEN
11634: RAISE fnd_api.g_exc_error ;
11635: -- log_statement(l_api_name, 'ApplyDef()', 'Dest Loct is NUll' );
11636: -- GOTO NextOutputRecord;
11637: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
11638: RAISE fnd_api.g_exc_unexpected_error;

Line 11637: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

11633: IF l_return_status = fnd_api.g_ret_sts_error THEN
11634: RAISE fnd_api.g_exc_error ;
11635: -- log_statement(l_api_name, 'ApplyDef()', 'Dest Loct is NUll' );
11636: -- GOTO NextOutputRecord;
11637: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
11638: RAISE fnd_api.g_exc_unexpected_error;
11639: END IF;
11640:
11641: --log_statement(l_api_name, 'l_to_locator_id',nvl(l_to_locator_id, -9999) );

Line 11638: RAISE fnd_api.g_exc_unexpected_error;

11634: RAISE fnd_api.g_exc_error ;
11635: -- log_statement(l_api_name, 'ApplyDef()', 'Dest Loct is NUll' );
11636: -- GOTO NextOutputRecord;
11637: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
11638: RAISE fnd_api.g_exc_unexpected_error;
11639: END IF;
11640:
11641: --log_statement(l_api_name, 'l_to_locator_id',nvl(l_to_locator_id, -9999) );
11642: IF (l_osubinventory_code is NULL AND x_subinventory_code is not NULL ) then

Line 11723: x_finished := fnd_api.g_false;

11719: If l_olocator_id_exist IS NOT NULL THEN
11720: l_olocator_id := l_olocator_id_exist;
11721: ELSE
11722: use_supplied_loc := false;
11723: x_finished := fnd_api.g_false;
11724: If (l_debug = 1) then
11725: log_statement(l_api_name, 'do_project_fail',
11726: 'Do project check failed. Cannot use supplied locator with this Project and Task.');
11727: End if;

Line 11776: x_finished := fnd_api.g_false;

11772: END IF;
11773:
11774: IF l_allowed <> 'Y' THEN
11775: use_supplied_loc := false;
11776: x_finished := fnd_api.g_false;
11777: If (l_debug = 1) then
11778: log_event(l_api_name, 'bad_status',
11779: 'This transaction type is not allowed by the status ' ||
11780: 'for the subinventory, locator. ');

Line 11941: if x_return_status = fnd_api.g_ret_sts_unexp_error then

11937: ,p_locator_id => l_olocator_id
11938: ,p_lpn_id => NULL
11939: ,p_cost_group_id => l_to_cost_group_id
11940: );
11941: if x_return_status = fnd_api.g_ret_sts_unexp_error then
11942: If (l_debug = 1) then
11943: log_statement(l_api_name, 'uerr_comingle_check',
11944: 'Unexpected error in comingle_check');
11945: End if;

Line 11946: RAISE fnd_api.g_exc_unexpected_error;

11942: If (l_debug = 1) then
11943: log_statement(l_api_name, 'uerr_comingle_check',
11944: 'Unexpected error in comingle_check');
11945: End if;
11946: RAISE fnd_api.g_exc_unexpected_error;
11947: elsif x_return_status = fnd_api.g_ret_sts_error then
11948: If (l_debug = 1) then
11949: log_statement(l_api_name, 'err_comingle_check',
11950: 'Error in comingle_check');

Line 11947: elsif x_return_status = fnd_api.g_ret_sts_error then

11943: log_statement(l_api_name, 'uerr_comingle_check',
11944: 'Unexpected error in comingle_check');
11945: End if;
11946: RAISE fnd_api.g_exc_unexpected_error;
11947: elsif x_return_status = fnd_api.g_ret_sts_error then
11948: If (l_debug = 1) then
11949: log_statement(l_api_name, 'err_comingle_check',
11950: 'Error in comingle_check');
11951: End if;

Line 11952: RAISE fnd_api.g_exc_error;

11948: If (l_debug = 1) then
11949: log_statement(l_api_name, 'err_comingle_check',
11950: 'Error in comingle_check');
11951: End if;
11952: RAISE fnd_api.g_exc_error;
11953: end if;
11954:
11955: -- Skip record if it would cause comingling
11956: if l_comingle = 'Y' then

Line 12059: x_finished := fnd_api.g_false;

12055:
12056: -- if input line couldn't get satisfied ...
12057: IF l_needed_quantity > 0 THEN
12058: -- notice, that at least one input record couldn't get satisfied
12059: x_finished := fnd_api.g_false;
12060: If (l_debug = 1) then
12061: log_event(l_api_name, 'no_success',
12062: 'Locator supplied could not be used');
12063: End if;

Line 12066: x_finished := fnd_api.g_true;

12062: 'Locator supplied could not be used');
12063: End if;
12064:
12065: ELSE
12066: x_finished := fnd_api.g_true;
12067: -- if input line could get satisfied
12068: -- delete the input line in the wms_transactions_temp table
12069: If (l_debug = 1) then
12070: log_statement(l_api_name, 'deleting_input_rec',

Line 12083: ,p_init_msg_list => fnd_api.g_false

12079: END IF;
12080: IF l_debug_on THEN
12081: wms_search_order_globals_pvt.insert_trace_lines(
12082: p_api_version => 1.0
12083: ,p_init_msg_list => fnd_api.g_false
12084: ,p_validation_level => fnd_api.g_valid_level_full
12085: ,x_return_status => l_return_status
12086: ,x_msg_count => x_msg_count
12087: ,x_msg_data => x_msg_data

Line 12084: ,p_validation_level => fnd_api.g_valid_level_full

12080: IF l_debug_on THEN
12081: wms_search_order_globals_pvt.insert_trace_lines(
12082: p_api_version => 1.0
12083: ,p_init_msg_list => fnd_api.g_false
12084: ,p_validation_level => fnd_api.g_valid_level_full
12085: ,x_return_status => l_return_status
12086: ,x_msg_count => x_msg_count
12087: ,x_msg_data => x_msg_data
12088: ,p_header_id => wms_engine_pvt.g_trace_header_id

Line 12097: IF fnd_api.to_boolean(p_commit) THEN

12093:
12094: END LOOP; -- input records
12095: --
12096: -- Standard check of p_commit
12097: IF fnd_api.to_boolean(p_commit) THEN
12098: COMMIT WORK;
12099: END IF;
12100: --
12101: If (l_debug = 1) then

Line 12107: WHEN fnd_api.g_exc_error THEN

12103: End if;
12104: l_debug := NULL;
12105: --
12106: EXCEPTION
12107: WHEN fnd_api.g_exc_error THEN
12108:
12109: ROLLBACK TO ApplyRuleSP;
12110: FreeGlobals;
12111: x_return_status := fnd_api.g_ret_sts_error;

Line 12111: x_return_status := fnd_api.g_ret_sts_error;

12107: WHEN fnd_api.g_exc_error THEN
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);

Line 12119: WHEN fnd_api.g_exc_unexpected_error THEN

12115: log_error(l_api_name, 'error', 'Expected error - ' || x_msg_data);
12116: End if;
12117: l_debug := NULL;
12118: --
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

Line 12122: x_return_status := fnd_api.g_ret_sts_unexp_error;

12118: --
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);

Line 12134: x_return_status := fnd_api.g_ret_sts_unexp_error;

12130: WHEN OTHERS THEN
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

Line 12191: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

12187: --
12188: BEGIN
12189: --
12190: -- Standard call to check for call compatibility
12191: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
12192: RAISE fnd_api.g_exc_unexpected_error;
12193: END IF;
12194:
12195: -- Initialize message list if p_init_msg_list is set to TRUE

Line 12192: RAISE fnd_api.g_exc_unexpected_error;

12188: BEGIN
12189: --
12190: -- Standard call to check for call compatibility
12191: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
12192: RAISE fnd_api.g_exc_unexpected_error;
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

Line 12196: IF fnd_api.to_boolean(p_init_msg_list) THEN

12192: RAISE fnd_api.g_exc_unexpected_error;
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: --

Line 12202: x_return_status := fnd_api.g_ret_sts_success;

12198: END IF;
12199:
12200: --
12201: -- Initialize API return status to success
12202: x_return_status := fnd_api.g_ret_sts_success;
12203: generaterulepackage(p_api_version, p_init_msg_list, p_validation_level, x_return_status, x_msg_count, x_msg_data, p_rule_id);
12204:
12205: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
12206: RAISE fnd_api.g_exc_unexpected_error;

Line 12205: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

12201: -- Initialize API return status to success
12202: x_return_status := fnd_api.g_ret_sts_success;
12203: generaterulepackage(p_api_version, p_init_msg_list, p_validation_level, x_return_status, x_msg_count, x_msg_data, p_rule_id);
12204:
12205: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
12206: RAISE fnd_api.g_exc_unexpected_error;
12207: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
12208: RAISE fnd_api.g_exc_error;
12209: END IF;

Line 12206: RAISE fnd_api.g_exc_unexpected_error;

12202: x_return_status := fnd_api.g_ret_sts_success;
12203: generaterulepackage(p_api_version, p_init_msg_list, p_validation_level, x_return_status, x_msg_count, x_msg_data, p_rule_id);
12204:
12205: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
12206: RAISE fnd_api.g_exc_unexpected_error;
12207: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
12208: RAISE fnd_api.g_exc_error;
12209: END IF;
12210:

Line 12207: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

12203: generaterulepackage(p_api_version, p_init_msg_list, p_validation_level, x_return_status, x_msg_count, x_msg_data, p_rule_id);
12204:
12205: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
12206: RAISE fnd_api.g_exc_unexpected_error;
12207: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
12208: RAISE fnd_api.g_exc_error;
12209: END IF;
12210:
12211: EXCEPTION

Line 12208: RAISE fnd_api.g_exc_error;

12204:
12205: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
12206: RAISE fnd_api.g_exc_unexpected_error;
12207: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
12208: RAISE fnd_api.g_exc_error;
12209: END IF;
12210:
12211: EXCEPTION
12212: WHEN fnd_api.g_exc_error THEN

Line 12212: WHEN fnd_api.g_exc_error THEN

12208: RAISE fnd_api.g_exc_error;
12209: END IF;
12210:
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: --

Line 12214: x_return_status := fnd_api.g_ret_sts_error;

12210:
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;

Line 12217: WHEN fnd_api.g_exc_unexpected_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);
12220: --
12221: WHEN OTHERS THEN

Line 12218: x_return_status := fnd_api.g_ret_sts_unexp_error;

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);
12220: --
12221: WHEN OTHERS THEN
12222: freeglobals;

Line 12223: 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;
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;

Line 12314: WHEN fnd_api.g_exc_error THEN

12310:
12311: CLOSE l_cur;
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

Line 12315: x_return_status := fnd_api.g_ret_sts_error;

12311: CLOSE l_cur;
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;

Line 12318: WHEN fnd_api.g_exc_unexpected_error THEN

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);
12321: --
12322: WHEN OTHERS THEN

Line 12319: x_return_status := fnd_api.g_ret_sts_unexp_error;

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);
12321: --
12322: WHEN OTHERS THEN
12323: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 12323: x_return_status := fnd_api.g_ret_sts_unexp_error;

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:
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;

Line 12428: x_return_status := fnd_api.g_ret_sts_unexp_error;

12424: AND status <> 'VALID'
12425: AND rownum = 1;
12426:
12427: BEGIN
12428: x_return_status := fnd_api.g_ret_sts_unexp_error;
12429: --open cursor
12430: l_cursor := DBMS_SQL.open_cursor;
12431: --parse cursor
12432: DBMS_SQL.parse(l_cursor, g_build_package_tbl, 1, g_build_package_row, FALSE, DBMS_SQL.native);

Line 12445: RAISE fnd_api.g_exc_error;

12441: ,industry => l_industry
12442: ,oracle_schema => l_schema
12443: );
12444: IF l_return = FALSE THEN
12445: RAISE fnd_api.g_exc_error;
12446: END IF;
12447:
12448: --Call create package
12449: ad_ddl.create_plsql_object(

Line 12460: RAISE fnd_api.g_exc_error;

12456: ,comp_error => l_comp_error
12457: );
12458:
12459: IF l_comp_error = 'TRUE' THEN
12460: RAISE fnd_api.g_exc_error;
12461: END IF;
12462: */
12463: --Check status, return error if package that was created
12464: -- is invalid

Line 12470: x_return_status := fnd_api.g_ret_sts_unexp_error;

12466: OPEN c_package_body_status;
12467: FETCH c_package_body_status INTO l_error;
12468:
12469: IF c_package_body_status%FOUND THEN
12470: x_return_status := fnd_api.g_ret_sts_unexp_error;
12471: ELSE
12472: x_return_status := fnd_api.g_ret_sts_success;
12473: END IF;
12474:

Line 12472: x_return_status := fnd_api.g_ret_sts_success;

12468:
12469: IF c_package_body_status%FOUND THEN
12470: x_return_status := fnd_api.g_ret_sts_unexp_error;
12471: ELSE
12472: x_return_status := fnd_api.g_ret_sts_success;
12473: END IF;
12474:
12475: CLOSE c_package_body_status;
12476: ELSE

Line 12481: x_return_status := fnd_api.g_ret_sts_unexp_error;

12477: OPEN c_package_status;
12478: FETCH c_package_status INTO l_error;
12479:
12480: IF c_package_status%FOUND THEN
12481: x_return_status := fnd_api.g_ret_sts_unexp_error;
12482: ELSE
12483: x_return_status := fnd_api.g_ret_sts_success;
12484: END IF;
12485:

Line 12483: x_return_status := fnd_api.g_ret_sts_success;

12479:
12480: IF c_package_status%FOUND THEN
12481: x_return_status := fnd_api.g_ret_sts_unexp_error;
12482: ELSE
12483: x_return_status := fnd_api.g_ret_sts_success;
12484: END IF;
12485:
12486: CLOSE c_package_status;
12487: END IF;

Line 12490: x_return_status := fnd_api.g_ret_sts_unexp_error;

12486: CLOSE c_package_status;
12487: END IF;
12488: EXCEPTION
12489: WHEN OTHERS THEN
12490: x_return_status := fnd_api.g_ret_sts_unexp_error;
12491: END createpackage;
12492:
12493: -- API name : GenerateRulePackage
12494: -- Type : Private

Line 12570: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

12566: --
12567: BEGIN
12568: --
12569: -- Standard call to check for call compatibility
12570: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
12571: RAISE fnd_api.g_exc_unexpected_error;
12572: END IF;
12573:
12574: --

Line 12571: RAISE fnd_api.g_exc_unexpected_error;

12567: BEGIN
12568: --
12569: -- Standard call to check for call compatibility
12570: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
12571: RAISE fnd_api.g_exc_unexpected_error;
12572: END IF;
12573:
12574: --
12575: -- Initialize message list if p_init_msg_list is set to TRUE

Line 12576: IF fnd_api.to_boolean(p_init_msg_list) THEN

12572: END IF;
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: --

Line 12582: x_return_status := fnd_api.g_ret_sts_success;

12578: END IF;
12579:
12580: --
12581: -- Initialize API return status to success
12582: x_return_status := fnd_api.g_ret_sts_success;
12583:
12584: log_procedure(l_api_name, 'start', 'Start GenerateRulePackage');
12585:
12586: -- end of debugging section

Line 12589: IF p_validation_level <> fnd_api.g_valid_level_none THEN

12585:
12586: -- end of debugging section
12587: --
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');

Line 12591: OR p_rule_id = fnd_api.g_miss_num THEN

12587: --
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;

Line 12598: RAISE fnd_api.g_exc_error;

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;
12600: END IF;
12601:
12602: --

Line 12639: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

12635: OR l_type_code = 2 THEN
12636: -- Build the base part of the SQL statement
12637: buildbasesql(x_return_status, x_msg_count, x_msg_data, l_type_code, l_allocation_mode_id);
12638:
12639: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
12640: RAISE fnd_api.g_exc_unexpected_error;
12641: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
12642: RAISE fnd_api.g_exc_error;
12643: END IF;

Line 12640: RAISE fnd_api.g_exc_unexpected_error;

12636: -- Build the base part of the SQL statement
12637: buildbasesql(x_return_status, x_msg_count, x_msg_data, l_type_code, l_allocation_mode_id);
12638:
12639: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
12640: RAISE fnd_api.g_exc_unexpected_error;
12641: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
12642: RAISE fnd_api.g_exc_error;
12643: END IF;
12644:

Line 12641: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

12637: buildbasesql(x_return_status, x_msg_count, x_msg_data, l_type_code, l_allocation_mode_id);
12638:
12639: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
12640: RAISE fnd_api.g_exc_unexpected_error;
12641: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
12642: RAISE fnd_api.g_exc_error;
12643: END IF;
12644:
12645: -- Build the input parameter dependent part of the SQL statement

Line 12642: RAISE fnd_api.g_exc_error;

12638:
12639: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
12640: RAISE fnd_api.g_exc_unexpected_error;
12641: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
12642: RAISE fnd_api.g_exc_error;
12643: END IF;
12644:
12645: -- Build the input parameter dependent part of the SQL statement
12646: buildinputsql(x_return_status, x_msg_count, x_msg_data, l_type_code);

Line 12649: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

12645: -- Build the input parameter dependent part of the SQL statement
12646: buildinputsql(x_return_status, x_msg_count, x_msg_data, l_type_code);
12647:
12648: --
12649: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
12650: RAISE fnd_api.g_exc_unexpected_error;
12651: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
12652: RAISE fnd_api.g_exc_error;
12653: END IF;

Line 12650: RAISE fnd_api.g_exc_unexpected_error;

12646: buildinputsql(x_return_status, x_msg_count, x_msg_data, l_type_code);
12647:
12648: --
12649: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
12650: RAISE fnd_api.g_exc_unexpected_error;
12651: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
12652: RAISE fnd_api.g_exc_error;
12653: END IF;
12654: END IF;

Line 12651: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

12647:
12648: --
12649: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
12650: RAISE fnd_api.g_exc_unexpected_error;
12651: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
12652: RAISE fnd_api.g_exc_error;
12653: END IF;
12654: END IF;
12655:

Line 12652: RAISE fnd_api.g_exc_error;

12648: --
12649: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
12650: RAISE fnd_api.g_exc_unexpected_error;
12651: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
12652: RAISE fnd_api.g_exc_error;
12653: END IF;
12654: END IF;
12655:
12656: -- Build the rule dependent part of the SQL statement.

Line 12661: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

12657: -- Happens for rules of all type
12658: buildrulesql(x_return_status, x_msg_count, x_msg_data, p_rule_id, l_type_code, l_allocation_mode_id);
12659:
12660: --
12661: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
12662: RAISE fnd_api.g_exc_unexpected_error;
12663: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
12664: RAISE fnd_api.g_exc_error;
12665: END IF;

Line 12662: RAISE fnd_api.g_exc_unexpected_error;

12658: buildrulesql(x_return_status, x_msg_count, x_msg_data, p_rule_id, l_type_code, l_allocation_mode_id);
12659:
12660: --
12661: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
12662: RAISE fnd_api.g_exc_unexpected_error;
12663: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
12664: RAISE fnd_api.g_exc_error;
12665: END IF;
12666:

Line 12663: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

12659:
12660: --
12661: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
12662: RAISE fnd_api.g_exc_unexpected_error;
12663: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
12664: RAISE fnd_api.g_exc_error;
12665: END IF;
12666:
12667: --

Line 12664: RAISE fnd_api.g_exc_error;

12660: --
12661: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
12662: RAISE fnd_api.g_exc_unexpected_error;
12663: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
12664: RAISE fnd_api.g_exc_error;
12665: END IF;
12666:
12667: --
12668:

Line 12773: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

12769: buildpackage(l_pack_sql);
12770: --create the package spec
12771: createpackage(x_return_status, l_package_name, FALSE);
12772:
12773: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
12774: RAISE fnd_api.g_exc_unexpected_error;
12775: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
12776: RAISE fnd_api.g_exc_error;
12777: END IF;

Line 12774: RAISE fnd_api.g_exc_unexpected_error;

12770: --create the package spec
12771: createpackage(x_return_status, l_package_name, FALSE);
12772:
12773: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
12774: RAISE fnd_api.g_exc_unexpected_error;
12775: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
12776: RAISE fnd_api.g_exc_error;
12777: END IF;
12778:

Line 12775: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

12771: createpackage(x_return_status, l_package_name, FALSE);
12772:
12773: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
12774: RAISE fnd_api.g_exc_unexpected_error;
12775: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
12776: RAISE fnd_api.g_exc_error;
12777: END IF;
12778:
12779: --re initialize global variables

Line 12776: RAISE fnd_api.g_exc_error;

12772:
12773: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
12774: RAISE fnd_api.g_exc_unexpected_error;
12775: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
12776: RAISE fnd_api.g_exc_error;
12777: END IF;
12778:
12779: --re initialize global variables
12780: initbuildpackage;

Line 12839: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

12835: --dbms_sql.close_cursor(l_cursor);
12836: buildpackage(l_pack_sql);
12837: createpackage(x_return_status, l_package_name, FALSE);
12838:
12839: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
12840: RAISE fnd_api.g_exc_unexpected_error;
12841: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
12842: RAISE fnd_api.g_exc_error;
12843: END IF;

Line 12840: RAISE fnd_api.g_exc_unexpected_error;

12836: buildpackage(l_pack_sql);
12837: createpackage(x_return_status, l_package_name, FALSE);
12838:
12839: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
12840: RAISE fnd_api.g_exc_unexpected_error;
12841: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
12842: RAISE fnd_api.g_exc_error;
12843: END IF;
12844:

Line 12841: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

12837: createpackage(x_return_status, l_package_name, FALSE);
12838:
12839: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
12840: RAISE fnd_api.g_exc_unexpected_error;
12841: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
12842: RAISE fnd_api.g_exc_error;
12843: END IF;
12844:
12845: initbuildpackage;

Line 12842: RAISE fnd_api.g_exc_error;

12838:
12839: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
12840: RAISE fnd_api.g_exc_unexpected_error;
12841: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
12842: RAISE fnd_api.g_exc_error;
12843: END IF;
12844:
12845: initbuildpackage;
12846: --inv_pp_debug.send_long_to_pipe(g_stmt);

Line 12903: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

12899: --dbms_sql.close_cursor(l_cursor);
12900: buildpackage(l_pack_sql);
12901: createpackage(x_return_status, l_package_name, FALSE);
12902:
12903: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
12904: RAISE fnd_api.g_exc_unexpected_error;
12905: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
12906: RAISE fnd_api.g_exc_error;
12907: END IF;

Line 12904: RAISE fnd_api.g_exc_unexpected_error;

12900: buildpackage(l_pack_sql);
12901: createpackage(x_return_status, l_package_name, FALSE);
12902:
12903: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
12904: RAISE fnd_api.g_exc_unexpected_error;
12905: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
12906: RAISE fnd_api.g_exc_error;
12907: END IF;
12908:

Line 12905: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

12901: createpackage(x_return_status, l_package_name, FALSE);
12902:
12903: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
12904: RAISE fnd_api.g_exc_unexpected_error;
12905: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
12906: RAISE fnd_api.g_exc_error;
12907: END IF;
12908:
12909: initbuildpackage;

Line 12906: RAISE fnd_api.g_exc_error;

12902:
12903: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
12904: RAISE fnd_api.g_exc_unexpected_error;
12905: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
12906: RAISE fnd_api.g_exc_error;
12907: END IF;
12908:
12909: initbuildpackage;
12910: --inv_pp_debug.send_long_to_pipe(g_stmt);

Line 12970: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

12966: --dbms_sql.close_cursor(l_cursor);
12967: buildpackage(l_pack_sql);
12968: createpackage(x_return_status, l_package_name, FALSE);
12969:
12970: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
12971: RAISE fnd_api.g_exc_unexpected_error;
12972: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
12973: RAISE fnd_api.g_exc_error;
12974: END IF;

Line 12971: RAISE fnd_api.g_exc_unexpected_error;

12967: buildpackage(l_pack_sql);
12968: createpackage(x_return_status, l_package_name, FALSE);
12969:
12970: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
12971: RAISE fnd_api.g_exc_unexpected_error;
12972: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
12973: RAISE fnd_api.g_exc_error;
12974: END IF;
12975:

Line 12972: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

12968: createpackage(x_return_status, l_package_name, FALSE);
12969:
12970: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
12971: RAISE fnd_api.g_exc_unexpected_error;
12972: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
12973: RAISE fnd_api.g_exc_error;
12974: END IF;
12975:
12976: initbuildpackage;

Line 12973: RAISE fnd_api.g_exc_error;

12969:
12970: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
12971: RAISE fnd_api.g_exc_unexpected_error;
12972: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
12973: RAISE fnd_api.g_exc_error;
12974: END IF;
12975:
12976: initbuildpackage;
12977: --inv_pp_debug.send_long_to_pipe(g_stmt);

Line 13076: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

13072: --dbms_sql.close_cursor(l_cursor);
13073: buildpackage(l_pack_sql);
13074: createpackage(x_return_status, l_package_name, FALSE);
13075:
13076: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
13077: RAISE fnd_api.g_exc_unexpected_error;
13078: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
13079: RAISE fnd_api.g_exc_error;
13080: END IF;

Line 13077: RAISE fnd_api.g_exc_unexpected_error;

13073: buildpackage(l_pack_sql);
13074: createpackage(x_return_status, l_package_name, FALSE);
13075:
13076: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
13077: RAISE fnd_api.g_exc_unexpected_error;
13078: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
13079: RAISE fnd_api.g_exc_error;
13080: END IF;
13081:

Line 13078: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

13074: createpackage(x_return_status, l_package_name, FALSE);
13075:
13076: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
13077: RAISE fnd_api.g_exc_unexpected_error;
13078: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
13079: RAISE fnd_api.g_exc_error;
13080: END IF;
13081:
13082: initbuildpackage;

Line 13079: RAISE fnd_api.g_exc_error;

13075:
13076: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
13077: RAISE fnd_api.g_exc_unexpected_error;
13078: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
13079: RAISE fnd_api.g_exc_error;
13080: END IF;
13081:
13082: initbuildpackage;
13083: -- inv_pp_debug.send_long_to_pipe(g_stmt_serial_detail);

Line 13431: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

13427: --dbms_sql.close_cursor(l_cursor);
13428: buildpackage(l_pack_sql);
13429: createpackage(x_return_status, l_package_name, FALSE);
13430:
13431: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
13432: RAISE fnd_api.g_exc_unexpected_error;
13433: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
13434: RAISE fnd_api.g_exc_error;
13435: END IF;

Line 13432: RAISE fnd_api.g_exc_unexpected_error;

13428: buildpackage(l_pack_sql);
13429: createpackage(x_return_status, l_package_name, FALSE);
13430:
13431: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
13432: RAISE fnd_api.g_exc_unexpected_error;
13433: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
13434: RAISE fnd_api.g_exc_error;
13435: END IF;
13436:

Line 13433: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

13429: createpackage(x_return_status, l_package_name, FALSE);
13430:
13431: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
13432: RAISE fnd_api.g_exc_unexpected_error;
13433: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
13434: RAISE fnd_api.g_exc_error;
13435: END IF;
13436:
13437: initbuildpackage;

Line 13434: RAISE fnd_api.g_exc_error;

13430:
13431: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
13432: RAISE fnd_api.g_exc_unexpected_error;
13433: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
13434: RAISE fnd_api.g_exc_error;
13435: END IF;
13436:
13437: initbuildpackage;
13438: -- inv_pp_debug.send_long_to_pipe(g_stmt_serial_detail);

Line 13629: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

13625: -- CreatePackage to generate package body
13626: buildpackage(l_pack_body_sql);
13627: createpackage(x_return_status, l_package_name, TRUE);
13628:
13629: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
13630: RAISE fnd_api.g_exc_unexpected_error;
13631: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
13632: RAISE fnd_api.g_exc_error;
13633: END IF;

Line 13630: RAISE fnd_api.g_exc_unexpected_error;

13626: buildpackage(l_pack_body_sql);
13627: createpackage(x_return_status, l_package_name, TRUE);
13628:
13629: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
13630: RAISE fnd_api.g_exc_unexpected_error;
13631: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
13632: RAISE fnd_api.g_exc_error;
13633: END IF;
13634:

Line 13631: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

13627: createpackage(x_return_status, l_package_name, TRUE);
13628:
13629: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
13630: RAISE fnd_api.g_exc_unexpected_error;
13631: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
13632: RAISE fnd_api.g_exc_error;
13633: END IF;
13634:
13635: initbuildpackage;

Line 13632: RAISE fnd_api.g_exc_error;

13628:
13629: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
13630: RAISE fnd_api.g_exc_unexpected_error;
13631: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
13632: RAISE fnd_api.g_exc_error;
13633: END IF;
13634:
13635: initbuildpackage;
13636: -- inv_pp_debug.send_long_to_pipe(l_pack_body_sql);

Line 13668: WHEN fnd_api.g_exc_error THEN

13664: -- end of debugging section
13665: log_procedure(l_api_name, 'end', 'End GenerateRulePackage');
13666: --
13667: EXCEPTION
13668: WHEN fnd_api.g_exc_error THEN
13669: --
13670: -- debugging portion
13671: -- can be commented ut for final code
13672: IF inv_pp_debug.is_debug_mode THEN

Line 13687: x_return_status := fnd_api.g_ret_sts_error;

13683: DBMS_SQL.close_cursor(l_cursor);
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

Line 13691: WHEN fnd_api.g_exc_unexpected_error THEN

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: --
13693: -- debugging portion
13694: -- can be commented ut for final code
13695: IF inv_pp_debug.is_debug_mode THEN

Line 13712: x_return_status := fnd_api.g_ret_sts_unexp_error;

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: --
13716: WHEN OTHERS THEN

Line 13741: x_return_status := fnd_api.g_ret_sts_unexp_error;

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);
13745: END IF;

Line 13794: x_return_status := fnd_api.g_ret_sts_success;

13790: l_api_name VARCHAR2(30) := 'assign_operation_plans';
13791: l_count NUMBER;
13792: BEGIN
13793: -- Initialize API return status to success
13794: x_return_status := fnd_api.g_ret_sts_success;
13795:
13796: -- Bug# 4587423
13797: -- See if there are any enabled rules for Operation Plan Selection.
13798: l_count := 0;

Line 13850: IF l_return_status <> fnd_api.g_ret_sts_success THEN

13846: x_msg_data => l_msg_data
13847: );
13848: end if;
13849:
13850: IF l_return_status <> fnd_api.g_ret_sts_success THEN
13851: x_return_status := fnd_api.g_ret_sts_error;
13852: END IF;
13853: END LOOP;
13854:

Line 13851: x_return_status := fnd_api.g_ret_sts_error;

13847: );
13848: end if;
13849:
13850: IF l_return_status <> fnd_api.g_ret_sts_success THEN
13851: x_return_status := fnd_api.g_ret_sts_error;
13852: END IF;
13853: END LOOP;
13854:
13855: CLOSE c_tasks;

Line 13875: x_return_status := fnd_api.g_ret_sts_unexp_error;

13871: END IF;
13872:
13873: EXCEPTION
13874: WHEN OTHERS THEN
13875: x_return_status := fnd_api.g_ret_sts_unexp_error;
13876: END assign_operation_plans;
13877:
13878: --
13879: -- API name : Assign Operation Plan

Line 13960: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

13956: BEGIN
13957: SAVEPOINT assign_operation_plan_sp;
13958:
13959: -- Standard call to check for call compatibility
13960: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
13961: RAISE fnd_api.g_exc_unexpected_error;
13962: END IF;
13963:
13964: -- Initialize message list if p_init_msg_list is set to TRUE

Line 13961: RAISE fnd_api.g_exc_unexpected_error;

13957: SAVEPOINT assign_operation_plan_sp;
13958:
13959: -- Standard call to check for call compatibility
13960: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
13961: RAISE fnd_api.g_exc_unexpected_error;
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

Line 13965: IF fnd_api.to_boolean(p_init_msg_list) THEN

13961: RAISE fnd_api.g_exc_unexpected_error;
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: --

Line 13971: x_return_status := fnd_api.g_ret_sts_success;

13967: END IF;
13968:
13969: --
13970: -- Initialize API return status to success
13971: x_return_status := fnd_api.g_ret_sts_success;
13972:
13973: -- Validate input parameters and pre-requisites, if validation level
13974: -- requires this
13975: IF p_validation_level <> fnd_api.g_valid_level_none THEN

Line 13975: IF p_validation_level <> fnd_api.g_valid_level_none THEN

13971: x_return_status := fnd_api.g_ret_sts_success;
13972:
13973: -- Validate input parameters and pre-requisites, if validation level
13974: -- requires this
13975: IF p_validation_level <> fnd_api.g_valid_level_none THEN
13976: -- in case further needs for validation
13977: NULL;
13978: END IF;
13979:

Line 13999: RAISE fnd_api.g_exc_unexpected_error;

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
14001: EXIT;
14002: END IF;
14003: END LOOP;

Line 14018: WHEN fnd_api.g_exc_error THEN

14014:
14015: EXIT; -- operation plan assigned, jump out of the rule loop
14016: END IF; -- l_return_status > 0
14017: EXCEPTION -- handle exceptions for matching one rule
14018: WHEN fnd_api.g_exc_error THEN
14019: NULL;
14020: WHEN OTHERS THEN
14021: NULL;
14022: END; -- end matching one rule

Line 14061: IF fnd_api.to_boolean(p_commit) THEN

14057: WHERE mmtt.transaction_temp_id = p_task_id;
14058: END IF;
14059:
14060: -- Standard check of p_commit
14061: IF fnd_api.to_boolean(p_commit) THEN
14062: COMMIT WORK;
14063: END IF;
14064: EXCEPTION
14065: WHEN fnd_api.g_exc_error THEN

Line 14065: WHEN fnd_api.g_exc_error THEN

14061: IF fnd_api.to_boolean(p_commit) THEN
14062: COMMIT WORK;
14063: END IF;
14064: EXCEPTION
14065: WHEN fnd_api.g_exc_error THEN
14066: -- if the rule package not created yet, close the rule cursor
14067: IF c_rules%ISOPEN THEN
14068: CLOSE c_rules;
14069: END IF;

Line 14073: x_return_status := fnd_api.g_ret_sts_error;

14069: END IF;
14070:
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;

Line 14083: x_return_status := fnd_api.g_ret_sts_unexp_error;

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;
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;

Line 14141: x_return_status := fnd_api.g_ret_sts_success;

14137: l_api_name VARCHAR2(30) := 'assignTTs';
14138: l_count NUMBER;
14139: BEGIN
14140: -- Initialize API return status to success
14141: x_return_status := fnd_api.g_ret_sts_success;
14142:
14143: -- Bug# 4587423
14144: -- See if there are any enabled rules for Task Type Assignment for
14145: -- all orgs or for the orgs in the set of MMTT records for the given move order header.

Line 14183: IF l_return_status <> fnd_api.g_ret_sts_success THEN

14179: x_msg_count => l_msg_count,
14180: x_msg_data => l_msg_data
14181: );
14182:
14183: IF l_return_status <> fnd_api.g_ret_sts_success THEN
14184: x_return_status := fnd_api.g_ret_sts_error;
14185: END IF;
14186: END LOOP;
14187:

Line 14184: x_return_status := fnd_api.g_ret_sts_error;

14180: x_msg_data => l_msg_data
14181: );
14182:
14183: IF l_return_status <> fnd_api.g_ret_sts_success THEN
14184: x_return_status := fnd_api.g_ret_sts_error;
14185: END IF;
14186: END LOOP;
14187:
14188: CLOSE c_tasks;

Line 14211: x_return_status := fnd_api.g_ret_sts_unexp_error;

14207: END IF;
14208:
14209: EXCEPTION
14210: WHEN OTHERS THEN
14211: x_return_status := fnd_api.g_ret_sts_unexp_error;
14212: END assigntts;
14213:
14214: --
14215: -- API name : AssignTT

Line 14341: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

14337: END IF;
14338: l_debug := g_debug;
14339:
14340: -- Standard call to check for call compatibility
14341: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
14342: RAISE fnd_api.g_exc_unexpected_error;
14343: END IF;
14344:
14345: -- Initialize message list if p_init_msg_list is set to TRUE

Line 14342: RAISE fnd_api.g_exc_unexpected_error;

14338: l_debug := g_debug;
14339:
14340: -- Standard call to check for call compatibility
14341: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
14342: RAISE fnd_api.g_exc_unexpected_error;
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

Line 14346: IF fnd_api.to_boolean(p_init_msg_list) THEN

14342: RAISE fnd_api.g_exc_unexpected_error;
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: --

Line 14352: x_return_status := fnd_api.g_ret_sts_success;

14348: END IF;
14349:
14350: --
14351: -- Initialize API return status to success
14352: x_return_status := fnd_api.g_ret_sts_success;
14353:
14354: -- Validate input parameters and pre-requisites, if validation level
14355: -- requires this
14356: IF p_validation_level <> fnd_api.g_valid_level_none THEN

Line 14356: IF p_validation_level <> fnd_api.g_valid_level_none THEN

14352: x_return_status := fnd_api.g_ret_sts_success;
14353:
14354: -- Validate input parameters and pre-requisites, if validation level
14355: -- requires this
14356: IF p_validation_level <> fnd_api.g_valid_level_none THEN
14357: -- in case further needs for validation
14358: NULL;
14359: END IF;
14360:

Line 14391: RAISE fnd_api.g_exc_unexpected_error;

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;
14391: RAISE fnd_api.g_exc_unexpected_error;
14392: ELSIF l_return_status <> -1 THEN
14393: EXIT;
14394: END IF;
14395: END LOOP;

Line 14419: WHEN fnd_api.g_exc_error THEN

14415:
14416: EXIT; -- task assigned, jump out of the rule loop
14417: END IF; -- l_return_status > 0
14418: EXCEPTION -- handle exceptions for matching one rule
14419: WHEN fnd_api.g_exc_error THEN
14420: NULL;
14421: WHEN OTHERS THEN
14422: NULL;
14423: END; -- end matching one rule

Line 14506: IF fnd_api.to_boolean(p_commit) THEN

14502: --inv_log_util.TRACE('after update statement: standard_operation_id:'||jxlu_soi, 'RULE_ENGINE', 4);
14503: END IF;
14504:
14505: -- Standard check of p_commit
14506: IF fnd_api.to_boolean(p_commit) THEN
14507: COMMIT WORK;
14508: END IF;
14509: EXCEPTION
14510: WHEN fnd_api.g_exc_error THEN

Line 14510: WHEN fnd_api.g_exc_error THEN

14506: IF fnd_api.to_boolean(p_commit) THEN
14507: COMMIT WORK;
14508: END IF;
14509: EXCEPTION
14510: WHEN fnd_api.g_exc_error THEN
14511: -- if the rule package not created yet, close the rule cursor
14512: IF c_rules%ISOPEN THEN
14513: CLOSE c_rules;
14514: END IF;

Line 14518: x_return_status := fnd_api.g_ret_sts_error;

14514: END IF;
14515:
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;

Line 14528: x_return_status := fnd_api.g_ret_sts_unexp_error;

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;
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;

Line 14700: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

14696: TRACE('Number of rules to process(LL_CTR) :' || ll_ctr);
14697: END IF;
14698:
14699: -- Standard call to check for call compatibility
14700: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
14701: RAISE fnd_api.g_exc_unexpected_error;
14702: END IF;
14703:
14704: -- Initialize message list if p_init_msg_list is set to TRUE

Line 14701: RAISE fnd_api.g_exc_unexpected_error;

14697: END IF;
14698:
14699: -- Standard call to check for call compatibility
14700: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
14701: RAISE fnd_api.g_exc_unexpected_error;
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

Line 14705: IF fnd_api.to_boolean(p_init_msg_list) THEN

14701: RAISE fnd_api.g_exc_unexpected_error;
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: --

Line 14711: x_return_status := fnd_api.g_ret_sts_success;

14707: END IF;
14708:
14709: --
14710: -- Initialize API return status to success
14711: x_return_status := fnd_api.g_ret_sts_success;
14712:
14713: -- Validate input parameters and pre-requisites, if validation level
14714: -- requires this
14715: IF p_validation_level <> fnd_api.g_valid_level_none THEN

Line 14715: IF p_validation_level <> fnd_api.g_valid_level_none THEN

14711: x_return_status := fnd_api.g_ret_sts_success;
14712:
14713: -- Validate input parameters and pre-requisites, if validation level
14714: -- requires this
14715: IF p_validation_level <> fnd_api.g_valid_level_none THEN
14716: -- in case further needs for validation
14717: NULL;
14718: END IF;
14719:

Line 14733: RAISE fnd_api.g_exc_error;

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;
14737:

Line 14770: RAISE fnd_api.g_exc_unexpected_error;

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;
14770: RAISE fnd_api.g_exc_unexpected_error;
14771: ELSIF l_return_status <> -1 THEN
14772: EXIT;
14773: END IF;
14774: END LOOP;

Line 14841: IF fnd_api.to_boolean(p_commit) THEN

14837: x_label_format_id := l_label_format_id;
14838: x_label_format_name := l_label_format_name;
14839:
14840: -- Standard check of p_commit
14841: IF fnd_api.to_boolean(p_commit) THEN
14842: COMMIT WORK;
14843: END IF;
14844: EXCEPTION
14845: WHEN fnd_api.g_exc_error THEN

Line 14845: WHEN fnd_api.g_exc_error THEN

14841: IF fnd_api.to_boolean(p_commit) THEN
14842: COMMIT WORK;
14843: END IF;
14844: EXCEPTION
14845: WHEN fnd_api.g_exc_error THEN
14846: -- if the rule package not created yet, close the rule cursor
14847: IF c_rules%ISOPEN THEN
14848: CLOSE c_rules;
14849: END IF;

Line 14853: x_return_status := fnd_api.g_ret_sts_error;

14849: 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

Line 14862: x_return_status := fnd_api.g_ret_sts_unexp_error;

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(

Line 14921: , p_init_msg_list => fnd_api.g_true

14917: EXIT WHEN l_enabled_rules%NOTFOUND;
14918: --fnd_file.put_line(fnd_file.LOG, 'Compiling Rule ID= ' || l_rule_id);
14919: wms_rule_pvt.generaterulepackage(
14920: p_api_version => 1.0
14921: , p_init_msg_list => fnd_api.g_true
14922: , p_validation_level => fnd_api.g_valid_level_full
14923: , x_return_status => l_return_status
14924: , x_msg_count => l_msg_count
14925: , x_msg_data => l_msg_data

Line 14922: , p_validation_level => fnd_api.g_valid_level_full

14918: --fnd_file.put_line(fnd_file.LOG, 'Compiling Rule ID= ' || l_rule_id);
14919: wms_rule_pvt.generaterulepackage(
14920: p_api_version => 1.0
14921: , p_init_msg_list => fnd_api.g_true
14922: , p_validation_level => fnd_api.g_valid_level_full
14923: , x_return_status => l_return_status
14924: , x_msg_count => l_msg_count
14925: , x_msg_data => l_msg_data
14926: , p_rule_id => l_rule_id

Line 14931: -- Used FND APIs to check the return status of the called procedure

14927: );
14928:
14929: --
14930: -- kkoothan Bug Fix:2561401
14931: -- Used FND APIs to check the return status of the called procedure
14932: -- instead of using hard coded values.
14933: --
14934: IF (l_return_status = fnd_api.g_ret_sts_success) THEN
14935: FND_FILE.put_line(FND_FILE.LOG, 'Success from GenerateRulePackage');

Line 14934: IF (l_return_status = fnd_api.g_ret_sts_success) THEN

14930: -- kkoothan Bug Fix:2561401
14931: -- Used FND APIs to check the return status of the called procedure
14932: -- instead of using hard coded values.
14933: --
14934: IF (l_return_status = fnd_api.g_ret_sts_success) THEN
14935: FND_FILE.put_line(FND_FILE.LOG, 'Success from GenerateRulePackage');
14936: ELSE
14937: FND_FILE.put_line(FND_FILE.LOG, 'Error from GenerateRulePackage:');
14938: retcode := 1;

Line 14954: IF (l_return_status = fnd_api.g_ret_sts_success) THEN

14950: --- Calling procedure to generate all rule list packages
14951: --- this package should be called stand alone .
14952: buildrulespkg(l_errbuf, l_return_code, l_return_status);
14953:
14954: IF (l_return_status = fnd_api.g_ret_sts_success) THEN
14955: FND_FILE.put_line(FND_FILE.LOG, 'Success from BuildRulesPkg');
14956: ELSE
14957: FND_FILE.put_line(FND_FILE.LOG, 'Error from BuildRulesPkg:');
14958: retcode := 1;

Line 14984: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false ,

14980: --
14981: --
14982: PROCEDURE QuickPick
14983: (p_api_version IN NUMBER ,
14984: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false ,
14985: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false ,
14986: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full ,
14987: x_return_status OUT NOCOPY VARCHAR2 ,
14988: x_msg_count OUT NOCOPY NUMBER ,

Line 14985: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false ,

14981: --
14982: PROCEDURE QuickPick
14983: (p_api_version IN NUMBER ,
14984: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false ,
14985: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false ,
14986: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full ,
14987: x_return_status OUT NOCOPY VARCHAR2 ,
14988: x_msg_count OUT NOCOPY NUMBER ,
14989: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 14986: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full ,

14982: PROCEDURE QuickPick
14983: (p_api_version IN NUMBER ,
14984: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false ,
14985: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false ,
14986: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full ,
14987: x_return_status OUT NOCOPY VARCHAR2 ,
14988: x_msg_count OUT NOCOPY NUMBER ,
14989: x_msg_data OUT NOCOPY VARCHAR2 ,
14990: p_type_code IN NUMBER DEFAULT NULL ,

Line 15123: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

15119: -- Standard start of API savepoint
15120: SAVEPOINT QuickPicksp;
15121:
15122: -- Standard call to check for call compatibility
15123: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
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

Line 15124: RAISE fnd_api.g_exc_unexpected_error;

15120: SAVEPOINT QuickPicksp;
15121:
15122: -- Standard call to check for call compatibility
15123: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
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;

Line 15127: IF fnd_api.to_boolean(p_init_msg_list) THEN

15123: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
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;

Line 15131: x_return_status := fnd_api.g_ret_sts_success;

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
15133: x_finished := fnd_api.g_true;
15134: -- Validate input parameters and pre-requisites, if validation level
15135: -- requires this

Line 15133: x_finished := fnd_api.g_true;

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
15133: x_finished := fnd_api.g_true;
15134: -- Validate input parameters and pre-requisites, if validation level
15135: -- requires this
15136:
15137: IF p_validation_level <> fnd_api.g_valid_level_none THEN

Line 15137: IF p_validation_level <> fnd_api.g_valid_level_none THEN

15133: x_finished := fnd_api.g_true;
15134: -- Validate input parameters and pre-requisites, if validation level
15135: -- requires this
15136:
15137: IF p_validation_level <> fnd_api.g_valid_level_none THEN
15138: IF l_debug = 1 THEN
15139: log_statement(l_api_name, 'Quick Pick',
15140: 'p_validation_level <> fnd_api.g_valid_level_none ');
15141: END IF;

Line 15140: 'p_validation_level <> fnd_api.g_valid_level_none ');

15136:
15137: IF p_validation_level <> fnd_api.g_valid_level_none THEN
15138: IF l_debug = 1 THEN
15139: log_statement(l_api_name, 'Quick Pick',
15140: 'p_validation_level <> fnd_api.g_valid_level_none ');
15141: END IF;
15142:
15143: IF p_type_code IS NULL
15144: OR p_type_code = fnd_api.g_miss_num

Line 15144: OR p_type_code = fnd_api.g_miss_num

15140: 'p_validation_level <> fnd_api.g_valid_level_none ');
15141: END IF;
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');

Line 15151: RAISE fnd_api.g_exc_error;

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:
15154: IF l_debug = 1 THEN
15155: log_statement(l_api_name, 'Quick Pick',

Line 15160: OR p_transaction_temp_id = fnd_api.g_miss_num THEN

15156: 'p_transaction_temp_id ' || p_transaction_temp_id );
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;

Line 15167: RAISE fnd_api.g_exc_error;

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;
15169:
15170: IF l_debug = 1 THEN
15171: log_statement(l_api_name, 'Quick Pick',

Line 15176: OR p_organization_id = fnd_api.g_miss_num THEN

15172: 'p_organization_id ' || p_organization_id );
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;

Line 15183: RAISE fnd_api.g_exc_error;

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;
15185:
15186: IF l_debug = 1 THEN
15187: log_statement(l_api_name, 'Quick Pick',

Line 15192: OR p_inventory_item_id = fnd_api.g_miss_num THEN

15188: 'p_Inventory_item_id_id ' || p_inventory_item_id );
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;

Line 15199: RAISE fnd_api.g_exc_error;

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;
15201:
15202: /** Commented for bug 4006426
15203: IF l_debug = 1 THEN

Line 15208: OR p_tree_id = fnd_api.g_miss_num

15204: log_statement(l_api_name, 'Quick Pick', 'qty Tree =>' || p_tree_id );
15205: 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');

Line 15216: RAISE fnd_api.g_exc_error;

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;
15218:
15219: IF l_debug = 1 THEN
15220: log_statement(l_api_name, 'Quick Pick', 'finished validations and qty tree init' );

Line 15241: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

15237: END IF;
15238:
15239: inv_quantity_tree_pvt.backup_tree(x_return_status, p_tree_id);
15240:
15241: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
15242: IF l_debug = 1 THEN
15243: log_statement(l_api_name, 'backup_tree_unexp_err',
15244: 'Unexpected error from inv_quantity_tree_pvt.backup_tree');
15245: END IF;

Line 15246: RAISE fnd_api.g_exc_unexpected_error;

15242: IF l_debug = 1 THEN
15243: log_statement(l_api_name, 'backup_tree_unexp_err',
15244: 'Unexpected error from inv_quantity_tree_pvt.backup_tree');
15245: END IF;
15246: RAISE fnd_api.g_exc_unexpected_error;
15247: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
15248: IF l_debug = 1 THEN
15249: log_statement(l_api_name, 'backup_tree_err',
15250: 'Error from inv_quantity_tree_pvt.backup_tree');

Line 15247: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

15243: log_statement(l_api_name, 'backup_tree_unexp_err',
15244: 'Unexpected error from inv_quantity_tree_pvt.backup_tree');
15245: END IF;
15246: RAISE fnd_api.g_exc_unexpected_error;
15247: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
15248: IF l_debug = 1 THEN
15249: log_statement(l_api_name, 'backup_tree_err',
15250: 'Error from inv_quantity_tree_pvt.backup_tree');
15251: END IF;

Line 15252: RAISE fnd_api.g_exc_error;

15248: IF l_debug = 1 THEN
15249: log_statement(l_api_name, 'backup_tree_err',
15250: 'Error from inv_quantity_tree_pvt.backup_tree');
15251: END IF;
15252: RAISE fnd_api.g_exc_error;
15253: END IF;
15254: END IF; --- Added for bug # 4006426
15255:
15256: g_locs_index := 0;

Line 15536: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

15532: , x_remaining_quantity => l_remaining_quantity
15533: );
15534: END IF;
15535:
15536: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
15537: IF l_debug = 1 THEN
15538: log_statement(l_api_name, 'uerr_validate_insert',
15539: 'Unexpected error in validate_and_insert');
15540: END IF;

Line 15541: RAISE fnd_api.g_exc_unexpected_error;

15537: IF l_debug = 1 THEN
15538: log_statement(l_api_name, 'uerr_validate_insert',
15539: 'Unexpected error in validate_and_insert');
15540: END IF;
15541: RAISE fnd_api.g_exc_unexpected_error;
15542: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
15543: IF l_debug = 1 THEN
15544: log_statement(l_api_name, 'err_validate_insert', 'Error in validate_and_insert');
15545: END IF;

Line 15542: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

15538: log_statement(l_api_name, 'uerr_validate_insert',
15539: 'Unexpected error in validate_and_insert');
15540: END IF;
15541: RAISE fnd_api.g_exc_unexpected_error;
15542: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
15543: IF l_debug = 1 THEN
15544: log_statement(l_api_name, 'err_validate_insert', 'Error in validate_and_insert');
15545: END IF;
15546: RAISE fnd_api.g_exc_error;

Line 15546: RAISE fnd_api.g_exc_error;

15542: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
15543: IF l_debug = 1 THEN
15544: log_statement(l_api_name, 'err_validate_insert', 'Error in validate_and_insert');
15545: END IF;
15546: RAISE fnd_api.g_exc_error;
15547: END IF;
15548:
15549: IF l_inserted_record = FALSE OR l_allocated_quantity < l_needed_quantity THEN
15550: fnd_message.set_name('WMS', 'WMS_LPN_UNAVAILABLE'); --- to be Added to Mesg Dict

Line 15568: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

15564: inv_quantity_tree_pvt.restore_tree(x_return_status => x_return_status, p_tree_id => p_tree_id);
15565: END IF; -- Bug # 4006426
15566: END IF;
15567:
15568: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
15569: IF l_debug = 1 THEN
15570: log_error(l_api_name, 'uerr_restore_tree', 'Unexpected error in restore_tree');
15571: END IF;
15572: RAISE fnd_api.g_exc_unexpected_error;

Line 15572: RAISE fnd_api.g_exc_unexpected_error;

15568: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
15569: IF l_debug = 1 THEN
15570: log_error(l_api_name, 'uerr_restore_tree', 'Unexpected error in restore_tree');
15571: END IF;
15572: RAISE fnd_api.g_exc_unexpected_error;
15573: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
15574: IF l_debug = 1 THEN
15575: log_error(l_api_name, 'err_restore_tree', 'Error in restore_tree');
15576: END IF;

Line 15573: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

15569: IF l_debug = 1 THEN
15570: log_error(l_api_name, 'uerr_restore_tree', 'Unexpected error in restore_tree');
15571: END IF;
15572: RAISE fnd_api.g_exc_unexpected_error;
15573: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
15574: IF l_debug = 1 THEN
15575: log_error(l_api_name, 'err_restore_tree', 'Error in restore_tree');
15576: END IF;
15577: RAISE fnd_api.g_exc_error;

Line 15577: RAISE fnd_api.g_exc_error;

15573: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
15574: IF l_debug = 1 THEN
15575: log_error(l_api_name, 'err_restore_tree', 'Error in restore_tree');
15576: END IF;
15577: RAISE fnd_api.g_exc_error;
15578: END IF;
15579: ELSE
15580:
15581: IF ( l_allowed = 'N') then

Line 15608: WHEN fnd_api.g_exc_error THEN

15604: l_cur_rec := g_locs(l_cur_rec).next_rec;
15605:
15606: END LOOP;
15607: EXCEPTION
15608: WHEN fnd_api.g_exc_error THEN
15609:
15610: ROLLBACK TO QuickPicksp;
15611: freeglobals;
15612: x_return_status := fnd_api.g_ret_sts_error;

Line 15612: x_return_status := fnd_api.g_ret_sts_error;

15608: WHEN fnd_api.g_exc_error THEN
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);

Line 15619: WHEN fnd_api.g_exc_unexpected_error THEN

15615: IF l_debug = 1 THEN
15616: log_error(l_api_name, 'error', 'Expected error - ' || x_msg_data);
15617: END IF;
15618:
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);

Line 15622: x_return_status := fnd_api.g_ret_sts_unexp_error;

15618:
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);

Line 15632: x_return_status := fnd_api.g_ret_sts_unexp_error;

15628:
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);

Line 15939: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

15935: -- Standard start of API savepoint
15936: SAVEPOINT applyrulesp;
15937:
15938: -- Standard call to check for call compatibility
15939: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
15940: RAISE fnd_api.g_exc_unexpected_error;
15941: END IF;
15942:
15943: -- Initialize message list if p_init_msg_list is set to TRUE

Line 15940: RAISE fnd_api.g_exc_unexpected_error;

15936: SAVEPOINT applyrulesp;
15937:
15938: -- Standard call to check for call compatibility
15939: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
15940: RAISE fnd_api.g_exc_unexpected_error;
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

Line 15944: IF fnd_api.to_boolean(p_init_msg_list) THEN

15940: RAISE fnd_api.g_exc_unexpected_error;
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: --

Line 15950: x_return_status := fnd_api.g_ret_sts_success;

15946: END IF;
15947:
15948: --
15949: -- Initialize API return status to success
15950: x_return_status := fnd_api.g_ret_sts_success;
15951: --
15952: -- Initialize functional return status to completed
15953: x_finished := fnd_api.g_true;
15954:

Line 15953: x_finished := fnd_api.g_true;

15949: -- Initialize API return status to success
15950: x_return_status := fnd_api.g_ret_sts_success;
15951: --
15952: -- Initialize functional return status to completed
15953: x_finished := fnd_api.g_true;
15954:
15955: --
15956: -- Validate input parameters and pre-requisites, if validation level
15957: -- requires this

Line 15958: IF p_validation_level <> fnd_api.g_valid_level_none THEN

15954:
15955: --
15956: -- Validate input parameters and pre-requisites, if validation level
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');

Line 15960: OR p_type_code = fnd_api.g_miss_num THEN

15956: -- Validate input parameters and pre-requisites, if validation level
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

Line 15968: RAISE fnd_api.g_exc_error;

15964: IF l_debug = 1 THEN
15965: log_error_msg(l_api_name, 'type_code_missing');
15966: END IF;
15967: END IF;
15968: RAISE fnd_api.g_exc_error;
15969: END IF;
15970:
15971: -- init variables
15972: l_revision := null;

Line 15979: IF p_rule_id IS NULL OR p_rule_id = fnd_api.g_miss_num THEN

15975:
15976: --changed by jcearley on 11/22/99, b/c a null rule_id is now allowed
15977: -- if rule_id is null, use default rule (0 for put away, 1 for pick)
15978:
15979: IF p_rule_id IS NULL OR p_rule_id = fnd_api.g_miss_num THEN
15980: --query org parameters to get user's default rule
15981: IF l_debug = 1 THEN
15982: log_statement(l_api_name,'no_rule','Getting default rule at org level');
15983: END IF;

Line 16029: OR p_partial_success_allowed_flag = fnd_api.g_miss_char THEN

16025: 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

Line 16039: RAISE fnd_api.g_exc_error;

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

Line 16044: OR p_transaction_temp_id = fnd_api.g_miss_num THEN

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

Line 16054: RAISE fnd_api.g_exc_error;

16050: END IF;
16051:
16052: END IF;
16053:
16054: RAISE fnd_api.g_exc_error;
16055: END IF;
16056:
16057: IF p_organization_id IS NULL
16058: OR p_organization_id = fnd_api.g_miss_num THEN

Line 16058: OR p_organization_id = fnd_api.g_miss_num THEN

16054: RAISE fnd_api.g_exc_error;
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

Line 16067: RAISE fnd_api.g_exc_error;

16063: log_error_msg(l_api_name, 'org_id_missing');
16064: END IF;
16065: END IF;
16066:
16067: RAISE fnd_api.g_exc_error;
16068: END IF;
16069:
16070: IF p_inventory_item_id IS NULL
16071: OR p_inventory_item_id = fnd_api.g_miss_num THEN

Line 16071: OR p_inventory_item_id = fnd_api.g_miss_num THEN

16067: RAISE fnd_api.g_exc_error;
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

Line 16080: RAISE fnd_api.g_exc_error;

16076: log_error_msg(l_api_name, 'item_id_missing');
16077: END IF;
16078: END IF;
16079:
16080: RAISE fnd_api.g_exc_error;
16081: END IF;
16082:
16083: IF p_type_code = 2
16084: AND (p_tree_id IS NULL

Line 16085: OR p_tree_id = fnd_api.g_miss_num

16081: END IF;
16082:
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;

Line 16096: RAISE fnd_api.g_exc_error;

16092: log_error_msg(l_api_name, 'qty_tree_id_missing');
16093: END IF;
16094: END IF;
16095:
16096: RAISE fnd_api.g_exc_error;
16097: END IF;
16098: END IF;
16099:
16100: --inv_pp_debug.send_message_to_pipe('finished validations and qty tree init');

Line 16111: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

16107: 'Calling inv_quantity_tree_pvt.backup_tree');
16108: END IF;
16109: inv_quantity_tree_pvt.backup_tree(x_return_status, p_tree_id);
16110:
16111: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
16112: IF l_debug = 1 THEN
16113: log_statement(l_api_name, 'backup_tree_unexp_err',
16114: 'Unexpected error from inv_quantity_tree_pvt.backup_tree');
16115: END IF;

Line 16117: RAISE fnd_api.g_exc_unexpected_error;

16113: log_statement(l_api_name, 'backup_tree_unexp_err',
16114: 'Unexpected error from inv_quantity_tree_pvt.backup_tree');
16115: END IF;
16116:
16117: RAISE fnd_api.g_exc_unexpected_error;
16118: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
16119: IF l_debug = 1 THEN
16120: log_statement(l_api_name, 'backup_tree_err',
16121: 'Error from inv_quantity_tree_pvt.backup_tree');

Line 16118: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

16114: 'Unexpected error from inv_quantity_tree_pvt.backup_tree');
16115: END IF;
16116:
16117: RAISE fnd_api.g_exc_unexpected_error;
16118: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
16119: IF l_debug = 1 THEN
16120: log_statement(l_api_name, 'backup_tree_err',
16121: 'Error from inv_quantity_tree_pvt.backup_tree');
16122: END IF;

Line 16123: RAISE fnd_api.g_exc_error;

16119: IF l_debug = 1 THEN
16120: log_statement(l_api_name, 'backup_tree_err',
16121: 'Error from inv_quantity_tree_pvt.backup_tree');
16122: END IF;
16123: RAISE fnd_api.g_exc_error;
16124: END IF;
16125:
16126: --does the rule have any consistency restrictions?
16127: OPEN l_consist;

Line 16447: x_return_status := fnd_api.g_ret_sts_unexp_error;

16443: */
16444: END IF;
16445: EXCEPTION
16446: /*WHEN INVALID_PKG_STATE THEN
16447: x_return_status := fnd_api.g_ret_sts_unexp_error;
16448: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');
16449: fnd_message.set_token('LIST_PKG', l_list_pkg);
16450: fnd_message.set_token('RULE_NAME', l_package_name);
16451: fnd_msg_pub.ADD;

Line 16456: x_return_status := fnd_api.g_ret_sts_unexp_error;

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
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;

Line 16501: x_return_status := fnd_api.g_ret_sts_success;

16497:
16498:
16499: BEGIN
16500: -- Initialize API return status to success
16501: x_return_status := fnd_api.g_ret_sts_success;
16502:
16503: --
16504: -- debugging portion
16505: -- can be commented ut for final code

Line 16558: x_return_status := fnd_api.g_ret_sts_unexp_error;

16554: log_procedure(l_api_name, 'end', 'End FetchCursorrows');
16555: --
16556: EXCEPTION
16557: WHEN INVALID_PKG_STATE THEN
16558: x_return_status := fnd_api.g_ret_sts_unexp_error;
16559: fnd_message.set_name('WMS', 'WMS_INVALID_PKG');
16560: fnd_message.set_token('LIST_PKG', l_list_pkg);
16561: fnd_message.set_token('RULE_NAME', l_package_name);
16562: fnd_msg_pub.ADD;

Line 16567: x_return_status := fnd_api.g_ret_sts_unexp_error;

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
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;