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_CREATE_EFF_REPORTS dependencies on FND_API

Line 1091: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1087:
1088:
1089: /* added this call just to see how retry works
1090:
1091: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1092:
1093:
1094: */
1095:

Line 1136: If (l_return_status = fnd_api.g_ret_sts_error) or (l_return_status = fnd_api.g_ret_sts_unexp_error) then

1132: l_profile_bg_id,
1133: l_return_status) ;
1134: hr_utility.trace('psp_create_eff_reports--> After xmlgen.copy_ptaoe_from_gl_segments');
1135:
1136: If (l_return_status = fnd_api.g_ret_sts_error) or (l_return_status = fnd_api.g_ret_sts_unexp_error) then
1137: psp_message_s.print_error(p_mode=>FND_FILE.log,
1138: p_print_header=>FND_API.G_TRUE);
1139: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1140:

Line 1138: p_print_header=>FND_API.G_TRUE);

1134: hr_utility.trace('psp_create_eff_reports--> After xmlgen.copy_ptaoe_from_gl_segments');
1135:
1136: If (l_return_status = fnd_api.g_ret_sts_error) or (l_return_status = fnd_api.g_ret_sts_unexp_error) then
1137: psp_message_s.print_error(p_mode=>FND_FILE.log,
1138: p_print_header=>FND_API.G_TRUE);
1139: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1140:
1141: END IF;
1142: END IF;

Line 1139: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1135:
1136: If (l_return_status = fnd_api.g_ret_sts_error) or (l_return_status = fnd_api.g_ret_sts_unexp_error) then
1137: psp_message_s.print_error(p_mode=>FND_FILE.log,
1138: p_print_header=>FND_API.G_TRUE);
1139: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1140:
1141: END IF;
1142: END IF;
1143: */

Line 1146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1142: END IF;
1143: */
1144:
1145: if p_warning = true then
1146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1147: end if;
1148:
1149: hr_utility.trace('psp_create_eff_reports--> After costs share API');
1150: -- fnd_file.put_line(fnd_file.log,' ===== psp_xmlgen.update_er_details');

Line 1159: If (l_return_status = fnd_api.g_ret_sts_error) or (l_return_status = fnd_api.g_ret_sts_unexp_error) then

1155: l_retry_request_id,
1156: l_return_status) ;
1157:
1158: hr_utility.trace('psp_create_eff_reports--> After xmlgen.update_er_details');
1159: If (l_return_status = fnd_api.g_ret_sts_error) or (l_return_status = fnd_api.g_ret_sts_unexp_error) then
1160: psp_message_s.print_error(p_mode=>FND_FILE.log,
1161: p_print_header=>FND_API.G_TRUE);
1162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1163:

Line 1161: p_print_header=>FND_API.G_TRUE);

1157:
1158: hr_utility.trace('psp_create_eff_reports--> After xmlgen.update_er_details');
1159: If (l_return_status = fnd_api.g_ret_sts_error) or (l_return_status = fnd_api.g_ret_sts_unexp_error) then
1160: psp_message_s.print_error(p_mode=>FND_FILE.log,
1161: p_print_header=>FND_API.G_TRUE);
1162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1163:
1164: END IF;
1165: -- fnd_file.put_line(fnd_file.log,' ===== psp_eff_report_details_api.update_eff_report_details');

Line 1162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1158: hr_utility.trace('psp_create_eff_reports--> After xmlgen.update_er_details');
1159: If (l_return_status = fnd_api.g_ret_sts_error) or (l_return_status = fnd_api.g_ret_sts_unexp_error) then
1160: psp_message_s.print_error(p_mode=>FND_FILE.log,
1161: p_print_header=>FND_API.G_TRUE);
1162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1163:
1164: END IF;
1165: -- fnd_file.put_line(fnd_file.log,' ===== psp_eff_report_details_api.update_eff_report_details');
1166:

Line 1171: If (l_return_status = fnd_api.g_ret_sts_error) or (l_return_status = fnd_api.g_ret_sts_unexp_error) then

1167:
1168: psp_xmlgen.update_grouping_category(l_start_person, l_end_person, l_request_id, l_return_status) ;
1169:
1170: hr_utility.trace('psp_create_eff_reports--> After xmlgen.update_grouping_category');
1171: If (l_return_status = fnd_api.g_ret_sts_error) or (l_return_status = fnd_api.g_ret_sts_unexp_error) then
1172: psp_message_s.print_error(p_mode=>FND_FILE.log,
1173: p_print_header=>FND_API.G_TRUE);
1174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1175: END IF;

Line 1173: p_print_header=>FND_API.G_TRUE);

1169:
1170: hr_utility.trace('psp_create_eff_reports--> After xmlgen.update_grouping_category');
1171: If (l_return_status = fnd_api.g_ret_sts_error) or (l_return_status = fnd_api.g_ret_sts_unexp_error) then
1172: psp_message_s.print_error(p_mode=>FND_FILE.log,
1173: p_print_header=>FND_API.G_TRUE);
1174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1175: END IF;
1176:
1177: -- fnd_file.put_line(fnd_file.log,' ===== psp_eff_report_details_api.update_eff_report_details');

Line 1174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1170: hr_utility.trace('psp_create_eff_reports--> After xmlgen.update_grouping_category');
1171: If (l_return_status = fnd_api.g_ret_sts_error) or (l_return_status = fnd_api.g_ret_sts_unexp_error) then
1172: psp_message_s.print_error(p_mode=>FND_FILE.log,
1173: p_print_header=>FND_API.G_TRUE);
1174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1175: END IF;
1176:
1177: -- fnd_file.put_line(fnd_file.log,' ===== psp_eff_report_details_api.update_eff_report_details');
1178:

Line 1191: If (l_return_status = fnd_api.g_ret_sts_unexp_error) or (l_return_status = fnd_api.g_ret_sts_error) then

1187: p_return_status => l_return_status) ;
1188:
1189: -- fnd_file.put_line(fnd_file.log,' ===== after ptaoe validate');
1190:
1191: If (l_return_status = fnd_api.g_ret_sts_unexp_error) or (l_return_status = fnd_api.g_ret_sts_error) then
1192: -- fnd_file.put_line(fnd_file.log,' ===== after ptaoe validate in side error');
1193:
1194: psp_message_s.print_error(p_mode=>FND_FILE.log,
1195: p_print_header=>FND_API.G_TRUE);

Line 1195: p_print_header=>FND_API.G_TRUE);

1191: If (l_return_status = fnd_api.g_ret_sts_unexp_error) or (l_return_status = fnd_api.g_ret_sts_error) then
1192: -- fnd_file.put_line(fnd_file.log,' ===== after ptaoe validate in side error');
1193:
1194: psp_message_s.print_error(p_mode=>FND_FILE.log,
1195: p_print_header=>FND_API.G_TRUE);
1196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1197: END IF;
1198:
1199: -- fnd_file.put_line(fnd_file.log,' ===== psp_er_ame.get_first_approvers');

Line 1196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1192: -- fnd_file.put_line(fnd_file.log,' ===== after ptaoe validate in side error');
1193:
1194: psp_message_s.print_error(p_mode=>FND_FILE.log,
1195: p_print_header=>FND_API.G_TRUE);
1196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1197: END IF;
1198:
1199: -- fnd_file.put_line(fnd_file.log,' ===== psp_er_ame.get_first_approvers');
1200:

Line 1212: If (l_return_status = fnd_api.g_ret_sts_unexp_error) or (l_return_status=fnd_api.g_ret_sts_error) then

1208: hr_utility.trace('psp_create_eff_reports--> After psp_er_ame.get_first_approvers');
1209:
1210:
1211:
1212: If (l_return_status = fnd_api.g_ret_sts_unexp_error) or (l_return_status=fnd_api.g_ret_sts_error) then
1213: psp_message_s.print_error(p_mode=>FND_FILE.log,
1214: p_print_header=>FND_API.G_TRUE);
1215:
1216: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1214: p_print_header=>FND_API.G_TRUE);

1210:
1211:
1212: If (l_return_status = fnd_api.g_ret_sts_unexp_error) or (l_return_status=fnd_api.g_ret_sts_error) then
1213: psp_message_s.print_error(p_mode=>FND_FILE.log,
1214: p_print_header=>FND_API.G_TRUE);
1215:
1216: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1217:
1218: END IF;

Line 1216: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1212: If (l_return_status = fnd_api.g_ret_sts_unexp_error) or (l_return_status=fnd_api.g_ret_sts_error) then
1213: psp_message_s.print_error(p_mode=>FND_FILE.log,
1214: p_print_header=>FND_API.G_TRUE);
1215:
1216: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1217:
1218: END IF;
1219:
1220: -- fnd_file.put_line(fnd_file.log,' ===== psp_xmlgen.update_er_person_xml');

Line 1230: If (l_return_status = fnd_api.g_ret_sts_error ) or (l_return_status = fnd_api.g_ret_sts_unexp_error) then

1226: l_return_status) ;
1227:
1228: hr_utility.trace('psp_create_eff_reports--> After xmlgen.update_er_person_xml');
1229:
1230: If (l_return_status = fnd_api.g_ret_sts_error ) or (l_return_status = fnd_api.g_ret_sts_unexp_error) then
1231: psp_message_s.print_error(p_mode=>FND_FILE.log,
1232: p_print_header=>FND_API.G_TRUE);
1233: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1234:

Line 1232: p_print_header=>FND_API.G_TRUE);

1228: hr_utility.trace('psp_create_eff_reports--> After xmlgen.update_er_person_xml');
1229:
1230: If (l_return_status = fnd_api.g_ret_sts_error ) or (l_return_status = fnd_api.g_ret_sts_unexp_error) then
1231: psp_message_s.print_error(p_mode=>FND_FILE.log,
1232: p_print_header=>FND_API.G_TRUE);
1233: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1234:
1235: END IF;
1236:

Line 1233: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1229:
1230: If (l_return_status = fnd_api.g_ret_sts_error ) or (l_return_status = fnd_api.g_ret_sts_unexp_error) then
1231: psp_message_s.print_error(p_mode=>FND_FILE.log,
1232: p_print_header=>FND_API.G_TRUE);
1233: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1234:
1235: END IF;
1236:
1237: END IF;

Line 1241: when FND_API.G_EXC_UNEXPECTED_ERROR then

1237: END IF;
1238: -- hr_utility.trace_off;
1239:
1240: EXCEPTION
1241: when FND_API.G_EXC_UNEXPECTED_ERROR then
1242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1243: when others then
1244: BEGIN
1245: -- hr_utility.trace('psp_create_eff_reports--> Exception '||sqlerrm);

Line 1242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1238: -- hr_utility.trace_off;
1239:
1240: EXCEPTION
1241: when FND_API.G_EXC_UNEXPECTED_ERROR then
1242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1243: when others then
1244: BEGIN
1245: -- hr_utility.trace('psp_create_eff_reports--> Exception '||sqlerrm);
1246: fnd_file.put_line(fnd_file.log,' Unhandled exception raised '||sqlerrm);

Line 1256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1252: /* Below lines added for supercedence requirement
1253: */
1254: -- hr_utility.trace_off;
1255:
1256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1257: END;
1258:
1259:
1260: END;

Line 1607: p_return_status := fnd_api.g_ret_sts_success;

1603: AND ROWNUM = 1;
1604: BEGIN
1605:
1606: l_profile_bg_id := FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID');
1607: p_return_status := fnd_api.g_ret_sts_success;
1608:
1609: OPEN layout_type_cur;
1610: FETCH layout_type_cur INTO l_layout_type;
1611: CLOSE layout_type_cur;

Line 1666: p_return_status := fnd_api.g_ret_sts_error;

1662: p_retry_request_id => p_retry_request_id,
1663: p_pdf_request_id => NULL,
1664: p_error_message => l_err_mesg,
1665: p_return_status => l_return_status);
1666: p_return_status := fnd_api.g_ret_sts_error;
1667: END IF;
1668:
1669: END LOOP;
1670: CLOSE check_ptaoe;

Line 1689: p_return_status := fnd_api.g_ret_sts_error;

1685: p_retry_request_id => p_retry_request_id,
1686: p_pdf_request_id => NULL,
1687: p_error_message => l_err_mesg,
1688: p_return_status => l_return_status);
1689: p_return_status := fnd_api.g_ret_sts_error;
1690: END LOOP;
1691: CLOSE check_award_pi_cur;
1692:
1693: ELSIF (l_layout_type = 'PMG') THEN

Line 1710: p_return_status := fnd_api.g_ret_sts_error;

1706: p_retry_request_id => p_retry_request_id,
1707: p_pdf_request_id => NULL,
1708: p_error_message => l_err_mesg,
1709: p_return_status => l_return_status);
1710: p_return_status := fnd_api.g_ret_sts_error;
1711: END LOOP;
1712: CLOSE check_pm_cur;
1713:
1714: ELSIF (l_layout_type = 'TMG') THEN

Line 1737: p_return_status := fnd_api.g_ret_sts_error;

1733: p_retry_request_id => p_retry_request_id,
1734: p_pdf_request_id => NULL,
1735: p_error_message => l_err_mesg,
1736: p_return_status => l_return_status);
1737: p_return_status := fnd_api.g_ret_sts_error;
1738: END LOOP;
1739: CLOSE check_tm_cur;
1740: ELSE
1741: OPEN check_tm_cur1;

Line 1758: p_return_status := fnd_api.g_ret_sts_error;

1754: p_retry_request_id => p_retry_request_id,
1755: p_pdf_request_id => NULL,
1756: p_error_message => l_err_mesg,
1757: p_return_status => l_return_status);
1758: p_return_status := fnd_api.g_ret_sts_error;
1759: END LOOP;
1760: CLOSE check_tm_cur1;
1761: END IF;
1762: END IF;

Line 1766: p_return_status := fnd_api.g_ret_sts_unexp_error;

1762: END IF;
1763:
1764: EXCEPTION
1765: WHEN OTHERS THEN
1766: p_return_status := fnd_api.g_ret_sts_unexp_error;
1767: END VALIDATE_PTAOE;
1768:
1769: END;