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.PSP_ER_AME dependencies on FND_MESSAGE

Line 1100: fnd_message.set_name('PSP','PSP_ER_AME_WRONG_APR_TYP');

1096: close er_PTA_cur;
1097: if (er_PTA_rec.project_id is null and approval_type_rec.approval_type = 'PMG') or
1098: (er_PTA_rec.award_id is null and approval_type_rec.approval_type = 'GPI') or
1099: (er_PTA_rec.task_id is null and approval_type_rec.approval_type = 'TMG') then
1100: fnd_message.set_name('PSP','PSP_ER_AME_WRONG_APR_TYP');
1101: l_incorrect_apr_type_msg := substr(fnd_message.get,1,2000);
1102: end if;
1103: end if;
1104: hr_utility.trace('psperamb--> POPULATE ERROR p_approval_type ='|| p_approval_type ||

Line 1101: l_incorrect_apr_type_msg := substr(fnd_message.get,1,2000);

1097: if (er_PTA_rec.project_id is null and approval_type_rec.approval_type = 'PMG') or
1098: (er_PTA_rec.award_id is null and approval_type_rec.approval_type = 'GPI') or
1099: (er_PTA_rec.task_id is null and approval_type_rec.approval_type = 'TMG') then
1100: fnd_message.set_name('PSP','PSP_ER_AME_WRONG_APR_TYP');
1101: l_incorrect_apr_type_msg := substr(fnd_message.get,1,2000);
1102: end if;
1103: end if;
1104: hr_utility.trace('psperamb--> POPULATE ERROR p_approval_type ='|| p_approval_type ||
1105: ', p_sup_levels ='|| p_sup_levels ||

Line 1116: fnd_message.set_name('PSP','PSP_ER_AME_EMP_APPRV_ERR');

1112: ', p_request_id =' || p_request_id);
1113:
1114:
1115: if approval_type_rec.approval_type = 'EMP' then
1116: fnd_message.set_name('PSP','PSP_ER_AME_EMP_APPRV_ERR');
1117: fnd_message.set_token('Error',p_sqlerrm);
1118: l_err_mesg := substr(fnd_message.get,1,2000);
1119: insert_error(p_request_id, 'E', p_group_attribute, l_err_mesg, p_retry_request_id);
1120: elsif approval_type_rec.approval_type = 'ESU' then

Line 1117: fnd_message.set_token('Error',p_sqlerrm);

1113:
1114:
1115: if approval_type_rec.approval_type = 'EMP' then
1116: fnd_message.set_name('PSP','PSP_ER_AME_EMP_APPRV_ERR');
1117: fnd_message.set_token('Error',p_sqlerrm);
1118: l_err_mesg := substr(fnd_message.get,1,2000);
1119: insert_error(p_request_id, 'E', p_group_attribute, l_err_mesg, p_retry_request_id);
1120: elsif approval_type_rec.approval_type = 'ESU' then
1121: fnd_message.set_name('PSP','PSP_ER_AME_ESU_APPRV_ERR');

Line 1118: l_err_mesg := substr(fnd_message.get,1,2000);

1114:
1115: if approval_type_rec.approval_type = 'EMP' then
1116: fnd_message.set_name('PSP','PSP_ER_AME_EMP_APPRV_ERR');
1117: fnd_message.set_token('Error',p_sqlerrm);
1118: l_err_mesg := substr(fnd_message.get,1,2000);
1119: insert_error(p_request_id, 'E', p_group_attribute, l_err_mesg, p_retry_request_id);
1120: elsif approval_type_rec.approval_type = 'ESU' then
1121: fnd_message.set_name('PSP','PSP_ER_AME_ESU_APPRV_ERR');
1122: fnd_message.set_token('Error',p_sqlerrm);

Line 1121: fnd_message.set_name('PSP','PSP_ER_AME_ESU_APPRV_ERR');

1117: fnd_message.set_token('Error',p_sqlerrm);
1118: l_err_mesg := substr(fnd_message.get,1,2000);
1119: insert_error(p_request_id, 'E', p_group_attribute, l_err_mesg, p_retry_request_id);
1120: elsif approval_type_rec.approval_type = 'ESU' then
1121: fnd_message.set_name('PSP','PSP_ER_AME_ESU_APPRV_ERR');
1122: fnd_message.set_token('Error',p_sqlerrm);
1123: l_err_mesg := substr(fnd_message.get,1,2000);
1124: insert_error(p_request_id, 'E', p_group_attribute, l_err_mesg, p_retry_request_id);
1125: elsif approval_type_rec.approval_type = 'SUP' then

Line 1122: fnd_message.set_token('Error',p_sqlerrm);

1118: l_err_mesg := substr(fnd_message.get,1,2000);
1119: insert_error(p_request_id, 'E', p_group_attribute, l_err_mesg, p_retry_request_id);
1120: elsif approval_type_rec.approval_type = 'ESU' then
1121: fnd_message.set_name('PSP','PSP_ER_AME_ESU_APPRV_ERR');
1122: fnd_message.set_token('Error',p_sqlerrm);
1123: l_err_mesg := substr(fnd_message.get,1,2000);
1124: insert_error(p_request_id, 'E', p_group_attribute, l_err_mesg, p_retry_request_id);
1125: elsif approval_type_rec.approval_type = 'SUP' then
1126: fnd_message.set_name('PSP','PSP_ER_AME_SUP_APPRV_ERR');

Line 1123: l_err_mesg := substr(fnd_message.get,1,2000);

1119: insert_error(p_request_id, 'E', p_group_attribute, l_err_mesg, p_retry_request_id);
1120: elsif approval_type_rec.approval_type = 'ESU' then
1121: fnd_message.set_name('PSP','PSP_ER_AME_ESU_APPRV_ERR');
1122: fnd_message.set_token('Error',p_sqlerrm);
1123: l_err_mesg := substr(fnd_message.get,1,2000);
1124: insert_error(p_request_id, 'E', p_group_attribute, l_err_mesg, p_retry_request_id);
1125: elsif approval_type_rec.approval_type = 'SUP' then
1126: fnd_message.set_name('PSP','PSP_ER_AME_SUP_APPRV_ERR');
1127: fnd_message.set_token('Error',p_sqlerrm);

Line 1126: fnd_message.set_name('PSP','PSP_ER_AME_SUP_APPRV_ERR');

1122: fnd_message.set_token('Error',p_sqlerrm);
1123: l_err_mesg := substr(fnd_message.get,1,2000);
1124: insert_error(p_request_id, 'E', p_group_attribute, l_err_mesg, p_retry_request_id);
1125: elsif approval_type_rec.approval_type = 'SUP' then
1126: fnd_message.set_name('PSP','PSP_ER_AME_SUP_APPRV_ERR');
1127: fnd_message.set_token('Error',p_sqlerrm);
1128: l_err_mesg := substr(fnd_message.get,1,2000);
1129: open get_supervisor_1_emps;
1130: fetch get_supervisor_1_emps bulk collect into t_source_id;

Line 1127: fnd_message.set_token('Error',p_sqlerrm);

1123: l_err_mesg := substr(fnd_message.get,1,2000);
1124: insert_error(p_request_id, 'E', p_group_attribute, l_err_mesg, p_retry_request_id);
1125: elsif approval_type_rec.approval_type = 'SUP' then
1126: fnd_message.set_name('PSP','PSP_ER_AME_SUP_APPRV_ERR');
1127: fnd_message.set_token('Error',p_sqlerrm);
1128: l_err_mesg := substr(fnd_message.get,1,2000);
1129: open get_supervisor_1_emps;
1130: fetch get_supervisor_1_emps bulk collect into t_source_id;
1131: close get_supervisor_1_emps;

Line 1128: l_err_mesg := substr(fnd_message.get,1,2000);

1124: insert_error(p_request_id, 'E', p_group_attribute, l_err_mesg, p_retry_request_id);
1125: elsif approval_type_rec.approval_type = 'SUP' then
1126: fnd_message.set_name('PSP','PSP_ER_AME_SUP_APPRV_ERR');
1127: fnd_message.set_token('Error',p_sqlerrm);
1128: l_err_mesg := substr(fnd_message.get,1,2000);
1129: open get_supervisor_1_emps;
1130: fetch get_supervisor_1_emps bulk collect into t_source_id;
1131: close get_supervisor_1_emps;
1132: if t_source_id.count > 0 then

Line 1157: fnd_message.set_name('PSP','PSP_ER_AME_TMG_APPRV_ERR');

1153: if l_incorrect_apr_type_msg is not null then
1154: t_err_mesg(i) := l_incorrect_apr_type_msg;
1155: t_source_id(i) := task_rec.person_id;
1156: else
1157: fnd_message.set_name('PSP','PSP_ER_AME_TMG_APPRV_ERR');
1158: fnd_message.set_token('TASK_NUMBER',task_rec.task_number);
1159: fnd_message.set_token('ASG_NUMBER',task_rec.assignment_number);
1160: fnd_message.set_token('Error',p_sqlerrm);
1161: l_err_mesg := substr(fnd_message.get,1,2000);

Line 1158: fnd_message.set_token('TASK_NUMBER',task_rec.task_number);

1154: t_err_mesg(i) := l_incorrect_apr_type_msg;
1155: t_source_id(i) := task_rec.person_id;
1156: else
1157: fnd_message.set_name('PSP','PSP_ER_AME_TMG_APPRV_ERR');
1158: fnd_message.set_token('TASK_NUMBER',task_rec.task_number);
1159: fnd_message.set_token('ASG_NUMBER',task_rec.assignment_number);
1160: fnd_message.set_token('Error',p_sqlerrm);
1161: l_err_mesg := substr(fnd_message.get,1,2000);
1162: t_source_id(i) := task_rec.person_id;

Line 1159: fnd_message.set_token('ASG_NUMBER',task_rec.assignment_number);

1155: t_source_id(i) := task_rec.person_id;
1156: else
1157: fnd_message.set_name('PSP','PSP_ER_AME_TMG_APPRV_ERR');
1158: fnd_message.set_token('TASK_NUMBER',task_rec.task_number);
1159: fnd_message.set_token('ASG_NUMBER',task_rec.assignment_number);
1160: fnd_message.set_token('Error',p_sqlerrm);
1161: l_err_mesg := substr(fnd_message.get,1,2000);
1162: t_source_id(i) := task_rec.person_id;
1163: t_err_mesg(i) := l_err_mesg;

Line 1160: fnd_message.set_token('Error',p_sqlerrm);

1156: else
1157: fnd_message.set_name('PSP','PSP_ER_AME_TMG_APPRV_ERR');
1158: fnd_message.set_token('TASK_NUMBER',task_rec.task_number);
1159: fnd_message.set_token('ASG_NUMBER',task_rec.assignment_number);
1160: fnd_message.set_token('Error',p_sqlerrm);
1161: l_err_mesg := substr(fnd_message.get,1,2000);
1162: t_source_id(i) := task_rec.person_id;
1163: t_err_mesg(i) := l_err_mesg;
1164: end if;

Line 1161: l_err_mesg := substr(fnd_message.get,1,2000);

1157: fnd_message.set_name('PSP','PSP_ER_AME_TMG_APPRV_ERR');
1158: fnd_message.set_token('TASK_NUMBER',task_rec.task_number);
1159: fnd_message.set_token('ASG_NUMBER',task_rec.assignment_number);
1160: fnd_message.set_token('Error',p_sqlerrm);
1161: l_err_mesg := substr(fnd_message.get,1,2000);
1162: t_source_id(i) := task_rec.person_id;
1163: t_err_mesg(i) := l_err_mesg;
1164: end if;
1165: i := i + 1;

Line 1186: fnd_message.set_name('PSP','PSP_ER_AME_PMG_APPRV_ERR');

1182: if l_incorrect_apr_type_msg is not null then
1183: t_err_mesg(i) := l_incorrect_apr_type_msg;
1184: t_source_id(i) := project_rec.person_id;
1185: else
1186: fnd_message.set_name('PSP','PSP_ER_AME_PMG_APPRV_ERR');
1187: fnd_message.set_token('PROJECT_NUMBER',project_rec.project_number);
1188: fnd_message.set_token('ASG_NUMBER',project_rec.assignment_number);
1189: fnd_message.set_token('Error',p_sqlerrm);
1190: l_err_mesg := substr(fnd_message.get,1,2000);

Line 1187: fnd_message.set_token('PROJECT_NUMBER',project_rec.project_number);

1183: t_err_mesg(i) := l_incorrect_apr_type_msg;
1184: t_source_id(i) := project_rec.person_id;
1185: else
1186: fnd_message.set_name('PSP','PSP_ER_AME_PMG_APPRV_ERR');
1187: fnd_message.set_token('PROJECT_NUMBER',project_rec.project_number);
1188: fnd_message.set_token('ASG_NUMBER',project_rec.assignment_number);
1189: fnd_message.set_token('Error',p_sqlerrm);
1190: l_err_mesg := substr(fnd_message.get,1,2000);
1191: t_source_id(i) := project_rec.person_id;

Line 1188: fnd_message.set_token('ASG_NUMBER',project_rec.assignment_number);

1184: t_source_id(i) := project_rec.person_id;
1185: else
1186: fnd_message.set_name('PSP','PSP_ER_AME_PMG_APPRV_ERR');
1187: fnd_message.set_token('PROJECT_NUMBER',project_rec.project_number);
1188: fnd_message.set_token('ASG_NUMBER',project_rec.assignment_number);
1189: fnd_message.set_token('Error',p_sqlerrm);
1190: l_err_mesg := substr(fnd_message.get,1,2000);
1191: t_source_id(i) := project_rec.person_id;
1192: t_err_mesg(i) := l_err_mesg;

Line 1189: fnd_message.set_token('Error',p_sqlerrm);

1185: else
1186: fnd_message.set_name('PSP','PSP_ER_AME_PMG_APPRV_ERR');
1187: fnd_message.set_token('PROJECT_NUMBER',project_rec.project_number);
1188: fnd_message.set_token('ASG_NUMBER',project_rec.assignment_number);
1189: fnd_message.set_token('Error',p_sqlerrm);
1190: l_err_mesg := substr(fnd_message.get,1,2000);
1191: t_source_id(i) := project_rec.person_id;
1192: t_err_mesg(i) := l_err_mesg;
1193: end if;

Line 1190: l_err_mesg := substr(fnd_message.get,1,2000);

1186: fnd_message.set_name('PSP','PSP_ER_AME_PMG_APPRV_ERR');
1187: fnd_message.set_token('PROJECT_NUMBER',project_rec.project_number);
1188: fnd_message.set_token('ASG_NUMBER',project_rec.assignment_number);
1189: fnd_message.set_token('Error',p_sqlerrm);
1190: l_err_mesg := substr(fnd_message.get,1,2000);
1191: t_source_id(i) := project_rec.person_id;
1192: t_err_mesg(i) := l_err_mesg;
1193: end if;
1194:

Line 1213: fnd_message.set_name('PSP','PSP_ER_AME_GPI_APPRV_ERR');

1209: if l_incorrect_apr_type_msg is not null then
1210: t_err_mesg(i) := l_incorrect_apr_type_msg;
1211: t_source_id(i) := award_rec.person_id;
1212: else
1213: fnd_message.set_name('PSP','PSP_ER_AME_GPI_APPRV_ERR');
1214: fnd_message.set_token('AWARD_NUMBER',award_rec.award_number);
1215: fnd_message.set_token('ASG_NUMBER',award_rec.assignment_number);
1216: fnd_message.set_token('Error',p_sqlerrm);
1217: l_err_mesg := substr(fnd_message.get,1,2000);

Line 1214: fnd_message.set_token('AWARD_NUMBER',award_rec.award_number);

1210: t_err_mesg(i) := l_incorrect_apr_type_msg;
1211: t_source_id(i) := award_rec.person_id;
1212: else
1213: fnd_message.set_name('PSP','PSP_ER_AME_GPI_APPRV_ERR');
1214: fnd_message.set_token('AWARD_NUMBER',award_rec.award_number);
1215: fnd_message.set_token('ASG_NUMBER',award_rec.assignment_number);
1216: fnd_message.set_token('Error',p_sqlerrm);
1217: l_err_mesg := substr(fnd_message.get,1,2000);
1218: hr_utility.trace('before insert into GPI');

Line 1215: fnd_message.set_token('ASG_NUMBER',award_rec.assignment_number);

1211: t_source_id(i) := award_rec.person_id;
1212: else
1213: fnd_message.set_name('PSP','PSP_ER_AME_GPI_APPRV_ERR');
1214: fnd_message.set_token('AWARD_NUMBER',award_rec.award_number);
1215: fnd_message.set_token('ASG_NUMBER',award_rec.assignment_number);
1216: fnd_message.set_token('Error',p_sqlerrm);
1217: l_err_mesg := substr(fnd_message.get,1,2000);
1218: hr_utility.trace('before insert into GPI');
1219: t_source_id(i) := award_rec.person_id;

Line 1216: fnd_message.set_token('Error',p_sqlerrm);

1212: else
1213: fnd_message.set_name('PSP','PSP_ER_AME_GPI_APPRV_ERR');
1214: fnd_message.set_token('AWARD_NUMBER',award_rec.award_number);
1215: fnd_message.set_token('ASG_NUMBER',award_rec.assignment_number);
1216: fnd_message.set_token('Error',p_sqlerrm);
1217: l_err_mesg := substr(fnd_message.get,1,2000);
1218: hr_utility.trace('before insert into GPI');
1219: t_source_id(i) := award_rec.person_id;
1220: t_err_mesg(i) := l_err_mesg;

Line 1217: l_err_mesg := substr(fnd_message.get,1,2000);

1213: fnd_message.set_name('PSP','PSP_ER_AME_GPI_APPRV_ERR');
1214: fnd_message.set_token('AWARD_NUMBER',award_rec.award_number);
1215: fnd_message.set_token('ASG_NUMBER',award_rec.assignment_number);
1216: fnd_message.set_token('Error',p_sqlerrm);
1217: l_err_mesg := substr(fnd_message.get,1,2000);
1218: hr_utility.trace('before insert into GPI');
1219: t_source_id(i) := award_rec.person_id;
1220: t_err_mesg(i) := l_err_mesg;
1221: end if;

Line 1271: fnd_message.set_name('PSP','PSP_ER_WRNG_RPT_LAYOUT');

1267: if check_valid_prj%notfound then
1268: close check_valid_prj;
1269: exit;
1270: end if;
1271: fnd_message.set_name('PSP','PSP_ER_WRNG_RPT_LAYOUT');
1272: l_error_out := substr(fnd_message.get,1,2000);
1273: insert_error(p_request_id, 'E', l_err_person_id, l_error_out, p_retry_request_id);
1274: l_counter := l_counter + 1;
1275: end loop;

Line 1272: l_error_out := substr(fnd_message.get,1,2000);

1268: close check_valid_prj;
1269: exit;
1270: end if;
1271: fnd_message.set_name('PSP','PSP_ER_WRNG_RPT_LAYOUT');
1272: l_error_out := substr(fnd_message.get,1,2000);
1273: insert_error(p_request_id, 'E', l_err_person_id, l_error_out, p_retry_request_id);
1274: l_counter := l_counter + 1;
1275: end loop;
1276: if l_counter > 0 then

Line 1289: fnd_message.set_name('PSP','PSP_ER_WRNG_RPT_LAYOUT');

1285: if check_non_sponsered_prj%notfound then
1286: close check_non_sponsered_prj;
1287: exit;
1288: end if;
1289: fnd_message.set_name('PSP','PSP_ER_WRNG_RPT_LAYOUT');
1290: l_error_out := substr(fnd_message.get,1,2000);
1291: insert_error(p_request_id, 'E', l_err_person_id, l_error_out, p_retry_request_id);
1292: l_counter := l_counter + 1;
1293: end loop;

Line 1290: l_error_out := substr(fnd_message.get,1,2000);

1286: close check_non_sponsered_prj;
1287: exit;
1288: end if;
1289: fnd_message.set_name('PSP','PSP_ER_WRNG_RPT_LAYOUT');
1290: l_error_out := substr(fnd_message.get,1,2000);
1291: insert_error(p_request_id, 'E', l_err_person_id, l_error_out, p_retry_request_id);
1292: l_counter := l_counter + 1;
1293: end loop;
1294: end if;

Line 1377: fnd_message.set_name('PSP','PSP_ER_AME_CUST_APPRV_ERR');

1373: when others then
1374: l_sqlerrm := sqlerrm;
1375: hr_utility.trace(sqlerrm);
1376: fnd_msg_pub.add_exc_msg('PSP_ER_AME','GET_FIRST_APPROVER - AME CUSTOM ERR');
1377: fnd_message.set_name('PSP','PSP_ER_AME_CUST_APPRV_ERR');
1378: fnd_message.set_token('Error',l_sqlerrm);
1379: l_err_mesg := substr(fnd_message.get,1,2000);
1380: insert_error(p_request_id,
1381: 'E',

Line 1378: fnd_message.set_token('Error',l_sqlerrm);

1374: l_sqlerrm := sqlerrm;
1375: hr_utility.trace(sqlerrm);
1376: fnd_msg_pub.add_exc_msg('PSP_ER_AME','GET_FIRST_APPROVER - AME CUSTOM ERR');
1377: fnd_message.set_name('PSP','PSP_ER_AME_CUST_APPRV_ERR');
1378: fnd_message.set_token('Error',l_sqlerrm);
1379: l_err_mesg := substr(fnd_message.get,1,2000);
1380: insert_error(p_request_id,
1381: 'E',
1382: null ,

Line 1379: l_err_mesg := substr(fnd_message.get,1,2000);

1375: hr_utility.trace(sqlerrm);
1376: fnd_msg_pub.add_exc_msg('PSP_ER_AME','GET_FIRST_APPROVER - AME CUSTOM ERR');
1377: fnd_message.set_name('PSP','PSP_ER_AME_CUST_APPRV_ERR');
1378: fnd_message.set_token('Error',l_sqlerrm);
1379: l_err_mesg := substr(fnd_message.get,1,2000);
1380: insert_error(p_request_id,
1381: 'E',
1382: null ,
1383: l_err_mesg, p_retry_request_id);