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
267: end if;
268:
269: savepoint pre_insert;
270:
271: fnd_message.set_name('PA','PA_TKN_PRJ');
272: l_segment_name := fnd_message.get;
273: l_return_code := create_locator_segment(
274: 19,
275: l_segment_name,
268:
269: savepoint pre_insert;
270:
271: fnd_message.set_name('PA','PA_TKN_PRJ');
272: l_segment_name := fnd_message.get;
273: l_return_code := create_locator_segment(
274: 19,
275: l_segment_name,
276: 'SEGMENT19',
283: rollback to savepoint pre_insert;
284: return(FALSE);
285: end if;
286:
287: fnd_message.set_name('PA','PA_TKN_TSK');
288: l_segment_name := fnd_message.get;
289: l_return_code := create_locator_segment(
290: 20,
291: l_segment_name,
284: return(FALSE);
285: end if;
286:
287: fnd_message.set_name('PA','PA_TKN_TSK');
288: l_segment_name := fnd_message.get;
289: l_return_code := create_locator_segment(
290: 20,
291: l_segment_name,
292: 'SEGMENT20',