[Home] [Help]
130: retcode := 2;
131: fnd_message.set_name('FLM','FLM_PULLSEQ_INTF_ERR');
132: errbuf := fnd_message.get;
133: fnd_file.put_line(fnd_file.log, errbuf);
134: l_conc_status := fnd_concurrent.set_completion_status('ERROR', errbuf);
135: RETURN;
136: ELSIF l_ret_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
138: END IF;
146: retcode := 2;
147: fnd_message.set_name('FLM','FLM_CARDS_INTF_ERR');
148: errbuf := fnd_message.get;
149: fnd_file.put_line(fnd_file.log, errbuf);
150: l_conc_status := fnd_concurrent.set_completion_status('ERROR', errbuf);
151: RETURN;
152: ELSIF l_ret_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
154: END IF;
179: retcode := 0;
180: fnd_message.set_name('FLM','FLM_INTERFACE_SUCCESS');
181: errbuf := fnd_message.get;
182: fnd_file.put_line(fnd_file.log, errbuf);
183: l_conc_status := fnd_concurrent.set_completion_status('NORMAL', errbuf);
184: ELSE
185: retcode := 1;
186: fnd_message.set_name('FLM','FLM_INTERFACE_ROW_ERR');
187: errbuf := fnd_message.get;
185: retcode := 1;
186: fnd_message.set_name('FLM','FLM_INTERFACE_ROW_ERR');
187: errbuf := fnd_message.get;
188: fnd_file.put_line(fnd_file.log, errbuf);
189: l_conc_status := fnd_concurrent.set_completion_status('WARNING', errbuf);
190: END IF;
191:
192: EXCEPTION
193: WHEN OTHERS THEN
195: fnd_message.set_name('FLM','FLM_INTERFACE_ERR');
196: errbuf := fnd_message.get;
197: fnd_file.put_line(fnd_file.log, errbuf);
198: fnd_file.put_line(fnd_file.log, SQLERRM);
199: l_conc_status := fnd_concurrent.set_completion_status('ERROR', errbuf);
200:
201: END load_kanban;
202:
203: END FLM_KANBAN_MASSLOAD;