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 1795: IF fnd_profile.value('CSD_DEF_REP_INV_ORG') = l_transactions_interface_rec.organization_id and

1791: END IF;
1792:
1793: IF l_transactions_interface_rec.subinventory_code is null THEN
1794:
1795: IF fnd_profile.value('CSD_DEF_REP_INV_ORG') = l_transactions_interface_rec.organization_id and
1796: fnd_profile.value('CSD_DEF_HV_CMP_SUBINV') is not null THEN
1797: l_transactions_interface_rec.subinventory_code := fnd_profile.value('CSD_DEF_HV_CMP_SUBINV');
1798: ELSE
1799: x_need_details_flag := 'T'; -- swai: bug 5262927

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

1792:
1793: IF l_transactions_interface_rec.subinventory_code is null THEN
1794:
1795: IF fnd_profile.value('CSD_DEF_REP_INV_ORG') = l_transactions_interface_rec.organization_id and
1796: fnd_profile.value('CSD_DEF_HV_CMP_SUBINV') is not null THEN
1797: l_transactions_interface_rec.subinventory_code := fnd_profile.value('CSD_DEF_HV_CMP_SUBINV');
1798: ELSE
1799: x_need_details_flag := 'T'; -- swai: bug 5262927
1800: END IF;

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

1793: IF l_transactions_interface_rec.subinventory_code is null THEN
1794:
1795: IF fnd_profile.value('CSD_DEF_REP_INV_ORG') = l_transactions_interface_rec.organization_id and
1796: fnd_profile.value('CSD_DEF_HV_CMP_SUBINV') is not null THEN
1797: l_transactions_interface_rec.subinventory_code := fnd_profile.value('CSD_DEF_HV_CMP_SUBINV');
1798: ELSE
1799: x_need_details_flag := 'T'; -- swai: bug 5262927
1800: END IF;
1801: END IF;

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

2657: l_job_details_rec.group_id := l_job_header_rec.group_id;
2658: /* l_job_details_rec.parent_header_id := l_job_header_rec.group_id;
2659:
2660: */
2661: -- l_completion_subinv := nvl( p_completion_subinv, fnd_profile.value('CSD_HV_COMP_SUBINV')) ;
2662: -- l_completion_loc_id : nvl( p_completion_loc_id, fnd_profile.value('CSD_HV_COMP_LOC_ID'));
2663:
2664:
2665:

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

2658: /* l_job_details_rec.parent_header_id := l_job_header_rec.group_id;
2659:
2660: */
2661: -- l_completion_subinv := nvl( p_completion_subinv, fnd_profile.value('CSD_HV_COMP_SUBINV')) ;
2662: -- l_completion_loc_id : nvl( p_completion_loc_id, fnd_profile.value('CSD_HV_COMP_LOC_ID'));
2663:
2664:
2665:
2666: FOR mtl_ctr in p_mtl_txn_dtls_tbl.FIRST.. p_mtl_txn_dtls_tbl.LAST

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

2731: l_transactions_interface_rec.subinventory_code := p_mtl_txn_dtls_tbl(mtl_ctr).supply_subinventory;
2732:
2733: ELSE
2734:
2735: IF fnd_profile.value('CSD_DEF_REP_INV_ORG') = p_mtl_txn_dtls_tbl(mtl_ctr).organization_id and
2736: fnd_profile.value('CSD_DEF_HV_SUBINV') is not null THEN
2737: l_transactions_interface_rec.subinventory_code := fnd_profile.value('CSD_DEF_HV_SUBINV');
2738: ELSE
2739: l_row_need_details_flag := 'T';

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

2732:
2733: ELSE
2734:
2735: IF fnd_profile.value('CSD_DEF_REP_INV_ORG') = p_mtl_txn_dtls_tbl(mtl_ctr).organization_id and
2736: fnd_profile.value('CSD_DEF_HV_SUBINV') is not null THEN
2737: l_transactions_interface_rec.subinventory_code := fnd_profile.value('CSD_DEF_HV_SUBINV');
2738: ELSE
2739: l_row_need_details_flag := 'T';
2740: END IF;

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

2733: ELSE
2734:
2735: IF fnd_profile.value('CSD_DEF_REP_INV_ORG') = p_mtl_txn_dtls_tbl(mtl_ctr).organization_id and
2736: fnd_profile.value('CSD_DEF_HV_SUBINV') is not null THEN
2737: l_transactions_interface_rec.subinventory_code := fnd_profile.value('CSD_DEF_HV_SUBINV');
2738: ELSE
2739: l_row_need_details_flag := 'T';
2740: END IF;
2741: END IF;

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

2795: l_transactions_interface_rec.locator_id := p_mtl_txn_dtls_tbl(mtl_ctr).supply_locator_id;
2796:
2797: ELSE
2798:
2799: /* IF fnd_profile.value('CSD_DEF_REP_INV_ORG') = p_mtl_txn_dtls_tbl(mtl_ctr).organization_id and
2800: fnd_profile.value('CSD_DEF_HV_LOC_ID') is not null THEN
2801:
2802:
2803: l_transactions_interface_rec.locator_id := fnd_profile.value('CSD_DEF_HV_LOC_ID');

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

2796:
2797: ELSE
2798:
2799: /* IF fnd_profile.value('CSD_DEF_REP_INV_ORG') = p_mtl_txn_dtls_tbl(mtl_ctr).organization_id and
2800: fnd_profile.value('CSD_DEF_HV_LOC_ID') is not null THEN
2801:
2802:
2803: l_transactions_interface_rec.locator_id := fnd_profile.value('CSD_DEF_HV_LOC_ID');
2804: dbms_output.put_line( 'l_transactions_interface_rec.locator_id is'

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

2799: /* IF fnd_profile.value('CSD_DEF_REP_INV_ORG') = p_mtl_txn_dtls_tbl(mtl_ctr).organization_id and
2800: fnd_profile.value('CSD_DEF_HV_LOC_ID') is not null THEN
2801:
2802:
2803: l_transactions_interface_rec.locator_id := fnd_profile.value('CSD_DEF_HV_LOC_ID');
2804: dbms_output.put_line( 'l_transactions_interface_rec.locator_id is'
2805: || l_transactions_interface_rec.locator_id );
2806:
2807: ELSE */

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

3775:
3776: l_job_details_rec.substitution_type := lc_substitution_change_type;
3777:
3778:
3779: -- l_job_details_rec.autocharge_type := fnd_profile.value('CSD_HV_ATCHG_TYP');
3780:
3781: -- If autocharge_type is null, throw an error and return;
3782: -- Uncomment following later - once profiles are defined
3783: /* IF l_job_details_rec.autocharge_type is NULL THEN

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

3787: RAISE FND_API.G_EXC_ERROR;
3788: end if;
3789:
3790:
3791: l_job_details_rec.basis_type := fnd_profile.value('CSD_HV_BASIS_TYP');
3792:
3793: -- If basis_type is null, throw an error and return;
3794:
3795: IF l_job_details_rec.basis_type is NULL THEN

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

3798: FND_MSG_PUB.ADD;
3799: RAISE FND_API.G_EXC_ERROR;
3800: end if;
3801:
3802: l_job_details_rec.scheduled_flag := fnd_profile.value('CSD_HV_SCD_FLG');
3803:
3804: -- If scheduled_flag is null, throw an error and return;
3805:
3806: IF l_job_details_rec.scheduled_flag is NULL THEN

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

3809: FND_MSG_PUB.ADD;
3810: RAISE FND_API.G_EXC_ERROR;
3811: end if;
3812:
3813: l_job_details_rec.standard_rate_flag := fnd_profile.value('CSD_HV_STD_FLG');
3814:
3815: -- If standard_rate_flag is null, throw an error and return;
3816:
3817: IF l_job_details_rec.standard_rate_flag is NULL THEN

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

4318: close get_operation_exists;
4319: end if;
4320: if (l_op_exists is null) then
4321: -- create operation, but only if default department is specified
4322: l_op_dtls_tbl(1).department_id := fnd_profile.value('CSD_DEF_HV_OP_DEPT');
4323: if (l_op_dtls_tbl(1).department_id is null) then
4324: -- No operations exist for the job and no default
4325: -- department has been specified, so throw an error.
4326: -- we cannot add the material to operation 1 since

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

5538: x_return_status:=FND_API.G_RET_STS_SUCCESS;
5539:
5540:
5541: l_job_header_rec.organization_id :=
5542: fnd_profile.value('CSD_DEF_REP_INV_ORG');
5543:
5544: -- l_job_header_rec.organization_id := 207;
5545:
5546: IF l_job_header_rec.organization_id is NULL THEN

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

5550: RAISE FND_API.G_EXC_ERROR;
5551: end if;
5552:
5553:
5554: l_job_prefix := fnd_profile.value('CSD_DEFAULT_JOB_PREFIX');
5555:
5556: -- If l_job_prefix is null, throw an error and return;
5557:
5558: -- l_job_prefix := 'SR';

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

5566:
5567:
5568:
5569: l_job_header_rec.class_code :=
5570: fnd_profile.value('CSD_DEF_WIP_ACCOUNTING_CLASS');
5571:
5572: -- l_job_header_rec.class_code := 'Rework';
5573:
5574: IF l_job_header_rec.class_code is NULL THEN

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

5583: -- Assign the WIP Job Status lookup codes corresponding to Released -- and Unreleased Job status,
5584: -- to be passed for WIP Interface Table
5585:
5586:
5587: if fnd_profile.value('CSD_DEFAULT_JOB_STATUS') = 'RELEASED' then
5588:
5589:
5590: l_job_header_rec.status_type := lc_released_status_code ;
5591:

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

5588:
5589:
5590: l_job_header_rec.status_type := lc_released_status_code ;
5591:
5592: elsif nvl( fnd_profile.value('CSD_DEFAULT_JOB_STATUS'), 'UNRELEASED' ) = 'UNRELEASED' then
5593:
5594: l_job_header_rec.status_type := lc_unreleased_status_code;
5595: end if;
5596:

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

5607:
5608: -- If the profile CSD: Default WIP MRP Net Qty to Zero is set to
5609: -- null / 'N' then net_quantity = start_quantity else if the
5610: -- profile is set to 'Y' then net_quantity = 0
5611: IF ( nvl(fnd_profile.value('CSD_WIP_MRP_NET_QTY'),'N') = 'N' ) THEN
5612: l_job_header_rec.net_quantity := p_repair_quantity;
5613: ELSIF ( fnd_profile.value('CSD_WIP_MRP_NET_QTY') = 'Y' ) THEN
5614: l_job_header_rec.net_quantity := 0;
5615: END IF;

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

5609: -- null / 'N' then net_quantity = start_quantity else if the
5610: -- profile is set to 'Y' then net_quantity = 0
5611: IF ( nvl(fnd_profile.value('CSD_WIP_MRP_NET_QTY'),'N') = 'N' ) THEN
5612: l_job_header_rec.net_quantity := p_repair_quantity;
5613: ELSIF ( fnd_profile.value('CSD_WIP_MRP_NET_QTY') = 'Y' ) THEN
5614: l_job_header_rec.net_quantity := 0;
5615: END IF;
5616:
5617:

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

5694:
5695:
5696: --*****Below are the code to Default Repair Item as Material on Job**********
5697:
5698: l_default_ro_item := nvl(FND_PROFILE.VALUE('CSD_DEFAULT_RO_ITEM_AS_MATERIAL_ON_JOB'), 'N');
5699: --taklam
5700: if (l_default_ro_item = 'Y') then
5701: -- swai: bug 7477845/7483291
5702: -- check if there another job existing for this RO. If so, do not default

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

5719: l_quantity,
5720: l_serial_number,
5721: l_inventory_org_id;
5722: CLOSE c_repair_line_info;
5723: l_subinventory := fnd_profile.value('CSD_DEF_HV_SUBINV');
5724:
5725: --Get serial number control code and lot control code
5726: OPEN cur_get_item_attribs (l_inventory_org_id,
5727: l_inventory_item_id);

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

6209: -- Initialize API return status to success
6210: x_return_status:=FND_API.G_RET_STS_SUCCESS;
6211:
6212: l_job_header_rec.organization_id :=
6213: fnd_profile.value('CSD_DEF_REP_INV_ORG');
6214:
6215:
6216: IF l_job_header_rec.organization_id is NULL THEN
6217:

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

6219: FND_MSG_PUB.ADD;
6220: RAISE FND_API.G_EXC_ERROR;
6221: END IF;
6222:
6223: l_job_prefix := fnd_profile.value('CSD_DEFAULT_JOB_PREFIX');
6224:
6225: -- If l_job_prefix is null, throw an error and return;
6226: IF l_job_prefix is NULL THEN
6227: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_PREFIX_NULL');

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

6229: RAISE FND_API.G_EXC_ERROR;
6230: END IF;
6231:
6232: l_job_header_rec.class_code :=
6233: fnd_profile.value('CSD_DEF_WIP_ACCOUNTING_CLASS');
6234:
6235: IF l_job_header_rec.class_code is NULL THEN
6236: FND_MESSAGE.SET_NAME('CSD','CSD_CLASS_CODE_NULL');
6237: FND_MSG_PUB.ADD;

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

6244: -- and Unreleased Job status,
6245: -- to be passed for WIP Interface Table
6246:
6247:
6248: if fnd_profile.value('CSD_DEFAULT_JOB_STATUS') = 'RELEASED' then
6249: l_job_header_rec.status_type := lc_released_status_code ;
6250:
6251: elsif nvl( fnd_profile.value('CSD_DEFAULT_JOB_STATUS'), 'UNRELEASED' ) = 'UNRELEASED' then
6252: l_job_header_rec.status_type := lc_unreleased_status_code;

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

6247:
6248: if fnd_profile.value('CSD_DEFAULT_JOB_STATUS') = 'RELEASED' then
6249: l_job_header_rec.status_type := lc_released_status_code ;
6250:
6251: elsif nvl( fnd_profile.value('CSD_DEFAULT_JOB_STATUS'), 'UNRELEASED' ) = 'UNRELEASED' then
6252: l_job_header_rec.status_type := lc_unreleased_status_code;
6253: end if;
6254:
6255:

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

6261: -- Fix for bug# 3109417
6262: -- If the profile CSD: Default WIP MRP Net Qty to Zero is set to
6263: -- null / 'N' then net_quantity = start_quantity else if the
6264: -- profile is set to 'Y' then net_quantity = 0
6265: IF ( nvl(fnd_profile.value('CSD_WIP_MRP_NET_QTY'),'N') = 'N' ) THEN
6266: l_job_header_rec.net_quantity := p_repair_quantity;
6267: ELSIF ( fnd_profile.value('CSD_WIP_MRP_NET_QTY') = 'Y' ) THEN
6268: l_job_header_rec.net_quantity := 0;
6269: END IF;

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

6263: -- null / 'N' then net_quantity = start_quantity else if the
6264: -- profile is set to 'Y' then net_quantity = 0
6265: IF ( nvl(fnd_profile.value('CSD_WIP_MRP_NET_QTY'),'N') = 'N' ) THEN
6266: l_job_header_rec.net_quantity := p_repair_quantity;
6267: ELSIF ( fnd_profile.value('CSD_WIP_MRP_NET_QTY') = 'Y' ) THEN
6268: l_job_header_rec.net_quantity := 0;
6269: END IF;
6270:
6271: -- dbms_output.put_line('Before Loop');

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

6361:
6362:
6363: --*****Below are the code to Default Repair Item as Material on Job**********
6364:
6365: l_default_ro_item := nvl(FND_PROFILE.VALUE('CSD_DEFAULT_RO_ITEM_AS_MATERIAL_ON_JOB'), 'N');
6366: --taklam
6367: if (l_default_ro_item = 'Y') then
6368:
6369: -- swai: bug 7477845/7483291

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

6387: l_quantity,
6388: l_serial_number,
6389: l_inventory_org_id;
6390: CLOSE c_repair_line_info;
6391: l_subinventory := fnd_profile.value('CSD_DEF_HV_SUBINV');
6392:
6393: --Get serial number control code and lot control code
6394: OPEN cur_get_item_attribs (l_inventory_org_id,
6395: l_inventory_item_id);