APPS.GCS_HIERARCHIES_PKG dependencies on FND_LOG

Line 509: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE THEN

505: --
506: PROCEDURE Module_Log_Write(p_module VARCHAR2, p_action_type VARCHAR2) IS
507: BEGIN
508: -- Only print if the log level is set at the appropriate level
509: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE THEN
510: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
511: g_api || '.' || p_module,
512: p_action_type || ' ' || p_module || '() ' ||
513: to_char(sysdate, 'DD-MON-YYYY HH:MI:SS'));

Line 510: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

506: PROCEDURE Module_Log_Write(p_module VARCHAR2, p_action_type VARCHAR2) IS
507: BEGIN
508: -- Only print if the log level is set at the appropriate level
509: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE THEN
510: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
511: g_api || '.' || p_module,
512: p_action_type || ' ' || p_module || '() ' ||
513: to_char(sysdate, 'DD-MON-YYYY HH:MI:SS'));
514: END IF;

Line 542: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= p_level THEN

538: text_with_date_len NUMBER;
539: curr_index NUMBER;
540: BEGIN
541: -- Only print if the log level is set at the appropriate level
542: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= p_level THEN
543: api_module_concat := g_api || '.' || p_module;
544: text_with_date := to_char(sysdate, 'DD-MON-YYYY HH:MI:SS') || g_nl ||
545: p_text;
546: text_with_date_len := length(text_with_date);

Line 549: fnd_log.string(p_level,

545: p_text;
546: text_with_date_len := length(text_with_date);
547: curr_index := 1;
548: WHILE curr_index <= text_with_date_len LOOP
549: fnd_log.string(p_level,
550: api_module_concat,
551: substr(text_with_date, curr_index, 3500));
552: curr_index := curr_index + 3500;
553: END LOOP;

Line 663: fnd_login_id NUMBER;

659: AND r.start_date <= nvl(r.end_date, r.start_date)
660: AND p_start_date <= nvl(r.end_date, p_start_date)
661: AND nvl(p_end_date, r.start_date) >= r.start_date;
662: fnd_user_id NUMBER;
663: fnd_login_id NUMBER;
664: v_module VARCHAR2(30);
665: BEGIN
666: v_module := 'Calc_Delta_To_Single_Parent';
667: module_log_write(v_module, g_module_enter);

Line 681: fnd_login_id := fnd_global.login_id;

677: -- If we have reached the desired parent entity, create the necessary rows.
678: -- Otherwise keep going up the hierarchy.
679: IF p_current_entity_id = p_parent_entity_id THEN
680: fnd_user_id := fnd_global.user_id;
681: fnd_login_id := fnd_global.login_id;
682: -- Initialize the previous end date to be the day prior to the start date
683: -- of the new range
684: last_end_date := p_start_date - 1;
685: -- Go through each of the delta rows, and perform the necessary actions

Line 723: fnd_login_id,

719: sysdate,
720: fnd_user_id,
721: sysdate,
722: fnd_user_id,
723: fnd_login_id,
724: p_start_date - 1,
725: delta_row.delta_owned,
726: 'N',
727: 'N');

Line 768: fnd_login_id,

764: sysdate,
765: fnd_user_id,
766: sysdate,
767: fnd_user_id,
768: fnd_login_id,
769: delta_row.end_date,
770: delta_row.delta_owned,
771: 'N',
772: 'N');

Line 814: fnd_login_id,

810: sysdate,
811: fnd_user_id,
812: sysdate,
813: fnd_user_id,
814: fnd_login_id,
815: delta_row.start_date - 1,
816: p_effective_ownership,
817: 'N',
818: 'N');

Line 863: fnd_login_id,

859: sysdate,
860: fnd_user_id,
861: sysdate,
862: fnd_user_id,
863: fnd_login_id,
864: p_end_date,
865: p_effective_ownership,
866: 'N',
867: 'N');

Line 892: write_to_log(v_module, FND_LOG.LEVEL_UNEXPECTED, SQLERRM);

888: END IF;
889: module_log_write(v_module, g_module_success);
890: EXCEPTION
891: WHEN OTHERS THEN
892: write_to_log(v_module, FND_LOG.LEVEL_UNEXPECTED, SQLERRM);
893: module_log_write(v_module, g_module_failure);
894: RAISE;
895: END Calc_Delta_To_Single_Parent;
896: --

Line 1032: write_to_log(v_module, FND_LOG.LEVEL_UNEXPECTED, SQLERRM);

1028: p_calc_parent_entities(p_parent_entity_id) := NULL;
1029: module_log_write(v_module, g_module_success);
1030: EXCEPTION
1031: WHEN OTHERS THEN
1032: write_to_log(v_module, FND_LOG.LEVEL_UNEXPECTED, SQLERRM);
1033: module_log_write(v_module, g_module_failure);
1034: RAISE;
1035: END Calc_Delta_To_All_Parents;
1036: --

Line 1132: write_to_log(v_module, FND_LOG.LEVEL_UNEXPECTED, SQLERRM);

1128: END LOOP;
1129: module_log_write(v_module, g_module_success);
1130: EXCEPTION
1131: WHEN OTHERS THEN
1132: write_to_log(v_module, FND_LOG.LEVEL_UNEXPECTED, SQLERRM);
1133: module_log_write(v_module, g_module_failure);
1134: RAISE;
1135: END Calculate_Delta_Internal;
1136: --

Line 1172: write_to_log(v_module, FND_LOG.LEVEL_UNEXPECTED, SQLERRM);

1168: module_log_write(v_module, g_module_success);
1169: EXCEPTION
1170: WHEN OTHERS THEN
1171: ROLLBACK TO gcs_calc_delta_single_entity;
1172: write_to_log(v_module, FND_LOG.LEVEL_UNEXPECTED, SQLERRM);
1173: module_log_write(v_module, g_module_failure);
1174: RAISE;
1175: END Calculate_Delta;
1176: --