DBA Data[Home] [Help]

APPS.GME_MATERIAL_DETAIL_PVT dependencies on FND_MSG_PUB

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

304: gme_debug.put_line (g_pkg_name||'.'||l_api_name|| ': '
305: || l_proc|| 'Dispensing error returned ');
306: END IF;
307: WHEN OTHERS THEN
308: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
309: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
310: gme_debug.put_line ('Unexpected error: '||g_pkg_name||'.'||l_api_name||': '||SQLERRM);
311: END IF;
312: x_return_status := FND_API.g_ret_sts_unexp_error;

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

362: EXCEPTION
363: WHEN validation_error THEN
364: x_return_status := fnd_api.g_ret_sts_error;
365: WHEN OTHERS THEN
366: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
367: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
368: gme_debug.put_line ('Unexpected error: '||g_pkg_name||'.'||l_api_name||': '||SQLERRM);
369: END IF;
370: x_return_status := FND_API.g_ret_sts_unexp_error;

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

825: gme_debug.put_line (g_pkg_name||'.'||l_api_name||': validation error from proc: '|| l_val_proc);
826: END IF;
827: x_return_status := FND_API.g_ret_sts_error;
828: WHEN OTHERS THEN
829: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
830: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
831: gme_debug.put_line ('Unexpected error: '||g_pkg_name||'.'||l_api_name||': '||SQLERRM);
832: END IF;
833: x_return_status := FND_API.g_ret_sts_unexp_error;

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

956: x_return_status := fnd_api.g_ret_sts_unexp_error;
957: WHEN process_actual_qty_error THEN
958: NULL;
959: WHEN OTHERS THEN
960: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
961:
962: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
963: gme_debug.put_line ( 'Unexpected error: '
964: || g_pkg_name

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

1402: -- -1 means you can't create a transaction; 0 means there are no transactions
1403: -- but you can create transactions; other is trans_id => 1 and only 1 trans exists
1404: EXCEPTION
1405: WHEN OTHERS THEN
1406: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1407:
1408: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1409: gme_debug.put_line ( 'Unexpected error: '
1410: || g_pkg_name

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

1669: EXCEPTION
1670: WHEN error_trans THEN
1671: NULL;
1672: WHEN OTHERS THEN
1673: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1674:
1675: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1676: gme_debug.put_line ( 'Unexpected error: '
1677: || g_pkg_name

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

1869: gme_debug.put_line (g_pkg_name||'.'||l_api_name
1870: ||': error from proc: '|| l_val_proc);
1871: END IF;
1872: WHEN OTHERS THEN
1873: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1874:
1875: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1876: gme_debug.put_line ( 'Unexpected error: '
1877: || g_pkg_name

Line 1965: fnd_msg_pub.ADD;

1961: EXCEPTION
1962: WHEN um_convert_error THEN
1963: FND_MESSAGE.SET_NAME('INV','INV_NO_CONVERSION_ERR');
1964: FND_MESSAGE.SET_TOKEN('PGM_NAME',g_pkg_name||'.'||l_api_name);
1965: fnd_msg_pub.ADD;
1966: x_return_status := fnd_api.g_ret_sts_error;
1967: WHEN OTHERS THEN
1968: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1969:

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

1964: FND_MESSAGE.SET_TOKEN('PGM_NAME',g_pkg_name||'.'||l_api_name);
1965: fnd_msg_pub.ADD;
1966: x_return_status := fnd_api.g_ret_sts_error;
1967: WHEN OTHERS THEN
1968: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1969:
1970: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1971: gme_debug.put_line ( 'Unexpected error: '
1972: || g_pkg_name

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

2029: EXCEPTION
2030: WHEN error_get_item THEN
2031: x_return_status := fnd_api.g_ret_sts_error;
2032: WHEN OTHERS THEN
2033: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2034:
2035: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2036: gme_debug.put_line ( 'Unexpected error: '
2037: || g_pkg_name

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

2129: gme_common_pvt.log_message ('GME_INV_ITEM_INSERT', 'ITEM_NO', l_field);
2130: x_return_status := fnd_api.g_ret_sts_error;
2131:
2132: WHEN OTHERS THEN
2133: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2134:
2135: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2136: gme_debug.put_line ( 'Unexpected error: '
2137: || g_pkg_name

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

2204: EXCEPTION
2205: WHEN error_not_revision_control OR error_revision_not_found THEN
2206: x_return_status := fnd_api.g_ret_sts_error;
2207: WHEN OTHERS THEN
2208: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2209:
2210: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2211: gme_debug.put_line ( 'Unexpected error: '
2212: || g_pkg_name

Line 2245: fnd_msg_pub.ADD;

2241: -- raise an error
2242: IF gme_common_pvt.g_byprod_active = 2 AND
2243: p_line_type = gme_common_pvt.g_line_type_byprod THEN
2244: fnd_message.set_name ('GMD', 'FM_BYPROD_INACTIVE');
2245: fnd_msg_pub.ADD;
2246: RAISE validation_error;
2247: END IF;
2248:
2249: IF p_line_type NOT IN

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

2261: EXCEPTION
2262: WHEN validation_error THEN
2263: x_return_status := fnd_api.g_ret_sts_error;
2264: WHEN OTHERS THEN
2265: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2266:
2267: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2268: gme_debug.put_line ( 'Unexpected error: '
2269: || g_pkg_name

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

2318: EXCEPTION
2319: WHEN invalid_byproduct_type THEN
2320: x_return_status := fnd_api.g_ret_sts_error;
2321: WHEN OTHERS THEN
2322: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2323:
2324: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2325: gme_debug.put_line ( 'Unexpected error: '
2326: || g_pkg_name

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

2382: EXCEPTION
2383: WHEN invalid_line_no THEN
2384: x_return_status := fnd_api.g_ret_sts_error;
2385: WHEN OTHERS THEN
2386: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2387:
2388: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2389: gme_debug.put_line ( 'Unexpected error: '
2390: || g_pkg_name

Line 2439: fnd_msg_pub.ADD;

2435: -- Namit bug#4515560. Disable date can be null for UOM and do not raise exception for it.
2436: /*
2437: IF l_disable_date IS NULL THEN
2438: fnd_message.set_name ('GMI', 'IC_UMCODE');
2439: fnd_msg_pub.ADD;
2440: RAISE invalid_dtl_um;
2441: END IF;
2442: */
2443:

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

2470: x_return_status := fnd_api.g_ret_sts_error;
2471: WHEN um_convert_error THEN
2472: NULL;
2473: WHEN OTHERS THEN
2474: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2475:
2476: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2477: gme_debug.put_line ( 'Unexpected error: '
2478: || g_pkg_name

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

2511: EXCEPTION
2512: WHEN val_error THEN
2513: x_return_status := fnd_api.g_ret_sts_error;
2514: WHEN OTHERS THEN
2515: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2516:
2517: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2518: gme_debug.put_line ( 'Unexpected error: '
2519: || g_pkg_name

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

2552: EXCEPTION
2553: WHEN val_error THEN
2554: x_return_status := fnd_api.g_ret_sts_error;
2555: WHEN OTHERS THEN
2556: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2557:
2558: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2559: gme_debug.put_line ( 'Unexpected error: '
2560: || g_pkg_name

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

2593: EXCEPTION
2594: WHEN val_error THEN
2595: x_return_status := fnd_api.g_ret_sts_error;
2596: WHEN OTHERS THEN
2597: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2598:
2599: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2600: gme_debug.put_line ( 'Unexpected error: '
2601: || g_pkg_name

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

2647: EXCEPTION
2648: WHEN val_error THEN
2649: x_return_status := fnd_api.g_ret_sts_error;
2650: WHEN OTHERS THEN
2651: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2652:
2653: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2654: gme_debug.put_line ( 'Unexpected error: '
2655: || g_pkg_name

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

2689: EXCEPTION
2690: WHEN val_error THEN
2691: x_return_status := fnd_api.g_ret_sts_error;
2692: WHEN OTHERS THEN
2693: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2694:
2695: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2696: gme_debug.put_line ( 'Unexpected error: '
2697: || g_pkg_name

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

2730: EXCEPTION
2731: WHEN val_error THEN
2732: x_return_status := fnd_api.g_ret_sts_error;
2733: WHEN OTHERS THEN
2734: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2735:
2736: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2737: gme_debug.put_line ( 'Unexpected error: '
2738: || g_pkg_name

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

2771: EXCEPTION
2772: WHEN val_error THEN
2773: x_return_status := fnd_api.g_ret_sts_error;
2774: WHEN OTHERS THEN
2775: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2776:
2777: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2778: gme_debug.put_line ( 'Unexpected error: '
2779: || g_pkg_name

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

2825: EXCEPTION
2826: WHEN val_error THEN
2827: x_return_status := fnd_api.g_ret_sts_error;
2828: WHEN OTHERS THEN
2829: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2830:
2831: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2832: gme_debug.put_line ( 'Unexpected error: '
2833: || g_pkg_name

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

2879: EXCEPTION
2880: WHEN val_error THEN
2881: x_return_status := fnd_api.g_ret_sts_error;
2882: WHEN OTHERS THEN
2883: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2884:
2885: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2886: gme_debug.put_line ( 'Unexpected error: '
2887: || g_pkg_name

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

2978: EXCEPTION
2979: WHEN val_error THEN
2980: x_return_status := fnd_api.g_ret_sts_error;
2981: WHEN OTHERS THEN
2982: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2983: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2984: gme_debug.put_line ( 'Unexpected error: '
2985: || g_pkg_name
2986: || '.'

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

3030: EXCEPTION
3031: WHEN val_error THEN
3032: x_return_status := fnd_api.g_ret_sts_error;
3033: WHEN OTHERS THEN
3034: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3035:
3036: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
3037: gme_debug.put_line ( 'Unexpected error: '
3038: || g_pkg_name

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

3071: EXCEPTION
3072: WHEN val_error THEN
3073: x_return_status := fnd_api.g_ret_sts_error;
3074: WHEN OTHERS THEN
3075: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3076:
3077: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
3078: gme_debug.put_line ( 'Unexpected error: '
3079: || g_pkg_name

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

3113: EXCEPTION
3114: WHEN val_error THEN
3115: x_return_status := fnd_api.g_ret_sts_error;
3116: WHEN OTHERS THEN
3117: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3118:
3119: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
3120: gme_debug.put_line ( 'Unexpected error: '
3121: || g_pkg_name

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

3162: EXCEPTION
3163: WHEN sub_not_valid THEN
3164: x_return_status := fnd_api.g_ret_sts_error;
3165: WHEN OTHERS THEN
3166: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3167:
3168: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
3169: gme_debug.put_line ( 'Unexpected error: '
3170: || g_pkg_name

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

3244: EXCEPTION
3245: WHEN loc_not_valid THEN
3246: x_return_status := fnd_api.g_ret_sts_error;
3247: WHEN OTHERS THEN
3248: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3249:
3250: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
3251: gme_debug.put_line ( 'Unexpected error: '
3252: || g_pkg_name

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

3860: gme_debug.put_line (g_pkg_name||'.'||l_api_name|| ': '
3861: || l_proc|| ' unexpected error: '|| SQLERRM);
3862: END IF;
3863: WHEN OTHERS THEN
3864: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3865:
3866: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
3867: gme_debug.put_line ( 'Unexpected error: '
3868: || g_pkg_name

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

4384: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
4385: gme_debug.put_line (g_pkg_name||'.'||l_api_name||': validation error from proc: '|| l_val_proc);
4386: END IF;
4387: WHEN OTHERS THEN
4388: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
4389:
4390: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
4391: gme_debug.put_line ( 'Unexpected error: '
4392: || g_pkg_name

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

4532: EXCEPTION
4533: WHEN val_error THEN
4534: x_return_status := fnd_api.g_ret_sts_error;
4535: WHEN OTHERS THEN
4536: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
4537: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
4538: gme_debug.put_line ('Unexpected error: '
4539: || g_pkg_name
4540: || '.'

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

4585: EXCEPTION
4586: WHEN val_error THEN
4587: x_return_status := fnd_api.g_ret_sts_error;
4588: WHEN OTHERS THEN
4589: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
4590:
4591: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
4592: gme_debug.put_line ( 'Unexpected error: '
4593: || g_pkg_name

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

4780: gme_debug.put_line (g_pkg_name||'.'||l_api_name|| ': '
4781: || l_proc|| ' unexpected error: '|| SQLERRM);
4782: END IF;
4783: WHEN OTHERS THEN
4784: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
4785:
4786: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
4787: gme_debug.put_line ( 'Unexpected error: '
4788: || g_pkg_name