68: if ( l_seg_value_set_id <> l_value_set_id ) then
69: --
70: -- Segment already in use
71: --
72: fnd_message.set_name('PJM','INST-SEGMENT IN USE');
73: fnd_message.set_token('SEGMENT',p_column_name);
74: return(FALSE);
75: end if;
76:
69: --
70: -- Segment already in use
71: --
72: fnd_message.set_name('PJM','INST-SEGMENT IN USE');
73: fnd_message.set_token('SEGMENT',p_column_name);
74: return(FALSE);
75: end if;
76:
77: exception
284: end if;
285:
286: savepoint pre_insert;
287:
288: fnd_message.set_name('PA','PA_TKN_PRJ');
289: l_segment_name := fnd_message.get;
290: l_return_code := create_locator_segment(
291: 19,
292: l_segment_name,
285:
286: savepoint pre_insert;
287:
288: fnd_message.set_name('PA','PA_TKN_PRJ');
289: l_segment_name := fnd_message.get;
290: l_return_code := create_locator_segment(
291: 19,
292: l_segment_name,
293: 'SEGMENT19',
300: rollback to savepoint pre_insert;
301: return(FALSE);
302: end if;
303:
304: fnd_message.set_name('PA','PA_TKN_TSK');
305: l_segment_name := fnd_message.get;
306: l_return_code := create_locator_segment(
307: 20,
308: l_segment_name,
301: return(FALSE);
302: end if;
303:
304: fnd_message.set_name('PA','PA_TKN_TSK');
305: l_segment_name := fnd_message.get;
306: l_return_code := create_locator_segment(
307: 20,
308: l_segment_name,
309: 'SEGMENT20',