DBA Data[Home] [Help]

APPS.EAM_PMDEF_PUB dependencies on FND_MSG_PUB

Line 101: FND_MSG_PUB.Add;

97:
98: -- Check that enough info is supplied to identify which pm schedule to copy from.
99: if (p_pm_schedule_id is null) then
100: FND_MESSAGE.SET_NAME ('EAM', 'EAM_MT_SUPPLY_PARAMS');
101: FND_MSG_PUB.Add;
102: RAISE FND_API.G_EXC_ERROR;
103: end if;
104:
105: begin

Line 166: FND_MSG_PUB.Add;

162: where pm_schedule_id=p_pm_schedule_id;
163: exception
164: when no_data_found then
165: FND_MESSAGE.SET_NAME ('EAM', 'EAM_MT_SUPPLY_PARAMS');
166: FND_MSG_PUB.Add;
167: RAISE FND_API.G_EXC_ERROR;
168: end;
169:
170: select eam_pm_schedulings_s.nextval into l_pm_schedule_id from dual;

Line 175: FND_MSG_PUB.Add;

171:
172: -- If the source pm is not a template, raise error
173: if (not (pm_header_row.tmpl_flag = 'Y')) then
174: FND_MESSAGE.SET_NAME('EAM', 'EAM_PM_INST_NOT_TMPL');
175: FND_MSG_PUB.Add;
176: RAISE FND_API.G_EXC_ERROR;
177: else
178: -- When instantiating, tmpl_flag should be 'N'
179: pm_header_row.tmpl_flag:='N';

Line 199: FND_MSG_PUB.Add;

195:
196: exception
197: when no_data_found then
198: FND_MESSAGE.SET_NAME ('EAM', 'EAM_MT_SUPPLY_PARAMS');
199: FND_MSG_PUB.Add;
200: RAISE FND_API.G_EXC_ERROR;
201: end;
202: end if;
203:

Line 529: FND_MSG_PUB.get

525: x_return_status := fnd_api.g_ret_sts_error;
526: x_msg_count := 1;
527: x_msg_data := l_msg_data;
528: else
529: FND_MSG_PUB.get
530: ( p_msg_index_out => x_msg_count ,
531: p_data => x_msg_data
532: );
533: x_msg_data := substr(x_msg_data,1,2000);

Line 621: FND_MSG_PUB.initialize;

617: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
618: END IF;
619: -- Initialize message list if p_init_msg_list is set to TRUE.
620: IF FND_API.to_Boolean( p_init_msg_list ) THEN
621: FND_MSG_PUB.initialize;
622: END IF;
623: -- Initialize API return status to success
624: x_return_status := FND_API.G_RET_STS_SUCCESS;
625: -- API body

Line 684: FND_MSG_PUB.get

680: IF FND_API.To_Boolean( p_commit ) THEN
681: COMMIT WORK;
682: END IF;
683: -- Standard call to get message count and if count is 1, get message info.
684: FND_MSG_PUB.get
685: ( p_msg_index_out => x_msg_count ,
686: p_data => x_msg_data
687: );
688: x_msg_data := substr(x_msg_data,1,2000);

Line 693: FND_MSG_PUB.get

689: EXCEPTION
690: WHEN FND_API.G_EXC_ERROR THEN
691: ROLLBACK TO instantiate_PM_Defs_pvt;
692: x_return_status := FND_API.G_RET_STS_ERROR ;
693: FND_MSG_PUB.get
694: ( p_msg_index_out => x_msg_count ,
695: p_data => x_msg_data
696: );
697: x_msg_data := substr(x_msg_data,1,2000);

Line 701: FND_MSG_PUB.get

697: x_msg_data := substr(x_msg_data,1,2000);
698: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
699: ROLLBACK TO instantiate_PM_Defs_pvt;
700: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
701: FND_MSG_PUB.get
702: ( p_msg_index_out => x_msg_count ,
703: p_data => x_msg_data
704: );
705: x_msg_data := substr(x_msg_data,1,2000);

Line 709: IF FND_MSG_PUB.Check_Msg_Level

705: x_msg_data := substr(x_msg_data,1,2000);
706: WHEN OTHERS THEN
707: ROLLBACK TO instantiate_PM_Defs_pvt;
708: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
709: IF FND_MSG_PUB.Check_Msg_Level
710: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
711: THEN
712: FND_MSG_PUB.Add_Exc_Msg
713: ( G_PKG_NAME ,

Line 710: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

706: WHEN OTHERS THEN
707: ROLLBACK TO instantiate_PM_Defs_pvt;
708: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
709: IF FND_MSG_PUB.Check_Msg_Level
710: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
711: THEN
712: FND_MSG_PUB.Add_Exc_Msg
713: ( G_PKG_NAME ,
714: l_api_name

Line 712: FND_MSG_PUB.Add_Exc_Msg

708: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
709: IF FND_MSG_PUB.Check_Msg_Level
710: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
711: THEN
712: FND_MSG_PUB.Add_Exc_Msg
713: ( G_PKG_NAME ,
714: l_api_name
715: );
716: END IF;

Line 717: FND_MSG_PUB.get

713: ( G_PKG_NAME ,
714: l_api_name
715: );
716: END IF;
717: FND_MSG_PUB.get
718: ( p_msg_index_out => x_msg_count ,
719: p_data => x_msg_data
720: );
721: x_msg_data := substr(x_msg_data,1,2000);

Line 771: FND_MSG_PUB.initialize;

767: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
768: END IF;
769: -- Initialize message list if p_init_msg_list is set to TRUE.
770: IF FND_API.to_Boolean( p_init_msg_list ) THEN
771: FND_MSG_PUB.initialize;
772: END IF;
773: -- Initialize API return status to success
774: x_return_status := FND_API.G_RET_STS_SUCCESS;
775:

Line 793: FND_MSG_PUB.Add;

789: );
790:
791: if (not l_validated) then
792: FND_MESSAGE.SET_NAME ('EAM', l_reason_failed);
793: FND_MSG_PUB.Add;
794: RAISE FND_API.G_EXC_ERROR;
795: end if;
796:
797: l_validated := validate_pm_activities

Line 808: FND_MSG_PUB.Add;

804: l_act_names
805: );
806: if (not l_validated) then
807: FND_MESSAGE.SET_NAME ('EAM', l_reason_failed);
808: FND_MSG_PUB.Add;
809: RAISE FND_API.G_EXC_ERROR;
810: end if;
811: /* Validation generate_next_work_order */
812: if ( not (p_pm_schedule_rec.generate_next_work_order = 'Y'

Line 817: FND_MSG_PUB.Add;

813: OR p_pm_schedule_rec.generate_next_work_order = 'N'
814: OR p_pm_schedule_rec.generate_next_work_order is null)) then
815:
816: FND_MESSAGE.SET_NAME ('EAM', 'INVALID_GENERATE_NEXT_WORK_ORDER');
817: FND_MSG_PUB.Add;
818: RAISE FND_API.G_EXC_ERROR;
819:
820: end if;
821:

Line 849: FND_MSG_PUB.Add;

845:
846: IF (not l_validated) THEN
847: FND_MESSAGE.SET_NAME('EAM', 'EAM_INVALID_DESC_FLEX');
848: FND_MESSAGE.SET_TOKEN('ERROR_MSG', x_error_message);
849: FND_MSG_PUB.Add;
850: RAISE FND_API.G_EXC_ERROR;
851: END IF;
852:
853: select eam_pm_schedulings_s.nextval into l_pm_schedule_id from dual;

Line 1147: FND_MSG_PUB.get

1143: IF FND_API.To_Boolean( p_commit ) THEN
1144: COMMIT WORK;
1145: END IF;
1146: -- Standard call to get message count and if count is 1, get message info.
1147: FND_MSG_PUB.get
1148: ( p_msg_index_out => x_msg_count ,
1149: p_data => x_msg_data
1150: );
1151: x_msg_data := substr(x_msg_data,1,2000);

Line 1156: FND_MSG_PUB.get

1152: EXCEPTION
1153: WHEN FND_API.G_EXC_ERROR THEN
1154: ROLLBACK TO create_PM_def_pub;
1155: x_return_status := FND_API.G_RET_STS_ERROR ;
1156: FND_MSG_PUB.get
1157: ( p_msg_index_out => x_msg_count ,
1158: p_data => x_msg_data
1159: );
1160: x_msg_data := substr(x_msg_data,1,2000);

Line 1164: FND_MSG_PUB.get

1160: x_msg_data := substr(x_msg_data,1,2000);
1161: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1162: ROLLBACK TO create_PM_def_pub;
1163: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1164: FND_MSG_PUB.get
1165: ( p_msg_index_out => x_msg_count ,
1166: p_data => x_msg_data
1167: );
1168: x_msg_data := substr(x_msg_data,1,2000);

Line 1172: IF FND_MSG_PUB.Check_Msg_Level

1168: x_msg_data := substr(x_msg_data,1,2000);
1169: WHEN OTHERS THEN
1170: ROLLBACK TO create_PM_def_pub;
1171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1172: IF FND_MSG_PUB.Check_Msg_Level
1173: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1174: THEN
1175: FND_MSG_PUB.Add_Exc_Msg
1176: ( G_PKG_NAME ,

Line 1173: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1169: WHEN OTHERS THEN
1170: ROLLBACK TO create_PM_def_pub;
1171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1172: IF FND_MSG_PUB.Check_Msg_Level
1173: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1174: THEN
1175: FND_MSG_PUB.Add_Exc_Msg
1176: ( G_PKG_NAME ,
1177: l_api_name

Line 1175: FND_MSG_PUB.Add_Exc_Msg

1171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1172: IF FND_MSG_PUB.Check_Msg_Level
1173: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1174: THEN
1175: FND_MSG_PUB.Add_Exc_Msg
1176: ( G_PKG_NAME ,
1177: l_api_name
1178: );
1179: END IF;

Line 1180: FND_MSG_PUB.get

1176: ( G_PKG_NAME ,
1177: l_api_name
1178: );
1179: END IF;
1180: FND_MSG_PUB.get
1181: ( p_msg_index_out => x_msg_count ,
1182: p_data => x_msg_data
1183: );
1184: x_msg_data := substr(x_msg_data,1,2000);

Line 1245: FND_MSG_PUB.initialize;

1241: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1242: END IF;
1243: -- Initialize message list if p_init_msg_list is set to TRUE.
1244: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1245: FND_MSG_PUB.initialize;
1246: END IF;
1247: -- Initialize API return status to success
1248: x_return_status := FND_API.G_RET_STS_SUCCESS;
1249: -- API body

Line 1253: FND_MSG_PUB.Add;

1249: -- API body
1250:
1251: if (p_pm_schedule_rec.pm_schedule_id is null) then
1252: FND_MESSAGE.SET_NAME ('EAM', 'EAM_PM_SCHEDULE_ID_MISSING');
1253: FND_MSG_PUB.Add;
1254: RAISE FND_API.G_EXC_ERROR;
1255: else
1256: l_pm_schedule_id:=p_pm_schedule_rec.pm_schedule_id;
1257: end if;

Line 1265: FND_MSG_PUB.Add;

1261: if ( not (p_pm_schedule_rec.generate_next_work_order = 'Y'
1262: OR p_pm_schedule_rec.generate_next_work_order = 'N'
1263: OR p_pm_schedule_rec.generate_next_work_order is null)) then
1264: FND_MESSAGE.SET_NAME ('EAM', 'INVALID_GENERATE_NEXT_WORK_ORDER');
1265: FND_MSG_PUB.Add;
1266: RAISE FND_API.G_EXC_ERROR;
1267:
1268: end if;
1269: /* Validating the DFF */

Line 1294: FND_MSG_PUB.Add;

1290: x_error_segments => x_error_segments ,
1291: x_error_message => x_error_message);
1292: IF (not l_validated) THEN
1293: FND_MESSAGE.SET_NAME ('EAM', x_error_message);
1294: FND_MSG_PUB.Add;
1295: RAISE FND_API.G_EXC_ERROR;
1296: END IF;
1297:
1298:

Line 1459: FND_MSG_PUB.Add;

1455: end loop; -- end for loop that loop through 3 tables
1456:
1457: else -- rules did not validate
1458: FND_MESSAGE.SET_NAME ('EAM', l_reason_failed);
1459: FND_MSG_PUB.Add;
1460: RAISE FND_API.G_EXC_ERROR;
1461: end if;
1462:
1463: -- End of API body.

Line 1469: FND_MSG_PUB.get

1465: IF FND_API.To_Boolean( p_commit ) THEN
1466: COMMIT WORK;
1467: END IF;
1468: -- Standard call to get message count and if count is 1, get message info.
1469: FND_MSG_PUB.get
1470: ( p_msg_index_out => x_msg_count ,
1471: p_data => x_msg_data
1472: );
1473: x_msg_data := substr(x_msg_data,1,2000);

Line 1478: FND_MSG_PUB.get

1474: EXCEPTION
1475: WHEN FND_API.G_EXC_ERROR THEN
1476: ROLLBACK TO update_pm_def_pub;
1477: x_return_status := FND_API.G_RET_STS_ERROR ;
1478: FND_MSG_PUB.get
1479: ( p_msg_index_out => x_msg_count ,
1480: p_data => x_msg_data
1481: );
1482: x_msg_data := substr(x_msg_data,1,2000);

Line 1486: FND_MSG_PUB.get

1482: x_msg_data := substr(x_msg_data,1,2000);
1483: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1484: ROLLBACK TO update_pm_def_pub;
1485: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1486: FND_MSG_PUB.get
1487: ( p_msg_index_out => x_msg_count ,
1488: p_data => x_msg_data
1489: );
1490: x_msg_data := substr(x_msg_data,1,2000);

Line 1494: IF FND_MSG_PUB.Check_Msg_Level

1490: x_msg_data := substr(x_msg_data,1,2000);
1491: WHEN OTHERS THEN
1492: ROLLBACK TO update_pm_def_pub;
1493: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1494: IF FND_MSG_PUB.Check_Msg_Level
1495: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1496: THEN
1497: FND_MSG_PUB.Add_Exc_Msg
1498: ( G_PKG_NAME ,

Line 1495: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1491: WHEN OTHERS THEN
1492: ROLLBACK TO update_pm_def_pub;
1493: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1494: IF FND_MSG_PUB.Check_Msg_Level
1495: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1496: THEN
1497: FND_MSG_PUB.Add_Exc_Msg
1498: ( G_PKG_NAME ,
1499: l_api_name

Line 1497: FND_MSG_PUB.Add_Exc_Msg

1493: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1494: IF FND_MSG_PUB.Check_Msg_Level
1495: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1496: THEN
1497: FND_MSG_PUB.Add_Exc_Msg
1498: ( G_PKG_NAME ,
1499: l_api_name
1500: );
1501: END IF;

Line 1502: FND_MSG_PUB.get

1498: ( G_PKG_NAME ,
1499: l_api_name
1500: );
1501: END IF;
1502: FND_MSG_PUB.get
1503: ( p_msg_index_out => x_msg_count ,
1504: p_data => x_msg_data
1505: );
1506: x_msg_data := substr(x_msg_data,1,2000);

Line 2925: FND_MSG_PUB.Add;

2921: x_return_status:='S';
2922: -- Check that enough info is supplied to identify which pm schedule to copy from.
2923: if (p_pm_schedule_id is null) then
2924: FND_MESSAGE.SET_NAME ('EAM', 'EAM_MT_SUPPLY_PARAMS');
2925: FND_MSG_PUB.Add;
2926: RAISE FND_API.G_EXC_ERROR;
2927: end if;
2928:
2929: --getting the scheduling option for the pm schedule

Line 2938: FND_MSG_PUB.Add;

2934:
2935: --mandatory checking for rescheduling and current interval values
2936: if (l_rescheduling_point is null) then
2937: FND_MESSAGE.SET_NAME ('EAM', 'EAM_PM_NO_RESCHED');
2938: FND_MSG_PUB.Add;
2939: RAISE FND_API.G_EXC_ERROR;
2940: end if;
2941:
2942: if (l_current_seq is null) then

Line 2944: FND_MSG_PUB.Add;

2940: end if;
2941:
2942: if (l_current_seq is null) then
2943: FND_MESSAGE.SET_NAME ('EAM', 'EAM_PM_NO_CURRENTSEQ');
2944: FND_MSG_PUB.Add;
2945: RAISE FND_API.G_EXC_ERROR;
2946: end if;
2947:
2948: --based on current sequence retrieve

Line 3045: FND_MSG_PUB.get

3041:
3042: EXCEPTION
3043: WHEN FND_API.G_EXC_ERROR THEN
3044: x_return_status := FND_API.G_RET_STS_ERROR ;
3045: FND_MSG_PUB.get
3046: ( p_msg_index_out => x_msg_count ,
3047: p_data => x_msg_data
3048: );
3049: x_msg_data := substr(x_msg_data,1,2000);

Line 3096: FND_MSG_PUB.Add;

3092:
3093: --mandatory checking
3094: if (p_pm_schedule_id is null) then
3095: FND_MESSAGE.SET_NAME ('EAM', 'EAM_PM_SCHEDULE_ID_MISSING');
3096: FND_MSG_PUB.Add;
3097: RAISE FND_API.G_EXC_ERROR;
3098: end if;
3099:
3100: --call to get the last activity of the pm schedule

Line 3139: FND_MSG_PUB.get

3135: if l_get_failed = 'Y' then
3136: x_msg_count := l_msg_count;
3137: x_msg_data := l_msg_data;
3138: else
3139: FND_MSG_PUB.get
3140: ( p_msg_index_out => x_msg_count ,
3141: p_data => x_msg_data
3142: );
3143: x_msg_data := substr(x_msg_data,1,2000);

Line 3148: FND_MSG_PUB.get

3144: end if;
3145: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3146: ROLLBACK TO update_pm_last_cyclic_act;
3147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3148: FND_MSG_PUB.get
3149: ( p_msg_index_out => x_msg_count ,
3150: p_data => x_msg_data
3151: );
3152: x_msg_data := substr(x_msg_data,1,2000);

Line 3156: IF FND_MSG_PUB.Check_Msg_Level

3152: x_msg_data := substr(x_msg_data,1,2000);
3153: WHEN OTHERS THEN
3154: ROLLBACK TO update_pm_last_cyclic_act;
3155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3156: IF FND_MSG_PUB.Check_Msg_Level
3157: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3158: THEN
3159: FND_MSG_PUB.Add_Exc_Msg
3160: ( G_PKG_NAME ,

Line 3157: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3153: WHEN OTHERS THEN
3154: ROLLBACK TO update_pm_last_cyclic_act;
3155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3156: IF FND_MSG_PUB.Check_Msg_Level
3157: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3158: THEN
3159: FND_MSG_PUB.Add_Exc_Msg
3160: ( G_PKG_NAME ,
3161: l_api_name

Line 3159: FND_MSG_PUB.Add_Exc_Msg

3155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3156: IF FND_MSG_PUB.Check_Msg_Level
3157: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3158: THEN
3159: FND_MSG_PUB.Add_Exc_Msg
3160: ( G_PKG_NAME ,
3161: l_api_name
3162: );
3163: END IF;

Line 3164: FND_MSG_PUB.get

3160: ( G_PKG_NAME ,
3161: l_api_name
3162: );
3163: END IF;
3164: FND_MSG_PUB.get
3165: ( p_msg_index_out => x_msg_count ,
3166: p_data => x_msg_data
3167: );
3168: x_msg_data := substr(x_msg_data,1,2000);

Line 3217: FND_MSG_PUB.Add;

3213: --mandatory checking
3214:
3215: if (p_pm_schedule_id is null) then
3216: FND_MESSAGE.SET_NAME ('EAM', 'EAM_PM_SCHEDULE_ID_MISSING');
3217: FND_MSG_PUB.Add;
3218: RAISE FND_API.G_EXC_ERROR;
3219: end if;
3220:
3221: --call to get the last activity of the pm schedule

Line 3267: FND_MSG_PUB.get

3263: if l_get_failed = 'Y' then
3264: x_msg_count := l_msg_count;
3265: x_msg_data := l_msg_data;
3266: else
3267: FND_MSG_PUB.get
3268: ( p_msg_index_out => x_msg_count ,
3269: p_data => x_msg_data
3270: );
3271: x_msg_data := substr(x_msg_data,1,2000);

Line 3276: FND_MSG_PUB.get

3272: end if;
3273: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3274: ROLLBACK TO update_pm_last_service_reading;
3275: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3276: FND_MSG_PUB.get
3277: ( p_msg_index_out => x_msg_count ,
3278: p_data => x_msg_data
3279: );
3280: x_msg_data := substr(x_msg_data,1,2000);

Line 3284: IF FND_MSG_PUB.Check_Msg_Level

3280: x_msg_data := substr(x_msg_data,1,2000);
3281: WHEN OTHERS THEN
3282: ROLLBACK TO update_pm_last_service_reading;
3283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3284: IF FND_MSG_PUB.Check_Msg_Level
3285: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3286: THEN
3287: FND_MSG_PUB.Add_Exc_Msg
3288: ( G_PKG_NAME ,

Line 3285: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3281: WHEN OTHERS THEN
3282: ROLLBACK TO update_pm_last_service_reading;
3283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3284: IF FND_MSG_PUB.Check_Msg_Level
3285: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3286: THEN
3287: FND_MSG_PUB.Add_Exc_Msg
3288: ( G_PKG_NAME ,
3289: l_api_name

Line 3287: FND_MSG_PUB.Add_Exc_Msg

3283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3284: IF FND_MSG_PUB.Check_Msg_Level
3285: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3286: THEN
3287: FND_MSG_PUB.Add_Exc_Msg
3288: ( G_PKG_NAME ,
3289: l_api_name
3290: );
3291: END IF;

Line 3292: FND_MSG_PUB.get

3288: ( G_PKG_NAME ,
3289: l_api_name
3290: );
3291: END IF;
3292: FND_MSG_PUB.get
3293: ( p_msg_index_out => x_msg_count ,
3294: p_data => x_msg_data
3295: );
3296: x_msg_data := substr(x_msg_data,1,2000);