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

Line 66: p_comp_operation_seq_id = FND_API.G_MISS_NUM

62: ( p_entity = 'COPS'
63: AND
64: (p_comp_operation_seq_id IS NULL
65: OR
66: p_comp_operation_seq_id = FND_API.G_MISS_NUM
67: OR
68: comp_operation_seq_id <> p_comp_operation_seq_id)
69: )
70: OR

Line 75: p_component_sequence_id = FND_API.G_MISS_NUM

71: ( p_entity = 'RC'
72: AND
73: (p_component_sequence_id IS NULL
74: OR
75: p_component_sequence_id = FND_API.G_MISS_NUM
76: OR
77: comp_operation_seq_id <> 0 -- row belongs to comp ops
78: OR
79: component_sequence_id <> p_component_sequence_id)

Line 88: p_Rowid = FND_API.G_MISS_CHAR

84: /* AND
85: (
86: p_RowId IS NULL
87: or
88: p_Rowid = FND_API.G_MISS_CHAR
89: or
90: ( decode(p_entity,'COPS',bco_rowid,
91: 'RC',bic_RowId,' ') <> p_RowID )
92: )

Line 98: p_Rowid = FND_API.G_MISS_CHAR

94: AND
95: (
96: p_RowId IS NULL
97: or
98: p_Rowid = FND_API.G_MISS_CHAR
99: or
100: row_id <> p_Rowid)
101: AND ( p_Disable_Date IS NULL
102: OR ( to_char(p_Disable_Date,'YYYY/MM/DD HH24:MI:SS') > to_char(Effectivity_Date,'YYYY/MM/DD HH24:MI:SS'))) -- 5954279

Line 162: p_comp_operation_seq_id = FND_API.G_MISS_NUM

158: ( p_entity = 'COPS'
159: AND
160: (p_comp_operation_seq_id IS NULL
161: OR
162: p_comp_operation_seq_id = FND_API.G_MISS_NUM
163: OR
164: comp_operation_seq_id <> p_comp_operation_seq_id)
165: )
166: OR

Line 171: p_component_sequence_id = FND_API.G_MISS_NUM

167: ( p_entity = 'RC'
168: AND
169: (p_component_sequence_id IS NULL
170: OR
171: p_component_sequence_id = FND_API.G_MISS_NUM
172: OR
173: comp_operation_seq_id <> 0
174: OR
175: component_sequence_id <> p_component_sequence_id)

Line 184: p_Rowid = FND_API.G_MISS_CHAR

180: AND
181: (
182: p_RowId IS NULL
183: or
184: p_Rowid = FND_API.G_MISS_CHAR
185: or
186: ( decode(p_entity,'COPS',bco_rowid,
187: 'RC',bic_RowId,' ') <> p_RowID )
188: )

Line 194: p_Rowid = FND_API.G_MISS_CHAR

190: AND
191: (
192: p_RowId IS NULL
193: or
194: p_Rowid = FND_API.G_MISS_CHAR
195: or
196: rowid <> p_Rowid)
197: AND (p_To_End_Item_Number IS NULL
198: OR p_To_End_Item_Number >=

Line 223: p_comp_operation_seq_id = FND_API.G_MISS_NUM

219: ( p_entity = 'COPS'
220: AND
221: (p_comp_operation_seq_id IS NULL
222: OR
223: p_comp_operation_seq_id = FND_API.G_MISS_NUM
224: OR
225: comp_operation_seq_id <> p_comp_operation_seq_id)
226: )
227: OR

Line 232: p_component_sequence_id = FND_API.G_MISS_NUM

228: ( p_entity = 'RC'
229: AND
230: (p_component_sequence_id IS NULL
231: OR
232: p_component_sequence_id = FND_API.G_MISS_NUM
233: OR
234: comp_operation_seq_id <> 0
235: OR
236: component_sequence_id <> p_component_sequence_id)

Line 245: p_Rowid = FND_API.G_MISS_CHAR

241: AND
242: (
243: p_RowId IS NULL
244: or
245: p_Rowid = FND_API.G_MISS_CHAR
246: or
247: ( decode(p_entity,'COPS',bco_rowid,
248: 'RC',bic_RowId,' ') <> p_RowID )
249: )

Line 255: p_Rowid = FND_API.G_MISS_CHAR

251: AND
252: (
253: p_RowId IS NULL
254: or
255: p_Rowid = FND_API.G_MISS_CHAR
256: or
257: bco.rowid <> p_Rowid)
258: AND (p_To_End_Item_Number IS NULL
259: OR p_To_End_Item_Number >=

Line 335: x_Return_Status := FND_API.G_RET_STS_ERROR;

331: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
332: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
333: , p_Token_Tbl => l_Token_Tbl
334: );
335: x_Return_Status := FND_API.G_RET_STS_ERROR;
336: END;
337:
338: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Entity Validation for Comp. Operation begins . . .'); END IF;
339:

Line 364: RAISE FND_API.G_EXC_ERROR;

360: , p_message_name => 'BOM_REV_ITEM_BOM_NOT_ENABLED'
361: , p_token_tbl => l_token_tbl
362: );
363: END IF;
364: RAISE FND_API.G_EXC_ERROR;
365: END IF;
366:
367:
368: /* Select the didsable date which is one of the key parameters */

Line 383: and p_bom_comp_ops_rec.new_additional_op_seq_num <> FND_API.G_MISS_NUM) then

379: l_Additional_Op_Seq_Number := p_bom_comp_ops_rec.additional_operation_seq_num;
380:
381: If( p_bom_comp_ops_rec.transaction_type = BOM_globals.G_OPR_UPDATE and
382: p_bom_comp_ops_rec.new_additional_op_seq_num is not null
383: and p_bom_comp_ops_rec.new_additional_op_seq_num <> FND_API.G_MISS_NUM) then
384: l_Additional_Op_Seq_Number := p_bom_comp_ops_rec.new_additional_op_seq_num;
385: End if;
386:
387: IF p_bom_comp_ops_rec.from_end_item_unit_number IS NULL or

Line 388: p_bom_comp_ops_rec.from_end_item_unit_number = FND_API.G_MISS_CHAR THEN

384: l_Additional_Op_Seq_Number := p_bom_comp_ops_rec.new_additional_op_seq_num;
385: End if;
386:
387: IF p_bom_comp_ops_rec.from_end_item_unit_number IS NULL or
388: p_bom_comp_ops_rec.from_end_item_unit_number = FND_API.G_MISS_CHAR THEN
389:
390: IF Check_Overlap_Dates ( p_Effectivity_Date => p_bom_comp_ops_rec.start_effective_date,
391: p_Disable_Date => l_disable_date,
392: p_Component_Item_Id =>p_bom_comp_ops_unexp_rec.component_item_id,

Line 409: RAISE FND_API.G_EXC_ERROR;

405: , p_message_name => 'BOM_COPS_DATES_OVERLAP'
406: , p_token_tbl => l_token_tbl
407: );
408:
409: RAISE FND_API.G_EXC_ERROR;
410: END IF;
411:
412: ELSE
413:

Line 432: RAISE FND_API.G_EXC_ERROR;

428: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
429: , p_message_name => 'BOM_COPS_NUMBERS_OVERLAP'
430: , p_token_tbl => l_token_tbl
431: );
432: RAISE FND_API.G_EXC_ERROR;
433:
434: END IF;
435:
436: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;

Line 437: x_return_status := FND_API.G_RET_STS_SUCCESS;

433:
434: END IF;
435:
436: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
437: x_return_status := FND_API.G_RET_STS_SUCCESS;
438:
439: END IF;
440:
441: /* When the component operation is updated with new Component operation, It should be checked that

Line 445: and p_bom_comp_ops_rec.new_additional_op_seq_num <> FND_API.G_MISS_NUM

441: /* When the component operation is updated with new Component operation, It should be checked that
442: the New Component operation does not exists already */
443:
444: IF ( p_bom_comp_ops_rec.new_additional_op_seq_num is not null
445: and p_bom_comp_ops_rec.new_additional_op_seq_num <> FND_API.G_MISS_NUM
446: and p_bom_comp_ops_rec.transaction_type = Bom_Globals.G_OPR_UPDATE) THEN
447:
448: select count(*) into l_temp_var
449: FROM BOM_COMPONENT_OPERATIONS

Line 467: RAISE FND_API.G_EXC_ERROR;

463: , p_message_name => 'BOM_COMP_OPS_ALREADY_EXISTS'
464: , p_token_tbl => l_token_tbl
465: );
466:
467: RAISE FND_API.G_EXC_ERROR;
468: END IF;
469: END IF;
470:
471: IF BOm_GlobalS.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Verified New addtional Component operation ... '); END IF;

Line 486: RAISE FND_API.G_EXC_ERROR;

482: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
483: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
484: , p_Token_Tbl => l_Token_Tbl
485: );
486: RAISE FND_API.G_EXC_ERROR;
487: END IF;
488:
489:
490:

Line 494: WHEN FND_API.G_EXC_ERROR THEN

490:
491:
492: EXCEPTION
493:
494: WHEN FND_API.G_EXC_ERROR THEN
495:
496: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Expected Error in Comp Operations. Entity Validation '); END IF;
497:
498: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;

Line 499: x_return_status := FND_API.G_RET_STS_ERROR;

495:
496: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Expected Error in Comp Operations. Entity Validation '); END IF;
497:
498: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
499: x_return_status := FND_API.G_RET_STS_ERROR;
500:
501: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
502:
503: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('UNExpected Error in Comp. Operations Entity Validation '); END IF;

Line 501: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

497:
498: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
499: x_return_status := FND_API.G_RET_STS_ERROR;
500:
501: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
502:
503: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('UNExpected Error in Comp. Operations Entity Validation '); END IF;
504: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

501: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
502:
503: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('UNExpected Error in Comp. Operations Entity Validation '); END IF;
504: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
506:
507: WHEN OTHERS THEN
508: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
506:
507: WHEN OTHERS THEN
508: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
510:
511: END Check_Entity;
512:
513: /********************************************************************

Line 565: x_return_status := FND_API.G_RET_STS_SUCCESS;

561: and nvl(trunc(disable_date), trunc(sysdate)+1) > trunc(sysdate) and nvl(operation_type,1) = 1;
562:
563: BEGIN
564:
565: x_return_status := FND_API.G_RET_STS_SUCCESS;
566:
567: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Attribute Validation Starts . . . '); END IF;
568:
569: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Additional Operation Sequence Number is '||to_char(p_bom_comp_ops_rec.additional_operation_seq_num)); END IF;

Line 610: x_return_status := FND_API.G_RET_STS_ERROR;

606: , p_message_name => 'BOM_COPS_OPSEQ_INVALID'
607: , p_token_tbl => l_token_tbl
608: );
609: END IF;
610: x_return_status := FND_API.G_RET_STS_ERROR;
611: END IF;
612:
613: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
614:

Line 633: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

629: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
630: );
631: END IF;
632: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
633: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
634:
635: END Check_Attributes;
636:
637: /*****************************************************************************

Line 691: l_return_status := FND_API.G_RET_STS_ERROR;

687: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
688: , p_message_name => 'BOM_COMP_OPS_ALREADY_EXISTS'
689: , p_token_tbl => l_token_tbl
690: );
691: l_return_status := FND_API.G_RET_STS_ERROR;
692: ELSIF l_return_status = Bom_Globals.G_RECORD_NOT_FOUND AND
693: p_bom_comp_ops_rec.transaction_type IN
694: (Bom_Globals.G_OPR_UPDATE, Bom_Globals.G_OPR_DELETE)
695: THEN

Line 702: l_return_status := FND_API.G_RET_STS_ERROR;

698: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
699: , p_message_name => 'BOM_COMP_OPS_DOESNOT_EXIST'
700: , p_token_tbl => l_token_tbl
701: );
702: l_return_status := FND_API.G_RET_STS_ERROR;
703: ELSIF l_Return_status = FND_API.G_RET_STS_UNEXP_ERROR
704: THEN
705: Error_Handler.Add_Error_Token
706: ( x_Mesg_token_tbl => l_Mesg_Token_Tbl

Line 703: ELSIF l_Return_status = FND_API.G_RET_STS_UNEXP_ERROR

699: , p_message_name => 'BOM_COMP_OPS_DOESNOT_EXIST'
700: , p_token_tbl => l_token_tbl
701: );
702: l_return_status := FND_API.G_RET_STS_ERROR;
703: ELSIF l_Return_status = FND_API.G_RET_STS_UNEXP_ERROR
704: THEN
705: Error_Handler.Add_Error_Token
706: ( x_Mesg_token_tbl => l_Mesg_Token_Tbl
707: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 728: l_return_status := FND_API.G_RET_STS_SUCCESS;

724: x_old_bom_comp_ops_rec.transaction_type :=
725: Bom_Globals.G_OPR_CREATE;
726: END IF;
727: END IF;
728: l_return_status := FND_API.G_RET_STS_SUCCESS;
729:
730: END IF;
731:
732: x_return_status := l_return_status;

Line 755: x_return_status := FND_API.G_RET_STS_SUCCESS;

751: AND operation_seq_num=p_bom_comp_ops_rec.operation_sequence_number
752: AND effectivity_date = p_bom_comp_ops_rec.start_effective_date
753: AND bill_sequence_id = p_bom_comp_ops_unexp_rec.bill_sequence_id;
754: BEGIN
755: x_return_status := FND_API.G_RET_STS_SUCCESS;
756:
757: FOR Component IN c_GetComponent LOOP
758: IF Component.component_sequence_id <>
759: p_bom_comp_ops_unexp_rec.component_sequence_id

Line 780: x_return_status := FND_API.G_RET_STS_ERROR;

776: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
777: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
778: , p_Token_Tbl => l_Token_Tbl
779: );
780: x_return_status := FND_API.G_RET_STS_ERROR;
781: END IF;
782: END LOOP;
783:
784: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;