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.3.12000000.3 2007/10/08 19:51:16 ckclark ship $ */
3:
4: --
5: -- Package

Line 6: -- FND_AMP_PRIVATE

2: /* $Header: AFCPAMPB.pls 120.3.12000000.3 2007/10/08 19:51:16 ckclark 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 359: 'fnd.plsql.FND_AMP_PRIVATE.kill_session',

355: dummy number;
356: begin
357: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
358: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
359: 'fnd.plsql.FND_AMP_PRIVATE.kill_session',
360: 'audsid: ' ||audsid||', inst_id=' ||inst_id);
361: end if;
362:
363: begin

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

369: exception
370: when no_data_found then
371: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
372: fnd_log.string(FND_LOG.LEVEL_ERROR,
373: 'fnd.plsql.FND_AMP_PRIVATE.kill_session',
374: 'Session (audsid) ' ||audsid||' in instance '||inst_id||' not found');
375: end if;
376: return 1;
377: when others then

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

398:
399: exception
400: when others then
401: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
402: fnd_message.set_token('ROUTINE', 'FND_AMP_PRIVATE.KILL_SESSION');
403: fnd_message.set_token('ERRNO', SQLCODE);
404: fnd_message.set_token('REASON', SQLERRM);
405: message := fnd_message.get;
406: return 0;

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

506:
507: exception
508: when others then
509: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
510: fnd_message.set_token('ROUTINE', 'FND_AMP_PRIVATE.TERMINATE_REQUEST');
511: fnd_message.set_token('ERRNO', SQLCODE);
512: fnd_message.set_token('REASON', SQLERRM);
513: message := fnd_message.get;
514: rollback;

Line 545: savepoint fnd_amp_private_hold_req;

541: req_type varchar2(1);
542: new_hold varchar2(1);
543: retval number;
544: begin
545: savepoint fnd_amp_private_hold_req;
546:
547: begin
548: select phase_code, hold_flag, request_type
549: into req_phase, req_hold, req_type

Line 566: rollback to fnd_amp_private_hold_req;

562: if (req_phase <> 'P' ) then
563: -- to fix bug # 4761862
564: -- Request Sets in Running phase can be hold.
565: if ( req_type <> 'M' or req_phase <> 'R') then
566: rollback to fnd_amp_private_hold_req;
567: return 2;
568: end if;
569: end if;
570:

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

589:
590: exception
591: when others then
592: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
593: fnd_message.set_token('ROUTINE', 'FND_AMP_PRIVATE.TOGGLE_REQUEST_HOLD');
594: fnd_message.set_token('ERRNO', SQLCODE);
595: fnd_message.set_token('REASON', SQLERRM);
596: message := fnd_message.get;
597: rollback to fnd_amp_private_hold_req;

Line 597: rollback to fnd_amp_private_hold_req;

593: fnd_message.set_token('ROUTINE', 'FND_AMP_PRIVATE.TOGGLE_REQUEST_HOLD');
594: fnd_message.set_token('ERRNO', SQLCODE);
595: fnd_message.set_token('REASON', SQLERRM);
596: message := fnd_message.get;
597: rollback to fnd_amp_private_hold_req;
598: return 0;
599: end;
600:
601:

Line 626: savepoint fnd_amp_private_alter_priority;

622: message in out NOCOPY varchar2) return number is
623: req_phase varchar2(1);
624:
625: begin
626: savepoint fnd_amp_private_alter_priority;
627:
628: begin
629: select phase_code
630: into req_phase

Line 644: rollback to fnd_amp_private_alter_priority;

640: end if;
641: end;
642:
643: if (req_phase <> 'P') then
644: rollback to fnd_amp_private_alter_priority;
645: return 2;
646: end if;
647:
648:

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

658:
659: exception
660: when others then
661: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
662: fnd_message.set_token('ROUTINE', 'FND_AMP_PRIVATE.ALTER_REQUEST_PRIORITY');
663: fnd_message.set_token('ERRNO', SQLCODE);
664: fnd_message.set_token('REASON', SQLERRM);
665: message := fnd_message.get;
666: rollback to fnd_amp_private_alter_priority;

Line 666: rollback to fnd_amp_private_alter_priority;

662: fnd_message.set_token('ROUTINE', 'FND_AMP_PRIVATE.ALTER_REQUEST_PRIORITY');
663: fnd_message.set_token('ERRNO', SQLCODE);
664: fnd_message.set_token('REASON', SQLERRM);
665: message := fnd_message.get;
666: rollback to fnd_amp_private_alter_priority;
667: return 0;
668: end;
669:
670: end FND_AMP_PRIVATE;

Line 670: end FND_AMP_PRIVATE;

666: rollback to fnd_amp_private_alter_priority;
667: return 0;
668: end;
669:
670: end FND_AMP_PRIVATE;