APPS.WMS_TASK_MGMT_PUB dependencies on FND_API

Line 23: g_main_tab(5).field_value := FND_API.G_FALSE;

19: g_main_tab(3).field_value := NULL;
20: g_main_tab(4).field_name := 'CATEGORY_SET_ID';
21: g_main_tab(4).field_value := NULL;
22: g_main_tab(5).field_name := 'COMPLETED';
23: g_main_tab(5).field_value := FND_API.G_FALSE;
24: g_main_tab(6).field_name := 'CUSTOMER_CATEGORY';
25: g_main_tab(6).field_value := NULL;
26: g_main_tab(7).field_name := 'CUSTOMER_ID';
27: g_main_tab(7).field_value := NULL;

Line 31: g_main_tab(9).field_value := FND_API.G_TRUE;

27: g_main_tab(7).field_value := NULL;
28: g_main_tab(8).field_name := 'CYCLE_COUNT_NAME';
29: g_main_tab(8).field_value := NULL;
30: g_main_tab(9).field_name := 'CYCLE_COUNT_TASKS';
31: g_main_tab(9).field_value := FND_API.G_TRUE;
32: g_main_tab(10).field_name := 'DELIVERY_ID';
33: g_main_tab(10).field_value := NULL;
34: g_main_tab(11).field_name := 'DEPARTMENT_ID';
35: g_main_tab(11).field_value := NULL;

Line 37: g_main_tab(12).field_value := FND_API.G_FALSE;

33: g_main_tab(10).field_value := NULL;
34: g_main_tab(11).field_name := 'DEPARTMENT_ID';
35: g_main_tab(11).field_value := NULL;
36: g_main_tab(12).field_name := 'DISPATCHED';
37: g_main_tab(12).field_value := FND_API.G_FALSE;
38: g_main_tab(13).field_name := 'EMPLOYEE_ID';
39: g_main_tab(13).field_value := NULL;
40: ---add equipment
41: g_main_tab(14).field_name := 'EQUIPMENT';

Line 84: g_main_tab(35).field_value := FND_API.G_FALSE;

80: g_main_tab(33).field_value := NULL;
81: g_main_tab(34).field_name := 'FROM_TRANSFER_ISSUE_MO'; --33
82: g_main_tab(34).field_value := NULL;
83: g_main_tab(35).field_name := 'INBOUND'; --34
84: g_main_tab(35).field_value := FND_API.G_FALSE;
85: g_main_tab(36).field_name := 'INDEPENDENT_TASKS'; --35
86: g_main_tab(36).field_value := FND_API.G_TRUE;
87: g_main_tab(37).field_name := 'INVENTORY_ITEM_ID'; --36
88: g_main_tab(37).field_value := NULL;

Line 86: g_main_tab(36).field_value := FND_API.G_TRUE;

82: g_main_tab(34).field_value := NULL;
83: g_main_tab(35).field_name := 'INBOUND'; --34
84: g_main_tab(35).field_value := FND_API.G_FALSE;
85: g_main_tab(36).field_name := 'INDEPENDENT_TASKS'; --35
86: g_main_tab(36).field_value := FND_API.G_TRUE;
87: g_main_tab(37).field_name := 'INVENTORY_ITEM_ID'; --36
88: g_main_tab(37).field_value := NULL;
89: g_main_tab(38).field_name := 'ITEM_CATEGORY_ID'; --37
90: g_main_tab(38).field_value := NULL;

Line 92: g_main_tab(39).field_value := FND_API.G_FALSE;

88: g_main_tab(37).field_value := NULL;
89: g_main_tab(38).field_name := 'ITEM_CATEGORY_ID'; --37
90: g_main_tab(38).field_value := NULL;
91: g_main_tab(39).field_name := 'LOADED'; --38
92: g_main_tab(39).field_value := FND_API.G_FALSE;
93: g_main_tab(40).field_name := 'LOCATOR_ID'; --39
94: g_main_tab(40).field_value := NULL;
95: g_main_tab(41).field_name := 'LPN_PUTAWAY_TASKS'; --40
96: g_main_tab(41).field_value := FND_API.G_TRUE;

Line 96: g_main_tab(41).field_value := FND_API.G_TRUE;

92: g_main_tab(39).field_value := FND_API.G_FALSE;
93: g_main_tab(40).field_name := 'LOCATOR_ID'; --39
94: g_main_tab(40).field_value := NULL;
95: g_main_tab(41).field_name := 'LPN_PUTAWAY_TASKS'; --40
96: g_main_tab(41).field_value := FND_API.G_TRUE;
97: g_main_tab(42).field_name := 'MANUFACTURING'; --41
98: g_main_tab(42).field_value := FND_API.G_FALSE;
99: g_main_tab(43).field_name := 'MANUFACTURING_TYPE'; --42
100: g_main_tab(43).field_value := NULL;

Line 98: g_main_tab(42).field_value := FND_API.G_FALSE;

94: g_main_tab(40).field_value := NULL;
95: g_main_tab(41).field_name := 'LPN_PUTAWAY_TASKS'; --40
96: g_main_tab(41).field_value := FND_API.G_TRUE;
97: g_main_tab(42).field_name := 'MANUFACTURING'; --41
98: g_main_tab(42).field_value := FND_API.G_FALSE;
99: g_main_tab(43).field_name := 'MANUFACTURING_TYPE'; --42
100: g_main_tab(43).field_value := NULL;
101: g_main_tab(44).field_name := 'MO_ISSUE_TASKS'; --43
102: g_main_tab(44).field_value := FND_API.G_TRUE;

Line 102: g_main_tab(44).field_value := FND_API.G_TRUE;

98: g_main_tab(42).field_value := FND_API.G_FALSE;
99: g_main_tab(43).field_name := 'MANUFACTURING_TYPE'; --42
100: g_main_tab(43).field_value := NULL;
101: g_main_tab(44).field_name := 'MO_ISSUE_TASKS'; --43
102: g_main_tab(44).field_value := FND_API.G_TRUE;
103: g_main_tab(45).field_name := 'MO_TRANSFER_TASKS'; --44
104: g_main_tab(45).field_value := FND_API.G_TRUE;
105: g_main_tab(46).field_name := 'OP_PLAN_ACTIVITY_ID'; --45
106: g_main_tab(46).field_value := NULL;

Line 104: g_main_tab(45).field_value := FND_API.G_TRUE;

100: g_main_tab(43).field_value := NULL;
101: g_main_tab(44).field_name := 'MO_ISSUE_TASKS'; --43
102: g_main_tab(44).field_value := FND_API.G_TRUE;
103: g_main_tab(45).field_name := 'MO_TRANSFER_TASKS'; --44
104: g_main_tab(45).field_value := FND_API.G_TRUE;
105: g_main_tab(46).field_name := 'OP_PLAN_ACTIVITY_ID'; --45
106: g_main_tab(46).field_value := NULL;
107: g_main_tab(47).field_name := 'OP_PLAN_ID'; --46
108: g_main_tab(47).field_value := NULL;

Line 115: g_main_tab(50).field_value := FND_API.G_FALSE;

111: ---add ORDER_TYPE
112: g_main_tab(49).field_name := 'ORDER_TYPE';
113: g_main_tab(49).field_value := NULL;
114: g_main_tab(50).field_name := 'OUTBOUND'; ---48
115: g_main_tab(50).field_value := FND_API.G_FALSE;
116: g_main_tab(51).field_name := 'PENDING'; --49
117: g_main_tab(51).field_value := FND_API.G_FALSE;
118: g_main_tab(52).field_name := 'PERSON_RESOURCE_ID'; --50
119: g_main_tab(52).field_value := NULL;

Line 117: g_main_tab(51).field_value := FND_API.G_FALSE;

113: g_main_tab(49).field_value := NULL;
114: g_main_tab(50).field_name := 'OUTBOUND'; ---48
115: g_main_tab(50).field_value := FND_API.G_FALSE;
116: g_main_tab(51).field_name := 'PENDING'; --49
117: g_main_tab(51).field_value := FND_API.G_FALSE;
118: g_main_tab(52).field_name := 'PERSON_RESOURCE_ID'; --50
119: g_main_tab(52).field_value := NULL;
120: g_main_tab(53).field_name := 'PLAN_ABORTED'; --51
121: g_main_tab(53).field_value := FND_API.G_FALSE;

Line 121: g_main_tab(53).field_value := FND_API.G_FALSE;

117: g_main_tab(51).field_value := FND_API.G_FALSE;
118: g_main_tab(52).field_name := 'PERSON_RESOURCE_ID'; --50
119: g_main_tab(52).field_value := NULL;
120: g_main_tab(53).field_name := 'PLAN_ABORTED'; --51
121: g_main_tab(53).field_value := FND_API.G_FALSE;
122: g_main_tab(54).field_name := 'PLAN_CANCELLED'; --52
123: g_main_tab(54).field_value := FND_API.G_FALSE;
124: g_main_tab(55).field_name := 'PLAN_COMPLETED'; --53
125: g_main_tab(55).field_value := FND_API.G_FALSE;

Line 123: g_main_tab(54).field_value := FND_API.G_FALSE;

119: g_main_tab(52).field_value := NULL;
120: g_main_tab(53).field_name := 'PLAN_ABORTED'; --51
121: g_main_tab(53).field_value := FND_API.G_FALSE;
122: g_main_tab(54).field_name := 'PLAN_CANCELLED'; --52
123: g_main_tab(54).field_value := FND_API.G_FALSE;
124: g_main_tab(55).field_name := 'PLAN_COMPLETED'; --53
125: g_main_tab(55).field_value := FND_API.G_FALSE;
126: g_main_tab(56).field_name := 'PLAN_IN_PROGRESS'; --54
127: g_main_tab(56).field_value := FND_API.G_FALSE;

Line 125: g_main_tab(55).field_value := FND_API.G_FALSE;

121: g_main_tab(53).field_value := FND_API.G_FALSE;
122: g_main_tab(54).field_name := 'PLAN_CANCELLED'; --52
123: g_main_tab(54).field_value := FND_API.G_FALSE;
124: g_main_tab(55).field_name := 'PLAN_COMPLETED'; --53
125: g_main_tab(55).field_value := FND_API.G_FALSE;
126: g_main_tab(56).field_name := 'PLAN_IN_PROGRESS'; --54
127: g_main_tab(56).field_value := FND_API.G_FALSE;
128: g_main_tab(57).field_name := 'PLAN_PENDING'; --55
129: g_main_tab(57).field_value := FND_API.G_FALSE;

Line 127: g_main_tab(56).field_value := FND_API.G_FALSE;

123: g_main_tab(54).field_value := FND_API.G_FALSE;
124: g_main_tab(55).field_name := 'PLAN_COMPLETED'; --53
125: g_main_tab(55).field_value := FND_API.G_FALSE;
126: g_main_tab(56).field_name := 'PLAN_IN_PROGRESS'; --54
127: g_main_tab(56).field_value := FND_API.G_FALSE;
128: g_main_tab(57).field_name := 'PLAN_PENDING'; --55
129: g_main_tab(57).field_value := FND_API.G_FALSE;
130: g_main_tab(58).field_name := 'PLANNED_TASKS'; --56
131: g_main_tab(58).field_value := FND_API.G_TRUE;

Line 129: g_main_tab(57).field_value := FND_API.G_FALSE;

125: g_main_tab(55).field_value := FND_API.G_FALSE;
126: g_main_tab(56).field_name := 'PLAN_IN_PROGRESS'; --54
127: g_main_tab(56).field_value := FND_API.G_FALSE;
128: g_main_tab(57).field_name := 'PLAN_PENDING'; --55
129: g_main_tab(57).field_value := FND_API.G_FALSE;
130: g_main_tab(58).field_name := 'PLANNED_TASKS'; --56
131: g_main_tab(58).field_value := FND_API.G_TRUE;
132: g_main_tab(59).field_name := 'QUEUED'; --57
133: g_main_tab(59).field_value := FND_API.G_FALSE;

Line 131: g_main_tab(58).field_value := FND_API.G_TRUE;

127: g_main_tab(56).field_value := FND_API.G_FALSE;
128: g_main_tab(57).field_name := 'PLAN_PENDING'; --55
129: g_main_tab(57).field_value := FND_API.G_FALSE;
130: g_main_tab(58).field_name := 'PLANNED_TASKS'; --56
131: g_main_tab(58).field_value := FND_API.G_TRUE;
132: g_main_tab(59).field_name := 'QUEUED'; --57
133: g_main_tab(59).field_value := FND_API.G_FALSE;
134: g_main_tab(60).field_name := 'REPLENISHMENT_TASKS'; --58
135: g_main_tab(60).field_value := FND_API.G_TRUE;

Line 133: g_main_tab(59).field_value := FND_API.G_FALSE;

129: g_main_tab(57).field_value := FND_API.G_FALSE;
130: g_main_tab(58).field_name := 'PLANNED_TASKS'; --56
131: g_main_tab(58).field_value := FND_API.G_TRUE;
132: g_main_tab(59).field_name := 'QUEUED'; --57
133: g_main_tab(59).field_value := FND_API.G_FALSE;
134: g_main_tab(60).field_name := 'REPLENISHMENT_TASKS'; --58
135: g_main_tab(60).field_value := FND_API.G_TRUE;
136: g_main_tab(61).field_name := 'SHIP_METHOD_CODE'; --59
137: g_main_tab(61).field_value := NULL;

Line 135: g_main_tab(60).field_value := FND_API.G_TRUE;

131: g_main_tab(58).field_value := FND_API.G_TRUE;
132: g_main_tab(59).field_name := 'QUEUED'; --57
133: g_main_tab(59).field_value := FND_API.G_FALSE;
134: g_main_tab(60).field_name := 'REPLENISHMENT_TASKS'; --58
135: g_main_tab(60).field_value := FND_API.G_TRUE;
136: g_main_tab(61).field_name := 'SHIP_METHOD_CODE'; --59
137: g_main_tab(61).field_value := NULL;
138: g_main_tab(62).field_name := 'SHIP_TO_COUNTRY'; --60
139: g_main_tab(62).field_value := NULL;

Line 147: g_main_tab(66).field_value := FND_API.G_FALSE;

143: g_main_tab(64).field_value := NULL;
144: g_main_tab(65).field_name := 'SHIPMENT_PRIORITY'; --63
145: g_main_tab(65).field_value := NULL;
146: g_main_tab(66).field_name := 'STAGING_MOVE'; --64
147: g_main_tab(66).field_value := FND_API.G_FALSE;
148: g_main_tab(67).field_name := 'SUBINVENTORY'; --65
149: g_main_tab(67).field_value := NULL;
150: g_main_tab(68).field_name := 'TO_CREATION_DATE'; --66
151: g_main_tab(68).field_value := NULL;

Line 195: g_main_tab(90).field_value := FND_API.G_FALSE;

191: g_main_tab(88).field_value := NULL;
192: g_main_tab(89).field_name := 'TRIP_ID'; --87
193: g_main_tab(89).field_value := NULL;
194: g_main_tab(90).field_name := 'UNRELEASED'; --88
195: g_main_tab(90).field_value := FND_API.G_FALSE;
196: g_main_tab(91).field_name := 'USER_TASK_TYPE_ID'; --89
197: g_main_tab(91).field_value := NULL;
198: g_main_tab(92).field_name := 'WAREHOUSING'; --90
199: g_main_tab(92).field_value := FND_API.G_FALSE;

Line 199: g_main_tab(92).field_value := FND_API.G_FALSE;

195: g_main_tab(90).field_value := FND_API.G_FALSE;
196: g_main_tab(91).field_name := 'USER_TASK_TYPE_ID'; --89
197: g_main_tab(91).field_value := NULL;
198: g_main_tab(92).field_name := 'WAREHOUSING'; --90
199: g_main_tab(92).field_value := FND_API.G_FALSE;
200: g_main_tab(93).field_name := 'CROSSDOCK'; --91--Munish added column for crossdock
201: g_main_tab(93).field_value := FND_API.G_FALSE; --Munish initialized column value for crossdock
202: END initialize_main_table;
203:

Line 201: g_main_tab(93).field_value := FND_API.G_FALSE; --Munish initialized column value for crossdock

197: g_main_tab(91).field_value := NULL;
198: g_main_tab(92).field_name := 'WAREHOUSING'; --90
199: g_main_tab(92).field_value := FND_API.G_FALSE;
200: g_main_tab(93).field_name := 'CROSSDOCK'; --91--Munish added column for crossdock
201: g_main_tab(93).field_value := FND_API.G_FALSE; --Munish initialized column value for crossdock
202: END initialize_main_table;
203:
204: -------------------------------------------------------------------------------------------------------------------
205: /*Procedure to log error message to the x_updated_tasks rec*/

Line 308: x_return_status := fnd_api.g_ret_sts_success;

304: l_delivery_id NUMBER;
305: l_carton_lpn_itm_id NUMBER;
306:
307: BEGIN
308: x_return_status := fnd_api.g_ret_sts_success;
309: OPEN carton_lpn_csr(p_new_carton_lpn_id);
310: FETCH carton_lpn_csr INTO l_carton_lpn_ctx,l_carton_lpn_org,l_carton_lpn_itm_id;
311: CLOSE carton_lpn_csr;
312: --if carton lpn is passed and is not valid then no need to proceed further

Line 314: x_return_status := fnd_api.g_ret_sts_error;

310: FETCH carton_lpn_csr INTO l_carton_lpn_ctx,l_carton_lpn_org,l_carton_lpn_itm_id;
311: CLOSE carton_lpn_csr;
312: --if carton lpn is passed and is not valid then no need to proceed further
313: IF(l_carton_lpn_ctx NOT IN (5,8)) THEN
314: x_return_status := fnd_api.g_ret_sts_error;
315: fnd_message.set_name('WMS', 'WMS_CARTON_LPN_CTX_ERR');
316: fnd_msg_pub.ADD;
317: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE, p_count => l_msg_count, p_data => x_error_msg );
318: l_error_msg :='Invalid context for Carton LPN:'||p_new_carton_lpn_id;

Line 317: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE, p_count => l_msg_count, p_data => x_error_msg );

313: IF(l_carton_lpn_ctx NOT IN (5,8)) THEN
314: x_return_status := fnd_api.g_ret_sts_error;
315: fnd_message.set_name('WMS', 'WMS_CARTON_LPN_CTX_ERR');
316: fnd_msg_pub.ADD;
317: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE, p_count => l_msg_count, p_data => x_error_msg );
318: l_error_msg :='Invalid context for Carton LPN:'||p_new_carton_lpn_id;
319: IF(l_debug = 1) THEN
320: inv_trx_util_pub.trace(l_api_name|| ': '||l_error_msg);
321: END IF;

Line 324: x_return_status := fnd_api.g_ret_sts_error;

320: inv_trx_util_pub.trace(l_api_name|| ': '||l_error_msg);
321: END IF;
322: RETURN;
323: ELSIF (l_carton_lpn_itm_id is NULL) THEN
324: x_return_status := fnd_api.g_ret_sts_error;
325: fnd_message.set_name('WMS', 'WMS_CARTONIZATION_ERR');
326: fnd_msg_pub.ADD;
327: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE, p_count => l_msg_count, p_data => x_error_msg );
328: l_error_msg :='Inventory item id is not present in carton LPN';

Line 327: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE, p_count => l_msg_count, p_data => x_error_msg );

323: ELSIF (l_carton_lpn_itm_id is NULL) THEN
324: x_return_status := fnd_api.g_ret_sts_error;
325: fnd_message.set_name('WMS', 'WMS_CARTONIZATION_ERR');
326: fnd_msg_pub.ADD;
327: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE, p_count => l_msg_count, p_data => x_error_msg );
328: l_error_msg :='Inventory item id is not present in carton LPN';
329: IF(l_debug = 1) THEN
330: inv_trx_util_pub.trace(l_api_name|| ': '||l_error_msg);
331: END IF;

Line 365: x_return_status := fnd_api.g_ret_sts_error;

361: END IF;
362: FOR i IN 1..p_task_table.count
363: LOOP
364: IF (p_task_table(i).organization_id <> l_carton_lpn_org) THEN
365: x_return_status := fnd_api.g_ret_sts_error;
366: fnd_message.set_name('WMS', 'WMS_CARTON_LPN_ORG_ERR');
367: fnd_msg_pub.ADD;
368: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE, p_count => l_msg_count, p_data => x_error_msg );
369: l_error_msg :='Organization is not same for Carton LPN and Task';

Line 368: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE, p_count => l_msg_count, p_data => x_error_msg );

364: IF (p_task_table(i).organization_id <> l_carton_lpn_org) THEN
365: x_return_status := fnd_api.g_ret_sts_error;
366: fnd_message.set_name('WMS', 'WMS_CARTON_LPN_ORG_ERR');
367: fnd_msg_pub.ADD;
368: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE, p_count => l_msg_count, p_data => x_error_msg );
369: l_error_msg :='Organization is not same for Carton LPN and Task';
370: IF(l_debug = 1) THEN
371: inv_trx_util_pub.trace(l_api_name|| ': '||l_error_msg);
372: END IF;

Line 381: x_return_status := fnd_api.g_ret_sts_error;

377: FETCH c_bulk_task INTO l_bulk_task;
378: IF c_bulk_task%NOTFOUND THEN
379: CLOSE c_bulk_task;
380: ELSE
381: x_return_status := fnd_api.g_ret_sts_error;
382: fnd_message.set_name('WMS', 'WMS_CARTON_BULK_ERR');
383: fnd_msg_pub.ADD;
384: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE, p_count => l_msg_count, p_data => x_error_msg );
385: l_error_msg :='Bulk Tasks cannot be cartonized';

Line 384: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE, p_count => l_msg_count, p_data => x_error_msg );

380: ELSE
381: x_return_status := fnd_api.g_ret_sts_error;
382: fnd_message.set_name('WMS', 'WMS_CARTON_BULK_ERR');
383: fnd_msg_pub.ADD;
384: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE, p_count => l_msg_count, p_data => x_error_msg );
385: l_error_msg :='Bulk Tasks cannot be cartonized';
386: IF(l_debug = 1) THEN
387: inv_trx_util_pub.trace(l_api_name|| ': '||l_error_msg);
388: END IF;

Line 410: x_return_status := fnd_api.g_ret_sts_error;

406: WHEN OTHERS THEN
407: l_temp_del_detail_id := NULL;
408: END;
409: IF (l_temp_del_detail_id IS NULL) THEN
410: x_return_status := fnd_api.g_ret_sts_error;
411: fnd_message.set_name('WMS', 'WMS_CARTONIZATION_ERR');
412: fnd_msg_pub.ADD;
413: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => x_error_msg );
414: l_error_msg :='Data not present in WDD for the corresponding task :'||p_task_table(i).transaction_number;

Line 413: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => x_error_msg );

409: IF (l_temp_del_detail_id IS NULL) THEN
410: x_return_status := fnd_api.g_ret_sts_error;
411: fnd_message.set_name('WMS', 'WMS_CARTONIZATION_ERR');
412: fnd_msg_pub.ADD;
413: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => x_error_msg );
414: l_error_msg :='Data not present in WDD for the corresponding task :'||p_task_table(i).transaction_number;
415: IF(l_debug = 1) THEN
416: inv_trx_util_pub.trace(l_api_name|| ': '||l_error_msg);
417: END IF;

Line 463: x_return_status := fnd_api.g_ret_sts_error;

459: IF l_return_status = 'S' then
460: -- check if all the values in l_grouping_rows are same.
461: FOR i in 1..l_grouping_rows.COUNT LOOP
462: IF (l_grouping_rows(1) <> l_grouping_rows(i)) THEN
463: x_return_status := fnd_api.g_ret_sts_error;
464: fnd_message.set_name('WMS', 'WMS_CARTON_DEL_GP_ERR');
465: fnd_msg_pub.ADD;
466: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => x_error_msg );
467: l_error_msg :='Delivery grouping mismatch,cartonization cannot be done';

Line 466: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => x_error_msg );

462: IF (l_grouping_rows(1) <> l_grouping_rows(i)) THEN
463: x_return_status := fnd_api.g_ret_sts_error;
464: fnd_message.set_name('WMS', 'WMS_CARTON_DEL_GP_ERR');
465: fnd_msg_pub.ADD;
466: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => x_error_msg );
467: l_error_msg :='Delivery grouping mismatch,cartonization cannot be done';
468: IF(l_debug = 1) THEN
469: inv_trx_util_pub.trace(l_api_name|| ': '||l_error_msg);
470: END IF;

Line 481: x_return_status := fnd_api.g_ret_sts_error;

477: ELSE --l_del_id_Tab_new.count > 0
478: --check if the delivery_id's that are present in l_del_id_tab_new are all same.
479: FOR i in 1..l_del_id_tab_new.COUNT LOOP
480: IF (l_del_id_tab_new(1) <> l_del_id_tab_new(i)) THEN
481: x_return_status := fnd_api.g_ret_sts_error;
482: fnd_message.set_name('WMS', 'WMS_CARTON_DEL_ERR');
483: fnd_msg_pub.ADD;
484: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => x_error_msg );
485: l_error_msg :='Delivery mismatch,cartonization cannot be done';

Line 484: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => x_error_msg );

480: IF (l_del_id_tab_new(1) <> l_del_id_tab_new(i)) THEN
481: x_return_status := fnd_api.g_ret_sts_error;
482: fnd_message.set_name('WMS', 'WMS_CARTON_DEL_ERR');
483: fnd_msg_pub.ADD;
484: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => x_error_msg );
485: l_error_msg :='Delivery mismatch,cartonization cannot be done';
486: IF(l_debug = 1) THEN
487: inv_trx_util_pub.trace(l_api_name|| ': '||l_error_msg);
488: END IF;

Line 503: p_init_msg_list => FND_API.G_FALSE,

499: l_delivery_id := l_del_id_tab_new(1);
500:
501: wsh_delivery_details_grp.detail_to_delivery(
502: p_api_version => 1.0,
503: p_init_msg_list => FND_API.G_FALSE,
504: p_commit => FND_API.G_FALSE,
505: p_validation_level => l_validation_level,
506: x_return_status => l_return_status,
507: x_msg_count => l_msg_count,

Line 504: p_commit => FND_API.G_FALSE,

500:
501: wsh_delivery_details_grp.detail_to_delivery(
502: p_api_version => 1.0,
503: p_init_msg_list => FND_API.G_FALSE,
504: p_commit => FND_API.G_FALSE,
505: p_validation_level => l_validation_level,
506: x_return_status => l_return_status,
507: x_msg_count => l_msg_count,
508: x_msg_data => l_msg_data,

Line 518: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => x_error_msg );

514:
515: IF l_return_status <> 'S' THEN
516: fnd_message.set_name('WMS', 'WMS_CARTONIZATION_ERR');
517: fnd_msg_pub.ADD;
518: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => x_error_msg );
519: l_error_msg :='Error returned from WSH API';
520: IF(l_debug = 1) THEN
521: inv_trx_util_pub.trace(l_api_name|| ': '||l_error_msg);
522: END IF;

Line 640: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_err_msg );

636: END;
637: IF l_count > 0 THEN
638: fnd_message.set_name('WMS', 'WMS_ATF_INVALID_TASK_STATUS');--new message WMS_ATF_ACTIVE_TASK_EXP
639: fnd_msg_pub.ADD;
640: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_err_msg );
641: l_msg := 'Active task can be updated if tasks assigned to user is logged off the system';
642: IF(l_debug = 1) THEN
643: inv_trx_util_pub.trace(l_api_name|| ': '||l_msg);
644: END IF;

Line 689: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_err_msg );

685: END;
686: IF (l_count > 0 ) THEN --ANY OF GROUP TASK IS active
687: fnd_message.set_name('WMS', 'WMS_ATF_INVALID_TASK_STATUS');--new message WMS_ATF_DISPATCH_TASK_EXP
688: fnd_msg_pub.ADD;
689: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_err_msg );
690: l_msg := 'Dispatcher task can be updated only if any of the task in group is not in Active status';
691: IF(l_debug = 1) THEN
692: inv_trx_util_pub.trace(l_api_name|| ': '||l_msg);
693: END IF;

Line 709: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_err_msg );

705: p_output_task_rec.status_id := p_new_task_status;
706: ELSE
707: fnd_message.set_name('WMS', 'WMS_ATF_INVALID_TASK_STATUS');
708: fnd_msg_pub.ADD;
709: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_err_msg );
710: l_msg := 'Active task can be moved only to Pending or Unreleased state';
711: IF(l_debug = 1) THEN
712: inv_trx_util_pub.trace(l_api_name|| ': '||l_msg);
713: END IF;

Line 724: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_err_msg );

720: p_output_task_rec.status_id := p_new_task_status;
721: ELSE
722: fnd_message.set_name('WMS', 'WMS_ATF_INVALID_TASK_STATUS');
723: fnd_msg_pub.ADD;
724: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_err_msg );
725: l_msg := 'Dispatcher task can be moved only to Pending or Unreleased state';
726: IF(l_debug = 1) THEN
727: inv_trx_util_pub.trace(l_api_name|| ': '||l_msg);
728: END IF;

Line 739: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_err_msg );

735: p_output_task_rec.status_id := p_new_task_status;
736: ELSE
737: fnd_message.set_name('WMS', 'WMS_ATF_INVALID_TASK_STATUS');
738: fnd_msg_pub.ADD;
739: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_err_msg );
740: l_msg := 'Unreleased task can be moved only to Pending or Queued state';
741: IF(l_debug = 1) THEN
742: inv_trx_util_pub.trace(l_api_name|| ': '||l_msg);
743: END IF;

Line 754: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_err_msg );

750: p_output_task_rec.status_id := p_new_task_status;
751: ELSE
752: fnd_message.set_name('WMS', 'WMS_ATF_INVALID_TASK_STATUS');
753: fnd_msg_pub.ADD;
754: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_err_msg );
755: l_msg := 'Pending task can be moved only to Queued state';
756: IF(l_debug = 1) THEN
757: inv_trx_util_pub.trace(l_api_name|| ': '||l_msg);
758: END IF;

Line 766: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_err_msg );

762: END IF;
763: ELSE
764: fnd_message.set_name('WMS', 'WMS_ATF_INVALID_TASK_STATUS');
765: fnd_msg_pub.ADD;
766: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_err_msg );
767: l_msg := 'Invalid task status';
768: IF(l_debug = 1) THEN
769: inv_trx_util_pub.trace(l_api_name|| ': '||l_msg);
770: END IF;

Line 784: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_err_msg );

780: p_output_task_rec.priority := p_new_task_priority;
781: ELSE
782: fnd_message.set_name('WMS', 'WMS_INVALID_TASK');
783: fnd_msg_pub.ADD;
784: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_err_msg );
785: l_msg := 'Inbound task priority cannot be updated';
786: IF(l_debug = 1) THEN
787: inv_trx_util_pub.trace(l_api_name|| ': '||l_msg);
788: END IF;

Line 809: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_err_msg );

805: FETCH c_usr_task_type INTO l_usr_task_type_id;
806: IF c_usr_task_type%NOTFOUND THEN
807: fnd_message.set_name('WMS', 'WMS_INVALID_USER_TASK');--new message
808: fnd_msg_pub.ADD;
809: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_err_msg );
810: l_msg := 'Standard task type associated with the user task is different from the current standard task type';
811: IF(l_debug = 1) THEN
812: inv_trx_util_pub.trace(l_api_name|| ': '||l_msg);
813: END IF;

Line 828: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_err_msg );

824: IF (p_task_rec.organization_id <> p_op_plan_rec.organization_id) THEN
825: IF(p_op_plan_rec.common_to_all_org <> 'Y') THEN
826: fnd_message.set_name('WMS', 'WMS_OPER_PLAN_ORG_INVALID');--new message
827: fnd_msg_pub.ADD;
828: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_err_msg );
829: p_output_task_rec.RESULT := 'E';
830: p_output_task_rec.ERROR := l_err_msg;
831: l_msg := 'Organization associated with the operation plan is different from that of the task';
832: IF(l_debug = 1) THEN

Line 858: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_err_msg );

854: p_output_task_rec.operation_plan_id := p_new_operation_plan_id;
855: ELSE
856: fnd_message.set_name('WMS', 'WMS_OPERTN_PLAN_ID_INVALID');--new message
857: fnd_msg_pub.ADD;
858: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_err_msg );
859: p_output_task_rec.RESULT := 'E';
860: p_output_task_rec.ERROR := l_err_msg;
861: l_msg := 'Inspection/Standard operation plan can only be replaced with another Inspection/Standard operation plan
862: and cross dock operation can be replaced with another cross dock operation plan or non-cross dock Operation plan ';

Line 871: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_err_msg );

867: END IF;
868: ELSE
869: fnd_message.set_name('WMS', 'WMS_OPERTN_PLAN_ID_INVALID');--new message
870: fnd_msg_pub.ADD;
871: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_err_msg );
872: p_output_task_rec.RESULT := 'E';
873: p_output_task_rec.ERROR := l_err_msg;
874: l_msg := 'Current or new operation plan type is NULL';
875: IF(l_debug = 1) THEN

Line 887: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_err_msg );

883: IF ( p_op_plan_rec.activity_type_id = 1) THEN --INBOUND CASE
884: IF(p_task_rec.task_type_id <> 2) THEN --putaway
885: fnd_message.set_name('WMS', 'WMS_INVALID_OP_PLAN_ACTIVITY');--new message
886: fnd_msg_pub.ADD;
887: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_err_msg );
888: p_output_task_rec.ERROR := l_err_msg;
889: p_output_task_rec.RESULT := 'E';
890: l_msg := 'Mismatch in the operation plan activity type and task type';
891: IF(l_debug = 1) THEN

Line 911: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_err_msg );

907: IF (l_debug=1) THEN
908: inv_trx_util_pub.trace('Records not found in WMS_OP_PLANS_B for given p_new_operation_plan_id');
909: fnd_message.set_name('WMS', ' WMS_INVALID_TASK');--new message
910: fnd_msg_pub.ADD;
911: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_err_msg );
912: l_msg := 'No of Records found in WMS_OP_PLANS_B for given operation plan id';
913: IF(l_debug = 1) THEN
914: inv_trx_util_pub.trace(l_api_name|| ': '||l_msg);
915: END IF;

Line 942: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_err_msg );

938: IF (l_debug=1) THEN
939: inv_trx_util_pub.trace('Records not found in WMS_OP_PLAN_DETAILS for given operation plan id');
940: fnd_message.set_name('WMS', ' WMS_INVALID_TASK');--new message
941: fnd_msg_pub.ADD;
942: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_err_msg );
943: l_msg := 'No of Records found in WMS_OP_PLAN_DETAILS for given operation plan id';
944: IF(l_debug = 1) THEN
945: inv_trx_util_pub.trace(l_api_name|| ': '||l_msg);
946: END IF;

Line 972: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_err_msg );

968:
969: ELSE
970: fnd_message.set_name('WMS', ' WMS_INVALID_TASK');--new message
971: fnd_msg_pub.ADD;
972: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_err_msg );
973: l_msg := 'STATUS in wms_op_plan_instances is not pending';
974: IF(l_debug = 1) THEN
975: inv_trx_util_pub.trace(l_api_name|| ': '||l_msg);
976: END IF;

Line 1015: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_err_msg );

1011: --just updating the plan id should be enough.needs to be investigated further
1012: IF (p_task_rec.task_type_id <> 1) THEN --if not a pick task then error out
1013: fnd_message.set_name('WMS', 'WMS_INVALID_OP_PLAN_ACTIVITY');--new message
1014: fnd_msg_pub.ADD;
1015: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_err_msg );
1016: l_msg := 'Mismatch in the operation plan activity type and task type';
1017: IF(l_debug = 1) THEN
1018: inv_trx_util_pub.trace(l_api_name|| ': '||l_msg);
1019: END IF;

Line 1159: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => x_error_msg );

1155: x_validation_status:= 'E';
1156: END IF;
1157: END IF;
1158: -- 6850212 End
1159: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => x_error_msg );
1160: EXCEPTION
1161: WHEN OTHERS THEN
1162: x_return_status := 'E';
1163: END validate_task_id ;

Line 1267: x_return_status := fnd_api.g_ret_sts_success;

1263: l_api_name VARCHAR2(1000) := 'CHECK_CARTONIZATION';
1264: l_error_msg VARCHAR2(2000);
1265: l_msg_count NUMBER;
1266: BEGIN
1267: x_return_status := fnd_api.g_ret_sts_success;
1268: OPEN carton_lpn_csr(p_new_carton_lpn_id);
1269: FETCH carton_lpn_csr INTO l_carton_lpn_ctx,l_carton_lpn_org;
1270: CLOSE carton_lpn_csr;
1271: --if carton lpn is passed and is not valid then no need to proceed further

Line 1273: x_return_status := fnd_api.g_ret_sts_error;

1269: FETCH carton_lpn_csr INTO l_carton_lpn_ctx,l_carton_lpn_org;
1270: CLOSE carton_lpn_csr;
1271: --if carton lpn is passed and is not valid then no need to proceed further
1272: IF(l_carton_lpn_ctx NOT IN (5,8)) THEN
1273: x_return_status := fnd_api.g_ret_sts_error;
1274: fnd_message.set_name('WMS', 'WMS_CARTONIZATION_ERR');
1275: fnd_msg_pub.ADD;
1276: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => x_error_msg );
1277: l_error_msg :='Invalid context for Carton LPN:'||p_new_carton_lpn_id;

Line 1276: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => x_error_msg );

1272: IF(l_carton_lpn_ctx NOT IN (5,8)) THEN
1273: x_return_status := fnd_api.g_ret_sts_error;
1274: fnd_message.set_name('WMS', 'WMS_CARTONIZATION_ERR');
1275: fnd_msg_pub.ADD;
1276: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => x_error_msg );
1277: l_error_msg :='Invalid context for Carton LPN:'||p_new_carton_lpn_id;
1278: IF(l_debug = 1) THEN
1279: inv_trx_util_pub.trace(l_api_name|| ': '||l_error_msg);
1280: END IF;

Line 1305: x_return_status := fnd_api.g_ret_sts_error;

1301: END IF;
1302: FOR i IN 1..p_task_table.count
1303: LOOP
1304: IF (p_task_table(i).organization_id <> l_carton_lpn_org) THEN
1305: x_return_status := fnd_api.g_ret_sts_error;
1306: fnd_message.set_name('WMS', 'WMS_CARTONIZATION_ERR');
1307: fnd_msg_pub.ADD;
1308: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => x_error_msg );
1309: l_error_msg :='Organization is not same for Carton LPN and Task';

Line 1308: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => x_error_msg );

1304: IF (p_task_table(i).organization_id <> l_carton_lpn_org) THEN
1305: x_return_status := fnd_api.g_ret_sts_error;
1306: fnd_message.set_name('WMS', 'WMS_CARTONIZATION_ERR');
1307: fnd_msg_pub.ADD;
1308: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => x_error_msg );
1309: l_error_msg :='Organization is not same for Carton LPN and Task';
1310: IF(l_debug = 1) THEN
1311: inv_trx_util_pub.trace(l_api_name|| ': '||l_error_msg);
1312: END IF;

Line 1321: x_return_status := fnd_api.g_ret_sts_error;

1317: FETCH c_bulk_task INTO l_bulk_task;
1318: IF c_bulk_task%NOTFOUND THEN
1319: CLOSE c_bulk_task;
1320: ELSE
1321: x_return_status := fnd_api.g_ret_sts_error;
1322: fnd_message.set_name('WMS', 'WMS_CARTONIZATION_ERR');
1323: fnd_msg_pub.ADD;
1324: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => x_error_msg );
1325: l_error_msg :='Bulk Tasks cannot be cartonized';

Line 1324: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => x_error_msg );

1320: ELSE
1321: x_return_status := fnd_api.g_ret_sts_error;
1322: fnd_message.set_name('WMS', 'WMS_CARTONIZATION_ERR');
1323: fnd_msg_pub.ADD;
1324: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => x_error_msg );
1325: l_error_msg :='Bulk Tasks cannot be cartonized';
1326: IF(l_debug = 1) THEN
1327: inv_trx_util_pub.trace(l_api_name|| ': '||l_error_msg);
1328: END IF;

Line 1350: x_return_status := fnd_api.g_ret_sts_error;

1346: WHEN OTHERS THEN
1347: l_temp_del_detail_id := NULL;
1348: END;
1349: IF (l_temp_del_detail_id IS NULL) THEN
1350: x_return_status := fnd_api.g_ret_sts_error;
1351: fnd_message.set_name('WMS', 'WMS_CARTONIZATION_ERR');
1352: fnd_msg_pub.ADD;
1353: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => x_error_msg );
1354: l_error_msg :='Data not present in WDD for the corresponding task :'||p_task_table(i).transaction_number;

Line 1353: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => x_error_msg );

1349: IF (l_temp_del_detail_id IS NULL) THEN
1350: x_return_status := fnd_api.g_ret_sts_error;
1351: fnd_message.set_name('WMS', 'WMS_CARTONIZATION_ERR');
1352: fnd_msg_pub.ADD;
1353: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => x_error_msg );
1354: l_error_msg :='Data not present in WDD for the corresponding task :'||p_task_table(i).transaction_number;
1355: IF(l_debug = 1) THEN
1356: inv_trx_util_pub.trace(l_api_name|| ': '||l_error_msg);
1357: END IF;

Line 1384: x_return_status := fnd_api.g_ret_sts_error;

1380: IF l_del_det_id_tab.COUNT > 1 THEN
1381: FOR i IN 1..l_del_id_tab.COUNT
1382: LOOP
1383: IF nvl(l_del_id_tab(1),-999) <> nvl(l_del_id_tab(i),-999) THEN
1384: x_return_status := fnd_api.g_ret_sts_error;
1385: fnd_message.set_name('WMS', 'WMS_CARTONIZATION_ERR');
1386: fnd_msg_pub.ADD;
1387: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => x_error_msg );
1388: l_error_msg :='Delivery mismatch,cartonization cannot be done';

Line 1387: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => x_error_msg );

1383: IF nvl(l_del_id_tab(1),-999) <> nvl(l_del_id_tab(i),-999) THEN
1384: x_return_status := fnd_api.g_ret_sts_error;
1385: fnd_message.set_name('WMS', 'WMS_CARTONIZATION_ERR');
1386: fnd_msg_pub.ADD;
1387: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => x_error_msg );
1388: l_error_msg :='Delivery mismatch,cartonization cannot be done';
1389: IF(l_debug = 1) THEN
1390: inv_trx_util_pub.trace(l_api_name|| ': '||l_error_msg);
1391: END IF;

Line 1416: x_return_status := fnd_api.g_ret_sts_error;

1412: END LOOP;
1413: FOR i IN 1..l_carton_grp_id_tab.COUNT
1414: LOOP
1415: IF nvl(l_carton_grp_id_tab(1),-999) <> nvl(l_carton_grp_id_tab(i),-999) THEN
1416: x_return_status := fnd_api.g_ret_sts_error;
1417: fnd_message.set_name('WMS', 'WMS_CARTONIZATION_ERR');
1418: fnd_msg_pub.ADD;
1419: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => x_error_msg );
1420: l_error_msg :='Carton group mismatch,cartonization cannot be done';

Line 1419: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => x_error_msg );

1415: IF nvl(l_carton_grp_id_tab(1),-999) <> nvl(l_carton_grp_id_tab(i),-999) THEN
1416: x_return_status := fnd_api.g_ret_sts_error;
1417: fnd_message.set_name('WMS', 'WMS_CARTONIZATION_ERR');
1418: fnd_msg_pub.ADD;
1419: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => x_error_msg );
1420: l_error_msg :='Carton group mismatch,cartonization cannot be done';
1421: IF(l_debug = 1) THEN
1422: inv_trx_util_pub.trace(l_api_name|| ': '||l_error_msg);
1423: END IF;

Line 2976: FUNCTION query_rows(p_line_id IN NUMBER := fnd_api.g_miss_num)

2972: /*FUNCTION query_rows()
2973: This function gets the move order record for the move order line passed.
2974: */
2975: -------------------------------------------------------------------------------------------------------------------
2976: FUNCTION query_rows(p_line_id IN NUMBER := fnd_api.g_miss_num)
2977: RETURN inv_move_order_pub.trolin_tbl_type IS
2978:
2979: l_trolin_rec inv_move_order_pub.trolin_rec_type;
2980: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;

Line 3068: IF (p_line_id IS NOT NULL AND p_line_id <> fnd_api.g_miss_num ) THEN

3064: FROM mtl_txn_request_lines
3065: WHERE line_id = p_line_id;
3066: BEGIN
3067: debug_print( 'p_line_id ' || p_line_id);
3068: IF (p_line_id IS NOT NULL AND p_line_id <> fnd_api.g_miss_num ) THEN
3069: -- Loop over fetched records
3070: FOR l_implicit_rec IN l_trolin_csr
3071: LOOP
3072: l_trolin_rec.attribute1 := l_implicit_rec.attribute1;

Line 3156: IF (p_line_id IS NOT NULL AND p_line_id <> fnd_api.g_miss_num ) AND (l_trolin_tbl.COUNT = 0) THEN

3152: l_trolin_rec.required_quantity := l_implicit_rec.required_quantity;
3153: l_trolin_tbl(l_trolin_tbl.COUNT + 1) := l_trolin_rec;
3154: END LOOP;
3155: END IF;
3156: IF (p_line_id IS NOT NULL AND p_line_id <> fnd_api.g_miss_num ) AND (l_trolin_tbl.COUNT = 0) THEN
3157: debug_print('no data found');
3158: RAISE NO_DATA_FOUND;
3159: END IF;
3160: -- Return fetched table

Line 3163: WHEN fnd_api.g_exc_unexpected_error THEN

3159: END IF;
3160: -- Return fetched table
3161: RETURN l_trolin_tbl;
3162: EXCEPTION
3163: WHEN fnd_api.g_exc_unexpected_error THEN
3164: RAISE fnd_api.g_exc_unexpected_error;
3165: WHEN OTHERS THEN
3166: RAISE fnd_api.g_exc_unexpected_error;
3167: END query_rows;

Line 3164: RAISE fnd_api.g_exc_unexpected_error;

3160: -- Return fetched table
3161: RETURN l_trolin_tbl;
3162: EXCEPTION
3163: WHEN fnd_api.g_exc_unexpected_error THEN
3164: RAISE fnd_api.g_exc_unexpected_error;
3165: WHEN OTHERS THEN
3166: RAISE fnd_api.g_exc_unexpected_error;
3167: END query_rows;
3168:

Line 3166: RAISE fnd_api.g_exc_unexpected_error;

3162: EXCEPTION
3163: WHEN fnd_api.g_exc_unexpected_error THEN
3164: RAISE fnd_api.g_exc_unexpected_error;
3165: WHEN OTHERS THEN
3166: RAISE fnd_api.g_exc_unexpected_error;
3167: END query_rows;
3168:
3169: -------------------------------------------------------------------------------------------------------------------
3170: /*PROCEDURE delete_transaction()

Line 3209: x_return_status := fnd_api.g_ret_sts_success;

3205: AND msi.inventory_item_id = mmtt.inventory_item_id
3206: AND msi.organization_id = mmtt.organization_id;
3207: BEGIN
3208: l_debug := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
3209: x_return_status := fnd_api.g_ret_sts_success;
3210: SAVEPOINT deltxn;
3211: IF l_debug = 1 THEN
3212: debug_print( 'Cleaning up MMTT, MTLT and MSNT for Txn Temp ID = ' || p_transaction_temp_id);
3213: END IF;

Line 3231: IF x_return_status <> fnd_api.g_ret_sts_success THEN

3227: IF l_parent_line_id IS NOT NULL AND p_update_parent THEN
3228: IF l_debug = 1 THEN
3229: debug_print( 'Child Record... Updating the Parent: TxnTempID = ' || l_parent_line_id);
3230: END IF;
3231: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3232: IF l_debug = 1 THEN
3233: debug_print('Error occurred while updating parent line in MMTT');
3234: END IF;
3235: ROLLBACK TO deltxn;

Line 3384: x_return_status := fnd_api.g_ret_sts_unexp_error;

3380: debug_print('In the exception for could not delete a record. Returning staus as E');
3381: END IF;
3382: x_return_status := 'E';
3383: WHEN OTHERS THEN
3384: x_return_status := fnd_api.g_ret_sts_unexp_error;
3385: IF l_debug = 1 THEN
3386: debug_print( 'Exception Occurred = ' || SQLERRM);
3387: END IF;
3388: ROLLBACK TO deltxn;

Line 3426: x_return_status := fnd_api.g_ret_sts_success;

3422: g_retain_ato_profile VARCHAR2(1) := fnd_profile.VALUE('WSH_RETAIN_ATO_RESERVATIONS');
3423: exc_not_deleted EXCEPTION;
3424: BEGIN
3425: l_debug := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
3426: x_return_status := fnd_api.g_ret_sts_success;
3427: SAVEPOINT delete_details;
3428: IF (l_debug = 1) THEN
3429: debug_print( 'Transaction Temp ID = ' || p_transaction_temp_id);
3430: debug_print( 'Move Order Line ID = ' || p_move_order_line_id);

Line 3450: IF x_return_status <> fnd_api.g_ret_sts_success THEN

3446: debug_print( 'x_return_status = ' || x_return_status);
3447: debug_print( 'l_error_code = ' || l_error_code);
3448: debug_print( 'l_mtl_reservation_tbl_count = ' || l_mtl_reservation_tbl_count);
3449: END IF;
3450: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3451: IF l_debug = 1 THEN
3452: debug_print('delete_mo: Error occurred while deleting MMTT');
3453: END IF;
3454: ROLLBACK TO delete_details;

Line 3526: IF x_return_status <> fnd_api.g_ret_sts_success THEN

3522: p_to_serial_number => l_to_serial_number);
3523: IF l_debug = 1 THEN
3524: debug_print('x_return_status' || x_return_status);
3525: END IF;
3526: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3527: IF l_debug = 1 THEN
3528: debug_print('delete_mo: Error occurred while updating reservations');
3529: END IF;
3530: ROLLBACK TO delete_details;

Line 3581: IF x_return_status <> fnd_api.g_ret_sts_success THEN

3577:
3578: IF l_debug = 1 THEN
3579: debug_print( 'x_return_status from inv_reservation_pub.update_reservation ' || x_return_status);
3580: END IF;
3581: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3582: IF l_debug = 1 THEN
3583: debug_print('delete_mo: Error occurred while updating reservations');
3584: END IF;
3585: ROLLBACK TO delete_details;

Line 3602: IF x_return_status = fnd_api.g_ret_sts_error THEN

3598: p_update_parent => FALSE);
3599: IF l_debug = 1 THEN
3600: debug_print( 'x_return_status ' || x_return_status);
3601: END IF;
3602: IF x_return_status = fnd_api.g_ret_sts_error THEN
3603: IF l_debug = 1 THEN
3604: debug_print('delete_mo: Error occurred while deleting MMTT');
3605: END IF;
3606: ROLLBACK TO delete_details;

Line 3608: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

3604: debug_print('delete_mo: Error occurred while deleting MMTT');
3605: END IF;
3606: ROLLBACK TO delete_details;
3607: RAISE exc_not_deleted ;
3608: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3609: IF l_debug = 1 THEN
3610: debug_print('delete_mo: Error occurred while deleting MMTT');
3611: END IF;
3612: ROLLBACK TO delete_details;

Line 3621: x_return_status := fnd_api.g_ret_sts_unexp_error;

3617: debug_print('In the exception for could not delete a record. Returning staus as E');
3618: END IF;
3619: x_return_status := 'E';
3620: WHEN OTHERS THEN
3621: x_return_status := fnd_api.g_ret_sts_unexp_error;
3622: ROLLBACK TO delete_details;
3623: END delete_details;
3624:
3625: -------------------------------------------------------------------------------------------------------------------

Line 3654: x_return_status := fnd_api.g_ret_sts_success;

3650: AND move_order_line_id IS NOT NULL
3651: AND released_status = 'S';
3652: BEGIN
3653: SAVEPOINT backorder_source;
3654: x_return_status := fnd_api.g_ret_sts_success;
3655: l_debug := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
3656: l_qty_to_backorder := p_qty_to_backorder;
3657: IF l_qty_to_backorder < 0 THEN
3658: l_qty_to_backorder := 0;

Line 3678: RAISE fnd_api.g_exc_error;

3674: CLOSE c_wsh_info;
3675: IF l_debug = 1 THEN
3676: debug_print('NOTFOUND c_wsh_info' );
3677: END IF;
3678: RAISE fnd_api.g_exc_error;
3679: END IF;
3680: CLOSE c_wsh_info;
3681: IF l_debug = 1 THEN
3682: debug_print('finished fetching' );

Line 3712: IF x_return_status <> fnd_api.g_ret_sts_success THEN

3708: x_return_status => x_return_status );
3709: IF (l_debug = 1) THEN
3710: debug_print( 'Updated Shipping Attributes - Return Status = ' || x_return_status);
3711: END IF;
3712: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3713: ROLLBACK TO backorder_source;
3714: RAISE exc_not_deleted ;
3715: END IF;
3716: ELSIF p_move_order_type = inv_globals.g_move_order_mfg_pick THEN

Line 3736: IF x_return_status <> fnd_api.g_ret_sts_success THEN

3732:
3733: IF (l_debug = 1) THEN
3734: debug_print( 'Unallocated WIP Material - Return Status = ' || x_return_status);
3735: END IF;
3736: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3737: ROLLBACK TO backorder_source;
3738: RAISE exc_not_deleted ;
3739: END IF;
3740: END IF;

Line 3748: x_return_status := fnd_api.g_ret_sts_unexp_error;

3744: debug_print('In the exception for could not delete a record. Returning staus as E');
3745: END IF;
3746: x_return_status := 'E';
3747: WHEN OTHERS THEN
3748: x_return_status := fnd_api.g_ret_sts_unexp_error;
3749: ROLLBACK TO backorder_source;
3750: END backorder_source;
3751:
3752: -------------------------------------------------------------------------------------------------------------------

Line 3805: x_return_status := fnd_api.g_ret_sts_success;

3801: WHERE t.parent_line_id = mmtt.transaction_temp_id
3802: )
3803: FOR UPDATE NOWAIT;
3804: BEGIN
3805: x_return_status := fnd_api.g_ret_sts_success;
3806: l_debug := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
3807: -- Set savepoint
3808: SAVEPOINT backorder;
3809: IF (l_debug = 1) THEN

Line 3863: IF x_return_status = fnd_api.g_ret_sts_error THEN

3859:
3860: IF l_debug = 1 THEN
3861: debug_print( 'x_return_status ' || x_return_status);
3862: END IF;
3863: IF x_return_status = fnd_api.g_ret_sts_error THEN
3864: IF l_debug = 1 THEN
3865: debug_print('Error occurred while back ordering');
3866: END IF;
3867: ROLLBACK TO backorder;

Line 3869: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

3865: debug_print('Error occurred while back ordering');
3866: END IF;
3867: ROLLBACK TO backorder;
3868: RAISE exc_not_deleted ;
3869: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3870: IF l_debug = 1 THEN
3871: debug_print('Unexpected error occurred while back ordering');
3872: END IF;
3873: ROLLBACK TO backorder;

Line 3891: IF x_return_status = fnd_api.g_ret_sts_error THEN

3887:
3888: IF l_debug = 1 THEN
3889: debug_print( 'x_return_status ' || x_return_status);
3890: END IF;
3891: IF x_return_status = fnd_api.g_ret_sts_error THEN
3892: IF l_debug = 1 THEN
3893: debug_print('Error occurred while back ordering');
3894: END IF;
3895: ROLLBACK TO backorder;

Line 3897: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

3893: debug_print('Error occurred while back ordering');
3894: END IF;
3895: ROLLBACK TO backorder;
3896: RAISE exc_not_deleted ;
3897: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3898: IF l_debug = 1 THEN
3899: debug_print('Unexpected Error occurred while back ordering');
3900: END IF;
3901: ROLLBACK TO backorder;

Line 3936: IF x_return_status <> fnd_api.g_ret_sts_success THEN

3932:
3933: IF l_debug = 1 THEN
3934: debug_print( 'x_return_status ' || x_return_status);
3935: END IF;
3936: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3937: IF l_debug = 1 THEN
3938: debug_print( 'Error occurred while cleaning reservation ');
3939: END IF;
3940: ROLLBACK TO backorder;

Line 3951: x_return_status := fnd_api.g_ret_sts_unexp_error;

3947: debug_print('In the exception for could not delete a record. Returning staus as E');
3948: END IF;
3949: x_return_status := 'E';
3950: WHEN OTHERS THEN
3951: x_return_status := fnd_api.g_ret_sts_unexp_error;
3952: ROLLBACK TO backorder;
3953: END backorder;
3954:
3955: -------------------------------------------------------------------------------------------------------------------

Line 3971: l_g_ret_sts_error CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_error;

3967: l_progress VARCHAR2(30) := '100';
3968: l_update_parent BOOLEAN := FALSE ; -- No need to call update_parent_mmtt
3969: x_msg_count NUMBER;
3970: x_msg_data VARCHAR2(50);
3971: l_g_ret_sts_error CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_error;
3972: l_g_ret_sts_unexp_error CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_unexp_error;
3973: l_g_ret_sts_success CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_success;
3974: l_reservation_id NUMBER;
3975: l_pri_rsv_qty NUMBER;

Line 3972: l_g_ret_sts_unexp_error CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_unexp_error;

3968: l_update_parent BOOLEAN := FALSE ; -- No need to call update_parent_mmtt
3969: x_msg_count NUMBER;
3970: x_msg_data VARCHAR2(50);
3971: l_g_ret_sts_error CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_error;
3972: l_g_ret_sts_unexp_error CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_unexp_error;
3973: l_g_ret_sts_success CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_success;
3974: l_reservation_id NUMBER;
3975: l_pri_rsv_qty NUMBER;
3976: l_rsv_qty NUMBER;

Line 3973: l_g_ret_sts_success CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_success;

3969: x_msg_count NUMBER;
3970: x_msg_data VARCHAR2(50);
3971: l_g_ret_sts_error CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_error;
3972: l_g_ret_sts_unexp_error CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_unexp_error;
3973: l_g_ret_sts_success CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_success;
3974: l_reservation_id NUMBER;
3975: l_pri_rsv_qty NUMBER;
3976: l_rsv_qty NUMBER;
3977: l_pri_rsv_uom VARCHAR2(3);

Line 4049: x_return_status := fnd_api.g_ret_sts_success;

4045: mtl_txn_request_lines mtrl
4046: WHERE mtrl.line_id = l_transaction_record.move_order_line_id
4047: AND mtrh.header_id = mtrl.header_id;
4048: BEGIN
4049: x_return_status := fnd_api.g_ret_sts_success;
4050: l_progress := '110';
4051: l_debug := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
4052: IF (l_debug = 1) THEN
4053: debug_print('IN DELETE_OUTBOUND_TASKS');

Line 4153: p_init_msg_lst => fnd_api.g_false ,

4149: IF (l_debug = 1) THEN
4150: debug_print( 'delete_so: Calling update_reservation api : ' );
4151: END IF;
4152: inv_reservation_pub.update_reservation( p_api_version_number => 1.0 ,
4153: p_init_msg_lst => fnd_api.g_false ,
4154: x_return_status => x_return_status ,
4155: x_msg_count => x_msg_count ,
4156: x_msg_data => x_msg_data ,
4157: p_original_rsv_rec => l_old_upd_resv_rec ,

Line 4161: p_validation_flag => fnd_api.g_true );

4157: p_original_rsv_rec => l_old_upd_resv_rec ,
4158: p_to_rsv_rec => l_new_upd_resv_rec ,
4159: p_original_serial_number => l_upd_dummy_sn ,
4160: p_to_serial_number => l_upd_dummy_sn ,
4161: p_validation_flag => fnd_api.g_true );
4162:
4163: IF (l_debug = 1) THEN
4164: debug_print( 'delete_so: return of update_reservation api : ' || x_return_status);
4165: END IF;

Line 4166: IF x_return_status <> fnd_api.g_ret_sts_success THEN

4162:
4163: IF (l_debug = 1) THEN
4164: debug_print( 'delete_so: return of update_reservation api : ' || x_return_status);
4165: END IF;
4166: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4167: x_task_rec := p_task_rec;
4168: IF (l_debug = 1) THEN
4169: debug_print( 'delete_so: Error updating reservation ' );
4170: END IF;

Line 4184: x_return_status:= fnd_api.g_ret_sts_unexp_error ;

4180: WHEN OTHERS THEN
4181: IF (l_debug = 1) THEN
4182: debug_print( 'delete_so: OTHERS EXCEPTION !!!! while Updating reservation ' );
4183: END IF;
4184: x_return_status:= fnd_api.g_ret_sts_unexp_error ;
4185: ROLLBACK TO delso;
4186: END;
4187: l_progress := '145';
4188: delete_transaction( x_return_status => x_return_status ,

Line 4197: IF x_return_status = fnd_api.g_ret_sts_error THEN

4193:
4194: IF l_debug = 1 THEN
4195: debug_print( 'x_return_status ' || x_return_status);
4196: END IF;
4197: IF x_return_status = fnd_api.g_ret_sts_error THEN
4198: IF l_debug = 1 THEN
4199: debug_print ( 'delete_so: l_progress: ' || l_progress );
4200: debug_print('delete_so: Error occurred while deleting MMTT');
4201: END IF;

Line 4205: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

4201: END IF;
4202: x_task_rec := p_task_rec;
4203: ROLLBACK TO delso;
4204: RAISE exc_not_deleted ;
4205: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4206: IF l_debug = 1 THEN
4207: debug_print('delete_mo: Error occurred while deleting MMTT');
4208: END IF;
4209: ROLLBACK TO delso;

Line 4240: IF x_return_status = fnd_api.g_ret_sts_error THEN

4236: p_move_order_type => l_mo_type ,
4237: p_mo_line_rec => l_mo_line_rec ,
4238: p_qty_to_backorder => l_transaction_record.primary_quantity);
4239:
4240: IF x_return_status = fnd_api.g_ret_sts_error THEN
4241: IF l_debug = 1 THEN
4242: debug_print('delete_so: Error occurred while backordering WDD');
4243: END IF;
4244: x_task_rec := p_task_rec;

Line 4247: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

4243: END IF;
4244: x_task_rec := p_task_rec;
4245: ROLLBACK TO delso;
4246: RAISE exc_not_deleted ;
4247: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4248: IF l_debug = 1 THEN
4249: debug_print('Unexpected Error occurred while backordering WDD');
4250: END IF;
4251: ROLLBACK TO delso;

Line 4282: IF x_return_status = fnd_api.g_ret_sts_error THEN

4278: backorder( p_line_id => l_transaction_record.move_order_line_id ,p_transaction_temp_id => l_transaction_record.transaction_temp_id , x_return_status => x_return_status , x_msg_count => x_msg_count , x_msg_data => x_msg_data );
4279: IF l_debug = 1 THEN
4280: debug_print( 'x_return_status ' || x_return_status);
4281: END IF;
4282: IF x_return_status = fnd_api.g_ret_sts_error THEN
4283: IF l_debug = 1 THEN
4284: debug_print('delete_so: Unexpected error occurrend while calling BackOrder API');
4285: END IF;
4286: x_task_rec := p_task_rec;

Line 4289: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

4285: END IF;
4286: x_task_rec := p_task_rec;
4287: ROLLBACK TO delso;
4288: RAISE exc_not_deleted ;
4289: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4290: IF l_debug = 1 THEN
4291: debug_print('delete_so: Unexpected error occurred while calling BackOrder API');
4292: END IF;
4293: ROLLBACK TO delso;

Line 4313: IF x_return_status = fnd_api.g_ret_sts_error THEN

4309:
4310: IF l_debug = 1 THEN
4311: debug_print( 'x_return_status ' || x_return_status);
4312: END IF;
4313: IF x_return_status = fnd_api.g_ret_sts_error THEN
4314: IF l_debug = 1 THEN
4315: debug_print('delete_so: Error occurred while deleting parent line in MMTT');
4316: END IF;
4317: x_task_rec := p_task_rec;

Line 4320: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

4316: END IF;
4317: x_task_rec := p_task_rec;
4318: ROLLBACK TO delso;
4319: RAISE exc_not_deleted ;
4320: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4321: IF l_debug = 1 THEN
4322: debug_print('delete_so: Error occurred while deleting MMTT');
4323: END IF;
4324: ROLLBACK TO delso;

Line 4363: l_g_ret_sts_error CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_error;

4359: l_progress VARCHAR2(30) := '200';
4360: l_update_parent BOOLEAN := FALSE ; -- No need to call update_parent_mmtt
4361: x_msg_count NUMBER;
4362: x_msg_data VARCHAR2(50);
4363: l_g_ret_sts_error CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_error;
4364: l_g_ret_sts_unexp_error CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_unexp_error;
4365: l_g_ret_sts_success CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_success;
4366: l_reservation_id NUMBER;
4367: l_pri_rsv_qty NUMBER;

Line 4364: l_g_ret_sts_unexp_error CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_unexp_error;

4360: l_update_parent BOOLEAN := FALSE ; -- No need to call update_parent_mmtt
4361: x_msg_count NUMBER;
4362: x_msg_data VARCHAR2(50);
4363: l_g_ret_sts_error CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_error;
4364: l_g_ret_sts_unexp_error CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_unexp_error;
4365: l_g_ret_sts_success CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_success;
4366: l_reservation_id NUMBER;
4367: l_pri_rsv_qty NUMBER;
4368: l_rsv_qty NUMBER;

Line 4365: l_g_ret_sts_success CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_success;

4361: x_msg_count NUMBER;
4362: x_msg_data VARCHAR2(50);
4363: l_g_ret_sts_error CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_error;
4364: l_g_ret_sts_unexp_error CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_unexp_error;
4365: l_g_ret_sts_success CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_success;
4366: l_reservation_id NUMBER;
4367: l_pri_rsv_qty NUMBER;
4368: l_rsv_qty NUMBER;
4369: l_pri_rsv_uom VARCHAR2(3);

Line 4429: x_return_status := fnd_api.g_ret_sts_success;

4425: FROM mtl_material_transactions_temp t1
4426: WHERE t1.parent_line_id = mmtt.transaction_temp_id
4427: );
4428: BEGIN
4429: x_return_status := fnd_api.g_ret_sts_success;
4430: l_progress := '210';
4431: l_debug := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
4432: IF (l_debug = 1) THEN
4433: debug_print('IN DELETE_MO_TASKS');

Line 4499: IF x_return_status = fnd_api.g_ret_sts_error THEN

4495:
4496: IF l_debug = 1 THEN
4497: debug_print( 'x_return_status ' || x_return_status);
4498: END IF;
4499: IF x_return_status = fnd_api.g_ret_sts_error THEN
4500: IF l_debug = 1 THEN
4501: debug_print ( 'delete_mo: l_progress: ' || l_progress );
4502: debug_print('delete_mo: Error occurred while deleting MMTT');
4503: END IF;

Line 4507: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

4503: END IF;
4504: x_task_rec := p_task_rec;
4505: ROLLBACK TO delmo;
4506: RAISE exc_not_deleted ;
4507: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4508: IF l_debug = 1 THEN
4509: debug_print('delete_mo: Error occurred while deleting MMTT');
4510: END IF;
4511: ROLLBACK TO delmo;

Line 4544: IF x_return_status = fnd_api.g_ret_sts_error THEN

4540:
4541: IF l_debug = 1 THEN
4542: debug_print( 'x_return_status ' || x_return_status);
4543: END IF;
4544: IF x_return_status = fnd_api.g_ret_sts_error THEN
4545: IF l_debug = 1 THEN
4546: debug_print('delete_mo: Error occurred while deleting MMTT');
4547: END IF;
4548: x_task_rec := p_task_rec;

Line 4551: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

4547: END IF;
4548: x_task_rec := p_task_rec;
4549: ROLLBACK TO delmo;
4550: RAISE exc_not_deleted ;
4551: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4552: IF l_debug = 1 THEN
4553: debug_print('delete_mo: Error occurred while deleting MMTT');
4554: END IF;
4555: ROLLBACK TO delmo;

Line 4605: l_g_ret_sts_error CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_error;

4601: l_move_order_rec mtl_txn_request_lines%rowtype ; --MTRL rec
4602: l_op_plan_rec wms_op_plan_instances%rowtype ; --WOPI rec
4603: exc_not_deleted EXCEPTION;
4604: l_op_plan_status NUMBER ;
4605: l_g_ret_sts_error CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_error;
4606: l_g_ret_sts_unexp_error CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_unexp_error;
4607: l_g_ret_sts_success CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_success;
4608: CURSOR c_mmtt_info
4609: IS

Line 4606: l_g_ret_sts_unexp_error CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_unexp_error;

4602: l_op_plan_rec wms_op_plan_instances%rowtype ; --WOPI rec
4603: exc_not_deleted EXCEPTION;
4604: l_op_plan_status NUMBER ;
4605: l_g_ret_sts_error CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_error;
4606: l_g_ret_sts_unexp_error CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_unexp_error;
4607: l_g_ret_sts_success CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_success;
4608: CURSOR c_mmtt_info
4609: IS
4610: SELECT mmtt.transaction_temp_id ,

Line 4607: l_g_ret_sts_success CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_success;

4603: exc_not_deleted EXCEPTION;
4604: l_op_plan_status NUMBER ;
4605: l_g_ret_sts_error CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_error;
4606: l_g_ret_sts_unexp_error CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_unexp_error;
4607: l_g_ret_sts_success CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_success;
4608: CURSOR c_mmtt_info
4609: IS
4610: SELECT mmtt.transaction_temp_id ,
4611: mmtt.parent_line_id ,

Line 4665: x_return_status := fnd_api.g_ret_sts_success;

4661: FROM WMS_OP_PLAN_INSTANCES
4662: WHERE source_task_id = l_transaction_record.parent_line_id;
4663: BEGIN
4664: l_debug := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
4665: x_return_status := fnd_api.g_ret_sts_success;
4666: l_progress := '300';
4667: IF (l_debug = 1) THEN
4668: debug_print('IN DELETE_INBOUND_TASKS');
4669: debug_print( 'l_progress: ' || l_progress );

Line 4770: IF x_return_status = fnd_api.g_ret_sts_error THEN

4766: p_transaction_temp_id => l_transaction_record.transaction_temp_id ,p_update_parent => l_update_parent );
4767: IF l_debug = 1 THEN
4768: debug_print( 'x_return_status ' || x_return_status);
4769: END IF;
4770: IF x_return_status = fnd_api.g_ret_sts_error THEN
4771: IF l_debug = 1 THEN
4772: debug_print('delete_inbound_tasks: Error while deleting MMTT/MTLT/MSNT/WDT');
4773: END IF;
4774: x_task_rec := p_task_rec;

Line 4777: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

4773: END IF;
4774: x_task_rec := p_task_rec;
4775: ROLLBACK TO delinb;
4776: RAISE exc_not_deleted ;
4777: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4778: IF l_debug = 1 THEN
4779: debug_print('delete_inbound_tasks: Error occurred while deleting MMTT');
4780: END IF;
4781: ROLLBACK TO delinb;

Line 4809: IF l_return_status <> fnd_api.g_ret_sts_success THEN

4805: p_quantity => l_transaction_record.primary_quantity );
4806: IF l_debug = 1 THEN
4807: debug_print( 'Return status from revert_loc_suggested_capacity ' || x_return_status);
4808: END IF;
4809: IF l_return_status <> fnd_api.g_ret_sts_success THEN
4810: IF l_debug = 1 THEN
4811: debug_print('delete_inbound_tasks: Error while reverting locator capacity');
4812: END IF;
4813: x_task_rec := p_task_rec;

Line 4896: l_g_ret_sts_error CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_error;

4892: l_update_cyc NUMBER;
4893: l_cyc_task NUMBER;
4894: l_debug NUMBER;
4895: exc_not_deleted EXCEPTION;
4896: l_g_ret_sts_error CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_error;
4897: l_g_ret_sts_unexp_error CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_unexp_error;
4898: l_g_ret_sts_success CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_success;
4899: BEGIN
4900: x_return_status := fnd_api.g_ret_sts_success;

Line 4897: l_g_ret_sts_unexp_error CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_unexp_error;

4893: l_cyc_task NUMBER;
4894: l_debug NUMBER;
4895: exc_not_deleted EXCEPTION;
4896: l_g_ret_sts_error CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_error;
4897: l_g_ret_sts_unexp_error CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_unexp_error;
4898: l_g_ret_sts_success CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_success;
4899: BEGIN
4900: x_return_status := fnd_api.g_ret_sts_success;
4901: l_debug := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

Line 4898: l_g_ret_sts_success CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_success;

4894: l_debug NUMBER;
4895: exc_not_deleted EXCEPTION;
4896: l_g_ret_sts_error CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_error;
4897: l_g_ret_sts_unexp_error CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_unexp_error;
4898: l_g_ret_sts_success CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_success;
4899: BEGIN
4900: x_return_status := fnd_api.g_ret_sts_success;
4901: l_debug := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
4902: l_cc_entry_id := p_task_rec.transaction_number ;

Line 4900: x_return_status := fnd_api.g_ret_sts_success;

4896: l_g_ret_sts_error CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_error;
4897: l_g_ret_sts_unexp_error CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_unexp_error;
4898: l_g_ret_sts_success CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_success;
4899: BEGIN
4900: x_return_status := fnd_api.g_ret_sts_success;
4901: l_debug := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
4902: l_cc_entry_id := p_task_rec.transaction_number ;
4903: SAVEPOINT delcyc;
4904: SELECT cycle_count_header_id

Line 4968: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE ,

4964: /*This Public API takes care of deleting a single task or a table of tasks as is passed to the API.
4965: The types of tasks that this API handles include Inbound, Outbound, Warehouse and Manufacturing Tasks.
4966:
4967: PROCEDURE delete_tasks ( p_transaction_number IN NUMBER DEFAULT NULL ,
4968: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE ,
4969: p_wms_task IN WMS_TASK_MGMT_PUB.task_tab_type ,
4970: x_undeleted_tasks OUT NOCOPY WMS_TASK_MGMT_PUB.task_tab_type ,
4971: x_return_status OUT NOCOPY VARCHAR2 ,
4972: x_msg_count OUT NOCOPY NUMBER ,

Line 4988: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE ,

4984: X_msg_data This gives the descrption of the messages that got logged during the task deletion process.
4985: -------------------------------------------------------------------------------------------------------------------*/
4986:
4987: PROCEDURE delete_tasks ( p_transaction_number IN NUMBER DEFAULT NULL ,
4988: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE ,
4989: p_wms_task IN WMS_TASK_MGMT_PUB.task_tab_type ,
4990: x_undeleted_tasks OUT NOCOPY WMS_TASK_MGMT_PUB.task_tab_type ,
4991: x_return_status OUT NOCOPY VARCHAR2 ,
4992: x_msg_count OUT NOCOPY NUMBER ,

Line 5005: l_g_ret_sts_error CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_error;

5001: l_ret_task_table WMS_TASK_MGMT_PUB.task_tab_type ;
5002: l_val_ret_status VARCHAR2(30);
5003: l_task_type NUMBER ;
5004: l_task_exists NUMBER :=0 ;
5005: l_g_ret_sts_error CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_error;
5006: l_g_ret_sts_unexp_error CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_unexp_error;
5007: l_g_ret_sts_success CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_success;
5008: exec_unexp EXCEPTION;
5009: l_lock_cyc_rec NUMBER;

Line 5006: l_g_ret_sts_unexp_error CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_unexp_error;

5002: l_val_ret_status VARCHAR2(30);
5003: l_task_type NUMBER ;
5004: l_task_exists NUMBER :=0 ;
5005: l_g_ret_sts_error CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_error;
5006: l_g_ret_sts_unexp_error CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_unexp_error;
5007: l_g_ret_sts_success CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_success;
5008: exec_unexp EXCEPTION;
5009: l_lock_cyc_rec NUMBER;
5010: l_debug NUMBER;

Line 5007: l_g_ret_sts_success CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_success;

5003: l_task_type NUMBER ;
5004: l_task_exists NUMBER :=0 ;
5005: l_g_ret_sts_error CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_error;
5006: l_g_ret_sts_unexp_error CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_unexp_error;
5007: l_g_ret_sts_success CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_success;
5008: exec_unexp EXCEPTION;
5009: l_lock_cyc_rec NUMBER;
5010: l_debug NUMBER;
5011: undel_task NUMBER;

Line 5014: x_return_status := fnd_api.g_ret_sts_success;

5010: l_debug NUMBER;
5011: undel_task NUMBER;
5012: l_msg VARCHAR2(2000);--anjana
5013: BEGIN
5014: x_return_status := fnd_api.g_ret_sts_success;
5015: --anjana
5016: x_msg_count := 0;
5017: l_debug := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
5018: l_val_ret_status :='S' ;

Line 5113: -- fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);

5109: x_undeleted_tasks(undel_task).RESULT := x_task_rec.status;
5110: x_undeleted_tasks(undel_task).error := l_msg;
5111: undel_task :=undel_task+1;
5112: -- FND_MSG_PUB.ADD;
5113: -- fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
5114: END IF;
5115: IF x_return_status ='U' THEN
5116: IF l_debug = 1 THEN
5117: debug_print('The called program returned unexpected error status' );

Line 5131: -- fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);

5127: l_msg := fnd_message.get;
5128: x_msg_count := x_msg_count + 1;
5129: x_msg_data := x_msg_data || l_msg;
5130: -- FND_MSG_PUB.ADD;
5131: -- fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
5132:
5133: x_undeleted_tasks(undel_task).transaction_number:= l_ret_task_table(i).transaction_number ; --6888354 Bug
5134: x_undeleted_tasks(undel_task).RESULT := l_ret_task_table(i).RESULT;
5135: x_undeleted_tasks(undel_task).error := l_msg;

Line 5145: IF p_commit = FND_API.G_TRUE THEN

5141: debug_print('Invalid status returned from Validate_Task' );
5142: END IF;
5143: RAISE exec_unexp;
5144: END IF; --End of Validation Status 'S'.
5145: IF p_commit = FND_API.G_TRUE THEN
5146: COMMIT;
5147: END IF ;
5148: EXCEPTION
5149: WHEN exec_unexp THEN

Line 5156: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);

5152: END IF;
5153: x_return_status := l_g_ret_sts_unexp_error;
5154: FND_MESSAGE.SET_NAME('WMS', 'WMS_UNEXPECTED_ERROR');
5155: FND_MSG_PUB.ADD;
5156: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
5157: ROLLBACK TO deltask;
5158: WHEN OTHERS THEN
5159: IF l_debug = 1 THEN
5160: debug_print('In the When Others Exception of Delete_Tasks, Rolling back.' );

Line 5165: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);

5161: END IF;
5162: x_return_status := l_g_ret_sts_unexp_error;
5163: FND_MESSAGE.SET_NAME('WMS', 'WMS_UNEXPECTED_ERROR');
5164: FND_MSG_PUB.ADD;
5165: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
5166: ROLLBACK TO deltask;
5167: END DELETE_TASKS;
5168:
5169: -------------------------------------------------------------------------------------------------------------------

Line 5368: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

5364: l_err_msg := 'Status returned by API wms_waveplan_tasks_pvt.query_tasks: '||x_return_status;
5365: inv_trx_util_pub.trace(l_api_name||': '||l_err_msg);
5366: END IF;
5367:
5368: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5369: /* SELECT * BULK COLLECT
5370: INTO x_task_tab
5371: FROM wms_waveplan_tasks_temp
5372: WHERE transaction_temp_id = p_transaction_number;*/

Line 5569: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

5565: l_err_msg := 'Status returned by API wms_waveplan_tasks_pvt.query_tasks for cycle count task: '||x_return_status;
5566: inv_trx_util_pub.trace(l_api_name||': '||l_err_msg);
5567: END IF;
5568:
5569: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5570: /* SELECT * BULK COLLECT
5571: INTO x_task_tab
5572: FROM wms_waveplan_tasks_temp
5573: WHERE transaction_temp_id = p_transaction_number;*/

Line 5824: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

5820: l_err_msg := 'Status returned by API wms_waveplan_tasks_pvt.query_tasks: '||x_return_status;
5821: inv_trx_util_pub.trace(l_api_name||': '||l_err_msg);
5822: END IF;
5823:
5824: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5825: SELECT
5826: TASK_ID,
5827: TRANSACTION_TEMP_ID,
5828: PARENT_LINE_ID,

Line 6016: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

6012: l_err_msg := 'Status returned by API wms_waveplan_tasks_pvt.query_tasks: '||x_return_status;
6013: inv_trx_util_pub.trace(l_api_name||': '||l_err_msg);
6014: END IF;
6015:
6016: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
6017: SELECT
6018: TASK_ID,
6019: TRANSACTION_TEMP_ID,
6020: PARENT_LINE_ID,

Line 6147: x_return_status := fnd_api.g_ret_sts_unexp_error;

6143: WHEN NO_DATA_FOUND THEN
6144: inv_trx_util_pub.trace('in the exception block of outbond/manufacturing/warehousing complete tasks');
6145: fnd_message.set_name('WMS', 'WMS_INVALID_TASK');
6146: fnd_msg_pub.ADD;
6147: x_return_status := fnd_api.g_ret_sts_unexp_error;
6148: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
6149: l_err_msg := 'Failed to fetch data from MMTT,MCCE,MMT or WDTH tables for transaction number '||p_transaction_number;
6150: IF(l_debug = 1) THEN
6151: inv_trx_util_pub.trace(l_api_name||': '||l_err_msg);

Line 6148: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);

6144: inv_trx_util_pub.trace('in the exception block of outbond/manufacturing/warehousing complete tasks');
6145: fnd_message.set_name('WMS', 'WMS_INVALID_TASK');
6146: fnd_msg_pub.ADD;
6147: x_return_status := fnd_api.g_ret_sts_unexp_error;
6148: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
6149: l_err_msg := 'Failed to fetch data from MMTT,MCCE,MMT or WDTH tables for transaction number '||p_transaction_number;
6150: IF(l_debug = 1) THEN
6151: inv_trx_util_pub.trace(l_api_name||': '||l_err_msg);
6152: END IF;

Line 6160: x_return_status := fnd_api.g_ret_sts_unexp_error;

6156: --end the begin block for inbound/crossdock complete tasks
6157: END;
6158: --end the begin block for cycle count tasks
6159: WHEN OTHERS THEN
6160: x_return_status := fnd_api.g_ret_sts_unexp_error;
6161: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
6162: l_err_msg := substr(SQLERRM,1,1000);
6163: IF(l_debug = 1) THEN
6164: inv_trx_util_pub.trace(l_api_name||': '||l_err_msg);

Line 6161: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);

6157: END;
6158: --end the begin block for cycle count tasks
6159: WHEN OTHERS THEN
6160: x_return_status := fnd_api.g_ret_sts_unexp_error;
6161: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
6162: l_err_msg := substr(SQLERRM,1,1000);
6163: IF(l_debug = 1) THEN
6164: inv_trx_util_pub.trace(l_api_name||': '||l_err_msg);
6165: END IF;

Line 6209: --Munish is adding (g_main_tab(93).field_value = FND_API.G_TRUE) to check crossdock task

6205:
6206: --- check the credentials of the query_name passed as input
6207:
6208: ---if 'inbound' task is queried then
6209: --Munish is adding (g_main_tab(93).field_value = FND_API.G_TRUE) to check crossdock task
6210: IF(g_main_tab(35).field_value = FND_API.G_TRUE) OR (g_main_tab(93).field_value = FND_API.G_TRUE) THEN
6211: -- IF(g_main_tab(35).field_value = FND_API.G_TRUE) THEN
6212: ---if its planned or independent task
6213: IF ((g_main_tab(36).field_value = FND_API.G_TRUE)

Line 6210: IF(g_main_tab(35).field_value = FND_API.G_TRUE) OR (g_main_tab(93).field_value = FND_API.G_TRUE) THEN

6206: --- check the credentials of the query_name passed as input
6207:
6208: ---if 'inbound' task is queried then
6209: --Munish is adding (g_main_tab(93).field_value = FND_API.G_TRUE) to check crossdock task
6210: IF(g_main_tab(35).field_value = FND_API.G_TRUE) OR (g_main_tab(93).field_value = FND_API.G_TRUE) THEN
6211: -- IF(g_main_tab(35).field_value = FND_API.G_TRUE) THEN
6212: ---if its planned or independent task
6213: IF ((g_main_tab(36).field_value = FND_API.G_TRUE)
6214: OR (g_main_tab(58).field_value = FND_API.G_TRUE))

Line 6211: -- IF(g_main_tab(35).field_value = FND_API.G_TRUE) THEN

6207:
6208: ---if 'inbound' task is queried then
6209: --Munish is adding (g_main_tab(93).field_value = FND_API.G_TRUE) to check crossdock task
6210: IF(g_main_tab(35).field_value = FND_API.G_TRUE) OR (g_main_tab(93).field_value = FND_API.G_TRUE) THEN
6211: -- IF(g_main_tab(35).field_value = FND_API.G_TRUE) THEN
6212: ---if its planned or independent task
6213: IF ((g_main_tab(36).field_value = FND_API.G_TRUE)
6214: OR (g_main_tab(58).field_value = FND_API.G_TRUE))
6215: THEN

Line 6213: IF ((g_main_tab(36).field_value = FND_API.G_TRUE)

6209: --Munish is adding (g_main_tab(93).field_value = FND_API.G_TRUE) to check crossdock task
6210: IF(g_main_tab(35).field_value = FND_API.G_TRUE) OR (g_main_tab(93).field_value = FND_API.G_TRUE) THEN
6211: -- IF(g_main_tab(35).field_value = FND_API.G_TRUE) THEN
6212: ---if its planned or independent task
6213: IF ((g_main_tab(36).field_value = FND_API.G_TRUE)
6214: OR (g_main_tab(58).field_value = FND_API.G_TRUE))
6215: THEN
6216: ---the status has to be either one of the following:
6217: ---unreleased, pending, queued, dispatched,active, loaded, completed

Line 6214: OR (g_main_tab(58).field_value = FND_API.G_TRUE))

6210: IF(g_main_tab(35).field_value = FND_API.G_TRUE) OR (g_main_tab(93).field_value = FND_API.G_TRUE) THEN
6211: -- IF(g_main_tab(35).field_value = FND_API.G_TRUE) THEN
6212: ---if its planned or independent task
6213: IF ((g_main_tab(36).field_value = FND_API.G_TRUE)
6214: OR (g_main_tab(58).field_value = FND_API.G_TRUE))
6215: THEN
6216: ---the status has to be either one of the following:
6217: ---unreleased, pending, queued, dispatched,active, loaded, completed
6218: IF((g_main_tab(1).field_value = FND_API.G_TRUE)

Line 6218: IF((g_main_tab(1).field_value = FND_API.G_TRUE)

6214: OR (g_main_tab(58).field_value = FND_API.G_TRUE))
6215: THEN
6216: ---the status has to be either one of the following:
6217: ---unreleased, pending, queued, dispatched,active, loaded, completed
6218: IF((g_main_tab(1).field_value = FND_API.G_TRUE)
6219: OR (g_main_tab(5).field_value = FND_API.G_TRUE)
6220: OR (g_main_tab(12).field_value = FND_API.G_TRUE)
6221: OR (g_main_tab(39).field_value = FND_API.G_TRUE)
6222: OR (g_main_tab(51).field_value = FND_API.G_TRUE)

Line 6219: OR (g_main_tab(5).field_value = FND_API.G_TRUE)

6215: THEN
6216: ---the status has to be either one of the following:
6217: ---unreleased, pending, queued, dispatched,active, loaded, completed
6218: IF((g_main_tab(1).field_value = FND_API.G_TRUE)
6219: OR (g_main_tab(5).field_value = FND_API.G_TRUE)
6220: OR (g_main_tab(12).field_value = FND_API.G_TRUE)
6221: OR (g_main_tab(39).field_value = FND_API.G_TRUE)
6222: OR (g_main_tab(51).field_value = FND_API.G_TRUE)
6223: OR (g_main_tab(59).field_value = FND_API.G_TRUE)

Line 6220: OR (g_main_tab(12).field_value = FND_API.G_TRUE)

6216: ---the status has to be either one of the following:
6217: ---unreleased, pending, queued, dispatched,active, loaded, completed
6218: IF((g_main_tab(1).field_value = FND_API.G_TRUE)
6219: OR (g_main_tab(5).field_value = FND_API.G_TRUE)
6220: OR (g_main_tab(12).field_value = FND_API.G_TRUE)
6221: OR (g_main_tab(39).field_value = FND_API.G_TRUE)
6222: OR (g_main_tab(51).field_value = FND_API.G_TRUE)
6223: OR (g_main_tab(59).field_value = FND_API.G_TRUE)
6224: OR (g_main_tab(90).field_value = FND_API.G_TRUE))

Line 6221: OR (g_main_tab(39).field_value = FND_API.G_TRUE)

6217: ---unreleased, pending, queued, dispatched,active, loaded, completed
6218: IF((g_main_tab(1).field_value = FND_API.G_TRUE)
6219: OR (g_main_tab(5).field_value = FND_API.G_TRUE)
6220: OR (g_main_tab(12).field_value = FND_API.G_TRUE)
6221: OR (g_main_tab(39).field_value = FND_API.G_TRUE)
6222: OR (g_main_tab(51).field_value = FND_API.G_TRUE)
6223: OR (g_main_tab(59).field_value = FND_API.G_TRUE)
6224: OR (g_main_tab(90).field_value = FND_API.G_TRUE))
6225: THEN

Line 6222: OR (g_main_tab(51).field_value = FND_API.G_TRUE)

6218: IF((g_main_tab(1).field_value = FND_API.G_TRUE)
6219: OR (g_main_tab(5).field_value = FND_API.G_TRUE)
6220: OR (g_main_tab(12).field_value = FND_API.G_TRUE)
6221: OR (g_main_tab(39).field_value = FND_API.G_TRUE)
6222: OR (g_main_tab(51).field_value = FND_API.G_TRUE)
6223: OR (g_main_tab(59).field_value = FND_API.G_TRUE)
6224: OR (g_main_tab(90).field_value = FND_API.G_TRUE))
6225: THEN
6226: l_execute_qry := TRUE;

Line 6223: OR (g_main_tab(59).field_value = FND_API.G_TRUE)

6219: OR (g_main_tab(5).field_value = FND_API.G_TRUE)
6220: OR (g_main_tab(12).field_value = FND_API.G_TRUE)
6221: OR (g_main_tab(39).field_value = FND_API.G_TRUE)
6222: OR (g_main_tab(51).field_value = FND_API.G_TRUE)
6223: OR (g_main_tab(59).field_value = FND_API.G_TRUE)
6224: OR (g_main_tab(90).field_value = FND_API.G_TRUE))
6225: THEN
6226: l_execute_qry := TRUE;
6227: END IF;

Line 6224: OR (g_main_tab(90).field_value = FND_API.G_TRUE))

6220: OR (g_main_tab(12).field_value = FND_API.G_TRUE)
6221: OR (g_main_tab(39).field_value = FND_API.G_TRUE)
6222: OR (g_main_tab(51).field_value = FND_API.G_TRUE)
6223: OR (g_main_tab(59).field_value = FND_API.G_TRUE)
6224: OR (g_main_tab(90).field_value = FND_API.G_TRUE))
6225: THEN
6226: l_execute_qry := TRUE;
6227: END IF;
6228: --else if it's not planned or independent task then

Line 6231: ELSIF((g_main_tab(53).field_value = FND_API.G_TRUE)

6227: END IF;
6228: --else if it's not planned or independent task then
6229: --it has to be either one of plan_pending, plan_in_progress, plan_completed
6230: --plan_cancelled or plan_aborted
6231: ELSIF((g_main_tab(53).field_value = FND_API.G_TRUE)
6232: OR (g_main_tab(54).field_value = FND_API.G_TRUE)
6233: OR (g_main_tab(55).field_value = FND_API.G_TRUE)
6234: OR (g_main_tab(56).field_value = FND_API.G_TRUE)
6235: OR (g_main_tab(57).field_value = FND_API.G_TRUE))

Line 6232: OR (g_main_tab(54).field_value = FND_API.G_TRUE)

6228: --else if it's not planned or independent task then
6229: --it has to be either one of plan_pending, plan_in_progress, plan_completed
6230: --plan_cancelled or plan_aborted
6231: ELSIF((g_main_tab(53).field_value = FND_API.G_TRUE)
6232: OR (g_main_tab(54).field_value = FND_API.G_TRUE)
6233: OR (g_main_tab(55).field_value = FND_API.G_TRUE)
6234: OR (g_main_tab(56).field_value = FND_API.G_TRUE)
6235: OR (g_main_tab(57).field_value = FND_API.G_TRUE))
6236: THEN

Line 6233: OR (g_main_tab(55).field_value = FND_API.G_TRUE)

6229: --it has to be either one of plan_pending, plan_in_progress, plan_completed
6230: --plan_cancelled or plan_aborted
6231: ELSIF((g_main_tab(53).field_value = FND_API.G_TRUE)
6232: OR (g_main_tab(54).field_value = FND_API.G_TRUE)
6233: OR (g_main_tab(55).field_value = FND_API.G_TRUE)
6234: OR (g_main_tab(56).field_value = FND_API.G_TRUE)
6235: OR (g_main_tab(57).field_value = FND_API.G_TRUE))
6236: THEN
6237: l_execute_qry := TRUE;

Line 6234: OR (g_main_tab(56).field_value = FND_API.G_TRUE)

6230: --plan_cancelled or plan_aborted
6231: ELSIF((g_main_tab(53).field_value = FND_API.G_TRUE)
6232: OR (g_main_tab(54).field_value = FND_API.G_TRUE)
6233: OR (g_main_tab(55).field_value = FND_API.G_TRUE)
6234: OR (g_main_tab(56).field_value = FND_API.G_TRUE)
6235: OR (g_main_tab(57).field_value = FND_API.G_TRUE))
6236: THEN
6237: l_execute_qry := TRUE;
6238: ELSE

Line 6235: OR (g_main_tab(57).field_value = FND_API.G_TRUE))

6231: ELSIF((g_main_tab(53).field_value = FND_API.G_TRUE)
6232: OR (g_main_tab(54).field_value = FND_API.G_TRUE)
6233: OR (g_main_tab(55).field_value = FND_API.G_TRUE)
6234: OR (g_main_tab(56).field_value = FND_API.G_TRUE)
6235: OR (g_main_tab(57).field_value = FND_API.G_TRUE))
6236: THEN
6237: l_execute_qry := TRUE;
6238: ELSE
6239: l_execute_qry := FALSE;

Line 6248: IF ((g_main_tab(50).field_value = FND_API.G_TRUE)

6244: END IF;
6245: END IF;
6246:
6247: --If its either outbound, manufacturing or warehousing tasks
6248: IF ((g_main_tab(50).field_value = FND_API.G_TRUE)
6249: OR(g_main_tab(42).field_value = FND_API.G_TRUE)
6250: OR(g_main_tab(92).field_value = FND_API.G_TRUE))
6251: THEN
6252: ---the status has to be either one of the following:

Line 6249: OR(g_main_tab(42).field_value = FND_API.G_TRUE)

6245: END IF;
6246:
6247: --If its either outbound, manufacturing or warehousing tasks
6248: IF ((g_main_tab(50).field_value = FND_API.G_TRUE)
6249: OR(g_main_tab(42).field_value = FND_API.G_TRUE)
6250: OR(g_main_tab(92).field_value = FND_API.G_TRUE))
6251: THEN
6252: ---the status has to be either one of the following:
6253: ---unreleased, pending, queued, dispatched,active, loaded, completed

Line 6250: OR(g_main_tab(92).field_value = FND_API.G_TRUE))

6246:
6247: --If its either outbound, manufacturing or warehousing tasks
6248: IF ((g_main_tab(50).field_value = FND_API.G_TRUE)
6249: OR(g_main_tab(42).field_value = FND_API.G_TRUE)
6250: OR(g_main_tab(92).field_value = FND_API.G_TRUE))
6251: THEN
6252: ---the status has to be either one of the following:
6253: ---unreleased, pending, queued, dispatched,active, loaded, completed
6254: IF((g_main_tab(1).field_value = FND_API.G_TRUE)

Line 6254: IF((g_main_tab(1).field_value = FND_API.G_TRUE)

6250: OR(g_main_tab(92).field_value = FND_API.G_TRUE))
6251: THEN
6252: ---the status has to be either one of the following:
6253: ---unreleased, pending, queued, dispatched,active, loaded, completed
6254: IF((g_main_tab(1).field_value = FND_API.G_TRUE)
6255: OR (g_main_tab(5).field_value = FND_API.G_TRUE)
6256: OR (g_main_tab(12).field_value = FND_API.G_TRUE)
6257: OR (g_main_tab(39).field_value = FND_API.G_TRUE)
6258: OR (g_main_tab(51).field_value = FND_API.G_TRUE)

Line 6255: OR (g_main_tab(5).field_value = FND_API.G_TRUE)

6251: THEN
6252: ---the status has to be either one of the following:
6253: ---unreleased, pending, queued, dispatched,active, loaded, completed
6254: IF((g_main_tab(1).field_value = FND_API.G_TRUE)
6255: OR (g_main_tab(5).field_value = FND_API.G_TRUE)
6256: OR (g_main_tab(12).field_value = FND_API.G_TRUE)
6257: OR (g_main_tab(39).field_value = FND_API.G_TRUE)
6258: OR (g_main_tab(51).field_value = FND_API.G_TRUE)
6259: OR (g_main_tab(59).field_value = FND_API.G_TRUE)

Line 6256: OR (g_main_tab(12).field_value = FND_API.G_TRUE)

6252: ---the status has to be either one of the following:
6253: ---unreleased, pending, queued, dispatched,active, loaded, completed
6254: IF((g_main_tab(1).field_value = FND_API.G_TRUE)
6255: OR (g_main_tab(5).field_value = FND_API.G_TRUE)
6256: OR (g_main_tab(12).field_value = FND_API.G_TRUE)
6257: OR (g_main_tab(39).field_value = FND_API.G_TRUE)
6258: OR (g_main_tab(51).field_value = FND_API.G_TRUE)
6259: OR (g_main_tab(59).field_value = FND_API.G_TRUE)
6260: OR (g_main_tab(90).field_value = FND_API.G_TRUE))

Line 6257: OR (g_main_tab(39).field_value = FND_API.G_TRUE)

6253: ---unreleased, pending, queued, dispatched,active, loaded, completed
6254: IF((g_main_tab(1).field_value = FND_API.G_TRUE)
6255: OR (g_main_tab(5).field_value = FND_API.G_TRUE)
6256: OR (g_main_tab(12).field_value = FND_API.G_TRUE)
6257: OR (g_main_tab(39).field_value = FND_API.G_TRUE)
6258: OR (g_main_tab(51).field_value = FND_API.G_TRUE)
6259: OR (g_main_tab(59).field_value = FND_API.G_TRUE)
6260: OR (g_main_tab(90).field_value = FND_API.G_TRUE))
6261: THEN

Line 6258: OR (g_main_tab(51).field_value = FND_API.G_TRUE)

6254: IF((g_main_tab(1).field_value = FND_API.G_TRUE)
6255: OR (g_main_tab(5).field_value = FND_API.G_TRUE)
6256: OR (g_main_tab(12).field_value = FND_API.G_TRUE)
6257: OR (g_main_tab(39).field_value = FND_API.G_TRUE)
6258: OR (g_main_tab(51).field_value = FND_API.G_TRUE)
6259: OR (g_main_tab(59).field_value = FND_API.G_TRUE)
6260: OR (g_main_tab(90).field_value = FND_API.G_TRUE))
6261: THEN
6262: l_execute_qry := TRUE;

Line 6259: OR (g_main_tab(59).field_value = FND_API.G_TRUE)

6255: OR (g_main_tab(5).field_value = FND_API.G_TRUE)
6256: OR (g_main_tab(12).field_value = FND_API.G_TRUE)
6257: OR (g_main_tab(39).field_value = FND_API.G_TRUE)
6258: OR (g_main_tab(51).field_value = FND_API.G_TRUE)
6259: OR (g_main_tab(59).field_value = FND_API.G_TRUE)
6260: OR (g_main_tab(90).field_value = FND_API.G_TRUE))
6261: THEN
6262: l_execute_qry := TRUE;
6263: END IF;

Line 6260: OR (g_main_tab(90).field_value = FND_API.G_TRUE))

6256: OR (g_main_tab(12).field_value = FND_API.G_TRUE)
6257: OR (g_main_tab(39).field_value = FND_API.G_TRUE)
6258: OR (g_main_tab(51).field_value = FND_API.G_TRUE)
6259: OR (g_main_tab(59).field_value = FND_API.G_TRUE)
6260: OR (g_main_tab(90).field_value = FND_API.G_TRUE))
6261: THEN
6262: l_execute_qry := TRUE;
6263: END IF;
6264: ---else if its neither one of the following tasks then generate error message

Line 6266: ELSIF ((g_main_tab(50).field_value = FND_API.G_FALSE)

6262: l_execute_qry := TRUE;
6263: END IF;
6264: ---else if its neither one of the following tasks then generate error message
6265: ---outbound, inbound, manufacturing, warehousing
6266: ELSIF ((g_main_tab(50).field_value = FND_API.G_FALSE)
6267: AND(g_main_tab(42).field_value = FND_API.G_FALSE)
6268: AND(g_main_tab(92).field_value = FND_API.G_FALSE)
6269: AND(g_main_tab(35).field_value = FND_API.G_FALSE)
6270: AND (g_main_tab(93).field_value = FND_API.G_FALSE))

Line 6267: AND(g_main_tab(42).field_value = FND_API.G_FALSE)

6263: END IF;
6264: ---else if its neither one of the following tasks then generate error message
6265: ---outbound, inbound, manufacturing, warehousing
6266: ELSIF ((g_main_tab(50).field_value = FND_API.G_FALSE)
6267: AND(g_main_tab(42).field_value = FND_API.G_FALSE)
6268: AND(g_main_tab(92).field_value = FND_API.G_FALSE)
6269: AND(g_main_tab(35).field_value = FND_API.G_FALSE)
6270: AND (g_main_tab(93).field_value = FND_API.G_FALSE))
6271: THEN

Line 6268: AND(g_main_tab(92).field_value = FND_API.G_FALSE)

6264: ---else if its neither one of the following tasks then generate error message
6265: ---outbound, inbound, manufacturing, warehousing
6266: ELSIF ((g_main_tab(50).field_value = FND_API.G_FALSE)
6267: AND(g_main_tab(42).field_value = FND_API.G_FALSE)
6268: AND(g_main_tab(92).field_value = FND_API.G_FALSE)
6269: AND(g_main_tab(35).field_value = FND_API.G_FALSE)
6270: AND (g_main_tab(93).field_value = FND_API.G_FALSE))
6271: THEN
6272: l_execute_qry := FALSE;

Line 6269: AND(g_main_tab(35).field_value = FND_API.G_FALSE)

6265: ---outbound, inbound, manufacturing, warehousing
6266: ELSIF ((g_main_tab(50).field_value = FND_API.G_FALSE)
6267: AND(g_main_tab(42).field_value = FND_API.G_FALSE)
6268: AND(g_main_tab(92).field_value = FND_API.G_FALSE)
6269: AND(g_main_tab(35).field_value = FND_API.G_FALSE)
6270: AND (g_main_tab(93).field_value = FND_API.G_FALSE))
6271: THEN
6272: l_execute_qry := FALSE;
6273: l_err_msg := 'Invalid query criteria';

Line 6270: AND (g_main_tab(93).field_value = FND_API.G_FALSE))

6266: ELSIF ((g_main_tab(50).field_value = FND_API.G_FALSE)
6267: AND(g_main_tab(42).field_value = FND_API.G_FALSE)
6268: AND(g_main_tab(92).field_value = FND_API.G_FALSE)
6269: AND(g_main_tab(35).field_value = FND_API.G_FALSE)
6270: AND (g_main_tab(93).field_value = FND_API.G_FALSE))
6271: THEN
6272: l_execute_qry := FALSE;
6273: l_err_msg := 'Invalid query criteria';
6274: fnd_message.set_name('WMS', 'WMS_NO_SOURCE_ENTERED');

Line 6339: fnd_api.to_boolean(g_main_tab(90).field_value), ---p_is_unreleased BOOLEAN DEFAULT FALSE,

6335: g_main_tab(32).field_value, ---p_from_task_priority NUMBER DEFAULT NULL,
6336: g_main_tab(86).field_value, ---p_to_task_priority NUMBER DEFAULT NULL,
6337: g_main_tab(16).field_value, ---p_from_creation_date DATE DEFAULT NULL,
6338: g_main_tab(68).field_value, ---p_to_creation_date DATE DEFAULT NULL,
6339: fnd_api.to_boolean(g_main_tab(90).field_value), ---p_is_unreleased BOOLEAN DEFAULT FALSE,
6340: fnd_api.to_boolean(g_main_tab(51).field_value), ---p_is_pending BOOLEAN DEFAULT FALSE,
6341: fnd_api.to_boolean(g_main_tab(59).field_value), ---p_is_queued BOOLEAN DEFAULT FALSE,
6342: fnd_api.to_boolean(g_main_tab(12).field_value), ---p_is_dispatched BOOLEAN DEFAULT FALSE,
6343: fnd_api.to_boolean(g_main_tab(1).field_value), ---p_is_active BOOLEAN DEFAULT FALSE,

Line 6340: fnd_api.to_boolean(g_main_tab(51).field_value), ---p_is_pending BOOLEAN DEFAULT FALSE,

6336: g_main_tab(86).field_value, ---p_to_task_priority NUMBER DEFAULT NULL,
6337: g_main_tab(16).field_value, ---p_from_creation_date DATE DEFAULT NULL,
6338: g_main_tab(68).field_value, ---p_to_creation_date DATE DEFAULT NULL,
6339: fnd_api.to_boolean(g_main_tab(90).field_value), ---p_is_unreleased BOOLEAN DEFAULT FALSE,
6340: fnd_api.to_boolean(g_main_tab(51).field_value), ---p_is_pending BOOLEAN DEFAULT FALSE,
6341: fnd_api.to_boolean(g_main_tab(59).field_value), ---p_is_queued BOOLEAN DEFAULT FALSE,
6342: fnd_api.to_boolean(g_main_tab(12).field_value), ---p_is_dispatched BOOLEAN DEFAULT FALSE,
6343: fnd_api.to_boolean(g_main_tab(1).field_value), ---p_is_active BOOLEAN DEFAULT FALSE,
6344: fnd_api.to_boolean(g_main_tab(39).field_value), ---p_is_loaded BOOLEAN DEFAULT FALSE,

Line 6341: fnd_api.to_boolean(g_main_tab(59).field_value), ---p_is_queued BOOLEAN DEFAULT FALSE,

6337: g_main_tab(16).field_value, ---p_from_creation_date DATE DEFAULT NULL,
6338: g_main_tab(68).field_value, ---p_to_creation_date DATE DEFAULT NULL,
6339: fnd_api.to_boolean(g_main_tab(90).field_value), ---p_is_unreleased BOOLEAN DEFAULT FALSE,
6340: fnd_api.to_boolean(g_main_tab(51).field_value), ---p_is_pending BOOLEAN DEFAULT FALSE,
6341: fnd_api.to_boolean(g_main_tab(59).field_value), ---p_is_queued BOOLEAN DEFAULT FALSE,
6342: fnd_api.to_boolean(g_main_tab(12).field_value), ---p_is_dispatched BOOLEAN DEFAULT FALSE,
6343: fnd_api.to_boolean(g_main_tab(1).field_value), ---p_is_active BOOLEAN DEFAULT FALSE,
6344: fnd_api.to_boolean(g_main_tab(39).field_value), ---p_is_loaded BOOLEAN DEFAULT FALSE,
6345: fnd_api.to_boolean(g_main_tab(5).field_value), ---p_is_completed BOOLEAN DEFAULT FALSE,

Line 6342: fnd_api.to_boolean(g_main_tab(12).field_value), ---p_is_dispatched BOOLEAN DEFAULT FALSE,

6338: g_main_tab(68).field_value, ---p_to_creation_date DATE DEFAULT NULL,
6339: fnd_api.to_boolean(g_main_tab(90).field_value), ---p_is_unreleased BOOLEAN DEFAULT FALSE,
6340: fnd_api.to_boolean(g_main_tab(51).field_value), ---p_is_pending BOOLEAN DEFAULT FALSE,
6341: fnd_api.to_boolean(g_main_tab(59).field_value), ---p_is_queued BOOLEAN DEFAULT FALSE,
6342: fnd_api.to_boolean(g_main_tab(12).field_value), ---p_is_dispatched BOOLEAN DEFAULT FALSE,
6343: fnd_api.to_boolean(g_main_tab(1).field_value), ---p_is_active BOOLEAN DEFAULT FALSE,
6344: fnd_api.to_boolean(g_main_tab(39).field_value), ---p_is_loaded BOOLEAN DEFAULT FALSE,
6345: fnd_api.to_boolean(g_main_tab(5).field_value), ---p_is_completed BOOLEAN DEFAULT FALSE,
6346: fnd_api.to_boolean(g_main_tab(35).field_value), ---p_include_inbound BOOLEAN DEFAULT FALSE,

Line 6343: fnd_api.to_boolean(g_main_tab(1).field_value), ---p_is_active BOOLEAN DEFAULT FALSE,

6339: fnd_api.to_boolean(g_main_tab(90).field_value), ---p_is_unreleased BOOLEAN DEFAULT FALSE,
6340: fnd_api.to_boolean(g_main_tab(51).field_value), ---p_is_pending BOOLEAN DEFAULT FALSE,
6341: fnd_api.to_boolean(g_main_tab(59).field_value), ---p_is_queued BOOLEAN DEFAULT FALSE,
6342: fnd_api.to_boolean(g_main_tab(12).field_value), ---p_is_dispatched BOOLEAN DEFAULT FALSE,
6343: fnd_api.to_boolean(g_main_tab(1).field_value), ---p_is_active BOOLEAN DEFAULT FALSE,
6344: fnd_api.to_boolean(g_main_tab(39).field_value), ---p_is_loaded BOOLEAN DEFAULT FALSE,
6345: fnd_api.to_boolean(g_main_tab(5).field_value), ---p_is_completed BOOLEAN DEFAULT FALSE,
6346: fnd_api.to_boolean(g_main_tab(35).field_value), ---p_include_inbound BOOLEAN DEFAULT FALSE,
6347: fnd_api.to_boolean(g_main_tab(50).field_value), ---p_include_outbound BOOLEAN DEFAULT FALSE,

Line 6344: fnd_api.to_boolean(g_main_tab(39).field_value), ---p_is_loaded BOOLEAN DEFAULT FALSE,

6340: fnd_api.to_boolean(g_main_tab(51).field_value), ---p_is_pending BOOLEAN DEFAULT FALSE,
6341: fnd_api.to_boolean(g_main_tab(59).field_value), ---p_is_queued BOOLEAN DEFAULT FALSE,
6342: fnd_api.to_boolean(g_main_tab(12).field_value), ---p_is_dispatched BOOLEAN DEFAULT FALSE,
6343: fnd_api.to_boolean(g_main_tab(1).field_value), ---p_is_active BOOLEAN DEFAULT FALSE,
6344: fnd_api.to_boolean(g_main_tab(39).field_value), ---p_is_loaded BOOLEAN DEFAULT FALSE,
6345: fnd_api.to_boolean(g_main_tab(5).field_value), ---p_is_completed BOOLEAN DEFAULT FALSE,
6346: fnd_api.to_boolean(g_main_tab(35).field_value), ---p_include_inbound BOOLEAN DEFAULT FALSE,
6347: fnd_api.to_boolean(g_main_tab(50).field_value), ---p_include_outbound BOOLEAN DEFAULT FALSE,
6348: fnd_api.to_boolean(g_main_tab(93).field_value), ---p_include_crossdock

Line 6345: fnd_api.to_boolean(g_main_tab(5).field_value), ---p_is_completed BOOLEAN DEFAULT FALSE,

6341: fnd_api.to_boolean(g_main_tab(59).field_value), ---p_is_queued BOOLEAN DEFAULT FALSE,
6342: fnd_api.to_boolean(g_main_tab(12).field_value), ---p_is_dispatched BOOLEAN DEFAULT FALSE,
6343: fnd_api.to_boolean(g_main_tab(1).field_value), ---p_is_active BOOLEAN DEFAULT FALSE,
6344: fnd_api.to_boolean(g_main_tab(39).field_value), ---p_is_loaded BOOLEAN DEFAULT FALSE,
6345: fnd_api.to_boolean(g_main_tab(5).field_value), ---p_is_completed BOOLEAN DEFAULT FALSE,
6346: fnd_api.to_boolean(g_main_tab(35).field_value), ---p_include_inbound BOOLEAN DEFAULT FALSE,
6347: fnd_api.to_boolean(g_main_tab(50).field_value), ---p_include_outbound BOOLEAN DEFAULT FALSE,
6348: fnd_api.to_boolean(g_main_tab(93).field_value), ---p_include_crossdock
6349: fnd_api.to_boolean(g_main_tab(42).field_value), ---p_include_manufacturing BOOLEAN DEFAULT FALSE,

Line 6346: fnd_api.to_boolean(g_main_tab(35).field_value), ---p_include_inbound BOOLEAN DEFAULT FALSE,

6342: fnd_api.to_boolean(g_main_tab(12).field_value), ---p_is_dispatched BOOLEAN DEFAULT FALSE,
6343: fnd_api.to_boolean(g_main_tab(1).field_value), ---p_is_active BOOLEAN DEFAULT FALSE,
6344: fnd_api.to_boolean(g_main_tab(39).field_value), ---p_is_loaded BOOLEAN DEFAULT FALSE,
6345: fnd_api.to_boolean(g_main_tab(5).field_value), ---p_is_completed BOOLEAN DEFAULT FALSE,
6346: fnd_api.to_boolean(g_main_tab(35).field_value), ---p_include_inbound BOOLEAN DEFAULT FALSE,
6347: fnd_api.to_boolean(g_main_tab(50).field_value), ---p_include_outbound BOOLEAN DEFAULT FALSE,
6348: fnd_api.to_boolean(g_main_tab(93).field_value), ---p_include_crossdock
6349: fnd_api.to_boolean(g_main_tab(42).field_value), ---p_include_manufacturing BOOLEAN DEFAULT FALSE,
6350: fnd_api.to_boolean(g_main_tab(92).field_value), ---p_include_warehousing BOOLEAN DEFAULT FALSE,

Line 6347: fnd_api.to_boolean(g_main_tab(50).field_value), ---p_include_outbound BOOLEAN DEFAULT FALSE,

6343: fnd_api.to_boolean(g_main_tab(1).field_value), ---p_is_active BOOLEAN DEFAULT FALSE,
6344: fnd_api.to_boolean(g_main_tab(39).field_value), ---p_is_loaded BOOLEAN DEFAULT FALSE,
6345: fnd_api.to_boolean(g_main_tab(5).field_value), ---p_is_completed BOOLEAN DEFAULT FALSE,
6346: fnd_api.to_boolean(g_main_tab(35).field_value), ---p_include_inbound BOOLEAN DEFAULT FALSE,
6347: fnd_api.to_boolean(g_main_tab(50).field_value), ---p_include_outbound BOOLEAN DEFAULT FALSE,
6348: fnd_api.to_boolean(g_main_tab(93).field_value), ---p_include_crossdock
6349: fnd_api.to_boolean(g_main_tab(42).field_value), ---p_include_manufacturing BOOLEAN DEFAULT FALSE,
6350: fnd_api.to_boolean(g_main_tab(92).field_value), ---p_include_warehousing BOOLEAN DEFAULT FALSE,
6351: g_main_tab(21).field_value, ---p_from_po_header_id NUMBER DEFAULT NULL,

Line 6348: fnd_api.to_boolean(g_main_tab(93).field_value), ---p_include_crossdock

6344: fnd_api.to_boolean(g_main_tab(39).field_value), ---p_is_loaded BOOLEAN DEFAULT FALSE,
6345: fnd_api.to_boolean(g_main_tab(5).field_value), ---p_is_completed BOOLEAN DEFAULT FALSE,
6346: fnd_api.to_boolean(g_main_tab(35).field_value), ---p_include_inbound BOOLEAN DEFAULT FALSE,
6347: fnd_api.to_boolean(g_main_tab(50).field_value), ---p_include_outbound BOOLEAN DEFAULT FALSE,
6348: fnd_api.to_boolean(g_main_tab(93).field_value), ---p_include_crossdock
6349: fnd_api.to_boolean(g_main_tab(42).field_value), ---p_include_manufacturing BOOLEAN DEFAULT FALSE,
6350: fnd_api.to_boolean(g_main_tab(92).field_value), ---p_include_warehousing BOOLEAN DEFAULT FALSE,
6351: g_main_tab(21).field_value, ---p_from_po_header_id NUMBER DEFAULT NULL,
6352: g_main_tab(74).field_value, ---p_to_po_header_id NUMBER DEFAULT NULL,

Line 6349: fnd_api.to_boolean(g_main_tab(42).field_value), ---p_include_manufacturing BOOLEAN DEFAULT FALSE,

6345: fnd_api.to_boolean(g_main_tab(5).field_value), ---p_is_completed BOOLEAN DEFAULT FALSE,
6346: fnd_api.to_boolean(g_main_tab(35).field_value), ---p_include_inbound BOOLEAN DEFAULT FALSE,
6347: fnd_api.to_boolean(g_main_tab(50).field_value), ---p_include_outbound BOOLEAN DEFAULT FALSE,
6348: fnd_api.to_boolean(g_main_tab(93).field_value), ---p_include_crossdock
6349: fnd_api.to_boolean(g_main_tab(42).field_value), ---p_include_manufacturing BOOLEAN DEFAULT FALSE,
6350: fnd_api.to_boolean(g_main_tab(92).field_value), ---p_include_warehousing BOOLEAN DEFAULT FALSE,
6351: g_main_tab(21).field_value, ---p_from_po_header_id NUMBER DEFAULT NULL,
6352: g_main_tab(74).field_value, ---p_to_po_header_id NUMBER DEFAULT NULL,
6353: g_main_tab(22).field_value, ---p_from_purchase_order VARCHAR2 DEFAULT NULL,

Line 6350: fnd_api.to_boolean(g_main_tab(92).field_value), ---p_include_warehousing BOOLEAN DEFAULT FALSE,

6346: fnd_api.to_boolean(g_main_tab(35).field_value), ---p_include_inbound BOOLEAN DEFAULT FALSE,
6347: fnd_api.to_boolean(g_main_tab(50).field_value), ---p_include_outbound BOOLEAN DEFAULT FALSE,
6348: fnd_api.to_boolean(g_main_tab(93).field_value), ---p_include_crossdock
6349: fnd_api.to_boolean(g_main_tab(42).field_value), ---p_include_manufacturing BOOLEAN DEFAULT FALSE,
6350: fnd_api.to_boolean(g_main_tab(92).field_value), ---p_include_warehousing BOOLEAN DEFAULT FALSE,
6351: g_main_tab(21).field_value, ---p_from_po_header_id NUMBER DEFAULT NULL,
6352: g_main_tab(74).field_value, ---p_to_po_header_id NUMBER DEFAULT NULL,
6353: g_main_tab(22).field_value, ---p_from_purchase_order VARCHAR2 DEFAULT NULL,
6354: g_main_tab(75).field_value, ---p_to_purchase_order VARCHAR2 DEFAULT NULL,

Line 6394: fnd_api.to_boolean(g_main_tab(60).field_value), ---p_include_replenishment BOOLEAN DEFAULT TRUE,

6390: g_main_tab(84).field_value, ---p_to_start_date DATE DEFAULT NULL,
6391: g_main_tab(18).field_value, ---p_from_line VARCHAR2 DEFAULT NULL,
6392: g_main_tab(70).field_value, ---p_to_line VARCHAR2 DEFAULT NULL,
6393: g_main_tab(11).field_value, ---p_department_id NUMBER DEFAULT NULL,
6394: fnd_api.to_boolean(g_main_tab(60).field_value), ---p_include_replenishment BOOLEAN DEFAULT TRUE,
6395: g_main_tab(23).field_value, ---p_from_replenishment_mo VARCHAR2 DEFAULT NULL,
6396: g_main_tab(76).field_value, ---p_to_replenishment_mo VARCHAR2 DEFAULT NULL,
6397: fnd_api.to_boolean(g_main_tab(45).field_value), ---p_include_mo_transfer BOOLEAN DEFAULT TRUE,
6398: fnd_api.to_boolean(g_main_tab(44).field_value), ---p_include_mo_issue BOOLEAN DEFAULT TRUE,

Line 6397: fnd_api.to_boolean(g_main_tab(45).field_value), ---p_include_mo_transfer BOOLEAN DEFAULT TRUE,

6393: g_main_tab(11).field_value, ---p_department_id NUMBER DEFAULT NULL,
6394: fnd_api.to_boolean(g_main_tab(60).field_value), ---p_include_replenishment BOOLEAN DEFAULT TRUE,
6395: g_main_tab(23).field_value, ---p_from_replenishment_mo VARCHAR2 DEFAULT NULL,
6396: g_main_tab(76).field_value, ---p_to_replenishment_mo VARCHAR2 DEFAULT NULL,
6397: fnd_api.to_boolean(g_main_tab(45).field_value), ---p_include_mo_transfer BOOLEAN DEFAULT TRUE,
6398: fnd_api.to_boolean(g_main_tab(44).field_value), ---p_include_mo_issue BOOLEAN DEFAULT TRUE,
6399: g_main_tab(34).field_value, ---p_from_transfer_issue_mo VARCHAR2 DEFAULT NULL,
6400: g_main_tab(88).field_value, ---p_to_transfer_issue_mo VARCHAR2 DEFAULT NULL,
6401: fnd_api.to_boolean(g_main_tab(41).field_value), ---p_include_lpn_putaway BOOLEAN DEFAULT TRUE,

Line 6398: fnd_api.to_boolean(g_main_tab(44).field_value), ---p_include_mo_issue BOOLEAN DEFAULT TRUE,

6394: fnd_api.to_boolean(g_main_tab(60).field_value), ---p_include_replenishment BOOLEAN DEFAULT TRUE,
6395: g_main_tab(23).field_value, ---p_from_replenishment_mo VARCHAR2 DEFAULT NULL,
6396: g_main_tab(76).field_value, ---p_to_replenishment_mo VARCHAR2 DEFAULT NULL,
6397: fnd_api.to_boolean(g_main_tab(45).field_value), ---p_include_mo_transfer BOOLEAN DEFAULT TRUE,
6398: fnd_api.to_boolean(g_main_tab(44).field_value), ---p_include_mo_issue BOOLEAN DEFAULT TRUE,
6399: g_main_tab(34).field_value, ---p_from_transfer_issue_mo VARCHAR2 DEFAULT NULL,
6400: g_main_tab(88).field_value, ---p_to_transfer_issue_mo VARCHAR2 DEFAULT NULL,
6401: fnd_api.to_boolean(g_main_tab(41).field_value), ---p_include_lpn_putaway BOOLEAN DEFAULT TRUE,
6402: fnd_api.to_boolean(g_main_tab(66).field_value), ---p_include_staging_move BOOLEAN DEFAULT FALSE,

Line 6401: fnd_api.to_boolean(g_main_tab(41).field_value), ---p_include_lpn_putaway BOOLEAN DEFAULT TRUE,

6397: fnd_api.to_boolean(g_main_tab(45).field_value), ---p_include_mo_transfer BOOLEAN DEFAULT TRUE,
6398: fnd_api.to_boolean(g_main_tab(44).field_value), ---p_include_mo_issue BOOLEAN DEFAULT TRUE,
6399: g_main_tab(34).field_value, ---p_from_transfer_issue_mo VARCHAR2 DEFAULT NULL,
6400: g_main_tab(88).field_value, ---p_to_transfer_issue_mo VARCHAR2 DEFAULT NULL,
6401: fnd_api.to_boolean(g_main_tab(41).field_value), ---p_include_lpn_putaway BOOLEAN DEFAULT TRUE,
6402: fnd_api.to_boolean(g_main_tab(66).field_value), ---p_include_staging_move BOOLEAN DEFAULT FALSE,
6403: fnd_api.to_boolean(g_main_tab(9).field_value), ---p_include_cycle_count BOOLEAN DEFAULT TRUE,
6404: g_main_tab(8).field_value, ---p_cycle_count_name VARCHAR2 DEFAULT NULL,
6405: l_record_count, ---OUT NOCOPY NUMBER,

Line 6402: fnd_api.to_boolean(g_main_tab(66).field_value), ---p_include_staging_move BOOLEAN DEFAULT FALSE,

6398: fnd_api.to_boolean(g_main_tab(44).field_value), ---p_include_mo_issue BOOLEAN DEFAULT TRUE,
6399: g_main_tab(34).field_value, ---p_from_transfer_issue_mo VARCHAR2 DEFAULT NULL,
6400: g_main_tab(88).field_value, ---p_to_transfer_issue_mo VARCHAR2 DEFAULT NULL,
6401: fnd_api.to_boolean(g_main_tab(41).field_value), ---p_include_lpn_putaway BOOLEAN DEFAULT TRUE,
6402: fnd_api.to_boolean(g_main_tab(66).field_value), ---p_include_staging_move BOOLEAN DEFAULT FALSE,
6403: fnd_api.to_boolean(g_main_tab(9).field_value), ---p_include_cycle_count BOOLEAN DEFAULT TRUE,
6404: g_main_tab(8).field_value, ---p_cycle_count_name VARCHAR2 DEFAULT NULL,
6405: l_record_count, ---OUT NOCOPY NUMBER,
6406: x_return_status, ---OUT NOCOPY VARCHAR2,

Line 6403: fnd_api.to_boolean(g_main_tab(9).field_value), ---p_include_cycle_count BOOLEAN DEFAULT TRUE,

6399: g_main_tab(34).field_value, ---p_from_transfer_issue_mo VARCHAR2 DEFAULT NULL,
6400: g_main_tab(88).field_value, ---p_to_transfer_issue_mo VARCHAR2 DEFAULT NULL,
6401: fnd_api.to_boolean(g_main_tab(41).field_value), ---p_include_lpn_putaway BOOLEAN DEFAULT TRUE,
6402: fnd_api.to_boolean(g_main_tab(66).field_value), ---p_include_staging_move BOOLEAN DEFAULT FALSE,
6403: fnd_api.to_boolean(g_main_tab(9).field_value), ---p_include_cycle_count BOOLEAN DEFAULT TRUE,
6404: g_main_tab(8).field_value, ---p_cycle_count_name VARCHAR2 DEFAULT NULL,
6405: l_record_count, ---OUT NOCOPY NUMBER,
6406: x_return_status, ---OUT NOCOPY VARCHAR2,
6407: x_msg_data, ---OUT NOCOPY VARCHAR2,

Line 6409: fnd_api.to_boolean(g_main_tab(36).field_value), ---p_query_independent_tasks BOOLEAN DEFAULT TRUE,

6405: l_record_count, ---OUT NOCOPY NUMBER,
6406: x_return_status, ---OUT NOCOPY VARCHAR2,
6407: x_msg_data, ---OUT NOCOPY VARCHAR2,
6408: x_msg_count, ---OUT NOCOPY NUMBER,
6409: fnd_api.to_boolean(g_main_tab(36).field_value), ---p_query_independent_tasks BOOLEAN DEFAULT TRUE,
6410: fnd_api.to_boolean(g_main_tab(58).field_value), ---p_query_planned_tasks BOOLEAN DEFAULT TRUE,
6411: fnd_api.to_boolean(g_main_tab(57).field_value), ---p_is_pending_plan BOOLEAN DEFAULT FALSE,
6412: fnd_api.to_boolean(g_main_tab(56).field_value), ---p_is_inprogress_plan BOOLEAN DEFAULT FALSE,
6413: fnd_api.to_boolean(g_main_tab(55).field_value), ---p_is_completed_plan BOOLEAN DEFAULT FALSE,

Line 6410: fnd_api.to_boolean(g_main_tab(58).field_value), ---p_query_planned_tasks BOOLEAN DEFAULT TRUE,

6406: x_return_status, ---OUT NOCOPY VARCHAR2,
6407: x_msg_data, ---OUT NOCOPY VARCHAR2,
6408: x_msg_count, ---OUT NOCOPY NUMBER,
6409: fnd_api.to_boolean(g_main_tab(36).field_value), ---p_query_independent_tasks BOOLEAN DEFAULT TRUE,
6410: fnd_api.to_boolean(g_main_tab(58).field_value), ---p_query_planned_tasks BOOLEAN DEFAULT TRUE,
6411: fnd_api.to_boolean(g_main_tab(57).field_value), ---p_is_pending_plan BOOLEAN DEFAULT FALSE,
6412: fnd_api.to_boolean(g_main_tab(56).field_value), ---p_is_inprogress_plan BOOLEAN DEFAULT FALSE,
6413: fnd_api.to_boolean(g_main_tab(55).field_value), ---p_is_completed_plan BOOLEAN DEFAULT FALSE,
6414: fnd_api.to_boolean(g_main_tab(54).field_value), ---p_is_cancelled_plan BOOLEAN DEFAULT FALSE,

Line 6411: fnd_api.to_boolean(g_main_tab(57).field_value), ---p_is_pending_plan BOOLEAN DEFAULT FALSE,

6407: x_msg_data, ---OUT NOCOPY VARCHAR2,
6408: x_msg_count, ---OUT NOCOPY NUMBER,
6409: fnd_api.to_boolean(g_main_tab(36).field_value), ---p_query_independent_tasks BOOLEAN DEFAULT TRUE,
6410: fnd_api.to_boolean(g_main_tab(58).field_value), ---p_query_planned_tasks BOOLEAN DEFAULT TRUE,
6411: fnd_api.to_boolean(g_main_tab(57).field_value), ---p_is_pending_plan BOOLEAN DEFAULT FALSE,
6412: fnd_api.to_boolean(g_main_tab(56).field_value), ---p_is_inprogress_plan BOOLEAN DEFAULT FALSE,
6413: fnd_api.to_boolean(g_main_tab(55).field_value), ---p_is_completed_plan BOOLEAN DEFAULT FALSE,
6414: fnd_api.to_boolean(g_main_tab(54).field_value), ---p_is_cancelled_plan BOOLEAN DEFAULT FALSE,
6415: fnd_api.to_boolean(g_main_tab(53).field_value), ---p_is_aborted_plan BOOLEAN DEFAULT FALSE,

Line 6412: fnd_api.to_boolean(g_main_tab(56).field_value), ---p_is_inprogress_plan BOOLEAN DEFAULT FALSE,

6408: x_msg_count, ---OUT NOCOPY NUMBER,
6409: fnd_api.to_boolean(g_main_tab(36).field_value), ---p_query_independent_tasks BOOLEAN DEFAULT TRUE,
6410: fnd_api.to_boolean(g_main_tab(58).field_value), ---p_query_planned_tasks BOOLEAN DEFAULT TRUE,
6411: fnd_api.to_boolean(g_main_tab(57).field_value), ---p_is_pending_plan BOOLEAN DEFAULT FALSE,
6412: fnd_api.to_boolean(g_main_tab(56).field_value), ---p_is_inprogress_plan BOOLEAN DEFAULT FALSE,
6413: fnd_api.to_boolean(g_main_tab(55).field_value), ---p_is_completed_plan BOOLEAN DEFAULT FALSE,
6414: fnd_api.to_boolean(g_main_tab(54).field_value), ---p_is_cancelled_plan BOOLEAN DEFAULT FALSE,
6415: fnd_api.to_boolean(g_main_tab(53).field_value), ---p_is_aborted_plan BOOLEAN DEFAULT FALSE,
6416: g_main_tab(46).field_value, ---p_activity_id NUMBER DEFAULT NULL,

Line 6413: fnd_api.to_boolean(g_main_tab(55).field_value), ---p_is_completed_plan BOOLEAN DEFAULT FALSE,

6409: fnd_api.to_boolean(g_main_tab(36).field_value), ---p_query_independent_tasks BOOLEAN DEFAULT TRUE,
6410: fnd_api.to_boolean(g_main_tab(58).field_value), ---p_query_planned_tasks BOOLEAN DEFAULT TRUE,
6411: fnd_api.to_boolean(g_main_tab(57).field_value), ---p_is_pending_plan BOOLEAN DEFAULT FALSE,
6412: fnd_api.to_boolean(g_main_tab(56).field_value), ---p_is_inprogress_plan BOOLEAN DEFAULT FALSE,
6413: fnd_api.to_boolean(g_main_tab(55).field_value), ---p_is_completed_plan BOOLEAN DEFAULT FALSE,
6414: fnd_api.to_boolean(g_main_tab(54).field_value), ---p_is_cancelled_plan BOOLEAN DEFAULT FALSE,
6415: fnd_api.to_boolean(g_main_tab(53).field_value), ---p_is_aborted_plan BOOLEAN DEFAULT FALSE,
6416: g_main_tab(46).field_value, ---p_activity_id NUMBER DEFAULT NULL,
6417: g_main_tab(48).field_value, ---p_plan_type_id NUMBER DEFAULT NULL,

Line 6414: fnd_api.to_boolean(g_main_tab(54).field_value), ---p_is_cancelled_plan BOOLEAN DEFAULT FALSE,

6410: fnd_api.to_boolean(g_main_tab(58).field_value), ---p_query_planned_tasks BOOLEAN DEFAULT TRUE,
6411: fnd_api.to_boolean(g_main_tab(57).field_value), ---p_is_pending_plan BOOLEAN DEFAULT FALSE,
6412: fnd_api.to_boolean(g_main_tab(56).field_value), ---p_is_inprogress_plan BOOLEAN DEFAULT FALSE,
6413: fnd_api.to_boolean(g_main_tab(55).field_value), ---p_is_completed_plan BOOLEAN DEFAULT FALSE,
6414: fnd_api.to_boolean(g_main_tab(54).field_value), ---p_is_cancelled_plan BOOLEAN DEFAULT FALSE,
6415: fnd_api.to_boolean(g_main_tab(53).field_value), ---p_is_aborted_plan BOOLEAN DEFAULT FALSE,
6416: g_main_tab(46).field_value, ---p_activity_id NUMBER DEFAULT NULL,
6417: g_main_tab(48).field_value, ---p_plan_type_id NUMBER DEFAULT NULL,
6418: g_main_tab(47).field_value ---p_op_plan_id NUMBER DEFAULT NULL

Line 6415: fnd_api.to_boolean(g_main_tab(53).field_value), ---p_is_aborted_plan BOOLEAN DEFAULT FALSE,

6411: fnd_api.to_boolean(g_main_tab(57).field_value), ---p_is_pending_plan BOOLEAN DEFAULT FALSE,
6412: fnd_api.to_boolean(g_main_tab(56).field_value), ---p_is_inprogress_plan BOOLEAN DEFAULT FALSE,
6413: fnd_api.to_boolean(g_main_tab(55).field_value), ---p_is_completed_plan BOOLEAN DEFAULT FALSE,
6414: fnd_api.to_boolean(g_main_tab(54).field_value), ---p_is_cancelled_plan BOOLEAN DEFAULT FALSE,
6415: fnd_api.to_boolean(g_main_tab(53).field_value), ---p_is_aborted_plan BOOLEAN DEFAULT FALSE,
6416: g_main_tab(46).field_value, ---p_activity_id NUMBER DEFAULT NULL,
6417: g_main_tab(48).field_value, ---p_plan_type_id NUMBER DEFAULT NULL,
6418: g_main_tab(47).field_value ---p_op_plan_id NUMBER DEFAULT NULL
6419: );

