DBA Data[Home] [Help]

APPS.GME_MOBILE_TXN dependencies on FND_MSG_PUB

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

130: WHEN OTHERS THEN
131: IF g_debug <= gme_debug.g_log_unexpected THEN
132: gme_debug.put_line('When others exception in relieve_resvns_pend_lots');
133: END IF;
134: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','relieve_resvns_pend_lots');
135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
136: x_error_msg := fnd_message.get;
137:
138: END relieve_resvns_pend_lots;

Line 162: fnd_msg_pub.Count_And_Get

158: l_message VARCHAR2(2000);
159: l_msg_count NUMBER;
160: BEGIN
161:
162: fnd_msg_pub.Count_And_Get
163: (p_encoded => FND_API.g_false,
164: p_count => l_msg_count,
165: p_data => l_message
166: );

Line 169: fnd_msg_pub.delete_msg;

165: p_data => l_message
166: );
167:
168:
169: fnd_msg_pub.delete_msg;
170:
171: x_message := l_message;
172:
173: EXCEPTION

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

313: WHEN OTHERS THEN
314: IF g_debug <= gme_debug.g_log_unexpected THEN
315: gme_debug.put_line('When others exception in Create MAterial Txn');
316: END IF;
317: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','create_material_txn');
318: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
319: x_error_msg := fnd_message.get;
320:
321: END Create_Material_Txn;

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

391: WHEN OTHERS THEN
392: IF g_debug <= gme_debug.g_log_unexpected THEN
393: gme_debug.put_line('When others exception in Create Lot Txn');
394: END IF;
395: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','create_lot_txn');
396: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
397: x_error_msg := fnd_message.get;
398:
399: END Create_Lot_Txn;

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

471: WHEN OTHERS THEN
472: IF g_debug <= gme_debug.g_log_unexpected THEN
473: gme_debug.put_line('When others exception in Validate Indiv Lot Txn');
474: END IF;
475: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Validate_Indiv_Lot_Txn');
476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
477: x_error_msg := fnd_message.get;
478:
479: END Validate_Indiv_Lot_Txn;

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

604: WHEN OTHERS THEN
605: IF g_debug <= gme_debug.g_log_unexpected THEN
606: gme_debug.put_line('When others exception in Is_Material_Status_Applicable');
607: END IF;
608: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Is_Material_Status_Applicable');
609: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
610: x_error_msg := fnd_message.get;
611:
612: END Is_Material_Status_Applicable;

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

660: WHEN OTHERS THEN
661: IF g_debug <= gme_debug.g_log_unexpected THEN
662: gme_debug.put_line('When others exception in fetch aggrageted txns');
663: END IF;
664: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_aggregated_txns');
665: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
666: x_error_msg := fnd_message.get;
667:
668: END Fetch_Aggregated_Txns;

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

717: WHEN OTHERS THEN
718: IF g_debug <= gme_debug.g_log_unexpected THEN
719: gme_debug.put_line('When others exception in fetch aggrageted lot txns');
720: END IF;
721: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_aggregated_lot_txns');
722: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
723: x_error_msg := fnd_message.get;
724:
725: END Fetch_Aggregated_Lot_Txns;

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

777: WHEN OTHERS THEN
778: IF g_debug <= gme_debug.g_log_unexpected THEN
779: gme_debug.put_line('When others exception in fetch aggrageted lot txns');
780: END IF;
781: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_aggregated_rev_txns');
782: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
783: x_error_msg := fnd_message.get;
784:
785: END Fetch_Aggregated_Rev_Txns;

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

849: WHEN OTHERS THEN
850: IF g_debug <= gme_debug.g_log_unexpected THEN
851: gme_debug.put_line('When others exception in fetch Mtl Transactions');
852: END IF;
853: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_material_transactions');
854: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
855: x_error_msg := fnd_message.get;
856:
857: END Fetch_Material_Transactions;

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

900: WHEN OTHERS THEN
901: IF g_debug <= gme_debug.g_log_unexpected THEN
902: gme_debug.put_line('When others exception in fetch Mtl Lot Transactions');
903: END IF;
904: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_material_lot_transactions');
905: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
906: x_error_msg := fnd_message.get;
907:
908: END Fetch_Lot_Transactions;

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

972: WHEN OTHERS THEN
973: IF g_debug <= gme_debug.g_log_unexpected THEN
974: gme_debug.put_line('When others exception in Process_Transactions');
975: END IF;
976: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','process_transactions');
977: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
978: x_error_msg := fnd_message.get;
979:
980: END Process_Interface_Txn;

Line 1034: fnd_msg_pub.ADD;

1030:
1031: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1032: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
1033: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_LOT_API_PUB.VALIDATE_CHILD_LOT');
1034: fnd_msg_pub.ADD;
1035: RAISE fnd_api.g_exc_unexpected_error;
1036: END IF;
1037:
1038: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

1044: EXCEPTION
1045: WHEN NO_DATA_FOUND THEN
1046: x_return_status := FND_API.G_RET_STS_ERROR;
1047:
1048: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1049: p_count => l_msg_count,
1050: p_data => x_error_msg);
1051: if( l_msg_count > 1 ) then
1052: x_error_msg:= fnd_msg_pub.get(l_msg_count, FND_API.G_FALSE);

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

1048: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1049: p_count => l_msg_count,
1050: p_data => x_error_msg);
1051: if( l_msg_count > 1 ) then
1052: x_error_msg:= fnd_msg_pub.get(l_msg_count, FND_API.G_FALSE);
1053: end if;
1054:
1055: WHEN FND_API.G_EXC_ERROR THEN
1056: x_return_status := FND_API.G_RET_STS_ERROR;

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

1054:
1055: WHEN FND_API.G_EXC_ERROR THEN
1056: x_return_status := FND_API.G_RET_STS_ERROR;
1057:
1058: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1059: p_count => l_msg_count,
1060: p_data => l_msg_data);
1061: if( l_msg_count > 1 ) then
1062: x_error_msg := fnd_msg_pub.get(l_msg_count, FND_API.G_FALSE);

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

1058: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1059: p_count => l_msg_count,
1060: p_data => l_msg_data);
1061: if( l_msg_count > 1 ) then
1062: x_error_msg := fnd_msg_pub.get(l_msg_count, FND_API.G_FALSE);
1063: end if;
1064:
1065: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1066: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1064:
1065: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1066: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1067:
1068: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1069: p_count => l_msg_count,
1070: p_data => l_msg_data);
1071: if( l_msg_count > 1 ) then
1072: x_error_msg := fnd_msg_pub.get(l_msg_count, FND_API.G_FALSE);

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

1068: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1069: p_count => l_msg_count,
1070: p_data => l_msg_data);
1071: if( l_msg_count > 1 ) then
1072: x_error_msg := fnd_msg_pub.get(l_msg_count, FND_API.G_FALSE);
1073: end if;
1074:
1075:
1076: WHEN OTHERS THEN

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

1075:
1076: WHEN OTHERS THEN
1077: x_return_status := fnd_api.g_ret_sts_error;
1078:
1079: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1080: p_count => l_msg_count,
1081: p_data => l_msg_data);
1082: if( l_msg_count > 1 ) then
1083: x_error_msg := fnd_msg_pub.get(l_msg_count, FND_API.G_FALSE);

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

1079: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1080: p_count => l_msg_count,
1081: p_data => l_msg_data);
1082: if( l_msg_count > 1 ) then
1083: x_error_msg := fnd_msg_pub.get(l_msg_count, FND_API.G_FALSE);
1084: end if;
1085:
1086: END Validate_Child_Lot;
1087:

Line 1449: FND_MSG_PUB.count_and_get

1445: , x_row_id => l_row_id
1446: );
1447:
1448: IF l_return_status <> 'S' THEN
1449: FND_MSG_PUB.count_and_get
1450: ( p_count => l_msg_count
1451: , p_data => x_error_msg
1452: );
1453: END IF;

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

1515: WHEN OTHERS THEN
1516: IF g_debug <= gme_debug.g_log_unexpected THEN
1517: gme_debug.put_line('When others exception in Validate Txn Date');
1518: END IF;
1519: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Validate_Txn_Date');
1520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1521: x_error_msg := fnd_message.get;
1522:
1523: END Validate_Txn_Date;

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

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

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

1698: WHEN OTHERS THEN
1699: IF g_debug <= gme_debug.g_log_unexpected THEN
1700: gme_debug.put_line('When others exception in Validate Item For IB');
1701: END IF;
1702: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Validate_Item_For_IB');
1703: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1704: x_error_msg := fnd_message.get;
1705:
1706: END Validate_Item_For_IB;

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

1790: FND_MESSAGE.SET_NAME('GME','GME_INCR_BACKFLUSH_EXCEPTIONS');
1791: x_error_msg := FND_MESSAGE.GET;
1792: RAISE BACKFLUSH_ERROR;
1793: ELSIF x_return_status <> 'S' THEN
1794: FND_MSG_PUB.GET(p_msg_index => 1,
1795: p_data => x_error_msg,
1796: p_encoded => 'F',
1797: p_msg_index_out => l_msg_index);
1798: RAISE BACKFLUSH_ERROR;

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

1809: WHEN OTHERS THEN
1810: IF g_debug <= gme_debug.g_log_unexpected THEN
1811: gme_debug.put_line('When others exception in Backflush Material');
1812: END IF;
1813: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Backflush_Material');
1814: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1815: x_error_msg := fnd_message.get;
1816: ROLLBACK;
1817:

Line 1885: FND_MSG_PUB.get

1881: IF l_msg_count > 0
1882: THEN
1883: FOR i IN 1..l_msg_count
1884: LOOP
1885: FND_MSG_PUB.get
1886: ( p_msg_index => i
1887: , p_data => message
1888: , p_encoded => fnd_api.g_false
1889: , p_msg_index_out => dummy

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

1912: IF g_debug <= gme_debug.g_log_unexpected THEN
1913: gme_debug.put_line('When others exception in Save Resource Usage');
1914: END IF;
1915: x_result := -4;
1916: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Save_Resource_Usage');
1917: x_error_msg := fnd_message.get;
1918: ROLLBACK;
1919:
1920: END Save_Resource_Usage;

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

1988: WHEN OTHERS THEN
1989: IF g_debug <= gme_debug.g_log_unexpected THEN
1990: gme_debug.put_line('When others exception in fetch Pending Lots');
1991: END IF;
1992: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_pending_product_lots');
1993: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1994: x_error_msg := fnd_message.get;
1995:
1996: END Fetch_Product_Pending_Lots;

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

2052: WHEN OTHERS THEN
2053: IF g_debug <= gme_debug.g_log_unexpected THEN
2054: gme_debug.put_line('When others exception in fetch Rev Pending Lots');
2055: END IF;
2056: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_rev_pending_product_lots');
2057: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2058: x_error_msg := fnd_message.get;
2059:
2060: END Fetch_Rev_Product_Pending_Lots;

Line 2176: FND_MSG_PUB.count_and_get

2172:
2173:
2174: EXCEPTION
2175: WHEN OTHERS THEN
2176: FND_MSG_PUB.count_and_get
2177: ( p_count => l_message_count
2178: , p_data => x_error_msg
2179: );
2180: IF g_debug <= gme_debug.g_log_unexpected THEN

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

2179: );
2180: IF g_debug <= gme_debug.g_log_unexpected THEN
2181: gme_debug.put_line('When others exception in Create Pending Lots');
2182: END IF;
2183: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','create_pending_product_lots');
2184: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2185: x_error_msg := fnd_message.get;
2186:
2187: END Create_Product_Pending_Lot;

Line 2310: FND_MSG_PUB.count_and_get

2306: ,p_pending_product_lots_rec => l_pending_product_lots_rec
2307: ,x_pending_product_lots_rec => l_out_pending_product_lots_rec);
2308:
2309: IF x_return_status <> 'S' THEN
2310: FND_MSG_PUB.count_and_get
2311: ( p_count => l_message_count
2312: , p_data => x_error_msg
2313: );
2314: /* Bug 5438355: Added success message */

Line 2323: FND_MSG_PUB.count_and_get

2319: EXCEPTION
2320: WHEN OTHERS THEN
2321: IF g_debug <= gme_debug.g_log_unexpected THEN
2322: gme_debug.put_line('When others exception in Update Pending Lots');
2323: FND_MSG_PUB.count_and_get
2324: ( p_count => l_message_count
2325: , p_data => x_error_msg
2326: );
2327: gme_debug.put_line('Error = '||x_error_msg);

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

2325: , p_data => x_error_msg
2326: );
2327: gme_debug.put_line('Error = '||x_error_msg);
2328: END IF;
2329: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','update_pending_product_lots');
2330: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2331:
2332: END Update_Product_Pending_Lot;
2333:

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

2447: gme_debug.put_line(SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,
2448: 255));
2449:
2450: END IF;
2451: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Populate_Dispensing_Table');
2452: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2453: x_error_msg := fnd_message.get;
2454:
2455: END Populate_Dispensing_Table;

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

2490: WHEN OTHERS THEN
2491: IF g_debug <= gme_debug.g_log_unexpected THEN
2492: gme_debug.put_line('When others exception in Delete_Dispensing_Record');
2493: END IF;
2494: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Delete_Dispensing_Record');
2495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2496: x_error_msg := fnd_message.get;
2497:
2498: END Delete_Dispensing_Record;

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

2541: WHEN OTHERS THEN
2542: IF g_debug <= gme_debug.g_log_unexpected THEN
2543: gme_debug.put_line('When others exception in Get_Dispensed_Lot_Count');
2544: END IF;
2545: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Get_Dispensed_Lot_Count');
2546: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2547: x_error_msg := fnd_message.get;
2548:
2549: END Get_Dispensed_Lot_Count;

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

2657: WHEN OTHERS THEN
2658: IF g_debug <= gme_debug.g_log_unexpected THEN
2659: gme_debug.put_line('When others exception in Query_Qty_Tree');
2660: END IF;
2661: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Query_Qty_Tree');
2662:
2663: END Query_Qty_Tree;
2664:
2665: /*+========================================================================+

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

2756: WHEN OTHERS THEN
2757: IF g_debug <= gme_debug.g_log_unexpected THEN
2758: gme_debug.put_line('When others exception in Create Qty Tree');
2759: END IF;
2760: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Create_Qty_Tree');
2761: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2762: x_error_msg := fnd_message.get;
2763:
2764: END Create_Qty_Tree;

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

2848: WHEN OTHERS THEN
2849: IF g_debug <= gme_debug.g_log_unexpected THEN
2850: gme_debug.put_line('When others exception in Query_Tree');
2851: END IF;
2852: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Query_Tree');
2853: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2854: x_error_msg := fnd_message.get;
2855:
2856: END Query_Qty_Tree;

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

2968: WHEN OTHERS THEN
2969: IF g_debug <= gme_debug.g_log_unexpected THEN
2970: gme_debug.put_line('When others exception in Update Qty Tree');
2971: END IF;
2972: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Update_Qty_Tree');
2973: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2974: x_error_msg := fnd_message.get;
2975:
2976: END Update_Qty_Tree;

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

3125: WHEN OTHERS THEN
3126: IF g_debug <= gme_debug.g_log_unexpected THEN
3127: gme_debug.put_line('When others exception in Validate Item To Issue');
3128: END IF;
3129: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Validate_Item_To_Issue');
3130: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3131: x_error_msg := fnd_message.get;
3132:
3133: END Validate_Item_To_Issue;

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

3192: WHEN OTHERS THEN
3193: IF g_debug <= gme_debug.g_log_unexpected THEN
3194: gme_debug.put_line('When others exception in Validate Item To Return');
3195: END IF;
3196: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Validate_Item_To_Return');
3197: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3198: x_error_msg := fnd_message.get;
3199:
3200: END Validate_Item_To_Return;

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

3295: WHEN OTHERS THEN
3296: IF g_debug <= gme_debug.g_log_unexpected THEN
3297: gme_debug.put_line('When others exception in Validate Prod To Yield');
3298: END IF;
3299: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Validate_Prod_To_Yield');
3300: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3301: x_error_msg := fnd_message.get;
3302:
3303: END Validate_Prod_To_Yield;

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

3370: WHEN OTHERS THEN
3371: IF g_debug <= gme_debug.g_log_unexpected THEN
3372: gme_debug.put_line('When others exception in fetch Issue Transactions');
3373: END IF;
3374: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_issue_transactions');
3375: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3376: x_error_msg := fnd_message.get;
3377:
3378: END Fetch_Issue_Transactions;

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

3449: WHEN OTHERS THEN
3450: IF g_debug <= gme_debug.g_log_unexpected THEN
3451: gme_debug.put_line('When others exception in fetch yield Transactions');
3452: END IF;
3453: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_yield_transactions');
3454: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3455: x_error_msg := fnd_message.get;
3456:
3457: END Fetch_Yield_Transactions;

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

3575: x_return_status := fnd_api.g_ret_sts_unexp_error;
3576:
3577: WHEN OTHERS THEN
3578: x_return_status := fnd_api.g_ret_sts_unexp_error;
3579: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3580: x_error_msg := fnd_message.get;
3581: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
3582: gme_debug.put_line ( g_pkg_name
3583: || '.'

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

3764: x_trans_id := l_rsrc_txn_rec.poc_trans_id;
3765: EXCEPTION
3766: WHEN OTHERS THEN
3767: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3768: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3769: END End_Cmplt_Actual_Rsrc_Txn;
3770:
3771: /*###############################################################
3772: # DESCRIPTION

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

3897: FND_MESSAGE.SET_NAME('GME','GME_API_INV_BATCH_REL_STEP');
3898: x_message_list := FND_MESSAGE.GET;
3899: WHEN OTHERS THEN
3900: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3901: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3902: END release_step;
3903:
3904: /*###############################################################
3905: # DESCRIPTION

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

3951: x_trans_id := l_rsrc_txn_rec.poc_trans_id;
3952: EXCEPTION
3953: WHEN OTHERS THEN
3954: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3955: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3956: END Start_Cmplt_Actual_Rsrc_Txn;
3957:
3958: /*###############################################################
3959: # DESCRIPTION

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

3995: FND_MESSAGE.SET_NAME('GME', 'GME_CMPLT_DATE_OUTSIDE');
3996: x_error_msg := FND_MESSAGE.GET;
3997: WHEN OTHERS THEN
3998: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3999: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
4000: x_error_msg := FND_MESSAGE.GET;
4001: END Validate_Step_Completion_Date;
4002:
4003: /*###############################################################

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

4019: FND_MESSAGE.SET_NAME('GME', 'GME_VALUE_ERROR');
4020: x_error_msg := FND_MESSAGE.GET;
4021: WHEN OTHERS THEN
4022: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4023: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
4024: x_error_msg := FND_MESSAGE.GET;
4025: END Validate_Step_Qty;
4026:
4027: /*###############################################################

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

4079: FND_MESSAGE.SET_NAME('GME', 'GME_STEP_START_BATCH_START_ERR');
4080: x_error_msg := FND_MESSAGE.GET;
4081: WHEN OTHERS THEN
4082: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4083: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
4084: x_error_msg := FND_MESSAGE.GET;
4085: END Validate_Step_Start_Date;
4086:
4087: PROCEDURE check_close_period(p_org_id IN NUMBER,

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

4169: WHEN OTHERS THEN
4170: IF g_debug <= gme_debug.g_log_unexpected THEN
4171: gme_debug.put_line('When others exception in fetch_txn_date');
4172: END IF;
4173: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_txn_date');
4174: x_return_status := fnd_api.g_ret_sts_unexp_error;
4175: x_error_msg := fnd_message.get;
4176: END;
4177:

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

4325: WHEN OTHERS THEN
4326: IF g_debug <= gme_debug.g_log_unexpected THEN
4327: gme_debug.put_line('When others exception in Fetch_subinv_locator');
4328: END IF;
4329: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Fetch_subinv_locator');
4330: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4331: x_error_msg := fnd_message.get;
4332: END Fetch_subinv_locator;
4333:

Line 4372: fnd_msg_pub.ADD;

4368: gme_debug.put_line('Program inv_calculate_exp_date.get_lot_expiration_date has failed with a Unexpected exception');
4369: END IF;
4370: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
4371: FND_MESSAGE.SET_TOKEN('PROG_NAME','inv_calculate_exp_date.get_lot_expiration_date');
4372: fnd_msg_pub.ADD;
4373: RAISE fnd_api.g_exc_unexpected_error;
4374: END IF;
4375: IF g_debug = 1 THEN
4376: gme_debug.put_line('l_lot_expiration_date '||l_lot_expiration_date);