DBA Data[Home] [Help]

APPS.CST_MGD_INFL_ADJUSTMENT_CP dependencies on FND_LOG

Line 117: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

113: l_status NUMBER;
114: l_period_is_final_exc EXCEPTION;
115: BEGIN
116:
117: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
118: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
119: ,G_MODULE_HEAD || l_routine || '.begin'
120: ,l_routine || '<'
121: );

Line 118: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

114: l_period_is_final_exc EXCEPTION;
115: BEGIN
116:
117: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
118: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
119: ,G_MODULE_HEAD || l_routine || '.begin'
120: ,l_routine || '<'
121: );
122: END IF;

Line 145: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

141: THEN
142: RAISE l_period_is_final_exc;
143: END IF;
144:
145: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
146: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
147: ,G_MODULE_HEAD || l_routine || '.end'
148: ,l_routine || '>'
149: );

Line 146: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

142: RAISE l_period_is_final_exc;
143: END IF;
144:
145: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
146: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
147: ,G_MODULE_HEAD || l_routine || '.end'
148: ,l_routine || '>'
149: );
150: END IF;

Line 196: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

192: IS
193: l_routine CONSTANT VARCHAR2(30) := 'get_inflation_index_value';
194: BEGIN
195:
196: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
197: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
198: ,G_MODULE_HEAD || l_routine || '.begin'
199: ,l_routine || '<'
200: );

Line 197: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

193: l_routine CONSTANT VARCHAR2(30) := 'get_inflation_index_value';
194: BEGIN
195:
196: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
197: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
198: ,G_MODULE_HEAD || l_routine || '.begin'
199: ,l_routine || '<'
200: );
201: END IF;

Line 219: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

215: AND a.From_Date = c.Period_Start_Date
216: AND a.To_Date = c.Schedule_Close_Date
217: AND c.Open_Flag = 'N';
218:
219: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
220: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
221: ,G_MODULE_HEAD || l_routine || '.end'
222: ,l_routine || '>'
223: );

Line 220: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

216: AND a.To_Date = c.Schedule_Close_Date
217: AND c.Open_Flag = 'N';
218:
219: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
220: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
221: ,G_MODULE_HEAD || l_routine || '.end'
222: ,l_routine || '>'
223: );
224: END IF;

Line 265: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

261: WHERE organization_id = p_org_id;
262:
263: BEGIN
264:
265: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
266: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
267: ,G_MODULE_HEAD || l_routine || '.begin'
268: ,l_routine || '<'
269: );

Line 266: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

262:
263: BEGIN
264:
265: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
266: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
267: ,G_MODULE_HEAD || l_routine || '.begin'
268: ,l_routine || '<'
269: );
270: END IF;

Line 280: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

276: INTO x_cost_group_id;
277:
278: CLOSE c_default_cost_group_cur;
279:
280: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
281: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
282: ,G_MODULE_HEAD || l_routine || '.end'
283: ,l_routine || '>'
284: );

Line 281: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

277:
278: CLOSE c_default_cost_group_cur;
279:
280: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
281: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
282: ,G_MODULE_HEAD || l_routine || '.end'
283: ,l_routine || '>'
284: );
285: END IF;

Line 383: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

379: l_state_level NUMBER;
380:
381: BEGIN
382:
383: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
384: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
385: ,G_MODULE_HEAD || l_routine || '.begin'
386: ,l_routine || '<'
387: );

Line 384: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

380:
381: BEGIN
382:
383: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
384: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
385: ,G_MODULE_HEAD || l_routine || '.begin'
386: ,l_routine || '<'
387: );
388: END IF;

Line 395: l_debug_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

391: l_profile_category_name := 'CST_MGD_INFL_ADJ_CTG';
392: l_profile_category_set_name := 'CST_MGD_INFL_ADJ_CTG_SET';
393:
394: -- initialize debug level variables to use within loop
395: l_debug_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
396: l_state_level := FND_LOG.LEVEL_STATEMENT;
397:
398: -- initialize the message stack
399: FND_MSG_PUB.Initialize;

Line 396: l_state_level := FND_LOG.LEVEL_STATEMENT;

392: l_profile_category_set_name := 'CST_MGD_INFL_ADJ_CTG_SET';
393:
394: -- initialize debug level variables to use within loop
395: l_debug_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
396: l_state_level := FND_LOG.LEVEL_STATEMENT;
397:
398: -- initialize the message stack
399: FND_MSG_PUB.Initialize;
400:

Line 449: IF (FND_LOG.LEVEL_STATEMENT >= l_debug_level) THEN

445: IF l_prev_sch_close_date IS NOT NULL THEN
446: l_prev_sch_close_date := TRUNC(l_prev_sch_close_date) + (86399/86400);
447: END IF;
448:
449: IF (FND_LOG.LEVEL_STATEMENT >= l_debug_level) THEN
450: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
451: ,G_MODULE_HEAD || l_routine || '.prevsch'
452: ,'Previous Acct Period Id:' || l_prev_acct_period_id || ' ' ||'Previous Schedule Close Date:' || TO_CHAR(l_prev_sch_close_date,'DD-MON-YYYY HH24:MI:SS')
453: );

Line 450: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

446: l_prev_sch_close_date := TRUNC(l_prev_sch_close_date) + (86399/86400);
447: END IF;
448:
449: IF (FND_LOG.LEVEL_STATEMENT >= l_debug_level) THEN
450: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
451: ,G_MODULE_HEAD || l_routine || '.prevsch'
452: ,'Previous Acct Period Id:' || l_prev_acct_period_id || ' ' ||'Previous Schedule Close Date:' || TO_CHAR(l_prev_sch_close_date,'DD-MON-YYYY HH24:MI:SS')
453: );
454: END IF;

Line 473: IF (FND_LOG.LEVEL_STATEMENT >= l_debug_level) THEN

469:
470: -- The to date is at 23:59:59 of that date entered
471: l_curr_period_end_date := TRUNC(l_curr_period_end_date) + (86399/86400);
472:
473: IF (FND_LOG.LEVEL_STATEMENT >= l_debug_level) THEN
474: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
475: ,G_MODULE_HEAD || l_routine || '.curpddt'
476: ,'Current Period Start Date:' || TO_CHAR(l_curr_period_start_date,'DD-MON-YYYY HH24:MI:SS') || ' ' ||'Current Period End Date:' || TO_CHAR(l_curr_period_end_date,'DD-MON-YYYY HH24:MI:SS')
477: );

Line 474: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

470: -- The to date is at 23:59:59 of that date entered
471: l_curr_period_end_date := TRUNC(l_curr_period_end_date) + (86399/86400);
472:
473: IF (FND_LOG.LEVEL_STATEMENT >= l_debug_level) THEN
474: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
475: ,G_MODULE_HEAD || l_routine || '.curpddt'
476: ,'Current Period Start Date:' || TO_CHAR(l_curr_period_start_date,'DD-MON-YYYY HH24:MI:SS') || ' ' ||'Current Period End Date:' || TO_CHAR(l_curr_period_end_date,'DD-MON-YYYY HH24:MI:SS')
477: );
478: END IF;

Line 497: FND_LOG.string(l_state_level

493: , x_inflation_index_value => l_inflation_index_value
494: );
495:
496: IF (l_state_level >= l_debug_level) THEN
497: FND_LOG.string(l_state_level
498: , G_MODULE_HEAD || l_routine || '.itemcat'
499: , 'Item Category Set Id:' || l_category_set_id ||
500: ' Item Category Id:' || l_category_id
501: );

Line 534: FND_LOG.string(l_state_level

530: FND_PROFILE.Get(l_profile_category_name, l_category_id);
531: FND_PROFILE.Get(l_profile_category_set_name, l_category_set_id);
532:
533: IF (l_state_level >= l_debug_level) THEN
534: FND_LOG.string(l_state_level
535: , G_MODULE_HEAD || l_routine || '.itemcat'
536: , 'Item Category Set Id:' || l_category_set_id ||
537: ' Item Category Id:' || l_category_id
538: );

Line 547: IF (FND_LOG.LEVEL_EVENT >= l_debug_level) THEN

543: Get_valid_cost_group( p_org_id
544: ,l_cost_group_id);
545:
546:
547: IF (FND_LOG.LEVEL_EVENT >= l_debug_level) THEN
548: FND_LOG.string(FND_LOG.LEVEL_EVENT
549: , G_MODULE_HEAD || l_routine || '.cg_group'
550: , 'Cost Group Id:' || to_char(l_cost_group_id)
551: );

Line 548: FND_LOG.string(FND_LOG.LEVEL_EVENT

544: ,l_cost_group_id);
545:
546:
547: IF (FND_LOG.LEVEL_EVENT >= l_debug_level) THEN
548: FND_LOG.string(FND_LOG.LEVEL_EVENT
549: , G_MODULE_HEAD || l_routine || '.cg_group'
550: , 'Cost Group Id:' || to_char(l_cost_group_id)
551: );
552: END IF;

Line 565: FND_LOG.string(l_state_level

561:
562: l_inv_item_id := k.inventory_item_id;
563:
564: IF (l_state_level >= l_debug_level) THEN
565: FND_LOG.string(l_state_level
566: , G_MODULE_HEAD || l_routine || '.itemcsr'
567: , 'Item Id:' || l_inv_item_id || ' ' ||
568: 'Org Id:' || p_org_id || ' ' ||
569: 'Country Code:' || p_country_code || ' ' ||

Line 610: FND_LOG.string(l_state_level

606:
607: l_inflation_adjustment_rec.item_unit_cost := l_item_unit_avg_cost;
608:
609: IF (l_state_level >= l_debug_level) THEN
610: FND_LOG.string(l_state_level
611: , G_MODULE_HEAD || l_routine || '.itemunitavgcost'
612: , 'Item Unit Average Cost:' || l_item_unit_avg_cost
613: );
614: END IF;

Line 653: IF (FND_LOG.LEVEL_PROCEDURE >= l_debug_level) THEN

649: -- report success
650: x_errbuf := NULL;
651: x_retcode := 0;
652:
653: IF (FND_LOG.LEVEL_PROCEDURE >= l_debug_level) THEN
654: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
655: ,G_MODULE_HEAD || l_routine || '.end'
656: ,l_routine || '>'
657: );

Line 654: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

650: x_errbuf := NULL;
651: x_retcode := 0;
652:
653: IF (FND_LOG.LEVEL_PROCEDURE >= l_debug_level) THEN
654: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
655: ,G_MODULE_HEAD || l_routine || '.end'
656: ,l_routine || '>'
657: );
658: END IF;

Line 840: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

836: AND ADJ.Inventory_Item_ID = SYS.Inventory_Item_ID
837: AND SYS.Organization_ID = p_org_id;
838: BEGIN
839:
840: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
841: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
842: ,G_MODULE_HEAD || l_routine || '.begin'
843: ,l_routine || '<'
844: );

Line 841: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

837: AND SYS.Organization_ID = p_org_id;
838: BEGIN
839:
840: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
841: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
842: ,G_MODULE_HEAD || l_routine || '.begin'
843: ,l_routine || '<'
844: );
845: END IF;

Line 970: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

966: -- report success
967: x_errbuf := NULL;
968: x_retcode := 0;
969:
970: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
971: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
972: ,G_MODULE_HEAD || l_routine || '.end'
973: ,l_routine || '>'
974: );

Line 971: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

967: x_errbuf := NULL;
968: x_retcode := 0;
969:
970: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
971: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
972: ,G_MODULE_HEAD || l_routine || '.end'
973: ,l_routine || '>'
974: );
975: END IF;