[Home] [Help]
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
3386: x_return_status := fnd_api.g_ret_sts_success;
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;
3741:
3742: IF (l_debug = 1) THEN
3743: print_debug('dispatch_task - No eligible picking tasks ', 4);
3744: END IF;
4282: END IF;
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;
4290: SELECT SEGMENT1 INTO l_transaction_source_id FROM mtl_sales_orders WHERE sales_order_id=l_transaction_source_id;
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;
4302:
4303: --Modified for Case Picking Project
4304: IF ( l_task_id IS NULL AND p_task_method NOT IN ('CLUSTERPICKBYLABEL','MANIFESTORDER','MANIFESTPICKSLIP') ) THEN --Bug 7254397
4305: fnd_message.set_name('WMS', 'WMS_TASK_NO_ELIGIBLE_TASKS');
4306: fnd_msg_pub.ADD;
4307:
4308: IF (l_debug = 1) THEN
4309: print_debug('dispatch_task - No eligible picking tasks ', 4);
4310: END IF;
4576: END IF;
4577:
4578: IF l_ordered_tasks_count = 0 THEN
4579: fnd_message.set_name('WMS', 'WMS_TASK_NO_ELIGIBLE_TASKS');
4580: fnd_msg_pub.ADD;
4581:
4582: IF (l_debug = 1) THEN
4583: print_debug('dispatch_task - No eligible picking tasks ', 4);
4584: END IF;
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;
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;
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;
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
6601: x_return_status := fnd_api.g_ret_sts_success;
7128: -- End bug fix 2832818
7129:
7130: IF l_opt_task_id IS NULL THEN
7131: fnd_message.set_name('WMS', 'WMS_TASK_NO_ELIGIBLE_TASKS');
7132: fnd_msg_pub.ADD;
7133:
7134: IF (l_debug = 1) THEN
7135: print_debug('dispatch_task - No eligible picking tasks ', 4);
7136: END IF;
7394: END IF;
7395:
7396: IF l_ordered_tasks_count = 0 THEN
7397: fnd_message.set_name('WMS', 'WMS_TASK_NO_ELIGIBLE_TASKS');
7398: fnd_msg_pub.ADD;
7399:
7400: IF (l_debug = 1) THEN
7401: print_debug('dispatch_task - No eligible picking tasks ', 4);
7402: END IF;
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;
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;
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;
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
10165: x_return_status := fnd_api.g_ret_sts_success;
10962: END IF;
10963:
10964: IF l_ordered_tasks_count = 0 THEN
10965: fnd_message.set_name('WMS', 'WMS_TASK_NO_ELIGIBLE_TASKS');
10966: fnd_msg_pub.ADD;
10967:
10968: IF (l_debug = 1) THEN
10969: print_debug('dispatch_task - No eligible picking tasks ', 4);
10970: END IF;
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;
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;
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;
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;
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;
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;
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:
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;
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
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;
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 ------------------------------------
13250: , uom_rate => l_loc_txn_uom_ratio);
13251:
13252: IF l_loc_txn_uom_ratio = -99999 THEN -- uom conversion failure
13253: fnd_message.set_name('INV', 'INV_INT_UOMCONVCODE');
13254: fnd_msg_pub.ADD;
13255:
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;
13265: , uom_rate => l_txn_pri_uom_ratio);
13266:
13267: IF l_txn_pri_uom_ratio = -99999 THEN -- uom conversion failure
13268: fnd_message.set_name('INV', 'INV_INT_UOMCONVCODE');
13269: fnd_msg_pub.ADD;
13270:
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;
13329: -- get the conversion ratio between equipment and item volume UOM
13330: inv_convert.inv_um_conversion(from_unit => l_equip_v_uom, to_unit => l_item_v_uom, item_id => 0, uom_rate => l_eq_it_v_uom_ratio);
13331: IF l_eq_it_v_uom_ratio = -99999 THEN -- uom conversion failure
13332: fnd_message.set_name('INV', 'INV_INT_UOMCONVCODE');
13333: fnd_msg_pub.ADD;
13334:
13335: IF (l_debug = 1) THEN
13336: print_debug('split_task 70 - eqp/item volume uom ratio calculation failed' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
13337: END IF;
13339: -- get the conversion ratio between equipment and item weight UOM
13340: inv_convert.inv_um_conversion(from_unit => l_equip_w_uom, to_unit => l_item_w_uom, item_id => 0, uom_rate => l_eq_it_w_uom_ratio);
13341: IF l_eq_it_w_uom_ratio = -99999 THEN -- uom conversion failure
13342: fnd_message.set_name('INV', 'INV_INT_UOMCONVCODE');
13343: fnd_msg_pub.ADD;
13344:
13345: IF (l_debug = 1) THEN
13346: print_debug('split_task 70 - eqp/item weight uom ratio calculation failed' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
13347: END IF;
13508: l_progress := '100';
13509:
13510: IF l_min_cap = -1 THEN -- min capcity is not properly queried
13511: fnd_message.set_name('WMS', 'WMS_INVALID_CAP_DEF');
13512: fnd_msg_pub.ADD;
13513:
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;
13530: END IF;
13531:
13532: IF (l_split_factor <= 0 OR l_split_factor IS NULL) THEN -- min capcity is not properly queried bug# 9479006
13533: fnd_message.set_name('WMS', 'WMS_INVALID_CAP_DEF');
13534: fnd_msg_pub.ADD;
13535:
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;
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. '
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;
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;