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.BOM_RTG_VAL_TO_ID dependencies on FND_API

Line 59: RETURN FND_API.G_MISS_NUM;

55: WHEN NO_DATA_FOUND THEN
56: RETURN NULL;
57:
58: WHEN OTHERS THEN
59: RETURN FND_API.G_MISS_NUM;
60:
61: END Organization;
62:
63:

Line 113: RETURN FND_API.G_MISS_NUM;

109: WHEN NO_DATA_FOUND THEN
110: RETURN NULL;
111:
112: WHEN OTHERS THEN
113: RETURN FND_API.G_MISS_NUM;
114:
115: END Revised_Item;
116:
117:

Line 203: AND NVL(alternate_routing_designator, FND_API.G_MISS_CHAR) =

199: INTO l_id, l_cfm_flag, l_com_rtg_seq_id
200: FROM bom_operational_routings
201: WHERE organization_id = p_organization_id
202: AND assembly_item_id = p_assembly_item_id
203: AND NVL(alternate_routing_designator, FND_API.G_MISS_CHAR) =
204: NVL(p_alternate_routing_designator, FND_API.G_MISS_CHAR);
205:
206: BOM_Rtg_Globals.Set_CFM_Rtg_Flag(p_cfm_rtg_type => l_cfm_flag) ;
207: BOM_Rtg_Globals.Set_Common_Rtg_Seq_id

Line 204: NVL(p_alternate_routing_designator, FND_API.G_MISS_CHAR);

200: FROM bom_operational_routings
201: WHERE organization_id = p_organization_id
202: AND assembly_item_id = p_assembly_item_id
203: AND NVL(alternate_routing_designator, FND_API.G_MISS_CHAR) =
204: NVL(p_alternate_routing_designator, FND_API.G_MISS_CHAR);
205:
206: BOM_Rtg_Globals.Set_CFM_Rtg_Flag(p_cfm_rtg_type => l_cfm_flag) ;
207: BOM_Rtg_Globals.Set_Common_Rtg_Seq_id
208: ( p_common_Rtg_seq_id => l_com_rtg_seq_id );

Line 219: RETURN FND_API.G_MISS_NUM;

215: WHEN NO_DATA_FOUND THEN
216: RETURN NULL;
217:
218: WHEN OTHERS THEN
219: RETURN FND_API.G_MISS_NUM;
220:
221: END Routing_Sequence_id ;
222:
223: /********************************************************************

Line 288: WHERE NVL(from_end_item_unit_number, FND_API.G_MISS_CHAR )

284: -- Modified by MK on 11/02/00
285: SELECT routing_sequence_id, revised_item_Sequence_id
286: INTO x_routing_sequence_id, l_Rev_Item_Seq
287: FROM eng_revised_items
288: WHERE NVL(from_end_item_unit_number, FND_API.G_MISS_CHAR )
289: = NVL(p_from_end_item_number, FND_API.G_MISS_CHAR)
290: AND NVL(new_routing_revision, FND_API.G_MISS_CHAR) =
291: NVL(p_new_routing_revision, FND_API.G_MISS_CHAR)
292: AND NVL(new_item_revision,FND_API.G_MISS_CHAR)= NVL(p_item_revision,FND_API.G_MISS_CHAR)

Line 289: = NVL(p_from_end_item_number, FND_API.G_MISS_CHAR)

285: SELECT routing_sequence_id, revised_item_Sequence_id
286: INTO x_routing_sequence_id, l_Rev_Item_Seq
287: FROM eng_revised_items
288: WHERE NVL(from_end_item_unit_number, FND_API.G_MISS_CHAR )
289: = NVL(p_from_end_item_number, FND_API.G_MISS_CHAR)
290: AND NVL(new_routing_revision, FND_API.G_MISS_CHAR) =
291: NVL(p_new_routing_revision, FND_API.G_MISS_CHAR)
292: AND NVL(new_item_revision,FND_API.G_MISS_CHAR)= NVL(p_item_revision,FND_API.G_MISS_CHAR)
293: AND scheduled_date = p_effective_date

Line 290: AND NVL(new_routing_revision, FND_API.G_MISS_CHAR) =

286: INTO x_routing_sequence_id, l_Rev_Item_Seq
287: FROM eng_revised_items
288: WHERE NVL(from_end_item_unit_number, FND_API.G_MISS_CHAR )
289: = NVL(p_from_end_item_number, FND_API.G_MISS_CHAR)
290: AND NVL(new_routing_revision, FND_API.G_MISS_CHAR) =
291: NVL(p_new_routing_revision, FND_API.G_MISS_CHAR)
292: AND NVL(new_item_revision,FND_API.G_MISS_CHAR)= NVL(p_item_revision,FND_API.G_MISS_CHAR)
293: AND scheduled_date = p_effective_date
294: -- AND TRUNC(scheduled_date) = TRUNC(p_effective_date) -- time

Line 291: NVL(p_new_routing_revision, FND_API.G_MISS_CHAR)

287: FROM eng_revised_items
288: WHERE NVL(from_end_item_unit_number, FND_API.G_MISS_CHAR )
289: = NVL(p_from_end_item_number, FND_API.G_MISS_CHAR)
290: AND NVL(new_routing_revision, FND_API.G_MISS_CHAR) =
291: NVL(p_new_routing_revision, FND_API.G_MISS_CHAR)
292: AND NVL(new_item_revision,FND_API.G_MISS_CHAR)= NVL(p_item_revision,FND_API.G_MISS_CHAR)
293: AND scheduled_date = p_effective_date
294: -- AND TRUNC(scheduled_date) = TRUNC(p_effective_date) -- time
295: AND change_notice = p_change_notice

Line 292: AND NVL(new_item_revision,FND_API.G_MISS_CHAR)= NVL(p_item_revision,FND_API.G_MISS_CHAR)

288: WHERE NVL(from_end_item_unit_number, FND_API.G_MISS_CHAR )
289: = NVL(p_from_end_item_number, FND_API.G_MISS_CHAR)
290: AND NVL(new_routing_revision, FND_API.G_MISS_CHAR) =
291: NVL(p_new_routing_revision, FND_API.G_MISS_CHAR)
292: AND NVL(new_item_revision,FND_API.G_MISS_CHAR)= NVL(p_item_revision,FND_API.G_MISS_CHAR)
293: AND scheduled_date = p_effective_date
294: -- AND TRUNC(scheduled_date) = TRUNC(p_effective_date) -- time
295: AND change_notice = p_change_notice
296: AND organization_id = p_organization_id

Line 358: RETURN FND_API.G_MISS_NUM;

354: WHEN NO_DATA_FOUND THEN
355: RETURN NULL;
356:
357: WHEN OTHERS THEN
358: RETURN FND_API.G_MISS_NUM;
359:
360: END Completion_locator_id;
361:
362: /********************************************************************

Line 398: RETURN FND_API.G_MISS_NUM;

394: WHEN NO_DATA_FOUND THEN
395: RETURN NULL;
396:
397: WHEN OTHERS THEN
398: RETURN FND_API.G_MISS_NUM;
399: END Line_Id;
400:
401: /********************************************************************
402: * Function : Standard_Operation_id for ECO BO

Line 433: = DECODE(p_operation_type, FND_API.G_MISS_NUM, 1

429: INTO l_id
430: FROM bom_standard_operations bso
431: -- , eng_revised_items eri
432: WHERE NVL(bso.operation_type, 1)
433: = DECODE(p_operation_type, FND_API.G_MISS_NUM, 1
434: , NVL(p_operation_type, 1 ) )
435: -- AND NVL(bso.line_id, FND_API.G_MISS_NUM)
436: -- = NVL(eri.line_id, FND_API.G_MISS_NUM)
437: -- AND eri.revised_item_sequence_id = p_rev_item_sequence_id

Line 435: -- AND NVL(bso.line_id, FND_API.G_MISS_NUM)

431: -- , eng_revised_items eri
432: WHERE NVL(bso.operation_type, 1)
433: = DECODE(p_operation_type, FND_API.G_MISS_NUM, 1
434: , NVL(p_operation_type, 1 ) )
435: -- AND NVL(bso.line_id, FND_API.G_MISS_NUM)
436: -- = NVL(eri.line_id, FND_API.G_MISS_NUM)
437: -- AND eri.revised_item_sequence_id = p_rev_item_sequence_id
438: AND NVL(bso.line_id, FND_API.G_MISS_NUM ) = FND_API.G_MISS_NUM
439: AND bso.organization_id = p_organization_id

Line 436: -- = NVL(eri.line_id, FND_API.G_MISS_NUM)

432: WHERE NVL(bso.operation_type, 1)
433: = DECODE(p_operation_type, FND_API.G_MISS_NUM, 1
434: , NVL(p_operation_type, 1 ) )
435: -- AND NVL(bso.line_id, FND_API.G_MISS_NUM)
436: -- = NVL(eri.line_id, FND_API.G_MISS_NUM)
437: -- AND eri.revised_item_sequence_id = p_rev_item_sequence_id
438: AND NVL(bso.line_id, FND_API.G_MISS_NUM ) = FND_API.G_MISS_NUM
439: AND bso.organization_id = p_organization_id
440: AND bso.operation_code = p_standard_operation_code ;

Line 438: AND NVL(bso.line_id, FND_API.G_MISS_NUM ) = FND_API.G_MISS_NUM

434: , NVL(p_operation_type, 1 ) )
435: -- AND NVL(bso.line_id, FND_API.G_MISS_NUM)
436: -- = NVL(eri.line_id, FND_API.G_MISS_NUM)
437: -- AND eri.revised_item_sequence_id = p_rev_item_sequence_id
438: AND NVL(bso.line_id, FND_API.G_MISS_NUM ) = FND_API.G_MISS_NUM
439: AND bso.organization_id = p_organization_id
440: AND bso.operation_code = p_standard_operation_code ;
441:
442:

Line 451: RETURN FND_API.G_MISS_NUM;

447: WHEN NO_DATA_FOUND THEN
448: RETURN NULL;
449:
450: WHEN OTHERS THEN
451: RETURN FND_API.G_MISS_NUM;
452: END Standard_Operation_Id;
453:
454:
455: /********************************************************************

Line 487: = DECODE(p_operation_type, FND_API.G_MISS_NUM, 1

483: INTO l_id
484: FROM bom_standard_operations bso
485: , bom_operational_routings bor
486: WHERE NVL(bso.operation_type,1 )
487: = DECODE(p_operation_type, FND_API.G_MISS_NUM, 1
488: , NVL(p_operation_type, 1))
489: AND NVL(bso.line_id, FND_API.G_MISS_NUM)
490: = NVL(bor.line_id, FND_API.G_MISS_NUM)
491: AND bor.routing_sequence_id = p_routing_sequence_id

Line 489: AND NVL(bso.line_id, FND_API.G_MISS_NUM)

485: , bom_operational_routings bor
486: WHERE NVL(bso.operation_type,1 )
487: = DECODE(p_operation_type, FND_API.G_MISS_NUM, 1
488: , NVL(p_operation_type, 1))
489: AND NVL(bso.line_id, FND_API.G_MISS_NUM)
490: = NVL(bor.line_id, FND_API.G_MISS_NUM)
491: AND bor.routing_sequence_id = p_routing_sequence_id
492: AND bso.organization_id = p_organization_id
493: AND bso.operation_code = p_standard_operation_code ;

Line 490: = NVL(bor.line_id, FND_API.G_MISS_NUM)

486: WHERE NVL(bso.operation_type,1 )
487: = DECODE(p_operation_type, FND_API.G_MISS_NUM, 1
488: , NVL(p_operation_type, 1))
489: AND NVL(bso.line_id, FND_API.G_MISS_NUM)
490: = NVL(bor.line_id, FND_API.G_MISS_NUM)
491: AND bor.routing_sequence_id = p_routing_sequence_id
492: AND bso.organization_id = p_organization_id
493: AND bso.operation_code = p_standard_operation_code ;
494:

Line 503: RETURN FND_API.G_MISS_NUM;

499: WHEN NO_DATA_FOUND THEN
500: RETURN NULL;
501:
502: WHEN OTHERS THEN
503: RETURN FND_API.G_MISS_NUM;
504: END Standard_Operation_Id;
505:
506: /********************************************************************
507: * Function : Department id

Line 539: RETURN FND_API.G_MISS_NUM;

535: WHEN NO_DATA_FOUND THEN
536: RETURN NULL;
537:
538: WHEN OTHERS THEN
539: RETURN FND_API.G_MISS_NUM;
540: END Department_Id;
541:
542: /********************************************************************
543: * Function : Process_Op_Seq_Id

Line 599: RETURN FND_API.G_MISS_NUM;

595: WHEN NO_DATA_FOUND THEN
596: RETURN NULL;
597:
598: WHEN OTHERS THEN
599: RETURN FND_API.G_MISS_NUM;
600:
601: END Process_Op_Seq_Id;
602:
603: /********************************************************************

Line 675: RETURN FND_API.G_MISS_NUM;

671: WHEN NO_DATA_FOUND THEN
672: RETURN NULL;
673:
674: WHEN OTHERS THEN
675: RETURN FND_API.G_MISS_NUM;
676:
677: END Line_Op_Seq_Id;
678:
679:

Line 712: FND_API.G_MISS_NUM, 1,

708: SELECT operation_sequence_id
709: INTO l_id
710: FROM BOM_OPERATION_SEQUENCES
711: WHERE NVL(operation_type, 1) = DECODE(p_operation_type,
712: FND_API.G_MISS_NUM, 1,
713: NVL(p_operation_type, 1)
714: )
715: AND routing_sequence_id = p_routing_sequence_id
716: AND effectivity_date = p_old_effective_date -- Changed for bug 2647027

Line 729: RETURN FND_API.G_MISS_NUM;

725: WHEN NO_DATA_FOUND THEN
726: RETURN NULL;
727:
728: WHEN OTHERS THEN
729: RETURN FND_API.G_MISS_NUM;
730:
731: END Old_Operation_Sequence;
732:
733:

Line 767: RETURN FND_API.G_MISS_NUM;

763: WHEN NO_DATA_FOUND THEN
764: RETURN NULL;
765:
766: WHEN OTHERS THEN
767: RETURN FND_API.G_MISS_NUM;
768:
769: END Setup_Id ;
770:
771:

Line 805: RETURN FND_API.G_MISS_NUM;

801: WHEN NO_DATA_FOUND THEN
802: RETURN NULL;
803:
804: WHEN OTHERS THEN
805: RETURN FND_API.G_MISS_NUM;
806:
807: END Activity_Id;
808:
809: /********************************************************************

Line 843: RETURN FND_API.G_MISS_NUM;

839: WHEN NO_DATA_FOUND THEN
840: RETURN NULL;
841:
842: WHEN OTHERS THEN
843: RETURN FND_API.G_MISS_NUM;
844:
845: END resource_id;
846:
847: /********************************************************************

Line 889: FND_API.G_MISS_NUM, 1,

885: -- /** time **/ TRUNC(effectivity_date) = TRUNC(p_effectivity_date))
886: OR p_operation_type IN (2, 3)
887: )
888: AND NVL(operation_type, 1 ) = DECODE(p_operation_type,
889: FND_API.G_MISS_NUM, 1,
890: NVL(p_operation_type, 1 ) )
891: AND operation_seq_num = p_operation_seq_num
892: AND routing_sequence_id = p_routing_sequence_id ;
893:

