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 120.1.12020000.2 2012/12/14 07:50:36 shnatu ship $ */
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 120.1.12020000.2 2012/12/14 07:50:36 shnatu ship $ */
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 643: AHL_DEBUG_PUB.debug( 'enter AHL_DI_ASSO_DOC_GEN_PVT.Delete Association','+DOBJASS+');

639: END IF;
640: -- Debug info.
641: IF G_DEBUG='Y' THEN
642: IF G_DEBUG='Y' THEN
643: AHL_DEBUG_PUB.debug( 'enter AHL_DI_ASSO_DOC_GEN_PVT.Delete Association','+DOBJASS+');
644:
645: END IF;
646: END IF;
647: -- Standard call to check for call compatibility.

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

718: p_data => x_msg_data);
719: --Debug Info
720: IF G_DEBUG='Y' THEN
721: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
722: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.Delete Association','+DOBJASS+');
723:
724:
725: -- Check if API is called in debug mode. If yes, disable debug.
726:

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

736: p_data => X_msg_data);
737: -- Debug info.
738: IF G_DEBUG='Y' THEN
739: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
740: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.Delete Association','+DOCJASS+');
741:
742:
743: -- Check if API is called in debug mode. If yes, disable debug.
744: AHL_DEBUG_PUB.disable_debug;

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

749: ROLLBACK TO delete_association;
750: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
751: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
752: THEN
753: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_ASSO_DOC_GEN_PVT',
754: p_procedure_name => 'DELETE_ASSOCIATION',
755: p_error_text => SUBSTR(SQLERRM,1,240));
756: END IF;
757: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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

759: p_data => X_msg_data);
760: -- Debug info.
761: IF G_DEBUG='Y' THEN
762: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
763: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.Delete Association','+DOCJASS+');
764:
765:
766: -- Check if API is called in debug mode. If yes, disable debug.
767: AHL_DEBUG_PUB.disable_debug;

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

937: END IF;
938: -- Debug info.
939: IF G_DEBUG='Y' THEN
940: IF G_DEBUG='Y' THEN
941: AHL_DEBUG_PUB.debug( 'enter AHL_DI_ASSO_DOC_GEN_PVT.Process Association','+DOBJASS+');
942:
943: END IF;
944: END IF;
945: -- Standard call to check for call compatibility.

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

1395:
1396: --Debug Info
1397: IF G_DEBUG='Y' THEN
1398: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
1399: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.Create Association','+DOBJASS+');
1400:
1401:
1402: -- Check if API is called in debug mode. If yes, disable debug.
1403: AHL_DEBUG_PUB.disable_debug;

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

1413:
1414: -- Debug info.
1415: IF G_DEBUG='Y' THEN
1416: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
1417: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.Create Association','+DOCJASS+');
1418:
1419:
1420: -- Check if API is called in debug mode. If yes, disable debug.
1421: AHL_DEBUG_PUB.disable_debug;

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

1426: ROLLBACK TO process_association;
1427: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1428: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1429: THEN
1430: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_ASSO_DOC_GEN_PVT',
1431: p_procedure_name => 'PROCESS_ASSOCIATION',
1432: p_error_text => SUBSTR(SQLERRM,1,240));
1433: END IF;
1434: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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

1436: p_data => X_msg_data);
1437: -- Debug info.
1438: IF G_DEBUG='Y' THEN
1439: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
1440: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.Create Association','+DOCJASS+');
1441:
1442:
1443: -- Check if API is called in debug mode. If yes, disable debug.
1444: AHL_DEBUG_PUB.disable_debug;

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

1529: END IF;
1530: -- Debug info.
1531: IF G_DEBUG='Y' THEN
1532: IF G_DEBUG='Y' THEN
1533: AHL_DEBUG_PUB.debug( 'enter AHL_DI_ASSO_DOC_GEN_PVT.Insert Assoc Rec','+DOBJASS+');
1534:
1535: END IF;
1536: END IF;
1537: -- Standard call to check for call compatibility.

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

1890:
1891: --Debug Info
1892: IF G_DEBUG='Y' THEN
1893: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
1894: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.INSERT Assoc Rec','+DOBJASS+');
1895:
1896:
1897: -- Check if API is called in debug mode. If yes, disable debug.
1898: AHL_DEBUG_PUB.disable_debug;

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

1908:
1909: -- Debug info.
1910: IF G_DEBUG='Y' THEN
1911: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
1912: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT. INSERT Assoc Rec','+DOCJASS+');
1913:
1914:
1915: -- Check if API is called in debug mode. If yes, disable debug.
1916: AHL_DEBUG_PUB.disable_debug;

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

1921: ROLLBACK TO insert_assoc_rec;
1922: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1923: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
1924: THEN
1925: Fnd_Msg_Pub.add_exc_msg(p_pkg_name => 'AHL_DI_ASSO_DOC_GEN_PVT',
1926: p_procedure_name => 'INSERT_ASSOC_REC',
1927: p_error_text => SUBSTR(SQLERRM,1,240));
1928: END IF;
1929: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,

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

1931: p_data => X_msg_data);
1932: -- Debug info.
1933: IF G_DEBUG='Y' THEN
1934: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
1935: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.INSERT Assoc Rec','+DOCJASS+');
1936:
1937:
1938: -- Check if API is called in debug mode. If yes, disable debug.
1939: AHL_DEBUG_PUB.disable_debug;

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

1989: END IF;
1990: -- Debug info.
1991: IF G_DEBUG='Y' THEN
1992: IF G_DEBUG='Y' THEN
1993: AHL_DEBUG_PUB.debug( 'enter AHL_DI_ASSO_DOC_GEN_PVT.Copy Association','+DOBJASS+');
1994:
1995: END IF;
1996: END IF;
1997: -- Standard call to check for call compatibility.

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

2009: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
2010: END IF;
2011: IF G_DEBUG='Y' THEN
2012: IF G_DEBUG='Y' THEN
2013: AHL_DEBUG_PUB.debug( 'enter AHL_DI_ASSO_DOC_GEN_PVT.Copy Association:'||p_from_object_id ,'+DOBJASS+');
2014:
2015: END IF;
2016: END IF;
2017: --Start of API Body

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

2105:
2106: --Debug Info
2107: IF G_DEBUG='Y' THEN
2108: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
2109: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.Copy Association','+DOBJASS+');
2110:
2111:
2112: -- Check if API is called in debug mode. If yes, disable debug.
2113: AHL_DEBUG_PUB.disable_debug;

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

2122: p_data => X_msg_data);
2123: -- Debug info.
2124: IF G_DEBUG='Y' THEN
2125: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
2126: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.Copy Association','+DOCJASS+');
2127:
2128:
2129: -- Check if API is called in debug mode. If yes, disable debug.
2130: AHL_DEBUG_PUB.disable_debug;

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

2135: ROLLBACK TO copy_association;
2136: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2137: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
2138: THEN
2139: Fnd_Msg_Pub.add_exc_msg(p_pkg_name => 'AHL_DI_ASSO_DOC_GEN_PVT',
2140: p_procedure_name => 'COPY_ASSOCIATION',
2141: p_error_text => SUBSTR(SQLERRM,1,240));
2142: END IF;
2143: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,

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

2146:
2147: -- Debug info.
2148: IF G_DEBUG='Y' THEN
2149: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
2150: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.Copy Association','+DOCJASS+');
2151:
2152:
2153: -- Check if API is called in debug mode. If yes, disable debug.
2154:

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

2198: END IF;
2199: -- Debug info.
2200: IF G_DEBUG='Y' THEN
2201: IF G_DEBUG='Y' THEN
2202: AHL_DEBUG_PUB.debug( 'enter AHL_DI_ASSO_DOC_GEN_PVT.delete all Association','+DOBJASS+');
2203:
2204: END IF;
2205: END IF;
2206:

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

2219: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
2220: END IF;
2221: IF G_DEBUG='Y' THEN
2222:
2223: AHL_DEBUG_PUB.debug( 'enter AHL_DI_ASSO_DOC_GEN_PVT.delete all Association:'||p_aso_object_id ,'+DOBJASS+');
2224:
2225: END IF;
2226: --Start of API Body
2227:

Line 2243: 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);

2239:
2240: l_count_assoc := l_count_assoc + 1;
2241: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_ASSOS_NOT_FOUND');
2242: FND_MSG_PUB.ADD;
2243: 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);
2244: END IF;
2245:
2246: END LOOP;
2247:

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

2276: FROM AHL_DOC_TITLE_ASSOS_B
2277: WHERE aso_object_type_code = p_aso_object_type_code and
2278: aso_object_id = p_aso_object_id;
2279:
2280: AHL_DEBUG_PUB.debug( 'exit AHL_DI_ASSO_DOC_GEN_PVT.delete all Association:'||p_aso_object_id ,'+DOBJASS+');
2281:
2282: EXCEPTION
2283: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
2284: ROLLBACK TO copy_association;

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

2289:
2290: --Debug Info
2291: IF G_DEBUG='Y' THEN
2292: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
2293: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.delete all Association','+DOBJASS+');
2294:
2295:
2296: -- Check if API is called in debug mode. If yes, disable debug.
2297: AHL_DEBUG_PUB.disable_debug;

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

2306: p_data => X_msg_data);
2307: -- Debug info.
2308: IF G_DEBUG='Y' THEN
2309: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
2310: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.delete all Association','+DOCJASS+');
2311:
2312:
2313: -- Check if API is called in debug mode. If yes, disable debug.
2314: AHL_DEBUG_PUB.disable_debug;

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

2319: ROLLBACK TO copy_association;
2320: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2321: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
2322: THEN
2323: Fnd_Msg_Pub.add_exc_msg(p_pkg_name => 'AHL_DI_ASSO_DOC_GEN_PVT',
2324: p_procedure_name => 'DELETE_ALL_ASSOCIATION',
2325: p_error_text => SUBSTR(SQLERRM,1,240));
2326: END IF;
2327: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,

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

2330:
2331: -- Debug info.
2332: IF G_DEBUG='Y' THEN
2333: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
2334: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.delete all Association','+DOCJASS+');
2335:
2336:
2337: -- Check if API is called in debug mode. If yes, disable debug.
2338:

Line 2349: END AHL_DI_ASSO_DOC_GEN_PVT;

2345:
2346: END DELETE_ALL_ASSOCIATIONS;
2347:
2348: --
2349: END AHL_DI_ASSO_DOC_GEN_PVT;