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_PVT dependencies on FND_API

Line 167: l_op_resource_rec.return_status = FND_API.G_MISS_CHAR)

163: -- that it is the child of the parent that called this procedure
164: --
165:
166: IF (l_op_resource_rec.return_status IS NULL OR
167: l_op_resource_rec.return_status = FND_API.G_MISS_CHAR)
168: AND
169: (
170: -- Did Op_Seq call this procedure, that is,
171: -- if revised operation(operation sequence) exists, then is this record a child ?

Line 175: NVL(l_op_resource_rec.alternate_routing_code, FND_API.G_MISS_CHAR)

171: -- if revised operation(operation sequence) exists, then is this record a child ?
172: (l_op_parent_exists AND
173: (l_op_resource_rec.assembly_item_name = p_assembly_item_name AND
174: l_op_res_unexp_rec.organization_id = p_organization_id AND
175: NVL(l_op_resource_rec.alternate_routing_code, FND_API.G_MISS_CHAR)
176: = NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR) AND
177: l_op_resource_rec.operation_sequence_number
178: = p_operation_seq_num AND
179: l_op_resource_rec.op_start_effective_date

Line 176: = NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR) AND

172: (l_op_parent_exists AND
173: (l_op_resource_rec.assembly_item_name = p_assembly_item_name AND
174: l_op_res_unexp_rec.organization_id = p_organization_id AND
175: NVL(l_op_resource_rec.alternate_routing_code, FND_API.G_MISS_CHAR)
176: = NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR) AND
177: l_op_resource_rec.operation_sequence_number
178: = p_operation_seq_num AND
179: l_op_resource_rec.op_start_effective_date
180: = p_effectivity_date AND

Line 191: NVL(l_op_resource_rec.alternate_routing_code, FND_API.G_MISS_CHAR)

187: -- if revised item or routing header exists, then is this record a child ?
188: (l_rtg_parent_exists AND
189: (l_op_resource_rec.assembly_item_name = p_assembly_item_name AND
190: l_op_res_unexp_rec.organization_id = p_organization_id AND
191: NVL(l_op_resource_rec.alternate_routing_code, FND_API.G_MISS_CHAR)
192: = NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR)
193: )
194: )
195: OR

Line 192: = NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR)

188: (l_rtg_parent_exists AND
189: (l_op_resource_rec.assembly_item_name = p_assembly_item_name AND
190: l_op_res_unexp_rec.organization_id = p_organization_id AND
191: NVL(l_op_resource_rec.alternate_routing_code, FND_API.G_MISS_CHAR)
192: = NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR)
193: )
194: )
195: OR
196: (NOT l_rtg_parent_exists AND NOT l_op_parent_exists)

Line 199: l_return_status := FND_API.G_RET_STS_SUCCESS;

195: OR
196: (NOT l_rtg_parent_exists AND NOT l_op_parent_exists)
197: )
198: THEN
199: l_return_status := FND_API.G_RET_STS_SUCCESS;
200: l_op_resource_rec.return_status := FND_API.G_RET_STS_SUCCESS;
201:
202: --
203: -- Process Flow step 3 :Check if transaction_type is valid

Line 200: l_op_resource_rec.return_status := FND_API.G_RET_STS_SUCCESS;

196: (NOT l_rtg_parent_exists AND NOT l_op_parent_exists)
197: )
198: THEN
199: l_return_status := FND_API.G_RET_STS_SUCCESS;
200: l_op_resource_rec.return_status := FND_API.G_RET_STS_SUCCESS;
201:
202: --
203: -- Process Flow step 3 :Check if transaction_type is valid
204: -- Transaction_Type must be CRATE, UPDATE, DELETE or CANCEL(in only ECO for Rrg)

Line 1414: l_sub_resource_rec.return_status = FND_API.G_MISS_CHAR)

1410: -- that it is the child of the parent that called this procedure
1411: --
1412:
1413: IF (l_sub_resource_rec.return_status IS NULL OR
1414: l_sub_resource_rec.return_status = FND_API.G_MISS_CHAR)
1415: AND
1416: (
1417: -- Did Op_Seq call this procedure, that is,
1418: -- if revised operation(operation sequence) exists, then is this record a child ?

Line 1422: NVL(l_sub_resource_rec.alternate_routing_code, FND_API.G_MISS_CHAR)

1418: -- if revised operation(operation sequence) exists, then is this record a child ?
1419: (l_op_parent_exists AND
1420: (l_sub_resource_rec.assembly_item_name = p_assembly_item_name AND
1421: l_sub_res_unexp_rec.organization_id = p_organization_id AND
1422: NVL(l_sub_resource_rec.alternate_routing_code, FND_API.G_MISS_CHAR)
1423: = NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR) AND
1424: l_sub_resource_rec.operation_sequence_number
1425: = p_operation_seq_num AND
1426: l_sub_resource_rec.op_start_effective_date

Line 1423: = NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR) AND

1419: (l_op_parent_exists AND
1420: (l_sub_resource_rec.assembly_item_name = p_assembly_item_name AND
1421: l_sub_res_unexp_rec.organization_id = p_organization_id AND
1422: NVL(l_sub_resource_rec.alternate_routing_code, FND_API.G_MISS_CHAR)
1423: = NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR) AND
1424: l_sub_resource_rec.operation_sequence_number
1425: = p_operation_seq_num AND
1426: l_sub_resource_rec.op_start_effective_date
1427: = p_effectivity_date AND

Line 1437: NVL(l_sub_resource_rec.alternate_routing_code, FND_API.G_MISS_CHAR)

1433: -- if revised item or routing header exists, then is this record a child ?
1434: (l_rtg_parent_exists AND
1435: (l_sub_resource_rec.assembly_item_name = p_assembly_item_name AND
1436: l_sub_res_unexp_rec.organization_id = p_organization_id AND
1437: NVL(l_sub_resource_rec.alternate_routing_code, FND_API.G_MISS_CHAR)
1438: = NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR)
1439: )
1440: )
1441: OR

Line 1438: = NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR)

1434: (l_rtg_parent_exists AND
1435: (l_sub_resource_rec.assembly_item_name = p_assembly_item_name AND
1436: l_sub_res_unexp_rec.organization_id = p_organization_id AND
1437: NVL(l_sub_resource_rec.alternate_routing_code, FND_API.G_MISS_CHAR)
1438: = NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR)
1439: )
1440: )
1441: OR
1442: (NOT l_rtg_parent_exists AND NOT l_op_parent_exists)

Line 1445: l_return_status := FND_API.G_RET_STS_SUCCESS;

1441: OR
1442: (NOT l_rtg_parent_exists AND NOT l_op_parent_exists)
1443: )
1444: THEN
1445: l_return_status := FND_API.G_RET_STS_SUCCESS;
1446: l_sub_resource_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1447:
1448: --
1449: -- Process Flow step 3 :Check if transaction_type is valid

Line 1446: l_sub_resource_rec.return_status := FND_API.G_RET_STS_SUCCESS;

1442: (NOT l_rtg_parent_exists AND NOT l_op_parent_exists)
1443: )
1444: THEN
1445: l_return_status := FND_API.G_RET_STS_SUCCESS;
1446: l_sub_resource_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1447:
1448: --
1449: -- Process Flow step 3 :Check if transaction_type is valid
1450: -- Transaction_Type must be CRATE, UPDATE, DELETE or CANCEL(in only ECO for Rrg)

Line 1720: l_return_status := FND_API.G_RET_STS_ERROR ;

1716: -- For eAM enhancement, maintenace routings do not support
1717: -- sub resource currently
1718: ELSIF l_return_status = 'EAM' THEN
1719:
1720: l_return_status := FND_API.G_RET_STS_ERROR ;
1721:
1722: l_token_tbl(1).token_name := 'SUB_RESOURCE_CODE';
1723: l_token_tbl(1).token_value :=
1724: l_sub_resource_rec.sub_resource_code ;

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

2653: l_err_text VARCHAR2(2000);
2654:
2655:
2656: l_valid BOOLEAN := TRUE;
2657: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2658: l_bo_return_status VARCHAR2(1) := 'S';
2659: l_rtg_parent_exists BOOLEAN := FALSE;
2660:
2661: l_rtg_header_rec Bom_Rtg_Pub.rtg_header_Rec_Type;

Line 2734: l_op_network_rec.return_status = FND_API.G_MISS_CHAR)

2730: -- Process Flow Step 2.5: Check if record has not yet been processed and
2731: -- that it is the child of the parent that called this procedure
2732: --
2733: IF (l_op_network_rec.return_status IS NULL OR
2734: l_op_network_rec.return_status = FND_API.G_MISS_CHAR)
2735: AND
2736: (NOT l_rtg_parent_exists
2737: OR
2738: (l_rtg_parent_exists AND

Line 2741: NVL(l_op_network_rec.alternate_routing_code, FND_API.G_MISS_CHAR) =

2737: OR
2738: (l_rtg_parent_exists AND
2739: ( l_op_network_rec.assembly_item_name = p_assembly_item_name AND
2740: l_op_network_unexp_rec.organization_id = p_organization_id AND
2741: NVL(l_op_network_rec.alternate_routing_code, FND_API.G_MISS_CHAR) =
2742: NVL(p_alternate_rtg_code, FND_API.G_MISS_CHAR)
2743: )
2744: )
2745: )

Line 2742: NVL(p_alternate_rtg_code, FND_API.G_MISS_CHAR)

2738: (l_rtg_parent_exists AND
2739: ( l_op_network_rec.assembly_item_name = p_assembly_item_name AND
2740: l_op_network_unexp_rec.organization_id = p_organization_id AND
2741: NVL(l_op_network_rec.alternate_routing_code, FND_API.G_MISS_CHAR) =
2742: NVL(p_alternate_rtg_code, FND_API.G_MISS_CHAR)
2743: )
2744: )
2745: )
2746: THEN

Line 2748: l_return_status := FND_API.G_RET_STS_SUCCESS;

2744: )
2745: )
2746: THEN
2747:
2748: l_return_status := FND_API.G_RET_STS_SUCCESS;
2749: l_op_network_rec.return_status := FND_API.G_RET_STS_SUCCESS;
2750:
2751: --
2752: -- Step 3: Check if transaction_type is valid

Line 2749: l_op_network_rec.return_status := FND_API.G_RET_STS_SUCCESS;

2745: )
2746: THEN
2747:
2748: l_return_status := FND_API.G_RET_STS_SUCCESS;
2749: l_op_network_rec.return_status := FND_API.G_RET_STS_SUCCESS;
2750:
2751: --
2752: -- Step 3: Check if transaction_type is valid
2753: --

Line 3573: x_return_status := FND_API.G_RET_STS_ERROR;

3569: , p_token_tbl => l_token_tbl
3570: , p_mesg_token_tbl => l_mesg_token_tbl
3571: , x_mesg_token_tbl => l_mesg_token_tbl
3572: );
3573: x_return_status := FND_API.G_RET_STS_ERROR;
3574: ELSIF UPPER( RTRIM(l_other_message) ) =
3575: UPPER('A broken link exists in this routing Network.')
3576: THEN
3577:

Line 3585: x_return_status := FND_API.G_RET_STS_ERROR;

3581: , p_mesg_token_tbl => l_mesg_token_tbl
3582: , x_mesg_token_tbl => l_mesg_token_tbl
3583: );
3584:
3585: x_return_status := FND_API.G_RET_STS_ERROR;
3586: ELSE
3587:
3588: Error_Handler.Add_Error_Token
3589: ( p_message_name => 'BOM_OP_NWK_VLDN_ERROR'

Line 3595: x_return_status := FND_API.G_RET_STS_ERROR;

3591: , p_mesg_token_tbl => l_mesg_token_tbl
3592: , x_mesg_token_tbl => l_mesg_token_tbl
3593: );
3594:
3595: x_return_status := FND_API.G_RET_STS_ERROR;
3596: END IF;
3597: --dbms_output.put_line('before raising excptn');
3598: RAISE EXC_SEV_QUIT_OBJECT ;
3599: END IF;

Line 3624: l_return_status := FND_API.G_RET_STS_ERROR;

3620: , p_token_tbl => l_token_tbl
3621: , p_mesg_token_tbl => l_mesg_token_tbl
3622: , x_mesg_token_tbl => l_mesg_token_tbl
3623: );
3624: l_return_status := FND_API.G_RET_STS_ERROR;
3625: RAISE EXC_SEV_QUIT_OBJECT ;
3626: END IF;
3627: END IF;
3628: END IF;

Line 3646: l_return_status := FND_API.G_RET_STS_ERROR;

3642: , p_token_tbl => l_token_tbl
3643: , p_mesg_token_tbl => l_mesg_token_tbl
3644: , x_mesg_token_tbl => l_mesg_token_tbl
3645: );
3646: l_return_status := FND_API.G_RET_STS_ERROR;
3647: RAISE EXC_SEV_QUIT_OBJECT ;
3648: END IF;
3649: END IF;
3650:

Line 3710: IF ( ( l_return_status = FND_API.G_RET_STS_SUCCESS )

3706: /*above change for RBO support for OSFM*/
3707:
3708: -- bug:5235684 SSOS is required for standard/network routing for serial controlled item
3709: -- and it should be present on primary path.
3710: IF ( ( l_return_status = FND_API.G_RET_STS_SUCCESS )
3711: AND ( BOM_RTG_Globals.Get_Routing_Sequence_Id() IS NOT NULL ) )
3712: THEN
3713: Bom_Validate_Rtg_Header.Validate_SSOS
3714: ( p_routing_sequence_id => BOM_RTG_Globals.Get_Routing_Sequence_Id()

Line 3720: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

3716: , p_validate_from_table => TRUE
3717: , x_mesg_token_tbl => l_Mesg_Token_Tbl
3718: , x_return_status => l_return_status );
3719:
3720: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
3721: RAISE EXC_SEV_QUIT_OBJECT;
3722: END IF;
3723: END IF; -- end if ( l_return_status = FND_API.G_RET_STS_SUCCESS )
3724:

Line 3723: END IF; -- end if ( l_return_status = FND_API.G_RET_STS_SUCCESS )

3719:
3720: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
3721: RAISE EXC_SEV_QUIT_OBJECT;
3722: END IF;
3723: END IF; -- end if ( l_return_status = FND_API.G_RET_STS_SUCCESS )
3724:
3725: --bug:5060186 Copy the first or last operation of the network if disabled.
3726: IF ( BOM_RTG_Globals.Get_Routing_Sequence_Id() IS NOT NULL ) THEN
3727: Bom_Op_Network_Util.Copy_First_Last_Dis_Op(

Line 3920: l_operation_rec.return_status = FND_API.G_MISS_CHAR)

3916: -- that it is the child of the parent that called this procedure
3917: --
3918:
3919: IF (l_operation_rec.return_status IS NULL OR
3920: l_operation_rec.return_status = FND_API.G_MISS_CHAR)
3921: AND
3922:
3923: -- Did Rtg Header call this procedure, that is,
3924: -- if revised item or routing header exists,

Line 3931: NVL(l_operation_rec.alternate_routing_code, FND_API.G_MISS_CHAR)

3927: OR
3928: (l_parent_exists AND
3929: (l_operation_rec.assembly_item_name = p_assembly_item_name AND
3930: l_op_unexp_rec.organization_id = p_organization_id AND
3931: NVL(l_operation_rec.alternate_routing_code, FND_API.G_MISS_CHAR)
3932: = NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR)
3933: )
3934: )
3935: )

Line 3932: = NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR)

3928: (l_parent_exists AND
3929: (l_operation_rec.assembly_item_name = p_assembly_item_name AND
3930: l_op_unexp_rec.organization_id = p_organization_id AND
3931: NVL(l_operation_rec.alternate_routing_code, FND_API.G_MISS_CHAR)
3932: = NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR)
3933: )
3934: )
3935: )
3936: THEN

Line 3938: l_return_status := FND_API.G_RET_STS_SUCCESS;

3934: )
3935: )
3936: THEN
3937:
3938: l_return_status := FND_API.G_RET_STS_SUCCESS;
3939: l_operation_rec.return_status := FND_API.G_RET_STS_SUCCESS;
3940:
3941: --
3942: -- Process Flow step 3 :Check if transaction_type is valid

Line 3939: l_operation_rec.return_status := FND_API.G_RET_STS_SUCCESS;

3935: )
3936: THEN
3937:
3938: l_return_status := FND_API.G_RET_STS_SUCCESS;
3939: l_operation_rec.return_status := FND_API.G_RET_STS_SUCCESS;
3940:
3941: --
3942: -- Process Flow step 3 :Check if transaction_type is valid
3943: -- Transaction_Type must be CRATE, UPDATE, DELETE

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

5220: l_other_token_tbl Error_Handler.Token_Tbl_Type;
5221: l_other_message VARCHAR2(50);
5222: l_err_text VARCHAR2(2000);
5223: l_valid BOOLEAN := TRUE;
5224: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
5225: l_bo_return_status VARCHAR2(1) := 'S';
5226: l_bom_parent_exists BOOLEAN := FALSE;
5227: l_rtg_header_rec Bom_Rtg_Pub.rtg_Header_Rec_Type;
5228: l_rtg_header_unexp_rec Bom_Rtg_Pub.rtg_Header_unexposed_Rec_Type;

Line 5278: l_rtg_revision_rec.return_status = FND_API.G_MISS_CHAR)

5274: -- that it is the child of the parent that called this procedure
5275: --
5276:
5277: IF (l_rtg_revision_rec.return_status IS NULL OR
5278: l_rtg_revision_rec.return_status = FND_API.G_MISS_CHAR)
5279: AND
5280: (NOT l_rtg_parent_exists
5281: OR
5282: (l_rtg_parent_exists AND

Line 5285: NVL(l_rtg_revision_rec.alternate_routing_code, FND_API.G_MISS_CHAR) =

5281: OR
5282: (l_rtg_parent_exists AND
5283: ( l_rtg_revision_rec.assembly_item_name = p_assembly_item_name AND
5284: l_rtg_rev_unexp_rec.organization_id = p_organization_id AND
5285: NVL(l_rtg_revision_rec.alternate_routing_code, FND_API.G_MISS_CHAR) =
5286: NVL(p_alternate_rtg_code, FND_API.G_MISS_CHAR)
5287: )
5288: )
5289: )

Line 5286: NVL(p_alternate_rtg_code, FND_API.G_MISS_CHAR)

5282: (l_rtg_parent_exists AND
5283: ( l_rtg_revision_rec.assembly_item_name = p_assembly_item_name AND
5284: l_rtg_rev_unexp_rec.organization_id = p_organization_id AND
5285: NVL(l_rtg_revision_rec.alternate_routing_code, FND_API.G_MISS_CHAR) =
5286: NVL(p_alternate_rtg_code, FND_API.G_MISS_CHAR)
5287: )
5288: )
5289: )
5290: THEN

Line 5292: l_return_status := FND_API.G_RET_STS_SUCCESS;

5288: )
5289: )
5290: THEN
5291:
5292: l_return_status := FND_API.G_RET_STS_SUCCESS;
5293: l_rtg_revision_rec.return_status := FND_API.G_RET_STS_SUCCESS;
5294:
5295: --
5296: -- Check if transaction_type is valid

Line 5293: l_rtg_revision_rec.return_status := FND_API.G_RET_STS_SUCCESS;

5289: )
5290: THEN
5291:
5292: l_return_status := FND_API.G_RET_STS_SUCCESS;
5293: l_rtg_revision_rec.return_status := FND_API.G_RET_STS_SUCCESS;
5294:
5295: --
5296: -- Check if transaction_type is valid
5297: --

Line 5317: l_rtg_revision_rec.revision = FND_API.G_MISS_CHAR

5313: -- Process Flow step 4: Verify that Revision is not NULL or MISSING
5314: --
5315:
5316: IF l_rtg_revision_rec.revision is NULL OR
5317: l_rtg_revision_rec.revision = FND_API.G_MISS_CHAR
5318: THEN
5319: l_other_message := 'BOM_RTG_REV_KEYCOL_NULL';
5320: l_return_status := Error_Handler.G_STATUS_ERROR;
5321: RAISE EXC_UNEXP_SKIP_OBJECT;

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

5791: l_other_token_tbl Error_Handler.Token_Tbl_Type;
5792: l_other_message VARCHAR2(50);
5793: l_err_text VARCHAR2(2000);
5794: l_valid BOOLEAN := TRUE;
5795: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
5796: l_bo_return_status VARCHAR2(1) := 'S';
5797: l_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type;
5798: l_old_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type;
5799: l_old_rtg_header_unexp_rec Bom_Rtg_Pub.rtg_Header_Unexposed_Rec_Type;

Line 5837: l_rtg_header_rec.return_status <> FND_API.G_MISS_CHAR

5833: -- Process Flow Step 2: Check if record has not yet been processed
5834: --
5835:
5836: IF l_rtg_header_rec.return_status IS NOT NULL AND
5837: l_rtg_header_rec.return_status <> FND_API.G_MISS_CHAR
5838: THEN
5839: x_return_status := l_return_status;
5840: x_rtg_header_rec := l_rtg_header_rec;
5841: x_rtg_revision_tbl := l_rtg_revision_tbl;

Line 5849: l_return_status := FND_API.G_RET_STS_SUCCESS;

5845: x_op_network_tbl := l_op_network_tbl;
5846: RETURN;
5847: END IF;
5848:
5849: l_return_status := FND_API.G_RET_STS_SUCCESS;
5850: l_rtg_header_rec.return_status := FND_API.G_RET_STS_SUCCESS;
5851:
5852: --
5853: -- Process Flow Step 3: Check if transaction_type is valid

Line 5850: l_rtg_header_rec.return_status := FND_API.G_RET_STS_SUCCESS;

5846: RETURN;
5847: END IF;
5848:
5849: l_return_status := FND_API.G_RET_STS_SUCCESS;
5850: l_rtg_header_rec.return_status := FND_API.G_RET_STS_SUCCESS;
5851:
5852: --
5853: -- Process Flow Step 3: Check if transaction_type is valid
5854: --

Line 6875: IF ( l_return_status = FND_API.G_RET_STS_SUCCESS )

6871: );
6872:
6873: -- bug:5235684 SSOS is required for standard/network routing for serial controlled item
6874: -- and it should be present on primary path.
6875: IF ( l_return_status = FND_API.G_RET_STS_SUCCESS )
6876: THEN
6877: Bom_Validate_Rtg_Header.Validate_SSOS
6878: ( p_routing_sequence_id => l_rtg_header_unexp_rec.routing_sequence_id
6879: , p_ser_start_op_seq => l_rtg_header_rec.ser_start_op_seq

Line 6884: IF ( ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) AND

6880: , p_validate_from_table => FALSE
6881: , x_mesg_token_tbl => l_Mesg_Token_Tbl
6882: , x_return_status => l_return_status );
6883:
6884: IF ( ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) AND
6885: ( l_Mesg_Token_Tbl.COUNT <> 0 ) )
6886: THEN
6887: Bom_Rtg_Error_Handler.Log_Error
6888: ( p_rtg_header_rec => l_rtg_header_rec

Line 6911: END IF; -- end if ( l_return_status = FND_API.G_RET_STS_SUCCESS )

6907: , x_sub_resource_tbl => l_sub_resource_tbl
6908: , x_op_network_tbl => l_op_network_tbl
6909: );
6910: END IF; -- end if l_return_status <> 'S'
6911: END IF; -- end if ( l_return_status = FND_API.G_RET_STS_SUCCESS )
6912:
6913: IF l_return_status <> 'S'
6914: THEN
6915: l_bo_return_status := l_return_status;

Line 7026: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

7022: END IF;
7023:
7024: */
7025:
7026: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
7027: THEN
7028: RAISE EXC_ERR_PVT_API_MAIN;
7029: END IF;
7030:

Line 7034: IF (l_rtg_header_rec.assembly_item_name <> FND_API.G_MISS_CHAR

7030:
7031: --
7032: -- Start with processing of the routing header.
7033: --
7034: IF (l_rtg_header_rec.assembly_item_name <> FND_API.G_MISS_CHAR
7035: AND l_rtg_header_rec.assembly_item_name IS NOT NULL)
7036: THEN
7037: Rtg_Header
7038: ( p_validation_level => p_validation_level

Line 7292: , p_error_status => FND_API.G_RET_STS_UNEXP_ERROR

7288: , p_operation_tbl => l_operation_tbl
7289: , p_op_resource_tbl => l_op_resource_tbl
7290: , p_sub_resource_tbl => l_sub_resource_tbl
7291: , p_op_network_tbl => l_op_network_tbl
7292: , p_error_status => FND_API.G_RET_STS_UNEXP_ERROR
7293: , p_other_status => Error_Handler.G_STATUS_NOT_PICKED
7294: , p_other_message => l_other_message
7295: , p_other_token_tbl => l_other_token_tbl
7296: , p_error_level => 0