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

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

29: --
30: Begin
31: --
32: If (p_constraint_name = 'OTA_ACT_CAT_ACTIVE_DATE_CHK') 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: ElsIf (p_constraint_name = 'OTA_ACT_CAT_INCLUSIONS_FK1') Then

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

30: Begin
31: --
32: If (p_constraint_name = 'OTA_ACT_CAT_ACTIVE_DATE_CHK') 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: ElsIf (p_constraint_name = 'OTA_ACT_CAT_INCLUSIONS_FK1') Then
38: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

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

31: --
32: If (p_constraint_name = 'OTA_ACT_CAT_ACTIVE_DATE_CHK') 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: ElsIf (p_constraint_name = 'OTA_ACT_CAT_INCLUSIONS_FK1') Then
38: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
39: fnd_message.set_token('PROCEDURE', l_proc);

Line 36: fnd_message.raise_error;

32: If (p_constraint_name = 'OTA_ACT_CAT_ACTIVE_DATE_CHK') 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: ElsIf (p_constraint_name = 'OTA_ACT_CAT_INCLUSIONS_FK1') Then
38: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
39: fnd_message.set_token('PROCEDURE', l_proc);
40: fnd_message.set_token('STEP','10');

Line 38: 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: ElsIf (p_constraint_name = 'OTA_ACT_CAT_INCLUSIONS_FK1') Then
38: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
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 = 'OTA_ACT_CAT_INCLUSIONS_FK2') 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 = 'OTA_ACT_CAT_INCLUSIONS_FK1') Then
38: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
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 = 'OTA_ACT_CAT_INCLUSIONS_FK2') Then
43: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

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

36: fnd_message.raise_error;
37: ElsIf (p_constraint_name = 'OTA_ACT_CAT_INCLUSIONS_FK1') Then
38: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
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 = 'OTA_ACT_CAT_INCLUSIONS_FK2') Then
43: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
44: fnd_message.set_token('PROCEDURE', l_proc);

Line 41: fnd_message.raise_error;

37: ElsIf (p_constraint_name = 'OTA_ACT_CAT_INCLUSIONS_FK1') Then
38: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
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 = 'OTA_ACT_CAT_INCLUSIONS_FK2') Then
43: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
44: fnd_message.set_token('PROCEDURE', l_proc);
45: fnd_message.set_token('STEP','15');

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

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 = 'OTA_ACT_CAT_INCLUSIONS_FK2') Then
43: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
44: fnd_message.set_token('PROCEDURE', l_proc);
45: fnd_message.set_token('STEP','15');
46: fnd_message.raise_error;
47: ElsIf (p_constraint_name = 'OTA_ACT_CAT_INCLUSIONS_UK3') Then

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 = 'OTA_ACT_CAT_INCLUSIONS_FK2') Then
43: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
44: fnd_message.set_token('PROCEDURE', l_proc);
45: fnd_message.set_token('STEP','15');
46: fnd_message.raise_error;
47: ElsIf (p_constraint_name = 'OTA_ACT_CAT_INCLUSIONS_UK3') Then
48: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

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

41: fnd_message.raise_error;
42: ElsIf (p_constraint_name = 'OTA_ACT_CAT_INCLUSIONS_FK2') Then
43: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
44: fnd_message.set_token('PROCEDURE', l_proc);
45: fnd_message.set_token('STEP','15');
46: fnd_message.raise_error;
47: ElsIf (p_constraint_name = 'OTA_ACT_CAT_INCLUSIONS_UK3') Then
48: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
49: fnd_message.set_token('PROCEDURE', l_proc);

Line 46: fnd_message.raise_error;

42: ElsIf (p_constraint_name = 'OTA_ACT_CAT_INCLUSIONS_FK2') Then
43: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
44: fnd_message.set_token('PROCEDURE', l_proc);
45: fnd_message.set_token('STEP','15');
46: fnd_message.raise_error;
47: ElsIf (p_constraint_name = 'OTA_ACT_CAT_INCLUSIONS_UK3') Then
48: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
49: fnd_message.set_token('PROCEDURE', l_proc);
50: fnd_message.set_token('STEP','20');

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

44: fnd_message.set_token('PROCEDURE', l_proc);
45: fnd_message.set_token('STEP','15');
46: fnd_message.raise_error;
47: ElsIf (p_constraint_name = 'OTA_ACT_CAT_INCLUSIONS_UK3') Then
48: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
49: fnd_message.set_token('PROCEDURE', l_proc);
50: fnd_message.set_token('STEP','20');
51: fnd_message.raise_error;
52: /*

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

45: fnd_message.set_token('STEP','15');
46: fnd_message.raise_error;
47: ElsIf (p_constraint_name = 'OTA_ACT_CAT_INCLUSIONS_UK3') Then
48: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
49: fnd_message.set_token('PROCEDURE', l_proc);
50: fnd_message.set_token('STEP','20');
51: fnd_message.raise_error;
52: /*
53: ElsIf (p_constraint_name = 'OTA_ACT_CAT_INCL_PK') Then

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

46: fnd_message.raise_error;
47: ElsIf (p_constraint_name = 'OTA_ACT_CAT_INCLUSIONS_UK3') Then
48: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
49: fnd_message.set_token('PROCEDURE', l_proc);
50: fnd_message.set_token('STEP','20');
51: fnd_message.raise_error;
52: /*
53: ElsIf (p_constraint_name = 'OTA_ACT_CAT_INCL_PK') Then
54: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 51: fnd_message.raise_error;

47: ElsIf (p_constraint_name = 'OTA_ACT_CAT_INCLUSIONS_UK3') Then
48: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
49: fnd_message.set_token('PROCEDURE', l_proc);
50: fnd_message.set_token('STEP','20');
51: fnd_message.raise_error;
52: /*
53: ElsIf (p_constraint_name = 'OTA_ACT_CAT_INCL_PK') Then
54: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
55: fnd_message.set_token('PROCEDURE', l_proc);

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

50: fnd_message.set_token('STEP','20');
51: fnd_message.raise_error;
52: /*
53: ElsIf (p_constraint_name = 'OTA_ACT_CAT_INCL_PK') Then
54: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
55: fnd_message.set_token('PROCEDURE', l_proc);
56: fnd_message.set_token('STEP','25');
57: fnd_message.raise_error;
58: */

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

51: fnd_message.raise_error;
52: /*
53: ElsIf (p_constraint_name = 'OTA_ACT_CAT_INCL_PK') Then
54: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
55: fnd_message.set_token('PROCEDURE', l_proc);
56: fnd_message.set_token('STEP','25');
57: fnd_message.raise_error;
58: */
59: Else

Line 56: fnd_message.set_token('STEP','25');

52: /*
53: ElsIf (p_constraint_name = 'OTA_ACT_CAT_INCL_PK') Then
54: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
55: fnd_message.set_token('PROCEDURE', l_proc);
56: fnd_message.set_token('STEP','25');
57: fnd_message.raise_error;
58: */
59: Else
60: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');

Line 57: fnd_message.raise_error;

53: ElsIf (p_constraint_name = 'OTA_ACT_CAT_INCL_PK') Then
54: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
55: fnd_message.set_token('PROCEDURE', l_proc);
56: fnd_message.set_token('STEP','25');
57: fnd_message.raise_error;
58: */
59: Else
60: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
61: fnd_message.set_token('PROCEDURE', l_proc);

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

56: fnd_message.set_token('STEP','25');
57: fnd_message.raise_error;
58: */
59: Else
60: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
61: fnd_message.set_token('PROCEDURE', l_proc);
62: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
63: fnd_message.raise_error;
64: End If;

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

57: fnd_message.raise_error;
58: */
59: Else
60: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
61: fnd_message.set_token('PROCEDURE', l_proc);
62: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
63: fnd_message.raise_error;
64: End If;
65: --

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

58: */
59: Else
60: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
61: fnd_message.set_token('PROCEDURE', l_proc);
62: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
63: fnd_message.raise_error;
64: End If;
65: --
66: End constraint_error;

Line 63: fnd_message.raise_error;

59: Else
60: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
61: fnd_message.set_token('PROCEDURE', l_proc);
62: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
63: fnd_message.raise_error;
64: End If;
65: --
66: End constraint_error;
67: --

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

150: Close C_Sel1;
151: --
152: -- The primary key is invalid therefore we must error
153: --
154: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
155: fnd_message.raise_error;
156: End If;
157: Close C_Sel1;
158: If (p_object_version_number

Line 155: fnd_message.raise_error;

151: --
152: -- The primary key is invalid therefore we must error
153: --
154: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
155: fnd_message.raise_error;
156: End If;
157: Close C_Sel1;
158: If (p_object_version_number
159: <> ota_aci_shd.g_old_rec.object_version_number) Then

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

156: End If;
157: Close C_Sel1;
158: If (p_object_version_number
159: <> ota_aci_shd.g_old_rec.object_version_number) Then
160: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
161: fnd_message.raise_error;
162: End If;
163: l_fct_ret := true;
164: End If;

Line 161: fnd_message.raise_error;

157: Close C_Sel1;
158: If (p_object_version_number
159: <> ota_aci_shd.g_old_rec.object_version_number) Then
160: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
161: fnd_message.raise_error;
162: End If;
163: l_fct_ret := true;
164: End If;
165: End If;

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

244: Close C_Sel1;
245: --
246: -- The primary key is invalid therefore we must error
247: --
248: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
249: fnd_message.raise_error;
250: End If;
251: Close C_Sel1;
252: If (p_object_version_number

Line 249: fnd_message.raise_error;

245: --
246: -- The primary key is invalid therefore we must error
247: --
248: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
249: fnd_message.raise_error;
250: End If;
251: Close C_Sel1;
252: If (p_object_version_number
253: <> ota_aci_shd.g_old_rec.object_version_number) Then

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

250: End If;
251: Close C_Sel1;
252: If (p_object_version_number
253: <> ota_aci_shd.g_old_rec.object_version_number) Then
254: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
255: fnd_message.raise_error;
256: End If;
257: --
258: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 255: fnd_message.raise_error;

251: Close C_Sel1;
252: If (p_object_version_number
253: <> ota_aci_shd.g_old_rec.object_version_number) Then
254: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
255: fnd_message.raise_error;
256: End If;
257: --
258: hr_utility.set_location(' Leaving:'||l_proc, 10);
259: --

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

264: --
265: -- The object is locked therefore we need to supply a meaningful
266: -- error message.
267: --
268: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
269: fnd_message.set_token('TABLE_NAME', 'ota_act_cat_inclusions');
270: fnd_message.raise_error;
271: End lck;
272: --

Line 269: fnd_message.set_token('TABLE_NAME', 'ota_act_cat_inclusions');

265: -- The object is locked therefore we need to supply a meaningful
266: -- error message.
267: --
268: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
269: fnd_message.set_token('TABLE_NAME', 'ota_act_cat_inclusions');
270: fnd_message.raise_error;
271: End lck;
272: --
273: -- ----------------------------------------------------------------------------

Line 270: fnd_message.raise_error;

266: -- error message.
267: --
268: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
269: fnd_message.set_token('TABLE_NAME', 'ota_act_cat_inclusions');
270: fnd_message.raise_error;
271: End lck;
272: --
273: -- ----------------------------------------------------------------------------
274: -- |-----------------------------< convert_args >-----------------------------|