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.OE_AUDIT_HISTORY_PVT dependencies on OE_DEBUG_PUB

Line 16: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

12:
13: l_inventory_item VARCHAR2(240) := NULL;
14: l_validation_org_id NUMBER := NULL;
15:
16: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
17:
18: BEGIN
19:
20: IF p_inventory_item_id IS NOT NULL THEN

Line 34: oe_debug_pub.ADD('l_inventory_item');

30: FROM MTL_SYSTEM_ITEMS_kfv
31: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
32: AND ORGANIZATION_ID = l_validation_org_id;
33:
34: oe_debug_pub.ADD('l_inventory_item');
35:
36:
37: END IF;
38: RETURN l_inventory_item;

Line 80: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

76: l_attribute_code varchar2(80);
77: l_attribute_display_value varchar2(2000);
78: l_display_name varchar2(500);
79: --
80: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
81: --
82: BEGIN
83:
84: BEGIN

Line 538: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

534: l_last_instrument_id NUMBER;
535: l_instr_flag VARCHAR2(1);
536:
537: --
538: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
539: --
540:
541: BEGIN
542:

Line 544: oe_debug_pub.add('Enter audit history consolidate program',1);

540:
541: BEGIN
542:
543: IF l_debug_level > 0 THEN
544: oe_debug_pub.add('Enter audit history consolidate program',1);
545: END IF;
546:
547: --Added for MOAC
548: If l_input_org_id IS NOT NULL THEN

Line 634: oe_debug_pub.add('History start date => '||to_char(min_hist_creation_date,'dd-mon-yyyy hh24:mi:ss'),1);

630: max_hist_creation_date := sysdate;
631: end if;
632:
633: IF l_debug_level > 0 THEN
634: oe_debug_pub.add('History start date => '||to_char(min_hist_creation_date,'dd-mon-yyyy hh24:mi:ss'),1);
635: oe_debug_pub.add('History end date => '||to_char(max_hist_creation_date,'dd-mon-yyyy hh24:mi:ss'),1);
636: END IF;
637:
638: FOR c_ent_rec in c_entities

Line 635: oe_debug_pub.add('History end date => '||to_char(max_hist_creation_date,'dd-mon-yyyy hh24:mi:ss'),1);

631: end if;
632:
633: IF l_debug_level > 0 THEN
634: oe_debug_pub.add('History start date => '||to_char(min_hist_creation_date,'dd-mon-yyyy hh24:mi:ss'),1);
635: oe_debug_pub.add('History end date => '||to_char(max_hist_creation_date,'dd-mon-yyyy hh24:mi:ss'),1);
636: END IF;
637:
638: FOR c_ent_rec in c_entities
639: LOOP

Line 642: oe_debug_pub.add('Consolidating history records for entity '||to_char(c_ent_rec.entity_id),1);

638: FOR c_ent_rec in c_entities
639: LOOP
640:
641: IF l_debug_level > 0 THEN
642: oe_debug_pub.add('Consolidating history records for entity '||to_char(c_ent_rec.entity_id),1);
643: END IF;
644:
645: /* Check whether history records exist for this entity in the date range */
646: --8265428 l_cnt_stmt := 'select count(*) from ' || c_ent_rec.entity_name || ' where trunc(hist_creation_date) between :x and :z and ';

Line 723: oe_debug_pub.add('NO matching history records in this date range for entity '||to_char(c_ent_rec.entity_id),1);

719: CLOSE ref_attr;
720:
721: if l_count=0 then
722: IF l_debug_level > 0 THEN
723: oe_debug_pub.add('NO matching history records in this date range for entity '||to_char(c_ent_rec.entity_id),1);
724: END IF;
725: goto End_Of_Entity;
726: end if;
727:

Line 737: OE_DEBUG_PUB.add('Consolidating for all attributes',1);

733:
734: v_attr_index:=1;
735: IF v_entity_constrained = 'Y' THEN
736: IF l_debug_level > 0 THEN
737: OE_DEBUG_PUB.add('Consolidating for all attributes',1);
738: END IF;
739: FOR c_attr_rec IN c_all_attributes(c_ent_rec.entity_id) LOOP
740: c_attr_tbl(v_attr_index).entity_id := c_ent_rec.entity_id;
741: c_attr_tbl(v_attr_index).attribute_id := c_attr_rec.attribute_id;

Line 749: OE_DEBUG_PUB.add('Consolidating for currently constrained attributes only',1);

745: v_attr_index := v_attr_index+1;
746: END LOOP;
747: ELSE
748: IF l_debug_level > 0 THEN
749: OE_DEBUG_PUB.add('Consolidating for currently constrained attributes only',1);
750: END IF;
751:
752: FOR c_attr_rec IN c_const_attributes(c_ent_rec.entity_id) LOOP
753: c_attr_tbl(v_attr_index).entity_id := c_ent_rec.entity_id;

Line 782: oe_debug_pub.add(' ');

778: -- 16447475 start, Comparison of attribute changes has to be done based on Creation Date
779: l_ent_stmt := l_ent_stmt || ' and nvl(audit_flag, ''Y'') = ''Y'' ORDER BY hist_creation_date asc';
780:
781: IF l_debug_level > 0 THEN
782: oe_debug_pub.add(' ');
783: oe_debug_pub.add('SK 101 '||l_ent_stmt);
784: oe_debug_pub.add(' ');
785: End If;
786: -- 16447475 end

Line 783: oe_debug_pub.add('SK 101 '||l_ent_stmt);

779: l_ent_stmt := l_ent_stmt || ' and nvl(audit_flag, ''Y'') = ''Y'' ORDER BY hist_creation_date asc';
780:
781: IF l_debug_level > 0 THEN
782: oe_debug_pub.add(' ');
783: oe_debug_pub.add('SK 101 '||l_ent_stmt);
784: oe_debug_pub.add(' ');
785: End If;
786: -- 16447475 end
787: -- Following code added for 4394119. This version of the entity statement does not

Line 784: oe_debug_pub.add(' ');

780:
781: IF l_debug_level > 0 THEN
782: oe_debug_pub.add(' ');
783: oe_debug_pub.add('SK 101 '||l_ent_stmt);
784: oe_debug_pub.add(' ');
785: End If;
786: -- 16447475 end
787: -- Following code added for 4394119. This version of the entity statement does not
788: -- use the hist table alias. As a result, when the inner query uses this statement

Line 814: oe_debug_pub.add(' ');

810:
811: l_ent_stmt_subquery := l_ent_stmt_subquery || ' and nvl(audit_flag, ''Y'') = ''Y'' ';
812: l_ent_stmt_subquery2 := l_ent_stmt_subquery2 || ' and nvl(audit_flag, ''Y'') = ''Y'' '; -- 16447475
813: IF l_debug_level > 0 THEN
814: oe_debug_pub.add(' ');
815: oe_debug_pub.add('For entity id ' || c_ent_rec.entity_id || ' Constructed subquery entity statement: ' || l_ent_stmt_subquery);
816: oe_debug_pub.add(' ');
817: END IF;
818: -- end bug 4394119

Line 815: oe_debug_pub.add('For entity id ' || c_ent_rec.entity_id || ' Constructed subquery entity statement: ' || l_ent_stmt_subquery);

811: l_ent_stmt_subquery := l_ent_stmt_subquery || ' and nvl(audit_flag, ''Y'') = ''Y'' ';
812: l_ent_stmt_subquery2 := l_ent_stmt_subquery2 || ' and nvl(audit_flag, ''Y'') = ''Y'' '; -- 16447475
813: IF l_debug_level > 0 THEN
814: oe_debug_pub.add(' ');
815: oe_debug_pub.add('For entity id ' || c_ent_rec.entity_id || ' Constructed subquery entity statement: ' || l_ent_stmt_subquery);
816: oe_debug_pub.add(' ');
817: END IF;
818: -- end bug 4394119
819:

Line 816: oe_debug_pub.add(' ');

812: l_ent_stmt_subquery2 := l_ent_stmt_subquery2 || ' and nvl(audit_flag, ''Y'') = ''Y'' '; -- 16447475
813: IF l_debug_level > 0 THEN
814: oe_debug_pub.add(' ');
815: oe_debug_pub.add('For entity id ' || c_ent_rec.entity_id || ' Constructed subquery entity statement: ' || l_ent_stmt_subquery);
816: oe_debug_pub.add(' ');
817: END IF;
818: -- end bug 4394119
819:
820: /*8265428 start

Line 920: oe_debug_pub.add(' ');

916: l_id_stmt := l_id_stmt || l_order_by;
917:
918: --16447475 start
919: IF l_debug_level > 0 THEN
920: oe_debug_pub.add(' ');
921: oe_debug_pub.add('SK 102 l_id_stmt= '||l_id_stmt);
922: oe_debug_pub.add(' ');
923: End If;
924: --16447475 end

Line 921: oe_debug_pub.add('SK 102 l_id_stmt= '||l_id_stmt);

917:
918: --16447475 start
919: IF l_debug_level > 0 THEN
920: oe_debug_pub.add(' ');
921: oe_debug_pub.add('SK 102 l_id_stmt= '||l_id_stmt);
922: oe_debug_pub.add(' ');
923: End If;
924: --16447475 end
925: if order_number_from is not null and order_number_to is not null then

Line 922: oe_debug_pub.add(' ');

918: --16447475 start
919: IF l_debug_level > 0 THEN
920: oe_debug_pub.add(' ');
921: oe_debug_pub.add('SK 102 l_id_stmt= '||l_id_stmt);
922: oe_debug_pub.add(' ');
923: End If;
924: --16447475 end
925: if order_number_from is not null and order_number_to is not null then
926: If l_input_org_id IS NOT NULL THEN

Line 981: oe_debug_pub.add('Unable to locate header record for header ID : '||l_header_id||' ERROR: '||SQLERRM , 1 ) ;

977: WHERE HEADER_ID = l_header_id;
978:
979: EXCEPTION WHEN OTHERS THEN
980: IF l_debug_level > 0 THEN
981: oe_debug_pub.add('Unable to locate header record for header ID : '||l_header_id||' ERROR: '||SQLERRM , 1 ) ;
982: END IF;
983: --assiging null to order attributes bug14285026
984: l_order_number := NULL;
985: l_sold_to_org_id := NULL;

Line 1111: oe_debug_pub.add('Entity id not recognized '||c_ent_rec.entity_id,1);

1107: || l_ent_stmt;
1108: END IF;
1109: ELSE
1110: IF l_debug_level > 0 THEN
1111: oe_debug_pub.add('Entity id not recognized '||c_ent_rec.entity_id,1);
1112: END IF;
1113: END IF;
1114: -- 16447475 start
1115: IF l_debug_level > 0 THEN

Line 1116: oe_debug_pub.add(' ');

1112: END IF;
1113: END IF;
1114: -- 16447475 start
1115: IF l_debug_level > 0 THEN
1116: oe_debug_pub.add(' ');
1117: oe_debug_pub.add('SK 103.001 l_sql_stmt= '||l_sql_stmt);
1118: oe_debug_pub.add('SK 103.002 min_hist_creation_date= '
1119: ||to_char(min_hist_creation_date,'DD-MM-YYYY Hh24:MI:SS')
1120: ||' max_hist_creation_date= '

Line 1117: oe_debug_pub.add('SK 103.001 l_sql_stmt= '||l_sql_stmt);

1113: END IF;
1114: -- 16447475 start
1115: IF l_debug_level > 0 THEN
1116: oe_debug_pub.add(' ');
1117: oe_debug_pub.add('SK 103.001 l_sql_stmt= '||l_sql_stmt);
1118: oe_debug_pub.add('SK 103.002 min_hist_creation_date= '
1119: ||to_char(min_hist_creation_date,'DD-MM-YYYY Hh24:MI:SS')
1120: ||' max_hist_creation_date= '
1121: ||to_char(max_hist_creation_date,'DD-MM-YYYY Hh24:MI:SS')

Line 1118: oe_debug_pub.add('SK 103.002 min_hist_creation_date= '

1114: -- 16447475 start
1115: IF l_debug_level > 0 THEN
1116: oe_debug_pub.add(' ');
1117: oe_debug_pub.add('SK 103.001 l_sql_stmt= '||l_sql_stmt);
1118: oe_debug_pub.add('SK 103.002 min_hist_creation_date= '
1119: ||to_char(min_hist_creation_date,'DD-MM-YYYY Hh24:MI:SS')
1120: ||' max_hist_creation_date= '
1121: ||to_char(max_hist_creation_date,'DD-MM-YYYY Hh24:MI:SS')
1122: ||' l_header_id= '||l_header_id

Line 1124: oe_debug_pub.add(' ');

1120: ||' max_hist_creation_date= '
1121: ||to_char(max_hist_creation_date,'DD-MM-YYYY Hh24:MI:SS')
1122: ||' l_header_id= '||l_header_id
1123: ||' l_entity_number= '||l_entity_number);
1124: oe_debug_pub.add(' ');
1125: End IF;
1126: --16447475 end
1127:
1128: BEGIN

Line 1152: oe_debug_pub.add('SK 105 l_old_db_rec_upd_flag is TRUE');

1148: /* Following condition for any iteration after the first */
1149: IF (l_old_db_rec_upd_flag = TRUE) THEN
1150: --16447475 start
1151: IF l_debug_level > 0 THEN
1152: oe_debug_pub.add('SK 105 l_old_db_rec_upd_flag is TRUE');
1153: End If; --16447475 end
1154:
1155: l_old_hist_creation_date := l_hist_creation_date;
1156: l_old_reason_code := l_reason_code;

Line 1185: oe_debug_pub.add('SK 106 l_count_hist = '||l_count_hist

1181: AND entity_id = c_ent_rec.entity_id
1182: and rownum = 1; -- Added for bug 7319059
1183: --16447475 start
1184: IF l_debug_level > 0 THEN
1185: oe_debug_pub.add('SK 106 l_count_hist = '||l_count_hist
1186: || ' Attribute ID= '||c_attr_tbl(j).attribute_id);
1187: End If;
1188: --16447475 end
1189: IF l_count_hist > 0 THEN

Line 1268: oe_debug_pub.add(' ');

1264: oe_pc_attr_tbl(l_rec_counter).new_context_value:= l_context_value;
1265: oe_pc_attr_tbl(l_rec_counter).old_context_value:= l_old_context_value;
1266: -- 16447475 start
1267: IF l_debug_level > 0 THEN
1268: oe_debug_pub.add(' ');
1269: oe_debug_pub.add('SK 107 Printing');
1270: oe_debug_pub.add('entity_id:- '||oe_pc_attr_tbl(l_rec_counter).entity_id );
1271: oe_debug_pub.add('attribute_id:- '||oe_pc_attr_tbl(l_rec_counter).attribute_id);
1272: oe_debug_pub.add('old_attribute_value:- '||oe_pc_attr_tbl(l_rec_counter).old_attribute_value);

Line 1269: oe_debug_pub.add('SK 107 Printing');

1265: oe_pc_attr_tbl(l_rec_counter).old_context_value:= l_old_context_value;
1266: -- 16447475 start
1267: IF l_debug_level > 0 THEN
1268: oe_debug_pub.add(' ');
1269: oe_debug_pub.add('SK 107 Printing');
1270: oe_debug_pub.add('entity_id:- '||oe_pc_attr_tbl(l_rec_counter).entity_id );
1271: oe_debug_pub.add('attribute_id:- '||oe_pc_attr_tbl(l_rec_counter).attribute_id);
1272: oe_debug_pub.add('old_attribute_value:- '||oe_pc_attr_tbl(l_rec_counter).old_attribute_value);
1273: oe_debug_pub.add('new_attribute_value:- '||oe_pc_attr_tbl(l_rec_counter).new_attribute_value);

Line 1270: oe_debug_pub.add('entity_id:- '||oe_pc_attr_tbl(l_rec_counter).entity_id );

1266: -- 16447475 start
1267: IF l_debug_level > 0 THEN
1268: oe_debug_pub.add(' ');
1269: oe_debug_pub.add('SK 107 Printing');
1270: oe_debug_pub.add('entity_id:- '||oe_pc_attr_tbl(l_rec_counter).entity_id );
1271: oe_debug_pub.add('attribute_id:- '||oe_pc_attr_tbl(l_rec_counter).attribute_id);
1272: oe_debug_pub.add('old_attribute_value:- '||oe_pc_attr_tbl(l_rec_counter).old_attribute_value);
1273: oe_debug_pub.add('new_attribute_value:- '||oe_pc_attr_tbl(l_rec_counter).new_attribute_value);
1274: oe_debug_pub.add('order_number:- '||oe_pc_attr_tbl(l_rec_counter).order_number);

Line 1271: oe_debug_pub.add('attribute_id:- '||oe_pc_attr_tbl(l_rec_counter).attribute_id);

1267: IF l_debug_level > 0 THEN
1268: oe_debug_pub.add(' ');
1269: oe_debug_pub.add('SK 107 Printing');
1270: oe_debug_pub.add('entity_id:- '||oe_pc_attr_tbl(l_rec_counter).entity_id );
1271: oe_debug_pub.add('attribute_id:- '||oe_pc_attr_tbl(l_rec_counter).attribute_id);
1272: oe_debug_pub.add('old_attribute_value:- '||oe_pc_attr_tbl(l_rec_counter).old_attribute_value);
1273: oe_debug_pub.add('new_attribute_value:- '||oe_pc_attr_tbl(l_rec_counter).new_attribute_value);
1274: oe_debug_pub.add('order_number:- '||oe_pc_attr_tbl(l_rec_counter).order_number);
1275: oe_debug_pub.add('entity_number:- '||oe_pc_attr_tbl(l_rec_counter).entity_number);

Line 1272: oe_debug_pub.add('old_attribute_value:- '||oe_pc_attr_tbl(l_rec_counter).old_attribute_value);

1268: oe_debug_pub.add(' ');
1269: oe_debug_pub.add('SK 107 Printing');
1270: oe_debug_pub.add('entity_id:- '||oe_pc_attr_tbl(l_rec_counter).entity_id );
1271: oe_debug_pub.add('attribute_id:- '||oe_pc_attr_tbl(l_rec_counter).attribute_id);
1272: oe_debug_pub.add('old_attribute_value:- '||oe_pc_attr_tbl(l_rec_counter).old_attribute_value);
1273: oe_debug_pub.add('new_attribute_value:- '||oe_pc_attr_tbl(l_rec_counter).new_attribute_value);
1274: oe_debug_pub.add('order_number:- '||oe_pc_attr_tbl(l_rec_counter).order_number);
1275: oe_debug_pub.add('entity_number:- '||oe_pc_attr_tbl(l_rec_counter).entity_number);
1276: oe_debug_pub.add(' ');

Line 1273: oe_debug_pub.add('new_attribute_value:- '||oe_pc_attr_tbl(l_rec_counter).new_attribute_value);

1269: oe_debug_pub.add('SK 107 Printing');
1270: oe_debug_pub.add('entity_id:- '||oe_pc_attr_tbl(l_rec_counter).entity_id );
1271: oe_debug_pub.add('attribute_id:- '||oe_pc_attr_tbl(l_rec_counter).attribute_id);
1272: oe_debug_pub.add('old_attribute_value:- '||oe_pc_attr_tbl(l_rec_counter).old_attribute_value);
1273: oe_debug_pub.add('new_attribute_value:- '||oe_pc_attr_tbl(l_rec_counter).new_attribute_value);
1274: oe_debug_pub.add('order_number:- '||oe_pc_attr_tbl(l_rec_counter).order_number);
1275: oe_debug_pub.add('entity_number:- '||oe_pc_attr_tbl(l_rec_counter).entity_number);
1276: oe_debug_pub.add(' ');
1277: End IF;

Line 1274: oe_debug_pub.add('order_number:- '||oe_pc_attr_tbl(l_rec_counter).order_number);

1270: oe_debug_pub.add('entity_id:- '||oe_pc_attr_tbl(l_rec_counter).entity_id );
1271: oe_debug_pub.add('attribute_id:- '||oe_pc_attr_tbl(l_rec_counter).attribute_id);
1272: oe_debug_pub.add('old_attribute_value:- '||oe_pc_attr_tbl(l_rec_counter).old_attribute_value);
1273: oe_debug_pub.add('new_attribute_value:- '||oe_pc_attr_tbl(l_rec_counter).new_attribute_value);
1274: oe_debug_pub.add('order_number:- '||oe_pc_attr_tbl(l_rec_counter).order_number);
1275: oe_debug_pub.add('entity_number:- '||oe_pc_attr_tbl(l_rec_counter).entity_number);
1276: oe_debug_pub.add(' ');
1277: End IF;
1278: -- 16447475 end

Line 1275: oe_debug_pub.add('entity_number:- '||oe_pc_attr_tbl(l_rec_counter).entity_number);

1271: oe_debug_pub.add('attribute_id:- '||oe_pc_attr_tbl(l_rec_counter).attribute_id);
1272: oe_debug_pub.add('old_attribute_value:- '||oe_pc_attr_tbl(l_rec_counter).old_attribute_value);
1273: oe_debug_pub.add('new_attribute_value:- '||oe_pc_attr_tbl(l_rec_counter).new_attribute_value);
1274: oe_debug_pub.add('order_number:- '||oe_pc_attr_tbl(l_rec_counter).order_number);
1275: oe_debug_pub.add('entity_number:- '||oe_pc_attr_tbl(l_rec_counter).entity_number);
1276: oe_debug_pub.add(' ');
1277: End IF;
1278: -- 16447475 end
1279: l_rec_counter := l_rec_counter +1;

Line 1276: oe_debug_pub.add(' ');

1272: oe_debug_pub.add('old_attribute_value:- '||oe_pc_attr_tbl(l_rec_counter).old_attribute_value);
1273: oe_debug_pub.add('new_attribute_value:- '||oe_pc_attr_tbl(l_rec_counter).new_attribute_value);
1274: oe_debug_pub.add('order_number:- '||oe_pc_attr_tbl(l_rec_counter).order_number);
1275: oe_debug_pub.add('entity_number:- '||oe_pc_attr_tbl(l_rec_counter).entity_number);
1276: oe_debug_pub.add(' ');
1277: End IF;
1278: -- 16447475 end
1279: l_rec_counter := l_rec_counter +1;
1280: END IF;

Line 1294: oe_debug_pub.add(' ');

1290: || ' and header_id = :y '
1291: || l_ent_stmt;
1292: -- 16447475 start
1293: IF l_debug_level > 0 THEN
1294: oe_debug_pub.add(' ');
1295: oe_debug_pub.add('SK 108 l_sql_stmt_last= '||l_sql_stmt_last);
1296: oe_debug_pub.add(' ');
1297: End IF;
1298: -- 16447475 end

Line 1295: oe_debug_pub.add('SK 108 l_sql_stmt_last= '||l_sql_stmt_last);

1291: || l_ent_stmt;
1292: -- 16447475 start
1293: IF l_debug_level > 0 THEN
1294: oe_debug_pub.add(' ');
1295: oe_debug_pub.add('SK 108 l_sql_stmt_last= '||l_sql_stmt_last);
1296: oe_debug_pub.add(' ');
1297: End IF;
1298: -- 16447475 end
1299: OPEN ref_attr_last FOR l_sql_stmt_last using l_hist_creation_date ,l_header_id ,l_entity_number;

Line 1296: oe_debug_pub.add(' ');

1292: -- 16447475 start
1293: IF l_debug_level > 0 THEN
1294: oe_debug_pub.add(' ');
1295: oe_debug_pub.add('SK 108 l_sql_stmt_last= '||l_sql_stmt_last);
1296: oe_debug_pub.add(' ');
1297: End IF;
1298: -- 16447475 end
1299: OPEN ref_attr_last FOR l_sql_stmt_last using l_hist_creation_date ,l_header_id ,l_entity_number;
1300: FETCH ref_attr_last INTO l_count_last;

Line 1304: oe_debug_pub.add('SK 108.55 count_last= '||l_count_last

1300: FETCH ref_attr_last INTO l_count_last;
1301: CLOSE ref_attr_last;
1302: -- 16447475 start
1303: IF l_debug_level > 0 THEN
1304: oe_debug_pub.add('SK 108.55 count_last= '||l_count_last
1305: ||' l_hist_creation_date='
1306: ||to_char(l_hist_creation_date,'DD-MM-YYYY HH24:MI:SS')
1307: ||' l_header_id= '||l_header_id
1308: ||' l_entity_number= '||l_entity_number);

Line 1309: oe_debug_pub.add(' ');

1305: ||' l_hist_creation_date='
1306: ||to_char(l_hist_creation_date,'DD-MM-YYYY HH24:MI:SS')
1307: ||' l_header_id= '||l_header_id
1308: ||' l_entity_number= '||l_entity_number);
1309: oe_debug_pub.add(' ');
1310: End IF;
1311: -- 16447475 end
1312: IF (l_count_last = 0) THEN
1313:

Line 1333: oe_debug_pub.add('column name is: '||c_attr_tbl(j).column_name, 5);

1329: END IF;
1330: END IF;
1331:
1332: IF l_debug_level > 0 THEN
1333: oe_debug_pub.add('column name is: '||c_attr_tbl(j).column_name, 5);
1334: END IF;
1335:
1336: if (c_ent_rec.entity_id = 1) then
1337: if c_attr_tbl(j).attribute_id in (46, 47, 48,49) then

Line 1434: oe_debug_pub.add(' ');

1430: || ' and hist.reason_id = oer.reason_id(+) '
1431: || l_ent_stmt;
1432: -- 16447475 start
1433: IF l_debug_level > 0 THEN
1434: oe_debug_pub.add(' ');
1435: oe_debug_pub.add('SK 109 l_sql_stmt_last= '||l_sql_stmt_last);
1436: End IF; -- 16447475 end
1437: ELSE
1438: l_sql_stmt_last :=

Line 1435: oe_debug_pub.add('SK 109 l_sql_stmt_last= '||l_sql_stmt_last);

1431: || l_ent_stmt;
1432: -- 16447475 start
1433: IF l_debug_level > 0 THEN
1434: oe_debug_pub.add(' ');
1435: oe_debug_pub.add('SK 109 l_sql_stmt_last= '||l_sql_stmt_last);
1436: End IF; -- 16447475 end
1437: ELSE
1438: l_sql_stmt_last :=
1439: 'select hist_creation_date, nvl(oer.reason_code, hist.reason_code), '

Line 1453: oe_debug_pub.add(' ');

1449: || l_ent_stmt;
1450:
1451: -- 16447475 start
1452: IF l_debug_level > 0 THEN
1453: oe_debug_pub.add(' ');
1454: oe_debug_pub.add('SK 110 l_sql_stmt_last= '||l_sql_stmt_last);
1455: oe_debug_pub.add(' ');
1456: End IF; -- 16447475 end
1457: END IF;

Line 1454: oe_debug_pub.add('SK 110 l_sql_stmt_last= '||l_sql_stmt_last);

1450:
1451: -- 16447475 start
1452: IF l_debug_level > 0 THEN
1453: oe_debug_pub.add(' ');
1454: oe_debug_pub.add('SK 110 l_sql_stmt_last= '||l_sql_stmt_last);
1455: oe_debug_pub.add(' ');
1456: End IF; -- 16447475 end
1457: END IF;
1458: ELSIF (l_count_last > 1) then

Line 1455: oe_debug_pub.add(' ');

1451: -- 16447475 start
1452: IF l_debug_level > 0 THEN
1453: oe_debug_pub.add(' ');
1454: oe_debug_pub.add('SK 110 l_sql_stmt_last= '||l_sql_stmt_last);
1455: oe_debug_pub.add(' ');
1456: End IF; -- 16447475 end
1457: END IF;
1458: ELSIF (l_count_last > 1) then
1459: IF l_debug_level > 0 THEN

Line 1460: oe_debug_pub.add('Executing subquery: ' || l_ent_stmt_subquery);

1456: End IF; -- 16447475 end
1457: END IF;
1458: ELSIF (l_count_last > 1) then
1459: IF l_debug_level > 0 THEN
1460: oe_debug_pub.add('Executing subquery: ' || l_ent_stmt_subquery);
1461: oe_debug_pub.add('Entity id: ' || c_ent_rec.entity_id || ' date: ' || l_hist_creation_date || ' Header Id: ' || l_header_id || ' entity number ' || l_entity_number);
1462: END IF;
1463: IF (c_ent_rec.entity_id in (6,8)) THEN
1464: l_exists :='Y'; -- 16447475(New Binds are to be used)

Line 1461: oe_debug_pub.add('Entity id: ' || c_ent_rec.entity_id || ' date: ' || l_hist_creation_date || ' Header Id: ' || l_header_id || ' entity number ' || l_entity_number);

1457: END IF;
1458: ELSIF (l_count_last > 1) then
1459: IF l_debug_level > 0 THEN
1460: oe_debug_pub.add('Executing subquery: ' || l_ent_stmt_subquery);
1461: oe_debug_pub.add('Entity id: ' || c_ent_rec.entity_id || ' date: ' || l_hist_creation_date || ' Header Id: ' || l_header_id || ' entity number ' || l_entity_number);
1462: END IF;
1463: IF (c_ent_rec.entity_id in (6,8)) THEN
1464: l_exists :='Y'; -- 16447475(New Binds are to be used)
1465: l_sql_stmt_last :=

Line 1494: oe_debug_pub.add(' ');

1490: || l_ent_stmt_subquery
1491: || ') ';*/
1492: -- 16447475 start
1493: IF l_debug_level > 0 THEN
1494: oe_debug_pub.add(' ');
1495: oe_debug_pub.add('SK 111 l_sql_stmt_last='||l_sql_stmt_last);
1496: oe_debug_pub.add(' ');
1497: End IF; -- 16447475 end
1498: ELSE

Line 1495: oe_debug_pub.add('SK 111 l_sql_stmt_last='||l_sql_stmt_last);

1491: || ') ';*/
1492: -- 16447475 start
1493: IF l_debug_level > 0 THEN
1494: oe_debug_pub.add(' ');
1495: oe_debug_pub.add('SK 111 l_sql_stmt_last='||l_sql_stmt_last);
1496: oe_debug_pub.add(' ');
1497: End IF; -- 16447475 end
1498: ELSE
1499: l_exists :='Y'; -- 16447475(New Binds are to be used)

Line 1496: oe_debug_pub.add(' ');

1492: -- 16447475 start
1493: IF l_debug_level > 0 THEN
1494: oe_debug_pub.add(' ');
1495: oe_debug_pub.add('SK 111 l_sql_stmt_last='||l_sql_stmt_last);
1496: oe_debug_pub.add(' ');
1497: End IF; -- 16447475 end
1498: ELSE
1499: l_exists :='Y'; -- 16447475(New Binds are to be used)
1500: l_sql_stmt_last :=

Line 1530: oe_debug_pub.add(' ');

1526: || l_ent_stmt_subquery
1527: || ') ';*/
1528: -- 16447475 start
1529: IF l_debug_level > 0 THEN
1530: oe_debug_pub.add(' ');
1531: oe_debug_pub.add('SK 116 l_sql_stmt_last='||l_sql_stmt_last);
1532: oe_debug_pub.add(' ');
1533: End If; -- 16447475 end
1534: END IF;

Line 1531: oe_debug_pub.add('SK 116 l_sql_stmt_last='||l_sql_stmt_last);

1527: || ') ';*/
1528: -- 16447475 start
1529: IF l_debug_level > 0 THEN
1530: oe_debug_pub.add(' ');
1531: oe_debug_pub.add('SK 116 l_sql_stmt_last='||l_sql_stmt_last);
1532: oe_debug_pub.add(' ');
1533: End If; -- 16447475 end
1534: END IF;
1535: END IF;

Line 1532: oe_debug_pub.add(' ');

1528: -- 16447475 start
1529: IF l_debug_level > 0 THEN
1530: oe_debug_pub.add(' ');
1531: oe_debug_pub.add('SK 116 l_sql_stmt_last='||l_sql_stmt_last);
1532: oe_debug_pub.add(' ');
1533: End If; -- 16447475 end
1534: END IF;
1535: END IF;
1536: -- 16447475 start

Line 1538: oe_debug_pub.add('SK 116.1 l_hist_creation_date='

1534: END IF;
1535: END IF;
1536: -- 16447475 start
1537: IF l_debug_level > 0 THEN
1538: oe_debug_pub.add('SK 116.1 l_hist_creation_date='
1539: ||to_char(l_hist_creation_date,'DD-MM-YYYY HH24:MI:SS')
1540: ||' l_header_id= '||l_header_id
1541: ||' l_entity_number= '||l_entity_number);
1542: End IF;

Line 1564: oe_debug_pub.add('SK 120 l_attribute_value_last= '||l_attribute_value_last);

1560: CLOSE ref_attr_last;
1561:
1562: -- 16447475 start
1563: IF l_debug_level > 0 THEN
1564: oe_debug_pub.add('SK 120 l_attribute_value_last= '||l_attribute_value_last);
1565: End IF; -- 16447475
1566: END IF;
1567:
1568: -- IF c_attr_tbl(j).column_name = 'INSTRUMENT_ID'

Line 1621: oe_debug_pub.add('old date is '||to_char(l_hist_creation_date ,'HH24:MI:SS DD-MON-YYYY'),1);

1617: goto next_attribute;
1618: END IF;
1619:
1620: IF l_debug_level > 0 THEN
1621: oe_debug_pub.add('old date is '||to_char(l_hist_creation_date ,'HH24:MI:SS DD-MON-YYYY'),1);
1622: oe_debug_pub.add('new date is '||to_char(l_hist_creation_date_last ,'HH24:MI:SS DD-MON-YYYY'),1);
1623: oe_debug_pub.add('old value is '||l_attribute_value ,1);
1624: oe_debug_pub.add('new value is '||l_attribute_value_last,1);
1625: END IF;

Line 1622: oe_debug_pub.add('new date is '||to_char(l_hist_creation_date_last ,'HH24:MI:SS DD-MON-YYYY'),1);

1618: END IF;
1619:
1620: IF l_debug_level > 0 THEN
1621: oe_debug_pub.add('old date is '||to_char(l_hist_creation_date ,'HH24:MI:SS DD-MON-YYYY'),1);
1622: oe_debug_pub.add('new date is '||to_char(l_hist_creation_date_last ,'HH24:MI:SS DD-MON-YYYY'),1);
1623: oe_debug_pub.add('old value is '||l_attribute_value ,1);
1624: oe_debug_pub.add('new value is '||l_attribute_value_last,1);
1625: END IF;
1626:

Line 1623: oe_debug_pub.add('old value is '||l_attribute_value ,1);

1619:
1620: IF l_debug_level > 0 THEN
1621: oe_debug_pub.add('old date is '||to_char(l_hist_creation_date ,'HH24:MI:SS DD-MON-YYYY'),1);
1622: oe_debug_pub.add('new date is '||to_char(l_hist_creation_date_last ,'HH24:MI:SS DD-MON-YYYY'),1);
1623: oe_debug_pub.add('old value is '||l_attribute_value ,1);
1624: oe_debug_pub.add('new value is '||l_attribute_value_last,1);
1625: END IF;
1626:
1627: ELSIF c_attr_tbl(j).attribute_id IN (46,47,48, 49) AND l_count_last = 0 THEN

Line 1624: oe_debug_pub.add('new value is '||l_attribute_value_last,1);

1620: IF l_debug_level > 0 THEN
1621: oe_debug_pub.add('old date is '||to_char(l_hist_creation_date ,'HH24:MI:SS DD-MON-YYYY'),1);
1622: oe_debug_pub.add('new date is '||to_char(l_hist_creation_date_last ,'HH24:MI:SS DD-MON-YYYY'),1);
1623: oe_debug_pub.add('old value is '||l_attribute_value ,1);
1624: oe_debug_pub.add('new value is '||l_attribute_value_last,1);
1625: END IF;
1626:
1627: ELSIF c_attr_tbl(j).attribute_id IN (46,47,48, 49) AND l_count_last = 0 THEN
1628: -- compare the card number between the last record and the one

Line 1681: oe_debug_pub.add('Found history records for order => '||l_order_number,1);

1677:
1678: -- end R12 cc encryption
1679:
1680: IF l_debug_level > 0 THEN
1681: oe_debug_pub.add('Found history records for order => '||l_order_number,1);
1682: END IF;
1683: -- PADSS Start
1684: IF c_attr_tbl(j).attribute_id=47 then
1685: IF l_attribute_value is null then

Line 1713: oe_debug_pub.add(' ');

1709: oe_pc_attr_tbl(l_rec_counter).new_context_value := l_context_value_last;
1710: oe_pc_attr_tbl(l_rec_counter).old_context_value := l_context_value;
1711: -- 16447475 start
1712: IF l_debug_level > 0 THEN
1713: oe_debug_pub.add(' ');
1714: oe_debug_pub.add('SK 122 Printing 2');
1715: oe_debug_pub.add('entity_id:- '||oe_pc_attr_tbl(l_rec_counter).entity_id );
1716: oe_debug_pub.add('attribute_id:- '||oe_pc_attr_tbl(l_rec_counter).attribute_id);
1717: oe_debug_pub.add('old_attribute_value:- '||oe_pc_attr_tbl(l_rec_counter).old_attribute_value);

Line 1714: oe_debug_pub.add('SK 122 Printing 2');

1710: oe_pc_attr_tbl(l_rec_counter).old_context_value := l_context_value;
1711: -- 16447475 start
1712: IF l_debug_level > 0 THEN
1713: oe_debug_pub.add(' ');
1714: oe_debug_pub.add('SK 122 Printing 2');
1715: oe_debug_pub.add('entity_id:- '||oe_pc_attr_tbl(l_rec_counter).entity_id );
1716: oe_debug_pub.add('attribute_id:- '||oe_pc_attr_tbl(l_rec_counter).attribute_id);
1717: oe_debug_pub.add('old_attribute_value:- '||oe_pc_attr_tbl(l_rec_counter).old_attribute_value);
1718: oe_debug_pub.add('new_attribute_value:- '||oe_pc_attr_tbl(l_rec_counter).new_attribute_value);

Line 1715: oe_debug_pub.add('entity_id:- '||oe_pc_attr_tbl(l_rec_counter).entity_id );

1711: -- 16447475 start
1712: IF l_debug_level > 0 THEN
1713: oe_debug_pub.add(' ');
1714: oe_debug_pub.add('SK 122 Printing 2');
1715: oe_debug_pub.add('entity_id:- '||oe_pc_attr_tbl(l_rec_counter).entity_id );
1716: oe_debug_pub.add('attribute_id:- '||oe_pc_attr_tbl(l_rec_counter).attribute_id);
1717: oe_debug_pub.add('old_attribute_value:- '||oe_pc_attr_tbl(l_rec_counter).old_attribute_value);
1718: oe_debug_pub.add('new_attribute_value:- '||oe_pc_attr_tbl(l_rec_counter).new_attribute_value);
1719: oe_debug_pub.add('order_number:- '||oe_pc_attr_tbl(l_rec_counter).order_number);

Line 1716: oe_debug_pub.add('attribute_id:- '||oe_pc_attr_tbl(l_rec_counter).attribute_id);

1712: IF l_debug_level > 0 THEN
1713: oe_debug_pub.add(' ');
1714: oe_debug_pub.add('SK 122 Printing 2');
1715: oe_debug_pub.add('entity_id:- '||oe_pc_attr_tbl(l_rec_counter).entity_id );
1716: oe_debug_pub.add('attribute_id:- '||oe_pc_attr_tbl(l_rec_counter).attribute_id);
1717: oe_debug_pub.add('old_attribute_value:- '||oe_pc_attr_tbl(l_rec_counter).old_attribute_value);
1718: oe_debug_pub.add('new_attribute_value:- '||oe_pc_attr_tbl(l_rec_counter).new_attribute_value);
1719: oe_debug_pub.add('order_number:- '||oe_pc_attr_tbl(l_rec_counter).order_number);
1720: oe_debug_pub.add('entity_number:- '||oe_pc_attr_tbl(l_rec_counter).entity_number);

Line 1717: oe_debug_pub.add('old_attribute_value:- '||oe_pc_attr_tbl(l_rec_counter).old_attribute_value);

1713: oe_debug_pub.add(' ');
1714: oe_debug_pub.add('SK 122 Printing 2');
1715: oe_debug_pub.add('entity_id:- '||oe_pc_attr_tbl(l_rec_counter).entity_id );
1716: oe_debug_pub.add('attribute_id:- '||oe_pc_attr_tbl(l_rec_counter).attribute_id);
1717: oe_debug_pub.add('old_attribute_value:- '||oe_pc_attr_tbl(l_rec_counter).old_attribute_value);
1718: oe_debug_pub.add('new_attribute_value:- '||oe_pc_attr_tbl(l_rec_counter).new_attribute_value);
1719: oe_debug_pub.add('order_number:- '||oe_pc_attr_tbl(l_rec_counter).order_number);
1720: oe_debug_pub.add('entity_number:- '||oe_pc_attr_tbl(l_rec_counter).entity_number);
1721: End IF; -- 16447475

Line 1718: oe_debug_pub.add('new_attribute_value:- '||oe_pc_attr_tbl(l_rec_counter).new_attribute_value);

1714: oe_debug_pub.add('SK 122 Printing 2');
1715: oe_debug_pub.add('entity_id:- '||oe_pc_attr_tbl(l_rec_counter).entity_id );
1716: oe_debug_pub.add('attribute_id:- '||oe_pc_attr_tbl(l_rec_counter).attribute_id);
1717: oe_debug_pub.add('old_attribute_value:- '||oe_pc_attr_tbl(l_rec_counter).old_attribute_value);
1718: oe_debug_pub.add('new_attribute_value:- '||oe_pc_attr_tbl(l_rec_counter).new_attribute_value);
1719: oe_debug_pub.add('order_number:- '||oe_pc_attr_tbl(l_rec_counter).order_number);
1720: oe_debug_pub.add('entity_number:- '||oe_pc_attr_tbl(l_rec_counter).entity_number);
1721: End IF; -- 16447475
1722: l_rec_counter := l_rec_counter+1;

Line 1719: oe_debug_pub.add('order_number:- '||oe_pc_attr_tbl(l_rec_counter).order_number);

1715: oe_debug_pub.add('entity_id:- '||oe_pc_attr_tbl(l_rec_counter).entity_id );
1716: oe_debug_pub.add('attribute_id:- '||oe_pc_attr_tbl(l_rec_counter).attribute_id);
1717: oe_debug_pub.add('old_attribute_value:- '||oe_pc_attr_tbl(l_rec_counter).old_attribute_value);
1718: oe_debug_pub.add('new_attribute_value:- '||oe_pc_attr_tbl(l_rec_counter).new_attribute_value);
1719: oe_debug_pub.add('order_number:- '||oe_pc_attr_tbl(l_rec_counter).order_number);
1720: oe_debug_pub.add('entity_number:- '||oe_pc_attr_tbl(l_rec_counter).entity_number);
1721: End IF; -- 16447475
1722: l_rec_counter := l_rec_counter+1;
1723: --16698375 start

Line 1720: oe_debug_pub.add('entity_number:- '||oe_pc_attr_tbl(l_rec_counter).entity_number);

1716: oe_debug_pub.add('attribute_id:- '||oe_pc_attr_tbl(l_rec_counter).attribute_id);
1717: oe_debug_pub.add('old_attribute_value:- '||oe_pc_attr_tbl(l_rec_counter).old_attribute_value);
1718: oe_debug_pub.add('new_attribute_value:- '||oe_pc_attr_tbl(l_rec_counter).new_attribute_value);
1719: oe_debug_pub.add('order_number:- '||oe_pc_attr_tbl(l_rec_counter).order_number);
1720: oe_debug_pub.add('entity_number:- '||oe_pc_attr_tbl(l_rec_counter).entity_number);
1721: End IF; -- 16447475
1722: l_rec_counter := l_rec_counter+1;
1723: --16698375 start
1724: Else

Line 1726: oe_debug_pub.add(' No Change in Credit Card Dtl, Attr '||c_attr_tbl(j).attribute_id);

1722: l_rec_counter := l_rec_counter+1;
1723: --16698375 start
1724: Else
1725: IF l_debug_level > 0 THEN
1726: oe_debug_pub.add(' No Change in Credit Card Dtl, Attr '||c_attr_tbl(j).attribute_id);
1727: End IF;
1728: End IF; --16698375 END
1729:
1730: END IF;

Line 1741: oe_debug_pub.add('Inserting history records for order number => '||oe_pc_attr_tbl(i).order_number,1);

1737: FOR I in 1..oe_pc_attr_tbl.count LOOP
1738: IF (oe_pc_attr_tbl(I).old_attribute_value is not null OR
1739: oe_pc_attr_tbl(I).new_attribute_value is not null) THEN
1740: IF l_debug_level > 0 THEN
1741: oe_debug_pub.add('Inserting history records for order number => '||oe_pc_attr_tbl(i).order_number,1);
1742:
1743: END IF;
1744: BEGIN -- 16447475
1745: INSERT INTO OE_AUDIT_ATTR_HISTORY

Line 1783: OE_DEBUG_PUB.add(' In EXCEPTION : After Insert in OE_AUDIT_ATTR_HISTORY ', 5);

1779: oe_pc_attr_tbl(I).old_context_value, --Bug4324371
1780: oe_pc_attr_tbl(I).new_context_Value );
1781: -- 16447475 start
1782: EXCEPTION WHEN OTHERS THEN
1783: OE_DEBUG_PUB.add(' In EXCEPTION : After Insert in OE_AUDIT_ATTR_HISTORY ', 5);
1784: oe_pc_attr_tbl.delete(i);
1785: IF l_debug_level > 0 THEN
1786: oe_debug_pub.add(' In EXCEPTION : SQL stmt => '||l_sql_stmt,1);
1787: oe_debug_pub.add(' In EXCEPTION : SQL stmt last => '||l_sql_stmt_last,1);

Line 1786: oe_debug_pub.add(' In EXCEPTION : SQL stmt => '||l_sql_stmt,1);

1782: EXCEPTION WHEN OTHERS THEN
1783: OE_DEBUG_PUB.add(' In EXCEPTION : After Insert in OE_AUDIT_ATTR_HISTORY ', 5);
1784: oe_pc_attr_tbl.delete(i);
1785: IF l_debug_level > 0 THEN
1786: oe_debug_pub.add(' In EXCEPTION : SQL stmt => '||l_sql_stmt,1);
1787: oe_debug_pub.add(' In EXCEPTION : SQL stmt last => '||l_sql_stmt_last,1);
1788: oe_debug_pub.add(' In EXCEPTION : SQL stmt txn => '||l_sql_stmt_txn,1);
1789: oe_debug_pub.add(' In EXCEPTION : Error => '||sqlerrm,1);
1790: END IF;

Line 1787: oe_debug_pub.add(' In EXCEPTION : SQL stmt last => '||l_sql_stmt_last,1);

1783: OE_DEBUG_PUB.add(' In EXCEPTION : After Insert in OE_AUDIT_ATTR_HISTORY ', 5);
1784: oe_pc_attr_tbl.delete(i);
1785: IF l_debug_level > 0 THEN
1786: oe_debug_pub.add(' In EXCEPTION : SQL stmt => '||l_sql_stmt,1);
1787: oe_debug_pub.add(' In EXCEPTION : SQL stmt last => '||l_sql_stmt_last,1);
1788: oe_debug_pub.add(' In EXCEPTION : SQL stmt txn => '||l_sql_stmt_txn,1);
1789: oe_debug_pub.add(' In EXCEPTION : Error => '||sqlerrm,1);
1790: END IF;
1791: END;

Line 1788: oe_debug_pub.add(' In EXCEPTION : SQL stmt txn => '||l_sql_stmt_txn,1);

1784: oe_pc_attr_tbl.delete(i);
1785: IF l_debug_level > 0 THEN
1786: oe_debug_pub.add(' In EXCEPTION : SQL stmt => '||l_sql_stmt,1);
1787: oe_debug_pub.add(' In EXCEPTION : SQL stmt last => '||l_sql_stmt_last,1);
1788: oe_debug_pub.add(' In EXCEPTION : SQL stmt txn => '||l_sql_stmt_txn,1);
1789: oe_debug_pub.add(' In EXCEPTION : Error => '||sqlerrm,1);
1790: END IF;
1791: END;
1792: -- 16447475 end

Line 1789: oe_debug_pub.add(' In EXCEPTION : Error => '||sqlerrm,1);

1785: IF l_debug_level > 0 THEN
1786: oe_debug_pub.add(' In EXCEPTION : SQL stmt => '||l_sql_stmt,1);
1787: oe_debug_pub.add(' In EXCEPTION : SQL stmt last => '||l_sql_stmt_last,1);
1788: oe_debug_pub.add(' In EXCEPTION : SQL stmt txn => '||l_sql_stmt_txn,1);
1789: oe_debug_pub.add(' In EXCEPTION : Error => '||sqlerrm,1);
1790: END IF;
1791: END;
1792: -- 16447475 end
1793: END IF;

Line 1798: OE_DEBUG_PUB.add(' ramising: Doing COMMIT....',5 ) ;

1794: END LOOP;
1795: oe_pc_attr_tbl.delete;
1796:
1797: COMMIT;
1798: OE_DEBUG_PUB.add(' ramising: Doing COMMIT....',5 ) ;
1799:
1800: EXCEPTION WHEN OTHERS THEN
1801: OE_DEBUG_PUB.add(' In EXCEPTION : deleting oe_pc_attr_tbl ', 5);
1802: oe_pc_attr_tbl.delete; -- bug# 9067627 : Delete these tables when above INSERT encounters some error(s)

Line 1801: OE_DEBUG_PUB.add(' In EXCEPTION : deleting oe_pc_attr_tbl ', 5);

1797: COMMIT;
1798: OE_DEBUG_PUB.add(' ramising: Doing COMMIT....',5 ) ;
1799:
1800: EXCEPTION WHEN OTHERS THEN
1801: OE_DEBUG_PUB.add(' In EXCEPTION : deleting oe_pc_attr_tbl ', 5);
1802: oe_pc_attr_tbl.delete; -- bug# 9067627 : Delete these tables when above INSERT encounters some error(s)
1803: -- e.g. => ORA-00001: unique constraint (ONT.OE_AUDIT_ATTR_HISTORY_U1) violated
1804:
1805: IF l_debug_level > 0 THEN

Line 1806: oe_debug_pub.add(' In EXCEPTION : SQL stmt => '||l_sql_stmt,1);

1802: oe_pc_attr_tbl.delete; -- bug# 9067627 : Delete these tables when above INSERT encounters some error(s)
1803: -- e.g. => ORA-00001: unique constraint (ONT.OE_AUDIT_ATTR_HISTORY_U1) violated
1804:
1805: IF l_debug_level > 0 THEN
1806: oe_debug_pub.add(' In EXCEPTION : SQL stmt => '||l_sql_stmt,1);
1807: oe_debug_pub.add(' In EXCEPTION : SQL stmt last => '||l_sql_stmt_last,1);
1808: oe_debug_pub.add(' In EXCEPTION : SQL stmt txn => '||l_sql_stmt_txn,1);
1809: oe_debug_pub.add(' In EXCEPTION : Error => '||sqlerrm,1);
1810: END IF;

Line 1807: oe_debug_pub.add(' In EXCEPTION : SQL stmt last => '||l_sql_stmt_last,1);

1803: -- e.g. => ORA-00001: unique constraint (ONT.OE_AUDIT_ATTR_HISTORY_U1) violated
1804:
1805: IF l_debug_level > 0 THEN
1806: oe_debug_pub.add(' In EXCEPTION : SQL stmt => '||l_sql_stmt,1);
1807: oe_debug_pub.add(' In EXCEPTION : SQL stmt last => '||l_sql_stmt_last,1);
1808: oe_debug_pub.add(' In EXCEPTION : SQL stmt txn => '||l_sql_stmt_txn,1);
1809: oe_debug_pub.add(' In EXCEPTION : Error => '||sqlerrm,1);
1810: END IF;
1811: END;

Line 1808: oe_debug_pub.add(' In EXCEPTION : SQL stmt txn => '||l_sql_stmt_txn,1);

1804:
1805: IF l_debug_level > 0 THEN
1806: oe_debug_pub.add(' In EXCEPTION : SQL stmt => '||l_sql_stmt,1);
1807: oe_debug_pub.add(' In EXCEPTION : SQL stmt last => '||l_sql_stmt_last,1);
1808: oe_debug_pub.add(' In EXCEPTION : SQL stmt txn => '||l_sql_stmt_txn,1);
1809: oe_debug_pub.add(' In EXCEPTION : Error => '||sqlerrm,1);
1810: END IF;
1811: END;
1812: END LOOP; /* Attr cursor */

Line 1809: oe_debug_pub.add(' In EXCEPTION : Error => '||sqlerrm,1);

1805: IF l_debug_level > 0 THEN
1806: oe_debug_pub.add(' In EXCEPTION : SQL stmt => '||l_sql_stmt,1);
1807: oe_debug_pub.add(' In EXCEPTION : SQL stmt last => '||l_sql_stmt_last,1);
1808: oe_debug_pub.add(' In EXCEPTION : SQL stmt txn => '||l_sql_stmt_txn,1);
1809: oe_debug_pub.add(' In EXCEPTION : Error => '||sqlerrm,1);
1810: END IF;
1811: END;
1812: END LOOP; /* Attr cursor */
1813: END LOOP;

Line 1819: oe_debug_pub.add('Exit audit history consolidator program..',1);

1815: null;
1816:
1817: END LOOP; /* entity cursor */
1818: IF l_debug_level > 0 THEN
1819: oe_debug_pub.add('Exit audit history consolidator program..',1);
1820: END IF;
1821: EXCEPTION WHEN OTHERS THEN
1822: IF l_debug_level > 0 THEN
1823: oe_debug_pub.add('Exiting with error '||sqlerrm,1);

Line 1823: oe_debug_pub.add('Exiting with error '||sqlerrm,1);

1819: oe_debug_pub.add('Exit audit history consolidator program..',1);
1820: END IF;
1821: EXCEPTION WHEN OTHERS THEN
1822: IF l_debug_level > 0 THEN
1823: oe_debug_pub.add('Exiting with error '||sqlerrm,1);
1824: END IF;
1825: retcode := 2;
1826: errbuf := sqlerrm;
1827: END set_attribute_history;

Line 2037: OE_DEBUG_PUB.add('Unable to get column label : '||sqlerrm,1);

2033: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = p_old_context_value;
2034:
2035: RETURN p_column_label;
2036: EXCEPTION WHEN OTHERS THEN
2037: OE_DEBUG_PUB.add('Unable to get column label : '||sqlerrm,1);
2038: RETURN NULL;
2039: END;
2040: WHEN OTHERS THEN
2041: OE_DEBUG_PUB.add('Unable to get column label : '||sqlerrm,1);

Line 2041: OE_DEBUG_PUB.add('Unable to get column label : '||sqlerrm,1);

2037: OE_DEBUG_PUB.add('Unable to get column label : '||sqlerrm,1);
2038: RETURN NULL;
2039: END;
2040: WHEN OTHERS THEN
2041: OE_DEBUG_PUB.add('Unable to get column label : '||sqlerrm,1);
2042: RETURN NULL;
2043: END Get_Column_Label;
2044:
2045: FUNCTION Get_translated_value(p_flexfield_name IN varchar2,

Line 2075: OE_DEBUG_PUB.add('Error when getting translated value : '||sqlerrm,1);

2071: RETURN p_column_translated_value;
2072: END IF;
2073:
2074: EXCEPTION WHEN OTHERS THEN
2075: OE_DEBUG_PUB.add('Error when getting translated value : '||sqlerrm,1);
2076: RETURN p_column_value;
2077: END Get_Translated_Value;
2078:
2079: -- ==========================================================================

Line 2147: oe_debug_pub.add('select stmt'||v_selectstmt);

2143: ELSE
2144: v_cols := v_cols || ', NULL ';
2145: END IF;
2146: v_selectstmt := 'SELECT '||v_cols||' FROM '||p_table_r.table_name||' '||v_where_clause;
2147: oe_debug_pub.add('select stmt'||v_selectstmt);
2148: -- parse the query
2149: DBMS_SQL.PARSE(v_cursor_id,v_selectstmt,DBMS_SQL.V7);
2150: -- Bind the input variables
2151: DBMS_SQL.DEFINE_COLUMN(v_cursor_id,1,v_value,150);

Line 2175: oe_debug_pub.add('value does notmatch, continue search'||p_value||','||v_id);

2171: x_value := v_value;
2172: RETURN TRUE;
2173: ELSE
2174: Null;
2175: oe_debug_pub.add('value does notmatch, continue search'||p_value||','||v_id);
2176: END IF;
2177: END LOOP;
2178: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);
2179: RETURN FALSE;

Line 2182: oe_debug_pub.add('value_exists_in_table exception');

2178: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);
2179: RETURN FALSE;
2180: EXCEPTION
2181: WHEN OTHERS THEN
2182: oe_debug_pub.add('value_exists_in_table exception');
2183: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);
2184: RETURN FALSE;
2185: END value_exists_in_table;
2186:

Line 2216: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

2212:
2213: type refcur is ref cursor;
2214: ref_attr REFCUR;
2215: --
2216: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2217: --
2218:
2219: BEGIN
2220:

Line 2222: oe_debug_pub.add('Entering Comparing_Credit_Card for attribute_id: '||p_attribute_id, 1);

2218:
2219: BEGIN
2220:
2221: IF l_debug_level > 0 THEN
2222: oe_debug_pub.add('Entering Comparing_Credit_Card for attribute_id: '||p_attribute_id, 1);
2223: END IF;
2224:
2225: IF l_debug_level > 0 THEN
2226: oe_debug_pub.add('p_old_hist_creation_date is: '||p_old_hist_creation_date, 3);

Line 2226: oe_debug_pub.add('p_old_hist_creation_date is: '||p_old_hist_creation_date, 3);

2222: oe_debug_pub.add('Entering Comparing_Credit_Card for attribute_id: '||p_attribute_id, 1);
2223: END IF;
2224:
2225: IF l_debug_level > 0 THEN
2226: oe_debug_pub.add('p_old_hist_creation_date is: '||p_old_hist_creation_date, 3);
2227: oe_debug_pub.add('p_new_hist_creation_date is: '||p_new_hist_creation_date, 3);
2228: END IF;
2229:
2230:

Line 2227: oe_debug_pub.add('p_new_hist_creation_date is: '||p_new_hist_creation_date, 3);

2223: END IF;
2224:
2225: IF l_debug_level > 0 THEN
2226: oe_debug_pub.add('p_old_hist_creation_date is: '||p_old_hist_creation_date, 3);
2227: oe_debug_pub.add('p_new_hist_creation_date is: '||p_new_hist_creation_date, 3);
2228: END IF;
2229:
2230:
2231: BEGIN

Line 2304: oe_debug_pub.add('x_card_number_equal is: '||x_card_number_equal, 3);

2300:
2301: END IF;
2302:
2303: IF l_debug_level > 0 THEN
2304: oe_debug_pub.add('x_card_number_equal is: '||x_card_number_equal, 3);
2305: END IF;
2306:
2307: IF p_attribute_id = 46 THEN
2308: l_column_name := 'CARD_ISSUER_CODE';

Line 2318: --oe_debug_pub.add('l_old_cc_code is: '||l_old_cc_code, 3);

2314: l_column_name := 'MASKED_CC_NUMBER';
2315: END IF;
2316:
2317: --IF l_debug_level > 0 THEN
2318: --oe_debug_pub.add('l_old_cc_code is: '||l_old_cc_code, 3);
2319: --oe_debug_pub.add('l_new_cc_code is: '||l_new_cc_code, 3);
2320: --oe_debug_pub.add('l_old_cc_number is: '||l_old_cc_number, 3);
2321: --oe_debug_pub.add('l_new_cc_number is: '||l_new_cc_number, 3);
2322: --END IF;

Line 2319: --oe_debug_pub.add('l_new_cc_code is: '||l_new_cc_code, 3);

2315: END IF;
2316:
2317: --IF l_debug_level > 0 THEN
2318: --oe_debug_pub.add('l_old_cc_code is: '||l_old_cc_code, 3);
2319: --oe_debug_pub.add('l_new_cc_code is: '||l_new_cc_code, 3);
2320: --oe_debug_pub.add('l_old_cc_number is: '||l_old_cc_number, 3);
2321: --oe_debug_pub.add('l_new_cc_number is: '||l_new_cc_number, 3);
2322: --END IF;
2323:

Line 2320: --oe_debug_pub.add('l_old_cc_number is: '||l_old_cc_number, 3);

2316:
2317: --IF l_debug_level > 0 THEN
2318: --oe_debug_pub.add('l_old_cc_code is: '||l_old_cc_code, 3);
2319: --oe_debug_pub.add('l_new_cc_code is: '||l_new_cc_code, 3);
2320: --oe_debug_pub.add('l_old_cc_number is: '||l_old_cc_number, 3);
2321: --oe_debug_pub.add('l_new_cc_number is: '||l_new_cc_number, 3);
2322: --END IF;
2323:
2324: --get old and new attribute values for credit card number and credit card code.

Line 2321: --oe_debug_pub.add('l_new_cc_number is: '||l_new_cc_number, 3);

2317: --IF l_debug_level > 0 THEN
2318: --oe_debug_pub.add('l_old_cc_code is: '||l_old_cc_code, 3);
2319: --oe_debug_pub.add('l_new_cc_code is: '||l_new_cc_code, 3);
2320: --oe_debug_pub.add('l_old_cc_number is: '||l_old_cc_number, 3);
2321: --oe_debug_pub.add('l_new_cc_number is: '||l_new_cc_number, 3);
2322: --END IF;
2323:
2324: --get old and new attribute values for credit card number and credit card code.
2325: -- instrument_id stores the instrument_id

Line 2384: oe_debug_pub.add('x_old_attribute_value is: '||x_old_attribute_value, 3);

2380:
2381: END IF;
2382:
2383: IF l_debug_level > 0 THEN
2384: oe_debug_pub.add('x_old_attribute_value is: '||x_old_attribute_value, 3);
2385: oe_debug_pub.add('x_new_attribute_value is: '||x_new_attribute_value, 3);
2386: END IF;
2387:
2388: IF l_debug_level > 0 THEN

Line 2385: oe_debug_pub.add('x_new_attribute_value is: '||x_new_attribute_value, 3);

2381: END IF;
2382:
2383: IF l_debug_level > 0 THEN
2384: oe_debug_pub.add('x_old_attribute_value is: '||x_old_attribute_value, 3);
2385: oe_debug_pub.add('x_new_attribute_value is: '||x_new_attribute_value, 3);
2386: END IF;
2387:
2388: IF l_debug_level > 0 THEN
2389: oe_debug_pub.add('Exiting Comparing_Credit_Card. ', 1);

Line 2389: oe_debug_pub.add('Exiting Comparing_Credit_Card. ', 1);

2385: oe_debug_pub.add('x_new_attribute_value is: '||x_new_attribute_value, 3);
2386: END IF;
2387:
2388: IF l_debug_level > 0 THEN
2389: oe_debug_pub.add('Exiting Comparing_Credit_Card. ', 1);
2390: END IF;
2391:
2392: END Compare_Credit_Card;
2393:

Line 2482: oe_debug_pub.add('Error in inserting data in sets history');

2478:
2479: EXCEPTION
2480: WHEN OTHERS THEN
2481: x_return_status :=FND_API.G_RET_STS_UNEXP_ERROR;
2482: oe_debug_pub.add('Error in inserting data in sets history');
2483: end;
2484:
2485: --Added for bug5631508
2486: PROCEDURE DELETE_SET_HISTORY(

Line 2496: oe_debug_pub.add('Error in Deleting data from sets history');

2492:
2493: x_return_status := FND_API.G_RET_STS_SUCCESS;
2494: exception
2495: WHEN OTHERS THEN
2496: oe_debug_pub.add('Error in Deleting data from sets history');
2497: x_return_status :=FND_API.G_RET_STS_UNEXP_ERROR;
2498: end;
2499:
2500: