22:
23: EXCEPTION
24: WHEN OTHERS THEN
25: fnd_file.put_line(fnd_file.log, SQLERRM);
26: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
27: fnd_message.set_token('NAME','FND_TXK_TECH_INT_PKG.store_into_fnd_preference');
28: fnd_file.put_line(fnd_file.log, fnd_message.get);
29: RETURN(NULL);
30: END store_into_fnd_preference;
23: EXCEPTION
24: WHEN OTHERS THEN
25: fnd_file.put_line(fnd_file.log, SQLERRM);
26: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
27: fnd_message.set_token('NAME','FND_TXK_TECH_INT_PKG.store_into_fnd_preference');
28: fnd_file.put_line(fnd_file.log, fnd_message.get);
29: RETURN(NULL);
30: END store_into_fnd_preference;
31:
24: WHEN OTHERS THEN
25: fnd_file.put_line(fnd_file.log, SQLERRM);
26: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
27: fnd_message.set_token('NAME','FND_TXK_TECH_INT_PKG.store_into_fnd_preference');
28: fnd_file.put_line(fnd_file.log, fnd_message.get);
29: RETURN(NULL);
30: END store_into_fnd_preference;
31:
32: FUNCTION store_into_fnd_lob(p_args_table IN FND_TXK_BPEL_ARGS_TYPE )
69:
70: EXCEPTION
71: WHEN OTHERS THEN
72: fnd_file.put_line(fnd_file.log, SQLERRM);
73: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
74: fnd_message.set_token('NAME','FND_TXK_TECH_INT_PKG.store_into_fnd_lob');
75:
76: RETURN(NULL);
77: END store_into_fnd_lob;
70: EXCEPTION
71: WHEN OTHERS THEN
72: fnd_file.put_line(fnd_file.log, SQLERRM);
73: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
74: fnd_message.set_token('NAME','FND_TXK_TECH_INT_PKG.store_into_fnd_lob');
75:
76: RETURN(NULL);
77: END store_into_fnd_lob;
78:
129: ROLLBACK;
130: l_retcode := 2;
131: fnd_file.put_line(fnd_file.log, SQLERRM);
132:
133: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
134: fnd_message.set_token('NAME','FND_TXK_TECH_INT_PKG.remove_bpel_info_if_exists');
135: fnd_message.set_token('ERRNO', SQLCODE);
136: return l_retcode;
137: END remove_bpel_info_if_exists;
130: l_retcode := 2;
131: fnd_file.put_line(fnd_file.log, SQLERRM);
132:
133: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
134: fnd_message.set_token('NAME','FND_TXK_TECH_INT_PKG.remove_bpel_info_if_exists');
135: fnd_message.set_token('ERRNO', SQLCODE);
136: return l_retcode;
137: END remove_bpel_info_if_exists;
138:
131: fnd_file.put_line(fnd_file.log, SQLERRM);
132:
133: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
134: fnd_message.set_token('NAME','FND_TXK_TECH_INT_PKG.remove_bpel_info_if_exists');
135: fnd_message.set_token('ERRNO', SQLCODE);
136: return l_retcode;
137: END remove_bpel_info_if_exists;
138:
139:
173: ROLLBACK;
174: retcode := 2;
175: fnd_file.put_line(fnd_file.log, SQLERRM);
176:
177: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
178: fnd_message.set_token('NAME','FND_TXK_TECH_INT_PKG.store_bpel_info');
179: fnd_message.set_token('ERRNO', SQLCODE);
180: errbuf := fnd_message.get;
181: END store_bpel_info;
174: retcode := 2;
175: fnd_file.put_line(fnd_file.log, SQLERRM);
176:
177: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
178: fnd_message.set_token('NAME','FND_TXK_TECH_INT_PKG.store_bpel_info');
179: fnd_message.set_token('ERRNO', SQLCODE);
180: errbuf := fnd_message.get;
181: END store_bpel_info;
182:
175: fnd_file.put_line(fnd_file.log, SQLERRM);
176:
177: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
178: fnd_message.set_token('NAME','FND_TXK_TECH_INT_PKG.store_bpel_info');
179: fnd_message.set_token('ERRNO', SQLCODE);
180: errbuf := fnd_message.get;
181: END store_bpel_info;
182:
183: END FND_TXK_TECH_INT_PKG;
176:
177: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
178: fnd_message.set_token('NAME','FND_TXK_TECH_INT_PKG.store_bpel_info');
179: fnd_message.set_token('ERRNO', SQLCODE);
180: errbuf := fnd_message.get;
181: END store_bpel_info;
182:
183: END FND_TXK_TECH_INT_PKG;