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.BEN_XEL_SHD dependencies on FND_MESSAGE

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

53: Begin
54: hr_utility.set_location('Entering:'||l_proc, 5);
55: --
56: If (p_constraint_name = 'BEN_EXT_DATA_ELMT_FK2') Then
57: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
58: fnd_message.set_token('PROCEDURE', l_proc);
59: fnd_message.set_token('STEP','5');
60: fnd_message.raise_error;
61: ElsIf (p_constraint_name = 'BEN_EXT_DATA_ELMT_PK') Then

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

54: hr_utility.set_location('Entering:'||l_proc, 5);
55: --
56: If (p_constraint_name = 'BEN_EXT_DATA_ELMT_FK2') Then
57: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
58: fnd_message.set_token('PROCEDURE', l_proc);
59: fnd_message.set_token('STEP','5');
60: fnd_message.raise_error;
61: ElsIf (p_constraint_name = 'BEN_EXT_DATA_ELMT_PK') Then
62: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

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

55: --
56: If (p_constraint_name = 'BEN_EXT_DATA_ELMT_FK2') Then
57: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
58: fnd_message.set_token('PROCEDURE', l_proc);
59: fnd_message.set_token('STEP','5');
60: fnd_message.raise_error;
61: ElsIf (p_constraint_name = 'BEN_EXT_DATA_ELMT_PK') Then
62: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
63: fnd_message.set_token('PROCEDURE', l_proc);

Line 60: fnd_message.raise_error;

56: If (p_constraint_name = 'BEN_EXT_DATA_ELMT_FK2') Then
57: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
58: fnd_message.set_token('PROCEDURE', l_proc);
59: fnd_message.set_token('STEP','5');
60: fnd_message.raise_error;
61: ElsIf (p_constraint_name = 'BEN_EXT_DATA_ELMT_PK') Then
62: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
63: fnd_message.set_token('PROCEDURE', l_proc);
64: fnd_message.set_token('STEP','10');

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

58: fnd_message.set_token('PROCEDURE', l_proc);
59: fnd_message.set_token('STEP','5');
60: fnd_message.raise_error;
61: ElsIf (p_constraint_name = 'BEN_EXT_DATA_ELMT_PK') Then
62: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
63: fnd_message.set_token('PROCEDURE', l_proc);
64: fnd_message.set_token('STEP','10');
65: fnd_message.raise_error;
66: ElsIf (p_constraint_name = 'BEN_EXT_DATA_ELMT_DECD_FK1') Then

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

59: fnd_message.set_token('STEP','5');
60: fnd_message.raise_error;
61: ElsIf (p_constraint_name = 'BEN_EXT_DATA_ELMT_PK') Then
62: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
63: fnd_message.set_token('PROCEDURE', l_proc);
64: fnd_message.set_token('STEP','10');
65: fnd_message.raise_error;
66: ElsIf (p_constraint_name = 'BEN_EXT_DATA_ELMT_DECD_FK1') Then
67: fnd_message.set_name('BEN', 'BEN_92477_ELMT_HAS_CHLD2');

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

60: fnd_message.raise_error;
61: ElsIf (p_constraint_name = 'BEN_EXT_DATA_ELMT_PK') Then
62: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
63: fnd_message.set_token('PROCEDURE', l_proc);
64: fnd_message.set_token('STEP','10');
65: fnd_message.raise_error;
66: ElsIf (p_constraint_name = 'BEN_EXT_DATA_ELMT_DECD_FK1') Then
67: fnd_message.set_name('BEN', 'BEN_92477_ELMT_HAS_CHLD2');
68: fnd_message.raise_error;

Line 65: fnd_message.raise_error;

61: ElsIf (p_constraint_name = 'BEN_EXT_DATA_ELMT_PK') Then
62: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
63: fnd_message.set_token('PROCEDURE', l_proc);
64: fnd_message.set_token('STEP','10');
65: fnd_message.raise_error;
66: ElsIf (p_constraint_name = 'BEN_EXT_DATA_ELMT_DECD_FK1') Then
67: fnd_message.set_name('BEN', 'BEN_92477_ELMT_HAS_CHLD2');
68: fnd_message.raise_error;
69: ElsIf (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_FK1') Then

Line 67: fnd_message.set_name('BEN', 'BEN_92477_ELMT_HAS_CHLD2');

63: fnd_message.set_token('PROCEDURE', l_proc);
64: fnd_message.set_token('STEP','10');
65: fnd_message.raise_error;
66: ElsIf (p_constraint_name = 'BEN_EXT_DATA_ELMT_DECD_FK1') Then
67: fnd_message.set_name('BEN', 'BEN_92477_ELMT_HAS_CHLD2');
68: fnd_message.raise_error;
69: ElsIf (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_FK1') Then
70: fnd_message.set_name('BEN', 'BEN_92476_ELMT_HAS_CHLD1');
71: fnd_message.raise_error;

Line 68: fnd_message.raise_error;

64: fnd_message.set_token('STEP','10');
65: fnd_message.raise_error;
66: ElsIf (p_constraint_name = 'BEN_EXT_DATA_ELMT_DECD_FK1') Then
67: fnd_message.set_name('BEN', 'BEN_92477_ELMT_HAS_CHLD2');
68: fnd_message.raise_error;
69: ElsIf (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_FK1') Then
70: fnd_message.set_name('BEN', 'BEN_92476_ELMT_HAS_CHLD1');
71: fnd_message.raise_error;
72: ElsIf (p_constraint_name = 'BEN_EXT_DATA_ELMT_FK3') Then

Line 70: fnd_message.set_name('BEN', 'BEN_92476_ELMT_HAS_CHLD1');

66: ElsIf (p_constraint_name = 'BEN_EXT_DATA_ELMT_DECD_FK1') Then
67: fnd_message.set_name('BEN', 'BEN_92477_ELMT_HAS_CHLD2');
68: fnd_message.raise_error;
69: ElsIf (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_FK1') Then
70: fnd_message.set_name('BEN', 'BEN_92476_ELMT_HAS_CHLD1');
71: fnd_message.raise_error;
72: ElsIf (p_constraint_name = 'BEN_EXT_DATA_ELMT_FK3') Then
73: open c2;
74: fetch c2 into l_name;

Line 71: fnd_message.raise_error;

67: fnd_message.set_name('BEN', 'BEN_92477_ELMT_HAS_CHLD2');
68: fnd_message.raise_error;
69: ElsIf (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_FK1') Then
70: fnd_message.set_name('BEN', 'BEN_92476_ELMT_HAS_CHLD1');
71: fnd_message.raise_error;
72: ElsIf (p_constraint_name = 'BEN_EXT_DATA_ELMT_FK3') Then
73: open c2;
74: fetch c2 into l_name;
75: close c2;

Line 76: fnd_message.set_name('BEN', 'BEN_92475_ELMT_USED_IN_TTL');

72: ElsIf (p_constraint_name = 'BEN_EXT_DATA_ELMT_FK3') Then
73: open c2;
74: fetch c2 into l_name;
75: close c2;
76: fnd_message.set_name('BEN', 'BEN_92475_ELMT_USED_IN_TTL');
77: fnd_message.set_token('DATA_ELMT', l_name);
78: fnd_message.raise_error;
79: ElsIf (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_FK2') Then
80: open c3;

Line 77: fnd_message.set_token('DATA_ELMT', l_name);

73: open c2;
74: fetch c2 into l_name;
75: close c2;
76: fnd_message.set_name('BEN', 'BEN_92475_ELMT_USED_IN_TTL');
77: fnd_message.set_token('DATA_ELMT', l_name);
78: fnd_message.raise_error;
79: ElsIf (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_FK2') Then
80: open c3;
81: fetch c3 into l_name;

Line 78: fnd_message.raise_error;

74: fetch c2 into l_name;
75: close c2;
76: fnd_message.set_name('BEN', 'BEN_92475_ELMT_USED_IN_TTL');
77: fnd_message.set_token('DATA_ELMT', l_name);
78: fnd_message.raise_error;
79: ElsIf (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_FK2') Then
80: open c3;
81: fetch c3 into l_name;
82: close c3;

Line 83: fnd_message.set_name('BEN', 'BEN_92475_ELMT_USED_IN_TTL');

79: ElsIf (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_FK2') Then
80: open c3;
81: fetch c3 into l_name;
82: close c3;
83: fnd_message.set_name('BEN', 'BEN_92475_ELMT_USED_IN_TTL');
84: fnd_message.set_token('DATA_ELMT', l_name);
85: fnd_message.raise_error;
86: ElsIf (p_constraint_name = 'BEN_EXT_DATA_ELMT_IN_RCD_FK1') Then
87: open c1;

Line 84: fnd_message.set_token('DATA_ELMT', l_name);

80: open c3;
81: fetch c3 into l_name;
82: close c3;
83: fnd_message.set_name('BEN', 'BEN_92475_ELMT_USED_IN_TTL');
84: fnd_message.set_token('DATA_ELMT', l_name);
85: fnd_message.raise_error;
86: ElsIf (p_constraint_name = 'BEN_EXT_DATA_ELMT_IN_RCD_FK1') Then
87: open c1;
88: fetch c1 into l_name;

Line 85: fnd_message.raise_error;

81: fetch c3 into l_name;
82: close c3;
83: fnd_message.set_name('BEN', 'BEN_92475_ELMT_USED_IN_TTL');
84: fnd_message.set_token('DATA_ELMT', l_name);
85: fnd_message.raise_error;
86: ElsIf (p_constraint_name = 'BEN_EXT_DATA_ELMT_IN_RCD_FK1') Then
87: open c1;
88: fetch c1 into l_name;
89: close c1;

Line 90: fnd_message.set_name('BEN', 'BEN_92474_ELMT_USED_IN_RCD');

86: ElsIf (p_constraint_name = 'BEN_EXT_DATA_ELMT_IN_RCD_FK1') Then
87: open c1;
88: fetch c1 into l_name;
89: close c1;
90: fnd_message.set_name('BEN', 'BEN_92474_ELMT_USED_IN_RCD');
91: fnd_message.set_token('RECORD', l_name);
92: fnd_message.raise_error;
93: Else
94: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');

Line 91: fnd_message.set_token('RECORD', l_name);

87: open c1;
88: fetch c1 into l_name;
89: close c1;
90: fnd_message.set_name('BEN', 'BEN_92474_ELMT_USED_IN_RCD');
91: fnd_message.set_token('RECORD', l_name);
92: fnd_message.raise_error;
93: Else
94: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
95: fnd_message.set_token('PROCEDURE', l_proc);

Line 92: fnd_message.raise_error;

88: fetch c1 into l_name;
89: close c1;
90: fnd_message.set_name('BEN', 'BEN_92474_ELMT_USED_IN_RCD');
91: fnd_message.set_token('RECORD', l_name);
92: fnd_message.raise_error;
93: Else
94: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
95: fnd_message.set_token('PROCEDURE', l_proc);
96: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);

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

90: fnd_message.set_name('BEN', 'BEN_92474_ELMT_USED_IN_RCD');
91: fnd_message.set_token('RECORD', l_name);
92: fnd_message.raise_error;
93: Else
94: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
95: fnd_message.set_token('PROCEDURE', l_proc);
96: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
97: fnd_message.raise_error;
98:

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

91: fnd_message.set_token('RECORD', l_name);
92: fnd_message.raise_error;
93: Else
94: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
95: fnd_message.set_token('PROCEDURE', l_proc);
96: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
97: fnd_message.raise_error;
98:
99: End If;

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

92: fnd_message.raise_error;
93: Else
94: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
95: fnd_message.set_token('PROCEDURE', l_proc);
96: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
97: fnd_message.raise_error;
98:
99: End If;
100: --

Line 97: fnd_message.raise_error;

93: Else
94: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
95: fnd_message.set_token('PROCEDURE', l_proc);
96: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
97: fnd_message.raise_error;
98:
99: End If;
100: --
101: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

210: Close C_Sel1;
211: --
212: -- The primary key is invalid therefore we must error
213: --
214: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
215: fnd_message.raise_error;
216: End If;
217: Close C_Sel1;
218: If (p_object_version_number <> g_old_rec.object_version_number) Then

Line 215: fnd_message.raise_error;

211: --
212: -- The primary key is invalid therefore we must error
213: --
214: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
215: fnd_message.raise_error;
216: End If;
217: Close C_Sel1;
218: If (p_object_version_number <> g_old_rec.object_version_number) Then
219: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');

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

215: fnd_message.raise_error;
216: End If;
217: Close C_Sel1;
218: If (p_object_version_number <> g_old_rec.object_version_number) Then
219: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
220: fnd_message.raise_error;
221: End If;
222: hr_utility.set_location(l_proc, 15);
223: l_fct_ret := true;

Line 220: fnd_message.raise_error;

216: End If;
217: Close C_Sel1;
218: If (p_object_version_number <> g_old_rec.object_version_number) Then
219: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
220: fnd_message.raise_error;
221: End If;
222: hr_utility.set_location(l_proc, 15);
223: l_fct_ret := true;
224: End If;

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

318: Close C_Sel1;
319: --
320: -- The primary key is invalid therefore we must error
321: --
322: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
323: fnd_message.raise_error;
324: End If;
325: Close C_Sel1;
326: If (p_object_version_number <> g_old_rec.object_version_number) Then

Line 323: fnd_message.raise_error;

319: --
320: -- The primary key is invalid therefore we must error
321: --
322: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
323: fnd_message.raise_error;
324: End If;
325: Close C_Sel1;
326: If (p_object_version_number <> g_old_rec.object_version_number) Then
327: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');

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

323: fnd_message.raise_error;
324: End If;
325: Close C_Sel1;
326: If (p_object_version_number <> g_old_rec.object_version_number) Then
327: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
328: fnd_message.raise_error;
329: End If;
330: --
331: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 328: fnd_message.raise_error;

324: End If;
325: Close C_Sel1;
326: If (p_object_version_number <> g_old_rec.object_version_number) Then
327: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
328: fnd_message.raise_error;
329: End If;
330: --
331: hr_utility.set_location(' Leaving:'||l_proc, 10);
332: --

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

337: --
338: -- The object is locked therefore we need to supply a meaningful
339: -- error message.
340: --
341: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
342: fnd_message.set_token('TABLE_NAME', 'ben_ext_data_elmt');
343: fnd_message.raise_error;
344: End lck;
345: --

Line 342: fnd_message.set_token('TABLE_NAME', 'ben_ext_data_elmt');

338: -- The object is locked therefore we need to supply a meaningful
339: -- error message.
340: --
341: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
342: fnd_message.set_token('TABLE_NAME', 'ben_ext_data_elmt');
343: fnd_message.raise_error;
344: End lck;
345: --
346: -- ----------------------------------------------------------------------------

Line 343: fnd_message.raise_error;

339: -- error message.
340: --
341: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
342: fnd_message.set_token('TABLE_NAME', 'ben_ext_data_elmt');
343: fnd_message.raise_error;
344: End lck;
345: --
346: -- ----------------------------------------------------------------------------
347: -- |-----------------------------< convert_args >-----------------------------|