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.FTE_ACS_RULE_UTIL_PKG dependencies on WSH_DEBUG_SV

Line 189: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

185: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
186: --
187: IF l_debug_on IS NULL
188: THEN
189: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
190: END IF;
191: --
192: --
193: -- Debug Statements

Line 196: WSH_DEBUG_SV.push(l_module_name);

192: --
193: -- Debug Statements
194: --
195: IF l_debug_on THEN
196: WSH_DEBUG_SV.push(l_module_name);
197: --
198: WSH_DEBUG_SV.log(l_module_name,'P_INPUT_VALUE',P_INPUT_VALUE);
199: WSH_DEBUG_SV.log(l_module_name,'P_FROM_UOM',P_FROM_UOM);
200: WSH_DEBUG_SV.log(l_module_name,'P_TO_UOM',P_TO_UOM);

Line 198: WSH_DEBUG_SV.log(l_module_name,'P_INPUT_VALUE',P_INPUT_VALUE);

194: --
195: IF l_debug_on THEN
196: WSH_DEBUG_SV.push(l_module_name);
197: --
198: WSH_DEBUG_SV.log(l_module_name,'P_INPUT_VALUE',P_INPUT_VALUE);
199: WSH_DEBUG_SV.log(l_module_name,'P_FROM_UOM',P_FROM_UOM);
200: WSH_DEBUG_SV.log(l_module_name,'P_TO_UOM',P_TO_UOM);
201: END IF;
202: --

Line 199: WSH_DEBUG_SV.log(l_module_name,'P_FROM_UOM',P_FROM_UOM);

195: IF l_debug_on THEN
196: WSH_DEBUG_SV.push(l_module_name);
197: --
198: WSH_DEBUG_SV.log(l_module_name,'P_INPUT_VALUE',P_INPUT_VALUE);
199: WSH_DEBUG_SV.log(l_module_name,'P_FROM_UOM',P_FROM_UOM);
200: WSH_DEBUG_SV.log(l_module_name,'P_TO_UOM',P_TO_UOM);
201: END IF;
202: --
203: IF (p_input_value = 0) THEN

Line 200: WSH_DEBUG_SV.log(l_module_name,'P_TO_UOM',P_TO_UOM);

196: WSH_DEBUG_SV.push(l_module_name);
197: --
198: WSH_DEBUG_SV.log(l_module_name,'P_INPUT_VALUE',P_INPUT_VALUE);
199: WSH_DEBUG_SV.log(l_module_name,'P_FROM_UOM',P_FROM_UOM);
200: WSH_DEBUG_SV.log(l_module_name,'P_TO_UOM',P_TO_UOM);
201: END IF;
202: --
203: IF (p_input_value = 0) THEN
204: --

Line 211: WSH_DEBUG_SV.pop(l_module_name);

207: --
208: -- Debug Statements
209: --
210: IF l_debug_on THEN
211: WSH_DEBUG_SV.pop(l_module_name);
212: END IF;
213: --
214: RETURN(0);
215: END IF;

Line 228: WSH_DEBUG_SV.pop(l_module_name);

224: --
225: -- Debug Statements
226: --
227: IF l_debug_on THEN
228: WSH_DEBUG_SV.pop(l_module_name);
229: END IF;
230: --
231: RETURN(-99999);
232: ELSE

Line 237: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_CONVERT.INV_UM_CONVERT',WSH_DEBUG_SV.C_PROC_LEVEL);

233: --
234: -- Debug Statements
235: --
236: IF l_debug_on THEN
237: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_CONVERT.INV_UM_CONVERT',WSH_DEBUG_SV.C_PROC_LEVEL);
238: END IF;
239: --
240: l_new_conv_value := INV_CONVERT.inv_um_convert(null,
241: 5,

Line 251: WSH_DEBUG_SV.pop(l_module_name);

247: --
248: -- Debug Statements
249: --
250: IF l_debug_on THEN
251: WSH_DEBUG_SV.pop(l_module_name);
252: END IF;
253: --
254: RETURN(l_new_conv_value);
255:

Line 266: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM FTE_ACS_RULE_UTIL_PKG.CONV_VAL_TO_BASE_UOM IS ' ||L_ERROR_TEXT );

262: --
263: -- Debug Statements
264: --
265: IF l_debug_on THEN
266: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM FTE_ACS_RULE_UTIL_PKG.CONV_VAL_TO_BASE_UOM IS ' ||L_ERROR_TEXT );
267: END IF;
268: --
269: WSH_UTIL_CORE.default_handler('FTE_ACS_RULE_UTIL_PKG.CONV_TO_BASE_UOM');
270: --

Line 274: WSH_DEBUG_SV.pop(l_module_name);

270: --
271: -- Debug Statements
272: --
273: IF l_debug_on THEN
274: WSH_DEBUG_SV.pop(l_module_name);
275: END IF;
276: --
277: RETURN(-99999);
278:

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

279: --
280: -- Debug Statements
281: --
282: IF l_debug_on THEN
283: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
284: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
285: END IF;
286: --
287: END CONV_TO_BASE_UOM;

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

280: -- Debug Statements
281: --
282: IF l_debug_on THEN
283: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
284: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
285: END IF;
286: --
287: END CONV_TO_BASE_UOM;
288:

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

502:
503: itr NUMBER;
504: l_count NUMBER;
505:
506: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
507: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.'||G_PKG_NAME||'.'||'get_formatted_regions';
508:
509: BEGIN
510:

Line 514: wsh_debug_sv.push (l_module_name);

510:
511: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
512:
513: IF l_debug_on THEN
514: wsh_debug_sv.push (l_module_name);
515: END IF;
516:
517: IF (l_language is null) THEN
518: l_language := nvl(userenv('LANG'),'US');

Line 570: WSH_DEBUG_SV.log(l_module_name,'Found Regions for location ',p_location_id);

566: END LOOP;
567: END IF;
568:
569: IF l_debug_on THEN
570: WSH_DEBUG_SV.log(l_module_name,'Found Regions for location ',p_location_id);
571: WSH_DEBUG_SV.POP(l_module_name);
572: END IF;
573:
574: EXCEPTION

Line 571: WSH_DEBUG_SV.POP(l_module_name);

567: END IF;
568:
569: IF l_debug_on THEN
570: WSH_DEBUG_SV.log(l_module_name,'Found Regions for location ',p_location_id);
571: WSH_DEBUG_SV.POP(l_module_name);
572: END IF;
573:
574: EXCEPTION
575:

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

578: WSH_UTIL_CORE.default_handler('FTE_ACS_UTIL_PKG.GET_FORMATTED_REGION');
579: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
580:
581: IF l_debug_on THEN
582: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
583: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
584: END IF;
585: --
586: END GET_FORMATED_REGIONS;

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

579: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
580:
581: IF l_debug_on THEN
582: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
583: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
584: END IF;
585: --
586: END GET_FORMATED_REGIONS;
587:

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

608: WHERE wsh_location_id = p_location_id;
609:
610: l_postal_code WSH_LOCATIONS.POSTAL_CODE%TYPE;
611:
612: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
613: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.'||G_PKG_NAME||'.'||'get_postal_code';
614:
615: BEGIN
616:

Line 620: wsh_debug_sv.push (l_module_name);

616:
617: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
618:
619: IF l_debug_on THEN
620: wsh_debug_sv.push (l_module_name);
621: END IF;
622:
623: OPEN c_get_postal_code;
624: FETCH c_get_postal_code INTO l_postal_code;

Line 630: WSH_DEBUG_SV.POP (l_module_name);

626:
627: x_postal_code := l_postal_code;
628:
629: IF l_debug_on THEN
630: WSH_DEBUG_SV.POP (l_module_name);
631: END IF;
632:
633: EXCEPTION
634:

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

640: WSH_UTIL_CORE.default_handler('FTE_ACS_UTIL_PKG.get_postal_code');
641: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
642:
643: IF l_debug_on THEN
644: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
645: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
646: END IF;
647: --
648: END GET_POSTAL_CODE;

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

641: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
642:
643: IF l_debug_on THEN
644: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
645: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
646: END IF;
647: --
648: END GET_POSTAL_CODE;
649:

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

661: PROCEDURE INSERT_INTO_GTT(p_input_data IN FTE_ACS_PKG.fte_cs_entity_tab_type,
662: x_return_status OUT NOCOPY VARCHAR2)
663: IS
664: l_cnt NUMBER;
665: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
666: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'INSERT_INTO_GTT';
667: l_first NUMBER;
668: l_last NUMBER;
669: l_insert_gtt_rec FTE_CS_BULK_ENTITY_GTT;

Line 677: wsh_debug_sv.push (l_module_name);

673: BEGIN
674: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
675:
676: IF l_debug_on THEN
677: wsh_debug_sv.push (l_module_name);
678: WSH_DEBUG_SV.logmsg(l_module_name,'Number of input records'||p_input_data.COUNT);
679: WSH_DEBUG_SV.logmsg(l_module_name,'Inserting data into GTT');
680: itr := p_input_data.FIRST;
681: LOOP

Line 678: WSH_DEBUG_SV.logmsg(l_module_name,'Number of input records'||p_input_data.COUNT);

674: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
675:
676: IF l_debug_on THEN
677: wsh_debug_sv.push (l_module_name);
678: WSH_DEBUG_SV.logmsg(l_module_name,'Number of input records'||p_input_data.COUNT);
679: WSH_DEBUG_SV.logmsg(l_module_name,'Inserting data into GTT');
680: itr := p_input_data.FIRST;
681: LOOP
682: WSH_DEBUG_SV.logmsg(l_module_name,'***NEW RECORD ********');

Line 679: WSH_DEBUG_SV.logmsg(l_module_name,'Inserting data into GTT');

675:
676: IF l_debug_on THEN
677: wsh_debug_sv.push (l_module_name);
678: WSH_DEBUG_SV.logmsg(l_module_name,'Number of input records'||p_input_data.COUNT);
679: WSH_DEBUG_SV.logmsg(l_module_name,'Inserting data into GTT');
680: itr := p_input_data.FIRST;
681: LOOP
682: WSH_DEBUG_SV.logmsg(l_module_name,'***NEW RECORD ********');
683: WSH_DEBUG_SV.log(l_module_name,'delivery_id ',p_input_data(itr).delivery_id);

Line 682: WSH_DEBUG_SV.logmsg(l_module_name,'*NEW RECORD ******');

678: WSH_DEBUG_SV.logmsg(l_module_name,'Number of input records'||p_input_data.COUNT);
679: WSH_DEBUG_SV.logmsg(l_module_name,'Inserting data into GTT');
680: itr := p_input_data.FIRST;
681: LOOP
682: WSH_DEBUG_SV.logmsg(l_module_name,'***NEW RECORD ********');
683: WSH_DEBUG_SV.log(l_module_name,'delivery_id ',p_input_data(itr).delivery_id);
684: WSH_DEBUG_SV.log(l_module_name,'trip_id ',p_input_data(itr).trip_id);
685: WSH_DEBUG_SV.log(l_module_name,'delivery_name ',p_input_data(itr).delivery_name);
686: WSH_DEBUG_SV.log(l_module_name,'trip_name ',p_input_data(itr).trip_name);

Line 683: WSH_DEBUG_SV.log(l_module_name,'delivery_id ',p_input_data(itr).delivery_id);

679: WSH_DEBUG_SV.logmsg(l_module_name,'Inserting data into GTT');
680: itr := p_input_data.FIRST;
681: LOOP
682: WSH_DEBUG_SV.logmsg(l_module_name,'***NEW RECORD ********');
683: WSH_DEBUG_SV.log(l_module_name,'delivery_id ',p_input_data(itr).delivery_id);
684: WSH_DEBUG_SV.log(l_module_name,'trip_id ',p_input_data(itr).trip_id);
685: WSH_DEBUG_SV.log(l_module_name,'delivery_name ',p_input_data(itr).delivery_name);
686: WSH_DEBUG_SV.log(l_module_name,'trip_name ',p_input_data(itr).trip_name);
687: WSH_DEBUG_SV.log(l_module_name,'organization_id ',p_input_data(itr).organization_id);

Line 684: WSH_DEBUG_SV.log(l_module_name,'trip_id ',p_input_data(itr).trip_id);

680: itr := p_input_data.FIRST;
681: LOOP
682: WSH_DEBUG_SV.logmsg(l_module_name,'***NEW RECORD ********');
683: WSH_DEBUG_SV.log(l_module_name,'delivery_id ',p_input_data(itr).delivery_id);
684: WSH_DEBUG_SV.log(l_module_name,'trip_id ',p_input_data(itr).trip_id);
685: WSH_DEBUG_SV.log(l_module_name,'delivery_name ',p_input_data(itr).delivery_name);
686: WSH_DEBUG_SV.log(l_module_name,'trip_name ',p_input_data(itr).trip_name);
687: WSH_DEBUG_SV.log(l_module_name,'organization_id ',p_input_data(itr).organization_id);
688: WSH_DEBUG_SV.log(l_module_name,'triporigin_internalorg_id ',p_input_data(itr).triporigin_internalorg_id);

Line 685: WSH_DEBUG_SV.log(l_module_name,'delivery_name ',p_input_data(itr).delivery_name);

681: LOOP
682: WSH_DEBUG_SV.logmsg(l_module_name,'***NEW RECORD ********');
683: WSH_DEBUG_SV.log(l_module_name,'delivery_id ',p_input_data(itr).delivery_id);
684: WSH_DEBUG_SV.log(l_module_name,'trip_id ',p_input_data(itr).trip_id);
685: WSH_DEBUG_SV.log(l_module_name,'delivery_name ',p_input_data(itr).delivery_name);
686: WSH_DEBUG_SV.log(l_module_name,'trip_name ',p_input_data(itr).trip_name);
687: WSH_DEBUG_SV.log(l_module_name,'organization_id ',p_input_data(itr).organization_id);
688: WSH_DEBUG_SV.log(l_module_name,'triporigin_internalorg_id ',p_input_data(itr).triporigin_internalorg_id);
689: WSH_DEBUG_SV.log(l_module_name,'customer_id ',p_input_data(itr).customer_id);

Line 686: WSH_DEBUG_SV.log(l_module_name,'trip_name ',p_input_data(itr).trip_name);

682: WSH_DEBUG_SV.logmsg(l_module_name,'***NEW RECORD ********');
683: WSH_DEBUG_SV.log(l_module_name,'delivery_id ',p_input_data(itr).delivery_id);
684: WSH_DEBUG_SV.log(l_module_name,'trip_id ',p_input_data(itr).trip_id);
685: WSH_DEBUG_SV.log(l_module_name,'delivery_name ',p_input_data(itr).delivery_name);
686: WSH_DEBUG_SV.log(l_module_name,'trip_name ',p_input_data(itr).trip_name);
687: WSH_DEBUG_SV.log(l_module_name,'organization_id ',p_input_data(itr).organization_id);
688: WSH_DEBUG_SV.log(l_module_name,'triporigin_internalorg_id ',p_input_data(itr).triporigin_internalorg_id);
689: WSH_DEBUG_SV.log(l_module_name,'customer_id ',p_input_data(itr).customer_id);
690: WSH_DEBUG_SV.log(l_module_name,'customer_site_id ',p_input_data(itr).customer_site_id);

Line 687: WSH_DEBUG_SV.log(l_module_name,'organization_id ',p_input_data(itr).organization_id);

683: WSH_DEBUG_SV.log(l_module_name,'delivery_id ',p_input_data(itr).delivery_id);
684: WSH_DEBUG_SV.log(l_module_name,'trip_id ',p_input_data(itr).trip_id);
685: WSH_DEBUG_SV.log(l_module_name,'delivery_name ',p_input_data(itr).delivery_name);
686: WSH_DEBUG_SV.log(l_module_name,'trip_name ',p_input_data(itr).trip_name);
687: WSH_DEBUG_SV.log(l_module_name,'organization_id ',p_input_data(itr).organization_id);
688: WSH_DEBUG_SV.log(l_module_name,'triporigin_internalorg_id ',p_input_data(itr).triporigin_internalorg_id);
689: WSH_DEBUG_SV.log(l_module_name,'customer_id ',p_input_data(itr).customer_id);
690: WSH_DEBUG_SV.log(l_module_name,'customer_site_id ',p_input_data(itr).customer_site_id);
691: WSH_DEBUG_SV.log(l_module_name,'gross_weight ', p_input_data(itr).gross_weight);

Line 688: WSH_DEBUG_SV.log(l_module_name,'triporigin_internalorg_id ',p_input_data(itr).triporigin_internalorg_id);

684: WSH_DEBUG_SV.log(l_module_name,'trip_id ',p_input_data(itr).trip_id);
685: WSH_DEBUG_SV.log(l_module_name,'delivery_name ',p_input_data(itr).delivery_name);
686: WSH_DEBUG_SV.log(l_module_name,'trip_name ',p_input_data(itr).trip_name);
687: WSH_DEBUG_SV.log(l_module_name,'organization_id ',p_input_data(itr).organization_id);
688: WSH_DEBUG_SV.log(l_module_name,'triporigin_internalorg_id ',p_input_data(itr).triporigin_internalorg_id);
689: WSH_DEBUG_SV.log(l_module_name,'customer_id ',p_input_data(itr).customer_id);
690: WSH_DEBUG_SV.log(l_module_name,'customer_site_id ',p_input_data(itr).customer_site_id);
691: WSH_DEBUG_SV.log(l_module_name,'gross_weight ', p_input_data(itr).gross_weight);
692: WSH_DEBUG_SV.log(l_module_name,'weight_uom_code ',p_input_data(itr).weight_uom_code);

Line 689: WSH_DEBUG_SV.log(l_module_name,'customer_id ',p_input_data(itr).customer_id);

685: WSH_DEBUG_SV.log(l_module_name,'delivery_name ',p_input_data(itr).delivery_name);
686: WSH_DEBUG_SV.log(l_module_name,'trip_name ',p_input_data(itr).trip_name);
687: WSH_DEBUG_SV.log(l_module_name,'organization_id ',p_input_data(itr).organization_id);
688: WSH_DEBUG_SV.log(l_module_name,'triporigin_internalorg_id ',p_input_data(itr).triporigin_internalorg_id);
689: WSH_DEBUG_SV.log(l_module_name,'customer_id ',p_input_data(itr).customer_id);
690: WSH_DEBUG_SV.log(l_module_name,'customer_site_id ',p_input_data(itr).customer_site_id);
691: WSH_DEBUG_SV.log(l_module_name,'gross_weight ', p_input_data(itr).gross_weight);
692: WSH_DEBUG_SV.log(l_module_name,'weight_uom_code ',p_input_data(itr).weight_uom_code);
693: WSH_DEBUG_SV.log(l_module_name,'volume ', p_input_data(itr).volume);

Line 690: WSH_DEBUG_SV.log(l_module_name,'customer_site_id ',p_input_data(itr).customer_site_id);

686: WSH_DEBUG_SV.log(l_module_name,'trip_name ',p_input_data(itr).trip_name);
687: WSH_DEBUG_SV.log(l_module_name,'organization_id ',p_input_data(itr).organization_id);
688: WSH_DEBUG_SV.log(l_module_name,'triporigin_internalorg_id ',p_input_data(itr).triporigin_internalorg_id);
689: WSH_DEBUG_SV.log(l_module_name,'customer_id ',p_input_data(itr).customer_id);
690: WSH_DEBUG_SV.log(l_module_name,'customer_site_id ',p_input_data(itr).customer_site_id);
691: WSH_DEBUG_SV.log(l_module_name,'gross_weight ', p_input_data(itr).gross_weight);
692: WSH_DEBUG_SV.log(l_module_name,'weight_uom_code ',p_input_data(itr).weight_uom_code);
693: WSH_DEBUG_SV.log(l_module_name,'volume ', p_input_data(itr).volume);
694: WSH_DEBUG_SV.log(l_module_name,'volume_uom_code ', p_input_data(itr).volume_uom_code);

Line 691: WSH_DEBUG_SV.log(l_module_name,'gross_weight ', p_input_data(itr).gross_weight);

687: WSH_DEBUG_SV.log(l_module_name,'organization_id ',p_input_data(itr).organization_id);
688: WSH_DEBUG_SV.log(l_module_name,'triporigin_internalorg_id ',p_input_data(itr).triporigin_internalorg_id);
689: WSH_DEBUG_SV.log(l_module_name,'customer_id ',p_input_data(itr).customer_id);
690: WSH_DEBUG_SV.log(l_module_name,'customer_site_id ',p_input_data(itr).customer_site_id);
691: WSH_DEBUG_SV.log(l_module_name,'gross_weight ', p_input_data(itr).gross_weight);
692: WSH_DEBUG_SV.log(l_module_name,'weight_uom_code ',p_input_data(itr).weight_uom_code);
693: WSH_DEBUG_SV.log(l_module_name,'volume ', p_input_data(itr).volume);
694: WSH_DEBUG_SV.log(l_module_name,'volume_uom_code ', p_input_data(itr).volume_uom_code);
695: WSH_DEBUG_SV.log(l_module_name,'initial_pickup_loc_id ', p_input_data(itr).initial_pickup_loc_id);

Line 692: WSH_DEBUG_SV.log(l_module_name,'weight_uom_code ',p_input_data(itr).weight_uom_code);

688: WSH_DEBUG_SV.log(l_module_name,'triporigin_internalorg_id ',p_input_data(itr).triporigin_internalorg_id);
689: WSH_DEBUG_SV.log(l_module_name,'customer_id ',p_input_data(itr).customer_id);
690: WSH_DEBUG_SV.log(l_module_name,'customer_site_id ',p_input_data(itr).customer_site_id);
691: WSH_DEBUG_SV.log(l_module_name,'gross_weight ', p_input_data(itr).gross_weight);
692: WSH_DEBUG_SV.log(l_module_name,'weight_uom_code ',p_input_data(itr).weight_uom_code);
693: WSH_DEBUG_SV.log(l_module_name,'volume ', p_input_data(itr).volume);
694: WSH_DEBUG_SV.log(l_module_name,'volume_uom_code ', p_input_data(itr).volume_uom_code);
695: WSH_DEBUG_SV.log(l_module_name,'initial_pickup_loc_id ', p_input_data(itr).initial_pickup_loc_id);
696: WSH_DEBUG_SV.log(l_module_name,'ultimate_dropoff_loc_id ', p_input_data(itr).ultimate_dropoff_loc_id);

Line 693: WSH_DEBUG_SV.log(l_module_name,'volume ', p_input_data(itr).volume);

689: WSH_DEBUG_SV.log(l_module_name,'customer_id ',p_input_data(itr).customer_id);
690: WSH_DEBUG_SV.log(l_module_name,'customer_site_id ',p_input_data(itr).customer_site_id);
691: WSH_DEBUG_SV.log(l_module_name,'gross_weight ', p_input_data(itr).gross_weight);
692: WSH_DEBUG_SV.log(l_module_name,'weight_uom_code ',p_input_data(itr).weight_uom_code);
693: WSH_DEBUG_SV.log(l_module_name,'volume ', p_input_data(itr).volume);
694: WSH_DEBUG_SV.log(l_module_name,'volume_uom_code ', p_input_data(itr).volume_uom_code);
695: WSH_DEBUG_SV.log(l_module_name,'initial_pickup_loc_id ', p_input_data(itr).initial_pickup_loc_id);
696: WSH_DEBUG_SV.log(l_module_name,'ultimate_dropoff_loc_id ', p_input_data(itr).ultimate_dropoff_loc_id);
697: WSH_DEBUG_SV.log(l_module_name,'initial_pickup_date ', nvl(p_input_data(itr).initial_pickup_date,SYSDATE));

Line 694: WSH_DEBUG_SV.log(l_module_name,'volume_uom_code ', p_input_data(itr).volume_uom_code);

690: WSH_DEBUG_SV.log(l_module_name,'customer_site_id ',p_input_data(itr).customer_site_id);
691: WSH_DEBUG_SV.log(l_module_name,'gross_weight ', p_input_data(itr).gross_weight);
692: WSH_DEBUG_SV.log(l_module_name,'weight_uom_code ',p_input_data(itr).weight_uom_code);
693: WSH_DEBUG_SV.log(l_module_name,'volume ', p_input_data(itr).volume);
694: WSH_DEBUG_SV.log(l_module_name,'volume_uom_code ', p_input_data(itr).volume_uom_code);
695: WSH_DEBUG_SV.log(l_module_name,'initial_pickup_loc_id ', p_input_data(itr).initial_pickup_loc_id);
696: WSH_DEBUG_SV.log(l_module_name,'ultimate_dropoff_loc_id ', p_input_data(itr).ultimate_dropoff_loc_id);
697: WSH_DEBUG_SV.log(l_module_name,'initial_pickup_date ', nvl(p_input_data(itr).initial_pickup_date,SYSDATE));
698: WSH_DEBUG_SV.log(l_module_name,'ultimate_dropoff_date ', p_input_data(itr).ultimate_dropoff_date);

Line 695: WSH_DEBUG_SV.log(l_module_name,'initial_pickup_loc_id ', p_input_data(itr).initial_pickup_loc_id);

691: WSH_DEBUG_SV.log(l_module_name,'gross_weight ', p_input_data(itr).gross_weight);
692: WSH_DEBUG_SV.log(l_module_name,'weight_uom_code ',p_input_data(itr).weight_uom_code);
693: WSH_DEBUG_SV.log(l_module_name,'volume ', p_input_data(itr).volume);
694: WSH_DEBUG_SV.log(l_module_name,'volume_uom_code ', p_input_data(itr).volume_uom_code);
695: WSH_DEBUG_SV.log(l_module_name,'initial_pickup_loc_id ', p_input_data(itr).initial_pickup_loc_id);
696: WSH_DEBUG_SV.log(l_module_name,'ultimate_dropoff_loc_id ', p_input_data(itr).ultimate_dropoff_loc_id);
697: WSH_DEBUG_SV.log(l_module_name,'initial_pickup_date ', nvl(p_input_data(itr).initial_pickup_date,SYSDATE));
698: WSH_DEBUG_SV.log(l_module_name,'ultimate_dropoff_date ', p_input_data(itr).ultimate_dropoff_date);
699: WSH_DEBUG_SV.log(l_module_name,'freight_terms_code ',p_input_data(itr).freight_terms_code);

Line 696: WSH_DEBUG_SV.log(l_module_name,'ultimate_dropoff_loc_id ', p_input_data(itr).ultimate_dropoff_loc_id);

692: WSH_DEBUG_SV.log(l_module_name,'weight_uom_code ',p_input_data(itr).weight_uom_code);
693: WSH_DEBUG_SV.log(l_module_name,'volume ', p_input_data(itr).volume);
694: WSH_DEBUG_SV.log(l_module_name,'volume_uom_code ', p_input_data(itr).volume_uom_code);
695: WSH_DEBUG_SV.log(l_module_name,'initial_pickup_loc_id ', p_input_data(itr).initial_pickup_loc_id);
696: WSH_DEBUG_SV.log(l_module_name,'ultimate_dropoff_loc_id ', p_input_data(itr).ultimate_dropoff_loc_id);
697: WSH_DEBUG_SV.log(l_module_name,'initial_pickup_date ', nvl(p_input_data(itr).initial_pickup_date,SYSDATE));
698: WSH_DEBUG_SV.log(l_module_name,'ultimate_dropoff_date ', p_input_data(itr).ultimate_dropoff_date);
699: WSH_DEBUG_SV.log(l_module_name,'freight_terms_code ',p_input_data(itr).freight_terms_code);
700: WSH_DEBUG_SV.log(l_module_name,'fob_code ',p_input_data(itr).fob_code);

Line 697: WSH_DEBUG_SV.log(l_module_name,'initial_pickup_date ', nvl(p_input_data(itr).initial_pickup_date,SYSDATE));

693: WSH_DEBUG_SV.log(l_module_name,'volume ', p_input_data(itr).volume);
694: WSH_DEBUG_SV.log(l_module_name,'volume_uom_code ', p_input_data(itr).volume_uom_code);
695: WSH_DEBUG_SV.log(l_module_name,'initial_pickup_loc_id ', p_input_data(itr).initial_pickup_loc_id);
696: WSH_DEBUG_SV.log(l_module_name,'ultimate_dropoff_loc_id ', p_input_data(itr).ultimate_dropoff_loc_id);
697: WSH_DEBUG_SV.log(l_module_name,'initial_pickup_date ', nvl(p_input_data(itr).initial_pickup_date,SYSDATE));
698: WSH_DEBUG_SV.log(l_module_name,'ultimate_dropoff_date ', p_input_data(itr).ultimate_dropoff_date);
699: WSH_DEBUG_SV.log(l_module_name,'freight_terms_code ',p_input_data(itr).freight_terms_code);
700: WSH_DEBUG_SV.log(l_module_name,'fob_code ',p_input_data(itr).fob_code);
701: WSH_DEBUG_SV.log(l_module_name,'start_search_level ',p_input_data(itr).start_search_level);

Line 698: WSH_DEBUG_SV.log(l_module_name,'ultimate_dropoff_date ', p_input_data(itr).ultimate_dropoff_date);

694: WSH_DEBUG_SV.log(l_module_name,'volume_uom_code ', p_input_data(itr).volume_uom_code);
695: WSH_DEBUG_SV.log(l_module_name,'initial_pickup_loc_id ', p_input_data(itr).initial_pickup_loc_id);
696: WSH_DEBUG_SV.log(l_module_name,'ultimate_dropoff_loc_id ', p_input_data(itr).ultimate_dropoff_loc_id);
697: WSH_DEBUG_SV.log(l_module_name,'initial_pickup_date ', nvl(p_input_data(itr).initial_pickup_date,SYSDATE));
698: WSH_DEBUG_SV.log(l_module_name,'ultimate_dropoff_date ', p_input_data(itr).ultimate_dropoff_date);
699: WSH_DEBUG_SV.log(l_module_name,'freight_terms_code ',p_input_data(itr).freight_terms_code);
700: WSH_DEBUG_SV.log(l_module_name,'fob_code ',p_input_data(itr).fob_code);
701: WSH_DEBUG_SV.log(l_module_name,'start_search_level ',p_input_data(itr).start_search_level);
702: WSH_DEBUG_SV.log(l_module_name,'transit_time ',p_input_data(itr).transit_time);

Line 699: WSH_DEBUG_SV.log(l_module_name,'freight_terms_code ',p_input_data(itr).freight_terms_code);

695: WSH_DEBUG_SV.log(l_module_name,'initial_pickup_loc_id ', p_input_data(itr).initial_pickup_loc_id);
696: WSH_DEBUG_SV.log(l_module_name,'ultimate_dropoff_loc_id ', p_input_data(itr).ultimate_dropoff_loc_id);
697: WSH_DEBUG_SV.log(l_module_name,'initial_pickup_date ', nvl(p_input_data(itr).initial_pickup_date,SYSDATE));
698: WSH_DEBUG_SV.log(l_module_name,'ultimate_dropoff_date ', p_input_data(itr).ultimate_dropoff_date);
699: WSH_DEBUG_SV.log(l_module_name,'freight_terms_code ',p_input_data(itr).freight_terms_code);
700: WSH_DEBUG_SV.log(l_module_name,'fob_code ',p_input_data(itr).fob_code);
701: WSH_DEBUG_SV.log(l_module_name,'start_search_level ',p_input_data(itr).start_search_level);
702: WSH_DEBUG_SV.log(l_module_name,'transit_time ',p_input_data(itr).transit_time);
703:

Line 700: WSH_DEBUG_SV.log(l_module_name,'fob_code ',p_input_data(itr).fob_code);

696: WSH_DEBUG_SV.log(l_module_name,'ultimate_dropoff_loc_id ', p_input_data(itr).ultimate_dropoff_loc_id);
697: WSH_DEBUG_SV.log(l_module_name,'initial_pickup_date ', nvl(p_input_data(itr).initial_pickup_date,SYSDATE));
698: WSH_DEBUG_SV.log(l_module_name,'ultimate_dropoff_date ', p_input_data(itr).ultimate_dropoff_date);
699: WSH_DEBUG_SV.log(l_module_name,'freight_terms_code ',p_input_data(itr).freight_terms_code);
700: WSH_DEBUG_SV.log(l_module_name,'fob_code ',p_input_data(itr).fob_code);
701: WSH_DEBUG_SV.log(l_module_name,'start_search_level ',p_input_data(itr).start_search_level);
702: WSH_DEBUG_SV.log(l_module_name,'transit_time ',p_input_data(itr).transit_time);
703:
704: EXIT WHEN itr = p_input_data.LAST;

Line 701: WSH_DEBUG_SV.log(l_module_name,'start_search_level ',p_input_data(itr).start_search_level);

697: WSH_DEBUG_SV.log(l_module_name,'initial_pickup_date ', nvl(p_input_data(itr).initial_pickup_date,SYSDATE));
698: WSH_DEBUG_SV.log(l_module_name,'ultimate_dropoff_date ', p_input_data(itr).ultimate_dropoff_date);
699: WSH_DEBUG_SV.log(l_module_name,'freight_terms_code ',p_input_data(itr).freight_terms_code);
700: WSH_DEBUG_SV.log(l_module_name,'fob_code ',p_input_data(itr).fob_code);
701: WSH_DEBUG_SV.log(l_module_name,'start_search_level ',p_input_data(itr).start_search_level);
702: WSH_DEBUG_SV.log(l_module_name,'transit_time ',p_input_data(itr).transit_time);
703:
704: EXIT WHEN itr = p_input_data.LAST;
705: itr := p_input_data.NEXT(itr);

Line 702: WSH_DEBUG_SV.log(l_module_name,'transit_time ',p_input_data(itr).transit_time);

698: WSH_DEBUG_SV.log(l_module_name,'ultimate_dropoff_date ', p_input_data(itr).ultimate_dropoff_date);
699: WSH_DEBUG_SV.log(l_module_name,'freight_terms_code ',p_input_data(itr).freight_terms_code);
700: WSH_DEBUG_SV.log(l_module_name,'fob_code ',p_input_data(itr).fob_code);
701: WSH_DEBUG_SV.log(l_module_name,'start_search_level ',p_input_data(itr).start_search_level);
702: WSH_DEBUG_SV.log(l_module_name,'transit_time ',p_input_data(itr).transit_time);
703:
704: EXIT WHEN itr = p_input_data.LAST;
705: itr := p_input_data.NEXT(itr);
706: END LOOP;

Line 790: wsh_debug_sv.pop (l_module_name);

786: l_insert_gtt_rec.search_level_tab(j),
787: l_insert_gtt_rec.transit_time_tab(j));
788:
789: IF l_debug_on THEN
790: wsh_debug_sv.pop (l_module_name);
791: END IF;
792:
793: EXCEPTION
794: WHEN OTHERS THEN

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

796: WSH_UTIL_CORE.default_handler('FTE_ACS_RULE_UTIL_PKG.INSERT_INTO_GTT');
797: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
798: --
799: IF l_debug_on THEN
800: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
801: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
802: END IF;
803: --
804: END insert_into_gtt;

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

797: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
798: --
799: IF l_debug_on THEN
800: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
801: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
802: END IF;
803: --
804: END insert_into_gtt;
805:

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

826: l_search_level VARCHAR2(1);
827: l_itr NUMBER;
828: l_sysdate DATE := sysdate;
829:
830: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
831: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'FORMAT_ENTITY_INFO';
832:
833: BEGIN
834:

Line 838: wsh_debug_sv.push (l_module_name);

834:
835: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
836:
837: IF l_debug_on THEN
838: wsh_debug_sv.push (l_module_name);
839: WSH_DEBUG_SV.logmsg(l_module_name,'Number of input records'||p_input_cs_tab.COUNT);
840: END IF;
841:
842: itr := p_input_cs_tab.FIRST;

Line 839: WSH_DEBUG_SV.logmsg(l_module_name,'Number of input records'||p_input_cs_tab.COUNT);

835: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
836:
837: IF l_debug_on THEN
838: wsh_debug_sv.push (l_module_name);
839: WSH_DEBUG_SV.logmsg(l_module_name,'Number of input records'||p_input_cs_tab.COUNT);
840: END IF;
841:
842: itr := p_input_cs_tab.FIRST;
843:

Line 914: wsh_debug_sv.pop (l_module_name);

910: END LOOP;
911: END IF;
912:
913: IF l_debug_on THEN
914: wsh_debug_sv.pop (l_module_name);
915: END IF;
916: EXCEPTION
917: WHEN OTHERS THEN
918: --

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

919: WSH_UTIL_CORE.default_handler('FTE_ACS_RULE_UTIL_PKG.FORMAT_ENTITY_INFO');
920: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
921: --
922: IF l_debug_on THEN
923: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
924: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
925: END IF;
926: --
927: END FORMAT_ENTITY_INFO;

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

920: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
921: --
922: IF l_debug_on THEN
923: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
924: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
925: END IF;
926: --
927: END FORMAT_ENTITY_INFO;
928:

Line 985: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

981: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
982: --
983: IF l_debug_on IS NULL
984: THEN
985: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
986: END IF;
987: --
988: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
989: x_return_message := null;

Line 992: WSH_DEBUG_SV.push(l_module_name);

988: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
989: x_return_message := null;
990:
991: IF l_debug_on THEN
992: WSH_DEBUG_SV.push(l_module_name);
993: WSH_DEBUG_SV.logmsg(l_module_name, 'Carrier Id '||p_carrier_id);
994: WSH_DEBUG_SV.logmsg(l_module_name, 'Service Level '||p_service_level);
995: WSH_DEBUG_SV.logmsg(l_module_name, 'Mode of transport '||p_mode_of_transport);
996: WSH_DEBUG_SV.logmsg(l_module_name, 'Organization Id '||p_org_id);

Line 993: WSH_DEBUG_SV.logmsg(l_module_name, 'Carrier Id '||p_carrier_id);

989: x_return_message := null;
990:
991: IF l_debug_on THEN
992: WSH_DEBUG_SV.push(l_module_name);
993: WSH_DEBUG_SV.logmsg(l_module_name, 'Carrier Id '||p_carrier_id);
994: WSH_DEBUG_SV.logmsg(l_module_name, 'Service Level '||p_service_level);
995: WSH_DEBUG_SV.logmsg(l_module_name, 'Mode of transport '||p_mode_of_transport);
996: WSH_DEBUG_SV.logmsg(l_module_name, 'Organization Id '||p_org_id);
997: END IF;

Line 994: WSH_DEBUG_SV.logmsg(l_module_name, 'Service Level '||p_service_level);

990:
991: IF l_debug_on THEN
992: WSH_DEBUG_SV.push(l_module_name);
993: WSH_DEBUG_SV.logmsg(l_module_name, 'Carrier Id '||p_carrier_id);
994: WSH_DEBUG_SV.logmsg(l_module_name, 'Service Level '||p_service_level);
995: WSH_DEBUG_SV.logmsg(l_module_name, 'Mode of transport '||p_mode_of_transport);
996: WSH_DEBUG_SV.logmsg(l_module_name, 'Organization Id '||p_org_id);
997: END IF;
998: --

Line 995: WSH_DEBUG_SV.logmsg(l_module_name, 'Mode of transport '||p_mode_of_transport);

991: IF l_debug_on THEN
992: WSH_DEBUG_SV.push(l_module_name);
993: WSH_DEBUG_SV.logmsg(l_module_name, 'Carrier Id '||p_carrier_id);
994: WSH_DEBUG_SV.logmsg(l_module_name, 'Service Level '||p_service_level);
995: WSH_DEBUG_SV.logmsg(l_module_name, 'Mode of transport '||p_mode_of_transport);
996: WSH_DEBUG_SV.logmsg(l_module_name, 'Organization Id '||p_org_id);
997: END IF;
998: --
999:

Line 996: WSH_DEBUG_SV.logmsg(l_module_name, 'Organization Id '||p_org_id);

992: WSH_DEBUG_SV.push(l_module_name);
993: WSH_DEBUG_SV.logmsg(l_module_name, 'Carrier Id '||p_carrier_id);
994: WSH_DEBUG_SV.logmsg(l_module_name, 'Service Level '||p_service_level);
995: WSH_DEBUG_SV.logmsg(l_module_name, 'Mode of transport '||p_mode_of_transport);
996: WSH_DEBUG_SV.logmsg(l_module_name, 'Organization Id '||p_org_id);
997: END IF;
998: --
999:
1000: IF (p_carrier_id IS NOT NULL) THEN

Line 1017: WSH_DEBUG_SV.logmsg(l_module_name, 'Ship Method Code'||x_ship_method_code);

1013: --
1014: -- Debug Statements
1015: --
1016: IF l_debug_on THEN
1017: WSH_DEBUG_SV.logmsg(l_module_name, 'Ship Method Code'||x_ship_method_code);
1018: WSH_DEBUG_SV.pop(l_module_name);
1019: END IF;
1020: --
1021:

Line 1018: WSH_DEBUG_SV.pop(l_module_name);

1014: -- Debug Statements
1015: --
1016: IF l_debug_on THEN
1017: WSH_DEBUG_SV.logmsg(l_module_name, 'Ship Method Code'||x_ship_method_code);
1018: WSH_DEBUG_SV.pop(l_module_name);
1019: END IF;
1020: --
1021:
1022: EXCEPTION

Line 1030: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM WSH_UTIL_CORE.GET_SHIP_METHOD_CODE IS ' ||L_ERROR_TEXT );

1026: --
1027: -- Debug Statements
1028: --
1029: IF l_debug_on THEN
1030: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM WSH_UTIL_CORE.GET_SHIP_METHOD_CODE IS ' ||L_ERROR_TEXT );
1031: WSH_DEBUG_SV.pop(l_module_name);
1032: END IF;
1033: --
1034: WSH_UTIL_CORE.default_handler('WSH_UTIL_CORE.GET_SHIP_METHOD_CODE');

Line 1031: WSH_DEBUG_SV.pop(l_module_name);

1027: -- Debug Statements
1028: --
1029: IF l_debug_on THEN
1030: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM WSH_UTIL_CORE.GET_SHIP_METHOD_CODE IS ' ||L_ERROR_TEXT );
1031: WSH_DEBUG_SV.pop(l_module_name);
1032: END IF;
1033: --
1034: WSH_UTIL_CORE.default_handler('WSH_UTIL_CORE.GET_SHIP_METHOD_CODE');
1035: FND_MESSAGE.SET_NAME('WSH','WSH_FTE_GET_SMC_ERROR');

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

1319:
1320: l_result_found BOOLEAN := FALSE;
1321: l_group_id NUMBER;
1322:
1323: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
1324: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' ||'GET_CANDIDATE_RECORDS';
1325: BEGIN
1326:
1327: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 1331: wsh_debug_sv.push(l_module_name);

1327: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1328:
1329: IF l_debug_on THEN
1330:
1331: wsh_debug_sv.push(l_module_name);
1332: WSH_DEBUG_SV.log(l_module_name,'p_search_level',p_search_level);
1333:
1334: IF (p_query_gtt) THEN
1335: WSH_DEBUG_SV.logmsg(l_module_name,'Use Global Temporary Table');

Line 1332: WSH_DEBUG_SV.log(l_module_name,'p_search_level',p_search_level);

1328:
1329: IF l_debug_on THEN
1330:
1331: wsh_debug_sv.push(l_module_name);
1332: WSH_DEBUG_SV.log(l_module_name,'p_search_level',p_search_level);
1333:
1334: IF (p_query_gtt) THEN
1335: WSH_DEBUG_SV.logmsg(l_module_name,'Use Global Temporary Table');
1336: ELSE

Line 1335: WSH_DEBUG_SV.logmsg(l_module_name,'Use Global Temporary Table');

1331: wsh_debug_sv.push(l_module_name);
1332: WSH_DEBUG_SV.log(l_module_name,'p_search_level',p_search_level);
1333:
1334: IF (p_query_gtt) THEN
1335: WSH_DEBUG_SV.logmsg(l_module_name,'Use Global Temporary Table');
1336: ELSE
1337: WSH_DEBUG_SV.logmsg(l_module_name,'Use Single Record');
1338: END IF;
1339:

Line 1337: WSH_DEBUG_SV.logmsg(l_module_name,'Use Single Record');

1333:
1334: IF (p_query_gtt) THEN
1335: WSH_DEBUG_SV.logmsg(l_module_name,'Use Global Temporary Table');
1336: ELSE
1337: WSH_DEBUG_SV.logmsg(l_module_name,'Use Single Record');
1338: END IF;
1339:
1340: END IF;
1341:

Line 1595: WSH_DEBUG_SV.log(l_module_name, 'CANDIDATE RECORDS RETURNED',x_output_tab.COUNT);

1591:
1592: END IF; --IF (p_query_gtt) THEN
1593:
1594: IF l_debug_on THEN
1595: WSH_DEBUG_SV.log(l_module_name, 'CANDIDATE RECORDS RETURNED',x_output_tab.COUNT);
1596: WSH_DEBUG_SV.pop(l_module_name);
1597: END IF;
1598:
1599: EXCEPTION

Line 1596: WSH_DEBUG_SV.pop(l_module_name);

1592: END IF; --IF (p_query_gtt) THEN
1593:
1594: IF l_debug_on THEN
1595: WSH_DEBUG_SV.log(l_module_name, 'CANDIDATE RECORDS RETURNED',x_output_tab.COUNT);
1596: WSH_DEBUG_SV.pop(l_module_name);
1597: END IF;
1598:
1599: EXCEPTION
1600: WHEN others THEN

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

1634: WSH_UTIL_CORE.default_handler('FTE_ACS_UTIL_PKG.get_candidate_records');
1635: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1636: --
1637: IF l_debug_on THEN
1638: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1639: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1640: END IF;
1641: --
1642: END GET_CANDIDATE_RECORDS;

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

1635: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1636: --
1637: IF l_debug_on THEN
1638: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1639: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1640: END IF;
1641: --
1642: END GET_CANDIDATE_RECORDS;
1643: