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_ATTR_GRP_PVT dependencies on OE_DEBUG_PUB

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

24:
25: begin
26:
27: if g_call_from_setup = 'Y' then
28: oe_debug_pub.add('Begin create pattern slabs');
29: else
30: fnd_file.put_line(FND_FILE.LOG, 'Begin create pattern slabs');
31: fnd_file.put_line(FND_FILE.LOG, 'Start time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
32: end if;

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

36: end if;
37: l_gap := round(p_total_lines / l_no_of_threads, 0);
38:
39: if g_call_from_setup = 'Y' then
40: oe_debug_pub.add('Total lines:'||p_total_lines);
41: oe_debug_pub.add('l_gap:'||l_gap);
42: else
43: fnd_file.put_line(FND_FILE.LOG, 'Total lines:'||p_total_lines);
44: fnd_file.put_line(FND_FILE.LOG, 'l_gap:'||l_gap);

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

37: l_gap := round(p_total_lines / l_no_of_threads, 0);
38:
39: if g_call_from_setup = 'Y' then
40: oe_debug_pub.add('Total lines:'||p_total_lines);
41: oe_debug_pub.add('l_gap:'||l_gap);
42: else
43: fnd_file.put_line(FND_FILE.LOG, 'Total lines:'||p_total_lines);
44: fnd_file.put_line(FND_FILE.LOG, 'l_gap:'||l_gap);
45: end if;

Line 167: oe_debug_pub.add('ATTR_GRP_PVT.Remove_Duplicate_Patterns ' || SQLERRM);

163:
164: EXCEPTION
165: WHEN OTHERS THEN
166: if g_call_from_setup = 'Y' then
167: oe_debug_pub.add('ATTR_GRP_PVT.Remove_Duplicate_Patterns ' || SQLERRM);
168: else
169: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Remove_Duplicate_Patterns ' || SQLERRM );
170: end if;
171:

Line 407: oe_debug_pub.add('ATTR_GRP_PVT.Pattern_Upgrade ' || SQLERRM);

403: retcode := 0;
404: exception
405: when others then
406: if g_call_from_setup = 'Y' then
407: oe_debug_pub.add('ATTR_GRP_PVT.Pattern_Upgrade ' || SQLERRM);
408: else
409: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Pattern_Upgrade ' || SQLERRM );
410: end if;
411: err_buff := 'Others Error in procedure Pattern_Upgrade';

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

454: order by qpq.list_header_id, qpq.list_line_id, qpq.segment_id;
455: begin
456: -- delete the data from cursor, temp and final tables to start with
457: if g_call_from_setup = 'Y' then
458: oe_debug_pub.add('Begin generate_hp_atgrps');
459: else
460: fnd_file.put_line(FND_FILE.LOG, 'Begin generate_hp_atgrps');
461: end if;
462: Reset_c_tables;

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

491: if g_list_header_id_c_tbl.count > 0 then
492: process_c_tables('HP');
493: end if;
494: if g_call_from_setup = 'Y' then
495: oe_debug_pub.add('End generate_hp_atgrps');
496: else
497: fnd_file.put_line(FND_FILE.LOG, 'End generate_hp_atgrps');
498: end if;
499:

Line 503: oe_debug_pub.add('ATTR_GRP_PVT.Generate_Hp_Atgrps ' || SQLERRM);

499:
500: EXCEPTION
501: WHEN OTHERS THEN
502: if g_call_from_setup = 'Y' then
503: oe_debug_pub.add('ATTR_GRP_PVT.Generate_Hp_Atgrps ' || SQLERRM);
504: else
505: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Generate_Hp_Atgrps ' || SQLERRM );
506: end if;
507:

Line 647: oe_debug_pub.add('ATTR_GRP_PVT.Generate_Lp_Atgrps ' || SQLERRM);

643:
644: EXCEPTION
645: WHEN OTHERS THEN
646: if g_call_from_setup = 'Y' then
647: oe_debug_pub.add('ATTR_GRP_PVT.Generate_Lp_Atgrps ' || SQLERRM);
648: else
649: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Generate_Lp_Atgrps ' || SQLERRM );
650: end if;
651:

Line 726: oe_debug_pub.add('ATTR_GRP_PVT.Update_Pp_Lines ' || SQLERRM);

722:
723: EXCEPTION
724: WHEN OTHERS THEN
725: if g_call_from_setup = 'Y' then
726: oe_debug_pub.add('ATTR_GRP_PVT.Update_Pp_Lines ' || SQLERRM);
727: else
728: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Update_Pp_Lines ' || SQLERRM );
729: end if;
730:

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

745: l_old_list_header_id := g_init_val;
746: l_old_list_line_id := g_init_val;
747:
748: if g_call_from_setup = 'Y' then
749: oe_debug_pub.add('Start process_c_tables - Pattern type '||p_pattern_type);
750: oe_debug_pub.add('cursor tables total = ' || g_list_header_id_c_tbl.count);
751: else
752: QP_PREQ_GRP.Set_QP_Debug;
753: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;

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

746: l_old_list_line_id := g_init_val;
747:
748: if g_call_from_setup = 'Y' then
749: oe_debug_pub.add('Start process_c_tables - Pattern type '||p_pattern_type);
750: oe_debug_pub.add('cursor tables total = ' || g_list_header_id_c_tbl.count);
751: else
752: QP_PREQ_GRP.Set_QP_Debug;
753: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
754: IF l_debug = FND_API.G_TRUE THEN

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

760: if g_list_header_id_c_tbl.count > 0 then
761: for i in 1..g_list_header_id_c_tbl.count
762: loop
763: if g_call_from_setup = 'Y' then
764: oe_debug_pub.add('i = ' || i ||
765: ', list_header_id = ' || g_list_header_id_c_tbl(i) ||
766: ', list_line_id = ' || g_list_line_id_c_tbl(i) ||
767: ', group = ' || g_qual_grouping_no_c_tbl(i) ||
768: ', operator = ' || g_comparison_opr_code_c_tbl(i));

Line 769: --oe_debug_pub.add('l_old_list_header_id ' || l_old_list_header_id);

765: ', list_header_id = ' || g_list_header_id_c_tbl(i) ||
766: ', list_line_id = ' || g_list_line_id_c_tbl(i) ||
767: ', group = ' || g_qual_grouping_no_c_tbl(i) ||
768: ', operator = ' || g_comparison_opr_code_c_tbl(i));
769: --oe_debug_pub.add('l_old_list_header_id ' || l_old_list_header_id);
770: --oe_debug_pub.add('l_old_list_line_id ' || l_old_list_line_id);
771: elsif l_debug = FND_API.G_TRUE then
772: fnd_file.put_line(FND_FILE.LOG, 'i = ' || i ||
773: ', list_header_id = ' || g_list_header_id_c_tbl(i) ||

Line 770: --oe_debug_pub.add('l_old_list_line_id ' || l_old_list_line_id);

766: ', list_line_id = ' || g_list_line_id_c_tbl(i) ||
767: ', group = ' || g_qual_grouping_no_c_tbl(i) ||
768: ', operator = ' || g_comparison_opr_code_c_tbl(i));
769: --oe_debug_pub.add('l_old_list_header_id ' || l_old_list_header_id);
770: --oe_debug_pub.add('l_old_list_line_id ' || l_old_list_line_id);
771: elsif l_debug = FND_API.G_TRUE then
772: fnd_file.put_line(FND_FILE.LOG, 'i = ' || i ||
773: ', list_header_id = ' || g_list_header_id_c_tbl(i) ||
774: ', list_line_id = ' || g_list_line_id_c_tbl(i) ||

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

788: -- logic to insert into tables every G_LINES_PER_INSERT lines
789: l_line_counter := l_line_counter + 1;
790: if l_line_counter >= G_LINES_PER_INSERT then
791: if g_call_from_setup = 'Y' then
792: oe_debug_pub.add('inserting data for ' || G_LINES_PER_INSERT || ' lines');
793: elsif l_debug = FND_API.G_TRUE then
794: fnd_file.put_line(FND_FILE.LOG, 'inserting data for ' || G_LINES_PER_INSERT || ' lines');
795: end if;
796: populate_atgrps;

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

812: if g_qual_grouping_no_tmp_tbl.exists(l_current_grp) = TRUE then
813:
814: /*
815: if g_call_from_setup = 'Y' then
816: oe_debug_pub.add('record exists in temp table for current group');
817: oe_debug_pub.add('current record Operator is ' || g_comparison_opr_code_c_tbl(i));
818: else
819: fnd_file.put_line(FND_FILE.LOG, 'record exists in temp table for current group');
820: fnd_file.put_line(FND_FILE.LOG, 'current record Operator is ' || g_comparison_opr_code_c_tbl(i));

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

813:
814: /*
815: if g_call_from_setup = 'Y' then
816: oe_debug_pub.add('record exists in temp table for current group');
817: oe_debug_pub.add('current record Operator is ' || g_comparison_opr_code_c_tbl(i));
818: else
819: fnd_file.put_line(FND_FILE.LOG, 'record exists in temp table for current group');
820: fnd_file.put_line(FND_FILE.LOG, 'current record Operator is ' || g_comparison_opr_code_c_tbl(i));
821: end if;

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

828: while other_grp_index is not null
829: LOOP
830: /*
831: if g_call_from_setup = 'Y' then
832: oe_debug_pub.add('other_grp_index = ' || other_grp_index);
833: else
834: fnd_file.put_line(FND_FILE.LOG, 'other_grp_index = ' || other_grp_index);
835: end if;
836: */

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

938:
939: else -- record does not exists for the group
940: /*
941: if g_call_from_setup = 'Y' then
942: oe_debug_pub.add('record DOES NOT exists in temp table for current group');
943: oe_debug_pub.add('current record Operator is ' || g_comparison_opr_code_c_tbl(i));
944: else
945: fnd_file.put_line(FND_FILE.LOG, 'record DOES NOT exists in temp table for current group');
946: fnd_file.put_line(FND_FILE.LOG, 'current record Operator is ' || g_comparison_opr_code_c_tbl(i));

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

939: else -- record does not exists for the group
940: /*
941: if g_call_from_setup = 'Y' then
942: oe_debug_pub.add('record DOES NOT exists in temp table for current group');
943: oe_debug_pub.add('current record Operator is ' || g_comparison_opr_code_c_tbl(i));
944: else
945: fnd_file.put_line(FND_FILE.LOG, 'record DOES NOT exists in temp table for current group');
946: fnd_file.put_line(FND_FILE.LOG, 'current record Operator is ' || g_comparison_opr_code_c_tbl(i));
947: end if;

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

955: while other_grp_index is not null
956: LOOP
957: /*
958: if g_call_from_setup = 'Y' then
959: oe_debug_pub.add('other_grp_index = ' || other_grp_index);
960: else
961: fnd_file.put_line(FND_FILE.LOG, 'other_grp_index = ' || other_grp_index);
962: end if;
963: */

Line 1161: oe_debug_pub.add('ATTR_GRP_PVT.Process_C_Tables ' || SQLERRM);

1157:
1158: EXCEPTION
1159: WHEN OTHERS THEN
1160: if g_call_from_setup = 'Y' then
1161: oe_debug_pub.add('ATTR_GRP_PVT.Process_C_Tables ' || SQLERRM);
1162: else
1163: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Process_C_Tables ' || SQLERRM );
1164: end if;
1165:

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

1178: l_old_list_header_id := g_init_val;
1179: l_old_list_line_id := g_init_val;
1180:
1181: if g_call_from_setup = 'Y' then
1182: oe_debug_pub.add('PP cursor tables total = ' || g_list_header_id_c_tbl.count);
1183: else
1184: QP_PREQ_GRP.Set_QP_Debug;
1185: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
1186: IF l_debug = FND_API.G_TRUE THEN

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

1193: if g_list_header_id_c_tbl.count > 0 then
1194: for i in 1..g_list_header_id_c_tbl.count
1195: loop
1196: if g_call_from_setup = 'Y' then
1197: oe_debug_pub.add('PP i = ' || i ||
1198: ', list_header_id = ' || g_list_header_id_c_tbl(i) ||
1199: ', list_line_id = ' || g_list_line_id_c_tbl(i) ||
1200: ', operator = ' || g_comparison_opr_code_c_tbl(i));
1201: --oe_debug_pub.add('PP l_old_list_header_id ' || l_old_list_header_id);

Line 1201: --oe_debug_pub.add('PP l_old_list_header_id ' || l_old_list_header_id);

1197: oe_debug_pub.add('PP i = ' || i ||
1198: ', list_header_id = ' || g_list_header_id_c_tbl(i) ||
1199: ', list_line_id = ' || g_list_line_id_c_tbl(i) ||
1200: ', operator = ' || g_comparison_opr_code_c_tbl(i));
1201: --oe_debug_pub.add('PP l_old_list_header_id ' || l_old_list_header_id);
1202: --oe_debug_pub.add('PP l_old_list_line_id ' || l_old_list_line_id);
1203: elsif l_debug = FND_API.G_TRUE then
1204: fnd_file.put_line(FND_FILE.LOG, 'PP i = ' || i ||
1205: ', list_header_id = ' || g_list_header_id_c_tbl(i) ||

Line 1202: --oe_debug_pub.add('PP l_old_list_line_id ' || l_old_list_line_id);

1198: ', list_header_id = ' || g_list_header_id_c_tbl(i) ||
1199: ', list_line_id = ' || g_list_line_id_c_tbl(i) ||
1200: ', operator = ' || g_comparison_opr_code_c_tbl(i));
1201: --oe_debug_pub.add('PP l_old_list_header_id ' || l_old_list_header_id);
1202: --oe_debug_pub.add('PP l_old_list_line_id ' || l_old_list_line_id);
1203: elsif l_debug = FND_API.G_TRUE then
1204: fnd_file.put_line(FND_FILE.LOG, 'PP i = ' || i ||
1205: ', list_header_id = ' || g_list_header_id_c_tbl(i) ||
1206: ', list_line_id = ' || g_list_line_id_c_tbl(i) ||

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

1220: -- logic to insert into tables every G_LINES_PER_INSERT lines
1221: l_line_counter := l_line_counter + 1;
1222: if l_line_counter >= G_LINES_PER_INSERT then
1223: if g_call_from_setup = 'Y' then
1224: oe_debug_pub.add('inserting data for ' || G_LINES_PER_INSERT || ' lines');
1225: elsif l_debug = FND_API.G_TRUE then
1226: fnd_file.put_line(FND_FILE.LOG, 'inserting data for ' || G_LINES_PER_INSERT || ' lines');
1227: end if;
1228: update_list_lines;

Line 1336: oe_debug_pub.add('ATTR_GRP_PVT.Process_C_Tables_Pp ' || SQLERRM);

1332:
1333: EXCEPTION
1334: WHEN OTHERS THEN
1335: if g_call_from_setup = 'Y' then
1336: oe_debug_pub.add('ATTR_GRP_PVT.Process_C_Tables_Pp ' || SQLERRM);
1337: else
1338: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Process_C_Tables_Pp ' || SQLERRM );
1339: end if;
1340:

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

1349: l_product_precedence number;
1350: BEGIN
1351: /*
1352: if g_call_from_setup = 'Y' then
1353: oe_debug_pub.add('Moving data from temp table to final table');
1354: oe_debug_pub.add('temp tables total = ' || g_list_header_id_tmp_tbl.count);
1355: else
1356: fnd_file.put_line(FND_FILE.LOG, 'Moving data from temp table to final table');
1357: fnd_file.put_line(FND_FILE.LOG, 'temp tables total = ' || g_list_header_id_tmp_tbl.count);

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

1350: BEGIN
1351: /*
1352: if g_call_from_setup = 'Y' then
1353: oe_debug_pub.add('Moving data from temp table to final table');
1354: oe_debug_pub.add('temp tables total = ' || g_list_header_id_tmp_tbl.count);
1355: else
1356: fnd_file.put_line(FND_FILE.LOG, 'Moving data from temp table to final table');
1357: fnd_file.put_line(FND_FILE.LOG, 'temp tables total = ' || g_list_header_id_tmp_tbl.count);
1358: end if;

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

1365: end if; -- g_list_header_id_tmp_tbl.count > 1
1366:
1367: /*
1368: if g_call_from_setup = 'Y' then
1369: oe_debug_pub.add('l_other_grp_exists = ' || l_other_grp_exists);
1370: else
1371: fnd_file.put_line(FND_FILE.LOG, 'l_other_grp_exists = ' || l_other_grp_exists);
1372: end if;
1373: */

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

1377: while grp_no_index is not null
1378: LOOP
1379: /*
1380: if g_call_from_setup = 'Y' then
1381: oe_debug_pub.add('grouping no = ' || grp_no_index);
1382: else
1383: fnd_file.put_line(FND_FILE.LOG, 'grouping no = ' || grp_no_index);
1384: end if;
1385: */

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

1394: l_pattern_id := -1;
1395: end if;
1396: /*
1397: if g_call_from_setup = 'Y' then
1398: oe_debug_pub.add('Pattern_id='||l_pattern_id);
1399: else
1400: fnd_file.put_line(FND_FILE.LOG, 'Pattern_id='||l_pattern_id);
1401: end if;
1402: */

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

1410:
1411: -- move the data from tmp tables to final tables for qp_attribute_groups
1412: /*
1413: if g_call_from_setup = 'Y' then
1414: oe_debug_pub.add('move the data from tmp tables to final tables for qp_attribute_groups');
1415: else
1416: fnd_file.put_line(FND_FILE.LOG, 'move the data from tmp tables to final tables for qp_attribute_groups');
1417: end if;
1418: */

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

1448: g_effec_precedence_final_tbl(l_atgrp_final_index) := l_product_precedence;
1449: end if;
1450: /*
1451: if g_call_from_setup = 'Y' then
1452: oe_debug_pub.add('cache_key should be just list_header_id ');
1453: else
1454: fnd_file.put_line(FND_FILE.LOG, 'cache_key should be just list_header_id ');
1455: end if;
1456: */

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

1457: else
1458: g_cache_key_final_tbl(l_atgrp_final_index) := g_cache_key_tmp_tbl(grp_no_index);
1459: /*
1460: if g_call_from_setup = 'Y' then
1461: oe_debug_pub.add('cache_key should be standard OR null');
1462: else
1463: fnd_file.put_line(FND_FILE.LOG, 'cache_key should be standard OR null');
1464: end if;
1465: */

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

1485:
1486: END LOOP; -- while
1487: /*
1488: if g_call_from_setup = 'Y' then
1489: oe_debug_pub.add('End Moving data from temp table to final table');
1490: else
1491: fnd_file.put_line(FND_FILE.LOG, 'End Moving data from temp table to final table');
1492: end if;
1493: */

Line 1498: oe_debug_pub.add('ATTR_GRP_PVT.Move_Data_From_Tmp_To_Final ' || SQLERRM);

1494:
1495: EXCEPTION
1496: WHEN OTHERS THEN
1497: if g_call_from_setup = 'Y' then
1498: oe_debug_pub.add('ATTR_GRP_PVT.Move_Data_From_Tmp_To_Final ' || SQLERRM);
1499: else
1500: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Move_Data_From_Tmp_To_Final ' || SQLERRM );
1501: end if;
1502:

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

1508: BEGIN
1509:
1510: /*
1511: if g_call_from_setup = 'Y' then
1512: oe_debug_pub.add('Begin Populate_patterns');
1513: else
1514: fnd_file.put_line(FND_FILE.LOG, 'Begin Populate_patterns');
1515: end if;
1516: */

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

1564: g_pattern_req_id_final_tbl.delete;
1565:
1566: /*
1567: if g_call_from_setup = 'Y' then
1568: oe_debug_pub.add('End Populate_patterns');
1569: else
1570: commit;
1571: fnd_file.put_line(FND_FILE.LOG, 'End Populate_patterns');
1572: end if;

Line 1577: oe_debug_pub.add('ATTR_GRP_PVT.Populate_Patterns ' || SQLERRM);

1573: */
1574: EXCEPTION
1575: WHEN OTHERS THEN
1576: if g_call_from_setup = 'Y' then
1577: oe_debug_pub.add('ATTR_GRP_PVT.Populate_Patterns ' || SQLERRM);
1578: else
1579: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Populate_Patterns ' || SQLERRM );
1580: end if;
1581: raise;

Line 1604: oe_debug_pub.add('ATTR_GRP_PVT.Update_List_Lines ' || SQLERRM);

1600:
1601: EXCEPTION
1602: WHEN OTHERS THEN
1603: if g_call_from_setup = 'Y' then
1604: oe_debug_pub.add('ATTR_GRP_PVT.Update_List_Lines ' || SQLERRM);
1605: else
1606: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Update_List_Lines ' || SQLERRM );
1607: end if;
1608:

Line 1627: oe_debug_pub.add('ATTR_GRP_PVT.Update_List_Lines_Cache_Key ' || SQLERRM);

1623:
1624: EXCEPTION
1625: WHEN OTHERS THEN
1626: if g_call_from_setup = 'Y' then
1627: oe_debug_pub.add('ATTR_GRP_PVT.Update_List_Lines_Cache_Key ' || SQLERRM);
1628: else
1629: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Update_List_Lines_Cache_Key ' || SQLERRM );
1630: end if;
1631:

Line 1699: oe_debug_pub.add('ATTR_GRP_PVT.Populate_Atgrps ' || SQLERRM);

1695: );
1696: EXCEPTION
1697: WHEN OTHERS THEN
1698: if g_call_from_setup = 'Y' then
1699: oe_debug_pub.add('ATTR_GRP_PVT.Populate_Atgrps ' || SQLERRM);
1700: else
1701: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Populate_Atgrps ' || SQLERRM );
1702: end if;
1703: raise;

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

1707: is
1708: begin
1709: /*
1710: if g_call_from_setup = 'Y' then
1711: oe_debug_pub.add('Reset temp tables');
1712: else
1713: fnd_file.put_line(FND_FILE.LOG, 'Reset temp tables');
1714: end if;
1715: */

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

1747: l_pattern_final_index number;
1748: begin
1749: /*
1750: if g_call_from_setup = 'Y' then
1751: oe_debug_pub.add('Begin get_pattern_id');
1752: else
1753: fnd_file.put_line(FND_FILE.LOG, 'Begin get_pattern_id');
1754: end if;
1755: */

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

1771: end;
1772:
1773: /*
1774: if g_call_from_setup = 'Y' then
1775: oe_debug_pub.add('l_pattern_to_be_created='||l_pattern_to_be_created);
1776: else
1777: fnd_file.put_line(FND_FILE.LOG, 'l_pattern_to_be_created='||l_pattern_to_be_created);
1778: end if;
1779: */

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

1804: populate_patterns;
1805: end if; -- l_pattern_to_be_created = 'Y'
1806: /*
1807: if g_call_from_setup = 'Y' then
1808: oe_debug_pub.add('End get_pattern_id');
1809: else
1810: fnd_file.put_line(FND_FILE.LOG, 'End get_pattern_id');
1811: end if;
1812: */

Line 1819: oe_debug_pub.add('ATTR_GRP_PVT.Get_Pattern_Id ' || SQLERRM);

1815:
1816: EXCEPTION
1817: WHEN OTHERS THEN
1818: if g_call_from_setup = 'Y' then
1819: oe_debug_pub.add('ATTR_GRP_PVT.Get_Pattern_Id ' || SQLERRM);
1820: else
1821: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Get_Pattern_Id ' || SQLERRM );
1822: end if;
1823:

Line 1863: oe_debug_pub.add('ATTR_GRP_PVT.Reset_Final_Tables ' || SQLERRM);

1859:
1860: EXCEPTION
1861: WHEN OTHERS THEN
1862: if g_call_from_setup = 'Y' then
1863: oe_debug_pub.add('ATTR_GRP_PVT.Reset_Final_Tables ' || SQLERRM);
1864: else
1865: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Reset_Final_Tables ' || SQLERRM );
1866: end if;
1867:

Line 1898: oe_debug_pub.add('ATTR_GRP_PVT.Reset_C_Tables ' || SQLERRM);

1894:
1895: EXCEPTION
1896: WHEN OTHERS THEN
1897: if g_call_from_setup = 'Y' then
1898: oe_debug_pub.add('ATTR_GRP_PVT.Reset_C_Tables ' || SQLERRM);
1899: else
1900: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Reset_C_Tables ' || SQLERRM );
1901: end if;
1902: end reset_c_tables;

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

1918: IF p_list_header_id is not null then
1919: -- HP case
1920: /*
1921: if g_call_from_setup = 'Y' then
1922: oe_debug_pub.add('Begin Populate_Pattern_Phases for HP case');
1923: else
1924: fnd_file.put_line(FND_FILE.LOG, 'Begin Populate_Pattern_Phases for HP case');
1925: end if;
1926: */

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

1971: else
1972: -- LP, PP case
1973: /*
1974: if g_call_from_setup = 'Y' then
1975: oe_debug_pub.add('Begin Populate_Pattern_Phases for LP, PP case');
1976: else
1977: fnd_file.put_line(FND_FILE.LOG, 'Begin Populate_Pattern_Phases for LP, PP case');
1978: end if;
1979: */

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

1987: exception
1988: when no_data_found then
1989: /*
1990: if g_call_from_setup = 'Y' then
1991: oe_debug_pub.add('No pattern_phases found; go insert');
1992: else
1993: fnd_file.put_line(FND_FILE.LOG, 'No pattern_phases found; go insert');
1994: end if;
1995: */

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

2025: end if;
2026:
2027: when others then
2028: if g_call_from_setup = 'Y' then
2029: oe_debug_pub.add('Insert failure:'||sqlerrm);
2030: else
2031: fnd_file.put_line(FND_FILE.LOG, 'Insert failure:'||sqlerrm);
2032: end if;
2033: raise;

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

2035:
2036: END IF; -- p_list_header_id is not null
2037: /*
2038: if g_call_from_setup = 'Y' then
2039: oe_debug_pub.add('End Populate_Pattern_Phases ');
2040: else
2041: fnd_file.put_line(FND_FILE.LOG, 'End Populate_Pattern_Phases ');
2042: end if;
2043: */

Line 2048: oe_debug_pub.add('ATTR_GRP_PVT.Populate_Pattern_Phases ' || SQLERRM);

2044:
2045: EXCEPTION
2046: WHEN OTHERS THEN
2047: if g_call_from_setup = 'Y' then
2048: oe_debug_pub.add('ATTR_GRP_PVT.Populate_Pattern_Phases ' || SQLERRM);
2049: else
2050: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Populate_Pattern_Phases ' || SQLERRM );
2051: end if;
2052: raise;

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

2073: BEGIN
2074: g_call_from_setup := 'Y';
2075:
2076: if g_call_from_setup = 'Y' then
2077: oe_debug_pub.add('Header_Pattern_Main - p_list_header_id = ' ||p_list_header_id);
2078: oe_debug_pub.add('Header_Pattern_Main - p_qualifier_group = ' ||p_qualifier_group);
2079: oe_debug_pub.add('Header_Pattern_Main - p_setup_action = ' ||p_setup_action);
2080: else
2081: fnd_file.put_line(FND_FILE.LOG, 'Header_Pattern_Main - p_list_header_id = ' ||p_list_header_id);

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

2074: g_call_from_setup := 'Y';
2075:
2076: if g_call_from_setup = 'Y' then
2077: oe_debug_pub.add('Header_Pattern_Main - p_list_header_id = ' ||p_list_header_id);
2078: oe_debug_pub.add('Header_Pattern_Main - p_qualifier_group = ' ||p_qualifier_group);
2079: oe_debug_pub.add('Header_Pattern_Main - p_setup_action = ' ||p_setup_action);
2080: else
2081: fnd_file.put_line(FND_FILE.LOG, 'Header_Pattern_Main - p_list_header_id = ' ||p_list_header_id);
2082: fnd_file.put_line(FND_FILE.LOG, 'Header_Pattern_Main - p_qualifier_group = ' ||p_qualifier_group);

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

2075:
2076: if g_call_from_setup = 'Y' then
2077: oe_debug_pub.add('Header_Pattern_Main - p_list_header_id = ' ||p_list_header_id);
2078: oe_debug_pub.add('Header_Pattern_Main - p_qualifier_group = ' ||p_qualifier_group);
2079: oe_debug_pub.add('Header_Pattern_Main - p_setup_action = ' ||p_setup_action);
2080: else
2081: fnd_file.put_line(FND_FILE.LOG, 'Header_Pattern_Main - p_list_header_id = ' ||p_list_header_id);
2082: fnd_file.put_line(FND_FILE.LOG, 'Header_Pattern_Main - p_qualifier_group = ' ||p_qualifier_group);
2083: fnd_file.put_line(FND_FILE.LOG, 'Header_Pattern_Main - p_setup_action = ' ||p_setup_action);

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

2202:
2203: exception
2204: when no_data_found then
2205: if g_call_from_setup = 'Y' then
2206: oe_debug_pub.add('Header_Pattern_Main - no_data_found in action UD ' );
2207: end if;
2208: null;
2209:
2210: when others then

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

2208: null;
2209:
2210: when others then
2211: if g_call_from_setup = 'Y' then
2212: oe_debug_pub.add('Header_Pattern_Main - others exceptions in action UD ' );
2213: end if;
2214: null;
2215: end;
2216: end if; -- p_setup_action = 'I'

Line 2221: oe_debug_pub.add('ATTR_GRP_PVT.Header_Pattern_Main ' || SQLERRM);

2217:
2218: EXCEPTION
2219: WHEN OTHERS THEN
2220: if g_call_from_setup = 'Y' then
2221: oe_debug_pub.add('ATTR_GRP_PVT.Header_Pattern_Main ' || SQLERRM);
2222: else
2223: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Header_Pattern_Main ' || SQLERRM );
2224: end if;
2225:

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

2240: BEGIN
2241: g_call_from_setup := 'Y';
2242:
2243: if g_call_from_setup = 'Y' then
2244: oe_debug_pub.add('Line_Pattern_Main - p_list_header_id = ' ||p_list_header_id);
2245: oe_debug_pub.add('Line_Pattern_Main - p_list_line_id = ' ||p_list_line_id);
2246: oe_debug_pub.add('Line_Pattern_Main - p_qualifier_group = ' ||p_qualifier_group);
2247: oe_debug_pub.add('Line_Pattern_Main - p_setup_action = ' ||p_setup_action);
2248: else

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

2241: g_call_from_setup := 'Y';
2242:
2243: if g_call_from_setup = 'Y' then
2244: oe_debug_pub.add('Line_Pattern_Main - p_list_header_id = ' ||p_list_header_id);
2245: oe_debug_pub.add('Line_Pattern_Main - p_list_line_id = ' ||p_list_line_id);
2246: oe_debug_pub.add('Line_Pattern_Main - p_qualifier_group = ' ||p_qualifier_group);
2247: oe_debug_pub.add('Line_Pattern_Main - p_setup_action = ' ||p_setup_action);
2248: else
2249: fnd_file.put_line(FND_FILE.LOG, 'Line_Pattern_Main - p_list_header_id = ' ||p_list_header_id);

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

2242:
2243: if g_call_from_setup = 'Y' then
2244: oe_debug_pub.add('Line_Pattern_Main - p_list_header_id = ' ||p_list_header_id);
2245: oe_debug_pub.add('Line_Pattern_Main - p_list_line_id = ' ||p_list_line_id);
2246: oe_debug_pub.add('Line_Pattern_Main - p_qualifier_group = ' ||p_qualifier_group);
2247: oe_debug_pub.add('Line_Pattern_Main - p_setup_action = ' ||p_setup_action);
2248: else
2249: fnd_file.put_line(FND_FILE.LOG, 'Line_Pattern_Main - p_list_header_id = ' ||p_list_header_id);
2250: fnd_file.put_line(FND_FILE.LOG, 'Line_Pattern_Main - p_list_line_id = ' ||p_list_line_id);

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

2243: if g_call_from_setup = 'Y' then
2244: oe_debug_pub.add('Line_Pattern_Main - p_list_header_id = ' ||p_list_header_id);
2245: oe_debug_pub.add('Line_Pattern_Main - p_list_line_id = ' ||p_list_line_id);
2246: oe_debug_pub.add('Line_Pattern_Main - p_qualifier_group = ' ||p_qualifier_group);
2247: oe_debug_pub.add('Line_Pattern_Main - p_setup_action = ' ||p_setup_action);
2248: else
2249: fnd_file.put_line(FND_FILE.LOG, 'Line_Pattern_Main - p_list_header_id = ' ||p_list_header_id);
2250: fnd_file.put_line(FND_FILE.LOG, 'Line_Pattern_Main - p_list_line_id = ' ||p_list_line_id);
2251: fnd_file.put_line(FND_FILE.LOG, 'Line_Pattern_Main - p_qualifier_group = ' ||p_qualifier_group);

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

2358:
2359: exception
2360: when no_data_found then
2361: if g_call_from_setup = 'Y' then
2362: oe_debug_pub.add('Line_Pattern_Main - no_data_found in action UD ' );
2363: end if;
2364: null;
2365:
2366: when others then

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

2364: null;
2365:
2366: when others then
2367: if g_call_from_setup = 'Y' then
2368: oe_debug_pub.add('Line_Pattern_Main - others exceptions in action UD ' );
2369: end if;
2370: null;
2371: end;
2372: end if; -- p_setup_action = 'I'

Line 2415: oe_debug_pub.add('ATTR_GRP_PVT.Line_Pattern_Main ' || SQLERRM);

2411:
2412: EXCEPTION
2413: WHEN OTHERS THEN
2414: if g_call_from_setup = 'Y' then
2415: oe_debug_pub.add('ATTR_GRP_PVT.Line_Pattern_Main ' || SQLERRM);
2416: else
2417: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Line_Pattern_Main ' || SQLERRM );
2418: end if;
2419:

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

2433: BEGIN
2434: g_call_from_setup := 'Y';
2435:
2436: if g_call_from_setup = 'Y' then
2437: oe_debug_pub.add('Product_Pattern_Main - p_list_header_id = ' ||p_list_header_id);
2438: oe_debug_pub.add('Product_Pattern_Main - p_list_line_id = ' ||p_list_line_id);
2439: oe_debug_pub.add('Product_Pattern_Main - p_setup_action = ' ||p_setup_action);
2440: else
2441: fnd_file.put_line(FND_FILE.LOG, 'Product_Pattern_Main - p_list_header_id = ' ||p_list_header_id);

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

2434: g_call_from_setup := 'Y';
2435:
2436: if g_call_from_setup = 'Y' then
2437: oe_debug_pub.add('Product_Pattern_Main - p_list_header_id = ' ||p_list_header_id);
2438: oe_debug_pub.add('Product_Pattern_Main - p_list_line_id = ' ||p_list_line_id);
2439: oe_debug_pub.add('Product_Pattern_Main - p_setup_action = ' ||p_setup_action);
2440: else
2441: fnd_file.put_line(FND_FILE.LOG, 'Product_Pattern_Main - p_list_header_id = ' ||p_list_header_id);
2442: fnd_file.put_line(FND_FILE.LOG, 'Product_Pattern_Main - p_list_line_id = ' ||p_list_line_id);

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

2435:
2436: if g_call_from_setup = 'Y' then
2437: oe_debug_pub.add('Product_Pattern_Main - p_list_header_id = ' ||p_list_header_id);
2438: oe_debug_pub.add('Product_Pattern_Main - p_list_line_id = ' ||p_list_line_id);
2439: oe_debug_pub.add('Product_Pattern_Main - p_setup_action = ' ||p_setup_action);
2440: else
2441: fnd_file.put_line(FND_FILE.LOG, 'Product_Pattern_Main - p_list_header_id = ' ||p_list_header_id);
2442: fnd_file.put_line(FND_FILE.LOG, 'Product_Pattern_Main - p_list_line_id = ' ||p_list_line_id);
2443: fnd_file.put_line(FND_FILE.LOG, 'Product_Pattern_Main - p_setup_action = ' ||p_setup_action);

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

2447: into l_qual_ind
2448: from qp_list_lines
2449: where list_line_id = p_list_line_id;
2450:
2451: oe_debug_pub.add('Product_Pattern_Main - l_qual_ind = ' ||l_qual_ind);
2452:
2453: -- do nothing, return back if called for child line, bug 3581058
2454: if l_qual_ind in (4, 6, 8, 10, 12, 14, 20, 22, 28, 30) then
2455: null;

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

2490: end;
2491:
2492: if l_qual_exists = 'Y' then
2493: if g_call_from_setup = 'Y' then
2494: oe_debug_pub.add('going to populate LP');
2495: else
2496: fnd_file.put_line(FND_FILE.LOG, 'going to populate LP');
2497: end if;
2498: Line_Pattern_Main(p_list_header_id, p_list_line_id, null, 'I');

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

2497: end if;
2498: Line_Pattern_Main(p_list_header_id, p_list_line_id, null, 'I');
2499: else
2500: if g_call_from_setup = 'Y' then
2501: oe_debug_pub.add('going to populate PP');
2502: else
2503: fnd_file.put_line(FND_FILE.LOG, 'going to populate PP');
2504: end if;
2505:

Line 2519: oe_debug_pub.add('ATTR_GRP_PVT.Product_Pattern_Main ' || SQLERRM);

2515:
2516: EXCEPTION
2517: WHEN OTHERS THEN
2518: if g_call_from_setup = 'Y' then
2519: oe_debug_pub.add('ATTR_GRP_PVT.Product_Pattern_Main ' || SQLERRM);
2520: else
2521: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Product_Pattern_Main ' || SQLERRM );
2522: end if;
2523:

Line 2544: oe_debug_pub.add('ATTR_GRP_PVT.Remove_Prod_Pattern_For_Line ' || SQLERRM);

2540: null;
2541:
2542: when others then
2543: if g_call_from_setup = 'Y' then
2544: oe_debug_pub.add('ATTR_GRP_PVT.Remove_Prod_Pattern_For_Line ' || SQLERRM);
2545: else
2546: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Remove_Prod_Pattern_For_Line ' || SQLERRM );
2547: end if;
2548: raise;

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

2575:
2576: begin
2577: -- update the segment_id columns for qualifiers
2578: if g_call_from_setup = 'Y' then
2579: oe_debug_pub.add('Inside Update_Qual_Segment_id');
2580: oe_debug_pub.add('Start time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
2581: else
2582: fnd_file.put_line(FND_FILE.LOG, 'Inside Update_Qual_Segment_id');
2583: fnd_file.put_line(FND_FILE.LOG, 'Start time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));

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

2576: begin
2577: -- update the segment_id columns for qualifiers
2578: if g_call_from_setup = 'Y' then
2579: oe_debug_pub.add('Inside Update_Qual_Segment_id');
2580: oe_debug_pub.add('Start time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
2581: else
2582: fnd_file.put_line(FND_FILE.LOG, 'Inside Update_Qual_Segment_id');
2583: fnd_file.put_line(FND_FILE.LOG, 'Start time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
2584: end if;

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

2593: CLOSE c_qual_seg_id;
2594:
2595: if context_t.count > 0 then
2596: if g_call_from_setup = 'Y' then
2597: oe_debug_pub.add('Context_t.count='||context_t.count);
2598: else
2599: fnd_file.put_line(FND_FILE.LOG, 'Context_t.count='||context_t.count);
2600: end if;
2601: FOR i in 1..context_t.count

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

2616: and list_header_id = nvl(p_list_header_id, list_header_id)
2617: and list_line_id between p_low_list_line_id and p_high_list_line_id;
2618:
2619: if g_call_from_setup = 'Y' then
2620: oe_debug_pub.add('No of qualifiers updated='||SQL%ROWCOUNT);
2621: else
2622: fnd_file.put_line(FND_FILE.LOG, 'No of qualifiers updated='||SQL%ROWCOUNT);
2623: end if;
2624: end if; -- context_t.count > 0

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

2623: end if;
2624: end if; -- context_t.count > 0
2625:
2626: if g_call_from_setup = 'Y' then
2627: oe_debug_pub.add('End Update_Qual_Segment_id');
2628: oe_debug_pub.add('End time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
2629: else
2630: fnd_file.put_line(FND_FILE.LOG, 'End Update_Qual_Segment_id');
2631: fnd_file.put_line(FND_FILE.LOG, 'End time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));

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

2624: end if; -- context_t.count > 0
2625:
2626: if g_call_from_setup = 'Y' then
2627: oe_debug_pub.add('End Update_Qual_Segment_id');
2628: oe_debug_pub.add('End time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
2629: else
2630: fnd_file.put_line(FND_FILE.LOG, 'End Update_Qual_Segment_id');
2631: fnd_file.put_line(FND_FILE.LOG, 'End time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
2632: end if;

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

2632: end if;
2633: exception
2634: when no_data_found then
2635: if g_call_from_setup = 'Y' then
2636: oe_debug_pub.add('No data found in c_qual_seg_id');
2637: else
2638: fnd_file.put_line(FND_FILE.LOG, 'No data found in c_qual_seg_id');
2639: end if;
2640:

Line 2643: oe_debug_pub.add('ATTR_GRP_PVT.Update_Qual_Segment_Id ' || SQLERRM);

2639: end if;
2640:
2641: when others then
2642: if g_call_from_setup = 'Y' then
2643: oe_debug_pub.add('ATTR_GRP_PVT.Update_Qual_Segment_Id ' || SQLERRM);
2644: else
2645: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Update_Qual_Segment_Id ' || SQLERRM );
2646: end if;
2647:

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

2680:
2681:
2682: begin
2683: if g_call_from_setup = 'Y' then
2684: oe_debug_pub.add('Inside Update_Prod_Pric_Segment_id');
2685: oe_debug_pub.add('Start time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
2686: else
2687: fnd_file.put_line(FND_FILE.LOG, 'Inside Update_Prod_Pric_Segment_id');
2688: fnd_file.put_line(FND_FILE.LOG, 'Start time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));

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

2681:
2682: begin
2683: if g_call_from_setup = 'Y' then
2684: oe_debug_pub.add('Inside Update_Prod_Pric_Segment_id');
2685: oe_debug_pub.add('Start time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
2686: else
2687: fnd_file.put_line(FND_FILE.LOG, 'Inside Update_Prod_Pric_Segment_id');
2688: fnd_file.put_line(FND_FILE.LOG, 'Start time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
2689: end if;

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

2699: CLOSE c_prod_seg_id;
2700:
2701: if context_t.count > 0 then
2702: if g_call_from_setup = 'Y' then
2703: oe_debug_pub.add('Context_t.count='||context_t.count);
2704: else
2705: fnd_file.put_line(FND_FILE.LOG, 'Context_t.count='||context_t.count);
2706: end if;
2707: FOR i in 1..context_t.count

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

2722: --and list_header_id = nvl(p_list_header_id, list_header_id)
2723: and list_line_id between p_low_list_line_id and p_high_list_line_id;
2724:
2725: if g_call_from_setup = 'Y' then
2726: oe_debug_pub.add('No of product segment ids updated='||SQL%ROWCOUNT);
2727: oe_debug_pub.add('End Time product segments :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
2728: else
2729: fnd_file.put_line(FND_FILE.LOG, 'No of product segment ids updated='||SQL%ROWCOUNT);
2730: fnd_file.put_line(FND_FILE.LOG, 'End time product segments :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));

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

2723: and list_line_id between p_low_list_line_id and p_high_list_line_id;
2724:
2725: if g_call_from_setup = 'Y' then
2726: oe_debug_pub.add('No of product segment ids updated='||SQL%ROWCOUNT);
2727: oe_debug_pub.add('End Time product segments :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
2728: else
2729: fnd_file.put_line(FND_FILE.LOG, 'No of product segment ids updated='||SQL%ROWCOUNT);
2730: fnd_file.put_line(FND_FILE.LOG, 'End time product segments :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
2731: end if;

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

2743: CLOSE c_pric_seg_id;
2744:
2745: if context_t.count > 0 then
2746: if g_call_from_setup = 'Y' then
2747: oe_debug_pub.add('Context_t.count='||context_t.count);
2748: else
2749: fnd_file.put_line(FND_FILE.LOG, 'Context_t.count='||context_t.count);
2750: end if;
2751:

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

2767: --and list_header_id = nvl(p_list_header_id, list_header_id)
2768: and list_line_id between p_low_list_line_id and p_high_list_line_id;
2769:
2770: if g_call_from_setup = 'Y' then
2771: oe_debug_pub.add('No of pricing segment ids updated='||SQL%ROWCOUNT);
2772: oe_debug_pub.add('End Time pricing segments :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
2773: else
2774: fnd_file.put_line(FND_FILE.LOG, 'No of pricing segment ids updated='||SQL%ROWCOUNT);
2775: fnd_file.put_line(FND_FILE.LOG, 'End time pricing segments :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));

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

2768: and list_line_id between p_low_list_line_id and p_high_list_line_id;
2769:
2770: if g_call_from_setup = 'Y' then
2771: oe_debug_pub.add('No of pricing segment ids updated='||SQL%ROWCOUNT);
2772: oe_debug_pub.add('End Time pricing segments :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
2773: else
2774: fnd_file.put_line(FND_FILE.LOG, 'No of pricing segment ids updated='||SQL%ROWCOUNT);
2775: fnd_file.put_line(FND_FILE.LOG, 'End time pricing segments :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
2776: end if;

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

2776: end if;
2777: end if; -- context_t.count > 0
2778:
2779: if g_call_from_setup = 'Y' then
2780: oe_debug_pub.add('End Update_Prod_Pric_Segment_id');
2781: else
2782: fnd_file.put_line(FND_FILE.LOG, 'End Update_Prod_Pric_Segment_id');
2783: end if;
2784: exception

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

2783: end if;
2784: exception
2785: when no_data_found then
2786: if g_call_from_setup = 'Y' then
2787: oe_debug_pub.add('No data found in Update_Prod_Pric_Segment_id');
2788: else
2789: fnd_file.put_line(FND_FILE.LOG, 'No data found in Update_Prod_Pric_Segment_id');
2790: end if;
2791:

Line 2796: oe_debug_pub.add('ATTR_GRP_PVT.Update_Prod_Pric_Segment_id ' || SQLERRM);

2792: null;
2793:
2794: when others then
2795: if g_call_from_setup = 'Y' then
2796: oe_debug_pub.add('ATTR_GRP_PVT.Update_Prod_Pric_Segment_id ' || SQLERRM);
2797: else
2798: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Update_Prod_Pric_Segment_id ' || SQLERRM );
2799: end if;
2800: