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_ORG_CARRIER_SERVICES_PKG dependencies on WSH_DEBUG_SV

Line 100: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

96: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
97: --
98: IF l_debug_on IS NULL
99: THEN
100: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
101: END IF;
102: --
103: IF l_debug_on THEN
104: WSH_DEBUG_SV.push(l_module_name);

Line 104: WSH_DEBUG_SV.push(l_module_name);

100: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
101: END IF;
102: --
103: IF l_debug_on THEN
104: WSH_DEBUG_SV.push(l_module_name);
105: --
106: WSH_DEBUG_SV.log(l_module_name,'X_ROWID',X_ROWID);
107: WSH_DEBUG_SV.log(l_module_name,'X_ORG_CARRIER_SERVICE_ID',X_ORG_CARRIER_SERVICE_ID);
108: END IF;

Line 106: WSH_DEBUG_SV.log(l_module_name,'X_ROWID',X_ROWID);

102: --
103: IF l_debug_on THEN
104: WSH_DEBUG_SV.push(l_module_name);
105: --
106: WSH_DEBUG_SV.log(l_module_name,'X_ROWID',X_ROWID);
107: WSH_DEBUG_SV.log(l_module_name,'X_ORG_CARRIER_SERVICE_ID',X_ORG_CARRIER_SERVICE_ID);
108: END IF;
109: --
110: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 107: WSH_DEBUG_SV.log(l_module_name,'X_ORG_CARRIER_SERVICE_ID',X_ORG_CARRIER_SERVICE_ID);

103: IF l_debug_on THEN
104: WSH_DEBUG_SV.push(l_module_name);
105: --
106: WSH_DEBUG_SV.log(l_module_name,'X_ROWID',X_ROWID);
107: WSH_DEBUG_SV.log(l_module_name,'X_ORG_CARRIER_SERVICE_ID',X_ORG_CARRIER_SERVICE_ID);
108: END IF;
109: --
110: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
111:

Line 128: WSH_DEBUG_SV.logmsg(l_module_name,'Inserting into WSH_ORG_CARRIER_SERVICES',WSH_DEBUG_SV.C_PROC_LEVEL);

124: l_procedure := 'Inserting into Wsh_org_carrier_services';
125:
126: --
127: IF l_debug_on THEN
128: WSH_DEBUG_SV.logmsg(l_module_name,'Inserting into WSH_ORG_CARRIER_SERVICES',WSH_DEBUG_SV.C_PROC_LEVEL);
129: END IF;
130: --
131:
132: INSERT INTO wsh_org_Carrier_Services

Line 186: WSH_DEBUG_SV.log(l_module_name,'Rows inserted',SQL%ROWCOUNT);

182: fnd_global.user_id,
183: fnd_global.login_id);
184:
185: IF l_debug_on THEN
186: WSH_DEBUG_SV.log(l_module_name,'Rows inserted',SQL%ROWCOUNT);
187: END IF;
188: OPEN C_New_Rowid(l_org_carrier_service_id);
189: FETCH C_New_Rowid INTO l_rowid;
190: IF (C_New_Rowid%NOTFOUND) THEN

Line 199: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit ORG_FREIGHT_TL_PKG.INSERT_ROW',WSH_DEBUG_SV.C_PROC_LEVEL);

195: l_position := 20;
196: l_procedure := 'Inserting into ORG_FREIGHT_TL';
197: --
198: IF l_debug_on THEN
199: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit ORG_FREIGHT_TL_PKG.INSERT_ROW',WSH_DEBUG_SV.C_PROC_LEVEL);
200: END IF;
201: --
202: ORG_FREIGHT_TL_PKG.INSERT_ROW(
203: X_ROWID => l_oft_rowid,

Line 260: WSH_DEBUG_SV.logmsg(l_module_name,'Updating ORG_FREIGHT_TL',WSH_DEBUG_SV.C_PROC_LEVEL);

256: l_procedure := 'Updating Org_Freight_TL';
257:
258: --
259: IF l_debug_on THEN
260: WSH_DEBUG_SV.logmsg(l_module_name,'Updating ORG_FREIGHT_TL',WSH_DEBUG_SV.C_PROC_LEVEL);
261: END IF;
262: --
263:
264: UPDATE ORG_FREIGHT_TL

Line 270: WSH_DEBUG_SV.log(l_module_name,'Rows updated',SQL%ROWCOUNT);

266: disable_date = l_disable_date
267: WHERE freight_code = p_carrier_info.p_freight_code
268: and organization_id = p_org_carrier_service_info.organization_id;
269: IF l_debug_on THEN
270: WSH_DEBUG_SV.log(l_module_name,'Rows updated',SQL%ROWCOUNT);
271: END IF;
272: IF SQL%NOTFOUND THEN
273: RAISE NO_DATA_FOUND;
274: END IF;

Line 281: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CARRIER_SHIP_METHODS_PKG.Create_Carrier_Ship_Method',WSH_DEBUG_SV.C_PROC_LEVEL);

277: l_procedure := 'Calling Create_Carrier_Ship_Method';
278:
279: --
280: IF l_debug_on THEN
281: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CARRIER_SHIP_METHODS_PKG.Create_Carrier_Ship_Method',WSH_DEBUG_SV.C_PROC_LEVEL);
282: END IF;
283: --
284:
285: WSH_CARRIER_SHIP_METHODS_PKG.Create_Carrier_Ship_Method

Line 298: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);

294: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
295: -- RAISE Failed_In_CSM;
296: END IF;
297: IF l_debug_on THEN
298: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
299: END IF;
300: x_org_carrier_service_id := l_org_carrier_service_id;
301: x_rowid := l_rowid;
302:

Line 307: WSH_DEBUG_SV.logmsg(l_module_name,'Updating WSH_ORG_CARRIER_SERVICES',WSH_DEBUG_SV.C_PROC_LEVEL);

303: ELSE
304:
305: --
306: IF l_debug_on THEN
307: WSH_DEBUG_SV.logmsg(l_module_name,'Updating WSH_ORG_CARRIER_SERVICES',WSH_DEBUG_SV.C_PROC_LEVEL);
308: END IF;
309: --
310: L_POSITION := 20;
311: L_PROCEDURE := 'Updating WSH_ORG_CARRIER_SERVICES';

Line 388: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit ORG_FREIGHT_TL_PKG.UPDATE_ROW',WSH_DEBUG_SV.C_PROC_LEVEL);

384: L_POSITION := 40;
385: L_PROCEDURE := 'Calling ORG_FREIGHT_TL.Update_Row';
386: --
387: IF l_debug_on THEN
388: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit ORG_FREIGHT_TL_PKG.UPDATE_ROW',WSH_DEBUG_SV.C_PROC_LEVEL);
389: END IF;
390:
391: -- Bug 3537378
392: IF (l_orgfgt_update_allowed = 'Y') THEN -- Update Allowled

Line 399: WSH_DEBUG_SV.logmsg(l_module_name,'No of rows fetched from cursor c_get_org_freight_tl: ' || c_get_org_freight_tl%ROWCOUNT);

395: OPEN c_get_org_freight_tl( p_carrier_info.P_FREIGHT_CODE, p_org_carrier_service_info.ORGANIZATION_ID );
396: FETCH c_get_org_freight_tl into l_org_freight_tl_info;
397: --
398: IF l_debug_on THEN
399: WSH_DEBUG_SV.logmsg(l_module_name,'No of rows fetched from cursor c_get_org_freight_tl: ' || c_get_org_freight_tl%ROWCOUNT);
400: END IF;
401: --
402: CLOSE c_get_org_freight_tl;
403: --End of fix for bug 6126916

Line 460: WSH_DEBUG_SV.logmsg(l_module_name,'Updating ORG_FREIGHT_TL',WSH_DEBUG_SV.C_PROC_LEVEL);

456: L_PROCEDURE := 'Updating ORG_FREIGHT_TL';
457:
458: --
459: IF l_debug_on THEN
460: WSH_DEBUG_SV.logmsg(l_module_name,'Updating ORG_FREIGHT_TL',WSH_DEBUG_SV.C_PROC_LEVEL);
461: END IF;
462: --
463:
464: UPDATE ORG_FREIGHT_TL

Line 469: WSH_DEBUG_SV.log(l_module_name,'Update with carrier_id '||p_csm_info.carrier_id,SQL%ROWCOUNT);

465: SET party_id = p_csm_info.carrier_id
466: WHERE freight_code = p_carrier_info.p_freight_code
467: and organization_id = p_org_carrier_service_info.organization_id;
468: IF l_debug_on THEN
469: WSH_DEBUG_SV.log(l_module_name,'Update with carrier_id '||p_csm_info.carrier_id,SQL%ROWCOUNT);
470: END IF;
471:
472: IF (SQL%NOTFOUND) THEN
473: RAISE NO_DATA_FOUND;

Line 485: WSH_DEBUG_SV.log(l_module_name,'COMMIT');

481: COMMIT;
482: END IF;
483:
484: IF l_debug_on THEN
485: WSH_DEBUG_SV.log(l_module_name,'COMMIT');
486: WSH_DEBUG_SV.pop(l_module_name);
487: END IF;
488: --
489: EXCEPTION

Line 486: WSH_DEBUG_SV.pop(l_module_name);

482: END IF;
483:
484: IF l_debug_on THEN
485: WSH_DEBUG_SV.log(l_module_name,'COMMIT');
486: WSH_DEBUG_SV.pop(l_module_name);
487: END IF;
488: --
489: EXCEPTION
490: WHEN NO_DATA_FOUND THEN

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

495: x_sql_code := sqlcode;
496: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
497: --
498: IF l_debug_on THEN
499: WSH_DEBUG_SV.logmsg(l_module_name,'NO_DATA_FOUND exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
500: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_DATA_FOUND');
501: END IF;
502: --
503: WHEN Failed_In_CSM THEN

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

496: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
497: --
498: IF l_debug_on THEN
499: WSH_DEBUG_SV.logmsg(l_module_name,'NO_DATA_FOUND exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
500: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_DATA_FOUND');
501: END IF;
502: --
503: WHEN Failed_In_CSM THEN
504: x_exception_msg := 'EXCEPTION: Failed in CSM';

Line 512: WSH_DEBUG_SV.logmsg(l_module_name,'FAILED_IN_CSM exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

508: x_sql_code := sqlcode;
509: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
510: --
511: IF l_debug_on THEN
512: WSH_DEBUG_SV.logmsg(l_module_name,'FAILED_IN_CSM exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
513: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FAILED_IN_CSM');
514: END IF;
515: --
516: WHEN OTHERS THEN

Line 513: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FAILED_IN_CSM');

509: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
510: --
511: IF l_debug_on THEN
512: WSH_DEBUG_SV.logmsg(l_module_name,'FAILED_IN_CSM exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
513: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FAILED_IN_CSM');
514: END IF;
515: --
516: WHEN OTHERS THEN
517: x_exception_msg := 'EXCEPTION : Others';

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

521: x_sql_code := sqlcode;
522: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
523: --
524: IF l_debug_on THEN
525: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
526: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
527: END IF;
528: --
529: END Assign_Org_Carrier_Service;

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

522: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
523: --
524: IF l_debug_on THEN
525: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
526: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
527: END IF;
528: --
529: END Assign_Org_Carrier_Service;
530:

Line 560: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

556: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
557: --
558: IF l_debug_on IS NULL
559: THEN
560: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
561: END IF;
562: --
563: IF l_debug_on THEN
564: WSH_DEBUG_SV.push(l_module_name);

Line 564: WSH_DEBUG_SV.push(l_module_name);

560: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
561: END IF;
562: --
563: IF l_debug_on THEN
564: WSH_DEBUG_SV.push(l_module_name);
565: --
566: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
567: END IF;
568: --

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

562: --
563: IF l_debug_on THEN
564: WSH_DEBUG_SV.push(l_module_name);
565: --
566: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
567: END IF;
568: --
569: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
570: IF (p_rowid is not null) THEN

Line 581: WSH_DEBUG_SV.pop(l_module_name,'x_return_status');

577: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
578: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
579: --
580: IF l_debug_on THEN
581: WSH_DEBUG_SV.pop(l_module_name,'x_return_status');
582: END IF;
583: --
584: RETURN;
585: END IF;

Line 640: WSH_DEBUG_SV.pop(l_module_name,'Nothing changed');

636: AND (p_org_Carrier_Service_Info.Attribute15 is NULL)))
637: ) THEN
638: --
639: IF l_debug_on THEN
640: WSH_DEBUG_SV.pop(l_module_name,'Nothing changed');
641: END IF;
642: --
643: RETURN;
644: ELSE

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

643: RETURN;
644: ELSE
645: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
646: IF l_debug_on THEN
647: WSH_DEBUG_SV.log(l_module_name,'FORM_RECORD_CHANGED');
648: END IF;
649: APP_EXCEPTION.Raise_Exception;
650: END IF;
651: END IF;

Line 654: WSH_DEBUG_SV.pop(l_module_name);

650: END IF;
651: END IF;
652: --
653: IF l_debug_on THEN
654: WSH_DEBUG_SV.pop(l_module_name);
655: END IF;
656: --
657: EXCEPTION
658: WHEN others THEN

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

659: x_Return_Status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
660: WSH_UTIL_CORE.Default_Handler('WSH_org_Carrier_ServiceS_PKG.LockOrg_Carrier_Service',l_module_name);
661: --
662: IF l_debug_on THEN
663: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
664: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
665: END IF;
666: --
667: END Lock_Org_Carrier_Service;

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

660: WSH_UTIL_CORE.Default_Handler('WSH_org_Carrier_ServiceS_PKG.LockOrg_Carrier_Service',l_module_name);
661: --
662: IF l_debug_on THEN
663: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
664: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
665: END IF;
666: --
667: END Lock_Org_Carrier_Service;
668: