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

Line 99: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13202_GEN_INVALID_KEY');

95: --
96: -- Key constraints
97: --
98: if (P_CONSTRAINT_NAME = 'OTA_BOOKING_STATUS_TYPES_FK1') Then
99: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13202_GEN_INVALID_KEY');
100: FND_MESSAGE.SET_TOKEN ('COLUMN_NAME', 'ORGANIZATION_ID');
101: FND_MESSAGE.SET_TOKEN ('TABLE_NAME', 'HR_ORGANIZATION_UNITS');
102: -- elsif (P_CONSTRAINT_NAME = 'OTA_BOOKING_STATUS_TYPES_PK') Then
103: -- Unkn constraint will be raised giving constraint name.

Line 100: FND_MESSAGE.SET_TOKEN ('COLUMN_NAME', 'ORGANIZATION_ID');

96: -- Key constraints
97: --
98: if (P_CONSTRAINT_NAME = 'OTA_BOOKING_STATUS_TYPES_FK1') Then
99: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13202_GEN_INVALID_KEY');
100: FND_MESSAGE.SET_TOKEN ('COLUMN_NAME', 'ORGANIZATION_ID');
101: FND_MESSAGE.SET_TOKEN ('TABLE_NAME', 'HR_ORGANIZATION_UNITS');
102: -- elsif (P_CONSTRAINT_NAME = 'OTA_BOOKING_STATUS_TYPES_PK') Then
103: -- Unkn constraint will be raised giving constraint name.
104: -- FND_MESSAGE.SET_NAME ('OTA', 'HR_6153_ALW_PROCEDURE_FAIL');

Line 101: FND_MESSAGE.SET_TOKEN ('TABLE_NAME', 'HR_ORGANIZATION_UNITS');

97: --
98: if (P_CONSTRAINT_NAME = 'OTA_BOOKING_STATUS_TYPES_FK1') Then
99: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13202_GEN_INVALID_KEY');
100: FND_MESSAGE.SET_TOKEN ('COLUMN_NAME', 'ORGANIZATION_ID');
101: FND_MESSAGE.SET_TOKEN ('TABLE_NAME', 'HR_ORGANIZATION_UNITS');
102: -- elsif (P_CONSTRAINT_NAME = 'OTA_BOOKING_STATUS_TYPES_PK') Then
103: -- Unkn constraint will be raised giving constraint name.
104: -- FND_MESSAGE.SET_NAME ('OTA', 'HR_6153_ALW_PROCEDURE_FAIL');
105: -- FND_MESSAGE.SET_TOKEN ('PROCEDURE', W_PROC);

Line 104: -- FND_MESSAGE.SET_NAME ('OTA', 'HR_6153_ALW_PROCEDURE_FAIL');

100: FND_MESSAGE.SET_TOKEN ('COLUMN_NAME', 'ORGANIZATION_ID');
101: FND_MESSAGE.SET_TOKEN ('TABLE_NAME', 'HR_ORGANIZATION_UNITS');
102: -- elsif (P_CONSTRAINT_NAME = 'OTA_BOOKING_STATUS_TYPES_PK') Then
103: -- Unkn constraint will be raised giving constraint name.
104: -- FND_MESSAGE.SET_NAME ('OTA', 'HR_6153_ALW_PROCEDURE_FAIL');
105: -- FND_MESSAGE.SET_TOKEN ('PROCEDURE', W_PROC);
106: -- FND_MESSAGE.SET_TOKEN ('STEP','10');
107: elsif (P_CONSTRAINT_NAME = 'OTA_BOOKING_STATUS_TYPES_UK2') Then
108: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13209_GEN_NOT_UNIQUE');

Line 105: -- FND_MESSAGE.SET_TOKEN ('PROCEDURE', W_PROC);

101: FND_MESSAGE.SET_TOKEN ('TABLE_NAME', 'HR_ORGANIZATION_UNITS');
102: -- elsif (P_CONSTRAINT_NAME = 'OTA_BOOKING_STATUS_TYPES_PK') Then
103: -- Unkn constraint will be raised giving constraint name.
104: -- FND_MESSAGE.SET_NAME ('OTA', 'HR_6153_ALW_PROCEDURE_FAIL');
105: -- FND_MESSAGE.SET_TOKEN ('PROCEDURE', W_PROC);
106: -- FND_MESSAGE.SET_TOKEN ('STEP','10');
107: elsif (P_CONSTRAINT_NAME = 'OTA_BOOKING_STATUS_TYPES_UK2') Then
108: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13209_GEN_NOT_UNIQUE');
109: FND_MESSAGE.SET_TOKEN ('FIELD', 'The status name');

Line 106: -- FND_MESSAGE.SET_TOKEN ('STEP','10');

102: -- elsif (P_CONSTRAINT_NAME = 'OTA_BOOKING_STATUS_TYPES_PK') Then
103: -- Unkn constraint will be raised giving constraint name.
104: -- FND_MESSAGE.SET_NAME ('OTA', 'HR_6153_ALW_PROCEDURE_FAIL');
105: -- FND_MESSAGE.SET_TOKEN ('PROCEDURE', W_PROC);
106: -- FND_MESSAGE.SET_TOKEN ('STEP','10');
107: elsif (P_CONSTRAINT_NAME = 'OTA_BOOKING_STATUS_TYPES_UK2') Then
108: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13209_GEN_NOT_UNIQUE');
109: FND_MESSAGE.SET_TOKEN ('FIELD', 'The status name');
110: FND_MESSAGE.SET_TOKEN ('MESSAGE_EXTENSION', 'Must be unique');

Line 108: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13209_GEN_NOT_UNIQUE');

104: -- FND_MESSAGE.SET_NAME ('OTA', 'HR_6153_ALW_PROCEDURE_FAIL');
105: -- FND_MESSAGE.SET_TOKEN ('PROCEDURE', W_PROC);
106: -- FND_MESSAGE.SET_TOKEN ('STEP','10');
107: elsif (P_CONSTRAINT_NAME = 'OTA_BOOKING_STATUS_TYPES_UK2') Then
108: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13209_GEN_NOT_UNIQUE');
109: FND_MESSAGE.SET_TOKEN ('FIELD', 'The status name');
110: FND_MESSAGE.SET_TOKEN ('MESSAGE_EXTENSION', 'Must be unique');
111: --
112: -- Check constraints

Line 109: FND_MESSAGE.SET_TOKEN ('FIELD', 'The status name');

105: -- FND_MESSAGE.SET_TOKEN ('PROCEDURE', W_PROC);
106: -- FND_MESSAGE.SET_TOKEN ('STEP','10');
107: elsif (P_CONSTRAINT_NAME = 'OTA_BOOKING_STATUS_TYPES_UK2') Then
108: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13209_GEN_NOT_UNIQUE');
109: FND_MESSAGE.SET_TOKEN ('FIELD', 'The status name');
110: FND_MESSAGE.SET_TOKEN ('MESSAGE_EXTENSION', 'Must be unique');
111: --
112: -- Check constraints
113: --

Line 110: FND_MESSAGE.SET_TOKEN ('MESSAGE_EXTENSION', 'Must be unique');

106: -- FND_MESSAGE.SET_TOKEN ('STEP','10');
107: elsif (P_CONSTRAINT_NAME = 'OTA_BOOKING_STATUS_TYPES_UK2') Then
108: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13209_GEN_NOT_UNIQUE');
109: FND_MESSAGE.SET_TOKEN ('FIELD', 'The status name');
110: FND_MESSAGE.SET_TOKEN ('MESSAGE_EXTENSION', 'Must be unique');
111: --
112: -- Check constraints
113: --
114: elsif (P_CONSTRAINT_NAME = 'OTA_BST_ACTIVE_FLAG_CHK') Then

Line 115: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13387_BST_ACTIVE_FLAG_CHK');

111: --
112: -- Check constraints
113: --
114: elsif (P_CONSTRAINT_NAME = 'OTA_BST_ACTIVE_FLAG_CHK') Then
115: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13387_BST_ACTIVE_FLAG_CHK');
116: elsif (P_CONSTRAINT_NAME = 'OTA_BST_DEFAULT_FLAG_CHK') Then
117: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13388_BST_DEFAULT_FLAG_CHK');
118: elsif (P_CONSTRAINT_NAME = 'OTA_BST_TYPE_CHK') Then
119: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13389_BST_TYPE_CHK');

Line 117: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13388_BST_DEFAULT_FLAG_CHK');

113: --
114: elsif (P_CONSTRAINT_NAME = 'OTA_BST_ACTIVE_FLAG_CHK') Then
115: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13387_BST_ACTIVE_FLAG_CHK');
116: elsif (P_CONSTRAINT_NAME = 'OTA_BST_DEFAULT_FLAG_CHK') Then
117: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13388_BST_DEFAULT_FLAG_CHK');
118: elsif (P_CONSTRAINT_NAME = 'OTA_BST_TYPE_CHK') Then
119: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13389_BST_TYPE_CHK');
120: --
121: -- Other errors, see below

Line 119: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13389_BST_TYPE_CHK');

115: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13387_BST_ACTIVE_FLAG_CHK');
116: elsif (P_CONSTRAINT_NAME = 'OTA_BST_DEFAULT_FLAG_CHK') Then
117: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13388_BST_DEFAULT_FLAG_CHK');
118: elsif (P_CONSTRAINT_NAME = 'OTA_BST_TYPE_CHK') Then
119: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13389_BST_TYPE_CHK');
120: --
121: -- Other errors, see below
122: --
123: elsif (P_CONSTRAINT_NAME = 'OTA_BST_DUPLICATE_NAME') then

Line 124: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13209_GEN_NOT_UNIQUE');

120: --
121: -- Other errors, see below
122: --
123: elsif (P_CONSTRAINT_NAME = 'OTA_BST_DUPLICATE_NAME') then
124: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13209_GEN_NOT_UNIQUE');
125: FND_MESSAGE.SET_TOKEN ('FIELD', 'Name');
126: FND_MESSAGE.SET_TOKEN ('MESSAGE_EXTENSION', 'Must be unique');
127: elsif (P_CONSTRAINT_NAME = 'OTA_BST_BSH_EXISTS') then
128: FND_MESSAGE.SET_NAME ('OTA', 'OTA_443818_NO_DEL_HAS_CHILD');

Line 125: FND_MESSAGE.SET_TOKEN ('FIELD', 'Name');

121: -- Other errors, see below
122: --
123: elsif (P_CONSTRAINT_NAME = 'OTA_BST_DUPLICATE_NAME') then
124: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13209_GEN_NOT_UNIQUE');
125: FND_MESSAGE.SET_TOKEN ('FIELD', 'Name');
126: FND_MESSAGE.SET_TOKEN ('MESSAGE_EXTENSION', 'Must be unique');
127: elsif (P_CONSTRAINT_NAME = 'OTA_BST_BSH_EXISTS') then
128: FND_MESSAGE.SET_NAME ('OTA', 'OTA_443818_NO_DEL_HAS_CHILD');
129: FND_MESSAGE.SET_TOKEN ('ENTITY_NAME', 'Booking status history');

Line 126: FND_MESSAGE.SET_TOKEN ('MESSAGE_EXTENSION', 'Must be unique');

122: --
123: elsif (P_CONSTRAINT_NAME = 'OTA_BST_DUPLICATE_NAME') then
124: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13209_GEN_NOT_UNIQUE');
125: FND_MESSAGE.SET_TOKEN ('FIELD', 'Name');
126: FND_MESSAGE.SET_TOKEN ('MESSAGE_EXTENSION', 'Must be unique');
127: elsif (P_CONSTRAINT_NAME = 'OTA_BST_BSH_EXISTS') then
128: FND_MESSAGE.SET_NAME ('OTA', 'OTA_443818_NO_DEL_HAS_CHILD');
129: FND_MESSAGE.SET_TOKEN ('ENTITY_NAME', 'Booking status history');
130: elsif (P_CONSTRAINT_NAME = 'OTA_BST_TDB_EXISTS') then

Line 128: FND_MESSAGE.SET_NAME ('OTA', 'OTA_443818_NO_DEL_HAS_CHILD');

124: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13209_GEN_NOT_UNIQUE');
125: FND_MESSAGE.SET_TOKEN ('FIELD', 'Name');
126: FND_MESSAGE.SET_TOKEN ('MESSAGE_EXTENSION', 'Must be unique');
127: elsif (P_CONSTRAINT_NAME = 'OTA_BST_BSH_EXISTS') then
128: FND_MESSAGE.SET_NAME ('OTA', 'OTA_443818_NO_DEL_HAS_CHILD');
129: FND_MESSAGE.SET_TOKEN ('ENTITY_NAME', 'Booking status history');
130: elsif (P_CONSTRAINT_NAME = 'OTA_BST_TDB_EXISTS') then
131: FND_MESSAGE.SET_NAME ('OTA', 'OTA_443818_NO_DEL_HAS_CHILD');
132: FND_MESSAGE.SET_TOKEN ('ENTITY_NAME', 'Delegate booking');

Line 129: FND_MESSAGE.SET_TOKEN ('ENTITY_NAME', 'Booking status history');

125: FND_MESSAGE.SET_TOKEN ('FIELD', 'Name');
126: FND_MESSAGE.SET_TOKEN ('MESSAGE_EXTENSION', 'Must be unique');
127: elsif (P_CONSTRAINT_NAME = 'OTA_BST_BSH_EXISTS') then
128: FND_MESSAGE.SET_NAME ('OTA', 'OTA_443818_NO_DEL_HAS_CHILD');
129: FND_MESSAGE.SET_TOKEN ('ENTITY_NAME', 'Booking status history');
130: elsif (P_CONSTRAINT_NAME = 'OTA_BST_TDB_EXISTS') then
131: FND_MESSAGE.SET_NAME ('OTA', 'OTA_443818_NO_DEL_HAS_CHILD');
132: FND_MESSAGE.SET_TOKEN ('ENTITY_NAME', 'Delegate booking');
133: elsif p_constraint_name = 'OTA_BST_ACTIVE_DEFAULT' then

Line 131: FND_MESSAGE.SET_NAME ('OTA', 'OTA_443818_NO_DEL_HAS_CHILD');

127: elsif (P_CONSTRAINT_NAME = 'OTA_BST_BSH_EXISTS') then
128: FND_MESSAGE.SET_NAME ('OTA', 'OTA_443818_NO_DEL_HAS_CHILD');
129: FND_MESSAGE.SET_TOKEN ('ENTITY_NAME', 'Booking status history');
130: elsif (P_CONSTRAINT_NAME = 'OTA_BST_TDB_EXISTS') then
131: FND_MESSAGE.SET_NAME ('OTA', 'OTA_443818_NO_DEL_HAS_CHILD');
132: FND_MESSAGE.SET_TOKEN ('ENTITY_NAME', 'Delegate booking');
133: elsif p_constraint_name = 'OTA_BST_ACTIVE_DEFAULT' then
134: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13390_BST_ACTIVE_DEFAULT');
135: elsif p_constraint_name = 'OTA_BST_DUPLICATE_DEFAULT' then

Line 132: FND_MESSAGE.SET_TOKEN ('ENTITY_NAME', 'Delegate booking');

128: FND_MESSAGE.SET_NAME ('OTA', 'OTA_443818_NO_DEL_HAS_CHILD');
129: FND_MESSAGE.SET_TOKEN ('ENTITY_NAME', 'Booking status history');
130: elsif (P_CONSTRAINT_NAME = 'OTA_BST_TDB_EXISTS') then
131: FND_MESSAGE.SET_NAME ('OTA', 'OTA_443818_NO_DEL_HAS_CHILD');
132: FND_MESSAGE.SET_TOKEN ('ENTITY_NAME', 'Delegate booking');
133: elsif p_constraint_name = 'OTA_BST_ACTIVE_DEFAULT' then
134: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13390_BST_ACTIVE_DEFAULT');
135: elsif p_constraint_name = 'OTA_BST_DUPLICATE_DEFAULT' then
136: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13391_BST_DUPLICATE_DEFAUL');

Line 134: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13390_BST_ACTIVE_DEFAULT');

130: elsif (P_CONSTRAINT_NAME = 'OTA_BST_TDB_EXISTS') then
131: FND_MESSAGE.SET_NAME ('OTA', 'OTA_443818_NO_DEL_HAS_CHILD');
132: FND_MESSAGE.SET_TOKEN ('ENTITY_NAME', 'Delegate booking');
133: elsif p_constraint_name = 'OTA_BST_ACTIVE_DEFAULT' then
134: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13390_BST_ACTIVE_DEFAULT');
135: elsif p_constraint_name = 'OTA_BST_DUPLICATE_DEFAULT' then
136: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13391_BST_DUPLICATE_DEFAUL');
137: --
138: -- Unknown !

Line 136: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13391_BST_DUPLICATE_DEFAUL');

132: FND_MESSAGE.SET_TOKEN ('ENTITY_NAME', 'Delegate booking');
133: elsif p_constraint_name = 'OTA_BST_ACTIVE_DEFAULT' then
134: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13390_BST_ACTIVE_DEFAULT');
135: elsif p_constraint_name = 'OTA_BST_DUPLICATE_DEFAULT' then
136: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13391_BST_DUPLICATE_DEFAUL');
137: --
138: -- Unknown !
139: --
140: else

Line 141: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13259_GEN_UNKN_CONSTRAINT');

137: --
138: -- Unknown !
139: --
140: else
141: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13259_GEN_UNKN_CONSTRAINT');
142: FND_MESSAGE.SET_TOKEN ('PROCEDURE', W_PROC);
143: FND_MESSAGE.SET_TOKEN ('CONSTRAINT', P_CONSTRAINT_NAME);
144: end if;
145: FND_MESSAGE.RAISE_ERROR;

Line 142: FND_MESSAGE.SET_TOKEN ('PROCEDURE', W_PROC);

138: -- Unknown !
139: --
140: else
141: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13259_GEN_UNKN_CONSTRAINT');
142: FND_MESSAGE.SET_TOKEN ('PROCEDURE', W_PROC);
143: FND_MESSAGE.SET_TOKEN ('CONSTRAINT', P_CONSTRAINT_NAME);
144: end if;
145: FND_MESSAGE.RAISE_ERROR;
146: --

Line 143: FND_MESSAGE.SET_TOKEN ('CONSTRAINT', P_CONSTRAINT_NAME);

139: --
140: else
141: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13259_GEN_UNKN_CONSTRAINT');
142: FND_MESSAGE.SET_TOKEN ('PROCEDURE', W_PROC);
143: FND_MESSAGE.SET_TOKEN ('CONSTRAINT', P_CONSTRAINT_NAME);
144: end if;
145: FND_MESSAGE.RAISE_ERROR;
146: --
147: HR_UTILITY.SET_LOCATION (' Leaving:' || W_PROC, 10);

Line 145: FND_MESSAGE.RAISE_ERROR;

141: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13259_GEN_UNKN_CONSTRAINT');
142: FND_MESSAGE.SET_TOKEN ('PROCEDURE', W_PROC);
143: FND_MESSAGE.SET_TOKEN ('CONSTRAINT', P_CONSTRAINT_NAME);
144: end if;
145: FND_MESSAGE.RAISE_ERROR;
146: --
147: HR_UTILITY.SET_LOCATION (' Leaving:' || W_PROC, 10);
148: --
149: end CONSTRAINT_ERROR;

Line 523: fnd_message.set_name('OTA','OTA_443877_BST_DELETE_CHK');

519: fetch C1
520: into W_OK;
521: if (C1%found) then
522: close C1;
523: fnd_message.set_name('OTA','OTA_443877_BST_DELETE_CHK');
524: fnd_message.raise_error;
525: end if;
526: close C1;
527: --

Line 524: fnd_message.raise_error;

520: into W_OK;
521: if (C1%found) then
522: close C1;
523: fnd_message.set_name('OTA','OTA_443877_BST_DELETE_CHK');
524: fnd_message.raise_error;
525: end if;
526: close C1;
527: --
528: HR_UTILITY.SET_LOCATION (' Leaving: ' || W_PROCEDURE, 10);

Line 651: FND_MESSAGE.SET_NAME('OTA', 'HR_7220_INVALID_PRIMARY_KEY');

647: Close C_Sel1;
648: --
649: -- The primary key is invalid therefore we must error
650: --
651: FND_MESSAGE.SET_NAME('OTA', 'HR_7220_INVALID_PRIMARY_KEY');
652: HR_UTILITY.raise_error;
653: End If;
654: Close C_Sel1;
655: If (p_object_version_number <> g_old_rec.object_version_number) Then

Line 656: FND_MESSAGE.SET_NAME('OTA', 'HR_7155_OBJECT_INVALID');

652: HR_UTILITY.raise_error;
653: End If;
654: Close C_Sel1;
655: If (p_object_version_number <> g_old_rec.object_version_number) Then
656: FND_MESSAGE.SET_NAME('OTA', 'HR_7155_OBJECT_INVALID');
657: HR_UTILITY.raise_error;
658: End If;
659: HR_UTILITY.SET_LOCATION(W_PROC, 15);
660: l_fct_ret := true;

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

712: close csr_sec_grp;
713: --
714: -- The primary key is invalid therefore we must error
715: --
716: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
717: hr_multi_message.add
718: (p_associated_column1
719: => nvl(p_associated_column1,'BOOKING_STATUS_TYPE_ID')
720: );

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

793: --
794: -- The primary key is invalid therefore we must error
795: --
796: close csr_leg_code;
797: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
798: fnd_message.raise_error;
799: end if;
800: hr_utility.set_location(l_proc,30);
801: --

Line 798: fnd_message.raise_error;

794: -- The primary key is invalid therefore we must error
795: --
796: close csr_leg_code;
797: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
798: fnd_message.raise_error;
799: end if;
800: hr_utility.set_location(l_proc,30);
801: --
802: -- Set the global variables so the values are

Line 1468: FND_MESSAGE.SET_NAME('OTA', 'HR_7220_INVALID_PRIMARY_KEY');

1464: Close C_Sel1;
1465: --
1466: -- The primary key is invalid therefore we must error
1467: --
1468: FND_MESSAGE.SET_NAME('OTA', 'HR_7220_INVALID_PRIMARY_KEY');
1469: HR_UTILITY.raise_error;
1470: End If;
1471: Close C_Sel1;
1472: If (p_object_version_number <> g_old_rec.object_version_number) Then

Line 1473: FND_MESSAGE.SET_NAME('OTA', 'HR_7155_OBJECT_INVALID');

1469: HR_UTILITY.raise_error;
1470: End If;
1471: Close C_Sel1;
1472: If (p_object_version_number <> g_old_rec.object_version_number) Then
1473: FND_MESSAGE.SET_NAME('OTA', 'HR_7155_OBJECT_INVALID');
1474: HR_UTILITY.raise_error;
1475: End If;
1476: --
1477: HR_UTILITY.SET_LOCATION(' Leaving:'||W_PROC, 10);

Line 1487: FND_MESSAGE.SET_NAME('OTA', 'HR_7165_OBJECT_LOCKED');

1483: --
1484: -- The object is locked therefore we need to supply a meaningful
1485: -- error message.
1486: --
1487: FND_MESSAGE.SET_NAME('OTA', 'HR_7165_OBJECT_LOCKED');
1488: FND_MESSAGE.SET_TOKEN('TABLE_NAME', 'ota_booking_status_types');
1489: HR_UTILITY.raise_error;
1490: End lck;
1491: --

Line 1488: FND_MESSAGE.SET_TOKEN('TABLE_NAME', 'ota_booking_status_types');

1484: -- The object is locked therefore we need to supply a meaningful
1485: -- error message.
1486: --
1487: FND_MESSAGE.SET_NAME('OTA', 'HR_7165_OBJECT_LOCKED');
1488: FND_MESSAGE.SET_TOKEN('TABLE_NAME', 'ota_booking_status_types');
1489: HR_UTILITY.raise_error;
1490: End lck;
1491: --
1492: -- ----------------------------------------------------------------------------