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 228: Fnd_Message.Set_Name('FND', 'CONC-Req information required');

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

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

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

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

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

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

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

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

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

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

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

Line 323: Fnd_Message.Set_Token('ROUTINE',

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

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

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

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

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

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

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

Line 352: Fnd_Message.Set_Token('ROUTINE',

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

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

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

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

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

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

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

Line 436: Fnd_Message.Set_Token('ROUTINE',

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

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

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

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

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

Line 608: Fnd_Message.Set_Token('ROUTINE',

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

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

696: elsif (upper(status) = 'ERROR') then
697: scode := 'E';
698:
699: else
700: fnd_message.set_name('FND', 'CONC-SCS BAD STATUS');
701: fnd_message.set_token('STATUS', status);
702: return FALSE;
703: end if;
704:

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

697: scode := 'E';
698:
699: else
700: fnd_message.set_name('FND', 'CONC-SCS BAD STATUS');
701: fnd_message.set_token('STATUS', status);
702: return FALSE;
703: end if;
704:
705: if ( lengthb(message) > 240 ) then

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

711: ret_str := set_status_autonomous(req_id, scode, message);
712:
713: -- if ret_str has some string that means some error otherwise return TRUE
714: if ( nvl(lengthb(ret_str), 0 ) > 0 ) then
715: Fnd_Message.Set_Name('FND', 'CP-Generic oracle error');
716: Fnd_Message.Set_Token('ERROR', ret_str, FALSE);
717: Fnd_Message.Set_Token('ROUTINE',
718: 'FND_CONCURRENT.SET_COMPLETION_STATUS', FALSE);
719: return FALSE;

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

712:
713: -- if ret_str has some string that means some error otherwise return TRUE
714: if ( nvl(lengthb(ret_str), 0 ) > 0 ) then
715: Fnd_Message.Set_Name('FND', 'CP-Generic oracle error');
716: Fnd_Message.Set_Token('ERROR', ret_str, FALSE);
717: Fnd_Message.Set_Token('ROUTINE',
718: 'FND_CONCURRENT.SET_COMPLETION_STATUS', FALSE);
719: return FALSE;
720: else

Line 717: Fnd_Message.Set_Token('ROUTINE',

713: -- if ret_str has some string that means some error otherwise return TRUE
714: if ( nvl(lengthb(ret_str), 0 ) > 0 ) then
715: Fnd_Message.Set_Name('FND', 'CP-Generic oracle error');
716: Fnd_Message.Set_Token('ERROR', ret_str, FALSE);
717: Fnd_Message.Set_Token('ROUTINE',
718: 'FND_CONCURRENT.SET_COMPLETION_STATUS', FALSE);
719: return FALSE;
720: else
721: return TRUE;

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

748:
749: exception
750: when others then
751: oraerrmesg := substr(SQLERRM, 1, 80);
752: Fnd_Message.Set_Name('FND', 'CP-Generic oracle error');
753: Fnd_Message.Set_Token('ERROR', oraerrmesg, FALSE);
754: Fnd_Message.Set_Token('ROUTINE',
755: 'FND_CONCURRENT.GET_REQUEST_PRINT_OPTIONS', FALSE);
756: return FALSE;

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

749: exception
750: when others then
751: oraerrmesg := substr(SQLERRM, 1, 80);
752: Fnd_Message.Set_Name('FND', 'CP-Generic oracle error');
753: Fnd_Message.Set_Token('ERROR', oraerrmesg, FALSE);
754: Fnd_Message.Set_Token('ROUTINE',
755: 'FND_CONCURRENT.GET_REQUEST_PRINT_OPTIONS', FALSE);
756: return FALSE;
757: end get_request_print_options;

Line 754: Fnd_Message.Set_Token('ROUTINE',

750: when others then
751: oraerrmesg := substr(SQLERRM, 1, 80);
752: Fnd_Message.Set_Name('FND', 'CP-Generic oracle error');
753: Fnd_Message.Set_Token('ERROR', oraerrmesg, FALSE);
754: Fnd_Message.Set_Token('ROUTINE',
755: 'FND_CONCURRENT.GET_REQUEST_PRINT_OPTIONS', FALSE);
756: return FALSE;
757: end get_request_print_options;
758:

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

794:
795: exception
796: when others then
797: oraerrmesg := substr(SQLERRM, 1, 80);
798: Fnd_Message.Set_Name('FND', 'CP-Generic oracle error');
799: Fnd_Message.Set_Token('ERROR', oraerrmesg, FALSE);
800: Fnd_Message.Set_Token('ROUTINE',
801: 'FND_CONCURRENT.GET_REQUEST_PRINT_OPTIONS', FALSE);
802: return counter;

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

795: exception
796: when others then
797: oraerrmesg := substr(SQLERRM, 1, 80);
798: Fnd_Message.Set_Name('FND', 'CP-Generic oracle error');
799: Fnd_Message.Set_Token('ERROR', oraerrmesg, FALSE);
800: Fnd_Message.Set_Token('ROUTINE',
801: 'FND_CONCURRENT.GET_REQUEST_PRINT_OPTIONS', FALSE);
802: return counter;
803: end get_request_print_options;

Line 800: Fnd_Message.Set_Token('ROUTINE',

796: when others then
797: oraerrmesg := substr(SQLERRM, 1, 80);
798: Fnd_Message.Set_Name('FND', 'CP-Generic oracle error');
799: Fnd_Message.Set_Token('ERROR', oraerrmesg, FALSE);
800: Fnd_Message.Set_Token('ROUTINE',
801: 'FND_CONCURRENT.GET_REQUEST_PRINT_OPTIONS', FALSE);
802: return counter;
803: end get_request_print_options;
804:

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

841: and cp.concurrent_queue_id = cq.concurrent_queue_id
842: and cq.concurrent_queue_name = Queue_Name;
843:
844: if (Sql%NotFound) then
845: Fnd_Message.Set_Name('FND', 'CP-Need valid manager name');
846: return FALSE;
847: end if;
848: end if;
849:

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

881: return TRUE;
882:
883: when others then
884: oraerrmesg := substr(SQLERRM, 1, 80);
885: Fnd_Message.Set_Name('FND', 'CP-Generic oracle error');
886: Fnd_Message.Set_Token('ERROR', oraerrmesg, FALSE);
887: Fnd_Message.Set_Token('ROUTINE',
888: 'FND_CONCURRENT.Check_Lock_Contention', FALSE);
889: return FALSE;

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

882:
883: when others then
884: oraerrmesg := substr(SQLERRM, 1, 80);
885: Fnd_Message.Set_Name('FND', 'CP-Generic oracle error');
886: Fnd_Message.Set_Token('ERROR', oraerrmesg, FALSE);
887: Fnd_Message.Set_Token('ROUTINE',
888: 'FND_CONCURRENT.Check_Lock_Contention', FALSE);
889: return FALSE;
890:

Line 887: Fnd_Message.Set_Token('ROUTINE',

883: when others then
884: oraerrmesg := substr(SQLERRM, 1, 80);
885: Fnd_Message.Set_Name('FND', 'CP-Generic oracle error');
886: Fnd_Message.Set_Token('ERROR', oraerrmesg, FALSE);
887: Fnd_Message.Set_Token('ROUTINE',
888: 'FND_CONCURRENT.Check_Lock_Contention', FALSE);
889: return FALSE;
890:
891: end Check_Lock_Contention;

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

918: and p.concurrent_program_name = program
919: and a.application_short_name = appl_shortname;
920:
921: if (Sql%NotFound) then
922: Fnd_Message.Set_Name('FND', 'CONC-Invalid Appl/Prog combo');
923: return FALSE;
924: end if;
925:
926: return TRUE;

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

927:
928: exception
929: when others then
930: oraerrmesg := substr(SQLERRM, 1, 80);
931: Fnd_Message.Set_Name('FND', 'CP-Generic oracle error');
932: Fnd_Message.Set_Token('ERROR', oraerrmesg, FALSE);
933: Fnd_Message.Set_Token('ROUTINE',
934: 'FND_CONCURRENT.GET_PROGRAM_ATTRIBUTES', FALSE);
935: return FALSE;

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

928: exception
929: when others then
930: oraerrmesg := substr(SQLERRM, 1, 80);
931: Fnd_Message.Set_Name('FND', 'CP-Generic oracle error');
932: Fnd_Message.Set_Token('ERROR', oraerrmesg, FALSE);
933: Fnd_Message.Set_Token('ROUTINE',
934: 'FND_CONCURRENT.GET_PROGRAM_ATTRIBUTES', FALSE);
935: return FALSE;
936: end get_program_attributes;

Line 933: Fnd_Message.Set_Token('ROUTINE',

929: when others then
930: oraerrmesg := substr(SQLERRM, 1, 80);
931: Fnd_Message.Set_Name('FND', 'CP-Generic oracle error');
932: Fnd_Message.Set_Token('ERROR', oraerrmesg, FALSE);
933: Fnd_Message.Set_Token('ROUTINE',
934: 'FND_CONCURRENT.GET_PROGRAM_ATTRIBUTES', FALSE);
935: return FALSE;
936: end get_program_attributes;
937:

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

1105:
1106: exception
1107: when others then
1108: oraerrmesg := substr(SQLERRM, 1, 80);
1109: Fnd_Message.Set_Name('FND', 'CP-Generic oracle error');
1110: Fnd_Message.Set_Token('ERROR', oraerrmesg, FALSE);
1111: Fnd_Message.Set_Token('ROUTINE',
1112: 'FND_CONCURRENT.INIT_REQUEST', FALSE);
1113: return;

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

1106: exception
1107: when others then
1108: oraerrmesg := substr(SQLERRM, 1, 80);
1109: Fnd_Message.Set_Name('FND', 'CP-Generic oracle error');
1110: Fnd_Message.Set_Token('ERROR', oraerrmesg, FALSE);
1111: Fnd_Message.Set_Token('ROUTINE',
1112: 'FND_CONCURRENT.INIT_REQUEST', FALSE);
1113: return;
1114:

Line 1111: Fnd_Message.Set_Token('ROUTINE',

1107: when others then
1108: oraerrmesg := substr(SQLERRM, 1, 80);
1109: Fnd_Message.Set_Name('FND', 'CP-Generic oracle error');
1110: Fnd_Message.Set_Token('ERROR', oraerrmesg, FALSE);
1111: Fnd_Message.Set_Token('ROUTINE',
1112: 'FND_CONCURRENT.INIT_REQUEST', FALSE);
1113: return;
1114:
1115: end init_request;

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

1261: rollback to startpoint;
1262:
1263: errbuf := SQLERRM;
1264: if ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1265: fnd_message.set_name('FND', 'CONC-SHUTDOWN_ACTION_FAILURE');
1266: fnd_message.set_token('PROCEDURE', c_rec.execution_file_name);
1267: fnd_message.set_token('REASON', errbuf);
1268: fnd_log.message(FND_LOG.LEVEL_ERROR, 'fnd.plsql.fnd_concurrent.shut_down_procs', FALSE);
1269: end if;

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

1262:
1263: errbuf := SQLERRM;
1264: if ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1265: fnd_message.set_name('FND', 'CONC-SHUTDOWN_ACTION_FAILURE');
1266: fnd_message.set_token('PROCEDURE', c_rec.execution_file_name);
1267: fnd_message.set_token('REASON', errbuf);
1268: fnd_log.message(FND_LOG.LEVEL_ERROR, 'fnd.plsql.fnd_concurrent.shut_down_procs', FALSE);
1269: end if;
1270: end;

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

1263: errbuf := SQLERRM;
1264: if ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1265: fnd_message.set_name('FND', 'CONC-SHUTDOWN_ACTION_FAILURE');
1266: fnd_message.set_token('PROCEDURE', c_rec.execution_file_name);
1267: fnd_message.set_token('REASON', errbuf);
1268: fnd_log.message(FND_LOG.LEVEL_ERROR, 'fnd.plsql.fnd_concurrent.shut_down_procs', FALSE);
1269: end if;
1270: end;
1271: END LOOP;

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

1305: scode := 'E';
1306: elsif (upper(status) = 'PAUSED') then
1307: scode := 'W';
1308: else
1309: fnd_message.set_name('FND', 'CONC-SCS BAD STATUS');
1310: fnd_message.set_token('STATUS', status);
1311: return FALSE;
1312: end if;
1313:

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

1306: elsif (upper(status) = 'PAUSED') then
1307: scode := 'W';
1308: else
1309: fnd_message.set_name('FND', 'CONC-SCS BAD STATUS');
1310: fnd_message.set_token('STATUS', status);
1311: return FALSE;
1312: end if;
1313:
1314:

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

1312: end if;
1313:
1314:
1315: if ( (lengthb(message) = 0) and scode in ('G','E')) then
1316: fnd_message.set_name('FND', 'CONC-REQ RETURNED NO MESG');
1317: lmessage := fnd_message.get;
1318: elsif( (lengthb(message) = 0) and scode in ('W')) then
1319: fnd_message.set_name('FND', 'CONC_REQ REQUEST INFO');
1320: lmessage := message;

Line 1317: lmessage := fnd_message.get;

1313:
1314:
1315: if ( (lengthb(message) = 0) and scode in ('G','E')) then
1316: fnd_message.set_name('FND', 'CONC-REQ RETURNED NO MESG');
1317: lmessage := fnd_message.get;
1318: elsif( (lengthb(message) = 0) and scode in ('W')) then
1319: fnd_message.set_name('FND', 'CONC_REQ REQUEST INFO');
1320: lmessage := message;
1321: else

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

1315: if ( (lengthb(message) = 0) and scode in ('G','E')) then
1316: fnd_message.set_name('FND', 'CONC-REQ RETURNED NO MESG');
1317: lmessage := fnd_message.get;
1318: elsif( (lengthb(message) = 0) and scode in ('W')) then
1319: fnd_message.set_name('FND', 'CONC_REQ REQUEST INFO');
1320: lmessage := message;
1321: else
1322: lmessage := message;
1323: end if;

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

1331: ret_str := set_status_autonomous(req_id, scode, lmessage, TRUE);
1332:
1333: -- if ret_str has some string that means some error otherwise return TRUE
1334: if ( nvl(lengthb(ret_str), 0 ) > 0 ) then
1335: Fnd_Message.Set_Name('FND', 'CP-Generic oracle error');
1336: Fnd_Message.Set_Token('ERROR', ret_str, FALSE);
1337: Fnd_Message.Set_Token('ROUTINE',
1338: 'FND_CONCURRENT.SET_INTERIM_STATUS', FALSE);
1339: return FALSE;

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

1332:
1333: -- if ret_str has some string that means some error otherwise return TRUE
1334: if ( nvl(lengthb(ret_str), 0 ) > 0 ) then
1335: Fnd_Message.Set_Name('FND', 'CP-Generic oracle error');
1336: Fnd_Message.Set_Token('ERROR', ret_str, FALSE);
1337: Fnd_Message.Set_Token('ROUTINE',
1338: 'FND_CONCURRENT.SET_INTERIM_STATUS', FALSE);
1339: return FALSE;
1340: else

Line 1337: Fnd_Message.Set_Token('ROUTINE',

1333: -- if ret_str has some string that means some error otherwise return TRUE
1334: if ( nvl(lengthb(ret_str), 0 ) > 0 ) then
1335: Fnd_Message.Set_Name('FND', 'CP-Generic oracle error');
1336: Fnd_Message.Set_Token('ERROR', ret_str, FALSE);
1337: Fnd_Message.Set_Token('ROUTINE',
1338: 'FND_CONCURRENT.SET_INTERIM_STATUS', FALSE);
1339: return FALSE;
1340: else
1341: return TRUE;

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

1626: from FND_CP_SERVICES
1627: where SERVICE_HANDLE = upper(svc_handle);
1628: exception
1629: when no_data_found then
1630: fnd_message.set_name('FND', 'CONC-SM INVALID SVC HANDLE');
1631: fnd_message.set_token('HANDLE', svc_handle);
1632: user_error := substrb(fnd_message.get, 1, 255);
1633: raise_application_error(-20100, user_error);
1634: end;

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

1627: where SERVICE_HANDLE = upper(svc_handle);
1628: exception
1629: when no_data_found then
1630: fnd_message.set_name('FND', 'CONC-SM INVALID SVC HANDLE');
1631: fnd_message.set_token('HANDLE', svc_handle);
1632: user_error := substrb(fnd_message.get, 1, 255);
1633: raise_application_error(-20100, user_error);
1634: end;
1635:

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

1628: exception
1629: when no_data_found then
1630: fnd_message.set_name('FND', 'CONC-SM INVALID SVC HANDLE');
1631: fnd_message.set_token('HANDLE', svc_handle);
1632: user_error := substrb(fnd_message.get, 1, 255);
1633: raise_application_error(-20100, user_error);
1634: end;
1635:
1636:

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

1723: and APPLICATION_SHORT_NAME = upper(appl_short_name)
1724: and upper(CONCURRENT_QUEUE_NAME) = upper(svc_instance_name);
1725: exception
1726: when no_data_found then
1727: fnd_message.set_name('FND', 'CONC-SM INVALID SVC INSTANCE');
1728: fnd_message.set_token('APPLICATION', appl_short_name);
1729: fnd_message.set_token('INSTANCE', svc_instance_name);
1730: user_error := substrb(fnd_message.get, 1, 255);
1731: raise_application_error(-20100, user_error);

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

1724: and upper(CONCURRENT_QUEUE_NAME) = upper(svc_instance_name);
1725: exception
1726: when no_data_found then
1727: fnd_message.set_name('FND', 'CONC-SM INVALID SVC INSTANCE');
1728: fnd_message.set_token('APPLICATION', appl_short_name);
1729: fnd_message.set_token('INSTANCE', svc_instance_name);
1730: user_error := substrb(fnd_message.get, 1, 255);
1731: raise_application_error(-20100, user_error);
1732: end;

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

1725: exception
1726: when no_data_found then
1727: fnd_message.set_name('FND', 'CONC-SM INVALID SVC INSTANCE');
1728: fnd_message.set_token('APPLICATION', appl_short_name);
1729: fnd_message.set_token('INSTANCE', svc_instance_name);
1730: user_error := substrb(fnd_message.get, 1, 255);
1731: raise_application_error(-20100, user_error);
1732: end;
1733:

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

1726: when no_data_found then
1727: fnd_message.set_name('FND', 'CONC-SM INVALID SVC INSTANCE');
1728: fnd_message.set_token('APPLICATION', appl_short_name);
1729: fnd_message.set_token('INSTANCE', svc_instance_name);
1730: user_error := substrb(fnd_message.get, 1, 255);
1731: raise_application_error(-20100, user_error);
1732: end;
1733:
1734: FOR c1_rec in C1 LOOP

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

2276:
2277: exception
2278: when others then
2279: oraerrmesg := substr(SQLERRM, 1, 80);
2280: Fnd_Message.Set_Name('FND', 'CP-Generic oracle error');
2281: Fnd_Message.Set_Token('ERROR', oraerrmesg, FALSE);
2282: Fnd_Message.Set_Token('ROUTINE',
2283: 'FND_CONCURRENT.WAIT_FOR_ALL_DOWN', FALSE);
2284: return FALSE;

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

2277: exception
2278: when others then
2279: oraerrmesg := substr(SQLERRM, 1, 80);
2280: Fnd_Message.Set_Name('FND', 'CP-Generic oracle error');
2281: Fnd_Message.Set_Token('ERROR', oraerrmesg, FALSE);
2282: Fnd_Message.Set_Token('ROUTINE',
2283: 'FND_CONCURRENT.WAIT_FOR_ALL_DOWN', FALSE);
2284: return FALSE;
2285: end Wait_For_All_Down;

Line 2282: Fnd_Message.Set_Token('ROUTINE',

2278: when others then
2279: oraerrmesg := substr(SQLERRM, 1, 80);
2280: Fnd_Message.Set_Name('FND', 'CP-Generic oracle error');
2281: Fnd_Message.Set_Token('ERROR', oraerrmesg, FALSE);
2282: Fnd_Message.Set_Token('ROUTINE',
2283: 'FND_CONCURRENT.WAIT_FOR_ALL_DOWN', FALSE);
2284: return FALSE;
2285: end Wait_For_All_Down;
2286:

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

2331: when others then
2332: Detail := 'QID = ' || to_char(Arg1);
2333: end;
2334:
2335: Fnd_Message.Set_Name('FND', 'CP-MultiQC OldStyle');
2336: Fnd_Message.Set_Token('ACTION', action, FALSE);
2337: Fnd_Message.Set_Token('QUEUE', detail, FALSE);
2338: Descr := Fnd_Message.get;
2339:

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

2332: Detail := 'QID = ' || to_char(Arg1);
2333: end;
2334:
2335: Fnd_Message.Set_Name('FND', 'CP-MultiQC OldStyle');
2336: Fnd_Message.Set_Token('ACTION', action, FALSE);
2337: Fnd_Message.Set_Token('QUEUE', detail, FALSE);
2338: Descr := Fnd_Message.get;
2339:
2340: return Descr;

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

2333: end;
2334:
2335: Fnd_Message.Set_Name('FND', 'CP-MultiQC OldStyle');
2336: Fnd_Message.Set_Token('ACTION', action, FALSE);
2337: Fnd_Message.Set_Token('QUEUE', detail, FALSE);
2338: Descr := Fnd_Message.get;
2339:
2340: return Descr;
2341:

Line 2338: Descr := Fnd_Message.get;

2334:
2335: Fnd_Message.Set_Name('FND', 'CP-MultiQC OldStyle');
2336: Fnd_Message.Set_Token('ACTION', action, FALSE);
2337: Fnd_Message.Set_Token('QUEUE', detail, FALSE);
2338: Descr := Fnd_Message.get;
2339:
2340: return Descr;
2341:
2342: elsif (Arg1 = -1) then

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

2349: when others then
2350: Detail := 'APPID = ' || to_char(Arg2);
2351: end;
2352:
2353: Fnd_Message.Set_Name('FND', 'CP-MultiQC -1 ' || to_char(Arg3));
2354: Fnd_Message.Set_Token('ACTION', action, FALSE);
2355: Fnd_Message.Set_Token('APP', detail, FALSE);
2356: Descr := Fnd_Message.get;
2357:

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

2350: Detail := 'APPID = ' || to_char(Arg2);
2351: end;
2352:
2353: Fnd_Message.Set_Name('FND', 'CP-MultiQC -1 ' || to_char(Arg3));
2354: Fnd_Message.Set_Token('ACTION', action, FALSE);
2355: Fnd_Message.Set_Token('APP', detail, FALSE);
2356: Descr := Fnd_Message.get;
2357:
2358: return Descr;

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

2351: end;
2352:
2353: Fnd_Message.Set_Name('FND', 'CP-MultiQC -1 ' || to_char(Arg3));
2354: Fnd_Message.Set_Token('ACTION', action, FALSE);
2355: Fnd_Message.Set_Token('APP', detail, FALSE);
2356: Descr := Fnd_Message.get;
2357:
2358: return Descr;
2359:

Line 2356: Descr := Fnd_Message.get;

2352:
2353: Fnd_Message.Set_Name('FND', 'CP-MultiQC -1 ' || to_char(Arg3));
2354: Fnd_Message.Set_Token('ACTION', action, FALSE);
2355: Fnd_Message.Set_Token('APP', detail, FALSE);
2356: Descr := Fnd_Message.get;
2357:
2358: return Descr;
2359:
2360: elsif (Arg1 = -2) then

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

2358: return Descr;
2359:
2360: elsif (Arg1 = -2) then
2361:
2362: Fnd_Message.Set_Name('FND', 'CP-MultiQC -2');
2363: Fnd_Message.Set_Token('ACTION', action, FALSE);
2364: Descr := Fnd_Message.get;
2365:
2366: return Descr;

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

2359:
2360: elsif (Arg1 = -2) then
2361:
2362: Fnd_Message.Set_Name('FND', 'CP-MultiQC -2');
2363: Fnd_Message.Set_Token('ACTION', action, FALSE);
2364: Descr := Fnd_Message.get;
2365:
2366: return Descr;
2367:

Line 2364: Descr := Fnd_Message.get;

2360: elsif (Arg1 = -2) then
2361:
2362: Fnd_Message.Set_Name('FND', 'CP-MultiQC -2');
2363: Fnd_Message.Set_Token('ACTION', action, FALSE);
2364: Descr := Fnd_Message.get;
2365:
2366: return Descr;
2367:
2368: elsif (Arg1 = -3) then

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

2375: when others then
2376: Detail := 'SVCID = ' || to_char(Arg2);
2377: end;
2378:
2379: Fnd_Message.Set_Name('FND', 'CP-MultiQC -3');
2380: Fnd_Message.Set_Token('ACTION', action, FALSE);
2381: Fnd_Message.Set_Token('SVC', detail, FALSE);
2382: Descr := Fnd_Message.get;
2383:

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

2376: Detail := 'SVCID = ' || to_char(Arg2);
2377: end;
2378:
2379: Fnd_Message.Set_Name('FND', 'CP-MultiQC -3');
2380: Fnd_Message.Set_Token('ACTION', action, FALSE);
2381: Fnd_Message.Set_Token('SVC', detail, FALSE);
2382: Descr := Fnd_Message.get;
2383:
2384: return Descr;

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

2377: end;
2378:
2379: Fnd_Message.Set_Name('FND', 'CP-MultiQC -3');
2380: Fnd_Message.Set_Token('ACTION', action, FALSE);
2381: Fnd_Message.Set_Token('SVC', detail, FALSE);
2382: Descr := Fnd_Message.get;
2383:
2384: return Descr;
2385:

Line 2382: Descr := Fnd_Message.get;

2378:
2379: Fnd_Message.Set_Name('FND', 'CP-MultiQC -3');
2380: Fnd_Message.Set_Token('ACTION', action, FALSE);
2381: Fnd_Message.Set_Token('SVC', detail, FALSE);
2382: Descr := Fnd_Message.get;
2383:
2384: return Descr;
2385:
2386: elsif (Arg1 = -4) then

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

2384: return Descr;
2385:
2386: elsif (Arg1 = -4) then
2387:
2388: Fnd_Message.Set_Name('FND', 'CP-MultiQC -4');
2389: Fnd_Message.Set_Token('ACTION', action, FALSE);
2390: Descr := Fnd_Message.get;
2391:
2392: return Descr;

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

2385:
2386: elsif (Arg1 = -4) then
2387:
2388: Fnd_Message.Set_Name('FND', 'CP-MultiQC -4');
2389: Fnd_Message.Set_Token('ACTION', action, FALSE);
2390: Descr := Fnd_Message.get;
2391:
2392: return Descr;
2393:

Line 2390: Descr := Fnd_Message.get;

2386: elsif (Arg1 = -4) then
2387:
2388: Fnd_Message.Set_Name('FND', 'CP-MultiQC -4');
2389: Fnd_Message.Set_Token('ACTION', action, FALSE);
2390: Descr := Fnd_Message.get;
2391:
2392: return Descr;
2393:
2394:

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

2439:
2440: if ( ret_val = 0 ) then
2441: return FALSE;
2442: elsif ( ret_val = 1 ) then
2443: fnd_message.set_name('FND', 'CONC-Could not lock Request');
2444: message := fnd_message.get;
2445: return FALSE;
2446: elsif ( ret_val = 2 ) then
2447: fnd_message.set_name('FND', 'CONC-request completed');

Line 2444: message := fnd_message.get;

2440: if ( ret_val = 0 ) then
2441: return FALSE;
2442: elsif ( ret_val = 1 ) then
2443: fnd_message.set_name('FND', 'CONC-Could not lock Request');
2444: message := fnd_message.get;
2445: return FALSE;
2446: elsif ( ret_val = 2 ) then
2447: fnd_message.set_name('FND', 'CONC-request completed');
2448: message := fnd_message.get;

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

2443: fnd_message.set_name('FND', 'CONC-Could not lock Request');
2444: message := fnd_message.get;
2445: return FALSE;
2446: elsif ( ret_val = 2 ) then
2447: fnd_message.set_name('FND', 'CONC-request completed');
2448: message := fnd_message.get;
2449: return FALSE;
2450: elsif ( ret_val = 3 ) then
2451: fnd_message.set_name('FND', 'CONC-cannot cancel mgr dead');

Line 2448: message := fnd_message.get;

2444: message := fnd_message.get;
2445: return FALSE;
2446: elsif ( ret_val = 2 ) then
2447: fnd_message.set_name('FND', 'CONC-request completed');
2448: message := fnd_message.get;
2449: return FALSE;
2450: elsif ( ret_val = 3 ) then
2451: fnd_message.set_name('FND', 'CONC-cannot cancel mgr dead');
2452: message := fnd_message.get;

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

2447: fnd_message.set_name('FND', 'CONC-request completed');
2448: message := fnd_message.get;
2449: return FALSE;
2450: elsif ( ret_val = 3 ) then
2451: fnd_message.set_name('FND', 'CONC-cannot cancel mgr dead');
2452: message := fnd_message.get;
2453: return FALSE;
2454: elsif ( ret_val in (4,5)) then
2455: return TRUE;

Line 2452: message := fnd_message.get;

2448: message := fnd_message.get;
2449: return FALSE;
2450: elsif ( ret_val = 3 ) then
2451: fnd_message.set_name('FND', 'CONC-cannot cancel mgr dead');
2452: message := fnd_message.get;
2453: return FALSE;
2454: elsif ( ret_val in (4,5)) then
2455: return TRUE;
2456: end if;

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

2456: end if;
2457:
2458: exception
2459: when request_missing then
2460: fnd_message.set_name('FND', 'CONC-MISSING REQUEST');
2461: fnd_message.set_token('ROUTINE', 'FND_CONCURRENT.CANCEL_REQUEST');
2462: fnd_message.set_token('REQUEST', to_char(request_id));
2463: message := fnd_message.get;
2464: return FALSE;

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

2457:
2458: exception
2459: when request_missing then
2460: fnd_message.set_name('FND', 'CONC-MISSING REQUEST');
2461: fnd_message.set_token('ROUTINE', 'FND_CONCURRENT.CANCEL_REQUEST');
2462: fnd_message.set_token('REQUEST', to_char(request_id));
2463: message := fnd_message.get;
2464: return FALSE;
2465: when no_privilege then

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

2458: exception
2459: when request_missing then
2460: fnd_message.set_name('FND', 'CONC-MISSING REQUEST');
2461: fnd_message.set_token('ROUTINE', 'FND_CONCURRENT.CANCEL_REQUEST');
2462: fnd_message.set_token('REQUEST', to_char(request_id));
2463: message := fnd_message.get;
2464: return FALSE;
2465: when no_privilege then
2466: fnd_message.set_name('FND', 'CONC-NOT OWNER OF REQUEST');

Line 2463: message := fnd_message.get;

2459: when request_missing then
2460: fnd_message.set_name('FND', 'CONC-MISSING REQUEST');
2461: fnd_message.set_token('ROUTINE', 'FND_CONCURRENT.CANCEL_REQUEST');
2462: fnd_message.set_token('REQUEST', to_char(request_id));
2463: message := fnd_message.get;
2464: return FALSE;
2465: when no_privilege then
2466: fnd_message.set_name('FND', 'CONC-NOT OWNER OF REQUEST');
2467: fnd_message.set_token('REQUEST', to_char(request_id));

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

2462: fnd_message.set_token('REQUEST', to_char(request_id));
2463: message := fnd_message.get;
2464: return FALSE;
2465: when no_privilege then
2466: fnd_message.set_name('FND', 'CONC-NOT OWNER OF REQUEST');
2467: fnd_message.set_token('REQUEST', to_char(request_id));
2468: message := fnd_message.get;
2469: return FALSE;
2470: when others then

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

2463: message := fnd_message.get;
2464: return FALSE;
2465: when no_privilege then
2466: fnd_message.set_name('FND', 'CONC-NOT OWNER OF REQUEST');
2467: fnd_message.set_token('REQUEST', to_char(request_id));
2468: message := fnd_message.get;
2469: return FALSE;
2470: when others then
2471: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

Line 2468: message := fnd_message.get;

2464: return FALSE;
2465: when no_privilege then
2466: fnd_message.set_name('FND', 'CONC-NOT OWNER OF REQUEST');
2467: fnd_message.set_token('REQUEST', to_char(request_id));
2468: message := fnd_message.get;
2469: return FALSE;
2470: when others then
2471: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2472: fnd_message.set_token('ROUTINE', 'FND_CONCURRENT.CANCEL_REQUEST');

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

2467: fnd_message.set_token('REQUEST', to_char(request_id));
2468: message := fnd_message.get;
2469: return FALSE;
2470: when others then
2471: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2472: fnd_message.set_token('ROUTINE', 'FND_CONCURRENT.CANCEL_REQUEST');
2473: fnd_message.set_token('ERRNO', SQLCODE);
2474: fnd_message.set_token('REASON', SQLERRM);
2475: message := fnd_message.get;

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

2468: message := fnd_message.get;
2469: return FALSE;
2470: when others then
2471: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2472: fnd_message.set_token('ROUTINE', 'FND_CONCURRENT.CANCEL_REQUEST');
2473: fnd_message.set_token('ERRNO', SQLCODE);
2474: fnd_message.set_token('REASON', SQLERRM);
2475: message := fnd_message.get;
2476: return FALSE;

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

2469: return FALSE;
2470: when others then
2471: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2472: fnd_message.set_token('ROUTINE', 'FND_CONCURRENT.CANCEL_REQUEST');
2473: fnd_message.set_token('ERRNO', SQLCODE);
2474: fnd_message.set_token('REASON', SQLERRM);
2475: message := fnd_message.get;
2476: return FALSE;
2477:

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

2470: when others then
2471: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2472: fnd_message.set_token('ROUTINE', 'FND_CONCURRENT.CANCEL_REQUEST');
2473: fnd_message.set_token('ERRNO', SQLCODE);
2474: fnd_message.set_token('REASON', SQLERRM);
2475: message := fnd_message.get;
2476: return FALSE;
2477:
2478: end Cancel_Request;

Line 2475: message := fnd_message.get;

2471: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2472: fnd_message.set_token('ROUTINE', 'FND_CONCURRENT.CANCEL_REQUEST');
2473: fnd_message.set_token('ERRNO', SQLCODE);
2474: fnd_message.set_token('REASON', SQLERRM);
2475: message := fnd_message.get;
2476: return FALSE;
2477:
2478: end Cancel_Request;
2479:

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

2518: return result;
2519:
2520: exception
2521: when others then
2522: fnd_message.set_name ('FND', 'CP-Generic oracle error');
2523: fnd_message.set_token ('ERROR', substr (sqlerrm, 1, 30), FALSE);
2524: fnd_message.set_token ('ROUTINE', 'fnd_concurrent.get_resource_lock',
2525: FALSE);
2526: return result;

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

2519:
2520: exception
2521: when others then
2522: fnd_message.set_name ('FND', 'CP-Generic oracle error');
2523: fnd_message.set_token ('ERROR', substr (sqlerrm, 1, 30), FALSE);
2524: fnd_message.set_token ('ROUTINE', 'fnd_concurrent.get_resource_lock',
2525: FALSE);
2526: return result;
2527:

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

2520: exception
2521: when others then
2522: fnd_message.set_name ('FND', 'CP-Generic oracle error');
2523: fnd_message.set_token ('ERROR', substr (sqlerrm, 1, 30), FALSE);
2524: fnd_message.set_token ('ROUTINE', 'fnd_concurrent.get_resource_lock',
2525: FALSE);
2526: return result;
2527:
2528: end;

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

2560: return result;
2561:
2562: exception
2563: when others then
2564: fnd_message.set_name ('FND', 'CP-Generic oracle error');
2565: fnd_message.set_token ('ERROR', substr (sqlerrm, 1, 30), FALSE);
2566: fnd_message.set_token ('ROUTINE', 'fnd_concurrent.release_resource_lock',
2567: FALSE);
2568: return result;

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

2561:
2562: exception
2563: when others then
2564: fnd_message.set_name ('FND', 'CP-Generic oracle error');
2565: fnd_message.set_token ('ERROR', substr (sqlerrm, 1, 30), FALSE);
2566: fnd_message.set_token ('ROUTINE', 'fnd_concurrent.release_resource_lock',
2567: FALSE);
2568: return result;
2569:

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

2562: exception
2563: when others then
2564: fnd_message.set_name ('FND', 'CP-Generic oracle error');
2565: fnd_message.set_token ('ERROR', substr (sqlerrm, 1, 30), FALSE);
2566: fnd_message.set_token ('ROUTINE', 'fnd_concurrent.release_resource_lock',
2567: FALSE);
2568: return result;
2569:
2570: end;

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

2679: exception
2680: when others then
2681:
2682: if ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2683: fnd_message.set_name ('FND', 'SQL-Generic error');
2684: fnd_message.set_token ('ERRNO', sqlcode, FALSE);
2685: fnd_message.set_token ('REASON', sqlerrm, FALSE);
2686: fnd_message.set_token ('ROUTINE', 'FND_CONCURRENT.INIT_SQL_REQUEST', FALSE);
2687: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

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

2680: when others then
2681:
2682: if ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2683: fnd_message.set_name ('FND', 'SQL-Generic error');
2684: fnd_message.set_token ('ERRNO', sqlcode, FALSE);
2685: fnd_message.set_token ('REASON', sqlerrm, FALSE);
2686: fnd_message.set_token ('ROUTINE', 'FND_CONCURRENT.INIT_SQL_REQUEST', FALSE);
2687: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
2688: 'fnd.plsql.FND_CONCURRENT.INIT_SQL_REQUEST.others', FALSE);

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

2681:
2682: if ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2683: fnd_message.set_name ('FND', 'SQL-Generic error');
2684: fnd_message.set_token ('ERRNO', sqlcode, FALSE);
2685: fnd_message.set_token ('REASON', sqlerrm, FALSE);
2686: fnd_message.set_token ('ROUTINE', 'FND_CONCURRENT.INIT_SQL_REQUEST', FALSE);
2687: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
2688: 'fnd.plsql.FND_CONCURRENT.INIT_SQL_REQUEST.others', FALSE);
2689: end if;

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

2682: if ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2683: fnd_message.set_name ('FND', 'SQL-Generic error');
2684: fnd_message.set_token ('ERRNO', sqlcode, FALSE);
2685: fnd_message.set_token ('REASON', sqlerrm, FALSE);
2686: fnd_message.set_token ('ROUTINE', 'FND_CONCURRENT.INIT_SQL_REQUEST', FALSE);
2687: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
2688: 'fnd.plsql.FND_CONCURRENT.INIT_SQL_REQUEST.others', FALSE);
2689: end if;
2690: end;