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 734: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_RET_MAT_INVALID_LOCATOR');

730: exception
731: when no_data_found then
732: -- x_error_flag := 1;
733: -- x_error_mssg := 'EAM_RET_MAT_INVALID_LOCATOR';
734: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_RET_MAT_INVALID_LOCATOR');
735: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
736: return;
737: end;
738: end if;

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

757: if(l_locator_ctrl = 2 or l_locator_ctrl = 3) then
758: if(l_locator_id IS NULL) then
759: /* l_error_flag := 1;
760: l_error_mssg := 'EAM_RET_MAT_LOCATOR_NEEDED'; */
761: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_RET_MAT_LOCATOR_NEEDED');
762: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
763: return;
764: end if;
765: elsif(l_locator_ctrl = 1) then -- If the locator control is NOControl

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

765: elsif(l_locator_ctrl = 1) then -- If the locator control is NOControl
766: if(l_locator_id IS NOT NULL) then
767: /* l_error_flag := 1;
768: l_error_mssg := 'EAM_RET_MAT_LOCATOR_RESTRICTED'; */
769: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_RET_MAT_LOCATOR_RESTRICTED');
770: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
771: return;
772: end if;
773: end if; -- end of locator_control checkif

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

784: inventory_item_id = p_item_id
785: and organization_id = p_org_id;
786: exception
787: when NO_DATA_FOUND then
788: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_NO_LOT_NUMBER');
789: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
790: end;
791: else
792: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_LOT_NEEDED');

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

788: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_NO_LOT_NUMBER');
789: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
790: end;
791: else
792: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_LOT_NEEDED');
793: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
794: end if;
795: else
796: if(p_lot is not null) then

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

793: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
794: end if;
795: else
796: if(p_lot is not null) then
797: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_LOT_NOT_NEEDED');
798: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
799: end if;
800: end if; -- end of lot entry check
801:

Line 811: eam_execution_jsp.Get_Messages

807:
808: -- if validate not passed then raise error
809: l_msg_count := FND_MSG_PUB.count_msg;
810: IF l_msg_count = 1 THEN
811: eam_execution_jsp.Get_Messages
812: (p_encoded => FND_API.G_FALSE,
813: p_msg_index => 1,
814: p_msg_count => l_msg_count,
815: p_msg_data => nvl(l_msg_data,FND_API.g_MISS_CHAR),

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

865: ,x_attribute15 => p_attribute15
866: );
867:
868: IF (l_err_number = 2) THEN
869: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name =>'EAM_WO_NO_UNCOMPLETE' );
870: x_return_status := FND_API.G_RET_STS_ERROR;
871: ELSIF (l_err_number > 0 ) THEN
872: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name =>l_err_code);
873: x_return_status := FND_API.G_RET_STS_ERROR;

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

868: IF (l_err_number = 2) THEN
869: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name =>'EAM_WO_NO_UNCOMPLETE' );
870: x_return_status := FND_API.G_RET_STS_ERROR;
871: ELSIF (l_err_number > 0 ) THEN
872: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name =>l_err_code);
873: x_return_status := FND_API.G_RET_STS_ERROR;
874: END IF;
875:
876: EXCEPTION WHEN OTHERS THEN

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

873: x_return_status := FND_API.G_RET_STS_ERROR;
874: END IF;
875:
876: EXCEPTION WHEN OTHERS THEN
877: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_WO_EXCEPTION',
878: p_token1 => 'TEXT', p_value1 => sqlerrm);
879: x_return_status := FND_API.G_RET_STS_ERROR;
880: END;
881:

Line 886: eam_execution_jsp.Get_Messages

882:
883: -- if DML not passed then raise error
884: l_msg_count := FND_MSG_PUB.count_msg;
885: IF l_msg_count = 1 THEN
886: eam_execution_jsp.Get_Messages
887: (p_encoded => FND_API.G_FALSE,
888: p_msg_index => 1,
889: p_msg_count => l_msg_count,
890: p_msg_data => nvl(l_msg_data,FND_API.g_MISS_CHAR) ,

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

1305: asset_status := 4; --inactive
1306: end if;
1307:
1308: 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
1309: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_DEACTIVATE_CANNOT_UNCANCEL',
1310: p_token1 => 'NAME', p_value1 => p_wip_entity_name);
1311: x_return_status := FND_API.G_RET_STS_ERROR;
1312: return;
1313: end if;

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

1355: l_maintenance_object_id:=l_asset_group_id;
1356: l_maintenance_object_type:=2;
1357: exception
1358: when others then
1359: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_EZWO_ASSET_BAD');
1360: x_return_status := FND_API.G_RET_STS_ERROR;
1361: end;
1362: end if;
1363:

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

1363:
1364: l_maintenance_object_source:=1;
1365:
1366: EXCEPTION WHEN OTHERS THEN
1367: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_EZWO_ASSET_BAD');
1368: x_return_status := FND_API.G_RET_STS_ERROR;
1369: END;
1370:
1371: -- get owning department id

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

1379: where organization_id = p_organization_id
1380: and department_code = p_owning_department;
1381: END IF;
1382: EXCEPTION WHEN OTHERS THEN
1383: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_EZWO_DEPT_BAD');
1384: x_return_status := FND_API.G_RET_STS_ERROR;
1385: END;
1386:
1387: --if it is a work request

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

1401: where r.work_request_number = p_work_request_number;
1402:
1403: -- unique
1404: if(l_count > 1) then
1405: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_EZWO_WQ_NOTUNIQUE');
1406: x_return_status := FND_API.G_RET_STS_ERROR;
1407: elsif (l_count <1) then
1408: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_EZWO_WQ_NOTFOUND');
1409: x_return_status := FND_API.G_RET_STS_ERROR;

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

1404: if(l_count > 1) then
1405: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_EZWO_WQ_NOTUNIQUE');
1406: x_return_status := FND_API.G_RET_STS_ERROR;
1407: elsif (l_count <1) then
1408: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_EZWO_WQ_NOTFOUND');
1409: x_return_status := FND_API.G_RET_STS_ERROR;
1410: end if;
1411: end if;
1412:

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

1418: where r.work_request_id = l_work_request_id for update;
1419:
1420: if(l_work_request_number <> p_work_request_number) then
1421: -- should not happen
1422: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_EZWO_WQ_CONFLICT');
1423: x_return_status := FND_API.G_RET_STS_ERROR;
1424: end if;
1425: if(l_work_request_wip_entity_id is not null) then
1426: -- has work order on work request

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

1423: x_return_status := FND_API.G_RET_STS_ERROR;
1424: end if;
1425: if(l_work_request_wip_entity_id is not null) then
1426: -- has work order on work request
1427: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_EZWO_WQ_WO_EXIST');
1428: x_return_status := FND_API.G_RET_STS_ERROR;
1429: end if;
1430: if(l_work_request_status <> 3) then
1431: -- has work order on work request

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

1428: x_return_status := FND_API.G_RET_STS_ERROR;
1429: end if;
1430: if(l_work_request_status <> 3) then
1431: -- has work order on work request
1432: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_EZWO_WQ_STATUS_WRONG');
1433: x_return_status := FND_API.G_RET_STS_ERROR;
1434: end if;
1435: end if;
1436: EXCEPTION WHEN OTHERS THEN

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

1434: end if;
1435: end if;
1436: EXCEPTION WHEN OTHERS THEN
1437: -- only occur if work request not exist, should not happen
1438: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_EZWO_WQID_NOTFOUND');
1439: x_return_status := FND_API.G_RET_STS_ERROR;
1440: END;
1441: end if;
1442:

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

1449: WHERE wip_entity_name=p_parent_work_order
1450: AND organization_id=p_organization_id;
1451: exception
1452: when others then
1453: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_EZWO_PARENT_WO_BAD');
1454: x_return_status := FND_API.G_RET_STS_ERROR;
1455: end;
1456: end if;
1457: --end of fix for 3396024

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

1468: and organization_id = p_organization_id;
1469: end if;
1470:
1471: EXCEPTION WHEN OTHERS THEN
1472: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_GENERIC_ERROR',
1473: p_token1 => 'EAM_ERROR', p_value1 => sqlerrm);
1474: x_return_status := FND_API.G_RET_STS_ERROR;
1475: END;
1476:

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

1493: l_service_request_id := p_service_request_id;
1494:
1495: end if;
1496: EXCEPTION WHEN OTHERS THEN
1497: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_EZWO_BAD_SERVICE_REQUEST');
1498: x_return_status := FND_API.G_RET_STS_ERROR;
1499: END;
1500: end if;
1501:

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

1502: -- Project and task validation
1503: BEGIN
1504:
1505: if p_project_number is null and p_task_number is not null then
1506: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_EZWO_PROJECT_REQUIRED');
1507: x_return_status := FND_API.G_RET_STS_ERROR;
1508: end if;
1509:
1510: -- set profile values to be used by PJM Views. Bug#4384541

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

1518: and ppp.organization_id = p_organization_id
1519: and ppv.project_number = p_project_number
1520: and rownum <= 1;
1521: if l_count <> 1 then
1522: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_EZWO_BAD_PROJECT');
1523: x_return_status := FND_API.G_RET_STS_ERROR;
1524: else
1525: select ppv.project_id into l_project_id
1526: from pjm_projects_v ppv,

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

1534: /* Bug # 4862404 : Removed the validation for project_id and task_id as we
1535: calling WO API */
1536:
1537: EXCEPTION WHEN OTHERS THEN
1538: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_GENERIC_ERROR',
1539: p_token1 => 'EAM_ERROR', p_value1 => SQLERRM);
1540: x_return_status := FND_API.G_RET_STS_ERROR;
1541: END;
1542: -- Check Validation Errors

Line 1547: eam_execution_jsp.Get_Messages

1543:
1544: -- if validate not passed then raise error
1545: l_msg_count := FND_MSG_PUB.count_msg;
1546: IF l_msg_count = 1 THEN
1547: eam_execution_jsp.Get_Messages
1548: (p_encoded => FND_API.G_FALSE,
1549: p_msg_index => 1,
1550: p_msg_count => l_msg_count,
1551: p_msg_data => nvl(l_msg_data,FND_API.g_MISS_CHAR) ,

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

1718: and we.organization_id = wdj.organization_id
1719: and we.wip_entity_id = wdj.wip_entity_id;
1720:
1721: EXCEPTION WHEN OTHERS THEN
1722: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_GENERIC_ERROR',
1723: p_token1 => 'EAM_ERROR', p_value1 => SQLERRM);
1724: x_return_status := FND_API.G_RET_STS_ERROR;
1725: end;
1726:

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

2009: RAISE FND_API.G_EXC_ERROR;
2010: end if;
2011:
2012: EXCEPTION WHEN OTHERS THEN
2013: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_GENERIC_ERROR',
2014: p_token1 => 'EAM_ERROR', p_value1 => SQLERRM);
2015: x_return_status := FND_API.G_RET_STS_ERROR;
2016: END;
2017:

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

2073: and wip_entity_id=l_wip_entity_updt
2074: and (enable_flag IS NULL OR enable_flag='Y'); -- Fix for Bug 3773450
2075:
2076: if(l_orig_service_request_id<>l_service_request_id) then
2077: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_WO_SERVICE_REQUEST_EXISTS');
2078: x_return_status := FND_API.G_RET_STS_ERROR;
2079: end if;
2080: end if;
2081:

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

2096: end if;
2097: end if;
2098: EXCEPTION
2099: WHEN OTHERS THEN
2100: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_EZWO_BAD_SERVICE_REQUEST');
2101: x_return_status := FND_API.G_RET_STS_ERROR;
2102:
2103: END;
2104:

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

2326: x_return_status := l_return_status;
2327: -- End of Call to Work Order PL/SQL API
2328:
2329: EXCEPTION WHEN OTHERS THEN
2330: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_GENERIC_ERROR',
2331: p_token1 => 'EAM_ERROR', p_value1 => SQLERRM);
2332: x_return_status := FND_API.G_RET_STS_ERROR;
2333: END;
2334:

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

2397: end if;
2398: end if;
2399: EXCEPTION
2400: WHEN OTHERS THEN
2401: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_EZWO_BAD_SERVICE_REQUEST');
2402: x_return_status := FND_API.G_RET_STS_ERROR;
2403:
2404: END;
2405:

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

2499: COMMIT WORK;
2500: END IF;
2501:
2502: EXCEPTION WHEN OTHERS THEN -- all dml excpetion
2503: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_WO_EXCEPTION'
2504: , p_token1 => 'TEXT', p_value1 => SQLERRM);
2505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2506:
2507: l_msg_count := FND_MSG_PUB.count_msg;

Line 2509: eam_execution_jsp.Get_Messages

2505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2506:
2507: l_msg_count := FND_MSG_PUB.count_msg;
2508: IF l_msg_count = 1 THEN
2509: eam_execution_jsp.Get_Messages
2510: (p_encoded => FND_API.G_FALSE,
2511: p_msg_index => 1,
2512: p_msg_count => l_msg_count,
2513: p_msg_data => nvl(l_msg_data,FND_API.g_MISS_CHAR) ,

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

2635: WHERE wip_entity_id = p_wip_entity_id
2636: FOR UPDATE;
2637:
2638: IF l_db_last_update_date <> p_stored_last_update_date THEN
2639: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_WO_STALED_DATA');
2640: x_return_status := FND_API.G_RET_STS_ERROR;
2641: END IF;
2642: EXCEPTION WHEN OTHERS THEN
2643: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_WO_NOT_FOUND');

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

2639: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_WO_STALED_DATA');
2640: x_return_status := FND_API.G_RET_STS_ERROR;
2641: END IF;
2642: EXCEPTION WHEN OTHERS THEN
2643: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_WO_NOT_FOUND');
2644: x_return_status := FND_API.G_RET_STS_ERROR;
2645: END;
2646:
2647: BEGIN

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

2651: where organization_id = l_org_id
2652: and department_code = p_owning_department;
2653:
2654: EXCEPTION WHEN OTHERS THEN
2655: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_DEPT_NOT_FOUND');
2656: x_return_status := FND_API.G_RET_STS_ERROR;
2657: END;
2658:
2659: if( p_firm_planned_flag = 1) then

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

2657: END;
2658:
2659: if( p_firm_planned_flag = 1) then
2660: if(p_scheduled_start_date is null) then
2661: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_WO_UPDATE_DATE_MISS');
2662: x_return_status := FND_API.G_RET_STS_ERROR;
2663: end if;
2664: end if;
2665:

Line 2669: eam_execution_jsp.Get_Messages

2665:
2666: -- if validate not passed then raise error
2667: l_msg_count := FND_MSG_PUB.count_msg;
2668: IF l_msg_count = 1 THEN
2669: eam_execution_jsp.Get_Messages
2670: (p_encoded => FND_API.G_FALSE,
2671: p_msg_index => 1,
2672: p_msg_count => l_msg_count,
2673: p_msg_data => nvl(l_msg_data,FND_API.g_MISS_CHAR) ,

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

2728: , wor.last_update_login = g_last_update_login
2729: where wor.wip_entity_id = p_wip_entity_id;
2730: end if;
2731: EXCEPTION WHEN OTHERS THEN
2732: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_WO_EXCEPTION'
2733: ,p_token1 => 'TEXT', p_value1 => SQLERRM);
2734: x_return_status := FND_API.G_RET_STS_ERROR;
2735: END;
2736:

Line 2740: eam_execution_jsp.Get_Messages

2736:
2737: -- if DML not passed then raise error
2738: l_msg_count := FND_MSG_PUB.count_msg;
2739: IF l_msg_count = 1 THEN
2740: eam_execution_jsp.Get_Messages
2741: (p_encoded => FND_API.G_FALSE,
2742: p_msg_index => 1,
2743: p_msg_count => l_msg_count,
2744: p_msg_data => nvl(l_msg_data,FND_API.g_MISS_CHAR) ,

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

2983: END IF;
2984:
2985: IF p_prior_object_id = 0000 OR p_next_object_id = 0000 THEN
2986: x_return_status := FND_API.G_RET_STS_ERROR;
2987: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_NOT_ENOUGH_VALUES');
2988: return;
2989: END IF;
2990:
2991: EAM_WORKORDER_UTIL_PKG.log_path(l_output_dir);