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 6609: oe_debug_Pub.add('>>>>>>>>>>>>>>>>>>>>>>>>EXCEPTION HAPPEN in procedure product_uom() ');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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