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 700: FND_MSG_PUB.initialize;

696:
697: -- Initialize message list if p_init_msg_list is set to TRUE.
698:
699: IF FND_API.to_Boolean( p_init_msg_list ) THEN
700: FND_MSG_PUB.initialize;
701: END IF;
702:
703: -- Initialize API return status to success
704:

Line 786: FND_MSG_PUB.Count_And_Get

782: END IF;
783:
784: -- Standard call to get message count and if count is 1, get message info.
785:
786: FND_MSG_PUB.Count_And_Get
787: (p_count => x_msg_count ,
788: p_data => x_msg_data
789: );
790:

Line 796: FND_MSG_PUB.Count_And_Get

792:
793: WHEN FND_API.G_EXC_ERROR THEN
794: ROLLBACK TO GET_NOTICE_PUB;
795: x_return_status := FND_API.G_RET_STS_ERROR ;
796: FND_MSG_PUB.Count_And_Get
797: (p_count => x_msg_count ,
798: p_data => x_msg_data
799: );
800: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 803: FND_MSG_PUB.Count_And_Get

799: );
800: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
801: ROLLBACK TO GET_NOTICE_PUB;
802: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
803: FND_MSG_PUB.Count_And_Get
804: (p_count => x_msg_count ,
805: p_data => x_msg_data
806: );
807: WHEN OTHERS THEN

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

806: );
807: WHEN OTHERS THEN
808: ROLLBACK TO GET_NOTICE_PUB;
809: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
810: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
811: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
812: END IF;
813: FND_MSG_PUB.Count_And_Get
814: (p_count => x_msg_count ,

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

807: WHEN OTHERS THEN
808: ROLLBACK TO GET_NOTICE_PUB;
809: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
810: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
811: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
812: END IF;
813: FND_MSG_PUB.Count_And_Get
814: (p_count => x_msg_count ,
815: p_data => x_msg_data

Line 813: FND_MSG_PUB.Count_And_Get

809: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
810: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
811: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
812: END IF;
813: FND_MSG_PUB.Count_And_Get
814: (p_count => x_msg_count ,
815: p_data => x_msg_data
816: );
817: END GET_NOTICE;

Line 1006: FND_MSG_PUB.initialize;

1002:
1003: -- Initialize message list if p_init_msg_list is set to TRUE.
1004:
1005: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1006: FND_MSG_PUB.initialize;
1007: END IF;
1008:
1009: -- Initialize API return status to success
1010:

Line 1091: FND_MSG_PUB.Count_And_Get

1087: END IF;
1088:
1089: -- Standard call to get message count and if count is 1, get message info.
1090:
1091: FND_MSG_PUB.Count_And_Get
1092: (p_count => x_msg_count ,
1093: p_data => x_msg_data
1094: );
1095:

Line 1101: FND_MSG_PUB.Count_And_Get

1097:
1098: WHEN FND_API.G_EXC_ERROR THEN
1099: ROLLBACK TO HANDLE_EXCEPTION_PUB;
1100: x_return_status := FND_API.G_RET_STS_ERROR ;
1101: FND_MSG_PUB.Count_And_Get
1102: (p_count => x_msg_count ,
1103: p_data => x_msg_data
1104: );
1105: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1108: FND_MSG_PUB.Count_And_Get

1104: );
1105: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1106: ROLLBACK TO HANDLE_EXCEPTION_PUB;
1107: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1108: FND_MSG_PUB.Count_And_Get
1109: (p_count => x_msg_count ,
1110: p_data => x_msg_data
1111: );
1112: WHEN OTHERS THEN

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

1111: );
1112: WHEN OTHERS THEN
1113: ROLLBACK TO HANDLE_EXCEPTION_PUB;
1114: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1115: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1116: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
1117: END IF;
1118: FND_MSG_PUB.Count_And_Get
1119: (p_count => x_msg_count ,

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

1112: WHEN OTHERS THEN
1113: ROLLBACK TO HANDLE_EXCEPTION_PUB;
1114: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1115: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1116: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
1117: END IF;
1118: FND_MSG_PUB.Count_And_Get
1119: (p_count => x_msg_count ,
1120: p_data => x_msg_data

Line 1118: FND_MSG_PUB.Count_And_Get

1114: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1115: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1116: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
1117: END IF;
1118: FND_MSG_PUB.Count_And_Get
1119: (p_count => x_msg_count ,
1120: p_data => x_msg_data
1121: );
1122: END HANDLE_EXCEPTION;

Line 1258: FND_MSG_PUB.initialize;

1254:
1255: -- Initialize message list if p_init_msg_list is set to TRUE.
1256:
1257: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1258: FND_MSG_PUB.initialize;
1259: END IF;
1260:
1261: -- Initialize API return status to success
1262:

Line 1346: FND_MSG_PUB.Count_And_Get

1342: END IF;
1343:
1344: -- Standard call to get message count and if count is 1, get message info.
1345:
1346: FND_MSG_PUB.Count_And_Get
1347: (p_count => x_msg_count ,
1348: p_data => x_msg_data
1349: );
1350:

Line 1356: FND_MSG_PUB.Count_And_Get

1352:
1353: WHEN FND_API.G_EXC_ERROR THEN
1354: ROLLBACK TO GET_EXCEPTION_PUB;
1355: x_return_status := FND_API.G_RET_STS_ERROR ;
1356: FND_MSG_PUB.Count_And_Get
1357: (p_count => x_msg_count ,
1358: p_data => x_msg_data
1359: );
1360: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1363: FND_MSG_PUB.Count_And_Get

1359: );
1360: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1361: ROLLBACK TO GET_EXCEPTION_PUB;
1362: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1363: FND_MSG_PUB.Count_And_Get
1364: (p_count => x_msg_count ,
1365: p_data => x_msg_data
1366: );
1367: WHEN OTHERS THEN

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

1366: );
1367: WHEN OTHERS THEN
1368: ROLLBACK TO GET_EXCEPTION_PUB;
1369: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1370: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1371: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
1372: END IF;
1373: FND_MSG_PUB.Count_And_Get
1374: (p_count => x_msg_count ,

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

1367: WHEN OTHERS THEN
1368: ROLLBACK TO GET_EXCEPTION_PUB;
1369: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1370: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1371: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
1372: END IF;
1373: FND_MSG_PUB.Count_And_Get
1374: (p_count => x_msg_count ,
1375: p_data => x_msg_data

Line 1373: FND_MSG_PUB.Count_And_Get

1369: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1370: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1371: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
1372: END IF;
1373: FND_MSG_PUB.Count_And_Get
1374: (p_count => x_msg_count ,
1375: p_data => x_msg_data
1376: );
1377: END GET_EXCEPTION;