APPS.WSH_XC_UTIL dependencies on WSH_EXCEPTIONS_S

Line 582: -- Bug 6615016 using the wsh_exceptions_s.nextval directly in the insert statement.

578: WSH_DEBUG_SV.logmsg(l_module_name,'Logging exception with severity '||l_severity||' , status '||l_status ,WSH_DEBUG_SV.C_PROC_LEVEL);
579: END IF;
580:
581: -- populate l_exception_id
582: -- Bug 6615016 using the wsh_exceptions_s.nextval directly in the insert statement.
583: -- SELECT wsh_exceptions_s.nextval INTO l_exception_id FROM SYS.DUAL;
584:
585: IF l_debug_on THEN
586: wsh_debug_sv.logmsg(l_module_name, '**** Actual values ****');

Line 583: -- SELECT wsh_exceptions_s.nextval INTO l_exception_id FROM SYS.DUAL;

579: END IF;
580:
581: -- populate l_exception_id
582: -- Bug 6615016 using the wsh_exceptions_s.nextval directly in the insert statement.
583: -- SELECT wsh_exceptions_s.nextval INTO l_exception_id FROM SYS.DUAL;
584:
585: IF l_debug_on THEN
586: wsh_debug_sv.logmsg(l_module_name, '**** Actual values ****');
587: -- Bug 6615016

Line 679: -- Bug 6615016 using the wsh_exceptions_s.nextval directly in the insert statement.

675: program_id,
676: program_update_date
677: )
678: VALUES (
679: -- Bug 6615016 using the wsh_exceptions_s.nextval directly in the insert statement.
680: --l_exception_id,
681: wsh_exceptions_s.nextval,
682: p_exception_location_id,
683: p_logged_at_location_id,

Line 681: wsh_exceptions_s.nextval,

677: )
678: VALUES (
679: -- Bug 6615016 using the wsh_exceptions_s.nextval directly in the insert statement.
680: --l_exception_id,
681: wsh_exceptions_s.nextval,
682: p_exception_location_id,
683: p_logged_at_location_id,
684: UPPER(p_logging_entity),
685: p_logging_entity_id,

Line 5196: x_severity OUT NOCOPY WSH_EXCEPTIONS.SEVERITY%TYPE,

5192: ----------------------------------------------------------
5193: PROCEDURE GET_OTM_DELIVERY_EXCEPTION
5194: (p_delivery_id IN WSH_NEW_DELIVERIES.DELIVERY_ID%TYPE,
5195: x_exception_name OUT NOCOPY WSH_EXCEPTIONS.EXCEPTION_NAME%TYPE,
5196: x_severity OUT NOCOPY WSH_EXCEPTIONS.SEVERITY%TYPE,
5197: x_return_status OUT NOCOPY VARCHAR2) IS
5198:
5199: --this cursor gets the delivery's otm exceptions ordered by severity
5200: --we used order by 1 to take advantage of the alphabetical order of ERROR and WARNING

Line 5214: l_severity WSH_EXCEPTIONS.SEVERITY%TYPE;

5210: ('WSH_OTM_DEL_CREATE_REQ','WSH_OTM_DEL_UPDATE_REQ',
5211: 'WSH_OTM_DEL_AWAIT_TRIP')
5212: ORDER BY rank ASC;
5213:
5214: l_severity WSH_EXCEPTIONS.SEVERITY%TYPE;
5215: l_exception_name WSH_EXCEPTIONS.EXCEPTION_NAME%TYPE;
5216: l_rank NUMBER;
5217:
5218: l_debug_on BOOLEAN;