APPS.PSP_CREATE_EFF_REPORTS dependencies on PSP_GENERAL

Line 245: l_bg_currency_code := psp_general.get_currency_code(l_profile_bg_id);

241: ---hr_utility.trace(' COUNT of supercede persons_gt ='|| l_gt_Count);
242:
243: l_profile_sob_id := FND_PROFILE.VALUE('GL_SET_OF_BKS_ID');
244: l_profile_bg_id := FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID');
245: l_bg_currency_code := psp_general.get_currency_code(l_profile_bg_id);
246:
247:
248: --OPEN HUNDRED_PCENT_EFF_CSR(p_request_id); Commented for UVA bug fix 4537063
249: --fetch HUNDRED_PCENT_EFF_CSR into l_HUNDRED_PCENT_EFF_AT_PER_ASG, l_selection_match_level; Commented for UVA bug fix 4537063

Line 530: IF PSP_GENERAL.GET_CONFIGURATION_OPTION_VALUE(l_profile_bg_id,'PSP_USE_GL_PTAOE_MAPPING') = 'Y' THEN

526: eff_template_sum_rec.array_sum_order;
527:
528: CLOSE get_summarization_criteria;
529: -- Bug Fix 4244924:YALE ENHANCEMENTS
530: IF PSP_GENERAL.GET_CONFIGURATION_OPTION_VALUE(l_profile_bg_id,'PSP_USE_GL_PTAOE_MAPPING') = 'Y' THEN
531: PSP_GENERAL.GET_GL_PTAOE_MAPPING(p_business_group_id => l_profile_bg_id,
532: p_proj_segment => l_proj_segment,
533: p_tsk_segment => l_tsk_segment,
534: p_awd_sgement => l_awd_sgement,

Line 531: PSP_GENERAL.GET_GL_PTAOE_MAPPING(p_business_group_id => l_profile_bg_id,

527:
528: CLOSE get_summarization_criteria;
529: -- Bug Fix 4244924:YALE ENHANCEMENTS
530: IF PSP_GENERAL.GET_CONFIGURATION_OPTION_VALUE(l_profile_bg_id,'PSP_USE_GL_PTAOE_MAPPING') = 'Y' THEN
531: PSP_GENERAL.GET_GL_PTAOE_MAPPING(p_business_group_id => l_profile_bg_id,
532: p_proj_segment => l_proj_segment,
533: p_tsk_segment => l_tsk_segment,
534: p_awd_sgement => l_awd_sgement,
535: p_exp_org_segment=> l_exp_org_segment,

Line 544: IF PSP_GENERAL.GET_CONFIGURATION_OPTION_VALUE(l_profile_bg_id,'PSP_USE_GL_PTAOE_MAPPING') = 'N' THEN

540: FOR I IN 1..EFF_TEMPLATE_SUM_REC.ARRAY_SUM_CRITERIA.COUNT
541:
542: LOOP
543:
544: IF PSP_GENERAL.GET_CONFIGURATION_OPTION_VALUE(l_profile_bg_id,'PSP_USE_GL_PTAOE_MAPPING') = 'N' THEN
545: IF substr(eff_template_sum_rec.array_sum_criteria(i),1,7) = 'SEGMENT' then
546: g_exec_string:= replace(g_exec_string, 'null '||eff_template_sum_rec.array_sum_criteria(i)||',',
547: eff_template_sum_rec.array_sum_criteria(i) ||',');
548: l_select_string:= ' and psl.gl_code_combination_id = gcc.code_combination_id(+) ';

Line 1129: IF PSP_GENERAL.GET_CONFIGURATION_OPTION_VALUE(l_profile_bg_id,'PSP_USE_GL_PTAOE_MAPPING') = 'Y' THEN

1125:
1126: person_rec.array_effort_report_id.delete;
1127: person_rec.payroll_percent_tot.delete;
1128: /*
1129: IF PSP_GENERAL.GET_CONFIGURATION_OPTION_VALUE(l_profile_bg_id,'PSP_USE_GL_PTAOE_MAPPING') = 'Y' THEN
1130: psp_xmlgen.copy_ptaoe_from_gl_segments(l_start_person ,
1131: l_end_person ,
1132: l_request_id,
1133: l_retry_request_id,

Line 1252: psp_general.add_report_error(l_request_id, 'E',null, l_retry_request_id, null, l_sqlerrm,l_return_status);

1248: fnd_file.put_line(fnd_file.log,' Unhandled exception raised '||sqlerrm);
1249: fnd_message.set_name('PSP','PSP_ER_CREATE_UNEXPECTED_ERROR');
1250: l_err_mesg := substr(fnd_message.get,1,2000);
1251: l_sqlerrm := l_err_mesg || substr(sqlerrm,1,200);
1252: psp_general.add_report_error(l_request_id, 'E',null, l_retry_request_id, null, l_sqlerrm,l_return_status);
1253:
1254: /* Below lines added for supercedence requirement
1255: */
1256: -- hr_utility.trace_off;

Line 1477: psp_general.add_report_error(p_request_id, 'E',null, p_retry_request_id, null, l_sqlerrm,l_return_status);

1473: WHEN OTHERS THEN
1474:
1475: l_sqlerrm := 'Error inserting in psp_report_errors '|| substr(sqlerrm,1,200);
1476:
1477: psp_general.add_report_error(p_request_id, 'E',null, p_retry_request_id, null, l_sqlerrm,l_return_status);
1478:
1479:
1480:
1481: END;

Line 1661: psp_general.add_report_error( p_request_id => p_request_id ,

1657: fnd_message.set_name('PSP','PSP_ER_CAN_NOT_DISPLAY_DATA');
1658: l_err_mesg := l_err_mesg || fnd_message.get;
1659: END IF;
1660: l_err_mesg := substr(l_err_mesg,1,2000);
1661: psp_general.add_report_error( p_request_id => p_request_id ,
1662: p_message_level => 'E',
1663: p_source_id => l_person_id,
1664: p_retry_request_id => p_retry_request_id,
1665: p_pdf_request_id => NULL,

Line 1684: psp_general.add_report_error( p_request_id => p_request_id ,

1680: fnd_message.set_name('PSP', 'PSP_ER_INVALID_PI');
1681: fnd_message.set_token('AWARD_NUMBER', l_award_number);
1682: l_err_mesg := fnd_message.get;
1683:
1684: psp_general.add_report_error( p_request_id => p_request_id ,
1685: p_message_level => 'E',
1686: p_source_id => l_person_id,
1687: p_retry_request_id => p_retry_request_id,
1688: p_pdf_request_id => NULL,

Line 1705: psp_general.add_report_error( p_request_id => p_request_id ,

1701: fnd_message.set_name('PSP', 'PSP_ER_INVALID_PM');
1702: fnd_message.set_token('PROJECT_NUMBER', l_project_number);
1703: l_err_mesg := fnd_message.get;
1704:
1705: psp_general.add_report_error( p_request_id => p_request_id ,
1706: p_message_level => 'E',
1707: p_source_id => l_person_id,
1708: p_retry_request_id => p_retry_request_id,
1709: p_pdf_request_id => NULL,

Line 1732: psp_general.add_report_error( p_request_id => p_request_id ,

1728: fnd_message.set_token('PROJECT_NUMBER', l_project_number);
1729: fnd_message.set_token('TASK_NUMBER', l_task_number);
1730: l_err_mesg := fnd_message.get;
1731:
1732: psp_general.add_report_error( p_request_id => p_request_id ,
1733: p_message_level => 'E',
1734: p_source_id => l_person_id,
1735: p_retry_request_id => p_retry_request_id,
1736: p_pdf_request_id => NULL,

Line 1753: psp_general.add_report_error( p_request_id => p_request_id ,

1749: fnd_message.set_token('PROJECT_NUMBER', l_project_number);
1750: fnd_message.set_token('TASK_NUMBER', l_task_number);
1751: l_err_mesg := fnd_message.get;
1752:
1753: psp_general.add_report_error( p_request_id => p_request_id ,
1754: p_message_level => 'E',
1755: p_source_id => l_person_id,
1756: p_retry_request_id => p_retry_request_id,
1757: p_pdf_request_id => NULL,