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 8440: -- p_api_version Standard Input Parameter

8436: -- If picking, quantity tree has to exist, created through
8437: -- INV_Quantity_Tree_PVT.Create_Tree and uniquely identified
8438: -- by parameter p_tree_id
8439: -- Parameters :
8440: -- p_api_version Standard Input Parameter
8441: -- p_init_msg_list Standard Input Parameter
8442: -- p_commit Standard Input Parameter
8443: -- p_validation_level Standard Input Parameter
8444: -- p_rule_id Identifier of the rule to apply

Line 8441: -- p_init_msg_list Standard Input Parameter

8437: -- INV_Quantity_Tree_PVT.Create_Tree and uniquely identified
8438: -- by parameter p_tree_id
8439: -- Parameters :
8440: -- p_api_version Standard Input Parameter
8441: -- p_init_msg_list Standard Input Parameter
8442: -- p_commit Standard Input Parameter
8443: -- p_validation_level Standard Input Parameter
8444: -- p_rule_id Identifier of the rule to apply
8445: -- p_type_code Type code of the rule

Line 8442: -- p_commit Standard Input Parameter

8438: -- by parameter p_tree_id
8439: -- Parameters :
8440: -- p_api_version Standard Input Parameter
8441: -- p_init_msg_list Standard Input Parameter
8442: -- p_commit Standard Input Parameter
8443: -- p_validation_level Standard Input Parameter
8444: -- p_rule_id Identifier of the rule to apply
8445: -- p_type_code Type code of the rule
8446: -- p_partial_success_allowed_flag

Line 8443: -- p_validation_level Standard Input Parameter

8439: -- Parameters :
8440: -- p_api_version Standard Input Parameter
8441: -- p_init_msg_list Standard Input Parameter
8442: -- p_commit Standard Input Parameter
8443: -- p_validation_level Standard Input Parameter
8444: -- p_rule_id Identifier of the rule to apply
8445: -- p_type_code Type code of the rule
8446: -- p_partial_success_allowed_flag
8447: -- 'Y' or 'N'

Line 8458: -- x_return_status Standard Output Parameter

8454: -- p_primary_uom Primary UOM code
8455: -- p_tree_id Identifier for the quantity tree
8456: --
8457: -- Output Parameters
8458: -- x_return_status Standard Output Parameter
8459: -- x_msg_count Standard Output Parameter
8460: -- x_msg_data Standard Output Parameter
8461: -- x_finished whether the rule has found enough quantity to
8462: -- find a location that completely satisfy

Line 8459: -- x_msg_count Standard Output Parameter

8455: -- p_tree_id Identifier for the quantity tree
8456: --
8457: -- Output Parameters
8458: -- x_return_status Standard Output Parameter
8459: -- x_msg_count Standard Output Parameter
8460: -- x_msg_data Standard Output Parameter
8461: -- x_finished whether the rule has found enough quantity to
8462: -- find a location that completely satisfy
8463: -- the requested quantity (value is 'Y' or 'N')

Line 8460: -- x_msg_data Standard Output Parameter

8456: --
8457: -- Output Parameters
8458: -- x_return_status Standard Output Parameter
8459: -- x_msg_count Standard Output Parameter
8460: -- x_msg_data Standard Output Parameter
8461: -- x_finished whether the rule has found enough quantity to
8462: -- find a location that completely satisfy
8463: -- the requested quantity (value is 'Y' or 'N')
8464: --

Line 8509: -- API standard variables

8505: , p_project_id IN NUMBER
8506: , p_task_id IN NUMBER
8507: , p_wave_simulation_mode IN VARCHAR2 DEFAULT 'N'
8508: ) IS
8509: -- API standard variables
8510: l_api_version CONSTANT NUMBER := 1.0;
8511: l_api_name CONSTANT VARCHAR2(30) := 'Apply';
8512: -- variables needed for dynamic SQL
8513: l_cursor INTEGER;

Line 8742: -- Standard start of API savepoint

8738: log_event(l_api_name, 'Apply ', 'item_id '||p_inventory_item_id);
8739: END IF;
8740: -- end of debugging section
8741: --
8742: -- Standard start of API savepoint
8743: SAVEPOINT applyrulesp;
8744:
8745: -- Standard call to check for call compatibility
8746: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

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

8741: --
8742: -- Standard start of API savepoint
8743: SAVEPOINT applyrulesp;
8744:
8745: -- Standard call to check for call compatibility
8746: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
8747: RAISE fnd_api.g_exc_unexpected_error;
8748: END IF;
8749:

Line 13431: -- Standard check of p_commit

13427: NULL;
13428: END LOOP; --} input records
13429:
13430: --
13431: -- Standard check of p_commit
13432: IF fnd_api.to_boolean(p_commit) THEN
13433: COMMIT WORK;
13434: END IF;
13435:

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

13833: END IF;
13834:
13835: -- Now get the cost group. If the to_cost_group is specified
13836: -- on the move order, then use that. If not, query the default
13837: -- cost group for the subinventory if in a standard costing org.
13838: -- If not defined there, or if avg. costing org
13839: -- try to get the default cost group from the organization
13840:
13841: IF p_to_cost_group_id IS NULL THEN

Line 13926: -- p_api_version Standard Input Parameter

13922: -- to check capacity.
13923: -- Pre-reqs :
13924: --
13925: -- Parameters :
13926: -- p_api_version Standard Input Parameter
13927: -- p_init_msg_list Standard Input Parameter
13928: -- p_commit Standard Input Parameter
13929: -- p_validation_level Standard Input Parameter
13930: -- p_transaction_temp_id Identifier for the record in view

Line 13927: -- p_init_msg_list Standard Input Parameter

13923: -- Pre-reqs :
13924: --
13925: -- Parameters :
13926: -- p_api_version Standard Input Parameter
13927: -- p_init_msg_list Standard Input Parameter
13928: -- p_commit Standard Input Parameter
13929: -- p_validation_level Standard Input Parameter
13930: -- p_transaction_temp_id Identifier for the record in view
13931: -- wms_strategy_mat_txn_tmp_v that represents

Line 13928: -- p_commit Standard Input Parameter

13924: --
13925: -- Parameters :
13926: -- p_api_version Standard Input Parameter
13927: -- p_init_msg_list Standard Input Parameter
13928: -- p_commit Standard Input Parameter
13929: -- p_validation_level Standard Input Parameter
13930: -- p_transaction_temp_id Identifier for the record in view
13931: -- wms_strategy_mat_txn_tmp_v that represents
13932: -- the request for detailing

Line 13929: -- p_validation_level Standard Input Parameter

13925: -- Parameters :
13926: -- p_api_version Standard Input Parameter
13927: -- p_init_msg_list Standard Input Parameter
13928: -- p_commit Standard Input Parameter
13929: -- p_validation_level Standard Input Parameter
13930: -- p_transaction_temp_id Identifier for the record in view
13931: -- wms_strategy_mat_txn_tmp_v that represents
13932: -- the request for detailing
13933: -- p_organization_id Organization identifier

Line 13941: -- x_return_status Standard Output Parameter

13937: -- p_project_id Project associated with transaction
13938: -- p_task_id Task associated with transaction
13939: --
13940: -- Output Parameters
13941: -- x_return_status Standard Output Parameter
13942: -- x_msg_count Standard Output Parameter
13943: -- x_msg_data Standard Output Parameter
13944: -- x_finished whether the rule has found enough quantity to
13945: -- find a location that completely satisfy

Line 13942: -- x_msg_count Standard Output Parameter

13938: -- p_task_id Task associated with transaction
13939: --
13940: -- Output Parameters
13941: -- x_return_status Standard Output Parameter
13942: -- x_msg_count Standard Output Parameter
13943: -- x_msg_data Standard Output Parameter
13944: -- x_finished whether the rule has found enough quantity to
13945: -- find a location that completely satisfy
13946: -- the requested quantity (value is 'Y' or 'N')

Line 13943: -- x_msg_data Standard Output Parameter

13939: --
13940: -- Output Parameters
13941: -- x_return_status Standard Output Parameter
13942: -- x_msg_count Standard Output Parameter
13943: -- x_msg_data Standard Output Parameter
13944: -- x_finished whether the rule has found enough quantity to
13945: -- find a location that completely satisfy
13946: -- the requested quantity (value is 'Y' or 'N')
13947: --

Line 13979: -- API standard variables

13975: p_task_id IN NUMBER
13976: )
13977: IS
13978:
13979: -- API standard variables
13980: l_api_version constant number := 1.0;
13981: l_api_name constant varchar2(30) := 'ApplyDefLoc';
13982: -- variables needed for dynamic SQL
13983: l_cursor integer;

Line 14057: -- Standard start of API savepoint

14053: log_procedure(l_api_name, 'start', 'Start ApplyDefLoc');
14054: End if;
14055: -- end of debugging section
14056:
14057: -- Standard start of API savepoint
14058: SAVEPOINT ApplyRuleSP;
14059: --
14060:
14061:

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

14058: SAVEPOINT ApplyRuleSP;
14059: --
14060:
14061:
14062: -- Standard call to check for call compatibility
14063: IF NOT fnd_api.compatible_api_call( l_api_version
14064: ,p_api_version
14065: ,l_api_name
14066: ,g_pkg_name ) THEN

Line 14697: -- Standard check of p_commit

14693: END IF;
14694:
14695: END LOOP; -- input records
14696: --
14697: -- Standard check of p_commit
14698: IF fnd_api.to_boolean(p_commit) THEN
14699: COMMIT WORK;
14700: END IF;
14701: --

Line 14759: -- p_api_version Standard Input Parameter

14755: -- called from the WMS_RULES form
14756: -- Pre-reqs : one record in WMS_RULES_B uniquely identified by parameter
14757: -- p_rule_id
14758: -- Input Parameters :
14759: -- p_api_version Standard Input Parameter
14760: -- p_init_msg_list Standard Input Parameter
14761: -- p_validation_level Standard Input Parameter
14762: -- p_rule_id Identifier of the rule to check
14763: --

Line 14760: -- p_init_msg_list Standard Input Parameter

14756: -- Pre-reqs : one record in WMS_RULES_B uniquely identified by parameter
14757: -- p_rule_id
14758: -- Input Parameters :
14759: -- p_api_version Standard Input Parameter
14760: -- p_init_msg_list Standard Input Parameter
14761: -- p_validation_level Standard Input Parameter
14762: -- p_rule_id Identifier of the rule to check
14763: --
14764: -- Output Parameters :

Line 14761: -- p_validation_level Standard Input Parameter

14757: -- p_rule_id
14758: -- Input Parameters :
14759: -- p_api_version Standard Input Parameter
14760: -- p_init_msg_list Standard Input Parameter
14761: -- p_validation_level Standard Input Parameter
14762: -- p_rule_id Identifier of the rule to check
14763: --
14764: -- Output Parameters :
14765: -- x_return_status Standard Output Parameter

Line 14765: -- x_return_status Standard Output Parameter

14761: -- p_validation_level Standard Input Parameter
14762: -- p_rule_id Identifier of the rule to check
14763: --
14764: -- Output Parameters :
14765: -- x_return_status Standard Output Parameter
14766: -- x_msg_count Standard Output Parameter
14767: -- x_msg_data Standard Output Parameter
14768: --
14769: -- Version :

Line 14766: -- x_msg_count Standard Output Parameter

14762: -- p_rule_id Identifier of the rule to check
14763: --
14764: -- Output Parameters :
14765: -- x_return_status Standard Output Parameter
14766: -- x_msg_count Standard Output Parameter
14767: -- x_msg_data Standard Output Parameter
14768: --
14769: -- Version :
14770: -- Current version 1.0

Line 14767: -- x_msg_data Standard Output Parameter

14763: --
14764: -- Output Parameters :
14765: -- x_return_status Standard Output Parameter
14766: -- x_msg_count Standard Output Parameter
14767: -- x_msg_data Standard Output Parameter
14768: --
14769: -- Version :
14770: -- Current version 1.0
14771: --

Line 14784: -- API standard variables

14780: , x_msg_data OUT NOCOPY VARCHAR2
14781: , p_rule_id IN NUMBER
14782: ) IS
14783: PRAGMA AUTONOMOUS_TRANSACTION;
14784: -- API standard variables
14785: l_api_version CONSTANT NUMBER := 1.0;
14786: l_api_name CONSTANT VARCHAR2(30) := 'CheckSyntax';
14787: --
14788: --

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

14787: --
14788: --
14789: BEGIN
14790: --
14791: -- Standard call to check for call compatibility
14792: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
14793: RAISE fnd_api.g_exc_unexpected_error;
14794: END IF;
14795:

Line 14839: -- p_api_version Standard Input Parameter

14835: -- API name : Find_Rule
14836: -- Type : Private
14837: -- Function : find a rule by id
14838: -- Input Parameters :
14839: -- p_api_version Standard Input Parameter
14840: -- p_init_msg_list Standard Input Parameter
14841: -- p_rule_id Identifier of the rule
14842: --
14843: -- Output Parameters:

Line 14840: -- p_init_msg_list Standard Input Parameter

14836: -- Type : Private
14837: -- Function : find a rule by id
14838: -- Input Parameters :
14839: -- p_api_version Standard Input Parameter
14840: -- p_init_msg_list Standard Input Parameter
14841: -- p_rule_id Identifier of the rule
14842: --
14843: -- Output Parameters:
14844: -- x_return_status Standard Output Parameter

Line 14844: -- x_return_status Standard Output Parameter

14840: -- p_init_msg_list Standard Input Parameter
14841: -- p_rule_id Identifier of the rule
14842: --
14843: -- Output Parameters:
14844: -- x_return_status Standard Output Parameter
14845: -- x_msg_count Standard Output Parameter
14846: -- x_msg_data Standard Output Parameter
14847: -- x_found true if found ; else false
14848: -- x_rule_rec info of the rule if found

Line 14845: -- x_msg_count Standard Output Parameter

14841: -- p_rule_id Identifier of the rule
14842: --
14843: -- Output Parameters:
14844: -- x_return_status Standard Output Parameter
14845: -- x_msg_count Standard Output Parameter
14846: -- x_msg_data Standard Output Parameter
14847: -- x_found true if found ; else false
14848: -- x_rule_rec info of the rule if found
14849:

Line 14846: -- x_msg_data Standard Output Parameter

14842: --
14843: -- Output Parameters:
14844: -- x_return_status Standard Output Parameter
14845: -- x_msg_count Standard Output Parameter
14846: -- x_msg_data Standard Output Parameter
14847: -- x_found true if found ; else false
14848: -- x_rule_rec info of the rule if found
14849:
14850: -- Version :

Line 14865: -- API standard variables

14861: , p_rule_id IN NUMBER
14862: , x_found OUT NOCOPY BOOLEAN
14863: , x_rule_rec OUT NOCOPY rule_rec
14864: ) IS
14865: -- API standard variables
14866: l_api_version CONSTANT NUMBER := 1.0;
14867: l_api_name CONSTANT VARCHAR2(30) := 'Find_Rule';
14868:
14869: --

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

14932: END find_rule;
14933:
14934: --GetPackageName
14935: --
14936: --This function establishes the naming standard for the rule packages.
14937: --Currently, the naming standard is WMS_RULE_## , where ## is rule id
14938: PROCEDURE getpackagename(p_rule_id IN NUMBER, x_package_name OUT NOCOPY VARCHAR2) IS
14939: BEGIN
14940: x_package_name := 'WMS_RULE_' || p_rule_id;

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

14933:
14934: --GetPackageName
14935: --
14936: --This function establishes the naming standard for the rule packages.
14937: --Currently, the naming standard is WMS_RULE_## , where ## is rule id
14938: PROCEDURE getpackagename(p_rule_id IN NUMBER, x_package_name OUT NOCOPY VARCHAR2) IS
14939: BEGIN
14940: x_package_name := 'WMS_RULE_' || p_rule_id;
14941: END getpackagename;

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

14981: l_row := l_row + 1;
14982: --Get substring from package_string
14983: g_build_package_tbl(l_row) := SUBSTR(p_package_string, l_cur_start, l_num_chars);
14984: --Call build package to add row
14985: -- We may need to call this API for AOL standards.
14986: --ad_ddl.build_package(l_cur_string, l_row);
14987:
14988: --increment pointers
14989: l_cur_start := l_cur_start + l_num_chars;

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

15042: DBMS_SQL.parse(l_cursor, g_build_package_tbl, 1, g_build_package_row, FALSE, DBMS_SQL.native);
15043: --close cursor
15044: DBMS_SQL.close_cursor(l_cursor);
15045:
15046: /* We may need to call this API for AOL standards
15047: --get schema info
15048: l_return := fnd_installation.get_app_info(
15049: application_short_name => 'FND'
15050: ,status => l_status

Line 15110: -- p_api_version Standard Input Parameter

15106: -- Type : Private
15107: -- Function : generate a package for a rule that can be used in
15108: -- picking and put away
15109: -- Input Parameters :
15110: -- p_api_version Standard Input Parameter
15111: -- p_init_msg_list Standard Input Parameter
15112: -- p_validation_level Standard Input Parameter
15113: -- p_rule_id Identifier of the rule
15114: --

Line 15111: -- p_init_msg_list Standard Input Parameter

15107: -- Function : generate a package for a rule that can be used in
15108: -- picking and put away
15109: -- Input Parameters :
15110: -- p_api_version Standard Input Parameter
15111: -- p_init_msg_list Standard Input Parameter
15112: -- p_validation_level Standard Input Parameter
15113: -- p_rule_id Identifier of the rule
15114: --
15115: -- Output Parameters:

Line 15112: -- p_validation_level Standard Input Parameter

15108: -- picking and put away
15109: -- Input Parameters :
15110: -- p_api_version Standard Input Parameter
15111: -- p_init_msg_list Standard Input Parameter
15112: -- p_validation_level Standard Input Parameter
15113: -- p_rule_id Identifier of the rule
15114: --
15115: -- Output Parameters:
15116: -- x_return_status Standard Output Parameter

Line 15116: -- x_return_status Standard Output Parameter

15112: -- p_validation_level Standard Input Parameter
15113: -- p_rule_id Identifier of the rule
15114: --
15115: -- Output Parameters:
15116: -- x_return_status Standard Output Parameter
15117: -- x_msg_count Standard Output Parameter
15118: -- x_msg_data Standard Output Parameter
15119: --
15120: -- Called by the WMS Rules form (WMSRULEF.fmb), this function

Line 15117: -- x_msg_count Standard Output Parameter

15113: -- p_rule_id Identifier of the rule
15114: --
15115: -- Output Parameters:
15116: -- x_return_status Standard Output Parameter
15117: -- x_msg_count Standard Output Parameter
15118: -- x_msg_data Standard Output Parameter
15119: --
15120: -- Called by the WMS Rules form (WMSRULEF.fmb), this function
15121: -- creates a package for the given rule. The package has three

Line 15118: -- x_msg_data Standard Output Parameter

15114: --
15115: -- Output Parameters:
15116: -- x_return_status Standard Output Parameter
15117: -- x_msg_count Standard Output Parameter
15118: -- x_msg_data Standard Output Parameter
15119: --
15120: -- Called by the WMS Rules form (WMSRULEF.fmb), this function
15121: -- creates a package for the given rule. The package has three
15122: -- functions, open_curs, fetch_one_row, and close_curs. Open_curs

Line 15143: -- API standard variables

15139: , x_msg_count OUT NOCOPY NUMBER
15140: , x_msg_data OUT NOCOPY VARCHAR2
15141: , p_rule_id IN NUMBER
15142: ) IS
15143: -- API standard variables
15144: l_api_version CONSTANT NUMBER := 1.0;
15145: l_api_name CONSTANT VARCHAR2(30) := 'GenerateRulePackage';
15146: --
15147: -- variables needed for dynamic SQL

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

15177: WHERE mpr.rule_id = p_rule_id;
15178: --
15179: BEGIN
15180: --
15181: -- Standard call to check for call compatibility
15182: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
15183: RAISE fnd_api.g_exc_unexpected_error;
15184: END IF;
15185:

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

16613: l_rule_counter INTEGER;
16614: BEGIN
16615: SAVEPOINT assign_operation_plan_sp;
16616:
16617: -- Standard call to check for call compatibility
16618: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
16619: RAISE fnd_api.g_exc_unexpected_error;
16620: END IF;
16621:

Line 16718: -- Standard check of p_commit

16714: SET mmtt.operation_plan_id = l_operation_plan_id
16715: WHERE mmtt.transaction_temp_id = p_task_id;
16716: END IF;
16717:
16718: -- Standard check of p_commit
16719: IF fnd_api.to_boolean(p_commit) THEN
16720: COMMIT WORK;
16721: END IF;
16722: EXCEPTION

Line 16785: WHERE mmtt.standard_operation_id IS NULL

16781: SELECT mmtt.transaction_temp_id
16782: ,mmtt.organization_id -- Added new
16783: ,mmtt.wms_task_type -- Added new
16784: FROM mtl_material_transactions_temp mmtt, mtl_txn_request_lines mol
16785: WHERE mmtt.standard_operation_id IS NULL
16786: AND mmtt.move_order_line_id = mol.line_id
16787: AND mol.header_id = p_move_order_header_id;
16788:
16789: l_task_id NUMBER;

Line 16815: WHERE mmtt.standard_operation_id IS NULL

16811: AND (organization_id = -1
16812: OR organization_id IN (SELECT mmtt.organization_id
16813: FROM mtl_material_transactions_temp mmtt,
16814: mtl_txn_request_lines mol
16815: WHERE mmtt.standard_operation_id IS NULL
16816: AND mmtt.move_order_line_id = mol.line_id
16817: AND mol.header_id = p_move_order_header_id)));
16818: EXCEPTION
16819: WHEN OTHERS THEN

Line 16852: SET standard_operation_id =

16848: -- Bug# 4587423
16849: -- No valid rules exist for task type assignment so just stamp the org level
16850: -- default task type for the given WMS task type on the MMTT record.
16851: UPDATE mtl_material_transactions_temp mmtt
16852: SET standard_operation_id =
16853: (SELECT DECODE(mmtt.wms_task_type, 1, default_pick_task_type_id,
16854: 2, default_putaway_task_type_id,
16855: 3, default_cc_task_type_id,
16856: 4, default_repl_task_type_id,

Line 16861: WHERE mmtt.standard_operation_id IS NULL

16857: 5, default_moxfer_task_type_id,
16858: 6, default_moissue_task_type_id,
16859: NULL)
16860: FROM mtl_parameters mp WHERE mp.organization_id = mmtt.organization_id)
16861: WHERE mmtt.standard_operation_id IS NULL
16862: AND mmtt.move_order_line_id IN (SELECT line_id
16863: FROM mtl_txn_request_lines mol
16864: WHERE mol.header_id = p_move_order_header_id);
16865: END IF;

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

16936: SELECT rules.rule_id
16937: , rules.type_hdr_id /* Added this Column */
16938: , mmtt.organization_id
16939: , mmtt.wms_task_type
16940: FROM wms_rules_b rules, bom_standard_operations bso , mtl_material_transactions_temp mmtt
16941: WHERE rules.type_code = 3
16942: AND rules.enabled_flag = 'Y'
16943: AND rules.type_hdr_id = bso.standard_operation_id
16944: AND bso.wms_task_type = NVL(mmtt.wms_task_type, bso.wms_task_type)

Line 16943: AND rules.type_hdr_id = bso.standard_operation_id

16939: , mmtt.wms_task_type
16940: FROM wms_rules_b rules, bom_standard_operations bso , mtl_material_transactions_temp mmtt
16941: WHERE rules.type_code = 3
16942: AND rules.enabled_flag = 'Y'
16943: AND rules.type_hdr_id = bso.standard_operation_id
16944: AND bso.wms_task_type = NVL(mmtt.wms_task_type, bso.wms_task_type)
16945: AND mmtt.transaction_temp_id = p_task_id
16946: AND rules.organization_id IN (mmtt.organization_id, -1)
16947: AND bso.organization_id = mmtt.organization_id

Line 16952: FROM wms_rules_b rules, bom_standard_operations bso

16948: ORDER BY rules.rule_weight DESC, rules.creation_date;
16949:
16950: /*CURSOR c_rules_new IS
16951: SELECT rules.rule_id , rules.type_hdr_id
16952: FROM wms_rules_b rules, bom_standard_operations bso
16953: WHERE rules.type_code = 3
16954: AND rules.enabled_flag = 'Y'
16955: AND rules.type_hdr_id = bso.standard_operation_id
16956: AND bso.wms_task_type = NVL(p_wms_task_type, bso.wms_task_type)

Line 16955: AND rules.type_hdr_id = bso.standard_operation_id

16951: SELECT rules.rule_id , rules.type_hdr_id
16952: FROM wms_rules_b rules, bom_standard_operations bso
16953: WHERE rules.type_code = 3
16954: AND rules.enabled_flag = 'Y'
16955: AND rules.type_hdr_id = bso.standard_operation_id
16956: AND bso.wms_task_type = NVL(p_wms_task_type, bso.wms_task_type)
16957: AND rules.organization_id IN (p_organization_id, -1)
16958: AND bso.organization_id = p_organization_id
16959: ORDER BY rules.rule_weight DESC, rules.creation_date; */

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

16987: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
16988: END IF;
16989: l_debug := g_debug;
16990:
16991: -- Standard call to check for call compatibility
16992: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
16993: RAISE fnd_api.g_exc_unexpected_error;
16994: END IF;
16995:

Line 17057: SET mmtt.standard_operation_id = l_type_hdr_id

17053:
17054: -- update mmtt table to assign the task type
17055:
17056: UPDATE mtl_material_transactions_temp mmtt
17057: SET mmtt.standard_operation_id = l_type_hdr_id
17058: WHERE mmtt.transaction_temp_id = p_task_id;
17059: /*
17060: UPDATE mtl_material_transactions_temp mmtt
17061: SET mmtt.standard_operation_id = (SELECT type_hdr_id

Line 17061: SET mmtt.standard_operation_id = (SELECT type_hdr_id

17057: SET mmtt.standard_operation_id = l_type_hdr_id
17058: WHERE mmtt.transaction_temp_id = p_task_id;
17059: /*
17060: UPDATE mtl_material_transactions_temp mmtt
17061: SET mmtt.standard_operation_id = (SELECT type_hdr_id
17062: FROM wms_rules_b
17063: WHERE rule_id = l_rule_id)
17064: WHERE mmtt.transaction_temp_id = p_task_id
17065: */

Line 17150: SET mmtt.standard_operation_id = l_task_type_id

17146: --inv_log_util.TRACE('wms_task_type = 1, task_type_id=:' || l_task_type_id, 'RULE_ENGINE', 4);
17147: --inv_log_util.TRACE('before update statement', 'RULE_ENGINE', 4);
17148:
17149: UPDATE mtl_material_transactions_temp mmtt
17150: SET mmtt.standard_operation_id = l_task_type_id
17151: WHERE mmtt.transaction_temp_id = p_task_id;
17152:
17153: --inv_log_util.TRACE('after update statement: standard_operation_id:'||jxlu_soi, 'RULE_ENGINE', 4);
17154: END IF;

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

17149: UPDATE mtl_material_transactions_temp mmtt
17150: SET mmtt.standard_operation_id = l_task_type_id
17151: WHERE mmtt.transaction_temp_id = p_task_id;
17152:
17153: --inv_log_util.TRACE('after update statement: standard_operation_id:'||jxlu_soi, 'RULE_ENGINE', 4);
17154: END IF;
17155:
17156: -- Standard check of p_commit
17157: IF fnd_api.to_boolean(p_commit) THEN

Line 17156: -- Standard check of p_commit

17152:
17153: --inv_log_util.TRACE('after update statement: standard_operation_id:'||jxlu_soi, 'RULE_ENGINE', 4);
17154: END IF;
17155:
17156: -- Standard check of p_commit
17157: IF fnd_api.to_boolean(p_commit) THEN
17158: COMMIT WORK;
17159: END IF;
17160: EXCEPTION

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

17340: TRACE('Executing ApplyLabel()...Label_request_ID : '|| p_label_request_id);
17341: TRACE('Number of rules to process(LL_CTR) :' || ll_ctr);
17342: END IF;
17343:
17344: -- Standard call to check for call compatibility
17345: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
17346: RAISE fnd_api.g_exc_unexpected_error;
17347: END IF;
17348:

Line 17485: -- Standard check of p_commit

17481: --
17482: x_label_format_id := l_label_format_id;
17483: x_label_format_name := l_label_format_name;
17484:
17485: -- Standard check of p_commit
17486: IF fnd_api.to_boolean(p_commit) THEN
17487: COMMIT WORK;
17488: END IF;
17489: EXCEPTION

Line 17676: -- API standard variables

17672: p_task_id IN NUMBER DEFAULT NULL
17673: )
17674: IS
17675:
17676: -- API standard variables
17677: l_api_version CONSTANT NUMBER := 1.0;
17678: l_api_name CONSTANT VARCHAR2(30) := 'QuickPick';
17679: l_debug_on BOOLEAN;
17680:

Line 17777: -- Standard start of API savepoint

17773: log_procedure(l_api_name, 'QuickPick', 'enter '|| g_pkg_name || '.' || l_api_name);
17774: END IF;
17775: -- end of debugging section
17776: --
17777: -- Standard start of API savepoint
17778: SAVEPOINT QuickPicksp;
17779:
17780: -- Standard call to check for call compatibility
17781: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

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

17776: --
17777: -- Standard start of API savepoint
17778: SAVEPOINT QuickPicksp;
17779:
17780: -- Standard call to check for call compatibility
17781: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
17782: RAISE fnd_api.g_exc_unexpected_error;
17783: END IF;
17784: -- Initialize message list if p_init_msg_list is set to TRUE

Line 18330: -- p_api_version Standard Input Parameter

18326: -- If picking, quantity tree has to exist, created through
18327: -- INV_Quantity_Tree_PVT.Create_Tree and uniquely identified
18328: -- by parameter p_tree_id
18329: -- Parameters :
18330: -- p_api_version Standard Input Parameter
18331: -- p_init_msg_list Standard Input Parameter
18332: -- p_commit Standard Input Parameter
18333: -- p_validation_level Standard Input Parameter
18334: -- p_rule_id Identifier of the rule to apply

Line 18331: -- p_init_msg_list Standard Input Parameter

18327: -- INV_Quantity_Tree_PVT.Create_Tree and uniquely identified
18328: -- by parameter p_tree_id
18329: -- Parameters :
18330: -- p_api_version Standard Input Parameter
18331: -- p_init_msg_list Standard Input Parameter
18332: -- p_commit Standard Input Parameter
18333: -- p_validation_level Standard Input Parameter
18334: -- p_rule_id Identifier of the rule to apply
18335: -- p_type_code Type code of the rule

Line 18332: -- p_commit Standard Input Parameter

18328: -- by parameter p_tree_id
18329: -- Parameters :
18330: -- p_api_version Standard Input Parameter
18331: -- p_init_msg_list Standard Input Parameter
18332: -- p_commit Standard Input Parameter
18333: -- p_validation_level Standard Input Parameter
18334: -- p_rule_id Identifier of the rule to apply
18335: -- p_type_code Type code of the rule
18336: -- p_partial_success_allowed_flag

Line 18333: -- p_validation_level Standard Input Parameter

18329: -- Parameters :
18330: -- p_api_version Standard Input Parameter
18331: -- p_init_msg_list Standard Input Parameter
18332: -- p_commit Standard Input Parameter
18333: -- p_validation_level Standard Input Parameter
18334: -- p_rule_id Identifier of the rule to apply
18335: -- p_type_code Type code of the rule
18336: -- p_partial_success_allowed_flag
18337: -- 'Y' or 'N'

Line 18348: -- x_return_status Standard Output Parameter

18344: -- p_primary_uom Primary UOM code
18345: -- p_tree_id Identifier for the quantity tree
18346: --
18347: -- Output Parameters
18348: -- x_return_status Standard Output Parameter
18349: -- x_msg_count Standard Output Parameter
18350: -- x_msg_data Standard Output Parameter
18351: -- x_finished whether the rule has found enough quantity to
18352: -- find a location that completely satisfy

Line 18349: -- x_msg_count Standard Output Parameter

18345: -- p_tree_id Identifier for the quantity tree
18346: --
18347: -- Output Parameters
18348: -- x_return_status Standard Output Parameter
18349: -- x_msg_count Standard Output Parameter
18350: -- x_msg_data Standard Output Parameter
18351: -- x_finished whether the rule has found enough quantity to
18352: -- find a location that completely satisfy
18353: -- the requested quantity (value is 'Y' or 'N')

Line 18350: -- x_msg_data Standard Output Parameter

18346: --
18347: -- Output Parameters
18348: -- x_return_status Standard Output Parameter
18349: -- x_msg_count Standard Output Parameter
18350: -- x_msg_data Standard Output Parameter
18351: -- x_finished whether the rule has found enough quantity to
18352: -- find a location that completely satisfy
18353: -- the requested quantity (value is 'Y' or 'N')
18354: --

Line 18396: -- API standard variables

18392: , p_simulation_mode IN NUMBER
18393: , p_project_id IN NUMBER
18394: , p_task_id IN NUMBER
18395: ) IS
18396: -- API standard variables
18397: l_api_version CONSTANT NUMBER := 1.0;
18398: l_api_name CONSTANT VARCHAR2(30) := 'Apply';
18399: -- variables needed for dynamic SQL
18400: l_cursor INTEGER;

Line 18575: -- Standard start of API savepoint

18571: log_procedure(l_api_name, 'start', 'Start Apply');
18572: END IF;
18573: -- end of debugging section
18574: --
18575: -- Standard start of API savepoint
18576: SAVEPOINT applyrulesp;
18577:
18578: -- Standard call to check for call compatibility
18579: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

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

18574: --
18575: -- Standard start of API savepoint
18576: SAVEPOINT applyrulesp;
18577:
18578: -- Standard call to check for call compatibility
18579: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
18580: RAISE fnd_api.g_exc_unexpected_error;
18581: END IF;
18582: