DBA Data[Home] [Help]

APPS.MRP_FLOW_SCHEDULE_PUB dependencies on FND_MSG_PUB

Line 157: FND_MSG_PUB.Count_And_Get

153: x_return_status := FND_API.G_RET_STS_ERROR;
154:
155: -- Get message count and data
156:
157: FND_MSG_PUB.Count_And_Get
158: ( p_count => x_msg_count
159: , p_data => x_msg_data
160: );
161:

Line 168: FND_MSG_PUB.Count_And_Get

164: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
165:
166: -- Get message count and data
167:
168: FND_MSG_PUB.Count_And_Get
169: ( p_count => x_msg_count
170: , p_data => x_msg_data
171: );
172:

Line 177: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

173: WHEN OTHERS THEN
174:
175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
176:
177: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
178: THEN
179: FND_MSG_PUB.Add_Exc_Msg
180: ( G_PKG_NAME
181: , 'Process_Flow_Schedule'

Line 179: FND_MSG_PUB.Add_Exc_Msg

175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
176:
177: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
178: THEN
179: FND_MSG_PUB.Add_Exc_Msg
180: ( G_PKG_NAME
181: , 'Process_Flow_Schedule'
182: );
183: END IF;

Line 187: FND_MSG_PUB.Count_And_Get

183: END IF;
184:
185: -- Get message count and data
186:
187: FND_MSG_PUB.Count_And_Get
188: ( p_count => x_msg_count
189: , p_data => x_msg_data
190: );
191:

Line 302: FND_MSG_PUB.Count_And_Get

298: x_return_status := FND_API.G_RET_STS_ERROR;
299:
300: -- Get message count and data
301:
302: FND_MSG_PUB.Count_And_Get
303: ( p_count => x_msg_count
304: , p_data => x_msg_data
305: );
306:

Line 313: FND_MSG_PUB.Count_And_Get

309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
310:
311: -- Get message count and data
312:
313: FND_MSG_PUB.Count_And_Get
314: ( p_count => x_msg_count
315: , p_data => x_msg_data
316: );
317:

Line 322: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

318: WHEN OTHERS THEN
319:
320: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
321:
322: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
323: THEN
324: FND_MSG_PUB.Add_Exc_Msg
325: ( G_PKG_NAME
326: , 'Lock_Flow_Schedule'

Line 324: FND_MSG_PUB.Add_Exc_Msg

320: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
321:
322: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
323: THEN
324: FND_MSG_PUB.Add_Exc_Msg
325: ( G_PKG_NAME
326: , 'Lock_Flow_Schedule'
327: );
328: END IF;

Line 332: FND_MSG_PUB.Count_And_Get

328: END IF;
329:
330: -- Get message count and data
331:
332: FND_MSG_PUB.Count_And_Get
333: ( p_count => x_msg_count
334: , p_data => x_msg_data
335: );
336:

Line 400: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)

396: ELSIF p_wip_entity_id <> FND_API.G_MISS_NUM THEN
397:
398: l_wip_entity_id := p_wip_entity_id;
399:
400: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
401: THEN
402:
403: FND_MESSAGE.SET_NAME('MRP','MRP_BOTH_VAL_AND_ID_EXIST');
404: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','wip_entity');

Line 405: FND_MSG_PUB.Add;

401: THEN
402:
403: FND_MESSAGE.SET_NAME('MRP','MRP_BOTH_VAL_AND_ID_EXIST');
404: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','wip_entity');
405: FND_MSG_PUB.Add;
406:
407: END IF;
408:
409: ELSE

Line 418: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

414: ( p_wip_entity => p_wip_entity
415: );
416:
417: IF l_wip_entity_id = FND_API.G_MISS_NUM THEN
418: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
419: THEN
420:
421: FND_MESSAGE.SET_NAME('MRP','MRP_INVALID_BUSINESS_OBJ_VALUE');
422: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','wip_entity');

Line 423: FND_MSG_PUB.Add;

419: THEN
420:
421: FND_MESSAGE.SET_NAME('MRP','MRP_INVALID_BUSINESS_OBJ_VALUE');
422: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','wip_entity');
423: FND_MSG_PUB.Add;
424:
425: END IF;
426: END IF;
427:

Line 468: FND_MSG_PUB.Count_And_Get

464: x_return_status := FND_API.G_RET_STS_SUCCESS;
465:
466: -- Get message count and data
467:
468: FND_MSG_PUB.Count_And_Get
469: ( p_count => x_msg_count
470: , p_data => x_msg_data
471: );
472:

Line 482: FND_MSG_PUB.Count_And_Get

478: x_return_status := FND_API.G_RET_STS_ERROR;
479:
480: -- Get message count and data
481:
482: FND_MSG_PUB.Count_And_Get
483: ( p_count => x_msg_count
484: , p_data => x_msg_data
485: );
486:

Line 493: FND_MSG_PUB.Count_And_Get

489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
490:
491: -- Get message count and data
492:
493: FND_MSG_PUB.Count_And_Get
494: ( p_count => x_msg_count
495: , p_data => x_msg_data
496: );
497:

Line 502: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

498: WHEN OTHERS THEN
499:
500: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
501:
502: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
503: THEN
504: FND_MSG_PUB.Add_Exc_Msg
505: ( G_PKG_NAME
506: , 'Get_Flow_Schedule'

Line 504: FND_MSG_PUB.Add_Exc_Msg

500: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
501:
502: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
503: THEN
504: FND_MSG_PUB.Add_Exc_Msg
505: ( G_PKG_NAME
506: , 'Get_Flow_Schedule'
507: );
508: END IF;

Line 512: FND_MSG_PUB.Count_And_Get

508: END IF;
509:
510: -- Get message count and data
511:
512: FND_MSG_PUB.Count_And_Get
513: ( p_count => x_msg_count
514: , p_data => x_msg_data
515: );
516:

Line 537: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

533: EXCEPTION
534:
535: WHEN OTHERS THEN
536:
537: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
538: THEN
539: FND_MSG_PUB.Add_Exc_Msg
540: ( G_PKG_NAME
541: , 'Id_To_Value'

Line 539: FND_MSG_PUB.Add_Exc_Msg

535: WHEN OTHERS THEN
536:
537: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
538: THEN
539: FND_MSG_PUB.Add_Exc_Msg
540: ( G_PKG_NAME
541: , 'Id_To_Value'
542: );
543: END IF;

Line 583: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

579: EXCEPTION
580:
581: WHEN OTHERS THEN
582:
583: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
584: THEN
585: FND_MSG_PUB.Add_Exc_Msg
586: ( G_PKG_NAME
587: , 'Value_To_Id'

Line 585: FND_MSG_PUB.Add_Exc_Msg

581: WHEN OTHERS THEN
582:
583: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
584: THEN
585: FND_MSG_PUB.Add_Exc_Msg
586: ( G_PKG_NAME
587: , 'Value_To_Id'
588: );
589: END IF;

Line 661: FND_MSG_PUB.Count_And_Get

657: x_return_status := FND_API.G_RET_STS_ERROR;
658:
659: -- Get message count and data
660:
661: FND_MSG_PUB.Count_And_Get
662: ( p_count => x_msg_count
663: , p_data => x_msg_data
664: );
665:

Line 672: FND_MSG_PUB.Count_And_Get

668: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
669:
670: -- Get message count and data
671:
672: FND_MSG_PUB.Count_And_Get
673: ( p_count => x_msg_count
674: , p_data => x_msg_data
675: );
676:

Line 681: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

677: WHEN OTHERS THEN
678:
679: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
680:
681: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
682: THEN
683: FND_MSG_PUB.Add_Exc_Msg
684: ( G_PKG_NAME
685: , 'Line_Schedule'

Line 683: FND_MSG_PUB.Add_Exc_Msg

679: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
680:
681: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
682: THEN
683: FND_MSG_PUB.Add_Exc_Msg
684: ( G_PKG_NAME
685: , 'Line_Schedule'
686: );
687: END IF;

Line 691: FND_MSG_PUB.Count_And_Get

687: END IF;
688:
689: -- Get message count and data
690:
691: FND_MSG_PUB.Count_And_Get
692: ( p_count => x_msg_count
693: , p_data => x_msg_data
694: );
695:

Line 765: FND_MSG_PUB.Count_And_Get

761: x_return_status := FND_API.G_RET_STS_ERROR;
762:
763: -- Get message count and data
764:
765: FND_MSG_PUB.Count_And_Get
766: ( p_count => x_msg_count
767: , p_data => x_msg_data
768: );
769:

Line 778: FND_MSG_PUB.Count_And_Get

774: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
775:
776: -- Get message count and data
777:
778: FND_MSG_PUB.Count_And_Get
779: ( p_count => x_msg_count
780: , p_data => x_msg_data
781: );
782:

Line 789: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

785: WHEN OTHERS THEN
786:
787: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
788:
789: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
790: THEN
791: FND_MSG_PUB.Add_Exc_Msg
792: ( G_PKG_NAME
793: , 'get_first_unit_completion_date'

Line 791: FND_MSG_PUB.Add_Exc_Msg

787: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
788:
789: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
790: THEN
791: FND_MSG_PUB.Add_Exc_Msg
792: ( G_PKG_NAME
793: , 'get_first_unit_completion_date'
794: );
795: END IF;

Line 799: FND_MSG_PUB.Count_And_Get

795: END IF;
796:
797: -- Get message count and data
798:
799: FND_MSG_PUB.Count_And_Get
800: ( p_count => x_msg_count
801: , p_data => x_msg_data
802: );
803:

Line 871: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

867: AND ASSEMBLY_ITEM_ID = p_assembly_item_id
868: AND ORGANIZATION_ID = p_org_id;
869:
870: IF (p_calculate_option NOT IN (0,1)) THEN
871: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
872: FND_MESSAGE.SET_NAME('MRP','MRP_INVALID_BUSINESS_OBJ_VALUE');
873: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','calculate_option');
874: FND_MSG_PUB.Add;
875: END IF;

Line 874: FND_MSG_PUB.Add;

870: IF (p_calculate_option NOT IN (0,1)) THEN
871: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
872: FND_MESSAGE.SET_NAME('MRP','MRP_INVALID_BUSINESS_OBJ_VALUE');
873: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','calculate_option');
874: FND_MSG_PUB.Add;
875: END IF;
876: RAISE FND_API.G_EXC_ERROR;
877: END IF;
878:

Line 885: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

881: FROM BOM_OPERATION_SEQUENCES
882: WHERE OPERATION_SEQUENCE_ID = p_operation_sequence_id
883: AND ROUTING_SEQUENCE_ID = p_routing_sequence_id;
884: IF (l_cnt = 0) THEN
885: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
886: FND_MESSAGE.SET_NAME('MRP','MRP_INVALID_BUSINESS_OBJ_VALUE');
887: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','operation_sequence_id');
888: FND_MSG_PUB.Add;
889: END IF;

Line 888: FND_MSG_PUB.Add;

884: IF (l_cnt = 0) THEN
885: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
886: FND_MESSAGE.SET_NAME('MRP','MRP_INVALID_BUSINESS_OBJ_VALUE');
887: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','operation_sequence_id');
888: FND_MSG_PUB.Add;
889: END IF;
890: RAISE FND_API.G_EXC_ERROR;
891: END IF;
892:

Line 911: FND_MSG_PUB.Count_And_Get

907: x_return_status := FND_API.G_RET_STS_ERROR;
908:
909: -- Get message count and data
910:
911: FND_MSG_PUB.Count_And_Get
912: ( p_count => x_msg_count
913: , p_data => x_msg_data
914: );
915:

Line 924: FND_MSG_PUB.Count_And_Get

920: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
921:
922: -- Get message count and data
923:
924: FND_MSG_PUB.Count_And_Get
925: ( p_count => x_msg_count
926: , p_data => x_msg_data
927: );
928:

Line 935: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

931: WHEN OTHERS THEN
932:
933: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
934:
935: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
936: THEN
937: FND_MSG_PUB.Add_Exc_Msg
938: ( G_PKG_NAME
939: , 'get_operation_offset_date'

Line 937: FND_MSG_PUB.Add_Exc_Msg

933: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
934:
935: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
936: THEN
937: FND_MSG_PUB.Add_Exc_Msg
938: ( G_PKG_NAME
939: , 'get_operation_offset_date'
940: );
941: END IF;

Line 945: FND_MSG_PUB.Count_And_Get

941: END IF;
942:
943: -- Get message count and data
944:
945: FND_MSG_PUB.Count_And_Get
946: ( p_count => x_msg_count
947: , p_data => x_msg_data
948: );
949:

Line 1011: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1007: into l_item_id
1008: from oe_order_lines_all
1009: where line_id = p_line_id;
1010: EXCEPTION WHEN OTHERS THEN
1011: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1012: FND_MESSAGE.SET_NAME('MRP','MRP_INVALID_OE_LINE_ID');
1013: FND_MSG_PUB.Add;
1014: END IF;
1015: RAISE FND_API.G_EXC_ERROR;

Line 1013: FND_MSG_PUB.Add;

1009: where line_id = p_line_id;
1010: EXCEPTION WHEN OTHERS THEN
1011: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1012: FND_MESSAGE.SET_NAME('MRP','MRP_INVALID_OE_LINE_ID');
1013: FND_MSG_PUB.Add;
1014: END IF;
1015: RAISE FND_API.G_EXC_ERROR;
1016: END;
1017:

Line 1019: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1015: RAISE FND_API.G_EXC_ERROR;
1016: END;
1017:
1018: if( p_assembly_item_id is null or l_item_id <> p_assembly_item_id ) then
1019: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1020: FND_MESSAGE.SET_NAME('MRP','MRP_ITEM_OE_LINE_ID_NOT_MATCH');
1021: FND_MSG_PUB.Add;
1022: END IF;
1023: RAISE FND_API.G_EXC_ERROR;

Line 1021: FND_MSG_PUB.Add;

1017:
1018: if( p_assembly_item_id is null or l_item_id <> p_assembly_item_id ) then
1019: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1020: FND_MESSAGE.SET_NAME('MRP','MRP_ITEM_OE_LINE_ID_NOT_MATCH');
1021: FND_MSG_PUB.Add;
1022: END IF;
1023: RAISE FND_API.G_EXC_ERROR;
1024: end if;
1025:

Line 1040: FND_MSG_PUB.Count_And_Get

1036:
1037: WHEN FND_API.G_EXC_ERROR THEN
1038: x_return_status := FND_API.G_RET_STS_ERROR;
1039: -- Get message count and data
1040: FND_MSG_PUB.Count_And_Get
1041: ( p_count => x_msg_count
1042: , p_data => x_msg_data
1043: );
1044:

Line 1049: FND_MSG_PUB.Count_And_Get

1045: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1046:
1047: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1048: -- Get message count and data
1049: FND_MSG_PUB.Count_And_Get
1050: ( p_count => x_msg_count
1051: , p_data => x_msg_data
1052: );
1053:

Line 1057: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1053:
1054: WHEN OTHERS THEN
1055:
1056: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1057: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1058: THEN
1059: FND_MSG_PUB.Add_Exc_Msg
1060: ( G_PKG_NAME
1061: , 'get_operation_offset_date'

Line 1059: FND_MSG_PUB.Add_Exc_Msg

1055:
1056: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1057: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1058: THEN
1059: FND_MSG_PUB.Add_Exc_Msg
1060: ( G_PKG_NAME
1061: , 'get_operation_offset_date'
1062: );
1063: END IF;

Line 1066: FND_MSG_PUB.Count_And_Get

1062: );
1063: END IF;
1064:
1065: -- Get message count and data
1066: FND_MSG_PUB.Count_And_Get
1067: ( p_count => x_msg_count
1068: , p_data => x_msg_data
1069: );
1070: