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.FPA_PORTFOLIO_PVT dependencies on FPA_PORTFOLIO_PVT

Line 1: PACKAGE BODY FPA_PORTFOLIO_PVT as

1: PACKAGE BODY FPA_PORTFOLIO_PVT as
2: /* $Header: FPAVPTFB.pls 120.1 2005/08/18 11:46:58 appldev noship $ */
3:
4: PROCEDURE Create_Portfolio
5: (

Line 7: p_portfolio_rec IN FPA_Portfolio_PVT.portfolio_rec_type,

3:
4: PROCEDURE Create_Portfolio
5: (
6: p_api_version IN NUMBER,
7: p_portfolio_rec IN FPA_Portfolio_PVT.portfolio_rec_type,
8: x_portfolio_id OUT NOCOPY VARCHAR2,
9: x_return_status OUT NOCOPY VARCHAR2,
10: x_msg_data OUT NOCOPY VARCHAR2,
11: x_msg_count OUT NOCOPY NUMBER

Line 38: 'fpa.sql.fpa_portfolio_pvt.create_portfolio.begin',

34: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
35: fnd_log.string
36: (
37: FND_LOG.LEVEL_PROCEDURE,
38: 'fpa.sql.fpa_portfolio_pvt.create_portfolio.begin',
39: 'Entering fpa_portfolo_pvt.create_portfolio'
40: );
41: END IF;
42:

Line 123: 'Exiting fpa_portfolio_pvt.create_portfolio'

119: fnd_log.string
120: (
121: FND_LOG.LEVEL_PROCEDURE,
122: 'fpa_portfolo_pvt.create_portfolio.end',
123: 'Exiting fpa_portfolio_pvt.create_portfolio'
124: );
125: END IF;
126:
127:

Line 148: 'fpa_portfolio_pvt.create_portfolio',

144: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
145: fnd_log.string
146: (
147: FND_LOG.LEVEL_ERROR,
148: 'fpa_portfolio_pvt.create_portfolio',
149: SQLERRM
150: );
151: END IF;
152: FND_MSG_PUB.count_and_get

Line 181: 'fpa_portfolio_pvt.Delete_Portfolio.begin',

177: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
178: fnd_log.string
179: (
180: FND_LOG.LEVEL_PROCEDURE,
181: 'fpa_portfolio_pvt.Delete_Portfolio.begin',
182: 'Entering fpa_portfolio_pvt.Delete_Portfolio'
183: );
184: END IF;
185:

Line 182: 'Entering fpa_portfolio_pvt.Delete_Portfolio'

178: fnd_log.string
179: (
180: FND_LOG.LEVEL_PROCEDURE,
181: 'fpa_portfolio_pvt.Delete_Portfolio.begin',
182: 'Entering fpa_portfolio_pvt.Delete_Portfolio'
183: );
184: END IF;
185:
186: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 190: ' fpa_portfolio_pvt.Delete_Portfolio',

186: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
187: fnd_log.string
188: (
189: FND_LOG.LEVEL_PROCEDURE,
190: ' fpa_portfolio_pvt.Delete_Portfolio',
191: ' Before remove portfolio maintain portfolio_d '
192: );
193: END IF;
194:

Line 201: ' fpa_portfolio_pvt.Delete_Portfolio',

197: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
198: fnd_log.string
199: (
200: FND_LOG.LEVEL_PROCEDURE,
201: ' fpa_portfolio_pvt.Delete_Portfolio',
202: ' After remove portfolio maintain portfolio_d '
203: );
204: END IF;
205:

Line 222: 'fpa_portfolio_pvt.Delete_Portfolio.end',

218: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
219: fnd_log.string
220: (
221: FND_LOG.LEVEL_PROCEDURE,
222: 'fpa_portfolio_pvt.Delete_Portfolio.end',
223: 'Exiting fpa_portfolio_pvt.Delete_Portfolio'
224: );
225: END IF;
226:

Line 223: 'Exiting fpa_portfolio_pvt.Delete_Portfolio'

219: fnd_log.string
220: (
221: FND_LOG.LEVEL_PROCEDURE,
222: 'fpa_portfolio_pvt.Delete_Portfolio.end',
223: 'Exiting fpa_portfolio_pvt.Delete_Portfolio'
224: );
225: END IF;
226:
227:

Line 237: 'fpa_portfolio_pvt.Delete_Portfolio.end',

233: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
234: fnd_log.string
235: (
236: FND_LOG.LEVEL_ERROR,
237: 'fpa_portfolio_pvt.Delete_Portfolio.end',
238: SQLERRM
239: );
240: END IF;
241: FND_MSG_PUB.count_and_get

Line 260: p_portfolio_rec IN FPA_Portfolio_PVT.portfolio_rec_type,

256:
257: PROCEDURE Upadate_Portfolio_Descr
258: (
259: p_api_version IN NUMBER,
260: p_portfolio_rec IN FPA_Portfolio_PVT.portfolio_rec_type,
261: x_return_status OUT NOCOPY VARCHAR2,
262: x_msg_data OUT NOCOPY VARCHAR2,
263: x_msg_count OUT NOCOPY NUMBER
264: )

Line 272: 'fpa.sql.fpa_portfolio_pvt.update_portfolio_Descr.begin',

268: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
269: fnd_log.string
270: (
271: FND_LOG.LEVEL_PROCEDURE,
272: 'fpa.sql.fpa_portfolio_pvt.update_portfolio_Descr.begin',
273: 'Entering fpa_portfolo_pvt.update_portfolio_descr'
274: );
275: END IF;
276: UPDATE FPA_OBJECTS_TL objtl

Line 288: 'fpa.sql.fpa_portfolio_pvt.update_portfolio_desc.end',

284: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
285: fnd_log.string
286: (
287: FND_LOG.LEVEL_PROCEDURE,
288: 'fpa.sql.fpa_portfolio_pvt.update_portfolio_desc.end',
289: 'Exiting fpa_portfolo_pvt.update_portfolio_descr'
290: );
291: END IF;
292:

Line 302: 'fpa_portfolio_pvt.update_portfolio',

298: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
299: fnd_log.string
300: (
301: FND_LOG.LEVEL_ERROR,
302: 'fpa_portfolio_pvt.update_portfolio',
303: SQLERRM
304: );
305: END IF;
306: FND_MSG_PUB.count_and_get

Line 335: 'fpa.sql.fpa_portfolio_pvt.update_portfolio_type.begin',

331: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
332: fnd_log.string
333: (
334: FND_LOG.LEVEL_PROCEDURE,
335: 'fpa.sql.fpa_portfolio_pvt.update_portfolio_type.begin',
336: 'Entering fpa_portfolo_pvt.update_portfolio_type'
337: );
338: END IF;
339: -- Update name and description

Line 347: 'fpa.sql.fpa_portfolio_pvt.update_portfolio_type.end',

343: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
344: fnd_log.string
345: (
346: FND_LOG.LEVEL_PROCEDURE,
347: 'fpa.sql.fpa_portfolio_pvt.update_portfolio_type.end',
348: 'Exiting fpa_portfolo_pvt.update_portfolio_type'
349: );
350: END IF;
351:

Line 361: 'fpa_portfolio_pvt.update_portfolio_type',

357: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
358: fnd_log.string
359: (
360: FND_LOG.LEVEL_ERROR,
361: 'fpa_portfolio_pvt.update_portfolio_type',
362: SQLERRM
363: );
364: END IF;
365: FND_MSG_PUB.count_and_get

Line 395: 'fpa.sql.fpa_portfolio_pvt.update_portfolio_organization.begin',

391: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
392: fnd_log.string
393: (
394: FND_LOG.LEVEL_PROCEDURE,
395: 'fpa.sql.fpa_portfolio_pvt.update_portfolio_organization.begin',
396: 'Entering fpa_portfolo_pvt.update_portfolio_organization'
397: );
398: END IF;
399: dbms_aw.execute('LMT portfolio_d TO '||p_portfolio_id);

Line 410: 'fpa.sql.fpa_portfolio_pvt.update_portfolio_organization.end',

406: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
407: fnd_log.string
408: (
409: FND_LOG.LEVEL_PROCEDURE,
410: 'fpa.sql.fpa_portfolio_pvt.update_portfolio_organization.end',
411: 'Exiting fpa_portfolo_pvt.update_portfolio_organization'
412: );
413: END IF;
414:

Line 424: 'fpa_portfolio_pvt.update_portfolio_organization',

420: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
421: fnd_log.string
422: (
423: FND_LOG.LEVEL_ERROR,
424: 'fpa_portfolio_pvt.update_portfolio_organization',
425: SQLERRM
426: );
427: END IF;
428: FND_MSG_PUB.count_and_get

Line 460: 'fpa.sql.fpa_portfolio_pvt.Check_portfolio_name.begin',

456: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
457: fnd_log.string
458: (
459: FND_LOG.LEVEL_PROCEDURE,
460: 'fpa.sql.fpa_portfolio_pvt.Check_portfolio_name.begin',
461: 'Entering fpa_portfolo_pvt.Check_portfolio_name'
462: );
463: END IF;
464: --dbms_output.PUT_LINE('portfolio name is '||p_portfolio_name);

Line 490: 'fpa.sql.fpa_portfolio_pvt.Check_portfolio_name.end',

486: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
487: fnd_log.string
488: (
489: FND_LOG.LEVEL_PROCEDURE,
490: 'fpa.sql.fpa_portfolio_pvt.Check_portfolio_name.end',
491: 'Exting fpa_portfolo_pvt.Check_portfolio_name'
492: );
493: END IF;
494:

Line 505: 'fpa_portfolio_pvt.Check_portfolio_name',

501: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
502: fnd_log.string
503: (
504: FND_LOG.LEVEL_ERROR,
505: 'fpa_portfolio_pvt.Check_portfolio_name',
506: SQLERRM
507: );
508: END IF;
509: FND_MSG_PUB.count_and_get