[Home] [Help]
1779: WHERE transaction_id = l_rs_txn.txn_id
1780: AND group_id = p_gib.group_id;
1781:
1782: -- Get error from message stack
1783: wip_utilities.get_message_stack(p_msg =>l_msg);
1784: IF(l_msg IS NULL) THEN
1785: -- initialize message to something because we cannot insert
1786: -- null into WIP_TXN_INTERFACE_ERRORS
1787: fnd_message.set_name('WIP', 'WIP_SOME_RECORDS_ERROR');
2245: l_step := l_dj_txn.to_step;
2246: END IF;
2247: -- update current serial location to WMTI.TO_OPERATION_SEQ_NUM and
2248: -- WMTI.INTRAOPERATION_STEP_TYPE
2249: wip_utilities.update_serial(
2250: p_serial_number => l_ser_loc.serial,
2251: p_inventory_item_id => l_dj_txn.item_id,
2252: p_organization_id => l_dj_txn.org_id,
2253: p_wip_entity_id => l_dj_txn.wip_id,
2256: p_intraoperation_step_type => l_step,
2257: x_return_status => l_returnStatus);
2258:
2259: IF(l_returnStatus <> fnd_api.g_ret_sts_success) THEN
2260: l_errMsg := 'wip_utilities.update_serial failed';
2261: raise fnd_api.g_exc_unexpected_error;
2262: END IF;
2263: END IF; -- IF(l_dj_txn.txn_type
2264: END LOOP; -- l_ser_loc IN c_ser_loc
2457: SET process_status = WIP_CONSTANTS.ERROR
2458: WHERE transaction_id = l_dj_txn.txn_id
2459: AND group_id = p_gib.group_id;
2460: -- Get error from message stack
2461: wip_utilities.get_message_stack(p_msg =>l_msg);
2462: IF(l_msg IS NULL) THEN
2463: -- initialize message to something because we cannot insert
2464: -- null into WIP_TXN_INTERFACE_ERRORS
2465: fnd_message.set_name('WIP', 'WIP_SOME_RECORDS_ERROR');
10185: END IF; -- check entity type
10186: EXCEPTION
10187: WHEN fnd_api.g_exc_unexpected_error THEN
10188: ROLLBACK TO SAVEPOINT s_backflush_proc;
10189: wip_utilities.get_message_stack(p_msg =>l_errMsg);
10190: IF(l_errMsg IS NULL) THEN
10191: -- initialize message to something because we cannot
10192: -- insert null into WIP_TXN_INTERFACE_ERRORS
10193: fnd_message.set_name('WIP', 'WIP_SOME_RECORDS_ERROR');
10346: WHERE group_id = p_group_id
10347: AND process_status = WIP_CONSTANTS.RUNNING
10348: AND TRUNC(transaction_date)= TRUNC(l_gib.txn_date);
10349:
10350: wip_utilities.get_message_stack(p_msg =>l_errMsg);
10351: IF(l_errMsg IS NULL) THEN
10352: -- initialize message to something because we cannot insert null
10353: -- into WIP_TXN_INTERFACE_ERRORS
10354: fnd_message.set_name('WIP', 'WIP_SOME_RECORDS_ERROR');
10626: retcode := 2; -- error
10627: -- Fixed bug 5355443. Since WIP_SOME_RECORDS_ERROR message is only
10628: -- applicable to background transaction, we should set error message here
10629: -- instead of wip_movProc_priv.processIntf().
10630: --wip_utilities.get_message_stack(p_msg =>errbuf);
10631: fnd_message.set_name('WIP', 'WIP_SOME_RECORDS_ERROR');
10632: errbuf := fnd_message.get;
10633: END IF;
10634: COMMIT; -- To prevent Move Worker concurrent program rollback.
11077: END IF;
11078:
11079: /* Start: VJ Label Printing */
11080: IF (p_print_label = 1) THEN
11081: wip_utilities.print_move_txn_label(p_txn_id => p_group_id,
11082: x_status => l_return_status,
11083: x_msg_count => l_msg_count,
11084: x_msg => l_error_msg);
11085: -- do not error out if label printing, only put warning message in log
11083: x_msg_count => l_msg_count,
11084: x_msg => l_error_msg);
11085: -- do not error out if label printing, only put warning message in log
11086: IF(l_return_status <> fnd_api.g_ret_sts_success) THEN
11087: wip_utilities.get_message_stack(p_msg => l_msg_stack);
11088: IF (l_log_level <= wip_constants.full_logging) THEN
11089: wip_logger.log(p_msg => 'An error has occurred with label printing.\n' ||
11090: 'The following error has occurred during ' ||
11091: 'printing: ' || l_msg_stack || '\n' ||