435: 'NO', 'NO', P_LANGUAGE,
436: P_TERRITORY, null, P_NUMERIC_CHARACTERS);
437:
438: if (not success) then
439: -- fnd_message.retrieve; --Implement some error message
440: -- fnd_message.error;
441: return(null);
442: end if;
443:
436: P_TERRITORY, null, P_NUMERIC_CHARACTERS);
437:
438: if (not success) then
439: -- fnd_message.retrieve; --Implement some error message
440: -- fnd_message.error;
441: return(null);
442: end if;
443:
444: if( P_MLS_LANG_FUNC_EXISTS ) then
768:
769: exception
770:
771: when start_time_error then
772: fnd_message.set_name ('FND', 'CONC-Invalid Req Start Date');
773: fnd_message.set_token ('START_DATE', requested_start, FALSE);
774: return (0);
775:
776: when no_data_found then
769: exception
770:
771: when start_time_error then
772: fnd_message.set_name ('FND', 'CONC-Invalid Req Start Date');
773: fnd_message.set_token ('START_DATE', requested_start, FALSE);
774: return (0);
775:
776: when no_data_found then
777: fnd_message.set_name ('FND', 'CONC-Invalid Appl Short Name');
773: fnd_message.set_token ('START_DATE', requested_start, FALSE);
774: return (0);
775:
776: when no_data_found then
777: fnd_message.set_name ('FND', 'CONC-Invalid Appl Short Name');
778: fnd_message.set_token ('APPLNAME', application, FALSE);
779: return (0);
780:
781: when others then
774: return (0);
775:
776: when no_data_found then
777: fnd_message.set_name ('FND', 'CONC-Invalid Appl Short Name');
778: fnd_message.set_token ('APPLNAME', application, FALSE);
779: return (0);
780:
781: when others then
782: fnd_message.set_name ('FND', 'SQL-Generic error');
778: fnd_message.set_token ('APPLNAME', application, FALSE);
779: return (0);
780:
781: when others then
782: fnd_message.set_name ('FND', 'SQL-Generic error');
783: fnd_message.set_token ('ERRNO', sqlcode, FALSE);
784: fnd_message.set_token ('REASON', sqlerrm, FALSE);
785: fnd_message.set_token (
786: 'ROUTINE', 'SUBMIT: appl_prog_error', FALSE);
779: return (0);
780:
781: when others then
782: fnd_message.set_name ('FND', 'SQL-Generic error');
783: fnd_message.set_token ('ERRNO', sqlcode, FALSE);
784: fnd_message.set_token ('REASON', sqlerrm, FALSE);
785: fnd_message.set_token (
786: 'ROUTINE', 'SUBMIT: appl_prog_error', FALSE);
787:
780:
781: when others then
782: fnd_message.set_name ('FND', 'SQL-Generic error');
783: fnd_message.set_token ('ERRNO', sqlcode, FALSE);
784: fnd_message.set_token ('REASON', sqlerrm, FALSE);
785: fnd_message.set_token (
786: 'ROUTINE', 'SUBMIT: appl_prog_error', FALSE);
787:
788: return (0);
781: when others then
782: fnd_message.set_name ('FND', 'SQL-Generic error');
783: fnd_message.set_token ('ERRNO', sqlcode, FALSE);
784: fnd_message.set_token ('REASON', sqlerrm, FALSE);
785: fnd_message.set_token (
786: 'ROUTINE', 'SUBMIT: appl_prog_error', FALSE);
787:
788: return (0);
789:
864: P_NOTIFICATIONS(n_index).on_warning := 'Y';
865: P_NOTIFICATIONS(n_index).on_error := 'Y';
866:
867: if( c1%notfound ) then
868: fnd_message.set_name('FND', 'CONC-INVALID NOTIFY USER');
869: close c1;
870: return FALSE;
871: else
872: P_NOTIFICATION_COUNT := P_NOTIFICATION_COUNT + 1;
980: return (TRUE);
981:
982: exception
983: when print_together_error then
984: fnd_message.set_name ('FND', 'CONC-Invalid opt:Print Group');
985: init_pvt_vars;
986: return (FALSE);
987:
988: when printer_error then
985: init_pvt_vars;
986: return (FALSE);
987:
988: when printer_error then
989: fnd_message.set_name ('FND', 'PRINTERS-No system printer');
990: fnd_message.set_token ('PRINTER', printer, FALSE);
991: init_pvt_vars;
992: return (FALSE);
993:
986: return (FALSE);
987:
988: when printer_error then
989: fnd_message.set_name ('FND', 'PRINTERS-No system printer');
990: fnd_message.set_token ('PRINTER', printer, FALSE);
991: init_pvt_vars;
992: return (FALSE);
993:
994: when style_error then
991: init_pvt_vars;
992: return (FALSE);
993:
994: when style_error then
995: fnd_message.set_name ('FND', 'PRT-Invalid print style');
996: fnd_message.set_token ('STYLE', P_PRINT_STYLE, FALSE);
997: init_pvt_vars;
998: return (FALSE);
999:
992: return (FALSE);
993:
994: when style_error then
995: fnd_message.set_name ('FND', 'PRT-Invalid print style');
996: fnd_message.set_token ('STYLE', P_PRINT_STYLE, FALSE);
997: init_pvt_vars;
998: return (FALSE);
999:
1000: when printer_style_error then
997: init_pvt_vars;
998: return (FALSE);
999:
1000: when printer_style_error then
1001: fnd_message.set_name ('FND', 'CONC-Invalid printer style');
1002: fnd_message.set_token ('STYLE', P_PRINT_STYLE, FALSE);
1003: fnd_message.set_token ('PRINTER', printer, FALSE);
1004: init_pvt_vars;
1005: return (FALSE);
998: return (FALSE);
999:
1000: when printer_style_error then
1001: fnd_message.set_name ('FND', 'CONC-Invalid printer style');
1002: fnd_message.set_token ('STYLE', P_PRINT_STYLE, FALSE);
1003: fnd_message.set_token ('PRINTER', printer, FALSE);
1004: init_pvt_vars;
1005: return (FALSE);
1006:
999:
1000: when printer_style_error then
1001: fnd_message.set_name ('FND', 'CONC-Invalid printer style');
1002: fnd_message.set_token ('STYLE', P_PRINT_STYLE, FALSE);
1003: fnd_message.set_token ('PRINTER', printer, FALSE);
1004: init_pvt_vars;
1005: return (FALSE);
1006:
1007: when others then
1005: return (FALSE);
1006:
1007: when others then
1008: init_pvt_vars;
1009: fnd_message.set_name ('FND', 'SQL-Generic error');
1010: fnd_message.set_token ('ERRNO', sqlcode, FALSE);
1011: fnd_message.set_token ('REASON', sqlerrm, FALSE);
1012: fnd_message.set_token ('ROUTINE', 'SET_PRINT_OPTIONS', FALSE);
1013: return (FALSE);
1006:
1007: when others then
1008: init_pvt_vars;
1009: fnd_message.set_name ('FND', 'SQL-Generic error');
1010: fnd_message.set_token ('ERRNO', sqlcode, FALSE);
1011: fnd_message.set_token ('REASON', sqlerrm, FALSE);
1012: fnd_message.set_token ('ROUTINE', 'SET_PRINT_OPTIONS', FALSE);
1013: return (FALSE);
1014:
1007: when others then
1008: init_pvt_vars;
1009: fnd_message.set_name ('FND', 'SQL-Generic error');
1010: fnd_message.set_token ('ERRNO', sqlcode, FALSE);
1011: fnd_message.set_token ('REASON', sqlerrm, FALSE);
1012: fnd_message.set_token ('ROUTINE', 'SET_PRINT_OPTIONS', FALSE);
1013: return (FALSE);
1014:
1015: end;
1008: init_pvt_vars;
1009: fnd_message.set_name ('FND', 'SQL-Generic error');
1010: fnd_message.set_token ('ERRNO', sqlcode, FALSE);
1011: fnd_message.set_token ('REASON', sqlerrm, FALSE);
1012: fnd_message.set_token ('ROUTINE', 'SET_PRINT_OPTIONS', FALSE);
1013: return (FALSE);
1014:
1015: end;
1016:
1175: return (TRUE);
1176:
1177: exception
1178: when validate_printer_error then
1179: fnd_message.set_name ('FND', 'CONC-Bad Validate Printer Parm');
1180: init_pvt_vars;
1181: return (FALSE);
1182:
1183: when print_together_error then
1180: init_pvt_vars;
1181: return (FALSE);
1182:
1183: when print_together_error then
1184: fnd_message.set_name ('FND', 'CONC-Invalid opt:Print Group');
1185: init_pvt_vars;
1186: return (FALSE);
1187:
1188: when printer_error then
1185: init_pvt_vars;
1186: return (FALSE);
1187:
1188: when printer_error then
1189: fnd_message.set_name ('FND', 'PRINTERS-No system printer');
1190: fnd_message.set_token ('PRINTER', printer, FALSE);
1191: init_pvt_vars;
1192: return (FALSE);
1193:
1186: return (FALSE);
1187:
1188: when printer_error then
1189: fnd_message.set_name ('FND', 'PRINTERS-No system printer');
1190: fnd_message.set_token ('PRINTER', printer, FALSE);
1191: init_pvt_vars;
1192: return (FALSE);
1193:
1194: when style_error then
1191: init_pvt_vars;
1192: return (FALSE);
1193:
1194: when style_error then
1195: fnd_message.set_name ('FND', 'PRT-Invalid print style');
1196: fnd_message.set_token ('STYLE', style, FALSE);
1197: init_pvt_vars;
1198: return (FALSE);
1199:
1192: return (FALSE);
1193:
1194: when style_error then
1195: fnd_message.set_name ('FND', 'PRT-Invalid print style');
1196: fnd_message.set_token ('STYLE', style, FALSE);
1197: init_pvt_vars;
1198: return (FALSE);
1199:
1200: when printer_style_error then
1197: init_pvt_vars;
1198: return (FALSE);
1199:
1200: when printer_style_error then
1201: fnd_message.set_name ('FND', 'CONC-Invalid printer style');
1202: fnd_message.set_token ('STYLE', style, FALSE);
1203: fnd_message.set_token ('PRINTER', printer, FALSE);
1204: init_pvt_vars;
1205: return (FALSE);
1198: return (FALSE);
1199:
1200: when printer_style_error then
1201: fnd_message.set_name ('FND', 'CONC-Invalid printer style');
1202: fnd_message.set_token ('STYLE', style, FALSE);
1203: fnd_message.set_token ('PRINTER', printer, FALSE);
1204: init_pvt_vars;
1205: return (FALSE);
1206:
1199:
1200: when printer_style_error then
1201: fnd_message.set_name ('FND', 'CONC-Invalid printer style');
1202: fnd_message.set_token ('STYLE', style, FALSE);
1203: fnd_message.set_token ('PRINTER', printer, FALSE);
1204: init_pvt_vars;
1205: return (FALSE);
1206:
1207: when others then
1205: return (FALSE);
1206:
1207: when others then
1208: init_pvt_vars;
1209: fnd_message.set_name ('FND', 'SQL-Generic error');
1210: fnd_message.set_token ('ERRNO', sqlcode, FALSE);
1211: fnd_message.set_token ('REASON', sqlerrm, FALSE);
1212: fnd_message.set_token ('ROUTINE', 'SET_PRINT_OPTIONS', FALSE);
1213: return (FALSE);
1206:
1207: when others then
1208: init_pvt_vars;
1209: fnd_message.set_name ('FND', 'SQL-Generic error');
1210: fnd_message.set_token ('ERRNO', sqlcode, FALSE);
1211: fnd_message.set_token ('REASON', sqlerrm, FALSE);
1212: fnd_message.set_token ('ROUTINE', 'SET_PRINT_OPTIONS', FALSE);
1213: return (FALSE);
1214: end set_print_options;
1207: when others then
1208: init_pvt_vars;
1209: fnd_message.set_name ('FND', 'SQL-Generic error');
1210: fnd_message.set_token ('ERRNO', sqlcode, FALSE);
1211: fnd_message.set_token ('REASON', sqlerrm, FALSE);
1212: fnd_message.set_token ('ROUTINE', 'SET_PRINT_OPTIONS', FALSE);
1213: return (FALSE);
1214: end set_print_options;
1215:
1208: init_pvt_vars;
1209: fnd_message.set_name ('FND', 'SQL-Generic error');
1210: fnd_message.set_token ('ERRNO', sqlcode, FALSE);
1211: fnd_message.set_token ('REASON', sqlerrm, FALSE);
1212: fnd_message.set_token ('ROUTINE', 'SET_PRINT_OPTIONS', FALSE);
1213: return (FALSE);
1214: end set_print_options;
1215:
1216:
1241: return (TRUE);
1242:
1243: exception
1244: when others then
1245: fnd_message.set_name ('FND', 'GLI-Not found');
1246: return(FALSE);
1247:
1248: end add_language;
1249:
1267: P_IMPLICIT := 'Y';
1268: elsif (upper (implicit) = 'ERROR') then
1269: P_IMPLICIT := 'E';
1270: else
1271: Fnd_Message.Set_Name ('FND', 'CONC-Bad implicit argument');
1272: init_pvt_vars;
1273: return (FALSE);
1274: end if;
1275:
1324: return (TRUE);
1325:
1326: exception
1327: when nls_error then
1328: fnd_message.set_name ('FND', 'GLI-Not found');
1329: return(FALSE);
1330:
1331: end set_options;
1332: