97: fnd_transaction.debug_info('fnd_trn_pipe.get_manager', 'No manager defined', NULL);
98:
99: fnd_transaction.post_tm_event(1, application, program, -1);
100:
101: fnd_message.set_name('FND', 'CONC-TM-No manager defined');
102: fnd_message.set_token('APPLICATION', application);
103: fnd_message.set_token('PROGRAM', program);
104: fnd_message.set_token('RESP_ID', resp_id);
105: fnd_message.set_token('RESP_APPL_ID', resp_appl_id);
98:
99: fnd_transaction.post_tm_event(1, application, program, -1);
100:
101: fnd_message.set_name('FND', 'CONC-TM-No manager defined');
102: fnd_message.set_token('APPLICATION', application);
103: fnd_message.set_token('PROGRAM', program);
104: fnd_message.set_token('RESP_ID', resp_id);
105: fnd_message.set_token('RESP_APPL_ID', resp_appl_id);
106: raise error;
99: fnd_transaction.post_tm_event(1, application, program, -1);
100:
101: fnd_message.set_name('FND', 'CONC-TM-No manager defined');
102: fnd_message.set_token('APPLICATION', application);
103: fnd_message.set_token('PROGRAM', program);
104: fnd_message.set_token('RESP_ID', resp_id);
105: fnd_message.set_token('RESP_APPL_ID', resp_appl_id);
106: raise error;
107: end if;
100:
101: fnd_message.set_name('FND', 'CONC-TM-No manager defined');
102: fnd_message.set_token('APPLICATION', application);
103: fnd_message.set_token('PROGRAM', program);
104: fnd_message.set_token('RESP_ID', resp_id);
105: fnd_message.set_token('RESP_APPL_ID', resp_appl_id);
106: raise error;
107: end if;
108:
101: fnd_message.set_name('FND', 'CONC-TM-No manager defined');
102: fnd_message.set_token('APPLICATION', application);
103: fnd_message.set_token('PROGRAM', program);
104: fnd_message.set_token('RESP_ID', resp_id);
105: fnd_message.set_token('RESP_APPL_ID', resp_appl_id);
106: raise error;
107: end if;
108:
109: if (debug_flag) then
127:
128: -- Raise exception on error other than timeout.
129: if (status <> 1) then
130: fnd_transaction.debug_info('fnd_trn_pipe.get_manager', 'Token read error:', to_char(status));
131: fnd_message.set_name('FND', 'CONC-TM-Token read error');
132: raise error;
133: end if;
134:
135: /* mark soft busy event (2) */
174: when others then
175: if tm%isopen then
176: close tm;
177: end if;
178: fnd_message.set_name ('FND', 'SQL-Generic error');
179: fnd_message.set_token ('ERRNO', sqlcode, FALSE);
180: fnd_message.set_token ('REASON', sqlerrm, FALSE);
181: fnd_message.set_token ('ROUTINE', 'FND_TRN_PIPE.GET_MANAGER', FALSE);
182: fnd_transaction.debug_info('fnd_trn_pipe.get_manager', 'Caught exception', sqlerrm);
175: if tm%isopen then
176: close tm;
177: end if;
178: fnd_message.set_name ('FND', 'SQL-Generic error');
179: fnd_message.set_token ('ERRNO', sqlcode, FALSE);
180: fnd_message.set_token ('REASON', sqlerrm, FALSE);
181: fnd_message.set_token ('ROUTINE', 'FND_TRN_PIPE.GET_MANAGER', FALSE);
182: fnd_transaction.debug_info('fnd_trn_pipe.get_manager', 'Caught exception', sqlerrm);
183:
176: close tm;
177: end if;
178: fnd_message.set_name ('FND', 'SQL-Generic error');
179: fnd_message.set_token ('ERRNO', sqlcode, FALSE);
180: fnd_message.set_token ('REASON', sqlerrm, FALSE);
181: fnd_message.set_token ('ROUTINE', 'FND_TRN_PIPE.GET_MANAGER', FALSE);
182: fnd_transaction.debug_info('fnd_trn_pipe.get_manager', 'Caught exception', sqlerrm);
183:
184: return fnd_transaction.E_OTHER;
177: end if;
178: fnd_message.set_name ('FND', 'SQL-Generic error');
179: fnd_message.set_token ('ERRNO', sqlcode, FALSE);
180: fnd_message.set_token ('REASON', sqlerrm, FALSE);
181: fnd_message.set_token ('ROUTINE', 'FND_TRN_PIPE.GET_MANAGER', FALSE);
182: fnd_transaction.debug_info('fnd_trn_pipe.get_manager', 'Caught exception', sqlerrm);
183:
184: return fnd_transaction.E_OTHER;
185:
505: when argslen_err then
506: fnd_transaction.debug_info('fnd_trn_pipe.send_message', 'Total size of args too long', to_char(argtotal));
507: return fnd_transaction.E_ARGSIZE;
508: when others then
509: fnd_message.set_name ('FND', 'SQL-Generic error');
510: fnd_message.set_token ('ERRNO', sqlcode, FALSE);
511: fnd_message.set_token ('REASON', sqlerrm, FALSE);
512: fnd_message.set_token (
513: 'ROUTINE', 'FND_TRN_PIPE.SEND_MESSAGE', FALSE);
506: fnd_transaction.debug_info('fnd_trn_pipe.send_message', 'Total size of args too long', to_char(argtotal));
507: return fnd_transaction.E_ARGSIZE;
508: when others then
509: fnd_message.set_name ('FND', 'SQL-Generic error');
510: fnd_message.set_token ('ERRNO', sqlcode, FALSE);
511: fnd_message.set_token ('REASON', sqlerrm, FALSE);
512: fnd_message.set_token (
513: 'ROUTINE', 'FND_TRN_PIPE.SEND_MESSAGE', FALSE);
514: fnd_transaction.debug_info('fnd_trn_pipe.send_message', 'Caught exception', sqlerrm);
507: return fnd_transaction.E_ARGSIZE;
508: when others then
509: fnd_message.set_name ('FND', 'SQL-Generic error');
510: fnd_message.set_token ('ERRNO', sqlcode, FALSE);
511: fnd_message.set_token ('REASON', sqlerrm, FALSE);
512: fnd_message.set_token (
513: 'ROUTINE', 'FND_TRN_PIPE.SEND_MESSAGE', FALSE);
514: fnd_transaction.debug_info('fnd_trn_pipe.send_message', 'Caught exception', sqlerrm);
515: return fnd_transaction.E_OTHER;
508: when others then
509: fnd_message.set_name ('FND', 'SQL-Generic error');
510: fnd_message.set_token ('ERRNO', sqlcode, FALSE);
511: fnd_message.set_token ('REASON', sqlerrm, FALSE);
512: fnd_message.set_token (
513: 'ROUTINE', 'FND_TRN_PIPE.SEND_MESSAGE', FALSE);
514: fnd_transaction.debug_info('fnd_trn_pipe.send_message', 'Caught exception', sqlerrm);
515: return fnd_transaction.E_OTHER;
516: