68: end if;
69: --
70: csf_tasks_pub.commit_schedule(
71: p_api_version => 1.0
72: , p_init_msg_list => fnd_api.g_false
73: , p_commit => fnd_api.g_true
74: , x_return_status => l_return_status
75: , x_msg_count => l_msg_count
76: , x_msg_data => l_msg_data
69: --
70: csf_tasks_pub.commit_schedule(
71: p_api_version => 1.0
72: , p_init_msg_list => fnd_api.g_false
73: , p_commit => fnd_api.g_true
74: , x_return_status => l_return_status
75: , x_msg_count => l_msg_count
76: , x_msg_data => l_msg_data
77: , p_query_id => l_query_id
76: , x_msg_data => l_msg_data
77: , p_query_id => l_query_id
78: );
79:
80: if l_return_status <> fnd_api.g_ret_sts_success
81: then
82: raise fnd_api.g_exc_unexpected_error;
83: end if;
84: --
78: );
79:
80: if l_return_status <> fnd_api.g_ret_sts_success
81: then
82: raise fnd_api.g_exc_unexpected_error;
83: end if;
84: --
85: --
86: if l_msg_count > 0 then
85: --
86: if l_msg_count > 0 then
87: FOR counter IN REVERSE 1..l_msg_count
88: LOOP
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');
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;
99: x_retcode := g_retcode_warning;
100: if l_msg_count > 0 then
101: FOR counter IN REVERSE 1..l_msg_count
99: x_retcode := g_retcode_warning;
100: if l_msg_count > 0 then
101: FOR counter IN REVERSE 1..l_msg_count
102: LOOP
103: fnd_msg_pub.get(counter,FND_API.G_FALSE,l_msg_data,l1);
104: print(l_msg_data);
105: end loop;
106: end if;
107: when others then
110:
111: if l_msg_count > 0 then
112: FOR counter IN REVERSE 1..l_msg_count
113: LOOP
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');