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.INV_LOT_TRX_VALIDATION_PVT dependencies on FND_MSG_PUB

Line 509: fnd_msg_pub.ADD;

505: EXCEPTION
506: WHEN NO_DATA_FOUND
507: THEN
508: fnd_message.set_name ('INV', 'INV_INT_ITEM_CODE');
509: fnd_msg_pub.ADD;
510: RAISE fnd_api.g_exc_error;
511: END;
512: IF (l_start_primary_uom <> l_mti_csr.transaction_uom)
513: THEN

Line 538: fnd_msg_pub.ADD;

534: fnd_message.set_name ('INV', 'INV-CANNOT CONVERT');
535: fnd_message.set_token ('UOM', l_mti_csr.transaction_uom);
536: fnd_message.set_token ('ROUTINE'
537: , g_pkg_name || 'Validate_Quantity');
538: fnd_msg_pub.ADD;
539: x_validation_status := 'N';
540: RAISE fnd_api.g_exc_unexpected_error;
541: END IF;
542: ELSE

Line 895: fnd_msg_pub.ADD;

891:
892: IF (l_serial_diff = -1)
893: THEN
894: fnd_message.set_name ('INV', 'INV_INVALID_SERIAL_RANGE');
895: fnd_msg_pub.ADD;
896: RAISE fnd_api.g_exc_unexpected_error;
897: END IF;
898:
899: FOR i IN 1 .. l_serial_diff

Line 927: fnd_msg_pub.ADD;

923: IF(per_serial_msn_src_csr%ISOPEN) THEN
924: CLOSE per_serial_msn_src_csr;
925: END IF;
926: fnd_message.set_name('INV', 'INVALID_SERIAL_NUMBER');
927: fnd_msg_pub.ADD;
928: RAISE NO_DATA_FOUND;
929: END IF;
930:
931:

Line 953: fnd_msg_pub.ADD;

949:
950: IF (l_old_serial = l_next_serial)
951: THEN
952: fnd_message.set_name ('INV', 'INVALID_SERIAL_NUMBER');
953: fnd_msg_pub.ADD;
954: RAISE fnd_api.g_exc_unexpected_error;
955: END IF;
956: END LOOP;
957: END LOOP;

Line 996: fnd_msg_pub.ADD;

992:
993: IF (l_serial_diff = -1)
994: THEN
995: fnd_message.set_name ('INV', 'INV_INVALID_SERIAL_RANGE');
996: fnd_msg_pub.ADD;
997: RAISE fnd_api.g_exc_unexpected_error;
998: END IF;
999:
1000: FOR i IN 1 .. l_serial_diff

Line 1026: fnd_msg_pub.ADD;

1022: IF(per_serial_msn_csr%ISOPEN) THEN
1023: CLOSE per_serial_msn_csr;
1024: END IF;
1025: fnd_message.set_name('INV', 'INVALID_SERIAL_NUMBER');
1026: fnd_msg_pub.ADD;
1027: RAISE NO_DATA_FOUND;
1028: END IF;
1029:
1030: l_rs_ser_status_tbl.EXTEND (1);

Line 1053: fnd_msg_pub.ADD;

1049:
1050: IF (l_next_serial = l_old_serial)
1051: THEN
1052: fnd_message.set_name ('INV', 'INVALID_SERIAL_NUMBER');
1053: fnd_msg_pub.ADD;
1054: RAISE fnd_api.g_exc_unexpected_error;
1055: END IF;
1056: END LOOP;
1057: END LOOP;

Line 1542: fnd_msg_pub.ADD;

1538: EXCEPTION
1539: WHEN OTHERS
1540: THEN
1541: fnd_message.set_name ('INV', 'INV_INVALID_LOT');
1542: fnd_msg_pub.ADD;
1543: RAISE fnd_api.g_exc_unexpected_error;
1544: END;
1545:
1546: /*Bug:5354721. Moved the following code to get_lot_Attr_table where all the

Line 1748: fnd_msg_pub.ADD;

1744: EXCEPTION
1745: WHEN OTHERS
1746: THEN
1747: fnd_message.set_name ('WMS', 'WMS_GET_LOT_ATTR_ERROR');
1748: fnd_msg_pub.ADD;
1749:
1750: -- FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1751: IF (l_debug = 1)
1752: THEN

Line 1750: -- FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

1746: THEN
1747: fnd_message.set_name ('WMS', 'WMS_GET_LOT_ATTR_ERROR');
1748: fnd_msg_pub.ADD;
1749:
1750: -- FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1751: IF (l_debug = 1)
1752: THEN
1753: print_debug ('SQL : ' || SUBSTR (SQLERRM, 1, 200)
1754: , 'get_lot_attr_record'

Line 1828: fnd_msg_pub.ADD;

1824: EXCEPTION
1825: WHEN OTHERS
1826: THEN
1827: fnd_message.set_name ('WMS', 'WMS_UPDATE_ATTR_ERROR');
1828: fnd_msg_pub.ADD;
1829:
1830: -- FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1831: IF (l_debug = 1)
1832: THEN

Line 1830: -- FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

1826: THEN
1827: fnd_message.set_name ('WMS', 'WMS_UPDATE_ATTR_ERROR');
1828: fnd_msg_pub.ADD;
1829:
1830: -- FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1831: IF (l_debug = 1)
1832: THEN
1833: print_debug ('SQL : ' || SUBSTR (SQLERRM, 1, 200)
1834: , 'get_lot_attr_record'

Line 2039: fnd_msg_pub.ADD;

2035: print_debug ('Validation failed on wsm/wms install'
2036: , 'Validate_lot_Split_Trx'
2037: );
2038: fnd_message.set_name ('WMS', 'WMS_NOT_INSTALLED');
2039: fnd_msg_pub.ADD;
2040: RAISE fnd_api.g_exc_error;
2041: END IF;
2042: */
2043: IF (l_debug = 1)

Line 2063: fnd_msg_pub.ADD;

2059: EXCEPTION
2060: WHEN OTHERS
2061: THEN
2062: fnd_message.set_name ('INV', 'INV_RETRIEVE_PERIOD');
2063: fnd_msg_pub.ADD;
2064: RAISE fnd_api.g_exc_unexpected_error;
2065: END;
2066:
2067: IF ( x_return_status <> fnd_api.g_ret_sts_success

Line 2109: fnd_msg_pub.ADD;

2105: print_debug ('breadcrumb 80', 'validate_lot_split_trx');
2106: END IF;
2107:
2108: fnd_message.set_name ('WMS', 'WMS_VALIDATE_LOT_ERROR');
2109: fnd_msg_pub.ADD;
2110: RAISE fnd_api.g_exc_unexpected_error;
2111: END;
2112:
2113: IF ( x_return_status <> fnd_api.g_ret_sts_success

Line 2166: fnd_msg_pub.ADD;

2162: print_debug ('breadcrumb 110', 'validate_lot_split_trx');
2163: END IF;
2164:
2165: fnd_message.set_name ('WMS', 'WMS_VALIDATE_STATUS_ERROR');
2166: fnd_msg_pub.ADD;
2167: fnd_msg_pub.count_and_get (p_count => x_msg_count
2168: , p_data => x_msg_data
2169: );
2170: RAISE fnd_api.g_exc_unexpected_error;

Line 2167: fnd_msg_pub.count_and_get (p_count => x_msg_count

2163: END IF;
2164:
2165: fnd_message.set_name ('WMS', 'WMS_VALIDATE_STATUS_ERROR');
2166: fnd_msg_pub.ADD;
2167: fnd_msg_pub.count_and_get (p_count => x_msg_count
2168: , p_data => x_msg_data
2169: );
2170: RAISE fnd_api.g_exc_unexpected_error;
2171: END;

Line 2194: fnd_msg_pub.ADD;

2190: print_debug ('breadcrumb 120', 'validate_lot_split_trx');
2191: END IF;
2192:
2193: fnd_message.set_name ('WMS', 'WMS_VALIDATE_STATUS_ERROR');
2194: fnd_msg_pub.ADD;
2195: fnd_msg_pub.count_and_get (p_count => x_msg_count
2196: , p_data => x_msg_data);
2197: RAISE fnd_api.g_exc_error;
2198: END IF;

Line 2195: fnd_msg_pub.count_and_get (p_count => x_msg_count

2191: END IF;
2192:
2193: fnd_message.set_name ('WMS', 'WMS_VALIDATE_STATUS_ERROR');
2194: fnd_msg_pub.ADD;
2195: fnd_msg_pub.count_and_get (p_count => x_msg_count
2196: , p_data => x_msg_data);
2197: RAISE fnd_api.g_exc_error;
2198: END IF;
2199:

Line 2214: fnd_msg_pub.ADD;

2210: print_debug ('breadcrumb 130', 'validate_lot_split_trx');
2211: END IF;
2212:
2213: fnd_message.set_name ('INV', 'INV_INT_TRX_TYPE');
2214: fnd_msg_pub.ADD;
2215: RAISE fnd_api.g_exc_unexpected_error;
2216: WHEN OTHERS
2217: THEN
2218: IF (l_debug = 1)

Line 2224: fnd_msg_pub.ADD;

2220: print_debug ('breadcrumb 140', 'validate_lot_split_trx');
2221: END IF;
2222:
2223: fnd_message.set_name ('INV', 'INV_INT_TRX_TYPE');
2224: fnd_msg_pub.ADD;
2225: RAISE fnd_api.g_exc_unexpected_error;
2226: END;
2227:
2228: IF (l_debug = 1)

Line 2272: fnd_msg_pub.ADD;

2268: print_debug ('breadcrumb 160', 'validate_lot_split_trx');
2269: END IF;
2270:
2271: fnd_message.set_name ('WMS', 'VALIDATE_COST_GROUP_ERROR');
2272: fnd_msg_pub.ADD;
2273: RAISE fnd_api.g_exc_unexpected_error;
2274: END;
2275:
2276: IF (x_return_status <> fnd_api.g_ret_sts_success)

Line 2348: fnd_msg_pub.ADD;

2344: );
2345: END IF;
2346:
2347: fnd_message.set_name ('WMS', 'WMS_VALIDATE_QUANTITY_ERROR');
2348: fnd_msg_pub.ADD;
2349: RAISE fnd_api.g_exc_unexpected_error;
2350: END;
2351:
2352: IF ( x_return_status <> fnd_api.g_ret_sts_success

Line 2398: fnd_msg_pub.ADD;

2394: );
2395: END IF;
2396:
2397: fnd_message.set_name ('INV', 'INV_INT_LPN');
2398: fnd_msg_pub.ADD;
2399: RAISE fnd_api.g_exc_unexpected_error;
2400: END;
2401:
2402: IF ( x_return_status <> fnd_api.g_ret_sts_success

Line 2469: fnd_msg_pub.ADD;

2465: END IF;
2466:
2467: l_validation_status := 'N';
2468: fnd_message.set_name ('INV', 'INV_SERIAL_INFO_MISSING');
2469: fnd_msg_pub.ADD;
2470: RAISE fnd_api.g_exc_error;
2471: ELSE
2472: BEGIN
2473: IF (l_debug = 1)

Line 2516: fnd_msg_pub.ADD;

2512: END IF;
2513:
2514: l_validation_status := 'N';
2515: fnd_message.set_name ('INV', 'INV_FAIL_VALIDATE_SERIAL');
2516: fnd_msg_pub.ADD;
2517: RAISE fnd_api.g_exc_unexpected_error;
2518: END;
2519:
2520: IF ( x_return_status <> fnd_api.g_ret_sts_success

Line 2553: fnd_msg_pub.ADD;

2549: END IF;
2550:
2551: l_validation_status := 'N';
2552: fnd_message.set_name ('INV', 'INV_FAIL_VALIDATE_SERIAL');
2553: fnd_msg_pub.ADD;
2554: RAISE fnd_api.g_exc_unexpected_error;
2555: END;
2556:
2557: /*Bug:5354721. The following procedure populates the column name, type and

Line 2577: fnd_msg_pub.ADD;

2573: EXCEPTION
2574: WHEN OTHERS
2575: THEN
2576: fnd_message.set_name ('WMS', 'WMS_GET_LOT_ATTR_ERROR');
2577: fnd_msg_pub.ADD;
2578: l_validation_status := 'N';
2579: RAISE fnd_api.g_exc_unexpected_error;
2580: END;
2581:

Line 2608: fnd_msg_pub.ADD;

2604: EXCEPTION
2605: WHEN OTHERS
2606: THEN
2607: fnd_message.set_name ('WMS', 'WMS_GET_LOT_ATTR_ERROR');
2608: fnd_msg_pub.ADD;
2609: l_validation_status := 'N';
2610: RAISE fnd_api.g_exc_unexpected_error;
2611: END;
2612:

Line 2640: fnd_msg_pub.ADD;

2636: EXCEPTION
2637: WHEN OTHERS
2638: THEN
2639: fnd_message.set_name ('WMS', 'WMS_VALIDATE_ATTR_ERROR');
2640: fnd_msg_pub.ADD;
2641: RAISE fnd_api.g_exc_unexpected_error;
2642: END;
2643:
2644: IF ( x_return_status <> fnd_api.g_ret_sts_success

Line 2695: fnd_msg_pub.ADD;

2691: EXCEPTION
2692: WHEN OTHERS
2693: THEN
2694: fnd_message.set_name ('INV', 'INV_LOT_EXP_COMPUTE_ERROR');
2695: fnd_msg_pub.ADD;
2696: RAISE fnd_api.g_exc_unexpected_error;
2697: END;
2698:
2699: IF (x_return_status <> fnd_api.g_ret_sts_success)

Line 2702: fnd_msg_pub.ADD;

2698:
2699: IF (x_return_status <> fnd_api.g_ret_sts_success)
2700: THEN
2701: fnd_message.set_name ('INV', 'INV_LOT_EXP_COMPUTE_ERROR');
2702: fnd_msg_pub.ADD;
2703: l_validation_status := 'N';
2704: RAISE fnd_api.g_exc_error;
2705: END IF;
2706:

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

2706:
2707: -- if we reach here, it means all validations are successfull
2708: x_return_status := fnd_api.g_ret_sts_success;
2709: x_validation_status := 'Y';
2710: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2711: EXCEPTION
2712: WHEN fnd_api.g_exc_error
2713: THEN
2714: x_return_status := fnd_api.g_ret_sts_error;

Line 2716: fnd_msg_pub.count_and_get (p_count => x_msg_count

2712: WHEN fnd_api.g_exc_error
2713: THEN
2714: x_return_status := fnd_api.g_ret_sts_error;
2715: x_validation_status := l_validation_status;
2716: fnd_msg_pub.count_and_get (p_count => x_msg_count
2717: , p_data => x_msg_data);
2718: WHEN fnd_api.g_exc_unexpected_error
2719: THEN
2720: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2722: fnd_msg_pub.count_and_get (p_count => x_msg_count

2718: WHEN fnd_api.g_exc_unexpected_error
2719: THEN
2720: x_return_status := fnd_api.g_ret_sts_unexp_error;
2721: x_validation_status := l_validation_status;
2722: fnd_msg_pub.count_and_get (p_count => x_msg_count
2723: , p_data => x_msg_data);
2724: WHEN OTHERS
2725: THEN
2726: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2729: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

2725: THEN
2726: x_return_status := fnd_api.g_ret_sts_unexp_error;
2727: x_validation_status := 'E';
2728:
2729: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2730: THEN
2731: fnd_msg_pub.add_exc_msg (g_pkg_name, 'Validate_Lot_Split_Trx');
2732: END IF;
2733:

Line 2731: fnd_msg_pub.add_exc_msg (g_pkg_name, 'Validate_Lot_Split_Trx');

2727: x_validation_status := 'E';
2728:
2729: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2730: THEN
2731: fnd_msg_pub.add_exc_msg (g_pkg_name, 'Validate_Lot_Split_Trx');
2732: END IF;
2733:
2734: fnd_msg_pub.count_and_get (p_count => x_msg_count
2735: , p_data => x_msg_data);

Line 2734: fnd_msg_pub.count_and_get (p_count => x_msg_count

2730: THEN
2731: fnd_msg_pub.add_exc_msg (g_pkg_name, 'Validate_Lot_Split_Trx');
2732: END IF;
2733:
2734: fnd_msg_pub.count_and_get (p_count => x_msg_count
2735: , p_data => x_msg_data);
2736: END validate_lot_split_trx;
2737:
2738: PROCEDURE validate_lot_merge_trx (

Line 2920: fnd_msg_pub.ADD;

2916: print_debug ('Validation failed on wsm/wms install'
2917: , 'Validate_lot_Split_Trx'
2918: );
2919: fnd_message.set_name ('WMS', 'WMS_NOT_INSTALLED');
2920: fnd_msg_pub.ADD;
2921: l_validation_status := 'N';
2922: RAISE fnd_api.g_exc_error;
2923: END IF;
2924: */

Line 2944: fnd_msg_pub.ADD;

2940: EXCEPTION
2941: WHEN OTHERS
2942: THEN
2943: fnd_message.set_name ('INV', 'INV_RETRIEVE_PERIOD');
2944: fnd_msg_pub.ADD;
2945: l_validation_status := 'N';
2946: RAISE fnd_api.g_exc_unexpected_error;
2947: END;
2948:

Line 3038: fnd_msg_pub.ADD;

3034: OR l_validation_status <> 'Y'
3035: )
3036: THEN
3037: fnd_message.set_name ('WMS', 'WMS_VALIDATE_STATUS_ERROR');
3038: fnd_msg_pub.ADD;
3039: RAISE fnd_api.g_exc_error;
3040: END IF;
3041: END LOOP;
3042:

Line 3052: fnd_msg_pub.ADD;

3048: EXCEPTION
3049: WHEN NO_DATA_FOUND
3050: THEN
3051: fnd_message.set_name ('INV', 'INV_INT_TRX_TYPE');
3052: fnd_msg_pub.ADD;
3053: l_validation_status := 'N';
3054: RAISE fnd_api.g_exc_unexpected_error;
3055: WHEN OTHERS
3056: THEN

Line 3058: fnd_msg_pub.ADD;

3054: RAISE fnd_api.g_exc_unexpected_error;
3055: WHEN OTHERS
3056: THEN
3057: fnd_message.set_name ('INV', 'INV_INT_TRX_TYPE');
3058: fnd_msg_pub.ADD;
3059: l_validation_status := 'E';
3060: RAISE fnd_api.g_exc_unexpected_error;
3061: END;
3062:

Line 3198: fnd_msg_pub.ADD;

3194: );
3195: END IF;
3196:
3197: fnd_message.set_name ('INV', 'INV_INT_LPN');
3198: fnd_msg_pub.ADD;
3199: RAISE fnd_api.g_exc_unexpected_error;
3200: END;
3201:
3202: IF ( x_return_status <> fnd_api.g_ret_sts_success

Line 3261: fnd_msg_pub.ADD;

3257: END IF;
3258:
3259: l_validation_status := 'N';
3260: fnd_message.set_name ('INV', 'INV_SERIAL_INFO_MISSING');
3261: fnd_msg_pub.ADD;
3262: RAISE fnd_api.g_exc_error;
3263: ELSE
3264: BEGIN
3265: IF (l_debug = 1)

Line 3308: fnd_msg_pub.ADD;

3304: END IF;
3305:
3306: l_validation_status := 'N';
3307: fnd_message.set_name ('INV', 'INV_FAIL_VALIDATE_SERIAL');
3308: fnd_msg_pub.ADD;
3309: RAISE fnd_api.g_exc_unexpected_error;
3310: END;
3311:
3312: IF ( x_return_status <> fnd_api.g_ret_sts_success

Line 3339: fnd_msg_pub.ADD;

3335: END IF;
3336:
3337: l_validation_status := 'N';
3338: fnd_message.set_name ('INV', 'INV_FAIL_VALIDATE_SERIAL');
3339: fnd_msg_pub.ADD;
3340: RAISE fnd_api.g_exc_unexpected_error;
3341: END;
3342:
3343: /***** Check for the representative Lot and if it is populated

Line 3480: fnd_msg_pub.ADD;

3476: EXCEPTION
3477: WHEN OTHERS
3478: THEN
3479: fnd_message.set_name ('INV', 'INV_LOT_EXP_COMPUTE_ERROR');
3480: fnd_msg_pub.ADD;
3481: RAISE fnd_api.g_exc_unexpected_error;
3482: END;
3483:
3484: IF (x_return_status <> fnd_api.g_ret_sts_success)

Line 3487: fnd_msg_pub.ADD;

3483:
3484: IF (x_return_status <> fnd_api.g_ret_sts_success)
3485: THEN
3486: fnd_message.set_name ('INV', 'INV_LOT_EXP_COMPUTE_ERROR');
3487: fnd_msg_pub.ADD;
3488: l_validation_status := 'N';
3489: RAISE fnd_api.g_exc_error;
3490: END IF;
3491:

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

3491:
3492: -- if we reach here, it means all validations are successfull
3493: x_return_status := fnd_api.g_ret_sts_success;
3494: x_validation_status := 'Y';
3495: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3496: EXCEPTION
3497: WHEN fnd_api.g_exc_error
3498: THEN
3499: x_return_status := fnd_api.g_ret_sts_error;

Line 3501: fnd_msg_pub.count_and_get (p_count => x_msg_count

3497: WHEN fnd_api.g_exc_error
3498: THEN
3499: x_return_status := fnd_api.g_ret_sts_error;
3500: x_validation_status := l_validation_status;
3501: fnd_msg_pub.count_and_get (p_count => x_msg_count
3502: , p_data => x_msg_data);
3503: WHEN fnd_api.g_exc_unexpected_error
3504: THEN
3505: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 3507: fnd_msg_pub.count_and_get (p_count => x_msg_count

3503: WHEN fnd_api.g_exc_unexpected_error
3504: THEN
3505: x_return_status := fnd_api.g_ret_sts_unexp_error;
3506: x_validation_status := l_validation_status;
3507: fnd_msg_pub.count_and_get (p_count => x_msg_count
3508: , p_data => x_msg_data);
3509: WHEN OTHERS
3510: THEN
3511: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 3514: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

3510: THEN
3511: x_return_status := fnd_api.g_ret_sts_unexp_error;
3512: x_validation_status := 'E';
3513:
3514: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
3515: THEN
3516: fnd_msg_pub.add_exc_msg (g_pkg_name, 'validate_lot_merge_trx');
3517: END IF;
3518:

Line 3516: fnd_msg_pub.add_exc_msg (g_pkg_name, 'validate_lot_merge_trx');

3512: x_validation_status := 'E';
3513:
3514: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
3515: THEN
3516: fnd_msg_pub.add_exc_msg (g_pkg_name, 'validate_lot_merge_trx');
3517: END IF;
3518:
3519: fnd_msg_pub.count_and_get (p_count => x_msg_count
3520: , p_data => x_msg_data);

Line 3519: fnd_msg_pub.count_and_get (p_count => x_msg_count

3515: THEN
3516: fnd_msg_pub.add_exc_msg (g_pkg_name, 'validate_lot_merge_trx');
3517: END IF;
3518:
3519: fnd_msg_pub.count_and_get (p_count => x_msg_count
3520: , p_data => x_msg_data);
3521: END validate_lot_merge_trx;
3522:
3523: PROCEDURE validate_lot_translate_trx (

Line 3724: fnd_msg_pub.ADD;

3720: print_debug ('Validation failed on wsm/wms install'
3721: , 'Validate_lot_translate'
3722: );
3723: fnd_message.set_name ('WMS', 'WMS_NOT_INSTALLED');
3724: fnd_msg_pub.ADD;
3725: l_validation_status := 'N';
3726: RAISE fnd_api.g_exc_error;
3727: END IF;
3728: */

Line 3755: fnd_msg_pub.ADD;

3751: );
3752: END IF;
3753:
3754: fnd_message.set_name ('INV', 'INV_RETRIEVE_PERIOD');
3755: fnd_msg_pub.ADD;
3756: l_validation_status := 'N';
3757: RAISE fnd_api.g_exc_unexpected_error;
3758: END;
3759:

Line 3826: fnd_msg_pub.ADD;

3822: EXCEPTION
3823: WHEN NO_DATA_FOUND
3824: THEN
3825: fnd_message.set_name ('INV', 'INV_NO_DIST_ACCOUNT_ID');
3826: fnd_msg_pub.ADD;
3827:
3828: IF (l_debug = 1)
3829: THEN
3830: print_debug ('INV_NO_DIST_ACCOUNT_ID : ' || SQLERRM

Line 3848: fnd_msg_pub.ADD;

3844: );
3845: END IF;
3846:
3847: fnd_message.set_name ('WMS', 'WMS_NOT_INSTALLED');
3848: fnd_msg_pub.ADD;
3849: l_validation_status := 'N';
3850: RAISE fnd_api.g_exc_error;
3851: END IF;*/
3852: ELSE

Line 3862: fnd_msg_pub.ADD;

3858: EXCEPTION
3859: WHEN NO_DATA_FOUND
3860: THEN
3861: fnd_message.set_name ('INV', 'INV_NO_DIST_ACCOUNT_ID');
3862: fnd_msg_pub.ADD;
3863:
3864: IF (l_debug = 1)
3865: THEN
3866: print_debug ('INV_NO_DIST_ACCOUNT_ID : ' || SQLERRM

Line 3884: fnd_msg_pub.ADD;

3880: print_debug ('Distribution account id is null'
3881: , 'Validate_lot_translate'
3882: );
3883: fnd_message.set_name ('INV', 'INV_NO_DIST_ACCOUNT_ID');
3884: fnd_msg_pub.ADD;
3885: l_validation_status := 'N';
3886: x_return_status := fnd_api.g_ret_sts_error;
3887: RAISE fnd_api.g_exc_error;
3888: END IF;

Line 3990: fnd_msg_pub.ADD;

3986: OR l_validation_status <> 'Y'
3987: )
3988: THEN
3989: fnd_message.set_name ('WMS', 'WMS_VALIDATE_STATUS_ERROR');
3990: fnd_msg_pub.ADD;
3991: RAISE fnd_api.g_exc_error;
3992: END IF;
3993:
3994: BEGIN

Line 4003: fnd_msg_pub.ADD;

3999: EXCEPTION
4000: WHEN NO_DATA_FOUND
4001: THEN
4002: fnd_message.set_name ('INV', 'INV_INT_TRX_TYPE');
4003: fnd_msg_pub.ADD;
4004: l_validation_status := 'N';
4005: RAISE fnd_api.g_exc_unexpected_error;
4006: WHEN OTHERS
4007: THEN

Line 4009: fnd_msg_pub.ADD;

4005: RAISE fnd_api.g_exc_unexpected_error;
4006: WHEN OTHERS
4007: THEN
4008: fnd_message.set_name ('INV', 'INV_INT_TRX_TYPE');
4009: fnd_msg_pub.ADD;
4010: l_validation_status := 'E';
4011: RAISE fnd_api.g_exc_unexpected_error;
4012: END;
4013:

Line 4156: fnd_msg_pub.ADD;

4152: );
4153: END IF;
4154:
4155: fnd_message.set_name ('INV', 'INV_INT_LPN');
4156: fnd_msg_pub.ADD;
4157: RAISE fnd_api.g_exc_unexpected_error;
4158: END;
4159:
4160: IF ( x_return_status <> fnd_api.g_ret_sts_success

Line 4220: fnd_msg_pub.ADD;

4216: END IF;
4217:
4218: l_validation_status := 'N';
4219: fnd_message.set_name ('INV', 'INV_SERIAL_INFO_MISSING');
4220: fnd_msg_pub.ADD;
4221: RAISE fnd_api.g_exc_error;
4222: ELSE
4223: BEGIN
4224: IF (l_debug = 1)

Line 4266: fnd_msg_pub.ADD;

4262: END IF;
4263:
4264: l_validation_status := 'N';
4265: fnd_message.set_name ('INV', 'INV_FAIL_VALIDATE_SERIAL');
4266: fnd_msg_pub.ADD;
4267: RAISE fnd_api.g_exc_unexpected_error;
4268: END;
4269:
4270: IF ( x_return_status <> fnd_api.g_ret_sts_success

Line 4297: fnd_msg_pub.ADD;

4293: END IF;
4294:
4295: l_validation_status := 'N';
4296: fnd_message.set_name ('INV', 'INV_FAIL_VALIDATE_SERIAL');
4297: fnd_msg_pub.ADD;
4298: RAISE fnd_api.g_exc_error;
4299: END;
4300:
4301: /*Bug:5354721. The following procedure populates the column name, type and

Line 4409: fnd_msg_pub.ADD;

4405: EXCEPTION
4406: WHEN OTHERS
4407: THEN
4408: fnd_message.set_name ('INV', 'INV_LOT_EXP_COMPUTE_ERROR');
4409: fnd_msg_pub.ADD;
4410: l_validation_status := 'N';
4411: RAISE fnd_api.g_exc_unexpected_error;
4412: END;
4413:

Line 4417: fnd_msg_pub.ADD;

4413:
4414: IF (x_return_status <> fnd_api.g_ret_sts_success)
4415: THEN
4416: fnd_message.set_name ('INV', 'INV_LOT_EXP_COMPUTE_ERROR');
4417: fnd_msg_pub.ADD;
4418: l_validation_status := 'N';
4419: RAISE fnd_api.g_exc_error;
4420: END IF;
4421:

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

4421:
4422: -- if we reach here, it means all validations are successfull
4423: x_return_status := fnd_api.g_ret_sts_success;
4424: x_validation_status := 'Y';
4425: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
4426: EXCEPTION
4427: WHEN fnd_api.g_exc_error
4428: THEN
4429: x_return_status := fnd_api.g_ret_sts_error;

Line 4431: fnd_msg_pub.count_and_get (p_count => x_msg_count

4427: WHEN fnd_api.g_exc_error
4428: THEN
4429: x_return_status := fnd_api.g_ret_sts_error;
4430: x_validation_status := l_validation_status;
4431: fnd_msg_pub.count_and_get (p_count => x_msg_count
4432: , p_data => x_msg_data);
4433: WHEN fnd_api.g_exc_unexpected_error
4434: THEN
4435: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 4437: fnd_msg_pub.count_and_get (p_count => x_msg_count

4433: WHEN fnd_api.g_exc_unexpected_error
4434: THEN
4435: x_return_status := fnd_api.g_ret_sts_unexp_error;
4436: x_validation_status := l_validation_status;
4437: fnd_msg_pub.count_and_get (p_count => x_msg_count
4438: , p_data => x_msg_data);
4439: WHEN OTHERS
4440: THEN
4441: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 4444: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

4440: THEN
4441: x_return_status := fnd_api.g_ret_sts_unexp_error;
4442: x_validation_status := 'E';
4443:
4444: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
4445: THEN
4446: fnd_msg_pub.add_exc_msg (g_pkg_name, 'validate_lot_translate_trx');
4447: END IF;
4448:

Line 4446: fnd_msg_pub.add_exc_msg (g_pkg_name, 'validate_lot_translate_trx');

4442: x_validation_status := 'E';
4443:
4444: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
4445: THEN
4446: fnd_msg_pub.add_exc_msg (g_pkg_name, 'validate_lot_translate_trx');
4447: END IF;
4448:
4449: fnd_msg_pub.count_and_get (p_count => x_msg_count
4450: , p_data => x_msg_data);

Line 4449: fnd_msg_pub.count_and_get (p_count => x_msg_count

4445: THEN
4446: fnd_msg_pub.add_exc_msg (g_pkg_name, 'validate_lot_translate_trx');
4447: END IF;
4448:
4449: fnd_msg_pub.count_and_get (p_count => x_msg_count
4450: , p_data => x_msg_data);
4451: END validate_lot_translate_trx;
4452: END inv_lot_trx_validation_pvt;