APPS.OZF_SPECIAL_PRICING_PVT dependencies on OZF_RESALE_LOGS_ALL

Line 820: INSERT INTO ozf_resale_logs_all(

816: x_return_status := FND_API.G_RET_STS_SUCCESS;
817:
818: -- agreement_type should be 'SPO'
819: BEGIN
820: INSERT INTO ozf_resale_logs_all(
821: RESALE_LOG_ID,
822: RESALE_ID,
823: RESALE_ID_TYPE,
824: ERROR_CODE,

Line 830: ozf_resale_logs_all_s.nextval,

826: COLUMN_NAME,
827: COLUMN_VALUE,
828: ORG_ID
829: ) SELECT
830: ozf_resale_logs_all_s.nextval,
831: resale_line_int_id,
832: 'IFACE',
833: 'OZF_RESALE_AGRM_TYPE_WNG',
834: FND_MESSAGE.get_string('OZF','OZF_RESALE_AGR_TYPE_WNG'),

Line 844: FROM ozf_resale_logs_all a

840: AND b.tracing_flag = 'F'
841: AND b.agreement_type <>'SPO'
842: AND b.resale_batch_id = p_resale_batch_id
843: AND NOT EXISTS(SELECT 1
844: FROM ozf_resale_logs_all a
845: WHERE a.resale_id = b.resale_line_int_id
846: AND a.RESALE_ID_TYPE = 'IFACE'
847: AND a.error_code ='OZF_RESALE_AGRM_TYPE_WNG'
848: );

Line 880: INSERT INTO ozf_resale_logs_all(

876: END;
877:
878: -- purchase price not be NULL
879: BEGIN
880: INSERT INTO ozf_resale_logs_all(
881: RESALE_LOG_ID,
882: RESALE_ID,
883: RESALE_ID_TYPE,
884: ERROR_CODE,

Line 890: ozf_resale_logs_all_s.nextval,

886: COLUMN_NAME,
887: COLUMN_VALUE,
888: ORG_ID
889: ) SELECT
890: ozf_resale_logs_all_s.nextval,
891: resale_line_int_id,
892: OZF_RESALE_COMMON_PVT.G_ID_TYPE_IFACE,
893: 'OZF_RESALE_PUR_PRICE_MISSING',
894: fnd_message.get_string('OZF','OZF_RESALE_PUR_PRICE_MISSING'),

Line 904: FROM ozf_resale_logs_all a

900: AND b.tracing_flag = 'F'
901: AND b.purchase_price IS NULL
902: AND b.resale_batch_id = p_resale_batch_id
903: AND NOT EXISTS(SELECT 1
904: FROM ozf_resale_logs_all a
905: WHERE a.resale_id = b.resale_line_int_id
906: AND a.RESALE_ID_TYPE = 'IFACE'
907: AND a.error_code ='OZF_RESALE_PUR_PRICE_MISSING'
908: );