DBA Data[Home] [Help]

APPS.GME_TRANSACTIONS_PVT dependencies on FND_MSG_PUB

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

379: WHEN fnd_api.g_exc_unexpected_error THEN
380: x_return_status := fnd_api.g_ret_sts_unexp_error;
381: WHEN OTHERS THEN
382: x_return_status := fnd_api.g_ret_sts_unexp_error;
383: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
384:
385: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
386: gme_debug.put_line ( g_pkg_name
387: || '.'

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

499: WHEN fnd_api.g_exc_unexpected_error THEN
500: x_return_status := fnd_api.g_ret_sts_unexp_error;
501: WHEN OTHERS THEN
502: x_return_status := fnd_api.g_ret_sts_unexp_error;
503: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
504:
505: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
506: gme_debug.put_line ( g_pkg_name
507: || '.'

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

652: WHEN fnd_api.g_exc_unexpected_error THEN
653: x_return_status := fnd_api.g_ret_sts_unexp_error;
654: WHEN OTHERS THEN
655: x_return_status := fnd_api.g_ret_sts_unexp_error;
656: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
657:
658: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
659: gme_debug.put_line ( g_pkg_name
660: || '.'

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

1003:
1004: x_return_status := fnd_api.g_ret_sts_unexp_error;
1005: WHEN OTHERS THEN
1006: x_return_status := fnd_api.g_ret_sts_unexp_error;
1007: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1008:
1009: IF (g_debug <= gme_debug.g_log_statement) THEN
1010: gme_debug.put_line ( g_pkg_name
1011: || '.'

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

1195: || SQLERRM);
1196: x_return_status := fnd_api.g_ret_sts_unexp_error;
1197: WHEN OTHERS THEN
1198: x_return_status := fnd_api.g_ret_sts_unexp_error;
1199: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1200:
1201: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1202: gme_debug.put_line ( g_pkg_name
1203: || '.'

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

1595: || SQLERRM);
1596: x_return_status := fnd_api.g_ret_sts_unexp_error;
1597: WHEN OTHERS THEN
1598: x_return_status := fnd_api.g_ret_sts_unexp_error;
1599: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1600:
1601: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1602: gme_debug.put_line ( g_pkg_name
1603: || '.'

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

1784: || SQLERRM);
1785: x_return_status := fnd_api.g_ret_sts_unexp_error;
1786: WHEN OTHERS THEN
1787: x_return_status := fnd_api.g_ret_sts_unexp_error;
1788: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1789:
1790: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1791: gme_debug.put_line ( g_pkg_name
1792: || '.'

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

1927: WHEN fnd_api.g_exc_unexpected_error THEN
1928: x_return_status := fnd_api.g_ret_sts_unexp_error;
1929: WHEN OTHERS THEN
1930: x_return_status := fnd_api.g_ret_sts_unexp_error;
1931: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1932:
1933: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
1934: gme_debug.put_line ( g_pkg_name
1935: || '.'

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

2048: WHEN fnd_api.g_exc_unexpected_error THEN
2049: x_return_status := fnd_api.g_ret_sts_unexp_error;
2050: WHEN OTHERS THEN
2051: x_return_status := fnd_api.g_ret_sts_unexp_error;
2052: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2053:
2054: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
2055: gme_debug.put_line ( g_pkg_name
2056: || '.'

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

2139: WHEN fnd_api.g_exc_unexpected_error THEN
2140: x_return_status := fnd_api.g_ret_sts_unexp_error;
2141: WHEN OTHERS THEN
2142: x_return_status := fnd_api.g_ret_sts_unexp_error;
2143: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2144:
2145: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
2146: gme_debug.put_line ( g_pkg_name
2147: || '.'

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

2228: || 'WHEN OTHERS:'
2229: || SQLERRM);
2230: END IF;
2231:
2232: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2233: END get_lot_trans;
2234:
2235: /* +==========================================================================+
2236: | PROCEDURE NAME

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

2329: || 'WHEN OTHERS:'
2330: || SQLERRM);
2331: END IF;
2332:
2333: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2334: END gme_pre_process;
2335:
2336: /* +==========================================================================+
2337: | PROCEDURE NAME

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

2492: END IF;
2493: EXCEPTION
2494: WHEN OTHERS THEN
2495: x_return_status := fnd_api.g_ret_sts_unexp_error;
2496: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2497:
2498: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
2499: gme_debug.put_line ( g_pkg_name
2500: || '.'

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

2828: WHEN fnd_api.g_exc_unexpected_error THEN
2829: x_return_status := fnd_api.g_ret_sts_unexp_error;
2830: WHEN OTHERS THEN
2831: x_return_status := fnd_api.g_ret_sts_unexp_error;
2832: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2833:
2834: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
2835: gme_debug.put_line ( g_pkg_name
2836: || '.'

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

2904: );
2905: END IF;
2906: EXCEPTION
2907: WHEN OTHERS THEN
2908: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2909:
2910: IF g_debug <= gme_debug.g_log_unexpected THEN
2911: gme_debug.put_line ( 'When others exception in '
2912: || g_pkg_name

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

3436: x_return_status := fnd_api.g_ret_sts_error;
3437: WHEN fnd_api.g_exc_unexpected_error THEN
3438: x_return_status := fnd_api.g_ret_sts_unexp_error;
3439: WHEN OTHERS THEN
3440: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3441:
3442: IF g_debug <= gme_debug.g_log_unexpected THEN
3443: gme_debug.put_line ( 'When others exception in '
3444: || g_pkg_name

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

3534: x_return_status := fnd_api.g_ret_sts_error;
3535: WHEN fnd_api.g_exc_unexpected_error THEN
3536: x_return_status := fnd_api.g_ret_sts_unexp_error;
3537: WHEN OTHERS THEN
3538: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3539:
3540: IF g_debug <= gme_debug.g_log_unexpected THEN
3541: gme_debug.put_line ( 'When others exception in '
3542: || g_pkg_name

Line 3883: fnd_msg_pub.count_and_get (p_count => x_msg_count

3879:
3880: EXCEPTION
3881: WHEN fnd_api.g_exc_error THEN
3882: x_return_status := fnd_api.g_ret_sts_error;
3883: fnd_msg_pub.count_and_get (p_count => x_msg_count
3884: ,p_data => x_msg_data);
3885: WHEN fnd_api.g_exc_unexpected_error THEN
3886: x_return_status := fnd_api.g_ret_sts_unexp_error;
3887:

Line 3897: fnd_msg_pub.count_and_get (p_count => x_msg_count

3893: || 'UNEXPECTED:'
3894: || SQLERRM);
3895: END IF;
3896:
3897: fnd_msg_pub.count_and_get (p_count => x_msg_count
3898: ,p_data => x_msg_data);
3899: WHEN OTHERS THEN
3900: x_return_status := fnd_api.g_ret_sts_unexp_error;
3901:

Line 3911: fnd_msg_pub.count_and_get (p_count => x_msg_count

3907: || 'OTHERS:'
3908: || SQLERRM);
3909: END IF;
3910:
3911: fnd_msg_pub.count_and_get (p_count => x_msg_count
3912: ,p_data => x_msg_data);
3913: END process_transactions;
3914:
3915: /* +==========================================================================+

Line 4110: fnd_msg_pub.count_and_get (p_count => x_msg_count

4106: END IF;
4107: EXCEPTION
4108: WHEN fnd_api.g_exc_error THEN
4109: x_return_status := fnd_api.g_ret_sts_error;
4110: fnd_msg_pub.count_and_get (p_count => x_msg_count
4111: ,p_data => x_msg_data);
4112: WHEN fnd_api.g_exc_unexpected_error THEN
4113: x_return_status := fnd_api.g_ret_sts_unexp_error;
4114:

Line 4124: fnd_msg_pub.count_and_get (p_count => x_msg_count

4120: || 'UNEXPECTED:'
4121: || SQLERRM);
4122: END IF;
4123:
4124: fnd_msg_pub.count_and_get (p_count => x_msg_count
4125: ,p_data => x_msg_data);
4126: WHEN OTHERS THEN
4127: x_return_status := fnd_api.g_ret_sts_unexp_error;
4128:

Line 4138: fnd_msg_pub.count_and_get (p_count => x_msg_count

4134: || 'OTHERS:'
4135: || SQLERRM);
4136: END IF;
4137:
4138: fnd_msg_pub.count_and_get (p_count => x_msg_count
4139: ,p_data => x_msg_data);
4140: END query_quantities;
4141:
4142: /* +==========================================================================+

Line 4366: fnd_msg_pub.count_and_get (p_count => x_msg_count

4362: END IF;
4363: EXCEPTION
4364: WHEN fnd_api.g_exc_error THEN
4365: x_return_status := fnd_api.g_ret_sts_error;
4366: fnd_msg_pub.count_and_get (p_count => x_msg_count
4367: ,p_data => x_msg_data);
4368: WHEN fnd_api.g_exc_unexpected_error THEN
4369: x_return_status := fnd_api.g_ret_sts_unexp_error;
4370:

Line 4380: fnd_msg_pub.count_and_get (p_count => x_msg_count

4376: || 'UNEXPECTED:'
4377: || SQLERRM);
4378: END IF;
4379:
4380: fnd_msg_pub.count_and_get (p_count => x_msg_count
4381: ,p_data => x_msg_data);
4382: WHEN OTHERS THEN
4383: x_return_status := fnd_api.g_ret_sts_unexp_error;
4384:

Line 4394: fnd_msg_pub.count_and_get (p_count => x_msg_count

4390: || 'OTHERS:'
4391: || SQLERRM);
4392: END IF;
4393:
4394: fnd_msg_pub.count_and_get (p_count => x_msg_count
4395: ,p_data => x_msg_data);
4396: END update_quantities;
4397:
4398: /* Bug 4929610 Added fucntion */

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

4675: WHEN fnd_api.g_exc_unexpected_error THEN
4676: x_return_status := fnd_api.g_ret_sts_unexp_error;
4677: WHEN OTHERS THEN
4678: x_return_status := fnd_api.g_ret_sts_unexp_error;
4679: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
4680:
4681: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
4682: gme_debug.put_line ( g_pkg_name
4683: || '.'

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

4732: gme_common_pvt.log_message(p_message_code => 'INV_INVALID_LOT',
4733: p_product_code => 'INV');
4734: WHEN OTHERS THEN
4735: x_return_status := fnd_api.g_ret_sts_unexp_error;
4736: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
4737: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
4738: gme_debug.put_line ( g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);
4739: END IF;
4740: END validate_lot_for_ing;

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

4921: WHEN fnd_api.g_exc_unexpected_error THEN
4922: x_return_status := fnd_api.g_ret_sts_unexp_error;
4923: WHEN OTHERS THEN
4924: x_return_status := fnd_api.g_ret_sts_unexp_error;
4925: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
4926: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
4927: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);
4928: END IF;
4929: END gmo_pre_process_val;