DBA Data[Home] [Help]

APPS.CST_OSFMUPGRADE_PVT dependencies on FND_FILE

Line 56: FND_FILE.PUT_LINE(FND_FILE.LOG,'Uncosted transactions exist. Please ensure that '||

52: MP.organization_id = nvl(p_organization_id, MP.organization_id) and
53: rownum = 1;
54:
55: if (l_mmtt <> 0 OR l_uncosted_mmt <> 0 ) THEN
56: FND_FILE.PUT_LINE(FND_FILE.LOG,'Uncosted transactions exist. Please ensure that '||
57: 'all transactions are costed before running this script');
58: FND_FILE.PUT_LINE(FND_FILE.LOG,' Pending MMTT txns : '||l_mmtt||
59: ' Uncosted/Errored MMT txns :'||l_uncosted_mmt);
60: CONC_STATUS := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','Uncosted transactions exists. Please ensure that all transactions are costed');

Line 58: FND_FILE.PUT_LINE(FND_FILE.LOG,' Pending MMTT txns : '||l_mmtt||

54:
55: if (l_mmtt <> 0 OR l_uncosted_mmt <> 0 ) THEN
56: FND_FILE.PUT_LINE(FND_FILE.LOG,'Uncosted transactions exist. Please ensure that '||
57: 'all transactions are costed before running this script');
58: FND_FILE.PUT_LINE(FND_FILE.LOG,' Pending MMTT txns : '||l_mmtt||
59: ' Uncosted/Errored MMT txns :'||l_uncosted_mmt);
60: CONC_STATUS := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','Uncosted transactions exists. Please ensure that all transactions are costed');
61: RETURN;
62: END IF;

Line 64: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Updating WRO ...');

60: CONC_STATUS := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','Uncosted transactions exists. Please ensure that all transactions are costed');
61: RETURN;
62: END IF;
63:
64: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Updating WRO ...');
65: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_organization_id : '||p_organization_id);
66:
67: IF (p_organization_id IS NULL) THEN
68: l_stmt_num := 30;

Line 65: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_organization_id : '||p_organization_id);

61: RETURN;
62: END IF;
63:
64: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Updating WRO ...');
65: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_organization_id : '||p_organization_id);
66:
67: IF (p_organization_id IS NULL) THEN
68: l_stmt_num := 30;
69: UPDATE wip_requirement_operations wro

Line 106: fnd_file.put_line(fnd_file.log,ERRBUF);

102: RETCODE := SQLCODE;
103: ERRBUF := 'Inconsistent API version'||l_stmt_num||'): '||
104: substr(SQLERRM, 1, 200);
105: CONC_STATUS := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', ERRBUF);
106: fnd_file.put_line(fnd_file.log,ERRBUF);
107: WHEN OTHERS THEN
108: RETCODE := SQLCODE;
109: ERRBUF := 'CST_OSFMUpgrade_PVT.update_quantity_issued('||l_stmt_num||'):'||
110: substr(SQLERRM, 1, 200);

Line 112: fnd_file.put_line(fnd_file.log,ERRBUF);

108: RETCODE := SQLCODE;
109: ERRBUF := 'CST_OSFMUpgrade_PVT.update_quantity_issued('||l_stmt_num||'):'||
110: substr(SQLERRM, 1, 200);
111: CONC_STATUS := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', ERRBUF);
112: fnd_file.put_line(fnd_file.log,ERRBUF);
113:
114: END Update_Quantity_Issued;
115:
116: END CST_OSFMUpgrade_PVT;