eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QP_PS_ATTR_GRP_PVT dependencies on OE_DEBUG_PUB

Line 401: oe_debug_pub.add('QP_PS_ATTR_GRP_PVT.update_pattern_phases ' || SQLERRM);

397: CLOSE pat_phases_dates_flags_prl_all;
398: END if;
399:
400: if g_call_from_setup = 'Y' THEN
401: oe_debug_pub.add('QP_PS_ATTR_GRP_PVT.update_pattern_phases ' || SQLERRM);
402: else
403: write_log( 'QP_PS_ATTR_GRP_PVT.update_pattern_phases ' || SQLERRM );
404: end if;
405:

Line 430: oe_debug_pub.add('Begin create pattern slabs');

426:
427: begin
428:
429: if g_call_from_setup = 'Y' then
430: oe_debug_pub.add('Begin create pattern slabs');
431: else
432: write_log( 'Begin create pattern slabs');
433: write_log( 'Start time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
434: end if;

Line 442: oe_debug_pub.add('Total lines:'||p_total_lines);

438: end if;
439: l_gap := round(p_total_lines / l_no_of_threads, 0);
440:
441: if g_call_from_setup = 'Y' then
442: oe_debug_pub.add('Total lines:'||p_total_lines);
443: oe_debug_pub.add('l_gap:'||l_gap);
444: else
445: write_log( 'Total lines:'||p_total_lines);
446: write_log( 'l_gap:'||l_gap);

Line 443: oe_debug_pub.add('l_gap:'||l_gap);

439: l_gap := round(p_total_lines / l_no_of_threads, 0);
440:
441: if g_call_from_setup = 'Y' then
442: oe_debug_pub.add('Total lines:'||p_total_lines);
443: oe_debug_pub.add('l_gap:'||l_gap);
444: else
445: write_log( 'Total lines:'||p_total_lines);
446: write_log( 'l_gap:'||l_gap);
447: end if;

Line 507: oe_debug_pub.add('Begin create pattern chunks');

503: l_start_flag number := 0;
504: l_no_of_threads number := 0;
505: begin
506: if g_call_from_setup = 'Y' then
507: oe_debug_pub.add('Begin create pattern chunks');
508: else
509: write_log( 'Begin create pattern chunks');
510: write_log( 'Start time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
511: end if;

Line 674: oe_debug_pub.add('PS_ATTR_GRP_PVT.Remove_Duplicate_Patterns ' || SQLERRM);

670:
671: EXCEPTION
672: WHEN OTHERS THEN
673: if g_call_from_setup = 'Y' then
674: oe_debug_pub.add('PS_ATTR_GRP_PVT.Remove_Duplicate_Patterns ' || SQLERRM);
675: else
676: write_log( 'PS_ATTR_GRP_PVT.Remove_Duplicate_Patterns ' || SQLERRM );
677: end if;
678:

Line 1067: oe_debug_pub.add('PS_ATTR_GRP_PVT.Pattern_Upgrade ' || SQLERRM);

1063: retcode := 0;
1064: exception
1065: when others then
1066: if g_call_from_setup = 'Y' then
1067: oe_debug_pub.add('PS_ATTR_GRP_PVT.Pattern_Upgrade ' || SQLERRM);
1068: else
1069: write_log( 'PS_ATTR_GRP_PVT.Pattern_Upgrade ' || SQLERRM );
1070: end if;
1071: err_buff := 'Others Error in procedure Pattern_Upgrade';

Line 1199: oe_debug_pub.add('Begin generate_hp_atgrps');

1195: order by attr_view.list_header_id, attr_view.list_line_id, attr_view.segment_id;
1196: begin
1197: -- delete the data from cursor, temp and final tables to start with
1198: if g_call_from_setup = 'Y' then
1199: oe_debug_pub.add('Begin generate_hp_atgrps');
1200: else
1201: write_log( 'Begin generate_hp_atgrps');
1202: end if;
1203: Reset_c_tables;

Line 1257: oe_debug_pub.add('End generate_hp_atgrps');

1253: if g_list_header_id_c_tbl.count > 0 then
1254: process_c_tables('HP');
1255: end if;
1256: if g_call_from_setup = 'Y' then
1257: oe_debug_pub.add('End generate_hp_atgrps');
1258: else
1259: write_log( 'End generate_hp_atgrps');
1260: end if;
1261:

Line 1265: oe_debug_pub.add('PS_ATTR_GRP_PVT.Generate_Hp_Atgrps ' || SQLERRM);

1261:
1262: EXCEPTION
1263: WHEN OTHERS THEN
1264: if g_call_from_setup = 'Y' then
1265: oe_debug_pub.add('PS_ATTR_GRP_PVT.Generate_Hp_Atgrps ' || SQLERRM);
1266: else
1267: write_log( 'PS_ATTR_GRP_PVT.Generate_Hp_Atgrps ' || SQLERRM );
1268: end if;
1269:

Line 1735: oe_debug_pub.add('PS_ATTR_GRP_PVT.Generate_Lp_Atgrps ' || SQLERRM);

1731:
1732: EXCEPTION
1733: WHEN OTHERS THEN
1734: if g_call_from_setup = 'Y' then
1735: oe_debug_pub.add('PS_ATTR_GRP_PVT.Generate_Lp_Atgrps ' || SQLERRM);
1736: else
1737: write_log( 'PS_ATTR_GRP_PVT.Generate_Lp_Atgrps ' || SQLERRM );
1738: end if;
1739:

Line 2212: oe_debug_pub.add('exiting update pp lines' || g_list_header_id_c_tbl.count);

2208:
2209: CLOSE c_lines_pp_csr;
2210: END if;
2211:
2212: oe_debug_pub.add('exiting update pp lines' || g_list_header_id_c_tbl.count);
2213: if g_list_header_id_c_tbl.count > 0 then
2214: process_c_tables_pp('PP');
2215: end if;
2216:

Line 2220: oe_debug_pub.add('PS_ATTR_GRP_PVT.Update_Pp_Lines ' || SQLERRM);

2216:
2217: EXCEPTION
2218: WHEN OTHERS THEN
2219: if g_call_from_setup = 'Y' then
2220: oe_debug_pub.add('PS_ATTR_GRP_PVT.Update_Pp_Lines ' || SQLERRM);
2221: else
2222: write_log( 'PS_ATTR_GRP_PVT.Update_Pp_Lines ' || SQLERRM );
2223: end if;
2224:

Line 2244: oe_debug_pub.add('Start process_c_tables - Pattern type '||p_pattern_type);

2240: l_old_list_line_id := g_init_val;
2241: l_product_uom_code_j := NULL;
2242:
2243: if g_call_from_setup = 'Y' then
2244: oe_debug_pub.add('Start process_c_tables - Pattern type '||p_pattern_type);
2245: oe_debug_pub.add('cursor tables total = ' || g_list_header_id_c_tbl.count);
2246: else
2247: QP_PREQ_GRP.Set_QP_Debug;
2248: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;

Line 2245: oe_debug_pub.add('cursor tables total = ' || g_list_header_id_c_tbl.count);

2241: l_product_uom_code_j := NULL;
2242:
2243: if g_call_from_setup = 'Y' then
2244: oe_debug_pub.add('Start process_c_tables - Pattern type '||p_pattern_type);
2245: oe_debug_pub.add('cursor tables total = ' || g_list_header_id_c_tbl.count);
2246: else
2247: QP_PREQ_GRP.Set_QP_Debug;
2248: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
2249: IF l_debug = FND_API.G_TRUE THEN

Line 2259: oe_debug_pub.add('i = ' || i ||

2255: if g_list_header_id_c_tbl.count > 0 then
2256: for i in 1..g_list_header_id_c_tbl.count
2257: LOOP
2258: if g_call_from_setup = 'Y' then
2259: oe_debug_pub.add('i = ' || i ||
2260: ', list_header_id = ' || g_list_header_id_c_tbl(i) ||
2261: ', list_line_id = ' || g_list_line_id_c_tbl(i) ||
2262: ', group = ' || g_qual_grouping_no_c_tbl(i) ||
2263: ', operator = ' || g_comparison_opr_code_c_tbl(i));

Line 2283: oe_debug_pub.add('inserting data for ' || G_LINES_PER_INSERT || ' lines');

2279: -- logic to insert into tables every G_LINES_PER_INSERT lines
2280: l_line_counter := l_line_counter + 1;
2281: if l_line_counter >= G_LINES_PER_INSERT then
2282: if g_call_from_setup = 'Y' then
2283: oe_debug_pub.add('inserting data for ' || G_LINES_PER_INSERT || ' lines');
2284: elsif l_debug = FND_API.G_TRUE then
2285: write_log( 'inserting data for ' || G_LINES_PER_INSERT || ' lines');
2286: end if;
2287: populate_atgrps;

Line 2309: oe_debug_pub.add('record exists in temp table for current group');

2305: if g_qual_grouping_no_tmp_tbl.exists(l_current_grp) = TRUE then
2306:
2307: /*
2308: if g_call_from_setup = 'Y' then
2309: oe_debug_pub.add('record exists in temp table for current group');
2310: oe_debug_pub.add('current record Operator is ' || g_comparison_opr_code_c_tbl(i));
2311: else
2312: write_log( 'record exists in temp table for current group');
2313: write_log( 'current record Operator is ' || g_comparison_opr_code_c_tbl(i));

Line 2310: oe_debug_pub.add('current record Operator is ' || g_comparison_opr_code_c_tbl(i));

2306:
2307: /*
2308: if g_call_from_setup = 'Y' then
2309: oe_debug_pub.add('record exists in temp table for current group');
2310: oe_debug_pub.add('current record Operator is ' || g_comparison_opr_code_c_tbl(i));
2311: else
2312: write_log( 'record exists in temp table for current group');
2313: write_log( 'current record Operator is ' || g_comparison_opr_code_c_tbl(i));
2314: end if;

Line 2325: oe_debug_pub.add('other_grp_index = ' || other_grp_index);

2321: while other_grp_index is not null
2322: LOOP
2323: /*
2324: if g_call_from_setup = 'Y' then
2325: oe_debug_pub.add('other_grp_index = ' || other_grp_index);
2326: else
2327: write_log( 'other_grp_index = ' || other_grp_index);
2328: end if;
2329: */

Line 2515: oe_debug_pub.add('record DOES NOT exists in temp table for current group');

2511:
2512: else -- record does not exists for the group
2513: /*
2514: if g_call_from_setup = 'Y' then
2515: oe_debug_pub.add('record DOES NOT exists in temp table for current group');
2516: oe_debug_pub.add('current record Operator is ' || g_comparison_opr_code_c_tbl(i));
2517: else
2518: write_log( 'record DOES NOT exists in temp table for current group');
2519: write_log( 'current record Operator is ' || g_comparison_opr_code_c_tbl(i));

Line 2516: oe_debug_pub.add('current record Operator is ' || g_comparison_opr_code_c_tbl(i));

2512: else -- record does not exists for the group
2513: /*
2514: if g_call_from_setup = 'Y' then
2515: oe_debug_pub.add('record DOES NOT exists in temp table for current group');
2516: oe_debug_pub.add('current record Operator is ' || g_comparison_opr_code_c_tbl(i));
2517: else
2518: write_log( 'record DOES NOT exists in temp table for current group');
2519: write_log( 'current record Operator is ' || g_comparison_opr_code_c_tbl(i));
2520: end if;

Line 2536: oe_debug_pub.add('other_grp_index = ' || other_grp_index);

2532: while other_grp_index is not null
2533: LOOP
2534: /*
2535: if g_call_from_setup = 'Y' then
2536: oe_debug_pub.add('other_grp_index = ' || other_grp_index);
2537: else
2538: write_log( 'other_grp_index = ' || other_grp_index);
2539: end if;
2540: */

Line 2861: oe_debug_pub.add('PS_ATTR_GRP_PVT.Process_C_Tables ' || SQLERRM);

2857:
2858: EXCEPTION
2859: WHEN OTHERS THEN
2860: if g_call_from_setup = 'Y' then
2861: oe_debug_pub.add('PS_ATTR_GRP_PVT.Process_C_Tables ' || SQLERRM);
2862: else
2863: write_log( 'PS_ATTR_GRP_PVT.Process_C_Tables ' || SQLERRM );
2864: end if;
2865:

Line 2882: oe_debug_pub.add('PP cursor tables total = ' || g_list_header_id_c_tbl.count);

2878: l_old_list_header_id := g_init_val;
2879: l_old_list_line_id := g_init_val;
2880:
2881: if g_call_from_setup = 'Y' then
2882: oe_debug_pub.add('PP cursor tables total = ' || g_list_header_id_c_tbl.count);
2883: else
2884: QP_PREQ_GRP.Set_QP_Debug;
2885: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
2886: IF l_debug = FND_API.G_TRUE THEN

Line 2897: oe_debug_pub.add('PP i = ' || i ||

2893: if g_list_header_id_c_tbl.count > 0 then
2894: for i in 1..g_list_header_id_c_tbl.count
2895: LOOP
2896: if g_call_from_setup = 'Y' then
2897: oe_debug_pub.add('PP i = ' || i ||
2898: ', list_header_id = ' || g_list_header_id_c_tbl(i) ||
2899: ', list_line_id = ' || g_list_line_id_c_tbl(i) ||
2900: ', operator = ' || g_comparison_opr_code_c_tbl(i));
2901: elsif l_debug = FND_API.G_TRUE then

Line 2920: oe_debug_pub.add('inserting data for ' || G_LINES_PER_INSERT || ' lines');

2916: -- logic to insert into tables every G_LINES_PER_INSERT lines
2917: l_line_counter := l_line_counter + 1;
2918: if l_line_counter >= G_LINES_PER_INSERT then
2919: if g_call_from_setup = 'Y' then
2920: oe_debug_pub.add('inserting data for ' || G_LINES_PER_INSERT || ' lines');
2921: elsif l_debug = FND_API.G_TRUE then
2922: write_log( 'inserting data for ' || G_LINES_PER_INSERT || ' lines');
2923: end if;
2924: IF g_qp_pattern_search <> 'M' THEN

Line 3112: oe_debug_pub.add('Count final table before move data - '||g_list_header_id_final_tbl.count);

3108: end if; -- g_list_header_id_c_tbl.count > 0
3109:
3110: -- move data for last pair of header and line id
3111:
3112: oe_debug_pub.add('Count final table before move data - '||g_list_header_id_final_tbl.count);
3113:
3114: Move_data_from_tmp_to_final(p_pattern_type);
3115:
3116: oe_debug_pub.add('Count final table after move data - '||g_list_header_id_final_tbl.count);

Line 3116: oe_debug_pub.add('Count final table after move data - '||g_list_header_id_final_tbl.count);

3112: oe_debug_pub.add('Count final table before move data - '||g_list_header_id_final_tbl.count);
3113:
3114: Move_data_from_tmp_to_final(p_pattern_type);
3115:
3116: oe_debug_pub.add('Count final table after move data - '||g_list_header_id_final_tbl.count);
3117:
3118: -- update qp_list_lines from final tables
3119: IF g_qp_pattern_search <> 'M' THEN
3120: update_list_lines;

Line 3126: oe_debug_pub.add('Count final table before final insertion - '||g_list_line_id_final_tbl.count);

3122:
3123: -- Added for PL/SQL Pattern Search
3124: --- update populate_pp_atgrps from final tables
3125:
3126: oe_debug_pub.add('Count final table before final insertion - '||g_list_line_id_final_tbl.count);
3127:
3128: populate_pp_atgrps;
3129: reset_final_tables;
3130: -- Added for PL/SQL Pattern Search

Line 3134: oe_debug_pub.add('PS_ATTR_GRP_PVT.Process_C_Tables_Pp ' || SQLERRM);

3130: -- Added for PL/SQL Pattern Search
3131: EXCEPTION
3132: WHEN OTHERS THEN
3133: if g_call_from_setup = 'Y' then
3134: oe_debug_pub.add('PS_ATTR_GRP_PVT.Process_C_Tables_Pp ' || SQLERRM);
3135: else
3136: write_log( 'PS_ATTR_GRP_PVT.Process_C_Tables_Pp ' || SQLERRM );
3137: end if;
3138:

Line 3151: oe_debug_pub.add('Moving data from temp table to final table');

3147: l_product_precedence number;
3148: BEGIN
3149: /*
3150: if g_call_from_setup = 'Y' then
3151: oe_debug_pub.add('Moving data from temp table to final table');
3152: oe_debug_pub.add('temp tables total = ' || g_list_header_id_tmp_tbl.count);
3153: else
3154: write_log( 'Moving data from temp table to final table');
3155: write_log( 'temp tables total = ' || g_list_header_id_tmp_tbl.count);

Line 3152: oe_debug_pub.add('temp tables total = ' || g_list_header_id_tmp_tbl.count);

3148: BEGIN
3149: /*
3150: if g_call_from_setup = 'Y' then
3151: oe_debug_pub.add('Moving data from temp table to final table');
3152: oe_debug_pub.add('temp tables total = ' || g_list_header_id_tmp_tbl.count);
3153: else
3154: write_log( 'Moving data from temp table to final table');
3155: write_log( 'temp tables total = ' || g_list_header_id_tmp_tbl.count);
3156: end if;

Line 3167: oe_debug_pub.add('l_other_grp_exists = ' || l_other_grp_exists);

3163: end if; -- g_list_header_id_tmp_tbl.count > 1
3164:
3165: /*
3166: if g_call_from_setup = 'Y' then
3167: oe_debug_pub.add('l_other_grp_exists = ' || l_other_grp_exists);
3168: else
3169: write_log( 'l_other_grp_exists = ' || l_other_grp_exists);
3170: end if;
3171: */

Line 3180: oe_debug_pub.add('grouping no = ' || grp_no_index);

3176: LOOP
3177:
3178: /*
3179: if g_call_from_setup = 'Y' then
3180: oe_debug_pub.add('grouping no = ' || grp_no_index);
3181: else
3182: write_log( 'grouping no = ' || grp_no_index);
3183: end if;
3184: */

Line 3221: oe_debug_pub.add('Pattern_id='||l_pattern_id);

3217: END IF;
3218: end if;
3219: /*
3220: if g_call_from_setup = 'Y' then
3221: oe_debug_pub.add('Pattern_id='||l_pattern_id);
3222: else
3223: write_log( 'Pattern_id='||l_pattern_id);
3224: end if;
3225: */

Line 3236: oe_debug_pub.add('move the data from tmp tables to final tables for qp_attribute_groups');

3232: end if;
3233: -- move the data from tmp tables to final tables for qp_attribute_groups
3234: /*
3235: if g_call_from_setup = 'Y' then
3236: oe_debug_pub.add('move the data from tmp tables to final tables for qp_attribute_groups');
3237: else
3238: write_log( 'move the data from tmp tables to final tables for qp_attribute_groups');
3239: end if;
3240: */

Line 3299: oe_debug_pub.add('cache_key should be just list_header_id ');

3295: g_effec_precedence_final_tbl(l_atgrp_final_index) := l_product_precedence;
3296: end if;
3297: /*
3298: if g_call_from_setup = 'Y' then
3299: oe_debug_pub.add('cache_key should be just list_header_id ');
3300: else
3301: write_log( 'cache_key should be just list_header_id ');
3302: end if;
3303: */

Line 3308: oe_debug_pub.add('cache_key should be standard OR null');

3304: else
3305: g_cache_key_final_tbl(l_atgrp_final_index) := g_cache_key_tmp_tbl(grp_no_index);
3306: /*
3307: if g_call_from_setup = 'Y' then
3308: oe_debug_pub.add('cache_key should be standard OR null');
3309: else
3310: write_log( 'cache_key should be standard OR null');
3311: end if;
3312: */

Line 3366: oe_debug_pub.add('End Moving data from temp table to final table');

3362:
3363: END LOOP; -- while
3364: /*
3365: if g_call_from_setup = 'Y' then
3366: oe_debug_pub.add('End Moving data from temp table to final table');
3367: else
3368: write_log( 'End Moving data from temp table to final table');
3369: end if;
3370: */

Line 3375: oe_debug_pub.add('PS_ATTR_GRP_PVT.Move_Data_From_Tmp_To_Final ' || SQLERRM);

3371:
3372: EXCEPTION
3373: WHEN OTHERS THEN
3374: if g_call_from_setup = 'Y' then
3375: oe_debug_pub.add('PS_ATTR_GRP_PVT.Move_Data_From_Tmp_To_Final ' || SQLERRM);
3376: else
3377: write_log( 'PS_ATTR_GRP_PVT.Move_Data_From_Tmp_To_Final ' || SQLERRM );
3378: end if;
3379:

Line 3389: oe_debug_pub.add('Begin Populate_patterns');

3385: BEGIN
3386:
3387: /*
3388: if g_call_from_setup = 'Y' then
3389: oe_debug_pub.add('Begin Populate_patterns');
3390: else
3391: write_log( 'Begin Populate_patterns');
3392: end if;
3393: */

Line 3448: oe_debug_pub.add('End Populate_patterns');

3444: g_pattern_segment_ind_fnl_tbl.delete;
3445:
3446: /*
3447: if g_call_from_setup = 'Y' then
3448: oe_debug_pub.add('End Populate_patterns');
3449: else
3450: commit;
3451: write_log( 'End Populate_patterns');
3452: end if;

Line 3457: oe_debug_pub.add('PS_ATTR_GRP_PVT.Populate_Patterns ' || SQLERRM);

3453: */
3454: EXCEPTION
3455: WHEN OTHERS THEN
3456: if g_call_from_setup = 'Y' then
3457: oe_debug_pub.add('PS_ATTR_GRP_PVT.Populate_Patterns ' || SQLERRM);
3458: else
3459: write_log( 'PS_ATTR_GRP_PVT.Populate_Patterns ' || SQLERRM );
3460: end if;
3461: raise;

Line 3508: oe_debug_pub.add('PS_ATTR_GRP_PVT.Update_List_Lines ' || SQLERRM);

3504: END if;
3505: EXCEPTION
3506: WHEN OTHERS THEN
3507: if g_call_from_setup = 'Y' then
3508: oe_debug_pub.add('PS_ATTR_GRP_PVT.Update_List_Lines ' || SQLERRM);
3509: else
3510: write_log( 'PS_ATTR_GRP_PVT.Update_List_Lines ' || SQLERRM );
3511: end if;
3512:

Line 3521: oe_debug_pub.add('total count - ' || g_list_line_id_final_tbl.COUNT);

3517: PROCEDURE populate_pp_atgrps
3518: is
3519: BEGIN
3520:
3521: oe_debug_pub.add('total count - ' || g_list_line_id_final_tbl.COUNT);
3522: FORALL i in 1 .. g_list_line_id_final_tbl.COUNT
3523: INSERT INTO qp_attribute_groups
3524:
3525: (list_header_id,

Line 3624: oe_debug_pub.add('PS_ATTR_GRP_PVT.populate_pp_atgrps ' || SQLERRM);

3620: g_automatic_flag_fnl_tbl(i) FROM dual WHERE g_pricing_phase_id_final_tbl(i) <> 1 ;
3621: EXCEPTION
3622: WHEN OTHERS THEN
3623: if g_call_from_setup = 'Y' then
3624: oe_debug_pub.add('PS_ATTR_GRP_PVT.populate_pp_atgrps ' || SQLERRM);
3625: else
3626: write_log( 'PS_ATTR_GRP_PVT.populate_pp_atgrps ' || SQLERRM );
3627: end if;
3628:

Line 3649: oe_debug_pub.add('PS_ATTR_GRP_PVT.Update_List_Lines_Cache_Key ' || SQLERRM);

3645:
3646: EXCEPTION
3647: WHEN OTHERS THEN
3648: if g_call_from_setup = 'Y' then
3649: oe_debug_pub.add('PS_ATTR_GRP_PVT.Update_List_Lines_Cache_Key ' || SQLERRM);
3650: else
3651: write_log( 'PS_ATTR_GRP_PVT.Update_List_Lines_Cache_Key ' || SQLERRM );
3652: end if;
3653:

Line 3790: oe_debug_pub.add('PS_ATTR_GRP_PVT.Populate_Atgrps ' || SQLERRM);

3786:
3787: EXCEPTION
3788: WHEN OTHERS THEN
3789: if g_call_from_setup = 'Y' then
3790: oe_debug_pub.add('PS_ATTR_GRP_PVT.Populate_Atgrps ' || SQLERRM);
3791: else
3792: write_log( 'PS_ATTR_GRP_PVT.Populate_Atgrps ' || SQLERRM );
3793: end if;
3794: raise;

Line 3802: oe_debug_pub.add('Reset temp tables');

3798: is
3799: begin
3800: /*
3801: if g_call_from_setup = 'Y' then
3802: oe_debug_pub.add('Reset temp tables');
3803: else
3804: write_log( 'Reset temp tables');
3805: end if;
3806: */

Line 3875: oe_debug_pub.add('Begin get_pattern_id');

3871: l_pattern_final_index number;
3872: begin
3873: /*
3874: if g_call_from_setup = 'Y' then
3875: oe_debug_pub.add('Begin get_pattern_id');
3876: else
3877: write_log( 'Begin get_pattern_id');
3878: end if;
3879: */

Line 3899: oe_debug_pub.add('l_pattern_to_be_created='||l_pattern_to_be_created);

3895: end;
3896:
3897: /*
3898: if g_call_from_setup = 'Y' then
3899: oe_debug_pub.add('l_pattern_to_be_created='||l_pattern_to_be_created);
3900: else
3901: write_log( 'l_pattern_to_be_created='||l_pattern_to_be_created);
3902: end if;
3903: */

Line 3933: oe_debug_pub.add('End get_pattern_id');

3929: populate_patterns;
3930: end if; -- l_pattern_to_be_created = 'Y'
3931: /*
3932: if g_call_from_setup = 'Y' then
3933: oe_debug_pub.add('End get_pattern_id');
3934: else
3935: write_log( 'End get_pattern_id');
3936: end if;
3937: */

Line 3944: oe_debug_pub.add('PS_ATTR_GRP_PVT.Get_Pattern_Id ' || SQLERRM);

3940:
3941: EXCEPTION
3942: WHEN OTHERS THEN
3943: if g_call_from_setup = 'Y' then
3944: oe_debug_pub.add('PS_ATTR_GRP_PVT.Get_Pattern_Id ' || SQLERRM);
3945: else
3946: write_log( 'PS_ATTR_GRP_PVT.Get_Pattern_Id ' || SQLERRM );
3947: end if;
3948:

Line 4016: oe_debug_pub.add('PS_ATTR_GRP_PVT.Reset_Final_Tables ' || SQLERRM);

4012:
4013: EXCEPTION
4014: WHEN OTHERS THEN
4015: if g_call_from_setup = 'Y' then
4016: oe_debug_pub.add('PS_ATTR_GRP_PVT.Reset_Final_Tables ' || SQLERRM);
4017: else
4018: write_log( 'PS_ATTR_GRP_PVT.Reset_Final_Tables ' || SQLERRM );
4019: end if;
4020:

Line 4079: oe_debug_pub.add('PS_ATTR_GRP_PVT.Reset_C_Tables ' || SQLERRM);

4075:
4076: EXCEPTION
4077: WHEN OTHERS THEN
4078: if g_call_from_setup = 'Y' then
4079: oe_debug_pub.add('PS_ATTR_GRP_PVT.Reset_C_Tables ' || SQLERRM);
4080: else
4081: write_log( 'PS_ATTR_GRP_PVT.Reset_C_Tables ' || SQLERRM );
4082: end if;
4083: end reset_c_tables;

Line 4106: oe_debug_pub.add('Begin Populate_Pattern_Phases for HP case');

4102: IF p_list_header_id is not null then
4103: -- HP case
4104: /*
4105: if g_call_from_setup = 'Y' then
4106: oe_debug_pub.add('Begin Populate_Pattern_Phases for HP case');
4107: else
4108: write_log( 'Begin Populate_Pattern_Phases for HP case');
4109: end if;
4110: */

Line 4211: oe_debug_pub.add('Begin Populate_Pattern_Phases for LP, PP case');

4207: else
4208: -- LP, PP case
4209: /*
4210: if g_call_from_setup = 'Y' then
4211: oe_debug_pub.add('Begin Populate_Pattern_Phases for LP, PP case');
4212: else
4213: write_log( 'Begin Populate_Pattern_Phases for LP, PP case');
4214: end if;
4215: */

Line 4227: oe_debug_pub.add('No pattern_phases found; go insert');

4223: exception
4224: when no_data_found then
4225: /*
4226: if g_call_from_setup = 'Y' then
4227: oe_debug_pub.add('No pattern_phases found; go insert');
4228: else
4229: write_log( 'No pattern_phases found; go insert');
4230: end if;
4231: */

Line 4265: oe_debug_pub.add('Insert failure:'||sqlerrm);

4261: end if;
4262:
4263: when others then
4264: if g_call_from_setup = 'Y' then
4265: oe_debug_pub.add('Insert failure:'||sqlerrm);
4266: else
4267: write_log( 'Insert failure:'||sqlerrm);
4268: end if;
4269: raise;

Line 4275: oe_debug_pub.add('End Populate_Pattern_Phases ');

4271:
4272: END IF; -- p_list_header_id is not null
4273: /*
4274: if g_call_from_setup = 'Y' then
4275: oe_debug_pub.add('End Populate_Pattern_Phases ');
4276: else
4277: write_log( 'End Populate_Pattern_Phases ');
4278: end if;
4279: */

Line 4284: oe_debug_pub.add('PS_ATTR_GRP_PVT.Populate_Pattern_Phases ' || SQLERRM);

4280:
4281: EXCEPTION
4282: WHEN OTHERS THEN
4283: if g_call_from_setup = 'Y' then
4284: oe_debug_pub.add('PS_ATTR_GRP_PVT.Populate_Pattern_Phases ' || SQLERRM);
4285: else
4286: write_log( 'PS_ATTR_GRP_PVT.Populate_Pattern_Phases ' || SQLERRM );
4287: end if;
4288: raise;

Line 4325: oe_debug_pub.add('Header_Pattern_Main - p_list_header_id = ' ||p_list_header_id);

4321: g_call_from_setup := 'Y';
4322: G_QP_DEBUG := 'N';
4323:
4324: if g_call_from_setup = 'Y' then
4325: oe_debug_pub.add('Header_Pattern_Main - p_list_header_id = ' ||p_list_header_id);
4326: oe_debug_pub.add('Header_Pattern_Main - p_qualifier_group = ' ||p_qualifier_group);
4327: oe_debug_pub.add('Header_Pattern_Main - p_setup_action = ' ||p_setup_action);
4328: else
4329: write_log( 'Header_Pattern_Main - p_list_header_id = ' ||p_list_header_id);

Line 4326: oe_debug_pub.add('Header_Pattern_Main - p_qualifier_group = ' ||p_qualifier_group);

4322: G_QP_DEBUG := 'N';
4323:
4324: if g_call_from_setup = 'Y' then
4325: oe_debug_pub.add('Header_Pattern_Main - p_list_header_id = ' ||p_list_header_id);
4326: oe_debug_pub.add('Header_Pattern_Main - p_qualifier_group = ' ||p_qualifier_group);
4327: oe_debug_pub.add('Header_Pattern_Main - p_setup_action = ' ||p_setup_action);
4328: else
4329: write_log( 'Header_Pattern_Main - p_list_header_id = ' ||p_list_header_id);
4330: write_log( 'Header_Pattern_Main - p_qualifier_group = ' ||p_qualifier_group);

Line 4327: oe_debug_pub.add('Header_Pattern_Main - p_setup_action = ' ||p_setup_action);

4323:
4324: if g_call_from_setup = 'Y' then
4325: oe_debug_pub.add('Header_Pattern_Main - p_list_header_id = ' ||p_list_header_id);
4326: oe_debug_pub.add('Header_Pattern_Main - p_qualifier_group = ' ||p_qualifier_group);
4327: oe_debug_pub.add('Header_Pattern_Main - p_setup_action = ' ||p_setup_action);
4328: else
4329: write_log( 'Header_Pattern_Main - p_list_header_id = ' ||p_list_header_id);
4330: write_log( 'Header_Pattern_Main - p_qualifier_group = ' ||p_qualifier_group);
4331: write_log( 'Header_Pattern_Main - p_setup_action = ' ||p_setup_action);

Line 4491: oe_debug_pub.add('Header_Pattern_Main - no_data_found in action UD ' );

4487:
4488: exception
4489: when no_data_found then
4490: if g_call_from_setup = 'Y' then
4491: oe_debug_pub.add('Header_Pattern_Main - no_data_found in action UD ' );
4492: end if;
4493: null;
4494:
4495: when others then

Line 4497: oe_debug_pub.add('Header_Pattern_Main - others exceptions in action UD ' );

4493: null;
4494:
4495: when others then
4496: if g_call_from_setup = 'Y' then
4497: oe_debug_pub.add('Header_Pattern_Main - others exceptions in action UD ' );
4498: end if;
4499: null;
4500: end;
4501: end if; -- p_setup_action = 'I'

Line 4574: oe_debug_pub.add('PS_ATTR_GRP_PVT.Header_Pattern_Main ' || SQLERRM);

4570:
4571: EXCEPTION
4572: WHEN OTHERS THEN
4573: if g_call_from_setup = 'Y' then
4574: oe_debug_pub.add('PS_ATTR_GRP_PVT.Header_Pattern_Main ' || SQLERRM);
4575: else
4576: write_log( 'PS_ATTR_GRP_PVT.Header_Pattern_Main ' || SQLERRM );
4577: end if;
4578:

Line 4599: oe_debug_pub.add('Line_Pattern_Main - p_list_header_id = ' ||p_list_header_id);

4595: g_call_from_setup := 'Y';
4596: G_QP_DEBUG := 'N';
4597:
4598: if g_call_from_setup = 'Y' then
4599: oe_debug_pub.add('Line_Pattern_Main - p_list_header_id = ' ||p_list_header_id);
4600: oe_debug_pub.add('Line_Pattern_Main - p_list_line_id = ' ||p_list_line_id);
4601: oe_debug_pub.add('Line_Pattern_Main - p_qualifier_group = ' ||p_qualifier_group);
4602: oe_debug_pub.add('Line_Pattern_Main - p_setup_action = ' ||p_setup_action);
4603: else

Line 4600: oe_debug_pub.add('Line_Pattern_Main - p_list_line_id = ' ||p_list_line_id);

4596: G_QP_DEBUG := 'N';
4597:
4598: if g_call_from_setup = 'Y' then
4599: oe_debug_pub.add('Line_Pattern_Main - p_list_header_id = ' ||p_list_header_id);
4600: oe_debug_pub.add('Line_Pattern_Main - p_list_line_id = ' ||p_list_line_id);
4601: oe_debug_pub.add('Line_Pattern_Main - p_qualifier_group = ' ||p_qualifier_group);
4602: oe_debug_pub.add('Line_Pattern_Main - p_setup_action = ' ||p_setup_action);
4603: else
4604: write_log( 'Line_Pattern_Main - p_list_header_id = ' ||p_list_header_id);

Line 4601: oe_debug_pub.add('Line_Pattern_Main - p_qualifier_group = ' ||p_qualifier_group);

4597:
4598: if g_call_from_setup = 'Y' then
4599: oe_debug_pub.add('Line_Pattern_Main - p_list_header_id = ' ||p_list_header_id);
4600: oe_debug_pub.add('Line_Pattern_Main - p_list_line_id = ' ||p_list_line_id);
4601: oe_debug_pub.add('Line_Pattern_Main - p_qualifier_group = ' ||p_qualifier_group);
4602: oe_debug_pub.add('Line_Pattern_Main - p_setup_action = ' ||p_setup_action);
4603: else
4604: write_log( 'Line_Pattern_Main - p_list_header_id = ' ||p_list_header_id);
4605: write_log( 'Line_Pattern_Main - p_list_line_id = ' ||p_list_line_id);

Line 4602: oe_debug_pub.add('Line_Pattern_Main - p_setup_action = ' ||p_setup_action);

4598: if g_call_from_setup = 'Y' then
4599: oe_debug_pub.add('Line_Pattern_Main - p_list_header_id = ' ||p_list_header_id);
4600: oe_debug_pub.add('Line_Pattern_Main - p_list_line_id = ' ||p_list_line_id);
4601: oe_debug_pub.add('Line_Pattern_Main - p_qualifier_group = ' ||p_qualifier_group);
4602: oe_debug_pub.add('Line_Pattern_Main - p_setup_action = ' ||p_setup_action);
4603: else
4604: write_log( 'Line_Pattern_Main - p_list_header_id = ' ||p_list_header_id);
4605: write_log( 'Line_Pattern_Main - p_list_line_id = ' ||p_list_line_id);
4606: write_log( 'Line_Pattern_Main - p_qualifier_group = ' ||p_qualifier_group);

Line 4725: oe_debug_pub.add('Line_Pattern_Main - no_data_found in action UD ' );

4721:
4722: exception
4723: when no_data_found then
4724: if g_call_from_setup = 'Y' then
4725: oe_debug_pub.add('Line_Pattern_Main - no_data_found in action UD ' );
4726: end if;
4727: null;
4728:
4729: when others then

Line 4731: oe_debug_pub.add('Line_Pattern_Main - others exceptions in action UD ' );

4727: null;
4728:
4729: when others then
4730: if g_call_from_setup = 'Y' then
4731: oe_debug_pub.add('Line_Pattern_Main - others exceptions in action UD ' );
4732: end if;
4733: null;
4734: end;
4735: end if; -- p_setup_action = 'I'

Line 4824: oe_debug_pub.add('PS_ATTR_GRP_PVT.Line_Pattern_Main ' || SQLERRM);

4820:
4821: EXCEPTION
4822: WHEN OTHERS THEN
4823: if g_call_from_setup = 'Y' then
4824: oe_debug_pub.add('PS_ATTR_GRP_PVT.Line_Pattern_Main ' || SQLERRM);
4825: else
4826: write_log( 'PS_ATTR_GRP_PVT.Line_Pattern_Main ' || SQLERRM );
4827: end if;
4828:

Line 4847: oe_debug_pub.add('Product_Pattern_Main - p_list_header_id = ' ||p_list_header_id);

4843: g_qp_pattern_search := FND_PROFILE.VALUE('QP_PATTERN_SEARCH');
4844: g_call_from_setup := 'Y';
4845: G_QP_DEBUG := 'N';
4846: if g_call_from_setup = 'Y' then
4847: oe_debug_pub.add('Product_Pattern_Main - p_list_header_id = ' ||p_list_header_id);
4848: oe_debug_pub.add('Product_Pattern_Main - p_list_line_id = ' ||p_list_line_id);
4849: oe_debug_pub.add('Product_Pattern_Main - p_setup_action = ' ||p_setup_action);
4850: else
4851: write_log( 'Product_Pattern_Main - p_list_header_id = ' ||p_list_header_id);

Line 4848: oe_debug_pub.add('Product_Pattern_Main - p_list_line_id = ' ||p_list_line_id);

4844: g_call_from_setup := 'Y';
4845: G_QP_DEBUG := 'N';
4846: if g_call_from_setup = 'Y' then
4847: oe_debug_pub.add('Product_Pattern_Main - p_list_header_id = ' ||p_list_header_id);
4848: oe_debug_pub.add('Product_Pattern_Main - p_list_line_id = ' ||p_list_line_id);
4849: oe_debug_pub.add('Product_Pattern_Main - p_setup_action = ' ||p_setup_action);
4850: else
4851: write_log( 'Product_Pattern_Main - p_list_header_id = ' ||p_list_header_id);
4852: write_log( 'Product_Pattern_Main - p_list_line_id = ' ||p_list_line_id);

Line 4849: oe_debug_pub.add('Product_Pattern_Main - p_setup_action = ' ||p_setup_action);

4845: G_QP_DEBUG := 'N';
4846: if g_call_from_setup = 'Y' then
4847: oe_debug_pub.add('Product_Pattern_Main - p_list_header_id = ' ||p_list_header_id);
4848: oe_debug_pub.add('Product_Pattern_Main - p_list_line_id = ' ||p_list_line_id);
4849: oe_debug_pub.add('Product_Pattern_Main - p_setup_action = ' ||p_setup_action);
4850: else
4851: write_log( 'Product_Pattern_Main - p_list_header_id = ' ||p_list_header_id);
4852: write_log( 'Product_Pattern_Main - p_list_line_id = ' ||p_list_line_id);
4853: write_log( 'Product_Pattern_Main - p_setup_action = ' ||p_setup_action);

Line 4868: oe_debug_pub.add('Product_Pattern_Main - l_qual_ind = ' ||l_qual_ind);

4864: ELSE
4865: g_list_type := 'JP';
4866: END IF;
4867:
4868: oe_debug_pub.add('Product_Pattern_Main - l_qual_ind = ' ||l_qual_ind);
4869:
4870: -- do nothing, return back if called for child line, bug 3581058
4871: if l_qual_ind in (4, 6, 8, 10, 12, 14, 20, 22, 28, 30,0,2) then
4872: null;

Line 4911: oe_debug_pub.add('going to populate LP');

4907: end;
4908:
4909: if l_qual_exists = 'Y' then
4910: if g_call_from_setup = 'Y' then
4911: oe_debug_pub.add('going to populate LP');
4912: else
4913: write_log( 'going to populate LP');
4914: end if;
4915: Line_Pattern_Main(p_list_header_id, p_list_line_id, null, 'I');

Line 4918: oe_debug_pub.add('going to populate PP');

4914: end if;
4915: Line_Pattern_Main(p_list_header_id, p_list_line_id, null, 'I');
4916: else
4917: if g_call_from_setup = 'Y' then
4918: oe_debug_pub.add('going to populate PP');
4919: else
4920: write_log( 'going to populate PP');
4921: end if;
4922:

Line 4991: oe_debug_pub.add('PS_ATTR_GRP_PVT.Product_Pattern_Main ' || SQLERRM);

4987:
4988: EXCEPTION
4989: WHEN OTHERS THEN
4990: if g_call_from_setup = 'Y' then
4991: oe_debug_pub.add('PS_ATTR_GRP_PVT.Product_Pattern_Main ' || SQLERRM);
4992: else
4993: write_log( 'PS_ATTR_GRP_PVT.Product_Pattern_Main ' || SQLERRM );
4994: end if;
4995:

Line 5017: oe_debug_pub.add('Deleted records from qp_attribute_groups for PP for list_line_id:'||p_list_line_id);

5013:
5014: where list_line_id = p_list_line_id;
5015:
5016: if g_call_from_setup = 'Y' then
5017: oe_debug_pub.add('Deleted records from qp_attribute_groups for PP for list_line_id:'||p_list_line_id);
5018: else
5019: write_log( 'Deleted records from qp_attribute_groups for PP for list_line_id:'||p_list_line_id);
5020: end if;
5021:

Line 5032: oe_debug_pub.add('PS_ATTR_GRP_PVT.Remove_Prod_Pattern_For_Line ' || SQLERRM);

5028: null;
5029:
5030: when others then
5031: if g_call_from_setup = 'Y' then
5032: oe_debug_pub.add('PS_ATTR_GRP_PVT.Remove_Prod_Pattern_For_Line ' || SQLERRM);
5033: else
5034: write_log( 'PS_ATTR_GRP_PVT.Remove_Prod_Pattern_For_Line ' || SQLERRM );
5035: end if;
5036: raise;

Line 5077: oe_debug_pub.add('Inside Update_Qual_Segment_id');

5073:
5074: begin
5075: -- update the segment_id columns for qualifiers
5076: if g_call_from_setup = 'Y' then
5077: oe_debug_pub.add('Inside Update_Qual_Segment_id');
5078: oe_debug_pub.add('Start time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
5079: else
5080: write_log( 'Inside Update_Qual_Segment_id');
5081: write_log( 'Start time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));

Line 5078: oe_debug_pub.add('Start time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));

5074: begin
5075: -- update the segment_id columns for qualifiers
5076: if g_call_from_setup = 'Y' then
5077: oe_debug_pub.add('Inside Update_Qual_Segment_id');
5078: oe_debug_pub.add('Start time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
5079: else
5080: write_log( 'Inside Update_Qual_Segment_id');
5081: write_log( 'Start time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
5082: end if;

Line 5103: oe_debug_pub.add('Context_t.count='||context_t.count);

5099: END IF;
5100:
5101: if context_t.count > 0 then
5102: if g_call_from_setup = 'Y' then
5103: oe_debug_pub.add('Context_t.count='||context_t.count);
5104: else
5105: write_log( 'Context_t.count='||context_t.count);
5106: end if;
5107: FOR i in 1..context_t.count

Line 5126: oe_debug_pub.add('No of qualifiers updated='||SQL%ROWCOUNT);

5122: and list_header_id = nvl(p_list_header_id, list_header_id)
5123: and list_line_id between p_low_list_line_id and p_high_list_line_id;
5124:
5125: if g_call_from_setup = 'Y' then
5126: oe_debug_pub.add('No of qualifiers updated='||SQL%ROWCOUNT);
5127: else
5128: write_log( 'No of qualifiers updated='||SQL%ROWCOUNT);
5129: end if;
5130: end if; -- context_t.count > 0

Line 5133: oe_debug_pub.add('End Update_Qual_Segment_id');

5129: end if;
5130: end if; -- context_t.count > 0
5131:
5132: if g_call_from_setup = 'Y' then
5133: oe_debug_pub.add('End Update_Qual_Segment_id');
5134: oe_debug_pub.add('End time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
5135: else
5136: write_log( 'End Update_Qual_Segment_id');
5137: write_log( 'End time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));

Line 5134: oe_debug_pub.add('End time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));

5130: end if; -- context_t.count > 0
5131:
5132: if g_call_from_setup = 'Y' then
5133: oe_debug_pub.add('End Update_Qual_Segment_id');
5134: oe_debug_pub.add('End time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
5135: else
5136: write_log( 'End Update_Qual_Segment_id');
5137: write_log( 'End time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
5138: end if;

Line 5142: oe_debug_pub.add('No data found in c_qual_seg_id');

5138: end if;
5139: exception
5140: when no_data_found then
5141: if g_call_from_setup = 'Y' then
5142: oe_debug_pub.add('No data found in c_qual_seg_id');
5143: else
5144: write_log( 'No data found in c_qual_seg_id');
5145: end if;
5146:

Line 5149: oe_debug_pub.add('PS_ATTR_GRP_PVT.Update_Qual_Segment_Id ' || SQLERRM);

5145: end if;
5146:
5147: when others then
5148: if g_call_from_setup = 'Y' then
5149: oe_debug_pub.add('PS_ATTR_GRP_PVT.Update_Qual_Segment_Id ' || SQLERRM);
5150: else
5151: write_log( 'PS_ATTR_GRP_PVT.Update_Qual_Segment_Id ' || SQLERRM );
5152: end if;
5153:

Line 5202: oe_debug_pub.add('Inside Update_Prod_Pric_Segment_id');

5198:
5199:
5200: begin
5201: if g_call_from_setup = 'Y' then
5202: oe_debug_pub.add('Inside Update_Prod_Pric_Segment_id');
5203: oe_debug_pub.add('Start time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
5204: else
5205: write_log( 'Inside Update_Prod_Pric_Segment_id');
5206: write_log( 'Start time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));

Line 5203: oe_debug_pub.add('Start time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));

5199:
5200: begin
5201: if g_call_from_setup = 'Y' then
5202: oe_debug_pub.add('Inside Update_Prod_Pric_Segment_id');
5203: oe_debug_pub.add('Start time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
5204: else
5205: write_log( 'Inside Update_Prod_Pric_Segment_id');
5206: write_log( 'Start time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
5207: end if;

Line 5229: oe_debug_pub.add('Context_t.count='||context_t.count);

5225: END if;
5226:
5227: if context_t.count > 0 then
5228: if g_call_from_setup = 'Y' then
5229: oe_debug_pub.add('Context_t.count='||context_t.count);
5230: else
5231: write_log( 'Context_t.count='||context_t.count);
5232: end if;
5233: FOR i in 1..context_t.count

Line 5252: oe_debug_pub.add('No of product segment ids updated='||SQL%ROWCOUNT);

5248: and list_header_id = nvl(p_list_header_id, list_header_id)
5249: and list_line_id between p_low_list_line_id and p_high_list_line_id;
5250:
5251: if g_call_from_setup = 'Y' then
5252: oe_debug_pub.add('No of product segment ids updated='||SQL%ROWCOUNT);
5253: oe_debug_pub.add('End Time product segments :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
5254: else
5255: write_log( 'No of product segment ids updated='||SQL%ROWCOUNT);
5256: write_log( 'End time product segments :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));

Line 5253: oe_debug_pub.add('End Time product segments :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));

5249: and list_line_id between p_low_list_line_id and p_high_list_line_id;
5250:
5251: if g_call_from_setup = 'Y' then
5252: oe_debug_pub.add('No of product segment ids updated='||SQL%ROWCOUNT);
5253: oe_debug_pub.add('End Time product segments :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
5254: else
5255: write_log( 'No of product segment ids updated='||SQL%ROWCOUNT);
5256: write_log( 'End time product segments :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
5257: end if;

Line 5281: oe_debug_pub.add('Context_t.count='||context_t.count);

5277: END if;
5278:
5279: if context_t.count > 0 then
5280: if g_call_from_setup = 'Y' then
5281: oe_debug_pub.add('Context_t.count='||context_t.count);
5282: else
5283: write_log( 'Context_t.count='||context_t.count);
5284: end if;
5285:

Line 5305: oe_debug_pub.add('No of pricing segment ids updated='||SQL%ROWCOUNT);

5301: and list_header_id = nvl(p_list_header_id, list_header_id)
5302: and list_line_id between p_low_list_line_id and p_high_list_line_id;
5303:
5304: if g_call_from_setup = 'Y' then
5305: oe_debug_pub.add('No of pricing segment ids updated='||SQL%ROWCOUNT);
5306: oe_debug_pub.add('End Time pricing segments :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
5307: else
5308: write_log( 'No of pricing segment ids updated='||SQL%ROWCOUNT);
5309: write_log( 'End time pricing segments :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));

Line 5306: oe_debug_pub.add('End Time pricing segments :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));

5302: and list_line_id between p_low_list_line_id and p_high_list_line_id;
5303:
5304: if g_call_from_setup = 'Y' then
5305: oe_debug_pub.add('No of pricing segment ids updated='||SQL%ROWCOUNT);
5306: oe_debug_pub.add('End Time pricing segments :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
5307: else
5308: write_log( 'No of pricing segment ids updated='||SQL%ROWCOUNT);
5309: write_log( 'End time pricing segments :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
5310: end if;

Line 5314: oe_debug_pub.add('End Update_Prod_Pric_Segment_id');

5310: end if;
5311: end if; -- context_t.count > 0
5312:
5313: if g_call_from_setup = 'Y' then
5314: oe_debug_pub.add('End Update_Prod_Pric_Segment_id');
5315: else
5316: write_log( 'End Update_Prod_Pric_Segment_id');
5317: end if;
5318: exception

Line 5321: oe_debug_pub.add('No data found in Update_Prod_Pric_Segment_id');

5317: end if;
5318: exception
5319: when no_data_found then
5320: if g_call_from_setup = 'Y' then
5321: oe_debug_pub.add('No data found in Update_Prod_Pric_Segment_id');
5322: else
5323: write_log( 'No data found in Update_Prod_Pric_Segment_id');
5324: end if;
5325:

Line 5330: oe_debug_pub.add('PS_ATTR_GRP_PVT.Update_Prod_Pric_Segment_id ' || SQLERRM);

5326: null;
5327:
5328: when others then
5329: if g_call_from_setup = 'Y' then
5330: oe_debug_pub.add('PS_ATTR_GRP_PVT.Update_Prod_Pric_Segment_id ' || SQLERRM);
5331: else
5332: write_log( 'PS_ATTR_GRP_PVT.Update_Prod_Pric_Segment_id ' || SQLERRM );
5333: end if;
5334: