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 1093: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

Line 1140: p_print_header=>FND_API.G_TRUE);

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

Line 1141: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

Line 1163: p_print_header=>FND_API.G_TRUE);

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

Line 1164: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

Line 1175: p_print_header=>FND_API.G_TRUE);

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

Line 1176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

Line 1197: p_print_header=>FND_API.G_TRUE);

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

Line 1198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

Line 1216: p_print_header=>FND_API.G_TRUE);

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

Line 1218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

Line 1234: p_print_header=>FND_API.G_TRUE);

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

Line 1235: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1243: when FND_API.G_EXC_UNEXPECTED_ERROR then

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

Line 1244: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1258: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1609: p_return_status := fnd_api.g_ret_sts_success;

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

Line 1668: p_return_status := fnd_api.g_ret_sts_error;

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

Line 1691: p_return_status := fnd_api.g_ret_sts_error;

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

Line 1712: p_return_status := fnd_api.g_ret_sts_error;

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

Line 1739: p_return_status := fnd_api.g_ret_sts_error;

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

Line 1760: p_return_status := fnd_api.g_ret_sts_error;

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

Line 1768: p_return_status := fnd_api.g_ret_sts_unexp_error;

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