APPS.QA_SEQUENCE_API dependencies on FND_LOG

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

2900: l_module constant VARCHAR2(200) := g_module_name || '.generate_seq_for_txninteg';
2901:
2902: BEGIN
2903:
2904: IF(fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2905: fnd_log.string(fnd_log.level_procedure, l_module,
2906: 'Generating sequence for collection_id = ' || p_collection_id);
2907: END IF;
2908:

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

2901:
2902: BEGIN
2903:
2904: IF(fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2905: fnd_log.string(fnd_log.level_procedure, l_module,
2906: 'Generating sequence for collection_id = ' || p_collection_id);
2907: END IF;
2908:
2909: -- Initialize return status to success

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

2913:
2914: -- flush off any unnecessary values from sequence message array
2915: g_message_array.DELETE;
2916:
2917: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2918: fnd_log.string(fnd_log.level_statement, l_module, 'Calling get_all_record_info ');
2919: END IF;
2920:
2921: -- Pack all the sequence values in the data collection into plsql table

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

2914: -- flush off any unnecessary values from sequence message array
2915: g_message_array.DELETE;
2916:
2917: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2918: fnd_log.string(fnd_log.level_statement, l_module, 'Calling get_all_record_info ');
2919: END IF;
2920:
2921: -- Pack all the sequence values in the data collection into plsql table
2922: l_row_count := get_all_record_info(p_collection_id, NULL);

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

2924: IF l_row_count = 0 THEN
2925: RETURN;
2926: END IF;
2927:
2928: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2929: fnd_log.string(fnd_log.level_statement, l_module, 'Looping through all the plans');
2930: END IF;
2931:
2932: FOR plan_rec IN all_plan_cur

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

2925: RETURN;
2926: END IF;
2927:
2928: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2929: fnd_log.string(fnd_log.level_statement, l_module, 'Looping through all the plans');
2930: END IF;
2931:
2932: FOR plan_rec IN all_plan_cur
2933: LOOP

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

2935: -- Generate seq value or copy seq value from parent to child rec.
2936: -- this should be done for all the parent rec and its all child,
2937: -- grandchild.. records
2938:
2939: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2940: fnd_log.string(fnd_log.level_statement, l_module,
2941: 'Calling generate_seq_for_pc for plan_id = ' || plan_rec.plan_id);
2942: END IF;
2943:

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

2936: -- this should be done for all the parent rec and its all child,
2937: -- grandchild.. records
2938:
2939: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2940: fnd_log.string(fnd_log.level_statement, l_module,
2941: 'Calling generate_seq_for_pc for plan_id = ' || plan_rec.plan_id);
2942: END IF;
2943:
2944: generate_seq_for_pc(plan_rec.plan_id, p_collection_id, NULL, TRUE);

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

2958: -- remove the starting '@' char.
2959: x_message := SUBSTR(x_message, 2);
2960:
2961:
2962: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2963: fnd_log.string(fnd_log.level_statement, l_module,
2964: 'Sequence message for Applicable Plans Page ' || x_message);
2965: END IF;
2966:

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

2959: x_message := SUBSTR(x_message, 2);
2960:
2961:
2962: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2963: fnd_log.string(fnd_log.level_statement, l_module,
2964: 'Sequence message for Applicable Plans Page ' || x_message);
2965: END IF;
2966:
2967: -- Now use bulk update to update all seq. values into qa_results for all the

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

2967: -- Now use bulk update to update all seq. values into qa_results for all the
2968: -- records in the data collection
2969: update_record(l_row_count);
2970:
2971: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2972: fnd_log.string(fnd_log.level_statement, l_module,
2973: 'Called update_record with row count ' || l_row_count);
2974: END IF;
2975:

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

2968: -- records in the data collection
2969: update_record(l_row_count);
2970:
2971: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2972: fnd_log.string(fnd_log.level_statement, l_module,
2973: 'Called update_record with row count ' || l_row_count);
2974: END IF;
2975:
2976: -- reflect the changes in inline region, so commit

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

3013: l_user_id := fnd_global.user_id;
3014: l_login_id := fnd_global.login_id;
3015: l_date := sysdate;
3016:
3017: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3018: fnd_log.string(fnd_log.level_statement, l_module,
3019: 'Auditing for char_id = ' || p_char_id
3020: || ' Seq val = ' || p_seq_value);
3021: END IF;

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

3014: l_login_id := fnd_global.login_id;
3015: l_date := sysdate;
3016:
3017: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3018: fnd_log.string(fnd_log.level_statement, l_module,
3019: 'Auditing for char_id = ' || p_char_id
3020: || ' Seq val = ' || p_seq_value);
3021: END IF;
3022: