DBA Data[Home] [Help]

APPS.QP_VALIDATE_MODIFIER_LIST dependencies on OE_DEBUG_PUB

Line 24: oe_debug_pub.add('BEGIN entity in QPXLMLHB');

20: l_security_profile VARCHAR2(1);
21: BEGIN
22:
23:
24: oe_debug_pub.add('BEGIN entity in QPXLMLHB');
25:
26: -- Check whether Source System Code matches
27: -- mkarya for bug 1728764, Prevent update of Trade Management Data in QP
28: QP_UTIL.Check_Source_System_Code

Line 39: oe_debug_pub.add('list header id is mandatory');

35:
36: IF p_MODIFIER_LIST_rec.list_header_id IS NULL
37: THEN
38:
39: oe_debug_pub.add('list header id is mandatory');
40: l_return_status := FND_API.G_RET_STS_ERROR;
41:
42: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
43: THEN

Line 184: oe_debug_pub.add('list type code is mandatory');

180: IF p_MODIFIER_LIST_rec.list_type_code IS NULL
181: THEN
182: l_return_status := FND_API.G_RET_STS_ERROR;
183:
184: oe_debug_pub.add('list type code is mandatory');
185: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
186: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('LIST_TYPE_CODE')); -- Fix For Bug-1974413
187: OE_MSG_PUB.Add;
188:

Line 200: oe_debug_pub.add('invalid list type code ');

196: p_MODIFIER_LIST_rec.list_type_code <> 'CHARGES' AND
197: p_MODIFIER_LIST_rec.list_type_code <> 'SLT' )
198: THEN
199:
200: oe_debug_pub.add('invalid list type code ');
201: l_return_status := FND_API.G_RET_STS_ERROR;
202: FND_MESSAGE.SET_NAME('QP','QP_INVALID_LIST_TYPE');
203: OE_MSG_PUB.Add;
204:

Line 215: oe_debug_pub.add('invalid list type code ');

211: p_MODIFIER_LIST_rec.list_type_code <> 'CHARGES' AND
212: p_MODIFIER_LIST_rec.list_type_code <> 'SLT' )
213: THEN
214:
215: oe_debug_pub.add('invalid list type code ');
216: l_return_status := FND_API.G_RET_STS_ERROR;
217: FND_MESSAGE.SET_NAME('QP','QP_INVALID_LIST_TYPE');
218: OE_MSG_PUB.Add;
219:

Line 270: oe_debug_pub.add('currency code is null ');

266: If QP_Code_Control.Get_Code_Release_Level > '110509'
267: Then
268: l_currency_code := NULL;
269: Else
270: oe_debug_pub.add('currency code is null ');
271: l_return_status := FND_API.G_RET_STS_ERROR;
272: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
273: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('CURRENCY_CODE')); -- Fix For Bug-1974413
274: OE_MSG_PUB.Add;

Line 307: oe_debug_pub.add('start date after end date');

303: IF nvl( p_MODIFIER_LIST_rec.start_date_active,to_date('01/01/1951','mm/dd/yyyy')) >
304: nvl( p_MODIFIER_LIST_rec.end_date_active,to_date('12/31/9999','mm/dd/yyyy'))
305: THEN
306:
307: oe_debug_pub.add('start date after end date');
308: l_return_status := FND_API.G_RET_STS_ERROR;
309:
310: FND_MESSAGE.SET_NAME('QP','QP_STRT_DATE_BFR_END_DATE');
311: OE_MSG_PUB.Add;

Line 319: oe_debug_pub.add('start date after end date');

315: IF nvl( p_MODIFIER_LIST_rec.start_date_active_first,to_date('01/01/1951','mm/dd/yyyy')) >
316: nvl( p_MODIFIER_LIST_rec.end_date_active_first,to_date('12/31/9999','mm/dd/yyyy'))
317: THEN
318:
319: oe_debug_pub.add('start date after end date');
320: l_return_status := FND_API.G_RET_STS_ERROR;
321:
322: FND_MESSAGE.SET_NAME('QP','QP_STRT_DATE_BFR_END_DATE');
323: OE_MSG_PUB.Add;

Line 331: oe_debug_pub.add('start date after end date');

327: IF nvl( p_MODIFIER_LIST_rec.start_date_active_second,to_date('01/01/1951','mm/dd/yyyy')) >
328: nvl( p_MODIFIER_LIST_rec.end_date_active_second,to_date('12/31/9999','mm/dd/yyyy'))
329: THEN
330:
331: oe_debug_pub.add('start date after end date');
332: l_return_status := FND_API.G_RET_STS_ERROR;
333:
334: FND_MESSAGE.SET_NAME('QP','QP_STRT_DATE_BFR_END_DATE');
335: OE_MSG_PUB.Add;

Line 339: oe_debug_pub.add('list type code = '||p_MODIFIER_LIST_rec.list_type_code);

335: OE_MSG_PUB.Add;
336:
337: END IF;
338:
339: oe_debug_pub.add('list type code = '||p_MODIFIER_LIST_rec.list_type_code);
340: oe_debug_pub.add('parent list header id = '||
341: to_char(p_MODIFIER_LIST_rec.parent_list_header_id));
342:
343: IF p_MODIFIER_LIST_rec.list_type_code = 'DEL'

Line 340: oe_debug_pub.add('parent list header id = '||

336:
337: END IF;
338:
339: oe_debug_pub.add('list type code = '||p_MODIFIER_LIST_rec.list_type_code);
340: oe_debug_pub.add('parent list header id = '||
341: to_char(p_MODIFIER_LIST_rec.parent_list_header_id));
342:
343: IF p_MODIFIER_LIST_rec.list_type_code = 'DEL'
344: AND p_MODIFIER_LIST_rec.parent_list_header_id IS NULL

Line 347: oe_debug_pub.add('id deal, list header id is null');

343: IF p_MODIFIER_LIST_rec.list_type_code = 'DEL'
344: AND p_MODIFIER_LIST_rec.parent_list_header_id IS NULL
345: THEN
346:
347: oe_debug_pub.add('id deal, list header id is null');
348: l_return_status := FND_API.G_RET_STS_ERROR;
349:
350: FND_MESSAGE.SET_NAME('QP','QP_PARENT_REQUIRED');
351: OE_MSG_PUB.Add;

Line 361: oe_debug_pub.add('name is null');

357: THEN
358: IF p_MODIFIER_LIST_rec.description IS NULL
359: THEN
360:
361: oe_debug_pub.add('name is null');
362: l_return_status := FND_API.G_RET_STS_ERROR;
363:
364: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
365: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('NAME')); -- Fix For Bug-1974413

Line 378: oe_debug_pub.add('name is null');

374: IF p_MODIFIER_LIST_rec.active_date_first_type =
375: p_MODIFIER_LIST_rec.active_date_second_type
376: THEN
377:
378: oe_debug_pub.add('name is null');
379: l_return_status := FND_API.G_RET_STS_ERROR;
380:
381: FND_MESSAGE.SET_NAME('QP','QP_DATE_TYPES_MUST_DIFFER');
382: OE_MSG_PUB.Add;

Line 493: oe_debug_pub.add('END entity in QPXLMLHB');

489: -- Done validating entity
490:
491: x_return_status := l_return_status;
492:
493: oe_debug_pub.add('END entity in QPXLMLHB');
494:
495: EXCEPTION
496:
497: WHEN FND_API.G_EXC_ERROR THEN

Line 499: oe_debug_pub.add('here in G_EXC');

495: EXCEPTION
496:
497: WHEN FND_API.G_EXC_ERROR THEN
498:
499: oe_debug_pub.add('here in G_EXC');
500: x_return_status := FND_API.G_RET_STS_ERROR;
501:
502: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
503:

Line 508: oe_debug_pub.add('others EXP');

504: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
505:
506: WHEN OTHERS THEN
507:
508: oe_debug_pub.add('others EXP');
509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
510:
511: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
512: THEN

Line 532: oe_debug_pub.add('BEGIN attributes in QPXLMLHB');

528: )
529: IS
530: BEGIN
531:
532: oe_debug_pub.add('BEGIN attributes in QPXLMLHB');
533:
534: x_return_status := FND_API.G_RET_STS_SUCCESS;
535:
536: -- Validate MODIFIER_LIST attributes

Line 548: oe_debug_pub.add('here1');

544: x_return_status := FND_API.G_RET_STS_ERROR;
545: END IF;
546: END IF;
547:
548: oe_debug_pub.add('here1');
549: IF p_MODIFIER_LIST_rec.comments IS NOT NULL AND
550: ( p_MODIFIER_LIST_rec.comments <>
551: p_old_MODIFIER_LIST_rec.comments OR
552: p_old_MODIFIER_LIST_rec.comments IS NULL )