Line 902: RETURN FND_API.G_MISS_NUM;

898: WHEN NO_DATA_FOUND THEN
899: RETURN NULL;
900:
901: WHEN OTHERS THEN
902: RETURN FND_API.G_MISS_NUM;
903:
904:
905: END Operation_Sequence_Id;
906:

Line 943: x_return_status := FND_API.G_RET_STS_SUCCESS;

939: WHERE alternate_designator_code = p_alt_designator
940: AND organization_id = p_organization_id;
941:
942: BEGIN
943: x_return_status := FND_API.G_RET_STS_SUCCESS;
944: l_return_status := FND_API.G_RET_STS_SUCCESS;
945: l_rtg_header_unexp_rec := p_rtg_header_unexp_rec;
946:
947:

Line 944: l_return_status := FND_API.G_RET_STS_SUCCESS;

940: AND organization_id = p_organization_id;
941:
942: BEGIN
943: x_return_status := FND_API.G_RET_STS_SUCCESS;
944: l_return_status := FND_API.G_RET_STS_SUCCESS;
945: l_rtg_header_unexp_rec := p_rtg_header_unexp_rec;
946:
947:
948: If Bom_Rtg_Globals.Get_Debug = 'Y'

Line 957: p_rtg_header_rec.assembly_item_name = FND_API.G_MISS_CHAR

953: --
954: -- Assembly Item name cannot be NULL or missing.
955: --
956: IF p_rtg_header_rec.assembly_item_name IS NULL OR
957: p_rtg_header_rec.assembly_item_name = FND_API.G_MISS_CHAR
958: THEN
959: Error_Handler.Add_Error_Token
960: ( p_message_name => 'BOM_RTG_AITEM_NAME_KEYCOL_NULL'
961: , p_mesg_token_tbl => l_mesg_token_tbl

Line 965: l_return_status := FND_API.G_RET_STS_ERROR;

961: , p_mesg_token_tbl => l_mesg_token_tbl
962: , x_mesg_token_tbl => l_mesg_token_tbl
963: );
964:
965: l_return_status := FND_API.G_RET_STS_ERROR;
966: END IF;
967:
968: --
969: -- Assembly item name must be successfully converted to id.

Line 994: l_Return_Status := FND_API.G_RET_STS_ERROR;

990: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
991: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
992: , p_Token_Tbl => g_Token_Tbl
993: );
994: l_Return_Status := FND_API.G_RET_STS_ERROR;
995: ELSIF l_err_text IS NOT NULL AND
996: (l_rtg_header_unexp_rec.assembly_item_id IS NULL OR
997: l_rtg_header_unexp_rec.assembly_item_id = FND_API.G_MISS_NUM)
998: THEN

Line 997: l_rtg_header_unexp_rec.assembly_item_id = FND_API.G_MISS_NUM)

993: );
994: l_Return_Status := FND_API.G_RET_STS_ERROR;
995: ELSIF l_err_text IS NOT NULL AND
996: (l_rtg_header_unexp_rec.assembly_item_id IS NULL OR
997: l_rtg_header_unexp_rec.assembly_item_id = FND_API.G_MISS_NUM)
998: THEN
999: -- This is an unexpected error.
1000: Error_Handler.Add_Error_Token
1001: ( p_Message_Name => NULL

Line 1007: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1003: G_PKG_NAME
1004: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1005: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1006: );
1007: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1008: END IF;
1009:
1010: If BOM_Rtg_Globals.Get_Debug = 'Y'
1011: THEN Error_Handler.Write_Debug

Line 1018: p_rtg_header_rec.alternate_routing_code <> FND_API.G_MISS_CHAR

1014: || ' Status ' || l_return_status); END IF;
1015:
1016:
1017: IF p_rtg_header_rec.alternate_routing_code IS NOT NULL AND
1018: p_rtg_header_rec.alternate_routing_code <> FND_API.G_MISS_CHAR
1019: THEN
1020: l_err_text/*_diff*/ := FND_API.G_RET_STS_ERROR;
1021:
1022: FOR check_alternate IN

Line 1020: l_err_text/_diff/ := FND_API.G_RET_STS_ERROR;

1016:
1017: IF p_rtg_header_rec.alternate_routing_code IS NOT NULL AND
1018: p_rtg_header_rec.alternate_routing_code <> FND_API.G_MISS_CHAR
1019: THEN
1020: l_err_text/*_diff*/ := FND_API.G_RET_STS_ERROR;
1021:
1022: FOR check_alternate IN
1023: c_Check_Alternate
1024: ( p_alt_designator =>

Line 1029: l_err_text/_diff/ := FND_API.G_RET_STS_SUCCESS;

1025: p_rtg_header_rec.alternate_routing_code,
1026: p_organization_id =>
1027: l_rtg_header_unexp_rec.organization_id )
1028: LOOP
1029: l_err_text/*_diff*/ := FND_API.G_RET_STS_SUCCESS;
1030: END LOOP;
1031:
1032: IF l_err_text/*_diff*/ <> FND_API.G_RET_STS_SUCCESS
1033: THEN

Line 1032: IF l_err_text/_diff/ <> FND_API.G_RET_STS_SUCCESS

1028: LOOP
1029: l_err_text/*_diff*/ := FND_API.G_RET_STS_SUCCESS;
1030: END LOOP;
1031:
1032: IF l_err_text/*_diff*/ <> FND_API.G_RET_STS_SUCCESS
1033: THEN
1034: g_token_tbl(1).token_name :='ALTERNATE_ROUTING_CODE';
1035: g_token_tbl(1).token_value :=
1036: p_rtg_header_rec.alternate_routing_code;

Line 1047: l_return_status := FND_API.G_RET_STS_ERROR;

1043: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1044: , p_token_tbl => g_token_tbl
1045: );
1046:
1047: l_return_status := FND_API.G_RET_STS_ERROR;
1048: END IF;
1049: END IF;
1050:
1051: x_return_status := l_return_status;

Line 1081: l_return_status VARCHAR2(1):=FND_API.G_RET_STS_SUCCESS;

1077: , x_Return_Status IN OUT NOCOPY VARCHAR2
1078: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1079: )
1080: IS
1081: l_return_status VARCHAR2(1):=FND_API.G_RET_STS_SUCCESS;
1082: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
1083: l_err_text VARCHAR2(2000);
1084: l_Token_Tbl Error_Handler.Token_Tbl_Type;
1085: l_rtg_header_unexp_rec Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type

Line 1096: FND_API.G_MISS_CHAR

1092:
1093:
1094: IF p_rtg_header_rec.common_assembly_item_name IS NOT NULL AND
1095: p_rtg_header_rec.common_assembly_item_name <>
1096: FND_API.G_MISS_CHAR
1097: THEN
1098: l_rtg_header_unexp_rec.common_assembly_item_id :=
1099: Assembly_Item
1100: ( p_assembly_item_name => p_rtg_header_rec.common_assembly_item_name

Line 1118: l_return_status := FND_API.G_RET_STS_ERROR;

1114: , p_Message_name =>
1115: 'BOM_RTG_COMMON_AITEM_INVALID'
1116: , p_token_tbl => l_token_tbl
1117: );
1118: l_return_status := FND_API.G_RET_STS_ERROR;
1119:
1120: ELSIF l_err_text IS NOT NULL AND
1121: l_rtg_header_unexp_rec.common_assembly_item_id
1122: IS NULL

Line 1133: l_return_status :=FND_API.G_RET_STS_UNEXP_ERROR;

1129: G_PKG_NAME
1130: , p_token_tbl => l_token_tbl
1131: );
1132:
1133: l_return_status :=FND_API.G_RET_STS_UNEXP_ERROR;
1134: END IF;
1135:
1136: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN
1137: Error_Handler.Write_Debug('Converted common assembly name . . .');

Line 1148: l_rtg_header_unexp_rec.organization_id <>FND_API.G_MISS_NUM AND

1144: -- Convert common assembly name information, alternate routing
1145: -- code and organanization id into common routing sequence_id
1146: --
1147: IF l_rtg_header_unexp_rec.organization_id IS NOT NULL AND
1148: l_rtg_header_unexp_rec.organization_id <>FND_API.G_MISS_NUM AND
1149: l_rtg_header_unexp_rec.common_assembly_item_id IS NOT NULL AND
1150: l_rtg_header_unexp_rec.common_assembly_item_id <> FND_API.G_MISS_NUM
1151: -- p_rtg_header_rec.alternate_routing_code IS NOT NULL AND
1152: -- p_rtg_header_rec.alternate_routing_code <>FND_API.G_MISS_CHAR

Line 1150: l_rtg_header_unexp_rec.common_assembly_item_id <> FND_API.G_MISS_NUM

1146: --
1147: IF l_rtg_header_unexp_rec.organization_id IS NOT NULL AND
1148: l_rtg_header_unexp_rec.organization_id <>FND_API.G_MISS_NUM AND
1149: l_rtg_header_unexp_rec.common_assembly_item_id IS NOT NULL AND
1150: l_rtg_header_unexp_rec.common_assembly_item_id <> FND_API.G_MISS_NUM
1151: -- p_rtg_header_rec.alternate_routing_code IS NOT NULL AND
1152: -- p_rtg_header_rec.alternate_routing_code <>FND_API.G_MISS_CHAR
1153: THEN
1154:

Line 1152: -- p_rtg_header_rec.alternate_routing_code <>FND_API.G_MISS_CHAR

1148: l_rtg_header_unexp_rec.organization_id <>FND_API.G_MISS_NUM AND
1149: l_rtg_header_unexp_rec.common_assembly_item_id IS NOT NULL AND
1150: l_rtg_header_unexp_rec.common_assembly_item_id <> FND_API.G_MISS_NUM
1151: -- p_rtg_header_rec.alternate_routing_code IS NOT NULL AND
1152: -- p_rtg_header_rec.alternate_routing_code <>FND_API.G_MISS_CHAR
1153: THEN
1154:
1155: l_rtg_header_unexp_rec.common_routing_sequence_id :=
1156: Routing_Sequence_Id

Line 1188: l_return_status := FND_API.G_RET_STS_ERROR;

1184: , p_token_tbl => l_token_tbl
1185: , p_mesg_token_tbl => l_mesg_token_tbl
1186: , x_mesg_token_tbl => l_mesg_token_tbl
1187: );
1188: l_return_status := FND_API.G_RET_STS_ERROR;
1189:
1190: ELSIF l_err_text IS NOT NULL AND
1191: l_rtg_header_unexp_rec.common_routing_sequence_id
1192: IS NULL

Line 1202: l_return_status :=FND_API.G_RET_STS_UNEXP_ERROR;

1198: 'Unexpected Error ' || l_err_text || ' in ' ||
1199: G_PKG_NAME
1200: , p_token_tbl => l_token_tbl
1201: );
1202: l_return_status :=FND_API.G_RET_STS_UNEXP_ERROR;
1203: END IF;
1204:
1205: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN
1206: Error_Handler.Write_Debug('Converted common routing sequence id. . .');

Line 1216: FND_API.G_MISS_CHAR

1212:
1213:
1214: IF p_rtg_header_rec.completion_location_name IS NOT NULL AND
1215: p_rtg_header_rec.completion_location_name <>
1216: FND_API.G_MISS_CHAR
1217: THEN
1218: l_rtg_header_unexp_rec.completion_locator_id :=
1219:
1220: Completion_locator_id

Line 1244: l_return_status := FND_API.G_RET_STS_ERROR;

1240: , p_Message_name =>
1241: 'BOM_RTG_LOCATION_NAME_INVALID'
1242: , p_token_tbl => l_token_tbl
1243: );
1244: l_return_status := FND_API.G_RET_STS_ERROR;
1245: ELSIF l_err_text IS NOT NULL AND
1246: l_rtg_header_unexp_rec.completion_locator_id
1247: IS NULL
1248: THEN

Line 1257: l_return_status :=FND_API.G_RET_STS_UNEXP_ERROR;

1253: 'Unexpected Error ' || l_err_text || ' in ' ||
1254: G_PKG_NAME
1255: , p_token_tbl => l_token_tbl
1256: );
1257: l_return_status :=FND_API.G_RET_STS_UNEXP_ERROR;
1258: END IF;
1259:
1260: IF BOM_Rtg_Globals.Get_Debug = 'Y'THEN
1261: Error_Handler.Write_Debug('Converted completion locator name ...');

Line 1268: p_rtg_header_rec.line_code <> FND_API.G_MISS_CHAR

1264: END IF;
1265:
1266:
1267: IF p_rtg_header_rec.line_code IS NOT NULL AND
1268: p_rtg_header_rec.line_code <> FND_API.G_MISS_CHAR
1269: -- p_rtg_header_rec.cfm_routing_flag = 1
1270: THEN
1271: l_rtg_header_unexp_rec.line_id :=
1272: Line_Id

Line 1291: l_return_status := FND_API.G_RET_STS_ERROR;

1287: , p_Message_name =>
1288: 'BOM_RTG_LINE_CODE_INVALID'
1289: , p_token_tbl => l_token_tbl
1290: );
1291: l_return_status := FND_API.G_RET_STS_ERROR;
1292: ELSIF l_err_text IS NOT NULL AND
1293: l_rtg_header_unexp_rec.line_id
1294: IS NULL
1295: THEN

Line 1304: l_return_status :=FND_API.G_RET_STS_UNEXP_ERROR;

1300: 'Unexpected Error ' || l_err_text
1301: || ' in ' || G_PKG_NAME
1302: , p_token_tbl => l_token_tbl
1303: );
1304: l_return_status :=FND_API.G_RET_STS_UNEXP_ERROR;
1305: END IF;
1306:
1307: IF BOM_Rtg_Globals.Get_Debug = 'Y'THEN
1308: Error_Handler.Write_Debug('Converted line code ...');

Line 1357: x_return_status := FND_API.G_RET_STS_SUCCESS;

1353:
1354:
1355:
1356: BEGIN
1357: x_return_status := FND_API.G_RET_STS_SUCCESS;
1358: l_return_status := FND_API.G_RET_STS_SUCCESS;
1359: l_rtg_rev_unexp_rec := p_rtg_rev_unexp_rec;
1360:
1361:

Line 1358: l_return_status := FND_API.G_RET_STS_SUCCESS;

1354:
1355:
1356: BEGIN
1357: x_return_status := FND_API.G_RET_STS_SUCCESS;
1358: l_return_status := FND_API.G_RET_STS_SUCCESS;
1359: l_rtg_rev_unexp_rec := p_rtg_rev_unexp_rec;
1360:
1361:
1362: If BOM_Rtg_Globals.Get_Debug = 'Y'

Line 1376: p_rtg_revision_rec.assembly_item_name = FND_API.G_MISS_CHAR

1372: --
1373: -- Assembly Item name cannot be NULL or missing.
1374: --
1375: IF p_rtg_revision_rec.assembly_item_name IS NULL OR
1376: p_rtg_revision_rec.assembly_item_name = FND_API.G_MISS_CHAR
1377: THEN
1378: Error_Handler.Add_Error_Token
1379: ( p_message_name => 'BOM_RTG_REV_AITEM_KEYCOL_NULL'
1380: , p_mesg_token_tbl => l_mesg_token_tbl

Line 1384: l_return_status := FND_API.G_RET_STS_ERROR;

1380: , p_mesg_token_tbl => l_mesg_token_tbl
1381: , x_mesg_token_tbl => l_mesg_token_tbl
1382: );
1383:
1384: l_return_status := FND_API.G_RET_STS_ERROR;
1385: END IF;
1386:
1387: --
1388: -- Assembly item name must be successfully converted to id.

Line 1413: l_Return_Status := FND_API.G_RET_STS_ERROR;

1409: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1410: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1411: , p_Token_Tbl => g_Token_Tbl
1412: );
1413: l_Return_Status := FND_API.G_RET_STS_ERROR;
1414: ELSIF l_err_text IS NOT NULL AND
1415: (l_rtg_rev_unexp_rec.assembly_item_id IS NULL OR
1416: l_rtg_rev_unexp_rec.assembly_item_id = FND_API.G_MISS_NUM)
1417: THEN

Line 1416: l_rtg_rev_unexp_rec.assembly_item_id = FND_API.G_MISS_NUM)

1412: );
1413: l_Return_Status := FND_API.G_RET_STS_ERROR;
1414: ELSIF l_err_text IS NOT NULL AND
1415: (l_rtg_rev_unexp_rec.assembly_item_id IS NULL OR
1416: l_rtg_rev_unexp_rec.assembly_item_id = FND_API.G_MISS_NUM)
1417: THEN
1418: -- This is an unexpected error.
1419: Error_Handler.Add_Error_Token
1420: ( p_Message_Name => NULL

Line 1426: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1422: G_PKG_NAME
1423: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1424: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1425: );
1426: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1427: END IF;
1428:
1429: If BOM_Rtg_Globals.Get_Debug = 'Y'
1430: THEN Error_Handler.Write_Debug

Line 1588: x_return_status := FND_API.G_RET_STS_SUCCESS;

1584: WHERE alternate_designator_code = p_alt_designator
1585: AND organization_id = p_organization_id;
1586:
1587: BEGIN
1588: x_return_status := FND_API.G_RET_STS_SUCCESS;
1589: l_return_status := FND_API.G_RET_STS_SUCCESS;
1590: l_com_op_unexp_rec := p_com_op_unexp_rec;
1591:
1592: If BOM_Rtg_Globals.Get_Debug = 'Y'

Line 1589: l_return_status := FND_API.G_RET_STS_SUCCESS;

1585: AND organization_id = p_organization_id;
1586:
1587: BEGIN
1588: x_return_status := FND_API.G_RET_STS_SUCCESS;
1589: l_return_status := FND_API.G_RET_STS_SUCCESS;
1590: l_com_op_unexp_rec := p_com_op_unexp_rec;
1591:
1592: If BOM_Rtg_Globals.Get_Debug = 'Y'
1593: THEN Error_Handler.Write_Debug

Line 1601: p_com_operation_rec.revised_item_name = FND_API.G_MISS_CHAR

1597: --
1598: -- Revised Item name cannot be NULL or missing.
1599: --
1600: IF p_com_operation_rec.revised_item_name IS NULL OR
1601: p_com_operation_rec.revised_item_name = FND_API.G_MISS_CHAR
1602: THEN
1603: Error_Handler.Add_Error_Token
1604: ( p_message_name => 'BOM_OP_AITEM_KEYCOL_NULL'
1605: , p_mesg_token_tbl => l_mesg_token_tbl

Line 1609: l_return_status := FND_API.G_RET_STS_ERROR;

1605: , p_mesg_token_tbl => l_mesg_token_tbl
1606: , x_mesg_token_tbl => l_mesg_token_tbl
1607: );
1608:
1609: l_return_status := FND_API.G_RET_STS_ERROR;
1610: END IF;
1611:
1612: --
1613: -- Operation sequence number cannot be NULL or missing.

Line 1616: p_com_operation_rec.operation_sequence_number = FND_API.G_MISS_NUM

1612: --
1613: -- Operation sequence number cannot be NULL or missing.
1614: --
1615: IF p_com_operation_rec.operation_sequence_number IS NULL OR
1616: p_com_operation_rec.operation_sequence_number = FND_API.G_MISS_NUM
1617: THEN
1618: Error_Handler.Add_Error_Token
1619: ( p_Message_Name => 'BOM_OP_SEQNUM_KEYCOL_NULL'
1620: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 1623: l_Return_Status := FND_API.G_RET_STS_ERROR;

1619: ( p_Message_Name => 'BOM_OP_SEQNUM_KEYCOL_NULL'
1620: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1621: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1622: );
1623: l_Return_Status := FND_API.G_RET_STS_ERROR;
1624: END IF;
1625:
1626: --
1627: -- Start effective date cannot be NULL or missing.

Line 1630: p_com_operation_rec.start_effective_date = FND_API.G_MISS_DATE)

1626: --
1627: -- Start effective date cannot be NULL or missing.
1628: --
1629: IF ( p_com_operation_rec.start_effective_date IS NULL OR
1630: p_com_operation_rec.start_effective_date = FND_API.G_MISS_DATE)
1631: AND ( p_com_operation_rec.operation_type NOT IN (2, 3)
1632: OR p_com_operation_rec.operation_type IS NULL)
1633: THEN
1634: Error_Handler.Add_Error_Token

Line 1639: l_Return_Status := FND_API.G_RET_STS_ERROR;

1635: ( p_Message_Name => 'BOM_OP_EFFECTIVITY_KEYCOL_NULL'
1636: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1637: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1638: );
1639: l_Return_Status := FND_API.G_RET_STS_ERROR;
1640: END IF;
1641:
1642: --
1643: -- If key columns are NULL, then return.

Line 1645: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

1641:
1642: --
1643: -- If key columns are NULL, then return.
1644: --
1645: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
1646: THEN
1647: x_return_status := l_return_status;
1648: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
1649: x_com_op_unexp_rec := l_com_op_unexp_rec;

Line 1679: l_Return_Status := FND_API.G_RET_STS_ERROR;

1675: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1676: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1677: , p_Token_Tbl => g_Token_Tbl
1678: );
1679: l_Return_Status := FND_API.G_RET_STS_ERROR;
1680: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
1681: x_com_op_unexp_rec := l_com_op_unexp_rec;
1682: x_Return_Status := l_Return_Status;
1683:

Line 1687: l_com_op_unexp_rec.revised_item_id = FND_API.G_MISS_NUM)

1683:
1684:
1685: ELSIF l_err_text IS NOT NULL AND
1686: (l_com_op_unexp_rec.revised_item_id IS NULL OR
1687: l_com_op_unexp_rec.revised_item_id = FND_API.G_MISS_NUM)
1688: THEN
1689: -- This is an unexpected error.
1690: Error_Handler.Add_Error_Token
1691: ( p_Message_Name => NULL

Line 1697: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1693: G_PKG_NAME
1694: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1695: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1696: );
1697: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1698: END IF;
1699:
1700:
1701:

Line 1710: p_com_operation_rec.alternate_routing_code <> FND_API.G_MISS_CHAR

1706: || ' Status ' || l_return_status);
1707: END IF;
1708:
1709: IF p_com_operation_rec.alternate_routing_code IS NOT NULL AND
1710: p_com_operation_rec.alternate_routing_code <> FND_API.G_MISS_CHAR
1711: THEN
1712: /*l_err_text_diff*/l_err_text := FND_API.G_RET_STS_ERROR;
1713:
1714: FOR check_alternate IN

Line 1712: /l_err_text_diff/l_err_text := FND_API.G_RET_STS_ERROR;

1708:
1709: IF p_com_operation_rec.alternate_routing_code IS NOT NULL AND
1710: p_com_operation_rec.alternate_routing_code <> FND_API.G_MISS_CHAR
1711: THEN
1712: /*l_err_text_diff*/l_err_text := FND_API.G_RET_STS_ERROR;
1713:
1714: FOR check_alternate IN
1715: c_Check_Alternate
1716: ( p_alt_designator =>

Line 1721: /l_err_text_diff/l_err_text := FND_API.G_RET_STS_SUCCESS;

1717: p_com_operation_rec.alternate_routing_code,
1718: p_organization_id =>
1719: l_com_op_unexp_rec.organization_id )
1720: LOOP
1721: /*l_err_text_diff*/l_err_text := FND_API.G_RET_STS_SUCCESS;
1722: END LOOP;
1723:
1724: IF /*l_err_text_diff*/l_err_text <> FND_API.G_RET_STS_SUCCESS
1725: THEN

Line 1724: IF /l_err_text_diff/l_err_text <> FND_API.G_RET_STS_SUCCESS

1720: LOOP
1721: /*l_err_text_diff*/l_err_text := FND_API.G_RET_STS_SUCCESS;
1722: END LOOP;
1723:
1724: IF /*l_err_text_diff*/l_err_text <> FND_API.G_RET_STS_SUCCESS
1725: THEN
1726: g_token_tbl(1).token_name :='ALTERNATE_ROUTING_CODE';
1727: g_token_tbl(1).token_value :=
1728: p_com_operation_rec.alternate_routing_code;

Line 1739: l_return_status := FND_API.G_RET_STS_ERROR;

1735: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1736: , p_token_tbl => g_token_tbl
1737: );
1738:
1739: l_return_status := FND_API.G_RET_STS_ERROR;
1740: END IF;
1741:
1742: END IF;
1743:

Line 1791: l_Return_Status := FND_API.G_RET_STS_ERROR;

1787: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1788: , p_Token_Tbl => g_Token_Tbl
1789: );
1790:
1791: l_Return_Status := FND_API.G_RET_STS_ERROR;
1792: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
1793: x_com_op_unexp_rec := l_com_op_unexp_rec;
1794: x_Return_Status := l_Return_Status;
1795:

Line 1838: l_Return_Status := FND_API.G_RET_STS_ERROR;

1834: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1835: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1836: , p_Token_Tbl => g_Token_Tbl
1837: );
1838: l_Return_Status := FND_API.G_RET_STS_ERROR;
1839: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
1840: x_com_op_unexp_rec := l_com_op_unexp_rec;
1841: x_Return_Status := l_Return_Status;
1842:

Line 1850: l_com_op_unexp_rec.routing_sequence_id= FND_API.G_MISS_NUM)

1846:
1847:
1848: ELSIF l_err_text IS NOT NULL AND
1849: (l_com_op_unexp_rec.routing_sequence_id IS NULL OR
1850: l_com_op_unexp_rec.routing_sequence_id= FND_API.G_MISS_NUM)
1851: THEN
1852: -- This is an unexpected error.
1853: Error_Handler.Add_Error_Token
1854: ( p_Message_Name => NULL

Line 1860: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1856: G_PKG_NAME
1857: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1858: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1859: );
1860: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1861: END IF;
1862: END IF ;
1863:
1864: IF BOM_Rtg_Globals.Get_Debug = 'Y'

Line 2012: l_return_status VARCHAR2(1):=FND_API.G_RET_STS_SUCCESS;

2008: , x_Return_Status IN OUT NOCOPY VARCHAR2
2009: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2010: )
2011: IS
2012: l_return_status VARCHAR2(1):=FND_API.G_RET_STS_SUCCESS;
2013: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
2014: l_err_text VARCHAR2(2000);
2015: l_Token_Tbl Error_Handler.Token_Tbl_Type;
2016: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type

Line 2030: p_com_operation_rec.standard_operation_code <> FND_API.G_MISS_CHAR

2026: --
2027: -- Convert standard operation code to standard operation id
2028: --
2029: IF p_com_operation_rec.standard_operation_code IS NOT NULL AND
2030: p_com_operation_rec.standard_operation_code <> FND_API.G_MISS_CHAR
2031: THEN
2032: IF BOM_Rtg_Globals.Get_Bo_Identifier = BOM_Rtg_Globals.G_RTG_BO
2033: THEN
2034:

Line 2077: l_return_status := FND_API.G_RET_STS_ERROR;

2073: , p_Message_name =>
2074: 'BOM_OP_STD_OP_CODE_INVALID'
2075: , p_token_tbl => l_token_tbl
2076: );
2077: l_return_status := FND_API.G_RET_STS_ERROR;
2078: ELSIF l_err_text IS NOT NULL AND
2079: l_com_op_unexp_rec.Standard_Operation_Id IS NULL
2080: THEN
2081: Error_Handler.Add_Error_Token

Line 2089: l_return_status :=FND_API.G_RET_STS_UNEXP_ERROR;

2085: 'Unexpected Error ' || l_err_text || ' in ' ||
2086: G_PKG_NAME
2087: , p_token_tbl => l_token_tbl
2088: );
2089: l_return_status :=FND_API.G_RET_STS_UNEXP_ERROR;
2090: END IF;
2091: END IF;
2092:
2093:

Line 2104: p_com_operation_rec.department_code <> FND_API.G_MISS_CHAR

2100: END IF;
2101:
2102:
2103: IF p_com_operation_rec.department_code IS NOT NULL AND
2104: p_com_operation_rec.department_code <> FND_API.G_MISS_CHAR
2105: THEN
2106: l_com_op_unexp_rec.department_id :=
2107: Department_Id
2108: ( p_department_code => p_com_operation_rec.department_code

Line 2128: l_return_status := FND_API.G_RET_STS_ERROR;

2124: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2125: , p_Message_name =>'BOM_OP_DEPT_CODE_INVALID'
2126: , p_token_tbl => l_token_tbl
2127: );
2128: l_return_status := FND_API.G_RET_STS_ERROR;
2129: ELSIF l_err_text IS NOT NULL AND
2130: l_com_op_unexp_rec.department_id IS NULL
2131: THEN
2132: Error_Handler.Add_Error_Token

Line 2140: l_return_status :=FND_API.G_RET_STS_UNEXP_ERROR;

2136: 'Unexpected Error ' || l_err_text || ' in '
2137: || G_PKG_NAME
2138: , p_token_tbl => l_token_tbl
2139: );
2140: l_return_status :=FND_API.G_RET_STS_UNEXP_ERROR;
2141: END IF;
2142: END IF;
2143:
2144: --

Line 2149: BOM_Rtg_Globals.Get_CFM_Rtg_Flag = FND_API.G_MISS_NUM

2145: -- If routing is flow routing, convert process code to proces_op
2146: -- _seq_id
2147: --
2148: IF BOM_Rtg_Globals.Get_CFM_Rtg_Flag IS NULL OR
2149: BOM_Rtg_Globals.Get_CFM_Rtg_Flag = FND_API.G_MISS_NUM
2150: THEN
2151: l_cfm_flag := Bom_Rtg_Validate.Get_Flow_Routing_Flag
2152: (l_com_op_unexp_rec.routing_sequence_id) ;
2153: BOM_Rtg_Globals.Set_CFM_Rtg_Flag(p_cfm_rtg_type => l_cfm_flag) ;

Line 2163: p_com_operation_rec.process_code <> FND_API.G_MISS_CHAR )

2159: IF l_cfm_flag = BOM_Rtg_Globals.G_FLOW_RTG
2160: THEN
2161:
2162: IF (p_com_operation_rec.process_code IS NOT NULL AND
2163: p_com_operation_rec.process_code <> FND_API.G_MISS_CHAR )
2164: OR
2165: (p_com_operation_rec.process_seq_number IS NOT NULL AND
2166: p_com_operation_rec.process_seq_number <> FND_API.G_MISS_NUM )
2167:

Line 2166: p_com_operation_rec.process_seq_number <> FND_API.G_MISS_NUM )

2162: IF (p_com_operation_rec.process_code IS NOT NULL AND
2163: p_com_operation_rec.process_code <> FND_API.G_MISS_CHAR )
2164: OR
2165: (p_com_operation_rec.process_seq_number IS NOT NULL AND
2166: p_com_operation_rec.process_seq_number <> FND_API.G_MISS_NUM )
2167:
2168: THEN
2169:
2170: l_com_op_unexp_rec.process_op_seq_id:=

Line 2189: <> FND_API.G_MISS_CHAR

2185:
2186: IF l_com_op_unexp_rec.process_op_seq_id IS NULL
2187: THEN
2188: IF p_com_operation_rec.process_code
2189: <> FND_API.G_MISS_CHAR
2190: THEN
2191: l_token_tbl(1).token_name :='PROCESS_CODE';
2192: l_token_tbl(1).token_value :=
2193: p_com_operation_rec.process_code;

Line 2197: <> FND_API.G_MISS_NUM

2193: p_com_operation_rec.process_code;
2194: END IF ;
2195:
2196: IF p_com_operation_rec.process_seq_number
2197: <> FND_API.G_MISS_NUM
2198: THEN
2199: l_token_tbl(2).token_name :='PROCESS_SEQ_NUM';
2200: l_token_tbl(2).token_value :=
2201: p_com_operation_rec.process_seq_number ;

Line 2212: l_return_status := FND_API.G_RET_STS_ERROR;

2208: 'BOM_FLM_OP_PSCODE_SQNM_INVALID'
2209: , p_token_tbl => l_token_tbl
2210: );
2211:
2212: l_return_status := FND_API.G_RET_STS_ERROR;
2213: l_token_tbl.delete ;
2214:
2215: ELSIF l_err_text IS NOT NULL AND
2216: l_com_op_unexp_rec.process_op_seq_id IS NULL

Line 2226: l_return_status :=FND_API.G_RET_STS_UNEXP_ERROR;

2222: 'Unexpected Error ' || l_err_text || ' in '
2223: || G_PKG_NAME
2224: , p_token_tbl => l_token_tbl
2225: );
2226: l_return_status :=FND_API.G_RET_STS_UNEXP_ERROR;
2227: END IF;
2228: END IF ;
2229: END IF;
2230:

Line 2238: p_com_operation_rec.line_op_code <> FND_API.G_MISS_CHAR )

2234: --
2235: IF l_cfm_flag = BOM_Rtg_Globals.G_FLOW_RTG
2236: THEN
2237: IF (p_com_operation_rec.line_op_code IS NOT NULL AND
2238: p_com_operation_rec.line_op_code <> FND_API.G_MISS_CHAR )
2239: OR
2240: (p_com_operation_rec.line_op_seq_number IS NOT NULL AND
2241: p_com_operation_rec.line_op_seq_number <>FND_API.G_MISS_NUM )
2242:

Line 2241: p_com_operation_rec.line_op_seq_number <>FND_API.G_MISS_NUM )

2237: IF (p_com_operation_rec.line_op_code IS NOT NULL AND
2238: p_com_operation_rec.line_op_code <> FND_API.G_MISS_CHAR )
2239: OR
2240: (p_com_operation_rec.line_op_seq_number IS NOT NULL AND
2241: p_com_operation_rec.line_op_seq_number <>FND_API.G_MISS_NUM )
2242:
2243: THEN
2244: l_com_op_unexp_rec.line_op_seq_id :=
2245: Line_Op_Seq_Id

Line 2264: -- 2863724 IF p_com_operation_rec.line_op_code <> FND_API.G_MISS_CHAR

2260: IF l_com_op_unexp_rec.line_op_seq_id IS NULL
2261: THEN
2262:
2263: -- to avoid conditions where record at first index may be null in l_token_tbl
2264: -- 2863724 IF p_com_operation_rec.line_op_code <> FND_API.G_MISS_CHAR
2265: -- 2863724 THEN
2266: l_token_tbl(1).token_name := 'LINE_OP_CODE';
2267: l_token_tbl(1).token_value :=
2268: p_com_operation_rec.line_op_code;

Line 2271: <> FND_API.G_MISS_NUM

2267: l_token_tbl(1).token_value :=
2268: p_com_operation_rec.line_op_code;
2269: -- 2863724 END IF ;
2270: IF p_com_operation_rec.line_op_seq_number
2271: <> FND_API.G_MISS_NUM
2272: THEN
2273:
2274: l_token_tbl(2).token_name := 'LINE_OP_SEQ_NUM';
2275: l_token_tbl(2).token_value :=

Line 2287: l_return_status := FND_API.G_RET_STS_ERROR;

2283: 'BOM_FLM_OP_LNOPCD_SQNM_INVALID'
2284: , p_token_tbl => l_token_tbl
2285: );
2286:
2287: l_return_status := FND_API.G_RET_STS_ERROR;
2288: l_token_tbl.delete ;
2289:
2290: ELSIF l_err_text IS NOT NULL AND
2291: l_com_op_unexp_rec.line_op_seq_id IS NULL

Line 2301: l_return_status :=FND_API.G_RET_STS_UNEXP_ERROR;

2297: 'Unexpected Error ' || l_err_text || ' in '
2298: || G_PKG_NAME
2299: , p_token_tbl => l_token_tbl
2300: );
2301: l_return_status :=FND_API.G_RET_STS_UNEXP_ERROR;
2302: END IF;
2303: END IF ;
2304: END IF;
2305:

Line 2314: AND p_com_operation_rec.old_start_effective_date <> FND_API.G_MISS_DATE

2310: --
2311: IF BOM_Rtg_Globals.Get_Bo_Identifier = BOM_Rtg_Globals.G_ECO_BO
2312: AND p_com_operation_rec.acd_type IN (2,3) -- Change or Disable
2313: AND p_com_operation_rec.old_start_effective_date IS NOT NULL
2314: AND p_com_operation_rec.old_start_effective_date <> FND_API.G_MISS_DATE
2315: -- p_com_operation_rec.old_operation_sequence_number IS NOT NULL AND
2316: -- p_com_operation_rec.old_operation_sequence_number <>
2317: -- FND_API.G_MISS_NUM
2318: THEN

Line 2317: -- FND_API.G_MISS_NUM

2313: AND p_com_operation_rec.old_start_effective_date IS NOT NULL
2314: AND p_com_operation_rec.old_start_effective_date <> FND_API.G_MISS_DATE
2315: -- p_com_operation_rec.old_operation_sequence_number IS NOT NULL AND
2316: -- p_com_operation_rec.old_operation_sequence_number <>
2317: -- FND_API.G_MISS_NUM
2318: THEN
2319:
2320: IF Bom_Rtg_Globals.Get_Debug = 'Y' THEN
2321: Error_Handler.Write_Debug('Executing old operation seq id Val-ID conversion . . .');

Line 2327: FND_API.G_MISS_NUM)

2323: END IF;
2324:
2325: IF (p_com_operation_rec.old_operation_sequence_number IS NULL
2326: OR p_com_operation_rec.old_operation_sequence_number =
2327: FND_API.G_MISS_NUM)
2328: THEN
2329: l_old_op_seq_number := p_com_operation_rec.operation_sequence_number ;
2330: ELSE
2331: l_old_op_seq_number := p_com_operation_rec.old_operation_sequence_number ;

Line 2348: l_Return_Status := FND_API.G_RET_STS_ERROR;

2344: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2345: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2346: , p_Token_Tbl => g_Token_Tbl
2347: );
2348: l_Return_Status := FND_API.G_RET_STS_ERROR;
2349:
2350: END IF ;
2351:
2352: l_com_op_unexp_rec.old_operation_sequence_id :=

Line 2382: l_Return_Status := FND_API.G_RET_STS_ERROR;

2378: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2379: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2380: , p_Token_Tbl => g_Token_Tbl
2381: );
2382: l_Return_Status := FND_API.G_RET_STS_ERROR;
2383: ELSIF l_com_op_unexp_rec.old_operation_sequence_id = FND_API.G_MISS_NUM
2384: THEN
2385: Error_Handler.Add_Error_Token
2386: ( p_Message_Name => NULL

Line 2383: ELSIF l_com_op_unexp_rec.old_operation_sequence_id = FND_API.G_MISS_NUM

2379: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2380: , p_Token_Tbl => g_Token_Tbl
2381: );
2382: l_Return_Status := FND_API.G_RET_STS_ERROR;
2383: ELSIF l_com_op_unexp_rec.old_operation_sequence_id = FND_API.G_MISS_NUM
2384: THEN
2385: Error_Handler.Add_Error_Token
2386: ( p_Message_Name => NULL
2387: , p_Message_Text =>

Line 2393: l_Return_Status := FND_API.G_RET_STS_ERROR;

2389: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2390: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2391:
2392: );
2393: l_Return_Status := FND_API.G_RET_STS_ERROR;
2394:
2395: END IF;
2396:
2397:

Line 2508: x_return_status := FND_API.G_RET_STS_SUCCESS;

2504: WHERE alternate_designator_code = p_alt_designator
2505: AND organization_id = p_organization_id;
2506:
2507: BEGIN
2508: x_return_status := FND_API.G_RET_STS_SUCCESS;
2509: l_return_status := FND_API.G_RET_STS_SUCCESS;
2510: l_rev_op_res_unexp_rec := p_rev_op_res_unexp_rec;
2511:
2512: If BOM_Rtg_Globals.Get_Debug = 'Y'

Line 2509: l_return_status := FND_API.G_RET_STS_SUCCESS;

2505: AND organization_id = p_organization_id;
2506:
2507: BEGIN
2508: x_return_status := FND_API.G_RET_STS_SUCCESS;
2509: l_return_status := FND_API.G_RET_STS_SUCCESS;
2510: l_rev_op_res_unexp_rec := p_rev_op_res_unexp_rec;
2511:
2512: If BOM_Rtg_Globals.Get_Debug = 'Y'
2513: THEN Error_Handler.Write_Debug

Line 2521: p_rev_op_resource_rec.revised_item_name = FND_API.G_MISS_CHAR

2517: --
2518: -- Assembly Item name cannot be NULL or missing.
2519: --
2520: IF p_rev_op_resource_rec.revised_item_name IS NULL OR
2521: p_rev_op_resource_rec.revised_item_name = FND_API.G_MISS_CHAR
2522: THEN
2523: Error_Handler.Add_Error_Token
2524: ( p_message_name => 'BOM_RES_AITEM_KEYCOL_NULL'
2525: , p_mesg_token_tbl => l_mesg_token_tbl

Line 2529: l_return_status := FND_API.G_RET_STS_ERROR;

2525: , p_mesg_token_tbl => l_mesg_token_tbl
2526: , x_mesg_token_tbl => l_mesg_token_tbl
2527: );
2528:
2529: l_return_status := FND_API.G_RET_STS_ERROR;
2530: END IF;
2531:
2532: --
2533: -- Resource sequence number cannot be NULL or missing.

Line 2536: p_rev_op_resource_rec.resource_sequence_number = FND_API.G_MISS_NUM

2532: --
2533: -- Resource sequence number cannot be NULL or missing.
2534: --
2535: IF p_rev_op_resource_rec.resource_sequence_number IS NULL OR
2536: p_rev_op_resource_rec.resource_sequence_number = FND_API.G_MISS_NUM
2537: THEN
2538: Error_Handler.Add_Error_Token
2539: ( p_Message_Name => 'BOM_RES_SEQNUM_KEYCOL_NULL'
2540: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 2543: l_Return_Status := FND_API.G_RET_STS_ERROR;

2539: ( p_Message_Name => 'BOM_RES_SEQNUM_KEYCOL_NULL'
2540: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2541: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2542: );
2543: l_Return_Status := FND_API.G_RET_STS_ERROR;
2544: END IF;
2545:
2546: --
2547: -- Operation sequence number cannot be NULL or missing.

Line 2551: FND_API.G_MISS_NUM

2547: -- Operation sequence number cannot be NULL or missing.
2548: --
2549: IF p_rev_op_resource_rec.operation_sequence_number IS NULL OR
2550: p_rev_op_resource_rec.operation_sequence_number =
2551: FND_API.G_MISS_NUM
2552: THEN
2553: Error_Handler.Add_Error_Token
2554: ( p_Message_Name => 'BOM_RES_OP_SEQNUM_KEYCOL_NULL'
2555: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 2558: l_Return_Status := FND_API.G_RET_STS_ERROR;

2554: ( p_Message_Name => 'BOM_RES_OP_SEQNUM_KEYCOL_NULL'
2555: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2556: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2557: );
2558: l_Return_Status := FND_API.G_RET_STS_ERROR;
2559: END IF;
2560:
2561: --
2562: -- Start effective date cannot be NULL or missing.

Line 2565: p_rev_op_resource_rec.op_start_effective_date = FND_API.G_MISS_DATE

2561: --
2562: -- Start effective date cannot be NULL or missing.
2563: --
2564: IF p_rev_op_resource_rec.op_start_effective_date IS NULL OR
2565: p_rev_op_resource_rec.op_start_effective_date = FND_API.G_MISS_DATE
2566: THEN
2567: Error_Handler.Add_Error_Token
2568: ( p_Message_Name => 'BOM_RES_EFF_DATE_KEYCOL_NULL'
2569: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 2572: l_Return_Status := FND_API.G_RET_STS_ERROR;

2568: ( p_Message_Name => 'BOM_RES_EFF_DATE_KEYCOL_NULL'
2569: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2570: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2571: );
2572: l_Return_Status := FND_API.G_RET_STS_ERROR;
2573: END IF;
2574:
2575: --
2576: -- If key columns are NULL, then return.

Line 2578: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

2574:
2575: --
2576: -- If key columns are NULL, then return.
2577: --
2578: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
2579: THEN
2580: x_Return_Status := FND_API.G_RET_STS_ERROR;
2581: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
2582: RETURN;

Line 2580: x_Return_Status := FND_API.G_RET_STS_ERROR;

2576: -- If key columns are NULL, then return.
2577: --
2578: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
2579: THEN
2580: x_Return_Status := FND_API.G_RET_STS_ERROR;
2581: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
2582: RETURN;
2583: END IF;
2584:

Line 2612: l_Return_Status := FND_API.G_RET_STS_ERROR;

2608: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2609: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2610: , p_Token_Tbl => g_Token_Tbl
2611: );
2612: l_Return_Status := FND_API.G_RET_STS_ERROR;
2613: ELSIF l_err_text IS NOT NULL AND
2614: ( l_rev_op_res_unexp_rec.revised_item_id IS NULL OR
2615: l_rev_op_res_unexp_rec.revised_item_id = FND_API.G_MISS_NUM)
2616: THEN

Line 2615: l_rev_op_res_unexp_rec.revised_item_id = FND_API.G_MISS_NUM)

2611: );
2612: l_Return_Status := FND_API.G_RET_STS_ERROR;
2613: ELSIF l_err_text IS NOT NULL AND
2614: ( l_rev_op_res_unexp_rec.revised_item_id IS NULL OR
2615: l_rev_op_res_unexp_rec.revised_item_id = FND_API.G_MISS_NUM)
2616: THEN
2617: -- This is an unexpected error.
2618: Error_Handler.Add_Error_Token
2619: ( p_Message_Name => NULL

Line 2625: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2621: G_PKG_NAME
2622: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2623: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2624: );
2625: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2626: END IF;
2627:
2628: IF BOM_Rtg_Globals.Get_Debug = 'Y'
2629: THEN Error_Handler.Write_Debug

Line 2636: p_rev_op_resource_rec.alternate_routing_code <> FND_API.G_MISS_CHAR

