DBA Data[Home] [Help]

APPS.FND_DCP dependencies on FND_MESSAGE

Line 173: fnd_message.set_name ('FND', 'CP-Generic oracle error');

169: +-------------------------------------------------------*/
170:
171: exception
172: when others then
173: fnd_message.set_name ('FND', 'CP-Generic oracle error');
174: fnd_message.set_token ('ERROR', substr (sqlerrm, 1, 30), FALSE);
175: fnd_message.set_token ('ROUTINE', 'REQUEST_LOCK (hndl)', FALSE);
176: end request_lock;
177:

Line 174: fnd_message.set_token ('ERROR', substr (sqlerrm, 1, 30), FALSE);

170:
171: exception
172: when others then
173: fnd_message.set_name ('FND', 'CP-Generic oracle error');
174: fnd_message.set_token ('ERROR', substr (sqlerrm, 1, 30), FALSE);
175: fnd_message.set_token ('ROUTINE', 'REQUEST_LOCK (hndl)', FALSE);
176: end request_lock;
177:
178: --

Line 175: fnd_message.set_token ('ROUTINE', 'REQUEST_LOCK (hndl)', FALSE);

171: exception
172: when others then
173: fnd_message.set_name ('FND', 'CP-Generic oracle error');
174: fnd_message.set_token ('ERROR', substr (sqlerrm, 1, 30), FALSE);
175: fnd_message.set_token ('ROUTINE', 'REQUEST_LOCK (hndl)', FALSE);
176: end request_lock;
177:
178: --
179: -- PUBLIC PROCEDURES, FUNCTIONS

Line 208: fnd_message.set_name ('FND', 'CP-Generic oracle error');

204:
205: exception
206: when others then
207: e_code := NFALSE;
208: fnd_message.set_name ('FND', 'CP-Generic oracle error');
209: fnd_message.set_token ('ERROR', substr (sqlerrm, 1, 30), FALSE);
210: fnd_message.set_token ('ROUTINE', 'get_lk_handle', FALSE);
211: end get_lk_handle;
212:

Line 209: fnd_message.set_token ('ERROR', substr (sqlerrm, 1, 30), FALSE);

205: exception
206: when others then
207: e_code := NFALSE;
208: fnd_message.set_name ('FND', 'CP-Generic oracle error');
209: fnd_message.set_token ('ERROR', substr (sqlerrm, 1, 30), FALSE);
210: fnd_message.set_token ('ROUTINE', 'get_lk_handle', FALSE);
211: end get_lk_handle;
212:
213: /*------------------------------------------------------------------|

Line 210: fnd_message.set_token ('ROUTINE', 'get_lk_handle', FALSE);

206: when others then
207: e_code := NFALSE;
208: fnd_message.set_name ('FND', 'CP-Generic oracle error');
209: fnd_message.set_token ('ERROR', substr (sqlerrm, 1, 30), FALSE);
210: fnd_message.set_token ('ROUTINE', 'get_lk_handle', FALSE);
211: end get_lk_handle;
212:
213: /*------------------------------------------------------------------|
214: | Bug 2093806: The purpose of Request_Session_Lock is to provide |

Line 299: fnd_message.set_name ('FND', 'CONC-DBMS_LOCK.Request result');

295:
296: if (result in (0, 4)) then
297: return;
298: else
299: fnd_message.set_name ('FND', 'CONC-DBMS_LOCK.Request result');
300: fnd_message.set_token ('ROUTINE',
301: 'FND_DCP.REQUEST_SESSION_LOCK', FALSE);
302: fnd_message.set_token ('RESULT',
303: nvl(to_char(result),'NULL'), FALSE);

Line 300: fnd_message.set_token ('ROUTINE',

296: if (result in (0, 4)) then
297: return;
298: else
299: fnd_message.set_name ('FND', 'CONC-DBMS_LOCK.Request result');
300: fnd_message.set_token ('ROUTINE',
301: 'FND_DCP.REQUEST_SESSION_LOCK', FALSE);
302: fnd_message.set_token ('RESULT',
303: nvl(to_char(result),'NULL'), FALSE);
304: lk := null;

Line 302: fnd_message.set_token ('RESULT',

298: else
299: fnd_message.set_name ('FND', 'CONC-DBMS_LOCK.Request result');
300: fnd_message.set_token ('ROUTINE',
301: 'FND_DCP.REQUEST_SESSION_LOCK', FALSE);
302: fnd_message.set_token ('RESULT',
303: nvl(to_char(result),'NULL'), FALSE);
304: lk := null;
305: hndl := null;
306: return;

Line 374: fnd_message.set_name ('FND', 'CONC-DBMS_LOCK.Request result');

370: | result = (3 or 5 from DBMS_LOCK.Request or |
371: | still NULL from Request_Lock |
372: +-------------------------------------------------------*/
373: alive := NTRUE; -- assume manager alive
374: fnd_message.set_name ('FND', 'CONC-DBMS_LOCK.Request result');
375: fnd_message.set_token ('ROUTINE',
376: 'FND_DCP.CHECK_PROCESS_STATUS_BY_HANDLE',
377: FALSE);
378: fnd_message.set_token ('RESULT',

Line 375: fnd_message.set_token ('ROUTINE',

371: | still NULL from Request_Lock |
372: +-------------------------------------------------------*/
373: alive := NTRUE; -- assume manager alive
374: fnd_message.set_name ('FND', 'CONC-DBMS_LOCK.Request result');
375: fnd_message.set_token ('ROUTINE',
376: 'FND_DCP.CHECK_PROCESS_STATUS_BY_HANDLE',
377: FALSE);
378: fnd_message.set_token ('RESULT',
379: nvl(to_char(result), 'NULL'), FALSE);

Line 378: fnd_message.set_token ('RESULT',

374: fnd_message.set_name ('FND', 'CONC-DBMS_LOCK.Request result');
375: fnd_message.set_token ('ROUTINE',
376: 'FND_DCP.CHECK_PROCESS_STATUS_BY_HANDLE',
377: FALSE);
378: fnd_message.set_token ('RESULT',
379: nvl(to_char(result), 'NULL'), FALSE);
380:
381: end if;
382:

Line 493: fnd_message.set_name ('FND', 'CP-Generic oracle error');

489:
490: exception
491: when others then
492: e_code := NFALSE;
493: fnd_message.set_name ('FND', 'CP-Generic oracle error');
494: fnd_message.set_token ('ERROR', substr (sqlerrm, 1, 30), FALSE);
495: fnd_message.set_token ('ROUTINE', 'REQUEST_LOCK', FALSE);
496: end request_lock;
497:

Line 494: fnd_message.set_token ('ERROR', substr (sqlerrm, 1, 30), FALSE);

490: exception
491: when others then
492: e_code := NFALSE;
493: fnd_message.set_name ('FND', 'CP-Generic oracle error');
494: fnd_message.set_token ('ERROR', substr (sqlerrm, 1, 30), FALSE);
495: fnd_message.set_token ('ROUTINE', 'REQUEST_LOCK', FALSE);
496: end request_lock;
497:
498: -- ### OVERLOADED ###

Line 495: fnd_message.set_token ('ROUTINE', 'REQUEST_LOCK', FALSE);

491: when others then
492: e_code := NFALSE;
493: fnd_message.set_name ('FND', 'CP-Generic oracle error');
494: fnd_message.set_token ('ERROR', substr (sqlerrm, 1, 30), FALSE);
495: fnd_message.set_token ('ROUTINE', 'REQUEST_LOCK', FALSE);
496: end request_lock;
497:
498: -- ### OVERLOADED ###
499: /*------------------------------------------------------------------|

Line 525: fnd_message.set_name ('FND', 'CP-Generic oracle error');

521:
522: exception
523: when others then
524: e_code := NFALSE;
525: fnd_message.set_name ('FND', 'CP-Generic oracle error');
526: fnd_message.set_token ('ERROR', substr (sqlerrm, 1, 30), FALSE);
527: fnd_message.set_token ('ROUTINE', 'REQUEST_LOCK (hndl)', FALSE);
528: end request_lock;
529:

Line 526: fnd_message.set_token ('ERROR', substr (sqlerrm, 1, 30), FALSE);

522: exception
523: when others then
524: e_code := NFALSE;
525: fnd_message.set_name ('FND', 'CP-Generic oracle error');
526: fnd_message.set_token ('ERROR', substr (sqlerrm, 1, 30), FALSE);
527: fnd_message.set_token ('ROUTINE', 'REQUEST_LOCK (hndl)', FALSE);
528: end request_lock;
529:
530:

Line 527: fnd_message.set_token ('ROUTINE', 'REQUEST_LOCK (hndl)', FALSE);

523: when others then
524: e_code := NFALSE;
525: fnd_message.set_name ('FND', 'CP-Generic oracle error');
526: fnd_message.set_token ('ERROR', substr (sqlerrm, 1, 30), FALSE);
527: fnd_message.set_token ('ROUTINE', 'REQUEST_LOCK (hndl)', FALSE);
528: end request_lock;
529:
530:
531: procedure release_lock (hndl in varchar2,

Line 557: fnd_message.set_name ('FND', 'CP-Generic oracle error');

553: end if;
554: exception
555: when others then
556: e_code := NFALSE;
557: fnd_message.set_name ('FND', 'CP-Generic oracle error');
558: fnd_message.set_token ('ERROR', substr (sqlerrm, 1, 30), FALSE);
559: fnd_message.set_token ('ROUTINE', 'release_lock', FALSE);
560: end release_lock;
561:

Line 558: fnd_message.set_token ('ERROR', substr (sqlerrm, 1, 30), FALSE);

554: exception
555: when others then
556: e_code := NFALSE;
557: fnd_message.set_name ('FND', 'CP-Generic oracle error');
558: fnd_message.set_token ('ERROR', substr (sqlerrm, 1, 30), FALSE);
559: fnd_message.set_token ('ROUTINE', 'release_lock', FALSE);
560: end release_lock;
561:
562:

Line 559: fnd_message.set_token ('ROUTINE', 'release_lock', FALSE);

555: when others then
556: e_code := NFALSE;
557: fnd_message.set_name ('FND', 'CP-Generic oracle error');
558: fnd_message.set_token ('ERROR', substr (sqlerrm, 1, 30), FALSE);
559: fnd_message.set_token ('ROUTINE', 'release_lock', FALSE);
560: end release_lock;
561:
562:
563: procedure clean_mgrs (e_code in out nocopy number) is

Line 678: fnd_message.set_name ('FND', 'CP-Generic oracle error');

674: exception
675: when others then
676: e_code := NFALSE;
677: rollback;
678: fnd_message.set_name ('FND', 'CP-Generic oracle error');
679: fnd_message.set_token ('ERROR', substr (sqlerrm, 1, 30), FALSE);
680: fnd_message.set_token ('ROUTINE', 'monitor_icm', FALSE);
681: end monitor_icm;
682:

Line 679: fnd_message.set_token ('ERROR', substr (sqlerrm, 1, 30), FALSE);

675: when others then
676: e_code := NFALSE;
677: rollback;
678: fnd_message.set_name ('FND', 'CP-Generic oracle error');
679: fnd_message.set_token ('ERROR', substr (sqlerrm, 1, 30), FALSE);
680: fnd_message.set_token ('ROUTINE', 'monitor_icm', FALSE);
681: end monitor_icm;
682:
683:

Line 680: fnd_message.set_token ('ROUTINE', 'monitor_icm', FALSE);

676: e_code := NFALSE;
677: rollback;
678: fnd_message.set_name ('FND', 'CP-Generic oracle error');
679: fnd_message.set_token ('ERROR', substr (sqlerrm, 1, 30), FALSE);
680: fnd_message.set_token ('ROUTINE', 'monitor_icm', FALSE);
681: end monitor_icm;
682:
683:
684: procedure monitor_im (apid in number,

Line 721: fnd_message.set_name ('FND', 'CP-Generic oracle error');

717:
718: exception
719: when others then
720: e_code := NFALSE;
721: fnd_message.set_name ('FND', 'CP-Generic oracle error');
722: fnd_message.set_token ('ERROR', substr (sqlerrm, 1, 30), FALSE);
723: fnd_message.set_token ('ROUTINE', 'monitor_im', FALSE);
724: end monitor_im;
725:

Line 722: fnd_message.set_token ('ERROR', substr (sqlerrm, 1, 30), FALSE);

718: exception
719: when others then
720: e_code := NFALSE;
721: fnd_message.set_name ('FND', 'CP-Generic oracle error');
722: fnd_message.set_token ('ERROR', substr (sqlerrm, 1, 30), FALSE);
723: fnd_message.set_token ('ROUTINE', 'monitor_im', FALSE);
724: end monitor_im;
725:
726:

Line 723: fnd_message.set_token ('ROUTINE', 'monitor_im', FALSE);

719: when others then
720: e_code := NFALSE;
721: fnd_message.set_name ('FND', 'CP-Generic oracle error');
722: fnd_message.set_token ('ERROR', substr (sqlerrm, 1, 30), FALSE);
723: fnd_message.set_token ('ROUTINE', 'monitor_im', FALSE);
724: end monitor_im;
725:
726:
727: procedure reassign_lkh (e_code in out nocopy number) is

Line 770: fnd_message.set_name ('FND', 'CP-Generic oracle error');

766:
767: exception
768: when others then
769: e_code := NFALSE;
770: fnd_message.set_name ('FND', 'CP-Generic oracle error');
771: fnd_message.set_token ('ERROR', substr (sqlerrm, 1, 30), FALSE);
772: fnd_message.set_token ('ROUTINE', 'reassign_lkh', FALSE);
773: end reassign_lkh;
774:

Line 771: fnd_message.set_token ('ERROR', substr (sqlerrm, 1, 30), FALSE);

767: exception
768: when others then
769: e_code := NFALSE;
770: fnd_message.set_name ('FND', 'CP-Generic oracle error');
771: fnd_message.set_token ('ERROR', substr (sqlerrm, 1, 30), FALSE);
772: fnd_message.set_token ('ROUTINE', 'reassign_lkh', FALSE);
773: end reassign_lkh;
774:
775:

Line 772: fnd_message.set_token ('ROUTINE', 'reassign_lkh', FALSE);

768: when others then
769: e_code := NFALSE;
770: fnd_message.set_name ('FND', 'CP-Generic oracle error');
771: fnd_message.set_token ('ERROR', substr (sqlerrm, 1, 30), FALSE);
772: fnd_message.set_token ('ROUTINE', 'reassign_lkh', FALSE);
773: end reassign_lkh;
774:
775:
776: /* function get_inst_num

Line 986: fnd_message.set_name ('FND', 'CONC-REQ NODE NOT HONORED');

982:
983: /* If request target node is down, okay to run it */
984: if (dummy >= 1) then
985: retval := NTRUE;
986: fnd_message.set_name ('FND', 'CONC-REQ NODE NOT HONORED');
987: fnd_message.set_token ('REQID', to_char(req_id), FALSE);
988: fnd_message.set_token ('NODE', req_node, FALSE);
989: if( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
990: fnd_log.message(FND_LOG.LEVEL_EVENT,

Line 987: fnd_message.set_token ('REQID', to_char(req_id), FALSE);

983: /* If request target node is down, okay to run it */
984: if (dummy >= 1) then
985: retval := NTRUE;
986: fnd_message.set_name ('FND', 'CONC-REQ NODE NOT HONORED');
987: fnd_message.set_token ('REQID', to_char(req_id), FALSE);
988: fnd_message.set_token ('NODE', req_node, FALSE);
989: if( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
990: fnd_log.message(FND_LOG.LEVEL_EVENT,
991: 'fnd.plsql.FND_DCP.TARGET_NODE_MGR_CHK',

Line 988: fnd_message.set_token ('NODE', req_node, FALSE);

984: if (dummy >= 1) then
985: retval := NTRUE;
986: fnd_message.set_name ('FND', 'CONC-REQ NODE NOT HONORED');
987: fnd_message.set_token ('REQID', to_char(req_id), FALSE);
988: fnd_message.set_token ('NODE', req_node, FALSE);
989: if( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
990: fnd_log.message(FND_LOG.LEVEL_EVENT,
991: 'fnd.plsql.FND_DCP.TARGET_NODE_MGR_CHK',
992: FALSE);

Line 1023: fnd_message.set_name ('FND', 'CONC-REQ NODE NOT HONORED');

1019: retval := NFALSE;
1020: exit;
1021: else
1022: retval := NTRUE;
1023: fnd_message.set_name ('FND', 'CONC-REQ NODE NOT HONORED');
1024: fnd_message.set_token ('REQID', to_char(req_id), FALSE);
1025: fnd_message.set_token ('NODE', req_node, FALSE);
1026: if( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1027: fnd_log.message(FND_LOG.LEVEL_EVENT,

Line 1024: fnd_message.set_token ('REQID', to_char(req_id), FALSE);

1020: exit;
1021: else
1022: retval := NTRUE;
1023: fnd_message.set_name ('FND', 'CONC-REQ NODE NOT HONORED');
1024: fnd_message.set_token ('REQID', to_char(req_id), FALSE);
1025: fnd_message.set_token ('NODE', req_node, FALSE);
1026: if( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1027: fnd_log.message(FND_LOG.LEVEL_EVENT,
1028: 'fnd.plsql.FND_DCP.TARGET_NODE_MGR_CHK',

Line 1025: fnd_message.set_token ('NODE', req_node, FALSE);

1021: else
1022: retval := NTRUE;
1023: fnd_message.set_name ('FND', 'CONC-REQ NODE NOT HONORED');
1024: fnd_message.set_token ('REQID', to_char(req_id), FALSE);
1025: fnd_message.set_token ('NODE', req_node, FALSE);
1026: if( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1027: fnd_log.message(FND_LOG.LEVEL_EVENT,
1028: 'fnd.plsql.FND_DCP.TARGET_NODE_MGR_CHK',
1029: FALSE);