29: --
30: Begin
31: --
32: If (p_constraint_name = 'PAY_REPORT_FORMAT_MAPPINGS_PK') Then
33: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
34: fnd_message.set_token('PROCEDURE', l_proc);
35: fnd_message.set_token('STEP','5');
36: fnd_message.raise_error;
37: Else
30: Begin
31: --
32: If (p_constraint_name = 'PAY_REPORT_FORMAT_MAPPINGS_PK') Then
33: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
34: fnd_message.set_token('PROCEDURE', l_proc);
35: fnd_message.set_token('STEP','5');
36: fnd_message.raise_error;
37: Else
38: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
31: --
32: If (p_constraint_name = 'PAY_REPORT_FORMAT_MAPPINGS_PK') Then
33: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
34: fnd_message.set_token('PROCEDURE', l_proc);
35: fnd_message.set_token('STEP','5');
36: fnd_message.raise_error;
37: Else
38: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
39: fnd_message.set_token('PROCEDURE', l_proc);
32: If (p_constraint_name = 'PAY_REPORT_FORMAT_MAPPINGS_PK') Then
33: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
34: fnd_message.set_token('PROCEDURE', l_proc);
35: fnd_message.set_token('STEP','5');
36: fnd_message.raise_error;
37: Else
38: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
39: fnd_message.set_token('PROCEDURE', l_proc);
40: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
34: fnd_message.set_token('PROCEDURE', l_proc);
35: fnd_message.set_token('STEP','5');
36: fnd_message.raise_error;
37: Else
38: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
39: fnd_message.set_token('PROCEDURE', l_proc);
40: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
41: fnd_message.raise_error;
42: End If;
35: fnd_message.set_token('STEP','5');
36: fnd_message.raise_error;
37: Else
38: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
39: fnd_message.set_token('PROCEDURE', l_proc);
40: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
41: fnd_message.raise_error;
42: End If;
43: --
36: fnd_message.raise_error;
37: Else
38: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
39: fnd_message.set_token('PROCEDURE', l_proc);
40: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
41: fnd_message.raise_error;
42: End If;
43: --
44: End constraint_error;
37: Else
38: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
39: fnd_message.set_token('PROCEDURE', l_proc);
40: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
41: fnd_message.raise_error;
42: End If;
43: --
44: End constraint_error;
45: --
114: Close C_Sel1;
115: --
116: -- The primary key is invalid therefore we must error
117: --
118: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
119: fnd_message.raise_error;
120: End If;
121: Close C_Sel1;
122: If (p_object_version_number
115: --
116: -- The primary key is invalid therefore we must error
117: --
118: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
119: fnd_message.raise_error;
120: End If;
121: Close C_Sel1;
122: If (p_object_version_number
123: <> pay_rfm_shd.g_old_rec.object_version_number) Then
120: End If;
121: Close C_Sel1;
122: If (p_object_version_number
123: <> pay_rfm_shd.g_old_rec.object_version_number) Then
124: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
125: fnd_message.raise_error;
126: End If;
127: l_fct_ret := true;
128: End If;
121: Close C_Sel1;
122: If (p_object_version_number
123: <> pay_rfm_shd.g_old_rec.object_version_number) Then
124: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
125: fnd_message.raise_error;
126: End If;
127: l_fct_ret := true;
128: End If;
129: End If;
337: Close C_Sel1;
338: --
339: -- The primary key is invalid therefore we must error
340: --
341: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
342: fnd_message.raise_error;
343: End If;
344: Close C_Sel1;
345: If (p_object_version_number
338: --
339: -- The primary key is invalid therefore we must error
340: --
341: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
342: fnd_message.raise_error;
343: End If;
344: Close C_Sel1;
345: If (p_object_version_number
346: <> pay_rfm_shd.g_old_rec.object_version_number) Then
343: End If;
344: Close C_Sel1;
345: If (p_object_version_number
346: <> pay_rfm_shd.g_old_rec.object_version_number) Then
347: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
348: fnd_message.raise_error;
349: End If;
350: --
351: --
344: Close C_Sel1;
345: If (p_object_version_number
346: <> pay_rfm_shd.g_old_rec.object_version_number) Then
347: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
348: fnd_message.raise_error;
349: End If;
350: --
351: --
352: -- Validate the datetrack mode mode getting the validation start
367: -- We are doing a datetrack 'INSERT' which is illegal within this
368: -- procedure therefore we must error (note: to lck on insert the
369: -- private procedure ins_lck should be called).
370: --
371: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
372: fnd_message.set_token('PROCEDURE', l_proc);
373: fnd_message.set_token('STEP','20');
374: fnd_message.raise_error;
375: End If;
368: -- procedure therefore we must error (note: to lck on insert the
369: -- private procedure ins_lck should be called).
370: --
371: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
372: fnd_message.set_token('PROCEDURE', l_proc);
373: fnd_message.set_token('STEP','20');
374: fnd_message.raise_error;
375: End If;
376: --
369: -- private procedure ins_lck should be called).
370: --
371: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
372: fnd_message.set_token('PROCEDURE', l_proc);
373: fnd_message.set_token('STEP','20');
374: fnd_message.raise_error;
375: End If;
376: --
377: -- Set the validation start and end date OUT arguments
370: --
371: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
372: fnd_message.set_token('PROCEDURE', l_proc);
373: fnd_message.set_token('STEP','20');
374: fnd_message.raise_error;
375: End If;
376: --
377: -- Set the validation start and end date OUT arguments
378: --
388: --
389: -- The object is locked therefore we need to supply a meaningful
390: -- error message.
391: --
392: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
393: fnd_message.set_token('TABLE_NAME', 'pay_report_format_mappings_f');
394: fnd_message.raise_error;
395: End lck;
396: --
389: -- The object is locked therefore we need to supply a meaningful
390: -- error message.
391: --
392: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
393: fnd_message.set_token('TABLE_NAME', 'pay_report_format_mappings_f');
394: fnd_message.raise_error;
395: End lck;
396: --
397: -- ----------------------------------------------------------------------------
390: -- error message.
391: --
392: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
393: fnd_message.set_token('TABLE_NAME', 'pay_report_format_mappings_f');
394: fnd_message.raise_error;
395: End lck;
396: --
397: -- ----------------------------------------------------------------------------
398: -- |-----------------------------< convert_args >-----------------------------|
491: if csr_format_mapping_id%ROWCOUNT > 1 then
492:
493: close csr_format_mapping_id;
494:
495: fnd_message.set_name( 'PAY' , 'PAY_33255_INV_SKEY' );
496: fnd_message.set_token( 'SURROGATE_ID' , 'REPORT_FORMAT_MAPPING_ID' );
497: fnd_message.set_token( 'ENTITY' , 'REPORT FORMAT MAPPING' );
498: fnd_message.raise_error ;
499:
492:
493: close csr_format_mapping_id;
494:
495: fnd_message.set_name( 'PAY' , 'PAY_33255_INV_SKEY' );
496: fnd_message.set_token( 'SURROGATE_ID' , 'REPORT_FORMAT_MAPPING_ID' );
497: fnd_message.set_token( 'ENTITY' , 'REPORT FORMAT MAPPING' );
498: fnd_message.raise_error ;
499:
500: end if;
493: close csr_format_mapping_id;
494:
495: fnd_message.set_name( 'PAY' , 'PAY_33255_INV_SKEY' );
496: fnd_message.set_token( 'SURROGATE_ID' , 'REPORT_FORMAT_MAPPING_ID' );
497: fnd_message.set_token( 'ENTITY' , 'REPORT FORMAT MAPPING' );
498: fnd_message.raise_error ;
499:
500: end if;
501:
494:
495: fnd_message.set_name( 'PAY' , 'PAY_33255_INV_SKEY' );
496: fnd_message.set_token( 'SURROGATE_ID' , 'REPORT_FORMAT_MAPPING_ID' );
497: fnd_message.set_token( 'ENTITY' , 'REPORT FORMAT MAPPING' );
498: fnd_message.raise_error ;
499:
500: end if;
501:
502: if csr_format_mapping_id%found and l_report_format_mapping_id is null then
502: if csr_format_mapping_id%found and l_report_format_mapping_id is null then
503:
504: close csr_format_mapping_id;
505:
506: fnd_message.set_name( 'PAY' , 'PAY_33255_INV_SKEY' );
507: fnd_message.set_token( 'SURROGATE_ID' , 'REPORT_FORMAT_MAPPING_ID' );
508: fnd_message.set_token( 'ENTITY' , 'REPORT FORMAT MAPPING' );
509: fnd_message.raise_error ;
510:
503:
504: close csr_format_mapping_id;
505:
506: fnd_message.set_name( 'PAY' , 'PAY_33255_INV_SKEY' );
507: fnd_message.set_token( 'SURROGATE_ID' , 'REPORT_FORMAT_MAPPING_ID' );
508: fnd_message.set_token( 'ENTITY' , 'REPORT FORMAT MAPPING' );
509: fnd_message.raise_error ;
510:
511: end if;
504: close csr_format_mapping_id;
505:
506: fnd_message.set_name( 'PAY' , 'PAY_33255_INV_SKEY' );
507: fnd_message.set_token( 'SURROGATE_ID' , 'REPORT_FORMAT_MAPPING_ID' );
508: fnd_message.set_token( 'ENTITY' , 'REPORT FORMAT MAPPING' );
509: fnd_message.raise_error ;
510:
511: end if;
512:
505:
506: fnd_message.set_name( 'PAY' , 'PAY_33255_INV_SKEY' );
507: fnd_message.set_token( 'SURROGATE_ID' , 'REPORT_FORMAT_MAPPING_ID' );
508: fnd_message.set_token( 'ENTITY' , 'REPORT FORMAT MAPPING' );
509: fnd_message.raise_error ;
510:
511: end if;
512:
513: close csr_format_mapping_id;