2632: || ' Status ' || l_return_status);
2633: END IF;
2634:
2635: IF p_rev_op_resource_rec.alternate_routing_code IS NOT NULL AND
2636: p_rev_op_resource_rec.alternate_routing_code <> FND_API.G_MISS_CHAR
2637: THEN
2638: /*l_err_text_diff*/l_err_text := FND_API.G_RET_STS_ERROR;
2639:
2640: FOR check_alternate IN

Line 2638: /l_err_text_diff/l_err_text := FND_API.G_RET_STS_ERROR;

2634:
2635: IF p_rev_op_resource_rec.alternate_routing_code IS NOT NULL AND
2636: p_rev_op_resource_rec.alternate_routing_code <> FND_API.G_MISS_CHAR
2637: THEN
2638: /*l_err_text_diff*/l_err_text := FND_API.G_RET_STS_ERROR;
2639:
2640: FOR check_alternate IN
2641: c_Check_Alternate
2642: ( p_alt_designator =>

Line 2647: /l_err_text_diff/l_err_text := FND_API.G_RET_STS_SUCCESS;

2643: p_rev_op_resource_rec.alternate_routing_code,
2644: p_organization_id =>
2645: l_rev_op_res_unexp_rec.organization_id )
2646: LOOP
2647: /*l_err_text_diff*/l_err_text := FND_API.G_RET_STS_SUCCESS;
2648: END LOOP;
2649:
2650: IF /*l_err_text_diff*/l_err_text <> FND_API.G_RET_STS_SUCCESS
2651: THEN

Line 2650: IF /l_err_text_diff/l_err_text <> FND_API.G_RET_STS_SUCCESS

2646: LOOP
2647: /*l_err_text_diff*/l_err_text := FND_API.G_RET_STS_SUCCESS;
2648: END LOOP;
2649:
2650: IF /*l_err_text_diff*/l_err_text <> FND_API.G_RET_STS_SUCCESS
2651: THEN
2652: g_token_tbl(1).token_name :='ALTERNATE_ROUTING_CODE';
2653: g_token_tbl(1).token_value :=
2654: p_rev_op_resource_rec.alternate_routing_code;

Line 2665: l_return_status := FND_API.G_RET_STS_ERROR;

2661: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2662: , p_token_tbl => g_token_tbl
2663: );
2664:
2665: l_return_status := FND_API.G_RET_STS_ERROR;
2666: END IF;
2667:
2668: END IF;
2669:

Line 2717: l_Return_Status := FND_API.G_RET_STS_ERROR;

2713: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2714: , p_Token_Tbl => g_Token_Tbl
2715: );
2716:
2717: l_Return_Status := FND_API.G_RET_STS_ERROR;
2718: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
2719: x_rev_op_res_unexp_rec := l_rev_op_res_unexp_rec;
2720: x_Return_Status := l_Return_Status;
2721:

Line 2764: l_Return_Status := FND_API.G_RET_STS_ERROR;

2760: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2761: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2762: , p_Token_Tbl => g_Token_Tbl
2763: );
2764: l_Return_Status := FND_API.G_RET_STS_ERROR;
2765: ELSIF l_err_text IS NOT NULL AND
2766: (l_rev_op_res_unexp_rec.routing_sequence_id IS NULL OR
2767: l_rev_op_res_unexp_rec.routing_sequence_id = FND_API.G_MISS_NUM)
2768: THEN

Line 2767: l_rev_op_res_unexp_rec.routing_sequence_id = FND_API.G_MISS_NUM)

2763: );
2764: l_Return_Status := FND_API.G_RET_STS_ERROR;
2765: ELSIF l_err_text IS NOT NULL AND
2766: (l_rev_op_res_unexp_rec.routing_sequence_id IS NULL OR
2767: l_rev_op_res_unexp_rec.routing_sequence_id = FND_API.G_MISS_NUM)
2768: THEN
2769: -- This is an unexpected error.
2770: Error_Handler.Add_Error_Token
2771: ( p_Message_Name => NULL

Line 2777: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2773: G_PKG_NAME
2774: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2775: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2776: );
2777: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2778: END IF;
2779: END IF ;
2780:
2781: -- Added by MK on 12/04/00

Line 2796: BOM_Rtg_Globals.Get_CFM_Rtg_Flag = FND_API.G_MISS_NUM

2792: --
2793: -- For flow routing, operatoin Type should be set in (1, 2, 3)
2794: --
2795: IF BOM_Rtg_Globals.Get_CFM_Rtg_Flag IS NULL OR
2796: BOM_Rtg_Globals.Get_CFM_Rtg_Flag = FND_API.G_MISS_NUM
2797: THEN
2798: l_cfm_flag := Bom_Rtg_Validate.Get_Flow_Routing_Flag(
2799: l_rev_op_res_unexp_rec.routing_sequence_id) ;
2800: BOM_Rtg_Globals.Set_CFM_Rtg_Flag(p_cfm_rtg_type => l_cfm_flag) ;

Line 2807: OR p_rev_op_resource_rec.operation_type = FND_API.G_MISS_NUM

2803:
2804: IF l_cfm_flag = BOM_Rtg_Globals.G_FLOW_RTG
2805: THEN
2806: IF p_rev_op_resource_rec.operation_type IS NULL
2807: OR p_rev_op_resource_rec.operation_type = FND_API.G_MISS_NUM
2808: OR p_rev_op_resource_rec.operation_type NOT IN (1, 2, 3)
2809: THEN
2810:
2811: IF p_rev_op_resource_rec.operation_type <> FND_API.G_MISS_NUM

Line 2811: IF p_rev_op_resource_rec.operation_type <> FND_API.G_MISS_NUM

2807: OR p_rev_op_resource_rec.operation_type = FND_API.G_MISS_NUM
2808: OR p_rev_op_resource_rec.operation_type NOT IN (1, 2, 3)
2809: THEN
2810:
2811: IF p_rev_op_resource_rec.operation_type <> FND_API.G_MISS_NUM
2812: THEN
2813: g_token_tbl(1).token_name := 'OPERATION_TYPE';
2814: g_token_tbl(1).token_value :=
2815: p_rev_op_resource_rec.operation_type ;

Line 2824: l_return_status := FND_API.G_RET_STS_ERROR ;

2820: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2821: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2822: , p_Token_Tbl => g_Token_Tbl
2823: );
2824: l_return_status := FND_API.G_RET_STS_ERROR ;
2825: END IF ;
2826: ELSE
2827: IF p_rev_op_resource_rec.operation_type IS NOT NULL
2828: AND p_rev_op_resource_rec.operation_type <> FND_API.G_MISS_NUM

Line 2828: AND p_rev_op_resource_rec.operation_type <> FND_API.G_MISS_NUM

2824: l_return_status := FND_API.G_RET_STS_ERROR ;
2825: END IF ;
2826: ELSE
2827: IF p_rev_op_resource_rec.operation_type IS NOT NULL
2828: AND p_rev_op_resource_rec.operation_type <> FND_API.G_MISS_NUM
2829: AND p_rev_op_resource_rec.operation_type <> 1
2830: THEN
2831: g_token_tbl(1).token_name := 'OPERATION_TYPE';
2832: g_token_tbl(1).token_value :=

Line 2841: l_return_status := FND_API.G_RET_STS_ERROR ;

2837: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2838: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2839: , p_Token_Tbl => g_Token_Tbl
2840: );
2841: l_return_status := FND_API.G_RET_STS_ERROR ;
2842: END IF ;
2843:
2844: END IF;
2845:

Line 2870: l_Return_Status := FND_API.G_RET_STS_ERROR;

2866: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2867: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2868: , p_Token_Tbl => g_Token_Tbl
2869: );
2870: l_Return_Status := FND_API.G_RET_STS_ERROR;
2871: ELSIF l_err_text IS NOT NULL AND
2872: (l_rev_op_res_unexp_rec.operation_sequence_id IS NULL OR
2873: l_rev_op_res_unexp_rec.operation_sequence_id = FND_API.G_MISS_NUM
2874: )

Line 2873: l_rev_op_res_unexp_rec.operation_sequence_id = FND_API.G_MISS_NUM

2869: );
2870: l_Return_Status := FND_API.G_RET_STS_ERROR;
2871: ELSIF l_err_text IS NOT NULL AND
2872: (l_rev_op_res_unexp_rec.operation_sequence_id IS NULL OR
2873: l_rev_op_res_unexp_rec.operation_sequence_id = FND_API.G_MISS_NUM
2874: )
2875: THEN
2876: -- This is an unexpected error.
2877: Error_Handler.Add_Error_Token

Line 2884: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2880: G_PKG_NAME
2881: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2882: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2883: );
2884: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2885: END IF;
2886:
2887: IF BOM_Rtg_Globals.Get_Debug = 'Y'
2888: THEN Error_Handler.Write_Debug

Line 2983: l_return_status VARCHAR2(1):=FND_API.G_RET_STS_SUCCESS;

2979: , x_Return_Status IN OUT NOCOPY VARCHAR2
2980: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2981: )
2982: IS
2983: l_return_status VARCHAR2(1):=FND_API.G_RET_STS_SUCCESS;
2984: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
2985: l_err_text VARCHAR2(2000);
2986: l_Token_Tbl Error_Handler.Token_Tbl_Type;
2987: l_rev_op_res_unexp_rec Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type

Line 3000: FND_API.G_MISS_CHAR

2996: -- Convert resource code to reosurce id
2997: --
2998: IF p_rev_op_resource_rec.resource_code IS NOT NULL AND
2999: p_rev_op_resource_rec.resource_code <>
3000: FND_API.G_MISS_CHAR
3001: THEN
3002:
3003: l_rev_op_res_unexp_rec.resource_id :=
3004: Resource_Id

Line 3025: l_return_status := FND_API.G_RET_STS_ERROR;

3021: , p_Message_name =>
3022: 'BOM_RES_RESCODE_INVALID'
3023: , p_token_tbl => l_token_tbl
3024: );
3025: l_return_status := FND_API.G_RET_STS_ERROR;
3026: ELSIF l_err_text IS NOT NULL AND
3027: l_rev_op_res_unexp_rec.resource_id IS NULL
3028: THEN
3029: Error_Handler.Add_Error_Token

Line 3037: l_return_status :=FND_API.G_RET_STS_UNEXP_ERROR;

3033: 'Unexpected Error ' || l_err_text || ' in ' ||
3034: G_PKG_NAME
3035: , p_token_tbl => l_token_tbl
3036: );
3037: l_return_status :=FND_API.G_RET_STS_UNEXP_ERROR;
3038: END IF;
3039:
3040: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
3041: ('Converted resource code . . .');

Line 3052: p_rev_op_resource_rec.activity <> FND_API.G_MISS_CHAR

3048: -- Convert activity to activity id
3049: --
3050:
3051: IF p_rev_op_resource_rec.activity IS NOT NULL AND
3052: p_rev_op_resource_rec.activity <> FND_API.G_MISS_CHAR
3053: THEN
3054: l_rev_op_res_unexp_rec.activity_id :=
3055: Activity_Id
3056: ( p_activity =>

Line 3075: l_return_status := FND_API.G_RET_STS_ERROR;

3071: , p_Message_name =>
3072: 'BOM_RES_ACTIVITY_CODE_INVALID'
3073: , p_token_tbl => l_token_tbl
3074: );
3075: l_return_status := FND_API.G_RET_STS_ERROR;
3076: ELSIF l_err_text IS NOT NULL AND
3077: l_rev_op_res_unexp_rec.activity_id IS NULL
3078: THEN
3079: Error_Handler.Add_Error_Token

Line 3087: l_return_status :=FND_API.G_RET_STS_UNEXP_ERROR;

3083: 'Unexpected Error ' || l_err_text || ' in ' ||
3084: G_PKG_NAME
3085: , p_token_tbl => l_token_tbl
3086: );
3087: l_return_status :=FND_API.G_RET_STS_UNEXP_ERROR;
3088: END IF;
3089:
3090: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
3091: ('Converted activity. . .');

Line 3101: p_rev_op_resource_rec.setup_type <> FND_API.G_MISS_CHAR

3097: --
3098: -- Convert setup code to setup id
3099: --
3100: IF p_rev_op_resource_rec.setup_type IS NOT NULL AND
3101: p_rev_op_resource_rec.setup_type <> FND_API.G_MISS_CHAR
3102: THEN
3103: l_rev_op_res_unexp_rec.setup_id :=
3104: Setup_Id
3105: ( p_setup_type =>

Line 3124: l_return_status := FND_API.G_RET_STS_ERROR;

3120: , p_Message_name =>
3121: 'BOM_RES_SETUP_CODE_INVALID'
3122: , p_token_tbl => l_token_tbl
3123: );
3124: l_return_status := FND_API.G_RET_STS_ERROR;
3125: ELSIF l_err_text IS NOT NULL AND
3126: l_rev_op_res_unexp_rec.setup_id IS NULL
3127: THEN
3128: Error_Handler.Add_Error_Token

Line 3136: l_return_status :=FND_API.G_RET_STS_UNEXP_ERROR;

3132: 'Unexpected Error ' || l_err_text || ' in ' ||
3133: G_PKG_NAME
3134: , p_token_tbl => l_token_tbl
3135: );
3136: l_return_status :=FND_API.G_RET_STS_UNEXP_ERROR;
3137: END IF;
3138:
3139: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
3140: ('Converted setup code . . .');

Line 3255: x_return_status := FND_API.G_RET_STS_SUCCESS;

3251: WHERE alternate_designator_code = p_alt_designator
3252: AND organization_id = p_organization_id;
3253:
3254: BEGIN
3255: x_return_status := FND_API.G_RET_STS_SUCCESS;
3256: l_return_status := FND_API.G_RET_STS_SUCCESS;
3257: l_rev_sub_res_unexp_rec := p_rev_sub_res_unexp_rec ;
3258:
3259: IF BOM_Rtg_Globals.Get_Debug = 'Y'

Line 3256: l_return_status := FND_API.G_RET_STS_SUCCESS;

3252: AND organization_id = p_organization_id;
3253:
3254: BEGIN
3255: x_return_status := FND_API.G_RET_STS_SUCCESS;
3256: l_return_status := FND_API.G_RET_STS_SUCCESS;
3257: l_rev_sub_res_unexp_rec := p_rev_sub_res_unexp_rec ;
3258:
3259: IF BOM_Rtg_Globals.Get_Debug = 'Y'
3260: THEN Error_Handler.Write_Debug

Line 3268: p_rev_sub_resource_rec.revised_item_name = FND_API.G_MISS_CHAR

3264: --
3265: -- Assembly Item name cannot be NULL or missing.
3266: --
3267: IF p_rev_sub_resource_rec.revised_item_name IS NULL OR
3268: p_rev_sub_resource_rec.revised_item_name = FND_API.G_MISS_CHAR
3269: THEN
3270: Error_Handler.Add_Error_Token
3271: ( p_message_name => 'BOM_SUB_RES_AITEM_KEYCOL_NULL'
3272: , p_mesg_token_tbl => l_mesg_token_tbl

Line 3276: l_return_status := FND_API.G_RET_STS_ERROR;

3272: , p_mesg_token_tbl => l_mesg_token_tbl
3273: , x_mesg_token_tbl => l_mesg_token_tbl
3274: );
3275:
3276: l_return_status := FND_API.G_RET_STS_ERROR;
3277: END IF;
3278:
3279: /* bug:4714714 - Commented the below check on Alternate routing code as
3280: creation/updation of alternate resources should be allowed for alternate routings also.

Line 3285: p_rev_sub_resource_rec.alternate_routing_code <> FND_API.G_MISS_CHAR

3281: --
3282: -- Alternate routing code should be NULL or missing.
3283: --
3284: IF p_rev_sub_resource_rec.alternate_routing_code IS NOT NULL AND
3285: p_rev_sub_resource_rec.alternate_routing_code <> FND_API.G_MISS_CHAR
3286: THEN
3287: Error_Handler.Add_Error_Token
3288: ( p_Message_Name => 'BOM_SUB_RES_ALTER_CD_NOT_NULL'
3289: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 3292: l_Return_Status := FND_API.G_RET_STS_ERROR;

3288: ( p_Message_Name => 'BOM_SUB_RES_ALTER_CD_NOT_NULL'
3289: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3290: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3291: );
3292: l_Return_Status := FND_API.G_RET_STS_ERROR;
3293: END IF;
3294: */
3295:
3296: --

Line 3302: p_rev_sub_resource_rec.sub_resource_code = FND_API.G_MISS_CHAR

3298: -- Sub resource code cannot be NULL or missing.
3299: -- Sub resource code should exist in BOM_RESOURCE
3300: --
3301: IF p_rev_sub_resource_rec.sub_resource_code IS NULL OR
3302: p_rev_sub_resource_rec.sub_resource_code = FND_API.G_MISS_CHAR
3303: THEN
3304: Error_Handler.Add_Error_Token
3305: ( p_message_name => 'BOM_SUB_RES_CODE_KEYCOL_NULL'
3306: , p_mesg_token_tbl => l_mesg_token_tbl

Line 3310: l_return_status := FND_API.G_RET_STS_ERROR;

3306: , p_mesg_token_tbl => l_mesg_token_tbl
3307: , x_mesg_token_tbl => l_mesg_token_tbl
3308: );
3309:
3310: l_return_status := FND_API.G_RET_STS_ERROR;
3311:
3312: END IF;
3313:
3314: --

Line 3321: = FND_API.G_MISS_NUM

3317: --
3318: -- IF nvl(BOM_Globals.Get_Caller_Type,'') <> 'MIGRATION' THEN
3319: IF nvl(p_rev_sub_resource_rec.substitute_group_number, p_rev_sub_res_unexp_rec.substitute_group_number) IS NULL OR
3320: nvl(p_rev_sub_resource_rec.substitute_group_number, p_rev_sub_res_unexp_rec.substitute_group_number)
3321: = FND_API.G_MISS_NUM
3322: THEN
3323: Error_Handler.Add_Error_Token
3324: ( p_message_name => 'BOM_SUB_RES_SCHDNM_KEYCOL_NULL'
3325: , p_mesg_token_tbl => l_mesg_token_tbl

Line 3329: l_return_status := FND_API.G_RET_STS_ERROR;

3325: , p_mesg_token_tbl => l_mesg_token_tbl
3326: , x_mesg_token_tbl => l_mesg_token_tbl
3327: );
3328:
3329: l_return_status := FND_API.G_RET_STS_ERROR;
3330: END IF;
3331: -- END IF; --migration
3332:
3333: --

Line 3339: = FND_API.G_MISS_NUM

3335: -- Operation sequence number cannot be NULL or missing.
3336: --
3337: IF p_rev_sub_resource_rec.operation_sequence_number IS NULL OR
3338: p_rev_sub_resource_rec.operation_sequence_number
3339: = FND_API.G_MISS_NUM
3340: THEN
3341: Error_Handler.Add_Error_Token
3342: ( p_message_name => 'BOM_SUB_RES_OP_SQNM_KEYCOL_NULL'
3343: , p_mesg_token_tbl => l_mesg_token_tbl

Line 3347: l_return_status := FND_API.G_RET_STS_ERROR;

3343: , p_mesg_token_tbl => l_mesg_token_tbl
3344: , x_mesg_token_tbl => l_mesg_token_tbl
3345: );
3346:
3347: l_return_status := FND_API.G_RET_STS_ERROR;
3348: END IF;
3349:
3350: --
3351: --

Line 3356: = FND_API.G_MISS_DATE

3352: -- Start effective date cannot be NULL or missing.
3353: --
3354: IF p_rev_sub_resource_rec.op_start_effective_date IS NULL OR
3355: p_rev_sub_resource_rec.op_start_effective_date
3356: = FND_API.G_MISS_DATE
3357: THEN
3358: Error_Handler.Add_Error_Token
3359: ( p_message_name =>
3360: 'BOM_SUB_RES_EFFDT_KEYCOL_NULL'

Line 3365: l_return_status := FND_API.G_RET_STS_ERROR;

3361: , p_mesg_token_tbl => l_mesg_token_tbl
3362: , x_mesg_token_tbl => l_mesg_token_tbl
3363: );
3364:
3365: l_return_status := FND_API.G_RET_STS_ERROR;
3366: END IF;
3367:
3368: IF BOM_Rtg_Globals.Get_Debug = 'Y'
3369: THEN Error_Handler.Write_Debug

Line 3376: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

3372:
3373: --
3374: -- If key columns are NULL, then return.
3375: --
3376: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
3377: THEN
3378: x_Return_Status := FND_API.G_RET_STS_ERROR;
3379: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
3380: RETURN;

Line 3378: x_Return_Status := FND_API.G_RET_STS_ERROR;

3374: -- If key columns are NULL, then return.
3375: --
3376: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
3377: THEN
3378: x_Return_Status := FND_API.G_RET_STS_ERROR;
3379: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
3380: RETURN;
3381: END IF;
3382:

Line 3409: l_Return_Status := FND_API.G_RET_STS_ERROR;

3405: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3406: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3407: , p_Token_Tbl => g_Token_Tbl
3408: );
3409: l_Return_Status := FND_API.G_RET_STS_ERROR;
3410: ELSIF l_err_text IS NOT NULL AND
3411: ( l_rev_sub_res_unexp_rec.revised_item_id IS NULL OR
3412: l_rev_sub_res_unexp_rec.revised_item_id = FND_API.G_MISS_NUM)
3413: THEN

Line 3412: l_rev_sub_res_unexp_rec.revised_item_id = FND_API.G_MISS_NUM)

3408: );
3409: l_Return_Status := FND_API.G_RET_STS_ERROR;
3410: ELSIF l_err_text IS NOT NULL AND
3411: ( l_rev_sub_res_unexp_rec.revised_item_id IS NULL OR
3412: l_rev_sub_res_unexp_rec.revised_item_id = FND_API.G_MISS_NUM)
3413: THEN
3414: -- This is an unexpected error.
3415: Error_Handler.Add_Error_Token
3416: ( p_Message_Name => NULL

Line 3422: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3418: G_PKG_NAME
3419: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3420: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3421: );
3422: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3423: END IF;
3424:
3425: IF BOM_Rtg_Globals.Get_Debug = 'Y'
3426: THEN Error_Handler.Write_Debug

Line 3433: p_rev_sub_resource_rec.alternate_routing_code <> FND_API.G_MISS_CHAR

3429: || ' Status ' || l_return_status);
3430: END IF;
3431:
3432: IF p_rev_sub_resource_rec.alternate_routing_code IS NOT NULL AND
3433: p_rev_sub_resource_rec.alternate_routing_code <> FND_API.G_MISS_CHAR
3434: THEN
3435: /*l_err_text_diff*/l_err_text := FND_API.G_RET_STS_ERROR;
3436:
3437: FOR check_alternate IN

Line 3435: /l_err_text_diff/l_err_text := FND_API.G_RET_STS_ERROR;

3431:
3432: IF p_rev_sub_resource_rec.alternate_routing_code IS NOT NULL AND
3433: p_rev_sub_resource_rec.alternate_routing_code <> FND_API.G_MISS_CHAR
3434: THEN
3435: /*l_err_text_diff*/l_err_text := FND_API.G_RET_STS_ERROR;
3436:
3437: FOR check_alternate IN
3438: c_Check_Alternate
3439: ( p_alt_designator =>

Line 3444: /l_err_text_diff/l_err_text := FND_API.G_RET_STS_SUCCESS;

3440: p_rev_sub_resource_rec.alternate_routing_code,
3441: p_organization_id =>
3442: l_rev_sub_res_unexp_rec.organization_id )
3443: LOOP
3444: /*l_err_text_diff*/l_err_text := FND_API.G_RET_STS_SUCCESS;
3445: END LOOP;
3446:
3447: IF /*l_err_text_diff*/l_err_text <> FND_API.G_RET_STS_SUCCESS
3448: THEN

Line 3447: IF /l_err_text_diff/l_err_text <> FND_API.G_RET_STS_SUCCESS

3443: LOOP
3444: /*l_err_text_diff*/l_err_text := FND_API.G_RET_STS_SUCCESS;
3445: END LOOP;
3446:
3447: IF /*l_err_text_diff*/l_err_text <> FND_API.G_RET_STS_SUCCESS
3448: THEN
3449: g_token_tbl(1).token_name :='ALTERNATE_ROUTING_CODE';
3450: g_token_tbl(1).token_value :=
3451: p_rev_sub_resource_rec.alternate_routing_code;

Line 3463: l_return_status := FND_API.G_RET_STS_ERROR;

3459: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3460: , p_token_tbl => g_token_tbl
3461: );
3462:
3463: l_return_status := FND_API.G_RET_STS_ERROR;
3464: END IF;
3465:
3466: END IF;
3467:

Line 3515: l_Return_Status := FND_API.G_RET_STS_ERROR;

3511: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3512: , p_Token_Tbl => g_Token_Tbl
3513: );
3514:
3515: l_Return_Status := FND_API.G_RET_STS_ERROR;
3516: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
3517: x_rev_sub_res_unexp_rec := l_rev_sub_res_unexp_rec;
3518: x_Return_Status := l_Return_Status;
3519:

Line 3566: l_Return_Status := FND_API.G_RET_STS_ERROR;

3562: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3563: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3564: , p_Token_Tbl => g_Token_Tbl
3565: );
3566: l_Return_Status := FND_API.G_RET_STS_ERROR;
3567: ELSIF l_err_text IS NOT NULL AND
3568: (l_rev_sub_res_unexp_rec.routing_sequence_id IS NULL OR
3569: l_rev_sub_res_unexp_rec.routing_sequence_id = FND_API.G_MISS_NUM)
3570: THEN

Line 3569: l_rev_sub_res_unexp_rec.routing_sequence_id = FND_API.G_MISS_NUM)

3565: );
3566: l_Return_Status := FND_API.G_RET_STS_ERROR;
3567: ELSIF l_err_text IS NOT NULL AND
3568: (l_rev_sub_res_unexp_rec.routing_sequence_id IS NULL OR
3569: l_rev_sub_res_unexp_rec.routing_sequence_id = FND_API.G_MISS_NUM)
3570: THEN
3571: -- This is an unexpected error.
3572: Error_Handler.Add_Error_Token
3573: ( p_Message_Name => NULL

Line 3579: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3575: G_PKG_NAME
3576: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3577: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3578: );
3579: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3580: END IF;
3581:
3582: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN
3583: Error_Handler.Write_Debug('After converting, routing sequence id is '

Line 3600: l_cfm_flag = FND_API.G_MISS_NUM

3596: -- For non flow routing,
3597:
3598: l_cfm_flag := BOM_Rtg_Globals.Get_CFM_Rtg_Flag ;
3599: IF l_cfm_flag IS NULL OR
3600: l_cfm_flag = FND_API.G_MISS_NUM
3601: THEN
3602: l_cfm_flag := Bom_Rtg_Validate.Get_Flow_Routing_Flag(
3603: p_routing_sequence_id =>
3604: l_rev_sub_res_unexp_rec.routing_sequence_id ) ;

Line 3611: OR p_rev_sub_resource_rec.operation_type = FND_API.G_MISS_NUM

3607:
3608: IF l_cfm_flag = BOM_Rtg_Globals.G_FLOW_RTG
3609: THEN
3610: IF p_rev_sub_resource_rec.operation_type IS NULL
3611: OR p_rev_sub_resource_rec.operation_type = FND_API.G_MISS_NUM
3612: OR p_rev_sub_resource_rec.operation_type NOT IN (1, 2, 3)
3613: THEN
3614: IF p_rev_sub_resource_rec.operation_type <> FND_API.G_MISS_NUM
3615: THEN

Line 3614: IF p_rev_sub_resource_rec.operation_type <> FND_API.G_MISS_NUM

3610: IF p_rev_sub_resource_rec.operation_type IS NULL
3611: OR p_rev_sub_resource_rec.operation_type = FND_API.G_MISS_NUM
3612: OR p_rev_sub_resource_rec.operation_type NOT IN (1, 2, 3)
3613: THEN
3614: IF p_rev_sub_resource_rec.operation_type <> FND_API.G_MISS_NUM
3615: THEN
3616: g_token_tbl(1).token_name := 'OPERATION_TYPE';
3617: g_token_tbl(1).token_value :=
3618: p_rev_sub_resource_rec.operation_type;

Line 3627: l_return_status := FND_API.G_RET_STS_ERROR ;

3623: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3624: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3625: , p_Token_Tbl => g_Token_Tbl
3626: );
3627: l_return_status := FND_API.G_RET_STS_ERROR ;
3628:
3629: END IF ;
3630: ELSE
3631: IF p_rev_sub_resource_rec.operation_type IS NOT NULL

Line 3632: AND p_rev_sub_resource_rec.operation_type <> FND_API.G_MISS_NUM

3628:
3629: END IF ;
3630: ELSE
3631: IF p_rev_sub_resource_rec.operation_type IS NOT NULL
3632: AND p_rev_sub_resource_rec.operation_type <> FND_API.G_MISS_NUM
3633: AND p_rev_sub_resource_rec.operation_type <> 1
3634: THEN
3635: g_token_tbl(1).token_name := 'OPERATION_TYPE';
3636: g_token_tbl(1).token_value :=

Line 3645: l_return_status := FND_API.G_RET_STS_ERROR ;

3641: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3642: , p_Token_Tbl => g_Token_Tbl
3643: );
3644:
3645: l_return_status := FND_API.G_RET_STS_ERROR ;
3646: END IF ;
3647:
3648: END IF;
3649:

Line 3679: l_Return_Status := FND_API.G_RET_STS_ERROR;

3675: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3676: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3677: , p_Token_Tbl => g_Token_Tbl
3678: );
3679: l_Return_Status := FND_API.G_RET_STS_ERROR;
3680: ELSIF l_err_text IS NOT NULL AND
3681: (
3682: l_rev_sub_res_unexp_rec.operation_sequence_id IS NULL OR
3683: l_rev_sub_res_unexp_rec.operation_sequence_id =FND_API.G_MISS_NUM

Line 3683: l_rev_sub_res_unexp_rec.operation_sequence_id =FND_API.G_MISS_NUM

3679: l_Return_Status := FND_API.G_RET_STS_ERROR;
3680: ELSIF l_err_text IS NOT NULL AND
3681: (
3682: l_rev_sub_res_unexp_rec.operation_sequence_id IS NULL OR
3683: l_rev_sub_res_unexp_rec.operation_sequence_id =FND_API.G_MISS_NUM
3684: )
3685: THEN
3686: -- This is an unexpected error.
3687: Error_Handler.Add_Error_Token

Line 3694: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3690: G_PKG_NAME
3691: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3692: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3693: );
3694: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3695: END IF;
3696:
3697: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN
3698: Error_Handler.Write_Debug('After converting, op sequence id is '

Line 3707: p_rev_sub_resource_rec.sub_resource_code <> FND_API.G_MISS_CHAR

3703: --
3704: -- convert resource code to resource id
3705: --
3706: IF p_rev_sub_resource_rec.sub_resource_code IS NOT NULL AND
3707: p_rev_sub_resource_rec.sub_resource_code <> FND_API.G_MISS_CHAR
3708: THEN
3709: l_rev_sub_res_unexp_rec.resource_id :=
3710: Resource_Id
3711: ( p_resource_code =>

Line 3731: l_return_status := FND_API.G_RET_STS_ERROR;

3727: , p_Message_name =>
3728: 'BOM_SUB_RES_SUB_RES_CD_INVALID'
3729: , p_token_tbl => l_token_tbl
3730: );
3731: l_return_status := FND_API.G_RET_STS_ERROR;
3732: ELSIF l_err_text IS NOT NULL AND
3733: l_rev_sub_res_unexp_rec.resource_id IS NULL
3734: THEN
3735: Error_Handler.Add_Error_Token

Line 3743: l_return_status :=FND_API.G_RET_STS_UNEXP_ERROR;

3739: 'Unexpected Error ' || l_err_text || ' in ' ||
3740: G_PKG_NAME
3741: , p_token_tbl => l_token_tbl
3742: );
3743: l_return_status :=FND_API.G_RET_STS_UNEXP_ERROR;
3744: END IF;
3745: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN
3746: Error_Handler.Write_Debug('After converting, Resource Id is '
3747: || to_char(l_rev_sub_res_unexp_rec.resource_id)

Line 3776: l_return_status := FND_API.G_RET_STS_ERROR;

3772: , p_Message_name =>
3773: 'BOM_SUB_RES_RELRES_NOT_FOUND'
3774: , p_token_tbl => l_token_tbl
3775: );
3776: l_return_status := FND_API.G_RET_STS_ERROR;
3777: END IF;
3778: END IF;
3779:
3780: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN

Line 3874: l_return_status VARCHAR2(1):=FND_API.G_RET_STS_SUCCESS;

3870: , x_Return_Status IN OUT NOCOPY VARCHAR2
3871: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3872: )
3873: IS
3874: l_return_status VARCHAR2(1):=FND_API.G_RET_STS_SUCCESS;
3875: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
3876: l_err_text VARCHAR2(2000);
3877: l_Token_Tbl Error_Handler.Token_Tbl_Type;
3878: l_rev_sub_res_unexp_rec Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type

Line 3891: p_rev_sub_resource_rec.activity <> FND_API.G_MISS_CHAR

3887: -- Convert activity to activity id
3888: --
3889:
3890: IF p_rev_sub_resource_rec.activity IS NOT NULL AND
3891: p_rev_sub_resource_rec.activity <> FND_API.G_MISS_CHAR
3892: THEN
3893:
3894: l_rev_sub_res_unexp_rec.activity_id :=
3895: Activity_Id

Line 3915: l_return_status := FND_API.G_RET_STS_ERROR;

3911: , p_Message_name =>
3912: 'BOM_SUB_RES_ACT_CD_INVALID'
3913: , p_token_tbl => l_token_tbl
3914: );
3915: l_return_status := FND_API.G_RET_STS_ERROR;
3916: ELSIF l_err_text IS NOT NULL AND
3917: l_rev_sub_res_unexp_rec.activity_id IS NULL
3918: THEN
3919: Error_Handler.Add_Error_Token

Line 3927: l_return_status :=FND_API.G_RET_STS_UNEXP_ERROR;

3923: 'Unexpected Error ' || l_err_text || ' in ' ||
3924: G_PKG_NAME
3925: , p_token_tbl => l_token_tbl
3926: );
3927: l_return_status :=FND_API.G_RET_STS_UNEXP_ERROR;
3928: END IF;
3929: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN
3930: Error_Handler.Write_Debug('Converted activity id. '|| to_char(l_rev_sub_res_unexp_rec.activity_id) );
3931: END IF;

Line 3941: FND_API.G_MISS_CHAR

3937: -- Convert new resource code to new reosurce id
3938: --
3939: IF p_rev_sub_resource_rec.new_sub_resource_code IS NOT NULL AND
3940: p_rev_sub_resource_rec.new_sub_resource_code <>
3941: FND_API.G_MISS_CHAR
3942: THEN
3943:
3944: l_rev_sub_res_unexp_rec.new_resource_id :=
3945: Resource_Id

Line 3966: l_return_status := FND_API.G_RET_STS_ERROR;

3962: , p_Message_name =>
3963: 'BOM_SUB_RES_SUB_RES_CD_INVALID'
3964: , p_token_tbl => l_token_tbl
3965: );
3966: l_return_status := FND_API.G_RET_STS_ERROR;
3967: ELSIF l_err_text IS NOT NULL AND
3968: l_rev_sub_res_unexp_rec.new_resource_id IS NULL
3969: THEN
3970: Error_Handler.Add_Error_Token

Line 3978: l_return_status :=FND_API.G_RET_STS_UNEXP_ERROR;

3974: 'Unexpected Error ' || l_err_text || ' in ' ||
3975: G_PKG_NAME
3976: , p_token_tbl => l_token_tbl
3977: );
3978: l_return_status :=FND_API.G_RET_STS_UNEXP_ERROR;
3979: END IF;
3980:
3981: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
3982: ('Converted new sub resource id. ' || to_char(l_rev_sub_res_unexp_rec.new_resource_id) ) ;

Line 3991: p_rev_sub_resource_rec.setup_type <> FND_API.G_MISS_CHAR

3987: --
3988: -- Convert setup code to setup id
3989: --
3990: IF p_rev_sub_resource_rec.setup_type IS NOT NULL AND
3991: p_rev_sub_resource_rec.setup_type <> FND_API.G_MISS_CHAR
3992: THEN
3993: l_rev_sub_res_unexp_rec.setup_id :=
3994: Setup_Id
3995: ( p_setup_type =>

Line 4014: l_return_status := FND_API.G_RET_STS_ERROR;

4010: , p_Message_name =>
4011: 'BOM_SUB_RES_SETUP_CODE_INVALID'
4012: , p_token_tbl => l_token_tbl
4013: );
4014: l_return_status := FND_API.G_RET_STS_ERROR;
4015: ELSIF l_err_text IS NOT NULL AND
4016: l_rev_sub_res_unexp_rec.setup_id IS NULL
4017: THEN
4018: Error_Handler.Add_Error_Token

Line 4026: l_return_status :=FND_API.G_RET_STS_UNEXP_ERROR;

4022: 'Unexpected Error ' || l_err_text || ' in ' ||
4023: G_PKG_NAME
4024: , p_token_tbl => l_token_tbl
4025: );
4026: l_return_status :=FND_API.G_RET_STS_UNEXP_ERROR;
4027: END IF;
4028:
4029: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN
4030: Error_Handler.Write_Debug ('Converted setup code . . .');

Line 4086: x_return_status := FND_API.G_RET_STS_SUCCESS;

4082: x_temp_op_rec BOM_RTG_Globals.Temp_Op_Rec_Type;
4083: /***END 1838261***/
4084: l_temp_op_rec_tbl_test BOM_RTG_Globals.Temp_Op_Rec_Tbl_Type;--for testing by Dev
4085: BEGIN
4086: x_return_status := FND_API.G_RET_STS_SUCCESS;
4087: l_return_status := FND_API.G_RET_STS_SUCCESS;
4088: l_op_network_unexp_rec := p_op_network_unexp_rec;
4089:
4090: IF BOM_Rtg_Globals.Get_Debug = 'Y'

Line 4087: l_return_status := FND_API.G_RET_STS_SUCCESS;

4083: /***END 1838261***/
4084: l_temp_op_rec_tbl_test BOM_RTG_Globals.Temp_Op_Rec_Tbl_Type;--for testing by Dev
4085: BEGIN
4086: x_return_status := FND_API.G_RET_STS_SUCCESS;
4087: l_return_status := FND_API.G_RET_STS_SUCCESS;
4088: l_op_network_unexp_rec := p_op_network_unexp_rec;
4089:
4090: IF BOM_Rtg_Globals.Get_Debug = 'Y'
4091: THEN Error_Handler.Write_Debug

Line 4099: p_op_network_rec.assembly_item_name = FND_API.G_MISS_CHAR

4095: --
4096: -- Assembly Item name cannot be NULL or missing.
4097: --
4098: IF p_op_network_rec.assembly_item_name IS NULL OR
4099: p_op_network_rec.assembly_item_name = FND_API.G_MISS_CHAR
4100: THEN
4101: Error_Handler.Add_Error_Token
4102: ( p_message_name => 'BOM_OP_NWK_AITEM_KEYCOL_NULL'
4103: , p_mesg_token_tbl => l_mesg_token_tbl

Line 4107: l_return_status := FND_API.G_RET_STS_ERROR;

4103: , p_mesg_token_tbl => l_mesg_token_tbl
4104: , x_mesg_token_tbl => l_mesg_token_tbl
4105: );
4106:
4107: l_return_status := FND_API.G_RET_STS_ERROR;
4108: END IF;
4109:
4110: --
4111: -- From operation sequence number cannot be NULL or missing.

Line 4115: = FND_API.G_MISS_NUM

4111: -- From operation sequence number cannot be NULL or missing.
4112: --
4113: IF p_op_network_rec.from_op_seq_number IS NULL OR
4114: p_op_network_rec.from_op_seq_number
4115: = FND_API.G_MISS_NUM
4116: THEN
4117: Error_Handler.Add_Error_Token
4118: ( p_Message_Name => 'BOM_OP_NWK_SEQNUM_KEYCOL_NULL'
4119: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 4122: l_Return_Status := FND_API.G_RET_STS_ERROR;

4118: ( p_Message_Name => 'BOM_OP_NWK_SEQNUM_KEYCOL_NULL'
4119: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
4120: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
4121: );
4122: l_Return_Status := FND_API.G_RET_STS_ERROR;
4123: END IF;
4124:
4125: --
4126: -- To operation sequence number cannot be NULL or missing.

Line 4130: = FND_API.G_MISS_NUM

4126: -- To operation sequence number cannot be NULL or missing.
4127: --
4128: IF p_op_network_rec.to_op_seq_number IS NULL OR
4129: p_op_network_rec.to_op_seq_number
4130: = FND_API.G_MISS_NUM
4131: THEN
4132: Error_Handler.Add_Error_Token
4133: ( p_Message_Name => 'BOM_OP_NWK_SEQNUM_KEYCOL_NULL'
4134: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 4137: l_Return_Status := FND_API.G_RET_STS_ERROR;

4133: ( p_Message_Name => 'BOM_OP_NWK_SEQNUM_KEYCOL_NULL'
4134: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
4135: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
4136: );
4137: l_Return_Status := FND_API.G_RET_STS_ERROR;
4138: END IF;
4139:
4140: --
4141: -- From start effective date cannot be NULL or missing.

Line 4145: = FND_API.G_MISS_DATE)

4141: -- From start effective date cannot be NULL or missing.
4142: --
4143: IF ( p_op_network_rec.from_start_effective_date IS NULL OR
4144: p_op_network_rec.from_start_effective_date
4145: = FND_API.G_MISS_DATE)
4146: AND ( NVL(p_op_network_rec.operation_type,1) = 1
4147: OR p_op_network_rec.operation_type = FND_API.G_MISS_NUM )
4148: THEN
4149: Error_Handler.Add_Error_Token

Line 4147: OR p_op_network_rec.operation_type = FND_API.G_MISS_NUM )

4143: IF ( p_op_network_rec.from_start_effective_date IS NULL OR
4144: p_op_network_rec.from_start_effective_date
4145: = FND_API.G_MISS_DATE)
4146: AND ( NVL(p_op_network_rec.operation_type,1) = 1
4147: OR p_op_network_rec.operation_type = FND_API.G_MISS_NUM )
4148: THEN
4149: Error_Handler.Add_Error_Token
4150: ( p_Message_Name => 'BOM_OP_NWK_EFFDT_KEYCOL_NULL'
4151: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 4154: l_Return_Status := FND_API.G_RET_STS_ERROR;

4150: ( p_Message_Name => 'BOM_OP_NWK_EFFDT_KEYCOL_NULL'
4151: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
4152: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
4153: );
4154: l_Return_Status := FND_API.G_RET_STS_ERROR;
4155: END IF;
4156:
4157: --
4158: -- To start effective date cannot be NULL or missing.

Line 4162: = FND_API.G_MISS_DATE)

4158: -- To start effective date cannot be NULL or missing.
4159: --
4160: IF ( p_op_network_rec.to_start_effective_date IS NULL OR
4161: p_op_network_rec.to_start_effective_date
4162: = FND_API.G_MISS_DATE)
4163: AND ( NVL(p_op_network_rec.operation_type,1) = 1
4164: OR p_op_network_rec.operation_type = FND_API.G_MISS_NUM )
4165: THEN
4166: Error_Handler.Add_Error_Token

Line 4164: OR p_op_network_rec.operation_type = FND_API.G_MISS_NUM )

4160: IF ( p_op_network_rec.to_start_effective_date IS NULL OR
4161: p_op_network_rec.to_start_effective_date
4162: = FND_API.G_MISS_DATE)
4163: AND ( NVL(p_op_network_rec.operation_type,1) = 1
4164: OR p_op_network_rec.operation_type = FND_API.G_MISS_NUM )
4165: THEN
4166: Error_Handler.Add_Error_Token
4167: ( p_Message_Name => 'BOM_OP_NWK_EFFDT_KEYCOL_NULL'
4168: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 4171: l_Return_Status := FND_API.G_RET_STS_ERROR;

4167: ( p_Message_Name => 'BOM_OP_NWK_EFFDT_KEYCOL_NULL'
4168: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
4169: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
4170: );
4171: l_Return_Status := FND_API.G_RET_STS_ERROR;
4172: END IF;
4173:
4174: --
4175: -- If key columns are NULL, then return.

Line 4178: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

4174: --
4175: -- If key columns are NULL, then return.
4176: --
4177:
4178: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
4179: THEN
4180: x_Return_Status := FND_API.G_RET_STS_ERROR;
4181: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
4182: RETURN;

Line 4180: x_Return_Status := FND_API.G_RET_STS_ERROR;

4176: --
4177:
4178: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
4179: THEN
4180: x_Return_Status := FND_API.G_RET_STS_ERROR;
4181: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
4182: RETURN;
4183: END IF;
4184:

Line 4212: l_Return_Status := FND_API.G_RET_STS_ERROR;

4208: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
4209: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
4210: , p_Token_Tbl => g_Token_Tbl
4211: );
4212: l_Return_Status := FND_API.G_RET_STS_ERROR;
4213: ELSIF l_err_text IS NOT NULL AND
4214: ( l_op_network_unexp_rec.assembly_item_id IS NULL OR
4215: l_op_network_unexp_rec.assembly_item_id = FND_API.G_MISS_NUM
4216: )

Line 4215: l_op_network_unexp_rec.assembly_item_id = FND_API.G_MISS_NUM

4211: );
4212: l_Return_Status := FND_API.G_RET_STS_ERROR;
4213: ELSIF l_err_text IS NOT NULL AND
4214: ( l_op_network_unexp_rec.assembly_item_id IS NULL OR
4215: l_op_network_unexp_rec.assembly_item_id = FND_API.G_MISS_NUM
4216: )
4217: THEN
4218: -- This is an unexpected error.
4219: Error_Handler.Add_Error_Token

Line 4226: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4222: G_PKG_NAME
4223: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
4224: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
4225: );
4226: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4227: END IF;
4228:
4229: IF BOM_Rtg_Globals.Get_Debug = 'Y'
4230: THEN Error_Handler.Write_Debug

Line 4237: p_op_network_rec.alternate_routing_code <> FND_API.G_MISS_CHAR

4233: || ' Status ' || l_return_status);
4234: END IF;
4235:
4236: IF p_op_network_rec.alternate_routing_code IS NOT NULL AND
4237: p_op_network_rec.alternate_routing_code <> FND_API.G_MISS_CHAR
4238: THEN
4239: /*l_err_text_diff*/l_err_text := FND_API.G_RET_STS_ERROR;
4240:
4241: FOR check_alternate IN

Line 4239: /l_err_text_diff/l_err_text := FND_API.G_RET_STS_ERROR;

4235:
4236: IF p_op_network_rec.alternate_routing_code IS NOT NULL AND
4237: p_op_network_rec.alternate_routing_code <> FND_API.G_MISS_CHAR
4238: THEN
4239: /*l_err_text_diff*/l_err_text := FND_API.G_RET_STS_ERROR;
4240:
4241: FOR check_alternate IN
4242: c_Check_Alternate
4243: ( p_alt_designator =>

Line 4248: /l_err_text_diff/l_err_text := FND_API.G_RET_STS_SUCCESS;

4244: p_op_network_rec.alternate_routing_code,
4245: p_organization_id =>
4246: l_op_network_unexp_rec.organization_id )
4247: LOOP
4248: /*l_err_text_diff*/l_err_text := FND_API.G_RET_STS_SUCCESS;
4249: END LOOP;
4250:
4251: IF /*l_err_text_diff*/l_err_text <> FND_API.G_RET_STS_SUCCESS
4252: THEN

Line 4251: IF /l_err_text_diff/l_err_text <> FND_API.G_RET_STS_SUCCESS

4247: LOOP
4248: /*l_err_text_diff*/l_err_text := FND_API.G_RET_STS_SUCCESS;
4249: END LOOP;
4250:
4251: IF /*l_err_text_diff*/l_err_text <> FND_API.G_RET_STS_SUCCESS
4252: THEN
4253: g_token_tbl(1).token_name :='ALTERNATE_ROUTING_CODE';
4254: g_token_tbl(1).token_value :=
4255: p_op_network_rec.alternate_routing_code;

Line 4267: l_return_status := FND_API.G_RET_STS_ERROR;

4263: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
4264: , p_token_tbl => g_token_tbl
4265: );
4266:
4267: l_return_status := FND_API.G_RET_STS_ERROR;
4268: END IF;
4269:
4270: END IF;
4271:

Line 4294: l_Return_Status := FND_API.G_RET_STS_ERROR;

4290: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
4291: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
4292: , p_Token_Tbl => g_Token_Tbl
4293: );
4294: l_Return_Status := FND_API.G_RET_STS_ERROR;
4295: ELSIF l_err_text IS NOT NULL AND
4296: (l_op_network_unexp_rec.routing_sequence_id IS NULL OR
4297: l_op_network_unexp_rec.routing_sequence_id
4298: = FND_API.G_MISS_NUM)

Line 4298: = FND_API.G_MISS_NUM)

4294: l_Return_Status := FND_API.G_RET_STS_ERROR;
4295: ELSIF l_err_text IS NOT NULL AND
4296: (l_op_network_unexp_rec.routing_sequence_id IS NULL OR
4297: l_op_network_unexp_rec.routing_sequence_id
4298: = FND_API.G_MISS_NUM)
4299: THEN
4300: -- This is an unexpected error.
4301: Error_Handler.Add_Error_Token
4302: ( p_Message_Name => NULL

Line 4308: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4304: G_PKG_NAME
4305: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
4306: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
4307: );
4308: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4309: END IF;
4310:
4311: IF BOM_Rtg_Globals.Get_Debug = 'Y'
4312: THEN Error_Handler.Write_Debug

Line 4323: BOM_Rtg_Globals.Get_CFM_Rtg_Flag = FND_API.G_MISS_NUM

4319: -- For operation network, CFM flag should be in (1, 3)
4320: --
4321:
4322: IF BOM_Rtg_Globals.Get_CFM_Rtg_Flag IS NULL OR
4323: BOM_Rtg_Globals.Get_CFM_Rtg_Flag = FND_API.G_MISS_NUM
4324: THEN
4325: l_cfm_flag := Bom_Rtg_Validate.Get_Flow_Routing_Flag(
4326: l_op_network_unexp_rec.routing_sequence_id) ;
4327: BOM_Rtg_Globals.Set_CFM_Rtg_Flag(p_cfm_rtg_type => l_cfm_flag) ;

Line 4347: l_return_status := FND_API.G_RET_STS_ERROR ;

4343: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
4344: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
4345: , p_Token_Tbl => g_Token_Tbl
4346: );
4347: l_return_status := FND_API.G_RET_STS_ERROR ;
4348: END IF ;
4349: */
4350:
4351: --

Line 4358: OR p_op_network_rec.operation_type = FND_API.G_MISS_NUM

4354:
4355: IF l_cfm_flag = BOM_Rtg_Globals.G_FLOW_RTG
4356: THEN
4357: IF p_op_network_rec.operation_type IS NULL
4358: OR p_op_network_rec.operation_type = FND_API.G_MISS_NUM
4359: OR p_op_network_rec.operation_type NOT IN (2, 3)
4360: THEN
4361: IF p_op_network_rec.operation_type <> FND_API.G_MISS_NUM
4362: THEN

Line 4361: IF p_op_network_rec.operation_type <> FND_API.G_MISS_NUM

4357: IF p_op_network_rec.operation_type IS NULL
4358: OR p_op_network_rec.operation_type = FND_API.G_MISS_NUM
4359: OR p_op_network_rec.operation_type NOT IN (2, 3)
4360: THEN
4361: IF p_op_network_rec.operation_type <> FND_API.G_MISS_NUM
4362: THEN
4363: g_token_tbl(1).token_name := 'OPERATION_TYPE';
4364: g_token_tbl(1).token_value :=
4365: p_op_network_rec.operation_type;

Line 4374: l_return_status := FND_API.G_RET_STS_ERROR ;

4370: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
4371: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
4372: , p_Token_Tbl => g_Token_Tbl
4373: );
4374: l_return_status := FND_API.G_RET_STS_ERROR ;
4375:
4376: END IF ;
4377:
4378: ELSIF l_cfm_flag = BOM_Rtg_Globals.G_LOT_RTG

Line 4382: AND p_op_network_rec.operation_type <> FND_API.G_MISS_NUM

4378: ELSIF l_cfm_flag = BOM_Rtg_Globals.G_LOT_RTG
4379: OR l_cfm_flag = BOM_Rtg_Globals.G_STD_RTG
4380: THEN
4381: IF p_op_network_rec.operation_type IS NOT NULL
4382: AND p_op_network_rec.operation_type <> FND_API.G_MISS_NUM
4383: AND p_op_network_rec.operation_type <> 1
4384: THEN
4385: g_token_tbl(1).token_name := 'OPERATION_TYPE';
4386: g_token_tbl(1).token_value :=

Line 4394: l_return_status := FND_API.G_RET_STS_ERROR ;

4390: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
4391: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
4392: , p_Token_Tbl => g_Token_Tbl
4393: );
4394: l_return_status := FND_API.G_RET_STS_ERROR ;
4395: END IF ;
4396:
4397: END IF;
4398:

Line 4403: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

4399: --
4400: -- If error in CFM routing check, then return.
4401: --
4402:
4403: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
4404: THEN
4405: x_Return_Status := FND_API.G_RET_STS_ERROR;
4406: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
4407: RETURN;

Line 4405: x_Return_Status := FND_API.G_RET_STS_ERROR;

4401: --
4402:
4403: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
4404: THEN
4405: x_Return_Status := FND_API.G_RET_STS_ERROR;
4406: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
4407: RETURN;
4408: END IF;
4409:

Line 4479: l_Return_Status := FND_API.G_RET_STS_ERROR;

4475: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
4476: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
4477: , p_Token_Tbl => g_Token_Tbl
4478: );
4479: l_Return_Status := FND_API.G_RET_STS_ERROR;
4480: ELSIF l_err_text IS NOT NULL AND
4481: (l_op_network_unexp_rec.from_op_seq_id IS NULL OR
4482: l_op_network_unexp_rec.from_op_seq_id
4483: = FND_API.G_MISS_NUM )

Line 4483: = FND_API.G_MISS_NUM )

4479: l_Return_Status := FND_API.G_RET_STS_ERROR;
4480: ELSIF l_err_text IS NOT NULL AND
4481: (l_op_network_unexp_rec.from_op_seq_id IS NULL OR
4482: l_op_network_unexp_rec.from_op_seq_id
4483: = FND_API.G_MISS_NUM )
4484: THEN
4485: -- This is an unexpected error.
4486: Error_Handler.Add_Error_Token
4487: ( p_Message_Name => NULL

Line 4493: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4489: G_PKG_NAME
4490: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
4491: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
4492: );
4493: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4494: END IF;
4495:
4496: IF BOM_Rtg_Globals.Get_Debug = 'Y'
4497: THEN Error_Handler.Write_Debug

Line 4567: l_Return_Status := FND_API.G_RET_STS_ERROR;

4563: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
4564: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
4565: , p_Token_Tbl => g_Token_Tbl
4566: );
4567: l_Return_Status := FND_API.G_RET_STS_ERROR;
4568:
4569: ELSIF l_err_text IS NOT NULL AND
4570: (l_op_network_unexp_rec.to_op_seq_id IS NULL OR
4571: l_op_network_unexp_rec.to_op_seq_id

Line 4572: = FND_API.G_MISS_NUM )

4568:
4569: ELSIF l_err_text IS NOT NULL AND
4570: (l_op_network_unexp_rec.to_op_seq_id IS NULL OR
4571: l_op_network_unexp_rec.to_op_seq_id
4572: = FND_API.G_MISS_NUM )
4573: THEN
4574: -- This is an unexpected error.
4575: Error_Handler.Add_Error_Token
4576: ( p_Message_Name => NULL

Line 4582: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4578: G_PKG_NAME
4579: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
4580: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
4581: );
4582: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4583: END IF;
4584:
4585: IF BOM_Rtg_Globals.Get_Debug = 'Y'
4586: THEN Error_Handler.Write_Debug

Line 4596: p_op_network_rec.new_from_op_seq_number <> FND_API.G_MISS_NUM )

4592: --
4593: -- Get new_from_operation_sequence_id
4594: --
4595: IF ( p_op_network_rec.new_from_op_seq_number IS NOT NULL AND
4596: p_op_network_rec.new_from_op_seq_number <> FND_API.G_MISS_NUM )
4597: OR ( p_op_network_rec.new_from_start_effective_date IS NOT NULL AND
4598: p_op_network_rec.new_from_start_effective_date <> FND_API.G_MISS_DATE )
4599: THEN
4600:

Line 4598: p_op_network_rec.new_from_start_effective_date <> FND_API.G_MISS_DATE )

4594: --
4595: IF ( p_op_network_rec.new_from_op_seq_number IS NOT NULL AND
4596: p_op_network_rec.new_from_op_seq_number <> FND_API.G_MISS_NUM )
4597: OR ( p_op_network_rec.new_from_start_effective_date IS NOT NULL AND
4598: p_op_network_rec.new_from_start_effective_date <> FND_API.G_MISS_DATE )
4599: THEN
4600:
4601: l_op_network_unexp_rec.new_from_op_seq_id :=
4602: Operation_Sequence_id

Line 4643: l_Return_Status := FND_API.G_RET_STS_ERROR;

4639: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
4640: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
4641: , p_Token_Tbl => g_Token_Tbl
4642: );
4643: l_Return_Status := FND_API.G_RET_STS_ERROR;
4644:
4645: ELSIF l_err_text IS NOT NULL AND
4646: (l_op_network_unexp_rec.new_from_op_seq_id IS NULL OR
4647: l_op_network_unexp_rec.new_from_op_seq_id

Line 4648: = FND_API.G_MISS_NUM )

4644:
4645: ELSIF l_err_text IS NOT NULL AND
4646: (l_op_network_unexp_rec.new_from_op_seq_id IS NULL OR
4647: l_op_network_unexp_rec.new_from_op_seq_id
4648: = FND_API.G_MISS_NUM )
4649: THEN
4650: -- This is an unexpected error.
4651: Error_Handler.Add_Error_Token
4652: ( p_Message_Name => NULL

Line 4658: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4654: G_PKG_NAME
4655: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
4656: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
4657: );
4658: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4659: END IF;
4660:
4661: IF BOM_Rtg_Globals.Get_Debug = 'Y'
4662: THEN Error_Handler.Write_Debug

Line 4674: p_op_network_rec.new_to_op_seq_number <> FND_API.G_MISS_NUM )

4670: --
4671: -- Get new_to_operation_sequence_id
4672: --
4673: IF ( p_op_network_rec.new_to_op_seq_number IS NOT NULL AND
4674: p_op_network_rec.new_to_op_seq_number <> FND_API.G_MISS_NUM )
4675: OR ( p_op_network_rec.new_to_start_effective_date IS NOT NULL AND
4676: p_op_network_rec.new_to_start_effective_date <> FND_API.G_MISS_DATE )
4677: THEN
4678:

Line 4676: p_op_network_rec.new_to_start_effective_date <> FND_API.G_MISS_DATE )

4672: --
4673: IF ( p_op_network_rec.new_to_op_seq_number IS NOT NULL AND
4674: p_op_network_rec.new_to_op_seq_number <> FND_API.G_MISS_NUM )
4675: OR ( p_op_network_rec.new_to_start_effective_date IS NOT NULL AND
4676: p_op_network_rec.new_to_start_effective_date <> FND_API.G_MISS_DATE )
4677: THEN
4678:
4679: l_op_network_unexp_rec.new_to_op_seq_id :=
4680: Operation_Sequence_id

Line 4721: l_Return_Status := FND_API.G_RET_STS_ERROR;

4717: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
4718: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
4719: , p_Token_Tbl => g_Token_Tbl
4720: );
4721: l_Return_Status := FND_API.G_RET_STS_ERROR;
4722:
4723: ELSIF l_err_text IS NOT NULL AND
4724: (l_op_network_unexp_rec.new_to_op_seq_id IS NULL OR
4725: l_op_network_unexp_rec.new_to_op_seq_id

Line 4726: = FND_API.G_MISS_NUM )

4722:
4723: ELSIF l_err_text IS NOT NULL AND
4724: (l_op_network_unexp_rec.new_to_op_seq_id IS NULL OR
4725: l_op_network_unexp_rec.new_to_op_seq_id
4726: = FND_API.G_MISS_NUM )
4727: THEN
4728:
4729: -- This is an unexpected error.
4730: Error_Handler.Add_Error_Token

Line 4737: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4733: G_PKG_NAME
4734: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
4735: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
4736: );
4737: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4738: END IF;
4739:
4740: IF BOM_Rtg_Globals.Get_Debug = 'Y'
4741: THEN Error_Handler.Write_Debug