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.GME_MOBILE_LOVS dependencies on FND_PROFILE

Line 38: g_gtin_cross_ref_type VARCHAR2(25) := fnd_profile.value('INV:GTIN_CROSS_REFERENCE_TYPE');

34: | Rsrv_Lov procedure.
35: +===========================================================================*/
36:
37: --- For GTIN support
38: g_gtin_cross_ref_type VARCHAR2(25) := fnd_profile.value('INV:GTIN_CROSS_REFERENCE_TYPE');
39: g_gtin_code_length NUMBER := 14;
40:
41: g_debug VARCHAR2 (5) := fnd_profile.VALUE ('AFLOG_LEVEL');
42:

Line 41: g_debug VARCHAR2 (5) := fnd_profile.VALUE ('AFLOG_LEVEL');

37: --- For GTIN support
38: g_gtin_cross_ref_type VARCHAR2(25) := fnd_profile.value('INV:GTIN_CROSS_REFERENCE_TYPE');
39: g_gtin_code_length NUMBER := 14;
40:
41: g_debug VARCHAR2 (5) := fnd_profile.VALUE ('AFLOG_LEVEL');
42:
43: /* Bug#5663458 Begin
44: * Created the following procedure. This procedure is to get all reservations
45: * from material line. Used for Use Rsrv field in mobile

Line 56: FND_PROFILE.GET('MWA_DATE_FORMAT_MASK',l_date_format);

52: )
53: IS
54: l_date_format VARCHAR2(100);
55: BEGIN
56: FND_PROFILE.GET('MWA_DATE_FORMAT_MASK',l_date_format);
57:
58: IF l_date_format IS NULL THEN
59: FND_PROFILE.GET('ICX_DATE_FORMAT_MASK',l_date_format);
60: END IF;

Line 59: FND_PROFILE.GET('ICX_DATE_FORMAT_MASK',l_date_format);

55: BEGIN
56: FND_PROFILE.GET('MWA_DATE_FORMAT_MASK',l_date_format);
57:
58: IF l_date_format IS NULL THEN
59: FND_PROFILE.GET('ICX_DATE_FORMAT_MASK',l_date_format);
60: END IF;
61:
62: OPEN x_batch_cursor FOR
63: SELECT NVL(revision,' '),

Line 96: FND_PROFILE.GET('MWA_DATE_FORMAT_MASK',l_date_format);

92: ( x_batch_cursor OUT NOCOPY t_genref
93: )IS
94: l_date_format VARCHAR2(100);
95: BEGIN
96: FND_PROFILE.GET('MWA_DATE_FORMAT_MASK',l_date_format);
97:
98: IF l_date_format IS NULL THEN
99: FND_PROFILE.GET('ICX_DATE_FORMAT_MASK',l_date_format);
100: END IF;

Line 99: FND_PROFILE.GET('ICX_DATE_FORMAT_MASK',l_date_format);

95: BEGIN
96: FND_PROFILE.GET('MWA_DATE_FORMAT_MASK',l_date_format);
97:
98: IF l_date_format IS NULL THEN
99: FND_PROFILE.GET('ICX_DATE_FORMAT_MASK',l_date_format);
100: END IF;
101:
102: OPEN x_batch_cursor FOR
103: SELECT NVL(revision,' '),

Line 2831: FND_PROFILE.GET('MWA_DATE_FORMAT_MASK',l_date_format);

2827: l_date_format VARCHAR2(100);
2828:
2829: BEGIN
2830:
2831: FND_PROFILE.GET('MWA_DATE_FORMAT_MASK',l_date_format);
2832:
2833: IF l_date_format IS NULL THEN
2834: FND_PROFILE.GET('ICX_DATE_FORMAT_MASK',l_date_format);
2835: END IF;

Line 2834: FND_PROFILE.GET('ICX_DATE_FORMAT_MASK',l_date_format);

2830:
2831: FND_PROFILE.GET('MWA_DATE_FORMAT_MASK',l_date_format);
2832:
2833: IF l_date_format IS NULL THEN
2834: FND_PROFILE.GET('ICX_DATE_FORMAT_MASK',l_date_format);
2835: END IF;
2836:
2837: IF p_subinventory_code IS NOT NULL THEN
2838:

Line 2970: FND_PROFILE.GET('MWA_DATE_FORMAT_MASK',l_date_format);

2966: l_date_format VARCHAR2(100);
2967:
2968: BEGIN
2969:
2970: FND_PROFILE.GET('MWA_DATE_FORMAT_MASK',l_date_format);
2971:
2972: IF l_date_format IS NULL THEN
2973: FND_PROFILE.GET('ICX_DATE_FORMAT_MASK',l_date_format);
2974: END IF;

Line 2973: FND_PROFILE.GET('ICX_DATE_FORMAT_MASK',l_date_format);

2969:
2970: FND_PROFILE.GET('MWA_DATE_FORMAT_MASK',l_date_format);
2971:
2972: IF l_date_format IS NULL THEN
2973: FND_PROFILE.GET('ICX_DATE_FORMAT_MASK',l_date_format);
2974: END IF;
2975:
2976: IF p_subinventory_code IS NULL THEN
2977:

Line 3047: FND_PROFILE.GET('MWA_DATE_FORMAT_MASK',l_date_format);

3043: l_date_format VARCHAR2(100);
3044:
3045: BEGIN
3046:
3047: FND_PROFILE.GET('MWA_DATE_FORMAT_MASK',l_date_format);
3048:
3049: IF l_date_format IS NULL THEN
3050: FND_PROFILE.GET('ICX_DATE_FORMAT_MASK',l_date_format);
3051: END IF;

Line 3050: FND_PROFILE.GET('ICX_DATE_FORMAT_MASK',l_date_format);

3046:
3047: FND_PROFILE.GET('MWA_DATE_FORMAT_MASK',l_date_format);
3048:
3049: IF l_date_format IS NULL THEN
3050: FND_PROFILE.GET('ICX_DATE_FORMAT_MASK',l_date_format);
3051: END IF;
3052:
3053: IF p_subinventory_code IS NULL THEN
3054: OPEN x_lot_num_lov FOR

Line 3121: FND_PROFILE.GET('MWA_DATE_FORMAT_MASK',l_date_format);

3117: l_date_format VARCHAR2(100);
3118:
3119: BEGIN
3120:
3121: FND_PROFILE.GET('MWA_DATE_FORMAT_MASK',l_date_format);
3122:
3123: IF l_date_format IS NULL THEN
3124: FND_PROFILE.GET('ICX_DATE_FORMAT_MASK',l_date_format);
3125: END IF;

Line 3124: FND_PROFILE.GET('ICX_DATE_FORMAT_MASK',l_date_format);

3120:
3121: FND_PROFILE.GET('MWA_DATE_FORMAT_MASK',l_date_format);
3122:
3123: IF l_date_format IS NULL THEN
3124: FND_PROFILE.GET('ICX_DATE_FORMAT_MASK',l_date_format);
3125: END IF;
3126:
3127: OPEN x_lot_num_lov FOR
3128: SELECT DISTINCT mln.lot_number

Line 3219: FND_PROFILE.GET('MWA_DATE_FORMAT_MASK',l_date_format);

3215: l_date_format VARCHAR2(100);
3216:
3217: BEGIN
3218:
3219: FND_PROFILE.GET('MWA_DATE_FORMAT_MASK',l_date_format);
3220:
3221: IF l_date_format IS NULL THEN
3222: FND_PROFILE.GET('ICX_DATE_FORMAT_MASK',l_date_format);
3223: END IF;

Line 3222: FND_PROFILE.GET('ICX_DATE_FORMAT_MASK',l_date_format);

3218:
3219: FND_PROFILE.GET('MWA_DATE_FORMAT_MASK',l_date_format);
3220:
3221: IF l_date_format IS NULL THEN
3222: FND_PROFILE.GET('ICX_DATE_FORMAT_MASK',l_date_format);
3223: END IF;
3224:
3225: OPEN x_lot_num_lov FOR
3226: SELECT lot_number,