218:
219: -- Initialize message list if p_init_msg_list is set to TRUE.
220:
221: IF FND_API.to_Boolean( p_init_msg_list ) THEN
222: FND_MSG_PUB.initialize;
223: END IF;
224:
225: -- Initialize API return status to success
226:
300: );
301:
302: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
303: THEN
304: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
305: THEN
306: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
307: FND_MESSAGE.Set_Token('API', 'ASO_ORDER_FEEDBACK_CUHK.Update_Notice_PRE', FALSE);
308: FND_MSG_PUB.ADD;
304: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
305: THEN
306: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
307: FND_MESSAGE.Set_Token('API', 'ASO_ORDER_FEEDBACK_CUHK.Update_Notice_PRE', FALSE);
308: FND_MSG_PUB.ADD;
309: END IF;
310: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
311: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
312: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
354: );
355:
356: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
357: THEN
358: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
359: THEN
360: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
361: FND_MESSAGE.Set_Token('API', 'ASO_ORDER_FEEDBACK_VUHK.Update_Notice_PRE', FALSE);
362: FND_MSG_PUB.ADD;
358: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
359: THEN
360: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
361: FND_MESSAGE.Set_Token('API', 'ASO_ORDER_FEEDBACK_VUHK.Update_Notice_PRE', FALSE);
362: FND_MSG_PUB.ADD;
363: END IF;
364: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
365: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
366: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
454: );
455:
456: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
457: THEN
458: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
459: THEN
460: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
461: FND_MESSAGE.Set_Token('API', 'ASO_ORDER_FEEDBACK_CUHK.Update_Notice_POST', FALSE);
462: FND_MSG_PUB.ADD;
458: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
459: THEN
460: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
461: FND_MESSAGE.Set_Token('API', 'ASO_ORDER_FEEDBACK_CUHK.Update_Notice_POST', FALSE);
462: FND_MSG_PUB.ADD;
463: END IF;
464: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
465: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
466: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
508: );
509:
510: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
511: THEN
512: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
513: THEN
514: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
515: FND_MESSAGE.Set_Token('API', 'ASO_ORDER_FEEDBACK_VUHK.Update_Notice_POST', FALSE);
516: FND_MSG_PUB.ADD;
512: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
513: THEN
514: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
515: FND_MESSAGE.Set_Token('API', 'ASO_ORDER_FEEDBACK_VUHK.Update_Notice_POST', FALSE);
516: FND_MSG_PUB.ADD;
517: END IF;
518: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
519: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
520: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
535: END IF;
536:
537: -- Standard call to get message count and if count is 1, get message info.
538:
539: FND_MSG_PUB.Count_And_Get
540: (p_count => x_msg_count ,
541: p_data => x_msg_data
542: );
543:
545:
546: WHEN FND_API.G_EXC_ERROR THEN
547: ROLLBACK TO UPDATE_NOTICE_PUB;
548: x_return_status := FND_API.G_RET_STS_ERROR ;
549: FND_MSG_PUB.Count_And_Get
550: (p_count => x_msg_count ,
551: p_data => x_msg_data
552: );
553: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
552: );
553: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
554: ROLLBACK TO UPDATE_NOTICE_PUB;
555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
556: FND_MSG_PUB.Count_And_Get
557: (p_count => x_msg_count ,
558: p_data => x_msg_data
559: );
560: WHEN OTHERS THEN
559: );
560: WHEN OTHERS THEN
561: ROLLBACK TO UPDATE_NOTICE_PUB;
562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
563: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
564: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
565: END IF;
566: FND_MSG_PUB.Count_And_Get
567: (p_count => x_msg_count ,
560: WHEN OTHERS THEN
561: ROLLBACK TO UPDATE_NOTICE_PUB;
562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
563: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
564: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
565: END IF;
566: FND_MSG_PUB.Count_And_Get
567: (p_count => x_msg_count ,
568: p_data => x_msg_data
562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
563: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
564: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
565: END IF;
566: FND_MSG_PUB.Count_And_Get
567: (p_count => x_msg_count ,
568: p_data => x_msg_data
569: );
570: END UPDATE_NOTICE;
697:
698: -- Initialize message list if p_init_msg_list is set to TRUE.
699:
700: IF FND_API.to_Boolean( p_init_msg_list ) THEN
701: FND_MSG_PUB.initialize;
702: END IF;
703:
704: -- Initialize API return status to success
705:
784: END IF;
785:
786: -- Standard call to get message count and if count is 1, get message info.
787:
788: FND_MSG_PUB.Count_And_Get
789: (p_count => x_msg_count ,
790: p_data => x_msg_data
791: );
792:
794:
795: WHEN FND_API.G_EXC_ERROR THEN
796: ROLLBACK TO GET_NOTICE_PUB;
797: x_return_status := FND_API.G_RET_STS_ERROR ;
798: FND_MSG_PUB.Count_And_Get
799: (p_count => x_msg_count ,
800: p_data => x_msg_data
801: );
802: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
801: );
802: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
803: ROLLBACK TO GET_NOTICE_PUB;
804: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
805: FND_MSG_PUB.Count_And_Get
806: (p_count => x_msg_count ,
807: p_data => x_msg_data
808: );
809: WHEN OTHERS THEN
808: );
809: WHEN OTHERS THEN
810: ROLLBACK TO GET_NOTICE_PUB;
811: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
812: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
813: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
814: END IF;
815: FND_MSG_PUB.Count_And_Get
816: (p_count => x_msg_count ,
809: WHEN OTHERS THEN
810: ROLLBACK TO GET_NOTICE_PUB;
811: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
812: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
813: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
814: END IF;
815: FND_MSG_PUB.Count_And_Get
816: (p_count => x_msg_count ,
817: p_data => x_msg_data
811: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
812: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
813: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
814: END IF;
815: FND_MSG_PUB.Count_And_Get
816: (p_count => x_msg_count ,
817: p_data => x_msg_data
818: );
819: END GET_NOTICE;
1004:
1005: -- Initialize message list if p_init_msg_list is set to TRUE.
1006:
1007: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1008: FND_MSG_PUB.initialize;
1009: END IF;
1010:
1011: -- Initialize API return status to success
1012:
1089: END IF;
1090:
1091: -- Standard call to get message count and if count is 1, get message info.
1092:
1093: FND_MSG_PUB.Count_And_Get
1094: (p_count => x_msg_count ,
1095: p_data => x_msg_data
1096: );
1097:
1099:
1100: WHEN FND_API.G_EXC_ERROR THEN
1101: ROLLBACK TO HANDLE_EXCEPTION_PUB;
1102: x_return_status := FND_API.G_RET_STS_ERROR ;
1103: FND_MSG_PUB.Count_And_Get
1104: (p_count => x_msg_count ,
1105: p_data => x_msg_data
1106: );
1107: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1106: );
1107: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1108: ROLLBACK TO HANDLE_EXCEPTION_PUB;
1109: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1110: FND_MSG_PUB.Count_And_Get
1111: (p_count => x_msg_count ,
1112: p_data => x_msg_data
1113: );
1114: WHEN OTHERS THEN
1113: );
1114: WHEN OTHERS THEN
1115: ROLLBACK TO HANDLE_EXCEPTION_PUB;
1116: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1117: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1118: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
1119: END IF;
1120: FND_MSG_PUB.Count_And_Get
1121: (p_count => x_msg_count ,
1114: WHEN OTHERS THEN
1115: ROLLBACK TO HANDLE_EXCEPTION_PUB;
1116: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1117: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1118: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
1119: END IF;
1120: FND_MSG_PUB.Count_And_Get
1121: (p_count => x_msg_count ,
1122: p_data => x_msg_data
1116: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1117: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1118: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
1119: END IF;
1120: FND_MSG_PUB.Count_And_Get
1121: (p_count => x_msg_count ,
1122: p_data => x_msg_data
1123: );
1124: END HANDLE_EXCEPTION;
1256:
1257: -- Initialize message list if p_init_msg_list is set to TRUE.
1258:
1259: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1260: FND_MSG_PUB.initialize;
1261: END IF;
1262:
1263: -- Initialize API return status to success
1264:
1344: END IF;
1345:
1346: -- Standard call to get message count and if count is 1, get message info.
1347:
1348: FND_MSG_PUB.Count_And_Get
1349: (p_count => x_msg_count ,
1350: p_data => x_msg_data
1351: );
1352:
1354:
1355: WHEN FND_API.G_EXC_ERROR THEN
1356: ROLLBACK TO GET_EXCEPTION_PUB;
1357: x_return_status := FND_API.G_RET_STS_ERROR ;
1358: FND_MSG_PUB.Count_And_Get
1359: (p_count => x_msg_count ,
1360: p_data => x_msg_data
1361: );
1362: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1361: );
1362: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1363: ROLLBACK TO GET_EXCEPTION_PUB;
1364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1365: FND_MSG_PUB.Count_And_Get
1366: (p_count => x_msg_count ,
1367: p_data => x_msg_data
1368: );
1369: WHEN OTHERS THEN
1368: );
1369: WHEN OTHERS THEN
1370: ROLLBACK TO GET_EXCEPTION_PUB;
1371: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1372: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1373: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
1374: END IF;
1375: FND_MSG_PUB.Count_And_Get
1376: (p_count => x_msg_count ,
1369: WHEN OTHERS THEN
1370: ROLLBACK TO GET_EXCEPTION_PUB;
1371: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1372: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1373: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
1374: END IF;
1375: FND_MSG_PUB.Count_And_Get
1376: (p_count => x_msg_count ,
1377: p_data => x_msg_data
1371: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1372: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1373: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
1374: END IF;
1375: FND_MSG_PUB.Count_And_Get
1376: (p_count => x_msg_count ,
1377: p_data => x_msg_data
1378: );
1379: END GET_EXCEPTION;