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 1400: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_HEADER_ID_INVALID');

1396:
1397: IF p_source_mr_header_id is null or
1398: p_source_mr_header_id=FND_API.G_MISS_NUM
1399: THEN
1400: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_HEADER_ID_INVALID');
1401: FND_MSG_PUB.ADD;
1402: l_check_flag:='N';
1403: ELSE
1404: open GetHeaderInfo(p_source_mr_header_id);

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

1413: l_upd_mr_status_code:='APPROVAL_PENDING';
1414:
1415: IF trunc(l_mr_Rec.effective_from) 1416: THEN
1417: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_ST_DATE_LESSER_SYSDATE');
1418: FND_MSG_PUB.ADD;
1419: END IF;
1420:
1421: If l_mr_rec.MR_STATUS_CODE<>'DRAFT'

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

1420:
1421: If l_mr_rec.MR_STATUS_CODE<>'DRAFT'
1422: AND l_mr_rec.MR_STATUS_CODE<>'APPROVAL_REJECTED'
1423: Then
1424: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_CANNOT_APRV');
1425: FND_MSG_PUB.ADD;
1426: End if;
1427: ElsIf P_APPRV_TYPE='TERMINATE'
1428: Then

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

1468: --l_contract_ref_exists:=FND_API.G_MISS_CHAR; -- TEMP CHECK
1469:
1470: IF l_contract_ref_exists='Y'
1471: THEN
1472: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_CONTRACTS_EXIST');
1473: FND_MESSAGE.SET_TOKEN('MRTITLE',l_mr_Rec.TITLE);
1474: FND_MSG_PUB.ADD;
1475:
1476: IF G_DEBUG='Y' THEN

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

1469:
1470: IF l_contract_ref_exists='Y'
1471: THEN
1472: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_CONTRACTS_EXIST');
1473: FND_MESSAGE.SET_TOKEN('MRTITLE',l_mr_Rec.TITLE);
1474: FND_MSG_PUB.ADD;
1475:
1476: IF G_DEBUG='Y' THEN
1477: AHL_DEBUG_PUB.debug( 'l_contract_ref_exists---->'||l_contract_ref_exists);

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

1478: END IF;
1479:
1480: ELSIF l_contract_ref_exists IS NULL OR l_contract_ref_exists=FND_API.G_MISS_CHAR
1481: THEN
1482: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_INVALID_RET_PARAM');
1483: FND_MSG_PUB.ADD;
1484:
1485: IF G_DEBUG='Y' THEN
1486: AHL_DEBUG_PUB.debug( 'l_contract_ref_exists----> is either null or g_misschar'||l_contract_ref_exists);

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

1498: If l_mr_rec.MR_STATUS_CODE<>'COMPLETE' OR
1499: (l_mr_rec.EFFECTIVE_TO IS NOT NULL
1500: AND l_mr_rec.EFFECTIVE_TO<>FND_API.G_MISS_DATE)
1501: Then
1502: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_CANNOT_TERMIN');
1503: FND_MSG_PUB.ADD;
1504: End if;
1505: End If;
1506: -- If mr_header_id is invalid or not found

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

1505: End If;
1506: -- If mr_header_id is invalid or not found
1507: ElsIf GetHeaderInfo%NOTFOUND
1508: Then
1509: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_HEADER_ID_INVALID');
1510: FND_MSG_PUB.ADD;
1511: l_check_flag:='N';
1512: End If;
1513: Close GetHeaderInfo;

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

1527: If GetHeaderInfo1%FOUND
1528: Then
1529: If trunc(l_mr_Rec.effective_from) < trunc(l_mr_Rec1.effective_from)
1530: TheN
1531: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_ST_DATE_LESSER');
1532: FND_MESSAGE.SET_TOKEN('FIELD',l_mr_Rec1.effective_from);
1533: FND_MSG_PUB.ADD;
1534: End If;
1535: End If;

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

1528: Then
1529: If trunc(l_mr_Rec.effective_from) < trunc(l_mr_Rec1.effective_from)
1530: TheN
1531: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_ST_DATE_LESSER');
1532: FND_MESSAGE.SET_TOKEN('FIELD',l_mr_Rec1.effective_from);
1533: FND_MSG_PUB.ADD;
1534: End If;
1535: End If;
1536: Close GetHeaderInfo1;

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

1547: If G_APPLN_USAGE='PM' and l_mr_Rec.type_code<>'PROGRAM'
1548: Then
1549: If l_counter=0
1550: TheN
1551: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_INIT_APPRV_ABORT');
1552: FND_MSG_PUB.ADD;
1553: End If;
1554: ElsIf G_APPLN_USAGE<>'PM'
1555: Then

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

1554: ElsIf G_APPLN_USAGE<>'PM'
1555: Then
1556: IF l_counter=0
1557: Then
1558: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_INIT_APPRV_ABORT');
1559: FND_MSG_PUB.ADD;
1560: End If;
1561: End If;
1562:

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

1571: And Title=l_mr_rec.title
1572: And Version_number >l_mr_rec.version_number;
1573: IF l_counter>0
1574: Then
1575: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_TERMIN_OLD');
1576: FND_MESSAGE.SET_TOKEN('TITLE',l_mr_Rec.TITLE);
1577: FND_MSG_PUB.ADD;
1578: End If;
1579: IF l_mr_rec.effective_to IS NOT NULL

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

1572: And Version_number >l_mr_rec.version_number;
1573: IF l_counter>0
1574: Then
1575: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_TERMIN_OLD');
1576: FND_MESSAGE.SET_TOKEN('TITLE',l_mr_Rec.TITLE);
1577: FND_MSG_PUB.ADD;
1578: End If;
1579: IF l_mr_rec.effective_to IS NOT NULL
1580: Then

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

1577: FND_MSG_PUB.ADD;
1578: End If;
1579: IF l_mr_rec.effective_to IS NOT NULL
1580: Then
1581: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_TERMINATED');
1582: FND_MESSAGE.SET_TOKEN('TITLE',l_mr_Rec.title);
1583: FND_MSG_PUB.ADD;
1584: End If;
1585: End if;

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

1578: End If;
1579: IF l_mr_rec.effective_to IS NOT NULL
1580: Then
1581: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_TERMINATED');
1582: FND_MESSAGE.SET_TOKEN('TITLE',l_mr_Rec.title);
1583: FND_MSG_PUB.ADD;
1584: End If;
1585: End if;
1586: */

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

1626: And OBJECT_VERSION_NUMBER=p_object_Version_number;
1627:
1628: IF sql%rowcount=0
1629: THEN
1630: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
1631: FND_MSG_PUB.ADD;
1632: ELSE
1633:
1634: Ahl_generic_aprv_pvt.Start_Wf_Process(

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

1655: AND OBJECT_VERSION_NUMBER=p_object_Version_number;
1656:
1657: IF sql%rowcount=0
1658: THEN
1659: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
1660: FND_MSG_PUB.ADD;
1661: END IF;
1662:
1663: AHL_FMP_MR_REVISION_PVT.COMPLETE_MR_REVISION

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

2167: SAVEPOINT VALIDATE_MR_REVISION;
2168:
2169: IF G_APPLN_USAGE IS NULL
2170: THEN
2171: FND_MESSAGE.SET_NAME('AHL','AHL_COM_APP_PRFL_UNDEF');
2172: FND_MSG_PUB.ADD;
2173: RETURN;
2174: END IF;
2175:

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

2181: Where mr_header_id=p_source_mr_header_id;
2182:
2183: IF l_counter1=0
2184: THEN
2185: FND_MESSAGE.SET_NAME('AHL','AHL_MR_HEADER_ID_INVALID');
2186: FND_MSG_PUB.ADD;
2187: END IF;
2188:
2189: SELECT count(*) into l_counter2

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

2192: And mr_status_code='DRAFT' or mr_status_code='APPROVAL_REJECTED';
2193:
2194: IF l_counter2=0
2195: THEN
2196: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
2197: FND_MSG_PUB.ADD;
2198: END IF;
2199:
2200: EXCEPTION