1067: INV_EBI_UTIL.setup();
1068:
1069: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_PUB.get_eco_list_attr');
1070: INV_EBI_UTIL.debug_line( ' **************** Apps Context Details ****************' );
1071: INV_EBI_UTIL.debug_line(' User Id: ' || FND_GLOBAL.USER_ID || '; Responsibility Application id: ' ||
1072: FND_GLOBAL.RESP_APPL_ID || '; Responsibility Id: ' || FND_GLOBAL.RESP_ID ||
1073: '; Security Group id: '|| FND_GLOBAL.SECURITY_GROUP_ID ||'; User Lang: '|| USERENV('LANG') );
1074: INV_EBI_UTIL.debug_line( ' **************** End of Apps Context ****************' );
1075:
1068:
1069: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_PUB.get_eco_list_attr');
1070: INV_EBI_UTIL.debug_line( ' **************** Apps Context Details ****************' );
1071: INV_EBI_UTIL.debug_line(' User Id: ' || FND_GLOBAL.USER_ID || '; Responsibility Application id: ' ||
1072: FND_GLOBAL.RESP_APPL_ID || '; Responsibility Id: ' || FND_GLOBAL.RESP_ID ||
1073: '; Security Group id: '|| FND_GLOBAL.SECURITY_GROUP_ID ||'; User Lang: '|| USERENV('LANG') );
1074: INV_EBI_UTIL.debug_line( ' **************** End of Apps Context ****************' );
1075:
1076: --Start of Bug 13874263
1069: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_PUB.get_eco_list_attr');
1070: INV_EBI_UTIL.debug_line( ' **************** Apps Context Details ****************' );
1071: INV_EBI_UTIL.debug_line(' User Id: ' || FND_GLOBAL.USER_ID || '; Responsibility Application id: ' ||
1072: FND_GLOBAL.RESP_APPL_ID || '; Responsibility Id: ' || FND_GLOBAL.RESP_ID ||
1073: '; Security Group id: '|| FND_GLOBAL.SECURITY_GROUP_ID ||'; User Lang: '|| USERENV('LANG') );
1074: INV_EBI_UTIL.debug_line( ' **************** End of Apps Context ****************' );
1075:
1076: --Start of Bug 13874263
1077: IF l_name_val_list.name_value_table IS NOT NULL THEN
1396: implementation_date = sysdate,
1397: effectivity_date = sysdate,
1398: creation_date = sysdate,
1399: last_update_date = sysdate,
1400: last_updated_by = DECODE(last_updated_by, NULL, fnd_global.user_id,last_updated_by),
1401: created_by = DECODE(last_updated_by, NULL, fnd_global.user_id,last_updated_by)
1402: WHERE
1403: inventory_item_id = l_item_output_obj.inventory_item_id AND
1404: organization_id = l_item_output_obj.organization_id AND
1397: effectivity_date = sysdate,
1398: creation_date = sysdate,
1399: last_update_date = sysdate,
1400: last_updated_by = DECODE(last_updated_by, NULL, fnd_global.user_id,last_updated_by),
1401: created_by = DECODE(last_updated_by, NULL, fnd_global.user_id,last_updated_by)
1402: WHERE
1403: inventory_item_id = l_item_output_obj.inventory_item_id AND
1404: organization_id = l_item_output_obj.organization_id AND
1405: revision = l_revision;
2254: ERROR_HANDLER.Initialize;
2255: FND_MSG_PUB.initialize;
2256: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_PUB.process_change_order_list_core');
2257: INV_EBI_UTIL.debug_line( ' **************** Apps Context Details ****************' );
2258: INV_EBI_UTIL.debug_line(' User Id: ' || FND_GLOBAL.USER_ID || '; Responsibility Application id: ' ||
2259: FND_GLOBAL.RESP_APPL_ID || '; Responsibility Id: ' || FND_GLOBAL.RESP_ID ||
2260: '; Security Group id: '|| FND_GLOBAL.SECURITY_GROUP_ID ||'; User Lang: '|| USERENV('LANG') );
2261: INV_EBI_UTIL.debug_line( ' **************** End of Apps Context ****************' );
2262:
2255: FND_MSG_PUB.initialize;
2256: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_PUB.process_change_order_list_core');
2257: INV_EBI_UTIL.debug_line( ' **************** Apps Context Details ****************' );
2258: INV_EBI_UTIL.debug_line(' User Id: ' || FND_GLOBAL.USER_ID || '; Responsibility Application id: ' ||
2259: FND_GLOBAL.RESP_APPL_ID || '; Responsibility Id: ' || FND_GLOBAL.RESP_ID ||
2260: '; Security Group id: '|| FND_GLOBAL.SECURITY_GROUP_ID ||'; User Lang: '|| USERENV('LANG') );
2261: INV_EBI_UTIL.debug_line( ' **************** End of Apps Context ****************' );
2262:
2263: x_return_status := FND_API.G_RET_STS_SUCCESS ;
2256: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_PUB.process_change_order_list_core');
2257: INV_EBI_UTIL.debug_line( ' **************** Apps Context Details ****************' );
2258: INV_EBI_UTIL.debug_line(' User Id: ' || FND_GLOBAL.USER_ID || '; Responsibility Application id: ' ||
2259: FND_GLOBAL.RESP_APPL_ID || '; Responsibility Id: ' || FND_GLOBAL.RESP_ID ||
2260: '; Security Group id: '|| FND_GLOBAL.SECURITY_GROUP_ID ||'; User Lang: '|| USERENV('LANG') );
2261: INV_EBI_UTIL.debug_line( ' **************** End of Apps Context ****************' );
2262:
2263: x_return_status := FND_API.G_RET_STS_SUCCESS ;
2264: x_out := inv_ebi_eco_output_obj_tbl();