eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AS_STATUSES_PKG dependencies on FND_FILE

Line 688: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error, cannot complete Concurrent Program') ;

684: Write_Log(l_module, 1, 'SQLCODE ' || to_char(SQLCODE) ||
685: ' SQLERRM ' || substr(SQLERRM, 1, 100));
686: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);
687: IF l_status = TRUE THEN
688: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error, cannot complete Concurrent Program') ;
689: END IF ;
690: END PRE_UPDATE;
691:
692: PROCEDURE POST_UPDATE(

Line 713: FND_FILE.put(p_which, p_mssg);

709: BEGIN
710: IF l_debug THEN
711: AS_UTILITY_PVT.Debug_Message(p_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, p_mssg);
712: ELSE
713: FND_FILE.put(p_which, p_mssg);
714: FND_FILE.NEW_LINE(p_which, 1);
715: END IF;
716: END Write_Log;
717:

Line 714: FND_FILE.NEW_LINE(p_which, 1);

710: IF l_debug THEN
711: AS_UTILITY_PVT.Debug_Message(p_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, p_mssg);
712: ELSE
713: FND_FILE.put(p_which, p_mssg);
714: FND_FILE.NEW_LINE(p_which, 1);
715: END IF;
716: END Write_Log;
717:
718:

Line 1148: FND_FILE.PUT_LINE(FND_FILE.LOG,'Minimum Id - Max id for as_accesses_all_all for this worker :' || l_min_id ||' to '||l_max_id);

1144: END IF;
1145:
1146:
1147: if (l_debug) Then
1148: FND_FILE.PUT_LINE(FND_FILE.LOG,'Minimum Id - Max id for as_accesses_all_all for this worker :' || l_min_id ||' to '||l_max_id);
1149: end if;
1150:
1151:
1152:

Line 1159: FND_FILE.PUT_LINE(FND_FILE.LOG,'Current loop count:' || l_count);

1155:
1156: while (l_count <= l_max_id)
1157: loop
1158: if (l_debug) Then
1159: FND_FILE.PUT_LINE(FND_FILE.LOG,'Current loop count:' || l_count);
1160: end if;
1161: -- update statements here
1162: IF Upper(X_STATUS_CODE) <> 'ALL' THEN
1163: UPDATE /*+ INDEX(acc AS_ACCESSES_ALL_ALL_MT1)*/ AS_ACCESSES_ALL acc

Line 1243: FND_FILE.PUT_LINE(FND_FILE.LOG,'Update of denormed open flag in as_accesses_all_all (for leads and opps) finished successfully');

1239: commit;
1240:
1241:
1242: if l_debug then
1243: FND_FILE.PUT_LINE(FND_FILE.LOG,'Update of denormed open flag in as_accesses_all_all (for leads and opps) finished successfully');
1244: FND_FILE.PUT_LINE(FND_FILE.LOG,'for range :'|| l_min_id ||' to '||l_max_id);
1245: FND_FILE.PUT_LINE(FND_FILE.LOG,'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1246: end if;
1247:

Line 1244: FND_FILE.PUT_LINE(FND_FILE.LOG,'for range :'|| l_min_id ||' to '||l_max_id);

1240:
1241:
1242: if l_debug then
1243: FND_FILE.PUT_LINE(FND_FILE.LOG,'Update of denormed open flag in as_accesses_all_all (for leads and opps) finished successfully');
1244: FND_FILE.PUT_LINE(FND_FILE.LOG,'for range :'|| l_min_id ||' to '||l_max_id);
1245: FND_FILE.PUT_LINE(FND_FILE.LOG,'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1246: end if;
1247:
1248:

Line 1245: FND_FILE.PUT_LINE(FND_FILE.LOG,'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

1241:
1242: if l_debug then
1243: FND_FILE.PUT_LINE(FND_FILE.LOG,'Update of denormed open flag in as_accesses_all_all (for leads and opps) finished successfully');
1244: FND_FILE.PUT_LINE(FND_FILE.LOG,'for range :'|| l_min_id ||' to '||l_max_id);
1245: FND_FILE.PUT_LINE(FND_FILE.LOG,'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1246: end if;
1247:
1248:
1249: EXCEPTION

Line 1259: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error, cannot complete Concurrent Program') ;

1255: Write_log (l_module, 1, 'SQLCODE ' || to_char(SQLCODE) ||
1256: ' SQLERRM ' || substr(SQLERRM, 1, 100));
1257: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);
1258: IF l_status = TRUE THEN
1259: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error, cannot complete Concurrent Program') ;
1260: END IF ;
1261: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1262: ERRBUF := ERRBUF||sqlerrm;
1263: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1268: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error, cannot complete Concurrent Program') ;

1264: ROLLBACK;
1265: Write_Log(l_module, 1, 'Unexpected error in as_statuses_pkg.update_oppty_accesses');
1266: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);
1267: IF l_status = TRUE THEN
1268: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error, cannot complete Concurrent Program') ;
1269: END IF ;
1270: WHEN others THEN
1271: ERRBUF := SQLERRM;
1272: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1279: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error, cannot complete Concurrent Program') ;

1275: Write_Log(l_module, 1, 'SQLCODE ' || to_char(SQLCODE) ||
1276: ' SQLERRM ' || substr(SQLERRM, 1, 100));
1277: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);
1278: IF l_status = TRUE THEN
1279: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error, cannot complete Concurrent Program') ;
1280: END IF ;
1281: end UPDATE_ACCESSES_SUB;
1282:
1283:

Line 1638: FND_FILE.PUT_LINE(FND_FILE.LOG,'Minimum Id - Max id for leads for this worker :' || l_min_id ||' to '||l_max_id);

1634:
1635:
1636:
1637: if (l_debug) Then
1638: FND_FILE.PUT_LINE(FND_FILE.LOG,'Minimum Id - Max id for leads for this worker :' || l_min_id ||' to '||l_max_id);
1639: end if;
1640:
1641: -- Initialize counter
1642: l_count := l_min_id;

Line 1647: FND_FILE.PUT_LINE(FND_FILE.LOG,'Current loop count:' || l_count);

1643:
1644: while (l_count <= l_max_id)
1645: loop
1646: if (l_debug) Then
1647: FND_FILE.PUT_LINE(FND_FILE.LOG,'Current loop count:' || l_count);
1648: end if;
1649: -- update statements for sales leads here
1650: If Upper(X_STATUS_CODE) = 'ALL' THEN
1651: -- added decode for converted_to_opportunity fix for bug#3931530

Line 1696: FND_FILE.PUT_LINE(FND_FILE.LOG,'Update of denormed open flag in sales leads finished successfully');

1692: end loop;
1693: commit;
1694:
1695: if l_debug then
1696: FND_FILE.PUT_LINE(FND_FILE.LOG,'Update of denormed open flag in sales leads finished successfully');
1697: FND_FILE.PUT_LINE(FND_FILE.LOG,'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1698: end if;
1699: END IF; -- Only if l_lead_flag is Y
1700:

Line 1697: FND_FILE.PUT_LINE(FND_FILE.LOG,'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

1693: commit;
1694:
1695: if l_debug then
1696: FND_FILE.PUT_LINE(FND_FILE.LOG,'Update of denormed open flag in sales leads finished successfully');
1697: FND_FILE.PUT_LINE(FND_FILE.LOG,'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1698: end if;
1699: END IF; -- Only if l_lead_flag is Y
1700:
1701:

Line 1713: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error, cannot complete Concurrent Program') ;

1709: Write_log (l_module, 1, 'SQLCODE ' || to_char(SQLCODE) ||
1710: ' SQLERRM ' || substr(SQLERRM, 1, 100));
1711: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);
1712: IF l_status = TRUE THEN
1713: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error, cannot complete Concurrent Program') ;
1714: END IF ;
1715: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1716: ERRBUF := ERRBUF||sqlerrm;
1717: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1722: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error, cannot complete Concurrent Program') ;

1718: ROLLBACK;
1719: Write_Log(l_module, 1, 'Unexpected error in as_statuses_pkg.update_leads_accesses');
1720: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);
1721: IF l_status = TRUE THEN
1722: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error, cannot complete Concurrent Program') ;
1723: END IF ;
1724: WHEN others THEN
1725: ERRBUF := SQLERRM;
1726: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1733: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error, cannot complete Concurrent Program') ;

1729: Write_Log(l_module, 1, 'SQLCODE ' || to_char(SQLCODE) ||
1730: ' SQLERRM ' || substr(SQLERRM, 1, 100));
1731: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);
1732: IF l_status = TRUE THEN
1733: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error, cannot complete Concurrent Program') ;
1734: END IF ;
1735: end UPDATE_LEADS_ACCESSES;
1736:
1737:

Line 2087: FND_FILE.PUT_LINE(FND_FILE.LOG,'Minimum Id - Max id for opportunity for this worker :' || l_min_id ||' to '||l_max_id);

2083: l_max_id := p_end_id;
2084: G_BATCH_SIZE := NVL(p_batch_size,10000);
2085:
2086: IF (l_debug) THEN
2087: FND_FILE.PUT_LINE(FND_FILE.LOG,'Minimum Id - Max id for opportunity for this worker :' || l_min_id ||' to '||l_max_id);
2088: END IF;
2089:
2090:
2091: -- Initialize counter

Line 2097: FND_FILE.PUT_LINE(FND_FILE.LOG,'Current loop count:' || l_count);

2093:
2094: while (l_count <= l_max_id)
2095: loop
2096: if (l_debug) Then
2097: FND_FILE.PUT_LINE(FND_FILE.LOG,'Current loop count:' || l_count);
2098: end if;
2099: -- update statements for opptys here
2100: If Upper(X_STATUS_CODE) = 'ALL' THEN
2101: execute immediate 'UPDATE /*+ INDEX(ld AS_LEADS_ALL_MT2)*/ AS_LEADS_ALL ld

Line 2146: FND_FILE.PUT_LINE(FND_FILE.LOG,'Update of close reason in opptys finished successfully');

2142: end loop;
2143: commit;
2144:
2145: if l_debug then
2146: FND_FILE.PUT_LINE(FND_FILE.LOG,'Update of close reason in opptys finished successfully');
2147: FND_FILE.PUT_LINE(FND_FILE.LOG,'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
2148: end if;
2149: END IF; -- Only if l_opp_flag is Y
2150:

Line 2147: FND_FILE.PUT_LINE(FND_FILE.LOG,'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

2143: commit;
2144:
2145: if l_debug then
2146: FND_FILE.PUT_LINE(FND_FILE.LOG,'Update of close reason in opptys finished successfully');
2147: FND_FILE.PUT_LINE(FND_FILE.LOG,'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
2148: end if;
2149: END IF; -- Only if l_opp_flag is Y
2150:
2151:

Line 2163: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error, cannot complete Concurrent Program') ;

2159: Write_log (l_module, 1, 'SQLCODE ' || to_char(SQLCODE) ||
2160: ' SQLERRM ' || substr(SQLERRM, 1, 100));
2161: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);
2162: IF l_status = TRUE THEN
2163: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error, cannot complete Concurrent Program') ;
2164: END IF ;
2165: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2166: ERRBUF := ERRBUF||sqlerrm;
2167: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2172: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error, cannot complete Concurrent Program') ;

2168: ROLLBACK;
2169: Write_Log(l_module, 1, 'Unexpected error in as_statuses_pkg.update_oppty_accesses');
2170: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);
2171: IF l_status = TRUE THEN
2172: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error, cannot complete Concurrent Program') ;
2173: END IF ;
2174: WHEN others THEN
2175: ERRBUF := SQLERRM;
2176: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2183: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error, cannot complete Concurrent Program') ;

2179: Write_Log(l_module, 1, 'SQLCODE ' || to_char(SQLCODE) ||
2180: ' SQLERRM ' || substr(SQLERRM, 1, 100));
2181: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);
2182: IF l_status = TRUE THEN
2183: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error, cannot complete Concurrent Program') ;
2184: END IF ;
2185: end UPDATE_OPPTY_ACCESSES;
2186:
2187: end AS_STATUSES_PKG;