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 8954: if l_return_status = FND_API.G_RET_STS_SUCCESS then

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

Line 8985: p_encoded => FND_API.G_FALSE

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

Line 9343: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 9495: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 9916: p_commit => FND_API.G_FALSE,

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

Line 9917: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

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

Line 9918: p_init_msg_list => FND_API.G_FALSE,

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

Line 9951: RAISE FND_API.G_EXC_ERROR;

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

Line 9953: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 10014: if l_return_status = FND_API.G_RET_STS_SUCCESS then

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

Line 10024: p_encoded => FND_API.G_FALSE

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

Line 10091: if l_return_status = FND_API.G_RET_STS_SUCCESS then

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

Line 10122: p_encoded => FND_API.G_FALSE

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

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

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

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

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

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

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

Line 10970: if l_return_status = FND_API.G_RET_STS_SUCCESS then

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

Line 10980: p_encoded => FND_API.G_FALSE

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

Line 11154: WHEN FND_API.G_EXC_ERROR THEN

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

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

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

Line 11175: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

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

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

Line 11564: p_init_msg_list => fnd_api.g_false,

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

Line 11565: p_validation_level => fnd_api.g_valid_level_full,

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

Line 11633: RAISE FND_API.G_EXC_ERROR;

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

Line 11662: RAISE FND_API.G_EXC_ERROR;

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

Line 11664: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 11683: RAISE FND_API.G_EXC_ERROR;

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

Line 11685: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 11967: RAISE FND_API.G_EXC_ERROR;

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

Line 11969: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 11990: WHEN FND_API.G_EXC_ERROR THEN

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

Line 11999: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 12247: RAISE FND_API.G_EXC_ERROR;

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

Line 12266: RAISE FND_API.G_EXC_ERROR;

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

Line 12293: RAISE FND_API.G_EXC_ERROR;

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

Line 12619: WHEN FND_API.G_EXC_ERROR THEN

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

Line 12626: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 12901: WHEN FND_API.G_EXC_ERROR THEN

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

Line 12909: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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