DBA Data[Home] [Help]

APPS.EAM_ITEM_ACTIVITIES_PUB dependencies on FND_MSG_PUB

Line 133: FND_MSG_PUB.ADD;

129: BEGIN
130:
131:
132: FND_MESSAGE.SET_NAME ('EAM', ERROR);
133: FND_MSG_PUB.ADD;
134: RAISE FND_API.G_EXC_ERROR;
135: END;
136:
137: --funcation to validate if the provided lookup code is present forthe specified type.

Line 155: fnd_msg_pub.add;

151:
152: if l_count = 0
153: then
154: fnd_message.set_name('EAM', P_MSG);
155: fnd_msg_pub.add;
156: RAISE fnd_api.g_exc_error;
157: end if;
158: END;
159:

Line 180: fnd_msg_pub.add;

176:
177: if l_count = 0
178: then
179: fnd_message.set_name('EAM', 'EAM_ABO_INVALID_CLASS_CODE');
180: fnd_msg_pub.add;
181: RAISE fnd_api.g_exc_error;
182: end if;
183: END;
184:

Line 194: fnd_msg_pub.add;

190: then
191: if not EAM_COMMON_UTILITIES_PVT.validate_boolean_flag(p_flag)
192: then
193: fnd_message.set_name('EAM', p_msg);
194: fnd_msg_pub.add;
195: RAISE fnd_api.g_exc_error;
196: end if;
197: end if;
198: end;

Line 226: fnd_msg_pub.add;

222: end if;
223:
224: if l_count = 0 then
225: fnd_message.set_name('EAM', 'EAM_INVALID_MAINT_OBJ_ID');
226: fnd_msg_pub.add;
227: RAISE fnd_api.g_exc_error;
228: end if;
229:
230: END;

Line 257: fnd_msg_pub.add;

253: END IF;
254:
255: if (l_count = 0) then
256: fnd_message.set_name('EAM', 'EAM_INVALID_INVENTORY_ITEM');
257: fnd_msg_pub.add;
258: RAISE fnd_api.g_exc_error;
259: end if;
260: end validate_inventory_item_id;
261:

Line 271: fnd_msg_pub.add;

267:
268: if nvl(p_tmpl_flag, 'N') = 'Y' and p_serial_number is not null
269: then
270: fnd_message.set_name('EAM', 'EAM_IAA_SERIAL_NUMBER_NOT_NULL');
271: fnd_msg_pub.add;
272: RAISE fnd_api.g_exc_error;
273: end if;
274:
275: if nvl(p_tmpl_flag, 'N') = 'N' and p_serial_number is null

Line 278: fnd_msg_pub.add;

274:
275: if nvl(p_tmpl_flag, 'N') = 'N' and p_serial_number is null
276: then
277: fnd_message.set_name('EAM', 'EAM_IAA_SERIAL_NUMBER_NULL');
278: fnd_msg_pub.add;
279: RAISE fnd_api.g_exc_error;
280: end if;
281:
282: if nvl(p_tmpl_flag, 'N') = 'N'

Line 290: fnd_msg_pub.add;

286: where cii.serial_number = p_serial_number;
287:
288: if (l_count = 0) then
289: fnd_message.set_name('EAM', 'EAM_EZWO_ASSET_BAD');
290: fnd_msg_pub.add;
291: RAISE fnd_api.g_exc_error;
292: end if;
293: end if;
294: END validate_serial_number;

Line 348: FND_MSG_PUB.Add;

344: )
345: then
346: FND_MESSAGE.SET_NAME('EAM', 'EAM_INVALID_DESC_FLEX');
347: FND_MESSAGE.SET_TOKEN('ERROR_MSG', l_error_message);
348: FND_MSG_PUB.Add;
349: RAISE FND_API.G_EXC_ERROR;
350: end if;
351:
352: end validate_dff_segments;

Line 380: fnd_msg_pub.add;

376: x_act_assoc_id := -1;
377: WHEN TOO_MANY_ROWS THEN
378: fnd_message.set_name('EAM', 'EAM_DATA_CORRUPT');
379: fnd_message.set_token('TABLE_NAME', 'MTL_EAM_ASSET_ACTIVITIES');
380: fnd_msg_pub.add;
381: RAISE fnd_api.g_exc_error;
382: END;
383:
384:

Line 485: FND_MSG_PUB.initialize;

481: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
482: END IF;
483: -- Initialize message list if p_init_msg_list is set to TRUE.
484: IF FND_API.to_Boolean( p_init_msg_list ) THEN
485: FND_MSG_PUB.initialize;
486: END IF;
487: -- Initialize API return status to success
488: x_return_status := FND_API.G_RET_STS_SUCCESS;
489:

Line 498: fnd_msg_pub.add;

494:
495: if (P_CREATION_ORGANIZATION_ID IS NOT NULL) then
496: if P_CREATION_ORGANIZATION_ID <> P_ORGANIZATION_ID then
497: fnd_message.set_name('EAM', 'EAM_ABO_INVALID_CR_ORG_ID');
498: fnd_msg_pub.add;
499: RAISE fnd_api.g_exc_error;
500: else
501: l_creation_organization_id := P_ORGANIZATION_ID;
502: end if;

Line 520: fnd_msg_pub.add;

516: x_msg_data => x_msg_data);
517: if l_boolean = 0
518: then
519: fnd_message.set_name('EAM', 'EAM_ABO_INVALID_ORG_ID');
520: fnd_msg_pub.add;
521: RAISE fnd_api.g_exc_error;
522: end if;
523: end if;
524:

Line 528: fnd_msg_pub.add;

524:
525:
526: IF ((p_class_code IS NOT NULL or p_owningdepartment_id IS NOT NULL) AND p_organization_id IS NULL) THEN
527: fnd_message.set_name('EAM', 'EAM_ABO_INVALID_ORG_ID');
528: fnd_msg_pub.add;
529: RAISE fnd_api.g_exc_error;
530: END IF;
531:
532: -- Bug # 3441956

Line 566: fnd_msg_pub.add;

562:
563: if p_start_date_active>p_end_date_active
564: then
565: fnd_message.set_name('EAM', 'EAM_IAA_INVALID_ACTIVE_DATE');
566: fnd_msg_pub.add;
567: RAISE fnd_api.g_exc_error;
568: END IF;
569:
570: if p_last_service_start_date > p_last_service_end_date

Line 573: fnd_msg_pub.add;

569:
570: if p_last_service_start_date > p_last_service_end_date
571: then
572: fnd_message.set_name('EAM', 'EAM_ABO_INVALID_START_END_DATE');
573: fnd_msg_pub.add;
574: RAISE fnd_api.g_exc_error;
575: END IF;
576:
577: if p_prev_service_start_date > p_prev_service_end_date

Line 580: fnd_msg_pub.add;

576:
577: if p_prev_service_start_date > p_prev_service_end_date
578: then
579: fnd_message.set_name('EAM', 'EAM_ABO_INVALID_START_END_DATE');
580: fnd_msg_pub.add;
581: RAISE fnd_api.g_exc_error;
582: END IF;
583:
584: if p_last_scheduled_start_date > p_last_scheduled_end_date

Line 587: fnd_msg_pub.add;

583:
584: if p_last_scheduled_start_date > p_last_scheduled_end_date
585: then
586: fnd_message.set_name('EAM', 'EAM_ABO_INVALID_START_END_DATE');
587: fnd_msg_pub.add;
588: RAISE fnd_api.g_exc_error;
589: END IF;
590:
591:

Line 595: fnd_msg_pub.add;

591:
592: if p_prev_scheduled_start_date > p_prev_scheduled_end_date
593: then
594: fnd_message.set_name('EAM', 'EAM_ABO_INVALID_START_END_DATE');
595: fnd_msg_pub.add;
596: RAISE fnd_api.g_exc_error;
597: END IF;
598:
599: validate_boolean_flag(p_tagging_required_flag, 'EAM_ABO_INVALID_TAG_REQ_FLAG');

Line 633: fnd_msg_pub.add;

629: --------------------------------------------------------------------------------------------
630: IF ((p_maintenance_object_type is null or p_maintenance_object_id is null) and
631: (p_inventory_item_id is null)) THEN
632: fnd_message.set_name('EAM', 'EAM_NOT_ENOUGH_PARAM');
633: fnd_msg_pub.add;
634: RAISE FND_API.G_EXC_ERROR;
635: END IF;
636:
637: IF (p_maintenance_object_type is not null and p_maintenance_object_type NOT in (3,2)) THEN

Line 639: fnd_msg_pub.add;

635: END IF;
636:
637: IF (p_maintenance_object_type is not null and p_maintenance_object_type NOT in (3,2)) THEN
638: fnd_message.set_name('EAM', 'EAM_INVALID_MAINT_OBJ_TYPE');
639: fnd_msg_pub.add;
640: RAISE FND_API.G_EXC_ERROR;
641: END IF;
642:
643: l_org_id := p_organization_id;

Line 916: x_msg_count := FND_MSG_PUB.count_msg;

912: p_pm_last_service_tbl => p_pm_last_service_tbl,
913: p_actv_assoc_id => l_actv_assoc_id
914: );
915:
916: x_msg_count := FND_MSG_PUB.count_msg;
917: IF x_msg_count > 0 THEN
918: RAISE FND_API.G_EXC_ERROR;
919: END IF;
920: END IF;

Line 928: FND_MSG_PUB.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.get
929: ( p_msg_index_out => x_msg_count ,
930: p_data => x_msg_data
931: );
932: EXCEPTION

Line 936: FND_MSG_PUB.get

932: EXCEPTION
933: WHEN FND_API.G_EXC_ERROR THEN
934: ROLLBACK TO INSERT_ITEM_ACTIVITIES;
935: x_return_status := FND_API.G_RET_STS_ERROR ;
936: FND_MSG_PUB.get
937: ( p_msg_index_out => x_msg_count ,
938: p_data => x_msg_data
939: );
940: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 943: FND_MSG_PUB.get

939: );
940: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
941: ROLLBACK TO INSERT_ITEM_ACTIVITIES;
942: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
943: FND_MSG_PUB.get
944: ( p_msg_index_out => x_msg_count ,
945: p_data => x_msg_data
946: );
947: WHEN OTHERS THEN

Line 950: IF FND_MSG_PUB.Check_Msg_Level

946: );
947: WHEN OTHERS THEN
948: ROLLBACK TO INSERT_ITEM_ACTIVITIES;
949: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
950: IF FND_MSG_PUB.Check_Msg_Level
951: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
952: THEN
953: FND_MSG_PUB.Add_Exc_Msg
954: ( G_PKG_NAME ,

Line 951: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

Line 953: FND_MSG_PUB.Add_Exc_Msg

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

Line 958: FND_MSG_PUB.get

954: ( G_PKG_NAME ,
955: l_api_name
956: );
957: END IF;
958: FND_MSG_PUB.get
959: ( p_msg_index_out => x_msg_count ,
960: p_data => x_msg_data
961: );
962: END INSERT_ITEM_ACTIVITIES;

Line 1065: FND_MSG_PUB.initialize;

1061: END IF;
1062: -- Initialize message list if p_init_msg_list is set to TRUE.
1063:
1064: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1065: FND_MSG_PUB.initialize;
1066: END IF;
1067: -- Initialize API return status to success
1068: x_return_status := FND_API.G_RET_STS_SUCCESS;
1069: -- API body

Line 1079: fnd_msg_pub.add;

1075:
1076: if (P_CREATION_ORGANIZATION_ID IS NOT NULL) then
1077: if P_CREATION_ORGANIZATION_ID <> P_ORGANIZATION_ID then
1078: fnd_message.set_name('EAM', 'EAM_ABO_INVALID_CR_ORG_ID');
1079: fnd_msg_pub.add;
1080: RAISE fnd_api.g_exc_error;
1081: else
1082: l_creation_organization_id := P_ORGANIZATION_ID;
1083: end if;

Line 1101: fnd_msg_pub.add;

1097: x_msg_data => x_msg_data);
1098: if l_boolean = 0
1099: then
1100: fnd_message.set_name('EAM', 'EAM_ABO_INVALID_ORG_ID');
1101: fnd_msg_pub.add;
1102: RAISE fnd_api.g_exc_error;
1103: end if;
1104: end if;
1105:

Line 1109: fnd_msg_pub.add;

1105:
1106:
1107: IF ((p_class_code IS NOT NULL or p_owningdepartment_id IS NOT NULL) AND p_organization_id IS NULL) THEN
1108: fnd_message.set_name('EAM', 'EAM_ABO_INVALID_ORG_ID');
1109: fnd_msg_pub.add;
1110: RAISE fnd_api.g_exc_error;
1111: END IF;
1112:
1113: -- Bug # 3441956

Line 1144: fnd_msg_pub.add;

1140:
1141: if p_start_date_active>p_end_date_active
1142: then
1143: fnd_message.set_name('EAM', 'EAM_IAA_INVALID_ACTIVE_DATE');
1144: fnd_msg_pub.add;
1145: RAISE fnd_api.g_exc_error;
1146: END IF;
1147:
1148: if p_last_service_start_date > p_last_service_end_date

Line 1151: fnd_msg_pub.add;

1147:
1148: if p_last_service_start_date > p_last_service_end_date
1149: then
1150: fnd_message.set_name('EAM', 'EAM_ABO_INVALID_START_END_DATE');
1151: fnd_msg_pub.add;
1152: RAISE fnd_api.g_exc_error;
1153: END IF;
1154:
1155: if p_prev_service_start_date > p_prev_service_end_date

Line 1158: fnd_msg_pub.add;

1154:
1155: if p_prev_service_start_date > p_prev_service_end_date
1156: then
1157: fnd_message.set_name('EAM', 'EAM_ABO_INVALID_START_END_DATE');
1158: fnd_msg_pub.add;
1159: RAISE fnd_api.g_exc_error;
1160: END IF;
1161:
1162: if p_last_scheduled_start_date > p_last_scheduled_end_date

Line 1165: fnd_msg_pub.add;

1161:
1162: if p_last_scheduled_start_date > p_last_scheduled_end_date
1163: then
1164: fnd_message.set_name('EAM', 'EAM_ABO_INVALID_START_END_DATE');
1165: fnd_msg_pub.add;
1166: RAISE fnd_api.g_exc_error;
1167: END IF;
1168:
1169:

Line 1173: fnd_msg_pub.add;

1169:
1170: if p_prev_scheduled_start_date > p_prev_scheduled_end_date
1171: then
1172: fnd_message.set_name('EAM', 'EAM_ABO_INVALID_START_END_DATE');
1173: fnd_msg_pub.add;
1174: RAISE fnd_api.g_exc_error;
1175: END IF;
1176:
1177: validate_boolean_flag(p_tagging_required_flag, 'EAM_ABO_INVALID_TAG_REQ_FLAG');

Line 1212: fnd_msg_pub.add;

1208: --------------------------------------------------------------------------------------------
1209: IF ((p_maintenance_object_type is null or p_maintenance_object_id is null) and
1210: (p_inventory_item_id is null)) THEN
1211: fnd_message.set_name('EAM', 'EAM_NOT_ENOUGH_PARAM');
1212: fnd_msg_pub.add;
1213: RAISE FND_API.G_EXC_ERROR;
1214: END IF;
1215:
1216: IF (p_maintenance_object_type is not null and p_maintenance_object_type NOT in (3,2)) THEN

Line 1218: fnd_msg_pub.add;

1214: END IF;
1215:
1216: IF (p_maintenance_object_type is not null and p_maintenance_object_type NOT in (3,2)) THEN
1217: fnd_message.set_name('EAM', 'EAM_INVALID_MAINT_OBJ_TYPE');
1218: fnd_msg_pub.add;
1219: RAISE FND_API.G_EXC_ERROR;
1220: END IF;
1221:
1222: l_org_id := p_organization_id;

Line 1339: fnd_msg_pub.add;

1335: l_id);
1336:
1337: IF (l_id = -1) THEN
1338: fnd_message.set_name('EAM', 'EAM_ITEM_ACT_REC_NOT_FOUND');
1339: fnd_msg_pub.add;
1340: RAISE fnd_api.g_exc_error;
1341: END IF;
1342:
1343:

Line 1434: x_msg_count := FND_MSG_PUB.count_msg;

1430: p_pm_last_service_tbl => p_pm_last_service_tbl,
1431: p_actv_assoc_id => P_ACTIVITY_ASSOCIATION_ID
1432: );
1433:
1434: x_msg_count := FND_MSG_PUB.count_msg;
1435: IF x_msg_count > 0 THEN
1436: RAISE FND_API.G_EXC_ERROR;
1437: END IF;
1438: END IF;

Line 1446: FND_MSG_PUB.get

1442: IF FND_API.To_Boolean( p_commit ) THEN
1443: COMMIT WORK;
1444: END IF;
1445: -- Standard call to get message count and if count is 1, get message info.
1446: FND_MSG_PUB.get
1447: ( p_msg_index_out => x_msg_count ,
1448: p_data => x_msg_data
1449: );
1450: EXCEPTION

Line 1454: FND_MSG_PUB.get

1450: EXCEPTION
1451: WHEN FND_API.G_EXC_ERROR THEN
1452: ROLLBACK TO UPDATE_ITEM_ACTIVITIES;
1453: x_return_status := FND_API.G_RET_STS_ERROR ;
1454: FND_MSG_PUB.get
1455: ( p_msg_index_out => x_msg_count ,
1456: p_data => x_msg_data
1457: );
1458: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1461: FND_MSG_PUB.get

1457: );
1458: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1459: ROLLBACK TO UPDATE_ITEM_ACTIVITIES;
1460: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1461: FND_MSG_PUB.get
1462: ( p_msg_index_out => x_msg_count ,
1463: p_data => x_msg_data
1464: );
1465: WHEN OTHERS THEN

Line 1468: IF FND_MSG_PUB.Check_Msg_Level

1464: );
1465: WHEN OTHERS THEN
1466: ROLLBACK TO UPDATE_ITEM_ACTIVITIES;
1467: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1468: IF FND_MSG_PUB.Check_Msg_Level
1469: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1470: THEN
1471: FND_MSG_PUB.Add_Exc_Msg
1472: ( G_PKG_NAME ,

Line 1469: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1465: WHEN OTHERS THEN
1466: ROLLBACK TO UPDATE_ITEM_ACTIVITIES;
1467: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1468: IF FND_MSG_PUB.Check_Msg_Level
1469: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1470: THEN
1471: FND_MSG_PUB.Add_Exc_Msg
1472: ( G_PKG_NAME ,
1473: l_api_name

Line 1471: FND_MSG_PUB.Add_Exc_Msg

1467: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1468: IF FND_MSG_PUB.Check_Msg_Level
1469: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1470: THEN
1471: FND_MSG_PUB.Add_Exc_Msg
1472: ( G_PKG_NAME ,
1473: l_api_name
1474: );
1475: END IF;

Line 1476: FND_MSG_PUB.get

1472: ( G_PKG_NAME ,
1473: l_api_name
1474: );
1475: END IF;
1476: FND_MSG_PUB.get
1477: ( p_msg_index_out => x_msg_count ,
1478: p_data => x_msg_data
1479: );
1480: END update_item_activities;