DBA Data[Home] [Help]

APPS.WMS_WIP_XDOCK_PVT dependencies on FND_MSG_PUB

Line 428: fnd_msg_pub.ADD;

424: END IF;
425:
426: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
427: fnd_message.set_name('WMS', 'WMS_TD_WIP_ERROR');
428: fnd_msg_pub.ADD;
429: RAISE fnd_api.g_exc_unexpected_error;
430: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
431: fnd_message.set_name('WMS', 'WMS_TD_WIP_ERROR');
432: fnd_msg_pub.ADD;

Line 432: fnd_msg_pub.ADD;

428: fnd_msg_pub.ADD;
429: RAISE fnd_api.g_exc_unexpected_error;
430: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
431: fnd_message.set_name('WMS', 'WMS_TD_WIP_ERROR');
432: fnd_msg_pub.ADD;
433: RAISE fnd_api.g_exc_error;
434: ELSIF(l_return_status = 'L') THEN
435: IF (l_debug = 1) THEN
436: mydebug('Unable to lock the record');

Line 509: fnd_msg_pub.ADD;

505: );
506:
507: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
508: fnd_message.set_name('WMS', 'WMS_TD_CMOL_ERROR');
509: fnd_msg_pub.ADD;
510: RAISE fnd_api.g_exc_unexpected_error;
511: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
512: fnd_message.set_name('WMS', 'WMS_TD_CMOL_ERROR');
513: fnd_msg_pub.ADD;

Line 513: fnd_msg_pub.ADD;

509: fnd_msg_pub.ADD;
510: RAISE fnd_api.g_exc_unexpected_error;
511: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
512: fnd_message.set_name('WMS', 'WMS_TD_CMOL_ERROR');
513: fnd_msg_pub.ADD;
514: RAISE fnd_api.g_exc_error;
515: END IF;
516: -- Need to fetch next del line
517: -- EXIT;

Line 552: fnd_msg_pub.ADD;

548: );
549:
550: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
551: fnd_message.set_name('WMS', 'WMS_TD_WIP_ERROR');
552: fnd_msg_pub.ADD;
553: RAISE fnd_api.g_exc_unexpected_error;
554: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
555: fnd_message.set_name('WMS', 'WMS_TD_WIP_ERROR');
556: fnd_msg_pub.ADD;

Line 556: fnd_msg_pub.ADD;

552: fnd_msg_pub.ADD;
553: RAISE fnd_api.g_exc_unexpected_error;
554: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
555: fnd_message.set_name('WMS', 'WMS_TD_WIP_ERROR');
556: fnd_msg_pub.ADD;
557: RAISE fnd_api.g_exc_error;
558: ELSIF(l_return_status = 'L') THEN
559: IF (l_debug = 1) THEN
560: mydebug('Unable to lock the record');

Line 636: fnd_msg_pub.ADD;

632: );
633:
634: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
635: fnd_message.set_name('WMS', 'WMS_TD_CMOL_ERROR');
636: fnd_msg_pub.ADD;
637: RAISE fnd_api.g_exc_unexpected_error;
638: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
639: fnd_message.set_name('WMS', 'WMS_TD_CMOL_ERROR');
640: fnd_msg_pub.ADD;

Line 640: fnd_msg_pub.ADD;

636: fnd_msg_pub.ADD;
637: RAISE fnd_api.g_exc_unexpected_error;
638: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
639: fnd_message.set_name('WMS', 'WMS_TD_CMOL_ERROR');
640: fnd_msg_pub.ADD;
641: RAISE fnd_api.g_exc_error;
642: END IF;
643:
644: IF (l_debug = 1) THEN

Line 710: fnd_msg_pub.ADD;

706: );
707:
708: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
709: fnd_message.set_name('WMS', 'WMS_TD_WIP_ERROR');
710: fnd_msg_pub.ADD;
711: RAISE fnd_api.g_exc_unexpected_error;
712: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
713: fnd_message.set_name('WMS', 'WMS_TD_WIP_ERROR');
714: fnd_msg_pub.ADD;

Line 714: fnd_msg_pub.ADD;

710: fnd_msg_pub.ADD;
711: RAISE fnd_api.g_exc_unexpected_error;
712: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
713: fnd_message.set_name('WMS', 'WMS_TD_WIP_ERROR');
714: fnd_msg_pub.ADD;
715: RAISE fnd_api.g_exc_error;
716: ELSIF(l_return_status = 'L') THEN
717: IF (l_debug = 1) THEN
718: mydebug('Unable to lock the record');

Line 791: fnd_msg_pub.ADD;

787: );
788:
789: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
790: fnd_message.set_name('WMS', 'WMS_TD_CMOL_ERROR');
791: fnd_msg_pub.ADD;
792: RAISE fnd_api.g_exc_unexpected_error;
793: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
794: fnd_message.set_name('WMS', 'WMS_TD_CMOL_ERROR');
795: fnd_msg_pub.ADD;

Line 795: fnd_msg_pub.ADD;

791: fnd_msg_pub.ADD;
792: RAISE fnd_api.g_exc_unexpected_error;
793: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
794: fnd_message.set_name('WMS', 'WMS_TD_CMOL_ERROR');
795: fnd_msg_pub.ADD;
796: RAISE fnd_api.g_exc_error;
797: END IF;
798:
799: IF (l_debug = 1) THEN

Line 833: fnd_msg_pub.ADD;

829: wms_task_dispatch_put_away.crdk_wip_info_table(indx).wip_issue_flag := l_wip_issue_flag;
830:
831: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
832: fnd_message.set_name('WMS', 'WMS_TD_MK_DEL_ERROR');
833: fnd_msg_pub.ADD;
834: RAISE fnd_api.g_exc_unexpected_error;
835: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
836: fnd_message.set_name('WMS', 'WMS_TD_MK_DEL_ERROR');
837: fnd_msg_pub.ADD;

Line 837: fnd_msg_pub.ADD;

833: fnd_msg_pub.ADD;
834: RAISE fnd_api.g_exc_unexpected_error;
835: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
836: fnd_message.set_name('WMS', 'WMS_TD_MK_DEL_ERROR');
837: fnd_msg_pub.ADD;
838: RAISE fnd_api.g_exc_error;
839: END IF;
840: -- Qty's match. Pick release the delivery detail
841: --l_lpn_qty:=0;

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

866: EXCEPTION
867: WHEN fnd_api.g_exc_error THEN
868: x_ret := 2;
869: x_return_status := l_return_status;
870: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
871: WHEN fnd_api.g_exc_unexpected_error THEN
872: x_ret := 2;
873: x_return_status := l_return_status;
874: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

870: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
871: WHEN fnd_api.g_exc_unexpected_error THEN
872: x_ret := 2;
873: x_return_status := l_return_status;
874: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
875: WHEN OTHERS THEN
876: x_ret := 2;
877: x_return_status := l_return_status;
878: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

874: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
875: WHEN OTHERS THEN
876: x_ret := 2;
877: x_return_status := l_return_status;
878: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
879: END wip_chk_crossdock;
880:
881: PROCEDURE wip_complete_crossdock(
882: p_org_id IN NUMBER

Line 1189: fnd_msg_pub.ADD;

1185: END IF;
1186:
1187: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1188: fnd_message.set_name('WMS', 'WMS_TD_TXNMGR_ERROR');
1189: fnd_msg_pub.ADD;
1190: RAISE fnd_api.g_exc_unexpected_error;
1191: END IF;
1192: --Changed call above to WIP
1193: --l_txn_ret:=inv_lpn_trx_pub.PROCESS_LPN_TRX(p_trx_hdr_id=>l_new_txn_hdr_id,

Line 1204: --fND_MSG_PUB.ADD;

1200:
1201: --COMMIT;
1202: --IF l_txn_ret<>0 THEN
1203: --FND_MESSAGE.SET_NAME('WMS','WMS_TD_TXNMGR_ERROR' );
1204: --fND_MSG_PUB.ADD;
1205: -- RAISE FND_API.g_exc_unexpected_error;
1206: --END IF;
1207: ELSE
1208: -- Bug 2829872, triggering label printing for Manufacturing Cross-Dock.

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

1255: EXCEPTION
1256: WHEN fnd_api.g_exc_error THEN
1257: x_return_status := fnd_api.g_ret_sts_error;
1258: -- Get message count and data
1259: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1260: WHEN fnd_api.g_exc_unexpected_error THEN
1261: x_return_status := fnd_api.g_ret_sts_unexp_error;
1262: -- Get message count and data
1263: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

1259: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1260: WHEN fnd_api.g_exc_unexpected_error THEN
1261: x_return_status := fnd_api.g_ret_sts_unexp_error;
1262: -- Get message count and data
1263: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1264: WHEN OTHERS THEN
1265: x_return_status := fnd_api.g_ret_sts_unexp_error;
1266: fnd_message.set_name('WMS', 'WMS_TD_CCDOCK_ERROR');
1267: fnd_msg_pub.ADD;

Line 1267: fnd_msg_pub.ADD;

1263: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1264: WHEN OTHERS THEN
1265: x_return_status := fnd_api.g_ret_sts_unexp_error;
1266: fnd_message.set_name('WMS', 'WMS_TD_CCDOCK_ERROR');
1267: fnd_msg_pub.ADD;
1268: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1269: END wip_complete_crossdock;
1270:
1271: PROCEDURE mark_wip(

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

1264: WHEN OTHERS THEN
1265: x_return_status := fnd_api.g_ret_sts_unexp_error;
1266: fnd_message.set_name('WMS', 'WMS_TD_CCDOCK_ERROR');
1267: fnd_msg_pub.ADD;
1268: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1269: END wip_complete_crossdock;
1270:
1271: PROCEDURE mark_wip(
1272: p_line_id IN NUMBER

Line 1349: fnd_msg_pub.ADD;

1345: END IF;
1346:
1347: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1348: fnd_message.set_name('WMS', 'WMS_TD_UPD_SHP_ERROR');
1349: fnd_msg_pub.ADD;
1350: RAISE fnd_api.g_exc_unexpected_error;
1351: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1352: fnd_message.set_name('WMS', 'WMS_TD_UPD_SHP_ERROR');
1353: fnd_msg_pub.ADD;

Line 1353: fnd_msg_pub.ADD;

1349: fnd_msg_pub.ADD;
1350: RAISE fnd_api.g_exc_unexpected_error;
1351: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1352: fnd_message.set_name('WMS', 'WMS_TD_UPD_SHP_ERROR');
1353: fnd_msg_pub.ADD;
1354: RAISE fnd_api.g_exc_error;
1355: END IF;
1356:
1357: --x_ret:=l_ret;

Line 1377: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);

1373: WHEN fnd_api.g_exc_error THEN
1374: x_return_status := fnd_api.g_ret_sts_error;
1375: --x_return_status:=l_return_status;
1376: -- Get message count and data
1377: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);
1378: WHEN fnd_api.g_exc_unexpected_error THEN
1379: x_return_status := fnd_api.g_ret_sts_unexp_error;
1380: -- x_return_status:=l_return_status;
1381: -- Get message count and data

Line 1382: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);

1378: WHEN fnd_api.g_exc_unexpected_error THEN
1379: x_return_status := fnd_api.g_ret_sts_unexp_error;
1380: -- x_return_status:=l_return_status;
1381: -- Get message count and data
1382: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);
1383: WHEN OTHERS THEN
1384: x_return_status := fnd_api.g_ret_sts_unexp_error;
1385: --x_return_status:=l_return_status;
1386: fnd_message.set_name('WMS', 'WMS_TD_MW_ERROR');

Line 1387: fnd_msg_pub.ADD;

1383: WHEN OTHERS THEN
1384: x_return_status := fnd_api.g_ret_sts_unexp_error;
1385: --x_return_status:=l_return_status;
1386: fnd_message.set_name('WMS', 'WMS_TD_MW_ERROR');
1387: fnd_msg_pub.ADD;
1388: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);
1389: END mark_wip;
1390:
1391: PROCEDURE insert_new_mmtt_row_like(p_txn_temp_id IN NUMBER, x_new_temp_id OUT NOCOPY NUMBER, x_new_hdr_id OUT NOCOPY NUMBER) IS

Line 1388: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);

1384: x_return_status := fnd_api.g_ret_sts_unexp_error;
1385: --x_return_status:=l_return_status;
1386: fnd_message.set_name('WMS', 'WMS_TD_MW_ERROR');
1387: fnd_msg_pub.ADD;
1388: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);
1389: END mark_wip;
1390:
1391: PROCEDURE insert_new_mmtt_row_like(p_txn_temp_id IN NUMBER, x_new_temp_id OUT NOCOPY NUMBER, x_new_hdr_id OUT NOCOPY NUMBER) IS
1392: SUBTYPE mmtt_type IS mtl_material_transactions_temp%ROWTYPE;