178: -- {Start Of Comments}
179: --
180: -- Description:
181: -- This procedure is called when a constraint has been violated (i.e.
182: -- The exception hr_api.check_integrity_violated,
183: -- hr_api.parent_integrity_violated, hr_api.child_integrity_violated or
184: -- hr_api.unique_integrity_violated has been raised).
185: -- The exceptions can only be raised as follows:
186: -- 1) A check constraint can only be violated during an INSERT or UPDATE
179: --
180: -- Description:
181: -- This procedure is called when a constraint has been violated (i.e.
182: -- The exception hr_api.check_integrity_violated,
183: -- hr_api.parent_integrity_violated, hr_api.child_integrity_violated or
184: -- hr_api.unique_integrity_violated has been raised).
185: -- The exceptions can only be raised as follows:
186: -- 1) A check constraint can only be violated during an INSERT or UPDATE
187: -- dml operation.
180: -- Description:
181: -- This procedure is called when a constraint has been violated (i.e.
182: -- The exception hr_api.check_integrity_violated,
183: -- hr_api.parent_integrity_violated, hr_api.child_integrity_violated or
184: -- hr_api.unique_integrity_violated has been raised).
185: -- The exceptions can only be raised as follows:
186: -- 1) A check constraint can only be violated during an INSERT or UPDATE
187: -- dml operation.
188: -- 2) A parent integrity constraint can only be violated during an
192: -- 4) A unique integrity constraint can only be violated during INSERT or
193: -- UPDATE dml operation.
194: --
195: -- Prerequisites:
196: -- 1) Either hr_api.check_integrity_violated,
197: -- hr_api.parent_integrity_violated, hr_api.child_integrity_violated or
198: -- hr_api.unique_integrity_violated has been raised with the subsequent
199: -- stripping of the constraint name from the generated error message
200: -- text.
193: -- UPDATE dml operation.
194: --
195: -- Prerequisites:
196: -- 1) Either hr_api.check_integrity_violated,
197: -- hr_api.parent_integrity_violated, hr_api.child_integrity_violated or
198: -- hr_api.unique_integrity_violated has been raised with the subsequent
199: -- stripping of the constraint name from the generated error message
200: -- text.
201: -- 2) Standalone validation test which corresponds with a constraint error.
194: --
195: -- Prerequisites:
196: -- 1) Either hr_api.check_integrity_violated,
197: -- hr_api.parent_integrity_violated, hr_api.child_integrity_violated or
198: -- hr_api.unique_integrity_violated has been raised with the subsequent
199: -- stripping of the constraint name from the generated error message
200: -- text.
201: -- 2) Standalone validation test which corresponds with a constraint error.
202: --
298: --
299: -- Post Failure:
300: -- The Lck process can fail for three reasons:
301: -- 1) When attempting to lock the row the row could already be locked by
302: -- another user. This will raise the HR_Api.Object_Locked exception.
303: -- 2) The row which is required to be locked doesn't exist in the HR Schema.
304: -- This error is trapped and reported using the message name
305: -- 'HR_7220_INVALID_PRIMARY_KEY'.
306: -- 3) The row although existing in the HR Schema has a different object
309: -- 'HR_7155_OBJECT_INVALID'.
310: --
311: -- Developer Implementation Notes:
312: -- For each primary key and the object version number arguments add a
313: -- call to hr_api.mandatory_arg_error procedure to ensure that these
314: -- argument values are not null.
315: --
316: -- Access Status:
317: -- Internal Development Use Only.
506: -- ----------------------------------------------------------------------------
507:
508: --
509: Procedure keyflex_comb(
510: p_dml_mode in varchar2 default hr_api.g_varchar2,
511: p_appl_short_name in varchar2 default hr_api.g_varchar2,
512: p_flex_code in varchar2 default hr_api.g_varchar2,
513: p_segment1 in varchar2 default hr_api.g_varchar2,
514: p_segment2 in varchar2 default hr_api.g_varchar2,
507:
508: --
509: Procedure keyflex_comb(
510: p_dml_mode in varchar2 default hr_api.g_varchar2,
511: p_appl_short_name in varchar2 default hr_api.g_varchar2,
512: p_flex_code in varchar2 default hr_api.g_varchar2,
513: p_segment1 in varchar2 default hr_api.g_varchar2,
514: p_segment2 in varchar2 default hr_api.g_varchar2,
515: p_segment3 in varchar2 default hr_api.g_varchar2,
508: --
509: Procedure keyflex_comb(
510: p_dml_mode in varchar2 default hr_api.g_varchar2,
511: p_appl_short_name in varchar2 default hr_api.g_varchar2,
512: p_flex_code in varchar2 default hr_api.g_varchar2,
513: p_segment1 in varchar2 default hr_api.g_varchar2,
514: p_segment2 in varchar2 default hr_api.g_varchar2,
515: p_segment3 in varchar2 default hr_api.g_varchar2,
516: p_segment4 in varchar2 default hr_api.g_varchar2,
509: Procedure keyflex_comb(
510: p_dml_mode in varchar2 default hr_api.g_varchar2,
511: p_appl_short_name in varchar2 default hr_api.g_varchar2,
512: p_flex_code in varchar2 default hr_api.g_varchar2,
513: p_segment1 in varchar2 default hr_api.g_varchar2,
514: p_segment2 in varchar2 default hr_api.g_varchar2,
515: p_segment3 in varchar2 default hr_api.g_varchar2,
516: p_segment4 in varchar2 default hr_api.g_varchar2,
517: p_segment5 in varchar2 default hr_api.g_varchar2,
510: p_dml_mode in varchar2 default hr_api.g_varchar2,
511: p_appl_short_name in varchar2 default hr_api.g_varchar2,
512: p_flex_code in varchar2 default hr_api.g_varchar2,
513: p_segment1 in varchar2 default hr_api.g_varchar2,
514: p_segment2 in varchar2 default hr_api.g_varchar2,
515: p_segment3 in varchar2 default hr_api.g_varchar2,
516: p_segment4 in varchar2 default hr_api.g_varchar2,
517: p_segment5 in varchar2 default hr_api.g_varchar2,
518: p_segment6 in varchar2 default hr_api.g_varchar2,
511: p_appl_short_name in varchar2 default hr_api.g_varchar2,
512: p_flex_code in varchar2 default hr_api.g_varchar2,
513: p_segment1 in varchar2 default hr_api.g_varchar2,
514: p_segment2 in varchar2 default hr_api.g_varchar2,
515: p_segment3 in varchar2 default hr_api.g_varchar2,
516: p_segment4 in varchar2 default hr_api.g_varchar2,
517: p_segment5 in varchar2 default hr_api.g_varchar2,
518: p_segment6 in varchar2 default hr_api.g_varchar2,
519: p_segment7 in varchar2 default hr_api.g_varchar2,
512: p_flex_code in varchar2 default hr_api.g_varchar2,
513: p_segment1 in varchar2 default hr_api.g_varchar2,
514: p_segment2 in varchar2 default hr_api.g_varchar2,
515: p_segment3 in varchar2 default hr_api.g_varchar2,
516: p_segment4 in varchar2 default hr_api.g_varchar2,
517: p_segment5 in varchar2 default hr_api.g_varchar2,
518: p_segment6 in varchar2 default hr_api.g_varchar2,
519: p_segment7 in varchar2 default hr_api.g_varchar2,
520: p_segment8 in varchar2 default hr_api.g_varchar2,
513: p_segment1 in varchar2 default hr_api.g_varchar2,
514: p_segment2 in varchar2 default hr_api.g_varchar2,
515: p_segment3 in varchar2 default hr_api.g_varchar2,
516: p_segment4 in varchar2 default hr_api.g_varchar2,
517: p_segment5 in varchar2 default hr_api.g_varchar2,
518: p_segment6 in varchar2 default hr_api.g_varchar2,
519: p_segment7 in varchar2 default hr_api.g_varchar2,
520: p_segment8 in varchar2 default hr_api.g_varchar2,
521: p_segment9 in varchar2 default hr_api.g_varchar2,
514: p_segment2 in varchar2 default hr_api.g_varchar2,
515: p_segment3 in varchar2 default hr_api.g_varchar2,
516: p_segment4 in varchar2 default hr_api.g_varchar2,
517: p_segment5 in varchar2 default hr_api.g_varchar2,
518: p_segment6 in varchar2 default hr_api.g_varchar2,
519: p_segment7 in varchar2 default hr_api.g_varchar2,
520: p_segment8 in varchar2 default hr_api.g_varchar2,
521: p_segment9 in varchar2 default hr_api.g_varchar2,
522: p_segment10 in varchar2 default hr_api.g_varchar2,
515: p_segment3 in varchar2 default hr_api.g_varchar2,
516: p_segment4 in varchar2 default hr_api.g_varchar2,
517: p_segment5 in varchar2 default hr_api.g_varchar2,
518: p_segment6 in varchar2 default hr_api.g_varchar2,
519: p_segment7 in varchar2 default hr_api.g_varchar2,
520: p_segment8 in varchar2 default hr_api.g_varchar2,
521: p_segment9 in varchar2 default hr_api.g_varchar2,
522: p_segment10 in varchar2 default hr_api.g_varchar2,
523: p_segment11 in varchar2 default hr_api.g_varchar2,
516: p_segment4 in varchar2 default hr_api.g_varchar2,
517: p_segment5 in varchar2 default hr_api.g_varchar2,
518: p_segment6 in varchar2 default hr_api.g_varchar2,
519: p_segment7 in varchar2 default hr_api.g_varchar2,
520: p_segment8 in varchar2 default hr_api.g_varchar2,
521: p_segment9 in varchar2 default hr_api.g_varchar2,
522: p_segment10 in varchar2 default hr_api.g_varchar2,
523: p_segment11 in varchar2 default hr_api.g_varchar2,
524: p_segment12 in varchar2 default hr_api.g_varchar2,
517: p_segment5 in varchar2 default hr_api.g_varchar2,
518: p_segment6 in varchar2 default hr_api.g_varchar2,
519: p_segment7 in varchar2 default hr_api.g_varchar2,
520: p_segment8 in varchar2 default hr_api.g_varchar2,
521: p_segment9 in varchar2 default hr_api.g_varchar2,
522: p_segment10 in varchar2 default hr_api.g_varchar2,
523: p_segment11 in varchar2 default hr_api.g_varchar2,
524: p_segment12 in varchar2 default hr_api.g_varchar2,
525: p_segment13 in varchar2 default hr_api.g_varchar2,
518: p_segment6 in varchar2 default hr_api.g_varchar2,
519: p_segment7 in varchar2 default hr_api.g_varchar2,
520: p_segment8 in varchar2 default hr_api.g_varchar2,
521: p_segment9 in varchar2 default hr_api.g_varchar2,
522: p_segment10 in varchar2 default hr_api.g_varchar2,
523: p_segment11 in varchar2 default hr_api.g_varchar2,
524: p_segment12 in varchar2 default hr_api.g_varchar2,
525: p_segment13 in varchar2 default hr_api.g_varchar2,
526: p_segment14 in varchar2 default hr_api.g_varchar2,
519: p_segment7 in varchar2 default hr_api.g_varchar2,
520: p_segment8 in varchar2 default hr_api.g_varchar2,
521: p_segment9 in varchar2 default hr_api.g_varchar2,
522: p_segment10 in varchar2 default hr_api.g_varchar2,
523: p_segment11 in varchar2 default hr_api.g_varchar2,
524: p_segment12 in varchar2 default hr_api.g_varchar2,
525: p_segment13 in varchar2 default hr_api.g_varchar2,
526: p_segment14 in varchar2 default hr_api.g_varchar2,
527: p_segment15 in varchar2 default hr_api.g_varchar2,
520: p_segment8 in varchar2 default hr_api.g_varchar2,
521: p_segment9 in varchar2 default hr_api.g_varchar2,
522: p_segment10 in varchar2 default hr_api.g_varchar2,
523: p_segment11 in varchar2 default hr_api.g_varchar2,
524: p_segment12 in varchar2 default hr_api.g_varchar2,
525: p_segment13 in varchar2 default hr_api.g_varchar2,
526: p_segment14 in varchar2 default hr_api.g_varchar2,
527: p_segment15 in varchar2 default hr_api.g_varchar2,
528: p_segment16 in varchar2 default hr_api.g_varchar2,
521: p_segment9 in varchar2 default hr_api.g_varchar2,
522: p_segment10 in varchar2 default hr_api.g_varchar2,
523: p_segment11 in varchar2 default hr_api.g_varchar2,
524: p_segment12 in varchar2 default hr_api.g_varchar2,
525: p_segment13 in varchar2 default hr_api.g_varchar2,
526: p_segment14 in varchar2 default hr_api.g_varchar2,
527: p_segment15 in varchar2 default hr_api.g_varchar2,
528: p_segment16 in varchar2 default hr_api.g_varchar2,
529: p_segment17 in varchar2 default hr_api.g_varchar2,
522: p_segment10 in varchar2 default hr_api.g_varchar2,
523: p_segment11 in varchar2 default hr_api.g_varchar2,
524: p_segment12 in varchar2 default hr_api.g_varchar2,
525: p_segment13 in varchar2 default hr_api.g_varchar2,
526: p_segment14 in varchar2 default hr_api.g_varchar2,
527: p_segment15 in varchar2 default hr_api.g_varchar2,
528: p_segment16 in varchar2 default hr_api.g_varchar2,
529: p_segment17 in varchar2 default hr_api.g_varchar2,
530: p_segment18 in varchar2 default hr_api.g_varchar2,
523: p_segment11 in varchar2 default hr_api.g_varchar2,
524: p_segment12 in varchar2 default hr_api.g_varchar2,
525: p_segment13 in varchar2 default hr_api.g_varchar2,
526: p_segment14 in varchar2 default hr_api.g_varchar2,
527: p_segment15 in varchar2 default hr_api.g_varchar2,
528: p_segment16 in varchar2 default hr_api.g_varchar2,
529: p_segment17 in varchar2 default hr_api.g_varchar2,
530: p_segment18 in varchar2 default hr_api.g_varchar2,
531: p_segment19 in varchar2 default hr_api.g_varchar2,
524: p_segment12 in varchar2 default hr_api.g_varchar2,
525: p_segment13 in varchar2 default hr_api.g_varchar2,
526: p_segment14 in varchar2 default hr_api.g_varchar2,
527: p_segment15 in varchar2 default hr_api.g_varchar2,
528: p_segment16 in varchar2 default hr_api.g_varchar2,
529: p_segment17 in varchar2 default hr_api.g_varchar2,
530: p_segment18 in varchar2 default hr_api.g_varchar2,
531: p_segment19 in varchar2 default hr_api.g_varchar2,
532: p_segment20 in varchar2 default hr_api.g_varchar2,
525: p_segment13 in varchar2 default hr_api.g_varchar2,
526: p_segment14 in varchar2 default hr_api.g_varchar2,
527: p_segment15 in varchar2 default hr_api.g_varchar2,
528: p_segment16 in varchar2 default hr_api.g_varchar2,
529: p_segment17 in varchar2 default hr_api.g_varchar2,
530: p_segment18 in varchar2 default hr_api.g_varchar2,
531: p_segment19 in varchar2 default hr_api.g_varchar2,
532: p_segment20 in varchar2 default hr_api.g_varchar2,
533: p_segment21 in varchar2 default hr_api.g_varchar2,
526: p_segment14 in varchar2 default hr_api.g_varchar2,
527: p_segment15 in varchar2 default hr_api.g_varchar2,
528: p_segment16 in varchar2 default hr_api.g_varchar2,
529: p_segment17 in varchar2 default hr_api.g_varchar2,
530: p_segment18 in varchar2 default hr_api.g_varchar2,
531: p_segment19 in varchar2 default hr_api.g_varchar2,
532: p_segment20 in varchar2 default hr_api.g_varchar2,
533: p_segment21 in varchar2 default hr_api.g_varchar2,
534: p_segment22 in varchar2 default hr_api.g_varchar2,
527: p_segment15 in varchar2 default hr_api.g_varchar2,
528: p_segment16 in varchar2 default hr_api.g_varchar2,
529: p_segment17 in varchar2 default hr_api.g_varchar2,
530: p_segment18 in varchar2 default hr_api.g_varchar2,
531: p_segment19 in varchar2 default hr_api.g_varchar2,
532: p_segment20 in varchar2 default hr_api.g_varchar2,
533: p_segment21 in varchar2 default hr_api.g_varchar2,
534: p_segment22 in varchar2 default hr_api.g_varchar2,
535: p_segment23 in varchar2 default hr_api.g_varchar2,
528: p_segment16 in varchar2 default hr_api.g_varchar2,
529: p_segment17 in varchar2 default hr_api.g_varchar2,
530: p_segment18 in varchar2 default hr_api.g_varchar2,
531: p_segment19 in varchar2 default hr_api.g_varchar2,
532: p_segment20 in varchar2 default hr_api.g_varchar2,
533: p_segment21 in varchar2 default hr_api.g_varchar2,
534: p_segment22 in varchar2 default hr_api.g_varchar2,
535: p_segment23 in varchar2 default hr_api.g_varchar2,
536: p_segment24 in varchar2 default hr_api.g_varchar2,
529: p_segment17 in varchar2 default hr_api.g_varchar2,
530: p_segment18 in varchar2 default hr_api.g_varchar2,
531: p_segment19 in varchar2 default hr_api.g_varchar2,
532: p_segment20 in varchar2 default hr_api.g_varchar2,
533: p_segment21 in varchar2 default hr_api.g_varchar2,
534: p_segment22 in varchar2 default hr_api.g_varchar2,
535: p_segment23 in varchar2 default hr_api.g_varchar2,
536: p_segment24 in varchar2 default hr_api.g_varchar2,
537: p_segment25 in varchar2 default hr_api.g_varchar2,
530: p_segment18 in varchar2 default hr_api.g_varchar2,
531: p_segment19 in varchar2 default hr_api.g_varchar2,
532: p_segment20 in varchar2 default hr_api.g_varchar2,
533: p_segment21 in varchar2 default hr_api.g_varchar2,
534: p_segment22 in varchar2 default hr_api.g_varchar2,
535: p_segment23 in varchar2 default hr_api.g_varchar2,
536: p_segment24 in varchar2 default hr_api.g_varchar2,
537: p_segment25 in varchar2 default hr_api.g_varchar2,
538: p_segment26 in varchar2 default hr_api.g_varchar2,
531: p_segment19 in varchar2 default hr_api.g_varchar2,
532: p_segment20 in varchar2 default hr_api.g_varchar2,
533: p_segment21 in varchar2 default hr_api.g_varchar2,
534: p_segment22 in varchar2 default hr_api.g_varchar2,
535: p_segment23 in varchar2 default hr_api.g_varchar2,
536: p_segment24 in varchar2 default hr_api.g_varchar2,
537: p_segment25 in varchar2 default hr_api.g_varchar2,
538: p_segment26 in varchar2 default hr_api.g_varchar2,
539: p_segment27 in varchar2 default hr_api.g_varchar2,
532: p_segment20 in varchar2 default hr_api.g_varchar2,
533: p_segment21 in varchar2 default hr_api.g_varchar2,
534: p_segment22 in varchar2 default hr_api.g_varchar2,
535: p_segment23 in varchar2 default hr_api.g_varchar2,
536: p_segment24 in varchar2 default hr_api.g_varchar2,
537: p_segment25 in varchar2 default hr_api.g_varchar2,
538: p_segment26 in varchar2 default hr_api.g_varchar2,
539: p_segment27 in varchar2 default hr_api.g_varchar2,
540: p_segment28 in varchar2 default hr_api.g_varchar2,
533: p_segment21 in varchar2 default hr_api.g_varchar2,
534: p_segment22 in varchar2 default hr_api.g_varchar2,
535: p_segment23 in varchar2 default hr_api.g_varchar2,
536: p_segment24 in varchar2 default hr_api.g_varchar2,
537: p_segment25 in varchar2 default hr_api.g_varchar2,
538: p_segment26 in varchar2 default hr_api.g_varchar2,
539: p_segment27 in varchar2 default hr_api.g_varchar2,
540: p_segment28 in varchar2 default hr_api.g_varchar2,
541: p_segment29 in varchar2 default hr_api.g_varchar2,
534: p_segment22 in varchar2 default hr_api.g_varchar2,
535: p_segment23 in varchar2 default hr_api.g_varchar2,
536: p_segment24 in varchar2 default hr_api.g_varchar2,
537: p_segment25 in varchar2 default hr_api.g_varchar2,
538: p_segment26 in varchar2 default hr_api.g_varchar2,
539: p_segment27 in varchar2 default hr_api.g_varchar2,
540: p_segment28 in varchar2 default hr_api.g_varchar2,
541: p_segment29 in varchar2 default hr_api.g_varchar2,
542: p_segment30 in varchar2 default hr_api.g_varchar2,
535: p_segment23 in varchar2 default hr_api.g_varchar2,
536: p_segment24 in varchar2 default hr_api.g_varchar2,
537: p_segment25 in varchar2 default hr_api.g_varchar2,
538: p_segment26 in varchar2 default hr_api.g_varchar2,
539: p_segment27 in varchar2 default hr_api.g_varchar2,
540: p_segment28 in varchar2 default hr_api.g_varchar2,
541: p_segment29 in varchar2 default hr_api.g_varchar2,
542: p_segment30 in varchar2 default hr_api.g_varchar2,
543: p_concat_segments_in in varchar2 default hr_api.g_varchar2,
536: p_segment24 in varchar2 default hr_api.g_varchar2,
537: p_segment25 in varchar2 default hr_api.g_varchar2,
538: p_segment26 in varchar2 default hr_api.g_varchar2,
539: p_segment27 in varchar2 default hr_api.g_varchar2,
540: p_segment28 in varchar2 default hr_api.g_varchar2,
541: p_segment29 in varchar2 default hr_api.g_varchar2,
542: p_segment30 in varchar2 default hr_api.g_varchar2,
543: p_concat_segments_in in varchar2 default hr_api.g_varchar2,
544: p_batch_line_id in number default hr_api.g_number,
537: p_segment25 in varchar2 default hr_api.g_varchar2,
538: p_segment26 in varchar2 default hr_api.g_varchar2,
539: p_segment27 in varchar2 default hr_api.g_varchar2,
540: p_segment28 in varchar2 default hr_api.g_varchar2,
541: p_segment29 in varchar2 default hr_api.g_varchar2,
542: p_segment30 in varchar2 default hr_api.g_varchar2,
543: p_concat_segments_in in varchar2 default hr_api.g_varchar2,
544: p_batch_line_id in number default hr_api.g_number,
545: p_batch_id in number default hr_api.g_number,
538: p_segment26 in varchar2 default hr_api.g_varchar2,
539: p_segment27 in varchar2 default hr_api.g_varchar2,
540: p_segment28 in varchar2 default hr_api.g_varchar2,
541: p_segment29 in varchar2 default hr_api.g_varchar2,
542: p_segment30 in varchar2 default hr_api.g_varchar2,
543: p_concat_segments_in in varchar2 default hr_api.g_varchar2,
544: p_batch_line_id in number default hr_api.g_number,
545: p_batch_id in number default hr_api.g_number,
546: --
539: p_segment27 in varchar2 default hr_api.g_varchar2,
540: p_segment28 in varchar2 default hr_api.g_varchar2,
541: p_segment29 in varchar2 default hr_api.g_varchar2,
542: p_segment30 in varchar2 default hr_api.g_varchar2,
543: p_concat_segments_in in varchar2 default hr_api.g_varchar2,
544: p_batch_line_id in number default hr_api.g_number,
545: p_batch_id in number default hr_api.g_number,
546: --
547: -- OUT parameter,
540: p_segment28 in varchar2 default hr_api.g_varchar2,
541: p_segment29 in varchar2 default hr_api.g_varchar2,
542: p_segment30 in varchar2 default hr_api.g_varchar2,
543: p_concat_segments_in in varchar2 default hr_api.g_varchar2,
544: p_batch_line_id in number default hr_api.g_number,
545: p_batch_id in number default hr_api.g_number,
546: --
547: -- OUT parameter,
548: -- l_rec.cost_allocation_keyflex_id may have a new value
541: p_segment29 in varchar2 default hr_api.g_varchar2,
542: p_segment30 in varchar2 default hr_api.g_varchar2,
543: p_concat_segments_in in varchar2 default hr_api.g_varchar2,
544: p_batch_line_id in number default hr_api.g_number,
545: p_batch_id in number default hr_api.g_number,
546: --
547: -- OUT parameter,
548: -- l_rec.cost_allocation_keyflex_id may have a new value
549: --