440: into v_organization_id, v_location_id;
441: close c_get_orgn_project;
442: else
443:
444: fnd_file.put_line(FND_FILE.LOG,
445: 'organization id is ' || v_organization_id);
446: fnd_file.put_line(FND_FILE.LOG, 'location id is ' || v_location_id);
447:
448: if v_location_id is null then
442: else
443:
444: fnd_file.put_line(FND_FILE.LOG,
445: 'organization id is ' || v_organization_id);
446: fnd_file.put_line(FND_FILE.LOG, 'location id is ' || v_location_id);
447:
448: if v_location_id is null then
449: OPEN SO_AR_HDR_INFO;
450: FETCH SO_AR_HDR_INFO
451: INTO v_organization_id, v_location_id, v_batch_source_id;
452: CLOSE SO_AR_HDR_INFO;
453: end if;
454:
455: fnd_file.put_line(FND_FILE.LOG,
456: 'organization id is ' || v_organization_id);
457: fnd_file.put_line(FND_FILE.LOG, 'location id is ' || v_location_id);
458:
459: IF v_created_from = 'RAXTRX' THEN
453: end if;
454:
455: fnd_file.put_line(FND_FILE.LOG,
456: 'organization id is ' || v_organization_id);
457: fnd_file.put_line(FND_FILE.LOG, 'location id is ' || v_location_id);
458:
459: IF v_created_from = 'RAXTRX' THEN
460:
461: OPEN register_code_cur1(v_organization_id,