DBA Data[Home] [Help]

APPS.IGS_UC_EXT_MARVIN dependencies on FND_MESSAGE

Line 51: FND_MESSAGE.SET_NAME('IGS', 'IGS_EN_INVALID_PATH');

47: p_filename,
48: 'w');
49: EXCEPTION
50: WHEN OTHERS THEN
51: FND_MESSAGE.SET_NAME('IGS', 'IGS_EN_INVALID_PATH');
52: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
53: IGS_GE_MSG_STACK.ADD;
54: App_Exception.Raise_Exception;
55:

Line 52: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);

48: 'w');
49: EXCEPTION
50: WHEN OTHERS THEN
51: FND_MESSAGE.SET_NAME('IGS', 'IGS_EN_INVALID_PATH');
52: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
53: IGS_GE_MSG_STACK.ADD;
54: App_Exception.Raise_Exception;
55:
56: END open_file;

Line 115: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');

111: l_header := '000019*S 1 '||RPAD(p_inst_code,4)||'I'||l_date||'00000'||p_sys_ind;
112: put_line(l_header);
113:
114: EXCEPTION WHEN OTHERS THEN
115: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
116: FND_MESSAGE.SET_TOKEN('NAME','IGS_UC_EXT_MARVIN.PREPARE_HEADER'||' - '||SQLERRM);
117: IGS_GE_MSG_STACK.ADD;
118: App_Exception.Raise_Exception;
119:

Line 116: FND_MESSAGE.SET_TOKEN('NAME','IGS_UC_EXT_MARVIN.PREPARE_HEADER'||' - '||SQLERRM);

112: put_line(l_header);
113:
114: EXCEPTION WHEN OTHERS THEN
115: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
116: FND_MESSAGE.SET_TOKEN('NAME','IGS_UC_EXT_MARVIN.PREPARE_HEADER'||' - '||SQLERRM);
117: IGS_GE_MSG_STACK.ADD;
118: App_Exception.Raise_Exception;
119:
120: END prepare_header;

Line 144: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');

140: l_trailer := LPAD((l_sequence_number + 1),5,0)||'9*S 1 '||RPAD(p_inst_code,4)||'E'||l_date||LPAD(l_total_trans,5,0)||p_sys_ind;
141: put_line(l_trailer);
142:
143: EXCEPTION WHEN OTHERS THEN
144: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
145: FND_MESSAGE.SET_TOKEN('NAME','IGS_UC_EXT_MARVIN.PREPARE_TRAILER'||' - '||SQLERRM);
146: IGS_GE_MSG_STACK.ADD;
147: App_Exception.Raise_Exception;
148:

Line 145: FND_MESSAGE.SET_TOKEN('NAME','IGS_UC_EXT_MARVIN.PREPARE_TRAILER'||' - '||SQLERRM);

141: put_line(l_trailer);
142:
143: EXCEPTION WHEN OTHERS THEN
144: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
145: FND_MESSAGE.SET_TOKEN('NAME','IGS_UC_EXT_MARVIN.PREPARE_TRAILER'||' - '||SQLERRM);
146: IGS_GE_MSG_STACK.ADD;
147: App_Exception.Raise_Exception;
148:
149: END prepare_trailer;

Line 241: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');

237:
238: EXCEPTION
239: WHEN OTHERS THEN
240: p_directory := NULL ;
241: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
242: FND_MESSAGE.SET_TOKEN('NAME','IGS_UC_EXT_MARVIN.CREATE_DIRECTORY'||' - '||SQLERRM);
243: IGS_GE_MSG_STACK.ADD;
244: App_Exception.Raise_Exception;
245:

Line 242: FND_MESSAGE.SET_TOKEN('NAME','IGS_UC_EXT_MARVIN.CREATE_DIRECTORY'||' - '||SQLERRM);

238: EXCEPTION
239: WHEN OTHERS THEN
240: p_directory := NULL ;
241: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
242: FND_MESSAGE.SET_TOKEN('NAME','IGS_UC_EXT_MARVIN.CREATE_DIRECTORY'||' - '||SQLERRM);
243: IGS_GE_MSG_STACK.ADD;
244: App_Exception.Raise_Exception;
245:
246: END create_directory ;

Line 295: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');

291:
292: END IF;
293:
294: EXCEPTION WHEN OTHERS THEN
295: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
296: FND_MESSAGE.SET_TOKEN('NAME','IGS_UC_EXT_MARVIN.CHECK_SEC_LEN'||' - '||SQLERRM);
297: IGS_GE_MSG_STACK.ADD;
298: App_Exception.Raise_Exception;
299:

Line 296: FND_MESSAGE.SET_TOKEN('NAME','IGS_UC_EXT_MARVIN.CHECK_SEC_LEN'||' - '||SQLERRM);

292: END IF;
293:
294: EXCEPTION WHEN OTHERS THEN
295: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
296: FND_MESSAGE.SET_TOKEN('NAME','IGS_UC_EXT_MARVIN.CHECK_SEC_LEN'||' - '||SQLERRM);
297: IGS_GE_MSG_STACK.ADD;
298: App_Exception.Raise_Exception;
299:
300: END check_sec_len;

Line 1080: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

1076: END IF; -- End of QA Transaction
1077:
1078: EXCEPTION
1079: WHEN OTHERS THEN
1080: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1081: fnd_message.set_token('NAME','IGS_UC_EXT_MARVIN.PREPARE_DATA'||' - '||SQLERRM);
1082: igs_ge_msg_stack.ADD;
1083: app_exception.raise_exception;
1084:

Line 1081: fnd_message.set_token('NAME','IGS_UC_EXT_MARVIN.PREPARE_DATA'||' - '||SQLERRM);

1077:
1078: EXCEPTION
1079: WHEN OTHERS THEN
1080: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1081: fnd_message.set_token('NAME','IGS_UC_EXT_MARVIN.PREPARE_DATA'||' - '||SQLERRM);
1082: igs_ge_msg_stack.ADD;
1083: app_exception.raise_exception;
1084:
1085: END prepare_data;

Line 1187: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

1183: RETURN l_status;
1184:
1185: EXCEPTION
1186: WHEN OTHERS THEN
1187: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1188: fnd_message.set_token('NAME','IGS_UC_EXT_MARVIN.PENDING_TRANSACTIONS_EXIST'||' - '||SQLERRM);
1189: igs_ge_msg_stack.ADD;
1190: app_exception.raise_exception;
1191:

Line 1188: fnd_message.set_token('NAME','IGS_UC_EXT_MARVIN.PENDING_TRANSACTIONS_EXIST'||' - '||SQLERRM);

1184:
1185: EXCEPTION
1186: WHEN OTHERS THEN
1187: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1188: fnd_message.set_token('NAME','IGS_UC_EXT_MARVIN.PENDING_TRANSACTIONS_EXIST'||' - '||SQLERRM);
1189: igs_ge_msg_stack.ADD;
1190: app_exception.raise_exception;
1191:
1192: END pending_transactions_exist;

Line 1281: fnd_message.set_name('IGS','IGS_UC_CYCLE_NOT_FOUND');

1277: CLOSE ucas_cycles_cur;
1278:
1279: IF ucas_cycles_rec.configured_cycle IS NULL OR ucas_cycles_rec.current_cycle IS NULL THEN
1280:
1281: fnd_message.set_name('IGS','IGS_UC_CYCLE_NOT_FOUND');
1282: errbuf := fnd_message.get;
1283: fnd_file.put_line(fnd_file.LOG,errbuf);
1284: retcode:=2;
1285: RETURN;

Line 1282: errbuf := fnd_message.get;

1278:
1279: IF ucas_cycles_rec.configured_cycle IS NULL OR ucas_cycles_rec.current_cycle IS NULL THEN
1280:
1281: fnd_message.set_name('IGS','IGS_UC_CYCLE_NOT_FOUND');
1282: errbuf := fnd_message.get;
1283: fnd_file.put_line(fnd_file.LOG,errbuf);
1284: retcode:=2;
1285: RETURN;
1286:

Line 1302: fnd_message.set_name('IGS','IGS_UC_INV_INST_CD');

1298: --
1299: -- Error message: File cannot be created, as the mentioned Institution Code is invalid.
1300: --
1301: fnd_file.put_line(FND_FILE.LOG, ' ');
1302: fnd_message.set_name('IGS','IGS_UC_INV_INST_CD');
1303: errbuf := fnd_message.get;
1304: fnd_file.put_line(fnd_file.LOG, errbuf);
1305: retcode:=2;
1306: RETURN;

Line 1303: errbuf := fnd_message.get;

1299: -- Error message: File cannot be created, as the mentioned Institution Code is invalid.
1300: --
1301: fnd_file.put_line(FND_FILE.LOG, ' ');
1302: fnd_message.set_name('IGS','IGS_UC_INV_INST_CD');
1303: errbuf := fnd_message.get;
1304: fnd_file.put_line(fnd_file.LOG, errbuf);
1305: retcode:=2;
1306: RETURN;
1307:

Line 1313: fnd_message.set_name('IGS','IGS_UC_INV_SEQ_KEY');

1309: --
1310: -- Error message: File cannot be created, as the mentioned Security Key is invalid.
1311: --
1312: fnd_file.put_line(FND_FILE.LOG, ' ');
1313: fnd_message.set_name('IGS','IGS_UC_INV_SEQ_KEY');
1314: fnd_file.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
1315: retcode:=2;
1316: RETURN;
1317:

Line 1314: fnd_file.put_line(FND_FILE.LOG, FND_MESSAGE.GET);

1310: -- Error message: File cannot be created, as the mentioned Security Key is invalid.
1311: --
1312: fnd_file.put_line(FND_FILE.LOG, ' ');
1313: fnd_message.set_name('IGS','IGS_UC_INV_SEQ_KEY');
1314: fnd_file.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
1315: retcode:=2;
1316: RETURN;
1317:
1318: END IF;

Line 1330: fnd_message.set_name('IGS','IGS_UC_NOT_MARV');

1326: FETCH ucas_systems_cur INTO l_dummy;
1327: IF ucas_systems_cur%NOTFOUND THEN
1328:
1329: CLOSE ucas_systems_cur;
1330: fnd_message.set_name('IGS','IGS_UC_NOT_MARV');
1331: errbuf := fnd_message.get;
1332: fnd_file.put_line(FND_FILE.LOG,errbuf);
1333: retcode:=2;
1334: RETURN;

Line 1331: errbuf := fnd_message.get;

1327: IF ucas_systems_cur%NOTFOUND THEN
1328:
1329: CLOSE ucas_systems_cur;
1330: fnd_message.set_name('IGS','IGS_UC_NOT_MARV');
1331: errbuf := fnd_message.get;
1332: fnd_file.put_line(FND_FILE.LOG,errbuf);
1333: retcode:=2;
1334: RETURN;
1335:

Line 1353: fnd_message.set_name('IGS','IGS_UC_EXP_INVIAD_DIRECTORY');

1349: -- Call the local procedure to find the directory name to store the flat file
1350: create_directory ( l_directory );
1351: -- If the directory is NULL, log a message and return
1352: IF l_directory IS NULL THEN
1353: fnd_message.set_name('IGS','IGS_UC_EXP_INVIAD_DIRECTORY');
1354: errbuf := fnd_message.get;
1355: fnd_file.put_line(FND_FILE.LOG,errbuf);
1356: retcode:=2;
1357: RETURN;

Line 1354: errbuf := fnd_message.get;

1350: create_directory ( l_directory );
1351: -- If the directory is NULL, log a message and return
1352: IF l_directory IS NULL THEN
1353: fnd_message.set_name('IGS','IGS_UC_EXP_INVIAD_DIRECTORY');
1354: errbuf := fnd_message.get;
1355: fnd_file.put_line(FND_FILE.LOG,errbuf);
1356: retcode:=2;
1357: RETURN;
1358: END IF ;

Line 1369: fnd_message.set_name('IGS','IGS_UC_FILE_NAME');

1365: l_file_name := 'Afin'||l_inst_code||'.'||l_sec_key;
1366:
1367: -- Print the Flat File Name in the log file
1368: fnd_file.put_line(FND_FILE.LOG, ' ');
1369: fnd_message.set_name('IGS','IGS_UC_FILE_NAME');
1370: fnd_message.set_token('FILE_NAME', l_directory||'/'||l_file_name);
1371: fnd_file.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
1372:
1373: /******** Writing the data into the flat file ********/

Line 1370: fnd_message.set_token('FILE_NAME', l_directory||'/'||l_file_name);

1366:
1367: -- Print the Flat File Name in the log file
1368: fnd_file.put_line(FND_FILE.LOG, ' ');
1369: fnd_message.set_name('IGS','IGS_UC_FILE_NAME');
1370: fnd_message.set_token('FILE_NAME', l_directory||'/'||l_file_name);
1371: fnd_file.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
1372:
1373: /******** Writing the data into the flat file ********/
1374:

Line 1371: fnd_file.put_line(FND_FILE.LOG, FND_MESSAGE.GET);

1367: -- Print the Flat File Name in the log file
1368: fnd_file.put_line(FND_FILE.LOG, ' ');
1369: fnd_message.set_name('IGS','IGS_UC_FILE_NAME');
1370: fnd_message.set_token('FILE_NAME', l_directory||'/'||l_file_name);
1371: fnd_file.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
1372:
1373: /******** Writing the data into the flat file ********/
1374:
1375: -- Call the local procedure, open_file to open the file

Line 1404: fnd_message.set_name('IGS', 'IGS_UC_NO_PENDING_TRANS_EXIST');

1400: -- Check whether any Pending Transactions exist
1401: -- If no system have any pending transactions send to UCAS
1402: -- Display the Warning Message in the log file and exit the process
1403: IF NOT l_trans_exist THEN
1404: fnd_message.set_name('IGS', 'IGS_UC_NO_PENDING_TRANS_EXIST');
1405: errbuf := fnd_message.get;
1406: fnd_file.put_line(FND_FILE.LOG,errbuf);
1407: retcode:=1;
1408: RETURN;

Line 1405: errbuf := fnd_message.get;

1401: -- If no system have any pending transactions send to UCAS
1402: -- Display the Warning Message in the log file and exit the process
1403: IF NOT l_trans_exist THEN
1404: fnd_message.set_name('IGS', 'IGS_UC_NO_PENDING_TRANS_EXIST');
1405: errbuf := fnd_message.get;
1406: fnd_file.put_line(FND_FILE.LOG,errbuf);
1407: retcode:=1;
1408: RETURN;
1409: END IF ;

Line 1419: fnd_message.set_name('IGS', 'IGS_EN_INVALID_PATH');

1415: EXCEPTION
1416:
1417: WHEN UTL_FILE.INVALID_PATH THEN
1418: ROLLBACK TO create_file;
1419: fnd_message.set_name('IGS', 'IGS_EN_INVALID_PATH');
1420: fnd_file.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
1421:
1422: WHEN UTL_FILE.WRITE_ERROR THEN
1423: ROLLBACK TO create_file;

Line 1420: fnd_file.put_line(FND_FILE.LOG, FND_MESSAGE.GET);

1416:
1417: WHEN UTL_FILE.INVALID_PATH THEN
1418: ROLLBACK TO create_file;
1419: fnd_message.set_name('IGS', 'IGS_EN_INVALID_PATH');
1420: fnd_file.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
1421:
1422: WHEN UTL_FILE.WRITE_ERROR THEN
1423: ROLLBACK TO create_file;
1424: fnd_message.set_name('IGS', 'IGS_EN_WRITE_ERROR');

Line 1424: fnd_message.set_name('IGS', 'IGS_EN_WRITE_ERROR');

1420: fnd_file.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
1421:
1422: WHEN UTL_FILE.WRITE_ERROR THEN
1423: ROLLBACK TO create_file;
1424: fnd_message.set_name('IGS', 'IGS_EN_WRITE_ERROR');
1425: fnd_file.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
1426:
1427: WHEN UTL_FILE.INVALID_FILEHANDLE THEN
1428: ROLLBACK TO create_file;

Line 1425: fnd_file.put_line(FND_FILE.LOG, FND_MESSAGE.GET);

1421:
1422: WHEN UTL_FILE.WRITE_ERROR THEN
1423: ROLLBACK TO create_file;
1424: fnd_message.set_name('IGS', 'IGS_EN_WRITE_ERROR');
1425: fnd_file.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
1426:
1427: WHEN UTL_FILE.INVALID_FILEHANDLE THEN
1428: ROLLBACK TO create_file;
1429: fnd_message.set_name('IGS', 'IGS_EN_INVALID_FILEHANDLE');

Line 1429: fnd_message.set_name('IGS', 'IGS_EN_INVALID_FILEHANDLE');

1425: fnd_file.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
1426:
1427: WHEN UTL_FILE.INVALID_FILEHANDLE THEN
1428: ROLLBACK TO create_file;
1429: fnd_message.set_name('IGS', 'IGS_EN_INVALID_FILEHANDLE');
1430: fnd_file.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
1431:
1432: WHEN OTHERS THEN
1433: ROLLBACK;

Line 1430: fnd_file.put_line(FND_FILE.LOG, FND_MESSAGE.GET);

1426:
1427: WHEN UTL_FILE.INVALID_FILEHANDLE THEN
1428: ROLLBACK TO create_file;
1429: fnd_message.set_name('IGS', 'IGS_EN_INVALID_FILEHANDLE');
1430: fnd_file.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
1431:
1432: WHEN OTHERS THEN
1433: ROLLBACK;
1434: retcode:=2;

Line 1435: fnd_message.set_name( 'IGS','IGS_GE_UNHANDLED_EXP');

1431:
1432: WHEN OTHERS THEN
1433: ROLLBACK;
1434: retcode:=2;
1435: fnd_message.set_name( 'IGS','IGS_GE_UNHANDLED_EXP');
1436: fnd_message.set_token('NAME','IGS_UC_EXT_MARVIN.CREATE_FILE'||' - '||SQLERRM);
1437: errbuf := fnd_message.get;
1438: igs_ge_msg_stack.conc_exception_hndl;
1439:

Line 1436: fnd_message.set_token('NAME','IGS_UC_EXT_MARVIN.CREATE_FILE'||' - '||SQLERRM);

1432: WHEN OTHERS THEN
1433: ROLLBACK;
1434: retcode:=2;
1435: fnd_message.set_name( 'IGS','IGS_GE_UNHANDLED_EXP');
1436: fnd_message.set_token('NAME','IGS_UC_EXT_MARVIN.CREATE_FILE'||' - '||SQLERRM);
1437: errbuf := fnd_message.get;
1438: igs_ge_msg_stack.conc_exception_hndl;
1439:
1440: END create_file;

Line 1437: errbuf := fnd_message.get;

1433: ROLLBACK;
1434: retcode:=2;
1435: fnd_message.set_name( 'IGS','IGS_GE_UNHANDLED_EXP');
1436: fnd_message.set_token('NAME','IGS_UC_EXT_MARVIN.CREATE_FILE'||' - '||SQLERRM);
1437: errbuf := fnd_message.get;
1438: igs_ge_msg_stack.conc_exception_hndl;
1439:
1440: END create_file;
1441: