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 49: g_gtin_cross_ref_type VARCHAR2(25) := fnd_profile.value('INV:GTIN_CROSS_REFERENCE_TYPE');

45: | not compile on versions below 11g |
46: +===========================================================================*/
47:
48: --- For GTIN support
49: g_gtin_cross_ref_type VARCHAR2(25) := fnd_profile.value('INV:GTIN_CROSS_REFERENCE_TYPE');
50: g_gtin_code_length NUMBER := 14;
51:
52: g_debug VARCHAR2 (5) := fnd_profile.VALUE ('AFLOG_LEVEL');
53:

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

48: --- For GTIN support
49: g_gtin_cross_ref_type VARCHAR2(25) := fnd_profile.value('INV:GTIN_CROSS_REFERENCE_TYPE');
50: g_gtin_code_length NUMBER := 14;
51:
52: g_debug VARCHAR2 (5) := fnd_profile.VALUE ('AFLOG_LEVEL');
53:
54: /* Bug#5663458 Begin
55: * Created the following procedure. This procedure is to get all reservations
56: * from material line. Used for Use Rsrv field in mobile

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

63: )
64: IS
65: l_date_format VARCHAR2(100);
66: BEGIN
67: FND_PROFILE.GET('MWA_DATE_FORMAT_MASK',l_date_format);
68:
69: IF l_date_format IS NULL THEN
70: FND_PROFILE.GET('ICX_DATE_FORMAT_MASK',l_date_format);
71: END IF;

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

66: BEGIN
67: FND_PROFILE.GET('MWA_DATE_FORMAT_MASK',l_date_format);
68:
69: IF l_date_format IS NULL THEN
70: FND_PROFILE.GET('ICX_DATE_FORMAT_MASK',l_date_format);
71: END IF;
72:
73: --
74: -- bug 9483781

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

112: ( x_batch_cursor OUT NOCOPY t_genref
113: )IS
114: l_date_format VARCHAR2(100);
115: BEGIN
116: FND_PROFILE.GET('MWA_DATE_FORMAT_MASK',l_date_format);
117:
118: IF l_date_format IS NULL THEN
119: FND_PROFILE.GET('ICX_DATE_FORMAT_MASK',l_date_format);
120: END IF;

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

115: BEGIN
116: FND_PROFILE.GET('MWA_DATE_FORMAT_MASK',l_date_format);
117:
118: IF l_date_format IS NULL THEN
119: FND_PROFILE.GET('ICX_DATE_FORMAT_MASK',l_date_format);
120: END IF;
121:
122: --
123: -- bug 9483781

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

2854: l_date_format VARCHAR2(100);
2855:
2856: BEGIN
2857:
2858: FND_PROFILE.GET('MWA_DATE_FORMAT_MASK',l_date_format);
2859:
2860: IF l_date_format IS NULL THEN
2861: FND_PROFILE.GET('ICX_DATE_FORMAT_MASK',l_date_format);
2862: END IF;

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

2857:
2858: FND_PROFILE.GET('MWA_DATE_FORMAT_MASK',l_date_format);
2859:
2860: IF l_date_format IS NULL THEN
2861: FND_PROFILE.GET('ICX_DATE_FORMAT_MASK',l_date_format);
2862: END IF;
2863:
2864: IF p_subinventory_code IS NOT NULL THEN
2865:

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

2993: l_date_format VARCHAR2(100);
2994:
2995: BEGIN
2996:
2997: FND_PROFILE.GET('MWA_DATE_FORMAT_MASK',l_date_format);
2998:
2999: IF l_date_format IS NULL THEN
3000: FND_PROFILE.GET('ICX_DATE_FORMAT_MASK',l_date_format);
3001: END IF;

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

2996:
2997: FND_PROFILE.GET('MWA_DATE_FORMAT_MASK',l_date_format);
2998:
2999: IF l_date_format IS NULL THEN
3000: FND_PROFILE.GET('ICX_DATE_FORMAT_MASK',l_date_format);
3001: END IF;
3002:
3003: IF p_subinventory_code IS NULL THEN
3004:

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

3074: l_date_format VARCHAR2(100);
3075:
3076: BEGIN
3077:
3078: FND_PROFILE.GET('MWA_DATE_FORMAT_MASK',l_date_format);
3079:
3080: IF l_date_format IS NULL THEN
3081: FND_PROFILE.GET('ICX_DATE_FORMAT_MASK',l_date_format);
3082: END IF;

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

3077:
3078: FND_PROFILE.GET('MWA_DATE_FORMAT_MASK',l_date_format);
3079:
3080: IF l_date_format IS NULL THEN
3081: FND_PROFILE.GET('ICX_DATE_FORMAT_MASK',l_date_format);
3082: END IF;
3083:
3084: IF p_subinventory_code IS NULL THEN
3085: OPEN x_lot_num_lov FOR

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

3201: l_date_format VARCHAR2(100);
3202:
3203: BEGIN
3204:
3205: FND_PROFILE.GET('MWA_DATE_FORMAT_MASK',l_date_format);
3206:
3207: IF l_date_format IS NULL THEN
3208: FND_PROFILE.GET('ICX_DATE_FORMAT_MASK',l_date_format);
3209: END IF;

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

3204:
3205: FND_PROFILE.GET('MWA_DATE_FORMAT_MASK',l_date_format);
3206:
3207: IF l_date_format IS NULL THEN
3208: FND_PROFILE.GET('ICX_DATE_FORMAT_MASK',l_date_format);
3209: END IF;
3210:
3211: OPEN x_lot_num_lov FOR
3212: SELECT DISTINCT mln.lot_number

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

3299: l_date_format VARCHAR2(100);
3300:
3301: BEGIN
3302:
3303: FND_PROFILE.GET('MWA_DATE_FORMAT_MASK',l_date_format);
3304:
3305: IF l_date_format IS NULL THEN
3306: FND_PROFILE.GET('ICX_DATE_FORMAT_MASK',l_date_format);
3307: END IF;

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

3302:
3303: FND_PROFILE.GET('MWA_DATE_FORMAT_MASK',l_date_format);
3304:
3305: IF l_date_format IS NULL THEN
3306: FND_PROFILE.GET('ICX_DATE_FORMAT_MASK',l_date_format);
3307: END IF;
3308:
3309: OPEN x_lot_num_lov FOR
3310: SELECT lot_number,