eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_SPP_SHD dependencies on FND_MESSAGE

Line 33: fnd_message.set_name('PER', 'HR_289228_SPP_FK1_BUS_GROUP');

29: --
30: Begin
31: --
32: If (p_constraint_name = 'PER_SPINAL_POINT_PLACEMENT_FK1') Then
33: fnd_message.set_name('PER', 'HR_289228_SPP_FK1_BUS_GROUP');
34: fnd_message.set_token('PROCEDURE', l_proc);
35: fnd_message.set_token('STEP','5');
36: fnd_message.raise_error;
37: ElsIf (p_constraint_name = 'PER_SPINAL_POINT_PLACEMENT_PK') Then

Line 34: fnd_message.set_token('PROCEDURE', l_proc);

30: Begin
31: --
32: If (p_constraint_name = 'PER_SPINAL_POINT_PLACEMENT_FK1') Then
33: fnd_message.set_name('PER', 'HR_289228_SPP_FK1_BUS_GROUP');
34: fnd_message.set_token('PROCEDURE', l_proc);
35: fnd_message.set_token('STEP','5');
36: fnd_message.raise_error;
37: ElsIf (p_constraint_name = 'PER_SPINAL_POINT_PLACEMENT_PK') Then
38: fnd_message.set_name('PER', 'HR_289222_SPP_PK_PLACEMENT_ID');

Line 35: fnd_message.set_token('STEP','5');

31: --
32: If (p_constraint_name = 'PER_SPINAL_POINT_PLACEMENT_FK1') Then
33: fnd_message.set_name('PER', 'HR_289228_SPP_FK1_BUS_GROUP');
34: fnd_message.set_token('PROCEDURE', l_proc);
35: fnd_message.set_token('STEP','5');
36: fnd_message.raise_error;
37: ElsIf (p_constraint_name = 'PER_SPINAL_POINT_PLACEMENT_PK') Then
38: fnd_message.set_name('PER', 'HR_289222_SPP_PK_PLACEMENT_ID');
39: fnd_message.set_token('PROCEDURE', l_proc);

Line 36: fnd_message.raise_error;

32: If (p_constraint_name = 'PER_SPINAL_POINT_PLACEMENT_FK1') Then
33: fnd_message.set_name('PER', 'HR_289228_SPP_FK1_BUS_GROUP');
34: fnd_message.set_token('PROCEDURE', l_proc);
35: fnd_message.set_token('STEP','5');
36: fnd_message.raise_error;
37: ElsIf (p_constraint_name = 'PER_SPINAL_POINT_PLACEMENT_PK') Then
38: fnd_message.set_name('PER', 'HR_289222_SPP_PK_PLACEMENT_ID');
39: fnd_message.set_token('PROCEDURE', l_proc);
40: fnd_message.set_token('STEP','10');

Line 38: fnd_message.set_name('PER', 'HR_289222_SPP_PK_PLACEMENT_ID');

34: fnd_message.set_token('PROCEDURE', l_proc);
35: fnd_message.set_token('STEP','5');
36: fnd_message.raise_error;
37: ElsIf (p_constraint_name = 'PER_SPINAL_POINT_PLACEMENT_PK') Then
38: fnd_message.set_name('PER', 'HR_289222_SPP_PK_PLACEMENT_ID');
39: fnd_message.set_token('PROCEDURE', l_proc);
40: fnd_message.set_token('STEP','10');
41: fnd_message.raise_error;
42: ElsIf (p_constraint_name = 'PER_SPTPL_AUTO_INCREMENT_F_CHK') Then

Line 39: fnd_message.set_token('PROCEDURE', l_proc);

35: fnd_message.set_token('STEP','5');
36: fnd_message.raise_error;
37: ElsIf (p_constraint_name = 'PER_SPINAL_POINT_PLACEMENT_PK') Then
38: fnd_message.set_name('PER', 'HR_289222_SPP_PK_PLACEMENT_ID');
39: fnd_message.set_token('PROCEDURE', l_proc);
40: fnd_message.set_token('STEP','10');
41: fnd_message.raise_error;
42: ElsIf (p_constraint_name = 'PER_SPTPL_AUTO_INCREMENT_F_CHK') Then
43: fnd_message.set_name('PER', 'HR_289223_SPP_AUTO_INC_FLG_CHK');

Line 40: fnd_message.set_token('STEP','10');

36: fnd_message.raise_error;
37: ElsIf (p_constraint_name = 'PER_SPINAL_POINT_PLACEMENT_PK') Then
38: fnd_message.set_name('PER', 'HR_289222_SPP_PK_PLACEMENT_ID');
39: fnd_message.set_token('PROCEDURE', l_proc);
40: fnd_message.set_token('STEP','10');
41: fnd_message.raise_error;
42: ElsIf (p_constraint_name = 'PER_SPTPL_AUTO_INCREMENT_F_CHK') Then
43: fnd_message.set_name('PER', 'HR_289223_SPP_AUTO_INC_FLG_CHK');
44: fnd_message.set_token('PROCEDURE', l_proc);

Line 41: fnd_message.raise_error;

37: ElsIf (p_constraint_name = 'PER_SPINAL_POINT_PLACEMENT_PK') Then
38: fnd_message.set_name('PER', 'HR_289222_SPP_PK_PLACEMENT_ID');
39: fnd_message.set_token('PROCEDURE', l_proc);
40: fnd_message.set_token('STEP','10');
41: fnd_message.raise_error;
42: ElsIf (p_constraint_name = 'PER_SPTPL_AUTO_INCREMENT_F_CHK') Then
43: fnd_message.set_name('PER', 'HR_289223_SPP_AUTO_INC_FLG_CHK');
44: fnd_message.set_token('PROCEDURE', l_proc);
45: fnd_message.set_token('STEP','15');

Line 43: fnd_message.set_name('PER', 'HR_289223_SPP_AUTO_INC_FLG_CHK');

39: fnd_message.set_token('PROCEDURE', l_proc);
40: fnd_message.set_token('STEP','10');
41: fnd_message.raise_error;
42: ElsIf (p_constraint_name = 'PER_SPTPL_AUTO_INCREMENT_F_CHK') Then
43: fnd_message.set_name('PER', 'HR_289223_SPP_AUTO_INC_FLG_CHK');
44: fnd_message.set_token('PROCEDURE', l_proc);
45: fnd_message.set_token('STEP','15');
46: fnd_message.raise_error;
47: Else

Line 44: fnd_message.set_token('PROCEDURE', l_proc);

40: fnd_message.set_token('STEP','10');
41: fnd_message.raise_error;
42: ElsIf (p_constraint_name = 'PER_SPTPL_AUTO_INCREMENT_F_CHK') Then
43: fnd_message.set_name('PER', 'HR_289223_SPP_AUTO_INC_FLG_CHK');
44: fnd_message.set_token('PROCEDURE', l_proc);
45: fnd_message.set_token('STEP','15');
46: fnd_message.raise_error;
47: Else
48: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');

Line 45: fnd_message.set_token('STEP','15');

41: fnd_message.raise_error;
42: ElsIf (p_constraint_name = 'PER_SPTPL_AUTO_INCREMENT_F_CHK') Then
43: fnd_message.set_name('PER', 'HR_289223_SPP_AUTO_INC_FLG_CHK');
44: fnd_message.set_token('PROCEDURE', l_proc);
45: fnd_message.set_token('STEP','15');
46: fnd_message.raise_error;
47: Else
48: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
49: fnd_message.set_token('PROCEDURE', l_proc);

Line 46: fnd_message.raise_error;

42: ElsIf (p_constraint_name = 'PER_SPTPL_AUTO_INCREMENT_F_CHK') Then
43: fnd_message.set_name('PER', 'HR_289223_SPP_AUTO_INC_FLG_CHK');
44: fnd_message.set_token('PROCEDURE', l_proc);
45: fnd_message.set_token('STEP','15');
46: fnd_message.raise_error;
47: Else
48: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
49: fnd_message.set_token('PROCEDURE', l_proc);
50: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);

Line 48: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');

44: fnd_message.set_token('PROCEDURE', l_proc);
45: fnd_message.set_token('STEP','15');
46: fnd_message.raise_error;
47: Else
48: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
49: fnd_message.set_token('PROCEDURE', l_proc);
50: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
51: fnd_message.raise_error;
52: End If;

Line 49: fnd_message.set_token('PROCEDURE', l_proc);

45: fnd_message.set_token('STEP','15');
46: fnd_message.raise_error;
47: Else
48: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
49: fnd_message.set_token('PROCEDURE', l_proc);
50: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
51: fnd_message.raise_error;
52: End If;
53: --

Line 50: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);

46: fnd_message.raise_error;
47: Else
48: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
49: fnd_message.set_token('PROCEDURE', l_proc);
50: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
51: fnd_message.raise_error;
52: End If;
53: --
54: End constraint_error;

Line 51: fnd_message.raise_error;

47: Else
48: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
49: fnd_message.set_token('PROCEDURE', l_proc);
50: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
51: fnd_message.raise_error;
52: End If;
53: --
54: End constraint_error;
55: --

Line 160: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');

156: Close C_Sel1;
157: --
158: -- The primary key is invalid therefore we must error
159: --
160: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
161: fnd_message.raise_error;
162: End If;
163: Close C_Sel1;
164: hr_utility.set_location('Entering :'||l_proc, 30);

Line 161: fnd_message.raise_error;

157: --
158: -- The primary key is invalid therefore we must error
159: --
160: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
161: fnd_message.raise_error;
162: End If;
163: Close C_Sel1;
164: hr_utility.set_location('Entering :'||l_proc, 30);
165: If (p_object_version_number

Line 167: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');

163: Close C_Sel1;
164: hr_utility.set_location('Entering :'||l_proc, 30);
165: If (p_object_version_number
166: <> per_spp_shd.g_old_rec.object_version_number) Then
167: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
168: fnd_message.raise_error;
169: End If;
170: l_fct_ret := true;
171: End If;

Line 168: fnd_message.raise_error;

164: hr_utility.set_location('Entering :'||l_proc, 30);
165: If (p_object_version_number
166: <> per_spp_shd.g_old_rec.object_version_number) Then
167: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
168: fnd_message.raise_error;
169: End If;
170: l_fct_ret := true;
171: End If;
172: End If;

Line 271: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

267: l_parent_key_value1
268: ,l_parent_key_value2;
269: If C_Sel1%NOTFOUND then
270: Close C_Sel1;
271: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
272: fnd_message.set_token('PROCEDURE',l_proc);
273: fnd_message.set_token('STEP','10');
274: fnd_message.raise_error;
275: End If;

Line 272: fnd_message.set_token('PROCEDURE',l_proc);

268: ,l_parent_key_value2;
269: If C_Sel1%NOTFOUND then
270: Close C_Sel1;
271: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
272: fnd_message.set_token('PROCEDURE',l_proc);
273: fnd_message.set_token('STEP','10');
274: fnd_message.raise_error;
275: End If;
276: Close C_Sel1;

Line 273: fnd_message.set_token('STEP','10');

269: If C_Sel1%NOTFOUND then
270: Close C_Sel1;
271: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
272: fnd_message.set_token('PROCEDURE',l_proc);
273: fnd_message.set_token('STEP','10');
274: fnd_message.raise_error;
275: End If;
276: Close C_Sel1;
277: --

Line 274: fnd_message.raise_error;

270: Close C_Sel1;
271: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
272: fnd_message.set_token('PROCEDURE',l_proc);
273: fnd_message.set_token('STEP','10');
274: fnd_message.raise_error;
275: End If;
276: Close C_Sel1;
277: --
278: -- Call the corresponding datetrack api

Line 485: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');

481: Close C_Sel1;
482: --
483: -- The primary key is invalid therefore we must error
484: --
485: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
486: fnd_message.raise_error;
487: End If;
488: Close C_Sel1;
489: If (p_object_version_number

Line 486: fnd_message.raise_error;

482: --
483: -- The primary key is invalid therefore we must error
484: --
485: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
486: fnd_message.raise_error;
487: End If;
488: Close C_Sel1;
489: If (p_object_version_number
490: <> per_spp_shd.g_old_rec.object_version_number) Then

Line 491: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');

487: End If;
488: Close C_Sel1;
489: If (p_object_version_number
490: <> per_spp_shd.g_old_rec.object_version_number) Then
491: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
492: fnd_message.raise_error;
493: End If;
494: --
495: -- Validate the datetrack mode mode getting the validation start

Line 492: fnd_message.raise_error;

488: Close C_Sel1;
489: If (p_object_version_number
490: <> per_spp_shd.g_old_rec.object_version_number) Then
491: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
492: fnd_message.raise_error;
493: End If;
494: --
495: -- Validate the datetrack mode mode getting the validation start
496: -- and end dates for the specified datetrack operation.

Line 554: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

550: -- We are doing a datetrack 'INSERT' which is illegal within this
551: -- procedure therefore we must error (note: to lck on insert the
552: -- private procedure ins_lck should be called).
553: --
554: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
555: fnd_message.set_token('PROCEDURE', l_proc);
556: fnd_message.set_token('STEP','20');
557: fnd_message.raise_error;
558: End If;

Line 555: fnd_message.set_token('PROCEDURE', l_proc);

551: -- procedure therefore we must error (note: to lck on insert the
552: -- private procedure ins_lck should be called).
553: --
554: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
555: fnd_message.set_token('PROCEDURE', l_proc);
556: fnd_message.set_token('STEP','20');
557: fnd_message.raise_error;
558: End If;
559: --

Line 556: fnd_message.set_token('STEP','20');

552: -- private procedure ins_lck should be called).
553: --
554: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
555: fnd_message.set_token('PROCEDURE', l_proc);
556: fnd_message.set_token('STEP','20');
557: fnd_message.raise_error;
558: End If;
559: --
560: -- Set the validation start and end date OUT arguments

Line 557: fnd_message.raise_error;

553: --
554: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
555: fnd_message.set_token('PROCEDURE', l_proc);
556: fnd_message.set_token('STEP','20');
557: fnd_message.raise_error;
558: End If;
559: --
560: -- Set the validation start and end date OUT arguments
561: -- taking the most restrictive replies from the two calls

Line 593: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');

589: --
590: -- The object is locked therefore we need to supply a meaningful
591: -- error message.
592: --
593: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
594: fnd_message.set_token('TABLE_NAME', 'per_spinal_point_placements_f');
595: fnd_message.raise_error;
596: End lck;
597: --

Line 594: fnd_message.set_token('TABLE_NAME', 'per_spinal_point_placements_f');

590: -- The object is locked therefore we need to supply a meaningful
591: -- error message.
592: --
593: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
594: fnd_message.set_token('TABLE_NAME', 'per_spinal_point_placements_f');
595: fnd_message.raise_error;
596: End lck;
597: --
598: -- ----------------------------------------------------------------------------

Line 595: fnd_message.raise_error;

591: -- error message.
592: --
593: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
594: fnd_message.set_token('TABLE_NAME', 'per_spinal_point_placements_f');
595: fnd_message.raise_error;
596: End lck;
597: --
598: -- ----------------------------------------------------------------------------
599: -- |-----------------------------< convert_args >-----------------------------|