eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 167: FND_MSG_PUB.Add;

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

Line 176: FND_MSG_PUB.Add;

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

Line 200: FND_MSG_PUB.Add;

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

Line 532: FND_MSG_PUB.get

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

Line 624: FND_MSG_PUB.initialize;

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

Line 687: FND_MSG_PUB.get

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

Line 696: FND_MSG_PUB.get

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

Line 704: FND_MSG_PUB.get

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

Line 712: IF FND_MSG_PUB.Check_Msg_Level

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

Line 713: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

Line 715: FND_MSG_PUB.Add_Exc_Msg

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

Line 720: FND_MSG_PUB.get

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

Line 774: FND_MSG_PUB.initialize;

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

Line 796: FND_MSG_PUB.Add;

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

Line 811: FND_MSG_PUB.Add;

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

Line 820: FND_MSG_PUB.Add;

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

Line 852: FND_MSG_PUB.Add;

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

Line 1188: FND_MSG_PUB.get

1184: IF FND_API.To_Boolean( p_commit ) THEN
1185: COMMIT WORK;
1186: END IF;
1187: -- Standard call to get message count and if count is 1, get message info.
1188: FND_MSG_PUB.get
1189: ( p_msg_index_out => x_msg_count ,
1190: p_data => x_msg_data
1191: );
1192: x_msg_data := substr(x_msg_data,1,2000);

Line 1197: FND_MSG_PUB.get

1193: EXCEPTION
1194: WHEN FND_API.G_EXC_ERROR THEN
1195: ROLLBACK TO create_PM_def_pub;
1196: x_return_status := FND_API.G_RET_STS_ERROR ;
1197: FND_MSG_PUB.get
1198: ( p_msg_index_out => x_msg_count ,
1199: p_data => x_msg_data
1200: );
1201: x_msg_data := substr(x_msg_data,1,2000);

Line 1205: FND_MSG_PUB.get

1201: x_msg_data := substr(x_msg_data,1,2000);
1202: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1203: ROLLBACK TO create_PM_def_pub;
1204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1205: FND_MSG_PUB.get
1206: ( p_msg_index_out => x_msg_count ,
1207: p_data => x_msg_data
1208: );
1209: x_msg_data := substr(x_msg_data,1,2000);

Line 1213: IF FND_MSG_PUB.Check_Msg_Level

1209: x_msg_data := substr(x_msg_data,1,2000);
1210: WHEN OTHERS THEN
1211: ROLLBACK TO create_PM_def_pub;
1212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1213: IF FND_MSG_PUB.Check_Msg_Level
1214: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1215: THEN
1216: FND_MSG_PUB.Add_Exc_Msg
1217: ( G_PKG_NAME ,

Line 1214: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1210: WHEN OTHERS THEN
1211: ROLLBACK TO create_PM_def_pub;
1212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1213: IF FND_MSG_PUB.Check_Msg_Level
1214: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1215: THEN
1216: FND_MSG_PUB.Add_Exc_Msg
1217: ( G_PKG_NAME ,
1218: l_api_name

Line 1216: FND_MSG_PUB.Add_Exc_Msg

1212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1213: IF FND_MSG_PUB.Check_Msg_Level
1214: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1215: THEN
1216: FND_MSG_PUB.Add_Exc_Msg
1217: ( G_PKG_NAME ,
1218: l_api_name
1219: );
1220: END IF;

Line 1221: FND_MSG_PUB.get

1217: ( G_PKG_NAME ,
1218: l_api_name
1219: );
1220: END IF;
1221: FND_MSG_PUB.get
1222: ( p_msg_index_out => x_msg_count ,
1223: p_data => x_msg_data
1224: );
1225: x_msg_data := substr(x_msg_data,1,2000);

Line 1286: FND_MSG_PUB.initialize;

1282: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1283: END IF;
1284: -- Initialize message list if p_init_msg_list is set to TRUE.
1285: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1286: FND_MSG_PUB.initialize;
1287: END IF;
1288: -- Initialize API return status to success
1289: x_return_status := FND_API.G_RET_STS_SUCCESS;
1290: -- API body

Line 1294: FND_MSG_PUB.Add;

1290: -- API body
1291:
1292: if (p_pm_schedule_rec.pm_schedule_id is null) then
1293: FND_MESSAGE.SET_NAME ('EAM', 'EAM_PM_SCHEDULE_ID_MISSING');
1294: FND_MSG_PUB.Add;
1295: RAISE FND_API.G_EXC_ERROR;
1296: else
1297: l_pm_schedule_id:=p_pm_schedule_rec.pm_schedule_id;
1298: end if;

Line 1306: FND_MSG_PUB.Add;

1302: if ( not (p_pm_schedule_rec.generate_next_work_order = 'Y'
1303: OR p_pm_schedule_rec.generate_next_work_order = 'N'
1304: OR p_pm_schedule_rec.generate_next_work_order is null)) then
1305: FND_MESSAGE.SET_NAME ('EAM', 'INVALID_GENERATE_NEXT_WORK_ORDER');
1306: FND_MSG_PUB.Add;
1307: RAISE FND_API.G_EXC_ERROR;
1308:
1309: end if;
1310: /* Validating the DFF */

Line 1335: FND_MSG_PUB.Add;

1331: x_error_segments => x_error_segments ,
1332: x_error_message => x_error_message);
1333: IF (not l_validated) THEN
1334: FND_MESSAGE.SET_NAME ('EAM', x_error_message);
1335: FND_MSG_PUB.Add;
1336: RAISE FND_API.G_EXC_ERROR;
1337: END IF;
1338:
1339:

Line 1544: FND_MSG_PUB.Add;

1540: /*bug 9744000 end*/
1541:
1542: else -- rules did not validate
1543: FND_MESSAGE.SET_NAME ('EAM', l_reason_failed);
1544: FND_MSG_PUB.Add;
1545: RAISE FND_API.G_EXC_ERROR;
1546: end if;
1547:
1548: -- End of API body.

Line 1554: FND_MSG_PUB.get

1550: IF FND_API.To_Boolean( p_commit ) THEN
1551: COMMIT WORK;
1552: END IF;
1553: -- Standard call to get message count and if count is 1, get message info.
1554: FND_MSG_PUB.get
1555: ( p_msg_index_out => x_msg_count ,
1556: p_data => x_msg_data
1557: );
1558: x_msg_data := substr(x_msg_data,1,2000);

Line 1563: FND_MSG_PUB.get

1559: EXCEPTION
1560: WHEN FND_API.G_EXC_ERROR THEN
1561: ROLLBACK TO update_pm_def_pub;
1562: x_return_status := FND_API.G_RET_STS_ERROR ;
1563: FND_MSG_PUB.get
1564: ( p_msg_index_out => x_msg_count ,
1565: p_data => x_msg_data
1566: );
1567: x_msg_data := substr(x_msg_data,1,2000);

Line 1571: FND_MSG_PUB.get

1567: x_msg_data := substr(x_msg_data,1,2000);
1568: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1569: ROLLBACK TO update_pm_def_pub;
1570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1571: FND_MSG_PUB.get
1572: ( p_msg_index_out => x_msg_count ,
1573: p_data => x_msg_data
1574: );
1575: x_msg_data := substr(x_msg_data,1,2000);

Line 1579: IF FND_MSG_PUB.Check_Msg_Level

1575: x_msg_data := substr(x_msg_data,1,2000);
1576: WHEN OTHERS THEN
1577: ROLLBACK TO update_pm_def_pub;
1578: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1579: IF FND_MSG_PUB.Check_Msg_Level
1580: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1581: THEN
1582: FND_MSG_PUB.Add_Exc_Msg
1583: ( G_PKG_NAME ,

Line 1580: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1576: WHEN OTHERS THEN
1577: ROLLBACK TO update_pm_def_pub;
1578: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1579: IF FND_MSG_PUB.Check_Msg_Level
1580: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1581: THEN
1582: FND_MSG_PUB.Add_Exc_Msg
1583: ( G_PKG_NAME ,
1584: l_api_name

Line 1582: FND_MSG_PUB.Add_Exc_Msg

1578: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1579: IF FND_MSG_PUB.Check_Msg_Level
1580: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1581: THEN
1582: FND_MSG_PUB.Add_Exc_Msg
1583: ( G_PKG_NAME ,
1584: l_api_name
1585: );
1586: END IF;

Line 1587: FND_MSG_PUB.get

1583: ( G_PKG_NAME ,
1584: l_api_name
1585: );
1586: END IF;
1587: FND_MSG_PUB.get
1588: ( p_msg_index_out => x_msg_count ,
1589: p_data => x_msg_data
1590: );
1591: x_msg_data := substr(x_msg_data,1,2000);

Line 3012: FND_MSG_PUB.Add;

3008: x_return_status:='S';
3009: -- Check that enough info is supplied to identify which pm schedule to copy from.
3010: if (p_pm_schedule_id is null) then
3011: FND_MESSAGE.SET_NAME ('EAM', 'EAM_MT_SUPPLY_PARAMS');
3012: FND_MSG_PUB.Add;
3013: RAISE FND_API.G_EXC_ERROR;
3014: end if;
3015:
3016: --getting the scheduling option for the pm schedule

Line 3025: FND_MSG_PUB.Add;

3021:
3022: --mandatory checking for rescheduling and current interval values
3023: if (l_rescheduling_point is null) then
3024: FND_MESSAGE.SET_NAME ('EAM', 'EAM_PM_NO_RESCHED');
3025: FND_MSG_PUB.Add;
3026: RAISE FND_API.G_EXC_ERROR;
3027: end if;
3028:
3029: if (l_current_seq is null) then

Line 3031: FND_MSG_PUB.Add;

3027: end if;
3028:
3029: if (l_current_seq is null) then
3030: FND_MESSAGE.SET_NAME ('EAM', 'EAM_PM_NO_CURRENTSEQ');
3031: FND_MSG_PUB.Add;
3032: RAISE FND_API.G_EXC_ERROR;
3033: end if;
3034:
3035: --based on current sequence retrieve

Line 3150: FND_MSG_PUB.get

3146:
3147: EXCEPTION
3148: WHEN FND_API.G_EXC_ERROR THEN
3149: x_return_status := FND_API.G_RET_STS_ERROR ;
3150: FND_MSG_PUB.get
3151: ( p_msg_index_out => x_msg_count ,
3152: p_data => x_msg_data
3153: );
3154: x_msg_data := substr(x_msg_data,1,2000);

Line 3201: FND_MSG_PUB.Add;

3197:
3198: --mandatory checking
3199: if (p_pm_schedule_id is null) then
3200: FND_MESSAGE.SET_NAME ('EAM', 'EAM_PM_SCHEDULE_ID_MISSING');
3201: FND_MSG_PUB.Add;
3202: RAISE FND_API.G_EXC_ERROR;
3203: end if;
3204:
3205: --call to get the last activity of the pm schedule

Line 3243: FND_MSG_PUB.get

3239: if l_get_failed = 'Y' then
3240: x_msg_count := l_msg_count;
3241: x_msg_data := l_msg_data;
3242: else
3243: FND_MSG_PUB.get
3244: ( p_msg_index_out => x_msg_count ,
3245: p_data => x_msg_data
3246: );
3247: x_msg_data := substr(x_msg_data,1,2000);

Line 3252: FND_MSG_PUB.get

3248: end if;
3249: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3250: ROLLBACK TO update_pm_last_cyclic_act;
3251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3252: FND_MSG_PUB.get
3253: ( p_msg_index_out => x_msg_count ,
3254: p_data => x_msg_data
3255: );
3256: x_msg_data := substr(x_msg_data,1,2000);

Line 3260: IF FND_MSG_PUB.Check_Msg_Level

3256: x_msg_data := substr(x_msg_data,1,2000);
3257: WHEN OTHERS THEN
3258: ROLLBACK TO update_pm_last_cyclic_act;
3259: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3260: IF FND_MSG_PUB.Check_Msg_Level
3261: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3262: THEN
3263: FND_MSG_PUB.Add_Exc_Msg
3264: ( G_PKG_NAME ,

Line 3261: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3257: WHEN OTHERS THEN
3258: ROLLBACK TO update_pm_last_cyclic_act;
3259: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3260: IF FND_MSG_PUB.Check_Msg_Level
3261: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3262: THEN
3263: FND_MSG_PUB.Add_Exc_Msg
3264: ( G_PKG_NAME ,
3265: l_api_name

Line 3263: FND_MSG_PUB.Add_Exc_Msg

3259: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3260: IF FND_MSG_PUB.Check_Msg_Level
3261: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3262: THEN
3263: FND_MSG_PUB.Add_Exc_Msg
3264: ( G_PKG_NAME ,
3265: l_api_name
3266: );
3267: END IF;

Line 3268: FND_MSG_PUB.get

3264: ( G_PKG_NAME ,
3265: l_api_name
3266: );
3267: END IF;
3268: FND_MSG_PUB.get
3269: ( p_msg_index_out => x_msg_count ,
3270: p_data => x_msg_data
3271: );
3272: x_msg_data := substr(x_msg_data,1,2000);

Line 3321: FND_MSG_PUB.Add;

3317: --mandatory checking
3318:
3319: if (p_pm_schedule_id is null) then
3320: FND_MESSAGE.SET_NAME ('EAM', 'EAM_PM_SCHEDULE_ID_MISSING');
3321: FND_MSG_PUB.Add;
3322: RAISE FND_API.G_EXC_ERROR;
3323: end if;
3324:
3325: --call to get the last activity of the pm schedule

Line 3369: FND_MSG_PUB.get

3365: if l_get_failed = 'Y' then
3366: x_msg_count := l_msg_count;
3367: x_msg_data := l_msg_data;
3368: else
3369: FND_MSG_PUB.get
3370: ( p_msg_index_out => x_msg_count ,
3371: p_data => x_msg_data
3372: );
3373: x_msg_data := substr(x_msg_data,1,2000);

Line 3378: FND_MSG_PUB.get

3374: end if;
3375: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3376: ROLLBACK TO update_pm_last_service_reading;
3377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3378: FND_MSG_PUB.get
3379: ( p_msg_index_out => x_msg_count ,
3380: p_data => x_msg_data
3381: );
3382: x_msg_data := substr(x_msg_data,1,2000);

Line 3386: IF FND_MSG_PUB.Check_Msg_Level

3382: x_msg_data := substr(x_msg_data,1,2000);
3383: WHEN OTHERS THEN
3384: ROLLBACK TO update_pm_last_service_reading;
3385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3386: IF FND_MSG_PUB.Check_Msg_Level
3387: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3388: THEN
3389: FND_MSG_PUB.Add_Exc_Msg
3390: ( G_PKG_NAME ,

Line 3387: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3383: WHEN OTHERS THEN
3384: ROLLBACK TO update_pm_last_service_reading;
3385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3386: IF FND_MSG_PUB.Check_Msg_Level
3387: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3388: THEN
3389: FND_MSG_PUB.Add_Exc_Msg
3390: ( G_PKG_NAME ,
3391: l_api_name

Line 3389: FND_MSG_PUB.Add_Exc_Msg

3385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3386: IF FND_MSG_PUB.Check_Msg_Level
3387: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3388: THEN
3389: FND_MSG_PUB.Add_Exc_Msg
3390: ( G_PKG_NAME ,
3391: l_api_name
3392: );
3393: END IF;

Line 3394: FND_MSG_PUB.get

3390: ( G_PKG_NAME ,
3391: l_api_name
3392: );
3393: END IF;
3394: FND_MSG_PUB.get
3395: ( p_msg_index_out => x_msg_count ,
3396: p_data => x_msg_data
3397: );
3398: x_msg_data := substr(x_msg_data,1,2000);