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.ZPB_DC_OBJECTS_PVT dependencies on FND_MSG_PUB

Line 54: FND_MSG_PUB.initialize ;

50: END IF;
51:
52:
53: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
54: FND_MSG_PUB.initialize ;
55: END IF;
56:
57: x_return_status := FND_API.G_RET_STS_SUCCESS ;
58:

Line 111: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

107: x_return_status => x_return_status,
108: x_msg_count => x_msg_count,
109: x_msg_data => x_msg_data);
110:
111: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
112: p_data => x_msg_data );
113: EXCEPTION
114:
115: WHEN FND_API.G_EXC_ERROR THEN

Line 119: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

115: WHEN FND_API.G_EXC_ERROR THEN
116:
117: ROLLBACK TO Get_User_Id_Clob_Pvt ;
118: x_return_status := FND_API.G_RET_STS_ERROR;
119: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
120: p_data => x_msg_data );
121:
122: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
123:

Line 126: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

122: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
123:
124: ROLLBACK TO Get_User_Id_Clob_Pvt ;
125: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
126: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
127: p_data => x_msg_data );
128:
129: WHEN OTHERS THEN
130:

Line 134: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

130:
131: ROLLBACK TO Get_User_Id_Clob_Pvt ;
132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
133:
134: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
135: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
136: l_api_name);
137: END if;
138:

Line 135: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

131: ROLLBACK TO Get_User_Id_Clob_Pvt ;
132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
133:
134: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
135: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
136: l_api_name);
137: END if;
138:
139: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 139: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

135: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
136: l_api_name);
137: END if;
138:
139: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
140: p_data => x_msg_data );
141:
142: END Get_User_Id_Clob;
143:

Line 227: FND_MSG_PUB.initialize ;

223: END IF;
224:
225:
226: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
227: FND_MSG_PUB.initialize ;
228: END IF;
229:
230: x_return_status := FND_API.G_RET_STS_SUCCESS ;
231:

Line 254: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

250: fnd_global.LOGIN_ID,
251: fnd_global.user_id,
252: SYSDATE);
253:
254: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
255: p_data => x_msg_data );
256: EXCEPTION
257:
258: WHEN FND_API.G_EXC_ERROR THEN

Line 262: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

258: WHEN FND_API.G_EXC_ERROR THEN
259:
260: ROLLBACK TO Populate_Approvers ;
261: x_return_status := FND_API.G_RET_STS_ERROR;
262: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
263: p_data => x_msg_data );
264:
265: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
266:

Line 269: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

265: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
266:
267: ROLLBACK TO Populate_Approvers ;
268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
269: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
270: p_data => x_msg_data );
271:
272: WHEN OTHERS THEN
273:

Line 277: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

273:
274: ROLLBACK TO Populate_Approvers ;
275: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
276:
277: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
278: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
279: l_api_name);
280: END if;
281:

Line 278: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

274: ROLLBACK TO Populate_Approvers ;
275: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
276:
277: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
278: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
279: l_api_name);
280: END if;
281:
282: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 282: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

278: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
279: l_api_name);
280: END if;
281:
282: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
283: p_data => x_msg_data );
284:
285: END Populate_Approvers;
286:

Line 774: FND_MSG_PUB.initialize ;

770: END IF;
771:
772:
773: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
774: FND_MSG_PUB.initialize ;
775: END IF;
776:
777: x_return_status := FND_API.G_RET_STS_SUCCESS ;
778:

Line 1293: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

1289: l_viewType,
1290: l_bus_area_id,
1291: l_multiple_submissions_flag);
1292:
1293: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1294: p_data => x_msg_data );
1295: --COMMIT WORK;
1296:
1297: EXCEPTION

Line 1303: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

1299: WHEN FND_API.G_EXC_ERROR THEN
1300:
1301: ROLLBACK TO Generate_Template_Pvt ;
1302: x_return_status := FND_API.G_RET_STS_ERROR;
1303: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1304: p_data => x_msg_data );
1305:
1306: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1307:

Line 1310: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

1306: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1307:
1308: ROLLBACK TO Generate_Template_Pvt ;
1309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1310: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1311: p_data => x_msg_data );
1312: WHEN OTHERS THEN
1313:
1314: ROLLBACK TO Generate_Template_Pvt ;

Line 1317: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1313:
1314: ROLLBACK TO Generate_Template_Pvt ;
1315: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1316:
1317: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1318: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
1319: l_api_name);
1320: END if;
1321:

Line 1318: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

1314: ROLLBACK TO Generate_Template_Pvt ;
1315: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1316:
1317: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1318: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
1319: l_api_name);
1320: END if;
1321:
1322: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 1322: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

1318: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
1319: l_api_name);
1320: END if;
1321:
1322: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1323: p_data => x_msg_data );
1324:
1325:
1326: END Generate_Template;

Line 1514: FND_MSG_PUB.initialize ;

1510: END IF;
1511:
1512:
1513: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
1514: FND_MSG_PUB.initialize ;
1515: END IF;
1516:
1517: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1518:

Line 1769: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

1765:
1766: END LOOP; -- loop through task parameter table
1767: END IF; -- Specified user or not
1768:
1769: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1770: p_data => x_msg_data );
1771:
1772: EXCEPTION
1773:

Line 1778: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

1774: WHEN FND_API.G_EXC_ERROR THEN
1775:
1776: ROLLBACK TO Auto_Distribute_Pvt ;
1777: x_return_status := FND_API.G_RET_STS_ERROR;
1778: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1779: p_data => x_msg_data );
1780:
1781: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1782:

Line 1785: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

1781: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1782:
1783: ROLLBACK TO Auto_Distribute_Pvt ;
1784: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1785: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1786: p_data => x_msg_data );
1787:
1788: WHEN OTHERS THEN
1789:

Line 1793: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1789:
1790: ROLLBACK TO Auto_Distribute_Pvt ;
1791: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1792:
1793: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1794: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
1795: l_api_name);
1796: END if;
1797:

Line 1794: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

1790: ROLLBACK TO Auto_Distribute_Pvt ;
1791: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1792:
1793: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1794: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
1795: l_api_name);
1796: END if;
1797:
1798: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 1798: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

1794: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
1795: l_api_name);
1796: END if;
1797:
1798: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1799: p_data => x_msg_data );
1800:
1801:
1802: END Auto_Distribute;

Line 2005: FND_MSG_PUB.initialize ;

2001: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2002: END IF;
2003:
2004: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
2005: FND_MSG_PUB.initialize ;
2006: END IF;
2007:
2008: x_return_status := FND_API.G_RET_STS_SUCCESS ;
2009:

Line 2243: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

2239: END LOOP;
2240:
2241: END LOOP; -- loop through specific users
2242: END IF; -- recipient is specified or not
2243: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2244: p_data => x_msg_data );
2245: EXCEPTION
2246:
2247: WHEN FND_API.G_EXC_ERROR THEN

Line 2251: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

2247: WHEN FND_API.G_EXC_ERROR THEN
2248:
2249: ROLLBACK TO Manual_Distribute_Pvt ;
2250: x_return_status := FND_API.G_RET_STS_ERROR;
2251: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2252: p_data => x_msg_data );
2253:
2254: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2255:

Line 2258: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

2254: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2255:
2256: ROLLBACK TO Manual_Distribute_Pvt ;
2257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2258: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2259: p_data => x_msg_data );
2260:
2261: WHEN OTHERS THEN
2262:

Line 2266: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2262:
2263: ROLLBACK TO Manual_Distribute_Pvt ;
2264: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2265:
2266: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2267: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
2268: l_api_name);
2269: END if;
2270:

Line 2267: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

2263: ROLLBACK TO Manual_Distribute_Pvt ;
2264: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2265:
2266: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2267: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
2268: l_api_name);
2269: END if;
2270:
2271: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 2271: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

2267: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
2268: l_api_name);
2269: END if;
2270:
2271: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2272: p_data => x_msg_data );
2273:
2274:
2275: END Manual_Distribute;

Line 2333: FND_MSG_PUB.initialize ;

2329: END IF;
2330:
2331:
2332: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
2333: FND_MSG_PUB.initialize ;
2334: END IF;
2335:
2336: x_return_status := FND_API.G_RET_STS_SUCCESS ;
2337:

Line 2356: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

2352: l_rolename := zpb_wf_ntf.update_Role_with_Shadows(l_rolename, template_user_rec.user_name);
2353: FND_FILE.Put_Line ( FND_FILE.LOG, 'set_template_recipient - after call to update_Role_with_Shadows') ;
2354: END LOOP;
2355: x_role_name := l_rolename;
2356: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2357: p_data => x_msg_data );
2358: EXCEPTION
2359:
2360: WHEN FND_API.G_EXC_ERROR THEN

Line 2364: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

2360: WHEN FND_API.G_EXC_ERROR THEN
2361:
2362: ROLLBACK TO Set_Template_Recipient ;
2363: x_return_status := FND_API.G_RET_STS_ERROR;
2364: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2365: p_data => x_msg_data );
2366:
2367: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2368:

Line 2371: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

2367: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2368:
2369: ROLLBACK TO Set_Template_Recipient ;
2370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2371: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2372: p_data => x_msg_data );
2373:
2374: WHEN OTHERS THEN
2375:

Line 2379: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2375:
2376: ROLLBACK TO Set_Template_Recipient ;
2377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2378:
2379: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2380: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
2381: l_api_name);
2382: END if;
2383:

Line 2380: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

2376: ROLLBACK TO Set_Template_Recipient ;
2377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2378:
2379: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2380: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
2381: l_api_name);
2382: END if;
2383:
2384: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 2384: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

2380: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
2381: l_api_name);
2382: END if;
2383:
2384: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2385: p_data => x_msg_data );
2386:
2387:
2388: END Set_Template_Recipient;

Line 2755: FND_MSG_PUB.initialize ;

2751: END IF;
2752:
2753:
2754: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
2755: FND_MSG_PUB.initialize ;
2756: END IF;
2757:
2758: x_return_status := FND_API.G_RET_STS_SUCCESS ;
2759:

Line 2811: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

2807: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
2808: WHERE TEMPLATE_ID = p_template_id
2809: AND OBJECT_TYPE in ('E','M');
2810:
2811: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2812: p_data => x_msg_data );
2813: COMMIT WORK;
2814: EXCEPTION
2815:

Line 2820: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

2816: WHEN FND_API.G_EXC_ERROR THEN
2817:
2818: ROLLBACK TO Complete_Review_Pvt ;
2819: x_return_status := FND_API.G_RET_STS_ERROR;
2820: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2821: p_data => x_msg_data );
2822:
2823: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2824:

Line 2827: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

2823: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2824:
2825: ROLLBACK TO Complete_Review_Pvt ;
2826: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2827: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2828: p_data => x_msg_data );
2829:
2830: WHEN OTHERS THEN
2831:

Line 2835: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2831:
2832: ROLLBACK TO Complete_Review_Pvt ;
2833: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2834:
2835: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2836: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
2837: l_api_name);
2838: END if;
2839:

Line 2836: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

2832: ROLLBACK TO Complete_Review_Pvt ;
2833: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2834:
2835: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2836: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
2837: l_api_name);
2838: END if;
2839:
2840: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 2840: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

2836: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
2837: l_api_name);
2838: END if;
2839:
2840: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2841: p_data => x_msg_data );
2842:
2843:
2844: END Complete_Review;

Line 2888: FND_MSG_PUB.initialize ;

2884: END IF;
2885:
2886:
2887: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
2888: FND_MSG_PUB.initialize ;
2889: END IF;
2890:
2891: x_return_status := FND_API.G_RET_STS_SUCCESS ;
2892:

Line 2905: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

2901: IF FND_API.To_Boolean ( p_commit ) THEN
2902: COMMIT WORK;
2903: END iF;
2904:
2905: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2906: p_data => x_msg_data );
2907: EXCEPTION
2908:
2909: WHEN FND_API.G_EXC_ERROR THEN

Line 2913: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

2909: WHEN FND_API.G_EXC_ERROR THEN
2910:
2911: ROLLBACK TO Delete_Template_Pvt ;
2912: x_return_status := FND_API.G_RET_STS_ERROR;
2913: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2914: p_data => x_msg_data );
2915:
2916: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2917:

Line 2920: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

2916: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2917:
2918: ROLLBACK TO Delete_Template_Pvt ;
2919: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2920: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2921: p_data => x_msg_data );
2922:
2923: WHEN OTHERS THEN
2924:

Line 2928: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2924:
2925: ROLLBACK TO Delete_Template_Pvt ;
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) THEN
2929: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
2930: l_api_name);
2931: END if;
2932:

Line 2929: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

2925: ROLLBACK TO Delete_Template_Pvt ;
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) THEN
2929: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
2930: l_api_name);
2931: END if;
2932:
2933: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 2933: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

2929: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
2930: l_api_name);
2931: END if;
2932:
2933: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2934: p_data => x_msg_data );
2935:
2936: END Delete_Template;
2937:

Line 2997: FND_MSG_PUB.initialize ;

2993: END IF;
2994:
2995:
2996: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
2997: FND_MSG_PUB.initialize ;
2998: END IF;
2999:
3000: x_return_status := FND_API.G_RET_STS_SUCCESS ;
3001:

Line 3084: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

3080: ZPB_UTIL_PVT.AddUsersToAdHocRole(l_rolename, fnd_rec.user_name);
3081: END LOOP;
3082: x_role_name := l_rolename;
3083:
3084: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
3085: p_data => x_msg_data );
3086: EXCEPTION
3087:
3088: WHEN FND_API.G_EXC_ERROR THEN

Line 3092: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

3088: WHEN FND_API.G_EXC_ERROR THEN
3089:
3090: ROLLBACK TO Set_Submit_Ntf_Recipients ;
3091: x_return_status := FND_API.G_RET_STS_ERROR;
3092: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
3093: p_data => x_msg_data );
3094:
3095: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3096:

Line 3099: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

3095: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3096:
3097: ROLLBACK TO Set_Submit_Ntf_Recipients;
3098: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3099: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
3100: p_data => x_msg_data );
3101:
3102: WHEN OTHERS THEN
3103:

Line 3107: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3103:
3104: ROLLBACK TO Set_Submit_Ntf_Recipients ;
3105: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3106:
3107: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3108: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
3109: l_api_name);
3110: END if;
3111:

Line 3108: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

3104: ROLLBACK TO Set_Submit_Ntf_Recipients ;
3105: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3106:
3107: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3108: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
3109: l_api_name);
3110: END if;
3111:
3112: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 3112: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

3108: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
3109: l_api_name);
3110: END if;
3111:
3112: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
3113: p_data => x_msg_data );
3114:
3115: END Set_Submit_Ntf_Recipients;
3116:

Line 3157: FND_MSG_PUB.initialize ;

3153: END IF;
3154:
3155:
3156: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
3157: FND_MSG_PUB.initialize ;
3158: END IF;
3159:
3160: x_return_status := FND_API.G_RET_STS_SUCCESS ;
3161:

Line 3173: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

3169: LAST_UPDATE_DATE = SYSDATE,
3170: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
3171: WHERE ac_instance_id = p_ac_instance_id;
3172:
3173: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
3174: p_data => x_msg_data );
3175: EXCEPTION
3176:
3177: WHEN FND_API.G_EXC_ERROR THEN

Line 3181: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

3177: WHEN FND_API.G_EXC_ERROR THEN
3178:
3179: ROLLBACK TO Set_Source_Type ;
3180: x_return_status := FND_API.G_RET_STS_ERROR;
3181: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
3182: p_data => x_msg_data );
3183:
3184: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3185:

Line 3188: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

3184: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3185:
3186: ROLLBACK TO Set_Source_Type ;
3187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3188: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
3189: p_data => x_msg_data );
3190:
3191: WHEN OTHERS THEN
3192:

Line 3196: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3192:
3193: ROLLBACK TO Set_Source_Type ;
3194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3195:
3196: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3197: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
3198: l_api_name);
3199: END if;
3200:

Line 3197: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

3193: ROLLBACK TO Set_Source_Type ;
3194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3195:
3196: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3197: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
3198: l_api_name);
3199: END if;
3200:
3201: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 3201: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

3197: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
3198: l_api_name);
3199: END if;
3200:
3201: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
3202: p_data => x_msg_data );
3203:
3204: END Set_Source_Type;
3205: