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_WORKORDERS_JSP dependencies on EAM_EXECUTION_JSP

Line 472: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_WO_STALED_DATA');

468: WHERE wip_entity_id = p_wip_entity_id
469: FOR UPDATE;
470:
471: IF l_db_last_update_date <> p_stored_last_update_date THEN
472: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_WO_STALED_DATA');
473: x_return_status := FND_API.G_RET_STS_ERROR;
474: END IF;
475:
476: IF ( (p_transaction_type = 1 AND l_db_status <> 3) or

Line 478: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_WO_COMP_WRONG_STATUS');

474: END IF;
475:
476: IF ( (p_transaction_type = 1 AND l_db_status <> 3) or
477: (p_transaction_type = 2 and (l_db_status <> 4 and l_db_status <> 5)) ) THEN -- 5??
478: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_WO_COMP_WRONG_STATUS');
479: x_return_status := FND_API.G_RET_STS_ERROR;
480: END IF;
481:
482: EXCEPTION WHEN OTHERS THEN

Line 483: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_WO_NOT_FOUND');

479: x_return_status := FND_API.G_RET_STS_ERROR;
480: END IF;
481:
482: EXCEPTION WHEN OTHERS THEN
483: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_WO_NOT_FOUND');
484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
485: END;
486:
487: --dgupta: default actual start and end dates from the last completion txn.

Line 510: eam_execution_jsp.add_message(p_app_short_name => 'EAM',

506: /* Fix for bug no: 2695696 */
507: /*Fix for bug 3235163*/
508: --Previously the check was for actual_end date.It has been changed to p_transaction_date
509: if (p_transaction_date < l_min_open_period) then
510: eam_execution_jsp.add_message(p_app_short_name => 'EAM',
511: p_msg_name => 'EAM_TRANSACTION_DATE_INVALID');
512: end if;
513: /*End of fix for bug 3235163*/
514: /* end of fix for bug o:2695696 */

Line 545: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_NEGATIVE_DURATION');

541:
542: if ((p_actual_start_date is not null) and (p_actual_duration is not null)) then
543: -- Start Fix for Bug 2165293
544: if (p_actual_duration < 0) then
545: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_NEGATIVE_DURATION');
546: x_return_status := FND_API.G_RET_STS_ERROR;
547: end if;
548: -- End Fix for Bug 2165293
549:

Line 551: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_END_LATER_THAN_TODAY');

547: end if;
548: -- End Fix for Bug 2165293
549:
550: if (p_actual_end_date > sysdate) then
551: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_END_LATER_THAN_TODAY');
552: x_return_status := FND_API.G_RET_STS_ERROR;
553: end if;
554:
555:

Line 565: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_WO_COMPL_DATES_INVALID',

561: if (
562: ((p_actual_end_date < l_max_compl_op_date) AND (l_max_compl_op_date - p_actual_end_date > (0.000011575 * 60 ))) OR
563: ((p_actual_start_date > l_min_compl_op_date) AND (p_actual_start_date - l_min_compl_op_date > (0.000011575 * 60 )))
564: )then
565: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_WO_COMPL_DATES_INVALID',
566: p_token1=>'MIN_OP_DATE',p_value1=>TO_CHAR(l_min_compl_op_date,'dd-MON-yyyy HH24:MI:SS'),p_token2=>'MAX_OP_DATE'
567: ,p_value2=>TO_CHAR(l_max_compl_op_date,'dd-MON-yyyy HH24:MI:SS'));
568: x_return_status := FND_API.G_RET_STS_ERROR;
569: end if;

Line 597: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_RECONCILIATION_CODE_INV');

593: where mlu.lookup_type = 'WIP_EAM_RECONCILIATION_CODE'
594: and mlu.meaning = p_reconciliation_code;
595: end if;
596: EXCEPTION WHEN OTHERS THEN
597: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_RECONCILIATION_CODE_INV');
598: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
599: END;
600:
601: if( p_shutdown_start_date > p_shutdown_end_date) then

Line 602: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_SHUTDOWN_DATE_BAD');

598: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
599: END;
600:
601: if( p_shutdown_start_date > p_shutdown_end_date) then
602: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_SHUTDOWN_DATE_BAD');
603: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
604: end if;
605:
606: /* I. As part of IB changes, Completing to a subinventory is always optional

Line 628: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_ITEM_NOT_ASSIGNED');

624: and msi.organization_id = p_org_id;
625:
626: exception
627: when no_data_found then
628: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_ITEM_NOT_ASSIGNED');
629: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
630: end;
631:
632: else

Line 641: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_NOT_OUT_OF_STORES');

637: and msn.serial_number = p_serial
638: and msn.current_status = 4;
639: exception
640: when no_data_found then
641: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_NOT_OUT_OF_STORES');
642: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
643: end;
644:
645: end if;

Line 681: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_RET_MAT_INVALID_SUBINV');

677: and organization_id = p_org_id);
678: end if;
679: exception
680: when no_data_found then
681: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_RET_MAT_INVALID_SUBINV');
682: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
683: return;
684: end;
685: end if;

Line 714: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_RET_MAT_INVALID_LOCATOR');

710: exception
711: when no_data_found then
712: -- x_error_flag := 1;
713: -- x_error_mssg := 'EAM_RET_MAT_INVALID_LOCATOR';
714: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_RET_MAT_INVALID_LOCATOR');
715: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
716: return;
717: end;
718: end if;

Line 741: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_RET_MAT_LOCATOR_NEEDED');

737: if(l_locator_ctrl = 2 or l_locator_ctrl = 3) then
738: if(l_locator_id IS NULL) then
739: /* l_error_flag := 1;
740: l_error_mssg := 'EAM_RET_MAT_LOCATOR_NEEDED'; */
741: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_RET_MAT_LOCATOR_NEEDED');
742: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
743: return;
744: end if;
745: elsif(l_locator_ctrl = 1) then -- If the locator control is NOControl

Line 749: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_RET_MAT_LOCATOR_RESTRICTED');

745: elsif(l_locator_ctrl = 1) then -- If the locator control is NOControl
746: if(l_locator_id IS NOT NULL) then
747: /* l_error_flag := 1;
748: l_error_mssg := 'EAM_RET_MAT_LOCATOR_RESTRICTED'; */
749: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_RET_MAT_LOCATOR_RESTRICTED');
750: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
751: return;
752: end if;
753: end if; -- end of locator_control checkif

Line 768: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_NO_LOT_NUMBER');

764: inventory_item_id = p_item_id
765: and organization_id = p_org_id;
766: exception
767: when NO_DATA_FOUND then
768: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_NO_LOT_NUMBER');
769: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
770: end;
771: else
772: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_LOT_NEEDED');

Line 772: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_LOT_NEEDED');

768: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_NO_LOT_NUMBER');
769: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
770: end;
771: else
772: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_LOT_NEEDED');
773: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
774: end if;
775: else
776: if(p_lot is not null) then

Line 777: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_LOT_NOT_NEEDED');

773: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
774: end if;
775: else
776: if(p_lot is not null) then
777: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_LOT_NOT_NEEDED');
778: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
779: end if;
780: end if; -- end of lot entry check
781:

Line 791: eam_execution_jsp.Get_Messages

787:
788: -- if validate not passed then raise error
789: l_msg_count := FND_MSG_PUB.count_msg;
790: IF l_msg_count = 1 THEN
791: eam_execution_jsp.Get_Messages
792: (p_encoded => FND_API.G_FALSE,
793: p_msg_index => 1,
794: p_msg_count => l_msg_count,
795: p_msg_data => nvl(l_msg_data,FND_API.g_MISS_CHAR),

Line 849: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name =>'EAM_WO_NO_UNCOMPLETE' );

845: ,x_attribute15 => p_attribute15
846: );
847:
848: IF (l_err_number = 2) THEN
849: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name =>'EAM_WO_NO_UNCOMPLETE' );
850: x_return_status := FND_API.G_RET_STS_ERROR;
851: ELSIF (l_err_number > 0 ) THEN
852: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name =>l_err_code);
853: x_return_status := FND_API.G_RET_STS_ERROR;

Line 852: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name =>l_err_code);

848: IF (l_err_number = 2) THEN
849: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name =>'EAM_WO_NO_UNCOMPLETE' );
850: x_return_status := FND_API.G_RET_STS_ERROR;
851: ELSIF (l_err_number > 0 ) THEN
852: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name =>l_err_code);
853: x_return_status := FND_API.G_RET_STS_ERROR;
854: END IF;
855:
856: EXCEPTION WHEN OTHERS THEN

Line 857: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_WO_EXCEPTION',

853: x_return_status := FND_API.G_RET_STS_ERROR;
854: END IF;
855:
856: EXCEPTION WHEN OTHERS THEN
857: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_WO_EXCEPTION',
858: p_token1 => 'TEXT', p_value1 => sqlerrm);
859: x_return_status := FND_API.G_RET_STS_ERROR;
860: END;
861:

Line 866: eam_execution_jsp.Get_Messages

862:
863: -- if DML not passed then raise error
864: l_msg_count := FND_MSG_PUB.count_msg;
865: IF l_msg_count = 1 THEN
866: eam_execution_jsp.Get_Messages
867: (p_encoded => FND_API.G_FALSE,
868: p_msg_index => 1,
869: p_msg_count => l_msg_count,
870: p_msg_data => nvl(l_msg_data,FND_API.g_MISS_CHAR) ,

Line 1278: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_DEACTIVATE_CANNOT_UNCANCEL',

1274: asset_status := 4; --inactive
1275: end if;
1276:
1277: if((l_eam_item_type=1) and (l_orig_wo_status=7) and (l_status_type in (1,3,6,17)) and (asset_status<>3)) then
1278: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_DEACTIVATE_CANNOT_UNCANCEL',
1279: p_token1 => 'NAME', p_value1 => p_wip_entity_name);
1280: x_return_status := FND_API.G_RET_STS_ERROR;
1281: return;
1282: end if;

Line 1328: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_EZWO_ASSET_BAD');

1324: l_maintenance_object_id:=l_asset_group_id;
1325: l_maintenance_object_type:=2;
1326: exception
1327: when others then
1328: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_EZWO_ASSET_BAD');
1329: x_return_status := FND_API.G_RET_STS_ERROR;
1330: end;
1331: end if;
1332:

Line 1336: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_EZWO_ASSET_BAD');

1332:
1333: l_maintenance_object_source:=1;
1334:
1335: EXCEPTION WHEN OTHERS THEN
1336: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_EZWO_ASSET_BAD');
1337: x_return_status := FND_API.G_RET_STS_ERROR;
1338: END;
1339:
1340: -- get owning department id

Line 1352: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_EZWO_DEPT_BAD');

1348: where organization_id = p_organization_id
1349: and department_code = p_owning_department;
1350: END IF;
1351: EXCEPTION WHEN OTHERS THEN
1352: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_EZWO_DEPT_BAD');
1353: x_return_status := FND_API.G_RET_STS_ERROR;
1354: END;
1355:
1356: --if it is a work request

Line 1374: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_EZWO_WQ_NOTUNIQUE');

1370: where r.work_request_number = p_work_request_number;
1371:
1372: -- unique
1373: if(l_count > 1) then
1374: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_EZWO_WQ_NOTUNIQUE');
1375: x_return_status := FND_API.G_RET_STS_ERROR;
1376: elsif (l_count <1) then
1377: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_EZWO_WQ_NOTFOUND');
1378: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1377: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_EZWO_WQ_NOTFOUND');

1373: if(l_count > 1) then
1374: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_EZWO_WQ_NOTUNIQUE');
1375: x_return_status := FND_API.G_RET_STS_ERROR;
1376: elsif (l_count <1) then
1377: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_EZWO_WQ_NOTFOUND');
1378: x_return_status := FND_API.G_RET_STS_ERROR;
1379: end if;
1380: end if;
1381:

Line 1391: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_EZWO_WQ_CONFLICT');

1387: where r.work_request_id = l_work_request_id for update;
1388:
1389: if(l_work_request_number <> p_work_request_number) then
1390: -- should not happen
1391: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_EZWO_WQ_CONFLICT');
1392: x_return_status := FND_API.G_RET_STS_ERROR;
1393: end if;
1394: if(l_work_request_wip_entity_id is not null) then
1395: -- has work order on work request

Line 1396: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_EZWO_WQ_WO_EXIST');

1392: x_return_status := FND_API.G_RET_STS_ERROR;
1393: end if;
1394: if(l_work_request_wip_entity_id is not null) then
1395: -- has work order on work request
1396: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_EZWO_WQ_WO_EXIST');
1397: x_return_status := FND_API.G_RET_STS_ERROR;
1398: end if;
1399: if(l_work_request_status <> 3) then
1400: -- has work order on work request

Line 1401: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_EZWO_WQ_STATUS_WRONG');

1397: x_return_status := FND_API.G_RET_STS_ERROR;
1398: end if;
1399: if(l_work_request_status <> 3) then
1400: -- has work order on work request
1401: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_EZWO_WQ_STATUS_WRONG');
1402: x_return_status := FND_API.G_RET_STS_ERROR;
1403: end if;
1404: end if;
1405: EXCEPTION WHEN OTHERS THEN

Line 1407: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_EZWO_WQID_NOTFOUND');

1403: end if;
1404: end if;
1405: EXCEPTION WHEN OTHERS THEN
1406: -- only occur if work request not exist, should not happen
1407: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_EZWO_WQID_NOTFOUND');
1408: x_return_status := FND_API.G_RET_STS_ERROR;
1409: END;
1410: end if;
1411:

Line 1422: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_EZWO_PARENT_WO_BAD');

1418: WHERE wip_entity_name=p_parent_work_order
1419: AND organization_id=p_organization_id;
1420: exception
1421: when others then
1422: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_EZWO_PARENT_WO_BAD');
1423: x_return_status := FND_API.G_RET_STS_ERROR;
1424: end;
1425: end if;
1426: --end of fix for 3396024

Line 1441: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_GENERIC_ERROR',

1437: and organization_id = p_organization_id;
1438: end if;
1439:
1440: EXCEPTION WHEN OTHERS THEN
1441: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_GENERIC_ERROR',
1442: p_token1 => 'EAM_ERROR', p_value1 => sqlerrm);
1443: x_return_status := FND_API.G_RET_STS_ERROR;
1444: END;
1445:

Line 1466: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_EZWO_BAD_SERVICE_REQUEST');

1462: l_service_request_id := p_service_request_id;
1463:
1464: end if;
1465: EXCEPTION WHEN OTHERS THEN
1466: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_EZWO_BAD_SERVICE_REQUEST');
1467: x_return_status := FND_API.G_RET_STS_ERROR;
1468: END;
1469: end if;
1470:

Line 1475: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_EZWO_PROJECT_REQUIRED');

1471: -- Project and task validation
1472: BEGIN
1473:
1474: if p_project_number is null and p_task_number is not null then
1475: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_EZWO_PROJECT_REQUIRED');
1476: x_return_status := FND_API.G_RET_STS_ERROR;
1477: end if;
1478:
1479: -- set profile values to be used by PJM Views. Bug#4384541

Line 1491: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_EZWO_BAD_PROJECT');

1487: and ppp.organization_id = p_organization_id
1488: and ppv.project_number = p_project_number
1489: and rownum <= 1;
1490: if l_count <> 1 then
1491: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_EZWO_BAD_PROJECT');
1492: x_return_status := FND_API.G_RET_STS_ERROR;
1493: else
1494: select ppv.project_id into l_project_id
1495: from pjm_projects_v ppv,

Line 1507: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_GENERIC_ERROR',

1503: /* Bug # 4862404 : Removed the validation for project_id and task_id as we
1504: calling WO API */
1505:
1506: EXCEPTION WHEN OTHERS THEN
1507: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_GENERIC_ERROR',
1508: p_token1 => 'EAM_ERROR', p_value1 => SQLERRM);
1509: x_return_status := FND_API.G_RET_STS_ERROR;
1510: END;
1511: -- Check Validation Errors

Line 1516: eam_execution_jsp.Get_Messages

1512:
1513: -- if validate not passed then raise error
1514: l_msg_count := FND_MSG_PUB.count_msg;
1515: IF l_msg_count = 1 THEN
1516: eam_execution_jsp.Get_Messages
1517: (p_encoded => FND_API.G_FALSE,
1518: p_msg_index => 1,
1519: p_msg_count => l_msg_count,
1520: p_msg_data => nvl(l_msg_data,FND_API.g_MISS_CHAR) ,

Line 1691: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_GENERIC_ERROR',

1687: and we.organization_id = wdj.organization_id
1688: and we.wip_entity_id = wdj.wip_entity_id;
1689:
1690: EXCEPTION WHEN OTHERS THEN
1691: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_GENERIC_ERROR',
1692: p_token1 => 'EAM_ERROR', p_value1 => SQLERRM);
1693: x_return_status := FND_API.G_RET_STS_ERROR;
1694: end;
1695:

Line 1982: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_GENERIC_ERROR',

1978: RAISE FND_API.G_EXC_ERROR;
1979: end if;
1980:
1981: EXCEPTION WHEN OTHERS THEN
1982: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_GENERIC_ERROR',
1983: p_token1 => 'EAM_ERROR', p_value1 => SQLERRM);
1984: x_return_status := FND_API.G_RET_STS_ERROR;
1985: END;
1986:

Line 2046: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_WO_SERVICE_REQUEST_EXISTS');

2042: and wip_entity_id=l_wip_entity_updt
2043: and (enable_flag IS NULL OR enable_flag='Y'); -- Fix for Bug 3773450
2044:
2045: if(l_orig_service_request_id<>l_service_request_id) then
2046: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_WO_SERVICE_REQUEST_EXISTS');
2047: x_return_status := FND_API.G_RET_STS_ERROR;
2048: end if;
2049: end if;
2050:

Line 2069: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_EZWO_BAD_SERVICE_REQUEST');

2065: end if;
2066: end if;
2067: EXCEPTION
2068: WHEN OTHERS THEN
2069: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_EZWO_BAD_SERVICE_REQUEST');
2070: x_return_status := FND_API.G_RET_STS_ERROR;
2071:
2072: END;
2073:

Line 2299: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_GENERIC_ERROR',

2295: x_return_status := l_return_status;
2296: -- End of Call to Work Order PL/SQL API
2297:
2298: EXCEPTION WHEN OTHERS THEN
2299: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_GENERIC_ERROR',
2300: p_token1 => 'EAM_ERROR', p_value1 => SQLERRM);
2301: x_return_status := FND_API.G_RET_STS_ERROR;
2302: END;
2303:

Line 2370: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_EZWO_BAD_SERVICE_REQUEST');

2366: end if;
2367: end if;
2368: EXCEPTION
2369: WHEN OTHERS THEN
2370: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_EZWO_BAD_SERVICE_REQUEST');
2371: x_return_status := FND_API.G_RET_STS_ERROR;
2372:
2373: END;
2374:

Line 2472: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_WO_EXCEPTION'

2468: COMMIT WORK;
2469: END IF;
2470:
2471: EXCEPTION WHEN OTHERS THEN -- all dml excpetion
2472: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_WO_EXCEPTION'
2473: , p_token1 => 'TEXT', p_value1 => SQLERRM);
2474: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2475:
2476: l_msg_count := FND_MSG_PUB.count_msg;

Line 2478: eam_execution_jsp.Get_Messages

2474: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2475:
2476: l_msg_count := FND_MSG_PUB.count_msg;
2477: IF l_msg_count = 1 THEN
2478: eam_execution_jsp.Get_Messages
2479: (p_encoded => FND_API.G_FALSE,
2480: p_msg_index => 1,
2481: p_msg_count => l_msg_count,
2482: p_msg_data => nvl(l_msg_data,FND_API.g_MISS_CHAR) ,

Line 2608: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_WO_STALED_DATA');

2604: WHERE wip_entity_id = p_wip_entity_id
2605: FOR UPDATE;
2606:
2607: IF l_db_last_update_date <> p_stored_last_update_date THEN
2608: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_WO_STALED_DATA');
2609: x_return_status := FND_API.G_RET_STS_ERROR;
2610: END IF;
2611: EXCEPTION WHEN OTHERS THEN
2612: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_WO_NOT_FOUND');

Line 2612: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_WO_NOT_FOUND');

2608: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_WO_STALED_DATA');
2609: x_return_status := FND_API.G_RET_STS_ERROR;
2610: END IF;
2611: EXCEPTION WHEN OTHERS THEN
2612: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_WO_NOT_FOUND');
2613: x_return_status := FND_API.G_RET_STS_ERROR;
2614: END;
2615:
2616: BEGIN

Line 2624: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_DEPT_NOT_FOUND');

2620: where organization_id = l_org_id
2621: and department_code = p_owning_department;
2622:
2623: EXCEPTION WHEN OTHERS THEN
2624: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_DEPT_NOT_FOUND');
2625: x_return_status := FND_API.G_RET_STS_ERROR;
2626: END;
2627:
2628: if( p_firm_planned_flag = 1) then

Line 2630: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_WO_UPDATE_DATE_MISS');

2626: END;
2627:
2628: if( p_firm_planned_flag = 1) then
2629: if(p_scheduled_start_date is null) then
2630: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_WO_UPDATE_DATE_MISS');
2631: x_return_status := FND_API.G_RET_STS_ERROR;
2632: end if;
2633: end if;
2634:

Line 2638: eam_execution_jsp.Get_Messages

2634:
2635: -- if validate not passed then raise error
2636: l_msg_count := FND_MSG_PUB.count_msg;
2637: IF l_msg_count = 1 THEN
2638: eam_execution_jsp.Get_Messages
2639: (p_encoded => FND_API.G_FALSE,
2640: p_msg_index => 1,
2641: p_msg_count => l_msg_count,
2642: p_msg_data => nvl(l_msg_data,FND_API.g_MISS_CHAR) ,

Line 2701: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_WO_EXCEPTION'

2697: , wor.last_update_login = g_last_update_login
2698: where wor.wip_entity_id = p_wip_entity_id;
2699: end if;
2700: EXCEPTION WHEN OTHERS THEN
2701: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_WO_EXCEPTION'
2702: ,p_token1 => 'TEXT', p_value1 => SQLERRM);
2703: x_return_status := FND_API.G_RET_STS_ERROR;
2704: END;
2705:

Line 2709: eam_execution_jsp.Get_Messages

2705:
2706: -- if DML not passed then raise error
2707: l_msg_count := FND_MSG_PUB.count_msg;
2708: IF l_msg_count = 1 THEN
2709: eam_execution_jsp.Get_Messages
2710: (p_encoded => FND_API.G_FALSE,
2711: p_msg_index => 1,
2712: p_msg_count => l_msg_count,
2713: p_msg_data => nvl(l_msg_data,FND_API.g_MISS_CHAR) ,

Line 2948: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_NOT_ENOUGH_VALUES');

2944: END IF;
2945:
2946: IF p_prior_object_id = 0000 OR p_next_object_id = 0000 THEN
2947: x_return_status := FND_API.G_RET_STS_ERROR;
2948: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_NOT_ENOUGH_VALUES');
2949: return;
2950: END IF;
2951:
2952: EAM_WORKORDER_UTIL_PKG.log_path(l_output_dir);