DBA Data[Home] [Help]

APPS.GME_TRANSACTIONS_PVT dependencies on FND_MSG_PUB

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

530: WHEN fnd_api.g_exc_unexpected_error THEN
531: x_return_status := fnd_api.g_ret_sts_unexp_error;
532: WHEN OTHERS THEN
533: x_return_status := fnd_api.g_ret_sts_unexp_error;
534: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
535:
536: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
537: gme_debug.put_line ( g_pkg_name
538: || '.'

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

825: WHEN fnd_api.g_exc_unexpected_error THEN
826: x_return_status := fnd_api.g_ret_sts_unexp_error;
827: WHEN OTHERS THEN
828: x_return_status := fnd_api.g_ret_sts_unexp_error;
829: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
830:
831: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
832: gme_debug.put_line ( g_pkg_name
833: || '.'

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

1064: WHEN fnd_api.g_exc_unexpected_error THEN
1065: x_return_status := fnd_api.g_ret_sts_unexp_error;
1066: WHEN OTHERS THEN
1067: x_return_status := fnd_api.g_ret_sts_unexp_error;
1068: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1069:
1070: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
1071: gme_debug.put_line ( g_pkg_name
1072: || '.'

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

1535:
1536: x_return_status := fnd_api.g_ret_sts_unexp_error;
1537: WHEN OTHERS THEN
1538: x_return_status := fnd_api.g_ret_sts_unexp_error;
1539: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1540:
1541: IF (g_debug <= gme_debug.g_log_statement) THEN
1542: gme_debug.put_line ( g_pkg_name
1543: || '.'

Line 1823: fnd_msg_pub.ADD;

1819: fnd_message.set_name ('GMI', 'IC_API_UOM_CONVERSION_ERROR');
1820: fnd_message.set_token ('ITEM_NO', l_item_no);
1821: fnd_message.set_token ('FROM_UOM',x_mmti_rec.transaction_uom);
1822: fnd_message.set_token ('TO_UOM', l_primary_uom);
1823: fnd_msg_pub.ADD;
1824: x_return_status := FND_API.g_ret_sts_error;
1825: WHEN lot_expired_err THEN
1826: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'lot_expired_err');
1827: x_return_status := 'T';

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

1843: || SQLERRM);
1844: x_return_status := fnd_api.g_ret_sts_unexp_error;
1845: WHEN OTHERS THEN
1846: x_return_status := fnd_api.g_ret_sts_unexp_error;
1847: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1848:
1849: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1850: gme_debug.put_line ( g_pkg_name
1851: || '.'

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

2250: || SQLERRM);
2251: x_return_status := fnd_api.g_ret_sts_unexp_error;
2252: WHEN OTHERS THEN
2253: x_return_status := fnd_api.g_ret_sts_unexp_error;
2254: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2255:
2256: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2257: gme_debug.put_line ( g_pkg_name
2258: || '.'

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

2572: || SQLERRM);
2573: x_return_status := fnd_api.g_ret_sts_unexp_error;
2574: WHEN OTHERS THEN
2575: x_return_status := fnd_api.g_ret_sts_unexp_error;
2576: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2577:
2578: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2579: gme_debug.put_line ( g_pkg_name
2580: || '.'

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

2715: WHEN fnd_api.g_exc_unexpected_error THEN
2716: x_return_status := fnd_api.g_ret_sts_unexp_error;
2717: WHEN OTHERS THEN
2718: x_return_status := fnd_api.g_ret_sts_unexp_error;
2719: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2720:
2721: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
2722: gme_debug.put_line ( g_pkg_name
2723: || '.'

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

2837: WHEN fnd_api.g_exc_unexpected_error THEN
2838: x_return_status := fnd_api.g_ret_sts_unexp_error;
2839: WHEN OTHERS THEN
2840: x_return_status := fnd_api.g_ret_sts_unexp_error;
2841: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2842:
2843: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
2844: gme_debug.put_line ( g_pkg_name
2845: || '.'

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

2986: WHEN fnd_api.g_exc_unexpected_error THEN
2987: x_return_status := fnd_api.g_ret_sts_unexp_error;
2988: WHEN OTHERS THEN
2989: x_return_status := fnd_api.g_ret_sts_unexp_error;
2990: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2991:
2992: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
2993: gme_debug.put_line ( g_pkg_name
2994: || '.'

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

3076: || 'WHEN OTHERS:'
3077: || SQLERRM);
3078: END IF;
3079:
3080: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3081: END get_lot_trans;
3082:
3083: /* +==========================================================================+
3084: | PROCEDURE NAME

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

3177: || 'WHEN OTHERS:'
3178: || SQLERRM);
3179: END IF;
3180:
3181: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3182: END gme_pre_process;
3183:
3184: /* +==========================================================================+
3185: | PROCEDURE NAME

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

3342: END IF;
3343: EXCEPTION
3344: WHEN OTHERS THEN
3345: x_return_status := fnd_api.g_ret_sts_unexp_error;
3346: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3347:
3348: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
3349: gme_debug.put_line ( g_pkg_name
3350: || '.'

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

3681: WHEN fnd_api.g_exc_unexpected_error THEN
3682: x_return_status := fnd_api.g_ret_sts_unexp_error;
3683: WHEN OTHERS THEN
3684: x_return_status := fnd_api.g_ret_sts_unexp_error;
3685: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3686:
3687: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
3688: gme_debug.put_line ( g_pkg_name
3689: || '.'

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

3762: );
3763: END IF;
3764: EXCEPTION
3765: WHEN OTHERS THEN
3766: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3767:
3768: IF g_debug <= gme_debug.g_log_unexpected THEN
3769: gme_debug.put_line ( 'When others exception in '
3770: || g_pkg_name

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

4312: x_return_status := fnd_api.g_ret_sts_error;
4313: WHEN fnd_api.g_exc_unexpected_error THEN
4314: x_return_status := fnd_api.g_ret_sts_unexp_error;
4315: WHEN OTHERS THEN
4316: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
4317:
4318: IF g_debug <= gme_debug.g_log_unexpected THEN
4319: gme_debug.put_line ( 'When others exception in '
4320: || g_pkg_name

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

4411: x_return_status := fnd_api.g_ret_sts_error;
4412: WHEN fnd_api.g_exc_unexpected_error THEN
4413: x_return_status := fnd_api.g_ret_sts_unexp_error;
4414: WHEN OTHERS THEN
4415: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
4416:
4417: IF g_debug <= gme_debug.g_log_unexpected THEN
4418: gme_debug.put_line ( 'When others exception in '
4419: || g_pkg_name

Line 4882: fnd_msg_pub.count_and_get (p_count => x_msg_count

4878:
4879: EXCEPTION
4880: WHEN fnd_api.g_exc_error THEN
4881: x_return_status := fnd_api.g_ret_sts_error;
4882: fnd_msg_pub.count_and_get (p_count => x_msg_count
4883: ,p_data => x_msg_data);
4884: WHEN fnd_api.g_exc_unexpected_error THEN
4885: x_return_status := fnd_api.g_ret_sts_unexp_error;
4886:

Line 4896: fnd_msg_pub.count_and_get (p_count => x_msg_count

4892: || 'UNEXPECTED:'
4893: || SQLERRM);
4894: END IF;
4895:
4896: fnd_msg_pub.count_and_get (p_count => x_msg_count
4897: ,p_data => x_msg_data);
4898: WHEN OTHERS THEN
4899: x_return_status := fnd_api.g_ret_sts_unexp_error;
4900:

Line 4910: fnd_msg_pub.count_and_get (p_count => x_msg_count

4906: || 'OTHERS:'
4907: || SQLERRM);
4908: END IF;
4909:
4910: fnd_msg_pub.count_and_get (p_count => x_msg_count
4911: ,p_data => x_msg_data);
4912: END process_transactions;
4913:
4914: /* +==========================================================================+

Line 5118: fnd_msg_pub.count_and_get (p_count => x_msg_count

5114: END IF;
5115: EXCEPTION
5116: WHEN fnd_api.g_exc_error THEN
5117: x_return_status := fnd_api.g_ret_sts_error;
5118: fnd_msg_pub.count_and_get (p_count => x_msg_count
5119: ,p_data => x_msg_data);
5120: WHEN fnd_api.g_exc_unexpected_error THEN
5121: x_return_status := fnd_api.g_ret_sts_unexp_error;
5122:

Line 5132: fnd_msg_pub.count_and_get (p_count => x_msg_count

5128: || 'UNEXPECTED:'
5129: || SQLERRM);
5130: END IF;
5131:
5132: fnd_msg_pub.count_and_get (p_count => x_msg_count
5133: ,p_data => x_msg_data);
5134: WHEN OTHERS THEN
5135: x_return_status := fnd_api.g_ret_sts_unexp_error;
5136:

Line 5146: fnd_msg_pub.count_and_get (p_count => x_msg_count

5142: || 'OTHERS:'
5143: || SQLERRM);
5144: END IF;
5145:
5146: fnd_msg_pub.count_and_get (p_count => x_msg_count
5147: ,p_data => x_msg_data);
5148: END query_quantities;
5149:
5150: /* +==========================================================================+

Line 5374: fnd_msg_pub.count_and_get (p_count => x_msg_count

5370: END IF;
5371: EXCEPTION
5372: WHEN fnd_api.g_exc_error THEN
5373: x_return_status := fnd_api.g_ret_sts_error;
5374: fnd_msg_pub.count_and_get (p_count => x_msg_count
5375: ,p_data => x_msg_data);
5376: WHEN fnd_api.g_exc_unexpected_error THEN
5377: x_return_status := fnd_api.g_ret_sts_unexp_error;
5378:

Line 5388: fnd_msg_pub.count_and_get (p_count => x_msg_count

5384: || 'UNEXPECTED:'
5385: || SQLERRM);
5386: END IF;
5387:
5388: fnd_msg_pub.count_and_get (p_count => x_msg_count
5389: ,p_data => x_msg_data);
5390: WHEN OTHERS THEN
5391: x_return_status := fnd_api.g_ret_sts_unexp_error;
5392:

Line 5402: fnd_msg_pub.count_and_get (p_count => x_msg_count

5398: || 'OTHERS:'
5399: || SQLERRM);
5400: END IF;
5401:
5402: fnd_msg_pub.count_and_get (p_count => x_msg_count
5403: ,p_data => x_msg_data);
5404: END update_quantities;
5405:
5406: /* Bug 4929610 Added fucntion */

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

5717: WHEN fnd_api.g_exc_unexpected_error THEN
5718: x_return_status := fnd_api.g_ret_sts_unexp_error;
5719: WHEN OTHERS THEN
5720: x_return_status := fnd_api.g_ret_sts_unexp_error;
5721: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
5722:
5723: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
5724: gme_debug.put_line ( g_pkg_name
5725: || '.'

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

5778: gme_common_pvt.log_message(p_message_code => 'INV_INVALID_LOT',
5779: p_product_code => 'INV');
5780: WHEN OTHERS THEN
5781: x_return_status := fnd_api.g_ret_sts_unexp_error;
5782: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
5783: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
5784: gme_debug.put_line ( g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);
5785: END IF;
5786: END validate_lot_for_ing;

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

5969: WHEN fnd_api.g_exc_unexpected_error THEN
5970: x_return_status := fnd_api.g_ret_sts_unexp_error;
5971: WHEN OTHERS THEN
5972: x_return_status := fnd_api.g_ret_sts_unexp_error;
5973: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
5974: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
5975: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);
5976: END IF;
5977: END gmo_pre_process_val;