APPS.OZF_SPECIAL_PRICING_PVT dependencies on OZF_RESALE_LOGS_ALL

Line 764: INSERT INTO ozf_resale_logs_all(

760: x_return_status := FND_API.G_RET_STS_SUCCESS;
761:
762: -- agreement_type should be 'SPO'
763: BEGIN
764: INSERT INTO ozf_resale_logs_all(
765: RESALE_LOG_ID,
766: RESALE_ID,
767: RESALE_ID_TYPE,
768: ERROR_CODE,

Line 774: ozf_resale_logs_all_s.nextval,

770: COLUMN_NAME,
771: COLUMN_VALUE,
772: ORG_ID
773: ) SELECT
774: ozf_resale_logs_all_s.nextval,
775: resale_line_int_id,
776: 'IFACE',
777: 'OZF_RESALE_AGRM_TYPE_WNG',
778: FND_MESSAGE.get_string('OZF','OZF_RESALE_AGR_TYPE_WNG'),

Line 788: FROM ozf_resale_logs_all a

784: AND b.tracing_flag = 'F'
785: AND b.agreement_type <>'SPO'
786: AND b.resale_batch_id = p_resale_batch_id
787: AND NOT EXISTS(SELECT 1
788: FROM ozf_resale_logs_all a
789: WHERE a.resale_id = b.resale_line_int_id
790: AND a.RESALE_ID_TYPE = 'IFACE'
791: AND a.error_code ='OZF_RESALE_AGRM_TYPE_WNG'
792: );

Line 824: INSERT INTO ozf_resale_logs_all(

820: END;
821:
822: -- purchase price not be NULL
823: BEGIN
824: INSERT INTO ozf_resale_logs_all(
825: RESALE_LOG_ID,
826: RESALE_ID,
827: RESALE_ID_TYPE,
828: ERROR_CODE,

Line 834: ozf_resale_logs_all_s.nextval,

830: COLUMN_NAME,
831: COLUMN_VALUE,
832: ORG_ID
833: ) SELECT
834: ozf_resale_logs_all_s.nextval,
835: resale_line_int_id,
836: OZF_RESALE_COMMON_PVT.G_ID_TYPE_IFACE,
837: 'OZF_RESALE_PUR_PRICE_MISSING',
838: fnd_message.get_string('OZF','OZF_RESALE_PUR_PRICE_MISSING'),

Line 848: FROM ozf_resale_logs_all a

844: AND b.tracing_flag = 'F'
845: AND b.purchase_price IS NULL
846: AND b.resale_batch_id = p_resale_batch_id
847: AND NOT EXISTS(SELECT 1
848: FROM ozf_resale_logs_all a
849: WHERE a.resale_id = b.resale_line_int_id
850: AND a.RESALE_ID_TYPE = 'IFACE'
851: AND a.error_code ='OZF_RESALE_PUR_PRICE_MISSING'
852: );