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.CSD_HV_WIP_JOB_PVT dependencies on FND_PROFILE

Line 37: if (nvl(fnd_profile.value('CSD_DEF_CUR_REVISION_MTL_TXN'), 'Y') = 'N' ) then

33: l_get_default VARCHAR2(1) := FND_API.G_TRUE;
34: BEGIN
35: if (p_mat_transaction_type = 'MAT_ISSUE') then -- material issue
36: --swai: bug 6654197 - allow user to specify revision based on profile option
37: if (nvl(fnd_profile.value('CSD_DEF_CUR_REVISION_MTL_TXN'), 'Y') = 'N' ) then
38: l_get_default := FND_API.G_FALSE;
39: end if;
40: elsif (p_mat_transaction_type = 'JOB_COMP') then -- job completion
41: -- swai: bug 6654197 - allow user to specify revision based on profile option

Line 42: if (nvl(fnd_profile.value('CSD_DEF_CUR_REVISION_JOB_COMP'), 'Y') = 'N' ) then

38: l_get_default := FND_API.G_FALSE;
39: end if;
40: elsif (p_mat_transaction_type = 'JOB_COMP') then -- job completion
41: -- swai: bug 6654197 - allow user to specify revision based on profile option
42: if (nvl(fnd_profile.value('CSD_DEF_CUR_REVISION_JOB_COMP'), 'Y') = 'N' ) then
43: l_get_default := FND_API.G_FALSE;
44: end if;
45: end if;
46: if (l_get_default = FND_API.G_TRUE) then

Line 2001: IF fnd_profile.value('CSD_DEF_REP_INV_ORG') = l_transactions_interface_rec.organization_id and

1997: END IF;
1998:
1999: IF l_transactions_interface_rec.subinventory_code is null THEN
2000:
2001: IF fnd_profile.value('CSD_DEF_REP_INV_ORG') = l_transactions_interface_rec.organization_id and
2002: fnd_profile.value('CSD_DEF_HV_CMP_SUBINV') is not null THEN
2003: l_transactions_interface_rec.subinventory_code := fnd_profile.value('CSD_DEF_HV_CMP_SUBINV');
2004: ELSE
2005: x_need_details_flag := 'T'; -- swai: bug 5262927

Line 2002: fnd_profile.value('CSD_DEF_HV_CMP_SUBINV') is not null THEN

1998:
1999: IF l_transactions_interface_rec.subinventory_code is null THEN
2000:
2001: IF fnd_profile.value('CSD_DEF_REP_INV_ORG') = l_transactions_interface_rec.organization_id and
2002: fnd_profile.value('CSD_DEF_HV_CMP_SUBINV') is not null THEN
2003: l_transactions_interface_rec.subinventory_code := fnd_profile.value('CSD_DEF_HV_CMP_SUBINV');
2004: ELSE
2005: x_need_details_flag := 'T'; -- swai: bug 5262927
2006: END IF;

Line 2003: l_transactions_interface_rec.subinventory_code := fnd_profile.value('CSD_DEF_HV_CMP_SUBINV');

1999: IF l_transactions_interface_rec.subinventory_code is null THEN
2000:
2001: IF fnd_profile.value('CSD_DEF_REP_INV_ORG') = l_transactions_interface_rec.organization_id and
2002: fnd_profile.value('CSD_DEF_HV_CMP_SUBINV') is not null THEN
2003: l_transactions_interface_rec.subinventory_code := fnd_profile.value('CSD_DEF_HV_CMP_SUBINV');
2004: ELSE
2005: x_need_details_flag := 'T'; -- swai: bug 5262927
2006: END IF;
2007: END IF;

Line 2342: IF (nvl(fnd_profile.value('MRP_DEBUG'),'Y') = 'N') THEN

2338: x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
2339:
2340: --bug#14456229 --14497341
2341: if (p_txn_header_id is not null) then
2342: IF (nvl(fnd_profile.value('MRP_DEBUG'),'Y') = 'N') THEN
2343:
2344: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2345: FND_LOG.STRING( FND_LOG.LEVEL_EVENT,
2346: lc_mod_name||'Error',

Line 2416: IF (nvl(fnd_profile.value('MRP_DEBUG'),'Y') = 'Y') THEN

2412:
2413:
2414: WHEN FND_API.G_EXC_ERROR THEN
2415: --bug#14456229 --14497341
2416: IF (nvl(fnd_profile.value('MRP_DEBUG'),'Y') = 'Y') THEN
2417: ROLLBACK to PROCESS_MTI_TRANSACTIONS_PVT ;
2418: End if;
2419: --bug#14456229 --14497341
2420:

Line 3006: -- l_completion_subinv := nvl( p_completion_subinv, fnd_profile.value('CSD_HV_COMP_SUBINV')) ;

3002: l_job_details_rec.group_id := l_job_header_rec.group_id;
3003: /* l_job_details_rec.parent_header_id := l_job_header_rec.group_id;
3004:
3005: */
3006: -- l_completion_subinv := nvl( p_completion_subinv, fnd_profile.value('CSD_HV_COMP_SUBINV')) ;
3007: -- l_completion_loc_id : nvl( p_completion_loc_id, fnd_profile.value('CSD_HV_COMP_LOC_ID'));
3008:
3009:
3010:

Line 3007: -- l_completion_loc_id : nvl( p_completion_loc_id, fnd_profile.value('CSD_HV_COMP_LOC_ID'));

3003: /* l_job_details_rec.parent_header_id := l_job_header_rec.group_id;
3004:
3005: */
3006: -- l_completion_subinv := nvl( p_completion_subinv, fnd_profile.value('CSD_HV_COMP_SUBINV')) ;
3007: -- l_completion_loc_id : nvl( p_completion_loc_id, fnd_profile.value('CSD_HV_COMP_LOC_ID'));
3008:
3009:
3010:
3011: FOR mtl_ctr in p_mtl_txn_dtls_tbl.FIRST.. p_mtl_txn_dtls_tbl.LAST

Line 3092: IF fnd_profile.value('CSD_DEF_REP_INV_ORG') = p_mtl_txn_dtls_tbl(mtl_ctr).organization_id and

3088: l_transactions_interface_rec.subinventory_code := p_mtl_txn_dtls_tbl(mtl_ctr).supply_subinventory;
3089:
3090: ELSE
3091:
3092: IF fnd_profile.value('CSD_DEF_REP_INV_ORG') = p_mtl_txn_dtls_tbl(mtl_ctr).organization_id and
3093: fnd_profile.value('CSD_DEF_HV_SUBINV') is not null THEN
3094: l_transactions_interface_rec.subinventory_code := fnd_profile.value('CSD_DEF_HV_SUBINV');
3095: ELSE
3096: l_row_need_details_flag := 'T';

Line 3093: fnd_profile.value('CSD_DEF_HV_SUBINV') is not null THEN

3089:
3090: ELSE
3091:
3092: IF fnd_profile.value('CSD_DEF_REP_INV_ORG') = p_mtl_txn_dtls_tbl(mtl_ctr).organization_id and
3093: fnd_profile.value('CSD_DEF_HV_SUBINV') is not null THEN
3094: l_transactions_interface_rec.subinventory_code := fnd_profile.value('CSD_DEF_HV_SUBINV');
3095: ELSE
3096: l_row_need_details_flag := 'T';
3097: END IF;

Line 3094: l_transactions_interface_rec.subinventory_code := fnd_profile.value('CSD_DEF_HV_SUBINV');

3090: ELSE
3091:
3092: IF fnd_profile.value('CSD_DEF_REP_INV_ORG') = p_mtl_txn_dtls_tbl(mtl_ctr).organization_id and
3093: fnd_profile.value('CSD_DEF_HV_SUBINV') is not null THEN
3094: l_transactions_interface_rec.subinventory_code := fnd_profile.value('CSD_DEF_HV_SUBINV');
3095: ELSE
3096: l_row_need_details_flag := 'T';
3097: END IF;
3098: END IF;

Line 3156: /* IF fnd_profile.value('CSD_DEF_REP_INV_ORG') = p_mtl_txn_dtls_tbl(mtl_ctr).organization_id and

3152: l_transactions_interface_rec.locator_id := p_mtl_txn_dtls_tbl(mtl_ctr).supply_locator_id;
3153:
3154: ELSE
3155:
3156: /* IF fnd_profile.value('CSD_DEF_REP_INV_ORG') = p_mtl_txn_dtls_tbl(mtl_ctr).organization_id and
3157: fnd_profile.value('CSD_DEF_HV_LOC_ID') is not null THEN
3158:
3159:
3160: l_transactions_interface_rec.locator_id := fnd_profile.value('CSD_DEF_HV_LOC_ID');

Line 3157: fnd_profile.value('CSD_DEF_HV_LOC_ID') is not null THEN

3153:
3154: ELSE
3155:
3156: /* IF fnd_profile.value('CSD_DEF_REP_INV_ORG') = p_mtl_txn_dtls_tbl(mtl_ctr).organization_id and
3157: fnd_profile.value('CSD_DEF_HV_LOC_ID') is not null THEN
3158:
3159:
3160: l_transactions_interface_rec.locator_id := fnd_profile.value('CSD_DEF_HV_LOC_ID');
3161: dbms_output.put_line( 'l_transactions_interface_rec.locator_id is'

Line 3160: l_transactions_interface_rec.locator_id := fnd_profile.value('CSD_DEF_HV_LOC_ID');

3156: /* IF fnd_profile.value('CSD_DEF_REP_INV_ORG') = p_mtl_txn_dtls_tbl(mtl_ctr).organization_id and
3157: fnd_profile.value('CSD_DEF_HV_LOC_ID') is not null THEN
3158:
3159:
3160: l_transactions_interface_rec.locator_id := fnd_profile.value('CSD_DEF_HV_LOC_ID');
3161: dbms_output.put_line( 'l_transactions_interface_rec.locator_id is'
3162: || l_transactions_interface_rec.locator_id );
3163:
3164: ELSE */

Line 3585: IF (nvl(fnd_profile.value('MRP_DEBUG'),'Y') = 'N') THEN

3581:
3582: end if;
3583:
3584: --bug#12316893
3585: IF (nvl(fnd_profile.value('MRP_DEBUG'),'Y') = 'N') THEN
3586: WIP_MASS_LOAD_PROCESSOR.Delete_Completed_Records(l_job_header_rec.group_id);
3587: End If;
3588: --bug#12316893
3589:

Line 4216: -- l_job_details_rec.autocharge_type := fnd_profile.value('CSD_HV_ATCHG_TYP');

4212:
4213: l_job_details_rec.substitution_type := lc_substitution_change_type;
4214:
4215:
4216: -- l_job_details_rec.autocharge_type := fnd_profile.value('CSD_HV_ATCHG_TYP');
4217:
4218: -- If autocharge_type is null, throw an error and return;
4219: -- Uncomment following later - once profiles are defined
4220: /* IF l_job_details_rec.autocharge_type is NULL THEN

Line 4228: l_job_details_rec.basis_type := fnd_profile.value('CSD_HV_BASIS_TYP');

4224: RAISE FND_API.G_EXC_ERROR;
4225: end if;
4226:
4227:
4228: l_job_details_rec.basis_type := fnd_profile.value('CSD_HV_BASIS_TYP');
4229:
4230: -- If basis_type is null, throw an error and return;
4231:
4232: IF l_job_details_rec.basis_type is NULL THEN

Line 4239: l_job_details_rec.scheduled_flag := fnd_profile.value('CSD_HV_SCD_FLG');

4235: FND_MSG_PUB.ADD;
4236: RAISE FND_API.G_EXC_ERROR;
4237: end if;
4238:
4239: l_job_details_rec.scheduled_flag := fnd_profile.value('CSD_HV_SCD_FLG');
4240:
4241: -- If scheduled_flag is null, throw an error and return;
4242:
4243: IF l_job_details_rec.scheduled_flag is NULL THEN

Line 4250: l_job_details_rec.standard_rate_flag := fnd_profile.value('CSD_HV_STD_FLG');

4246: FND_MSG_PUB.ADD;
4247: RAISE FND_API.G_EXC_ERROR;
4248: end if;
4249:
4250: l_job_details_rec.standard_rate_flag := fnd_profile.value('CSD_HV_STD_FLG');
4251:
4252: -- If standard_rate_flag is null, throw an error and return;
4253:
4254: IF l_job_details_rec.standard_rate_flag is NULL THEN

Line 4516: IF (nvl(fnd_profile.value('MRP_DEBUG'),'Y') = 'N') THEN

4512:
4513: end if;
4514:
4515: --bug#12316893
4516: IF (nvl(fnd_profile.value('MRP_DEBUG'),'Y') = 'N') THEN
4517: WIP_MASS_LOAD_PROCESSOR.Delete_Completed_Records(l_job_header_rec.group_id);
4518: End If;
4519: --bug#12316893
4520:

Line 4836: l_op_dtls_tbl(1).department_id := fnd_profile.value('CSD_DEF_HV_OP_DEPT');

4832: close get_operation_exists;
4833: end if;
4834: if (l_op_exists is null) then
4835: -- create operation, but only if default department is specified
4836: l_op_dtls_tbl(1).department_id := fnd_profile.value('CSD_DEF_HV_OP_DEPT');
4837: if (l_op_dtls_tbl(1).department_id is null) then
4838: -- No operations exist for the job and no default
4839: -- department has been specified, so throw an error.
4840: -- we cannot add the material to operation 1 since

Line 4913: --FND_LOG.STRING(FND_LOG.LEVEL_EVENT,lc_mod_name,'CSD_DEF_HV_SUBINV : '||fnd_profile.value('CSD_DEF_HV_SUBINV'));

4909: l_job_details_rec.SUPPLY_LOCATOR_ID := p_mtl_txn_dtls_tbl(mtl_ctr).supply_locator_id;
4910:
4911: --FND_LOG.STRING(FND_LOG.LEVEL_EVENT,lc_mod_name,'SUPPLY_LOCATOR_ID : '||p_mtl_txn_dtls_tbl(mtl_ctr).supply_locator_id);
4912: --FND_LOG.STRING(FND_LOG.LEVEL_EVENT,lc_mod_name,'supply_subinventory : '||p_mtl_txn_dtls_tbl(mtl_ctr).supply_subinventory);
4913: --FND_LOG.STRING(FND_LOG.LEVEL_EVENT,lc_mod_name,'CSD_DEF_HV_SUBINV : '||fnd_profile.value('CSD_DEF_HV_SUBINV'));
4914:
4915:
4916: if (p_mtl_txn_dtls_tbl(mtl_ctr).supply_locator_id is null) Then
4917:

Line 4949: --FND_LOG.STRING(FND_LOG.LEVEL_EVENT,lc_mod_name,'CSD_DEF_INV_LOCATOR : '||fnd_profile.value('CSD_DEF_INV_LOCATOR'));

4945:
4946: --FND_LOG.STRING(FND_LOG.LEVEL_EVENT,lc_mod_name,'l_wip_supply_subinventory : '||l_wip_supply_subinventory);
4947: --FND_LOG.STRING(FND_LOG.LEVEL_EVENT,lc_mod_name,'l_wip_supply_locator_id : '||l_wip_supply_locator_id);
4948: --FND_LOG.STRING(FND_LOG.LEVEL_EVENT,lc_mod_name,'l_locator_controlled : '||l_locator_controlled);
4949: --FND_LOG.STRING(FND_LOG.LEVEL_EVENT,lc_mod_name,'CSD_DEF_INV_LOCATOR : '||fnd_profile.value('CSD_DEF_INV_LOCATOR'));
4950: --wip_supply_type = 2 means assembly pull, 3 means operation pull
4951:
4952: If ((l_locator_controlled = 'T' or l_locator_subinv_controlled = 'T') and (l_wip_supply_type = 2 or l_wip_supply_type = 3))
4953: THEN

Line 4960: l_job_details_rec.SUPPLY_LOCATOR_ID := fnd_profile.value('CSD_DEF_INV_LOCATOR');

4956: --if the value is not set there, get it from depot CSD_DEF_INV_LOCATOR profile value
4957: l_job_details_rec.supply_subinventory := l_wip_supply_subinventory;
4958: l_job_details_rec.SUPPLY_LOCATOR_ID := l_wip_supply_locator_id;
4959: else
4960: l_job_details_rec.SUPPLY_LOCATOR_ID := fnd_profile.value('CSD_DEF_INV_LOCATOR');
4961: --FND_LOG.STRING(FND_LOG.LEVEL_EVENT,lc_mod_name,'SUPPLY_LOCATOR_ID : '||l_job_details_rec.SUPPLY_LOCATOR_ID);
4962: end if;
4963: end if;
4964:

Line 5047: IF (nvl(fnd_profile.value('MRP_DEBUG'),'Y') = 'N') THEN

5043: RETURN;
5044: end if;
5045:
5046: --bug#12316893
5047: IF (nvl(fnd_profile.value('MRP_DEBUG'),'Y') = 'N') THEN
5048: WIP_MASS_LOAD_PROCESSOR.Delete_Completed_Records(l_job_header_rec.group_id);
5049: End If;
5050: --bug#12316893
5051:

Line 5226: IF (nvl(fnd_profile.value('MRP_DEBUG'),'Y') = 'N') THEN

5222: -- because wip transaction details can be updated.
5223: end if;
5224:
5225: --bug#12316893
5226: IF (nvl(fnd_profile.value('MRP_DEBUG'),'Y') = 'N') THEN
5227: WIP_MASS_LOAD_PROCESSOR.Delete_Completed_Records(l_job_header_rec.group_id);
5228: End If;
5229: --bug#12316893
5230:

Line 5684: IF (nvl(fnd_profile.value('MRP_DEBUG'),'Y') = 'N') THEN

5680: RETURN;
5681: end if;
5682:
5683: --bug#12316893
5684: IF (nvl(fnd_profile.value('MRP_DEBUG'),'Y') = 'N') THEN
5685: WIP_MASS_LOAD_PROCESSOR.Delete_Completed_Records(l_job_header_rec.group_id);
5686: End If;
5687: --bug#12316893
5688:

Line 6084: IF (nvl(fnd_profile.value('MRP_DEBUG'),'Y') = 'N') THEN

6080: RETURN;
6081: end if;
6082:
6083: --bug#12316893
6084: IF (nvl(fnd_profile.value('MRP_DEBUG'),'Y') = 'N') THEN
6085: WIP_MASS_LOAD_PROCESSOR.Delete_Completed_Records(l_job_header_rec.group_id);
6086: End If;
6087: --bug#12316893
6088:

Line 6439: fnd_profile.value('CSD_DEF_REP_INV_ORG');

6435: x_return_status:=FND_API.G_RET_STS_SUCCESS;
6436:
6437:
6438: l_job_header_rec.organization_id :=
6439: fnd_profile.value('CSD_DEF_REP_INV_ORG');
6440:
6441: -- l_job_header_rec.organization_id := 207;
6442:
6443: IF l_job_header_rec.organization_id is NULL THEN

Line 6451: l_job_prefix := fnd_profile.value('CSD_DEFAULT_JOB_PREFIX');

6447: RAISE FND_API.G_EXC_ERROR;
6448: end if;
6449:
6450:
6451: l_job_prefix := fnd_profile.value('CSD_DEFAULT_JOB_PREFIX');
6452:
6453: -- If l_job_prefix is null, throw an error and return;
6454:
6455: -- l_job_prefix := 'SR';

Line 6475: fnd_profile.value('CSD_DEF_WIP_ACCOUNTING_CLASS');

6471: CLOSE c_repair_project_info;
6472: --bug#13472453
6473:
6474: l_job_header_rec.class_code :=
6475: fnd_profile.value('CSD_DEF_WIP_ACCOUNTING_CLASS');
6476:
6477: -- l_job_header_rec.class_code := 'Rework';
6478:
6479: IF l_job_header_rec.class_code is NULL THEN

Line 6492: if fnd_profile.value('CSD_DEFAULT_JOB_STATUS') = 'RELEASED' then

6488: -- Assign the WIP Job Status lookup codes corresponding to Released -- and Unreleased Job status,
6489: -- to be passed for WIP Interface Table
6490:
6491:
6492: if fnd_profile.value('CSD_DEFAULT_JOB_STATUS') = 'RELEASED' then
6493:
6494:
6495: l_job_header_rec.status_type := lc_released_status_code ;
6496:

Line 6497: elsif nvl( fnd_profile.value('CSD_DEFAULT_JOB_STATUS'), 'UNRELEASED' ) = 'UNRELEASED' then

6493:
6494:
6495: l_job_header_rec.status_type := lc_released_status_code ;
6496:
6497: elsif nvl( fnd_profile.value('CSD_DEFAULT_JOB_STATUS'), 'UNRELEASED' ) = 'UNRELEASED' then
6498:
6499: l_job_header_rec.status_type := lc_unreleased_status_code;
6500: end if;
6501:

Line 6516: IF ( nvl(fnd_profile.value('CSD_WIP_MRP_NET_QTY'),'N') = 'N' ) THEN

6512:
6513: -- If the profile CSD: Default WIP MRP Net Qty to Zero is set to
6514: -- null / 'N' then net_quantity = start_quantity else if the
6515: -- profile is set to 'Y' then net_quantity = 0
6516: IF ( nvl(fnd_profile.value('CSD_WIP_MRP_NET_QTY'),'N') = 'N' ) THEN
6517: l_job_header_rec.net_quantity := p_repair_quantity;
6518: ELSIF ( fnd_profile.value('CSD_WIP_MRP_NET_QTY') = 'Y' ) THEN
6519: l_job_header_rec.net_quantity := 0;
6520: END IF;

Line 6518: ELSIF ( fnd_profile.value('CSD_WIP_MRP_NET_QTY') = 'Y' ) THEN

6514: -- null / 'N' then net_quantity = start_quantity else if the
6515: -- profile is set to 'Y' then net_quantity = 0
6516: IF ( nvl(fnd_profile.value('CSD_WIP_MRP_NET_QTY'),'N') = 'N' ) THEN
6517: l_job_header_rec.net_quantity := p_repair_quantity;
6518: ELSIF ( fnd_profile.value('CSD_WIP_MRP_NET_QTY') = 'Y' ) THEN
6519: l_job_header_rec.net_quantity := 0;
6520: END IF;
6521:
6522:

Line 6581: fnd_profile.get('ORG_ID', l_org_id);

6577: -- dbms_output.put_line('Before calling createonejob');
6578:
6579: --bug#13472453
6580: -- Set the Policy context as required for MOAC Uptake, Bug#4421242
6581: fnd_profile.get('ORG_ID', l_org_id);
6582: mo_global.set_policy_context('S',l_org_id);
6583:
6584: WIP_MASSLOAD_PUB.createOneJob( p_interfaceID => l_job_header_rec.interface_id, --bug 9263438
6585: p_validationLevel => p_validation_level,

Line 6638: l_default_ro_item := nvl(FND_PROFILE.VALUE('CSD_DEFAULT_RO_ITEM_AS_MATERIAL_ON_JOB'), 'N');

6634:
6635:
6636: --*****Below are the code to Default Repair Item as Material on Job**********
6637:
6638: l_default_ro_item := nvl(FND_PROFILE.VALUE('CSD_DEFAULT_RO_ITEM_AS_MATERIAL_ON_JOB'), 'N');
6639: --taklam
6640: if (l_default_ro_item = 'Y') then
6641: -- swai: bug 7477845/7483291
6642: -- check if there another job existing for this RO. If so, do not default

Line 6663: l_inventory_org_id := fnd_profile.value('CSD_DEF_REP_INV_ORG'); -- swai: bug 9954780

6659: l_quantity,
6660: l_serial_number;
6661: -- l_inventory_org_id; -- swai: bug 9954780
6662: CLOSE c_repair_line_info;
6663: l_inventory_org_id := fnd_profile.value('CSD_DEF_REP_INV_ORG'); -- swai: bug 9954780
6664: l_subinventory := fnd_profile.value('CSD_DEF_HV_SUBINV');
6665:
6666: --Get serial number control code and lot control code
6667: OPEN cur_get_item_attribs (l_inventory_org_id,

Line 6664: l_subinventory := fnd_profile.value('CSD_DEF_HV_SUBINV');

6660: l_serial_number;
6661: -- l_inventory_org_id; -- swai: bug 9954780
6662: CLOSE c_repair_line_info;
6663: l_inventory_org_id := fnd_profile.value('CSD_DEF_REP_INV_ORG'); -- swai: bug 9954780
6664: l_subinventory := fnd_profile.value('CSD_DEF_HV_SUBINV');
6665:
6666: --Get serial number control code and lot control code
6667: OPEN cur_get_item_attribs (l_inventory_org_id,
6668: l_inventory_item_id);

Line 7241: fnd_profile.value('CSD_DEF_REP_INV_ORG');

7237: -- Initialize API return status to success
7238: x_return_status:=FND_API.G_RET_STS_SUCCESS;
7239:
7240: l_job_header_rec.organization_id :=
7241: fnd_profile.value('CSD_DEF_REP_INV_ORG');
7242:
7243:
7244: IF l_job_header_rec.organization_id is NULL THEN
7245:

Line 7251: l_job_prefix := fnd_profile.value('CSD_DEFAULT_JOB_PREFIX');

7247: FND_MSG_PUB.ADD;
7248: RAISE FND_API.G_EXC_ERROR;
7249: END IF;
7250:
7251: l_job_prefix := fnd_profile.value('CSD_DEFAULT_JOB_PREFIX');
7252:
7253: -- If l_job_prefix is null, throw an error and return;
7254: IF l_job_prefix is NULL THEN
7255: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_PREFIX_NULL');

Line 7261: fnd_profile.value('CSD_DEF_WIP_ACCOUNTING_CLASS');

7257: RAISE FND_API.G_EXC_ERROR;
7258: END IF;
7259:
7260: l_job_header_rec.class_code :=
7261: fnd_profile.value('CSD_DEF_WIP_ACCOUNTING_CLASS');
7262:
7263: IF l_job_header_rec.class_code is NULL THEN
7264: FND_MESSAGE.SET_NAME('CSD','CSD_CLASS_CODE_NULL');
7265: FND_MSG_PUB.ADD;

Line 7276: if fnd_profile.value('CSD_DEFAULT_JOB_STATUS') = 'RELEASED' then

7272: -- and Unreleased Job status,
7273: -- to be passed for WIP Interface Table
7274:
7275:
7276: if fnd_profile.value('CSD_DEFAULT_JOB_STATUS') = 'RELEASED' then
7277: l_job_header_rec.status_type := lc_released_status_code ;
7278:
7279: elsif nvl( fnd_profile.value('CSD_DEFAULT_JOB_STATUS'), 'UNRELEASED' ) = 'UNRELEASED' then
7280: l_job_header_rec.status_type := lc_unreleased_status_code;

Line 7279: elsif nvl( fnd_profile.value('CSD_DEFAULT_JOB_STATUS'), 'UNRELEASED' ) = 'UNRELEASED' then

7275:
7276: if fnd_profile.value('CSD_DEFAULT_JOB_STATUS') = 'RELEASED' then
7277: l_job_header_rec.status_type := lc_released_status_code ;
7278:
7279: elsif nvl( fnd_profile.value('CSD_DEFAULT_JOB_STATUS'), 'UNRELEASED' ) = 'UNRELEASED' then
7280: l_job_header_rec.status_type := lc_unreleased_status_code;
7281: end if;
7282:
7283:

Line 7304: IF ( nvl(fnd_profile.value('CSD_WIP_MRP_NET_QTY'),'N') = 'N' ) THEN

7300: -- Fix for bug# 3109417
7301: -- If the profile CSD: Default WIP MRP Net Qty to Zero is set to
7302: -- null / 'N' then net_quantity = start_quantity else if the
7303: -- profile is set to 'Y' then net_quantity = 0
7304: IF ( nvl(fnd_profile.value('CSD_WIP_MRP_NET_QTY'),'N') = 'N' ) THEN
7305: l_job_header_rec.net_quantity := p_repair_quantity;
7306: ELSIF ( fnd_profile.value('CSD_WIP_MRP_NET_QTY') = 'Y' ) THEN
7307: l_job_header_rec.net_quantity := 0;
7308: END IF;

Line 7306: ELSIF ( fnd_profile.value('CSD_WIP_MRP_NET_QTY') = 'Y' ) THEN

7302: -- null / 'N' then net_quantity = start_quantity else if the
7303: -- profile is set to 'Y' then net_quantity = 0
7304: IF ( nvl(fnd_profile.value('CSD_WIP_MRP_NET_QTY'),'N') = 'N' ) THEN
7305: l_job_header_rec.net_quantity := p_repair_quantity;
7306: ELSIF ( fnd_profile.value('CSD_WIP_MRP_NET_QTY') = 'Y' ) THEN
7307: l_job_header_rec.net_quantity := 0;
7308: END IF;
7309:
7310: -- dbms_output.put_line('Before Loop');

Line 7388: fnd_profile.get('ORG_ID', l_org_id);

7384: END IF;
7385:
7386: --bug#13472453
7387: -- Set the Policy context as required for MOAC Uptake, Bug#4421242
7388: fnd_profile.get('ORG_ID', l_org_id);
7389: mo_global.set_policy_context('S',l_org_id);
7390:
7391: WIP_MASSLOAD_PUB.createOneJob( p_interfaceID => l_job_header_rec.interface_id, --bug 9263438
7392: p_validationLevel => p_validation_level,

Line 7520: l_default_ro_item := nvl(FND_PROFILE.VALUE('CSD_DEFAULT_RO_ITEM_AS_MATERIAL_ON_JOB'), 'N');

7516: END LOOP;
7517:
7518: --*****Below are the code to Default Repair Item as Material on Job**********
7519:
7520: l_default_ro_item := nvl(FND_PROFILE.VALUE('CSD_DEFAULT_RO_ITEM_AS_MATERIAL_ON_JOB'), 'N');
7521: --taklam
7522: if (l_default_ro_item = 'Y') then
7523:
7524: -- swai: bug 7477845/7483291

Line 7546: l_inventory_org_id := fnd_profile.value('CSD_DEF_REP_INV_ORG'); -- swai: bug 10137471

7542: l_quantity,
7543: l_serial_number;
7544: -- l_inventory_org_id; -- swai: bug 10137471
7545: CLOSE c_repair_line_info;
7546: l_inventory_org_id := fnd_profile.value('CSD_DEF_REP_INV_ORG'); -- swai: bug 10137471
7547: l_subinventory := fnd_profile.value('CSD_DEF_HV_SUBINV');
7548:
7549: --Get serial number control code and lot control code
7550: OPEN cur_get_item_attribs (l_inventory_org_id,

Line 7547: l_subinventory := fnd_profile.value('CSD_DEF_HV_SUBINV');

7543: l_serial_number;
7544: -- l_inventory_org_id; -- swai: bug 10137471
7545: CLOSE c_repair_line_info;
7546: l_inventory_org_id := fnd_profile.value('CSD_DEF_REP_INV_ORG'); -- swai: bug 10137471
7547: l_subinventory := fnd_profile.value('CSD_DEF_HV_SUBINV');
7548:
7549: --Get serial number control code and lot control code
7550: OPEN cur_get_item_attribs (l_inventory_org_id,
7551: l_inventory_item_id);

Line 8030: decode ( fnd_profile.value('CSD_DEF_REP_INV_ORG') , WRO.ORGANIZATION_ID ,

8026: MSIK.REVISION_QTY_CONTROL_CODE, -- revision_qty_control_code
8027: MSIK.SERIAL_NUMBER_CONTROL_CODE, -- serial_number_control_code
8028: MSIK.LOT_CONTROL_CODE, -- lot_control_code
8029: nvl ( WRO.supply_subinventory,
8030: decode ( fnd_profile.value('CSD_DEF_REP_INV_ORG') , WRO.ORGANIZATION_ID ,
8031: fnd_profile.value('CSD_DEF_HV_SUBINV') , null ) )
8032: subinventory_code, -- supply_subinventory
8033: WRO.supply_locator_id locator_id, -- supply_locator_id
8034: null transaction_interface_id, -- transaction_interface_id

Line 8031: fnd_profile.value('CSD_DEF_HV_SUBINV') , null ) )

8027: MSIK.SERIAL_NUMBER_CONTROL_CODE, -- serial_number_control_code
8028: MSIK.LOT_CONTROL_CODE, -- lot_control_code
8029: nvl ( WRO.supply_subinventory,
8030: decode ( fnd_profile.value('CSD_DEF_REP_INV_ORG') , WRO.ORGANIZATION_ID ,
8031: fnd_profile.value('CSD_DEF_HV_SUBINV') , null ) )
8032: subinventory_code, -- supply_subinventory
8033: WRO.supply_locator_id locator_id, -- supply_locator_id
8034: null transaction_interface_id, -- transaction_interface_id
8035: null object_version_number, -- object_version_number

Line 8617: l_bom_hr_uom VARCHAR(15) := fnd_profile.value('BOM:HOUR_UOM_CODE'); -- yvchen: bug 13026808

8613: l_res_txn_dtls_tbl RES_TXN_DTLS_TBL_TYPE;
8614: l_existing_res_txn RES_TXN_DTLS_REC_TYPE;
8615: l_clocked_time NUMBER;
8616: l_exists VARCHAR2(10);
8617: l_bom_hr_uom VARCHAR(15) := fnd_profile.value('BOM:HOUR_UOM_CODE'); -- yvchen: bug 13026808
8618:
8619: cursor get_time_clock_entry is
8620: select wip_entity_id,
8621: operation_seq_num,

Line 8780: l_resource_id := fnd_profile.value('CSD_DEF_HV_BOM_RESOURCE');-- get resource from profile value.

8776: l_clock_out_time;
8777: close get_time_clock_entry;
8778:
8779: if (l_resource_id is null) then
8780: l_resource_id := fnd_profile.value('CSD_DEF_HV_BOM_RESOURCE');-- get resource from profile value.
8781: if (l_resource_id is null) then
8782: FND_MESSAGE.SET_NAME('CSD', 'CSD_NO_DEF_HV_BOM_RESOURCE');
8783: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_WARNING_MSG);
8784: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 8841: l_res_txn_dtls_tbl(1).organization_id := nvl(l_existing_res_txn.organization_id, fnd_profile.value('CSD_DEF_REP_INV_ORG'));

8837: l_res_txn_dtls_tbl(1).wip_entity_id := l_wip_entity_id;
8838: l_res_txn_dtls_tbl(1).operation_seq_num := l_operation_seq_num;
8839: l_res_txn_dtls_tbl(1).employee_id := l_employee_id;
8840: l_res_txn_dtls_tbl(1).resource_id := l_resource_id;
8841: l_res_txn_dtls_tbl(1).organization_id := nvl(l_existing_res_txn.organization_id, fnd_profile.value('CSD_DEF_REP_INV_ORG'));
8842: l_res_txn_dtls_tbl(1).object_version_number := nvl(l_existing_res_txn.object_version_number, 1);
8843: l_res_txn_dtls_tbl(1).new_row := nvl(l_existing_res_txn.new_row, 'Y');
8844:
8845: -- save the new/updated resource

Line 8998: where flow_status_code = fnd_profile.value('CSD_COMPLETE_WORK_RO_STATUS');

8994:
8995: cursor c_get_to_flow_status_id is
8996: select flow_status_id
8997: from csd_flow_statuses_b
8998: where flow_status_code = fnd_profile.value('CSD_COMPLETE_WORK_RO_STATUS');
8999:
9000: cursor c_get_repair_status is
9001: select flb.flow_status_code, dra.status
9002: from csd_repairs dra, csd_flow_statuses_b flb

Line 9307: IF (nvl(fnd_profile.value('MRP_DEBUG'),'Y') = 'N') THEN

9303: RETURN;
9304: end if;
9305:
9306: --bug#12316893
9307: IF (nvl(fnd_profile.value('MRP_DEBUG'),'Y') = 'N') THEN
9308: WIP_MASS_LOAD_PROCESSOR.Delete_Completed_Records(l_job_header_rec.group_id);
9309: End If;
9310: --bug#12316893
9311:

Line 10396: l_organization_id := fnd_profile.value('CSD_DEF_REP_INV_ORG');

10392: from csd_repairs dra, csd_repair_types_b rt
10393: where rt.repair_type_id = dra.repair_type_id
10394: and repair_line_id = p_repair_line_id;
10395:
10396: l_organization_id := fnd_profile.value('CSD_DEF_REP_INV_ORG');
10397:
10398:
10399: IF ( lc_event_level >= lc_debug_level ) then
10400: FND_LOG.STRING( lc_event_level,