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.EGO_UPLOAD_PUB dependencies on EGO_ITEM_PUB

Line 280: where user_name = DECODE(p_owner,EGO_ITEM_PUB.G_ALL_USERS_PARTY_TYPE,'MFG',p_owner);

276: BEGIN
277: SELECT user_id, party_id
278: INTO l_user_id, l_party_id
279: from ego_user_v
280: where user_name = DECODE(p_owner,EGO_ITEM_PUB.G_ALL_USERS_PARTY_TYPE,'MFG',p_owner);
281: IF p_owner = EGO_ITEM_PUB.G_ALL_USERS_PARTY_TYPE THEN
282: l_party_id := -1000;
283: END IF;
284: EXCEPTION

Line 281: IF p_owner = EGO_ITEM_PUB.G_ALL_USERS_PARTY_TYPE THEN

277: SELECT user_id, party_id
278: INTO l_user_id, l_party_id
279: from ego_user_v
280: where user_name = DECODE(p_owner,EGO_ITEM_PUB.G_ALL_USERS_PARTY_TYPE,'MFG',p_owner);
281: IF p_owner = EGO_ITEM_PUB.G_ALL_USERS_PARTY_TYPE THEN
282: l_party_id := -1000;
283: END IF;
284: EXCEPTION
285: WHEN OTHERS THEN

Line 298: l_transaction_type := EGO_ITEM_PUB.G_TTYPE_CREATE;

294: get_catalog_group_id (p_catalog_group => p_catalog_group
295: ,x_catalog_group_id => l_catalog_group_id
296: );
297: IF l_catalog_group_id IS NULL THEN
298: l_transaction_type := EGO_ITEM_PUB.G_TTYPE_CREATE;
299: ELSE
300: l_transaction_type := EGO_ITEM_PUB.G_TTYPE_UPDATE;
301: END IF;
302: l_language := USERENV ('LANG');

Line 300: l_transaction_type := EGO_ITEM_PUB.G_TTYPE_UPDATE;

296: );
297: IF l_catalog_group_id IS NULL THEN
298: l_transaction_type := EGO_ITEM_PUB.G_TTYPE_CREATE;
299: ELSE
300: l_transaction_type := EGO_ITEM_PUB.G_TTYPE_UPDATE;
301: END IF;
302: l_language := USERENV ('LANG');
303: code_debug('Sync_Catalog_Group calling EGO_ITEM_CATALOG_PUB.Process_Catalog_Group trans type '||l_transaction_type);
304: EGO_ITEM_CATALOG_PUB.Process_Catalog_Group

Line 364: x_return_status := NVL(x_return_status,EGO_ITEM_PUB.G_RET_STS_SUCCESS);

360: , x_catalog_group_name => l_catalog_name
361: );
362: -- code_debug('Sync_Catalog_Group returning EGO_ITEM_CATALOG_PUB.Process_Catalog_Group with status '||x_Return_Status);
363: x_catalog_group_id := NVL(x_catalog_group_id, l_catalog_group_id);
364: x_return_status := NVL(x_return_status,EGO_ITEM_PUB.G_RET_STS_SUCCESS);
365: IF x_return_status = EGO_ITEM_PUB.G_RET_STS_SUCCESS AND
366: l_transaction_type = EGO_ITEM_PUB.G_TTYPE_CREATE THEN
367: IF p_parent_catalog_group IS NULL THEN
368: createBaseAttributePages(p_catalog_group_id => x_catalog_group_id

Line 365: IF x_return_status = EGO_ITEM_PUB.G_RET_STS_SUCCESS AND

361: );
362: -- code_debug('Sync_Catalog_Group returning EGO_ITEM_CATALOG_PUB.Process_Catalog_Group with status '||x_Return_Status);
363: x_catalog_group_id := NVL(x_catalog_group_id, l_catalog_group_id);
364: x_return_status := NVL(x_return_status,EGO_ITEM_PUB.G_RET_STS_SUCCESS);
365: IF x_return_status = EGO_ITEM_PUB.G_RET_STS_SUCCESS AND
366: l_transaction_type = EGO_ITEM_PUB.G_TTYPE_CREATE THEN
367: IF p_parent_catalog_group IS NULL THEN
368: createBaseAttributePages(p_catalog_group_id => x_catalog_group_id
369: ,x_return_status => x_return_status

Line 366: l_transaction_type = EGO_ITEM_PUB.G_TTYPE_CREATE THEN

362: -- code_debug('Sync_Catalog_Group returning EGO_ITEM_CATALOG_PUB.Process_Catalog_Group with status '||x_Return_Status);
363: x_catalog_group_id := NVL(x_catalog_group_id, l_catalog_group_id);
364: x_return_status := NVL(x_return_status,EGO_ITEM_PUB.G_RET_STS_SUCCESS);
365: IF x_return_status = EGO_ITEM_PUB.G_RET_STS_SUCCESS AND
366: l_transaction_type = EGO_ITEM_PUB.G_TTYPE_CREATE THEN
367: IF p_parent_catalog_group IS NULL THEN
368: createBaseAttributePages(p_catalog_group_id => x_catalog_group_id
369: ,x_return_status => x_return_status
370: );

Line 376: , p_instance_type => EGO_ITEM_PUB.G_INSTANCE_TYPE_INSTANCE

372: EGO_SECURITY_PUB.grant_role_guid(
373: p_api_version => p_api_version
374: , p_role_name => 'EGO_CATALOG_GROUP_USER'
375: , p_object_name => 'EGO_CATALOG_GROUP'
376: , p_instance_type => EGO_ITEM_PUB.G_INSTANCE_TYPE_INSTANCE
377: , p_instance_set_id => NULL
378: , p_instance_pk1_value => x_catalog_group_id
379: , p_instance_pk2_value => NULL
380: , p_instance_pk3_value => NULL

Line 391: x_return_status := EGO_ITEM_PUB.G_RET_STS_SUCCESS;

387: , x_errorcode => l_errorcode
388: , x_grant_guid => l_grant_guid
389: );
390: IF FND_API.TO_BOOLEAN(x_return_status) THEN
391: x_return_status := EGO_ITEM_PUB.G_RET_STS_SUCCESS;
392: ELSE
393: x_return_status := EGO_ITEM_PUB.G_RET_STS_ERROR;
394: END IF;
395: END IF;

Line 393: x_return_status := EGO_ITEM_PUB.G_RET_STS_ERROR;

389: );
390: IF FND_API.TO_BOOLEAN(x_return_status) THEN
391: x_return_status := EGO_ITEM_PUB.G_RET_STS_SUCCESS;
392: ELSE
393: x_return_status := EGO_ITEM_PUB.G_RET_STS_ERROR;
394: END IF;
395: END IF;
396: IF FND_API.TO_BOOLEAN(p_commit) AND
397: x_return_status = EGO_ITEM_PUB.G_RET_STS_SUCCESS THEN

Line 397: x_return_status = EGO_ITEM_PUB.G_RET_STS_SUCCESS THEN

393: x_return_status := EGO_ITEM_PUB.G_RET_STS_ERROR;
394: END IF;
395: END IF;
396: IF FND_API.TO_BOOLEAN(p_commit) AND
397: x_return_status = EGO_ITEM_PUB.G_RET_STS_SUCCESS THEN
398: COMMIT WORK;
399: END IF;
400: -- code_debug('Sync_Catalog_Group returning with status '||x_return_status);
401: EXCEPTION

Line 404: x_return_status := EGO_ITEM_PUB.G_RET_STS_UNEXP_ERROR;

400: -- code_debug('Sync_Catalog_Group returning with status '||x_return_status);
401: EXCEPTION
402: WHEN OTHERS THEN
403: code_debug('Sync_Catalog_Group returning EXCEPTION '||SQLERRM);
404: x_return_status := EGO_ITEM_PUB.G_RET_STS_UNEXP_ERROR;
405: x_msg_data := SQLERRM;
406: END Sync_Catalog_Group;
407:
408: --------------------------------------------------------

Line 439: x_return_status := EGO_ITEM_PUB.G_RET_STS_ERROR;

435: ELSE
436: l_catalog_group_id := p_catalog_group_id;
437: END IF;
438: IF l_catalog_group_id IS NULL THEN
439: x_return_status := EGO_ITEM_PUB.G_RET_STS_ERROR;
440: x_msg_data := 'sync_cat_attr_grp_assoc Catalog Category does not exist for '||p_catalog_group;
441: RETURN;
442: END IF;
443: get_attr_group_id (p_attr_group_name => p_attr_group_name

Line 448: x_return_status := EGO_ITEM_PUB.G_RET_STS_ERROR;

444: ,p_attr_group_type => p_attr_group_type
445: ,x_attr_group_id => l_attr_group_id
446: );
447: IF l_attr_group_id IS NULL THEN
448: x_return_status := EGO_ITEM_PUB.G_RET_STS_ERROR;
449: x_msg_data := 'sync_cat_attr_grp_assoc attr group does not exist for '||p_attr_group_name;
450: RETURN;
451: END IF;
452: l_object_id := get_object_id ();

Line 492: x_return_status := NVL(x_return_status,EGO_ITEM_PUB.G_RET_STS_SUCCESS);

488: ,x_msg_count => x_msg_count
489: ,x_msg_data => x_msg_data
490: );
491: END IF;
492: x_return_status := NVL(x_return_status,EGO_ITEM_PUB.G_RET_STS_SUCCESS);
493: -- code_debug('sync_cat_attr_grp_assoc returning with status '||x_return_status);
494:
495: EXCEPTION
496: WHEN OTHERS THEN

Line 498: x_return_status := EGO_ITEM_PUB.G_RET_STS_UNEXP_ERROR;

494:
495: EXCEPTION
496: WHEN OTHERS THEN
497: code_debug('sync_cat_attr_grp_assoc returning EXCEPTION '||SQLERRM);
498: x_return_status := EGO_ITEM_PUB.G_RET_STS_UNEXP_ERROR;
499: x_msg_data := SQLERRM;
500: END sync_cat_attr_grp_assoc;
501:
502: --------------------------------------------------------

Line 533: x_return_status := EGO_ITEM_PUB.G_RET_STS_ERROR;

529: ELSE
530: l_catalog_group_id := p_catalog_group_id;
531: END IF;
532: IF l_catalog_group_id IS NULL THEN
533: x_return_status := EGO_ITEM_PUB.G_RET_STS_ERROR;
534: x_msg_data := 'sync_cat_item_pages Catalog Category does not exist for '||p_catalog_group;
535: RETURN;
536: END IF;
537: l_object_id := get_object_id();

Line 579: x_return_status := NVL(x_return_status,EGO_ITEM_PUB.G_RET_STS_SUCCESS);

575: ,x_msg_count => x_msg_count
576: ,x_msg_data => x_msg_data
577: );
578: END IF;
579: x_return_status := NVL(x_return_status,EGO_ITEM_PUB.G_RET_STS_SUCCESS);
580: EXCEPTION
581: WHEN OTHERS THEN
582: code_debug('sync_cat_item_pages returning EXCEPTION '||SQLERRM);
583: x_return_status := EGO_ITEM_PUB.G_RET_STS_UNEXP_ERROR;

Line 583: x_return_status := EGO_ITEM_PUB.G_RET_STS_UNEXP_ERROR;

579: x_return_status := NVL(x_return_status,EGO_ITEM_PUB.G_RET_STS_SUCCESS);
580: EXCEPTION
581: WHEN OTHERS THEN
582: code_debug('sync_cat_item_pages returning EXCEPTION '||SQLERRM);
583: x_return_status := EGO_ITEM_PUB.G_RET_STS_UNEXP_ERROR;
584: x_msg_data := SQLERRM;
585: END sync_cat_item_pages;
586:
587: --------------------------------------------------------

Line 617: x_return_status := EGO_ITEM_PUB.G_RET_STS_ERROR;

613: get_catalog_group_id (p_catalog_group => p_catalog_group
614: ,x_catalog_group_id => l_catalog_group_id
615: );
616: IF l_catalog_group_id IS NULL THEN
617: x_return_status := EGO_ITEM_PUB.G_RET_STS_ERROR;
618: x_msg_data := 'sync_cat_item_page_entries Catalog Category does not exist for '||p_catalog_group;
619: RETURN;
620: END IF;
621: get_attr_group_id (p_attr_group_name => p_attr_group_name

Line 626: x_return_status := EGO_ITEM_PUB.G_RET_STS_ERROR;

622: ,p_attr_group_type => p_attr_group_type
623: ,x_attr_group_id => l_attr_group_id
624: );
625: IF l_attr_group_id IS NULL THEN
626: x_return_status := EGO_ITEM_PUB.G_RET_STS_ERROR;
627: x_msg_data := 'sync_cat_item_page_entries attr group does not exist for '||p_attr_group_name;
628: RETURN;
629: END IF;
630: l_object_id := get_object_id ();

Line 640: x_return_status := EGO_ITEM_PUB.G_RET_STS_ERROR;

636: ELSE
637: l_association_id := p_association_id;
638: END IF;
639: IF l_association_id IS NULL THEN
640: x_return_status := EGO_ITEM_PUB.G_RET_STS_ERROR;
641: x_msg_data := 'sync_cat_item_page_entries association id does not exist for '||l_attr_group_id;
642: RETURN;
643: END IF;
644: IF p_page_id IS NULL THEN

Line 654: x_return_status := EGO_ITEM_PUB.G_RET_STS_ERROR;

650: ELSE
651: l_page_id := p_page_id;
652: END IF;
653: IF l_page_id IS NULL THEN
654: x_return_status := EGO_ITEM_PUB.G_RET_STS_ERROR;
655: x_msg_data := 'sync_cat_item_page_entries page id does not exist for '||p_page_int_name;
656: RETURN;
657: END IF;
658:

Line 698: x_return_status := NVL(x_return_status,EGO_ITEM_PUB.G_RET_STS_SUCCESS);

694: ,x_msg_count => x_msg_count
695: ,x_msg_data => x_msg_data
696: );
697: END IF;
698: x_return_status := NVL(x_return_status,EGO_ITEM_PUB.G_RET_STS_SUCCESS);
699: EXCEPTION
700: WHEN OTHERS THEN
701: code_debug('sync_cat_item_page_entries returning EXCEPTION '||SQLERRM);
702: x_return_status := EGO_ITEM_PUB.G_RET_STS_UNEXP_ERROR;

Line 702: x_return_status := EGO_ITEM_PUB.G_RET_STS_UNEXP_ERROR;

698: x_return_status := NVL(x_return_status,EGO_ITEM_PUB.G_RET_STS_SUCCESS);
699: EXCEPTION
700: WHEN OTHERS THEN
701: code_debug('sync_cat_item_page_entries returning EXCEPTION '||SQLERRM);
702: x_return_status := EGO_ITEM_PUB.G_RET_STS_UNEXP_ERROR;
703: x_msg_data := SQLERRM;
704: END sync_cat_item_page_entries;
705:
706: