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_CATALOG_PVT dependencies on FND_MSG_PUB

Line 163: FND_MSG_PUB.initialize;

159: END IF;
160:
161: -- Initialize message list if L_init_msg_list is set to TRUE.
162: IF FND_API.to_Boolean(L_init_msg_list) THEN
163: FND_MSG_PUB.initialize;
164: END IF;
165:
166: -- Initialize API return status to success.
167: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 186: FND_MSG_PUB.Add;

182: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
183: IBE_UTIL.debug('IBE_CATALOG_PVT.Error p_sect_id_tbl is NULL');
184: END IF;
185: FND_MESSAGE.Set_Name('IBE', 'IBE_CT_INVALID_ID_OR_NAME');
186: FND_MSG_PUB.Add;
187: RAISE FND_API.G_EXC_ERROR;
188: ELSE
189: l_sectid_tbl := p_sectid_tbl;
190: END IF;

Line 431: FND_MSG_PUB.Count_And_Get

427: IBE_UTIL.debug('IBE_CATALOG_PVT.Load_Sections(-)');
428: END IF;
429:
430: -- standard call to get message count and if count is 1, get message info.
431: FND_MSG_PUB.Count_And_Get
432: ( p_encoded => FND_API.G_FALSE,
433: p_count => x_msg_count,
434: p_data => x_msg_data
435: );

Line 439: FND_MSG_PUB.Count_And_Get

435: );
436: EXCEPTION
437: WHEN FND_API.G_EXC_ERROR THEN
438: x_return_status := FND_API.G_RET_STS_ERROR;
439: FND_MSG_PUB.Count_And_Get
440: ( p_encoded => FND_API.G_FALSE,
441: p_count => x_msg_count,
442: p_data => x_msg_data
443: );

Line 448: FND_MSG_PUB.Count_And_Get

444: --gzhang 08/08/2002, bug#2488246
445: --ibe_util.disable_debug;
446: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
447: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
448: FND_MSG_PUB.Count_And_Get
449: ( p_encoded => FND_API.G_FALSE,
450: p_count => x_msg_count,
451: p_data => x_msg_data
452: );

Line 461: FND_MSG_PUB.Add;

457: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
458: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
459: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
460: FND_MESSAGE.Set_Token('REASON', SQLERRM);
461: FND_MSG_PUB.Add;
462: IF FND_MSG_PUB.Check_Msg_Level
463: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
464: THEN FND_MSG_PUB.Add_Exc_Msg
465: ( G_PKG_NAME,

Line 462: IF FND_MSG_PUB.Check_Msg_Level

458: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
459: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
460: FND_MESSAGE.Set_Token('REASON', SQLERRM);
461: FND_MSG_PUB.Add;
462: IF FND_MSG_PUB.Check_Msg_Level
463: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
464: THEN FND_MSG_PUB.Add_Exc_Msg
465: ( G_PKG_NAME,
466: l_api_name

Line 463: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

459: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
460: FND_MESSAGE.Set_Token('REASON', SQLERRM);
461: FND_MSG_PUB.Add;
462: IF FND_MSG_PUB.Check_Msg_Level
463: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
464: THEN FND_MSG_PUB.Add_Exc_Msg
465: ( G_PKG_NAME,
466: l_api_name
467: );

Line 464: THEN FND_MSG_PUB.Add_Exc_Msg

460: FND_MESSAGE.Set_Token('REASON', SQLERRM);
461: FND_MSG_PUB.Add;
462: IF FND_MSG_PUB.Check_Msg_Level
463: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
464: THEN FND_MSG_PUB.Add_Exc_Msg
465: ( G_PKG_NAME,
466: l_api_name
467: );
468: END IF;

Line 469: FND_MSG_PUB.Count_And_Get

465: ( G_PKG_NAME,
466: l_api_name
467: );
468: END IF;
469: FND_MSG_PUB.Count_And_Get
470: ( p_encoded => FND_API.G_FALSE,
471: p_count => x_msg_count,
472: p_data => x_msg_data
473: );

Line 558: FND_MSG_PUB.initialize;

554:
555:
556: -- initialize message list if l_init_msg_list is set to TRUE
557: IF FND_API.to_Boolean(l_init_msg_list) THEN
558: FND_MSG_PUB.initialize;
559: END IF;
560:
561: -- initialize API return status to success
562: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 625: FND_MSG_PUB.Count_And_Get

621: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
622: IBE_UTIL.debug('IBE_CATALOG_PVT.GetLeafSubSectIDs(-)');
623: END IF;
624: -- standard call to get message count and if count is 1, get message info.
625: FND_MSG_PUB.Count_And_Get
626: ( p_encoded => FND_API.G_FALSE,
627: p_count => x_msg_count,
628: p_data => x_msg_data
629: );

Line 635: FND_MSG_PUB.Count_And_Get

631: --ibe_util.disable_debug;
632: EXCEPTION
633: WHEN FND_API.G_EXC_ERROR THEN
634: x_return_status := FND_API.G_RET_STS_ERROR;
635: FND_MSG_PUB.Count_And_Get
636: ( p_encoded => FND_API.G_FALSE,
637: p_count => x_msg_count,
638: p_data => x_msg_data
639: );

Line 644: FND_MSG_PUB.Count_And_Get

640: --gzhang 08/08/2002, bug#2488246
641: --ibe_util.disable_debug;
642: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
643: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
644: FND_MSG_PUB.Count_And_Get
645: ( p_encoded => FND_API.G_FALSE,
646: p_count => x_msg_count,
647: p_data => x_msg_data
648: );

Line 653: IF FND_MSG_PUB.Check_Msg_Level

649: --gzhang 08/08/2002, bug#2488246
650: --ibe_util.disable_debug;
651: WHEN OTHERS THEN
652: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
653: IF FND_MSG_PUB.Check_Msg_Level
654: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
655: THEN FND_MSG_PUB.Add_Exc_Msg
656: ( G_PKG_NAME,
657: l_api_name

Line 654: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

650: --ibe_util.disable_debug;
651: WHEN OTHERS THEN
652: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
653: IF FND_MSG_PUB.Check_Msg_Level
654: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
655: THEN FND_MSG_PUB.Add_Exc_Msg
656: ( G_PKG_NAME,
657: l_api_name
658: );

Line 655: THEN FND_MSG_PUB.Add_Exc_Msg

651: WHEN OTHERS THEN
652: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
653: IF FND_MSG_PUB.Check_Msg_Level
654: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
655: THEN FND_MSG_PUB.Add_Exc_Msg
656: ( G_PKG_NAME,
657: l_api_name
658: );
659: END IF;

Line 660: FND_MSG_PUB.Count_And_Get

656: ( G_PKG_NAME,
657: l_api_name
658: );
659: END IF;
660: FND_MSG_PUB.Count_And_Get
661: ( p_encoded => FND_API.G_FALSE,
662: p_count => x_msg_count,
663: p_data => x_msg_data
664: );

Line 740: FND_MSG_PUB.initialize;

736: END IF;
737:
738: -- Initialize message list if l_init_msg_list is set to TRUE.
739: IF FND_API.to_Boolean(l_init_msg_list) THEN
740: FND_MSG_PUB.initialize;
741: END IF;
742:
743: -- Initialize API return status to success.
744: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 774: FND_MSG_PUB.Count_And_Get

770: IBE_UTIL.debug('IBE_CATALOG_PVT.GetSuperSectIDs(-)');
771: END IF;
772:
773: -- standard call to get message count and if count is 1, get message info.
774: FND_MSG_PUB.Count_And_Get
775: ( p_encoded => FND_API.G_FALSE,
776: p_count => x_msg_count,
777: p_data => x_msg_data
778: );

Line 782: FND_MSG_PUB.Count_And_Get

778: );
779: EXCEPTION
780: WHEN FND_API.G_EXC_ERROR THEN
781: x_return_status := FND_API.G_RET_STS_ERROR;
782: FND_MSG_PUB.Count_And_Get
783: ( p_encoded => FND_API.G_FALSE,
784: p_count => x_msg_count,
785: p_data => x_msg_data
786: );

Line 789: FND_MSG_PUB.Count_And_Get

785: p_data => x_msg_data
786: );
787: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
788: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
789: FND_MSG_PUB.Count_And_Get
790: ( p_encoded => FND_API.G_FALSE,
791: p_count => x_msg_count,
792: p_data => x_msg_data
793: );

Line 796: IF FND_MSG_PUB.Check_Msg_Level

792: p_data => x_msg_data
793: );
794: WHEN OTHERS THEN
795: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
796: IF FND_MSG_PUB.Check_Msg_Level
797: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
798: THEN FND_MSG_PUB.Add_Exc_Msg
799: ( G_PKG_NAME,
800: l_api_name

Line 797: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

793: );
794: WHEN OTHERS THEN
795: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
796: IF FND_MSG_PUB.Check_Msg_Level
797: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
798: THEN FND_MSG_PUB.Add_Exc_Msg
799: ( G_PKG_NAME,
800: l_api_name
801: );

Line 798: THEN FND_MSG_PUB.Add_Exc_Msg

794: WHEN OTHERS THEN
795: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
796: IF FND_MSG_PUB.Check_Msg_Level
797: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
798: THEN FND_MSG_PUB.Add_Exc_Msg
799: ( G_PKG_NAME,
800: l_api_name
801: );
802: END IF;

Line 803: FND_MSG_PUB.Count_And_Get

799: ( G_PKG_NAME,
800: l_api_name
801: );
802: END IF;
803: FND_MSG_PUB.Count_And_Get
804: ( p_encoded => FND_API.G_FALSE,
805: p_count => x_msg_count,
806: p_data => x_msg_data
807: );

Line 976: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

972: END IF;
973:
974: ROLLBACK TO AVAILABLE_SERVICES_PUB;
975: x_return_status := FND_API.G_RET_STS_ERROR;
976: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
977: p_count => x_msg_count,
978: p_data => x_msg_data);
979: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
980: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN

Line 986: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

982: END IF;
983:
984: ROLLBACK TO AVAILABLE_SERVICES_PUB;
985: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
986: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
987: p_count => x_msg_count,
988: p_data => x_msg_data);
989: WHEN OTHERS THEN
990: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN

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

993:
994: ROLLBACK TO AVAILABLE_SERVICES_PUB;
995: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
996:
997: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
998: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
999: l_api_name);
1000: END IF;
1001:

Line 998: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,

994: ROLLBACK TO AVAILABLE_SERVICES_PUB;
995: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
996:
997: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
998: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
999: l_api_name);
1000: END IF;
1001:
1002: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 1002: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

998: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
999: l_api_name);
1000: END IF;
1001:
1002: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1003: p_count => x_msg_count,
1004: p_data => x_msg_data);
1005:
1006: END GetAvailableServices;

Line 1107: FND_MSG_PUB.initialize;

1103: END IF;
1104:
1105: -- initialize message list if l_init_msg_list is set to TRUE
1106: IF FND_API.to_Boolean(l_init_msg_list) THEN
1107: FND_MSG_PUB.initialize;
1108: END IF;
1109:
1110: -- initialize API return status to success
1111: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1128: FND_MSG_PUB.Add;

1124: IF l_reltype_csr%NOTFOUND THEN
1125: CLOSE l_reltype_csr;
1126: FND_MESSAGE.Set_Name('IBE', 'IBE_CT_REL_NOT_EXIST');
1127: FND_MESSAGE.Set_Token('RELATIONSHIP_TYPE', p_reltype_code);
1128: FND_MSG_PUB.Add;
1129: RAISE FND_API.G_EXC_ERROR;
1130: END IF;
1131: CLOSE l_reltype_csr;
1132:

Line 1205: FND_MSG_PUB.Count_And_Get

1201: IBE_UTIL.debug('IBE_CATALOG_PVT.GETRELATEDCATORSECTIDS(-)');
1202: END IF ;
1203:
1204: -- standard call to get messgae count and if count is 1, get message info.
1205: FND_MSG_PUB.Count_And_Get
1206: ( p_encoded => FND_API.G_FALSE,
1207: p_count => x_msg_count,
1208: p_data => x_msg_data
1209: );

Line 1215: FND_MSG_PUB.Count_And_Get

1211: --ibe_util.disable_debug;
1212: EXCEPTION
1213: WHEN FND_API.G_EXC_ERROR THEN
1214: x_return_status := FND_API.G_RET_STS_ERROR;
1215: FND_MSG_PUB.Count_And_Get
1216: ( p_encoded => FND_API.G_FALSE,
1217: p_count => x_msg_count,
1218: p_data => x_msg_data
1219: );

Line 1224: FND_MSG_PUB.Count_And_Get

1220: --gzhang 08/08/2002, bug#2488246
1221: --ibe_util.disable_debug;
1222: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1224: FND_MSG_PUB.Count_And_Get
1225: ( p_encoded => FND_API.G_FALSE,
1226: p_count => x_msg_count,
1227: p_data => x_msg_data
1228: );

Line 1233: IF FND_MSG_PUB.Check_Msg_Level

1229: --gzhang 08/08/2002, bug#2488246
1230: --ibe_util.disable_debug;
1231: WHEN OTHERS THEN
1232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1233: IF FND_MSG_PUB.Check_Msg_Level
1234: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1235: THEN FND_MSG_PUB.Add_Exc_Msg
1236: ( G_PKG_NAME,
1237: l_api_name

Line 1234: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1230: --ibe_util.disable_debug;
1231: WHEN OTHERS THEN
1232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1233: IF FND_MSG_PUB.Check_Msg_Level
1234: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1235: THEN FND_MSG_PUB.Add_Exc_Msg
1236: ( G_PKG_NAME,
1237: l_api_name
1238: );

Line 1235: THEN FND_MSG_PUB.Add_Exc_Msg

1231: WHEN OTHERS THEN
1232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1233: IF FND_MSG_PUB.Check_Msg_Level
1234: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1235: THEN FND_MSG_PUB.Add_Exc_Msg
1236: ( G_PKG_NAME,
1237: l_api_name
1238: );
1239: END IF;

Line 1240: FND_MSG_PUB.Count_And_Get

1236: ( G_PKG_NAME,
1237: l_api_name
1238: );
1239: END IF;
1240: FND_MSG_PUB.Count_And_Get
1241: ( p_encoded => FND_API.G_FALSE,
1242: p_count => x_msg_count,
1243: p_data => x_msg_data
1244: );

Line 1472: FND_MSG_PUB.initialize;

1468: END IF;
1469:
1470: -- initialize message list if l_init_msg_list is set to TRUE
1471: IF FND_API.to_Boolean(l_init_msg_list) THEN
1472: FND_MSG_PUB.initialize;
1473: END IF;
1474:
1475: -- initialize API return status to success
1476: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1500: FND_MSG_PUB.Count_And_Get

1496: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
1497: IBE_UTIL.debug('IBE_CATALOG_PVT.Get_Format_Mask_and_Symbol(-)');
1498: END IF;
1499: -- standard call to get message count and if count is 1, get message info.
1500: FND_MSG_PUB.Count_And_Get
1501: ( p_encoded => FND_API.G_FALSE,
1502: p_count => x_msg_count,
1503: p_data => x_msg_data
1504: );

Line 1510: FND_MSG_PUB.Count_And_Get

1506: --ibe_util.disable_debug;
1507: EXCEPTION
1508: WHEN FND_API.G_EXC_ERROR THEN
1509: x_return_status := FND_API.G_RET_STS_ERROR;
1510: FND_MSG_PUB.Count_And_Get
1511: ( p_encoded => FND_API.G_FALSE,
1512: p_count => x_msg_count,
1513: p_data => x_msg_data
1514: );

Line 1519: FND_MSG_PUB.Count_And_Get

1515: --gzhang 08/08/2002, bug#2488246
1516: --ibe_util.disable_debug;
1517: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1518: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1519: FND_MSG_PUB.Count_And_Get
1520: ( p_encoded => FND_API.G_FALSE,
1521: p_count => x_msg_count,
1522: p_data => x_msg_data
1523: );

Line 1532: FND_MSG_PUB.Add;

1528: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1529: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1530: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1531: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1532: FND_MSG_PUB.Add;
1533: IF FND_MSG_PUB.Check_Msg_Level
1534: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1535: THEN FND_MSG_PUB.Add_Exc_Msg
1536: ( G_PKG_NAME,

Line 1533: IF FND_MSG_PUB.Check_Msg_Level

1529: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1530: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1531: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1532: FND_MSG_PUB.Add;
1533: IF FND_MSG_PUB.Check_Msg_Level
1534: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1535: THEN FND_MSG_PUB.Add_Exc_Msg
1536: ( G_PKG_NAME,
1537: l_api_name

Line 1534: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1530: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1531: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1532: FND_MSG_PUB.Add;
1533: IF FND_MSG_PUB.Check_Msg_Level
1534: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1535: THEN FND_MSG_PUB.Add_Exc_Msg
1536: ( G_PKG_NAME,
1537: l_api_name
1538: );

Line 1535: THEN FND_MSG_PUB.Add_Exc_Msg

1531: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1532: FND_MSG_PUB.Add;
1533: IF FND_MSG_PUB.Check_Msg_Level
1534: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1535: THEN FND_MSG_PUB.Add_Exc_Msg
1536: ( G_PKG_NAME,
1537: l_api_name
1538: );
1539: END IF;

Line 1540: FND_MSG_PUB.Count_And_Get

1536: ( G_PKG_NAME,
1537: l_api_name
1538: );
1539: END IF;
1540: FND_MSG_PUB.Count_And_Get
1541: ( p_encoded => FND_API.G_FALSE,
1542: p_count => x_msg_count,
1543: p_data => x_msg_data
1544: );

Line 1588: FND_MSG_PUB.initialize;

1584: END IF;
1585:
1586: -- initialize message list if L_init_msg_list is set to TRUE
1587: IF FND_API.to_Boolean(l_init_msg_list) THEN
1588: FND_MSG_PUB.initialize;
1589: END IF;
1590:
1591: -- initialize API return status to success
1592: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1620: FND_MSG_PUB.Count_And_Get

1616: IBE_UTIL.debug('IBE_CATALOG_PVT.validate_quantity(-)');
1617: END IF;
1618:
1619: -- standard call to get message count and if count is 1, get message info.
1620: FND_MSG_PUB.Count_And_Get
1621: ( p_encoded => FND_API.G_FALSE,
1622: p_count => x_msg_count,
1623: p_data => x_msg_data
1624: );

Line 1630: FND_MSG_PUB.Count_And_Get

1626: --ibe_util.disable_debug;
1627: EXCEPTION
1628: WHEN FND_API.G_EXC_ERROR THEN
1629: x_return_status := FND_API.G_RET_STS_ERROR;
1630: FND_MSG_PUB.Count_And_Get
1631: ( p_encoded => FND_API.G_FALSE,
1632: p_count => x_msg_count,
1633: p_data => x_msg_data
1634: );

Line 1639: FND_MSG_PUB.Count_And_Get

1635: --gzhang 08/08/2002, bug#2488246
1636: --ibe_util.disable_debug;
1637: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1638: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1639: FND_MSG_PUB.Count_And_Get
1640: ( p_encoded => FND_API.G_FALSE,
1641: p_count => x_msg_count,
1642: p_data => x_msg_data
1643: );

Line 1652: FND_MSG_PUB.Add;

1648: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1649: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1650: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1651: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1652: FND_MSG_PUB.Add;
1653: IF FND_MSG_PUB.Check_Msg_Level
1654: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1655: THEN FND_MSG_PUB.Add_Exc_Msg
1656: (G_PKG_NAME,

Line 1653: IF FND_MSG_PUB.Check_Msg_Level

1649: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1650: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1651: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1652: FND_MSG_PUB.Add;
1653: IF FND_MSG_PUB.Check_Msg_Level
1654: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1655: THEN FND_MSG_PUB.Add_Exc_Msg
1656: (G_PKG_NAME,
1657: l_api_name

Line 1654: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1650: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1651: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1652: FND_MSG_PUB.Add;
1653: IF FND_MSG_PUB.Check_Msg_Level
1654: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1655: THEN FND_MSG_PUB.Add_Exc_Msg
1656: (G_PKG_NAME,
1657: l_api_name
1658: );

Line 1655: THEN FND_MSG_PUB.Add_Exc_Msg

1651: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1652: FND_MSG_PUB.Add;
1653: IF FND_MSG_PUB.Check_Msg_Level
1654: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1655: THEN FND_MSG_PUB.Add_Exc_Msg
1656: (G_PKG_NAME,
1657: l_api_name
1658: );
1659: END IF;

Line 1660: FND_MSG_PUB.Count_And_Get

1656: (G_PKG_NAME,
1657: l_api_name
1658: );
1659: END IF;
1660: FND_MSG_PUB.Count_And_Get
1661: ( p_encoded => FND_API.G_FALSE,
1662: p_count => x_msg_count,
1663: p_data => x_msg_data
1664: );

Line 1711: FND_MSG_PUB.initialize;

1707: END IF;
1708:
1709: -- initialize message list if L_init_msg_list is set to TRUE
1710: IF FND_API.to_Boolean(l_init_msg_list) THEN
1711: FND_MSG_PUB.initialize;
1712: END IF;
1713:
1714: -- initialize API return status to success
1715: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1755: FND_MSG_PUB.Count_And_Get

1751: end if;
1752: end loop;
1753:
1754: -- standard call to get message count and if count is 1, get message info.
1755: FND_MSG_PUB.Count_And_Get
1756: ( p_encoded => FND_API.G_FALSE,
1757: p_count => x_msg_count,
1758: p_data => x_msg_data
1759: );

Line 1790: FND_MSG_PUB.Count_And_Get

1786: END LOOP;
1787: EXCEPTION
1788: WHEN FND_API.G_EXC_ERROR THEN
1789: x_return_status := FND_API.G_RET_STS_ERROR;
1790: FND_MSG_PUB.Count_And_Get
1791: ( p_encoded => FND_API.G_FALSE,
1792: p_count => x_msg_count,
1793: p_data => x_msg_data
1794: );

Line 1799: FND_MSG_PUB.Count_And_Get

1795: --gzhang 08/08/2002, bug#2488246
1796: --ibe_util.disable_debug;
1797: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1798: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1799: FND_MSG_PUB.Count_And_Get
1800: ( p_encoded => FND_API.G_FALSE,
1801: p_count => x_msg_count,
1802: p_data => x_msg_data
1803: );

Line 1812: FND_MSG_PUB.Add;

1808: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1809: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1810: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1811: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1812: FND_MSG_PUB.Add;
1813: IF FND_MSG_PUB.Check_Msg_Level
1814: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1815: THEN FND_MSG_PUB.Add_Exc_Msg
1816: (G_PKG_NAME,

Line 1813: IF FND_MSG_PUB.Check_Msg_Level

1809: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1810: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1811: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1812: FND_MSG_PUB.Add;
1813: IF FND_MSG_PUB.Check_Msg_Level
1814: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1815: THEN FND_MSG_PUB.Add_Exc_Msg
1816: (G_PKG_NAME,
1817: l_api_name

Line 1814: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1810: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1811: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1812: FND_MSG_PUB.Add;
1813: IF FND_MSG_PUB.Check_Msg_Level
1814: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1815: THEN FND_MSG_PUB.Add_Exc_Msg
1816: (G_PKG_NAME,
1817: l_api_name
1818: );

Line 1815: THEN FND_MSG_PUB.Add_Exc_Msg

1811: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1812: FND_MSG_PUB.Add;
1813: IF FND_MSG_PUB.Check_Msg_Level
1814: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1815: THEN FND_MSG_PUB.Add_Exc_Msg
1816: (G_PKG_NAME,
1817: l_api_name
1818: );
1819: END IF;

Line 1820: FND_MSG_PUB.Count_And_Get

1816: (G_PKG_NAME,
1817: l_api_name
1818: );
1819: END IF;
1820: FND_MSG_PUB.Count_And_Get
1821: ( p_encoded => FND_API.G_FALSE,
1822: p_count => x_msg_count,
1823: p_data => x_msg_data
1824: );

Line 2005: FND_MSG_PUB.initialize;

2001: END IF;
2002:
2003: -- initialize message list if L_init_msg_list is set to TRUE
2004: IF FND_API.to_Boolean(l_init_msg_list) THEN
2005: FND_MSG_PUB.initialize;
2006: END IF;
2007:
2008: -- initialize API return status to success
2009: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2027: FND_MSG_PUB.Add;

2023: IBE_UTIL.debug('Error: p_itm_id and p_accessname are both NULL');
2024: END IF;
2025: FND_MESSAGE.Set_Name('IBE', 'IBE_CT_INVALID_ID_OR_NAME');
2026: FND_MESSAGE.Set_Token('ID_NAME', p_partnum);
2027: FND_MSG_PUB.Add;
2028: RAISE FND_API.G_EXC_ERROR;
2029: ELSE
2030: --loading by part number
2031:

Line 2121: FND_MSG_PUB.Count_And_Get

2117: END IF;
2118: --end API body
2119:
2120: -- standard call to get message count and if count is 1, get message info.
2121: FND_MSG_PUB.Count_And_Get
2122: ( p_encoded => FND_API.G_FALSE,
2123: p_count => x_msg_count,
2124: p_data => x_msg_data
2125: );

Line 2129: FND_MSG_PUB.Count_And_Get

2125: );
2126: EXCEPTION
2127: WHEN FND_API.G_EXC_ERROR THEN
2128: x_return_status := FND_API.G_RET_STS_ERROR;
2129: FND_MSG_PUB.Count_And_Get
2130: ( p_encoded => FND_API.G_FALSE,
2131: p_count => x_msg_count,
2132: p_data => x_msg_data
2133: );

Line 2138: FND_MSG_PUB.Count_And_Get

2134: --gzhang 08/08/2002, bug#2488246
2135: --ibe_util.disable_debug;
2136: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2138: FND_MSG_PUB.Count_And_Get
2139: ( p_encoded => FND_API.G_FALSE,
2140: p_count => x_msg_count,
2141: p_data => x_msg_data
2142: );

Line 2151: FND_MSG_PUB.Add;

2147: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
2148: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
2149: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
2150: FND_MESSAGE.Set_Token('REASON', SQLERRM);
2151: FND_MSG_PUB.Add;
2152: IF FND_MSG_PUB.Check_Msg_Level
2153: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2154: THEN FND_MSG_PUB.Add_Exc_Msg
2155: ( G_PKG_NAME,

Line 2152: IF FND_MSG_PUB.Check_Msg_Level

2148: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
2149: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
2150: FND_MESSAGE.Set_Token('REASON', SQLERRM);
2151: FND_MSG_PUB.Add;
2152: IF FND_MSG_PUB.Check_Msg_Level
2153: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2154: THEN FND_MSG_PUB.Add_Exc_Msg
2155: ( G_PKG_NAME,
2156: l_api_name

Line 2153: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2149: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
2150: FND_MESSAGE.Set_Token('REASON', SQLERRM);
2151: FND_MSG_PUB.Add;
2152: IF FND_MSG_PUB.Check_Msg_Level
2153: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2154: THEN FND_MSG_PUB.Add_Exc_Msg
2155: ( G_PKG_NAME,
2156: l_api_name
2157: );

Line 2154: THEN FND_MSG_PUB.Add_Exc_Msg

2150: FND_MESSAGE.Set_Token('REASON', SQLERRM);
2151: FND_MSG_PUB.Add;
2152: IF FND_MSG_PUB.Check_Msg_Level
2153: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2154: THEN FND_MSG_PUB.Add_Exc_Msg
2155: ( G_PKG_NAME,
2156: l_api_name
2157: );
2158: END IF;

Line 2159: FND_MSG_PUB.Count_And_Get

2155: ( G_PKG_NAME,
2156: l_api_name
2157: );
2158: END IF;
2159: FND_MSG_PUB.Count_And_Get
2160: ( p_encoded => FND_API.G_FALSE,
2161: p_count => x_msg_count,
2162: p_data => x_msg_data
2163: );

Line 2396: FND_MSG_PUB.initialize;

2392: END IF;
2393:
2394: -- initialize message list if p_init_msg_list is set to TRUE
2395: IF FND_API.to_Boolean(p_init_msg_list) THEN
2396: FND_MSG_PUB.initialize;
2397: END IF;
2398:
2399: -- initialize API return status to success
2400: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2453: FND_MSG_PUB.Count_And_Get

2449: END IF;
2450: --end API body
2451:
2452: -- standard call to get message count and if count is 1, get message info.
2453: FND_MSG_PUB.Count_And_Get
2454: ( p_encoded => FND_API.G_FALSE,
2455: p_count => x_msg_count,
2456: p_data => x_msg_data
2457: );

Line 2461: FND_MSG_PUB.Count_And_Get

2457: );
2458: EXCEPTION
2459: WHEN FND_API.G_EXC_ERROR THEN
2460: x_return_status := FND_API.G_RET_STS_ERROR;
2461: FND_MSG_PUB.Count_And_Get
2462: ( p_encoded => FND_API.G_FALSE,
2463: p_count => x_msg_count,
2464: p_data => x_msg_data
2465: );

Line 2468: FND_MSG_PUB.Count_And_Get

2464: p_data => x_msg_data
2465: );
2466: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2467: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2468: FND_MSG_PUB.Count_And_Get
2469: ( p_encoded => FND_API.G_FALSE,
2470: p_count => x_msg_count,
2471: p_data => x_msg_data
2472: );

Line 2479: FND_MSG_PUB.Add;

2475: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
2476: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
2477: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
2478: FND_MESSAGE.Set_Token('REASON', SQLERRM);
2479: FND_MSG_PUB.Add;
2480: IF FND_MSG_PUB.Check_Msg_Level
2481: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2482: THEN FND_MSG_PUB.Add_Exc_Msg
2483: ( G_PKG_NAME,

Line 2480: IF FND_MSG_PUB.Check_Msg_Level

2476: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
2477: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
2478: FND_MESSAGE.Set_Token('REASON', SQLERRM);
2479: FND_MSG_PUB.Add;
2480: IF FND_MSG_PUB.Check_Msg_Level
2481: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2482: THEN FND_MSG_PUB.Add_Exc_Msg
2483: ( G_PKG_NAME,
2484: l_api_name

Line 2481: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2477: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
2478: FND_MESSAGE.Set_Token('REASON', SQLERRM);
2479: FND_MSG_PUB.Add;
2480: IF FND_MSG_PUB.Check_Msg_Level
2481: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2482: THEN FND_MSG_PUB.Add_Exc_Msg
2483: ( G_PKG_NAME,
2484: l_api_name
2485: );

Line 2482: THEN FND_MSG_PUB.Add_Exc_Msg

2478: FND_MESSAGE.Set_Token('REASON', SQLERRM);
2479: FND_MSG_PUB.Add;
2480: IF FND_MSG_PUB.Check_Msg_Level
2481: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2482: THEN FND_MSG_PUB.Add_Exc_Msg
2483: ( G_PKG_NAME,
2484: l_api_name
2485: );
2486: END IF;

Line 2487: FND_MSG_PUB.Count_And_Get

2483: ( G_PKG_NAME,
2484: l_api_name
2485: );
2486: END IF;
2487: FND_MSG_PUB.Count_And_Get
2488: ( p_encoded => FND_API.G_FALSE,
2489: p_count => x_msg_count,
2490: p_data => x_msg_data
2491: );

Line 2562: FND_MSG_PUB.Add;

2558: IBE_UTIL.debug('Error: p_itmid_tbl and p_partnum_tbl are both NULL');
2559: END IF;
2560: FND_MESSAGE.Set_Name('IBE', 'IBE_CT_INVALID_ID_OR_NAME');
2561: FND_MESSAGE.Set_Token('ID_NAME', 'NULL');
2562: FND_MSG_PUB.Add;
2563: RAISE FND_API.G_EXC_ERROR;
2564: RETURN;
2565: ELSE
2566: --loading by part number

Line 2912: FND_MSG_PUB.initialize;

2908: l_init_msg_list := FND_API.G_FALSE;
2909: END IF;
2910: -- initialize message list if L_init_msg_list is set to TRUE
2911: IF FND_API.to_Boolean(l_init_msg_list) THEN
2912: FND_MSG_PUB.initialize;
2913: END IF;
2914:
2915: -- initialize API return status to success
2916: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2961: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE, p_count => x_msg_count, p_data => x_msg_data);

2957: END IF;
2958: --end API body
2959:
2960: -- standard call to get message count and if count is 1, get message info.
2961: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE, p_count => x_msg_count, p_data => x_msg_data);
2962: l_end_time := DBMS_UTILITY.GET_TIME;
2963: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2964: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||':END, elapsed time (s) ='||(l_end_time-l_start_time)/100);
2965: END IF;

Line 2970: FND_MSG_PUB.Count_And_Get

2966:
2967: EXCEPTION
2968: WHEN FND_API.G_EXC_ERROR THEN
2969: x_return_status := FND_API.G_RET_STS_ERROR;
2970: FND_MSG_PUB.Count_And_Get
2971: ( p_encoded => FND_API.G_FALSE,
2972: p_count => x_msg_count,
2973: p_data => x_msg_data
2974: );

Line 2979: FND_MSG_PUB.Count_And_Get

2975: --gzhang 08/08/2002, bug#2488246
2976: --ibe_util.disable_debug;
2977: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2978: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2979: FND_MSG_PUB.Count_And_Get
2980: ( p_encoded => FND_API.G_FALSE,
2981: p_count => x_msg_count,
2982: p_data => x_msg_data
2983: );

Line 2992: FND_MSG_PUB.Add;

2988: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
2989: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
2990: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
2991: FND_MESSAGE.Set_Token('REASON', SQLERRM);
2992: FND_MSG_PUB.Add;
2993: IF FND_MSG_PUB.Check_Msg_Level
2994: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2995: THEN FND_MSG_PUB.Add_Exc_Msg
2996: ( G_PKG_NAME,

Line 2993: IF FND_MSG_PUB.Check_Msg_Level

2989: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
2990: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
2991: FND_MESSAGE.Set_Token('REASON', SQLERRM);
2992: FND_MSG_PUB.Add;
2993: IF FND_MSG_PUB.Check_Msg_Level
2994: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2995: THEN FND_MSG_PUB.Add_Exc_Msg
2996: ( G_PKG_NAME,
2997: l_api_name

Line 2994: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2990: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
2991: FND_MESSAGE.Set_Token('REASON', SQLERRM);
2992: FND_MSG_PUB.Add;
2993: IF FND_MSG_PUB.Check_Msg_Level
2994: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2995: THEN FND_MSG_PUB.Add_Exc_Msg
2996: ( G_PKG_NAME,
2997: l_api_name
2998: );

Line 2995: THEN FND_MSG_PUB.Add_Exc_Msg

2991: FND_MESSAGE.Set_Token('REASON', SQLERRM);
2992: FND_MSG_PUB.Add;
2993: IF FND_MSG_PUB.Check_Msg_Level
2994: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2995: THEN FND_MSG_PUB.Add_Exc_Msg
2996: ( G_PKG_NAME,
2997: l_api_name
2998: );
2999: END IF;

Line 3000: FND_MSG_PUB.Count_And_Get

2996: ( G_PKG_NAME,
2997: l_api_name
2998: );
2999: END IF;
3000: FND_MSG_PUB.Count_And_Get
3001: ( p_encoded => FND_API.G_FALSE,
3002: p_count => x_msg_count,
3003: p_data => x_msg_data
3004: );

Line 3053: FND_MSG_PUB.initialize;

3049: l_init_msg_list := FND_API.G_FALSE;
3050: END IF;
3051: -- initialize message list if p_init_msg_list is set to TRUE
3052: IF FND_API.to_Boolean(p_init_msg_list) THEN
3053: FND_MSG_PUB.initialize;
3054: END IF;
3055:
3056: -- initialize API return status to success
3057: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3126: FND_MSG_PUB.Count_And_Get

3122: CLOSE l_itm_attr_csr;
3123: EXCEPTION
3124: WHEN FND_API.G_EXC_ERROR THEN
3125: x_return_status := FND_API.G_RET_STS_ERROR;
3126: FND_MSG_PUB.Count_And_Get
3127: ( p_encoded => FND_API.G_FALSE,
3128: p_count => x_msg_count,
3129: p_data => x_msg_data
3130: );

Line 3135: FND_MSG_PUB.Count_And_Get

3131: --gzhang 08/08/2002, bug#2488246
3132: --ibe_util.disable_debug;
3133: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3135: FND_MSG_PUB.Count_And_Get
3136: ( p_encoded => FND_API.G_FALSE,
3137: p_count => x_msg_count,
3138: p_data => x_msg_data
3139: );

Line 3148: FND_MSG_PUB.Add;

3144: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
3145: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
3146: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
3147: FND_MESSAGE.Set_Token('REASON', SQLERRM);
3148: FND_MSG_PUB.Add;
3149: IF FND_MSG_PUB.Check_Msg_Level
3150: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3151: THEN FND_MSG_PUB.Add_Exc_Msg
3152: ( G_PKG_NAME,

Line 3149: IF FND_MSG_PUB.Check_Msg_Level

3145: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
3146: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
3147: FND_MESSAGE.Set_Token('REASON', SQLERRM);
3148: FND_MSG_PUB.Add;
3149: IF FND_MSG_PUB.Check_Msg_Level
3150: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3151: THEN FND_MSG_PUB.Add_Exc_Msg
3152: ( G_PKG_NAME,
3153: l_api_name

Line 3150: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3146: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
3147: FND_MESSAGE.Set_Token('REASON', SQLERRM);
3148: FND_MSG_PUB.Add;
3149: IF FND_MSG_PUB.Check_Msg_Level
3150: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3151: THEN FND_MSG_PUB.Add_Exc_Msg
3152: ( G_PKG_NAME,
3153: l_api_name
3154: );

Line 3151: THEN FND_MSG_PUB.Add_Exc_Msg

3147: FND_MESSAGE.Set_Token('REASON', SQLERRM);
3148: FND_MSG_PUB.Add;
3149: IF FND_MSG_PUB.Check_Msg_Level
3150: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3151: THEN FND_MSG_PUB.Add_Exc_Msg
3152: ( G_PKG_NAME,
3153: l_api_name
3154: );
3155: END IF;

Line 3156: FND_MSG_PUB.Count_And_Get

3152: ( G_PKG_NAME,
3153: l_api_name
3154: );
3155: END IF;
3156: FND_MSG_PUB.Count_And_Get
3157: ( p_encoded => FND_API.G_FALSE,
3158: p_count => x_msg_count,
3159: p_data => x_msg_data
3160: );

Line 3202: FND_MSG_PUB.initialize;

3198: l_init_msg_list := FND_API.G_FALSE;
3199: END IF;
3200: -- initialize message list if l_init_msg_list is set to TRUE
3201: IF FND_API.to_Boolean(l_init_msg_list) THEN
3202: FND_MSG_PUB.initialize;
3203: END IF;
3204:
3205: -- initialize API return status to success
3206: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3233: FND_MSG_PUB.Count_And_Get

3229: CLOSE l_itms_msite_csr;
3230: EXCEPTION
3231: WHEN FND_API.G_EXC_ERROR THEN
3232: x_return_status := FND_API.G_RET_STS_ERROR;
3233: FND_MSG_PUB.Count_And_Get
3234: ( p_encoded => FND_API.G_FALSE,
3235: p_count => x_msg_count,
3236: p_data => x_msg_data
3237: );

Line 3240: FND_MSG_PUB.Count_And_Get

3236: p_data => x_msg_data
3237: );
3238: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3240: FND_MSG_PUB.Count_And_Get
3241: ( p_encoded => FND_API.G_FALSE,
3242: p_count => x_msg_count,
3243: p_data => x_msg_data
3244: );

Line 3251: FND_MSG_PUB.Add;

3247: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
3248: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
3249: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
3250: FND_MESSAGE.Set_Token('REASON', SQLERRM);
3251: FND_MSG_PUB.Add;
3252: IF FND_MSG_PUB.Check_Msg_Level
3253: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3254: THEN FND_MSG_PUB.Add_Exc_Msg
3255: ( G_PKG_NAME,

Line 3252: IF FND_MSG_PUB.Check_Msg_Level

3248: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
3249: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
3250: FND_MESSAGE.Set_Token('REASON', SQLERRM);
3251: FND_MSG_PUB.Add;
3252: IF FND_MSG_PUB.Check_Msg_Level
3253: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3254: THEN FND_MSG_PUB.Add_Exc_Msg
3255: ( G_PKG_NAME,
3256: l_api_name

Line 3253: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3249: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
3250: FND_MESSAGE.Set_Token('REASON', SQLERRM);
3251: FND_MSG_PUB.Add;
3252: IF FND_MSG_PUB.Check_Msg_Level
3253: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3254: THEN FND_MSG_PUB.Add_Exc_Msg
3255: ( G_PKG_NAME,
3256: l_api_name
3257: );

Line 3254: THEN FND_MSG_PUB.Add_Exc_Msg

3250: FND_MESSAGE.Set_Token('REASON', SQLERRM);
3251: FND_MSG_PUB.Add;
3252: IF FND_MSG_PUB.Check_Msg_Level
3253: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3254: THEN FND_MSG_PUB.Add_Exc_Msg
3255: ( G_PKG_NAME,
3256: l_api_name
3257: );
3258: END IF;

Line 3259: FND_MSG_PUB.Count_And_Get

3255: ( G_PKG_NAME,
3256: l_api_name
3257: );
3258: END IF;
3259: FND_MSG_PUB.Count_And_Get
3260: ( p_encoded => FND_API.G_FALSE,
3261: p_count => x_msg_count,
3262: p_data => x_msg_data
3263: );