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

Line 119: if px_status_rec.organization_id = fnd_api.g_miss_num THEN

115: PROCEDURE Initialize_status_rec(px_status_rec
116: IN OUT NOCOPY INV_MATERIAL_STATUS_PUB.mtl_status_update_rec_type )
117: IS
118: BEGIN
119: if px_status_rec.organization_id = fnd_api.g_miss_num THEN
120: px_status_rec.organization_id := NULL;
121: end if;
122: if px_status_rec.inventory_item_id = fnd_api.g_miss_num THEN
123: px_status_rec.inventory_item_id := NULL;

Line 122: if px_status_rec.inventory_item_id = fnd_api.g_miss_num THEN

118: BEGIN
119: if px_status_rec.organization_id = fnd_api.g_miss_num THEN
120: px_status_rec.organization_id := NULL;
121: end if;
122: if px_status_rec.inventory_item_id = fnd_api.g_miss_num THEN
123: px_status_rec.inventory_item_id := NULL;
124: end if;
125: if px_status_rec.lot_number = fnd_api.g_miss_char then
126: px_status_rec.lot_number := NULL;

Line 125: if px_status_rec.lot_number = fnd_api.g_miss_char then

121: end if;
122: if px_status_rec.inventory_item_id = fnd_api.g_miss_num THEN
123: px_status_rec.inventory_item_id := NULL;
124: end if;
125: if px_status_rec.lot_number = fnd_api.g_miss_char then
126: px_status_rec.lot_number := NULL;
127: end if;
128: if px_status_rec.serial_number = fnd_api.g_miss_char then
129: px_status_rec.serial_number := NULL;

Line 128: if px_status_rec.serial_number = fnd_api.g_miss_char then

124: end if;
125: if px_status_rec.lot_number = fnd_api.g_miss_char then
126: px_status_rec.lot_number := NULL;
127: end if;
128: if px_status_rec.serial_number = fnd_api.g_miss_char then
129: px_status_rec.serial_number := NULL;
130: end if;
131: if px_status_rec.to_serial_number = fnd_api.g_miss_char then
132: px_status_rec.to_serial_number := NULL;

Line 131: if px_status_rec.to_serial_number = fnd_api.g_miss_char then

127: end if;
128: if px_status_rec.serial_number = fnd_api.g_miss_char then
129: px_status_rec.serial_number := NULL;
130: end if;
131: if px_status_rec.to_serial_number = fnd_api.g_miss_char then
132: px_status_rec.to_serial_number := NULL;
133: end if;
134: if px_status_rec.update_method = fnd_api.g_miss_num then
135: px_status_rec.update_method := NULL;

Line 134: if px_status_rec.update_method = fnd_api.g_miss_num then

130: end if;
131: if px_status_rec.to_serial_number = fnd_api.g_miss_char then
132: px_status_rec.to_serial_number := NULL;
133: end if;
134: if px_status_rec.update_method = fnd_api.g_miss_num then
135: px_status_rec.update_method := NULL;
136: end if;
137: if px_status_rec.status_id = fnd_api.g_miss_num then
138: px_status_rec.status_id := NULL;

Line 137: if px_status_rec.status_id = fnd_api.g_miss_num then

133: end if;
134: if px_status_rec.update_method = fnd_api.g_miss_num then
135: px_status_rec.update_method := NULL;
136: end if;
137: if px_status_rec.status_id = fnd_api.g_miss_num then
138: px_status_rec.status_id := NULL;
139: end if;
140: if px_status_rec.zone_code = fnd_api.g_miss_char then
141: px_status_rec.zone_code := NULL;

Line 140: if px_status_rec.zone_code = fnd_api.g_miss_char then

136: end if;
137: if px_status_rec.status_id = fnd_api.g_miss_num then
138: px_status_rec.status_id := NULL;
139: end if;
140: if px_status_rec.zone_code = fnd_api.g_miss_char then
141: px_status_rec.zone_code := NULL;
142: end if;
143: if px_status_rec.locator_id = fnd_api.g_miss_num then
144: px_status_rec.locator_id := NULL;

Line 143: if px_status_rec.locator_id = fnd_api.g_miss_num then

139: end if;
140: if px_status_rec.zone_code = fnd_api.g_miss_char then
141: px_status_rec.zone_code := NULL;
142: end if;
143: if px_status_rec.locator_id = fnd_api.g_miss_num then
144: px_status_rec.locator_id := NULL;
145: end if;
146: if px_status_rec.created_by = fnd_api.g_miss_num then
147: px_status_rec.created_by := FND_GLOBAL.USER_ID;

Line 146: if px_status_rec.created_by = fnd_api.g_miss_num then

142: end if;
143: if px_status_rec.locator_id = fnd_api.g_miss_num then
144: px_status_rec.locator_id := NULL;
145: end if;
146: if px_status_rec.created_by = fnd_api.g_miss_num then
147: px_status_rec.created_by := FND_GLOBAL.USER_ID;
148: end if;
149: if px_status_rec.last_updated_by = fnd_api.g_miss_num then
150: px_status_rec.last_updated_by := FND_GLOBAL.USER_ID;

Line 149: if px_status_rec.last_updated_by = fnd_api.g_miss_num then

145: end if;
146: if px_status_rec.created_by = fnd_api.g_miss_num then
147: px_status_rec.created_by := FND_GLOBAL.USER_ID;
148: end if;
149: if px_status_rec.last_updated_by = fnd_api.g_miss_num then
150: px_status_rec.last_updated_by := FND_GLOBAL.USER_ID;
151: end if;
152: -- always default the creation date and update date to sysdate
153: -- since we only need to insert this record and never need to

Line 157: if px_status_rec.last_update_login = fnd_api.g_miss_num then

153: -- since we only need to insert this record and never need to
154: -- change it, bug 1912638
155: px_status_rec.creation_date := SYSDATE;
156: px_status_rec.last_update_date := SYSDATE;
157: if px_status_rec.last_update_login = fnd_api.g_miss_num then
158: px_status_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
159: end if;
160:
161: if px_status_rec.program_application_id = fnd_api.g_miss_num then

Line 161: if px_status_rec.program_application_id = fnd_api.g_miss_num then

157: if px_status_rec.last_update_login = fnd_api.g_miss_num then
158: px_status_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
159: end if;
160:
161: if px_status_rec.program_application_id = fnd_api.g_miss_num then
162: px_status_rec.program_application_id := NULL;
163: end if;
164:
165: if px_status_rec.program_id = fnd_api.g_miss_num then

Line 165: if px_status_rec.program_id = fnd_api.g_miss_num then

161: if px_status_rec.program_application_id = fnd_api.g_miss_num then
162: px_status_rec.program_application_id := NULL;
163: end if;
164:
165: if px_status_rec.program_id = fnd_api.g_miss_num then
166: px_status_rec.program_id := NULL;
167: end if;
168:
169: if px_status_rec.attribute_category = fnd_api.g_miss_char then

Line 169: if px_status_rec.attribute_category = fnd_api.g_miss_char then

165: if px_status_rec.program_id = fnd_api.g_miss_num then
166: px_status_rec.program_id := NULL;
167: end if;
168:
169: if px_status_rec.attribute_category = fnd_api.g_miss_char then
170: px_status_rec.attribute_category := NULL;
171: end if;
172: if px_status_rec.attribute1 = fnd_api.g_miss_char then
173: px_status_rec.attribute1 := NULL;

Line 172: if px_status_rec.attribute1 = fnd_api.g_miss_char then

168:
169: if px_status_rec.attribute_category = fnd_api.g_miss_char then
170: px_status_rec.attribute_category := NULL;
171: end if;
172: if px_status_rec.attribute1 = fnd_api.g_miss_char then
173: px_status_rec.attribute1 := NULL;
174: end if;
175: if px_status_rec.attribute2 = fnd_api.g_miss_char then
176: px_status_rec.attribute2 := NULL;

Line 175: if px_status_rec.attribute2 = fnd_api.g_miss_char then

171: end if;
172: if px_status_rec.attribute1 = fnd_api.g_miss_char then
173: px_status_rec.attribute1 := NULL;
174: end if;
175: if px_status_rec.attribute2 = fnd_api.g_miss_char then
176: px_status_rec.attribute2 := NULL;
177: end if;
178: if px_status_rec.attribute3 = fnd_api.g_miss_char then
179: px_status_rec.attribute3 := NULL;

Line 178: if px_status_rec.attribute3 = fnd_api.g_miss_char then

174: end if;
175: if px_status_rec.attribute2 = fnd_api.g_miss_char then
176: px_status_rec.attribute2 := NULL;
177: end if;
178: if px_status_rec.attribute3 = fnd_api.g_miss_char then
179: px_status_rec.attribute3 := NULL;
180: end if;
181: if px_status_rec.attribute4 = fnd_api.g_miss_char then
182: px_status_rec.attribute4 := NULL;

Line 181: if px_status_rec.attribute4 = fnd_api.g_miss_char then

177: end if;
178: if px_status_rec.attribute3 = fnd_api.g_miss_char then
179: px_status_rec.attribute3 := NULL;
180: end if;
181: if px_status_rec.attribute4 = fnd_api.g_miss_char then
182: px_status_rec.attribute4 := NULL;
183: end if;
184: if px_status_rec.attribute5 = fnd_api.g_miss_char then
185: px_status_rec.attribute5 := NULL;

Line 184: if px_status_rec.attribute5 = fnd_api.g_miss_char then

180: end if;
181: if px_status_rec.attribute4 = fnd_api.g_miss_char then
182: px_status_rec.attribute4 := NULL;
183: end if;
184: if px_status_rec.attribute5 = fnd_api.g_miss_char then
185: px_status_rec.attribute5 := NULL;
186: end if;
187: if px_status_rec.attribute6 = fnd_api.g_miss_char then
188: px_status_rec.attribute6 := NULL;

Line 187: if px_status_rec.attribute6 = fnd_api.g_miss_char then

183: end if;
184: if px_status_rec.attribute5 = fnd_api.g_miss_char then
185: px_status_rec.attribute5 := NULL;
186: end if;
187: if px_status_rec.attribute6 = fnd_api.g_miss_char then
188: px_status_rec.attribute6 := NULL;
189: end if;
190: if px_status_rec.attribute7 = fnd_api.g_miss_char then
191: px_status_rec.attribute7 := NULL;

Line 190: if px_status_rec.attribute7 = fnd_api.g_miss_char then

186: end if;
187: if px_status_rec.attribute6 = fnd_api.g_miss_char then
188: px_status_rec.attribute6 := NULL;
189: end if;
190: if px_status_rec.attribute7 = fnd_api.g_miss_char then
191: px_status_rec.attribute7 := NULL;
192: end if;
193: if px_status_rec.attribute8 = fnd_api.g_miss_char then
194: px_status_rec.attribute8 := NULL;

Line 193: if px_status_rec.attribute8 = fnd_api.g_miss_char then

189: end if;
190: if px_status_rec.attribute7 = fnd_api.g_miss_char then
191: px_status_rec.attribute7 := NULL;
192: end if;
193: if px_status_rec.attribute8 = fnd_api.g_miss_char then
194: px_status_rec.attribute8 := NULL;
195: end if;
196: if px_status_rec.attribute9 = fnd_api.g_miss_char then
197: px_status_rec.attribute9 := NULL;

Line 196: if px_status_rec.attribute9 = fnd_api.g_miss_char then

192: end if;
193: if px_status_rec.attribute8 = fnd_api.g_miss_char then
194: px_status_rec.attribute8 := NULL;
195: end if;
196: if px_status_rec.attribute9 = fnd_api.g_miss_char then
197: px_status_rec.attribute9 := NULL;
198: end if;
199: if px_status_rec.attribute10 = fnd_api.g_miss_char then
200: px_status_rec.attribute10 := NULL;

Line 199: if px_status_rec.attribute10 = fnd_api.g_miss_char then

195: end if;
196: if px_status_rec.attribute9 = fnd_api.g_miss_char then
197: px_status_rec.attribute9 := NULL;
198: end if;
199: if px_status_rec.attribute10 = fnd_api.g_miss_char then
200: px_status_rec.attribute10 := NULL;
201: end if;
202: if px_status_rec.attribute11 = fnd_api.g_miss_char then
203: px_status_rec.attribute11 := NULL;

Line 202: if px_status_rec.attribute11 = fnd_api.g_miss_char then

198: end if;
199: if px_status_rec.attribute10 = fnd_api.g_miss_char then
200: px_status_rec.attribute10 := NULL;
201: end if;
202: if px_status_rec.attribute11 = fnd_api.g_miss_char then
203: px_status_rec.attribute11 := NULL;
204: end if;
205: if px_status_rec.attribute12 = fnd_api.g_miss_char then
206: px_status_rec.attribute12 := NULL;

Line 205: if px_status_rec.attribute12 = fnd_api.g_miss_char then

201: end if;
202: if px_status_rec.attribute11 = fnd_api.g_miss_char then
203: px_status_rec.attribute11 := NULL;
204: end if;
205: if px_status_rec.attribute12 = fnd_api.g_miss_char then
206: px_status_rec.attribute12 := NULL;
207: end if;
208: if px_status_rec.attribute13 = fnd_api.g_miss_char then
209: px_status_rec.attribute13 := NULL;

Line 208: if px_status_rec.attribute13 = fnd_api.g_miss_char then

204: end if;
205: if px_status_rec.attribute12 = fnd_api.g_miss_char then
206: px_status_rec.attribute12 := NULL;
207: end if;
208: if px_status_rec.attribute13 = fnd_api.g_miss_char then
209: px_status_rec.attribute13 := NULL;
210: end if;
211: if px_status_rec.attribute14 = fnd_api.g_miss_char then
212: px_status_rec.attribute14 := NULL;

Line 211: if px_status_rec.attribute14 = fnd_api.g_miss_char then

207: end if;
208: if px_status_rec.attribute13 = fnd_api.g_miss_char then
209: px_status_rec.attribute13 := NULL;
210: end if;
211: if px_status_rec.attribute14 = fnd_api.g_miss_char then
212: px_status_rec.attribute14 := NULL;
213: end if;
214: if px_status_rec.attribute15 = fnd_api.g_miss_char then
215: px_status_rec.attribute15 := NULL;

Line 214: if px_status_rec.attribute15 = fnd_api.g_miss_char then

210: end if;
211: if px_status_rec.attribute14 = fnd_api.g_miss_char then
212: px_status_rec.attribute14 := NULL;
213: end if;
214: if px_status_rec.attribute15 = fnd_api.g_miss_char then
215: px_status_rec.attribute15 := NULL;
216: end if;
217: if px_status_rec.update_reason_id = fnd_api.g_miss_num then
218: px_status_rec.update_reason_id := NULL;

Line 217: if px_status_rec.update_reason_id = fnd_api.g_miss_num then

213: end if;
214: if px_status_rec.attribute15 = fnd_api.g_miss_char then
215: px_status_rec.attribute15 := NULL;
216: end if;
217: if px_status_rec.update_reason_id = fnd_api.g_miss_num then
218: px_status_rec.update_reason_id := NULL;
219: end if;
220:
221: if px_status_rec.initial_status_flag = fnd_api.g_miss_char then

Line 221: if px_status_rec.initial_status_flag = fnd_api.g_miss_char then

217: if px_status_rec.update_reason_id = fnd_api.g_miss_num then
218: px_status_rec.update_reason_id := NULL;
219: end if;
220:
221: if px_status_rec.initial_status_flag = fnd_api.g_miss_char then
222: px_status_rec.initial_status_flag := NULL;
223: end if;
224: if px_status_rec.from_mobile_apps_flag = fnd_api.g_miss_char then
225: px_status_rec.from_mobile_apps_flag := NULL;

Line 224: if px_status_rec.from_mobile_apps_flag = fnd_api.g_miss_char then

220:
221: if px_status_rec.initial_status_flag = fnd_api.g_miss_char then
222: px_status_rec.initial_status_flag := NULL;
223: end if;
224: if px_status_rec.from_mobile_apps_flag = fnd_api.g_miss_char then
225: px_status_rec.from_mobile_apps_flag := NULL;
226: end if;
227: --BUG 7306729 Quantities should be changed to NULL when the value is g_miss_num
228: if px_status_rec.PRIMARY_ONHAND = fnd_api.g_miss_num then

Line 228: if px_status_rec.PRIMARY_ONHAND = fnd_api.g_miss_num then

224: if px_status_rec.from_mobile_apps_flag = fnd_api.g_miss_char then
225: px_status_rec.from_mobile_apps_flag := NULL;
226: end if;
227: --BUG 7306729 Quantities should be changed to NULL when the value is g_miss_num
228: if px_status_rec.PRIMARY_ONHAND = fnd_api.g_miss_num then
229: px_status_rec.PRIMARY_ONHAND := NULL;
230: end if;
231:
232: if px_status_rec.SECONDARY_ONHAND = fnd_api.g_miss_num then

Line 232: if px_status_rec.SECONDARY_ONHAND = fnd_api.g_miss_num then

228: if px_status_rec.PRIMARY_ONHAND = fnd_api.g_miss_num then
229: px_status_rec.PRIMARY_ONHAND := NULL;
230: end if;
231:
232: if px_status_rec.SECONDARY_ONHAND = fnd_api.g_miss_num then
233: px_status_rec.SECONDARY_ONHAND := NULL;
234: end if;
235: --End of 7306729
236: -- Bug# 1695432 added initial_status_flag,from_mobile_apps_flag columns

Line 238: if px_status_rec.GROUP_ID = fnd_api.g_miss_num then

234: end if;
235: --End of 7306729
236: -- Bug# 1695432 added initial_status_flag,from_mobile_apps_flag columns
237:
238: if px_status_rec.GROUP_ID = fnd_api.g_miss_num then
239: px_status_rec.GROUP_ID := NULL; --Bug#11826279
240: end if;
241:
242: if px_status_rec.lpn_id = fnd_api.g_miss_num then

Line 242: if px_status_rec.lpn_id = fnd_api.g_miss_num then

238: if px_status_rec.GROUP_ID = fnd_api.g_miss_num then
239: px_status_rec.GROUP_ID := NULL; --Bug#11826279
240: end if;
241:
242: if px_status_rec.lpn_id = fnd_api.g_miss_num then
243: px_status_rec.lpn_id := NULL; --Bug#11826279
244: end if;
245:
246: if px_status_rec.pending_status = fnd_api.g_miss_num then

Line 246: if px_status_rec.pending_status = fnd_api.g_miss_num then

242: if px_status_rec.lpn_id = fnd_api.g_miss_num then
243: px_status_rec.lpn_id := NULL; --Bug#11826279
244: end if;
245:
246: if px_status_rec.pending_status = fnd_api.g_miss_num then
247: px_status_rec.pending_status := 0; --ERES Deferred
248: end if;
249:
250:

Line 546: IF l_return_status <> fnd_api.g_ret_sts_success THEN

542: p_lot_number => l_status_rec.lot_number,
543: p_fm_serial_number => l_status_rec.serial_number,
544: p_to_serial_number => l_to_serial_number);
545:
546: IF l_return_status <> fnd_api.g_ret_sts_success THEN
547: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CRT_PRINT_LAB_FAIL');
548: FND_MSG_PUB.ADD;
549: END IF;
550:

Line 554: WHEN FND_API.G_EXC_ERROR THEN

550:
551:
552: EXCEPTION
553:
554: WHEN FND_API.G_EXC_ERROR THEN
555:
556: Raise FND_API.G_EXC_ERROR;
557:
558: WHEN OTHERS THEN

Line 556: Raise FND_API.G_EXC_ERROR;

552: EXCEPTION
553:
554: WHEN FND_API.G_EXC_ERROR THEN
555:
556: Raise FND_API.G_EXC_ERROR;
557:
558: WHEN OTHERS THEN
559:
560: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 569: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

565: );
566: END IF;
567:
568:
569: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
570:
571: END Insert_status_history;
572:
573: /* bug 11806801 */