DBA Data[Home] [Help]

APPS.EAM_WORKORDER_UTIL_PKG dependencies on FND_MESSAGE

Line 740: FND_MESSAGE.SET_NAME('EAM', 'EAM_ORG_ACCESS_VIOLATION');

736: fnd_profile.get('MFG_ORGANIZATION_ID', l_organization_id);
737: open C_RESPS ;
738: fetch C_RESPS into l_resp_key, l_resp_id, l_resp_app_id, l_menu_id;
739: if( C_RESPS%NOTFOUND ) then
740: FND_MESSAGE.SET_NAME('EAM', 'EAM_ORG_ACCESS_VIOLATION');
741: APP_EXCEPTION.RAISE_EXCEPTION;
742: end if;
743: x_out := l_resp_key;
744: x_resp_id := l_resp_id;

Line 800: fnd_message.set_name('EAM','EAM_RESP_NOT_AVAILABLE'); --show message that resp. is not available

796: from fnd_form_functions
797: where function_name = l_function_name;
798: EXCEPTION
799: WHEN NO_DATA_FOUND THEN
800: fnd_message.set_name('EAM','EAM_RESP_NOT_AVAILABLE'); --show message that resp. is not available
801: APP_EXCEPTION.RAISE_EXCEPTION;
802: END;
803:
804: -- EAM uses 426 as application id

Line 810: fnd_message.set_name('EAM','EAM_RESP_NOT_AVAILABLE'); --show message that resp. is not available

806:
807: get_resp_for_func(l_eam_function_id,FND_GLOBAL.user_id, null, l_resp_id, l_resp_key);
808:
809: IF(l_resp_id = -1) THEN
810: fnd_message.set_name('EAM','EAM_RESP_NOT_AVAILABLE'); --show message that resp. is not available
811: APP_EXCEPTION.RAISE_EXCEPTION;
812: END IF;
813:
814: RETURN l_resp_id;

Line 895: FND_MESSAGE.SET_NAME('WIP','WIP_UNRLS_JOB/SCHED_OPEN_PO');

891: IF (WIP_OSP.PO_REQ_EXISTS( p_wip_entity_id => x_wip_id
892: ,p_rep_sched_id => x_rep_id
893: ,p_organization_id => x_org_id
894: ,p_entity_type => x_ent_type ) = TRUE) THEN
895: FND_MESSAGE.SET_NAME('WIP','WIP_UNRLS_JOB/SCHED_OPEN_PO');
896: APP_EXCEPTION.RAISE_EXCEPTION;
897: RETURN;
898: END IF;
899:

Line 983: FND_MESSAGE.SET_NAME('WIP','WIP_UNRLS_JOB/SCHED_OPEN_PO');

979: -- bug fix 2675869: removed following group by clause for performance
980: -- group by work_order_number;
981:
982: if (quantity_left > 0) then
983: FND_MESSAGE.SET_NAME('WIP','WIP_UNRLS_JOB/SCHED_OPEN_PO');
984: APP_EXCEPTION.RAISE_EXCEPTION;
985: /* Bug#3022963: The 'RETURN' was placed outside the quantity_left check causing
986: the procedure to return without making other checks */
987: RETURN;

Line 1031: FND_MESSAGE.SET_NAME('WIP','WIP_UNRLS_JOB/SCHED');

1027: OR WPB.PL_OUTSIDE_PROCESSING_OUT <> 0)
1028: AND ROWNUM <= 1;
1029:
1030: if charges_exist_1 = '1' then
1031: FND_MESSAGE.SET_NAME('WIP','WIP_UNRLS_JOB/SCHED');
1032: APP_EXCEPTION.RAISE_EXCEPTION;
1033: /* Bug#3022963: The 'RETURN' was placed outside the quantity_left check causing
1034: the procedure to return without making other checks */
1035: RETURN;

Line 1062: FND_MESSAGE.SET_NAME('WIP','WIP_UNRLS_JOB/SCHED');

