APPS.FND_SUBMIT dependencies on DUAL

Line 666: dual_no_rows exception;

662: style_error exception;
663: srw_style_error exception;
664: printer_styl_error exception;
665: insert_error exception;
666: dual_no_rows exception;
667: dual_too_many_rows exception;
668: nls_error exception;
669: appl_prog_error exception;
670: already_msg exception;

Line 667: dual_too_many_rows exception;

663: srw_style_error exception;
664: printer_styl_error exception;
665: insert_error exception;
666: dual_no_rows exception;
667: dual_too_many_rows exception;
668: nls_error exception;
669: appl_prog_error exception;
670: already_msg exception;
671: program_not_found exception;

Line 769: from dual;

765: begin
766: select substr(userenv('LANGUAGE'),1,
767: instr(userenv('LANGUAGE'), '_') -1)
768: into P_LANGUAGE
769: from dual;
770:
771: exception
772: when no_data_found then
773: raise nls_error;

Line 787: from dual;

783: instr ( userenv('LANGUAGE') , '_') + 1,
784: (instr ( userenv('LANGUAGE') , '.') - 1 -
785: instr ( userenv('LANGUAGE') , '_') ))
786: into P_TERRITORY
787: from dual;
788:
789: exception
790: when no_data_found then
791: raise nls_error;

Line 1170: from sys.dual;

1166: submit_program.argument97, submit_program.argument98,
1167: submit_program.argument99, submit_program.argument100,
1168: P_ORG_ID,
1169: P_NUMERIC_CHARACTERS
1170: from sys.dual;
1171:
1172: if (sql%rowcount = 0) then
1173: raise insert_error;
1174: end if;

Line 1226: when dual_no_rows then

1222: fnd_message.set_token (
1223: 'ROUTINE', 'SUBMIT_PROGRAM: insert_error2', FALSE);
1224: init_pvt_vars(TRUE);
1225: return (FALSE);
1226: when dual_no_rows then
1227: fnd_message.set_name ('FND', 'No Rows in SYS.Dual');
1228: init_pvt_vars(TRUE);
1229: return (FALSE);
1230: when dual_too_many_rows then

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

1223: 'ROUTINE', 'SUBMIT_PROGRAM: insert_error2', FALSE);
1224: init_pvt_vars(TRUE);
1225: return (FALSE);
1226: when dual_no_rows then
1227: fnd_message.set_name ('FND', 'No Rows in SYS.Dual');
1228: init_pvt_vars(TRUE);
1229: return (FALSE);
1230: when dual_too_many_rows then
1231: fnd_message.set_name ('FND', 'Too many rows in SYS.Dual');

Line 1230: when dual_too_many_rows then

1226: when dual_no_rows then
1227: fnd_message.set_name ('FND', 'No Rows in SYS.Dual');
1228: init_pvt_vars(TRUE);
1229: return (FALSE);
1230: when dual_too_many_rows then
1231: fnd_message.set_name ('FND', 'Too many rows in SYS.Dual');
1232: init_pvt_vars(TRUE);
1233: return (FALSE);
1234: when already_msg then

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

1227: fnd_message.set_name ('FND', 'No Rows in SYS.Dual');
1228: init_pvt_vars(TRUE);
1229: return (FALSE);
1230: when dual_too_many_rows then
1231: fnd_message.set_name ('FND', 'Too many rows in SYS.Dual');
1232: init_pvt_vars(TRUE);
1233: return (FALSE);
1234: when already_msg then
1235: init_pvt_vars(TRUE);