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

Line 44: FND_MSG_PUB.Add;

40: IF (c1%NOTFOUND) THEN
41: CLOSE c1;
42: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MSITE_ID_NOT_FOUND');
43: FND_MESSAGE.Set_Token('MSITE_ID', p_msite_id);
44: FND_MSG_PUB.Add;
45: RAISE FND_API.G_EXC_ERROR;
46: END IF;
47: CLOSE c1;
48:

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

49: EXCEPTION
50:
51: WHEN FND_API.G_EXC_ERROR THEN
52: x_return_status := FND_API.G_RET_STS_ERROR;
53: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
54: p_data => x_msg_data,
55: p_encoded => 'F');
56:
57: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

55: p_encoded => 'F');
56:
57: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
58: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
59: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
60: p_data => x_msg_data,
61: p_encoded => 'F');
62:
63: WHEN OTHERS THEN

Line 68: FND_MSG_PUB.Add;

64: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
65: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
66: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
67: FND_MESSAGE.Set_Token('REASON', SQLERRM);
68: FND_MSG_PUB.Add;
69:
70: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
71:
72: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

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

68: FND_MSG_PUB.Add;
69:
70: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
71:
72: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
73: THEN
74: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
75: END IF;
76:

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

70: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
71:
72: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
73: THEN
74: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
75: END IF;
76:
77: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
78: p_data => x_msg_data,

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

73: THEN
74: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
75: END IF;
76:
77: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
78: p_data => x_msg_data,
79: p_encoded => 'F');
80:
81: END Validate_Msite_Id_Exists;

Line 119: FND_MSG_PUB.Add;

115: IF (c1%NOTFOUND) THEN
116: CLOSE c1;
117: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_PM_CODE_NOT_EXISTS');
118: FND_MESSAGE.Set_Token('PAYMENT_METHOD_CODE', p_payment_method_code);
119: FND_MSG_PUB.Add;
120: RAISE FND_API.G_EXC_ERROR;
121: END IF;
122: CLOSE c1;
123:

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

124: EXCEPTION
125:
126: WHEN FND_API.G_EXC_ERROR THEN
127: x_return_status := FND_API.G_RET_STS_ERROR;
128: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
129: p_data => x_msg_data,
130: p_encoded => 'F');
131:
132: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

130: p_encoded => 'F');
131:
132: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
134: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
135: p_data => x_msg_data,
136: p_encoded => 'F');
137:
138: WHEN OTHERS THEN

Line 143: FND_MSG_PUB.Add;

139: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
140: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
141: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
142: FND_MESSAGE.Set_Token('REASON', SQLERRM);
143: FND_MSG_PUB.Add;
144:
145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
146:
147: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

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

143: FND_MSG_PUB.Add;
144:
145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
146:
147: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
148: THEN
149: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
150: END IF;
151:

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

145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
146:
147: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
148: THEN
149: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
150: END IF;
151:
152: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
153: p_data => x_msg_data,

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

148: THEN
149: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
150: END IF;
151:
152: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
153: p_data => x_msg_data,
154: p_encoded => 'F');
155:
156: END Validate_Payment_Method_Code;

Line 189: FND_MSG_PUB.Add;

185: IF (c1%NOTFOUND) THEN
186: CLOSE c1;
187: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_CC_CODE_NOT_EXISTS');
188: FND_MESSAGE.Set_Token('CREDIT_CARD_CODE', p_credit_card_code);
189: FND_MSG_PUB.Add;
190: RAISE FND_API.G_EXC_ERROR;
191: END IF;
192: CLOSE c1;
193:

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

194: EXCEPTION
195:
196: WHEN FND_API.G_EXC_ERROR THEN
197: x_return_status := FND_API.G_RET_STS_ERROR;
198: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
199: p_data => x_msg_data,
200: p_encoded => 'F');
201:
202: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

200: p_encoded => 'F');
201:
202: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
204: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
205: p_data => x_msg_data,
206: p_encoded => 'F');
207:
208: WHEN OTHERS THEN

Line 213: FND_MSG_PUB.Add;

209: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
210: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
211: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
212: FND_MESSAGE.Set_Token('REASON', SQLERRM);
213: FND_MSG_PUB.Add;
214:
215: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
216:
217: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

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

213: FND_MSG_PUB.Add;
214:
215: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
216:
217: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
218: THEN
219: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
220: END IF;
221:

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

215: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
216:
217: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
218: THEN
219: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
220: END IF;
221:
222: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
223: p_data => x_msg_data,

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

218: THEN
219: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
220: END IF;
221:
222: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
223: p_data => x_msg_data,
224: p_encoded => 'F');
225:
226: END Validate_Credit_Card_Code;

Line 264: FND_MSG_PUB.Add;

260: IF (c1%NOTFOUND) THEN
261: CLOSE c1;
262: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_SM_CODE_NOT_EXISTS');
263: FND_MESSAGE.Set_Token('SHIPMENT_METHOD_CODE', p_shipment_method_code);
264: FND_MSG_PUB.Add;
265: RAISE FND_API.G_EXC_ERROR;
266: END IF;
267: CLOSE c1;
268:

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

269: EXCEPTION
270:
271: WHEN FND_API.G_EXC_ERROR THEN
272: x_return_status := FND_API.G_RET_STS_ERROR;
273: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
274: p_data => x_msg_data,
275: p_encoded => 'F');
276:
277: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

275: p_encoded => 'F');
276:
277: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
278: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
279: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
280: p_data => x_msg_data,
281: p_encoded => 'F');
282:
283: WHEN OTHERS THEN

Line 288: FND_MSG_PUB.Add;

284: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
285: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
286: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
287: FND_MESSAGE.Set_Token('REASON', SQLERRM);
288: FND_MSG_PUB.Add;
289:
290: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
291:
292: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

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

288: FND_MSG_PUB.Add;
289:
290: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
291:
292: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
293: THEN
294: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
295: END IF;
296:

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

290: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
291:
292: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
293: THEN
294: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
295: END IF;
296:
297: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
298: p_data => x_msg_data,

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

293: THEN
294: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
295: END IF;
296:
297: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
298: p_data => x_msg_data,
299: p_encoded => 'F');
300:
301: END Validate_Shipment_Method_Code;

Line 379: FND_MSG_PUB.Add;

375: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_INFORMATION_DUP');
376: FND_MESSAGE.Set_Token('VALUE', p_msite_information1);
377: FND_MESSAGE.Set_Token('MSITE_ID', p_msite_id);
378: FND_MESSAGE.Set_Token('CONTEXT', p_msite_information_context);
379: FND_MSG_PUB.Add;
380: RAISE FND_API.G_EXC_ERROR;
381: END IF;
382: CLOSE c1;
383:

Line 395: FND_MSG_PUB.Add;

391: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_INFORMATION_DUP');
392: FND_MESSAGE.Set_Token('VALUE', p_msite_information1);
393: FND_MESSAGE.Set_Token('MSITE_ID', p_msite_id);
394: FND_MESSAGE.Set_Token('CONTEXT', p_msite_information_context);
395: FND_MSG_PUB.Add;
396: RAISE FND_API.G_EXC_ERROR;
397: END IF;
398: CLOSE c2;
399:

Line 411: FND_MSG_PUB.Add;

407: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_INFORMATION_DUP');
408: FND_MESSAGE.Set_Token('VALUE', p_msite_information1);
409: FND_MESSAGE.Set_Token('MSITE_ID', p_msite_id);
410: FND_MESSAGE.Set_Token('CONTEXT', p_msite_information_context);
411: FND_MSG_PUB.Add;
412: RAISE FND_API.G_EXC_ERROR;
413: END IF;
414: CLOSE c3;
415:

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

418: EXCEPTION
419:
420: WHEN FND_API.G_EXC_ERROR THEN
421: x_return_status := FND_API.G_RET_STS_SUCCESS; -- found duplicate
422: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
423: p_data => x_msg_data,
424: p_encoded => 'F');
425:
426: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

424: p_encoded => 'F');
425:
426: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
428: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
429: p_data => x_msg_data,
430: p_encoded => 'F');
431:
432: WHEN OTHERS THEN

Line 437: FND_MSG_PUB.Add;

433: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
434: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
435: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
436: FND_MESSAGE.Set_Token('REASON', SQLERRM);
437: FND_MSG_PUB.Add;
438:
439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
440:
441: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

437: FND_MSG_PUB.Add;
438:
439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
440:
441: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
442: THEN
443: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
444: END IF;
445:

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

439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
440:
441: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
442: THEN
443: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
444: END IF;
445:
446: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
447: p_data => x_msg_data,

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

442: THEN
443: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
444: END IF;
445:
446: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
447: p_data => x_msg_data,
448: p_encoded => 'F');
449:
450: END Check_Duplicate_Entry;

Line 507: FND_MSG_PUB.initialize;

503: BEGIN
504:
505: -- Initialize message list if p_init_msg_list is set to TRUE.
506: IF FND_API.to_Boolean(p_init_msg_list) THEN
507: FND_MSG_PUB.initialize;
508: END IF;
509:
510: -- Initialize API return status to success
511: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 521: FND_MSG_PUB.Add;

