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 481: oe_debug_pub.add('END entity in QPXLMLHB');

477: -- Done validating entity
478:
479: x_return_status := l_return_status;
480:
481: oe_debug_pub.add('END entity in QPXLMLHB');
482:
483: EXCEPTION
484:
485: WHEN FND_API.G_EXC_ERROR THEN

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

483: EXCEPTION
484:
485: WHEN FND_API.G_EXC_ERROR THEN
486:
487: oe_debug_pub.add('here in G_EXC');
488: x_return_status := FND_API.G_RET_STS_ERROR;
489:
490: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
491:

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

492: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
493:
494: WHEN OTHERS THEN
495:
496: oe_debug_pub.add('others EXP');
497: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
498:
499: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
500: THEN

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

516: )
517: IS
518: BEGIN
519:
520: oe_debug_pub.add('BEGIN attributes in QPXLMLHB');
521:
522: x_return_status := FND_API.G_RET_STS_SUCCESS;
523:
524: -- Validate MODIFIER_LIST attributes

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

532: x_return_status := FND_API.G_RET_STS_ERROR;
533: END IF;
534: END IF;
535:
536: oe_debug_pub.add('here1');
537: IF p_MODIFIER_LIST_rec.comments IS NOT NULL AND
538: ( p_MODIFIER_LIST_rec.comments <>
539: p_old_MODIFIER_LIST_rec.comments OR
540: p_old_MODIFIER_LIST_rec.comments IS NULL )

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

583: x_return_status := FND_API.G_RET_STS_ERROR;
584: END IF;
585: END IF;
586:
587: oe_debug_pub.add('here6');
588: IF p_MODIFIER_LIST_rec.end_date_active IS NOT NULL AND
589: ( p_MODIFIER_LIST_rec.end_date_active <>
590: p_old_MODIFIER_LIST_rec.end_date_active OR
591: p_old_MODIFIER_LIST_rec.end_date_active IS NULL )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

748: x_return_status := FND_API.G_RET_STS_ERROR;
749: END IF;
750: END IF;
751:
752: oe_debug_pub.add('here21');
753: oe_debug_pub.add(to_char(p_MODIFIER_LIST_rec.start_date_active)||'start_date');
754: IF p_MODIFIER_LIST_rec.start_date_active IS NOT NULL AND
755: ( p_MODIFIER_LIST_rec.start_date_active <>
756: p_old_MODIFIER_LIST_rec.start_date_active OR

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

749: END IF;
750: END IF;
751:
752: oe_debug_pub.add('here21');
753: oe_debug_pub.add(to_char(p_MODIFIER_LIST_rec.start_date_active)||'start_date');
754: IF p_MODIFIER_LIST_rec.start_date_active IS NOT NULL AND
755: ( p_MODIFIER_LIST_rec.start_date_active <>
756: p_old_MODIFIER_LIST_rec.start_date_active OR
757: p_old_MODIFIER_LIST_rec.start_date_active IS NULL )

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

755: ( p_MODIFIER_LIST_rec.start_date_active <>
756: p_old_MODIFIER_LIST_rec.start_date_active OR
757: p_old_MODIFIER_LIST_rec.start_date_active IS NULL )
758: THEN
759: oe_debug_pub.add('here');
760: IF NOT QP_Validate.Start_Date_Active(p_MODIFIER_LIST_rec.start_date_active) THEN
761: oe_debug_pub.add('here');
762: x_return_status := FND_API.G_RET_STS_ERROR;
763: END IF;

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

757: p_old_MODIFIER_LIST_rec.start_date_active IS NULL )
758: THEN
759: oe_debug_pub.add('here');
760: IF NOT QP_Validate.Start_Date_Active(p_MODIFIER_LIST_rec.start_date_active) THEN
761: oe_debug_pub.add('here');
762: x_return_status := FND_API.G_RET_STS_ERROR;
763: END IF;
764: END IF;
765:

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

762: x_return_status := FND_API.G_RET_STS_ERROR;
763: END IF;
764: END IF;
765:
766: oe_debug_pub.add('here22');
767: IF p_MODIFIER_LIST_rec.terms_id IS NOT NULL AND
768: ( p_MODIFIER_LIST_rec.terms_id <>
769: p_old_MODIFIER_LIST_rec.terms_id OR
770: p_old_MODIFIER_LIST_rec.terms_id IS NULL )

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

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

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

794: x_return_status := FND_API.G_RET_STS_ERROR;
795: END IF;
796: END IF;
797:
798: oe_debug_pub.add('here24');
799: IF p_MODIFIER_LIST_rec.active_flag IS NOT NULL AND
800: ( p_MODIFIER_LIST_rec.active_flag <>
801: p_old_MODIFIER_LIST_rec.active_flag OR
802: p_old_MODIFIER_LIST_rec.active_flag IS NULL )

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

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

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

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

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

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

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

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

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

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

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

871: END IF;
872: END IF;
873:
874:
875: oe_debug_pub.add('here30');
876: IF p_MODIFIER_LIST_rec.end_date_active_second IS NOT NULL AND
877: ( p_MODIFIER_LIST_rec.end_date_active_second <>
878: p_old_MODIFIER_LIST_rec.end_date_active_second OR
879: p_old_MODIFIER_LIST_rec.end_date_active_second IS NULL )

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

882: x_return_status := FND_API.G_RET_STS_ERROR;
883: END IF;
884: END IF;
885:
886: oe_debug_pub.add('here31');
887: IF p_MODIFIER_LIST_rec.active_date_second_type IS NOT NULL AND
888: ( p_MODIFIER_LIST_rec.active_date_second_type <>
889: p_old_MODIFIER_LIST_rec.active_date_second_type OR
890: p_old_MODIFIER_LIST_rec.active_date_second_type IS NULL )

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

923: x_return_status := FND_API.G_RET_STS_ERROR;
924: END IF;
925: END IF;
926:
927: oe_debug_pub.add('here31 - blanket pricing');
928: IF p_MODIFIER_LIST_rec.LIST_SOURCE_CODE IS NOT NULL AND
929: ( p_MODIFIER_LIST_rec.LIST_SOURCE_CODE <>
930: p_old_MODIFIER_LIST_rec.LIST_SOURCE_CODE OR
931: p_old_MODIFIER_LIST_rec.LIST_SOURCE_CODE IS NULL)

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

966: x_return_status := FND_API.G_RET_STS_ERROR;
967: END IF;
968: END IF;
969:
970: oe_debug_pub.add('here32');
971: IF (p_MODIFIER_LIST_rec.attribute1 IS NOT NULL AND
972: ( p_MODIFIER_LIST_rec.attribute1 <>
973: p_old_MODIFIER_LIST_rec.attribute1 OR
974: p_old_MODIFIER_LIST_rec.attribute1 IS NULL ))

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

1112: END IF;
1113:
1114: -- Done validating attributes
1115:
1116: oe_debug_pub.add('END attributes in QPXLMLHB');
1117: EXCEPTION
1118:
1119: WHEN FND_API.G_EXC_ERROR THEN
1120:

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

1148: IS
1149: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1150: BEGIN
1151:
1152: oe_debug_pub.add('BEGIN entity_delete in QPXLMLHB');
1153: -- Validate entity delete.
1154:
1155: NULL;
1156:

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

1179: , 'Entity_Delete'
1180: );
1181: END IF;
1182:
1183: oe_debug_pub.add('END entity_delete in QPXLMLHB');
1184: END Entity_Delete;
1185:
1186: END QP_Validate_Modifier_List;