DBA Data[Home] [Help]

APPS.AHL_FMP_MR_REVISION_PVT dependencies on AHL_DEBUG_PUB

Line 5: G_DEBUG VARCHAR2(1) :=AHL_DEBUG_PUB.is_log_enabled;

1: PACKAGE BODY AHL_FMP_MR_REVISION_PVT AS
2: /* $Header: AHLVMRRB.pls 120.5.12010000.2 2008/12/29 01:03:58 sracha ship $ */
3:
4: G_PKG_NAME VARCHAR2(30):='AHL_FMP_MR_REVISION_PVT';
5: G_DEBUG VARCHAR2(1) :=AHL_DEBUG_PUB.is_log_enabled;
6: G_APPLN_USAGE VARCHAR2(30) :=LTRIM(RTRIM(FND_PROFILE.VALUE('AHL_APPLN_USAGE')));
7:
8: TYPE TEMP_MR_ROUTE_REC IS RECORD
9: (

Line 58: AHL_DEBUG_PUB.enable_debug;

54: x_return_status:=fnd_api.g_ret_sts_success;
55:
56:
57: IF G_DEBUG='Y' THEN
58: AHL_DEBUG_PUB.enable_debug;
59: END IF;
60:
61: IF g_appln_usage is null
62: THEN

Line 134: AHL_DEBUG_PUB.disable_debug;

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;
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,

Line 142: AHL_DEBUG_PUB.disable_debug;

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;
143: END IF;
144:
145: WHEN OTHERS THEN
146: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 158: AHL_DEBUG_PUB.disable_debug;

154: p_count => x_msg_count,
155: p_data => X_msg_data);
156:
157: IF G_DEBUG='Y' THEN
158: AHL_DEBUG_PUB.disable_debug;
159: END IF;
160:
161: END;
162:

Line 609: AHL_DEBUG_PUB.enable_debug;

605:
606: SAVEPOINT CREATE_MR_REVISION_PVT;
607:
608: IF G_DEBUG='Y' THEN
609: AHL_DEBUG_PUB.enable_debug;
610: AHL_DEBUG_PUB.debug( ' START CREATE MR REVISION ');
611: END IF;
612:
613: -- Standard call to check for call compatibility.

Line 610: AHL_DEBUG_PUB.debug( ' START CREATE MR REVISION ');

606: SAVEPOINT CREATE_MR_REVISION_PVT;
607:
608: IF G_DEBUG='Y' THEN
609: AHL_DEBUG_PUB.enable_debug;
610: AHL_DEBUG_PUB.debug( ' START CREATE MR REVISION ');
611: END IF;
612:
613: -- Standard call to check for call compatibility.
614:

Line 1252: AHL_DEBUG_PUB.DEBUG('CREATION OF MR_REVISION IS COMPLETE');

1248:
1249: -- Check if API is called in debug mode. If yes, disable debug.
1250:
1251: IF G_DEBUG='Y' THEN
1252: AHL_DEBUG_PUB.DEBUG('CREATION OF MR_REVISION IS COMPLETE');
1253: AHL_DEBUG_PUB.disable_debug;
1254: END IF;
1255:
1256: EXCEPTION

Line 1253: AHL_DEBUG_PUB.disable_debug;

1249: -- Check if API is called in debug mode. If yes, disable debug.
1250:
1251: IF G_DEBUG='Y' THEN
1252: AHL_DEBUG_PUB.DEBUG('CREATION OF MR_REVISION IS COMPLETE');
1253: AHL_DEBUG_PUB.disable_debug;
1254: END IF;
1255:
1256: EXCEPTION
1257: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1264: AHL_DEBUG_PUB.DEBUG('CREATION OF MR_REVISION IS NOT COMPLETE');

1260: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1261: p_count => x_msg_count,
1262: p_data => x_msg_data);
1263: IF G_DEBUG='Y' THEN
1264: AHL_DEBUG_PUB.DEBUG('CREATION OF MR_REVISION IS NOT COMPLETE');
1265: AHL_DEBUG_PUB.disable_debug;
1266: END IF;
1267:
1268:

Line 1265: AHL_DEBUG_PUB.disable_debug;

1261: p_count => x_msg_count,
1262: p_data => x_msg_data);
1263: IF G_DEBUG='Y' THEN
1264: AHL_DEBUG_PUB.DEBUG('CREATION OF MR_REVISION IS NOT COMPLETE');
1265: AHL_DEBUG_PUB.disable_debug;
1266: END IF;
1267:
1268:
1269: WHEN FND_API.G_EXC_ERROR THEN

Line 1276: AHL_DEBUG_PUB.DEBUG('CREATION OF MR_REVISION IS NOT COMPLETE');

1272: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1273: p_count => x_msg_count,
1274: p_data => X_msg_data);
1275: IF G_DEBUG='Y' THEN
1276: AHL_DEBUG_PUB.DEBUG('CREATION OF MR_REVISION IS NOT COMPLETE');
1277: AHL_DEBUG_PUB.disable_debug;
1278: END IF;
1279:
1280: WHEN OTHERS THEN

Line 1277: AHL_DEBUG_PUB.disable_debug;

1273: p_count => x_msg_count,
1274: p_data => X_msg_data);
1275: IF G_DEBUG='Y' THEN
1276: AHL_DEBUG_PUB.DEBUG('CREATION OF MR_REVISION IS NOT COMPLETE');
1277: AHL_DEBUG_PUB.disable_debug;
1278: END IF;
1279:
1280: WHEN OTHERS THEN
1281: ROLLBACK TO CREATE_MR_REVISION_PVT;

Line 1293: AHL_DEBUG_PUB.DEBUG('CREATION OF MR_REVISION IS NOT COMPLETE');

1289: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1290: p_count => x_msg_count,
1291: p_data => X_msg_data);
1292: IF G_DEBUG='Y' THEN
1293: AHL_DEBUG_PUB.DEBUG('CREATION OF MR_REVISION IS NOT COMPLETE');
1294: AHL_DEBUG_PUB.DEBUG(SQLERRM||' IN '||L_API_NAME);
1295: AHL_DEBUG_PUB.disable_debug;
1296: END IF;
1297:

Line 1294: AHL_DEBUG_PUB.DEBUG(SQLERRM||' IN '||L_API_NAME);

1290: p_count => x_msg_count,
1291: p_data => X_msg_data);
1292: IF G_DEBUG='Y' THEN
1293: AHL_DEBUG_PUB.DEBUG('CREATION OF MR_REVISION IS NOT COMPLETE');
1294: AHL_DEBUG_PUB.DEBUG(SQLERRM||' IN '||L_API_NAME);
1295: AHL_DEBUG_PUB.disable_debug;
1296: END IF;
1297:
1298: END;

Line 1295: AHL_DEBUG_PUB.disable_debug;

1291: p_data => X_msg_data);
1292: IF G_DEBUG='Y' THEN
1293: AHL_DEBUG_PUB.DEBUG('CREATION OF MR_REVISION IS NOT COMPLETE');
1294: AHL_DEBUG_PUB.DEBUG(SQLERRM||' IN '||L_API_NAME);
1295: AHL_DEBUG_PUB.disable_debug;
1296: END IF;
1297:
1298: END;
1299:

Line 1369: AHL_DEBUG_PUB.enable_debug;

1365: BEGIN
1366: SAVEPOINT INITIATE_MR_APPROVAL_PVT;
1367:
1368: IF G_DEBUG='Y' THEN
1369: AHL_DEBUG_PUB.enable_debug;
1370: END IF;
1371:
1372: IF G_DEBUG='Y' THEN
1373: AHL_DEBUG_PUB.debug( 'Start Initiate_MR_Approval');

Line 1373: AHL_DEBUG_PUB.debug( 'Start Initiate_MR_Approval');

1369: AHL_DEBUG_PUB.enable_debug;
1370: END IF;
1371:
1372: IF G_DEBUG='Y' THEN
1373: AHL_DEBUG_PUB.debug( 'Start Initiate_MR_Approval');
1374: END IF;
1375:
1376: IF FND_API.to_boolean(l_init_msg_list) THEN
1377: FND_MSG_PUB.initialize;

Line 1393: AHL_DEBUG_PUB.debug( 'l_mr_appr_enabled : ' || l_mr_appr_enabled);

1389: l_mr_appr_enabled:=nvl(l_mr_appr_enabled,'Y');
1390: END IF;
1391:
1392: IF G_DEBUG='Y' THEN
1393: AHL_DEBUG_PUB.debug( 'l_mr_appr_enabled : ' || l_mr_appr_enabled);
1394: AHL_DEBUG_PUB.debug( 'P_APPRV_TYPE : ' || P_APPRV_TYPE);
1395: END IF;
1396:
1397: IF p_source_mr_header_id is null or

Line 1394: AHL_DEBUG_PUB.debug( 'P_APPRV_TYPE : ' || P_APPRV_TYPE);

1390: END IF;
1391:
1392: IF G_DEBUG='Y' THEN
1393: AHL_DEBUG_PUB.debug( 'l_mr_appr_enabled : ' || l_mr_appr_enabled);
1394: AHL_DEBUG_PUB.debug( 'P_APPRV_TYPE : ' || P_APPRV_TYPE);
1395: END IF;
1396:
1397: IF p_source_mr_header_id is null or
1398: p_source_mr_header_id=FND_API.G_MISS_NUM

Line 1443: AHL_DEBUG_PUB.debug( ' Before Call to OKS_PM_ENTITLEMENTS_PUB.Check_PM_Exists');

1439: l_program_id:=p_source_mr_header_id;
1440: END IF;
1441:
1442: IF G_DEBUG='Y' THEN
1443: AHL_DEBUG_PUB.debug( ' Before Call to OKS_PM_ENTITLEMENTS_PUB.Check_PM_Exists');
1444: AHL_DEBUG_PUB.debug( 'l_pm_activity_id'||l_pm_activity_id);
1445: AHL_DEBUG_PUB.debug( 'l_program_id'||l_program_id);
1446: END IF;
1447:

Line 1444: AHL_DEBUG_PUB.debug( 'l_pm_activity_id'||l_pm_activity_id);

1440: END IF;
1441:
1442: IF G_DEBUG='Y' THEN
1443: AHL_DEBUG_PUB.debug( ' Before Call to OKS_PM_ENTITLEMENTS_PUB.Check_PM_Exists');
1444: AHL_DEBUG_PUB.debug( 'l_pm_activity_id'||l_pm_activity_id);
1445: AHL_DEBUG_PUB.debug( 'l_program_id'||l_program_id);
1446: END IF;
1447:
1448:

Line 1445: AHL_DEBUG_PUB.debug( 'l_program_id'||l_program_id);

1441:
1442: IF G_DEBUG='Y' THEN
1443: AHL_DEBUG_PUB.debug( ' Before Call to OKS_PM_ENTITLEMENTS_PUB.Check_PM_Exists');
1444: AHL_DEBUG_PUB.debug( 'l_pm_activity_id'||l_pm_activity_id);
1445: AHL_DEBUG_PUB.debug( 'l_program_id'||l_program_id);
1446: END IF;
1447:
1448:
1449: OKS_PM_ENTITLEMENTS_PUB.Check_PM_Exists

Line 1462: AHL_DEBUG_PUB.debug( 'After call to OKS_PM_ENTITLEMENTS_PUB.Check_PM_Exists');

1458: x_pm_reference_exists =>l_contract_ref_exists
1459: );
1460:
1461: IF G_DEBUG='Y' THEN
1462: AHL_DEBUG_PUB.debug( 'After call to OKS_PM_ENTITLEMENTS_PUB.Check_PM_Exists');
1463: END IF;
1464:
1465:
1466: --l_contract_ref_exists:='Y'; -- TEMP CHECK

Line 1477: AHL_DEBUG_PUB.debug( 'l_contract_ref_exists---->'||l_contract_ref_exists);

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);
1478: END IF;
1479:
1480: ELSIF l_contract_ref_exists IS NULL OR l_contract_ref_exists=FND_API.G_MISS_CHAR
1481: THEN

Line 1486: AHL_DEBUG_PUB.debug( 'l_contract_ref_exists----> is either null or g_misschar'||l_contract_ref_exists);

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);
1487: END IF;
1488:
1489: END IF;
1490:

Line 1590: AHL_DEBUG_PUB.debug( 'Check Error l_msg_count:'||l_msg_count);

1586: */
1587: l_msg_count := FND_MSG_PUB.count_msg;
1588:
1589: If G_DEBUG='Y' THEN
1590: AHL_DEBUG_PUB.debug( 'Check Error l_msg_count:'||l_msg_count);
1591: End If;
1592:
1593: IF l_msg_count > 0
1594: THEN

Line 1704: AHL_DEBUG_PUB.disable_debug;

1700: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1701: p_count => x_msg_count,
1702: p_data => x_msg_data);
1703: IF G_DEBUG='Y' THEN
1704: AHL_DEBUG_PUB.disable_debug;
1705: END IF;
1706:
1707:
1708: WHEN FND_API.G_EXC_ERROR THEN

Line 1715: AHL_DEBUG_PUB.disable_debug;

1711: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1712: p_count => x_msg_count,
1713: p_data => X_msg_data);
1714: IF G_DEBUG='Y' THEN
1715: AHL_DEBUG_PUB.disable_debug;
1716: END IF;
1717:
1718: WHEN OTHERS THEN
1719: ROLLBACK TO INITIATE_MR_APPROVAL_PVT;

Line 1731: AHL_DEBUG_PUB.disable_debug;

1727: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1728: p_count => x_msg_count,
1729: p_data => X_msg_data);
1730: IF G_DEBUG='Y' THEN
1731: AHL_DEBUG_PUB.disable_debug;
1732: END IF;
1733:
1734: END;
1735:

Line 1808: AHL_DEBUG_PUB.enable_debug;

1804: SAVEPOINT COMPLETE_MR_REVISION_PVT;
1805:
1806: x_return_status:=FND_API.G_RET_STS_SUCCESS;
1807: IF G_DEBUG='Y' THEN
1808: AHL_DEBUG_PUB.enable_debug;
1809: AHL_DEBUG_PUB.debug( 'p_appr_Status'||p_appr_status);
1810: AHL_DEBUG_PUB.debug( 'Header Id '||p_mr_header_id);
1811: END IF;
1812:

Line 1809: AHL_DEBUG_PUB.debug( 'p_appr_Status'||p_appr_status);

1805:
1806: x_return_status:=FND_API.G_RET_STS_SUCCESS;
1807: IF G_DEBUG='Y' THEN
1808: AHL_DEBUG_PUB.enable_debug;
1809: AHL_DEBUG_PUB.debug( 'p_appr_Status'||p_appr_status);
1810: AHL_DEBUG_PUB.debug( 'Header Id '||p_mr_header_id);
1811: END IF;
1812:
1813: IF p_mr_header_id is not null and p_mr_header_id<>fnd_api.g_miss_num

Line 1810: AHL_DEBUG_PUB.debug( 'Header Id '||p_mr_header_id);

1806: x_return_status:=FND_API.G_RET_STS_SUCCESS;
1807: IF G_DEBUG='Y' THEN
1808: AHL_DEBUG_PUB.enable_debug;
1809: AHL_DEBUG_PUB.debug( 'p_appr_Status'||p_appr_status);
1810: AHL_DEBUG_PUB.debug( 'Header Id '||p_mr_header_id);
1811: END IF;
1812:
1813: IF p_mr_header_id is not null and p_mr_header_id<>fnd_api.g_miss_num
1814: THEN

Line 1880: AHL_DEBUG_PUB.debug( 'l_status:'||l_status);

1876: IF L_MR_REC.MR_STATUS_CODE='TERMINATE_PENDING'
1877: THEN
1878: IF G_DEBUG='Y'
1879: THEN
1880: AHL_DEBUG_PUB.debug( 'l_status:'||l_status);
1881: AHL_DEBUG_PUB.debug( 'Before Call to Terminate MR Instances');
1882: END IF;
1883:
1884: AHL_UMP_UNITMAINT_PUB.Terminate_MR_Instances(

Line 1881: AHL_DEBUG_PUB.debug( 'Before Call to Terminate MR Instances');

1877: THEN
1878: IF G_DEBUG='Y'
1879: THEN
1880: AHL_DEBUG_PUB.debug( 'l_status:'||l_status);
1881: AHL_DEBUG_PUB.debug( 'Before Call to Terminate MR Instances');
1882: END IF;
1883:
1884: AHL_UMP_UNITMAINT_PUB.Terminate_MR_Instances(
1885: p_api_version =>l_api_version,

Line 1904: AHL_DEBUG_PUB.debug( 'Terminate inst fail');

1900:
1901: IF FND_MSG_PUB.count_msg > 0
1902: THEN
1903: IF G_DEBUG='Y' THEN
1904: AHL_DEBUG_PUB.debug( 'Terminate inst fail');
1905: END IF;
1906:
1907: END IF;
1908:

Line 1919: AHL_DEBUG_PUB.debug( ' For version_number >1');

1915: l_check_flag2:='Y';
1916:
1917: ELSIF l_check_flag='Y' and l_mr_rec.version_number>1
1918: THEN
1919: AHL_DEBUG_PUB.debug( ' For version_number >1');
1920:
1921: OPEN GetPrevMR_headerid(l_mr_rec.version_number,
1922: l_mr_rec.title,
1923: l_mr_rec.application_usg_code);

Line 2010: AHL_DEBUG_PUB.debug( 'Error Before TerminateInstances');

2006:
2007: IF FND_MSG_PUB.count_msg > 0
2008: THEN
2009: IF G_DEBUG='Y' THEN
2010: AHL_DEBUG_PUB.debug( 'Error Before TerminateInstances');
2011: END IF;
2012: X_msg_count := l_msg_count;
2013: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2014: RAISE FND_API.G_EXC_ERROR;

Line 2019: AHL_DEBUG_PUB.debug( 'l_status:'||l_status);

2015: END IF;
2016:
2017: IF G_DEBUG='Y'
2018: THEN
2019: AHL_DEBUG_PUB.debug( 'l_status:'||l_status);
2020: END IF;
2021:
2022: IF L_MR_REC.MR_STATUS_CODE='APPROVAL_PENDING'
2023: THEN

Line 2067: AHL_DEBUG_PUB.debug( 'Terminate inst fail');

2063: IF FND_MSG_PUB.count_msg > 0
2064: THEN
2065:
2066: IF G_DEBUG='Y' THEN
2067: AHL_DEBUG_PUB.debug( 'Terminate inst fail');
2068: END IF;
2069:
2070: END IF;
2071: END IF;

Line 2080: AHL_DEBUG_PUB.debug( 'Failed To Complete:');

2076: l_msg_count := FND_MSG_PUB.count_msg;
2077: IF l_msg_count > 0
2078: THEN
2079: IF G_DEBUG='Y' THEN
2080: AHL_DEBUG_PUB.debug( 'Failed To Complete:');
2081: END IF;
2082: X_msg_count := l_msg_count;
2083: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2084: RAISE FND_API.G_EXC_ERROR;

Line 2092: AHL_DEBUG_PUB.debug('Tried to submit concurrent request but failed');

2088: l_req_id := fnd_request.submit_request('AHL','AHLWUEFF',NULL,NULL,FALSE,
2089: l_prev_mr_rec.MR_HEADER_ID, l_mr_rec.MR_HEADER_ID);
2090: IF (l_req_id = 0 OR l_req_id IS NULL) THEN
2091: IF G_debug = 'Y' THEN
2092: AHL_DEBUG_PUB.debug('Tried to submit concurrent request but failed');
2093: END IF;
2094: ELSE
2095: IF G_debug = 'Y' THEN
2096: AHL_DEBUG_PUB.debug('submit concurrent request : ' || l_req_id);

Line 2096: AHL_DEBUG_PUB.debug('submit concurrent request : ' || l_req_id);

2092: AHL_DEBUG_PUB.debug('Tried to submit concurrent request but failed');
2093: END IF;
2094: ELSE
2095: IF G_debug = 'Y' THEN
2096: AHL_DEBUG_PUB.debug('submit concurrent request : ' || l_req_id);
2097: END IF;
2098: END IF;
2099: END IF;
2100:

Line 2102: AHL_DEBUG_PUB.debug( 'Before commit Complete_mr_revision ');

2098: END IF;
2099: END IF;
2100:
2101: IF G_DEBUG='Y' THEN
2102: AHL_DEBUG_PUB.debug( 'Before commit Complete_mr_revision ');
2103: END IF;
2104:
2105: IF FND_API.TO_BOOLEAN(p_commit) THEN
2106: COMMIT;

Line 2116: AHL_DEBUG_PUB.disable_debug;

2112: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
2113: p_count => x_msg_count,
2114: p_data => x_msg_data);
2115: IF G_DEBUG='Y' THEN
2116: AHL_DEBUG_PUB.disable_debug;
2117: END IF;
2118: WHEN FND_API.G_EXC_ERROR THEN
2119: ROLLBACK TO COMPLETE_MR_REVISION_PVT;
2120: X_return_status := FND_API.G_RET_STS_ERROR;

Line 2125: AHL_DEBUG_PUB.disable_debug;

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;
2126: END IF;
2127:
2128: WHEN OTHERS THEN
2129: ROLLBACK TO COMPLETE_MR_REVISION_PVT;

Line 2142: AHL_DEBUG_PUB.disable_debug;

2138: p_count => x_msg_count,
2139: p_data => X_msg_data);
2140:
2141: IF G_DEBUG='Y' THEN
2142: AHL_DEBUG_PUB.disable_debug;
2143: END IF;
2144:
2145: END;
2146:

Line 2208: AHL_DEBUG_PUB.disable_debug;

2204: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
2205: p_count => x_msg_count,
2206: p_data => x_msg_data);
2207: IF G_DEBUG='Y' THEN
2208: AHL_DEBUG_PUB.disable_debug;
2209: END IF;
2210:
2211: WHEN FND_API.G_EXC_ERROR THEN
2212: ROLLBACK TO VALIDATE_MR_REVISION;

Line 2218: AHL_DEBUG_PUB.disable_debug;

2214: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
2215: p_count => x_msg_count,
2216: p_data => X_msg_data);
2217: IF G_DEBUG='Y' THEN
2218: AHL_DEBUG_PUB.disable_debug;
2219: END IF;
2220:
2221: WHEN OTHERS THEN
2222: ROLLBACK TO VALIDATE_MR_REVISION;

Line 2234: AHL_DEBUG_PUB.disable_debug;

2230: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
2231: p_count => x_msg_count,
2232: p_data => X_msg_data);
2233: IF G_DEBUG='Y' THEN
2234: AHL_DEBUG_PUB.disable_debug;
2235: END IF;
2236: END;
2237: END AHL_FMP_MR_REVISION_PVT;