APPS.FND_CONCURRENT dependencies on FND_MESSAGE

Line 76: Fnd_Message.Set_Name('FND', 'CP-Generic oracle error');

72: end if;
73:
74: when others then
75: oraerrmesg := substr(SQLERRM, 1, 80);
76: Fnd_Message.Set_Name('FND', 'CP-Generic oracle error');
77: Fnd_Message.Set_Token('ERROR', oraerrmesg, FALSE);
78: Fnd_Message.Set_Token('ROUTINE', 'FND_CONCURRENT.Get_Handle', FALSE);
79: return FALSE;
80: end get_handle;

Line 77: Fnd_Message.Set_Token('ERROR', oraerrmesg, FALSE);

73:
74: when others then
75: oraerrmesg := substr(SQLERRM, 1, 80);
76: Fnd_Message.Set_Name('FND', 'CP-Generic oracle error');
77: Fnd_Message.Set_Token('ERROR', oraerrmesg, FALSE);
78: Fnd_Message.Set_Token('ROUTINE', 'FND_CONCURRENT.Get_Handle', FALSE);
79: return FALSE;
80: end get_handle;
81:

Line 78: Fnd_Message.Set_Token('ROUTINE', 'FND_CONCURRENT.Get_Handle', FALSE);

74: when others then
75: oraerrmesg := substr(SQLERRM, 1, 80);
76: Fnd_Message.Set_Name('FND', 'CP-Generic oracle error');
77: Fnd_Message.Set_Token('ERROR', oraerrmesg, FALSE);
78: Fnd_Message.Set_Token('ROUTINE', 'FND_CONCURRENT.Get_Handle', FALSE);
79: return FALSE;
80: end get_handle;
81:
82: -- procedure is internal to this package.

Line 230: Fnd_Message.Set_Name('FND', 'CONC-Req information required');

226:
227:
228: if (Request_ID is null) then
229: if (Program is null or Appl_ShortName is null) then
230: Fnd_Message.Set_Name('FND', 'CONC-Req information required');
231: return FALSE;
232: end if;
233: begin
234: Select Concurrent_Program_ID, P.Application_ID

Line 246: Fnd_Message.Set_Name('FND', 'CONC-Invalid Appl/Prog combo');

242: -- If no rows returned, return message "CONC-Invalid Appl/Prog combo"
243: --
244: exception
245: when no_data_found THEN
246: Fnd_Message.Set_Name('FND', 'CONC-Invalid Appl/Prog combo');
247: return FALSE;
248: when others then
249: raise; -- program_validate_error
250: end;

Line 266: Fnd_Message.Set_Name('FND', 'CONC-No req for appl/prog');

262: -- requests for this program "CONC-No req for appl/prog"
263: --
264: exception
265: when no_data_found then
266: Fnd_Message.Set_Name('FND', 'CONC-No req for appl/prog');
267: Fnd_Message.Set_Token('APPL', Appl_ShortName, FALSE);
268: Fnd_Message.Set_Token('PROGRAM', Program, FALSE);
269: return FALSE;
270: when others then

Line 267: Fnd_Message.Set_Token('APPL', Appl_ShortName, FALSE);

263: --
264: exception
265: when no_data_found then
266: Fnd_Message.Set_Name('FND', 'CONC-No req for appl/prog');
267: Fnd_Message.Set_Token('APPL', Appl_ShortName, FALSE);
268: Fnd_Message.Set_Token('PROGRAM', Program, FALSE);
269: return FALSE;
270: when others then
271: raise; -- fcr_access_error

Line 268: Fnd_Message.Set_Token('PROGRAM', Program, FALSE);

264: exception
265: when no_data_found then
266: Fnd_Message.Set_Name('FND', 'CONC-No req for appl/prog');
267: Fnd_Message.Set_Token('APPL', Appl_ShortName, FALSE);
268: Fnd_Message.Set_Token('PROGRAM', Program, FALSE);
269: return FALSE;
270: when others then
271: raise; -- fcr_access_error
272: end;

Line 324: Fnd_Message.Set_Name('FND', 'CONC-Request missing');

320: --
321: exception
322: when no_data_found then
323: Reqid_for_message := Req_ID;
324: Fnd_Message.Set_Name('FND', 'CONC-Request missing');
325: Fnd_Message.Set_Token('ROUTINE',
326: 'FND_CONCURRENT.GET_REQUEST_STATUS', FALSE);
327: Fnd_Message.Set_Token('REQUEST', Reqid_for_message, FALSE);
328: return FALSE;

Line 325: Fnd_Message.Set_Token('ROUTINE',

321: exception
322: when no_data_found then
323: Reqid_for_message := Req_ID;
324: Fnd_Message.Set_Name('FND', 'CONC-Request missing');
325: Fnd_Message.Set_Token('ROUTINE',
326: 'FND_CONCURRENT.GET_REQUEST_STATUS', FALSE);
327: Fnd_Message.Set_Token('REQUEST', Reqid_for_message, FALSE);
328: return FALSE;
329: when others then

Line 327: Fnd_Message.Set_Token('REQUEST', Reqid_for_message, FALSE);

323: Reqid_for_message := Req_ID;
324: Fnd_Message.Set_Name('FND', 'CONC-Request missing');
325: Fnd_Message.Set_Token('ROUTINE',
326: 'FND_CONCURRENT.GET_REQUEST_STATUS', FALSE);
327: Fnd_Message.Set_Token('REQUEST', Reqid_for_message, FALSE);
328: return FALSE;
329: when others then
330: raise; -- status_fetch_error
331: end;

Line 352: Fnd_Message.Set_Name('FND', 'CP-Generic oracle error');

348: -- when status_fetch_error then
349: -- null;
350: when others then
351: oraerrmesg := substr(SQLERRM, 1, 80);
352: Fnd_Message.Set_Name('FND', 'CP-Generic oracle error');
353: Fnd_Message.Set_Token('ERROR', oraerrmesg, FALSE);
354: Fnd_Message.Set_Token('ROUTINE',
355: 'FND_CONCURRENT.GET_REQUEST_STATUS', FALSE);
356: return FALSE;

Line 353: Fnd_Message.Set_Token('ERROR', oraerrmesg, FALSE);

349: -- null;
350: when others then
351: oraerrmesg := substr(SQLERRM, 1, 80);
352: Fnd_Message.Set_Name('FND', 'CP-Generic oracle error');
353: Fnd_Message.Set_Token('ERROR', oraerrmesg, FALSE);
354: Fnd_Message.Set_Token('ROUTINE',
355: 'FND_CONCURRENT.GET_REQUEST_STATUS', FALSE);
356: return FALSE;
357: end get_request_status;

Line 354: Fnd_Message.Set_Token('ROUTINE',

350: when others then
351: oraerrmesg := substr(SQLERRM, 1, 80);
352: Fnd_Message.Set_Name('FND', 'CP-Generic oracle error');
353: Fnd_Message.Set_Token('ERROR', oraerrmesg, FALSE);
354: Fnd_Message.Set_Token('ROUTINE',
355: 'FND_CONCURRENT.GET_REQUEST_STATUS', FALSE);
356: return FALSE;
357: end get_request_status;
358:

Line 401: Fnd_Message.Set_Name('FND', 'CONC-Req information required');

397: Rid number := request_id;
398: i number;
399: begin
400: if (Rid is null) then
401: Fnd_Message.Set_Name('FND', 'CONC-Req information required');
402: return FALSE;
403: end if;
404:
405: if ( max_wait > 0 ) then

Line 436: Fnd_Message.Set_Name('FND', 'CP-Generic oracle error');

432:
433: exception
434: when others then
435: oraerrmesg := substr(SQLERRM, 1, 80);
436: Fnd_Message.Set_Name('FND', 'CP-Generic oracle error');
437: Fnd_Message.Set_Token('ERROR', oraerrmesg, FALSE);
438: Fnd_Message.Set_Token('ROUTINE',
439: 'FND_CONCURRENT.WAIT_FOR_REQUEST', FALSE);
440: return FALSE;

Line 437: Fnd_Message.Set_Token('ERROR', oraerrmesg, FALSE);

433: exception
434: when others then
435: oraerrmesg := substr(SQLERRM, 1, 80);
436: Fnd_Message.Set_Name('FND', 'CP-Generic oracle error');
437: Fnd_Message.Set_Token('ERROR', oraerrmesg, FALSE);
438: Fnd_Message.Set_Token('ROUTINE',
439: 'FND_CONCURRENT.WAIT_FOR_REQUEST', FALSE);
440: return FALSE;
441: end wait_for_request;

Line 438: Fnd_Message.Set_Token('ROUTINE',

434: when others then
435: oraerrmesg := substr(SQLERRM, 1, 80);
436: Fnd_Message.Set_Name('FND', 'CP-Generic oracle error');
437: Fnd_Message.Set_Token('ERROR', oraerrmesg, FALSE);
438: Fnd_Message.Set_Token('ROUTINE',
439: 'FND_CONCURRENT.WAIT_FOR_REQUEST', FALSE);
440: return FALSE;
441: end wait_for_request;
442:

Line 608: Fnd_Message.Set_Name('FND', 'CP-Generic oracle error');

604: TargetP := 0;
605: ActiveP := 0;
606: callstat := 1;
607: oraerrmesg := substr(SQLERRM, 1, 80);
608: Fnd_Message.Set_Name('FND', 'CP-Generic oracle error');
609: Fnd_Message.Set_Token('ERROR', oraerrmesg, FALSE);
610: Fnd_Message.Set_Token('ROUTINE',
611: 'FND_CONCURRENT.GET_MANAGER_STATUS', FALSE);
612: return;

Line 609: Fnd_Message.Set_Token('ERROR', oraerrmesg, FALSE);

605: ActiveP := 0;
606: callstat := 1;
607: oraerrmesg := substr(SQLERRM, 1, 80);
608: Fnd_Message.Set_Name('FND', 'CP-Generic oracle error');
609: Fnd_Message.Set_Token('ERROR', oraerrmesg, FALSE);
610: Fnd_Message.Set_Token('ROUTINE',
611: 'FND_CONCURRENT.GET_MANAGER_STATUS', FALSE);
612: return;
613: end get_manager_status;

Line 610: Fnd_Message.Set_Token('ROUTINE',

606: callstat := 1;
607: oraerrmesg := substr(SQLERRM, 1, 80);
608: Fnd_Message.Set_Name('FND', 'CP-Generic oracle error');
609: Fnd_Message.Set_Token('ERROR', oraerrmesg, FALSE);
610: Fnd_Message.Set_Token('ROUTINE',
611: 'FND_CONCURRENT.GET_MANAGER_STATUS', FALSE);
612: return;
613: end get_manager_status;
614:

Line 769: fnd_message.set_name('FND', 'CONC-SCS BAD STATUS');

765: elsif (upper(status) = 'ERROR') then
766: scode := 'E';
767:
768: else
769: fnd_message.set_name('FND', 'CONC-SCS BAD STATUS');
770: fnd_message.set_token('STATUS', status);
771: return FALSE;
772: end if;
773:

Line 770: fnd_message.set_token('STATUS', status);

766: scode := 'E';
767:
768: else
769: fnd_message.set_name('FND', 'CONC-SCS BAD STATUS');
770: fnd_message.set_token('STATUS', status);
771: return FALSE;
772: end if;
773:
774: if ( lengthb(message) > 240 ) then

Line 784: Fnd_Message.Set_Name('FND', 'CP-Generic oracle error');

780: ret_str := set_status_autonomous(req_id, scode, message);
781:
782: -- if ret_str has some string that means some error otherwise return TRUE
783: if ( nvl(lengthb(ret_str), 0 ) > 0 ) then
784: Fnd_Message.Set_Name('FND', 'CP-Generic oracle error');
785: Fnd_Message.Set_Token('ERROR', ret_str, FALSE);
786: Fnd_Message.Set_Token('ROUTINE',
787: 'FND_CONCURRENT.SET_COMPLETION_STATUS', FALSE);
788: return FALSE;

Line 785: Fnd_Message.Set_Token('ERROR', ret_str, FALSE);

781:
782: -- if ret_str has some string that means some error otherwise return TRUE
783: if ( nvl(lengthb(ret_str), 0 ) > 0 ) then
784: Fnd_Message.Set_Name('FND', 'CP-Generic oracle error');
785: Fnd_Message.Set_Token('ERROR', ret_str, FALSE);
786: Fnd_Message.Set_Token('ROUTINE',
787: 'FND_CONCURRENT.SET_COMPLETION_STATUS', FALSE);
788: return FALSE;
789: else

Line 786: Fnd_Message.Set_Token('ROUTINE',

782: -- if ret_str has some string that means some error otherwise return TRUE
783: if ( nvl(lengthb(ret_str), 0 ) > 0 ) then
784: Fnd_Message.Set_Name('FND', 'CP-Generic oracle error');
785: Fnd_Message.Set_Token('ERROR', ret_str, FALSE);
786: Fnd_Message.Set_Token('ROUTINE',
787: 'FND_CONCURRENT.SET_COMPLETION_STATUS', FALSE);
788: return FALSE;
789: else
790: return TRUE;

Line 821: Fnd_Message.Set_Name('FND', 'CP-Generic oracle error');

817:
818: exception
819: when others then
820: oraerrmesg := substr(SQLERRM, 1, 80);
821: Fnd_Message.Set_Name('FND', 'CP-Generic oracle error');
822: Fnd_Message.Set_Token('ERROR', oraerrmesg, FALSE);
823: Fnd_Message.Set_Token('ROUTINE',
824: 'FND_CONCURRENT.GET_REQUEST_PRINT_OPTIONS', FALSE);
825: return FALSE;

Line 822: Fnd_Message.Set_Token('ERROR', oraerrmesg, FALSE);

818: exception
819: when others then
820: oraerrmesg := substr(SQLERRM, 1, 80);
821: Fnd_Message.Set_Name('FND', 'CP-Generic oracle error');
822: Fnd_Message.Set_Token('ERROR', oraerrmesg, FALSE);
823: Fnd_Message.Set_Token('ROUTINE',
824: 'FND_CONCURRENT.GET_REQUEST_PRINT_OPTIONS', FALSE);
825: return FALSE;
826: end get_request_print_options;

Line 823: Fnd_Message.Set_Token('ROUTINE',

819: when others then
820: oraerrmesg := substr(SQLERRM, 1, 80);
821: Fnd_Message.Set_Name('FND', 'CP-Generic oracle error');
822: Fnd_Message.Set_Token('ERROR', oraerrmesg, FALSE);
823: Fnd_Message.Set_Token('ROUTINE',
824: 'FND_CONCURRENT.GET_REQUEST_PRINT_OPTIONS', FALSE);
825: return FALSE;
826: end get_request_print_options;
827:

Line 867: Fnd_Message.Set_Name('FND', 'CP-Generic oracle error');

863:
864: exception
865: when others then
866: oraerrmesg := substr(SQLERRM, 1, 80);
867: Fnd_Message.Set_Name('FND', 'CP-Generic oracle error');
868: Fnd_Message.Set_Token('ERROR', oraerrmesg, FALSE);
869: Fnd_Message.Set_Token('ROUTINE',
870: 'FND_CONCURRENT.GET_REQUEST_PRINT_OPTIONS', FALSE);
871: return counter;

Line 868: Fnd_Message.Set_Token('ERROR', oraerrmesg, FALSE);

864: exception
865: when others then
866: oraerrmesg := substr(SQLERRM, 1, 80);
867: Fnd_Message.Set_Name('FND', 'CP-Generic oracle error');
868: Fnd_Message.Set_Token('ERROR', oraerrmesg, FALSE);
869: Fnd_Message.Set_Token('ROUTINE',
870: 'FND_CONCURRENT.GET_REQUEST_PRINT_OPTIONS', FALSE);
871: return counter;
872: end get_request_print_options;

Line 869: Fnd_Message.Set_Token('ROUTINE',

865: when others then
866: oraerrmesg := substr(SQLERRM, 1, 80);
867: Fnd_Message.Set_Name('FND', 'CP-Generic oracle error');
868: Fnd_Message.Set_Token('ERROR', oraerrmesg, FALSE);
869: Fnd_Message.Set_Token('ROUTINE',
870: 'FND_CONCURRENT.GET_REQUEST_PRINT_OPTIONS', FALSE);
871: return counter;
872: end get_request_print_options;
873:

Line 914: Fnd_Message.Set_Name('FND', 'CP-Need valid manager name');

910: and cp.concurrent_queue_id = cq.concurrent_queue_id
911: and cq.concurrent_queue_name = Queue_Name;
912:
913: if (Sql%NotFound) then
914: Fnd_Message.Set_Name('FND', 'CP-Need valid manager name');
915: return FALSE;
916: end if;
917: end if;
918:

Line 954: Fnd_Message.Set_Name('FND', 'CP-Generic oracle error');

950: return TRUE;
951:
952: when others then
953: oraerrmesg := substr(SQLERRM, 1, 80);
954: Fnd_Message.Set_Name('FND', 'CP-Generic oracle error');
955: Fnd_Message.Set_Token('ERROR', oraerrmesg, FALSE);
956: Fnd_Message.Set_Token('ROUTINE',
957: 'FND_CONCURRENT.Check_Lock_Contention', FALSE);
958: return FALSE;

Line 955: Fnd_Message.Set_Token('ERROR', oraerrmesg, FALSE);

951:
952: when others then
953: oraerrmesg := substr(SQLERRM, 1, 80);
954: Fnd_Message.Set_Name('FND', 'CP-Generic oracle error');
955: Fnd_Message.Set_Token('ERROR', oraerrmesg, FALSE);
956: Fnd_Message.Set_Token('ROUTINE',
957: 'FND_CONCURRENT.Check_Lock_Contention', FALSE);
958: return FALSE;
959:

Line 956: Fnd_Message.Set_Token('ROUTINE',

952: when others then
953: oraerrmesg := substr(SQLERRM, 1, 80);
954: Fnd_Message.Set_Name('FND', 'CP-Generic oracle error');
955: Fnd_Message.Set_Token('ERROR', oraerrmesg, FALSE);
956: Fnd_Message.Set_Token('ROUTINE',
957: 'FND_CONCURRENT.Check_Lock_Contention', FALSE);
958: return FALSE;
959:
960: end Check_Lock_Contention;

Line 991: Fnd_Message.Set_Name('FND', 'CONC-Invalid Appl/Prog combo');

987: and p.concurrent_program_name = program
988: and a.application_short_name = appl_shortname;
989:
990: if (Sql%NotFound) then
991: Fnd_Message.Set_Name('FND', 'CONC-Invalid Appl/Prog combo');
992: return FALSE;
993: end if;
994:
995: return TRUE;

Line 1000: Fnd_Message.Set_Name('FND', 'CP-Generic oracle error');

996:
997: exception
998: when others then
999: oraerrmesg := substr(SQLERRM, 1, 80);
1000: Fnd_Message.Set_Name('FND', 'CP-Generic oracle error');
1001: Fnd_Message.Set_Token('ERROR', oraerrmesg, FALSE);
1002: Fnd_Message.Set_Token('ROUTINE',
1003: 'FND_CONCURRENT.GET_PROGRAM_ATTRIBUTES', FALSE);
1004: return FALSE;

Line 1001: Fnd_Message.Set_Token('ERROR', oraerrmesg, FALSE);

997: exception
998: when others then
999: oraerrmesg := substr(SQLERRM, 1, 80);
1000: Fnd_Message.Set_Name('FND', 'CP-Generic oracle error');
1001: Fnd_Message.Set_Token('ERROR', oraerrmesg, FALSE);
1002: Fnd_Message.Set_Token('ROUTINE',
1003: 'FND_CONCURRENT.GET_PROGRAM_ATTRIBUTES', FALSE);
1004: return FALSE;
1005: end get_program_attributes;

Line 1002: Fnd_Message.Set_Token('ROUTINE',

998: when others then
999: oraerrmesg := substr(SQLERRM, 1, 80);
1000: Fnd_Message.Set_Name('FND', 'CP-Generic oracle error');
1001: Fnd_Message.Set_Token('ERROR', oraerrmesg, FALSE);
1002: Fnd_Message.Set_Token('ROUTINE',
1003: 'FND_CONCURRENT.GET_PROGRAM_ATTRIBUTES', FALSE);
1004: return FALSE;
1005: end get_program_attributes;
1006:

Line 1217: Fnd_Message.Set_Name('FND', 'CP-Generic oracle error');

1213:
1214: exception
1215: when others then
1216: oraerrmesg := substr(SQLERRM, 1, 80);
1217: Fnd_Message.Set_Name('FND', 'CP-Generic oracle error');
1218: Fnd_Message.Set_Token('ERROR', oraerrmesg, FALSE);
1219: Fnd_Message.Set_Token('ROUTINE',
1220: 'FND_CONCURRENT.INIT_REQUEST', FALSE);
1221: fnd_adg_support.log_unhandled_exception('fnd_concurrent.init_request',SQLERRM);

Line 1218: Fnd_Message.Set_Token('ERROR', oraerrmesg, FALSE);

1214: exception
1215: when others then
1216: oraerrmesg := substr(SQLERRM, 1, 80);
1217: Fnd_Message.Set_Name('FND', 'CP-Generic oracle error');
1218: Fnd_Message.Set_Token('ERROR', oraerrmesg, FALSE);
1219: Fnd_Message.Set_Token('ROUTINE',
1220: 'FND_CONCURRENT.INIT_REQUEST', FALSE);
1221: fnd_adg_support.log_unhandled_exception('fnd_concurrent.init_request',SQLERRM);
1222: return;

Line 1219: Fnd_Message.Set_Token('ROUTINE',

1215: when others then
1216: oraerrmesg := substr(SQLERRM, 1, 80);
1217: Fnd_Message.Set_Name('FND', 'CP-Generic oracle error');
1218: Fnd_Message.Set_Token('ERROR', oraerrmesg, FALSE);
1219: Fnd_Message.Set_Token('ROUTINE',
1220: 'FND_CONCURRENT.INIT_REQUEST', FALSE);
1221: fnd_adg_support.log_unhandled_exception('fnd_concurrent.init_request',SQLERRM);
1222: return;
1223:

Line 1374: fnd_message.set_name('FND', 'CONC-SHUTDOWN_ACTION_FAILURE');

1370: rollback to startpoint;
1371:
1372: errbuf := SQLERRM;
1373: if ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1374: fnd_message.set_name('FND', 'CONC-SHUTDOWN_ACTION_FAILURE');
1375: fnd_message.set_token('PROCEDURE', c_rec.execution_file_name);
1376: fnd_message.set_token('REASON', errbuf);
1377: fnd_log.message(FND_LOG.LEVEL_ERROR, 'fnd.plsql.fnd_concurrent.shut_down_procs', FALSE);
1378: end if;

Line 1375: fnd_message.set_token('PROCEDURE', c_rec.execution_file_name);

1371:
1372: errbuf := SQLERRM;
1373: if ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1374: fnd_message.set_name('FND', 'CONC-SHUTDOWN_ACTION_FAILURE');
1375: fnd_message.set_token('PROCEDURE', c_rec.execution_file_name);
1376: fnd_message.set_token('REASON', errbuf);
1377: fnd_log.message(FND_LOG.LEVEL_ERROR, 'fnd.plsql.fnd_concurrent.shut_down_procs', FALSE);
1378: end if;
1379: end;

Line 1376: fnd_message.set_token('REASON', errbuf);

1372: errbuf := SQLERRM;
1373: if ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1374: fnd_message.set_name('FND', 'CONC-SHUTDOWN_ACTION_FAILURE');
1375: fnd_message.set_token('PROCEDURE', c_rec.execution_file_name);
1376: fnd_message.set_token('REASON', errbuf);
1377: fnd_log.message(FND_LOG.LEVEL_ERROR, 'fnd.plsql.fnd_concurrent.shut_down_procs', FALSE);
1378: end if;
1379: end;
1380: END LOOP;

Line 1418: fnd_message.set_name('FND', 'CONC-SCS BAD STATUS');

1414: scode := 'E';
1415: elsif (upper(status) = 'PAUSED') then
1416: scode := 'W';
1417: else
1418: fnd_message.set_name('FND', 'CONC-SCS BAD STATUS');
1419: fnd_message.set_token('STATUS', status);
1420: return FALSE;
1421: end if;
1422:

Line 1419: fnd_message.set_token('STATUS', status);

1415: elsif (upper(status) = 'PAUSED') then
1416: scode := 'W';
1417: else
1418: fnd_message.set_name('FND', 'CONC-SCS BAD STATUS');
1419: fnd_message.set_token('STATUS', status);
1420: return FALSE;
1421: end if;
1422:
1423:

Line 1425: fnd_message.set_name('FND', 'CONC-REQ RETURNED NO MESG');

1421: end if;
1422:
1423:
1424: if ( (lengthb(message) = 0) and scode in ('G','E')) then
1425: fnd_message.set_name('FND', 'CONC-REQ RETURNED NO MESG');
1426: lmessage := fnd_message.get;
1427: elsif( (lengthb(message) = 0) and scode in ('W')) then
1428: fnd_message.set_name('FND', 'CONC_REQ REQUEST INFO');
1429: lmessage := message;

Line 1426: lmessage := fnd_message.get;

1422:
1423:
1424: if ( (lengthb(message) = 0) and scode in ('G','E')) then
1425: fnd_message.set_name('FND', 'CONC-REQ RETURNED NO MESG');
1426: lmessage := fnd_message.get;
1427: elsif( (lengthb(message) = 0) and scode in ('W')) then
1428: fnd_message.set_name('FND', 'CONC_REQ REQUEST INFO');
1429: lmessage := message;
1430: else

Line 1428: fnd_message.set_name('FND', 'CONC_REQ REQUEST INFO');

1424: if ( (lengthb(message) = 0) and scode in ('G','E')) then
1425: fnd_message.set_name('FND', 'CONC-REQ RETURNED NO MESG');
1426: lmessage := fnd_message.get;
1427: elsif( (lengthb(message) = 0) and scode in ('W')) then
1428: fnd_message.set_name('FND', 'CONC_REQ REQUEST INFO');
1429: lmessage := message;
1430: else
1431: lmessage := message;
1432: end if;

Line 1444: Fnd_Message.Set_Name('FND', 'CP-Generic oracle error');

1440: ret_str := set_status_autonomous(req_id, scode, lmessage, TRUE);
1441:
1442: -- if ret_str has some string that means some error otherwise return TRUE
1443: if ( nvl(lengthb(ret_str), 0 ) > 0 ) then
1444: Fnd_Message.Set_Name('FND', 'CP-Generic oracle error');
1445: Fnd_Message.Set_Token('ERROR', ret_str, FALSE);
1446: Fnd_Message.Set_Token('ROUTINE',
1447: 'FND_CONCURRENT.SET_INTERIM_STATUS', FALSE);
1448: return FALSE;

Line 1445: Fnd_Message.Set_Token('ERROR', ret_str, FALSE);

1441:
1442: -- if ret_str has some string that means some error otherwise return TRUE
1443: if ( nvl(lengthb(ret_str), 0 ) > 0 ) then
1444: Fnd_Message.Set_Name('FND', 'CP-Generic oracle error');
1445: Fnd_Message.Set_Token('ERROR', ret_str, FALSE);
1446: Fnd_Message.Set_Token('ROUTINE',
1447: 'FND_CONCURRENT.SET_INTERIM_STATUS', FALSE);
1448: return FALSE;
1449: else

Line 1446: Fnd_Message.Set_Token('ROUTINE',

1442: -- if ret_str has some string that means some error otherwise return TRUE
1443: if ( nvl(lengthb(ret_str), 0 ) > 0 ) then
1444: Fnd_Message.Set_Name('FND', 'CP-Generic oracle error');
1445: Fnd_Message.Set_Token('ERROR', ret_str, FALSE);
1446: Fnd_Message.Set_Token('ROUTINE',
1447: 'FND_CONCURRENT.SET_INTERIM_STATUS', FALSE);
1448: return FALSE;
1449: else
1450: return TRUE;

Line 1739: fnd_message.set_name('FND', 'CONC-SM INVALID SVC HANDLE');

1735: from FND_CP_SERVICES
1736: where SERVICE_HANDLE = upper(svc_handle);
1737: exception
1738: when no_data_found then
1739: fnd_message.set_name('FND', 'CONC-SM INVALID SVC HANDLE');
1740: fnd_message.set_token('HANDLE', svc_handle);
1741: user_error := substrb(fnd_message.get, 1, 255);
1742: raise_application_error(-20100, user_error);
1743: end;

Line 1740: fnd_message.set_token('HANDLE', svc_handle);

1736: where SERVICE_HANDLE = upper(svc_handle);
1737: exception
1738: when no_data_found then
1739: fnd_message.set_name('FND', 'CONC-SM INVALID SVC HANDLE');
1740: fnd_message.set_token('HANDLE', svc_handle);
1741: user_error := substrb(fnd_message.get, 1, 255);
1742: raise_application_error(-20100, user_error);
1743: end;
1744:

Line 1741: user_error := substrb(fnd_message.get, 1, 255);

1737: exception
1738: when no_data_found then
1739: fnd_message.set_name('FND', 'CONC-SM INVALID SVC HANDLE');
1740: fnd_message.set_token('HANDLE', svc_handle);
1741: user_error := substrb(fnd_message.get, 1, 255);
1742: raise_application_error(-20100, user_error);
1743: end;
1744:
1745:

Line 1836: fnd_message.set_name('FND', 'CONC-SM INVALID SVC INSTANCE');

1832: and APPLICATION_SHORT_NAME = upper(appl_short_name)
1833: and upper(CONCURRENT_QUEUE_NAME) = upper(svc_instance_name);
1834: exception
1835: when no_data_found then
1836: fnd_message.set_name('FND', 'CONC-SM INVALID SVC INSTANCE');
1837: fnd_message.set_token('APPLICATION', appl_short_name);
1838: fnd_message.set_token('INSTANCE', svc_instance_name);
1839: user_error := substrb(fnd_message.get, 1, 255);
1840: raise_application_error(-20100, user_error);

Line 1837: fnd_message.set_token('APPLICATION', appl_short_name);

1833: and upper(CONCURRENT_QUEUE_NAME) = upper(svc_instance_name);
1834: exception
1835: when no_data_found then
1836: fnd_message.set_name('FND', 'CONC-SM INVALID SVC INSTANCE');
1837: fnd_message.set_token('APPLICATION', appl_short_name);
1838: fnd_message.set_token('INSTANCE', svc_instance_name);
1839: user_error := substrb(fnd_message.get, 1, 255);
1840: raise_application_error(-20100, user_error);
1841: end;

Line 1838: fnd_message.set_token('INSTANCE', svc_instance_name);

1834: exception
1835: when no_data_found then
1836: fnd_message.set_name('FND', 'CONC-SM INVALID SVC INSTANCE');
1837: fnd_message.set_token('APPLICATION', appl_short_name);
1838: fnd_message.set_token('INSTANCE', svc_instance_name);
1839: user_error := substrb(fnd_message.get, 1, 255);
1840: raise_application_error(-20100, user_error);
1841: end;
1842:

Line 1839: user_error := substrb(fnd_message.get, 1, 255);

1835: when no_data_found then
1836: fnd_message.set_name('FND', 'CONC-SM INVALID SVC INSTANCE');
1837: fnd_message.set_token('APPLICATION', appl_short_name);
1838: fnd_message.set_token('INSTANCE', svc_instance_name);
1839: user_error := substrb(fnd_message.get, 1, 255);
1840: raise_application_error(-20100, user_error);
1841: end;
1842:
1843: FOR c1_rec in C1 LOOP

Line 2389: Fnd_Message.Set_Name('FND', 'CP-Generic oracle error');

2385:
2386: exception
2387: when others then
2388: oraerrmesg := substr(SQLERRM, 1, 80);
2389: Fnd_Message.Set_Name('FND', 'CP-Generic oracle error');
2390: Fnd_Message.Set_Token('ERROR', oraerrmesg, FALSE);
2391: Fnd_Message.Set_Token('ROUTINE',
2392: 'FND_CONCURRENT.WAIT_FOR_ALL_DOWN', FALSE);
2393: return FALSE;

Line 2390: Fnd_Message.Set_Token('ERROR', oraerrmesg, FALSE);

2386: exception
2387: when others then
2388: oraerrmesg := substr(SQLERRM, 1, 80);
2389: Fnd_Message.Set_Name('FND', 'CP-Generic oracle error');
2390: Fnd_Message.Set_Token('ERROR', oraerrmesg, FALSE);
2391: Fnd_Message.Set_Token('ROUTINE',
2392: 'FND_CONCURRENT.WAIT_FOR_ALL_DOWN', FALSE);
2393: return FALSE;
2394: end Wait_For_All_Down;

Line 2391: Fnd_Message.Set_Token('ROUTINE',

2387: when others then
2388: oraerrmesg := substr(SQLERRM, 1, 80);
2389: Fnd_Message.Set_Name('FND', 'CP-Generic oracle error');
2390: Fnd_Message.Set_Token('ERROR', oraerrmesg, FALSE);
2391: Fnd_Message.Set_Token('ROUTINE',
2392: 'FND_CONCURRENT.WAIT_FOR_ALL_DOWN', FALSE);
2393: return FALSE;
2394: end Wait_For_All_Down;
2395:

Line 2444: Fnd_Message.Set_Name('FND', 'CP-MultiQC OldStyle');

2440: when others then
2441: Detail := 'QID = ' || to_char(Arg1);
2442: end;
2443:
2444: Fnd_Message.Set_Name('FND', 'CP-MultiQC OldStyle');
2445: Fnd_Message.Set_Token('ACTION', action, FALSE);
2446: Fnd_Message.Set_Token('QUEUE', detail, FALSE);
2447: Descr := Fnd_Message.get;
2448:

Line 2445: Fnd_Message.Set_Token('ACTION', action, FALSE);

2441: Detail := 'QID = ' || to_char(Arg1);
2442: end;
2443:
2444: Fnd_Message.Set_Name('FND', 'CP-MultiQC OldStyle');
2445: Fnd_Message.Set_Token('ACTION', action, FALSE);
2446: Fnd_Message.Set_Token('QUEUE', detail, FALSE);
2447: Descr := Fnd_Message.get;
2448:
2449: return Descr;

Line 2446: Fnd_Message.Set_Token('QUEUE', detail, FALSE);

2442: end;
2443:
2444: Fnd_Message.Set_Name('FND', 'CP-MultiQC OldStyle');
2445: Fnd_Message.Set_Token('ACTION', action, FALSE);
2446: Fnd_Message.Set_Token('QUEUE', detail, FALSE);
2447: Descr := Fnd_Message.get;
2448:
2449: return Descr;
2450:

Line 2447: Descr := Fnd_Message.get;

2443:
2444: Fnd_Message.Set_Name('FND', 'CP-MultiQC OldStyle');
2445: Fnd_Message.Set_Token('ACTION', action, FALSE);
2446: Fnd_Message.Set_Token('QUEUE', detail, FALSE);
2447: Descr := Fnd_Message.get;
2448:
2449: return Descr;
2450:
2451: elsif (Arg1 = -1) then

Line 2462: Fnd_Message.Set_Name('FND', 'CP-MultiQC -1 ' || to_char(Arg3));

2458: when others then
2459: Detail := 'APPID = ' || to_char(Arg2);
2460: end;
2461:
2462: Fnd_Message.Set_Name('FND', 'CP-MultiQC -1 ' || to_char(Arg3));
2463: Fnd_Message.Set_Token('ACTION', action, FALSE);
2464: Fnd_Message.Set_Token('APP', detail, FALSE);
2465: Descr := Fnd_Message.get;
2466:

Line 2463: Fnd_Message.Set_Token('ACTION', action, FALSE);

2459: Detail := 'APPID = ' || to_char(Arg2);
2460: end;
2461:
2462: Fnd_Message.Set_Name('FND', 'CP-MultiQC -1 ' || to_char(Arg3));
2463: Fnd_Message.Set_Token('ACTION', action, FALSE);
2464: Fnd_Message.Set_Token('APP', detail, FALSE);
2465: Descr := Fnd_Message.get;
2466:
2467: return Descr;

Line 2464: Fnd_Message.Set_Token('APP', detail, FALSE);

2460: end;
2461:
2462: Fnd_Message.Set_Name('FND', 'CP-MultiQC -1 ' || to_char(Arg3));
2463: Fnd_Message.Set_Token('ACTION', action, FALSE);
2464: Fnd_Message.Set_Token('APP', detail, FALSE);
2465: Descr := Fnd_Message.get;
2466:
2467: return Descr;
2468:

Line 2465: Descr := Fnd_Message.get;

2461:
2462: Fnd_Message.Set_Name('FND', 'CP-MultiQC -1 ' || to_char(Arg3));
2463: Fnd_Message.Set_Token('ACTION', action, FALSE);
2464: Fnd_Message.Set_Token('APP', detail, FALSE);
2465: Descr := Fnd_Message.get;
2466:
2467: return Descr;
2468:
2469: elsif (Arg1 = -2) then

Line 2471: Fnd_Message.Set_Name('FND', 'CP-MultiQC -2');

2467: return Descr;
2468:
2469: elsif (Arg1 = -2) then
2470:
2471: Fnd_Message.Set_Name('FND', 'CP-MultiQC -2');
2472: Fnd_Message.Set_Token('ACTION', action, FALSE);
2473: Descr := Fnd_Message.get;
2474:
2475: return Descr;

Line 2472: Fnd_Message.Set_Token('ACTION', action, FALSE);

2468:
2469: elsif (Arg1 = -2) then
2470:
2471: Fnd_Message.Set_Name('FND', 'CP-MultiQC -2');
2472: Fnd_Message.Set_Token('ACTION', action, FALSE);
2473: Descr := Fnd_Message.get;
2474:
2475: return Descr;
2476:

Line 2473: Descr := Fnd_Message.get;

2469: elsif (Arg1 = -2) then
2470:
2471: Fnd_Message.Set_Name('FND', 'CP-MultiQC -2');
2472: Fnd_Message.Set_Token('ACTION', action, FALSE);
2473: Descr := Fnd_Message.get;
2474:
2475: return Descr;
2476:
2477: elsif (Arg1 = -3) then

Line 2488: Fnd_Message.Set_Name('FND', 'CP-MultiQC -3');

2484: when others then
2485: Detail := 'SVCID = ' || to_char(Arg2);
2486: end;
2487:
2488: Fnd_Message.Set_Name('FND', 'CP-MultiQC -3');
2489: Fnd_Message.Set_Token('ACTION', action, FALSE);
2490: Fnd_Message.Set_Token('SVC', detail, FALSE);
2491: Descr := Fnd_Message.get;
2492:

Line 2489: Fnd_Message.Set_Token('ACTION', action, FALSE);

2485: Detail := 'SVCID = ' || to_char(Arg2);
2486: end;
2487:
2488: Fnd_Message.Set_Name('FND', 'CP-MultiQC -3');
2489: Fnd_Message.Set_Token('ACTION', action, FALSE);
2490: Fnd_Message.Set_Token('SVC', detail, FALSE);
2491: Descr := Fnd_Message.get;
2492:
2493: return Descr;

Line 2490: Fnd_Message.Set_Token('SVC', detail, FALSE);

2486: end;
2487:
2488: Fnd_Message.Set_Name('FND', 'CP-MultiQC -3');
2489: Fnd_Message.Set_Token('ACTION', action, FALSE);
2490: Fnd_Message.Set_Token('SVC', detail, FALSE);
2491: Descr := Fnd_Message.get;
2492:
2493: return Descr;
2494:

Line 2491: Descr := Fnd_Message.get;

2487:
2488: Fnd_Message.Set_Name('FND', 'CP-MultiQC -3');
2489: Fnd_Message.Set_Token('ACTION', action, FALSE);
2490: Fnd_Message.Set_Token('SVC', detail, FALSE);
2491: Descr := Fnd_Message.get;
2492:
2493: return Descr;
2494:
2495: elsif (Arg1 = -4) then

Line 2497: Fnd_Message.Set_Name('FND', 'CP-MultiQC -4');

2493: return Descr;
2494:
2495: elsif (Arg1 = -4) then
2496:
2497: Fnd_Message.Set_Name('FND', 'CP-MultiQC -4');
2498: Fnd_Message.Set_Token('ACTION', action, FALSE);
2499: Descr := Fnd_Message.get;
2500:
2501: return Descr;

Line 2498: Fnd_Message.Set_Token('ACTION', action, FALSE);

2494:
2495: elsif (Arg1 = -4) then
2496:
2497: Fnd_Message.Set_Name('FND', 'CP-MultiQC -4');
2498: Fnd_Message.Set_Token('ACTION', action, FALSE);
2499: Descr := Fnd_Message.get;
2500:
2501: return Descr;
2502:

Line 2499: Descr := Fnd_Message.get;

2495: elsif (Arg1 = -4) then
2496:
2497: Fnd_Message.Set_Name('FND', 'CP-MultiQC -4');
2498: Fnd_Message.Set_Token('ACTION', action, FALSE);
2499: Descr := Fnd_Message.get;
2500:
2501: return Descr;
2502:
2503:

Line 2552: fnd_message.set_name('FND', 'CONC-Could not lock Request');

2548:
2549: if ( ret_val = 0 ) then
2550: return FALSE;
2551: elsif ( ret_val = 1 ) then
2552: fnd_message.set_name('FND', 'CONC-Could not lock Request');
2553: message := fnd_message.get;
2554: return FALSE;
2555: elsif ( ret_val = 2 ) then
2556: fnd_message.set_name('FND', 'CONC-request completed');

Line 2553: message := fnd_message.get;

2549: if ( ret_val = 0 ) then
2550: return FALSE;
2551: elsif ( ret_val = 1 ) then
2552: fnd_message.set_name('FND', 'CONC-Could not lock Request');
2553: message := fnd_message.get;
2554: return FALSE;
2555: elsif ( ret_val = 2 ) then
2556: fnd_message.set_name('FND', 'CONC-request completed');
2557: message := fnd_message.get;

Line 2556: fnd_message.set_name('FND', 'CONC-request completed');

2552: fnd_message.set_name('FND', 'CONC-Could not lock Request');
2553: message := fnd_message.get;
2554: return FALSE;
2555: elsif ( ret_val = 2 ) then
2556: fnd_message.set_name('FND', 'CONC-request completed');
2557: message := fnd_message.get;
2558: return FALSE;
2559: elsif ( ret_val = 3 ) then
2560: fnd_message.set_name('FND', 'CONC-cannot cancel mgr dead');

Line 2557: message := fnd_message.get;

2553: message := fnd_message.get;
2554: return FALSE;
2555: elsif ( ret_val = 2 ) then
2556: fnd_message.set_name('FND', 'CONC-request completed');
2557: message := fnd_message.get;
2558: return FALSE;
2559: elsif ( ret_val = 3 ) then
2560: fnd_message.set_name('FND', 'CONC-cannot cancel mgr dead');
2561: message := fnd_message.get;

Line 2560: fnd_message.set_name('FND', 'CONC-cannot cancel mgr dead');

2556: fnd_message.set_name('FND', 'CONC-request completed');
2557: message := fnd_message.get;
2558: return FALSE;
2559: elsif ( ret_val = 3 ) then
2560: fnd_message.set_name('FND', 'CONC-cannot cancel mgr dead');
2561: message := fnd_message.get;
2562: return FALSE;
2563: elsif ( ret_val in (4,5)) then
2564: return TRUE;

Line 2561: message := fnd_message.get;

2557: message := fnd_message.get;
2558: return FALSE;
2559: elsif ( ret_val = 3 ) then
2560: fnd_message.set_name('FND', 'CONC-cannot cancel mgr dead');
2561: message := fnd_message.get;
2562: return FALSE;
2563: elsif ( ret_val in (4,5)) then
2564: return TRUE;
2565: end if;

Line 2569: fnd_message.set_name('FND', 'CONC-MISSING REQUEST');

2565: end if;
2566:
2567: exception
2568: when request_missing then
2569: fnd_message.set_name('FND', 'CONC-MISSING REQUEST');
2570: fnd_message.set_token('ROUTINE', 'FND_CONCURRENT.CANCEL_REQUEST');
2571: fnd_message.set_token('REQUEST', to_char(request_id));
2572: message := fnd_message.get;
2573: return FALSE;

Line 2570: fnd_message.set_token('ROUTINE', 'FND_CONCURRENT.CANCEL_REQUEST');

2566:
2567: exception
2568: when request_missing then
2569: fnd_message.set_name('FND', 'CONC-MISSING REQUEST');
2570: fnd_message.set_token('ROUTINE', 'FND_CONCURRENT.CANCEL_REQUEST');
2571: fnd_message.set_token('REQUEST', to_char(request_id));
2572: message := fnd_message.get;
2573: return FALSE;
2574: when no_privilege then

Line 2571: fnd_message.set_token('REQUEST', to_char(request_id));

2567: exception
2568: when request_missing then
2569: fnd_message.set_name('FND', 'CONC-MISSING REQUEST');
2570: fnd_message.set_token('ROUTINE', 'FND_CONCURRENT.CANCEL_REQUEST');
2571: fnd_message.set_token('REQUEST', to_char(request_id));
2572: message := fnd_message.get;
2573: return FALSE;
2574: when no_privilege then
2575: fnd_message.set_name('FND', 'CONC-NOT OWNER OF REQUEST');

Line 2572: message := fnd_message.get;

2568: when request_missing then
2569: fnd_message.set_name('FND', 'CONC-MISSING REQUEST');
2570: fnd_message.set_token('ROUTINE', 'FND_CONCURRENT.CANCEL_REQUEST');
2571: fnd_message.set_token('REQUEST', to_char(request_id));
2572: message := fnd_message.get;
2573: return FALSE;
2574: when no_privilege then
2575: fnd_message.set_name('FND', 'CONC-NOT OWNER OF REQUEST');
2576: fnd_message.set_token('REQUEST', to_char(request_id));

Line 2575: fnd_message.set_name('FND', 'CONC-NOT OWNER OF REQUEST');

2571: fnd_message.set_token('REQUEST', to_char(request_id));
2572: message := fnd_message.get;
2573: return FALSE;
2574: when no_privilege then
2575: fnd_message.set_name('FND', 'CONC-NOT OWNER OF REQUEST');
2576: fnd_message.set_token('REQUEST', to_char(request_id));
2577: message := fnd_message.get;
2578: return FALSE;
2579: when others then

Line 2576: fnd_message.set_token('REQUEST', to_char(request_id));

2572: message := fnd_message.get;
2573: return FALSE;
2574: when no_privilege then
2575: fnd_message.set_name('FND', 'CONC-NOT OWNER OF REQUEST');
2576: fnd_message.set_token('REQUEST', to_char(request_id));
2577: message := fnd_message.get;
2578: return FALSE;
2579: when others then
2580: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

Line 2577: message := fnd_message.get;

2573: return FALSE;
2574: when no_privilege then
2575: fnd_message.set_name('FND', 'CONC-NOT OWNER OF REQUEST');
2576: fnd_message.set_token('REQUEST', to_char(request_id));
2577: message := fnd_message.get;
2578: return FALSE;
2579: when others then
2580: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2581: fnd_message.set_token('ROUTINE', 'FND_CONCURRENT.CANCEL_REQUEST');

Line 2580: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

2576: fnd_message.set_token('REQUEST', to_char(request_id));
2577: message := fnd_message.get;
2578: return FALSE;
2579: when others then
2580: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2581: fnd_message.set_token('ROUTINE', 'FND_CONCURRENT.CANCEL_REQUEST');
2582: fnd_message.set_token('ERRNO', SQLCODE);
2583: fnd_message.set_token('REASON', SQLERRM);
2584: message := fnd_message.get;

Line 2581: fnd_message.set_token('ROUTINE', 'FND_CONCURRENT.CANCEL_REQUEST');

2577: message := fnd_message.get;
2578: return FALSE;
2579: when others then
2580: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2581: fnd_message.set_token('ROUTINE', 'FND_CONCURRENT.CANCEL_REQUEST');
2582: fnd_message.set_token('ERRNO', SQLCODE);
2583: fnd_message.set_token('REASON', SQLERRM);
2584: message := fnd_message.get;
2585: return FALSE;

Line 2582: fnd_message.set_token('ERRNO', SQLCODE);

2578: return FALSE;
2579: when others then
2580: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2581: fnd_message.set_token('ROUTINE', 'FND_CONCURRENT.CANCEL_REQUEST');
2582: fnd_message.set_token('ERRNO', SQLCODE);
2583: fnd_message.set_token('REASON', SQLERRM);
2584: message := fnd_message.get;
2585: return FALSE;
2586:

Line 2583: fnd_message.set_token('REASON', SQLERRM);

2579: when others then
2580: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2581: fnd_message.set_token('ROUTINE', 'FND_CONCURRENT.CANCEL_REQUEST');
2582: fnd_message.set_token('ERRNO', SQLCODE);
2583: fnd_message.set_token('REASON', SQLERRM);
2584: message := fnd_message.get;
2585: return FALSE;
2586:
2587: end Cancel_Request;

Line 2584: message := fnd_message.get;

2580: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2581: fnd_message.set_token('ROUTINE', 'FND_CONCURRENT.CANCEL_REQUEST');
2582: fnd_message.set_token('ERRNO', SQLCODE);
2583: fnd_message.set_token('REASON', SQLERRM);
2584: message := fnd_message.get;
2585: return FALSE;
2586:
2587: end Cancel_Request;
2588:

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

2627: return result;
2628:
2629: exception
2630: when others then
2631: fnd_message.set_name ('FND', 'CP-Generic oracle error');
2632: fnd_message.set_token ('ERROR', substr (sqlerrm, 1, 30), FALSE);
2633: fnd_message.set_token ('ROUTINE', 'fnd_concurrent.get_resource_lock',
2634: FALSE);
2635: return result;

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

2628:
2629: exception
2630: when others then
2631: fnd_message.set_name ('FND', 'CP-Generic oracle error');
2632: fnd_message.set_token ('ERROR', substr (sqlerrm, 1, 30), FALSE);
2633: fnd_message.set_token ('ROUTINE', 'fnd_concurrent.get_resource_lock',
2634: FALSE);
2635: return result;
2636:

Line 2633: fnd_message.set_token ('ROUTINE', 'fnd_concurrent.get_resource_lock',

2629: exception
2630: when others then
2631: fnd_message.set_name ('FND', 'CP-Generic oracle error');
2632: fnd_message.set_token ('ERROR', substr (sqlerrm, 1, 30), FALSE);
2633: fnd_message.set_token ('ROUTINE', 'fnd_concurrent.get_resource_lock',
2634: FALSE);
2635: return result;
2636:
2637: end;

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

2669: return result;
2670:
2671: exception
2672: when others then
2673: fnd_message.set_name ('FND', 'CP-Generic oracle error');
2674: fnd_message.set_token ('ERROR', substr (sqlerrm, 1, 30), FALSE);
2675: fnd_message.set_token ('ROUTINE', 'fnd_concurrent.release_resource_lock',
2676: FALSE);
2677: return result;

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

2670:
2671: exception
2672: when others then
2673: fnd_message.set_name ('FND', 'CP-Generic oracle error');
2674: fnd_message.set_token ('ERROR', substr (sqlerrm, 1, 30), FALSE);
2675: fnd_message.set_token ('ROUTINE', 'fnd_concurrent.release_resource_lock',
2676: FALSE);
2677: return result;
2678:

Line 2675: fnd_message.set_token ('ROUTINE', 'fnd_concurrent.release_resource_lock',

2671: exception
2672: when others then
2673: fnd_message.set_name ('FND', 'CP-Generic oracle error');
2674: fnd_message.set_token ('ERROR', substr (sqlerrm, 1, 30), FALSE);
2675: fnd_message.set_token ('ROUTINE', 'fnd_concurrent.release_resource_lock',
2676: FALSE);
2677: return result;
2678:
2679: end;

Line 2792: fnd_message.set_name ('FND', 'SQL-Generic error');

2788: exception
2789: when others then
2790:
2791: if ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2792: fnd_message.set_name ('FND', 'SQL-Generic error');
2793: fnd_message.set_token ('ERRNO', sqlcode, FALSE);
2794: fnd_message.set_token ('REASON', sqlerrm, FALSE);
2795: fnd_message.set_token ('ROUTINE', 'FND_CONCURRENT.INIT_SQL_REQUEST', FALSE);
2796: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

Line 2793: fnd_message.set_token ('ERRNO', sqlcode, FALSE);

2789: when others then
2790:
2791: if ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2792: fnd_message.set_name ('FND', 'SQL-Generic error');
2793: fnd_message.set_token ('ERRNO', sqlcode, FALSE);
2794: fnd_message.set_token ('REASON', sqlerrm, FALSE);
2795: fnd_message.set_token ('ROUTINE', 'FND_CONCURRENT.INIT_SQL_REQUEST', FALSE);
2796: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
2797: 'fnd.plsql.FND_CONCURRENT.INIT_SQL_REQUEST.others', FALSE);

Line 2794: fnd_message.set_token ('REASON', sqlerrm, FALSE);

2790:
2791: if ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2792: fnd_message.set_name ('FND', 'SQL-Generic error');
2793: fnd_message.set_token ('ERRNO', sqlcode, FALSE);
2794: fnd_message.set_token ('REASON', sqlerrm, FALSE);
2795: fnd_message.set_token ('ROUTINE', 'FND_CONCURRENT.INIT_SQL_REQUEST', FALSE);
2796: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
2797: 'fnd.plsql.FND_CONCURRENT.INIT_SQL_REQUEST.others', FALSE);
2798: end if;

Line 2795: fnd_message.set_token ('ROUTINE', 'FND_CONCURRENT.INIT_SQL_REQUEST', FALSE);

2791: if ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2792: fnd_message.set_name ('FND', 'SQL-Generic error');
2793: fnd_message.set_token ('ERRNO', sqlcode, FALSE);
2794: fnd_message.set_token ('REASON', sqlerrm, FALSE);
2795: fnd_message.set_token ('ROUTINE', 'FND_CONCURRENT.INIT_SQL_REQUEST', FALSE);
2796: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
2797: 'fnd.plsql.FND_CONCURRENT.INIT_SQL_REQUEST.others', FALSE);
2798: end if;
2799: end;