[Home] [Help]
629: l_object_version_number NUMBER;
630: l_record VARCHAR2(4000);
631: --
632: BEGIN
633: -- Standard Start of API savepoint
634: SAVEPOINT delete_association;
635: -- Check if API is called in debug mode. If yes, enable debug.
636: IF G_DEBUG='Y' THEN
637: AHL_DEBUG_PUB.enable_debug;
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.
648: IF FND_API.to_boolean(p_init_msg_list)
649: THEN
650: FND_MSG_PUB.initialize;
651: END IF;
693: DELETE FROM AHL_DOC_TITLE_ASSOS_TL
694: WHERE doc_title_asso_id = p_association_rec.doc_title_asso_id;
695: --
696: */
697: --Standard check for commit;
698: IF FND_API.TO_BOOLEAN(p_commit) THEN
699: COMMIT;
700: END IF;
701: -- Debug info
927: l_association_tl_info get_doc_assos_rec_tl_info%ROWTYPE;
928: l_record VARCHAR(4000);
929: l_found_flag VARCHAR2(5) := 'N';
930: BEGIN
931: -- Standard Start of API savepoint
932: SAVEPOINT process_association;
933: -- Check if API is called in debug mode. If yes, enable debug.
934: IF G_DEBUG='Y' THEN
935: AHL_DEBUG_PUB.enable_debug;
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.
946: IF FND_API.to_boolean(p_init_msg_list)
947: THEN
948: FND_MSG_PUB.initialize;
949: END IF;
1193: /* IF G_DEBUG='Y' THEN
1194: AHL_DEBUG_PUB.debug( 'after dup check: '||l_record,'+adharia+');
1195: END IF;
1196:
1197: --Standard call to message count
1198: l_msg_count := FND_MSG_PUB.count_msg;
1199:
1200: IF l_msg_count > 0 THEN
1201: X_msg_count := l_msg_count;
1344: X_LAST_UPDATE_LOGIN => fnd_global.login_id);
1345: --Assign the doc title asso id,object version number
1346: p_x_association_tbl(i).doc_title_asso_id := l_doc_title_asso_id;
1347: p_x_association_tbl(i).object_version_number := 1;
1348: --Standard check to count messages
1349: -----------------------------END CREATE------------------------------------------------------------------------
1350: END IF;--CREATE/EDIT/DELETE
1351: END LOOP;
1352:
1366: RAISE FND_API.G_EXC_ERROR;
1367: END IF;
1368:
1369: END IF;
1370: --Standard check for commit
1371: IF FND_API.TO_BOOLEAN(p_commit) THEN
1372: IF G_DEBUG='Y' THEN
1373: AHL_DEBUG_PUB.debug( 'before commit');
1374: END IF;
1519: l_doc_title_asso_id NUMBER;
1520: l_association_info association_rec;
1521: l_record VARCHAR2(4000);
1522: BEGIN
1523: -- Standard Start of API savepoint
1524: SAVEPOINT insert_assoc_rec;
1525: -- Check if API is called in debug mode. If yes, enable debug.
1526: IF G_DEBUG='Y' THEN
1527: AHL_DEBUG_PUB.enable_debug;
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.
1538: IF Fnd_Api.to_boolean(p_init_msg_list)
1539: THEN
1540: Fnd_Msg_Pub.initialize;
1541: END IF;
1565: P_DML_OPERATION => 'X',
1566: P_RECORD => L_RECORD
1567: );
1568:
1569: --Standard call to message count
1570: l_msg_count := Fnd_Msg_Pub.count_msg;
1571:
1572: IF l_msg_count > 0 THEN
1573: X_msg_count := l_msg_count;
1855: X_CREATED_BY => fnd_global.user_id,
1856: X_LAST_UPDATE_DATE => sysdate,
1857: X_LAST_UPDATED_BY => fnd_global.user_id,
1858: X_LAST_UPDATE_LOGIN => fnd_global.login_id);
1859: --Standard check to count messages
1860: l_msg_count := Fnd_Msg_Pub.count_msg;
1861:
1862: IF l_msg_count > 0 THEN
1863: X_msg_count := l_msg_count;
1864: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1865: RAISE Fnd_Api.G_EXC_ERROR;
1866: END IF;
1867: END IF;
1868: --Standard check for commit
1869: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
1870: COMMIT;
1871: END IF;
1872: -- Debug info
1979: l_dummy VARCHAR2(2000);
1980: l_row_id VARCHAR2(30);
1981: l_association_rec get_assos_b_cur%ROWTYPE;
1982: BEGIN
1983: -- Standard Start of API savepoint
1984: SAVEPOINT copy_association;
1985: -- Check if API is called in debug mode. If yes, enable debug.
1986: IF G_DEBUG='Y' THEN
1987: AHL_DEBUG_PUB.enable_debug;
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.
1998: IF Fnd_Api.to_boolean(p_init_msg_list)
1999: THEN
2000: Fnd_Msg_Pub.initialize;
2001: END IF;
2071: x_msg_data => x_msg_data);
2072:
2073: END LOOP;
2074: CLOSE get_assos_b_cur;
2075: --Standard check to count messages
2076: l_msg_count := Fnd_Msg_Pub.count_msg;
2077:
2078: IF l_msg_count > 0 THEN
2079: X_msg_count := l_msg_count;
2079: X_msg_count := l_msg_count;
2080: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2081: RAISE Fnd_Api.G_EXC_ERROR;
2082: END IF;
2083: --Standard check for commit
2084: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
2085: COMMIT;
2086: END IF;
2087: -- Debug info
2188:
2189: l_doc_asso_rec get_all_doc_assos%ROWTYPE;
2190: l_count_assoc NUMBER := 0;
2191: BEGIN
2192: -- Standard Start of API savepoint
2193: SAVEPOINT copy_association;
2194: -- Check if API is called in debug mode. If yes, enable debug.
2195: IF G_DEBUG='Y' THEN
2196: AHL_DEBUG_PUB.enable_debug;
2203:
2204: END IF;
2205: END IF;
2206:
2207: -- Standard call to check for call compatibility.
2208: IF Fnd_Api.to_boolean(p_init_msg_list)
2209: THEN
2210: Fnd_Msg_Pub.initialize;
2211: END IF;