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_RUD_SHD dependencies on FND_MESSAGE

Line 26: fnd_message.set_name ('OTA', 'OTA_13202_GEN_INVALID_KEY');

22: --
23: -- Key constraints
24: --
25: If (p_constraint_name = 'OTA_RESOURCE_USAGES_FK1') Then
26: fnd_message.set_name ('OTA', 'OTA_13202_GEN_INVALID_KEY');
27: fnd_message.set_token ('COLUMN_NAME','SUPPLIED_RESOURCE_ID');
28: fnd_message.set_token ('TABLE_NAME', 'OTA_SUPPLIABLE_RESOURCES');
29: fnd_message.raise_error;
30: ElsIf (p_constraint_name = 'OTA_RESOURCE_USAGES_FK2') Then

Line 27: fnd_message.set_token ('COLUMN_NAME','SUPPLIED_RESOURCE_ID');

23: -- Key constraints
24: --
25: If (p_constraint_name = 'OTA_RESOURCE_USAGES_FK1') Then
26: fnd_message.set_name ('OTA', 'OTA_13202_GEN_INVALID_KEY');
27: fnd_message.set_token ('COLUMN_NAME','SUPPLIED_RESOURCE_ID');
28: fnd_message.set_token ('TABLE_NAME', 'OTA_SUPPLIABLE_RESOURCES');
29: fnd_message.raise_error;
30: ElsIf (p_constraint_name = 'OTA_RESOURCE_USAGES_FK2') Then
31: fnd_message.set_name ('OTA', 'OTA_13235_RUD_NO_ACTIVITY');

Line 28: fnd_message.set_token ('TABLE_NAME', 'OTA_SUPPLIABLE_RESOURCES');

24: --
25: If (p_constraint_name = 'OTA_RESOURCE_USAGES_FK1') Then
26: fnd_message.set_name ('OTA', 'OTA_13202_GEN_INVALID_KEY');
27: fnd_message.set_token ('COLUMN_NAME','SUPPLIED_RESOURCE_ID');
28: fnd_message.set_token ('TABLE_NAME', 'OTA_SUPPLIABLE_RESOURCES');
29: fnd_message.raise_error;
30: ElsIf (p_constraint_name = 'OTA_RESOURCE_USAGES_FK2') Then
31: fnd_message.set_name ('OTA', 'OTA_13235_RUD_NO_ACTIVITY');
32: fnd_message.raise_error;

Line 29: fnd_message.raise_error;

25: If (p_constraint_name = 'OTA_RESOURCE_USAGES_FK1') Then
26: fnd_message.set_name ('OTA', 'OTA_13202_GEN_INVALID_KEY');
27: fnd_message.set_token ('COLUMN_NAME','SUPPLIED_RESOURCE_ID');
28: fnd_message.set_token ('TABLE_NAME', 'OTA_SUPPLIABLE_RESOURCES');
29: fnd_message.raise_error;
30: ElsIf (p_constraint_name = 'OTA_RESOURCE_USAGES_FK2') Then
31: fnd_message.set_name ('OTA', 'OTA_13235_RUD_NO_ACTIVITY');
32: fnd_message.raise_error;
33: ElsIf (p_constraint_name = 'OTA_RESOURCE_USAGES_PK') Then

Line 31: fnd_message.set_name ('OTA', 'OTA_13235_RUD_NO_ACTIVITY');

27: fnd_message.set_token ('COLUMN_NAME','SUPPLIED_RESOURCE_ID');
28: fnd_message.set_token ('TABLE_NAME', 'OTA_SUPPLIABLE_RESOURCES');
29: fnd_message.raise_error;
30: ElsIf (p_constraint_name = 'OTA_RESOURCE_USAGES_FK2') Then
31: fnd_message.set_name ('OTA', 'OTA_13235_RUD_NO_ACTIVITY');
32: fnd_message.raise_error;
33: ElsIf (p_constraint_name = 'OTA_RESOURCE_USAGES_PK') Then
34: fnd_message.set_name ('OTA', 'OTA_13216_RUD_RESOURCE_UNIQUE');
35: fnd_message.raise_error;

Line 32: fnd_message.raise_error;

28: fnd_message.set_token ('TABLE_NAME', 'OTA_SUPPLIABLE_RESOURCES');
29: fnd_message.raise_error;
30: ElsIf (p_constraint_name = 'OTA_RESOURCE_USAGES_FK2') Then
31: fnd_message.set_name ('OTA', 'OTA_13235_RUD_NO_ACTIVITY');
32: fnd_message.raise_error;
33: ElsIf (p_constraint_name = 'OTA_RESOURCE_USAGES_PK') Then
34: fnd_message.set_name ('OTA', 'OTA_13216_RUD_RESOURCE_UNIQUE');
35: fnd_message.raise_error;
36: --

Line 34: fnd_message.set_name ('OTA', 'OTA_13216_RUD_RESOURCE_UNIQUE');

30: ElsIf (p_constraint_name = 'OTA_RESOURCE_USAGES_FK2') Then
31: fnd_message.set_name ('OTA', 'OTA_13235_RUD_NO_ACTIVITY');
32: fnd_message.raise_error;
33: ElsIf (p_constraint_name = 'OTA_RESOURCE_USAGES_PK') Then
34: fnd_message.set_name ('OTA', 'OTA_13216_RUD_RESOURCE_UNIQUE');
35: fnd_message.raise_error;
36: --
37: -- Check constraints
38: --

Line 35: fnd_message.raise_error;

31: fnd_message.set_name ('OTA', 'OTA_13235_RUD_NO_ACTIVITY');
32: fnd_message.raise_error;
33: ElsIf (p_constraint_name = 'OTA_RESOURCE_USAGES_PK') Then
34: fnd_message.set_name ('OTA', 'OTA_13216_RUD_RESOURCE_UNIQUE');
35: fnd_message.raise_error;
36: --
37: -- Check constraints
38: --
39: ElsIf (p_constraint_name = 'OTA_RUD_DATES') Then

Line 40: fnd_message.set_name ('OTA', 'OTA_13312_GEN_DATE_ORDER');

36: --
37: -- Check constraints
38: --
39: ElsIf (p_constraint_name = 'OTA_RUD_DATES') Then
40: fnd_message.set_name ('OTA', 'OTA_13312_GEN_DATE_ORDER');
41: fnd_message.raise_error;
42: ElsIf (p_constraint_name = 'OTA_RUD_EXCLUSIVITY') Then
43: fnd_message.set_name ('OTA', 'OTA_13253_RUD_EXCLUSIVITY');
44: fnd_message.raise_error;

Line 41: fnd_message.raise_error;

37: -- Check constraints
38: --
39: ElsIf (p_constraint_name = 'OTA_RUD_DATES') Then
40: fnd_message.set_name ('OTA', 'OTA_13312_GEN_DATE_ORDER');
41: fnd_message.raise_error;
42: ElsIf (p_constraint_name = 'OTA_RUD_EXCLUSIVITY') Then
43: fnd_message.set_name ('OTA', 'OTA_13253_RUD_EXCLUSIVITY');
44: fnd_message.raise_error;
45: ElsIf (p_constraint_name = 'OTA_RUD_REQUIRED_FLAG_CHK') Then

Line 43: fnd_message.set_name ('OTA', 'OTA_13253_RUD_EXCLUSIVITY');

39: ElsIf (p_constraint_name = 'OTA_RUD_DATES') Then
40: fnd_message.set_name ('OTA', 'OTA_13312_GEN_DATE_ORDER');
41: fnd_message.raise_error;
42: ElsIf (p_constraint_name = 'OTA_RUD_EXCLUSIVITY') Then
43: fnd_message.set_name ('OTA', 'OTA_13253_RUD_EXCLUSIVITY');
44: fnd_message.raise_error;
45: ElsIf (p_constraint_name = 'OTA_RUD_REQUIRED_FLAG_CHK') Then
46: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
47: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 44: fnd_message.raise_error;

40: fnd_message.set_name ('OTA', 'OTA_13312_GEN_DATE_ORDER');
41: fnd_message.raise_error;
42: ElsIf (p_constraint_name = 'OTA_RUD_EXCLUSIVITY') Then
43: fnd_message.set_name ('OTA', 'OTA_13253_RUD_EXCLUSIVITY');
44: fnd_message.raise_error;
45: ElsIf (p_constraint_name = 'OTA_RUD_REQUIRED_FLAG_CHK') Then
46: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
47: hr_utility.set_message_token('PROCEDURE', l_proc);
48: hr_utility.set_message_token('STEP','30');

Line 51: fnd_message.set_name ('OTA', 'OTA_13254_RUD_RESOURCE_ROLE');

47: hr_utility.set_message_token('PROCEDURE', l_proc);
48: hr_utility.set_message_token('STEP','30');
49: hr_utility.raise_error;
50: ElsIf (p_constraint_name = 'OTA_RUD_RESOURCE_ROLE') Then
51: fnd_message.set_name ('OTA', 'OTA_13254_RUD_RESOURCE_ROLE');
52: fnd_message.raise_error;
53: --
54: -- Others, see below
55: --

Line 52: fnd_message.raise_error;

48: hr_utility.set_message_token('STEP','30');
49: hr_utility.raise_error;
50: ElsIf (p_constraint_name = 'OTA_RUD_RESOURCE_ROLE') Then
51: fnd_message.set_name ('OTA', 'OTA_13254_RUD_RESOURCE_ROLE');
52: fnd_message.raise_error;
53: --
54: -- Others, see below
55: --
56: elsif (p_constraint_name = 'OTA_RUD_NON_TRANSFER') then

Line 57: fnd_message.set_name ('OTA', 'OTA_13633_RUD_NON_TRANSFER');

53: --
54: -- Others, see below
55: --
56: elsif (p_constraint_name = 'OTA_RUD_NON_TRANSFER') then
57: fnd_message.set_name ('OTA', 'OTA_13633_RUD_NON_TRANSFER');
58: fnd_message.raise_error;
59: elsif (p_constraint_name = 'OTA_RUD_TAV_DATES') then
60: fnd_message.set_name ('OTA', 'OTA_13256_RUD_TAV_DATES');
61: fnd_message.raise_error;

Line 58: fnd_message.raise_error;

54: -- Others, see below
55: --
56: elsif (p_constraint_name = 'OTA_RUD_NON_TRANSFER') then
57: fnd_message.set_name ('OTA', 'OTA_13633_RUD_NON_TRANSFER');
58: fnd_message.raise_error;
59: elsif (p_constraint_name = 'OTA_RUD_TAV_DATES') then
60: fnd_message.set_name ('OTA', 'OTA_13256_RUD_TAV_DATES');
61: fnd_message.raise_error;
62: elsif (p_constraint_name = 'OTA_RUD_TSR_DATES') then

Line 60: fnd_message.set_name ('OTA', 'OTA_13256_RUD_TAV_DATES');

56: elsif (p_constraint_name = 'OTA_RUD_NON_TRANSFER') then
57: fnd_message.set_name ('OTA', 'OTA_13633_RUD_NON_TRANSFER');
58: fnd_message.raise_error;
59: elsif (p_constraint_name = 'OTA_RUD_TAV_DATES') then
60: fnd_message.set_name ('OTA', 'OTA_13256_RUD_TAV_DATES');
61: fnd_message.raise_error;
62: elsif (p_constraint_name = 'OTA_RUD_TSR_DATES') then
63: fnd_message.set_name ('OTA', 'OTA_13257_RUD_TSR_DATES');
64: fnd_message.raise_error;

Line 61: fnd_message.raise_error;

57: fnd_message.set_name ('OTA', 'OTA_13633_RUD_NON_TRANSFER');
58: fnd_message.raise_error;
59: elsif (p_constraint_name = 'OTA_RUD_TAV_DATES') then
60: fnd_message.set_name ('OTA', 'OTA_13256_RUD_TAV_DATES');
61: fnd_message.raise_error;
62: elsif (p_constraint_name = 'OTA_RUD_TSR_DATES') then
63: fnd_message.set_name ('OTA', 'OTA_13257_RUD_TSR_DATES');
64: fnd_message.raise_error;
65: elsif (p_constraint_name = 'OTA_RUD_BUSINESS_GROUPS') then

Line 63: fnd_message.set_name ('OTA', 'OTA_13257_RUD_TSR_DATES');

59: elsif (p_constraint_name = 'OTA_RUD_TAV_DATES') then
60: fnd_message.set_name ('OTA', 'OTA_13256_RUD_TAV_DATES');
61: fnd_message.raise_error;
62: elsif (p_constraint_name = 'OTA_RUD_TSR_DATES') then
63: fnd_message.set_name ('OTA', 'OTA_13257_RUD_TSR_DATES');
64: fnd_message.raise_error;
65: elsif (p_constraint_name = 'OTA_RUD_BUSINESS_GROUPS') then
66: fnd_message.set_name ('OTA', 'OTA_13247_RUD_SAME_BIZ_GROUP');
67: fnd_message.raise_error;

Line 64: fnd_message.raise_error;

60: fnd_message.set_name ('OTA', 'OTA_13256_RUD_TAV_DATES');
61: fnd_message.raise_error;
62: elsif (p_constraint_name = 'OTA_RUD_TSR_DATES') then
63: fnd_message.set_name ('OTA', 'OTA_13257_RUD_TSR_DATES');
64: fnd_message.raise_error;
65: elsif (p_constraint_name = 'OTA_RUD_BUSINESS_GROUPS') then
66: fnd_message.set_name ('OTA', 'OTA_13247_RUD_SAME_BIZ_GROUP');
67: fnd_message.raise_error;
68: elsif (p_constraint_name = 'OTA_RUD_REQUIRED') then

Line 66: fnd_message.set_name ('OTA', 'OTA_13247_RUD_SAME_BIZ_GROUP');

62: elsif (p_constraint_name = 'OTA_RUD_TSR_DATES') then
63: fnd_message.set_name ('OTA', 'OTA_13257_RUD_TSR_DATES');
64: fnd_message.raise_error;
65: elsif (p_constraint_name = 'OTA_RUD_BUSINESS_GROUPS') then
66: fnd_message.set_name ('OTA', 'OTA_13247_RUD_SAME_BIZ_GROUP');
67: fnd_message.raise_error;
68: elsif (p_constraint_name = 'OTA_RUD_REQUIRED') then
69: HR_UTILITY.SET_MESSAGE (801,'HR_7166_OBJECT_CHK_CONSTRAINT');
70: HR_UTILITY.SET_MESSAGE_TOKEN ('CONSTRAINT_NAME', 'OTA_RUD_REQUIRED');

Line 67: fnd_message.raise_error;

63: fnd_message.set_name ('OTA', 'OTA_13257_RUD_TSR_DATES');
64: fnd_message.raise_error;
65: elsif (p_constraint_name = 'OTA_RUD_BUSINESS_GROUPS') then
66: fnd_message.set_name ('OTA', 'OTA_13247_RUD_SAME_BIZ_GROUP');
67: fnd_message.raise_error;
68: elsif (p_constraint_name = 'OTA_RUD_REQUIRED') then
69: HR_UTILITY.SET_MESSAGE (801,'HR_7166_OBJECT_CHK_CONSTRAINT');
70: HR_UTILITY.SET_MESSAGE_TOKEN ('CONSTRAINT_NAME', 'OTA_RUD_REQUIRED');
71: HR_UTILITY.SET_MESSAGE_TOKEN ('TABLE_NAME', 'OTA_RESOURCE_USAGES');

Line 76: fnd_message.set_name ('OTA', 'OTA_13259_GEN_UNKN_CONSTRAINT');

72: HR_UTILITY.raise_error;
73: --
74: --
75: Else
76: fnd_message.set_name ('OTA', 'OTA_13259_GEN_UNKN_CONSTRAINT');
77: fnd_message.set_token ('PROCEDURE', l_proc);
78: fnd_message.set_token ('CONSTRAINT', p_constraint_name);
79: fnd_message.raise_error;
80: End If;

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

73: --
74: --
75: Else
76: fnd_message.set_name ('OTA', 'OTA_13259_GEN_UNKN_CONSTRAINT');
77: fnd_message.set_token ('PROCEDURE', l_proc);
78: fnd_message.set_token ('CONSTRAINT', p_constraint_name);
79: fnd_message.raise_error;
80: End If;
81: --

Line 78: fnd_message.set_token ('CONSTRAINT', p_constraint_name);

74: --
75: Else
76: fnd_message.set_name ('OTA', 'OTA_13259_GEN_UNKN_CONSTRAINT');
77: fnd_message.set_token ('PROCEDURE', l_proc);
78: fnd_message.set_token ('CONSTRAINT', p_constraint_name);
79: fnd_message.raise_error;
80: End If;
81: --
82: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 79: fnd_message.raise_error;

75: Else
76: fnd_message.set_name ('OTA', 'OTA_13259_GEN_UNKN_CONSTRAINT');
77: fnd_message.set_token ('PROCEDURE', l_proc);
78: fnd_message.set_token ('CONSTRAINT', p_constraint_name);
79: fnd_message.raise_error;
80: End If;
81: --
82: hr_utility.set_location(' Leaving:'||l_proc, 10);
83: --