APPS.AHL_DI_DOC_REVISION_PVT dependencies on STANDARD

Line 379: -- Standard Start of API savepoint

375: --Added for storing local variables to pass to Table Handler- Prakash 26-Dec-2001
376: l_row_id VARCHAR2(30);
377: --End of addition: Prakash 26-dec-2001
378: BEGIN
379: -- Standard Start of API savepoint
380: SAVEPOINT create_revision;
381: -- Check if API is called in debug mode. If yes, enable debug.
382: IF G_DEBUG='Y' THEN
383: AHL_DEBUG_PUB.enable_debug;

Line 393: -- Standard call to check for call compatibility.

389: AHL_DEBUG_PUB.debug( 'enter ahl_di_doc_revision_pvt.Create Revision','+REV+');
390:
391: END IF;
392: END IF;
393: -- Standard call to check for call compatibility.
394: IF FND_API.to_boolean(p_init_msg_list)
395: THEN
396: FND_MSG_PUB.initialize;
397: END IF;

Line 432: -- Standard call to get message count and if count is get message info.

428: p_issue_number => p_x_revision_tbl(i).issue_number,
429: p_delete_flag => p_x_revision_tbl(i).delete_flag
430: );
431: END LOOP;
432: -- Standard call to get message count and if count is get message info.
433: l_msg_count := FND_MSG_PUB.count_msg;
434:
435:
436: IF l_msg_count > 0 THEN

Line 535: -- Standard check of p_commit.

531: END IF;
532: END IF;
533: END LOOP;
534: END IF;
535: -- Standard check of p_commit.
536: IF FND_API.TO_BOOLEAN(p_commit) THEN
537: COMMIT;
538: END IF;
539: -- Debug info

Line 687: -- Standard Start of API savepoint

683: l_comments VARCHAR2(2000);
684: l_revision_info get_doc_revisions_b_rec_info%ROWTYPE;
685: --
686: BEGIN
687: -- Standard Start of API savepoint
688: SAVEPOINT modify_revision;
689: -- Check if API is called in debug mode. If yes, enable debug.
690: IF G_DEBUG='Y' THEN
691: AHL_DEBUG_PUB.enable_debug;

Line 701: -- Standard call to check for call compatibility.

697: AHL_DEBUG_PUB.debug( 'enter ahl_di_doc_revision_pvt.Modify Revision','+REV+');
698:
699: END IF;
700: END IF;
701: -- Standard call to check for call compatibility.
702: IF FND_API.to_boolean(p_init_msg_list)
703: THEN
704: FND_MSG_PUB.initialize;
705: END IF;

Line 741: -- Standard call to get message count

737: p_delete_flag => p_x_revision_tbl(i).delete_flag
738: );
739: END LOOP;
740: --End of Validations
741: -- Standard call to get message count
742: l_msg_count := FND_MSG_PUB.count_msg;
743: IF l_msg_count > 0 THEN
744: X_msg_count := l_msg_count;
745: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 862: -- Standard check of p_commit.

858: );
859: END IF;
860: END LOOP;
861: END IF;
862: -- Standard check of p_commit.
863: IF FND_API.TO_BOOLEAN(p_commit) THEN
864: COMMIT;
865: END IF;
866: -- Debug info

Line 968: -- Standard Start of API savepoint

964: l_object_version_number NUMBER;
965: l_effective_date DATE;
966: l_obsolete_date DATE;
967: BEGIN
968: -- Standard Start of API savepoint
969: SAVEPOINT delete_revision;
970: -- Standard call to check for call compatibility.
971: IF FND_API.to_boolean(p_init_msg_list)
972: THEN

Line 970: -- Standard call to check for call compatibility.

966: l_obsolete_date DATE;
967: BEGIN
968: -- Standard Start of API savepoint
969: SAVEPOINT delete_revision;
970: -- Standard call to check for call compatibility.
971: IF FND_API.to_boolean(p_init_msg_list)
972: THEN
973: FND_MSG_PUB.initialize;
974: END IF;

Line 1024: -- Standard check of p_commit.

1020: SET OBSOLETE_DATE = p_x_revision_tbl(i).obsolete_date
1021: WHERE ROWID = l_rowid;
1022: END LOOP;
1023: END IF;
1024: -- Standard check of p_commit.
1025: IF FND_API.TO_BOOLEAN(p_commit) THEN
1026: COMMIT;
1027: END IF;
1028: