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_ASO_PVT dependencies on AHL_DI_ASSO_DOC_ASO_PVT

Line 1: PACKAGE BODY AHL_DI_ASSO_DOC_ASO_PVT AS

1: PACKAGE BODY AHL_DI_ASSO_DOC_ASO_PVT AS
2: /* $Header: AHLVDASB.pls 115.36 2003/08/26 11:52:24 rroy noship $ */
3: --
4: G_PKG_NAME VARCHAR2(30) := 'AHL_DI_ASSO_DOC_ASO_PVT';
5: /*---------------------------------------------------------*/

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

1: PACKAGE BODY AHL_DI_ASSO_DOC_ASO_PVT AS
2: /* $Header: AHLVDASB.pls 115.36 2003/08/26 11:52:24 rroy noship $ */
3: --
4: G_PKG_NAME VARCHAR2(30) := 'AHL_DI_ASSO_DOC_ASO_PVT';
5: /*---------------------------------------------------------*/
6: /* procedure name: validate_association(private procedure) */
7: /* description : Validation checks for before inserting */
8: /* new record as well before modification */

Line 321: AHL_DEBUG_PUB.debug( 'enter ahl_di_asso_doc_aso_pvt.Delete Association','+DOBJASS+');

317: END IF;
318: -- Debug info.
319: IF G_DEBUG='Y' THEN
320: IF G_DEBUG='Y' THEN
321: AHL_DEBUG_PUB.debug( 'enter ahl_di_asso_doc_aso_pvt.Delete Association','+DOBJASS+');
322:
323: END IF;
324: END IF;
325: -- Standard call to check for call compatibility.

Line 400: AHL_DEBUG_PUB.debug( 'ahl_di_asso_doc_aso_pvt.Delete Association','+DOBJASS+');

396: p_data => x_msg_data);
397: --Debug Info
398: IF G_DEBUG='Y' THEN
399: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
400: AHL_DEBUG_PUB.debug( 'ahl_di_asso_doc_aso_pvt.Delete Association','+DOBJASS+');
401:
402:
403: -- Check if API is called in debug mode. If yes, disable debug.
404:

Line 418: AHL_DEBUG_PUB.debug( 'ahl_di_asso_doc_aso_pvt.Delete Association','+DOCJASS+');

414: p_data => X_msg_data);
415: -- Debug info.
416: IF G_DEBUG='Y' THEN
417: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
418: AHL_DEBUG_PUB.debug( 'ahl_di_asso_doc_aso_pvt.Delete Association','+DOCJASS+');
419:
420:
421: -- Check if API is called in debug mode. If yes, disable debug.
422: AHL_DEBUG_PUB.disable_debug;

Line 431: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_ASSO_DOC_ASO_PVT',

427: ROLLBACK TO delete_association;
428: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
429: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
430: THEN
431: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_ASSO_DOC_ASO_PVT',
432: p_procedure_name => 'DELETE_ASSOCIATION',
433: p_error_text => SUBSTR(SQLERRM,1,240));
434: END IF;
435: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 441: AHL_DEBUG_PUB.debug( 'ahl_di_asso_doc_aso_pvt.Delete Association','+DOCJASS+');

437: p_data => X_msg_data);
438: -- Debug info.
439: IF G_DEBUG='Y' THEN
440: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
441: AHL_DEBUG_PUB.debug( 'ahl_di_asso_doc_aso_pvt.Delete Association','+DOCJASS+');
442:
443:
444: -- Check if API is called in debug mode. If yes, disable debug.
445: AHL_DEBUG_PUB.disable_debug;

Line 534: AHL_DEBUG_PUB.debug( 'enter ahl_di_asso_doc_aso_pvt.Create Association','+DOBJASS+');

530: END IF;
531: -- Debug info.
532: IF G_DEBUG='Y' THEN
533: IF G_DEBUG='Y' THEN
534: AHL_DEBUG_PUB.debug( 'enter ahl_di_asso_doc_aso_pvt.Create Association','+DOBJASS+');
535:
536: END IF;
537: END IF;
538: -- Standard call to check for call compatibility.

Line 935: AHL_DEBUG_PUB.debug( 'ahl_di_asso_doc_aso_pvt.Create Association','+DOBJASS+');

931:
932: --Debug Info
933: IF G_DEBUG='Y' THEN
934: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
935: AHL_DEBUG_PUB.debug( 'ahl_di_asso_doc_aso_pvt.Create Association','+DOBJASS+');
936:
937:
938: -- Check if API is called in debug mode. If yes, disable debug.
939: AHL_DEBUG_PUB.disable_debug;

Line 953: AHL_DEBUG_PUB.debug( 'ahl_di_asso_doc_aso_pvt.Create Association','+DOCJASS+');

949:
950: -- Debug info.
951: IF G_DEBUG='Y' THEN
952: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
953: AHL_DEBUG_PUB.debug( 'ahl_di_asso_doc_aso_pvt.Create Association','+DOCJASS+');
954:
955:
956: -- Check if API is called in debug mode. If yes, disable debug.
957: AHL_DEBUG_PUB.disable_debug;

Line 966: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_ASSO_DOC_ASO_PVT',

962: ROLLBACK TO create_association;
963: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
964: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
965: THEN
966: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_ASSO_DOC_ASO_PVT',
967: p_procedure_name => 'CREATE_ASSOCIATION',
968: p_error_text => SUBSTR(SQLERRM,1,240));
969: END IF;
970: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 976: AHL_DEBUG_PUB.debug( 'ahl_di_asso_doc_aso_pvt.Create Association','+DOCJASS+');

972: p_data => X_msg_data);
973: -- Debug info.
974: IF G_DEBUG='Y' THEN
975: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
976: AHL_DEBUG_PUB.debug( 'ahl_di_asso_doc_aso_pvt.Create Association','+DOCJASS+');
977:
978:
979: -- Check if API is called in debug mode. If yes, disable debug.
980: AHL_DEBUG_PUB.disable_debug;

Line 1119: AHL_DEBUG_PUB.debug( 'enter ahl_di_asso_doc_aso_pvt.Modify Association','+DOBJASS+');

1115: END IF;
1116: -- Debug info.
1117: IF G_DEBUG='Y' THEN
1118: IF G_DEBUG='Y' THEN
1119: AHL_DEBUG_PUB.debug( 'enter ahl_di_asso_doc_aso_pvt.Modify Association','+DOBJASS+');
1120:
1121: END IF;
1122: END IF;
1123: -- Standard call to check for call compatibility.

Line 1536: AHL_DEBUG_PUB.debug( 'ahl_di_asso_doc_aso_pvt.Modify Association','+DOBJASS+');

1532:
1533: --Debug Info
1534: IF G_DEBUG='Y' THEN
1535: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
1536: AHL_DEBUG_PUB.debug( 'ahl_di_asso_doc_aso_pvt.Modify Association','+DOBJASS+');
1537:
1538:
1539: -- Check if API is called in debug mode. If yes, disable debug.
1540: AHL_DEBUG_PUB.disable_debug;

Line 1553: AHL_DEBUG_PUB.debug( 'ahl_di_asso_doc_aso_pvt.Modify Association','+DOCJASS+');

1549: p_data => X_msg_data);
1550: -- Debug info.
1551: IF G_DEBUG='Y' THEN
1552: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
1553: AHL_DEBUG_PUB.debug( 'ahl_di_asso_doc_aso_pvt.Modify Association','+DOCJASS+');
1554:
1555:
1556: -- Check if API is called in debug mode. If yes, disable debug.
1557: AHL_DEBUG_PUB.disable_debug;

Line 1566: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_ASSO_DOC_ASO_PVT',

1562: ROLLBACK TO modify_association;
1563: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1564: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1565: THEN
1566: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_ASSO_DOC_ASO_PVT',
1567: p_procedure_name => 'MODIFY_ASSOCIATION',
1568: p_error_text => SUBSTR(SQLERRM,1,240));
1569: END IF;
1570: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 1577: AHL_DEBUG_PUB.debug( 'ahl_di_asso_doc_aso_pvt.Modify Association','+DOCJASS+');

1573:
1574: -- Debug info.
1575: IF G_DEBUG='Y' THEN
1576: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
1577: AHL_DEBUG_PUB.debug( 'ahl_di_asso_doc_aso_pvt.Modify Association','+DOCJASS+');
1578:
1579:
1580: -- Check if API is called in debug mode. If yes, disable debug.
1581: AHL_DEBUG_PUB.disable_debug;

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

1635: END IF;
1636: -- Debug info.
1637: IF G_DEBUG='Y' THEN
1638: IF G_DEBUG='Y' THEN
1639: AHL_DEBUG_PUB.debug( 'enter ahl_di_asso_doc_aso_pvt.Insert Assoc Rec','+DOBJASS+');
1640:
1641: END IF;
1642: END IF;
1643: -- Standard call to check for call compatibility.

Line 1967: AHL_DEBUG_PUB.debug( 'Ahl_Di_Asso_Doc_Aso_Pvt.INSERT Assoc Rec','+DOBJASS+');

1963:
1964: --Debug Info
1965: IF G_DEBUG='Y' THEN
1966: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
1967: AHL_DEBUG_PUB.debug( 'Ahl_Di_Asso_Doc_Aso_Pvt.INSERT Assoc Rec','+DOBJASS+');
1968:
1969:
1970: -- Check if API is called in debug mode. If yes, disable debug.
1971: AHL_DEBUG_PUB.disable_debug;

Line 1985: AHL_DEBUG_PUB.debug( 'Ahl_Di_Asso_Doc_Aso_Pvt. INSERT Assoc Rec','+DOCJASS+');

1981:
1982: -- Debug info.
1983: IF G_DEBUG='Y' THEN
1984: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
1985: AHL_DEBUG_PUB.debug( 'Ahl_Di_Asso_Doc_Aso_Pvt. INSERT Assoc Rec','+DOCJASS+');
1986:
1987:
1988: -- Check if API is called in debug mode. If yes, disable debug.
1989: AHL_DEBUG_PUB.disable_debug;

Line 1998: Fnd_Msg_Pub.add_exc_msg(p_pkg_name => 'Ahl_Di_Asso_Doc_Aso_Pvt',

1994: ROLLBACK TO insert_assoc_rec;
1995: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1996: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
1997: THEN
1998: Fnd_Msg_Pub.add_exc_msg(p_pkg_name => 'Ahl_Di_Asso_Doc_Aso_Pvt',
1999: p_procedure_name => 'INSERT_ASSOC_REC',
2000: p_error_text => SUBSTR(SQLERRM,1,240));
2001: END IF;
2002: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,

Line 2008: AHL_DEBUG_PUB.debug( 'Ahl_Di_Asso_Doc_Aso_Pvt.INSERT Assoc Rec','+DOCJASS+');

2004: p_data => X_msg_data);
2005: -- Debug info.
2006: IF G_DEBUG='Y' THEN
2007: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
2008: AHL_DEBUG_PUB.debug( 'Ahl_Di_Asso_Doc_Aso_Pvt.INSERT Assoc Rec','+DOCJASS+');
2009:
2010:
2011: -- Check if API is called in debug mode. If yes, disable debug.
2012: AHL_DEBUG_PUB.disable_debug;

Line 2066: AHL_DEBUG_PUB.debug( 'enter Ahl_Di_Asso_Doc_Aso_Pvt.Copy Association','+DOBJASS+');

2062: END IF;
2063: -- Debug info.
2064: IF G_DEBUG='Y' THEN
2065: IF G_DEBUG='Y' THEN
2066: AHL_DEBUG_PUB.debug( 'enter Ahl_Di_Asso_Doc_Aso_Pvt.Copy Association','+DOBJASS+');
2067:
2068: END IF;
2069: END IF;
2070: -- Standard call to check for call compatibility.

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

2082: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
2083: END IF;
2084: IF G_DEBUG='Y' THEN
2085: IF G_DEBUG='Y' THEN
2086: AHL_DEBUG_PUB.debug( 'enter Ahl_Di_Asso_Doc_Aso_Pvt.Copy Association:'||p_from_object_id ,'+DOBJASS+');
2087:
2088: END IF;
2089: END IF;
2090: --Start of API Body

Line 2182: AHL_DEBUG_PUB.debug( 'Ahl_Di_Asso_Doc_Aso_Pvt.Copy Association','+DOBJASS+');

2178:
2179: --Debug Info
2180: IF G_DEBUG='Y' THEN
2181: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
2182: AHL_DEBUG_PUB.debug( 'Ahl_Di_Asso_Doc_Aso_Pvt.Copy Association','+DOBJASS+');
2183:
2184:
2185: -- Check if API is called in debug mode. If yes, disable debug.
2186: AHL_DEBUG_PUB.disable_debug;

Line 2199: AHL_DEBUG_PUB.debug( 'Ahl_Di_Asso_Doc_Aso_Pvt.Copy Association','+DOCJASS+');

2195: p_data => X_msg_data);
2196: -- Debug info.
2197: IF G_DEBUG='Y' THEN
2198: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
2199: AHL_DEBUG_PUB.debug( 'Ahl_Di_Asso_Doc_Aso_Pvt.Copy Association','+DOCJASS+');
2200:
2201:
2202: -- Check if API is called in debug mode. If yes, disable debug.
2203: AHL_DEBUG_PUB.disable_debug;

Line 2212: Fnd_Msg_Pub.add_exc_msg(p_pkg_name => 'Ahl_Di_Asso_Doc_Aso_Pvt',

2208: ROLLBACK TO copy_association;
2209: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2210: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
2211: THEN
2212: Fnd_Msg_Pub.add_exc_msg(p_pkg_name => 'Ahl_Di_Asso_Doc_Aso_Pvt',
2213: p_procedure_name => 'COPY_ASSOCIATION',
2214: p_error_text => SUBSTR(SQLERRM,1,240));
2215: END IF;
2216: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,

Line 2223: AHL_DEBUG_PUB.debug( 'Ahl_Di_Asso_Doc_Aso_Pvt.Copy Association','+DOCJASS+');

2219:
2220: -- Debug info.
2221: IF G_DEBUG='Y' THEN
2222: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
2223: AHL_DEBUG_PUB.debug( 'Ahl_Di_Asso_Doc_Aso_Pvt.Copy Association','+DOCJASS+');
2224:
2225:
2226: -- Check if API is called in debug mode. If yes, disable debug.
2227:

Line 2234: END AHL_DI_ASSO_DOC_ASO_PVT;

2230: END IF;
2231:
2232: END COPY_ASSOCIATION;
2233: --
2234: END AHL_DI_ASSO_DOC_ASO_PVT;