DBA Data[Home] [Help]

APPS.WIP_EAMWORKORDER_PVT dependencies on FND_MSG_PUB

Line 88: FND_MSG_PUB.initialize;

84: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
85: END IF;
86: -- Initialize message list if p_init_msg_list is set to TRUE.
87: IF FND_API.to_Boolean( p_init_msg_list ) THEN
88: FND_MSG_PUB.initialize;
89: END IF;
90: -- Initialize API return status to success
91: x_return_status := FND_API.G_RET_STS_SUCCESS;
92: -- API body

Line 97: FND_MSG_PUB.ADD();

93:
94: -- EAM Specific Validation
95: IF (NVL(p_work_order_rec.load_type,7) <> 7) THEN
96: FND_MESSAGE.SET_NAME('EAM','Incorrect Value of Load Type: '||p_work_order_rec.load_type);
97: FND_MSG_PUB.ADD();
98: RAISE FND_API.G_EXC_ERROR;
99: END IF;
100:
101: /*

Line 391: fnd_msg_pub.add();

387: end if;
388:
389: if(l_return_status <> FND_API.G_RET_STS_SUCCESS) then
390: fnd_message.set_name('EAM','EAM_CANNOT_CREAT_WRK');
391: fnd_msg_pub.add();
392: RAISE FND_API.G_EXC_ERROR;
393: end if ;
394:
395: IF FND_API.To_Boolean( p_commit ) THEN

Line 401: FND_MSG_PUB.Count_And_Get

397: END IF;
398:
399: -- End of API body.
400: -- Standard call to get message count and if count is 1, get message info.
401: FND_MSG_PUB.Count_And_Get
402: (p_count => x_msg_count,
403: p_data => x_msg_data
404: );
405: EXCEPTION

Line 410: FND_MSG_PUB.Count_And_Get

406: WHEN FND_API.G_EXC_ERROR THEN
407: ROLLBACK TO Create_EAM_Work_Order_PVT;
408: x_return_status := FND_API.G_RET_STS_ERROR ;
409: x_request_id := l_request_id;
410: FND_MSG_PUB.Count_And_Get
411: (p_count => x_msg_count,
412: p_data => x_msg_data
413: );
414: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 418: FND_MSG_PUB.Count_And_Get

414: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
415: ROLLBACK TO Create_EAM_Work_Order_PVT;
416: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
417: x_request_id := l_request_id;
418: FND_MSG_PUB.Count_And_Get
419: (p_count => x_msg_count,
420: p_data => x_msg_data
421: );
422: WHEN OTHERS THEN

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

422: WHEN OTHERS THEN
423: ROLLBACK TO Create_EAM_Work_Order_PVT;
424: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
425: x_request_id := l_request_id;
426: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
427: THEN
428: FND_MSG_PUB.Add_Exc_Msg
429: (G_PKG_NAME,
430: l_api_name

Line 428: FND_MSG_PUB.Add_Exc_Msg

424: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
425: x_request_id := l_request_id;
426: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
427: THEN
428: FND_MSG_PUB.Add_Exc_Msg
429: (G_PKG_NAME,
430: l_api_name
431: );
432: END IF;

Line 433: FND_MSG_PUB.Count_And_Get

429: (G_PKG_NAME,
430: l_api_name
431: );
432: END IF;
433: FND_MSG_PUB.Count_And_Get
434: (p_count => x_msg_count,
435: p_data => x_msg_data
436: );
437: END Create_EAM_Work_Order;

Line 478: FND_MSG_PUB.initialize;

474: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
475: END IF;
476: -- Initialize message list if p_init_msg_list is set to TRUE.
477: IF FND_API.to_Boolean( p_init_msg_list ) THEN
478: FND_MSG_PUB.initialize;
479: END IF;
480: -- Initialize API return status to success
481: x_return_status := FND_API.G_RET_STS_SUCCESS;
482: -- API body

Line 551: FND_MSG_PUB.Count_And_Get

547: IF FND_API.To_Boolean( p_commit ) THEN
548: COMMIT WORK;
549: END IF;
550: -- Standard call to get message count and if count is 1, get message info.
551: FND_MSG_PUB.Count_And_Get
552: (p_count => x_msg_count,
553: p_data => x_msg_data
554: );
555: EXCEPTION

Line 560: FND_MSG_PUB.Count_And_Get

556: WHEN FND_API.G_EXC_ERROR THEN
557: ROLLBACK TO Get_EAM_Act_Cause_Default_PVT;
558: x_return_status := FND_API.G_RET_STS_ERROR ;
559:
560: FND_MSG_PUB.Count_And_Get
561: (p_count => x_msg_count,
562: p_data => x_msg_data
563: );
564: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 568: FND_MSG_PUB.Count_And_Get

564: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
565: ROLLBACK TO Get_EAM_Act_Cause_Default_PVT;
566: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
567:
568: FND_MSG_PUB.Count_And_Get
569: (p_count => x_msg_count,
570: p_data => x_msg_data
571: );
572: WHEN OTHERS THEN

Line 576: IF FND_MSG_PUB.Check_Msg_Level

572: WHEN OTHERS THEN
573: ROLLBACK TO Get_EAM_Act_Cause_Default_PVT;
574: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
575:
576: IF FND_MSG_PUB.Check_Msg_Level
577: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
578: THEN
579: FND_MSG_PUB.Add_Exc_Msg
580: (G_PKG_NAME,

Line 577: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

573: ROLLBACK TO Get_EAM_Act_Cause_Default_PVT;
574: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
575:
576: IF FND_MSG_PUB.Check_Msg_Level
577: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
578: THEN
579: FND_MSG_PUB.Add_Exc_Msg
580: (G_PKG_NAME,
581: l_api_name

Line 579: FND_MSG_PUB.Add_Exc_Msg

575:
576: IF FND_MSG_PUB.Check_Msg_Level
577: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
578: THEN
579: FND_MSG_PUB.Add_Exc_Msg
580: (G_PKG_NAME,
581: l_api_name
582: );
583: END IF;

Line 584: FND_MSG_PUB.Count_And_Get

580: (G_PKG_NAME,
581: l_api_name
582: );
583: END IF;
584: FND_MSG_PUB.Count_And_Get
585: (p_count => x_msg_count,
586: p_data => x_msg_data
587: );
588: END Get_EAM_Act_Cause_Default;

Line 705: FND_MSG_PUB.initialize;

701: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
702: END IF;
703: -- Initialize message list if p_init_msg_list is set to TRUE.
704: IF FND_API.to_Boolean( p_init_msg_list ) THEN
705: FND_MSG_PUB.initialize;
706: END IF;
707: -- Initialize API return status to success
708: x_return_status := FND_API.G_RET_STS_SUCCESS;
709: -- API body

Line 777: FND_MSG_PUB.Count_And_Get

773: IF FND_API.To_Boolean( p_commit ) THEN
774: COMMIT WORK;
775: END IF;
776: -- Standard call to get message count and if count is 1, get message info.
777: FND_MSG_PUB.Count_And_Get
778: (p_count => x_msg_count,
779: p_data => x_msg_data
780: );
781: EXCEPTION

Line 786: FND_MSG_PUB.Count_And_Get

782: WHEN FND_API.G_EXC_ERROR THEN
783: ROLLBACK TO Get_EAM_Act_Type_Default_PVT;
784: x_return_status := FND_API.G_RET_STS_ERROR ;
785:
786: FND_MSG_PUB.Count_And_Get
787: (p_count => x_msg_count,
788: p_data => x_msg_data
789: );
790: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 794: FND_MSG_PUB.Count_And_Get

790: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
791: ROLLBACK TO Get_EAM_Act_Type_Default_PVT;
792: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
793:
794: FND_MSG_PUB.Count_And_Get
795: (p_count => x_msg_count,
796: p_data => x_msg_data
797: );
798: WHEN OTHERS THEN

Line 802: IF FND_MSG_PUB.Check_Msg_Level

798: WHEN OTHERS THEN
799: ROLLBACK TO Get_EAM_Act_Type_Default_PVT;
800: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
801:
802: IF FND_MSG_PUB.Check_Msg_Level
803: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
804: THEN
805: FND_MSG_PUB.Add_Exc_Msg
806: (G_PKG_NAME,

Line 803: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

799: ROLLBACK TO Get_EAM_Act_Type_Default_PVT;
800: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
801:
802: IF FND_MSG_PUB.Check_Msg_Level
803: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
804: THEN
805: FND_MSG_PUB.Add_Exc_Msg
806: (G_PKG_NAME,
807: l_api_name

Line 805: FND_MSG_PUB.Add_Exc_Msg

801:
802: IF FND_MSG_PUB.Check_Msg_Level
803: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
804: THEN
805: FND_MSG_PUB.Add_Exc_Msg
806: (G_PKG_NAME,
807: l_api_name
808: );
809: END IF;

Line 810: FND_MSG_PUB.Count_And_Get

806: (G_PKG_NAME,
807: l_api_name
808: );
809: END IF;
810: FND_MSG_PUB.Count_And_Get
811: (p_count => x_msg_count,
812: p_data => x_msg_data
813: );
814: END Get_EAM_Act_type_Default;

Line 856: FND_MSG_PUB.initialize;

852: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
853: END IF;
854: -- Initialize message list if p_init_msg_list is set to TRUE.
855: IF FND_API.to_Boolean( p_init_msg_list ) THEN
856: FND_MSG_PUB.initialize;
857: END IF;
858: -- Initialize API return status to success
859: x_return_status := FND_API.G_RET_STS_SUCCESS;
860: -- API body

Line 928: FND_MSG_PUB.Count_And_Get

924: IF FND_API.To_Boolean( p_commit ) THEN
925: COMMIT WORK;
926: END IF;
927: -- Standard call to get message count and if count is 1, get message info.
928: FND_MSG_PUB.Count_And_Get
929: (p_count => x_msg_count,
930: p_data => x_msg_data
931: );
932: EXCEPTION

Line 937: FND_MSG_PUB.Count_And_Get

933: WHEN FND_API.G_EXC_ERROR THEN
934: ROLLBACK TO Get_EAM_Act_Source_Default_PVT;
935: x_return_status := FND_API.G_RET_STS_ERROR ;
936:
937: FND_MSG_PUB.Count_And_Get
938: (p_count => x_msg_count,
939: p_data => x_msg_data
940: );
941: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 945: FND_MSG_PUB.Count_And_Get

941: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
942: ROLLBACK TO Get_EAM_Act_Source_Default_PVT;
943: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
944:
945: FND_MSG_PUB.Count_And_Get
946: (p_count => x_msg_count,
947: p_data => x_msg_data
948: );
949: WHEN OTHERS THEN

Line 953: IF FND_MSG_PUB.Check_Msg_Level

949: WHEN OTHERS THEN
950: ROLLBACK TO Get_EAM_Act_Source_Default_PVT;
951: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
952:
953: IF FND_MSG_PUB.Check_Msg_Level
954: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
955: THEN
956: FND_MSG_PUB.Add_Exc_Msg
957: (G_PKG_NAME,

Line 954: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

950: ROLLBACK TO Get_EAM_Act_Source_Default_PVT;
951: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
952:
953: IF FND_MSG_PUB.Check_Msg_Level
954: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
955: THEN
956: FND_MSG_PUB.Add_Exc_Msg
957: (G_PKG_NAME,
958: l_api_name

Line 956: FND_MSG_PUB.Add_Exc_Msg

952:
953: IF FND_MSG_PUB.Check_Msg_Level
954: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
955: THEN
956: FND_MSG_PUB.Add_Exc_Msg
957: (G_PKG_NAME,
958: l_api_name
959: );
960: END IF;

Line 961: FND_MSG_PUB.Count_And_Get

957: (G_PKG_NAME,
958: l_api_name
959: );
960: END IF;
961: FND_MSG_PUB.Count_And_Get
962: (p_count => x_msg_count,
963: p_data => x_msg_data
964: );
965: END Get_EAM_Act_Source_Default;

Line 1006: FND_MSG_PUB.initialize;

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

Line 1080: FND_MSG_PUB.Count_And_Get

1076: IF FND_API.To_Boolean( p_commit ) THEN
1077: COMMIT WORK;
1078: END IF;
1079: -- Standard call to get message count and if count is 1, get message info.
1080: FND_MSG_PUB.Count_And_Get
1081: (p_count => x_msg_count,
1082: p_data => x_msg_data
1083: );
1084: EXCEPTION

Line 1089: FND_MSG_PUB.Count_And_Get

1085: WHEN FND_API.G_EXC_ERROR THEN
1086: ROLLBACK TO Get_EAM_Shutdown_Default_PVT;
1087: x_return_status := FND_API.G_RET_STS_ERROR ;
1088:
1089: FND_MSG_PUB.Count_And_Get
1090: (p_count => x_msg_count,
1091: p_data => x_msg_data
1092: );
1093: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1097: FND_MSG_PUB.Count_And_Get

1093: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1094: ROLLBACK TO Get_EAM_Shutdown_Default_PVT;
1095: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1096:
1097: FND_MSG_PUB.Count_And_Get
1098: (p_count => x_msg_count,
1099: p_data => x_msg_data
1100: );
1101: WHEN OTHERS THEN

Line 1105: IF FND_MSG_PUB.Check_Msg_Level

1101: WHEN OTHERS THEN
1102: ROLLBACK TO Get_EAM_Shutdown_Default_PVT;
1103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1104:
1105: IF FND_MSG_PUB.Check_Msg_Level
1106: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1107: THEN
1108: FND_MSG_PUB.Add_Exc_Msg
1109: (G_PKG_NAME,

Line 1106: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1102: ROLLBACK TO Get_EAM_Shutdown_Default_PVT;
1103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1104:
1105: IF FND_MSG_PUB.Check_Msg_Level
1106: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1107: THEN
1108: FND_MSG_PUB.Add_Exc_Msg
1109: (G_PKG_NAME,
1110: l_api_name

Line 1108: FND_MSG_PUB.Add_Exc_Msg

1104:
1105: IF FND_MSG_PUB.Check_Msg_Level
1106: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1107: THEN
1108: FND_MSG_PUB.Add_Exc_Msg
1109: (G_PKG_NAME,
1110: l_api_name
1111: );
1112: END IF;

Line 1113: FND_MSG_PUB.Count_And_Get

1109: (G_PKG_NAME,
1110: l_api_name
1111: );
1112: END IF;
1113: FND_MSG_PUB.Count_And_Get
1114: (p_count => x_msg_count,
1115: p_data => x_msg_data
1116: );
1117: END Get_EAM_Shutdown_Default;

Line 1159: FND_MSG_PUB.initialize;

1155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1156: END IF;
1157: -- Initialize message list if p_init_msg_list is set to TRUE.
1158: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1159: FND_MSG_PUB.initialize;
1160: END IF;
1161: -- Initialize API return status to success
1162: x_return_status := FND_API.G_RET_STS_SUCCESS;
1163: -- API body

Line 1238: FND_MSG_PUB.Count_And_Get

1234: IF FND_API.To_Boolean( p_commit ) THEN
1235: COMMIT WORK;
1236: END IF;
1237: -- Standard call to get message count and if count is 1, get message info.
1238: FND_MSG_PUB.Count_And_Get
1239: (p_count => x_msg_count,
1240: p_data => x_msg_data
1241: );
1242: EXCEPTION

Line 1247: FND_MSG_PUB.Count_And_Get

1243: WHEN FND_API.G_EXC_ERROR THEN
1244: ROLLBACK TO Get_EAM_Notification_Def_PVT;
1245: x_return_status := FND_API.G_RET_STS_ERROR ;
1246:
1247: FND_MSG_PUB.Count_And_Get
1248: (p_count => x_msg_count,
1249: p_data => x_msg_data
1250: );
1251: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1255: FND_MSG_PUB.Count_And_Get

1251: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1252: ROLLBACK TO Get_EAM_Notification_Def_PVT;
1253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1254:
1255: FND_MSG_PUB.Count_And_Get
1256: (p_count => x_msg_count,
1257: p_data => x_msg_data
1258: );
1259: WHEN OTHERS THEN

Line 1263: IF FND_MSG_PUB.Check_Msg_Level

1259: WHEN OTHERS THEN
1260: ROLLBACK TO Get_EAM_Notification_Def_PVT;
1261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1262:
1263: IF FND_MSG_PUB.Check_Msg_Level
1264: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1265: THEN
1266: FND_MSG_PUB.Add_Exc_Msg
1267: (G_PKG_NAME,

Line 1264: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1260: ROLLBACK TO Get_EAM_Notification_Def_PVT;
1261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1262:
1263: IF FND_MSG_PUB.Check_Msg_Level
1264: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1265: THEN
1266: FND_MSG_PUB.Add_Exc_Msg
1267: (G_PKG_NAME,
1268: l_api_name

Line 1266: FND_MSG_PUB.Add_Exc_Msg

1262:
1263: IF FND_MSG_PUB.Check_Msg_Level
1264: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1265: THEN
1266: FND_MSG_PUB.Add_Exc_Msg
1267: (G_PKG_NAME,
1268: l_api_name
1269: );
1270: END IF;

Line 1271: FND_MSG_PUB.Count_And_Get

1267: (G_PKG_NAME,
1268: l_api_name
1269: );
1270: END IF;
1271: FND_MSG_PUB.Count_And_Get
1272: (p_count => x_msg_count,
1273: p_data => x_msg_data
1274: );
1275: END Get_EAM_Notification_Default;

Line 1317: FND_MSG_PUB.initialize;

1313: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1314: END IF;
1315: -- Initialize message list if p_init_msg_list is set to TRUE.
1316: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1317: FND_MSG_PUB.initialize;
1318: END IF;
1319: -- Initialize API return status to success
1320: x_return_status := FND_API.G_RET_STS_SUCCESS;
1321: -- API body

Line 1375: FND_MSG_PUB.Count_And_Get

1371: IF FND_API.To_Boolean( p_commit ) THEN
1372: COMMIT WORK;
1373: END IF;
1374: -- Standard call to get message count and if count is 1, get message info.
1375: FND_MSG_PUB.Count_And_Get
1376: (p_count => x_msg_count,
1377: p_data => x_msg_data
1378: );
1379: EXCEPTION

Line 1384: FND_MSG_PUB.Count_And_Get

1380: WHEN FND_API.G_EXC_ERROR THEN
1381: ROLLBACK TO Get_EAM_Tagout_Default_PVT;
1382: x_return_status := FND_API.G_RET_STS_ERROR ;
1383:
1384: FND_MSG_PUB.Count_And_Get
1385: (p_count => x_msg_count,
1386: p_data => x_msg_data
1387: );
1388: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1392: FND_MSG_PUB.Count_And_Get

1388: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1389: ROLLBACK TO Get_EAM_Tagout_Default_PVT;
1390: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1391:
1392: FND_MSG_PUB.Count_And_Get
1393: (p_count => x_msg_count,
1394: p_data => x_msg_data
1395: );
1396: WHEN OTHERS THEN

Line 1400: IF FND_MSG_PUB.Check_Msg_Level

1396: WHEN OTHERS THEN
1397: ROLLBACK TO Get_EAM_Tagout_Default_PVT;
1398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1399:
1400: IF FND_MSG_PUB.Check_Msg_Level
1401: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1402: THEN
1403: FND_MSG_PUB.Add_Exc_Msg
1404: (G_PKG_NAME,

Line 1401: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1397: ROLLBACK TO Get_EAM_Tagout_Default_PVT;
1398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1399:
1400: IF FND_MSG_PUB.Check_Msg_Level
1401: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1402: THEN
1403: FND_MSG_PUB.Add_Exc_Msg
1404: (G_PKG_NAME,
1405: l_api_name

Line 1403: FND_MSG_PUB.Add_Exc_Msg

1399:
1400: IF FND_MSG_PUB.Check_Msg_Level
1401: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1402: THEN
1403: FND_MSG_PUB.Add_Exc_Msg
1404: (G_PKG_NAME,
1405: l_api_name
1406: );
1407: END IF;

Line 1408: FND_MSG_PUB.Count_And_Get

1404: (G_PKG_NAME,
1405: l_api_name
1406: );
1407: END IF;
1408: FND_MSG_PUB.Count_And_Get
1409: (p_count => x_msg_count,
1410: p_data => x_msg_data
1411: );
1412: END Get_EAM_Tagout_Default;

Line 1455: FND_MSG_PUB.initialize;

1451: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1452: END IF;
1453: -- Initialize message list if p_init_msg_list is set to TRUE.
1454: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1455: FND_MSG_PUB.initialize;
1456: END IF;
1457: -- Initialize API return status to success
1458: x_return_status := FND_API.G_RET_STS_SUCCESS;
1459: -- API body

Line 1538: FND_MSG_PUB.Count_And_Get

1534: IF FND_API.To_Boolean( p_commit ) THEN
1535: COMMIT WORK;
1536: END IF;
1537: -- Standard call to get message count and if count is 1, get message info.
1538: FND_MSG_PUB.Count_And_Get
1539: (p_count => x_msg_count,
1540: p_data => x_msg_data
1541: );
1542: EXCEPTION

Line 1547: FND_MSG_PUB.Count_And_Get

1543: WHEN FND_API.G_EXC_ERROR THEN
1544: ROLLBACK TO Get_EAM_Owning_Dept_Def_PVT;
1545: x_return_status := FND_API.G_RET_STS_ERROR ;
1546:
1547: FND_MSG_PUB.Count_And_Get
1548: (p_count => x_msg_count,
1549: p_data => x_msg_data
1550: );
1551: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1555: FND_MSG_PUB.Count_And_Get

1551: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1552: ROLLBACK TO Get_EAM_Owning_Dept_Def_PVT;
1553: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1554:
1555: FND_MSG_PUB.Count_And_Get
1556: (p_count => x_msg_count,
1557: p_data => x_msg_data
1558: );
1559: WHEN OTHERS THEN

Line 1563: IF FND_MSG_PUB.Check_Msg_Level

1559: WHEN OTHERS THEN
1560: ROLLBACK TO Get_EAM_Owning_Dept_Def_PVT;
1561: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1562:
1563: IF FND_MSG_PUB.Check_Msg_Level
1564: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1565: THEN
1566: FND_MSG_PUB.Add_Exc_Msg
1567: (G_PKG_NAME,

Line 1564: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1560: ROLLBACK TO Get_EAM_Owning_Dept_Def_PVT;
1561: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1562:
1563: IF FND_MSG_PUB.Check_Msg_Level
1564: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1565: THEN
1566: FND_MSG_PUB.Add_Exc_Msg
1567: (G_PKG_NAME,
1568: l_api_name

Line 1566: FND_MSG_PUB.Add_Exc_Msg

1562:
1563: IF FND_MSG_PUB.Check_Msg_Level
1564: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1565: THEN
1566: FND_MSG_PUB.Add_Exc_Msg
1567: (G_PKG_NAME,
1568: l_api_name
1569: );
1570: END IF;

Line 1571: FND_MSG_PUB.Count_And_Get

1567: (G_PKG_NAME,
1568: l_api_name
1569: );
1570: END IF;
1571: FND_MSG_PUB.Count_And_Get
1572: (p_count => x_msg_count,
1573: p_data => x_msg_data
1574: );
1575: END Get_EAM_Owning_Dept_Default;

Line 1615: FND_MSG_PUB.initialize;

1611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1612: END IF;
1613: -- Initialize message list if p_init_msg_list is set to TRUE.
1614: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1615: FND_MSG_PUB.initialize;
1616: END IF;
1617: -- Initialize API return status to success
1618: x_return_status := FND_API.G_RET_STS_SUCCESS;
1619: -- API body

Line 1645: FND_MSG_PUB.Count_And_Get

1641: IF FND_API.To_Boolean( p_commit ) THEN
1642: COMMIT WORK;
1643: END IF;
1644: -- Standard call to get message count and if count is 1, get message info.
1645: FND_MSG_PUB.Count_And_Get
1646: (p_count => x_msg_count,
1647: p_data => x_msg_data
1648: );
1649: EXCEPTION

Line 1654: FND_MSG_PUB.Count_And_Get

1650: WHEN FND_API.G_EXC_ERROR THEN
1651: ROLLBACK TO Get_EAM_ACT_WO_Type_Def_PVT;
1652: x_return_status := FND_API.G_RET_STS_ERROR ;
1653:
1654: FND_MSG_PUB.Count_And_Get
1655: (p_count => x_msg_count,
1656: p_data => x_msg_data
1657: );
1658: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1662: FND_MSG_PUB.Count_And_Get

1658: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1659: ROLLBACK TO Get_EAM_ACT_WO_Type_Def_PVT;
1660: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1661:
1662: FND_MSG_PUB.Count_And_Get
1663: (p_count => x_msg_count,
1664: p_data => x_msg_data
1665: );
1666: WHEN OTHERS THEN

Line 1670: IF FND_MSG_PUB.Check_Msg_Level

1666: WHEN OTHERS THEN
1667: ROLLBACK TO Get_EAM_ACT_WO_Type_Def_PVT;
1668: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1669:
1670: IF FND_MSG_PUB.Check_Msg_Level
1671: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1672: THEN
1673: FND_MSG_PUB.Add_Exc_Msg
1674: (G_PKG_NAME,

Line 1671: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1667: ROLLBACK TO Get_EAM_ACT_WO_Type_Def_PVT;
1668: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1669:
1670: IF FND_MSG_PUB.Check_Msg_Level
1671: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1672: THEN
1673: FND_MSG_PUB.Add_Exc_Msg
1674: (G_PKG_NAME,
1675: l_api_name

Line 1673: FND_MSG_PUB.Add_Exc_Msg

1669:
1670: IF FND_MSG_PUB.Check_Msg_Level
1671: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1672: THEN
1673: FND_MSG_PUB.Add_Exc_Msg
1674: (G_PKG_NAME,
1675: l_api_name
1676: );
1677: END IF;

Line 1678: FND_MSG_PUB.Count_And_Get

1674: (G_PKG_NAME,
1675: l_api_name
1676: );
1677: END IF;
1678: FND_MSG_PUB.Count_And_Get
1679: (p_count => x_msg_count,
1680: p_data => x_msg_data
1681: );
1682:

Line 1718: FND_MSG_PUB.initialize;

1714: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1715: END IF;
1716: -- Initialize message list if p_init_msg_list is set to TRUE.
1717: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1718: FND_MSG_PUB.initialize;
1719: END IF;
1720: -- Initialize API return status to success
1721: x_return_status := FND_API.G_RET_STS_SUCCESS;
1722: -- API body

Line 1747: FND_MSG_PUB.Count_And_Get

1743: IF FND_API.To_Boolean( p_commit ) THEN
1744: COMMIT WORK;
1745: END IF;
1746: -- Standard call to get message count and if count is 1, get message info.
1747: FND_MSG_PUB.Count_And_Get
1748: (p_count => x_msg_count,
1749: p_data => x_msg_data
1750: );
1751: EXCEPTION

Line 1756: FND_MSG_PUB.Count_And_Get

1752: WHEN FND_API.G_EXC_ERROR THEN
1753: ROLLBACK TO Get_EAM_ACT_Planner_Def_PVT;
1754: x_return_status := FND_API.G_RET_STS_ERROR ;
1755:
1756: FND_MSG_PUB.Count_And_Get
1757: (p_count => x_msg_count,
1758: p_data => x_msg_data
1759: );
1760: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1764: FND_MSG_PUB.Count_And_Get

1760: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1761: ROLLBACK TO Get_EAM_ACT_Planner_Def_PVT;
1762: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1763:
1764: FND_MSG_PUB.Count_And_Get
1765: (p_count => x_msg_count,
1766: p_data => x_msg_data
1767: );
1768: WHEN OTHERS THEN

Line 1772: IF FND_MSG_PUB.Check_Msg_Level

1768: WHEN OTHERS THEN
1769: ROLLBACK TO Get_EAM_ACT_Planner_Def_PVT;
1770: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1771:
1772: IF FND_MSG_PUB.Check_Msg_Level
1773: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1774: THEN
1775: FND_MSG_PUB.Add_Exc_Msg
1776: (G_PKG_NAME,

Line 1773: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1769: ROLLBACK TO Get_EAM_ACT_Planner_Def_PVT;
1770: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1771:
1772: IF FND_MSG_PUB.Check_Msg_Level
1773: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1774: THEN
1775: FND_MSG_PUB.Add_Exc_Msg
1776: (G_PKG_NAME,
1777: l_api_name

Line 1775: FND_MSG_PUB.Add_Exc_Msg

1771:
1772: IF FND_MSG_PUB.Check_Msg_Level
1773: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1774: THEN
1775: FND_MSG_PUB.Add_Exc_Msg
1776: (G_PKG_NAME,
1777: l_api_name
1778: );
1779: END IF;

Line 1780: FND_MSG_PUB.Count_And_Get

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

Line 1819: FND_MSG_PUB.initialize;

1815: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1816: END IF;
1817: -- Initialize message list if p_init_msg_list is set to TRUE.
1818: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1819: FND_MSG_PUB.initialize;
1820: END IF;
1821: -- Initialize API return status to success
1822: x_return_status := FND_API.G_RET_STS_SUCCESS;
1823: -- API body

Line 1848: FND_MSG_PUB.Count_And_Get

1844: IF FND_API.To_Boolean( p_commit ) THEN
1845: COMMIT WORK;
1846: END IF;
1847: -- Standard call to get message count and if count is 1, get message info.
1848: FND_MSG_PUB.Count_And_Get
1849: (p_count => x_msg_count,
1850: p_data => x_msg_data
1851: );
1852: EXCEPTION

Line 1857: FND_MSG_PUB.Count_And_Get

1853: WHEN FND_API.G_EXC_ERROR THEN
1854: ROLLBACK TO Get_EAM_ACT_Firm_Def_PVT;
1855: x_return_status := FND_API.G_RET_STS_ERROR ;
1856:
1857: FND_MSG_PUB.Count_And_Get
1858: (p_count => x_msg_count,
1859: p_data => x_msg_data
1860: );
1861: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1865: FND_MSG_PUB.Count_And_Get

1861: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1862: ROLLBACK TO Get_EAM_ACT_Firm_Def_PVT;
1863: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1864:
1865: FND_MSG_PUB.Count_And_Get
1866: (p_count => x_msg_count,
1867: p_data => x_msg_data
1868: );
1869: WHEN OTHERS THEN

Line 1873: IF FND_MSG_PUB.Check_Msg_Level

1869: WHEN OTHERS THEN
1870: ROLLBACK TO Get_EAM_ACT_Firm_Def_PVT;
1871: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1872:
1873: IF FND_MSG_PUB.Check_Msg_Level
1874: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1875: THEN
1876: FND_MSG_PUB.Add_Exc_Msg
1877: (G_PKG_NAME,

Line 1874: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1870: ROLLBACK TO Get_EAM_ACT_Firm_Def_PVT;
1871: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1872:
1873: IF FND_MSG_PUB.Check_Msg_Level
1874: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1875: THEN
1876: FND_MSG_PUB.Add_Exc_Msg
1877: (G_PKG_NAME,
1878: l_api_name

Line 1876: FND_MSG_PUB.Add_Exc_Msg

1872:
1873: IF FND_MSG_PUB.Check_Msg_Level
1874: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1875: THEN
1876: FND_MSG_PUB.Add_Exc_Msg
1877: (G_PKG_NAME,
1878: l_api_name
1879: );
1880: END IF;

Line 1881: FND_MSG_PUB.Count_And_Get

1877: (G_PKG_NAME,
1878: l_api_name
1879: );
1880: END IF;
1881: FND_MSG_PUB.Count_And_Get
1882: (p_count => x_msg_count,
1883: p_data => x_msg_data
1884: );
1885: END Get_EAM_ACT_Firm_Default;

Line 1920: FND_MSG_PUB.initialize;

1916: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1917: END IF;
1918: -- Initialize message list if p_init_msg_list is set to TRUE.
1919: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1920: FND_MSG_PUB.initialize;
1921: END IF;
1922: -- Initialize API return status to success
1923: x_return_status := FND_API.G_RET_STS_SUCCESS;
1924: -- API body

Line 1949: FND_MSG_PUB.Count_And_Get

1945: IF FND_API.To_Boolean( p_commit ) THEN
1946: COMMIT WORK;
1947: END IF;
1948: -- Standard call to get message count and if count is 1, get message info.
1949: FND_MSG_PUB.Count_And_Get
1950: (p_count => x_msg_count,
1951: p_data => x_msg_data
1952: );
1953: EXCEPTION

Line 1958: FND_MSG_PUB.Count_And_Get

1954: WHEN FND_API.G_EXC_ERROR THEN
1955: ROLLBACK TO Get_EAM_ACT_Planned_Def_PVT;
1956: x_return_status := FND_API.G_RET_STS_ERROR ;
1957:
1958: FND_MSG_PUB.Count_And_Get
1959: (p_count => x_msg_count,
1960: p_data => x_msg_data
1961: );
1962: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1966: FND_MSG_PUB.Count_And_Get

1962: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1963: ROLLBACK TO Get_EAM_ACT_Planned_Def_PVT;
1964: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1965:
1966: FND_MSG_PUB.Count_And_Get
1967: (p_count => x_msg_count,
1968: p_data => x_msg_data
1969: );
1970: WHEN OTHERS THEN

Line 1974: IF FND_MSG_PUB.Check_Msg_Level

1970: WHEN OTHERS THEN
1971: ROLLBACK TO Get_EAM_ACT_Planned_Def_PVT;
1972: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1973:
1974: IF FND_MSG_PUB.Check_Msg_Level
1975: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1976: THEN
1977: FND_MSG_PUB.Add_Exc_Msg
1978: (G_PKG_NAME,

Line 1975: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1971: ROLLBACK TO Get_EAM_ACT_Planned_Def_PVT;
1972: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1973:
1974: IF FND_MSG_PUB.Check_Msg_Level
1975: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1976: THEN
1977: FND_MSG_PUB.Add_Exc_Msg
1978: (G_PKG_NAME,
1979: l_api_name

Line 1977: FND_MSG_PUB.Add_Exc_Msg

1973:
1974: IF FND_MSG_PUB.Check_Msg_Level
1975: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1976: THEN
1977: FND_MSG_PUB.Add_Exc_Msg
1978: (G_PKG_NAME,
1979: l_api_name
1980: );
1981: END IF;

Line 1982: FND_MSG_PUB.Count_And_Get

1978: (G_PKG_NAME,
1979: l_api_name
1980: );
1981: END IF;
1982: FND_MSG_PUB.Count_And_Get
1983: (p_count => x_msg_count,
1984: p_data => x_msg_data
1985: );
1986: END Get_EAM_ACT_Planned_Default;