Line 6426: IF(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

6422: l_err_msg := 'Status returned by API wms_waveplan_tasks_pvt.query_tasks: '||x_return_status;
6423: inv_trx_util_pub.trace(l_api_name||': '||l_err_msg);
6424: END IF;
6425:
6426: IF(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
6427: /* SELECT * BULK COLLECT
6428: INTO x_task_tab
6429: FROM wms_waveplan_tasks_temp;*/
6430: --Replacing the above by selecting columns from the table.

Line 6558: x_return_status := fnd_api.g_ret_sts_unexp_error;

6554:
6555: END IF; --- if l_execute_qry then
6556:
6557: ELSE
6558: x_return_status := fnd_api.g_ret_sts_unexp_error;
6559: fnd_message.set_name('WMS', 'WMS_INVALID_VALUE');
6560: fnd_msg_pub.ADD;
6561: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
6562: inv_trx_util_pub.trace(l_api_name||': '||'Invalid Parameters Passed');

Line 6561: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);

6557: ELSE
6558: x_return_status := fnd_api.g_ret_sts_unexp_error;
6559: fnd_message.set_name('WMS', 'WMS_INVALID_VALUE');
6560: fnd_msg_pub.ADD;
6561: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
6562: inv_trx_util_pub.trace(l_api_name||': '||'Invalid Parameters Passed');
6563: END IF; ----if p_transaction_number is not null
6564:
6565: EXCEPTION

Line 6567: x_return_status := fnd_api.g_ret_sts_unexp_error;

6563: END IF; ----if p_transaction_number is not null
6564:
6565: EXCEPTION
6566: WHEN l_invalid_org THEN
6567: x_return_status := fnd_api.g_ret_sts_unexp_error;
6568: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
6569: IF(l_debug = 1) THEN
6570: inv_trx_util_pub.trace(l_api_name||': '||l_err_msg);
6571: END IF;

Line 6568: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);

6564:
6565: EXCEPTION
6566: WHEN l_invalid_org THEN
6567: x_return_status := fnd_api.g_ret_sts_unexp_error;
6568: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
6569: IF(l_debug = 1) THEN
6570: inv_trx_util_pub.trace(l_api_name||': '||l_err_msg);
6571: END IF;
6572: NULL;

Line 6575: x_return_status := fnd_api.g_ret_sts_unexp_error;

6571: END IF;
6572: NULL;
6573:
6574: WHEN l_qry_fail THEN
6575: x_return_status := fnd_api.g_ret_sts_unexp_error;
6576: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
6577: IF(l_debug = 1) THEN
6578: inv_trx_util_pub.trace(l_api_name||': '||l_err_msg);
6579: END IF;

Line 6576: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);

6572: NULL;
6573:
6574: WHEN l_qry_fail THEN
6575: x_return_status := fnd_api.g_ret_sts_unexp_error;
6576: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
6577: IF(l_debug = 1) THEN
6578: inv_trx_util_pub.trace(l_api_name||': '||l_err_msg);
6579: END IF;
6580: NULL;

Line 6583: x_return_status := fnd_api.g_ret_sts_unexp_error;

6579: END IF;
6580: NULL;
6581:
6582: WHEN OTHERS THEN
6583: x_return_status := fnd_api.g_ret_sts_unexp_error;
6584: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
6585: l_err_msg := substr(SQLERRM,1,1000);
6586: IF(l_debug = 1) THEN
6587: inv_trx_util_pub.trace(l_api_name||': '||l_err_msg);

Line 6584: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);

6580: NULL;
6581:
6582: WHEN OTHERS THEN
6583: x_return_status := fnd_api.g_ret_sts_unexp_error;
6584: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
6585: l_err_msg := substr(SQLERRM,1,1000);
6586: IF(l_debug = 1) THEN
6587: inv_trx_util_pub.trace(l_api_name||': '||l_err_msg);
6588: END IF;

Line 6620: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE ,

6616: */
6617: -------------------------------------------------------------------------------------------------------------------
6618: PROCEDURE split_task( p_source_transaction_number IN NUMBER DEFAULT NULL ,
6619: p_split_quantities IN task_qty_tbl_type ,
6620: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE ,
6621: x_resultant_tasks OUT NOCOPY WMS_TASK_MGMT_PUB.task_tab_type ,
6622: x_resultant_task_details OUT NOCOPY task_detail_tbl_type ,
6623: x_return_status OUT NOCOPY VARCHAR2 ,
6624: x_msg_count OUT NOCOPY NUMBER ,

Line 7012: IF p_commit = FND_API.G_TRUE THEN

7008: ELSE
7009: print_msg(l_procedure_name, 'Table x_resultant_tasks is empty');
7010: END IF;
7011: END IF;
7012: IF p_commit = FND_API.G_TRUE THEN
7013: IF g_debug = 1 THEN
7014: print_msg(l_procedure_name, ' p_commit is TRUE, so COMMITING the transactions.');
7015: END IF;
7016: COMMIT;

Line 7037: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);

7033: l_msg_count ,
7034: l_msg_data );
7035: fnd_message.set_name('WMS', 'WMS_INVALID_TASK');
7036: fnd_msg_pub.ADD;
7037: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
7038:
7039: IF l_new_tasks_tbl.COUNT > 0 THEN
7040: x_resultant_tasks(1) := l_new_tasks_tbl(1);
7041: x_resultant_tasks(1).RESULT := 'E';

Line 7061: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);

7057: l_msg_count ,
7058: l_msg_data );
7059: fnd_message.set_name('INV', 'INV_LOT_INDIVISIBLE');
7060: fnd_msg_pub.ADD;
7061: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
7062:
7063: IF l_new_tasks_tbl.COUNT > 0 THEN
7064: x_resultant_tasks(1) := l_new_tasks_tbl(1);
7065: x_resultant_tasks(1).RESULT := 'E';

Line 7082: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);

7078: l_msg_count ,
7079: l_msg_data );
7080: fnd_message.set_name('WMS', 'WMS_INVALID_SPLIT_QUANTITY');
7081: fnd_msg_pub.ADD;
7082: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
7083:
7084: IF l_new_tasks_tbl.COUNT > 0 THEN
7085: x_resultant_tasks(1) := l_new_tasks_tbl(1);
7086: x_resultant_tasks(1).RESULT := 'E';

Line 7106: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);

7102: l_msg_count ,
7103: l_msg_data );
7104: fnd_message.set_name('WMS', 'WMS_QUERY_ELIG_MATRL');
7105: fnd_msg_pub.ADD;
7106: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
7107:
7108: IF l_new_tasks_tbl.COUNT > 0 THEN
7109: x_resultant_tasks(1) := l_new_tasks_tbl(1);
7110: x_resultant_tasks(1).RESULT := 'E';

Line 7124: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);

7120: x_return_status := 'E';
7121: ROLLBACK TO wms_split_task;
7122: fnd_message.set_name('WMS', 'WMS_UNEXPECTED_ERROR');
7123: fnd_msg_pub.ADD;
7124: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
7125: WHEN OTHERS THEN
7126: IF g_debug = 1 THEN
7127: print_msg(l_procedure_name,'EXCEPTION BLOCK : Unexpected error has occured, ROLLING BACK THE TRANSACTIONS');
7128: END IF;

Line 7133: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);

7129: x_return_status := 'E';
7130: ROLLBACK TO wms_split_task;
7131: fnd_message.set_name('WMS', 'WMS_UNEXPECTED_ERROR');
7132: fnd_msg_pub.ADD;
7133: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
7134: x_return_status := 'E';
7135: IF g_debug = 1 THEN
7136: print_msg(l_procedure_name, 'EXCEPTION BLOCK : Error Code : '|| SQLCODE || 'EXCEPTION BLOCK : Error Message :'||SQLERRM);
7137: END IF;

Line 7189: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE ,

7185: p_new_task_type IN VARCHAR2 DEFAULT NULL ,
7186: p_new_carton_lpn_id IN NUMBER DEFAULT NULL ,
7187: p_new_operation_plan_id IN NUMBER DEFAULT NULL ,
7188: p_person_id IN NUMBER DEFAULT NULL ,
7189: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE ,
7190: x_updated_tasks OUT NOCOPY WMS_TASK_MGMT_PUB.task_tab_type ,
7191: x_return_status OUT NOCOPY VARCHAR2 ,
7192: x_msg_count OUT NOCOPY NUMBER ,
7193: x_msg_data OUT NOCOPY VARCHAR2 ) IS

Line 7298: x_return_status := fnd_api.g_ret_sts_success;

7294: l_action VARCHAR2(20) := 'MODIFY'; -- 6850212
7295:
7296:
7297: BEGIN
7298: x_return_status := fnd_api.g_ret_sts_success;
7299: --anjana
7300: x_msg_count := 0;
7301: --1.Tasks status can be updated only to to Pending or queued or unreleased state.
7302: IF (p_new_task_status IS NOT NULL) THEN

Line 7305: --x_return_status := fnd_api.g_ret_sts_error;

7301: --1.Tasks status can be updated only to to Pending or queued or unreleased state.
7302: IF (p_new_task_status IS NOT NULL) THEN
7303: IF(p_new_task_status NOT IN (1,2,8)) THEN
7304: --6850212:Return status should not be set to error.
7305: --x_return_status := fnd_api.g_ret_sts_error;
7306: fnd_message.set_name('WMS', 'WMS_INVALID_TASK_STATUS');--new message
7307: fnd_msg_pub.ADD;
7308: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_msg );
7309: x_msg_data := l_msg;

Line 7308: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_msg );

7304: --6850212:Return status should not be set to error.
7305: --x_return_status := fnd_api.g_ret_sts_error;
7306: fnd_message.set_name('WMS', 'WMS_INVALID_TASK_STATUS');--new message
7307: fnd_msg_pub.ADD;
7308: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_msg );
7309: x_msg_data := l_msg;
7310: x_msg_count := l_msg_count;
7311: l_err_msg :='New task status not in Pending or Queued state or Unreleased state';
7312: IF(l_debug = 1) THEN

Line 7331: --x_return_status := fnd_api.g_ret_sts_error;

7327: l_op_plan_rec.common_to_all_org,
7328: l_op_plan_rec.plan_type_id;
7329: IF (l_op_plan_rec.eabled_flag <> 'Y') THEN--op_plan passed is not enabled
7330: --6850212:Return status should not be set to error.
7331: --x_return_status := fnd_api.g_ret_sts_error;
7332: fnd_message.set_name('WMS', 'WMS_OPERTN_PLAN_ID_INVALID');--new message
7333: fnd_msg_pub.ADD;
7334: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_msg );
7335: x_msg_data := l_msg;

Line 7334: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_msg );

7330: --6850212:Return status should not be set to error.
7331: --x_return_status := fnd_api.g_ret_sts_error;
7332: fnd_message.set_name('WMS', 'WMS_OPERTN_PLAN_ID_INVALID');--new message
7333: fnd_msg_pub.ADD;
7334: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_msg );
7335: x_msg_data := l_msg;
7336: x_msg_count := l_msg_count;
7337: l_err_msg :='Operation Plan is not enabled';
7338: IF(l_debug = 1) THEN

Line 7358: IF (p_return_sts = fnd_api.g_ret_sts_success) THEN

7354: p_action => l_action, --6850212
7355: x_wms_task => l_updated_tasks,
7356: x_return_status => p_return_sts);
7357:
7358: IF (p_return_sts = fnd_api.g_ret_sts_success) THEN
7359: l_valid_task_counter := l_updated_tasks.count;
7360: FOR i IN 1..l_updated_tasks.count
7361: LOOP--Loop starts
7362: IF (nvl(l_updated_tasks(i).RESULT,'X')<> 'E') THEN

Line 7372: IF ((p_return_sts <> fnd_api.g_ret_sts_success) OR ( temp_task_tab.count = 0)) THEN

7368: x_msg_count => p_msg_count,
7369: x_msg_data => p_msg_data);
7370:
7371: --if quey was not successfull then populate output table with passed values with error
7372: IF ((p_return_sts <> fnd_api.g_ret_sts_success) OR ( temp_task_tab.count = 0)) THEN
7373: fnd_message.set_name('WMS', 'WMS_QUERY_ELIG_MATRL');--new message
7374: -- fnd_msg_pub.ADD;
7375: -- fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_msg);
7376: --anjana

Line 7375: -- fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_msg);

7371: --if quey was not successfull then populate output table with passed values with error
7372: IF ((p_return_sts <> fnd_api.g_ret_sts_success) OR ( temp_task_tab.count = 0)) THEN
7373: fnd_message.set_name('WMS', 'WMS_QUERY_ELIG_MATRL');--new message
7374: -- fnd_msg_pub.ADD;
7375: -- fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_msg);
7376: --anjana
7377: l_msg := fnd_message.get;
7378: x_msg_data := x_msg_data || l_msg;
7379: x_msg_count := x_msg_count + 1;

Line 7395: -- fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_msg );

7391: END IF;
7392: ELSE
7393: fnd_message.set_name('WMS', 'WMS_INVALID_TASK');
7394: -- fnd_msg_pub.ADD;
7395: -- fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_msg );
7396: --anjana
7397: l_msg := fnd_message.get;
7398: x_msg_data := x_msg_data || l_msg;
7399: x_msg_count := x_msg_count + 1;

Line 7408: x_return_status := fnd_api.g_ret_sts_unexp_error;

7404: l_valid_task_counter := l_valid_task_counter - 1;
7405: END IF;
7406: END LOOP;--Loop ends
7407: ELSE
7408: x_return_status := fnd_api.g_ret_sts_unexp_error;
7409: fnd_message.set_name('WMS', 'WMS_UNEXPECTED_ERROR');
7410: fnd_msg_pub.ADD;
7411: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_msg );
7412: x_msg_data := l_msg;

Line 7411: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_msg );

7407: ELSE
7408: x_return_status := fnd_api.g_ret_sts_unexp_error;
7409: fnd_message.set_name('WMS', 'WMS_UNEXPECTED_ERROR');
7410: fnd_msg_pub.ADD;
7411: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_msg );
7412: x_msg_data := l_msg;
7413: x_msg_count := l_msg_count;
7414: -- l_err_msg :='Task Validation Failed';
7415: IF(l_debug = 1) THEN

Line 7423: --x_return_status := fnd_api.g_ret_sts_error;

7419: END IF;
7420: IF (l_valid_task_counter <=0 ) THEN
7421: --all the tasks are invalid.Dont proceed
7422: --6850212:Return status should not be set to error.
7423: --x_return_status := fnd_api.g_ret_sts_error;
7424: RETURN;
7425: END IF;
7426: --Cartonization needs to be done only if all the tasks passed are valid and the task is an outboud task(SO/WIP)
7427: IF (p_new_carton_lpn_id IS NOT NULL) THEN

Line 7434: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_msg );

7430: LOOP
7431: IF ((l_updated_tasks(1).task_type_id <> 1) OR (l_updated_tasks(i).task_type_id <> l_updated_tasks(1).task_type_id )) THEN
7432: fnd_message.set_name('WMS', 'WMS_CARTONIZATION_ERROR');--new message
7433: fnd_msg_pub.ADD;
7434: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_msg );
7435: l_err_msg :='Cartonization can be done only on Outbound tasks(Sales order/WIP)';
7436: x_msg_data := l_msg;
7437: x_msg_count := l_msg_count;
7438: log_error(p_transaction_number => p_transaction_number,

Line 7450: IF (p_return_sts <> fnd_api.g_ret_sts_success) THEN

7446: p_new_carton_lpn_id => p_new_carton_lpn_id,
7447: x_error_msg => l_error_msg,
7448: x_return_status => p_return_sts);
7449:
7450: IF (p_return_sts <> fnd_api.g_ret_sts_success) THEN
7451: x_return_status := fnd_api.g_ret_sts_error;
7452: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data );
7453: FOR i IN 1..l_updated_tasks.count
7454: LOOP

Line 7451: x_return_status := fnd_api.g_ret_sts_error;

7447: x_error_msg => l_error_msg,
7448: x_return_status => p_return_sts);
7449:
7450: IF (p_return_sts <> fnd_api.g_ret_sts_success) THEN
7451: x_return_status := fnd_api.g_ret_sts_error;
7452: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data );
7453: FOR i IN 1..l_updated_tasks.count
7454: LOOP
7455: x_updated_tasks(i).RESULT := 'E';

Line 7452: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data );

7448: x_return_status => p_return_sts);
7449:
7450: IF (p_return_sts <> fnd_api.g_ret_sts_success) THEN
7451: x_return_status := fnd_api.g_ret_sts_error;
7452: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data );
7453: FOR i IN 1..l_updated_tasks.count
7454: LOOP
7455: x_updated_tasks(i).RESULT := 'E';
7456: x_updated_tasks(i).ERROR := l_error_msg;

Line 7464: x_return_status := fnd_api.g_ret_sts_error;

7460: END IF;
7461: RETURN;
7462: END IF;
7463: ELSE
7464: x_return_status := fnd_api.g_ret_sts_error;
7465: fnd_message.set_name('WMS', 'WMS_CARTONIZATION_ERROR');--new message
7466: fnd_msg_pub.ADD;
7467: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data );
7468: l_err_msg := 'Some tasks have failed validation,cartonization cannot be done';

Line 7467: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data );

7463: ELSE
7464: x_return_status := fnd_api.g_ret_sts_error;
7465: fnd_message.set_name('WMS', 'WMS_CARTONIZATION_ERROR');--new message
7466: fnd_msg_pub.ADD;
7467: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data );
7468: l_err_msg := 'Some tasks have failed validation,cartonization cannot be done';
7469: IF(l_debug = 1) THEN
7470: inv_trx_util_pub.trace(l_api_name|| ': '||l_err_msg);
7471: END IF;

Line 7661: IF (p_commit = FND_API.G_TRUE) THEN

7657: DELETE from wms_dispatched_tasks
7658: WHERE transaction_temp_id = l_wdt_del_trns_num_table(i);
7659: END IF;
7660:
7661: IF (p_commit = FND_API.G_TRUE) THEN
7662: COMMIT;
7663: END IF;
7664: EXCEPTION
7665: WHEN OTHERS THEN

Line 7666: x_return_status := fnd_api.g_ret_sts_unexp_error;

7662: COMMIT;
7663: END IF;
7664: EXCEPTION
7665: WHEN OTHERS THEN
7666: x_return_status := fnd_api.g_ret_sts_unexp_error;
7667: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
7668: l_err_msg := substr(SQLERRM,1,1000);
7669: IF(l_debug = 1) THEN
7670: inv_trx_util_pub.trace(l_api_name|| ': '||l_err_msg);

Line 7667: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);

7663: END IF;
7664: EXCEPTION
7665: WHEN OTHERS THEN
7666: x_return_status := fnd_api.g_ret_sts_unexp_error;
7667: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
7668: l_err_msg := substr(SQLERRM,1,1000);
7669: IF(l_debug = 1) THEN
7670: inv_trx_util_pub.trace(l_api_name|| ': '||l_err_msg);
7671: END IF;

Line 7705: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

7701: -------------------------------------------------------------------------------------------------------------
7702:
7703: PROCEDURE cancel_task(
7704: p_transaction_number IN NUMBER DEFAULT NULL,
7705: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
7706: p_wms_task IN WMS_TASK_MGMT_PUB.task_tab_type,
7707: x_unprocessed_crossdock_tasks OUT NOCOPY WMS_TASK_MGMT_PUB.task_tab_type,
7708: x_return_status OUT NOCOPY VARCHAR2,
7709: x_msg_count OUT NOCOPY NUMBER,

Line 7724: x_return_status := fnd_api.g_ret_sts_success;

7720: l_msg VARCHAR2(2000);
7721:
7722: BEGIN
7723:
7724: x_return_status := fnd_api.g_ret_sts_success;
7725: --anjana
7726: x_msg_count := 0;
7727: l_transaction_number:= p_transaction_number ;
7728: l_task_table := p_wms_task;

Line 7743: IF (l_val_ret_status = fnd_api.g_ret_sts_success) THEN

7739: IF l_debug = 1 THEN
7740: inv_trx_util_pub.trace('cancel_task l_val_ret_status is : '||l_val_ret_status);
7741: END IF;
7742:
7743: IF (l_val_ret_status = fnd_api.g_ret_sts_success) THEN
7744: IF l_debug = 1 THEN
7745: inv_trx_util_pub.trace('l_ret_task_table.count : '||l_ret_task_table.count);
7746: END IF;
7747:

Line 7752: IF ( nvl(l_ret_task_table(i).RESULT,'X')<> FND_API.G_RET_STS_ERROR)THEN

7748: FOR i in 1..l_ret_task_table.count LOOP
7749: IF l_debug = 1 THEN
7750: inv_trx_util_pub.trace('cancel_task l_ret_task_table(i).RESULT '||l_ret_task_table(i).RESULT);
7751: END IF;
7752: IF ( nvl(l_ret_task_table(i).RESULT,'X')<> FND_API.G_RET_STS_ERROR)THEN
7753: IF l_debug = 1 THEN
7754: inv_trx_util_pub.trace('cancel_task transaction_number '||l_ret_task_table(i).transaction_number);
7755: END IF;
7756: SAVEPOINT SAVEPOINT1;

Line 7765: IF (x_return_status<>FND_API.G_RET_STS_SUCCESS) THEN

7761: IF l_debug = 1 THEN
7762: inv_trx_util_pub.trace('cancel_task CANCEL_TASK: x_return_status: ' || x_return_status);
7763: END IF;
7764:
7765: IF (x_return_status<>FND_API.G_RET_STS_SUCCESS) THEN
7766: FND_MESSAGE.SET_NAME('WMS', 'WMS_CANCEL_FAILED');
7767: l_msg := fnd_message.get;
7768: x_msg_count := x_msg_count + 1;
7769: x_msg_data := x_msg_data || l_msg;

Line 7799: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

7795: ELSE
7796: IF l_debug = 1 THEN
7797: inv_trx_util_pub.trace('CANCEL_TASK: Error occured while validating the transaction_number or table of transaction_number...');
7798: END IF;
7799: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
7800: RETURN;
7801: END IF;
7802:
7803: IF (p_commit= FND_API.G_TRUE ) THEN

Line 7803: IF (p_commit= FND_API.G_TRUE ) THEN

7799: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
7800: RETURN;
7801: END IF;
7802:
7803: IF (p_commit= FND_API.G_TRUE ) THEN
7804: COMMIT;
7805: END IF;
7806: EXCEPTION
7807: WHEN fnd_api.g_exc_error THEN

Line 7807: WHEN fnd_api.g_exc_error THEN

7803: IF (p_commit= FND_API.G_TRUE ) THEN
7804: COMMIT;
7805: END IF;
7806: EXCEPTION
7807: WHEN fnd_api.g_exc_error THEN
7808: IF l_debug = 1 THEN
7809: inv_trx_util_pub.trace('CANCEL_TASK: Expected Error occurred while performing cancel cross dock task:'|| SQLCODE);
7810: END IF;
7811: x_return_status:=FND_API.G_RET_STS_ERROR;

Line 7811: x_return_status:=FND_API.G_RET_STS_ERROR;

7807: WHEN fnd_api.g_exc_error THEN
7808: IF l_debug = 1 THEN
7809: inv_trx_util_pub.trace('CANCEL_TASK: Expected Error occurred while performing cancel cross dock task:'|| SQLCODE);
7810: END IF;
7811: x_return_status:=FND_API.G_RET_STS_ERROR;
7812: ROLLBACK TO SAVEPOINT1;
7813: RETURN;
7814: WHEN OTHERS THEN
7815: IF l_debug = 1 THEN

Line 7818: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

7814: WHEN OTHERS THEN
7815: IF l_debug = 1 THEN
7816: inv_trx_util_pub.trace('CANCEL_TASK: Unknown Error occurred while performing cancel cross dock task:'|| SQLCODE);
7817: END IF;
7818: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
7819: ROLLBACK TO SAVEPOINT1;
7820: RETURN;
7821: END cancel_task;
7822: