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_GENERAL dependencies on FND_MESSAGE

Line 1236: RETURN(FND_MESSAGE.GET_STRING('PSP','PSP_NON_PERSON_NOT_FOUND'));

1232: IF c1%NOTFOUND
1233: THEN
1234: CLOSE c1;
1235: -- RETURN ('Person Name Not Found on Effective Date');
1236: RETURN(FND_MESSAGE.GET_STRING('PSP','PSP_NON_PERSON_NOT_FOUND'));
1237: END IF;
1238:
1239: CLOSE c1;
1240:

Line 1274: RETURN(FND_MESSAGE.GET_STRING('PSP','PSP_NON_ASSIGNMENT_NOT_FOUND'));

1270: IF c1%NOTFOUND
1271: THEN
1272: CLOSE c1;
1273: -- RETURN ('Assg Num Not Found on Eff Date');
1274: RETURN(FND_MESSAGE.GET_STRING('PSP','PSP_NON_ASSIGNMENT_NOT_FOUND'));
1275: END IF;
1276:
1277: CLOSE c1;
1278:

Line 1312: RETURN(FND_MESSAGE.GET_STRING('PSP','PSP_NON_PAYROLL_NOT_FOUND'));

1308: IF c1%NOTFOUND
1309: THEN
1310: CLOSE c1;
1311: -- RETURN ('Payroll Name Not Found on Effective Date');
1312: RETURN(FND_MESSAGE.GET_STRING('PSP','PSP_NON_PAYROLL_NOT_FOUND'));
1313: END IF;
1314:
1315: CLOSE c1;
1316:

Line 1378: fnd_message.set_name('PSP', 'PSP_PROJECT_NOT_FOUND');

1374: BEGIN
1375: OPEN project_number_cur;
1376: FETCH project_number_cur INTO l_project_number;
1377: IF (project_number_cur%NOTFOUND) THEN
1378: fnd_message.set_name('PSP', 'PSP_PROJECT_NOT_FOUND');
1379: l_project_number := fnd_message.get;
1380: END IF;
1381: CLOSE project_number_cur;
1382: RETURN l_project_number;

Line 1379: l_project_number := fnd_message.get;

1375: OPEN project_number_cur;
1376: FETCH project_number_cur INTO l_project_number;
1377: IF (project_number_cur%NOTFOUND) THEN
1378: fnd_message.set_name('PSP', 'PSP_PROJECT_NOT_FOUND');
1379: l_project_number := fnd_message.get;
1380: END IF;
1381: CLOSE project_number_cur;
1382: RETURN l_project_number;
1383: END get_project_number;

Line 1397: fnd_message.set_name('PSP', 'PSP_TASK_NOT_FOUND');

1393: BEGIN
1394: OPEN task_number_cur;
1395: FETCH task_number_cur INTO l_task_number;
1396: IF (task_number_cur%NOTFOUND) THEN
1397: fnd_message.set_name('PSP', 'PSP_TASK_NOT_FOUND');
1398: l_task_number := fnd_message.get;
1399: END IF;
1400: CLOSE task_number_cur;
1401: RETURN l_task_number;

Line 1398: l_task_number := fnd_message.get;

1394: OPEN task_number_cur;
1395: FETCH task_number_cur INTO l_task_number;
1396: IF (task_number_cur%NOTFOUND) THEN
1397: fnd_message.set_name('PSP', 'PSP_TASK_NOT_FOUND');
1398: l_task_number := fnd_message.get;
1399: END IF;
1400: CLOSE task_number_cur;
1401: RETURN l_task_number;
1402: END get_task_number;

Line 1424: fnd_message.set_name('PSP', 'PSP_AWARD_NOT_FOUND');

1420: IF (award_number_cur%NOTFOUND) THEN
1421: open default_Award_cur;
1422: fetch default_Award_cur into l_Award_number;
1423: if default_Award_cur%notfound then
1424: fnd_message.set_name('PSP', 'PSP_AWARD_NOT_FOUND');
1425: l_award_number := fnd_message.get;
1426: end if;
1427: close default_award_cur;
1428: END IF;

Line 1425: l_award_number := fnd_message.get;

1421: open default_Award_cur;
1422: fetch default_Award_cur into l_Award_number;
1423: if default_Award_cur%notfound then
1424: fnd_message.set_name('PSP', 'PSP_AWARD_NOT_FOUND');
1425: l_award_number := fnd_message.get;
1426: end if;
1427: close default_award_cur;
1428: END IF;
1429: CLOSE award_number_cur;

Line 1446: fnd_message.set_name('PSP', 'PSP_ORG_NOT_FOUND');

1442: BEGIN
1443: OPEN org_name_cur;
1444: FETCH org_name_cur INTO l_org_name;
1445: IF (org_name_cur%NOTFOUND) THEN
1446: fnd_message.set_name('PSP', 'PSP_ORG_NOT_FOUND');
1447: l_org_name := fnd_message.get;
1448: END IF;
1449: CLOSE org_name_cur;
1450: RETURN l_org_name;

Line 1447: l_org_name := fnd_message.get;

1443: OPEN org_name_cur;
1444: FETCH org_name_cur INTO l_org_name;
1445: IF (org_name_cur%NOTFOUND) THEN
1446: fnd_message.set_name('PSP', 'PSP_ORG_NOT_FOUND');
1447: l_org_name := fnd_message.get;
1448: END IF;
1449: CLOSE org_name_cur;
1450: RETURN l_org_name;
1451: END get_org_name;

Line 1465: fnd_message.set_name('PSP', 'PSP_PERIOD_NOT_FOUND');

1461: BEGIN
1462: OPEN period_name_cur;
1463: FETCH period_name_cur INTO l_period_name;
1464: IF (period_name_cur%NOTFOUND) THEN
1465: fnd_message.set_name('PSP', 'PSP_PERIOD_NOT_FOUND');
1466: l_period_name := fnd_message.get;
1467: END IF;
1468: CLOSE period_name_cur;
1469: RETURN l_period_name;

Line 1466: l_period_name := fnd_message.get;

1462: OPEN period_name_cur;
1463: FETCH period_name_cur INTO l_period_name;
1464: IF (period_name_cur%NOTFOUND) THEN
1465: fnd_message.set_name('PSP', 'PSP_PERIOD_NOT_FOUND');
1466: l_period_name := fnd_message.get;
1467: END IF;
1468: CLOSE period_name_cur;
1469: RETURN l_period_name;
1470: END get_period_name;

Line 1486: fnd_message.set_name('PSP', 'PSP_ELEMENT_NOT_FOUND');

1482: BEGIN
1483: OPEN element_name_cur;
1484: FETCH element_name_cur INTO l_element_name;
1485: IF (element_name_cur%NOTFOUND) THEN
1486: fnd_message.set_name('PSP', 'PSP_ELEMENT_NOT_FOUND');
1487: l_element_name := fnd_message.get;
1488: END IF;
1489: CLOSE element_name_cur;
1490: RETURN l_element_name;

Line 1487: l_element_name := fnd_message.get;

1483: OPEN element_name_cur;
1484: FETCH element_name_cur INTO l_element_name;
1485: IF (element_name_cur%NOTFOUND) THEN
1486: fnd_message.set_name('PSP', 'PSP_ELEMENT_NOT_FOUND');
1487: l_element_name := fnd_message.get;
1488: END IF;
1489: CLOSE element_name_cur;
1490: RETURN l_element_name;
1491: END get_element_name;

Line 1529: fnd_message.set_name('PSP', 'PSP_SOURCE_TYPE_NOT_FOUND');

1525: BEGIN
1526: OPEN source_type_cur;
1527: FETCH source_type_cur INTO l_source_type;
1528: IF (source_type_cur%NOTFOUND) THEN
1529: fnd_message.set_name('PSP', 'PSP_SOURCE_TYPE_NOT_FOUND');
1530: l_source_type := fnd_message.get;
1531: END IF;
1532: CLOSE source_type_cur;
1533: RETURN l_source_type;

Line 1530: l_source_type := fnd_message.get;

1526: OPEN source_type_cur;
1527: FETCH source_type_cur INTO l_source_type;
1528: IF (source_type_cur%NOTFOUND) THEN
1529: fnd_message.set_name('PSP', 'PSP_SOURCE_TYPE_NOT_FOUND');
1530: l_source_type := fnd_message.get;
1531: END IF;
1532: CLOSE source_type_cur;
1533: RETURN l_source_type;
1534: END get_source_type;

Line 1558: fnd_message.set_name('PSP', 'PSP_STATUS_DESCR_NOT_FOUND');

1554: BEGIN
1555: OPEN status_description_cur;
1556: FETCH status_description_cur INTO l_status_description;
1557: IF (status_description_cur%NOTFOUND) THEN
1558: fnd_message.set_name('PSP', 'PSP_STATUS_DESCR_NOT_FOUND');
1559: l_status_description := fnd_message.get;
1560: END IF;
1561: CLOSE status_description_cur;
1562: RETURN l_status_description;

Line 1559: l_status_description := fnd_message.get;

1555: OPEN status_description_cur;
1556: FETCH status_description_cur INTO l_status_description;
1557: IF (status_description_cur%NOTFOUND) THEN
1558: fnd_message.set_name('PSP', 'PSP_STATUS_DESCR_NOT_FOUND');
1559: l_status_description := fnd_message.get;
1560: END IF;
1561: CLOSE status_description_cur;
1562: RETURN l_status_description;
1563: END get_status_description;

Line 1617: FND_MESSAGE.SET_NAME('PSP' , 'PSP_HR_CUR_NOT_SET_UP');

1613: FETCH get_curr_for_bg into l_curr_code;
1614:
1615: IF get_curr_for_bg%NOTFOUND THEN
1616:
1617: FND_MESSAGE.SET_NAME('PSP' , 'PSP_HR_CUR_NOT_SET_UP');
1618: CLOSE get_curr_for_bg;
1619: RAISE fnd_api.g_exc_unexpected_error;
1620:
1621: ELSE

Line 1867: If (l_person_name = FND_MESSAGE.GET_STRING('PSP','PSP_NON_PERSON_NOT_FOUND') ) Then

1863: begin
1864:
1865:
1866: l_person_name := psp_general.get_person_name(p_person_id,p_effective_date);
1867: If (l_person_name = FND_MESSAGE.GET_STRING('PSP','PSP_NON_PERSON_NOT_FOUND') ) Then
1868: open eff_dates;
1869: fetch eff_dates into max_eff_end_date,min_eff_start_date;
1870: close eff_dates;
1871:

Line 1879: RETURN(FND_MESSAGE.GET_STRING('PSP','PSP_NON_PERSON_NOT_FOUND'));

1875: fetch c1 into l_person_name;
1876: IF c1%NOTFOUND THEN
1877: CLOSE c1;
1878: -- RETURN ('Person Name Not Found on Effective Date');
1879: RETURN(FND_MESSAGE.GET_STRING('PSP','PSP_NON_PERSON_NOT_FOUND'));
1880: END IF;
1881:
1882:
1883: Else

Line 1890: RETURN(FND_MESSAGE.GET_STRING('PSP','PSP_NON_PERSON_NOT_FOUND'));

1886: fetch c1 into l_person_name;
1887: IF c1%NOTFOUND THEN
1888: CLOSE c1;
1889: -- RETURN ('Person Name Not Found on Effective Date');
1890: RETURN(FND_MESSAGE.GET_STRING('PSP','PSP_NON_PERSON_NOT_FOUND'));
1891: END IF;
1892:
1893: End if ;
1894:

Line 1987: If (l_payroll_name = FND_MESSAGE.GET_STRING('PSP','PSP_NON_PAYROLL_NOT_FOUND') ) Then

1983: begin
1984:
1985:
1986: l_payroll_name := psp_general.get_payroll_name(p_payroll_id,p_effective_date);
1987: If (l_payroll_name = FND_MESSAGE.GET_STRING('PSP','PSP_NON_PAYROLL_NOT_FOUND') ) Then
1988: open eff_dates;
1989: fetch eff_dates into max_eff_end_date,min_eff_start_date;
1990: close eff_dates;
1991:

Line 1998: RETURN(FND_MESSAGE.GET_STRING('PSP','PSP_NON_PAYROLL_NOT_FOUND'));

1994: open c1(min_eff_start_date);
1995: fetch c1 into l_payroll_name;
1996: IF c1%NOTFOUND THEN
1997: CLOSE c1;
1998: RETURN(FND_MESSAGE.GET_STRING('PSP','PSP_NON_PAYROLL_NOT_FOUND'));
1999: END IF;
2000:
2001:
2002: Else

Line 2008: RETURN(FND_MESSAGE.GET_STRING('PSP','PSP_NON_PAYROLL_NOT_FOUND'));

2004: open c1(max_eff_end_date);
2005: fetch c1 into l_payroll_name;
2006: IF c1%NOTFOUND THEN
2007: CLOSE c1;
2008: RETURN(FND_MESSAGE.GET_STRING('PSP','PSP_NON_PAYROLL_NOT_FOUND'));
2009: END IF;
2010:
2011: End if ;
2012:

Line 2398: RETURN(FND_MESSAGE.GET_STRING('PSP','PSP_ORG_NOT_FOUND'));

2394: open c1(min_eff_start_date);
2395: fetch c1 into l_organization_name;
2396: IF c1%NOTFOUND THEN
2397: CLOSE c1;
2398: RETURN(FND_MESSAGE.GET_STRING('PSP','PSP_ORG_NOT_FOUND'));
2399: END IF;
2400:
2401:
2402: Else

Line 2408: RETURN(FND_MESSAGE.GET_STRING('PSP','PSP_ORG_NOT_FOUND'));

2404: open c1(max_eff_end_date);
2405: fetch c1 into l_organization_name;
2406: IF c1%NOTFOUND THEN
2407: CLOSE c1;
2408: RETURN(FND_MESSAGE.GET_STRING('PSP','PSP_ORG_NOT_FOUND'));
2409: END IF;
2410:
2411: End if ;
2412: