DBA Data[Home] [Help]

APPS.INV_REPLENISH_DETAIL_PUB dependencies on FND_MESSAGE

Line 264: fnd_message.set_name('INV', 'INV_AUTO_PICK_CONFIRM_PARAM');

260: FROM mtl_parameters
261: WHERE organization_id = l_trolin_tbl(1).organization_id;
262: EXCEPTION
263: WHEN NO_DATA_FOUND THEN
264: fnd_message.set_name('INV', 'INV_AUTO_PICK_CONFIRM_PARAM');
265: fnd_msg_pub.ADD;
266: RAISE fnd_api.g_exc_unexpected_error;
267: END;
268:

Line 284: fnd_message.set_name('INV', 'INV_AUTO_PICK_CONFIRM_PARAM');

280: END IF;
281:
282: EXCEPTION
283: WHEN NO_DATA_FOUND THEN
284: fnd_message.set_name('INV', 'INV_AUTO_PICK_CONFIRM_PARAM');
285: fnd_msg_pub.ADD;
286: RAISE fnd_api.g_exc_unexpected_error;
287: END;
288: END IF;

Line 360: fnd_message.set_name('INV', 'INV_DETAILING_FAILED');

356: END IF;
357:
358: --No rows allocated
359: IF (l_detail_rec_count <= 0 AND l_auto_pick_flag = 'Y') THEN
360: fnd_message.set_name('INV', 'INV_DETAILING_FAILED');
361: fnd_message.set_token('LINE_NUM', l_trolin_tbl(1).line_number);
362: fnd_message.set_token('MO_NUMBER', l_request_number);
363: fnd_msg_pub.ADD;
364: RAISE fnd_api.g_exc_error;

Line 361: fnd_message.set_token('LINE_NUM', l_trolin_tbl(1).line_number);

357:
358: --No rows allocated
359: IF (l_detail_rec_count <= 0 AND l_auto_pick_flag = 'Y') THEN
360: fnd_message.set_name('INV', 'INV_DETAILING_FAILED');
361: fnd_message.set_token('LINE_NUM', l_trolin_tbl(1).line_number);
362: fnd_message.set_token('MO_NUMBER', l_request_number);
363: fnd_msg_pub.ADD;
364: RAISE fnd_api.g_exc_error;
365: END IF;

Line 362: fnd_message.set_token('MO_NUMBER', l_request_number);

358: --No rows allocated
359: IF (l_detail_rec_count <= 0 AND l_auto_pick_flag = 'Y') THEN
360: fnd_message.set_name('INV', 'INV_DETAILING_FAILED');
361: fnd_message.set_token('LINE_NUM', l_trolin_tbl(1).line_number);
362: fnd_message.set_token('MO_NUMBER', l_request_number);
363: fnd_msg_pub.ADD;
364: RAISE fnd_api.g_exc_error;
365: END IF;
366:

Line 391: fnd_message.set_name('INV', 'INV_PICK_RELEASE_ERROR');

387: l_mold_tbl_temp := l_mold_tbl;
388:
389: IF (l_mold_tbl.COUNT = 0) THEN
390: l_return_status := fnd_api.g_ret_sts_unexp_error;
391: fnd_message.set_name('INV', 'INV_PICK_RELEASE_ERROR');
392: fnd_msg_pub.ADD;
393: RAISE fnd_api.g_exc_unexpected_error;
394: ELSE
395: IF (l_debug = 1) THEN

Line 598: fnd_message.set_name('WMS', 'WMS_PRINT_LABEL_FAIL');

594: IF ( l_return_status <> fnd_api.g_ret_sts_success ) THEN
595: IF (l_debug = 1) THEN
596: print_debug('failed to print labels');
597: END IF;
598: fnd_message.set_name('WMS', 'WMS_PRINT_LABEL_FAIL');
599: fnd_msg_pub.ADD;
600: END IF;
601: END IF;
602: EXCEPTION

Line 607: fnd_message.set_name('WMS', 'WMS_PRINT_LABEL_FAIL');

603: WHEN OTHERS THEN
604: IF (l_debug = 1) THEN
605: print_debug('Exception occured while calling print_label');
606: END IF;
607: fnd_message.set_name('WMS', 'WMS_PRINT_LABEL_FAIL');
608: fnd_msg_pub.ADD;
609: END;
610: END IF;
611: --End Bug 6696594

Line 929: --fnd_message.debug('copying project_id and task_id from tolines_blk to mtl_Trx_line');

925: FROM mtl_material_transactions_temp
926: WHERE transaction_temp_id = p_transaction_temp_id;
927:
928: IF (l_transaction_action_id = 1) THEN
929: --fnd_message.debug('copying project_id and task_id from tolines_blk to mtl_Trx_line');
930:
931: SELECT project_id
932: , task_id
933: INTO l_project_id

Line 1428: fnd_message.set_name('INV', 'SPLIT_LINE_DETAIL_ERROR');

1424: END IF;
1425: EXCEPTION
1426: WHEN fnd_api.g_exc_error THEN
1427: x_return_status := fnd_api.g_ret_sts_error;
1428: fnd_message.set_name('INV', 'SPLIT_LINE_DETAIL_ERROR');
1429: fnd_msg_pub.ADD;
1430: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1431: WHEN fnd_api.g_exc_unexpected_error THEN
1432: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1433: fnd_message.set_name('INV', 'SPLIT_LINE_DETAIL_ERROR');

1429: fnd_msg_pub.ADD;
1430: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1431: WHEN fnd_api.g_exc_unexpected_error THEN
1432: x_return_status := fnd_api.g_ret_sts_unexp_error;
1433: fnd_message.set_name('INV', 'SPLIT_LINE_DETAIL_ERROR');
1434: fnd_msg_pub.ADD;
1435: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1436: WHEN OTHERS THEN
1437: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1495: fnd_message.set_name('INV', 'AUTO_PICK_CONFIRM_ERROR');

1491: x_return_status := l_return_status;
1492: EXCEPTION
1493: WHEN fnd_api.g_exc_error THEN
1494: x_return_status := fnd_api.g_ret_sts_error;
1495: fnd_message.set_name('INV', 'AUTO_PICK_CONFIRM_ERROR');
1496: fnd_msg_pub.ADD;
1497: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1498: WHEN fnd_api.g_exc_unexpected_error THEN
1499: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1500: fnd_message.set_name('INV', 'AUTO_PICK_CONFIRM_ERROR');

1496: fnd_msg_pub.ADD;
1497: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1498: WHEN fnd_api.g_exc_unexpected_error THEN
1499: x_return_status := fnd_api.g_ret_sts_unexp_error;
1500: fnd_message.set_name('INV', 'AUTO_PICK_CONFIRM_ERROR');
1501: fnd_msg_pub.ADD;
1502: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1503: WHEN OTHERS THEN
1504: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2039: fnd_message.set_name('INV', 'INV_MO_LOCKED_SO');

2035: NULL;
2036: END LOOP;
2037: EXCEPTION
2038: WHEN record_locked THEN
2039: fnd_message.set_name('INV', 'INV_MO_LOCKED_SO');
2040: fnd_msg_pub.ADD;
2041: RAISE fnd_api.g_exc_error;
2042: END;
2043:

Line 2682: fnd_message.set_name('INV', 'INV_OVERSHIP_TOLERANCE');

2678: print_debug('OVPK: pickedQty is not within overship tolerance level');
2679: print_debug('OVPK: Erroring out');
2680: END IF;
2681:
2682: fnd_message.set_name('INV', 'INV_OVERSHIP_TOLERANCE');
2683: x_ovpk_error_code := 3;
2684: fnd_msg_pub.ADD;
2685: RAISE fnd_api.g_exc_error;
2686: ELSIF (l_max_qty_allowed2 <> -1

Line 2694: fnd_message.set_name('INV', 'INV_OVERSHIP_TOLERANCE');

2690: print_debug('OVPK: pickedQty is not within overship tolerance level');
2691: print_debug('OVPK: Erroring out');
2692: END IF;
2693:
2694: fnd_message.set_name('INV', 'INV_OVERSHIP_TOLERANCE');
2695: x_ovpk_error_code := 3;
2696: fnd_msg_pub.ADD;
2697: RAISE fnd_api.g_exc_error;
2698:

Line 2728: fnd_message.set_name('INV', 'INV_LACK_MTRL_TO_OVERPICK');

2724: print_debug('OVPK: Not enough material to pick in Sub/Loc/Lot/LPN');
2725: print_debug('OVPK: Erroring out');
2726: END IF;
2727:
2728: fnd_message.set_name('INV', 'INV_LACK_MTRL_TO_OVERPICK');
2729: x_ovpk_error_code := 2;
2730: fnd_msg_pub.ADD;
2731: RAISE fnd_api.g_exc_error;*/
2732: --END IF;

Line 2740: fnd_message.set_name('INV', 'INV_OVERPICK_NOT_ALLOWED');

2736: print_debug('OVPK: Overpicking is not allowed in this org and for this Move Order type');
2737: print_debug('OVPK: Erroring out');
2738: END IF;
2739:
2740: fnd_message.set_name('INV', 'INV_OVERPICK_NOT_ALLOWED');
2741: x_ovpk_error_code := 1;
2742: fnd_msg_pub.ADD;
2743: RAISE fnd_api.g_exc_error;
2744: END IF;

Line 2998: fnd_message.set_name('INV', 'INV_OVERSHIP_TOLERANCE');

2994: print_debug('OVPK: pickedQty is not within overship tolerance level');
2995: print_debug('OVPK: Erroring out');
2996: END IF;
2997:
2998: fnd_message.set_name('INV', 'INV_OVERSHIP_TOLERANCE');
2999: x_ovpk_error_code := 3;
3000: fnd_msg_pub.ADD;
3001: RAISE fnd_api.g_exc_error;
3002: ELSE

Line 3031: fnd_message.set_name('INV', 'INV_LACK_MTRL_TO_OVERPICK');

3027: print_debug('OVPK: Not enough material to pick in Sub/Loc/Lot/LPN');
3028: print_debug('OVPK: Erroring out');
3029: END IF;
3030:
3031: fnd_message.set_name('INV', 'INV_LACK_MTRL_TO_OVERPICK');
3032: x_ovpk_error_code := 2;
3033: fnd_msg_pub.ADD;
3034: RAISE fnd_api.g_exc_error;
3035: END IF;

Line 3043: fnd_message.set_name('INV', 'INV_OVERPICK_NOT_ALLOWED');

3039: print_debug('OVPK: Overpicking is not allowed in this org and for this Move Order type');
3040: print_debug('OVPK: Erroring out');
3041: END IF;
3042:
3043: fnd_message.set_name('INV', 'INV_OVERPICK_NOT_ALLOWED');
3044: x_ovpk_error_code := 1;
3045: fnd_msg_pub.ADD;
3046: RAISE fnd_api.g_exc_error;
3047: END IF;

Line 3700: fnd_message.set_name('INV', 'INV_OVERSHIP_TOLERANCE');

3696: print_debug('OVPK: pickedQty is not within overship tolerance level');
3697: print_debug('OVPK: Erroring out');
3698: END IF;
3699:
3700: fnd_message.set_name('INV', 'INV_OVERSHIP_TOLERANCE');
3701: x_ovpk_error_code := 3;
3702: fnd_msg_pub.ADD;
3703: RAISE fnd_api.g_exc_error;
3704: ELSIF (l_max_qty_allowed2 <> -1

Line 3712: fnd_message.set_name('INV', 'INV_OVERSHIP_TOLERANCE');

3708: print_debug('OVPK: pickedQty2 is not within overship tolerance level');
3709: print_debug('OVPK: Erroring out');
3710: END IF;
3711:
3712: fnd_message.set_name('INV', 'INV_OVERSHIP_TOLERANCE');
3713: x_ovpk_error_code := 3;
3714: fnd_msg_pub.ADD;
3715: RAISE fnd_api.g_exc_error;
3716: ELSE

Line 3746: fnd_message.set_name('INV', 'INV_LACK_MTRL_TO_OVERPICK');

3742: print_debug('OVPK: Not enough material to pick in Sub/Loc/Lot/LPN');
3743: print_debug('OVPK: Erroring out');
3744: END IF;
3745:
3746: fnd_message.set_name('INV', 'INV_LACK_MTRL_TO_OVERPICK');
3747: x_ovpk_error_code := 2;
3748: fnd_msg_pub.ADD;
3749: RAISE fnd_api.g_exc_error;
3750: END IF;*/

Line 3758: fnd_message.set_name('INV', 'INV_OVERPICK_NOT_ALLOWED');

3754: print_debug('OVPK: Overpicking is not allowed in this org and for this Move Order type');
3755: print_debug('OVPK: Erroring out');
3756: END IF;
3757:
3758: fnd_message.set_name('INV', 'INV_OVERPICK_NOT_ALLOWED');
3759: x_ovpk_error_code := 1;
3760: fnd_msg_pub.ADD;
3761: RAISE fnd_api.g_exc_error;
3762: END IF;