eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_U_RASS dependencies on WSH_DEBUG_SV

Line 116: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

112: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
113: --
114: IF l_debug_on IS NULL
115: THEN
116: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
117: END IF;
118: --
119: IF l_debug_on THEN
120: WSH_DEBUG_SV.push(l_module_name);

Line 120: WSH_DEBUG_SV.push(l_module_name);

116: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
117: END IF;
118: --
119: IF l_debug_on THEN
120: WSH_DEBUG_SV.push(l_module_name);
121: --
122: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
123: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
124: WSH_DEBUG_SV.log(l_module_name,'P_APPVERSION',P_APPVERSION);

Line 122: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);

118: --
119: IF l_debug_on THEN
120: WSH_DEBUG_SV.push(l_module_name);
121: --
122: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
123: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
124: WSH_DEBUG_SV.log(l_module_name,'P_APPVERSION',P_APPVERSION);
125: WSH_DEBUG_SV.log(l_module_name,'P_ACCEPTLICENSEAGREEMENT',P_ACCEPTLICENSEAGREEMENT);
126: WSH_DEBUG_SV.log(l_module_name,'P_RESPONSETYPE',P_RESPONSETYPE);

Line 123: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);

119: IF l_debug_on THEN
120: WSH_DEBUG_SV.push(l_module_name);
121: --
122: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
123: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
124: WSH_DEBUG_SV.log(l_module_name,'P_APPVERSION',P_APPVERSION);
125: WSH_DEBUG_SV.log(l_module_name,'P_ACCEPTLICENSEAGREEMENT',P_ACCEPTLICENSEAGREEMENT);
126: WSH_DEBUG_SV.log(l_module_name,'P_RESPONSETYPE',P_RESPONSETYPE);
127: END IF;

Line 124: WSH_DEBUG_SV.log(l_module_name,'P_APPVERSION',P_APPVERSION);

120: WSH_DEBUG_SV.push(l_module_name);
121: --
122: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
123: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
124: WSH_DEBUG_SV.log(l_module_name,'P_APPVERSION',P_APPVERSION);
125: WSH_DEBUG_SV.log(l_module_name,'P_ACCEPTLICENSEAGREEMENT',P_ACCEPTLICENSEAGREEMENT);
126: WSH_DEBUG_SV.log(l_module_name,'P_RESPONSETYPE',P_RESPONSETYPE);
127: END IF;
128: --

Line 125: WSH_DEBUG_SV.log(l_module_name,'P_ACCEPTLICENSEAGREEMENT',P_ACCEPTLICENSEAGREEMENT);

121: --
122: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
123: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
124: WSH_DEBUG_SV.log(l_module_name,'P_APPVERSION',P_APPVERSION);
125: WSH_DEBUG_SV.log(l_module_name,'P_ACCEPTLICENSEAGREEMENT',P_ACCEPTLICENSEAGREEMENT);
126: WSH_DEBUG_SV.log(l_module_name,'P_RESPONSETYPE',P_RESPONSETYPE);
127: END IF;
128: --
129: l_output.delete;

Line 126: WSH_DEBUG_SV.log(l_module_name,'P_RESPONSETYPE',P_RESPONSETYPE);

122: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
123: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
124: WSH_DEBUG_SV.log(l_module_name,'P_APPVERSION',P_APPVERSION);
125: WSH_DEBUG_SV.log(l_module_name,'P_ACCEPTLICENSEAGREEMENT',P_ACCEPTLICENSEAGREEMENT);
126: WSH_DEBUG_SV.log(l_module_name,'P_RESPONSETYPE',P_RESPONSETYPE);
127: END IF;
128: --
129: l_output.delete;
130: -- Standard call to check for call compatibility.

Line 139: WSH_DEBUG_SV.log(l_module_name,'Not Compatible');

135: , G_PKG_NAME)
136: THEN
137: IF l_debug_on
138: THEN
139: WSH_DEBUG_SV.log(l_module_name,'Not Compatible');
140: END IF;
141: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
142: END IF;
143:

Line 167: WSH_DEBUG_SV.log(l_module_name,'Entity Called is '||l_rate_request_in.Entity);

163:
164: l_rate_request_in := p_request_in;
165:
166: IF l_debug_on THEN
167: WSH_DEBUG_SV.log(l_module_name,'Entity Called is '||l_rate_request_in.Entity);
168: WSH_DEBUG_SV.log(l_module_name,'EntityId is '||l_rate_request_in.Entity_Id);
169: END IF;
170:
171: wsh_custom_pub.rate_shipment_services

Line 168: WSH_DEBUG_SV.log(l_module_name,'EntityId is '||l_rate_request_in.Entity_Id);

164: l_rate_request_in := p_request_in;
165:
166: IF l_debug_on THEN
167: WSH_DEBUG_SV.log(l_module_name,'Entity Called is '||l_rate_request_in.Entity);
168: WSH_DEBUG_SV.log(l_module_name,'EntityId is '||l_rate_request_in.Entity_Id);
169: END IF;
170:
171: wsh_custom_pub.rate_shipment_services
172: ( p_request_in => l_rate_request_in

Line 180: WSH_DEBUG_SV.log(l_module_name,' Inside RETURN status :'||l_return_status);

176: , x_return_status => l_return_status);
177:
178: IF l_return_status = FND_API.G_RET_STS_SUCCESS
179: THEN
180: WSH_DEBUG_SV.log(l_module_name,' Inside RETURN status :'||l_return_status);
181: ELSE
182: WSH_DEBUG_SV.log(l_module_name,' Inside RETURN status :'||l_return_status);
183: x_return_status := l_return_status;
184: x_msg_data := l_msg_data;

Line 182: WSH_DEBUG_SV.log(l_module_name,' Inside RETURN status :'||l_return_status);

178: IF l_return_status = FND_API.G_RET_STS_SUCCESS
179: THEN
180: WSH_DEBUG_SV.log(l_module_name,' Inside RETURN status :'||l_return_status);
181: ELSE
182: WSH_DEBUG_SV.log(l_module_name,' Inside RETURN status :'||l_return_status);
183: x_return_status := l_return_status;
184: x_msg_data := l_msg_data;
185: RETURN l_output;
186: END IF;

Line 205: WSH_DEBUG_SV.log(l_module_name,'L_UPS_URL',SUBSTR(L_UPS_URL,1,250));

201: -- constructing the request sent to UPS API
202: L_INPUT_STR := L_UPS_URL || '?';
203:
204: IF l_debug_on THEN
205: WSH_DEBUG_SV.log(l_module_name,'L_UPS_URL',SUBSTR(L_UPS_URL,1,250));
206: END IF;
207: -- ---------------------------------------------------------------
208: -- UPS standard parameters: AppVersion
209: -- AcceptLicenseAgreement

Line 431: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,0,50));

427: DBMS_OUTPUT.PUT_LINE('INPUT:'||SUBSTR(L_INPUT_STR,651,50));
428: DBMS_OUTPUT.PUT_LINE('INPUT:'||SUBSTR(L_INPUT_STR,701,50));
429:
430: IF l_debug_on THEN
431: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,0,50));
432: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,51,50));
433: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,101,50));
434: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,151,50));
435: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,201,50));

Line 432: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,51,50));

428: DBMS_OUTPUT.PUT_LINE('INPUT:'||SUBSTR(L_INPUT_STR,701,50));
429:
430: IF l_debug_on THEN
431: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,0,50));
432: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,51,50));
433: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,101,50));
434: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,151,50));
435: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,201,50));
436: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,251,50));

Line 433: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,101,50));

429:
430: IF l_debug_on THEN
431: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,0,50));
432: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,51,50));
433: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,101,50));
434: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,151,50));
435: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,201,50));
436: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,251,50));
437: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,301,50));

Line 434: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,151,50));

430: IF l_debug_on THEN
431: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,0,50));
432: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,51,50));
433: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,101,50));
434: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,151,50));
435: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,201,50));
436: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,251,50));
437: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,301,50));
438: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,351,50));

Line 435: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,201,50));

431: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,0,50));
432: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,51,50));
433: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,101,50));
434: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,151,50));
435: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,201,50));
436: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,251,50));
437: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,301,50));
438: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,351,50));
439: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,401,50));

Line 436: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,251,50));

432: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,51,50));
433: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,101,50));
434: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,151,50));
435: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,201,50));
436: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,251,50));
437: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,301,50));
438: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,351,50));
439: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,401,50));
440: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,451,50));

Line 437: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,301,50));

433: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,101,50));
434: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,151,50));
435: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,201,50));
436: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,251,50));
437: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,301,50));
438: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,351,50));
439: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,401,50));
440: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,451,50));
441: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,501,50));

Line 438: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,351,50));

434: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,151,50));
435: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,201,50));
436: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,251,50));
437: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,301,50));
438: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,351,50));
439: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,401,50));
440: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,451,50));
441: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,501,50));
442: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,551,50));

Line 439: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,401,50));

435: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,201,50));
436: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,251,50));
437: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,301,50));
438: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,351,50));
439: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,401,50));
440: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,451,50));
441: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,501,50));
442: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,551,50));
443: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,601,50));

Line 440: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,451,50));

436: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,251,50));
437: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,301,50));
438: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,351,50));
439: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,401,50));
440: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,451,50));
441: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,501,50));
442: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,551,50));
443: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,601,50));
444: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,651,50));

Line 441: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,501,50));

437: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,301,50));
438: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,351,50));
439: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,401,50));
440: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,451,50));
441: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,501,50));
442: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,551,50));
443: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,601,50));
444: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,651,50));
445: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,701,50));

Line 442: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,551,50));

438: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,351,50));
439: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,401,50));
440: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,451,50));
441: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,501,50));
442: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,551,50));
443: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,601,50));
444: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,651,50));
445: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,701,50));
446: END IF;

Line 443: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,601,50));

439: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,401,50));
440: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,451,50));
441: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,501,50));
442: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,551,50));
443: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,601,50));
444: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,651,50));
445: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,701,50));
446: END IF;
447: -- clear variables before calling subroutine

Line 444: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,651,50));

440: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,451,50));
441: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,501,50));
442: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,551,50));
443: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,601,50));
444: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,651,50));
445: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,701,50));
446: END IF;
447: -- clear variables before calling subroutine
448: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 445: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,701,50));

441: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,501,50));
442: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,551,50));
443: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,601,50));
444: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,651,50));
445: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,701,50));
446: END IF;
447: -- clear variables before calling subroutine
448: l_return_status := FND_API.G_RET_STS_SUCCESS;
449: l_msg_count := 0;

Line 500: WSH_DEBUG_SV.log(l_module_name,'Boundary String',l_boundary_string);

496: end if;
497: l_boundary_string := '--' || l_boundary_string;
498: -- DBMS_OUTPUT.PUT_LINE('Boundary String:'|| l_boundary_string);
499: IF l_debug_on THEN
500: WSH_DEBUG_SV.log(l_module_name,'Boundary String',l_boundary_string);
501: END IF;
502:
503: LOOP
504: L_Locate_Boundry := INSTR(L_OUTPUT_STR, l_boundary_string,

Line 510: WSH_DEBUG_SV.log(l_module_name,'l_locate_str_len',l_locate_str_len);

506:
507: L_Locate_Str_Len := INSTR(L_OUTPUT_STR, 'Content-length',L_Locate_Boundry,1);
508: -- DBMS_OUTPUT.PUT_LINE('l_locate_str_len:' ||to_char( L_Locate_Str_Len));
509: IF l_debug_on THEN
510: WSH_DEBUG_SV.log(l_module_name,'l_locate_str_len',l_locate_str_len);
511: END IF;
512: L_Locate_Begin := INSTR(L_OUTPUT_STR, L_UPSONLINE ,L_Locate_Boundry,1);
513: L_Locate_Boundry_End := INSTR(L_OUTPUT_STR, l_boundary_string, L_Locate_Boundry,2);
514:

Line 518: WSH_DEBUG_SV.log(l_module_name,'J BEGIN',l_outrec_index);

514:
515: IF(L_Locate_Boundry_End > L_Locate_Begin) THEN
516:
517: IF l_debug_on THEN
518: WSH_DEBUG_SV.log(l_module_name,'J BEGIN',l_outrec_index);
519: END IF;
520: --DBMS_OUTPUT.PUT_LINE('J BEGIN:' || to_char(l_outrec_index));
521: l_outrec_index := l_outrec_index + 1;
522: --DBMS_OUTPUT.PUT_LINE('l_outrec_index END:' || to_char(l_outrec_index));

Line 524: WSH_DEBUG_SV.log(l_module_name,'l_outrec_index',l_outrec_index);

520: --DBMS_OUTPUT.PUT_LINE('J BEGIN:' || to_char(l_outrec_index));
521: l_outrec_index := l_outrec_index + 1;
522: --DBMS_OUTPUT.PUT_LINE('l_outrec_index END:' || to_char(l_outrec_index));
523: IF l_debug_on THEN
524: WSH_DEBUG_SV.log(l_module_name,'l_outrec_index',l_outrec_index);
525: END IF;
526:
527: L_Locate_Str_Len_End := INSTR(L_OUTPUT_STR, FND_GLOBAL.LOCAL_CHR(13), L_Locate_Str_Len, 1);
528: -- DBMS_OUTPUT.PUT_LINE('l_locate_str_len_end:' ||to_char( L_Locate_Str_Len_end));

Line 530: WSH_DEBUG_SV.log(l_module_name,'l_locate_str_len_end',l_locate_str_len_end);

526:
527: L_Locate_Str_Len_End := INSTR(L_OUTPUT_STR, FND_GLOBAL.LOCAL_CHR(13), L_Locate_Str_Len, 1);
528: -- DBMS_OUTPUT.PUT_LINE('l_locate_str_len_end:' ||to_char( L_Locate_Str_Len_end));
529: IF l_debug_on THEN
530: WSH_DEBUG_SV.log(l_module_name,'l_locate_str_len_end',l_locate_str_len_end);
531: END IF;
532: L_Content_Str_Len := TO_NUMBER(SUBSTR(L_OUTPUT_STR,(L_Locate_Str_Len+16),L_Locate_Str_Len_End - L_Locate_Str_Len - 16));
533:
534: -- DBMS_OUTPUT.PUT_LINE('string length:' || to_char(L_Content_Str_Len));

Line 536: WSH_DEBUG_SV.log(l_module_name,'L_Content_Str_Len',L_Content_Str_Len);

532: L_Content_Str_Len := TO_NUMBER(SUBSTR(L_OUTPUT_STR,(L_Locate_Str_Len+16),L_Locate_Str_Len_End - L_Locate_Str_Len - 16));
533:
534: -- DBMS_OUTPUT.PUT_LINE('string length:' || to_char(L_Content_Str_Len));
535: IF l_debug_on THEN
536: WSH_DEBUG_SV.log(l_module_name,'L_Content_Str_Len',L_Content_Str_Len);
537: END IF;
538:
539: L_Rate_Message := SUBSTR(L_OUTPUT_STR, L_Locate_Begin, L_Content_Str_Len);
540: L_Token_Start := 0;

Line 608: WSH_DEBUG_SV.pop(l_module_name);

604: FND_MSG_PUB.count_and_get ( p_count => x_msg_count, p_data => x_msg_data);
605: */ -- Commented for Carrier Services Integration with Shipping project Bug 16095594
606: --
607: IF l_debug_on THEN
608: WSH_DEBUG_SV.pop(l_module_name);
609: END IF;
610: --
611: RETURN L_OUTPUT;
612:

Line 639: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_U_DELDETID exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

635: -- Debug Statements
636: --
637: IF l_debug_on
638: THEN
639: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_U_DELDETID exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
640: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_U_DELDETID');
641: END IF;
642: RETURN l_output;
643: /* Commented for Carrier Services Integration with Shipping project Bug 16095594

Line 640: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_U_DELDETID');

636: --
637: IF l_debug_on
638: THEN
639: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_U_DELDETID exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
640: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_U_DELDETID');
641: END IF;
642: RETURN l_output;
643: /* Commented for Carrier Services Integration with Shipping project Bug 16095594
644: WHEN WSH_U_CAR_URL THEN

Line 656: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_U_CAR_URL exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

652: x_msg_data := l_msg_summary;
653: end if;
654: --
655: IF l_debug_on THEN
656: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_U_CAR_URL exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
657: WSH_DEBUG_SV.log(l_module_name,'x_msg_data',SUBSTR(x_msg_data,1,200));
658: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_U_CAR_URL');
659: END IF;
660: --

Line 657: WSH_DEBUG_SV.log(l_module_name,'x_msg_data',SUBSTR(x_msg_data,1,200));

653: end if;
654: --
655: IF l_debug_on THEN
656: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_U_CAR_URL exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
657: WSH_DEBUG_SV.log(l_module_name,'x_msg_data',SUBSTR(x_msg_data,1,200));
658: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_U_CAR_URL');
659: END IF;
660: --
661: return L_OUTPUT;

Line 658: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_U_CAR_URL');

654: --
655: IF l_debug_on THEN
656: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_U_CAR_URL exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
657: WSH_DEBUG_SV.log(l_module_name,'x_msg_data',SUBSTR(x_msg_data,1,200));
658: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_U_CAR_URL');
659: END IF;
660: --
661: return L_OUTPUT;
662: WHEN WSH_U_PROXY THEN

Line 674: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_U_PROXY exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

670: x_msg_data := l_msg_summary;
671: end if;
672: --
673: IF l_debug_on THEN
674: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_U_PROXY exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
675: WSH_DEBUG_SV.log(l_module_name,'x_msg_data',SUBSTR(x_msg_data,1,200));
676: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_U_PROXY');
677: END IF;
678: --

Line 675: WSH_DEBUG_SV.log(l_module_name,'x_msg_data',SUBSTR(x_msg_data,1,200));

671: end if;
672: --
673: IF l_debug_on THEN
674: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_U_PROXY exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
675: WSH_DEBUG_SV.log(l_module_name,'x_msg_data',SUBSTR(x_msg_data,1,200));
676: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_U_PROXY');
677: END IF;
678: --
679: return L_OUTPUT;

Line 676: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_U_PROXY');

672: --
673: IF l_debug_on THEN
674: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_U_PROXY exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
675: WSH_DEBUG_SV.log(l_module_name,'x_msg_data',SUBSTR(x_msg_data,1,200));
676: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_U_PROXY');
677: END IF;
678: --
679: return L_OUTPUT;
680:

Line 697: WSH_DEBUG_SV.log(l_module_name,'x_msg_data',SUBSTR(x_msg_data,1,200));

693: x_msg_data := l_msg_summary;
694: end if;
695: --
696: IF l_debug_on THEN
697: WSH_DEBUG_SV.log(l_module_name,'x_msg_data',SUBSTR(x_msg_data,1,200));
698: WSH_DEBUG_SV.logmsg(l_module_name,'REQUEST_FAILED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
699: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:REQUEST_FAILED');
700: END IF;
701: --

Line 698: WSH_DEBUG_SV.logmsg(l_module_name,'REQUEST_FAILED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

694: end if;
695: --
696: IF l_debug_on THEN
697: WSH_DEBUG_SV.log(l_module_name,'x_msg_data',SUBSTR(x_msg_data,1,200));
698: WSH_DEBUG_SV.logmsg(l_module_name,'REQUEST_FAILED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
699: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:REQUEST_FAILED');
700: END IF;
701: --
702: return L_OUTPUT;

Line 699: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:REQUEST_FAILED');

695: --
696: IF l_debug_on THEN
697: WSH_DEBUG_SV.log(l_module_name,'x_msg_data',SUBSTR(x_msg_data,1,200));
698: WSH_DEBUG_SV.logmsg(l_module_name,'REQUEST_FAILED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
699: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:REQUEST_FAILED');
700: END IF;
701: --
702: return L_OUTPUT;
703:

Line 719: WSH_DEBUG_SV.log(l_module_name,'x_msg_data',SUBSTR(x_msg_data,1,200));

715: x_msg_data := l_msg_summary;
716: end if;
717: --
718: IF l_debug_on THEN
719: WSH_DEBUG_SV.log(l_module_name,'x_msg_data',SUBSTR(x_msg_data,1,200));
720: WSH_DEBUG_SV.logmsg(l_module_name,'INIT_FAILED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
721: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:INIT_FAILED');
722: END IF;
723: --

Line 720: WSH_DEBUG_SV.logmsg(l_module_name,'INIT_FAILED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

716: end if;
717: --
718: IF l_debug_on THEN
719: WSH_DEBUG_SV.log(l_module_name,'x_msg_data',SUBSTR(x_msg_data,1,200));
720: WSH_DEBUG_SV.logmsg(l_module_name,'INIT_FAILED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
721: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:INIT_FAILED');
722: END IF;
723: --
724: return L_OUTPUT;

Line 721: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:INIT_FAILED');

717: --
718: IF l_debug_on THEN
719: WSH_DEBUG_SV.log(l_module_name,'x_msg_data',SUBSTR(x_msg_data,1,200));
720: WSH_DEBUG_SV.logmsg(l_module_name,'INIT_FAILED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
721: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:INIT_FAILED');
722: END IF;
723: --
724: return L_OUTPUT;
725: WHEN WSH_U_NO_HOST THEN

Line 737: WSH_DEBUG_SV.log(l_module_name,'x_msg_data',SUBSTR(x_msg_data,1,200));

733: x_msg_data := l_msg_summary;
734: end if;
735: --
736: IF l_debug_on THEN
737: WSH_DEBUG_SV.log(l_module_name,'x_msg_data',SUBSTR(x_msg_data,1,200));
738: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_U_NO_HOST exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
739: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_U_NO_HOST');
740: END IF;
741: --

Line 738: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_U_NO_HOST exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

734: end if;
735: --
736: IF l_debug_on THEN
737: WSH_DEBUG_SV.log(l_module_name,'x_msg_data',SUBSTR(x_msg_data,1,200));
738: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_U_NO_HOST exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
739: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_U_NO_HOST');
740: END IF;
741: --
742: return L_OUTPUT;

Line 739: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_U_NO_HOST');

735: --
736: IF l_debug_on THEN
737: WSH_DEBUG_SV.log(l_module_name,'x_msg_data',SUBSTR(x_msg_data,1,200));
738: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_U_NO_HOST exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
739: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_U_NO_HOST');
740: END IF;
741: --
742: return L_OUTPUT;
743: WHEN WSH_U_APPVER THEN

Line 755: WSH_DEBUG_SV.log(l_module_name,'x_msg_data',SUBSTR(x_msg_data,1,200));

751: x_msg_data := l_msg_summary;
752: end if;
753: --
754: IF l_debug_on THEN
755: WSH_DEBUG_SV.log(l_module_name,'x_msg_data',SUBSTR(x_msg_data,1,200));
756: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_U_APPVER exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
757: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_U_APPVER');
758: END IF;
759: --

Line 756: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_U_APPVER exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

752: end if;
753: --
754: IF l_debug_on THEN
755: WSH_DEBUG_SV.log(l_module_name,'x_msg_data',SUBSTR(x_msg_data,1,200));
756: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_U_APPVER exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
757: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_U_APPVER');
758: END IF;
759: --
760: return L_OUTPUT;

Line 757: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_U_APPVER');

753: --
754: IF l_debug_on THEN
755: WSH_DEBUG_SV.log(l_module_name,'x_msg_data',SUBSTR(x_msg_data,1,200));
756: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_U_APPVER exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
757: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_U_APPVER');
758: END IF;
759: --
760: return L_OUTPUT;
761: WHEN WSH_U_LICAGRE THEN

Line 773: WSH_DEBUG_SV.log(l_module_name,'x_msg_data',SUBSTR(x_msg_data,1,200));

769: x_msg_data := l_msg_summary;
770: end if;
771: --
772: IF l_debug_on THEN
773: WSH_DEBUG_SV.log(l_module_name,'x_msg_data',SUBSTR(x_msg_data,1,200));
774: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_U_LICAGRE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
775: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_U_LICAGRE');
776: END IF;
777: --

Line 774: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_U_LICAGRE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

770: end if;
771: --
772: IF l_debug_on THEN
773: WSH_DEBUG_SV.log(l_module_name,'x_msg_data',SUBSTR(x_msg_data,1,200));
774: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_U_LICAGRE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
775: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_U_LICAGRE');
776: END IF;
777: --
778: return L_OUTPUT;

Line 775: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_U_LICAGRE');

771: --
772: IF l_debug_on THEN
773: WSH_DEBUG_SV.log(l_module_name,'x_msg_data',SUBSTR(x_msg_data,1,200));
774: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_U_LICAGRE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
775: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_U_LICAGRE');
776: END IF;
777: --
778: return L_OUTPUT;
779: WHEN WSH_U_RESTYP THEN

Line 791: WSH_DEBUG_SV.log(l_module_name,'x_msg_data',SUBSTR(x_msg_data,1,200));

787: x_msg_data := l_msg_summary;
788: end if;
789: --
790: IF l_debug_on THEN
791: WSH_DEBUG_SV.log(l_module_name,'x_msg_data',SUBSTR(x_msg_data,1,200));
792: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_U_RESTYP exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
793: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_U_RESTYP');
794: END IF;
795: --

Line 792: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_U_RESTYP exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

788: end if;
789: --
790: IF l_debug_on THEN
791: WSH_DEBUG_SV.log(l_module_name,'x_msg_data',SUBSTR(x_msg_data,1,200));
792: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_U_RESTYP exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
793: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_U_RESTYP');
794: END IF;
795: --
796: return L_OUTPUT;

Line 793: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_U_RESTYP');

789: --
790: IF l_debug_on THEN
791: WSH_DEBUG_SV.log(l_module_name,'x_msg_data',SUBSTR(x_msg_data,1,200));
792: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_U_RESTYP exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
793: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_U_RESTYP');
794: END IF;
795: --
796: return L_OUTPUT;
797: WHEN WSH_U_ACTIONCODE THEN

Line 809: WSH_DEBUG_SV.log(l_module_name,'x_msg_data',SUBSTR(x_msg_data,1,200));

805: x_msg_data := l_msg_summary;
806: end if;
807: --
808: IF l_debug_on THEN
809: WSH_DEBUG_SV.log(l_module_name,'x_msg_data',SUBSTR(x_msg_data,1,200));
810: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_U_ACTIONCODE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
811: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_U_ACTIONCODE');
812: END IF;
813: --

Line 810: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_U_ACTIONCODE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

806: end if;
807: --
808: IF l_debug_on THEN
809: WSH_DEBUG_SV.log(l_module_name,'x_msg_data',SUBSTR(x_msg_data,1,200));
810: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_U_ACTIONCODE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
811: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_U_ACTIONCODE');
812: END IF;
813: --
814: return L_OUTPUT;

Line 811: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_U_ACTIONCODE');

807: --
808: IF l_debug_on THEN
809: WSH_DEBUG_SV.log(l_module_name,'x_msg_data',SUBSTR(x_msg_data,1,200));
810: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_U_ACTIONCODE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
811: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_U_ACTIONCODE');
812: END IF;
813: --
814: return L_OUTPUT;
815: WHEN WSH_U_SRVLEVCODE THEN

Line 827: WSH_DEBUG_SV.log(l_module_name,'x_msg_data',SUBSTR(x_msg_data,1,200));

823: x_msg_data := l_msg_summary;
824: end if;
825: --
826: IF l_debug_on THEN
827: WSH_DEBUG_SV.log(l_module_name,'x_msg_data',SUBSTR(x_msg_data,1,200));
828: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_U_SRVLEVCODE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
829: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_U_SRVLEVCODE');
830: END IF;
831: --

Line 828: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_U_SRVLEVCODE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

824: end if;
825: --
826: IF l_debug_on THEN
827: WSH_DEBUG_SV.log(l_module_name,'x_msg_data',SUBSTR(x_msg_data,1,200));
828: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_U_SRVLEVCODE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
829: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_U_SRVLEVCODE');
830: END IF;
831: --
832: return L_OUTPUT;

Line 829: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_U_SRVLEVCODE');

825: --
826: IF l_debug_on THEN
827: WSH_DEBUG_SV.log(l_module_name,'x_msg_data',SUBSTR(x_msg_data,1,200));
828: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_U_SRVLEVCODE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
829: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_U_SRVLEVCODE');
830: END IF;
831: --
832: return L_OUTPUT;
833: WHEN WSH_U_RATECHART THEN

Line 845: WSH_DEBUG_SV.log(l_module_name,'x_msg_data',SUBSTR(x_msg_data,1,200));

841: x_msg_data := l_msg_summary;
842: end if;
843: --
844: IF l_debug_on THEN
845: WSH_DEBUG_SV.log(l_module_name,'x_msg_data',SUBSTR(x_msg_data,1,200));
846: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_U_RATECHART exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
847: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_U_RATECHART');
848: END IF;
849: --

Line 846: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_U_RATECHART exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

842: end if;
843: --
844: IF l_debug_on THEN
845: WSH_DEBUG_SV.log(l_module_name,'x_msg_data',SUBSTR(x_msg_data,1,200));
846: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_U_RATECHART exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
847: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_U_RATECHART');
848: END IF;
849: --
850: return L_OUTPUT;

Line 847: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_U_RATECHART');

843: --
844: IF l_debug_on THEN
845: WSH_DEBUG_SV.log(l_module_name,'x_msg_data',SUBSTR(x_msg_data,1,200));
846: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_U_RATECHART exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
847: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_U_RATECHART');
848: END IF;
849: --
850: return L_OUTPUT;
851: WHEN WSH_U_SPOSTALCODE THEN

Line 863: WSH_DEBUG_SV.log(l_module_name,'x_msg_data',SUBSTR(x_msg_data,1,200));

859: x_msg_data := l_msg_summary;
860: end if;
861: --
862: IF l_debug_on THEN
863: WSH_DEBUG_SV.log(l_module_name,'x_msg_data',SUBSTR(x_msg_data,1,200));
864: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_U_SPOSTALCODE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
865: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_U_SPOSTALCODE');
866: END IF;
867: --

Line 864: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_U_SPOSTALCODE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

860: end if;
861: --
862: IF l_debug_on THEN
863: WSH_DEBUG_SV.log(l_module_name,'x_msg_data',SUBSTR(x_msg_data,1,200));
864: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_U_SPOSTALCODE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
865: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_U_SPOSTALCODE');
866: END IF;
867: --
868: return L_OUTPUT;

Line 865: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_U_SPOSTALCODE');

861: --
862: IF l_debug_on THEN
863: WSH_DEBUG_SV.log(l_module_name,'x_msg_data',SUBSTR(x_msg_data,1,200));
864: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_U_SPOSTALCODE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
865: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_U_SPOSTALCODE');
866: END IF;
867: --
868: return L_OUTPUT;
869: WHEN WSH_U_CPOSTALCODE THEN

Line 881: WSH_DEBUG_SV.log(l_module_name,'x_msg_data',SUBSTR(x_msg_data,1,200));

877: x_msg_data := l_msg_summary;
878: end if;
879: --
880: IF l_debug_on THEN
881: WSH_DEBUG_SV.log(l_module_name,'x_msg_data',SUBSTR(x_msg_data,1,200));
882: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_U_CPOSTALCODE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
883: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_U_CPOSTALCODE');
884: END IF;
885: --

Line 882: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_U_CPOSTALCODE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

878: end if;
879: --
880: IF l_debug_on THEN
881: WSH_DEBUG_SV.log(l_module_name,'x_msg_data',SUBSTR(x_msg_data,1,200));
882: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_U_CPOSTALCODE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
883: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_U_CPOSTALCODE');
884: END IF;
885: --
886: return L_OUTPUT;

Line 883: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_U_CPOSTALCODE');

879: --
880: IF l_debug_on THEN
881: WSH_DEBUG_SV.log(l_module_name,'x_msg_data',SUBSTR(x_msg_data,1,200));
882: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_U_CPOSTALCODE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
883: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_U_CPOSTALCODE');
884: END IF;
885: --
886: return L_OUTPUT;
887: WHEN WSH_U_CCOUNTRY THEN

Line 899: WSH_DEBUG_SV.log(l_module_name,'x_msg_data',SUBSTR(x_msg_data,1,200));

895: x_msg_data := l_msg_summary;
896: end if;
897: --
898: IF l_debug_on THEN
899: WSH_DEBUG_SV.log(l_module_name,'x_msg_data',SUBSTR(x_msg_data,1,200));
900: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_U_CCOUNTRY exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
901: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_U_CCOUNTRY');
902: END IF;
903: --

Line 900: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_U_CCOUNTRY exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

896: end if;
897: --
898: IF l_debug_on THEN
899: WSH_DEBUG_SV.log(l_module_name,'x_msg_data',SUBSTR(x_msg_data,1,200));
900: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_U_CCOUNTRY exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
901: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_U_CCOUNTRY');
902: END IF;
903: --
904: return L_OUTPUT;

Line 901: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_U_CCOUNTRY');

897: --
898: IF l_debug_on THEN
899: WSH_DEBUG_SV.log(l_module_name,'x_msg_data',SUBSTR(x_msg_data,1,200));
900: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_U_CCOUNTRY exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
901: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_U_CCOUNTRY');
902: END IF;
903: --
904: return L_OUTPUT;
905: WHEN WSH_U_PKGACTWT THEN

Line 917: WSH_DEBUG_SV.log(l_module_name,'x_msg_data',SUBSTR(x_msg_data,1,200));

913: x_msg_data := l_msg_summary;
914: end if;
915: --
916: IF l_debug_on THEN
917: WSH_DEBUG_SV.log(l_module_name,'x_msg_data',SUBSTR(x_msg_data,1,200));
918: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_U_PKGACTWT exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
919: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_U_PKGACTWT');
920: END IF;
921: --

Line 918: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_U_PKGACTWT exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

914: end if;
915: --
916: IF l_debug_on THEN
917: WSH_DEBUG_SV.log(l_module_name,'x_msg_data',SUBSTR(x_msg_data,1,200));
918: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_U_PKGACTWT exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
919: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_U_PKGACTWT');
920: END IF;
921: --
922: return L_OUTPUT;

Line 919: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_U_PKGACTWT');

915: --
916: IF l_debug_on THEN
917: WSH_DEBUG_SV.log(l_module_name,'x_msg_data',SUBSTR(x_msg_data,1,200));
918: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_U_PKGACTWT exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
919: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_U_PKGACTWT');
920: END IF;
921: --
922: return L_OUTPUT;
923: WHEN WSH_U_RESDIND THEN

Line 935: WSH_DEBUG_SV.log(l_module_name,'x_msg_data',SUBSTR(x_msg_data,1,200));

931: x_msg_data := l_msg_summary;
932: end if;
933: --
934: IF l_debug_on THEN
935: WSH_DEBUG_SV.log(l_module_name,'x_msg_data',SUBSTR(x_msg_data,1,200));
936: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_U_RESDIND exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
937: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_U_RESDIND');
938: END IF;
939: --

Line 936: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_U_RESDIND exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

932: end if;
933: --
934: IF l_debug_on THEN
935: WSH_DEBUG_SV.log(l_module_name,'x_msg_data',SUBSTR(x_msg_data,1,200));
936: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_U_RESDIND exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
937: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_U_RESDIND');
938: END IF;
939: --
940: return L_OUTPUT;

Line 937: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_U_RESDIND');

933: --
934: IF l_debug_on THEN
935: WSH_DEBUG_SV.log(l_module_name,'x_msg_data',SUBSTR(x_msg_data,1,200));
936: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_U_RESDIND exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
937: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_U_RESDIND');
938: END IF;
939: --
940: return L_OUTPUT;
941: WHEN WSH_U_PKGTYPE THEN

Line 953: WSH_DEBUG_SV.log(l_module_name,'x_msg_data',SUBSTR(x_msg_data,1,200));

949: x_msg_data := l_msg_summary;
950: end if;
951: --
952: IF l_debug_on THEN
953: WSH_DEBUG_SV.log(l_module_name,'x_msg_data',SUBSTR(x_msg_data,1,200));
954: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_U_PKGTYPE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
955: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_U_PKGTYPE');
956: END IF;
957: --

Line 954: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_U_PKGTYPE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

950: end if;
951: --
952: IF l_debug_on THEN
953: WSH_DEBUG_SV.log(l_module_name,'x_msg_data',SUBSTR(x_msg_data,1,200));
954: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_U_PKGTYPE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
955: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_U_PKGTYPE');
956: END IF;
957: --
958: return L_OUTPUT;

Line 955: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_U_PKGTYPE');

951: --
952: IF l_debug_on THEN
953: WSH_DEBUG_SV.log(l_module_name,'x_msg_data',SUBSTR(x_msg_data,1,200));
954: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_U_PKGTYPE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
955: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_U_PKGTYPE');
956: END IF;
957: --
958: return L_OUTPUT;
959: -- Bug 2993856 :Handling the exception WSH_U_HOST_FAILED

Line 972: WSH_DEBUG_SV.log(l_module_name,'x_msg_data',SUBSTR(x_msg_data,1,200));

968: x_msg_data := SUBSTR(x_msg_data,INSTR(x_msg_data,':') + 2);
969:
970: --
971: IF l_debug_on THEN
972: WSH_DEBUG_SV.log(l_module_name,'x_msg_data',SUBSTR(x_msg_data,1,200));
973: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_U_HOST_FAILED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
974: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_U_HOST_FAILED');
975: END IF;
976: --

Line 973: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_U_HOST_FAILED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

969:
970: --
971: IF l_debug_on THEN
972: WSH_DEBUG_SV.log(l_module_name,'x_msg_data',SUBSTR(x_msg_data,1,200));
973: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_U_HOST_FAILED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
974: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_U_HOST_FAILED');
975: END IF;
976: --
977: return L_OUTPUT;

Line 974: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_U_HOST_FAILED');

970: --
971: IF l_debug_on THEN
972: WSH_DEBUG_SV.log(l_module_name,'x_msg_data',SUBSTR(x_msg_data,1,200));
973: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_U_HOST_FAILED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
974: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_U_HOST_FAILED');
975: END IF;
976: --
977: return L_OUTPUT;
978: End of Comment for Carrier Services Integration with Shipping project Bug 16095594 */

Line 994: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

990: , p_data => x_msg_data);
991: --
992: IF l_debug_on
993: THEN
994: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
995: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
996: END IF;
997: --
998: RETURN L_OUTPUT;

Line 995: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

991: --
992: IF l_debug_on
993: THEN
994: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
995: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
996: END IF;
997: --
998: RETURN L_OUTPUT;
999: WHEN OTHERS

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

1011: , p_data => x_msg_data);
1012: --
1013: IF l_debug_on
1014: THEN
1015: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1016: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1017: END IF;
1018: --
1019: RETURN L_OUTPUT;

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

1012: --
1013: IF l_debug_on
1014: THEN
1015: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1016: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1017: END IF;
1018: --
1019: RETURN L_OUTPUT;
1020: END FindServiceRate;

Line 1077: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1073: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1074: --
1075: IF l_debug_on IS NULL
1076: THEN
1077: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1078: END IF;
1079: --
1080: IF l_debug_on
1081: THEN

Line 1082: WSH_DEBUG_SV.push(l_module_name);

1078: END IF;
1079: --
1080: IF l_debug_on
1081: THEN
1082: WSH_DEBUG_SV.push(l_module_name);
1083: --
1084: WSH_DEBUG_SV.log(l_module_name,'P_SELECT_STATEMENT',P_SELECT_STATEMENT);
1085: END IF;
1086: --

Line 1084: WSH_DEBUG_SV.log(l_module_name,'P_SELECT_STATEMENT',P_SELECT_STATEMENT);

1080: IF l_debug_on
1081: THEN
1082: WSH_DEBUG_SV.push(l_module_name);
1083: --
1084: WSH_DEBUG_SV.log(l_module_name,'P_SELECT_STATEMENT',P_SELECT_STATEMENT);
1085: END IF;
1086: --
1087: l_cursorid := DBMS_SQL.OPEN_CURSOR;
1088: l_SelectStmt := p_select_statement;

Line 1106: WSH_DEBUG_SV.log(l_module_name,'l_ship_from_location_id',l_ship_from_location_id);

1102: x_headers(l_index).ship_from_location_id := l_ship_from_location_id;
1103: x_headers(l_index).ship_to_location_id := l_ship_to_location_id;
1104: IF l_debug_on
1105: THEN
1106: WSH_DEBUG_SV.log(l_module_name,'l_ship_from_location_id',l_ship_from_location_id);
1107: WSH_DEBUG_SV.log(l_module_name,'l_ship_to_location_id',l_ship_to_location_id);
1108: END IF;
1109: END LOOP;
1110: --

Line 1107: WSH_DEBUG_SV.log(l_module_name,'l_ship_to_location_id',l_ship_to_location_id);

1103: x_headers(l_index).ship_to_location_id := l_ship_to_location_id;
1104: IF l_debug_on
1105: THEN
1106: WSH_DEBUG_SV.log(l_module_name,'l_ship_from_location_id',l_ship_from_location_id);
1107: WSH_DEBUG_SV.log(l_module_name,'l_ship_to_location_id',l_ship_to_location_id);
1108: END IF;
1109: END LOOP;
1110: --
1111: IF l_debug_on

Line 1113: WSH_DEBUG_SV.pop(l_module_name);

1109: END LOOP;
1110: --
1111: IF l_debug_on
1112: THEN
1113: WSH_DEBUG_SV.pop(l_module_name);
1114: END IF;
1115: --
1116: END load_headers;
1117: