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_MGMT_PUB dependencies on FND_MSG_PUB

Line 316: fnd_msg_pub.ADD;

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

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

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

Line 326: fnd_msg_pub.ADD;

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

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

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

Line 367: fnd_msg_pub.ADD;

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

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

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

Line 383: fnd_msg_pub.ADD;

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

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

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

Line 412: fnd_msg_pub.ADD;

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

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

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

Line 465: fnd_msg_pub.ADD;

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

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

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

Line 483: fnd_msg_pub.ADD;

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

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

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

Line 517: fnd_msg_pub.ADD;

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

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

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

Line 639: fnd_msg_pub.ADD;

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

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

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

Line 688: fnd_msg_pub.ADD;

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

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

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

Line 708: fnd_msg_pub.ADD;

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

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

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

Line 723: fnd_msg_pub.ADD;

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

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

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

Line 738: fnd_msg_pub.ADD;

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

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

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

Line 753: fnd_msg_pub.ADD;

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

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

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

Line 765: fnd_msg_pub.ADD;

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

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

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

Line 783: fnd_msg_pub.ADD;

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

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

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

Line 808: fnd_msg_pub.ADD;

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

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

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

Line 827: fnd_msg_pub.ADD;

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

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

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

Line 857: fnd_msg_pub.ADD;

853: ( p_op_plan_rec.plan_type_id = 2 AND l_operation_plan_type_id = 2 )) THEN
854: p_output_task_rec.operation_plan_id := p_new_operation_plan_id;
855: ELSE
856: fnd_message.set_name('WMS', 'WMS_OPERTN_PLAN_ID_INVALID');--new message
857: fnd_msg_pub.ADD;
858: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_err_msg );
859: p_output_task_rec.RESULT := 'E';
860: p_output_task_rec.ERROR := l_err_msg;
861: l_msg := 'Inspection/Standard operation plan can only be replaced with another Inspection/Standard operation plan

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

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

Line 870: fnd_msg_pub.ADD;

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

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

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

Line 886: fnd_msg_pub.ADD;

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

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

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

Line 910: fnd_msg_pub.ADD;

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

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

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

Line 941: fnd_msg_pub.ADD;

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

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

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

Line 971: fnd_msg_pub.ADD;

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

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

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

Line 1014: fnd_msg_pub.ADD;

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

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

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

Line 1070: fnd_msg_pub.initialize;

1066: x_return_status := 'S';
1067: x_error_msg := NULL;
1068: --Initialize message pub
1069: IF p_init_msg_list ='Y' THEN
1070: fnd_msg_pub.initialize;
1071: END IF;
1072: BEGIN
1073: --Make sure there is a task with this Id
1074: SELECT 1 ,

Line 1100: fnd_msg_pub.ADD;

1096: END IF ;
1097: IF (l_task_exists = 0 ) THEN
1098: --Still no task, this is invalid id.
1099: fnd_message.set_name('WMS', 'INVALID_TASK');
1100: fnd_msg_pub.ADD;
1101: x_validation_status:= 'E';
1102: END IF;
1103: --Need to check status in WDT .
1104: BEGIN

Line 1140: fnd_msg_pub.ADD;

1136: IF ( l_parent_line_id > 0 AND l_task_type = 1 ) THEN --This is nbulk pick
1137: IF (l_parent_line_id <> p_transaction_number ) THEN
1138: --The input is a child of bulk task.Fail validation.
1139: fnd_message.set_name('WMS', 'INVALID_TASK');
1140: fnd_msg_pub.ADD;
1141: x_validation_status:= 'E';
1142: END IF;
1143: END IF;
1144: -- 6850212 Start

Line 1148: --fnd_msg_pub.ADD;

1144: -- 6850212 Start
1145: IF p_action = 'MODIFY' THEN
1146: IF (l_wdt_status NOT IN (0,2,3,9)) THEN
1147: --fnd_message.set_name('WMS', 'WMS_ATF_INVALID_TASK_STATUS');
1148: --fnd_msg_pub.ADD;
1149: x_validation_status:= 'E';
1150: END IF;
1151: ELSE
1152: IF( l_wdt_status NOT IN (0,2) ) THEN

Line 1154: --fnd_msg_pub.ADD;

1150: END IF;
1151: ELSE
1152: IF( l_wdt_status NOT IN (0,2) ) THEN
1153: --fnd_message.set_name('WMS', 'WMS_ATF_INVALID_TASK_STATUS');
1154: --fnd_msg_pub.ADD;
1155: x_validation_status:= 'E';
1156: END IF;
1157: END IF;
1158: -- 6850212 End

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

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

Line 1275: fnd_msg_pub.ADD;

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

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

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

Line 1307: fnd_msg_pub.ADD;

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

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

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

Line 1323: fnd_msg_pub.ADD;

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

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

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

Line 1352: fnd_msg_pub.ADD;

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

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

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

Line 1386: fnd_msg_pub.ADD;

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

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

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

Line 1418: fnd_msg_pub.ADD;

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

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

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

Line 5112: -- FND_MSG_PUB.ADD;

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

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

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

Line 5130: -- FND_MSG_PUB.ADD;

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

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

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

Line 5155: FND_MSG_PUB.ADD;

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

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

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

Line 5164: FND_MSG_PUB.ADD;

5160: debug_print('In the When Others Exception of Delete_Tasks, Rolling back.' );
5161: END IF;
5162: x_return_status := l_g_ret_sts_unexp_error;
5163: FND_MESSAGE.SET_NAME('WMS', 'WMS_UNEXPECTED_ERROR');
5164: FND_MSG_PUB.ADD;
5165: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
5166: ROLLBACK TO deltask;
5167: END DELETE_TASKS;
5168:

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

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

Line 6146: fnd_msg_pub.ADD;

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

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

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

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

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

Line 6185: fnd_msg_pub.ADD;

6181: ORDER BY 1;
6182: EXCEPTION
6183: WHEN OTHERS THEN
6184: fnd_message.set_name('WMS', 'WMS_INVALID_VALUE');
6185: fnd_msg_pub.ADD;
6186: l_err_msg := substr(SQLERRM,1,1000);
6187: RAISE l_qry_fail;
6188: END;
6189:

Line 6242: fnd_msg_pub.ADD;

6238: ELSE
6239: l_execute_qry := FALSE;
6240: l_err_msg := 'Invalid query criteria';
6241: fnd_message.set_name('WMS', 'WMS_NO_SOURCE_ENTERED');
6242: fnd_msg_pub.ADD;
6243: RAISE l_qry_fail;
6244: END IF;
6245: END IF;
6246:

Line 6275: fnd_msg_pub.ADD;

6271: THEN
6272: l_execute_qry := FALSE;
6273: l_err_msg := 'Invalid query criteria';
6274: fnd_message.set_name('WMS', 'WMS_NO_SOURCE_ENTERED');
6275: fnd_msg_pub.ADD;
6276: RAISE l_qry_fail;
6277: END IF;
6278:
6279: --- Derive organization_id

Line 6288: fnd_msg_pub.ADD;

6284: WHERE query_name = p_query_name;
6285: EXCEPTION
6286: WHEN OTHERS THEN
6287: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_ORG');
6288: fnd_msg_pub.ADD;
6289: l_err_msg := concat('Invalid Org: ',substr(SQLERRM,1,1000));
6290: RAISE l_invalid_org;
6291: NULL;
6292: END;

Line 6560: fnd_msg_pub.ADD;

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

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

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

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

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

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

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

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

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

Line 7036: fnd_msg_pub.ADD;

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

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

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

Line 7060: fnd_msg_pub.ADD;

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

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

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

Line 7081: fnd_msg_pub.ADD;

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

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

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

Line 7105: fnd_msg_pub.ADD;

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

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

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

Line 7123: fnd_msg_pub.ADD;

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

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

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

Line 7132: fnd_msg_pub.ADD;

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

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

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

Line 7307: fnd_msg_pub.ADD;

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

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

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

Line 7333: fnd_msg_pub.ADD;

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

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

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

Line 7374: -- fnd_msg_pub.ADD;

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

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

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

Line 7394: -- fnd_msg_pub.ADD;

7390: x_updated_tasks(i) := temp_task_tab(1);--assigning the queried results to output table
7391: END IF;
7392: ELSE
7393: fnd_message.set_name('WMS', 'WMS_INVALID_TASK');
7394: -- fnd_msg_pub.ADD;
7395: -- fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_msg );
7396: --anjana
7397: l_msg := fnd_message.get;
7398: x_msg_data := x_msg_data || l_msg;

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

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

Line 7410: fnd_msg_pub.ADD;

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

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

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

Line 7433: fnd_msg_pub.ADD;

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

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

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

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

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

Line 7466: fnd_msg_pub.ADD;

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

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

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

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

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