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.ONT_TOL_CUST_ITEM_DEF_UTIL dependencies on FND_API

Line 38: IF NVL(p_record.CUSTOMER_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

34: IS
35: BEGIN
36:
37: IF p_attr_code =('CUSTOMER_ID') THEN
38: IF NVL(p_record.CUSTOMER_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
39: RETURN p_record.CUSTOMER_ID;
40: ELSE
41: RETURN NULL;
42: END IF;

Line 44: IF NVL(p_record.INTERNAL_ITEM_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

40: ELSE
41: RETURN NULL;
42: END IF;
43: ELSIF p_attr_code =('INTERNAL_ITEM_ID') THEN
44: IF NVL(p_record.INTERNAL_ITEM_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
45: RETURN p_record.INTERNAL_ITEM_ID;
46: ELSE
47: RETURN NULL;
48: END IF;

Line 50: IF NVL(p_record.INVENTORY_ORG_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

46: ELSE
47: RETURN NULL;
48: END IF;
49: ELSIF p_attr_code =('INVENTORY_ORG_ID') THEN
50: IF NVL(p_record.INVENTORY_ORG_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
51: RETURN p_record.INVENTORY_ORG_ID;
52: ELSE
53: RETURN NULL;
54: END IF;

Line 56: IF NVL(p_record.OVER_RETURN_TOLERANCE, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

52: ELSE
53: RETURN NULL;
54: END IF;
55: ELSIF p_attr_code =('OVER_RETURN_TOLERANCE') THEN
56: IF NVL(p_record.OVER_RETURN_TOLERANCE, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
57: RETURN p_record.OVER_RETURN_TOLERANCE;
58: ELSE
59: RETURN NULL;
60: END IF;

Line 62: IF NVL(p_record.OVER_SHIPMENT_TOLERANCE, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

58: ELSE
59: RETURN NULL;
60: END IF;
61: ELSIF p_attr_code =('OVER_SHIPMENT_TOLERANCE') THEN
62: IF NVL(p_record.OVER_SHIPMENT_TOLERANCE, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
63: RETURN p_record.OVER_SHIPMENT_TOLERANCE;
64: ELSE
65: RETURN NULL;
66: END IF;

Line 68: IF NVL(p_record.CUSTOMER_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

64: ELSE
65: RETURN NULL;
66: END IF;
67: ELSIF p_attr_code =('SOLD_TO_ORG_ID') THEN
68: IF NVL(p_record.CUSTOMER_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
69: RETURN p_record.CUSTOMER_ID;
70: ELSE
71: RETURN NULL;
72: END IF;

Line 74: IF NVL(p_record.UNDER_RETURN_TOLERANCE, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

70: ELSE
71: RETURN NULL;
72: END IF;
73: ELSIF p_attr_code =('UNDER_RETURN_TOLERANCE') THEN
74: IF NVL(p_record.UNDER_RETURN_TOLERANCE, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
75: RETURN p_record.UNDER_RETURN_TOLERANCE;
76: ELSE
77: RETURN NULL;
78: END IF;

Line 80: IF NVL(p_record.UNDER_SHIPMENT_TOLERANCE, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

76: ELSE
77: RETURN NULL;
78: END IF;
79: ELSIF p_attr_code =('UNDER_SHIPMENT_TOLERANCE') THEN
80: IF NVL(p_record.UNDER_SHIPMENT_TOLERANCE, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
81: RETURN p_record.UNDER_SHIPMENT_TOLERANCE;
82: ELSE
83: RETURN NULL;
84: END IF;

Line 99: IF NVL(p_record.CUSTOMER_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

95: IS
96: BEGIN
97:
98: IF p_attr_code =('CUSTOMER_ID') THEN
99: IF NVL(p_record.CUSTOMER_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
100: RETURN to_date(p_record.CUSTOMER_ID,'RRRR/MM/DD HH24:MI:SS');
101: ELSE
102: RETURN NULL;
103: END IF;

Line 105: IF NVL(p_record.INTERNAL_ITEM_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

101: ELSE
102: RETURN NULL;
103: END IF;
104: ELSIF p_attr_code =('INTERNAL_ITEM_ID') THEN
105: IF NVL(p_record.INTERNAL_ITEM_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
106: RETURN to_date(p_record.INTERNAL_ITEM_ID,'RRRR/MM/DD HH24:MI:SS');
107: ELSE
108: RETURN NULL;
109: END IF;

Line 111: IF NVL(p_record.INVENTORY_ORG_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

107: ELSE
108: RETURN NULL;
109: END IF;
110: ELSIF p_attr_code =('INVENTORY_ORG_ID') THEN
111: IF NVL(p_record.INVENTORY_ORG_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
112: RETURN to_date(p_record.INVENTORY_ORG_ID,'RRRR/MM/DD HH24:MI:SS');
113: ELSE
114: RETURN NULL;
115: END IF;

Line 117: IF NVL(p_record.OVER_RETURN_TOLERANCE, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

113: ELSE
114: RETURN NULL;
115: END IF;
116: ELSIF p_attr_code =('OVER_RETURN_TOLERANCE') THEN
117: IF NVL(p_record.OVER_RETURN_TOLERANCE, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
118: RETURN to_date(p_record.OVER_RETURN_TOLERANCE,'RRRR/MM/DD HH24:MI:SS');
119: ELSE
120: RETURN NULL;
121: END IF;

Line 123: IF NVL(p_record.OVER_SHIPMENT_TOLERANCE, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

119: ELSE
120: RETURN NULL;
121: END IF;
122: ELSIF p_attr_code =('OVER_SHIPMENT_TOLERANCE') THEN
123: IF NVL(p_record.OVER_SHIPMENT_TOLERANCE, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
124: RETURN to_date(p_record.OVER_SHIPMENT_TOLERANCE,'RRRR/MM/DD HH24:MI:SS');
125: ELSE
126: RETURN NULL;
127: END IF;

Line 129: IF NVL(p_record.CUSTOMER_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

125: ELSE
126: RETURN NULL;
127: END IF;
128: ELSIF p_attr_code =('SOLD_TO_ORG_ID') THEN
129: IF NVL(p_record.CUSTOMER_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
130: RETURN to_date(p_record.CUSTOMER_ID,'RRRR/MM/DD HH24:MI:SS');
131: ELSE
132: RETURN NULL;
133: END IF;

Line 135: IF NVL(p_record.UNDER_RETURN_TOLERANCE, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

131: ELSE
132: RETURN NULL;
133: END IF;
134: ELSIF p_attr_code =('UNDER_RETURN_TOLERANCE') THEN
135: IF NVL(p_record.UNDER_RETURN_TOLERANCE, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
136: RETURN to_date(p_record.UNDER_RETURN_TOLERANCE,'RRRR/MM/DD HH24:MI:SS');
137: ELSE
138: RETURN NULL;
139: END IF;

Line 141: IF NVL(p_record.UNDER_SHIPMENT_TOLERANCE, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

137: ELSE
138: RETURN NULL;
139: END IF;
140: ELSIF p_attr_code =('UNDER_SHIPMENT_TOLERANCE') THEN
141: IF NVL(p_record.UNDER_SHIPMENT_TOLERANCE, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
142: RETURN to_date(p_record.UNDER_SHIPMENT_TOLERANCE,'RRRR/MM/DD HH24:MI:SS');
143: ELSE
144: RETURN NULL;
145: END IF;

Line 175: IF (NVL(p_CUSTOMER_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM)

171: AND INTERNAL_ITEM_ID = p_INTERNAL_ITEM_ID
172: ;
173: BEGIN
174:
175: IF (NVL(p_CUSTOMER_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM)
176: OR (NVL(p_INTERNAL_ITEM_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM)
177: THEN
178: RETURN 0 ;
179: ELSIF (NVL(g_cached_record.CUSTOMER_ID,FND_API.G_MISS_NUM) <> p_CUSTOMER_ID)

Line 176: OR (NVL(p_INTERNAL_ITEM_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM)

172: ;
173: BEGIN
174:
175: IF (NVL(p_CUSTOMER_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM)
176: OR (NVL(p_INTERNAL_ITEM_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM)
177: THEN
178: RETURN 0 ;
179: ELSIF (NVL(g_cached_record.CUSTOMER_ID,FND_API.G_MISS_NUM) <> p_CUSTOMER_ID)
180: OR (NVL(g_cached_record.INTERNAL_ITEM_ID,FND_API.G_MISS_NUM) <> p_INTERNAL_ITEM_ID)

Line 179: ELSIF (NVL(g_cached_record.CUSTOMER_ID,FND_API.G_MISS_NUM) <> p_CUSTOMER_ID)

175: IF (NVL(p_CUSTOMER_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM)
176: OR (NVL(p_INTERNAL_ITEM_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM)
177: THEN
178: RETURN 0 ;
179: ELSIF (NVL(g_cached_record.CUSTOMER_ID,FND_API.G_MISS_NUM) <> p_CUSTOMER_ID)
180: OR (NVL(g_cached_record.INTERNAL_ITEM_ID,FND_API.G_MISS_NUM) <> p_INTERNAL_ITEM_ID)
181: THEN
182: Clear_TOL_CUST_ITEM_Cache;
183: Open cache;

Line 180: OR (NVL(g_cached_record.INTERNAL_ITEM_ID,FND_API.G_MISS_NUM) <> p_INTERNAL_ITEM_ID)

176: OR (NVL(p_INTERNAL_ITEM_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM)
177: THEN
178: RETURN 0 ;
179: ELSIF (NVL(g_cached_record.CUSTOMER_ID,FND_API.G_MISS_NUM) <> p_CUSTOMER_ID)
180: OR (NVL(g_cached_record.INTERNAL_ITEM_ID,FND_API.G_MISS_NUM) <> p_INTERNAL_ITEM_ID)
181: THEN
182: Clear_TOL_CUST_ITEM_Cache;
183: Open cache;
184: FETCH cache into g_cached_record;