APPS.QA_SEQUENCE_API dependencies on FND_LOG

Line 2850: IF(fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

2846: l_module constant VARCHAR2(200) := g_module_name || '.generate_seq_for_txninteg';
2847:
2848: BEGIN
2849:
2850: IF(fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2851: fnd_log.string(fnd_log.level_procedure, l_module,
2852: 'Generating sequence for collection_id = ' || p_collection_id);
2853: END IF;
2854:

Line 2851: fnd_log.string(fnd_log.level_procedure, l_module,

2847:
2848: BEGIN
2849:
2850: IF(fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2851: fnd_log.string(fnd_log.level_procedure, l_module,
2852: 'Generating sequence for collection_id = ' || p_collection_id);
2853: END IF;
2854:
2855: -- Initialize return status to success

Line 2863: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2859:
2860: -- flush off any unnecessary values from sequence message array
2861: g_message_array.DELETE;
2862:
2863: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2864: fnd_log.string(fnd_log.level_statement, l_module, 'Calling get_all_record_info ');
2865: END IF;
2866:
2867: -- Pack all the sequence values in the data collection into plsql table

Line 2864: fnd_log.string(fnd_log.level_statement, l_module, 'Calling get_all_record_info ');

2860: -- flush off any unnecessary values from sequence message array
2861: g_message_array.DELETE;
2862:
2863: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2864: fnd_log.string(fnd_log.level_statement, l_module, 'Calling get_all_record_info ');
2865: END IF;
2866:
2867: -- Pack all the sequence values in the data collection into plsql table
2868: l_row_count := get_all_record_info(p_collection_id, NULL);

Line 2874: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2870: IF l_row_count = 0 THEN
2871: RETURN;
2872: END IF;
2873:
2874: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2875: fnd_log.string(fnd_log.level_statement, l_module, 'Looping through all the plans');
2876: END IF;
2877:
2878: FOR plan_rec IN all_plan_cur

Line 2875: fnd_log.string(fnd_log.level_statement, l_module, 'Looping through all the plans');

2871: RETURN;
2872: END IF;
2873:
2874: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2875: fnd_log.string(fnd_log.level_statement, l_module, 'Looping through all the plans');
2876: END IF;
2877:
2878: FOR plan_rec IN all_plan_cur
2879: LOOP

Line 2885: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2881: -- Generate seq value or copy seq value from parent to child rec.
2882: -- this should be done for all the parent rec and its all child,
2883: -- grandchild.. records
2884:
2885: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2886: fnd_log.string(fnd_log.level_statement, l_module,
2887: 'Calling generate_seq_for_pc for plan_id = ' || plan_rec.plan_id);
2888: END IF;
2889:

Line 2886: fnd_log.string(fnd_log.level_statement, l_module,

2882: -- this should be done for all the parent rec and its all child,
2883: -- grandchild.. records
2884:
2885: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2886: fnd_log.string(fnd_log.level_statement, l_module,
2887: 'Calling generate_seq_for_pc for plan_id = ' || plan_rec.plan_id);
2888: END IF;
2889:
2890: generate_seq_for_pc(plan_rec.plan_id, p_collection_id, NULL, TRUE);

Line 2908: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2904: -- remove the starting '@' char.
2905: x_message := SUBSTR(x_message, 2);
2906:
2907:
2908: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2909: fnd_log.string(fnd_log.level_statement, l_module,
2910: 'Sequence message for Applicable Plans Page ' || x_message);
2911: END IF;
2912:

Line 2909: fnd_log.string(fnd_log.level_statement, l_module,

2905: x_message := SUBSTR(x_message, 2);
2906:
2907:
2908: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2909: fnd_log.string(fnd_log.level_statement, l_module,
2910: 'Sequence message for Applicable Plans Page ' || x_message);
2911: END IF;
2912:
2913: -- Now use bulk update to update all seq. values into qa_results for all the

Line 2917: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2913: -- Now use bulk update to update all seq. values into qa_results for all the
2914: -- records in the data collection
2915: update_record(l_row_count);
2916:
2917: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2918: fnd_log.string(fnd_log.level_statement, l_module,
2919: 'Called update_record with row count ' || l_row_count);
2920: END IF;
2921:

Line 2918: fnd_log.string(fnd_log.level_statement, l_module,

2914: -- records in the data collection
2915: update_record(l_row_count);
2916:
2917: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2918: fnd_log.string(fnd_log.level_statement, l_module,
2919: 'Called update_record with row count ' || l_row_count);
2920: END IF;
2921:
2922: -- reflect the changes in inline region, so commit

Line 2963: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2959: l_user_id := fnd_global.user_id;
2960: l_login_id := fnd_global.login_id;
2961: l_date := sysdate;
2962:
2963: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2964: fnd_log.string(fnd_log.level_statement, l_module,
2965: 'Auditing for char_id = ' || p_char_id
2966: || ' Seq val = ' || p_seq_value);
2967: END IF;

Line 2964: fnd_log.string(fnd_log.level_statement, l_module,

2960: l_login_id := fnd_global.login_id;
2961: l_date := sysdate;
2962:
2963: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2964: fnd_log.string(fnd_log.level_statement, l_module,
2965: 'Auditing for char_id = ' || p_char_id
2966: || ' Seq val = ' || p_seq_value);
2967: END IF;
2968: