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

Line 29: FND_MSG_PUB.initialize;

25:
26: BEGIN
27: -- Initialize message list if p_init_msg_list is set to TRUE.
28: IF FND_API.to_Boolean( p_init_msg_list ) THEN
29: FND_MSG_PUB.initialize;
30: END IF;
31: -- Initialize API return status to success
32: x_return_status := FND_API.G_RET_STS_SUCCESS;
33:

Line 38: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

34: OPEN Get_Citem;
35: FETCH Get_Citem INTO x_live_citem_version_id, l_content_item_status;
36: -- check if p_content_item_id is valid
37: IF Get_Citem%NOTFOUND THEN
38: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
39: FND_MESSAGE.Set_Name('IBC', 'INVALID_STYLESHEET_ITEM_ID');
40: FND_MESSAGE.Set_token('STYLESHEET_ITEM_ID', p_stylesheet_item_id);
41: FND_MSG_PUB.ADD;
42: END IF;

Line 41: FND_MSG_PUB.ADD;

37: IF Get_Citem%NOTFOUND THEN
38: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
39: FND_MESSAGE.Set_Name('IBC', 'INVALID_STYLESHEET_ITEM_ID');
40: FND_MESSAGE.Set_token('STYLESHEET_ITEM_ID', p_stylesheet_item_id);
41: FND_MSG_PUB.ADD;
42: END IF;
43: RAISE FND_API.G_EXC_ERROR;
44: END IF;
45: CLOSE Get_Citem;

Line 50: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

46:
47: -- check if content_item_status is APPROVED
48: IF (l_content_item_status IS NULL OR
49: l_content_item_status <> IBC_UTILITIES_PUB.G_STI_APPROVED) THEN
50: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
51: FND_MESSAGE.Set_Name('IBC', 'IBC_STYLESHEET_NOT_APPROVED');
52: FND_MESSAGE.Set_token('STYLESHEET_ITEM_ID', p_stylesheet_item_id);
53: FND_MSG_PUB.ADD;
54: END IF;

Line 53: FND_MSG_PUB.ADD;

49: l_content_item_status <> IBC_UTILITIES_PUB.G_STI_APPROVED) THEN
50: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
51: FND_MESSAGE.Set_Name('IBC', 'IBC_STYLESHEET_NOT_APPROVED');
52: FND_MESSAGE.Set_token('STYLESHEET_ITEM_ID', p_stylesheet_item_id);
53: FND_MSG_PUB.ADD;
54: END IF;
55: RAISE FND_API.G_EXC_ERROR;
56: END IF;
57:

Line 61: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

57:
58: EXCEPTION
59: WHEN FND_API.G_EXC_ERROR THEN
60: x_return_status := FND_API.G_RET_STS_ERROR;
61: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
62: p_data => x_msg_data);
63: END Validate_StyleSheetItem;
64:
65:

Line 84: FND_MSG_PUB.initialize;

80: where CITEM_VERSION_ID = p_stylesheet_version_id;
81: BEGIN
82: -- Initialize message list if p_init_msg_list is set to TRUE.
83: IF FND_API.to_Boolean( p_init_msg_list ) THEN
84: FND_MSG_PUB.initialize;
85: END IF;
86: -- Initialize API return status to success
87: x_return_status := FND_API.G_RET_STS_SUCCESS;
88:

Line 97: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

93: -- Check Profile if availabe date is enforced
94: IF (FND_PROFILE.Value('IBC_ENFORCE_AVAILABLE_DATE') IS NULL) OR
95: (FND_PROFILE.Value('IBC_ENFORCE_AVAILABLE_DATE') = 'Y') THEN
96: IF (NVL(l_start_date, SYSDATE) > SYSDATE) THEN
97: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
98: FND_MESSAGE.Set_Name('IBC', 'IBC_STYLESHEET_NOT_AVAILABLE');
99: FND_MESSAGE.Set_token('STYLESHEET_ITEM_ID', p_stylesheet_item_id);
100: FND_MESSAGE.Set_token('START_DATE', l_start_date);
101: FND_MSG_PUB.ADD;

Line 101: FND_MSG_PUB.ADD;

97: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
98: FND_MESSAGE.Set_Name('IBC', 'IBC_STYLESHEET_NOT_AVAILABLE');
99: FND_MESSAGE.Set_token('STYLESHEET_ITEM_ID', p_stylesheet_item_id);
100: FND_MESSAGE.Set_token('START_DATE', l_start_date);
101: FND_MSG_PUB.ADD;
102: END IF;
103: RAISE FND_API.G_EXC_ERROR;
104: END IF;
105: END IF;

Line 111: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

107: -- Check Profile if expiration date is enforced
108: IF (FND_PROFILE.Value('IBC_ENFORCE_EXPIRATION_DATE') IS NULL) OR
109: (FND_PROFILE.Value('IBC_ENFORCE_EXPIRATION_DATE') = 'Y') THEN
110: IF (NVL(l_end_date, SYSDATE) < SYSDATE) THEN
111: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
112: FND_MESSAGE.Set_Name('IBC', 'IBC_STYLESHEET_EXPIRED');
113: FND_MESSAGE.Set_token('STYLESHEET_ITEM_ID', p_stylesheet_item_id);
114: FND_MESSAGE.Set_token('END_DATE', l_end_date);
115: FND_MSG_PUB.ADD;

Line 115: FND_MSG_PUB.ADD;

111: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
112: FND_MESSAGE.Set_Name('IBC', 'IBC_STYLESHEET_EXPIRED');
113: FND_MESSAGE.Set_token('STYLESHEET_ITEM_ID', p_stylesheet_item_id);
114: FND_MESSAGE.Set_token('END_DATE', l_end_date);
115: FND_MSG_PUB.ADD;
116: END IF;
117: RAISE FND_API.G_EXC_ERROR;
118: END IF;
119: END IF;

Line 124: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

120:
121: EXCEPTION
122: WHEN FND_API.G_EXC_ERROR THEN
123: x_return_status := FND_API.G_RET_STS_ERROR;
124: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
125: p_data => x_msg_data);
126: END Validate_Start_End_Date;
127:
128:

Line 157: FND_MSG_PUB.initialize;

153:
154: BEGIN
155: -- Initialize message list if p_init_msg_list is set to TRUE.
156: IF FND_API.to_Boolean( p_init_msg_list ) THEN
157: FND_MSG_PUB.initialize;
158: END IF;
159: -- Initialize API return status to success
160: x_return_status := FND_API.G_RET_STS_SUCCESS;
161:

Line 186: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

182: -- Label doesn't exist for this content item id
183: IF (Get_Citem_Ver_By_Label%NOTFOUND) THEN
184: -- Validate Label
185: IF (Ibc_Validate_Pvt.isValidLabel(p_stylesheet_label_code) = FND_API.g_false) THEN
186: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
187: FND_MESSAGE.Set_Name('IBC', 'INVALID_LABEL_CODE');
188: FND_MESSAGE.Set_token('LABEL_CODE', p_stylesheet_label_code);
189: FND_MSG_PUB.ADD;
190: END IF;

Line 189: FND_MSG_PUB.ADD;

185: IF (Ibc_Validate_Pvt.isValidLabel(p_stylesheet_label_code) = FND_API.g_false) THEN
186: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
187: FND_MESSAGE.Set_Name('IBC', 'INVALID_LABEL_CODE');
188: FND_MESSAGE.Set_token('LABEL_CODE', p_stylesheet_label_code);
189: FND_MSG_PUB.ADD;
190: END IF;
191: RAISE FND_API.G_EXC_ERROR;
192: END IF;
193: x_stylesheet := NULL;

Line 220: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

216:
217: EXCEPTION
218: WHEN FND_API.G_EXC_ERROR THEN
219: x_return_status := FND_API.G_RET_STS_ERROR;
220: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
221: p_data => x_msg_data);
222: END Get_StyleSheet_Private;
223:
224:

Line 267: FND_MSG_PUB.initialize;

263: END IF;
264: -- Initialize message list if p_init_msg_list is set to TRUE.
265: IF FND_API.to_Boolean( p_init_msg_list )
266: THEN
267: FND_MSG_PUB.initialize;
268: END IF;
269:
270: -- Initialize API return status to success
271: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 296: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

292:
293: --******************* Real Logic End ***********************
294:
295: -- Standard call to get message count and if count=1, get the message
296: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
297: p_data => x_msg_data);
298: EXCEPTION
299: WHEN FND_API.G_EXC_ERROR THEN
300: x_return_status := FND_API.G_RET_STS_ERROR;

Line 301: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

297: p_data => x_msg_data);
298: EXCEPTION
299: WHEN FND_API.G_EXC_ERROR THEN
300: x_return_status := FND_API.G_RET_STS_ERROR;
301: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
302: p_data => x_msg_data);
303: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
305: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 305: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

301: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
302: p_data => x_msg_data);
303: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
305: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
306: p_data => x_msg_data);
307: WHEN OTHERS THEN
308: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
309: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 309: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

305: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
306: p_data => x_msg_data);
307: WHEN OTHERS THEN
308: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
309: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
310: THEN
311: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
312: END IF;
313: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 311: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

307: WHEN OTHERS THEN
308: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
309: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
310: THEN
311: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
312: END IF;
313: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
314: p_data => x_msg_data);
315: END Get_Approved_Default_StyleSht;

Line 313: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

309: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
310: THEN
311: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
312: END IF;
313: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
314: p_data => x_msg_data);
315: END Get_Approved_Default_StyleSht;
316:
317:

Line 355: FND_MSG_PUB.initialize;

351: END IF;
352: -- Initialize message list if p_init_msg_list is set to TRUE.
353: IF FND_API.to_Boolean( p_init_msg_list )
354: THEN
355: FND_MSG_PUB.initialize;
356: END IF;
357:
358: -- Initialize API return status to success
359: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 377: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

373:
374: EXCEPTION
375: WHEN FND_API.G_EXC_ERROR THEN
376: x_return_status := FND_API.G_RET_STS_ERROR;
377: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
378: p_data => x_msg_data);
379: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
380: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
381: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 381: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

377: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
378: p_data => x_msg_data);
379: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
380: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
381: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
382: p_data => x_msg_data);
383: WHEN OTHERS THEN
384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
385: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 385: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

381: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
382: p_data => x_msg_data);
383: WHEN OTHERS THEN
384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
385: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
386: THEN
387: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
388: END IF;
389: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 387: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

383: WHEN OTHERS THEN
384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
385: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
386: THEN
387: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
388: END IF;
389: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
390: p_data => x_msg_data);
391: END Get_Apprv_Default_StyleSht_Id;

Line 389: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

385: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
386: THEN
387: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
388: END IF;
389: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
390: p_data => x_msg_data);
391: END Get_Apprv_Default_StyleSht_Id;
392:
393:

Line 424: FND_MSG_PUB.initialize;

420: END IF;
421: -- Initialize message list if p_init_msg_list is set to TRUE.
422: IF FND_API.to_Boolean( p_init_msg_list )
423: THEN
424: FND_MSG_PUB.initialize;
425: END IF;
426:
427: -- Initialize API return status to success
428: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 444: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

440:
441: --******************* Real Logic End ***********************
442:
443: -- Standard call to get message count and if count=1, get the message
444: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
445: p_data => x_msg_data);
446: EXCEPTION
447: WHEN FND_API.G_EXC_ERROR THEN
448: x_return_status := FND_API.G_RET_STS_ERROR;

Line 449: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

445: p_data => x_msg_data);
446: EXCEPTION
447: WHEN FND_API.G_EXC_ERROR THEN
448: x_return_status := FND_API.G_RET_STS_ERROR;
449: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
450: p_data => x_msg_data);
451: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
452: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
453: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 453: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

449: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
450: p_data => x_msg_data);
451: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
452: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
453: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
454: p_data => x_msg_data);
455: WHEN OTHERS THEN
456: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
457: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 457: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

453: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
454: p_data => x_msg_data);
455: WHEN OTHERS THEN
456: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
457: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
458: THEN
459: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
460: END IF;
461: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 459: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

455: WHEN OTHERS THEN
456: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
457: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
458: THEN
459: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
460: END IF;
461: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
462: p_data => x_msg_data);
463: END Get_Approved_StyleSheet;

Line 461: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

457: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
458: THEN
459: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
460: END IF;
461: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
462: p_data => x_msg_data);
463: END Get_Approved_StyleSheet;
464:
465:

Line 502: FND_MSG_PUB.initialize;

498: END IF;
499: -- Initialize message list if p_init_msg_list is set to TRUE.
500: IF FND_API.to_Boolean( p_init_msg_list )
501: THEN
502: FND_MSG_PUB.initialize;
503: END IF;
504:
505: -- Initialize API return status to success
506: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 512: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

508:
509: OPEN Get_StyleSheet_Id;
510: FETCH Get_StyleSheet_Id INTO l_stylesheet_id;
511: IF Get_StyleSheet_Id%NOTFOUND THEN
512: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
513: FND_MESSAGE.Set_Name('IBC', 'IBC_STYLESHT_RC_NOT_FOUND');
514: FND_MESSAGE.Set_token('REF_CODE', p_stylesheet_ref_code);
515: FND_MSG_PUB.ADD;
516: END IF;

Line 515: FND_MSG_PUB.ADD;

511: IF Get_StyleSheet_Id%NOTFOUND THEN
512: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
513: FND_MESSAGE.Set_Name('IBC', 'IBC_STYLESHT_RC_NOT_FOUND');
514: FND_MESSAGE.Set_token('REF_CODE', p_stylesheet_ref_code);
515: FND_MSG_PUB.ADD;
516: END IF;
517: RAISE FND_API.G_EXC_ERROR;
518: END IF;
519: CLOSE Get_StyleSheet_Id;

Line 534: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

530:
531: --******************* Real Logic End ***********************
532:
533: -- Standard call to get message count and if count=1, get the message
534: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
535: p_data => x_msg_data);
536: EXCEPTION
537: WHEN FND_API.G_EXC_ERROR THEN
538: x_return_status := FND_API.G_RET_STS_ERROR;

Line 539: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

535: p_data => x_msg_data);
536: EXCEPTION
537: WHEN FND_API.G_EXC_ERROR THEN
538: x_return_status := FND_API.G_RET_STS_ERROR;
539: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
540: p_data => x_msg_data);
541: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
543: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 543: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

539: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
540: p_data => x_msg_data);
541: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
543: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
544: p_data => x_msg_data);
545: WHEN OTHERS THEN
546: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
547: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 547: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

543: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
544: p_data => x_msg_data);
545: WHEN OTHERS THEN
546: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
547: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
548: THEN
549: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
550: END IF;
551: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 549: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

545: WHEN OTHERS THEN
546: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
547: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
548: THEN
549: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
550: END IF;
551: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
552: p_data => x_msg_data);
553: END Get_Approved_StyleSht_RC;

Line 551: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

547: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
548: THEN
549: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
550: END IF;
551: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
552: p_data => x_msg_data);
553: END Get_Approved_StyleSht_RC;
554:
555:

Line 606: FND_MSG_PUB.initialize;

602: END IF;
603: -- Initialize message list if p_init_msg_list is set to TRUE.
604: IF FND_API.to_Boolean( p_init_msg_list )
605: THEN
606: FND_MSG_PUB.initialize;
607: END IF;
608:
609: -- Initialize API return status to success
610: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 620: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

616:
617: -- // Validate p_content_item_id
618: IF (Get_StyleSheet_Ids%NOTFOUND) THEN
619: IF (Ibc_Validate_Pvt.isValidCitem(p_content_item_id) = FND_API.g_false) THEN
620: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
621: FND_MESSAGE.Set_Name('IBC', 'INVALID_CITEM_ID');
622: FND_MESSAGE.Set_token('CITEM_ID', p_content_item_id);
623: FND_MSG_PUB.ADD;
624: END IF;

Line 623: FND_MSG_PUB.ADD;

619: IF (Ibc_Validate_Pvt.isValidCitem(p_content_item_id) = FND_API.g_false) THEN
620: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
621: FND_MESSAGE.Set_Name('IBC', 'INVALID_CITEM_ID');
622: FND_MESSAGE.Set_token('CITEM_ID', p_content_item_id);
623: FND_MSG_PUB.ADD;
624: END IF;
625: RAISE FND_API.G_EXC_ERROR;
626: END IF;
627: END IF;

Line 652: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

648:
649: -- // List of stylesheets returned is 0, validate Label Code
650: IF (x_stylesheet_item_ids.COUNT = 0) THEN
651: IF (Ibc_Validate_Pvt.isValidLabel(p_stylesheets_label_code) = FND_API.g_false) THEN
652: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
653: FND_MESSAGE.Set_Name('IBC', 'INVALID_LABEL_CODE');
654: FND_MESSAGE.Set_token('LABEL_CODE', p_stylesheets_label_code);
655: FND_MSG_PUB.ADD;
656: END IF;

Line 655: FND_MSG_PUB.ADD;

651: IF (Ibc_Validate_Pvt.isValidLabel(p_stylesheets_label_code) = FND_API.g_false) THEN
652: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
653: FND_MESSAGE.Set_Name('IBC', 'INVALID_LABEL_CODE');
654: FND_MESSAGE.Set_token('LABEL_CODE', p_stylesheets_label_code);
655: FND_MSG_PUB.ADD;
656: END IF;
657: RAISE FND_API.G_EXC_ERROR;
658: END IF;
659: END IF;

Line 663: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

659: END IF;
660: --******************* Real Logic End ***********************
661:
662: -- Standard call to get message count and if count=1, get the message
663: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
664: p_data => x_msg_data);
665: EXCEPTION
666: WHEN FND_API.G_EXC_ERROR THEN
667: x_return_status := FND_API.G_RET_STS_ERROR;

Line 668: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

664: p_data => x_msg_data);
665: EXCEPTION
666: WHEN FND_API.G_EXC_ERROR THEN
667: x_return_status := FND_API.G_RET_STS_ERROR;
668: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
669: p_data => x_msg_data);
670: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
671: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
672: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 672: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

668: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
669: p_data => x_msg_data);
670: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
671: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
672: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
673: p_data => x_msg_data);
674: WHEN OTHERS THEN
675: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
676: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 676: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

672: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
673: p_data => x_msg_data);
674: WHEN OTHERS THEN
675: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
676: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
677: THEN
678: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
679: END IF;
680: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 678: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

674: WHEN OTHERS THEN
675: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
676: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
677: THEN
678: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
679: END IF;
680: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
681: p_data => x_msg_data);
682: END Get_StyleSheet_Items;

Line 680: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

676: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
677: THEN
678: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
679: END IF;
680: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
681: p_data => x_msg_data);
682: END Get_StyleSheet_Items;
683:
684: