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.WSMPUTIL dependencies on STANDARD

Line 30: | PROCEDURE OPERATION_IS_STANDARD_REPEATS - overridden

Line 734: x_standard_operation_id NUMBER;

730: l_stmt_num NUMBER;
731: l_operation_seq_id NUMBER;
732:
733: -- BA NSO-WLT
734: x_standard_operation_id NUMBER;
735: not_std_op EXCEPTION;
736: -- EA NSO-WLT
737:
738: BEGIN

Line 768: x_standard_operation_id := 0;

764: --EA: CZH.I_OED-2
765:
766: IF (l_operation_seq_id IS NOT NULL) THEN
767: -- BA NSO-WLT
768: x_standard_operation_id := 0;
769: l_stmt_num := 15;
770:
771: SELECT nvl(standard_operation_id, -999)
772: INTO x_standard_operation_id

Line 771: SELECT nvl(standard_operation_id, -999)

767: -- BA NSO-WLT
768: x_standard_operation_id := 0;
769: l_stmt_num := 15;
770:
771: SELECT nvl(standard_operation_id, -999)
772: INTO x_standard_operation_id
773: FROM bom_operation_sequences
774: WHERE operation_sequence_id = l_operation_seq_id;
775:

Line 772: INTO x_standard_operation_id

768: x_standard_operation_id := 0;
769: l_stmt_num := 15;
770:
771: SELECT nvl(standard_operation_id, -999)
772: INTO x_standard_operation_id
773: FROM bom_operation_sequences
774: WHERE operation_sequence_id = l_operation_seq_id;
775:
776: IF x_standard_operation_id <> -999 then

Line 776: IF x_standard_operation_id <> -999 then

772: INTO x_standard_operation_id
773: FROM bom_operation_sequences
774: WHERE operation_sequence_id = l_operation_seq_id;
775:
776: IF x_standard_operation_id <> -999 then
777: -- EA NSO-WLT
778:
779: l_stmt_num := 20;
780: --MES replacing WSM_OPERATION_DETAILS with BOM_STANDARD_OPERATIONS

Line 780: --MES replacing WSM_OPERATION_DETAILS with BOM_STANDARD_OPERATIONS

776: IF x_standard_operation_id <> -999 then
777: -- EA NSO-WLT
778:
779: l_stmt_num := 20;
780: --MES replacing WSM_OPERATION_DETAILS with BOM_STANDARD_OPERATIONS
781: /*
782: -- BA NSO-WLT
783: SELECT WOD.SECONDARY_INVENTORY_NAME,
784: WOD.INVENTORY_LOCATION_ID

Line 791: AND nvl(WOD.standard_operation_id, -999) = nvl(BOS.standard_operation_id, -999)

787: FROM WSM_OPERATION_DETAILS WOD,
788: BOM_OPERATION_SEQUENCES BOS
789: WHERE BOS.operation_sequence_id = l_operation_seq_id
790: AND BOS.routing_sequence_id = p_routing_sequence_id
791: AND nvl(WOD.standard_operation_id, -999) = nvl(BOS.standard_operation_id, -999)
792: AND WOD.organization_id = p_organization_id;
793: -- EA NSO-WLT
794: */
795: -- BA NSO-WLT

Line 800: FROM BOM_STANDARD_OPERATIONS BSO,

796: SELECT BSO.DEFAULT_SUBINVENTORY,
797: BSO.DEFAULT_LOCATOR_ID
798: INTO x_subinventory_code,
799: x_locator_id
800: FROM BOM_STANDARD_OPERATIONS BSO,
801: BOM_OPERATION_SEQUENCES BOS
802: WHERE BOS.operation_sequence_id = l_operation_seq_id
803: AND BOS.routing_sequence_id = p_routing_sequence_id
804: AND nvl(BSO.standard_operation_id, -999) = nvl(BOS.standard_operation_id, -999)

Line 804: AND nvl(BSO.standard_operation_id, -999) = nvl(BOS.standard_operation_id, -999)

800: FROM BOM_STANDARD_OPERATIONS BSO,
801: BOM_OPERATION_SEQUENCES BOS
802: WHERE BOS.operation_sequence_id = l_operation_seq_id
803: AND BOS.routing_sequence_id = p_routing_sequence_id
804: AND nvl(BSO.standard_operation_id, -999) = nvl(BOS.standard_operation_id, -999)
805: AND BSO.organization_id = p_organization_id;
806: -- EA NSO-WLT
807:
808: IF (SQL%NOTFOUND) THEN

Line 1117: x_standard_operation_id NUMBER;

1113: x_err_code OUT NOCOPY NUMBER,
1114: x_err_msg OUT NOCOPY VARCHAR2 ) IS
1115:
1116:
1117: x_standard_operation_id NUMBER;
1118: no_sub EXCEPTION;
1119:
1120: -- BA NSO-WLT: Non-Standard Operations Project code change by Sadiq.
1121: not_std_op EXCEPTION;

Line 1120: -- BA NSO-WLT: Non-Standard Operations Project code change by Sadiq.

1116:
1117: x_standard_operation_id NUMBER;
1118: no_sub EXCEPTION;
1119:
1120: -- BA NSO-WLT: Non-Standard Operations Project code change by Sadiq.
1121: not_std_op EXCEPTION;
1122: -- EA NSO-WLT
1123:
1124: BEGIN

Line 1130: SELECT nvl(standard_operation_id, '-999')

1126: x_completion_subinventory := NULL;
1127: x_inventory_location_id := 0;
1128:
1129: -- BA NSO-WLT
1130: SELECT nvl(standard_operation_id, '-999')
1131: INTO x_standard_operation_id
1132: FROM bom_operation_sequences
1133: WHERE operation_sequence_id = p_end_id;
1134:

Line 1131: INTO x_standard_operation_id

1127: x_inventory_location_id := 0;
1128:
1129: -- BA NSO-WLT
1130: SELECT nvl(standard_operation_id, '-999')
1131: INTO x_standard_operation_id
1132: FROM bom_operation_sequences
1133: WHERE operation_sequence_id = p_end_id;
1134:
1135: IF x_standard_operation_id <> -999 then

Line 1135: IF x_standard_operation_id <> -999 then

1131: INTO x_standard_operation_id
1132: FROM bom_operation_sequences
1133: WHERE operation_sequence_id = p_end_id;
1134:
1135: IF x_standard_operation_id <> -999 then
1136: -- EA NSO-WLT
1137: --MES replacing WSM_OPERATION_DETAILS with BOM_STANDARD_OPERATIONS
1138: /*
1139: SELECT secondary_inventory_name, inventory_location_id

Line 1137: --MES replacing WSM_OPERATION_DETAILS with BOM_STANDARD_OPERATIONS

1133: WHERE operation_sequence_id = p_end_id;
1134:
1135: IF x_standard_operation_id <> -999 then
1136: -- EA NSO-WLT
1137: --MES replacing WSM_OPERATION_DETAILS with BOM_STANDARD_OPERATIONS
1138: /*
1139: SELECT secondary_inventory_name, inventory_location_id
1140: INTO x_completion_subinventory,x_inventory_location_id
1141: FROM wsm_operation_details

Line 1142: WHERE standard_operation_id = x_standard_operation_id

1138: /*
1139: SELECT secondary_inventory_name, inventory_location_id
1140: INTO x_completion_subinventory,x_inventory_location_id
1141: FROM wsm_operation_details
1142: WHERE standard_operation_id = x_standard_operation_id
1143: AND organization_id = p_org_id;
1144: */
1145: SELECT DEFAULT_SUBINVENTORY, DEFAULT_LOCATOR_ID
1146: INTO x_completion_subinventory,x_inventory_location_id

Line 1147: FROM BOM_STANDARD_OPERATIONS

1143: AND organization_id = p_org_id;
1144: */
1145: SELECT DEFAULT_SUBINVENTORY, DEFAULT_LOCATOR_ID
1146: INTO x_completion_subinventory,x_inventory_location_id
1147: FROM BOM_STANDARD_OPERATIONS
1148: WHERE standard_operation_id = x_standard_operation_id
1149: AND organization_id = p_org_id;
1150:
1151: IF x_completion_subinventory IS NULL THEN

Line 1148: WHERE standard_operation_id = x_standard_operation_id

1144: */
1145: SELECT DEFAULT_SUBINVENTORY, DEFAULT_LOCATOR_ID
1146: INTO x_completion_subinventory,x_inventory_location_id
1147: FROM BOM_STANDARD_OPERATIONS
1148: WHERE standard_operation_id = x_standard_operation_id
1149: AND organization_id = p_org_id;
1150:
1151: IF x_completion_subinventory IS NULL THEN
1152: RAISE NO_SUB;

Line 1227: ** 1. Org should be a Standard Costing Method Org.

1223: /*
1224: ** Function CHECK_IF_ORG_IS_VALID to check for the validity
1225: ** of an organization for use in WSM.
1226: ** The following checks are made;
1227: ** 1. Org should be a Standard Costing Method Org.
1228: ** 2. Org should have inventory item lot number set to NON-UNIQUE.
1229: ** 3. Org should have WIP Parameter lot number default type to JOBNAME.
1230: ** 4. Org should NOT be WPS enabled in WIP Parameter table.
1231: ** BA#1490834

Line 1251: -- 1:Standard, 2: Average.

1247: l_lotNumberUniqueNess number default 0;
1248: -- 1:UniqueForItem, 2:NoUniqueness
1249:
1250: l_primaryCostMethod number default 0;
1251: -- 1:Standard, 2: Average.
1252:
1253: l_lotNumberDefaultType number default 0;
1254: -- 1:JobName, 2:InvRules.
1255:

Line 1301: -- NON_STANDARD costing method

1297: Where MTL.organization_id = p_organization_id
1298: And MTL.organization_id = WIP.organization_id (+);
1299:
1300: If l_primaryCostMethod <> 1 Then
1301: -- NON_STANDARD costing method
1302: fnd_message.set_name('WSM', 'WSM_ORG_NOT_STD_COST');
1303: raise e_primaryCostMethod;
1304:
1305: ElsIf l_lotNumberUniqueness <> 2 Then

Line 1915: PROCEDURE OPERATION_IS_STANDARD_REPEATS (

1911: --
1912: -- This is created to circumvent the dependency issues with forms and other objects
1913: --
1914:
1915: PROCEDURE OPERATION_IS_STANDARD_REPEATS (
1916: p_routing_sequence_id IN NUMBER,
1917: p_standard_operation_id IN NUMBER,
1918: p_operation_code IN VARCHAR2,
1919: p_organization_id IN NUMBER, --BBK

Line 1917: p_standard_operation_id IN NUMBER,

1913: --
1914:
1915: PROCEDURE OPERATION_IS_STANDARD_REPEATS (
1916: p_routing_sequence_id IN NUMBER,
1917: p_standard_operation_id IN NUMBER,
1918: p_operation_code IN VARCHAR2,
1919: p_organization_id IN NUMBER, --BBK
1920: p_op_is_std_op OUT NOCOPY NUMBER,
1921: p_op_repeated_times OUT NOCOPY NUMBER,

Line 1926: Operation_Is_Standard_Repeats(

1922: x_err_code OUT NOCOPY NUMBER,
1923: x_err_msg OUT NOCOPY VARCHAR2)
1924: IS
1925: BEGIN
1926: Operation_Is_Standard_Repeats(
1927: p_routing_sequence_id => p_routing_sequence_id,
1928: p_routing_revision_date => SYSDATE,
1929: p_standard_operation_id => p_standard_operation_id,
1930: p_operation_code => p_operation_code,

Line 1929: p_standard_operation_id => p_standard_operation_id,

1925: BEGIN
1926: Operation_Is_Standard_Repeats(
1927: p_routing_sequence_id => p_routing_sequence_id,
1928: p_routing_revision_date => SYSDATE,
1929: p_standard_operation_id => p_standard_operation_id,
1930: p_operation_code => p_operation_code,
1931: p_organization_id => p_organization_id,
1932: p_op_is_std_op => p_op_is_std_op,
1933: p_op_repeated_times => p_op_repeated_times,

Line 1937: END OPERATION_IS_STANDARD_REPEATS;

1933: p_op_repeated_times => p_op_repeated_times,
1934: x_err_code => x_err_code,
1935: x_err_msg => x_err_msg );
1936:
1937: END OPERATION_IS_STANDARD_REPEATS;
1938:
1939: /* **********************************************************************************
1940: -- BA: NSO-WLT
1941:

Line 1944: standard operation id), this procedure finds out if:

1940: -- BA: NSO-WLT
1941:
1942: Function description:
1943: Given a routing (routing sequence id) and an operation (operation code or
1944: standard operation id), this procedure finds out if:
1945: 1. This operation is a standard operation (p_op_is_std_op=1)
1946: Then, if it is a standard operation, is it unique in the primary path of the
1947: network routing (if so p_op_is_unique=1, otherwise 0)
1948: Then if not unique, how many times this repeats in the primary path of the

Line 1945: 1. This operation is a standard operation (p_op_is_std_op=1)

1941:
1942: Function description:
1943: Given a routing (routing sequence id) and an operation (operation code or
1944: standard operation id), this procedure finds out if:
1945: 1. This operation is a standard operation (p_op_is_std_op=1)
1946: Then, if it is a standard operation, is it unique in the primary path of the
1947: network routing (if so p_op_is_unique=1, otherwise 0)
1948: Then if not unique, how many times this repeats in the primary path of the
1949: network routing (p_op_repeated_times=1 if more than once, otherwise, 2).

Line 1946: Then, if it is a standard operation, is it unique in the primary path of the

1942: Function description:
1943: Given a routing (routing sequence id) and an operation (operation code or
1944: standard operation id), this procedure finds out if:
1945: 1. This operation is a standard operation (p_op_is_std_op=1)
1946: Then, if it is a standard operation, is it unique in the primary path of the
1947: network routing (if so p_op_is_unique=1, otherwise 0)
1948: Then if not unique, how many times this repeats in the primary path of the
1949: network routing (p_op_repeated_times=1 if more than once, otherwise, 2).
1950: 2. This operation is a non-standard op (p_op_is_std_op= 0),

Line 1950: 2. This operation is a non-standard op (p_op_is_std_op= 0),

1946: Then, if it is a standard operation, is it unique in the primary path of the
1947: network routing (if so p_op_is_unique=1, otherwise 0)
1948: Then if not unique, how many times this repeats in the primary path of the
1949: network routing (p_op_repeated_times=1 if more than once, otherwise, 2).
1950: 2. This operation is a non-standard op (p_op_is_std_op= 0),
1951: Then, if it is a non-standard op, is it unique in the primary path of the
1952: network routing (if so p_op_is_unique=1, otherwise 0)
1953: If not unique, how many times this repeats in the primary path of the
1954: network routing (p_op_repeated_times=1 if more than once, otherwise, 2).

Line 1951: Then, if it is a non-standard op, is it unique in the primary path of the

1947: network routing (if so p_op_is_unique=1, otherwise 0)
1948: Then if not unique, how many times this repeats in the primary path of the
1949: network routing (p_op_repeated_times=1 if more than once, otherwise, 2).
1950: 2. This operation is a non-standard op (p_op_is_std_op= 0),
1951: Then, if it is a non-standard op, is it unique in the primary path of the
1952: network routing (if so p_op_is_unique=1, otherwise 0)
1953: If not unique, how many times this repeats in the primary path of the
1954: network routing (p_op_repeated_times=1 if more than once, otherwise, 2).
1955:

Line 1965: PROCEDURE OPERATION_IS_STANDARD_REPEATS(

1961: -- match this call
1962: --
1963: ********************************************************************************** */
1964:
1965: PROCEDURE OPERATION_IS_STANDARD_REPEATS(
1966: p_routing_sequence_id IN NUMBER,
1967: p_routing_revision_date IN DATE, -- CZH.I_OED-1
1968: p_standard_operation_id IN NUMBER,
1969: p_operation_code IN VARCHAR2,

Line 1968: p_standard_operation_id IN NUMBER,

1964:
1965: PROCEDURE OPERATION_IS_STANDARD_REPEATS(
1966: p_routing_sequence_id IN NUMBER,
1967: p_routing_revision_date IN DATE, -- CZH.I_OED-1
1968: p_standard_operation_id IN NUMBER,
1969: p_operation_code IN VARCHAR2,
1970: p_organization_id IN NUMBER, --BBK
1971: p_op_is_std_op OUT NOCOPY NUMBER,
1972: p_op_repeated_times OUT NOCOPY NUMBER,

Line 1995: x_err_msg := 'WSMPUTIL.operation_is_standard_repeats: Invalid operation and/or routing ('

1991: l_stmt_num := 10;
1992:
1993: IF (p_routing_sequence_id is null) then
1994: x_err_code := 1;
1995: x_err_msg := 'WSMPUTIL.operation_is_standard_repeats: Invalid operation and/or routing ('
1996: ||l_stmt_num || ') ';
1997: p_op_is_std_op := 3; -- CZH: why?
1998: p_op_repeated_times := 3; -- CZH: why?
1999: return;

Line 2005: IF (p_operation_code is null and p_standard_operation_id is null) then

2001:
2002:
2003: l_stmt_num := 20;
2004:
2005: IF (p_operation_code is null and p_standard_operation_id is null) then
2006: -- Job is at an NSO operation.
2007: p_op_is_std_op := 0;
2008: p_op_repeated_times := 0;
2009: return;

Line 2011: ELSIF p_standard_operation_id is not null then

2007: p_op_is_std_op := 0;
2008: p_op_repeated_times := 0;
2009: return;
2010:
2011: ELSIF p_standard_operation_id is not null then
2012:
2013: l_std_op_id := p_standard_operation_id;
2014: p_op_is_std_op := 1;
2015:

Line 2013: l_std_op_id := p_standard_operation_id;

2009: return;
2010:
2011: ELSIF p_standard_operation_id is not null then
2012:
2013: l_std_op_id := p_standard_operation_id;
2014: p_op_is_std_op := 1;
2015:
2016: ELSIF (p_operation_code is not null) then
2017:

Line 2022: select nvl(standard_operation_id, -999)

2018: l_stmt_num := 30;
2019:
2020: Begin
2021:
2022: select nvl(standard_operation_id, -999)
2023: into l_std_op_id
2024: from bom_standard_operations
2025: where organization_id = p_organization_id -- BBK
2026: and operation_type = 1 -- Standard Operation Type BBK

Line 2024: from bom_standard_operations

2020: Begin
2021:
2022: select nvl(standard_operation_id, -999)
2023: into l_std_op_id
2024: from bom_standard_operations
2025: where organization_id = p_organization_id -- BBK
2026: and operation_type = 1 -- Standard Operation Type BBK
2027: and line_id is NULL -- Not for a WIP Line BBK
2028: and operation_code = p_operation_code;

Line 2026: and operation_type = 1 -- Standard Operation Type BBK

2022: select nvl(standard_operation_id, -999)
2023: into l_std_op_id
2024: from bom_standard_operations
2025: where organization_id = p_organization_id -- BBK
2026: and operation_type = 1 -- Standard Operation Type BBK
2027: and line_id is NULL -- Not for a WIP Line BBK
2028: and operation_code = p_operation_code;
2029:
2030: Exception

Line 2034: x_err_msg := 'WSMPUTIL.operation_is_standard_repeats ('

2030: Exception
2031:
2032: WHEN NO_DATA_FOUND THEN
2033: x_err_code := 2;
2034: x_err_msg := 'WSMPUTIL.operation_is_standard_repeats ('
2035: ||l_stmt_num || '): Standard_op_id not found for this opcode.. '
2036: ||substrb(sqlerrm,1,1000);
2037:
2038: WHEN OTHERS THEN

Line 2035: ||l_stmt_num || '): Standard_op_id not found for this opcode.. '

2031:
2032: WHEN NO_DATA_FOUND THEN
2033: x_err_code := 2;
2034: x_err_msg := 'WSMPUTIL.operation_is_standard_repeats ('
2035: ||l_stmt_num || '): Standard_op_id not found for this opcode.. '
2036: ||substrb(sqlerrm,1,1000);
2037:
2038: WHEN OTHERS THEN
2039: x_err_code := 3;

Line 2040: x_err_msg := 'WSMPUTIL.operation_is_standard_repeats ('

2036: ||substrb(sqlerrm,1,1000);
2037:
2038: WHEN OTHERS THEN
2039: x_err_code := 3;
2040: x_err_msg := 'WSMPUTIL.operation_is_standard_repeats ('
2041: ||l_stmt_num ||'): '||substrb(sqlerrm,1,1000);
2042:
2043: End;
2044:

Line 2074: bos.standard_operation_id

2070: DECLARE
2071: cursor c is
2072: -- BC: CZH.I_OED-2, consider replacement
2073: select distinct bon.from_op_seq_id,
2074: bos.standard_operation_id
2075: from bom_operation_networks bon,
2076: bom_operation_sequences bos
2077: Where bos.routing_sequence_id = p_routing_sequence_id
2078: and bos.operation_sequence_id = bon.from_op_seq_id

Line 2079: and bos.standard_operation_id = l_std_op_id --p_standard_operation_id --Fix for 2265237

2075: from bom_operation_networks bon,
2076: bom_operation_sequences bos
2077: Where bos.routing_sequence_id = p_routing_sequence_id
2078: and bos.operation_sequence_id = bon.from_op_seq_id
2079: and bos.standard_operation_id = l_std_op_id --p_standard_operation_id --Fix for 2265237
2080: and nvl(bos.disable_date, l_rtg_rev_date+1) >= l_rtg_rev_date -- CZH.I_OED-1
2081: and bos.effectivity_date <= l_rtg_rev_date -- CZH.I_OED-1
2082: UNION
2083: select distinct bon.to_op_seq_id,

Line 2084: bos.standard_operation_id

2080: and nvl(bos.disable_date, l_rtg_rev_date+1) >= l_rtg_rev_date -- CZH.I_OED-1
2081: and bos.effectivity_date <= l_rtg_rev_date -- CZH.I_OED-1
2082: UNION
2083: select distinct bon.to_op_seq_id,
2084: bos.standard_operation_id
2085: from bom_operation_networks bon,
2086: bom_operation_sequences bos
2087: Where bos.routing_sequence_id = p_routing_sequence_id
2088: and bos.operation_sequence_id = bon.to_op_seq_id

Line 2089: and bos.standard_operation_id = l_std_op_id --p_standard_operation_id --Fix for 2265237

2085: from bom_operation_networks bon,
2086: bom_operation_sequences bos
2087: Where bos.routing_sequence_id = p_routing_sequence_id
2088: and bos.operation_sequence_id = bon.to_op_seq_id
2089: and bos.standard_operation_id = l_std_op_id --p_standard_operation_id --Fix for 2265237
2090: and nvl(bos.disable_date, l_rtg_rev_date+1) >= l_rtg_rev_date --CZH.I_OED-1
2091: and bos.effectivity_date <= l_rtg_rev_date; --CZH.I_OED-1
2092: select distinct
2093: bos.operation_sequence_id,

Line 2094: bos.standard_operation_id

2090: and nvl(bos.disable_date, l_rtg_rev_date+1) >= l_rtg_rev_date --CZH.I_OED-1
2091: and bos.effectivity_date <= l_rtg_rev_date; --CZH.I_OED-1
2092: select distinct
2093: bos.operation_sequence_id,
2094: bos.standard_operation_id
2095: from bom_operation_networks bon,
2096: bom_operation_sequences bos
2097: Where bos.routing_sequence_id = p_routing_sequence_id
2098: and bos.standard_operation_id = l_std_op_id

Line 2098: and bos.standard_operation_id = l_std_op_id

2094: bos.standard_operation_id
2095: from bom_operation_networks bon,
2096: bom_operation_sequences bos
2097: Where bos.routing_sequence_id = p_routing_sequence_id
2098: and bos.standard_operation_id = l_std_op_id
2099: and (bos.operation_sequence_id = WSMPUTIL.replacement_op_seq_id(
2100: bon.from_op_seq_id,
2101: l_rtg_rev_date)
2102: or

Line 2146: and bos2.standard_operation_id = l_std_op_id

2142: where bos_B.routing_sequence_id = p_routing_sequence_id
2143: and bon_B.from_op_seq_id = bos_B.operation_sequence_id)
2144: and bos2.routing_sequence_id = p_routing_sequence_id
2145: and bos.operation_seq_num = bos2.operation_seq_num
2146: and bos2.standard_operation_id = l_std_op_id
2147: and nvl(bos2.disable_date, l_rtg_rev_date+1) >= l_rtg_rev_date
2148: and bos2.effectivity_date <= l_rtg_rev_date;
2149:
2150: END;

Line 2158: x_err_msg := substr('WSMPUTIL.OPERATION_IS_STANDARD_REPEATS' ||sqlerrm,1,2000);

2154: End;
2155: EXCEPTION
2156: WHEN OTHERS THEN
2157: x_err_code := SQLCODE;
2158: x_err_msg := substr('WSMPUTIL.OPERATION_IS_STANDARD_REPEATS' ||sqlerrm,1,2000);
2159: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
2160: return;
2161:
2162: END OPERATION_IS_STANDARD_REPEATS;

Line 2162: END OPERATION_IS_STANDARD_REPEATS;

2158: x_err_msg := substr('WSMPUTIL.OPERATION_IS_STANDARD_REPEATS' ||sqlerrm,1,2000);
2159: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
2160: return;
2161:
2162: END OPERATION_IS_STANDARD_REPEATS;
2163: -- BA: NSO-WLT
2164:
2165: -- added by abedajna for patchset H non standard jobs project
2166:

Line 2165: -- added by abedajna for patchset H non standard jobs project

2161:
2162: END OPERATION_IS_STANDARD_REPEATS;
2163: -- BA: NSO-WLT
2164:
2165: -- added by abedajna for patchset H non standard jobs project
2166:
2167: procedure validate_non_std_references(p_assembly_item_id IN NUMBER,
2168: p_routing_reference_id IN NUMBER,
2169: p_bom_reference_id IN NUMBER,

Line 3904: -- or a standard operation (S) has PO Move charge type resources attached

3900: return NULL;
3901: END replacement_op_seq_id;
3902:
3903: -- OSP : This procedure determines if the routing (R), operation (O) in a routing
3904: -- or a standard operation (S) has PO Move charge type resources attached
3905: -- to them.
3906:
3907:
3908: FUNCTION check_po_move (

Line 3966: -- when the id passed is standard_operation_id

3962: bos.effectivity_date AND nvl(bos.disable_date, nvl(p_routing_rev_date, SYSDATE)+1)
3963: /*EA HH24MISS */
3964: AND bres.autocharge_type = WIP_CONSTANTS.PO_MOVE ;
3965:
3966: -- when the id passed is standard_operation_id
3967:
3968: elsif p_sequence_id_type = 'S' then
3969:
3970: SELECT count(*)

Line 3973: WHERE bsor.standard_operation_id = p_sequence_id

3969:
3970: SELECT count(*)
3971: INTO x_rowcount
3972: FROM bom_std_op_resources bsor
3973: WHERE bsor.standard_operation_id = p_sequence_id
3974: AND bsor.autocharge_type = WIP_CONSTANTS.PO_MOVE;
3975:
3976: end if;
3977:

Line 4296: BOM_OPERATION_NETWORKS_V to fetch standard operation id of

4292:
4293: /* bug fix:7387499
4294: ***************************************************************************
4295: created this function for bug fix 5529692 to call this in
4296: BOM_OPERATION_NETWORKS_V to fetch standard operation id of
4297: operation that is relatively effective at a particular operation
4298: sequence number and inturn fetch its op code
4299: **************************************************************************/
4300:

Line 4315: where standard_operation_id = p_stdop_id

4311:
4312: select operation_seq_num,routing_sequence_id,operation_type
4313: into l_opseq_num,l_routseq_id,l_operation_type
4314: from bom_operation_sequences
4315: where standard_operation_id = p_stdop_id
4316: and operation_sequence_id = p_opseq_id;
4317:
4318: l_eff_date := WSMPUTIL.EFFECTIVE_DATE(l_opseq_num,l_routseq_id,l_operation_type);
4319:

Line 4320: select standard_operation_id into l_eff_stdop_id

4316: and operation_sequence_id = p_opseq_id;
4317:
4318: l_eff_date := WSMPUTIL.EFFECTIVE_DATE(l_opseq_num,l_routseq_id,l_operation_type);
4319:
4320: select standard_operation_id into l_eff_stdop_id
4321: from bom_operation_sequences
4322: where effectivity_date = l_eff_date
4323: and operation_seq_num = l_opseq_num
4324: and routing_sequence_id = l_routseq_id

Line 4333: BOM_OPERATION_NETWORKS_V to fetch standard department id of

4329: end get_eff_stdop_id;
4330:
4331: /****************************************************************************************************
4332: Created this function for bug fix 5529692 to call this in
4333: BOM_OPERATION_NETWORKS_V to fetch standard department id of
4334: operation that is relatively effective at a particular operation
4335: sequence number and inturn fetch its department code
4336: ****************************************************************************************************/
4337: