APPS.WIP_JOB_DTLS_SUBSTITUTIONS dependencies on WIP_UTILITIES

Line 2847: wip_utilities.update_serial(p_serial_number => l_serRec.serial_number,

2843: return;
2844: END IF;
2845:
2846: for l_serRec in ser_info(p_group_id, p_wip_entity_id, p_organization_id) loop
2847: wip_utilities.update_serial(p_serial_number => l_serRec.serial_number,
2848: p_organization_id => l_serRec.organization_id,
2849: p_inventory_item_id => l_serRec.primary_item_id,
2850: p_wip_entity_id => p_wip_entity_id,
2851: p_operation_seq_num => null,

Line 2856: wip_utilities.get_message_stack(p_msg => x_err_msg);

2852: p_intraoperation_step_type => null,
2853: x_return_status => x_return_status);
2854: if(x_return_status <> fnd_api.g_ret_sts_success) then
2855: rollback to wipjdstb10;
2856: wip_utilities.get_message_stack(p_msg => x_err_msg);
2857: exit;
2858: end if;
2859: end loop;
2860: exception

Line 2908: wip_utilities.update_serial(p_serial_number => l_serRec.serial_number_new,

2904: return;
2905: END IF;
2906:
2907: for l_serRec in ser_info(p_group_id, p_wip_entity_id, p_organization_id) loop
2908: wip_utilities.update_serial(p_serial_number => l_serRec.serial_number_new,
2909: p_organization_id => l_serRec.organization_id,
2910: p_inventory_item_id => l_serRec.primary_item_id,
2911: p_wip_entity_id => p_wip_entity_id,
2912: p_operation_seq_num => null,

Line 2917: wip_utilities.get_message_stack(p_msg => x_err_msg);

2913: p_intraoperation_step_type => null,
2914: x_return_status => x_return_status);
2915: if(x_return_status <> fnd_api.g_ret_sts_success) then
2916: rollback to wipjdstb20;
2917: wip_utilities.get_message_stack(p_msg => x_err_msg);
2918: exit;
2919: end if;
2920:
2921: wip_utilities.update_serial(p_serial_number => l_serRec.serial_number_old,

Line 2921: wip_utilities.update_serial(p_serial_number => l_serRec.serial_number_old,

2917: wip_utilities.get_message_stack(p_msg => x_err_msg);
2918: exit;
2919: end if;
2920:
2921: wip_utilities.update_serial(p_serial_number => l_serRec.serial_number_old,
2922: p_organization_id => l_serRec.organization_id,
2923: p_inventory_item_id => l_serRec.primary_item_id,
2924: p_wip_entity_id => null,
2925: p_operation_seq_num => null,

Line 2929: wip_utilities.get_message_stack(p_msg => x_err_msg);

2925: p_operation_seq_num => null,
2926: p_intraoperation_step_type => null,
2927: x_return_status => x_return_status);
2928: if(x_return_status <> fnd_api.g_ret_sts_success) then
2929: wip_utilities.get_message_stack(p_msg => x_err_msg);
2930: exit;
2931: end if;
2932:
2933: end loop;

Line 2981: wip_utilities.update_serial(p_serial_number => l_serRec.serial_number,

2977: return;
2978: END IF;
2979:
2980: for l_serRec in ser_info(p_group_id, p_wip_entity_id, p_organization_id) loop
2981: wip_utilities.update_serial(p_serial_number => l_serRec.serial_number,
2982: p_organization_id => l_serRec.organization_id,
2983: p_inventory_item_id => l_serRec.primary_item_id,
2984: p_wip_entity_id => null,
2985: p_operation_seq_num => null,

Line 2990: wip_utilities.get_message_stack(p_msg => x_err_msg);

2986: p_intraoperation_step_type => null,
2987: x_return_status => x_return_status);
2988: if(x_return_status <> fnd_api.g_ret_sts_success) then
2989: rollback to wipjdstb30;
2990: wip_utilities.get_message_stack(p_msg => x_err_msg);
2991: exit;
2992: end if;
2993: end loop;
2994: exception

Line 3050: wip_utilities.generate_serials(p_item_id => l_primary_item_id,

3046:
3047: --if the user did not provide enough serial numbers
3048: if(l_serialization_start_op is not null and
3049: l_start_quantity > l_rowCount) then
3050: wip_utilities.generate_serials(p_item_id => l_primary_item_id,
3051: p_org_id => p_organization_id,
3052: p_qty => to_number(l_start_quantity - l_rowCount),
3053: p_wip_entity_id => p_wip_entity_id,
3054: p_revision => null,