DBA Data[Home] [Help]

APPS.ICX_RELATED_CATEGORIES_PUB dependencies on FND_MESSAGE

Line 100: FND_MESSAGE.SET_NAME('ICX','ICX_API_MISS_PARAM');

96: p_related_category is null) then
97:
98: if FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) then
99: -- add message: Required API parameters are missing
100: FND_MESSAGE.SET_NAME('ICX','ICX_API_MISS_PARAM');
101: FND_MSG_PUB.Add;
102: end if;
103: RAISE FND_API.G_EXC_ERROR;
104: end if;

Line 125: FND_MESSAGE.SET_NAME('ICX','ICX_INVALID_ENTRY');

121: close l_category_set_csr;
122: if l_count <> 1 then
123: if FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) then
124: -- add message: Category Set is invalid
125: FND_MESSAGE.SET_NAME('ICX','ICX_INVALID_ENTRY');
126: FND_MESSAGE.SET_TOKEN('INVALID_TOKEN',l_prompts(2));
127: FND_MSG_PUB.Add;
128: end if;
129: l_id_resolve_error := TRUE;

Line 126: FND_MESSAGE.SET_TOKEN('INVALID_TOKEN',l_prompts(2));

122: if l_count <> 1 then
123: if FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) then
124: -- add message: Category Set is invalid
125: FND_MESSAGE.SET_NAME('ICX','ICX_INVALID_ENTRY');
126: FND_MESSAGE.SET_TOKEN('INVALID_TOKEN',l_prompts(2));
127: FND_MSG_PUB.Add;
128: end if;
129: l_id_resolve_error := TRUE;
130: end if;

Line 149: FND_MESSAGE.SET_NAME('ICX','ICX_INVALID_ENTRY');

145: close l_category_csr;
146: if l_count = 0 then
147: if FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) then
148: -- add message: Category is invalid
149: FND_MESSAGE.SET_NAME('ICX','ICX_INVALID_ENTRY');
150: FND_MESSAGE.SET_TOKEN('INVALID_TOKEN',l_prompts(4));
151: FND_MSG_PUB.Add;
152: end if;
153: l_id_resolve_error := TRUE;

Line 150: FND_MESSAGE.SET_TOKEN('INVALID_TOKEN',l_prompts(4));

146: if l_count = 0 then
147: if FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) then
148: -- add message: Category is invalid
149: FND_MESSAGE.SET_NAME('ICX','ICX_INVALID_ENTRY');
150: FND_MESSAGE.SET_TOKEN('INVALID_TOKEN',l_prompts(4));
151: FND_MSG_PUB.Add;
152: end if;
153: l_id_resolve_error := TRUE;
154: end if;

Line 173: FND_MESSAGE.SET_NAME('ICX','ICX_INVALID_ENTRY');

169: close l_category_csr;
170: if l_count = 0 then
171: if FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) then
172: -- add message: Related Category is invalid
173: FND_MESSAGE.SET_NAME('ICX','ICX_INVALID_ENTRY');
174: FND_MESSAGE.SET_TOKEN('INVALID_TOKEN',l_prompts(7));
175: FND_MSG_PUB.Add;
176: end if;
177: l_id_resolve_error := TRUE;

Line 174: FND_MESSAGE.SET_TOKEN('INVALID_TOKEN',l_prompts(7));

170: if l_count = 0 then
171: if FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) then
172: -- add message: Related Category is invalid
173: FND_MESSAGE.SET_NAME('ICX','ICX_INVALID_ENTRY');
174: FND_MESSAGE.SET_TOKEN('INVALID_TOKEN',l_prompts(7));
175: FND_MSG_PUB.Add;
176: end if;
177: l_id_resolve_error := TRUE;
178: end if;

Line 201: FND_MESSAGE.SET_NAME('ICX','ICX_INVALID_ENTRY');

197:
198: if l_count <> 1 then
199: if FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) then
200: -- add message: Category Set ID is invalid
201: FND_MESSAGE.SET_NAME('ICX','ICX_INVALID_ENTRY');
202: FND_MESSAGE.SET_TOKEN('INVALID_TOKEN',l_prompts(1));
203: FND_MSG_PUB.Add;
204: end if;
205: l_validation_error := TRUE;

Line 202: FND_MESSAGE.SET_TOKEN('INVALID_TOKEN',l_prompts(1));

198: if l_count <> 1 then
199: if FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) then
200: -- add message: Category Set ID is invalid
201: FND_MESSAGE.SET_NAME('ICX','ICX_INVALID_ENTRY');
202: FND_MESSAGE.SET_TOKEN('INVALID_TOKEN',l_prompts(1));
203: FND_MSG_PUB.Add;
204: end if;
205: l_validation_error := TRUE;
206: end if;

