DBA Data[Home] [Help]

APPS.WMS_ATF_RUNTIME_PUB_APIS dependencies on FND_PROFILE

Line 142: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

138: WHERE source_task_id=p_source_task_id
139: AND activity_type_id=p_activity_id;
140:
141:
142: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
143: l_module_name VARCHAR2(30) := 'Init_OP_Plan_Instance';
144: l_progress NUMBER;
145:
146: l_inbound_doc_rec inbound_document_details%ROWTYPE :=NULL;

Line 752: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'),0);

748: p_activity_type_id IN NUMBER,
749: p_inventory_item_id IN NUMBER
750: ) IS
751:
752: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'),0);
753: l_module_name VARCHAR2(30) := 'Determine_Attributes';
754: l_progress VARCHAR2(30) := '0';
755:
756: l_attributes WMS_OP_INBOUND_PVT.DEST_PARAM_REC_TYPE;

Line 1765: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

1761: l_sug_to_lpn_id NUMBER;
1762: l_dest_param_rec WMS_OP_INBOUND_PVT.DEST_PARAM_REC_TYPE;
1763: l_operation_type_id NUMBER;
1764:
1765: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1766: l_module_name VARCHAR2(30) := 'Activate_Operation_Instance';
1767: l_progress NUMBER;
1768:
1769: l_return_status VARCHAR2(1);

Line 2517: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

2513: ,p_activity_id IN NUMBER
2514: ,p_operation_type_id IN NUMBER )
2515: IS
2516:
2517: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2518: l_module_name VARCHAR2(30) := 'Complete_Operation_Instance';
2519: l_progress NUMBER;
2520: l_return_status VARCHAR2(1);
2521: l_msg_count NUMBER;

Line 4112: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

4108: AND organization_id = p_organization_id
4109: GROUP BY lpn_id,inventory_item_id,lot_number,revision;
4110:
4111:
4112: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
4113: l_module_name VARCHAR2(30) := 'Validate_Operation';
4114: l_progress NUMBER ;
4115:
4116: l_inspection_status NUMBER:=-1;

Line 5016: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

5012: l_n_return_status NUMBER;
5013: l_lot_trx_id NUMBER;
5014: l_proc_msg VARCHAR2(500);
5015: l_progress NUMBER;
5016: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
5017: l_module_name VARCHAR2(30) := 'Split_operation_instance';
5018:
5019:
5020: /* BEGIN GRACE11_02_2003 */

Line 6325: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

6321: x_error_code OUT NOCOPY NUMBER,
6322: p_source_task_id IN NUMBER,
6323: p_activity_type_id IN NUMBER )IS
6324:
6325: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
6326: l_module_name VARCHAR2(30) := 'Cleanup_operation_instance';
6327: l_progress NUMBER;
6328: l_return_status VARCHAR2(1);
6329: l_msg_count NUMBER;

Line 6831: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

6827: l_wopi_update_rec WMS_OP_PLAN_INSTANCES%ROWTYPE;
6828: l_parent_source_task_id NUMBER;
6829:
6830:
6831: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
6832: l_module_name VARCHAR2(30) := 'Cancel_operation_Plan';
6833: l_progress NUMBER;
6834:
6835: BEGIN

Line 7294: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

7290: l_document_rec mtl_material_transactions_temp%ROWTYPE;
7291:
7292:
7293:
7294: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
7295: l_module_name VARCHAR2(30) := 'Abort_operation_Plan';
7296: l_return_status VARCHAR2(1);
7297: l_msg_count NUMBER;
7298: l_msg_data VARCHAR2(400);

Line 7881: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

7877: l_first_opertn_seq NUMBER;
7878: l_wopi_rec wms_op_plan_instances%ROWTYPE;
7879: l_op_plan_id NUMBER;
7880:
7881: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
7882: l_module_name VARCHAR2(30) := 'Rollback_operation_Plan';
7883: l_progress NUMBER ;
7884:
7885: BEGIN

Line 8423: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'),0);

8419: p_source_task_id IN NUMBER,
8420: p_activity_type_id IN NUMBER
8421: ) IS
8422:
8423: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'),0);
8424: l_module_name VARCHAR2(30) := 'Check_Plan_Status';
8425: l_progress VARCHAR2(30);
8426:
8427: l_status NUMBER := -1;