55: --
56: -- initialise
57: --
58: l_query_id := fnd_profile.value('CSF_DEFAULT_AUTO_COMMIT_QUERY');
59: fnd_message.set_name('CSF', 'CSF_AUTO_COMMIT_STARTED');
60: print(fnd_message.get);
61: --
62: x_errbuf := g_errbuf_success;
63: x_retcode := g_retcode_success;
56: -- initialise
57: --
58: l_query_id := fnd_profile.value('CSF_DEFAULT_AUTO_COMMIT_QUERY');
59: fnd_message.set_name('CSF', 'CSF_AUTO_COMMIT_STARTED');
60: print(fnd_message.get);
61: --
62: x_errbuf := g_errbuf_success;
63: x_retcode := g_retcode_success;
64: fnd_msg_pub.Initialize;
89: fnd_msg_pub.get(counter,FND_API.G_FALSE,l_msg_data,l1);
90: print(l_msg_data);
91: end loop;
92: end if;
93: fnd_message.set_name('CSF', 'CSF_AUTO_COMMIT_DONE');
94: print(fnd_message.get);
95: --
96: exception
97: when fnd_api.g_exc_unexpected_error then
90: print(l_msg_data);
91: end loop;
92: end if;
93: fnd_message.set_name('CSF', 'CSF_AUTO_COMMIT_DONE');
94: print(fnd_message.get);
95: --
96: exception
97: when fnd_api.g_exc_unexpected_error then
98: x_errbuf := g_errbuf_warning;
114: fnd_msg_pub.get(counter,FND_API.G_FALSE,l_msg_data,l1);
115: print(l_msg_data);
116: end loop;
117: end if;
118: fnd_message.set_name('CSF', 'CSF_AUTO_COMMIT_EXCEPTION');
119: fnd_message.set_token('P_MESSAGE', sqlerrm);
120: print(fnd_message.get);
121: fnd_message.set_name('CSF', 'CSF_AUTO_COMMIT_ABORT');
122: print(fnd_message.get);
115: print(l_msg_data);
116: end loop;
117: end if;
118: fnd_message.set_name('CSF', 'CSF_AUTO_COMMIT_EXCEPTION');
119: fnd_message.set_token('P_MESSAGE', sqlerrm);
120: print(fnd_message.get);
121: fnd_message.set_name('CSF', 'CSF_AUTO_COMMIT_ABORT');
122: print(fnd_message.get);
123: end update_planned_task_status;
116: end loop;
117: end if;
118: fnd_message.set_name('CSF', 'CSF_AUTO_COMMIT_EXCEPTION');
119: fnd_message.set_token('P_MESSAGE', sqlerrm);
120: print(fnd_message.get);
121: fnd_message.set_name('CSF', 'CSF_AUTO_COMMIT_ABORT');
122: print(fnd_message.get);
123: end update_planned_task_status;
124:
117: end if;
118: fnd_message.set_name('CSF', 'CSF_AUTO_COMMIT_EXCEPTION');
119: fnd_message.set_token('P_MESSAGE', sqlerrm);
120: print(fnd_message.get);
121: fnd_message.set_name('CSF', 'CSF_AUTO_COMMIT_ABORT');
122: print(fnd_message.get);
123: end update_planned_task_status;
124:
125: --============================================--
118: fnd_message.set_name('CSF', 'CSF_AUTO_COMMIT_EXCEPTION');
119: fnd_message.set_token('P_MESSAGE', sqlerrm);
120: print(fnd_message.get);
121: fnd_message.set_name('CSF', 'CSF_AUTO_COMMIT_ABORT');
122: print(fnd_message.get);
123: end update_planned_task_status;
124:
125: --============================================--
126: -- private procedure and function definitions --