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

Line 186: cur.item_catalog_group_id <> FND_API.G_MISS_NUM) THEN

182:
183: /*Added for bug 8848620 fp for 7581972 and 8808831 */
184:
185: IF (cur.item_catalog_group_id IS NOT NULL and
186: cur.item_catalog_group_id <> FND_API.G_MISS_NUM) THEN
187: l_icc_id := cur.item_catalog_group_id;/*Change for Bug 13786862*/
188: SELECT COUNT(1)
189: INTO L_CAT_TEMPL_COUNT
190: FROM EGO_CAT_GRP_TEMPLATES

Line 198: cur.item_catalog_group_id = FND_API.G_MISS_NUM) AND

194: CONNECT BY PRIOR PARENT_CATALOG_GROUP_ID = ITEM_CATALOG_GROUP_ID);
195:
196:
197: ELSIF (cur.item_catalog_group_id IS NULL or
198: cur.item_catalog_group_id = FND_API.G_MISS_NUM) AND
199: cur.transaction_type = 'UPDATE' THEN
200:
201: FOR rec_get_icc_id IN get_icc_id(cur.inventory_item_id, cur.organization_id)
202: LOOP

Line 220: IF (cur.template_id IS NULL or cur.template_id = FND_API.G_MISS_NUM) AND

216: END IF;
217:
218: /*End of bug 8848620 */
219:
220: IF (cur.template_id IS NULL or cur.template_id = FND_API.G_MISS_NUM) AND
221: (cur.template_name IS NOT NULL and
222: cur.template_name <> FND_API.G_MISS_CHAR) AND l_icc_id IS NULL THEN
223:
224: OPEN check_template_name(cur.template_name);

Line 222: cur.template_name <> FND_API.G_MISS_CHAR) AND l_icc_id IS NULL THEN

218: /*End of bug 8848620 */
219:
220: IF (cur.template_id IS NULL or cur.template_id = FND_API.G_MISS_NUM) AND
221: (cur.template_name IS NOT NULL and
222: cur.template_name <> FND_API.G_MISS_CHAR) AND l_icc_id IS NULL THEN
223:
224: OPEN check_template_name(cur.template_name);
225: FETCH check_template_name INTO l_template_id,context_orgid;
226: CLOSE check_template_name;

Line 242: cur.template_id <> FND_API.G_MISS_NUM) AND cur.template_id > 0 AND

238: END IF;
239:
240: --ELSIF cur.template_id IS NOT NULL AND cur.template_id > 0 AND l_cat_templ_count = 0 /*Change for Bug 13786862*/
241: ELSIF (cur.template_id IS NOT NULL and
242: cur.template_id <> FND_API.G_MISS_NUM) AND cur.template_id > 0 AND
243: l_icc_id IS NULL /*Change for Bug 13786862*/
244: AND cur.template_id <> FND_API.G_MISS_NUM THEN /*bug8942177*/
245:
246: OPEN check_template_id(cur.template_id);

Line 244: AND cur.template_id <> FND_API.G_MISS_NUM THEN /bug8942177/

240: --ELSIF cur.template_id IS NOT NULL AND cur.template_id > 0 AND l_cat_templ_count = 0 /*Change for Bug 13786862*/
241: ELSIF (cur.template_id IS NOT NULL and
242: cur.template_id <> FND_API.G_MISS_NUM) AND cur.template_id > 0 AND
243: l_icc_id IS NULL /*Change for Bug 13786862*/
244: AND cur.template_id <> FND_API.G_MISS_NUM THEN /*bug8942177*/
245:
246: OPEN check_template_id(cur.template_id);
247: FETCH check_template_id INTO l_template_id,context_orgid;
248: CLOSE check_template_id;

Line 263: cur.template_id <> FND_API.G_MISS_NUM) OR

259: l_message_name := 'INV_ORG_TEMPLATE_ERROR';
260: END IF;
261: /*Change for Bug 13786862*/
262: ELSIF ((cur.template_id IS NOT NULL and
263: cur.template_id <> FND_API.G_MISS_NUM) OR
264: (cur.template_name IS NOT NULL and
265: cur.template_name <> FND_API.G_MISS_CHAR)) AND
266: l_icc_id IS NOT NULL AND l_cat_templ_count = 0 THEN
267: /*When ICC has no defined Templates but a tempate id/name presents*/

Line 265: cur.template_name <> FND_API.G_MISS_CHAR)) AND

261: /*Change for Bug 13786862*/
262: ELSIF ((cur.template_id IS NOT NULL and
263: cur.template_id <> FND_API.G_MISS_NUM) OR
264: (cur.template_name IS NOT NULL and
265: cur.template_name <> FND_API.G_MISS_CHAR)) AND
266: l_icc_id IS NOT NULL AND l_cat_templ_count = 0 THEN
267: /*When ICC has no defined Templates but a tempate id/name presents*/
268: l_error_exists := TRUE;
269: l_column_name := 'TEMPLATE_NAME/TEMPLATE_ID';

Line 272: cur.template_id = FND_API.G_MISS_NUM) AND

268: l_error_exists := TRUE;
269: l_column_name := 'TEMPLATE_NAME/TEMPLATE_ID';
270: l_message_name := 'INV_TEMPLATE_ERROR';
271: ELSIF (cur.template_id IS NULL or
272: cur.template_id = FND_API.G_MISS_NUM) AND
273: (cur.template_name IS NOT NULL and
274: cur.template_name <> FND_API.G_MISS_CHAR) AND
275: l_cat_templ_count <> 0 THEN
276: /*When ICC has defined Templates*/

Line 274: cur.template_name <> FND_API.G_MISS_CHAR) AND

270: l_message_name := 'INV_TEMPLATE_ERROR';
271: ELSIF (cur.template_id IS NULL or
272: cur.template_id = FND_API.G_MISS_NUM) AND
273: (cur.template_name IS NOT NULL and
274: cur.template_name <> FND_API.G_MISS_CHAR) AND
275: l_cat_templ_count <> 0 THEN
276: /*When ICC has defined Templates*/
277:
278: OPEN check_template_name_icc(cur.template_name,NVL(cur.item_catalog_group_id,l_icc_id)); /* 8808831 FP added NVL */

Line 295: AND cur.template_id <> FND_API.G_MISS_NUM THEN /bug8942177/ /When ICC has defined Templates/

291: l_message_name := 'INV_ORG_TEMPLATE_ERROR';
292: END IF;
293:
294: ELSIF cur.template_id IS NOT NULL AND cur.template_id > 0 AND l_cat_templ_count <> 0
295: AND cur.template_id <> FND_API.G_MISS_NUM THEN /*bug8942177*/ /*When ICC has defined Templates*/
296:
297: OPEN check_template_id_icc(cur.template_id,NVL(cur.item_catalog_group_id,l_icc_id)); /* 8808831 FP added NVL */
298: FETCH check_template_id_icc INTO l_template_id,context_orgid;
299: CLOSE check_template_id_icc;

Line 315: cur.template_id = FND_API.G_MISS_NUM) AND

311: END IF;
312:
313:
314: ELSIF (cur.template_id IS NULL or
315: cur.template_id = FND_API.G_MISS_NUM) AND
316: (cur.TRANSACTION_TYPE = 'CREATE') AND
317: (cur.ITEM_CATALOG_GROUP_ID IS NOT NULL and
318: cur.ITEM_CATALOG_GROUP_ID <> FND_API.G_MISS_NUM) AND
319: (INV_ITEM_UTIL.Appl_Inst_EGO > 0)

Line 318: cur.ITEM_CATALOG_GROUP_ID <> FND_API.G_MISS_NUM) AND

314: ELSIF (cur.template_id IS NULL or
315: cur.template_id = FND_API.G_MISS_NUM) AND
316: (cur.TRANSACTION_TYPE = 'CREATE') AND
317: (cur.ITEM_CATALOG_GROUP_ID IS NOT NULL and
318: cur.ITEM_CATALOG_GROUP_ID <> FND_API.G_MISS_NUM) AND
319: (INV_ITEM_UTIL.Appl_Inst_EGO > 0)
320: --AND (INV_ITEM_UTIL.Object_Exists(p_object_type => 'SYNONYM', p_object_name => 'EGO_CAT_GRP_TEMPLATES') = 'Y')
321: --end added for bug: 7033786
322: AND (l_ego_cat_grp_flag = 'Y')

Line 335: cur.template_id = FND_API.G_MISS_NUM) AND

331: l_template_id := INV_EGO_REVISION_VALIDATE.get_default_template(cur.ITEM_CATALOG_GROUP_ID);
332: END IF;
333:
334: ELSIF (cur.template_id IS NULL or
335: cur.template_id = FND_API.G_MISS_NUM) AND
336: (cur.TRANSACTION_TYPE = 'CREATE')
337: -- Adding the below clause to prevent application of default templates in the case of SKU Item
338: AND ( cur.style_item_flag IS NULL OR cur.style_item_flag = 'Y')
339: THEN

Line 401: IF x_ret_sts <>FND_API.G_RET_STS_SUCCESS THEN

397: p_to_item_id => cur.inventory_item_id,
398: p_to_org_id => cur.organization_id,
399: x_return_status => x_ret_sts);
400:
401: IF x_ret_sts <>FND_API.G_RET_STS_SUCCESS THEN
402:
403: dumm_status := INVPUOPI.mtl_log_interface_err(
404: cur.organization_id,
405: user_id,