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 13: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

9: l_attribute_code varchar2(80);
10: l_attribute_display_value varchar2(2000);
11: l_display_name varchar2(500);
12: --
13: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
14: --
15: BEGIN
16:
17: BEGIN

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

430: l_last_instrument_id NUMBER;
431: l_instr_flag VARCHAR2(1);
432:
433: --
434: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
435: --
436:
437: BEGIN
438:

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

436:
437: BEGIN
438:
439: IF l_debug_level > 0 THEN
440: oe_debug_pub.add('Enter audit history consolidate program',1);
441: END IF;
442:
443: --Added for MOAC
444: If l_input_org_id IS NOT NULL THEN

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

521: max_hist_creation_date := sysdate;
522: end if;
523:
524: IF l_debug_level > 0 THEN
525: oe_debug_pub.add('History start date => '||to_char(min_hist_creation_date,'dd-mon-yyyy hh24:mi:ss'),1);
526: oe_debug_pub.add('History end date => '||to_char(max_hist_creation_date,'dd-mon-yyyy hh24:mi:ss'),1);
527: END IF;
528:
529: FOR c_ent_rec in c_entities

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

522: end if;
523:
524: IF l_debug_level > 0 THEN
525: oe_debug_pub.add('History start date => '||to_char(min_hist_creation_date,'dd-mon-yyyy hh24:mi:ss'),1);
526: oe_debug_pub.add('History end date => '||to_char(max_hist_creation_date,'dd-mon-yyyy hh24:mi:ss'),1);
527: END IF;
528:
529: FOR c_ent_rec in c_entities
530: LOOP

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

529: FOR c_ent_rec in c_entities
530: LOOP
531:
532: IF l_debug_level > 0 THEN
533: oe_debug_pub.add('Consolidating history records for entity '||to_char(c_ent_rec.entity_id),1);
534: END IF;
535:
536: /* Check whether history records exist for this entity in the date range */
537: l_cnt_stmt := 'select count(*) from ' || c_ent_rec.entity_name || ' where trunc(hist_creation_date) between :x and :z and ';

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

598: CLOSE ref_attr;
599:
600: if l_count=0 then
601: IF l_debug_level > 0 THEN
602: oe_debug_pub.add('NO matching history records in this date range for entity '||to_char(c_ent_rec.entity_id),1);
603: END IF;
604: goto End_Of_Entity;
605: end if;
606:

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

612:
613: v_attr_index:=1;
614: IF v_entity_constrained = 'Y' THEN
615: IF l_debug_level > 0 THEN
616: OE_DEBUG_PUB.add('Consolidating for all attributes',1);
617: END IF;
618: FOR c_attr_rec IN c_all_attributes(c_ent_rec.entity_id) LOOP
619: c_attr_tbl(v_attr_index).entity_id := c_ent_rec.entity_id;
620: c_attr_tbl(v_attr_index).attribute_id := c_attr_rec.attribute_id;

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

624: v_attr_index := v_attr_index+1;
625: END LOOP;
626: ELSE
627: IF l_debug_level > 0 THEN
628: OE_DEBUG_PUB.add('Consolidating for currently constrained attributes only',1);
629: END IF;
630:
631: FOR c_attr_rec IN c_const_attributes(c_ent_rec.entity_id) LOOP
632: c_attr_tbl(v_attr_index).entity_id := c_ent_rec.entity_id;

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

675:
676: l_ent_stmt_subquery := l_ent_stmt_subquery || ' and nvl(audit_flag, ''Y'') = ''Y'' ';
677:
678: IF l_debug_level > 0 THEN
679: oe_debug_pub.add('For entity id ' || c_ent_rec.entity_id || ' Constructed subquery entity statement: ' || l_ent_stmt_subquery);
680: END IF;
681: -- end bug 4394119
682:
683: if (c_ent_rec.entity_id = 1) then

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

777: WHERE HEADER_ID = l_header_id;
778:
779: EXCEPTION WHEN OTHERS THEN
780: IF l_debug_level > 0 THEN
781: oe_debug_pub.add('Unable to locate header record for header ID : '||l_header_id||' ERROR: '||SQLERRM , 1 ) ;
782: END IF;
783: END;
784:
785: FOR J in 1..c_attr_tbl.count LOOP

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

901: || l_ent_stmt;
902: END IF;
903: ELSE
904: IF l_debug_level > 0 THEN
905: oe_debug_pub.add('Entity id not recognized '||c_ent_rec.entity_id,1);
906: END IF;
907: END IF;
908:
909: BEGIN

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

1072: END IF;
1073: END IF;
1074:
1075: IF l_debug_level > 0 THEN
1076: oe_debug_pub.add('column name is: '||c_attr_tbl(j).column_name, 5);
1077: END IF;
1078:
1079: if (c_ent_rec.entity_id = 1) then
1080: if c_attr_tbl(j).attribute_id in (46, 47, 48,49) then

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

1184:
1185: END IF;
1186: ELSIF (l_count_last > 1) then
1187: IF l_debug_level > 0 THEN
1188: oe_debug_pub.add('Executing subquery: ' || l_ent_stmt_subquery);
1189: 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);
1190: END IF;
1191: IF (c_ent_rec.entity_id in (6,8)) THEN
1192: l_sql_stmt_last :=

Line 1189: 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);

1185: END IF;
1186: ELSIF (l_count_last > 1) then
1187: IF l_debug_level > 0 THEN
1188: oe_debug_pub.add('Executing subquery: ' || l_ent_stmt_subquery);
1189: 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);
1190: END IF;
1191: IF (c_ent_rec.entity_id in (6,8)) THEN
1192: l_sql_stmt_last :=
1193: 'select hist_creation_date, nvl(oer.reason_code, hist.change_reason_code), '

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

1293: goto next_attribute;
1294: END IF;
1295:
1296: IF l_debug_level > 0 THEN
1297: oe_debug_pub.add('old date is '||to_char(l_hist_creation_date ,'HH24:MI:SS DD-MON-YYYY'),1);
1298: oe_debug_pub.add('new date is '||to_char(l_hist_creation_date_last ,'HH24:MI:SS DD-MON-YYYY'),1);
1299: oe_debug_pub.add('old value is '||l_attribute_value ,1);
1300: oe_debug_pub.add('new value is '||l_attribute_value_last,1);
1301: END IF;

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

1294: END IF;
1295:
1296: IF l_debug_level > 0 THEN
1297: oe_debug_pub.add('old date is '||to_char(l_hist_creation_date ,'HH24:MI:SS DD-MON-YYYY'),1);
1298: oe_debug_pub.add('new date is '||to_char(l_hist_creation_date_last ,'HH24:MI:SS DD-MON-YYYY'),1);
1299: oe_debug_pub.add('old value is '||l_attribute_value ,1);
1300: oe_debug_pub.add('new value is '||l_attribute_value_last,1);
1301: END IF;
1302:

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

1295:
1296: IF l_debug_level > 0 THEN
1297: oe_debug_pub.add('old date is '||to_char(l_hist_creation_date ,'HH24:MI:SS DD-MON-YYYY'),1);
1298: oe_debug_pub.add('new date is '||to_char(l_hist_creation_date_last ,'HH24:MI:SS DD-MON-YYYY'),1);
1299: oe_debug_pub.add('old value is '||l_attribute_value ,1);
1300: oe_debug_pub.add('new value is '||l_attribute_value_last,1);
1301: END IF;
1302:
1303: ELSIF c_attr_tbl(j).attribute_id IN (46,47,48, 49) AND l_count_last = 0 THEN

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

1296: IF l_debug_level > 0 THEN
1297: oe_debug_pub.add('old date is '||to_char(l_hist_creation_date ,'HH24:MI:SS DD-MON-YYYY'),1);
1298: oe_debug_pub.add('new date is '||to_char(l_hist_creation_date_last ,'HH24:MI:SS DD-MON-YYYY'),1);
1299: oe_debug_pub.add('old value is '||l_attribute_value ,1);
1300: oe_debug_pub.add('new value is '||l_attribute_value_last,1);
1301: END IF;
1302:
1303: ELSIF c_attr_tbl(j).attribute_id IN (46,47,48, 49) AND l_count_last = 0 THEN
1304: -- compare the card number between the last record and the one

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

1353:
1354: -- end R12 cc encryption
1355:
1356: IF l_debug_level > 0 THEN
1357: oe_debug_pub.add('Found history records for order => '||l_order_number,1);
1358: END IF;
1359:
1360: oe_pc_attr_tbl(l_rec_counter).old_attribute_value := l_attribute_value;
1361: oe_pc_attr_tbl(l_rec_counter).new_attribute_value := l_attribute_value_last;

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

1385: FOR I in 1..oe_pc_attr_tbl.count LOOP
1386: IF (oe_pc_attr_tbl(I).old_attribute_value is not null OR
1387: oe_pc_attr_tbl(I).new_attribute_value is not null) THEN
1388: IF l_debug_level > 0 THEN
1389: oe_debug_pub.add('Inserting history records for order number => '||oe_pc_attr_tbl(i).order_number,1);
1390:
1391: END IF;
1392: INSERT INTO OE_AUDIT_ATTR_HISTORY
1393: (entity_id,

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

1431:
1432: COMMIT;
1433: EXCEPTION WHEN OTHERS THEN
1434: IF l_debug_level > 0 THEN
1435: oe_debug_pub.add('SQL stmt => '||l_sql_stmt,1);
1436: oe_debug_pub.add('SQL stmt last => '||l_sql_stmt_last,1);
1437: oe_debug_pub.add('SQL stmt txn => '||l_sql_stmt_txn,1);
1438: oe_debug_pub.add('Error => '||sqlerrm,1);
1439: END IF;

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

1432: COMMIT;
1433: EXCEPTION WHEN OTHERS THEN
1434: IF l_debug_level > 0 THEN
1435: oe_debug_pub.add('SQL stmt => '||l_sql_stmt,1);
1436: oe_debug_pub.add('SQL stmt last => '||l_sql_stmt_last,1);
1437: oe_debug_pub.add('SQL stmt txn => '||l_sql_stmt_txn,1);
1438: oe_debug_pub.add('Error => '||sqlerrm,1);
1439: END IF;
1440: END;

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

1433: EXCEPTION WHEN OTHERS THEN
1434: IF l_debug_level > 0 THEN
1435: oe_debug_pub.add('SQL stmt => '||l_sql_stmt,1);
1436: oe_debug_pub.add('SQL stmt last => '||l_sql_stmt_last,1);
1437: oe_debug_pub.add('SQL stmt txn => '||l_sql_stmt_txn,1);
1438: oe_debug_pub.add('Error => '||sqlerrm,1);
1439: END IF;
1440: END;
1441: END LOOP; /* Attr cursor */

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

1434: IF l_debug_level > 0 THEN
1435: oe_debug_pub.add('SQL stmt => '||l_sql_stmt,1);
1436: oe_debug_pub.add('SQL stmt last => '||l_sql_stmt_last,1);
1437: oe_debug_pub.add('SQL stmt txn => '||l_sql_stmt_txn,1);
1438: oe_debug_pub.add('Error => '||sqlerrm,1);
1439: END IF;
1440: END;
1441: END LOOP; /* Attr cursor */
1442: END LOOP;

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

1444: null;
1445:
1446: END LOOP; /* entity cursor */
1447: IF l_debug_level > 0 THEN
1448: oe_debug_pub.add('Exit audit history consolidator program..',1);
1449: END IF;
1450: EXCEPTION WHEN OTHERS THEN
1451: IF l_debug_level > 0 THEN
1452: oe_debug_pub.add('Exiting with error '||sqlerrm,1);

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

1448: oe_debug_pub.add('Exit audit history consolidator program..',1);
1449: END IF;
1450: EXCEPTION WHEN OTHERS THEN
1451: IF l_debug_level > 0 THEN
1452: oe_debug_pub.add('Exiting with error '||sqlerrm,1);
1453: END IF;
1454: retcode := 2;
1455: errbuf := sqlerrm;
1456: END set_attribute_history;

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

1662: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = p_old_context_value;
1663:
1664: RETURN p_column_label;
1665: EXCEPTION WHEN OTHERS THEN
1666: OE_DEBUG_PUB.add('Unable to get column label : '||sqlerrm,1);
1667: RETURN NULL;
1668: END;
1669: WHEN OTHERS THEN
1670: OE_DEBUG_PUB.add('Unable to get column label : '||sqlerrm,1);

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

1666: OE_DEBUG_PUB.add('Unable to get column label : '||sqlerrm,1);
1667: RETURN NULL;
1668: END;
1669: WHEN OTHERS THEN
1670: OE_DEBUG_PUB.add('Unable to get column label : '||sqlerrm,1);
1671: RETURN NULL;
1672: END Get_Column_Label;
1673:
1674: FUNCTION Get_translated_value(p_flexfield_name IN varchar2,

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

1700: RETURN p_column_translated_value;
1701: END IF;
1702:
1703: EXCEPTION WHEN OTHERS THEN
1704: OE_DEBUG_PUB.add('Error when getting translated value : '||sqlerrm,1);
1705: RETURN p_column_value;
1706: END Get_Translated_Value;
1707:
1708: -- ==========================================================================

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

1772: ELSE
1773: v_cols := v_cols || ', NULL ';
1774: END IF;
1775: v_selectstmt := 'SELECT '||v_cols||' FROM '||p_table_r.table_name||' '||v_where_clause;
1776: oe_debug_pub.add('select stmt'||v_selectstmt);
1777: -- parse the query
1778: DBMS_SQL.PARSE(v_cursor_id,v_selectstmt,DBMS_SQL.V7);
1779: -- Bind the input variables
1780: DBMS_SQL.DEFINE_COLUMN(v_cursor_id,1,v_value,150);

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

1800: x_value := v_value;
1801: RETURN TRUE;
1802: ELSE
1803: Null;
1804: oe_debug_pub.add('value does notmatch, continue search'||p_value||','||v_id);
1805: END IF;
1806: END LOOP;
1807: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);
1808: RETURN FALSE;

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

1807: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);
1808: RETURN FALSE;
1809: EXCEPTION
1810: WHEN OTHERS THEN
1811: oe_debug_pub.add('value_exists_in_table exception');
1812: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);
1813: RETURN FALSE;
1814: END value_exists_in_table;
1815:

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

1841:
1842: type refcur is ref cursor;
1843: ref_attr REFCUR;
1844: --
1845: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1846: --
1847:
1848: BEGIN
1849:

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

1847:
1848: BEGIN
1849:
1850: IF l_debug_level > 0 THEN
1851: oe_debug_pub.add('Entering Comparing_Credit_Card for attribute_id: '||p_attribute_id, 1);
1852: END IF;
1853:
1854: IF l_debug_level > 0 THEN
1855: oe_debug_pub.add('p_old_hist_creation_date is: '||p_old_hist_creation_date, 3);

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

1851: oe_debug_pub.add('Entering Comparing_Credit_Card for attribute_id: '||p_attribute_id, 1);
1852: END IF;
1853:
1854: IF l_debug_level > 0 THEN
1855: oe_debug_pub.add('p_old_hist_creation_date is: '||p_old_hist_creation_date, 3);
1856: oe_debug_pub.add('p_new_hist_creation_date is: '||p_new_hist_creation_date, 3);
1857: END IF;
1858:
1859:

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

1852: END IF;
1853:
1854: IF l_debug_level > 0 THEN
1855: oe_debug_pub.add('p_old_hist_creation_date is: '||p_old_hist_creation_date, 3);
1856: oe_debug_pub.add('p_new_hist_creation_date is: '||p_new_hist_creation_date, 3);
1857: END IF;
1858:
1859:
1860: BEGIN

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

1929:
1930: END IF;
1931:
1932: IF l_debug_level > 0 THEN
1933: oe_debug_pub.add('x_card_number_equal is: '||x_card_number_equal, 3);
1934: END IF;
1935:
1936: IF p_attribute_id = 46 THEN
1937: l_column_name := 'CARD_ISSUER_CODE';

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

1943: l_column_name := 'MASKED_CC_NUMBER';
1944: END IF;
1945:
1946: IF l_debug_level > 0 THEN
1947: oe_debug_pub.add('l_old_cc_code is: '||l_old_cc_code, 3);
1948: oe_debug_pub.add('l_new_cc_code is: '||l_new_cc_code, 3);
1949: oe_debug_pub.add('l_old_cc_number is: '||l_old_cc_number, 3);
1950: oe_debug_pub.add('l_new_cc_number is: '||l_new_cc_number, 3);
1951: END IF;

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

1944: END IF;
1945:
1946: IF l_debug_level > 0 THEN
1947: oe_debug_pub.add('l_old_cc_code is: '||l_old_cc_code, 3);
1948: oe_debug_pub.add('l_new_cc_code is: '||l_new_cc_code, 3);
1949: oe_debug_pub.add('l_old_cc_number is: '||l_old_cc_number, 3);
1950: oe_debug_pub.add('l_new_cc_number is: '||l_new_cc_number, 3);
1951: END IF;
1952:

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

1945:
1946: IF l_debug_level > 0 THEN
1947: oe_debug_pub.add('l_old_cc_code is: '||l_old_cc_code, 3);
1948: oe_debug_pub.add('l_new_cc_code is: '||l_new_cc_code, 3);
1949: oe_debug_pub.add('l_old_cc_number is: '||l_old_cc_number, 3);
1950: oe_debug_pub.add('l_new_cc_number is: '||l_new_cc_number, 3);
1951: END IF;
1952:
1953: --get old and new attribute values for credit card number and credit card code.

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

1946: IF l_debug_level > 0 THEN
1947: oe_debug_pub.add('l_old_cc_code is: '||l_old_cc_code, 3);
1948: oe_debug_pub.add('l_new_cc_code is: '||l_new_cc_code, 3);
1949: oe_debug_pub.add('l_old_cc_number is: '||l_old_cc_number, 3);
1950: oe_debug_pub.add('l_new_cc_number is: '||l_new_cc_number, 3);
1951: END IF;
1952:
1953: --get old and new attribute values for credit card number and credit card code.
1954: -- instrument_id stores the instrument_id

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

2009:
2010: END IF;
2011:
2012: IF l_debug_level > 0 THEN
2013: oe_debug_pub.add('x_old_attribute_value is: '||x_old_attribute_value, 3);
2014: oe_debug_pub.add('x_new_attribute_value is: '||x_new_attribute_value, 3);
2015: END IF;
2016:
2017: IF l_debug_level > 0 THEN

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

2010: END IF;
2011:
2012: IF l_debug_level > 0 THEN
2013: oe_debug_pub.add('x_old_attribute_value is: '||x_old_attribute_value, 3);
2014: oe_debug_pub.add('x_new_attribute_value is: '||x_new_attribute_value, 3);
2015: END IF;
2016:
2017: IF l_debug_level > 0 THEN
2018: oe_debug_pub.add('Exiting Comparing_Credit_Card. ', 1);

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

2014: oe_debug_pub.add('x_new_attribute_value is: '||x_new_attribute_value, 3);
2015: END IF;
2016:
2017: IF l_debug_level > 0 THEN
2018: oe_debug_pub.add('Exiting Comparing_Credit_Card. ', 1);
2019: END IF;
2020:
2021: END Compare_Credit_Card;
2022:

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

2107:
2108: EXCEPTION
2109: WHEN OTHERS THEN
2110: x_return_status :=FND_API.G_RET_STS_UNEXP_ERROR;
2111: oe_debug_pub.add('Error in inserting data in sets history');
2112: end;
2113:
2114: --Added for bug5631508
2115: PROCEDURE DELETE_SET_HISTORY(

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

2121:
2122: x_return_status := FND_API.G_RET_STS_SUCCESS;
2123: exception
2124: WHEN OTHERS THEN
2125: oe_debug_pub.add('Error in Deleting data from sets history');
2126: x_return_status :=FND_API.G_RET_STS_UNEXP_ERROR;
2127: end;
2128:
2129: