DBA Data[Home] [Help]

APPS.AHL_DI_DOC_REVISION_PVT dependencies on FND_FILE

Line 1638: fnd_file.put_line(fnd_file.log,'Associations for following documents are checked and updated appropriately');

1634: set revision_status_code ='OBSOLETE'
1635: where trunc(obsolete_date) <= trunc(sysdate)
1636: and revision_status_code <> 'OBSOLETE';
1637:
1638: fnd_file.put_line(fnd_file.log,'Associations for following documents are checked and updated appropriately');
1639: OPEN get_all_document_ids;
1640: LOOP
1641: FETCH get_all_document_ids INTO l_document_id,l_document_no;
1642: EXIT WHEN get_all_document_ids%NOTFOUND;

Line 1644: fnd_file.put_line(fnd_file.log,' document_no -> ' || l_document_no);

1640: LOOP
1641: FETCH get_all_document_ids INTO l_document_id,l_document_no;
1642: EXIT WHEN get_all_document_ids%NOTFOUND;
1643: UPDATE_ASSOCIATIONS(NULL,l_document_id);
1644: fnd_file.put_line(fnd_file.log,' document_no -> ' || l_document_no);
1645: END LOOP;
1646: CLOSE get_all_document_ids;
1647: EXCEPTION
1648: WHEN OTHERS THEN

Line 1653: fnd_file.put_line(fnd_file.log, errbuf);

1649: retcode := 2;
1650: FND_MESSAGE.SET_NAME('AHL','AHL_DI_CONC_UPDT_FAILED');
1651: FND_MSG_PUB.ADD;
1652: errbuf := FND_MSG_PUB.GET;
1653: fnd_file.put_line(fnd_file.log, errbuf);
1654:
1655: END UPDATE_ASSOCIATIONS_CONCURRENT;
1656: END AHL_DI_DOC_REVISION_PVT;