[Home] [Help]
209: l_doc_sub_type_code VARCHAR2(30);
210: l_object_version_number NUMBER;
211: l_meaning VARCHAR2(80);
212: BEGIN
213: -- Standard Start of API savepoint
214: SAVEPOINT delete_doc_type_assoc;
215: -- Check if API is called in debug mode. If yes, enable debug.
216: IF G_DEBUG='Y' THEN
217: AHL_DEBUG_PUB.enable_debug;
223: AHL_DEBUG_PUB.debug( 'enter ahl_di_pro_type_aso_pvt.Delete Doc Type','+DOCTY+');
224:
225: END IF;
226: END IF;
227: -- Standard call to check for call compatibility.
228: IF FND_API.to_boolean(p_init_msg_list)
229: THEN
230: FND_MSG_PUB.initialize;
231: END IF;
296: WHERE ROWID = l_rowid;
297: END IF;
298: END LOOP;
299:
300: --Standard check to count messages
301: l_msg_count := FND_MSG_PUB.count_msg;
302:
303: IF l_msg_count > 0 THEN
304: X_msg_count := l_msg_count;
304: X_msg_count := l_msg_count;
305: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
306: RAISE FND_API.G_EXC_ERROR;
307: END IF;
308: --Standard check for commit
309: IF FND_API.TO_BOOLEAN(p_commit) THEN
310: COMMIT;
311: END IF;
312: -- Debug info
426: l_meaning VARCHAR2(80);
427: l_document_sub_type_id NUMBER;
428: l_doc_type_assoc_info doc_type_assoc_rec;
429: BEGIN
430: -- Standard Start of API savepoint
431: SAVEPOINT create_doc_type_assoc;
432: -- Check if API is called in debug mode. If yes, enable debug.
433: IF G_DEBUG='Y' THEN
434: AHL_DEBUG_PUB.enable_debug;
440: AHL_DEBUG_PUB.debug( 'enter ahl_di_pro_type_aso_pvt.Create Doc Type','+DOCTY+');
441:
442: END IF;
443: END IF;
444: -- Standard call to check for call compatibility.
445: IF FND_API.to_boolean(p_init_msg_list)
446: THEN
447: FND_MSG_PUB.initialize;
448: END IF;
466: p_doc_type_code => p_x_doc_type_assoc_tbl(i).doc_type_code,
467: p_doc_sub_type_code => p_x_doc_type_assoc_tbl(i).doc_sub_type_code,
468: p_delete_flag => p_x_doc_type_assoc_tbl(i).delete_flag);
469: END LOOP;
470: --Standard check for count messages
471: l_msg_count := FND_MSG_PUB.count_msg;
472:
473: IF l_msg_count > 0 THEN
474: X_msg_count := l_msg_count;
572: fnd_global.user_id,
573: fnd_global.login_id
574: );
575: p_x_doc_type_assoc_tbl(i).document_sub_type_id := l_document_sub_type_id;
576: --Standard check for messages
577: l_msg_count := FND_MSG_PUB.count_msg;
578:
579: IF l_msg_count > 0 THEN
580: X_msg_count := l_msg_count;
583: END IF;
584: END IF;
585: END LOOP;
586: END IF;
587: --Standard check for commit
588: IF FND_API.TO_BOOLEAN(p_commit) THEN
589: COMMIT;
590: END IF;
591: -- Debug info
752: l_meaning VARCHAR2(80);
753: l_msg_count_temp NUMBER(3);
754: l_doc_type_assoc_info get_doc_sub_rec_info%ROWTYPE;
755: BEGIN
756: -- Standard Start of API savepoint
757: SAVEPOINT modify_doc_type_assoc;
758: -- Check if API is called in debug mode. If yes, enable debug.
759: IF G_DEBUG='Y' THEN
760: AHL_DEBUG_PUB.enable_debug;
766: AHL_DEBUG_PUB.debug( 'enter ahl_di_pro_type_aso_pvt.Modify Doc Type','+DOCTY+');
767:
768: END IF;
769: END IF;
770: -- Standard call to check for call compatibility.
771: IF FND_API.to_boolean(p_init_msg_list)
772: THEN
773: FND_MSG_PUB.initialize;
774: END IF;
792: p_doc_type_code => p_x_doc_type_assoc_tbl(i).doc_type_code,
793: p_doc_sub_type_code => p_x_doc_type_assoc_tbl(i).doc_sub_type_code,
794: p_delete_flag => p_x_doc_type_assoc_tbl(i).delete_flag);
795: END LOOP;
796: --Standard check for messages
797: l_msg_count := FND_MSG_PUB.count_msg;
798:
799: IF l_msg_count > 0 THEN
800: X_msg_count := l_msg_count;
988: IF G_DEBUG='Y' THEN
989: AHL_DEBUG_PUB.debug( 'The error count '||FND_MSG_PUB.count_msg);
990:
991: END IF;
992: --Standard check for messages
993: l_msg_count := FND_MSG_PUB.count_msg;
994:
995: IF l_msg_count > 0 THEN
996: X_msg_count := l_msg_count;
997: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
998: RAISE FND_API.G_EXC_ERROR;
999: END IF;
1000:
1001: --Standard check for commit
1002: IF FND_API.TO_BOOLEAN(p_commit) THEN
1003: COMMIT;
1004: END IF;
1005: -- Debug info