APPS.PSB_YEAR_TYPE_PVT dependencies on FND_MESSAGE

Line 60: FND_MESSAGE.Set_Name('PSB', 'PSB_DUP_YEAR_TYPE_SEQ');

56: AND ((p_year_type_id IS NULL ) OR
57: ( budget_year_type_id <> p_year_type_id)) ;
58: --
59: if l_seq_count > 0 then
60: FND_MESSAGE.Set_Name('PSB', 'PSB_DUP_YEAR_TYPE_SEQ');
61: FND_MSG_PUB.Add;
62: RAISE FND_API.G_EXC_ERROR;
63: end if;
64: --

Line 176: FND_MESSAGE.Set_name ('PSB', 'PSB_PY_GREATER_THAN_CY');

172: close ytp_csr ;
173: --
174: if p_year_type = 'PY' then
175: if p_year_type_seq > l_cy_min then
176: FND_MESSAGE.Set_name ('PSB', 'PSB_PY_GREATER_THAN_CY');
177: FND_MSG_PUB.Add;
178: RAISE FND_API.G_EXC_ERROR;
179: end if;
180: --

Line 182: FND_MESSAGE.Set_name ('PSB', 'PSB_PY_GREATER_THAN_PP');

178: RAISE FND_API.G_EXC_ERROR;
179: end if;
180: --
181: if p_year_type_seq > l_pp_min then
182: FND_MESSAGE.Set_name ('PSB', 'PSB_PY_GREATER_THAN_PP');
183: FND_MSG_PUB.Add;
184: RAISE FND_API.G_EXC_ERROR;
185: end if;
186: end if;

Line 191: FND_MESSAGE.Set_name ('PSB', 'PSB_PY_GREATER_THAN_CY');

187: --
188: --
189: if p_year_type = 'CY' then
190: if p_year_type_seq < l_py_max then
191: FND_MESSAGE.Set_name ('PSB', 'PSB_PY_GREATER_THAN_CY');
192: FND_MSG_PUB.Add;
193: RAISE FND_API.G_EXC_ERROR;
194: end if;
195: --

Line 197: FND_MESSAGE.Set_name ('PSB', 'PSB_CY_GREATER_THAN_PP');

193: RAISE FND_API.G_EXC_ERROR;
194: end if;
195: --
196: if p_year_type_seq > l_pp_min then
197: FND_MESSAGE.Set_name ('PSB', 'PSB_CY_GREATER_THAN_PP');
198: FND_MSG_PUB.Add;
199: RAISE FND_API.G_EXC_ERROR;
200: end if;
201: end if;

Line 206: FND_MESSAGE.Set_name ('PSB', 'PSB_CY_GREATER_THAN_PP');

202: --
203: --
204: if p_year_type = 'PP' then
205: if p_year_type_seq < l_cy_min then
206: FND_MESSAGE.Set_name ('PSB', 'PSB_CY_GREATER_THAN_PP');
207: FND_MSG_PUB.Add;
208: RAISE FND_API.G_EXC_ERROR;
209: end if;
210: --

Line 212: FND_MESSAGE.Set_name ('PSB', 'PSB_PY_GREATER_THAN_PP');

208: RAISE FND_API.G_EXC_ERROR;
209: end if;
210: --
211: if p_year_type_seq < l_py_max then
212: FND_MESSAGE.Set_name ('PSB', 'PSB_PY_GREATER_THAN_PP');
213: FND_MSG_PUB.Add;
214: RAISE FND_API.G_EXC_ERROR;
215: end if;
216: end if;

Line 320: FND_MESSAGE.Set_Name('PSB', 'PSB_DUP_CY_TYPE');

316: AND ((p_year_type_id IS NULL) OR
317: (budget_year_type_id <> p_year_type_id));
318: --
319: if l_cy_count > 0 then
320: FND_MESSAGE.Set_Name('PSB', 'PSB_DUP_CY_TYPE');
321: FND_MSG_PUB.Add;
322: RAISE FND_API.G_EXC_ERROR ;
323: end if;
324: -- End of API body.

Line 443: FND_MESSAGE.Set_Name('PSB', 'PSB_CANNOT_DELETE_YTP');

439: EXCEPTION
440:
441: when NO_DATA_FOUND then
442:
443: FND_MESSAGE.Set_Name('PSB', 'PSB_CANNOT_DELETE_YTP');
444: FND_MSG_PUB.Add;
445:
446: p_return_status := FND_API.G_RET_STS_ERROR;
447:

Line 542: FND_MESSAGE.Set_Name('PSB', 'PSB_DUPLICATE_NAME');

538: AND ((p_year_type_id IS NULL ) OR
539: ( budget_year_type_id <> p_year_type_id)) ;
540: --
541: if l_seq_count > 0 then
542: FND_MESSAGE.Set_Name('PSB', 'PSB_DUPLICATE_NAME');
543: FND_MSG_PUB.Add;
544: RAISE FND_API.G_EXC_ERROR;
545: end if;
546: --

Line 851: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

847: open c;
848: fetch c into recinfo;
849: if (c%notfound) then
850: close c;
851: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
852: app_exception.raise_exception;
853: end if;
854: close c;
855: if ( (recinfo.YEAR_CATEGORY_TYPE = p_YEAR_CATEGORY_TYPE)

Line 860: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');

856: AND (recinfo.SEQUENCE_NUMBER = p_SEQUENCE_NUMBER)
857: ) then
858: null;
859: else
860: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
861: app_exception.raise_exception;
862: end if;
863:
864: for tlinfo in c1 loop

Line 871: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');

867: AND (tlinfo.DESCRIPTION = p_DESCRIPTION)
868: ) then
869: null;
870: else
871: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
872: app_exception.raise_exception;
873: end if;
874: end if;
875: end loop;