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

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

Line 1745: FROM wsh_exceptions

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

Line 1754: FROM wsh_exceptions

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

Line 1907: UPDATE wsh_exceptions

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

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

3090:
3091:
3092: -- ---------------------------------------------------------------------
3093: -- function: Get_Lookup_Meaning
3094: -- description: called by the view WSH_EXCEPTIONS_V to get meaning
3095: -- for EXCEPTION_SEVERITY and LOGGING_ENTITY
3096: --
3097: -- return: meaning
3098: -- ---------------------------------------------------------------------

Line 3267: from wsh_exceptions we

3263:
3264:
3265: /*CURSOR c_exceptions IS
3266: select we.rowid
3267: from wsh_exceptions we
3268: where
3269: nvl(we.request_id,-999) = nvl(p_request_id , nvl(we.request_id,-999))
3270: and nvl(we.exception_name,'XXX') = nvl(p_exception_name, nvl(we.exception_name,'XXX'))
3271: and we.logging_entity = nvl(p_logging_entity, we.logging_entity )

Line 3299: from wsh_delivery_assignments_v a, wsh_exceptions b

3295: and nvl(TO_CHAR(nvl(p_departure_date_to,nvl(we.departure_date,sysdate)),'YYYY/MM/DD') ,
3296: to_char(nvl(we.departure_date,sysdate),'YYYY/MM/DD') )
3297: and (sysdate - we.creation_date) > nvl(p_data_older_no_of_days,(sysdate - we.creation_date - 1))
3298: and ( (we.delivery_detail_id in (select distinct a.delivery_detail_id
3299: from wsh_delivery_assignments_v a, wsh_exceptions b
3300: where a.delivery_detail_id=b.delivery_detail_id
3301: and a.delivery_id=p_delivery_id)
3302: AND p_delivery_id is not null
3303: AND p_delivery_contents = 'Y')

Line 3435: UPDATE WSH_EXCEPTIONS

3431: l_use_dynamic := 'N';
3432: -- FP bug 4370532: this is the only context where
3433: -- action C_ACTION_SEMICLOSED can be used.
3434: IF (p_action = C_ACTION_SEMICLOSED) THEN
3435: UPDATE WSH_EXCEPTIONS
3436: SET status= 'CLOSED',
3437: last_update_date = sysdate,
3438: last_updated_by = FND_GLOBAL.USER_ID,
3439: last_update_login = FND_GLOBAL.USER_ID

Line 3444: UPDATE WSH_EXCEPTIONS

3440: WHERE trip_id = p_trip_id
3441: AND status <> 'CLOSED'
3442: AND severity <> 'INFO';
3443: ELSE
3444: UPDATE WSH_EXCEPTIONS
3445: SET status= 'CLOSED',
3446: last_update_date = sysdate,
3447: last_updated_by = FND_GLOBAL.USER_ID,
3448: last_update_login = FND_GLOBAL.USER_ID

Line 3463: UPDATE WSH_EXCEPTIONS

3459: l_use_dynamic := 'N';
3460: -- FP bug 4370532: this is the only context where
3461: -- action C_ACTION_SEMICLOSED can be used.
3462: IF (p_action = C_ACTION_SEMICLOSED) THEN
3463: UPDATE WSH_EXCEPTIONS
3464: SET status='CLOSED',
3465: last_update_date = sysdate,
3466: last_updated_by = FND_GLOBAL.USER_ID,
3467: last_update_login = FND_GLOBAL.USER_ID

Line 3472: UPDATE WSH_EXCEPTIONS

3468: WHERE trip_stop_id = p_trip_stop_id
3469: AND status <> 'CLOSED'
3470: AND severity <> 'INFO';
3471: ELSE
3472: UPDATE WSH_EXCEPTIONS
3473: SET status='CLOSED',
3474: last_update_date = sysdate,
3475: last_updated_by = FND_GLOBAL.USER_ID,
3476: last_update_login = FND_GLOBAL.USER_ID

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

3490: -- FP bug 4370532: this is the only context where
3491: -- action C_ACTION_SEMICLOSED can be used.
3492: IF (p_action = C_ACTION_SEMICLOSED) THEN
3493: -- performance bug 5257207: SC-11: split UPDATE to reduce
3494: -- the total number of queries on WSH_EXCEPTIONS.
3495: --
3496: -- This code is part of the ship confirm flow.
3497:
3498: UPDATE WSH_EXCEPTIONS

Line 3498: UPDATE WSH_EXCEPTIONS

3494: -- the total number of queries on WSH_EXCEPTIONS.
3495: --
3496: -- This code is part of the ship confirm flow.
3497:
3498: UPDATE WSH_EXCEPTIONS
3499: SET status = C_STATUS_CLOSED,
3500: last_update_date = sysdate,
3501: last_updated_by = FND_GLOBAL.USER_ID,
3502: last_update_login = FND_GLOBAL.USER_ID

Line 3512: UPDATE WSH_EXCEPTIONS

3508: AND severity <> C_SEVERITY_INFO;
3509:
3510: l_count := SQL%rowcount;
3511:
3512: UPDATE WSH_EXCEPTIONS
3513: SET status = C_STATUS_CLOSED,
3514: last_update_date = sysdate,
3515: last_updated_by = FND_GLOBAL.USER_ID,
3516: last_update_login = FND_GLOBAL.USER_ID

Line 3525: UPDATE WSH_EXCEPTIONS

3521: l_count := l_count + SQL%rowcount;
3522:
3523: ELSE
3524: -- UPDATES are tuned the same way as above.
3525: UPDATE WSH_EXCEPTIONS
3526: SET status = p_action,
3527: last_update_date = sysdate,
3528: last_updated_by = FND_GLOBAL.USER_ID,
3529: last_update_login = FND_GLOBAL.USER_ID

Line 3538: UPDATE WSH_EXCEPTIONS

3534: AND status <> C_STATUS_CLOSED;
3535:
3536: l_count := SQL%rowcount;
3537:
3538: UPDATE WSH_EXCEPTIONS
3539: SET status = p_action,
3540: last_update_date = sysdate,
3541: last_updated_by = FND_GLOBAL.USER_ID,
3542: last_update_login = FND_GLOBAL.USER_ID

Line 3555: UPDATE WSH_EXCEPTIONS

3551:
3552: -- bug 4318747: this is the only context where
3553: -- action C_ACTION_SEMICLOSED can be used.
3554: IF (p_action = C_ACTION_SEMICLOSED) THEN
3555: UPDATE WSH_EXCEPTIONS
3556: SET status='CLOSED',
3557: last_update_date = sysdate,
3558: last_updated_by = FND_GLOBAL.USER_ID,
3559: last_update_login = FND_GLOBAL.USER_ID

Line 3566: UPDATE WSH_EXCEPTIONS

3562: AND severity <> 'INFO'
3563: --AND exception_name <> 'WSH_OTM_SHIPMENT_ERROR'; -- OTM R12 glog project;
3564: AND exception_name <> C_OTM_EXC_NAME; -- OTM R12 glog project;
3565: ELSE
3566: UPDATE WSH_EXCEPTIONS
3567: SET status='CLOSED',
3568: last_update_date = sysdate,
3569: last_updated_by = FND_GLOBAL.USER_ID,
3570: last_update_login = FND_GLOBAL.USER_ID

Line 3585: UPDATE WSH_EXCEPTIONS

3581: p_trip_stop_id is NULL and
3582: p_delivery_id is NULL) THEN
3583:
3584: l_use_dynamic := 'N';
3585: UPDATE WSH_EXCEPTIONS
3586: SET status=p_action ,
3587: last_update_date = sysdate,
3588: last_updated_by = FND_GLOBAL.USER_ID,
3589: last_update_login = FND_GLOBAL.USER_ID

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

3598: IF l_use_dynamic = 'Y' THEN -- Dynamic cusrsor required
3599: --{
3600: -- Bug#3200314: Constructing the Dynamic Cursor.
3601: Exceptions_SQL := Exceptions_SQL || 'SELECT WE.ROWID';
3602: Exceptions_SQL := Exceptions_SQL || ' FROM WSH_EXCEPTIONS WE';
3603: Exceptions_SQL := Exceptions_SQL || ' WHERE';
3604: IF p_request_id IS NOT NULL THEN
3605: Exceptions_SQL := Exceptions_SQL || ' WE.REQUEST_ID = :p_request_id AND';
3606: bind_col_tab(bind_col_tab.COUNT+1) := TO_CHAR(p_request_id);

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

3683:
3684: IF p_delivery_id IS NOT NULL THEN
3685: IF p_delivery_contents = 'Y' THEN
3686: Temp_SQL := ' SELECT ROWID';
3687: Temp_SQL := Temp_SQL || ' FROM WSH_EXCEPTIONS';
3688: Temp_SQL := Temp_SQL || ' WHERE';
3689: Exceptions_SQL := Exceptions_SQL || ' WE.ROWID IN (';
3690: Exceptions_SQL := Exceptions_SQL || Temp_SQL;
3691: Exceptions_SQL := Exceptions_SQL || ' DELIVERY_DETAIL_ID IN';

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

3689: Exceptions_SQL := Exceptions_SQL || ' WE.ROWID IN (';
3690: Exceptions_SQL := Exceptions_SQL || Temp_SQL;
3691: Exceptions_SQL := Exceptions_SQL || ' DELIVERY_DETAIL_ID IN';
3692: Exceptions_SQL := Exceptions_SQL || ' (SELECT DISTINCT a.delivery_detail_id';
3693: Exceptions_SQL := Exceptions_SQL || ' FROM wsh_delivery_assignments_v a, wsh_exceptions b';
3694: Exceptions_SQL := Exceptions_SQL || ' WHERE a.delivery_detail_id=b.delivery_detail_id';
3695: Exceptions_SQL := Exceptions_SQL || ' AND a.delivery_id= :p_delivery_id)';
3696: Exceptions_SQL := Exceptions_SQL || ' UNION ALL';
3697: bind_col_tab(bind_col_tab.COUNT+1) := TO_CHAR(p_delivery_id);

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

3761: c_cfetch := c_exceptions%rowcount - c_pfetch;
3762: EXIT WHEN (c_cfetch=0);
3763: IF p_action='PURGE' THEN
3764: FORALL l_counter IN 1..c_cfetch
3765: DELETE from WSH_EXCEPTIONS where rowid = RowIdList(l_counter);
3766: ELSE -- 'CLOSED'
3767: FORALL l_counter IN 1..c_cfetch
3768: UPDATE WSH_EXCEPTIONS
3769: SET status=p_action ,

Line 3768: UPDATE WSH_EXCEPTIONS

3764: FORALL l_counter IN 1..c_cfetch
3765: DELETE from WSH_EXCEPTIONS where rowid = RowIdList(l_counter);
3766: ELSE -- 'CLOSED'
3767: FORALL l_counter IN 1..c_cfetch
3768: UPDATE WSH_EXCEPTIONS
3769: SET status=p_action ,
3770: last_update_date = sysdate,
3771: last_updated_by = FND_GLOBAL.USER_ID,
3772: last_update_login = FND_GLOBAL.USER_ID

Line 3926: FROM wsh_exceptions

3922: ) IS
3923:
3924: CURSOR Get_Trip_Exceptions (v_trip_id NUMBER) IS
3925: SELECT DECODE(severity,'HIGH','ERROR','MEDIUM','WARNING',severity)
3926: FROM wsh_exceptions
3927: WHERE trip_id = v_trip_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_Stop_Exceptions (v_stop_id NUMBER) IS
3933: SELECT DECODE(severity,'HIGH','ERROR','MEDIUM','WARNING',severity)
3934: FROM wsh_exceptions
3935: WHERE trip_stop_id = v_stop_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_Delivery_Exceptions (v_delivery_id NUMBER) IS
3941: SELECT DECODE(severity,'HIGH','ERROR','MEDIUM','WARNING',severity)
3942: FROM wsh_exceptions
3943: WHERE delivery_id = v_delivery_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 3950: FROM wsh_exceptions

3946: ORDER BY decode(severity,'HIGH',1,'ERROR',1,'MEDIUM',2,'WARNING',2,3);
3947:
3948: CURSOR Get_Detail_Exceptions (v_detail_id NUMBER) IS
3949: SELECT DECODE(severity,'HIGH','ERROR','MEDIUM','WARNING',severity)
3950: FROM wsh_exceptions
3951: WHERE delivery_detail_id = v_detail_id
3952: AND status in ('OPEN','ERROR','LOGGED','IN_PROCESS','MANUAL')
3953: AND severity in ('HIGH','MEDIUM','ERROR','WARNING')
3954: ORDER BY decode(severity,'HIGH',1,'ERROR',1,'MEDIUM',2,'WARNING',2,3);

Line 4897: l_exception_id WSH_EXCEPTIONS.EXCEPTION_ID%TYPE;

4893: x_return_status OUT NOCOPY VARCHAR2) IS
4894:
4895: l_msg_count NUMBER;
4896: l_msg_data VARCHAR2(32767);
4897: l_exception_id WSH_EXCEPTIONS.EXCEPTION_ID%TYPE;
4898: l_exception_message WSH_EXCEPTIONS.MESSAGE%TYPE;
4899: l_num_error NUMBER;
4900: l_num_warn NUMBER;
4901: l_return_status VARCHAR2(1);

Line 4898: l_exception_message WSH_EXCEPTIONS.MESSAGE%TYPE;

4894:
4895: l_msg_count NUMBER;
4896: l_msg_data VARCHAR2(32767);
4897: l_exception_id WSH_EXCEPTIONS.EXCEPTION_ID%TYPE;
4898: l_exception_message WSH_EXCEPTIONS.MESSAGE%TYPE;
4899: l_num_error NUMBER;
4900: l_num_warn NUMBER;
4901: l_return_status VARCHAR2(1);
4902:

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

5191: -- description: This procedure gets the delivery's OTM exception and severity
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

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 5205: FROM wsh_exceptions

5201: CURSOR c_get_delivery_otm_exceptions (p_delivery_id IN NUMBER) IS
5202: SELECT severity,
5203: DECODE(severity,'HIGH', 1, 'ERROR', 1, 'MEDIUM', 2, 'WARNING', 2, 3) rank,
5204: exception_name
5205: FROM wsh_exceptions
5206: WHERE delivery_id = p_delivery_id
5207: AND status IN ('OPEN','ERROR','LOGGED','IN_PROCESS','MANUAL')
5208: AND severity IN ('HIGH','MEDIUM','ERROR','WARNING')
5209: AND exception_name IN

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;

Line 5215: l_exception_name WSH_EXCEPTIONS.EXCEPTION_NAME%TYPE;

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;
5219: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || g_pkg_name || '.' || 'GET_OTM_DELIVERY_EXCEPTION';