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_DEBUG_PUB

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

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: /*---------------------------------------------------------*/
9: /* procedure name: validate_association(private procedure) */
10: /* description : Validation checks for before inserting */

Line 489: AHL_DEBUG_PUB.enable_debug;

485: -- Standard Start of API savepoint
486: SAVEPOINT delete_association;
487: -- Check if API is called in debug mode. If yes, enable debug.
488: IF G_DEBUG='Y' THEN
489: AHL_DEBUG_PUB.enable_debug;
490:
491: END IF;
492: -- Debug info.
493: IF G_DEBUG='Y' THEN

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 555: AHL_DEBUG_PUB.debug( 'End of private procedure Delete Association','+DOBJASS+');

551: COMMIT;
552: END IF;
553: -- Debug info
554: IF G_DEBUG='Y' THEN
555: AHL_DEBUG_PUB.debug( 'End of private procedure Delete Association','+DOBJASS+');
556:
557: END IF;
558: -- Check if API is called in debug mode. If yes, disable debug.
559: IF G_DEBUG='Y' THEN

Line 560: AHL_DEBUG_PUB.disable_debug;

556:
557: END IF;
558: -- Check if API is called in debug mode. If yes, disable debug.
559: IF G_DEBUG='Y' THEN
560: AHL_DEBUG_PUB.disable_debug;
561:
562: END IF;
563:
564: EXCEPTION

Line 573: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );

569: p_count => x_msg_count,
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.

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 579: AHL_DEBUG_PUB.disable_debug;

575:
576:
577: -- Check if API is called in debug mode. If yes, disable debug.
578:
579: AHL_DEBUG_PUB.disable_debug;
580:
581: END IF;
582:
583: WHEN FND_API.G_EXC_ERROR THEN

Line 591: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );

587: p_count => x_msg_count,
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.

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 596: AHL_DEBUG_PUB.disable_debug;

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;
597:
598: END IF;
599:
600: WHEN OTHERS THEN

Line 614: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );

610: p_count => x_msg_count,
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.

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 619: AHL_DEBUG_PUB.disable_debug;

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;
620:
621: END IF;
622:
623: END DELETE_ASSOCIATION;

Line 787: AHL_DEBUG_PUB.enable_debug;

783: -- Standard Start of API savepoint
784: SAVEPOINT process_association;
785: -- Check if API is called in debug mode. If yes, enable debug.
786: IF G_DEBUG='Y' THEN
787: AHL_DEBUG_PUB.enable_debug;
788:
789: END IF;
790: -- Debug info.
791: IF G_DEBUG='Y' THEN

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 825: AHL_DEBUG_PUB.debug( 'at end of validate the record pvt .... '||l_record,'+adhariamr+');

821: p_association_rec =>p_x_association_tbl(i),
822: x_record =>l_record
823: );
824: IF G_DEBUG='Y' THEN
825: AHL_DEBUG_PUB.debug( 'at end of validate the record pvt .... '||l_record,'+adhariamr+');
826: END IF;
827:
828:
829:

Line 846: AHL_DEBUG_PUB.debug( 'after validation check: '||l_record,'+adharia+');

842: P_DML_OPERATION => p_x_association_tbl(i).DML_OPERATION,
843: P_RECORD => L_RECORD
844: );
845: IF G_DEBUG='Y' THEN
846: AHL_DEBUG_PUB.debug( 'after validation check: '||l_record,'+adharia+');
847: END IF;
848: END LOOP;
849: END IF;
850:

Line 940: AHL_DEBUG_PUB.debug( 'in update prithwi71+');

936:
937:
938: ELSIF p_x_association_tbl(i).DML_OPERATION = 'U'
939: THEN
940: AHL_DEBUG_PUB.debug( 'in update prithwi71+');
941: OPEN dup_rec_check_upd(c_doc_title_asso_id => p_x_association_tbl(i).doc_title_asso_id,
942: c_aso_object_type_code => p_x_association_tbl(i).aso_object_type_code,
943: c_aso_object_id => p_x_association_tbl(i).aso_object_id,
944: c_document_id => p_x_association_tbl(i).document_id,

Line 1044: AHL_DEBUG_PUB.debug( 'after dup check: '||l_record,'+adharia+');

1040:
1041: -- END LOOP;
1042:
1043: /* IF G_DEBUG='Y' THEN
1044: AHL_DEBUG_PUB.debug( 'after dup check: '||l_record,'+adharia+');
1045: END IF;
1046:
1047: --Standard call to message count
1048: l_msg_count := FND_MSG_PUB.count_msg;

Line 1078: AHL_DEBUG_PUB.debug( 'bafore update Association','+DOBJASS+');

1074: -----------------------------START UPDATE-----------------------------------------------------------------------
1075: ELSIF p_x_association_tbl(i).DML_OPERATION ='U'
1076: THEN
1077: IF G_DEBUG='Y' THEN
1078: AHL_DEBUG_PUB.debug( 'bafore update Association','+DOBJASS+');
1079: END IF;
1080:
1081: --Open the record from base table
1082: OPEN get_doc_assos_rec_b_info(p_x_association_tbl(i).doc_title_asso_id);

Line 1096: AHL_DEBUG_PUB.debug( 'bafore 3 update Association','+DOBJASS+');

1092: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
1093: FND_MSG_PUB.ADD;
1094: ELSE
1095: IF G_DEBUG='Y' THEN
1096: AHL_DEBUG_PUB.debug( 'bafore 3 update Association','+DOBJASS+');
1097: END IF;
1098:
1099: /*-------------------------------------------------------- */
1100: /* procedure name: AHL_DOC_TITLE_ASSOS_PKG.UPDATE_ROW */

Line 1204: AHL_DEBUG_PUB.debug( 'afte all update Association','+DOBJASS+');

1200: END IF;--CREATE/EDIT/DELETE
1201: END LOOP;
1202:
1203: IF G_DEBUG='Y' THEN
1204: AHL_DEBUG_PUB.debug( 'afte all update Association','+DOBJASS+');
1205: END IF;
1206:
1207: l_msg_count := FND_MSG_PUB.count_msg;
1208:

Line 1222: AHL_DEBUG_PUB.debug( 'End of private api Create Association','+DOBJASS+');

1218: COMMIT;
1219: END IF;
1220: -- Debug info
1221: IF G_DEBUG='Y' THEN
1222: AHL_DEBUG_PUB.debug( 'End of private api Create Association','+DOBJASS+');
1223:
1224: END IF;
1225: -- Check if API is called in debug mode. If yes, disable debug.
1226: IF G_DEBUG='Y' THEN

Line 1227: AHL_DEBUG_PUB.disable_debug;

1223:
1224: END IF;
1225: -- Check if API is called in debug mode. If yes, disable debug.
1226: IF G_DEBUG='Y' THEN
1227: AHL_DEBUG_PUB.disable_debug;
1228:
1229: END IF;
1230:
1231: EXCEPTION

Line 1241: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );

1237: p_data => x_msg_data);
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.

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 1246: AHL_DEBUG_PUB.disable_debug;

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;
1247:
1248: END IF;
1249:
1250: WHEN FND_API.G_EXC_ERROR THEN

Line 1259: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );

1255: p_data => X_msg_data);
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.

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 1264: AHL_DEBUG_PUB.disable_debug;

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;
1265:
1266: END IF;
1267:
1268: WHEN OTHERS THEN

Line 1282: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );

1278: p_count => x_msg_count,
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.

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 1287: AHL_DEBUG_PUB.disable_debug;

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;
1288:
1289: END IF;
1290:
1291: END PROCESS_ASSOCIATION;

Line 1370: AHL_DEBUG_PUB.enable_debug;

1366: -- Standard Start of API savepoint
1367: SAVEPOINT insert_assoc_rec;
1368: -- Check if API is called in debug mode. If yes, enable debug.
1369: IF G_DEBUG='Y' THEN
1370: AHL_DEBUG_PUB.enable_debug;
1371:
1372: END IF;
1373: -- Debug info.
1374: IF G_DEBUG='Y' THEN

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 1717: AHL_DEBUG_PUB.debug( 'END OF PRIVATE Insret Asso Rec','+DOBJASS+');

1713: COMMIT;
1714: END IF;
1715: -- Debug info
1716: IF G_DEBUG='Y' THEN
1717: AHL_DEBUG_PUB.debug( 'END OF PRIVATE Insret Asso Rec','+DOBJASS+');
1718:
1719: END IF;
1720: -- Check if API is called in debug mode. If yes, disable debug.
1721: IF G_DEBUG='Y' THEN

Line 1722: AHL_DEBUG_PUB.disable_debug;

1718:
1719: END IF;
1720: -- Check if API is called in debug mode. If yes, disable debug.
1721: IF G_DEBUG='Y' THEN
1722: AHL_DEBUG_PUB.disable_debug;
1723:
1724: END IF;
1725:
1726: EXCEPTION

Line 1736: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );

1732: p_data => x_msg_data);
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.

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 1741: AHL_DEBUG_PUB.disable_debug;

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;
1742:
1743: END IF;
1744:
1745: WHEN Fnd_Api.G_EXC_ERROR THEN

Line 1754: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );

1750: p_data => X_msg_data);
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.

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 1759: AHL_DEBUG_PUB.disable_debug;

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;
1760:
1761: END IF;
1762:
1763: WHEN OTHERS THEN

Line 1777: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );

1773: p_count => x_msg_count,
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.

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 1782: AHL_DEBUG_PUB.disable_debug;

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;
1783:
1784: END IF;
1785:
1786: END INSERT_ASSOC_REC;

Line 1830: AHL_DEBUG_PUB.enable_debug;

1826: -- Standard Start of API savepoint
1827: SAVEPOINT copy_association;
1828: -- Check if API is called in debug mode. If yes, enable debug.
1829: IF G_DEBUG='Y' THEN
1830: AHL_DEBUG_PUB.enable_debug;
1831:
1832: END IF;
1833: -- Debug info.
1834: IF G_DEBUG='Y' THEN

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 1932: AHL_DEBUG_PUB.debug( 'END OF PRIVATE copy Association','+DOBJASS+');

1928: COMMIT;
1929: END IF;
1930: -- Debug info
1931: IF G_DEBUG='Y' THEN
1932: AHL_DEBUG_PUB.debug( 'END OF PRIVATE copy Association','+DOBJASS+');
1933:
1934: END IF;
1935: -- Check if API is called in debug mode. If yes, disable debug.
1936: IF G_DEBUG='Y' THEN

Line 1937: AHL_DEBUG_PUB.disable_debug;

1933:
1934: END IF;
1935: -- Check if API is called in debug mode. If yes, disable debug.
1936: IF G_DEBUG='Y' THEN
1937: AHL_DEBUG_PUB.disable_debug;
1938:
1939: END IF;
1940:
1941: EXCEPTION

Line 1951: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );

1947: p_data => x_msg_data);
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.

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 1956: AHL_DEBUG_PUB.disable_debug;

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;
1957:
1958: END IF;
1959:
1960: WHEN Fnd_Api.G_EXC_ERROR THEN

Line 1968: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );

1964: p_count => x_msg_count,
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.

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 1973: AHL_DEBUG_PUB.disable_debug;

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;
1974:
1975: END IF;
1976:
1977: WHEN OTHERS THEN

Line 1992: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );

1988: p_data => X_msg_data);
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.

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 1998: AHL_DEBUG_PUB.disable_debug;

1994:
1995:
1996: -- Check if API is called in debug mode. If yes, disable debug.
1997:
1998: AHL_DEBUG_PUB.disable_debug;
1999:
2000: END IF;
2001:
2002: END COPY_ASSOCIATION;

Line 2039: AHL_DEBUG_PUB.enable_debug;

2035: -- Standard Start of API savepoint
2036: SAVEPOINT copy_association;
2037: -- Check if API is called in debug mode. If yes, enable debug.
2038: IF G_DEBUG='Y' THEN
2039: AHL_DEBUG_PUB.enable_debug;
2040:
2041: END IF;
2042: -- Debug info.
2043: IF G_DEBUG='Y' THEN

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 2097: AHL_DEBUG_PUB.debug( 'no revisions found that are attached to the object id'|| p_aso_object_id );

2093: IF l_count_assoc = 0
2094: THEN
2095: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_ASSOS_NOT_FOUND');
2096: FND_MSG_PUB.ADD;
2097: AHL_DEBUG_PUB.debug( 'no revisions found that are attached to the object id'|| p_aso_object_id );
2098: ELSE
2099:
2100: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_ASSOS_DELETED');
2101: FND_MSG_PUB.ADD;

Line 2102: AHL_DEBUG_PUB.debug( 'number of revisions found that are attached to the object id'|| p_aso_object_id ||' are '|| l_count_assoc);

2098: ELSE
2099:
2100: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_ASSOS_DELETED');
2101: FND_MSG_PUB.ADD;
2102: AHL_DEBUG_PUB.debug( 'number of revisions found that are attached to the object id'|| p_aso_object_id ||' are '|| l_count_assoc);
2103:
2104: END IF;
2105:
2106: END IF;

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 2135: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );

2131: p_data => x_msg_data);
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.

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 2140: AHL_DEBUG_PUB.disable_debug;

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;
2141:
2142: END IF;
2143:
2144: WHEN Fnd_Api.G_EXC_ERROR THEN

Line 2152: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );

2148: p_count => x_msg_count,
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.

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 2157: AHL_DEBUG_PUB.disable_debug;

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;
2158:
2159: END IF;
2160:
2161: WHEN OTHERS THEN

Line 2176: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );

2172: p_data => X_msg_data);
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.

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 2182: AHL_DEBUG_PUB.disable_debug;

2178:
2179:
2180: -- Check if API is called in debug mode. If yes, disable debug.
2181:
2182: AHL_DEBUG_PUB.disable_debug;
2183:
2184: END IF;
2185:
2186: