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 401: oe_debug_pub.add('ATTR_GRP_PVT.Pattern_Upgrade ' || SQLERRM);

397: retcode := 0;
398: exception
399: when others then
400: if g_call_from_setup = 'Y' then
401: oe_debug_pub.add('ATTR_GRP_PVT.Pattern_Upgrade ' || SQLERRM);
402: else
403: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Pattern_Upgrade ' || SQLERRM );
404: end if;
405: err_buff := 'Others Error in procedure Pattern_Upgrade';

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

448: order by qpq.list_header_id, qpq.list_line_id, qpq.segment_id;
449: begin
450: -- delete the data from cursor, temp and final tables to start with
451: if g_call_from_setup = 'Y' then
452: oe_debug_pub.add('Begin generate_hp_atgrps');
453: else
454: fnd_file.put_line(FND_FILE.LOG, 'Begin generate_hp_atgrps');
455: end if;
456: Reset_c_tables;

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

485: if g_list_header_id_c_tbl.count > 0 then
486: process_c_tables('HP');
487: end if;
488: if g_call_from_setup = 'Y' then
489: oe_debug_pub.add('End generate_hp_atgrps');
490: else
491: fnd_file.put_line(FND_FILE.LOG, 'End generate_hp_atgrps');
492: end if;
493:

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

493:
494: EXCEPTION
495: WHEN OTHERS THEN
496: if g_call_from_setup = 'Y' then
497: oe_debug_pub.add('ATTR_GRP_PVT.Generate_Hp_Atgrps ' || SQLERRM);
498: else
499: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Generate_Hp_Atgrps ' || SQLERRM );
500: end if;
501:

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

637:
638: EXCEPTION
639: WHEN OTHERS THEN
640: if g_call_from_setup = 'Y' then
641: oe_debug_pub.add('ATTR_GRP_PVT.Generate_Lp_Atgrps ' || SQLERRM);
642: else
643: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Generate_Lp_Atgrps ' || SQLERRM );
644: end if;
645:

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

716:
717: EXCEPTION
718: WHEN OTHERS THEN
719: if g_call_from_setup = 'Y' then
720: oe_debug_pub.add('ATTR_GRP_PVT.Update_Pp_Lines ' || SQLERRM);
721: else
722: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Update_Pp_Lines ' || SQLERRM );
723: end if;
724:

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

739: l_old_list_header_id := g_init_val;
740: l_old_list_line_id := g_init_val;
741:
742: if g_call_from_setup = 'Y' then
743: oe_debug_pub.add('Start process_c_tables - Pattern type '||p_pattern_type);
744: oe_debug_pub.add('cursor tables total = ' || g_list_header_id_c_tbl.count);
745: else
746: QP_PREQ_GRP.Set_QP_Debug;
747: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;

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

740: l_old_list_line_id := g_init_val;
741:
742: if g_call_from_setup = 'Y' then
743: oe_debug_pub.add('Start process_c_tables - Pattern type '||p_pattern_type);
744: oe_debug_pub.add('cursor tables total = ' || g_list_header_id_c_tbl.count);
745: else
746: QP_PREQ_GRP.Set_QP_Debug;
747: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
748: IF l_debug = FND_API.G_TRUE THEN

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

754: if g_list_header_id_c_tbl.count > 0 then
755: for i in 1..g_list_header_id_c_tbl.count
756: loop
757: if g_call_from_setup = 'Y' then
758: oe_debug_pub.add('i = ' || i ||
759: ', list_header_id = ' || g_list_header_id_c_tbl(i) ||
760: ', list_line_id = ' || g_list_line_id_c_tbl(i) ||
761: ', group = ' || g_qual_grouping_no_c_tbl(i) ||
762: ', operator = ' || g_comparison_opr_code_c_tbl(i));

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

759: ', list_header_id = ' || g_list_header_id_c_tbl(i) ||
760: ', list_line_id = ' || g_list_line_id_c_tbl(i) ||
761: ', group = ' || g_qual_grouping_no_c_tbl(i) ||
762: ', operator = ' || g_comparison_opr_code_c_tbl(i));
763: --oe_debug_pub.add('l_old_list_header_id ' || l_old_list_header_id);
764: --oe_debug_pub.add('l_old_list_line_id ' || l_old_list_line_id);
765: elsif l_debug = FND_API.G_TRUE then
766: fnd_file.put_line(FND_FILE.LOG, 'i = ' || i ||
767: ', list_header_id = ' || g_list_header_id_c_tbl(i) ||

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

760: ', list_line_id = ' || g_list_line_id_c_tbl(i) ||
761: ', group = ' || g_qual_grouping_no_c_tbl(i) ||
762: ', operator = ' || g_comparison_opr_code_c_tbl(i));
763: --oe_debug_pub.add('l_old_list_header_id ' || l_old_list_header_id);
764: --oe_debug_pub.add('l_old_list_line_id ' || l_old_list_line_id);
765: elsif l_debug = FND_API.G_TRUE then
766: fnd_file.put_line(FND_FILE.LOG, 'i = ' || i ||
767: ', list_header_id = ' || g_list_header_id_c_tbl(i) ||
768: ', list_line_id = ' || g_list_line_id_c_tbl(i) ||

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

782: -- logic to insert into tables every G_LINES_PER_INSERT lines
783: l_line_counter := l_line_counter + 1;
784: if l_line_counter >= G_LINES_PER_INSERT then
785: if g_call_from_setup = 'Y' then
786: oe_debug_pub.add('inserting data for ' || G_LINES_PER_INSERT || ' lines');
787: elsif l_debug = FND_API.G_TRUE then
788: fnd_file.put_line(FND_FILE.LOG, 'inserting data for ' || G_LINES_PER_INSERT || ' lines');
789: end if;
790: populate_atgrps;

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

806: if g_qual_grouping_no_tmp_tbl.exists(l_current_grp) = TRUE then
807:
808: /*
809: if g_call_from_setup = 'Y' then
810: oe_debug_pub.add('record exists in temp table for current group');
811: oe_debug_pub.add('current record Operator is ' || g_comparison_opr_code_c_tbl(i));
812: else
813: fnd_file.put_line(FND_FILE.LOG, 'record exists in temp table for current group');
814: fnd_file.put_line(FND_FILE.LOG, 'current record Operator is ' || g_comparison_opr_code_c_tbl(i));

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

807:
808: /*
809: if g_call_from_setup = 'Y' then
810: oe_debug_pub.add('record exists in temp table for current group');
811: oe_debug_pub.add('current record Operator is ' || g_comparison_opr_code_c_tbl(i));
812: else
813: fnd_file.put_line(FND_FILE.LOG, 'record exists in temp table for current group');
814: fnd_file.put_line(FND_FILE.LOG, 'current record Operator is ' || g_comparison_opr_code_c_tbl(i));
815: end if;

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

822: while other_grp_index is not null
823: LOOP
824: /*
825: if g_call_from_setup = 'Y' then
826: oe_debug_pub.add('other_grp_index = ' || other_grp_index);
827: else
828: fnd_file.put_line(FND_FILE.LOG, 'other_grp_index = ' || other_grp_index);
829: end if;
830: */

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

932:
933: else -- record does not exists for the group
934: /*
935: if g_call_from_setup = 'Y' then
936: oe_debug_pub.add('record DOES NOT exists in temp table for current group');
937: oe_debug_pub.add('current record Operator is ' || g_comparison_opr_code_c_tbl(i));
938: else
939: fnd_file.put_line(FND_FILE.LOG, 'record DOES NOT exists in temp table for current group');
940: fnd_file.put_line(FND_FILE.LOG, 'current record Operator is ' || g_comparison_opr_code_c_tbl(i));

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

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

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

949: while other_grp_index is not null
950: LOOP
951: /*
952: if g_call_from_setup = 'Y' then
953: oe_debug_pub.add('other_grp_index = ' || other_grp_index);
954: else
955: fnd_file.put_line(FND_FILE.LOG, 'other_grp_index = ' || other_grp_index);
956: end if;
957: */

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

1151:
1152: EXCEPTION
1153: WHEN OTHERS THEN
1154: if g_call_from_setup = 'Y' then
1155: oe_debug_pub.add('ATTR_GRP_PVT.Process_C_Tables ' || SQLERRM);
1156: else
1157: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Process_C_Tables ' || SQLERRM );
1158: end if;
1159:

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

1172: l_old_list_header_id := g_init_val;
1173: l_old_list_line_id := g_init_val;
1174:
1175: if g_call_from_setup = 'Y' then
1176: oe_debug_pub.add('PP cursor tables total = ' || g_list_header_id_c_tbl.count);
1177: else
1178: QP_PREQ_GRP.Set_QP_Debug;
1179: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
1180: IF l_debug = FND_API.G_TRUE THEN

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

1187: if g_list_header_id_c_tbl.count > 0 then
1188: for i in 1..g_list_header_id_c_tbl.count
1189: loop
1190: if g_call_from_setup = 'Y' then
1191: oe_debug_pub.add('PP i = ' || i ||
1192: ', list_header_id = ' || g_list_header_id_c_tbl(i) ||
1193: ', list_line_id = ' || g_list_line_id_c_tbl(i) ||
1194: ', operator = ' || g_comparison_opr_code_c_tbl(i));
1195: --oe_debug_pub.add('PP l_old_list_header_id ' || l_old_list_header_id);

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

1191: oe_debug_pub.add('PP i = ' || i ||
1192: ', list_header_id = ' || g_list_header_id_c_tbl(i) ||
1193: ', list_line_id = ' || g_list_line_id_c_tbl(i) ||
1194: ', operator = ' || g_comparison_opr_code_c_tbl(i));
1195: --oe_debug_pub.add('PP l_old_list_header_id ' || l_old_list_header_id);
1196: --oe_debug_pub.add('PP l_old_list_line_id ' || l_old_list_line_id);
1197: elsif l_debug = FND_API.G_TRUE then
1198: fnd_file.put_line(FND_FILE.LOG, 'PP i = ' || i ||
1199: ', list_header_id = ' || g_list_header_id_c_tbl(i) ||

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

1192: ', list_header_id = ' || g_list_header_id_c_tbl(i) ||
1193: ', list_line_id = ' || g_list_line_id_c_tbl(i) ||
1194: ', operator = ' || g_comparison_opr_code_c_tbl(i));
1195: --oe_debug_pub.add('PP l_old_list_header_id ' || l_old_list_header_id);
1196: --oe_debug_pub.add('PP l_old_list_line_id ' || l_old_list_line_id);
1197: elsif l_debug = FND_API.G_TRUE then
1198: fnd_file.put_line(FND_FILE.LOG, 'PP i = ' || i ||
1199: ', list_header_id = ' || g_list_header_id_c_tbl(i) ||
1200: ', list_line_id = ' || g_list_line_id_c_tbl(i) ||

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

1214: -- logic to insert into tables every G_LINES_PER_INSERT lines
1215: l_line_counter := l_line_counter + 1;
1216: if l_line_counter >= G_LINES_PER_INSERT then
1217: if g_call_from_setup = 'Y' then
1218: oe_debug_pub.add('inserting data for ' || G_LINES_PER_INSERT || ' lines');
1219: elsif l_debug = FND_API.G_TRUE then
1220: fnd_file.put_line(FND_FILE.LOG, 'inserting data for ' || G_LINES_PER_INSERT || ' lines');
1221: end if;
1222: update_list_lines;

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

1326:
1327: EXCEPTION
1328: WHEN OTHERS THEN
1329: if g_call_from_setup = 'Y' then
1330: oe_debug_pub.add('ATTR_GRP_PVT.Process_C_Tables_Pp ' || SQLERRM);
1331: else
1332: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Process_C_Tables_Pp ' || SQLERRM );
1333: end if;
1334:

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

1343: l_product_precedence number;
1344: BEGIN
1345: /*
1346: if g_call_from_setup = 'Y' then
1347: oe_debug_pub.add('Moving data from temp table to final table');
1348: oe_debug_pub.add('temp tables total = ' || g_list_header_id_tmp_tbl.count);
1349: else
1350: fnd_file.put_line(FND_FILE.LOG, 'Moving data from temp table to final table');
1351: fnd_file.put_line(FND_FILE.LOG, 'temp tables total = ' || g_list_header_id_tmp_tbl.count);

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

1344: BEGIN
1345: /*
1346: if g_call_from_setup = 'Y' then
1347: oe_debug_pub.add('Moving data from temp table to final table');
1348: oe_debug_pub.add('temp tables total = ' || g_list_header_id_tmp_tbl.count);
1349: else
1350: fnd_file.put_line(FND_FILE.LOG, 'Moving data from temp table to final table');
1351: fnd_file.put_line(FND_FILE.LOG, 'temp tables total = ' || g_list_header_id_tmp_tbl.count);
1352: end if;

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

1359: end if; -- g_list_header_id_tmp_tbl.count > 1
1360:
1361: /*
1362: if g_call_from_setup = 'Y' then
1363: oe_debug_pub.add('l_other_grp_exists = ' || l_other_grp_exists);
1364: else
1365: fnd_file.put_line(FND_FILE.LOG, 'l_other_grp_exists = ' || l_other_grp_exists);
1366: end if;
1367: */

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

1371: while grp_no_index is not null
1372: LOOP
1373: /*
1374: if g_call_from_setup = 'Y' then
1375: oe_debug_pub.add('grouping no = ' || grp_no_index);
1376: else
1377: fnd_file.put_line(FND_FILE.LOG, 'grouping no = ' || grp_no_index);
1378: end if;
1379: */

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

1388: l_pattern_id := -1;
1389: end if;
1390: /*
1391: if g_call_from_setup = 'Y' then
1392: oe_debug_pub.add('Pattern_id='||l_pattern_id);
1393: else
1394: fnd_file.put_line(FND_FILE.LOG, 'Pattern_id='||l_pattern_id);
1395: end if;
1396: */

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

1404:
1405: -- move the data from tmp tables to final tables for qp_attribute_groups
1406: /*
1407: if g_call_from_setup = 'Y' then
1408: oe_debug_pub.add('move the data from tmp tables to final tables for qp_attribute_groups');
1409: else
1410: fnd_file.put_line(FND_FILE.LOG, 'move the data from tmp tables to final tables for qp_attribute_groups');
1411: end if;
1412: */

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

1442: g_effec_precedence_final_tbl(l_atgrp_final_index) := l_product_precedence;
1443: end if;
1444: /*
1445: if g_call_from_setup = 'Y' then
1446: oe_debug_pub.add('cache_key should be just list_header_id ');
1447: else
1448: fnd_file.put_line(FND_FILE.LOG, 'cache_key should be just list_header_id ');
1449: end if;
1450: */

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

1451: else
1452: g_cache_key_final_tbl(l_atgrp_final_index) := g_cache_key_tmp_tbl(grp_no_index);
1453: /*
1454: if g_call_from_setup = 'Y' then
1455: oe_debug_pub.add('cache_key should be standard OR null');
1456: else
1457: fnd_file.put_line(FND_FILE.LOG, 'cache_key should be standard OR null');
1458: end if;
1459: */

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

1479:
1480: END LOOP; -- while
1481: /*
1482: if g_call_from_setup = 'Y' then
1483: oe_debug_pub.add('End Moving data from temp table to final table');
1484: else
1485: fnd_file.put_line(FND_FILE.LOG, 'End Moving data from temp table to final table');
1486: end if;
1487: */

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

1488:
1489: EXCEPTION
1490: WHEN OTHERS THEN
1491: if g_call_from_setup = 'Y' then
1492: oe_debug_pub.add('ATTR_GRP_PVT.Move_Data_From_Tmp_To_Final ' || SQLERRM);
1493: else
1494: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Move_Data_From_Tmp_To_Final ' || SQLERRM );
1495: end if;
1496:

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

1502: BEGIN
1503:
1504: /*
1505: if g_call_from_setup = 'Y' then
1506: oe_debug_pub.add('Begin Populate_patterns');
1507: else
1508: fnd_file.put_line(FND_FILE.LOG, 'Begin Populate_patterns');
1509: end if;
1510: */

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

1558: g_pattern_req_id_final_tbl.delete;
1559:
1560: /*
1561: if g_call_from_setup = 'Y' then
1562: oe_debug_pub.add('End Populate_patterns');
1563: else
1564: commit;
1565: fnd_file.put_line(FND_FILE.LOG, 'End Populate_patterns');
1566: end if;

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

1567: */
1568: EXCEPTION
1569: WHEN OTHERS THEN
1570: if g_call_from_setup = 'Y' then
1571: oe_debug_pub.add('ATTR_GRP_PVT.Populate_Patterns ' || SQLERRM);
1572: else
1573: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Populate_Patterns ' || SQLERRM );
1574: end if;
1575: raise;

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

1594:
1595: EXCEPTION
1596: WHEN OTHERS THEN
1597: if g_call_from_setup = 'Y' then
1598: oe_debug_pub.add('ATTR_GRP_PVT.Update_List_Lines ' || SQLERRM);
1599: else
1600: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Update_List_Lines ' || SQLERRM );
1601: end if;
1602:

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

1617:
1618: EXCEPTION
1619: WHEN OTHERS THEN
1620: if g_call_from_setup = 'Y' then
1621: oe_debug_pub.add('ATTR_GRP_PVT.Update_List_Lines_Cache_Key ' || SQLERRM);
1622: else
1623: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Update_List_Lines_Cache_Key ' || SQLERRM );
1624: end if;
1625:

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

1689: );
1690: EXCEPTION
1691: WHEN OTHERS THEN
1692: if g_call_from_setup = 'Y' then
1693: oe_debug_pub.add('ATTR_GRP_PVT.Populate_Atgrps ' || SQLERRM);
1694: else
1695: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Populate_Atgrps ' || SQLERRM );
1696: end if;
1697: raise;

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

1701: is
1702: begin
1703: /*
1704: if g_call_from_setup = 'Y' then
1705: oe_debug_pub.add('Reset temp tables');
1706: else
1707: fnd_file.put_line(FND_FILE.LOG, 'Reset temp tables');
1708: end if;
1709: */

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

1741: l_pattern_final_index number;
1742: begin
1743: /*
1744: if g_call_from_setup = 'Y' then
1745: oe_debug_pub.add('Begin get_pattern_id');
1746: else
1747: fnd_file.put_line(FND_FILE.LOG, 'Begin get_pattern_id');
1748: end if;
1749: */

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

1765: end;
1766:
1767: /*
1768: if g_call_from_setup = 'Y' then
1769: oe_debug_pub.add('l_pattern_to_be_created='||l_pattern_to_be_created);
1770: else
1771: fnd_file.put_line(FND_FILE.LOG, 'l_pattern_to_be_created='||l_pattern_to_be_created);
1772: end if;
1773: */

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

1798: populate_patterns;
1799: end if; -- l_pattern_to_be_created = 'Y'
1800: /*
1801: if g_call_from_setup = 'Y' then
1802: oe_debug_pub.add('End get_pattern_id');
1803: else
1804: fnd_file.put_line(FND_FILE.LOG, 'End get_pattern_id');
1805: end if;
1806: */

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

1809:
1810: EXCEPTION
1811: WHEN OTHERS THEN
1812: if g_call_from_setup = 'Y' then
1813: oe_debug_pub.add('ATTR_GRP_PVT.Get_Pattern_Id ' || SQLERRM);
1814: else
1815: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Get_Pattern_Id ' || SQLERRM );
1816: end if;
1817:

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

1853:
1854: EXCEPTION
1855: WHEN OTHERS THEN
1856: if g_call_from_setup = 'Y' then
1857: oe_debug_pub.add('ATTR_GRP_PVT.Reset_Final_Tables ' || SQLERRM);
1858: else
1859: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Reset_Final_Tables ' || SQLERRM );
1860: end if;
1861:

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

1888:
1889: EXCEPTION
1890: WHEN OTHERS THEN
1891: if g_call_from_setup = 'Y' then
1892: oe_debug_pub.add('ATTR_GRP_PVT.Reset_C_Tables ' || SQLERRM);
1893: else
1894: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Reset_C_Tables ' || SQLERRM );
1895: end if;
1896: end reset_c_tables;

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

1912: IF p_list_header_id is not null then
1913: -- HP case
1914: /*
1915: if g_call_from_setup = 'Y' then
1916: oe_debug_pub.add('Begin Populate_Pattern_Phases for HP case');
1917: else
1918: fnd_file.put_line(FND_FILE.LOG, 'Begin Populate_Pattern_Phases for HP case');
1919: end if;
1920: */

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

1965: else
1966: -- LP, PP case
1967: /*
1968: if g_call_from_setup = 'Y' then
1969: oe_debug_pub.add('Begin Populate_Pattern_Phases for LP, PP case');
1970: else
1971: fnd_file.put_line(FND_FILE.LOG, 'Begin Populate_Pattern_Phases for LP, PP case');
1972: end if;
1973: */

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

1981: exception
1982: when no_data_found then
1983: /*
1984: if g_call_from_setup = 'Y' then
1985: oe_debug_pub.add('No pattern_phases found; go insert');
1986: else
1987: fnd_file.put_line(FND_FILE.LOG, 'No pattern_phases found; go insert');
1988: end if;
1989: */

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

2019: end if;
2020:
2021: when others then
2022: if g_call_from_setup = 'Y' then
2023: oe_debug_pub.add('Insert failure:'||sqlerrm);
2024: else
2025: fnd_file.put_line(FND_FILE.LOG, 'Insert failure:'||sqlerrm);
2026: end if;
2027: raise;

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

2029:
2030: END IF; -- p_list_header_id is not null
2031: /*
2032: if g_call_from_setup = 'Y' then
2033: oe_debug_pub.add('End Populate_Pattern_Phases ');
2034: else
2035: fnd_file.put_line(FND_FILE.LOG, 'End Populate_Pattern_Phases ');
2036: end if;
2037: */

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

2038:
2039: EXCEPTION
2040: WHEN OTHERS THEN
2041: if g_call_from_setup = 'Y' then
2042: oe_debug_pub.add('ATTR_GRP_PVT.Populate_Pattern_Phases ' || SQLERRM);
2043: else
2044: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Populate_Pattern_Phases ' || SQLERRM );
2045: end if;
2046: raise;

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

2067: BEGIN
2068: g_call_from_setup := 'Y';
2069:
2070: if g_call_from_setup = 'Y' then
2071: oe_debug_pub.add('Header_Pattern_Main - p_list_header_id = ' ||p_list_header_id);
2072: oe_debug_pub.add('Header_Pattern_Main - p_qualifier_group = ' ||p_qualifier_group);
2073: oe_debug_pub.add('Header_Pattern_Main - p_setup_action = ' ||p_setup_action);
2074: else
2075: fnd_file.put_line(FND_FILE.LOG, 'Header_Pattern_Main - p_list_header_id = ' ||p_list_header_id);

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

2068: g_call_from_setup := 'Y';
2069:
2070: if g_call_from_setup = 'Y' then
2071: oe_debug_pub.add('Header_Pattern_Main - p_list_header_id = ' ||p_list_header_id);
2072: oe_debug_pub.add('Header_Pattern_Main - p_qualifier_group = ' ||p_qualifier_group);
2073: oe_debug_pub.add('Header_Pattern_Main - p_setup_action = ' ||p_setup_action);
2074: else
2075: fnd_file.put_line(FND_FILE.LOG, 'Header_Pattern_Main - p_list_header_id = ' ||p_list_header_id);
2076: fnd_file.put_line(FND_FILE.LOG, 'Header_Pattern_Main - p_qualifier_group = ' ||p_qualifier_group);

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

2069:
2070: if g_call_from_setup = 'Y' then
2071: oe_debug_pub.add('Header_Pattern_Main - p_list_header_id = ' ||p_list_header_id);
2072: oe_debug_pub.add('Header_Pattern_Main - p_qualifier_group = ' ||p_qualifier_group);
2073: oe_debug_pub.add('Header_Pattern_Main - p_setup_action = ' ||p_setup_action);
2074: else
2075: fnd_file.put_line(FND_FILE.LOG, 'Header_Pattern_Main - p_list_header_id = ' ||p_list_header_id);
2076: fnd_file.put_line(FND_FILE.LOG, 'Header_Pattern_Main - p_qualifier_group = ' ||p_qualifier_group);
2077: fnd_file.put_line(FND_FILE.LOG, 'Header_Pattern_Main - p_setup_action = ' ||p_setup_action);

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

2196:
2197: exception
2198: when no_data_found then
2199: if g_call_from_setup = 'Y' then
2200: oe_debug_pub.add('Header_Pattern_Main - no_data_found in action UD ' );
2201: end if;
2202: null;
2203:
2204: when others then

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

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

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

2211:
2212: EXCEPTION
2213: WHEN OTHERS THEN
2214: if g_call_from_setup = 'Y' then
2215: oe_debug_pub.add('ATTR_GRP_PVT.Header_Pattern_Main ' || SQLERRM);
2216: else
2217: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Header_Pattern_Main ' || SQLERRM );
2218: end if;
2219:

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

2234: BEGIN
2235: g_call_from_setup := 'Y';
2236:
2237: if g_call_from_setup = 'Y' then
2238: oe_debug_pub.add('Line_Pattern_Main - p_list_header_id = ' ||p_list_header_id);
2239: oe_debug_pub.add('Line_Pattern_Main - p_list_line_id = ' ||p_list_line_id);
2240: oe_debug_pub.add('Line_Pattern_Main - p_qualifier_group = ' ||p_qualifier_group);
2241: oe_debug_pub.add('Line_Pattern_Main - p_setup_action = ' ||p_setup_action);
2242: else

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

2235: g_call_from_setup := 'Y';
2236:
2237: if g_call_from_setup = 'Y' then
2238: oe_debug_pub.add('Line_Pattern_Main - p_list_header_id = ' ||p_list_header_id);
2239: oe_debug_pub.add('Line_Pattern_Main - p_list_line_id = ' ||p_list_line_id);
2240: oe_debug_pub.add('Line_Pattern_Main - p_qualifier_group = ' ||p_qualifier_group);
2241: oe_debug_pub.add('Line_Pattern_Main - p_setup_action = ' ||p_setup_action);
2242: else
2243: fnd_file.put_line(FND_FILE.LOG, 'Line_Pattern_Main - p_list_header_id = ' ||p_list_header_id);

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

2236:
2237: if g_call_from_setup = 'Y' then
2238: oe_debug_pub.add('Line_Pattern_Main - p_list_header_id = ' ||p_list_header_id);
2239: oe_debug_pub.add('Line_Pattern_Main - p_list_line_id = ' ||p_list_line_id);
2240: oe_debug_pub.add('Line_Pattern_Main - p_qualifier_group = ' ||p_qualifier_group);
2241: oe_debug_pub.add('Line_Pattern_Main - p_setup_action = ' ||p_setup_action);
2242: else
2243: fnd_file.put_line(FND_FILE.LOG, 'Line_Pattern_Main - p_list_header_id = ' ||p_list_header_id);
2244: fnd_file.put_line(FND_FILE.LOG, 'Line_Pattern_Main - p_list_line_id = ' ||p_list_line_id);

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

2237: if g_call_from_setup = 'Y' then
2238: oe_debug_pub.add('Line_Pattern_Main - p_list_header_id = ' ||p_list_header_id);
2239: oe_debug_pub.add('Line_Pattern_Main - p_list_line_id = ' ||p_list_line_id);
2240: oe_debug_pub.add('Line_Pattern_Main - p_qualifier_group = ' ||p_qualifier_group);
2241: oe_debug_pub.add('Line_Pattern_Main - p_setup_action = ' ||p_setup_action);
2242: else
2243: fnd_file.put_line(FND_FILE.LOG, 'Line_Pattern_Main - p_list_header_id = ' ||p_list_header_id);
2244: fnd_file.put_line(FND_FILE.LOG, 'Line_Pattern_Main - p_list_line_id = ' ||p_list_line_id);
2245: fnd_file.put_line(FND_FILE.LOG, 'Line_Pattern_Main - p_qualifier_group = ' ||p_qualifier_group);

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

2352:
2353: exception
2354: when no_data_found then
2355: if g_call_from_setup = 'Y' then
2356: oe_debug_pub.add('Line_Pattern_Main - no_data_found in action UD ' );
2357: end if;
2358: null;
2359:
2360: when others then

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

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

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

2405:
2406: EXCEPTION
2407: WHEN OTHERS THEN
2408: if g_call_from_setup = 'Y' then
2409: oe_debug_pub.add('ATTR_GRP_PVT.Line_Pattern_Main ' || SQLERRM);
2410: else
2411: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Line_Pattern_Main ' || SQLERRM );
2412: end if;
2413:

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

2427: BEGIN
2428: g_call_from_setup := 'Y';
2429:
2430: if g_call_from_setup = 'Y' then
2431: oe_debug_pub.add('Product_Pattern_Main - p_list_header_id = ' ||p_list_header_id);
2432: oe_debug_pub.add('Product_Pattern_Main - p_list_line_id = ' ||p_list_line_id);
2433: oe_debug_pub.add('Product_Pattern_Main - p_setup_action = ' ||p_setup_action);
2434: else
2435: fnd_file.put_line(FND_FILE.LOG, 'Product_Pattern_Main - p_list_header_id = ' ||p_list_header_id);

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

2428: g_call_from_setup := 'Y';
2429:
2430: if g_call_from_setup = 'Y' then
2431: oe_debug_pub.add('Product_Pattern_Main - p_list_header_id = ' ||p_list_header_id);
2432: oe_debug_pub.add('Product_Pattern_Main - p_list_line_id = ' ||p_list_line_id);
2433: oe_debug_pub.add('Product_Pattern_Main - p_setup_action = ' ||p_setup_action);
2434: else
2435: fnd_file.put_line(FND_FILE.LOG, 'Product_Pattern_Main - p_list_header_id = ' ||p_list_header_id);
2436: fnd_file.put_line(FND_FILE.LOG, 'Product_Pattern_Main - p_list_line_id = ' ||p_list_line_id);

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

2429:
2430: if g_call_from_setup = 'Y' then
2431: oe_debug_pub.add('Product_Pattern_Main - p_list_header_id = ' ||p_list_header_id);
2432: oe_debug_pub.add('Product_Pattern_Main - p_list_line_id = ' ||p_list_line_id);
2433: oe_debug_pub.add('Product_Pattern_Main - p_setup_action = ' ||p_setup_action);
2434: else
2435: fnd_file.put_line(FND_FILE.LOG, 'Product_Pattern_Main - p_list_header_id = ' ||p_list_header_id);
2436: fnd_file.put_line(FND_FILE.LOG, 'Product_Pattern_Main - p_list_line_id = ' ||p_list_line_id);
2437: fnd_file.put_line(FND_FILE.LOG, 'Product_Pattern_Main - p_setup_action = ' ||p_setup_action);

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

2441: into l_qual_ind
2442: from qp_list_lines
2443: where list_line_id = p_list_line_id;
2444:
2445: oe_debug_pub.add('Product_Pattern_Main - l_qual_ind = ' ||l_qual_ind);
2446:
2447: -- do nothing, return back if called for child line, bug 3581058
2448: if l_qual_ind in (4, 6, 8, 10, 12, 14, 20, 22, 28, 30) then
2449: null;

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

2484: end;
2485:
2486: if l_qual_exists = 'Y' then
2487: if g_call_from_setup = 'Y' then
2488: oe_debug_pub.add('going to populate LP');
2489: else
2490: fnd_file.put_line(FND_FILE.LOG, 'going to populate LP');
2491: end if;
2492: Line_Pattern_Main(p_list_header_id, p_list_line_id, null, 'I');

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

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

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

2509:
2510: EXCEPTION
2511: WHEN OTHERS THEN
2512: if g_call_from_setup = 'Y' then
2513: oe_debug_pub.add('ATTR_GRP_PVT.Product_Pattern_Main ' || SQLERRM);
2514: else
2515: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Product_Pattern_Main ' || SQLERRM );
2516: end if;
2517:

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

2534: null;
2535:
2536: when others then
2537: if g_call_from_setup = 'Y' then
2538: oe_debug_pub.add('ATTR_GRP_PVT.Remove_Prod_Pattern_For_Line ' || SQLERRM);
2539: else
2540: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Remove_Prod_Pattern_For_Line ' || SQLERRM );
2541: end if;
2542: raise;

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

2569:
2570: begin
2571: -- update the segment_id columns for qualifiers
2572: if g_call_from_setup = 'Y' then
2573: oe_debug_pub.add('Inside Update_Qual_Segment_id');
2574: oe_debug_pub.add('Start time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
2575: else
2576: fnd_file.put_line(FND_FILE.LOG, 'Inside Update_Qual_Segment_id');
2577: fnd_file.put_line(FND_FILE.LOG, 'Start time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));

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

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

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

2587: CLOSE c_qual_seg_id;
2588:
2589: if context_t.count > 0 then
2590: if g_call_from_setup = 'Y' then
2591: oe_debug_pub.add('Context_t.count='||context_t.count);
2592: else
2593: fnd_file.put_line(FND_FILE.LOG, 'Context_t.count='||context_t.count);
2594: end if;
2595: FOR i in 1..context_t.count

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

2610: and list_header_id = nvl(p_list_header_id, list_header_id)
2611: and list_line_id between p_low_list_line_id and p_high_list_line_id;
2612:
2613: if g_call_from_setup = 'Y' then
2614: oe_debug_pub.add('No of qualifiers updated='||SQL%ROWCOUNT);
2615: else
2616: fnd_file.put_line(FND_FILE.LOG, 'No of qualifiers updated='||SQL%ROWCOUNT);
2617: end if;
2618: end if; -- context_t.count > 0

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

2617: end if;
2618: end if; -- context_t.count > 0
2619:
2620: if g_call_from_setup = 'Y' then
2621: oe_debug_pub.add('End Update_Qual_Segment_id');
2622: oe_debug_pub.add('End time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
2623: else
2624: fnd_file.put_line(FND_FILE.LOG, 'End Update_Qual_Segment_id');
2625: fnd_file.put_line(FND_FILE.LOG, 'End time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));

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

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

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

2626: end if;
2627: exception
2628: when no_data_found then
2629: if g_call_from_setup = 'Y' then
2630: oe_debug_pub.add('No data found in c_qual_seg_id');
2631: else
2632: fnd_file.put_line(FND_FILE.LOG, 'No data found in c_qual_seg_id');
2633: end if;
2634:

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

2633: end if;
2634:
2635: when others then
2636: if g_call_from_setup = 'Y' then
2637: oe_debug_pub.add('ATTR_GRP_PVT.Update_Qual_Segment_Id ' || SQLERRM);
2638: else
2639: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Update_Qual_Segment_Id ' || SQLERRM );
2640: end if;
2641:

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

2674:
2675:
2676: begin
2677: if g_call_from_setup = 'Y' then
2678: oe_debug_pub.add('Inside Update_Prod_Pric_Segment_id');
2679: oe_debug_pub.add('Start time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
2680: else
2681: fnd_file.put_line(FND_FILE.LOG, 'Inside Update_Prod_Pric_Segment_id');
2682: fnd_file.put_line(FND_FILE.LOG, 'Start time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));

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

2675:
2676: begin
2677: if g_call_from_setup = 'Y' then
2678: oe_debug_pub.add('Inside Update_Prod_Pric_Segment_id');
2679: oe_debug_pub.add('Start time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
2680: else
2681: fnd_file.put_line(FND_FILE.LOG, 'Inside Update_Prod_Pric_Segment_id');
2682: fnd_file.put_line(FND_FILE.LOG, 'Start time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
2683: end if;

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

2693: CLOSE c_prod_seg_id;
2694:
2695: if context_t.count > 0 then
2696: if g_call_from_setup = 'Y' then
2697: oe_debug_pub.add('Context_t.count='||context_t.count);
2698: else
2699: fnd_file.put_line(FND_FILE.LOG, 'Context_t.count='||context_t.count);
2700: end if;
2701: FOR i in 1..context_t.count

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

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

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

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

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

2737: CLOSE c_pric_seg_id;
2738:
2739: if context_t.count > 0 then
2740: if g_call_from_setup = 'Y' then
2741: oe_debug_pub.add('Context_t.count='||context_t.count);
2742: else
2743: fnd_file.put_line(FND_FILE.LOG, 'Context_t.count='||context_t.count);
2744: end if;
2745:

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

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

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

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

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

2770: end if;
2771: end if; -- context_t.count > 0
2772:
2773: if g_call_from_setup = 'Y' then
2774: oe_debug_pub.add('End Update_Prod_Pric_Segment_id');
2775: else
2776: fnd_file.put_line(FND_FILE.LOG, 'End Update_Prod_Pric_Segment_id');
2777: end if;
2778: exception

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

2777: end if;
2778: exception
2779: when no_data_found then
2780: if g_call_from_setup = 'Y' then
2781: oe_debug_pub.add('No data found in Update_Prod_Pric_Segment_id');
2782: else
2783: fnd_file.put_line(FND_FILE.LOG, 'No data found in Update_Prod_Pric_Segment_id');
2784: end if;
2785:

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

2786: null;
2787:
2788: when others then
2789: if g_call_from_setup = 'Y' then
2790: oe_debug_pub.add('ATTR_GRP_PVT.Update_Prod_Pric_Segment_id ' || SQLERRM);
2791: else
2792: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ATTR_GRP_PVT.Update_Prod_Pric_Segment_id ' || SQLERRM );
2793: end if;
2794: