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_TRIP_STOPS_ACTIONS dependencies on WSH_TRIP_STOPS_VALIDATIONS

Line 514: l_in_rec WSH_TRIP_STOPS_VALIDATIONS.chkClose_in_rec_type;

510: l_return_status VARCHAR2(1);
511: others EXCEPTION;
512: --
513: --
514: l_in_rec WSH_TRIP_STOPS_VALIDATIONS.chkClose_in_rec_type;
515: l_out_rec WSH_TRIP_STOPS_VALIDATIONS.chkClose_out_rec_type;
516: --
517: l_stopsProcessed NUMBER;
518: l_stopsProcessedWarnings NUMBER;

Line 515: l_out_rec WSH_TRIP_STOPS_VALIDATIONS.chkClose_out_rec_type;

511: others EXCEPTION;
512: --
513: --
514: l_in_rec WSH_TRIP_STOPS_VALIDATIONS.chkClose_in_rec_type;
515: l_out_rec WSH_TRIP_STOPS_VALIDATIONS.chkClose_out_rec_type;
516: --
517: l_stopsProcessed NUMBER;
518: l_stopsProcessedWarnings NUMBER;
519: l_stopsNotProcessedWarnings NUMBER;

Line 602: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_VALIDATIONS.CHECK_STOP_CLOSE',WSH_DEBUG_SV.C_PROC_LEVEL);

598: l_in_rec.actual_date := p_actual_date;
599: --
600: --
601: IF l_debug_on THEN
602: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_VALIDATIONS.CHECK_STOP_CLOSE',WSH_DEBUG_SV.C_PROC_LEVEL);
603: END IF;
604: --
605: WSH_TRIP_STOPS_VALIDATIONS.check_stop_close
606: (

Line 605: WSH_TRIP_STOPS_VALIDATIONS.check_stop_close

601: IF l_debug_on THEN
602: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_VALIDATIONS.CHECK_STOP_CLOSE',WSH_DEBUG_SV.C_PROC_LEVEL);
603: END IF;
604: --
605: WSH_TRIP_STOPS_VALIDATIONS.check_stop_close
606: (
607: p_in_rec => l_in_rec,
608: x_out_rec => l_out_rec,
609: x_return_status => l_return_status

Line 708: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_VALIDATIONS.CHECK_STOP_ARRIVE',WSH_DEBUG_SV.C_PROC_LEVEL);

704: l_in_rec.actual_date := p_actual_date;
705: --
706: --
707: IF l_debug_on THEN
708: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_VALIDATIONS.CHECK_STOP_ARRIVE',WSH_DEBUG_SV.C_PROC_LEVEL);
709: END IF;
710: --
711: WSH_TRIP_VALIDATIONS.check_stop_arrive
712: (

Line 1279: p_in_rec IN WSH_TRIP_STOPS_VALIDATIONS.chkClose_in_rec_type,

1275: --========================================================================
1276: --
1277: PROCEDURE autoCloseOpen
1278: (
1279: p_in_rec IN WSH_TRIP_STOPS_VALIDATIONS.chkClose_in_rec_type,
1280: p_reopenStop IN BOOLEAN DEFAULT FALSE,
1281: x_stop_processed OUT NOCOPY VARCHAR2,
1282: x_return_status OUT NOCOPY VARCHAR2
1283: )

Line 1292: l_in_rec WSH_TRIP_STOPS_VALIDATIONS.chkClose_in_rec_type;

1288: l_num_warnings NUMBER;
1289: l_num_errors NUMBER;
1290: --
1291: l_actual_date DATE := NULL;
1292: l_in_rec WSH_TRIP_STOPS_VALIDATIONS.chkClose_in_rec_type;
1293: l_out_rec WSH_TRIP_STOPS_VALIDATIONS.chkClose_out_rec_type;
1294: --
1295: l_debug_on BOOLEAN;
1296: --

Line 1293: l_out_rec WSH_TRIP_STOPS_VALIDATIONS.chkClose_out_rec_type;

1289: l_num_errors NUMBER;
1290: --
1291: l_actual_date DATE := NULL;
1292: l_in_rec WSH_TRIP_STOPS_VALIDATIONS.chkClose_in_rec_type;
1293: l_out_rec WSH_TRIP_STOPS_VALIDATIONS.chkClose_out_rec_type;
1294: --
1295: l_debug_on BOOLEAN;
1296: --
1297: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'autoCloseOpen';

Line 1334: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_VALIDATIONS.CHECK_STOP_CLOSE',WSH_DEBUG_SV.C_PROC_LEVEL);

1330: --
1331: --
1332: IF l_debug_on THEN
1333: WSH_DEBUG_SV.log(l_module_name,'l_in_rec.caller',l_in_rec.caller);
1334: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_VALIDATIONS.CHECK_STOP_CLOSE',WSH_DEBUG_SV.C_PROC_LEVEL);
1335: END IF;
1336: --
1337: -- Check if stop can be closed or not.
1338: --

Line 1339: WSH_TRIP_STOPS_VALIDATIONS.check_stop_close

1335: END IF;
1336: --
1337: -- Check if stop can be closed or not.
1338: --
1339: WSH_TRIP_STOPS_VALIDATIONS.check_stop_close
1340: (
1341: p_in_rec => l_in_rec,
1342: x_out_rec => l_out_rec,
1343: x_return_status => l_return_status

Line 1358: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_VALIDATIONS.get_stop_close_date',WSH_DEBUG_SV.C_PROC_LEVEL);

1354: AND NOT(p_reopenStop)
1355: THEN
1356: --{
1357: IF l_debug_on THEN
1358: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_VALIDATIONS.get_stop_close_date',WSH_DEBUG_SV.C_PROC_LEVEL);
1359: END IF;
1360: --
1361: -- Stop can be closed and input parameter p_reopenStop is FALSE.
1362: -- First, determine the stop close date

Line 1365: WSH_TRIP_STOPS_VALIDATIONS.get_stop_close_date

1361: -- Stop can be closed and input parameter p_reopenStop is FALSE.
1362: -- First, determine the stop close date
1363: -- and then call stop close api
1364: --
1365: WSH_TRIP_STOPS_VALIDATIONS.get_stop_close_date
1366: (
1367: p_trip_id => l_out_rec.trip_id,
1368: p_stop_id => p_in_rec.stop_id,
1369: p_stop_sequence_number => l_out_rec.stop_sequence_number,

Line 1508: -- WSH_TRIP_STOPS_VALIDATIONS.check_stop_close, which in turn will set its out

1504: -- x_return_status Return status of API
1505: --
1506: -- PRE-REQS : Caller should set all the attributes of input parameters p_in_rec and p_in_rec1.
1507: -- Typically, this procedure gets called after call to
1508: -- WSH_TRIP_STOPS_VALIDATIONS.check_stop_close, which in turn will set its out
1509: -- parameter x_out_rec which can be passed as input (p_in_rec1) to this API.
1510: --
1511: --
1512: -- COMMENT : This API performs the stop close operation

Line 1530: p_in_rec IN WSH_TRIP_STOPS_VALIDATIONS.chkClose_in_rec_type,

1526: --========================================================================
1527: --
1528: PROCEDURE setClose
1529: (
1530: p_in_rec IN WSH_TRIP_STOPS_VALIDATIONS.chkClose_in_rec_type,
1531: p_in_rec1 IN WSH_TRIP_STOPS_VALIDATIONS.chkClose_out_rec_type,
1532: p_defer_interface_Flag IN VARCHAR2,
1533: x_return_status OUT NOCOPY VARCHAR2
1534: )

Line 1531: p_in_rec1 IN WSH_TRIP_STOPS_VALIDATIONS.chkClose_out_rec_type,

1527: --
1528: PROCEDURE setClose
1529: (
1530: p_in_rec IN WSH_TRIP_STOPS_VALIDATIONS.chkClose_in_rec_type,
1531: p_in_rec1 IN WSH_TRIP_STOPS_VALIDATIONS.chkClose_out_rec_type,
1532: p_defer_interface_Flag IN VARCHAR2,
1533: x_return_status OUT NOCOPY VARCHAR2
1534: )
1535: IS

Line 1554: l_stop_in_rec WSH_TRIP_STOPS_VALIDATIONS.chkClose_in_rec_type;

1550: l_warehouse_type VARCHAR2(30);
1551: l_cms_flag VARCHAR2(1);
1552: l_in_rec WSH_DELIVERY_VALIDATIONS.ChgStatus_in_rec_type;
1553: l_trip_in_rec WSH_TRIP_VALIDATIONS.ChgStatus_in_rec_type;
1554: l_stop_in_rec WSH_TRIP_STOPS_VALIDATIONS.chkClose_in_rec_type;
1555: --
1556: --
1557: l_stop_closed VARCHAR2(10);
1558: l_stop_opened VARCHAR2(10);

Line 2325: -- WSH_TRIP_STOPS_VALIDATIONS.check_stop_close, which in turn will set its out

2321: -- x_return_status Return status of API
2322: --
2323: -- PRE-REQS : Caller should set all the attributes of input parameters p_in_rec and p_in_rec1.
2324: -- Typically, this procedure gets called after call to
2325: -- WSH_TRIP_STOPS_VALIDATIONS.check_stop_close, which in turn will set its out
2326: -- parameter x_out_rec which can be passed as input (p_in_rec1) to this API.
2327: --
2328: --
2329: -- COMMENT : This API performs the stop open operation. This is only required for

Line 2345: p_in_rec IN WSH_TRIP_STOPS_VALIDATIONS.chkClose_in_rec_type,

2341: --========================================================================
2342: --
2343: PROCEDURE setOpen
2344: (
2345: p_in_rec IN WSH_TRIP_STOPS_VALIDATIONS.chkClose_in_rec_type,
2346: p_in_rec1 IN WSH_TRIP_STOPS_VALIDATIONS.chkClose_out_rec_type,
2347: x_return_status OUT NOCOPY VARCHAR2
2348: )
2349: IS

Line 2346: p_in_rec1 IN WSH_TRIP_STOPS_VALIDATIONS.chkClose_out_rec_type,

2342: --
2343: PROCEDURE setOpen
2344: (
2345: p_in_rec IN WSH_TRIP_STOPS_VALIDATIONS.chkClose_in_rec_type,
2346: p_in_rec1 IN WSH_TRIP_STOPS_VALIDATIONS.chkClose_out_rec_type,
2347: x_return_status OUT NOCOPY VARCHAR2
2348: )
2349: IS
2350: --{

Line 2435: l_stop_in_rec WSH_TRIP_STOPS_VALIDATIONS.chkClose_in_rec_type;

2431: l_stop_opened VARCHAR2(10);
2432: l_allowed VARCHAR2(10);
2433: --
2434: l_trip_in_rec WSH_TRIP_VALIDATIONS.ChgStatus_in_rec_type;
2435: l_stop_in_rec WSH_TRIP_STOPS_VALIDATIONS.chkClose_in_rec_type;
2436: l_stop_id_tbl WSH_UTIL_CORE.id_tab_type;
2437: l_stop_cnt NUMBER := 0;
2438: l_index NUMBER;
2439: l_stop_id NUMBER;

Line 2951: ( p_stop_details_rec IN OUT NOCOPY WSH_TRIP_STOPS_VALIDATIONS.stop_details,

2947: --
2948: --
2949:
2950: PROCEDURE RESET_STOP_SEQ_NUMBERS
2951: ( p_stop_details_rec IN OUT NOCOPY WSH_TRIP_STOPS_VALIDATIONS.stop_details,
2952: x_return_status OUT NOCOPY VARCHAR2
2953: ) IS
2954:
2955:

Line 2978: l_stop_rec_tab WSH_TRIP_STOPS_VALIDATIONS.stop_details_tab;

2974: OR stop_sequence_number < 1) -- Newly created stops
2975: FOR update nowait
2976: ORDER BY 1, 2;
2977:
2978: l_stop_rec_tab WSH_TRIP_STOPS_VALIDATIONS.stop_details_tab;
2979: l_max_seq_number NUMBER;
2980: l_trip_id_tmp NUMBER;
2981: l_locking_stops VARCHAR2(1);
2982: i NUMBER;