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

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

79: --
80: hr_utility.set_location('Entering:'||l_proc, 5);
81: --
82: If (p_constraint_name = 'OTA_CHECK_START_END_TIMES') Then
83: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
84: fnd_message.set_token('PROCEDURE', l_proc);
85: fnd_message.set_token('STEP','5');
86: fnd_message.raise_error;
87: ElsIf (p_constraint_name = 'OTA_CHK_REQ_TIMES_END_FMT') Then

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

80: hr_utility.set_location('Entering:'||l_proc, 5);
81: --
82: If (p_constraint_name = 'OTA_CHECK_START_END_TIMES') Then
83: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
84: fnd_message.set_token('PROCEDURE', l_proc);
85: fnd_message.set_token('STEP','5');
86: fnd_message.raise_error;
87: ElsIf (p_constraint_name = 'OTA_CHK_REQ_TIMES_END_FMT') Then
88: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

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

81: --
82: If (p_constraint_name = 'OTA_CHECK_START_END_TIMES') Then
83: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
84: fnd_message.set_token('PROCEDURE', l_proc);
85: fnd_message.set_token('STEP','5');
86: fnd_message.raise_error;
87: ElsIf (p_constraint_name = 'OTA_CHK_REQ_TIMES_END_FMT') Then
88: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
89: fnd_message.set_token('PROCEDURE', l_proc);

Line 86: fnd_message.raise_error;

82: If (p_constraint_name = 'OTA_CHECK_START_END_TIMES') Then
83: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
84: fnd_message.set_token('PROCEDURE', l_proc);
85: fnd_message.set_token('STEP','5');
86: fnd_message.raise_error;
87: ElsIf (p_constraint_name = 'OTA_CHK_REQ_TIMES_END_FMT') Then
88: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
89: fnd_message.set_token('PROCEDURE', l_proc);
90: fnd_message.set_token('STEP','10');

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

84: fnd_message.set_token('PROCEDURE', l_proc);
85: fnd_message.set_token('STEP','5');
86: fnd_message.raise_error;
87: ElsIf (p_constraint_name = 'OTA_CHK_REQ_TIMES_END_FMT') Then
88: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
89: fnd_message.set_token('PROCEDURE', l_proc);
90: fnd_message.set_token('STEP','10');
91: fnd_message.raise_error;
92: ElsIf (p_constraint_name = 'OTA_CHK_REQ_TIMES_START_FMT') Then

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

85: fnd_message.set_token('STEP','5');
86: fnd_message.raise_error;
87: ElsIf (p_constraint_name = 'OTA_CHK_REQ_TIMES_END_FMT') Then
88: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
89: fnd_message.set_token('PROCEDURE', l_proc);
90: fnd_message.set_token('STEP','10');
91: fnd_message.raise_error;
92: ElsIf (p_constraint_name = 'OTA_CHK_REQ_TIMES_START_FMT') Then
93: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

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

86: fnd_message.raise_error;
87: ElsIf (p_constraint_name = 'OTA_CHK_REQ_TIMES_END_FMT') Then
88: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
89: fnd_message.set_token('PROCEDURE', l_proc);
90: fnd_message.set_token('STEP','10');
91: fnd_message.raise_error;
92: ElsIf (p_constraint_name = 'OTA_CHK_REQ_TIMES_START_FMT') Then
93: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
94: fnd_message.set_token('PROCEDURE', l_proc);

Line 91: fnd_message.raise_error;

87: ElsIf (p_constraint_name = 'OTA_CHK_REQ_TIMES_END_FMT') Then
88: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
89: fnd_message.set_token('PROCEDURE', l_proc);
90: fnd_message.set_token('STEP','10');
91: fnd_message.raise_error;
92: ElsIf (p_constraint_name = 'OTA_CHK_REQ_TIMES_START_FMT') Then
93: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
94: fnd_message.set_token('PROCEDURE', l_proc);
95: fnd_message.set_token('STEP','15');

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

89: fnd_message.set_token('PROCEDURE', l_proc);
90: fnd_message.set_token('STEP','10');
91: fnd_message.raise_error;
92: ElsIf (p_constraint_name = 'OTA_CHK_REQ_TIMES_START_FMT') Then
93: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
94: fnd_message.set_token('PROCEDURE', l_proc);
95: fnd_message.set_token('STEP','15');
96: fnd_message.raise_error;
97: ElsIf (p_constraint_name = 'OTA_RESOURCE_BOOKINGS_FK1') Then

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

90: fnd_message.set_token('STEP','10');
91: fnd_message.raise_error;
92: ElsIf (p_constraint_name = 'OTA_CHK_REQ_TIMES_START_FMT') Then
93: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
94: fnd_message.set_token('PROCEDURE', l_proc);
95: fnd_message.set_token('STEP','15');
96: fnd_message.raise_error;
97: ElsIf (p_constraint_name = 'OTA_RESOURCE_BOOKINGS_FK1') Then
98: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

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

91: fnd_message.raise_error;
92: ElsIf (p_constraint_name = 'OTA_CHK_REQ_TIMES_START_FMT') Then
93: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
94: fnd_message.set_token('PROCEDURE', l_proc);
95: fnd_message.set_token('STEP','15');
96: fnd_message.raise_error;
97: ElsIf (p_constraint_name = 'OTA_RESOURCE_BOOKINGS_FK1') Then
98: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
99: fnd_message.set_token('PROCEDURE', l_proc);

Line 96: fnd_message.raise_error;

92: ElsIf (p_constraint_name = 'OTA_CHK_REQ_TIMES_START_FMT') Then
93: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
94: fnd_message.set_token('PROCEDURE', l_proc);
95: fnd_message.set_token('STEP','15');
96: fnd_message.raise_error;
97: ElsIf (p_constraint_name = 'OTA_RESOURCE_BOOKINGS_FK1') Then
98: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
99: fnd_message.set_token('PROCEDURE', l_proc);
100: fnd_message.set_token('STEP','20');

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

94: fnd_message.set_token('PROCEDURE', l_proc);
95: fnd_message.set_token('STEP','15');
96: fnd_message.raise_error;
97: ElsIf (p_constraint_name = 'OTA_RESOURCE_BOOKINGS_FK1') Then
98: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
99: fnd_message.set_token('PROCEDURE', l_proc);
100: fnd_message.set_token('STEP','20');
101: fnd_message.raise_error;
102: ElsIf (p_constraint_name = 'OTA_RESOURCE_BOOKINGS_FK2') Then

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

95: fnd_message.set_token('STEP','15');
96: fnd_message.raise_error;
97: ElsIf (p_constraint_name = 'OTA_RESOURCE_BOOKINGS_FK1') Then
98: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
99: fnd_message.set_token('PROCEDURE', l_proc);
100: fnd_message.set_token('STEP','20');
101: fnd_message.raise_error;
102: ElsIf (p_constraint_name = 'OTA_RESOURCE_BOOKINGS_FK2') Then
103: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

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

96: fnd_message.raise_error;
97: ElsIf (p_constraint_name = 'OTA_RESOURCE_BOOKINGS_FK1') Then
98: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
99: fnd_message.set_token('PROCEDURE', l_proc);
100: fnd_message.set_token('STEP','20');
101: fnd_message.raise_error;
102: ElsIf (p_constraint_name = 'OTA_RESOURCE_BOOKINGS_FK2') Then
103: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
104: fnd_message.set_token('PROCEDURE', l_proc);

Line 101: fnd_message.raise_error;

97: ElsIf (p_constraint_name = 'OTA_RESOURCE_BOOKINGS_FK1') Then
98: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
99: fnd_message.set_token('PROCEDURE', l_proc);
100: fnd_message.set_token('STEP','20');
101: fnd_message.raise_error;
102: ElsIf (p_constraint_name = 'OTA_RESOURCE_BOOKINGS_FK2') Then
103: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
104: fnd_message.set_token('PROCEDURE', l_proc);
105: fnd_message.set_token('STEP','25');

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

99: fnd_message.set_token('PROCEDURE', l_proc);
100: fnd_message.set_token('STEP','20');
101: fnd_message.raise_error;
102: ElsIf (p_constraint_name = 'OTA_RESOURCE_BOOKINGS_FK2') Then
103: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
104: fnd_message.set_token('PROCEDURE', l_proc);
105: fnd_message.set_token('STEP','25');
106: fnd_message.raise_error;
107: ElsIf (p_constraint_name = 'OTA_RESOURCE_BOOKINGS_PK') Then

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

100: fnd_message.set_token('STEP','20');
101: fnd_message.raise_error;
102: ElsIf (p_constraint_name = 'OTA_RESOURCE_BOOKINGS_FK2') Then
103: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
104: fnd_message.set_token('PROCEDURE', l_proc);
105: fnd_message.set_token('STEP','25');
106: fnd_message.raise_error;
107: ElsIf (p_constraint_name = 'OTA_RESOURCE_BOOKINGS_PK') Then
108: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

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

101: fnd_message.raise_error;
102: ElsIf (p_constraint_name = 'OTA_RESOURCE_BOOKINGS_FK2') Then
103: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
104: fnd_message.set_token('PROCEDURE', l_proc);
105: fnd_message.set_token('STEP','25');
106: fnd_message.raise_error;
107: ElsIf (p_constraint_name = 'OTA_RESOURCE_BOOKINGS_PK') Then
108: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
109: fnd_message.set_token('PROCEDURE', l_proc);

Line 106: fnd_message.raise_error;

102: ElsIf (p_constraint_name = 'OTA_RESOURCE_BOOKINGS_FK2') Then
103: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
104: fnd_message.set_token('PROCEDURE', l_proc);
105: fnd_message.set_token('STEP','25');
106: fnd_message.raise_error;
107: ElsIf (p_constraint_name = 'OTA_RESOURCE_BOOKINGS_PK') Then
108: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
109: fnd_message.set_token('PROCEDURE', l_proc);
110: fnd_message.set_token('STEP','30');

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

104: fnd_message.set_token('PROCEDURE', l_proc);
105: fnd_message.set_token('STEP','25');
106: fnd_message.raise_error;
107: ElsIf (p_constraint_name = 'OTA_RESOURCE_BOOKINGS_PK') Then
108: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
109: fnd_message.set_token('PROCEDURE', l_proc);
110: fnd_message.set_token('STEP','30');
111: fnd_message.raise_error;
112: ElsIf (p_constraint_name = 'OTA_TRB_PRIMARY_VENUE_FLAG_CHK') Then

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

105: fnd_message.set_token('STEP','25');
106: fnd_message.raise_error;
107: ElsIf (p_constraint_name = 'OTA_RESOURCE_BOOKINGS_PK') Then
108: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
109: fnd_message.set_token('PROCEDURE', l_proc);
110: fnd_message.set_token('STEP','30');
111: fnd_message.raise_error;
112: ElsIf (p_constraint_name = 'OTA_TRB_PRIMARY_VENUE_FLAG_CHK') Then
113: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 110: fnd_message.set_token('STEP','30');

106: fnd_message.raise_error;
107: ElsIf (p_constraint_name = 'OTA_RESOURCE_BOOKINGS_PK') Then
108: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
109: fnd_message.set_token('PROCEDURE', l_proc);
110: fnd_message.set_token('STEP','30');
111: fnd_message.raise_error;
112: ElsIf (p_constraint_name = 'OTA_TRB_PRIMARY_VENUE_FLAG_CHK') Then
113: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
114: fnd_message.set_token('PROCEDURE', l_proc);

Line 111: fnd_message.raise_error;

107: ElsIf (p_constraint_name = 'OTA_RESOURCE_BOOKINGS_PK') Then
108: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
109: fnd_message.set_token('PROCEDURE', l_proc);
110: fnd_message.set_token('STEP','30');
111: fnd_message.raise_error;
112: ElsIf (p_constraint_name = 'OTA_TRB_PRIMARY_VENUE_FLAG_CHK') Then
113: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
114: fnd_message.set_token('PROCEDURE', l_proc);
115: fnd_message.set_token('STEP','35');

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

109: fnd_message.set_token('PROCEDURE', l_proc);
110: fnd_message.set_token('STEP','30');
111: fnd_message.raise_error;
112: ElsIf (p_constraint_name = 'OTA_TRB_PRIMARY_VENUE_FLAG_CHK') Then
113: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
114: fnd_message.set_token('PROCEDURE', l_proc);
115: fnd_message.set_token('STEP','35');
116: fnd_message.raise_error;
117: ElsIf (p_constraint_name = 'OTA_TRB_STATUS_CHK') Then

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

110: fnd_message.set_token('STEP','30');
111: fnd_message.raise_error;
112: ElsIf (p_constraint_name = 'OTA_TRB_PRIMARY_VENUE_FLAG_CHK') Then
113: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
114: fnd_message.set_token('PROCEDURE', l_proc);
115: fnd_message.set_token('STEP','35');
116: fnd_message.raise_error;
117: ElsIf (p_constraint_name = 'OTA_TRB_STATUS_CHK') Then
118: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

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

111: fnd_message.raise_error;
112: ElsIf (p_constraint_name = 'OTA_TRB_PRIMARY_VENUE_FLAG_CHK') Then
113: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
114: fnd_message.set_token('PROCEDURE', l_proc);
115: fnd_message.set_token('STEP','35');
116: fnd_message.raise_error;
117: ElsIf (p_constraint_name = 'OTA_TRB_STATUS_CHK') Then
118: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
119: fnd_message.set_token('PROCEDURE', l_proc);

Line 116: fnd_message.raise_error;

112: ElsIf (p_constraint_name = 'OTA_TRB_PRIMARY_VENUE_FLAG_CHK') Then
113: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
114: fnd_message.set_token('PROCEDURE', l_proc);
115: fnd_message.set_token('STEP','35');
116: fnd_message.raise_error;
117: ElsIf (p_constraint_name = 'OTA_TRB_STATUS_CHK') Then
118: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
119: fnd_message.set_token('PROCEDURE', l_proc);
120: fnd_message.set_token('STEP','40');

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

114: fnd_message.set_token('PROCEDURE', l_proc);
115: fnd_message.set_token('STEP','35');
116: fnd_message.raise_error;
117: ElsIf (p_constraint_name = 'OTA_TRB_STATUS_CHK') Then
118: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
119: fnd_message.set_token('PROCEDURE', l_proc);
120: fnd_message.set_token('STEP','40');
121: fnd_message.raise_error;
122: Else

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

115: fnd_message.set_token('STEP','35');
116: fnd_message.raise_error;
117: ElsIf (p_constraint_name = 'OTA_TRB_STATUS_CHK') Then
118: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
119: fnd_message.set_token('PROCEDURE', l_proc);
120: fnd_message.set_token('STEP','40');
121: fnd_message.raise_error;
122: Else
123: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');

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

116: fnd_message.raise_error;
117: ElsIf (p_constraint_name = 'OTA_TRB_STATUS_CHK') Then
118: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
119: fnd_message.set_token('PROCEDURE', l_proc);
120: fnd_message.set_token('STEP','40');
121: fnd_message.raise_error;
122: Else
123: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
124: fnd_message.set_token('PROCEDURE', l_proc);

Line 121: fnd_message.raise_error;

117: ElsIf (p_constraint_name = 'OTA_TRB_STATUS_CHK') Then
118: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
119: fnd_message.set_token('PROCEDURE', l_proc);
120: fnd_message.set_token('STEP','40');
121: fnd_message.raise_error;
122: Else
123: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
124: fnd_message.set_token('PROCEDURE', l_proc);
125: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);

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

119: fnd_message.set_token('PROCEDURE', l_proc);
120: fnd_message.set_token('STEP','40');
121: fnd_message.raise_error;
122: Else
123: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
124: fnd_message.set_token('PROCEDURE', l_proc);
125: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
126: fnd_message.raise_error;
127: End If;

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

120: fnd_message.set_token('STEP','40');
121: fnd_message.raise_error;
122: Else
123: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
124: fnd_message.set_token('PROCEDURE', l_proc);
125: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
126: fnd_message.raise_error;
127: End If;
128: --

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

121: fnd_message.raise_error;
122: Else
123: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
124: fnd_message.set_token('PROCEDURE', l_proc);
125: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
126: fnd_message.raise_error;
127: End If;
128: --
129: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 126: fnd_message.raise_error;

122: Else
123: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
124: fnd_message.set_token('PROCEDURE', l_proc);
125: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
126: fnd_message.raise_error;
127: End If;
128: --
129: hr_utility.set_location(' Leaving:'||l_proc, 10);
130: End constraint_error;