DBA Data[Home] [Help]

APPS.GME_MOBILE_TXN dependencies on FND_MSG_PUB

Line 152: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','relieve_resvns_pend_lots');

148: WHEN OTHERS THEN
149: IF g_debug <= gme_debug.g_log_unexpected THEN
150: gme_debug.put_line('When others exception in relieve_resvns_pend_lots');
151: END IF;
152: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','relieve_resvns_pend_lots');
153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
154: x_error_msg := fnd_message.get;
155:
156: END relieve_resvns_pend_lots;

Line 199: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','relieve_resvns_disp_items');

195: WHEN OTHERS THEN
196: IF g_debug <= gme_debug.g_log_unexpected THEN
197: gme_debug.put_line('When others exception in relieve_resvns_disp_items');
198: END IF;
199: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','relieve_resvns_disp_items');
200: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
201: x_error_msg := fnd_message.get;
202: END relieve_resvns_disp_items;
203:

Line 226: fnd_msg_pub.Count_And_Get

222: l_message VARCHAR2(2000);
223: l_msg_count NUMBER;
224: BEGIN
225:
226: fnd_msg_pub.Count_And_Get
227: (p_encoded => FND_API.g_false,
228: p_count => l_msg_count,
229: p_data => l_message
230: );

Line 233: fnd_msg_pub.delete_msg;

229: p_data => l_message
230: );
231:
232:
233: fnd_msg_pub.delete_msg;
234:
235: x_message := l_message;
236:
237: EXCEPTION

Line 410: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','create_material_txn');

406: WHEN OTHERS THEN
407: IF g_debug <= gme_debug.g_log_unexpected THEN
408: gme_debug.put_line('When others exception in Create MAterial Txn');
409: END IF;
410: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','create_material_txn');
411: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
412: x_error_msg := fnd_message.get;
413:
414: END Create_Material_Txn;

Line 486: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','create_lot_txn');

482: WHEN OTHERS THEN
483: IF g_debug <= gme_debug.g_log_unexpected THEN
484: gme_debug.put_line('When others exception in Create Lot Txn');
485: END IF;
486: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','create_lot_txn');
487: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
488: x_error_msg := fnd_message.get;
489:
490: END Create_Lot_Txn;

Line 566: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Validate_Indiv_Lot_Txn');

562: WHEN OTHERS THEN
563: IF g_debug <= gme_debug.g_log_unexpected THEN
564: gme_debug.put_line('When others exception in Validate Indiv Lot Txn');
565: END IF;
566: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Validate_Indiv_Lot_Txn');
567: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
568: x_error_msg := fnd_message.get;
569:
570: END Validate_Indiv_Lot_Txn;

Line 699: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Is_Material_Status_Applicable');

695: WHEN OTHERS THEN
696: IF g_debug <= gme_debug.g_log_unexpected THEN
697: gme_debug.put_line('When others exception in Is_Material_Status_Applicable');
698: END IF;
699: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Is_Material_Status_Applicable');
700: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
701: x_error_msg := fnd_message.get;
702:
703: END Is_Material_Status_Applicable;

Line 755: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_aggregated_txns');

751: WHEN OTHERS THEN
752: IF g_debug <= gme_debug.g_log_unexpected THEN
753: gme_debug.put_line('When others exception in fetch aggrageted txns');
754: END IF;
755: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_aggregated_txns');
756: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
757: x_error_msg := fnd_message.get;
758:
759: END Fetch_Aggregated_Txns;

Line 812: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_aggregated_lot_txns');

808: WHEN OTHERS THEN
809: IF g_debug <= gme_debug.g_log_unexpected THEN
810: gme_debug.put_line('When others exception in fetch aggrageted lot txns');
811: END IF;
812: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_aggregated_lot_txns');
813: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
814: x_error_msg := fnd_message.get;
815:
816: END Fetch_Aggregated_Lot_Txns;

Line 872: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_aggregated_rev_txns');

868: WHEN OTHERS THEN
869: IF g_debug <= gme_debug.g_log_unexpected THEN
870: gme_debug.put_line('When others exception in fetch aggrageted lot txns');
871: END IF;
872: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_aggregated_rev_txns');
873: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
874: x_error_msg := fnd_message.get;
875:
876: END Fetch_Aggregated_Rev_Txns;

Line 944: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_material_transactions');

940: WHEN OTHERS THEN
941: IF g_debug <= gme_debug.g_log_unexpected THEN
942: gme_debug.put_line('When others exception in fetch Mtl Transactions');
943: END IF;
944: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_material_transactions');
945: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
946: x_error_msg := fnd_message.get;
947:
948: END Fetch_Material_Transactions;

Line 995: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_material_lot_transactions');

991: WHEN OTHERS THEN
992: IF g_debug <= gme_debug.g_log_unexpected THEN
993: gme_debug.put_line('When others exception in fetch Mtl Lot Transactions');
994: END IF;
995: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_material_lot_transactions');
996: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
997: x_error_msg := fnd_message.get;
998:
999: END Fetch_Lot_Transactions;

Line 1072: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','process_transactions');

1068: WHEN OTHERS THEN
1069: IF g_debug <= gme_debug.g_log_unexpected THEN
1070: gme_debug.put_line('When others exception in Process_Transactions');
1071: END IF;
1072: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','process_transactions');
1073: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1074: x_error_msg := fnd_message.get;
1075:
1076: END Process_Interface_Txn;

Line 1130: fnd_msg_pub.ADD;

1126:
1127: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1128: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
1129: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_LOT_API_PUB.VALIDATE_CHILD_LOT');
1130: fnd_msg_pub.ADD;
1131: RAISE fnd_api.g_exc_unexpected_error;
1132: END IF;
1133:
1134: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 1144: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1140: EXCEPTION
1141: WHEN NO_DATA_FOUND THEN
1142: x_return_status := FND_API.G_RET_STS_ERROR;
1143:
1144: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1145: p_count => l_msg_count,
1146: p_data => x_error_msg);
1147: if( l_msg_count > 1 ) then
1148: x_error_msg:= fnd_msg_pub.get(l_msg_count, FND_API.G_FALSE);

Line 1148: x_error_msg:= fnd_msg_pub.get(l_msg_count, FND_API.G_FALSE);

1144: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1145: p_count => l_msg_count,
1146: p_data => x_error_msg);
1147: if( l_msg_count > 1 ) then
1148: x_error_msg:= fnd_msg_pub.get(l_msg_count, FND_API.G_FALSE);
1149: end if;
1150:
1151: WHEN FND_API.G_EXC_ERROR THEN
1152: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1154: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1150:
1151: WHEN FND_API.G_EXC_ERROR THEN
1152: x_return_status := FND_API.G_RET_STS_ERROR;
1153:
1154: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1155: p_count => l_msg_count,
1156: p_data => l_msg_data);
1157: if( l_msg_count > 1 ) then
1158: x_error_msg := fnd_msg_pub.get(l_msg_count, FND_API.G_FALSE);

Line 1158: x_error_msg := fnd_msg_pub.get(l_msg_count, FND_API.G_FALSE);

1154: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1155: p_count => l_msg_count,
1156: p_data => l_msg_data);
1157: if( l_msg_count > 1 ) then
1158: x_error_msg := fnd_msg_pub.get(l_msg_count, FND_API.G_FALSE);
1159: end if;
1160:
1161: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1162: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1164: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1160:
1161: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1162: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1163:
1164: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1165: p_count => l_msg_count,
1166: p_data => l_msg_data);
1167: if( l_msg_count > 1 ) then
1168: x_error_msg := fnd_msg_pub.get(l_msg_count, FND_API.G_FALSE);

Line 1168: x_error_msg := fnd_msg_pub.get(l_msg_count, FND_API.G_FALSE);

1164: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1165: p_count => l_msg_count,
1166: p_data => l_msg_data);
1167: if( l_msg_count > 1 ) then
1168: x_error_msg := fnd_msg_pub.get(l_msg_count, FND_API.G_FALSE);
1169: end if;
1170:
1171:
1172: WHEN OTHERS THEN

Line 1175: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1171:
1172: WHEN OTHERS THEN
1173: x_return_status := fnd_api.g_ret_sts_error;
1174:
1175: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1176: p_count => l_msg_count,
1177: p_data => l_msg_data);
1178: if( l_msg_count > 1 ) then
1179: x_error_msg := fnd_msg_pub.get(l_msg_count, FND_API.G_FALSE);

Line 1179: x_error_msg := fnd_msg_pub.get(l_msg_count, FND_API.G_FALSE);

1175: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1176: p_count => l_msg_count,
1177: p_data => l_msg_data);
1178: if( l_msg_count > 1 ) then
1179: x_error_msg := fnd_msg_pub.get(l_msg_count, FND_API.G_FALSE);
1180: end if;
1181:
1182: END Validate_Child_Lot;
1183:

Line 1545: FND_MSG_PUB.count_and_get

1541: , x_row_id => l_row_id
1542: );
1543:
1544: IF l_return_status <> 'S' THEN
1545: FND_MSG_PUB.count_and_get
1546: ( p_count => l_msg_count
1547: , p_data => x_error_msg
1548: );
1549: END IF;

Line 1615: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Validate_Txn_Date');

1611: WHEN OTHERS THEN
1612: IF g_debug <= gme_debug.g_log_unexpected THEN
1613: gme_debug.put_line('When others exception in Validate Txn Date');
1614: END IF;
1615: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Validate_Txn_Date');
1616: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1617: x_error_msg := fnd_message.get;
1618:
1619: END Validate_Txn_Date;

Line 1712: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Validate_Batch_For_IB');

1708: WHEN OTHERS THEN
1709: IF g_debug <= gme_debug.g_log_unexpected THEN
1710: gme_debug.put_line('When others exception in Validate Batch For IB');
1711: END IF;
1712: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Validate_Batch_For_IB');
1713: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1714: x_error_msg := fnd_message.get;
1715:
1716: END Validate_Batch_For_IB;

Line 1798: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Validate_Item_For_IB');

1794: WHEN OTHERS THEN
1795: IF g_debug <= gme_debug.g_log_unexpected THEN
1796: gme_debug.put_line('When others exception in Validate Item For IB');
1797: END IF;
1798: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Validate_Item_For_IB');
1799: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1800: x_error_msg := fnd_message.get;
1801:
1802: END Validate_Item_For_IB;

Line 1890: FND_MSG_PUB.GET(p_msg_index => 1,

1886: FND_MESSAGE.SET_NAME('GME','GME_INCR_BACKFLUSH_EXCEPTIONS');
1887: x_error_msg := FND_MESSAGE.GET;
1888: RAISE BACKFLUSH_ERROR;
1889: ELSIF x_return_status <> 'S' THEN
1890: FND_MSG_PUB.GET(p_msg_index => 1,
1891: p_data => x_error_msg,
1892: p_encoded => 'F',
1893: p_msg_index_out => l_msg_index);
1894: RAISE BACKFLUSH_ERROR;

Line 1909: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Backflush_Material');

1905: WHEN OTHERS THEN
1906: IF g_debug <= gme_debug.g_log_unexpected THEN
1907: gme_debug.put_line('When others exception in Backflush Material');
1908: END IF;
1909: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Backflush_Material');
1910: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1911: x_error_msg := fnd_message.get;
1912: ROLLBACK;
1913:

Line 1981: FND_MSG_PUB.get

1977: IF l_msg_count > 0
1978: THEN
1979: FOR i IN 1..l_msg_count
1980: LOOP
1981: FND_MSG_PUB.get
1982: ( p_msg_index => i
1983: , p_data => message
1984: , p_encoded => fnd_api.g_false
1985: , p_msg_index_out => dummy

Line 2012: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Save_Resource_Usage');

2008: IF g_debug <= gme_debug.g_log_unexpected THEN
2009: gme_debug.put_line('When others exception in Save Resource Usage');
2010: END IF;
2011: x_result := -4;
2012: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Save_Resource_Usage');
2013: x_error_msg := fnd_message.get;
2014: ROLLBACK;
2015:
2016: END Save_Resource_Usage;

Line 2088: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_pending_product_lots');

2084: WHEN OTHERS THEN
2085: IF g_debug <= gme_debug.g_log_unexpected THEN
2086: gme_debug.put_line('When others exception in fetch Pending Lots');
2087: END IF;
2088: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_pending_product_lots');
2089: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2090: x_error_msg := fnd_message.get;
2091:
2092: END Fetch_Product_Pending_Lots;

Line 2152: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_rev_pending_product_lots');

2148: WHEN OTHERS THEN
2149: IF g_debug <= gme_debug.g_log_unexpected THEN
2150: gme_debug.put_line('When others exception in fetch Rev Pending Lots');
2151: END IF;
2152: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_rev_pending_product_lots');
2153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2154: x_error_msg := fnd_message.get;
2155:
2156: END Fetch_Rev_Product_Pending_Lots;

Line 2272: FND_MSG_PUB.count_and_get

2268:
2269:
2270: EXCEPTION
2271: WHEN OTHERS THEN
2272: FND_MSG_PUB.count_and_get
2273: ( p_count => l_message_count
2274: , p_data => x_error_msg
2275: );
2276: IF g_debug <= gme_debug.g_log_unexpected THEN

Line 2279: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','create_pending_product_lots');

2275: );
2276: IF g_debug <= gme_debug.g_log_unexpected THEN
2277: gme_debug.put_line('When others exception in Create Pending Lots');
2278: END IF;
2279: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','create_pending_product_lots');
2280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2281: x_error_msg := fnd_message.get;
2282:
2283: END Create_Product_Pending_Lot;

Line 2406: FND_MSG_PUB.count_and_get

2402: ,p_pending_product_lots_rec => l_pending_product_lots_rec
2403: ,x_pending_product_lots_rec => l_out_pending_product_lots_rec);
2404:
2405: IF x_return_status <> 'S' THEN
2406: FND_MSG_PUB.count_and_get
2407: ( p_count => l_message_count
2408: , p_data => x_error_msg
2409: );
2410: /* Bug 5438355: Added success message */

Line 2419: FND_MSG_PUB.count_and_get

2415: EXCEPTION
2416: WHEN OTHERS THEN
2417: IF g_debug <= gme_debug.g_log_unexpected THEN
2418: gme_debug.put_line('When others exception in Update Pending Lots');
2419: FND_MSG_PUB.count_and_get
2420: ( p_count => l_message_count
2421: , p_data => x_error_msg
2422: );
2423: gme_debug.put_line('Error = '||x_error_msg);

Line 2425: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','update_pending_product_lots');

2421: , p_data => x_error_msg
2422: );
2423: gme_debug.put_line('Error = '||x_error_msg);
2424: END IF;
2425: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','update_pending_product_lots');
2426: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2427:
2428: END Update_Product_Pending_Lot;
2429:

Line 2547: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Populate_Dispensing_Table');

2543: gme_debug.put_line(SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,
2544: 255));
2545:
2546: END IF;
2547: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Populate_Dispensing_Table');
2548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2549: x_error_msg := fnd_message.get;
2550:
2551: END Populate_Dispensing_Table;

Line 2590: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Delete_Dispensing_Record');

2586: WHEN OTHERS THEN
2587: IF g_debug <= gme_debug.g_log_unexpected THEN
2588: gme_debug.put_line('When others exception in Delete_Dispensing_Record');
2589: END IF;
2590: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Delete_Dispensing_Record');
2591: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2592: x_error_msg := fnd_message.get;
2593:
2594: END Delete_Dispensing_Record;

Line 2641: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Get_Dispensed_Lot_Count');

