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 1232: Eng_Propagation_Log_Util.Debug_Log(G_LOG_PROC, '-------------------------------');

1228: l_Mesg_token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
1229: l_Token_Tbl Error_Handler.Token_Tbl_Type;
1230: BEGIN
1231:
1232: Eng_Propagation_Log_Util.Debug_Log(G_LOG_PROC, '-------------------------------');
1233: Eng_Propagation_Log_Util.Debug_Log(G_LOG_PROC, 'CHECK_REVISED_ITEM_ERRORS.begin');
1234: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_change_notice '|| p_change_notice);
1235: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_global_org_id '|| p_global_org_id);
1236: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_local_org_id '|| p_local_org_id);

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

1229: l_Token_Tbl Error_Handler.Token_Tbl_Type;
1230: BEGIN
1231:
1232: Eng_Propagation_Log_Util.Debug_Log(G_LOG_PROC, '-------------------------------');
1233: Eng_Propagation_Log_Util.Debug_Log(G_LOG_PROC, 'CHECK_REVISED_ITEM_ERRORS.begin');
1234: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_change_notice '|| p_change_notice);
1235: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_global_org_id '|| p_global_org_id);
1236: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_local_org_id '|| p_local_org_id);
1237: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Input Param: p_rev_item_seq_id '|| p_rev_item_seq_id);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1351: 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);

1347: END IF;
1348: END IF;
1349: END IF;
1350:
1351: 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);
1352:
1353: -- If Item does not exist in local organization throw an error
1354: IF (l_item_exists_in_org_flag = 0)
1355: THEN

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

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

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

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

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

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

Line 1395: 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);

1391: x_propagate_strc_changes := G_VAL_TRUE;
1392: --
1393: -- Check if sourcing rules exist for item
1394: l_item_sourced_flag := CHECK_SOURCING_RULES(p_local_org_id , p_revised_item_id);
1395: 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);
1396:
1397: --
1398: -- Check if structure line - bill exists
1399: FOR sl in c_rev_item_struc_lines(p_rev_item_seq_id)

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

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

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

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

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

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

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

1714: x_error_logged := l_error_logged;
1715: x_revised_item_name := l_revised_item_number;
1716: x_Mesg_Token_Tbl := l_mesg_token_tbl;
1717:
1718: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Output Param: p_propagate_revised_item '|| l_item_exists_in_org_flag);
1719: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Output Param: p_sourcing_rules_exists '|| l_item_sourced_flag);
1720: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Output Param: p_error_logged '|| l_error_logged);
1721: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Output Param: p_revised_item_name '|| l_revised_item_number);
1722:

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

1715: x_revised_item_name := l_revised_item_number;
1716: x_Mesg_Token_Tbl := l_mesg_token_tbl;
1717:
1718: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Output Param: p_propagate_revised_item '|| l_item_exists_in_org_flag);
1719: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Output Param: p_sourcing_rules_exists '|| l_item_sourced_flag);
1720: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Output Param: p_error_logged '|| l_error_logged);
1721: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Output Param: p_revised_item_name '|| l_revised_item_number);
1722:
1723: Eng_Propagation_Log_Util.Debug_Log(G_LOG_PROC, 'CHECK_REVISED_ITEM_ERRORS.end');

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

1716: x_Mesg_Token_Tbl := l_mesg_token_tbl;
1717:
1718: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Output Param: p_propagate_revised_item '|| l_item_exists_in_org_flag);
1719: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Output Param: p_sourcing_rules_exists '|| l_item_sourced_flag);
1720: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Output Param: p_error_logged '|| l_error_logged);
1721: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Output Param: p_revised_item_name '|| l_revised_item_number);
1722:
1723: Eng_Propagation_Log_Util.Debug_Log(G_LOG_PROC, 'CHECK_REVISED_ITEM_ERRORS.end');
1724: Eng_Propagation_Log_Util.Debug_Log(G_LOG_PROC, '-------------------------------');

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

1717:
1718: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Output Param: p_propagate_revised_item '|| l_item_exists_in_org_flag);
1719: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Output Param: p_sourcing_rules_exists '|| l_item_sourced_flag);
1720: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Output Param: p_error_logged '|| l_error_logged);
1721: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Output Param: p_revised_item_name '|| l_revised_item_number);
1722:
1723: Eng_Propagation_Log_Util.Debug_Log(G_LOG_PROC, 'CHECK_REVISED_ITEM_ERRORS.end');
1724: Eng_Propagation_Log_Util.Debug_Log(G_LOG_PROC, '-------------------------------');
1725: EXCEPTION

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

