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.ENGECOBO dependencies on ENG_PROPAGATION_LOG_UTIL

Line 299: AND ecpm.revised_line_type = Eng_Propagation_Log_Util.G_REV_LINE_ATCH_CHG

295: ))
296: AND NOT EXISTS (SELECT 1 FROM eng_change_propagation_maps ecpm
297: WHERE ecpm.change_id = p_change_id
298: AND ecpm.local_organization_id = p_local_organization_id
299: AND ecpm.revised_line_type = Eng_Propagation_Log_Util.G_REV_LINE_ATCH_CHG
300: AND ecpm.revised_line_id1 = eac.change_document_id
301: AND ecpm.entity_action_status = 3);
302:
303: CURSOR c_attachment_details(cp_attached_document_id IN NUMBER

Line 326: Eng_Propagation_log_Util.Debug_Log(G_LOG_PROC, 'Propagate_Attach_Lines.BEGIN');

322:
323: l_attachment_details_rec c_attachment_details%ROWTYPE;
324:
325: BEGIN
326: Eng_Propagation_log_Util.Debug_Log(G_LOG_PROC, 'Propagate_Attach_Lines.BEGIN');
327: Eng_Propagation_log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_change_id '||p_change_id);
328: Eng_Propagation_log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_revised_item_sequence_id'||p_revised_item_sequence_id );
329:
330: -- get the local change id

Line 327: Eng_Propagation_log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_change_id '||p_change_id);

323: l_attachment_details_rec c_attachment_details%ROWTYPE;
324:
325: BEGIN
326: Eng_Propagation_log_Util.Debug_Log(G_LOG_PROC, 'Propagate_Attach_Lines.BEGIN');
327: Eng_Propagation_log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_change_id '||p_change_id);
328: Eng_Propagation_log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_revised_item_sequence_id'||p_revised_item_sequence_id );
329:
330: -- get the local change id
331: Propagated_Local_Change(

Line 328: Eng_Propagation_log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_revised_item_sequence_id'||p_revised_item_sequence_id );

324:
325: BEGIN
326: Eng_Propagation_log_Util.Debug_Log(G_LOG_PROC, 'Propagate_Attach_Lines.BEGIN');
327: Eng_Propagation_log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_change_id '||p_change_id);
328: Eng_Propagation_log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_revised_item_sequence_id'||p_revised_item_sequence_id );
329:
330: -- get the local change id
331: Propagated_Local_Change(
332: p_change_id => p_change_id

Line 338: Eng_Propagation_log_Util.Debug_Log(G_LOG_STMT, 'Value: l_local_change_id'||l_local_change_id);

334: , x_local_change_id => l_local_change_id);
335:
336: x_return_status := FND_API.G_RET_STS_SUCCESS;
337:
338: Eng_Propagation_log_Util.Debug_Log(G_LOG_STMT, 'Value: l_local_change_id'||l_local_change_id);
339: IF l_local_change_id IS null
340: THEN
341: Eng_Propagation_log_Util.Debug_Log(G_LOG_STMT, 'Value: l_local_change_id'||p_revised_item_unexp_rec.change_id);
342: l_local_change_id := p_revised_item_unexp_rec.change_id;

Line 341: Eng_Propagation_log_Util.Debug_Log(G_LOG_STMT, 'Value: l_local_change_id'||p_revised_item_unexp_rec.change_id);

337:
338: Eng_Propagation_log_Util.Debug_Log(G_LOG_STMT, 'Value: l_local_change_id'||l_local_change_id);
339: IF l_local_change_id IS null
340: THEN
341: Eng_Propagation_log_Util.Debug_Log(G_LOG_STMT, 'Value: l_local_change_id'||p_revised_item_unexp_rec.change_id);
342: l_local_change_id := p_revised_item_unexp_rec.change_id;
343: END IF;
344: Eng_Propagation_log_Util.Debug_Log(G_LOG_STMT, 'Value: p_revised_item_unexp_rec.revised_item_sequence_id'|| p_revised_item_unexp_rec.revised_item_sequence_id);
345:

Line 344: Eng_Propagation_log_Util.Debug_Log(G_LOG_STMT, 'Value: p_revised_item_unexp_rec.revised_item_sequence_id'|| p_revised_item_unexp_rec.revised_item_sequence_id);

340: THEN
341: Eng_Propagation_log_Util.Debug_Log(G_LOG_STMT, 'Value: l_local_change_id'||p_revised_item_unexp_rec.change_id);
342: l_local_change_id := p_revised_item_unexp_rec.change_id;
343: END IF;
344: Eng_Propagation_log_Util.Debug_Log(G_LOG_STMT, 'Value: p_revised_item_unexp_rec.revised_item_sequence_id'|| p_revised_item_unexp_rec.revised_item_sequence_id);
345:
346: IF (l_local_change_id IS NOT NULL AND p_revised_item_unexp_rec.revised_item_sequence_id IS NOT NULL)
347: THEN
348: FOR ac in c_attachment_changes (p_revised_item_sequence_id) /* loop 2*/

Line 357: Eng_Propagation_log_Util.Debug_Log(G_LOG_STMT, 'Value: p_revised_item_unexp_rec.new_item_revision_id'|| p_revised_item_unexp_rec.new_item_revision_id);

353: l_return_status := FND_API.G_RET_STS_SUCCESS;
354: -- set the pk3 value if the attachment belongs to item revision
355: IF (ac.entity_name = 'MTL_ITEM_REVISIONS')
356: THEN
357: Eng_Propagation_log_Util.Debug_Log(G_LOG_STMT, 'Value: p_revised_item_unexp_rec.new_item_revision_id'|| p_revised_item_unexp_rec.new_item_revision_id);
358: Eng_Propagation_log_Util.Debug_Log(G_LOG_STMT, 'Value: p_revised_item_unexp_rec.CURRENT_item_revision_id'|| p_revised_item_unexp_rec.CURRENT_item_revision_id);
359:
360: -- Bug : 5355614
361: -- For item attachment changes with new revisions we need to get the correct revision id (eng_attachment_changes.pk3_value)

Line 358: Eng_Propagation_log_Util.Debug_Log(G_LOG_STMT, 'Value: p_revised_item_unexp_rec.CURRENT_item_revision_id'|| p_revised_item_unexp_rec.CURRENT_item_revision_id);

354: -- set the pk3 value if the attachment belongs to item revision
355: IF (ac.entity_name = 'MTL_ITEM_REVISIONS')
356: THEN
357: Eng_Propagation_log_Util.Debug_Log(G_LOG_STMT, 'Value: p_revised_item_unexp_rec.new_item_revision_id'|| p_revised_item_unexp_rec.new_item_revision_id);
358: Eng_Propagation_log_Util.Debug_Log(G_LOG_STMT, 'Value: p_revised_item_unexp_rec.CURRENT_item_revision_id'|| p_revised_item_unexp_rec.CURRENT_item_revision_id);
359:
360: -- Bug : 5355614
361: -- For item attachment changes with new revisions we need to get the correct revision id (eng_attachment_changes.pk3_value)
362: BEGIN

Line 393: Eng_Propagation_log_Util.Debug_Log(G_LOG_STMT, 'Value: ac.action_type:'||ac.action_type);

389: , p_local_pk2_value => ac.pk2_value
390: , p_local_pk3_value => l_pk3_value
391: , p_global_document_id => l_temp_document_id
392: , x_att_status => l_local_att_status); -- Bug 3599366
393: Eng_Propagation_log_Util.Debug_Log(G_LOG_STMT, 'Value: ac.action_type:'||ac.action_type);
394: Eng_Propagation_log_Util.Debug_Log(G_LOG_STMT, 'Value: l_local_attachment_id:'||l_local_attachment_id);
395: Eng_Propagation_log_Util.Debug_Log(G_LOG_STMT, 'Value: ac.change_document_id:'||ac.change_document_id);
396: IF (ac.action_type = 'ATTACH' OR l_local_attachment_id <> -1)
397: THEN

Line 394: Eng_Propagation_log_Util.Debug_Log(G_LOG_STMT, 'Value: l_local_attachment_id:'||l_local_attachment_id);

390: , p_local_pk3_value => l_pk3_value
391: , p_global_document_id => l_temp_document_id
392: , x_att_status => l_local_att_status); -- Bug 3599366
393: Eng_Propagation_log_Util.Debug_Log(G_LOG_STMT, 'Value: ac.action_type:'||ac.action_type);
394: Eng_Propagation_log_Util.Debug_Log(G_LOG_STMT, 'Value: l_local_attachment_id:'||l_local_attachment_id);
395: Eng_Propagation_log_Util.Debug_Log(G_LOG_STMT, 'Value: ac.change_document_id:'||ac.change_document_id);
396: IF (ac.action_type = 'ATTACH' OR l_local_attachment_id <> -1)
397: THEN
398: FOR cad IN c_attachment_details(l_local_attachment_id, ac.action_type, ac.change_document_id)

Line 395: Eng_Propagation_log_Util.Debug_Log(G_LOG_STMT, 'Value: ac.change_document_id:'||ac.change_document_id);

391: , p_global_document_id => l_temp_document_id
392: , x_att_status => l_local_att_status); -- Bug 3599366
393: Eng_Propagation_log_Util.Debug_Log(G_LOG_STMT, 'Value: ac.action_type:'||ac.action_type);
394: Eng_Propagation_log_Util.Debug_Log(G_LOG_STMT, 'Value: l_local_attachment_id:'||l_local_attachment_id);
395: Eng_Propagation_log_Util.Debug_Log(G_LOG_STMT, 'Value: ac.change_document_id:'||ac.change_document_id);
396: IF (ac.action_type = 'ATTACH' OR l_local_attachment_id <> -1)
397: THEN
398: FOR cad IN c_attachment_details(l_local_attachment_id, ac.action_type, ac.change_document_id)
399: LOOP

Line 400: Eng_Propagation_log_Util.Debug_Log(G_LOG_STMT, 'Inserting into eng_attachment_changes..');

396: IF (ac.action_type = 'ATTACH' OR l_local_attachment_id <> -1)
397: THEN
398: FOR cad IN c_attachment_details(l_local_attachment_id, ac.action_type, ac.change_document_id)
399: LOOP
400: Eng_Propagation_log_Util.Debug_Log(G_LOG_STMT, 'Inserting into eng_attachment_changes..');
401: SELECT ENG_ATTACHMENT_CHANGES_S.nextval
402: INTO l_change_document_id
403: FROM dual;
404:

Line 478: Eng_Propagation_log_Util.Debug_Log(G_LOG_STMT, 'Could not process attachment_changes..Add Error');

474: , cad.DATATYPE_ID
475: );
476: END LOOP;
477: ELSE
478: Eng_Propagation_log_Util.Debug_Log(G_LOG_STMT, 'Could not process attachment_changes..Add Error');
479: Eng_Propagation_Log_Util.add_entity_map(
480: p_change_id => p_change_id
481: , p_revised_item_sequence_id => p_revised_item_sequence_id
482: , p_revised_line_type => Eng_Propagation_Log_Util.G_REV_LINE_ATCH_CHG

Line 479: Eng_Propagation_Log_Util.add_entity_map(

475: );
476: END LOOP;
477: ELSE
478: Eng_Propagation_log_Util.Debug_Log(G_LOG_STMT, 'Could not process attachment_changes..Add Error');
479: Eng_Propagation_Log_Util.add_entity_map(
480: p_change_id => p_change_id
481: , p_revised_item_sequence_id => p_revised_item_sequence_id
482: , p_revised_line_type => Eng_Propagation_Log_Util.G_REV_LINE_ATCH_CHG
483: , p_revised_line_id1 => ac.CHANGE_DOCUMENT_ID

Line 482: , p_revised_line_type => Eng_Propagation_Log_Util.G_REV_LINE_ATCH_CHG

478: Eng_Propagation_log_Util.Debug_Log(G_LOG_STMT, 'Could not process attachment_changes..Add Error');
479: Eng_Propagation_Log_Util.add_entity_map(
480: p_change_id => p_change_id
481: , p_revised_item_sequence_id => p_revised_item_sequence_id
482: , p_revised_line_type => Eng_Propagation_Log_Util.G_REV_LINE_ATCH_CHG
483: , p_revised_line_id1 => ac.CHANGE_DOCUMENT_ID
484: , p_local_organization_id => p_local_organization_id
485: , p_entity_name => Eng_Propagation_Log_Util.G_ENTITY_REVISED_LINE
486: , p_entity_action_status => Eng_Propagation_Log_Util.G_PRP_PRC_STS_ERROR

Line 485: , p_entity_name => Eng_Propagation_Log_Util.G_ENTITY_REVISED_LINE

481: , p_revised_item_sequence_id => p_revised_item_sequence_id
482: , p_revised_line_type => Eng_Propagation_Log_Util.G_REV_LINE_ATCH_CHG
483: , p_revised_line_id1 => ac.CHANGE_DOCUMENT_ID
484: , p_local_organization_id => p_local_organization_id
485: , p_entity_name => Eng_Propagation_Log_Util.G_ENTITY_REVISED_LINE
486: , p_entity_action_status => Eng_Propagation_Log_Util.G_PRP_PRC_STS_ERROR
487: , p_bo_entity_identifier => 'ATCH'--Eco_Error_Handler.G_ATCH_LEVEL
488: );
489: l_return_status := FND_API.G_RET_STS_ERROR;

Line 486: , p_entity_action_status => Eng_Propagation_Log_Util.G_PRP_PRC_STS_ERROR

482: , p_revised_line_type => Eng_Propagation_Log_Util.G_REV_LINE_ATCH_CHG
483: , p_revised_line_id1 => ac.CHANGE_DOCUMENT_ID
484: , p_local_organization_id => p_local_organization_id
485: , p_entity_name => Eng_Propagation_Log_Util.G_ENTITY_REVISED_LINE
486: , p_entity_action_status => Eng_Propagation_Log_Util.G_PRP_PRC_STS_ERROR
487: , p_bo_entity_identifier => 'ATCH'--Eco_Error_Handler.G_ATCH_LEVEL
488: );
489: l_return_status := FND_API.G_RET_STS_ERROR;
490: -- this case should not be reached as validation of attachments has already been done.

Line 493: Eng_Propagation_log_Util.Debug_Log(G_LOG_STMT, 'Processed attachment change with l_return_status'|| l_return_status);

489: l_return_status := FND_API.G_RET_STS_ERROR;
490: -- this case should not be reached as validation of attachments has already been done.
491: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Attachment does not exist');
492: END IF;
493: Eng_Propagation_log_Util.Debug_Log(G_LOG_STMT, 'Processed attachment change with l_return_status'|| l_return_status);
494: IF l_return_status = FND_API.G_RET_STS_SUCCESS
495: THEN
496: Eng_Propagation_Log_Util.add_entity_map(
497: p_change_id => p_change_id

Line 496: Eng_Propagation_Log_Util.add_entity_map(

492: END IF;
493: Eng_Propagation_log_Util.Debug_Log(G_LOG_STMT, 'Processed attachment change with l_return_status'|| l_return_status);
494: IF l_return_status = FND_API.G_RET_STS_SUCCESS
495: THEN
496: Eng_Propagation_Log_Util.add_entity_map(
497: p_change_id => p_change_id
498: , p_revised_item_sequence_id => p_revised_item_sequence_id
499: , p_revised_line_type => Eng_Propagation_Log_Util.G_REV_LINE_ATCH_CHG
500: , p_revised_line_id1 => ac.CHANGE_DOCUMENT_ID

Line 499: , p_revised_line_type => Eng_Propagation_Log_Util.G_REV_LINE_ATCH_CHG

495: THEN
496: Eng_Propagation_Log_Util.add_entity_map(
497: p_change_id => p_change_id
498: , p_revised_item_sequence_id => p_revised_item_sequence_id
499: , p_revised_line_type => Eng_Propagation_Log_Util.G_REV_LINE_ATCH_CHG
500: , p_revised_line_id1 => ac.CHANGE_DOCUMENT_ID
501: , p_local_organization_id => p_local_organization_id
502: , p_local_revised_item_seq_id => p_revised_item_unexp_rec.revised_item_sequence_id
503: , p_local_revised_line_id1 => l_change_document_id

Line 504: , p_entity_name => Eng_Propagation_Log_Util.G_ENTITY_REVISED_LINE

500: , p_revised_line_id1 => ac.CHANGE_DOCUMENT_ID
501: , p_local_organization_id => p_local_organization_id
502: , p_local_revised_item_seq_id => p_revised_item_unexp_rec.revised_item_sequence_id
503: , p_local_revised_line_id1 => l_change_document_id
504: , p_entity_name => Eng_Propagation_Log_Util.G_ENTITY_REVISED_LINE
505: , p_entity_action_status => Eng_Propagation_Log_Util.G_PRP_PRC_STS_SUCCESS
506: , p_bo_entity_identifier => 'ATCH'--Eco_Error_Handler.G_ATCH_LEVEL
507: );
508: END IF;

Line 505: , p_entity_action_status => Eng_Propagation_Log_Util.G_PRP_PRC_STS_SUCCESS

501: , p_local_organization_id => p_local_organization_id
502: , p_local_revised_item_seq_id => p_revised_item_unexp_rec.revised_item_sequence_id
503: , p_local_revised_line_id1 => l_change_document_id
504: , p_entity_name => Eng_Propagation_Log_Util.G_ENTITY_REVISED_LINE
505: , p_entity_action_status => Eng_Propagation_Log_Util.G_PRP_PRC_STS_SUCCESS
506: , p_bo_entity_identifier => 'ATCH'--Eco_Error_Handler.G_ATCH_LEVEL
507: );
508: END IF;
509: IF l_return_status = FND_API.G_RET_STS_ERROR

Line 515: Eng_Propagation_log_Util.Debug_Log(G_LOG_STMT, 'Processed All attachment change with x_return_status'||x_return_status);

511: x_return_status := l_return_status;
512: END IF;
513: END LOOP; /* end loop 2 */
514: END IF;
515: Eng_Propagation_log_Util.Debug_Log(G_LOG_STMT, 'Processed All attachment change with x_return_status'||x_return_status);
516: IF x_return_status = FND_API.G_RET_STS_ERROR
517: THEN
518: Error_Handler.Add_Error_Token(
519: p_Message_Name => 'ENG_PRP_ATT_REVITEM_ERR'

Line 524: Eng_Propagation_log_Util.Debug_Log(G_LOG_STMT, 'Propagate_Attach_Lines.END');

520: , p_Mesg_Token_Tbl => x_mesg_token_tbl
521: , x_Mesg_Token_Tbl => x_mesg_token_tbl
522: );
523: END IF;
524: Eng_Propagation_log_Util.Debug_Log(G_LOG_STMT, 'Propagate_Attach_Lines.END');
525:
526: EXCEPTION
527: WHEN OTHERS THEN
528: x_return_status := FND_API.G_RET_STS_ERROR;

Line 537: Eng_Propagation_log_Util.Debug_Log(G_LOG_PROC, 'Propagate_Attach_Lines.END.ERROR');

533: , p_Mesg_Token_Tbl => x_Mesg_Token_Tbl
534: , x_Mesg_Token_Tbl => x_Mesg_Token_Tbl
535: );
536: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error propagating attachment changes' ||SQLERRM);
537: Eng_Propagation_log_Util.Debug_Log(G_LOG_PROC, 'Propagate_Attach_Lines.END.ERROR');
538: END Propagate_Attach_Lines;
539:
540: PROCEDURE BREAK_COMMON_BOM (
541: p_to_sequence_id IN NUMBER

Line 795: AND ecpm.revised_line_type = Eng_Propagation_Log_Util.G_REV_LINE_ATCH_CHG

791: ))
792: AND NOT EXISTS (SELECT 1 FROM eng_change_propagation_maps ecpm
793: WHERE ecpm.change_id = p_change_id
794: AND ecpm.local_organization_id = p_local_organization_id
795: AND ecpm.revised_line_type = Eng_Propagation_Log_Util.G_REV_LINE_ATCH_CHG
796: AND ecpm.revised_line_id1 = eac.change_document_id
797: AND ecpm.entity_action_status = 3);
798:
799: CURSOR c_check_item_level_changes IS

Line 811: AND ecpm.revised_line_type = Eng_Propagation_Log_Util.G_REV_LINE_ATCH_CHG

807: AND MP.master_organization_id = MP.organization_id)
808: AND NOT EXISTS (SELECT 1 FROM eng_change_propagation_maps ecpm
809: WHERE ecpm.change_id = p_change_id
810: AND ecpm.local_organization_id = p_local_organization_id
811: AND ecpm.revised_line_type = Eng_Propagation_Log_Util.G_REV_LINE_ATCH_CHG
812: AND ecpm.revised_line_id1 = eac.change_document_id
813: AND ecpm.entity_action_status = 3);
814:
815:

Line 833: Eng_Propagation_Log_Util.Debug_Log(G_LOG_PROC, 'Validate_Attach_Lines.BEGIN');

829: l_global_revision VARCHAR2(30);
830: l_rev_mismatch NUMBER;
831:
832: BEGIN
833: Eng_Propagation_Log_Util.Debug_Log(G_LOG_PROC, 'Validate_Attach_Lines.BEGIN');
834: --
835: -- Initialize
836: l_error_logged := G_VAL_FALSE;
837: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 842: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Processing attachment change record with change_document_id: '||ac.change_document_id);

838:
839: -- validate attachment changes propagation
840: FOR ac IN c_attachment_changes
841: LOOP
842: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Processing attachment change record with change_document_id: '||ac.change_document_id);
843:
844: Error_Handler.Delete_Message(p_entity_id => Eco_Error_Handler.G_ATCH_LEVEL);
845:
846: l_mesg_token_tbl.delete;

Line 917: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Value: l_pk3_value '||l_pk3_value);

913: l_rev_mismatch := G_VAL_TRUE;
914: END IF;
915: END IF;
916:
917: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Value: l_pk3_value '||l_pk3_value);
918: END IF;
919:
920: IF l_rev_mismatch = G_VAL_FALSE
921: THEN

Line 957: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Value: l_local_attachment_id'||l_local_attachment_id||' l_local_att_status'||l_local_att_status);

953: FROM fnd_lookups
954: WHERE lookup_type = 'DOM_CHANGE_ACTION_TYPES'
955: AND lookup_code = ac.action_type;
956:
957: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Value: l_local_attachment_id'||l_local_attachment_id||' l_local_att_status'||l_local_att_status);
958: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Value: ac.action_type'||ac.action_type);
959:
960: IF (ac.action_type = 'ATTACH' AND l_local_attachment_id <> -1)
961: THEN

Line 958: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Value: ac.action_type'||ac.action_type);

954: WHERE lookup_type = 'DOM_CHANGE_ACTION_TYPES'
955: AND lookup_code = ac.action_type;
956:
957: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Value: l_local_attachment_id'||l_local_attachment_id||' l_local_att_status'||l_local_att_status);
958: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Value: ac.action_type'||ac.action_type);
959:
960: IF (ac.action_type = 'ATTACH' AND l_local_attachment_id <> -1)
961: THEN
962: -- For attach action, if Attachment already exists log error

Line 1023: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Value: l_error_logged'||l_error_logged);

1019:
1020: END IF;
1021: END IF;
1022:
1023: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Value: l_error_logged'||l_error_logged);
1024:
1025: IF (l_error_logged = G_VAL_TRUE)
1026: THEN
1027: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1049: Eng_Propagation_Log_Util.add_entity_map(

1045: );
1046: -- local change id is set later
1047: -- if there are errors, based on the level they are not populated in the
1048: -- maps table.
1049: Eng_Propagation_Log_Util.add_entity_map(
1050: p_change_id => p_change_id
1051: , p_revised_item_sequence_id => p_rev_item_sequence_id
1052: , p_revised_line_type => Eng_Propagation_Log_Util.G_REV_LINE_ATCH_CHG
1053: , p_revised_line_id1 => ac.change_document_id

Line 1052: , p_revised_line_type => Eng_Propagation_Log_Util.G_REV_LINE_ATCH_CHG

1048: -- maps table.
1049: Eng_Propagation_Log_Util.add_entity_map(
1050: p_change_id => p_change_id
1051: , p_revised_item_sequence_id => p_rev_item_sequence_id
1052: , p_revised_line_type => Eng_Propagation_Log_Util.G_REV_LINE_ATCH_CHG
1053: , p_revised_line_id1 => ac.change_document_id
1054: , p_local_organization_id => p_local_organization_id
1055: , p_entity_name => Eng_Propagation_Log_Util.G_ENTITY_REVISED_LINE
1056: , p_entity_action_status => Eng_Propagation_Log_Util.G_PRP_PRC_STS_ERROR

Line 1055: , p_entity_name => Eng_Propagation_Log_Util.G_ENTITY_REVISED_LINE

1051: , p_revised_item_sequence_id => p_rev_item_sequence_id
1052: , p_revised_line_type => Eng_Propagation_Log_Util.G_REV_LINE_ATCH_CHG
1053: , p_revised_line_id1 => ac.change_document_id
1054: , p_local_organization_id => p_local_organization_id
1055: , p_entity_name => Eng_Propagation_Log_Util.G_ENTITY_REVISED_LINE
1056: , p_entity_action_status => Eng_Propagation_Log_Util.G_PRP_PRC_STS_ERROR
1057: , p_bo_entity_identifier => 'ATCH'--Eco_Error_Handler.G_ATCH_LEVEL
1058: );
1059: ELSE

Line 1056: , p_entity_action_status => Eng_Propagation_Log_Util.G_PRP_PRC_STS_ERROR

1052: , p_revised_line_type => Eng_Propagation_Log_Util.G_REV_LINE_ATCH_CHG
1053: , p_revised_line_id1 => ac.change_document_id
1054: , p_local_organization_id => p_local_organization_id
1055: , p_entity_name => Eng_Propagation_Log_Util.G_ENTITY_REVISED_LINE
1056: , p_entity_action_status => Eng_Propagation_Log_Util.G_PRP_PRC_STS_ERROR
1057: , p_bo_entity_identifier => 'ATCH'--Eco_Error_Handler.G_ATCH_LEVEL
1058: );
1059: ELSE
1060: /*Eng_Propagation_Log_Util.add_entity_map(

Line 1060: /*Eng_Propagation_Log_Util.add_entity_map(

1056: , p_entity_action_status => Eng_Propagation_Log_Util.G_PRP_PRC_STS_ERROR
1057: , p_bo_entity_identifier => 'ATCH'--Eco_Error_Handler.G_ATCH_LEVEL
1058: );
1059: ELSE
1060: /*Eng_Propagation_Log_Util.add_entity_map(
1061: p_change_id => p_change_id
1062: , p_revised_item_sequence_id => p_rev_item_sequence_id
1063: , p_revised_line_type => Eng_Propagation_Log_Util.G_REV_LINE_ATCH_CHG
1064: , p_revised_line_id1 => ac.change_document_id

Line 1063: , p_revised_line_type => Eng_Propagation_Log_Util.G_REV_LINE_ATCH_CHG

1059: ELSE
1060: /*Eng_Propagation_Log_Util.add_entity_map(
1061: p_change_id => p_change_id
1062: , p_revised_item_sequence_id => p_rev_item_sequence_id
1063: , p_revised_line_type => Eng_Propagation_Log_Util.G_REV_LINE_ATCH_CHG
1064: , p_revised_line_id1 => ac.change_document_id
1065: , p_local_organization_id => p_local_organization_id
1066: , p_entity_name => Eng_Propagation_Log_Util.G_ENTITY_REVISED_LINE
1067: , p_entity_action_status => Eng_Propagation_Log_Util.G_PRP_PRC_STS_SUCCESS

Line 1066: , p_entity_name => Eng_Propagation_Log_Util.G_ENTITY_REVISED_LINE

1062: , p_revised_item_sequence_id => p_rev_item_sequence_id
1063: , p_revised_line_type => Eng_Propagation_Log_Util.G_REV_LINE_ATCH_CHG
1064: , p_revised_line_id1 => ac.change_document_id
1065: , p_local_organization_id => p_local_organization_id
1066: , p_entity_name => Eng_Propagation_Log_Util.G_ENTITY_REVISED_LINE
1067: , p_entity_action_status => Eng_Propagation_Log_Util.G_PRP_PRC_STS_SUCCESS
1068: , p_bo_entity_identifier => 'ATCH'--Eco_Error_Handler.G_ATCH_LEVEL
1069: );*/
1070: null;-- do nothing

Line 1067: , p_entity_action_status => Eng_Propagation_Log_Util.G_PRP_PRC_STS_SUCCESS

1063: , p_revised_line_type => Eng_Propagation_Log_Util.G_REV_LINE_ATCH_CHG
1064: , p_revised_line_id1 => ac.change_document_id
1065: , p_local_organization_id => p_local_organization_id
1066: , p_entity_name => Eng_Propagation_Log_Util.G_ENTITY_REVISED_LINE
1067: , p_entity_action_status => Eng_Propagation_Log_Util.G_PRP_PRC_STS_SUCCESS
1068: , p_bo_entity_identifier => 'ATCH'--Eco_Error_Handler.G_ATCH_LEVEL
1069: );*/
1070: null;-- do nothing
1071: END IF;

Line 1099: Eng_Propagation_Log_Util.Debug_Log(G_LOG_PROC, 'Validate_Attach_Lines.END');

1095: , x_Mesg_Token_Tbl => x_mesg_token_tbl
1096: , p_Token_Tbl => l_token_tbl
1097: );
1098: END IF;
1099: Eng_Propagation_Log_Util.Debug_Log(G_LOG_PROC, 'Validate_Attach_Lines.END');
1100:
1101: EXCEPTION
1102: WHEN OTHERS THEN
1103: IF (c_check_item_level_changes%ISOPEN)

Line 1107: Eng_Propagation_Log_Util.Debug_Log(G_LOG_PROC, 'Validate_Attach_Lines.ERROR');

