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 1683: oe_debug_pub.add('select stmt1'||v_selectstmt);

1679:
1680:
1681: v_selectstmt := 'SELECT '||v_cols||' FROM '||p_table_r.table_name||' '||v_where_clause;
1682:
1683: oe_debug_pub.add('select stmt1'||v_selectstmt);
1684: ------------------
1685:
1686: /*
1687: IF p_table_r.id_column_name is not null then

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

1714: /*
1715: -- parse the query
1716:
1717: DBMS_SQL.PARSE(v_cursor_id,v_selectstmt,DBMS_SQL.V7);
1718: oe_debug_pub.add('after parse1');
1719: -- Bind the input variables
1720: DBMS_SQL.DEFINE_COLUMN(v_cursor_id,1,v_value,150);
1721: DBMS_SQL.DEFINE_COLUMN(v_cursor_id,2,v_id,150);
1722: v_retval := DBMS_SQL.EXECUTE(v_cursor_id);

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

1729: DBMS_SQL.COLUMN_VALUE(v_cursor_id,1,v_value);
1730: DBMS_SQL.COLUMN_VALUE(v_cursor_id,2,v_id);
1731:
1732: IF v_id IS NULL AND (p_value = v_value) THEN
1733: oe_debug_pub.add('id null, passing value'||p_value||','||v_value);
1734: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);
1735: x_id := v_id;
1736: x_value := v_value;
1737: RETURN TRUE;

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

1735: x_id := v_id;
1736: x_value := v_value;
1737: RETURN TRUE;
1738: ELSIF (p_value = v_id) THEN
1739: oe_debug_pub.add('id exists, passing id'||p_value||','||v_id);
1740: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);
1741: x_id := v_id;
1742: x_value := v_value;
1743: RETURN TRUE;

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

1742: x_value := v_value;
1743: RETURN TRUE;
1744: ELSE
1745: Null;
1746: oe_debug_pub.add('value does notmatch, continue search'||p_value||','||v_id);
1747: END IF;
1748: END LOOP;
1749: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);
1750: RETURN FALSE;

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

1750: RETURN FALSE;
1751: */
1752: EXCEPTION
1753: WHEN OTHERS THEN
1754: oe_debug_pub.add('value_exists_in_table exception');
1755: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);
1756: RETURN FALSE;
1757: END value_exists_in_table;
1758:

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

3848: end if;
3849:
3850: v_selectstmt := 'SELECT '||v_cols||' FROM '||p_table_r.table_name||' '||v_where_clause;
3851:
3852: oe_debug_pub.add('select stmt2'||v_selectstmt);
3853:
3854: ------------------
3855:
3856: /*

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

3889: /*
3890: -- parse the query
3891:
3892: DBMS_SQL.PARSE(v_cursor_id,v_selectstmt,DBMS_SQL.V7);
3893: oe_debug_pub.add('after parse2');
3894: -- Bind the input variables
3895: DBMS_SQL.DEFINE_COLUMN(v_cursor_id,1,v_value,150);
3896: DBMS_SQL.DEFINE_COLUMN(v_cursor_id,2,v_id,150);
3897: if p_table_r.meaning_column_name IS NOT NULL THEN

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

3912: end if;
3913:
3914:
3915: IF v_id IS NULL AND (p_value = v_value) THEN
3916: oe_debug_pub.add('id null, passing value'||p_value||','||v_value||' '||v_meaning);
3917: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);
3918: x_id := v_id;
3919: x_value := v_value;
3920: --added this to return meaning

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

3920: --added this to return meaning
3921: x_meaning := v_meaning;
3922: RETURN TRUE;
3923: ELSIF (p_value = v_id) THEN
3924: oe_debug_pub.add('id exists, passing id'||p_value||','||v_id||' '||v_meaning);
3925: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);
3926: x_id := v_id;
3927: x_value := v_value;
3928: --added this to return meaning

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

3933: end if;
3934: RETURN TRUE;
3935: ELSE
3936: Null;
3937: oe_debug_pub.add('value does notmatch, continue search'||p_value||','||v_id);
3938: END IF;
3939: END LOOP;
3940: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);
3941: RETURN FALSE;

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

3941: RETURN FALSE;
3942: */
3943: EXCEPTION
3944: WHEN OTHERS THEN
3945: oe_debug_pub.add('value_exists_in_table exception');
3946: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);
3947: RETURN FALSE;
3948: END value_exists_in_table;
3949:

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

4981: FUNCTION Get_Item_Validation_Org RETURN NUMBER IS
4982: l_application_id NUMBER;
4983: l_inv_org_id NUMBER;
4984: BEGIN
4985: oe_debug_pub.add('Start G_ORGANIZATION_ID = '||G_ORGANIZATION_ID);
4986: /*
4987: commenting this code R12 per ER 4756750 to move the profile-based
4988: approach for all calling app and come up with a pricing parameter
4989: for the item validation Org per the ER

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

4988: approach for all calling app and come up with a pricing parameter
4989: for the item validation Org per the ER
4990: l_application_id := fnd_global.resp_appl_id;
4991:
4992: oe_debug_pub.add('l_application_id = '||l_application_id);
4993: if l_application_id in (201, 178) then -- oracle purchasing/iProcurement
4994: SELECT inventory_organization_id
4995: INTO l_inv_org_id
4996: --fix for bug 4776045 for MOAC

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

4997: --FROM financials_system_parameters;
4998: FROM FINANCIALS_SYSTEM_PARAMS_ALL
4999: where org_id = get_org_id;
5000:
5001: oe_debug_pub.add('inv_org_id from financials_system_parameters = '||l_inv_org_id);
5002: G_ORGANIZATION_ID := l_inv_org_id;
5003: end if;--application_id
5004: if G_ORGANIZATION_ID is null then --above query did not return a value
5005: --because MO Default OU was not set or FSP is not set revert to QP profile

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

5006: */
5007: -- if G_ORGANIZATION_ID is null then
5008: l_inv_org_id := FND_PROFILE.Value('QP_ORGANIZATION_ID');
5009:
5010: oe_debug_pub.add('inv_org_id from profile QP_ORGANIZATION_ID = '||l_inv_org_id);
5011: IF G_ORGANIZATION_ID IS NULL THEN
5012: G_ORGANIZATION_ID := l_inv_org_id;
5013: -- end if;
5014: end if; --if G_ORGANIZATION_ID is null

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

5012: G_ORGANIZATION_ID := l_inv_org_id;
5013: -- end if;
5014: end if; --if G_ORGANIZATION_ID is null
5015:
5016: oe_debug_pub.add('End G_ORGANIZATION_ID = '||G_ORGANIZATION_ID);
5017:
5018: return l_inv_org_id;
5019: EXCEPTION
5020: when no_data_found then

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

5017:
5018: return l_inv_org_id;
5019: EXCEPTION
5020: when no_data_found then
5021: oe_debug_pub.add('no data found exception in qp_util.Get_Item_Validation_Org');
5022: --fix for bug 4776045
5023: -- G_ORGANIZATION_ID := FND_PROFILE.Value('QP_ORGANIZATION_ID');
5024: -- return G_ORGANIZATION_ID;
5025: return null;

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

5024: -- return G_ORGANIZATION_ID;
5025: return null;
5026:
5027: when others then
5028: oe_debug_pub.add('others exception in qp_util.Get_Item_Validation_Org, error is ' || SQLERRM);
5029: --fix for bug 4776045
5030: -- G_ORGANIZATION_ID := FND_PROFILE.Value('QP_ORGANIZATION_ID');
5031: -- return G_ORGANIZATION_ID;
5032: return null;