DBA Data[Home] [Help]

APPS.AHL_FMP_MR_REVISION_PVT dependencies on FND_MESSAGE

Line 63: FND_MESSAGE.SET_NAME('AHL','AHL_COM_APP_PRFL_UNDEF');

59: END IF;
60:
61: IF g_appln_usage is null
62: THEN
63: FND_MESSAGE.SET_NAME('AHL','AHL_COM_APP_PRFL_UNDEF');
64: FND_MSG_PUB.ADD;
65: RETURN;
66: ELSIF (g_appln_usage = 'PM')
67: THEN

Line 68: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_PM_MRR_PM_INSTALL');

64: FND_MSG_PUB.ADD;
65: RETURN;
66: ELSIF (g_appln_usage = 'PM')
67: THEN
68: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_PM_MRR_PM_INSTALL');
69: FND_MSG_PUB.ADD;
70: RETURN;
71: END IF;
72:

Line 84: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_CANNOT_CREATE_REV');

80: IF SQL%ROWCOUNT>0
81: THEN
82: IF l_status<>'COMPLETE'
83: THEN
84: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_CANNOT_CREATE_REV');
85: FND_MESSAGE.SET_TOKEN('RECORD',l_title,false);
86: FND_MSG_PUB.ADD;
87: l_check_flag:='N';
88: ELSE

Line 85: FND_MESSAGE.SET_TOKEN('RECORD',l_title,false);

81: THEN
82: IF l_status<>'COMPLETE'
83: THEN
84: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_CANNOT_CREATE_REV');
85: FND_MESSAGE.SET_TOKEN('RECORD',l_title,false);
86: FND_MSG_PUB.ADD;
87: l_check_flag:='N';
88: ELSE
89: l_check_flag:='Y';

Line 101: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_REVISION_CREATED');

97: IF CheckAnyExistingMr%FOUND
98: THEN
99: IF l_counter>0
100: THEN
101: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_REVISION_CREATED');
102: FND_MESSAGE.SET_TOKEN('RECORD',l_title,false);
103: FND_MSG_PUB.ADD;
104: l_check_flag:='N';
105: END IF;

Line 102: FND_MESSAGE.SET_TOKEN('RECORD',l_title,false);

98: THEN
99: IF l_counter>0
100: THEN
101: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_REVISION_CREATED');
102: FND_MESSAGE.SET_TOKEN('RECORD',l_title,false);
103: FND_MSG_PUB.ADD;
104: l_check_flag:='N';
105: END IF;
106: END IF;

Line 119: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_NOT_LATEST');

115: IF CheckCurrentlyActive%FOUND
116: THEN
117: IF l_counter>0
118: THEN
119: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_NOT_LATEST');
120: FND_MSG_PUB.ADD;
121: END IF;
122: END IF;
123: CLOSE CheckCurrentlyActive;

Line 1794: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_HEADER_ID_INVALID');

1790:
1791: IF p_source_mr_header_id is null or
1792: p_source_mr_header_id=FND_API.G_MISS_NUM
1793: THEN
1794: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_HEADER_ID_INVALID');
1795: FND_MSG_PUB.ADD;
1796: l_check_flag:='N';
1797: ELSE
1798: open GetHeaderInfo(p_source_mr_header_id);

Line 1811: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_ST_DATE_LESSER_SYSDATE');

1807: l_upd_mr_status_code:='APPROVAL_PENDING';
1808:
1809: IF trunc(l_mr_Rec.effective_from) 1810: THEN
1811: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_ST_DATE_LESSER_SYSDATE');
1812: FND_MSG_PUB.ADD;
1813: END IF;
1814:
1815: If l_mr_rec.MR_STATUS_CODE<>'DRAFT'

Line 1818: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_CANNOT_APRV');

1814:
1815: If l_mr_rec.MR_STATUS_CODE<>'DRAFT'
1816: AND l_mr_rec.MR_STATUS_CODE<>'APPROVAL_REJECTED'
1817: Then
1818: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_CANNOT_APRV');
1819: FND_MSG_PUB.ADD;
1820: End if;
1821: ElsIf P_APPRV_TYPE='TERMINATE'
1822: Then

Line 1866: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_CONTRACTS_EXIST');

1862: --l_contract_ref_exists:=FND_API.G_MISS_CHAR; -- TEMP CHECK
1863:
1864: IF l_contract_ref_exists='Y'
1865: THEN
1866: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_CONTRACTS_EXIST');
1867: FND_MESSAGE.SET_TOKEN('MRTITLE',l_mr_Rec.TITLE);
1868: FND_MSG_PUB.ADD;
1869:
1870: IF G_DEBUG='Y' THEN

Line 1867: FND_MESSAGE.SET_TOKEN('MRTITLE',l_mr_Rec.TITLE);

1863:
1864: IF l_contract_ref_exists='Y'
1865: THEN
1866: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_CONTRACTS_EXIST');
1867: FND_MESSAGE.SET_TOKEN('MRTITLE',l_mr_Rec.TITLE);
1868: FND_MSG_PUB.ADD;
1869:
1870: IF G_DEBUG='Y' THEN
1871: AHL_DEBUG_PUB.debug( 'l_contract_ref_exists---->'||l_contract_ref_exists);

Line 1876: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_INVALID_RET_PARAM');

1872: END IF;
1873:
1874: ELSIF l_contract_ref_exists IS NULL OR l_contract_ref_exists=FND_API.G_MISS_CHAR
1875: THEN
1876: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_INVALID_RET_PARAM');
1877: FND_MSG_PUB.ADD;
1878:
1879: IF G_DEBUG='Y' THEN
1880: AHL_DEBUG_PUB.debug( 'l_contract_ref_exists----> is either null or g_misschar'||l_contract_ref_exists);

Line 1896: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_CANNOT_TERMIN');

1892: If l_mr_rec.MR_STATUS_CODE<>'COMPLETE' OR
1893: (l_mr_rec.EFFECTIVE_TO IS NOT NULL
1894: AND l_mr_rec.EFFECTIVE_TO<>FND_API.G_MISS_DATE)
1895: Then
1896: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_CANNOT_TERMIN');
1897: FND_MSG_PUB.ADD;
1898: End if;
1899: End If;
1900: -- If mr_header_id is invalid or not found

Line 1903: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_HEADER_ID_INVALID');

1899: End If;
1900: -- If mr_header_id is invalid or not found
1901: ElsIf GetHeaderInfo%NOTFOUND
1902: Then
1903: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_HEADER_ID_INVALID');
1904: FND_MSG_PUB.ADD;
1905: l_check_flag:='N';
1906: End If;
1907: Close GetHeaderInfo;

Line 1925: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_ST_DATE_LESSER');

1921: If GetHeaderInfo1%FOUND
1922: Then
1923: If trunc(l_mr_Rec.effective_from) < trunc(l_mr_Rec1.effective_from)
1924: TheN
1925: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_ST_DATE_LESSER');
1926: FND_MESSAGE.SET_TOKEN('FIELD',l_mr_Rec1.effective_from);
1927: FND_MSG_PUB.ADD;
1928: End If;
1929: End If;

Line 1926: FND_MESSAGE.SET_TOKEN('FIELD',l_mr_Rec1.effective_from);

1922: Then
1923: If trunc(l_mr_Rec.effective_from) < trunc(l_mr_Rec1.effective_from)
1924: TheN
1925: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_ST_DATE_LESSER');
1926: FND_MESSAGE.SET_TOKEN('FIELD',l_mr_Rec1.effective_from);
1927: FND_MSG_PUB.ADD;
1928: End If;
1929: End If;
1930: Close GetHeaderInfo1;

Line 1945: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_INIT_APPRV_ABORT');

1941: If G_APPLN_USAGE='PM' and l_mr_Rec.type_code<>'PROGRAM'
1942: Then
1943: If l_counter=0
1944: TheN
1945: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_INIT_APPRV_ABORT');
1946: FND_MSG_PUB.ADD;
1947: End If;
1948: ElsIf G_APPLN_USAGE<>'PM'
1949: Then

Line 1952: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_INIT_APPRV_ABORT');

1948: ElsIf G_APPLN_USAGE<>'PM'
1949: Then
1950: IF l_counter=0
1951: Then
1952: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_INIT_APPRV_ABORT');
1953: FND_MSG_PUB.ADD;
1954: End If;
1955: End If;
1956:

Line 1969: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_TERMIN_OLD');

1965: And Title=l_mr_rec.title
1966: And Version_number >l_mr_rec.version_number;
1967: IF l_counter>0
1968: Then
1969: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_TERMIN_OLD');
1970: FND_MESSAGE.SET_TOKEN('TITLE',l_mr_Rec.TITLE);
1971: FND_MSG_PUB.ADD;
1972: End If;
1973: IF l_mr_rec.effective_to IS NOT NULL

Line 1970: FND_MESSAGE.SET_TOKEN('TITLE',l_mr_Rec.TITLE);

1966: And Version_number >l_mr_rec.version_number;
1967: IF l_counter>0
1968: Then
1969: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_TERMIN_OLD');
1970: FND_MESSAGE.SET_TOKEN('TITLE',l_mr_Rec.TITLE);
1971: FND_MSG_PUB.ADD;
1972: End If;
1973: IF l_mr_rec.effective_to IS NOT NULL
1974: Then

Line 1975: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_TERMINATED');

1971: FND_MSG_PUB.ADD;
1972: End If;
1973: IF l_mr_rec.effective_to IS NOT NULL
1974: Then
1975: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_TERMINATED');
1976: FND_MESSAGE.SET_TOKEN('TITLE',l_mr_Rec.title);
1977: FND_MSG_PUB.ADD;
1978: End If;
1979: End if;

Line 1976: FND_MESSAGE.SET_TOKEN('TITLE',l_mr_Rec.title);

1972: End If;
1973: IF l_mr_rec.effective_to IS NOT NULL
1974: Then
1975: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_TERMINATED');
1976: FND_MESSAGE.SET_TOKEN('TITLE',l_mr_Rec.title);
1977: FND_MSG_PUB.ADD;
1978: End If;
1979: End if;
1980: */

Line 2024: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');

2020: And OBJECT_VERSION_NUMBER=p_object_Version_number;
2021:
2022: IF sql%rowcount=0
2023: THEN
2024: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
2025: FND_MSG_PUB.ADD;
2026: ELSE
2027:
2028: Ahl_generic_aprv_pvt.Start_Wf_Process(

Line 2053: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');

2049: AND OBJECT_VERSION_NUMBER=p_object_Version_number;
2050:
2051: IF sql%rowcount=0
2052: THEN
2053: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
2054: FND_MSG_PUB.ADD;
2055: END IF;
2056:
2057: AHL_FMP_MR_REVISION_PVT.COMPLETE_MR_REVISION

Line 2706: FND_MESSAGE.SET_NAME('AHL','AHL_COM_APP_PRFL_UNDEF');

2702: SAVEPOINT VALIDATE_MR_REVISION;
2703:
2704: IF G_APPLN_USAGE IS NULL
2705: THEN
2706: FND_MESSAGE.SET_NAME('AHL','AHL_COM_APP_PRFL_UNDEF');
2707: FND_MSG_PUB.ADD;
2708: RETURN;
2709: END IF;
2710:

Line 2720: FND_MESSAGE.SET_NAME('AHL','AHL_MR_HEADER_ID_INVALID');

2716: Where mr_header_id=p_source_mr_header_id;
2717:
2718: IF l_counter1=0
2719: THEN
2720: FND_MESSAGE.SET_NAME('AHL','AHL_MR_HEADER_ID_INVALID');
2721: FND_MSG_PUB.ADD;
2722: END IF;
2723:
2724: SELECT count(*) into l_counter2

Line 2731: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');

2727: And mr_status_code='DRAFT' or mr_status_code='APPROVAL_REJECTED';
2728:
2729: IF l_counter2=0
2730: THEN
2731: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
2732: FND_MSG_PUB.ADD;
2733: END IF;
2734:
2735: EXCEPTION