eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_MAINTAIN_RESERVATION_PUB dependencies on FND_MSG_PUB

Line 120: FND_MSG_PUB.Add;

116: END IF;
117: FND_MESSAGE.SET_NAME('INV','INV_API_MISSING_PARAM');
118: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
119: FND_MESSAGE.SET_TOKEN('MISSING_PARAM',p_param_name);
120: FND_MSG_PUB.Add;
121: RAISE FND_API.G_EXC_ERROR;
122: END IF;
123: END Check_Reqd_Param;
124:

Line 154: FND_MSG_PUB.Add;

150: -- $MISSING_PARAM is a required parameter.
151: FND_MESSAGE.SET_NAME('INV','INV_API_MISSING_PARAM');
152: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
153: FND_MESSAGE.SET_TOKEN('MISSING_PARAM',p_param_name);
154: FND_MSG_PUB.Add;
155: RAISE FND_API.G_EXC_ERROR;
156: END IF;
157: END Check_Reqd_Param;
158:

Line 186: FND_MSG_PUB.Add;

182:
183: FND_MESSAGE.SET_NAME('INV','INV_API_MISSING_PARAM');
184: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
185: FND_MESSAGE.SET_TOKEN('MISSING_PARAM',p_param_name);
186: FND_MSG_PUB.Add;
187: RAISE FND_API.G_EXC_ERROR;
188: END IF;
189: END Check_Reqd_Param;
190:

Line 294: fnd_msg_pub.initialize;

290:
291: -- initialize message list. null value for p_init_msg_lst variable will be treated as 'n'
292: -- codereview.su.05 remove nvl function
293: if fnd_api.to_boolean(p_init_msg_lst) then
294: fnd_msg_pub.initialize;
295: end if;
296:
297: if (g_debug= c_debug_enabled) then
298: mydebug ('before checking for required parameters' ,c_api_name,1);

Line 512: fnd_msg_pub.add;

508: -- "invalid value for parameter $param_name : $param_value
509: fnd_message.set_name('inv','inv_api_invalid_param_value');
510: fnd_message.set_token('param_name','action');
511: fnd_message.set_token('param_value',p_mtl_maintain_rsv_rec.action);
512: fnd_msg_pub.add;
513: raise fnd_api.g_exc_error;
514:
515: end if;
516: -- query the reservation records for supply based on sort by criteria passed by user.

Line 625: fnd_msg_pub.add;

621: end if;
622: -- new message 003 . this is a warning not an error message
623: -- "query reservation api returns no records"
624: fnd_message.set_name('inv','inv_qry_rsv_api_rtns_no_rec');
625: fnd_msg_pub.add;
626: return ;
627: end if;
628: -- dbms_output.put_line('checking delete flag status');
629: if upper(nvl(p_delete_flag,'N')) = 'Y' then

Line 656: fnd_msg_pub.add;

652: if (g_debug= c_debug_enabled) then
653: mydebug ('Staged reservation exists. Error out' ,c_api_name,1);
654: end if;
655: fnd_message.set_name('INV','INV_RSV_REC_IN_STAGING');
656: fnd_msg_pub.add;
657: raise fnd_api.g_exc_error;
658: end if;
659:
660: -- dbms_output.put_line('delete flag is yes');

Line 1171: fnd_msg_pub.count_and_get

1167: when fnd_api.g_exc_error then
1168: x_return_status := fnd_api.g_ret_sts_error;
1169:
1170: -- get message count and data
1171: fnd_msg_pub.count_and_get
1172: ( p_count => x_msg_count
1173: , p_data => x_msg_data
1174: );
1175:

Line 1194: fnd_msg_pub.get

1190: mydebug(l_fnd_log_message,c_api_name,9);
1191: end if;
1192: elsif x_msg_count > 1 then
1193: for i in 1..x_msg_count loop
1194: fnd_msg_pub.get
1195: (p_msg_index => i,
1196: p_encoded => 'f',
1197: p_data => l_fnd_log_message,
1198: p_msg_index_out => l_msg_index_out );

Line 1214: fnd_msg_pub.count_and_get

1210: when fnd_api.g_exc_unexpected_error then
1211: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1212:
1213: -- get message count and data
1214: fnd_msg_pub.count_and_get
1215: ( p_count => x_msg_count
1216: , p_data => x_msg_data
1217: );
1218: -- call fnd_log api at the end of the api

Line 1237: fnd_msg_pub.get

1233: mydebug(l_fnd_log_message,c_api_name,9);
1234: end if;
1235: elsif x_msg_count > 1 then
1236: for i in 1..x_msg_count loop
1237: fnd_msg_pub.get
1238: (p_msg_index => i,
1239: p_encoded => 'f',
1240: p_data => l_fnd_log_message,
1241: p_msg_index_out => l_msg_index_out );

Line 1255: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)

1251:
1252: when others then
1253: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1254:
1255: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1256: then
1257: fnd_msg_pub.add_exc_msg
1258: ( g_pkg_name
1259: , c_api_name

Line 1257: fnd_msg_pub.add_exc_msg

1253: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1254:
1255: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1256: then
1257: fnd_msg_pub.add_exc_msg
1258: ( g_pkg_name
1259: , c_api_name
1260: );
1261: end if;

Line 1264: fnd_msg_pub.count_and_get

1260: );
1261: end if;
1262:
1263: -- get message count and data
1264: fnd_msg_pub.count_and_get
1265: ( p_count => x_msg_count
1266: , p_data => x_msg_data
1267: );
1268:

Line 1288: fnd_msg_pub.get

1284: mydebug(l_fnd_log_message,c_api_name,9);
1285: end if;
1286: elsif x_msg_count > 1 then
1287: for i in 1..x_msg_count loop
1288: fnd_msg_pub.get
1289: (p_msg_index => i,
1290: p_encoded => 'f',
1291: p_data => l_fnd_log_message,
1292: p_msg_index_out => l_msg_index_out );

Line 1579: fnd_msg_pub.count_and_get

1575: when fnd_api.g_exc_error then
1576: x_return_status := fnd_api.g_ret_sts_error;
1577:
1578: -- get message count and data
1579: fnd_msg_pub.count_and_get
1580: ( p_count => x_msg_count
1581: , p_data => x_msg_data
1582: );
1583:

Line 1602: fnd_msg_pub.get

1598: mydebug(l_fnd_log_message,c_api_name,9);
1599: end if;
1600: elsif x_msg_count > 1 then
1601: for i in 1..x_msg_count loop
1602: fnd_msg_pub.get
1603: (p_msg_index => i,
1604: p_encoded => 'f',
1605: p_data => l_fnd_log_message,
1606: p_msg_index_out => l_msg_index_out );

Line 1622: fnd_msg_pub.count_and_get

1618: when fnd_api.g_exc_unexpected_error then
1619: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1620:
1621: -- get message count and data
1622: fnd_msg_pub.count_and_get
1623: ( p_count => x_msg_count
1624: , p_data => x_msg_data
1625: );
1626: -- call fnd_log api at the end of the api

Line 1645: fnd_msg_pub.get

1641: mydebug(l_fnd_log_message,c_api_name,9);
1642: end if;
1643: elsif x_msg_count > 1 then
1644: for i in 1..x_msg_count loop
1645: fnd_msg_pub.get
1646: (p_msg_index => i,
1647: p_encoded => 'f',
1648: p_data => l_fnd_log_message,
1649: p_msg_index_out => l_msg_index_out );

Line 1663: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)

1659:
1660: when others then
1661: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1662:
1663: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1664: then
1665: fnd_msg_pub.add_exc_msg
1666: ( g_pkg_name
1667: , c_api_name

Line 1665: fnd_msg_pub.add_exc_msg

1661: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1662:
1663: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1664: then
1665: fnd_msg_pub.add_exc_msg
1666: ( g_pkg_name
1667: , c_api_name
1668: );
1669: END IF;

Line 1672: fnd_msg_pub.count_and_get

1668: );
1669: END IF;
1670:
1671: -- Get message count and data
1672: fnd_msg_pub.count_and_get
1673: ( p_count => x_msg_count
1674: , p_data => x_msg_data
1675: );
1676:

Line 1696: FND_MSG_PUB.Get

1692: mydebug(l_Fnd_Log_Message,c_api_name,9);
1693: End If;
1694: Elsif X_Msg_Count > 1 Then
1695: For I In 1..X_Msg_Count Loop
1696: FND_MSG_PUB.Get
1697: (p_msg_index => i,
1698: p_encoded => 'F',
1699: p_data => l_Fnd_Log_Message,
1700: p_msg_index_out => l_msg_index_out );

Line 1771: FND_MSG_PUB.Add;

1767: END IF;
1768:
1769: IF p_supply_source_type_id IS NULL THEN
1770: FND_MESSAGE.SET_NAME('INV','INV_API_NULL_SOURCE_TYPE_ID');
1771: FND_MSG_PUB.Add;
1772: RAISE fnd_api.g_exc_unexpected_error;
1773: ELSIF p_supply_source_type_id NOT IN
1774: (inv_reservation_global.g_source_type_po,
1775: inv_reservation_global.g_source_type_internal_req,

Line 1778: FND_MSG_PUB.Add;

1774: (inv_reservation_global.g_source_type_po,
1775: inv_reservation_global.g_source_type_internal_req,
1776: inv_reservation_global.g_source_type_req) THEN
1777: FND_MESSAGE.SET_NAME('INV','INV_API_INVALID_SOURCE_TYPE_ID');
1778: FND_MSG_PUB.Add;
1779: RAISE fnd_api.g_exc_unexpected_error;
1780: END IF;
1781:
1782: IF p_project_id is not null THEN

Line 1849: fnd_msg_pub.count_and_get

1845: x_return_status := fnd_api.g_ret_sts_error;
1846: x_record_count := -1;
1847:
1848: -- Get message count and data
1849: fnd_msg_pub.count_and_get
1850: ( p_count => x_msg_count
1851: , p_data => x_msg_data
1852: );
1853:

Line 1872: FND_MSG_PUB.Get

1868: mydebug(l_Fnd_Log_Message,c_api_name,9);
1869: End If;
1870: Elsif x_msg_count > 1 Then
1871: For I In 1..X_Msg_Count Loop
1872: FND_MSG_PUB.Get
1873: (p_msg_index => i,
1874: p_encoded => 'F',
1875: p_data => l_Fnd_Log_Message,
1876: p_msg_index_out => l_msg_index_out );

Line 1893: fnd_msg_pub.count_and_get

1889: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1890: x_record_count := -1;
1891:
1892: -- Get message count and data
1893: fnd_msg_pub.count_and_get
1894: ( p_count => x_msg_count
1895: , p_data => x_msg_data
1896: );
1897: -- Call fnd_log api at the end of the API

Line 1916: FND_MSG_PUB.Get

1912: mydebug(l_Fnd_Log_Message,c_api_name,9);
1913: END IF;
1914: Elsif X_Msg_Count > 1 Then
1915: For I In 1..X_Msg_Count Loop
1916: FND_MSG_PUB.Get
1917: (p_msg_index => i,
1918: p_encoded => 'F',
1919: p_data => l_Fnd_Log_Message,
1920: p_msg_index_out => l_msg_index_out );

Line 1935: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)

1931: WHEN OTHERS THEN
1932: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1933: x_record_count := -1;
1934:
1935: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1936: THEN
1937: fnd_msg_pub.add_exc_msg
1938: ( g_pkg_name
1939: , c_api_name

Line 1937: fnd_msg_pub.add_exc_msg

1933: x_record_count := -1;
1934:
1935: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1936: THEN
1937: fnd_msg_pub.add_exc_msg
1938: ( g_pkg_name
1939: , c_api_name
1940: );
1941: END IF;

Line 1944: fnd_msg_pub.count_and_get

1940: );
1941: END IF;
1942:
1943: -- Get message count and data
1944: fnd_msg_pub.count_and_get
1945: ( p_count => x_msg_count
1946: , p_data => x_msg_data
1947: );
1948:

Line 1968: FND_MSG_PUB.Get

1964: mydebug(l_Fnd_Log_Message,c_api_name,9);
1965: End If;
1966: Elsif X_Msg_Count > 1 Then
1967: For I In 1..X_Msg_Count Loop
1968: FND_MSG_PUB.Get
1969: (p_msg_index => i,
1970: p_encoded => 'F',
1971: p_data => l_Fnd_Log_Message,
1972: p_msg_index_out => l_msg_index_out );

Line 2308: fnd_msg_pub.count_and_get

2304: WHEN fnd_api.g_exc_error THEN
2305: x_return_status := fnd_api.g_ret_sts_error;
2306:
2307: -- Get message count and data
2308: fnd_msg_pub.count_and_get
2309: ( p_count => x_msg_count
2310: , p_data => x_msg_data
2311: );
2312:

Line 2331: FND_MSG_PUB.Get

2327: mydebug(l_Fnd_Log_Message,c_api_name,9);
2328: End If;
2329: Elsif x_msg_count > 1 Then
2330: For I In 1..X_Msg_Count Loop
2331: FND_MSG_PUB.Get
2332: (p_msg_index => i,
2333: p_encoded => 'F',
2334: p_data => l_Fnd_Log_Message,
2335: p_msg_index_out => l_msg_index_out );

Line 2351: fnd_msg_pub.count_and_get

2347: WHEN fnd_api.g_exc_unexpected_error THEN
2348: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2349:
2350: -- Get message count and data
2351: fnd_msg_pub.count_and_get
2352: ( p_count => x_msg_count
2353: , p_data => x_msg_data
2354: );
2355: -- Call fnd_log api at the end of the API

Line 2374: FND_MSG_PUB.Get

2370: mydebug(l_Fnd_Log_Message,c_api_name,9);
2371: END IF;
2372: Elsif X_Msg_Count > 1 Then
2373: For I In 1..X_Msg_Count Loop
2374: FND_MSG_PUB.Get
2375: (p_msg_index => i,
2376: p_encoded => 'F',
2377: p_data => l_Fnd_Log_Message,
2378: p_msg_index_out => l_msg_index_out );

Line 2392: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)

2388:
2389: WHEN OTHERS THEN
2390: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2391:
2392: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
2393: THEN
2394: fnd_msg_pub.add_exc_msg
2395: ( g_pkg_name
2396: , c_api_name

Line 2394: fnd_msg_pub.add_exc_msg

2390: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2391:
2392: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
2393: THEN
2394: fnd_msg_pub.add_exc_msg
2395: ( g_pkg_name
2396: , c_api_name
2397: );
2398: END IF;

Line 2401: fnd_msg_pub.count_and_get

2397: );
2398: END IF;
2399:
2400: -- Get message count and data
2401: fnd_msg_pub.count_and_get
2402: ( p_count => x_msg_count
2403: , p_data => x_msg_data
2404: );
2405:

Line 2425: FND_MSG_PUB.Get

2421: mydebug(l_Fnd_Log_Message,c_api_name,9);
2422: End If;
2423: Elsif X_Msg_Count > 1 Then
2424: For I In 1..X_Msg_Count Loop
2425: FND_MSG_PUB.Get
2426: (p_msg_index => i,
2427: p_encoded => 'F',
2428: p_data => l_Fnd_Log_Message,
2429: p_msg_index_out => l_msg_index_out );

Line 2620: fnd_msg_pub.count_and_get

2616: WHEN fnd_api.g_exc_error THEN
2617: x_return_status := fnd_api.g_ret_sts_error;
2618:
2619: -- Get message count and data
2620: fnd_msg_pub.count_and_get
2621: ( p_count => x_msg_count
2622: , p_data => x_msg_data
2623: );
2624:

Line 2643: FND_MSG_PUB.Get

2639: mydebug(l_Fnd_Log_Message,c_api_name,9);
2640: End If;
2641: Elsif x_msg_count > 1 Then
2642: For I In 1..X_Msg_Count Loop
2643: FND_MSG_PUB.Get
2644: (p_msg_index => i,
2645: p_encoded => 'F',
2646: p_data => l_Fnd_Log_Message,
2647: p_msg_index_out => l_msg_index_out );

Line 2662: fnd_msg_pub.count_and_get

2658: WHEN fnd_api.g_exc_unexpected_error THEN
2659: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2660:
2661: -- Get message count and data
2662: fnd_msg_pub.count_and_get
2663: ( p_count => x_msg_count
2664: , p_data => x_msg_data
2665: );
2666: -- Call fnd_log api at the end of the API

Line 2685: FND_MSG_PUB.Get

2681: mydebug(l_Fnd_Log_Message,c_api_name,9);
2682: END IF;
2683: Elsif X_Msg_Count > 1 Then
2684: For I In 1..X_Msg_Count Loop
2685: FND_MSG_PUB.Get
2686: (p_msg_index => i,
2687: p_encoded => 'F',
2688: p_data => l_Fnd_Log_Message,
2689: p_msg_index_out => l_msg_index_out );

Line 2703: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)

2699:
2700: WHEN OTHERS THEN
2701: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2702:
2703: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
2704: THEN
2705: fnd_msg_pub.add_exc_msg
2706: ( g_pkg_name
2707: , c_api_name

Line 2705: fnd_msg_pub.add_exc_msg

2701: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2702:
2703: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
2704: THEN
2705: fnd_msg_pub.add_exc_msg
2706: ( g_pkg_name
2707: , c_api_name
2708: );
2709: END IF;

Line 2712: fnd_msg_pub.count_and_get

2708: );
2709: END IF;
2710:
2711: -- Get message count and data
2712: fnd_msg_pub.count_and_get
2713: ( p_count => x_msg_count
2714: , p_data => x_msg_data
2715: );
2716:

Line 2736: FND_MSG_PUB.Get

2732: mydebug(l_Fnd_Log_Message,c_api_name,9);
2733: End If;
2734: Elsif X_Msg_Count > 1 Then
2735: For I In 1..X_Msg_Count Loop
2736: FND_MSG_PUB.Get
2737: (p_msg_index => i,
2738: p_encoded => 'F',
2739: p_data => l_Fnd_Log_Message,
2740: p_msg_index_out => l_msg_index_out );

Line 2859: fnd_msg_pub.count_and_get

2855: WHEN fnd_api.g_exc_error THEN
2856: x_return_status := fnd_api.g_ret_sts_error;
2857:
2858: -- Get message count and data
2859: fnd_msg_pub.count_and_get
2860: ( p_count => x_msg_count
2861: , p_data => x_msg_data
2862: );
2863:

Line 2882: FND_MSG_PUB.Get

2878: mydebug(l_Fnd_Log_Message,c_api_name,9);
2879: End If;
2880: Elsif x_msg_count > 1 Then
2881: For I In 1..X_Msg_Count Loop
2882: FND_MSG_PUB.Get
2883: (p_msg_index => i,
2884: p_encoded => 'F',
2885: p_data => l_Fnd_Log_Message,
2886: p_msg_index_out => l_msg_index_out );

Line 2901: fnd_msg_pub.count_and_get

2897: WHEN fnd_api.g_exc_unexpected_error THEN
2898: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2899:
2900: -- Get message count and data
2901: fnd_msg_pub.count_and_get
2902: ( p_count => x_msg_count
2903: , p_data => x_msg_data
2904: );
2905: -- Call fnd_log api at the end of the API

Line 2924: FND_MSG_PUB.Get

2920: mydebug(l_Fnd_Log_Message,c_api_name,9);
2921: END IF;
2922: Elsif X_Msg_Count > 1 Then
2923: For I In 1..X_Msg_Count Loop
2924: FND_MSG_PUB.Get
2925: (p_msg_index => i,
2926: p_encoded => 'F',
2927: p_data => l_Fnd_Log_Message,
2928: p_msg_index_out => l_msg_index_out );

Line 2942: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)

2938:
2939: WHEN OTHERS THEN
2940: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2941:
2942: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
2943: THEN
2944: fnd_msg_pub.add_exc_msg
2945: ( g_pkg_name
2946: , c_api_name

Line 2944: fnd_msg_pub.add_exc_msg

2940: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2941:
2942: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
2943: THEN
2944: fnd_msg_pub.add_exc_msg
2945: ( g_pkg_name
2946: , c_api_name
2947: );
2948: END IF;

Line 2951: fnd_msg_pub.count_and_get

2947: );
2948: END IF;
2949:
2950: -- Get message count and data
2951: fnd_msg_pub.count_and_get
2952: ( p_count => x_msg_count
2953: , p_data => x_msg_data
2954: );
2955:

Line 2975: FND_MSG_PUB.Get

2971: mydebug(l_Fnd_Log_Message,c_api_name,9);
2972: End If;
2973: Elsif X_Msg_Count > 1 Then
2974: For I In 1..X_Msg_Count Loop
2975: FND_MSG_PUB.Get
2976: (p_msg_index => i,
2977: p_encoded => 'F',
2978: p_data => l_Fnd_Log_Message,
2979: p_msg_index_out => l_msg_index_out );

Line 3056: FND_MSG_PUB.Add;

3052: WHEN OTHERS THEN
3053: --po_message_s.sql_error('UOM_CONVERSION', '010', sqlcode);
3054: -- inv message....
3055: FND_MESSAGE.SET_NAME('INV','INV_RSV_UOM_CONVERSION');
3056: FND_MSG_PUB.Add;
3057: IF G_debug= C_Debug_Enabled THEN
3058: l_Fnd_Log_message := 'OTHERS exception happens when geting item_id, primary_uom, res_uom';
3059: mydebug(l_Fnd_Log_Message,c_api_name,9);
3060: END IF;

Line 4034: FND_MSG_PUB.Add;

4030: END IF;
4031:
4032: ELSE -- if did not have any req reservation existing
4033: FND_MESSAGE.SET_NAME('INV','INV_API_NO_RSV_EXIST');
4034: FND_MSG_PUB.Add;
4035: l_Fnd_Log_Message := 'calling get_req_line_res, no reservation records';
4036: mydebug(l_Fnd_Log_Message, c_api_name,9);
4037: END IF; -- record_count
4038:

Line 4108: FND_MSG_PUB.Add;

4104: mydebug(l_Fnd_Log_Message, c_api_name,9);
4105: END IF;
4106: ELSE
4107: FND_MESSAGE.SET_NAME('INV','INV_API_NO_RSV_EXIST');
4108: FND_MSG_PUB.Add;
4109: l_Fnd_Log_Message := 'calling get_req_line_res, no reservation records';
4110: mydebug(l_Fnd_Log_Message, c_api_name,9);
4111: END IF;
4112:

Line 4345: FND_MSG_PUB.ADD;

4341: -- END IF;
4342:
4343: IF (p_transaction_id IS NULL) THEN
4344: FND_MESSAGE.SET_NAME('INV','INV_INVALID_TRANSACTION_ID');
4345: FND_MSG_PUB.ADD;
4346: RAISE fnd_api.g_exc_error;
4347: END IF;
4348:
4349: OPEN get_source_doc_code(p_transaction_id);

Line 5303: FND_MSG_PUB.Add;

5299:
5300: ELSE -- if did not have any req reservation existing
5301: IF g_debug= C_Debug_Enabled THEN
5302: FND_MESSAGE.SET_NAME('INV','INV_API_NO_RSV_EXIST');
5303: FND_MSG_PUB.Add;
5304: l_Fnd_Log_Message := 'l_record_count < 0';
5305: mydebug(l_Fnd_Log_Message, c_api_name,9);
5306: END IF;
5307: END IF; -- record_count

Line 6177: fnd_msg_pub.count_and_get

6173: WHEN fnd_api.g_exc_error THEN
6174: x_return_status := fnd_api.g_ret_sts_error;
6175:
6176: -- Get message count and data
6177: fnd_msg_pub.count_and_get
6178: ( p_count => x_msg_count
6179: , p_data => x_msg_data
6180: );
6181:

Line 6200: FND_MSG_PUB.Get

6196: mydebug(l_Fnd_Log_Message,c_api_name,9);
6197: End If;
6198: Elsif x_msg_count > 1 Then
6199: For I In 1..X_Msg_Count Loop
6200: FND_MSG_PUB.Get
6201: (p_msg_index => i,
6202: p_encoded => 'F',
6203: p_data => l_Fnd_Log_Message,
6204: p_msg_index_out => l_msg_index_out );

Line 6219: fnd_msg_pub.count_and_get

6215: WHEN fnd_api.g_exc_unexpected_error THEN
6216: x_return_status := fnd_api.g_ret_sts_unexp_error ;
6217:
6218: -- Get message count and data
6219: fnd_msg_pub.count_and_get
6220: ( p_count => x_msg_count
6221: , p_data => x_msg_data
6222: );
6223: -- Call fnd_log api at the end of the API

Line 6242: FND_MSG_PUB.Get

6238: mydebug(l_Fnd_Log_Message,c_api_name,9);
6239: END IF;
6240: Elsif X_Msg_Count > 1 Then
6241: For I In 1..X_Msg_Count Loop
6242: FND_MSG_PUB.Get
6243: (p_msg_index => i,
6244: p_encoded => 'F',
6245: p_data => l_Fnd_Log_Message,
6246: p_msg_index_out => l_msg_index_out );

Line 6260: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)

6256:
6257: WHEN OTHERS THEN
6258: x_return_status := fnd_api.g_ret_sts_unexp_error ;
6259:
6260: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
6261: THEN
6262: fnd_msg_pub.add_exc_msg
6263: ( g_pkg_name
6264: , c_api_name

Line 6262: fnd_msg_pub.add_exc_msg

6258: x_return_status := fnd_api.g_ret_sts_unexp_error ;
6259:
6260: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
6261: THEN
6262: fnd_msg_pub.add_exc_msg
6263: ( g_pkg_name
6264: , c_api_name
6265: );
6266: END IF;

Line 6269: fnd_msg_pub.count_and_get

6265: );
6266: END IF;
6267:
6268: -- Get message count and data
6269: fnd_msg_pub.count_and_get
6270: ( p_count => x_msg_count
6271: , p_data => x_msg_data
6272: );
6273:

Line 6293: FND_MSG_PUB.Get

6289: mydebug(l_Fnd_Log_Message,c_api_name,9);
6290: End If;
6291: Elsif X_Msg_Count > 1 Then
6292: For I In 1..X_Msg_Count Loop
6293: FND_MSG_PUB.Get
6294: (p_msg_index => i,
6295: p_encoded => 'F',
6296: p_data => l_Fnd_Log_Message,
6297: p_msg_index_out => l_msg_index_out );