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.CZ_ORAAPPS_INTEGRATE dependencies on FND_FILE

Line 1268: FND_FILE.PUT_LINE(FND_FILE.LOG,'SECTION_NAME = '||slSectionName);

1264: LOOP
1265: FETCH C_GETSET INTO slSectionName,slSettingID,slValue,slDescription;
1266: EXIT WHEN C_GETSET%NOTFOUND;
1267:
1268: FND_FILE.PUT_LINE(FND_FILE.LOG,'SECTION_NAME = '||slSectionName);
1269: FND_FILE.PUT_LINE(FND_FILE.LOG,'SETTING_ID = '||slSettingID);
1270: FND_FILE.PUT_LINE(FND_FILE.LOG,'VALUE = '||slValue);
1271: FND_FILE.PUT_LINE(FND_FILE.LOG,'DESCRIPTION = '||slDescription);
1272: FND_FILE.PUT_LINE(FND_FILE.LOG,'----------------------------');

Line 1269: FND_FILE.PUT_LINE(FND_FILE.LOG,'SETTING_ID = '||slSettingID);

1265: FETCH C_GETSET INTO slSectionName,slSettingID,slValue,slDescription;
1266: EXIT WHEN C_GETSET%NOTFOUND;
1267:
1268: FND_FILE.PUT_LINE(FND_FILE.LOG,'SECTION_NAME = '||slSectionName);
1269: FND_FILE.PUT_LINE(FND_FILE.LOG,'SETTING_ID = '||slSettingID);
1270: FND_FILE.PUT_LINE(FND_FILE.LOG,'VALUE = '||slValue);
1271: FND_FILE.PUT_LINE(FND_FILE.LOG,'DESCRIPTION = '||slDescription);
1272: FND_FILE.PUT_LINE(FND_FILE.LOG,'----------------------------');
1273:

Line 1270: FND_FILE.PUT_LINE(FND_FILE.LOG,'VALUE = '||slValue);

1266: EXIT WHEN C_GETSET%NOTFOUND;
1267:
1268: FND_FILE.PUT_LINE(FND_FILE.LOG,'SECTION_NAME = '||slSectionName);
1269: FND_FILE.PUT_LINE(FND_FILE.LOG,'SETTING_ID = '||slSettingID);
1270: FND_FILE.PUT_LINE(FND_FILE.LOG,'VALUE = '||slValue);
1271: FND_FILE.PUT_LINE(FND_FILE.LOG,'DESCRIPTION = '||slDescription);
1272: FND_FILE.PUT_LINE(FND_FILE.LOG,'----------------------------');
1273:
1274: END LOOP;

Line 1271: FND_FILE.PUT_LINE(FND_FILE.LOG,'DESCRIPTION = '||slDescription);

1267:
1268: FND_FILE.PUT_LINE(FND_FILE.LOG,'SECTION_NAME = '||slSectionName);
1269: FND_FILE.PUT_LINE(FND_FILE.LOG,'SETTING_ID = '||slSettingID);
1270: FND_FILE.PUT_LINE(FND_FILE.LOG,'VALUE = '||slValue);
1271: FND_FILE.PUT_LINE(FND_FILE.LOG,'DESCRIPTION = '||slDescription);
1272: FND_FILE.PUT_LINE(FND_FILE.LOG,'----------------------------');
1273:
1274: END LOOP;
1275: CLOSE C_GETSET;

Line 1272: FND_FILE.PUT_LINE(FND_FILE.LOG,'----------------------------');

1268: FND_FILE.PUT_LINE(FND_FILE.LOG,'SECTION_NAME = '||slSectionName);
1269: FND_FILE.PUT_LINE(FND_FILE.LOG,'SETTING_ID = '||slSettingID);
1270: FND_FILE.PUT_LINE(FND_FILE.LOG,'VALUE = '||slValue);
1271: FND_FILE.PUT_LINE(FND_FILE.LOG,'DESCRIPTION = '||slDescription);
1272: FND_FILE.PUT_LINE(FND_FILE.LOG,'----------------------------');
1273:
1274: END LOOP;
1275: CLOSE C_GETSET;
1276: EXCEPTION

Line 1280: --FND_FILE.PUT_LINE(FND_FILE.LOG,'GetSetting failed: '||SQLERRM);

1276: EXCEPTION
1277: WHEN OTHERS THEN
1278: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_GETSETTING_FAILED','ERRORTEXT',SQLERRM);
1279: --Now done from GET_TEXT
1280: --FND_FILE.PUT_LINE(FND_FILE.LOG,'GetSetting failed: '||SQLERRM);
1281: END;
1282: ------------------------------------------------------------------------------
1283: PROCEDURE AssignSetting(errbuf OUT NOCOPY VARCHAR2,
1284: retcode OUT NOCOPY NUMBER,

Line 1312: --FND_FILE.PUT_LINE(FND_FILE.LOG,'Setting not assigned: '||SQLERRM);

1308: EXCEPTION
1309: WHEN OTHERS THEN
1310: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_SETSETTING_FAILED','ERRORTEXT',SQLERRM);
1311: --Now done from GET_TEXT
1312: --FND_FILE.PUT_LINE(FND_FILE.LOG,'Setting not assigned: '||SQLERRM);
1313: END;
1314: ------------------------------------------------------------------------------
1315: PROCEDURE GetTableImport(errbuf OUT NOCOPY VARCHAR2,
1316: retcode OUT NOCOPY NUMBER,

Line 1334: FND_FILE.PUT_LINE(FND_FILE.LOG,'DST_TABLE = '||slDstTable);

1330: LOOP
1331: FETCH C_GETSET INTO slDstTable,slXfrGroup,slDisabled;
1332: EXIT WHEN C_GETSET%NOTFOUND;
1333:
1334: FND_FILE.PUT_LINE(FND_FILE.LOG,'DST_TABLE = '||slDstTable);
1335: FND_FILE.PUT_LINE(FND_FILE.LOG,'XFR_GROUP = '||slXfrGroup);
1336: FND_FILE.PUT_LINE(FND_FILE.LOG,'DISABLED_FLAG = '||slDisabled);
1337: FND_FILE.PUT_LINE(FND_FILE.LOG,'----------------------------');
1338:

Line 1335: FND_FILE.PUT_LINE(FND_FILE.LOG,'XFR_GROUP = '||slXfrGroup);

1331: FETCH C_GETSET INTO slDstTable,slXfrGroup,slDisabled;
1332: EXIT WHEN C_GETSET%NOTFOUND;
1333:
1334: FND_FILE.PUT_LINE(FND_FILE.LOG,'DST_TABLE = '||slDstTable);
1335: FND_FILE.PUT_LINE(FND_FILE.LOG,'XFR_GROUP = '||slXfrGroup);
1336: FND_FILE.PUT_LINE(FND_FILE.LOG,'DISABLED_FLAG = '||slDisabled);
1337: FND_FILE.PUT_LINE(FND_FILE.LOG,'----------------------------');
1338:
1339: END LOOP;

Line 1336: FND_FILE.PUT_LINE(FND_FILE.LOG,'DISABLED_FLAG = '||slDisabled);

1332: EXIT WHEN C_GETSET%NOTFOUND;
1333:
1334: FND_FILE.PUT_LINE(FND_FILE.LOG,'DST_TABLE = '||slDstTable);
1335: FND_FILE.PUT_LINE(FND_FILE.LOG,'XFR_GROUP = '||slXfrGroup);
1336: FND_FILE.PUT_LINE(FND_FILE.LOG,'DISABLED_FLAG = '||slDisabled);
1337: FND_FILE.PUT_LINE(FND_FILE.LOG,'----------------------------');
1338:
1339: END LOOP;
1340: CLOSE C_GETSET;

Line 1337: FND_FILE.PUT_LINE(FND_FILE.LOG,'----------------------------');

1333:
1334: FND_FILE.PUT_LINE(FND_FILE.LOG,'DST_TABLE = '||slDstTable);
1335: FND_FILE.PUT_LINE(FND_FILE.LOG,'XFR_GROUP = '||slXfrGroup);
1336: FND_FILE.PUT_LINE(FND_FILE.LOG,'DISABLED_FLAG = '||slDisabled);
1337: FND_FILE.PUT_LINE(FND_FILE.LOG,'----------------------------');
1338:
1339: END LOOP;
1340: CLOSE C_GETSET;
1341: EXCEPTION

Line 2251: FND_FILE.PUT_LINE(FND_FILE.LOG,'Inserting ' || v_server_id);

2247: BEGIN
2248: SELECT cz_servers_s.NEXTVAL
2249: INTO v_server_id
2250: FROM dual;
2251: FND_FILE.PUT_LINE(FND_FILE.LOG,'Inserting ' || v_server_id);
2252: INSERT INTO CZ_SERVERS (SERVER_LOCAL_ID,LOCAL_NAME, HOSTNAME, DB_LISTENER_PORT,
2253: INSTANCE_NAME, FNDNAM, GLOBAL_IDENTITY, NOTES,
2254: FNDNAM_LINK_NAME, IMPORT_ENABLED)
2255: VALUES (v_server_id,LOCAL_NAME, HOSTNAME, DB_LISTENER_PORT,

Line 2566: FND_FILE.PUT_LINE(FND_FILE.LOG,'Server Name='||lLocalName);

2562: lInstanceName,lServerDbVersion,lFndNam,lGlobalIdentity,
2563: lNotes,lFndNamLinkName,lImportEnabled;
2564: EXIT WHEN C_GETSERVERS%NOTFOUND;
2565:
2566: FND_FILE.PUT_LINE(FND_FILE.LOG,'Server Name='||lLocalName);
2567: FND_FILE.PUT_LINE(FND_FILE.LOG,'Host Name='||lHostName);
2568: FND_FILE.PUT_LINE(FND_FILE.LOG,'Port='||lDbListenerPort);
2569: FND_FILE.PUT_LINE(FND_FILE.LOG,'Instance Name='||lInstanceName);
2570: FND_FILE.PUT_LINE(FND_FILE.LOG,'Server Db Version='||lServerDbVersion);

Line 2567: FND_FILE.PUT_LINE(FND_FILE.LOG,'Host Name='||lHostName);

2563: lNotes,lFndNamLinkName,lImportEnabled;
2564: EXIT WHEN C_GETSERVERS%NOTFOUND;
2565:
2566: FND_FILE.PUT_LINE(FND_FILE.LOG,'Server Name='||lLocalName);
2567: FND_FILE.PUT_LINE(FND_FILE.LOG,'Host Name='||lHostName);
2568: FND_FILE.PUT_LINE(FND_FILE.LOG,'Port='||lDbListenerPort);
2569: FND_FILE.PUT_LINE(FND_FILE.LOG,'Instance Name='||lInstanceName);
2570: FND_FILE.PUT_LINE(FND_FILE.LOG,'Server Db Version='||lServerDbVersion);
2571: FND_FILE.PUT_LINE(FND_FILE.LOG,'FND Name='||lFndNam);

Line 2568: FND_FILE.PUT_LINE(FND_FILE.LOG,'Port='||lDbListenerPort);

2564: EXIT WHEN C_GETSERVERS%NOTFOUND;
2565:
2566: FND_FILE.PUT_LINE(FND_FILE.LOG,'Server Name='||lLocalName);
2567: FND_FILE.PUT_LINE(FND_FILE.LOG,'Host Name='||lHostName);
2568: FND_FILE.PUT_LINE(FND_FILE.LOG,'Port='||lDbListenerPort);
2569: FND_FILE.PUT_LINE(FND_FILE.LOG,'Instance Name='||lInstanceName);
2570: FND_FILE.PUT_LINE(FND_FILE.LOG,'Server Db Version='||lServerDbVersion);
2571: FND_FILE.PUT_LINE(FND_FILE.LOG,'FND Name='||lFndNam);
2572: FND_FILE.PUT_LINE(FND_FILE.LOG,'Global Name='||lGlobalIdentity);

Line 2569: FND_FILE.PUT_LINE(FND_FILE.LOG,'Instance Name='||lInstanceName);

2565:
2566: FND_FILE.PUT_LINE(FND_FILE.LOG,'Server Name='||lLocalName);
2567: FND_FILE.PUT_LINE(FND_FILE.LOG,'Host Name='||lHostName);
2568: FND_FILE.PUT_LINE(FND_FILE.LOG,'Port='||lDbListenerPort);
2569: FND_FILE.PUT_LINE(FND_FILE.LOG,'Instance Name='||lInstanceName);
2570: FND_FILE.PUT_LINE(FND_FILE.LOG,'Server Db Version='||lServerDbVersion);
2571: FND_FILE.PUT_LINE(FND_FILE.LOG,'FND Name='||lFndNam);
2572: FND_FILE.PUT_LINE(FND_FILE.LOG,'Global Name='||lGlobalIdentity);
2573: FND_FILE.PUT_LINE(FND_FILE.LOG,'Notes='||lNotes);

Line 2570: FND_FILE.PUT_LINE(FND_FILE.LOG,'Server Db Version='||lServerDbVersion);

2566: FND_FILE.PUT_LINE(FND_FILE.LOG,'Server Name='||lLocalName);
2567: FND_FILE.PUT_LINE(FND_FILE.LOG,'Host Name='||lHostName);
2568: FND_FILE.PUT_LINE(FND_FILE.LOG,'Port='||lDbListenerPort);
2569: FND_FILE.PUT_LINE(FND_FILE.LOG,'Instance Name='||lInstanceName);
2570: FND_FILE.PUT_LINE(FND_FILE.LOG,'Server Db Version='||lServerDbVersion);
2571: FND_FILE.PUT_LINE(FND_FILE.LOG,'FND Name='||lFndNam);
2572: FND_FILE.PUT_LINE(FND_FILE.LOG,'Global Name='||lGlobalIdentity);
2573: FND_FILE.PUT_LINE(FND_FILE.LOG,'Notes='||lNotes);
2574: FND_FILE.PUT_LINE(FND_FILE.LOG,'FND Link Name='||lFndNamLinkName);

Line 2571: FND_FILE.PUT_LINE(FND_FILE.LOG,'FND Name='||lFndNam);

2567: FND_FILE.PUT_LINE(FND_FILE.LOG,'Host Name='||lHostName);
2568: FND_FILE.PUT_LINE(FND_FILE.LOG,'Port='||lDbListenerPort);
2569: FND_FILE.PUT_LINE(FND_FILE.LOG,'Instance Name='||lInstanceName);
2570: FND_FILE.PUT_LINE(FND_FILE.LOG,'Server Db Version='||lServerDbVersion);
2571: FND_FILE.PUT_LINE(FND_FILE.LOG,'FND Name='||lFndNam);
2572: FND_FILE.PUT_LINE(FND_FILE.LOG,'Global Name='||lGlobalIdentity);
2573: FND_FILE.PUT_LINE(FND_FILE.LOG,'Notes='||lNotes);
2574: FND_FILE.PUT_LINE(FND_FILE.LOG,'FND Link Name='||lFndNamLinkName);
2575: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Import Enabled='||Decode(lImportEnabled, '1', 'Y', '0','N',lImportEnabled));

Line 2572: FND_FILE.PUT_LINE(FND_FILE.LOG,'Global Name='||lGlobalIdentity);

2568: FND_FILE.PUT_LINE(FND_FILE.LOG,'Port='||lDbListenerPort);
2569: FND_FILE.PUT_LINE(FND_FILE.LOG,'Instance Name='||lInstanceName);
2570: FND_FILE.PUT_LINE(FND_FILE.LOG,'Server Db Version='||lServerDbVersion);
2571: FND_FILE.PUT_LINE(FND_FILE.LOG,'FND Name='||lFndNam);
2572: FND_FILE.PUT_LINE(FND_FILE.LOG,'Global Name='||lGlobalIdentity);
2573: FND_FILE.PUT_LINE(FND_FILE.LOG,'Notes='||lNotes);
2574: FND_FILE.PUT_LINE(FND_FILE.LOG,'FND Link Name='||lFndNamLinkName);
2575: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Import Enabled='||Decode(lImportEnabled, '1', 'Y', '0','N',lImportEnabled));
2576: FND_FILE.PUT_LINE(FND_FILE.LOG,'Import Enabled=' || lImportEnabled);

Line 2573: FND_FILE.PUT_LINE(FND_FILE.LOG,'Notes='||lNotes);

2569: FND_FILE.PUT_LINE(FND_FILE.LOG,'Instance Name='||lInstanceName);
2570: FND_FILE.PUT_LINE(FND_FILE.LOG,'Server Db Version='||lServerDbVersion);
2571: FND_FILE.PUT_LINE(FND_FILE.LOG,'FND Name='||lFndNam);
2572: FND_FILE.PUT_LINE(FND_FILE.LOG,'Global Name='||lGlobalIdentity);
2573: FND_FILE.PUT_LINE(FND_FILE.LOG,'Notes='||lNotes);
2574: FND_FILE.PUT_LINE(FND_FILE.LOG,'FND Link Name='||lFndNamLinkName);
2575: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Import Enabled='||Decode(lImportEnabled, '1', 'Y', '0','N',lImportEnabled));
2576: FND_FILE.PUT_LINE(FND_FILE.LOG,'Import Enabled=' || lImportEnabled);
2577: FND_FILE.PUT_LINE(FND_FILE.LOG,'-------------------------------------');

Line 2574: FND_FILE.PUT_LINE(FND_FILE.LOG,'FND Link Name='||lFndNamLinkName);

2570: FND_FILE.PUT_LINE(FND_FILE.LOG,'Server Db Version='||lServerDbVersion);
2571: FND_FILE.PUT_LINE(FND_FILE.LOG,'FND Name='||lFndNam);
2572: FND_FILE.PUT_LINE(FND_FILE.LOG,'Global Name='||lGlobalIdentity);
2573: FND_FILE.PUT_LINE(FND_FILE.LOG,'Notes='||lNotes);
2574: FND_FILE.PUT_LINE(FND_FILE.LOG,'FND Link Name='||lFndNamLinkName);
2575: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Import Enabled='||Decode(lImportEnabled, '1', 'Y', '0','N',lImportEnabled));
2576: FND_FILE.PUT_LINE(FND_FILE.LOG,'Import Enabled=' || lImportEnabled);
2577: FND_FILE.PUT_LINE(FND_FILE.LOG,'-------------------------------------');
2578:

Line 2575: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Import Enabled='||Decode(lImportEnabled, '1', 'Y', '0','N',lImportEnabled));

2571: FND_FILE.PUT_LINE(FND_FILE.LOG,'FND Name='||lFndNam);
2572: FND_FILE.PUT_LINE(FND_FILE.LOG,'Global Name='||lGlobalIdentity);
2573: FND_FILE.PUT_LINE(FND_FILE.LOG,'Notes='||lNotes);
2574: FND_FILE.PUT_LINE(FND_FILE.LOG,'FND Link Name='||lFndNamLinkName);
2575: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Import Enabled='||Decode(lImportEnabled, '1', 'Y', '0','N',lImportEnabled));
2576: FND_FILE.PUT_LINE(FND_FILE.LOG,'Import Enabled=' || lImportEnabled);
2577: FND_FILE.PUT_LINE(FND_FILE.LOG,'-------------------------------------');
2578:
2579: END LOOP;

Line 2576: FND_FILE.PUT_LINE(FND_FILE.LOG,'Import Enabled=' || lImportEnabled);

2572: FND_FILE.PUT_LINE(FND_FILE.LOG,'Global Name='||lGlobalIdentity);
2573: FND_FILE.PUT_LINE(FND_FILE.LOG,'Notes='||lNotes);
2574: FND_FILE.PUT_LINE(FND_FILE.LOG,'FND Link Name='||lFndNamLinkName);
2575: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Import Enabled='||Decode(lImportEnabled, '1', 'Y', '0','N',lImportEnabled));
2576: FND_FILE.PUT_LINE(FND_FILE.LOG,'Import Enabled=' || lImportEnabled);
2577: FND_FILE.PUT_LINE(FND_FILE.LOG,'-------------------------------------');
2578:
2579: END LOOP;
2580: CLOSE C_GETSERVERS;

Line 2577: FND_FILE.PUT_LINE(FND_FILE.LOG,'-------------------------------------');

2573: FND_FILE.PUT_LINE(FND_FILE.LOG,'Notes='||lNotes);
2574: FND_FILE.PUT_LINE(FND_FILE.LOG,'FND Link Name='||lFndNamLinkName);
2575: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Import Enabled='||Decode(lImportEnabled, '1', 'Y', '0','N',lImportEnabled));
2576: FND_FILE.PUT_LINE(FND_FILE.LOG,'Import Enabled=' || lImportEnabled);
2577: FND_FILE.PUT_LINE(FND_FILE.LOG,'-------------------------------------');
2578:
2579: END LOOP;
2580: CLOSE C_GETSERVERS;
2581: EXCEPTION