Line 228: FND_MESSAGE.SET_NAME('ICX','ICX_INVALID_ENTRY');

224:
225: if l_count = 0 then
226: if FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) then
227: -- add message: Category ID is invalid
228: FND_MESSAGE.SET_NAME('ICX','ICX_INVALID_ENTRY');
229: FND_MESSAGE.SET_TOKEN('INVALID_TOKEN',l_prompts(3));
230: FND_MSG_PUB.Add;
231: end if;
232: l_validation_error := TRUE;

Line 229: FND_MESSAGE.SET_TOKEN('INVALID_TOKEN',l_prompts(3));

225: if l_count = 0 then
226: if FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) then
227: -- add message: Category ID is invalid
228: FND_MESSAGE.SET_NAME('ICX','ICX_INVALID_ENTRY');
229: FND_MESSAGE.SET_TOKEN('INVALID_TOKEN',l_prompts(3));
230: FND_MSG_PUB.Add;
231: end if;
232: l_validation_error := TRUE;
233: end if;

Line 255: FND_MESSAGE.SET_NAME('ICX','ICX_INVALID_ENTRY');

251:
252: if l_count = 0 then
253: if FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) then
254: -- add message: Related Category ID is invalid
255: FND_MESSAGE.SET_NAME('ICX','ICX_INVALID_ENTRY');
256: FND_MESSAGE.SET_TOKEN('INVALID_TOKEN',l_prompts(6));
257: FND_MSG_PUB.Add;
258: end if;
259: l_validation_error := TRUE;

Line 256: FND_MESSAGE.SET_TOKEN('INVALID_TOKEN',l_prompts(6));

252: if l_count = 0 then
253: if FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) then
254: -- add message: Related Category ID is invalid
255: FND_MESSAGE.SET_NAME('ICX','ICX_INVALID_ENTRY');
256: FND_MESSAGE.SET_TOKEN('INVALID_TOKEN',l_prompts(6));
257: FND_MSG_PUB.Add;
258: end if;
259: l_validation_error := TRUE;
260: end if;

Line 270: FND_MESSAGE.SET_NAME('ICX','ICX_CAT_PARENT');

266: l_category_id = l_related_category_id) then
267: if FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) then
268: -- add message: Related Category may not be the same as
269: -- its parent category
270: FND_MESSAGE.SET_NAME('ICX','ICX_CAT_PARENT');
271: FND_MSG_PUB.Add;
272: end if;
273: l_validation_error := TRUE;
274: end if;

Line 288: FND_MESSAGE.SET_NAME('ICX','ICX_CAT_TOP');

284:
285: if l_count > 0 then
286: if FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) then
287: -- add message: CATEGORY is already a top category
288: FND_MESSAGE.SET_NAME('ICX','ICX_CAT_TOP');
289: if p_category is not null then
290: FND_MESSAGE.SET_TOKEN('CATEGORY',p_category);
291: else
292: FND_MESSAGE.SET_TOKEN('CATEGORY',l_category_id);

Line 290: FND_MESSAGE.SET_TOKEN('CATEGORY',p_category);

286: if FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) then
287: -- add message: CATEGORY is already a top category
288: FND_MESSAGE.SET_NAME('ICX','ICX_CAT_TOP');
289: if p_category is not null then
290: FND_MESSAGE.SET_TOKEN('CATEGORY',p_category);
291: else
292: FND_MESSAGE.SET_TOKEN('CATEGORY',l_category_id);
293: end if;
294: FND_MSG_PUB.Add;

Line 292: FND_MESSAGE.SET_TOKEN('CATEGORY',l_category_id);

288: FND_MESSAGE.SET_NAME('ICX','ICX_CAT_TOP');
289: if p_category is not null then
290: FND_MESSAGE.SET_TOKEN('CATEGORY',p_category);
291: else
292: FND_MESSAGE.SET_TOKEN('CATEGORY',l_category_id);
293: end if;
294: FND_MSG_PUB.Add;
295: end if;
296: l_validation_error := TRUE;

Line 312: FND_MESSAGE.SET_NAME('ICX','ICX_CAT_DUP_RELATION');

308:
309: if l_count > 0 then
310: if FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) then
311: -- add message: This category relationship already exists
312: FND_MESSAGE.SET_NAME('ICX','ICX_CAT_DUP_RELATION');
313: FND_MSG_PUB.Add;
314: end if;
315: l_validation_error := TRUE;
316: end if;

Line 330: FND_MESSAGE.SET_NAME('ICX','ICX_INVALID_ENTRY');

326:
327: if l_count <> 1 then
328: if FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) then
329: -- add message: Relation is not valid
330: FND_MESSAGE.SET_NAME('ICX','ICX_INVALID_ENTRY');
331: FND_MESSAGE.SET_TOKEN('INVALID_TOKEN',l_prompts(5));
332: FND_MSG_PUB.Add;
333: end if;
334: l_validation_error := TRUE;

Line 331: FND_MESSAGE.SET_TOKEN('INVALID_TOKEN',l_prompts(5));

327: if l_count <> 1 then
328: if FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) then
329: -- add message: Relation is not valid
330: FND_MESSAGE.SET_NAME('ICX','ICX_INVALID_ENTRY');
331: FND_MESSAGE.SET_TOKEN('INVALID_TOKEN',l_prompts(5));
332: FND_MSG_PUB.Add;
333: end if;
334: l_validation_error := TRUE;
335: end if;

Line 535: FND_MESSAGE.SET_NAME('ICX','ICX_API_MISS_PARAM');

531: p_related_category is null) then
532:
533: if FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) then
534: -- add message: Required API parameters are missing
535: FND_MESSAGE.SET_NAME('ICX','ICX_API_MISS_PARAM');
536: FND_MSG_PUB.Add;
537: end if;
538: RAISE FND_API.G_EXC_ERROR;
539: end if;

Line 560: FND_MESSAGE.SET_NAME('ICX','ICX_INVALID_ENTRY');

556: close l_category_set_csr;
557: if l_count <> 1 then
558: if FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) then
559: -- add message: Category Set is invalid
560: FND_MESSAGE.SET_NAME('ICX','ICX_INVALID_ENTRY');
561: FND_MESSAGE.SET_TOKEN('INVALID_TOKEN',l_prompts(2));
562: FND_MSG_PUB.Add;
563: end if;
564: l_id_resolve_error := TRUE;

Line 561: FND_MESSAGE.SET_TOKEN('INVALID_TOKEN',l_prompts(2));

557: if l_count <> 1 then
558: if FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) then
559: -- add message: Category Set is invalid
560: FND_MESSAGE.SET_NAME('ICX','ICX_INVALID_ENTRY');
561: FND_MESSAGE.SET_TOKEN('INVALID_TOKEN',l_prompts(2));
562: FND_MSG_PUB.Add;
563: end if;
564: l_id_resolve_error := TRUE;
565: end if;

Line 584: FND_MESSAGE.SET_NAME('ICX','ICX_INVALID_ENTRY');

580: close l_category_csr;
581: if l_count <> 1 then
582: if FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) then
583: -- add message: Category is invalid
584: FND_MESSAGE.SET_NAME('ICX','ICX_INVALID_ENTRY');
585: FND_MESSAGE.SET_TOKEN('INVALID_TOKEN',l_prompts(4));
586: FND_MSG_PUB.Add;
587: end if;
588: l_id_resolve_error := TRUE;

Line 585: FND_MESSAGE.SET_TOKEN('INVALID_TOKEN',l_prompts(4));

581: if l_count <> 1 then
582: if FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) then
583: -- add message: Category is invalid
584: FND_MESSAGE.SET_NAME('ICX','ICX_INVALID_ENTRY');
585: FND_MESSAGE.SET_TOKEN('INVALID_TOKEN',l_prompts(4));
586: FND_MSG_PUB.Add;
587: end if;
588: l_id_resolve_error := TRUE;
589: end if;

Line 608: FND_MESSAGE.SET_NAME('ICX','ICX_INVALID_ENTRY');

604: close l_category_csr;
605: if l_count <> 1 then
606: if FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) then
607: -- add message: Related Category is invalid
608: FND_MESSAGE.SET_NAME('ICX','ICX_INVALID_ENTRY');
609: FND_MESSAGE.SET_TOKEN('INVALID_TOKEN',l_prompts(7));
610: FND_MSG_PUB.Add;
611: end if;
612: l_id_resolve_error := TRUE;

Line 609: FND_MESSAGE.SET_TOKEN('INVALID_TOKEN',l_prompts(7));

605: if l_count <> 1 then
606: if FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) then
607: -- add message: Related Category is invalid
608: FND_MESSAGE.SET_NAME('ICX','ICX_INVALID_ENTRY');
609: FND_MESSAGE.SET_TOKEN('INVALID_TOKEN',l_prompts(7));
610: FND_MSG_PUB.Add;
611: end if;
612: l_id_resolve_error := TRUE;
613: end if;

Line 664: FND_MESSAGE.SET_NAME('ICX','ICX_CAT_DELETE');

660: p_return_status := FND_API.G_RET_STS_ERROR;
661:
662: if FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) then
663: -- add message: Relation to delete does not exist
664: FND_MESSAGE.SET_NAME('ICX','ICX_CAT_DELETE');
665: FND_MSG_PUB.Add;
666: end if;
667:
668: -- Get message count and if 1, return message data