APPS.WSH_PR_PICKING_ROWS dependencies on WSH_PR_PICKING_ROWS

Line 1: PACKAGE BODY WSH_PR_PICKING_ROWS AS

1: PACKAGE BODY WSH_PR_PICKING_ROWS AS
2: /* $Header: WSHPRPRB.pls 115.14 99/07/16 08:20:06 porting ship $ */
3:
4: --
5: -- Package

Line 6: -- WSH_PR_PICKING_ROWS

2: /* $Header: WSHPRPRB.pls 115.14 99/07/16 08:20:06 porting ship $ */
3:
4: --
5: -- Package
6: -- WSH_PR_PICKING_ROWS
7: --
8: -- Purpose
9: -- This package does the following:
10: -- - Open and fetch unreleased line details cursor

Line 182: WSH_UTIL.Write_Log('Starting WSH_PR_PICKING_ROWS.Init');

178: cs BINARY_INTEGER;
179:
180: BEGIN
181:
182: WSH_UTIL.Write_Log('Starting WSH_PR_PICKING_ROWS.Init');
183:
184: IF initialized = TRUE THEN
185: WSH_UTIL.Write_Log('Package already initialized for session');
186: RETURN SUCCESS;

Line 444: WSH_UTIL.Write_Log('Starting WSH_PR_PICKING_ROWS.Open_Execute_Cursor');

440:
441: cs BINARY_INTEGER;
442:
443: BEGIN
444: WSH_UTIL.Write_Log('Starting WSH_PR_PICKING_ROWS.Open_Execute_Cursor');
445: IF p_mode = 'UNRELEASED' THEN
446: -- Open a cursor for unreleased_SQL
447: WSH_UTIL.Write_Log('Processing unreleased cursor');
448: u_cursor := DBMS_SQL.Open_Cursor;

Line 877: WSH_UTIL.Default_Handler('WSH_PR_PICKING_ROWS.Open_Execute_Cursor');

873:
874: EXCEPTION
875: WHEN OTHERS THEN
876: Close_Cursors;
877: WSH_UTIL.Default_Handler('WSH_PR_PICKING_ROWS.Open_Execute_Cursor');
878: RETURN FAILURE;
879:
880: END Open_Execute_Cursor;
881:

Line 1145: WSH_UTIL.Default_Handler('WSH_PR_PICKING_ROWS.Get_Line_Details');

1141:
1142: EXCEPTION
1143: WHEN OTHERS THEN
1144: Close_Cursors;
1145: WSH_UTIL.Default_Handler('WSH_PR_PICKING_ROWS.Get_Line_Details');
1146: call_parameters(2) := FAILURE;
1147:
1148: END Get_Line_Details;
1149:

Line 1321: WSH_UTIL.Default_Handler('WSH_PR_PICKING_ROWS.Get_Line_Details_Pvt');

1317: EXCEPTION
1318: WHEN OTHERS THEN
1319: Close_Cursors;
1320: WSH_UTIL.Write_Log(to_char(line));
1321: WSH_UTIL.Default_Handler('WSH_PR_PICKING_ROWS.Get_Line_Details_Pvt');
1322: RETURN FAILURE;
1323:
1324: END Get_Line_Details_Pvt;
1325:

Line 1786: WSH_UTIL.Default_Handler('WSH_PR_PICKING_ROWS.Open_Execute_Cursor');

1782:
1783: EXCEPTION
1784: WHEN OTHERS THEN
1785: Close_Cursors;
1786: WSH_UTIL.Default_Handler('WSH_PR_PICKING_ROWS.Open_Execute_Cursor');
1787: RETURN FAILURE;
1788:
1789: END Set_Request_Lines;
1790:

Line 1930: WSH_UTIL.Default_Handler('WSH_PR_PICKING_ROWS.Get_Sync_Line_Details');

1926:
1927: EXCEPTION
1928: WHEN OTHERS THEN
1929: Close_Cursors;
1930: WSH_UTIL.Default_Handler('WSH_PR_PICKING_ROWS.Get_Sync_Line_Details');
1931: call_parameters(2) := FAILURE;
1932:
1933: END Get_Sync_Line_Details;
1934:

Line 2047: WSH_UTIL.Default_Handler('WSH_PR_PICKING_ROWS.Get_Non_Ship_Lines');

2043:
2044: EXCEPTION
2045: WHEN OTHERS THEN
2046: Close_Cursors;
2047: WSH_UTIL.Default_Handler('WSH_PR_PICKING_ROWS.Get_Non_Ship_Lines');
2048: call_parameters(2) := FAILURE;
2049:
2050: END Get_Non_Ship_Lines;
2051:

Line 2088: END WSH_PR_PICKING_ROWS;

2084: END IF;
2085:
2086: END Close_Cursors;
2087:
2088: END WSH_PR_PICKING_ROWS;