221: RAISE fnd_api.g_exc_unexpected_error;
222: END IF;
223:
224: --Date Validations
225: JTF_RESOURCE_UTL.VALIDATE_INPUT_DATES(
226: p_start_date_active => l_start_date_active,
227: p_end_date_active => l_end_date_active,
228: x_return_status => x_return_status
229: );
348: X_ATTRIBUTE14 => l_attribute14,
349: X_ATTRIBUTE15 => l_attribute15,
350: X_ATTRIBUTE1 => l_attribute1,
351: X_CREATION_DATE => sysdate,
352: X_CREATED_BY => jtf_resource_utl.created_by,
353: X_LAST_UPDATE_DATE => sysdate,
354: X_LAST_UPDATED_BY => jtf_resource_utl.updated_by,
355: X_LAST_UPDATE_LOGIN => jtf_resource_utl.login_id
356: );
350: X_ATTRIBUTE1 => l_attribute1,
351: X_CREATION_DATE => sysdate,
352: X_CREATED_BY => jtf_resource_utl.created_by,
353: X_LAST_UPDATE_DATE => sysdate,
354: X_LAST_UPDATED_BY => jtf_resource_utl.updated_by,
355: X_LAST_UPDATE_LOGIN => jtf_resource_utl.login_id
356: );
357:
358: --dbms_output.put_line('Inserted Row');
351: X_CREATION_DATE => sysdate,
352: X_CREATED_BY => jtf_resource_utl.created_by,
353: X_LAST_UPDATE_DATE => sysdate,
354: X_LAST_UPDATED_BY => jtf_resource_utl.updated_by,
355: X_LAST_UPDATE_LOGIN => jtf_resource_utl.login_id
356: );
357:
358: --dbms_output.put_line('Inserted Row');
359: OPEN c_jtf_rs_srp_territories(l_rowid);
760: END IF;
761:
762: --Date Validations
763: IF (p_start_date_active <>FND_API.G_MISS_DATE OR p_end_date_active <> FND_API.G_MISS_DATE) THEN
764: JTF_RESOURCE_UTL.VALIDATE_INPUT_DATES(
765: p_start_date_active => l_start_date_active,
766: p_end_date_active => l_end_date_active,
767: x_return_status => x_return_status
768: );
902: X_ATTRIBUTE14 => salesrep_territory_rec.l_attribute14,
903: X_ATTRIBUTE15 => salesrep_territory_rec.l_attribute15,
904: X_ATTRIBUTE1 => salesrep_territory_rec.l_attribute1,
905: X_LAST_UPDATE_DATE => sysdate,
906: X_LAST_UPDATED_BY => jtf_resource_utl.updated_by,
907: X_LAST_UPDATE_LOGIN => jtf_resource_utl.login_id
908: );
909:
910: p_object_version_number := l_object_version_number;
903: X_ATTRIBUTE15 => salesrep_territory_rec.l_attribute15,
904: X_ATTRIBUTE1 => salesrep_territory_rec.l_attribute1,
905: X_LAST_UPDATE_DATE => sysdate,
906: X_LAST_UPDATED_BY => jtf_resource_utl.updated_by,
907: X_LAST_UPDATE_LOGIN => jtf_resource_utl.login_id
908: );
909:
910: p_object_version_number := l_object_version_number;
911: