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_GRP dependencies on WSH_TRIP_STOPS_PVT

Line 14: p_stop_attr_tab IN WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type,

10: -- Forward declaration
11: PROCEDURE Lock_Related_Entity
12: (
13: p_action_prms IN action_parameters_rectype,
14: p_stop_attr_tab IN WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type,
15: x_valid_ids_tab OUT NOCOPY WSH_UTIL_CORE.id_Tab_Type,
16: x_return_status OUT NOCOPY VARCHAR2
17: );
18:

Line 202: FND_MESSAGE.SET_TOKEN('STOP_NAME', wsh_trip_stops_pvt.get_name(l_stop_id));

198:
199: WHEN FND_API.G_EXC_ERROR THEN
200: x_return_status := FND_API.G_RET_STS_ERROR;
201: FND_MESSAGE.SET_NAME('WSH','WSH_OI_STOP_ACTION_ERROR');
202: FND_MESSAGE.SET_TOKEN('STOP_NAME', wsh_trip_stops_pvt.get_name(l_stop_id));
203: FND_MESSAGE.SET_TOKEN('ACTION', wsh_util_core.get_action_meaning('STOP',p_stop_IN_rec.action_code));
204: wsh_util_core.add_message(x_return_status,l_module_name);
205: FND_MSG_PUB.Count_And_Get
206: ( p_encoded => l_encoded

Line 219: FND_MESSAGE.SET_TOKEN('STOP_NAME', wsh_trip_stops_pvt.get_name(l_stop_id));

215:
216: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
218: FND_MESSAGE.SET_NAME('WSH','WSH_OI_STOP_ACTION_ERROR');
219: FND_MESSAGE.SET_TOKEN('STOP_NAME', wsh_trip_stops_pvt.get_name(l_stop_id));
220: FND_MESSAGE.SET_TOKEN('ACTION', wsh_util_core.get_action_meaning('STOP',p_stop_IN_rec.action_code));
221: wsh_util_core.add_message(x_return_status,l_module_name);
222: -- Get message count and data
223: FND_MSG_PUB.Count_And_Get

Line 440: FND_MESSAGE.SET_TOKEN('STOP_NAME', wsh_trip_stops_pvt.get_name(l_stop_id));

436: WHEN FND_API.G_EXC_ERROR THEN
437: x_return_status := FND_API.G_RET_STS_ERROR;
438: -- Get message count and data
439: FND_MESSAGE.SET_NAME('WSH','WSH_OI_STOP_ACTION_ERROR');
440: FND_MESSAGE.SET_TOKEN('STOP_NAME', wsh_trip_stops_pvt.get_name(l_stop_id));
441: FND_MESSAGE.SET_TOKEN('ACTION', wsh_util_core.get_action_meaning('STOP',p_action_code));
442: wsh_util_core.add_message(x_return_status,l_module_name);
443: FND_MSG_PUB.Count_And_Get
444: ( p_encoded => l_encoded

Line 456: FND_MESSAGE.SET_TOKEN('STOP_NAME', wsh_trip_stops_pvt.get_name(l_stop_id));

452:
453: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
454: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
455: FND_MESSAGE.SET_NAME('WSH','WSH_OI_STOP_ACTION_ERROR');
456: FND_MESSAGE.SET_TOKEN('STOP_NAME', wsh_trip_stops_pvt.get_name(l_stop_id));
457: FND_MESSAGE.SET_TOKEN('ACTION', wsh_util_core.get_action_meaning('STOP',p_action_code));
458: wsh_util_core.add_message(x_return_status,l_module_name);
459: -- Get message count and data
460: FND_MSG_PUB.Count_And_Get

Line 505: p_rec_attr_tab IN WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type,

501: ( p_api_version_number IN NUMBER,
502: p_init_msg_list IN VARCHAR2,
503: p_commit IN VARCHAR2,
504: p_action_prms IN action_parameters_rectype,
505: p_rec_attr_tab IN WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type,
506: x_stop_out_rec OUT NOCOPY stopActionOutRecType,
507: x_def_rec OUT NOCOPY default_parameters_rectype,
508: x_return_status OUT NOCOPY VARCHAR2,
509: x_msg_count OUT NOCOPY NUMBER,

Line 528: l_valid_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;

524: l_stop_id NUMBER;
525: l_is_installed VARCHAR2(10);
526: l_valid_index_tab wsh_util_core.id_tab_type;
527: l_valid_id_tab wsh_util_core.id_tab_type;
528: l_valid_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
529: l_num_warning NUMBER := 0;
530: l_num_errors NUMBER := 0;
531: l_return_status VARCHAR2(500);
532: l_trip_rec WSH_TRIPS_PVT.trip_rec_type;

Line 533: l_stop_rec WSH_TRIP_STOPS_PVT.trip_stop_rec_type;

529: l_num_warning NUMBER := 0;
530: l_num_errors NUMBER := 0;
531: l_return_status VARCHAR2(500);
532: l_trip_rec WSH_TRIPS_PVT.trip_rec_type;
533: l_stop_rec WSH_TRIP_STOPS_PVT.trip_stop_rec_type;
534: l_api_version_number CONSTANT NUMBER := 1.0;
535: l_api_name CONSTANT VARCHAR2(30):= 'Stop_Action';
536: l_counter NUMBER;
537: l_report_set_id NUMBER := p_action_prms.report_set_id;

Line 563: l_cc_stop_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;

559: l_cc_count_success NUMBER;
560: l_cc_del_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
561: l_cc_det_attr_tab wsh_glbl_var_strct_grp.Delivery_Details_Attr_Tbl_Type;
562: l_cc_trip_attr_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
563: l_cc_stop_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
564: l_cc_in_ids wsh_util_core.id_tab_type;
565: l_cc_fail_ids wsh_util_core.id_tab_type;
566: l_msg_count NUMBER;
567: l_msg_data VARCHAR2(32767);

Line 754: WSH_TRIP_STOPS_PVT.Lock_Trip_Stop(

750: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_LOCK_RECORDS_LVL) = 1 THEN
751: IF NOT ( p_action_prms.caller = 'WSH_FSTRX'
752: AND p_action_prms.action_code = 'DELETE'
753: ) THEN --BUG 4354579
754: WSH_TRIP_STOPS_PVT.Lock_Trip_Stop(
755: p_rec_attr_tab=>p_rec_attr_tab,
756: p_caller=>p_action_prms.caller,
757: p_valid_index_tab =>l_valid_index_tab,
758: x_valid_ids_tab =>x_stop_out_rec.valid_ids_tab,

Line 977: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

973: --
974: -- Debug Statements
975: --
976: IF l_debug_on THEN
977: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
978: END IF;
979: --tkt
980: FND_MESSAGE.SET_TOKEN('STOP_NAME',wsh_trip_stops_pvt.get_name(l_cc_fail_ids(j),p_action_prms.caller));
981: wsh_util_core.add_message(l_return_status);

Line 980: FND_MESSAGE.SET_TOKEN('STOP_NAME',wsh_trip_stops_pvt.get_name(l_cc_fail_ids(j),p_action_prms.caller));

976: IF l_debug_on THEN
977: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
978: END IF;
979: --tkt
980: FND_MESSAGE.SET_TOKEN('STOP_NAME',wsh_trip_stops_pvt.get_name(l_cc_fail_ids(j),p_action_prms.caller));
981: wsh_util_core.add_message(l_return_status);
982: END IF;
983: END LOOP;
984:

Line 1777: -- x_pvt_stop_rec OUT WSH_TRIP_STOPS_PVT.TRIP_STOP_REC_TYPE

1773: --========================================================================
1774: -- PROCEDURE : map_stopgrp_to_pvt PRIVATE
1775: --
1776: -- PARAMETERS: p_grp_stop_rec IN WSH_TRIP_STOPS_GRP.TRIP_STOP_PUB_REC_TYPE
1777: -- x_pvt_stop_rec OUT WSH_TRIP_STOPS_PVT.TRIP_STOP_REC_TYPE
1778: -- x_return_status return status
1779: -- COMMENT : This procedure maps Group API record type to Private API record type for Stop.
1780: --========================================================================
1781: PROCEDURE map_stopgrp_to_pvt(

Line 1783: x_pvt_stop_rec OUT NOCOPY WSH_TRIP_STOPS_PVT.TRIP_STOP_REC_TYPE,

1779: -- COMMENT : This procedure maps Group API record type to Private API record type for Stop.
1780: --========================================================================
1781: PROCEDURE map_stopgrp_to_pvt(
1782: p_grp_stop_rec IN WSH_TRIP_STOPS_GRP.TRIP_STOP_PUB_REC_TYPE,
1783: x_pvt_stop_rec OUT NOCOPY WSH_TRIP_STOPS_PVT.TRIP_STOP_REC_TYPE,
1784: x_return_status OUT NOCOPY VARCHAR2) IS
1785:
1786: l_debug_on BOOLEAN;
1787: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'MAP_STOPGRP_TO_PVT';

Line 1906: (p_rec_attr_tab IN OUT NOCOPY WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type,

1902: -- x_return_status return status
1903: -- COMMENT : This procedure takes tabe of Stops and validate them and return the validate stops in x_valid_id_index_tab.
1904: --========================================================================
1905: PROCEDURE Validate_Stop
1906: (p_rec_attr_tab IN OUT NOCOPY WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type,
1907: p_action_code IN VARCHAR2,
1908: p_caller IN VARCHAR2,
1909: x_valid_id_index_tab OUT NOCOPY wsh_util_core.id_tab_type,
1910: x_return_status OUT NOCOPY VARCHAR2) IS

Line 2295: p_rec_attr_tab IN WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type,

2291: p_api_version_number IN NUMBER,
2292: p_init_msg_list IN VARCHAR2,
2293: p_commit IN VARCHAR2,
2294: p_in_rec IN stopInRecType,
2295: p_rec_attr_tab IN WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type,
2296: x_stop_out_tab OUT NOCOPY stop_out_tab_type,
2297: x_return_status OUT NOCOPY VARCHAR2,
2298: x_msg_count OUT NOCOPY NUMBER,
2299: x_msg_data OUT NOCOPY VARCHAR2,

Line 2316: l_rec_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;

2312: l_num_errors NUMBER := 0;
2313: l_num_warnings NUMBER := 0;
2314: l_return_status VARCHAR2(1);
2315: l_index NUMBER;
2316: l_rec_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
2317: x_index_id_tab wsh_util_core.id_tab_type;
2318:
2319: --Compatibility Changes
2320: l_cc_validate_result VARCHAR2(1);

Line 2325: l_rec_attr_tab_temp WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;

2321: l_cc_failed_records WSH_FTE_COMP_CONSTRAINT_PKG.failed_line_tab_type;
2322: l_cc_line_groups WSH_FTE_COMP_CONSTRAINT_PKG.line_group_tab_type;
2323: l_cc_group_info WSH_FTE_COMP_CONSTRAINT_PKG.cc_group_tab_type;
2324:
2325: l_rec_attr_tab_temp WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
2326: l_cc_count_success NUMBER;
2327: b_cc_linefailed BOOLEAN;
2328: l_msg_count NUMBER;
2329: l_msg_data VARCHAR2(2000);

Line 2335: l_cc_stop_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;

2331: --dummy tables for calling validate_constraint_mainper
2332: l_cc_del_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
2333: l_cc_det_attr_tab wsh_glbl_var_strct_grp.Delivery_Details_Attr_Tbl_Type;
2334: l_cc_trip_attr_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
2335: l_cc_stop_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
2336: l_cc_in_ids wsh_util_core.id_tab_type;
2337: l_cc_fail_ids wsh_util_core.id_tab_type;
2338:
2339: --Compatibility Changes

Line 2351: l_stop_rec WSH_TRIP_STOPS_PVT.trip_stop_rec_type;

2347: l_details_marked WSH_UTIL_CORE.Id_Tab_Type;
2348: --TL Rating
2349:
2350: l_action_prms action_parameters_rectype;
2351: l_stop_rec WSH_TRIP_STOPS_PVT.trip_stop_rec_type;
2352: l_internal_stop_rec WSH_TRIP_STOPS_PVT.trip_stop_rec_type;
2353:
2354: --bug 2796095
2355: CURSOR c_get_all_trip_stops (p_trip_id IN NUMBER) IS

Line 2352: l_internal_stop_rec WSH_TRIP_STOPS_PVT.trip_stop_rec_type;

2348: --TL Rating
2349:
2350: l_action_prms action_parameters_rectype;
2351: l_stop_rec WSH_TRIP_STOPS_PVT.trip_stop_rec_type;
2352: l_internal_stop_rec WSH_TRIP_STOPS_PVT.trip_stop_rec_type;
2353:
2354: --bug 2796095
2355: CURSOR c_get_all_trip_stops (p_trip_id IN NUMBER) IS
2356: SELECT stop_id,

Line 2726: WSH_TRIP_STOPS_PVT.create_trip_stop (

2722: RAISE e_gc3_trip_exception;
2723: END IF;
2724: --
2725:
2726: WSH_TRIP_STOPS_PVT.create_trip_stop (
2727: p_trip_stop_info => l_rec_attr_tab(x_index_id_tab(l_index)),
2728: x_rowid => x_stop_out_tab(l_index).rowid,
2729: x_stop_id => x_stop_out_tab(l_index).stop_id,
2730: x_return_status => l_return_status);

Line 2809: WSH_TRIP_STOPS_PVT.UPDATE_TRIP_STOP (

2805: END IF;
2806:
2807: -- end csun 10+ internal location
2808:
2809: WSH_TRIP_STOPS_PVT.UPDATE_TRIP_STOP (
2810: p_rowid => l_rec_attr_tab(x_index_id_tab(l_index)).rowid,
2811: p_stop_info => l_rec_attr_tab(x_index_id_tab(l_index)),
2812: x_return_status => l_return_status);
2813:

Line 3541: l_pvt_stop_rec WSH_TRIP_STOPS_PVT.TRIP_STOP_REC_TYPE;

3537: l_debug_on BOOLEAN;
3538: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'CREATE_UPDATE_STOP';
3539:
3540: l_in_rec stopInRecType;
3541: l_pvt_stop_rec WSH_TRIP_STOPS_PVT.TRIP_STOP_REC_TYPE;
3542:
3543: l_rec_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
3544: l_stop_out_tab stop_out_tab_type;
3545:

Line 3543: l_rec_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;

3539:
3540: l_in_rec stopInRecType;
3541: l_pvt_stop_rec WSH_TRIP_STOPS_PVT.TRIP_STOP_REC_TYPE;
3542:
3543: l_rec_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
3544: l_stop_out_tab stop_out_tab_type;
3545:
3546: l_commit VARCHAR2(1):='F';
3547:

Line 3693: l_pvt_stop_rec WSH_TRIP_STOPS_PVT.TRIP_STOP_REC_TYPE;

3689: l_debug_on BOOLEAN;
3690: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'CREATE_UPDATE_STOP_NEW';
3691:
3692: l_in_rec stopInRecType;
3693: l_pvt_stop_rec WSH_TRIP_STOPS_PVT.TRIP_STOP_REC_TYPE;
3694:
3695: l_rec_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
3696: l_stop_out_tab stop_out_tab_type;
3697:

Line 3695: l_rec_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;

3691:
3692: l_in_rec stopInRecType;
3693: l_pvt_stop_rec WSH_TRIP_STOPS_PVT.TRIP_STOP_REC_TYPE;
3694:
3695: l_rec_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
3696: l_stop_out_tab stop_out_tab_type;
3697:
3698: l_commit VARCHAR2(1):='F';
3699: BEGIN

Line 3812: x_stop_rec OUT NOCOPY WSH_TRIP_STOPS_PVT.TRIP_STOP_REC_TYPE,

3808: -- API to get Stop Details
3809: -- OTM R12, glog proj, removed the cursor to call populate_record API from WSHSTTHS/B
3810: PROCEDURE get_stop_details_pvt
3811: (p_stop_id IN NUMBER,
3812: x_stop_rec OUT NOCOPY WSH_TRIP_STOPS_PVT.TRIP_STOP_REC_TYPE,
3813: x_return_status OUT NOCOPY VARCHAR2) IS
3814:
3815: --
3816: l_debug_on BOOLEAN;

Line 3838: WSH_TRIP_STOPS_PVT.Populate_Record(

3834: END IF;
3835: --
3836: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3837:
3838: WSH_TRIP_STOPS_PVT.Populate_Record(
3839: p_stop_id => p_stop_id,
3840: x_stop_info => x_stop_rec,
3841: x_return_status => x_return_status);
3842:

Line 3881: p_stop_attr_tab IN WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type,

3877:
3878: PROCEDURE Lock_Related_Entity
3879: (
3880: p_action_prms IN action_parameters_rectype,
3881: p_stop_attr_tab IN WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type,
3882: x_valid_ids_tab OUT NOCOPY WSH_UTIL_CORE.id_Tab_Type,
3883: x_return_status OUT NOCOPY VARCHAR2
3884: )
3885: IS