1058: WHERE ORGANIZATION_ID = x_org_id
1059: AND WIP_ENTITY_ID = x_wip_id);
1060:
1061: if charges_exist_2 = '1' then
1062: FND_MESSAGE.SET_NAME('WIP','WIP_UNRLS_JOB/SCHED');
1063: APP_EXCEPTION.RAISE_EXCEPTION;
1064: /* Bug#3022963: The 'RETURN' was placed outside the quantity_left check causing
1065: the procedure to return without making other checks */
1066: RETURN;

Line 1086: FND_MESSAGE.SET_NAME('WIP','WIP_UNRLS_JOB/SCHED');

1082: WHERE organization_id = x_org_id
1083: AND transaction_source_type_id = 5
1084: AND transaction_source_id = x_wip_id);
1085: if charges_exist_3 = '1' then
1086: FND_MESSAGE.SET_NAME('WIP','WIP_UNRLS_JOB/SCHED');
1087: APP_EXCEPTION.RAISE_EXCEPTION;
1088: /* Bug#3022963: The 'RETURN' was placed outside the quantity_left check causing
1089: the procedure to return without making other checks */
1090: RETURN;

Line 1105: FND_MESSAGE.SET_NAME('WIP','WIP_UNRLS_JOB/SCHED');

1101: AND WIP_ENTITY_ID = x_wip_id
1102: AND APPLIED_RESOURCE_UNITS <> 0);
1103:
1104: if charges_exist_3 = '1' then
1105: FND_MESSAGE.SET_NAME('WIP','WIP_UNRLS_JOB/SCHED');
1106: APP_EXCEPTION.RAISE_EXCEPTION;
1107: /* Bug#3022963: The 'RETURN' was placed outside the quantity_left check causing
1108: the procedure to return without making other checks */
1109: RETURN;

Line 1131: FND_MESSAGE.SET_NAME('WIP','WIP_UNRLS_JOB/SCHED');

1127: QUANTITY_COMPLETED = 0
1128: WHERE WIP_ENTITY_ID = x_wip_id
1129: AND ORGANIZATION_ID = x_org_id;
1130: ELSE
1131: FND_MESSAGE.SET_NAME('WIP','WIP_UNRLS_JOB/SCHED');
1132: APP_EXCEPTION.RAISE_EXCEPTION;
1133: RETURN;
1134: END IF;
1135:

Line 1410: fnd_message.set_name('EAM','EAM_WO_API_MESG');

1406: p_msg_index_out => msg_index);
1407: msg_index := msg_index-1;
1408: mesg := mesg || ' ' || to_char(i) || ' . '||temp ;
1409: end loop;
1410: fnd_message.set_name('EAM','EAM_WO_API_MESG');
1411:
1412: fnd_message.set_token(token => 'MESG',
1413: value =>mesg,
1414: translate =>FALSE);

Line 1412: fnd_message.set_token(token => 'MESG',

1408: mesg := mesg || ' ' || to_char(i) || ' . '||temp ;
1409: end loop;
1410: fnd_message.set_name('EAM','EAM_WO_API_MESG');
1411:
1412: fnd_message.set_token(token => 'MESG',
1413: value =>mesg,
1414: translate =>FALSE);
1415: APP_EXCEPTION.RAISE_EXCEPTION;
1416: END IF;

Line 1685: fnd_message.set_name('EAM','EAM_UPDATE_WO_TXN_OPEN');

1681:
1682: /* Code Added for bug#5335940 Start */
1683: IF ( charges_exist_2 = '1' AND charges_exist_3 = '0' ) THEN
1684: p_return_status := 1;
1685: fnd_message.set_name('EAM','EAM_UPDATE_WO_TXN_OPEN');
1686: fnd_message.set_token(token => 'TXN', value => 'EAM_MATERIAL', translate => TRUE );
1687: p_return_string := fnd_message.get;
1688: ELSIF ( charges_exist_2 = '0' AND charges_exist_3 = '1' ) THEN
1689: p_return_status := 1;

Line 1686: fnd_message.set_token(token => 'TXN', value => 'EAM_MATERIAL', translate => TRUE );

1682: /* Code Added for bug#5335940 Start */
1683: IF ( charges_exist_2 = '1' AND charges_exist_3 = '0' ) THEN
1684: p_return_status := 1;
1685: fnd_message.set_name('EAM','EAM_UPDATE_WO_TXN_OPEN');
1686: fnd_message.set_token(token => 'TXN', value => 'EAM_MATERIAL', translate => TRUE );
1687: p_return_string := fnd_message.get;
1688: ELSIF ( charges_exist_2 = '0' AND charges_exist_3 = '1' ) THEN
1689: p_return_status := 1;
1690: fnd_message.set_name('EAM','EAM_UPDATE_WO_TXN_OPEN');

Line 1687: p_return_string := fnd_message.get;

1683: IF ( charges_exist_2 = '1' AND charges_exist_3 = '0' ) THEN
1684: p_return_status := 1;
1685: fnd_message.set_name('EAM','EAM_UPDATE_WO_TXN_OPEN');
1686: fnd_message.set_token(token => 'TXN', value => 'EAM_MATERIAL', translate => TRUE );
1687: p_return_string := fnd_message.get;
1688: ELSIF ( charges_exist_2 = '0' AND charges_exist_3 = '1' ) THEN
1689: p_return_status := 1;
1690: fnd_message.set_name('EAM','EAM_UPDATE_WO_TXN_OPEN');
1691: fnd_message.set_token(token => 'TXN', value => 'EAM_RESOURCE', translate => TRUE );

Line 1690: fnd_message.set_name('EAM','EAM_UPDATE_WO_TXN_OPEN');

1686: fnd_message.set_token(token => 'TXN', value => 'EAM_MATERIAL', translate => TRUE );
1687: p_return_string := fnd_message.get;
1688: ELSIF ( charges_exist_2 = '0' AND charges_exist_3 = '1' ) THEN
1689: p_return_status := 1;
1690: fnd_message.set_name('EAM','EAM_UPDATE_WO_TXN_OPEN');
1691: fnd_message.set_token(token => 'TXN', value => 'EAM_RESOURCE', translate => TRUE );
1692: p_return_string := fnd_message.get;
1693: ElSIF ( charges_exist_2 = '1' AND charges_exist_3 = '1' ) THEN
1694: p_return_status := 1;

Line 1691: fnd_message.set_token(token => 'TXN', value => 'EAM_RESOURCE', translate => TRUE );

1687: p_return_string := fnd_message.get;
1688: ELSIF ( charges_exist_2 = '0' AND charges_exist_3 = '1' ) THEN
1689: p_return_status := 1;
1690: fnd_message.set_name('EAM','EAM_UPDATE_WO_TXN_OPEN');
1691: fnd_message.set_token(token => 'TXN', value => 'EAM_RESOURCE', translate => TRUE );
1692: p_return_string := fnd_message.get;
1693: ElSIF ( charges_exist_2 = '1' AND charges_exist_3 = '1' ) THEN
1694: p_return_status := 1;
1695: fnd_message.set_name('EAM','EAM_UPDATE_WO_TXN_OPEN');

Line 1692: p_return_string := fnd_message.get;

1688: ELSIF ( charges_exist_2 = '0' AND charges_exist_3 = '1' ) THEN
1689: p_return_status := 1;
1690: fnd_message.set_name('EAM','EAM_UPDATE_WO_TXN_OPEN');
1691: fnd_message.set_token(token => 'TXN', value => 'EAM_RESOURCE', translate => TRUE );
1692: p_return_string := fnd_message.get;
1693: ElSIF ( charges_exist_2 = '1' AND charges_exist_3 = '1' ) THEN
1694: p_return_status := 1;
1695: fnd_message.set_name('EAM','EAM_UPDATE_WO_TXN_OPEN');
1696: fnd_message.set_token(token => 'TXN', value => 'EAM_MATERIAL_RESOURCE', translate => TRUE );

Line 1695: fnd_message.set_name('EAM','EAM_UPDATE_WO_TXN_OPEN');

1691: fnd_message.set_token(token => 'TXN', value => 'EAM_RESOURCE', translate => TRUE );
1692: p_return_string := fnd_message.get;
1693: ElSIF ( charges_exist_2 = '1' AND charges_exist_3 = '1' ) THEN
1694: p_return_status := 1;
1695: fnd_message.set_name('EAM','EAM_UPDATE_WO_TXN_OPEN');
1696: fnd_message.set_token(token => 'TXN', value => 'EAM_MATERIAL_RESOURCE', translate => TRUE );
1697: p_return_string := fnd_message.get;
1698: ELSE
1699: p_return_status:=0; p_return_status:=0;

Line 1696: fnd_message.set_token(token => 'TXN', value => 'EAM_MATERIAL_RESOURCE', translate => TRUE );

1692: p_return_string := fnd_message.get;
1693: ElSIF ( charges_exist_2 = '1' AND charges_exist_3 = '1' ) THEN
1694: p_return_status := 1;
1695: fnd_message.set_name('EAM','EAM_UPDATE_WO_TXN_OPEN');
1696: fnd_message.set_token(token => 'TXN', value => 'EAM_MATERIAL_RESOURCE', translate => TRUE );
1697: p_return_string := fnd_message.get;
1698: ELSE
1699: p_return_status:=0; p_return_status:=0;
1700: p_return_string := null;

Line 1697: p_return_string := fnd_message.get;

1693: ElSIF ( charges_exist_2 = '1' AND charges_exist_3 = '1' ) THEN
1694: p_return_status := 1;
1695: fnd_message.set_name('EAM','EAM_UPDATE_WO_TXN_OPEN');
1696: fnd_message.set_token(token => 'TXN', value => 'EAM_MATERIAL_RESOURCE', translate => TRUE );
1697: p_return_string := fnd_message.get;
1698: ELSE
1699: p_return_status:=0; p_return_status:=0;
1700: p_return_string := null;
1701: END IF;

Line 1780: fnd_message.set_name ('EAM','EAM_UPDATE_WO_CONFIRM_CANCEL');

1776: x_return_status:=1;
1777: x_return_string := l_return_string;
1778: ELSIF ( l_po_exists = '1' AND l_txn_exists = '0' ) THEN
1779: x_return_status:=1;
1780: fnd_message.set_name ('EAM','EAM_UPDATE_WO_CONFIRM_CANCEL');
1781: x_return_string := fnd_message.get;
1782: ELSIF ( l_po_exists = '1' AND l_txn_exists = '1' ) THEN
1783: fnd_message.set_name ('EAM','EAM_UPDATE_WO_CONFIRM_CANCEL');
1784: x_return_string := fnd_message.get;

Line 1781: x_return_string := fnd_message.get;

1777: x_return_string := l_return_string;
1778: ELSIF ( l_po_exists = '1' AND l_txn_exists = '0' ) THEN
1779: x_return_status:=1;
1780: fnd_message.set_name ('EAM','EAM_UPDATE_WO_CONFIRM_CANCEL');
1781: x_return_string := fnd_message.get;
1782: ELSIF ( l_po_exists = '1' AND l_txn_exists = '1' ) THEN
1783: fnd_message.set_name ('EAM','EAM_UPDATE_WO_CONFIRM_CANCEL');
1784: x_return_string := fnd_message.get;
1785: x_return_string := l_return_string || x_return_string;

Line 1783: fnd_message.set_name ('EAM','EAM_UPDATE_WO_CONFIRM_CANCEL');

1779: x_return_status:=1;
1780: fnd_message.set_name ('EAM','EAM_UPDATE_WO_CONFIRM_CANCEL');
1781: x_return_string := fnd_message.get;
1782: ELSIF ( l_po_exists = '1' AND l_txn_exists = '1' ) THEN
1783: fnd_message.set_name ('EAM','EAM_UPDATE_WO_CONFIRM_CANCEL');
1784: x_return_string := fnd_message.get;
1785: x_return_string := l_return_string || x_return_string;
1786: ELSE
1787: x_return_status:=0;

Line 1784: x_return_string := fnd_message.get;

1780: fnd_message.set_name ('EAM','EAM_UPDATE_WO_CONFIRM_CANCEL');
1781: x_return_string := fnd_message.get;
1782: ELSIF ( l_po_exists = '1' AND l_txn_exists = '1' ) THEN
1783: fnd_message.set_name ('EAM','EAM_UPDATE_WO_CONFIRM_CANCEL');
1784: x_return_string := fnd_message.get;
1785: x_return_string := l_return_string || x_return_string;
1786: ELSE
1787: x_return_status:=0;
1788: x_return_string := null;