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_PVT dependencies on WSH_UTIL_CORE

Line 28: l_trips wsh_util_core.id_tab_type;

24: l_row_count NUMBER;
25: l_temp_id NUMBER;
26: l_physical_loc_id NUMBER;
27: l_return_status VARCHAR2(1);
28: l_trips wsh_util_core.id_tab_type;
29: l_success_trip_ids wsh_util_core.id_tab_type;
30: others EXCEPTION;
31: get_physical_loc_err EXCEPTION;
32:

Line 29: l_success_trip_ids wsh_util_core.id_tab_type;

25: l_temp_id NUMBER;
26: l_physical_loc_id NUMBER;
27: l_return_status VARCHAR2(1);
28: l_trips wsh_util_core.id_tab_type;
29: l_success_trip_ids wsh_util_core.id_tab_type;
30: others EXCEPTION;
31: get_physical_loc_err EXCEPTION;
32:
33: cursor l_trip_shipments_type_csr(p_trip_id IN NUMBER) is

Line 40: l_stop_tab WSH_UTIL_CORE.id_tab_type; -- DBI Project

36: where trip_id = p_trip_id;
37:
38: l_shipments_type_flag VARCHAR2(100);
39:
40: l_stop_tab WSH_UTIL_CORE.id_tab_type; -- DBI Project
41: l_dbi_rs VARCHAR2(1); -- DBI Project
42:
43: l_wf_rs VARCHAR2(1); -- Workflow Project
44: --

Line 88: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

84: WSH_DEBUG_SV.log(l_module_name,'UNLOADING_END_DATETIME',p_trip_stop_info.UNLOADING_END_DATETIME);
85: WSH_DEBUG_SV.log(l_module_name,'SHIPMENTS_TYPE_FLAG',p_trip_stop_info.SHIPMENTS_TYPE_FLAG);
86: END IF;
87: --
88: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
89: l_trips.DELETE;
90: x_stop_id := p_trip_stop_info.stop_id;
91:
92: l_shipments_type_flag := p_trip_stop_info.shipments_type_flag;

Line 133: IF l_return_status in ( WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR) THEN

129: p_internal_cust_location_id => p_trip_stop_info.stop_location_id,
130: x_internal_org_location_id => l_physical_loc_id,
131: x_return_status => l_return_status );
132:
133: IF l_return_status in ( WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
134: raise get_physical_loc_err;
135: END IF;
136:
137: IF l_debug_on THEN

Line 330: IF l_dbi_rs = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

326:
327: IF l_debug_on THEN
328: WSH_DEBUG_SV.log(l_module_name,'Return Status after DBI Call-',l_dbi_rs);
329: END IF;
330: IF l_dbi_rs = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
331: x_return_status := l_dbi_rs;
332: -- just pass this return status to caller API
333: IF l_debug_on THEN
334: WSH_DEBUG_SV.log(l_module_name,'DBI API Returned Unexpected error '||x_return_status);

Line 364: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

360: --
361: EXCEPTION
362:
363: WHEN get_physical_loc_err THEN
364: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
365: fnd_message.set_name('WSH', 'WSH_LOCATION_CONVERT_ERR');
366: fnd_message.set_token('LOCATION_NAME',
367: SUBSTRB(WSH_UTIL_CORE.get_location_description(p_trip_stop_info.stop_location_id,'NEW UI CODE'), 1, 60));
368: wsh_util_core.add_message(x_return_status,l_module_name);

Line 367: SUBSTRB(WSH_UTIL_CORE.get_location_description(p_trip_stop_info.stop_location_id,'NEW UI CODE'), 1, 60));

363: WHEN get_physical_loc_err THEN
364: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
365: fnd_message.set_name('WSH', 'WSH_LOCATION_CONVERT_ERR');
366: fnd_message.set_token('LOCATION_NAME',
367: SUBSTRB(WSH_UTIL_CORE.get_location_description(p_trip_stop_info.stop_location_id,'NEW UI CODE'), 1, 60));
368: wsh_util_core.add_message(x_return_status,l_module_name);
369:
370: WHEN others THEN
371: wsh_util_core.default_handler('WSH_TRIP_STOPS_PVT.CREATE_TRIP_STOP',l_module_name);

Line 368: wsh_util_core.add_message(x_return_status,l_module_name);

364: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
365: fnd_message.set_name('WSH', 'WSH_LOCATION_CONVERT_ERR');
366: fnd_message.set_token('LOCATION_NAME',
367: SUBSTRB(WSH_UTIL_CORE.get_location_description(p_trip_stop_info.stop_location_id,'NEW UI CODE'), 1, 60));
368: wsh_util_core.add_message(x_return_status,l_module_name);
369:
370: WHEN others THEN
371: wsh_util_core.default_handler('WSH_TRIP_STOPS_PVT.CREATE_TRIP_STOP',l_module_name);
372: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 371: wsh_util_core.default_handler('WSH_TRIP_STOPS_PVT.CREATE_TRIP_STOP',l_module_name);

