DBA Data[Home] [Help]

APPS.WSMPPCPD dependencies on FND_LOG

Line 2415: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2411: -- Added By Bala.
2412: -- Need to be performed only when inserting a component.
2413:
2414: If x_comp_insert Then
2415: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2416: DECLARE
2417: l_comp_eff_date DATE;
2418: BEGIN
2419: select bic.effectivity_date

Line 2428: FND_LOG.STRING(FND_LOG.LEVEL_EVENT, 'wsm%',

2424: and bic.bill_sequence_id = bom.common_bill_sequence_id
2425: and bic.component_item_id = x_component_id
2426: and bic.operation_seq_num = 1;
2427:
2428: FND_LOG.STRING(FND_LOG.LEVEL_EVENT, 'wsm%',
2429: 'component effectivity date = '||to_char(l_comp_eff_date, 'DD-MON-YYYY HH24:MI:SS')||
2430: ' x_component_id = '||x_component_id||
2431: ' l_effectivity_date = '||to_char(l_effectivity_date, 'DD-MON-YYYY HH24:MI:SS')||
2432: ' x_bill_sequence_id = '||x_bill_sequence_id);

Line 2435: FND_LOG.STRING(FND_LOG.LEVEL_EVENT, 'wsm%',

2431: ' l_effectivity_date = '||to_char(l_effectivity_date, 'DD-MON-YYYY HH24:MI:SS')||
2432: ' x_bill_sequence_id = '||x_bill_sequence_id);
2433: EXCEPTION
2434: WHEN no_data_found THEN
2435: FND_LOG.STRING(FND_LOG.LEVEL_EVENT, 'wsm%',
2436: 'no_data_found ');
2437: WHEN too_many_rows THEN
2438: null;
2439: END;