517: IF ((p_msite_id IS NULL) OR
518: (p_msite_id = FND_API.G_MISS_NUM))
519: THEN
520: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INVALID_MSITE_ID');
521: FND_MSG_PUB.Add;
522: RAISE FND_API.G_EXC_ERROR;
523: END IF;
524:
525: IF ((p_msite_information_context IS NULL) OR

Line 529: FND_MSG_PUB.Add;

525: IF ((p_msite_information_context IS NULL) OR
526: (p_msite_information_context = FND_API.G_MISS_CHAR))
527: THEN
528: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_INVALID_INFO_CTX');
529: FND_MSG_PUB.Add;
530: RAISE FND_API.G_EXC_ERROR;
531: END IF;
532: -- developer flex-fields
533: IF ((p_msite_information_context = 'PMT_MTHD') OR

Line 544: FND_MSG_PUB.Add;

540: THEN
541: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_INVALID_MSITE_INFO');
542: FND_MESSAGE.Set_Token('MSITE_ID', p_msite_id);
543: FND_MESSAGE.Set_Token('CONTEXT', p_msite_information_context);
544: FND_MSG_PUB.Add;
545: RAISE FND_API.G_EXC_ERROR;
546: END IF;
547:
548: END IF;

Line 570: FND_MSG_PUB.Add;

566:
567: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
568: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MSITE_ID_VLD_FAIL');
569: FND_MESSAGE.Set_Token('MSITE_ID', p_msite_id);
570: FND_MSG_PUB.Add;
571: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
572: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
573: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MSITE_ID_VLD_FAIL');
574: FND_MESSAGE.Set_Token('MSITE_ID', p_msite_id);

Line 575: FND_MSG_PUB.Add;

571: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
572: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
573: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MSITE_ID_VLD_FAIL');
574: FND_MESSAGE.Set_Token('MSITE_ID', p_msite_id);
575: FND_MSG_PUB.Add;
576: RAISE FND_API.G_EXC_ERROR; -- invalid msite_id
577: END IF;
578: -- developer flexfield
579: IF (p_msite_information_context = 'PMT_MTHD') THEN

Line 592: FND_MSG_PUB.Add;

588:
589: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
590: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_PM_VLD_FAIL');
591: FND_MESSAGE.Set_Token('PAYMENT_METHOD_CODE', p_msite_information1);
592: FND_MSG_PUB.Add;
593: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
594: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
595: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_PM_VLD_FAIL');
596: FND_MESSAGE.Set_Token('PAYMENT_METHOD_CODE', p_msite_information1);

Line 597: FND_MSG_PUB.Add;

593: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
594: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
595: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_PM_VLD_FAIL');
596: FND_MESSAGE.Set_Token('PAYMENT_METHOD_CODE', p_msite_information1);
597: FND_MSG_PUB.Add;
598: RAISE FND_API.G_EXC_ERROR;
599: END IF;
600: ELSIF (p_msite_information_context = 'CC_TYPE') THEN
601:

Line 613: FND_MSG_PUB.Add;

609:
610: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
611: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_CC_VLD_FAIL');
612: FND_MESSAGE.Set_Token('CREDIT_CARD_CODE', p_msite_information1);
613: FND_MSG_PUB.Add;
614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
615: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
616: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_CC_VLD_FAIL');
617: FND_MESSAGE.Set_Token('CREDIT_CARD_CODE', p_msite_information1);

Line 618: FND_MSG_PUB.Add;

614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
615: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
616: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_CC_VLD_FAIL');
617: FND_MESSAGE.Set_Token('CREDIT_CARD_CODE', p_msite_information1);
618: FND_MSG_PUB.Add;
619: RAISE FND_API.G_EXC_ERROR;
620: END IF;
621: ELSIF (p_msite_information_context = 'SHPMT_MTHD') THEN
622:

Line 634: FND_MSG_PUB.Add;

630:
631: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
632: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_SM_VLD_FAIL');
633: FND_MESSAGE.Set_Token('SHIPMENT_METHOD_CODE', p_msite_information1);
634: FND_MSG_PUB.Add;
635: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
636: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
637: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_SM_VLD_FAIL');
638: FND_MESSAGE.Set_Token('SHIPMENT_METHOD_CODE', p_msite_information1);

Line 639: FND_MSG_PUB.Add;

635: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
636: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
637: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_SM_VLD_FAIL');
638: FND_MESSAGE.Set_Token('SHIPMENT_METHOD_CODE', p_msite_information1);
639: FND_MSG_PUB.Add;
640: RAISE FND_API.G_EXC_ERROR;
641: END IF;
642:
643: END IF;

Line 678: FND_MSG_PUB.Add;

674: );
675:
676: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
677: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_INFO_UNEXP_DUP_CHECK');
678: FND_MSG_PUB.Add;
679: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
680: ELSIF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
681: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_DUPLICATE_MSITE_INFO');
682: FND_MESSAGE.Set_Token('MSITE_ID', p_msite_id);

Line 684: FND_MSG_PUB.Add;

680: ELSIF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
681: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_DUPLICATE_MSITE_INFO');
682: FND_MESSAGE.Set_Token('MSITE_ID', p_msite_id);
683: FND_MESSAGE.Set_Token('CONTEXT', p_msite_information_context);
684: FND_MSG_PUB.Add;
685: RAISE FND_API.G_EXC_ERROR; -- duplicate entry
686: END IF;
687: EXCEPTION
688:

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

687: EXCEPTION
688:
689: WHEN FND_API.G_EXC_ERROR THEN
690: x_return_status := FND_API.G_RET_STS_ERROR;
691: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
692: p_data => x_msg_data,
693: p_encoded => 'F');
694:
695: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

693: p_encoded => 'F');
694:
695: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
696: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
697: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
698: p_data => x_msg_data,
699: p_encoded => 'F');
700:
701: WHEN OTHERS THEN

Line 706: FND_MSG_PUB.Add;

702: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
703: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
704: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
705: FND_MESSAGE.Set_Token('REASON', SQLERRM);
706: FND_MSG_PUB.Add;
707:
708: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
709:
710: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

706: FND_MSG_PUB.Add;
707:
708: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
709:
710: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
711: THEN
712: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
713: END IF;
714:

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

708: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
709:
710: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
711: THEN
712: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
713: END IF;
714:
715: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
716: p_data => x_msg_data,

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

