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_ITEM_SHIPTO_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.UNDER_RETURN_TOLERANCE, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

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

Line 74: IF NVL(p_record.UNDER_SHIPMENT_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_SHIPMENT_TOLERANCE') THEN
74: IF NVL(p_record.UNDER_SHIPMENT_TOLERANCE, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
75: RETURN p_record.UNDER_SHIPMENT_TOLERANCE;
76: ELSE
77: RETURN NULL;
78: END IF;

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

89: IS
90: BEGIN
91:
92: IF p_attr_code =('CUSTOMER_ID') THEN
93: IF NVL(p_record.CUSTOMER_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
94: RETURN to_date(p_record.CUSTOMER_ID,'RRRR/MM/DD HH24:MI:SS');
95: ELSE
96: RETURN NULL;
97: END IF;

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

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

Line 105: IF NVL(p_record.INVENTORY_ORG_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 =('INVENTORY_ORG_ID') THEN
105: IF NVL(p_record.INVENTORY_ORG_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
106: RETURN to_date(p_record.INVENTORY_ORG_ID,'RRRR/MM/DD HH24:MI:SS');
107: ELSE
108: RETURN NULL;
109: END IF;

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

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

Line 117: IF NVL(p_record.OVER_SHIPMENT_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_SHIPMENT_TOLERANCE') THEN
117: IF NVL(p_record.OVER_SHIPMENT_TOLERANCE, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
118: RETURN to_date(p_record.OVER_SHIPMENT_TOLERANCE,'RRRR/MM/DD HH24:MI:SS');
119: ELSE
120: RETURN NULL;
121: END IF;

Line 123: IF NVL(p_record.UNDER_RETURN_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 =('UNDER_RETURN_TOLERANCE') THEN
123: IF NVL(p_record.UNDER_RETURN_TOLERANCE, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
124: RETURN to_date(p_record.UNDER_RETURN_TOLERANCE,'RRRR/MM/DD HH24:MI:SS');
125: ELSE
126: RETURN NULL;
127: END IF;

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

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

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

159: AND INTERNAL_ITEM_ID = p_INTERNAL_ITEM_ID
160: ;
161: BEGIN
162:
163: IF (NVL(p_CUSTOMER_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM)
164: OR (NVL(p_INTERNAL_ITEM_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM)
165: THEN
166: RETURN 0 ;
167: ELSIF (NVL(g_cached_record.CUSTOMER_ID,FND_API.G_MISS_NUM) <> p_CUSTOMER_ID)

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

160: ;
161: BEGIN
162:
163: IF (NVL(p_CUSTOMER_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM)
164: OR (NVL(p_INTERNAL_ITEM_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM)
165: THEN
166: RETURN 0 ;
167: ELSIF (NVL(g_cached_record.CUSTOMER_ID,FND_API.G_MISS_NUM) <> p_CUSTOMER_ID)
168: OR (NVL(g_cached_record.INTERNAL_ITEM_ID,FND_API.G_MISS_NUM) <> p_INTERNAL_ITEM_ID)

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

163: IF (NVL(p_CUSTOMER_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM)
164: OR (NVL(p_INTERNAL_ITEM_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM)
165: THEN
166: RETURN 0 ;
167: ELSIF (NVL(g_cached_record.CUSTOMER_ID,FND_API.G_MISS_NUM) <> p_CUSTOMER_ID)
168: OR (NVL(g_cached_record.INTERNAL_ITEM_ID,FND_API.G_MISS_NUM) <> p_INTERNAL_ITEM_ID)
169: THEN
170: Clear_ITEM_SHIPTO_Cache;
171: Open cache;

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

164: OR (NVL(p_INTERNAL_ITEM_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM)
165: THEN
166: RETURN 0 ;
167: ELSIF (NVL(g_cached_record.CUSTOMER_ID,FND_API.G_MISS_NUM) <> p_CUSTOMER_ID)
168: OR (NVL(g_cached_record.INTERNAL_ITEM_ID,FND_API.G_MISS_NUM) <> p_INTERNAL_ITEM_ID)
169: THEN
170: Clear_ITEM_SHIPTO_Cache;
171: Open cache;
172: FETCH cache into g_cached_record;