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_MESSAGE

Line 1249: fnd_message.set_name('PSP','PSP_ER_CREATE_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);
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:

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

1246: BEGIN
1247: -- hr_utility.trace('psp_create_eff_reports--> Exception '||sqlerrm);
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

Line 1334: fnd_message.set_name('PSP', 'PSP_EFF_ALREADY_EXISTS');

1330:
1331: /* A pending or Approved Effort Report already exists */
1332:
1333: if p_match_level = 'EMP' then
1334: fnd_message.set_name('PSP', 'PSP_EFF_ALREADY_EXISTS');
1335: l_msg_str:= substr(fnd_message.get ,1,240);
1336:
1337: update psp_selected_persons_t
1338: set skip_reason = 'ALREADY_EXISTS'

Line 1335: l_msg_str:= substr(fnd_message.get ,1,240);

1331: /* A pending or Approved Effort Report already exists */
1332:
1333: if p_match_level = 'EMP' then
1334: fnd_message.set_name('PSP', 'PSP_EFF_ALREADY_EXISTS');
1335: l_msg_str:= substr(fnd_message.get ,1,240);
1336:
1337: update psp_selected_persons_t
1338: set skip_reason = 'ALREADY_EXISTS'
1339: where person_id between p_start_person and p_end_person

Line 1410: fnd_message.set_name('PSP', 'PSP_ASG_EFF_ALREADY_EXISTS');

1406: exit;
1407: end if;
1408:
1409: if skipped_asg_rec.skip_reason = 'ALREADY_EXISTS' then
1410: fnd_message.set_name('PSP', 'PSP_ASG_EFF_ALREADY_EXISTS');
1411: fnd_message.set_token('ASG_NUMBER',skipped_asg_rec.assignment_number);
1412: l_msg_str:= substr(fnd_message.get ,1,240);
1413: else
1414: fnd_message.set_name('PSP', 'PSP_ASG_EFF_ALREADY_EXISTS2');

Line 1411: fnd_message.set_token('ASG_NUMBER',skipped_asg_rec.assignment_number);

1407: end if;
1408:
1409: if skipped_asg_rec.skip_reason = 'ALREADY_EXISTS' then
1410: fnd_message.set_name('PSP', 'PSP_ASG_EFF_ALREADY_EXISTS');
1411: fnd_message.set_token('ASG_NUMBER',skipped_asg_rec.assignment_number);
1412: l_msg_str:= substr(fnd_message.get ,1,240);
1413: else
1414: fnd_message.set_name('PSP', 'PSP_ASG_EFF_ALREADY_EXISTS2');
1415: fnd_message.set_token('ASG_NUMBER',skipped_asg_rec.assignment_number);

Line 1412: l_msg_str:= substr(fnd_message.get ,1,240);

1408:
1409: if skipped_asg_rec.skip_reason = 'ALREADY_EXISTS' then
1410: fnd_message.set_name('PSP', 'PSP_ASG_EFF_ALREADY_EXISTS');
1411: fnd_message.set_token('ASG_NUMBER',skipped_asg_rec.assignment_number);
1412: l_msg_str:= substr(fnd_message.get ,1,240);
1413: else
1414: fnd_message.set_name('PSP', 'PSP_ASG_EFF_ALREADY_EXISTS2');
1415: fnd_message.set_token('ASG_NUMBER',skipped_asg_rec.assignment_number);
1416: l_msg_str:= substr(fnd_message.get ,1,240);

Line 1414: fnd_message.set_name('PSP', 'PSP_ASG_EFF_ALREADY_EXISTS2');

1410: fnd_message.set_name('PSP', 'PSP_ASG_EFF_ALREADY_EXISTS');
1411: fnd_message.set_token('ASG_NUMBER',skipped_asg_rec.assignment_number);
1412: l_msg_str:= substr(fnd_message.get ,1,240);
1413: else
1414: fnd_message.set_name('PSP', 'PSP_ASG_EFF_ALREADY_EXISTS2');
1415: fnd_message.set_token('ASG_NUMBER',skipped_asg_rec.assignment_number);
1416: l_msg_str:= substr(fnd_message.get ,1,240);
1417: end if;
1418:

Line 1415: fnd_message.set_token('ASG_NUMBER',skipped_asg_rec.assignment_number);

1411: fnd_message.set_token('ASG_NUMBER',skipped_asg_rec.assignment_number);
1412: l_msg_str:= substr(fnd_message.get ,1,240);
1413: else
1414: fnd_message.set_name('PSP', 'PSP_ASG_EFF_ALREADY_EXISTS2');
1415: fnd_message.set_token('ASG_NUMBER',skipped_asg_rec.assignment_number);
1416: l_msg_str:= substr(fnd_message.get ,1,240);
1417: end if;
1418:
1419: insert into psp_report_errors

Line 1416: l_msg_str:= substr(fnd_message.get ,1,240);

1412: l_msg_str:= substr(fnd_message.get ,1,240);
1413: else
1414: fnd_message.set_name('PSP', 'PSP_ASG_EFF_ALREADY_EXISTS2');
1415: fnd_message.set_token('ASG_NUMBER',skipped_asg_rec.assignment_number);
1416: l_msg_str:= substr(fnd_message.get ,1,240);
1417: end if;
1418:
1419: insert into psp_report_errors
1420: (error_sequence_id, request_id, message_level,

Line 1436: fnd_message.set_name('PSP', 'PSP_EFF_NO_DISTRIB');

1432: /* No distributions Found */
1433:
1434:
1435:
1436: fnd_message.set_name('PSP', 'PSP_EFF_NO_DISTRIB');
1437: l_msg_str:= substr(fnd_message.get ,1,240);
1438:
1439: insert into psp_report_errors
1440: (error_sequence_id, request_id, message_level,

Line 1437: l_msg_str:= substr(fnd_message.get ,1,240);

1433:
1434:
1435:
1436: fnd_message.set_name('PSP', 'PSP_EFF_NO_DISTRIB');
1437: l_msg_str:= substr(fnd_message.get ,1,240);
1438:
1439: insert into psp_report_errors
1440: (error_sequence_id, request_id, message_level,
1441: source_id, error_message, retry_request_id, pdf_request_id,

Line 1453: fnd_message.set_name('PSP', 'PSP_EFF_PENDING_DIST_ADJ');

1449: g_psp_effort_start <= end_date and status_code in ('N', 'A'))
1450: and pspt.person_id not in (select nvl(source_id,0) from psp_report_errors where request_id = g_psp_request_id);
1451:
1452:
1453: fnd_message.set_name('PSP', 'PSP_EFF_PENDING_DIST_ADJ');
1454: l_msg_str:= substr(fnd_message.get ,1,200);
1455: insert into psp_report_errors
1456: (error_sequence_id, request_id, message_level,
1457: source_id, error_message, retry_request_id, pdf_request_id,

Line 1454: l_msg_str:= substr(fnd_message.get ,1,200);

1450: and pspt.person_id not in (select nvl(source_id,0) from psp_report_errors where request_id = g_psp_request_id);
1451:
1452:
1453: fnd_message.set_name('PSP', 'PSP_EFF_PENDING_DIST_ADJ');
1454: l_msg_str:= substr(fnd_message.get ,1,200);
1455: insert into psp_report_errors
1456: (error_sequence_id, request_id, message_level,
1457: source_id, error_message, retry_request_id, pdf_request_id,
1458: source_name, parent_source_id, parent_source_name)

Line 1625: fnd_message.set_name('PSP','PSP_ER_INVALID_PROJECT');

1621:
1622: IF l_error_type = 1 THEN
1623:
1624: IF l_project_name = 'NOTFOUND' THEN
1625: fnd_message.set_name('PSP','PSP_ER_INVALID_PROJECT');
1626: fnd_message.set_token('PROJECT_ID',l_project_id);
1627: l_err_mesg := l_err_mesg || fnd_message.get;
1628: END IF;
1629:

Line 1626: fnd_message.set_token('PROJECT_ID',l_project_id);

1622: IF l_error_type = 1 THEN
1623:
1624: IF l_project_name = 'NOTFOUND' THEN
1625: fnd_message.set_name('PSP','PSP_ER_INVALID_PROJECT');
1626: fnd_message.set_token('PROJECT_ID',l_project_id);
1627: l_err_mesg := l_err_mesg || fnd_message.get;
1628: END IF;
1629:
1630: IF l_task_name = 'NOTFOUND' THEN

Line 1627: l_err_mesg := l_err_mesg || fnd_message.get;

1623:
1624: IF l_project_name = 'NOTFOUND' THEN
1625: fnd_message.set_name('PSP','PSP_ER_INVALID_PROJECT');
1626: fnd_message.set_token('PROJECT_ID',l_project_id);
1627: l_err_mesg := l_err_mesg || fnd_message.get;
1628: END IF;
1629:
1630: IF l_task_name = 'NOTFOUND' THEN
1631: fnd_message.set_name('PSP','PSP_ER_INVALID_TASK');

Line 1631: fnd_message.set_name('PSP','PSP_ER_INVALID_TASK');

1627: l_err_mesg := l_err_mesg || fnd_message.get;
1628: END IF;
1629:
1630: IF l_task_name = 'NOTFOUND' THEN
1631: fnd_message.set_name('PSP','PSP_ER_INVALID_TASK');
1632: fnd_message.set_token('TASK_ID',l_task_id);
1633: l_err_mesg := l_err_mesg || fnd_message.get;
1634: END IF;
1635:

Line 1632: fnd_message.set_token('TASK_ID',l_task_id);

1628: END IF;
1629:
1630: IF l_task_name = 'NOTFOUND' THEN
1631: fnd_message.set_name('PSP','PSP_ER_INVALID_TASK');
1632: fnd_message.set_token('TASK_ID',l_task_id);
1633: l_err_mesg := l_err_mesg || fnd_message.get;
1634: END IF;
1635:
1636: IF l_award_name = 'NOTFOUND' THEN

Line 1633: l_err_mesg := l_err_mesg || fnd_message.get;

1629:
1630: IF l_task_name = 'NOTFOUND' THEN
1631: fnd_message.set_name('PSP','PSP_ER_INVALID_TASK');
1632: fnd_message.set_token('TASK_ID',l_task_id);
1633: l_err_mesg := l_err_mesg || fnd_message.get;
1634: END IF;
1635:
1636: IF l_award_name = 'NOTFOUND' THEN
1637: fnd_message.set_name('PSP','PSP_ER_INVALID_AWARD');

Line 1637: fnd_message.set_name('PSP','PSP_ER_INVALID_AWARD');

1633: l_err_mesg := l_err_mesg || fnd_message.get;
1634: END IF;
1635:
1636: IF l_award_name = 'NOTFOUND' THEN
1637: fnd_message.set_name('PSP','PSP_ER_INVALID_AWARD');
1638: fnd_message.set_token('AWARD_ID',l_award_id);
1639: l_err_mesg := l_err_mesg || fnd_message.get;
1640: END IF;
1641:

Line 1638: fnd_message.set_token('AWARD_ID',l_award_id);

1634: END IF;
1635:
1636: IF l_award_name = 'NOTFOUND' THEN
1637: fnd_message.set_name('PSP','PSP_ER_INVALID_AWARD');
1638: fnd_message.set_token('AWARD_ID',l_award_id);
1639: l_err_mesg := l_err_mesg || fnd_message.get;
1640: END IF;
1641:
1642: IF l_exp_org_name = 'NOTFOUND' THEN

Line 1639: l_err_mesg := l_err_mesg || fnd_message.get;

1635:
1636: IF l_award_name = 'NOTFOUND' THEN
1637: fnd_message.set_name('PSP','PSP_ER_INVALID_AWARD');
1638: fnd_message.set_token('AWARD_ID',l_award_id);
1639: l_err_mesg := l_err_mesg || fnd_message.get;
1640: END IF;
1641:
1642: IF l_exp_org_name = 'NOTFOUND' THEN
1643: fnd_message.set_name('PSP','PSP_ER_INVALID_EXP_ORG');

Line 1643: fnd_message.set_name('PSP','PSP_ER_INVALID_EXP_ORG');

1639: l_err_mesg := l_err_mesg || fnd_message.get;
1640: END IF;
1641:
1642: IF l_exp_org_name = 'NOTFOUND' THEN
1643: fnd_message.set_name('PSP','PSP_ER_INVALID_EXP_ORG');
1644: fnd_message.set_token('EXP_ORG_ID',l_exp_org_id);
1645: l_err_mesg := l_err_mesg || fnd_message.get;
1646: END IF;
1647:

Line 1644: fnd_message.set_token('EXP_ORG_ID',l_exp_org_id);

1640: END IF;
1641:
1642: IF l_exp_org_name = 'NOTFOUND' THEN
1643: fnd_message.set_name('PSP','PSP_ER_INVALID_EXP_ORG');
1644: fnd_message.set_token('EXP_ORG_ID',l_exp_org_id);
1645: l_err_mesg := l_err_mesg || fnd_message.get;
1646: END IF;
1647:
1648: ELSE

Line 1645: l_err_mesg := l_err_mesg || fnd_message.get;

1641:
1642: IF l_exp_org_name = 'NOTFOUND' THEN
1643: fnd_message.set_name('PSP','PSP_ER_INVALID_EXP_ORG');
1644: fnd_message.set_token('EXP_ORG_ID',l_exp_org_id);
1645: l_err_mesg := l_err_mesg || fnd_message.get;
1646: END IF;
1647:
1648: ELSE
1649:

Line 1650: fnd_message.set_name('PSP','PSP_ER_CI_NOT_FOUND');

1646: END IF;
1647:
1648: ELSE
1649:
1650: fnd_message.set_name('PSP','PSP_ER_CI_NOT_FOUND');
1651: l_err_mesg := l_err_mesg || fnd_message.get;
1652: END IF;
1653:
1654: IF l_err_mesg IS NOT NULL THEN

Line 1651: l_err_mesg := l_err_mesg || fnd_message.get;

1647:
1648: ELSE
1649:
1650: fnd_message.set_name('PSP','PSP_ER_CI_NOT_FOUND');
1651: l_err_mesg := l_err_mesg || fnd_message.get;
1652: END IF;
1653:
1654: IF l_err_mesg IS NOT NULL THEN
1655:

Line 1657: fnd_message.set_name('PSP','PSP_ER_CAN_NOT_DISPLAY_DATA');

1653:
1654: IF l_err_mesg IS NOT NULL THEN
1655:
1656: IF l_error_type = 1 THEN
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 ,

Line 1658: l_err_mesg := l_err_mesg || fnd_message.get;

1654: IF l_err_mesg IS NOT NULL THEN
1655:
1656: IF l_error_type = 1 THEN
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',

Line 1680: fnd_message.set_name('PSP', 'PSP_ER_INVALID_PI');

1676: LOOP
1677: FETCH check_award_pi_cur INTO l_person_id, l_award_id, l_award_number;
1678: EXIT WHEN check_award_pi_cur%NOTFOUND;
1679:
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 ,

Line 1681: fnd_message.set_token('AWARD_NUMBER', l_award_number);

1677: FETCH check_award_pi_cur INTO l_person_id, l_award_id, l_award_number;
1678: EXIT WHEN check_award_pi_cur%NOTFOUND;
1679:
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',

Line 1682: l_err_mesg := fnd_message.get;

1678: EXIT WHEN check_award_pi_cur%NOTFOUND;
1679:
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,

Line 1701: fnd_message.set_name('PSP', 'PSP_ER_INVALID_PM');

1697: LOOP
1698: FETCH check_pm_cur INTO l_person_id, l_project_id, l_project_number;
1699: EXIT WHEN check_pm_cur%NOTFOUND;
1700:
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 ,

Line 1702: fnd_message.set_token('PROJECT_NUMBER', l_project_number);

1698: FETCH check_pm_cur INTO l_person_id, l_project_id, l_project_number;
1699: EXIT WHEN check_pm_cur%NOTFOUND;
1700:
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',

Line 1703: l_err_mesg := fnd_message.get;

1699: EXIT WHEN check_pm_cur%NOTFOUND;
1700:
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,

Line 1727: fnd_message.set_name('PSP', 'PSP_ER_INVALID_TM');

1723: LOOP
1724: FETCH check_tm_cur INTO l_person_id, l_project_number, l_task_id, l_task_number;
1725: EXIT WHEN check_tm_cur%NOTFOUND;
1726:
1727: fnd_message.set_name('PSP', 'PSP_ER_INVALID_TM');
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:

Line 1728: fnd_message.set_token('PROJECT_NUMBER', l_project_number);

1724: FETCH check_tm_cur INTO l_person_id, l_project_number, l_task_id, l_task_number;
1725: EXIT WHEN check_tm_cur%NOTFOUND;
1726:
1727: fnd_message.set_name('PSP', 'PSP_ER_INVALID_TM');
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 ,

Line 1729: fnd_message.set_token('TASK_NUMBER', l_task_number);

1725: EXIT WHEN check_tm_cur%NOTFOUND;
1726:
1727: fnd_message.set_name('PSP', 'PSP_ER_INVALID_TM');
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',

Line 1730: l_err_mesg := fnd_message.get;

1726:
1727: fnd_message.set_name('PSP', 'PSP_ER_INVALID_TM');
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,

Line 1748: fnd_message.set_name('PSP', 'PSP_ER_INVALID_TM');

1744: LOOP
1745: FETCH check_tm_cur1 INTO l_person_id, l_project_number, l_task_id, l_task_number;
1746: EXIT WHEN check_tm_cur1%NOTFOUND;
1747:
1748: fnd_message.set_name('PSP', 'PSP_ER_INVALID_TM');
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:

Line 1749: fnd_message.set_token('PROJECT_NUMBER', l_project_number);

1745: FETCH check_tm_cur1 INTO l_person_id, l_project_number, l_task_id, l_task_number;
1746: EXIT WHEN check_tm_cur1%NOTFOUND;
1747:
1748: fnd_message.set_name('PSP', 'PSP_ER_INVALID_TM');
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 ,

Line 1750: fnd_message.set_token('TASK_NUMBER', l_task_number);

1746: EXIT WHEN check_tm_cur1%NOTFOUND;
1747:
1748: fnd_message.set_name('PSP', 'PSP_ER_INVALID_TM');
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',

Line 1751: l_err_mesg := fnd_message.get;

1747:
1748: fnd_message.set_name('PSP', 'PSP_ER_INVALID_TM');
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,