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 337: x_Return_Status := FND_API.G_RET_STS_ERROR;

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

Line 366: RAISE FND_API.G_EXC_ERROR;

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

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

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

Line 390: p_bom_comp_ops_rec.from_end_item_unit_number = FND_API.G_MISS_CHAR THEN

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

Line 411: RAISE FND_API.G_EXC_ERROR;

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

Line 434: RAISE FND_API.G_EXC_ERROR;

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

Line 439: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

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

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

Line 469: RAISE FND_API.G_EXC_ERROR;

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

Line 488: RAISE FND_API.G_EXC_ERROR;

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

Line 496: WHEN FND_API.G_EXC_ERROR THEN

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

Line 501: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 503: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 511: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 567: x_return_status := FND_API.G_RET_STS_SUCCESS;

563: and nvl(trunc(disable_date), trunc(sysdate)+1) > trunc(sysdate) and nvl(operation_type,1) = 1;
564:
565: BEGIN
566:
567: x_return_status := FND_API.G_RET_STS_SUCCESS;
568:
569: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Attribute Validation Starts . . . '); END IF;
570:
571: 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 612: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 635: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 693: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 704: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 705: ELSIF l_Return_status = FND_API.G_RET_STS_UNEXP_ERROR

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

Line 730: l_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 757: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 782: x_return_status := FND_API.G_RET_STS_ERROR;

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