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: -- bug 4358107
168: -- APL procedure: Used since 11.5.10

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

167: -- bug 4358107
168: -- APL procedure: Used since 11.5.10
169: PROCEDURE dispatch_task
170: (p_api_version IN NUMBER,
171: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
172: p_commit IN VARCHAR2 := fnd_api.g_false,
173: p_sign_on_emp_id IN NUMBER,
174: p_sign_on_org_id IN NUMBER,
175: p_sign_on_zone IN VARCHAR2 := NULL,

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

168: -- APL procedure: Used since 11.5.10
169: PROCEDURE dispatch_task
170: (p_api_version IN NUMBER,
171: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
172: p_commit IN VARCHAR2 := fnd_api.g_false,
173: p_sign_on_emp_id IN NUMBER,
174: p_sign_on_org_id IN NUMBER,
175: p_sign_on_zone IN VARCHAR2 := NULL,
176: p_sign_on_equipment_id IN NUMBER := NULL, -- specific equip idNULL or -999. -999 stands for none

Line 3188: IF fnd_api.to_boolean(p_init_msg_list) THEN

3184:
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

Line 3193: x_return_status := fnd_api.g_ret_sts_success;

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;
3194:
3195: -- API body
3196: -- preprocess input parameters
3197:

Line 3540: IF l_return_status = fnd_api.g_ret_sts_error THEN

3536: IF l_debug = 1 THEN
3537: print_debug('Return Status after the call to store_locked_tasks ' || l_return_status ||' p_task_method ' || p_task_method, 4);
3538: END IF;
3539:
3540: IF l_return_status = fnd_api.g_ret_sts_error THEN
3541: RAISE fnd_api.g_exc_error;
3542: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3543: RAISE fnd_api.g_exc_unexpected_error;
3544: END IF;

Line 3541: RAISE fnd_api.g_exc_error;

3537: print_debug('Return Status after the call to store_locked_tasks ' || l_return_status ||' p_task_method ' || p_task_method, 4);
3538: END IF;
3539:
3540: IF l_return_status = fnd_api.g_ret_sts_error THEN
3541: RAISE fnd_api.g_exc_error;
3542: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3543: RAISE fnd_api.g_exc_unexpected_error;
3544: END IF;
3545: IF l_locked_lpns = l_total_lpns THEN

Line 3542: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

3538: END IF;
3539:
3540: IF l_return_status = fnd_api.g_ret_sts_error THEN
3541: RAISE fnd_api.g_exc_error;
3542: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
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');

Line 3543: RAISE fnd_api.g_exc_unexpected_error;

3539:
3540: IF l_return_status = fnd_api.g_ret_sts_error THEN
3541: RAISE fnd_api.g_exc_error;
3542: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
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;

Line 3552: RAISE fnd_api.g_exc_error;

3548:
3549: IF (l_debug = 1) THEN
3550: print_debug('dispatch_task - No eligible picking tasks ', 4);
3551: END IF;
3552: RAISE fnd_api.g_exc_error;
3553: END IF;
3554: l_return_status := fnd_api.g_ret_sts_success;
3555: END IF;
3556:

Line 3554: l_return_status := fnd_api.g_ret_sts_success;

3550: print_debug('dispatch_task - No eligible picking tasks ', 4);
3551: END IF;
3552: RAISE fnd_api.g_exc_error;
3553: END IF;
3554: l_return_status := fnd_api.g_ret_sts_success;
3555: END IF;
3556:
3557: IF c_carton_lock_check%isopen THEN
3558: CLOSE c_carton_lock_check;

Line 3745: IF l_return_status = fnd_api.g_ret_sts_error THEN

3741: IF l_debug = 1 THEN
3742: print_debug('Return Status after the call to store_locked_tasks ' || l_return_status ||' p_task_method ' || p_task_method, 4);
3743: END IF;
3744:
3745: IF l_return_status = fnd_api.g_ret_sts_error THEN
3746: RAISE fnd_api.g_exc_error;
3747: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3748: RAISE fnd_api.g_exc_unexpected_error;
3749: END IF;

Line 3746: RAISE fnd_api.g_exc_error;

3742: print_debug('Return Status after the call to store_locked_tasks ' || l_return_status ||' p_task_method ' || p_task_method, 4);
3743: END IF;
3744:
3745: IF l_return_status = fnd_api.g_ret_sts_error THEN
3746: RAISE fnd_api.g_exc_error;
3747: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3748: RAISE fnd_api.g_exc_unexpected_error;
3749: END IF;
3750: l_return_status := fnd_api.g_ret_sts_success;

Line 3747: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

3743: END IF;
3744:
3745: IF l_return_status = fnd_api.g_ret_sts_error THEN
3746: RAISE fnd_api.g_exc_error;
3747: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3748: RAISE fnd_api.g_exc_unexpected_error;
3749: END IF;
3750: l_return_status := fnd_api.g_ret_sts_success;
3751: -- bug 4358107

Line 3748: RAISE fnd_api.g_exc_unexpected_error;

3744:
3745: IF l_return_status = fnd_api.g_ret_sts_error THEN
3746: RAISE fnd_api.g_exc_error;
3747: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3748: RAISE fnd_api.g_exc_unexpected_error;
3749: END IF;
3750: l_return_status := fnd_api.g_ret_sts_success;
3751: -- bug 4358107
3752:

Line 3750: l_return_status := fnd_api.g_ret_sts_success;

3746: RAISE fnd_api.g_exc_error;
3747: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3748: RAISE fnd_api.g_exc_unexpected_error;
3749: END IF;
3750: l_return_status := fnd_api.g_ret_sts_success;
3751: -- bug 4358107
3752:
3753: END IF;
3754:

Line 3795: IF l_return_status = fnd_api.g_ret_sts_error THEN

3791: IF l_debug = 1 THEN
3792: print_debug('Return Status after the call to store_locked_tasks ' || l_return_status ||' p_task_method ' || p_task_method, 4);
3793: END IF;
3794:
3795: IF l_return_status = fnd_api.g_ret_sts_error THEN
3796: RAISE fnd_api.g_exc_error;
3797: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3798: RAISE fnd_api.g_exc_unexpected_error;
3799: END IF;

Line 3796: RAISE fnd_api.g_exc_error;

3792: print_debug('Return Status after the call to store_locked_tasks ' || l_return_status ||' p_task_method ' || p_task_method, 4);
3793: END IF;
3794:
3795: IF l_return_status = fnd_api.g_ret_sts_error THEN
3796: RAISE fnd_api.g_exc_error;
3797: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3798: RAISE fnd_api.g_exc_unexpected_error;
3799: END IF;
3800: l_return_status := fnd_api.g_ret_sts_success;

Line 3797: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

3793: END IF;
3794:
3795: IF l_return_status = fnd_api.g_ret_sts_error THEN
3796: RAISE fnd_api.g_exc_error;
3797: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3798: RAISE fnd_api.g_exc_unexpected_error;
3799: END IF;
3800: l_return_status := fnd_api.g_ret_sts_success;
3801: -- bug 4358107

Line 3798: RAISE fnd_api.g_exc_unexpected_error;

3794:
3795: IF l_return_status = fnd_api.g_ret_sts_error THEN
3796: RAISE fnd_api.g_exc_error;
3797: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3798: RAISE fnd_api.g_exc_unexpected_error;
3799: END IF;
3800: l_return_status := fnd_api.g_ret_sts_success;
3801: -- bug 4358107
3802:

Line 3800: l_return_status := fnd_api.g_ret_sts_success;

3796: RAISE fnd_api.g_exc_error;
3797: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3798: RAISE fnd_api.g_exc_unexpected_error;
3799: END IF;
3800: l_return_status := fnd_api.g_ret_sts_success;
3801: -- bug 4358107
3802:
3803: END IF;
3804:

Line 3842: IF l_return_status = fnd_api.g_ret_sts_error THEN

3838: IF l_debug = 1 THEN
3839: print_debug('Return Status after the call to store_locked_tasks ' || l_return_status ||' p_task_method ' || p_task_method, 4);
3840: END IF;
3841:
3842: IF l_return_status = fnd_api.g_ret_sts_error THEN
3843: RAISE fnd_api.g_exc_error;
3844: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3845: RAISE fnd_api.g_exc_unexpected_error;
3846: END IF;

Line 3843: RAISE fnd_api.g_exc_error;

3839: print_debug('Return Status after the call to store_locked_tasks ' || l_return_status ||' p_task_method ' || p_task_method, 4);
3840: END IF;
3841:
3842: IF l_return_status = fnd_api.g_ret_sts_error THEN
3843: RAISE fnd_api.g_exc_error;
3844: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3845: RAISE fnd_api.g_exc_unexpected_error;
3846: END IF;
3847: l_return_status := fnd_api.g_ret_sts_success;

Line 3844: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

3840: END IF;
3841:
3842: IF l_return_status = fnd_api.g_ret_sts_error THEN
3843: RAISE fnd_api.g_exc_error;
3844: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3845: RAISE fnd_api.g_exc_unexpected_error;
3846: END IF;
3847: l_return_status := fnd_api.g_ret_sts_success;
3848: -- bug 4358107

Line 3845: RAISE fnd_api.g_exc_unexpected_error;

3841:
3842: IF l_return_status = fnd_api.g_ret_sts_error THEN
3843: RAISE fnd_api.g_exc_error;
3844: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3845: RAISE fnd_api.g_exc_unexpected_error;
3846: END IF;
3847: l_return_status := fnd_api.g_ret_sts_success;
3848: -- bug 4358107
3849:

Line 3847: l_return_status := fnd_api.g_ret_sts_success;

3843: RAISE fnd_api.g_exc_error;
3844: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3845: RAISE fnd_api.g_exc_unexpected_error;
3846: END IF;
3847: l_return_status := fnd_api.g_ret_sts_success;
3848: -- bug 4358107
3849:
3850: END IF;
3851:

Line 3963: IF l_return_status = fnd_api.g_ret_sts_error THEN

3959: IF l_debug = 1 THEN
3960: print_debug('Return Status after the call to store_locked_tasks ' || l_return_status ||' l_lpn_id :- '|| l_lpn_id, 4);
3961: END IF;
3962:
3963: IF l_return_status = fnd_api.g_ret_sts_error THEN
3964: RAISE fnd_api.g_exc_error;
3965: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3966: RAISE fnd_api.g_exc_unexpected_error;
3967: END IF;

Line 3964: RAISE fnd_api.g_exc_error;

3960: print_debug('Return Status after the call to store_locked_tasks ' || l_return_status ||' l_lpn_id :- '|| l_lpn_id, 4);
3961: END IF;
3962:
3963: IF l_return_status = fnd_api.g_ret_sts_error THEN
3964: RAISE fnd_api.g_exc_error;
3965: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3966: RAISE fnd_api.g_exc_unexpected_error;
3967: END IF;
3968: l_return_status := fnd_api.g_ret_sts_success;

Line 3965: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

3961: END IF;
3962:
3963: IF l_return_status = fnd_api.g_ret_sts_error THEN
3964: RAISE fnd_api.g_exc_error;
3965: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3966: RAISE fnd_api.g_exc_unexpected_error;
3967: END IF;
3968: l_return_status := fnd_api.g_ret_sts_success;
3969:

Line 3966: RAISE fnd_api.g_exc_unexpected_error;

3962:
3963: IF l_return_status = fnd_api.g_ret_sts_error THEN
3964: RAISE fnd_api.g_exc_error;
3965: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3966: RAISE fnd_api.g_exc_unexpected_error;
3967: END IF;
3968: l_return_status := fnd_api.g_ret_sts_success;
3969:
3970: IF l_debug = 1 THEN

Line 3968: l_return_status := fnd_api.g_ret_sts_success;

3964: RAISE fnd_api.g_exc_error;
3965: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3966: RAISE fnd_api.g_exc_unexpected_error;
3967: END IF;
3968: l_return_status := fnd_api.g_ret_sts_success;
3969:
3970: IF l_debug = 1 THEN
3971: print_debug('cartonized tasks end',4);
3972: END IF;

Line 4008: RAISE fnd_api.g_exc_error;

4004: IF (l_debug = 1) THEN
4005: print_debug('dispatch_task - No eligible picking tasks ', 4);
4006: END IF;
4007:
4008: RAISE fnd_api.g_exc_error;
4009: END IF;
4010:
4011: IF p_task_method <> 'ORDERPICK' THEN
4012: l_transaction_source_id := NULL;

Line 4219: IF l_return_status = fnd_api.g_ret_sts_error THEN

4215: remove_stored_cartons(x_return_status => l_return_status);
4216: IF l_debug = 1 THEN
4217: print_debug('Return Status after the call to remove_locked_tasks ' || l_return_status ||' p_task_method ' || p_task_method, 4);
4218: END IF;
4219: IF l_return_status = fnd_api.g_ret_sts_error THEN
4220: RAISE fnd_api.g_exc_error;
4221: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4222: RAISE fnd_api.g_exc_unexpected_error;
4223: END IF;

Line 4220: RAISE fnd_api.g_exc_error;

4216: IF l_debug = 1 THEN
4217: print_debug('Return Status after the call to remove_locked_tasks ' || l_return_status ||' p_task_method ' || p_task_method, 4);
4218: END IF;
4219: IF l_return_status = fnd_api.g_ret_sts_error THEN
4220: RAISE fnd_api.g_exc_error;
4221: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4222: RAISE fnd_api.g_exc_unexpected_error;
4223: END IF;
4224: l_return_status := fnd_api.g_ret_sts_success;

Line 4221: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

4217: print_debug('Return Status after the call to remove_locked_tasks ' || l_return_status ||' p_task_method ' || p_task_method, 4);
4218: END IF;
4219: IF l_return_status = fnd_api.g_ret_sts_error THEN
4220: RAISE fnd_api.g_exc_error;
4221: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4222: RAISE fnd_api.g_exc_unexpected_error;
4223: END IF;
4224: l_return_status := fnd_api.g_ret_sts_success;
4225: END IF;--Bug 7254397: Clear ...GTMP table end

Line 4222: RAISE fnd_api.g_exc_unexpected_error;

4218: END IF;
4219: IF l_return_status = fnd_api.g_ret_sts_error THEN
4220: RAISE fnd_api.g_exc_error;
4221: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4222: RAISE fnd_api.g_exc_unexpected_error;
4223: END IF;
4224: l_return_status := fnd_api.g_ret_sts_success;
4225: END IF;--Bug 7254397: Clear ...GTMP table end
4226:

Line 4224: l_return_status := fnd_api.g_ret_sts_success;

4220: RAISE fnd_api.g_exc_error;
4221: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4222: RAISE fnd_api.g_exc_unexpected_error;
4223: END IF;
4224: l_return_status := fnd_api.g_ret_sts_success;
4225: END IF;--Bug 7254397: Clear ...GTMP table end
4226:
4227: IF l_non_cc_allowed = 1 AND l_cc_allowed = 1 THEN
4228: CLOSE l_curs_ordered_tasks_11;

Line 4247: RAISE fnd_api.g_exc_error;

4243: IF (l_debug = 1) THEN
4244: print_debug('dispatch_task - No eligible picking tasks ', 4);
4245: END IF;
4246:
4247: RAISE fnd_api.g_exc_error;
4248: END IF;
4249:
4250: l_progress := '90';
4251:

Line 4281: WHEN fnd_api.g_exc_error THEN

4277: ORDER BY task_sequence_id;
4278:
4279: l_progress := '120';
4280: EXCEPTION
4281: WHEN fnd_api.g_exc_error THEN
4282: x_return_status := fnd_api.g_ret_sts_error;
4283:
4284: IF l_curs_ordered_tasks_11%ISOPEN THEN
4285: CLOSE l_curs_ordered_tasks_11;

Line 4282: x_return_status := fnd_api.g_ret_sts_error;

4278:
4279: l_progress := '120';
4280: EXCEPTION
4281: WHEN fnd_api.g_exc_error THEN
4282: x_return_status := fnd_api.g_ret_sts_error;
4283:
4284: IF l_curs_ordered_tasks_11%ISOPEN THEN
4285: CLOSE l_curs_ordered_tasks_11;
4286: END IF;

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

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;

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

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;
4301: WHEN fnd_api.g_exc_unexpected_error THEN
4302: x_return_status := fnd_api.g_ret_sts_unexp_error;
4303:

Line 4301: WHEN fnd_api.g_exc_unexpected_error THEN

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;
4301: WHEN fnd_api.g_exc_unexpected_error THEN
4302: x_return_status := fnd_api.g_ret_sts_unexp_error;
4303:
4304: IF l_curs_ordered_tasks_11%ISOPEN THEN
4305: CLOSE l_curs_ordered_tasks_11;

Line 4302: x_return_status := fnd_api.g_ret_sts_unexp_error;

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;
4301: WHEN fnd_api.g_exc_unexpected_error THEN
4302: x_return_status := fnd_api.g_ret_sts_unexp_error;
4303:
4304: IF l_curs_ordered_tasks_11%ISOPEN THEN
4305: CLOSE l_curs_ordered_tasks_11;
4306: END IF;

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

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;

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

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;
4321: WHEN OTHERS THEN
4322: x_return_status := fnd_api.g_ret_sts_unexp_error;
4323:

Line 4322: x_return_status := fnd_api.g_ret_sts_unexp_error;

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;
4321: WHEN OTHERS THEN
4322: x_return_status := fnd_api.g_ret_sts_unexp_error;
4323:
4324: IF l_curs_ordered_tasks_11%ISOPEN THEN
4325: CLOSE l_curs_ordered_tasks_11;
4326: END IF;

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

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;

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

4348: -- Old procedure: Not used from 11.5.10
4349:
4350: PROCEDURE dispatch_task(
4351: p_api_version IN NUMBER
4352: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
4353: , p_commit IN VARCHAR2 := fnd_api.g_false
4354: , p_sign_on_emp_id IN NUMBER
4355: , p_sign_on_org_id IN NUMBER
4356: , p_sign_on_zone IN VARCHAR2 := NULL

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

4349:
4350: PROCEDURE dispatch_task(
4351: p_api_version IN NUMBER
4352: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
4353: , p_commit IN VARCHAR2 := fnd_api.g_false
4354: , p_sign_on_emp_id IN NUMBER
4355: , p_sign_on_org_id IN NUMBER
4356: , p_sign_on_zone IN VARCHAR2 := NULL
4357: , p_sign_on_equipment_id IN NUMBER := NULL -- specific equip id, NULL or -999. -999 stands for none

Line 6257: IF fnd_api.to_boolean(p_init_msg_list) THEN

6253:
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

Line 6262: x_return_status := fnd_api.g_ret_sts_success;

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;
6263: -- API body
6264: -- preprocess input parameters
6265:
6266: fnd_profile.get('WMS_SEQUENCE_PICKS_ACROSS_WAVES', l_sequence_picks_across_waves);

Line 6799: RAISE fnd_api.g_exc_error;

6795: IF (l_debug = 1) THEN
6796: print_debug('dispatch_task - No eligible picking tasks ', 4);
6797: END IF;
6798:
6799: RAISE fnd_api.g_exc_error;
6800: END IF;
6801:
6802: IF l_sequence_picks_across_waves = 2 THEN
6803: IF l_is_express_pick <> 1 THEN

Line 7065: RAISE fnd_api.g_exc_error;

7061: IF (l_debug = 1) THEN
7062: print_debug('dispatch_task - No eligible picking tasks ', 4);
7063: END IF;
7064:
7065: RAISE fnd_api.g_exc_error;
7066: END IF;
7067:
7068: l_progress := '90';
7069: -- bug 2648133, inlined wms_dispatchable_tasks_v

Line 7127: WHEN fnd_api.g_exc_error THEN

7123: END IF;
7124:
7125: l_progress := '120';
7126: EXCEPTION
7127: WHEN fnd_api.g_exc_error THEN
7128: x_return_status := fnd_api.g_ret_sts_error;
7129:
7130: IF l_curs_ordered_tasks%ISOPEN THEN
7131: CLOSE l_curs_ordered_tasks;

Line 7128: x_return_status := fnd_api.g_ret_sts_error;

7124:
7125: l_progress := '120';
7126: EXCEPTION
7127: WHEN fnd_api.g_exc_error THEN
7128: x_return_status := fnd_api.g_ret_sts_error;
7129:
7130: IF l_curs_ordered_tasks%ISOPEN THEN
7131: CLOSE l_curs_ordered_tasks;
7132: END IF;

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

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;

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

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;
7151: WHEN fnd_api.g_exc_unexpected_error THEN
7152: x_return_status := fnd_api.g_ret_sts_unexp_error;
7153:

Line 7151: WHEN fnd_api.g_exc_unexpected_error THEN

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;
7151: WHEN fnd_api.g_exc_unexpected_error THEN
7152: x_return_status := fnd_api.g_ret_sts_unexp_error;
7153:
7154: IF l_curs_ordered_tasks%ISOPEN THEN
7155: CLOSE l_curs_ordered_tasks;

Line 7152: x_return_status := fnd_api.g_ret_sts_unexp_error;

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;
7151: WHEN fnd_api.g_exc_unexpected_error THEN
7152: x_return_status := fnd_api.g_ret_sts_unexp_error;
7153:
7154: IF l_curs_ordered_tasks%ISOPEN THEN
7155: CLOSE l_curs_ordered_tasks;
7156: END IF;

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

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;

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

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;
7175: WHEN OTHERS THEN
7176: x_return_status := fnd_api.g_ret_sts_unexp_error;
7177:

Line 7176: x_return_status := fnd_api.g_ret_sts_unexp_error;

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;
7175: WHEN OTHERS THEN
7176: x_return_status := fnd_api.g_ret_sts_unexp_error;
7177:
7178: IF l_curs_ordered_tasks%ISOPEN THEN
7179: CLOSE l_curs_ordered_tasks;
7180: END IF;

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

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;

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

7205: -- CP Enhancements
7206: -- This Method has been over-ridden for implementing the cluster picking task dispatch logic.
7207: PROCEDURE dispatch_task(
7208: p_api_version IN NUMBER
7209: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
7210: , p_commit IN VARCHAR2 := fnd_api.g_false
7211: , p_sign_on_emp_id IN NUMBER
7212: , p_sign_on_org_id IN NUMBER
7213: , p_sign_on_zone IN VARCHAR2 := NULL

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

7206: -- This Method has been over-ridden for implementing the cluster picking task dispatch logic.
7207: PROCEDURE dispatch_task(
7208: p_api_version IN NUMBER
7209: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
7210: , p_commit IN VARCHAR2 := fnd_api.g_false
7211: , p_sign_on_emp_id IN NUMBER
7212: , p_sign_on_org_id IN NUMBER
7213: , p_sign_on_zone IN VARCHAR2 := NULL
7214: , p_sign_on_equipment_id IN NUMBER := NULL -- specific equip id, NULL or -999. -999 stands for none

Line 9821: IF fnd_api.to_boolean(p_init_msg_list) THEN

9817: l_progress := '10';
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

Line 9826: x_return_status := fnd_api.g_ret_sts_success;

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;
9827:
9828: -- API body
9829: -- preprocess input parameters
9830:

Line 10633: RAISE fnd_api.g_exc_error;

10629: IF (l_debug = 1) THEN
10630: print_debug('dispatch_task - No eligible picking tasks ', 4);
10631: END IF;
10632:
10633: RAISE fnd_api.g_exc_error;
10634: END IF;
10635:
10636: l_progress := '90';
10637: END IF; -- end task type check if

Line 10673: WHEN fnd_api.g_exc_error THEN

10669: AND mmtt.transaction_temp_id > 0
10670: ORDER BY wot.task_sequence_id;
10671: l_progress := '120';
10672: EXCEPTION
10673: WHEN fnd_api.g_exc_error THEN
10674: x_return_status := fnd_api.g_ret_sts_error;
10675:
10676: IF l_cp_curs_ordered_tasks%ISOPEN THEN
10677: CLOSE l_cp_curs_ordered_tasks;

Line 10674: x_return_status := fnd_api.g_ret_sts_error;

10670: ORDER BY wot.task_sequence_id;
10671: l_progress := '120';
10672: EXCEPTION
10673: WHEN fnd_api.g_exc_error THEN
10674: x_return_status := fnd_api.g_ret_sts_error;
10675:
10676: IF l_cp_curs_ordered_tasks%ISOPEN THEN
10677: CLOSE l_cp_curs_ordered_tasks;
10678: END IF;

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

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;

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

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;
10689: WHEN fnd_api.g_exc_unexpected_error THEN
10690: x_return_status := fnd_api.g_ret_sts_unexp_error;
10691:

Line 10689: WHEN fnd_api.g_exc_unexpected_error THEN

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;
10689: WHEN fnd_api.g_exc_unexpected_error THEN
10690: x_return_status := fnd_api.g_ret_sts_unexp_error;
10691:
10692: IF l_cp_curs_ordered_tasks%ISOPEN THEN
10693: CLOSE l_cp_curs_ordered_tasks;

Line 10690: x_return_status := fnd_api.g_ret_sts_unexp_error;

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;
10689: WHEN fnd_api.g_exc_unexpected_error THEN
10690: x_return_status := fnd_api.g_ret_sts_unexp_error;
10691:
10692: IF l_cp_curs_ordered_tasks%ISOPEN THEN
10693: CLOSE l_cp_curs_ordered_tasks;
10694: END IF;

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

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;

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

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;
10705: WHEN OTHERS THEN
10706: x_return_status := fnd_api.g_ret_sts_unexp_error;
10707:

Line 10706: x_return_status := fnd_api.g_ret_sts_unexp_error;

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;
10705: WHEN OTHERS THEN
10706: x_return_status := fnd_api.g_ret_sts_unexp_error;
10707:
10708: IF l_cp_curs_ordered_tasks%ISOPEN THEN
10709: CLOSE l_cp_curs_ordered_tasks;
10710: END IF;

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

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;

Line 10742: , p_commit VARCHAR2 := fnd_api.g_false

10738:
10739: PROCEDURE split_tasks(
10740: p_api_version NUMBER
10741: , p_move_order_header_id NUMBER
10742: , p_commit VARCHAR2 := fnd_api.g_false
10743: , x_return_status OUT NOCOPY VARCHAR2
10744: , x_msg_count OUT NOCOPY NUMBER
10745: , x_msg_data OUT NOCOPY VARCHAR2
10746: ) IS

Line 10775: x_return_status := fnd_api.g_ret_sts_success;

10771:
10772: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
10773: BEGIN
10774: -- Initialize API return status to success
10775: x_return_status := fnd_api.g_ret_sts_success;
10776:
10777: IF (l_debug = 1) THEN
10778: print_debug('Enter split_tasks 10 ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
10779: END IF;

Line 10833: IF l_return_status = fnd_api.g_ret_sts_error THEN

10829: , x_msg_count => l_msg_count
10830: , x_msg_data => l_msg_data
10831: );
10832:
10833: IF l_return_status = fnd_api.g_ret_sts_error THEN
10834: IF (l_debug = 1) THEN
10835: print_debug('split_tasks 30 - split_task RAISE FND_API.G_EXC_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
10836: END IF;
10837:

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

10831: );
10832:
10833: IF l_return_status = fnd_api.g_ret_sts_error THEN
10834: IF (l_debug = 1) THEN
10835: print_debug('split_tasks 30 - split_task RAISE FND_API.G_EXC_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
10836: END IF;
10837:
10838: -- RAISE fnd_api.g_exc_error;
10839: -- in case of error for one task, should continue for another task

Line 10838: -- RAISE fnd_api.g_exc_error;

10834: IF (l_debug = 1) THEN
10835: print_debug('split_tasks 30 - split_task RAISE FND_API.G_EXC_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
10836: END IF;
10837:
10838: -- RAISE fnd_api.g_exc_error;
10839: -- in case of error for one task, should continue for another task
10840: END IF;
10841:
10842: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 10842: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

10838: -- RAISE fnd_api.g_exc_error;
10839: -- in case of error for one task, should continue for another task
10840: END IF;
10841:
10842: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
10843: IF (l_debug = 1) THEN
10844: print_debug('split_tasks 40 - split_task RAISE FND_API.G_EXC_UNEXPECTED_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
10845: END IF;
10846:

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

10840: END IF;
10841:
10842: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
10843: IF (l_debug = 1) THEN
10844: print_debug('split_tasks 40 - split_task RAISE FND_API.G_EXC_UNEXPECTED_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
10845: END IF;
10846:
10847: RAISE fnd_api.g_exc_unexpected_error;
10848: END IF;

Line 10847: RAISE fnd_api.g_exc_unexpected_error;

10843: IF (l_debug = 1) THEN
10844: print_debug('split_tasks 40 - split_task RAISE FND_API.G_EXC_UNEXPECTED_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
10845: END IF;
10846:
10847: RAISE fnd_api.g_exc_unexpected_error;
10848: END IF;
10849: END LOOP;
10850:
10851: l_progress := '50';

Line 10863: WHEN fnd_api.g_exc_error THEN

10859: IF (l_debug = 1) THEN
10860: print_debug('split_tasks 50 complete' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
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

Line 10864: x_return_status := fnd_api.g_ret_sts_error;

10860: print_debug('split_tasks 50 complete' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
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);

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

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;

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

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;
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);

Line 10870: WHEN fnd_api.g_exc_unexpected_error THEN

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;
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

Line 10871: x_return_status := fnd_api.g_ret_sts_unexp_error;

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;
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);

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

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;

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

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;
10877: WHEN OTHERS THEN
10878: x_return_status := fnd_api.g_ret_sts_unexp_error;
10879:

Line 10878: x_return_status := fnd_api.g_ret_sts_unexp_error;

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;
10877: WHEN OTHERS THEN
10878: x_return_status := fnd_api.g_ret_sts_unexp_error;
10879:
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;

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

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;

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

11088:
11089:
11090: PROCEDURE consolidate_bulk_tasks(
11091: p_api_version IN NUMBER
11092: , p_commit IN VARCHAR2 := fnd_api.g_false
11093: , x_return_status OUT NOCOPY VARCHAR2
11094: , x_msg_count OUT NOCOPY NUMBER
11095: , x_msg_data OUT NOCOPY VARCHAR2
11096: , p_move_order_header_id IN NUMBER

Line 11336: x_return_status := fnd_api.g_ret_sts_success;

11332: END IF;
11333:
11334: SAVEPOINT sp_consolidate_bulk_task;
11335:
11336: x_return_status := fnd_api.g_ret_sts_success;
11337:
11338: SELECT move_order_type
11339: INTO l_move_order_type
11340: FROM mtl_txn_request_headers

Line 11606: x_return_status := fnd_api.g_ret_sts_unexp_error;

11602: print_debug('Number of Parent Tasks = ' || l_parent_task_count, 4);
11603: END IF;
11604: EXCEPTION
11605: WHEN OTHERS THEN
11606: x_return_status := fnd_api.g_ret_sts_unexp_error;
11607: ROLLBACK TO sp_consolidate_bulk_task;
11608: IF l_debug = 1 THEN
11609: print_debug('Exception Occurred = ' || SQLERRM,4);
11610: END IF;

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

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:

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

11621:
11622:
11623: PROCEDURE consolidate_bulk_tasks_for_so(
11624: p_api_version IN NUMBER
11625: , p_commit IN VARCHAR2 := fnd_api.g_false
11626: , x_return_status OUT NOCOPY VARCHAR2
11627: , x_msg_count OUT NOCOPY NUMBER
11628: , x_msg_data OUT NOCOPY VARCHAR2
11629: , p_move_order_header_id IN NUMBER

Line 11959: x_return_status := fnd_api.g_ret_sts_success;

11955:
11956: SAVEPOINT sp_consolidate_bulk_task;
11957:
11958:
11959: x_return_status := fnd_api.g_ret_sts_success;
11960:
11961: -- check if the delivery is checked in the bulk picking rule-------------
11962: IF p_move_order_header_id <> -1 THEN
11963:

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

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;

Line 12348: x_return_status := fnd_api.g_ret_sts_unexp_error;

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;
12350: IF l_debug = 1 THEN
12351: print_debug('Exception Occurred = ' || SQLERRM,4);
12352: END IF;

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

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

Line 12397: x_return_status := fnd_api.g_ret_sts_success;

12393: END IF;
12394:
12395:
12396: -- Initialize API return status to success
12397: x_return_status := fnd_api.g_ret_sts_success;
12398:
12399: -- to get the serial control code
12400: select serial_number_control_code,lot_control_code
12401: into l_serial_number_control_code,l_lot_control_code

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

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;

Line 12449: x_return_status := fnd_api.g_ret_sts_unexp_error;

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;
12450:
12451: IF l_debug = 1 THEN
12452: print_debug('Exception Occurred = ' || SQLERRM,4);
12453: END IF;

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

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 ------------------------------------

Line 12464: , p_commit VARCHAR2 := fnd_api.g_false

12460:
12461: PROCEDURE split_task(
12462: p_api_version NUMBER
12463: , p_task_id NUMBER
12464: , p_commit VARCHAR2 := fnd_api.g_false
12465: , x_return_status OUT NOCOPY VARCHAR2
12466: , x_msg_count OUT NOCOPY NUMBER
12467: , x_msg_data OUT NOCOPY VARCHAR2
12468: ) IS

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

12498: l_new_qty NUMBER;
12499: l_counter NUMBER := 0;
12500: l_new_temp_id NUMBER;
12501: l_progress VARCHAR2(10);
12502: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
12503: l_msg_count NUMBER;
12504: l_msg_data VARCHAR2(400);
12505:
12506: -- capacity cursur for all the equipments that is eligible for one task

Line 12608: x_return_status := fnd_api.g_ret_sts_success;

12604: l_progress := '10';
12605: SAVEPOINT sp_task_split;
12606: l_progress := '20';
12607: -- Initialize API return status to success
12608: x_return_status := fnd_api.g_ret_sts_success;
12609: -- query locator picking UOM code, if NULL use subinventory picking UOM code
12610: -- query transaction UOM code, and primary UOM code
12611: -- query transacted item ID
12612: -- Also query the transaction quantity

Line 12702: RAISE fnd_api.g_exc_unexpected_error;

12698: IF (l_debug = 1) THEN
12699: print_debug('split_task 30 - necessary UOM information missing' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
12700: END IF;
12701:
12702: RAISE fnd_api.g_exc_unexpected_error;
12703: END IF;
12704:
12705: -- call UOM conversion API to compute the ratio between
12706: -- locator UOM and transcation UOM for given item

Line 12718: RAISE fnd_api.g_exc_error;

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;
12717:
12718: RAISE fnd_api.g_exc_error;
12719: END IF;
12720:
12721: -- compute conversion rate between transaction UOM and item primary UOM
12722: inv_convert.inv_um_conversion(from_unit => l_txn_uom_code, to_unit => l_item_prim_uom_code, item_id => l_item_id

Line 12733: RAISE fnd_api.g_exc_error;

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;
12732:
12733: RAISE fnd_api.g_exc_error;
12734: END IF;
12735:
12736: IF (l_debug = 1) THEN
12737: print_debug('split_task 60 - UOM conversion data:' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);

Line 12892: RAISE fnd_api.g_exc_error;

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;
12891:
12892: RAISE fnd_api.g_exc_error;
12893: END IF;
12894:
12895: -- compute splitting factor, round down equipment capacity to multiple of locator uom ratio
12896: IF l_min_cap >= l_loc_txn_uom_ratio THEN

Line 12914: RAISE fnd_api.g_exc_error;

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;
12913:
12914: RAISE fnd_api.g_exc_error;
12915: END IF;
12916:
12917: -- query the inital task
12918:

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

13110: print_debug('calling duplicate_lot_serial_in_parent....',4);
13111: END IF;
13112: Duplicate_lot_serial_in_parent(l_new_temp_id,x_return_status,x_msg_count,x_msg_data);
13113:
13114: if (x_return_status <> fnd_api.g_ret_sts_success) then
13115: IF (l_debug = 1) THEN
13116: print_debug('split_task 150.2 - error in duplicate_lot_serial_in_parent ', 4);
13117: END IF;
13118: raise fnd_api.g_exc_unexpected_error;

Line 13118: raise fnd_api.g_exc_unexpected_error;

13114: if (x_return_status <> fnd_api.g_ret_sts_success) then
13115: IF (l_debug = 1) THEN
13116: print_debug('split_task 150.2 - error in duplicate_lot_serial_in_parent ', 4);
13117: END IF;
13118: raise fnd_api.g_exc_unexpected_error;
13119: end if;
13120: -- IF (l_debug = 1) THEN print_debug('PATCHSET J -- BULK PICKING --- END',4); END IF;
13121: END IF;
13122:

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

13164: IF (l_debug = 1) THEN
13165: print_debug('calling duplicate_lot_serial_in_parent for the last ....',4);
13166: END IF;
13167: Duplicate_lot_serial_in_parent(p_task_id,x_return_status,x_msg_count,x_msg_data);
13168: if (x_return_status <> fnd_api.g_ret_sts_success) then
13169: IF (l_debug = 1) THEN
13170: print_debug('split_task 150.2 - error in duplicate_lot_serial_in_parent ', 4);
13171: END IF;
13172: raise fnd_api.g_exc_unexpected_error;

Line 13172: raise fnd_api.g_exc_unexpected_error;

13168: if (x_return_status <> fnd_api.g_ret_sts_success) then
13169: IF (l_debug = 1) THEN
13170: print_debug('split_task 150.2 - error in duplicate_lot_serial_in_parent ', 4);
13171: END IF;
13172: raise fnd_api.g_exc_unexpected_error;
13173: end if;
13174: END IF;
13175: -- IF (l_debug = 1) THEN print_debug('PATCHSET J -- BULK PICKING --- END',4); END IF;
13176: end if; -- end of patchset J bulk picking ----------

Line 13190: WHEN fnd_api.g_exc_error THEN

13186: IF (l_debug = 1) THEN
13187: print_debug('split_task 140 - complete ', 4);
13188: 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:

Line 13191: x_return_status := fnd_api.g_ret_sts_error;

13187: print_debug('split_task 140 - complete ', 4);
13188: 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

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

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. '

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

13210: IF (l_debug = 1) THEN
13211: print_debug('calling duplicate_lot_serial_in_parent for the parent line ....',4);
13212: END IF;
13213: Duplicate_lot_serial_in_parent(p_task_id,x_return_status,x_msg_count,x_msg_data);
13214: if (x_return_status <> fnd_api.g_ret_sts_success) then
13215: IF (l_debug = 1) THEN
13216: print_debug('split_task 1000- error in duplicate_lot_serial_in_parent ', 4);
13217: END IF;
13218: -- change to unexpected error

Line 13219: x_return_status := fnd_api.g_ret_sts_unexp_error;

13215: IF (l_debug = 1) THEN
13216: print_debug('split_task 1000- error in duplicate_lot_serial_in_parent ', 4);
13217: END IF;
13218: -- change to unexpected error
13219: x_return_status := fnd_api.g_ret_sts_unexp_error;
13220: end if;
13221: END IF;
13222: -- IF (l_debug = 1) THEN print_debug('PATCHSET J -- BULK PICKING --- END',4); END IF;
13223: end if; -- end of patchset J bulk picking ----------

Line 13225: WHEN fnd_api.g_exc_unexpected_error THEN

13221: END IF;
13222: -- IF (l_debug = 1) THEN print_debug('PATCHSET J -- BULK PICKING --- END',4); END IF;
13223: end if; -- end of patchset J bulk picking ----------
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:

Line 13226: x_return_status := fnd_api.g_ret_sts_unexp_error;

13222: -- IF (l_debug = 1) THEN print_debug('PATCHSET J -- BULK PICKING --- END',4); END IF;
13223: end if; -- end of patchset J bulk picking ----------
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

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

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;

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

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;
13233: WHEN OTHERS THEN
13234: x_return_status := fnd_api.g_ret_sts_unexp_error;
13235: ROLLBACK TO sp_task_split;

Line 13234: x_return_status := fnd_api.g_ret_sts_unexp_error;

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;
13233: WHEN OTHERS THEN
13234: x_return_status := fnd_api.g_ret_sts_unexp_error;
13235: ROLLBACK TO sp_task_split;
13236:
13237: IF SQLCODE IS NOT NULL THEN
13238: inv_mobile_helper_functions.sql_error('WMS_Task_Dispatch_Engine.split_task', l_progress, SQLCODE);

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

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;