435: );
436: END IF;
437:
438: IF( x_result = wip_constants.no ) THEN
439: fnd_message.set_name ('WIP', 'WIP_OC_TOLERANCE_FAIL');
440: p_err_mesg := fnd_message.get;
441: --p_err_mesg := 'Transaction violates Tolerance Level';
442: ELSE
443: IF(p_child_txn_id IS NULL OR
436: END IF;
437:
438: IF( x_result = wip_constants.no ) THEN
439: fnd_message.set_name ('WIP', 'WIP_OC_TOLERANCE_FAIL');
440: p_err_mesg := fnd_message.get;
441: --p_err_mesg := 'Transaction violates Tolerance Level';
442: ELSE
443: IF(p_child_txn_id IS NULL OR
444: p_child_txn_id = -1 OR
925: WHERE completion_transaction_id = p_parent_cpl_txn_id
926: AND transaction_action_id = wip_constants.cplassy_action;
927:
928: IF( x_result = wip_constants.no ) THEN
929: fnd_message.set_name ('WIP', 'WIP_OC_TOLERANCE_FAIL');
930: p_err_mesg := fnd_message.get;
931: --p_err_mesg := 'Transaction violates Tolerance Level';
932:
933: ELSE
926: AND transaction_action_id = wip_constants.cplassy_action;
927:
928: IF( x_result = wip_constants.no ) THEN
929: fnd_message.set_name ('WIP', 'WIP_OC_TOLERANCE_FAIL');
930: p_err_mesg := fnd_message.get;
931: --p_err_mesg := 'Transaction violates Tolerance Level';
932:
933: ELSE
934: if(p_child_txn_id is null or