[Home] [Help]
133:
134:
135: BEGIN
136:
137: -- Standard Start of API savepoint
138: SAVEPOINT create_association;
139: -- Check if API is called in debug mode. If yes, enable debug.
140: IF G_DEBUG='Y' THEN
141: AHL_DEBUG_PUB.enable_debug;
147: AHL_DEBUG_PUB.debug( 'enter ahl_di_asso_doc_aso_pub.Create Association','+DOBJASS+');
148:
149: END IF;
150: END IF;
151: -- Standard call to check for call compatibility.
152: IF FND_API.to_boolean(l_init_msg_list)
153: THEN
154: FND_MSG_PUB.initialize;
155: END IF;
283: l_association_tbl(i).attribute14 := p_x_association_tbl(i).attribute14;
284: l_association_tbl(i).attribute15 := p_x_association_tbl(i).attribute15;
285: l_association_tbl(i).delete_flag := p_x_association_tbl(i).delete_flag;
286: l_association_tbl(i).object_version_number := p_x_association_tbl(i).object_version_number;
287: --Standard check to count messages
288: l_msg_count := FND_MSG_PUB.count_msg;
289: IF l_msg_count > 0 THEN
290: X_msg_count := l_msg_count;
291: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
363: x_msg_count => l_msg_count,
364: x_msg_data => l_msg_data
365: );
366:
367: --Standard check to count messages
368: l_msg_count := FND_MSG_PUB.count_msg;
369:
370: IF l_msg_count > 0 THEN
371: X_msg_count := l_msg_count;
436: /*---------------------------------------------------------*/
437: /* End ; Date : Dec 10 2001 */
438: /*---------------------------------------------------------*/
439:
440: --Standard check for commit
441: IF FND_API.TO_BOOLEAN(p_commit) THEN
442: COMMIT;
443: END IF;
444: -- Debug info
600: l_doc_revision_no VARCHAR2(30);
601: -- }} adharia -- bug #2450326 - added- 9/7/2002
602:
603: BEGIN
604: -- Standard Start of API savepoint
605: SAVEPOINT modify_association;
606: -- Check if API is called in debug mode. If yes, enable debug.
607: IF G_DEBUG='Y' THEN
608: AHL_DEBUG_PUB.enable_debug;
614: AHL_DEBUG_PUB.debug( 'enter ahl_di_asso_doc_aso_pub.Rajanth Testing the code','+DOBJASS+');
615:
616: END IF;
617: END IF;
618: -- Standard call to check for call compatibility.
619: IF FND_API.to_boolean(l_init_msg_list)
620: THEN
621: FND_MSG_PUB.initialize;
622: END IF;
822: l_association_tbl(i).attribute14 := p_x_association_tbl(i).attribute14;
823: l_association_tbl(i).attribute15 := p_x_association_tbl(i).attribute15;
824: l_association_tbl(i).delete_flag := p_x_association_tbl(i).delete_flag;
825: l_association_tbl(i).object_version_number := p_x_association_tbl(i).object_version_number;
826: --Standard check to count messages
827: l_msg_count := FND_MSG_PUB.count_msg;
828:
829: IF l_msg_count > 0 THEN
830: X_msg_count := l_msg_count;
896: x_return_status => l_return_status,
897: x_msg_count => l_msg_count,
898: x_msg_data => l_msg_data
899: );
900: --Standard check to count messages
901: l_msg_count := FND_MSG_PUB.count_msg;
902:
903: IF l_msg_count > 0 THEN
904: X_msg_count := l_msg_count;
955: /*---------------------------------------------------------*/
956: /* End ; Date : Dec 10 2001 */
957: /*---------------------------------------------------------*/
958:
959: --Standard check for commit
960: IF FND_API.TO_BOOLEAN(p_commit) THEN
961: COMMIT;
962: END IF;
963: -- Debug info
1082: l_post_C_msg_count NUMBER;
1083: l_post_C_msg_data VARCHAR2(2000);
1084: l_post_C_return_status VARCHAR2(1);
1085: BEGIN
1086: -- Standard Start of API savepoint
1087: SAVEPOINT process_association;
1088: -- Check if API is called in debug mode. If yes, enable debug.
1089: IF G_DEBUG='Y' THEN
1090: AHL_DEBUG_PUB.enable_debug;
1096: AHL_DEBUG_PUB.debug( 'enter ahl_di_asso_doc_aso_pub.Process Association','+DOBJASS+');
1097:
1098: END IF;
1099: END IF;
1100: -- Standard call to check for call compatibility.
1101: IF FND_API.to_boolean(l_init_msg_list)
1102: THEN
1103: FND_MSG_PUB.initialize;
1104: END IF;
1264: l_association_tbl(i).attribute14 := p_x_association_tblm(i).attribute14;
1265: l_association_tbl(i).attribute15 := p_x_association_tblm(i).attribute15;
1266: l_association_tbl(i).delete_flag := p_x_association_tblm(i).delete_flag;
1267: l_association_tbl(i).object_version_number := p_x_association_tblm(i).object_version_number;
1268: --Standard check to count messages
1269: l_msg_count := FND_MSG_PUB.count_msg;
1270:
1271: IF l_msg_count > 0 THEN
1272: X_msg_count := l_msg_count;
1297: x_return_status => l_return_status,
1298: x_msg_count => l_msg_count,
1299: x_msg_data => l_msg_data
1300: );
1301: --Standard check to count messages
1302: l_msg_count := FND_MSG_PUB.count_msg;
1303:
1304: IF l_msg_count > 0 THEN
1305: X_msg_count := l_msg_count;
1478: l_association_tblc(i).attribute14 := p_x_association_tblc(i).attribute14;
1479: l_association_tblc(i).attribute15 := p_x_association_tblc(i).attribute15;
1480: l_association_tblc(i).delete_flag := p_x_association_tblc(i).delete_flag;
1481: l_association_tblc(i).object_version_number := p_x_association_tblc(i).object_version_number;
1482: --Standard check to count messages
1483: l_msg_count := FND_MSG_PUB.count_msg;
1484: IF l_msg_count > 0 THEN
1485: X_msg_count := l_msg_count;
1486: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1513: x_msg_count => l_msg_count,
1514: x_msg_data => l_msg_data
1515: );
1516:
1517: --Standard check to count messages
1518: l_msg_count := FND_MSG_PUB.count_msg;
1519:
1520: IF l_msg_count > 0 THEN
1521: X_msg_count := l_msg_count;
1532: END LOOP;
1533: END IF;
1534: END IF;
1535: --
1536: --Standard check for commit
1537: IF FND_API.TO_BOOLEAN(p_commit) THEN
1538: COMMIT;
1539: END IF;
1540: -- Debug info