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 5201: -- FND_MSG_PUB.ADD;

5197: x_undeleted_tasks(undel_task).transaction_number:= x_task_rec.transaction_number;
5198: x_undeleted_tasks(undel_task).RESULT := x_task_rec.status;
5199: x_undeleted_tasks(undel_task).error := l_msg;
5200: undel_task :=undel_task+1;
5201: -- FND_MSG_PUB.ADD;
5202: -- fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
5203: END IF;
5204: IF x_return_status ='U' THEN
5205: IF l_debug = 1 THEN

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

5198: x_undeleted_tasks(undel_task).RESULT := x_task_rec.status;
5199: x_undeleted_tasks(undel_task).error := l_msg;
5200: undel_task :=undel_task+1;
5201: -- FND_MSG_PUB.ADD;
5202: -- fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
5203: END IF;
5204: IF x_return_status ='U' THEN
5205: IF l_debug = 1 THEN
5206: debug_print('The called program returned unexpected error status' );

Line 5219: -- FND_MSG_PUB.ADD;

5215: --anjana
5216: l_msg := fnd_message.get;
5217: x_msg_count := x_msg_count + 1;
5218: x_msg_data := x_msg_data || l_msg;
5219: -- FND_MSG_PUB.ADD;
5220: -- fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
5221:
5222: x_undeleted_tasks(undel_task).transaction_number:= l_ret_task_table(i).transaction_number ; --6888354 Bug
5223: x_undeleted_tasks(undel_task).RESULT := l_ret_task_table(i).RESULT;

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

5216: l_msg := fnd_message.get;
5217: x_msg_count := x_msg_count + 1;
5218: x_msg_data := x_msg_data || l_msg;
5219: -- FND_MSG_PUB.ADD;
5220: -- fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
5221:
5222: x_undeleted_tasks(undel_task).transaction_number:= l_ret_task_table(i).transaction_number ; --6888354 Bug
5223: x_undeleted_tasks(undel_task).RESULT := l_ret_task_table(i).RESULT;
5224: x_undeleted_tasks(undel_task).error := l_msg;

Line 5244: FND_MSG_PUB.ADD;

5240: debug_print('In the Unexpected Error of Delete_Tasks, Rolling back.' );
5241: END IF;
5242: x_return_status := l_g_ret_sts_unexp_error;
5243: FND_MESSAGE.SET_NAME('WMS', 'WMS_UNEXPECTED_ERROR');
5244: FND_MSG_PUB.ADD;
5245: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
5246: ROLLBACK TO deltask;
5247: WHEN OTHERS THEN
5248: IF l_debug = 1 THEN

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

5241: END IF;
5242: x_return_status := l_g_ret_sts_unexp_error;
5243: FND_MESSAGE.SET_NAME('WMS', 'WMS_UNEXPECTED_ERROR');
5244: FND_MSG_PUB.ADD;
5245: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
5246: ROLLBACK TO deltask;
5247: WHEN OTHERS THEN
5248: IF l_debug = 1 THEN
5249: debug_print('In the When Others Exception of Delete_Tasks, Rolling back.' );

Line 5253: FND_MSG_PUB.ADD;

5249: debug_print('In the When Others Exception of Delete_Tasks, Rolling back.' );
5250: END IF;
5251: x_return_status := l_g_ret_sts_unexp_error;
5252: FND_MESSAGE.SET_NAME('WMS', 'WMS_UNEXPECTED_ERROR');
5253: FND_MSG_PUB.ADD;
5254: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
5255: ROLLBACK TO deltask;
5256: END DELETE_TASKS;
5257:

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

5250: END IF;
5251: x_return_status := l_g_ret_sts_unexp_error;
5252: FND_MESSAGE.SET_NAME('WMS', 'WMS_UNEXPECTED_ERROR');
5253: FND_MSG_PUB.ADD;
5254: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
5255: ROLLBACK TO deltask;
5256: END DELETE_TASKS;
5257:
5258: -------------------------------------------------------------------------------------------------------------------

Line 6241: fnd_msg_pub.ADD;

6237: EXCEPTION
6238: WHEN NO_DATA_FOUND THEN
6239: inv_trx_util_pub.trace('in the exception block of outbond/manufacturing/warehousing complete tasks');
6240: fnd_message.set_name('WMS', 'WMS_INVALID_TASK');
6241: fnd_msg_pub.ADD;
6242: x_return_status := fnd_api.g_ret_sts_unexp_error;
6243: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
6244: l_err_msg := 'Failed to fetch data from MMTT,MCCE,MMT or WDTH tables for transaction number '||p_transaction_number;
6245: IF(l_debug = 1) THEN

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

6239: inv_trx_util_pub.trace('in the exception block of outbond/manufacturing/warehousing complete tasks');
6240: fnd_message.set_name('WMS', 'WMS_INVALID_TASK');
6241: fnd_msg_pub.ADD;
6242: x_return_status := fnd_api.g_ret_sts_unexp_error;
6243: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
6244: l_err_msg := 'Failed to fetch data from MMTT,MCCE,MMT or WDTH tables for transaction number '||p_transaction_number;
6245: IF(l_debug = 1) THEN
6246: inv_trx_util_pub.trace(l_api_name||': '||l_err_msg);
6247: END IF;

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

6252: END;
6253: --end the begin block for cycle count tasks
6254: WHEN OTHERS THEN
6255: x_return_status := fnd_api.g_ret_sts_unexp_error;
6256: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
6257: l_err_msg := substr(SQLERRM,1,1000);
6258: IF(l_debug = 1) THEN
6259: inv_trx_util_pub.trace(l_api_name||': '||l_err_msg);
6260: END IF;

Line 6280: fnd_msg_pub.ADD;

6276: ORDER BY 1;
6277: EXCEPTION
6278: WHEN OTHERS THEN
6279: fnd_message.set_name('WMS', 'WMS_INVALID_VALUE');
6280: fnd_msg_pub.ADD;
6281: l_err_msg := substr(SQLERRM,1,1000);
6282: RAISE l_qry_fail;
6283: END;
6284:

Line 6337: fnd_msg_pub.ADD;

6333: ELSE
6334: l_execute_qry := FALSE;
6335: l_err_msg := 'Invalid query criteria';
6336: fnd_message.set_name('WMS', 'WMS_NO_SOURCE_ENTERED');
6337: fnd_msg_pub.ADD;
6338: RAISE l_qry_fail;
6339: END IF;
6340: END IF;
6341:

Line 6370: fnd_msg_pub.ADD;

6366: THEN
6367: l_execute_qry := FALSE;
6368: l_err_msg := 'Invalid query criteria';
6369: fnd_message.set_name('WMS', 'WMS_NO_SOURCE_ENTERED');
6370: fnd_msg_pub.ADD;
6371: RAISE l_qry_fail;
6372: END IF;
6373:
6374: --- Derive organization_id

Line 6383: fnd_msg_pub.ADD;

6379: WHERE query_name = p_query_name;
6380: EXCEPTION
6381: WHEN OTHERS THEN
6382: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_ORG');
6383: fnd_msg_pub.ADD;
6384: l_err_msg := concat('Invalid Org: ',substr(SQLERRM,1,1000));
6385: RAISE l_invalid_org;
6386: NULL;
6387: END;

Line 6655: fnd_msg_pub.ADD;

6651:
6652: ELSE
6653: x_return_status := fnd_api.g_ret_sts_unexp_error;
6654: fnd_message.set_name('WMS', 'WMS_INVALID_VALUE');
6655: fnd_msg_pub.ADD;
6656: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
6657: inv_trx_util_pub.trace(l_api_name||': '||'Invalid Parameters Passed');
6658: END IF; ----if p_transaction_number is not null
6659:

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

6652: ELSE
6653: x_return_status := fnd_api.g_ret_sts_unexp_error;
6654: fnd_message.set_name('WMS', 'WMS_INVALID_VALUE');
6655: fnd_msg_pub.ADD;
6656: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
6657: inv_trx_util_pub.trace(l_api_name||': '||'Invalid Parameters Passed');
6658: END IF; ----if p_transaction_number is not null
6659:
6660: EXCEPTION

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

6659:
6660: EXCEPTION
6661: WHEN l_invalid_org THEN
6662: x_return_status := fnd_api.g_ret_sts_unexp_error;
6663: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
6664: IF(l_debug = 1) THEN
6665: inv_trx_util_pub.trace(l_api_name||': '||l_err_msg);
6666: END IF;
6667: NULL;

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

6667: NULL;
6668:
6669: WHEN l_qry_fail THEN
6670: x_return_status := fnd_api.g_ret_sts_unexp_error;
6671: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
6672: IF(l_debug = 1) THEN
6673: inv_trx_util_pub.trace(l_api_name||': '||l_err_msg);
6674: END IF;
6675: NULL;

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

6675: NULL;
6676:
6677: WHEN OTHERS THEN
6678: x_return_status := fnd_api.g_ret_sts_unexp_error;
6679: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
6680: l_err_msg := substr(SQLERRM,1,1000);
6681: IF(l_debug = 1) THEN
6682: inv_trx_util_pub.trace(l_api_name||': '||l_err_msg);
6683: END IF;

Line 7135: fnd_msg_pub.ADD;

7131: l_return_status ,
7132: l_msg_count ,
7133: l_msg_data );
7134: fnd_message.set_name('WMS', 'WMS_INVALID_TASK');
7135: fnd_msg_pub.ADD;
7136: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
7137:
7138: IF l_new_tasks_tbl.COUNT > 0 THEN
7139: x_resultant_tasks(1) := l_new_tasks_tbl(1);

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

7132: l_msg_count ,
7133: l_msg_data );
7134: fnd_message.set_name('WMS', 'WMS_INVALID_TASK');
7135: fnd_msg_pub.ADD;
7136: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
7137:
7138: IF l_new_tasks_tbl.COUNT > 0 THEN
7139: x_resultant_tasks(1) := l_new_tasks_tbl(1);
7140: x_resultant_tasks(1).RESULT := 'E';

Line 7159: fnd_msg_pub.ADD;

7155: l_return_status ,
7156: l_msg_count ,
7157: l_msg_data );
7158: fnd_message.set_name('INV', 'INV_LOT_INDIVISIBLE');
7159: fnd_msg_pub.ADD;
7160: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
7161:
7162: IF l_new_tasks_tbl.COUNT > 0 THEN
7163: x_resultant_tasks(1) := l_new_tasks_tbl(1);

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

7156: l_msg_count ,
7157: l_msg_data );
7158: fnd_message.set_name('INV', 'INV_LOT_INDIVISIBLE');
7159: fnd_msg_pub.ADD;
7160: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
7161:
7162: IF l_new_tasks_tbl.COUNT > 0 THEN
7163: x_resultant_tasks(1) := l_new_tasks_tbl(1);
7164: x_resultant_tasks(1).RESULT := 'E';

Line 7180: fnd_msg_pub.ADD;

7176: l_return_status ,
7177: l_msg_count ,
7178: l_msg_data );
7179: fnd_message.set_name('WMS', 'WMS_INVALID_SPLIT_QUANTITY');
7180: fnd_msg_pub.ADD;
7181: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
7182:
7183: IF l_new_tasks_tbl.COUNT > 0 THEN
7184: x_resultant_tasks(1) := l_new_tasks_tbl(1);

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

7177: l_msg_count ,
7178: l_msg_data );
7179: fnd_message.set_name('WMS', 'WMS_INVALID_SPLIT_QUANTITY');
7180: fnd_msg_pub.ADD;
7181: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
7182:
7183: IF l_new_tasks_tbl.COUNT > 0 THEN
7184: x_resultant_tasks(1) := l_new_tasks_tbl(1);
7185: x_resultant_tasks(1).RESULT := 'E';

Line 7204: fnd_msg_pub.ADD;

7200: l_return_status ,
7201: l_msg_count ,
7202: l_msg_data );
7203: fnd_message.set_name('WMS', 'WMS_QUERY_ELIG_MATRL');
7204: fnd_msg_pub.ADD;
7205: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
7206:
7207: IF l_new_tasks_tbl.COUNT > 0 THEN
7208: x_resultant_tasks(1) := l_new_tasks_tbl(1);

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

7201: l_msg_count ,
7202: l_msg_data );
7203: fnd_message.set_name('WMS', 'WMS_QUERY_ELIG_MATRL');
7204: fnd_msg_pub.ADD;
7205: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
7206:
7207: IF l_new_tasks_tbl.COUNT > 0 THEN
7208: x_resultant_tasks(1) := l_new_tasks_tbl(1);
7209: x_resultant_tasks(1).RESULT := 'E';

Line 7222: fnd_msg_pub.ADD;

7218: END IF;
7219: x_return_status := 'E';
7220: ROLLBACK TO wms_split_task;
7221: fnd_message.set_name('WMS', 'WMS_UNEXPECTED_ERROR');
7222: fnd_msg_pub.ADD;
7223: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
7224: WHEN OTHERS THEN
7225: IF g_debug = 1 THEN
7226: print_msg(l_procedure_name,'EXCEPTION BLOCK : Unexpected error has occured, ROLLING BACK THE TRANSACTIONS');

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

7219: x_return_status := 'E';
7220: ROLLBACK TO wms_split_task;
7221: fnd_message.set_name('WMS', 'WMS_UNEXPECTED_ERROR');
7222: fnd_msg_pub.ADD;
7223: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
7224: WHEN OTHERS THEN
7225: IF g_debug = 1 THEN
7226: print_msg(l_procedure_name,'EXCEPTION BLOCK : Unexpected error has occured, ROLLING BACK THE TRANSACTIONS');
7227: END IF;

