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 528: IF PSP_GENERAL.GET_CONFIGURATION_OPTION_VALUE(l_profile_bg_id,'PSP_USE_GL_PTAOE_MAPPING') = 'Y' THEN

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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