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_MESSAGE

Line 42: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MSITE_ID_NOT_FOUND');

38: OPEN c1(p_msite_id);
39: FETCH c1 INTO l_tmp_id;
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;

Line 43: FND_MESSAGE.Set_Token('MSITE_ID', p_msite_id);

39: FETCH c1 INTO l_tmp_id;
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;

Line 64: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');

60: p_data => x_msg_data,
61: p_encoded => 'F');
62:
63: WHEN OTHERS THEN
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;

Line 65: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

61: p_encoded => 'F');
62:
63: WHEN OTHERS THEN
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:

Line 66: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

62:
63: WHEN OTHERS THEN
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;

Line 67: FND_MESSAGE.Set_Token('REASON', SQLERRM);

63: WHEN OTHERS THEN
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:

Line 117: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_PM_CODE_NOT_EXISTS');

113: OPEN c1(p_payment_method_code);
114: FETCH c1 INTO l_tmp_id;
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;

Line 118: FND_MESSAGE.Set_Token('PAYMENT_METHOD_CODE', p_payment_method_code);

114: FETCH c1 INTO l_tmp_id;
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;

Line 139: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');

135: p_data => x_msg_data,
136: p_encoded => 'F');
137:
138: WHEN OTHERS THEN
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;

Line 140: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

136: p_encoded => 'F');
137:
138: WHEN OTHERS THEN
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:

Line 141: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

137:
138: WHEN OTHERS THEN
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;

Line 142: FND_MESSAGE.Set_Token('REASON', SQLERRM);

138: WHEN OTHERS THEN
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:

Line 187: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_CC_CODE_NOT_EXISTS');

183: OPEN c1(p_credit_card_code);
184: FETCH c1 INTO l_tmp_id;
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;

Line 188: FND_MESSAGE.Set_Token('CREDIT_CARD_CODE', p_credit_card_code);

184: FETCH c1 INTO l_tmp_id;
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;

Line 209: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');

205: p_data => x_msg_data,
206: p_encoded => 'F');
207:
208: WHEN OTHERS THEN
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;

Line 210: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

206: p_encoded => 'F');
207:
208: WHEN OTHERS THEN
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:

Line 211: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

207:
208: WHEN OTHERS THEN
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;

Line 212: FND_MESSAGE.Set_Token('REASON', SQLERRM);

208: WHEN OTHERS THEN
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:

Line 262: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_SM_CODE_NOT_EXISTS');

258: OPEN c1(p_shipment_method_code);
259: FETCH c1 INTO l_tmp_id;
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;

Line 263: FND_MESSAGE.Set_Token('SHIPMENT_METHOD_CODE', p_shipment_method_code);

259: FETCH c1 INTO l_tmp_id;
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;

Line 284: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');

280: p_data => x_msg_data,
281: p_encoded => 'F');
282:
283: WHEN OTHERS THEN
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;

Line 285: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

281: p_encoded => 'F');
282:
283: WHEN OTHERS THEN
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:

Line 286: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

282:
283: WHEN OTHERS THEN
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;

Line 287: FND_MESSAGE.Set_Token('REASON', SQLERRM);

283: WHEN OTHERS THEN
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:

Line 375: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_INFORMATION_DUP');

371: OPEN c1(p_msite_id, p_msite_information1);
372: FETCH c1 INTO l_tmp_id;
373: IF (c1%FOUND) THEN -- found duplicate
374: CLOSE c1;
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;

Line 376: FND_MESSAGE.Set_Token('VALUE', p_msite_information1);

372: FETCH c1 INTO l_tmp_id;
373: IF (c1%FOUND) THEN -- found duplicate
374: CLOSE c1;
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;

Line 377: FND_MESSAGE.Set_Token('MSITE_ID', p_msite_id);

373: IF (c1%FOUND) THEN -- found duplicate
374: CLOSE c1;
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;

Line 378: FND_MESSAGE.Set_Token('CONTEXT', p_msite_information_context);

374: CLOSE c1;
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;

Line 391: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_INFORMATION_DUP');

387: OPEN c2(p_msite_id, p_msite_information1);
388: FETCH c2 INTO l_tmp_id;
389: IF (c2%FOUND) THEN -- found duplicate
390: CLOSE c2;
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;

Line 392: FND_MESSAGE.Set_Token('VALUE', p_msite_information1);

388: FETCH c2 INTO l_tmp_id;
389: IF (c2%FOUND) THEN -- found duplicate
390: CLOSE c2;
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;

Line 393: FND_MESSAGE.Set_Token('MSITE_ID', p_msite_id);

389: IF (c2%FOUND) THEN -- found duplicate
390: CLOSE c2;
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;

Line 394: FND_MESSAGE.Set_Token('CONTEXT', p_msite_information_context);

390: CLOSE c2;
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;

Line 407: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_INFORMATION_DUP');

403: OPEN c3(p_msite_id, p_msite_information1);
404: FETCH c3 INTO l_tmp_id;
405: IF (c3%FOUND) THEN -- found duplicate
406: CLOSE c3;
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;

Line 408: FND_MESSAGE.Set_Token('VALUE', p_msite_information1);

404: FETCH c3 INTO l_tmp_id;
405: IF (c3%FOUND) THEN -- found duplicate
406: CLOSE c3;
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;

Line 409: FND_MESSAGE.Set_Token('MSITE_ID', p_msite_id);

405: IF (c3%FOUND) THEN -- found duplicate
406: CLOSE c3;
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;

Line 410: FND_MESSAGE.Set_Token('CONTEXT', p_msite_information_context);

406: CLOSE c3;
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;

Line 433: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');

429: p_data => x_msg_data,
430: p_encoded => 'F');
431:
432: WHEN OTHERS THEN
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;

Line 434: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

430: p_encoded => 'F');
431:
432: WHEN OTHERS THEN
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:

Line 435: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

431:
432: WHEN OTHERS THEN
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;

Line 436: FND_MESSAGE.Set_Token('REASON', SQLERRM);

432: WHEN OTHERS THEN
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:

Line 520: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INVALID_MSITE_ID');

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

Line 528: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_INVALID_INFO_CTX');

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

Line 541: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_INVALID_MSITE_INFO');

537:
538: IF ((p_msite_information1 IS NULL) OR
539: (p_msite_information1 = FND_API.G_MISS_CHAR))
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;

Line 542: FND_MESSAGE.Set_Token('MSITE_ID', p_msite_id);

538: IF ((p_msite_information1 IS NULL) OR
539: (p_msite_information1 = FND_API.G_MISS_CHAR))
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;

Line 543: FND_MESSAGE.Set_Token('CONTEXT', p_msite_information_context);

539: (p_msite_information1 = FND_API.G_MISS_CHAR))
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:

Line 568: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MSITE_ID_VLD_FAIL');

564: x_msg_data => x_msg_data
565: );
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

Line 569: FND_MESSAGE.Set_Token('MSITE_ID', p_msite_id);

565: );
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');

Line 573: 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);
575: FND_MSG_PUB.Add;
576: RAISE FND_API.G_EXC_ERROR; -- invalid msite_id
577: END IF;

Line 574: 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);
575: FND_MSG_PUB.Add;
576: RAISE FND_API.G_EXC_ERROR; -- invalid msite_id
577: END IF;
578: -- developer flexfield

Line 590: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_PM_VLD_FAIL');

586: x_msg_data => x_msg_data
587: );
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

Line 591: FND_MESSAGE.Set_Token('PAYMENT_METHOD_CODE', p_msite_information1);

587: );
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');

Line 595: 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);
597: FND_MSG_PUB.Add;
598: RAISE FND_API.G_EXC_ERROR;
599: END IF;

Line 596: 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);
597: FND_MSG_PUB.Add;
598: RAISE FND_API.G_EXC_ERROR;
599: END IF;
600: ELSIF (p_msite_information_context = 'CC_TYPE') THEN

Line 611: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_CC_VLD_FAIL');

607: x_msg_data => x_msg_data
608: );
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

Line 612: FND_MESSAGE.Set_Token('CREDIT_CARD_CODE', p_msite_information1);

608: );
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');

Line 616: 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);
618: FND_MSG_PUB.Add;
619: RAISE FND_API.G_EXC_ERROR;
620: END IF;

Line 617: 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);
618: FND_MSG_PUB.Add;
619: RAISE FND_API.G_EXC_ERROR;
620: END IF;
621: ELSIF (p_msite_information_context = 'SHPMT_MTHD') THEN

Line 632: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_SM_VLD_FAIL');

628: x_msg_data => x_msg_data
629: );
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

Line 633: FND_MESSAGE.Set_Token('SHIPMENT_METHOD_CODE', p_msite_information1);

629: );
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');

Line 637: 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);
639: FND_MSG_PUB.Add;
640: RAISE FND_API.G_EXC_ERROR;
641: END IF;

Line 638: 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);
639: FND_MSG_PUB.Add;
640: RAISE FND_API.G_EXC_ERROR;
641: END IF;
642:

Line 677: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_INFO_UNEXP_DUP_CHECK');

673: x_msg_data => x_msg_data
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');

Line 681: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_DUPLICATE_MSITE_INFO');

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);
683: FND_MESSAGE.Set_Token('CONTEXT', p_msite_information_context);
684: FND_MSG_PUB.Add;
685: RAISE FND_API.G_EXC_ERROR; -- duplicate entry

Line 682: FND_MESSAGE.Set_Token('MSITE_ID', p_msite_id);

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);
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;

Line 683: FND_MESSAGE.Set_Token('CONTEXT', p_msite_information_context);

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);
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

Line 702: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');

698: p_data => x_msg_data,
699: p_encoded => 'F');
700:
701: WHEN OTHERS THEN
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;

Line 703: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

699: p_encoded => 'F');
700:
701: WHEN OTHERS THEN
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:

Line 704: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

700:
701: WHEN OTHERS THEN
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;

Line 705: FND_MESSAGE.Set_Token('REASON', SQLERRM);

701: WHEN OTHERS THEN
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:

Line 797: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MSINF_ID_IS_NULL');

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

Line 805: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_OVN_IS_NULL');

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

Line 819: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_INFO_ID_NOT_FOUND');

815: OPEN c1(p_msite_information_id);
816: FETCH c1 INTO l_msite_information_context, l_msite_id;
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;

Line 820: FND_MESSAGE.Set_Token('MSITE_INFO_ID', p_msite_information_id);

816: FETCH c1 INTO l_msite_information_context, l_msite_id;
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;

Line 835: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_INVALID_MSITE_INFO');

831:
832: IF ((p_msite_information1 IS NULL) OR
833: (p_msite_information1 = FND_API.G_MISS_CHAR))
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;

Line 836: FND_MESSAGE.Set_Token('MSITE_ID', l_msite_id);

832: IF ((p_msite_information1 IS NULL) OR
833: (p_msite_information1 = FND_API.G_MISS_CHAR))
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;

Line 837: FND_MESSAGE.Set_Token('CONTEXT', l_msite_information_context);

833: (p_msite_information1 = FND_API.G_MISS_CHAR))
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:

Line 856: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_PM_VLD_FAIL');

852: x_msg_data => x_msg_data
853: );
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

Line 857: FND_MESSAGE.Set_Token('PAYMENT_METHOD_CODE', p_msite_information1);

853: );
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');

Line 861: 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);
863: FND_MSG_PUB.Add;
864: RAISE FND_API.G_EXC_ERROR;
865: END IF;

Line 862: 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);
863: FND_MSG_PUB.Add;
864: RAISE FND_API.G_EXC_ERROR;
865: END IF;
866:

Line 878: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_CC_VLD_FAIL');

874: x_msg_data => x_msg_data
875: );
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

Line 879: FND_MESSAGE.Set_Token('CREDIT_CARD_CODE', p_msite_information1);

875: );
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');

Line 883: 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);
885: FND_MSG_PUB.Add;
886: RAISE FND_API.G_EXC_ERROR;
887: END IF;

Line 884: 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);
885: FND_MSG_PUB.Add;
886: RAISE FND_API.G_EXC_ERROR;
887: END IF;
888:

Line 900: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_SM_VLD_FAIL');

896: x_msg_data => x_msg_data
897: );
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

Line 901: FND_MESSAGE.Set_Token('SHIPMENT_METHOD_CODE', p_msite_information1);

897: );
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');

Line 905: 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);
907: FND_MSG_PUB.Add;
908: RAISE FND_API.G_EXC_ERROR;
909: END IF;

Line 906: 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);
907: FND_MSG_PUB.Add;
908: RAISE FND_API.G_EXC_ERROR;
909: END IF;
910:

Line 928: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');

924: p_data => x_msg_data,
925: p_encoded => 'F');
926:
927: WHEN OTHERS THEN
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;

Line 929: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

925: p_encoded => 'F');
926:
927: WHEN OTHERS THEN
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:

Line 930: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

926:
927: WHEN OTHERS THEN
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;

Line 931: FND_MESSAGE.Set_Token('REASON', SQLERRM);

927: WHEN OTHERS THEN
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:

Line 1081: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_INFO_INVALID_CREATE');

1077: x_msg_count => x_msg_count,
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');

Line 1085: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_INFO_INVALID_CREATE');

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;
1087: RAISE FND_API.G_EXC_ERROR; -- invalid
1088: END IF;
1089: --

Line 1146: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_INFO_INSERT_FL');

1142: );
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');

Line 1150: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');

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);
1152: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1153: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1154: FND_MSG_PUB.Add;

Line 1151: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

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);
1152: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1153: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1154: FND_MSG_PUB.Add;
1155:

Line 1152: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

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);
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');

Line 1153: FND_MESSAGE.Set_Token('REASON', SQLERRM);

1149: WHEN OTHERS THEN
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;

Line 1156: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_INFO_INSERT_FL');

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;
1159: END;
1160:

Line 1191: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');

1187: p_data => x_msg_data,
1188: p_encoded => 'F');
1189:
1190: WHEN OTHERS THEN
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;

Line 1192: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

1188: p_encoded => 'F');
1189:
1190: WHEN OTHERS THEN
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:

Line 1193: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

1189:
1190: WHEN OTHERS THEN
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;

Line 1194: FND_MESSAGE.Set_Token('REASON', SQLERRM);

1190: WHEN OTHERS THEN
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;

Line 1340: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_INFO_INVALID_UPDATE');

1336: x_msg_data => x_msg_data
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');

Line 1344: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_INFO_INVALID_UPDATE');

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;
1346: RAISE FND_API.G_EXC_ERROR; -- invalid
1347: END IF;
1348:

Line 1398: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_INFO_UPDATE_FL');

1394: );
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');

Line 1402: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');

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);
1404: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1405: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1406: FND_MSG_PUB.Add;

Line 1403: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

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);
1404: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1405: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1406: FND_MSG_PUB.Add;
1407:

Line 1404: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

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);
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');

Line 1405: FND_MESSAGE.Set_Token('REASON', SQLERRM);

1401: WHEN OTHERS THEN
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;

Line 1408: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_INFO_UPDATE_FL');

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;
1411: END;
1412:

Line 1443: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');

1439: p_data => x_msg_data,
1440: p_encoded => 'F');
1441:
1442: WHEN OTHERS THEN
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;

Line 1444: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

1440: p_encoded => 'F');
1441:
1442: WHEN OTHERS THEN
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:

Line 1445: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

1441:
1442: WHEN OTHERS THEN
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;

Line 1446: FND_MESSAGE.Set_Token('REASON', SQLERRM);

1442: WHEN OTHERS THEN
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;

Line 1507: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_NO_MINFO_ID_SPEC');

1503: IF ((p_msite_information_id IS NULL) OR
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:

Line 1517: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_INFO_DELETE_FL');

1513: BEGIN
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');

Line 1521: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');

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);
1523: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1524: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1525: FND_MSG_PUB.Add;

Line 1522: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

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);
1523: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1524: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1525: FND_MSG_PUB.Add;
1526:

Line 1523: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

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);
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');

Line 1524: FND_MESSAGE.Set_Token('REASON', SQLERRM);

1520: WHEN OTHERS THEN
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;

Line 1527: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_INFO_DELETE_FL');

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;
1530: END;
1531:

Line 1562: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');

1558: p_data => x_msg_data,
1559: p_encoded => 'F');
1560:
1561: WHEN OTHERS THEN
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;

Line 1563: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

1559: p_encoded => 'F');
1560:
1561: WHEN OTHERS THEN
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:

Line 1564: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

1560:
1561: WHEN OTHERS THEN
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;

Line 1565: FND_MESSAGE.Set_Token('REASON', SQLERRM);

1561: WHEN OTHERS THEN
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;