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

Line 1580: oe_debug_pub.add('Found bind variable in where clause');

1576: --2. If there is a API call, validation has to be done before calling
1577: -- this function
1578: IF(p_table_r.where_clause IS NOT NULL
1579: AND INSTR(p_table_r.where_clause,':')>0) THEN
1580: oe_debug_pub.add('Found bind variable in where clause');
1581: oe_debug_pub.add('where clause:' || p_table_r.where_clause);
1582: RETURN true;
1583: END if;
1584: --end 8923075

Line 1581: oe_debug_pub.add('where clause:' || p_table_r.where_clause);

1577: -- this function
1578: IF(p_table_r.where_clause IS NOT NULL
1579: AND INSTR(p_table_r.where_clause,':')>0) THEN
1580: oe_debug_pub.add('Found bind variable in where clause');
1581: oe_debug_pub.add('where clause:' || p_table_r.where_clause);
1582: RETURN true;
1583: END if;
1584: --end 8923075
1585:

Line 1696: oe_debug_pub.add('select stmt1'||v_selectstmt);

1692:
1693:
1694: v_selectstmt := 'SELECT '||v_cols||' FROM '||p_table_r.table_name||' '||v_where_clause;
1695:
1696: oe_debug_pub.add('select stmt1'||v_selectstmt);
1697: ------------------
1698:
1699: /*
1700: IF p_table_r.id_column_name is not null then

Line 1731: oe_debug_pub.add('after parse1');

1727: /*
1728: -- parse the query
1729:
1730: DBMS_SQL.PARSE(v_cursor_id,v_selectstmt,DBMS_SQL.V7);
1731: oe_debug_pub.add('after parse1');
1732: -- Bind the input variables
1733: DBMS_SQL.DEFINE_COLUMN(v_cursor_id,1,v_value,150);
1734: DBMS_SQL.DEFINE_COLUMN(v_cursor_id,2,v_id,150);
1735: v_retval := DBMS_SQL.EXECUTE(v_cursor_id);

Line 1746: oe_debug_pub.add('id null, passing value'||p_value||','||v_value);

1742: DBMS_SQL.COLUMN_VALUE(v_cursor_id,1,v_value);
1743: DBMS_SQL.COLUMN_VALUE(v_cursor_id,2,v_id);
1744:
1745: IF v_id IS NULL AND (p_value = v_value) THEN
1746: oe_debug_pub.add('id null, passing value'||p_value||','||v_value);
1747: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);
1748: x_id := v_id;
1749: x_value := v_value;
1750: RETURN TRUE;

Line 1752: oe_debug_pub.add('id exists, passing id'||p_value||','||v_id);

1748: x_id := v_id;
1749: x_value := v_value;
1750: RETURN TRUE;
1751: ELSIF (p_value = v_id) THEN
1752: oe_debug_pub.add('id exists, passing id'||p_value||','||v_id);
1753: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);
1754: x_id := v_id;
1755: x_value := v_value;
1756: RETURN TRUE;

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

1755: x_value := v_value;
1756: RETURN TRUE;
1757: ELSE
1758: Null;
1759: oe_debug_pub.add('value does notmatch, continue search'||p_value||','||v_id);
1760: END IF;
1761: END LOOP;
1762: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);
1763: RETURN FALSE;

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

1763: RETURN FALSE;
1764: */
1765: EXCEPTION
1766: WHEN OTHERS THEN
1767: oe_debug_pub.add('value_exists_in_table exception');
1768: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);
1769: RETURN FALSE;
1770: END value_exists_in_table;
1771:

Line 3770: oe_debug_pub.add('Found bind variable in where clause,so truncating the where clause');

3766: --attached in where clause as this will be added in sql statement.
3767: --Further this will be exectued to get value_meaning
3768: IF(p_table_r.where_clause IS NOT NULL
3769: AND INSTR(p_table_r.where_clause,':')>0) THEN
3770: oe_debug_pub.add('Found bind variable in where clause,so truncating the where clause');
3771: oe_debug_pub.add('where clause:' || p_table_r.where_clause);
3772: v_where_clause := '';
3773: END if;
3774:

Line 3771: oe_debug_pub.add('where clause:' || p_table_r.where_clause);

3767: --Further this will be exectued to get value_meaning
3768: IF(p_table_r.where_clause IS NOT NULL
3769: AND INSTR(p_table_r.where_clause,':')>0) THEN
3770: oe_debug_pub.add('Found bind variable in where clause,so truncating the where clause');
3771: oe_debug_pub.add('where clause:' || p_table_r.where_clause);
3772: v_where_clause := '';
3773: END if;
3774:
3775: -- if instr(upper(p_table_r.where_clause),'WHERE ') > 0 then --Commented out for 2492020

Line 3875: oe_debug_pub.add('select stmt2'||v_selectstmt);

3871: end if;
3872:
3873: v_selectstmt := 'SELECT '||v_cols||' FROM '||p_table_r.table_name||' '||v_where_clause;
3874:
3875: oe_debug_pub.add('select stmt2'||v_selectstmt);
3876:
3877: ------------------
3878:
3879: /*

Line 3916: oe_debug_pub.add('after parse2');

3912: /*
3913: -- parse the query
3914:
3915: DBMS_SQL.PARSE(v_cursor_id,v_selectstmt,DBMS_SQL.V7);
3916: oe_debug_pub.add('after parse2');
3917: -- Bind the input variables
3918: DBMS_SQL.DEFINE_COLUMN(v_cursor_id,1,v_value,150);
3919: DBMS_SQL.DEFINE_COLUMN(v_cursor_id,2,v_id,150);
3920: if p_table_r.meaning_column_name IS NOT NULL THEN

Line 3939: oe_debug_pub.add('id null, passing value'||p_value||','||v_value||' '||v_meaning);

3935: end if;
3936:
3937:
3938: IF v_id IS NULL AND (p_value = v_value) THEN
3939: oe_debug_pub.add('id null, passing value'||p_value||','||v_value||' '||v_meaning);
3940: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);
3941: x_id := v_id;
3942: x_value := v_value;
3943: --added this to return meaning

Line 3947: oe_debug_pub.add('id exists, passing id'||p_value||','||v_id||' '||v_meaning);

3943: --added this to return meaning
3944: x_meaning := v_meaning;
3945: RETURN TRUE;
3946: ELSIF (p_value = v_id) THEN
3947: oe_debug_pub.add('id exists, passing id'||p_value||','||v_id||' '||v_meaning);
3948: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);
3949: x_id := v_id;
3950: x_value := v_value;
3951: --added this to return meaning

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

3956: end if;
3957: RETURN TRUE;
3958: ELSE
3959: Null;
3960: oe_debug_pub.add('value does notmatch, continue search'||p_value||','||v_id);
3961: END IF;
3962: END LOOP;
3963: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);
3964: RETURN FALSE;

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

3964: RETURN FALSE;
3965: */
3966: EXCEPTION
3967: WHEN OTHERS THEN
3968: oe_debug_pub.add('value_exists_in_table exception');
3969: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);
3970: RETURN FALSE;
3971: END value_exists_in_table;
3972:

Line 5008: oe_debug_pub.add('Start G_ORGANIZATION_ID = '||G_ORGANIZATION_ID);

5004: FUNCTION Get_Item_Validation_Org RETURN NUMBER IS
5005: l_application_id NUMBER;
5006: l_inv_org_id NUMBER;
5007: BEGIN
5008: oe_debug_pub.add('Start G_ORGANIZATION_ID = '||G_ORGANIZATION_ID);
5009: /*
5010: commenting this code R12 per ER 4756750 to move the profile-based
5011: approach for all calling app and come up with a pricing parameter
5012: for the item validation Org per the ER

Line 5015: oe_debug_pub.add('l_application_id = '||l_application_id);

5011: approach for all calling app and come up with a pricing parameter
5012: for the item validation Org per the ER
5013: l_application_id := fnd_global.resp_appl_id;
5014:
5015: oe_debug_pub.add('l_application_id = '||l_application_id);
5016: if l_application_id in (201, 178) then -- oracle purchasing/iProcurement
5017: SELECT inventory_organization_id
5018: INTO l_inv_org_id
5019: --fix for bug 4776045 for MOAC

Line 5024: oe_debug_pub.add('inv_org_id from financials_system_parameters = '||l_inv_org_id);

5020: --FROM financials_system_parameters;
5021: FROM FINANCIALS_SYSTEM_PARAMS_ALL
5022: where org_id = get_org_id;
5023:
5024: oe_debug_pub.add('inv_org_id from financials_system_parameters = '||l_inv_org_id);
5025: G_ORGANIZATION_ID := l_inv_org_id;
5026: end if;--application_id
5027: if G_ORGANIZATION_ID is null then --above query did not return a value
5028: --because MO Default OU was not set or FSP is not set revert to QP profile

Line 5033: oe_debug_pub.add('inv_org_id from profile QP_ORGANIZATION_ID = '||l_inv_org_id);

5029: */
5030: -- if G_ORGANIZATION_ID is null then
5031: l_inv_org_id := FND_PROFILE.Value('QP_ORGANIZATION_ID');
5032:
5033: oe_debug_pub.add('inv_org_id from profile QP_ORGANIZATION_ID = '||l_inv_org_id);
5034: IF G_ORGANIZATION_ID IS NULL THEN
5035: G_ORGANIZATION_ID := l_inv_org_id;
5036: -- end if;
5037: end if; --if G_ORGANIZATION_ID is null

Line 5039: oe_debug_pub.add('End G_ORGANIZATION_ID = '||G_ORGANIZATION_ID);

5035: G_ORGANIZATION_ID := l_inv_org_id;
5036: -- end if;
5037: end if; --if G_ORGANIZATION_ID is null
5038:
5039: oe_debug_pub.add('End G_ORGANIZATION_ID = '||G_ORGANIZATION_ID);
5040:
5041: return l_inv_org_id;
5042: EXCEPTION
5043: when no_data_found then

Line 5044: oe_debug_pub.add('no data found exception in qp_util.Get_Item_Validation_Org');

5040:
5041: return l_inv_org_id;
5042: EXCEPTION
5043: when no_data_found then
5044: oe_debug_pub.add('no data found exception in qp_util.Get_Item_Validation_Org');
5045: --fix for bug 4776045
5046: -- G_ORGANIZATION_ID := FND_PROFILE.Value('QP_ORGANIZATION_ID');
5047: -- return G_ORGANIZATION_ID;
5048: return null;

Line 5051: oe_debug_pub.add('others exception in qp_util.Get_Item_Validation_Org, error is ' || SQLERRM);

5047: -- return G_ORGANIZATION_ID;
5048: return null;
5049:
5050: when others then
5051: oe_debug_pub.add('others exception in qp_util.Get_Item_Validation_Org, error is ' || SQLERRM);
5052: --fix for bug 4776045
5053: -- G_ORGANIZATION_ID := FND_PROFILE.Value('QP_ORGANIZATION_ID');
5054: -- return G_ORGANIZATION_ID;
5055: return null;