DBA Data[Home] [Help]

APPS.WSH_ROUTING_REQUEST dependencies on WSH_DEBUG_INTERFACE

Line 119: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;

115: l_debug_on BOOLEAN;
116: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'Create_Address_Record';
117: l_return_status varchar2(1);
118: BEGIN
119: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
120: IF l_debug_on IS NULL THEN
121: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
122: END IF;
123:

Line 188: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;

184: x_return_status OUT NOCOPY VARCHAR2) IS
185: l_debug_on BOOLEAN;
186: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'Create_Line_Record';
187: BEGIN
188: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
189: IF l_debug_on IS NULL THEN
190: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
191: END IF;
192:

Line 255: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;

251: x_return_status OUT NOCOPY VARCHAR2) IS
252: l_debug_on BOOLEAN;
253: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'Create_Delivery_Record';
254: BEGIN
255: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
256: IF l_debug_on IS NULL THEN
257: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
258: END IF;
259:

Line 329: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;

325: l_debug_on BOOLEAN;
326: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' ||
327: 'Create_Header_Record';
328: BEGIN
329: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
330: IF l_debug_on IS NULL THEN
331: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
332: END IF;
333:

Line 393: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;

389: l_index number;
390: l_count number:=0;
391: l_error_count number:=0;
392: BEGIN
393: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
394: IF l_debug_on IS NULL THEN
395: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
396: END IF;
397:

Line 475: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;

471: 'set_message';
472:
473: l_msg varchar2(2000);
474: BEGIN
475: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
476: IF l_debug_on IS NULL THEN
477: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
478: END IF;
479:

Line 539: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;

535:
536: l_msg varchar2(2000);
537: l_new_date date;
538: BEGIN
539: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
540: IF l_debug_on IS NULL THEN
541: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
542: END IF;
543:

Line 612: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;

608: 'Get_Message';
609: l_msg varchar2(23767);
610:
611: BEGIN
612: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
613: IF l_debug_on IS NULL THEN
614: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
615: END IF;
616:

Line 682: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;

678: PROCEDURE Init_Routing_Req_Validation IS
679: l_debug_on BOOLEAN;
680: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'Init_Routing_Req_Validation';
681: BEGIN
682: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
683: IF l_debug_on IS NULL THEN
684: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
685: END IF;
686:

Line 921: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;

917: l_debug_on BOOLEAN;
918: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' ||
919: 'Init_Supplier_Validation';
920: BEGIN
921: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
922: IF l_debug_on IS NULL THEN
923: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
924: END IF;
925:

Line 1060: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;

1056: l_start_index number;
1057: l_end_index number;
1058:
1059: BEGIN
1060: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1061: IF l_debug_on IS NULL THEN
1062: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1063: END IF;
1064:

Line 1171: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;

1167: l_dummy NUMBER;
1168: --
1169:
1170: BEGIN
1171: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1172: IF l_debug_on IS NULL THEN
1173: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1174: END IF;
1175:

Line 1312: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;

1308: 'Process_Address_Line';
1309:
1310: l_error boolean:=false;
1311: BEGIN
1312: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1313: IF l_debug_on IS NULL THEN
1314: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1315: END IF;
1316:

Line 1525: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;

1521: l_prev_line_number number;
1522: l_Address Address_Rec_Type;
1523:
1524: BEGIN
1525: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1526: IF l_debug_on IS NULL THEN
1527: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1528: END IF;
1529:

Line 1767: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;

1763: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'Process_Line';
1764:
1765: l_error boolean:=false;
1766: BEGIN
1767: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1768: IF l_debug_on IS NULL THEN
1769: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1770: END IF;
1771:

Line 1949: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;

1945: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'Process_Delivery';
1946:
1947: l_error boolean:=false;
1948: BEGIN
1949: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1950: IF l_debug_on IS NULL THEN
1951: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1952: END IF;
1953:

Line 2182: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;

2178: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'Process_Header';
2179:
2180: l_error boolean:=false;
2181: BEGIN
2182: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2183: IF l_debug_on IS NULL THEN
2184: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2185: END IF;
2186:

Line 2301: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;

2297: l_num_warnings number;
2298: l_num_errors number;
2299:
2300: BEGIN
2301: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2302: IF l_debug_on IS NULL THEN
2303: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2304: END IF;
2305:

Line 2488: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;

2484: l_party_site_status varchar2(1);
2485: l_party_site_msg varchar2(1000);
2486:
2487: BEGIN
2488: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2489: IF l_debug_on IS NULL THEN
2490: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2491: END IF;
2492:

Line 2698: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;

2694: l_num_errors number;
2695: l_index number;
2696: l_tab_count number;
2697: BEGIN
2698: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2699: IF l_debug_on IS NULL THEN
2700: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2701: END IF;
2702:

Line 2875: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;

2871: l_num_warnings number;
2872: l_num_errors number;
2873:
2874: BEGIN
2875: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2876: IF l_debug_on IS NULL THEN
2877: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2878: END IF;
2879:

Line 3069: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;

3065: l_primary_uom_code varchar2(30);
3066: l_num_warnings number;
3067: l_num_errors number;
3068: BEGIN
3069: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
3070: IF l_debug_on IS NULL THEN
3071: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3072: END IF;
3073:

Line 3380: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;

3376: l_convert_qty number;
3377: l_num_warnings number;
3378: l_num_errors number;
3379: BEGIN
3380: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
3381: IF l_debug_on IS NULL THEN
3382: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3383: END IF;
3384:

Line 3559: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;

3555: l_convert_qty number;
3556: l_num_warnings number;
3557: l_num_errors number;
3558: BEGIN
3559: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
3560: IF l_debug_on IS NULL THEN
3561: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3562: END IF;
3563:

Line 3712: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;

3708:
3709: l_dbi_rs VARCHAR2(1); -- Return Status from DBI API
3710:
3711: BEGIN
3712: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
3713: IF l_debug_on IS NULL THEN
3714: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3715: END IF;
3716:

Line 4031: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;

4027: l_prev_delivery_id number;
4028: l_num_warnings number;
4029: l_num_errors number;
4030: BEGIN
4031: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
4032: IF l_debug_on IS NULL THEN
4033: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
4034: END IF;
4035:

Line 4226: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;

4222: l_num_warnings number;
4223: l_num_errors number;
4224:
4225: BEGIN
4226: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
4227: IF l_debug_on IS NULL THEN
4228: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
4229: END IF;
4230:

Line 4552: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;

4548: l_num_warnings number;
4549: l_num_errors number;
4550:
4551: BEGIN
4552: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
4553: IF l_debug_on IS NULL THEN
4554: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
4555: END IF;
4556:

Line 4733: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;

4729: FROM HR_ORGANIZATION_UNITS
4730: WHERE name = p_org_name;
4731:
4732: BEGIN
4733: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
4734: IF l_debug_on IS NULL THEN
4735: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
4736: END IF;
4737:

Line 4972: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;

4968: l_supplier_name varchar2(2000);
4969: l_organization_id number;
4970:
4971: BEGIN
4972: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
4973: IF l_debug_on IS NULL THEN
4974: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
4975: END IF;
4976:

Line 5839: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;

5835: WSH_UTIL_CORE.G_START_OF_SESSION_API := l_api_session_name;
5836: WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API := FALSE;
5837: END IF;
5838:
5839: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
5840: IF l_debug_on IS NULL THEN
5841: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
5842: END IF;
5843:

Line 6382: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;

6378: BEGIN
6379: x_message_tbl:= WSH_FILE_MSG_TABLE();
6380: x_message_tbl.delete;
6381:
6382: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
6383: IF l_debug_on IS NULL THEN
6384: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
6385: END IF;
6386: