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

Line 19: g_ret_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

15: g_msg_lvl_debug_high NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH ;
16: g_msg_lvl_debug_medium NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM ;
17: g_msg_lvl_debug_low NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ;
18:
19: g_ret_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
20: g_ret_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
21: g_ret_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
22: --mes end
23:

Line 20: g_ret_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;

16: g_msg_lvl_debug_medium NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM ;
17: g_msg_lvl_debug_low NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ;
18:
19: g_ret_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
20: g_ret_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
21: g_ret_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
22: --mes end
23:
24: /*-------------------------------------------------------------+

Line 21: g_ret_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

17: g_msg_lvl_debug_low NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ;
18:
19: g_ret_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
20: g_ret_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
21: g_ret_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
22: --mes end
23:
24: /*-------------------------------------------------------------+
25: | CUSTOM_VALIDATION: |

Line 4224: ** if ( l_returnStatus <> fnd_api.g_ret_sts_success) then

4220: ** (X_Return_Status => l_returnStatus,
4221: ** p_Kanban_Card_Id => l_kanban_card_id,
4222: ** p_Supply_Status => inv_kanban_pvt.g_supply_status_InProcess);
4223: **
4224: ** if ( l_returnStatus <> fnd_api.g_ret_sts_success) then
4225: ** FND_MESSAGE.SET_NAME('WSM', 'WSM_KNBN_CARD_STS_FAIL');
4226: ** fnd_message.set_token('STATUS','InProcess');
4227: ** x_return_code := 1;
4228: ** x_err_buf := FND_MESSAGE.GET;

Line 6867: RAISE FND_API.G_EXC_ERROR;

6863: FND_MESSAGE.SET_NAME('WSM','WSM_MES_FIELD_NEGATIVE');
6864: FND_MESSAGE.SET_TOKEN('FIELD_NAME', l_msg_tokens(0).TokenValue);
6865: FND_MSG_PUB.add;
6866: ROLLBACK TO validation;
6867: RAISE FND_API.G_EXC_ERROR;
6868:
6869: ELSE
6870:
6871: l_stmt_num := 110.6;

Line 6932: RAISE FND_API.G_EXC_ERROR;

6928: );
6929: FND_MESSAGE.SET_NAME('WSM','WSM_MES_SCRAPCODEQTY_MISMATCH');
6930: FND_MSG_PUB.add;
6931: ROLLBACK TO validation;
6932: RAISE FND_API.G_EXC_ERROR;
6933:
6934: END IF;
6935: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
6936: l_msg_tokens.delete;

Line 6991: RAISE FND_API.G_EXC_ERROR;

6987: FND_MESSAGE.SET_NAME('WSM','WSM_MES_FIELD_NEGATIVE');
6988: FND_MESSAGE.SET_TOKEN('FIELD_NAME', l_msg_tokens(0).TokenValue);
6989: FND_MSG_PUB.add;
6990: ROLLBACK TO validation;
6991: RAISE FND_API.G_EXC_ERROR;
6992:
6993: ELSE
6994: l_stmt_num := 110.1102;
6995:

Line 7019: RAISE FND_API.G_EXC_ERROR;

7015: );
7016: FND_MESSAGE.SET_NAME('WSM','WSM_MES_BONUSCODEQTY_MISMATCH');
7017: FND_MSG_PUB.add;
7018: ROLLBACK TO validation;
7019: RAISE FND_API.G_EXC_ERROR;
7020:
7021: END IF;
7022: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
7023: l_msg_tokens.delete;

Line 7086: RAISE FND_API.G_EXC_ERROR;

7082: );
7083: FND_MESSAGE.SET_NAME('WSM','WSM_MES_SCRAPSERIAL_QTY');
7084: FND_MSG_PUB.add;
7085: ROLLBACK TO validation;
7086: RAISE FND_API.G_EXC_ERROR;
7087: END IF;
7088:
7089: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
7090: l_msg_tokens.delete;

Line 7151: RAISE FND_API.G_EXC_ERROR;

7147: );
7148: FND_MESSAGE.SET_NAME('WSM','WSM_MES_BONUSSERIAL_QTY');
7149: FND_MSG_PUB.add;
7150: ROLLBACK TO validation;
7151: RAISE FND_API.G_EXC_ERROR;
7152:
7153: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
7154: l_msg_tokens.delete;
7155: WSM_log_PVT.logMessage (

Line 7235: RAISE FND_API.G_EXC_ERROR;

7231: );
7232: FND_MESSAGE.SET_NAME('WSM','WSM_MES_START>CURRENTDATE');
7233: FND_MSG_PUB.add;
7234: ROLLBACK TO validation;
7235: RAISE FND_API.G_EXC_ERROR;
7236:
7237: END IF;
7238:
7239: l_stmt_num := 110.20;

Line 7268: RAISE FND_API.G_EXC_ERROR;

7264: );
7265: FND_MESSAGE.SET_NAME('WSM','WSM_MES_RESCOMPL 7266: FND_MSG_PUB.add;
7267: ROLLBACK TO validation;
7268: RAISE FND_API.G_EXC_ERROR;
7269: END IF;
7270:
7271: l_stmt_num := 110.21;
7272: /*****************This is needed only for multiple resource usage dates*******/

Line 7360: RAISE FND_API.G_EXC_ERROR;

7356: );
7357: FND_MESSAGE.SET_NAME('WSM','WSM_MES_OVERLAP_RES_DATES');
7358: FND_MSG_PUB.add;
7359: ROLLBACK TO validation;
7360: RAISE FND_API.G_EXC_ERROR;
7361:
7362: END IF;
7363: END;
7364: END LOOP;

Line 7393: RAISE FND_API.G_EXC_ERROR;

7389: );
7390: FND_MESSAGE.SET_NAME('WSM','WSM_MES_START>RESSTARTDATE');
7391: FND_MSG_PUB.add;
7392: ROLLBACK TO validation;
7393: RAISE FND_API.G_EXC_ERROR;
7394:
7395: END IF;
7396:
7397: l_stmt_num := 110.24;

Line 7424: RAISE FND_API.G_EXC_ERROR;

7420: );
7421: FND_MESSAGE.SET_NAME('WSM','WSM_MES_COMPL 7422: FND_MSG_PUB.add;
7423: ROLLBACK TO validation;
7424: RAISE FND_API.G_EXC_ERROR;
7425: END IF;
7426:
7427: END LOOP;
7428: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN

Line 7462: RAISE FND_API.G_EXC_ERROR;

7458: );
7459: FND_MESSAGE.SET_NAME('WSM','WSM_MES_COMPL 7460: FND_MSG_PUB.add;
7461: ROLLBACK TO validation;
7462: RAISE FND_API.G_EXC_ERROR;
7463:
7464: END IF;
7465: l_stmt_num := 110.252;
7466: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN

Line 7560: RAISE FND_API.G_EXC_ERROR;

7556: );
7557: FND_MESSAGE.SET_NAME('WSM','WSM_MES_START>CURRENTDATE');
7558: FND_MSG_PUB.add;
7559: ROLLBACK TO validation;
7560: RAISE FND_API.G_EXC_ERROR;
7561: END IF;
7562:
7563: IF nvl(p_jobop_resource_usages_tbls(l_header_id)(i).projected_completion_date, sysdate) <
7564: nvl(p_jobop_resource_usages_tbls(l_header_id)(i).start_date, sysdate) THEN

Line 7587: RAISE FND_API.G_EXC_ERROR;

7583: );
7584: FND_MESSAGE.SET_NAME('WSM','WSM_MES_RESPROJCOMPL 7585: FND_MSG_PUB.add;
7586: ROLLBACK TO validation;
7587: RAISE FND_API.G_EXC_ERROR;
7588: END IF;
7589:
7590: IF (p_operation_start_date IS NOT NULL) AND (p_jobop_resource_usages_tbls(l_header_id)(i).start_date < p_operation_start_date) THEN
7591: l_stmt_num := 110.231;

Line 7613: RAISE FND_API.G_EXC_ERROR;

7609: );
7610: FND_MESSAGE.SET_NAME('WSM','WSM_MES_START>RESSTARTDATE');
7611: FND_MSG_PUB.add;
7612: ROLLBACK TO validation;
7613: RAISE FND_API.G_EXC_ERROR;
7614: END IF;
7615:
7616: l_stmt_num := 110.24;
7617:

Line 7641: RAISE FND_API.G_EXC_ERROR;

7637: );
7638: FND_MESSAGE.SET_NAME('WSM','WSM_MES_PROJCOMPL 7639: FND_MSG_PUB.add;
7640: ROLLBACK TO validation;
7641: RAISE FND_API.G_EXC_ERROR;
7642:
7643: END IF;
7644:
7645: END LOOP;

Line 7667: RAISE FND_API.G_EXC_ERROR;

7663:
7664: FND_MESSAGE.SET_NAME('WSM','WSM_MES_PROJCOMPL 7665: FND_MSG_PUB.add;
7666: ROLLBACK TO validation;
7667: RAISE FND_API.G_EXC_ERROR;
7668:
7669: END IF;
7670:
7671: END IF;

Line 7811: if l_return_status = FND_API.G_RET_STS_SUCCESS then

7807: x_error_msg => l_error_msg ,
7808: x_error_count => l_error_count
7809: );
7810:
7811: if l_return_status = FND_API.G_RET_STS_SUCCESS then
7812: IF (l_debug='Y') THEN
7813: fnd_file.put_line(fnd_file.log, 'WSM_Serial_support_PVT.Move_serial_intf_proc returned Success');
7814: END IF;
7815: ELSE

Line 7822: p_encoded => FND_API.G_FALSE

7818: fnd_file.put_line(fnd_file.log, l_error_msg);
7819: ELSIF (l_error_count > 1) THEN
7820: FOR i IN 1..l_error_count LOOP
7821: l_error_msg := fnd_msg_pub.get( p_msg_index => l_error_count - i + 1,
7822: p_encoded => FND_API.G_FALSE
7823: );
7824: fnd_file.put_line(fnd_file.log, l_error_msg);
7825: END LOOP;
7826: ELSE

Line 8952: if l_return_status = FND_API.G_RET_STS_SUCCESS then

8948: x_error_count => l_error_msg ,
8949: x_error_msg => l_error_count
8950: );
8951:
8952: if l_return_status = FND_API.G_RET_STS_SUCCESS then
8953: IF (l_debug='Y') THEN
8954: fnd_file.put_line(fnd_file.log, 'WSM_Serial_support_PVT.Insert_attr_WSTI returned Success');
8955: END IF;
8956:

Line 8983: p_encoded => FND_API.G_FALSE

8979: fnd_file.put_line(fnd_file.log, l_error_msg);
8980: ELSIF (l_error_count > 1) THEN
8981: FOR i IN 1..l_error_count LOOP
8982: l_error_msg := fnd_msg_pub.get( p_msg_index => l_error_count - i + 1,
8983: p_encoded => FND_API.G_FALSE
8984: );
8985: fnd_file.put_line(fnd_file.log, l_error_msg);
8986: END LOOP;
8987: ELSE

Line 9341: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

9337: );
9338: END IF;
9339:
9340: END LOOP;
9341: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9342: END;
9343: /*
9344: forall i in p_jobop_resource_usages_tbls(l_header_id).first..p_jobop_resource_usages_tbls(l_header_id).last SAVE EXCEPTIONS
9345: insert into WIP_RESOURCE_ACTUAL_TIMES values p_jobop_resource_usages_tbls(l_header_id)(i);

Line 9493: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

9489: );
9490: END IF;
9491:
9492: END LOOP;
9493: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9494: END;
9495:
9496: DECLARE
9497: cursor C_WOR is

Line 9914: p_commit => FND_API.G_FALSE,

9910:
9911: l_stmt_num := 253.12;
9912: WSM_WIP_LOT_TXN_PVT.invoke_txn_API (
9913: p_api_version => 1.0,
9914: p_commit => FND_API.G_FALSE,
9915: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
9916: p_init_msg_list => FND_API.G_FALSE,
9917: p_calling_mode => 1,
9918: p_txn_header_rec => l_wltx_transactions_rec,

Line 9915: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

9911: l_stmt_num := 253.12;
9912: WSM_WIP_LOT_TXN_PVT.invoke_txn_API (
9913: p_api_version => 1.0,
9914: p_commit => FND_API.G_FALSE,
9915: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
9916: p_init_msg_list => FND_API.G_FALSE,
9917: p_calling_mode => 1,
9918: p_txn_header_rec => l_wltx_transactions_rec,
9919: p_starting_jobs_tbl => l_wltx_starting_job_tbl,

Line 9916: p_init_msg_list => FND_API.G_FALSE,

9912: WSM_WIP_LOT_TXN_PVT.invoke_txn_API (
9913: p_api_version => 1.0,
9914: p_commit => FND_API.G_FALSE,
9915: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
9916: p_init_msg_list => FND_API.G_FALSE,
9917: p_calling_mode => 1,
9918: p_txn_header_rec => l_wltx_transactions_rec,
9919: p_starting_jobs_tbl => l_wltx_starting_job_tbl,
9920: p_resulting_jobs_tbl => l_wltx_resulting_job_tbl,

Line 9949: RAISE FND_API.G_EXC_ERROR;

9945: END IF;
9946: END IF;
9947:
9948: IF (x_return_status = g_ret_error) THEN
9949: RAISE FND_API.G_EXC_ERROR;
9950: ELSIF (x_return_status = g_ret_unexpected) THEN
9951: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9952: END IF;
9953:

Line 9951: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

9947:
9948: IF (x_return_status = g_ret_error) THEN
9949: RAISE FND_API.G_EXC_ERROR;
9950: ELSIF (x_return_status = g_ret_unexpected) THEN
9951: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9952: END IF;
9953:
9954: IF (G_LOG_LEVEL_PROCEDURE >= l_log_level) THEN
9955: IF (x_return_status = g_ret_success) THEN

Line 10012: if l_return_status = FND_API.G_RET_STS_SUCCESS then

10008: x_error_count => l_error_count ,
10009: x_error_msg => l_error_msg
10010: );
10011:
10012: if l_return_status = FND_API.G_RET_STS_SUCCESS then
10013: IF (l_debug='Y') THEN
10014: fnd_file.put_line(fnd_file.log, 'WSM_Serial_support_PVT.Update_attr_move returned Success');
10015: END IF;
10016: ELSE

Line 10022: p_encoded => FND_API.G_FALSE

10018: fnd_file.put_line(fnd_file.log, l_error_msg);
10019: ELSIF (l_error_count > 1) THEN
10020: FOR i IN 1..l_error_count LOOP
10021: l_error_msg := fnd_msg_pub.get( p_msg_index => l_error_count - i + 1,
10022: p_encoded => FND_API.G_FALSE
10023: );
10024: fnd_file.put_line(fnd_file.log, l_error_msg);
10025: END LOOP;
10026: ELSE

Line 10089: if l_return_status = FND_API.G_RET_STS_SUCCESS then

10085: x_error_count => l_error_msg ,
10086: x_error_msg => l_error_count
10087: );
10088:
10089: if l_return_status = FND_API.G_RET_STS_SUCCESS then
10090: IF (l_debug='Y') THEN
10091: fnd_file.put_line(fnd_file.log, 'WSM_Serial_support_PVT.Insert_attr_WSTI returned Success');
10092: END IF;
10093:

Line 10120: p_encoded => FND_API.G_FALSE

10116: fnd_file.put_line(fnd_file.log, l_error_msg);
10117: ELSIF (l_error_count > 1) THEN
10118: FOR i IN 1..l_error_count LOOP
10119: l_error_msg := fnd_msg_pub.get( p_msg_index => l_error_count - i + 1,
10120: p_encoded => FND_API.G_FALSE
10121: );
10122: fnd_file.put_line(fnd_file.log, l_error_msg);
10123: END LOOP;
10124: ELSE

Line 10206: p_commit => null, --fnd_api.g_true,

10202:
10203:
10204: l_stmt_num := 240;
10205: Wip_movProc_grp.processInterface(p_groupID => l_wmti_group_id,
10206: p_commit => null, --fnd_api.g_true,
10207: x_returnStatus => x_returnStatus);
10208: /***
10209: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
10210: DECLARE

Line 10256: IF (x_returnStatus=fnd_api.g_ret_sts_unexp_error) THEN

10252: END LOOP;
10253: END;
10254: END IF;
10255: **/
10256: IF (x_returnStatus=fnd_api.g_ret_sts_unexp_error) THEN
10257: --move enh? this logic is based on the fact that after going through osfm validations wip api
10258: --should not throw any errors and if errors are encountered we will rollback and exit the worker
10259: --Checks for such errors should be added to osfm validations.
10260: DECLARE

Line 10297: ELSIF (x_returnStatus=fnd_api.g_ret_sts_success) THEN

10293: p_run_log_level => l_log_level
10294: );
10295: END IF;
10296: raise e_proc_exception;
10297: ELSIF (x_returnStatus=fnd_api.g_ret_sts_success) THEN
10298: l_wmti_err_txns := 0;
10299:
10300: SELECT count(*)
10301: INTO l_wmti_err_txns

Line 10968: if l_return_status = FND_API.G_RET_STS_SUCCESS then

10964: x_error_count => l_error_count ,
10965: x_error_msg => l_error_msg
10966: );
10967:
10968: if l_return_status = FND_API.G_RET_STS_SUCCESS then
10969: IF (l_debug='Y') THEN
10970: fnd_file.put_line(fnd_file.log, 'WSM_Serial_support_PVT.Update_attr_move returned Success');
10971: END IF;
10972: ELSE

Line 10978: p_encoded => FND_API.G_FALSE

10974: fnd_file.put_line(fnd_file.log, l_error_msg);
10975: ELSIF (l_error_count > 1) THEN
10976: FOR i IN 1..l_error_count LOOP
10977: l_error_msg := fnd_msg_pub.get( p_msg_index => l_error_count - i + 1,
10978: p_encoded => FND_API.G_FALSE
10979: );
10980: fnd_file.put_line(fnd_file.log, l_error_msg);
10981: END LOOP;
10982: ELSE

Line 11152: WHEN FND_API.G_EXC_ERROR THEN

11148: );
11149: END IF;
11150:
11151: EXCEPTION
11152: WHEN FND_API.G_EXC_ERROR THEN
11153: IF (x_return_status = g_ret_success) THEN
11154: l_msg_tokens.delete;
11155: WSM_log_PVT.logMessage (
11156: p_module_name => l_module,

Line 11157: p_msg_text => 'inside WHEN FND_API.G_EXC_ERROR THEN',

11153: IF (x_return_status = g_ret_success) THEN
11154: l_msg_tokens.delete;
11155: WSM_log_PVT.logMessage (
11156: p_module_name => l_module,
11157: p_msg_text => 'inside WHEN FND_API.G_EXC_ERROR THEN',
11158: p_stmt_num => l_stmt_num,
11159: p_msg_tokens => l_msg_tokens,
11160: p_fnd_log_level => G_LOG_LEVEL_PROCEDURE,
11161: p_run_log_level => l_log_level

Line 11173: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

11169: WLMTI.LAST_UPDATE_DATE = SYSDATE
11170: WHERE WLMTI.GROUP_ID = p_group_id
11171: AND WLMTI.STATUS in (g_pending, g_running) ;
11172:
11173: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
11174: IF (x_return_status = g_ret_success) THEN
11175: l_msg_tokens.delete;
11176: WSM_log_PVT.logMessage (
11177: p_module_name => l_module,

Line 11178: p_msg_text => 'inside WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN',

11174: IF (x_return_status = g_ret_success) THEN
11175: l_msg_tokens.delete;
11176: WSM_log_PVT.logMessage (
11177: p_module_name => l_module,
11178: p_msg_text => 'inside WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN',
11179: p_stmt_num => l_stmt_num,
11180: p_msg_tokens => l_msg_tokens,
11181: p_fnd_log_level => G_LOG_LEVEL_PROCEDURE,
11182: p_run_log_level => l_log_level

Line 11562: p_init_msg_list => fnd_api.g_false,

11558: WHERE MTL.transaction_header_id = p_mtl_txn_hdr_id;
11559:
11560: retcode := INV_TXN_MANAGER_GRP.Validate_Transactions(
11561: p_api_version => 1.0,
11562: p_init_msg_list => fnd_api.g_false,
11563: p_validation_level => fnd_api.g_valid_level_full,
11564: p_header_id => p_mtl_txn_hdr_id,
11565: x_return_status => x_return_status,
11566: x_msg_count => x_msg_count,

Line 11563: p_validation_level => fnd_api.g_valid_level_full,

11559:
11560: retcode := INV_TXN_MANAGER_GRP.Validate_Transactions(
11561: p_api_version => 1.0,
11562: p_init_msg_list => fnd_api.g_false,
11563: p_validation_level => fnd_api.g_valid_level_full,
11564: p_header_id => p_mtl_txn_hdr_id,
11565: x_return_status => x_return_status,
11566: x_msg_count => x_msg_count,
11567: x_msg_data => x_msg_data,

Line 11631: RAISE FND_API.G_EXC_ERROR;

11627: );
11628: END IF;
11629: end loop;
11630:
11631: RAISE FND_API.G_EXC_ERROR;
11632: END IF;
11633:
11634: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
11635: l_msg_tokens.delete;

Line 11660: RAISE FND_API.G_EXC_ERROR;

11656: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
11657: p_run_log_level => l_log_level
11658: );
11659: END IF;
11660: RAISE FND_API.G_EXC_ERROR;
11661: ELSIF (x_return_status = g_ret_unexpected) THEN
11662: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11663: END IF;
11664: END IF; --(l_mti_rows > 0)

Line 11662: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

11658: );
11659: END IF;
11660: RAISE FND_API.G_EXC_ERROR;
11661: ELSIF (x_return_status = g_ret_unexpected) THEN
11662: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11663: END IF;
11664: END IF; --(l_mti_rows > 0)
11665: END;
11666: ELSE --p_transaction_type IN (g_undo_txn, g_ret_txn)

Line 11681: RAISE FND_API.G_EXC_ERROR;

11677: x_error_msg => x_msg_data
11678: );
11679:
11680: IF (x_return_status = g_ret_error) THEN
11681: RAISE FND_API.G_EXC_ERROR;
11682: ELSIF (x_return_status = g_ret_unexpected) THEN
11683: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11684: END IF;
11685:

Line 11683: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

11679:
11680: IF (x_return_status = g_ret_error) THEN
11681: RAISE FND_API.G_EXC_ERROR;
11682: ELSIF (x_return_status = g_ret_unexpected) THEN
11683: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11684: END IF;
11685:
11686: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
11687:

Line 11965: RAISE FND_API.G_EXC_ERROR;

11961: END LOOP;
11962: END;
11963: */
11964: IF retcode > 0 THEN
11965: RAISE FND_API.G_EXC_ERROR;
11966: ELSIF retcode < 0 THEN
11967: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11968: END IF;
11969:

Line 11967: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

11963: */
11964: IF retcode > 0 THEN
11965: RAISE FND_API.G_EXC_ERROR;
11966: ELSIF retcode < 0 THEN
11967: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11968: END IF;
11969:
11970: FND_MSG_PUB.Count_And_Get
11971: ( p_count => x_msg_count ,

Line 11988: WHEN FND_API.G_EXC_ERROR THEN

11984: );
11985: END IF;
11986:
11987: EXCEPTION
11988: WHEN FND_API.G_EXC_ERROR THEN
11989: ROLLBACK;
11990: x_return_status := G_RET_ERROR;
11991: FND_MSG_PUB.Count_And_Get
11992: ( p_count => x_msg_count ,

Line 11997: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

11993: p_data => x_msg_data
11994: );
11995:
11996:
11997: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
11998: ROLLBACK;
11999: x_return_status := G_RET_UNEXPECTED;
12000: FND_MSG_PUB.Count_And_Get
12001: ( p_count => x_msg_count ,

Line 12245: RAISE FND_API.G_EXC_ERROR;

12241: p_fnd_log_level => G_LOG_LEVEL_ERROR,
12242: p_run_log_level => l_log_level
12243: );
12244: END IF;
12245: RAISE FND_API.G_EXC_ERROR;
12246: END IF;
12247: ELSE
12248: IF l_bos_to_move_mandatory_flag = 1 THEN
12249: IF g_log_level_error >= l_log_level OR

Line 12264: RAISE FND_API.G_EXC_ERROR;

12260: p_fnd_log_level => G_LOG_LEVEL_ERROR,
12261: p_run_log_level => l_log_level
12262: );
12263: END IF;
12264: RAISE FND_API.G_EXC_ERROR;
12265: END IF;
12266: END IF;
12267: END IF;
12268: ************************/

Line 12291: RAISE FND_API.G_EXC_ERROR;

12287: p_fnd_log_level => G_LOG_LEVEL_ERROR,
12288: p_run_log_level => l_log_level
12289: );
12290: END IF;
12291: RAISE FND_API.G_EXC_ERROR;
12292: END IF;
12293: ********/
12294: IF l_wip_scrap_enabled_flag = 2 THEN
12295: x_show_scrap_qty := 0;

Line 12617: WHEN FND_API.G_EXC_ERROR THEN

12613: );
12614: END IF;
12615:
12616: EXCEPTION
12617: WHEN FND_API.G_EXC_ERROR THEN
12618: x_return_status := G_RET_ERROR;
12619: FND_MSG_PUB.Count_And_Get
12620: ( p_count => x_msg_count ,
12621: p_data => x_msg_data

Line 12624: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

12620: ( p_count => x_msg_count ,
12621: p_data => x_msg_data
12622: );
12623:
12624: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
12625: x_return_status := G_RET_UNEXPECTED;
12626: FND_MSG_PUB.Count_And_Get
12627: ( p_count => x_msg_count ,
12628: p_data => x_msg_data

Line 12899: WHEN FND_API.G_EXC_ERROR THEN

12895: p_data => x_msg_data
12896: );
12897:
12898: EXCEPTION
12899: WHEN FND_API.G_EXC_ERROR THEN
12900: x_return_status := G_RET_ERROR;
12901: FND_MSG_PUB.Count_And_Get
12902: ( p_count => x_msg_count ,
12903: p_data => x_msg_data

Line 12907: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

12903: p_data => x_msg_data
12904: );
12905:
12906:
12907: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
12908: x_return_status := G_RET_UNEXPECTED;
12909: FND_MSG_PUB.Count_And_Get
12910: ( p_count => x_msg_count ,
12911: p_data => x_msg_data