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 403: where user_name = DECODE(p_owner,EGO_ITEM_PUB.G_ALL_USERS_PARTY_TYPE,'MFG',p_owner);

399: BEGIN
400: SELECT user_id, party_id
401: INTO l_user_id, l_party_id
402: from ego_user_v
403: where user_name = DECODE(p_owner,EGO_ITEM_PUB.G_ALL_USERS_PARTY_TYPE,'MFG',p_owner);
404: IF p_owner = EGO_ITEM_PUB.G_ALL_USERS_PARTY_TYPE THEN
405: l_party_id := -1000;
406: END IF;
407: EXCEPTION

Line 404: IF p_owner = EGO_ITEM_PUB.G_ALL_USERS_PARTY_TYPE THEN

400: SELECT user_id, party_id
401: INTO l_user_id, l_party_id
402: from ego_user_v
403: where user_name = DECODE(p_owner,EGO_ITEM_PUB.G_ALL_USERS_PARTY_TYPE,'MFG',p_owner);
404: IF p_owner = EGO_ITEM_PUB.G_ALL_USERS_PARTY_TYPE THEN
405: l_party_id := -1000;
406: END IF;
407: EXCEPTION
408: WHEN OTHERS THEN

Line 421: l_transaction_type := EGO_ITEM_PUB.G_TTYPE_CREATE;

417: get_catalog_group_id (p_catalog_group => p_catalog_group
418: ,x_catalog_group_id => l_catalog_group_id
419: );
420: IF l_catalog_group_id IS NULL THEN
421: l_transaction_type := EGO_ITEM_PUB.G_TTYPE_CREATE;
422: ELSE
423: l_transaction_type := EGO_ITEM_PUB.G_TTYPE_UPDATE;
424: END IF;
425: l_language := USERENV ('LANG');

Line 423: l_transaction_type := EGO_ITEM_PUB.G_TTYPE_UPDATE;

419: );
420: IF l_catalog_group_id IS NULL THEN
421: l_transaction_type := EGO_ITEM_PUB.G_TTYPE_CREATE;
422: ELSE
423: l_transaction_type := EGO_ITEM_PUB.G_TTYPE_UPDATE;
424: END IF;
425: l_language := USERENV ('LANG');
426: code_debug('Sync_Catalog_Group calling EGO_ITEM_CATALOG_PUB.Process_Catalog_Group trans type '||l_transaction_type);
427: EGO_ITEM_CATALOG_PUB.Process_Catalog_Group

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

483: , x_catalog_group_name => l_catalog_name
484: );
485: -- code_debug('Sync_Catalog_Group returning EGO_ITEM_CATALOG_PUB.Process_Catalog_Group with status '||x_Return_Status);
486: x_catalog_group_id := NVL(x_catalog_group_id, l_catalog_group_id);
487: x_return_status := NVL(x_return_status,EGO_ITEM_PUB.G_RET_STS_SUCCESS);
488: IF x_return_status = EGO_ITEM_PUB.G_RET_STS_SUCCESS AND
489: l_transaction_type = EGO_ITEM_PUB.G_TTYPE_CREATE THEN
490:
491: -- Bug fix# 10306119 - CHECHAND - START

Line 488: IF x_return_status = EGO_ITEM_PUB.G_RET_STS_SUCCESS AND

484: );
485: -- code_debug('Sync_Catalog_Group returning EGO_ITEM_CATALOG_PUB.Process_Catalog_Group with status '||x_Return_Status);
486: x_catalog_group_id := NVL(x_catalog_group_id, l_catalog_group_id);
487: x_return_status := NVL(x_return_status,EGO_ITEM_PUB.G_RET_STS_SUCCESS);
488: IF x_return_status = EGO_ITEM_PUB.G_RET_STS_SUCCESS AND
489: l_transaction_type = EGO_ITEM_PUB.G_TTYPE_CREATE THEN
490:
491: -- Bug fix# 10306119 - CHECHAND - START
492: -- Default the value of "NEW_ITEM_REQUEST_REQD" field to 'N'. This is required to mark the ICC as one without any new item request setup.

Line 489: l_transaction_type = EGO_ITEM_PUB.G_TTYPE_CREATE THEN

485: -- code_debug('Sync_Catalog_Group returning EGO_ITEM_CATALOG_PUB.Process_Catalog_Group with status '||x_Return_Status);
486: x_catalog_group_id := NVL(x_catalog_group_id, l_catalog_group_id);
487: x_return_status := NVL(x_return_status,EGO_ITEM_PUB.G_RET_STS_SUCCESS);
488: IF x_return_status = EGO_ITEM_PUB.G_RET_STS_SUCCESS AND
489: l_transaction_type = EGO_ITEM_PUB.G_TTYPE_CREATE THEN
490:
491: -- Bug fix# 10306119 - CHECHAND - START
492: -- Default the value of "NEW_ITEM_REQUEST_REQD" field to 'N'. This is required to mark the ICC as one without any new item request setup.
493: UPDATE MTL_ITEM_CATALOG_GROUPS_B

Line 516: , p_instance_type => EGO_ITEM_PUB.G_INSTANCE_TYPE_INSTANCE

512: EGO_SECURITY_PUB.grant_role_guid(
513: p_api_version => p_api_version
514: , p_role_name => 'EGO_CATALOG_GROUP_USER'
515: , p_object_name => 'EGO_CATALOG_GROUP'
516: , p_instance_type => EGO_ITEM_PUB.G_INSTANCE_TYPE_INSTANCE
517: , p_instance_set_id => NULL
518: , p_instance_pk1_value => x_catalog_group_id
519: , p_instance_pk2_value => NULL
520: , p_instance_pk3_value => NULL

Line 531: x_return_status := EGO_ITEM_PUB.G_RET_STS_SUCCESS;

527: , x_errorcode => l_errorcode
528: , x_grant_guid => l_grant_guid
529: );
530: IF FND_API.TO_BOOLEAN(x_return_status) THEN
531: x_return_status := EGO_ITEM_PUB.G_RET_STS_SUCCESS;
532: ELSE
533: x_return_status := EGO_ITEM_PUB.G_RET_STS_ERROR;
534: END IF;
535: END IF;

Line 533: x_return_status := EGO_ITEM_PUB.G_RET_STS_ERROR;

529: );
530: IF FND_API.TO_BOOLEAN(x_return_status) THEN
531: x_return_status := EGO_ITEM_PUB.G_RET_STS_SUCCESS;
532: ELSE
533: x_return_status := EGO_ITEM_PUB.G_RET_STS_ERROR;
534: END IF;
535: END IF;
536: IF FND_API.TO_BOOLEAN(p_commit) AND
537: x_return_status = EGO_ITEM_PUB.G_RET_STS_SUCCESS THEN

Line 537: x_return_status = EGO_ITEM_PUB.G_RET_STS_SUCCESS THEN

533: x_return_status := EGO_ITEM_PUB.G_RET_STS_ERROR;
534: END IF;
535: END IF;
536: IF FND_API.TO_BOOLEAN(p_commit) AND
537: x_return_status = EGO_ITEM_PUB.G_RET_STS_SUCCESS THEN
538: COMMIT WORK;
539: END IF;
540: -- code_debug('Sync_Catalog_Group returning with status '||x_return_status);
541: EXCEPTION

Line 544: x_return_status := EGO_ITEM_PUB.G_RET_STS_UNEXP_ERROR;

540: -- code_debug('Sync_Catalog_Group returning with status '||x_return_status);
541: EXCEPTION
542: WHEN OTHERS THEN
543: code_debug('Sync_Catalog_Group returning EXCEPTION '||SQLERRM);
544: x_return_status := EGO_ITEM_PUB.G_RET_STS_UNEXP_ERROR;
545: x_msg_data := SQLERRM;
546: END Sync_Catalog_Group;
547:
548: --------------------------------------------------------

Line 579: x_return_status := EGO_ITEM_PUB.G_RET_STS_ERROR;

575: ELSE
576: l_catalog_group_id := p_catalog_group_id;
577: END IF;
578: IF l_catalog_group_id IS NULL THEN
579: x_return_status := EGO_ITEM_PUB.G_RET_STS_ERROR;
580: x_msg_data := 'sync_cat_attr_grp_assoc Catalog Category does not exist for '||p_catalog_group;
581: RETURN;
582: END IF;
583: get_attr_group_id (p_attr_group_name => p_attr_group_name

Line 588: x_return_status := EGO_ITEM_PUB.G_RET_STS_ERROR;

584: ,p_attr_group_type => p_attr_group_type
585: ,x_attr_group_id => l_attr_group_id
586: );
587: IF l_attr_group_id IS NULL THEN
588: x_return_status := EGO_ITEM_PUB.G_RET_STS_ERROR;
589: x_msg_data := 'sync_cat_attr_grp_assoc attr group does not exist for '||p_attr_group_name;
590: RETURN;
591: END IF;
592: l_object_id := get_object_id ();

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

628: ,x_msg_count => x_msg_count
629: ,x_msg_data => x_msg_data
630: );
631: END IF;
632: x_return_status := NVL(x_return_status,EGO_ITEM_PUB.G_RET_STS_SUCCESS);
633: -- code_debug('sync_cat_attr_grp_assoc returning with status '||x_return_status);
634:
635: EXCEPTION
636: WHEN OTHERS THEN

Line 638: x_return_status := EGO_ITEM_PUB.G_RET_STS_UNEXP_ERROR;

634:
635: EXCEPTION
636: WHEN OTHERS THEN
637: code_debug('sync_cat_attr_grp_assoc returning EXCEPTION '||SQLERRM);
638: x_return_status := EGO_ITEM_PUB.G_RET_STS_UNEXP_ERROR;
639: x_msg_data := SQLERRM;
640: END sync_cat_attr_grp_assoc;
641:
642: --------------------------------------------------------

Line 673: x_return_status := EGO_ITEM_PUB.G_RET_STS_ERROR;

669: ELSE
670: l_catalog_group_id := p_catalog_group_id;
671: END IF;
672: IF l_catalog_group_id IS NULL THEN
673: x_return_status := EGO_ITEM_PUB.G_RET_STS_ERROR;
674: x_msg_data := 'sync_cat_item_pages Catalog Category does not exist for '||p_catalog_group;
675: RETURN;
676: END IF;
677: l_object_id := get_object_id();

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

715: ,x_msg_count => x_msg_count
716: ,x_msg_data => x_msg_data
717: );
718: END IF;
719: x_return_status := NVL(x_return_status,EGO_ITEM_PUB.G_RET_STS_SUCCESS);
720: EXCEPTION
721: WHEN OTHERS THEN
722: code_debug('sync_cat_item_pages returning EXCEPTION '||SQLERRM);
723: x_return_status := EGO_ITEM_PUB.G_RET_STS_UNEXP_ERROR;

Line 723: x_return_status := EGO_ITEM_PUB.G_RET_STS_UNEXP_ERROR;

719: x_return_status := NVL(x_return_status,EGO_ITEM_PUB.G_RET_STS_SUCCESS);
720: EXCEPTION
721: WHEN OTHERS THEN
722: code_debug('sync_cat_item_pages returning EXCEPTION '||SQLERRM);
723: x_return_status := EGO_ITEM_PUB.G_RET_STS_UNEXP_ERROR;
724: x_msg_data := SQLERRM;
725: END sync_cat_item_pages;
726:
727: --

Line 781: x_return_status := EGO_ITEM_PUB.G_RET_STS_ERROR;

777: l_catalog_group_id := p_catalog_group_id;
778: END IF;
779:
780: IF l_catalog_group_id IS NULL THEN
781: x_return_status := EGO_ITEM_PUB.G_RET_STS_ERROR;
782: x_msg_data := 'sync_cat_item_page_entries Catalog Category does not exist for '||p_catalog_group;
783: RETURN;
784: END IF;
785: get_attr_group_id (p_attr_group_name => p_attr_group_name

Line 791: x_return_status := EGO_ITEM_PUB.G_RET_STS_ERROR;

787: ,x_attr_group_id => l_attr_group_id
788: );
789:
790: IF l_attr_group_id IS NULL THEN
791: x_return_status := EGO_ITEM_PUB.G_RET_STS_ERROR;
792: x_msg_data := 'sync_cat_item_page_entries attr group does not exist for '||p_attr_group_name;
793: RETURN;
794: END IF;
795: l_object_id := get_object_id ();

Line 805: x_return_status := EGO_ITEM_PUB.G_RET_STS_ERROR;

801: ELSE
802: l_association_id := p_association_id;
803: END IF;
804: IF l_association_id IS NULL THEN
805: x_return_status := EGO_ITEM_PUB.G_RET_STS_ERROR;
806: x_msg_data := 'sync_cat_item_page_entries association id does not exist for '||l_attr_group_id;
807: RETURN;
808: END IF;
809: IF p_page_id IS NULL THEN

Line 820: x_return_status := EGO_ITEM_PUB.G_RET_STS_ERROR;

816: ELSE
817: l_page_id := p_page_id;
818: END IF;
819: IF l_page_id IS NULL THEN
820: x_return_status := EGO_ITEM_PUB.G_RET_STS_ERROR;
821: x_msg_data := 'sync_cat_item_page_entries page id does not exist for '||p_page_int_name;
822: RETURN;
823: END IF;
824:

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

860: ,x_msg_count => x_msg_count
861: ,x_msg_data => x_msg_data
862: );
863: END IF;
864: x_return_status := NVL(x_return_status,EGO_ITEM_PUB.G_RET_STS_SUCCESS);
865: EXCEPTION
866: WHEN OTHERS THEN
867: code_debug('sync_cat_item_page_entries returning EXCEPTION '||SQLERRM);
868: x_return_status := EGO_ITEM_PUB.G_RET_STS_UNEXP_ERROR;

Line 868: x_return_status := EGO_ITEM_PUB.G_RET_STS_UNEXP_ERROR;

864: x_return_status := NVL(x_return_status,EGO_ITEM_PUB.G_RET_STS_SUCCESS);
865: EXCEPTION
866: WHEN OTHERS THEN
867: code_debug('sync_cat_item_page_entries returning EXCEPTION '||SQLERRM);
868: x_return_status := EGO_ITEM_PUB.G_RET_STS_UNEXP_ERROR;
869: x_msg_data := SQLERRM;
870: END sync_cat_item_page_entries;
871:
872: