DBA Data[Home] [Help]

APPS.JTF_RS_ACTIVE_REC_CONC_PUB dependencies on FND_MESSAGE

Line 135: fnd_message.set_name('JTF', 'JTF_RS_ACTIVE_TO_INACT_COUNT');

131: ;
132:
133: l_den_update_count := l_den_update_count + SQL%ROWCOUNT ;
134:
135: fnd_message.set_name('JTF', 'JTF_RS_ACTIVE_TO_INACT_COUNT');
136: fnd_message.set_token('P_TABLE_NAME', 'JTF_RS_GROUPS_DENORM');
137: fnd_message.set_token('P_ROWCOUNT', TO_CHAR(SQL%ROWCOUNT));
138: fnd_file.put_line(fnd_file.log, fnd_message.get);
139: fnd_file.new_line(fnd_file.log,1);

Line 136: fnd_message.set_token('P_TABLE_NAME', 'JTF_RS_GROUPS_DENORM');

132:
133: l_den_update_count := l_den_update_count + SQL%ROWCOUNT ;
134:
135: fnd_message.set_name('JTF', 'JTF_RS_ACTIVE_TO_INACT_COUNT');
136: fnd_message.set_token('P_TABLE_NAME', 'JTF_RS_GROUPS_DENORM');
137: fnd_message.set_token('P_ROWCOUNT', TO_CHAR(SQL%ROWCOUNT));
138: fnd_file.put_line(fnd_file.log, fnd_message.get);
139: fnd_file.new_line(fnd_file.log,1);
140:

Line 137: fnd_message.set_token('P_ROWCOUNT', TO_CHAR(SQL%ROWCOUNT));

133: l_den_update_count := l_den_update_count + SQL%ROWCOUNT ;
134:
135: fnd_message.set_name('JTF', 'JTF_RS_ACTIVE_TO_INACT_COUNT');
136: fnd_message.set_token('P_TABLE_NAME', 'JTF_RS_GROUPS_DENORM');
137: fnd_message.set_token('P_ROWCOUNT', TO_CHAR(SQL%ROWCOUNT));
138: fnd_file.put_line(fnd_file.log, fnd_message.get);
139: fnd_file.new_line(fnd_file.log,1);
140:
141: COMMIT;

Line 138: fnd_file.put_line(fnd_file.log, fnd_message.get);

134:
135: fnd_message.set_name('JTF', 'JTF_RS_ACTIVE_TO_INACT_COUNT');
136: fnd_message.set_token('P_TABLE_NAME', 'JTF_RS_GROUPS_DENORM');
137: fnd_message.set_token('P_ROWCOUNT', TO_CHAR(SQL%ROWCOUNT));
138: fnd_file.put_line(fnd_file.log, fnd_message.get);
139: fnd_file.new_line(fnd_file.log,1);
140:
141: COMMIT;
142:

Line 296: fnd_message.set_name('JTF', 'JTF_RS_INACT_TO_ACTIVE_COUNT');

292: l_den_update_count := l_den_update_count + SQL%ROWCOUNT ;
293:
294: END IF;
295:
296: fnd_message.set_name('JTF', 'JTF_RS_INACT_TO_ACTIVE_COUNT');
297: fnd_message.set_token('P_TABLE_NAME', 'JTF_RS_GROUPS_DENORM');
298: fnd_message.set_token('P_ROWCOUNT', TO_CHAR(l_update_count));
299: fnd_file.put_line(fnd_file.LOG, fnd_message.get);
300: fnd_file.new_line(fnd_file.LOG,1);

Line 297: fnd_message.set_token('P_TABLE_NAME', 'JTF_RS_GROUPS_DENORM');

293:
294: END IF;
295:
296: fnd_message.set_name('JTF', 'JTF_RS_INACT_TO_ACTIVE_COUNT');
297: fnd_message.set_token('P_TABLE_NAME', 'JTF_RS_GROUPS_DENORM');
298: fnd_message.set_token('P_ROWCOUNT', TO_CHAR(l_update_count));
299: fnd_file.put_line(fnd_file.LOG, fnd_message.get);
300: fnd_file.new_line(fnd_file.LOG,1);
301:

Line 298: fnd_message.set_token('P_ROWCOUNT', TO_CHAR(l_update_count));

294: END IF;
295:
296: fnd_message.set_name('JTF', 'JTF_RS_INACT_TO_ACTIVE_COUNT');
297: fnd_message.set_token('P_TABLE_NAME', 'JTF_RS_GROUPS_DENORM');
298: fnd_message.set_token('P_ROWCOUNT', TO_CHAR(l_update_count));
299: fnd_file.put_line(fnd_file.LOG, fnd_message.get);
300: fnd_file.new_line(fnd_file.LOG,1);
301:
302: COMMIT;

Line 299: fnd_file.put_line(fnd_file.LOG, fnd_message.get);

295:
296: fnd_message.set_name('JTF', 'JTF_RS_INACT_TO_ACTIVE_COUNT');
297: fnd_message.set_token('P_TABLE_NAME', 'JTF_RS_GROUPS_DENORM');
298: fnd_message.set_token('P_ROWCOUNT', TO_CHAR(l_update_count));
299: fnd_file.put_line(fnd_file.LOG, fnd_message.get);
300: fnd_file.new_line(fnd_file.LOG,1);
301:
302: COMMIT;
303:

Line 329: fnd_message.set_name('JTF', 'JTF_RS_ACTIVE_TO_INACT_COUNT');

325:
326: l_update_count := l_update_count + SQL%ROWCOUNT ;
327: l_role_update_count := l_role_update_count + SQL%ROWCOUNT ;
328:
329: fnd_message.set_name('JTF', 'JTF_RS_ACTIVE_TO_INACT_COUNT');
330: fnd_message.set_token('P_TABLE_NAME', 'JTF_RS_ROLE_RELATIONS');
331: fnd_message.set_token('P_ROWCOUNT', to_char(l_update_count));
332: fnd_file.put_line(fnd_file.log, fnd_message.get);
333: fnd_file.new_line(fnd_file.log,1);

Line 330: fnd_message.set_token('P_TABLE_NAME', 'JTF_RS_ROLE_RELATIONS');

326: l_update_count := l_update_count + SQL%ROWCOUNT ;
327: l_role_update_count := l_role_update_count + SQL%ROWCOUNT ;
328:
329: fnd_message.set_name('JTF', 'JTF_RS_ACTIVE_TO_INACT_COUNT');
330: fnd_message.set_token('P_TABLE_NAME', 'JTF_RS_ROLE_RELATIONS');
331: fnd_message.set_token('P_ROWCOUNT', to_char(l_update_count));
332: fnd_file.put_line(fnd_file.log, fnd_message.get);
333: fnd_file.new_line(fnd_file.log,1);
334:

Line 331: fnd_message.set_token('P_ROWCOUNT', to_char(l_update_count));

327: l_role_update_count := l_role_update_count + SQL%ROWCOUNT ;
328:
329: fnd_message.set_name('JTF', 'JTF_RS_ACTIVE_TO_INACT_COUNT');
330: fnd_message.set_token('P_TABLE_NAME', 'JTF_RS_ROLE_RELATIONS');
331: fnd_message.set_token('P_ROWCOUNT', to_char(l_update_count));
332: fnd_file.put_line(fnd_file.log, fnd_message.get);
333: fnd_file.new_line(fnd_file.log,1);
334:
335: COMMIT;

Line 332: fnd_file.put_line(fnd_file.log, fnd_message.get);

328:
329: fnd_message.set_name('JTF', 'JTF_RS_ACTIVE_TO_INACT_COUNT');
330: fnd_message.set_token('P_TABLE_NAME', 'JTF_RS_ROLE_RELATIONS');
331: fnd_message.set_token('P_ROWCOUNT', to_char(l_update_count));
332: fnd_file.put_line(fnd_file.log, fnd_message.get);
333: fnd_file.new_line(fnd_file.log,1);
334:
335: COMMIT;
336:

Line 347: fnd_message.set_name('JTF', 'JTF_RS_INACT_TO_ACTIVE_COUNT');

343: ;
344:
345: l_role_update_count := l_role_update_count + SQL%ROWCOUNT ;
346:
347: fnd_message.set_name('JTF', 'JTF_RS_INACT_TO_ACTIVE_COUNT');
348: fnd_message.set_token('P_TABLE_NAME', 'JTF_RS_ROLE_RELATIONS');
349: fnd_message.set_token('P_ROWCOUNT', to_char(SQL%ROWCOUNT));
350: fnd_file.put_line(fnd_file.log, fnd_message.get);
351: fnd_file.new_line(fnd_file.log,1);

Line 348: fnd_message.set_token('P_TABLE_NAME', 'JTF_RS_ROLE_RELATIONS');

344:
345: l_role_update_count := l_role_update_count + SQL%ROWCOUNT ;
346:
347: fnd_message.set_name('JTF', 'JTF_RS_INACT_TO_ACTIVE_COUNT');
348: fnd_message.set_token('P_TABLE_NAME', 'JTF_RS_ROLE_RELATIONS');
349: fnd_message.set_token('P_ROWCOUNT', to_char(SQL%ROWCOUNT));
350: fnd_file.put_line(fnd_file.log, fnd_message.get);
351: fnd_file.new_line(fnd_file.log,1);
352:

Line 349: fnd_message.set_token('P_ROWCOUNT', to_char(SQL%ROWCOUNT));

345: l_role_update_count := l_role_update_count + SQL%ROWCOUNT ;
346:
347: fnd_message.set_name('JTF', 'JTF_RS_INACT_TO_ACTIVE_COUNT');
348: fnd_message.set_token('P_TABLE_NAME', 'JTF_RS_ROLE_RELATIONS');
349: fnd_message.set_token('P_ROWCOUNT', to_char(SQL%ROWCOUNT));
350: fnd_file.put_line(fnd_file.log, fnd_message.get);
351: fnd_file.new_line(fnd_file.log,1);
352:
353: COMMIT;

Line 350: fnd_file.put_line(fnd_file.log, fnd_message.get);

346:
347: fnd_message.set_name('JTF', 'JTF_RS_INACT_TO_ACTIVE_COUNT');
348: fnd_message.set_token('P_TABLE_NAME', 'JTF_RS_ROLE_RELATIONS');
349: fnd_message.set_token('P_ROWCOUNT', to_char(SQL%ROWCOUNT));
350: fnd_file.put_line(fnd_file.log, fnd_message.get);
351: fnd_file.new_line(fnd_file.log,1);
352:
353: COMMIT;
354: