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

Line 396: IF (FND_PROFILE.VALUE('AHL_OSP_OE_MIXED_ID') IS NULL OR FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID') = '') THEN

392: END IF;
393:
394: -- Start processing
395:
396: IF (FND_PROFILE.VALUE('AHL_OSP_OE_MIXED_ID') IS NULL OR FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID') = '') THEN
397: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
398: --FND_MESSAGE.SET_TOKEN('PROFILE', 'AHL: OE Mixed Order Type ID');
399: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_OSP_OE_MIXED_ID'));
400: FND_MSG_PUB.ADD;

Line 407: IF (FND_PROFILE.VALUE('AHL_OSP_OE_SHIP_ONLY_ID') IS NULL OR FND_PROFILE.VALUE('AHL_OSP_OE_SHIP_ONLY_ID') = '' ) THEN

403: END IF;
404: RAISE Fnd_Api.g_exc_error;
405: END IF;
406:
407: IF (FND_PROFILE.VALUE('AHL_OSP_OE_SHIP_ONLY_ID') IS NULL OR FND_PROFILE.VALUE('AHL_OSP_OE_SHIP_ONLY_ID') = '' ) THEN
408: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
409: --FND_MESSAGE.SET_TOKEN('PROFILE', 'AHL: OE Ship Only Line Type ID');
410: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_OSP_OE_SHIP_ONLY_ID'));
411: FND_MSG_PUB.ADD;

Line 418: IF (FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID') IS NULL OR FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID') = '') THEN

414: END IF;
415: RAISE Fnd_Api.g_exc_error;
416: END IF;
417:
418: IF (FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID') IS NULL OR FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID') = '') THEN
419: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
420: --FND_MESSAGE.SET_TOKEN('PROFILE', 'AHL: OE Return Line Type ID');
421: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_OSP_OE_RETURN_ID'));
422: FND_MSG_PUB.ADD;

Line 613: IF (p_x_lines_tbl(i).line_type_id = FND_PROFILE.VALUE('AHL_OSP_OE_SHIP_ONLY_ID')) THEN

609: FOR i IN p_x_lines_tbl.FIRST..p_x_lines_tbl.LAST LOOP
610: IF (p_x_lines_tbl(i).operation = 'C') THEN
611: -- Update the line_id
612: p_x_lines_tbl(i).line_id := x_line_tbl(i).line_id;
613: IF (p_x_lines_tbl(i).line_type_id = FND_PROFILE.VALUE('AHL_OSP_OE_SHIP_ONLY_ID')) THEN
614: l_line_type := 'ORDER';
615: ELSIF (p_x_lines_tbl(i).line_type_id = FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID')) THEN
616: l_line_type := 'RETURN';
617: END IF;

Line 615: ELSIF (p_x_lines_tbl(i).line_type_id = FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID')) THEN

611: -- Update the line_id
612: p_x_lines_tbl(i).line_id := x_line_tbl(i).line_id;
613: IF (p_x_lines_tbl(i).line_type_id = FND_PROFILE.VALUE('AHL_OSP_OE_SHIP_ONLY_ID')) THEN
614: l_line_type := 'ORDER';
615: ELSIF (p_x_lines_tbl(i).line_type_id = FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID')) THEN
616: l_line_type := 'RETURN';
617: END IF;
618:
619: IF p_x_lines_tbl(i).csi_item_instance_id IS NOT NULL THEN

Line 658: IF (p_x_lines_tbl(i).line_type_id = FND_PROFILE.VALUE('AHL_OSP_OE_SHIP_ONLY_ID')) THEN

654:
655: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
656: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'About to call Update_OSP_Order_Lines');
657: END IF;
658: IF (p_x_lines_tbl(i).line_type_id = FND_PROFILE.VALUE('AHL_OSP_OE_SHIP_ONLY_ID')) THEN
659: Update_OSP_Order_Lines(
660: p_osp_order_id => p_x_lines_tbl(i).osp_order_id,
661: p_item_instance_id => p_x_lines_tbl(i).csi_item_instance_id,
662: p_oe_ship_line_id => p_x_lines_tbl(i).line_id,

Line 664: ELSIF (p_x_lines_tbl(i).line_type_id = FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID')) THEN

660: p_osp_order_id => p_x_lines_tbl(i).osp_order_id,
661: p_item_instance_id => p_x_lines_tbl(i).csi_item_instance_id,
662: p_oe_ship_line_id => p_x_lines_tbl(i).line_id,
663: p_oe_return_line_id => FND_API.G_MISS_NUM);
664: ELSIF (p_x_lines_tbl(i).line_type_id = FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID')) THEN
665: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
666: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Calling Update_OSP_Order_Lines with p_oe_return_line_id = ' || p_x_lines_tbl(i).line_id );
667: END IF;
668: Update_OSP_Order_Lines(

Line 681: IF (p_x_lines_tbl(i).line_type_id = FND_PROFILE.VALUE('AHL_OSP_OE_SHIP_ONLY_ID')) THEN

677: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
678: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'About to call Update_OSP_Order_Lines');
679: END IF;
680: IF p_x_lines_tbl(i).osp_line_id IS NOT NULL THEN
681: IF (p_x_lines_tbl(i).line_type_id = FND_PROFILE.VALUE('AHL_OSP_OE_SHIP_ONLY_ID')) THEN
682: Update_OSP_Order_Lines(
683: p_osp_order_id => p_x_lines_tbl(i).osp_order_id,
684: p_osp_line_id => p_x_lines_tbl(i).osp_line_id,
685: p_oe_ship_line_id => p_x_lines_tbl(i).line_id,

Line 687: ELSIF (p_x_lines_tbl(i).line_type_id = FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID')) THEN

683: p_osp_order_id => p_x_lines_tbl(i).osp_order_id,
684: p_osp_line_id => p_x_lines_tbl(i).osp_line_id,
685: p_oe_ship_line_id => p_x_lines_tbl(i).line_id,
686: p_oe_return_line_id => FND_API.G_MISS_NUM);
687: ELSIF (p_x_lines_tbl(i).line_type_id = FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID')) THEN
688: --mpothuku modified on 14-Sep-2007 to fix the Bug 6398921
689: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
690: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'p_x_lines_tbl(i).order_type :' ||p_x_lines_tbl(i).order_type);
691: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'p_x_lines_tbl(i).line_id :' ||p_x_lines_tbl(i).line_id);

Line 1513: FROM fnd_profile_options_vl

1509: RETURN VARCHAR2
1510: IS
1511: CURSOR get_user_prf_opt_name_csr(c_prf_opt_name IN VARCHAR2) IS
1512: SELECT USER_PROFILE_OPTION_NAME
1513: FROM fnd_profile_options_vl
1514: WHERE profile_option_name = c_prf_opt_name;
1515:
1516: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.get_user_profile_option_name';
1517: l_usr_prf_opt_name VARCHAR2(240);

Line 1575: -- AND def.operating_unit = FND_PROFILE.VALUE('DEFAULT_ORG_ID')

1571: SELECT org.organization_id
1572: FROM OE_SHIP_FROM_ORGS_V org, inv_organization_info_v def
1573: WHERE org.organization_id = def.organization_id
1574: -- Changed by jaramana on Sep 9, 2005 for MOAC Uptake
1575: -- AND def.operating_unit = FND_PROFILE.VALUE('DEFAULT_ORG_ID')
1576: AND def.operating_unit = MO_GLOBAL.get_current_org_id()
1577: AND org.name = p_name;
1578:
1579: CURSOR ahl_sold_to_orgs_csr(p_cust_number IN VARCHAR2) IS

Line 1873: x_header_rec.shipment_priority_code := FND_PROFILE.VALUE('AHL_OSP_OE_SHIPMENT_PRIORITY');

1869: x_header_rec.freight_terms_code := FND_API.G_MISS_CHAR;
1870: x_header_rec.freight_carrier_code := FND_API.G_MISS_CHAR;
1871: x_header_rec.fob_point_code := FND_API.G_MISS_CHAR;
1872: -- Get this from the profile
1873: x_header_rec.shipment_priority_code := FND_PROFILE.VALUE('AHL_OSP_OE_SHIPMENT_PRIORITY');
1874: END IF;
1875:
1876: /*
1877: -- JR: Coded on 8/19/2003 as fix for Bug 3095543

Line 1912: x_header_rec.tax_exempt_reason_code := FND_PROFILE.VALUE('AHL_OSP_TAX_EXEMPT_REASON');

1908: END IF;
1909: IF x_header_rec.tax_exempt_flag IS NULL THEN
1910: IF (p_header_rec.operation = 'C') THEN
1911: x_header_rec.tax_exempt_flag := 'E'; -- Default is Exempted.
1912: x_header_rec.tax_exempt_reason_code := FND_PROFILE.VALUE('AHL_OSP_TAX_EXEMPT_REASON');
1913: END IF;
1914: END IF;
1915: x_header_rec.shipping_instructions := p_header_rec.shipping_instructions;
1916: x_header_rec.packing_instructions := p_header_rec.packing_instructions;

Line 1930: x_header_rec.order_type_id := FND_PROFILE.VALUE('AHL_OSP_OE_MIXED_ID');

1926: CLOSE ahl_trxn_curr_code_csr;
1927:
1928: --Set the ORDER_TYPE to 'MIXED'
1929: IF (p_header_rec.operation = 'C') THEN
1930: x_header_rec.order_type_id := FND_PROFILE.VALUE('AHL_OSP_OE_MIXED_ID');
1931:
1932: x_header_rec.ordered_date := sysdate;
1933: x_header_rec.pricing_date := sysdate;
1934: END IF;

Line 2660: IF (FND_PROFILE.VALUE('AHL_VENDOR_SERVICE_DURATION') IS NULL OR FND_PROFILE.VALUE('AHL_VENDOR_SERVICE_DURATION') = '') THEN

2656: END IF;
2657:
2658: IF l_service_duration is null THEN
2659: -- Check if the Default Duration Profile has been Set
2660: IF (FND_PROFILE.VALUE('AHL_VENDOR_SERVICE_DURATION') IS NULL OR FND_PROFILE.VALUE('AHL_VENDOR_SERVICE_DURATION') = '') THEN
2661: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
2662: --FND_MESSAGE.SET_TOKEN('PROFILE', 'AHL: Vendor Service Duration');
2663: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_VENDOR_SERVICE_DURATION'));
2664: FND_MSG_PUB.ADD;

Line 2671: l_service_duration := FND_PROFILE.VALUE('AHL_VENDOR_SERVICE_DURATION');

2667: END IF;
2668: RAISE Fnd_Api.g_exc_error;
2669: END IF;
2670:
2671: l_service_duration := FND_PROFILE.VALUE('AHL_VENDOR_SERVICE_DURATION');
2672:
2673: END IF;
2674: -- yazhou 31-Jul-2006 ends
2675:

Line 2734: ((p_x_line_tbl(i).line_type_id = FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID')) AND

2730: -- Bug fix#5189285
2731:
2732: -- For Exchange Order Return lines, use the exchange instance id instead
2733: IF (p_x_line_tbl(i).operation <> 'D') AND
2734: ((p_x_line_tbl(i).line_type_id = FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID')) AND
2735: (p_x_line_tbl(i).order_type = AHL_OSP_ORDERS_PVT.G_OSP_ORDER_TYPE_EXCHANGE)) THEN
2736:
2737: -- yazhou 26-Apr-2006 ends
2738: /*

Line 2908: IF (p_x_line_tbl(i).line_type_id = FND_PROFILE.VALUE('AHL_OSP_OE_SHIP_ONLY_ID')) THEN

2904: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2905: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Not a Shipment Delete Operation');
2906: END IF;
2907:
2908: IF (p_x_line_tbl(i).line_type_id = FND_PROFILE.VALUE('AHL_OSP_OE_SHIP_ONLY_ID')) THEN
2909: -- Ship-Only Line
2910: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2911: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Processing a Ship-Only Line');
2912: END IF;

Line 2997: ELSIF (p_x_line_tbl(i).line_type_id = FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID')) THEN

2993: END IF; -- Return Date < Ship Date
2994: END IF; -- Borrow or Exchange or Other
2995: END IF; -- Return Date is not null
2996: CLOSE ahl_oe_schedule_date_csr;
2997: ELSIF (p_x_line_tbl(i).line_type_id = FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID')) THEN
2998: -- Return Line
2999: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3000: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Processing a Return Line');
3001: END IF;

Line 3018: p_x_line_tbl(i).return_reason_code := FND_PROFILE.VALUE('AHL_OSP_OE_LINE_RET_REASON_CODE');

3014:
3015: END IF; -- If Return Date is not Set
3016:
3017: IF p_x_line_tbl(i).return_reason_code IS NULL THEN
3018: p_x_line_tbl(i).return_reason_code := FND_PROFILE.VALUE('AHL_OSP_OE_LINE_RET_REASON_CODE');
3019: END IF;
3020:
3021: -- For Create only, check that no previous oe return line exists for this job
3022: --yazhou 06-Jun-2006 starts

Line 3128: ((p_x_line_tbl(i).line_type_id = FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID')) AND

3124: -- Bug fix#5189285
3125:
3126: -- For Exchange Order Return lines, use the exchange instance id instead
3127: IF (p_x_line_tbl(i).operation <> 'D') AND
3128: ((p_x_line_tbl(i).line_type_id = FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID')) AND
3129: (p_x_line_tbl(i).order_type = AHL_OSP_ORDERS_PVT.G_OSP_ORDER_TYPE_EXCHANGE)) THEN
3130:
3131: -- yazhou 26-Apr-2006 ends
3132:

Line 3303: IF (p_x_line_tbl(i).line_type_id = FND_PROFILE.VALUE('AHL_OSP_OE_SHIP_ONLY_ID')) THEN

3299: IF (p_x_line_tbl(i).operation <> 'D') THEN
3300: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3301: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Not a Shipment Delete Operation');
3302: END IF;
3303: IF (p_x_line_tbl(i).line_type_id = FND_PROFILE.VALUE('AHL_OSP_OE_SHIP_ONLY_ID')) THEN
3304: -- Ship-Only Line
3305: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3306: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Processing a Ship-Only Line');
3307: END IF;

Line 3407: ELSIF (p_x_line_tbl(i).line_type_id = FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID')) THEN

3403: END IF; -- Return Date < Ship Date
3404: END IF; -- Borrow or Exchange or Other
3405: END IF; -- Return Date is not null
3406: CLOSE ahl_oe_Inv_schedule_date_csr;
3407: ELSIF (p_x_line_tbl(i).line_type_id = FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID')) THEN
3408: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3409: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Processing a Return Line');
3410: END IF;
3411: IF (p_x_line_tbl(i).schedule_ship_date IS NULL OR p_x_line_tbl(i).schedule_ship_date = FND_API.G_MISS_DATE) THEN

Line 3427: p_x_line_tbl(i).return_reason_code := FND_PROFILE.VALUE('AHL_OSP_OE_LINE_RET_REASON_CODE');

3423:
3424: END IF; -- If Return Date is not Set
3425:
3426: IF p_x_line_tbl(i).return_reason_code IS NULL THEN
3427: p_x_line_tbl(i).return_reason_code := FND_PROFILE.VALUE('AHL_OSP_OE_LINE_RET_REASON_CODE');
3428: END IF;
3429:
3430: --For Create only, check that no previous oe return line exists for the Item
3431: --yazhou 06-Jun-2006 starts

Line 3517: IF (p_x_line_tbl(i).line_type_id = FND_PROFILE.VALUE('AHL_OSP_OE_SHIP_ONLY_ID')) THEN

3513: Fnd_Msg_Pub.ADD;
3514: RAISE Fnd_Api.g_exc_error;
3515: END IF;
3516:
3517: IF (p_x_line_tbl(i).line_type_id = FND_PROFILE.VALUE('AHL_OSP_OE_SHIP_ONLY_ID')) THEN
3518: p_x_line_tbl(i).line_type := 'SHIP';
3519: ELSIF (p_x_line_tbl(i).line_type_id = FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID')) THEN
3520: p_x_line_tbl(i).line_type := 'RETURN';
3521: ELSE

Line 3519: ELSIF (p_x_line_tbl(i).line_type_id = FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID')) THEN

3515: END IF;
3516:
3517: IF (p_x_line_tbl(i).line_type_id = FND_PROFILE.VALUE('AHL_OSP_OE_SHIP_ONLY_ID')) THEN
3518: p_x_line_tbl(i).line_type := 'SHIP';
3519: ELSIF (p_x_line_tbl(i).line_type_id = FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID')) THEN
3520: p_x_line_tbl(i).line_type := 'RETURN';
3521: ELSE
3522: Fnd_Message.set_name('AHL', 'AHL_OSP_LINE_TYPE_NULL');
3523: Fnd_Msg_Pub.ADD;

Line 3603: p_x_line_tbl(l_index).line_type_id := FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID');

3599: p_x_line_tbl(l_index).line_id := NULL;
3600: p_x_line_tbl(l_index).line_number := NULL;
3601: p_x_line_tbl(l_index).header_id := l_osp_header_det.OE_HEADER_ID;
3602: p_x_line_tbl(l_index).order_type := l_osp_header_det.ORDER_TYPE_CODE;
3603: p_x_line_tbl(l_index).line_type_id := FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID');
3604: p_x_line_tbl(l_index).line_type := 'RETURN';
3605: p_x_line_tbl(l_index).operation := 'C';
3606: /* NOTE: Exchange Order is handled in a special way below
3607: after the ship-only lines are created*/

Line 3620: p_x_line_tbl(l_index).return_reason_code := FND_PROFILE.VALUE('AHL_OSP_OE_LINE_RET_REASON_CODE');

3616: p_x_line_tbl(l_index).ordered_quantity := I.INVENTORY_ITEM_QUANTITY;
3617: p_x_line_tbl(l_index).order_quantity_uom := I.INVENTORY_ITEM_UOM;
3618:
3619: -- Default the Return Reason from the Profile
3620: p_x_line_tbl(l_index).return_reason_code := FND_PROFILE.VALUE('AHL_OSP_OE_LINE_RET_REASON_CODE');
3621: IF p_x_line_tbl(l_index).return_reason_code IS NULL THEN
3622: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
3623: -- @@@@@ jaramana June 4, 2004: May become a translation issue
3624: --FND_MESSAGE.SET_TOKEN('PROFILE', 'AHL: OM Line Return Reason');

Line 3648: IF (FND_PROFILE.VALUE('AHL_VENDOR_SERVICE_DURATION') IS NULL OR FND_PROFILE.VALUE('AHL_VENDOR_SERVICE_DURATION') = '') THEN

3644: END IF;
3645:
3646: IF l_service_duration is null THEN
3647: -- Check if the Default Duration Profile has been Set
3648: IF (FND_PROFILE.VALUE('AHL_VENDOR_SERVICE_DURATION') IS NULL OR FND_PROFILE.VALUE('AHL_VENDOR_SERVICE_DURATION') = '') THEN
3649: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');
3650: --FND_MESSAGE.SET_TOKEN('PROFILE', 'AHL: Vendor Service Duration');
3651: FND_MESSAGE.SET_TOKEN('PROFILE', get_user_profile_option_name('AHL_VENDOR_SERVICE_DURATION'));
3652: FND_MSG_PUB.ADD;

Line 3659: l_service_duration := FND_PROFILE.VALUE('AHL_VENDOR_SERVICE_DURATION');

3655: END IF;
3656: RAISE Fnd_Api.g_exc_error;
3657: END IF;
3658:
3659: l_service_duration := FND_PROFILE.VALUE('AHL_VENDOR_SERVICE_DURATION');
3660:
3661: END IF;
3662:
3663:

Line 3778: p_x_line_tbl(l_ship_index).line_type_id:=FND_PROFILE.VALUE('AHL_OSP_OE_SHIP_ONLY_ID');

3774: END IF;
3775:
3776: -- Copy all the details about from the Return Line
3777: p_x_line_tbl(l_ship_index) := p_x_line_tbl(l_index);
3778: p_x_line_tbl(l_ship_index).line_type_id:=FND_PROFILE.VALUE('AHL_OSP_OE_SHIP_ONLY_ID');
3779: p_x_line_tbl(l_ship_index).line_type:='SHIP';
3780: p_x_line_tbl(l_ship_index).return_reason_code:=NULL;
3781:
3782: IF p_x_line_tbl(l_ship_index).order_type = 'BORROW' THEN

Line 3833: p_x_line_tbl(l_index).line_type_id:=FND_PROFILE.VALUE('AHL_OSP_OE_SHIP_ONLY_ID');

3829: FOR I in p_x_line_tbl.first..p_x_line_tbl.last LOOP
3830: l_index := l_index + 1;
3831: -- Copy all the details about from the Return Line
3832: p_x_line_tbl(l_index) := p_x_line_tbl(I);
3833: p_x_line_tbl(l_index).line_type_id:=FND_PROFILE.VALUE('AHL_OSP_OE_SHIP_ONLY_ID');
3834: p_x_line_tbl(l_index).line_type:='SHIP';
3835: p_x_line_tbl(l_index).return_reason_code:=NULL;
3836:
3837: -- yazhou 31-Jul-2006 starts

Line 3923: -- AND def.operating_unit = FND_PROFILE.VALUE('DEFAULT_ORG_ID')

3919: SELECT org.organization_id
3920: FROM OE_SHIP_FROM_ORGS_V org, inv_organization_info_v def
3921: WHERE org.organization_id = def.organization_id
3922: -- Changed by jaramana on Sep 9, 2005 for MOAC Uptake
3923: -- AND def.operating_unit = FND_PROFILE.VALUE('DEFAULT_ORG_ID')
3924: AND def.operating_unit = MO_GLOBAL.get_current_org_id()
3925: AND org.name = p_name;
3926:
3927: CURSOR ahl_oe_lot_serial_id (p_oe_line_id IN NUMBER) IS

Line 4100: IF (p_line_tbl(i).line_type_id = FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID') AND

4096: l_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
4097: END IF;
4098:
4099: -- NEED TO FIX: 'Return'
4100: IF (p_line_tbl(i).line_type_id = FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID') AND
4101: p_line_tbl(i).serial_number IS NOT NULL AND
4102: p_line_tbl(i).serial_number <> FND_API.G_MISS_CHAR) THEN
4103: IF (p_line_tbl(i).operation = 'C') THEN
4104: l_lot_serial_rec := OE_ORDER_PUB.G_MISS_LOT_SERIAL_REC;

Line 5044: l_subtxn_id := FND_PROFILE.VALUE('AHL_OSP_IB_SUBTXN_EXC_SHIP');

5040:
5041: -- get csi transaction ID for sub type based on OSP Order type
5042: IF p_OSP_order_type = AHL_OSP_ORDERS_PVT.G_OSP_ORDER_TYPE_EXCHANGE THEN
5043: --l_subtxn_name := G_SUBTXN_EXC_ORDER; --for ER 4746426
5044: l_subtxn_id := FND_PROFILE.VALUE('AHL_OSP_IB_SUBTXN_EXC_SHIP');
5045: IF l_subtxn_id IS NULL THEN
5046: --FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_SUBTXN_NOTFOUND');
5047: --FND_MESSAGE.Set_Token('TYPE','Exchange Order Ship');
5048: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');

Line 5108: l_subtxn_id := FND_PROFILE.VALUE('AHL_OSP_IB_SUBTXN_SER_SHIP');

5104: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, ' RELATIONSHIP_TYPE_CODE = ' || l_party_account_rec.RELATIONSHIP_TYPE_CODE);
5105: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, ' TXN_PARTY_DETAILS_INDEX = ' || l_party_account_rec.TXN_PARTY_DETAILS_INDEX);
5106: END IF;
5107: ELSIF p_OSP_order_type = AHL_OSP_ORDERS_PVT.G_OSP_ORDER_TYPE_SERVICE THEN
5108: l_subtxn_id := FND_PROFILE.VALUE('AHL_OSP_IB_SUBTXN_SER_SHIP');
5109: IF l_subtxn_id IS NULL THEN
5110: --FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_SUBTXN_NOTFOUND');
5111: --FND_MESSAGE.Set_Token('TYPE','Service Order Ship');
5112: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');

Line 5120: l_subtxn_id := FND_PROFILE.VALUE('AHL_OSP_IB_SUBTXN_BOR_SHIP');

5116: RETURN;
5117: END IF;
5118: ELSIF p_OSP_order_type = AHL_OSP_ORDERS_PVT.G_OSP_ORDER_TYPE_BORROW THEN
5119: --l_subtxn_name := G_SUBTXN_ORDER;
5120: l_subtxn_id := FND_PROFILE.VALUE('AHL_OSP_IB_SUBTXN_BOR_SHIP');
5121: IF l_subtxn_id IS NULL THEN
5122: --FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_SUBTXN_NOTFOUND');
5123: --FND_MESSAGE.Set_Token('TYPE','Borrow Order Ship');
5124: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');

Line 5163: l_subtxn_id := fnd_profile.VALUE('AHL_OSP_IB_SUBTXN_EXC_RETURN');

5159:
5160: -- get csi transaction ID for sub type based on OSP Order type
5161: IF p_OSP_order_type = AHL_OSP_ORDERS_PVT.G_OSP_ORDER_TYPE_EXCHANGE THEN
5162: --l_subtxn_name := G_SUBTXN_EXC_RETURN; --for ER 4746426
5163: l_subtxn_id := fnd_profile.VALUE('AHL_OSP_IB_SUBTXN_EXC_RETURN');
5164: IF l_subtxn_id IS NULL THEN
5165: --FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_SUBTXN_NOTFOUND');
5166: --FND_MESSAGE.Set_Token('TYPE','Exchange Order Return');
5167: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');

Line 5220: l_subtxn_id := FND_PROFILE.VALUE('AHL_OSP_IB_SUBTXN_SER_RETURN');

5216: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, ' TXN_LINE_DETAILS_INDEX = ' || l_party_dtl_rec.TXN_LINE_DETAILS_INDEX);
5217: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, ' INSTANCE_PARTY_ID = ' || l_party_dtl_rec.INSTANCE_PARTY_ID);
5218: END IF;
5219: ELSIF p_OSP_order_type = AHL_OSP_ORDERS_PVT.G_OSP_ORDER_TYPE_SERVICE THEN
5220: l_subtxn_id := FND_PROFILE.VALUE('AHL_OSP_IB_SUBTXN_SER_RETURN');
5221: IF l_subtxn_id IS NULL THEN
5222: --FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_SUBTXN_NOTFOUND');
5223: --FND_MESSAGE.Set_Token('TYPE','Service Order Return');
5224: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');

Line 5231: l_subtxn_id := FND_PROFILE.VALUE('AHL_OSP_IB_SUBTXN_BOR_RETURN');

5227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5228: RETURN;
5229: END IF;
5230: ELSIF p_OSP_order_type = AHL_OSP_ORDERS_PVT.G_OSP_ORDER_TYPE_BORROW THEN
5231: l_subtxn_id := FND_PROFILE.VALUE('AHL_OSP_IB_SUBTXN_BOR_RETURN');
5232: IF l_subtxn_id IS NULL THEN
5233: --FND_MESSAGE.Set_Name('AHL','AHL_OSP_IB_SUBTXN_NOTFOUND');
5234: --FND_MESSAGE.Set_Token('TYPE','Borrow Order Return');
5235: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PROFILE_NULL');