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

Line 6477: -- p_api_version Standard Input Parameter

6473: -- If picking, quantity tree has to exist, created through
6474: -- INV_Quantity_Tree_PVT.Create_Tree and uniquely identified
6475: -- by parameter p_tree_id
6476: -- Parameters :
6477: -- p_api_version Standard Input Parameter
6478: -- p_init_msg_list Standard Input Parameter
6479: -- p_commit Standard Input Parameter
6480: -- p_validation_level Standard Input Parameter
6481: -- p_rule_id Identifier of the rule to apply

Line 6478: -- p_init_msg_list Standard Input Parameter

6474: -- INV_Quantity_Tree_PVT.Create_Tree and uniquely identified
6475: -- by parameter p_tree_id
6476: -- Parameters :
6477: -- p_api_version Standard Input Parameter
6478: -- p_init_msg_list Standard Input Parameter
6479: -- p_commit Standard Input Parameter
6480: -- p_validation_level Standard Input Parameter
6481: -- p_rule_id Identifier of the rule to apply
6482: -- p_type_code Type code of the rule

Line 6479: -- p_commit Standard Input Parameter

6475: -- by parameter p_tree_id
6476: -- Parameters :
6477: -- p_api_version Standard Input Parameter
6478: -- p_init_msg_list Standard Input Parameter
6479: -- p_commit Standard Input Parameter
6480: -- p_validation_level Standard Input Parameter
6481: -- p_rule_id Identifier of the rule to apply
6482: -- p_type_code Type code of the rule
6483: -- p_partial_success_allowed_flag

Line 6480: -- p_validation_level Standard Input Parameter

6476: -- Parameters :
6477: -- p_api_version Standard Input Parameter
6478: -- p_init_msg_list Standard Input Parameter
6479: -- p_commit Standard Input Parameter
6480: -- p_validation_level Standard Input Parameter
6481: -- p_rule_id Identifier of the rule to apply
6482: -- p_type_code Type code of the rule
6483: -- p_partial_success_allowed_flag
6484: -- 'Y' or 'N'

Line 6495: -- x_return_status Standard Output Parameter

6491: -- p_primary_uom Primary UOM code
6492: -- p_tree_id Identifier for the quantity tree
6493: --
6494: -- Output Parameters
6495: -- x_return_status Standard Output Parameter
6496: -- x_msg_count Standard Output Parameter
6497: -- x_msg_data Standard Output Parameter
6498: -- x_finished whether the rule has found enough quantity to
6499: -- find a location that completely satisfy

Line 6496: -- x_msg_count Standard Output Parameter

6492: -- p_tree_id Identifier for the quantity tree
6493: --
6494: -- Output Parameters
6495: -- x_return_status Standard Output Parameter
6496: -- x_msg_count Standard Output Parameter
6497: -- x_msg_data Standard Output Parameter
6498: -- x_finished whether the rule has found enough quantity to
6499: -- find a location that completely satisfy
6500: -- the requested quantity (value is 'Y' or 'N')

Line 6497: -- x_msg_data Standard Output Parameter

6493: --
6494: -- Output Parameters
6495: -- x_return_status Standard Output Parameter
6496: -- x_msg_count Standard Output Parameter
6497: -- x_msg_data Standard Output Parameter
6498: -- x_finished whether the rule has found enough quantity to
6499: -- find a location that completely satisfy
6500: -- the requested quantity (value is 'Y' or 'N')
6501: --

Line 6545: -- API standard variables

6541: , p_simulation_mode IN NUMBER
6542: , p_project_id IN NUMBER
6543: , p_task_id IN NUMBER
6544: ) IS
6545: -- API standard variables
6546: l_api_version CONSTANT NUMBER := 1.0;
6547: l_api_name CONSTANT VARCHAR2(30) := 'Apply';
6548: -- variables needed for dynamic SQL
6549: l_cursor INTEGER;

Line 6803: -- Standard start of API savepoint

6799: log_event(l_api_name, 'Apply ', 'item_id '||p_inventory_item_id);
6800: END IF;
6801: -- end of debugging section
6802: --
6803: -- Standard start of API savepoint
6804: SAVEPOINT applyrulesp;
6805:
6806: -- Standard call to check for call compatibility
6807: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

Line 6806: -- Standard call to check for call compatibility

6802: --
6803: -- Standard start of API savepoint
6804: SAVEPOINT applyrulesp;
6805:
6806: -- Standard call to check for call compatibility
6807: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
6808: RAISE fnd_api.g_exc_unexpected_error;
6809: END IF;
6810:

Line 10848: -- Standard check of p_commit

10844: NULL;
10845: END LOOP; -- input records
10846:
10847: --
10848: -- Standard check of p_commit
10849: IF fnd_api.to_boolean(p_commit) THEN
10850: COMMIT WORK;
10851: END IF;
10852:

Line 11254: -- cost group for the subinventory if in a standard costing org.

11250: END IF;
11251:
11252: -- Now get the cost group. If the to_cost_group is specified
11253: -- on the move order, then use that. If not, query the default
11254: -- cost group for the subinventory if in a standard costing org.
11255: -- If not defined there, or if avg. costing org
11256: -- try to get the default cost group from the organization
11257:
11258: IF p_to_cost_group_id IS NULL THEN

Line 11343: -- p_api_version Standard Input Parameter

11339: -- to check capacity.
11340: -- Pre-reqs :
11341: --
11342: -- Parameters :
11343: -- p_api_version Standard Input Parameter
11344: -- p_init_msg_list Standard Input Parameter
11345: -- p_commit Standard Input Parameter
11346: -- p_validation_level Standard Input Parameter
11347: -- p_transaction_temp_id Identifier for the record in view

Line 11344: -- p_init_msg_list Standard Input Parameter

11340: -- Pre-reqs :
11341: --
11342: -- Parameters :
11343: -- p_api_version Standard Input Parameter
11344: -- p_init_msg_list Standard Input Parameter
11345: -- p_commit Standard Input Parameter
11346: -- p_validation_level Standard Input Parameter
11347: -- p_transaction_temp_id Identifier for the record in view
11348: -- wms_strategy_mat_txn_tmp_v that represents

Line 11345: -- p_commit Standard Input Parameter

11341: --
11342: -- Parameters :
11343: -- p_api_version Standard Input Parameter
11344: -- p_init_msg_list Standard Input Parameter
11345: -- p_commit Standard Input Parameter
11346: -- p_validation_level Standard Input Parameter
11347: -- p_transaction_temp_id Identifier for the record in view
11348: -- wms_strategy_mat_txn_tmp_v that represents
11349: -- the request for detailing

Line 11346: -- p_validation_level Standard Input Parameter

11342: -- Parameters :
11343: -- p_api_version Standard Input Parameter
11344: -- p_init_msg_list Standard Input Parameter
11345: -- p_commit Standard Input Parameter
11346: -- p_validation_level Standard Input Parameter
11347: -- p_transaction_temp_id Identifier for the record in view
11348: -- wms_strategy_mat_txn_tmp_v that represents
11349: -- the request for detailing
11350: -- p_organization_id Organization identifier

Line 11358: -- x_return_status Standard Output Parameter

11354: -- p_project_id Project associated with transaction
11355: -- p_task_id Task associated with transaction
11356: --
11357: -- Output Parameters
11358: -- x_return_status Standard Output Parameter
11359: -- x_msg_count Standard Output Parameter
11360: -- x_msg_data Standard Output Parameter
11361: -- x_finished whether the rule has found enough quantity to
11362: -- find a location that completely satisfy

Line 11359: -- x_msg_count Standard Output Parameter

11355: -- p_task_id Task associated with transaction
11356: --
11357: -- Output Parameters
11358: -- x_return_status Standard Output Parameter
11359: -- x_msg_count Standard Output Parameter
11360: -- x_msg_data Standard Output Parameter
11361: -- x_finished whether the rule has found enough quantity to
11362: -- find a location that completely satisfy
11363: -- the requested quantity (value is 'Y' or 'N')

Line 11360: -- x_msg_data Standard Output Parameter

11356: --
11357: -- Output Parameters
11358: -- x_return_status Standard Output Parameter
11359: -- x_msg_count Standard Output Parameter
11360: -- x_msg_data Standard Output Parameter
11361: -- x_finished whether the rule has found enough quantity to
11362: -- find a location that completely satisfy
11363: -- the requested quantity (value is 'Y' or 'N')
11364: --

Line 11396: -- API standard variables

11392: p_task_id IN NUMBER
11393: )
11394: IS
11395:
11396: -- API standard variables
11397: l_api_version constant number := 1.0;
11398: l_api_name constant varchar2(30) := 'ApplyDefLoc';
11399: -- variables needed for dynamic SQL
11400: l_cursor integer;

Line 11473: -- Standard start of API savepoint

11469: log_procedure(l_api_name, 'start', 'Start ApplyDefLoc');
11470: End if;
11471: -- end of debugging section
11472:
11473: -- Standard start of API savepoint
11474: SAVEPOINT ApplyRuleSP;
11475: --
11476:
11477:

Line 11478: -- Standard call to check for call compatibility

11474: SAVEPOINT ApplyRuleSP;
11475: --
11476:
11477:
11478: -- Standard call to check for call compatibility
11479: IF NOT fnd_api.compatible_api_call( l_api_version
11480: ,p_api_version
11481: ,l_api_name
11482: ,g_pkg_name ) THEN

Line 12096: -- Standard check of p_commit

12092: END IF;
12093:
12094: END LOOP; -- input records
12095: --
12096: -- Standard check of p_commit
12097: IF fnd_api.to_boolean(p_commit) THEN
12098: COMMIT WORK;
12099: END IF;
12100: --

Line 12158: -- p_api_version Standard Input Parameter

12154: -- called from the WMS_RULES form
12155: -- Pre-reqs : one record in WMS_RULES_B uniquely identified by parameter
12156: -- p_rule_id
12157: -- Input Parameters :
12158: -- p_api_version Standard Input Parameter
12159: -- p_init_msg_list Standard Input Parameter
12160: -- p_validation_level Standard Input Parameter
12161: -- p_rule_id Identifier of the rule to check
12162: --

Line 12159: -- p_init_msg_list Standard Input Parameter

12155: -- Pre-reqs : one record in WMS_RULES_B uniquely identified by parameter
12156: -- p_rule_id
12157: -- Input Parameters :
12158: -- p_api_version Standard Input Parameter
12159: -- p_init_msg_list Standard Input Parameter
12160: -- p_validation_level Standard Input Parameter
12161: -- p_rule_id Identifier of the rule to check
12162: --
12163: -- Output Parameters :

Line 12160: -- p_validation_level Standard Input Parameter

12156: -- p_rule_id
12157: -- Input Parameters :
12158: -- p_api_version Standard Input Parameter
12159: -- p_init_msg_list Standard Input Parameter
12160: -- p_validation_level Standard Input Parameter
12161: -- p_rule_id Identifier of the rule to check
12162: --
12163: -- Output Parameters :
12164: -- x_return_status Standard Output Parameter

Line 12164: -- x_return_status Standard Output Parameter

12160: -- p_validation_level Standard Input Parameter
12161: -- p_rule_id Identifier of the rule to check
12162: --
12163: -- Output Parameters :
12164: -- x_return_status Standard Output Parameter
12165: -- x_msg_count Standard Output Parameter
12166: -- x_msg_data Standard Output Parameter
12167: --
12168: -- Version :

Line 12165: -- x_msg_count Standard Output Parameter

12161: -- p_rule_id Identifier of the rule to check
12162: --
12163: -- Output Parameters :
12164: -- x_return_status Standard Output Parameter
12165: -- x_msg_count Standard Output Parameter
12166: -- x_msg_data Standard Output Parameter
12167: --
12168: -- Version :
12169: -- Current version 1.0

Line 12166: -- x_msg_data Standard Output Parameter

12162: --
12163: -- Output Parameters :
12164: -- x_return_status Standard Output Parameter
12165: -- x_msg_count Standard Output Parameter
12166: -- x_msg_data Standard Output Parameter
12167: --
12168: -- Version :
12169: -- Current version 1.0
12170: --

Line 12183: -- API standard variables

12179: , x_msg_data OUT NOCOPY VARCHAR2
12180: , p_rule_id IN NUMBER
12181: ) IS
12182: PRAGMA AUTONOMOUS_TRANSACTION;
12183: -- API standard variables
12184: l_api_version CONSTANT NUMBER := 1.0;
12185: l_api_name CONSTANT VARCHAR2(30) := 'CheckSyntax';
12186: --
12187: --

Line 12190: -- Standard call to check for call compatibility

12186: --
12187: --
12188: BEGIN
12189: --
12190: -- Standard call to check for call compatibility
12191: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
12192: RAISE fnd_api.g_exc_unexpected_error;
12193: END IF;
12194:

Line 12238: -- p_api_version Standard Input Parameter

12234: -- API name : Find_Rule
12235: -- Type : Private
12236: -- Function : find a rule by id
12237: -- Input Parameters :
12238: -- p_api_version Standard Input Parameter
12239: -- p_init_msg_list Standard Input Parameter
12240: -- p_rule_id Identifier of the rule
12241: --
12242: -- Output Parameters:

Line 12239: -- p_init_msg_list Standard Input Parameter

12235: -- Type : Private
12236: -- Function : find a rule by id
12237: -- Input Parameters :
12238: -- p_api_version Standard Input Parameter
12239: -- p_init_msg_list Standard Input Parameter
12240: -- p_rule_id Identifier of the rule
12241: --
12242: -- Output Parameters:
12243: -- x_return_status Standard Output Parameter

Line 12243: -- x_return_status Standard Output Parameter

12239: -- p_init_msg_list Standard Input Parameter
12240: -- p_rule_id Identifier of the rule
12241: --
12242: -- Output Parameters:
12243: -- x_return_status Standard Output Parameter
12244: -- x_msg_count Standard Output Parameter
12245: -- x_msg_data Standard Output Parameter
12246: -- x_found true if found ; else false
12247: -- x_rule_rec info of the rule if found

Line 12244: -- x_msg_count Standard Output Parameter

12240: -- p_rule_id Identifier of the rule
12241: --
12242: -- Output Parameters:
12243: -- x_return_status Standard Output Parameter
12244: -- x_msg_count Standard Output Parameter
12245: -- x_msg_data Standard Output Parameter
12246: -- x_found true if found ; else false
12247: -- x_rule_rec info of the rule if found
12248:

Line 12245: -- x_msg_data Standard Output Parameter

12241: --
12242: -- Output Parameters:
12243: -- x_return_status Standard Output Parameter
12244: -- x_msg_count Standard Output Parameter
12245: -- x_msg_data Standard Output Parameter
12246: -- x_found true if found ; else false
12247: -- x_rule_rec info of the rule if found
12248:
12249: -- Version :

Line 12264: -- API standard variables

12260: , p_rule_id IN NUMBER
12261: , x_found OUT NOCOPY BOOLEAN
12262: , x_rule_rec OUT NOCOPY rule_rec
12263: ) IS
12264: -- API standard variables
12265: l_api_version CONSTANT NUMBER := 1.0;
12266: l_api_name CONSTANT VARCHAR2(30) := 'Find_Rule';
12267:
12268: --

Line 12335: --This function establishes the naming standard for the rule packages.

12331: END find_rule;
12332:
12333: --GetPackageName
12334: --
12335: --This function establishes the naming standard for the rule packages.
12336: --Currently, the naming standard is WMS_RULE_## , where ## is rule id
12337: PROCEDURE getpackagename(p_rule_id IN NUMBER, x_package_name OUT NOCOPY VARCHAR2) IS
12338: BEGIN
12339: x_package_name := 'WMS_RULE_' || p_rule_id;

Line 12336: --Currently, the naming standard is WMS_RULE_## , where ## is rule id

12332:
12333: --GetPackageName
12334: --
12335: --This function establishes the naming standard for the rule packages.
12336: --Currently, the naming standard is WMS_RULE_## , where ## is rule id
12337: PROCEDURE getpackagename(p_rule_id IN NUMBER, x_package_name OUT NOCOPY VARCHAR2) IS
12338: BEGIN
12339: x_package_name := 'WMS_RULE_' || p_rule_id;
12340: END getpackagename;

Line 12384: -- We may need to call this API for AOL standards.

12380: l_row := l_row + 1;
12381: --Get substring from package_string
12382: g_build_package_tbl(l_row) := SUBSTR(p_package_string, l_cur_start, l_num_chars);
12383: --Call build package to add row
12384: -- We may need to call this API for AOL standards.
12385: --ad_ddl.build_package(l_cur_string, l_row);
12386:
12387: --increment pointers
12388: l_cur_start := l_cur_start + l_num_chars;

Line 12436: /* We may need to call this API for AOL standards

12432: DBMS_SQL.parse(l_cursor, g_build_package_tbl, 1, g_build_package_row, FALSE, DBMS_SQL.native);
12433: --close cursor
12434: DBMS_SQL.close_cursor(l_cursor);
12435:
12436: /* We may need to call this API for AOL standards
12437: --get schema info
12438: l_return := fnd_installation.get_app_info(
12439: application_short_name => 'FND'
12440: ,status => l_status

Line 12498: -- p_api_version Standard Input Parameter

12494: -- Type : Private
12495: -- Function : generate a package for a rule that can be used in
12496: -- picking and put away
12497: -- Input Parameters :
12498: -- p_api_version Standard Input Parameter
12499: -- p_init_msg_list Standard Input Parameter
12500: -- p_validation_level Standard Input Parameter
12501: -- p_rule_id Identifier of the rule
12502: --

Line 12499: -- p_init_msg_list Standard Input Parameter

12495: -- Function : generate a package for a rule that can be used in
12496: -- picking and put away
12497: -- Input Parameters :
12498: -- p_api_version Standard Input Parameter
12499: -- p_init_msg_list Standard Input Parameter
12500: -- p_validation_level Standard Input Parameter
12501: -- p_rule_id Identifier of the rule
12502: --
12503: -- Output Parameters:

Line 12500: -- p_validation_level Standard Input Parameter

12496: -- picking and put away
12497: -- Input Parameters :
12498: -- p_api_version Standard Input Parameter
12499: -- p_init_msg_list Standard Input Parameter
12500: -- p_validation_level Standard Input Parameter
12501: -- p_rule_id Identifier of the rule
12502: --
12503: -- Output Parameters:
12504: -- x_return_status Standard Output Parameter

Line 12504: -- x_return_status Standard Output Parameter

12500: -- p_validation_level Standard Input Parameter
12501: -- p_rule_id Identifier of the rule
12502: --
12503: -- Output Parameters:
12504: -- x_return_status Standard Output Parameter
12505: -- x_msg_count Standard Output Parameter
12506: -- x_msg_data Standard Output Parameter
12507: --
12508: -- Called by the WMS Rules form (WMSRULEF.fmb), this function

Line 12505: -- x_msg_count Standard Output Parameter

12501: -- p_rule_id Identifier of the rule
12502: --
12503: -- Output Parameters:
12504: -- x_return_status Standard Output Parameter
12505: -- x_msg_count Standard Output Parameter
12506: -- x_msg_data Standard Output Parameter
12507: --
12508: -- Called by the WMS Rules form (WMSRULEF.fmb), this function
12509: -- creates a package for the given rule. The package has three

Line 12506: -- x_msg_data Standard Output Parameter

12502: --
12503: -- Output Parameters:
12504: -- x_return_status Standard Output Parameter
12505: -- x_msg_count Standard Output Parameter
12506: -- x_msg_data Standard Output Parameter
12507: --
12508: -- Called by the WMS Rules form (WMSRULEF.fmb), this function
12509: -- creates a package for the given rule. The package has three
12510: -- functions, open_curs, fetch_one_row, and close_curs. Open_curs

Line 12531: -- API standard variables

12527: , x_msg_count OUT NOCOPY NUMBER
12528: , x_msg_data OUT NOCOPY VARCHAR2
12529: , p_rule_id IN NUMBER
12530: ) IS
12531: -- API standard variables
12532: l_api_version CONSTANT NUMBER := 1.0;
12533: l_api_name CONSTANT VARCHAR2(30) := 'GenerateRulePackage';
12534: --
12535: -- variables needed for dynamic SQL

Line 12569: -- Standard call to check for call compatibility

12565: WHERE mpr.rule_id = p_rule_id;
12566: --
12567: BEGIN
12568: --
12569: -- Standard call to check for call compatibility
12570: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
12571: RAISE fnd_api.g_exc_unexpected_error;
12572: END IF;
12573:

Line 13809: WHERE mmtt.standard_operation_id IS NULL

13805: AND (organization_id = -1
13806: OR organization_id IN (SELECT mmtt.organization_id
13807: FROM mtl_material_transactions_temp mmtt,
13808: mtl_txn_request_lines mol
13809: WHERE mmtt.standard_operation_id IS NULL
13810: AND mmtt.move_order_line_id = mol.line_id
13811: AND mol.header_id = p_move_order_header_id)));
13812: EXCEPTION
13813: WHEN OTHERS THEN

Line 13959: -- Standard call to check for call compatibility

13955: l_rule_counter INTEGER;
13956: BEGIN
13957: SAVEPOINT assign_operation_plan_sp;
13958:
13959: -- Standard call to check for call compatibility
13960: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
13961: RAISE fnd_api.g_exc_unexpected_error;
13962: END IF;
13963:

Line 14060: -- Standard check of p_commit

14056: SET mmtt.operation_plan_id = l_operation_plan_id
14057: WHERE mmtt.transaction_temp_id = p_task_id;
14058: END IF;
14059:
14060: -- Standard check of p_commit
14061: IF fnd_api.to_boolean(p_commit) THEN
14062: COMMIT WORK;
14063: END IF;
14064: EXCEPTION

Line 14127: WHERE mmtt.standard_operation_id IS NULL

14123: SELECT mmtt.transaction_temp_id
14124: ,mmtt.organization_id -- Added new
14125: ,mmtt.wms_task_type -- Added new
14126: FROM mtl_material_transactions_temp mmtt, mtl_txn_request_lines mol
14127: WHERE mmtt.standard_operation_id IS NULL
14128: AND mmtt.move_order_line_id = mol.line_id
14129: AND mol.header_id = p_move_order_header_id;
14130:
14131: l_task_id NUMBER;

Line 14157: WHERE mmtt.standard_operation_id IS NULL

14153: AND (organization_id = -1
14154: OR organization_id IN (SELECT mmtt.organization_id
14155: FROM mtl_material_transactions_temp mmtt,
14156: mtl_txn_request_lines mol
14157: WHERE mmtt.standard_operation_id IS NULL
14158: AND mmtt.move_order_line_id = mol.line_id
14159: AND mol.header_id = p_move_order_header_id)));
14160: EXCEPTION
14161: WHEN OTHERS THEN

Line 14194: SET standard_operation_id =

14190: -- Bug# 4587423
14191: -- No valid rules exist for task type assignment so just stamp the org level
14192: -- default task type for the given WMS task type on the MMTT record.
14193: UPDATE mtl_material_transactions_temp mmtt
14194: SET standard_operation_id =
14195: (SELECT DECODE(mmtt.wms_task_type, 1, default_pick_task_type_id,
14196: 2, default_putaway_task_type_id,
14197: 3, default_cc_task_type_id,
14198: 4, default_repl_task_type_id,

Line 14203: WHERE mmtt.standard_operation_id IS NULL

14199: 5, default_moxfer_task_type_id,
14200: 6, default_moissue_task_type_id,
14201: NULL)
14202: FROM mtl_parameters mp WHERE mp.organization_id = mmtt.organization_id)
14203: WHERE mmtt.standard_operation_id IS NULL
14204: AND mmtt.move_order_line_id IN (SELECT line_id
14205: FROM mtl_txn_request_lines mol
14206: WHERE mol.header_id = p_move_order_header_id);
14207: END IF;

Line 14282: FROM wms_rules_b rules, bom_standard_operations bso , mtl_material_transactions_temp mmtt

14278: SELECT rules.rule_id
14279: , rules.type_hdr_id /* Added this Column */
14280: , mmtt.organization_id
14281: , mmtt.wms_task_type
14282: FROM wms_rules_b rules, bom_standard_operations bso , mtl_material_transactions_temp mmtt
14283: WHERE rules.type_code = 3
14284: AND rules.enabled_flag = 'Y'
14285: AND rules.type_hdr_id = bso.standard_operation_id
14286: AND bso.wms_task_type = NVL(mmtt.wms_task_type, bso.wms_task_type)

Line 14285: AND rules.type_hdr_id = bso.standard_operation_id

14281: , mmtt.wms_task_type
14282: FROM wms_rules_b rules, bom_standard_operations bso , mtl_material_transactions_temp mmtt
14283: WHERE rules.type_code = 3
14284: AND rules.enabled_flag = 'Y'
14285: AND rules.type_hdr_id = bso.standard_operation_id
14286: AND bso.wms_task_type = NVL(mmtt.wms_task_type, bso.wms_task_type)
14287: AND mmtt.transaction_temp_id = p_task_id
14288: AND rules.organization_id IN (mmtt.organization_id, -1)
14289: AND bso.organization_id = mmtt.organization_id

Line 14294: FROM wms_rules_b rules, bom_standard_operations bso

14290: ORDER BY rules.rule_weight DESC, rules.creation_date;
14291:
14292: /*CURSOR c_rules_new IS
14293: SELECT rules.rule_id , rules.type_hdr_id
14294: FROM wms_rules_b rules, bom_standard_operations bso
14295: WHERE rules.type_code = 3
14296: AND rules.enabled_flag = 'Y'
14297: AND rules.type_hdr_id = bso.standard_operation_id
14298: AND bso.wms_task_type = NVL(p_wms_task_type, bso.wms_task_type)

Line 14297: AND rules.type_hdr_id = bso.standard_operation_id

14293: SELECT rules.rule_id , rules.type_hdr_id
14294: FROM wms_rules_b rules, bom_standard_operations bso
14295: WHERE rules.type_code = 3
14296: AND rules.enabled_flag = 'Y'
14297: AND rules.type_hdr_id = bso.standard_operation_id
14298: AND bso.wms_task_type = NVL(p_wms_task_type, bso.wms_task_type)
14299: AND rules.organization_id IN (p_organization_id, -1)
14300: AND bso.organization_id = p_organization_id
14301: ORDER BY rules.rule_weight DESC, rules.creation_date; */

Line 14340: -- Standard call to check for call compatibility

14336: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
14337: END IF;
14338: l_debug := g_debug;
14339:
14340: -- Standard call to check for call compatibility
14341: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
14342: RAISE fnd_api.g_exc_unexpected_error;
14343: END IF;
14344:

Line 14406: SET mmtt.standard_operation_id = l_type_hdr_id

14402:
14403: -- update mmtt table to assign the task type
14404:
14405: UPDATE mtl_material_transactions_temp mmtt
14406: SET mmtt.standard_operation_id = l_type_hdr_id
14407: WHERE mmtt.transaction_temp_id = p_task_id;
14408: /*
14409: UPDATE mtl_material_transactions_temp mmtt
14410: SET mmtt.standard_operation_id = (SELECT type_hdr_id

Line 14410: SET mmtt.standard_operation_id = (SELECT type_hdr_id

14406: SET mmtt.standard_operation_id = l_type_hdr_id
14407: WHERE mmtt.transaction_temp_id = p_task_id;
14408: /*
14409: UPDATE mtl_material_transactions_temp mmtt
14410: SET mmtt.standard_operation_id = (SELECT type_hdr_id
14411: FROM wms_rules_b
14412: WHERE rule_id = l_rule_id)
14413: WHERE mmtt.transaction_temp_id = p_task_id
14414: */

Line 14499: SET mmtt.standard_operation_id = l_task_type_id

14495: --inv_log_util.TRACE('wms_task_type = 1, task_type_id=:' || l_task_type_id, 'RULE_ENGINE', 4);
14496: --inv_log_util.TRACE('before update statement', 'RULE_ENGINE', 4);
14497:
14498: UPDATE mtl_material_transactions_temp mmtt
14499: SET mmtt.standard_operation_id = l_task_type_id
14500: WHERE mmtt.transaction_temp_id = p_task_id;
14501:
14502: --inv_log_util.TRACE('after update statement: standard_operation_id:'||jxlu_soi, 'RULE_ENGINE', 4);
14503: END IF;

Line 14502: --inv_log_util.TRACE('after update statement: standard_operation_id:'||jxlu_soi, 'RULE_ENGINE', 4);

14498: UPDATE mtl_material_transactions_temp mmtt
14499: SET mmtt.standard_operation_id = l_task_type_id
14500: WHERE mmtt.transaction_temp_id = p_task_id;
14501:
14502: --inv_log_util.TRACE('after update statement: standard_operation_id:'||jxlu_soi, 'RULE_ENGINE', 4);
14503: END IF;
14504:
14505: -- Standard check of p_commit
14506: IF fnd_api.to_boolean(p_commit) THEN

Line 14505: -- Standard check of p_commit

14501:
14502: --inv_log_util.TRACE('after update statement: standard_operation_id:'||jxlu_soi, 'RULE_ENGINE', 4);
14503: END IF;
14504:
14505: -- Standard check of p_commit
14506: IF fnd_api.to_boolean(p_commit) THEN
14507: COMMIT WORK;
14508: END IF;
14509: EXCEPTION

Line 14699: -- Standard call to check for call compatibility

14695: TRACE('Executing ApplyLabel()...Label_request_ID : '|| p_label_request_id);
14696: TRACE('Number of rules to process(LL_CTR) :' || ll_ctr);
14697: END IF;
14698:
14699: -- Standard call to check for call compatibility
14700: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
14701: RAISE fnd_api.g_exc_unexpected_error;
14702: END IF;
14703:

Line 14840: -- Standard check of p_commit

14836: --
14837: x_label_format_id := l_label_format_id;
14838: x_label_format_name := l_label_format_name;
14839:
14840: -- Standard check of p_commit
14841: IF fnd_api.to_boolean(p_commit) THEN
14842: COMMIT WORK;
14843: END IF;
14844: EXCEPTION

Line 15018: -- API standard variables

15014: p_task_id IN NUMBER DEFAULT NULL
15015: )
15016: IS
15017:
15018: -- API standard variables
15019: l_api_version CONSTANT NUMBER := 1.0;
15020: l_api_name CONSTANT VARCHAR2(30) := 'QuickPick';
15021: l_debug_on BOOLEAN;
15022:

Line 15119: -- Standard start of API savepoint

15115: log_procedure(l_api_name, 'QuickPick', 'enter '|| g_pkg_name || '.' || l_api_name);
15116: END IF;
15117: -- end of debugging section
15118: --
15119: -- Standard start of API savepoint
15120: SAVEPOINT QuickPicksp;
15121:
15122: -- Standard call to check for call compatibility
15123: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

Line 15122: -- Standard call to check for call compatibility

15118: --
15119: -- Standard start of API savepoint
15120: SAVEPOINT QuickPicksp;
15121:
15122: -- Standard call to check for call compatibility
15123: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
15124: RAISE fnd_api.g_exc_unexpected_error;
15125: END IF;
15126: -- Initialize message list if p_init_msg_list is set to TRUE

Line 15665: -- p_api_version Standard Input Parameter

15661: -- If picking, quantity tree has to exist, created through
15662: -- INV_Quantity_Tree_PVT.Create_Tree and uniquely identified
15663: -- by parameter p_tree_id
15664: -- Parameters :
15665: -- p_api_version Standard Input Parameter
15666: -- p_init_msg_list Standard Input Parameter
15667: -- p_commit Standard Input Parameter
15668: -- p_validation_level Standard Input Parameter
15669: -- p_rule_id Identifier of the rule to apply

Line 15666: -- p_init_msg_list Standard Input Parameter

15662: -- INV_Quantity_Tree_PVT.Create_Tree and uniquely identified
15663: -- by parameter p_tree_id
15664: -- Parameters :
15665: -- p_api_version Standard Input Parameter
15666: -- p_init_msg_list Standard Input Parameter
15667: -- p_commit Standard Input Parameter
15668: -- p_validation_level Standard Input Parameter
15669: -- p_rule_id Identifier of the rule to apply
15670: -- p_type_code Type code of the rule

Line 15667: -- p_commit Standard Input Parameter

15663: -- by parameter p_tree_id
15664: -- Parameters :
15665: -- p_api_version Standard Input Parameter
15666: -- p_init_msg_list Standard Input Parameter
15667: -- p_commit Standard Input Parameter
15668: -- p_validation_level Standard Input Parameter
15669: -- p_rule_id Identifier of the rule to apply
15670: -- p_type_code Type code of the rule
15671: -- p_partial_success_allowed_flag

Line 15668: -- p_validation_level Standard Input Parameter

15664: -- Parameters :
15665: -- p_api_version Standard Input Parameter
15666: -- p_init_msg_list Standard Input Parameter
15667: -- p_commit Standard Input Parameter
15668: -- p_validation_level Standard Input Parameter
15669: -- p_rule_id Identifier of the rule to apply
15670: -- p_type_code Type code of the rule
15671: -- p_partial_success_allowed_flag
15672: -- 'Y' or 'N'

Line 15683: -- x_return_status Standard Output Parameter

15679: -- p_primary_uom Primary UOM code
15680: -- p_tree_id Identifier for the quantity tree
15681: --
15682: -- Output Parameters
15683: -- x_return_status Standard Output Parameter
15684: -- x_msg_count Standard Output Parameter
15685: -- x_msg_data Standard Output Parameter
15686: -- x_finished whether the rule has found enough quantity to
15687: -- find a location that completely satisfy

Line 15684: -- x_msg_count Standard Output Parameter

15680: -- p_tree_id Identifier for the quantity tree
15681: --
15682: -- Output Parameters
15683: -- x_return_status Standard Output Parameter
15684: -- x_msg_count Standard Output Parameter
15685: -- x_msg_data Standard Output Parameter
15686: -- x_finished whether the rule has found enough quantity to
15687: -- find a location that completely satisfy
15688: -- the requested quantity (value is 'Y' or 'N')

Line 15685: -- x_msg_data Standard Output Parameter

15681: --
15682: -- Output Parameters
15683: -- x_return_status Standard Output Parameter
15684: -- x_msg_count Standard Output Parameter
15685: -- x_msg_data Standard Output Parameter
15686: -- x_finished whether the rule has found enough quantity to
15687: -- find a location that completely satisfy
15688: -- the requested quantity (value is 'Y' or 'N')
15689: --

Line 15731: -- API standard variables

15727: , p_simulation_mode IN NUMBER
15728: , p_project_id IN NUMBER
15729: , p_task_id IN NUMBER
15730: ) IS
15731: -- API standard variables
15732: l_api_version CONSTANT NUMBER := 1.0;
15733: l_api_name CONSTANT VARCHAR2(30) := 'Apply';
15734: -- variables needed for dynamic SQL
15735: l_cursor INTEGER;

Line 15935: -- Standard start of API savepoint

15931: log_procedure(l_api_name, 'start', 'Start Apply');
15932: END IF;
15933: -- end of debugging section
15934: --
15935: -- Standard start of API savepoint
15936: SAVEPOINT applyrulesp;
15937:
15938: -- Standard call to check for call compatibility
15939: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

Line 15938: -- Standard call to check for call compatibility

15934: --
15935: -- Standard start of API savepoint
15936: SAVEPOINT applyrulesp;
15937:
15938: -- Standard call to check for call compatibility
15939: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
15940: RAISE fnd_api.g_exc_unexpected_error;
15941: END IF;
15942: