51: x_product_category_id => x_product_category_id,
52: x_product_category_set_id => x_product_category_set_id ) THEN
53: FND_MESSAGE.SET_NAME('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
54: IGS_GE_MSG_STACK.ADD;
55: App_Exception.Raise_Exception;
56: END IF;
57:
58: OPEN cur_sales_lead_id( x_person_id,x_enquiry_appl_number);
59: FETCH cur_sales_lead_id INTO l_sales_lead_id ;
188: x_product_category_id => x_product_category_id,
189: x_product_category_set_id => x_product_category_set_id ) THEN
190: FND_MESSAGE.SET_NAME('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
191: IGS_GE_MSG_STACK.ADD;
192: App_Exception.Raise_Exception;
193: END IF;
194:
195: OPEN cur_sales_lead_id( x_person_id,x_enquiry_appl_number);
196: FETCH cur_sales_lead_id INTO l_sales_lead_id ;