86:
87: exception
88: when no_data_found then
89: e_code := E_OTHER;
90: fnd_message.set_name ('FND', 'CONC-Failed to get oracle name');
91: when others then
92: e_code := E_OTHER;
93: fnd_message.set_name ('FND', 'CP-Generic oracle error');
94: fnd_message.set_token ('ERROR', substr (sqlerrm, 1, 30), FALSE);
89: e_code := E_OTHER;
90: fnd_message.set_name ('FND', 'CONC-Failed to get oracle name');
91: when others then
92: e_code := E_OTHER;
93: fnd_message.set_name ('FND', 'CP-Generic oracle error');
94: fnd_message.set_token ('ERROR', substr (sqlerrm, 1, 30), FALSE);
95: fnd_message.set_token ('ROUTINE', 'get_oracle_account', FALSE);
96: end get_oracle_account;
97:
90: fnd_message.set_name ('FND', 'CONC-Failed to get oracle name');
91: when others then
92: e_code := E_OTHER;
93: fnd_message.set_name ('FND', 'CP-Generic oracle error');
94: fnd_message.set_token ('ERROR', substr (sqlerrm, 1, 30), FALSE);
95: fnd_message.set_token ('ROUTINE', 'get_oracle_account', FALSE);
96: end get_oracle_account;
97:
98:
91: when others then
92: e_code := E_OTHER;
93: fnd_message.set_name ('FND', 'CP-Generic oracle error');
94: fnd_message.set_token ('ERROR', substr (sqlerrm, 1, 30), FALSE);
95: fnd_message.set_token ('ROUTINE', 'get_oracle_account', FALSE);
96: end get_oracle_account;
97:
98:
99:
296:
297: exception
298: when others then
299: e_code := E_OTHER;
300: fnd_message.set_name ('FND', 'CP-Generic oracle error');
301: fnd_message.set_token ('ERROR', substr (sqlerrm, 1, 30), FALSE);
302: fnd_message.set_token ('ROUTINE', 'monitor_self', FALSE);
303: end monitor_self;
304:
297: exception
298: when others then
299: e_code := E_OTHER;
300: fnd_message.set_name ('FND', 'CP-Generic oracle error');
301: fnd_message.set_token ('ERROR', substr (sqlerrm, 1, 30), FALSE);
302: fnd_message.set_token ('ROUTINE', 'monitor_self', FALSE);
303: end monitor_self;
304:
305:
298: when others then
299: e_code := E_OTHER;
300: fnd_message.set_name ('FND', 'CP-Generic oracle error');
301: fnd_message.set_token ('ERROR', substr (sqlerrm, 1, 30), FALSE);
302: fnd_message.set_token ('ROUTINE', 'monitor_self', FALSE);
303: end monitor_self;
304:
305:
306: --