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

Line 6610: oe_debug_Pub.add('>>>>>>>>>>>>>>>>>>>>>>>>EXCEPTION HAPPEN in procedure product_uom() ');

6606: EXCEPTION
6607:
6608: When OTHERS THEN
6609:
6610: oe_debug_Pub.add('>>>>>>>>>>>>>>>>>>>>>>>>EXCEPTION HAPPEN in procedure product_uom() ');
6611:
6612: RETURN FALSE;
6613:
6614: END product_uom;

Line 6629: oe_debug_Pub.add('>>>>>>>>>>>>>>>>>>>>>>>>In procedure QP_VALIDATE.product_uom()');

6625: l_ss_code varchar2(30);
6626: l_org_id number:= QP_UTIL.Get_Item_Validation_Org ;
6627:
6628: BEGIN
6629: oe_debug_Pub.add('>>>>>>>>>>>>>>>>>>>>>>>>In procedure QP_VALIDATE.product_uom()');
6630: oe_debug_Pub.add('>>>>>>>>>>>>>>>>>>>>>>>>p_product_uom_code: '||p_product_uom_code);
6631: oe_debug_Pub.add('>>>>>>>>>>>>>>>>>>>>>>>>p_category_id: '||p_category_id);
6632: oe_debug_Pub.add('>>>>>>>>>>>>>>>>>>>>>>>>p_list_header_id: '||p_list_header_id);
6633:

Line 6630: oe_debug_Pub.add('>>>>>>>>>>>>>>>>>>>>>>>>p_product_uom_code: '||p_product_uom_code);

6626: l_org_id number:= QP_UTIL.Get_Item_Validation_Org ;
6627:
6628: BEGIN
6629: oe_debug_Pub.add('>>>>>>>>>>>>>>>>>>>>>>>>In procedure QP_VALIDATE.product_uom()');
6630: oe_debug_Pub.add('>>>>>>>>>>>>>>>>>>>>>>>>p_product_uom_code: '||p_product_uom_code);
6631: oe_debug_Pub.add('>>>>>>>>>>>>>>>>>>>>>>>>p_category_id: '||p_category_id);
6632: oe_debug_Pub.add('>>>>>>>>>>>>>>>>>>>>>>>>p_list_header_id: '||p_list_header_id);
6633:
6634: if QP_UTIL. Get_QP_Status <> 'I' then --advanced pricing

Line 6631: oe_debug_Pub.add('>>>>>>>>>>>>>>>>>>>>>>>>p_category_id: '||p_category_id);

6627:
6628: BEGIN
6629: oe_debug_Pub.add('>>>>>>>>>>>>>>>>>>>>>>>>In procedure QP_VALIDATE.product_uom()');
6630: oe_debug_Pub.add('>>>>>>>>>>>>>>>>>>>>>>>>p_product_uom_code: '||p_product_uom_code);
6631: oe_debug_Pub.add('>>>>>>>>>>>>>>>>>>>>>>>>p_category_id: '||p_category_id);
6632: oe_debug_Pub.add('>>>>>>>>>>>>>>>>>>>>>>>>p_list_header_id: '||p_list_header_id);
6633:
6634: if QP_UTIL. Get_QP_Status <> 'I' then --advanced pricing
6635: oe_debug_Pub.add('>>>>>>>>>>>>>>>>>>>>>>>>basic pricing ');

Line 6632: oe_debug_Pub.add('>>>>>>>>>>>>>>>>>>>>>>>>p_list_header_id: '||p_list_header_id);

6628: BEGIN
6629: oe_debug_Pub.add('>>>>>>>>>>>>>>>>>>>>>>>>In procedure QP_VALIDATE.product_uom()');
6630: oe_debug_Pub.add('>>>>>>>>>>>>>>>>>>>>>>>>p_product_uom_code: '||p_product_uom_code);
6631: oe_debug_Pub.add('>>>>>>>>>>>>>>>>>>>>>>>>p_category_id: '||p_category_id);
6632: oe_debug_Pub.add('>>>>>>>>>>>>>>>>>>>>>>>>p_list_header_id: '||p_list_header_id);
6633:
6634: if QP_UTIL. Get_QP_Status <> 'I' then --advanced pricing
6635: oe_debug_Pub.add('>>>>>>>>>>>>>>>>>>>>>>>>basic pricing ');
6636: l_temp := 0;

Line 6635: oe_debug_Pub.add('>>>>>>>>>>>>>>>>>>>>>>>>basic pricing ');

6631: oe_debug_Pub.add('>>>>>>>>>>>>>>>>>>>>>>>>p_category_id: '||p_category_id);
6632: oe_debug_Pub.add('>>>>>>>>>>>>>>>>>>>>>>>>p_list_header_id: '||p_list_header_id);
6633:
6634: if QP_UTIL. Get_QP_Status <> 'I' then --advanced pricing
6635: oe_debug_Pub.add('>>>>>>>>>>>>>>>>>>>>>>>>basic pricing ');
6636: l_temp := 0;
6637: else
6638: select pte_code, source_system_code into l_pte_code, l_ss_code from qp_list_headers_all_b
6639: where list_header_id = p_list_header_id;

Line 6649: oe_debug_Pub.add('>>>>>>>>>>>>>>>>>>>>>>>>inside loop cl.category_set_id: '||cl.category_set_id);

6645: A.PTE_SOURCE_SYSTEM_ID = B.PTE_SOURCE_SYSTEM_ID and
6646: c.FUNCTIONAL_AREA_ID = a.FUNCTIONAL_AREA_ID and
6647: A.ENABLED_FLAG = 'Y' and B.ENABLED_FLAG = 'Y')
6648: loop
6649: oe_debug_Pub.add('>>>>>>>>>>>>>>>>>>>>>>>>inside loop cl.category_set_id: '||cl.category_set_id);
6650: select count(*) into l_temp
6651: from MTL_CATEGORY_SET_VALID_CATS cats,
6652: MTL_CATEGORY_SETS_B d
6653: where cats.category_id = p_category_id

Line 6660: oe_debug_Pub.add('>>>>>>>>>>>>>>>>>>>>>>>>l_temp > 0 for '||cl.category_set_id);

6656: and d.HIERARCHY_ENABLED = 'Y'
6657: and rownum = 1;
6658:
6659: if l_temp >0 then
6660: oe_debug_Pub.add('>>>>>>>>>>>>>>>>>>>>>>>>l_temp > 0 for '||cl.category_set_id);
6661: exit;
6662: else
6663: l_temp := 0;
6664: end if;

Line 6668: oe_debug_Pub.add('>>>>>>>>>>>>>>>>>>>>>>>>l_temp: '||l_temp);

6664: end if;
6665: end loop;
6666: End if;--QP_UTIL. Get_QP_Status
6667:
6668: oe_debug_Pub.add('>>>>>>>>>>>>>>>>>>>>>>>>l_temp: '||l_temp);
6669: oe_debug_Pub.add('>>>>>>>>>>>>>>>>>>>>>>>>l_org_id: '||l_org_id);
6670:
6671: select count(*) into l_valid_uom
6672: from mtl_item_uoms_view

Line 6669: oe_debug_Pub.add('>>>>>>>>>>>>>>>>>>>>>>>>l_org_id: '||l_org_id);

6665: end loop;
6666: End if;--QP_UTIL. Get_QP_Status
6667:
6668: oe_debug_Pub.add('>>>>>>>>>>>>>>>>>>>>>>>>l_temp: '||l_temp);
6669: oe_debug_Pub.add('>>>>>>>>>>>>>>>>>>>>>>>>l_org_id: '||l_org_id);
6670:
6671: select count(*) into l_valid_uom
6672: from mtl_item_uoms_view
6673: where organization_id = l_org_id

Line 6692: oe_debug_Pub.add('>>>>>>>>>>>>>>>>>>>>>>>>l_valid_uom: '||l_valid_uom);

6688: )
6689: and uom_code = p_product_uom_code --uom_code being validated
6690: and rownum = 1;
6691:
6692: oe_debug_Pub.add('>>>>>>>>>>>>>>>>>>>>>>>>l_valid_uom: '||l_valid_uom);
6693: if l_valid_uom >0 then
6694: RETURN TRUE;
6695: else
6696: RETURN FALSE;

Line 6701: oe_debug_Pub.add('>>>>>>>>>>>>>>>>>>>>>>>>EXCEPTION HAPPEN in procedure product_uom() ');

6697: end if;--l_valid_uom
6698:
6699: EXCEPTION
6700: When OTHERS THEN
6701: oe_debug_Pub.add('>>>>>>>>>>>>>>>>>>>>>>>>EXCEPTION HAPPEN in procedure product_uom() ');
6702: RETURN FALSE;
6703: END product_uom;
6704: */
6705: