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 912: FND_MSG_PUB.Add;

908: 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');
909: END IF;
910: FND_MESSAGE.SET_TOKEN ( '0' , 'Express_Buy_Order - IBE_Quote_Save_pvt.SAVE' );
911: FND_MESSAGE.SET_TOKEN ( '1' , x_return_status );
912: FND_MSG_PUB.Add;
913: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
914: RAISE FND_API.G_EXC_ERROR;
915: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
916: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1042: FND_MSG_PUB.Add;

1038: 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');
1039: END IF;
1040: FND_MESSAGE.SET_TOKEN ( '0' , 'Express_Buy_Order - IBE_Shop_List_PVT.Save_Quote_From_Lists' );
1041: FND_MESSAGE.SET_TOKEN ( '1' , x_return_status );
1042: FND_MSG_PUB.Add;
1043: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1044: RAISE FND_API.G_EXC_ERROR;
1045: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1046: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1093: FND_MSG_PUB.Add;

1089: END IF;
1090: FND_MESSAGE.SET_NAME('IBE','IBE_EXPR_PLSQL_API_ERROR');
1091: FND_MESSAGE.SET_TOKEN ( '0' , 'Express_Buy_Order - IBE_Shop_List_PVT.Save_Quote_From_List_Items' );
1092: FND_MESSAGE.SET_TOKEN ( '1' , x_return_status );
1093: FND_MSG_PUB.Add;
1094: if x_return_status = FND_API.G_RET_STS_ERROR then
1095: RAISE FND_API.G_EXC_ERROR;
1096: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1097: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1111: FND_MSG_PUB.Count_And_Get

1107:
1108: IF FND_API.To_Boolean( p_commit ) THEN
1109: COMMIT WORK;
1110: END IF;
1111: FND_MSG_PUB.Count_And_Get
1112: ( p_encoded => FND_API.G_FALSE,
1113: p_count => x_msg_count ,
1114: p_data => x_msg_data );
1115:

Line 1125: FND_MSG_PUB.Count_And_Get

1121: END IF;
1122: ROLLBACK TO Express_Buy_Order_Pvt;
1123: x_return_status := FND_API.G_RET_STS_ERROR;
1124: x_last_update_date := IBE_Quote_Misc_pvt.getQuoteLastUpdateDate(p_cart_id);
1125: FND_MSG_PUB.Count_And_Get
1126: ( p_encoded => FND_API.G_FALSE,
1127: p_count => x_msg_count,
1128: p_data => x_msg_data
1129: );

Line 1137: FND_MSG_PUB.Count_And_Get

1133: ibe_util.debug('ibe_ord_oneclick_pvt.Express_Buy_Order: UNEXPECTED ERROR EXCEPTION ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));
1134: END IF;
1135: ROLLBACK TO Express_Buy_Order_Pvt;
1136: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1137: FND_MSG_PUB.Count_And_Get
1138: ( p_encoded => FND_API.G_FALSE,
1139: p_count => x_msg_count,
1140: p_data => x_msg_data
1141: );

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

1145: ibe_util.debug('ibe_ord_oneclick_pvt.Express_Buy_Order: OTHER EXCEPTION ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));
1146: END IF;
1147: ROLLBACK TO Express_Buy_Order_Pvt;
1148: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1149: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1150: THEN
1151: FND_MSG_PUB.Add_Exc_Msg
1152: ( G_PKG_NAME,
1153: l_api_name

Line 1151: FND_MSG_PUB.Add_Exc_Msg

1147: ROLLBACK TO Express_Buy_Order_Pvt;
1148: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1149: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1150: THEN
1151: FND_MSG_PUB.Add_Exc_Msg
1152: ( G_PKG_NAME,
1153: l_api_name
1154: );
1155: END IF;

Line 1156: FND_MSG_PUB.Count_And_Get

1152: ( G_PKG_NAME,
1153: l_api_name
1154: );
1155: END IF;
1156: FND_MSG_PUB.Count_And_Get
1157: ( p_encoded => FND_API.G_FALSE,
1158: p_count => x_msg_count,
1159: p_data => x_msg_data
1160: );

Line 1381: FND_MSG_PUB.Add;

1377: END IF;
1378: FND_MESSAGE.SET_NAME('IBE','IBE_EXPR_PLSQL_API_ERROR');
1379: FND_MESSAGE.SET_TOKEN ( '0' , 'Get_Express_Items_Settings - IBE_Quote_Save_pvt.SAVE for nonconsolidation' );
1380: FND_MESSAGE.SET_TOKEN ( '1' , lx_return_status );
1381: FND_MSG_PUB.Add;
1382: if lx_return_status = FND_API.G_RET_STS_ERROR then
1383: RAISE FND_API.G_EXC_ERROR;
1384: elsif lx_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1385: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1738: FND_MSG_PUB.Count_And_Get

1734: END IF;
1735:
1736: END IF;
1737:
1738: FND_MSG_PUB.Count_And_Get
1739: ( p_encoded => FND_API.G_FALSE,
1740: p_count => x_msg_count,
1741: p_data => x_msg_data
1742: );

Line 1751: FND_MSG_PUB.Count_And_Get

1747: ibe_util.debug('ibe_ord_oneclick_pvt.Update_Settings: EXPECTED ERROR EXCEPTION ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));
1748: END IF;
1749: ROLLBACK TO Update_Settings;
1750: x_return_status := FND_API.G_RET_STS_ERROR ;
1751: FND_MSG_PUB.Count_And_Get
1752: ( p_encoded => FND_API.G_FALSE,
1753: p_count => x_msg_count,
1754: p_data => x_msg_data
1755: );

Line 1763: FND_MSG_PUB.Count_And_Get

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

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

1771: ibe_util.debug('ibe_ord_oneclick_pvt.Update_Settings: OTHER EXCEPTION ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));
1772: END IF;
1773: ROLLBACK TO Update_Settings;
1774: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1775: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1776: FND_MSG_PUB.Add_Exc_Msg
1777: ( G_PKG_NAME,
1778: l_api_name
1779: );

Line 1776: FND_MSG_PUB.Add_Exc_Msg

1772: END IF;
1773: ROLLBACK TO Update_Settings;
1774: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1775: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1776: FND_MSG_PUB.Add_Exc_Msg
1777: ( G_PKG_NAME,
1778: l_api_name
1779: );
1780: END IF;

Line 1781: FND_MSG_PUB.Count_And_Get

1777: ( G_PKG_NAME,
1778: l_api_name
1779: );
1780: END IF;
1781: FND_MSG_PUB.Count_And_Get
1782: ( p_encoded => FND_API.G_FALSE,
1783: p_count => x_msg_count,
1784: p_data => x_msg_data
1785: );