DBA Data[Home] [Help]

APPS.GME_MATERIAL_DETAIL_PVT dependencies on FND_MSG_PUB

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

264: gme_debug.put_line (g_pkg_name||'.'||l_api_name|| ': '
265: || l_proc|| 'Dispensing error returned ');
266: END IF;
267: WHEN OTHERS THEN
268: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
269: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
270: gme_debug.put_line ('Unexpected error: '||g_pkg_name||'.'||l_api_name||': '||SQLERRM);
271: END IF;
272: x_return_status := FND_API.g_ret_sts_unexp_error;

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

322: EXCEPTION
323: WHEN validation_error THEN
324: x_return_status := fnd_api.g_ret_sts_error;
325: WHEN OTHERS THEN
326: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
327: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
328: gme_debug.put_line ('Unexpected error: '||g_pkg_name||'.'||l_api_name||': '||SQLERRM);
329: END IF;
330: x_return_status := FND_API.g_ret_sts_unexp_error;

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

785: gme_debug.put_line (g_pkg_name||'.'||l_api_name||': validation error from proc: '|| l_val_proc);
786: END IF;
787: x_return_status := FND_API.g_ret_sts_error;
788: WHEN OTHERS THEN
789: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
790: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
791: gme_debug.put_line ('Unexpected error: '||g_pkg_name||'.'||l_api_name||': '||SQLERRM);
792: END IF;
793: x_return_status := FND_API.g_ret_sts_unexp_error;

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

916: x_return_status := fnd_api.g_ret_sts_unexp_error;
917: WHEN process_actual_qty_error THEN
918: NULL;
919: WHEN OTHERS THEN
920: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
921:
922: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
923: gme_debug.put_line ( 'Unexpected error: '
924: || g_pkg_name

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

1362: -- -1 means you can't create a transaction; 0 means there are no transactions
1363: -- but you can create transactions; other is trans_id => 1 and only 1 trans exists
1364: EXCEPTION
1365: WHEN OTHERS THEN
1366: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1367:
1368: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1369: gme_debug.put_line ( 'Unexpected error: '
1370: || g_pkg_name

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

1526: EXCEPTION
1527: WHEN error_trans THEN
1528: NULL;
1529: WHEN OTHERS THEN
1530: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1531:
1532: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1533: gme_debug.put_line ( 'Unexpected error: '
1534: || g_pkg_name

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

1726: gme_debug.put_line (g_pkg_name||'.'||l_api_name
1727: ||': error from proc: '|| l_val_proc);
1728: END IF;
1729: WHEN OTHERS THEN
1730: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1731:
1732: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1733: gme_debug.put_line ( 'Unexpected error: '
1734: || g_pkg_name

Line 1822: fnd_msg_pub.ADD;

1818: EXCEPTION
1819: WHEN um_convert_error THEN
1820: FND_MESSAGE.SET_NAME('INV','INV_NO_CONVERSION_ERR');
1821: FND_MESSAGE.SET_TOKEN('PGM_NAME',g_pkg_name||'.'||l_api_name);
1822: fnd_msg_pub.ADD;
1823: x_return_status := fnd_api.g_ret_sts_error;
1824: WHEN OTHERS THEN
1825: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1826:

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

1821: FND_MESSAGE.SET_TOKEN('PGM_NAME',g_pkg_name||'.'||l_api_name);
1822: fnd_msg_pub.ADD;
1823: x_return_status := fnd_api.g_ret_sts_error;
1824: WHEN OTHERS THEN
1825: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1826:
1827: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1828: gme_debug.put_line ( 'Unexpected error: '
1829: || g_pkg_name

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

1886: EXCEPTION
1887: WHEN error_get_item THEN
1888: x_return_status := fnd_api.g_ret_sts_error;
1889: WHEN OTHERS THEN
1890: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1891:
1892: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1893: gme_debug.put_line ( 'Unexpected error: '
1894: || g_pkg_name

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

1985: gme_common_pvt.log_message ('GME_INV_ITEM_INSERT', 'ITEM_NO', l_field);
1986: x_return_status := fnd_api.g_ret_sts_error;
1987:
1988: WHEN OTHERS THEN
1989: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1990:
1991: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1992: gme_debug.put_line ( 'Unexpected error: '
1993: || g_pkg_name

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

2060: EXCEPTION
2061: WHEN error_not_revision_control OR error_revision_not_found THEN
2062: x_return_status := fnd_api.g_ret_sts_error;
2063: WHEN OTHERS THEN
2064: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2065:
2066: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2067: gme_debug.put_line ( 'Unexpected error: '
2068: || g_pkg_name

Line 2101: fnd_msg_pub.ADD;

2097: -- raise an error
2098: IF gme_common_pvt.g_byprod_active = 2 AND
2099: p_line_type = gme_common_pvt.g_line_type_byprod THEN
2100: fnd_message.set_name ('GMD', 'FM_BYPROD_INACTIVE');
2101: fnd_msg_pub.ADD;
2102: RAISE validation_error;
2103: END IF;
2104:
2105: IF p_line_type NOT IN

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

2117: EXCEPTION
2118: WHEN validation_error THEN
2119: x_return_status := fnd_api.g_ret_sts_error;
2120: WHEN OTHERS THEN
2121: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2122:
2123: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2124: gme_debug.put_line ( 'Unexpected error: '
2125: || g_pkg_name

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

2174: EXCEPTION
2175: WHEN invalid_byproduct_type THEN
2176: x_return_status := fnd_api.g_ret_sts_error;
2177: WHEN OTHERS THEN
2178: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2179:
2180: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2181: gme_debug.put_line ( 'Unexpected error: '
2182: || g_pkg_name

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

2238: EXCEPTION
2239: WHEN invalid_line_no THEN
2240: x_return_status := fnd_api.g_ret_sts_error;
2241: WHEN OTHERS THEN
2242: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2243:
2244: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2245: gme_debug.put_line ( 'Unexpected error: '
2246: || g_pkg_name

Line 2295: fnd_msg_pub.ADD;

2291: -- Namit bug#4515560. Disable date can be null for UOM and do not raise exception for it.
2292: /*
2293: IF l_disable_date IS NULL THEN
2294: fnd_message.set_name ('GMI', 'IC_UMCODE');
2295: fnd_msg_pub.ADD;
2296: RAISE invalid_dtl_um;
2297: END IF;
2298: */
2299:

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

2326: x_return_status := fnd_api.g_ret_sts_error;
2327: WHEN um_convert_error THEN
2328: NULL;
2329: WHEN OTHERS THEN
2330: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2331:
2332: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2333: gme_debug.put_line ( 'Unexpected error: '
2334: || g_pkg_name

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

2367: EXCEPTION
2368: WHEN val_error THEN
2369: x_return_status := fnd_api.g_ret_sts_error;
2370: WHEN OTHERS THEN
2371: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2372:
2373: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2374: gme_debug.put_line ( 'Unexpected error: '
2375: || g_pkg_name

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

2408: EXCEPTION
2409: WHEN val_error THEN
2410: x_return_status := fnd_api.g_ret_sts_error;
2411: WHEN OTHERS THEN
2412: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2413:
2414: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2415: gme_debug.put_line ( 'Unexpected error: '
2416: || g_pkg_name

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

2449: EXCEPTION
2450: WHEN val_error THEN
2451: x_return_status := fnd_api.g_ret_sts_error;
2452: WHEN OTHERS THEN
2453: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2454:
2455: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2456: gme_debug.put_line ( 'Unexpected error: '
2457: || g_pkg_name

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

2503: EXCEPTION
2504: WHEN val_error THEN
2505: x_return_status := fnd_api.g_ret_sts_error;
2506: WHEN OTHERS THEN
2507: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2508:
2509: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2510: gme_debug.put_line ( 'Unexpected error: '
2511: || g_pkg_name

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

2545: EXCEPTION
2546: WHEN val_error THEN
2547: x_return_status := fnd_api.g_ret_sts_error;
2548: WHEN OTHERS THEN
2549: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2550:
2551: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2552: gme_debug.put_line ( 'Unexpected error: '
2553: || g_pkg_name

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

2586: EXCEPTION
2587: WHEN val_error THEN
2588: x_return_status := fnd_api.g_ret_sts_error;
2589: WHEN OTHERS THEN
2590: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2591:
2592: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2593: gme_debug.put_line ( 'Unexpected error: '
2594: || g_pkg_name

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

2627: EXCEPTION
2628: WHEN val_error THEN
2629: x_return_status := fnd_api.g_ret_sts_error;
2630: WHEN OTHERS THEN
2631: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2632:
2633: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2634: gme_debug.put_line ( 'Unexpected error: '
2635: || g_pkg_name

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

2681: EXCEPTION
2682: WHEN val_error THEN
2683: x_return_status := fnd_api.g_ret_sts_error;
2684: WHEN OTHERS THEN
2685: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2686:
2687: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2688: gme_debug.put_line ( 'Unexpected error: '
2689: || g_pkg_name

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

2735: EXCEPTION
2736: WHEN val_error THEN
2737: x_return_status := fnd_api.g_ret_sts_error;
2738: WHEN OTHERS THEN
2739: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2740:
2741: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2742: gme_debug.put_line ( 'Unexpected error: '
2743: || g_pkg_name

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

2834: EXCEPTION
2835: WHEN val_error THEN
2836: x_return_status := fnd_api.g_ret_sts_error;
2837: WHEN OTHERS THEN
2838: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2839: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2840: gme_debug.put_line ( 'Unexpected error: '
2841: || g_pkg_name
2842: || '.'

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

2886: EXCEPTION
2887: WHEN val_error THEN
2888: x_return_status := fnd_api.g_ret_sts_error;
2889: WHEN OTHERS THEN
2890: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2891:
2892: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2893: gme_debug.put_line ( 'Unexpected error: '
2894: || g_pkg_name

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

2927: EXCEPTION
2928: WHEN val_error THEN
2929: x_return_status := fnd_api.g_ret_sts_error;
2930: WHEN OTHERS THEN
2931: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2932:
2933: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2934: gme_debug.put_line ( 'Unexpected error: '
2935: || g_pkg_name

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

2969: EXCEPTION
2970: WHEN val_error THEN
2971: x_return_status := fnd_api.g_ret_sts_error;
2972: WHEN OTHERS THEN
2973: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2974:
2975: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2976: gme_debug.put_line ( 'Unexpected error: '
2977: || g_pkg_name

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

3018: EXCEPTION
3019: WHEN sub_not_valid THEN
3020: x_return_status := fnd_api.g_ret_sts_error;
3021: WHEN OTHERS THEN
3022: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3023:
3024: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
3025: gme_debug.put_line ( 'Unexpected error: '
3026: || g_pkg_name

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

3100: EXCEPTION
3101: WHEN loc_not_valid THEN
3102: x_return_status := fnd_api.g_ret_sts_error;
3103: WHEN OTHERS THEN
3104: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3105:
3106: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
3107: gme_debug.put_line ( 'Unexpected error: '
3108: || g_pkg_name

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

3669: gme_debug.put_line (g_pkg_name||'.'||l_api_name|| ': '
3670: || l_proc|| ' unexpected error: '|| SQLERRM);
3671: END IF;
3672: WHEN OTHERS THEN
3673: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3674:
3675: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
3676: gme_debug.put_line ( 'Unexpected error: '
3677: || g_pkg_name

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

4193: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
4194: gme_debug.put_line (g_pkg_name||'.'||l_api_name||': validation error from proc: '|| l_val_proc);
4195: END IF;
4196: WHEN OTHERS THEN
4197: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
4198:
4199: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
4200: gme_debug.put_line ( 'Unexpected error: '
4201: || g_pkg_name

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

4339: EXCEPTION
4340: WHEN val_error THEN
4341: x_return_status := fnd_api.g_ret_sts_error;
4342: WHEN OTHERS THEN
4343: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
4344: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
4345: gme_debug.put_line ('Unexpected error: '
4346: || g_pkg_name
4347: || '.'

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

4392: EXCEPTION
4393: WHEN val_error THEN
4394: x_return_status := fnd_api.g_ret_sts_error;
4395: WHEN OTHERS THEN
4396: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
4397:
4398: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
4399: gme_debug.put_line ( 'Unexpected error: '
4400: || g_pkg_name

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

4587: gme_debug.put_line (g_pkg_name||'.'||l_api_name|| ': '
4588: || l_proc|| ' unexpected error: '|| SQLERRM);
4589: END IF;
4590: WHEN OTHERS THEN
4591: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
4592:
4593: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
4594: gme_debug.put_line ( 'Unexpected error: '
4595: || g_pkg_name