DBA Data[Home] [Help]

APPS.IGS_FI_GL_INTERFACE dependencies on FND_MESSAGE

Line 1074: fnd_message.set_name('IGS',

1070: CLOSE cur_sob;
1071:
1072: -- Log the values for the parameters to the process
1073: fnd_file.put_line(fnd_file.log, ' ');
1074: fnd_message.set_name('IGS',
1075: 'IGS_FI_ANC_LOG_PARM');
1076: fnd_file.put_line(fnd_file.log,
1077: fnd_message.get);
1078:

Line 1077: fnd_message.get);

1073: fnd_file.put_line(fnd_file.log, ' ');
1074: fnd_message.set_name('IGS',
1075: 'IGS_FI_ANC_LOG_PARM');
1076: fnd_file.put_line(fnd_file.log,
1077: fnd_message.get);
1078:
1079: fnd_file.new_line(fnd_file.log);
1080: fnd_file.put_line(fnd_file.log,
1081: get_log_details('SET_OF_BOOKS',l_v_sob_name));

Line 1106: fnd_message.set_name ( 'IGS', l_v_message_name );

1102:
1103: -- Added the code here to exit from this procedure if the Receivables is not installed
1104: -- If validations of igs_fi_control fails then log the corresponding message and return.
1105: IF NOT l_b_val_parm THEN
1106: fnd_message.set_name ( 'IGS', l_v_message_name );
1107: IF l_v_message_name = 'IGS_FI_INVALID_PROCESS' THEN
1108: fnd_message.set_token('YES_NO', igs_fi_gen_gl.get_lkp_meaning('YES_NO', 'Y'));
1109: END IF;
1110: fnd_file.put_line ( fnd_file.LOG, fnd_message.get );

Line 1108: fnd_message.set_token('YES_NO', igs_fi_gen_gl.get_lkp_meaning('YES_NO', 'Y'));

1104: -- If validations of igs_fi_control fails then log the corresponding message and return.
1105: IF NOT l_b_val_parm THEN
1106: fnd_message.set_name ( 'IGS', l_v_message_name );
1107: IF l_v_message_name = 'IGS_FI_INVALID_PROCESS' THEN
1108: fnd_message.set_token('YES_NO', igs_fi_gen_gl.get_lkp_meaning('YES_NO', 'Y'));
1109: END IF;
1110: fnd_file.put_line ( fnd_file.LOG, fnd_message.get );
1111: RETURN l_b_val_parm;
1112: END IF;

Line 1110: fnd_file.put_line ( fnd_file.LOG, fnd_message.get );

1106: fnd_message.set_name ( 'IGS', l_v_message_name );
1107: IF l_v_message_name = 'IGS_FI_INVALID_PROCESS' THEN
1108: fnd_message.set_token('YES_NO', igs_fi_gen_gl.get_lkp_meaning('YES_NO', 'Y'));
1109: END IF;
1110: fnd_file.put_line ( fnd_file.LOG, fnd_message.get );
1111: RETURN l_b_val_parm;
1112: END IF;
1113:
1114: -- Check the value of Manage Accounts System Option value.

Line 1120: fnd_message.set_name ( 'IGS', l_v_message_name );

1116: l_v_message_name := NULL;
1117: igs_fi_com_rec_interface.chk_manage_account ( p_v_manage_acc => l_v_manage_accounts,
1118: p_v_message_name => l_v_message_name );
1119: IF l_v_manage_accounts IS NULL OR l_v_manage_accounts = 'OTHER' THEN
1120: fnd_message.set_name ( 'IGS', l_v_message_name );
1121: fnd_file.put_line ( fnd_file.LOG, fnd_message.get );
1122: RETURN FALSE;
1123: END IF;
1124:

Line 1121: fnd_file.put_line ( fnd_file.LOG, fnd_message.get );

1117: igs_fi_com_rec_interface.chk_manage_account ( p_v_manage_acc => l_v_manage_accounts,
1118: p_v_message_name => l_v_message_name );
1119: IF l_v_manage_accounts IS NULL OR l_v_manage_accounts = 'OTHER' THEN
1120: fnd_message.set_name ( 'IGS', l_v_message_name );
1121: fnd_file.put_line ( fnd_file.LOG, fnd_message.get );
1122: RETURN FALSE;
1123: END IF;
1124:
1125: -- If any of the parameters is NULL, then log the error in the log file

Line 1131: fnd_message.set_name('IGS','IGS_FI_PARAMETER_NULL');

1127: (p_d_gl_date_end IS NULL) OR
1128: (p_v_post_detail IS NULL) OR
1129: (p_d_gl_date_posted IS NULL) OR
1130: (p_v_jrnl_import IS NULL)) THEN
1131: fnd_message.set_name('IGS','IGS_FI_PARAMETER_NULL');
1132: fnd_file.put_line(fnd_file.log,
1133: fnd_message.get);
1134: l_b_val_parm := FALSE;
1135: END IF;

Line 1133: fnd_message.get);

1129: (p_d_gl_date_posted IS NULL) OR
1130: (p_v_jrnl_import IS NULL)) THEN
1131: fnd_message.set_name('IGS','IGS_FI_PARAMETER_NULL');
1132: fnd_file.put_line(fnd_file.log,
1133: fnd_message.get);
1134: l_b_val_parm := FALSE;
1135: END IF;
1136:
1137: -- If the GL Date start is greater than the gl date end, then log error message

Line 1140: fnd_message.set_name('IGS',

1136:
1137: -- If the GL Date start is greater than the gl date end, then log error message
1138: IF p_d_gl_date_start IS NOT NULL AND p_d_gl_date_end IS NOT NULL THEN
1139: IF TRUNC(p_d_gl_date_start) > TRUNC(p_d_gl_date_end) THEN
1140: fnd_message.set_name('IGS',
1141: 'IGS_FI_VAL_GL_END_DATE');
1142: fnd_message.set_token('START_DATE',
1143: TRUNC(p_d_gl_date_start));
1144: fnd_file.put_line(fnd_file.log,

Line 1142: fnd_message.set_token('START_DATE',

1138: IF p_d_gl_date_start IS NOT NULL AND p_d_gl_date_end IS NOT NULL THEN
1139: IF TRUNC(p_d_gl_date_start) > TRUNC(p_d_gl_date_end) THEN
1140: fnd_message.set_name('IGS',
1141: 'IGS_FI_VAL_GL_END_DATE');
1142: fnd_message.set_token('START_DATE',
1143: TRUNC(p_d_gl_date_start));
1144: fnd_file.put_line(fnd_file.log,
1145: fnd_message.get);
1146: l_b_val_parm := FALSE;

Line 1145: fnd_message.get);

1141: 'IGS_FI_VAL_GL_END_DATE');
1142: fnd_message.set_token('START_DATE',
1143: TRUNC(p_d_gl_date_start));
1144: fnd_file.put_line(fnd_file.log,
1145: fnd_message.get);
1146: l_b_val_parm := FALSE;
1147: END IF;
1148:
1149: -- If the GL Date Start and the GL Date end are not within the same Open accounting period,

Line 1156: fnd_message.set_name('IGS',

1152: p_d_gl_date_start,
1153: g_n_sob_id);
1154: FETCH cur_glp INTO l_v_period_name, l_d_end_date;
1155: IF cur_glp%NOTFOUND THEN
1156: fnd_message.set_name('IGS',
1157: 'IGS_FI_NO_OPEN_PERIOD');
1158: fnd_file.put_line(fnd_file.log,
1159: fnd_message.get);
1160: l_b_val_parm := FALSE;

Line 1159: fnd_message.get);

1155: IF cur_glp%NOTFOUND THEN
1156: fnd_message.set_name('IGS',
1157: 'IGS_FI_NO_OPEN_PERIOD');
1158: fnd_file.put_line(fnd_file.log,
1159: fnd_message.get);
1160: l_b_val_parm := FALSE;
1161: END IF;
1162: CLOSE cur_glp;
1163:

Line 1165: fnd_message.set_name('IGS',

1161: END IF;
1162: CLOSE cur_glp;
1163:
1164: IF TRUNC(l_d_end_date) < TRUNC(p_d_gl_date_end) THEN
1165: fnd_message.set_name('IGS',
1166: 'IGS_FI_VAL_GL_START_END_DATE');
1167: fnd_message.set_token('GL_START_DATE',
1168: p_d_gl_date_start);
1169: fnd_message.set_token('PERIOD',

Line 1167: fnd_message.set_token('GL_START_DATE',

1163:
1164: IF TRUNC(l_d_end_date) < TRUNC(p_d_gl_date_end) THEN
1165: fnd_message.set_name('IGS',
1166: 'IGS_FI_VAL_GL_START_END_DATE');
1167: fnd_message.set_token('GL_START_DATE',
1168: p_d_gl_date_start);
1169: fnd_message.set_token('PERIOD',
1170: l_v_period_name);
1171:

Line 1169: fnd_message.set_token('PERIOD',

1165: fnd_message.set_name('IGS',
1166: 'IGS_FI_VAL_GL_START_END_DATE');
1167: fnd_message.set_token('GL_START_DATE',
1168: p_d_gl_date_start);
1169: fnd_message.set_token('PERIOD',
1170: l_v_period_name);
1171:
1172: fnd_file.put_line(fnd_file.log,
1173: fnd_message.get);

Line 1173: fnd_message.get);

1169: fnd_message.set_token('PERIOD',
1170: l_v_period_name);
1171:
1172: fnd_file.put_line(fnd_file.log,
1173: fnd_message.get);
1174: l_b_val_parm := FALSE;
1175: END IF;
1176:
1177: l_v_period_name := NULL;

Line 1188: fnd_message.set_name('IGS',

1184: p_d_gl_date_start,
1185: g_n_sob_id);
1186: FETCH cur_glp INTO l_v_period_name, l_d_end_date;
1187: IF cur_glp%NOTFOUND THEN
1188: fnd_message.set_name('IGS',
1189: 'IGS_FI_GL_NO_OPEN_PERIOD');
1190: fnd_file.put_line(fnd_file.log,
1191: fnd_message.get);
1192: l_b_val_parm := FALSE;

Line 1191: fnd_message.get);

1187: IF cur_glp%NOTFOUND THEN
1188: fnd_message.set_name('IGS',
1189: 'IGS_FI_GL_NO_OPEN_PERIOD');
1190: fnd_file.put_line(fnd_file.log,
1191: fnd_message.get);
1192: l_b_val_parm := FALSE;
1193: END IF;
1194: CLOSE cur_glp;
1195: END IF;

Line 1198: fnd_message.set_name('IGS',

1194: CLOSE cur_glp;
1195: END IF;
1196:
1197: IF TRUNC(l_d_end_date) < TRUNC(p_d_gl_date_end) THEN
1198: fnd_message.set_name('IGS',
1199: 'IGS_FI_NO_OPEN_PERIOD_GL');
1200: l_log_line := fnd_message.get;
1201: fnd_message.set_name('IGS',
1202: 'IGS_FI_VAL_GL_START_END_DATE');

Line 1200: l_log_line := fnd_message.get;

1196:
1197: IF TRUNC(l_d_end_date) < TRUNC(p_d_gl_date_end) THEN
1198: fnd_message.set_name('IGS',
1199: 'IGS_FI_NO_OPEN_PERIOD_GL');
1200: l_log_line := fnd_message.get;
1201: fnd_message.set_name('IGS',
1202: 'IGS_FI_VAL_GL_START_END_DATE');
1203: fnd_message.set_token('GL_START_DATE',
1204: p_d_gl_date_start);

Line 1201: fnd_message.set_name('IGS',

1197: IF TRUNC(l_d_end_date) < TRUNC(p_d_gl_date_end) THEN
1198: fnd_message.set_name('IGS',
1199: 'IGS_FI_NO_OPEN_PERIOD_GL');
1200: l_log_line := fnd_message.get;
1201: fnd_message.set_name('IGS',
1202: 'IGS_FI_VAL_GL_START_END_DATE');
1203: fnd_message.set_token('GL_START_DATE',
1204: p_d_gl_date_start);
1205: fnd_message.set_token('PERIOD',

Line 1203: fnd_message.set_token('GL_START_DATE',

1199: 'IGS_FI_NO_OPEN_PERIOD_GL');
1200: l_log_line := fnd_message.get;
1201: fnd_message.set_name('IGS',
1202: 'IGS_FI_VAL_GL_START_END_DATE');
1203: fnd_message.set_token('GL_START_DATE',
1204: p_d_gl_date_start);
1205: fnd_message.set_token('PERIOD',
1206: l_v_period_name);
1207: l_log_line := l_log_line||fnd_message.get;

Line 1205: fnd_message.set_token('PERIOD',

1201: fnd_message.set_name('IGS',
1202: 'IGS_FI_VAL_GL_START_END_DATE');
1203: fnd_message.set_token('GL_START_DATE',
1204: p_d_gl_date_start);
1205: fnd_message.set_token('PERIOD',
1206: l_v_period_name);
1207: l_log_line := l_log_line||fnd_message.get;
1208: fnd_file.put_line(fnd_file.log,
1209: l_log_line);

Line 1207: l_log_line := l_log_line||fnd_message.get;

1203: fnd_message.set_token('GL_START_DATE',
1204: p_d_gl_date_start);
1205: fnd_message.set_token('PERIOD',
1206: l_v_period_name);
1207: l_log_line := l_log_line||fnd_message.get;
1208: fnd_file.put_line(fnd_file.log,
1209: l_log_line);
1210: l_b_val_parm := FALSE;
1211: END IF;

Line 1219: fnd_message.set_name('IGS',

1215: -- Validate if the parameter for Posting Detail is a valid lookup
1216: IF p_v_post_detail IS NOT NULL THEN
1217: IF NOT igs_lookups_view_pkg.get_pk_for_validation('IGS_FI_POSTING_DETAIL',
1218: p_v_post_detail) THEN
1219: fnd_message.set_name('IGS',
1220: 'IGS_FI_INV_POSTING_DETAIL');
1221: fnd_file.put_line(fnd_file.log,
1222: fnd_message.get);
1223: l_b_val_parm := FALSE;

Line 1222: fnd_message.get);

1218: p_v_post_detail) THEN
1219: fnd_message.set_name('IGS',
1220: 'IGS_FI_INV_POSTING_DETAIL');
1221: fnd_file.put_line(fnd_file.log,
1222: fnd_message.get);
1223: l_b_val_parm := FALSE;
1224: END IF;
1225: END IF;
1226: -- Validate if the Journal Import parameter is a valid Lookup

Line 1231: fnd_message.set_name('IGS',

1227:
1228: IF p_v_jrnl_import IS NOT NULL THEN
1229: IF NOT igs_lookups_view_pkg.get_pk_for_validation('YES_NO',
1230: p_v_jrnl_import) THEN
1231: fnd_message.set_name('IGS',
1232: 'IGS_FI_INV_JNL_IMPORT');
1233: fnd_file.put_line(fnd_file.log,
1234: fnd_message.get);
1235: l_b_val_parm := FALSE;

Line 1234: fnd_message.get);

1230: p_v_jrnl_import) THEN
1231: fnd_message.set_name('IGS',
1232: 'IGS_FI_INV_JNL_IMPORT');
1233: fnd_file.put_line(fnd_file.log,
1234: fnd_message.get);
1235: l_b_val_parm := FALSE;
1236: END IF;
1237: END IF;
1238:

Line 1345: fnd_message.set_name('IGS',

1341: END LOOP;
1342:
1343: fnd_file.new_line(fnd_file.log);
1344:
1345: fnd_message.set_name('IGS',
1346: 'IGS_FI_SUM_GL_TRX');
1347: fnd_file.put_line(fnd_file.log,
1348: fnd_message.get);
1349: fnd_file.put_line(fnd_file.log,

Line 1348: fnd_message.get);

1344:
1345: fnd_message.set_name('IGS',
1346: 'IGS_FI_SUM_GL_TRX');
1347: fnd_file.put_line(fnd_file.log,
1348: fnd_message.get);
1349: fnd_file.put_line(fnd_file.log,
1350: l_v_line_txt);
1351:
1352: -- Loop across the GL Interface table

Line 1385: fnd_message.set_name('IGS',

1381: get_log_details('TOT_ENT_DEBITS',l_n_dr_amnt));
1382: fnd_file.put_line(fnd_file.log,
1383: get_log_details('TOT_ENT_CREDITS',l_n_cr_amnt));
1384: ELSE
1385: fnd_message.set_name('IGS',
1386: 'IGS_GE_NO_DATA_FOUND');
1387: fnd_file.put_line(fnd_file.log,
1388: fnd_message.get);
1389: END IF;

Line 1388: fnd_message.get);

1384: ELSE
1385: fnd_message.set_name('IGS',
1386: 'IGS_GE_NO_DATA_FOUND');
1387: fnd_file.put_line(fnd_file.log,
1388: fnd_message.get);
1389: END IF;
1390: END generate_log;
1391:
1392: PROCEDURE transfer(errbuf OUT NOCOPY VARCHAR2,

Line 1428: fnd_file.put_line (fnd_file.log, fnd_message.get);

1424: l_org_id := NULL;
1425: igs_ge_gen_003.set_org_id(l_org_id);
1426: EXCEPTION
1427: WHEN OTHERS THEN
1428: fnd_file.put_line (fnd_file.log, fnd_message.get);
1429: RETCODE:=2;
1430: RETURN;
1431: END;
1432:

Line 1487: fnd_message.set_name('IGS',

1483:
1484: -- If the request id is null or 0, i.e. the request is not submitted, then
1485: -- log message indicating to the user to run the Import Journal Process manually
1486: IF ((l_n_req_id IS NULL) OR (l_n_req_id = 0))THEN
1487: fnd_message.set_name('IGS',
1488: 'IGS_FI_UNABLE_TO_SUB_GL_IMP');
1489: ELSE
1490:
1491: -- Else log the request identifier

Line 1499: fnd_message.set_name('IGS',

1495: ELSE
1496:
1497: -- Else if the run journal import parameter is No, then log a message to indicate that
1498: -- the user should manually run the Journal Import process
1499: fnd_message.set_name('IGS',
1500: 'IGS_FI_RUN_IMP_JNL');
1501: fnd_file.put_line(fnd_file.log,
1502: fnd_message.get);
1503: END IF;

Line 1502: fnd_message.get);

1498: -- the user should manually run the Journal Import process
1499: fnd_message.set_name('IGS',
1500: 'IGS_FI_RUN_IMP_JNL');
1501: fnd_file.put_line(fnd_file.log,
1502: fnd_message.get);
1503: END IF;
1504: END IF;
1505: EXCEPTION
1506: WHEN OTHERS THEN

Line 1508: fnd_message.set_name('IGS',

1504: END IF;
1505: EXCEPTION
1506: WHEN OTHERS THEN
1507: retcode := 2;
1508: fnd_message.set_name('IGS',
1509: 'IGS_GE_UNHANDLED_EXCEPTION');
1510: errbuf := fnd_message.get;
1511: fnd_file.put_line(fnd_file.log,
1512: sqlerrm);

Line 1510: errbuf := fnd_message.get;

1506: WHEN OTHERS THEN
1507: retcode := 2;
1508: fnd_message.set_name('IGS',
1509: 'IGS_GE_UNHANDLED_EXCEPTION');
1510: errbuf := fnd_message.get;
1511: fnd_file.put_line(fnd_file.log,
1512: sqlerrm);
1513: igs_ge_msg_stack.conc_exception_hndl;
1514: END transfer;