DBA Data[Home] [Help]

APPS.ASO_ORDER_FEEDBACK_PUB dependencies on FND_MSG_PUB

Line 222: FND_MSG_PUB.initialize;

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:

Line 304: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

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;

Line 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

Line 358: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

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;

Line 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

Line 458: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

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;

Line 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

Line 512: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

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;

Line 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

Line 539: FND_MSG_PUB.Count_And_Get

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:

Line 549: FND_MSG_PUB.Count_And_Get

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

Line 556: FND_MSG_PUB.Count_And_Get

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

Line 563: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) 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 ,

Line 564: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);

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

Line 566: FND_MSG_PUB.Count_And_Get

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;

Line 701: FND_MSG_PUB.initialize;

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:

Line 788: FND_MSG_PUB.Count_And_Get

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:

Line 798: FND_MSG_PUB.Count_And_Get

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

Line 805: FND_MSG_PUB.Count_And_Get

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

Line 812: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) 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 ,

Line 813: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);

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

Line 815: FND_MSG_PUB.Count_And_Get

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;

Line 1008: FND_MSG_PUB.initialize;

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:

Line 1093: FND_MSG_PUB.Count_And_Get

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:

Line 1103: FND_MSG_PUB.Count_And_Get

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

Line 1110: FND_MSG_PUB.Count_And_Get

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

Line 1117: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) 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 ,

Line 1118: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);

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

Line 1120: FND_MSG_PUB.Count_And_Get

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;

Line 1260: FND_MSG_PUB.initialize;

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:

Line 1348: FND_MSG_PUB.Count_And_Get

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:

Line 1358: FND_MSG_PUB.Count_And_Get

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

Line 1365: FND_MSG_PUB.Count_And_Get

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

Line 1372: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) 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 ,

Line 1373: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);

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

Line 1375: FND_MSG_PUB.Count_And_Get

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;