eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.GMD_QC_MIG12 dependencies on GMA_MIGRATION_UTILS

Line 1320: l_organization_id := GMA_MIGRATION_UTILS.GET_ORGANIZATION_ID(l_lab_profile);

1316: Get Organization id for Lab.
1317: ====================================*/
1318:
1319:
1320: l_organization_id := GMA_MIGRATION_UTILS.GET_ORGANIZATION_ID(l_lab_profile);
1321:
1322:
1323: IF (l_organization_id IS NULL) THEN
1324: RAISE NULL_DEF_ORGANIZATION_ID;

Line 1585: l_reason_id := GMA_MIGRATION_UTILS.GET_REASON_ID(v_qual_config.inv_trans_reason_code);

1581:
1582: IF (v_qual_config.inv_trans_reason_code IS NULL) THEN
1583: l_reason_id := NULL;
1584: ELSE
1585: l_reason_id := GMA_MIGRATION_UTILS.GET_REASON_ID(v_qual_config.inv_trans_reason_code);
1586: IF (l_reason_id IS NULL) THEN
1587: RAISE REASON_CODE_ERROR;
1588: END IF;
1589: END IF;

Line 1839: l_reason_id := GMA_MIGRATION_UTILS.GET_REASON_ID(l_config_rec.inv_trans_reason_code);

1835:
1836: IF (l_config_rec.inv_trans_reason_code IS NULL) THEN
1837: l_reason_id := NULL;
1838: ELSE
1839: l_reason_id := GMA_MIGRATION_UTILS.GET_REASON_ID(l_config_rec.inv_trans_reason_code);
1840: IF (l_reason_id IS NULL) THEN
1841: RAISE REASON_CODE_ERROR;
1842: END IF;
1843: END IF;

Line 2289: l_sampling_uom := GMA_MIGRATION_UTILS.get_uom_code(l_sampling_plan.frequency_per);

2285:
2286: GMD_QC_MIG12.g_sampling_plan_pro_count := GMD_QC_MIG12.g_sampling_plan_pro_count + 1;
2287:
2288: IF (l_sampling_plan.frequency_type = 'Q' and l_sampling_plan.frequency_per IS NOT NULL) THEN
2289: l_sampling_uom := GMA_MIGRATION_UTILS.get_uom_code(l_sampling_plan.frequency_per);
2290: IF (l_sampling_uom IS NULL) THEN
2291: RAISE MIG_NO_UOM;
2292: END IF;
2293: ELSE

Line 2576: l_organization_id := GMA_MIGRATION_UTILS.GET_ORGANIZATION_ID(v_samp_rec.orgn_code);

2572: /*======================================
2573: Get Organization ID.
2574: ======================================*/
2575: IF (v_samp_rec.orgn_code IS NOT NULL) THEN
2576: l_organization_id := GMA_MIGRATION_UTILS.GET_ORGANIZATION_ID(v_samp_rec.orgn_code);
2577: IF (l_organization_id IS NULL) THEN
2578: RAISE MIG_NO_ORG;
2579: END IF;
2580: ELSE

Line 2585: l_lab_organization_id := GMA_MIGRATION_UTILS.GET_ORGANIZATION_ID(v_samp_rec.qc_lab_orgn_code);

2581: l_organization_id := NULL;
2582: END IF;
2583:
2584: IF (v_samp_rec.qc_lab_orgn_code IS NOT NULL) THEN
2585: l_lab_organization_id := GMA_MIGRATION_UTILS.GET_ORGANIZATION_ID(v_samp_rec.qc_lab_orgn_code);
2586: IF (l_lab_organization_id IS NULL) THEN
2587: RAISE MIG_NO_LAB_ORG;
2588: END IF;
2589: ELSE

Line 4116: l_owner_org_id := GMA_MIGRATION_UTILS.GET_ORGANIZATION_ID(v_specs_b.owner_orgn_code);

4112: GMD_QC_MIG12.g_specs_pro_count := GMD_QC_MIG12.g_specs_pro_count + 1;
4113: /*==========================================
4114: Get organization_id.
4115: ==========================================*/
4116: l_owner_org_id := GMA_MIGRATION_UTILS.GET_ORGANIZATION_ID(v_specs_b.owner_orgn_code);
4117: IF (l_owner_org_id IS NULL) THEN
4118: RAISE MIG_NO_ORG;
4119: END IF;
4120:

Line 4542: l_sample_organization_id := GMA_MIGRATION_UTILS.GET_ORGANIZATION_ID(l_sample_orgn_code);

4538: /*=========================================
4539: Convert Sample org to organization_id,
4540: =========================================*/
4541: IF (l_sample_organization_id IS NULL) THEN
4542: l_sample_organization_id := GMA_MIGRATION_UTILS.GET_ORGANIZATION_ID(l_sample_orgn_code);
4543: IF (l_sample_organization_id IS NULL) THEN
4544: CLOSE get_sample_org;
4545: RAISE ISPEC_SAMPLE_ORG; -- goes to next invspec record.
4546: END IF;

Line 4646: l_sample_organization_id := GMA_MIGRATION_UTILS.GET_ORGANIZATION_ID(l_sample_orgn_code);

4642: /*=========================================
4643: Convert Sample org to organization_id,
4644: =========================================*/
4645: IF (l_sample_organization_id IS NULL) THEN
4646: l_sample_organization_id := GMA_MIGRATION_UTILS.GET_ORGANIZATION_ID(l_sample_orgn_code);
4647: IF (l_sample_organization_id IS NULL) THEN
4648: CLOSE get_sample_org;
4649: RAISE ISPEC_SAMPLE_ORG_ID;
4650: END IF;

Line 5156: l_wip_org_id := GMA_MIGRATION_UTILS.GET_ORGANIZATION_ID(l_wip_spec.orgn_code);

5152:
5153: -- Bug# 5438990
5154: -- Added IF condition to check if orgn_code is not null
5155: IF l_wip_spec.orgn_code IS NOT NULL THEN
5156: l_wip_org_id := GMA_MIGRATION_UTILS.GET_ORGANIZATION_ID(l_wip_spec.orgn_code);
5157: IF (l_wip_org_id IS NULL) THEN
5158: RAISE WIP_NO_ORG;
5159: END IF;
5160: END IF;

Line 5269: l_sample_organization_id := GMA_MIGRATION_UTILS.GET_ORGANIZATION_ID(l_sample_orgn_code);

5265: /*=========================================
5266: Convert Sample org to organization_id,
5267: =========================================*/
5268: IF (l_sample_organization_id IS NULL) THEN
5269: l_sample_organization_id := GMA_MIGRATION_UTILS.GET_ORGANIZATION_ID(l_sample_orgn_code);
5270: END IF;
5271:
5272: IF (l_sample_organization_id IS NULL) THEN
5273: CLOSE get_wip_sample_org; -- Bug# 5554719 -- Changed it from get_sample_org to get_wip_sample_org

Line 5319: l_sample_organization_id := GMA_MIGRATION_UTILS.GET_ORGANIZATION_ID(l_sample_orgn_code);

5315: Convert the Sample Org.
5316: ================================*/
5317:
5318: IF (l_sample_organization_id IS NULL) THEN
5319: l_sample_organization_id := GMA_MIGRATION_UTILS.GET_ORGANIZATION_ID(l_sample_orgn_code);
5320: IF (l_sample_organization_id IS NULL) THEN
5321: CLOSE get_wip_sample_org;
5322: RAISE WIP_SAMPLE_ORG_ID;
5323: END IF;

Line 5680: l_sample_organization_id := GMA_MIGRATION_UTILS.GET_ORGANIZATION_ID(l_sample_orgn_code);

5676: /*================================
5677: Convert the Sample Org.
5678: ================================*/
5679: IF (l_sample_organization_id IS NULL) THEN
5680: l_sample_organization_id := GMA_MIGRATION_UTILS.GET_ORGANIZATION_ID(l_sample_orgn_code);
5681: IF (l_sample_organization_id IS NULL) THEN
5682: CLOSE get_cust_sample_org; -- Bug# 5554719 -- Changed it from get_sample_org to get_cust_sample_org
5683: RAISE CUST_NO_ORG_ID;
5684: END IF;

Line 5738: l_sample_organization_id := GMA_MIGRATION_UTILS.GET_ORGANIZATION_ID(l_sample_orgn_code);

5734: /*================================
5735: Convert the Sample Org.
5736: ================================*/
5737: IF (l_sample_organization_id IS NULL) THEN
5738: l_sample_organization_id := GMA_MIGRATION_UTILS.GET_ORGANIZATION_ID(l_sample_orgn_code);
5739: IF (l_sample_organization_id IS NULL) THEN
5740: CLOSE get_cust_sample_org; -- Bug# 5554719 -- Changed it from get_sample_org to get_cust_sample_org
5741: RAISE CUST_NO_ORG_ID;
5742: END IF;

Line 6060: l_sample_organization_id := GMA_MIGRATION_UTILS.GET_ORGANIZATION_ID(l_sample_orgn_code);

6056: /*================================
6057: Convert the Sample Org.
6058: ================================*/
6059: IF (l_sample_organization_id IS NULL) THEN
6060: l_sample_organization_id := GMA_MIGRATION_UTILS.GET_ORGANIZATION_ID(l_sample_orgn_code);
6061: IF (l_sample_organization_id IS NULL) THEN
6062: CLOSE get_supl_sample_org; -- Bug# 5554719 -- Changed it from get_sample_org to get_supl_sample_org
6063: RAISE SUP_NO_ORG_ID;
6064: END IF;

Line 6110: l_sample_organization_id := GMA_MIGRATION_UTILS.GET_ORGANIZATION_ID(l_sample_orgn_code);

6106: /*================================
6107: Convert the Sample Org.
6108: ================================*/
6109: IF (l_sample_organization_id IS NULL) THEN
6110: l_sample_organization_id := GMA_MIGRATION_UTILS.GET_ORGANIZATION_ID(l_sample_orgn_code);
6111: IF (l_sample_organization_id IS NULL) THEN
6112: CLOSE get_supl_sample_org; -- Bug# 5554719 -- Changed it from get_sample_org to get_supl_sample_org
6113: RAISE SUP_NO_ORG_ID;
6114: END IF;

Line 6535: l_sample_organization_id := GMA_MIGRATION_UTILS.GET_ORGANIZATION_ID(l_sample_orgn_code);

6531: /*================================
6532: Convert the Sample Org.
6533: ================================*/
6534: IF (l_sample_organization_id IS NULL) THEN
6535: l_sample_organization_id := GMA_MIGRATION_UTILS.GET_ORGANIZATION_ID(l_sample_orgn_code);
6536: IF (l_sample_organization_id IS NULL) THEN
6537: CLOSE get_mon_sample_org; -- Bug# 5554719 -- Changed it from get_sample_org to get_mon_sample_org
6538: RAISE MON_NO_ORG_ID;
6539: END IF;

Line 6587: l_sample_organization_id := GMA_MIGRATION_UTILS.GET_ORGANIZATION_ID(l_sample_orgn_code);

6583: /*================================
6584: Convert the Sample Org.
6585: ================================*/
6586: IF (l_sample_organization_id IS NULL) THEN
6587: l_sample_organization_id := GMA_MIGRATION_UTILS.GET_ORGANIZATION_ID(l_sample_orgn_code);
6588: IF (l_sample_organization_id IS NULL) THEN
6589: CLOSE get_mon_sample_org;
6590: RAISE MON_NO_ORG_ID;
6591: END IF;

Line 7231: l_plan_org_id := GMA_MIGRATION_UTILS.GET_ORGANIZATION_ID(l_def_ss_org);

7227: OPEN get_ss_org;
7228: FETCH get_ss_org INTO l_def_ss_org;
7229: CLOSE get_ss_org;
7230:
7231: l_plan_org_id := GMA_MIGRATION_UTILS.GET_ORGANIZATION_ID(l_def_ss_org);
7232: IF (l_plan_org_id IS NULL) THEN
7233: RAISE DEFAULT_SS_ORG_ERROR;
7234: END IF;
7235: -- END Bug# 5109039

Line 7396: l_stab_org_id := GMA_MIGRATION_UTILS.GET_ORGANIZATION_ID(l_stab_rec.orgn_code);

7392: /*================================
7393: Migrate organization.
7394: ================================*/
7395:
7396: l_stab_org_id := GMA_MIGRATION_UTILS.GET_ORGANIZATION_ID(l_stab_rec.orgn_code);
7397: IF (l_stab_org_id IS NULL) THEN
7398: RAISE STAB_NO_ORG;
7399: END IF;
7400:

Line 7551: l_plant_org_id := GMA_MIGRATION_UTILS.GET_ORGANIZATION_ID(l_matl_rec.plant_code);

7547: Migrate organization.
7548: Convert plant code if it exists.
7549: ===================================*/
7550: IF (l_matl_rec.plant_code IS NOT NULL) THEN
7551: l_plant_org_id := GMA_MIGRATION_UTILS.GET_ORGANIZATION_ID(l_matl_rec.plant_code);
7552: ELSE
7553: l_plant_org_id := NULL;
7554: END IF;
7555:

Line 7574: l_plant_org_id := GMA_MIGRATION_UTILS.GET_ORGANIZATION_ID(l_ss_orgn_code);

7570: Use Stability Study if Plant orgid
7571: is null
7572: ===================================*/
7573: IF (l_plant_org_id IS NULL) THEN
7574: l_plant_org_id := GMA_MIGRATION_UTILS.GET_ORGANIZATION_ID(l_ss_orgn_code);
7575: IF (l_plant_org_id IS NULL) THEN
7576: RAISE MATL_PLANT_ORG;
7577: END IF;
7578: l_lot_orgn_code := l_ss_orgn_code;

Line 7967: l_def_ss_org_id := GMA_MIGRATION_UTILS.GET_ORGANIZATION_ID(l_def_ss_org);

7963: /*==============================================
7964: Get Org id for the Default Orgn Code.
7965: ==============================================*/
7966:
7967: l_def_ss_org_id := GMA_MIGRATION_UTILS.GET_ORGANIZATION_ID(l_def_ss_org);
7968: IF (l_def_ss_org_id IS NULL) THEN
7969: RAISE DEFAULT_SS_ORG_ERROR;
7970: END IF;
7971:

Line 8086: l_ss_org_id := GMA_MIGRATION_UTILS.GET_ORGANIZATION_ID(l_stab_orgn_code);

8082: ELSE
8083: /*========================================
8084: Use Org from Stability Study.
8085: ========================================*/
8086: l_ss_org_id := GMA_MIGRATION_UTILS.GET_ORGANIZATION_ID(l_stab_orgn_code);
8087: IF (l_ss_org_id IS NULL) THEN
8088: CLOSE get_stab_study_org;
8089: RAISE STORE_SS_ORG;
8090: END IF;

Line 8141: l_ss_org_id := GMA_MIGRATION_UTILS.GET_ORGANIZATION_ID(l_stab_orgn_code);

8137: ELSE
8138: l_text_code := NULL;
8139: END IF;
8140:
8141: l_ss_org_id := GMA_MIGRATION_UTILS.GET_ORGANIZATION_ID(l_stab_orgn_code);
8142: IF (l_ss_org_id IS NULL) THEN
8143: CLOSE get_stab_study_org;
8144: RAISE STORE_SS_ORG;
8145: END IF;