DBA Data[Home] [Help]

APPS.CSD_HV_WIP_JOB_PVT dependencies on WIP_OPERATIONS_PKG

Line 9485: WIP_OPERATIONS_PKG.Valid_Op_Delete(p_organization_id => p_organization_id,

9481: lc_mod_name||'.begin',
9482: 'Entering procedure is_delete_wip_op_valid' );
9483: END IF;
9484:
9485: WIP_OPERATIONS_PKG.Valid_Op_Delete(p_organization_id => p_organization_id,
9486: p_wip_entity_id => p_wip_entity_id,
9487: p_operation_seq_num => p_operation_seq_num,
9488: x_return_status => l_return_status,
9489: x_error_message => l_error_message);

Line 9495: 'WIP_OPERATIONS_PKG.Valid_Op_Delete returned success.' );

9491: IF (l_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
9492: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
9493: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE,
9494: lc_mod_name,
9495: 'WIP_OPERATIONS_PKG.Valid_Op_Delete returned success.' );
9496: END IF;
9497:
9498: open c_time_clock_entries_exist;
9499: fetch c_time_clock_entries_exist

Line 9539: 'WIP_OPERATIONS_PKG.Valid_Op_Delete returned non-success value: ' || l_return_status );

9535:
9536: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
9537: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE,
9538: lc_mod_name,
9539: 'WIP_OPERATIONS_PKG.Valid_Op_Delete returned non-success value: ' || l_return_status );
9540: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE,
9541: lc_mod_name,
9542: 'WIP_OPERATIONS_PKG.Valid_Op_Delete returned error message: ' || l_error_message );
9543: END IF;

Line 9542: 'WIP_OPERATIONS_PKG.Valid_Op_Delete returned error message: ' || l_error_message );

9538: lc_mod_name,
9539: 'WIP_OPERATIONS_PKG.Valid_Op_Delete returned non-success value: ' || l_return_status );
9540: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE,
9541: lc_mod_name,
9542: 'WIP_OPERATIONS_PKG.Valid_Op_Delete returned error message: ' || l_error_message );
9543: END IF;
9544: return lc_not_valid;
9545:
9546: EXCEPTION

Line 9551: 'WIP_OPERATIONS_PKG.Valid_Op_Delete threw exception');

9547: WHEN OTHERS THEN
9548: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
9549: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE,
9550: lc_mod_name,
9551: 'WIP_OPERATIONS_PKG.Valid_Op_Delete threw exception');
9552: END IF;
9553:
9554: return lc_not_valid;
9555:

Line 9650: 'Just before calling WIP_OPERATIONS_PKG.Delete_Operation');

9646:
9647: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
9648: FND_LOG.STRING( FND_LOG.LEVEL_EVENT,
9649: lc_mod_name||'beforecallinsertjobdtls',
9650: 'Just before calling WIP_OPERATIONS_PKG.Delete_Operation');
9651: END IF;
9652:
9653:
9654: WIP_OPERATIONS_PKG.Delete_Operation(p_organization_id => p_op_dtls.organization_id,

Line 9654: WIP_OPERATIONS_PKG.Delete_Operation(p_organization_id => p_op_dtls.organization_id,

9650: 'Just before calling WIP_OPERATIONS_PKG.Delete_Operation');
9651: END IF;
9652:
9653:
9654: WIP_OPERATIONS_PKG.Delete_Operation(p_organization_id => p_op_dtls.organization_id,
9655: p_wip_entity_id => p_op_dtls.wip_entity_id,
9656: p_operation_seq_num => p_op_dtls.operation_seq_num,
9657: x_return_status => l_return_status,
9658: x_error_message => l_error_message);

Line 9664: 'Error during WIP_OPERATIONS_PKG.Delete_Operation: ' || l_error_message);

9660: If (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
9661: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
9662: FND_LOG.STRING( FND_LOG.LEVEL_EVENT,
9663: lc_mod_name,
9664: 'Error during WIP_OPERATIONS_PKG.Delete_Operation: ' || l_error_message);
9665: END IF;
9666:
9667: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
9668: fnd_message.set_token('MESSAGE', l_error_message);