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.WSH_XC_UTIL dependencies on WSH_EXCEPTIONS

Line 314: FROM wsh_exceptions

310: logging_entity,
311: logging_entity_id,
312: exception_location_id,
313: manually_logged
314: FROM wsh_exceptions
315: WHERE exception_id = c_exception_id FOR UPDATE;
316:
317:
318: -- local variables

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 614: INSERT INTO wsh_exceptions(

610: l_msg_name := 'WSH_MISSING_DETAILS';
611: raise WSH_XC_INVALID_OPERATION;
612: END IF;
613: --
614: INSERT INTO wsh_exceptions(
615: exception_id,
616: exception_location_id,
617: logged_at_location_id,
618: logging_entity,

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 1286: UPDATE wsh_exceptions

1282: END IF;
1283: END IF;
1284:
1285:
1286: UPDATE wsh_exceptions
1287: SET
1288: logged_at_location_id = l_xcp_record.logged_at_location_id,
1289: logging_entity = l_xcp_record.logging_entity,
1290: logging_entity_id = l_xcp_record.logging_entity_id,

Line 1744: FROM wsh_exceptions

1740: 'NOT_HANDLED','NO_ACTION_REQUIRED' ,
1741: NULL,'NO_ACTION_REQUIRED' ,
1742: UPPER(status)
1743: )
1744: FROM wsh_exceptions
1745: WHERE exception_id = c_exception_id2;
1746:
1747: CURSOR C2(c_exception_id NUMBER) IS
1748: SELECT UPPER(default_severity), UPPER(exception_handling),

Line 1753: FROM wsh_exceptions

1749: UPPER(initiate_workflow)
1750: FROM wsh_exception_definitions_vl
1751: WHERE exception_name = (
1752: SELECT exception_name
1753: FROM wsh_exceptions
1754: WHERE exception_id = c_exception_id);
1755:
1756: l_exception_name VARCHAR2(30);
1757: l_new_status VARCHAR2(30) := NULL;

Line 1906: UPDATE wsh_exceptions

1902: RAISE WSH_XC_OTM_ERROR;
1903: END IF;
1904: -- OTM R12 end of glog project
1905:
1906: UPDATE wsh_exceptions
1907: SET status = l_new_status,
1908: last_update_date = SYSDATE,
1909: last_updated_by = FND_GLOBAL.USER_ID,
1910: last_update_login = FND_GLOBAL.LOGIN_ID

Line 3086: -- description: called by the view WSH_EXCEPTIONS_V to get meaning

3082:
3083:
3084: -- ---------------------------------------------------------------------
3085: -- function: Get_Lookup_Meaning
3086: -- description: called by the view WSH_EXCEPTIONS_V to get meaning
3087: -- for EXCEPTION_SEVERITY and LOGGING_ENTITY
3088: --
3089: -- return: meaning
3090: -- ---------------------------------------------------------------------

Line 3259: from wsh_exceptions we

3255:
3256:
3257: /*CURSOR c_exceptions IS
3258: select we.rowid
3259: from wsh_exceptions we
3260: where
3261: nvl(we.request_id,-999) = nvl(p_request_id , nvl(we.request_id,-999))
3262: and nvl(we.exception_name,'XXX') = nvl(p_exception_name, nvl(we.exception_name,'XXX'))
3263: and we.logging_entity = nvl(p_logging_entity, we.logging_entity )

Line 3291: from wsh_delivery_assignments_v a, wsh_exceptions b

3287: and nvl(TO_CHAR(nvl(p_departure_date_to,nvl(we.departure_date,sysdate)),'YYYY/MM/DD') ,
3288: to_char(nvl(we.departure_date,sysdate),'YYYY/MM/DD') )
3289: and (sysdate - we.creation_date) > nvl(p_data_older_no_of_days,(sysdate - we.creation_date - 1))
3290: and ( (we.delivery_detail_id in (select distinct a.delivery_detail_id
3291: from wsh_delivery_assignments_v a, wsh_exceptions b
3292: where a.delivery_detail_id=b.delivery_detail_id
3293: and a.delivery_id=p_delivery_id)
3294: AND p_delivery_id is not null
3295: AND p_delivery_contents = 'Y')

Line 3427: UPDATE WSH_EXCEPTIONS

3423: l_use_dynamic := 'N';
3424: -- FP bug 4370532: this is the only context where
3425: -- action C_ACTION_SEMICLOSED can be used.
3426: IF (p_action = C_ACTION_SEMICLOSED) THEN
3427: UPDATE WSH_EXCEPTIONS
3428: SET status= 'CLOSED',
3429: last_update_date = sysdate,
3430: last_updated_by = FND_GLOBAL.USER_ID,
3431: last_update_login = FND_GLOBAL.USER_ID

Line 3436: UPDATE WSH_EXCEPTIONS

3432: WHERE trip_id = p_trip_id
3433: AND status <> 'CLOSED'
3434: AND severity <> 'INFO';
3435: ELSE
3436: UPDATE WSH_EXCEPTIONS
3437: SET status= 'CLOSED',
3438: last_update_date = sysdate,
3439: last_updated_by = FND_GLOBAL.USER_ID,
3440: last_update_login = FND_GLOBAL.USER_ID

Line 3455: UPDATE WSH_EXCEPTIONS

3451: l_use_dynamic := 'N';
3452: -- FP bug 4370532: this is the only context where
3453: -- action C_ACTION_SEMICLOSED can be used.
3454: IF (p_action = C_ACTION_SEMICLOSED) THEN
3455: UPDATE WSH_EXCEPTIONS
3456: SET status='CLOSED',
3457: last_update_date = sysdate,
3458: last_updated_by = FND_GLOBAL.USER_ID,
3459: last_update_login = FND_GLOBAL.USER_ID

Line 3464: UPDATE WSH_EXCEPTIONS

3460: WHERE trip_stop_id = p_trip_stop_id
3461: AND status <> 'CLOSED'
3462: AND severity <> 'INFO';
3463: ELSE
3464: UPDATE WSH_EXCEPTIONS
3465: SET status='CLOSED',
3466: last_update_date = sysdate,
3467: last_updated_by = FND_GLOBAL.USER_ID,
3468: last_update_login = FND_GLOBAL.USER_ID

Line 3486: -- the total number of queries on WSH_EXCEPTIONS.

3482: -- FP bug 4370532: this is the only context where
3483: -- action C_ACTION_SEMICLOSED can be used.
3484: IF (p_action = C_ACTION_SEMICLOSED) THEN
3485: -- performance bug 5257207: SC-11: split UPDATE to reduce
3486: -- the total number of queries on WSH_EXCEPTIONS.
3487: --
3488: -- This code is part of the ship confirm flow.
3489:
3490: UPDATE WSH_EXCEPTIONS

Line 3490: UPDATE WSH_EXCEPTIONS

3486: -- the total number of queries on WSH_EXCEPTIONS.
3487: --
3488: -- This code is part of the ship confirm flow.
3489:
3490: UPDATE WSH_EXCEPTIONS
3491: SET status = C_STATUS_CLOSED,
3492: last_update_date = sysdate,
3493: last_updated_by = FND_GLOBAL.USER_ID,
3494: last_update_login = FND_GLOBAL.USER_ID

Line 3504: UPDATE WSH_EXCEPTIONS

3500: AND severity <> C_SEVERITY_INFO;
3501:
3502: l_count := SQL%rowcount;
3503:
3504: UPDATE WSH_EXCEPTIONS
3505: SET status = C_STATUS_CLOSED,
3506: last_update_date = sysdate,
3507: last_updated_by = FND_GLOBAL.USER_ID,
3508: last_update_login = FND_GLOBAL.USER_ID

Line 3517: UPDATE WSH_EXCEPTIONS

3513: l_count := l_count + SQL%rowcount;
3514:
3515: ELSE
3516: -- UPDATES are tuned the same way as above.
3517: UPDATE WSH_EXCEPTIONS
3518: SET status = p_action,
3519: last_update_date = sysdate,
3520: last_updated_by = FND_GLOBAL.USER_ID,
3521: last_update_login = FND_GLOBAL.USER_ID

Line 3530: UPDATE WSH_EXCEPTIONS

3526: AND status <> C_STATUS_CLOSED;
3527:
3528: l_count := SQL%rowcount;
3529:
3530: UPDATE WSH_EXCEPTIONS
3531: SET status = p_action,
3532: last_update_date = sysdate,
3533: last_updated_by = FND_GLOBAL.USER_ID,
3534: last_update_login = FND_GLOBAL.USER_ID

Line 3547: UPDATE WSH_EXCEPTIONS

3543:
3544: -- bug 4318747: this is the only context where
3545: -- action C_ACTION_SEMICLOSED can be used.
3546: IF (p_action = C_ACTION_SEMICLOSED) THEN
3547: UPDATE WSH_EXCEPTIONS
3548: SET status='CLOSED',
3549: last_update_date = sysdate,
3550: last_updated_by = FND_GLOBAL.USER_ID,
3551: last_update_login = FND_GLOBAL.USER_ID

Line 3558: UPDATE WSH_EXCEPTIONS

3554: AND severity <> 'INFO'
3555: --AND exception_name <> 'WSH_OTM_SHIPMENT_ERROR'; -- OTM R12 glog project;
3556: AND exception_name <> C_OTM_EXC_NAME; -- OTM R12 glog project;
3557: ELSE
3558: UPDATE WSH_EXCEPTIONS
3559: SET status='CLOSED',
3560: last_update_date = sysdate,
3561: last_updated_by = FND_GLOBAL.USER_ID,
3562: last_update_login = FND_GLOBAL.USER_ID

Line 3577: UPDATE WSH_EXCEPTIONS

3573: p_trip_stop_id is NULL and
3574: p_delivery_id is NULL) THEN
3575:
3576: l_use_dynamic := 'N';
3577: UPDATE WSH_EXCEPTIONS
3578: SET status=p_action ,
3579: last_update_date = sysdate,
3580: last_updated_by = FND_GLOBAL.USER_ID,
3581: last_update_login = FND_GLOBAL.USER_ID

Line 3594: Exceptions_SQL := Exceptions_SQL || ' FROM WSH_EXCEPTIONS WE';

3590: IF l_use_dynamic = 'Y' THEN -- Dynamic cusrsor required
3591: --{
3592: -- Bug#3200314: Constructing the Dynamic Cursor.
3593: Exceptions_SQL := Exceptions_SQL || 'SELECT WE.ROWID';
3594: Exceptions_SQL := Exceptions_SQL || ' FROM WSH_EXCEPTIONS WE';
3595: Exceptions_SQL := Exceptions_SQL || ' WHERE';
3596: IF p_request_id IS NOT NULL THEN
3597: Exceptions_SQL := Exceptions_SQL || ' WE.REQUEST_ID = :p_request_id AND';
3598: bind_col_tab(bind_col_tab.COUNT+1) := TO_CHAR(p_request_id);

Line 3679: Temp_SQL := Temp_SQL || ' FROM WSH_EXCEPTIONS';

3675:
3676: IF p_delivery_id IS NOT NULL THEN
3677: IF p_delivery_contents = 'Y' THEN
3678: Temp_SQL := ' SELECT ROWID';
3679: Temp_SQL := Temp_SQL || ' FROM WSH_EXCEPTIONS';
3680: Temp_SQL := Temp_SQL || ' WHERE';
3681: Exceptions_SQL := Exceptions_SQL || ' WE.ROWID IN (';
3682: Exceptions_SQL := Exceptions_SQL || Temp_SQL;
3683: Exceptions_SQL := Exceptions_SQL || ' DELIVERY_DETAIL_ID IN';

Line 3685: Exceptions_SQL := Exceptions_SQL || ' FROM wsh_delivery_assignments_v a, wsh_exceptions b';

3681: Exceptions_SQL := Exceptions_SQL || ' WE.ROWID IN (';
3682: Exceptions_SQL := Exceptions_SQL || Temp_SQL;
3683: Exceptions_SQL := Exceptions_SQL || ' DELIVERY_DETAIL_ID IN';
3684: Exceptions_SQL := Exceptions_SQL || ' (SELECT DISTINCT a.delivery_detail_id';
3685: Exceptions_SQL := Exceptions_SQL || ' FROM wsh_delivery_assignments_v a, wsh_exceptions b';
3686: Exceptions_SQL := Exceptions_SQL || ' WHERE a.delivery_detail_id=b.delivery_detail_id';
3687: Exceptions_SQL := Exceptions_SQL || ' AND a.delivery_id= :p_delivery_id)';
3688: Exceptions_SQL := Exceptions_SQL || ' UNION ALL';
3689: bind_col_tab(bind_col_tab.COUNT+1) := TO_CHAR(p_delivery_id);

Line 3757: DELETE from WSH_EXCEPTIONS where rowid = RowIdList(l_counter);

3753: c_cfetch := c_exceptions%rowcount - c_pfetch;
3754: EXIT WHEN (c_cfetch=0);
3755: IF p_action='PURGE' THEN
3756: FORALL l_counter IN 1..c_cfetch
3757: DELETE from WSH_EXCEPTIONS where rowid = RowIdList(l_counter);
3758: ELSE -- 'CLOSED'
3759: FORALL l_counter IN 1..c_cfetch
3760: UPDATE WSH_EXCEPTIONS
3761: SET status=p_action ,

Line 3760: UPDATE WSH_EXCEPTIONS

3756: FORALL l_counter IN 1..c_cfetch
3757: DELETE from WSH_EXCEPTIONS where rowid = RowIdList(l_counter);
3758: ELSE -- 'CLOSED'
3759: FORALL l_counter IN 1..c_cfetch
3760: UPDATE WSH_EXCEPTIONS
3761: SET status=p_action ,
3762: last_update_date = sysdate,
3763: last_updated_by = FND_GLOBAL.USER_ID,
3764: last_update_login = FND_GLOBAL.USER_ID

Line 3918: FROM wsh_exceptions

3914: ) IS
3915:
3916: CURSOR Get_Trip_Exceptions (v_trip_id NUMBER) IS
3917: SELECT DECODE(severity,'HIGH','ERROR','MEDIUM','WARNING',severity)
3918: FROM wsh_exceptions
3919: WHERE trip_id = v_trip_id
3920: AND status in ('OPEN','ERROR','LOGGED','IN_PROCESS','MANUAL')
3921: AND severity in ('HIGH','MEDIUM','ERROR','WARNING')
3922: ORDER BY decode(severity,'HIGH',1,'ERROR',1,'MEDIUM',2,'WARNING',2,3);

Line 3926: FROM wsh_exceptions

3922: ORDER BY decode(severity,'HIGH',1,'ERROR',1,'MEDIUM',2,'WARNING',2,3);
3923:
3924: CURSOR Get_Stop_Exceptions (v_stop_id NUMBER) IS
3925: SELECT DECODE(severity,'HIGH','ERROR','MEDIUM','WARNING',severity)
3926: FROM wsh_exceptions
3927: WHERE trip_stop_id = v_stop_id
3928: AND status in ('OPEN','ERROR','LOGGED','IN_PROCESS','MANUAL')
3929: AND severity in ('HIGH','MEDIUM','ERROR','WARNING')
3930: ORDER BY decode(severity,'HIGH',1,'ERROR',1,'MEDIUM',2,'WARNING',2,3);

Line 3934: FROM wsh_exceptions

3930: ORDER BY decode(severity,'HIGH',1,'ERROR',1,'MEDIUM',2,'WARNING',2,3);
3931:
3932: CURSOR Get_Delivery_Exceptions (v_delivery_id NUMBER) IS
3933: SELECT DECODE(severity,'HIGH','ERROR','MEDIUM','WARNING',severity)
3934: FROM wsh_exceptions
3935: WHERE delivery_id = v_delivery_id
3936: AND status in ('OPEN','ERROR','LOGGED','IN_PROCESS','MANUAL')
3937: AND severity in ('HIGH','MEDIUM','ERROR','WARNING')
3938: ORDER BY decode(severity,'HIGH',1,'ERROR',1,'MEDIUM',2,'WARNING',2,3);

Line 3942: FROM wsh_exceptions

3938: ORDER BY decode(severity,'HIGH',1,'ERROR',1,'MEDIUM',2,'WARNING',2,3);
3939:
3940: CURSOR Get_Detail_Exceptions (v_detail_id NUMBER) IS
3941: SELECT DECODE(severity,'HIGH','ERROR','MEDIUM','WARNING',severity)
3942: FROM wsh_exceptions
3943: WHERE delivery_detail_id = v_detail_id
3944: AND status in ('OPEN','ERROR','LOGGED','IN_PROCESS','MANUAL')
3945: AND severity in ('HIGH','MEDIUM','ERROR','WARNING')
3946: ORDER BY decode(severity,'HIGH',1,'ERROR',1,'MEDIUM',2,'WARNING',2,3);

Line 4889: l_exception_id WSH_EXCEPTIONS.EXCEPTION_ID%TYPE;

4885: x_return_status OUT NOCOPY VARCHAR2) IS
4886:
4887: l_msg_count NUMBER;
4888: l_msg_data VARCHAR2(32767);
4889: l_exception_id WSH_EXCEPTIONS.EXCEPTION_ID%TYPE;
4890: l_exception_message WSH_EXCEPTIONS.MESSAGE%TYPE;
4891: l_num_error NUMBER;
4892: l_num_warn NUMBER;
4893: l_return_status VARCHAR2(1);

Line 4890: l_exception_message WSH_EXCEPTIONS.MESSAGE%TYPE;

4886:
4887: l_msg_count NUMBER;
4888: l_msg_data VARCHAR2(32767);
4889: l_exception_id WSH_EXCEPTIONS.EXCEPTION_ID%TYPE;
4890: l_exception_message WSH_EXCEPTIONS.MESSAGE%TYPE;
4891: l_num_error NUMBER;
4892: l_num_warn NUMBER;
4893: l_return_status VARCHAR2(1);
4894:

Line 5187: x_exception_name OUT NOCOPY WSH_EXCEPTIONS.EXCEPTION_NAME%TYPE,

5183: -- description: This procedure gets the delivery's OTM exception and severity
5184: ----------------------------------------------------------
5185: PROCEDURE GET_OTM_DELIVERY_EXCEPTION
5186: (p_delivery_id IN WSH_NEW_DELIVERIES.DELIVERY_ID%TYPE,
5187: x_exception_name OUT NOCOPY WSH_EXCEPTIONS.EXCEPTION_NAME%TYPE,
5188: x_severity OUT NOCOPY WSH_EXCEPTIONS.SEVERITY%TYPE,
5189: x_return_status OUT NOCOPY VARCHAR2) IS
5190:
5191: --this cursor gets the delivery's otm exceptions ordered by severity

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

5184: ----------------------------------------------------------
5185: PROCEDURE GET_OTM_DELIVERY_EXCEPTION
5186: (p_delivery_id IN WSH_NEW_DELIVERIES.DELIVERY_ID%TYPE,
5187: x_exception_name OUT NOCOPY WSH_EXCEPTIONS.EXCEPTION_NAME%TYPE,
5188: x_severity OUT NOCOPY WSH_EXCEPTIONS.SEVERITY%TYPE,
5189: x_return_status OUT NOCOPY VARCHAR2) IS
5190:
5191: --this cursor gets the delivery's otm exceptions ordered by severity
5192: --we used order by 1 to take advantage of the alphabetical order of ERROR and WARNING

Line 5197: FROM wsh_exceptions

5193: CURSOR c_get_delivery_otm_exceptions (p_delivery_id IN NUMBER) IS
5194: SELECT severity,
5195: DECODE(severity,'HIGH', 1, 'ERROR', 1, 'MEDIUM', 2, 'WARNING', 2, 3) rank,
5196: exception_name
5197: FROM wsh_exceptions
5198: WHERE delivery_id = p_delivery_id
5199: AND status IN ('OPEN','ERROR','LOGGED','IN_PROCESS','MANUAL')
5200: AND severity IN ('HIGH','MEDIUM','ERROR','WARNING')
5201: AND exception_name IN

Line 5206: l_severity WSH_EXCEPTIONS.SEVERITY%TYPE;

5202: ('WSH_OTM_DEL_CREATE_REQ','WSH_OTM_DEL_UPDATE_REQ',
5203: 'WSH_OTM_DEL_AWAIT_TRIP')
5204: ORDER BY rank ASC;
5205:
5206: l_severity WSH_EXCEPTIONS.SEVERITY%TYPE;
5207: l_exception_name WSH_EXCEPTIONS.EXCEPTION_NAME%TYPE;
5208: l_rank NUMBER;
5209:
5210: l_debug_on BOOLEAN;

Line 5207: l_exception_name WSH_EXCEPTIONS.EXCEPTION_NAME%TYPE;

5203: 'WSH_OTM_DEL_AWAIT_TRIP')
5204: ORDER BY rank ASC;
5205:
5206: l_severity WSH_EXCEPTIONS.SEVERITY%TYPE;
5207: l_exception_name WSH_EXCEPTIONS.EXCEPTION_NAME%TYPE;
5208: l_rank NUMBER;
5209:
5210: l_debug_on BOOLEAN;
5211: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || g_pkg_name || '.' || 'GET_OTM_DELIVERY_EXCEPTION';