1719: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Output Param: p_sourcing_rules_exists '|| l_item_sourced_flag);
1720: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Output Param: p_error_logged '|| l_error_logged);
1721: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Output Param: p_revised_item_name '|| l_revised_item_number);
1722:
1723: Eng_Propagation_Log_Util.Debug_Log(G_LOG_PROC, 'CHECK_REVISED_ITEM_ERRORS.end');
1724: Eng_Propagation_Log_Util.Debug_Log(G_LOG_PROC, '-------------------------------');
1725: EXCEPTION
1726: WHEN OTHERS THEN
1727: Eng_Propagation_Log_Util.Debug_Log(Eng_Propagation_Log_Util.G_LOG_ERROR, 'CHECK_REVISED_ITEM_ERRORS.Unexpected error'|| SQLERRM);

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

1720: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Output Param: p_error_logged '|| l_error_logged);
1721: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Output Param: p_revised_item_name '|| l_revised_item_number);
1722:
1723: Eng_Propagation_Log_Util.Debug_Log(G_LOG_PROC, 'CHECK_REVISED_ITEM_ERRORS.end');
1724: Eng_Propagation_Log_Util.Debug_Log(G_LOG_PROC, '-------------------------------');
1725: EXCEPTION
1726: WHEN OTHERS THEN
1727: Eng_Propagation_Log_Util.Debug_Log(Eng_Propagation_Log_Util.G_LOG_ERROR, 'CHECK_REVISED_ITEM_ERRORS.Unexpected error'|| SQLERRM);
1728: END Check_Revised_Item_Errors;

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

1723: Eng_Propagation_Log_Util.Debug_Log(G_LOG_PROC, 'CHECK_REVISED_ITEM_ERRORS.end');
1724: Eng_Propagation_Log_Util.Debug_Log(G_LOG_PROC, '-------------------------------');
1725: EXCEPTION
1726: WHEN OTHERS THEN
1727: Eng_Propagation_Log_Util.Debug_Log(Eng_Propagation_Log_Util.G_LOG_ERROR, 'CHECK_REVISED_ITEM_ERRORS.Unexpected error'|| SQLERRM);
1728: END Check_Revised_Item_Errors;
1729:
1730: PROCEDURE PROPAGATE_ECO_ERP
1731: (

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

3406: WHERE inventory_item_id = cp_inventory_item_id
3407: AND organization_id = cp_organization_id;
3408: BEGIN
3409: -- Initialize this API for error handling
3410: Eng_Propagation_Log_Util.Debug_Log(G_LOG_PROC, 'Propagate_Revised_Component.BEGIN');
3411: Error_Handler.Initialize;
3412:
3413: l_entity_action_status := Eng_Propagation_Log_Util.G_PRP_PRC_STS_SUCCESS;
3414: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3413: l_entity_action_status := Eng_Propagation_Log_Util.G_PRP_PRC_STS_SUCCESS;

3409: -- Initialize this API for error handling
3410: Eng_Propagation_Log_Util.Debug_Log(G_LOG_PROC, 'Propagate_Revised_Component.BEGIN');
3411: Error_Handler.Initialize;
3412:
3413: l_entity_action_status := Eng_Propagation_Log_Util.G_PRP_PRC_STS_SUCCESS;
3414: l_return_status := FND_API.G_RET_STS_SUCCESS;
3415: -- Strat processing for each component
3416: FOR rc in c_component_details
3417: LOOP

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

3434: -- then it has to be auto enabled in the child organization
3435: -- Proceed to auto enable component
3436: IF rc.acd_type = 1 AND l_comp_exists_in_org = G_VAL_FALSE
3437: THEN
3438: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Component Item Is being auto enabled. rc.component_item_id:'|| rc.component_item_id);
3439: Auto_enable_item_in_org(
3440: p_inventory_item_id => rc.component_item_id
3441: , p_organization_id => p_local_organization_id
3442: , x_error_table => l_item_error_table

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

3440: p_inventory_item_id => rc.component_item_id
3441: , p_organization_id => p_local_organization_id
3442: , x_error_table => l_item_error_table
3443: , x_return_status => l_return_status);
3444: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'After Component Item Is auto enabled. l_return_status'||l_return_status);
3445: IF (l_return_status = FND_API.G_RET_STS_SUCCESS)
3446: THEN
3447: OPEN c_get_item_details(rc.component_item_id, p_local_organization_id);
3448: FETCH c_get_item_details INTO l_component_item_name;

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

3468: CLOSE c_get_item_details;
3469: ELSE
3470: FOR i IN 1..l_item_error_table.COUNT
3471: LOOP
3472: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Component Item Enabling Error:'||l_item_error_table(i).message_name);
3473: Error_Handler.Add_Error_Token(
3474: p_Message_Name => NULL
3475: , p_Message_Text => l_item_error_table(i).message_text
3476: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

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

3683: CLOSE c_get_item_details;
3684: ELSE
3685: FOR i IN 1..l_item_error_table.COUNT
3686: LOOP
3687: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Component Item Enabling Error:'||l_item_error_table(i).message_name);
3688: Error_Handler.Add_Error_Token(
3689: p_Message_Name => NULL
3690: , p_Message_Text => l_item_error_table(i).message_text
3691: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 3843: Eng_Propagation_Log_Util.Add_Entity_Map(

3839: , x_rev_op_resource_tbl => ENG_Eco_PUB.G_MISS_REV_OP_RESOURCE_TBL
3840: , x_rev_sub_resource_tbl => ENG_Eco_PUB.G_MISS_REV_SUB_RESOURCE_TBL
3841: );
3842:
3843: Eng_Propagation_Log_Util.Add_Entity_Map(
3844: p_change_id => p_change_id
3845: , p_revised_item_sequence_id => p_revised_item_sequence_id
3846: , p_revised_line_type => Eng_Propagation_Log_Util.G_REV_LINE_CMP_CHG
3847: , p_revised_line_id1 => p_component_sequence_id

Line 3846: , p_revised_line_type => Eng_Propagation_Log_Util.G_REV_LINE_CMP_CHG

3842:
3843: Eng_Propagation_Log_Util.Add_Entity_Map(
3844: p_change_id => p_change_id
3845: , p_revised_item_sequence_id => p_revised_item_sequence_id
3846: , p_revised_line_type => Eng_Propagation_Log_Util.G_REV_LINE_CMP_CHG
3847: , p_revised_line_id1 => p_component_sequence_id
3848: , p_local_organization_id => p_local_organization_id
3849: , p_local_revised_item_seq_id => p_revised_item_unexp_rec.revised_item_sequence_id
3850: , p_local_revised_line_id1 => l_rev_comp_unexp_rec.component_sequence_id

Line 3851: , p_entity_name => Eng_Propagation_Log_Util.G_ENTITY_REVISED_LINE

3847: , p_revised_line_id1 => p_component_sequence_id
3848: , p_local_organization_id => p_local_organization_id
3849: , p_local_revised_item_seq_id => p_revised_item_unexp_rec.revised_item_sequence_id
3850: , p_local_revised_line_id1 => l_rev_comp_unexp_rec.component_sequence_id
3851: , p_entity_name => Eng_Propagation_Log_Util.G_ENTITY_REVISED_LINE
3852: , p_entity_action_status => l_entity_action_status
3853: , p_bo_entity_identifier => 'RC'--Eco_Error_Handler.G_RC_LEVEL
3854: );
3855: -- TODO: How to handle substitue component and reference designator errors

Line 3881: Eng_Propagation_Log_Util.add_entity_map(

3877: );
3878: -- local change id is set later
3879: -- if there are errors, based on the level they are not populated in the
3880: -- maps table.
3881: Eng_Propagation_Log_Util.add_entity_map(
3882: p_change_id => p_change_id
3883: , p_revised_item_sequence_id => p_revised_item_sequence_id
3884: , p_revised_line_type => Eng_Propagation_Log_Util.G_REV_LINE_CMP_CHG
3885: , p_revised_line_id1 => p_component_sequence_id

Line 3884: , p_revised_line_type => Eng_Propagation_Log_Util.G_REV_LINE_CMP_CHG

3880: -- maps table.
3881: Eng_Propagation_Log_Util.add_entity_map(
3882: p_change_id => p_change_id
3883: , p_revised_item_sequence_id => p_revised_item_sequence_id
3884: , p_revised_line_type => Eng_Propagation_Log_Util.G_REV_LINE_CMP_CHG
3885: , p_revised_line_id1 => p_component_sequence_id
3886: , p_local_organization_id => p_local_organization_id
3887: , p_entity_name => Eng_Propagation_Log_Util.G_ENTITY_REVISED_LINE
3888: , p_entity_action_status => Eng_Propagation_Log_Util.G_PRP_PRC_STS_ERROR

Line 3887: , p_entity_name => Eng_Propagation_Log_Util.G_ENTITY_REVISED_LINE

3883: , p_revised_item_sequence_id => p_revised_item_sequence_id
3884: , p_revised_line_type => Eng_Propagation_Log_Util.G_REV_LINE_CMP_CHG
3885: , p_revised_line_id1 => p_component_sequence_id
3886: , p_local_organization_id => p_local_organization_id
3887: , p_entity_name => Eng_Propagation_Log_Util.G_ENTITY_REVISED_LINE
3888: , p_entity_action_status => Eng_Propagation_Log_Util.G_PRP_PRC_STS_ERROR
3889: , p_bo_entity_identifier => 'RC'--Eco_Error_Handler.G_RC_LEVEL
3890: );
3891: x_return_status := l_return_status;

Line 3888: , p_entity_action_status => Eng_Propagation_Log_Util.G_PRP_PRC_STS_ERROR

3884: , p_revised_line_type => Eng_Propagation_Log_Util.G_REV_LINE_CMP_CHG
3885: , p_revised_line_id1 => p_component_sequence_id
3886: , p_local_organization_id => p_local_organization_id
3887: , p_entity_name => Eng_Propagation_Log_Util.G_ENTITY_REVISED_LINE
3888: , p_entity_action_status => Eng_Propagation_Log_Util.G_PRP_PRC_STS_ERROR
3889: , p_bo_entity_identifier => 'RC'--Eco_Error_Handler.G_RC_LEVEL
3890: );
3891: x_return_status := l_return_status;
3892: END Propagate_Revised_Component;

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

4629: , x_rev_operation_tbl => l_rev_operation_tbl
4630: , x_rev_op_resource_tbl => l_rev_op_resource_tbl
4631: , x_rev_sub_resource_tbl => l_rev_sub_resource_tbl
4632: );
4633: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'After Propagation ECO l_return_status'|| l_return_status);
4634:
4635: IF l_return_status = FND_API.G_RET_STS_SUCCESS
4636: THEN
4637:

Line 4691: Eng_Propagation_Log_Util.add_entity_map(

4687: , x_rev_op_resource_tbl => l_rev_op_resource_tbl --L1
4688: , x_rev_sub_resource_tbl => l_rev_sub_resource_tbl --L1
4689: );
4690:
4691: Eng_Propagation_Log_Util.add_entity_map(
4692: p_change_id => p_change_id
4693: , p_local_organization_id => p_local_organization_id
4694: , p_entity_name => Eng_Propagation_Log_Util.G_ENTITY_CHANGE
4695: , p_entity_action_status => Eng_Propagation_Log_Util.G_PRP_PRC_STS_ERROR

Line 4694: , p_entity_name => Eng_Propagation_Log_Util.G_ENTITY_CHANGE

4690:
4691: Eng_Propagation_Log_Util.add_entity_map(
4692: p_change_id => p_change_id
4693: , p_local_organization_id => p_local_organization_id
4694: , p_entity_name => Eng_Propagation_Log_Util.G_ENTITY_CHANGE
4695: , p_entity_action_status => Eng_Propagation_Log_Util.G_PRP_PRC_STS_ERROR
4696: , p_bo_entity_identifier => 'ECO'--Eco_Error_Handler.G_ECO_LEVEL
4697: );
4698:

Line 4695: , p_entity_action_status => Eng_Propagation_Log_Util.G_PRP_PRC_STS_ERROR

4691: Eng_Propagation_Log_Util.add_entity_map(
4692: p_change_id => p_change_id
4693: , p_local_organization_id => p_local_organization_id
4694: , p_entity_name => Eng_Propagation_Log_Util.G_ENTITY_CHANGE
4695: , p_entity_action_status => Eng_Propagation_Log_Util.G_PRP_PRC_STS_ERROR
4696: , p_bo_entity_identifier => 'ECO'--Eco_Error_Handler.G_ECO_LEVEL
4697: );
4698:
4699: -- WHEN OTHERS THEN

Line 4840: AND ecpm.revised_line_type = Eng_Propagation_Log_Util.G_REV_LINE_CMP_CHG

4836: AND erc.revised_item_sequence_id = cp_revised_item_sequence_id
4837: AND NOT EXISTS (SELECT 1 FROM eng_change_propagation_maps ecpm
4838: WHERE ecpm.change_id = p_change_id
4839: AND ecpm.local_organization_id = p_local_organization_id
4840: AND ecpm.revised_line_type = Eng_Propagation_Log_Util.G_REV_LINE_CMP_CHG
4841: AND ecpm.revised_line_id1 = erc.component_sequence_id
4842: AND ecpm.entity_action_status IN (3,4))
4843: AND EXISTS (SELECT 1 FROM eng_revised_items eri
4844: WHERE eri.revised_item_sequence_id = erc.revised_item_sequence_id

Line 4859: AND ecpm.revised_line_type = Eng_Propagation_Log_Util.G_REV_LINE_CMP_CHG

4855: AND revised_item_sequence_id = cp_revised_item_sequence_id
4856: AND NOT EXISTS (SELECT 1 FROM eng_change_propagation_maps ecpm
4857: WHERE ecpm.change_id = p_change_id
4858: AND ecpm.local_organization_id = p_local_organization_id
4859: AND ecpm.revised_line_type = Eng_Propagation_Log_Util.G_REV_LINE_CMP_CHG
4860: AND ecpm.revised_line_id1 = bcb.component_sequence_id
4861: AND ecpm.entity_action_status IN (3,4))
4862: AND EXISTS (SELECT 1 FROM eng_revised_items eri
4863: WHERE eri.revised_item_sequence_id = bcb.revised_item_sequence_id

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

4863: WHERE eri.revised_item_sequence_id = bcb.revised_item_sequence_id
4864: AND eri.bill_sequence_id = bcb.bill_sequence_id);
4865:
4866: BEGIN
4867: Eng_Propagation_Log_Util.Debug_Log(G_LOG_PROC, 'Propagate_Revised_Item.BEGIN');
4868: -- Step 1:
4869: -- Initialize
4870: l_propagate_revised_item := G_VAL_TRUE;
4871: l_transfer_item_enable := G_VAL_FALSE;

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

4923: -- This will be used only when the functionality of parent_revised_item_seq_id
4924: -- gets defined. Currently not been scoped.
4925: FOR ri in c_rev_items_all (p_revised_item_sequence_id)
4926: LOOP
4927: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Start revised item processing p_revised_item_sequence_id'|| p_revised_item_sequence_id);
4928: IF (l_sourcing_rules_exists = 2
4929: OR (l_sourcing_rules_exists = 1 AND ri.parent_revised_item_seq_id IS NULL)
4930: OR (l_sourcing_rules_exists = 1 AND ri.parent_revised_item_seq_id IS NOT NULL AND ri.transfer_or_copy IS NOT NULL))
4931: THEN

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

5268: , x_return_status => l_return_status
5269: , x_disable_revision => l_disable_revision
5270: );
5271:
5272: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'After processing revised item through BO return status is '||l_return_status);
5273: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
5274: THEN
5275: RAISE EXC_EXP_SKIP_OBJECT;
5276: END IF;

Line 5399: Eng_Propagation_Log_Util.add_entity_map(

5395: , x_rev_operation_tbl => l_rev_operation_tbl --L1
5396: , x_rev_op_resource_tbl => l_rev_op_resource_tbl --L1
5397: , x_rev_sub_resource_tbl => l_rev_sub_resource_tbl --L1
5398: );
5399: Eng_Propagation_Log_Util.add_entity_map(
5400: p_change_id => p_change_id
5401: , p_revised_item_sequence_id => p_revised_item_sequence_id
5402: , p_local_organization_id => p_local_organization_id
5403: , p_local_revised_item_seq_id => l_revised_item_unexp_rec.revised_item_sequence_id

Line 5404: , p_entity_name => Eng_Propagation_Log_Util.G_ENTITY_REVISED_ITEM

5400: p_change_id => p_change_id
5401: , p_revised_item_sequence_id => p_revised_item_sequence_id
5402: , p_local_organization_id => p_local_organization_id
5403: , p_local_revised_item_seq_id => l_revised_item_unexp_rec.revised_item_sequence_id
5404: , p_entity_name => Eng_Propagation_Log_Util.G_ENTITY_REVISED_ITEM
5405: , p_entity_action_status => Eng_Propagation_Log_Util.G_PRP_PRC_STS_SUCCESS
5406: , p_bo_entity_identifier => 'RI'--Eco_Error_Handler.G_RI_LEVEL
5407: );
5408: CLOSE c_revised_items_data;

Line 5405: , p_entity_action_status => Eng_Propagation_Log_Util.G_PRP_PRC_STS_SUCCESS

5401: , p_revised_item_sequence_id => p_revised_item_sequence_id
5402: , p_local_organization_id => p_local_organization_id
5403: , p_local_revised_item_seq_id => l_revised_item_unexp_rec.revised_item_sequence_id
5404: , p_entity_name => Eng_Propagation_Log_Util.G_ENTITY_REVISED_ITEM
5405: , p_entity_action_status => Eng_Propagation_Log_Util.G_PRP_PRC_STS_SUCCESS
5406: , p_bo_entity_identifier => 'RI'--Eco_Error_Handler.G_RI_LEVEL
5407: );
5408: CLOSE c_revised_items_data;
5409:

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

5408: CLOSE c_revised_items_data;
5409:
5410: x_return_status := l_return_status;
5411:
5412: Eng_Propagation_Log_Util.Debug_Log(G_LOG_PROC, 'Propagate_Revised_Item.END');
5413: EXCEPTION
5414: WHEN EXC_EXP_SKIP_OBJECT THEN
5415: IF c_revised_items_data%ISOPEN
5416: THEN

Line 5443: Eng_Propagation_Log_Util.add_entity_map(

5439: , x_rev_operation_tbl => l_rev_operation_tbl --L1
5440: , x_rev_op_resource_tbl => l_rev_op_resource_tbl --L1
5441: , x_rev_sub_resource_tbl => l_rev_sub_resource_tbl --L1
5442: );
5443: Eng_Propagation_Log_Util.add_entity_map(
5444: p_change_id => p_change_id
5445: , p_revised_item_sequence_id => p_revised_item_sequence_id
5446: , p_local_organization_id => p_local_organization_id
5447: , p_entity_name => Eng_Propagation_Log_Util.G_ENTITY_REVISED_ITEM

Line 5447: , p_entity_name => Eng_Propagation_Log_Util.G_ENTITY_REVISED_ITEM

5443: Eng_Propagation_Log_Util.add_entity_map(
5444: p_change_id => p_change_id
5445: , p_revised_item_sequence_id => p_revised_item_sequence_id
5446: , p_local_organization_id => p_local_organization_id
5447: , p_entity_name => Eng_Propagation_Log_Util.G_ENTITY_REVISED_ITEM
5448: , p_entity_action_status => Eng_Propagation_Log_Util.G_PRP_PRC_STS_ERROR
5449: , p_bo_entity_identifier => 'RI'--Eco_Error_Handler.G_RI_LEVEL
5450: );
5451: x_return_status := l_return_status;

Line 5448: , p_entity_action_status => Eng_Propagation_Log_Util.G_PRP_PRC_STS_ERROR

5444: p_change_id => p_change_id
5445: , p_revised_item_sequence_id => p_revised_item_sequence_id
5446: , p_local_organization_id => p_local_organization_id
5447: , p_entity_name => Eng_Propagation_Log_Util.G_ENTITY_REVISED_ITEM
5448: , p_entity_action_status => Eng_Propagation_Log_Util.G_PRP_PRC_STS_ERROR
5449: , p_bo_entity_identifier => 'RI'--Eco_Error_Handler.G_RI_LEVEL
5450: );
5451: x_return_status := l_return_status;
5452: --

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

5452: --
5453: -- Rollback any changes that may have been made to the DB
5454: --
5455: ROLLBACK TO BEGIN_REV_ITEM_PROCESSING;
5456: Eng_Propagation_Log_Util.Debug_Log(G_LOG_PROC, 'Propagate_Revised_Item.END');
5457: WHEN OTHERS THEN
5458: IF c_revised_items_data%ISOPEN
5459: THEN
5460: CLOSE c_revised_items_data;

Line 5494: Eng_Propagation_Log_Util.add_entity_map(

5490: , x_rev_op_resource_tbl => l_rev_op_resource_tbl --L1
5491: , x_rev_sub_resource_tbl => l_rev_sub_resource_tbl --L1
5492: );
5493:
5494: Eng_Propagation_Log_Util.add_entity_map(
5495: p_change_id => p_change_id
5496: , p_revised_item_sequence_id => p_revised_item_sequence_id
5497: , p_local_organization_id => p_local_organization_id
5498: , p_entity_name => Eng_Propagation_Log_Util.G_ENTITY_REVISED_ITEM

Line 5498: , p_entity_name => Eng_Propagation_Log_Util.G_ENTITY_REVISED_ITEM

5494: Eng_Propagation_Log_Util.add_entity_map(
5495: p_change_id => p_change_id
5496: , p_revised_item_sequence_id => p_revised_item_sequence_id
5497: , p_local_organization_id => p_local_organization_id
5498: , p_entity_name => Eng_Propagation_Log_Util.G_ENTITY_REVISED_ITEM
5499: , p_entity_action_status => Eng_Propagation_Log_Util.G_PRP_PRC_STS_ERROR
5500: , p_bo_entity_identifier => 'RI'--Eco_Error_Handler.G_RI_LEVEL
5501: );
5502: x_return_status := l_return_status;

Line 5499: , p_entity_action_status => Eng_Propagation_Log_Util.G_PRP_PRC_STS_ERROR

5495: p_change_id => p_change_id
5496: , p_revised_item_sequence_id => p_revised_item_sequence_id
5497: , p_local_organization_id => p_local_organization_id
5498: , p_entity_name => Eng_Propagation_Log_Util.G_ENTITY_REVISED_ITEM
5499: , p_entity_action_status => Eng_Propagation_Log_Util.G_PRP_PRC_STS_ERROR
5500: , p_bo_entity_identifier => 'RI'--Eco_Error_Handler.G_RI_LEVEL
5501: );
5502: x_return_status := l_return_status;
5503: --

Line 5585: AND ecpm.entity_name = Eng_Propagation_Log_Util.G_ENTITY_REVISED_ITEM

5581: FROM eng_change_propagation_maps ecpm
5582: WHERE ecpm.change_id = eri.change_id
5583: AND ecpm.local_organization_id = p_local_organization_id
5584: AND ecpm.revised_item_sequence_id = eri.revised_item_sequence_id
5585: AND ecpm.entity_name = Eng_Propagation_Log_Util.G_ENTITY_REVISED_ITEM
5586: 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));
5587:
5588: BEGIN
5589: Eng_Propagation_Log_Util.Debug_Log(G_LOG_PROC, 'PROPAGATE_ECO_PLM.Begin For Organization: '|| l_org_code);

Line 5586: 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));

5582: WHERE ecpm.change_id = eri.change_id
5583: AND ecpm.local_organization_id = p_local_organization_id
5584: AND ecpm.revised_item_sequence_id = eri.revised_item_sequence_id
5585: AND ecpm.entity_name = Eng_Propagation_Log_Util.G_ENTITY_REVISED_ITEM
5586: 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));
5587:
5588: BEGIN
5589: Eng_Propagation_Log_Util.Debug_Log(G_LOG_PROC, 'PROPAGATE_ECO_PLM.Begin For Organization: '|| l_org_code);
5590: -- Standard call to check for call compatibility

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

5585: AND ecpm.entity_name = Eng_Propagation_Log_Util.G_ENTITY_REVISED_ITEM
5586: 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));
5587:
5588: BEGIN
5589: Eng_Propagation_Log_Util.Debug_Log(G_LOG_PROC, 'PROPAGATE_ECO_PLM.Begin For Organization: '|| l_org_code);
5590: -- Standard call to check for call compatibility
5591: IF NOT FND_API.Compatible_API_Call ( l_api_version
5592: , p_api_version
5593: , l_api_name

Line 5641: l_top_entity_process_status := Eng_Propagation_Log_Util.G_PRP_PRC_STS_ERROR;

5637: , x_Return_Status => l_return_status
5638: );
5639: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
5640: THEN
5641: l_top_entity_process_status := Eng_Propagation_Log_Util.G_PRP_PRC_STS_ERROR;
5642: RAISE EXC_EXP_SKIP_OBJECT;
5643: END IF;
5644: END IF; -- **** END of p_calling_API <> 'TTM' **** --
5645:

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

5657: , x_local_change_id => l_local_change_id
5658: );
5659: IF (l_local_change_id IS NULL)
5660: THEN
5661: Eng_Propagation_Log_Util.Debug_Log(G_LOG_PROC, 'PROPAGATE_ECO_PLM.End For Organization: '|| l_org_code);
5662: RETURN;
5663: END IF;
5664: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Value x_local_change_id: '|| l_local_change_id);
5665: Initialize_Business_object(

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

5660: THEN
5661: Eng_Propagation_Log_Util.Debug_Log(G_LOG_PROC, 'PROPAGATE_ECO_PLM.End For Organization: '|| l_org_code);
5662: RETURN;
5663: END IF;
5664: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Value x_local_change_id: '|| l_local_change_id);
5665: Initialize_Business_object(
5666: p_debug => 'N'
5667: , p_debug_filename => ''
5668: , p_output_dir => ''

Line 5688: l_top_entity_process_status := Eng_Propagation_Log_Util.G_PRP_PRC_STS_ERROR;

5684: , x_Return_Status => l_return_status
5685: );
5686: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
5687: THEN
5688: l_top_entity_process_status := Eng_Propagation_Log_Util.G_PRP_PRC_STS_ERROR;
5689: END IF;
5690: END LOOP;
5691: Reset_Business_Object;
5692: IF l_top_entity_process_status = Eng_Propagation_Log_Util.G_PRP_PRC_STS_ERROR

Line 5692: IF l_top_entity_process_status = Eng_Propagation_Log_Util.G_PRP_PRC_STS_ERROR

5688: l_top_entity_process_status := Eng_Propagation_Log_Util.G_PRP_PRC_STS_ERROR;
5689: END IF;
5690: END LOOP;
5691: Reset_Business_Object;
5692: IF l_top_entity_process_status = Eng_Propagation_Log_Util.G_PRP_PRC_STS_ERROR
5693: THEN
5694: RAISE EXC_EXP_SKIP_OBJECT;
5695: END IF;
5696:

Line 5706: Eng_Propagation_Log_Util.add_entity_map(

5702: );
5703: -- Not doing anythig for processing the Init_Local_Change_Lifecycle return status as
5704: -- the changes to the change order in local org can go through .user can then
5705: -- manually init the lifecycle if required
5706: Eng_Propagation_Log_Util.add_entity_map(
5707: p_change_id => l_global_change_id
5708: , p_local_organization_id => p_local_organization_id
5709: , p_entity_name => Eng_Propagation_Log_Util.G_ENTITY_CHANGE
5710: , p_entity_action_status => Eng_Propagation_Log_Util.G_PRP_PRC_STS_SUCCESS

Line 5709: , p_entity_name => Eng_Propagation_Log_Util.G_ENTITY_CHANGE

5705: -- manually init the lifecycle if required
5706: Eng_Propagation_Log_Util.add_entity_map(
5707: p_change_id => l_global_change_id
5708: , p_local_organization_id => p_local_organization_id
5709: , p_entity_name => Eng_Propagation_Log_Util.G_ENTITY_CHANGE
5710: , p_entity_action_status => Eng_Propagation_Log_Util.G_PRP_PRC_STS_SUCCESS
5711: , p_bo_entity_identifier => 'ECO'--Eco_Error_Handler.G_ECO_LEVEL
5712: );
5713: EXCEPTION

Line 5710: , p_entity_action_status => Eng_Propagation_Log_Util.G_PRP_PRC_STS_SUCCESS

5706: Eng_Propagation_Log_Util.add_entity_map(
5707: p_change_id => l_global_change_id
5708: , p_local_organization_id => p_local_organization_id
5709: , p_entity_name => Eng_Propagation_Log_Util.G_ENTITY_CHANGE
5710: , p_entity_action_status => Eng_Propagation_Log_Util.G_PRP_PRC_STS_SUCCESS
5711: , p_bo_entity_identifier => 'ECO'--Eco_Error_Handler.G_ECO_LEVEL
5712: );
5713: EXCEPTION
5714: WHEN EXC_EXP_SKIP_OBJECT THEN

Line 5715: Eng_Propagation_Log_Util.add_entity_map(

5711: , p_bo_entity_identifier => 'ECO'--Eco_Error_Handler.G_ECO_LEVEL
5712: );
5713: EXCEPTION
5714: WHEN EXC_EXP_SKIP_OBJECT THEN
5715: Eng_Propagation_Log_Util.add_entity_map(
5716: p_change_id => l_global_change_id
5717: , p_local_organization_id => p_local_organization_id
5718: , p_entity_name => Eng_Propagation_Log_Util.G_ENTITY_CHANGE
5719: , p_entity_action_status => Eng_Propagation_Log_Util.G_PRP_PRC_STS_ERROR

Line 5718: , p_entity_name => Eng_Propagation_Log_Util.G_ENTITY_CHANGE

5714: WHEN EXC_EXP_SKIP_OBJECT THEN
5715: Eng_Propagation_Log_Util.add_entity_map(
5716: p_change_id => l_global_change_id
5717: , p_local_organization_id => p_local_organization_id
5718: , p_entity_name => Eng_Propagation_Log_Util.G_ENTITY_CHANGE
5719: , p_entity_action_status => Eng_Propagation_Log_Util.G_PRP_PRC_STS_ERROR
5720: , p_bo_entity_identifier => 'ECO'--Eco_Error_Handler.G_ECO_LEVEL
5721: );
5722: ROLLBACK;

Line 5719: , p_entity_action_status => Eng_Propagation_Log_Util.G_PRP_PRC_STS_ERROR

5715: Eng_Propagation_Log_Util.add_entity_map(
5716: p_change_id => l_global_change_id
5717: , p_local_organization_id => p_local_organization_id
5718: , p_entity_name => Eng_Propagation_Log_Util.G_ENTITY_CHANGE
5719: , p_entity_action_status => Eng_Propagation_Log_Util.G_PRP_PRC_STS_ERROR
5720: , p_bo_entity_identifier => 'ECO'--Eco_Error_Handler.G_ECO_LEVEL
5721: );
5722: ROLLBACK;
5723: WHEN OTHERS THEN

Line 5887: Eng_Propagation_Log_Util.Initialize;

5883: END IF;
5884:
5885: FOR l_org_count IN 2..l_org_code_list.LAST
5886: LOOP
5887: Eng_Propagation_Log_Util.Initialize;
5888: Propagate_ECO_PLM(
5889: x_error_buf => errbuf
5890: , x_return_status => retcode
5891: , p_change_notice => p_change_notice

Line 5897: Eng_Propagation_Log_Util.Write_Propagation_Log;

5893: , p_org_hierarchy_name => p_org_hierarchy_name
5894: , p_local_organization_id => l_org_code_list(l_org_count)
5895: , p_calling_API => p_calling_API
5896: );
5897: Eng_Propagation_Log_Util.Write_Propagation_Log;
5898: commit;
5899:
5900: END LOOP; -- end FOR l_org_count IN 2..l_org_code_list.LAST
5901: ELSE

Line 6014: Eng_Propagation_Log_Util.Check_Entity_Map_Existance (

6010: FOR l_org_count IN 2..l_org_code_list.LAST
6011: LOOP
6012: --
6013: -- Check for header map existance for the change and specific local org
6014: Eng_Propagation_Log_Util.Check_Entity_Map_Existance (
6015: p_change_id => p_change_id
6016: , p_entity_name => Eng_Propagation_Log_Util.G_ENTITY_CHANGE--'ENG_CHANGE'
6017: , p_local_organization_id => l_org_code_list(l_org_count)
6018: , x_change_map_id => l_change_map_id

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

6012: --
6013: -- Check for header map existance for the change and specific local org
6014: Eng_Propagation_Log_Util.Check_Entity_Map_Existance (
6015: p_change_id => p_change_id
6016: , p_entity_name => Eng_Propagation_Log_Util.G_ENTITY_CHANGE--'ENG_CHANGE'
6017: , p_local_organization_id => l_org_code_list(l_org_count)
6018: , x_change_map_id => l_change_map_id
6019: );
6020: --

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

6042: l_CHANGE_MAP_ID
6043: , p_CHANGE_ID
6044: , p_request_id
6045: , l_org_code_list(l_org_count)
6046: , Eng_Propagation_Log_Util.G_ENTITY_CHANGE--'ENG_CHANGE'
6047: , SYSDATE
6048: , FND_GLOBAL.USER_ID
6049: , SYSDATE
6050: , FND_GLOBAL.USER_ID

Line 6052: , Eng_Propagation_Log_Util.G_PRP_PRC_STS_NOACTION

6048: , FND_GLOBAL.USER_ID
6049: , SYSDATE
6050: , FND_GLOBAL.USER_ID
6051: , FND_GLOBAL.LOGIN_ID
6052: , Eng_Propagation_Log_Util.G_PRP_PRC_STS_NOACTION
6053: );
6054: --
6055: -- Else UPDATE
6056: ELSE