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.INV_DETAIL_UTIL_PVT dependencies on FND_API

Line 221: x_return_status := fnd_api.g_ret_sts_success;

217: inv_pp_debug.send_message_to_pipe('enter '||g_pkg_name||'.'||l_api_name);
218: END IF;
219: -- end of debugging section
220: --
221: x_return_status := fnd_api.g_ret_sts_success;
222: -- get the request record
223: print_debug('in context ');
224: OPEN l_req_csr;
225: BEGIN

Line 251: RAISE fnd_api.g_exc_error;

247: fnd_message.set_token
248: ('LINE_ID',fnd_number.number_to_canonical(p_move_order_line_id));
249: fnd_msg_pub.ADD;
250: CLOSE l_req_csr;
251: RAISE fnd_api.g_exc_error;
252: END IF;
253: CLOSE l_req_csr;
254: print_debug('init request_context');
255: -- initialize x_request_context

Line 458: RAISE fnd_api.g_exc_unexpected_error;

454: inv_salesorder.get_salesorder_for_oeheader(x_request_context.txn_header_id);
455: IF x_request_context.txn_header_id IS NULL THEN
456: FND_MESSAGE.SET_NAME('INV','INV_COULD_NOT_GET_MSO_HEADER');
457: FND_MSG_PUB.Add;
458: RAISE fnd_api.g_exc_unexpected_error;
459: END IF;
460: --
461: --bug 1248138
462: --not sure why this is happening, but it probably shouldn't be, so

Line 503: RAISE fnd_api.g_exc_unexpected_error;

499: inv_salesorder.get_salesorder_for_oeheader(x_request_context.txn_header_id);
500: IF x_request_context.txn_header_id IS NULL THEN
501: FND_MESSAGE.SET_NAME('INV','INV_COULD_NOT_GET_MSO_HEADER');
502: FND_MSG_PUB.Add;
503: RAISE fnd_api.g_exc_unexpected_error;
504: END IF;
505: END IF;
506:
507: -- Bug 2027368

Line 714: WHEN fnd_api.g_exc_error THEN

710: END IF;
711: -- end of debugging section
712: --
713: EXCEPTION
714: WHEN fnd_api.g_exc_error THEN
715: --
716: -- debugging section
717: -- can be commented ut for final code
718: IF inv_pp_debug.is_debug_mode THEN

Line 727: x_return_status := fnd_api.g_ret_sts_error;

723: inv_pp_debug.send_last_error_message;
724: END IF;
725: -- end of debugging section
726: --
727: x_return_status := fnd_api.g_ret_sts_error;
728: IF l_req_csr%isopen THEN
729: CLOSE l_req_csr;
730: END IF;
731: /*IF l_context_csr%isopen THEN

Line 738: WHEN fnd_api.g_exc_unexpected_error THEN

734: IF l_ship_info_csr%isopen THEN
735: CLOSE l_ship_info_csr;
736: END IF;
737: --
738: WHEN fnd_api.g_exc_unexpected_error THEN
739: --
740: -- debugging section
741: -- can be commented ut for final code
742: IF inv_pp_debug.is_debug_mode THEN

Line 751: x_return_status := fnd_api.g_ret_sts_unexp_error;

747: inv_pp_debug.send_last_error_message;
748: END IF;
749: -- end of debugging section
750: --
751: x_return_status := fnd_api.g_ret_sts_unexp_error;
752: IF l_req_csr%isopen THEN
753: CLOSE l_req_csr;
754: END IF;
755: /*IF l_context_csr%isopen THEN

Line 775: x_return_status := fnd_api.g_ret_sts_unexp_error;

771: inv_pp_debug.send_last_error_message;
772: END IF;
773: -- end of debugging section
774: --
775: x_return_status := fnd_api.g_ret_sts_unexp_error;
776: IF l_req_csr%isopen THEN
777: CLOSE l_req_csr;
778: END IF;
779: /*IF l_context_csr%isopen THEN

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

799: x_detail_level_tbl_size OUT NOCOPY NUMBER ,
800: x_remaining_quantity OUT NOCOPY NUMBER
801: )
802: IS
803: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
804: l_api_name VARCHAR2(30) := 'compute_pick_detail_level';
805: l_remain_pri_qty NUMBER;
806: l_remain_sec_qty NUMBER;
807: l_pp_temp_qty NUMBER;

Line 998: when fnd_api.g_exc_error then

994: inv_pp_debug.send_message_to_pipe('exit '||g_pkg_name||'.'||l_api_name);
995: END IF;
996: --
997: EXCEPTION
998: when fnd_api.g_exc_error then
999: x_return_status := fnd_api.g_ret_sts_error ;
1000: --
1001: when fnd_api.g_exc_unexpected_error then
1002: x_return_status := fnd_api.g_ret_sts_unexp_error ;

Line 999: x_return_status := fnd_api.g_ret_sts_error ;

995: END IF;
996: --
997: EXCEPTION
998: when fnd_api.g_exc_error then
999: x_return_status := fnd_api.g_ret_sts_error ;
1000: --
1001: when fnd_api.g_exc_unexpected_error then
1002: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1003: --

Line 1001: when fnd_api.g_exc_unexpected_error then

997: EXCEPTION
998: when fnd_api.g_exc_error then
999: x_return_status := fnd_api.g_ret_sts_error ;
1000: --
1001: when fnd_api.g_exc_unexpected_error then
1002: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1003: --
1004: when others then
1005: x_return_status := fnd_api.g_ret_sts_unexp_error ;

Line 1002: x_return_status := fnd_api.g_ret_sts_unexp_error ;

998: when fnd_api.g_exc_error then
999: x_return_status := fnd_api.g_ret_sts_error ;
1000: --
1001: when fnd_api.g_exc_unexpected_error then
1002: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1003: --
1004: when others then
1005: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1006: if (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)) THEN

Line 1005: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1001: when fnd_api.g_exc_unexpected_error then
1002: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1003: --
1004: when others then
1005: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1006: if (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)) THEN
1007: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1008: end if;
1009: --

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

1016: x_request_line_rec OUT NOCOPY g_request_line_rec_type,
1017: x_request_context OUT NOCOPY g_request_context_rec_type
1018: )
1019: IS
1020: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
1021: l_api_name VARCHAR2(30) := 'validate_and_init';
1022: BEGIN
1023: --
1024: IF inv_pp_debug.is_debug_mode THEN

Line 1033: RAISE fnd_api.g_exc_error;

1029: print_debug('in inv validate and init');
1030: IF p_request_line_id IS NULL THEN
1031: fnd_message.set_name('INV','INV_PP_TRX_REQ_LINE_ID_MISS');
1032: fnd_msg_pub.add;
1033: RAISE fnd_api.g_exc_error;
1034: END IF;
1035: --
1036: -- get request context
1037: print_debug('before context ');

Line 1043: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1039: p_request_line_id,
1040: x_request_context,
1041: x_request_line_rec
1042: );
1043: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1044: RAISE fnd_api.g_exc_error;
1045: END IF;
1046: --
1047: -- check whether quantity to detail is >0, if not, return

Line 1044: RAISE fnd_api.g_exc_error;

1040: x_request_context,
1041: x_request_line_rec
1042: );
1043: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1044: RAISE fnd_api.g_exc_error;
1045: END IF;
1046: --
1047: -- check whether quantity to detail is >0, if not, return
1048: IF x_request_line_rec.quantity IS NOT NULL

Line 1069: IF p_suggest_serial = fnd_api.g_true AND

1065: -- in the get_request_context procedure.
1066: --x_request_context.detail_any_serial :=
1067: -- to_number(fnd_profile.value('INV:DETAIL_SERIAL_NUMBERS'));
1068:
1069: IF p_suggest_serial = fnd_api.g_true AND
1070: x_request_context.item_serial_control_code NOT IN (1,6) AND
1071: (x_request_context.detail_any_serial = 1 OR
1072: (x_request_line_rec.serial_number_start IS NOT NULL AND
1073: x_request_line_rec.serial_number_end IS NOT NULL)) THEN

Line 1091: when fnd_api.g_exc_error then

1087: inv_pp_debug.send_message_to_pipe('exit '||g_pkg_name||'.'||l_api_name);
1088: END IF;
1089: --
1090: EXCEPTION
1091: when fnd_api.g_exc_error then
1092: x_return_status := fnd_api.g_ret_sts_error ;
1093: --
1094: when fnd_api.g_exc_unexpected_error then
1095: x_return_status := fnd_api.g_ret_sts_unexp_error ;

Line 1092: x_return_status := fnd_api.g_ret_sts_error ;

1088: END IF;
1089: --
1090: EXCEPTION
1091: when fnd_api.g_exc_error then
1092: x_return_status := fnd_api.g_ret_sts_error ;
1093: --
1094: when fnd_api.g_exc_unexpected_error then
1095: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1096: --

Line 1094: when fnd_api.g_exc_unexpected_error then

1090: EXCEPTION
1091: when fnd_api.g_exc_error then
1092: x_return_status := fnd_api.g_ret_sts_error ;
1093: --
1094: when fnd_api.g_exc_unexpected_error then
1095: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1096: --
1097: when others then
1098: x_return_status := fnd_api.g_ret_sts_unexp_error ;

Line 1095: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1091: when fnd_api.g_exc_error then
1092: x_return_status := fnd_api.g_ret_sts_error ;
1093: --
1094: when fnd_api.g_exc_unexpected_error then
1095: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1096: --
1097: when others then
1098: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1099: if (fnd_msg_pub.check_msg_level(

Line 1098: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1094: when fnd_api.g_exc_unexpected_error then
1095: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1096: --
1097: when others then
1098: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1099: if (fnd_msg_pub.check_msg_level(
1100: fnd_msg_pub.g_msg_lvl_unexp_error)) then
1101: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1102: end if;

Line 1183: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

1179: ,x_return_status => l_return_status
1180: ,x_msg_count => l_msg_count
1181: ,x_msg_data => l_msg_data);
1182:
1183: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1184: CLOSE c_sub_status;
1185: RAISE fnd_api.g_exc_unexpected_error;
1186: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1187: CLOSE c_sub_status;

Line 1185: RAISE fnd_api.g_exc_unexpected_error;

1181: ,x_msg_data => l_msg_data);
1182:
1183: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1184: CLOSE c_sub_status;
1185: RAISE fnd_api.g_exc_unexpected_error;
1186: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1187: CLOSE c_sub_status;
1188: RAISE fnd_api.g_exc_error;
1189: END IF;

Line 1186: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

1182:
1183: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1184: CLOSE c_sub_status;
1185: RAISE fnd_api.g_exc_unexpected_error;
1186: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1187: CLOSE c_sub_status;
1188: RAISE fnd_api.g_exc_error;
1189: END IF;
1190: END IF;

Line 1188: RAISE fnd_api.g_exc_error;

1184: CLOSE c_sub_status;
1185: RAISE fnd_api.g_exc_unexpected_error;
1186: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1187: CLOSE c_sub_status;
1188: RAISE fnd_api.g_exc_error;
1189: END IF;
1190: END IF;
1191: CLOSE c_sub_status;
1192: g_isllta_subinventory_code := p_subinventory_code;

Line 1221: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

1217: ,x_return_status => l_return_status
1218: ,x_msg_count => l_msg_count
1219: ,x_msg_data => l_msg_data);
1220:
1221: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1222: CLOSE c_loc_status;
1223: RAISE fnd_api.g_exc_unexpected_error;
1224: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1225: CLOSE c_loc_status;

Line 1223: RAISE fnd_api.g_exc_unexpected_error;

1219: ,x_msg_data => l_msg_data);
1220:
1221: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1222: CLOSE c_loc_status;
1223: RAISE fnd_api.g_exc_unexpected_error;
1224: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1225: CLOSE c_loc_status;
1226: RAISE fnd_api.g_exc_error;
1227: END IF;

Line 1224: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

1220:
1221: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1222: CLOSE c_loc_status;
1223: RAISE fnd_api.g_exc_unexpected_error;
1224: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1225: CLOSE c_loc_status;
1226: RAISE fnd_api.g_exc_error;
1227: END IF;
1228: END IF;

Line 1226: RAISE fnd_api.g_exc_error;

1222: CLOSE c_loc_status;
1223: RAISE fnd_api.g_exc_unexpected_error;
1224: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1225: CLOSE c_loc_status;
1226: RAISE fnd_api.g_exc_error;
1227: END IF;
1228: END IF;
1229: CLOSE c_loc_status;
1230: g_isllta_locator_id := p_locator_id;

Line 1253: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

1249: ,x_default_lot_status_id => l_default_lot_status_id
1250: ,x_serial_status_enabled => l_serial_status_enabled
1251: ,x_default_serial_status_id => l_default_serial_status_id);
1252:
1253: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1254: RAISE fnd_api.g_exc_unexpected_error;
1255: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1256: RAISE fnd_api.g_exc_error;
1257: END IF;

Line 1254: RAISE fnd_api.g_exc_unexpected_error;

1250: ,x_serial_status_enabled => l_serial_status_enabled
1251: ,x_default_serial_status_id => l_default_serial_status_id);
1252:
1253: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1254: RAISE fnd_api.g_exc_unexpected_error;
1255: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1256: RAISE fnd_api.g_exc_error;
1257: END IF;
1258:

Line 1255: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

1251: ,x_default_serial_status_id => l_default_serial_status_id);
1252:
1253: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1254: RAISE fnd_api.g_exc_unexpected_error;
1255: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1256: RAISE fnd_api.g_exc_error;
1257: END IF;
1258:
1259: if l_lot_status_enabled = 'Y' AND p_lot_number IS NOT NULL THEN

Line 1256: RAISE fnd_api.g_exc_error;

1252:
1253: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1254: RAISE fnd_api.g_exc_unexpected_error;
1255: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1256: RAISE fnd_api.g_exc_error;
1257: END IF;
1258:
1259: if l_lot_status_enabled = 'Y' AND p_lot_number IS NOT NULL THEN
1260: --get status

Line 1276: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

1272: ,x_return_status => l_return_status
1273: ,x_msg_count => l_msg_count
1274: ,x_msg_data => l_msg_data);
1275:
1276: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1277: CLOSE c_lot_status;
1278: RAISE fnd_api.g_exc_unexpected_error;
1279: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1280: CLOSE c_lot_status;

Line 1278: RAISE fnd_api.g_exc_unexpected_error;

1274: ,x_msg_data => l_msg_data);
1275:
1276: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1277: CLOSE c_lot_status;
1278: RAISE fnd_api.g_exc_unexpected_error;
1279: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1280: CLOSE c_lot_status;
1281: RAISE fnd_api.g_exc_error;
1282: END IF;

Line 1279: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

1275:
1276: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1277: CLOSE c_lot_status;
1278: RAISE fnd_api.g_exc_unexpected_error;
1279: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1280: CLOSE c_lot_status;
1281: RAISE fnd_api.g_exc_error;
1282: END IF;
1283: END IF;

Line 1281: RAISE fnd_api.g_exc_error;

1277: CLOSE c_lot_status;
1278: RAISE fnd_api.g_exc_unexpected_error;
1279: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1280: CLOSE c_lot_status;
1281: RAISE fnd_api.g_exc_error;
1282: END IF;
1283: END IF;
1284: CLOSE c_lot_status;
1285: g_isllta_lot_number := p_lot_number;

Line 1362: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

1358: ,x_default_lot_status_id => l_default_lot_status_id
1359: ,x_serial_status_enabled => g_serial_status_enabled
1360: ,x_default_serial_status_id => l_default_serial_status_id);
1361:
1362: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1363: RAISE fnd_api.g_exc_unexpected_error;
1364: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1365: RAISE fnd_api.g_exc_error;
1366: END IF;

Line 1363: RAISE fnd_api.g_exc_unexpected_error;

1359: ,x_serial_status_enabled => g_serial_status_enabled
1360: ,x_default_serial_status_id => l_default_serial_status_id);
1361:
1362: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1363: RAISE fnd_api.g_exc_unexpected_error;
1364: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1365: RAISE fnd_api.g_exc_error;
1366: END IF;
1367: END IF;

Line 1364: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

1360: ,x_default_serial_status_id => l_default_serial_status_id);
1361:
1362: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1363: RAISE fnd_api.g_exc_unexpected_error;
1364: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1365: RAISE fnd_api.g_exc_error;
1366: END IF;
1367: END IF;
1368:

Line 1365: RAISE fnd_api.g_exc_error;

1361:
1362: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1363: RAISE fnd_api.g_exc_unexpected_error;
1364: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1365: RAISE fnd_api.g_exc_error;
1366: END IF;
1367: END IF;
1368:
1369: IF g_serial_status_enabled = 'Y' AND p_serial_status IS NOT NULL THEN

Line 1384: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

1380: ,x_return_status => l_return_status
1381: ,x_msg_count => l_msg_count
1382: ,x_msg_data => l_msg_data);
1383:
1384: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1385: RAISE fnd_api.g_exc_unexpected_error;
1386: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1387: RAISE fnd_api.g_exc_error;
1388: END IF;

Line 1385: RAISE fnd_api.g_exc_unexpected_error;

1381: ,x_msg_count => l_msg_count
1382: ,x_msg_data => l_msg_data);
1383:
1384: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1385: RAISE fnd_api.g_exc_unexpected_error;
1386: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1387: RAISE fnd_api.g_exc_error;
1388: END IF;
1389: l_serial_return := g_serial_return;

Line 1386: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

1382: ,x_msg_data => l_msg_data);
1383:
1384: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1385: RAISE fnd_api.g_exc_unexpected_error;
1386: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1387: RAISE fnd_api.g_exc_error;
1388: END IF;
1389: l_serial_return := g_serial_return;
1390: END IF;

Line 1387: RAISE fnd_api.g_exc_error;

1383:
1384: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1385: RAISE fnd_api.g_exc_unexpected_error;
1386: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1387: RAISE fnd_api.g_exc_error;
1388: END IF;
1389: l_serial_return := g_serial_return;
1390: END IF;
1391: END IF;

Line 1415: x_return_status := fnd_api.g_ret_sts_success;

1411: ,x_sql_statement OUT NOCOPY LONG)
1412: IS
1413:
1414: BEGIN
1415: x_return_status := fnd_api.g_ret_sts_success;
1416: x_sql_statement := '
1417: SELECT
1418: x.organization_id
1419: ,x.inventory_item_id

Line 1500: x_return_status := fnd_api.g_ret_sts_success;

1496:
1497: -- constants
1498: l_api_name constant varchar(30) := 'search_serial_numbers';
1499: begin
1500: x_return_status := fnd_api.g_ret_sts_success;
1501: x_found := FALSE;
1502:
1503: if (g_serial_tbl_ptr > 0) then
1504: for i in 1..g_serial_tbl_ptr loop

Line 1516: when fnd_api.g_exc_error then

1512: end loop;
1513: end if;
1514: --
1515: exception
1516: when fnd_api.g_exc_error then
1517: x_return_status := fnd_api.g_ret_sts_error ;
1518: x_found := TRUE;
1519:
1520: when fnd_api.g_exc_unexpected_error then

Line 1517: x_return_status := fnd_api.g_ret_sts_error ;

1513: end if;
1514: --
1515: exception
1516: when fnd_api.g_exc_error then
1517: x_return_status := fnd_api.g_ret_sts_error ;
1518: x_found := TRUE;
1519:
1520: when fnd_api.g_exc_unexpected_error then
1521: x_return_status := fnd_api.g_ret_sts_unexp_error ;

Line 1520: when fnd_api.g_exc_unexpected_error then

1516: when fnd_api.g_exc_error then
1517: x_return_status := fnd_api.g_ret_sts_error ;
1518: x_found := TRUE;
1519:
1520: when fnd_api.g_exc_unexpected_error then
1521: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1522: x_found := TRUE;
1523:
1524: when others then

Line 1521: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1517: x_return_status := fnd_api.g_ret_sts_error ;
1518: x_found := TRUE;
1519:
1520: when fnd_api.g_exc_unexpected_error then
1521: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1522: x_found := TRUE;
1523:
1524: when others then
1525: x_return_status := fnd_api.g_ret_sts_unexp_error ;

Line 1525: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1521: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1522: x_found := TRUE;
1523:
1524: when others then
1525: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1526: x_found := TRUE;
1527:
1528: if (fnd_msg_pub.check_msg_level(
1529: fnd_msg_pub.g_msg_lvl_unexp_error)) then

Line 1678: x_return_status := fnd_api.g_ret_sts_success ;

1674: l_custom_select_serials INV_DETAIL_UTIL_PVT.g_serial_row_table_rec;
1675: l_selected_serials INV_DETAIL_UTIL_PVT.g_serial_row_table_rec;
1676:
1677: BEGIN
1678: x_return_status := fnd_api.g_ret_sts_success ;
1679: x_available_sl_qty := 0;
1680: x_serial_index := 0;
1681:
1682: IF g_debug IS NULL or NOT INV_CACHE.is_pickrelease THEN

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

1723: , p_demand_source_header_id => p_demand_source_header_id
1724: , p_demand_source_line_id => p_demand_source_line_id
1725: , x_serial_numbers => l_custom_select_serials );
1726:
1727: IF ( x_return_status = fnd_api.g_ret_sts_unexp_error ) THEN
1728: IF ( l_debug = 1 ) THEN
1729: print_debug('unexp_error from Get_User_Serial_Numbers');
1730: END IF;
1731: RAISE fnd_api.g_exc_unexpected_error;

Line 1731: RAISE fnd_api.g_exc_unexpected_error;

1727: IF ( x_return_status = fnd_api.g_ret_sts_unexp_error ) THEN
1728: IF ( l_debug = 1 ) THEN
1729: print_debug('unexp_error from Get_User_Serial_Numbers');
1730: END IF;
1731: RAISE fnd_api.g_exc_unexpected_error;
1732: ELSIF ( x_return_status = fnd_api.g_ret_sts_error ) THEN
1733: IF ( l_debug = 1 ) THEN
1734: print_debug('error from Get_User_Serial_Numbers');
1735: END IF;

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

1728: IF ( l_debug = 1 ) THEN
1729: print_debug('unexp_error from Get_User_Serial_Numbers');
1730: END IF;
1731: RAISE fnd_api.g_exc_unexpected_error;
1732: ELSIF ( x_return_status = fnd_api.g_ret_sts_error ) THEN
1733: IF ( l_debug = 1 ) THEN
1734: print_debug('error from Get_User_Serial_Numbers');
1735: END IF;
1736: RAISE fnd_api.g_exc_error;

Line 1736: RAISE fnd_api.g_exc_error;

1732: ELSIF ( x_return_status = fnd_api.g_ret_sts_error ) THEN
1733: IF ( l_debug = 1 ) THEN
1734: print_debug('error from Get_User_Serial_Numbers');
1735: END IF;
1736: RAISE fnd_api.g_exc_error;
1737: END IF;
1738:
1739: --Bulk insert the return values from user into temp table for validation
1740: BEGIN

Line 1759: RAISE fnd_api.g_exc_error;

1755: print_debug('Get_User_Serial_Numbers returned duplicate serials', 1);
1756: END IF;
1757: fnd_message.set_name('INV', 'INV_DUPLICATE_SERIAL');
1758: fnd_msg_pub.ADD;
1759: RAISE fnd_api.g_exc_error;
1760: END;
1761:
1762: --Retrieve only valid rows returned from api
1763: OPEN validate_sn_cur;

Line 1859: WHEN fnd_api.g_exc_error then

1855: IF ( l_debug = 1 )THEN
1856: print_debug('exit '||g_pkg_name||'.'||l_api_name);
1857: END IF;
1858: EXCEPTION
1859: WHEN fnd_api.g_exc_error then
1860: x_return_status := fnd_api.g_ret_sts_error;
1861: x_available_sl_qty := 0;
1862: x_serial_index := 0;
1863:

Line 1860: x_return_status := fnd_api.g_ret_sts_error;

1856: print_debug('exit '||g_pkg_name||'.'||l_api_name);
1857: END IF;
1858: EXCEPTION
1859: WHEN fnd_api.g_exc_error then
1860: x_return_status := fnd_api.g_ret_sts_error;
1861: x_available_sl_qty := 0;
1862: x_serial_index := 0;
1863:
1864: IF (l_debug = 1) THEN

Line 1868: x_return_status := fnd_api.g_ret_sts_unexp_error;

1864: IF (l_debug = 1) THEN
1865: print_debug(l_api_name ||' Exc err progress='||l_progress||' SQL err: '||SQLERRM(SQLCODE), 1);
1866: END IF;
1867: WHEN OTHERS THEN
1868: x_return_status := fnd_api.g_ret_sts_unexp_error;
1869: x_available_sl_qty := 0;
1870: x_serial_index := 0;
1871:
1872: IF (l_debug = 1) THEN

Line 1905: x_return_status := fnd_api.g_ret_sts_success;

1901: END IF;
1902: -- end of debugging section
1903: --
1904: -- Initialisize API return status to access
1905: x_return_status := fnd_api.g_ret_sts_success;
1906: IF p_mmtt_tbl_size IS NULL OR p_mmtt_tbl_size <1 THEN
1907: RETURN;
1908: END IF;
1909: --

Line 2322: when fnd_api.g_exc_error then

2318: END IF;
2319: -- end of debugging section
2320: --
2321: EXCEPTION
2322: when fnd_api.g_exc_error then
2323: --
2324: -- debugging portion
2325: -- can be commented ut for final code
2326: IF inv_pp_debug.is_debug_mode THEN

Line 2335: x_return_status := fnd_api.g_ret_sts_error;

2331: inv_pp_debug.send_last_error_message;
2332: END IF;
2333: -- end of debugging section
2334: --
2335: x_return_status := fnd_api.g_ret_sts_error;
2336: --
2337: when fnd_api.g_exc_unexpected_error then
2338: --
2339: -- debugging portion

Line 2337: when fnd_api.g_exc_unexpected_error then

2333: -- end of debugging section
2334: --
2335: x_return_status := fnd_api.g_ret_sts_error;
2336: --
2337: when fnd_api.g_exc_unexpected_error then
2338: --
2339: -- debugging portion
2340: -- can be commented ut for final code
2341: IF inv_pp_debug.is_debug_mode THEN

Line 2350: x_return_status := fnd_api.g_ret_sts_unexp_error;

2346: inv_pp_debug.send_last_error_message;
2347: END IF;
2348: -- end of debugging section
2349: --
2350: x_return_status := fnd_api.g_ret_sts_unexp_error;
2351: --
2352: when others then
2353: --
2354: -- debugging portion

Line 2365: x_return_status := fnd_api.g_ret_sts_unexp_error;

2361: inv_pp_debug.send_last_error_message;
2362: END IF;
2363: -- end of debugging section
2364: --
2365: x_return_status := fnd_api.g_ret_sts_unexp_error;
2366: if fnd_msg_pub.Check_Msg_Level(fnd_msg_pub.g_msg_lvl_unexp_error) then
2367: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2368: end if;
2369: --

Line 2396: x_return_status := fnd_api.g_ret_sts_success;

2392: END IF;
2393: -- end of debugging section
2394: --
2395: -- Initialisize API return status to access
2396: x_return_status := fnd_api.g_ret_sts_success;
2397: IF p_mtlt_tbl_size IS NULL OR p_mtlt_tbl_size < 1 THEN
2398: RETURN;
2399: END IF;
2400: --

Line 2638: when fnd_api.g_exc_error then

2634: END IF;
2635: -- end of debugging section
2636: --
2637: EXCEPTION
2638: when fnd_api.g_exc_error then
2639: --
2640: -- debugging portion
2641: -- can be commented ut for final code
2642: IF inv_pp_debug.is_debug_mode THEN

Line 2651: x_return_status := fnd_api.g_ret_sts_error;

2647: inv_pp_debug.send_last_error_message;
2648: END IF;
2649: -- end of debugging section
2650: --
2651: x_return_status := fnd_api.g_ret_sts_error;
2652: --
2653: when fnd_api.g_exc_unexpected_error then
2654: --
2655: -- debugging portion

Line 2653: when fnd_api.g_exc_unexpected_error then

2649: -- end of debugging section
2650: --
2651: x_return_status := fnd_api.g_ret_sts_error;
2652: --
2653: when fnd_api.g_exc_unexpected_error then
2654: --
2655: -- debugging portion
2656: -- can be commented ut for final code
2657: IF inv_pp_debug.is_debug_mode THEN

Line 2666: x_return_status := fnd_api.g_ret_sts_unexp_error;

2662: inv_pp_debug.send_last_error_message;
2663: END IF;
2664: -- end of debugging section
2665: --
2666: x_return_status := fnd_api.g_ret_sts_unexp_error;
2667: --
2668: when others then
2669: --
2670: -- debugging portion

Line 2681: x_return_status := fnd_api.g_ret_sts_unexp_error;

2677: inv_pp_debug.send_last_error_message;
2678: END IF;
2679: -- end of debugging section
2680: --
2681: x_return_status := fnd_api.g_ret_sts_unexp_error;
2682: if fnd_msg_pub.Check_Msg_Level(fnd_msg_pub.g_msg_lvl_unexp_error) then
2683: fnd_msg_pub.Add_Exc_Msg(g_pkg_name, l_api_name);
2684: end if;
2685: --

Line 2712: x_return_status := fnd_api.g_ret_sts_success;

2708: END IF;
2709: -- end of debugging section
2710: --
2711: -- Initialisize API return status to access
2712: x_return_status := fnd_api.g_ret_sts_success;
2713: IF p_msnt_tbl_size IS NULL OR p_msnt_tbl_size < 1 THEN
2714: RETURN;
2715: END IF;
2716: --

Line 2775: when fnd_api.g_exc_error then

2771: END IF;
2772: -- end of debugging section
2773: --
2774: EXCEPTION
2775: when fnd_api.g_exc_error then
2776: --
2777: -- debugging portion
2778: -- can be commented ut for final code
2779: IF inv_pp_debug.is_debug_mode THEN

Line 2788: x_return_status := fnd_api.g_ret_sts_error;

2784: inv_pp_debug.send_last_error_message;
2785: END IF;
2786: -- end of debugging section
2787: --
2788: x_return_status := fnd_api.g_ret_sts_error;
2789: --
2790: when fnd_api.g_exc_unexpected_error then
2791: --
2792: -- debugging portion

Line 2790: when fnd_api.g_exc_unexpected_error then

2786: -- end of debugging section
2787: --
2788: x_return_status := fnd_api.g_ret_sts_error;
2789: --
2790: when fnd_api.g_exc_unexpected_error then
2791: --
2792: -- debugging portion
2793: -- can be commented ut for final code
2794: IF inv_pp_debug.is_debug_mode THEN

Line 2803: x_return_status := fnd_api.g_ret_sts_unexp_error;

2799: inv_pp_debug.send_last_error_message;
2800: END IF;
2801: -- end of debugging section
2802: --
2803: x_return_status := fnd_api.g_ret_sts_unexp_error;
2804: --
2805: when others then
2806: --
2807: -- debugging portion

Line 2818: x_return_status := fnd_api.g_ret_sts_unexp_error;

2814: inv_pp_debug.send_last_error_message;
2815: END IF;
2816: -- end of debugging section
2817: --
2818: x_return_status := fnd_api.g_ret_sts_unexp_error;
2819: if fnd_msg_pub.Check_Msg_Level(fnd_msg_pub.g_msg_lvl_unexp_error) then
2820: fnd_msg_pub.Add_Exc_Msg(g_pkg_name, l_api_name);
2821: end if;
2822: --

Line 3063: x_return_status := fnd_api.g_ret_sts_success;

3059: , secondary_detailed_quantity = secondary_detailed_quantity + g_output_process_tbl(l_index).secondary_quantity
3060: WHERE reservation_id = l_reservation_id;
3061: END IF;
3062: END LOOP;
3063: x_return_status := fnd_api.g_ret_sts_success;
3064: EXCEPTION
3065: WHEN OTHERS THEN
3066: FND_MESSAGE.SET_NAME('INV','INV_UPD_RSV_FAILED');
3067: FND_MSG_PUB.Add;

Line 3068: x_return_status := fnd_api.g_ret_sts_unexp_error;

3064: EXCEPTION
3065: WHEN OTHERS THEN
3066: FND_MESSAGE.SET_NAME('INV','INV_UPD_RSV_FAILED');
3067: FND_MSG_PUB.Add;
3068: x_return_status := fnd_api.g_ret_sts_unexp_error;
3069: END update_detailed_quantities;
3070: --
3071: -- create suggestion records.
3072: -- insert into mtl_material_transactions_temp, mtl_serial_numbers_temp,

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

3078: p_plan_tasks IN BOOLEAN
3079: ) IS
3080: l_api_name CONSTANT VARCHAR2(30) := 'Process_Output';
3081: l_debug NUMBER;
3082: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
3083: l_insert_lot BOOLEAN; -- insert a new lot record
3084: l_insert_serial BOOLEAN; -- insert a new serial record
3085: l_insert_txn BOOLEAN; -- insert a new transaction temp record
3086: l_txn_temp_id NUMBER;

Line 3128: x_return_status := fnd_api.g_ret_sts_success;

3124: print_debug('in process output ');
3125: print_output_process_tbl(p_request_context);
3126: END IF;
3127: -- Initialisize API return status to access
3128: x_return_status := fnd_api.g_ret_sts_success;
3129: IF g_output_process_tbl_size IS NULL OR
3130: g_output_process_tbl_size < 1 THEN
3131: RETURN;
3132: END IF;

Line 3420: x_return_status := FND_API.G_RET_STS_ERROR;

3416: END IF;
3417: IF l_mmtt_tbl(l_mmtt_tbl_size).acct_period_id = -1 THEN
3418: FND_MESSAGE.SET_NAME('INV', 'INV_NO_OPEN_PERIOD');
3419: FND_MSG_PUB.add;
3420: x_return_status := FND_API.G_RET_STS_ERROR;
3421: raise FND_API.G_EXC_ERROR;
3422: END IF;
3423: l_mmtt_tbl(l_mmtt_tbl_size).transaction_reference :=
3424: p_request_line_rec.reference;

Line 3421: raise FND_API.G_EXC_ERROR;

3417: IF l_mmtt_tbl(l_mmtt_tbl_size).acct_period_id = -1 THEN
3418: FND_MESSAGE.SET_NAME('INV', 'INV_NO_OPEN_PERIOD');
3419: FND_MSG_PUB.add;
3420: x_return_status := FND_API.G_RET_STS_ERROR;
3421: raise FND_API.G_EXC_ERROR;
3422: END IF;
3423: l_mmtt_tbl(l_mmtt_tbl_size).transaction_reference :=
3424: p_request_line_rec.reference;
3425: l_mmtt_tbl(l_mmtt_tbl_size).reason_id :=

Line 3571: IF l_return_status = fnd_api.g_ret_sts_error THEN

3567: x_return_status => l_return_status ,
3568: p_mmtt_tbl => l_mmtt_tbl ,
3569: p_mmtt_tbl_size => l_mmtt_tbl_size
3570: );
3571: IF l_return_status = fnd_api.g_ret_sts_error THEN
3572: RAISE fnd_api.g_exc_error;
3573: END IF;
3574: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3575: RAISE fnd_api.g_exc_unexpected_error;

Line 3572: RAISE fnd_api.g_exc_error;

3568: p_mmtt_tbl => l_mmtt_tbl ,
3569: p_mmtt_tbl_size => l_mmtt_tbl_size
3570: );
3571: IF l_return_status = fnd_api.g_ret_sts_error THEN
3572: RAISE fnd_api.g_exc_error;
3573: END IF;
3574: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3575: RAISE fnd_api.g_exc_unexpected_error;
3576: END IF;

Line 3574: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

3570: );
3571: IF l_return_status = fnd_api.g_ret_sts_error THEN
3572: RAISE fnd_api.g_exc_error;
3573: END IF;
3574: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3575: RAISE fnd_api.g_exc_unexpected_error;
3576: END IF;
3577: END IF;
3578: IF l_mtlt_tbl_size > 0 THEN

Line 3575: RAISE fnd_api.g_exc_unexpected_error;

3571: IF l_return_status = fnd_api.g_ret_sts_error THEN
3572: RAISE fnd_api.g_exc_error;
3573: END IF;
3574: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3575: RAISE fnd_api.g_exc_unexpected_error;
3576: END IF;
3577: END IF;
3578: IF l_mtlt_tbl_size > 0 THEN
3579: insert_mtlt

Line 3585: IF l_return_status = fnd_api.g_ret_sts_error THEN

3581: x_return_status => l_return_status ,
3582: p_mtlt_tbl => l_mtlt_tbl ,
3583: p_mtlt_tbl_size => l_mtlt_tbl_size
3584: );
3585: IF l_return_status = fnd_api.g_ret_sts_error THEN
3586: RAISE fnd_api.g_exc_error;
3587: END IF;
3588: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3589: RAISE fnd_api.g_exc_unexpected_error;

Line 3586: RAISE fnd_api.g_exc_error;

3582: p_mtlt_tbl => l_mtlt_tbl ,
3583: p_mtlt_tbl_size => l_mtlt_tbl_size
3584: );
3585: IF l_return_status = fnd_api.g_ret_sts_error THEN
3586: RAISE fnd_api.g_exc_error;
3587: END IF;
3588: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3589: RAISE fnd_api.g_exc_unexpected_error;
3590: END IF;

Line 3588: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

3584: );
3585: IF l_return_status = fnd_api.g_ret_sts_error THEN
3586: RAISE fnd_api.g_exc_error;
3587: END IF;
3588: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3589: RAISE fnd_api.g_exc_unexpected_error;
3590: END IF;
3591: END IF;
3592: IF l_msnt_tbl_size > 0 THEN

Line 3589: RAISE fnd_api.g_exc_unexpected_error;

3585: IF l_return_status = fnd_api.g_ret_sts_error THEN
3586: RAISE fnd_api.g_exc_error;
3587: END IF;
3588: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3589: RAISE fnd_api.g_exc_unexpected_error;
3590: END IF;
3591: END IF;
3592: IF l_msnt_tbl_size > 0 THEN
3593: insert_msnt

Line 3599: IF l_return_status = fnd_api.g_ret_sts_error THEN

3595: x_return_status => l_return_status ,
3596: p_msnt_tbl => l_msnt_tbl ,
3597: p_msnt_tbl_size => l_msnt_tbl_size
3598: );
3599: IF l_return_status = fnd_api.g_ret_sts_error THEN
3600: RAISE fnd_api.g_exc_error;
3601: END IF;
3602: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3603: RAISE fnd_api.g_exc_unexpected_error;

Line 3600: RAISE fnd_api.g_exc_error;

3596: p_msnt_tbl => l_msnt_tbl ,
3597: p_msnt_tbl_size => l_msnt_tbl_size
3598: );
3599: IF l_return_status = fnd_api.g_ret_sts_error THEN
3600: RAISE fnd_api.g_exc_error;
3601: END IF;
3602: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3603: RAISE fnd_api.g_exc_unexpected_error;
3604: END IF;

Line 3602: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

3598: );
3599: IF l_return_status = fnd_api.g_ret_sts_error THEN
3600: RAISE fnd_api.g_exc_error;
3601: END IF;
3602: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3603: RAISE fnd_api.g_exc_unexpected_error;
3604: END IF;
3605: END IF;
3606: IF p_request_context.detail_serial AND

Line 3603: RAISE fnd_api.g_exc_unexpected_error;

3599: IF l_return_status = fnd_api.g_ret_sts_error THEN
3600: RAISE fnd_api.g_exc_error;
3601: END IF;
3602: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3603: RAISE fnd_api.g_exc_unexpected_error;
3604: END IF;
3605: END IF;
3606: IF p_request_context.detail_serial AND
3607: (p_request_context.transfer_flag OR

Line 3623: --IF l_return_status = fnd_api.g_ret_sts_error THEN

3619: -- detailed quantity but not updating the quantity tree.
3620: -- Since we update detailed_quantity in INV_PICK_RELEASE_PVT.Process_line,
3621: -- we don't need to do it here.
3622: --update_detailed_quantities(l_return_status);
3623: --IF l_return_status = fnd_api.g_ret_sts_error THEN
3624: -- RAISE fnd_api.g_exc_error;
3625: --END IF;
3626: --IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3627: -- RAISE fnd_api.g_exc_unexpected_error;

Line 3624: -- RAISE fnd_api.g_exc_error;

3620: -- Since we update detailed_quantity in INV_PICK_RELEASE_PVT.Process_line,
3621: -- we don't need to do it here.
3622: --update_detailed_quantities(l_return_status);
3623: --IF l_return_status = fnd_api.g_ret_sts_error THEN
3624: -- RAISE fnd_api.g_exc_error;
3625: --END IF;
3626: --IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3627: -- RAISE fnd_api.g_exc_unexpected_error;
3628: --END IF;

Line 3626: --IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

3622: --update_detailed_quantities(l_return_status);
3623: --IF l_return_status = fnd_api.g_ret_sts_error THEN
3624: -- RAISE fnd_api.g_exc_error;
3625: --END IF;
3626: --IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3627: -- RAISE fnd_api.g_exc_unexpected_error;
3628: --END IF;
3629: x_return_status := l_return_status;
3630: --

Line 3627: -- RAISE fnd_api.g_exc_unexpected_error;

3623: --IF l_return_status = fnd_api.g_ret_sts_error THEN
3624: -- RAISE fnd_api.g_exc_error;
3625: --END IF;
3626: --IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3627: -- RAISE fnd_api.g_exc_unexpected_error;
3628: --END IF;
3629: x_return_status := l_return_status;
3630: --
3631: -- debugging section

Line 3646: WHEN fnd_api.g_exc_error THEN

3642: END IF;
3643: -- end of debugging section
3644: --
3645: EXCEPTION
3646: WHEN fnd_api.g_exc_error THEN
3647: --
3648: -- debugging section
3649: -- can be commented ut for final code
3650: IF inv_pp_debug.is_debug_mode THEN

Line 3659: x_return_status := fnd_api.g_ret_sts_error;

3655: inv_pp_debug.send_last_error_message;
3656: END IF;
3657: -- end of debugging section
3658: --
3659: x_return_status := fnd_api.g_ret_sts_error;
3660: --
3661: WHEN fnd_api.g_exc_unexpected_error THEN
3662: --
3663: -- debugging section

Line 3661: WHEN fnd_api.g_exc_unexpected_error THEN

3657: -- end of debugging section
3658: --
3659: x_return_status := fnd_api.g_ret_sts_error;
3660: --
3661: WHEN fnd_api.g_exc_unexpected_error THEN
3662: --
3663: -- debugging section
3664: -- can be commented ut for final code
3665: IF inv_pp_debug.is_debug_mode THEN

Line 3674: x_return_status := fnd_api.g_ret_sts_unexp_error;

3670: inv_pp_debug.send_last_error_message;
3671: END IF;
3672: -- end of debugging section
3673: --
3674: x_return_status := fnd_api.g_ret_sts_unexp_error;
3675: --
3676: WHEN OTHERS THEN
3677: --
3678: -- debugging section

Line 3689: x_return_status := fnd_api.g_ret_sts_unexp_error;

3685: inv_pp_debug.send_last_error_message;
3686: END IF;
3687: -- end of debugging section
3688: --
3689: x_return_status := fnd_api.g_ret_sts_unexp_error;
3690: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3691: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3692: END IF;
3693: --

Line 3884: IF l_status_return = fnd_api.g_ret_sts_unexp_error THEN

3880: ,p_transaction_type_id => p_transaction_type_id
3881: ,x_return_status => l_status_return ,x_msg_count => l_msg_count
3882: ,x_msg_data => l_msg_data);
3883:
3884: IF l_status_return = fnd_api.g_ret_sts_unexp_error THEN
3885: RAISE fnd_api.g_exc_unexpected_error;
3886: ELSIF l_status_return = fnd_api.g_ret_sts_error THEN
3887: RAISE fnd_api.g_exc_error;
3888: END IF;

Line 3885: RAISE fnd_api.g_exc_unexpected_error;

3881: ,x_return_status => l_status_return ,x_msg_count => l_msg_count
3882: ,x_msg_data => l_msg_data);
3883:
3884: IF l_status_return = fnd_api.g_ret_sts_unexp_error THEN
3885: RAISE fnd_api.g_exc_unexpected_error;
3886: ELSIF l_status_return = fnd_api.g_ret_sts_error THEN
3887: RAISE fnd_api.g_exc_error;
3888: END IF;
3889: EXCEPTION

Line 3886: ELSIF l_status_return = fnd_api.g_ret_sts_error THEN

3882: ,x_msg_data => l_msg_data);
3883:
3884: IF l_status_return = fnd_api.g_ret_sts_unexp_error THEN
3885: RAISE fnd_api.g_exc_unexpected_error;
3886: ELSIF l_status_return = fnd_api.g_ret_sts_error THEN
3887: RAISE fnd_api.g_exc_error;
3888: END IF;
3889: EXCEPTION
3890: WHEN OTHERS THEN

Line 3887: RAISE fnd_api.g_exc_error;

3883:
3884: IF l_status_return = fnd_api.g_ret_sts_unexp_error THEN
3885: RAISE fnd_api.g_exc_unexpected_error;
3886: ELSIF l_status_return = fnd_api.g_ret_sts_error THEN
3887: RAISE fnd_api.g_exc_error;
3888: END IF;
3889: EXCEPTION
3890: WHEN OTHERS THEN
3891: IF (l_debug = 1) THEN

Line 3894: RAISE fnd_api.g_exc_unexpected_error;

3890: WHEN OTHERS THEN
3891: IF (l_debug = 1) THEN
3892: l_progress := 'WMSSCC-0890';
3893: print_debug('INV_DETAIL_UTIL_PVT:'||l_api_name||': Error occured'||l_progress, 1);
3894: RAISE fnd_api.g_exc_unexpected_error;
3895: END IF;
3896: END;
3897:
3898: IF ( l_debug = 1 ) THEN