[Home] [Help]
1048:
1049: IF l_erecord_id IS NOT NULL
1050: THEN
1051: -- In case of error, autonomousCommit = TRUE
1052: QA_EDR_STANDARD.SEND_ACKN
1053: ( p_api_version => 1.0
1054: , p_init_msg_list => FND_API.G_FALSE
1055: , x_return_status => l_return_status
1056: , x_msg_count => l_msg_count
1062: , p_ackn_by => l_ackn_by
1063: , p_ackn_note => my_events.event_name||', '||my_events.event_key
1064: , p_autonomous_commit => FND_API.G_TRUE);
1065:
1066: FND_FILE.PUT_LINE(FND_FILE.LOG, 'After QA_EDR_STANDARD.SEND_ACKN msg='||l_msg_count);
1067: IF (NVL(l_return_status, FND_API.G_FALSE) <> FND_API.G_TRUE)
1068: AND (l_msg_count > 0)
1069: THEN
1070: RAISE SEND_ACKN_ERROR;
1389: -- For each destination component record that will be implemented
1390: FOR c_dest_comp_rec IN c_related_components
1391: LOOP
1392: -- set the values being updated into the global table to revert it
1393: -- when reverse standard bom is called .
1394: -- Here only common component sequence id is being updated to
1395: -- point to the new referenced component that is going to be implemented
1396: --
1397: g_common_rev_comps_cnt := g_common_rev_comps_cnt+1;
1607: -- ERES change begins
1608: bERES_Flag_for_BOM BOOLEAN := FALSE; -- bug 3741444.
1609: bERES_Flag_for_Routing BOOLEAN := FALSE; -- bug 3908563.
1610: l_eres_enabled VARCHAR2(10);
1611: l_child_record QA_EDR_STANDARD.ERECORD_ID_TBL_TYPE;
1612: l_event QA_EDR_STANDARD.ERES_EVENT_REC_TYPE;
1613: -- l_payload FND_WF_EVENT.PARAM_TABLE;
1614: -- ll_payload FND_WF_EVENT.PARAM_TABLE;
1615: l_msg_count NUMBER;
1608: bERES_Flag_for_BOM BOOLEAN := FALSE; -- bug 3741444.
1609: bERES_Flag_for_Routing BOOLEAN := FALSE; -- bug 3908563.
1610: l_eres_enabled VARCHAR2(10);
1611: l_child_record QA_EDR_STANDARD.ERECORD_ID_TBL_TYPE;
1612: l_event QA_EDR_STANDARD.ERES_EVENT_REC_TYPE;
1613: -- l_payload FND_WF_EVENT.PARAM_TABLE;
1614: -- ll_payload FND_WF_EVENT.PARAM_TABLE;
1615: l_msg_count NUMBER;
1616: l_msg_data VARCHAR2(2000);
3534: -- If the call fails or returns and error, the exception is not catched.
3535: l_eres_enabled := FND_PROFILE.VALUE('EDR_ERES_ENABLED');
3536: IF ( NVL( l_eres_enabled, 'N') = 'Y')
3537: THEN
3538: QA_EDR_STANDARD.GET_ERECORD_ID
3539: ( p_api_version => 1.0
3540: , p_init_msg_list => FND_API.G_TRUE
3541: , x_return_status => l_return_status
3542: , x_msg_count => l_msg_count
3550: -- there is either an ECO implement event,
3551: -- or an ECO Create event created before.
3552: IF (l_parent_record_id IS NULL)
3553: THEN
3554: QA_EDR_STANDARD.GET_ERECORD_ID
3555: ( p_api_version => 1.0
3556: , p_init_msg_list => FND_API.G_TRUE
3557: , x_return_status => l_return_status
3558: , x_msg_count => l_msg_count
3757: , item.last_updated_by
3758: , item.creation_date
3759: , item.created_by);
3760:
3761: QA_EDR_STANDARD.RAISE_ERES_EVENT
3762: ( p_api_version => 1.0
3763: , p_init_msg_list => FND_API.G_FALSE
3764: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
3765: , x_return_status => l_return_status
5433: operation_sequence_id
5434: , resource_seq_num
5435: , resource_id
5436: , activity_id
5437: , standard_rate_flag
5438: , assigned_units
5439: , usage_rate_or_amount
5440: , usage_rate_or_amount_inverse
5441: , basis_type
5478: chng_operation_rec.operation_sequence_id
5479: , resource_seq_num
5480: , resource_id
5481: , activity_id
5482: , standard_rate_flag
5483: , assigned_units
5484: , usage_rate_or_amount
5485: , usage_rate_or_amount_inverse
5486: , basis_type
5554: , substitute_group_num
5555: , resource_id
5556: , replacement_group_num
5557: , activity_id
5558: , standard_rate_flag
5559: , assigned_units
5560: , usage_rate_or_amount
5561: , usage_rate_or_amount_inverse
5562: , basis_type
5599: , substitute_group_num
5600: , resource_id
5601: , replacement_group_num
5602: , activity_id
5603: , standard_rate_flag
5604: , assigned_units
5605: , usage_rate_or_amount
5606: , usage_rate_or_amount_inverse
5607: , basis_type
5873: last_updated_by ,
5874: creation_date ,
5875: created_by ,
5876: last_update_login ,
5877: standard_operation_id ,
5878: department_id ,
5879: operation_lead_time_percent ,
5880: minimum_transfer_quantity ,
5881: count_point_type ,
5938: last_updated_by ,
5939: creation_date ,
5940: created_by ,
5941: last_update_login ,
5942: standard_operation_id ,
5943: department_id ,
5944: operation_lead_time_percent ,
5945: minimum_transfer_quantity ,
5946: count_point_type ,
7745: -- l_event.payload := l_payload;
7746: l_event.erecord_id := l_erecord_id;
7747: l_event.event_status := l_event_status;
7748:
7749: QA_EDR_STANDARD.RAISE_ERES_EVENT
7750: ( p_api_version => 1.0
7751: , p_init_msg_list => FND_API.G_FALSE
7752: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
7753: , x_return_status => l_return_status
7880: -- l_event.payload := l_payload;
7881: l_event.erecord_id := l_erecord_id;
7882: l_event.event_status := l_event_status;
7883:
7884: QA_EDR_STANDARD.RAISE_ERES_EVENT
7885: ( p_api_version => 1.0
7886: , p_init_msg_list => FND_API.G_FALSE
7887: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
7888: , x_return_status => l_return_status
8917: end if;
8918:
8919: end;
8920:
8921: Procedure reverse_standard_bom(
8922: revised_item in eng_revised_items.revised_item_sequence_id%type,
8923: userid in number, -- user id
8924: reqstid in number, -- concurrent request id
8925: appid in number, -- application id
8946:
8947: return_status := 0;
8948: return_message:= NULL;
8949:
8950: -- Reverse standard bom is called from ENCACN.opp,
8951: -- If bill sequence id is null, p_bill_sequence_id = -1
8952: IF p_bill_sequence_id <> -1 THEN
8953: -- Delete the related bom_reference_designators records
8954: -- those records are still expected to show on the window after implementation