APPS.WSH_CARRIER_SERVICES_PKG dependencies on WSH_DEBUG_SV

Line 61: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

57: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
58: --
59: IF l_debug_on IS NULL
60: THEN
61: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
62: END IF;
63: --
64: IF l_debug_on THEN
65: WSH_DEBUG_SV.push(l_module_name);

Line 65: WSH_DEBUG_SV.push(l_module_name);

61: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
62: END IF;
63: --
64: IF l_debug_on THEN
65: WSH_DEBUG_SV.push(l_module_name);
66: WSH_DEBUG_SV.log(l_module_name,'Carrier_Service_ID',
67: p_Carrier_Service_Info.Carrier_Service_ID);
68: WSH_DEBUG_SV.log(l_module_name,'Ship_Method_Code',
69: p_Carrier_Service_Info.Ship_Method_Code);

Line 66: WSH_DEBUG_SV.log(l_module_name,'Carrier_Service_ID',

62: END IF;
63: --
64: IF l_debug_on THEN
65: WSH_DEBUG_SV.push(l_module_name);
66: WSH_DEBUG_SV.log(l_module_name,'Carrier_Service_ID',
67: p_Carrier_Service_Info.Carrier_Service_ID);
68: WSH_DEBUG_SV.log(l_module_name,'Ship_Method_Code',
69: p_Carrier_Service_Info.Ship_Method_Code);
70: WSH_DEBUG_SV.log(l_module_name,'Ship_Method_Meaning',

Line 68: WSH_DEBUG_SV.log(l_module_name,'Ship_Method_Code',

64: IF l_debug_on THEN
65: WSH_DEBUG_SV.push(l_module_name);
66: WSH_DEBUG_SV.log(l_module_name,'Carrier_Service_ID',
67: p_Carrier_Service_Info.Carrier_Service_ID);
68: WSH_DEBUG_SV.log(l_module_name,'Ship_Method_Code',
69: p_Carrier_Service_Info.Ship_Method_Code);
70: WSH_DEBUG_SV.log(l_module_name,'Ship_Method_Meaning',
71: p_Carrier_Service_Info.Ship_Method_Meaning);
72: WSH_DEBUG_SV.log(l_module_name,'Service_level',

Line 70: WSH_DEBUG_SV.log(l_module_name,'Ship_Method_Meaning',

66: WSH_DEBUG_SV.log(l_module_name,'Carrier_Service_ID',
67: p_Carrier_Service_Info.Carrier_Service_ID);
68: WSH_DEBUG_SV.log(l_module_name,'Ship_Method_Code',
69: p_Carrier_Service_Info.Ship_Method_Code);
70: WSH_DEBUG_SV.log(l_module_name,'Ship_Method_Meaning',
71: p_Carrier_Service_Info.Ship_Method_Meaning);
72: WSH_DEBUG_SV.log(l_module_name,'Service_level',
73: p_Carrier_Service_Info.Service_level);
74: WSH_DEBUG_SV.log(l_module_name,'min_sl_time',

Line 72: WSH_DEBUG_SV.log(l_module_name,'Service_level',

68: WSH_DEBUG_SV.log(l_module_name,'Ship_Method_Code',
69: p_Carrier_Service_Info.Ship_Method_Code);
70: WSH_DEBUG_SV.log(l_module_name,'Ship_Method_Meaning',
71: p_Carrier_Service_Info.Ship_Method_Meaning);
72: WSH_DEBUG_SV.log(l_module_name,'Service_level',
73: p_Carrier_Service_Info.Service_level);
74: WSH_DEBUG_SV.log(l_module_name,'min_sl_time',
75: p_Carrier_Service_Info.min_sl_time);
76: WSH_DEBUG_SV.log(l_module_name,'max_sl_time',

Line 74: WSH_DEBUG_SV.log(l_module_name,'min_sl_time',

70: WSH_DEBUG_SV.log(l_module_name,'Ship_Method_Meaning',
71: p_Carrier_Service_Info.Ship_Method_Meaning);
72: WSH_DEBUG_SV.log(l_module_name,'Service_level',
73: p_Carrier_Service_Info.Service_level);
74: WSH_DEBUG_SV.log(l_module_name,'min_sl_time',
75: p_Carrier_Service_Info.min_sl_time);
76: WSH_DEBUG_SV.log(l_module_name,'max_sl_time',
77: p_Carrier_Service_Info.max_sl_time);
78: WSH_DEBUG_SV.log(l_module_name,'sl_time_uom',

Line 76: WSH_DEBUG_SV.log(l_module_name,'max_sl_time',

72: WSH_DEBUG_SV.log(l_module_name,'Service_level',
73: p_Carrier_Service_Info.Service_level);
74: WSH_DEBUG_SV.log(l_module_name,'min_sl_time',
75: p_Carrier_Service_Info.min_sl_time);
76: WSH_DEBUG_SV.log(l_module_name,'max_sl_time',
77: p_Carrier_Service_Info.max_sl_time);
78: WSH_DEBUG_SV.log(l_module_name,'sl_time_uom',
79: p_Carrier_Service_Info.sl_time_uom);
80: WSH_DEBUG_SV.log(l_module_name,'Attribute_Category',

Line 78: WSH_DEBUG_SV.log(l_module_name,'sl_time_uom',

74: WSH_DEBUG_SV.log(l_module_name,'min_sl_time',
75: p_Carrier_Service_Info.min_sl_time);
76: WSH_DEBUG_SV.log(l_module_name,'max_sl_time',
77: p_Carrier_Service_Info.max_sl_time);
78: WSH_DEBUG_SV.log(l_module_name,'sl_time_uom',
79: p_Carrier_Service_Info.sl_time_uom);
80: WSH_DEBUG_SV.log(l_module_name,'Attribute_Category',
81: p_Carrier_Service_Info.Attribute_Category);
82: WSH_DEBUG_SV.log(l_module_name,'attribute1',

Line 80: WSH_DEBUG_SV.log(l_module_name,'Attribute_Category',

76: WSH_DEBUG_SV.log(l_module_name,'max_sl_time',
77: p_Carrier_Service_Info.max_sl_time);
78: WSH_DEBUG_SV.log(l_module_name,'sl_time_uom',
79: p_Carrier_Service_Info.sl_time_uom);
80: WSH_DEBUG_SV.log(l_module_name,'Attribute_Category',
81: p_Carrier_Service_Info.Attribute_Category);
82: WSH_DEBUG_SV.log(l_module_name,'attribute1',
83: p_Carrier_Service_Info.attribute1);
84: WSH_DEBUG_SV.log(l_module_name,'attribute2',

Line 82: WSH_DEBUG_SV.log(l_module_name,'attribute1',

78: WSH_DEBUG_SV.log(l_module_name,'sl_time_uom',
79: p_Carrier_Service_Info.sl_time_uom);
80: WSH_DEBUG_SV.log(l_module_name,'Attribute_Category',
81: p_Carrier_Service_Info.Attribute_Category);
82: WSH_DEBUG_SV.log(l_module_name,'attribute1',
83: p_Carrier_Service_Info.attribute1);
84: WSH_DEBUG_SV.log(l_module_name,'attribute2',
85: p_Carrier_Service_Info.attribute2);
86: WSH_DEBUG_SV.log(l_module_name,'attribute3',

Line 84: WSH_DEBUG_SV.log(l_module_name,'attribute2',

80: WSH_DEBUG_SV.log(l_module_name,'Attribute_Category',
81: p_Carrier_Service_Info.Attribute_Category);
82: WSH_DEBUG_SV.log(l_module_name,'attribute1',
83: p_Carrier_Service_Info.attribute1);
84: WSH_DEBUG_SV.log(l_module_name,'attribute2',
85: p_Carrier_Service_Info.attribute2);
86: WSH_DEBUG_SV.log(l_module_name,'attribute3',
87: p_Carrier_Service_Info.attribute3);
88: WSH_DEBUG_SV.log(l_module_name,'attribute4',

Line 86: WSH_DEBUG_SV.log(l_module_name,'attribute3',

82: WSH_DEBUG_SV.log(l_module_name,'attribute1',
83: p_Carrier_Service_Info.attribute1);
84: WSH_DEBUG_SV.log(l_module_name,'attribute2',
85: p_Carrier_Service_Info.attribute2);
86: WSH_DEBUG_SV.log(l_module_name,'attribute3',
87: p_Carrier_Service_Info.attribute3);
88: WSH_DEBUG_SV.log(l_module_name,'attribute4',
89: p_Carrier_Service_Info.attribute4);
90: WSH_DEBUG_SV.log(l_module_name,'attribute5',

Line 88: WSH_DEBUG_SV.log(l_module_name,'attribute4',

84: WSH_DEBUG_SV.log(l_module_name,'attribute2',
85: p_Carrier_Service_Info.attribute2);
86: WSH_DEBUG_SV.log(l_module_name,'attribute3',
87: p_Carrier_Service_Info.attribute3);
88: WSH_DEBUG_SV.log(l_module_name,'attribute4',
89: p_Carrier_Service_Info.attribute4);
90: WSH_DEBUG_SV.log(l_module_name,'attribute5',
91: p_Carrier_Service_Info.attribute5);
92: WSH_DEBUG_SV.log(l_module_name,'attribute6',

Line 90: WSH_DEBUG_SV.log(l_module_name,'attribute5',

86: WSH_DEBUG_SV.log(l_module_name,'attribute3',
87: p_Carrier_Service_Info.attribute3);
88: WSH_DEBUG_SV.log(l_module_name,'attribute4',
89: p_Carrier_Service_Info.attribute4);
90: WSH_DEBUG_SV.log(l_module_name,'attribute5',
91: p_Carrier_Service_Info.attribute5);
92: WSH_DEBUG_SV.log(l_module_name,'attribute6',
93: p_Carrier_Service_Info.attribute6);
94: WSH_DEBUG_SV.log(l_module_name,'attribute7',

Line 92: WSH_DEBUG_SV.log(l_module_name,'attribute6',

88: WSH_DEBUG_SV.log(l_module_name,'attribute4',
89: p_Carrier_Service_Info.attribute4);
90: WSH_DEBUG_SV.log(l_module_name,'attribute5',
91: p_Carrier_Service_Info.attribute5);
92: WSH_DEBUG_SV.log(l_module_name,'attribute6',
93: p_Carrier_Service_Info.attribute6);
94: WSH_DEBUG_SV.log(l_module_name,'attribute7',
95: p_Carrier_Service_Info.attribute7);
96: WSH_DEBUG_SV.log(l_module_name,'attribute8',

Line 94: WSH_DEBUG_SV.log(l_module_name,'attribute7',

90: WSH_DEBUG_SV.log(l_module_name,'attribute5',
91: p_Carrier_Service_Info.attribute5);
92: WSH_DEBUG_SV.log(l_module_name,'attribute6',
93: p_Carrier_Service_Info.attribute6);
94: WSH_DEBUG_SV.log(l_module_name,'attribute7',
95: p_Carrier_Service_Info.attribute7);
96: WSH_DEBUG_SV.log(l_module_name,'attribute8',
97: p_Carrier_Service_Info.attribute8);
98: WSH_DEBUG_SV.log(l_module_name,'attribute9',

Line 96: WSH_DEBUG_SV.log(l_module_name,'attribute8',

92: WSH_DEBUG_SV.log(l_module_name,'attribute6',
93: p_Carrier_Service_Info.attribute6);
94: WSH_DEBUG_SV.log(l_module_name,'attribute7',
95: p_Carrier_Service_Info.attribute7);
96: WSH_DEBUG_SV.log(l_module_name,'attribute8',
97: p_Carrier_Service_Info.attribute8);
98: WSH_DEBUG_SV.log(l_module_name,'attribute9',
99: p_Carrier_Service_Info.attribute9);
100: WSH_DEBUG_SV.log(l_module_name,'attribute10',

Line 98: WSH_DEBUG_SV.log(l_module_name,'attribute9',

94: WSH_DEBUG_SV.log(l_module_name,'attribute7',
95: p_Carrier_Service_Info.attribute7);
96: WSH_DEBUG_SV.log(l_module_name,'attribute8',
97: p_Carrier_Service_Info.attribute8);
98: WSH_DEBUG_SV.log(l_module_name,'attribute9',
99: p_Carrier_Service_Info.attribute9);
100: WSH_DEBUG_SV.log(l_module_name,'attribute10',
101: p_Carrier_Service_Info.attribute10);
102: WSH_DEBUG_SV.log(l_module_name,'attribute11',

Line 100: WSH_DEBUG_SV.log(l_module_name,'attribute10',

96: WSH_DEBUG_SV.log(l_module_name,'attribute8',
97: p_Carrier_Service_Info.attribute8);
98: WSH_DEBUG_SV.log(l_module_name,'attribute9',
99: p_Carrier_Service_Info.attribute9);
100: WSH_DEBUG_SV.log(l_module_name,'attribute10',
101: p_Carrier_Service_Info.attribute10);
102: WSH_DEBUG_SV.log(l_module_name,'attribute11',
103: p_Carrier_Service_Info.attribute11);
104: WSH_DEBUG_SV.log(l_module_name,'attribute12',

Line 102: WSH_DEBUG_SV.log(l_module_name,'attribute11',

98: WSH_DEBUG_SV.log(l_module_name,'attribute9',
99: p_Carrier_Service_Info.attribute9);
100: WSH_DEBUG_SV.log(l_module_name,'attribute10',
101: p_Carrier_Service_Info.attribute10);
102: WSH_DEBUG_SV.log(l_module_name,'attribute11',
103: p_Carrier_Service_Info.attribute11);
104: WSH_DEBUG_SV.log(l_module_name,'attribute12',
105: p_Carrier_Service_Info.attribute12);
106: WSH_DEBUG_SV.log(l_module_name,'attribute13',

Line 104: WSH_DEBUG_SV.log(l_module_name,'attribute12',

100: WSH_DEBUG_SV.log(l_module_name,'attribute10',
101: p_Carrier_Service_Info.attribute10);
102: WSH_DEBUG_SV.log(l_module_name,'attribute11',
103: p_Carrier_Service_Info.attribute11);
104: WSH_DEBUG_SV.log(l_module_name,'attribute12',
105: p_Carrier_Service_Info.attribute12);
106: WSH_DEBUG_SV.log(l_module_name,'attribute13',
107: p_Carrier_Service_Info.attribute13);
108: WSH_DEBUG_SV.log(l_module_name,'attribute14',

Line 106: WSH_DEBUG_SV.log(l_module_name,'attribute13',

102: WSH_DEBUG_SV.log(l_module_name,'attribute11',
103: p_Carrier_Service_Info.attribute11);
104: WSH_DEBUG_SV.log(l_module_name,'attribute12',
105: p_Carrier_Service_Info.attribute12);
106: WSH_DEBUG_SV.log(l_module_name,'attribute13',
107: p_Carrier_Service_Info.attribute13);
108: WSH_DEBUG_SV.log(l_module_name,'attribute14',
109: p_Carrier_Service_Info.attribute14);
110: WSH_DEBUG_SV.log(l_module_name,'attribute15',

Line 108: WSH_DEBUG_SV.log(l_module_name,'attribute14',

104: WSH_DEBUG_SV.log(l_module_name,'attribute12',
105: p_Carrier_Service_Info.attribute12);
106: WSH_DEBUG_SV.log(l_module_name,'attribute13',
107: p_Carrier_Service_Info.attribute13);
108: WSH_DEBUG_SV.log(l_module_name,'attribute14',
109: p_Carrier_Service_Info.attribute14);
110: WSH_DEBUG_SV.log(l_module_name,'attribute15',
111: p_Carrier_Service_Info.attribute15);
112: -- Pack J Enhancement

Line 110: WSH_DEBUG_SV.log(l_module_name,'attribute15',

106: WSH_DEBUG_SV.log(l_module_name,'attribute13',
107: p_Carrier_Service_Info.attribute13);
108: WSH_DEBUG_SV.log(l_module_name,'attribute14',
109: p_Carrier_Service_Info.attribute14);
110: WSH_DEBUG_SV.log(l_module_name,'attribute15',
111: p_Carrier_Service_Info.attribute15);
112: -- Pack J Enhancement
113:
114: WSH_DEBUG_SV.log(l_module_name, 'MAX_NUM_STOPS_PERMITTED',

Line 114: WSH_DEBUG_SV.log(l_module_name, 'MAX_NUM_STOPS_PERMITTED',

110: WSH_DEBUG_SV.log(l_module_name,'attribute15',
111: p_Carrier_Service_Info.attribute15);
112: -- Pack J Enhancement
113:
114: WSH_DEBUG_SV.log(l_module_name, 'MAX_NUM_STOPS_PERMITTED',
115: p_Carrier_Service_Info.MAX_NUM_STOPS_PERMITTED);
116: WSH_DEBUG_SV.log(l_module_name, 'MAX_TOTAL_DISTANCE',
117: p_Carrier_Service_Info.MAX_TOTAL_DISTANCE);
118: WSH_DEBUG_SV.log(l_module_name, 'MAX_TOTAL_TIME',

Line 116: WSH_DEBUG_SV.log(l_module_name, 'MAX_TOTAL_DISTANCE',

112: -- Pack J Enhancement
113:
114: WSH_DEBUG_SV.log(l_module_name, 'MAX_NUM_STOPS_PERMITTED',
115: p_Carrier_Service_Info.MAX_NUM_STOPS_PERMITTED);
116: WSH_DEBUG_SV.log(l_module_name, 'MAX_TOTAL_DISTANCE',
117: p_Carrier_Service_Info.MAX_TOTAL_DISTANCE);
118: WSH_DEBUG_SV.log(l_module_name, 'MAX_TOTAL_TIME',
119: p_Carrier_Service_Info.MAX_TOTAL_TIME);
120: WSH_DEBUG_SV.log(l_module_name, 'ALLOW_INTERSPERSE_LOAD',

Line 118: WSH_DEBUG_SV.log(l_module_name, 'MAX_TOTAL_TIME',

114: WSH_DEBUG_SV.log(l_module_name, 'MAX_NUM_STOPS_PERMITTED',
115: p_Carrier_Service_Info.MAX_NUM_STOPS_PERMITTED);
116: WSH_DEBUG_SV.log(l_module_name, 'MAX_TOTAL_DISTANCE',
117: p_Carrier_Service_Info.MAX_TOTAL_DISTANCE);
118: WSH_DEBUG_SV.log(l_module_name, 'MAX_TOTAL_TIME',
119: p_Carrier_Service_Info.MAX_TOTAL_TIME);
120: WSH_DEBUG_SV.log(l_module_name, 'ALLOW_INTERSPERSE_LOAD',
121: p_Carrier_Service_Info.ALLOW_INTERSPERSE_LOAD);
122: WSH_DEBUG_SV.log(l_module_name, 'MAX_LAYOVER_TIME',

Line 120: WSH_DEBUG_SV.log(l_module_name, 'ALLOW_INTERSPERSE_LOAD',

116: WSH_DEBUG_SV.log(l_module_name, 'MAX_TOTAL_DISTANCE',
117: p_Carrier_Service_Info.MAX_TOTAL_DISTANCE);
118: WSH_DEBUG_SV.log(l_module_name, 'MAX_TOTAL_TIME',
119: p_Carrier_Service_Info.MAX_TOTAL_TIME);
120: WSH_DEBUG_SV.log(l_module_name, 'ALLOW_INTERSPERSE_LOAD',
121: p_Carrier_Service_Info.ALLOW_INTERSPERSE_LOAD);
122: WSH_DEBUG_SV.log(l_module_name, 'MAX_LAYOVER_TIME',
123: p_Carrier_Service_Info.MAX_LAYOVER_TIME);
124: WSH_DEBUG_SV.log(l_module_name, 'MIN_LAYOVER_TIME',

Line 122: WSH_DEBUG_SV.log(l_module_name, 'MAX_LAYOVER_TIME',

118: WSH_DEBUG_SV.log(l_module_name, 'MAX_TOTAL_TIME',
119: p_Carrier_Service_Info.MAX_TOTAL_TIME);
120: WSH_DEBUG_SV.log(l_module_name, 'ALLOW_INTERSPERSE_LOAD',
121: p_Carrier_Service_Info.ALLOW_INTERSPERSE_LOAD);
122: WSH_DEBUG_SV.log(l_module_name, 'MAX_LAYOVER_TIME',
123: p_Carrier_Service_Info.MAX_LAYOVER_TIME);
124: WSH_DEBUG_SV.log(l_module_name, 'MIN_LAYOVER_TIME',
125: p_Carrier_Service_Info.MIN_LAYOVER_TIME);
126: WSH_DEBUG_SV.log(l_module_name, 'MAX_TOTAL_DISTANCE_IN_24HR',

Line 124: WSH_DEBUG_SV.log(l_module_name, 'MIN_LAYOVER_TIME',

120: WSH_DEBUG_SV.log(l_module_name, 'ALLOW_INTERSPERSE_LOAD',
121: p_Carrier_Service_Info.ALLOW_INTERSPERSE_LOAD);
122: WSH_DEBUG_SV.log(l_module_name, 'MAX_LAYOVER_TIME',
123: p_Carrier_Service_Info.MAX_LAYOVER_TIME);
124: WSH_DEBUG_SV.log(l_module_name, 'MIN_LAYOVER_TIME',
125: p_Carrier_Service_Info.MIN_LAYOVER_TIME);
126: WSH_DEBUG_SV.log(l_module_name, 'MAX_TOTAL_DISTANCE_IN_24HR',
127: p_Carrier_Service_Info.MAX_TOTAL_DISTANCE_IN_24HR);
128: WSH_DEBUG_SV.log(l_module_name, 'MAX_DRIVING_TIME_IN_24HR',

Line 126: WSH_DEBUG_SV.log(l_module_name, 'MAX_TOTAL_DISTANCE_IN_24HR',

122: WSH_DEBUG_SV.log(l_module_name, 'MAX_LAYOVER_TIME',
123: p_Carrier_Service_Info.MAX_LAYOVER_TIME);
124: WSH_DEBUG_SV.log(l_module_name, 'MIN_LAYOVER_TIME',
125: p_Carrier_Service_Info.MIN_LAYOVER_TIME);
126: WSH_DEBUG_SV.log(l_module_name, 'MAX_TOTAL_DISTANCE_IN_24HR',
127: p_Carrier_Service_Info.MAX_TOTAL_DISTANCE_IN_24HR);
128: WSH_DEBUG_SV.log(l_module_name, 'MAX_DRIVING_TIME_IN_24HR',
129: p_Carrier_Service_Info.MAX_DRIVING_TIME_IN_24HR);
130: WSH_DEBUG_SV.log(l_module_name, 'MAX_DUTY_TIME_IN_24HR',

Line 128: WSH_DEBUG_SV.log(l_module_name, 'MAX_DRIVING_TIME_IN_24HR',

124: WSH_DEBUG_SV.log(l_module_name, 'MIN_LAYOVER_TIME',
125: p_Carrier_Service_Info.MIN_LAYOVER_TIME);
126: WSH_DEBUG_SV.log(l_module_name, 'MAX_TOTAL_DISTANCE_IN_24HR',
127: p_Carrier_Service_Info.MAX_TOTAL_DISTANCE_IN_24HR);
128: WSH_DEBUG_SV.log(l_module_name, 'MAX_DRIVING_TIME_IN_24HR',
129: p_Carrier_Service_Info.MAX_DRIVING_TIME_IN_24HR);
130: WSH_DEBUG_SV.log(l_module_name, 'MAX_DUTY_TIME_IN_24HR',
131: p_Carrier_Service_Info.MAX_DUTY_TIME_IN_24HR);
132: WSH_DEBUG_SV.log(l_module_name, 'MAX_CM_DISTANCE',

Line 130: WSH_DEBUG_SV.log(l_module_name, 'MAX_DUTY_TIME_IN_24HR',

126: WSH_DEBUG_SV.log(l_module_name, 'MAX_TOTAL_DISTANCE_IN_24HR',
127: p_Carrier_Service_Info.MAX_TOTAL_DISTANCE_IN_24HR);
128: WSH_DEBUG_SV.log(l_module_name, 'MAX_DRIVING_TIME_IN_24HR',
129: p_Carrier_Service_Info.MAX_DRIVING_TIME_IN_24HR);
130: WSH_DEBUG_SV.log(l_module_name, 'MAX_DUTY_TIME_IN_24HR',
131: p_Carrier_Service_Info.MAX_DUTY_TIME_IN_24HR);
132: WSH_DEBUG_SV.log(l_module_name, 'MAX_CM_DISTANCE',
133: p_Carrier_Service_Info.MAX_CM_DISTANCE);
134: WSH_DEBUG_SV.log(l_module_name, 'MAX_CM_TIME',

Line 132: WSH_DEBUG_SV.log(l_module_name, 'MAX_CM_DISTANCE',

128: WSH_DEBUG_SV.log(l_module_name, 'MAX_DRIVING_TIME_IN_24HR',
129: p_Carrier_Service_Info.MAX_DRIVING_TIME_IN_24HR);
130: WSH_DEBUG_SV.log(l_module_name, 'MAX_DUTY_TIME_IN_24HR',
131: p_Carrier_Service_Info.MAX_DUTY_TIME_IN_24HR);
132: WSH_DEBUG_SV.log(l_module_name, 'MAX_CM_DISTANCE',
133: p_Carrier_Service_Info.MAX_CM_DISTANCE);
134: WSH_DEBUG_SV.log(l_module_name, 'MAX_CM_TIME',
135: p_Carrier_Service_Info.MAX_CM_TIME);
136: WSH_DEBUG_SV.log(l_module_name, 'MAX_CM_DH_DISTANCE',

Line 134: WSH_DEBUG_SV.log(l_module_name, 'MAX_CM_TIME',

130: WSH_DEBUG_SV.log(l_module_name, 'MAX_DUTY_TIME_IN_24HR',
131: p_Carrier_Service_Info.MAX_DUTY_TIME_IN_24HR);
132: WSH_DEBUG_SV.log(l_module_name, 'MAX_CM_DISTANCE',
133: p_Carrier_Service_Info.MAX_CM_DISTANCE);
134: WSH_DEBUG_SV.log(l_module_name, 'MAX_CM_TIME',
135: p_Carrier_Service_Info.MAX_CM_TIME);
136: WSH_DEBUG_SV.log(l_module_name, 'MAX_CM_DH_DISTANCE',
137: p_Carrier_Service_Info.MAX_CM_DH_DISTANCE);
138: WSH_DEBUG_SV.log(l_module_name, 'MAX_SIZE_WIDTH',

Line 136: WSH_DEBUG_SV.log(l_module_name, 'MAX_CM_DH_DISTANCE',

132: WSH_DEBUG_SV.log(l_module_name, 'MAX_CM_DISTANCE',
133: p_Carrier_Service_Info.MAX_CM_DISTANCE);
134: WSH_DEBUG_SV.log(l_module_name, 'MAX_CM_TIME',
135: p_Carrier_Service_Info.MAX_CM_TIME);
136: WSH_DEBUG_SV.log(l_module_name, 'MAX_CM_DH_DISTANCE',
137: p_Carrier_Service_Info.MAX_CM_DH_DISTANCE);
138: WSH_DEBUG_SV.log(l_module_name, 'MAX_SIZE_WIDTH',
139: p_Carrier_Service_Info.MAX_SIZE_WIDTH);
140: WSH_DEBUG_SV.log(l_module_name, 'MAX_SIZE_HEIGHT',

Line 138: WSH_DEBUG_SV.log(l_module_name, 'MAX_SIZE_WIDTH',

134: WSH_DEBUG_SV.log(l_module_name, 'MAX_CM_TIME',
135: p_Carrier_Service_Info.MAX_CM_TIME);
136: WSH_DEBUG_SV.log(l_module_name, 'MAX_CM_DH_DISTANCE',
137: p_Carrier_Service_Info.MAX_CM_DH_DISTANCE);
138: WSH_DEBUG_SV.log(l_module_name, 'MAX_SIZE_WIDTH',
139: p_Carrier_Service_Info.MAX_SIZE_WIDTH);
140: WSH_DEBUG_SV.log(l_module_name, 'MAX_SIZE_HEIGHT',
141: p_Carrier_Service_Info.MAX_SIZE_HEIGHT);
142: WSH_DEBUG_SV.log(l_module_name, 'MAX_SIZE_LENGTH',

Line 140: WSH_DEBUG_SV.log(l_module_name, 'MAX_SIZE_HEIGHT',

136: WSH_DEBUG_SV.log(l_module_name, 'MAX_CM_DH_DISTANCE',
137: p_Carrier_Service_Info.MAX_CM_DH_DISTANCE);
138: WSH_DEBUG_SV.log(l_module_name, 'MAX_SIZE_WIDTH',
139: p_Carrier_Service_Info.MAX_SIZE_WIDTH);
140: WSH_DEBUG_SV.log(l_module_name, 'MAX_SIZE_HEIGHT',
141: p_Carrier_Service_Info.MAX_SIZE_HEIGHT);
142: WSH_DEBUG_SV.log(l_module_name, 'MAX_SIZE_LENGTH',
143: p_Carrier_Service_Info.MAX_SIZE_LENGTH);
144: WSH_DEBUG_SV.log(l_module_name, 'MIN_SIZE_WIDTH',

Line 142: WSH_DEBUG_SV.log(l_module_name, 'MAX_SIZE_LENGTH',

138: WSH_DEBUG_SV.log(l_module_name, 'MAX_SIZE_WIDTH',
139: p_Carrier_Service_Info.MAX_SIZE_WIDTH);
140: WSH_DEBUG_SV.log(l_module_name, 'MAX_SIZE_HEIGHT',
141: p_Carrier_Service_Info.MAX_SIZE_HEIGHT);
142: WSH_DEBUG_SV.log(l_module_name, 'MAX_SIZE_LENGTH',
143: p_Carrier_Service_Info.MAX_SIZE_LENGTH);
144: WSH_DEBUG_SV.log(l_module_name, 'MIN_SIZE_WIDTH',
145: p_Carrier_Service_Info.MIN_SIZE_WIDTH);
146: WSH_DEBUG_SV.log(l_module_name, 'MIN_SIZE_HEIGHT',

Line 144: WSH_DEBUG_SV.log(l_module_name, 'MIN_SIZE_WIDTH',

140: WSH_DEBUG_SV.log(l_module_name, 'MAX_SIZE_HEIGHT',
141: p_Carrier_Service_Info.MAX_SIZE_HEIGHT);
142: WSH_DEBUG_SV.log(l_module_name, 'MAX_SIZE_LENGTH',
143: p_Carrier_Service_Info.MAX_SIZE_LENGTH);
144: WSH_DEBUG_SV.log(l_module_name, 'MIN_SIZE_WIDTH',
145: p_Carrier_Service_Info.MIN_SIZE_WIDTH);
146: WSH_DEBUG_SV.log(l_module_name, 'MIN_SIZE_HEIGHT',
147: p_Carrier_Service_Info.MIN_SIZE_HEIGHT);
148: WSH_DEBUG_SV.log(l_module_name, 'MIN_SIZE_LENGTH',

Line 146: WSH_DEBUG_SV.log(l_module_name, 'MIN_SIZE_HEIGHT',

142: WSH_DEBUG_SV.log(l_module_name, 'MAX_SIZE_LENGTH',
143: p_Carrier_Service_Info.MAX_SIZE_LENGTH);
144: WSH_DEBUG_SV.log(l_module_name, 'MIN_SIZE_WIDTH',
145: p_Carrier_Service_Info.MIN_SIZE_WIDTH);
146: WSH_DEBUG_SV.log(l_module_name, 'MIN_SIZE_HEIGHT',
147: p_Carrier_Service_Info.MIN_SIZE_HEIGHT);
148: WSH_DEBUG_SV.log(l_module_name, 'MIN_SIZE_LENGTH',
149: p_Carrier_Service_Info.MIN_SIZE_LENGTH);
150: WSH_DEBUG_SV.log(l_module_name, 'MAX_OUT_OF_ROUTE',

Line 148: WSH_DEBUG_SV.log(l_module_name, 'MIN_SIZE_LENGTH',

144: WSH_DEBUG_SV.log(l_module_name, 'MIN_SIZE_WIDTH',
145: p_Carrier_Service_Info.MIN_SIZE_WIDTH);
146: WSH_DEBUG_SV.log(l_module_name, 'MIN_SIZE_HEIGHT',
147: p_Carrier_Service_Info.MIN_SIZE_HEIGHT);
148: WSH_DEBUG_SV.log(l_module_name, 'MIN_SIZE_LENGTH',
149: p_Carrier_Service_Info.MIN_SIZE_LENGTH);
150: WSH_DEBUG_SV.log(l_module_name, 'MAX_OUT_OF_ROUTE',
151: p_Carrier_Service_Info.MAX_OUT_OF_ROUTE);
152: WSH_DEBUG_SV.log(l_module_name, 'CM_FREE_DH_MILEAGE',

Line 150: WSH_DEBUG_SV.log(l_module_name, 'MAX_OUT_OF_ROUTE',

146: WSH_DEBUG_SV.log(l_module_name, 'MIN_SIZE_HEIGHT',
147: p_Carrier_Service_Info.MIN_SIZE_HEIGHT);
148: WSH_DEBUG_SV.log(l_module_name, 'MIN_SIZE_LENGTH',
149: p_Carrier_Service_Info.MIN_SIZE_LENGTH);
150: WSH_DEBUG_SV.log(l_module_name, 'MAX_OUT_OF_ROUTE',
151: p_Carrier_Service_Info.MAX_OUT_OF_ROUTE);
152: WSH_DEBUG_SV.log(l_module_name, 'CM_FREE_DH_MILEAGE',
153: p_Carrier_Service_Info.CM_FREE_DH_MILEAGE);
154: WSH_DEBUG_SV.log(l_module_name, 'MIN_CM_DISTANCE',

Line 152: WSH_DEBUG_SV.log(l_module_name, 'CM_FREE_DH_MILEAGE',

148: WSH_DEBUG_SV.log(l_module_name, 'MIN_SIZE_LENGTH',
149: p_Carrier_Service_Info.MIN_SIZE_LENGTH);
150: WSH_DEBUG_SV.log(l_module_name, 'MAX_OUT_OF_ROUTE',
151: p_Carrier_Service_Info.MAX_OUT_OF_ROUTE);
152: WSH_DEBUG_SV.log(l_module_name, 'CM_FREE_DH_MILEAGE',
153: p_Carrier_Service_Info.CM_FREE_DH_MILEAGE);
154: WSH_DEBUG_SV.log(l_module_name, 'MIN_CM_DISTANCE',
155: p_Carrier_Service_Info.MIN_CM_DISTANCE);
156: WSH_DEBUG_SV.log(l_module_name, 'CM_FIRST_LOAD_DISCOUNT',

Line 154: WSH_DEBUG_SV.log(l_module_name, 'MIN_CM_DISTANCE',

150: WSH_DEBUG_SV.log(l_module_name, 'MAX_OUT_OF_ROUTE',
151: p_Carrier_Service_Info.MAX_OUT_OF_ROUTE);
152: WSH_DEBUG_SV.log(l_module_name, 'CM_FREE_DH_MILEAGE',
153: p_Carrier_Service_Info.CM_FREE_DH_MILEAGE);
154: WSH_DEBUG_SV.log(l_module_name, 'MIN_CM_DISTANCE',
155: p_Carrier_Service_Info.MIN_CM_DISTANCE);
156: WSH_DEBUG_SV.log(l_module_name, 'CM_FIRST_LOAD_DISCOUNT',
157: p_Carrier_Service_Info.CM_FIRST_LOAD_DISCOUNT);
158: WSH_DEBUG_SV.log(l_module_name, 'MIN_CM_TIME',

Line 156: WSH_DEBUG_SV.log(l_module_name, 'CM_FIRST_LOAD_DISCOUNT',

152: WSH_DEBUG_SV.log(l_module_name, 'CM_FREE_DH_MILEAGE',
153: p_Carrier_Service_Info.CM_FREE_DH_MILEAGE);
154: WSH_DEBUG_SV.log(l_module_name, 'MIN_CM_DISTANCE',
155: p_Carrier_Service_Info.MIN_CM_DISTANCE);
156: WSH_DEBUG_SV.log(l_module_name, 'CM_FIRST_LOAD_DISCOUNT',
157: p_Carrier_Service_Info.CM_FIRST_LOAD_DISCOUNT);
158: WSH_DEBUG_SV.log(l_module_name, 'MIN_CM_TIME',
159: p_Carrier_Service_Info.MIN_CM_TIME);
160: WSH_DEBUG_SV.log(l_module_name, 'UNIT_RATE_BASIS',

Line 158: WSH_DEBUG_SV.log(l_module_name, 'MIN_CM_TIME',

154: WSH_DEBUG_SV.log(l_module_name, 'MIN_CM_DISTANCE',
155: p_Carrier_Service_Info.MIN_CM_DISTANCE);
156: WSH_DEBUG_SV.log(l_module_name, 'CM_FIRST_LOAD_DISCOUNT',
157: p_Carrier_Service_Info.CM_FIRST_LOAD_DISCOUNT);
158: WSH_DEBUG_SV.log(l_module_name, 'MIN_CM_TIME',
159: p_Carrier_Service_Info.MIN_CM_TIME);
160: WSH_DEBUG_SV.log(l_module_name, 'UNIT_RATE_BASIS',
161: p_Carrier_Service_Info.UNIT_RATE_BASIS);
162: WSH_DEBUG_SV.log(l_module_name, 'CM_RATE_VARIANT',

Line 160: WSH_DEBUG_SV.log(l_module_name, 'UNIT_RATE_BASIS',

156: WSH_DEBUG_SV.log(l_module_name, 'CM_FIRST_LOAD_DISCOUNT',
157: p_Carrier_Service_Info.CM_FIRST_LOAD_DISCOUNT);
158: WSH_DEBUG_SV.log(l_module_name, 'MIN_CM_TIME',
159: p_Carrier_Service_Info.MIN_CM_TIME);
160: WSH_DEBUG_SV.log(l_module_name, 'UNIT_RATE_BASIS',
161: p_Carrier_Service_Info.UNIT_RATE_BASIS);
162: WSH_DEBUG_SV.log(l_module_name, 'CM_RATE_VARIANT',
163: p_Carrier_Service_Info.CM_RATE_VARIANT);
164: WSH_DEBUG_SV.log(l_module_name, 'DISTANCE_CALCULATION_METHOD',

Line 162: WSH_DEBUG_SV.log(l_module_name, 'CM_RATE_VARIANT',

158: WSH_DEBUG_SV.log(l_module_name, 'MIN_CM_TIME',
159: p_Carrier_Service_Info.MIN_CM_TIME);
160: WSH_DEBUG_SV.log(l_module_name, 'UNIT_RATE_BASIS',
161: p_Carrier_Service_Info.UNIT_RATE_BASIS);
162: WSH_DEBUG_SV.log(l_module_name, 'CM_RATE_VARIANT',
163: p_Carrier_Service_Info.CM_RATE_VARIANT);
164: WSH_DEBUG_SV.log(l_module_name, 'DISTANCE_CALCULATION_METHOD',
165: p_Carrier_Service_Info.DISTANCE_CALCULATION_METHOD);
166: WSH_DEBUG_SV.log(l_module_name, 'ORIGIN_DSTN_SURCHARGE_LEVEL',

Line 164: WSH_DEBUG_SV.log(l_module_name, 'DISTANCE_CALCULATION_METHOD',

160: WSH_DEBUG_SV.log(l_module_name, 'UNIT_RATE_BASIS',
161: p_Carrier_Service_Info.UNIT_RATE_BASIS);
162: WSH_DEBUG_SV.log(l_module_name, 'CM_RATE_VARIANT',
163: p_Carrier_Service_Info.CM_RATE_VARIANT);
164: WSH_DEBUG_SV.log(l_module_name, 'DISTANCE_CALCULATION_METHOD',
165: p_Carrier_Service_Info.DISTANCE_CALCULATION_METHOD);
166: WSH_DEBUG_SV.log(l_module_name, 'ORIGIN_DSTN_SURCHARGE_LEVEL',
167: p_Carrier_Service_Info.ORIGIN_DSTN_SURCHARGE_LEVEL);
168: WSH_DEBUG_SV.log(l_module_name, 'ALLOW_CONTINUOUS_MOVE',

Line 166: WSH_DEBUG_SV.log(l_module_name, 'ORIGIN_DSTN_SURCHARGE_LEVEL',

162: WSH_DEBUG_SV.log(l_module_name, 'CM_RATE_VARIANT',
163: p_Carrier_Service_Info.CM_RATE_VARIANT);
164: WSH_DEBUG_SV.log(l_module_name, 'DISTANCE_CALCULATION_METHOD',
165: p_Carrier_Service_Info.DISTANCE_CALCULATION_METHOD);
166: WSH_DEBUG_SV.log(l_module_name, 'ORIGIN_DSTN_SURCHARGE_LEVEL',
167: p_Carrier_Service_Info.ORIGIN_DSTN_SURCHARGE_LEVEL);
168: WSH_DEBUG_SV.log(l_module_name, 'ALLOW_CONTINUOUS_MOVE',
169: p_Carrier_Service_Info.ALLOW_CONTINUOUS_MOVE);
170: WSH_DEBUG_SV.log(l_module_name, 'MAX_CM_DH_TIME',

Line 168: WSH_DEBUG_SV.log(l_module_name, 'ALLOW_CONTINUOUS_MOVE',

164: WSH_DEBUG_SV.log(l_module_name, 'DISTANCE_CALCULATION_METHOD',
165: p_Carrier_Service_Info.DISTANCE_CALCULATION_METHOD);
166: WSH_DEBUG_SV.log(l_module_name, 'ORIGIN_DSTN_SURCHARGE_LEVEL',
167: p_Carrier_Service_Info.ORIGIN_DSTN_SURCHARGE_LEVEL);
168: WSH_DEBUG_SV.log(l_module_name, 'ALLOW_CONTINUOUS_MOVE',
169: p_Carrier_Service_Info.ALLOW_CONTINUOUS_MOVE);
170: WSH_DEBUG_SV.log(l_module_name, 'MAX_CM_DH_TIME',
171: p_Carrier_Service_Info.MAX_CM_DH_TIME);
172: -- R12 Code changes

Line 170: WSH_DEBUG_SV.log(l_module_name, 'MAX_CM_DH_TIME',

166: WSH_DEBUG_SV.log(l_module_name, 'ORIGIN_DSTN_SURCHARGE_LEVEL',
167: p_Carrier_Service_Info.ORIGIN_DSTN_SURCHARGE_LEVEL);
168: WSH_DEBUG_SV.log(l_module_name, 'ALLOW_CONTINUOUS_MOVE',
169: p_Carrier_Service_Info.ALLOW_CONTINUOUS_MOVE);
170: WSH_DEBUG_SV.log(l_module_name, 'MAX_CM_DH_TIME',
171: p_Carrier_Service_Info.MAX_CM_DH_TIME);
172: -- R12 Code changes
173: WSH_DEBUG_SV.log(l_module_name, 'DIM_DIMENSIONA_FACTOR',
174: p_Carrier_Service_Info.DIM_DIMENSIONAL_FACTOR);

Line 173: WSH_DEBUG_SV.log(l_module_name, 'DIM_DIMENSIONA_FACTOR',

169: p_Carrier_Service_Info.ALLOW_CONTINUOUS_MOVE);
170: WSH_DEBUG_SV.log(l_module_name, 'MAX_CM_DH_TIME',
171: p_Carrier_Service_Info.MAX_CM_DH_TIME);
172: -- R12 Code changes
173: WSH_DEBUG_SV.log(l_module_name, 'DIM_DIMENSIONA_FACTOR',
174: p_Carrier_Service_Info.DIM_DIMENSIONAL_FACTOR);
175: WSH_DEBUG_SV.log(l_module_name, 'DIM_WEIGHT_UOM',
176: p_Carrier_Service_Info.DIM_WEIGHT_UOM);
177: WSH_DEBUG_SV.log(l_module_name, 'DIM_VOLUME_UOM',

Line 175: WSH_DEBUG_SV.log(l_module_name, 'DIM_WEIGHT_UOM',

171: p_Carrier_Service_Info.MAX_CM_DH_TIME);
172: -- R12 Code changes
173: WSH_DEBUG_SV.log(l_module_name, 'DIM_DIMENSIONA_FACTOR',
174: p_Carrier_Service_Info.DIM_DIMENSIONAL_FACTOR);
175: WSH_DEBUG_SV.log(l_module_name, 'DIM_WEIGHT_UOM',
176: p_Carrier_Service_Info.DIM_WEIGHT_UOM);
177: WSH_DEBUG_SV.log(l_module_name, 'DIM_VOLUME_UOM',
178: p_Carrier_Service_Info.DIM_VOLUME_UOM);
179: WSH_DEBUG_SV.log(l_module_name, 'DIM_DIMENSION_UOM',

Line 177: WSH_DEBUG_SV.log(l_module_name, 'DIM_VOLUME_UOM',

173: WSH_DEBUG_SV.log(l_module_name, 'DIM_DIMENSIONA_FACTOR',
174: p_Carrier_Service_Info.DIM_DIMENSIONAL_FACTOR);
175: WSH_DEBUG_SV.log(l_module_name, 'DIM_WEIGHT_UOM',
176: p_Carrier_Service_Info.DIM_WEIGHT_UOM);
177: WSH_DEBUG_SV.log(l_module_name, 'DIM_VOLUME_UOM',
178: p_Carrier_Service_Info.DIM_VOLUME_UOM);
179: WSH_DEBUG_SV.log(l_module_name, 'DIM_DIMENSION_UOM',
180: p_Carrier_Service_Info.DIM_DIMENSION_UOM);
181: WSH_DEBUG_SV.log(l_module_name, 'DIM_MIN_PACK_VOL',

Line 179: WSH_DEBUG_SV.log(l_module_name, 'DIM_DIMENSION_UOM',

175: WSH_DEBUG_SV.log(l_module_name, 'DIM_WEIGHT_UOM',
176: p_Carrier_Service_Info.DIM_WEIGHT_UOM);
177: WSH_DEBUG_SV.log(l_module_name, 'DIM_VOLUME_UOM',
178: p_Carrier_Service_Info.DIM_VOLUME_UOM);
179: WSH_DEBUG_SV.log(l_module_name, 'DIM_DIMENSION_UOM',
180: p_Carrier_Service_Info.DIM_DIMENSION_UOM);
181: WSH_DEBUG_SV.log(l_module_name, 'DIM_MIN_PACK_VOL',
182: p_Carrier_Service_Info.DIM_MIN_PACK_VOL);
183: WSH_DEBUG_SV.log(l_module_name, 'DEFAULT_VEHICLE_TYPE_ID',

Line 181: WSH_DEBUG_SV.log(l_module_name, 'DIM_MIN_PACK_VOL',

177: WSH_DEBUG_SV.log(l_module_name, 'DIM_VOLUME_UOM',
178: p_Carrier_Service_Info.DIM_VOLUME_UOM);
179: WSH_DEBUG_SV.log(l_module_name, 'DIM_DIMENSION_UOM',
180: p_Carrier_Service_Info.DIM_DIMENSION_UOM);
181: WSH_DEBUG_SV.log(l_module_name, 'DIM_MIN_PACK_VOL',
182: p_Carrier_Service_Info.DIM_MIN_PACK_VOL);
183: WSH_DEBUG_SV.log(l_module_name, 'DEFAULT_VEHICLE_TYPE_ID',
184: p_Carrier_Service_Info.DEFAULT_VEHICLE_TYPE_ID);
185: -- R12 Code changes

Line 183: WSH_DEBUG_SV.log(l_module_name, 'DEFAULT_VEHICLE_TYPE_ID',

179: WSH_DEBUG_SV.log(l_module_name, 'DIM_DIMENSION_UOM',
180: p_Carrier_Service_Info.DIM_DIMENSION_UOM);
181: WSH_DEBUG_SV.log(l_module_name, 'DIM_MIN_PACK_VOL',
182: p_Carrier_Service_Info.DIM_MIN_PACK_VOL);
183: WSH_DEBUG_SV.log(l_module_name, 'DEFAULT_VEHICLE_TYPE_ID',
184: p_Carrier_Service_Info.DEFAULT_VEHICLE_TYPE_ID);
185: -- R12 Code changes
186: WSH_DEBUG_SV.log(l_module_name, 'UPDATE_MOT_SL',
187: p_Carrier_Service_Info.UPDATE_MOT_SL);

Line 186: WSH_DEBUG_SV.log(l_module_name, 'UPDATE_MOT_SL',

182: p_Carrier_Service_Info.DIM_MIN_PACK_VOL);
183: WSH_DEBUG_SV.log(l_module_name, 'DEFAULT_VEHICLE_TYPE_ID',
184: p_Carrier_Service_Info.DEFAULT_VEHICLE_TYPE_ID);
185: -- R12 Code changes
186: WSH_DEBUG_SV.log(l_module_name, 'UPDATE_MOT_SL',
187: p_Carrier_Service_Info.UPDATE_MOT_SL);
188: END IF;
189: --
190: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 203: WSH_DEBUG_SV.log(l_module_name,'l_Carrier_Service_Id',

199: From fnd_lookup_values
200: Where lookup_type like 'SHIP_METHOD' and
201: lookup_code like p_Carrier_Service_Info.ship_method_code;
202: IF l_debug_on THEN
203: WSH_DEBUG_SV.log(l_module_name,'l_Carrier_Service_Id',
204: l_Carrier_Service_Id);
205: WSH_DEBUG_SV.log(l_module_name,'l_smc',l_smc);
206: END IF;
207:

Line 205: WSH_DEBUG_SV.log(l_module_name,'l_smc',l_smc);

201: lookup_code like p_Carrier_Service_Info.ship_method_code;
202: IF l_debug_on THEN
203: WSH_DEBUG_SV.log(l_module_name,'l_Carrier_Service_Id',
204: l_Carrier_Service_Id);
205: WSH_DEBUG_SV.log(l_module_name,'l_smc',l_smc);
206: END IF;
207:
208: IF (l_smc = 0) then
209: l_position := 10;

Line 252: WSH_DEBUG_SV.log(l_module_name,'Inserting into wsh_carrier_services');

248: l_position := 20;
249: l_procedure := 'Inserting Into Wsh_Carrier_Services';
250:
251: IF l_debug_on THEN
252: WSH_DEBUG_SV.log(l_module_name,'Inserting into wsh_carrier_services');
253: END IF;
254:
255: INSERT INTO wsh_carrier_services(
256: carrier_service_id,

Line 394: WSH_DEBUG_SV.log(l_module_name,'C_New_Rowid%NOTFOUND');

390: FETCH C_New_Rowid INTO x_rowid;
391: IF (C_New_Rowid%NOTFOUND) THEN
392: CLOSE C_New_Rowid;
393: IF l_debug_on THEN
394: WSH_DEBUG_SV.log(l_module_name,'C_New_Rowid%NOTFOUND');
395: END IF;
396: RAISE others;
397: END IF;
398:

Line 406: WSH_DEBUG_SV.pop(l_module_name);

402: COMMIT;
403: END IF;
404:
405: IF l_debug_on THEN
406: WSH_DEBUG_SV.pop(l_module_name);
407: END IF;
408: --
409: EXCEPTION
410: WHEN others THEN

Line 418: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

414: X_SQLERR := SQLERRM;
415: X_sql_code := SQLCODE;
416: --
417: IF l_debug_on THEN
418: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
419: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
420: END IF;
421: --
422: END Create_Carrier_Service;

Line 419: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

415: X_sql_code := SQLCODE;
416: --
417: IF l_debug_on THEN
418: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
419: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
420: END IF;
421: --
422: END Create_Carrier_Service;
423:

Line 552: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

548: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
549: --
550: IF l_debug_on IS NULL
551: THEN
552: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
553: END IF;
554: --
555: IF l_debug_on THEN
556: WSH_DEBUG_SV.push(l_module_name);

Line 556: WSH_DEBUG_SV.push(l_module_name);

552: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
553: END IF;
554: --
555: IF l_debug_on THEN
556: WSH_DEBUG_SV.push(l_module_name);
557: --
558: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
559: WSH_DEBUG_SV.log(l_module_name,'Carrier_Service_ID',
560: p_Carrier_Service_Info.Carrier_Service_ID);

Line 558: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);

554: --
555: IF l_debug_on THEN
556: WSH_DEBUG_SV.push(l_module_name);
557: --
558: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
559: WSH_DEBUG_SV.log(l_module_name,'Carrier_Service_ID',
560: p_Carrier_Service_Info.Carrier_Service_ID);
561: WSH_DEBUG_SV.log(l_module_name,'Ship_Method_Code',
562: p_Carrier_Service_Info.Ship_Method_Code);

Line 559: WSH_DEBUG_SV.log(l_module_name,'Carrier_Service_ID',

555: IF l_debug_on THEN
556: WSH_DEBUG_SV.push(l_module_name);
557: --
558: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
559: WSH_DEBUG_SV.log(l_module_name,'Carrier_Service_ID',
560: p_Carrier_Service_Info.Carrier_Service_ID);
561: WSH_DEBUG_SV.log(l_module_name,'Ship_Method_Code',
562: p_Carrier_Service_Info.Ship_Method_Code);
563: WSH_DEBUG_SV.log(l_module_name,'Ship_Method_Meaning',

Line 561: WSH_DEBUG_SV.log(l_module_name,'Ship_Method_Code',

557: --
558: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
559: WSH_DEBUG_SV.log(l_module_name,'Carrier_Service_ID',
560: p_Carrier_Service_Info.Carrier_Service_ID);
561: WSH_DEBUG_SV.log(l_module_name,'Ship_Method_Code',
562: p_Carrier_Service_Info.Ship_Method_Code);
563: WSH_DEBUG_SV.log(l_module_name,'Ship_Method_Meaning',
564: p_Carrier_Service_Info.Ship_Method_Meaning);
565: WSH_DEBUG_SV.log(l_module_name,'Service_level',

Line 563: WSH_DEBUG_SV.log(l_module_name,'Ship_Method_Meaning',

559: WSH_DEBUG_SV.log(l_module_name,'Carrier_Service_ID',
560: p_Carrier_Service_Info.Carrier_Service_ID);
561: WSH_DEBUG_SV.log(l_module_name,'Ship_Method_Code',
562: p_Carrier_Service_Info.Ship_Method_Code);
563: WSH_DEBUG_SV.log(l_module_name,'Ship_Method_Meaning',
564: p_Carrier_Service_Info.Ship_Method_Meaning);
565: WSH_DEBUG_SV.log(l_module_name,'Service_level',
566: p_Carrier_Service_Info.Service_level);
567: WSH_DEBUG_SV.log(l_module_name,'min_sl_time',

Line 565: WSH_DEBUG_SV.log(l_module_name,'Service_level',

561: WSH_DEBUG_SV.log(l_module_name,'Ship_Method_Code',
562: p_Carrier_Service_Info.Ship_Method_Code);
563: WSH_DEBUG_SV.log(l_module_name,'Ship_Method_Meaning',
564: p_Carrier_Service_Info.Ship_Method_Meaning);
565: WSH_DEBUG_SV.log(l_module_name,'Service_level',
566: p_Carrier_Service_Info.Service_level);
567: WSH_DEBUG_SV.log(l_module_name,'min_sl_time',
568: p_Carrier_Service_Info.min_sl_time);
569: WSH_DEBUG_SV.log(l_module_name,'max_sl_time',

Line 567: WSH_DEBUG_SV.log(l_module_name,'min_sl_time',

563: WSH_DEBUG_SV.log(l_module_name,'Ship_Method_Meaning',
564: p_Carrier_Service_Info.Ship_Method_Meaning);
565: WSH_DEBUG_SV.log(l_module_name,'Service_level',
566: p_Carrier_Service_Info.Service_level);
567: WSH_DEBUG_SV.log(l_module_name,'min_sl_time',
568: p_Carrier_Service_Info.min_sl_time);
569: WSH_DEBUG_SV.log(l_module_name,'max_sl_time',
570: p_Carrier_Service_Info.max_sl_time);
571: WSH_DEBUG_SV.log(l_module_name,'sl_time_uom',

Line 569: WSH_DEBUG_SV.log(l_module_name,'max_sl_time',

565: WSH_DEBUG_SV.log(l_module_name,'Service_level',
566: p_Carrier_Service_Info.Service_level);
567: WSH_DEBUG_SV.log(l_module_name,'min_sl_time',
568: p_Carrier_Service_Info.min_sl_time);
569: WSH_DEBUG_SV.log(l_module_name,'max_sl_time',
570: p_Carrier_Service_Info.max_sl_time);
571: WSH_DEBUG_SV.log(l_module_name,'sl_time_uom',
572: p_Carrier_Service_Info.sl_time_uom);
573: WSH_DEBUG_SV.log(l_module_name,'Attribute_Category',

Line 571: WSH_DEBUG_SV.log(l_module_name,'sl_time_uom',

567: WSH_DEBUG_SV.log(l_module_name,'min_sl_time',
568: p_Carrier_Service_Info.min_sl_time);
569: WSH_DEBUG_SV.log(l_module_name,'max_sl_time',
570: p_Carrier_Service_Info.max_sl_time);
571: WSH_DEBUG_SV.log(l_module_name,'sl_time_uom',
572: p_Carrier_Service_Info.sl_time_uom);
573: WSH_DEBUG_SV.log(l_module_name,'Attribute_Category',
574: p_Carrier_Service_Info.Attribute_Category);
575: WSH_DEBUG_SV.log(l_module_name,'attribute1',

Line 573: WSH_DEBUG_SV.log(l_module_name,'Attribute_Category',

569: WSH_DEBUG_SV.log(l_module_name,'max_sl_time',
570: p_Carrier_Service_Info.max_sl_time);
571: WSH_DEBUG_SV.log(l_module_name,'sl_time_uom',
572: p_Carrier_Service_Info.sl_time_uom);
573: WSH_DEBUG_SV.log(l_module_name,'Attribute_Category',
574: p_Carrier_Service_Info.Attribute_Category);
575: WSH_DEBUG_SV.log(l_module_name,'attribute1',
576: p_Carrier_Service_Info.attribute1);
577: WSH_DEBUG_SV.log(l_module_name,'attribute2',

Line 575: WSH_DEBUG_SV.log(l_module_name,'attribute1',

571: WSH_DEBUG_SV.log(l_module_name,'sl_time_uom',
572: p_Carrier_Service_Info.sl_time_uom);
573: WSH_DEBUG_SV.log(l_module_name,'Attribute_Category',
574: p_Carrier_Service_Info.Attribute_Category);
575: WSH_DEBUG_SV.log(l_module_name,'attribute1',
576: p_Carrier_Service_Info.attribute1);
577: WSH_DEBUG_SV.log(l_module_name,'attribute2',
578: p_Carrier_Service_Info.attribute2);
579: WSH_DEBUG_SV.log(l_module_name,'attribute3',

Line 577: WSH_DEBUG_SV.log(l_module_name,'attribute2',

573: WSH_DEBUG_SV.log(l_module_name,'Attribute_Category',
574: p_Carrier_Service_Info.Attribute_Category);
575: WSH_DEBUG_SV.log(l_module_name,'attribute1',
576: p_Carrier_Service_Info.attribute1);
577: WSH_DEBUG_SV.log(l_module_name,'attribute2',
578: p_Carrier_Service_Info.attribute2);
579: WSH_DEBUG_SV.log(l_module_name,'attribute3',
580: p_Carrier_Service_Info.attribute3);
581: WSH_DEBUG_SV.log(l_module_name,'attribute4',

Line 579: WSH_DEBUG_SV.log(l_module_name,'attribute3',

575: WSH_DEBUG_SV.log(l_module_name,'attribute1',
576: p_Carrier_Service_Info.attribute1);
577: WSH_DEBUG_SV.log(l_module_name,'attribute2',
578: p_Carrier_Service_Info.attribute2);
579: WSH_DEBUG_SV.log(l_module_name,'attribute3',
580: p_Carrier_Service_Info.attribute3);
581: WSH_DEBUG_SV.log(l_module_name,'attribute4',
582: p_Carrier_Service_Info.attribute4);
583: WSH_DEBUG_SV.log(l_module_name,'attribute5',

Line 581: WSH_DEBUG_SV.log(l_module_name,'attribute4',

577: WSH_DEBUG_SV.log(l_module_name,'attribute2',
578: p_Carrier_Service_Info.attribute2);
579: WSH_DEBUG_SV.log(l_module_name,'attribute3',
580: p_Carrier_Service_Info.attribute3);
581: WSH_DEBUG_SV.log(l_module_name,'attribute4',
582: p_Carrier_Service_Info.attribute4);
583: WSH_DEBUG_SV.log(l_module_name,'attribute5',
584: p_Carrier_Service_Info.attribute5);
585: WSH_DEBUG_SV.log(l_module_name,'attribute6',

Line 583: WSH_DEBUG_SV.log(l_module_name,'attribute5',

579: WSH_DEBUG_SV.log(l_module_name,'attribute3',
580: p_Carrier_Service_Info.attribute3);
581: WSH_DEBUG_SV.log(l_module_name,'attribute4',
582: p_Carrier_Service_Info.attribute4);
583: WSH_DEBUG_SV.log(l_module_name,'attribute5',
584: p_Carrier_Service_Info.attribute5);
585: WSH_DEBUG_SV.log(l_module_name,'attribute6',
586: p_Carrier_Service_Info.attribute6);
587: WSH_DEBUG_SV.log(l_module_name,'attribute7',

Line 585: WSH_DEBUG_SV.log(l_module_name,'attribute6',

581: WSH_DEBUG_SV.log(l_module_name,'attribute4',
582: p_Carrier_Service_Info.attribute4);
583: WSH_DEBUG_SV.log(l_module_name,'attribute5',
584: p_Carrier_Service_Info.attribute5);
585: WSH_DEBUG_SV.log(l_module_name,'attribute6',
586: p_Carrier_Service_Info.attribute6);
587: WSH_DEBUG_SV.log(l_module_name,'attribute7',
588: p_Carrier_Service_Info.attribute7);
589: WSH_DEBUG_SV.log(l_module_name,'attribute8',

Line 587: WSH_DEBUG_SV.log(l_module_name,'attribute7',

583: WSH_DEBUG_SV.log(l_module_name,'attribute5',
584: p_Carrier_Service_Info.attribute5);
585: WSH_DEBUG_SV.log(l_module_name,'attribute6',
586: p_Carrier_Service_Info.attribute6);
587: WSH_DEBUG_SV.log(l_module_name,'attribute7',
588: p_Carrier_Service_Info.attribute7);
589: WSH_DEBUG_SV.log(l_module_name,'attribute8',
590: p_Carrier_Service_Info.attribute8);
591: WSH_DEBUG_SV.log(l_module_name,'attribute9',

Line 589: WSH_DEBUG_SV.log(l_module_name,'attribute8',

585: WSH_DEBUG_SV.log(l_module_name,'attribute6',
586: p_Carrier_Service_Info.attribute6);
587: WSH_DEBUG_SV.log(l_module_name,'attribute7',
588: p_Carrier_Service_Info.attribute7);
589: WSH_DEBUG_SV.log(l_module_name,'attribute8',
590: p_Carrier_Service_Info.attribute8);
591: WSH_DEBUG_SV.log(l_module_name,'attribute9',
592: p_Carrier_Service_Info.attribute9);
593: WSH_DEBUG_SV.log(l_module_name,'attribute10',

Line 591: WSH_DEBUG_SV.log(l_module_name,'attribute9',

587: WSH_DEBUG_SV.log(l_module_name,'attribute7',
588: p_Carrier_Service_Info.attribute7);
589: WSH_DEBUG_SV.log(l_module_name,'attribute8',
590: p_Carrier_Service_Info.attribute8);
591: WSH_DEBUG_SV.log(l_module_name,'attribute9',
592: p_Carrier_Service_Info.attribute9);
593: WSH_DEBUG_SV.log(l_module_name,'attribute10',
594: p_Carrier_Service_Info.attribute10);
595: WSH_DEBUG_SV.log(l_module_name,'attribute11',

Line 593: WSH_DEBUG_SV.log(l_module_name,'attribute10',

589: WSH_DEBUG_SV.log(l_module_name,'attribute8',
590: p_Carrier_Service_Info.attribute8);
591: WSH_DEBUG_SV.log(l_module_name,'attribute9',
592: p_Carrier_Service_Info.attribute9);
593: WSH_DEBUG_SV.log(l_module_name,'attribute10',
594: p_Carrier_Service_Info.attribute10);
595: WSH_DEBUG_SV.log(l_module_name,'attribute11',
596: p_Carrier_Service_Info.attribute11);
597: WSH_DEBUG_SV.log(l_module_name,'attribute12',

Line 595: WSH_DEBUG_SV.log(l_module_name,'attribute11',

591: WSH_DEBUG_SV.log(l_module_name,'attribute9',
592: p_Carrier_Service_Info.attribute9);
593: WSH_DEBUG_SV.log(l_module_name,'attribute10',
594: p_Carrier_Service_Info.attribute10);
595: WSH_DEBUG_SV.log(l_module_name,'attribute11',
596: p_Carrier_Service_Info.attribute11);
597: WSH_DEBUG_SV.log(l_module_name,'attribute12',
598: p_Carrier_Service_Info.attribute12);
599: WSH_DEBUG_SV.log(l_module_name,'attribute13',

Line 597: WSH_DEBUG_SV.log(l_module_name,'attribute12',

593: WSH_DEBUG_SV.log(l_module_name,'attribute10',
594: p_Carrier_Service_Info.attribute10);
595: WSH_DEBUG_SV.log(l_module_name,'attribute11',
596: p_Carrier_Service_Info.attribute11);
597: WSH_DEBUG_SV.log(l_module_name,'attribute12',
598: p_Carrier_Service_Info.attribute12);
599: WSH_DEBUG_SV.log(l_module_name,'attribute13',
600: p_Carrier_Service_Info.attribute13);
601: WSH_DEBUG_SV.log(l_module_name,'attribute14',

Line 599: WSH_DEBUG_SV.log(l_module_name,'attribute13',

595: WSH_DEBUG_SV.log(l_module_name,'attribute11',
596: p_Carrier_Service_Info.attribute11);
597: WSH_DEBUG_SV.log(l_module_name,'attribute12',
598: p_Carrier_Service_Info.attribute12);
599: WSH_DEBUG_SV.log(l_module_name,'attribute13',
600: p_Carrier_Service_Info.attribute13);
601: WSH_DEBUG_SV.log(l_module_name,'attribute14',
602: p_Carrier_Service_Info.attribute14);
603: WSH_DEBUG_SV.log(l_module_name,'attribute15',

Line 601: WSH_DEBUG_SV.log(l_module_name,'attribute14',

597: WSH_DEBUG_SV.log(l_module_name,'attribute12',
598: p_Carrier_Service_Info.attribute12);
599: WSH_DEBUG_SV.log(l_module_name,'attribute13',
600: p_Carrier_Service_Info.attribute13);
601: WSH_DEBUG_SV.log(l_module_name,'attribute14',
602: p_Carrier_Service_Info.attribute14);
603: WSH_DEBUG_SV.log(l_module_name,'attribute15',
604: p_Carrier_Service_Info.attribute15);
605:

Line 603: WSH_DEBUG_SV.log(l_module_name,'attribute15',

599: WSH_DEBUG_SV.log(l_module_name,'attribute13',
600: p_Carrier_Service_Info.attribute13);
601: WSH_DEBUG_SV.log(l_module_name,'attribute14',
602: p_Carrier_Service_Info.attribute14);
603: WSH_DEBUG_SV.log(l_module_name,'attribute15',
604: p_Carrier_Service_Info.attribute15);
605:
606: -- Pack J Enhancement
607: WSH_DEBUG_SV.log(l_module_name, 'MAX_NUM_STOPS_PERMITTED',

Line 607: WSH_DEBUG_SV.log(l_module_name, 'MAX_NUM_STOPS_PERMITTED',

603: WSH_DEBUG_SV.log(l_module_name,'attribute15',
604: p_Carrier_Service_Info.attribute15);
605:
606: -- Pack J Enhancement
607: WSH_DEBUG_SV.log(l_module_name, 'MAX_NUM_STOPS_PERMITTED',
608: p_Carrier_Service_Info.MAX_NUM_STOPS_PERMITTED);
609: WSH_DEBUG_SV.log(l_module_name, 'MAX_TOTAL_DISTANCE',
610: p_Carrier_Service_Info.MAX_TOTAL_DISTANCE);
611: WSH_DEBUG_SV.log(l_module_name, 'MAX_TOTAL_TIME',

Line 609: WSH_DEBUG_SV.log(l_module_name, 'MAX_TOTAL_DISTANCE',

605:
606: -- Pack J Enhancement
607: WSH_DEBUG_SV.log(l_module_name, 'MAX_NUM_STOPS_PERMITTED',
608: p_Carrier_Service_Info.MAX_NUM_STOPS_PERMITTED);
609: WSH_DEBUG_SV.log(l_module_name, 'MAX_TOTAL_DISTANCE',
610: p_Carrier_Service_Info.MAX_TOTAL_DISTANCE);
611: WSH_DEBUG_SV.log(l_module_name, 'MAX_TOTAL_TIME',
612: p_Carrier_Service_Info.MAX_TOTAL_TIME);
613: WSH_DEBUG_SV.log(l_module_name, 'ALLOW_INTERSPERSE_LOAD',

Line 611: WSH_DEBUG_SV.log(l_module_name, 'MAX_TOTAL_TIME',

607: WSH_DEBUG_SV.log(l_module_name, 'MAX_NUM_STOPS_PERMITTED',
608: p_Carrier_Service_Info.MAX_NUM_STOPS_PERMITTED);
609: WSH_DEBUG_SV.log(l_module_name, 'MAX_TOTAL_DISTANCE',
610: p_Carrier_Service_Info.MAX_TOTAL_DISTANCE);
611: WSH_DEBUG_SV.log(l_module_name, 'MAX_TOTAL_TIME',
612: p_Carrier_Service_Info.MAX_TOTAL_TIME);
613: WSH_DEBUG_SV.log(l_module_name, 'ALLOW_INTERSPERSE_LOAD',
614: p_Carrier_Service_Info.ALLOW_INTERSPERSE_LOAD);
615: WSH_DEBUG_SV.log(l_module_name, 'MAX_LAYOVER_TIME',

Line 613: WSH_DEBUG_SV.log(l_module_name, 'ALLOW_INTERSPERSE_LOAD',

609: WSH_DEBUG_SV.log(l_module_name, 'MAX_TOTAL_DISTANCE',
610: p_Carrier_Service_Info.MAX_TOTAL_DISTANCE);
611: WSH_DEBUG_SV.log(l_module_name, 'MAX_TOTAL_TIME',
612: p_Carrier_Service_Info.MAX_TOTAL_TIME);
613: WSH_DEBUG_SV.log(l_module_name, 'ALLOW_INTERSPERSE_LOAD',
614: p_Carrier_Service_Info.ALLOW_INTERSPERSE_LOAD);
615: WSH_DEBUG_SV.log(l_module_name, 'MAX_LAYOVER_TIME',
616: p_Carrier_Service_Info.MAX_LAYOVER_TIME);
617: WSH_DEBUG_SV.log(l_module_name, 'MIN_LAYOVER_TIME',

Line 615: WSH_DEBUG_SV.log(l_module_name, 'MAX_LAYOVER_TIME',

611: WSH_DEBUG_SV.log(l_module_name, 'MAX_TOTAL_TIME',
612: p_Carrier_Service_Info.MAX_TOTAL_TIME);
613: WSH_DEBUG_SV.log(l_module_name, 'ALLOW_INTERSPERSE_LOAD',
614: p_Carrier_Service_Info.ALLOW_INTERSPERSE_LOAD);
615: WSH_DEBUG_SV.log(l_module_name, 'MAX_LAYOVER_TIME',
616: p_Carrier_Service_Info.MAX_LAYOVER_TIME);
617: WSH_DEBUG_SV.log(l_module_name, 'MIN_LAYOVER_TIME',
618: p_Carrier_Service_Info.MIN_LAYOVER_TIME);
619: WSH_DEBUG_SV.log(l_module_name, 'MAX_TOTAL_DISTANCE_IN_24HR',

Line 617: WSH_DEBUG_SV.log(l_module_name, 'MIN_LAYOVER_TIME',

613: WSH_DEBUG_SV.log(l_module_name, 'ALLOW_INTERSPERSE_LOAD',
614: p_Carrier_Service_Info.ALLOW_INTERSPERSE_LOAD);
615: WSH_DEBUG_SV.log(l_module_name, 'MAX_LAYOVER_TIME',
616: p_Carrier_Service_Info.MAX_LAYOVER_TIME);
617: WSH_DEBUG_SV.log(l_module_name, 'MIN_LAYOVER_TIME',
618: p_Carrier_Service_Info.MIN_LAYOVER_TIME);
619: WSH_DEBUG_SV.log(l_module_name, 'MAX_TOTAL_DISTANCE_IN_24HR',
620: p_Carrier_Service_Info.MAX_TOTAL_DISTANCE_IN_24HR);
621: WSH_DEBUG_SV.log(l_module_name, 'MAX_DRIVING_TIME_IN_24HR',

Line 619: WSH_DEBUG_SV.log(l_module_name, 'MAX_TOTAL_DISTANCE_IN_24HR',

615: WSH_DEBUG_SV.log(l_module_name, 'MAX_LAYOVER_TIME',
616: p_Carrier_Service_Info.MAX_LAYOVER_TIME);
617: WSH_DEBUG_SV.log(l_module_name, 'MIN_LAYOVER_TIME',
618: p_Carrier_Service_Info.MIN_LAYOVER_TIME);
619: WSH_DEBUG_SV.log(l_module_name, 'MAX_TOTAL_DISTANCE_IN_24HR',
620: p_Carrier_Service_Info.MAX_TOTAL_DISTANCE_IN_24HR);
621: WSH_DEBUG_SV.log(l_module_name, 'MAX_DRIVING_TIME_IN_24HR',
622: p_Carrier_Service_Info.MAX_DRIVING_TIME_IN_24HR);
623: WSH_DEBUG_SV.log(l_module_name, 'MAX_DUTY_TIME_IN_24HR',

Line 621: WSH_DEBUG_SV.log(l_module_name, 'MAX_DRIVING_TIME_IN_24HR',

617: WSH_DEBUG_SV.log(l_module_name, 'MIN_LAYOVER_TIME',
618: p_Carrier_Service_Info.MIN_LAYOVER_TIME);
619: WSH_DEBUG_SV.log(l_module_name, 'MAX_TOTAL_DISTANCE_IN_24HR',
620: p_Carrier_Service_Info.MAX_TOTAL_DISTANCE_IN_24HR);
621: WSH_DEBUG_SV.log(l_module_name, 'MAX_DRIVING_TIME_IN_24HR',
622: p_Carrier_Service_Info.MAX_DRIVING_TIME_IN_24HR);
623: WSH_DEBUG_SV.log(l_module_name, 'MAX_DUTY_TIME_IN_24HR',
624: p_Carrier_Service_Info.MAX_DUTY_TIME_IN_24HR);
625: WSH_DEBUG_SV.log(l_module_name, 'MAX_CM_DISTANCE',

Line 623: WSH_DEBUG_SV.log(l_module_name, 'MAX_DUTY_TIME_IN_24HR',

619: WSH_DEBUG_SV.log(l_module_name, 'MAX_TOTAL_DISTANCE_IN_24HR',
620: p_Carrier_Service_Info.MAX_TOTAL_DISTANCE_IN_24HR);
621: WSH_DEBUG_SV.log(l_module_name, 'MAX_DRIVING_TIME_IN_24HR',
622: p_Carrier_Service_Info.MAX_DRIVING_TIME_IN_24HR);
623: WSH_DEBUG_SV.log(l_module_name, 'MAX_DUTY_TIME_IN_24HR',
624: p_Carrier_Service_Info.MAX_DUTY_TIME_IN_24HR);
625: WSH_DEBUG_SV.log(l_module_name, 'MAX_CM_DISTANCE',
626: p_Carrier_Service_Info.MAX_CM_DISTANCE);
627: WSH_DEBUG_SV.log(l_module_name, 'MAX_CM_TIME',

Line 625: WSH_DEBUG_SV.log(l_module_name, 'MAX_CM_DISTANCE',

621: WSH_DEBUG_SV.log(l_module_name, 'MAX_DRIVING_TIME_IN_24HR',
622: p_Carrier_Service_Info.MAX_DRIVING_TIME_IN_24HR);
623: WSH_DEBUG_SV.log(l_module_name, 'MAX_DUTY_TIME_IN_24HR',
624: p_Carrier_Service_Info.MAX_DUTY_TIME_IN_24HR);
625: WSH_DEBUG_SV.log(l_module_name, 'MAX_CM_DISTANCE',
626: p_Carrier_Service_Info.MAX_CM_DISTANCE);
627: WSH_DEBUG_SV.log(l_module_name, 'MAX_CM_TIME',
628: p_Carrier_Service_Info.MAX_CM_TIME);
629: WSH_DEBUG_SV.log(l_module_name, 'MAX_CM_DH_DISTANCE',

Line 627: WSH_DEBUG_SV.log(l_module_name, 'MAX_CM_TIME',

623: WSH_DEBUG_SV.log(l_module_name, 'MAX_DUTY_TIME_IN_24HR',
624: p_Carrier_Service_Info.MAX_DUTY_TIME_IN_24HR);
625: WSH_DEBUG_SV.log(l_module_name, 'MAX_CM_DISTANCE',
626: p_Carrier_Service_Info.MAX_CM_DISTANCE);
627: WSH_DEBUG_SV.log(l_module_name, 'MAX_CM_TIME',
628: p_Carrier_Service_Info.MAX_CM_TIME);
629: WSH_DEBUG_SV.log(l_module_name, 'MAX_CM_DH_DISTANCE',
630: p_Carrier_Service_Info.MAX_CM_DH_DISTANCE);
631: WSH_DEBUG_SV.log(l_module_name, 'MAX_SIZE_WIDTH',

Line 629: WSH_DEBUG_SV.log(l_module_name, 'MAX_CM_DH_DISTANCE',

625: WSH_DEBUG_SV.log(l_module_name, 'MAX_CM_DISTANCE',
626: p_Carrier_Service_Info.MAX_CM_DISTANCE);
627: WSH_DEBUG_SV.log(l_module_name, 'MAX_CM_TIME',
628: p_Carrier_Service_Info.MAX_CM_TIME);
629: WSH_DEBUG_SV.log(l_module_name, 'MAX_CM_DH_DISTANCE',
630: p_Carrier_Service_Info.MAX_CM_DH_DISTANCE);
631: WSH_DEBUG_SV.log(l_module_name, 'MAX_SIZE_WIDTH',
632: p_Carrier_Service_Info.MAX_SIZE_WIDTH);
633: WSH_DEBUG_SV.log(l_module_name, 'MAX_SIZE_HEIGHT',

Line 631: WSH_DEBUG_SV.log(l_module_name, 'MAX_SIZE_WIDTH',

627: WSH_DEBUG_SV.log(l_module_name, 'MAX_CM_TIME',
628: p_Carrier_Service_Info.MAX_CM_TIME);
629: WSH_DEBUG_SV.log(l_module_name, 'MAX_CM_DH_DISTANCE',
630: p_Carrier_Service_Info.MAX_CM_DH_DISTANCE);
631: WSH_DEBUG_SV.log(l_module_name, 'MAX_SIZE_WIDTH',
632: p_Carrier_Service_Info.MAX_SIZE_WIDTH);
633: WSH_DEBUG_SV.log(l_module_name, 'MAX_SIZE_HEIGHT',
634: p_Carrier_Service_Info.MAX_SIZE_HEIGHT);
635: WSH_DEBUG_SV.log(l_module_name, 'MAX_SIZE_LENGTH',

Line 633: WSH_DEBUG_SV.log(l_module_name, 'MAX_SIZE_HEIGHT',

629: WSH_DEBUG_SV.log(l_module_name, 'MAX_CM_DH_DISTANCE',
630: p_Carrier_Service_Info.MAX_CM_DH_DISTANCE);
631: WSH_DEBUG_SV.log(l_module_name, 'MAX_SIZE_WIDTH',
632: p_Carrier_Service_Info.MAX_SIZE_WIDTH);
633: WSH_DEBUG_SV.log(l_module_name, 'MAX_SIZE_HEIGHT',
634: p_Carrier_Service_Info.MAX_SIZE_HEIGHT);
635: WSH_DEBUG_SV.log(l_module_name, 'MAX_SIZE_LENGTH',
636: p_Carrier_Service_Info.MAX_SIZE_LENGTH);
637: WSH_DEBUG_SV.log(l_module_name, 'MIN_SIZE_WIDTH',

Line 635: WSH_DEBUG_SV.log(l_module_name, 'MAX_SIZE_LENGTH',

631: WSH_DEBUG_SV.log(l_module_name, 'MAX_SIZE_WIDTH',
632: p_Carrier_Service_Info.MAX_SIZE_WIDTH);
633: WSH_DEBUG_SV.log(l_module_name, 'MAX_SIZE_HEIGHT',
634: p_Carrier_Service_Info.MAX_SIZE_HEIGHT);
635: WSH_DEBUG_SV.log(l_module_name, 'MAX_SIZE_LENGTH',
636: p_Carrier_Service_Info.MAX_SIZE_LENGTH);
637: WSH_DEBUG_SV.log(l_module_name, 'MIN_SIZE_WIDTH',
638: p_Carrier_Service_Info.MIN_SIZE_WIDTH);
639: WSH_DEBUG_SV.log(l_module_name, 'MIN_SIZE_HEIGHT',

Line 637: WSH_DEBUG_SV.log(l_module_name, 'MIN_SIZE_WIDTH',

633: WSH_DEBUG_SV.log(l_module_name, 'MAX_SIZE_HEIGHT',
634: p_Carrier_Service_Info.MAX_SIZE_HEIGHT);
635: WSH_DEBUG_SV.log(l_module_name, 'MAX_SIZE_LENGTH',
636: p_Carrier_Service_Info.MAX_SIZE_LENGTH);
637: WSH_DEBUG_SV.log(l_module_name, 'MIN_SIZE_WIDTH',
638: p_Carrier_Service_Info.MIN_SIZE_WIDTH);
639: WSH_DEBUG_SV.log(l_module_name, 'MIN_SIZE_HEIGHT',
640: p_Carrier_Service_Info.MIN_SIZE_HEIGHT);
641: WSH_DEBUG_SV.log(l_module_name, 'MIN_SIZE_LENGTH',

Line 639: WSH_DEBUG_SV.log(l_module_name, 'MIN_SIZE_HEIGHT',

635: WSH_DEBUG_SV.log(l_module_name, 'MAX_SIZE_LENGTH',
636: p_Carrier_Service_Info.MAX_SIZE_LENGTH);
637: WSH_DEBUG_SV.log(l_module_name, 'MIN_SIZE_WIDTH',
638: p_Carrier_Service_Info.MIN_SIZE_WIDTH);
639: WSH_DEBUG_SV.log(l_module_name, 'MIN_SIZE_HEIGHT',
640: p_Carrier_Service_Info.MIN_SIZE_HEIGHT);
641: WSH_DEBUG_SV.log(l_module_name, 'MIN_SIZE_LENGTH',
642: p_Carrier_Service_Info.MIN_SIZE_LENGTH);
643: WSH_DEBUG_SV.log(l_module_name, 'MAX_OUT_OF_ROUTE',

Line 641: WSH_DEBUG_SV.log(l_module_name, 'MIN_SIZE_LENGTH',

637: WSH_DEBUG_SV.log(l_module_name, 'MIN_SIZE_WIDTH',
638: p_Carrier_Service_Info.MIN_SIZE_WIDTH);
639: WSH_DEBUG_SV.log(l_module_name, 'MIN_SIZE_HEIGHT',
640: p_Carrier_Service_Info.MIN_SIZE_HEIGHT);
641: WSH_DEBUG_SV.log(l_module_name, 'MIN_SIZE_LENGTH',
642: p_Carrier_Service_Info.MIN_SIZE_LENGTH);
643: WSH_DEBUG_SV.log(l_module_name, 'MAX_OUT_OF_ROUTE',
644: p_Carrier_Service_Info.MAX_OUT_OF_ROUTE);
645: WSH_DEBUG_SV.log(l_module_name, 'CM_FREE_DH_MILEAGE',

Line 643: WSH_DEBUG_SV.log(l_module_name, 'MAX_OUT_OF_ROUTE',

639: WSH_DEBUG_SV.log(l_module_name, 'MIN_SIZE_HEIGHT',
640: p_Carrier_Service_Info.MIN_SIZE_HEIGHT);
641: WSH_DEBUG_SV.log(l_module_name, 'MIN_SIZE_LENGTH',
642: p_Carrier_Service_Info.MIN_SIZE_LENGTH);
643: WSH_DEBUG_SV.log(l_module_name, 'MAX_OUT_OF_ROUTE',
644: p_Carrier_Service_Info.MAX_OUT_OF_ROUTE);
645: WSH_DEBUG_SV.log(l_module_name, 'CM_FREE_DH_MILEAGE',
646: p_Carrier_Service_Info.CM_FREE_DH_MILEAGE);
647: WSH_DEBUG_SV.log(l_module_name, 'MIN_CM_DISTANCE',

Line 645: WSH_DEBUG_SV.log(l_module_name, 'CM_FREE_DH_MILEAGE',

641: WSH_DEBUG_SV.log(l_module_name, 'MIN_SIZE_LENGTH',
642: p_Carrier_Service_Info.MIN_SIZE_LENGTH);
643: WSH_DEBUG_SV.log(l_module_name, 'MAX_OUT_OF_ROUTE',
644: p_Carrier_Service_Info.MAX_OUT_OF_ROUTE);
645: WSH_DEBUG_SV.log(l_module_name, 'CM_FREE_DH_MILEAGE',
646: p_Carrier_Service_Info.CM_FREE_DH_MILEAGE);
647: WSH_DEBUG_SV.log(l_module_name, 'MIN_CM_DISTANCE',
648: p_Carrier_Service_Info.MIN_CM_DISTANCE);
649: WSH_DEBUG_SV.log(l_module_name, 'CM_FIRST_LOAD_DISCOUNT',

Line 647: WSH_DEBUG_SV.log(l_module_name, 'MIN_CM_DISTANCE',

643: WSH_DEBUG_SV.log(l_module_name, 'MAX_OUT_OF_ROUTE',
644: p_Carrier_Service_Info.MAX_OUT_OF_ROUTE);
645: WSH_DEBUG_SV.log(l_module_name, 'CM_FREE_DH_MILEAGE',
646: p_Carrier_Service_Info.CM_FREE_DH_MILEAGE);
647: WSH_DEBUG_SV.log(l_module_name, 'MIN_CM_DISTANCE',
648: p_Carrier_Service_Info.MIN_CM_DISTANCE);
649: WSH_DEBUG_SV.log(l_module_name, 'CM_FIRST_LOAD_DISCOUNT',
650: p_Carrier_Service_Info.CM_FIRST_LOAD_DISCOUNT);
651: WSH_DEBUG_SV.log(l_module_name, 'MIN_CM_TIME',

Line 649: WSH_DEBUG_SV.log(l_module_name, 'CM_FIRST_LOAD_DISCOUNT',

645: WSH_DEBUG_SV.log(l_module_name, 'CM_FREE_DH_MILEAGE',
646: p_Carrier_Service_Info.CM_FREE_DH_MILEAGE);
647: WSH_DEBUG_SV.log(l_module_name, 'MIN_CM_DISTANCE',
648: p_Carrier_Service_Info.MIN_CM_DISTANCE);
649: WSH_DEBUG_SV.log(l_module_name, 'CM_FIRST_LOAD_DISCOUNT',
650: p_Carrier_Service_Info.CM_FIRST_LOAD_DISCOUNT);
651: WSH_DEBUG_SV.log(l_module_name, 'MIN_CM_TIME',
652: p_Carrier_Service_Info.MIN_CM_TIME);
653: WSH_DEBUG_SV.log(l_module_name, 'UNIT_RATE_BASIS',

Line 651: WSH_DEBUG_SV.log(l_module_name, 'MIN_CM_TIME',

647: WSH_DEBUG_SV.log(l_module_name, 'MIN_CM_DISTANCE',
648: p_Carrier_Service_Info.MIN_CM_DISTANCE);
649: WSH_DEBUG_SV.log(l_module_name, 'CM_FIRST_LOAD_DISCOUNT',
650: p_Carrier_Service_Info.CM_FIRST_LOAD_DISCOUNT);
651: WSH_DEBUG_SV.log(l_module_name, 'MIN_CM_TIME',
652: p_Carrier_Service_Info.MIN_CM_TIME);
653: WSH_DEBUG_SV.log(l_module_name, 'UNIT_RATE_BASIS',
654: p_Carrier_Service_Info.UNIT_RATE_BASIS);
655: WSH_DEBUG_SV.log(l_module_name, 'CM_RATE_VARIANT',

Line 653: WSH_DEBUG_SV.log(l_module_name, 'UNIT_RATE_BASIS',

649: WSH_DEBUG_SV.log(l_module_name, 'CM_FIRST_LOAD_DISCOUNT',
650: p_Carrier_Service_Info.CM_FIRST_LOAD_DISCOUNT);
651: WSH_DEBUG_SV.log(l_module_name, 'MIN_CM_TIME',
652: p_Carrier_Service_Info.MIN_CM_TIME);
653: WSH_DEBUG_SV.log(l_module_name, 'UNIT_RATE_BASIS',
654: p_Carrier_Service_Info.UNIT_RATE_BASIS);
655: WSH_DEBUG_SV.log(l_module_name, 'CM_RATE_VARIANT',
656: p_Carrier_Service_Info.CM_RATE_VARIANT);
657: WSH_DEBUG_SV.log(l_module_name, 'DISTANCE_CALCULATION_METHOD',

Line 655: WSH_DEBUG_SV.log(l_module_name, 'CM_RATE_VARIANT',

651: WSH_DEBUG_SV.log(l_module_name, 'MIN_CM_TIME',
652: p_Carrier_Service_Info.MIN_CM_TIME);
653: WSH_DEBUG_SV.log(l_module_name, 'UNIT_RATE_BASIS',
654: p_Carrier_Service_Info.UNIT_RATE_BASIS);
655: WSH_DEBUG_SV.log(l_module_name, 'CM_RATE_VARIANT',
656: p_Carrier_Service_Info.CM_RATE_VARIANT);
657: WSH_DEBUG_SV.log(l_module_name, 'DISTANCE_CALCULATION_METHOD',
658: p_Carrier_Service_Info.DISTANCE_CALCULATION_METHOD);
659: WSH_DEBUG_SV.log(l_module_name, 'ORIGIN_DSTN_SURCHARGE_LEVEL',

Line 657: WSH_DEBUG_SV.log(l_module_name, 'DISTANCE_CALCULATION_METHOD',

653: WSH_DEBUG_SV.log(l_module_name, 'UNIT_RATE_BASIS',
654: p_Carrier_Service_Info.UNIT_RATE_BASIS);
655: WSH_DEBUG_SV.log(l_module_name, 'CM_RATE_VARIANT',
656: p_Carrier_Service_Info.CM_RATE_VARIANT);
657: WSH_DEBUG_SV.log(l_module_name, 'DISTANCE_CALCULATION_METHOD',
658: p_Carrier_Service_Info.DISTANCE_CALCULATION_METHOD);
659: WSH_DEBUG_SV.log(l_module_name, 'ORIGIN_DSTN_SURCHARGE_LEVEL',
660: p_Carrier_Service_Info.ORIGIN_DSTN_SURCHARGE_LEVEL);
661: WSH_DEBUG_SV.log(l_module_name, 'ALLOW_CONTINUOUS_MOVE',

Line 659: WSH_DEBUG_SV.log(l_module_name, 'ORIGIN_DSTN_SURCHARGE_LEVEL',

655: WSH_DEBUG_SV.log(l_module_name, 'CM_RATE_VARIANT',
656: p_Carrier_Service_Info.CM_RATE_VARIANT);
657: WSH_DEBUG_SV.log(l_module_name, 'DISTANCE_CALCULATION_METHOD',
658: p_Carrier_Service_Info.DISTANCE_CALCULATION_METHOD);
659: WSH_DEBUG_SV.log(l_module_name, 'ORIGIN_DSTN_SURCHARGE_LEVEL',
660: p_Carrier_Service_Info.ORIGIN_DSTN_SURCHARGE_LEVEL);
661: WSH_DEBUG_SV.log(l_module_name, 'ALLOW_CONTINUOUS_MOVE',
662: p_Carrier_Service_Info.ALLOW_CONTINUOUS_MOVE);
663: WSH_DEBUG_SV.log(l_module_name, 'MAX_CM_DH_TIME',

Line 661: WSH_DEBUG_SV.log(l_module_name, 'ALLOW_CONTINUOUS_MOVE',

657: WSH_DEBUG_SV.log(l_module_name, 'DISTANCE_CALCULATION_METHOD',
658: p_Carrier_Service_Info.DISTANCE_CALCULATION_METHOD);
659: WSH_DEBUG_SV.log(l_module_name, 'ORIGIN_DSTN_SURCHARGE_LEVEL',
660: p_Carrier_Service_Info.ORIGIN_DSTN_SURCHARGE_LEVEL);
661: WSH_DEBUG_SV.log(l_module_name, 'ALLOW_CONTINUOUS_MOVE',
662: p_Carrier_Service_Info.ALLOW_CONTINUOUS_MOVE);
663: WSH_DEBUG_SV.log(l_module_name, 'MAX_CM_DH_TIME',
664: p_Carrier_Service_Info.MAX_CM_DH_TIME);
665: -- R12 Code changes

Line 663: WSH_DEBUG_SV.log(l_module_name, 'MAX_CM_DH_TIME',

659: WSH_DEBUG_SV.log(l_module_name, 'ORIGIN_DSTN_SURCHARGE_LEVEL',
660: p_Carrier_Service_Info.ORIGIN_DSTN_SURCHARGE_LEVEL);
661: WSH_DEBUG_SV.log(l_module_name, 'ALLOW_CONTINUOUS_MOVE',
662: p_Carrier_Service_Info.ALLOW_CONTINUOUS_MOVE);
663: WSH_DEBUG_SV.log(l_module_name, 'MAX_CM_DH_TIME',
664: p_Carrier_Service_Info.MAX_CM_DH_TIME);
665: -- R12 Code changes
666: WSH_DEBUG_SV.log(l_module_name, 'DIM_DIMENSIONA_FACTOR',
667: p_Carrier_Service_Info.DIM_DIMENSIONAL_FACTOR);

Line 666: WSH_DEBUG_SV.log(l_module_name, 'DIM_DIMENSIONA_FACTOR',

662: p_Carrier_Service_Info.ALLOW_CONTINUOUS_MOVE);
663: WSH_DEBUG_SV.log(l_module_name, 'MAX_CM_DH_TIME',
664: p_Carrier_Service_Info.MAX_CM_DH_TIME);
665: -- R12 Code changes
666: WSH_DEBUG_SV.log(l_module_name, 'DIM_DIMENSIONA_FACTOR',
667: p_Carrier_Service_Info.DIM_DIMENSIONAL_FACTOR);
668: WSH_DEBUG_SV.log(l_module_name, 'DIM_WEIGHT_UOM',
669: p_Carrier_Service_Info.DIM_WEIGHT_UOM);
670: WSH_DEBUG_SV.log(l_module_name, 'DIM_VOLUME_UOM',

Line 668: WSH_DEBUG_SV.log(l_module_name, 'DIM_WEIGHT_UOM',

664: p_Carrier_Service_Info.MAX_CM_DH_TIME);
665: -- R12 Code changes
666: WSH_DEBUG_SV.log(l_module_name, 'DIM_DIMENSIONA_FACTOR',
667: p_Carrier_Service_Info.DIM_DIMENSIONAL_FACTOR);
668: WSH_DEBUG_SV.log(l_module_name, 'DIM_WEIGHT_UOM',
669: p_Carrier_Service_Info.DIM_WEIGHT_UOM);
670: WSH_DEBUG_SV.log(l_module_name, 'DIM_VOLUME_UOM',
671: p_Carrier_Service_Info.DIM_VOLUME_UOM);
672: WSH_DEBUG_SV.log(l_module_name, 'DIM_DIMENSION_UOM',

Line 670: WSH_DEBUG_SV.log(l_module_name, 'DIM_VOLUME_UOM',

666: WSH_DEBUG_SV.log(l_module_name, 'DIM_DIMENSIONA_FACTOR',
667: p_Carrier_Service_Info.DIM_DIMENSIONAL_FACTOR);
668: WSH_DEBUG_SV.log(l_module_name, 'DIM_WEIGHT_UOM',
669: p_Carrier_Service_Info.DIM_WEIGHT_UOM);
670: WSH_DEBUG_SV.log(l_module_name, 'DIM_VOLUME_UOM',
671: p_Carrier_Service_Info.DIM_VOLUME_UOM);
672: WSH_DEBUG_SV.log(l_module_name, 'DIM_DIMENSION_UOM',
673: p_Carrier_Service_Info.DIM_DIMENSION_UOM);
674: WSH_DEBUG_SV.log(l_module_name, 'DIM_MIN_PACK_VOL',

Line 672: WSH_DEBUG_SV.log(l_module_name, 'DIM_DIMENSION_UOM',

668: WSH_DEBUG_SV.log(l_module_name, 'DIM_WEIGHT_UOM',
669: p_Carrier_Service_Info.DIM_WEIGHT_UOM);
670: WSH_DEBUG_SV.log(l_module_name, 'DIM_VOLUME_UOM',
671: p_Carrier_Service_Info.DIM_VOLUME_UOM);
672: WSH_DEBUG_SV.log(l_module_name, 'DIM_DIMENSION_UOM',
673: p_Carrier_Service_Info.DIM_DIMENSION_UOM);
674: WSH_DEBUG_SV.log(l_module_name, 'DIM_MIN_PACK_VOL',
675: p_Carrier_Service_Info.DIM_MIN_PACK_VOL);
676: WSH_DEBUG_SV.log(l_module_name, 'DEFAULT_VEHICLE_TYPE_ID',

Line 674: WSH_DEBUG_SV.log(l_module_name, 'DIM_MIN_PACK_VOL',

670: WSH_DEBUG_SV.log(l_module_name, 'DIM_VOLUME_UOM',
671: p_Carrier_Service_Info.DIM_VOLUME_UOM);
672: WSH_DEBUG_SV.log(l_module_name, 'DIM_DIMENSION_UOM',
673: p_Carrier_Service_Info.DIM_DIMENSION_UOM);
674: WSH_DEBUG_SV.log(l_module_name, 'DIM_MIN_PACK_VOL',
675: p_Carrier_Service_Info.DIM_MIN_PACK_VOL);
676: WSH_DEBUG_SV.log(l_module_name, 'DEFAULT_VEHICLE_TYPE_ID',
677: p_Carrier_Service_Info.DEFAULT_VEHICLE_TYPE_ID);
678: WSH_DEBUG_SV.log(l_module_name, 'UPDATE_MOT_SL',

Line 676: WSH_DEBUG_SV.log(l_module_name, 'DEFAULT_VEHICLE_TYPE_ID',

672: WSH_DEBUG_SV.log(l_module_name, 'DIM_DIMENSION_UOM',
673: p_Carrier_Service_Info.DIM_DIMENSION_UOM);
674: WSH_DEBUG_SV.log(l_module_name, 'DIM_MIN_PACK_VOL',
675: p_Carrier_Service_Info.DIM_MIN_PACK_VOL);
676: WSH_DEBUG_SV.log(l_module_name, 'DEFAULT_VEHICLE_TYPE_ID',
677: p_Carrier_Service_Info.DEFAULT_VEHICLE_TYPE_ID);
678: WSH_DEBUG_SV.log(l_module_name, 'UPDATE_MOT_SL',
679: p_Carrier_Service_Info.UPDATE_MOT_SL);
680: -- R12 Code changes

Line 678: WSH_DEBUG_SV.log(l_module_name, 'UPDATE_MOT_SL',

674: WSH_DEBUG_SV.log(l_module_name, 'DIM_MIN_PACK_VOL',
675: p_Carrier_Service_Info.DIM_MIN_PACK_VOL);
676: WSH_DEBUG_SV.log(l_module_name, 'DEFAULT_VEHICLE_TYPE_ID',
677: p_Carrier_Service_Info.DEFAULT_VEHICLE_TYPE_ID);
678: WSH_DEBUG_SV.log(l_module_name, 'UPDATE_MOT_SL',
679: p_Carrier_Service_Info.UPDATE_MOT_SL);
680: -- R12 Code changes
681:
682: END IF;

Line 696: WSH_DEBUG_SV.log(l_module_name,'FORM_RECORD_DELETED');

692: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
693: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
694: --
695: IF l_debug_on THEN
696: WSH_DEBUG_SV.log(l_module_name,'FORM_RECORD_DELETED');
697: WSH_DEBUG_SV.pop(l_module_name);
698: END IF;
699: --
700: RETURN;

Line 697: WSH_DEBUG_SV.pop(l_module_name);

693: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
694: --
695: IF l_debug_on THEN
696: WSH_DEBUG_SV.log(l_module_name,'FORM_RECORD_DELETED');
697: WSH_DEBUG_SV.pop(l_module_name);
698: END IF;
699: --
700: RETURN;
701: END IF;

Line 704: WSH_DEBUG_SV.log(l_module_name,'Carrier_Service_ID',

700: RETURN;
701: END IF;
702: CLOSE C_lock_row;
703: IF l_debug_on THEN
704: WSH_DEBUG_SV.log(l_module_name,'Carrier_Service_ID',
705: Recinfo.Carrier_Service_ID);
706: WSH_DEBUG_SV.log(l_module_name,'Ship_Method_Code',
707: Recinfo.Ship_Method_Code);
708: WSH_DEBUG_SV.log(l_module_name,'Ship_Method_Meaning',

Line 706: WSH_DEBUG_SV.log(l_module_name,'Ship_Method_Code',

702: CLOSE C_lock_row;
703: IF l_debug_on THEN
704: WSH_DEBUG_SV.log(l_module_name,'Carrier_Service_ID',
705: Recinfo.Carrier_Service_ID);
706: WSH_DEBUG_SV.log(l_module_name,'Ship_Method_Code',
707: Recinfo.Ship_Method_Code);
708: WSH_DEBUG_SV.log(l_module_name,'Ship_Method_Meaning',
709: Recinfo.Ship_Method_Meaning);
710: WSH_DEBUG_SV.log(l_module_name,'Service_level',

Line 708: WSH_DEBUG_SV.log(l_module_name,'Ship_Method_Meaning',

704: WSH_DEBUG_SV.log(l_module_name,'Carrier_Service_ID',
705: Recinfo.Carrier_Service_ID);
706: WSH_DEBUG_SV.log(l_module_name,'Ship_Method_Code',
707: Recinfo.Ship_Method_Code);
708: WSH_DEBUG_SV.log(l_module_name,'Ship_Method_Meaning',
709: Recinfo.Ship_Method_Meaning);
710: WSH_DEBUG_SV.log(l_module_name,'Service_level',
711: Recinfo.Service_level);
712: WSH_DEBUG_SV.log(l_module_name,'min_sl_time',

Line 710: WSH_DEBUG_SV.log(l_module_name,'Service_level',

706: WSH_DEBUG_SV.log(l_module_name,'Ship_Method_Code',
707: Recinfo.Ship_Method_Code);
708: WSH_DEBUG_SV.log(l_module_name,'Ship_Method_Meaning',
709: Recinfo.Ship_Method_Meaning);
710: WSH_DEBUG_SV.log(l_module_name,'Service_level',
711: Recinfo.Service_level);
712: WSH_DEBUG_SV.log(l_module_name,'min_sl_time',
713: Recinfo.min_sl_time);
714: WSH_DEBUG_SV.log(l_module_name,'max_sl_time',

Line 712: WSH_DEBUG_SV.log(l_module_name,'min_sl_time',

708: WSH_DEBUG_SV.log(l_module_name,'Ship_Method_Meaning',
709: Recinfo.Ship_Method_Meaning);
710: WSH_DEBUG_SV.log(l_module_name,'Service_level',
711: Recinfo.Service_level);
712: WSH_DEBUG_SV.log(l_module_name,'min_sl_time',
713: Recinfo.min_sl_time);
714: WSH_DEBUG_SV.log(l_module_name,'max_sl_time',
715: Recinfo.max_sl_time);
716: WSH_DEBUG_SV.log(l_module_name,'sl_time_uom',

Line 714: WSH_DEBUG_SV.log(l_module_name,'max_sl_time',

710: WSH_DEBUG_SV.log(l_module_name,'Service_level',
711: Recinfo.Service_level);
712: WSH_DEBUG_SV.log(l_module_name,'min_sl_time',
713: Recinfo.min_sl_time);
714: WSH_DEBUG_SV.log(l_module_name,'max_sl_time',
715: Recinfo.max_sl_time);
716: WSH_DEBUG_SV.log(l_module_name,'sl_time_uom',
717: Recinfo.sl_time_uom);
718: WSH_DEBUG_SV.log(l_module_name,'Attribute_Category',

Line 716: WSH_DEBUG_SV.log(l_module_name,'sl_time_uom',

712: WSH_DEBUG_SV.log(l_module_name,'min_sl_time',
713: Recinfo.min_sl_time);
714: WSH_DEBUG_SV.log(l_module_name,'max_sl_time',
715: Recinfo.max_sl_time);
716: WSH_DEBUG_SV.log(l_module_name,'sl_time_uom',
717: Recinfo.sl_time_uom);
718: WSH_DEBUG_SV.log(l_module_name,'Attribute_Category',
719: Recinfo.Attribute_Category);
720: WSH_DEBUG_SV.log(l_module_name,'attribute1',

Line 718: WSH_DEBUG_SV.log(l_module_name,'Attribute_Category',

714: WSH_DEBUG_SV.log(l_module_name,'max_sl_time',
715: Recinfo.max_sl_time);
716: WSH_DEBUG_SV.log(l_module_name,'sl_time_uom',
717: Recinfo.sl_time_uom);
718: WSH_DEBUG_SV.log(l_module_name,'Attribute_Category',
719: Recinfo.Attribute_Category);
720: WSH_DEBUG_SV.log(l_module_name,'attribute1',
721: Recinfo.attribute1);
722: WSH_DEBUG_SV.log(l_module_name,'attribute2',

Line 720: WSH_DEBUG_SV.log(l_module_name,'attribute1',

716: WSH_DEBUG_SV.log(l_module_name,'sl_time_uom',
717: Recinfo.sl_time_uom);
718: WSH_DEBUG_SV.log(l_module_name,'Attribute_Category',
719: Recinfo.Attribute_Category);
720: WSH_DEBUG_SV.log(l_module_name,'attribute1',
721: Recinfo.attribute1);
722: WSH_DEBUG_SV.log(l_module_name,'attribute2',
723: Recinfo.attribute2);
724: WSH_DEBUG_SV.log(l_module_name,'attribute3',

Line 722: WSH_DEBUG_SV.log(l_module_name,'attribute2',

718: WSH_DEBUG_SV.log(l_module_name,'Attribute_Category',
719: Recinfo.Attribute_Category);
720: WSH_DEBUG_SV.log(l_module_name,'attribute1',
721: Recinfo.attribute1);
722: WSH_DEBUG_SV.log(l_module_name,'attribute2',
723: Recinfo.attribute2);
724: WSH_DEBUG_SV.log(l_module_name,'attribute3',
725: Recinfo.attribute3);
726: WSH_DEBUG_SV.log(l_module_name,'attribute4',

Line 724: WSH_DEBUG_SV.log(l_module_name,'attribute3',

720: WSH_DEBUG_SV.log(l_module_name,'attribute1',
721: Recinfo.attribute1);
722: WSH_DEBUG_SV.log(l_module_name,'attribute2',
723: Recinfo.attribute2);
724: WSH_DEBUG_SV.log(l_module_name,'attribute3',
725: Recinfo.attribute3);
726: WSH_DEBUG_SV.log(l_module_name,'attribute4',
727: Recinfo.attribute4);
728: WSH_DEBUG_SV.log(l_module_name,'attribute5',

Line 726: WSH_DEBUG_SV.log(l_module_name,'attribute4',

722: WSH_DEBUG_SV.log(l_module_name,'attribute2',
723: Recinfo.attribute2);
724: WSH_DEBUG_SV.log(l_module_name,'attribute3',
725: Recinfo.attribute3);
726: WSH_DEBUG_SV.log(l_module_name,'attribute4',
727: Recinfo.attribute4);
728: WSH_DEBUG_SV.log(l_module_name,'attribute5',
729: Recinfo.attribute5);
730: WSH_DEBUG_SV.log(l_module_name,'attribute6',

Line 728: WSH_DEBUG_SV.log(l_module_name,'attribute5',

724: WSH_DEBUG_SV.log(l_module_name,'attribute3',
725: Recinfo.attribute3);
726: WSH_DEBUG_SV.log(l_module_name,'attribute4',
727: Recinfo.attribute4);
728: WSH_DEBUG_SV.log(l_module_name,'attribute5',
729: Recinfo.attribute5);
730: WSH_DEBUG_SV.log(l_module_name,'attribute6',
731: Recinfo.attribute6);
732: WSH_DEBUG_SV.log(l_module_name,'attribute7',

Line 730: WSH_DEBUG_SV.log(l_module_name,'attribute6',

726: WSH_DEBUG_SV.log(l_module_name,'attribute4',
727: Recinfo.attribute4);
728: WSH_DEBUG_SV.log(l_module_name,'attribute5',
729: Recinfo.attribute5);
730: WSH_DEBUG_SV.log(l_module_name,'attribute6',
731: Recinfo.attribute6);
732: WSH_DEBUG_SV.log(l_module_name,'attribute7',
733: Recinfo.attribute7);
734: WSH_DEBUG_SV.log(l_module_name,'attribute8',

Line 732: WSH_DEBUG_SV.log(l_module_name,'attribute7',

728: WSH_DEBUG_SV.log(l_module_name,'attribute5',
729: Recinfo.attribute5);
730: WSH_DEBUG_SV.log(l_module_name,'attribute6',
731: Recinfo.attribute6);
732: WSH_DEBUG_SV.log(l_module_name,'attribute7',
733: Recinfo.attribute7);
734: WSH_DEBUG_SV.log(l_module_name,'attribute8',
735: Recinfo.attribute8);
736: WSH_DEBUG_SV.log(l_module_name,'attribute9',

Line 734: WSH_DEBUG_SV.log(l_module_name,'attribute8',

730: WSH_DEBUG_SV.log(l_module_name,'attribute6',
731: Recinfo.attribute6);
732: WSH_DEBUG_SV.log(l_module_name,'attribute7',
733: Recinfo.attribute7);
734: WSH_DEBUG_SV.log(l_module_name,'attribute8',
735: Recinfo.attribute8);
736: WSH_DEBUG_SV.log(l_module_name,'attribute9',
737: Recinfo.attribute9);
738: WSH_DEBUG_SV.log(l_module_name,'attribute10',

Line 736: WSH_DEBUG_SV.log(l_module_name,'attribute9',

732: WSH_DEBUG_SV.log(l_module_name,'attribute7',
733: Recinfo.attribute7);
734: WSH_DEBUG_SV.log(l_module_name,'attribute8',
735: Recinfo.attribute8);
736: WSH_DEBUG_SV.log(l_module_name,'attribute9',
737: Recinfo.attribute9);
738: WSH_DEBUG_SV.log(l_module_name,'attribute10',
739: Recinfo.attribute10);
740: WSH_DEBUG_SV.log(l_module_name,'attribute11',

Line 738: WSH_DEBUG_SV.log(l_module_name,'attribute10',

734: WSH_DEBUG_SV.log(l_module_name,'attribute8',
735: Recinfo.attribute8);
736: WSH_DEBUG_SV.log(l_module_name,'attribute9',
737: Recinfo.attribute9);
738: WSH_DEBUG_SV.log(l_module_name,'attribute10',
739: Recinfo.attribute10);
740: WSH_DEBUG_SV.log(l_module_name,'attribute11',
741: Recinfo.attribute11);
742: WSH_DEBUG_SV.log(l_module_name,'attribute12',

Line 740: WSH_DEBUG_SV.log(l_module_name,'attribute11',

736: WSH_DEBUG_SV.log(l_module_name,'attribute9',
737: Recinfo.attribute9);
738: WSH_DEBUG_SV.log(l_module_name,'attribute10',
739: Recinfo.attribute10);
740: WSH_DEBUG_SV.log(l_module_name,'attribute11',
741: Recinfo.attribute11);
742: WSH_DEBUG_SV.log(l_module_name,'attribute12',
743: Recinfo.attribute12);
744: WSH_DEBUG_SV.log(l_module_name,'attribute13',

Line 742: WSH_DEBUG_SV.log(l_module_name,'attribute12',

738: WSH_DEBUG_SV.log(l_module_name,'attribute10',
739: Recinfo.attribute10);
740: WSH_DEBUG_SV.log(l_module_name,'attribute11',
741: Recinfo.attribute11);
742: WSH_DEBUG_SV.log(l_module_name,'attribute12',
743: Recinfo.attribute12);
744: WSH_DEBUG_SV.log(l_module_name,'attribute13',
745: Recinfo.attribute13);
746: WSH_DEBUG_SV.log(l_module_name,'attribute14',

Line 744: WSH_DEBUG_SV.log(l_module_name,'attribute13',

740: WSH_DEBUG_SV.log(l_module_name,'attribute11',
741: Recinfo.attribute11);
742: WSH_DEBUG_SV.log(l_module_name,'attribute12',
743: Recinfo.attribute12);
744: WSH_DEBUG_SV.log(l_module_name,'attribute13',
745: Recinfo.attribute13);
746: WSH_DEBUG_SV.log(l_module_name,'attribute14',
747: Recinfo.attribute14);
748: WSH_DEBUG_SV.log(l_module_name,'attribute15',

Line 746: WSH_DEBUG_SV.log(l_module_name,'attribute14',

742: WSH_DEBUG_SV.log(l_module_name,'attribute12',
743: Recinfo.attribute12);
744: WSH_DEBUG_SV.log(l_module_name,'attribute13',
745: Recinfo.attribute13);
746: WSH_DEBUG_SV.log(l_module_name,'attribute14',
747: Recinfo.attribute14);
748: WSH_DEBUG_SV.log(l_module_name,'attribute15',
749: Recinfo.attribute15);
750: -- Pack J Enhancement

Line 748: WSH_DEBUG_SV.log(l_module_name,'attribute15',

744: WSH_DEBUG_SV.log(l_module_name,'attribute13',
745: Recinfo.attribute13);
746: WSH_DEBUG_SV.log(l_module_name,'attribute14',
747: Recinfo.attribute14);
748: WSH_DEBUG_SV.log(l_module_name,'attribute15',
749: Recinfo.attribute15);
750: -- Pack J Enhancement
751: WSH_DEBUG_SV.log(l_module_name, 'MAX_NUM_STOPS_PERMITTED',
752: Recinfo.MAX_NUM_STOPS_PERMITTED);

Line 751: WSH_DEBUG_SV.log(l_module_name, 'MAX_NUM_STOPS_PERMITTED',

747: Recinfo.attribute14);
748: WSH_DEBUG_SV.log(l_module_name,'attribute15',
749: Recinfo.attribute15);
750: -- Pack J Enhancement
751: WSH_DEBUG_SV.log(l_module_name, 'MAX_NUM_STOPS_PERMITTED',
752: Recinfo.MAX_NUM_STOPS_PERMITTED);
753: WSH_DEBUG_SV.log(l_module_name, 'MAX_TOTAL_DISTANCE',
754: Recinfo.MAX_TOTAL_DISTANCE);
755: WSH_DEBUG_SV.log(l_module_name, 'MAX_TOTAL_TIME',

Line 753: WSH_DEBUG_SV.log(l_module_name, 'MAX_TOTAL_DISTANCE',

749: Recinfo.attribute15);
750: -- Pack J Enhancement
751: WSH_DEBUG_SV.log(l_module_name, 'MAX_NUM_STOPS_PERMITTED',
752: Recinfo.MAX_NUM_STOPS_PERMITTED);
753: WSH_DEBUG_SV.log(l_module_name, 'MAX_TOTAL_DISTANCE',
754: Recinfo.MAX_TOTAL_DISTANCE);
755: WSH_DEBUG_SV.log(l_module_name, 'MAX_TOTAL_TIME',
756: Recinfo.MAX_TOTAL_TIME);
757: WSH_DEBUG_SV.log(l_module_name, 'ALLOW_INTERSPERSE_LOAD',

Line 755: WSH_DEBUG_SV.log(l_module_name, 'MAX_TOTAL_TIME',

751: WSH_DEBUG_SV.log(l_module_name, 'MAX_NUM_STOPS_PERMITTED',
752: Recinfo.MAX_NUM_STOPS_PERMITTED);
753: WSH_DEBUG_SV.log(l_module_name, 'MAX_TOTAL_DISTANCE',
754: Recinfo.MAX_TOTAL_DISTANCE);
755: WSH_DEBUG_SV.log(l_module_name, 'MAX_TOTAL_TIME',
756: Recinfo.MAX_TOTAL_TIME);
757: WSH_DEBUG_SV.log(l_module_name, 'ALLOW_INTERSPERSE_LOAD',
758: Recinfo.ALLOW_INTERSPERSE_LOAD);
759: WSH_DEBUG_SV.log(l_module_name, 'MAX_LAYOVER_TIME',

Line 757: WSH_DEBUG_SV.log(l_module_name, 'ALLOW_INTERSPERSE_LOAD',

753: WSH_DEBUG_SV.log(l_module_name, 'MAX_TOTAL_DISTANCE',
754: Recinfo.MAX_TOTAL_DISTANCE);
755: WSH_DEBUG_SV.log(l_module_name, 'MAX_TOTAL_TIME',
756: Recinfo.MAX_TOTAL_TIME);
757: WSH_DEBUG_SV.log(l_module_name, 'ALLOW_INTERSPERSE_LOAD',
758: Recinfo.ALLOW_INTERSPERSE_LOAD);
759: WSH_DEBUG_SV.log(l_module_name, 'MAX_LAYOVER_TIME',
760: Recinfo.MAX_LAYOVER_TIME);
761: WSH_DEBUG_SV.log(l_module_name, 'MIN_LAYOVER_TIME',

Line 759: WSH_DEBUG_SV.log(l_module_name, 'MAX_LAYOVER_TIME',

755: WSH_DEBUG_SV.log(l_module_name, 'MAX_TOTAL_TIME',
756: Recinfo.MAX_TOTAL_TIME);
757: WSH_DEBUG_SV.log(l_module_name, 'ALLOW_INTERSPERSE_LOAD',
758: Recinfo.ALLOW_INTERSPERSE_LOAD);
759: WSH_DEBUG_SV.log(l_module_name, 'MAX_LAYOVER_TIME',
760: Recinfo.MAX_LAYOVER_TIME);
761: WSH_DEBUG_SV.log(l_module_name, 'MIN_LAYOVER_TIME',
762: Recinfo.MIN_LAYOVER_TIME);
763: WSH_DEBUG_SV.log(l_module_name, 'MAX_TOTAL_DISTANCE_IN_24HR',

Line 761: WSH_DEBUG_SV.log(l_module_name, 'MIN_LAYOVER_TIME',

757: WSH_DEBUG_SV.log(l_module_name, 'ALLOW_INTERSPERSE_LOAD',
758: Recinfo.ALLOW_INTERSPERSE_LOAD);
759: WSH_DEBUG_SV.log(l_module_name, 'MAX_LAYOVER_TIME',
760: Recinfo.MAX_LAYOVER_TIME);
761: WSH_DEBUG_SV.log(l_module_name, 'MIN_LAYOVER_TIME',
762: Recinfo.MIN_LAYOVER_TIME);
763: WSH_DEBUG_SV.log(l_module_name, 'MAX_TOTAL_DISTANCE_IN_24HR',
764: Recinfo.MAX_TOTAL_DISTANCE_IN_24HR);
765: WSH_DEBUG_SV.log(l_module_name, 'MAX_DRIVING_TIME_IN_24HR',

Line 763: WSH_DEBUG_SV.log(l_module_name, 'MAX_TOTAL_DISTANCE_IN_24HR',

759: WSH_DEBUG_SV.log(l_module_name, 'MAX_LAYOVER_TIME',
760: Recinfo.MAX_LAYOVER_TIME);
761: WSH_DEBUG_SV.log(l_module_name, 'MIN_LAYOVER_TIME',
762: Recinfo.MIN_LAYOVER_TIME);
763: WSH_DEBUG_SV.log(l_module_name, 'MAX_TOTAL_DISTANCE_IN_24HR',
764: Recinfo.MAX_TOTAL_DISTANCE_IN_24HR);
765: WSH_DEBUG_SV.log(l_module_name, 'MAX_DRIVING_TIME_IN_24HR',
766: Recinfo.MAX_DRIVING_TIME_IN_24HR);
767: WSH_DEBUG_SV.log(l_module_name, 'MAX_DUTY_TIME_IN_24HR',

Line 765: WSH_DEBUG_SV.log(l_module_name, 'MAX_DRIVING_TIME_IN_24HR',

761: WSH_DEBUG_SV.log(l_module_name, 'MIN_LAYOVER_TIME',
762: Recinfo.MIN_LAYOVER_TIME);
763: WSH_DEBUG_SV.log(l_module_name, 'MAX_TOTAL_DISTANCE_IN_24HR',
764: Recinfo.MAX_TOTAL_DISTANCE_IN_24HR);
765: WSH_DEBUG_SV.log(l_module_name, 'MAX_DRIVING_TIME_IN_24HR',
766: Recinfo.MAX_DRIVING_TIME_IN_24HR);
767: WSH_DEBUG_SV.log(l_module_name, 'MAX_DUTY_TIME_IN_24HR',
768: Recinfo.MAX_DUTY_TIME_IN_24HR);
769: WSH_DEBUG_SV.log(l_module_name, 'MAX_CM_DISTANCE',

Line 767: WSH_DEBUG_SV.log(l_module_name, 'MAX_DUTY_TIME_IN_24HR',

763: WSH_DEBUG_SV.log(l_module_name, 'MAX_TOTAL_DISTANCE_IN_24HR',
764: Recinfo.MAX_TOTAL_DISTANCE_IN_24HR);
765: WSH_DEBUG_SV.log(l_module_name, 'MAX_DRIVING_TIME_IN_24HR',
766: Recinfo.MAX_DRIVING_TIME_IN_24HR);
767: WSH_DEBUG_SV.log(l_module_name, 'MAX_DUTY_TIME_IN_24HR',
768: Recinfo.MAX_DUTY_TIME_IN_24HR);
769: WSH_DEBUG_SV.log(l_module_name, 'MAX_CM_DISTANCE',
770: Recinfo.MAX_CM_DISTANCE);
771: WSH_DEBUG_SV.log(l_module_name, 'MAX_CM_TIME',

Line 769: WSH_DEBUG_SV.log(l_module_name, 'MAX_CM_DISTANCE',

765: WSH_DEBUG_SV.log(l_module_name, 'MAX_DRIVING_TIME_IN_24HR',
766: Recinfo.MAX_DRIVING_TIME_IN_24HR);
767: WSH_DEBUG_SV.log(l_module_name, 'MAX_DUTY_TIME_IN_24HR',
768: Recinfo.MAX_DUTY_TIME_IN_24HR);
769: WSH_DEBUG_SV.log(l_module_name, 'MAX_CM_DISTANCE',
770: Recinfo.MAX_CM_DISTANCE);
771: WSH_DEBUG_SV.log(l_module_name, 'MAX_CM_TIME',
772: Recinfo.MAX_CM_TIME);
773: WSH_DEBUG_SV.log(l_module_name, 'MAX_CM_DH_DISTANCE',

Line 771: WSH_DEBUG_SV.log(l_module_name, 'MAX_CM_TIME',

767: WSH_DEBUG_SV.log(l_module_name, 'MAX_DUTY_TIME_IN_24HR',
768: Recinfo.MAX_DUTY_TIME_IN_24HR);
769: WSH_DEBUG_SV.log(l_module_name, 'MAX_CM_DISTANCE',
770: Recinfo.MAX_CM_DISTANCE);
771: WSH_DEBUG_SV.log(l_module_name, 'MAX_CM_TIME',
772: Recinfo.MAX_CM_TIME);
773: WSH_DEBUG_SV.log(l_module_name, 'MAX_CM_DH_DISTANCE',
774: Recinfo.MAX_CM_DH_DISTANCE);
775: WSH_DEBUG_SV.log(l_module_name, 'MAX_SIZE_WIDTH',

Line 773: WSH_DEBUG_SV.log(l_module_name, 'MAX_CM_DH_DISTANCE',

769: WSH_DEBUG_SV.log(l_module_name, 'MAX_CM_DISTANCE',
770: Recinfo.MAX_CM_DISTANCE);
771: WSH_DEBUG_SV.log(l_module_name, 'MAX_CM_TIME',
772: Recinfo.MAX_CM_TIME);
773: WSH_DEBUG_SV.log(l_module_name, 'MAX_CM_DH_DISTANCE',
774: Recinfo.MAX_CM_DH_DISTANCE);
775: WSH_DEBUG_SV.log(l_module_name, 'MAX_SIZE_WIDTH',
776: Recinfo.MAX_SIZE_WIDTH);
777: WSH_DEBUG_SV.log(l_module_name, 'MAX_SIZE_HEIGHT',

Line 775: WSH_DEBUG_SV.log(l_module_name, 'MAX_SIZE_WIDTH',

771: WSH_DEBUG_SV.log(l_module_name, 'MAX_CM_TIME',
772: Recinfo.MAX_CM_TIME);
773: WSH_DEBUG_SV.log(l_module_name, 'MAX_CM_DH_DISTANCE',
774: Recinfo.MAX_CM_DH_DISTANCE);
775: WSH_DEBUG_SV.log(l_module_name, 'MAX_SIZE_WIDTH',
776: Recinfo.MAX_SIZE_WIDTH);
777: WSH_DEBUG_SV.log(l_module_name, 'MAX_SIZE_HEIGHT',
778: Recinfo.MAX_SIZE_HEIGHT);
779: WSH_DEBUG_SV.log(l_module_name, 'MAX_SIZE_LENGTH',

Line 777: WSH_DEBUG_SV.log(l_module_name, 'MAX_SIZE_HEIGHT',

773: WSH_DEBUG_SV.log(l_module_name, 'MAX_CM_DH_DISTANCE',
774: Recinfo.MAX_CM_DH_DISTANCE);
775: WSH_DEBUG_SV.log(l_module_name, 'MAX_SIZE_WIDTH',
776: Recinfo.MAX_SIZE_WIDTH);
777: WSH_DEBUG_SV.log(l_module_name, 'MAX_SIZE_HEIGHT',
778: Recinfo.MAX_SIZE_HEIGHT);
779: WSH_DEBUG_SV.log(l_module_name, 'MAX_SIZE_LENGTH',
780: Recinfo.MAX_SIZE_LENGTH);
781: WSH_DEBUG_SV.log(l_module_name, 'MIN_SIZE_WIDTH',

Line 779: WSH_DEBUG_SV.log(l_module_name, 'MAX_SIZE_LENGTH',

775: WSH_DEBUG_SV.log(l_module_name, 'MAX_SIZE_WIDTH',
776: Recinfo.MAX_SIZE_WIDTH);
777: WSH_DEBUG_SV.log(l_module_name, 'MAX_SIZE_HEIGHT',
778: Recinfo.MAX_SIZE_HEIGHT);
779: WSH_DEBUG_SV.log(l_module_name, 'MAX_SIZE_LENGTH',
780: Recinfo.MAX_SIZE_LENGTH);
781: WSH_DEBUG_SV.log(l_module_name, 'MIN_SIZE_WIDTH',
782: Recinfo.MIN_SIZE_WIDTH);
783: WSH_DEBUG_SV.log(l_module_name, 'MIN_SIZE_HEIGHT',

Line 781: WSH_DEBUG_SV.log(l_module_name, 'MIN_SIZE_WIDTH',

777: WSH_DEBUG_SV.log(l_module_name, 'MAX_SIZE_HEIGHT',
778: Recinfo.MAX_SIZE_HEIGHT);
779: WSH_DEBUG_SV.log(l_module_name, 'MAX_SIZE_LENGTH',
780: Recinfo.MAX_SIZE_LENGTH);
781: WSH_DEBUG_SV.log(l_module_name, 'MIN_SIZE_WIDTH',
782: Recinfo.MIN_SIZE_WIDTH);
783: WSH_DEBUG_SV.log(l_module_name, 'MIN_SIZE_HEIGHT',
784: Recinfo.MIN_SIZE_HEIGHT);
785: WSH_DEBUG_SV.log(l_module_name, 'MIN_SIZE_LENGTH',

Line 783: WSH_DEBUG_SV.log(l_module_name, 'MIN_SIZE_HEIGHT',

779: WSH_DEBUG_SV.log(l_module_name, 'MAX_SIZE_LENGTH',
780: Recinfo.MAX_SIZE_LENGTH);
781: WSH_DEBUG_SV.log(l_module_name, 'MIN_SIZE_WIDTH',
782: Recinfo.MIN_SIZE_WIDTH);
783: WSH_DEBUG_SV.log(l_module_name, 'MIN_SIZE_HEIGHT',
784: Recinfo.MIN_SIZE_HEIGHT);
785: WSH_DEBUG_SV.log(l_module_name, 'MIN_SIZE_LENGTH',
786: Recinfo.MIN_SIZE_LENGTH);
787: WSH_DEBUG_SV.log(l_module_name, 'MAX_OUT_OF_ROUTE',

Line 785: WSH_DEBUG_SV.log(l_module_name, 'MIN_SIZE_LENGTH',

781: WSH_DEBUG_SV.log(l_module_name, 'MIN_SIZE_WIDTH',
782: Recinfo.MIN_SIZE_WIDTH);
783: WSH_DEBUG_SV.log(l_module_name, 'MIN_SIZE_HEIGHT',
784: Recinfo.MIN_SIZE_HEIGHT);
785: WSH_DEBUG_SV.log(l_module_name, 'MIN_SIZE_LENGTH',
786: Recinfo.MIN_SIZE_LENGTH);
787: WSH_DEBUG_SV.log(l_module_name, 'MAX_OUT_OF_ROUTE',
788: Recinfo.MAX_OUT_OF_ROUTE);
789: WSH_DEBUG_SV.log(l_module_name, 'CM_FREE_DH_MILEAGE',

Line 787: WSH_DEBUG_SV.log(l_module_name, 'MAX_OUT_OF_ROUTE',

783: WSH_DEBUG_SV.log(l_module_name, 'MIN_SIZE_HEIGHT',
784: Recinfo.MIN_SIZE_HEIGHT);
785: WSH_DEBUG_SV.log(l_module_name, 'MIN_SIZE_LENGTH',
786: Recinfo.MIN_SIZE_LENGTH);
787: WSH_DEBUG_SV.log(l_module_name, 'MAX_OUT_OF_ROUTE',
788: Recinfo.MAX_OUT_OF_ROUTE);
789: WSH_DEBUG_SV.log(l_module_name, 'CM_FREE_DH_MILEAGE',
790: Recinfo.CM_FREE_DH_MILEAGE);
791: WSH_DEBUG_SV.log(l_module_name, 'MIN_CM_DISTANCE',

Line 789: WSH_DEBUG_SV.log(l_module_name, 'CM_FREE_DH_MILEAGE',

785: WSH_DEBUG_SV.log(l_module_name, 'MIN_SIZE_LENGTH',
786: Recinfo.MIN_SIZE_LENGTH);
787: WSH_DEBUG_SV.log(l_module_name, 'MAX_OUT_OF_ROUTE',
788: Recinfo.MAX_OUT_OF_ROUTE);
789: WSH_DEBUG_SV.log(l_module_name, 'CM_FREE_DH_MILEAGE',
790: Recinfo.CM_FREE_DH_MILEAGE);
791: WSH_DEBUG_SV.log(l_module_name, 'MIN_CM_DISTANCE',
792: Recinfo.MIN_CM_DISTANCE);
793: WSH_DEBUG_SV.log(l_module_name, 'CM_FIRST_LOAD_DISCOUNT',

Line 791: WSH_DEBUG_SV.log(l_module_name, 'MIN_CM_DISTANCE',

787: WSH_DEBUG_SV.log(l_module_name, 'MAX_OUT_OF_ROUTE',
788: Recinfo.MAX_OUT_OF_ROUTE);
789: WSH_DEBUG_SV.log(l_module_name, 'CM_FREE_DH_MILEAGE',
790: Recinfo.CM_FREE_DH_MILEAGE);
791: WSH_DEBUG_SV.log(l_module_name, 'MIN_CM_DISTANCE',
792: Recinfo.MIN_CM_DISTANCE);
793: WSH_DEBUG_SV.log(l_module_name, 'CM_FIRST_LOAD_DISCOUNT',
794: Recinfo.CM_FIRST_LOAD_DISCOUNT);
795: WSH_DEBUG_SV.log(l_module_name, 'MIN_CM_TIME',

Line 793: WSH_DEBUG_SV.log(l_module_name, 'CM_FIRST_LOAD_DISCOUNT',

789: WSH_DEBUG_SV.log(l_module_name, 'CM_FREE_DH_MILEAGE',
790: Recinfo.CM_FREE_DH_MILEAGE);
791: WSH_DEBUG_SV.log(l_module_name, 'MIN_CM_DISTANCE',
792: Recinfo.MIN_CM_DISTANCE);
793: WSH_DEBUG_SV.log(l_module_name, 'CM_FIRST_LOAD_DISCOUNT',
794: Recinfo.CM_FIRST_LOAD_DISCOUNT);
795: WSH_DEBUG_SV.log(l_module_name, 'MIN_CM_TIME',
796: Recinfo.MIN_CM_TIME);
797: WSH_DEBUG_SV.log(l_module_name, 'UNIT_RATE_BASIS',

Line 795: WSH_DEBUG_SV.log(l_module_name, 'MIN_CM_TIME',

791: WSH_DEBUG_SV.log(l_module_name, 'MIN_CM_DISTANCE',
792: Recinfo.MIN_CM_DISTANCE);
793: WSH_DEBUG_SV.log(l_module_name, 'CM_FIRST_LOAD_DISCOUNT',
794: Recinfo.CM_FIRST_LOAD_DISCOUNT);
795: WSH_DEBUG_SV.log(l_module_name, 'MIN_CM_TIME',
796: Recinfo.MIN_CM_TIME);
797: WSH_DEBUG_SV.log(l_module_name, 'UNIT_RATE_BASIS',
798: Recinfo.UNIT_RATE_BASIS);
799: WSH_DEBUG_SV.log(l_module_name, 'CM_RATE_VARIANT',

Line 797: WSH_DEBUG_SV.log(l_module_name, 'UNIT_RATE_BASIS',

793: WSH_DEBUG_SV.log(l_module_name, 'CM_FIRST_LOAD_DISCOUNT',
794: Recinfo.CM_FIRST_LOAD_DISCOUNT);
795: WSH_DEBUG_SV.log(l_module_name, 'MIN_CM_TIME',
796: Recinfo.MIN_CM_TIME);
797: WSH_DEBUG_SV.log(l_module_name, 'UNIT_RATE_BASIS',
798: Recinfo.UNIT_RATE_BASIS);
799: WSH_DEBUG_SV.log(l_module_name, 'CM_RATE_VARIANT',
800: Recinfo.CM_RATE_VARIANT);
801: WSH_DEBUG_SV.log(l_module_name, 'DISTANCE_CALCULATION_METHOD',

Line 799: WSH_DEBUG_SV.log(l_module_name, 'CM_RATE_VARIANT',

795: WSH_DEBUG_SV.log(l_module_name, 'MIN_CM_TIME',
796: Recinfo.MIN_CM_TIME);
797: WSH_DEBUG_SV.log(l_module_name, 'UNIT_RATE_BASIS',
798: Recinfo.UNIT_RATE_BASIS);
799: WSH_DEBUG_SV.log(l_module_name, 'CM_RATE_VARIANT',
800: Recinfo.CM_RATE_VARIANT);
801: WSH_DEBUG_SV.log(l_module_name, 'DISTANCE_CALCULATION_METHOD',
802: Recinfo.DISTANCE_CALCULATION_METHOD);
803: WSH_DEBUG_SV.log(l_module_name, 'ORIGIN_DSTN_SURCHARGE_LEVEL',

Line 801: WSH_DEBUG_SV.log(l_module_name, 'DISTANCE_CALCULATION_METHOD',

797: WSH_DEBUG_SV.log(l_module_name, 'UNIT_RATE_BASIS',
798: Recinfo.UNIT_RATE_BASIS);
799: WSH_DEBUG_SV.log(l_module_name, 'CM_RATE_VARIANT',
800: Recinfo.CM_RATE_VARIANT);
801: WSH_DEBUG_SV.log(l_module_name, 'DISTANCE_CALCULATION_METHOD',
802: Recinfo.DISTANCE_CALCULATION_METHOD);
803: WSH_DEBUG_SV.log(l_module_name, 'ORIGIN_DSTN_SURCHARGE_LEVEL',
804: Recinfo.ORIGIN_DSTN_SURCHARGE_LEVEL);
805: WSH_DEBUG_SV.log(l_module_name, 'MAX_CM_DH_TIME',

Line 803: WSH_DEBUG_SV.log(l_module_name, 'ORIGIN_DSTN_SURCHARGE_LEVEL',

799: WSH_DEBUG_SV.log(l_module_name, 'CM_RATE_VARIANT',
800: Recinfo.CM_RATE_VARIANT);
801: WSH_DEBUG_SV.log(l_module_name, 'DISTANCE_CALCULATION_METHOD',
802: Recinfo.DISTANCE_CALCULATION_METHOD);
803: WSH_DEBUG_SV.log(l_module_name, 'ORIGIN_DSTN_SURCHARGE_LEVEL',
804: Recinfo.ORIGIN_DSTN_SURCHARGE_LEVEL);
805: WSH_DEBUG_SV.log(l_module_name, 'MAX_CM_DH_TIME',
806: Recinfo.MAX_CM_DH_TIME);
807: WSH_DEBUG_SV.log(l_module_name, 'ALLOW_CONTINUOUS_MOVE',

Line 805: WSH_DEBUG_SV.log(l_module_name, 'MAX_CM_DH_TIME',

801: WSH_DEBUG_SV.log(l_module_name, 'DISTANCE_CALCULATION_METHOD',
802: Recinfo.DISTANCE_CALCULATION_METHOD);
803: WSH_DEBUG_SV.log(l_module_name, 'ORIGIN_DSTN_SURCHARGE_LEVEL',
804: Recinfo.ORIGIN_DSTN_SURCHARGE_LEVEL);
805: WSH_DEBUG_SV.log(l_module_name, 'MAX_CM_DH_TIME',
806: Recinfo.MAX_CM_DH_TIME);
807: WSH_DEBUG_SV.log(l_module_name, 'ALLOW_CONTINUOUS_MOVE',
808: Recinfo.ALLOW_CONTINUOUS_MOVE);
809: END IF;

Line 807: WSH_DEBUG_SV.log(l_module_name, 'ALLOW_CONTINUOUS_MOVE',

803: WSH_DEBUG_SV.log(l_module_name, 'ORIGIN_DSTN_SURCHARGE_LEVEL',
804: Recinfo.ORIGIN_DSTN_SURCHARGE_LEVEL);
805: WSH_DEBUG_SV.log(l_module_name, 'MAX_CM_DH_TIME',
806: Recinfo.MAX_CM_DH_TIME);
807: WSH_DEBUG_SV.log(l_module_name, 'ALLOW_CONTINUOUS_MOVE',
808: Recinfo.ALLOW_CONTINUOUS_MOVE);
809: END IF;
810: --
811: IF ( (Recinfo.Carrier_Service_Id = p_Carrier_Service_Info.Carrier_Service_Id)

Line 973: WSH_DEBUG_SV.log(l_module_name,'All matched');

969: AND (p_Carrier_Service_Info.UPDATE_MOT_SL is NULL)))
970: THEN
971: --
972: IF l_debug_on THEN
973: WSH_DEBUG_SV.log(l_module_name,'All matched');
974: WSH_DEBUG_SV.pop(l_module_name);
975: END IF;
976: --
977: RETURN;

Line 974: WSH_DEBUG_SV.pop(l_module_name);

970: THEN
971: --
972: IF l_debug_on THEN
973: WSH_DEBUG_SV.log(l_module_name,'All matched');
974: WSH_DEBUG_SV.pop(l_module_name);
975: END IF;
976: --
977: RETURN;
978: ELSE

Line 981: WSH_DEBUG_SV.log(l_module_name,'FORM_RECORD_CHANGED');

977: RETURN;
978: ELSE
979: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
980: IF l_debug_on THEN
981: WSH_DEBUG_SV.log(l_module_name,'FORM_RECORD_CHANGED');
982: END IF;
983: APP_EXCEPTION.Raise_Exception;
984: END IF;
985:

Line 996: WSH_DEBUG_SV.log(l_module_name,'FORM_RECORD_DELETED');

992: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
993: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
994: --
995: IF l_debug_on THEN
996: WSH_DEBUG_SV.log(l_module_name,'FORM_RECORD_DELETED');
997: WSH_DEBUG_SV.pop(l_module_name);
998: END IF;
999: RETURN;
1000: END IF;

Line 997: WSH_DEBUG_SV.pop(l_module_name);

993: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
994: --
995: IF l_debug_on THEN
996: WSH_DEBUG_SV.log(l_module_name,'FORM_RECORD_DELETED');
997: WSH_DEBUG_SV.pop(l_module_name);
998: END IF;
999: RETURN;
1000: END IF;
1001: CLOSE C_lookup_row;

Line 1003: WSH_DEBUG_SV.log(l_module_name,'Before FND_LOOKUP_VALUES_PKG.LOCK_ROW');

999: RETURN;
1000: END IF;
1001: CLOSE C_lookup_row;
1002: IF l_debug_on THEN
1003: WSH_DEBUG_SV.log(l_module_name,'Before FND_LOOKUP_VALUES_PKG.LOCK_ROW');
1004: END IF;
1005:
1006: FND_LOOKUP_VALUES_PKG.LOCK_ROW(
1007: X_LOOKUP_TYPE => 'SHIP_METHOD',

Line 1037: WSH_DEBUG_SV.pop(l_module_name);

1033: X_DESCRIPTION => lookupinfo.DESCRIPTION);
1034:
1035:
1036: IF l_debug_on THEN
1037: WSH_DEBUG_SV.pop(l_module_name);
1038: END IF;
1039: --
1040: EXCEPTION
1041:

Line 1069: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

1065: x_Return_Status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1066: WSH_UTIL_CORE.Default_Handler('WSH_CARRIER_SERVICES_PKG.Lock_Carrier_Service',l_module_name);
1067: --
1068: IF l_debug_on THEN
1069: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1070: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1071: END IF;
1072: --
1073: END Lock_Carrier_Service;

Line 1070: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

1066: WSH_UTIL_CORE.Default_Handler('WSH_CARRIER_SERVICES_PKG.Lock_Carrier_Service',l_module_name);
1067: --
1068: IF l_debug_on THEN
1069: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1070: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1071: END IF;
1072: --
1073: END Lock_Carrier_Service;
1074:

Line 1144: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1140: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1141: --
1142: IF l_debug_on IS NULL
1143: THEN
1144: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1145: END IF;
1146: --
1147: IF l_debug_on THEN
1148: WSH_DEBUG_SV.push(l_module_name);

Line 1148: WSH_DEBUG_SV.push(l_module_name);

1144: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1145: END IF;
1146: --
1147: IF l_debug_on THEN
1148: WSH_DEBUG_SV.push(l_module_name);
1149: --
1150: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
1151: END IF;
1152: --

Line 1150: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);

1146: --
1147: IF l_debug_on THEN
1148: WSH_DEBUG_SV.push(l_module_name);
1149: --
1150: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
1151: END IF;
1152: --
1153: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1154:

Line 1223: WSH_DEBUG_SV.log(l_module_name,'SQL%NOTFOUND');

1219: WHERE rowid = p_rowid;
1220:
1221: IF (SQL%NOTFOUND) THEN
1222: IF l_debug_on THEN
1223: WSH_DEBUG_SV.log(l_module_name,'SQL%NOTFOUND');
1224: END IF;
1225: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1226: RAISE NO_DATA_FOUND;
1227: END IF;

Line 1241: WSH_DEBUG_SV.log(l_module_name,'C_lookup_row%NOTFOUND');

1237: CLOSE C_lookup_row;
1238: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
1239: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1240: IF l_debug_on THEN
1241: WSH_DEBUG_SV.log(l_module_name,'C_lookup_row%NOTFOUND');
1242: WSH_DEBUG_SV.log(l_module_name, 'Cursor opened successfully called from update_carrier_service procedure'); --Bug3330869
1243: END IF;
1244: RAISE NO_DATA_FOUND;
1245: END IF;

Line 1242: WSH_DEBUG_SV.log(l_module_name, 'Cursor opened successfully called from update_carrier_service procedure'); --Bug3330869

1238: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
1239: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1240: IF l_debug_on THEN
1241: WSH_DEBUG_SV.log(l_module_name,'C_lookup_row%NOTFOUND');
1242: WSH_DEBUG_SV.log(l_module_name, 'Cursor opened successfully called from update_carrier_service procedure'); --Bug3330869
1243: END IF;
1244: RAISE NO_DATA_FOUND;
1245: END IF;
1246:

Line 1327: WSH_DEBUG_SV.log(l_module_name,'LOOKUP_CODE',lookupinfo.LOOKUP_CODE);

1323: END IF;
1324: --
1325:
1326: IF l_debug_on THEN
1327: WSH_DEBUG_SV.log(l_module_name,'LOOKUP_CODE',lookupinfo.LOOKUP_CODE);
1328: WSH_DEBUG_SV.log(l_module_name,'TAG',lookupinfo.TAG);
1329: WSH_DEBUG_SV.log(l_module_name,'ATTRIBUTE_CATEGORY',
1330: lookupinfo.ATTRIBUTE_CATEGORY);
1331: WSH_DEBUG_SV.pop(l_module_name);

Line 1328: WSH_DEBUG_SV.log(l_module_name,'TAG',lookupinfo.TAG);

1324: --
1325:
1326: IF l_debug_on THEN
1327: WSH_DEBUG_SV.log(l_module_name,'LOOKUP_CODE',lookupinfo.LOOKUP_CODE);
1328: WSH_DEBUG_SV.log(l_module_name,'TAG',lookupinfo.TAG);
1329: WSH_DEBUG_SV.log(l_module_name,'ATTRIBUTE_CATEGORY',
1330: lookupinfo.ATTRIBUTE_CATEGORY);
1331: WSH_DEBUG_SV.pop(l_module_name);
1332: END IF;

Line 1329: WSH_DEBUG_SV.log(l_module_name,'ATTRIBUTE_CATEGORY',

1325:
1326: IF l_debug_on THEN
1327: WSH_DEBUG_SV.log(l_module_name,'LOOKUP_CODE',lookupinfo.LOOKUP_CODE);
1328: WSH_DEBUG_SV.log(l_module_name,'TAG',lookupinfo.TAG);
1329: WSH_DEBUG_SV.log(l_module_name,'ATTRIBUTE_CATEGORY',
1330: lookupinfo.ATTRIBUTE_CATEGORY);
1331: WSH_DEBUG_SV.pop(l_module_name);
1332: END IF;
1333: --

Line 1331: WSH_DEBUG_SV.pop(l_module_name);

1327: WSH_DEBUG_SV.log(l_module_name,'LOOKUP_CODE',lookupinfo.LOOKUP_CODE);
1328: WSH_DEBUG_SV.log(l_module_name,'TAG',lookupinfo.TAG);
1329: WSH_DEBUG_SV.log(l_module_name,'ATTRIBUTE_CATEGORY',
1330: lookupinfo.ATTRIBUTE_CATEGORY);
1331: WSH_DEBUG_SV.pop(l_module_name);
1332: END IF;
1333: --
1334: EXCEPTION
1335: WHEN NO_DATA_FOUND THEN

Line 1344: WSH_DEBUG_SV.logmsg(l_module_name,'NO_DATA_FOUND exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1340: x_sql_code := sqlcode;
1341: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1342: --
1343: IF l_debug_on THEN
1344: WSH_DEBUG_SV.logmsg(l_module_name,'NO_DATA_FOUND exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1345: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_DATA_FOUND');
1346: END IF;
1347: --
1348: WHEN OTHERS THEN

Line 1345: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_DATA_FOUND');

1341: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1342: --
1343: IF l_debug_on THEN
1344: WSH_DEBUG_SV.logmsg(l_module_name,'NO_DATA_FOUND exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1345: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_DATA_FOUND');
1346: END IF;
1347: --
1348: WHEN OTHERS THEN
1349: x_exception_msg := 'EXCEPTION : Others';

Line 1356: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

1352: x_sqlerr := sqlerrm;
1353: x_sql_code := sqlcode;
1354: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1355: IF l_debug_on THEN
1356: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1357: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1358: END IF;
1359: --
1360: END Update_Carrier_Service;

Line 1357: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

1353: x_sql_code := sqlcode;
1354: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1355: IF l_debug_on THEN
1356: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1357: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1358: END IF;
1359: --
1360: END Update_Carrier_Service;
1361:

Line 1377: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;

1373: ) IS
1374:
1375: l_position NUMBER;
1376: l_procedure VARCHAR2(50);
1377: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
1378: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'CAR_SER_UNASSIGN_ALLORG';
1379:
1380: BEGIN
1381: --

Line 1383: WSH_DEBUG_SV.push(l_module_name);

1379:
1380: BEGIN
1381: --
1382: IF l_debug_on THEN
1383: WSH_DEBUG_SV.push(l_module_name);
1384: WSH_DEBUG_SV.log(l_module_name,'P_CARRIER_SERVICE_ID',p_carrier_service_id);
1385: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_METHOD_CODE',p_ship_method_code);
1386: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_CODE',p_freight_code);
1387: END IF;

Line 1384: WSH_DEBUG_SV.log(l_module_name,'P_CARRIER_SERVICE_ID',p_carrier_service_id);

1380: BEGIN
1381: --
1382: IF l_debug_on THEN
1383: WSH_DEBUG_SV.push(l_module_name);
1384: WSH_DEBUG_SV.log(l_module_name,'P_CARRIER_SERVICE_ID',p_carrier_service_id);
1385: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_METHOD_CODE',p_ship_method_code);
1386: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_CODE',p_freight_code);
1387: END IF;
1388: --

Line 1385: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_METHOD_CODE',p_ship_method_code);

1381: --
1382: IF l_debug_on THEN
1383: WSH_DEBUG_SV.push(l_module_name);
1384: WSH_DEBUG_SV.log(l_module_name,'P_CARRIER_SERVICE_ID',p_carrier_service_id);
1385: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_METHOD_CODE',p_ship_method_code);
1386: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_CODE',p_freight_code);
1387: END IF;
1388: --
1389: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 1386: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_CODE',p_freight_code);

1382: IF l_debug_on THEN
1383: WSH_DEBUG_SV.push(l_module_name);
1384: WSH_DEBUG_SV.log(l_module_name,'P_CARRIER_SERVICE_ID',p_carrier_service_id);
1385: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_METHOD_CODE',p_ship_method_code);
1386: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_CODE',p_freight_code);
1387: END IF;
1388: --
1389: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1390:

Line 1408: WSH_DEBUG_SV.pop(l_module_name);

1404: WHERE carrier_service_id= p_carrier_service_id;
1405:
1406: --
1407: IF l_debug_on THEN
1408: WSH_DEBUG_SV.pop(l_module_name);
1409: END IF;
1410: --
1411: EXCEPTION
1412: WHEN OTHERS THEN

Line 1421: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

1417: x_sql_code := sqlcode;
1418: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1419: --
1420: IF l_debug_on THEN
1421: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1422: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1423: END IF;
1424:
1425: END Car_Ser_Unassign_AllOrg;

Line 1422: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

1418: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1419: --
1420: IF l_debug_on THEN
1421: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1422: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1423: END IF;
1424:
1425: END Car_Ser_Unassign_AllOrg;
1426: