APPS.WMS_TXNRSN_ACTIONS_PUB dependencies on WMS_EXCEPTIONS

Line 1967: select wms_exceptions_s.NEXTVAL INTO l_sequence from dual;

1963: l_proc_name VARCHAR2(30) := 'Log_exception';
1964: BEGIN
1965:
1966: --Calculate Sequence Number
1967: select wms_exceptions_s.NEXTVAL INTO l_sequence from dual;
1968: g_debug := l_debug;
1969: g_module_name := l_proc_name;
1970: IF (l_debug = 1) THEN
1971: mdebug('Inserting into exceptions');

Line 2011: INSERT INTO wms_exceptions(

2007: l_insert_loc := p_locator_id;
2008: end if;
2009: -- end adding code for 11858770
2010:
2011: INSERT INTO wms_exceptions(
2012: TASK_ID,
2013: SEQUENCE_NUMBER,
2014: ORGANIZATION_ID,
2015: INVENTORY_ITEM_ID,

Line 2070: l_return_err := 'Insert into WMS_Exceptions failed'||

2066: exception
2067: when others THEN
2068: x_return_status:=FND_API.G_RET_STS_ERROR;
2069:
2070: l_return_err := 'Insert into WMS_Exceptions failed'||
2071: substrb(sqlerrm,1,55);
2072: raise_application_error(-20000,l_return_err);
2073:
2074:

Line 2960: l_subinventory_code wms_exceptions.subinventory_code%TYPE;

2956: l_discrepancy VARCHAR2(1000);
2957: l_reason_context_code VARCHAR2(2);
2958: l_reason_id NUMBER;
2959: l_transaction_temp_id NUMBER;
2960: l_subinventory_code wms_exceptions.subinventory_code%TYPE;
2961: l_locator_id NUMBER;
2962: l_lpn_id NUMBER;
2963: l_lot_number mtl_lot_numbers.lot_number%TYPE;
2964: l_workflow_name mtl_transaction_reasons.workflow_name%TYPE;

Line 3169: l_return_err := 'Insert into WMS_Exceptions failed'|| substrb(sqlerrm,1,55);

3165:
3166: EXCEPTION
3167: WHEN OTHERS THEN
3168: x_return_status:=FND_API.G_RET_STS_ERROR;
3169: l_return_err := 'Insert into WMS_Exceptions failed'|| substrb(sqlerrm,1,55);
3170: raise_application_error(-20000,l_return_err);
3171:
3172: END Log_exception;
3173: