106: fnd_transaction.debug_info('fnd_trn_queue.get_manager', 'No manager available', NULL);
107:
108: fnd_transaction.post_tm_event(1, application, program, -1);
109:
110: fnd_message.set_name('FND', 'CONC-TM-No manager defined');
111: fnd_message.set_token('APPLICATION', application);
112: fnd_message.set_token('PROGRAM', program);
113: fnd_message.set_token('RESP_ID', resp_id);
114: fnd_message.set_token('RESP_APPL_ID', resp_appl_id);
107:
108: fnd_transaction.post_tm_event(1, application, program, -1);
109:
110: fnd_message.set_name('FND', 'CONC-TM-No manager defined');
111: fnd_message.set_token('APPLICATION', application);
112: fnd_message.set_token('PROGRAM', program);
113: fnd_message.set_token('RESP_ID', resp_id);
114: fnd_message.set_token('RESP_APPL_ID', resp_appl_id);
115: close tm;
108: fnd_transaction.post_tm_event(1, application, program, -1);
109:
110: fnd_message.set_name('FND', 'CONC-TM-No manager defined');
111: fnd_message.set_token('APPLICATION', application);
112: fnd_message.set_token('PROGRAM', program);
113: fnd_message.set_token('RESP_ID', resp_id);
114: fnd_message.set_token('RESP_APPL_ID', resp_appl_id);
115: close tm;
116: return fnd_transaction.E_OTHER;
109:
110: fnd_message.set_name('FND', 'CONC-TM-No manager defined');
111: fnd_message.set_token('APPLICATION', application);
112: fnd_message.set_token('PROGRAM', program);
113: fnd_message.set_token('RESP_ID', resp_id);
114: fnd_message.set_token('RESP_APPL_ID', resp_appl_id);
115: close tm;
116: return fnd_transaction.E_OTHER;
117: end if;
110: fnd_message.set_name('FND', 'CONC-TM-No manager defined');
111: fnd_message.set_token('APPLICATION', application);
112: fnd_message.set_token('PROGRAM', program);
113: fnd_message.set_token('RESP_ID', resp_id);
114: fnd_message.set_token('RESP_APPL_ID', resp_appl_id);
115: close tm;
116: return fnd_transaction.E_OTHER;
117: end if;
118:
129: when others then
130: if tm%isopen then
131: close tm;
132: end if;
133: fnd_message.set_name ('FND', 'SQL-Generic error');
134: fnd_message.set_token ('ERRNO', sqlcode, FALSE);
135: fnd_message.set_token ('REASON', sqlerrm, FALSE);
136: fnd_message.set_token ('ROUTINE', 'FND_TRANSACTION_QUEUE.GET_MANAGER', FALSE);
137: fnd_transaction.debug_info('fnd_trn_queue.get_manager', 'Caught exception', sqlerrm);
130: if tm%isopen then
131: close tm;
132: end if;
133: fnd_message.set_name ('FND', 'SQL-Generic error');
134: fnd_message.set_token ('ERRNO', sqlcode, FALSE);
135: fnd_message.set_token ('REASON', sqlerrm, FALSE);
136: fnd_message.set_token ('ROUTINE', 'FND_TRANSACTION_QUEUE.GET_MANAGER', FALSE);
137: fnd_transaction.debug_info('fnd_trn_queue.get_manager', 'Caught exception', sqlerrm);
138:
131: close tm;
132: end if;
133: fnd_message.set_name ('FND', 'SQL-Generic error');
134: fnd_message.set_token ('ERRNO', sqlcode, FALSE);
135: fnd_message.set_token ('REASON', sqlerrm, FALSE);
136: fnd_message.set_token ('ROUTINE', 'FND_TRANSACTION_QUEUE.GET_MANAGER', FALSE);
137: fnd_transaction.debug_info('fnd_trn_queue.get_manager', 'Caught exception', sqlerrm);
138:
139: return fnd_transaction.E_OTHER;
132: end if;
133: fnd_message.set_name ('FND', 'SQL-Generic error');
134: fnd_message.set_token ('ERRNO', sqlcode, FALSE);
135: fnd_message.set_token ('REASON', sqlerrm, FALSE);
136: fnd_message.set_token ('ROUTINE', 'FND_TRANSACTION_QUEUE.GET_MANAGER', FALSE);
137: fnd_transaction.debug_info('fnd_trn_queue.get_manager', 'Caught exception', sqlerrm);
138:
139: return fnd_transaction.E_OTHER;
140:
403: return fnd_transaction.E_SUCCESS;
404:
405: exception
406: when OTHERS then
407: fnd_message.set_name ('FND', 'SQL-Generic error');
408: fnd_message.set_token ('ERRNO', sqlcode, FALSE);
409: fnd_message.set_token ('REASON', sqlerrm, FALSE);
410: fnd_message.set_token ('ROUTINE', 'FND_TRANSACTION_QUEUE.SEND_MESSAGE', FALSE);
411: fnd_transaction.debug_info('fnd_trn_queue.send_message', 'Caught exception', sqlerrm);
404:
405: exception
406: when OTHERS then
407: fnd_message.set_name ('FND', 'SQL-Generic error');
408: fnd_message.set_token ('ERRNO', sqlcode, FALSE);
409: fnd_message.set_token ('REASON', sqlerrm, FALSE);
410: fnd_message.set_token ('ROUTINE', 'FND_TRANSACTION_QUEUE.SEND_MESSAGE', FALSE);
411: fnd_transaction.debug_info('fnd_trn_queue.send_message', 'Caught exception', sqlerrm);
412: return fnd_transaction.E_OTHER;
405: exception
406: when OTHERS then
407: fnd_message.set_name ('FND', 'SQL-Generic error');
408: fnd_message.set_token ('ERRNO', sqlcode, FALSE);
409: fnd_message.set_token ('REASON', sqlerrm, FALSE);
410: fnd_message.set_token ('ROUTINE', 'FND_TRANSACTION_QUEUE.SEND_MESSAGE', FALSE);
411: fnd_transaction.debug_info('fnd_trn_queue.send_message', 'Caught exception', sqlerrm);
412: return fnd_transaction.E_OTHER;
413:
406: when OTHERS then
407: fnd_message.set_name ('FND', 'SQL-Generic error');
408: fnd_message.set_token ('ERRNO', sqlcode, FALSE);
409: fnd_message.set_token ('REASON', sqlerrm, FALSE);
410: fnd_message.set_token ('ROUTINE', 'FND_TRANSACTION_QUEUE.SEND_MESSAGE', FALSE);
411: fnd_transaction.debug_info('fnd_trn_queue.send_message', 'Caught exception', sqlerrm);
412: return fnd_transaction.E_OTHER;
413:
414: end send_message;