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

Line 1077: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

1073: IF (l_debug=1) THEN
1074: DEBUG('Expected Error at '||l_progress, l_proc_name,1);
1075: END IF;
1076:
1077: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1078: fnd_msg_pub.add_exc_msg(g_pkg_name, l_proc_name, SQLERRM);
1079: END IF; /* fnd_msg.... */
1080:
1081: fnd_msg_pub.count_and_get(

Line 1078: fnd_msg_pub.add_exc_msg(g_pkg_name, l_proc_name, SQLERRM);

1074: DEBUG('Expected Error at '||l_progress, l_proc_name,1);
1075: END IF;
1076:
1077: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1078: fnd_msg_pub.add_exc_msg(g_pkg_name, l_proc_name, SQLERRM);
1079: END IF; /* fnd_msg.... */
1080:
1081: fnd_msg_pub.count_and_get(
1082: p_count => x_msg_count,

Line 1081: fnd_msg_pub.count_and_get(

1077: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1078: fnd_msg_pub.add_exc_msg(g_pkg_name, l_proc_name, SQLERRM);
1079: END IF; /* fnd_msg.... */
1080:
1081: fnd_msg_pub.count_and_get(
1082: p_count => x_msg_count,
1083: p_data => x_msg_data
1084: );
1085: --x_error_code := SQLCODE;

Line 1096: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1092: DEBUG('Unexpected error at'||l_progress||' '||SQLERRM, l_proc_name,1);
1093: END IF;
1094:
1095:
1096: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1097: fnd_msg_pub.add_exc_msg(g_pkg_name, l_proc_name, SQLERRM);
1098: END IF; /* fnd_msg.... */
1099:
1100: fnd_msg_pub.count_and_get(

Line 1097: fnd_msg_pub.add_exc_msg(g_pkg_name, l_proc_name, SQLERRM);

1093: END IF;
1094:
1095:
1096: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1097: fnd_msg_pub.add_exc_msg(g_pkg_name, l_proc_name, SQLERRM);
1098: END IF; /* fnd_msg.... */
1099:
1100: fnd_msg_pub.count_and_get(
1101: p_count => x_msg_count,

Line 1100: fnd_msg_pub.count_and_get(

1096: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1097: fnd_msg_pub.add_exc_msg(g_pkg_name, l_proc_name, SQLERRM);
1098: END IF; /* fnd_msg.... */
1099:
1100: fnd_msg_pub.count_and_get(
1101: p_count => x_msg_count,
1102: p_data => x_msg_data
1103: );
1104: --x_error_code := SQLCODE;

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

3938:
3939: EXCEPTION
3940: WHEN fnd_api.g_exc_error THEN
3941: x_return_status := fnd_api.g_ret_sts_error;
3942: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
3943: DEBUG(' Exception occured at l_progress = ' || l_progress || ' during ' || to_char(SYSDATE, 'YYYY-MM-DD HH:DD:SS'),l_proc_name,1);
3944: DEBUG(SQLERRM,l_proc_name,1);
3945:
3946: IF c_all_mmtt_cursor%ISOPEN THEN

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

3951:
3952:
3953: WHEN fnd_api.g_exc_unexpected_error THEN
3954: x_return_status := fnd_api.g_ret_sts_unexp_error;
3955: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
3956:
3957: DEBUG(' Exception occured at l_progress = ' || l_progress || ' during ' || to_char(SYSDATE, 'YYYY-MM-DD HH:DD:SS'),l_proc_name,1);
3958: DEBUG(SQLERRM,l_proc_name,1);
3959:

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

3965:
3966:
3967: WHEN OTHERS THEN
3968: x_return_status := fnd_api.g_ret_sts_unexp_error;
3969: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
3970: DEBUG(' Exception occured at l_progress = ' || l_progress || ' during ' || to_char(SYSDATE, 'YYYY-MM-DD HH:DD:SS'),l_proc_name,1);
3971: DEBUG(SQLERRM,l_proc_name,1);
3972:
3973: IF c_all_mmtt_cursor%ISOPEN THEN

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

4112:
4113: EXCEPTION
4114: WHEN fnd_api.g_exc_error THEN
4115: x_return_status := fnd_api.g_ret_sts_error;
4116: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
4117: DEBUG(' Exception occured at l_progress = ' || l_progress || ' during ' || to_char(SYSDATE, 'YYYY-MM-DD HH:DD:SS'),l_proc_name,1);
4118: DEBUG(SQLERRM,l_proc_name,1);
4119:
4120: IF c_all_mmtt_cursor%ISOPEN THEN

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

4125:
4126:
4127: WHEN fnd_api.g_exc_unexpected_error THEN
4128: x_return_status := fnd_api.g_ret_sts_unexp_error;
4129: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
4130:
4131: DEBUG(' Exception occured at l_progress = ' || l_progress || ' during ' || to_char(SYSDATE, 'YYYY-MM-DD HH:DD:SS'),l_proc_name,1);
4132: DEBUG(SQLERRM,l_proc_name,1);
4133:

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

4139:
4140:
4141: WHEN OTHERS THEN
4142: x_return_status := fnd_api.g_ret_sts_unexp_error;
4143: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
4144: DEBUG(' Exception occured at l_progress = ' || l_progress || ' during ' || to_char(SYSDATE, 'YYYY-MM-DD HH:DD:SS'),l_proc_name,1);
4145: DEBUG(SQLERRM,l_proc_name,1);
4146:
4147: IF c_all_mmtt_cursor%ISOPEN THEN

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

4271:
4272: EXCEPTION
4273: WHEN fnd_api.g_exc_error THEN
4274: x_return_status := fnd_api.g_ret_sts_error;
4275: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
4276: DEBUG(' Exception occured at l_progress = ' || l_progress || ' during ' || to_char(SYSDATE, 'YYYY-MM-DD HH:DD:SS'),l_proc_name,1);
4277: DEBUG(SQLERRM,l_proc_name,1);
4278:
4279: WHEN fnd_api.g_exc_unexpected_error THEN

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

4277: DEBUG(SQLERRM,l_proc_name,1);
4278:
4279: WHEN fnd_api.g_exc_unexpected_error THEN
4280: x_return_status := fnd_api.g_ret_sts_unexp_error;
4281: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
4282: DEBUG(' Exception occured at l_progress = ' || l_progress || ' during ' || to_char(SYSDATE, 'YYYY-MM-DD HH:DD:SS'),l_proc_name,1);
4283: DEBUG(SQLERRM,l_proc_name,1);
4284:
4285: WHEN OTHERS THEN

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

4283: DEBUG(SQLERRM,l_proc_name,1);
4284:
4285: WHEN OTHERS THEN
4286: x_return_status := fnd_api.g_ret_sts_unexp_error;
4287: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
4288: DEBUG(' Exception occured at l_progress = ' || l_progress || ' during ' || to_char(SYSDATE, 'YYYY-MM-DD HH:DD:SS'),l_proc_name,1);
4289: DEBUG(SQLERRM,l_proc_name,1);
4290:
4291: END Complete_ATF_Load;

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

4553:
4554: EXCEPTION
4555: WHEN fnd_api.g_exc_error THEN
4556: x_return_status := fnd_api.g_ret_sts_error;
4557: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
4558: DEBUG(' Exception occured at l_progress = ' || l_progress || ' during ' || to_char(SYSDATE, 'YYYY-MM-DD HH:DD:SS'),l_proc_name,1);
4559: DEBUG(SQLERRM,l_proc_name,1);
4560:
4561: IF c_all_tasks_cursor%ISOPEN THEN

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

4570:
4571:
4572: WHEN fnd_api.g_exc_unexpected_error THEN
4573: x_return_status := fnd_api.g_ret_sts_unexp_error;
4574: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
4575:
4576: DEBUG(' Exception occured at l_progress = ' || l_progress || ' during ' || to_char(SYSDATE, 'YYYY-MM-DD HH:DD:SS'),l_proc_name,1);
4577: DEBUG(SQLERRM,l_proc_name,1);
4578:

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

4588:
4589:
4590: WHEN OTHERS THEN
4591: x_return_status := fnd_api.g_ret_sts_unexp_error;
4592: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
4593: DEBUG(' Exception occured at l_progress = ' || l_progress || ' during ' || to_char(SYSDATE, 'YYYY-MM-DD HH:DD:SS'),l_proc_name,1);
4594: DEBUG(SQLERRM,l_proc_name,1);
4595:
4596: IF c_all_tasks_cursor%ISOPEN THEN

Line 4681: fnd_msg_pub.ADD;

4677: debug(' LPN Already locked by someone else', l_proc_name,1);
4678: x_return_status := fnd_api.g_ret_sts_error;
4679:
4680: fnd_message.set_name('WMS', 'WMS_LPN_UNAVAIL');
4681: fnd_msg_pub.ADD;
4682: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
4683:
4684: WHEN OTHERS THEN
4685: debug(' Exception while trying to lock LPN(s) ' || SQLERRM, l_proc_name,1);

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

4678: x_return_status := fnd_api.g_ret_sts_error;
4679:
4680: fnd_message.set_name('WMS', 'WMS_LPN_UNAVAIL');
4681: fnd_msg_pub.ADD;
4682: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
4683:
4684: WHEN OTHERS THEN
4685: debug(' Exception while trying to lock LPN(s) ' || SQLERRM, l_proc_name,1);
4686: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

4683:
4684: WHEN OTHERS THEN
4685: debug(' Exception while trying to lock LPN(s) ' || SQLERRM, l_proc_name,1);
4686: x_return_status := fnd_api.g_ret_sts_unexp_error;
4687: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
4688:
4689: END Lock_LPNs;
4690:
4691:

Line 4926: fnd_msg_pub.ADD;

4922: l_progress := '225';
4923: -- No Tasks found for the data passed
4924: -- Set error message and raise error handle it in exception block.
4925: FND_MESSAGE.SET_NAME('WMS','WMS_NO_TASKS');
4926: fnd_msg_pub.ADD;
4927: -- Instead of raising an error, return with success
4928: RETURN;
4929: END IF;
4930:

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

5210:
5211: EXCEPTION
5212: WHEN fnd_api.g_exc_error THEN
5213: x_return_status := fnd_api.g_ret_sts_error;
5214: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
5215: DEBUG(' Exception occured at l_progress = ' || l_progress || ' during ' || to_char(SYSDATE, 'YYYY-MM-DD HH:DD:SS'),l_proc_name,1);
5216: DEBUG(SQLERRM,l_proc_name,1);
5217:
5218: IF c_lpn_cursor%isopen THEN

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

5220: END IF;
5221:
5222: WHEN fnd_api.g_exc_unexpected_error THEN
5223: x_return_status := fnd_api.g_ret_sts_unexp_error;
5224: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
5225: DEBUG(' Exception occured at l_progress = ' || l_progress || ' during ' || to_char(SYSDATE, 'YYYY-MM-DD HH:DD:SS'),l_proc_name,1);
5226: DEBUG(SQLERRM,l_proc_name,1);
5227:
5228: IF c_lpn_cursor%isopen THEN

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

5231:
5232:
5233: WHEN OTHERS THEN
5234: x_return_status := fnd_api.g_ret_sts_unexp_error;
5235: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
5236: DEBUG(' Exception occured at l_progress = ' || l_progress || ' during ' || to_char(SYSDATE, 'YYYY-MM-DD HH:DD:SS'),l_proc_name,1);
5237: DEBUG(SQLERRM,l_proc_name,1);
5238:
5239: IF c_lpn_cursor%isopen THEN

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

5460: EXCEPTION
5461:
5462: WHEN fnd_api.g_exc_error THEN
5463: x_return_status := fnd_api.g_ret_sts_error;
5464: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
5465: DEBUG(' Exception occured at l_progress = ' || l_progress || ' during ' || to_char(SYSDATE, 'YYYY-MM-DD HH:DD:SS'),l_proc_name,1);
5466: DEBUG(SQLERRM,l_proc_name,1);
5467:
5468: IF c_all_mmtt_cursor%isopen THEN

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

5470: END IF;
5471:
5472: WHEN fnd_api.g_exc_unexpected_error THEN
5473: x_return_status := fnd_api.g_ret_sts_unexp_error;
5474: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
5475: DEBUG(' Exception occured at l_progress = ' || l_progress || ' during ' || to_char(SYSDATE, 'YYYY-MM-DD HH:DD:SS'),l_proc_name,1);
5476: DEBUG(SQLERRM,l_proc_name,1);
5477:
5478: IF c_all_mmtt_cursor%isopen THEN

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

5481:
5482:
5483: WHEN OTHERS THEN
5484: x_return_status := fnd_api.g_ret_sts_unexp_error;
5485: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
5486: DEBUG(' Exception occured at l_progress = ' || l_progress || ' during ' || to_char(SYSDATE, 'YYYY-MM-DD HH:DD:SS'),l_proc_name,1);
5487: DEBUG(SQLERRM,l_proc_name,1);
5488:
5489: IF c_all_mmtt_cursor%isopen THEN

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

5664:
5665: EXCEPTION
5666: WHEN fnd_api.g_exc_error THEN
5667: x_return_status := fnd_api.g_ret_sts_error;
5668: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
5669: DEBUG(' Exception occured at l_progress = ' || l_progress || ' during ' || to_char(SYSDATE, 'YYYY-MM-DD HH:DD:SS'),l_proc_name,1);
5670: DEBUG(SQLERRM,l_proc_name,1);
5671:
5672: IF c_mol_mmtt_cursor%ISOPEN THEN

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

5677:
5678:
5679: WHEN fnd_api.g_exc_unexpected_error THEN
5680: x_return_status := fnd_api.g_ret_sts_unexp_error;
5681: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
5682:
5683: DEBUG(' Exception occured at l_progress = ' || l_progress || ' during ' || to_char(SYSDATE, 'YYYY-MM-DD HH:DD:SS'),l_proc_name,1);
5684: DEBUG(SQLERRM,l_proc_name,1);
5685:

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

5691:
5692:
5693: WHEN OTHERS THEN
5694: x_return_status := fnd_api.g_ret_sts_unexp_error;
5695: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
5696: DEBUG(' Exception occured at l_progress = ' || l_progress || ' during ' || to_char(SYSDATE, 'YYYY-MM-DD HH:DD:SS'),l_proc_name,1);
5697: DEBUG(SQLERRM,l_proc_name,1);
5698:
5699: IF c_mol_mmtt_cursor%ISOPEN THEN

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

6361:
6362: EXCEPTION
6363: WHEN fnd_api.g_exc_error THEN
6364: x_return_status := fnd_api.g_ret_sts_error;
6365: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
6366: DEBUG(' Exception occured at l_progress = ' || l_progress || ' during ' || to_char(SYSDATE, 'YYYY-MM-DD HH:DD:SS'),l_proc_name,1);
6367: DEBUG(SQLERRM,l_proc_name,1);
6368:
6369: IF c_mol_mmtt_cursor%ISOPEN THEN

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

6379: END IF;
6380:
6381: WHEN fnd_api.g_exc_unexpected_error THEN
6382: x_return_status := fnd_api.g_ret_sts_unexp_error;
6383: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
6384:
6385: DEBUG(' Exception occured at l_progress = ' || l_progress || ' during ' || to_char(SYSDATE, 'YYYY-MM-DD HH:DD:SS'),l_proc_name,1);
6386: DEBUG(SQLERRM,l_proc_name,1);
6387:

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

6397: CLOSE c_all_mmtt_cursor;
6398: END IF;
6399: WHEN OTHERS THEN
6400: x_return_status := fnd_api.g_ret_sts_unexp_error;
6401: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
6402: DEBUG(' Exception occured at l_progress = ' || l_progress || ' during ' || to_char(SYSDATE, 'YYYY-MM-DD HH:DD:SS'),l_proc_name,1);
6403: DEBUG(SQLERRM,l_proc_name,1);
6404:
6405: IF c_mol_mmtt_cursor%ISOPEN THEN

Line 6611: fnd_msg_pub.ADD;

6607:
6608: IF (l_username IS NOT NULL) THEN
6609: fnd_message.set_name('WMS','WMS_PUTAWAY_LPN_LOCKED');
6610: fnd_message.set_token('USER',l_username);
6611: fnd_msg_pub.ADD;
6612: fnd_message.set_name('WMS','WMS_CONT_INVALID_LPN');
6613: fnd_msg_pub.ADD;
6614: END IF;
6615:

Line 6613: fnd_msg_pub.ADD;

6609: fnd_message.set_name('WMS','WMS_PUTAWAY_LPN_LOCKED');
6610: fnd_message.set_token('USER',l_username);
6611: fnd_msg_pub.ADD;
6612: fnd_message.set_name('WMS','WMS_CONT_INVALID_LPN');
6613: fnd_msg_pub.ADD;
6614: END IF;
6615:
6616: END IF;
6617: x_ret := 3; --return error

Line 6790: fnd_msg_pub.add ;

6786:
6787: IF ( l_invalid_cnt > 0 ) THEN
6788: x_ret := 3;
6789: fnd_message.set_name('INV', 'INV_LPN_ALLOCATED');
6790: fnd_msg_pub.add ;
6791: IF (l_debug = 1) THEN
6792: debug('check_lpn_validity: Error!!!, LPN is Allocated' );
6793: END IF;
6794: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 6806: fnd_msg_pub.add ;

6802:
6803: IF ( l_invalid_cnt > 0 ) THEN
6804: x_ret := 3;
6805: fnd_message.set_name('WMS', 'WMS_LPN_LOADED_ERROR');
6806: fnd_msg_pub.add ;
6807: IF (l_debug = 1) THEN
6808: debug('check_lpn_validity: Error!!!, LPN has loaded tasks ' );
6809: END IF;
6810: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 6977: fnd_msg_pub.ADD;

6973: AND wlpn.organization_id=p_org_id;
6974: IF l_lpn_context = WMS_CONTAINER_PUB.LPN_CONTEXT_PREGENERATED THEN
6975: debug('There is no LPN content available for this transaction.');
6976: fnd_message.set_name('WMS', 'WMS_LPN_UNAVAIL');
6977: fnd_msg_pub.ADD;
6978: x_return_status := fnd_api.g_ret_sts_unexp_error;
6979: x_ret := 3;
6980: RETURN;
6981: END IF;

Line 7116: -- FND_MSG_PUB.ADD;

7112:
7113: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
7114: -- IF x_msg_count = 0 THEN
7115: -- FND_MESSAGE.SET_NAME('WMS','WMS_LOG_EXCEPTION_FAIL');
7116: -- FND_MSG_PUB.ADD;
7117: -- END IF;
7118: RAISE FND_API.g_exc_unexpected_error;
7119:
7120: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 7123: -- FND_MSG_PUB.ADD;

7119:
7120: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
7121: -- IF x_msg_count = 0 THEN
7122: -- FND_MESSAGE.SET_NAME('WMS','WMS_LOG_EXCEPTION_FAIL');
7123: -- FND_MSG_PUB.ADD;
7124: -- END IF;
7125: RAISE FND_API.G_EXC_ERROR;
7126: END IF;
7127:

Line 7164: --fnd_msg_pub.initialize();

7160: IF (l_debug = 1) THEN
7161: debug('suggestions_pub: Before suggestions_csr ');
7162: debug('suggestions_pub: There is a WLC for lpn_id ' || p_lpn_id || ' that does not have an MMTT so preventing the putaway out');
7163: END IF;
7164: --fnd_msg_pub.initialize();
7165: fnd_message.set_name('WMS', 'WMS_INVLID_LPN_MOVE');
7166: fnd_msg_pub.ADD;
7167: ROLLBACK TO before_suggestions_pub_call;
7168: RAISE fnd_api.g_exc_error;

Line 7166: fnd_msg_pub.ADD;

7162: debug('suggestions_pub: There is a WLC for lpn_id ' || p_lpn_id || ' that does not have an MMTT so preventing the putaway out');
7163: END IF;
7164: --fnd_msg_pub.initialize();
7165: fnd_message.set_name('WMS', 'WMS_INVLID_LPN_MOVE');
7166: fnd_msg_pub.ADD;
7167: ROLLBACK TO before_suggestions_pub_call;
7168: RAISE fnd_api.g_exc_error;
7169: END IF;
7170: END IF;

Line 7175: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data =>

7171: --BUG12681832 End
7172:
7173:
7174: IF x_number_of_rows = 0 THEN
7175: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data =>
7176: l_msg_data);
7177: IF l_debug = 1 THEN
7178: debug('l_msg_count: ' || l_msg_count);
7179: debug('l_msg_data: ' || l_msg_data);

Line 7185: fnd_msg_pub.initialize();

7181:
7182: IF (l_msg_count IS NULL OR l_msg_count = 0) THEN
7183: -- use default message if there are no message on stack
7184: -- first reset message stack
7185: fnd_msg_pub.initialize();
7186: FND_MESSAGE.SET_NAME('WMS','WMS_ALLOCATE_FAIL');
7187: FND_MSG_PUB.ADD;
7188: ELSIF l_msg_count > 1 THEN
7189: FOR i IN 2 .. l_msg_count LOOP

Line 7187: FND_MSG_PUB.ADD;

7183: -- use default message if there are no message on stack
7184: -- first reset message stack
7185: fnd_msg_pub.initialize();
7186: FND_MESSAGE.SET_NAME('WMS','WMS_ALLOCATE_FAIL');
7187: FND_MSG_PUB.ADD;
7188: ELSIF l_msg_count > 1 THEN
7189: FOR i IN 2 .. l_msg_count LOOP
7190: fnd_msg_pub.delete_msg(i);
7191: END LOOP;

Line 7190: fnd_msg_pub.delete_msg(i);

7186: FND_MESSAGE.SET_NAME('WMS','WMS_ALLOCATE_FAIL');
7187: FND_MSG_PUB.ADD;
7188: ELSIF l_msg_count > 1 THEN
7189: FOR i IN 2 .. l_msg_count LOOP
7190: fnd_msg_pub.delete_msg(i);
7191: END LOOP;
7192: END IF;
7193: RAISE fnd_api.g_exc_error;
7194: END IF;

Line 7721: -- FND_MSG_PUB.ADD;

7717:
7718: IF l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
7719: -- IF (x_msg_count = 0) THEN
7720: -- FND_MESSAGE.SET_NAME('WMS','WMS_LOG_EXCEPTION_FAIL');
7721: -- FND_MSG_PUB.ADD;
7722: -- END IF;
7723: RAISE FND_API.g_exc_unexpected_error;
7724: ELSIF l_x_return_status = FND_API.G_RET_STS_ERROR THEN
7725: -- IF (x_msg_count = 0 ) THEN

Line 7727: -- FND_MSG_PUB.ADD;

7723: RAISE FND_API.g_exc_unexpected_error;
7724: ELSIF l_x_return_status = FND_API.G_RET_STS_ERROR THEN
7725: -- IF (x_msg_count = 0 ) THEN
7726: -- FND_MESSAGE.SET_NAME('WMS','WMS_LOG_EXCEPTION_FAIL');
7727: -- FND_MSG_PUB.ADD;
7728: -- END IF;
7729: RAISE FND_API.G_EXC_ERROR;
7730: END IF;
7731:

Line 7760: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data =>

7756: debug('l_discrepancy = ' || l_discrepancy, 'load_lpn', 9);
7757: END IF;
7758:
7759: IF l_discrepancy = 1 THEN
7760: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data =>
7761: l_msg_data);
7762: IF l_debug = 1 THEN
7763: debug('l_msg_count: ' || l_msg_count);
7764: debug('l_msg_data: ' || l_msg_data);

Line 7770: fnd_msg_pub.initialize();

7766:
7767: IF (l_msg_count IS NULL OR l_msg_count = 0) THEN
7768: -- use default message if there are no message on stack
7769: -- first reset message stack
7770: fnd_msg_pub.initialize();
7771: FND_MESSAGE.SET_NAME('WMS','WMS_ALLOCATE_FAIL');
7772: FND_MSG_PUB.ADD;
7773: ELSIF l_msg_count > 1 THEN
7774: FOR i IN 2 .. l_msg_count LOOP

Line 7772: FND_MSG_PUB.ADD;

7768: -- use default message if there are no message on stack
7769: -- first reset message stack
7770: fnd_msg_pub.initialize();
7771: FND_MESSAGE.SET_NAME('WMS','WMS_ALLOCATE_FAIL');
7772: FND_MSG_PUB.ADD;
7773: ELSIF l_msg_count > 1 THEN
7774: FOR i IN 2 .. l_msg_count LOOP
7775: fnd_msg_pub.delete_msg(i);
7776: END LOOP;

Line 7775: fnd_msg_pub.delete_msg(i);

7771: FND_MESSAGE.SET_NAME('WMS','WMS_ALLOCATE_FAIL');
7772: FND_MSG_PUB.ADD;
7773: ELSIF l_msg_count > 1 THEN
7774: FOR i IN 2 .. l_msg_count LOOP
7775: fnd_msg_pub.delete_msg(i);
7776: END LOOP;
7777: END IF;
7778:
7779: -- 6962664

Line 7844: fnd_msg_pub.ADD;

7840: IF (l_debug = 1) THEN
7841: DEBUG('There is no employee id tied to the user','load_lpn',9);
7842: END IF;
7843: fnd_message.set_name('WMS', 'WMS_NO_EMP_FOR_USR');
7844: fnd_msg_pub.ADD;
7845: RAISE fnd_api.g_exc_error;
7846: END;
7847:
7848: -- BEGIN DBI FIX

Line 7940: fnd_msg_pub.ADD;

7936: IF (l_debug = 1) THEN
7937: DEBUG('There is no employee id tied to the user','transfer_contents',9);
7938: END IF;
7939: fnd_message.set_name('WMS', 'WMS_NO_EMP_FOR_USR');
7940: fnd_msg_pub.ADD;
7941: RAISE fnd_api.g_exc_error;
7942: END;
7943: debug('Calling complete_atf_load for:'||p_from_lpn_id);
7944: DEBUG(' p_org_id => '||p_org_id, 'load_lpn',4);

Line 8072: fnd_msg_pub.ADD;

8068: inv_rcv_common_apis.init_startup_values(l_from_org);
8069: EXCEPTION
8070: WHEN NO_DATA_FOUND THEN
8071: fnd_message.set_name('INV', 'INV_RCV_PARAM');
8072: fnd_msg_pub.ADD;
8073: RAISE fnd_api.g_exc_error;
8074: END;
8075:
8076: l_progress := '2';

Line 8850: fnd_msg_pub.ADD;

8846: IF (l_debug = 1) THEN
8847: DEBUG('There is no employee id tied to the user','transfer_contents',9);
8848: END IF;
8849: fnd_message.set_name('WMS', 'WMS_NO_EMP_FOR_USR');
8850: fnd_msg_pub.ADD;
8851: RAISE fnd_api.g_exc_error;
8852: END;
8853:
8854: l_progress := '7';

Line 8878: fnd_msg_pub.ADD;

8874: DEBUG('from LPN not found in WMS_LICENSE_PLATE_NUMBERS',
8875: 'transfer_contents',9);
8876: END IF;
8877: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_LPN');
8878: fnd_msg_pub.ADD;
8879: RAISE fnd_api.g_exc_error;
8880: END;
8881:
8882: l_progress := '9';

Line 8904: fnd_msg_pub.ADD;

8900: DEBUG('INTO LPN not found in WMS_LICENSE_PLATE_NUMBERS',
8901: 'transfer_contents',9);
8902: END IF;
8903: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_LPN');
8904: fnd_msg_pub.ADD;
8905: RAISE fnd_api.g_exc_error;
8906: END;
8907:
8908: -- Set variable if sub/loc of toLPN is different from that of from LPN

Line 8937: fnd_msg_pub.ADD;

8933: DEBUG('Invalid context for from_lpn_id',
8934: 'transfer_contents', 9);
8935: END IF;
8936: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_LPN_CONTEXT');
8937: fnd_msg_pub.ADD;
8938: RAISE fnd_api.g_exc_error;
8939: END IF;
8940:
8941: l_progress := '30';

Line 9004: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data =>

9000:
9001: l_progress := '50';
9002:
9003: IF (l_count > 0) THEN
9004: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data =>
9005: l_msg_data);
9006: IF l_debug = 1 THEN
9007: debug('l_msg_count: ' || l_msg_count);
9008: debug('l_msg_data: ' || l_msg_data);

Line 9014: fnd_msg_pub.initialize();

9010:
9011: IF (l_msg_count IS NULL OR l_msg_count = 0) THEN
9012: -- use default message if there are no message on stack
9013: -- first reset message stack
9014: fnd_msg_pub.initialize();
9015: FND_MESSAGE.SET_NAME('WMS','WMS_ALLOCATE_FAIL');
9016: FND_MSG_PUB.ADD;
9017: ELSIF l_msg_count > 1 THEN
9018: FOR i IN 2 .. l_msg_count LOOP

Line 9016: FND_MSG_PUB.ADD;

9012: -- use default message if there are no message on stack
9013: -- first reset message stack
9014: fnd_msg_pub.initialize();
9015: FND_MESSAGE.SET_NAME('WMS','WMS_ALLOCATE_FAIL');
9016: FND_MSG_PUB.ADD;
9017: ELSIF l_msg_count > 1 THEN
9018: FOR i IN 2 .. l_msg_count LOOP
9019: fnd_msg_pub.delete_msg(i);
9020: END LOOP;

Line 9019: fnd_msg_pub.delete_msg(i);

9015: FND_MESSAGE.SET_NAME('WMS','WMS_ALLOCATE_FAIL');
9016: FND_MSG_PUB.ADD;
9017: ELSIF l_msg_count > 1 THEN
9018: FOR i IN 2 .. l_msg_count LOOP
9019: fnd_msg_pub.delete_msg(i);
9020: END LOOP;
9021: END IF;
9022: RAISE fnd_api.g_exc_error;
9023: END IF;

Line 9080: FND_MSG_PUB.ADD;

9076: IF (l_debug = 1) THEN
9077: debug('No MMTT returned!','transfer_contents',9);
9078: END IF;
9079: FND_MESSAGE.SET_NAME('WMS','WMS_ALLOCATE_FAIL');
9080: FND_MSG_PUB.ADD;
9081: RAISE fnd_api.g_exc_error;
9082: END IF;
9083: ELSE
9084: -- For inventory and wip, just query based on move_order_line_id

Line 10071: fnd_msg_pub.add;

10067:
10068: EXCEPTION
10069: WHEN OTHERS THEN
10070: fnd_message.set_name('WMS', 'WMS_TASK_ERROR');
10071: fnd_msg_pub.add;
10072: x_return_status := fnd_api.g_ret_sts_unexp_error;
10073: IF (l_debug = 1) THEN
10074: debug('Exception occured after l_progress ='|| l_progress, 'transfer_contents', 9);
10075: END IF;

Line 10688: fnd_msg_pub.add;

10684: IF (l_debug = 1) THEN
10685: DEBUG('Error fetching MMTTs for the current group. Cannot drop', l_proc_name, 1);
10686: END IF;
10687: fnd_message.set_name('WMS', 'WMS_TASK_ERROR');
10688: fnd_msg_pub.add;
10689: RAISE FND_API.G_EXC_ERROR;
10690: END;
10691: ELSE
10692: --For other drop types, the user would not be confirming quantity and uom

Line 11311: fnd_msg_pub.ADD;

11307: END IF;
11308:
11309: IF (l_temp_id_tbl.COUNT = 0) THEN
11310: fnd_message.set_name('WMS', 'WMS_TASK_ERROR');
11311: fnd_msg_pub.ADD;
11312: END IF;
11313:
11314: IF (p_drop_type = G_DT_ITEM_DROP) THEN
11315: --First get the total drop quantity in transaction uom

Line 11977: fnd_msg_pub.add;

11973: IF (l_debug = 1) THEN
11974: DEBUG('complete_putaway_wrapper: Encountered g_exc_error while calling receiving manager;'|| to_char(sysdate, 'YYYY-MM-DD HH:DD:SS'), 4);
11975: END IF;
11976: fnd_message.set_name('WMS', 'WMS_TD_TXNMGR_ERROR');
11977: fnd_msg_pub.add;
11978: RAISE FND_API.G_EXC_ERROR;
11979: END IF;
11980:
11981: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 11986: fnd_msg_pub.add;

11982: IF (l_debug = 1) THEN
11983: DEBUG('complete_putaway_wrapper: Encountered g_exc_unexp_error while calling receiving manager;'|| to_char(sysdate, 'YYYY-MM-DD HH:DD:SS'), 4);
11984: END IF;
11985: fnd_message.set_name('WMS', 'WMS_TD_TXNMGR_ERROR');
11986: fnd_msg_pub.add;
11987: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11988: END IF;
11989:
11990: /*************** For bug 7428404 *****************/

Line 12122: fnd_msg_pub.ADD;

12118: END IF;
12119:
12120: IF (l_txn_ret <> 0) THEN
12121: fnd_message.set_name('WMS', 'WMS_TD_TXNMGR_ERROR');
12122: fnd_msg_pub.ADD;
12123: RAISE fnd_api.g_exc_unexpected_error;
12124: END IF;
12125:
12126:

Line 12193: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

12189: DEBUG('complete_putaway_wrapper: G_EXC_ERROR ocurred after l_progress = ' || l_progress, l_proc_name);
12190: END IF;
12191:
12192: --Get message count and data
12193: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
12194:
12195: WHEN fnd_api.g_exc_unexpected_error THEN
12196: x_return_status := fnd_api.g_ret_sts_unexp_error;
12197:

Line 12224: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

12220: DEBUG('complete_putaway_wrapper: G_EXC_UNEXPECTED_ERROR ocurred after l_progress = ' || l_progress, l_proc_name);
12221: END IF;
12222:
12223: --Get message count and data
12224: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
12225:
12226: WHEN OTHERS THEN
12227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12228:

Line 12255: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

12251: DEBUG('complete_putaway_wrapper: OTHER EXCEPTION ' || SQLERRM || ' ocurred after l_progress = ' || l_progress, l_proc_name);
12252: END IF;
12253:
12254: --Get message count and data
12255: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
12256: IF SQLCODE IS NOT NULL THEN
12257: inv_mobile_helper_functions.sql_error('wms_putaway_utils_pvt.complete_putaway_wrapper',l_progress, SQLCODE);
12258: END IF;
12259:

Line 12430: FND_MSG_PUB.ADD;

12426: IF (l_debug = 1) THEN
12427: debug('Failure returned from wms_container_pub.create_lpn API','validate_into_lpn',9);
12428: END IF;
12429: FND_MESSAGE.SET_NAME('WMS', 'WMS_TD_CREATE_LPN_ERROR');
12430: FND_MSG_PUB.ADD;
12431: RAISE fnd_api.g_exc_error;
12432: END IF;
12433: l_progress := '60';
12434:

Line 12575: FND_MSG_PUB.ADD;

12571: IF (l_debug = 1) THEN
12572: debug('Into LPN validation failed!','validate_into_lpn',9);
12573: END IF;
12574: FND_MESSAGE.SET_NAME('WMS','WMS_NO_LPN_LOAD_ALLOWED');
12575: FND_MSG_PUB.ADD;
12576: RAISE fnd_api.g_exc_error;
12577: ELSE
12578: x_validation_passed := 'Y';
12579: IF (l_debug = 1) THEN

Line 12679: fnd_msg_pub.ADD;

12675: /* IF l_allowed = 'N' THEN
12676: x_return_status := fnd_api.g_ret_sts_error;
12677: x_validation_passed := 'N';
12678: fnd_message.set_name('WMS', 'WMS_LOOSE_TO_LPN');
12679: fnd_msg_pub.ADD;
12680: RETURN;
12681: END IF;*/--Commented for BUG#11769042
12682: END IF;
12683: --x_validation_passed := 'Y';--Commented for BUG#11769042

Line 12774: fnd_msg_pub.ADD;

12770: l_allowed := 'N';
12771: x_return_status := fnd_api.g_ret_sts_error;
12772: x_validation_passed := 'N';
12773: fnd_message.set_name('WMS', 'WMS_LOOSE_TO_LPN');
12774: fnd_msg_pub.ADD;
12775: RETURN;
12776: ELSE
12777: IF (l_debug = 1) THEN
12778: debug('Grouping does match','validate_into_lpn',9);

Line 13231: fnd_msg_pub.count_and_get(p_count => x_msg_count,

13227: ROLLBACK TO validate_lpn_sp;
13228: x_return_status := fnd_api.g_ret_sts_error;
13229: x_validation_passed := 'N';
13230: x_new_lpn_created := 'N';
13231: fnd_msg_pub.count_and_get(p_count => x_msg_count,
13232: p_data => x_msg_data);
13233: IF (l_debug = 1) THEN
13234: debug('Exiting validate_into_lpn - Execution error: ' ||
13235: l_progress ||' '|| TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'),'validate_into_lpn',9);

Line 13243: fnd_msg_pub.count_and_get(p_count => x_msg_count,

13239: ROLLBACK TO validate_lpn_sp;
13240: x_return_status := fnd_api.g_ret_sts_unexp_error;
13241: x_validation_passed := 'N';
13242: x_new_lpn_created := 'N';
13243: fnd_msg_pub.count_and_get(p_count => x_msg_count,
13244: p_data => x_msg_data);
13245: IF (l_debug = 1) THEN
13246: debug('Exiting validate_into_lpn - Unexpected error: ' ||
13247: l_progress ||' '|| TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'),'validate_into_lpn',9);

Line 13255: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

13251: ROLLBACK TO validate_lpn_sp;
13252: x_return_status := fnd_api.g_ret_sts_unexp_error;
13253: x_validation_passed := 'N';
13254: x_new_lpn_created := 'N';
13255: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
13256: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
13257: END IF;
13258: fnd_msg_pub.count_and_get(p_count => x_msg_count,
13259: p_data => x_msg_data);

Line 13256: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

13252: x_return_status := fnd_api.g_ret_sts_unexp_error;
13253: x_validation_passed := 'N';
13254: x_new_lpn_created := 'N';
13255: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
13256: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
13257: END IF;
13258: fnd_msg_pub.count_and_get(p_count => x_msg_count,
13259: p_data => x_msg_data);
13260: IF (l_debug = 1) THEN

Line 13258: fnd_msg_pub.count_and_get(p_count => x_msg_count,

13254: x_new_lpn_created := 'N';
13255: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
13256: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
13257: END IF;
13258: fnd_msg_pub.count_and_get(p_count => x_msg_count,
13259: p_data => x_msg_data);
13260: IF (l_debug = 1) THEN
13261: debug('Exiting validate_into_lpn - Others exception: ' ||
13262: l_progress ||' '|| TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'),'validate_into_lpn',9);

Line 13539: fnd_msg_pub.add;

13535: l_progress := 2 ;
13536:
13537: IF (cur_mtrl_wlc_qty_mismatch%FOUND) THEN
13538: fnd_message.set_name('WMS', 'WMS_MO_NOT_FOUND');
13539: fnd_msg_pub.add;
13540: RAISE fnd_api.g_exc_error;
13541:
13542: ELSE
13543: IF (l_debug = 1) THEN

Line 13564: fnd_msg_pub.add;

13560:
13561: IF (cur_wlc_without_mtrl%FOUND) THEN
13562: fnd_message.set_name('WMS', 'WMS_MO_NOT_FOUND');
13563: --fnd_message.set_token('LPN', l_lpn);
13564: fnd_msg_pub.add;
13565: RAISE fnd_api.g_exc_error;
13566: ELSE
13567: IF (l_debug = 1) THEN
13568: DEBUG(' Move order exis for the lpn_id. => '||p_lpn_id , 4);

Line 13586: fnd_msg_pub.add;

13582: l_progress := 4 ;
13583: IF cur_mtrl_wlpn_mismatch%FOUND THEN
13584: fnd_message.set_name('WMS', 'WMS_LPN_SUBLOC_MISMATCH');
13585: --fnd_message.set_token('LPN', l_lpn);
13586: fnd_msg_pub.add;
13587: RAISE fnd_api.g_exc_error;
13588: ELSE
13589: IF (l_debug = 1) THEN
13590: DEBUG(' There is no Sub-Inventory Mismatch between MTRL and WLC => '||p_lpn_id , 4);

Line 13617: fnd_msg_pub.add;

13613: l_cur_mtrl_wlc_lot_mismatch ;
13614: IF (cur_mtrl_wlc_lot_mismatch%found) THEN
13615: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_LOT');
13616: --fnd_message.set_token('LPN', l_lpn);
13617: fnd_msg_pub.add;
13618: RAISE fnd_api.g_exc_error;
13619:
13620: ELSE
13621: IF (l_debug = 1) THEN

Line 14176: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

14172: IF (l_debug = 1) THEN
14173: DEBUG('Expected Error at '||l_progress, l_proc_name,1);
14174: END IF;
14175:
14176: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
14177: fnd_msg_pub.add_exc_msg(g_pkg_name, l_proc_name, SQLERRM);
14178: END IF;
14179: x_return_status := fnd_api.g_ret_sts_error;
14180:

Line 14177: fnd_msg_pub.add_exc_msg(g_pkg_name, l_proc_name, SQLERRM);

14173: DEBUG('Expected Error at '||l_progress, l_proc_name,1);
14174: END IF;
14175:
14176: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
14177: fnd_msg_pub.add_exc_msg(g_pkg_name, l_proc_name, SQLERRM);
14178: END IF;
14179: x_return_status := fnd_api.g_ret_sts_error;
14180:
14181: IF c_all_mmtt_cursor%ISOPEN THEN

Line 14452: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

14448: EXCEPTION
14449: WHEN fnd_api.g_exc_error THEN
14450: ROLLBACK TO update_capacity_sp;
14451: x_return_status := fnd_api.g_ret_sts_error;
14452: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
14453:
14454: IF (l_debug = 1) THEN
14455: debug(
14456: 'Exiting update_loc_suggested_capacity - Execution error: ' || l_progress || ' '

Line 14463: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

14459: END IF;
14460: WHEN fnd_api.g_exc_unexpected_error THEN
14461: ROLLBACK TO update_capacity_sp;
14462: x_return_status := fnd_api.g_ret_sts_unexp_error;
14463: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
14464:
14465: IF (l_debug = 1) THEN
14466: debug(
14467: 'Exiting update_loc_suggested_capacity - Unexpected error: ' || l_progress || ' '

Line 14475: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

14471: WHEN OTHERS THEN
14472: ROLLBACK TO update_capacity_sp;
14473: x_return_status := fnd_api.g_ret_sts_unexp_error;
14474:
14475: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
14476: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
14477: END IF;
14478:
14479: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 14476: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

14472: ROLLBACK TO update_capacity_sp;
14473: x_return_status := fnd_api.g_ret_sts_unexp_error;
14474:
14475: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
14476: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
14477: END IF;
14478:
14479: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
14480:

Line 14479: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

14475: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
14476: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
14477: END IF;
14478:
14479: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
14480:
14481: IF (l_debug = 1) THEN
14482: debug(
14483: 'Exiting update_loc_suggested_capacity - Others exception: ' || l_progress || ' '