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.ICX_RELATED_CATEGORIES_PUB dependencies on FND_MSG_PUB

Line 76: FND_MSG_PUB.initialize;

72:
73: -- Initialize message list if p_init_msg_list is set to TRUE
74:
75: IF FND_API.to_Boolean(p_init_msg_list) THEN
76: FND_MSG_PUB.initialize;
77: END IF;
78:
79:
80: -- Initialize p_return_status

Line 98: if FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) then

94: p_category is null) or
95: (p_related_category_id is null and
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;

Line 101: FND_MSG_PUB.Add;

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;
105:

Line 123: if FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) then

119: l_count := l_count + 1;
120: end loop;
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;

Line 127: FND_MSG_PUB.Add;

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;
131: end if; -- resolve category set id

Line 147: if FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) then

143: l_count := l_count + 1;
144: end loop;
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;

Line 151: FND_MSG_PUB.Add;

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;
155: end if; -- resolve category id

Line 171: if FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) then

167: l_count := l_count + 1;
168: end loop;
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;

Line 175: FND_MSG_PUB.Add;

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;
179: end if; -- resolve related category id

Line 199: if FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) then

195: from mtl_category_sets
196: where category_set_id = l_category_set_id;
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;

Line 203: FND_MSG_PUB.Add;

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;
207: end if; -- check category set id

Line 226: if FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) then

222: mcs.structure_id = mck.structure_id and
223: mck.category_id = l_category_id);
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;

Line 230: FND_MSG_PUB.Add;

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;
234: end if; -- check category id

Line 253: if FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) then

249: mcs.structure_id = mck.structure_id and
250: mck.category_id = l_related_category_id);
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;

Line 257: FND_MSG_PUB.Add;

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;
261: end if; -- check related category id

Line 267: if FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) then

263:
264: -- check that category id and related category id are not the same
265: if (p_relationship_type <> 'TOP' and
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;

Line 271: FND_MSG_PUB.Add;

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;
275:

Line 286: if FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) then

282: and category_id = l_category_id
283: and related_category_id = l_category_id;
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);

Line 294: FND_MSG_PUB.Add;

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;
297: end if;
298: end if;

Line 310: if FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) then

306: and category_id = l_category_id
307: and related_category_id = l_related_category_id;
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;

Line 313: FND_MSG_PUB.Add;

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;
317: end if;

Line 328: if FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) then

324: and enabled_flag = 'Y'
325: and lookup_code = p_relationship_type;
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;

Line 332: FND_MSG_PUB.Add;

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;
336:

Line 387: FND_MSG_PUB.Count_And_Get

383:
384:
385: -- Get message count and if 1, return message data
386:
387: FND_MSG_PUB.Count_And_Get
388: (p_count => p_msg_count,
389: p_data => p_msg_data
390: );
391:

Line 401: FND_MSG_PUB.Count_And_Get

397: p_return_status := FND_API.G_RET_STS_ERROR;
398:
399: -- Get message count and if 1, return message data
400:
401: FND_MSG_PUB.Count_And_Get
402: (p_count => p_msg_count,
403: p_data => p_msg_data
404: );
405:

Line 412: FND_MSG_PUB.Count_And_Get

408: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
409:
410: -- Get message count and if 1, return message data
411:
412: FND_MSG_PUB.Count_And_Get
413: (p_count => p_msg_count,
414: p_data => p_msg_data
415: );
416:

Line 421: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

417: WHEN OTHERS THEN
418:
419: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
420:
421: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
422: FND_MSG_PUB.Build_Exc_Msg
423: ( G_PKG_NAME ,
424: 'Insert_Relation'
425: );

Line 422: FND_MSG_PUB.Build_Exc_Msg

418:
419: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
420:
421: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
422: FND_MSG_PUB.Build_Exc_Msg
423: ( G_PKG_NAME ,
424: 'Insert_Relation'
425: );
426: END IF;

Line 430: FND_MSG_PUB.Count_And_Get

426: END IF;
427:
428: -- Get message count and if 1, return message data
429:
430: FND_MSG_PUB.Count_And_Get
431: (p_count => p_msg_count,
432: p_data => p_msg_data
433: );
434:

Line 509: FND_MSG_PUB.initialize;

505:
506: -- Initialize message list if p_init_msg_list is set to TRUE
507:
508: IF FND_API.to_Boolean(p_init_msg_list) THEN
509: FND_MSG_PUB.initialize;
510: END IF;
511:
512:
513: -- Initialize p_return_status

Line 533: if FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) then

529: p_category is null) or
530: (p_related_category_id is null and
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;

Line 536: FND_MSG_PUB.Add;

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;
540:

Line 558: if FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) then

554: l_count := l_count + 1;
555: end loop;
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;

Line 562: FND_MSG_PUB.Add;

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;
566: end if; -- resolve category set id

Line 582: if FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) then

578: l_count := l_count + 1;
579: end loop;
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;

Line 586: FND_MSG_PUB.Add;

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;
590: end if; -- resolve category id

Line 606: if FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) then

602: l_count := l_count + 1;
603: end loop;
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;

Line 610: FND_MSG_PUB.Add;

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;
614: end if; -- resolve related category id

Line 650: FND_MSG_PUB.Count_And_Get

646:
647:
648: -- Get message count and if 1, return message data
649:
650: FND_MSG_PUB.Count_And_Get
651: (p_count => p_msg_count,
652: p_data => p_msg_data
653: );
654:

Line 662: if FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) then

658: WHEN NO_DATA_FOUND THEN
659:
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;

Line 665: FND_MSG_PUB.Add;

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
669:

Line 670: FND_MSG_PUB.Count_And_Get

666: end if;
667:
668: -- Get message count and if 1, return message data
669:
670: FND_MSG_PUB.Count_And_Get
671: (p_count => p_msg_count,
672: p_data => p_msg_data
673: );
674:

Line 681: FND_MSG_PUB.Count_And_Get

677: p_return_status := FND_API.G_RET_STS_ERROR;
678:
679: -- Get message count and if 1, return message data
680:
681: FND_MSG_PUB.Count_And_Get
682: (p_count => p_msg_count,
683: p_data => p_msg_data
684: );
685:

Line 692: FND_MSG_PUB.Count_And_Get

688: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
689:
690: -- Get message count and if 1, return message data
691:
692: FND_MSG_PUB.Count_And_Get
693: (p_count => p_msg_count,
694: p_data => p_msg_data
695: );
696:

Line 701: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

697: WHEN OTHERS THEN
698:
699: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
700:
701: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
702: FND_MSG_PUB.Build_Exc_Msg
703: ( G_PKG_NAME ,
704: 'Delete_Relation'
705: );

Line 702: FND_MSG_PUB.Build_Exc_Msg

698:
699: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
700:
701: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
702: FND_MSG_PUB.Build_Exc_Msg
703: ( G_PKG_NAME ,
704: 'Delete_Relation'
705: );
706: END IF;

Line 710: FND_MSG_PUB.Count_And_Get

706: END IF;
707:
708: -- Get message count and if 1, return message data
709:
710: FND_MSG_PUB.Count_And_Get
711: (p_count => p_msg_count,
712: p_data => p_msg_data
713: );
714: