eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WMS_TASK_DISPATCH_ENGINE dependencies on FND_API

Line 109: x_return_status := fnd_api.g_ret_sts_success;

105: print_debug(' grouping document number : ' || p_grp_doc_num, 9);
106: print_debug(' grouping source type : ' || p_grp_src_type_id, 9);
107: END IF;
108:
109: x_return_status := fnd_api.g_ret_sts_success;
110:
111: savepoint store_locked_tasks;
112:
113: -- Inserting the data into temp table

Line 138: x_return_status := fnd_api.g_ret_sts_unexp_error;

134: IF (l_debug = 1) THEN
135: print_debug('STORE_LOCKED_TASKS : Exception Occured ' || substrb(SQLERRM,1,200), 1);
136: END IF;
137: rollback to store_locked_tasks;
138: x_return_status := fnd_api.g_ret_sts_unexp_error;
139: --}
140: END store_locked_tasks;
141:
142: PROCEDURE remove_stored_cartons(x_return_status OUT NOCOPY VARCHAR2)

Line 147: x_return_status := fnd_api.g_ret_sts_success;

143: IS
144: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
145: i NUMBER ;
146: BEGIN
147: x_return_status := fnd_api.g_ret_sts_success;
148:
149: savepoint remove_stored_cartons;
150:
151: -- remove the data from temp table

Line 164: x_return_status := fnd_api.g_ret_sts_unexp_error;

160: IF (l_debug = 1) THEN
161: print_debug('REMOVE_STORED_CARTONS : Exception Occured ' || substrb(SQLERRM,1,200), 1);
162: END IF;
163: rollback to remove_stored_cartons;
164: x_return_status := fnd_api.g_ret_sts_unexp_error;
165: END remove_stored_cartons;
166:
167: --Added for Case Picking Project start
168: PROCEDURE remove_stored_order_num(x_return_status OUT NOCOPY VARCHAR2) IS

Line 170: x_return_status := fnd_api.g_ret_sts_success;

166:
167: --Added for Case Picking Project start
168: PROCEDURE remove_stored_order_num(x_return_status OUT NOCOPY VARCHAR2) IS
169: BEGIN
170: x_return_status := fnd_api.g_ret_sts_success;
171: savepoint remove_stored_order_numbers;
172: DELETE FROM WMS_DISPATCH_TASKS_GTMP WHERE
173: GROUPING_DOCUMENT_NUMBER IN (
174: SELECT MMTT.TRANSACTION_SOURCE_ID

Line 183: x_return_status := fnd_api.g_ret_sts_unexp_error;

179: );
180: EXCEPTION
181: WHEN OTHERS THEN
182: rollback to remove_stored_order_numbers;
183: x_return_status := fnd_api.g_ret_sts_unexp_error;
184: END remove_stored_order_num;
185:
186: PROCEDURE remove_stored_pick_slip_num(x_return_status OUT NOCOPY VARCHAR2) IS
187: BEGIN

Line 188: x_return_status := fnd_api.g_ret_sts_success;

184: END remove_stored_order_num;
185:
186: PROCEDURE remove_stored_pick_slip_num(x_return_status OUT NOCOPY VARCHAR2) IS
187: BEGIN
188: x_return_status := fnd_api.g_ret_sts_success;
189: savepoint remove_store_pick_slip_numbers;
190: DELETE FROM WMS_DISPATCH_TASKS_GTMP WHERE
191: GROUPING_DOCUMENT_NUMBER IN
192: (SELECT * FROM TABLE(wms_picking_pkg.list_pick_slip_numbers));

Line 196: x_return_status := fnd_api.g_ret_sts_unexp_error;

192: (SELECT * FROM TABLE(wms_picking_pkg.list_pick_slip_numbers));
193: EXCEPTION
194: WHEN OTHERS THEN
195: rollback to remove_stored_pick_slip_number;
196: x_return_status := fnd_api.g_ret_sts_unexp_error;
197: END remove_stored_pick_slip_num;
198: --Added for Case Picking Project end
199:
200:

Line 205: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

201: -- bug 4358107
202: -- APL procedure: Used since 11.5.10
203: PROCEDURE dispatch_task
204: (p_api_version IN NUMBER,
205: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
206: p_commit IN VARCHAR2 := fnd_api.g_false,
207: p_sign_on_emp_id IN NUMBER,
208: p_sign_on_org_id IN NUMBER,
209: p_sign_on_zone IN VARCHAR2 := NULL,

Line 206: p_commit IN VARCHAR2 := fnd_api.g_false,

202: -- APL procedure: Used since 11.5.10
203: PROCEDURE dispatch_task
204: (p_api_version IN NUMBER,
205: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
206: p_commit IN VARCHAR2 := fnd_api.g_false,
207: p_sign_on_emp_id IN NUMBER,
208: p_sign_on_org_id IN NUMBER,
209: p_sign_on_zone IN VARCHAR2 := NULL,
210: p_sign_on_equipment_id IN NUMBER := NULL, -- specific equip idNULL or -999. -999 stands for none

Line 3381: IF fnd_api.to_boolean(p_init_msg_list) THEN

3377:
3378: -- This API is query only, therefore does not create a save point
3379:
3380: -- Initialize message list if p_init_msg_list is set to TRUE.
3381: IF fnd_api.to_boolean(p_init_msg_list) THEN
3382: fnd_msg_pub.initialize;
3383: END IF;
3384:
3385: -- Initialize API return status to success

Line 3386: x_return_status := fnd_api.g_ret_sts_success;

3382: fnd_msg_pub.initialize;
3383: END IF;
3384:
3385: -- Initialize API return status to success
3386: x_return_status := fnd_api.g_ret_sts_success;
3387:
3388: -- API body
3389: -- preprocess input parameters
3390:

Line 3733: IF l_return_status = fnd_api.g_ret_sts_error THEN

3729: IF l_debug = 1 THEN
3730: print_debug('Return Status after the call to store_locked_tasks ' || l_return_status ||' p_task_method ' || p_task_method, 4);
3731: END IF;
3732:
3733: IF l_return_status = fnd_api.g_ret_sts_error THEN
3734: RAISE fnd_api.g_exc_error;
3735: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3736: RAISE fnd_api.g_exc_unexpected_error;
3737: END IF;

Line 3734: RAISE fnd_api.g_exc_error;

3730: print_debug('Return Status after the call to store_locked_tasks ' || l_return_status ||' p_task_method ' || p_task_method, 4);
3731: END IF;
3732:
3733: IF l_return_status = fnd_api.g_ret_sts_error THEN
3734: RAISE fnd_api.g_exc_error;
3735: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3736: RAISE fnd_api.g_exc_unexpected_error;
3737: END IF;
3738: IF l_locked_lpns = l_total_lpns THEN

Line 3735: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

3731: END IF;
3732:
3733: IF l_return_status = fnd_api.g_ret_sts_error THEN
3734: RAISE fnd_api.g_exc_error;
3735: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3736: RAISE fnd_api.g_exc_unexpected_error;
3737: END IF;
3738: IF l_locked_lpns = l_total_lpns THEN
3739: fnd_message.set_name('WMS', 'WMS_TASK_NO_ELIGIBLE_TASKS');

Line 3736: RAISE fnd_api.g_exc_unexpected_error;

3732:
3733: IF l_return_status = fnd_api.g_ret_sts_error THEN
3734: RAISE fnd_api.g_exc_error;
3735: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3736: RAISE fnd_api.g_exc_unexpected_error;
3737: END IF;
3738: IF l_locked_lpns = l_total_lpns THEN
3739: fnd_message.set_name('WMS', 'WMS_TASK_NO_ELIGIBLE_TASKS');
3740: fnd_msg_pub.ADD;

Line 3745: RAISE fnd_api.g_exc_error;

3741:
3742: IF (l_debug = 1) THEN
3743: print_debug('dispatch_task - No eligible picking tasks ', 4);
3744: END IF;
3745: RAISE fnd_api.g_exc_error;
3746: END IF;
3747: l_return_status := fnd_api.g_ret_sts_success;
3748: END IF;
3749:

Line 3747: l_return_status := fnd_api.g_ret_sts_success;

3743: print_debug('dispatch_task - No eligible picking tasks ', 4);
3744: END IF;
3745: RAISE fnd_api.g_exc_error;
3746: END IF;
3747: l_return_status := fnd_api.g_ret_sts_success;
3748: END IF;
3749:
3750: IF c_carton_lock_check%isopen THEN
3751: CLOSE c_carton_lock_check;

Line 3779: IF l_return_status = fnd_api.g_ret_sts_error THEN

3775: store_locked_tasks(p_grp_doc_type => p_task_method,
3776: p_grp_doc_num =>c_order_numbers_rec.sales_order_id ,
3777: p_grp_src_type_id => NULL,
3778: x_return_status => l_return_status);
3779: IF l_return_status = fnd_api.g_ret_sts_error THEN
3780: RAISE fnd_api.g_exc_error;
3781: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3782: RAISE fnd_api.g_exc_unexpected_error;
3783: END IF;

Line 3780: RAISE fnd_api.g_exc_error;

3776: p_grp_doc_num =>c_order_numbers_rec.sales_order_id ,
3777: p_grp_src_type_id => NULL,
3778: x_return_status => l_return_status);
3779: IF l_return_status = fnd_api.g_ret_sts_error THEN
3780: RAISE fnd_api.g_exc_error;
3781: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3782: RAISE fnd_api.g_exc_unexpected_error;
3783: END IF;
3784: l_return_status := fnd_api.g_ret_sts_success;

Line 3781: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

3777: p_grp_src_type_id => NULL,
3778: x_return_status => l_return_status);
3779: IF l_return_status = fnd_api.g_ret_sts_error THEN
3780: RAISE fnd_api.g_exc_error;
3781: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3782: RAISE fnd_api.g_exc_unexpected_error;
3783: END IF;
3784: l_return_status := fnd_api.g_ret_sts_success;
3785: END IF;

Line 3782: RAISE fnd_api.g_exc_unexpected_error;

3778: x_return_status => l_return_status);
3779: IF l_return_status = fnd_api.g_ret_sts_error THEN
3780: RAISE fnd_api.g_exc_error;
3781: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3782: RAISE fnd_api.g_exc_unexpected_error;
3783: END IF;
3784: l_return_status := fnd_api.g_ret_sts_success;
3785: END IF;
3786: IF c_manifest_order_lock_check%isopen THEN

Line 3784: l_return_status := fnd_api.g_ret_sts_success;

3780: RAISE fnd_api.g_exc_error;
3781: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3782: RAISE fnd_api.g_exc_unexpected_error;
3783: END IF;
3784: l_return_status := fnd_api.g_ret_sts_success;
3785: END IF;
3786: IF c_manifest_order_lock_check%isopen THEN
3787: CLOSE c_manifest_order_lock_check;
3788: END IF;

Line 3813: IF l_return_status = fnd_api.g_ret_sts_error THEN

3809: store_locked_tasks(p_grp_doc_type => p_task_method,
3810: p_grp_doc_num => c_pick_slip_numbers_rec.pick_slip_number,
3811: p_grp_src_type_id => NULL,
3812: x_return_status => l_return_status);
3813: IF l_return_status = fnd_api.g_ret_sts_error THEN
3814: RAISE fnd_api.g_exc_error;
3815: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3816: RAISE fnd_api.g_exc_unexpected_error;
3817: END IF;

Line 3814: RAISE fnd_api.g_exc_error;

3810: p_grp_doc_num => c_pick_slip_numbers_rec.pick_slip_number,
3811: p_grp_src_type_id => NULL,
3812: x_return_status => l_return_status);
3813: IF l_return_status = fnd_api.g_ret_sts_error THEN
3814: RAISE fnd_api.g_exc_error;
3815: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3816: RAISE fnd_api.g_exc_unexpected_error;
3817: END IF;
3818: l_return_status := fnd_api.g_ret_sts_success;

Line 3815: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

3811: p_grp_src_type_id => NULL,
3812: x_return_status => l_return_status);
3813: IF l_return_status = fnd_api.g_ret_sts_error THEN
3814: RAISE fnd_api.g_exc_error;
3815: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3816: RAISE fnd_api.g_exc_unexpected_error;
3817: END IF;
3818: l_return_status := fnd_api.g_ret_sts_success;
3819: END IF;

Line 3816: RAISE fnd_api.g_exc_unexpected_error;

3812: x_return_status => l_return_status);
3813: IF l_return_status = fnd_api.g_ret_sts_error THEN
3814: RAISE fnd_api.g_exc_error;
3815: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3816: RAISE fnd_api.g_exc_unexpected_error;
3817: END IF;
3818: l_return_status := fnd_api.g_ret_sts_success;
3819: END IF;
3820: IF c_pick_slip_lock_check%isopen THEN

Line 3818: l_return_status := fnd_api.g_ret_sts_success;

3814: RAISE fnd_api.g_exc_error;
3815: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3816: RAISE fnd_api.g_exc_unexpected_error;
3817: END IF;
3818: l_return_status := fnd_api.g_ret_sts_success;
3819: END IF;
3820: IF c_pick_slip_lock_check%isopen THEN
3821: CLOSE c_pick_slip_lock_check;
3822: END IF;

Line 4009: IF l_return_status = fnd_api.g_ret_sts_error THEN

4005: IF l_debug = 1 THEN
4006: print_debug('Return Status after the call to store_locked_tasks ' || l_return_status ||' p_task_method ' || p_task_method, 4);
4007: END IF;
4008:
4009: IF l_return_status = fnd_api.g_ret_sts_error THEN
4010: RAISE fnd_api.g_exc_error;
4011: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4012: RAISE fnd_api.g_exc_unexpected_error;
4013: END IF;

Line 4010: RAISE fnd_api.g_exc_error;

4006: print_debug('Return Status after the call to store_locked_tasks ' || l_return_status ||' p_task_method ' || p_task_method, 4);
4007: END IF;
4008:
4009: IF l_return_status = fnd_api.g_ret_sts_error THEN
4010: RAISE fnd_api.g_exc_error;
4011: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4012: RAISE fnd_api.g_exc_unexpected_error;
4013: END IF;
4014: l_return_status := fnd_api.g_ret_sts_success;

Line 4011: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

4007: END IF;
4008:
4009: IF l_return_status = fnd_api.g_ret_sts_error THEN
4010: RAISE fnd_api.g_exc_error;
4011: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4012: RAISE fnd_api.g_exc_unexpected_error;
4013: END IF;
4014: l_return_status := fnd_api.g_ret_sts_success;
4015: -- bug 4358107

Line 4012: RAISE fnd_api.g_exc_unexpected_error;

4008:
4009: IF l_return_status = fnd_api.g_ret_sts_error THEN
4010: RAISE fnd_api.g_exc_error;
4011: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4012: RAISE fnd_api.g_exc_unexpected_error;
4013: END IF;
4014: l_return_status := fnd_api.g_ret_sts_success;
4015: -- bug 4358107
4016:

Line 4014: l_return_status := fnd_api.g_ret_sts_success;

4010: RAISE fnd_api.g_exc_error;
4011: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4012: RAISE fnd_api.g_exc_unexpected_error;
4013: END IF;
4014: l_return_status := fnd_api.g_ret_sts_success;
4015: -- bug 4358107
4016:
4017: END IF;
4018:

Line 4059: IF l_return_status = fnd_api.g_ret_sts_error THEN

4055: IF l_debug = 1 THEN
4056: print_debug('Return Status after the call to store_locked_tasks ' || l_return_status ||' p_task_method ' || p_task_method, 4);
4057: END IF;
4058:
4059: IF l_return_status = fnd_api.g_ret_sts_error THEN
4060: RAISE fnd_api.g_exc_error;
4061: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4062: RAISE fnd_api.g_exc_unexpected_error;
4063: END IF;

Line 4060: RAISE fnd_api.g_exc_error;

4056: print_debug('Return Status after the call to store_locked_tasks ' || l_return_status ||' p_task_method ' || p_task_method, 4);
4057: END IF;
4058:
4059: IF l_return_status = fnd_api.g_ret_sts_error THEN
4060: RAISE fnd_api.g_exc_error;
4061: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4062: RAISE fnd_api.g_exc_unexpected_error;
4063: END IF;
4064: l_return_status := fnd_api.g_ret_sts_success;

Line 4061: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

4057: END IF;
4058:
4059: IF l_return_status = fnd_api.g_ret_sts_error THEN
4060: RAISE fnd_api.g_exc_error;
4061: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4062: RAISE fnd_api.g_exc_unexpected_error;
4063: END IF;
4064: l_return_status := fnd_api.g_ret_sts_success;
4065: -- bug 4358107

Line 4062: RAISE fnd_api.g_exc_unexpected_error;

4058:
4059: IF l_return_status = fnd_api.g_ret_sts_error THEN
4060: RAISE fnd_api.g_exc_error;
4061: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4062: RAISE fnd_api.g_exc_unexpected_error;
4063: END IF;
4064: l_return_status := fnd_api.g_ret_sts_success;
4065: -- bug 4358107
4066:

Line 4064: l_return_status := fnd_api.g_ret_sts_success;

4060: RAISE fnd_api.g_exc_error;
4061: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4062: RAISE fnd_api.g_exc_unexpected_error;
4063: END IF;
4064: l_return_status := fnd_api.g_ret_sts_success;
4065: -- bug 4358107
4066:
4067: END IF;
4068:

Line 4106: IF l_return_status = fnd_api.g_ret_sts_error THEN

4102: IF l_debug = 1 THEN
4103: print_debug('Return Status after the call to store_locked_tasks ' || l_return_status ||' p_task_method ' || p_task_method, 4);
4104: END IF;
4105:
4106: IF l_return_status = fnd_api.g_ret_sts_error THEN
4107: RAISE fnd_api.g_exc_error;
4108: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4109: RAISE fnd_api.g_exc_unexpected_error;
4110: END IF;

Line 4107: RAISE fnd_api.g_exc_error;

4103: print_debug('Return Status after the call to store_locked_tasks ' || l_return_status ||' p_task_method ' || p_task_method, 4);
4104: END IF;
4105:
4106: IF l_return_status = fnd_api.g_ret_sts_error THEN
4107: RAISE fnd_api.g_exc_error;
4108: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4109: RAISE fnd_api.g_exc_unexpected_error;
4110: END IF;
4111: l_return_status := fnd_api.g_ret_sts_success;

Line 4108: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

4104: END IF;
4105:
4106: IF l_return_status = fnd_api.g_ret_sts_error THEN
4107: RAISE fnd_api.g_exc_error;
4108: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4109: RAISE fnd_api.g_exc_unexpected_error;
4110: END IF;
4111: l_return_status := fnd_api.g_ret_sts_success;
4112: -- bug 4358107

Line 4109: RAISE fnd_api.g_exc_unexpected_error;

4105:
4106: IF l_return_status = fnd_api.g_ret_sts_error THEN
4107: RAISE fnd_api.g_exc_error;
4108: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4109: RAISE fnd_api.g_exc_unexpected_error;
4110: END IF;
4111: l_return_status := fnd_api.g_ret_sts_success;
4112: -- bug 4358107
4113:

Line 4111: l_return_status := fnd_api.g_ret_sts_success;

4107: RAISE fnd_api.g_exc_error;
4108: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4109: RAISE fnd_api.g_exc_unexpected_error;
4110: END IF;
4111: l_return_status := fnd_api.g_ret_sts_success;
4112: -- bug 4358107
4113:
4114: END IF;
4115:

Line 4230: IF l_return_status = fnd_api.g_ret_sts_error THEN

4226: IF l_debug = 1 THEN
4227: print_debug('Return Status after the call to store_locked_tasks ' || l_return_status ||' l_lpn_id :- '|| l_lpn_id, 4);
4228: END IF;
4229:
4230: IF l_return_status = fnd_api.g_ret_sts_error THEN
4231: RAISE fnd_api.g_exc_error;
4232: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4233: RAISE fnd_api.g_exc_unexpected_error;
4234: END IF;

Line 4231: RAISE fnd_api.g_exc_error;

4227: print_debug('Return Status after the call to store_locked_tasks ' || l_return_status ||' l_lpn_id :- '|| l_lpn_id, 4);
4228: END IF;
4229:
4230: IF l_return_status = fnd_api.g_ret_sts_error THEN
4231: RAISE fnd_api.g_exc_error;
4232: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4233: RAISE fnd_api.g_exc_unexpected_error;
4234: END IF;
4235: l_return_status := fnd_api.g_ret_sts_success;

Line 4232: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

4228: END IF;
4229:
4230: IF l_return_status = fnd_api.g_ret_sts_error THEN
4231: RAISE fnd_api.g_exc_error;
4232: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4233: RAISE fnd_api.g_exc_unexpected_error;
4234: END IF;
4235: l_return_status := fnd_api.g_ret_sts_success;
4236:

Line 4233: RAISE fnd_api.g_exc_unexpected_error;

4229:
4230: IF l_return_status = fnd_api.g_ret_sts_error THEN
4231: RAISE fnd_api.g_exc_error;
4232: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4233: RAISE fnd_api.g_exc_unexpected_error;
4234: END IF;
4235: l_return_status := fnd_api.g_ret_sts_success;
4236:
4237: IF l_debug = 1 THEN

Line 4235: l_return_status := fnd_api.g_ret_sts_success;

4231: RAISE fnd_api.g_exc_error;
4232: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4233: RAISE fnd_api.g_exc_unexpected_error;
4234: END IF;
4235: l_return_status := fnd_api.g_ret_sts_success;
4236:
4237: IF l_debug = 1 THEN
4238: print_debug('cartonized tasks end',4);
4239: END IF;

Line 4287: RAISE fnd_api.g_exc_error;

4283: FND_MESSAGE.set_name('WMS', 'WMS_LOCKED_PICKSLIP_TASK');
4284: FND_MESSAGE.set_token('ENTITY1',l_task_id);
4285: FND_MESSAGE.set_token('ENTITY2',l_pick_slip);
4286: fnd_msg_pub.ADD;
4287: RAISE fnd_api.g_exc_error;
4288: ELSIF p_task_method = 'ORDERPICK' THEN
4289: IF l_transaction_type_id = 52 THEN
4290: SELECT SEGMENT1 INTO l_transaction_source_id FROM mtl_sales_orders WHERE sales_order_id=l_transaction_source_id;
4291: END IF;

Line 4295: RAISE fnd_api.g_exc_error;

4291: END IF;
4292: FND_MESSAGE.set_name('WMS', 'WMS_LOCKED_ORDERPICK_TASK');
4293: FND_MESSAGE.set_token('ENTITY1',l_transaction_source_id);
4294: fnd_msg_pub.ADD;
4295: RAISE fnd_api.g_exc_error;
4296: IF l_debug = 1 THEN
4297: print_debug('Displaying WMS_LOCKED_ORDERPICK_TASK',4);
4298: END IF;
4299: END IF;

Line 4312: RAISE fnd_api.g_exc_error;

4308: IF (l_debug = 1) THEN
4309: print_debug('dispatch_task - No eligible picking tasks ', 4);
4310: END IF;
4311:
4312: RAISE fnd_api.g_exc_error;
4313: END IF;
4314:
4315: IF p_task_method <> 'ORDERPICK' THEN
4316: l_transaction_source_id := NULL;

Line 4523: IF l_return_status = fnd_api.g_ret_sts_error THEN

4519: remove_stored_cartons(x_return_status => l_return_status);
4520: IF l_debug = 1 THEN
4521: print_debug('Return Status after the call to remove_locked_tasks ' || l_return_status ||' p_task_method ' || p_task_method, 4);
4522: END IF;
4523: IF l_return_status = fnd_api.g_ret_sts_error THEN
4524: RAISE fnd_api.g_exc_error;
4525: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4526: RAISE fnd_api.g_exc_unexpected_error;
4527: END IF;

Line 4524: RAISE fnd_api.g_exc_error;

4520: IF l_debug = 1 THEN
4521: print_debug('Return Status after the call to remove_locked_tasks ' || l_return_status ||' p_task_method ' || p_task_method, 4);
4522: END IF;
4523: IF l_return_status = fnd_api.g_ret_sts_error THEN
4524: RAISE fnd_api.g_exc_error;
4525: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4526: RAISE fnd_api.g_exc_unexpected_error;
4527: END IF;
4528: l_return_status := fnd_api.g_ret_sts_success;

Line 4525: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

4521: print_debug('Return Status after the call to remove_locked_tasks ' || l_return_status ||' p_task_method ' || p_task_method, 4);
4522: END IF;
4523: IF l_return_status = fnd_api.g_ret_sts_error THEN
4524: RAISE fnd_api.g_exc_error;
4525: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4526: RAISE fnd_api.g_exc_unexpected_error;
4527: END IF;
4528: l_return_status := fnd_api.g_ret_sts_success;
4529: END IF;--Bug 7254397: Clear ...GTMP table end

Line 4526: RAISE fnd_api.g_exc_unexpected_error;

4522: END IF;
4523: IF l_return_status = fnd_api.g_ret_sts_error THEN
4524: RAISE fnd_api.g_exc_error;
4525: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4526: RAISE fnd_api.g_exc_unexpected_error;
4527: END IF;
4528: l_return_status := fnd_api.g_ret_sts_success;
4529: END IF;--Bug 7254397: Clear ...GTMP table end
4530:

Line 4528: l_return_status := fnd_api.g_ret_sts_success;

4524: RAISE fnd_api.g_exc_error;
4525: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4526: RAISE fnd_api.g_exc_unexpected_error;
4527: END IF;
4528: l_return_status := fnd_api.g_ret_sts_success;
4529: END IF;--Bug 7254397: Clear ...GTMP table end
4530:
4531: --Added for Case Picking Project start
4532: IF p_task_method = 'MANIFESTORDER' THEN

Line 4586: RAISE fnd_api.g_exc_error;

4582: IF (l_debug = 1) THEN
4583: print_debug('dispatch_task - No eligible picking tasks ', 4);
4584: END IF;
4585:
4586: RAISE fnd_api.g_exc_error;
4587: END IF;
4588:
4589: l_progress := '90';
4590:

Line 4620: WHEN fnd_api.g_exc_error THEN

4616: ORDER BY task_sequence_id;
4617:
4618: l_progress := '120';
4619: EXCEPTION
4620: WHEN fnd_api.g_exc_error THEN
4621: x_return_status := fnd_api.g_ret_sts_error;
4622:
4623: IF l_curs_ordered_tasks_11%ISOPEN THEN
4624: CLOSE l_curs_ordered_tasks_11;

Line 4621: x_return_status := fnd_api.g_ret_sts_error;

4617:
4618: l_progress := '120';
4619: EXCEPTION
4620: WHEN fnd_api.g_exc_error THEN
4621: x_return_status := fnd_api.g_ret_sts_error;
4622:
4623: IF l_curs_ordered_tasks_11%ISOPEN THEN
4624: CLOSE l_curs_ordered_tasks_11;
4625: END IF;

Line 4635: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

4631: IF l_curs_ordered_tasks_10%ISOPEN THEN
4632: CLOSE l_curs_ordered_tasks_10;
4633: END IF;
4634:
4635: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
4636:
4637: IF (l_debug = 1) THEN
4638: print_debug('dispatch_task: FND_API.g_exc_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
4639: END IF;

Line 4638: print_debug('dispatch_task: FND_API.g_exc_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);

4634:
4635: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
4636:
4637: IF (l_debug = 1) THEN
4638: print_debug('dispatch_task: FND_API.g_exc_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
4639: END IF;
4640: WHEN fnd_api.g_exc_unexpected_error THEN
4641: x_return_status := fnd_api.g_ret_sts_unexp_error;
4642:

Line 4640: WHEN fnd_api.g_exc_unexpected_error THEN

4636:
4637: IF (l_debug = 1) THEN
4638: print_debug('dispatch_task: FND_API.g_exc_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
4639: END IF;
4640: WHEN fnd_api.g_exc_unexpected_error THEN
4641: x_return_status := fnd_api.g_ret_sts_unexp_error;
4642:
4643: IF l_curs_ordered_tasks_11%ISOPEN THEN
4644: CLOSE l_curs_ordered_tasks_11;

Line 4641: x_return_status := fnd_api.g_ret_sts_unexp_error;

4637: IF (l_debug = 1) THEN
4638: print_debug('dispatch_task: FND_API.g_exc_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
4639: END IF;
4640: WHEN fnd_api.g_exc_unexpected_error THEN
4641: x_return_status := fnd_api.g_ret_sts_unexp_error;
4642:
4643: IF l_curs_ordered_tasks_11%ISOPEN THEN
4644: CLOSE l_curs_ordered_tasks_11;
4645: END IF;

Line 4655: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

4651: IF l_curs_ordered_tasks_10%ISOPEN THEN
4652: CLOSE l_curs_ordered_tasks_10;
4653: END IF;
4654:
4655: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
4656:
4657: IF (l_debug = 1) THEN
4658: print_debug('dispatch_task: fnd_api.g_exc_unexpected_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
4659: END IF;

Line 4658: print_debug('dispatch_task: fnd_api.g_exc_unexpected_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);

4654:
4655: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
4656:
4657: IF (l_debug = 1) THEN
4658: print_debug('dispatch_task: fnd_api.g_exc_unexpected_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
4659: END IF;
4660: WHEN OTHERS THEN
4661: x_return_status := fnd_api.g_ret_sts_unexp_error;
4662:

Line 4661: x_return_status := fnd_api.g_ret_sts_unexp_error;

4657: IF (l_debug = 1) THEN
4658: print_debug('dispatch_task: fnd_api.g_exc_unexpected_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
4659: END IF;
4660: WHEN OTHERS THEN
4661: x_return_status := fnd_api.g_ret_sts_unexp_error;
4662:
4663: IF l_curs_ordered_tasks_11%ISOPEN THEN
4664: CLOSE l_curs_ordered_tasks_11;
4665: END IF;

Line 4679: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

4675: IF SQLCODE IS NOT NULL THEN
4676: inv_mobile_helper_functions.sql_error('WMS_Task_Dispatch_Engine.dispatch_task', l_progress, SQLCODE);
4677: END IF;
4678:
4679: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
4680:
4681: IF (l_debug = 1) THEN
4682: print_debug('dispatch_task: Other exception: ' || Sqlerrm || l_progress, 1);
4683: END IF;

Line 4691: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false

4687: -- Old procedure: Not used from 11.5.10
4688:
4689: PROCEDURE dispatch_task(
4690: p_api_version IN NUMBER
4691: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
4692: , p_commit IN VARCHAR2 := fnd_api.g_false
4693: , p_sign_on_emp_id IN NUMBER
4694: , p_sign_on_org_id IN NUMBER
4695: , p_sign_on_zone IN VARCHAR2 := NULL

Line 4692: , p_commit IN VARCHAR2 := fnd_api.g_false

4688:
4689: PROCEDURE dispatch_task(
4690: p_api_version IN NUMBER
4691: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
4692: , p_commit IN VARCHAR2 := fnd_api.g_false
4693: , p_sign_on_emp_id IN NUMBER
4694: , p_sign_on_org_id IN NUMBER
4695: , p_sign_on_zone IN VARCHAR2 := NULL
4696: , p_sign_on_equipment_id IN NUMBER := NULL -- specific equip id, NULL or -999. -999 stands for none

Line 6596: IF fnd_api.to_boolean(p_init_msg_list) THEN

6592:
6593: -- This API is query only, therefore does not create a save point
6594:
6595: -- Initialize message list if p_init_msg_list is set to TRUE.
6596: IF fnd_api.to_boolean(p_init_msg_list) THEN
6597: fnd_msg_pub.initialize;
6598: END IF;
6599:
6600: -- Initialize API return status to success

Line 6601: x_return_status := fnd_api.g_ret_sts_success;

6597: fnd_msg_pub.initialize;
6598: END IF;
6599:
6600: -- Initialize API return status to success
6601: x_return_status := fnd_api.g_ret_sts_success;
6602: -- API body
6603: -- preprocess input parameters
6604:
6605: fnd_profile.get('WMS_SEQUENCE_PICKS_ACROSS_WAVES', l_sequence_picks_across_waves);

Line 7138: RAISE fnd_api.g_exc_error;

7134: IF (l_debug = 1) THEN
7135: print_debug('dispatch_task - No eligible picking tasks ', 4);
7136: END IF;
7137:
7138: RAISE fnd_api.g_exc_error;
7139: END IF;
7140:
7141: IF l_sequence_picks_across_waves = 2 THEN
7142: IF l_is_express_pick <> 1 THEN

Line 7404: RAISE fnd_api.g_exc_error;

7400: IF (l_debug = 1) THEN
7401: print_debug('dispatch_task - No eligible picking tasks ', 4);
7402: END IF;
7403:
7404: RAISE fnd_api.g_exc_error;
7405: END IF;
7406:
7407: l_progress := '90';
7408: -- bug 2648133, inlined wms_dispatchable_tasks_v

Line 7466: WHEN fnd_api.g_exc_error THEN

7462: END IF;
7463:
7464: l_progress := '120';
7465: EXCEPTION
7466: WHEN fnd_api.g_exc_error THEN
7467: x_return_status := fnd_api.g_ret_sts_error;
7468:
7469: IF l_curs_ordered_tasks%ISOPEN THEN
7470: CLOSE l_curs_ordered_tasks;

Line 7467: x_return_status := fnd_api.g_ret_sts_error;

7463:
7464: l_progress := '120';
7465: EXCEPTION
7466: WHEN fnd_api.g_exc_error THEN
7467: x_return_status := fnd_api.g_ret_sts_error;
7468:
7469: IF l_curs_ordered_tasks%ISOPEN THEN
7470: CLOSE l_curs_ordered_tasks;
7471: END IF;

Line 7485: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

7481: IF l_curs_ordered_tasks_aw_exp%ISOPEN THEN
7482: CLOSE l_curs_ordered_tasks_aw_exp;
7483: END IF;
7484:
7485: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
7486:
7487: IF (l_debug = 1) THEN
7488: print_debug('dispatch_task: FND_API.g_exc_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
7489: END IF;

Line 7488: print_debug('dispatch_task: FND_API.g_exc_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);

7484:
7485: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
7486:
7487: IF (l_debug = 1) THEN
7488: print_debug('dispatch_task: FND_API.g_exc_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
7489: END IF;
7490: WHEN fnd_api.g_exc_unexpected_error THEN
7491: x_return_status := fnd_api.g_ret_sts_unexp_error;
7492:

Line 7490: WHEN fnd_api.g_exc_unexpected_error THEN

7486:
7487: IF (l_debug = 1) THEN
7488: print_debug('dispatch_task: FND_API.g_exc_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
7489: END IF;
7490: WHEN fnd_api.g_exc_unexpected_error THEN
7491: x_return_status := fnd_api.g_ret_sts_unexp_error;
7492:
7493: IF l_curs_ordered_tasks%ISOPEN THEN
7494: CLOSE l_curs_ordered_tasks;

Line 7491: x_return_status := fnd_api.g_ret_sts_unexp_error;

7487: IF (l_debug = 1) THEN
7488: print_debug('dispatch_task: FND_API.g_exc_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
7489: END IF;
7490: WHEN fnd_api.g_exc_unexpected_error THEN
7491: x_return_status := fnd_api.g_ret_sts_unexp_error;
7492:
7493: IF l_curs_ordered_tasks%ISOPEN THEN
7494: CLOSE l_curs_ordered_tasks;
7495: END IF;

Line 7509: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

7505: IF l_curs_ordered_tasks_aw_exp%ISOPEN THEN
7506: CLOSE l_curs_ordered_tasks_aw_exp;
7507: END IF;
7508:
7509: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
7510:
7511: IF (l_debug = 1) THEN
7512: print_debug('dispatch_task: fnd_api.g_exc_unexpected_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
7513: END IF;

Line 7512: print_debug('dispatch_task: fnd_api.g_exc_unexpected_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);

7508:
7509: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
7510:
7511: IF (l_debug = 1) THEN
7512: print_debug('dispatch_task: fnd_api.g_exc_unexpected_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
7513: END IF;
7514: WHEN OTHERS THEN
7515: x_return_status := fnd_api.g_ret_sts_unexp_error;
7516:

Line 7515: x_return_status := fnd_api.g_ret_sts_unexp_error;

7511: IF (l_debug = 1) THEN
7512: print_debug('dispatch_task: fnd_api.g_exc_unexpected_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
7513: END IF;
7514: WHEN OTHERS THEN
7515: x_return_status := fnd_api.g_ret_sts_unexp_error;
7516:
7517: IF l_curs_ordered_tasks%ISOPEN THEN
7518: CLOSE l_curs_ordered_tasks;
7519: END IF;

Line 7537: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

7533: IF SQLCODE IS NOT NULL THEN
7534: inv_mobile_helper_functions.sql_error('WMS_Task_Dispatch_Engine.dispatch_task', l_progress, SQLCODE);
7535: END IF;
7536:
7537: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
7538:
7539: IF (l_debug = 1) THEN
7540: print_debug('dispatch_task: Other exception ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
7541: END IF;

Line 7548: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false

7544: -- CP Enhancements
7545: -- This Method has been over-ridden for implementing the cluster picking task dispatch logic.
7546: PROCEDURE dispatch_task(
7547: p_api_version IN NUMBER
7548: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
7549: , p_commit IN VARCHAR2 := fnd_api.g_false
7550: , p_sign_on_emp_id IN NUMBER
7551: , p_sign_on_org_id IN NUMBER
7552: , p_sign_on_zone IN VARCHAR2 := NULL

Line 7549: , p_commit IN VARCHAR2 := fnd_api.g_false

7545: -- This Method has been over-ridden for implementing the cluster picking task dispatch logic.
7546: PROCEDURE dispatch_task(
7547: p_api_version IN NUMBER
7548: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
7549: , p_commit IN VARCHAR2 := fnd_api.g_false
7550: , p_sign_on_emp_id IN NUMBER
7551: , p_sign_on_org_id IN NUMBER
7552: , p_sign_on_zone IN VARCHAR2 := NULL
7553: , p_sign_on_equipment_id IN NUMBER := NULL -- specific equip id, NULL or -999. -999 stands for none

Line 10160: IF fnd_api.to_boolean(p_init_msg_list) THEN

10156: l_progress := '10';
10157:
10158: -- This API is query only, therefore does not create a save point
10159: -- Initialize message list if p_init_msg_list is set to TRUE.
10160: IF fnd_api.to_boolean(p_init_msg_list) THEN
10161: fnd_msg_pub.initialize;
10162: END IF;
10163:
10164: -- Initialize API return status to success

Line 10165: x_return_status := fnd_api.g_ret_sts_success;

10161: fnd_msg_pub.initialize;
10162: END IF;
10163:
10164: -- Initialize API return status to success
10165: x_return_status := fnd_api.g_ret_sts_success;
10166:
10167: -- API body
10168: -- preprocess input parameters
10169:

Line 10972: RAISE fnd_api.g_exc_error;

10968: IF (l_debug = 1) THEN
10969: print_debug('dispatch_task - No eligible picking tasks ', 4);
10970: END IF;
10971:
10972: RAISE fnd_api.g_exc_error;
10973: END IF;
10974:
10975: l_progress := '90';
10976: END IF; -- end task type check if

Line 11012: WHEN fnd_api.g_exc_error THEN

11008: AND mmtt.transaction_temp_id > 0
11009: ORDER BY wot.task_sequence_id;
11010: l_progress := '120';
11011: EXCEPTION
11012: WHEN fnd_api.g_exc_error THEN
11013: x_return_status := fnd_api.g_ret_sts_error;
11014:
11015: IF l_cp_curs_ordered_tasks%ISOPEN THEN
11016: CLOSE l_cp_curs_ordered_tasks;

Line 11013: x_return_status := fnd_api.g_ret_sts_error;

11009: ORDER BY wot.task_sequence_id;
11010: l_progress := '120';
11011: EXCEPTION
11012: WHEN fnd_api.g_exc_error THEN
11013: x_return_status := fnd_api.g_ret_sts_error;
11014:
11015: IF l_cp_curs_ordered_tasks%ISOPEN THEN
11016: CLOSE l_cp_curs_ordered_tasks;
11017: END IF;

Line 11023: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

11019: IF l_cp_curs_ordered_tasks_no_sub%ISOPEN THEN -- bug 2648133
11020: CLOSE l_cp_curs_ordered_tasks_no_sub;
11021: END IF;
11022:
11023: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
11024:
11025: IF (l_debug = 1) THEN
11026: print_debug('dispatch_task: FND_API.g_exc_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
11027: END IF;

Line 11026: print_debug('dispatch_task: FND_API.g_exc_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);

11022:
11023: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
11024:
11025: IF (l_debug = 1) THEN
11026: print_debug('dispatch_task: FND_API.g_exc_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
11027: END IF;
11028: WHEN fnd_api.g_exc_unexpected_error THEN
11029: x_return_status := fnd_api.g_ret_sts_unexp_error;
11030:

Line 11028: WHEN fnd_api.g_exc_unexpected_error THEN

11024:
11025: IF (l_debug = 1) THEN
11026: print_debug('dispatch_task: FND_API.g_exc_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
11027: END IF;
11028: WHEN fnd_api.g_exc_unexpected_error THEN
11029: x_return_status := fnd_api.g_ret_sts_unexp_error;
11030:
11031: IF l_cp_curs_ordered_tasks%ISOPEN THEN
11032: CLOSE l_cp_curs_ordered_tasks;

Line 11029: x_return_status := fnd_api.g_ret_sts_unexp_error;

11025: IF (l_debug = 1) THEN
11026: print_debug('dispatch_task: FND_API.g_exc_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
11027: END IF;
11028: WHEN fnd_api.g_exc_unexpected_error THEN
11029: x_return_status := fnd_api.g_ret_sts_unexp_error;
11030:
11031: IF l_cp_curs_ordered_tasks%ISOPEN THEN
11032: CLOSE l_cp_curs_ordered_tasks;
11033: END IF;

Line 11039: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

11035: IF l_cp_curs_ordered_tasks_no_sub%ISOPEN THEN -- bug 2648133
11036: CLOSE l_cp_curs_ordered_tasks_no_sub;
11037: END IF;
11038:
11039: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
11040:
11041: IF (l_debug = 1) THEN
11042: print_debug('dispatch_task: fnd_api.g_exc_unexpected_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
11043: END IF;

Line 11042: print_debug('dispatch_task: fnd_api.g_exc_unexpected_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);

11038:
11039: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
11040:
11041: IF (l_debug = 1) THEN
11042: print_debug('dispatch_task: fnd_api.g_exc_unexpected_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
11043: END IF;
11044: WHEN OTHERS THEN
11045: x_return_status := fnd_api.g_ret_sts_unexp_error;
11046:

Line 11045: x_return_status := fnd_api.g_ret_sts_unexp_error;

11041: IF (l_debug = 1) THEN
11042: print_debug('dispatch_task: fnd_api.g_exc_unexpected_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
11043: END IF;
11044: WHEN OTHERS THEN
11045: x_return_status := fnd_api.g_ret_sts_unexp_error;
11046:
11047: IF l_cp_curs_ordered_tasks%ISOPEN THEN
11048: CLOSE l_cp_curs_ordered_tasks;
11049: END IF;

Line 11059: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

11055: IF SQLCODE IS NOT NULL THEN
11056: inv_mobile_helper_functions.sql_error('WMS_Task_Dispatch_Engine.dispatch_task', l_progress, SQLCODE);
11057: END IF;
11058:
11059: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
11060:
11061: IF (l_debug = 1) THEN
11062: print_debug('dispatch_task: Other exception ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
11063: END IF;

Line 11081: , p_commit VARCHAR2 := fnd_api.g_false

11077:
11078: PROCEDURE split_tasks(
11079: p_api_version NUMBER
11080: , p_move_order_header_id NUMBER
11081: , p_commit VARCHAR2 := fnd_api.g_false
11082: , x_return_status OUT NOCOPY VARCHAR2
11083: , x_msg_count OUT NOCOPY NUMBER
11084: , x_msg_data OUT NOCOPY VARCHAR2
11085: ) IS

Line 11114: x_return_status := fnd_api.g_ret_sts_success;

11110:
11111: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
11112: BEGIN
11113: -- Initialize API return status to success
11114: x_return_status := fnd_api.g_ret_sts_success;
11115:
11116: IF (l_debug = 1) THEN
11117: print_debug('Enter split_tasks 10 ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
11118: END IF;

Line 11172: IF l_return_status = fnd_api.g_ret_sts_error THEN

11168: , x_msg_count => l_msg_count
11169: , x_msg_data => l_msg_data
11170: );
11171:
11172: IF l_return_status = fnd_api.g_ret_sts_error THEN
11173: IF (l_debug = 1) THEN
11174: print_debug('split_tasks 30 - split_task RAISE FND_API.G_EXC_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
11175: END IF;
11176:

Line 11174: print_debug('split_tasks 30 - split_task RAISE FND_API.G_EXC_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);

11170: );
11171:
11172: IF l_return_status = fnd_api.g_ret_sts_error THEN
11173: IF (l_debug = 1) THEN
11174: print_debug('split_tasks 30 - split_task RAISE FND_API.G_EXC_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
11175: END IF;
11176:
11177: -- RAISE fnd_api.g_exc_error;
11178: -- in case of error for one task, should continue for another task

Line 11177: -- RAISE fnd_api.g_exc_error;

11173: IF (l_debug = 1) THEN
11174: print_debug('split_tasks 30 - split_task RAISE FND_API.G_EXC_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
11175: END IF;
11176:
11177: -- RAISE fnd_api.g_exc_error;
11178: -- in case of error for one task, should continue for another task
11179: END IF;
11180:
11181: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 11181: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

11177: -- RAISE fnd_api.g_exc_error;
11178: -- in case of error for one task, should continue for another task
11179: END IF;
11180:
11181: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
11182: IF (l_debug = 1) THEN
11183: print_debug('split_tasks 40 - split_task RAISE FND_API.G_EXC_UNEXPECTED_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
11184: END IF;
11185:

Line 11183: print_debug('split_tasks 40 - split_task RAISE FND_API.G_EXC_UNEXPECTED_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);

11179: END IF;
11180:
11181: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
11182: IF (l_debug = 1) THEN
11183: print_debug('split_tasks 40 - split_task RAISE FND_API.G_EXC_UNEXPECTED_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
11184: END IF;
11185:
11186: RAISE fnd_api.g_exc_unexpected_error;
11187: END IF;

Line 11186: RAISE fnd_api.g_exc_unexpected_error;

11182: IF (l_debug = 1) THEN
11183: print_debug('split_tasks 40 - split_task RAISE FND_API.G_EXC_UNEXPECTED_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
11184: END IF;
11185:
11186: RAISE fnd_api.g_exc_unexpected_error;
11187: END IF;
11188: END LOOP;
11189:
11190: l_progress := '50';

Line 11202: WHEN fnd_api.g_exc_error THEN

11198: IF (l_debug = 1) THEN
11199: print_debug('split_tasks 50 complete' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
11200: END IF;
11201: EXCEPTION
11202: WHEN fnd_api.g_exc_error THEN
11203: x_return_status := fnd_api.g_ret_sts_error;
11204: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
11205:
11206: IF (l_debug = 1) THEN

Line 11203: x_return_status := fnd_api.g_ret_sts_error;

11199: print_debug('split_tasks 50 complete' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
11200: END IF;
11201: EXCEPTION
11202: WHEN fnd_api.g_exc_error THEN
11203: x_return_status := fnd_api.g_ret_sts_error;
11204: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
11205:
11206: IF (l_debug = 1) THEN
11207: print_debug('split_tasks: FND_API.g_exc_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);

Line 11204: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

11200: END IF;
11201: EXCEPTION
11202: WHEN fnd_api.g_exc_error THEN
11203: x_return_status := fnd_api.g_ret_sts_error;
11204: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
11205:
11206: IF (l_debug = 1) THEN
11207: print_debug('split_tasks: FND_API.g_exc_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
11208: END IF;

Line 11207: print_debug('split_tasks: FND_API.g_exc_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);

11203: x_return_status := fnd_api.g_ret_sts_error;
11204: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
11205:
11206: IF (l_debug = 1) THEN
11207: print_debug('split_tasks: FND_API.g_exc_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
11208: END IF;
11209: WHEN fnd_api.g_exc_unexpected_error THEN
11210: x_return_status := fnd_api.g_ret_sts_unexp_error;
11211: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

Line 11209: WHEN fnd_api.g_exc_unexpected_error THEN

11205:
11206: IF (l_debug = 1) THEN
11207: print_debug('split_tasks: FND_API.g_exc_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
11208: END IF;
11209: WHEN fnd_api.g_exc_unexpected_error THEN
11210: x_return_status := fnd_api.g_ret_sts_unexp_error;
11211: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
11212:
11213: IF (l_debug = 1) THEN

Line 11210: x_return_status := fnd_api.g_ret_sts_unexp_error;

11206: IF (l_debug = 1) THEN
11207: print_debug('split_tasks: FND_API.g_exc_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
11208: END IF;
11209: WHEN fnd_api.g_exc_unexpected_error THEN
11210: x_return_status := fnd_api.g_ret_sts_unexp_error;
11211: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
11212:
11213: IF (l_debug = 1) THEN
11214: print_debug('split_tasks: fnd_api.g_exc_unexpected_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);

Line 11211: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

11207: print_debug('split_tasks: FND_API.g_exc_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
11208: END IF;
11209: WHEN fnd_api.g_exc_unexpected_error THEN
11210: x_return_status := fnd_api.g_ret_sts_unexp_error;
11211: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
11212:
11213: IF (l_debug = 1) THEN
11214: print_debug('split_tasks: fnd_api.g_exc_unexpected_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
11215: END IF;

Line 11214: print_debug('split_tasks: fnd_api.g_exc_unexpected_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);

11210: x_return_status := fnd_api.g_ret_sts_unexp_error;
11211: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
11212:
11213: IF (l_debug = 1) THEN
11214: print_debug('split_tasks: fnd_api.g_exc_unexpected_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
11215: END IF;
11216: WHEN OTHERS THEN
11217: x_return_status := fnd_api.g_ret_sts_unexp_error;
11218:

Line 11217: x_return_status := fnd_api.g_ret_sts_unexp_error;

11213: IF (l_debug = 1) THEN
11214: print_debug('split_tasks: fnd_api.g_exc_unexpected_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
11215: END IF;
11216: WHEN OTHERS THEN
11217: x_return_status := fnd_api.g_ret_sts_unexp_error;
11218:
11219: IF SQLCODE IS NOT NULL THEN
11220: inv_mobile_helper_functions.sql_error('WMS_Task_Dispatch_Engine.split_tasks', l_progress, SQLCODE);
11221: END IF;

Line 11223: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

11219: IF SQLCODE IS NOT NULL THEN
11220: inv_mobile_helper_functions.sql_error('WMS_Task_Dispatch_Engine.split_tasks', l_progress, SQLCODE);
11221: END IF;
11222:
11223: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
11224:
11225: IF (l_debug = 1) THEN
11226: print_debug('split_tasks: Other exception ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
11227: END IF;

Line 11503: , p_commit IN VARCHAR2 := fnd_api.g_false

11499:
11500:
11501: PROCEDURE consolidate_bulk_tasks(
11502: p_api_version IN NUMBER
11503: , p_commit IN VARCHAR2 := fnd_api.g_false
11504: , x_return_status OUT NOCOPY VARCHAR2
11505: , x_msg_count OUT NOCOPY NUMBER
11506: , x_msg_data OUT NOCOPY VARCHAR2
11507: , p_move_order_header_id IN NUMBER

Line 11759: x_return_status := fnd_api.g_ret_sts_success;

11755: END IF;
11756:
11757: SAVEPOINT sp_consolidate_bulk_task;
11758:
11759: x_return_status := fnd_api.g_ret_sts_success;
11760:
11761: SELECT move_order_type
11762: INTO l_move_order_type
11763: FROM mtl_txn_request_headers

Line 12037: x_return_status := fnd_api.g_ret_sts_unexp_error;

12033: print_debug('Number of Parent Tasks = ' || l_parent_task_count, 4);
12034: END IF;
12035: EXCEPTION
12036: WHEN OTHERS THEN
12037: x_return_status := fnd_api.g_ret_sts_unexp_error;
12038: ROLLBACK TO sp_consolidate_bulk_task;
12039: IF l_debug = 1 THEN
12040: print_debug('Exception Occurred = ' || SQLERRM,4);
12041: END IF;

Line 12049: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

12045: END IF;
12046: IF task_list_wip%ISOPEN THEN
12047: CLOSE task_list_wip;
12048: END IF;
12049: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
12050: END consolidate_bulk_tasks;
12051:
12052:
12053:

Line 12056: , p_commit IN VARCHAR2 := fnd_api.g_false

12052:
12053:
12054: PROCEDURE consolidate_bulk_tasks_for_so(
12055: p_api_version IN NUMBER
12056: , p_commit IN VARCHAR2 := fnd_api.g_false
12057: , x_return_status OUT NOCOPY VARCHAR2
12058: , x_msg_count OUT NOCOPY NUMBER
12059: , x_msg_data OUT NOCOPY VARCHAR2
12060: , p_move_order_header_id IN NUMBER

Line 12427: x_return_status := fnd_api.g_ret_sts_success;

12423:
12424: SAVEPOINT sp_consolidate_bulk_task;
12425:
12426:
12427: x_return_status := fnd_api.g_ret_sts_success;
12428:
12429: -- check if the delivery is checked in the bulk picking rule-------------
12430: IF p_move_order_header_id <> -1 THEN
12431:

Line 12861: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

12857: print_debug('Number of child lines processed = ' || l_total_child_count,4);
12858: END IF;
12859: END IF; -- Bug 7005328
12860:
12861: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
12862: EXCEPTION
12863: WHEN OTHERS THEN
12864: x_return_status := fnd_api.g_ret_sts_unexp_error;
12865: ROLLBACK TO sp_consolidate_bulk_task;

Line 12864: x_return_status := fnd_api.g_ret_sts_unexp_error;

12860:
12861: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
12862: EXCEPTION
12863: WHEN OTHERS THEN
12864: x_return_status := fnd_api.g_ret_sts_unexp_error;
12865: ROLLBACK TO sp_consolidate_bulk_task;
12866: IF l_debug = 1 THEN
12867: print_debug('Exception Occurred = ' || SQLERRM,4);
12868: END IF;

Line 12884: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

12880: IF task_list_con_cd%ISOPEN THEN
12881: CLOSE task_list_con_cd;
12882: END IF;
12883:
12884: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
12885: END consolidate_bulk_tasks_for_so;
12886:
12887: --------- patchset J bulk picking -----------------
12888: -- This procedure will be called inside the split_task API. It will be called after stamping the parent_line_id

Line 12913: x_return_status := fnd_api.g_ret_sts_success;

12909: END IF;
12910:
12911:
12912: -- Initialize API return status to success
12913: x_return_status := fnd_api.g_ret_sts_success;
12914:
12915: -- to get the serial control code
12916: select serial_number_control_code,lot_control_code
12917: into l_serial_number_control_code,l_lot_control_code

Line 12966: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

12962:
12963: END IF;
12964:
12965:
12966: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
12967:
12968: EXCEPTION
12969: WHEN OTHERS THEN
12970: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 12970: x_return_status := fnd_api.g_ret_sts_unexp_error;

12966: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
12967:
12968: EXCEPTION
12969: WHEN OTHERS THEN
12970: x_return_status := fnd_api.g_ret_sts_unexp_error;
12971:
12972: IF l_debug = 1 THEN
12973: print_debug('Exception Occurred = ' || SQLERRM,4);
12974: END IF;

Line 12976: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

12972: IF l_debug = 1 THEN
12973: print_debug('Exception Occurred = ' || SQLERRM,4);
12974: END IF;
12975:
12976: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
12977:
12978: END Duplicate_lot_serial_in_parent;
12979:
12980: ----- end of patchset J bulk picking ------------------------------------

Line 12985: , p_commit VARCHAR2 := fnd_api.g_false

12981:
12982: PROCEDURE split_task(
12983: p_api_version NUMBER
12984: , p_task_id NUMBER
12985: , p_commit VARCHAR2 := fnd_api.g_false
12986: , x_return_status OUT NOCOPY VARCHAR2
12987: , x_msg_count OUT NOCOPY NUMBER
12988: , x_msg_data OUT NOCOPY VARCHAR2
12989: ) IS

Line 13027: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

13023: l_new_qty NUMBER;
13024: l_counter NUMBER := 0;
13025: l_new_temp_id NUMBER;
13026: l_progress VARCHAR2(10);
13027: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
13028: l_msg_count NUMBER;
13029: l_msg_data VARCHAR2(400);
13030:
13031: -- capacity cursur for all the equipments that is eligible for one task

Line 13133: x_return_status := fnd_api.g_ret_sts_success;

13129: l_progress := '10';
13130: SAVEPOINT sp_task_split;
13131: l_progress := '20';
13132: -- Initialize API return status to success
13133: x_return_status := fnd_api.g_ret_sts_success;
13134: -- query locator picking UOM code, if NULL use subinventory picking UOM code
13135: -- query transaction UOM code, and primary UOM code
13136: -- query transacted item ID
13137: -- Also query the transaction quantity

Line 13244: RAISE fnd_api.g_exc_unexpected_error;

13240: IF (l_debug = 1) THEN
13241: print_debug('split_task 30 - necessary UOM information missing' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
13242: END IF;
13243:
13244: RAISE fnd_api.g_exc_unexpected_error;
13245: END IF;
13246:
13247: -- call UOM conversion API to compute the ratio between
13248: -- locator UOM and transcation UOM for given item

Line 13260: RAISE fnd_api.g_exc_error;

13256: IF (l_debug = 1) THEN
13257: print_debug('split_task 40 - loc/item uom ratio calculation failed' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
13258: END IF;
13259:
13260: RAISE fnd_api.g_exc_error;
13261: END IF;
13262:
13263: -- compute conversion rate between transaction UOM and item primary UOM
13264: inv_convert.inv_um_conversion(from_unit => l_txn_uom_code, to_unit => l_item_prim_uom_code, item_id => l_item_id

Line 13275: RAISE fnd_api.g_exc_error;

13271: IF (l_debug = 1) THEN
13272: print_debug('split_task 50 - txn/item uom ratio calculation failed' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
13273: END IF;
13274:
13275: RAISE fnd_api.g_exc_error;
13276: END IF;
13277:
13278: IF (l_debug = 1) THEN
13279: print_debug('split_task 60 - UOM conversion data:' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);

Line 13518: RAISE fnd_api.g_exc_error;

13514: IF (l_debug = 1) THEN
13515: print_debug('split_task 90 - invalid capacity for a ALL equipment' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
13516: END IF;
13517:
13518: RAISE fnd_api.g_exc_error;
13519: END IF;
13520:
13521: -- compute splitting factor, round down equipment capacity to multiple of locator uom ratio
13522: IF l_min_cap >= l_loc_txn_uom_ratio THEN

Line 13540: RAISE fnd_api.g_exc_error;

13536: IF (l_debug = 1) THEN
13537: print_debug('split_task 95 - minimum capacity 0' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
13538: END IF;
13539:
13540: RAISE fnd_api.g_exc_error;
13541: END IF;
13542:
13543: -- query the inital task
13544:

Line 13765: if (x_return_status <> fnd_api.g_ret_sts_success) then

13761: print_debug('calling duplicate_lot_serial_in_parent....',4);
13762: END IF;
13763: Duplicate_lot_serial_in_parent(l_new_temp_id,x_return_status,x_msg_count,x_msg_data);
13764:
13765: if (x_return_status <> fnd_api.g_ret_sts_success) then
13766: IF (l_debug = 1) THEN
13767: print_debug('split_task 150.2 - error in duplicate_lot_serial_in_parent ', 4);
13768: END IF;
13769: raise fnd_api.g_exc_unexpected_error;

Line 13769: raise fnd_api.g_exc_unexpected_error;

13765: if (x_return_status <> fnd_api.g_ret_sts_success) then
13766: IF (l_debug = 1) THEN
13767: print_debug('split_task 150.2 - error in duplicate_lot_serial_in_parent ', 4);
13768: END IF;
13769: raise fnd_api.g_exc_unexpected_error;
13770: end if;
13771: -- IF (l_debug = 1) THEN print_debug('PATCHSET J -- BULK PICKING --- END',4); END IF;
13772: END IF;
13773:

Line 13822: if (x_return_status <> fnd_api.g_ret_sts_success) then

13818: IF (l_debug = 1) THEN
13819: print_debug('calling duplicate_lot_serial_in_parent for the last ....',4);
13820: END IF;
13821: Duplicate_lot_serial_in_parent(p_task_id,x_return_status,x_msg_count,x_msg_data);
13822: if (x_return_status <> fnd_api.g_ret_sts_success) then
13823: IF (l_debug = 1) THEN
13824: print_debug('split_task 150.2 - error in duplicate_lot_serial_in_parent ', 4);
13825: END IF;
13826: raise fnd_api.g_exc_unexpected_error;

Line 13826: raise fnd_api.g_exc_unexpected_error;

13822: if (x_return_status <> fnd_api.g_ret_sts_success) then
13823: IF (l_debug = 1) THEN
13824: print_debug('split_task 150.2 - error in duplicate_lot_serial_in_parent ', 4);
13825: END IF;
13826: raise fnd_api.g_exc_unexpected_error;
13827: end if;
13828: END IF;
13829: -- IF (l_debug = 1) THEN print_debug('PATCHSET J -- BULK PICKING --- END',4); END IF;
13830: end if; -- end of patchset J bulk picking ----------

Line 13844: WHEN fnd_api.g_exc_error THEN

13840: IF (l_debug = 1) THEN
13841: print_debug('split_task 140 - complete ', 4);
13842: END IF;
13843: EXCEPTION
13844: WHEN fnd_api.g_exc_error THEN
13845: x_return_status := fnd_api.g_ret_sts_error;
13846: ROLLBACK TO sp_task_split;
13847: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
13848:

Line 13845: x_return_status := fnd_api.g_ret_sts_error;

13841: print_debug('split_task 140 - complete ', 4);
13842: END IF;
13843: EXCEPTION
13844: WHEN fnd_api.g_exc_error THEN
13845: x_return_status := fnd_api.g_ret_sts_error;
13846: ROLLBACK TO sp_task_split;
13847: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
13848:
13849: IF (l_debug = 1) THEN

Line 13847: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

13843: EXCEPTION
13844: WHEN fnd_api.g_exc_error THEN
13845: x_return_status := fnd_api.g_ret_sts_error;
13846: ROLLBACK TO sp_task_split;
13847: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
13848:
13849: IF (l_debug = 1) THEN
13850: print_debug(
13851: 'split_task: Raise expected exception. But the task generation process should continue processing, only that tasks are not split according to equipment capacity. '

Line 13868: if (x_return_status <> fnd_api.g_ret_sts_success) then

13864: IF (l_debug = 1) THEN
13865: print_debug('calling duplicate_lot_serial_in_parent for the parent line ....',4);
13866: END IF;
13867: Duplicate_lot_serial_in_parent(p_task_id,x_return_status,x_msg_count,x_msg_data);
13868: if (x_return_status <> fnd_api.g_ret_sts_success) then
13869: IF (l_debug = 1) THEN
13870: print_debug('split_task 1000- error in duplicate_lot_serial_in_parent ', 4);
13871: END IF;
13872: -- change to unexpected error

Line 13873: x_return_status := fnd_api.g_ret_sts_unexp_error;

13869: IF (l_debug = 1) THEN
13870: print_debug('split_task 1000- error in duplicate_lot_serial_in_parent ', 4);
13871: END IF;
13872: -- change to unexpected error
13873: x_return_status := fnd_api.g_ret_sts_unexp_error;
13874: end if;
13875: END IF;
13876: -- IF (l_debug = 1) THEN print_debug('PATCHSET J -- BULK PICKING --- END',4); END IF;
13877: end if; -- end of patchset J bulk picking ----------

Line 13879: WHEN fnd_api.g_exc_unexpected_error THEN

13875: END IF;
13876: -- IF (l_debug = 1) THEN print_debug('PATCHSET J -- BULK PICKING --- END',4); END IF;
13877: end if; -- end of patchset J bulk picking ----------
13878:
13879: WHEN fnd_api.g_exc_unexpected_error THEN
13880: x_return_status := fnd_api.g_ret_sts_unexp_error;
13881: ROLLBACK TO sp_task_split;
13882: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
13883:

Line 13880: x_return_status := fnd_api.g_ret_sts_unexp_error;

13876: -- IF (l_debug = 1) THEN print_debug('PATCHSET J -- BULK PICKING --- END',4); END IF;
13877: end if; -- end of patchset J bulk picking ----------
13878:
13879: WHEN fnd_api.g_exc_unexpected_error THEN
13880: x_return_status := fnd_api.g_ret_sts_unexp_error;
13881: ROLLBACK TO sp_task_split;
13882: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
13883:
13884: IF (l_debug = 1) THEN

Line 13882: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

13878:
13879: WHEN fnd_api.g_exc_unexpected_error THEN
13880: x_return_status := fnd_api.g_ret_sts_unexp_error;
13881: ROLLBACK TO sp_task_split;
13882: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
13883:
13884: IF (l_debug = 1) THEN
13885: print_debug('split_task: fnd_api.g_exc_unexpected_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
13886: END IF;

Line 13885: print_debug('split_task: fnd_api.g_exc_unexpected_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);

13881: ROLLBACK TO sp_task_split;
13882: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
13883:
13884: IF (l_debug = 1) THEN
13885: print_debug('split_task: fnd_api.g_exc_unexpected_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
13886: END IF;
13887: WHEN OTHERS THEN
13888: x_return_status := fnd_api.g_ret_sts_unexp_error;
13889: ROLLBACK TO sp_task_split;

Line 13888: x_return_status := fnd_api.g_ret_sts_unexp_error;

13884: IF (l_debug = 1) THEN
13885: print_debug('split_task: fnd_api.g_exc_unexpected_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
13886: END IF;
13887: WHEN OTHERS THEN
13888: x_return_status := fnd_api.g_ret_sts_unexp_error;
13889: ROLLBACK TO sp_task_split;
13890:
13891: IF SQLCODE IS NOT NULL THEN
13892: inv_mobile_helper_functions.sql_error('WMS_Task_Dispatch_Engine.split_task', l_progress, SQLCODE);

Line 13895: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

13891: IF SQLCODE IS NOT NULL THEN
13892: inv_mobile_helper_functions.sql_error('WMS_Task_Dispatch_Engine.split_task', l_progress, SQLCODE);
13893: END IF;
13894:
13895: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
13896:
13897: IF (l_debug = 1) THEN
13898: print_debug('split_task: Other exception ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
13899: END IF;

Line 14860: x_return_status := fnd_api.g_ret_sts_success;

14856:
14857: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
14858: l_mmtt_rec mtl_material_transactions_temp%ROWTYPE;
14859: BEGIN
14860: x_return_status := fnd_api.g_ret_sts_success;
14861:
14862: OPEN mmtt;
14863: FETCH mmtt INTO l_mmtt_rec;
14864:

Line 14913: x_return_status := fnd_api.g_ret_sts_unexp_error;

14909: WHEN OTHERS THEN
14910: IF (l_debug = 1) THEN
14911: print_debug('INSERT_MTLT : Exception Occured ' || substrb(SQLERRM,1,200), 1);
14912: END IF;
14913: x_return_status := fnd_api.g_ret_sts_unexp_error;
14914:
14915: END insert_mtlt;
14916:
14917: END wms_task_dispatch_engine;