[Home] [Help]
3185: -- This API is query only, therefore does not create a save point
3186:
3187: -- Initialize message list if p_init_msg_list is set to TRUE.
3188: IF fnd_api.to_boolean(p_init_msg_list) THEN
3189: fnd_msg_pub.initialize;
3190: END IF;
3191:
3192: -- Initialize API return status to success
3193: x_return_status := fnd_api.g_ret_sts_success;
3543: RAISE fnd_api.g_exc_unexpected_error;
3544: END IF;
3545: IF l_locked_lpns = l_total_lpns THEN
3546: fnd_message.set_name('WMS', 'WMS_TASK_NO_ELIGIBLE_TASKS');
3547: fnd_msg_pub.ADD;
3548:
3549: IF (l_debug = 1) THEN
3550: print_debug('dispatch_task - No eligible picking tasks ', 4);
3551: END IF;
3998: -- End bug fix 2832818
3999:
4000: IF l_task_id IS NULL AND p_task_method <> 'CLUSTERPICKBYLABEL' THEN --Bug 7254397
4001: fnd_message.set_name('WMS', 'WMS_TASK_NO_ELIGIBLE_TASKS');
4002: fnd_msg_pub.ADD;
4003:
4004: IF (l_debug = 1) THEN
4005: print_debug('dispatch_task - No eligible picking tasks ', 4);
4006: END IF;
4237: END IF;
4238:
4239: IF l_ordered_tasks_count = 0 THEN
4240: fnd_message.set_name('WMS', 'WMS_TASK_NO_ELIGIBLE_TASKS');
4241: fnd_msg_pub.ADD;
4242:
4243: IF (l_debug = 1) THEN
4244: print_debug('dispatch_task - No eligible picking tasks ', 4);
4245: END IF;
4292: IF l_curs_ordered_tasks_10%ISOPEN THEN
4293: CLOSE l_curs_ordered_tasks_10;
4294: END IF;
4295:
4296: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
4297:
4298: IF (l_debug = 1) THEN
4299: print_debug('dispatch_task: FND_API.g_exc_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
4300: END IF;
4312: IF l_curs_ordered_tasks_10%ISOPEN THEN
4313: CLOSE l_curs_ordered_tasks_10;
4314: END IF;
4315:
4316: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
4317:
4318: IF (l_debug = 1) THEN
4319: print_debug('dispatch_task: fnd_api.g_exc_unexpected_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
4320: END IF;
4336: IF SQLCODE IS NOT NULL THEN
4337: inv_mobile_helper_functions.sql_error('WMS_Task_Dispatch_Engine.dispatch_task', l_progress, SQLCODE);
4338: END IF;
4339:
4340: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
4341:
4342: IF (l_debug = 1) THEN
4343: print_debug('dispatch_task: Other exception: ' || Sqlerrm || l_progress, 1);
4344: END IF;
6254: -- This API is query only, therefore does not create a save point
6255:
6256: -- Initialize message list if p_init_msg_list is set to TRUE.
6257: IF fnd_api.to_boolean(p_init_msg_list) THEN
6258: fnd_msg_pub.initialize;
6259: END IF;
6260:
6261: -- Initialize API return status to success
6262: x_return_status := fnd_api.g_ret_sts_success;
6789: -- End bug fix 2832818
6790:
6791: IF l_opt_task_id IS NULL THEN
6792: fnd_message.set_name('WMS', 'WMS_TASK_NO_ELIGIBLE_TASKS');
6793: fnd_msg_pub.ADD;
6794:
6795: IF (l_debug = 1) THEN
6796: print_debug('dispatch_task - No eligible picking tasks ', 4);
6797: END IF;
7055: END IF;
7056:
7057: IF l_ordered_tasks_count = 0 THEN
7058: fnd_message.set_name('WMS', 'WMS_TASK_NO_ELIGIBLE_TASKS');
7059: fnd_msg_pub.ADD;
7060:
7061: IF (l_debug = 1) THEN
7062: print_debug('dispatch_task - No eligible picking tasks ', 4);
7063: END IF;
7142: IF l_curs_ordered_tasks_aw_exp%ISOPEN THEN
7143: CLOSE l_curs_ordered_tasks_aw_exp;
7144: END IF;
7145:
7146: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
7147:
7148: IF (l_debug = 1) THEN
7149: print_debug('dispatch_task: FND_API.g_exc_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
7150: END IF;
7166: IF l_curs_ordered_tasks_aw_exp%ISOPEN THEN
7167: CLOSE l_curs_ordered_tasks_aw_exp;
7168: END IF;
7169:
7170: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
7171:
7172: IF (l_debug = 1) THEN
7173: print_debug('dispatch_task: fnd_api.g_exc_unexpected_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
7174: END IF;
7194: IF SQLCODE IS NOT NULL THEN
7195: inv_mobile_helper_functions.sql_error('WMS_Task_Dispatch_Engine.dispatch_task', l_progress, SQLCODE);
7196: END IF;
7197:
7198: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
7199:
7200: IF (l_debug = 1) THEN
7201: print_debug('dispatch_task: Other exception ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
7202: END IF;
9818:
9819: -- This API is query only, therefore does not create a save point
9820: -- Initialize message list if p_init_msg_list is set to TRUE.
9821: IF fnd_api.to_boolean(p_init_msg_list) THEN
9822: fnd_msg_pub.initialize;
9823: END IF;
9824:
9825: -- Initialize API return status to success
9826: x_return_status := fnd_api.g_ret_sts_success;
10623: END IF;
10624:
10625: IF l_ordered_tasks_count = 0 THEN
10626: fnd_message.set_name('WMS', 'WMS_TASK_NO_ELIGIBLE_TASKS');
10627: fnd_msg_pub.ADD;
10628:
10629: IF (l_debug = 1) THEN
10630: print_debug('dispatch_task - No eligible picking tasks ', 4);
10631: END IF;
10680: IF l_cp_curs_ordered_tasks_no_sub%ISOPEN THEN -- bug 2648133
10681: CLOSE l_cp_curs_ordered_tasks_no_sub;
10682: END IF;
10683:
10684: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
10685:
10686: IF (l_debug = 1) THEN
10687: print_debug('dispatch_task: FND_API.g_exc_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
10688: END IF;
10696: IF l_cp_curs_ordered_tasks_no_sub%ISOPEN THEN -- bug 2648133
10697: CLOSE l_cp_curs_ordered_tasks_no_sub;
10698: END IF;
10699:
10700: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
10701:
10702: IF (l_debug = 1) THEN
10703: print_debug('dispatch_task: fnd_api.g_exc_unexpected_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
10704: END IF;
10716: IF SQLCODE IS NOT NULL THEN
10717: inv_mobile_helper_functions.sql_error('WMS_Task_Dispatch_Engine.dispatch_task', l_progress, SQLCODE);
10718: END IF;
10719:
10720: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
10721:
10722: IF (l_debug = 1) THEN
10723: print_debug('dispatch_task: Other exception ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
10724: END IF;
10861: END IF;
10862: EXCEPTION
10863: WHEN fnd_api.g_exc_error THEN
10864: x_return_status := fnd_api.g_ret_sts_error;
10865: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
10866:
10867: IF (l_debug = 1) THEN
10868: print_debug('split_tasks: FND_API.g_exc_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
10869: END IF;
10868: print_debug('split_tasks: FND_API.g_exc_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
10869: END IF;
10870: WHEN fnd_api.g_exc_unexpected_error THEN
10871: x_return_status := fnd_api.g_ret_sts_unexp_error;
10872: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
10873:
10874: IF (l_debug = 1) THEN
10875: print_debug('split_tasks: fnd_api.g_exc_unexpected_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
10876: END IF;
10880: IF SQLCODE IS NOT NULL THEN
10881: inv_mobile_helper_functions.sql_error('WMS_Task_Dispatch_Engine.split_tasks', l_progress, SQLCODE);
10882: END IF;
10883:
10884: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
10885:
10886: IF (l_debug = 1) THEN
10887: print_debug('split_tasks: Other exception ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
10888: END IF;
11614: END IF;
11615: IF task_list_wip%ISOPEN THEN
11616: CLOSE task_list_wip;
11617: END IF;
11618: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
11619: END consolidate_bulk_tasks;
11620:
11621:
11622:
12341: IF (l_debug = 1) THEN
12342: print_debug('Number of Parent Tasks = ' || l_parent_task_count, 4);
12343: print_debug('Number of child lines processed = ' || l_total_child_count,4);
12344: END IF;
12345: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
12346: EXCEPTION
12347: WHEN OTHERS THEN
12348: x_return_status := fnd_api.g_ret_sts_unexp_error;
12349: ROLLBACK TO sp_consolidate_bulk_task;
12364: IF task_list_con_cd%ISOPEN THEN
12365: CLOSE task_list_con_cd;
12366: END IF;
12367:
12368: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
12369: END consolidate_bulk_tasks_for_so;
12370:
12371: --------- patchset J bulk picking -----------------
12372: -- This procedure will be called inside the split_task API. It will be called after stamping the parent_line_id
12441:
12442: END IF;
12443:
12444:
12445: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
12446:
12447: EXCEPTION
12448: WHEN OTHERS THEN
12449: x_return_status := fnd_api.g_ret_sts_unexp_error;
12451: IF l_debug = 1 THEN
12452: print_debug('Exception Occurred = ' || SQLERRM,4);
12453: END IF;
12454:
12455: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
12456:
12457: END Duplicate_lot_serial_in_parent;
12458:
12459: ----- end of patchset J bulk picking ------------------------------------
12708: , uom_rate => l_loc_txn_uom_ratio);
12709:
12710: IF l_loc_txn_uom_ratio = -99999 THEN -- uom conversion failure
12711: fnd_message.set_name('INV', 'INV_INT_UOMCONVCODE');
12712: fnd_msg_pub.ADD;
12713:
12714: IF (l_debug = 1) THEN
12715: print_debug('split_task 40 - loc/item uom ratio calculation failed' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
12716: END IF;
12723: , uom_rate => l_txn_pri_uom_ratio);
12724:
12725: IF l_txn_pri_uom_ratio = -99999 THEN -- uom conversion failure
12726: fnd_message.set_name('INV', 'INV_INT_UOMCONVCODE');
12727: fnd_msg_pub.ADD;
12728:
12729: IF (l_debug = 1) THEN
12730: print_debug('split_task 50 - txn/item uom ratio calculation failed' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
12731: END IF;
12776: -- get the conversion ratio between equipment and item volume UOM
12777: 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);
12778: IF l_eq_it_v_uom_ratio = -99999 THEN -- uom conversion failure
12779: fnd_message.set_name('INV', 'INV_INT_UOMCONVCODE');
12780: fnd_msg_pub.ADD;
12781:
12782: IF (l_debug = 1) THEN
12783: print_debug('split_task 70 - eqp/item volume uom ratio calculation failed' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
12784: END IF;
12786: -- get the conversion ratio between equipment and item weight UOM
12787: 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);
12788: IF l_eq_it_w_uom_ratio = -99999 THEN -- uom conversion failure
12789: fnd_message.set_name('INV', 'INV_INT_UOMCONVCODE');
12790: fnd_msg_pub.ADD;
12791:
12792: IF (l_debug = 1) THEN
12793: print_debug('split_task 70 - eqp/item weight uom ratio calculation failed' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
12794: END IF;
12882: l_progress := '100';
12883:
12884: IF l_min_cap = -1 THEN -- min capcity is not properly queried
12885: fnd_message.set_name('WMS', 'WMS_INVALID_CAP_DEF');
12886: fnd_msg_pub.ADD;
12887:
12888: IF (l_debug = 1) THEN
12889: print_debug('split_task 90 - invalid capacity for a ALL equipment' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
12890: END IF;
12904: END IF;
12905:
12906: IF l_split_factor <= 0 THEN -- min capcity is not properly queried
12907: fnd_message.set_name('WMS', 'WMS_INVALID_CAP_DEF');
12908: fnd_msg_pub.ADD;
12909:
12910: IF (l_debug = 1) THEN
12911: print_debug('split_task 95 - minimum capacity 0' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
12912: END IF;
13189: EXCEPTION
13190: WHEN fnd_api.g_exc_error THEN
13191: x_return_status := fnd_api.g_ret_sts_error;
13192: ROLLBACK TO sp_task_split;
13193: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
13194:
13195: IF (l_debug = 1) THEN
13196: print_debug(
13197: 'split_task: Raise expected exception. But the task generation process should continue processing, only that tasks are not split according to equipment capacity. '
13224:
13225: WHEN fnd_api.g_exc_unexpected_error THEN
13226: x_return_status := fnd_api.g_ret_sts_unexp_error;
13227: ROLLBACK TO sp_task_split;
13228: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
13229:
13230: IF (l_debug = 1) THEN
13231: print_debug('split_task: fnd_api.g_exc_unexpected_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
13232: END IF;
13237: IF SQLCODE IS NOT NULL THEN
13238: inv_mobile_helper_functions.sql_error('WMS_Task_Dispatch_Engine.split_task', l_progress, SQLCODE);
13239: END IF;
13240:
13241: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
13242:
13243: IF (l_debug = 1) THEN
13244: print_debug('split_task: Other exception ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
13245: END IF;