DBA Data[Home] [Help]

APPS.IBE_ORD_ONECLICK_PVT dependencies on FND_MSG_PUB

Line 100: FND_MSG_PUB.initialize;

96: END IF;
97:
98: -- Initialize message list if p_init_msg_list is set to TRUE.
99: IF FND_API.to_Boolean( p_init_msg_list ) THEN
100: FND_MSG_PUB.initialize;
101: END IF;
102:
103: -- Initialize API rturn status to success
104: x_return_status := FND_API.g_ret_sts_success;

Line 212: FND_MSG_PUB.Add;

208: END IF;
209: FND_MESSAGE.SET_NAME('IBE','IBE_EXPR_PLSQL_API_ERROR');
210: FND_MESSAGE.SET_TOKEN ( '0' , 'Get_Settings - IBE_ADDRESS_V2PVT.valid_usages' );
211: FND_MESSAGE.SET_TOKEN ( '1' , x_return_status );
212: FND_MSG_PUB.Add;
213: if x_return_status = FND_API.G_RET_STS_ERROR then
214: RAISE FND_API.G_EXC_ERROR;
215: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
216: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 258: FND_MSG_PUB.Add;

254: END IF;
255: FND_MESSAGE.SET_NAME('IBE','IBE_EXPR_PLSQL_API_ERROR');
256: FND_MESSAGE.SET_TOKEN ( '0' , 'Get_Settings - IBE_ADDRESS_V2PVT.valid_usages' );
257: FND_MESSAGE.SET_TOKEN ( '1' , x_return_status );
258: FND_MSG_PUB.Add;
259: if x_return_status = FND_API.G_RET_STS_ERROR then
260: RAISE FND_API.G_EXC_ERROR;
261: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 308: FND_MSG_PUB.Count_And_Get

304:
305: IF FND_API.To_Boolean( p_commit ) THEN
306: COMMIT WORK;
307: END IF;
308: FND_MSG_PUB.Count_And_Get
309: ( p_encoded => FND_API.G_FALSE,
310: p_count => x_msg_count,
311: p_data => x_msg_data
312: );

Line 322: FND_MSG_PUB.Count_And_Get

318: ibe_util.debug('ibe_ord_oneclick_pvt.Get_Settings: EXPECTED ERROR EXCEPTION ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));
319: END IF;
320: ROLLBACK TO Get_Settings_Pvt;
321: x_return_status := FND_API.G_RET_STS_ERROR ;
322: FND_MSG_PUB.Count_And_Get
323: ( p_encoded => FND_API.G_FALSE,
324: p_count => x_msg_count,
325: p_data => x_msg_data
326: );

Line 334: FND_MSG_PUB.Count_And_Get

330: ibe_util.debug('ibe_ord_oneclick_pvt.Get_Settings: UNEXPECTED ERROR EXCEPTION ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));
331: END IF;
332: ROLLBACK TO Get_Settings_Pvt;
333: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
334: FND_MSG_PUB.Count_And_Get
335: ( p_encoded => FND_API.G_FALSE,
336: p_count => x_msg_count,
337: p_data => x_msg_data
338: );

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

342: ibe_util.debug('ibe_ord_oneclick_pvt.Get_Settings: OTHER EXCEPTION ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));
343: END IF;
344: ROLLBACK TO Get_Settings_Pvt;
345: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
346: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
347: THEN
348: FND_MSG_PUB.Add_Exc_Msg
349: ( G_PKG_NAME,
350: l_api_name

Line 348: FND_MSG_PUB.Add_Exc_Msg

344: ROLLBACK TO Get_Settings_Pvt;
345: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
346: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
347: THEN
348: FND_MSG_PUB.Add_Exc_Msg
349: ( G_PKG_NAME,
350: l_api_name
351: );
352: END IF;

Line 353: FND_MSG_PUB.Count_And_Get

349: ( G_PKG_NAME,
350: l_api_name
351: );
352: END IF;
353: FND_MSG_PUB.Count_And_Get
354: ( p_encoded => FND_API.G_FALSE,
355: p_count => x_msg_count,
356: p_data => x_msg_data
357: );

Line 415: FND_MSG_PUB.initialize;

411: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
412: END IF;
413: -- Initialize message list if p_init_msg_list is set to TRUE.
414: IF FND_API.to_Boolean( p_init_msg_list ) THEN
415: FND_MSG_PUB.initialize;
416: END IF;
417:
418: -- Initialize API rturn status to success
419: x_return_status := FND_API.g_ret_sts_success;

Line 495: FND_MSG_PUB.Add;

491: object_version_number = p_OBJECT_VERSION_NUMBER;
492:
493: IF (SQL%NOTFOUND) THEN
494: FND_MESSAGE.Set_Name('IBE', 'IBE_SAVE_ERROR');
495: FND_MSG_PUB.Add;
496: RAISE FND_API.G_EXC_ERROR;
497: END IF;
498: end if;
499: close c_oneclick_row;

Line 508: FND_MSG_PUB.Count_And_Get

504: IF FND_API.To_Boolean( p_commit ) THEN
505: COMMIT WORK;
506: END IF;
507:
508: FND_MSG_PUB.Count_And_Get
509: ( p_encoded => FND_API.G_FALSE,
510: p_count => x_msg_count,
511: p_data => x_msg_data
512: );

Line 521: FND_MSG_PUB.Count_And_Get

517: ibe_util.debug('ibe_ord_oneclick_pvt.Save_Settings: EXPECTED ERROR EXCEPTION ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));
518: END IF;
519: ROLLBACK TO Save_Settings_Pvt;
520: x_return_status := FND_API.G_RET_STS_ERROR ;
521: FND_MSG_PUB.Count_And_Get
522: ( p_encoded => FND_API.G_FALSE,
523: p_count => x_msg_count,
524: p_data => x_msg_data
525: );

Line 533: FND_MSG_PUB.Count_And_Get

529: ibe_util.debug('ibe_ord_oneclick_pvt.Save_Settings: UNEXPECTED ERROR EXCEPTION ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));
530: END IF;
531: ROLLBACK TO Save_Settings_Pvt;
532: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
533: FND_MSG_PUB.Count_And_Get
534: ( p_encoded => FND_API.G_FALSE,
535: p_count => x_msg_count,
536: p_data => x_msg_data
537: );

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

541: ibe_util.debug('ibe_ord_oneclick_pvt.Save_Settings: OTHER EXCEPTION ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));
542: END IF;
543: ROLLBACK TO Save_Settings_Pvt;
544: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
545: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
546: THEN
547: FND_MSG_PUB.Add_Exc_Msg
548: ( G_PKG_NAME,
549: l_api_name

Line 547: FND_MSG_PUB.Add_Exc_Msg

543: ROLLBACK TO Save_Settings_Pvt;
544: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
545: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
546: THEN
547: FND_MSG_PUB.Add_Exc_Msg
548: ( G_PKG_NAME,
549: l_api_name
550: );
551: END IF;

Line 552: FND_MSG_PUB.Count_And_Get

548: ( G_PKG_NAME,
549: l_api_name
550: );
551: END IF;
552: FND_MSG_PUB.Count_And_Get
553: ( p_encoded => FND_API.G_FALSE,
554: p_count => x_msg_count,
555: p_data => x_msg_data
556: );

Line 704: FND_MSG_PUB.initialize;

700: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
701: END IF;
702: -- Initialize message list if p_init_msg_list is set to TRUE.
703: IF FND_API.to_Boolean( p_init_msg_list ) THEN
704: FND_MSG_PUB.initialize;
705: END IF;
706:
707: -- Initialize API rturn status to success
708: x_return_status := FND_API.g_ret_sts_success;

Line 919: FND_MSG_PUB.Add;

915: ibe_util.debug('ibe_ord_oneclick_pvt.Express_Buy_Order - non success status from IBE_Quote_Save_pvt.SAVE: ' || x_return_status); FND_MESSAGE.SET_NAME('IBE','IBE_EXPR_PLSQL_API_ERROR');
916: END IF;
917: FND_MESSAGE.SET_TOKEN ( '0' , 'Express_Buy_Order - IBE_Quote_Save_pvt.SAVE' );
918: FND_MESSAGE.SET_TOKEN ( '1' , x_return_status );
919: FND_MSG_PUB.Add;
920: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
921: RAISE FND_API.G_EXC_ERROR;
922: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
923: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1049: FND_MSG_PUB.Add;

1045: ibe_util.debug('ibe_ord_oneclick_pvt.Express_Buy_Order - non success status from IBE_Shop_List_PVT.Save_Quote_From_Lists: ' || x_return_status); FND_MESSAGE.SET_NAME('IBE','IBE_EXPR_PLSQL_API_ERROR');
1046: END IF;
1047: FND_MESSAGE.SET_TOKEN ( '0' , 'Express_Buy_Order - IBE_Shop_List_PVT.Save_Quote_From_Lists' );
1048: FND_MESSAGE.SET_TOKEN ( '1' , x_return_status );
1049: FND_MSG_PUB.Add;
1050: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1051: RAISE FND_API.G_EXC_ERROR;
1052: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1053: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1100: FND_MSG_PUB.Add;

1096: END IF;
1097: FND_MESSAGE.SET_NAME('IBE','IBE_EXPR_PLSQL_API_ERROR');
1098: FND_MESSAGE.SET_TOKEN ( '0' , 'Express_Buy_Order - IBE_Shop_List_PVT.Save_Quote_From_List_Items' );
1099: FND_MESSAGE.SET_TOKEN ( '1' , x_return_status );
1100: FND_MSG_PUB.Add;
1101: if x_return_status = FND_API.G_RET_STS_ERROR then
1102: RAISE FND_API.G_EXC_ERROR;
1103: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1104: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1118: FND_MSG_PUB.Count_And_Get

1114:
1115: IF FND_API.To_Boolean( p_commit ) THEN
1116: COMMIT WORK;
1117: END IF;
1118: FND_MSG_PUB.Count_And_Get
1119: ( p_encoded => FND_API.G_FALSE,
1120: p_count => x_msg_count ,
1121: p_data => x_msg_data );
1122:

Line 1132: FND_MSG_PUB.Count_And_Get

1128: END IF;
1129: ROLLBACK TO Express_Buy_Order_Pvt;
1130: x_return_status := FND_API.G_RET_STS_ERROR;
1131: x_last_update_date := IBE_Quote_Misc_pvt.getQuoteLastUpdateDate(p_cart_id);
1132: FND_MSG_PUB.Count_And_Get
1133: ( p_encoded => FND_API.G_FALSE,
1134: p_count => x_msg_count,
1135: p_data => x_msg_data
1136: );

Line 1144: FND_MSG_PUB.Count_And_Get

1140: ibe_util.debug('ibe_ord_oneclick_pvt.Express_Buy_Order: UNEXPECTED ERROR EXCEPTION ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));
1141: END IF;
1142: ROLLBACK TO Express_Buy_Order_Pvt;
1143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1144: FND_MSG_PUB.Count_And_Get
1145: ( p_encoded => FND_API.G_FALSE,
1146: p_count => x_msg_count,
1147: p_data => x_msg_data
1148: );

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

1152: ibe_util.debug('ibe_ord_oneclick_pvt.Express_Buy_Order: OTHER EXCEPTION ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));
1153: END IF;
1154: ROLLBACK TO Express_Buy_Order_Pvt;
1155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1156: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1157: THEN
1158: FND_MSG_PUB.Add_Exc_Msg
1159: ( G_PKG_NAME,
1160: l_api_name

Line 1158: FND_MSG_PUB.Add_Exc_Msg

1154: ROLLBACK TO Express_Buy_Order_Pvt;
1155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1156: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1157: THEN
1158: FND_MSG_PUB.Add_Exc_Msg
1159: ( G_PKG_NAME,
1160: l_api_name
1161: );
1162: END IF;

Line 1163: FND_MSG_PUB.Count_And_Get

1159: ( G_PKG_NAME,
1160: l_api_name
1161: );
1162: END IF;
1163: FND_MSG_PUB.Count_And_Get
1164: ( p_encoded => FND_API.G_FALSE,
1165: p_count => x_msg_count,
1166: p_data => x_msg_data
1167: );

Line 1388: FND_MSG_PUB.Add;

1384: END IF;
1385: FND_MESSAGE.SET_NAME('IBE','IBE_EXPR_PLSQL_API_ERROR');
1386: FND_MESSAGE.SET_TOKEN ( '0' , 'Get_Express_Items_Settings - IBE_Quote_Save_pvt.SAVE for nonconsolidation' );
1387: FND_MESSAGE.SET_TOKEN ( '1' , lx_return_status );
1388: FND_MSG_PUB.Add;
1389: if lx_return_status = FND_API.G_RET_STS_ERROR then
1390: RAISE FND_API.G_EXC_ERROR;
1391: elsif lx_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1392: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1748: FND_MSG_PUB.Count_And_Get

1744: END IF;
1745:
1746: END IF;
1747:
1748: FND_MSG_PUB.Count_And_Get
1749: ( p_encoded => FND_API.G_FALSE,
1750: p_count => x_msg_count,
1751: p_data => x_msg_data
1752: );

Line 1761: FND_MSG_PUB.Count_And_Get

1757: ibe_util.debug('ibe_ord_oneclick_pvt.Update_Settings: EXPECTED ERROR EXCEPTION ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));
1758: END IF;
1759: ROLLBACK TO Update_Settings;
1760: x_return_status := FND_API.G_RET_STS_ERROR ;
1761: FND_MSG_PUB.Count_And_Get
1762: ( p_encoded => FND_API.G_FALSE,
1763: p_count => x_msg_count,
1764: p_data => x_msg_data
1765: );

Line 1773: FND_MSG_PUB.Count_And_Get

1769: ibe_util.debug('ibe_ord_oneclick_pvt.Update_Settings: UNEXPECTED ERROR EXCEPTION ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));
1770: END IF;
1771: ROLLBACK TO Update_Settings;
1772: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1773: FND_MSG_PUB.Count_And_Get
1774: ( p_encoded => FND_API.G_FALSE,
1775: p_count => x_msg_count,
1776: p_data => x_msg_data
1777: );

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

1781: ibe_util.debug('ibe_ord_oneclick_pvt.Update_Settings: OTHER EXCEPTION ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));
1782: END IF;
1783: ROLLBACK TO Update_Settings;
1784: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1785: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1786: FND_MSG_PUB.Add_Exc_Msg
1787: ( G_PKG_NAME,
1788: l_api_name
1789: );

Line 1786: FND_MSG_PUB.Add_Exc_Msg

1782: END IF;
1783: ROLLBACK TO Update_Settings;
1784: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1785: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1786: FND_MSG_PUB.Add_Exc_Msg
1787: ( G_PKG_NAME,
1788: l_api_name
1789: );
1790: END IF;

Line 1791: FND_MSG_PUB.Count_And_Get

1787: ( G_PKG_NAME,
1788: l_api_name
1789: );
1790: END IF;
1791: FND_MSG_PUB.Count_And_Get
1792: ( p_encoded => FND_API.G_FALSE,
1793: p_count => x_msg_count,
1794: p_data => x_msg_data
1795: );