DBA Data[Home] [Help]

APPS.FND_AMP_PRIVATE dependencies on FND_AMP_PRIVATE

Line 1: package body FND_AMP_PRIVATE as

1: package body FND_AMP_PRIVATE as
2: /* $Header: AFCPAMPB.pls 120.6 2011/05/09 19:35:38 pferguso ship $ */
3:
4: --
5: -- Package

Line 6: -- FND_AMP_PRIVATE

2: /* $Header: AFCPAMPB.pls 120.6 2011/05/09 19:35:38 pferguso ship $ */
3:
4: --
5: -- Package
6: -- FND_AMP_PRIVATE
7: -- Purpose
8: -- Utilities for the Applications Management Pack
9: -- History
10: --

Line 187: fnd_message.set_token('ROUTINE', 'FND_AMP_PRIVATE.WHY_WAIT');

183: return NULL;
184: exception
185: when others then
186: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
187: fnd_message.set_token('ROUTINE', 'FND_AMP_PRIVATE.WHY_WAIT');
188: fnd_message.set_token('ERRNO', SQLCODE);
189: fnd_message.set_token('REASON', SQLERRM);
190: return fnd_message.get;
191: end why_wait;

Line 312: 'fnd.plsql.FND_AMP_PRIVATE.kill_session',

308: dummy number;
309: begin
310: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
311: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
312: 'fnd.plsql.FND_AMP_PRIVATE.kill_session',
313: 'audsid: ' ||audsid||', inst_id=' ||inst_id);
314: end if;
315:
316: begin

Line 326: 'fnd.plsql.FND_AMP_PRIVATE.kill_session',

322: exception
323: when no_data_found then
324: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
325: fnd_log.string(FND_LOG.LEVEL_ERROR,
326: 'fnd.plsql.FND_AMP_PRIVATE.kill_session',
327: 'Session (audsid) ' ||audsid||' in instance '||inst_id||' not found');
328: end if;
329: return 1;
330: when others then

Line 355: fnd_message.set_token('ROUTINE', 'FND_AMP_PRIVATE.KILL_SESSION');

351:
352: exception
353: when others then
354: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
355: fnd_message.set_token('ROUTINE', 'FND_AMP_PRIVATE.KILL_SESSION');
356: fnd_message.set_token('ERRNO', SQLCODE);
357: fnd_message.set_token('REASON', SQLERRM);
358: message := fnd_message.get;
359: return 0;

Line 463: fnd_message.set_token('ROUTINE', 'FND_AMP_PRIVATE.TERMINATE_REQUEST');

459:
460: exception
461: when others then
462: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
463: fnd_message.set_token('ROUTINE', 'FND_AMP_PRIVATE.TERMINATE_REQUEST');
464: fnd_message.set_token('ERRNO', SQLCODE);
465: fnd_message.set_token('REASON', SQLERRM);
466: message := fnd_message.get;
467: rollback;

Line 498: savepoint fnd_amp_private_hold_req;

494: req_type varchar2(1);
495: new_hold varchar2(1);
496: retval number;
497: begin
498: savepoint fnd_amp_private_hold_req;
499:
500: begin
501: select phase_code, hold_flag, request_type
502: into req_phase, req_hold, req_type

Line 519: rollback to fnd_amp_private_hold_req;

515: if (req_phase <> 'P' ) then
516: -- to fix bug # 4761862
517: -- Request Sets in Running phase can be hold.
518: if ( req_type <> 'M' or req_phase <> 'R') then
519: rollback to fnd_amp_private_hold_req;
520: return 2;
521: end if;
522: end if;
523:

Line 546: fnd_message.set_token('ROUTINE', 'FND_AMP_PRIVATE.TOGGLE_REQUEST_HOLD');

542:
543: exception
544: when others then
545: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
546: fnd_message.set_token('ROUTINE', 'FND_AMP_PRIVATE.TOGGLE_REQUEST_HOLD');
547: fnd_message.set_token('ERRNO', SQLCODE);
548: fnd_message.set_token('REASON', SQLERRM);
549: message := fnd_message.get;
550: rollback to fnd_amp_private_hold_req;

Line 550: rollback to fnd_amp_private_hold_req;

546: fnd_message.set_token('ROUTINE', 'FND_AMP_PRIVATE.TOGGLE_REQUEST_HOLD');
547: fnd_message.set_token('ERRNO', SQLCODE);
548: fnd_message.set_token('REASON', SQLERRM);
549: message := fnd_message.get;
550: rollback to fnd_amp_private_hold_req;
551: return 0;
552: end;
553:
554:

Line 579: savepoint fnd_amp_private_alter_priority;

575: message in out NOCOPY varchar2) return number is
576: req_phase varchar2(1);
577:
578: begin
579: savepoint fnd_amp_private_alter_priority;
580:
581: begin
582: select phase_code
583: into req_phase

Line 597: rollback to fnd_amp_private_alter_priority;

593: end if;
594: end;
595:
596: if (req_phase <> 'P') then
597: rollback to fnd_amp_private_alter_priority;
598: return 2;
599: end if;
600:
601:

Line 615: fnd_message.set_token('ROUTINE', 'FND_AMP_PRIVATE.ALTER_REQUEST_PRIORITY');

611:
612: exception
613: when others then
614: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
615: fnd_message.set_token('ROUTINE', 'FND_AMP_PRIVATE.ALTER_REQUEST_PRIORITY');
616: fnd_message.set_token('ERRNO', SQLCODE);
617: fnd_message.set_token('REASON', SQLERRM);
618: message := fnd_message.get;
619: rollback to fnd_amp_private_alter_priority;

Line 619: rollback to fnd_amp_private_alter_priority;

615: fnd_message.set_token('ROUTINE', 'FND_AMP_PRIVATE.ALTER_REQUEST_PRIORITY');
616: fnd_message.set_token('ERRNO', SQLCODE);
617: fnd_message.set_token('REASON', SQLERRM);
618: message := fnd_message.get;
619: rollback to fnd_amp_private_alter_priority;
620: return 0;
621: end;
622:
623: end FND_AMP_PRIVATE;

Line 623: end FND_AMP_PRIVATE;

619: rollback to fnd_amp_private_alter_priority;
620: return 0;
621: end;
622:
623: end FND_AMP_PRIVATE;