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 188: FND_MSG_PUB.Add;

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

Line 296: fnd_msg_pub.initialize;

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

Line 517: fnd_msg_pub.add;

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

Line 628: fnd_msg_pub.add;

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

Line 659: fnd_msg_pub.add;

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

Line 1146: fnd_msg_pub.count_and_get

1142: when fnd_api.g_exc_error then
1143: x_return_status := fnd_api.g_ret_sts_error;
1144:
1145: -- get message count and data
1146: fnd_msg_pub.count_and_get
1147: ( p_count => x_msg_count
1148: , p_data => x_msg_data
1149: );
1150:

Line 1169: fnd_msg_pub.get

1165: mydebug(l_fnd_log_message,c_api_name,9);
1166: end if;
1167: elsif x_msg_count > 1 then
1168: for i in 1..x_msg_count loop
1169: fnd_msg_pub.get
1170: (p_msg_index => i,
1171: p_encoded => 'f',
1172: p_data => l_fnd_log_message,
1173: p_msg_index_out => l_msg_index_out );

Line 1189: fnd_msg_pub.count_and_get

1185: when fnd_api.g_exc_unexpected_error then
1186: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1187:
1188: -- get message count and data
1189: fnd_msg_pub.count_and_get
1190: ( p_count => x_msg_count
1191: , p_data => x_msg_data
1192: );
1193: -- call fnd_log api at the end of the api

Line 1212: fnd_msg_pub.get

1208: mydebug(l_fnd_log_message,c_api_name,9);
1209: end if;
1210: elsif x_msg_count > 1 then
1211: for i in 1..x_msg_count loop
1212: fnd_msg_pub.get
1213: (p_msg_index => i,
1214: p_encoded => 'f',
1215: p_data => l_fnd_log_message,
1216: p_msg_index_out => l_msg_index_out );

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

1226:
1227: when others then
1228: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1229:
1230: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1231: then
1232: fnd_msg_pub.add_exc_msg
1233: ( g_pkg_name
1234: , c_api_name

Line 1232: fnd_msg_pub.add_exc_msg

1228: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1229:
1230: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1231: then
1232: fnd_msg_pub.add_exc_msg
1233: ( g_pkg_name
1234: , c_api_name
1235: );
1236: end if;

Line 1239: fnd_msg_pub.count_and_get

1235: );
1236: end if;
1237:
1238: -- get message count and data
1239: fnd_msg_pub.count_and_get
1240: ( p_count => x_msg_count
1241: , p_data => x_msg_data
1242: );
1243:

Line 1263: fnd_msg_pub.get

1259: mydebug(l_fnd_log_message,c_api_name,9);
1260: end if;
1261: elsif x_msg_count > 1 then
1262: for i in 1..x_msg_count loop
1263: fnd_msg_pub.get
1264: (p_msg_index => i,
1265: p_encoded => 'f',
1266: p_data => l_fnd_log_message,
1267: p_msg_index_out => l_msg_index_out );

Line 1554: fnd_msg_pub.count_and_get

1550: when fnd_api.g_exc_error then
1551: x_return_status := fnd_api.g_ret_sts_error;
1552:
1553: -- get message count and data
1554: fnd_msg_pub.count_and_get
1555: ( p_count => x_msg_count
1556: , p_data => x_msg_data
1557: );
1558:

Line 1577: fnd_msg_pub.get

1573: mydebug(l_fnd_log_message,c_api_name,9);
1574: end if;
1575: elsif x_msg_count > 1 then
1576: for i in 1..x_msg_count loop
1577: fnd_msg_pub.get
1578: (p_msg_index => i,
1579: p_encoded => 'f',
1580: p_data => l_fnd_log_message,
1581: p_msg_index_out => l_msg_index_out );

Line 1597: fnd_msg_pub.count_and_get

1593: when fnd_api.g_exc_unexpected_error then
1594: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1595:
1596: -- get message count and data
1597: fnd_msg_pub.count_and_get
1598: ( p_count => x_msg_count
1599: , p_data => x_msg_data
1600: );
1601: -- call fnd_log api at the end of the api

Line 1620: fnd_msg_pub.get

1616: mydebug(l_fnd_log_message,c_api_name,9);
1617: end if;
1618: elsif x_msg_count > 1 then
1619: for i in 1..x_msg_count loop
1620: fnd_msg_pub.get
1621: (p_msg_index => i,
1622: p_encoded => 'f',
1623: p_data => l_fnd_log_message,
1624: p_msg_index_out => l_msg_index_out );

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

1634:
1635: when others then
1636: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1637:
1638: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1639: then
1640: fnd_msg_pub.add_exc_msg
1641: ( g_pkg_name
1642: , c_api_name

Line 1640: fnd_msg_pub.add_exc_msg

1636: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1637:
1638: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1639: then
1640: fnd_msg_pub.add_exc_msg
1641: ( g_pkg_name
1642: , c_api_name
1643: );
1644: END IF;

Line 1647: fnd_msg_pub.count_and_get

1643: );
1644: END IF;
1645:
1646: -- Get message count and data
1647: fnd_msg_pub.count_and_get
1648: ( p_count => x_msg_count
1649: , p_data => x_msg_data
1650: );
1651:

Line 1671: FND_MSG_PUB.Get

1667: mydebug(l_Fnd_Log_Message,c_api_name,9);
1668: End If;
1669: Elsif X_Msg_Count > 1 Then
1670: For I In 1..X_Msg_Count Loop
1671: FND_MSG_PUB.Get
1672: (p_msg_index => i,
1673: p_encoded => 'F',
1674: p_data => l_Fnd_Log_Message,
1675: p_msg_index_out => l_msg_index_out );

Line 1746: FND_MSG_PUB.Add;

1742: END IF;
1743:
1744: IF p_supply_source_type_id IS NULL THEN
1745: FND_MESSAGE.SET_NAME('INV','INV_API_NULL_SOURCE_TYPE_ID');
1746: FND_MSG_PUB.Add;
1747: RAISE fnd_api.g_exc_unexpected_error;
1748: ELSIF p_supply_source_type_id NOT IN
1749: (inv_reservation_global.g_source_type_po,
1750: inv_reservation_global.g_source_type_internal_req,

Line 1753: FND_MSG_PUB.Add;

1749: (inv_reservation_global.g_source_type_po,
1750: inv_reservation_global.g_source_type_internal_req,
1751: inv_reservation_global.g_source_type_req) THEN
1752: FND_MESSAGE.SET_NAME('INV','INV_API_INVALID_SOURCE_TYPE_ID');
1753: FND_MSG_PUB.Add;
1754: RAISE fnd_api.g_exc_unexpected_error;
1755: END IF;
1756:
1757: IF p_project_id is not null THEN

Line 1824: fnd_msg_pub.count_and_get

1820: x_return_status := fnd_api.g_ret_sts_error;
1821: x_record_count := -1;
1822:
1823: -- Get message count and data
1824: fnd_msg_pub.count_and_get
1825: ( p_count => x_msg_count
1826: , p_data => x_msg_data
1827: );
1828:

Line 1847: FND_MSG_PUB.Get

1843: mydebug(l_Fnd_Log_Message,c_api_name,9);
1844: End If;
1845: Elsif x_msg_count > 1 Then
1846: For I In 1..X_Msg_Count Loop
1847: FND_MSG_PUB.Get
1848: (p_msg_index => i,
1849: p_encoded => 'F',
1850: p_data => l_Fnd_Log_Message,
1851: p_msg_index_out => l_msg_index_out );

Line 1868: fnd_msg_pub.count_and_get

1864: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1865: x_record_count := -1;
1866:
1867: -- Get message count and data
1868: fnd_msg_pub.count_and_get
1869: ( p_count => x_msg_count
1870: , p_data => x_msg_data
1871: );
1872: -- Call fnd_log api at the end of the API

Line 1891: FND_MSG_PUB.Get

1887: mydebug(l_Fnd_Log_Message,c_api_name,9);
1888: END IF;
1889: Elsif X_Msg_Count > 1 Then
1890: For I In 1..X_Msg_Count Loop
1891: FND_MSG_PUB.Get
1892: (p_msg_index => i,
1893: p_encoded => 'F',
1894: p_data => l_Fnd_Log_Message,
1895: p_msg_index_out => l_msg_index_out );

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

1906: WHEN OTHERS THEN
1907: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1908: x_record_count := -1;
1909:
1910: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1911: THEN
1912: fnd_msg_pub.add_exc_msg
1913: ( g_pkg_name
1914: , c_api_name

Line 1912: fnd_msg_pub.add_exc_msg

1908: x_record_count := -1;
1909:
1910: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1911: THEN
1912: fnd_msg_pub.add_exc_msg
1913: ( g_pkg_name
1914: , c_api_name
1915: );
1916: END IF;

Line 1919: fnd_msg_pub.count_and_get

1915: );
1916: END IF;
1917:
1918: -- Get message count and data
1919: fnd_msg_pub.count_and_get
1920: ( p_count => x_msg_count
1921: , p_data => x_msg_data
1922: );
1923:

Line 1943: FND_MSG_PUB.Get

1939: mydebug(l_Fnd_Log_Message,c_api_name,9);
1940: End If;
1941: Elsif X_Msg_Count > 1 Then
1942: For I In 1..X_Msg_Count Loop
1943: FND_MSG_PUB.Get
1944: (p_msg_index => i,
1945: p_encoded => 'F',
1946: p_data => l_Fnd_Log_Message,
1947: p_msg_index_out => l_msg_index_out );

Line 2283: fnd_msg_pub.count_and_get

2279: WHEN fnd_api.g_exc_error THEN
2280: x_return_status := fnd_api.g_ret_sts_error;
2281:
2282: -- Get message count and data
2283: fnd_msg_pub.count_and_get
2284: ( p_count => x_msg_count
2285: , p_data => x_msg_data
2286: );
2287:

Line 2306: FND_MSG_PUB.Get

2302: mydebug(l_Fnd_Log_Message,c_api_name,9);
2303: End If;
2304: Elsif x_msg_count > 1 Then
2305: For I In 1..X_Msg_Count Loop
2306: FND_MSG_PUB.Get
2307: (p_msg_index => i,
2308: p_encoded => 'F',
2309: p_data => l_Fnd_Log_Message,
2310: p_msg_index_out => l_msg_index_out );

Line 2326: fnd_msg_pub.count_and_get

2322: WHEN fnd_api.g_exc_unexpected_error THEN
2323: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2324:
2325: -- Get message count and data
2326: fnd_msg_pub.count_and_get
2327: ( p_count => x_msg_count
2328: , p_data => x_msg_data
2329: );
2330: -- Call fnd_log api at the end of the API

Line 2349: FND_MSG_PUB.Get

2345: mydebug(l_Fnd_Log_Message,c_api_name,9);
2346: END IF;
2347: Elsif X_Msg_Count > 1 Then
2348: For I In 1..X_Msg_Count Loop
2349: FND_MSG_PUB.Get
2350: (p_msg_index => i,
2351: p_encoded => 'F',
2352: p_data => l_Fnd_Log_Message,
2353: p_msg_index_out => l_msg_index_out );

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

2363:
2364: WHEN OTHERS THEN
2365: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2366:
2367: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
2368: THEN
2369: fnd_msg_pub.add_exc_msg
2370: ( g_pkg_name
2371: , c_api_name

Line 2369: fnd_msg_pub.add_exc_msg

2365: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2366:
2367: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
2368: THEN
2369: fnd_msg_pub.add_exc_msg
2370: ( g_pkg_name
2371: , c_api_name
2372: );
2373: END IF;

Line 2376: fnd_msg_pub.count_and_get

2372: );
2373: END IF;
2374:
2375: -- Get message count and data
2376: fnd_msg_pub.count_and_get
2377: ( p_count => x_msg_count
2378: , p_data => x_msg_data
2379: );
2380:

Line 2400: FND_MSG_PUB.Get

2396: mydebug(l_Fnd_Log_Message,c_api_name,9);
2397: End If;
2398: Elsif X_Msg_Count > 1 Then
2399: For I In 1..X_Msg_Count Loop
2400: FND_MSG_PUB.Get
2401: (p_msg_index => i,
2402: p_encoded => 'F',
2403: p_data => l_Fnd_Log_Message,
2404: p_msg_index_out => l_msg_index_out );

Line 2606: fnd_msg_pub.count_and_get

2602: WHEN fnd_api.g_exc_error THEN
2603: x_return_status := fnd_api.g_ret_sts_error;
2604:
2605: -- Get message count and data
2606: fnd_msg_pub.count_and_get
2607: ( p_count => x_msg_count
2608: , p_data => x_msg_data
2609: );
2610:

Line 2629: FND_MSG_PUB.Get

2625: mydebug(l_Fnd_Log_Message,c_api_name,9);
2626: End If;
2627: Elsif x_msg_count > 1 Then
2628: For I In 1..X_Msg_Count Loop
2629: FND_MSG_PUB.Get
2630: (p_msg_index => i,
2631: p_encoded => 'F',
2632: p_data => l_Fnd_Log_Message,
2633: p_msg_index_out => l_msg_index_out );

Line 2648: fnd_msg_pub.count_and_get

2644: WHEN fnd_api.g_exc_unexpected_error THEN
2645: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2646:
2647: -- Get message count and data
2648: fnd_msg_pub.count_and_get
2649: ( p_count => x_msg_count
2650: , p_data => x_msg_data
2651: );
2652: -- Call fnd_log api at the end of the API

Line 2671: FND_MSG_PUB.Get

2667: mydebug(l_Fnd_Log_Message,c_api_name,9);
2668: END IF;
2669: Elsif X_Msg_Count > 1 Then
2670: For I In 1..X_Msg_Count Loop
2671: FND_MSG_PUB.Get
2672: (p_msg_index => i,
2673: p_encoded => 'F',
2674: p_data => l_Fnd_Log_Message,
2675: p_msg_index_out => l_msg_index_out );

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

2685:
2686: WHEN OTHERS THEN
2687: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2688:
2689: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
2690: THEN
2691: fnd_msg_pub.add_exc_msg
2692: ( g_pkg_name
2693: , c_api_name

Line 2691: fnd_msg_pub.add_exc_msg

2687: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2688:
2689: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
2690: THEN
2691: fnd_msg_pub.add_exc_msg
2692: ( g_pkg_name
2693: , c_api_name
2694: );
2695: END IF;

Line 2698: fnd_msg_pub.count_and_get

2694: );
2695: END IF;
2696:
2697: -- Get message count and data
2698: fnd_msg_pub.count_and_get
2699: ( p_count => x_msg_count
2700: , p_data => x_msg_data
2701: );
2702:

Line 2722: FND_MSG_PUB.Get

2718: mydebug(l_Fnd_Log_Message,c_api_name,9);
2719: End If;
2720: Elsif X_Msg_Count > 1 Then
2721: For I In 1..X_Msg_Count Loop
2722: FND_MSG_PUB.Get
2723: (p_msg_index => i,
2724: p_encoded => 'F',
2725: p_data => l_Fnd_Log_Message,
2726: p_msg_index_out => l_msg_index_out );

Line 2845: fnd_msg_pub.count_and_get

2841: WHEN fnd_api.g_exc_error THEN
2842: x_return_status := fnd_api.g_ret_sts_error;
2843:
2844: -- Get message count and data
2845: fnd_msg_pub.count_and_get
2846: ( p_count => x_msg_count
2847: , p_data => x_msg_data
2848: );
2849:

Line 2868: FND_MSG_PUB.Get

2864: mydebug(l_Fnd_Log_Message,c_api_name,9);
2865: End If;
2866: Elsif x_msg_count > 1 Then
2867: For I In 1..X_Msg_Count Loop
2868: FND_MSG_PUB.Get
2869: (p_msg_index => i,
2870: p_encoded => 'F',
2871: p_data => l_Fnd_Log_Message,
2872: p_msg_index_out => l_msg_index_out );

Line 2887: fnd_msg_pub.count_and_get

2883: WHEN fnd_api.g_exc_unexpected_error THEN
2884: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2885:
2886: -- Get message count and data
2887: fnd_msg_pub.count_and_get
2888: ( p_count => x_msg_count
2889: , p_data => x_msg_data
2890: );
2891: -- Call fnd_log api at the end of the API

Line 2910: FND_MSG_PUB.Get

2906: mydebug(l_Fnd_Log_Message,c_api_name,9);
2907: END IF;
2908: Elsif X_Msg_Count > 1 Then
2909: For I In 1..X_Msg_Count Loop
2910: FND_MSG_PUB.Get
2911: (p_msg_index => i,
2912: p_encoded => 'F',
2913: p_data => l_Fnd_Log_Message,
2914: p_msg_index_out => l_msg_index_out );

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

2924:
2925: WHEN OTHERS THEN
2926: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2927:
2928: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
2929: THEN
2930: fnd_msg_pub.add_exc_msg
2931: ( g_pkg_name
2932: , c_api_name

Line 2930: fnd_msg_pub.add_exc_msg

2926: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2927:
2928: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
2929: THEN
2930: fnd_msg_pub.add_exc_msg
2931: ( g_pkg_name
2932: , c_api_name
2933: );
2934: END IF;

Line 2937: fnd_msg_pub.count_and_get

2933: );
2934: END IF;
2935:
2936: -- Get message count and data
2937: fnd_msg_pub.count_and_get
2938: ( p_count => x_msg_count
2939: , p_data => x_msg_data
2940: );
2941:

Line 2961: FND_MSG_PUB.Get

2957: mydebug(l_Fnd_Log_Message,c_api_name,9);
2958: End If;
2959: Elsif X_Msg_Count > 1 Then
2960: For I In 1..X_Msg_Count Loop
2961: FND_MSG_PUB.Get
2962: (p_msg_index => i,
2963: p_encoded => 'F',
2964: p_data => l_Fnd_Log_Message,
2965: p_msg_index_out => l_msg_index_out );

Line 3042: FND_MSG_PUB.Add;

3038: WHEN OTHERS THEN
3039: --po_message_s.sql_error('UOM_CONVERSION', '010', sqlcode);
3040: -- inv message....
3041: FND_MESSAGE.SET_NAME('INV','INV_RSV_UOM_CONVERSION');
3042: FND_MSG_PUB.Add;
3043: IF G_debug= C_Debug_Enabled THEN
3044: l_Fnd_Log_message := 'OTHERS exception happens when geting item_id, primary_uom, res_uom';
3045: mydebug(l_Fnd_Log_Message,c_api_name,9);
3046: END IF;

Line 4109: FND_MSG_PUB.Add;

4105: END IF;
4106:
4107: ELSE -- if did not have any req reservation existing
4108: FND_MESSAGE.SET_NAME('INV','INV_API_NO_RSV_EXIST');
4109: FND_MSG_PUB.Add;
4110: l_Fnd_Log_Message := 'calling get_req_line_res, no reservation records';
4111: mydebug(l_Fnd_Log_Message, c_api_name,9);
4112: END IF; -- record_count
4113:

Line 4199: FND_MSG_PUB.Add;

4195: mydebug(l_Fnd_Log_Message, c_api_name,9);
4196: END IF;
4197: ELSE
4198: FND_MESSAGE.SET_NAME('INV','INV_API_NO_RSV_EXIST');
4199: FND_MSG_PUB.Add;
4200: l_Fnd_Log_Message := 'calling get_req_line_res, no reservation records';
4201: mydebug(l_Fnd_Log_Message, c_api_name,9);
4202: END IF;
4203:

Line 4429: FND_MSG_PUB.ADD;

4425: -- END IF;
4426:
4427: IF (p_transaction_id IS NULL) THEN
4428: FND_MESSAGE.SET_NAME('INV','INV_INVALID_TRANSACTION_ID');
4429: FND_MSG_PUB.ADD;
4430: RAISE fnd_api.g_exc_error;
4431: END IF;
4432:
4433: OPEN get_source_doc_code(p_transaction_id);

Line 5556: FND_MSG_PUB.Add;

5552:
5553: ELSE -- if did not have any req reservation existing
5554: IF g_debug= C_Debug_Enabled THEN
5555: FND_MESSAGE.SET_NAME('INV','INV_API_NO_RSV_EXIST');
5556: FND_MSG_PUB.Add;
5557: l_Fnd_Log_Message := 'l_record_count < 0';
5558: mydebug(l_Fnd_Log_Message, c_api_name,9);
5559: END IF;
5560: END IF; -- record_count

Line 6425: fnd_msg_pub.count_and_get

6421: WHEN fnd_api.g_exc_error THEN
6422: x_return_status := fnd_api.g_ret_sts_error;
6423:
6424: -- Get message count and data
6425: fnd_msg_pub.count_and_get
6426: ( p_count => x_msg_count
6427: , p_data => x_msg_data
6428: );
6429:

Line 6448: FND_MSG_PUB.Get

6444: mydebug(l_Fnd_Log_Message,c_api_name,9);
6445: End If;
6446: Elsif x_msg_count > 1 Then
6447: For I In 1..X_Msg_Count Loop
6448: FND_MSG_PUB.Get
6449: (p_msg_index => i,
6450: p_encoded => 'F',
6451: p_data => l_Fnd_Log_Message,
6452: p_msg_index_out => l_msg_index_out );

Line 6467: fnd_msg_pub.count_and_get

6463: WHEN fnd_api.g_exc_unexpected_error THEN
6464: x_return_status := fnd_api.g_ret_sts_unexp_error ;
6465:
6466: -- Get message count and data
6467: fnd_msg_pub.count_and_get
6468: ( p_count => x_msg_count
6469: , p_data => x_msg_data
6470: );
6471: -- Call fnd_log api at the end of the API

Line 6490: FND_MSG_PUB.Get

6486: mydebug(l_Fnd_Log_Message,c_api_name,9);
6487: END IF;
6488: Elsif X_Msg_Count > 1 Then
6489: For I In 1..X_Msg_Count Loop
6490: FND_MSG_PUB.Get
6491: (p_msg_index => i,
6492: p_encoded => 'F',
6493: p_data => l_Fnd_Log_Message,
6494: p_msg_index_out => l_msg_index_out );

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

6504:
6505: WHEN OTHERS THEN
6506: x_return_status := fnd_api.g_ret_sts_unexp_error ;
6507:
6508: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
6509: THEN
6510: fnd_msg_pub.add_exc_msg
6511: ( g_pkg_name
6512: , c_api_name

Line 6510: fnd_msg_pub.add_exc_msg

6506: x_return_status := fnd_api.g_ret_sts_unexp_error ;
6507:
6508: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
6509: THEN
6510: fnd_msg_pub.add_exc_msg
6511: ( g_pkg_name
6512: , c_api_name
6513: );
6514: END IF;

Line 6517: fnd_msg_pub.count_and_get

6513: );
6514: END IF;
6515:
6516: -- Get message count and data
6517: fnd_msg_pub.count_and_get
6518: ( p_count => x_msg_count
6519: , p_data => x_msg_data
6520: );
6521:

Line 6541: FND_MSG_PUB.Get

6537: mydebug(l_Fnd_Log_Message,c_api_name,9);
6538: End If;
6539: Elsif X_Msg_Count > 1 Then
6540: For I In 1..X_Msg_Count Loop
6541: FND_MSG_PUB.Get
6542: (p_msg_index => i,
6543: p_encoded => 'F',
6544: p_data => l_Fnd_Log_Message,
6545: p_msg_index_out => l_msg_index_out );