2637: WHEN OTHERS THEN
2638: IF g_debug <= gme_debug.g_log_unexpected THEN
2639: gme_debug.put_line('When others exception in Get_Dispensed_Lot_Count');
2640: END IF;
2641: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Get_Dispensed_Lot_Count');
2642: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2643: x_error_msg := fnd_message.get;
2644:
2645: END Get_Dispensed_Lot_Count;

Line 2757: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Query_Qty_Tree');

2753: WHEN OTHERS THEN
2754: IF g_debug <= gme_debug.g_log_unexpected THEN
2755: gme_debug.put_line('When others exception in Query_Qty_Tree');
2756: END IF;
2757: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Query_Qty_Tree');
2758:
2759: END Query_Qty_Tree;
2760:
2761: /*+========================================================================+

Line 2856: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Create_Qty_Tree');

2852: WHEN OTHERS THEN
2853: IF g_debug <= gme_debug.g_log_unexpected THEN
2854: gme_debug.put_line('When others exception in Create Qty Tree');
2855: END IF;
2856: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Create_Qty_Tree');
2857: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2858: x_error_msg := fnd_message.get;
2859:
2860: END Create_Qty_Tree;

Line 2948: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Query_Tree');

2944: WHEN OTHERS THEN
2945: IF g_debug <= gme_debug.g_log_unexpected THEN
2946: gme_debug.put_line('When others exception in Query_Tree');
2947: END IF;
2948: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Query_Tree');
2949: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2950: x_error_msg := fnd_message.get;
2951:
2952: END Query_Qty_Tree;

Line 3068: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Update_Qty_Tree');

3064: WHEN OTHERS THEN
3065: IF g_debug <= gme_debug.g_log_unexpected THEN
3066: gme_debug.put_line('When others exception in Update Qty Tree');
3067: END IF;
3068: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Update_Qty_Tree');
3069: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3070: x_error_msg := fnd_message.get;
3071:
3072: END Update_Qty_Tree;

Line 3225: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Validate_Item_To_Issue');

3221: WHEN OTHERS THEN
3222: IF g_debug <= gme_debug.g_log_unexpected THEN
3223: gme_debug.put_line('When others exception in Validate Item To Issue');
3224: END IF;
3225: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Validate_Item_To_Issue');
3226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3227: x_error_msg := fnd_message.get;
3228:
3229: END Validate_Item_To_Issue;

Line 3292: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Validate_Item_To_Return');

3288: WHEN OTHERS THEN
3289: IF g_debug <= gme_debug.g_log_unexpected THEN
3290: gme_debug.put_line('When others exception in Validate Item To Return');
3291: END IF;
3292: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Validate_Item_To_Return');
3293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3294: x_error_msg := fnd_message.get;
3295:
3296: END Validate_Item_To_Return;

Line 3395: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Validate_Prod_To_Yield');

3391: WHEN OTHERS THEN
3392: IF g_debug <= gme_debug.g_log_unexpected THEN
3393: gme_debug.put_line('When others exception in Validate Prod To Yield');
3394: END IF;
3395: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Validate_Prod_To_Yield');
3396: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3397: x_error_msg := fnd_message.get;
3398:
3399: END Validate_Prod_To_Yield;

Line 3470: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_issue_transactions');

3466: WHEN OTHERS THEN
3467: IF g_debug <= gme_debug.g_log_unexpected THEN
3468: gme_debug.put_line('When others exception in fetch Issue Transactions');
3469: END IF;
3470: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_issue_transactions');
3471: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3472: x_error_msg := fnd_message.get;
3473:
3474: END Fetch_Issue_Transactions;

Line 3549: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_yield_transactions');

3545: WHEN OTHERS THEN
3546: IF g_debug <= gme_debug.g_log_unexpected THEN
3547: gme_debug.put_line('When others exception in fetch yield Transactions');
3548: END IF;
3549: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_yield_transactions');
3550: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3551: x_error_msg := fnd_message.get;
3552:
3553: END Fetch_Yield_Transactions;

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

3671: x_return_status := fnd_api.g_ret_sts_unexp_error;
3672:
3673: WHEN OTHERS THEN
3674: x_return_status := fnd_api.g_ret_sts_unexp_error;
3675: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3676: x_error_msg := fnd_message.get;
3677: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
3678: gme_debug.put_line ( g_pkg_name
3679: || '.'

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

3868: x_trans_id := l_rsrc_txn_rec.poc_trans_id;
3869: EXCEPTION
3870: WHEN OTHERS THEN
3871: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3872: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3873: END End_Cmplt_Actual_Rsrc_Txn;
3874:
3875: /*###############################################################
3876: # DESCRIPTION

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

4011: FND_MESSAGE.SET_NAME('GME','GME_API_INV_BATCH_REL_STEP');
4012: x_message_list := FND_MESSAGE.GET;
4013: WHEN OTHERS THEN
4014: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4015: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
4016: END release_step;
4017:
4018: /*###############################################################
4019: # DESCRIPTION

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

4065: x_trans_id := l_rsrc_txn_rec.poc_trans_id;
4066: EXCEPTION
4067: WHEN OTHERS THEN
4068: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4069: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
4070: END Start_Cmplt_Actual_Rsrc_Txn;
4071:
4072: /*###############################################################
4073: # DESCRIPTION

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

4125: FND_MESSAGE.SET_NAME('GME', 'GME_CMPLT_DATE_OUTSIDE');
4126: x_error_msg := FND_MESSAGE.GET;
4127: WHEN OTHERS THEN
4128: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4129: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
4130: x_error_msg := FND_MESSAGE.GET;
4131: END Validate_Step_Completion_Date;
4132:
4133: /*###############################################################

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

4149: FND_MESSAGE.SET_NAME('GME', 'GME_VALUE_ERROR');
4150: x_error_msg := FND_MESSAGE.GET;
4151: WHEN OTHERS THEN
4152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4153: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
4154: x_error_msg := FND_MESSAGE.GET;
4155: END Validate_Step_Qty;
4156:
4157: /*###############################################################

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

4209: FND_MESSAGE.SET_NAME('GME', 'GME_STEP_START_BATCH_START_ERR');
4210: x_error_msg := FND_MESSAGE.GET;
4211: WHEN OTHERS THEN
4212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4213: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
4214: x_error_msg := FND_MESSAGE.GET;
4215: END Validate_Step_Start_Date;
4216:
4217: PROCEDURE check_close_period(p_org_id IN NUMBER,

Line 4303: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_txn_date');

4299: WHEN OTHERS THEN
4300: IF g_debug <= gme_debug.g_log_unexpected THEN
4301: gme_debug.put_line('When others exception in fetch_txn_date');
4302: END IF;
4303: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_txn_date');
4304: x_return_status := fnd_api.g_ret_sts_unexp_error;
4305: x_error_msg := fnd_message.get;
4306: END;
4307:

Line 4459: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Fetch_subinv_locator');

4455: WHEN OTHERS THEN
4456: IF g_debug <= gme_debug.g_log_unexpected THEN
4457: gme_debug.put_line('When others exception in Fetch_subinv_locator');
4458: END IF;
4459: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Fetch_subinv_locator');
4460: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4461: x_error_msg := fnd_message.get;
4462: END Fetch_subinv_locator;
4463:

Line 4502: fnd_msg_pub.ADD;

4498: gme_debug.put_line('Program inv_calculate_exp_date.get_lot_expiration_date has failed with a Unexpected exception');
4499: END IF;
4500: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
4501: FND_MESSAGE.SET_TOKEN('PROG_NAME','inv_calculate_exp_date.get_lot_expiration_date');
4502: fnd_msg_pub.ADD;
4503: RAISE fnd_api.g_exc_unexpected_error;
4504: END IF;
4505: IF g_debug = 1 THEN
4506: gme_debug.put_line('l_lot_expiration_date '||l_lot_expiration_date);