Line 7231: fnd_msg_pub.ADD;

7227: END IF;
7228: x_return_status := 'E';
7229: ROLLBACK TO wms_split_task;
7230: fnd_message.set_name('WMS', 'WMS_UNEXPECTED_ERROR');
7231: fnd_msg_pub.ADD;
7232: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
7233: x_return_status := 'E';
7234: IF g_debug = 1 THEN
7235: print_msg(l_procedure_name, 'EXCEPTION BLOCK : Error Code : '|| SQLCODE || 'EXCEPTION BLOCK : Error Message :'||SQLERRM);

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

7228: x_return_status := 'E';
7229: ROLLBACK TO wms_split_task;
7230: fnd_message.set_name('WMS', 'WMS_UNEXPECTED_ERROR');
7231: fnd_msg_pub.ADD;
7232: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
7233: x_return_status := 'E';
7234: IF g_debug = 1 THEN
7235: print_msg(l_procedure_name, 'EXCEPTION BLOCK : Error Code : '|| SQLCODE || 'EXCEPTION BLOCK : Error Message :'||SQLERRM);
7236: END IF;

Line 7406: fnd_msg_pub.ADD;

7402: IF(p_new_task_status NOT IN (1,2,8)) THEN
7403: --6850212:Return status should not be set to error.
7404: --x_return_status := fnd_api.g_ret_sts_error;
7405: fnd_message.set_name('WMS', 'WMS_INVALID_TASK_STATUS');--new message
7406: fnd_msg_pub.ADD;
7407: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_msg );
7408: x_msg_data := l_msg;
7409: x_msg_count := l_msg_count;
7410: l_err_msg :='New task status not in Pending or Queued state or Unreleased state';

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

7403: --6850212:Return status should not be set to error.
7404: --x_return_status := fnd_api.g_ret_sts_error;
7405: fnd_message.set_name('WMS', 'WMS_INVALID_TASK_STATUS');--new message
7406: fnd_msg_pub.ADD;
7407: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_msg );
7408: x_msg_data := l_msg;
7409: x_msg_count := l_msg_count;
7410: l_err_msg :='New task status not in Pending or Queued state or Unreleased state';
7411: IF(l_debug = 1) THEN

Line 7432: fnd_msg_pub.ADD;

7428: IF (l_op_plan_rec.eabled_flag <> 'Y') THEN--op_plan passed is not enabled
7429: --6850212:Return status should not be set to error.
7430: --x_return_status := fnd_api.g_ret_sts_error;
7431: fnd_message.set_name('WMS', 'WMS_OPERTN_PLAN_ID_INVALID');--new message
7432: fnd_msg_pub.ADD;
7433: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_msg );
7434: x_msg_data := l_msg;
7435: x_msg_count := l_msg_count;
7436: l_err_msg :='Operation Plan is not enabled';

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

7429: --6850212:Return status should not be set to error.
7430: --x_return_status := fnd_api.g_ret_sts_error;
7431: fnd_message.set_name('WMS', 'WMS_OPERTN_PLAN_ID_INVALID');--new message
7432: fnd_msg_pub.ADD;
7433: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_msg );
7434: x_msg_data := l_msg;
7435: x_msg_count := l_msg_count;
7436: l_err_msg :='Operation Plan is not enabled';
7437: IF(l_debug = 1) THEN

Line 7473: -- fnd_msg_pub.ADD;

7469:
7470: --if quey was not successfull then populate output table with passed values with error
7471: IF ((p_return_sts <> fnd_api.g_ret_sts_success) OR ( temp_task_tab.count = 0)) THEN
7472: fnd_message.set_name('WMS', 'WMS_QUERY_ELIG_MATRL');--new message
7473: -- fnd_msg_pub.ADD;
7474: -- fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_msg);
7475: --anjana
7476: l_msg := fnd_message.get;
7477: x_msg_data := x_msg_data || l_msg;

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

7470: --if quey was not successfull then populate output table with passed values with error
7471: IF ((p_return_sts <> fnd_api.g_ret_sts_success) OR ( temp_task_tab.count = 0)) THEN
7472: fnd_message.set_name('WMS', 'WMS_QUERY_ELIG_MATRL');--new message
7473: -- fnd_msg_pub.ADD;
7474: -- fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_msg);
7475: --anjana
7476: l_msg := fnd_message.get;
7477: x_msg_data := x_msg_data || l_msg;
7478: x_msg_count := x_msg_count + 1;

Line 7493: -- fnd_msg_pub.ADD;

7489: x_updated_tasks(i) := temp_task_tab(1);--assigning the queried results to output table
7490: END IF;
7491: ELSE
7492: fnd_message.set_name('WMS', 'WMS_INVALID_TASK');
7493: -- fnd_msg_pub.ADD;
7494: -- fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_msg );
7495: --anjana
7496: l_msg := fnd_message.get;
7497: x_msg_data := x_msg_data || l_msg;

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

7490: END IF;
7491: ELSE
7492: fnd_message.set_name('WMS', 'WMS_INVALID_TASK');
7493: -- fnd_msg_pub.ADD;
7494: -- fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_msg );
7495: --anjana
7496: l_msg := fnd_message.get;
7497: x_msg_data := x_msg_data || l_msg;
7498: x_msg_count := x_msg_count + 1;

Line 7509: fnd_msg_pub.ADD;

7505: END LOOP;--Loop ends
7506: ELSE
7507: x_return_status := fnd_api.g_ret_sts_unexp_error;
7508: fnd_message.set_name('WMS', 'WMS_UNEXPECTED_ERROR');
7509: fnd_msg_pub.ADD;
7510: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_msg );
7511: x_msg_data := l_msg;
7512: x_msg_count := l_msg_count;
7513: -- l_err_msg :='Task Validation Failed';

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

7506: ELSE
7507: x_return_status := fnd_api.g_ret_sts_unexp_error;
7508: fnd_message.set_name('WMS', 'WMS_UNEXPECTED_ERROR');
7509: fnd_msg_pub.ADD;
7510: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_msg );
7511: x_msg_data := l_msg;
7512: x_msg_count := l_msg_count;
7513: -- l_err_msg :='Task Validation Failed';
7514: IF(l_debug = 1) THEN

Line 7532: fnd_msg_pub.ADD;

7528: FOR i in 1..l_updated_tasks.count
7529: LOOP
7530: 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
7531: fnd_message.set_name('WMS', 'WMS_CARTONIZATION_ERROR');--new message
7532: fnd_msg_pub.ADD;
7533: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_msg );
7534: l_err_msg :='Cartonization can be done only on Outbound tasks(Sales order/WIP)';
7535: x_msg_data := l_msg;
7536: x_msg_count := l_msg_count;

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

7529: LOOP
7530: 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
7531: fnd_message.set_name('WMS', 'WMS_CARTONIZATION_ERROR');--new message
7532: fnd_msg_pub.ADD;
7533: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_msg );
7534: l_err_msg :='Cartonization can be done only on Outbound tasks(Sales order/WIP)';
7535: x_msg_data := l_msg;
7536: x_msg_count := l_msg_count;
7537: log_error(p_transaction_number => p_transaction_number,

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

7547: x_return_status => p_return_sts);
7548:
7549: IF (p_return_sts <> fnd_api.g_ret_sts_success) THEN
7550: x_return_status := fnd_api.g_ret_sts_error;
7551: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data );
7552: FOR i IN 1..l_updated_tasks.count
7553: LOOP
7554: x_updated_tasks(i).RESULT := 'E';
7555: x_updated_tasks(i).ERROR := l_error_msg;

Line 7565: fnd_msg_pub.ADD;

7561: END IF;
7562: ELSE
7563: x_return_status := fnd_api.g_ret_sts_error;
7564: fnd_message.set_name('WMS', 'WMS_CARTONIZATION_ERROR');--new message
7565: fnd_msg_pub.ADD;
7566: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data );
7567: l_err_msg := 'Some tasks have failed validation,cartonization cannot be done';
7568: IF(l_debug = 1) THEN
7569: inv_trx_util_pub.trace(l_api_name|| ': '||l_err_msg);

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

7562: ELSE
7563: x_return_status := fnd_api.g_ret_sts_error;
7564: fnd_message.set_name('WMS', 'WMS_CARTONIZATION_ERROR');--new message
7565: fnd_msg_pub.ADD;
7566: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data );
7567: l_err_msg := 'Some tasks have failed validation,cartonization cannot be done';
7568: IF(l_debug = 1) THEN
7569: inv_trx_util_pub.trace(l_api_name|| ': '||l_err_msg);
7570: END IF;

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

7762: END IF;
7763: EXCEPTION
7764: WHEN OTHERS THEN
7765: x_return_status := fnd_api.g_ret_sts_unexp_error;
7766: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
7767: l_err_msg := substr(SQLERRM,1,1000);
7768: IF(l_debug = 1) THEN
7769: inv_trx_util_pub.trace(l_api_name|| ': '||l_err_msg);
7770: END IF;