1103: IF (c_check_item_level_changes%ISOPEN)
1104: THEN
1105: CLOSE c_check_item_level_changes;
1106: END IF;
1107: Eng_Propagation_Log_Util.Debug_Log(G_LOG_PROC, 'Validate_Attach_Lines.ERROR');
1108: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in validation attachments ' || SQLERRM);
1109: l_error_logged := 1;
1110: x_return_status := FND_API.G_RET_STS_ERROR;
1111: Error_Handler.Add_Error_Token(

Line 1234: Eng_Propagation_Log_Util.Debug_Log(G_LOG_PROC, '-------------------------------');

1230:
1231: l_eco_chg_exists VARCHAR2(1); -- bug 10146196 added
1232: BEGIN
1233:
1234: Eng_Propagation_Log_Util.Debug_Log(G_LOG_PROC, '-------------------------------');
1235: Eng_Propagation_Log_Util.Debug_Log(G_LOG_PROC, 'CHECK_REVISED_ITEM_ERRORS.begin');
1236: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_change_notice '|| p_change_notice);
1237: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_global_org_id '|| p_global_org_id);
1238: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_local_org_id '|| p_local_org_id);

Line 1235: Eng_Propagation_Log_Util.Debug_Log(G_LOG_PROC, 'CHECK_REVISED_ITEM_ERRORS.begin');

1231: l_eco_chg_exists VARCHAR2(1); -- bug 10146196 added
1232: BEGIN
1233:
1234: Eng_Propagation_Log_Util.Debug_Log(G_LOG_PROC, '-------------------------------');
1235: Eng_Propagation_Log_Util.Debug_Log(G_LOG_PROC, 'CHECK_REVISED_ITEM_ERRORS.begin');
1236: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_change_notice '|| p_change_notice);
1237: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_global_org_id '|| p_global_org_id);
1238: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_local_org_id '|| p_local_org_id);
1239: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_rev_item_seq_id '|| p_rev_item_seq_id);

Line 1236: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_change_notice '|| p_change_notice);

1232: BEGIN
1233:
1234: Eng_Propagation_Log_Util.Debug_Log(G_LOG_PROC, '-------------------------------');
1235: Eng_Propagation_Log_Util.Debug_Log(G_LOG_PROC, 'CHECK_REVISED_ITEM_ERRORS.begin');
1236: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_change_notice '|| p_change_notice);
1237: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_global_org_id '|| p_global_org_id);
1238: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_local_org_id '|| p_local_org_id);
1239: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_rev_item_seq_id '|| p_rev_item_seq_id);
1240: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_transfer_item_enable'|| p_transfer_item_enable);

Line 1237: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_global_org_id '|| p_global_org_id);

1233:
1234: Eng_Propagation_Log_Util.Debug_Log(G_LOG_PROC, '-------------------------------');
1235: Eng_Propagation_Log_Util.Debug_Log(G_LOG_PROC, 'CHECK_REVISED_ITEM_ERRORS.begin');
1236: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_change_notice '|| p_change_notice);
1237: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_global_org_id '|| p_global_org_id);
1238: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_local_org_id '|| p_local_org_id);
1239: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_rev_item_seq_id '|| p_rev_item_seq_id);
1240: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_transfer_item_enable'|| p_transfer_item_enable);
1241: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_use_up_item_id '|| p_use_up_item_id);

Line 1238: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_local_org_id '|| p_local_org_id);

1234: Eng_Propagation_Log_Util.Debug_Log(G_LOG_PROC, '-------------------------------');
1235: Eng_Propagation_Log_Util.Debug_Log(G_LOG_PROC, 'CHECK_REVISED_ITEM_ERRORS.begin');
1236: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_change_notice '|| p_change_notice);
1237: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_global_org_id '|| p_global_org_id);
1238: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_local_org_id '|| p_local_org_id);
1239: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_rev_item_seq_id '|| p_rev_item_seq_id);
1240: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_transfer_item_enable'|| p_transfer_item_enable);
1241: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_use_up_item_id '|| p_use_up_item_id);
1242: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_revised_item_id '|| p_revised_item_id);

Line 1239: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_rev_item_seq_id '|| p_rev_item_seq_id);

1235: Eng_Propagation_Log_Util.Debug_Log(G_LOG_PROC, 'CHECK_REVISED_ITEM_ERRORS.begin');
1236: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_change_notice '|| p_change_notice);
1237: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_global_org_id '|| p_global_org_id);
1238: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_local_org_id '|| p_local_org_id);
1239: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_rev_item_seq_id '|| p_rev_item_seq_id);
1240: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_transfer_item_enable'|| p_transfer_item_enable);
1241: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_use_up_item_id '|| p_use_up_item_id);
1242: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_revised_item_id '|| p_revised_item_id);
1243: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_transfer_or_copy '|| p_transfer_or_copy);

Line 1240: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_transfer_item_enable'|| p_transfer_item_enable);

1236: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_change_notice '|| p_change_notice);
1237: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_global_org_id '|| p_global_org_id);
1238: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_local_org_id '|| p_local_org_id);
1239: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_rev_item_seq_id '|| p_rev_item_seq_id);
1240: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_transfer_item_enable'|| p_transfer_item_enable);
1241: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_use_up_item_id '|| p_use_up_item_id);
1242: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_revised_item_id '|| p_revised_item_id);
1243: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_transfer_or_copy '|| p_transfer_or_copy);
1244: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_transfer_or_copy_item '|| p_transfer_or_copy_item);

Line 1241: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_use_up_item_id '|| p_use_up_item_id);

1237: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_global_org_id '|| p_global_org_id);
1238: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_local_org_id '|| p_local_org_id);
1239: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_rev_item_seq_id '|| p_rev_item_seq_id);
1240: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_transfer_item_enable'|| p_transfer_item_enable);
1241: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_use_up_item_id '|| p_use_up_item_id);
1242: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_revised_item_id '|| p_revised_item_id);
1243: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_transfer_or_copy '|| p_transfer_or_copy);
1244: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_transfer_or_copy_item '|| p_transfer_or_copy_item);
1245: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_status_master_controlled'|| p_status_master_controlled);

Line 1242: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_revised_item_id '|| p_revised_item_id);

1238: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_local_org_id '|| p_local_org_id);
1239: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_rev_item_seq_id '|| p_rev_item_seq_id);
1240: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_transfer_item_enable'|| p_transfer_item_enable);
1241: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_use_up_item_id '|| p_use_up_item_id);
1242: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_revised_item_id '|| p_revised_item_id);
1243: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_transfer_or_copy '|| p_transfer_or_copy);
1244: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_transfer_or_copy_item '|| p_transfer_or_copy_item);
1245: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_status_master_controlled'|| p_status_master_controlled);
1246:

Line 1243: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_transfer_or_copy '|| p_transfer_or_copy);

1239: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_rev_item_seq_id '|| p_rev_item_seq_id);
1240: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_transfer_item_enable'|| p_transfer_item_enable);
1241: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_use_up_item_id '|| p_use_up_item_id);
1242: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_revised_item_id '|| p_revised_item_id);
1243: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_transfer_or_copy '|| p_transfer_or_copy);
1244: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_transfer_or_copy_item '|| p_transfer_or_copy_item);
1245: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_status_master_controlled'|| p_status_master_controlled);
1246:
1247: BEGIN

Line 1244: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_transfer_or_copy_item '|| p_transfer_or_copy_item);

1240: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_transfer_item_enable'|| p_transfer_item_enable);
1241: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_use_up_item_id '|| p_use_up_item_id);
1242: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_revised_item_id '|| p_revised_item_id);
1243: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_transfer_or_copy '|| p_transfer_or_copy);
1244: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_transfer_or_copy_item '|| p_transfer_or_copy_item);
1245: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_status_master_controlled'|| p_status_master_controlled);
1246:
1247: BEGIN
1248:

Line 1245: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_status_master_controlled'|| p_status_master_controlled);

1241: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_use_up_item_id '|| p_use_up_item_id);
1242: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_revised_item_id '|| p_revised_item_id);
1243: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_transfer_or_copy '|| p_transfer_or_copy);
1244: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_transfer_or_copy_item '|| p_transfer_or_copy_item);
1245: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_status_master_controlled'|| p_status_master_controlled);
1246:
1247: BEGIN
1248:
1249: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Validation: Checking if revised item already exists in local Change');

Line 1249: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Validation: Checking if revised item already exists in local Change');

1245: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_status_master_controlled'|| p_status_master_controlled);
1246:
1247: BEGIN
1248:
1249: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Validation: Checking if revised item already exists in local Change');
1250:
1251: SELECT G_VAL_TRUE
1252: into l_local_revised_item_exists
1253: FROM eng_revised_items eri1

Line 1271: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Value l_local_revised_item_exists: '||l_local_revised_item_exists);

1267: EXCEPTION
1268: WHEN NO_DATA_FOUND THEN
1269: l_local_revised_item_exists := G_VAL_FALSE;
1270: END;
1271: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Value l_local_revised_item_exists: '||l_local_revised_item_exists);
1272:
1273: IF (l_local_revised_item_exists = G_VAL_TRUE)
1274: THEN
1275: Error_Handler.Add_Error_Token(

Line 1283: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Validation: Checking if item exists in local Organization');

1279: , p_Token_Tbl => l_token_tbl
1280: );
1281: l_error_logged := G_VAL_TRUE;
1282: ELSE
1283: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Validation: Checking if item exists in local Organization');
1284: BEGIN
1285: SELECT 1
1286: into l_item_exists_in_org_flag
1287: FROM mtl_system_items_b_kfv

Line 1295: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Value l_item_exists_in_org_flag: '||l_item_exists_in_org_flag);

1291: WHEN NO_DATA_FOUND THEN
1292: l_item_exists_in_org_flag := 0;
1293: END;
1294:
1295: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Value l_item_exists_in_org_flag: '||l_item_exists_in_org_flag);
1296:
1297: SELECT concatenated_segments
1298: into l_revised_item_number
1299: FROM mtl_system_items_b_kfv

Line 1303: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Value l_revised_item_number: '||l_revised_item_number);

1299: FROM mtl_system_items_b_kfv
1300: WHERE inventory_item_id = p_revised_item_id
1301: AND organization_id = g_global_org_id;
1302:
1303: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Value l_revised_item_number: '||l_revised_item_number);
1304:
1305: -- 11.5.10 Feature: Scoped Out
1306: -- If item does not exist in local organization but it is set to be enabled per organization
1307: -- at the change type level, then check if it is a transfer item and Auto Enable

Line 1310: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Item does not exist in Organization and it is supposed to be enabled for tranfer');

1306: -- If item does not exist in local organization but it is set to be enabled per organization
1307: -- at the change type level, then check if it is a transfer item and Auto Enable
1308: IF (l_item_exists_in_org_flag = 0 AND p_transfer_item_enable = 1)
1309: THEN
1310: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Item does not exist in Organization and it is supposed to be enabled for tranfer');
1311: -- Enable item in local org
1312: IF (p_transfer_or_copy = 'T' AND p_transfer_or_copy_item = 1 )
1313: THEN
1314: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Transfer Item Enabling In Progress ..');

Line 1314: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Transfer Item Enabling In Progress ..');

1310: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Item does not exist in Organization and it is supposed to be enabled for tranfer');
1311: -- Enable item in local org
1312: IF (p_transfer_or_copy = 'T' AND p_transfer_or_copy_item = 1 )
1313: THEN
1314: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Transfer Item Enabling In Progress ..');
1315: AUTO_ENABLE_ITEM_IN_ORG(
1316: p_inventory_item_id => p_revised_item_id
1317: , p_organization_id => p_local_org_id
1318: , x_error_table => l_item_error_table

Line 1323: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Transfer Item Enabling Successful');

1319: , x_return_status => l_return_status);
1320:
1321: IF (l_return_status = 'S')
1322: THEN
1323: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Transfer Item Enabling Successful');
1324: l_item_exists_in_org_flag := 1;
1325:
1326: l_token_tbl.delete;
1327: l_token_tbl(1).token_name := 'ITEM';

Line 1337: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Transfer Item Enabling Error');

1333: , p_Token_Tbl => l_token_tbl
1334: , p_message_type => 'I' );
1335: ELSE
1336: l_error_logged := G_VAL_TRUE;
1337: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Transfer Item Enabling Error');
1338: FOR i IN 1..l_item_error_table.COUNT
1339: LOOP
1340: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Transfer Item Enabling Error:'||l_item_error_table(i).message_name);
1341: Error_Handler.Add_Error_Token(

Line 1340: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Transfer Item Enabling Error:'||l_item_error_table(i).message_name);

1336: l_error_logged := G_VAL_TRUE;
1337: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Transfer Item Enabling Error');
1338: FOR i IN 1..l_item_error_table.COUNT
1339: LOOP
1340: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Transfer Item Enabling Error:'||l_item_error_table(i).message_name);
1341: Error_Handler.Add_Error_Token(
1342: p_Message_Name => NULL
1343: , p_Message_Text => l_item_error_table(i).message_text
1344: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 1354: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Value Post Auto Enable for transfer l_item_exists_in_org_flag: '||l_item_exists_in_org_flag);

1350: END IF;
1351: END IF;
1352: END IF;
1353:
1354: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Value Post Auto Enable for transfer l_item_exists_in_org_flag: '||l_item_exists_in_org_flag);
1355:
1356: -- If Item does not exist in local organization throw an error
1357: IF (l_item_exists_in_org_flag = 0)
1358: THEN

Line 1369: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Validation: Check if use up item Exists');

1365: l_error_logged := 1;
1366: ELSIF (l_item_exists_in_org_flag = 1 AND p_use_up_item_id IS NOT NULL)
1367: THEN
1368: -- If item exists check for use up item
1369: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Validation: Check if use up item Exists');
1370: BEGIN
1371: SELECT 1
1372: INTO l_use_up_item_exists
1373: FROM mtl_system_items

Line 1386: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Value l_use_up_item_exists'|| l_use_up_item_exists);

1382: , p_Token_Tbl => l_token_tbl);
1383: l_error_logged := 1;
1384: l_item_exists_in_org_flag := 0;
1385: END;
1386: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Value l_use_up_item_exists'|| l_use_up_item_exists);
1387: END IF;
1388:
1389: --
1390: -- Proceed with processing only if item and Use up exists in local Organization

Line 1393: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Proceed with processing as item and use up are valid for local Organization');

1389: --
1390: -- Proceed with processing only if item and Use up exists in local Organization
1391: IF (l_item_exists_in_org_flag = 1)
1392: THEN
1393: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Proceed with processing as item and use up are valid for local Organization');
1394: x_propagate_strc_changes := G_VAL_TRUE;
1395: --
1396: -- Check if sourcing rules exist for item
1397: l_item_sourced_flag := CHECK_SOURCING_RULES(p_local_org_id , p_revised_item_id);

Line 1398: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Fetch sourcing rules for item in local organization Value: l_item_sourced_flag'||l_item_sourced_flag);

1394: x_propagate_strc_changes := G_VAL_TRUE;
1395: --
1396: -- Check if sourcing rules exist for item
1397: l_item_sourced_flag := CHECK_SOURCING_RULES(p_local_org_id , p_revised_item_id);
1398: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Fetch sourcing rules for item in local organization Value: l_item_sourced_flag'||l_item_sourced_flag);
1399:
1400: --
1401: -- Check if structure line - bill exists
1402: FOR sl in c_rev_item_struc_lines(p_rev_item_seq_id)

Line 1440: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Value l_structure_exists_flag:' || l_structure_exists_flag);

1436: WHEN NO_DATA_FOUND THEN
1437: null;
1438: END;
1439: END IF;
1440: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Value l_structure_exists_flag:' || l_structure_exists_flag);
1441: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Value l_create_bill_for_item:' || l_create_bill_for_item);
1442:
1443: IF (l_item_sourced_flag = 1 AND l_structure_exists_flag = 1)
1444: THEN

Line 1441: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Value l_create_bill_for_item:' || l_create_bill_for_item);

1437: null;
1438: END;
1439: END IF;
1440: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Value l_structure_exists_flag:' || l_structure_exists_flag);
1441: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Value l_create_bill_for_item:' || l_create_bill_for_item);
1442:
1443: IF (l_item_sourced_flag = 1 AND l_structure_exists_flag = 1)
1444: THEN
1445: -- Log a message and do not continue

Line 1546: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Transfer Item Enabling Error:'||l_item_error_table(i).message_name);

1542: , p_message_type => 'I' );
1543: ELSE
1544: FOR i IN 1..l_item_error_table.COUNT
1545: LOOP
1546: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Transfer Item Enabling Error:'||l_item_error_table(i).message_name);
1547: l_token_tbl.delete;
1548: l_token_tbl(1).token_name := 'MESSAGE';
1549: l_token_tbl(1).token_value := l_item_error_table(i).message_name;
1550: Error_Handler.Add_Error_Token(

Line 1736: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Output Param: p_propagate_revised_item '|| l_item_exists_in_org_flag);

1732: x_error_logged := l_error_logged;
1733: x_revised_item_name := l_revised_item_number;
1734: x_Mesg_Token_Tbl := l_mesg_token_tbl;
1735:
1736: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Output Param: p_propagate_revised_item '|| l_item_exists_in_org_flag);
1737: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Output Param: p_sourcing_rules_exists '|| l_item_sourced_flag);
1738: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Output Param: p_error_logged '|| l_error_logged);
1739: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Output Param: p_revised_item_name '|| l_revised_item_number);
1740:

Line 1737: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Output Param: p_sourcing_rules_exists '|| l_item_sourced_flag);

1733: x_revised_item_name := l_revised_item_number;
1734: x_Mesg_Token_Tbl := l_mesg_token_tbl;
1735:
1736: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Output Param: p_propagate_revised_item '|| l_item_exists_in_org_flag);
1737: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Output Param: p_sourcing_rules_exists '|| l_item_sourced_flag);
1738: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Output Param: p_error_logged '|| l_error_logged);
1739: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Output Param: p_revised_item_name '|| l_revised_item_number);
1740:
1741: Eng_Propagation_Log_Util.Debug_Log(G_LOG_PROC, 'CHECK_REVISED_ITEM_ERRORS.end');

Line 1738: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Output Param: p_error_logged '|| l_error_logged);

1734: x_Mesg_Token_Tbl := l_mesg_token_tbl;
1735:
1736: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Output Param: p_propagate_revised_item '|| l_item_exists_in_org_flag);
1737: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Output Param: p_sourcing_rules_exists '|| l_item_sourced_flag);
1738: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Output Param: p_error_logged '|| l_error_logged);
1739: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Output Param: p_revised_item_name '|| l_revised_item_number);
1740:
1741: Eng_Propagation_Log_Util.Debug_Log(G_LOG_PROC, 'CHECK_REVISED_ITEM_ERRORS.end');
1742: Eng_Propagation_Log_Util.Debug_Log(G_LOG_PROC, '-------------------------------');

Line 1739: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Output Param: p_revised_item_name '|| l_revised_item_number);

1735:
1736: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Output Param: p_propagate_revised_item '|| l_item_exists_in_org_flag);
1737: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Output Param: p_sourcing_rules_exists '|| l_item_sourced_flag);
1738: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Output Param: p_error_logged '|| l_error_logged);
1739: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Output Param: p_revised_item_name '|| l_revised_item_number);
1740:
1741: Eng_Propagation_Log_Util.Debug_Log(G_LOG_PROC, 'CHECK_REVISED_ITEM_ERRORS.end');
1742: Eng_Propagation_Log_Util.Debug_Log(G_LOG_PROC, '-------------------------------');
1743: EXCEPTION

Line 1741: Eng_Propagation_Log_Util.Debug_Log(G_LOG_PROC, 'CHECK_REVISED_ITEM_ERRORS.end');

1737: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Output Param: p_sourcing_rules_exists '|| l_item_sourced_flag);
1738: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Output Param: p_error_logged '|| l_error_logged);
1739: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Output Param: p_revised_item_name '|| l_revised_item_number);
1740:
1741: Eng_Propagation_Log_Util.Debug_Log(G_LOG_PROC, 'CHECK_REVISED_ITEM_ERRORS.end');
1742: Eng_Propagation_Log_Util.Debug_Log(G_LOG_PROC, '-------------------------------');
1743: EXCEPTION
1744: WHEN OTHERS THEN
1745: Eng_Propagation_Log_Util.Debug_Log(Eng_Propagation_Log_Util.G_LOG_ERROR, 'CHECK_REVISED_ITEM_ERRORS.Unexpected error'|| SQLERRM);

Line 1742: Eng_Propagation_Log_Util.Debug_Log(G_LOG_PROC, '-------------------------------');

1738: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Output Param: p_error_logged '|| l_error_logged);
1739: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Output Param: p_revised_item_name '|| l_revised_item_number);
1740:
1741: Eng_Propagation_Log_Util.Debug_Log(G_LOG_PROC, 'CHECK_REVISED_ITEM_ERRORS.end');
1742: Eng_Propagation_Log_Util.Debug_Log(G_LOG_PROC, '-------------------------------');
1743: EXCEPTION
1744: WHEN OTHERS THEN
1745: Eng_Propagation_Log_Util.Debug_Log(Eng_Propagation_Log_Util.G_LOG_ERROR, 'CHECK_REVISED_ITEM_ERRORS.Unexpected error'|| SQLERRM);
1746: END Check_Revised_Item_Errors;

Line 1745: Eng_Propagation_Log_Util.Debug_Log(Eng_Propagation_Log_Util.G_LOG_ERROR, 'CHECK_REVISED_ITEM_ERRORS.Unexpected error'|| SQLERRM);

1741: Eng_Propagation_Log_Util.Debug_Log(G_LOG_PROC, 'CHECK_REVISED_ITEM_ERRORS.end');
1742: Eng_Propagation_Log_Util.Debug_Log(G_LOG_PROC, '-------------------------------');
1743: EXCEPTION
1744: WHEN OTHERS THEN
1745: Eng_Propagation_Log_Util.Debug_Log(Eng_Propagation_Log_Util.G_LOG_ERROR, 'CHECK_REVISED_ITEM_ERRORS.Unexpected error'|| SQLERRM);
1746: END Check_Revised_Item_Errors;
1747:
1748: PROCEDURE PROPAGATE_ECO_ERP
1749: (

Line 3535: Eng_Propagation_Log_Util.Debug_Log(G_LOG_PROC, 'Propagate_Revised_Component.BEGIN');

3531: WHERE inventory_item_id = cp_inventory_item_id
3532: AND organization_id = cp_organization_id;
3533: BEGIN
3534: -- Initialize this API for error handling
3535: Eng_Propagation_Log_Util.Debug_Log(G_LOG_PROC, 'Propagate_Revised_Component.BEGIN');
3536: Error_Handler.Initialize;
3537:
3538: l_entity_action_status := Eng_Propagation_Log_Util.G_PRP_PRC_STS_SUCCESS;
3539: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3538: l_entity_action_status := Eng_Propagation_Log_Util.G_PRP_PRC_STS_SUCCESS;

3534: -- Initialize this API for error handling
3535: Eng_Propagation_Log_Util.Debug_Log(G_LOG_PROC, 'Propagate_Revised_Component.BEGIN');
3536: Error_Handler.Initialize;
3537:
3538: l_entity_action_status := Eng_Propagation_Log_Util.G_PRP_PRC_STS_SUCCESS;
3539: l_return_status := FND_API.G_RET_STS_SUCCESS;
3540: -- Strat processing for each component
3541: FOR rc in c_component_details
3542: LOOP

Line 3563: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Component Item Is being auto enabled. rc.component_item_id:'|| rc.component_item_id);

3559: -- then it has to be auto enabled in the child organization
3560: -- Proceed to auto enable component
3561: IF rc.acd_type = 1 AND l_comp_exists_in_org = G_VAL_FALSE
3562: THEN
3563: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Component Item Is being auto enabled. rc.component_item_id:'|| rc.component_item_id);
3564: Auto_enable_item_in_org(
3565: p_inventory_item_id => rc.component_item_id
3566: , p_organization_id => p_local_organization_id
3567: , x_error_table => l_item_error_table

Line 3569: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'After Component Item Is auto enabled. l_return_status'||l_return_status);

3565: p_inventory_item_id => rc.component_item_id
3566: , p_organization_id => p_local_organization_id
3567: , x_error_table => l_item_error_table
3568: , x_return_status => l_return_status);
3569: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'After Component Item Is auto enabled. l_return_status'||l_return_status);
3570: IF (l_return_status = FND_API.G_RET_STS_SUCCESS)
3571: THEN
3572: OPEN c_get_item_details(rc.component_item_id, p_local_organization_id);
3573: FETCH c_get_item_details INTO l_component_item_name;

Line 3597: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Component Item Enabling Error:'||l_item_error_table(i).message_name);

3593: CLOSE c_get_item_details;
3594: ELSE
3595: FOR i IN 1..l_item_error_table.COUNT
3596: LOOP
3597: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Component Item Enabling Error:'||l_item_error_table(i).message_name);
3598: Error_Handler.Add_Error_Token(
3599: p_Message_Name => NULL
3600: , p_Message_Text => l_item_error_table(i).message_text
3601: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 3812: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Component Item Enabling Error:'||l_item_error_table(i).message_name);

3808: CLOSE c_get_item_details;
3809: ELSE
3810: FOR i IN 1..l_item_error_table.COUNT
3811: LOOP
3812: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Component Item Enabling Error:'||l_item_error_table(i).message_name);
3813: Error_Handler.Add_Error_Token(
3814: p_Message_Name => NULL
3815: , p_Message_Text => l_item_error_table(i).message_text
3816: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 3968: Eng_Propagation_Log_Util.Add_Entity_Map(

3964: , x_rev_op_resource_tbl => ENG_Eco_PUB.G_MISS_REV_OP_RESOURCE_TBL
3965: , x_rev_sub_resource_tbl => ENG_Eco_PUB.G_MISS_REV_SUB_RESOURCE_TBL
3966: );
3967:
3968: Eng_Propagation_Log_Util.Add_Entity_Map(
3969: p_change_id => p_change_id
3970: , p_revised_item_sequence_id => p_revised_item_sequence_id
3971: , p_revised_line_type => Eng_Propagation_Log_Util.G_REV_LINE_CMP_CHG
3972: , p_revised_line_id1 => p_component_sequence_id

Line 3971: , p_revised_line_type => Eng_Propagation_Log_Util.G_REV_LINE_CMP_CHG

3967:
3968: Eng_Propagation_Log_Util.Add_Entity_Map(
3969: p_change_id => p_change_id
3970: , p_revised_item_sequence_id => p_revised_item_sequence_id
3971: , p_revised_line_type => Eng_Propagation_Log_Util.G_REV_LINE_CMP_CHG
3972: , p_revised_line_id1 => p_component_sequence_id
3973: , p_local_organization_id => p_local_organization_id
3974: , p_local_revised_item_seq_id => p_revised_item_unexp_rec.revised_item_sequence_id
3975: , p_local_revised_line_id1 => l_rev_comp_unexp_rec.component_sequence_id

Line 3976: , p_entity_name => Eng_Propagation_Log_Util.G_ENTITY_REVISED_LINE

3972: , p_revised_line_id1 => p_component_sequence_id
3973: , p_local_organization_id => p_local_organization_id
3974: , p_local_revised_item_seq_id => p_revised_item_unexp_rec.revised_item_sequence_id
3975: , p_local_revised_line_id1 => l_rev_comp_unexp_rec.component_sequence_id
3976: , p_entity_name => Eng_Propagation_Log_Util.G_ENTITY_REVISED_LINE
3977: , p_entity_action_status => l_entity_action_status
3978: , p_bo_entity_identifier => 'RC'--Eco_Error_Handler.G_RC_LEVEL
3979: );
3980: -- TODO: How to handle substitue component and reference designator errors

Line 4006: Eng_Propagation_Log_Util.add_entity_map(

4002: );
4003: -- local change id is set later
4004: -- if there are errors, based on the level they are not populated in the
4005: -- maps table.
4006: Eng_Propagation_Log_Util.add_entity_map(
4007: p_change_id => p_change_id
4008: , p_revised_item_sequence_id => p_revised_item_sequence_id
4009: , p_revised_line_type => Eng_Propagation_Log_Util.G_REV_LINE_CMP_CHG
4010: , p_revised_line_id1 => p_component_sequence_id

Line 4009: , p_revised_line_type => Eng_Propagation_Log_Util.G_REV_LINE_CMP_CHG

4005: -- maps table.
4006: Eng_Propagation_Log_Util.add_entity_map(
4007: p_change_id => p_change_id
4008: , p_revised_item_sequence_id => p_revised_item_sequence_id
4009: , p_revised_line_type => Eng_Propagation_Log_Util.G_REV_LINE_CMP_CHG
4010: , p_revised_line_id1 => p_component_sequence_id
4011: , p_local_organization_id => p_local_organization_id
4012: , p_entity_name => Eng_Propagation_Log_Util.G_ENTITY_REVISED_LINE
4013: , p_entity_action_status => Eng_Propagation_Log_Util.G_PRP_PRC_STS_ERROR

Line 4012: , p_entity_name => Eng_Propagation_Log_Util.G_ENTITY_REVISED_LINE

4008: , p_revised_item_sequence_id => p_revised_item_sequence_id
4009: , p_revised_line_type => Eng_Propagation_Log_Util.G_REV_LINE_CMP_CHG
4010: , p_revised_line_id1 => p_component_sequence_id
4011: , p_local_organization_id => p_local_organization_id
4012: , p_entity_name => Eng_Propagation_Log_Util.G_ENTITY_REVISED_LINE
4013: , p_entity_action_status => Eng_Propagation_Log_Util.G_PRP_PRC_STS_ERROR
4014: , p_bo_entity_identifier => 'RC'--Eco_Error_Handler.G_RC_LEVEL
4015: );
4016: x_return_status := l_return_status;

Line 4013: , p_entity_action_status => Eng_Propagation_Log_Util.G_PRP_PRC_STS_ERROR

4009: , p_revised_line_type => Eng_Propagation_Log_Util.G_REV_LINE_CMP_CHG
4010: , p_revised_line_id1 => p_component_sequence_id
4011: , p_local_organization_id => p_local_organization_id
4012: , p_entity_name => Eng_Propagation_Log_Util.G_ENTITY_REVISED_LINE
4013: , p_entity_action_status => Eng_Propagation_Log_Util.G_PRP_PRC_STS_ERROR
4014: , p_bo_entity_identifier => 'RC'--Eco_Error_Handler.G_RC_LEVEL
4015: );
4016: x_return_status := l_return_status;
4017: END Propagate_Revised_Component;

Line 4759: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'After Propagation ECO l_return_status'|| l_return_status);

4755: , x_rev_operation_tbl => l_rev_operation_tbl
4756: , x_rev_op_resource_tbl => l_rev_op_resource_tbl
4757: , x_rev_sub_resource_tbl => l_rev_sub_resource_tbl
4758: );
4759: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'After Propagation ECO l_return_status'|| l_return_status);
4760:
4761: IF l_return_status = FND_API.G_RET_STS_SUCCESS
4762: THEN
4763:

Line 4817: Eng_Propagation_Log_Util.add_entity_map(

4813: , x_rev_op_resource_tbl => l_rev_op_resource_tbl --L1
4814: , x_rev_sub_resource_tbl => l_rev_sub_resource_tbl --L1
4815: );
4816:
4817: Eng_Propagation_Log_Util.add_entity_map(
4818: p_change_id => p_change_id
4819: , p_local_organization_id => p_local_organization_id
4820: , p_entity_name => Eng_Propagation_Log_Util.G_ENTITY_CHANGE
4821: , p_entity_action_status => Eng_Propagation_Log_Util.G_PRP_PRC_STS_ERROR

Line 4820: , p_entity_name => Eng_Propagation_Log_Util.G_ENTITY_CHANGE

4816:
4817: Eng_Propagation_Log_Util.add_entity_map(
4818: p_change_id => p_change_id
4819: , p_local_organization_id => p_local_organization_id
4820: , p_entity_name => Eng_Propagation_Log_Util.G_ENTITY_CHANGE
4821: , p_entity_action_status => Eng_Propagation_Log_Util.G_PRP_PRC_STS_ERROR
4822: , p_bo_entity_identifier => 'ECO'--Eco_Error_Handler.G_ECO_LEVEL
4823: );
4824:

Line 4821: , p_entity_action_status => Eng_Propagation_Log_Util.G_PRP_PRC_STS_ERROR

4817: Eng_Propagation_Log_Util.add_entity_map(
4818: p_change_id => p_change_id
4819: , p_local_organization_id => p_local_organization_id
4820: , p_entity_name => Eng_Propagation_Log_Util.G_ENTITY_CHANGE
4821: , p_entity_action_status => Eng_Propagation_Log_Util.G_PRP_PRC_STS_ERROR
4822: , p_bo_entity_identifier => 'ECO'--Eco_Error_Handler.G_ECO_LEVEL
4823: );
4824:
4825: -- WHEN OTHERS THEN

Line 4967: AND ecpm.revised_line_type = Eng_Propagation_Log_Util.G_REV_LINE_CMP_CHG

4963: AND erc.revised_item_sequence_id = cp_revised_item_sequence_id
4964: AND NOT EXISTS (SELECT 1 FROM eng_change_propagation_maps ecpm
4965: WHERE ecpm.change_id = p_change_id
4966: AND ecpm.local_organization_id = p_local_organization_id
4967: AND ecpm.revised_line_type = Eng_Propagation_Log_Util.G_REV_LINE_CMP_CHG
4968: AND ecpm.revised_line_id1 = erc.component_sequence_id
4969: AND ecpm.entity_action_status IN (3,4))
4970: AND EXISTS (SELECT 1 FROM eng_revised_items eri
4971: WHERE eri.revised_item_sequence_id = erc.revised_item_sequence_id

Line 4986: AND ecpm.revised_line_type = Eng_Propagation_Log_Util.G_REV_LINE_CMP_CHG

4982: AND revised_item_sequence_id = cp_revised_item_sequence_id
4983: AND NOT EXISTS (SELECT 1 FROM eng_change_propagation_maps ecpm
4984: WHERE ecpm.change_id = p_change_id
4985: AND ecpm.local_organization_id = p_local_organization_id
4986: AND ecpm.revised_line_type = Eng_Propagation_Log_Util.G_REV_LINE_CMP_CHG
4987: AND ecpm.revised_line_id1 = bcb.component_sequence_id
4988: AND ecpm.entity_action_status IN (3,4))
4989: AND EXISTS (SELECT 1 FROM eng_revised_items eri
4990: WHERE eri.revised_item_sequence_id = bcb.revised_item_sequence_id

Line 4994: Eng_Propagation_Log_Util.Debug_Log(G_LOG_PROC, 'Propagate_Revised_Item.BEGIN');

4990: WHERE eri.revised_item_sequence_id = bcb.revised_item_sequence_id
4991: AND eri.bill_sequence_id = bcb.bill_sequence_id);
4992:
4993: BEGIN
4994: Eng_Propagation_Log_Util.Debug_Log(G_LOG_PROC, 'Propagate_Revised_Item.BEGIN');
4995: -- Step 1:
4996: -- Initialize
4997: l_propagate_revised_item := G_VAL_TRUE;
4998: l_transfer_item_enable := G_VAL_FALSE;

Line 5054: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Start revised item processing p_revised_item_sequence_id'|| p_revised_item_sequence_id);

5050: -- This will be used only when the functionality of parent_revised_item_seq_id
5051: -- gets defined. Currently not been scoped.
5052: FOR ri in c_rev_items_all (p_revised_item_sequence_id)
5053: LOOP
5054: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Start revised item processing p_revised_item_sequence_id'|| p_revised_item_sequence_id);
5055: IF (l_sourcing_rules_exists = 2
5056: OR (l_sourcing_rules_exists = 1 AND ri.parent_revised_item_seq_id IS NULL)
5057: OR (l_sourcing_rules_exists = 1 AND ri.parent_revised_item_seq_id IS NOT NULL AND ri.transfer_or_copy IS NOT NULL))
5058: THEN

Line 5400: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'After processing revised item through BO return status is '||l_return_status);

5396: , x_return_status => l_return_status
5397: , x_disable_revision => l_disable_revision
5398: );
5399:
5400: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'After processing revised item through BO return status is '||l_return_status);
5401: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
5402: THEN
5403: RAISE EXC_EXP_SKIP_OBJECT;
5404: END IF;

Line 5527: Eng_Propagation_Log_Util.add_entity_map(

5523: , x_rev_operation_tbl => l_rev_operation_tbl --L1
5524: , x_rev_op_resource_tbl => l_rev_op_resource_tbl --L1
5525: , x_rev_sub_resource_tbl => l_rev_sub_resource_tbl --L1
5526: );
5527: Eng_Propagation_Log_Util.add_entity_map(
5528: p_change_id => p_change_id
5529: , p_revised_item_sequence_id => p_revised_item_sequence_id
5530: , p_local_organization_id => p_local_organization_id
5531: , p_local_revised_item_seq_id => l_revised_item_unexp_rec.revised_item_sequence_id

Line 5532: , p_entity_name => Eng_Propagation_Log_Util.G_ENTITY_REVISED_ITEM

5528: p_change_id => p_change_id
5529: , p_revised_item_sequence_id => p_revised_item_sequence_id
5530: , p_local_organization_id => p_local_organization_id
5531: , p_local_revised_item_seq_id => l_revised_item_unexp_rec.revised_item_sequence_id
5532: , p_entity_name => Eng_Propagation_Log_Util.G_ENTITY_REVISED_ITEM
5533: , p_entity_action_status => Eng_Propagation_Log_Util.G_PRP_PRC_STS_SUCCESS
5534: , p_bo_entity_identifier => 'RI'--Eco_Error_Handler.G_RI_LEVEL
5535: );
5536: CLOSE c_revised_items_data;

Line 5533: , p_entity_action_status => Eng_Propagation_Log_Util.G_PRP_PRC_STS_SUCCESS

5529: , p_revised_item_sequence_id => p_revised_item_sequence_id
5530: , p_local_organization_id => p_local_organization_id
5531: , p_local_revised_item_seq_id => l_revised_item_unexp_rec.revised_item_sequence_id
5532: , p_entity_name => Eng_Propagation_Log_Util.G_ENTITY_REVISED_ITEM
5533: , p_entity_action_status => Eng_Propagation_Log_Util.G_PRP_PRC_STS_SUCCESS
5534: , p_bo_entity_identifier => 'RI'--Eco_Error_Handler.G_RI_LEVEL
5535: );
5536: CLOSE c_revised_items_data;
5537:

Line 5540: Eng_Propagation_Log_Util.Debug_Log(G_LOG_PROC, 'Propagate_Revised_Item.END');

5536: CLOSE c_revised_items_data;
5537:
5538: x_return_status := l_return_status;
5539:
5540: Eng_Propagation_Log_Util.Debug_Log(G_LOG_PROC, 'Propagate_Revised_Item.END');
5541: EXCEPTION
5542: WHEN EXC_EXP_SKIP_OBJECT THEN
5543: IF c_revised_items_data%ISOPEN
5544: THEN

Line 5571: Eng_Propagation_Log_Util.add_entity_map(

5567: , x_rev_operation_tbl => l_rev_operation_tbl --L1
5568: , x_rev_op_resource_tbl => l_rev_op_resource_tbl --L1
5569: , x_rev_sub_resource_tbl => l_rev_sub_resource_tbl --L1
5570: );
5571: Eng_Propagation_Log_Util.add_entity_map(
5572: p_change_id => p_change_id
5573: , p_revised_item_sequence_id => p_revised_item_sequence_id
5574: , p_local_organization_id => p_local_organization_id
5575: , p_entity_name => Eng_Propagation_Log_Util.G_ENTITY_REVISED_ITEM

Line 5575: , p_entity_name => Eng_Propagation_Log_Util.G_ENTITY_REVISED_ITEM

5571: Eng_Propagation_Log_Util.add_entity_map(
5572: p_change_id => p_change_id
5573: , p_revised_item_sequence_id => p_revised_item_sequence_id
5574: , p_local_organization_id => p_local_organization_id
5575: , p_entity_name => Eng_Propagation_Log_Util.G_ENTITY_REVISED_ITEM
5576: , p_entity_action_status => Eng_Propagation_Log_Util.G_PRP_PRC_STS_ERROR
5577: , p_bo_entity_identifier => 'RI'--Eco_Error_Handler.G_RI_LEVEL
5578: );
5579: x_return_status := l_return_status;

Line 5576: , p_entity_action_status => Eng_Propagation_Log_Util.G_PRP_PRC_STS_ERROR

5572: p_change_id => p_change_id
5573: , p_revised_item_sequence_id => p_revised_item_sequence_id
5574: , p_local_organization_id => p_local_organization_id
5575: , p_entity_name => Eng_Propagation_Log_Util.G_ENTITY_REVISED_ITEM
5576: , p_entity_action_status => Eng_Propagation_Log_Util.G_PRP_PRC_STS_ERROR
5577: , p_bo_entity_identifier => 'RI'--Eco_Error_Handler.G_RI_LEVEL
5578: );
5579: x_return_status := l_return_status;
5580: --

Line 5584: Eng_Propagation_Log_Util.Debug_Log(G_LOG_PROC, 'Propagate_Revised_Item.END');

5580: --
5581: -- Rollback any changes that may have been made to the DB
5582: --
5583: ROLLBACK TO BEGIN_REV_ITEM_PROCESSING;
5584: Eng_Propagation_Log_Util.Debug_Log(G_LOG_PROC, 'Propagate_Revised_Item.END');
5585: WHEN OTHERS THEN
5586: IF c_revised_items_data%ISOPEN
5587: THEN
5588: CLOSE c_revised_items_data;

Line 5622: Eng_Propagation_Log_Util.add_entity_map(

5618: , x_rev_op_resource_tbl => l_rev_op_resource_tbl --L1
5619: , x_rev_sub_resource_tbl => l_rev_sub_resource_tbl --L1
5620: );
5621:
5622: Eng_Propagation_Log_Util.add_entity_map(
5623: p_change_id => p_change_id
5624: , p_revised_item_sequence_id => p_revised_item_sequence_id
5625: , p_local_organization_id => p_local_organization_id
5626: , p_entity_name => Eng_Propagation_Log_Util.G_ENTITY_REVISED_ITEM

Line 5626: , p_entity_name => Eng_Propagation_Log_Util.G_ENTITY_REVISED_ITEM

5622: Eng_Propagation_Log_Util.add_entity_map(
5623: p_change_id => p_change_id
5624: , p_revised_item_sequence_id => p_revised_item_sequence_id
5625: , p_local_organization_id => p_local_organization_id
5626: , p_entity_name => Eng_Propagation_Log_Util.G_ENTITY_REVISED_ITEM
5627: , p_entity_action_status => Eng_Propagation_Log_Util.G_PRP_PRC_STS_ERROR
5628: , p_bo_entity_identifier => 'RI'--Eco_Error_Handler.G_RI_LEVEL
5629: );
5630: x_return_status := l_return_status;

Line 5627: , p_entity_action_status => Eng_Propagation_Log_Util.G_PRP_PRC_STS_ERROR

5623: p_change_id => p_change_id
5624: , p_revised_item_sequence_id => p_revised_item_sequence_id
5625: , p_local_organization_id => p_local_organization_id
5626: , p_entity_name => Eng_Propagation_Log_Util.G_ENTITY_REVISED_ITEM
5627: , p_entity_action_status => Eng_Propagation_Log_Util.G_PRP_PRC_STS_ERROR
5628: , p_bo_entity_identifier => 'RI'--Eco_Error_Handler.G_RI_LEVEL
5629: );
5630: x_return_status := l_return_status;
5631: --

Line 5726: AND ecpm.entity_name = Eng_Propagation_Log_Util.G_ENTITY_REVISED_ITEM

5722: FROM eng_change_propagation_maps ecpm
5723: WHERE ecpm.change_id = eri.change_id
5724: AND ecpm.local_organization_id = p_local_organization_id
5725: AND ecpm.revised_item_sequence_id = eri.revised_item_sequence_id
5726: AND ecpm.entity_name = Eng_Propagation_Log_Util.G_ENTITY_REVISED_ITEM
5727: AND ecpm.entity_action_status IN (Eng_Propagation_Log_Util.G_PRP_PRC_STS_SUCCESS, Eng_Propagation_Log_Util.G_PRP_PRC_STS_EXCL_TTM));
5728:
5729: BEGIN
5730: Eng_Propagation_Log_Util.Debug_Log(G_LOG_PROC, 'PROPAGATE_ECO_PLM.Begin For Organization: '|| l_org_code);

Line 5727: AND ecpm.entity_action_status IN (Eng_Propagation_Log_Util.G_PRP_PRC_STS_SUCCESS, Eng_Propagation_Log_Util.G_PRP_PRC_STS_EXCL_TTM));

5723: WHERE ecpm.change_id = eri.change_id
5724: AND ecpm.local_organization_id = p_local_organization_id
5725: AND ecpm.revised_item_sequence_id = eri.revised_item_sequence_id
5726: AND ecpm.entity_name = Eng_Propagation_Log_Util.G_ENTITY_REVISED_ITEM
5727: AND ecpm.entity_action_status IN (Eng_Propagation_Log_Util.G_PRP_PRC_STS_SUCCESS, Eng_Propagation_Log_Util.G_PRP_PRC_STS_EXCL_TTM));
5728:
5729: BEGIN
5730: Eng_Propagation_Log_Util.Debug_Log(G_LOG_PROC, 'PROPAGATE_ECO_PLM.Begin For Organization: '|| l_org_code);
5731: -- Standard call to check for call compatibility

Line 5730: Eng_Propagation_Log_Util.Debug_Log(G_LOG_PROC, 'PROPAGATE_ECO_PLM.Begin For Organization: '|| l_org_code);

5726: AND ecpm.entity_name = Eng_Propagation_Log_Util.G_ENTITY_REVISED_ITEM
5727: AND ecpm.entity_action_status IN (Eng_Propagation_Log_Util.G_PRP_PRC_STS_SUCCESS, Eng_Propagation_Log_Util.G_PRP_PRC_STS_EXCL_TTM));
5728:
5729: BEGIN
5730: Eng_Propagation_Log_Util.Debug_Log(G_LOG_PROC, 'PROPAGATE_ECO_PLM.Begin For Organization: '|| l_org_code);
5731: -- Standard call to check for call compatibility
5732: IF NOT FND_API.Compatible_API_Call ( l_api_version
5733: , p_api_version
5734: , l_api_name

Line 5782: l_top_entity_process_status := Eng_Propagation_Log_Util.G_PRP_PRC_STS_ERROR;

5778: , x_Return_Status => l_return_status
5779: );
5780: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
5781: THEN
5782: l_top_entity_process_status := Eng_Propagation_Log_Util.G_PRP_PRC_STS_ERROR;
5783: RAISE EXC_EXP_SKIP_OBJECT;
5784: END IF;
5785: END IF; -- **** END of p_calling_API <> 'TTM' **** --
5786:

Line 5802: Eng_Propagation_Log_Util.Debug_Log(G_LOG_PROC, 'PROPAGATE_ECO_PLM.End For Organization: '|| l_org_code);

5798: , x_local_change_id => l_local_change_id
5799: );
5800: IF (l_local_change_id IS NULL)
5801: THEN
5802: Eng_Propagation_Log_Util.Debug_Log(G_LOG_PROC, 'PROPAGATE_ECO_PLM.End For Organization: '|| l_org_code);
5803: RETURN;
5804: END IF;
5805: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Value x_local_change_id: '|| l_local_change_id);
5806: Initialize_Business_object(

Line 5805: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Value x_local_change_id: '|| l_local_change_id);

5801: THEN
5802: Eng_Propagation_Log_Util.Debug_Log(G_LOG_PROC, 'PROPAGATE_ECO_PLM.End For Organization: '|| l_org_code);
5803: RETURN;
5804: END IF;
5805: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Value x_local_change_id: '|| l_local_change_id);
5806: Initialize_Business_object(
5807: p_debug => 'N'
5808: , p_debug_filename => ''
5809: , p_output_dir => ''

Line 5829: l_top_entity_process_status := Eng_Propagation_Log_Util.G_PRP_PRC_STS_ERROR;

5825: , x_Return_Status => l_return_status
5826: );
5827: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
5828: THEN
5829: l_top_entity_process_status := Eng_Propagation_Log_Util.G_PRP_PRC_STS_ERROR;
5830: END IF;
5831: END LOOP;
5832: Reset_Business_Object;
5833: IF l_top_entity_process_status = Eng_Propagation_Log_Util.G_PRP_PRC_STS_ERROR

Line 5833: IF l_top_entity_process_status = Eng_Propagation_Log_Util.G_PRP_PRC_STS_ERROR

5829: l_top_entity_process_status := Eng_Propagation_Log_Util.G_PRP_PRC_STS_ERROR;
5830: END IF;
5831: END LOOP;
5832: Reset_Business_Object;
5833: IF l_top_entity_process_status = Eng_Propagation_Log_Util.G_PRP_PRC_STS_ERROR
5834: THEN
5835: RAISE EXC_EXP_SKIP_OBJECT;
5836: END IF;
5837:

Line 6179: Eng_Propagation_Log_Util.add_entity_map(

6175: );
6176: -- Not doing anythig for processing the Init_Local_Change_Lifecycle return status as
6177: -- the changes to the change order in local org can go through .user can then
6178: -- manually init the lifecycle if required
6179: Eng_Propagation_Log_Util.add_entity_map(
6180: p_change_id => l_global_change_id
6181: , p_local_organization_id => p_local_organization_id
6182: , p_entity_name => Eng_Propagation_Log_Util.G_ENTITY_CHANGE
6183: , p_entity_action_status => Eng_Propagation_Log_Util.G_PRP_PRC_STS_SUCCESS

Line 6182: , p_entity_name => Eng_Propagation_Log_Util.G_ENTITY_CHANGE

6178: -- manually init the lifecycle if required
6179: Eng_Propagation_Log_Util.add_entity_map(
6180: p_change_id => l_global_change_id
6181: , p_local_organization_id => p_local_organization_id
6182: , p_entity_name => Eng_Propagation_Log_Util.G_ENTITY_CHANGE
6183: , p_entity_action_status => Eng_Propagation_Log_Util.G_PRP_PRC_STS_SUCCESS
6184: , p_bo_entity_identifier => 'ECO'--Eco_Error_Handler.G_ECO_LEVEL
6185: );
6186: EXCEPTION

Line 6183: , p_entity_action_status => Eng_Propagation_Log_Util.G_PRP_PRC_STS_SUCCESS

6179: Eng_Propagation_Log_Util.add_entity_map(
6180: p_change_id => l_global_change_id
6181: , p_local_organization_id => p_local_organization_id
6182: , p_entity_name => Eng_Propagation_Log_Util.G_ENTITY_CHANGE
6183: , p_entity_action_status => Eng_Propagation_Log_Util.G_PRP_PRC_STS_SUCCESS
6184: , p_bo_entity_identifier => 'ECO'--Eco_Error_Handler.G_ECO_LEVEL
6185: );
6186: EXCEPTION
6187: WHEN EXC_EXP_SKIP_OBJECT THEN

Line 6188: Eng_Propagation_Log_Util.add_entity_map(

6184: , p_bo_entity_identifier => 'ECO'--Eco_Error_Handler.G_ECO_LEVEL
6185: );
6186: EXCEPTION
6187: WHEN EXC_EXP_SKIP_OBJECT THEN
6188: Eng_Propagation_Log_Util.add_entity_map(
6189: p_change_id => l_global_change_id
6190: , p_local_organization_id => p_local_organization_id
6191: , p_entity_name => Eng_Propagation_Log_Util.G_ENTITY_CHANGE
6192: , p_entity_action_status => Eng_Propagation_Log_Util.G_PRP_PRC_STS_ERROR

Line 6191: , p_entity_name => Eng_Propagation_Log_Util.G_ENTITY_CHANGE

6187: WHEN EXC_EXP_SKIP_OBJECT THEN
6188: Eng_Propagation_Log_Util.add_entity_map(
6189: p_change_id => l_global_change_id
6190: , p_local_organization_id => p_local_organization_id
6191: , p_entity_name => Eng_Propagation_Log_Util.G_ENTITY_CHANGE
6192: , p_entity_action_status => Eng_Propagation_Log_Util.G_PRP_PRC_STS_ERROR
6193: , p_bo_entity_identifier => 'ECO'--Eco_Error_Handler.G_ECO_LEVEL
6194: );
6195: ROLLBACK;

Line 6192: , p_entity_action_status => Eng_Propagation_Log_Util.G_PRP_PRC_STS_ERROR

6188: Eng_Propagation_Log_Util.add_entity_map(
6189: p_change_id => l_global_change_id
6190: , p_local_organization_id => p_local_organization_id
6191: , p_entity_name => Eng_Propagation_Log_Util.G_ENTITY_CHANGE
6192: , p_entity_action_status => Eng_Propagation_Log_Util.G_PRP_PRC_STS_ERROR
6193: , p_bo_entity_identifier => 'ECO'--Eco_Error_Handler.G_ECO_LEVEL
6194: );
6195: ROLLBACK;
6196: WHEN OTHERS THEN

Line 6360: Eng_Propagation_Log_Util.Initialize;

6356: END IF;
6357:
6358: FOR l_org_count IN 2..l_org_code_list.LAST
6359: LOOP
6360: Eng_Propagation_Log_Util.Initialize;
6361: Propagate_ECO_PLM(
6362: x_error_buf => errbuf
6363: , x_return_status => retcode
6364: , p_change_notice => p_change_notice

Line 6370: Eng_Propagation_Log_Util.Write_Propagation_Log;

6366: , p_org_hierarchy_name => p_org_hierarchy_name
6367: , p_local_organization_id => l_org_code_list(l_org_count)
6368: , p_calling_API => p_calling_API
6369: );
6370: Eng_Propagation_Log_Util.Write_Propagation_Log;
6371: commit;
6372:
6373: END LOOP; -- end FOR l_org_count IN 2..l_org_code_list.LAST
6374: ELSE

Line 6487: Eng_Propagation_Log_Util.Check_Entity_Map_Existance (

6483: FOR l_org_count IN 2..l_org_code_list.LAST
6484: LOOP
6485: --
6486: -- Check for header map existance for the change and specific local org
6487: Eng_Propagation_Log_Util.Check_Entity_Map_Existance (
6488: p_change_id => p_change_id
6489: , p_entity_name => Eng_Propagation_Log_Util.G_ENTITY_CHANGE--'ENG_CHANGE'
6490: , p_local_organization_id => l_org_code_list(l_org_count)
6491: , x_change_map_id => l_change_map_id

Line 6489: , p_entity_name => Eng_Propagation_Log_Util.G_ENTITY_CHANGE--'ENG_CHANGE'

6485: --
6486: -- Check for header map existance for the change and specific local org
6487: Eng_Propagation_Log_Util.Check_Entity_Map_Existance (
6488: p_change_id => p_change_id
6489: , p_entity_name => Eng_Propagation_Log_Util.G_ENTITY_CHANGE--'ENG_CHANGE'
6490: , p_local_organization_id => l_org_code_list(l_org_count)
6491: , x_change_map_id => l_change_map_id
6492: );
6493: --

Line 6519: , Eng_Propagation_Log_Util.G_ENTITY_CHANGE--'ENG_CHANGE'

6515: l_CHANGE_MAP_ID
6516: , p_CHANGE_ID
6517: , p_request_id
6518: , l_org_code_list(l_org_count)
6519: , Eng_Propagation_Log_Util.G_ENTITY_CHANGE--'ENG_CHANGE'
6520: , SYSDATE
6521: , FND_GLOBAL.USER_ID
6522: , SYSDATE
6523: , FND_GLOBAL.USER_ID

Line 6525: , Eng_Propagation_Log_Util.G_PRP_PRC_STS_NOACTION

6521: , FND_GLOBAL.USER_ID
6522: , SYSDATE
6523: , FND_GLOBAL.USER_ID
6524: , FND_GLOBAL.LOGIN_ID
6525: , Eng_Propagation_Log_Util.G_PRP_PRC_STS_NOACTION
6526: );
6527: --
6528: -- Else UPDATE
6529: ELSE