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

Line 1: PACKAGE BODY WSH_TRIP_STOPS_GRP as

1: PACKAGE BODY WSH_TRIP_STOPS_GRP as
2: /* $Header: WSHSTGPB.pls 120.6 2007/01/05 19:24:49 parkhj noship $ */
3:
4: --===================
5: -- CONSTANTS

Line 7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WSH_TRIP_STOPS_GRP';

3:
4: --===================
5: -- CONSTANTS
6: --===================
7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WSH_TRIP_STOPS_GRP';
8: -- add your constants here if any
9:
10: -- Forward declaration
11: PROCEDURE Lock_Related_Entity

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 20: p_stop_tab IN WSH_TRIP_STOPS_VALIDATIONS.stop_details_tab,

16: x_return_status OUT NOCOPY VARCHAR2
17: );
18:
19: PROCEDURE Add_to_Delete_List(
20: p_stop_tab IN WSH_TRIP_STOPS_VALIDATIONS.stop_details_tab,
21: p_caller IN VARCHAR2,
22: x_stop_delete_tab OUT NOCOPY wsh_util_core.id_tab_type,
23: x_trip_affected_tab OUT NOCOPY wsh_util_core.id_tab_type,
24: x_return_status OUT NOCOPY VARCHAR2) ;

Line 62: p_stop_info IN OUT NOCOPY WSH_TRIP_STOPS_GRP.Trip_Stop_Pub_Rec_Type,

58: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
59: x_return_status OUT NOCOPY VARCHAR2,
60: x_msg_count OUT NOCOPY NUMBER,
61: x_msg_data OUT NOCOPY VARCHAR2,
62: p_stop_info IN OUT NOCOPY WSH_TRIP_STOPS_GRP.Trip_Stop_Pub_Rec_Type,
63: p_stop_IN_rec IN stopActionInRecType,
64: x_stop_OUT_rec OUT NOCOPY stopActionOutRecType) IS
65:
66:

Line 80: l_action_prms WSH_TRIP_STOPS_GRP.action_parameters_rectype;

76:
77: --
78:
79: l_stop_rows wsh_util_core.id_tab_type;
80: l_action_prms WSH_TRIP_STOPS_GRP.action_parameters_rectype;
81:
82: l_encoded VARCHAR2(1) := 'F';
83:
84: --

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 318: l_action_prms WSH_TRIP_STOPS_GRP.action_parameters_rectype;

314: l_num_errors NUMBER;
315: l_num_warning NUMBER;
316:
317: l_stop_OUT_rec stopActionOutRecType;
318: l_action_prms WSH_TRIP_STOPS_GRP.action_parameters_rectype;
319:
320: l_encoded VARCHAR2(1) := 'F';
321:
322: --

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 520: l_stop_rec_tab wsh_trip_stops_validations.stop_rec_tab_type;

516: l_error_ids wsh_util_core.id_tab_type;
517: l_dummy_ids wsh_util_core.id_tab_type;
518: l_dummy_doc_param WSH_DOCUMENT_SETS.DOCUMENT_SET_TAB_TYPE;
519: l_num NUMBER;
520: l_stop_rec_tab wsh_trip_stops_validations.stop_rec_tab_type;
521: l_first NUMBER;
522: l_next NUMBER;
523: l_last NUMBER;
524: l_stop_id 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 572: l_delete_tmp_tab WSH_TRIP_STOPS_VALIDATIONS.stop_details_tab;

568: --Compatibility Changes
569: l_stop_delete_tab wsh_util_core.id_tab_type;
570: l_trip_affected_tab wsh_util_core.id_tab_type;
571: l_success_trip_tab wsh_util_core.id_tab_type;
572: l_delete_tmp_tab WSH_TRIP_STOPS_VALIDATIONS.stop_details_tab;
573: l_delete_t WSH_TRIP_STOPS_VALIDATIONS.stop_details_tab;
574:
575: CURSOR c_check_trip_close (p_trip_id IN NUMBER) IS
576: SELECT trip_id

Line 573: l_delete_t WSH_TRIP_STOPS_VALIDATIONS.stop_details_tab;

569: l_stop_delete_tab wsh_util_core.id_tab_type;
570: l_trip_affected_tab wsh_util_core.id_tab_type;
571: l_success_trip_tab wsh_util_core.id_tab_type;
572: l_delete_tmp_tab WSH_TRIP_STOPS_VALIDATIONS.stop_details_tab;
573: l_delete_t WSH_TRIP_STOPS_VALIDATIONS.stop_details_tab;
574:
575: CURSOR c_check_trip_close (p_trip_id IN NUMBER) IS
576: SELECT trip_id
577: FROM WSH_TRIPS

Line 581: from wsh_trip_stops

577: FROM WSH_TRIPS
578: WHERE trip_id=p_trip_id
579: AND status_code='IT'
580: AND NOT EXISTS (select 'x'
581: from wsh_trip_stops
582: where trip_id=p_trip_id
583: and status_code IN ('OP', 'AR')
584: and rownum=1);
585: l_trip_in_rec WSH_TRIP_VALIDATIONS.ChgStatus_in_rec_type;

Line 735: WSH_TRIP_STOPS_validations.Is_Action_Enabled(

731: --
732: END IF;
733:
734: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_ACTION_ENABLED_LVL) = 1 THEN
735: WSH_TRIP_STOPS_validations.Is_Action_Enabled(
736: p_stop_rec_tab => l_stop_rec_tab,
737: p_action => p_action_prms.action_code,
738: p_caller => p_action_prms.caller,
739: x_return_status => l_return_status,

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 1052: WSH_TRIP_STOPS_ACTIONS.plan (

1048:
1049: END IF;
1050:
1051: IF p_action_prms.action_code = 'PLAN' THEN
1052: WSH_TRIP_STOPS_ACTIONS.plan (
1053: p_stop_rows => l_stop_id_tab,
1054: p_action => 'PLAN',
1055: --tkt
1056: p_caller => p_action_prms.caller,

Line 1063: WSH_TRIP_STOPS_ACTIONS.plan (

1059: wsh_util_core.api_post_call(p_return_status =>l_return_status,
1060: x_num_warnings =>l_num_warning,
1061: x_num_errors =>l_num_errors);
1062: ELSIF p_action_prms.action_code = 'UNPLAN' THEN
1063: WSH_TRIP_STOPS_ACTIONS.plan (
1064: p_stop_rows => l_stop_id_tab,
1065: p_action => 'UNPLAN',
1066: --tkt
1067: p_caller => p_action_prms.caller,

Line 1134: WSH_TRIP_STOPS_ACTIONS.calc_stop_weight_volume(

1130: WSH_WV_UTILS.G_RESET_WV := 'Y'; -- set to Y to enable the update
1131: END IF;
1132: -- End of OTM R12 : packing ECO
1133:
1134: WSH_TRIP_STOPS_ACTIONS.calc_stop_weight_volume(
1135: p_stop_rows => l_stop_id_tab,
1136: p_override_flag => p_action_prms.override_flag,
1137: x_return_status => l_return_status,
1138: --tkt

Line 1191: WSH_TRIP_STOPS_GRP.get_stop_details_pvt(

1187: BEGIN
1188:
1189: SAVEPOINT s_clean_loop_grp;
1190:
1191: WSH_TRIP_STOPS_GRP.get_stop_details_pvt(
1192: p_stop_id => l_stop_id_tab(i),
1193: x_stop_rec => l_stop_rec,
1194: x_return_status => l_return_status
1195: );

Line 1247: WSH_TRIP_STOPS_ACTIONS.Check_Update_Stops(

1243: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_CHK_UPDATE_STATUS_LVL) = 1 THEN
1244: if l_debug_on then
1245: wsh_debug_sv.log(l_module_name, 'l_stop_id_tab count', l_stop_id_tab.count);
1246: end if;
1247: WSH_TRIP_STOPS_ACTIONS.Check_Update_Stops(
1248: p_stop_rows => l_stop_id_tab,
1249: p_action => p_action_prms.stop_action,
1250: --tkt
1251: p_caller => p_action_prms.caller,

Line 1259: WSH_TRIP_STOPS_ACTIONS.Change_Status(

1255: x_num_warnings =>l_num_warning,
1256: x_num_errors =>l_num_errors);
1257: END IF;
1258:
1259: WSH_TRIP_STOPS_ACTIONS.Change_Status(
1260: p_stop_rows => l_stop_id_tab,
1261: p_action => p_action_prms.stop_action,
1262: p_actual_date => l_actual_date,
1263: p_defer_interface_flag => p_action_prms.defer_interface_flag,

Line 1736: wsh_util_core.default_handler('WSH_TRIP_STOPS_GRP.STOP_ACTION',

1732: ROLLBACK TO s_stop_action_grp;
1733: IF c_check_trip_close%ISOPEN THEN
1734: CLOSE c_check_trip_close;
1735: END IF;
1736: wsh_util_core.default_handler('WSH_TRIP_STOPS_GRP.STOP_ACTION',
1737: l_module_name);
1738:
1739:
1740: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 1776: -- PARAMETERS: p_grp_stop_rec IN WSH_TRIP_STOPS_GRP.TRIP_STOP_PUB_REC_TYPE

1772: --Harmonizing Project **heali
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: --========================================================================

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 1782: p_grp_stop_rec IN WSH_TRIP_STOPS_GRP.TRIP_STOP_PUB_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(
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;

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 1930: l_stop_details_rec WSH_TRIP_STOPS_VALIDATIONS.stop_details;

1926: WSH_STOP_VALIDATION EXCEPTION;
1927: e_mixed_stop_error EXCEPTION;
1928:
1929: -- J-Stop Sequence Change-CSUN
1930: l_stop_details_rec WSH_TRIP_STOPS_VALIDATIONS.stop_details;
1931:
1932: l_stop_id NUMBER;
1933:
1934: BEGIN

Line 2126: WSH_TRIP_STOPS_validations.validate_sequence_number (

2122: IF (WSH_TRIPS_ACTIONS.GET_STOP_SEQ_MODE = WSH_INTERFACE_GRP.G_STOP_SEQ_MODE_SSN) AND
2123: (WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_SEQ_NUM_LVL) = 1 ) THEN
2124:
2125: IF (l_status_code = 'OP') THEN
2126: WSH_TRIP_STOPS_validations.validate_sequence_number (
2127: p_stop_id => p_rec_attr_tab(l_index).stop_id,
2128: p_stop_sequence_number => p_rec_attr_tab(l_index).stop_sequence_number,
2129: p_trip_id => p_rec_attr_tab(l_index).trip_id,
2130: p_status_code => l_status_code,

Line 2260: wsh_util_core.default_handler ('WSH_TRIP_STOPS_GRP.Validate_Stop');

2256: END IF;
2257:
2258: WHEN OTHERS THEN
2259: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2260: wsh_util_core.default_handler ('WSH_TRIP_STOPS_GRP.Validate_Stop');
2261: FND_MSG_PUB.Count_And_Get (
2262: p_count => x_msg_count,
2263: p_data => x_msg_data,
2264: p_encoded => FND_API.G_FALSE);

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 2361: FROM wsh_trip_stops

2357: departure_gross_weight,
2358: departure_net_weight,
2359: departure_volume,
2360: departure_fill_percent
2361: FROM wsh_trip_stops
2362: WHERE trip_id = p_trip_id ;
2363:
2364: -- bug 3848771
2365: CURSOR c_trip_info (p_trip_id in number) is

Line 2384: l_stop_details_rec WSH_TRIP_STOPS_VALIDATIONS.stop_details;

2380: l_stop_id NUMBER;
2381: l_stop_index NUMBER :=0;
2382: --bug 2796095
2383: l_status_code VARCHAR2(100);
2384: l_stop_details_rec WSH_TRIP_STOPS_VALIDATIONS.stop_details;
2385: l_handle_internal_stops BOOLEAN;
2386: l_reset_stop_sequence BOOLEAN;
2387:
2388: get_physical_loc_err EXCEPTION;

Line 2508: WSH_TRIP_STOPS_validations.get_disabled_list(

2504: WSH_DEBUG_SV.log(l_module_name,'stop_id,trip_id',p_rec_attr_tab(l_index).stop_id||','||
2505: p_rec_attr_tab(l_index).trip_id);
2506: END IF;
2507:
2508: WSH_TRIP_STOPS_validations.get_disabled_list(
2509: p_stop_rec => p_rec_attr_tab(l_index),
2510: p_parent_entity_id => p_rec_attr_tab(l_index).trip_id,
2511: p_in_rec => p_in_rec,
2512: x_return_status => l_return_status,

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 3466: wsh_util_core.default_handler ('WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP');

3462: IF c_trip_info%ISOPEN THEN
3463: CLOSE c_trip_info;
3464: END IF;
3465: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3466: wsh_util_core.default_handler ('WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP');
3467: --Bugfix 4070732 {
3468: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
3469: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
3470: IF l_debug_on THEN

Line 3515: -- COMMENT : Creates or updates a record in wsh_trip_stops table with information

3511: -- p_planned_dep_date Planned departure date for update
3512: -- x_stop_id - stop id of new stop
3513: -- VERSION : current version 1.0
3514: -- initial version 1.0
3515: -- COMMENT : Creates or updates a record in wsh_trip_stops table with information
3516: -- specified in p_stop_info. Use p_trip_id, p_trip_name, p_stop_location_id,
3517: -- p_stop_location_code or p_planned_dep_date to update these values
3518: -- on an existing stop.
3519: --========================================================================

Line 3527: p_stop_info IN OUT NOCOPY WSH_TRIP_STOPS_GRP.Trip_Stop_Pub_Rec_Type,

3523: x_return_status OUT NOCOPY VARCHAR2,
3524: x_msg_count OUT NOCOPY NUMBER,
3525: x_msg_data OUT NOCOPY VARCHAR2,
3526: p_action_code IN VARCHAR2,
3527: p_stop_info IN OUT NOCOPY WSH_TRIP_STOPS_GRP.Trip_Stop_Pub_Rec_Type,
3528: p_trip_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
3529: p_trip_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
3530: p_stop_location_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
3531: p_stop_location_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

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 3629: WSH_DEBUG_SV.log(l_module_name,'WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP x_return_status',x_return_status);

3625: x_msg_count => x_msg_count,
3626: x_msg_data => x_msg_data);
3627:
3628: IF l_debug_on THEN
3629: WSH_DEBUG_SV.log(l_module_name,'WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP x_return_status',x_return_status);
3630: END IF;
3631:
3632: IF ( x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS AND l_stop_out_tab.count > 0) THEN
3633: x_stop_id := l_stop_out_tab(l_stop_out_tab.FIRST).stop_id;

Line 3648: wsh_util_core.default_handler ('WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP');

3644:
3645: EXCEPTION
3646: WHEN OTHERS THEN
3647: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3648: wsh_util_core.default_handler ('WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP');
3649: IF l_debug_on THEN
3650: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
3651: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3652: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 3671: -- COMMENT : Creates or updates a record in wsh_trip_stops table with information

3667: -- p_stop_IN_rec Input Attributes for the stop entity
3668: -- p_stop_OUT_rec Output Attributes for the stop entity
3669: -- VERSION : current version 1.0
3670: -- initial version 1.0
3671: -- COMMENT : Creates or updates a record in wsh_trip_stops table with information
3672: -- specified in p_stop_info. Use p_trip_id, p_trip_name, p_stop_location_id,
3673: -- p_stop_location_code or p_planned_dep_date to update these values
3674: -- on an existing stop.
3675: --========================================================================

Line 3683: p_stop_info IN OUT NOCOPY WSH_TRIP_STOPS_GRP.Trip_Stop_Pub_Rec_Type,

3679: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
3680: x_return_status OUT NOCOPY VARCHAR2,
3681: x_msg_count OUT NOCOPY NUMBER,
3682: x_msg_data OUT NOCOPY VARCHAR2,
3683: p_stop_info IN OUT NOCOPY WSH_TRIP_STOPS_GRP.Trip_Stop_Pub_Rec_Type,
3684: p_stop_IN_rec IN stopInRecType,
3685: x_stop_OUT_rec OUT NOCOPY stopOutRecType) IS
3686:
3687: l_api_version_number CONSTANT NUMBER := 1.0;

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 3774: WSH_DEBUG_SV.log(l_module_name,'WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP x_return_status',x_return_status);

3770: x_msg_count => x_msg_count,
3771: x_msg_data => x_msg_data);
3772:
3773: IF l_debug_on THEN
3774: WSH_DEBUG_SV.log(l_module_name,'WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP x_return_status',x_return_status);
3775: END IF;
3776:
3777: IF ( x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS AND l_stop_out_tab.count > 0) THEN
3778: x_stop_out_rec := l_stop_out_tab(l_stop_out_tab.FIRST);

Line 3798: wsh_util_core.default_handler ('WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP');

3794: END IF;
3795:
3796: WHEN OTHERS THEN
3797: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3798: wsh_util_core.default_handler ('WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP');
3799: IF l_debug_on THEN
3800: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
3801: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3802: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

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 3851: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_TRIP_STOPS_GRP.get_stop_details_pvt',l_module_name);

3847: END IF;
3848: --
3849: EXCEPTION
3850: WHEN OTHERS THEN
3851: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_TRIP_STOPS_GRP.get_stop_details_pvt',l_module_name);
3852: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3853: --
3854: IF l_debug_on THEN
3855: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

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

Line 3903: FROM wsh_trip_stops wts, wsh_trips wt

3899: AND wnd.ultimate_dropoff_location_id = p_stop_loc_id;
3900: --
3901: CURSOR c_stop_trip_info(p_stop_id NUMBER) IS
3902: SELECT wts.trip_id, wts.stop_location_id, wt.status_code
3903: FROM wsh_trip_stops wts, wsh_trips wt
3904: WHERE wts.stop_id = p_stop_id
3905: AND wts.trip_id = wt.trip_id;
3906: --
3907: CURSOR c_unclosed_other_stops(p_trip_id NUMBER, p_stop_id NUMBER) IS

Line 3909: FROM wsh_trip_stops wts

3905: AND wts.trip_id = wt.trip_id;
3906: --
3907: CURSOR c_unclosed_other_stops(p_trip_id NUMBER, p_stop_id NUMBER) IS
3908: SELECT wts.stop_id
3909: FROM wsh_trip_stops wts
3910: WHERE wts.trip_id = p_trip_id
3911: AND wts.status_code <> 'CL'
3912: AND wts.stop_id <> p_stop_id;
3913:

Line 4114: p_stop_tab IN WSH_TRIP_STOPS_VALIDATIONS.stop_details_tab,

4110:
4111:
4112:
4113: PROCEDURE Add_to_Delete_List(
4114: p_stop_tab IN WSH_TRIP_STOPS_VALIDATIONS.stop_details_tab,
4115: p_caller IN VARCHAR2,
4116: x_stop_delete_tab OUT NOCOPY wsh_util_core.id_tab_type,
4117: x_trip_affected_tab OUT NOCOPY wsh_util_core.id_tab_type,
4118: x_return_status OUT NOCOPY VARCHAR2)

Line 4126: FROM wsh_trip_stops

4122: CURSOR c_linked_stop(c_stop_id IN NUMBER, c_trip_id NUMBER) IS
4123: SELECT physical_stop_id linked_stop_id,
4124: 1 link_type ,
4125: trip_id
4126: FROM wsh_trip_stops
4127: WHERE stop_id = c_stop_id
4128: AND physical_stop_id IS NOT NULL
4129: AND trip_id = c_trip_id
4130: UNION

Line 4134: FROM wsh_trip_stops

4130: UNION
4131: SELECT stop_id linked_stop_id,
4132: 2 link_type ,
4133: trip_id
4134: FROM wsh_trip_stops
4135: WHERE physical_stop_id = c_stop_id
4136: AND status_code = 'OP'
4137: AND trip_id = c_trip_id;
4138:

Line 4257: wsh_util_core.default_handler('WSH_TRIP_STOPS_VALIDATIONS.Add_to_Delete_List',l_module_name);

4253: IF c_linked_stop%ISOPEN THEN
4254: close c_linked_stop;
4255: END IF;
4256:
4257: wsh_util_core.default_handler('WSH_TRIP_STOPS_VALIDATIONS.Add_to_Delete_List',l_module_name);
4258: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4259: IF l_debug_on THEN
4260: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
4261: END IF;

Line 4267: END WSH_TRIP_STOPS_GRP;

4263: END Add_to_Delete_List;
4264:
4265: -- end csun 10+ internal location
4266:
4267: END WSH_TRIP_STOPS_GRP;