[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: BEGIN
1231:
1232: Eng_Propagation_Log_Util.Debug_Log(G_LOG_PROC, '-------------------------------');
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: 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');
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(
1273: p_Message_Name => 'ENG_PRP_EXISTS_IN_CO'
1274: , p_Mesg_Token_Tbl => l_mesg_token_tbl
1275: , x_Mesg_Token_Tbl => l_mesg_token_tbl
1276: , p_Token_Tbl => l_token_tbl
1322:
1323: l_token_tbl.delete;
1324: l_token_tbl(1).token_name := 'ITEM';
1325: l_token_tbl(1).token_value := l_revised_item_number;
1326: Error_Handler.Add_Error_Token(
1327: p_Message_Name => 'ENG_PRP_TRNSMFG_ENABLED'
1328: , p_Mesg_Token_Tbl => l_mesg_token_tbl
1329: , x_Mesg_Token_Tbl => l_mesg_token_tbl
1330: , p_Token_Tbl => l_token_tbl
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
1342: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1352:
1353: -- If Item does not exist in local organization throw an error
1354: IF (l_item_exists_in_org_flag = 0)
1355: THEN
1356: Error_Handler.Add_Error_Token(
1357: p_Message_Name => 'ENG_PRP_DOES_NOT_EXIST'
1358: , p_Mesg_Token_Tbl => l_mesg_token_tbl
1359: , x_Mesg_Token_Tbl => l_mesg_token_tbl
1360: , p_Token_Tbl => l_token_tbl
1371: WHERE inventory_item_id = p_use_up_item_id
1372: AND organization_id = p_local_org_id;
1373: EXCEPTION
1374: WHEN NO_DATA_FOUND THEN
1375: Error_Handler.Add_Error_Token(
1376: p_Message_Name => 'ENG_PRP_INVAL_USEUP'
1377: , p_Mesg_Token_Tbl => l_mesg_token_tbl
1378: , x_Mesg_Token_Tbl => l_mesg_token_tbl
1379: , p_Token_Tbl => l_token_tbl);
1439:
1440: IF (l_item_sourced_flag = 1 AND l_structure_exists_flag = 1)
1441: THEN
1442: -- Log a message and do not continue
1443: Error_Handler.Add_Error_Token(
1444: p_Message_Name => 'ENG_PRP_SRC_RULES'
1445: , p_Mesg_Token_Tbl => l_mesg_token_tbl
1446: , x_Mesg_Token_Tbl => l_mesg_token_tbl
1447: , p_Token_Tbl => l_token_tbl
1454: -- then it will not be propgated to the child organization
1455: IF sl.from_end_item_rev_id IS NOT NULL
1456: THEN
1457: x_propagate_strc_changes := G_VAL_FALSE;
1458: Error_Handler.Add_Error_Token(
1459: p_Message_Name => 'ENG_PRP_REVEFF_STRC_DISABLED'
1460: , p_Mesg_Token_Tbl => l_mesg_token_tbl
1461: , x_Mesg_Token_Tbl => l_mesg_token_tbl
1462: , p_Token_Tbl => l_token_tbl
1464:
1465: ELSIF sl.bill_sequence_id <> nvl(sl.source_bill_sequence_id, sl.bill_sequence_id)
1466: THEN
1467: x_propagate_strc_changes := G_VAL_FALSE;
1468: Error_Handler.Add_Error_Token(
1469: p_Message_Name => 'ENG_PRP_COMN_STRC_DISABLED'
1470: , p_Mesg_Token_Tbl => l_mesg_token_tbl
1471: , x_Mesg_Token_Tbl => l_mesg_token_tbl
1472: , p_Token_Tbl => l_token_tbl
1475: THEN
1476: l_token_tbl.delete;
1477: l_token_tbl(1).token_name := 'STRUCTURE';
1478: l_token_tbl(1).token_value := sl.alternate_bom_designator;
1479: Error_Handler.Add_Error_Token(
1480: p_Message_Name => 'ENG_PRP_STRC_NOT_EXISTS'
1481: , p_Mesg_Token_Tbl => l_mesg_token_tbl
1482: , x_Mesg_Token_Tbl => l_mesg_token_tbl
1483: , p_Token_Tbl => l_token_tbl);
1530: THEN
1531: l_token_tbl.delete;
1532: l_token_tbl(1).token_name := 'ITEM';
1533: l_token_tbl(1).token_value := tle.item_name;
1534: Error_Handler.Add_Error_Token(
1535: p_Message_Name => 'ENG_PRP_TRNSMFG_ENABLED'
1536: , p_Mesg_Token_Tbl => l_mesg_token_tbl
1537: , x_Mesg_Token_Tbl => l_mesg_token_tbl
1538: , p_Token_Tbl => l_token_tbl
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(
1548: p_Message_Name => 'ENG_ERROR_MESSAGE'
1549: , p_Mesg_Token_Tbl => l_mesg_token_tbl
1550: , x_Mesg_Token_Tbl => l_mesg_token_tbl
1551: , p_Token_Tbl => l_token_tbl
1695: l_token_tbl(1).token_name := 'STRUCTURE';
1696: l_token_tbl(1).token_value := l_struc_line_tbl(i).alternate_bom_designator;
1697: l_token_tbl(2).token_name := 'LINE';
1698: l_token_tbl(2).token_value := l_temp_mesg;
1699: Error_Handler.Add_Error_Token(
1700: p_Message_Name => 'ENG_PRP_COMMON_BOM'
1701: , p_Mesg_Token_Tbl => l_mesg_token_tbl
1702: , x_Mesg_Token_Tbl => l_mesg_token_tbl
1703: , p_Token_Tbl => l_token_tbl);
1779:
1780: l_return_status VARCHAR2(1);
1781: l_msg_count NUMBER;
1782: l_msg_data VARCHAR2(2000);
1783: l_Error_Table Error_Handler.Error_Tbl_Type;
1784: l_Message_text VARCHAR2(2000);
1785:
1786: l_org_count NUMBER;
1787: l_count NUMBER;
3141: resp_id => FND_PROFILE.value('RESP_ID'),
3142: resp_appl_id => Eng_Globals.G_WHO_REC.prog_appid
3143: );
3144:
3145: /* Initializing the Error Handler */
3146:
3147: Error_Handler.Initialize;
3148:
3149: FND_FILE.PUT_LINE(FND_FILE.LOG,'Calling ECO Business Objects');
3143: );
3144:
3145: /* Initializing the Error Handler */
3146:
3147: Error_Handler.Initialize;
3148:
3149: FND_FILE.PUT_LINE(FND_FILE.LOG,'Calling ECO Business Objects');
3150: ENG_GLOBALS.G_ENG_LAUNCH_IMPORT := 2 ;--Indicates call is from propagation
3151: Eng_Eco_Pub.Process_Eco
3183: FND_FILE.PUT_LINE(FND_FILE.LOG,'ECO Business Object Processing Done');
3184: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
3185: --
3186: -- On return from the PUB API
3187: -- Perform all the error handler operations to verify that the
3188: -- error or warning are displayed and all the error table interface
3189: -- function provided to the user work corrently;
3190: --
3191:
3202: if (l_return_status = 'S') THEN
3203: COMMIT;
3204: else
3205: ROLLBACK;
3206: Error_Handler.Get_Message_List( x_message_list => l_error_table);
3207: i:=0;
3208: FOR i IN 1..l_error_table.COUNT
3209: LOOP
3210: FND_FILE.PUT_LINE(FND_FILE.LOG,'Entity Id: '||l_error_table(i).entity_id);
3238: , p_organization_id IN NUMBER
3239: , x_return_status IN OUT NOCOPY VARCHAR2
3240: )
3241: IS
3242: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
3243: l_other_message VARCHAR2(50);
3244: l_Token_Tbl Error_Handler.Token_Tbl_Type;
3245: l_err_text VARCHAR2(2000);
3246: l_return_status VARCHAR2(1);
3240: )
3241: IS
3242: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
3243: l_other_message VARCHAR2(50);
3244: l_Token_Tbl Error_Handler.Token_Tbl_Type;
3245: l_err_text VARCHAR2(2000);
3246: l_return_status VARCHAR2(1);
3247:
3248: BEGIN
3250: THEN
3251: BOM_Globals.Set_Debug(p_debug);
3252: BOM_Rtg_Globals.Set_Debug(p_debug) ; -- Added by MK on 11/08/00
3253:
3254: Error_Handler.Open_Debug_Session
3255: ( p_debug_filename => p_debug_filename
3256: , p_output_dir => p_output_dir
3257: , x_return_status => l_return_status
3258: , p_mesg_token_tbl => l_mesg_token_tbl
3342: l_entity_action_status NUMBER;
3343: l_comp_exists_in_org NUMBER;
3344:
3345: L_MSG_COUNT NUMBER;
3346: l_Mesg_token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
3347: l_bo_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
3348: l_return_status VARCHAR2(1);
3349: l_Token_Tbl Error_Handler.Token_Tbl_Type;
3350: l_item_error_table INV_ITEM_GRP.Error_Tbl_Type;
3343: l_comp_exists_in_org NUMBER;
3344:
3345: L_MSG_COUNT NUMBER;
3346: l_Mesg_token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
3347: l_bo_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
3348: l_return_status VARCHAR2(1);
3349: l_Token_Tbl Error_Handler.Token_Tbl_Type;
3350: l_item_error_table INV_ITEM_GRP.Error_Tbl_Type;
3351: l_message_log_text VARCHAR2(4000);
3345: L_MSG_COUNT NUMBER;
3346: l_Mesg_token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
3347: l_bo_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
3348: l_return_status VARCHAR2(1);
3349: l_Token_Tbl Error_Handler.Token_Tbl_Type;
3350: l_item_error_table INV_ITEM_GRP.Error_Tbl_Type;
3351: l_message_log_text VARCHAR2(4000);
3352: l_temp_mesg VARCHAR2(4000);
3353:
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;
3415: -- Strat processing for each component
3456: fnd_message.set_token('STRUCTURE', p_revised_item_rec.Alternate_Bom_Code);
3457: l_message_log_text := fnd_message.get();
3458: fnd_message.set_name('ENG', 'ENG_PRP_COMP_ENABLED');
3459: l_temp_mesg := fnd_message.get();
3460: Error_Handler.Add_Error_Token(
3461: p_Message_Name => NULL
3462: , p_Message_Text => l_message_log_text || l_temp_mesg
3463: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3464: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
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
3477: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3492: l_token_tbl(1).token_value := l_component_item_name;
3493: l_token_tbl(1).token_name := 'STRUCTURE';
3494: l_token_tbl(1).token_value := p_revised_item_rec.Alternate_Bom_Code;
3495:
3496: Error_Handler.Add_Error_Token(
3497: p_Message_Name => 'ENG_PRP_COMP_NOT_EXIST'
3498: , p_Mesg_Token_Tbl => l_mesg_token_tbl
3499: , x_Mesg_Token_Tbl => l_mesg_token_tbl
3500: , p_Token_Tbl => l_token_tbl
3672: fnd_message.set_token('STRUCTURE', p_revised_item_rec.Alternate_Bom_Code);
3673: l_message_log_text := fnd_message.get();
3674: fnd_message.set_name('ENG', 'ENG_PRP_COMP_ENABLED');
3675: l_temp_mesg := fnd_message.get();
3676: Error_Handler.Add_Error_Token(
3677: p_Message_Name => NULL
3678: , p_Message_Text => l_message_log_text || l_temp_mesg
3679: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3680: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
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
3692: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3710: l_token_tbl(1).token_value := l_component_item_name;
3711: l_token_tbl(3).token_name := 'STRUCTURE';
3712: l_token_tbl(3).token_value := p_revised_item_rec.alternate_bom_code;
3713:
3714: Error_Handler.Add_Error_Token(
3715: p_Message_Name => 'ENG_PRP_SUBS_NOT_EXIST'
3716: , p_Mesg_Token_Tbl => l_mesg_token_tbl
3717: , x_Mesg_Token_Tbl => l_mesg_token_tbl
3718: , p_Token_Tbl => l_token_tbl
3822: --
3823: -- Add messages through propagation Maps
3824: -- Calling log_errors first as in case of successful propagation the messages are not being displayed
3825: --
3826: Eco_Error_Handler.Log_Error(
3827: p_error_status => l_return_status
3828: , p_mesg_token_tbl => l_mesg_token_tbl
3829: , p_error_scope => Error_Handler.G_SCOPE_RECORD
3830: , p_error_level => Eco_Error_Handler.G_RC_LEVEL
3825: --
3826: Eco_Error_Handler.Log_Error(
3827: p_error_status => l_return_status
3828: , p_mesg_token_tbl => l_mesg_token_tbl
3829: , p_error_scope => Error_Handler.G_SCOPE_RECORD
3830: , p_error_level => Eco_Error_Handler.G_RC_LEVEL
3831: , x_eco_rec => ENG_Eco_PUB.G_MISS_ECO_REC
3832: , x_eco_revision_tbl => ENG_Eco_PUB.G_MISS_ECO_REVISION_TBL
3833: , x_change_line_tbl => ENG_Eco_PUB.G_MISS_CHANGE_LINE_TBL -- Eng Change
3826: Eco_Error_Handler.Log_Error(
3827: p_error_status => l_return_status
3828: , p_mesg_token_tbl => l_mesg_token_tbl
3829: , p_error_scope => Error_Handler.G_SCOPE_RECORD
3830: , p_error_level => Eco_Error_Handler.G_RC_LEVEL
3831: , x_eco_rec => ENG_Eco_PUB.G_MISS_ECO_REC
3832: , x_eco_revision_tbl => ENG_Eco_PUB.G_MISS_ECO_REVISION_TBL
3833: , x_change_line_tbl => ENG_Eco_PUB.G_MISS_CHANGE_LINE_TBL -- Eng Change
3834: , x_revised_item_tbl => ENG_Eco_PUB.G_MISS_REVISED_ITEM_TBL
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
3856: EXCEPTION
3857: WHEN EXC_EXP_SKIP_OBJECT THEN
3857: WHEN EXC_EXP_SKIP_OBJECT THEN
3858: -- Set the return status
3859: l_return_status := FND_API.G_RET_STS_ERROR;
3860: -- Log any messages that have been logged with the additional error
3861: -- message into error handler
3862: Eco_Error_Handler.Log_Error(
3863: p_error_status => l_return_status
3864: , p_mesg_token_tbl => l_mesg_token_tbl
3865: , p_error_scope => Error_Handler.G_SCOPE_RECORD
3858: -- Set the return status
3859: l_return_status := FND_API.G_RET_STS_ERROR;
3860: -- Log any messages that have been logged with the additional error
3861: -- message into error handler
3862: Eco_Error_Handler.Log_Error(
3863: p_error_status => l_return_status
3864: , p_mesg_token_tbl => l_mesg_token_tbl
3865: , p_error_scope => Error_Handler.G_SCOPE_RECORD
3866: , p_error_level => Eco_Error_Handler.G_RC_LEVEL
3861: -- message into error handler
3862: Eco_Error_Handler.Log_Error(
3863: p_error_status => l_return_status
3864: , p_mesg_token_tbl => l_mesg_token_tbl
3865: , p_error_scope => Error_Handler.G_SCOPE_RECORD
3866: , p_error_level => Eco_Error_Handler.G_RC_LEVEL
3867: , x_eco_rec => ENG_Eco_PUB.G_MISS_ECO_REC
3868: , x_eco_revision_tbl => ENG_Eco_PUB.G_MISS_ECO_REVISION_TBL
3869: , x_change_line_tbl => ENG_Eco_PUB.G_MISS_CHANGE_LINE_TBL -- Eng Change
3862: Eco_Error_Handler.Log_Error(
3863: p_error_status => l_return_status
3864: , p_mesg_token_tbl => l_mesg_token_tbl
3865: , p_error_scope => Error_Handler.G_SCOPE_RECORD
3866: , p_error_level => Eco_Error_Handler.G_RC_LEVEL
3867: , x_eco_rec => ENG_Eco_PUB.G_MISS_ECO_REC
3868: , x_eco_revision_tbl => ENG_Eco_PUB.G_MISS_ECO_REVISION_TBL
3869: , x_change_line_tbl => ENG_Eco_PUB.G_MISS_CHANGE_LINE_TBL -- Eng Change
3870: , x_revised_item_tbl => ENG_Eco_PUB.G_MISS_REVISED_ITEM_TBL
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;
3893:
3893:
3894: PROCEDURE Check_Change_Existance (
3895: p_change_notice IN VARCHAR2
3896: , p_organization_id IN NUMBER
3897: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3898: , x_Return_Status OUT NOCOPY VARCHAR2
3899: ) IS
3900:
3901: CURSOR c_change_notice IS
3904: WHERE change_notice = p_change_notice
3905: AND organization_id = p_organization_id;
3906:
3907: l_change_exists NUMBER;
3908: l_Mesg_token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
3909: l_return_status VARCHAR2(1);
3910: l_err_text VARCHAR2(2000);
3911: l_Token_Tbl Error_Handler.Token_Tbl_Type;
3912:
3907: l_change_exists NUMBER;
3908: l_Mesg_token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
3909: l_return_status VARCHAR2(1);
3910: l_err_text VARCHAR2(2000);
3911: l_Token_Tbl Error_Handler.Token_Tbl_Type;
3912:
3913: BEGIN
3914: l_return_status := FND_API.G_RET_STS_SUCCESS;
3915:
3921:
3922: IF l_change_exists = G_VAL_EXISTS
3923: THEN
3924: l_return_status := FND_API.G_RET_STS_ERROR;
3925: Error_Handler.Add_Error_Token(
3926: p_Message_Name => 'ENG_PRP_ECO_EXISTS'
3927: , p_Mesg_Token_Tbl => l_mesg_token_tbl
3928: , x_Mesg_Token_Tbl => l_mesg_token_tbl
3929: , p_Token_Tbl => l_token_tbl
4039: , p_organization_id IN NUMBER
4040: , p_org_hierarchy_name IN VARCHAR2
4041: , p_local_organization_code IN VARCHAR2
4042: , p_local_organization_id IN NUMBER
4043: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
4044: , x_Return_Status OUT NOCOPY VARCHAR2
4045: ) IS
4046: -- Local Identifiers
4047: l_local_change_id NUMBER;
4074: l_department_name VARCHAR2(240);
4075: l_change_type_id NUMBER;
4076: -- Variables for error handling
4077: l_msg_count NUMBER;
4078: l_Mesg_token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
4079: l_return_status VARCHAR2(1);
4080: l_err_text VARCHAR2(2000);
4081: l_Token_Tbl Error_Handler.Token_Tbl_Type;
4082: -- Variables for Call to Process ECO
4077: l_msg_count NUMBER;
4078: l_Mesg_token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
4079: l_return_status VARCHAR2(1);
4080: l_err_text VARCHAR2(2000);
4081: l_Token_Tbl Error_Handler.Token_Tbl_Type;
4082: -- Variables for Call to Process ECO
4083: l_eco_rec Eng_Eco_Pub.Eco_Rec_Type;
4084: l_change_lines_tbl Eng_Eco_Pub.Change_Line_Tbl_Type;
4085: l_eco_revision_tbl Eng_Eco_Pub.Eco_Revision_Tbl_Type;
4206: -- not continue . Return control to calling program .
4207: --
4208: IF l_local_change_id IS NOT NULL
4209: THEN
4210: Error_Handler.Add_Error_Token(
4211: p_Message_Name => 'ENG_PRP_ECO_PROPAGATED'
4212: , p_Mesg_Token_Tbl => x_Mesg_Token_Tbl
4213: , x_Mesg_Token_Tbl => x_Mesg_Token_Tbl
4214: , p_Token_Tbl => l_token_tbl
4413: AND organization_id = p_local_organization_id;
4414: EXCEPTION
4415: WHEN NO_DATA_FOUND THEN
4416: l_return_status := FND_API.G_RET_STS_ERROR;
4417: Error_Handler.Add_Error_Token(
4418: p_Message_Name => 'ENG_PRP_SUBJECT_ITEM_INVALID'
4419: , p_Mesg_Token_Tbl => l_mesg_token_tbl
4420: , x_Mesg_Token_Tbl => l_mesg_token_tbl
4421: , p_Token_Tbl => l_token_tbl
4446:
4447: l_token_tbl(1).token_name := 'ITEM';
4448: l_token_tbl(1).token_value := l_pk1_name;
4449:
4450: Error_Handler.Add_Error_Token(
4451: p_Message_Name => 'ENG_PRP_SUBJECT_REV_INVALID'
4452: , p_Mesg_Token_Tbl => l_mesg_token_tbl
4453: , x_Mesg_Token_Tbl => l_mesg_token_tbl
4454: , p_Token_Tbl => l_token_tbl
4634:
4635: IF l_return_status = FND_API.G_RET_STS_SUCCESS
4636: THEN
4637:
4638: Eco_Error_Handler.Log_Error(
4639: p_error_status => FND_API.G_RET_STS_SUCCESS
4640: , p_error_scope => Error_Handler.G_SCOPE_RECORD
4641: , p_error_level => Eco_Error_Handler.G_ECO_LEVEL
4642: , p_other_message => 'ENG_PRP_CHG_ORDER_SUCC'
4636: THEN
4637:
4638: Eco_Error_Handler.Log_Error(
4639: p_error_status => FND_API.G_RET_STS_SUCCESS
4640: , p_error_scope => Error_Handler.G_SCOPE_RECORD
4641: , p_error_level => Eco_Error_Handler.G_ECO_LEVEL
4642: , p_other_message => 'ENG_PRP_CHG_ORDER_SUCC'
4643: , p_other_status => l_return_status
4644: , p_other_token_tbl => l_token_tbl
4637:
4638: Eco_Error_Handler.Log_Error(
4639: p_error_status => FND_API.G_RET_STS_SUCCESS
4640: , p_error_scope => Error_Handler.G_SCOPE_RECORD
4641: , p_error_level => Eco_Error_Handler.G_ECO_LEVEL
4642: , p_other_message => 'ENG_PRP_CHG_ORDER_SUCC'
4643: , p_other_status => l_return_status
4644: , p_other_token_tbl => l_token_tbl
4645: , x_eco_rec => l_eco_rec
4666: ROLLBACK;
4667: -- Set the return status
4668: l_return_status := FND_API.G_RET_STS_ERROR;
4669: -- Log any messages that have been logged with the additional error
4670: -- message into error handler
4671: Eco_Error_Handler.Log_Error(
4672: p_error_status => l_return_status
4673: , p_mesg_token_tbl => l_mesg_token_tbl
4674: , p_error_scope => Error_Handler.G_SCOPE_RECORD
4667: -- Set the return status
4668: l_return_status := FND_API.G_RET_STS_ERROR;
4669: -- Log any messages that have been logged with the additional error
4670: -- message into error handler
4671: Eco_Error_Handler.Log_Error(
4672: p_error_status => l_return_status
4673: , p_mesg_token_tbl => l_mesg_token_tbl
4674: , p_error_scope => Error_Handler.G_SCOPE_RECORD
4675: , p_error_level => Eco_Error_Handler.G_ECO_LEVEL
4670: -- message into error handler
4671: Eco_Error_Handler.Log_Error(
4672: p_error_status => l_return_status
4673: , p_mesg_token_tbl => l_mesg_token_tbl
4674: , p_error_scope => Error_Handler.G_SCOPE_RECORD
4675: , p_error_level => Eco_Error_Handler.G_ECO_LEVEL
4676: , p_other_message => 'ENG_PRP_CHG_ORDER_ERR'
4677: , p_other_status => l_return_status
4678: , p_other_token_tbl => l_token_tbl
4671: Eco_Error_Handler.Log_Error(
4672: p_error_status => l_return_status
4673: , p_mesg_token_tbl => l_mesg_token_tbl
4674: , p_error_scope => Error_Handler.G_SCOPE_RECORD
4675: , p_error_level => Eco_Error_Handler.G_ECO_LEVEL
4676: , p_other_message => 'ENG_PRP_CHG_ORDER_ERR'
4677: , p_other_status => l_return_status
4678: , p_other_token_tbl => l_token_tbl
4679: , x_eco_rec => l_eco_rec
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
4700: -- LK: Do we need to handle this here ?
4771: l_structure_type_name VARCHAR2(80);
4772: l_local_line_rev_id NUMBER;
4773:
4774: l_attach_return_status VARCHAR2(1);
4775: l_Mesg_token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
4776: l_bo_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
4777: l_return_status VARCHAR2(1);
4778: l_err_text VARCHAR2(2000);
4779: l_Token_Tbl Error_Handler.Token_Tbl_Type;
4772: l_local_line_rev_id NUMBER;
4773:
4774: l_attach_return_status VARCHAR2(1);
4775: l_Mesg_token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
4776: l_bo_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
4777: l_return_status VARCHAR2(1);
4778: l_err_text VARCHAR2(2000);
4779: l_Token_Tbl Error_Handler.Token_Tbl_Type;
4780: l_msg_count NUMBER;
4775: l_Mesg_token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
4776: l_bo_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
4777: l_return_status VARCHAR2(1);
4778: l_err_text VARCHAR2(2000);
4779: l_Token_Tbl Error_Handler.Token_Tbl_Type;
4780: l_msg_count NUMBER;
4781:
4782: l_eco_rec Eng_Eco_Pub.Eco_Rec_Type;
4783: l_change_lines_tbl Eng_Eco_Pub.Change_Line_Tbl_Type;
4876: l_return_status := FND_API.G_RET_STS_SUCCESS;
4877: l_error_logged := G_VAL_FALSE;
4878: l_attach_return_status := FND_API.G_RET_STS_SUCCESS;
4879:
4880: Error_Handler.Initialize;
4881:
4882: IF (l_ris.enable_item_in_local_org = 'Y')
4883: THEN
4884: l_transfer_item_enable := G_VAL_TRUE;
5011: l_token_tbl.delete;
5012:
5013: l_token_tbl(1).token_name := 'REVISION';
5014: l_token_tbl(1).token_value := ri.new_item_revision;
5015: Error_Handler.Add_Error_Token
5016: ( p_Message_Name => 'ENG_NEW_REV_PROP_MISS'
5017: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
5018: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
5019: , p_Token_Tbl => l_Token_Tbl);
5379: IF (p_commit = FND_API.G_TRUE)
5380: THEN
5381: COMMIT;
5382: END IF;
5383: Eco_Error_Handler.Log_Error(
5384: p_error_status => l_return_status
5385: , p_mesg_token_tbl => l_mesg_token_tbl
5386: , p_error_scope => Error_Handler.G_SCOPE_RECORD
5387: , p_error_level => Eco_Error_Handler.G_RI_LEVEL
5382: END IF;
5383: Eco_Error_Handler.Log_Error(
5384: p_error_status => l_return_status
5385: , p_mesg_token_tbl => l_mesg_token_tbl
5386: , p_error_scope => Error_Handler.G_SCOPE_RECORD
5387: , p_error_level => Eco_Error_Handler.G_RI_LEVEL
5388: , x_eco_rec => l_eco_rec
5389: , x_eco_revision_tbl => l_eco_revision_tbl
5390: , x_change_line_tbl => l_change_lines_tbl -- Eng Change
5383: Eco_Error_Handler.Log_Error(
5384: p_error_status => l_return_status
5385: , p_mesg_token_tbl => l_mesg_token_tbl
5386: , p_error_scope => Error_Handler.G_SCOPE_RECORD
5387: , p_error_level => Eco_Error_Handler.G_RI_LEVEL
5388: , x_eco_rec => l_eco_rec
5389: , x_eco_revision_tbl => l_eco_revision_tbl
5390: , x_change_line_tbl => l_change_lines_tbl -- Eng Change
5391: , x_revised_item_tbl => l_revised_item_tbl
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:
5410: x_return_status := l_return_status;
5419:
5420: -- Set the return status
5421: l_return_status := FND_API.G_RET_STS_ERROR;
5422: -- Log any messages that have been logged with the additional error
5423: -- message into error handler
5424: Eco_Error_Handler.Log_Error(
5425: p_error_status => l_return_status
5426: , p_mesg_token_tbl => l_mesg_token_tbl
5427: , p_error_scope => Error_Handler.G_SCOPE_RECORD
5420: -- Set the return status
5421: l_return_status := FND_API.G_RET_STS_ERROR;
5422: -- Log any messages that have been logged with the additional error
5423: -- message into error handler
5424: Eco_Error_Handler.Log_Error(
5425: p_error_status => l_return_status
5426: , p_mesg_token_tbl => l_mesg_token_tbl
5427: , p_error_scope => Error_Handler.G_SCOPE_RECORD
5428: , p_error_level => Eco_Error_Handler.G_RI_LEVEL
5423: -- message into error handler
5424: Eco_Error_Handler.Log_Error(
5425: p_error_status => l_return_status
5426: , p_mesg_token_tbl => l_mesg_token_tbl
5427: , p_error_scope => Error_Handler.G_SCOPE_RECORD
5428: , p_error_level => Eco_Error_Handler.G_RI_LEVEL
5429: , p_other_message => 'ENG_PRP_REV_ITEM_ERR'
5430: , p_other_status => l_return_status
5431: , p_other_token_tbl => l_token_tbl
5424: Eco_Error_Handler.Log_Error(
5425: p_error_status => l_return_status
5426: , p_mesg_token_tbl => l_mesg_token_tbl
5427: , p_error_scope => Error_Handler.G_SCOPE_RECORD
5428: , p_error_level => Eco_Error_Handler.G_RI_LEVEL
5429: , p_other_message => 'ENG_PRP_REV_ITEM_ERR'
5430: , p_other_status => l_return_status
5431: , p_other_token_tbl => l_token_tbl
5432: , x_eco_rec => l_eco_rec
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: --
5453: -- Rollback any changes that may have been made to the DB
5462: -- Set the return status
5463: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5464: l_err_text := G_PKG_NAME || ' : (Revised Item Propagation) ' || substrb(SQLERRM,1,200);
5465:
5466: Error_Handler.Add_Error_Token(
5467: p_Message_Name => NULL
5468: , p_Message_Text => l_Err_Text
5469: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
5470: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
5469: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
5470: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
5471: );
5472: -- Log any messages that have been logged with the additional error
5473: -- message into error handler
5474: Eco_Error_Handler.Log_Error(
5475: p_error_status => l_return_status
5476: , p_mesg_token_tbl => l_mesg_token_tbl
5477: , p_error_scope => Error_Handler.G_SCOPE_RECORD
5470: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
5471: );
5472: -- Log any messages that have been logged with the additional error
5473: -- message into error handler
5474: Eco_Error_Handler.Log_Error(
5475: p_error_status => l_return_status
5476: , p_mesg_token_tbl => l_mesg_token_tbl
5477: , p_error_scope => Error_Handler.G_SCOPE_RECORD
5478: , p_error_level => Eco_Error_Handler.G_RI_LEVEL
5473: -- message into error handler
5474: Eco_Error_Handler.Log_Error(
5475: p_error_status => l_return_status
5476: , p_mesg_token_tbl => l_mesg_token_tbl
5477: , p_error_scope => Error_Handler.G_SCOPE_RECORD
5478: , p_error_level => Eco_Error_Handler.G_RI_LEVEL
5479: , p_other_message => 'ENG_PRP_REV_ITEM_ERR'
5480: , p_other_status => l_return_status
5481: , p_other_token_tbl => l_token_tbl
5474: Eco_Error_Handler.Log_Error(
5475: p_error_status => l_return_status
5476: , p_mesg_token_tbl => l_mesg_token_tbl
5477: , p_error_scope => Error_Handler.G_SCOPE_RECORD
5478: , p_error_level => Eco_Error_Handler.G_RI_LEVEL
5479: , p_other_message => 'ENG_PRP_REV_ITEM_ERR'
5480: , p_other_status => l_return_status
5481: , p_other_token_tbl => l_token_tbl
5482: , x_eco_rec => l_eco_rec
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: --
5504: -- Rollback any changes that may have been made to the DB
5556: l_local_change_id NUMBER;
5557: -- this corresponds to the processing status that will have to be updated to the change
5558: l_top_entity_process_status NUMBER;
5559:
5560: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
5561: l_return_status VARCHAR2(1);
5562:
5563: CURSOR c_fetch_org_code(cp_organization_id NUMBER) IS
5564: SELECT organization_code
5598:
5599: --
5600: -- Initialize return status
5601: l_return_status := FND_API.G_RET_STS_SUCCESS;
5602: Error_Handler.Initialize;
5603: ENG_GLOBALS.G_ENG_LAUNCH_IMPORT := 2 ;--Indicates call is from propagation
5604: -- Removed check for local orgs same master org when propagating change orders
5605: -- as if required this can be added to the Business Object ---- 6/15/2005
5606:
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
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
5724: ROLLBACK;