711: THEN
712: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
713: END IF;
714:
715: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
716: p_data => x_msg_data,
717: p_encoded => 'F');
718:
719: END Validate_Create;

Line 785: FND_MSG_PUB.initialize;

781: BEGIN
782:
783: -- Initialize message list if p_init_msg_list is set to TRUE.
784: IF FND_API.to_Boolean(p_init_msg_list) THEN
785: FND_MSG_PUB.initialize;
786: END IF;
787:
788: -- Initialize API return status to success
789: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 798: FND_MSG_PUB.Add;

794:
795: -- msite_information_id
796: IF (p_msite_information_id IS NULL) THEN
797: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MSINF_ID_IS_NULL');
798: FND_MSG_PUB.Add;
799: RAISE FND_API.G_EXC_ERROR;
800: END IF;
801:
802: -- object_version_number

Line 806: FND_MSG_PUB.Add;

802: -- object_version_number
803: IF (p_object_version_number IS NULL)
804: THEN
805: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_OVN_IS_NULL');
806: FND_MSG_PUB.Add;
807: RAISE FND_API.G_EXC_ERROR;
808: END IF;
809:
810: --

Line 821: FND_MSG_PUB.Add;

817: IF (c1%NOTFOUND) THEN
818: CLOSE c1;
819: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_INFO_ID_NOT_FOUND');
820: FND_MESSAGE.Set_Token('MSITE_INFO_ID', p_msite_information_id);
821: FND_MSG_PUB.Add;
822: RAISE FND_API.G_EXC_ERROR;
823: END IF;
824: CLOSE c1;
825:

Line 838: FND_MSG_PUB.Add;

834: THEN
835: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_INVALID_MSITE_INFO');
836: FND_MESSAGE.Set_Token('MSITE_ID', l_msite_id);
837: FND_MESSAGE.Set_Token('CONTEXT', l_msite_information_context);
838: FND_MSG_PUB.Add;
839: RAISE FND_API.G_EXC_ERROR;
840: END IF;
841:
842: END IF;

Line 858: FND_MSG_PUB.Add;

854:
855: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
856: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_PM_VLD_FAIL');
857: FND_MESSAGE.Set_Token('PAYMENT_METHOD_CODE', p_msite_information1);
858: FND_MSG_PUB.Add;
859: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
860: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
861: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_PM_VLD_FAIL');
862: FND_MESSAGE.Set_Token('PAYMENT_METHOD_CODE', p_msite_information1);

Line 863: FND_MSG_PUB.Add;

859: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
860: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
861: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_PM_VLD_FAIL');
862: FND_MESSAGE.Set_Token('PAYMENT_METHOD_CODE', p_msite_information1);
863: FND_MSG_PUB.Add;
864: RAISE FND_API.G_EXC_ERROR;
865: END IF;
866:
867: ELSIF (l_msite_information_context = 'CC_TYPE') THEN

Line 880: FND_MSG_PUB.Add;

876:
877: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
878: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_CC_VLD_FAIL');
879: FND_MESSAGE.Set_Token('CREDIT_CARD_CODE', p_msite_information1);
880: FND_MSG_PUB.Add;
881: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
882: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
883: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_CC_VLD_FAIL');
884: FND_MESSAGE.Set_Token('CREDIT_CARD_CODE', p_msite_information1);

Line 885: FND_MSG_PUB.Add;

881: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
882: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
883: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_CC_VLD_FAIL');
884: FND_MESSAGE.Set_Token('CREDIT_CARD_CODE', p_msite_information1);
885: FND_MSG_PUB.Add;
886: RAISE FND_API.G_EXC_ERROR;
887: END IF;
888:
889: ELSIF (l_msite_information_context = 'SHPMT_MTHD') THEN

Line 902: FND_MSG_PUB.Add;

898:
899: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
900: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_SM_VLD_FAIL');
901: FND_MESSAGE.Set_Token('SHIPMENT_METHOD_CODE', p_msite_information1);
902: FND_MSG_PUB.Add;
903: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
904: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
905: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_SM_VLD_FAIL');
906: FND_MESSAGE.Set_Token('SHIPMENT_METHOD_CODE', p_msite_information1);

Line 907: FND_MSG_PUB.Add;

903: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
904: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
905: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_SM_VLD_FAIL');
906: FND_MESSAGE.Set_Token('SHIPMENT_METHOD_CODE', p_msite_information1);
907: FND_MSG_PUB.Add;
908: RAISE FND_API.G_EXC_ERROR;
909: END IF;
910:
911: END IF;

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

913: EXCEPTION
914:
915: WHEN FND_API.G_EXC_ERROR THEN
916: x_return_status := FND_API.G_RET_STS_ERROR;
917: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
918: p_data => x_msg_data,
919: p_encoded => 'F');
920:
921: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

919: p_encoded => 'F');
920:
921: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
922: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
923: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
924: p_data => x_msg_data,
925: p_encoded => 'F');
926:
927: WHEN OTHERS THEN

Line 932: FND_MSG_PUB.Add;

928: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
929: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
930: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
931: FND_MESSAGE.Set_Token('REASON', SQLERRM);
932: FND_MSG_PUB.Add;
933:
934: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
935:
936: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

932: FND_MSG_PUB.Add;
933:
934: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
935:
936: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
937: THEN
938: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
939: END IF;
940:

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

934: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
935:
936: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
937: THEN
938: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
939: END IF;
940:
941: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
942: p_data => x_msg_data,

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

937: THEN
938: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
939: END IF;
940:
941: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
942: p_data => x_msg_data,
943: p_encoded => 'F');
944:
945: END Validate_Update;

Line 1020: FND_MSG_PUB.initialize;

1016: END IF;
1017:
1018: -- Initialize message list if p_init_msg_list is set to TRUE.
1019: IF FND_API.to_Boolean(p_init_msg_list) THEN
1020: FND_MSG_PUB.initialize;
1021: END IF;
1022: -- Initialize API return status to success
1023: x_return_status := FND_API.G_RET_STS_SUCCESS;
1024:

Line 1082: FND_MSG_PUB.Add;

1078: x_msg_data => x_msg_data
1079: );
1080: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1081: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_INFO_INVALID_CREATE');
1082: FND_MSG_PUB.Add;
1083: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1084: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1085: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_INFO_INVALID_CREATE');
1086: FND_MSG_PUB.Add;

Line 1086: FND_MSG_PUB.Add;

1082: FND_MSG_PUB.Add;
1083: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1084: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1085: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_INFO_INVALID_CREATE');
1086: FND_MSG_PUB.Add;
1087: RAISE FND_API.G_EXC_ERROR; -- invalid
1088: END IF;
1089: --
1090: -- 2. Insert row

Line 1147: FND_MSG_PUB.Add;

1143:
1144: EXCEPTION
1145: WHEN NO_DATA_FOUND THEN
1146: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_INFO_INSERT_FL');
1147: FND_MSG_PUB.Add;
1148: RAISE FND_API.G_EXC_ERROR;
1149: WHEN OTHERS THEN
1150: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1151: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

Line 1154: FND_MSG_PUB.Add;

1150: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1151: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1152: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1153: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1154: FND_MSG_PUB.Add;
1155:
1156: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_INFO_INSERT_FL');
1157: FND_MSG_PUB.Add;
1158: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1157: FND_MSG_PUB.Add;

1153: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1154: FND_MSG_PUB.Add;
1155:
1156: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_INFO_INSERT_FL');
1157: FND_MSG_PUB.Add;
1158: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1159: END;
1160:
1161: --

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

1166: COMMIT WORK;
1167: END IF;
1168:
1169: -- Standard call to get message count and if count is 1, get message info.
1170: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1171: p_data => x_msg_data,
1172: p_encoded => 'F');
1173:
1174: EXCEPTION

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

1175:
1176: WHEN FND_API.G_EXC_ERROR THEN
1177: ROLLBACK TO create_msite_information_pvt;
1178: x_return_status := FND_API.G_RET_STS_ERROR;
1179: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1180: p_data => x_msg_data,
1181: p_encoded => 'F');
1182:
1183: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1182:
1183: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1184: ROLLBACK TO create_msite_information_pvt;
1185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1186: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1187: p_data => x_msg_data,
1188: p_encoded => 'F');
1189:
1190: WHEN OTHERS THEN

Line 1195: FND_MSG_PUB.Add;

1191: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1192: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1193: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1194: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1195: FND_MSG_PUB.Add;
1196:
1197: ROLLBACK TO create_msite_information_pvt;
1198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1199:

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

1196:
1197: ROLLBACK TO create_msite_information_pvt;
1198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1199:
1200: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1201: THEN
1202: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1203: END IF;
1204:

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

1198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1199:
1200: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1201: THEN
1202: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1203: END IF;
1204:
1205: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1206: p_data => x_msg_data,

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

1201: THEN
1202: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1203: END IF;
1204:
1205: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1206: p_data => x_msg_data,
1207: p_encoded => 'F');
1208:
1209: END Create_Msite_Information;

Line 1279: FND_MSG_PUB.initialize;

1275: END IF;
1276:
1277: -- Initialize message list if p_init_msg_list is set to TRUE.
1278: IF FND_API.to_Boolean(p_init_msg_list) THEN
1279: FND_MSG_PUB.initialize;
1280: END IF;
1281:
1282: -- Initialize API return status to success
1283: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1341: FND_MSG_PUB.Add;

1337: );
1338:
1339: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1340: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_INFO_INVALID_UPDATE');
1341: FND_MSG_PUB.Add;
1342: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1343: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1344: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_INFO_INVALID_UPDATE');
1345: FND_MSG_PUB.Add;

Line 1345: FND_MSG_PUB.Add;

1341: FND_MSG_PUB.Add;
1342: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1343: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1344: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_INFO_INVALID_UPDATE');
1345: FND_MSG_PUB.Add;
1346: RAISE FND_API.G_EXC_ERROR; -- invalid
1347: END IF;
1348:
1349: -- 2. update row with section data into section table

Line 1399: FND_MSG_PUB.ADD;

1395:
1396: EXCEPTION
1397: WHEN NO_DATA_FOUND THEN
1398: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_INFO_UPDATE_FL');
1399: FND_MSG_PUB.ADD;
1400: RAISE FND_API.G_EXC_ERROR;
1401: WHEN OTHERS THEN
1402: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1403: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

Line 1406: FND_MSG_PUB.Add;

1402: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1403: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1404: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1405: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1406: FND_MSG_PUB.Add;
1407:
1408: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_INFO_UPDATE_FL');
1409: FND_MSG_PUB.ADD;
1410: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1409: FND_MSG_PUB.ADD;

1405: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1406: FND_MSG_PUB.Add;
1407:
1408: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_INFO_UPDATE_FL');
1409: FND_MSG_PUB.ADD;
1410: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1411: END;
1412:
1413: --

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

1418: COMMIT WORK;
1419: END IF;
1420:
1421: -- standard call to get message count and if count is 1, get message info.
1422: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1423: p_data => x_msg_data,
1424: p_encoded => 'F');
1425:
1426: EXCEPTION

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

1427:
1428: WHEN FND_API.G_EXC_ERROR THEN
1429: ROLLBACK TO update_msite_information_pvt;
1430: x_return_status := FND_API.G_RET_STS_ERROR;
1431: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1432: p_data => x_msg_data,
1433: p_encoded => 'F');
1434:
1435: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1434:
1435: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1436: ROLLBACK TO update_msite_information_pvt;
1437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1438: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1439: p_data => x_msg_data,
1440: p_encoded => 'F');
1441:
1442: WHEN OTHERS THEN

Line 1447: FND_MSG_PUB.Add;

1443: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1444: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1445: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1446: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1447: FND_MSG_PUB.Add;
1448:
1449: ROLLBACK TO update_msite_information_pvt;
1450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1451:

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

1448:
1449: ROLLBACK TO update_msite_information_pvt;
1450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1451:
1452: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1453: THEN
1454: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1455: END IF;
1456:

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

1450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1451:
1452: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1453: THEN
1454: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1455: END IF;
1456:
1457: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1458: p_data => x_msg_data,

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

1453: THEN
1454: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1455: END IF;
1456:
1457: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1458: p_data => x_msg_data,
1459: p_encoded => 'F');
1460:
1461: END Update_Msite_Information;

Line 1494: FND_MSG_PUB.initialize;

1490: END IF;
1491:
1492: -- Initialize message list if p_init_msg_list is set to TRUE.
1493: IF FND_API.to_Boolean(p_init_msg_list) THEN
1494: FND_MSG_PUB.initialize;
1495: END IF;
1496:
1497: -- Initialize API return status to success
1498: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1508: FND_MSG_PUB.Add;

1504: (p_msite_information_id = FND_API.G_MISS_NUM))
1505: THEN
1506: -- msite_information_id is not specified
1507: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_NO_MINFO_ID_SPEC');
1508: FND_MSG_PUB.Add;
1509: RAISE FND_API.G_EXC_ERROR;
1510: END IF;
1511:
1512: -- delete for ibe_msite_information

Line 1518: FND_MSG_PUB.Add;

1514: Ibe_Msite_Information_Pkg.delete_row(p_msite_information_id);
1515: EXCEPTION
1516: WHEN NO_DATA_FOUND THEN
1517: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_INFO_DELETE_FL');
1518: FND_MSG_PUB.Add;
1519: RAISE FND_API.G_EXC_ERROR;
1520: WHEN OTHERS THEN
1521: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1522: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

Line 1525: FND_MSG_PUB.Add;

1521: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1522: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1523: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1524: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1525: FND_MSG_PUB.Add;
1526:
1527: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_INFO_DELETE_FL');
1528: FND_MSG_PUB.Add;
1529: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1528: FND_MSG_PUB.Add;

1524: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1525: FND_MSG_PUB.Add;
1526:
1527: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_INFO_DELETE_FL');
1528: FND_MSG_PUB.Add;
1529: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1530: END;
1531:
1532: --

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

1537: COMMIT WORK;
1538: END IF;
1539:
1540: -- standard call to get message count and if count is 1, get message info.
1541: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1542: p_data => x_msg_data,
1543: p_encoded => 'F');
1544:
1545: EXCEPTION

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

1546:
1547: WHEN FND_API.G_EXC_ERROR THEN
1548: ROLLBACK TO delete_msite_information_pvt;
1549: x_return_status := FND_API.G_RET_STS_ERROR;
1550: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1551: p_data => x_msg_data,
1552: p_encoded => 'F');
1553:
1554: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1553:
1554: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1555: ROLLBACK TO delete_msite_information_pvt;
1556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1557: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1558: p_data => x_msg_data,
1559: p_encoded => 'F');
1560:
1561: WHEN OTHERS THEN

Line 1566: FND_MSG_PUB.Add;

1562: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1563: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1564: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1565: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1566: FND_MSG_PUB.Add;
1567:
1568: ROLLBACK TO delete_msite_information_pvt;
1569: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1570:

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

1567:
1568: ROLLBACK TO delete_msite_information_pvt;
1569: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1570:
1571: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1572: THEN
1573: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1574: END IF;
1575:

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

1569: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1570:
1571: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1572: THEN
1573: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1574: END IF;
1575:
1576: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1577: p_data => x_msg_data,

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

1572: THEN
1573: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1574: END IF;
1575:
1576: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1577: p_data => x_msg_data,
1578: p_encoded => 'F');
1579:
1580: END Delete_Msite_Information;