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_DI_ASSO_DOC_GEN_PVT dependencies on AHL_DI_ASSO_DOC_GEN_PVT

Line 1: PACKAGE BODY AHL_DI_ASSO_DOC_GEN_PVT AS

1: PACKAGE BODY AHL_DI_ASSO_DOC_GEN_PVT AS
2: /* $Header: AHLVDAGB.pls 115.6 2004/01/22 10:46:36 rroy noship $ */
3: --
4: G_PKG_NAME VARCHAR2(30) := 'AHL_DI_ASSO_DOC_GEN_PVT';
5: G_PM_INSTALL VARCHAR2(30):=ahl_util_pkg.is_pm_installed;

Line 4: G_PKG_NAME VARCHAR2(30) := 'AHL_DI_ASSO_DOC_GEN_PVT';

1: PACKAGE BODY AHL_DI_ASSO_DOC_GEN_PVT AS
2: /* $Header: AHLVDAGB.pls 115.6 2004/01/22 10:46:36 rroy noship $ */
3: --
4: G_PKG_NAME VARCHAR2(30) := 'AHL_DI_ASSO_DOC_GEN_PVT';
5: G_PM_INSTALL VARCHAR2(30):=ahl_util_pkg.is_pm_installed;
6: G_DEBUG VARCHAR2(1):=AHL_DEBUG_PUB.is_log_enabled;
7:
8: /*---------------------------------------------------------*/

Line 18: p_association_rec IN AHL_DI_ASSO_DOC_GEN_PVT.association_rec,

14:
15:
16: PROCEDURE RECORD_IDENTIFIER
17: (
18: p_association_rec IN AHL_DI_ASSO_DOC_GEN_PVT.association_rec,
19: x_record OUT NOCOPY VARCHAR2
20: )
21: as
22: CURSOR get_rev_dat(c_document_id NUMBER, c_doc_revision_id NUMBER)

Line 495: AHL_DEBUG_PUB.debug( 'enter AHL_DI_ASSO_DOC_GEN_PVT.Delete Association','+DOBJASS+');

491: END IF;
492: -- Debug info.
493: IF G_DEBUG='Y' THEN
494: IF G_DEBUG='Y' THEN
495: AHL_DEBUG_PUB.debug( 'enter AHL_DI_ASSO_DOC_GEN_PVT.Delete Association','+DOBJASS+');
496:
497: END IF;
498: END IF;
499: -- Standard call to check for call compatibility.

Line 574: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.Delete Association','+DOBJASS+');

570: p_data => x_msg_data);
571: --Debug Info
572: IF G_DEBUG='Y' THEN
573: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
574: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.Delete Association','+DOBJASS+');
575:
576:
577: -- Check if API is called in debug mode. If yes, disable debug.
578:

Line 592: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.Delete Association','+DOCJASS+');

588: p_data => X_msg_data);
589: -- Debug info.
590: IF G_DEBUG='Y' THEN
591: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
592: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.Delete Association','+DOCJASS+');
593:
594:
595: -- Check if API is called in debug mode. If yes, disable debug.
596: AHL_DEBUG_PUB.disable_debug;

Line 605: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_ASSO_DOC_GEN_PVT',

601: ROLLBACK TO delete_association;
602: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
603: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
604: THEN
605: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_ASSO_DOC_GEN_PVT',
606: p_procedure_name => 'DELETE_ASSOCIATION',
607: p_error_text => SUBSTR(SQLERRM,1,240));
608: END IF;
609: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 615: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.Delete Association','+DOCJASS+');

611: p_data => X_msg_data);
612: -- Debug info.
613: IF G_DEBUG='Y' THEN
614: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
615: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.Delete Association','+DOCJASS+');
616:
617:
618: -- Check if API is called in debug mode. If yes, disable debug.
619: AHL_DEBUG_PUB.disable_debug;

Line 793: AHL_DEBUG_PUB.debug( 'enter AHL_DI_ASSO_DOC_GEN_PVT.Process Association','+DOBJASS+');

789: END IF;
790: -- Debug info.
791: IF G_DEBUG='Y' THEN
792: IF G_DEBUG='Y' THEN
793: AHL_DEBUG_PUB.debug( 'enter AHL_DI_ASSO_DOC_GEN_PVT.Process Association','+DOBJASS+');
794:
795: END IF;
796: END IF;
797: -- Standard call to check for call compatibility.

Line 1242: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.Create Association','+DOBJASS+');

1238:
1239: --Debug Info
1240: IF G_DEBUG='Y' THEN
1241: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
1242: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.Create Association','+DOBJASS+');
1243:
1244:
1245: -- Check if API is called in debug mode. If yes, disable debug.
1246: AHL_DEBUG_PUB.disable_debug;

Line 1260: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.Create Association','+DOCJASS+');

1256:
1257: -- Debug info.
1258: IF G_DEBUG='Y' THEN
1259: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
1260: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.Create Association','+DOCJASS+');
1261:
1262:
1263: -- Check if API is called in debug mode. If yes, disable debug.
1264: AHL_DEBUG_PUB.disable_debug;

Line 1273: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_ASSO_DOC_GEN_PVT',

1269: ROLLBACK TO process_association;
1270: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1271: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1272: THEN
1273: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_ASSO_DOC_GEN_PVT',
1274: p_procedure_name => 'PROCESS_ASSOCIATION',
1275: p_error_text => SUBSTR(SQLERRM,1,240));
1276: END IF;
1277: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 1283: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.Create Association','+DOCJASS+');

1279: p_data => X_msg_data);
1280: -- Debug info.
1281: IF G_DEBUG='Y' THEN
1282: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
1283: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.Create Association','+DOCJASS+');
1284:
1285:
1286: -- Check if API is called in debug mode. If yes, disable debug.
1287: AHL_DEBUG_PUB.disable_debug;

Line 1376: AHL_DEBUG_PUB.debug( 'enter AHL_DI_ASSO_DOC_GEN_PVT.Insert Assoc Rec','+DOBJASS+');

1372: END IF;
1373: -- Debug info.
1374: IF G_DEBUG='Y' THEN
1375: IF G_DEBUG='Y' THEN
1376: AHL_DEBUG_PUB.debug( 'enter AHL_DI_ASSO_DOC_GEN_PVT.Insert Assoc Rec','+DOBJASS+');
1377:
1378: END IF;
1379: END IF;
1380: -- Standard call to check for call compatibility.

Line 1737: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.INSERT Assoc Rec','+DOBJASS+');

1733:
1734: --Debug Info
1735: IF G_DEBUG='Y' THEN
1736: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
1737: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.INSERT Assoc Rec','+DOBJASS+');
1738:
1739:
1740: -- Check if API is called in debug mode. If yes, disable debug.
1741: AHL_DEBUG_PUB.disable_debug;

Line 1755: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT. INSERT Assoc Rec','+DOCJASS+');

1751:
1752: -- Debug info.
1753: IF G_DEBUG='Y' THEN
1754: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
1755: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT. INSERT Assoc Rec','+DOCJASS+');
1756:
1757:
1758: -- Check if API is called in debug mode. If yes, disable debug.
1759: AHL_DEBUG_PUB.disable_debug;

Line 1768: Fnd_Msg_Pub.add_exc_msg(p_pkg_name => 'AHL_DI_ASSO_DOC_GEN_PVT',

1764: ROLLBACK TO insert_assoc_rec;
1765: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1766: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
1767: THEN
1768: Fnd_Msg_Pub.add_exc_msg(p_pkg_name => 'AHL_DI_ASSO_DOC_GEN_PVT',
1769: p_procedure_name => 'INSERT_ASSOC_REC',
1770: p_error_text => SUBSTR(SQLERRM,1,240));
1771: END IF;
1772: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,

Line 1778: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.INSERT Assoc Rec','+DOCJASS+');

1774: p_data => X_msg_data);
1775: -- Debug info.
1776: IF G_DEBUG='Y' THEN
1777: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
1778: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.INSERT Assoc Rec','+DOCJASS+');
1779:
1780:
1781: -- Check if API is called in debug mode. If yes, disable debug.
1782: AHL_DEBUG_PUB.disable_debug;

Line 1836: AHL_DEBUG_PUB.debug( 'enter AHL_DI_ASSO_DOC_GEN_PVT.Copy Association','+DOBJASS+');

1832: END IF;
1833: -- Debug info.
1834: IF G_DEBUG='Y' THEN
1835: IF G_DEBUG='Y' THEN
1836: AHL_DEBUG_PUB.debug( 'enter AHL_DI_ASSO_DOC_GEN_PVT.Copy Association','+DOBJASS+');
1837:
1838: END IF;
1839: END IF;
1840: -- Standard call to check for call compatibility.

Line 1856: AHL_DEBUG_PUB.debug( 'enter AHL_DI_ASSO_DOC_GEN_PVT.Copy Association:'||p_from_object_id ,'+DOBJASS+');

1852: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
1853: END IF;
1854: IF G_DEBUG='Y' THEN
1855: IF G_DEBUG='Y' THEN
1856: AHL_DEBUG_PUB.debug( 'enter AHL_DI_ASSO_DOC_GEN_PVT.Copy Association:'||p_from_object_id ,'+DOBJASS+');
1857:
1858: END IF;
1859: END IF;
1860: --Start of API Body

Line 1952: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.Copy Association','+DOBJASS+');

1948:
1949: --Debug Info
1950: IF G_DEBUG='Y' THEN
1951: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
1952: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.Copy Association','+DOBJASS+');
1953:
1954:
1955: -- Check if API is called in debug mode. If yes, disable debug.
1956: AHL_DEBUG_PUB.disable_debug;

Line 1969: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.Copy Association','+DOCJASS+');

1965: p_data => X_msg_data);
1966: -- Debug info.
1967: IF G_DEBUG='Y' THEN
1968: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
1969: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.Copy Association','+DOCJASS+');
1970:
1971:
1972: -- Check if API is called in debug mode. If yes, disable debug.
1973: AHL_DEBUG_PUB.disable_debug;

Line 1982: Fnd_Msg_Pub.add_exc_msg(p_pkg_name => 'AHL_DI_ASSO_DOC_GEN_PVT',

1978: ROLLBACK TO copy_association;
1979: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1980: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
1981: THEN
1982: Fnd_Msg_Pub.add_exc_msg(p_pkg_name => 'AHL_DI_ASSO_DOC_GEN_PVT',
1983: p_procedure_name => 'COPY_ASSOCIATION',
1984: p_error_text => SUBSTR(SQLERRM,1,240));
1985: END IF;
1986: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,

Line 1993: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.Copy Association','+DOCJASS+');

1989:
1990: -- Debug info.
1991: IF G_DEBUG='Y' THEN
1992: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
1993: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.Copy Association','+DOCJASS+');
1994:
1995:
1996: -- Check if API is called in debug mode. If yes, disable debug.
1997:

Line 2045: AHL_DEBUG_PUB.debug( 'enter AHL_DI_ASSO_DOC_GEN_PVT.delete all Association','+DOBJASS+');

2041: END IF;
2042: -- Debug info.
2043: IF G_DEBUG='Y' THEN
2044: IF G_DEBUG='Y' THEN
2045: AHL_DEBUG_PUB.debug( 'enter AHL_DI_ASSO_DOC_GEN_PVT.delete all Association','+DOBJASS+');
2046:
2047: END IF;
2048: END IF;
2049:

Line 2066: AHL_DEBUG_PUB.debug( 'enter AHL_DI_ASSO_DOC_GEN_PVT.delete all Association:'||p_aso_object_id ,'+DOBJASS+');

2062: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
2063: END IF;
2064: IF G_DEBUG='Y' THEN
2065:
2066: AHL_DEBUG_PUB.debug( 'enter AHL_DI_ASSO_DOC_GEN_PVT.delete all Association:'||p_aso_object_id ,'+DOBJASS+');
2067:
2068: END IF;
2069: --Start of API Body
2070:

Line 2086: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.delete all Association: the revision id of revision deleted is '|| l_doc_asso_rec.doc_revision_id);

2082:
2083: l_count_assoc := l_count_assoc + 1;
2084: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_ASSOS_NOT_FOUND');
2085: FND_MSG_PUB.ADD;
2086: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.delete all Association: the revision id of revision deleted is '|| l_doc_asso_rec.doc_revision_id);
2087: END IF;
2088:
2089: END LOOP;
2090:

Line 2123: AHL_DEBUG_PUB.debug( 'exit AHL_DI_ASSO_DOC_GEN_PVT.delete all Association:'||p_aso_object_id ,'+DOBJASS+');

2119: FROM AHL_DOC_TITLE_ASSOS_B
2120: WHERE aso_object_type_code = p_aso_object_type_code and
2121: aso_object_id = p_aso_object_id;
2122:
2123: AHL_DEBUG_PUB.debug( 'exit AHL_DI_ASSO_DOC_GEN_PVT.delete all Association:'||p_aso_object_id ,'+DOBJASS+');
2124:
2125: EXCEPTION
2126: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
2127: ROLLBACK TO copy_association;

Line 2136: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.delete all Association','+DOBJASS+');

2132:
2133: --Debug Info
2134: IF G_DEBUG='Y' THEN
2135: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
2136: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.delete all Association','+DOBJASS+');
2137:
2138:
2139: -- Check if API is called in debug mode. If yes, disable debug.
2140: AHL_DEBUG_PUB.disable_debug;

Line 2153: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.delete all Association','+DOCJASS+');

2149: p_data => X_msg_data);
2150: -- Debug info.
2151: IF G_DEBUG='Y' THEN
2152: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
2153: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.delete all Association','+DOCJASS+');
2154:
2155:
2156: -- Check if API is called in debug mode. If yes, disable debug.
2157: AHL_DEBUG_PUB.disable_debug;

Line 2166: Fnd_Msg_Pub.add_exc_msg(p_pkg_name => 'AHL_DI_ASSO_DOC_GEN_PVT',

2162: ROLLBACK TO copy_association;
2163: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2164: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
2165: THEN
2166: Fnd_Msg_Pub.add_exc_msg(p_pkg_name => 'AHL_DI_ASSO_DOC_GEN_PVT',
2167: p_procedure_name => 'DELETE_ALL_ASSOCIATION',
2168: p_error_text => SUBSTR(SQLERRM,1,240));
2169: END IF;
2170: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,

Line 2177: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.delete all Association','+DOCJASS+');

2173:
2174: -- Debug info.
2175: IF G_DEBUG='Y' THEN
2176: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
2177: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.delete all Association','+DOCJASS+');
2178:
2179:
2180: -- Check if API is called in debug mode. If yes, disable debug.
2181:

Line 2192: END AHL_DI_ASSO_DOC_GEN_PVT;

2188:
2189: END DELETE_ALL_ASSOCIATIONS;
2190:
2191: --
2192: END AHL_DI_ASSO_DOC_GEN_PVT;