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.

APPS.GMD_QC_MIG12 dependencies on GMA_MIGRATION_UTILS

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

1324: Get Organization id for Lab.
1325: ====================================*/
1326:
1327:
1328: l_organization_id := GMA_MIGRATION_UTILS.GET_ORGANIZATION_ID(l_lab_profile);
1329:
1330:
1331: IF (l_organization_id IS NULL) THEN
1332: RAISE NULL_DEF_ORGANIZATION_ID;

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

1589:
1590: IF (v_qual_config.inv_trans_reason_code IS NULL) THEN
1591: l_reason_id := NULL;
1592: ELSE
1593: l_reason_id := GMA_MIGRATION_UTILS.GET_REASON_ID(v_qual_config.inv_trans_reason_code);
1594: IF (l_reason_id IS NULL) THEN
1595: RAISE REASON_CODE_ERROR;
1596: END IF;
1597: END IF;

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

1843:
1844: IF (l_config_rec.inv_trans_reason_code IS NULL) THEN
1845: l_reason_id := NULL;
1846: ELSE
1847: l_reason_id := GMA_MIGRATION_UTILS.GET_REASON_ID(l_config_rec.inv_trans_reason_code);
1848: IF (l_reason_id IS NULL) THEN
1849: RAISE REASON_CODE_ERROR;
1850: END IF;
1851: END IF;

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

2293:
2294: GMD_QC_MIG12.g_sampling_plan_pro_count := GMD_QC_MIG12.g_sampling_plan_pro_count + 1;
2295:
2296: IF (l_sampling_plan.frequency_type = 'Q' and l_sampling_plan.frequency_per IS NOT NULL) THEN
2297: l_sampling_uom := GMA_MIGRATION_UTILS.get_uom_code(l_sampling_plan.frequency_per);
2298: IF (l_sampling_uom IS NULL) THEN
2299: RAISE MIG_NO_UOM;
2300: END IF;
2301: ELSE

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

2613: /*======================================
2614: Get Organization ID.
2615: ======================================*/
2616: IF (v_samp_rec.orgn_code IS NOT NULL) THEN
2617: l_organization_id := GMA_MIGRATION_UTILS.GET_ORGANIZATION_ID(v_samp_rec.orgn_code);
2618: IF (l_organization_id IS NULL) THEN
2619: RAISE MIG_NO_ORG;
2620: END IF;
2621: ELSE

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

2622: l_organization_id := NULL;
2623: END IF;
2624:
2625: IF (v_samp_rec.qc_lab_orgn_code IS NOT NULL) THEN
2626: l_lab_organization_id := GMA_MIGRATION_UTILS.GET_ORGANIZATION_ID(v_samp_rec.qc_lab_orgn_code);
2627: IF (l_lab_organization_id IS NULL) THEN
2628: RAISE MIG_NO_LAB_ORG;
2629: END IF;
2630: ELSE

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

4381: GMD_QC_MIG12.g_specs_pro_count := GMD_QC_MIG12.g_specs_pro_count + 1;
4382: /*==========================================
4383: Get organization_id.
4384: ==========================================*/
4385: l_owner_org_id := GMA_MIGRATION_UTILS.GET_ORGANIZATION_ID(v_specs_b.owner_orgn_code);
4386: IF (l_owner_org_id IS NULL) THEN
4387: RAISE MIG_NO_ORG;
4388: END IF;
4389:

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

4807: /*=========================================
4808: Convert Sample org to organization_id,
4809: =========================================*/
4810: IF (l_sample_organization_id IS NULL) THEN
4811: l_sample_organization_id := GMA_MIGRATION_UTILS.GET_ORGANIZATION_ID(l_sample_orgn_code);
4812: IF (l_sample_organization_id IS NULL) THEN
4813: CLOSE get_sample_org;
4814: RAISE ISPEC_SAMPLE_ORG; -- goes to next invspec record.
4815: END IF;

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

4911: /*=========================================
4912: Convert Sample org to organization_id,
4913: =========================================*/
4914: IF (l_sample_organization_id IS NULL) THEN
4915: l_sample_organization_id := GMA_MIGRATION_UTILS.GET_ORGANIZATION_ID(l_sample_orgn_code);
4916: IF (l_sample_organization_id IS NULL) THEN
4917: CLOSE get_sample_org;
4918: RAISE ISPEC_SAMPLE_ORG_ID;
4919: END IF;

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

5421:
5422: -- Bug# 5438990
5423: -- Added IF condition to check if orgn_code is not null
5424: IF l_wip_spec.orgn_code IS NOT NULL THEN
5425: l_wip_org_id := GMA_MIGRATION_UTILS.GET_ORGANIZATION_ID(l_wip_spec.orgn_code);
5426: IF (l_wip_org_id IS NULL) THEN
5427: RAISE WIP_NO_ORG;
5428: END IF;
5429: END IF;

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

5534: /*=========================================
5535: Convert Sample org to organization_id,
5536: =========================================*/
5537: IF (l_sample_organization_id IS NULL) THEN
5538: l_sample_organization_id := GMA_MIGRATION_UTILS.GET_ORGANIZATION_ID(l_sample_orgn_code);
5539: END IF;
5540:
5541: IF (l_sample_organization_id IS NULL) THEN
5542: CLOSE get_wip_sample_org; -- Bug# 5554719 -- Changed it from get_sample_org to get_wip_sample_org

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

5584: Convert the Sample Org.
5585: ================================*/
5586:
5587: IF (l_sample_organization_id IS NULL) THEN
5588: l_sample_organization_id := GMA_MIGRATION_UTILS.GET_ORGANIZATION_ID(l_sample_orgn_code);
5589: IF (l_sample_organization_id IS NULL) THEN
5590: CLOSE get_wip_sample_org;
5591: RAISE WIP_SAMPLE_ORG_ID;
5592: END IF;

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

5945: /*================================
5946: Convert the Sample Org.
5947: ================================*/
5948: IF (l_sample_organization_id IS NULL) THEN
5949: l_sample_organization_id := GMA_MIGRATION_UTILS.GET_ORGANIZATION_ID(l_sample_orgn_code);
5950: IF (l_sample_organization_id IS NULL) THEN
5951: CLOSE get_cust_sample_org; -- Bug# 5554719 -- Changed it from get_sample_org to get_cust_sample_org
5952: RAISE CUST_NO_ORG_ID;
5953: END IF;

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

6003: /*================================
6004: Convert the Sample Org.
6005: ================================*/
6006: IF (l_sample_organization_id IS NULL) THEN
6007: l_sample_organization_id := GMA_MIGRATION_UTILS.GET_ORGANIZATION_ID(l_sample_orgn_code);
6008: IF (l_sample_organization_id IS NULL) THEN
6009: CLOSE get_cust_sample_org; -- Bug# 5554719 -- Changed it from get_sample_org to get_cust_sample_org
6010: RAISE CUST_NO_ORG_ID;
6011: END IF;

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

6325: /*================================
6326: Convert the Sample Org.
6327: ================================*/
6328: IF (l_sample_organization_id IS NULL) THEN
6329: l_sample_organization_id := GMA_MIGRATION_UTILS.GET_ORGANIZATION_ID(l_sample_orgn_code);
6330: IF (l_sample_organization_id IS NULL) THEN
6331: CLOSE get_supl_sample_org; -- Bug# 5554719 -- Changed it from get_sample_org to get_supl_sample_org
6332: RAISE SUP_NO_ORG_ID;
6333: END IF;

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

6375: /*================================
6376: Convert the Sample Org.
6377: ================================*/
6378: IF (l_sample_organization_id IS NULL) THEN
6379: l_sample_organization_id := GMA_MIGRATION_UTILS.GET_ORGANIZATION_ID(l_sample_orgn_code);
6380: IF (l_sample_organization_id IS NULL) THEN
6381: CLOSE get_supl_sample_org; -- Bug# 5554719 -- Changed it from get_sample_org to get_supl_sample_org
6382: RAISE SUP_NO_ORG_ID;
6383: END IF;

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

6800: /*================================
6801: Convert the Sample Org.
6802: ================================*/
6803: IF (l_sample_organization_id IS NULL) THEN
6804: l_sample_organization_id := GMA_MIGRATION_UTILS.GET_ORGANIZATION_ID(l_sample_orgn_code);
6805: IF (l_sample_organization_id IS NULL) THEN
6806: CLOSE get_mon_sample_org; -- Bug# 5554719 -- Changed it from get_sample_org to get_mon_sample_org
6807: RAISE MON_NO_ORG_ID;
6808: END IF;

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

6852: /*================================
6853: Convert the Sample Org.
6854: ================================*/
6855: IF (l_sample_organization_id IS NULL) THEN
6856: l_sample_organization_id := GMA_MIGRATION_UTILS.GET_ORGANIZATION_ID(l_sample_orgn_code);
6857: IF (l_sample_organization_id IS NULL) THEN
6858: CLOSE get_mon_sample_org;
6859: RAISE MON_NO_ORG_ID;
6860: END IF;

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

7496: OPEN get_ss_org;
7497: FETCH get_ss_org INTO l_def_ss_org;
7498: CLOSE get_ss_org;
7499:
7500: l_plan_org_id := GMA_MIGRATION_UTILS.GET_ORGANIZATION_ID(l_def_ss_org);
7501: IF (l_plan_org_id IS NULL) THEN
7502: RAISE DEFAULT_SS_ORG_ERROR;
7503: END IF;
7504: -- END Bug# 5109039

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

7661: /*================================
7662: Migrate organization.
7663: ================================*/
7664:
7665: l_stab_org_id := GMA_MIGRATION_UTILS.GET_ORGANIZATION_ID(l_stab_rec.orgn_code);
7666: IF (l_stab_org_id IS NULL) THEN
7667: RAISE STAB_NO_ORG;
7668: END IF;
7669:

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

7816: Migrate organization.
7817: Convert plant code if it exists.
7818: ===================================*/
7819: IF (l_matl_rec.plant_code IS NOT NULL) THEN
7820: l_plant_org_id := GMA_MIGRATION_UTILS.GET_ORGANIZATION_ID(l_matl_rec.plant_code);
7821: ELSE
7822: l_plant_org_id := NULL;
7823: END IF;
7824:

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

7839: Use Stability Study if Plant orgid
7840: is null
7841: ===================================*/
7842: IF (l_plant_org_id IS NULL) THEN
7843: l_plant_org_id := GMA_MIGRATION_UTILS.GET_ORGANIZATION_ID(l_ss_orgn_code);
7844: IF (l_plant_org_id IS NULL) THEN
7845: RAISE MATL_PLANT_ORG;
7846: END IF;
7847: l_lot_orgn_code := l_ss_orgn_code;

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

8232: /*==============================================
8233: Get Org id for the Default Orgn Code.
8234: ==============================================*/
8235:
8236: l_def_ss_org_id := GMA_MIGRATION_UTILS.GET_ORGANIZATION_ID(l_def_ss_org);
8237: IF (l_def_ss_org_id IS NULL) THEN
8238: RAISE DEFAULT_SS_ORG_ERROR;
8239: END IF;
8240:

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

8351: ELSE
8352: /*========================================
8353: Use Org from Stability Study.
8354: ========================================*/
8355: l_ss_org_id := GMA_MIGRATION_UTILS.GET_ORGANIZATION_ID(l_stab_orgn_code);
8356: IF (l_ss_org_id IS NULL) THEN
8357: CLOSE get_stab_study_org;
8358: RAISE STORE_SS_ORG;
8359: END IF;

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

8406: ELSE
8407: l_text_code := NULL;
8408: END IF;
8409:
8410: l_ss_org_id := GMA_MIGRATION_UTILS.GET_ORGANIZATION_ID(l_stab_orgn_code);
8411: IF (l_ss_org_id IS NULL) THEN
8412: CLOSE get_stab_study_org;
8413: RAISE STORE_SS_ORG;
8414: END IF;