DBA Data[Home] [Help]

APPS.PSB_POSITION_ATTRIBUTES_PVT dependencies on FND_MESSAGE

Line 576: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');

572: --
573: FETCH C INTO Recinfo;
574: IF (C%NOTFOUND) then
575: CLOSE C;
576: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
577: FND_MSG_PUB.Add;
578: RAISE FND_API.G_EXC_ERROR ;
579: END IF;
580: CLOSE C;

Line 617: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');

613: )
614: THEN
615: Null;
616: ELSE
617: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
618: FND_MSG_PUB.Add;
619: RAISE FND_API.G_EXC_ERROR ;
620: END IF;
621:

Line 630: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');

626: OR ((tlinfo.DISPLAY_PROMPT is null) AND (p_DISPLAY_PROMPT is null)))
627: ) then
628: null;
629: else
630: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
631: app_exception.raise_exception;
632: end if;
633: end if;
634: end loop;

Line 1072: FND_MESSAGE.Set_Name('PSB', 'PSB_PAT_JOB_CLASS_NAME');

1068: -- load all system attributes into the record type
1069: -- there are 6 system defined attributes that has to be loaded
1070:
1071: l_sys_attributes_tbl(1).l_sys_attribute_type := 'JOB_CLASS';
1072: FND_MESSAGE.Set_Name('PSB', 'PSB_PAT_JOB_CLASS_NAME');
1073: l_sys_attributes_tbl(1).l_attribute_name := FND_MESSAGE.get;
1074: l_sys_attributes_tbl(1).l_display_worksheet := 'Y';
1075: l_sys_attributes_tbl(1).l_display_seq := '1';
1076: l_sys_attributes_tbl(1).l_req_import_flg := 'Y';

Line 1073: l_sys_attributes_tbl(1).l_attribute_name := FND_MESSAGE.get;

1069: -- there are 6 system defined attributes that has to be loaded
1070:
1071: l_sys_attributes_tbl(1).l_sys_attribute_type := 'JOB_CLASS';
1072: FND_MESSAGE.Set_Name('PSB', 'PSB_PAT_JOB_CLASS_NAME');
1073: l_sys_attributes_tbl(1).l_attribute_name := FND_MESSAGE.get;
1074: l_sys_attributes_tbl(1).l_display_worksheet := 'Y';
1075: l_sys_attributes_tbl(1).l_display_seq := '1';
1076: l_sys_attributes_tbl(1).l_req_import_flg := 'Y';
1077: l_sys_attributes_tbl(1).l_req_position_flg := 'Y';

Line 1085: FND_MESSAGE.Set_Name('PSB', 'PSB_PAT_FTE_NAME');

1081: l_sys_attributes_tbl(1).l_allow_pos_set_flg := 'Y';
1082:
1083: -- for fte
1084: l_sys_attributes_tbl(2).l_sys_attribute_type := 'FTE';
1085: FND_MESSAGE.Set_Name('PSB', 'PSB_PAT_FTE_NAME');
1086: l_sys_attributes_tbl(2).l_attribute_name := FND_MESSAGE.get;
1087: l_sys_attributes_tbl(2).l_display_worksheet := 'Y';
1088: l_sys_attributes_tbl(2).l_display_seq := '2';
1089: l_sys_attributes_tbl(2).l_req_import_flg := 'Y';

Line 1086: l_sys_attributes_tbl(2).l_attribute_name := FND_MESSAGE.get;

1082:
1083: -- for fte
1084: l_sys_attributes_tbl(2).l_sys_attribute_type := 'FTE';
1085: FND_MESSAGE.Set_Name('PSB', 'PSB_PAT_FTE_NAME');
1086: l_sys_attributes_tbl(2).l_attribute_name := FND_MESSAGE.get;
1087: l_sys_attributes_tbl(2).l_display_worksheet := 'Y';
1088: l_sys_attributes_tbl(2).l_display_seq := '2';
1089: l_sys_attributes_tbl(2).l_req_import_flg := 'Y';
1090: l_sys_attributes_tbl(2).l_req_position_flg := 'Y';

Line 1098: FND_MESSAGE.Set_Name('PSB', 'PSB_PAT_ORGANIZATION_NAME');

1094: l_sys_attributes_tbl(2).l_allow_pos_set_flg := '';
1095:
1096: -- for organization
1097: l_sys_attributes_tbl(3).l_sys_attribute_type := 'ORG';
1098: FND_MESSAGE.Set_Name('PSB', 'PSB_PAT_ORGANIZATION_NAME');
1099: l_sys_attributes_tbl(3).l_attribute_name := FND_MESSAGE.get;
1100: l_sys_attributes_tbl(3).l_display_worksheet := 'Y';
1101: l_sys_attributes_tbl(3).l_display_seq := '6';
1102: l_sys_attributes_tbl(3).l_req_import_flg := '';

Line 1099: l_sys_attributes_tbl(3).l_attribute_name := FND_MESSAGE.get;

1095:
1096: -- for organization
1097: l_sys_attributes_tbl(3).l_sys_attribute_type := 'ORG';
1098: FND_MESSAGE.Set_Name('PSB', 'PSB_PAT_ORGANIZATION_NAME');
1099: l_sys_attributes_tbl(3).l_attribute_name := FND_MESSAGE.get;
1100: l_sys_attributes_tbl(3).l_display_worksheet := 'Y';
1101: l_sys_attributes_tbl(3).l_display_seq := '6';
1102: l_sys_attributes_tbl(3).l_req_import_flg := '';
1103: l_sys_attributes_tbl(3).l_req_position_flg := 'Y';

Line 1111: FND_MESSAGE.Set_Name('PSB', 'PSB_PAT_HIRE_DATE_NAME');

1107: l_sys_attributes_tbl(3).l_allow_pos_set_flg := 'Y';
1108:
1109: -- for hire Date
1110: l_sys_attributes_tbl(4).l_sys_attribute_type := 'HIREDATE';
1111: FND_MESSAGE.Set_Name('PSB', 'PSB_PAT_HIRE_DATE_NAME');
1112: l_sys_attributes_tbl(4).l_attribute_name := FND_MESSAGE.get;
1113: l_sys_attributes_tbl(4).l_display_worksheet := '';
1114: l_sys_attributes_tbl(4).l_display_seq := '';
1115: l_sys_attributes_tbl(4).l_req_import_flg := '';

Line 1112: l_sys_attributes_tbl(4).l_attribute_name := FND_MESSAGE.get;

1108:
1109: -- for hire Date
1110: l_sys_attributes_tbl(4).l_sys_attribute_type := 'HIREDATE';
1111: FND_MESSAGE.Set_Name('PSB', 'PSB_PAT_HIRE_DATE_NAME');
1112: l_sys_attributes_tbl(4).l_attribute_name := FND_MESSAGE.get;
1113: l_sys_attributes_tbl(4).l_display_worksheet := '';
1114: l_sys_attributes_tbl(4).l_display_seq := '';
1115: l_sys_attributes_tbl(4).l_req_import_flg := '';
1116: l_sys_attributes_tbl(4).l_req_position_flg := '';

Line 1124: FND_MESSAGE.Set_Name('PSB', 'PSB_PAT_ADJUSTMENT_DATE_NAME');

1120: l_sys_attributes_tbl(4).l_allow_pos_set_flg := '';
1121:
1122: -- for adjustment date
1123: l_sys_attributes_tbl(5).l_sys_attribute_type := 'ADJUSTMENT_DATE';
1124: FND_MESSAGE.Set_Name('PSB', 'PSB_PAT_ADJUSTMENT_DATE_NAME');
1125: l_sys_attributes_tbl(5).l_attribute_name := FND_MESSAGE.get;
1126: l_sys_attributes_tbl(5).l_display_worksheet := '';
1127: l_sys_attributes_tbl(5).l_display_seq := '';
1128: l_sys_attributes_tbl(5).l_req_import_flg := '';

Line 1125: l_sys_attributes_tbl(5).l_attribute_name := FND_MESSAGE.get;

1121:
1122: -- for adjustment date
1123: l_sys_attributes_tbl(5).l_sys_attribute_type := 'ADJUSTMENT_DATE';
1124: FND_MESSAGE.Set_Name('PSB', 'PSB_PAT_ADJUSTMENT_DATE_NAME');
1125: l_sys_attributes_tbl(5).l_attribute_name := FND_MESSAGE.get;
1126: l_sys_attributes_tbl(5).l_display_worksheet := '';
1127: l_sys_attributes_tbl(5).l_display_seq := '';
1128: l_sys_attributes_tbl(5).l_req_import_flg := '';
1129: l_sys_attributes_tbl(5).l_req_position_flg := '';

Line 1137: FND_MESSAGE.Set_Name('PSB', 'PSB_PAT_DFLT_WEEKLY_HOURS_NAME');

1133: l_sys_attributes_tbl(5).l_allow_pos_set_flg := '';
1134:
1135: -- for default weekly hours
1136: l_sys_attributes_tbl(6).l_sys_attribute_type := 'DEFAULT_WEEKLY_HOURS';
1137: FND_MESSAGE.Set_Name('PSB', 'PSB_PAT_DFLT_WEEKLY_HOURS_NAME');
1138: l_sys_attributes_tbl(6).l_attribute_name := FND_MESSAGE.get;
1139: l_sys_attributes_tbl(6).l_display_worksheet := '';
1140: l_sys_attributes_tbl(6).l_display_seq := '';
1141: l_sys_attributes_tbl(6).l_req_import_flg := 'Y';

Line 1138: l_sys_attributes_tbl(6).l_attribute_name := FND_MESSAGE.get;

1134:
1135: -- for default weekly hours
1136: l_sys_attributes_tbl(6).l_sys_attribute_type := 'DEFAULT_WEEKLY_HOURS';
1137: FND_MESSAGE.Set_Name('PSB', 'PSB_PAT_DFLT_WEEKLY_HOURS_NAME');
1138: l_sys_attributes_tbl(6).l_attribute_name := FND_MESSAGE.get;
1139: l_sys_attributes_tbl(6).l_display_worksheet := '';
1140: l_sys_attributes_tbl(6).l_display_seq := '';
1141: l_sys_attributes_tbl(6).l_req_import_flg := 'Y';
1142: l_sys_attributes_tbl(6).l_req_position_flg := '';

Line 1274: FND_MESSAGE.Set_Name('PSB', 'PSB_PAT_JOB_CLASS_NAME');

1270:
1271: Temp_ID := Null;
1272: Temp_Type := '';
1273:
1274: FND_MESSAGE.Set_Name('PSB', 'PSB_PAT_JOB_CLASS_NAME');
1275: l_attribute_name := FND_MESSAGE.Get ;
1276:
1277: Begin
1278: select SYSTEM_ATTRIBUTE_TYPE,

Line 1275: l_attribute_name := FND_MESSAGE.Get ;

1271: Temp_ID := Null;
1272: Temp_Type := '';
1273:
1274: FND_MESSAGE.Set_Name('PSB', 'PSB_PAT_JOB_CLASS_NAME');
1275: l_attribute_name := FND_MESSAGE.Get ;
1276:
1277: Begin
1278: select SYSTEM_ATTRIBUTE_TYPE,
1279: ATTRIBUTE_ID

Line 1380: FND_MESSAGE.Set_Name('PSB', 'PSB_PAT_FTE_NAME');

1376:
1377: Temp_ID := Null;
1378: Temp_Type := '';
1379:
1380: FND_MESSAGE.Set_Name('PSB', 'PSB_PAT_FTE_NAME');
1381: l_attribute_name := FND_MESSAGE.Get ;
1382:
1383: Begin
1384: select SYSTEM_ATTRIBUTE_TYPE

Line 1381: l_attribute_name := FND_MESSAGE.Get ;

1377: Temp_ID := Null;
1378: Temp_Type := '';
1379:
1380: FND_MESSAGE.Set_Name('PSB', 'PSB_PAT_FTE_NAME');
1381: l_attribute_name := FND_MESSAGE.Get ;
1382:
1383: Begin
1384: select SYSTEM_ATTRIBUTE_TYPE
1385: , ATTRIBUTE_ID

Line 1486: FND_MESSAGE.Set_Name('PSB', 'PSB_PAT_ORGANIZATION_NAME');

1482:
1483: Temp_ID := Null;
1484: Temp_Type := '';
1485:
1486: FND_MESSAGE.Set_Name('PSB', 'PSB_PAT_ORGANIZATION_NAME');
1487: l_attribute_name := FND_MESSAGE.Get ;
1488:
1489: Begin
1490: select SYSTEM_ATTRIBUTE_TYPE

Line 1487: l_attribute_name := FND_MESSAGE.Get ;

1483: Temp_ID := Null;
1484: Temp_Type := '';
1485:
1486: FND_MESSAGE.Set_Name('PSB', 'PSB_PAT_ORGANIZATION_NAME');
1487: l_attribute_name := FND_MESSAGE.Get ;
1488:
1489: Begin
1490: select SYSTEM_ATTRIBUTE_TYPE
1491: , ATTRIBUTE_ID

Line 1615: FND_MESSAGE.Set_Name('PSB', 'PSB_PAT_HIRE_DATE_NAME');

1611:
1612: Temp_ID := Null;
1613: Temp_Type := '';
1614:
1615: FND_MESSAGE.Set_Name('PSB', 'PSB_PAT_HIRE_DATE_NAME');
1616: l_attribute_name := FND_MESSAGE.Get ;
1617:
1618: Begin
1619: select SYSTEM_ATTRIBUTE_TYPE

Line 1616: l_attribute_name := FND_MESSAGE.Get ;

1612: Temp_ID := Null;
1613: Temp_Type := '';
1614:
1615: FND_MESSAGE.Set_Name('PSB', 'PSB_PAT_HIRE_DATE_NAME');
1616: l_attribute_name := FND_MESSAGE.Get ;
1617:
1618: Begin
1619: select SYSTEM_ATTRIBUTE_TYPE
1620: , ATTRIBUTE_ID

Line 1720: FND_MESSAGE.Set_Name('PSB', 'PSB_PAT_ADJUSTMENT_DATE_NAME');

1716:
1717: Temp_ID := Null;
1718: Temp_Type := '';
1719:
1720: FND_MESSAGE.Set_Name('PSB', 'PSB_PAT_ADJUSTMENT_DATE_NAME');
1721: l_attribute_name := FND_MESSAGE.Get ;
1722:
1723: Begin
1724: select SYSTEM_ATTRIBUTE_TYPE

Line 1721: l_attribute_name := FND_MESSAGE.Get ;

1717: Temp_ID := Null;
1718: Temp_Type := '';
1719:
1720: FND_MESSAGE.Set_Name('PSB', 'PSB_PAT_ADJUSTMENT_DATE_NAME');
1721: l_attribute_name := FND_MESSAGE.Get ;
1722:
1723: Begin
1724: select SYSTEM_ATTRIBUTE_TYPE
1725: into Temp_Type

Line 1816: FND_MESSAGE.Set_Name('PSB', 'PSB_PAT_DFLT_WEEKLY_HOURS_NAME');

1812:
1813: Temp_ID := Null;
1814: Temp_Type := '';
1815:
1816: FND_MESSAGE.Set_Name('PSB', 'PSB_PAT_DFLT_WEEKLY_HOURS_NAME');
1817: l_attribute_name := FND_MESSAGE.Get ;
1818:
1819: Begin
1820: select SYSTEM_ATTRIBUTE_TYPE

Line 1817: l_attribute_name := FND_MESSAGE.Get ;

1813: Temp_ID := Null;
1814: Temp_Type := '';
1815:
1816: FND_MESSAGE.Set_Name('PSB', 'PSB_PAT_DFLT_WEEKLY_HOURS_NAME');
1817: l_attribute_name := FND_MESSAGE.Get ;
1818:
1819: Begin
1820: select SYSTEM_ATTRIBUTE_TYPE
1821: , ATTRIBUTE_ID

Line 1964: FND_MESSAGE.Set_Name('PSB', 'PSB_PAT_JOB_CLASS_NAME');

1960: RETURN varchar2 IS
1961: l_attribute_name varchar2(2000);
1962: BEGIN
1963: IF p_sys_attribute_type = 'JOB_CLASS' THEN
1964: FND_MESSAGE.Set_Name('PSB', 'PSB_PAT_JOB_CLASS_NAME');
1965: l_attribute_name := FND_MESSAGE.get;
1966: ELSIF
1967: -- for fte
1968: p_sys_attribute_type = 'FTE' THEN

Line 1965: l_attribute_name := FND_MESSAGE.get;

1961: l_attribute_name varchar2(2000);
1962: BEGIN
1963: IF p_sys_attribute_type = 'JOB_CLASS' THEN
1964: FND_MESSAGE.Set_Name('PSB', 'PSB_PAT_JOB_CLASS_NAME');
1965: l_attribute_name := FND_MESSAGE.get;
1966: ELSIF
1967: -- for fte
1968: p_sys_attribute_type = 'FTE' THEN
1969: FND_MESSAGE.Set_Name('PSB', 'PSB_PAT_FTE_NAME');

Line 1969: FND_MESSAGE.Set_Name('PSB', 'PSB_PAT_FTE_NAME');

1965: l_attribute_name := FND_MESSAGE.get;
1966: ELSIF
1967: -- for fte
1968: p_sys_attribute_type = 'FTE' THEN
1969: FND_MESSAGE.Set_Name('PSB', 'PSB_PAT_FTE_NAME');
1970: l_attribute_name := FND_MESSAGE.get;
1971:
1972: ELSIF
1973: -- for organization

Line 1970: l_attribute_name := FND_MESSAGE.get;

1966: ELSIF
1967: -- for fte
1968: p_sys_attribute_type = 'FTE' THEN
1969: FND_MESSAGE.Set_Name('PSB', 'PSB_PAT_FTE_NAME');
1970: l_attribute_name := FND_MESSAGE.get;
1971:
1972: ELSIF
1973: -- for organization
1974: p_sys_attribute_type = 'ORG' THEN

Line 1975: FND_MESSAGE.Set_Name('PSB', 'PSB_PAT_ORGANIZATION_NAME');

1971:
1972: ELSIF
1973: -- for organization
1974: p_sys_attribute_type = 'ORG' THEN
1975: FND_MESSAGE.Set_Name('PSB', 'PSB_PAT_ORGANIZATION_NAME');
1976: l_attribute_name := FND_MESSAGE.get;
1977:
1978: ELSIF
1979: -- for hire Date

Line 1976: l_attribute_name := FND_MESSAGE.get;

1972: ELSIF
1973: -- for organization
1974: p_sys_attribute_type = 'ORG' THEN
1975: FND_MESSAGE.Set_Name('PSB', 'PSB_PAT_ORGANIZATION_NAME');
1976: l_attribute_name := FND_MESSAGE.get;
1977:
1978: ELSIF
1979: -- for hire Date
1980: p_sys_attribute_type = 'HIREDATE' THEN

Line 1981: FND_MESSAGE.Set_Name('PSB', 'PSB_PAT_HIRE_DATE_NAME');

1977:
1978: ELSIF
1979: -- for hire Date
1980: p_sys_attribute_type = 'HIREDATE' THEN
1981: FND_MESSAGE.Set_Name('PSB', 'PSB_PAT_HIRE_DATE_NAME');
1982: l_attribute_name := FND_MESSAGE.get;
1983:
1984: ELSIF
1985: -- for adjustment date

Line 1982: l_attribute_name := FND_MESSAGE.get;

1978: ELSIF
1979: -- for hire Date
1980: p_sys_attribute_type = 'HIREDATE' THEN
1981: FND_MESSAGE.Set_Name('PSB', 'PSB_PAT_HIRE_DATE_NAME');
1982: l_attribute_name := FND_MESSAGE.get;
1983:
1984: ELSIF
1985: -- for adjustment date
1986: p_sys_attribute_type = 'ADJUSTMENT_DATE' THEN

Line 1987: FND_MESSAGE.Set_Name('PSB', 'PSB_PAT_ADJUSTMENT_DATE_NAME');

1983:
1984: ELSIF
1985: -- for adjustment date
1986: p_sys_attribute_type = 'ADJUSTMENT_DATE' THEN
1987: FND_MESSAGE.Set_Name('PSB', 'PSB_PAT_ADJUSTMENT_DATE_NAME');
1988: l_attribute_name := FND_MESSAGE.get;
1989:
1990: ELSIF
1991: -- for default weekly hours

Line 1988: l_attribute_name := FND_MESSAGE.get;

1984: ELSIF
1985: -- for adjustment date
1986: p_sys_attribute_type = 'ADJUSTMENT_DATE' THEN
1987: FND_MESSAGE.Set_Name('PSB', 'PSB_PAT_ADJUSTMENT_DATE_NAME');
1988: l_attribute_name := FND_MESSAGE.get;
1989:
1990: ELSIF
1991: -- for default weekly hours
1992: p_sys_attribute_type = 'DEFAULT_WEEKLY_HOURS' THEN

Line 1993: FND_MESSAGE.Set_Name('PSB', 'PSB_PAT_DFLT_WEEKLY_HOURS_NAME');

1989:
1990: ELSIF
1991: -- for default weekly hours
1992: p_sys_attribute_type = 'DEFAULT_WEEKLY_HOURS' THEN
1993: FND_MESSAGE.Set_Name('PSB', 'PSB_PAT_DFLT_WEEKLY_HOURS_NAME');
1994: l_attribute_name := FND_MESSAGE.get;
1995: END IF;
1996:
1997: RETURN l_attribute_name;

Line 1994: l_attribute_name := FND_MESSAGE.get;

1990: ELSIF
1991: -- for default weekly hours
1992: p_sys_attribute_type = 'DEFAULT_WEEKLY_HOURS' THEN
1993: FND_MESSAGE.Set_Name('PSB', 'PSB_PAT_DFLT_WEEKLY_HOURS_NAME');
1994: l_attribute_name := FND_MESSAGE.get;
1995: END IF;
1996:
1997: RETURN l_attribute_name;
1998: END GET_TRANSLATED_NAME;