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_EBI_ITEM_HELPER dependencies on EGO_ITEM_PUB

Line 1868: INV_EBI_UTIL.debug_line('STEP 20: BEFORE CALLING EGO_ITEM_PUB.Process_Item_Revision ');

1864: l_effectivity_date := SYSDATE;
1865: ELSE
1866: l_effectivity_date := l_item.main_obj_type.effectivity_date;
1867: END IF;
1868: INV_EBI_UTIL.debug_line('STEP 20: BEFORE CALLING EGO_ITEM_PUB.Process_Item_Revision ');
1869: INV_EBI_UTIL.debug_line('STEP 30: ITEM NUMBER '|| l_item.main_obj_type.item_number || 'ORG CODE: '|| l_item.main_obj_type.organization_code);
1870: EGO_ITEM_PUB.Process_Item_Revision(
1871: p_api_version => 1.0
1872: ,p_init_msg_list => FND_API.g_false

Line 1870: EGO_ITEM_PUB.Process_Item_Revision(

1866: l_effectivity_date := l_item.main_obj_type.effectivity_date;
1867: END IF;
1868: INV_EBI_UTIL.debug_line('STEP 20: BEFORE CALLING EGO_ITEM_PUB.Process_Item_Revision ');
1869: INV_EBI_UTIL.debug_line('STEP 30: ITEM NUMBER '|| l_item.main_obj_type.item_number || 'ORG CODE: '|| l_item.main_obj_type.organization_code);
1870: EGO_ITEM_PUB.Process_Item_Revision(
1871: p_api_version => 1.0
1872: ,p_init_msg_list => FND_API.g_false
1873: ,p_commit => FND_API.g_false
1874: ,p_transaction_type => INV_EBI_ITEM_PUB.g_otype_create

Line 1908: INV_EBI_UTIL.debug_line('STEP 40: AFTER CALLING EGO_ITEM_PUB.Process_Item_Revision STATUS: '|| x_out.output_status.return_status);

1904: ,x_return_status => x_out.output_status.return_status
1905: ,x_msg_count => x_out.output_status.msg_count
1906: ,x_msg_data => x_out.output_status.msg_data
1907: );
1908: INV_EBI_UTIL.debug_line('STEP 40: AFTER CALLING EGO_ITEM_PUB.Process_Item_Revision STATUS: '|| x_out.output_status.return_status);
1909: IF (x_out.output_status.return_status NOT IN (FND_API.g_ret_sts_success,'0')) THEN
1910: x_out.output_status.msg_data := x_out.output_status.msg_data || ' -> Item Number:' || l_item.main_obj_type.item_number || ' -> Org Code: ' || l_item.main_obj_type.organization_code;
1911: RAISE FND_API.g_exc_unexpected_error;
1912: END IF;

Line 1989: INV_EBI_UTIL.debug_line('STEP 50: BEFORE CALLING EGO_ITEM_PUB.process_item');

1985: --End of Bug 9688120
1986:
1987: END IF;
1988:
1989: INV_EBI_UTIL.debug_line('STEP 50: BEFORE CALLING EGO_ITEM_PUB.process_item');
1990:
1991: -- Following code is commented out for Bug 13618550 ,it may cause issue to PLM4P PIP
1992: /*
1993: IF( (l_item.main_obj_type.tracking_quantity_ind = 'P' OR l_item.main_obj_type.tracking_quantity_ind IS NULL OR l_item.main_obj_type.tracking_quantity_ind = fnd_api.g_miss_char) AND

Line 1999: INV_EBI_UTIL.debug_line('STEP 60:In INV_EBI_ITEM_HELPER.process_item_pvt,before calling EGO_ITEM_PUB.process_item');

1995: l_item.main_obj_type.secondary_default_ind := fnd_api.g_miss_char;
1996: END IF;
1997: */
1998:
1999: INV_EBI_UTIL.debug_line('STEP 60:In INV_EBI_ITEM_HELPER.process_item_pvt,before calling EGO_ITEM_PUB.process_item');
2000: INV_EBI_UTIL.debug_line('STEP 70: Engineering_date before defaulting to fnd_api.g_miss_date ' || to_char(l_item.deprecated_obj_type.engineering_date,'YYYY/MM/DD HH24:MI:SS'));
2001: --OAAdapter is not setting engineering_date to fnd_api.g_miss_date on Cummins soa env.
2002: --as a temporary fix we are hardcoding the value.
2003: l_item.deprecated_obj_type.engineering_date := fnd_api.g_miss_date; -- added for bug 11884886

Line 2004: INV_EBI_UTIL.debug_line('STEP 80:Before calling EGO_ITEM_PUB.process_item after defaulting to fnd_api.g_miss_date ' || to_char(l_item.deprecated_obj_type.engineering_date,'YYYY/MM/DD HH24:MI:SS'));

2000: INV_EBI_UTIL.debug_line('STEP 70: Engineering_date before defaulting to fnd_api.g_miss_date ' || to_char(l_item.deprecated_obj_type.engineering_date,'YYYY/MM/DD HH24:MI:SS'));
2001: --OAAdapter is not setting engineering_date to fnd_api.g_miss_date on Cummins soa env.
2002: --as a temporary fix we are hardcoding the value.
2003: l_item.deprecated_obj_type.engineering_date := fnd_api.g_miss_date; -- added for bug 11884886
2004: INV_EBI_UTIL.debug_line('STEP 80:Before calling EGO_ITEM_PUB.process_item after defaulting to fnd_api.g_miss_date ' || to_char(l_item.deprecated_obj_type.engineering_date,'YYYY/MM/DD HH24:MI:SS'));
2005: EGO_ITEM_PUB.process_item(
2006: p_api_version => 1.0
2007: ,p_init_msg_list => l_item.main_obj_type.init_msg_list
2008: ,p_commit => FND_API.g_false

Line 2005: EGO_ITEM_PUB.process_item(

2001: --OAAdapter is not setting engineering_date to fnd_api.g_miss_date on Cummins soa env.
2002: --as a temporary fix we are hardcoding the value.
2003: l_item.deprecated_obj_type.engineering_date := fnd_api.g_miss_date; -- added for bug 11884886
2004: INV_EBI_UTIL.debug_line('STEP 80:Before calling EGO_ITEM_PUB.process_item after defaulting to fnd_api.g_miss_date ' || to_char(l_item.deprecated_obj_type.engineering_date,'YYYY/MM/DD HH24:MI:SS'));
2005: EGO_ITEM_PUB.process_item(
2006: p_api_version => 1.0
2007: ,p_init_msg_list => l_item.main_obj_type.init_msg_list
2008: ,p_commit => FND_API.g_false
2009: ,p_transaction_type => l_transaction_type

Line 2427: INV_EBI_UTIL.debug_line('STEP 90: AFTER CALLING EGO_ITEM_PUB.process_item STATUS: '|| x_out.output_status.return_status);

2423: ,p_repair_program => l_item.mrp_obj_type.repair_program
2424: ,p_subcontracting_component => l_item.gplanning_obj_type.subcontracting_component
2425: ,p_outsourced_assembly => l_item.purchasing_obj_type.outsourced_assembly
2426: );
2427: INV_EBI_UTIL.debug_line('STEP 90: AFTER CALLING EGO_ITEM_PUB.process_item STATUS: '|| x_out.output_status.return_status);
2428: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
2429: x_out.output_status.msg_data := x_out.output_status.msg_data || ' -> Item Number:' || l_item.main_obj_type.item_number || ' -> Org Code: ' || l_item.main_obj_type.organization_code;
2430: RAISE FND_API.g_exc_unexpected_error;
2431: END IF;

Line 2460: INV_EBI_UTIL.debug_line('STEP 110: BEFORE CALLING EGO_ITEM_PUB.process_item IN UPDATE MODE');

2456: -- Added for bug 14210113
2457: INV_EBI_UTIL.debug_line('STEP 100: BEFORE CALLING set_nls for language ' || l_nls_language);
2458: set_nls(l_nls_language);
2459:
2460: INV_EBI_UTIL.debug_line('STEP 110: BEFORE CALLING EGO_ITEM_PUB.process_item IN UPDATE MODE');
2461: EGO_ITEM_PUB.process_item(
2462: p_api_version => 1.0
2463: ,p_init_msg_list => l_item.main_obj_type.init_msg_list
2464: ,p_commit => FND_API.g_false

Line 2461: EGO_ITEM_PUB.process_item(

2457: INV_EBI_UTIL.debug_line('STEP 100: BEFORE CALLING set_nls for language ' || l_nls_language);
2458: set_nls(l_nls_language);
2459:
2460: INV_EBI_UTIL.debug_line('STEP 110: BEFORE CALLING EGO_ITEM_PUB.process_item IN UPDATE MODE');
2461: EGO_ITEM_PUB.process_item(
2462: p_api_version => 1.0
2463: ,p_init_msg_list => l_item.main_obj_type.init_msg_list
2464: ,p_commit => FND_API.g_false
2465: ,p_transaction_type => l_transaction_type

Line 2478: INV_EBI_UTIL.debug_line('STEP 110: AFTER CALLING EGO_ITEM_PUB.process_item IN UPDATE MODE: STATUS: '|| x_out.output_status.return_status);

2474: ,x_msg_count => x_out.output_status.msg_count
2475: ,x_msg_data => x_out.output_status.msg_data
2476: );
2477:
2478: INV_EBI_UTIL.debug_line('STEP 110: AFTER CALLING EGO_ITEM_PUB.process_item IN UPDATE MODE: STATUS: '|| x_out.output_status.return_status);
2479:
2480: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
2481:
2482: INV_EBI_UTIL.debug_line('Error while updating Item ' || l_item.main_obj_type.item_number || ' description using language code :' || l_item.main_obj_type.item_desc_lang_obj_tbl_type(i).lang_code);

Line 2513: EGO_ITEM_PUB.SYNC_IM_INDEX ;

2509:
2510: /*End of Bug 13370136 */ -- ramukher
2511:
2512: --Added for Bug 12902341
2513: EGO_ITEM_PUB.SYNC_IM_INDEX ;
2514:
2515: l_pk_col_name_val_pairs.EXTEND(1);
2516: l_pk_col_name_val_pairs(1).name := 'organization_id';
2517: l_pk_col_name_val_pairs(1).value := l_item.main_obj_type.organization_id;

Line 2798: INV_EBI_UTIL.debug_line('STEP 80: BEFORE CALLING EGO_ITEM_PUB.process_user_attrs_for_item ');

2794: l_attributes_row_table(i) := l_attributes_row_obj;
2795: END IF;
2796:
2797: END LOOP;
2798: INV_EBI_UTIL.debug_line('STEP 80: BEFORE CALLING EGO_ITEM_PUB.process_user_attrs_for_item ');
2799: EGO_ITEM_PUB.process_user_attrs_for_item(
2800: p_api_version => p_api_version
2801: ,p_inventory_item_id => p_inventory_item_id
2802: ,p_organization_id => p_organization_id

Line 2799: EGO_ITEM_PUB.process_user_attrs_for_item(

2795: END IF;
2796:
2797: END LOOP;
2798: INV_EBI_UTIL.debug_line('STEP 80: BEFORE CALLING EGO_ITEM_PUB.process_user_attrs_for_item ');
2799: EGO_ITEM_PUB.process_user_attrs_for_item(
2800: p_api_version => p_api_version
2801: ,p_inventory_item_id => p_inventory_item_id
2802: ,p_organization_id => p_organization_id
2803: ,p_attributes_row_table => l_attributes_row_table

Line 2821: INV_EBI_UTIL.debug_line('STEP 90: AFETR CALLING EGO_ITEM_PUB.process_user_attrs_for_item STATUS: '||x_uda_output_obj.output_status.return_status);

2817: ,x_errorcode => x_uda_output_obj.uda_output.errorcode
2818: ,x_msg_count => x_uda_output_obj.output_status.msg_count
2819: ,x_msg_data => x_uda_output_obj.output_status.msg_data
2820: );
2821: INV_EBI_UTIL.debug_line('STEP 90: AFETR CALLING EGO_ITEM_PUB.process_user_attrs_for_item STATUS: '||x_uda_output_obj.output_status.return_status);
2822: IF (x_uda_output_obj.output_status.return_status <> FND_API.g_ret_sts_success) THEN
2823: x_uda_output_obj.output_status.msg_data := x_uda_output_obj.output_status.msg_data || ' -> Inventory Item Id:' || p_inventory_item_id || ' -> Org Id: ' || p_organization_id;
2824: RAISE FND_API.g_exc_unexpected_error;
2825: END IF;

Line 2883: l_item_org_assignment_rec ego_item_pub.item_org_assignment_rec_type;

2879: ,p_org_id_tbl IN inv_ebi_org_tbl
2880: ,x_out OUT NOCOPY inv_ebi_item_output_obj
2881: )
2882: IS
2883: l_item_org_assignment_rec ego_item_pub.item_org_assignment_rec_type;
2884: l_item_org_assignment_tbl ego_item_pub.item_org_assignment_tbl_type;
2885: l_output_status inv_ebi_output_status;
2886: l_api_version NUMBER:=1.0;
2887: l_item_org_tbl_count NUMBER := 1;

Line 2884: l_item_org_assignment_tbl ego_item_pub.item_org_assignment_tbl_type;

2880: ,x_out OUT NOCOPY inv_ebi_item_output_obj
2881: )
2882: IS
2883: l_item_org_assignment_rec ego_item_pub.item_org_assignment_rec_type;
2884: l_item_org_assignment_tbl ego_item_pub.item_org_assignment_tbl_type;
2885: l_output_status inv_ebi_output_status;
2886: l_api_version NUMBER:=1.0;
2887: l_item_org_tbl_count NUMBER := 1;
2888: BEGIN

Line 2902: INV_EBI_UTIL.debug_line('STEP 40: BEFORE CALLING EGO_ITEM_PUB.process_item_org_assignments ');

2898: l_item_org_assignment_rec.organization_id := p_org_id_tbl(i).org_id;
2899: l_item_org_assignment_tbl(i) := l_item_org_assignment_rec;
2900: INV_EBI_UTIL.debug_line('STEP 30: ORGANIZATION ID: '||p_org_id_tbl(i).org_id);
2901: END LOOP;
2902: INV_EBI_UTIL.debug_line('STEP 40: BEFORE CALLING EGO_ITEM_PUB.process_item_org_assignments ');
2903: EGO_ITEM_PUB.process_item_org_assignments(
2904: p_api_version => l_api_version --don't pass as of now
2905: ,p_init_msg_list => p_init_msg_list
2906: ,p_commit => FND_API.g_false

Line 2903: EGO_ITEM_PUB.process_item_org_assignments(

2899: l_item_org_assignment_tbl(i) := l_item_org_assignment_rec;
2900: INV_EBI_UTIL.debug_line('STEP 30: ORGANIZATION ID: '||p_org_id_tbl(i).org_id);
2901: END LOOP;
2902: INV_EBI_UTIL.debug_line('STEP 40: BEFORE CALLING EGO_ITEM_PUB.process_item_org_assignments ');
2903: EGO_ITEM_PUB.process_item_org_assignments(
2904: p_api_version => l_api_version --don't pass as of now
2905: ,p_init_msg_list => p_init_msg_list
2906: ,p_commit => FND_API.g_false
2907: ,p_item_org_assignment_tbl => l_item_org_assignment_tbl

Line 2911: INV_EBI_UTIL.debug_line('STEP 50: AFTER CALLING EGO_ITEM_PUB.process_item_org_assignments STATUS: '|| x_out.output_status.return_status);

2907: ,p_item_org_assignment_tbl => l_item_org_assignment_tbl
2908: ,x_return_status => x_out.output_status.return_status
2909: ,x_msg_count => x_out.output_status.msg_count
2910: );
2911: INV_EBI_UTIL.debug_line('STEP 50: AFTER CALLING EGO_ITEM_PUB.process_item_org_assignments STATUS: '|| x_out.output_status.return_status);
2912: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
2913: x_out.output_status.msg_data := x_out.output_status.msg_data || ' -> Item Name:' || p_item_number;
2914: RAISE FND_API.g_exc_unexpected_error;
2915: END IF;

Line 3008: /* From 12.1.3 onwards (and 12.2), please call the EGO_ITEM_PUB.Process_Item_Cat_Assignment() API with UPDATE transaction.*/

3004:
3005:
3006:
3007: /* Bug 9755814 - Added the below API to update the category of an item when a default category set is already been assigned through the Functional area (Inventory, Purchasing etc.,) */
3008: /* From 12.1.3 onwards (and 12.2), please call the EGO_ITEM_PUB.Process_Item_Cat_Assignment() API with UPDATE transaction.*/
3009:
3010: /************************************************************************************
3011: -- API name : update_category_assignments
3012: -- Type : Public

Line 3126: INV_EBI_UTIL.debug_line('STEP 30: BEFORE CALLING EGO_ITEM_PUB.process_item_cat_assignment');

3122: INV_EBI_UTIL.debug_line('STEP 20: ITEM ID: '|| p_inventory_item_id || 'ORG ID: '|| p_organization_id);
3123: l_category_output := inv_ebi_category_output_obj(NULL);
3124: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
3125: x_out := inv_ebi_item_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,l_category_output,NULL,NULL,NULL,NULL);
3126: INV_EBI_UTIL.debug_line('STEP 30: BEFORE CALLING EGO_ITEM_PUB.process_item_cat_assignment');
3127: l_no_multi_assign_cat_set_tbl :=FND_TABLE_OF_NUMBER();
3128: FOR i IN 1..p_category_id_tbl.COUNT LOOP
3129: l_category_id := p_category_id_tbl(i).cat_id;
3130:

Line 3134: EGO_ITEM_PUB.process_item_cat_assignment(

3130:
3131: IF is_category_set_multi_assign(p_category_id_tbl(i).cat_set_id) THEN
3132: -- multi assign enabled - just add the category
3133: -- TODO - check what happens if same category comes again in CREATE mode
3134: EGO_ITEM_PUB.process_item_cat_assignment(
3135: p_api_version => p_api_version
3136: ,p_init_msg_list => p_init_msg_list
3137: ,p_commit => FND_API.g_false
3138: ,p_category_id => l_category_id

Line 3142: ,p_transaction_type => EGO_ITEM_PUB.G_TTYPE_CREATE

3138: ,p_category_id => l_category_id
3139: ,p_category_set_id => p_category_id_tbl(i).cat_set_id
3140: ,p_inventory_item_id => p_inventory_item_id
3141: ,p_organization_id => p_organization_id
3142: ,p_transaction_type => EGO_ITEM_PUB.G_TTYPE_CREATE
3143: ,x_return_status => x_out.output_status.return_status
3144: ,x_errorcode => x_out.category_output.error_code
3145: ,x_msg_count => x_out.output_status.msg_count
3146: ,x_msg_data => x_out.output_status.msg_data

Line 3148: INV_EBI_UTIL.debug_line('STEP 50: AFTER CALLING EGO_ITEM_PUB.process_item_cat_assignment STATUS: '|| x_out.output_status.return_status);

3144: ,x_errorcode => x_out.category_output.error_code
3145: ,x_msg_count => x_out.output_status.msg_count
3146: ,x_msg_data => x_out.output_status.msg_data
3147: );
3148: INV_EBI_UTIL.debug_line('STEP 50: AFTER CALLING EGO_ITEM_PUB.process_item_cat_assignment STATUS: '|| x_out.output_status.return_status);
3149: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
3150: x_out.output_status.msg_data := x_out.output_status.msg_data || ' -> Inventory Item Id:' || p_inventory_item_id || ' -> Org Id: ' || p_organization_id;
3151: RAISE FND_API.g_exc_unexpected_error;
3152: END IF;

Line 3158: EGO_ITEM_PUB.process_item_cat_assignment(

3154: -- multi assign disabled
3155: l_old_item_category := get_item_category(p_inventory_item_id, p_organization_id, p_category_id_tbl(i).cat_set_id);
3156: IF l_old_item_category = 0 THEN
3157: -- no category exists for the category set for the item
3158: EGO_ITEM_PUB.process_item_cat_assignment(
3159: p_api_version => p_api_version
3160: ,p_init_msg_list => p_init_msg_list
3161: ,p_commit => FND_API.g_false
3162: ,p_category_id => l_category_id

Line 3166: ,p_transaction_type => EGO_ITEM_PUB.G_TTYPE_CREATE

3162: ,p_category_id => l_category_id
3163: ,p_category_set_id => p_category_id_tbl(i).cat_set_id
3164: ,p_inventory_item_id => p_inventory_item_id
3165: ,p_organization_id => p_organization_id
3166: ,p_transaction_type => EGO_ITEM_PUB.G_TTYPE_CREATE
3167: ,x_return_status => x_out.output_status.return_status
3168: ,x_errorcode => x_out.category_output.error_code
3169: ,x_msg_count => x_out.output_status.msg_count
3170: ,x_msg_data => x_out.output_status.msg_data

Line 3173: INV_EBI_UTIL.debug_line('STEP 50: AFTER CALLING EGO_ITEM_PUB.process_item_cat_assignment STATUS: '|| x_out.output_status.return_status);

3169: ,x_msg_count => x_out.output_status.msg_count
3170: ,x_msg_data => x_out.output_status.msg_data
3171: );
3172:
3173: INV_EBI_UTIL.debug_line('STEP 50: AFTER CALLING EGO_ITEM_PUB.process_item_cat_assignment STATUS: '|| x_out.output_status.return_status);
3174: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
3175: x_out.output_status.msg_data := x_out.output_status.msg_data || ' -> Inventory Item Id:' || p_inventory_item_id || ' -> Org Id: ' || p_organization_id;
3176: RAISE FND_API.g_exc_unexpected_error;
3177: END IF;

Line 3201: INV_EBI_UTIL.debug_line('STEP 50: AFTER CALLING EGO_ITEM_PUB.process_item_cat_assignment STATUS: '|| x_out.output_status.return_status);

3197: ,x_msg_count => x_out.output_status.msg_count
3198: ,x_msg_data => x_out.output_status.msg_data
3199: );
3200:
3201: INV_EBI_UTIL.debug_line('STEP 50: AFTER CALLING EGO_ITEM_PUB.process_item_cat_assignment STATUS: '|| x_out.output_status.return_status);
3202: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
3203: RAISE FND_API.g_exc_unexpected_error;
3204: END IF;
3205: l_no_multi_assign_cat_set_tbl.EXTEND() ;

Line 3609: l_item_tbl EGO_ITEM_PUB.ITEM_TBL_TYPE;

3605:
3606: l_output_status inv_ebi_output_status;
3607: l_inventory_item_id NUMBER;
3608: l_organization_id NUMBER;
3609: l_item_tbl EGO_ITEM_PUB.ITEM_TBL_TYPE;
3610: x_item_tbl EGO_ITEM_PUB.ITEM_TBL_TYPE;
3611: l_role_grant_tbl EGO_ITEM_PUB.ROLE_GRANT_TBL_TYPE := EGO_ITEM_PUB.G_MISS_ROLE_GRANT_TBL;
3612: x_return_status VARCHAR2(3) := fnd_api.g_ret_sts_success;
3613: x_msg_count number;

Line 3610: x_item_tbl EGO_ITEM_PUB.ITEM_TBL_TYPE;

3606: l_output_status inv_ebi_output_status;
3607: l_inventory_item_id NUMBER;
3608: l_organization_id NUMBER;
3609: l_item_tbl EGO_ITEM_PUB.ITEM_TBL_TYPE;
3610: x_item_tbl EGO_ITEM_PUB.ITEM_TBL_TYPE;
3611: l_role_grant_tbl EGO_ITEM_PUB.ROLE_GRANT_TBL_TYPE := EGO_ITEM_PUB.G_MISS_ROLE_GRANT_TBL;
3612: x_return_status VARCHAR2(3) := fnd_api.g_ret_sts_success;
3613: x_msg_count number;
3614:

Line 3611: l_role_grant_tbl EGO_ITEM_PUB.ROLE_GRANT_TBL_TYPE := EGO_ITEM_PUB.G_MISS_ROLE_GRANT_TBL;

3607: l_inventory_item_id NUMBER;
3608: l_organization_id NUMBER;
3609: l_item_tbl EGO_ITEM_PUB.ITEM_TBL_TYPE;
3610: x_item_tbl EGO_ITEM_PUB.ITEM_TBL_TYPE;
3611: l_role_grant_tbl EGO_ITEM_PUB.ROLE_GRANT_TBL_TYPE := EGO_ITEM_PUB.G_MISS_ROLE_GRANT_TBL;
3612: x_return_status VARCHAR2(3) := fnd_api.g_ret_sts_success;
3613: x_msg_count number;
3614:
3615: CURSOR c_get_item_curr_data(

Line 3735: /*To skip lifecycle phases we need to invoke EGO_ITEM_PUB.Process_item_phase_and_status

3731: THEN
3732: l_new_lifecycle_id := fnd_api.g_miss_num;
3733:
3734: --Start of bug 11066016
3735: /*To skip lifecycle phases we need to invoke EGO_ITEM_PUB.Process_item_phase_and_status
3736: in loop till desired phase is reached.This api promotes or demotes lifecycle phases as per the
3737: Transaction type being passed*/
3738:
3739: l_allow_lcp_skip := INV_EBI_UTIL.get_config_param_value(

Line 3781: INV_EBI_UTIL.debug_line('STEP 120: START CALLING EGO_ITEM_PUB.PROCESS_ITEM_PHASE_AND_STATUS FOR PROMOTING PHASE ');

3777: cp_phase_id => l_curr_phase_id
3778: )
3779: LOOP
3780: IF(cur_next_phase.display_sequence < l_new_phase_seq) THEN
3781: INV_EBI_UTIL.debug_line('STEP 120: START CALLING EGO_ITEM_PUB.PROCESS_ITEM_PHASE_AND_STATUS FOR PROMOTING PHASE ');
3782: EGO_ITEM_PUB.Process_item_phase_and_status(
3783: p_api_version => 1.0
3784: ,p_commit => fnd_api.g_false
3785: ,p_init_msg_list => fnd_api.g_true

Line 3782: EGO_ITEM_PUB.Process_item_phase_and_status(

3778: )
3779: LOOP
3780: IF(cur_next_phase.display_sequence < l_new_phase_seq) THEN
3781: INV_EBI_UTIL.debug_line('STEP 120: START CALLING EGO_ITEM_PUB.PROCESS_ITEM_PHASE_AND_STATUS FOR PROMOTING PHASE ');
3782: EGO_ITEM_PUB.Process_item_phase_and_status(
3783: p_api_version => 1.0
3784: ,p_commit => fnd_api.g_false
3785: ,p_init_msg_list => fnd_api.g_true
3786: ,p_transaction_type => EGO_ITEM_PUB.G_TTYPE_PROMOTE

Line 3786: ,p_transaction_type => EGO_ITEM_PUB.G_TTYPE_PROMOTE

3782: EGO_ITEM_PUB.Process_item_phase_and_status(
3783: p_api_version => 1.0
3784: ,p_commit => fnd_api.g_false
3785: ,p_init_msg_list => fnd_api.g_true
3786: ,p_transaction_type => EGO_ITEM_PUB.G_TTYPE_PROMOTE
3787: ,p_inventory_item_id => p_update_item_tbl(i).item_obj.main_obj_type.inventory_item_id
3788: ,p_item_number => p_update_item_tbl(i).item_obj.main_obj_type.item_number
3789: ,p_organization_id => p_update_item_tbl(i).item_obj.main_obj_type.organization_id
3790: ,p_organization_code => p_update_item_tbl(i).item_obj.main_obj_type.organization_code

Line 3803: INV_EBI_UTIL.debug_line('STEP 130: END CALLING EGO_ITEM_PUB.PROCESS_ITEM_PHASE_AND_STATUS status is '|| x_out.output_status.return_status );

3799: ,x_return_status => x_out.output_status.return_status
3800: ,x_msg_count => x_out.output_status.msg_count
3801: ,x_msg_data => x_out.output_status.msg_data
3802: ) ;
3803: INV_EBI_UTIL.debug_line('STEP 130: END CALLING EGO_ITEM_PUB.PROCESS_ITEM_PHASE_AND_STATUS status is '|| x_out.output_status.return_status );
3804: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
3805: x_out.item_number := p_update_item_tbl(i).item_obj.main_obj_type.item_number;
3806: x_out.organization_code := p_update_item_tbl(i).item_obj.main_obj_type.organization_code;
3807: x_out.output_status.msg_data := x_out.output_status.msg_data || ' -> Item Number:' || p_update_item_tbl(i).item_obj.main_obj_type.item_number || ' -> Org Code: ' || p_update_item_tbl(i).item_obj.main_obj_type.organization_code;

Line 3823: INV_EBI_UTIL.debug_line('STEP 150: START CALLING EGO_ITEM_PUB.PROCESS_ITEM_PHASE_AND_STATUS FOR DEMOTING PHASE ');

3819: )
3820: LOOP
3821:
3822: IF(cur_priv_phase.display_sequence > l_new_phase_seq) THEN
3823: INV_EBI_UTIL.debug_line('STEP 150: START CALLING EGO_ITEM_PUB.PROCESS_ITEM_PHASE_AND_STATUS FOR DEMOTING PHASE ');
3824: EGO_ITEM_PUB.Process_item_phase_and_status(
3825: p_api_version => 1.0
3826: ,p_commit => fnd_api.g_false
3827: ,p_init_msg_list => fnd_api.g_true

Line 3824: EGO_ITEM_PUB.Process_item_phase_and_status(

3820: LOOP
3821:
3822: IF(cur_priv_phase.display_sequence > l_new_phase_seq) THEN
3823: INV_EBI_UTIL.debug_line('STEP 150: START CALLING EGO_ITEM_PUB.PROCESS_ITEM_PHASE_AND_STATUS FOR DEMOTING PHASE ');
3824: EGO_ITEM_PUB.Process_item_phase_and_status(
3825: p_api_version => 1.0
3826: ,p_commit => fnd_api.g_false
3827: ,p_init_msg_list => fnd_api.g_true
3828: ,p_transaction_type => EGO_ITEM_PUB.G_TTYPE_DEMOTE

Line 3828: ,p_transaction_type => EGO_ITEM_PUB.G_TTYPE_DEMOTE

3824: EGO_ITEM_PUB.Process_item_phase_and_status(
3825: p_api_version => 1.0
3826: ,p_commit => fnd_api.g_false
3827: ,p_init_msg_list => fnd_api.g_true
3828: ,p_transaction_type => EGO_ITEM_PUB.G_TTYPE_DEMOTE
3829: ,p_inventory_item_id => p_update_item_tbl(i).item_obj.main_obj_type.inventory_item_id
3830: ,p_item_number => p_update_item_tbl(i).item_obj.main_obj_type.item_number
3831: ,p_organization_id => p_update_item_tbl(i).item_obj.main_obj_type.organization_id
3832: ,p_organization_code => p_update_item_tbl(i).item_obj.main_obj_type.organization_code

Line 3845: INV_EBI_UTIL.debug_line('STEP 160: END CALLING EGO_ITEM_PUB.PROCESS_ITEM_PHASE_AND_STATUS status is '|| x_out.output_status.return_status );

3841: ,x_return_status => x_out.output_status.return_status
3842: ,x_msg_count => x_out.output_status.msg_count
3843: ,x_msg_data => x_out.output_status.msg_data
3844: ) ;
3845: INV_EBI_UTIL.debug_line('STEP 160: END CALLING EGO_ITEM_PUB.PROCESS_ITEM_PHASE_AND_STATUS status is '|| x_out.output_status.return_status );
3846: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
3847: x_out.item_number := p_update_item_tbl(i).item_obj.main_obj_type.item_number;
3848: x_out.organization_code := p_update_item_tbl(i).item_obj.main_obj_type.organization_code;
3849: x_out.output_status.msg_data := x_out.output_status.msg_data || ' -> Item Number:' || p_update_item_tbl(i).item_obj.main_obj_type.item_number || ' -> Org Code: ' || p_update_item_tbl(i).item_obj.main_obj_type.organization_code;

Line 3903: EGO_ITEM_PUB.PROCESS_ITEMS(

3899: INV_EBI_UTIL.debug_line('STEP 200: l_item_tbl(1).lifecycle_id ' || l_item_tbl(1).lifecycle_id);
3900: INV_EBI_UTIL.debug_line('STEP 210: l_item_tbl(1).current_phase_id ' || l_item_tbl(1).current_phase_id );
3901: INV_EBI_UTIL.debug_line('STEP 220: l_item_tbl(1).inventory_item_status_code ' || l_item_tbl(1).inventory_item_status_code);
3902: INV_EBI_UTIL.debug_line('STEP 230: l_item_tbl(1).item_catalog_group_id ' || l_item_tbl(1).item_catalog_group_id);
3903: EGO_ITEM_PUB.PROCESS_ITEMS(
3904: p_api_version => 1.0
3905: ,p_init_msg_list => fnd_api.g_true
3906: ,p_commit => fnd_api.g_false
3907: ,p_item_tbl => l_item_tbl

Line 3913: INV_EBI_UTIL.debug_line('STEP 240: END CALLING EGO_ITEM_PUB.PROCESS_ITEMS STATUS: '|| x_out.output_status.return_status);

3909: ,x_item_tbl => x_item_tbl
3910: ,x_return_status => x_out.output_status.return_status
3911: ,x_msg_count => x_out.output_status.msg_count
3912: );
3913: INV_EBI_UTIL.debug_line('STEP 240: END CALLING EGO_ITEM_PUB.PROCESS_ITEMS STATUS: '|| x_out.output_status.return_status);
3914: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
3915: x_out.item_number := p_update_item_tbl(i).item_obj.main_obj_type.item_number;
3916: x_out.organization_code := p_update_item_tbl(i).item_obj.main_obj_type.organization_code;
3917: x_out.output_status.msg_data := x_out.output_status.msg_data || ' -> Item Number:' || p_update_item_tbl(i).item_obj.main_obj_type.item_number || ' -> Org Code: ' || p_update_item_tbl(i).item_obj.main_obj_type.organization_code;