Line 599: oe_debug_pub.add('here6');

595: x_return_status := FND_API.G_RET_STS_ERROR;
596: END IF;
597: END IF;
598:
599: oe_debug_pub.add('here6');
600: IF p_MODIFIER_LIST_rec.end_date_active IS NOT NULL AND
601: ( p_MODIFIER_LIST_rec.end_date_active <>
602: p_old_MODIFIER_LIST_rec.end_date_active OR
603: p_old_MODIFIER_LIST_rec.end_date_active IS NULL )

Line 610: oe_debug_pub.add('here7');

606: x_return_status := FND_API.G_RET_STS_ERROR;
607: END IF;
608: END IF;
609:
610: oe_debug_pub.add('here7');
611: IF p_MODIFIER_LIST_rec.freight_terms_code IS NOT NULL AND
612: ( p_MODIFIER_LIST_rec.freight_terms_code <>
613: p_old_MODIFIER_LIST_rec.freight_terms_code OR
614: p_old_MODIFIER_LIST_rec.freight_terms_code IS NULL )

Line 621: oe_debug_pub.add('here8');

617: x_return_status := FND_API.G_RET_STS_ERROR;
618: END IF;
619: END IF;
620:
621: oe_debug_pub.add('here8');
622: IF p_MODIFIER_LIST_rec.gsa_indicator IS NOT NULL AND
623: ( p_MODIFIER_LIST_rec.gsa_indicator <>
624: p_old_MODIFIER_LIST_rec.gsa_indicator OR
625: p_old_MODIFIER_LIST_rec.gsa_indicator IS NULL )

Line 632: oe_debug_pub.add('here9');

628: x_return_status := FND_API.G_RET_STS_ERROR;
629: END IF;
630: END IF;
631:
632: oe_debug_pub.add('here9');
633: IF p_MODIFIER_LIST_rec.last_updated_by IS NOT NULL AND
634: ( p_MODIFIER_LIST_rec.last_updated_by <>
635: p_old_MODIFIER_LIST_rec.last_updated_by OR
636: p_old_MODIFIER_LIST_rec.last_updated_by IS NULL )

Line 643: oe_debug_pub.add('here10');

639: x_return_status := FND_API.G_RET_STS_ERROR;
640: END IF;
641: END IF;
642:
643: oe_debug_pub.add('here10');
644: IF p_MODIFIER_LIST_rec.last_update_date IS NOT NULL AND
645: ( p_MODIFIER_LIST_rec.last_update_date <>
646: p_old_MODIFIER_LIST_rec.last_update_date OR
647: p_old_MODIFIER_LIST_rec.last_update_date IS NULL )

Line 654: oe_debug_pub.add('here11');

650: x_return_status := FND_API.G_RET_STS_ERROR;
651: END IF;
652: END IF;
653:
654: oe_debug_pub.add('here11');
655: IF p_MODIFIER_LIST_rec.last_update_login IS NOT NULL AND
656: ( p_MODIFIER_LIST_rec.last_update_login <>
657: p_old_MODIFIER_LIST_rec.last_update_login OR
658: p_old_MODIFIER_LIST_rec.last_update_login IS NULL )

Line 665: oe_debug_pub.add('here12');

661: x_return_status := FND_API.G_RET_STS_ERROR;
662: END IF;
663: END IF;
664:
665: oe_debug_pub.add('here12');
666: IF p_MODIFIER_LIST_rec.list_header_id IS NOT NULL AND
667: ( p_MODIFIER_LIST_rec.list_header_id <>
668: p_old_MODIFIER_LIST_rec.list_header_id OR
669: p_old_MODIFIER_LIST_rec.list_header_id IS NULL )

Line 676: oe_debug_pub.add('here13');

672: x_return_status := FND_API.G_RET_STS_ERROR;
673: END IF;
674: END IF;
675:
676: oe_debug_pub.add('here13');
677: IF p_MODIFIER_LIST_rec.list_type_code IS NOT NULL AND
678: ( p_MODIFIER_LIST_rec.list_type_code <>
679: p_old_MODIFIER_LIST_rec.list_type_code OR
680: p_old_MODIFIER_LIST_rec.list_type_code IS NULL )

Line 687: oe_debug_pub.add('here14');

683: x_return_status := FND_API.G_RET_STS_ERROR;
684: END IF;
685: END IF;
686:
687: oe_debug_pub.add('here14');
688: IF p_MODIFIER_LIST_rec.program_application_id IS NOT NULL AND
689: ( p_MODIFIER_LIST_rec.program_application_id <>
690: p_old_MODIFIER_LIST_rec.program_application_id OR
691: p_old_MODIFIER_LIST_rec.program_application_id IS NULL )

Line 698: oe_debug_pub.add('here15');

694: x_return_status := FND_API.G_RET_STS_ERROR;
695: END IF;
696: END IF;
697:
698: oe_debug_pub.add('here15');
699: IF p_MODIFIER_LIST_rec.program_id IS NOT NULL AND
700: ( p_MODIFIER_LIST_rec.program_id <>
701: p_old_MODIFIER_LIST_rec.program_id OR
702: p_old_MODIFIER_LIST_rec.program_id IS NULL )

Line 709: oe_debug_pub.add('here16');

705: x_return_status := FND_API.G_RET_STS_ERROR;
706: END IF;
707: END IF;
708:
709: oe_debug_pub.add('here16');
710: IF p_MODIFIER_LIST_rec.program_update_date IS NOT NULL AND
711: ( p_MODIFIER_LIST_rec.program_update_date <>
712: p_old_MODIFIER_LIST_rec.program_update_date OR
713: p_old_MODIFIER_LIST_rec.program_update_date IS NULL )

Line 720: oe_debug_pub.add('here17');

716: x_return_status := FND_API.G_RET_STS_ERROR;
717: END IF;
718: END IF;
719:
720: oe_debug_pub.add('here17');
721: IF p_MODIFIER_LIST_rec.prorate_flag IS NOT NULL AND
722: ( p_MODIFIER_LIST_rec.prorate_flag <>
723: p_old_MODIFIER_LIST_rec.prorate_flag OR
724: p_old_MODIFIER_LIST_rec.prorate_flag IS NULL )

Line 731: oe_debug_pub.add('here18');

727: x_return_status := FND_API.G_RET_STS_ERROR;
728: END IF;
729: END IF;
730:
731: oe_debug_pub.add('here18');
732: IF p_MODIFIER_LIST_rec.request_id IS NOT NULL AND
733: ( p_MODIFIER_LIST_rec.request_id <>
734: p_old_MODIFIER_LIST_rec.request_id OR
735: p_old_MODIFIER_LIST_rec.request_id IS NULL )

Line 742: oe_debug_pub.add('here19');

738: x_return_status := FND_API.G_RET_STS_ERROR;
739: END IF;
740: END IF;
741:
742: oe_debug_pub.add('here19');
743: IF p_MODIFIER_LIST_rec.rounding_factor IS NOT NULL AND
744: ( p_MODIFIER_LIST_rec.rounding_factor <>
745: p_old_MODIFIER_LIST_rec.rounding_factor OR
746: p_old_MODIFIER_LIST_rec.rounding_factor IS NULL )

Line 753: oe_debug_pub.add('here20');

749: x_return_status := FND_API.G_RET_STS_ERROR;
750: END IF;
751: END IF;
752:
753: oe_debug_pub.add('here20');
754: IF p_MODIFIER_LIST_rec.ship_method_code IS NOT NULL AND
755: ( p_MODIFIER_LIST_rec.ship_method_code <>
756: p_old_MODIFIER_LIST_rec.ship_method_code OR
757: p_old_MODIFIER_LIST_rec.ship_method_code IS NULL )

Line 764: oe_debug_pub.add('here21');

760: x_return_status := FND_API.G_RET_STS_ERROR;
761: END IF;
762: END IF;
763:
764: oe_debug_pub.add('here21');
765: oe_debug_pub.add(to_char(p_MODIFIER_LIST_rec.start_date_active)||'start_date');
766: IF p_MODIFIER_LIST_rec.start_date_active IS NOT NULL AND
767: ( p_MODIFIER_LIST_rec.start_date_active <>
768: p_old_MODIFIER_LIST_rec.start_date_active OR

Line 765: oe_debug_pub.add(to_char(p_MODIFIER_LIST_rec.start_date_active)||'start_date');

761: END IF;
762: END IF;
763:
764: oe_debug_pub.add('here21');
765: oe_debug_pub.add(to_char(p_MODIFIER_LIST_rec.start_date_active)||'start_date');
766: IF p_MODIFIER_LIST_rec.start_date_active IS NOT NULL AND
767: ( p_MODIFIER_LIST_rec.start_date_active <>
768: p_old_MODIFIER_LIST_rec.start_date_active OR
769: p_old_MODIFIER_LIST_rec.start_date_active IS NULL )

Line 771: oe_debug_pub.add('here');

767: ( p_MODIFIER_LIST_rec.start_date_active <>
768: p_old_MODIFIER_LIST_rec.start_date_active OR
769: p_old_MODIFIER_LIST_rec.start_date_active IS NULL )
770: THEN
771: oe_debug_pub.add('here');
772: IF NOT QP_Validate.Start_Date_Active(p_MODIFIER_LIST_rec.start_date_active) THEN
773: oe_debug_pub.add('here');
774: x_return_status := FND_API.G_RET_STS_ERROR;
775: END IF;

Line 773: oe_debug_pub.add('here');

769: p_old_MODIFIER_LIST_rec.start_date_active IS NULL )
770: THEN
771: oe_debug_pub.add('here');
772: IF NOT QP_Validate.Start_Date_Active(p_MODIFIER_LIST_rec.start_date_active) THEN
773: oe_debug_pub.add('here');
774: x_return_status := FND_API.G_RET_STS_ERROR;
775: END IF;
776: END IF;
777:

Line 778: oe_debug_pub.add('here22');

774: x_return_status := FND_API.G_RET_STS_ERROR;
775: END IF;
776: END IF;
777:
778: oe_debug_pub.add('here22');
779: IF p_MODIFIER_LIST_rec.terms_id IS NOT NULL AND
780: ( p_MODIFIER_LIST_rec.terms_id <>
781: p_old_MODIFIER_LIST_rec.terms_id OR
782: p_old_MODIFIER_LIST_rec.terms_id IS NULL )

Line 789: oe_debug_pub.add('here23');

785: x_return_status := FND_API.G_RET_STS_ERROR;
786: END IF;
787: END IF;
788:
789: oe_debug_pub.add('here23');
790: IF p_MODIFIER_LIST_rec.source_system_code IS NOT NULL AND
791: ( p_MODIFIER_LIST_rec.source_system_code <>
792: p_old_MODIFIER_LIST_rec.source_system_code OR
793: p_old_MODIFIER_LIST_rec.source_system_code IS NULL )

Line 810: oe_debug_pub.add('here24');

806: x_return_status := FND_API.G_RET_STS_ERROR;
807: END IF;
808: END IF;
809:
810: oe_debug_pub.add('here24');
811: IF p_MODIFIER_LIST_rec.active_flag IS NOT NULL AND
812: ( p_MODIFIER_LIST_rec.active_flag <>
813: p_old_MODIFIER_LIST_rec.active_flag OR
814: p_old_MODIFIER_LIST_rec.active_flag IS NULL )

Line 821: oe_debug_pub.add('here25');

817: x_return_status := FND_API.G_RET_STS_ERROR;
818: END IF;
819: END IF;
820:
821: oe_debug_pub.add('here25');
822: IF p_MODIFIER_LIST_rec.parent_list_header_id IS NOT NULL AND
823: ( p_MODIFIER_LIST_rec.parent_list_header_id <>
824: p_old_MODIFIER_LIST_rec.parent_list_header_id OR
825: p_old_MODIFIER_LIST_rec.parent_list_header_id IS NULL )

Line 832: oe_debug_pub.add('here26');

828: x_return_status := FND_API.G_RET_STS_ERROR;
829: END IF;
830: END IF;
831:
832: oe_debug_pub.add('here26');
833: IF p_MODIFIER_LIST_rec.start_date_active_first IS NOT NULL AND
834: ( p_MODIFIER_LIST_rec.start_date_active_first <>
835: p_old_MODIFIER_LIST_rec.start_date_active_first OR
836: p_old_MODIFIER_LIST_rec.start_date_active_first IS NULL )

Line 843: oe_debug_pub.add('here27');

839: x_return_status := FND_API.G_RET_STS_ERROR;
840: END IF;
841: END IF;
842:
843: oe_debug_pub.add('here27');
844: IF p_MODIFIER_LIST_rec.end_date_active_first IS NOT NULL AND
845: ( p_MODIFIER_LIST_rec.end_date_active_first <>
846: p_old_MODIFIER_LIST_rec.end_date_active_first OR
847: p_old_MODIFIER_LIST_rec.end_date_active_first IS NULL )

Line 854: oe_debug_pub.add('here28');

850: x_return_status := FND_API.G_RET_STS_ERROR;
851: END IF;
852: END IF;
853:
854: oe_debug_pub.add('here28');
855: IF p_MODIFIER_LIST_rec.active_date_first_type IS NOT NULL AND
856: ( p_MODIFIER_LIST_rec.active_date_first_type <>
857: p_old_MODIFIER_LIST_rec.active_date_first_type OR
858: p_old_MODIFIER_LIST_rec.active_date_first_type IS NULL )

Line 865: oe_debug_pub.add('here29');

861: x_return_status := FND_API.G_RET_STS_ERROR;
862: END IF;
863: END IF;
864:
865: oe_debug_pub.add('here29');
866: IF p_MODIFIER_LIST_rec.start_date_active_second IS NOT NULL AND
867: ( p_MODIFIER_LIST_rec.start_date_active_second <>
868: p_old_MODIFIER_LIST_rec.start_date_active_second OR
869: p_old_MODIFIER_LIST_rec.start_date_active_second IS NULL )

Line 887: oe_debug_pub.add('here30');

883: END IF;
884: END IF;
885:
886:
887: oe_debug_pub.add('here30');
888: IF p_MODIFIER_LIST_rec.end_date_active_second IS NOT NULL AND
889: ( p_MODIFIER_LIST_rec.end_date_active_second <>
890: p_old_MODIFIER_LIST_rec.end_date_active_second OR
891: p_old_MODIFIER_LIST_rec.end_date_active_second IS NULL )

Line 898: oe_debug_pub.add('here31');

894: x_return_status := FND_API.G_RET_STS_ERROR;
895: END IF;
896: END IF;
897:
898: oe_debug_pub.add('here31');
899: IF p_MODIFIER_LIST_rec.active_date_second_type IS NOT NULL AND
900: ( p_MODIFIER_LIST_rec.active_date_second_type <>
901: p_old_MODIFIER_LIST_rec.active_date_second_type OR
902: p_old_MODIFIER_LIST_rec.active_date_second_type IS NULL )

Line 939: oe_debug_pub.add('here31 - blanket pricing');

935: x_return_status := FND_API.G_RET_STS_ERROR;
936: END IF;
937: END IF;
938:
939: oe_debug_pub.add('here31 - blanket pricing');
940: IF p_MODIFIER_LIST_rec.LIST_SOURCE_CODE IS NOT NULL AND
941: ( p_MODIFIER_LIST_rec.LIST_SOURCE_CODE <>
942: p_old_MODIFIER_LIST_rec.LIST_SOURCE_CODE OR
943: p_old_MODIFIER_LIST_rec.LIST_SOURCE_CODE IS NULL)

Line 982: oe_debug_pub.add('here32');

978: x_return_status := FND_API.G_RET_STS_ERROR;
979: END IF;
980: END IF;
981:
982: oe_debug_pub.add('here32');
983: IF (p_MODIFIER_LIST_rec.attribute1 IS NOT NULL AND
984: ( p_MODIFIER_LIST_rec.attribute1 <>
985: p_old_MODIFIER_LIST_rec.attribute1 OR
986: p_old_MODIFIER_LIST_rec.attribute1 IS NULL ))

Line 1128: oe_debug_pub.add('END attributes in QPXLMLHB');

1124: END IF;
1125:
1126: -- Done validating attributes
1127:
1128: oe_debug_pub.add('END attributes in QPXLMLHB');
1129: EXCEPTION
1130:
1131: WHEN FND_API.G_EXC_ERROR THEN
1132:

Line 1164: oe_debug_pub.add('BEGIN entity_delete in QPXLMLHB');

1160: IS
1161: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1162: BEGIN
1163:
1164: oe_debug_pub.add('BEGIN entity_delete in QPXLMLHB');
1165: -- Validate entity delete.
1166:
1167: NULL;
1168:

Line 1195: oe_debug_pub.add('END entity_delete in QPXLMLHB');

1191: , 'Entity_Delete'
1192: );
1193: END IF;
1194:
1195: oe_debug_pub.add('END entity_delete in QPXLMLHB');
1196: END Entity_Delete;
1197:
1198: END QP_Validate_Modifier_List;