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_PR_PICK_SLIP_NUMBER dependencies on FND_API

Line 26: grouping_rule_id NUMBER := FND_API.G_MISS_NUM,

22: --
23: -- PACKAGE TYPES
24: --
25: TYPE keyRecTyp IS RECORD (
26: grouping_rule_id NUMBER := FND_API.G_MISS_NUM,
27: header_id NUMBER := FND_API.G_MISS_NUM,
28: customer_id NUMBER := FND_API.G_MISS_NUM,
29: ship_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
30: ship_to_loc_id NUMBER := FND_API.G_MISS_NUM,

Line 27: header_id NUMBER := FND_API.G_MISS_NUM,

23: -- PACKAGE TYPES
24: --
25: TYPE keyRecTyp IS RECORD (
26: grouping_rule_id NUMBER := FND_API.G_MISS_NUM,
27: header_id NUMBER := FND_API.G_MISS_NUM,
28: customer_id NUMBER := FND_API.G_MISS_NUM,
29: ship_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
30: ship_to_loc_id NUMBER := FND_API.G_MISS_NUM,
31: shipment_priority VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 28: customer_id NUMBER := FND_API.G_MISS_NUM,

24: --
25: TYPE keyRecTyp IS RECORD (
26: grouping_rule_id NUMBER := FND_API.G_MISS_NUM,
27: header_id NUMBER := FND_API.G_MISS_NUM,
28: customer_id NUMBER := FND_API.G_MISS_NUM,
29: ship_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
30: ship_to_loc_id NUMBER := FND_API.G_MISS_NUM,
31: shipment_priority VARCHAR2(30) := FND_API.G_MISS_CHAR,
32: subinventory VARCHAR2(10) := FND_API.G_MISS_CHAR,

Line 29: ship_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR,

25: TYPE keyRecTyp IS RECORD (
26: grouping_rule_id NUMBER := FND_API.G_MISS_NUM,
27: header_id NUMBER := FND_API.G_MISS_NUM,
28: customer_id NUMBER := FND_API.G_MISS_NUM,
29: ship_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
30: ship_to_loc_id NUMBER := FND_API.G_MISS_NUM,
31: shipment_priority VARCHAR2(30) := FND_API.G_MISS_CHAR,
32: subinventory VARCHAR2(10) := FND_API.G_MISS_CHAR,
33: trip_stop_id NUMBER := FND_API.G_MISS_NUM,

Line 30: ship_to_loc_id NUMBER := FND_API.G_MISS_NUM,

26: grouping_rule_id NUMBER := FND_API.G_MISS_NUM,
27: header_id NUMBER := FND_API.G_MISS_NUM,
28: customer_id NUMBER := FND_API.G_MISS_NUM,
29: ship_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
30: ship_to_loc_id NUMBER := FND_API.G_MISS_NUM,
31: shipment_priority VARCHAR2(30) := FND_API.G_MISS_CHAR,
32: subinventory VARCHAR2(10) := FND_API.G_MISS_CHAR,
33: trip_stop_id NUMBER := FND_API.G_MISS_NUM,
34: delivery_id NUMBER := FND_API.G_MISS_NUM,

Line 31: shipment_priority VARCHAR2(30) := FND_API.G_MISS_CHAR,

27: header_id NUMBER := FND_API.G_MISS_NUM,
28: customer_id NUMBER := FND_API.G_MISS_NUM,
29: ship_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
30: ship_to_loc_id NUMBER := FND_API.G_MISS_NUM,
31: shipment_priority VARCHAR2(30) := FND_API.G_MISS_CHAR,
32: subinventory VARCHAR2(10) := FND_API.G_MISS_CHAR,
33: trip_stop_id NUMBER := FND_API.G_MISS_NUM,
34: delivery_id NUMBER := FND_API.G_MISS_NUM,
35: inventory_item_id NUMBER := FND_API.G_MISS_NUM,

Line 32: subinventory VARCHAR2(10) := FND_API.G_MISS_CHAR,

28: customer_id NUMBER := FND_API.G_MISS_NUM,
29: ship_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
30: ship_to_loc_id NUMBER := FND_API.G_MISS_NUM,
31: shipment_priority VARCHAR2(30) := FND_API.G_MISS_CHAR,
32: subinventory VARCHAR2(10) := FND_API.G_MISS_CHAR,
33: trip_stop_id NUMBER := FND_API.G_MISS_NUM,
34: delivery_id NUMBER := FND_API.G_MISS_NUM,
35: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
36: locator_id NUMBER := FND_API.G_MISS_NUM,

Line 33: trip_stop_id NUMBER := FND_API.G_MISS_NUM,

29: ship_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
30: ship_to_loc_id NUMBER := FND_API.G_MISS_NUM,
31: shipment_priority VARCHAR2(30) := FND_API.G_MISS_CHAR,
32: subinventory VARCHAR2(10) := FND_API.G_MISS_CHAR,
33: trip_stop_id NUMBER := FND_API.G_MISS_NUM,
34: delivery_id NUMBER := FND_API.G_MISS_NUM,
35: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
36: locator_id NUMBER := FND_API.G_MISS_NUM,
37: -- HW OPMCONV - Increate the size of lot_number

Line 34: delivery_id NUMBER := FND_API.G_MISS_NUM,

30: ship_to_loc_id NUMBER := FND_API.G_MISS_NUM,
31: shipment_priority VARCHAR2(30) := FND_API.G_MISS_CHAR,
32: subinventory VARCHAR2(10) := FND_API.G_MISS_CHAR,
33: trip_stop_id NUMBER := FND_API.G_MISS_NUM,
34: delivery_id NUMBER := FND_API.G_MISS_NUM,
35: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
36: locator_id NUMBER := FND_API.G_MISS_NUM,
37: -- HW OPMCONV - Increate the size of lot_number
38: lot_number VARCHAR2(80) := FND_API.G_MISS_CHAR,

Line 35: inventory_item_id NUMBER := FND_API.G_MISS_NUM,

31: shipment_priority VARCHAR2(30) := FND_API.G_MISS_CHAR,
32: subinventory VARCHAR2(10) := FND_API.G_MISS_CHAR,
33: trip_stop_id NUMBER := FND_API.G_MISS_NUM,
34: delivery_id NUMBER := FND_API.G_MISS_NUM,
35: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
36: locator_id NUMBER := FND_API.G_MISS_NUM,
37: -- HW OPMCONV - Increate the size of lot_number
38: lot_number VARCHAR2(80) := FND_API.G_MISS_CHAR,
39: revision VARCHAR2(3) := FND_API.G_MISS_CHAR,

Line 36: locator_id NUMBER := FND_API.G_MISS_NUM,

32: subinventory VARCHAR2(10) := FND_API.G_MISS_CHAR,
33: trip_stop_id NUMBER := FND_API.G_MISS_NUM,
34: delivery_id NUMBER := FND_API.G_MISS_NUM,
35: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
36: locator_id NUMBER := FND_API.G_MISS_NUM,
37: -- HW OPMCONV - Increate the size of lot_number
38: lot_number VARCHAR2(80) := FND_API.G_MISS_CHAR,
39: revision VARCHAR2(3) := FND_API.G_MISS_CHAR,
40: organization_id NUMBER := FND_API.G_MISS_NUM,

Line 38: lot_number VARCHAR2(80) := FND_API.G_MISS_CHAR,

34: delivery_id NUMBER := FND_API.G_MISS_NUM,
35: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
36: locator_id NUMBER := FND_API.G_MISS_NUM,
37: -- HW OPMCONV - Increate the size of lot_number
38: lot_number VARCHAR2(80) := FND_API.G_MISS_CHAR,
39: revision VARCHAR2(3) := FND_API.G_MISS_CHAR,
40: organization_id NUMBER := FND_API.G_MISS_NUM,
41: pick_slip_number NUMBER := FND_API.G_MISS_NUM,
42: counter NUMBER := FND_API.G_MISS_NUM

Line 39: revision VARCHAR2(3) := FND_API.G_MISS_CHAR,

35: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
36: locator_id NUMBER := FND_API.G_MISS_NUM,
37: -- HW OPMCONV - Increate the size of lot_number
38: lot_number VARCHAR2(80) := FND_API.G_MISS_CHAR,
39: revision VARCHAR2(3) := FND_API.G_MISS_CHAR,
40: organization_id NUMBER := FND_API.G_MISS_NUM,
41: pick_slip_number NUMBER := FND_API.G_MISS_NUM,
42: counter NUMBER := FND_API.G_MISS_NUM
43: );

Line 40: organization_id NUMBER := FND_API.G_MISS_NUM,

36: locator_id NUMBER := FND_API.G_MISS_NUM,
37: -- HW OPMCONV - Increate the size of lot_number
38: lot_number VARCHAR2(80) := FND_API.G_MISS_CHAR,
39: revision VARCHAR2(3) := FND_API.G_MISS_CHAR,
40: organization_id NUMBER := FND_API.G_MISS_NUM,
41: pick_slip_number NUMBER := FND_API.G_MISS_NUM,
42: counter NUMBER := FND_API.G_MISS_NUM
43: );
44:

Line 41: pick_slip_number NUMBER := FND_API.G_MISS_NUM,

37: -- HW OPMCONV - Increate the size of lot_number
38: lot_number VARCHAR2(80) := FND_API.G_MISS_CHAR,
39: revision VARCHAR2(3) := FND_API.G_MISS_CHAR,
40: organization_id NUMBER := FND_API.G_MISS_NUM,
41: pick_slip_number NUMBER := FND_API.G_MISS_NUM,
42: counter NUMBER := FND_API.G_MISS_NUM
43: );
44:
45:

Line 42: counter NUMBER := FND_API.G_MISS_NUM

38: lot_number VARCHAR2(80) := FND_API.G_MISS_CHAR,
39: revision VARCHAR2(3) := FND_API.G_MISS_CHAR,
40: organization_id NUMBER := FND_API.G_MISS_NUM,
41: pick_slip_number NUMBER := FND_API.G_MISS_NUM,
42: counter NUMBER := FND_API.G_MISS_NUM
43: );
44:
45:
46: TYPE keyTabTyp IS TABLE OF keyRecTyp INDEX BY BINARY_INTEGER;

Line 49: grouping_rule_id NUMBER := FND_API.G_MISS_NUM,

45:
46: TYPE keyTabTyp IS TABLE OF keyRecTyp INDEX BY BINARY_INTEGER;
47:
48: TYPE grpRecTyp IS RECORD (
49: grouping_rule_id NUMBER := FND_API.G_MISS_NUM,
50: use_order_ps VARCHAR2(1) := 'N',
51: use_sub_ps VARCHAR2(1) := 'N',
52: use_customer_ps VARCHAR2(1) := 'N',
53: use_ship_to_ps VARCHAR2(1) := 'N',

Line 102: -- x_api_status => FND_API.G_RET_STS_SUCESSS or

98: -- this is passed on for an entire Batch,
99: -- ie. when a particular P.slip No. is not specified
100: --
101: -- Output Parameters
102: -- x_api_status => FND_API.G_RET_STS_SUCESSS or
103: -- FND_API.G_RET_STS_ERROR or
104: -- FND_API.G_RET_STS_UNEXP_ERROR
105: --
106: PROCEDURE Print_Pvt (

Line 103: -- FND_API.G_RET_STS_ERROR or

99: -- ie. when a particular P.slip No. is not specified
100: --
101: -- Output Parameters
102: -- x_api_status => FND_API.G_RET_STS_SUCESSS or
103: -- FND_API.G_RET_STS_ERROR or
104: -- FND_API.G_RET_STS_UNEXP_ERROR
105: --
106: PROCEDURE Print_Pvt (
107: p_report_set_id IN NUMBER,

Line 104: -- FND_API.G_RET_STS_UNEXP_ERROR

100: --
101: -- Output Parameters
102: -- x_api_status => FND_API.G_RET_STS_SUCESSS or
103: -- FND_API.G_RET_STS_ERROR or
104: -- FND_API.G_RET_STS_UNEXP_ERROR
105: --
106: PROCEDURE Print_Pvt (
107: p_report_set_id IN NUMBER,
108: p_organization_id IN NUMBER,

Line 272: -- x_api_status => FND_API.G_RET_STS_SUCESSS or

268: -- p_order_header_id => Order Header id
269: -- p_batch_id => Batch Id of the Picking Batch id
270: --
271: -- Output Parameters
272: -- x_api_status => FND_API.G_RET_STS_SUCESSS or
273: -- FND_API.G_RET_STS_ERROR or
274: -- FND_API.G_RET_STS_UNEXP_ERROR
275: -- x_error_message => Error message
276: --

Line 273: -- FND_API.G_RET_STS_ERROR or

269: -- p_batch_id => Batch Id of the Picking Batch id
270: --
271: -- Output Parameters
272: -- x_api_status => FND_API.G_RET_STS_SUCESSS or
273: -- FND_API.G_RET_STS_ERROR or
274: -- FND_API.G_RET_STS_UNEXP_ERROR
275: -- x_error_message => Error message
276: --
277: PROCEDURE Print_Pick_Slip (

Line 274: -- FND_API.G_RET_STS_UNEXP_ERROR

270: --
271: -- Output Parameters
272: -- x_api_status => FND_API.G_RET_STS_SUCESSS or
273: -- FND_API.G_RET_STS_ERROR or
274: -- FND_API.G_RET_STS_UNEXP_ERROR
275: -- x_error_message => Error message
276: --
277: PROCEDURE Print_Pick_Slip (
278: p_pick_slip_number IN NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 278: p_pick_slip_number IN NUMBER DEFAULT FND_API.G_MISS_NUM,

274: -- FND_API.G_RET_STS_UNEXP_ERROR
275: -- x_error_message => Error message
276: --
277: PROCEDURE Print_Pick_Slip (
278: p_pick_slip_number IN NUMBER DEFAULT FND_API.G_MISS_NUM,
279: p_report_set_id IN NUMBER,
280: p_organization_id IN NUMBER,
281: p_order_header_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
282: p_batch_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 281: p_order_header_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,

277: PROCEDURE Print_Pick_Slip (
278: p_pick_slip_number IN NUMBER DEFAULT FND_API.G_MISS_NUM,
279: p_report_set_id IN NUMBER,
280: p_organization_id IN NUMBER,
281: p_order_header_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
282: p_batch_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
283: p_ps_mode IN VARCHAR2 DEFAULT NULL,
284: x_api_status OUT NOCOPY VARCHAR2,
285: x_error_message OUT NOCOPY VARCHAR2 )

Line 282: p_batch_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,

278: p_pick_slip_number IN NUMBER DEFAULT FND_API.G_MISS_NUM,
279: p_report_set_id IN NUMBER,
280: p_organization_id IN NUMBER,
281: p_order_header_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
282: p_batch_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
283: p_ps_mode IN VARCHAR2 DEFAULT NULL,
284: x_api_status OUT NOCOPY VARCHAR2,
285: x_error_message OUT NOCOPY VARCHAR2 )
286: IS

Line 351: x_api_status := FND_API.G_RET_STS_SUCCESS;

347: ELSE
348: l_index := g_pskey_table.first;
349: END IF;
350: --
351: x_api_status := FND_API.G_RET_STS_SUCCESS;
352: IF l_debug_on THEN
353: WSH_DEBUG_SV.log(l_module_name,'l_index',l_index);
354: END IF;
355:

Line 358: x_api_status := FND_API.G_RET_STS_SUCCESS;

354: END IF;
355:
356: -- If report set id is NULL, there is no report to print
357: IF (WSH_PICK_LIST.G_SEED_DOC_SET IS NULL) THEN
358: x_api_status := FND_API.G_RET_STS_SUCCESS;
359: --
360: IF l_debug_on THEN
361: WSH_DEBUG_SV.log(l_module_name,'there is no report to print');
362: WSH_DEBUG_SV.pop(l_module_name);

Line 371: IF (p_pick_slip_number = FND_API.G_MISS_NUM) THEN

367:
368: -- Added if condition IF WSH_PICK_LIST.G_PICK_REL_PARALLEL for
369: -- parallel pick-release
370:
371: IF (p_pick_slip_number = FND_API.G_MISS_NUM) THEN
372: IF (p_ps_mode = 'I') THEN
373: -- Loop through the pl-sql table to print the remaining pick slips
374: IF WSH_PICK_LIST.G_PICK_REL_PARALLEL THEN
375: OPEN ps_list;

Line 444: IF x_api_status <> FND_API.G_RET_STS_SUCCESS THEN

440: p_ps_mode => p_ps_mode ,
441: x_api_status => x_api_status);
442: END IF;
443:
444: IF x_api_status <> FND_API.G_RET_STS_SUCCESS THEN
445: x_error_message := 'Error occurred in call to ' ||
446: 'Print_Pvt in ' ||
447: 'WSH_PR_PICK_SLIP_NUMBER.Print_Pick_Slip';
448: IF l_debug_on THEN

Line 462: x_api_status := FND_API.G_RET_STS_UNEXP_ERROR;

458: --
459: EXCEPTION
460: WHEN OTHERS THEN
461: x_error_message := 'Exception occurred in WSH_PR_PICK_SLIP_NUMBER.Print_Pick_Slip';
462: x_api_status := FND_API.G_RET_STS_UNEXP_ERROR;
463: --
464: IF l_debug_on THEN
465: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
466: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 747: -- x_ready_to_print => FND_API.G_TRUE or FND_API.G_FALSE

743: -- p_revision => revision
744: --
745: -- Output Parameters
746: -- x_pick_slip_number => pick_slip_number
747: -- x_ready_to_print => FND_API.G_TRUE or FND_API.G_FALSE
748: -- x_api_status => FND_API.G_RET_STS_SUCESSS or
749: -- FND_API.G_RET_STS_ERROR or
750: -- FND_API.G_RET_STS_UNEXP_ERROR
751: -- x_error_message => Error message

Line 748: -- x_api_status => FND_API.G_RET_STS_SUCESSS or

744: --
745: -- Output Parameters
746: -- x_pick_slip_number => pick_slip_number
747: -- x_ready_to_print => FND_API.G_TRUE or FND_API.G_FALSE
748: -- x_api_status => FND_API.G_RET_STS_SUCESSS or
749: -- FND_API.G_RET_STS_ERROR or
750: -- FND_API.G_RET_STS_UNEXP_ERROR
751: -- x_error_message => Error message
752: --

Line 749: -- FND_API.G_RET_STS_ERROR or

745: -- Output Parameters
746: -- x_pick_slip_number => pick_slip_number
747: -- x_ready_to_print => FND_API.G_TRUE or FND_API.G_FALSE
748: -- x_api_status => FND_API.G_RET_STS_SUCESSS or
749: -- FND_API.G_RET_STS_ERROR or
750: -- FND_API.G_RET_STS_UNEXP_ERROR
751: -- x_error_message => Error message
752: --
753: PROCEDURE Get_Pick_Slip_Number (

Line 750: -- FND_API.G_RET_STS_UNEXP_ERROR

746: -- x_pick_slip_number => pick_slip_number
747: -- x_ready_to_print => FND_API.G_TRUE or FND_API.G_FALSE
748: -- x_api_status => FND_API.G_RET_STS_SUCESSS or
749: -- FND_API.G_RET_STS_ERROR or
750: -- FND_API.G_RET_STS_UNEXP_ERROR
751: -- x_error_message => Error message
752: --
753: PROCEDURE Get_Pick_Slip_Number (
754: p_ps_mode IN VARCHAR2,

Line 843: x_api_status := FND_API.G_RET_STS_ERROR;

839: IF get_limit%NOTFOUND THEN
840: x_error_message := 'Organization ' ||
841: to_char(p_org_id) ||
842: ' does not exist. ';
843: x_api_status := FND_API.G_RET_STS_ERROR;
844: RETURN;
845: END IF;
846: g_prev_org_id := p_org_id;
847: g_pickslip_limit := l_limit;

Line 853: x_ready_to_print := FND_API.G_FALSE;

849: END IF;
850:
851:
852: -- Set ready to print flag to FALSE initially
853: x_ready_to_print := FND_API.G_FALSE;
854:
855: -- find grouping rule in table
856: l_found := FALSE;
857:

Line 874: x_api_status := FND_API.G_RET_STS_SUCCESS;

870: SELECT WSH_PICK_SLIP_NUMBERS_S.NEXTVAL
871: INTO x_pick_slip_number
872: FROM DUAL;
873:
874: x_api_status := FND_API.G_RET_STS_SUCCESS;
875: RETURN;
876: END IF;
877: -- Create hash for g_pskey table here instead of in Insert_Key
878:

Line 901: x_api_status := FND_API.G_RET_STS_ERROR;

897: IF ps_rule%NOTFOUND THEN
898: x_error_message := 'Pick grouping rule '
899: || to_char(p_pick_grouping_rule_id) ||
900: ' does not exist';
901: x_api_status := FND_API.G_RET_STS_ERROR;
902: RETURN;
903: END IF;
904:
905: g_rule_table(l_rule_index).grouping_rule_id := p_pick_grouping_rule_id;

Line 941: x_api_status := FND_API.G_RET_STS_SUCCESS;

937: l_Insert_key_Rec => l_Insert_key_Rec,
938: x_pick_slip_number => x_pick_slip_number,
939: x_error_message => x_error_message);
940: END IF;
941: x_api_status := FND_API.G_RET_STS_SUCCESS;
942: RETURN;
943:
944: END IF;
945:

Line 978: x_ready_to_print := FND_API.G_TRUE;

974:
975: -- Print is immediate so check if limit has been reached
976: IF (p_ps_mode = 'I' AND l_limit <> -1) THEN
977: IF (g_pskey_table(l_hash_value).counter >= l_limit) THEN
978: x_ready_to_print := FND_API.G_TRUE;
979: g_print_ps_table(g_print_ps_table.count + 1) := x_pick_slip_number;
980: g_pskey_table.delete(l_hash_value);
981: END IF;
982: END IF;

Line 992: x_api_status := FND_API.G_RET_STS_SUCCESS;

988: x_pick_slip_number => x_pick_slip_number,
989: x_error_message => x_error_message);
990: END IF;
991:
992: x_api_status := FND_API.G_RET_STS_SUCCESS;
993: EXCEPTION
994: WHEN OTHERS THEN
995: x_error_message := 'Error occurred in WSH_PR_PICK_NUMBER.Get_Pick_Slip_Number';
996: x_api_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 996: x_api_status := FND_API.G_RET_STS_UNEXP_ERROR;

992: x_api_status := FND_API.G_RET_STS_SUCCESS;
993: EXCEPTION
994: WHEN OTHERS THEN
995: x_error_message := 'Error occurred in WSH_PR_PICK_NUMBER.Get_Pick_Slip_Number';
996: x_api_status := FND_API.G_RET_STS_UNEXP_ERROR;
997: END Get_Pick_Slip_Number;
998:
999: --
1000: -- Name

Line 1017: x_api_status := FND_API.G_RET_STS_SUCCESS;

1013: ( x_api_status OUT NOCOPY VARCHAR2,
1014: x_error_message OUT NOCOPY VARCHAR2 ) IS
1015: BEGIN
1016:
1017: x_api_status := FND_API.G_RET_STS_SUCCESS;
1018: IF WSH_CODE_CONTROL.Get_Code_Release_Level >= '110509'
1019: THEN
1020: INV_PR_PICK_SLIP_NUMBER.g_pskey_table.delete ;
1021: ELSE

Line 1028: x_api_status := FND_API.G_RET_STS_UNEXP_ERROR;

1024:
1025: EXCEPTION
1026: WHEN OTHERS THEN
1027: x_error_message := 'Error occurred in WSH_PR_PICK_NUMBER.DELETE_PS_TBL: ' || SQLERRM;
1028: x_api_status := FND_API.G_RET_STS_UNEXP_ERROR;
1029: END DELETE_PS_TBL ;
1030:
1031: END WSH_PR_PICK_SLIP_NUMBER;