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

Line 38: fnd_file.put_line(FND_FILE.LOG,l_message_text);

34: begin
35: fnd_message.set_name('IBW','IBW_PARTY_MERGE');
36: fnd_message.set_token('DESC',' IBW_PAGE_VIEWS merge started ' );
37: l_message_text := fnd_message.get;
38: fnd_file.put_line(FND_FILE.LOG,l_message_text);
39: fnd_file.put_line(FND_FILE.OUTPUT,l_message_text);
40: end ;
41:
42: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 39: fnd_file.put_line(FND_FILE.OUTPUT,l_message_text);

35: fnd_message.set_name('IBW','IBW_PARTY_MERGE');
36: fnd_message.set_token('DESC',' IBW_PAGE_VIEWS merge started ' );
37: l_message_text := fnd_message.get;
38: fnd_file.put_line(FND_FILE.LOG,l_message_text);
39: fnd_file.put_line(FND_FILE.OUTPUT,l_message_text);
40: end ;
41:
42: x_return_status := FND_API.G_RET_STS_SUCCESS;
43:

Line 64: fnd_file.put_line(FND_FILE.LOG,l_message_text);

60: begin
61: fnd_message.set_name('IBW','IBW_PARTY_MERGE');
62: fnd_message.set_token('DESC',' Updating ibw_page_views : Start' );
63: l_message_text := fnd_message.get;
64: fnd_file.put_line(FND_FILE.LOG,l_message_text);
65: fnd_file.put_line(FND_FILE.OUTPUT,l_message_text);
66: end ;
67:
68: /* The below query would be executed when PARTY_ID of type 'ORGANIZATION' or 'PERSON' or 'PARTY RELATIONSHIP' is merged

Line 65: fnd_file.put_line(FND_FILE.OUTPUT,l_message_text);

61: fnd_message.set_name('IBW','IBW_PARTY_MERGE');
62: fnd_message.set_token('DESC',' Updating ibw_page_views : Start' );
63: l_message_text := fnd_message.get;
64: fnd_file.put_line(FND_FILE.LOG,l_message_text);
65: fnd_file.put_line(FND_FILE.OUTPUT,l_message_text);
66: end ;
67:
68: /* The below query would be executed when PARTY_ID of type 'ORGANIZATION' or 'PERSON' or 'PARTY RELATIONSHIP' is merged
69: in HZ_PARTIES Table.

Line 92: fnd_file.put_line(FND_FILE.LOG,l_message_text);

88: begin
89: fnd_message.set_name('IBW','IBW_PARTY_MERGE');
90: fnd_message.set_token('DESC',' IBW_PAGE_VIEWS Rows updated :'||to_char(l_count) );
91: l_message_text := fnd_message.get;
92: fnd_file.put_line(FND_FILE.LOG,l_message_text);
93: fnd_file.put_line(FND_FILE.OUTPUT,l_message_text);
94: end ;
95:
96: return;

Line 93: fnd_file.put_line(FND_FILE.OUTPUT,l_message_text);

89: fnd_message.set_name('IBW','IBW_PARTY_MERGE');
90: fnd_message.set_token('DESC',' IBW_PAGE_VIEWS Rows updated :'||to_char(l_count) );
91: l_message_text := fnd_message.get;
92: fnd_file.put_line(FND_FILE.LOG,l_message_text);
93: fnd_file.put_line(FND_FILE.OUTPUT,l_message_text);
94: end ;
95:
96: return;
97: END IF;

Line 106: fnd_file.put_line(FND_FILE.LOG,l_message_text);

102: begin
103: fnd_message.set_name('IBW','IBW_PARTY_MERGE');
104: fnd_message.set_token('DESC',' IBW_MERGE_PVT.MERGE_PAGES; Could not obtain lock on table IBW_PAGE_VIEWS' );
105: l_message_text := fnd_message.get;
106: fnd_file.put_line(FND_FILE.LOG,l_message_text);
107: end ;
108: x_return_status := FND_API.G_RET_STS_ERROR;
109: raise;
110:

Line 117: fnd_file.put_line(FND_FILE.LOG,l_message_text);

113: begin
114: fnd_message.set_name('IBW','IBW_PARTY_MERGE');
115: fnd_message.set_token('DESC','IBW_MERGE_PVT.MERGE_PAGES : '||sqlerrm );
116: l_message_text := fnd_message.get;
117: fnd_file.put_line(FND_FILE.LOG,l_message_text);
118: end ;
119:
120: x_return_status := FND_API.G_RET_STS_ERROR;
121: raise;

Line 158: fnd_file.put_line(FND_FILE.LOG,l_message_text);

154: begin
155: fnd_message.set_name('IBW','IBW_PARTY_MERGE');
156: fnd_message.set_token('DESC',' IBW_SITE_VISITS merge started ' );
157: l_message_text := fnd_message.get;
158: fnd_file.put_line(FND_FILE.LOG,l_message_text);
159: fnd_file.put_line(FND_FILE.OUTPUT,l_message_text);
160: end ;
161:
162: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 159: fnd_file.put_line(FND_FILE.OUTPUT,l_message_text);

155: fnd_message.set_name('IBW','IBW_PARTY_MERGE');
156: fnd_message.set_token('DESC',' IBW_SITE_VISITS merge started ' );
157: l_message_text := fnd_message.get;
158: fnd_file.put_line(FND_FILE.LOG,l_message_text);
159: fnd_file.put_line(FND_FILE.OUTPUT,l_message_text);
160: end ;
161:
162: x_return_status := FND_API.G_RET_STS_SUCCESS;
163:

Line 183: fnd_file.put_line(FND_FILE.LOG,l_message_text);

179: begin
180: fnd_message.set_name('IBW','IBW_PARTY_MERGE');
181: fnd_message.set_token('DESC',' Updating ibw_site_visits : Start' );
182: l_message_text := fnd_message.get;
183: fnd_file.put_line(FND_FILE.LOG,l_message_text);
184: fnd_file.put_line(FND_FILE.OUTPUT,l_message_text);
185: end ;
186:
187: /* The below query would be executed when PARTY_ID of type 'ORGANIZATION' or 'PERSON' is merged

Line 184: fnd_file.put_line(FND_FILE.OUTPUT,l_message_text);

180: fnd_message.set_name('IBW','IBW_PARTY_MERGE');
181: fnd_message.set_token('DESC',' Updating ibw_site_visits : Start' );
182: l_message_text := fnd_message.get;
183: fnd_file.put_line(FND_FILE.LOG,l_message_text);
184: fnd_file.put_line(FND_FILE.OUTPUT,l_message_text);
185: end ;
186:
187: /* The below query would be executed when PARTY_ID of type 'ORGANIZATION' or 'PERSON' is merged
188: in HZ_PARTIES Table.

Line 208: fnd_file.put_line(FND_FILE.LOG,l_message_text);

204: begin
205: fnd_message.set_name('IBW','IBW_PARTY_MERGE');
206: fnd_message.set_token('DESC',' IBW_SITE_VISITS Rows updated :'||to_char(l_count) );
207: l_message_text := fnd_message.get;
208: fnd_file.put_line(FND_FILE.LOG,l_message_text);
209: fnd_file.put_line(FND_FILE.OUTPUT,l_message_text);
210: end ;
211:
212: return;

Line 209: fnd_file.put_line(FND_FILE.OUTPUT,l_message_text);

205: fnd_message.set_name('IBW','IBW_PARTY_MERGE');
206: fnd_message.set_token('DESC',' IBW_SITE_VISITS Rows updated :'||to_char(l_count) );
207: l_message_text := fnd_message.get;
208: fnd_file.put_line(FND_FILE.LOG,l_message_text);
209: fnd_file.put_line(FND_FILE.OUTPUT,l_message_text);
210: end ;
211:
212: return;
213: END IF;

Line 223: fnd_file.put_line(FND_FILE.LOG,l_message_text);

219: begin
220: fnd_message.set_name('IBW','IBW_PARTY_MERGE');
221: fnd_message.set_token('DESC',' IBW_MERGE_PVT.MERGE_SITES; Could not obtain lock on table IBW_SITE_VISITS' );
222: l_message_text := fnd_message.get;
223: fnd_file.put_line(FND_FILE.LOG,l_message_text);
224: end ;
225:
226: x_return_status := FND_API.G_RET_STS_ERROR;
227: raise;

Line 235: fnd_file.put_line(FND_FILE.LOG,l_message_text);

231: begin
232: fnd_message.set_name('IBW','IBW_PARTY_MERGE');
233: fnd_message.set_token('DESC','IBW_MERGE_PVT.MERGE_SITES : '||sqlerrm );
234: l_message_text := fnd_message.get;
235: fnd_file.put_line(FND_FILE.LOG,l_message_text);
236: end ;
237: x_return_status := FND_API.G_RET_STS_ERROR;
238:
239: begin

Line 243: fnd_file.put_line(FND_FILE.LOG,l_message_text);

239: begin
240: fnd_message.set_name('IBW','IBW_PARTY_MERGE');
241: fnd_message.set_token('DESC',' IBW_MERGE_PVT. MERGE_SITESsql error ' );
242: l_message_text := fnd_message.get;
243: fnd_file.put_line(FND_FILE.LOG,l_message_text);
244: fnd_file.put_line(FND_FILE.OUTPUT,l_message_text);
245: end ;
246: raise;
247:

Line 244: fnd_file.put_line(FND_FILE.OUTPUT,l_message_text);

240: fnd_message.set_name('IBW','IBW_PARTY_MERGE');
241: fnd_message.set_token('DESC',' IBW_MERGE_PVT. MERGE_SITESsql error ' );
242: l_message_text := fnd_message.get;
243: fnd_file.put_line(FND_FILE.LOG,l_message_text);
244: fnd_file.put_line(FND_FILE.OUTPUT,l_message_text);
245: end ;
246: raise;
247:
248: END MERGE_SITES;