[Home] [Help]
976:
977: IF l_erecord_id IS NOT NULL
978: THEN
979: -- In case of error, autonomousCommit = TRUE
980: QA_EDR_STANDARD.SEND_ACKN
981: ( p_api_version => 1.0
982: , p_init_msg_list => FND_API.G_FALSE
983: , x_return_status => l_return_status
984: , x_msg_count => l_msg_count
990: , p_ackn_by => l_ackn_by
991: , p_ackn_note => my_events.event_name||', '||my_events.event_key
992: , p_autonomous_commit => FND_API.G_TRUE);
993:
994: FND_FILE.PUT_LINE(FND_FILE.LOG, 'After QA_EDR_STANDARD.SEND_ACKN msg='||l_msg_count);
995: IF (NVL(l_return_status, FND_API.G_FALSE) <> FND_API.G_TRUE)
996: AND (l_msg_count > 0)
997: THEN
998: RAISE SEND_ACKN_ERROR;
1317: -- For each destination component record that will be implemented
1318: FOR c_dest_comp_rec IN c_related_components
1319: LOOP
1320: -- set the values being updated into the global table to revert it
1321: -- when reverse standard bom is called .
1322: -- Here only common component sequence id is being updated to
1323: -- point to the new referenced component that is going to be implemented
1324: --
1325: g_common_rev_comps_cnt := g_common_rev_comps_cnt+1;
1535: -- ERES change begins
1536: bERES_Flag_for_BOM BOOLEAN := FALSE; -- bug 3741444.
1537: bERES_Flag_for_Routing BOOLEAN := FALSE; -- bug 3908563.
1538: l_eres_enabled VARCHAR2(10);
1539: l_child_record QA_EDR_STANDARD.ERECORD_ID_TBL_TYPE;
1540: l_event QA_EDR_STANDARD.ERES_EVENT_REC_TYPE;
1541: -- l_payload FND_WF_EVENT.PARAM_TABLE;
1542: -- ll_payload FND_WF_EVENT.PARAM_TABLE;
1543: l_msg_count NUMBER;
1536: bERES_Flag_for_BOM BOOLEAN := FALSE; -- bug 3741444.
1537: bERES_Flag_for_Routing BOOLEAN := FALSE; -- bug 3908563.
1538: l_eres_enabled VARCHAR2(10);
1539: l_child_record QA_EDR_STANDARD.ERECORD_ID_TBL_TYPE;
1540: l_event QA_EDR_STANDARD.ERES_EVENT_REC_TYPE;
1541: -- l_payload FND_WF_EVENT.PARAM_TABLE;
1542: -- ll_payload FND_WF_EVENT.PARAM_TABLE;
1543: l_msg_count NUMBER;
1544: l_msg_data VARCHAR2(2000);
3290: -- If the call fails or returns and error, the exception is not catched.
3291: l_eres_enabled := FND_PROFILE.VALUE('EDR_ERES_ENABLED');
3292: IF ( NVL( l_eres_enabled, 'N') = 'Y')
3293: THEN
3294: QA_EDR_STANDARD.GET_ERECORD_ID
3295: ( p_api_version => 1.0
3296: , p_init_msg_list => FND_API.G_TRUE
3297: , x_return_status => l_return_status
3298: , x_msg_count => l_msg_count
3306: -- there is either an ECO implement event,
3307: -- or an ECO Create event created before.
3308: IF (l_parent_record_id IS NULL)
3309: THEN
3310: QA_EDR_STANDARD.GET_ERECORD_ID
3311: ( p_api_version => 1.0
3312: , p_init_msg_list => FND_API.G_TRUE
3313: , x_return_status => l_return_status
3314: , x_msg_count => l_msg_count
3513: , item.last_updated_by
3514: , item.creation_date
3515: , item.created_by);
3516:
3517: QA_EDR_STANDARD.RAISE_ERES_EVENT
3518: ( p_api_version => 1.0
3519: , p_init_msg_list => FND_API.G_FALSE
3520: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
3521: , x_return_status => l_return_status
5169: operation_sequence_id
5170: , resource_seq_num
5171: , resource_id
5172: , activity_id
5173: , standard_rate_flag
5174: , assigned_units
5175: , usage_rate_or_amount
5176: , usage_rate_or_amount_inverse
5177: , basis_type
5214: chng_operation_rec.operation_sequence_id
5215: , resource_seq_num
5216: , resource_id
5217: , activity_id
5218: , standard_rate_flag
5219: , assigned_units
5220: , usage_rate_or_amount
5221: , usage_rate_or_amount_inverse
5222: , basis_type
5290: , substitute_group_num
5291: , resource_id
5292: , replacement_group_num
5293: , activity_id
5294: , standard_rate_flag
5295: , assigned_units
5296: , usage_rate_or_amount
5297: , usage_rate_or_amount_inverse
5298: , basis_type
5335: , substitute_group_num
5336: , resource_id
5337: , replacement_group_num
5338: , activity_id
5339: , standard_rate_flag
5340: , assigned_units
5341: , usage_rate_or_amount
5342: , usage_rate_or_amount_inverse
5343: , basis_type
5609: last_updated_by ,
5610: creation_date ,
5611: created_by ,
5612: last_update_login ,
5613: standard_operation_id ,
5614: department_id ,
5615: operation_lead_time_percent ,
5616: minimum_transfer_quantity ,
5617: count_point_type ,
5674: last_updated_by ,
5675: creation_date ,
5676: created_by ,
5677: last_update_login ,
5678: standard_operation_id ,
5679: department_id ,
5680: operation_lead_time_percent ,
5681: minimum_transfer_quantity ,
5682: count_point_type ,
7422: -- l_event.payload := l_payload;
7423: l_event.erecord_id := l_erecord_id;
7424: l_event.event_status := l_event_status;
7425:
7426: QA_EDR_STANDARD.RAISE_ERES_EVENT
7427: ( p_api_version => 1.0
7428: , p_init_msg_list => FND_API.G_FALSE
7429: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
7430: , x_return_status => l_return_status
7557: -- l_event.payload := l_payload;
7558: l_event.erecord_id := l_erecord_id;
7559: l_event.event_status := l_event_status;
7560:
7561: QA_EDR_STANDARD.RAISE_ERES_EVENT
7562: ( p_api_version => 1.0
7563: , p_init_msg_list => FND_API.G_FALSE
7564: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
7565: , x_return_status => l_return_status
8572: translate2(msg_qty) := 0;
8573: end if;
8574:
8575: end;
8576: Procedure reverse_standard_bom(
8577: revised_item in eng_revised_items.revised_item_sequence_id%type,
8578: userid in number, -- user id
8579: reqstid in number, -- concurrent request id
8580: appid in number, -- application id
8601:
8602: return_status := 0;
8603: return_message:= NULL;
8604:
8605: -- Reverse standard bom is called from ENCACN.opp,
8606: -- If bill sequence id is null, p_bill_sequence_id = -1
8607: IF p_bill_sequence_id <> -1 THEN
8608: -- Delete the related bom_reference_designators records
8609: -- those records are still expected to show on the window after implementation