[Home] [Help]
261: , p_revised_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
262: , p_local_organization_id IN NUMBER
263: , p_local_line_rev_id IN NUMBER
264: , x_return_status OUT NOCOPY VARCHAR2
265: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
266: ) IS
267: l_msg_count NUMBER;
268: l_msg_data VARCHAR2(2000);
269: l_return_status VARCHAR2(3);
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.
491: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Attachment does not exist');
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
510: THEN
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'
520: , p_Mesg_Token_Tbl => x_mesg_token_tbl
521: , x_Mesg_Token_Tbl => x_mesg_token_tbl
522: );
526: EXCEPTION
527: WHEN OTHERS THEN
528: x_return_status := FND_API.G_RET_STS_ERROR;
529:
530: Error_Handler.Add_Error_Token(
531: p_Message_Name => NULL
532: , p_Message_Text => 'Unexpected Error Occurred when propagating attachment changes' ||SQLERRM
533: , p_Mesg_Token_Tbl => x_Mesg_Token_Tbl
534: , x_Mesg_Token_Tbl => x_Mesg_Token_Tbl
771: , p_local_line_rev_id IN NUMBER
772: , p_revised_item_rec IN Eng_Eco_Pub.Revised_Item_Rec_Type
773: , p_revised_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
774: , x_return_status OUT NOCOPY VARCHAR2
775: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
776: ) IS
777:
778: CURSOR c_attachment_changes IS
779: SELECT eac.action_type, eac.entity_name, eac.pk1_value, eac.pk2_value
819: l_pk3_value VARCHAR2(100);
820: l_status_name fnd_lookups.meaning%TYPE;
821: l_check_item_changes NUMBER;
822: l_local_att_status fnd_attached_documents.status%TYPE; -- Bug 3599366
823: l_Mesg_token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
824: l_Token_Tbl Error_Handler.Token_Tbl_Type;
825: l_error_logged NUMBER;
826: l_cp_not_allowed NUMBER;
827: l_temp_document_id NUMBER;
820: l_status_name fnd_lookups.meaning%TYPE;
821: l_check_item_changes NUMBER;
822: l_local_att_status fnd_attached_documents.status%TYPE; -- Bug 3599366
823: l_Mesg_token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
824: l_Token_Tbl Error_Handler.Token_Tbl_Type;
825: l_error_logged NUMBER;
826: l_cp_not_allowed NUMBER;
827: l_temp_document_id NUMBER;
828: l_local_revision VARCHAR2(30);
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;
847:
848: -- initialize pk value and local attachment id
872: l_Token_Tbl.delete;
873: l_Token_Tbl(1).Token_name := 'REVISION';
874: l_Token_Tbl(1).Token_Value := p_global_new_item_rev;
875:
876: Error_Handler.Add_Error_Token(
877: p_Message_Name => 'ENG_NEW_REV_PROP_ERROR'
878: , p_Mesg_Token_Tbl => l_mesg_token_tbl
879: , x_Mesg_Token_Tbl => l_mesg_token_tbl
880: , p_Token_Tbl => l_token_tbl
901: l_Token_Tbl.delete;
902: l_Token_Tbl(1).Token_name := 'REVISION';
903: l_Token_Tbl(1).Token_Value := l_global_revision;
904:
905: Error_Handler.Add_Error_Token(
906: p_Message_Name => 'ENG_CUR_REV_PROP_ERROR'
907: , p_Mesg_Token_Tbl => l_mesg_token_tbl
908: , x_Mesg_Token_Tbl => l_mesg_token_tbl
909: , p_Token_Tbl => l_token_tbl
927: IF l_cp_not_allowed = 1
928: THEN
929: -- If revision level attachment has change allowed policy is set to 'NO'
930: l_Token_Tbl.delete;
931: Error_Handler.Add_Error_Token(p_Message_Name => 'ENG_ATT_NO_ALLOW_CHG_POLICY'
932: , p_Mesg_Token_Tbl => l_mesg_token_tbl
933: , x_Mesg_Token_Tbl => l_mesg_token_tbl
934: , p_Token_Tbl => l_token_tbl);
935: l_error_logged := G_VAL_TRUE;
963: l_Token_Tbl.delete;
964: l_Token_Tbl(1).Token_name := 'FILE';
965: l_Token_Tbl(1).Token_Value := ac.file_name;
966:
967: Error_Handler.Add_Error_Token(
968: p_Message_Name => 'ENG_PRP_ATT_ADD_FAIL'
969: , p_Mesg_Token_Tbl => l_mesg_token_tbl
970: , x_Mesg_Token_Tbl => l_mesg_token_tbl
971: , p_Token_Tbl => l_token_tbl
980: l_Token_Tbl(1).Token_Value := l_action_name;
981: l_Token_Tbl(2).Token_name := 'FILE';
982: l_Token_Tbl(2).Token_Value := ac.file_name;
983:
984: Error_Handler.Add_Error_Token(
985: p_Message_Name => 'ENG_PRP_ATT_ACTION_FAIL'
986: , p_Mesg_Token_Tbl => l_mesg_token_tbl
987: , x_Mesg_Token_Tbl => l_mesg_token_tbl
988: , p_Token_Tbl => l_token_tbl
1007: l_Token_Tbl(2).Token_Value := l_status_name;
1008: l_Token_Tbl(3).Token_name := 'FILE';
1009: l_Token_Tbl(3).Token_Value := ac.file_name;
1010:
1011: Error_Handler.Add_Error_Token(
1012: p_Message_Name => 'ENG_PRP_ATT_STATUS_FAIL'
1013: , p_Mesg_Token_Tbl => l_mesg_token_tbl
1014: , x_Mesg_Token_Tbl => l_mesg_token_tbl
1015: , p_Token_Tbl => l_token_tbl
1025: IF (l_error_logged = G_VAL_TRUE)
1026: THEN
1027: x_return_status := FND_API.G_RET_STS_ERROR;
1028: -- Log any messages that have been logged with the additional error
1029: -- message into error handler
1030: Eco_Error_Handler.Log_Error(
1031: p_error_status => FND_API.G_RET_STS_ERROR
1032: , p_mesg_token_tbl => l_mesg_token_tbl
1033: , p_error_scope => Error_Handler.G_SCOPE_ALL
1026: THEN
1027: x_return_status := FND_API.G_RET_STS_ERROR;
1028: -- Log any messages that have been logged with the additional error
1029: -- message into error handler
1030: Eco_Error_Handler.Log_Error(
1031: p_error_status => FND_API.G_RET_STS_ERROR
1032: , p_mesg_token_tbl => l_mesg_token_tbl
1033: , p_error_scope => Error_Handler.G_SCOPE_ALL
1034: , p_error_level => Eco_Error_Handler.G_ATCH_LEVEL
1029: -- message into error handler
1030: Eco_Error_Handler.Log_Error(
1031: p_error_status => FND_API.G_RET_STS_ERROR
1032: , p_mesg_token_tbl => l_mesg_token_tbl
1033: , p_error_scope => Error_Handler.G_SCOPE_ALL
1034: , p_error_level => Eco_Error_Handler.G_ATCH_LEVEL
1035: , x_eco_rec => ENG_Eco_PUB.G_MISS_ECO_REC
1036: , x_eco_revision_tbl => ENG_Eco_PUB.G_MISS_ECO_REVISION_TBL
1037: , x_change_line_tbl => ENG_Eco_PUB.G_MISS_CHANGE_LINE_TBL -- Eng Change
1030: Eco_Error_Handler.Log_Error(
1031: p_error_status => FND_API.G_RET_STS_ERROR
1032: , p_mesg_token_tbl => l_mesg_token_tbl
1033: , p_error_scope => Error_Handler.G_SCOPE_ALL
1034: , p_error_level => Eco_Error_Handler.G_ATCH_LEVEL
1035: , x_eco_rec => ENG_Eco_PUB.G_MISS_ECO_REC
1036: , x_eco_revision_tbl => ENG_Eco_PUB.G_MISS_ECO_REVISION_TBL
1037: , x_change_line_tbl => ENG_Eco_PUB.G_MISS_CHANGE_LINE_TBL -- Eng Change
1038: , x_revised_item_tbl => ENG_Eco_PUB.G_MISS_REVISED_ITEM_TBL
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(
1061: p_change_id => p_change_id
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;
1072:
1078: FETCH c_check_item_level_changes INTO l_check_item_changes;
1079: IF c_check_item_level_changes%FOUND
1080: THEN
1081: l_token_tbl.delete;
1082: Error_Handler.Add_Error_Token(
1083: p_Message_Name => 'ENG_PRP_ATT_ITEMCHG_INFO'
1084: , p_Mesg_Token_Tbl => x_mesg_token_tbl -- to be passed as o/p to the RI log error
1085: , x_Mesg_Token_Tbl => x_mesg_token_tbl
1086: , p_Token_Tbl => l_token_tbl
1088: );
1089: END IF;
1090: ELSE
1091: l_token_tbl.delete;
1092: Error_Handler.Add_Error_Token(
1093: p_Message_Name => 'ENG_PRP_ATT_REVITEM_ERR'
1094: , p_Mesg_Token_Tbl => x_mesg_token_tbl
1095: , x_Mesg_Token_Tbl => x_mesg_token_tbl
1096: , p_Token_Tbl => l_token_tbl
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(
1112: p_Message_Name => NULL
1113: , p_Message_Text => 'Unexpected Error Occurred when validating attachment changes' ||SQLERRM
1114: , p_Mesg_Token_Tbl => x_Mesg_Token_Tbl
1115: , x_Mesg_Token_Tbl => x_Mesg_Token_Tbl
1128: , p_transfer_or_copy IN VARCHAR2
1129: , p_transfer_or_copy_item IN NUMBER
1130: , p_status_master_controlled IN NUMBER
1131: , x_error_logged OUT NOCOPY NUMBER
1132: , x_mesg_token_tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1133: , x_propagate_strc_changes OUT NOCOPY NUMBER
1134: , x_sourcing_rules_exists OUT NOCOPY NUMBER
1135: , x_revised_item_name OUT NOCOPY VARCHAR2
1136: ) IS
1224: l_create_bill_for_item NUMBER;
1225: l_from_end_item_minor_rev_id NUMBER;
1226: l_from_end_item_rev_id NUMBER;
1227:
1228: l_Mesg_token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
1229: l_Token_Tbl Error_Handler.Token_Tbl_Type;
1230:
1231: l_eco_chg_exists VARCHAR2(1); -- bug 10146196 added
1232: BEGIN
1225: l_from_end_item_minor_rev_id NUMBER;
1226: l_from_end_item_rev_id NUMBER;
1227:
1228: l_Mesg_token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
1229: l_Token_Tbl Error_Handler.Token_Tbl_Type;
1230:
1231: l_eco_chg_exists VARCHAR2(1); -- bug 10146196 added
1232: BEGIN
1233:
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(
1276: p_Message_Name => 'ENG_PRP_EXISTS_IN_CO'
1277: , p_Mesg_Token_Tbl => l_mesg_token_tbl
1278: , x_Mesg_Token_Tbl => l_mesg_token_tbl
1279: , p_Token_Tbl => l_token_tbl
1325:
1326: l_token_tbl.delete;
1327: l_token_tbl(1).token_name := 'ITEM';
1328: l_token_tbl(1).token_value := l_revised_item_number;
1329: Error_Handler.Add_Error_Token(
1330: p_Message_Name => 'ENG_PRP_TRNSMFG_ENABLED'
1331: , p_Mesg_Token_Tbl => l_mesg_token_tbl
1332: , x_Mesg_Token_Tbl => l_mesg_token_tbl
1333: , p_Token_Tbl => l_token_tbl
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
1345: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1355:
1356: -- If Item does not exist in local organization throw an error
1357: IF (l_item_exists_in_org_flag = 0)
1358: THEN
1359: Error_Handler.Add_Error_Token(
1360: p_Message_Name => 'ENG_PRP_DOES_NOT_EXIST'
1361: , p_Mesg_Token_Tbl => l_mesg_token_tbl
1362: , x_Mesg_Token_Tbl => l_mesg_token_tbl
1363: , p_Token_Tbl => l_token_tbl
1374: WHERE inventory_item_id = p_use_up_item_id
1375: AND organization_id = p_local_org_id;
1376: EXCEPTION
1377: WHEN NO_DATA_FOUND THEN
1378: Error_Handler.Add_Error_Token(
1379: p_Message_Name => 'ENG_PRP_INVAL_USEUP'
1380: , p_Mesg_Token_Tbl => l_mesg_token_tbl
1381: , x_Mesg_Token_Tbl => l_mesg_token_tbl
1382: , p_Token_Tbl => l_token_tbl);
1442:
1443: IF (l_item_sourced_flag = 1 AND l_structure_exists_flag = 1)
1444: THEN
1445: -- Log a message and do not continue
1446: Error_Handler.Add_Error_Token(
1447: p_Message_Name => 'ENG_PRP_SRC_RULES'
1448: , p_Mesg_Token_Tbl => l_mesg_token_tbl
1449: , x_Mesg_Token_Tbl => l_mesg_token_tbl
1450: , p_Token_Tbl => l_token_tbl
1457: -- then it will not be propgated to the child organization
1458: IF sl.from_end_item_rev_id IS NOT NULL
1459: THEN
1460: x_propagate_strc_changes := G_VAL_FALSE;
1461: Error_Handler.Add_Error_Token(
1462: p_Message_Name => 'ENG_PRP_REVEFF_STRC_DISABLED'
1463: , p_Mesg_Token_Tbl => l_mesg_token_tbl
1464: , x_Mesg_Token_Tbl => l_mesg_token_tbl
1465: , p_Token_Tbl => l_token_tbl
1467:
1468: ELSIF sl.bill_sequence_id <> nvl(sl.source_bill_sequence_id, sl.bill_sequence_id)
1469: THEN
1470: x_propagate_strc_changes := G_VAL_FALSE;
1471: Error_Handler.Add_Error_Token(
1472: p_Message_Name => 'ENG_PRP_COMN_STRC_DISABLED'
1473: , p_Mesg_Token_Tbl => l_mesg_token_tbl
1474: , x_Mesg_Token_Tbl => l_mesg_token_tbl
1475: , p_Token_Tbl => l_token_tbl
1478: THEN
1479: l_token_tbl.delete;
1480: l_token_tbl(1).token_name := 'STRUCTURE';
1481: l_token_tbl(1).token_value := sl.alternate_bom_designator;
1482: Error_Handler.Add_Error_Token(
1483: p_Message_Name => 'ENG_PRP_STRC_NOT_EXISTS'
1484: , p_Mesg_Token_Tbl => l_mesg_token_tbl
1485: , x_Mesg_Token_Tbl => l_mesg_token_tbl
1486: , p_Token_Tbl => l_token_tbl);
1533: THEN
1534: l_token_tbl.delete;
1535: l_token_tbl(1).token_name := 'ITEM';
1536: l_token_tbl(1).token_value := tle.item_name;
1537: Error_Handler.Add_Error_Token(
1538: p_Message_Name => 'ENG_PRP_TRNSMFG_ENABLED'
1539: , p_Mesg_Token_Tbl => l_mesg_token_tbl
1540: , x_Mesg_Token_Tbl => l_mesg_token_tbl
1541: , p_Token_Tbl => l_token_tbl
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(
1551: p_Message_Name => 'ENG_ERROR_MESSAGE'
1552: , p_Mesg_Token_Tbl => l_mesg_token_tbl
1553: , x_Mesg_Token_Tbl => l_mesg_token_tbl
1554: , p_Token_Tbl => l_token_tbl
1712: l_token_tbl(1).token_name := 'STRUCTURE';
1713: l_token_tbl(1).token_value := l_struc_line_tbl(i).alternate_bom_designator;
1714: l_token_tbl(2).token_name := 'LINE';
1715: l_token_tbl(2).token_value := l_temp_mesg;
1716: Error_Handler.Add_Error_Token(
1717: p_Message_Name => 'ENG_PRP_COMMON_BOM'
1718: , p_Mesg_Token_Tbl => l_mesg_token_tbl
1719: , x_Mesg_Token_Tbl => l_mesg_token_tbl
1720: , p_Token_Tbl => l_token_tbl);
1797:
1798: l_return_status VARCHAR2(1);
1799: l_msg_count NUMBER;
1800: l_msg_data VARCHAR2(2000);
1801: l_Error_Table Error_Handler.Error_Tbl_Type;
1802: l_Message_text VARCHAR2(2000);
1803:
1804: l_org_count NUMBER;
1805: l_count NUMBER;
3233: resp_id => FND_PROFILE.value('RESP_ID'),
3234: resp_appl_id => Eng_Globals.G_WHO_REC.prog_appid
3235: );
3236:
3237: /* Initializing the Error Handler */
3238:
3239: Error_Handler.Initialize;
3240:
3241: FND_FILE.PUT_LINE(FND_FILE.LOG,'Calling ECO Business Objects');
3235: );
3236:
3237: /* Initializing the Error Handler */
3238:
3239: Error_Handler.Initialize;
3240:
3241: FND_FILE.PUT_LINE(FND_FILE.LOG,'Calling ECO Business Objects');
3242: ENG_GLOBALS.G_ENG_LAUNCH_IMPORT := 2 ;--Indicates call is from propagation
3243: Eng_Eco_Pub.Process_Eco
3275: FND_FILE.PUT_LINE(FND_FILE.LOG,'ECO Business Object Processing Done');
3276: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
3277: --
3278: -- On return from the PUB API
3279: -- Perform all the error handler operations to verify that the
3280: -- error or warning are displayed and all the error table interface
3281: -- function provided to the user work corrently;
3282: --
3283:
3327: /*End bug #7496156 to Copy attached Document*/
3328: COMMIT;
3329: else
3330: ROLLBACK;
3331: Error_Handler.Get_Message_List( x_message_list => l_error_table);
3332: i:=0;
3333: FOR i IN 1..l_error_table.COUNT
3334: LOOP
3335: FND_FILE.PUT_LINE(FND_FILE.LOG,'Entity Id: '||l_error_table(i).entity_id);
3363: , p_organization_id IN NUMBER
3364: , x_return_status IN OUT NOCOPY VARCHAR2
3365: )
3366: IS
3367: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
3368: l_other_message VARCHAR2(50);
3369: l_Token_Tbl Error_Handler.Token_Tbl_Type;
3370: l_err_text VARCHAR2(2000);
3371: l_return_status VARCHAR2(1);
3365: )
3366: IS
3367: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
3368: l_other_message VARCHAR2(50);
3369: l_Token_Tbl Error_Handler.Token_Tbl_Type;
3370: l_err_text VARCHAR2(2000);
3371: l_return_status VARCHAR2(1);
3372:
3373: BEGIN
3375: THEN
3376: BOM_Globals.Set_Debug(p_debug);
3377: BOM_Rtg_Globals.Set_Debug(p_debug) ; -- Added by MK on 11/08/00
3378:
3379: Error_Handler.Open_Debug_Session
3380: ( p_debug_filename => p_debug_filename
3381: , p_output_dir => p_output_dir
3382: , x_return_status => l_return_status
3383: , p_mesg_token_tbl => l_mesg_token_tbl
3467: l_entity_action_status NUMBER;
3468: l_comp_exists_in_org NUMBER;
3469:
3470: L_MSG_COUNT NUMBER;
3471: l_Mesg_token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
3472: l_bo_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
3473: l_return_status VARCHAR2(1);
3474: l_Token_Tbl Error_Handler.Token_Tbl_Type;
3475: l_item_error_table INV_ITEM_GRP.Error_Tbl_Type;
3468: l_comp_exists_in_org NUMBER;
3469:
3470: L_MSG_COUNT NUMBER;
3471: l_Mesg_token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
3472: l_bo_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
3473: l_return_status VARCHAR2(1);
3474: l_Token_Tbl Error_Handler.Token_Tbl_Type;
3475: l_item_error_table INV_ITEM_GRP.Error_Tbl_Type;
3476: l_message_log_text VARCHAR2(4000);
3470: L_MSG_COUNT NUMBER;
3471: l_Mesg_token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
3472: l_bo_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
3473: l_return_status VARCHAR2(1);
3474: l_Token_Tbl Error_Handler.Token_Tbl_Type;
3475: l_item_error_table INV_ITEM_GRP.Error_Tbl_Type;
3476: l_message_log_text VARCHAR2(4000);
3477: l_temp_mesg VARCHAR2(4000);
3478:
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;
3540: -- Strat processing for each component
3581: fnd_message.set_token('STRUCTURE', p_revised_item_rec.Alternate_Bom_Code);
3582: l_message_log_text := fnd_message.get();
3583: fnd_message.set_name('ENG', 'ENG_PRP_COMP_ENABLED');
3584: l_temp_mesg := fnd_message.get();
3585: Error_Handler.Add_Error_Token(
3586: p_Message_Name => NULL
3587: , p_Message_Text => l_message_log_text || l_temp_mesg
3588: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3589: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
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
3602: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3617: l_token_tbl(1).token_value := l_component_item_name;
3618: l_token_tbl(1).token_name := 'STRUCTURE';
3619: l_token_tbl(1).token_value := p_revised_item_rec.Alternate_Bom_Code;
3620:
3621: Error_Handler.Add_Error_Token(
3622: p_Message_Name => 'ENG_PRP_COMP_NOT_EXIST'
3623: , p_Mesg_Token_Tbl => l_mesg_token_tbl
3624: , x_Mesg_Token_Tbl => l_mesg_token_tbl
3625: , p_Token_Tbl => l_token_tbl
3797: fnd_message.set_token('STRUCTURE', p_revised_item_rec.Alternate_Bom_Code);
3798: l_message_log_text := fnd_message.get();
3799: fnd_message.set_name('ENG', 'ENG_PRP_COMP_ENABLED');
3800: l_temp_mesg := fnd_message.get();
3801: Error_Handler.Add_Error_Token(
3802: p_Message_Name => NULL
3803: , p_Message_Text => l_message_log_text || l_temp_mesg
3804: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3805: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
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
3817: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3835: l_token_tbl(1).token_value := l_component_item_name;
3836: l_token_tbl(3).token_name := 'STRUCTURE';
3837: l_token_tbl(3).token_value := p_revised_item_rec.alternate_bom_code;
3838:
3839: Error_Handler.Add_Error_Token(
3840: p_Message_Name => 'ENG_PRP_SUBS_NOT_EXIST'
3841: , p_Mesg_Token_Tbl => l_mesg_token_tbl
3842: , x_Mesg_Token_Tbl => l_mesg_token_tbl
3843: , p_Token_Tbl => l_token_tbl
3947: --
3948: -- Add messages through propagation Maps
3949: -- Calling log_errors first as in case of successful propagation the messages are not being displayed
3950: --
3951: Eco_Error_Handler.Log_Error(
3952: p_error_status => l_return_status
3953: , p_mesg_token_tbl => l_mesg_token_tbl
3954: , p_error_scope => Error_Handler.G_SCOPE_RECORD
3955: , p_error_level => Eco_Error_Handler.G_RC_LEVEL
3950: --
3951: Eco_Error_Handler.Log_Error(
3952: p_error_status => l_return_status
3953: , p_mesg_token_tbl => l_mesg_token_tbl
3954: , p_error_scope => Error_Handler.G_SCOPE_RECORD
3955: , p_error_level => Eco_Error_Handler.G_RC_LEVEL
3956: , x_eco_rec => ENG_Eco_PUB.G_MISS_ECO_REC
3957: , x_eco_revision_tbl => ENG_Eco_PUB.G_MISS_ECO_REVISION_TBL
3958: , x_change_line_tbl => ENG_Eco_PUB.G_MISS_CHANGE_LINE_TBL -- Eng Change
3951: Eco_Error_Handler.Log_Error(
3952: p_error_status => l_return_status
3953: , p_mesg_token_tbl => l_mesg_token_tbl
3954: , p_error_scope => Error_Handler.G_SCOPE_RECORD
3955: , p_error_level => Eco_Error_Handler.G_RC_LEVEL
3956: , x_eco_rec => ENG_Eco_PUB.G_MISS_ECO_REC
3957: , x_eco_revision_tbl => ENG_Eco_PUB.G_MISS_ECO_REVISION_TBL
3958: , x_change_line_tbl => ENG_Eco_PUB.G_MISS_CHANGE_LINE_TBL -- Eng Change
3959: , x_revised_item_tbl => ENG_Eco_PUB.G_MISS_REVISED_ITEM_TBL
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
3981: EXCEPTION
3982: WHEN EXC_EXP_SKIP_OBJECT THEN
3982: WHEN EXC_EXP_SKIP_OBJECT THEN
3983: -- Set the return status
3984: l_return_status := FND_API.G_RET_STS_ERROR;
3985: -- Log any messages that have been logged with the additional error
3986: -- message into error handler
3987: Eco_Error_Handler.Log_Error(
3988: p_error_status => l_return_status
3989: , p_mesg_token_tbl => l_mesg_token_tbl
3990: , p_error_scope => Error_Handler.G_SCOPE_RECORD
3983: -- Set the return status
3984: l_return_status := FND_API.G_RET_STS_ERROR;
3985: -- Log any messages that have been logged with the additional error
3986: -- message into error handler
3987: Eco_Error_Handler.Log_Error(
3988: p_error_status => l_return_status
3989: , p_mesg_token_tbl => l_mesg_token_tbl
3990: , p_error_scope => Error_Handler.G_SCOPE_RECORD
3991: , p_error_level => Eco_Error_Handler.G_RC_LEVEL
3986: -- message into error handler
3987: Eco_Error_Handler.Log_Error(
3988: p_error_status => l_return_status
3989: , p_mesg_token_tbl => l_mesg_token_tbl
3990: , p_error_scope => Error_Handler.G_SCOPE_RECORD
3991: , p_error_level => Eco_Error_Handler.G_RC_LEVEL
3992: , x_eco_rec => ENG_Eco_PUB.G_MISS_ECO_REC
3993: , x_eco_revision_tbl => ENG_Eco_PUB.G_MISS_ECO_REVISION_TBL
3994: , x_change_line_tbl => ENG_Eco_PUB.G_MISS_CHANGE_LINE_TBL -- Eng Change
3987: Eco_Error_Handler.Log_Error(
3988: p_error_status => l_return_status
3989: , p_mesg_token_tbl => l_mesg_token_tbl
3990: , p_error_scope => Error_Handler.G_SCOPE_RECORD
3991: , p_error_level => Eco_Error_Handler.G_RC_LEVEL
3992: , x_eco_rec => ENG_Eco_PUB.G_MISS_ECO_REC
3993: , x_eco_revision_tbl => ENG_Eco_PUB.G_MISS_ECO_REVISION_TBL
3994: , x_change_line_tbl => ENG_Eco_PUB.G_MISS_CHANGE_LINE_TBL -- Eng Change
3995: , x_revised_item_tbl => ENG_Eco_PUB.G_MISS_REVISED_ITEM_TBL
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;
4018:
4018:
4019: PROCEDURE Check_Change_Existance (
4020: p_change_notice IN VARCHAR2
4021: , p_organization_id IN NUMBER
4022: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
4023: , x_Return_Status OUT NOCOPY VARCHAR2
4024: ) IS
4025:
4026: CURSOR c_change_notice IS
4029: WHERE change_notice = p_change_notice
4030: AND organization_id = p_organization_id;
4031:
4032: l_change_exists NUMBER;
4033: l_Mesg_token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
4034: l_return_status VARCHAR2(1);
4035: l_err_text VARCHAR2(2000);
4036: l_Token_Tbl Error_Handler.Token_Tbl_Type;
4037:
4032: l_change_exists NUMBER;
4033: l_Mesg_token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
4034: l_return_status VARCHAR2(1);
4035: l_err_text VARCHAR2(2000);
4036: l_Token_Tbl Error_Handler.Token_Tbl_Type;
4037:
4038: BEGIN
4039: l_return_status := FND_API.G_RET_STS_SUCCESS;
4040:
4046:
4047: IF l_change_exists = G_VAL_EXISTS
4048: THEN
4049: l_return_status := FND_API.G_RET_STS_ERROR;
4050: Error_Handler.Add_Error_Token(
4051: p_Message_Name => 'ENG_PRP_ECO_EXISTS'
4052: , p_Mesg_Token_Tbl => l_mesg_token_tbl
4053: , x_Mesg_Token_Tbl => l_mesg_token_tbl
4054: , p_Token_Tbl => l_token_tbl
4164: , p_organization_id IN NUMBER
4165: , p_org_hierarchy_name IN VARCHAR2
4166: , p_local_organization_code IN VARCHAR2
4167: , p_local_organization_id IN NUMBER
4168: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
4169: , x_Return_Status OUT NOCOPY VARCHAR2
4170: ) IS
4171: -- Local Identifiers
4172: l_local_change_id NUMBER;
4199: l_department_name VARCHAR2(240);
4200: l_change_type_id NUMBER;
4201: -- Variables for error handling
4202: l_msg_count NUMBER;
4203: l_Mesg_token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
4204: l_return_status VARCHAR2(1);
4205: l_err_text VARCHAR2(2000);
4206: l_Token_Tbl Error_Handler.Token_Tbl_Type;
4207: -- Variables for Call to Process ECO
4202: l_msg_count NUMBER;
4203: l_Mesg_token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
4204: l_return_status VARCHAR2(1);
4205: l_err_text VARCHAR2(2000);
4206: l_Token_Tbl Error_Handler.Token_Tbl_Type;
4207: -- Variables for Call to Process ECO
4208: l_eco_rec Eng_Eco_Pub.Eco_Rec_Type;
4209: l_change_lines_tbl Eng_Eco_Pub.Change_Line_Tbl_Type;
4210: l_eco_revision_tbl Eng_Eco_Pub.Eco_Revision_Tbl_Type;
4331: -- not continue . Return control to calling program .
4332: --
4333: IF l_local_change_id IS NOT NULL
4334: THEN
4335: Error_Handler.Add_Error_Token(
4336: p_Message_Name => 'ENG_PRP_ECO_PROPAGATED'
4337: , p_Mesg_Token_Tbl => x_Mesg_Token_Tbl
4338: , x_Mesg_Token_Tbl => x_Mesg_Token_Tbl
4339: , p_Token_Tbl => l_token_tbl
4538: AND organization_id = p_local_organization_id;
4539: EXCEPTION
4540: WHEN NO_DATA_FOUND THEN
4541: l_return_status := FND_API.G_RET_STS_ERROR;
4542: Error_Handler.Add_Error_Token(
4543: p_Message_Name => 'ENG_PRP_SUBJECT_ITEM_INVALID'
4544: , p_Mesg_Token_Tbl => l_mesg_token_tbl
4545: , x_Mesg_Token_Tbl => l_mesg_token_tbl
4546: , p_Token_Tbl => l_token_tbl
4571:
4572: l_token_tbl(1).token_name := 'ITEM';
4573: l_token_tbl(1).token_value := l_pk1_name;
4574:
4575: Error_Handler.Add_Error_Token(
4576: p_Message_Name => 'ENG_PRP_SUBJECT_REV_INVALID'
4577: , p_Mesg_Token_Tbl => l_mesg_token_tbl
4578: , x_Mesg_Token_Tbl => l_mesg_token_tbl
4579: , p_Token_Tbl => l_token_tbl
4760:
4761: IF l_return_status = FND_API.G_RET_STS_SUCCESS
4762: THEN
4763:
4764: Eco_Error_Handler.Log_Error(
4765: p_error_status => FND_API.G_RET_STS_SUCCESS
4766: , p_error_scope => Error_Handler.G_SCOPE_RECORD
4767: , p_error_level => Eco_Error_Handler.G_ECO_LEVEL
4768: , p_other_message => 'ENG_PRP_CHG_ORDER_SUCC'
4762: THEN
4763:
4764: Eco_Error_Handler.Log_Error(
4765: p_error_status => FND_API.G_RET_STS_SUCCESS
4766: , p_error_scope => Error_Handler.G_SCOPE_RECORD
4767: , p_error_level => Eco_Error_Handler.G_ECO_LEVEL
4768: , p_other_message => 'ENG_PRP_CHG_ORDER_SUCC'
4769: , p_other_status => l_return_status
4770: , p_other_token_tbl => l_token_tbl
4763:
4764: Eco_Error_Handler.Log_Error(
4765: p_error_status => FND_API.G_RET_STS_SUCCESS
4766: , p_error_scope => Error_Handler.G_SCOPE_RECORD
4767: , p_error_level => Eco_Error_Handler.G_ECO_LEVEL
4768: , p_other_message => 'ENG_PRP_CHG_ORDER_SUCC'
4769: , p_other_status => l_return_status
4770: , p_other_token_tbl => l_token_tbl
4771: , x_eco_rec => l_eco_rec
4792: ROLLBACK;
4793: -- Set the return status
4794: l_return_status := FND_API.G_RET_STS_ERROR;
4795: -- Log any messages that have been logged with the additional error
4796: -- message into error handler
4797: Eco_Error_Handler.Log_Error(
4798: p_error_status => l_return_status
4799: , p_mesg_token_tbl => l_mesg_token_tbl
4800: , p_error_scope => Error_Handler.G_SCOPE_RECORD
4793: -- Set the return status
4794: l_return_status := FND_API.G_RET_STS_ERROR;
4795: -- Log any messages that have been logged with the additional error
4796: -- message into error handler
4797: Eco_Error_Handler.Log_Error(
4798: p_error_status => l_return_status
4799: , p_mesg_token_tbl => l_mesg_token_tbl
4800: , p_error_scope => Error_Handler.G_SCOPE_RECORD
4801: , p_error_level => Eco_Error_Handler.G_ECO_LEVEL
4796: -- message into error handler
4797: Eco_Error_Handler.Log_Error(
4798: p_error_status => l_return_status
4799: , p_mesg_token_tbl => l_mesg_token_tbl
4800: , p_error_scope => Error_Handler.G_SCOPE_RECORD
4801: , p_error_level => Eco_Error_Handler.G_ECO_LEVEL
4802: , p_other_message => 'ENG_PRP_CHG_ORDER_ERR'
4803: , p_other_status => l_return_status
4804: , p_other_token_tbl => l_token_tbl
4797: Eco_Error_Handler.Log_Error(
4798: p_error_status => l_return_status
4799: , p_mesg_token_tbl => l_mesg_token_tbl
4800: , p_error_scope => Error_Handler.G_SCOPE_RECORD
4801: , p_error_level => Eco_Error_Handler.G_ECO_LEVEL
4802: , p_other_message => 'ENG_PRP_CHG_ORDER_ERR'
4803: , p_other_status => l_return_status
4804: , p_other_token_tbl => l_token_tbl
4805: , x_eco_rec => l_eco_rec
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
4826: -- LK: Do we need to handle this here ?
4898: l_structure_type_name VARCHAR2(80);
4899: l_local_line_rev_id NUMBER;
4900:
4901: l_attach_return_status VARCHAR2(1);
4902: l_Mesg_token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
4903: l_bo_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
4904: l_return_status VARCHAR2(1);
4905: l_err_text VARCHAR2(2000);
4906: l_Token_Tbl Error_Handler.Token_Tbl_Type;
4899: l_local_line_rev_id NUMBER;
4900:
4901: l_attach_return_status VARCHAR2(1);
4902: l_Mesg_token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
4903: l_bo_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
4904: l_return_status VARCHAR2(1);
4905: l_err_text VARCHAR2(2000);
4906: l_Token_Tbl Error_Handler.Token_Tbl_Type;
4907: l_msg_count NUMBER;
4902: l_Mesg_token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
4903: l_bo_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
4904: l_return_status VARCHAR2(1);
4905: l_err_text VARCHAR2(2000);
4906: l_Token_Tbl Error_Handler.Token_Tbl_Type;
4907: l_msg_count NUMBER;
4908:
4909: l_eco_rec Eng_Eco_Pub.Eco_Rec_Type;
4910: l_change_lines_tbl Eng_Eco_Pub.Change_Line_Tbl_Type;
5003: l_return_status := FND_API.G_RET_STS_SUCCESS;
5004: l_error_logged := G_VAL_FALSE;
5005: l_attach_return_status := FND_API.G_RET_STS_SUCCESS;
5006:
5007: Error_Handler.Initialize;
5008:
5009: IF (l_ris.enable_item_in_local_org = 'Y')
5010: THEN
5011: l_transfer_item_enable := G_VAL_TRUE;
5138: l_token_tbl.delete;
5139:
5140: l_token_tbl(1).token_name := 'REVISION';
5141: l_token_tbl(1).token_value := ri.new_item_revision;
5142: Error_Handler.Add_Error_Token
5143: ( p_Message_Name => 'ENG_NEW_REV_PROP_MISS'
5144: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
5145: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
5146: , p_Token_Tbl => l_Token_Tbl);
5507: IF (p_commit = FND_API.G_TRUE)
5508: THEN
5509: COMMIT;
5510: END IF;
5511: Eco_Error_Handler.Log_Error(
5512: p_error_status => l_return_status
5513: , p_mesg_token_tbl => l_mesg_token_tbl
5514: , p_error_scope => Error_Handler.G_SCOPE_RECORD
5515: , p_error_level => Eco_Error_Handler.G_RI_LEVEL
5510: END IF;
5511: Eco_Error_Handler.Log_Error(
5512: p_error_status => l_return_status
5513: , p_mesg_token_tbl => l_mesg_token_tbl
5514: , p_error_scope => Error_Handler.G_SCOPE_RECORD
5515: , p_error_level => Eco_Error_Handler.G_RI_LEVEL
5516: , x_eco_rec => l_eco_rec
5517: , x_eco_revision_tbl => l_eco_revision_tbl
5518: , x_change_line_tbl => l_change_lines_tbl -- Eng Change
5511: Eco_Error_Handler.Log_Error(
5512: p_error_status => l_return_status
5513: , p_mesg_token_tbl => l_mesg_token_tbl
5514: , p_error_scope => Error_Handler.G_SCOPE_RECORD
5515: , p_error_level => Eco_Error_Handler.G_RI_LEVEL
5516: , x_eco_rec => l_eco_rec
5517: , x_eco_revision_tbl => l_eco_revision_tbl
5518: , x_change_line_tbl => l_change_lines_tbl -- Eng Change
5519: , x_revised_item_tbl => l_revised_item_tbl
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:
5538: x_return_status := l_return_status;
5547:
5548: -- Set the return status
5549: l_return_status := FND_API.G_RET_STS_ERROR;
5550: -- Log any messages that have been logged with the additional error
5551: -- message into error handler
5552: Eco_Error_Handler.Log_Error(
5553: p_error_status => l_return_status
5554: , p_mesg_token_tbl => l_mesg_token_tbl
5555: , p_error_scope => Error_Handler.G_SCOPE_RECORD
5548: -- Set the return status
5549: l_return_status := FND_API.G_RET_STS_ERROR;
5550: -- Log any messages that have been logged with the additional error
5551: -- message into error handler
5552: Eco_Error_Handler.Log_Error(
5553: p_error_status => l_return_status
5554: , p_mesg_token_tbl => l_mesg_token_tbl
5555: , p_error_scope => Error_Handler.G_SCOPE_RECORD
5556: , p_error_level => Eco_Error_Handler.G_RI_LEVEL
5551: -- message into error handler
5552: Eco_Error_Handler.Log_Error(
5553: p_error_status => l_return_status
5554: , p_mesg_token_tbl => l_mesg_token_tbl
5555: , p_error_scope => Error_Handler.G_SCOPE_RECORD
5556: , p_error_level => Eco_Error_Handler.G_RI_LEVEL
5557: , p_other_message => 'ENG_PRP_REV_ITEM_ERR'
5558: , p_other_status => l_return_status
5559: , p_other_token_tbl => l_token_tbl
5552: Eco_Error_Handler.Log_Error(
5553: p_error_status => l_return_status
5554: , p_mesg_token_tbl => l_mesg_token_tbl
5555: , p_error_scope => Error_Handler.G_SCOPE_RECORD
5556: , p_error_level => Eco_Error_Handler.G_RI_LEVEL
5557: , p_other_message => 'ENG_PRP_REV_ITEM_ERR'
5558: , p_other_status => l_return_status
5559: , p_other_token_tbl => l_token_tbl
5560: , x_eco_rec => l_eco_rec
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: --
5581: -- Rollback any changes that may have been made to the DB
5590: -- Set the return status
5591: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5592: l_err_text := G_PKG_NAME || ' : (Revised Item Propagation) ' || substrb(SQLERRM,1,200);
5593:
5594: Error_Handler.Add_Error_Token(
5595: p_Message_Name => NULL
5596: , p_Message_Text => l_Err_Text
5597: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
5598: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
5597: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
5598: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
5599: );
5600: -- Log any messages that have been logged with the additional error
5601: -- message into error handler
5602: Eco_Error_Handler.Log_Error(
5603: p_error_status => l_return_status
5604: , p_mesg_token_tbl => l_mesg_token_tbl
5605: , p_error_scope => Error_Handler.G_SCOPE_RECORD
5598: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
5599: );
5600: -- Log any messages that have been logged with the additional error
5601: -- message into error handler
5602: Eco_Error_Handler.Log_Error(
5603: p_error_status => l_return_status
5604: , p_mesg_token_tbl => l_mesg_token_tbl
5605: , p_error_scope => Error_Handler.G_SCOPE_RECORD
5606: , p_error_level => Eco_Error_Handler.G_RI_LEVEL
5601: -- message into error handler
5602: Eco_Error_Handler.Log_Error(
5603: p_error_status => l_return_status
5604: , p_mesg_token_tbl => l_mesg_token_tbl
5605: , p_error_scope => Error_Handler.G_SCOPE_RECORD
5606: , p_error_level => Eco_Error_Handler.G_RI_LEVEL
5607: , p_other_message => 'ENG_PRP_REV_ITEM_ERR'
5608: , p_other_status => l_return_status
5609: , p_other_token_tbl => l_token_tbl
5602: Eco_Error_Handler.Log_Error(
5603: p_error_status => l_return_status
5604: , p_mesg_token_tbl => l_mesg_token_tbl
5605: , p_error_scope => Error_Handler.G_SCOPE_RECORD
5606: , p_error_level => Eco_Error_Handler.G_RI_LEVEL
5607: , p_other_message => 'ENG_PRP_REV_ITEM_ERR'
5608: , p_other_status => l_return_status
5609: , p_other_token_tbl => l_token_tbl
5610: , x_eco_rec => l_eco_rec
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: --
5632: -- Rollback any changes that may have been made to the DB
5684: l_local_change_id NUMBER;
5685: -- this corresponds to the processing status that will have to be updated to the change
5686: l_top_entity_process_status NUMBER;
5687:
5688: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
5689: l_return_status VARCHAR2(1);
5690:
5691: -- Bug# 9498305
5692: l_propagated_to_chg_id NUMBER;
5739:
5740: --
5741: -- Initialize return status
5742: l_return_status := FND_API.G_RET_STS_SUCCESS;
5743: Error_Handler.Initialize;
5744: ENG_GLOBALS.G_ENG_LAUNCH_IMPORT := 2 ;--Indicates call is from propagation
5745: -- Removed check for local orgs same master org when propagating change orders
5746: -- as if required this can be added to the Business Object ---- 6/15/2005
5747:
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
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
6197: ROLLBACK;