eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FND_REQUEST dependencies on DUAL

Line 458: dual_no_rows exception;

454: insert_error exception;
455: args_insert_error exception;
456: login_insert_error exception;
457: relclass_insert_error exception;
458: dual_no_rows exception;
459: dual_too_many_rows exception;
460: nls_error exception;
461: appl_prog_error exception;
462: start_time_error exception;

Line 459: dual_too_many_rows exception;

455: args_insert_error exception;
456: login_insert_error exception;
457: relclass_insert_error exception;
458: dual_no_rows exception;
459: dual_too_many_rows exception;
460: nls_error exception;
461: appl_prog_error exception;
462: start_time_error exception;
463: already_msg exception;

Line 492: From Sys.Dual;

488: if ( (P_DEFERRED_MODE) OR (P_DEF_REQUEST_ID = 0)) then
489: begin
490: Select Fnd_Concurrent_Requests_S.nextval
491: Into cur_request_id
492: From Sys.Dual;
493: exception
494: when no_data_found then
495: raise dual_no_rows;
496: when too_many_rows then

Line 495: raise dual_no_rows;

491: Into cur_request_id
492: From Sys.Dual;
493: exception
494: when no_data_found then
495: raise dual_no_rows;
496: when too_many_rows then
497: raise dual_too_many_rows;
498: when others then
499: raise;

Line 497: raise dual_too_many_rows;

493: exception
494: when no_data_found then
495: raise dual_no_rows;
496: when too_many_rows then
497: raise dual_too_many_rows;
498: when others then
499: raise;
500: end;
501: end if;

Line 818: from dual;

814: begin
815: select substr(userenv('LANGUAGE'),1,
816: instr(userenv('LANGUAGE'), '_') -1)
817: into P_LANGUAGE
818: from dual;
819:
820: exception
821: when no_data_found then
822: raise nls_error;

Line 849: from dual;

845: instr ( userenv('LANGUAGE') , '_') + 1,
846: (instr ( userenv('LANGUAGE') , '.') - 1 -
847: instr ( userenv('LANGUAGE') , '_') ))
848: into P_TERRITORY
849: from dual;
850:
851: exception
852: when no_data_found then
853: raise nls_error;

Line 1313: From Sys.Dual;

1309: -- successful.
1310: begin
1311: Select Fnd_Logins_S.nextval
1312: Into loginid
1313: From Sys.Dual;
1314:
1315: exception
1316: when no_data_found then
1317: raise dual_no_rows;

Line 1317: raise dual_no_rows;

1313: From Sys.Dual;
1314:
1315: exception
1316: when no_data_found then
1317: raise dual_no_rows;
1318: when too_many_rows then
1319: raise dual_too_many_rows;
1320: when others then
1321: raise;

Line 1319: raise dual_too_many_rows;

1315: exception
1316: when no_data_found then
1317: raise dual_no_rows;
1318: when too_many_rows then
1319: raise dual_too_many_rows;
1320: when others then
1321: raise;
1322: end;
1323:

Line 1682: into P_REL_CLASS_ID, P_REL_CLASS_APP_ID from Sys.dual;

1678: or P_REPEAT_TIME is not null) then
1679: new_class := TRUE;
1680: begin
1681: Select FND_CONC_RELEASE_CLASSES_S.nextval, 0
1682: into P_REL_CLASS_ID, P_REL_CLASS_APP_ID from Sys.dual;
1683: exception
1684: when no_data_found then
1685: raise dual_no_rows;
1686: when too_many_rows then

Line 1685: raise dual_no_rows;

1681: Select FND_CONC_RELEASE_CLASSES_S.nextval, 0
1682: into P_REL_CLASS_ID, P_REL_CLASS_APP_ID from Sys.dual;
1683: exception
1684: when no_data_found then
1685: raise dual_no_rows;
1686: when too_many_rows then
1687: raise dual_too_many_rows;
1688: when others then
1689: raise;

Line 1687: raise dual_too_many_rows;

1683: exception
1684: when no_data_found then
1685: raise dual_no_rows;
1686: when too_many_rows then
1687: raise dual_too_many_rows;
1688: when others then
1689: raise;
1690: end;
1691: end if;

Line 1894: From Sys.Dual;

1890: submit.argument95, submit.argument96,
1891: submit.argument97, submit.argument98,
1892: submit.argument99, submit.argument100
1893:
1894: From Sys.Dual;
1895: end if; -- (nargs > 25)
1896:
1897: if (sql%rowcount = 0) then
1898: raise args_insert_error;

Line 2147: when dual_no_rows then

2143: fnd_message.set_name ('FND', 'CONC-RelClass insert failed');
2144: fnd_message.set_token ('APPLICATION', P_REL_CLASS_APP_ID, FALSE);
2145: fnd_message.set_token ('CLASS', P_REL_CLASS_ID, FALSE);
2146: return (0);
2147: when dual_no_rows then
2148: fnd_message.set_name ('FND', 'No Rows in Dual');
2149: return (0);
2150: when dual_too_many_rows then
2151: fnd_message.set_name ('FND', 'Too many rows in Dual');

Line 2148: fnd_message.set_name ('FND', 'No Rows in Dual');

2144: fnd_message.set_token ('APPLICATION', P_REL_CLASS_APP_ID, FALSE);
2145: fnd_message.set_token ('CLASS', P_REL_CLASS_ID, FALSE);
2146: return (0);
2147: when dual_no_rows then
2148: fnd_message.set_name ('FND', 'No Rows in Dual');
2149: return (0);
2150: when dual_too_many_rows then
2151: fnd_message.set_name ('FND', 'Too many rows in Dual');
2152: return (0);

Line 2150: when dual_too_many_rows then

2146: return (0);
2147: when dual_no_rows then
2148: fnd_message.set_name ('FND', 'No Rows in Dual');
2149: return (0);
2150: when dual_too_many_rows then
2151: fnd_message.set_name ('FND', 'Too many rows in Dual');
2152: return (0);
2153: when already_msg then
2154: return (0);

Line 2151: fnd_message.set_name ('FND', 'Too many rows in Dual');

2147: when dual_no_rows then
2148: fnd_message.set_name ('FND', 'No Rows in Dual');
2149: return (0);
2150: when dual_too_many_rows then
2151: fnd_message.set_name ('FND', 'Too many rows in Dual');
2152: return (0);
2153: when already_msg then
2154: return (0);
2155: when pp_plsql_exception then

Line 2792: From Sys.Dual;

2788: Select To_Char (fnd_conc_date.string_to_date (
2789: '01-01-0001' || repeat_time),
2790: 'HH24:MI:SS')
2791: Into P_REPEAT_TIME
2792: From Sys.Dual;
2793:
2794: elsif (repeat_interval is not NULL) then
2795: P_REPEAT_INTERVAL := repeat_interval;
2796:

Line 4302: dual_no_rows exception;

4298: --
4299: function get_fnd_debug_rules_sequence return number is
4300:
4301: l_sequence number;
4302: dual_no_rows exception;
4303: dual_too_many_rows exception;
4304:
4305: begin
4306:

Line 4303: dual_too_many_rows exception;

4299: function get_fnd_debug_rules_sequence return number is
4300:
4301: l_sequence number;
4302: dual_no_rows exception;
4303: dual_too_many_rows exception;
4304:
4305: begin
4306:
4307: begin

Line 4310: from sys.dual;

4306:
4307: begin
4308: select fnd_debug_rules_s.nextval
4309: into l_sequence
4310: from sys.dual;
4311:
4312: exception
4313: when no_data_found then
4314: raise dual_no_rows;

Line 4314: raise dual_no_rows;

4310: from sys.dual;
4311:
4312: exception
4313: when no_data_found then
4314: raise dual_no_rows;
4315: when too_many_rows then
4316: raise dual_too_many_rows;
4317: when others then
4318: raise;

Line 4316: raise dual_too_many_rows;

4312: exception
4313: when no_data_found then
4314: raise dual_no_rows;
4315: when too_many_rows then
4316: raise dual_too_many_rows;
4317: when others then
4318: raise;
4319: end;
4320:

Line 4492: into P_RELEASE_CLASS_ID, P_RELEASE_CLASS_APP_ID from Sys.dual;

4488: P_REPEAT_END_DATE := FND_CONC_DATE.STRING_TO_DATE(P_REQUESTED_END_DATE);
4489: end if;
4490:
4491: Select FND_CONC_RELEASE_CLASSES_S.nextval, 0
4492: into P_RELEASE_CLASS_ID, P_RELEASE_CLASS_APP_ID from Sys.dual;
4493:
4494: SELECT (DECODE(P_CLASS_TYPE, 'P', Decode(P_REPEAT_INTERVAL_UNIT, NULL, NULL,
4495: P_REPEAT_INTERVAL||':'||
4496: Decode(P_REPEAT_INTERVAL_UNIT,

Line 4502: 'START', 'S', 'C')), NULL)) INTO P_REPEAT_VALUE FROM SYS.DUAL;

4498: 'MONTHS', 'M',
4499: 'HOURS', 'H',
4500: 'DAYS', 'D') || ':' ||
4501: Decode(P_REPEAT_INTERVAL_TYPE,
4502: 'START', 'S', 'C')), NULL)) INTO P_REPEAT_VALUE FROM SYS.DUAL;
4503:
4504: -- Bug 6808926. Consider repeat start date as SYSDATE if null
4505:
4506: INSERT INTO FND_CONC_RELEASE_CLASSES

Line 4610: 'START', 'S', 'C')), NULL)) INTO P_REPEAT_VALUE FROM SYS.DUAL;

4606: 'MONTHS', 'M',
4607: 'HOURS', 'H',
4608: 'DAYS', 'D') || ':' ||
4609: Decode(P_REPEAT_INTERVAL_TYPE,
4610: 'START', 'S', 'C')), NULL)) INTO P_REPEAT_VALUE FROM SYS.DUAL;
4611:
4612: UPDATE FND_CONC_RELEASE_CLASSES
4613: set LAST_UPDATE_DATE = SYSDATE,
4614: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,