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.AHL_FMP_MR_REVISION_PVT dependencies on FND_MSG_PUB

Line 64: FND_MSG_PUB.ADD;

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

Line 69: 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:
73:

Line 86: FND_MSG_PUB.ADD;

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';
90: END IF;

Line 103: FND_MSG_PUB.ADD;

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;
107: CLOSE CheckAnyExistingMr;

Line 120: FND_MSG_PUB.ADD;

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;
124: END IF;

Line 130: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

126:
127: EXCEPTION
128: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
129: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
130: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
131: p_count => x_msg_count,
132: p_data => x_msg_data);
133: IF G_DEBUG='Y' THEN
134: AHL_DEBUG_PUB.disable_debug;

Line 138: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

134: AHL_DEBUG_PUB.disable_debug;
135: END IF;
136: WHEN FND_API.G_EXC_ERROR THEN
137: X_return_status := FND_API.G_RET_STS_ERROR;
138: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
139: p_count => x_msg_count,
140: p_data => X_msg_data);
141: IF G_DEBUG='Y' THEN
142: AHL_DEBUG_PUB.disable_debug;

Line 147: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

143: END IF;
144:
145: WHEN OTHERS THEN
146: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
147: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
148: THEN
149: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_FMP_MR_REVISION_PVT',
150: p_procedure_name => 'VALIDATE_MR_REV',
151: p_error_text => SUBSTR(SQLERRM,1,240));

Line 149: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_FMP_MR_REVISION_PVT',

145: WHEN OTHERS THEN
146: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
147: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
148: THEN
149: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_FMP_MR_REVISION_PVT',
150: p_procedure_name => 'VALIDATE_MR_REV',
151: p_error_text => SUBSTR(SQLERRM,1,240));
152: END IF;
153: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

Line 153: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

149: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_FMP_MR_REVISION_PVT',
150: p_procedure_name => 'VALIDATE_MR_REV',
151: p_error_text => SUBSTR(SQLERRM,1,240));
152: END IF;
153: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
154: p_count => x_msg_count,
155: p_data => X_msg_data);
156:
157: IF G_DEBUG='Y' THEN

Line 763: FND_MSG_PUB.initialize;

759:
760: -- Standard call to check for call compatibility.
761:
762: IF FND_API.to_boolean(p_init_msg_list) THEN
763: FND_MSG_PUB.initialize;
764: END IF;
765:
766: -- Initialize API return status to success
767:

Line 786: l_msg_count := FND_MSG_PUB.count_msg;

782: x_msg_data =>l_msg_data,
783: p_source_mr_header_id =>p_source_mr_header_id
784: );
785:
786: l_msg_count := FND_MSG_PUB.count_msg;
787:
788: IF l_msg_count > 0 THEN
789: X_msg_count := l_msg_count;
790: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1631: l_msg_count := FND_MSG_PUB.count_msg;

1627: l_loop_chain_rel_rec.ATTRIBUTE14,
1628: l_loop_chain_rel_rec.ATTRIBUTE15);
1629: END LOOP;
1630: ---Changes for SBE loop/Chain Ends.
1631: l_msg_count := FND_MSG_PUB.count_msg;
1632:
1633: IF l_msg_count > 0 OR x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1634: X_msg_count := l_msg_count;
1635: X_return_status := FND_API.G_RET_STS_ERROR;

Line 1654: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

1650: EXCEPTION
1651: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1652: ROLLBACK TO CREATE_MR_REVISION_PVT;
1653: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1654: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1655: p_count => x_msg_count,
1656: p_data => x_msg_data);
1657: IF G_DEBUG='Y' THEN
1658: AHL_DEBUG_PUB.DEBUG('CREATION OF MR_REVISION IS NOT COMPLETE');

Line 1666: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

1662:
1663: WHEN FND_API.G_EXC_ERROR THEN
1664: ROLLBACK TO CREATE_MR_REVISION_PVT;
1665: X_return_status := FND_API.G_RET_STS_ERROR;
1666: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1667: p_count => x_msg_count,
1668: p_data => X_msg_data);
1669: IF G_DEBUG='Y' THEN
1670: AHL_DEBUG_PUB.DEBUG('CREATION OF MR_REVISION IS NOT COMPLETE');

Line 1677: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1673:
1674: WHEN OTHERS THEN
1675: ROLLBACK TO CREATE_MR_REVISION_PVT;
1676: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1677: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1678: THEN
1679: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_FMP_MR_REVISION_PVT',
1680: p_procedure_name => 'CREATE_MR_REVISION',
1681: p_error_text => SUBSTR(SQLERRM,1,240));

Line 1679: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_FMP_MR_REVISION_PVT',

1675: ROLLBACK TO CREATE_MR_REVISION_PVT;
1676: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1677: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1678: THEN
1679: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_FMP_MR_REVISION_PVT',
1680: p_procedure_name => 'CREATE_MR_REVISION',
1681: p_error_text => SUBSTR(SQLERRM,1,240));
1682: END IF;
1683: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

Line 1683: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

1679: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_FMP_MR_REVISION_PVT',
1680: p_procedure_name => 'CREATE_MR_REVISION',
1681: p_error_text => SUBSTR(SQLERRM,1,240));
1682: END IF;
1683: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1684: p_count => x_msg_count,
1685: p_data => X_msg_data);
1686: IF G_DEBUG='Y' THEN
1687: AHL_DEBUG_PUB.DEBUG('CREATION OF MR_REVISION IS NOT COMPLETE');

Line 1771: FND_MSG_PUB.initialize;

1767: AHL_DEBUG_PUB.debug( 'Start Initiate_MR_Approval');
1768: END IF;
1769:
1770: IF FND_API.to_boolean(l_init_msg_list) THEN
1771: FND_MSG_PUB.initialize;
1772: END IF;
1773:
1774:
1775: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1795: FND_MSG_PUB.ADD;

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);
1799:

Line 1812: FND_MSG_PUB.ADD;

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'
1816: AND l_mr_rec.MR_STATUS_CODE<>'APPROVAL_REJECTED'

Line 1819: FND_MSG_PUB.ADD;

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
1823: IF G_APPLN_USAGE='PM'

Line 1868: FND_MSG_PUB.ADD;

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);
1872: END IF;

Line 1877: FND_MSG_PUB.ADD;

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);
1881: END IF;

Line 1897: FND_MSG_PUB.ADD;

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
1901: ElsIf GetHeaderInfo%NOTFOUND

Line 1904: FND_MSG_PUB.ADD;

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;
1908: End If;

Line 1927: FND_MSG_PUB.ADD;

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;
1931: End if;

Line 1946: FND_MSG_PUB.ADD;

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
1950: IF l_counter=0

Line 1953: FND_MSG_PUB.ADD;

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:
1957: End If;

Line 1971: FND_MSG_PUB.ADD;

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

Line 1977: FND_MSG_PUB.ADD;

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: */
1981: l_msg_count := FND_MSG_PUB.count_msg;

Line 1981: l_msg_count := FND_MSG_PUB.count_msg;

1977: FND_MSG_PUB.ADD;
1978: End If;
1979: End if;
1980: */
1981: l_msg_count := FND_MSG_PUB.count_msg;
1982:
1983: If G_DEBUG='Y' THEN
1984: AHL_DEBUG_PUB.debug( 'Check Error l_msg_count:'||l_msg_count);
1985: End If;

Line 2025: FND_MSG_PUB.ADD;

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(
2029: P_OBJECT =>l_object,

Line 2054: FND_MSG_PUB.ADD;

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
2058: (

Line 2076: l_msg_count := FND_MSG_PUB.count_msg;

2072: );
2073:
2074: END IF;
2075:
2076: l_msg_count := FND_MSG_PUB.count_msg;
2077:
2078: IF l_msg_count > 0
2079: THEN
2080: X_msg_count := l_msg_count;

Line 2094: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

2090: EXCEPTION
2091: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2092: ROLLBACK TO INITIATE_MR_APPROVAL_PVT;
2093: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2094: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
2095: p_count => x_msg_count,
2096: p_data => x_msg_data);
2097: IF G_DEBUG='Y' THEN
2098: AHL_DEBUG_PUB.disable_debug;

Line 2105: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

2101:
2102: WHEN FND_API.G_EXC_ERROR THEN
2103: ROLLBACK TO INITIATE_MR_APPROVAL_PVT;
2104: X_return_status := FND_API.G_RET_STS_ERROR;
2105: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
2106: p_count => x_msg_count,
2107: p_data => X_msg_data);
2108: IF G_DEBUG='Y' THEN
2109: AHL_DEBUG_PUB.disable_debug;

Line 2115: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2111:
2112: WHEN OTHERS THEN
2113: ROLLBACK TO INITIATE_MR_APPROVAL_PVT;
2114: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2115: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2116: THEN
2117: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_FMP_MR_REVISION_PVT',
2118: p_procedure_name => 'INITIATE_MR_APPROVAL',
2119: p_error_text => SUBSTR(SQLERRM,1,240));

Line 2117: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_FMP_MR_REVISION_PVT',

2113: ROLLBACK TO INITIATE_MR_APPROVAL_PVT;
2114: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2115: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2116: THEN
2117: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_FMP_MR_REVISION_PVT',
2118: p_procedure_name => 'INITIATE_MR_APPROVAL',
2119: p_error_text => SUBSTR(SQLERRM,1,240));
2120: END IF;
2121: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

Line 2121: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

2117: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_FMP_MR_REVISION_PVT',
2118: p_procedure_name => 'INITIATE_MR_APPROVAL',
2119: p_error_text => SUBSTR(SQLERRM,1,240));
2120: END IF;
2121: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
2122: p_count => x_msg_count,
2123: p_data => X_msg_data);
2124: IF G_DEBUG='Y' THEN
2125: AHL_DEBUG_PUB.disable_debug;

Line 2352: IF FND_MSG_PUB.count_msg > 0

2348: x_return_status =>x_return_Status,
2349: x_msg_count =>l_msg_count,
2350: x_msg_data =>l_msg_data);
2351:
2352: IF FND_MSG_PUB.count_msg > 0
2353: THEN
2354: IF G_DEBUG='Y' THEN
2355: AHL_DEBUG_PUB.debug( 'Terminate inst fail');
2356: END IF;

Line 2518: IF FND_MSG_PUB.count_msg > 0

2514: THEN
2515: IF l_check_flag2='Y' AND l_check_flag='Y'
2516: THEN
2517:
2518: IF FND_MSG_PUB.count_msg > 0
2519: THEN
2520: IF G_DEBUG='Y' THEN
2521: AHL_DEBUG_PUB.debug( 'Error Before TerminateInstances');
2522: END IF;

Line 2598: IF FND_MSG_PUB.count_msg > 0

2594:
2595: END IF;
2596: END IF;
2597:
2598: IF FND_MSG_PUB.count_msg > 0
2599: THEN
2600:
2601: IF G_DEBUG='Y' THEN
2602: AHL_DEBUG_PUB.debug( 'Terminate inst fail');

Line 2611: l_msg_count := FND_MSG_PUB.count_msg;

2607: END IF;
2608: END IF;
2609: END IF;
2610:
2611: l_msg_count := FND_MSG_PUB.count_msg;
2612: IF l_msg_count > 0
2613: THEN
2614: IF G_DEBUG='Y' THEN
2615: AHL_DEBUG_PUB.debug( 'Failed To Complete:');

Line 2647: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

2643: EXCEPTION
2644: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2645: ROLLBACK TO COMPLETE_MR_REVISION_PVT;
2646: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2647: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
2648: p_count => x_msg_count,
2649: p_data => x_msg_data);
2650: IF G_DEBUG='Y' THEN
2651: AHL_DEBUG_PUB.disable_debug;

Line 2656: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

2652: END IF;
2653: WHEN FND_API.G_EXC_ERROR THEN
2654: ROLLBACK TO COMPLETE_MR_REVISION_PVT;
2655: X_return_status := FND_API.G_RET_STS_ERROR;
2656: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
2657: p_count => x_msg_count,
2658: p_data => X_msg_data);
2659: IF G_DEBUG='Y' THEN
2660: AHL_DEBUG_PUB.disable_debug;

Line 2666: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2662:
2663: WHEN OTHERS THEN
2664: ROLLBACK TO COMPLETE_MR_REVISION_PVT;
2665: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2666: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2667: THEN
2668: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_FMP_MR_REVISION_PVT',
2669: p_procedure_name => 'COMPLETE_MR_REVISION',
2670: p_error_text => SUBSTR(SQLERRM,1,240));

Line 2668: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_FMP_MR_REVISION_PVT',

2664: ROLLBACK TO COMPLETE_MR_REVISION_PVT;
2665: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2666: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2667: THEN
2668: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_FMP_MR_REVISION_PVT',
2669: p_procedure_name => 'COMPLETE_MR_REVISION',
2670: p_error_text => SUBSTR(SQLERRM,1,240));
2671: END IF;
2672: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

Line 2672: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

2668: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_FMP_MR_REVISION_PVT',
2669: p_procedure_name => 'COMPLETE_MR_REVISION',
2670: p_error_text => SUBSTR(SQLERRM,1,240));
2671: END IF;
2672: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
2673: p_count => x_msg_count,
2674: p_data => X_msg_data);
2675:
2676: IF G_DEBUG='Y' THEN

Line 2707: FND_MSG_PUB.ADD;

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:
2711:

Line 2721: FND_MSG_PUB.ADD;

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
2725: FROM AHL_MR_HEADERS_APP_V

Line 2732: FND_MSG_PUB.ADD;

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
2736: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2739: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

2735: EXCEPTION
2736: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2737: ROLLBACK TO VALIDATE_MR_REVISION;
2738: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2739: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
2740: p_count => x_msg_count,
2741: p_data => x_msg_data);
2742: IF G_DEBUG='Y' THEN
2743: AHL_DEBUG_PUB.disable_debug;

Line 2749: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

2745:
2746: WHEN FND_API.G_EXC_ERROR THEN
2747: ROLLBACK TO VALIDATE_MR_REVISION;
2748: X_return_status := FND_API.G_RET_STS_ERROR;
2749: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
2750: p_count => x_msg_count,
2751: p_data => X_msg_data);
2752: IF G_DEBUG='Y' THEN
2753: AHL_DEBUG_PUB.disable_debug;

Line 2759: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2755:
2756: WHEN OTHERS THEN
2757: ROLLBACK TO VALIDATE_MR_REVISION;
2758: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2759: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2760: THEN
2761: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME ,
2762: p_procedure_name => 'VALIDATE_MR_REVISION',
2763: p_error_text => SUBSTR(SQLERRM,1,240));

Line 2761: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME ,

2757: ROLLBACK TO VALIDATE_MR_REVISION;
2758: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2759: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2760: THEN
2761: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME ,
2762: p_procedure_name => 'VALIDATE_MR_REVISION',
2763: p_error_text => SUBSTR(SQLERRM,1,240));
2764: END IF;
2765: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

Line 2765: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

2761: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME ,
2762: p_procedure_name => 'VALIDATE_MR_REVISION',
2763: p_error_text => SUBSTR(SQLERRM,1,240));
2764: END IF;
2765: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
2766: p_count => x_msg_count,
2767: p_data => X_msg_data);
2768: IF G_DEBUG='Y' THEN
2769: AHL_DEBUG_PUB.disable_debug;