60: print(fnd_message.get);
61: --
62: x_errbuf := g_errbuf_success;
63: x_retcode := g_retcode_success;
64: fnd_msg_pub.Initialize;
65: --
66: If p_query_id is not null then
67: l_query_id := p_query_id;
68: end if;
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');
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');