367: SUBSTRB(WSH_UTIL_CORE.get_location_description(p_trip_stop_info.stop_location_id,'NEW UI CODE'), 1, 60));
368: wsh_util_core.add_message(x_return_status,l_module_name);
369:
370: WHEN others THEN
371: wsh_util_core.default_handler('WSH_TRIP_STOPS_PVT.CREATE_TRIP_STOP',l_module_name);
372: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
373:
374: --
375: -- Debug Statements

Line 372: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

368: wsh_util_core.add_message(x_return_status,l_module_name);
369:
370: WHEN others THEN
371: wsh_util_core.default_handler('WSH_TRIP_STOPS_PVT.CREATE_TRIP_STOP',l_module_name);
372: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
373:
374: --
375: -- Debug Statements
376: --

Line 422: l_trip_id_tab wsh_util_core.id_tab_type;

418:
419:
420: l_stop_id NUMBER;
421: l_trip_id NUMBER;
422: l_trip_id_tab wsh_util_core.id_tab_type;
423: others EXCEPTION;
424:
425: l_return_status VARCHAR2(1);
426: l_warn_num NUMBER := 0;

Line 428: l_stop_tab WSH_UTIL_CORE.id_tab_type; -- DBI Project

424:
425: l_return_status VARCHAR2(1);
426: l_warn_num NUMBER := 0;
427:
428: l_stop_tab WSH_UTIL_CORE.id_tab_type; -- DBI Project
429: l_dbi_rs VARCHAR2(1); -- DBI Project
430:
431: --OTM R12, glog proj
432: l_ignore WSH_TRIPS.IGNORE_FOR_PLANNING%TYPE;

Line 466: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

462: END IF;
463: --
464: l_stop_id := p_stop_id;
465:
466: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
467:
468: --OTM R12, glog proj, use Global Variable
469: l_gc3_is_installed := WSH_UTIL_CORE.G_GC3_IS_INSTALLED;
470:

Line 469: l_gc3_is_installed := WSH_UTIL_CORE.G_GC3_IS_INSTALLED;

465:
466: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
467:
468: --OTM R12, glog proj, use Global Variable
469: l_gc3_is_installed := WSH_UTIL_CORE.G_GC3_IS_INSTALLED;
470:
471: -- If null, call the function
472: IF l_gc3_is_installed IS NULL THEN
473: l_gc3_is_installed := WSH_UTIL_CORE.GC3_IS_INSTALLED;

Line 473: l_gc3_is_installed := WSH_UTIL_CORE.GC3_IS_INSTALLED;

469: l_gc3_is_installed := WSH_UTIL_CORE.G_GC3_IS_INSTALLED;
470:
471: -- If null, call the function
472: IF l_gc3_is_installed IS NULL THEN
473: l_gc3_is_installed := WSH_UTIL_CORE.GC3_IS_INSTALLED;
474: END IF;
475: -- end of OTM R12, glog proj
476:
477:

Line 509: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

505: IF l_debug_on THEN
506: WSH_DEBUG_SV.logmsg(l_module_name,'Ignore:'||l_ignore||' Tp Plan:'||l_tp_plan_name);
507: END IF;
508: IF (l_ignore = 'N' AND l_tp_plan_name IS NOT NULL) THEN
509: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
510: RAISE e_gc3_trip;
511: END IF;
512: END IF;
513: --

Line 532: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

528: IF l_debug_on THEN
529: WSH_DEBUG_SV.log(l_module_name,'CHECK_STOP_DELETE x_return_status',x_return_status);
530: END IF;
531:
532: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
533: x_return_status := l_return_status;
534: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_DELETE_ERROR');
535: --
536: -- Debug Statements

Line 543: wsh_util_core.add_message(x_return_status,l_module_name);

539: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
540: END IF;
541: --
542: FND_MESSAGE.SET_TOKEN('STOP_NAME',wsh_trip_stops_pvt.get_name(l_stop_id, p_caller));
543: wsh_util_core.add_message(x_return_status,l_module_name);
544: --
545: -- Debug Statements
546: --
547: IF l_debug_on THEN

Line 552: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

548: WSH_DEBUG_SV.pop(l_module_name);
549: END IF;
550: --
551: RETURN;
552: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
553: l_warn_num := l_warn_num + 1;
554:
555: END IF;
556: END IF;

Line 578: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

574: IF l_debug_on THEN
575: WSH_DEBUG_SV.log(l_module_name,'After Calling Delete_Delivery_Leg x_return_status',x_return_status);
576: END IF;
577:
578: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
579: IF l_debug_on THEN
580: WSH_DEBUG_SV.pop(l_module_name);
581: END IF;
582: x_return_status := l_return_status;

Line 584: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

580: WSH_DEBUG_SV.pop(l_module_name);
581: END IF;
582: x_return_status := l_return_status;
583: RETURN;
584: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
585: l_warn_num := l_warn_num + 1;
586: END IF;
587:
588: END LOOP;

Line 611: IF l_dbi_rs = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

607:
608: IF l_debug_on THEN
609: WSH_DEBUG_SV.log(l_module_name,'Return Status after DBI Call-',l_dbi_rs);
610: END IF;
611: IF l_dbi_rs = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
612: x_return_status := l_dbi_rs;
613: -- just pass this return status to caller API
614: IF l_debug_on THEN
615: WSH_DEBUG_SV.log(l_module_name,'DBI API Returned Unexpected error '||x_return_status);

Line 641: IF x_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

637: p_calc_del_wv => 'N',
638: x_return_status => x_return_status,
639: p_suppress_errors => 'Y');
640:
641: IF x_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
642: IF l_debug_on THEN
643: WSH_DEBUG_SV.logmsg(l_module_name,'Error calculating trip wt/vol');
644: END IF;
645: END IF;

Line 653: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS and l_warn_num > 0 THEN

649: ELSE
650: raise others;
651: END IF;
652:
653: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS and l_warn_num > 0 THEN
654: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
655: END IF;
656:
657: --

Line 654: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

650: raise others;
651: END IF;
652:
653: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS and l_warn_num > 0 THEN
654: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
655: END IF;
656:
657: --
658: -- Debug Statements

Line 672: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

668: IF c_get_trip_status%ISOPEN THEN
669: CLOSE c_get_trip_status;
670: END IF;
671: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_NOT_FOUND');
672: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
673: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
674: --
675: -- Debug Statements
676: --

Line 673: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

669: CLOSE c_get_trip_status;
670: END IF;
671: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_NOT_FOUND');
672: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
673: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
674: --
675: -- Debug Statements
676: --
677: IF l_debug_on THEN

Line 689: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

685: IF c_get_trip_status%ISOPEN THEN
686: CLOSE c_get_trip_status;
687: END IF;
688: FND_MESSAGE.SET_NAME('WSH','WSH_OTM_TRIP_STOP_DEL_ERROR');
689: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
690: wsh_util_core.add_message(x_return_status);
691: --
692: -- Debug Statements
693: --

Line 690: wsh_util_core.add_message(x_return_status);

686: CLOSE c_get_trip_status;
687: END IF;
688: FND_MESSAGE.SET_NAME('WSH','WSH_OTM_TRIP_STOP_DEL_ERROR');
689: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
690: wsh_util_core.add_message(x_return_status);
691: --
692: -- Debug Statements
693: --
694: IF l_debug_on THEN

Line 704: wsh_util_core.default_handler('WSH_TRIP_STOPS_PVT.DELETE_TRIP_STOP',l_module_name);

700: WHEN others THEN
701: IF c_get_trip_status%ISOPEN THEN
702: CLOSE c_get_trip_status;
703: END IF;
704: wsh_util_core.default_handler('WSH_TRIP_STOPS_PVT.DELETE_TRIP_STOP',l_module_name);
705: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
706:
707: --
708: -- Debug Statements

Line 705: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

701: IF c_get_trip_status%ISOPEN THEN
702: CLOSE c_get_trip_status;
703: END IF;
704: wsh_util_core.default_handler('WSH_TRIP_STOPS_PVT.DELETE_TRIP_STOP',l_module_name);
705: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
706:
707: --
708: -- Debug Statements
709: --

Line 745: l_stop_tab WSH_UTIL_CORE.id_tab_type; -- DBI Project

741: l_return_status VARCHAR2(1);
742:
743: l_rowid VARCHAR2(30);
744:
745: l_stop_tab WSH_UTIL_CORE.id_tab_type; -- DBI Project
746: l_dbi_rs VARCHAR2(1); -- DBI Project
747:
748: --
749: l_debug_on BOOLEAN;

Line 941: IF l_dbi_rs = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

937:
938: IF l_debug_on THEN
939: WSH_DEBUG_SV.log(l_module_name,'Return Status after DBI Call-',l_dbi_rs);
940: END IF;
941: IF l_dbi_rs = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
942: x_return_status := l_dbi_rs;
943: -- just pass this return status to caller API
944: IF l_debug_on THEN
945: WSH_DEBUG_SV.log(l_module_name,'DBI API Returned Unexpected error '||x_return_status);

Line 953: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

949: END IF;
950: -- End of Code for DBI Project
951: --
952:
953: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
954:
955: --
956: -- Debug Statements
957: --

Line 965: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

961: --
962: EXCEPTION
963: WHEN no_data_found THEN
964: FND_MESSAGE.Set_Name('WSH','WSH_STOP_NOT_FOUND');
965: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
966: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
967: --
968: -- Debug Statements
969: --

Line 966: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);

962: EXCEPTION
963: WHEN no_data_found THEN
964: FND_MESSAGE.Set_Name('WSH','WSH_STOP_NOT_FOUND');
965: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
966: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
967: --
968: -- Debug Statements
969: --
970: IF l_debug_on THEN

Line 976: wsh_util_core.default_handler('WSH_TRIP_STOPS_PVT.UPDATE_TRIP_STOP',l_module_name);

972: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_DATA_FOUND');
973: END IF;
974: --
975: WHEN others THEN
976: wsh_util_core.default_handler('WSH_TRIP_STOPS_PVT.UPDATE_TRIP_STOP',l_module_name);
977: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
978:
979: --
980: -- Debug Statements

Line 977: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

973: END IF;
974: --
975: WHEN others THEN
976: wsh_util_core.default_handler('WSH_TRIP_STOPS_PVT.UPDATE_TRIP_STOP',l_module_name);
977: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
978:
979: --
980: -- Debug Statements
981: --

Line 1451: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1447: FETCH stop_record INTO x_stop_info;
1448:
1449: IF (stop_record%NOTFOUND) THEN
1450: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_NOT_FOUND');
1451: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1452: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
1453: ELSE
1454: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1455: END IF;

Line 1452: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);

1448:
1449: IF (stop_record%NOTFOUND) THEN
1450: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_NOT_FOUND');
1451: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1452: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
1453: ELSE
1454: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1455: END IF;
1456:

Line 1454: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1450: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_NOT_FOUND');
1451: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1452: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
1453: ELSE
1454: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1455: END IF;
1456:
1457: CLOSE stop_record;
1458:

Line 1468: wsh_util_core.default_handler('WSH_TRIP_STOPS_PVT.POPULATE_RECORD',l_module_name);

1464: END IF;
1465: --
1466: EXCEPTION
1467: WHEN others THEN
1468: wsh_util_core.default_handler('WSH_TRIP_STOPS_PVT.POPULATE_RECORD',l_module_name);
1469: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1470:
1471: --
1472: -- Debug Statements

Line 1469: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1465: --
1466: EXCEPTION
1467: WHEN others THEN
1468: wsh_util_core.default_handler('WSH_TRIP_STOPS_PVT.POPULATE_RECORD',l_module_name);
1469: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1470:
1471: --
1472: -- Debug Statements
1473: --

Line 1549: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);

1545:
1546: IF get_id%NOTFOUND THEN
1547: CLOSE get_id;
1548: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_NOT_FOUND');
1549: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
1550: IF l_debug_on THEN
1551: WSH_DEBUG_SV.pop(l_module_name);
1552: END IF;
1553: RETURN null;

Line 1571: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_LOCATION_DESCRIPTION',WSH_DEBUG_SV.C_PROC_LEVEL);

1567: --
1568: -- Debug Statements
1569: --
1570: IF l_debug_on THEN
1571: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_LOCATION_DESCRIPTION',WSH_DEBUG_SV.C_PROC_LEVEL);
1572: WSH_DEBUG_SV.log(l_module_name,'x_id',x_id);
1573: END IF;
1574: --
1575: l_name := WSH_UTIL_CORE.get_location_description(x_id, 'NEW UI CODE');

Line 1575: l_name := WSH_UTIL_CORE.get_location_description(x_id, 'NEW UI CODE');

1571: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_LOCATION_DESCRIPTION',WSH_DEBUG_SV.C_PROC_LEVEL);
1572: WSH_DEBUG_SV.log(l_module_name,'x_id',x_id);
1573: END IF;
1574: --
1575: l_name := WSH_UTIL_CORE.get_location_description(x_id, 'NEW UI CODE');
1576: x_name := SUBSTR(l_name,1,60);
1577:
1578: IF (x_name IS NULL) THEN
1579: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_NOT_FOUND');

Line 1580: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);

1576: x_name := SUBSTR(l_name,1,60);
1577:
1578: IF (x_name IS NULL) THEN
1579: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_NOT_FOUND');
1580: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
1581: --
1582: -- Debug Statements
1583: --
1584: IF l_debug_on THEN

Line 1603: wsh_util_core.default_handler('WSH_TRIP_STOPS_PVT.GET_NAME',l_module_name);

1599:
1600: EXCEPTION
1601:
1602: WHEN others THEN
1603: wsh_util_core.default_handler('WSH_TRIP_STOPS_PVT.GET_NAME',l_module_name);
1604: --
1605: IF l_debug_on THEN
1606: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1607: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 1628: x_disabled_list OUT NOCOPY wsh_util_core.column_tab_type,

1624: p_stop_id IN NUMBER,
1625: p_parent_entity_id IN NUMBER,
1626: p_list_type IN VARCHAR2,
1627: x_return_status OUT NOCOPY VARCHAR2,
1628: x_disabled_list OUT NOCOPY wsh_util_core.column_tab_type,
1629: x_msg_count OUT NOCOPY NUMBER,
1630: x_msg_data OUT NOCOPY VARCHAR2,
1631: p_caller IN VARCHAR2 -- DEFAULT NULL, --3509004:public api changes
1632: ) IS

Line 1734: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1730: WSH_DEBUG_SV.log(l_module_name,'P_PARENT_ENTITY_ID',P_PARENT_ENTITY_ID);
1731: WSH_DEBUG_SV.log(l_module_name,'P_LIST_TYPE',P_LIST_TYPE);
1732: END IF;
1733: --
1734: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1735: --OTM R12, glog proj
1736: l_tp_plan_name := NULL;
1737:
1738: --OTM R12, glog proj, use Global Variable

Line 1739: l_gc3_is_installed := WSH_UTIL_CORE.G_GC3_IS_INSTALLED;

1735: --OTM R12, glog proj
1736: l_tp_plan_name := NULL;
1737:
1738: --OTM R12, glog proj, use Global Variable
1739: l_gc3_is_installed := WSH_UTIL_CORE.G_GC3_IS_INSTALLED;
1740:
1741: -- If null, call the function
1742: IF l_gc3_is_installed IS NULL THEN
1743: l_gc3_is_installed := WSH_UTIL_CORE.GC3_IS_INSTALLED;

Line 1743: l_gc3_is_installed := WSH_UTIL_CORE.GC3_IS_INSTALLED;

1739: l_gc3_is_installed := WSH_UTIL_CORE.G_GC3_IS_INSTALLED;
1740:
1741: -- If null, call the function
1742: IF l_gc3_is_installed IS NULL THEN
1743: l_gc3_is_installed := WSH_UTIL_CORE.GC3_IS_INSTALLED;
1744: END IF;
1745: -- end of OTM R12, glog proj
1746:
1747: -- clear up the list table

Line 1782: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1778: l_tp_plan_name;
1779: IF get_trip_status%NOTFOUND THEN
1780: CLOSE get_trip_status;
1781: FND_MESSAGE.Set_Name('WSH','WSH_API_INVALID_PARAM_VALUE');
1782: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1783: --
1784: RETURN;
1785: END IF;
1786: CLOSE get_trip_status;

Line 1812: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1808: l_ssn_disabled := FALSE;
1809:
1810: IF (p_parent_entity_id IS NULL) THEN
1811: FND_MESSAGE.Set_Name('WSH','WSH_API_INVALID_PARAM_VALUE');
1812: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1813: --
1814: -- Debug Statements
1815: --
1816: IF l_debug_on THEN

Line 1832: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1828: l_tp_plan_name;
1829: IF get_trip_status%NOTFOUND THEN
1830: CLOSE get_trip_status;
1831: FND_MESSAGE.Set_Name('WSH','WSH_API_INVALID_PARAM_VALUE');
1832: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1833: --
1834: -- Debug Statements
1835: --
1836: IF l_debug_on THEN

Line 2078: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2074: END IF;
2075: --
2076: EXCEPTION
2077: WHEN e_all_disabled THEN --3509004:public api changes
2078: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2079: FND_MESSAGE.SET_NAME('WSH','WSH_ALL_COLS_DISABLED');
2080: FND_MESSAGE.Set_Token('ENTITY_ID',p_stop_id);
2081: wsh_util_core.add_message(x_return_status,l_module_name);
2082: IF l_debug_on THEN

Line 2081: wsh_util_core.add_message(x_return_status,l_module_name);

2077: WHEN e_all_disabled THEN --3509004:public api changes
2078: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2079: FND_MESSAGE.SET_NAME('WSH','WSH_ALL_COLS_DISABLED');
2080: FND_MESSAGE.Set_Token('ENTITY_ID',p_stop_id);
2081: wsh_util_core.add_message(x_return_status,l_module_name);
2082: IF l_debug_on THEN
2083: -- Nothing is updateable
2084: WSH_DEBUG_SV.pop(l_module_name,'e_all_disabled');
2085: END IF;

Line 2089: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);

2085: END IF;
2086:
2087: WHEN WSH_DP_NO_ENTITY THEN
2088: FND_MESSAGE.SET_NAME('WSH', 'WSH_DP_NO_ENTITY');
2089: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);
2090: x_return_status := FND_API.G_RET_STS_ERROR;
2091: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
2092: if x_msg_count > 1 then
2093: x_msg_data := l_msg_summary || l_msg_details;

Line 2091: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);

2087: WHEN WSH_DP_NO_ENTITY THEN
2088: FND_MESSAGE.SET_NAME('WSH', 'WSH_DP_NO_ENTITY');
2089: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);
2090: x_return_status := FND_API.G_RET_STS_ERROR;
2091: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
2092: if x_msg_count > 1 then
2093: x_msg_data := l_msg_summary || l_msg_details;
2094: else
2095: x_msg_data := l_msg_summary;

Line 2109: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);

2105: END IF;
2106: --
2107: WHEN WSH_INV_LIST_TYPE THEN
2108: FND_MESSAGE.SET_NAME('WSH', 'WSH_INV_LIST_TYPE');
2109: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);
2110: x_return_status := FND_API.G_RET_STS_ERROR;
2111: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
2112: if x_msg_count > 1 then
2113: x_msg_data := l_msg_summary || l_msg_details;

Line 2111: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);

2107: WHEN WSH_INV_LIST_TYPE THEN
2108: FND_MESSAGE.SET_NAME('WSH', 'WSH_INV_LIST_TYPE');
2109: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);
2110: x_return_status := FND_API.G_RET_STS_ERROR;
2111: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
2112: if x_msg_count > 1 then
2113: x_msg_data := l_msg_summary || l_msg_details;
2114: else
2115: x_msg_data := l_msg_summary;

Line 2150: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2146: CLOSE get_trip_status;
2147: END IF;
2148:
2149: FND_MESSAGE.Set_Name('WSH','WSH_UNEXPECTED_ERROR');
2150: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2151:
2152: IF l_debug_on THEN
2153: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2154: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 2209: wsh_util_core.default_handler('WSH_TRIP_STOPS_PVT.lock_trip_stop_no_compare',l_module_name);

2205: RAISE;
2206:
2207: WHEN OTHERS THEN
2208: --
2209: wsh_util_core.default_handler('WSH_TRIP_STOPS_PVT.lock_trip_stop_no_compare',l_module_name);
2210: --
2211: IF l_debug_on THEN
2212: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2213: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 2222: p_valid_index_tab IN wsh_util_core.id_tab_type,

2218:
2219: procedure Lock_Trip_Stop(
2220: p_rec_attr_tab IN Stop_Attr_Tbl_Type,
2221: p_caller IN VARCHAR2,
2222: p_valid_index_tab IN wsh_util_core.id_tab_type,
2223: x_valid_ids_tab OUT NOCOPY wsh_util_core.id_tab_type,
2224: x_return_status OUT NOCOPY VARCHAR2
2225: )
2226: IS

Line 2223: x_valid_ids_tab OUT NOCOPY wsh_util_core.id_tab_type,

2219: procedure Lock_Trip_Stop(
2220: p_rec_attr_tab IN Stop_Attr_Tbl_Type,
2221: p_caller IN VARCHAR2,
2222: p_valid_index_tab IN wsh_util_core.id_tab_type,
2223: x_valid_ids_tab OUT NOCOPY wsh_util_core.id_tab_type,
2224: x_return_status OUT NOCOPY VARCHAR2
2225: )
2226: IS
2227: --

Line 2281: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error,l_module_name);

2277: rollback to lock_trip_stop_loop;
2278: IF nvl(p_caller,'!') <> 'WSH_FSTRX' THEN
2279: FND_MESSAGE.SET_NAME('WSH', 'WSH_STOP_LOCK_FAILED');
2280: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',p_rec_attr_tab(l_index).stop_id);
2281: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error,l_module_name);
2282: END IF;
2283: l_num_errors := l_num_errors + 1;
2284: --
2285: IF l_debug_on THEN

Line 2298: x_return_status := wsh_util_core.g_ret_sts_success;

2294: --
2295: end loop;
2296: --
2297: IF p_valid_index_tab.COUNT = 0 THEN
2298: x_return_status := wsh_util_core.g_ret_sts_success;
2299: ELSIF l_num_errors = p_valid_index_tab.COUNT THEN
2300: FND_MESSAGE.SET_NAME('WSH', 'WSH_UI_NOT_PERFORMED');
2301: x_return_status := wsh_util_core.g_ret_sts_error;
2302: wsh_util_core.add_message(x_return_status,l_module_name);

Line 2301: x_return_status := wsh_util_core.g_ret_sts_error;

2297: IF p_valid_index_tab.COUNT = 0 THEN
2298: x_return_status := wsh_util_core.g_ret_sts_success;
2299: ELSIF l_num_errors = p_valid_index_tab.COUNT THEN
2300: FND_MESSAGE.SET_NAME('WSH', 'WSH_UI_NOT_PERFORMED');
2301: x_return_status := wsh_util_core.g_ret_sts_error;
2302: wsh_util_core.add_message(x_return_status,l_module_name);
2303: IF l_debug_on THEN
2304: wsh_debug_sv.logmsg(l_module_name, 'WSH_UI_NOT_PERFORMED');
2305: END IF;

Line 2302: wsh_util_core.add_message(x_return_status,l_module_name);

2298: x_return_status := wsh_util_core.g_ret_sts_success;
2299: ELSIF l_num_errors = p_valid_index_tab.COUNT THEN
2300: FND_MESSAGE.SET_NAME('WSH', 'WSH_UI_NOT_PERFORMED');
2301: x_return_status := wsh_util_core.g_ret_sts_error;
2302: wsh_util_core.add_message(x_return_status,l_module_name);
2303: IF l_debug_on THEN
2304: wsh_debug_sv.logmsg(l_module_name, 'WSH_UI_NOT_PERFORMED');
2305: END IF;
2306: RAISE FND_API.G_EXC_ERROR;

Line 2309: x_return_status := wsh_util_core.g_ret_sts_warning;

2305: END IF;
2306: RAISE FND_API.G_EXC_ERROR;
2307: ELSIF l_num_errors > 0 THEN
2308: FND_MESSAGE.SET_NAME('WSH', 'WSH_UI_NOT_PROCESSED');
2309: x_return_status := wsh_util_core.g_ret_sts_warning;
2310: wsh_util_core.add_message(x_return_status,l_module_name);
2311: IF l_debug_on THEN
2312: wsh_debug_sv.logmsg(l_module_name, 'WSH_UI_NOT_PROCESSED');
2313: END IF;

Line 2310: wsh_util_core.add_message(x_return_status,l_module_name);

2306: RAISE FND_API.G_EXC_ERROR;
2307: ELSIF l_num_errors > 0 THEN
2308: FND_MESSAGE.SET_NAME('WSH', 'WSH_UI_NOT_PROCESSED');
2309: x_return_status := wsh_util_core.g_ret_sts_warning;
2310: wsh_util_core.add_message(x_return_status,l_module_name);
2311: IF l_debug_on THEN
2312: wsh_debug_sv.logmsg(l_module_name, 'WSH_UI_NOT_PROCESSED');
2313: END IF;
2314: raise wsh_util_core.g_exc_warning;

Line 2314: raise wsh_util_core.g_exc_warning;

2310: wsh_util_core.add_message(x_return_status,l_module_name);
2311: IF l_debug_on THEN
2312: wsh_debug_sv.logmsg(l_module_name, 'WSH_UI_NOT_PROCESSED');
2313: END IF;
2314: raise wsh_util_core.g_exc_warning;
2315: ELSE
2316: x_return_status := wsh_util_core.g_ret_sts_success;
2317: END IF;
2318: --

Line 2316: x_return_status := wsh_util_core.g_ret_sts_success;

2312: wsh_debug_sv.logmsg(l_module_name, 'WSH_UI_NOT_PROCESSED');
2313: END IF;
2314: raise wsh_util_core.g_exc_warning;
2315: ELSE
2316: x_return_status := wsh_util_core.g_ret_sts_success;
2317: END IF;
2318: --
2319: IF l_debug_on THEN
2320: WSH_DEBUG_SV.pop(l_module_name);

Line 2328: x_return_status := wsh_util_core.g_ret_sts_error;

2324: --
2325: --
2326: WHEN FND_API.G_EXC_ERROR THEN
2327: --
2328: x_return_status := wsh_util_core.g_ret_sts_error;
2329: --
2330: IF l_debug_on THEN
2331: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2332: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

Line 2336: x_return_status := wsh_util_core.g_ret_sts_unexp_error;

2332: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2333: END IF;
2334: --
2335: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2336: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
2337: --
2338: IF l_debug_on THEN
2339: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2340: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

Line 2343: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

2339: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2340: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2341: END IF;
2342: --
2343: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
2344: x_return_status := wsh_util_core.g_ret_sts_warning;
2345: --
2346: IF l_debug_on THEN
2347: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 2344: x_return_status := wsh_util_core.g_ret_sts_warning;

2340: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2341: END IF;
2342: --
2343: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
2344: x_return_status := wsh_util_core.g_ret_sts_warning;
2345: --
2346: IF l_debug_on THEN
2347: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2348: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');

Line 2347: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

2343: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
2344: x_return_status := wsh_util_core.g_ret_sts_warning;
2345: --
2346: IF l_debug_on THEN
2347: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2348: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
2349: END IF;
2350: --
2351: WHEN OTHERS THEN

Line 2348: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');

2344: x_return_status := wsh_util_core.g_ret_sts_warning;
2345: --
2346: IF l_debug_on THEN
2347: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2348: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
2349: END IF;
2350: --
2351: WHEN OTHERS THEN
2352: --

Line 2353: x_return_status := wsh_util_core.g_ret_sts_unexp_error;

2349: END IF;
2350: --
2351: WHEN OTHERS THEN
2352: --
2353: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
2354: --
2355: wsh_util_core.default_handler('WSH_TRIP_STOPS_PVT.LOCK_TRIP_STOP_WRAPPER',l_module_name);
2356: --
2357: IF l_debug_on THEN

Line 2355: wsh_util_core.default_handler('WSH_TRIP_STOPS_PVT.LOCK_TRIP_STOP_WRAPPER',l_module_name);

2351: WHEN OTHERS THEN
2352: --
2353: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
2354: --
2355: wsh_util_core.default_handler('WSH_TRIP_STOPS_PVT.LOCK_TRIP_STOP_WRAPPER',l_module_name);
2356: --
2357: IF l_debug_on THEN
2358: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2359: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 2377: (p_stop_id_tab IN WSH_UTIL_CORE.ID_TAB_TYPE,

2373: -- Description: This procedure updates the stop's tms_interface_flag
2374: -- according to the flag in the p_tms_interface_flag_tab.
2375: ----------------------------------------------------------
2376: Procedure Update_Tms_interface_flag
2377: (p_stop_id_tab IN WSH_UTIL_CORE.ID_TAB_TYPE,
2378: p_tms_interface_flag_tab IN WSH_UTIL_CORE.COLUMN_TAB_TYPE,
2379: x_return_status OUT NOCOPY VARCHAR2) IS
2380:
2381: l_stop_tab WSH_UTIL_CORE.id_tab_type; -- DBI Project

Line 2378: p_tms_interface_flag_tab IN WSH_UTIL_CORE.COLUMN_TAB_TYPE,

2374: -- according to the flag in the p_tms_interface_flag_tab.
2375: ----------------------------------------------------------
2376: Procedure Update_Tms_interface_flag
2377: (p_stop_id_tab IN WSH_UTIL_CORE.ID_TAB_TYPE,
2378: p_tms_interface_flag_tab IN WSH_UTIL_CORE.COLUMN_TAB_TYPE,
2379: x_return_status OUT NOCOPY VARCHAR2) IS
2380:
2381: l_stop_tab WSH_UTIL_CORE.id_tab_type; -- DBI Project
2382: l_dbi_rs VARCHAR2(1); -- DBI Project

Line 2381: l_stop_tab WSH_UTIL_CORE.id_tab_type; -- DBI Project

2377: (p_stop_id_tab IN WSH_UTIL_CORE.ID_TAB_TYPE,
2378: p_tms_interface_flag_tab IN WSH_UTIL_CORE.COLUMN_TAB_TYPE,
2379: x_return_status OUT NOCOPY VARCHAR2) IS
2380:
2381: l_stop_tab WSH_UTIL_CORE.id_tab_type; -- DBI Project
2382: l_dbi_rs VARCHAR2(1); -- DBI Project
2383: l_loop_counter NUMBER;
2384: RECORD_LOCKED EXCEPTION;
2385: PRAGMA EXCEPTION_INIT(RECORD_LOCKED, -54);

Line 2428: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2424: END IF;
2425: RAISE FND_API.G_EXC_ERROR;
2426: END IF;
2427:
2428: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2429:
2430: IF (p_stop_id_tab.COUNT > 0) THEN--{
2431: FORALL i in p_stop_id_tab.FIRST..p_stop_id_tab.LAST
2432: UPDATE wsh_trip_stops

Line 2467: IF l_dbi_rs = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

2463: 'Return Status after DBI Call-',
2464: l_dbi_rs);
2465: END IF;
2466:
2467: IF l_dbi_rs = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
2468: IF l_debug_on THEN
2469: WSH_DEBUG_SV.log(l_module_name,
2470: 'DBI API Returned Unexpected error '||x_return_status);
2471: END IF;

Line 2494: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2490: EXCEPTION
2491: --
2492: WHEN FND_API.G_EXC_ERROR THEN
2493: ROLLBACK TO update_tms_interface;
2494: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2495: --
2496: IF l_debug_on THEN
2497: WSH_DEBUG_SV.logmsg(l_module_name,
2498: 'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 2505: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

2501: --
2502: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2503: --
2504: ROLLBACK TO update_tms_interface;
2505: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2506: --
2507: IF l_debug_on THEN
2508: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2509: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

Line 2512: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

2508: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2509: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2510: END IF;
2511: --
2512: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
2513: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2514: --
2515: IF l_debug_on THEN
2516: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 2513: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

2509: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2510: END IF;
2511: --
2512: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
2513: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2514: --
2515: IF l_debug_on THEN
2516: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2517: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');

Line 2516: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

2512: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
2513: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2514: --
2515: IF l_debug_on THEN
2516: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2517: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
2518: END IF;
2519: --
2520:

Line 2517: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');

2513: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2514: --
2515: IF l_debug_on THEN
2516: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2517: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
2518: END IF;
2519: --
2520:
2521: WHEN RECORD_LOCKED THEN

Line 2523: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2519: --
2520:
2521: WHEN RECORD_LOCKED THEN
2522: ROLLBACK TO update_tms_interface;
2523: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2524: IF l_debug_on THEN
2525: WSH_DEBUG_SV.logmsg(l_module_name,'Record_locked exception has occured. Cannot update stop tms_interface_flag', WSH_DEBUG_SV.C_EXCEP_LEVEL);
2526: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:RECORD_LOCKED');
2527: END IF;

Line 2531: wsh_util_core.default_handler('WSH_TRIP_STOPS_PVT.UPDATE_TMS_INTERFACE_FLAG',l_module_name);

2527: END IF;
2528:
2529: WHEN others THEN
2530: ROLLBACK TO update_tms_interface;
2531: wsh_util_core.default_handler('WSH_TRIP_STOPS_PVT.UPDATE_TMS_INTERFACE_FLAG',l_module_name);
2532: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2533:
2534: --
2535: -- Debug Statements

Line 2532: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2528:
2529: WHEN others THEN
2530: ROLLBACK TO update_tms_interface;
2531: wsh_util_core.default_handler('WSH_TRIP_STOPS_PVT.UPDATE_TMS_INTERFACE_FLAG',l_module_name);
2532: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2533:
2534: --
2535: -- Debug Statements
2536: --