APPS.FEM_WEBADI_MEMBER_UTILS_PVT dependencies on FND_NEW_MESSAGES

Line 555: FROM FND_NEW_MESSAGES M1,

551: , l_interface_cols_tbl(i).SEQUENCE_NUM
552: , 274
553: , L.LANGUAGE_CODE
554: , USERENV('LANG')
555: FROM FND_NEW_MESSAGES M1,
556: FND_NEW_MESSAGES M2,
557: FND_LANGUAGES L
558: WHERE L.INSTALLED_FLAG IN ('I', 'B')
559: AND M1.MESSAGE_NAME (+)= l_interface_cols_tbl(i).FND_MESSAGE_NAME

Line 556: FND_NEW_MESSAGES M2,

552: , 274
553: , L.LANGUAGE_CODE
554: , USERENV('LANG')
555: FROM FND_NEW_MESSAGES M1,
556: FND_NEW_MESSAGES M2,
557: FND_LANGUAGES L
558: WHERE L.INSTALLED_FLAG IN ('I', 'B')
559: AND M1.MESSAGE_NAME (+)= l_interface_cols_tbl(i).FND_MESSAGE_NAME
560: AND M1.LANGUAGE_CODE (+)= L.LANGUAGE_CODE

Line 877: , FND_NEW_MESSAGES M

873: , B.SOURCE_LANG
874: FROM FEM_XDIM_DIMENSIONS_VL D
875: , FEM_DIM_ATTRIBUTES_B A
876: , FEM_DIM_ATTRIBUTES_TL B
877: , FND_NEW_MESSAGES M
878: , FND_LANGUAGES L
879: WHERE L.INSTALLED_FLAG IN ('I', 'B')
880: AND D.DIMENSION_VARCHAR_LABEL = p_dimension_varchar_label
881: AND D.DIMENSION_ID = A.DIMENSION_ID

Line 1044: , FND_NEW_MESSAGES M

1040: , B.SOURCE_LANG
1041: FROM FEM_XDIM_DIMENSIONS_VL D
1042: , FEM_DIM_ATTRIBUTES_B A
1043: , FEM_DIM_ATTRIBUTES_TL B
1044: , FND_NEW_MESSAGES M
1045: , FND_LANGUAGES L
1046: WHERE L.INSTALLED_FLAG IN ('I', 'B')
1047: AND D.DIMENSION_VARCHAR_LABEL = p_dimension_varchar_label
1048: AND D.DIMENSION_ID = A.DIMENSION_ID

Line 1258: , FND_NEW_MESSAGES M

1254: , B.SOURCE_LANG
1255: FROM FEM_XDIM_DIMENSIONS_VL D
1256: , FEM_DIM_ATTRIBUTES_B A
1257: , FEM_DIM_ATTRIBUTES_TL B
1258: , FND_NEW_MESSAGES M
1259: , FND_LANGUAGES L
1260: WHERE L.INSTALLED_FLAG IN ('I', 'B')
1261: AND D.DIMENSION_VARCHAR_LABEL = p_dimension_varchar_label
1262: AND D.DIMENSION_ID = A.DIMENSION_ID

Line 1574: , FND_NEW_MESSAGES M

1570: , DT.LANGUAGE
1571: , DT.SOURCE_LANG
1572: FROM FEM_DIMENSIONS_TL DT
1573: , FEM_DIMENSIONS_B DB
1574: , FND_NEW_MESSAGES M
1575: , FND_LANGUAGES L
1576: WHERE DB.DIMENSION_VARCHAR_LABEL = p_dimension_varchar_label
1577: AND DT.DIMENSION_ID = DB.DIMENSION_ID
1578: AND M.APPLICATION_ID= 274

Line 1704: FROM FND_NEW_MESSAGES M,

1700: , l_login_id
1701: , SYSDATE
1702: , L.LANGUAGE_CODE
1703: , USERENV('LANG')
1704: FROM FND_NEW_MESSAGES M,
1705: FND_LANGUAGES L
1706: WHERE M.MESSAGE_NAME = 'LAY_LB_HEADER'
1707: AND M.LANGUAGE_CODE = L.LANGUAGE_CODE
1708: AND L.INSTALLED_FLAG IN ('I', 'B');

Line 1838: FROM FND_NEW_MESSAGES M,

1834: , l_login_id
1835: , SYSDATE
1836: , L.LANGUAGE_CODE
1837: , USERENV('LANG')
1838: FROM FND_NEW_MESSAGES M,
1839: FND_LANGUAGES L
1840: WHERE M.MESSAGE_NAME = 'LAY_LB_LINE'
1841: AND M.LANGUAGE_CODE = L.LANGUAGE_CODE
1842: AND L.INSTALLED_FLAG IN ('I', 'B');

Line 2451: FROM FND_NEW_MESSAGES M,

2447: , l_user_id
2448: , SYSDATE
2449: , l_user_id
2450: , SYSDATE
2451: FROM FND_NEW_MESSAGES M,
2452: FND_LANGUAGES L
2453: WHERE M.MESSAGE_NAME = 'FEM_ADI_MEMBER_INTEGRATOR'
2454: AND M.LANGUAGE_CODE = L.LANGUAGE_CODE
2455: AND L.INSTALLED_FLAG IN ('I', 'B');

Line 2559: FROM FEM_DIMENSIONS_TL D, FND_NEW_MESSAGES M, FND_LANGUAGES L

2555: , l_user_id
2556: , SYSDATE
2557: , l_user_id
2558: , SYSDATE
2559: FROM FEM_DIMENSIONS_TL D, FND_NEW_MESSAGES M, FND_LANGUAGES L
2560: WHERE D.DIMENSION_ID = l_dimension_id
2561: AND M.APPLICATION_ID= 274
2562: AND M.MESSAGE_NAME = 'FEM_ADI_MEMBER_INTERFACE'
2563: AND M.LANGUAGE_CODE = D.LANGUAGE