DBA Data[Home] [Help]

APPS.IBW_MERGE_PVT dependencies on FND_MESSAGE

Line 35: fnd_message.set_name('IBW','IBW_PARTY_MERGE');

31:
32: BEGIN
33:
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);

Line 36: fnd_message.set_token('DESC',' IBW_PAGE_VIEWS merge started ' );

32: BEGIN
33:
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 ;

Line 37: l_message_text := fnd_message.get;

33:
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:

Line 61: fnd_message.set_name('IBW','IBW_PARTY_MERGE');

57: if p_from_fk_id <> p_to_fk_id Then
58: IF p_parent_entity_name = 'HZ_PARTIES' Then
59:
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);

Line 62: fnd_message.set_token('DESC',' Updating ibw_page_views : Start' );

58: IF p_parent_entity_name = 'HZ_PARTIES' Then
59:
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 ;

Line 63: l_message_text := fnd_message.get;

59:
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:

Line 89: fnd_message.set_name('IBW','IBW_PARTY_MERGE');

85: l_count := sql%rowcount;
86:
87:
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);

Line 90: fnd_message.set_token('DESC',' IBW_PAGE_VIEWS Rows updated :'||to_char(l_count) );

86:
87:
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 ;

Line 91: l_message_text := fnd_message.get;

87:
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:

Line 103: fnd_message.set_name('IBW','IBW_PARTY_MERGE');

99:
100: Exception
101: When RESOURCE_BUSY Then
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 ;

Line 104: fnd_message.set_token('DESC',' IBW_MERGE_PVT.MERGE_PAGES; Could not obtain lock on table IBW_PAGE_VIEWS' );

100: Exception
101: When RESOURCE_BUSY Then
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;

Line 105: l_message_text := fnd_message.get;

101: When RESOURCE_BUSY Then
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;

Line 114: fnd_message.set_name('IBW','IBW_PARTY_MERGE');

110:
111: When Others Then
112:
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 ;

Line 115: fnd_message.set_token('DESC','IBW_MERGE_PVT.MERGE_PAGES : '||sqlerrm );

111: When Others Then
112:
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:

Line 116: l_message_text := fnd_message.get;

112:
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;

Line 155: fnd_message.set_name('IBW','IBW_PARTY_MERGE');

151:
152: BEGIN
153:
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);

Line 156: fnd_message.set_token('DESC',' IBW_SITE_VISITS merge started ' );

152: BEGIN
153:
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 ;

Line 157: l_message_text := fnd_message.get;

153:
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:

Line 180: fnd_message.set_name('IBW','IBW_PARTY_MERGE');

176: if p_from_fk_id <> p_to_fk_id Then
177: IF p_parent_entity_name = 'HZ_PARTIES' Then
178:
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);

Line 181: fnd_message.set_token('DESC',' Updating ibw_site_visits : Start' );

177: IF p_parent_entity_name = 'HZ_PARTIES' Then
178:
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 ;

Line 182: l_message_text := fnd_message.get;

178:
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:

Line 205: fnd_message.set_name('IBW','IBW_PARTY_MERGE');

201:
202: l_count := sql%rowcount;
203:
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);

Line 206: fnd_message.set_token('DESC',' IBW_SITE_VISITS Rows updated :'||to_char(l_count) );

202: l_count := sql%rowcount;
203:
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 ;

Line 207: l_message_text := fnd_message.get;

203:
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:

Line 220: fnd_message.set_name('IBW','IBW_PARTY_MERGE');

216:
217: Exception
218: When RESOURCE_BUSY Then
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 ;

Line 221: fnd_message.set_token('DESC',' IBW_MERGE_PVT.MERGE_SITES; Could not obtain lock on table IBW_SITE_VISITS' );

217: Exception
218: When RESOURCE_BUSY Then
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:

Line 222: l_message_text := fnd_message.get;

218: When RESOURCE_BUSY Then
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;

Line 232: fnd_message.set_name('IBW','IBW_PARTY_MERGE');

228:
229: When Others Then
230:
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 ;

Line 233: fnd_message.set_token('DESC','IBW_MERGE_PVT.MERGE_SITES : '||sqlerrm );

229: When Others Then
230:
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;

Line 234: l_message_text := fnd_message.get;

230:
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:

Line 240: fnd_message.set_name('IBW','IBW_PARTY_MERGE');

236: end ;
237: x_return_status := FND_API.G_RET_STS_ERROR;
238:
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);

Line 241: fnd_message.set_token('DESC',' IBW_MERGE_PVT. MERGE_SITESsql error ' );

237: x_return_status := FND_API.G_RET_STS_ERROR;
238:
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 ;

Line 242: l_message_text := fnd_message.get;

238:
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;