[Home] [Help]
481: l_object_version_number NUMBER;
482: l_record VARCHAR2(4000);
483: --
484: BEGIN
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;
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.
500: IF FND_API.to_boolean(p_init_msg_list)
501: THEN
502: FND_MSG_PUB.initialize;
503: END IF;
545: DELETE FROM AHL_DOC_TITLE_ASSOS_TL
546: WHERE doc_title_asso_id = p_association_rec.doc_title_asso_id;
547: --
548: */
549: --Standard check for commit;
550: IF FND_API.TO_BOOLEAN(p_commit) THEN
551: COMMIT;
552: END IF;
553: -- Debug info
779: l_association_tl_info get_doc_assos_rec_tl_info%ROWTYPE;
780: l_record VARCHAR(4000);
781: l_found_flag VARCHAR2(5) := 'N';
782: BEGIN
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;
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.
798: IF FND_API.to_boolean(p_init_msg_list)
799: THEN
800: FND_MSG_PUB.initialize;
801: END IF;
851:
852:
853:
854:
855: --Standard call to message count
856: l_msg_count := FND_MSG_PUB.count_msg;
857:
858: IF l_msg_count > 0 THEN
859: X_msg_count := l_msg_count;
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;
1049:
1050: IF l_msg_count > 0 THEN
1051: X_msg_count := l_msg_count;
1194: X_LAST_UPDATE_LOGIN => fnd_global.login_id);
1195: --Assign the doc title asso id,object version number
1196: p_x_association_tbl(i).doc_title_asso_id := l_doc_title_asso_id;
1197: p_x_association_tbl(i).object_version_number := 1;
1198: --Standard check to count messages
1199: -----------------------------END CREATE------------------------------------------------------------------------
1200: END IF;--CREATE/EDIT/DELETE
1201: END LOOP;
1202:
1212: RAISE FND_API.G_EXC_ERROR;
1213: END IF;
1214:
1215: END IF;
1216: --Standard check for commit
1217: IF FND_API.TO_BOOLEAN(p_commit) THEN
1218: COMMIT;
1219: END IF;
1220: -- Debug info
1362: l_doc_title_asso_id NUMBER;
1363: l_association_info association_rec;
1364: l_record VARCHAR2(4000);
1365: BEGIN
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;
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.
1381: IF Fnd_Api.to_boolean(p_init_msg_list)
1382: THEN
1383: Fnd_Msg_Pub.initialize;
1384: END IF;
1408: P_DML_OPERATION => 'X',
1409: P_RECORD => L_RECORD
1410: );
1411:
1412: --Standard call to message count
1413: l_msg_count := Fnd_Msg_Pub.count_msg;
1414:
1415: IF l_msg_count > 0 THEN
1416: X_msg_count := l_msg_count;
1698: X_CREATED_BY => fnd_global.user_id,
1699: X_LAST_UPDATE_DATE => sysdate,
1700: X_LAST_UPDATED_BY => fnd_global.user_id,
1701: X_LAST_UPDATE_LOGIN => fnd_global.login_id);
1702: --Standard check to count messages
1703: l_msg_count := Fnd_Msg_Pub.count_msg;
1704:
1705: IF l_msg_count > 0 THEN
1706: X_msg_count := l_msg_count;
1707: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1708: RAISE Fnd_Api.G_EXC_ERROR;
1709: END IF;
1710: END IF;
1711: --Standard check for commit
1712: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
1713: COMMIT;
1714: END IF;
1715: -- Debug info
1822: l_dummy VARCHAR2(2000);
1823: l_row_id VARCHAR2(30);
1824: l_association_rec get_assos_b_cur%ROWTYPE;
1825: BEGIN
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;
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.
1841: IF Fnd_Api.to_boolean(p_init_msg_list)
1842: THEN
1843: Fnd_Msg_Pub.initialize;
1844: END IF;
1914: x_msg_data => x_msg_data);
1915:
1916: END LOOP;
1917: CLOSE get_assos_b_cur;
1918: --Standard check to count messages
1919: l_msg_count := Fnd_Msg_Pub.count_msg;
1920:
1921: IF l_msg_count > 0 THEN
1922: X_msg_count := l_msg_count;
1922: X_msg_count := l_msg_count;
1923: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1924: RAISE Fnd_Api.G_EXC_ERROR;
1925: END IF;
1926: --Standard check for commit
1927: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
1928: COMMIT;
1929: END IF;
1930: -- Debug info
2031:
2032: l_doc_asso_rec get_all_doc_assos%ROWTYPE;
2033: l_count_assoc NUMBER := 0;
2034: BEGIN
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;
2046:
2047: END IF;
2048: END IF;
2049:
2050: -- Standard call to check for call compatibility.
2051: IF Fnd_Api.to_boolean(p_init_msg_list)
2052: THEN
2053: Fnd_Msg_Pub.initialize;
2054: END IF;