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.RCV_OPSM_DLV_BE_PKG dependencies on ASN_DEBUG

Line 48: g_asn_debug VARCHAR2(1):= NVL(fnd_profile.VALUE('RCV_DEBUG_MODE'), 'N');

44: m number:=1;
45:
46: l_module_name CONSTANT VARCHAR2(1000):= 'rcv.plsql.'||G_PKG_NAME||'.'||'RCV_OPSM_DLV_EVENT';
47: l_msg_data VARCHAR2(2000):=NULL;
48: g_asn_debug VARCHAR2(1):= NVL(fnd_profile.VALUE('RCV_DEBUG_MODE'), 'N');
49:
50: TYPE delivery_count IS TABLE OF NUMBER INDEX BY VARCHAR2(255);
51: del_count delivery_count;
52:

Line 261: IF g_asn_debug is null THEN

257:
258:
259: BEGIN
260:
261: IF g_asn_debug is null THEN
262: g_asn_debug:='Y';
263: END IF;
264:
265: x_return_status := 'U';

Line 262: g_asn_debug:='Y';

258:
259: BEGIN
260:
261: IF g_asn_debug is null THEN
262: g_asn_debug:='Y';
263: END IF;
264:
265: x_return_status := 'U';
266:

Line 550: asn_debug.put_line(l_module_name||'No Data Found.Oracle error message is '|| substr(SQLERRM,1,200),fnd_log.level_error);

546:
547:
548: EXCEPTION
549: WHEN NO_DATA_FOUND THEN
550: asn_debug.put_line(l_module_name||'No Data Found.Oracle error message is '|| substr(SQLERRM,1,200),fnd_log.level_error);
551: x_return_status :=rcv_error_pkg.g_ret_sts_error;
552: l_msg_data:='NO DATA FOUND -ERROR';
553: x_msg_data:=l_msg_data;
554:

Line 556: IF g_asn_debug <>'Y' THEN

552: l_msg_data:='NO DATA FOUND -ERROR';
553: x_msg_data:=l_msg_data;
554:
555: WHEN OTHERS THEN
556: IF g_asn_debug <>'Y' THEN
557: asn_debug.put_line(l_module_name||'Unexpected error has occured. Oracle error message is '||substr(SQLERRM,1,200)||fnd_log.level_error);
558: END IF;
559: x_return_status := rcv_error_pkg.G_RET_STS_UNEXP_ERROR;
560: l_msg_data := SQLERRM ||' at RCV_OPSM_DLV_BE_PKG.RCV_OPSM_DLV_EVENT';

Line 557: asn_debug.put_line(l_module_name||'Unexpected error has occured. Oracle error message is '||substr(SQLERRM,1,200)||fnd_log.level_error);

553: x_msg_data:=l_msg_data;
554:
555: WHEN OTHERS THEN
556: IF g_asn_debug <>'Y' THEN
557: asn_debug.put_line(l_module_name||'Unexpected error has occured. Oracle error message is '||substr(SQLERRM,1,200)||fnd_log.level_error);
558: END IF;
559: x_return_status := rcv_error_pkg.G_RET_STS_UNEXP_ERROR;
560: l_msg_data := SQLERRM ||' at RCV_OPSM_DLV_BE_PKG.RCV_OPSM_DLV_EVENT';
561: x_msg_data := l_msg_data;

Line 589: g_asn_debug VARCHAR2(1):= NVL(fnd_profile.VALUE('RCV_DEBUG_MODE'), 'N');

585: l_count NUMBER:=0;
586: l_count1 NUMBER:=0;
587: l_module_name CONSTANT VARCHAR2(100):= 'rcv.plsql.' ||G_PKG_NAME || '.' || 'RCV_OPSM_CHECK';
588: l_msg_data VARCHAR2(2000):=NULL;
589: g_asn_debug VARCHAR2(1):= NVL(fnd_profile.VALUE('RCV_DEBUG_MODE'), 'N');
590:
591: CURSOR c_opsm_items
592: IS
593: SELECT ROLV.item_id,ROLV.organization_id

Line 599: IF g_asn_debug is null THEN

595: WHERE rolv.shipment_header_id=p_shipmentheaderid
596: AND rolv.GROUP_ID=p_groupid;
597:
598: BEGIN
599: IF g_asn_debug is null THEN
600: g_asn_debug:='Y';
601: END IF;
602:
603: x_return_status := 'U';

Line 600: g_asn_debug:='Y';

596: AND rolv.GROUP_ID=p_groupid;
597:
598: BEGIN
599: IF g_asn_debug is null THEN
600: g_asn_debug:='Y';
601: END IF;
602:
603: x_return_status := 'U';
604:

Line 633: IF g_asn_debug='Y' THEN

629:
630:
631: l_count1:=l_count1+l_count;
632:
633: IF g_asn_debug='Y' THEN
634: asn_debug.put_line(l_module_name||'OPSM INTEGRATED SINGLE'||l_count);
635: asn_debug.put_line(l_module_name||'OPSM INTEGRATED COUNT'||l_count1);
636: END IF;
637:

Line 634: asn_debug.put_line(l_module_name||'OPSM INTEGRATED SINGLE'||l_count);

630:
631: l_count1:=l_count1+l_count;
632:
633: IF g_asn_debug='Y' THEN
634: asn_debug.put_line(l_module_name||'OPSM INTEGRATED SINGLE'||l_count);
635: asn_debug.put_line(l_module_name||'OPSM INTEGRATED COUNT'||l_count1);
636: END IF;
637:
638: IF l_count1 > 0 THEN

Line 635: asn_debug.put_line(l_module_name||'OPSM INTEGRATED COUNT'||l_count1);

631: l_count1:=l_count1+l_count;
632:
633: IF g_asn_debug='Y' THEN
634: asn_debug.put_line(l_module_name||'OPSM INTEGRATED SINGLE'||l_count);
635: asn_debug.put_line(l_module_name||'OPSM INTEGRATED COUNT'||l_count1);
636: END IF;
637:
638: IF l_count1 > 0 THEN
639: EXIT;

Line 663: IF g_asn_debug='Y' THEN

659: END LOOP;
660:
661: IF l_count1 > 0 THEN
662: p_opsmexist:='Y';
663: IF g_asn_debug='Y' THEN
664: asn_debug.put_line(l_module_name||'OPSM INTEGRATED EXIST'||p_opsmexist);
665: l_msg_data:='OPSM ITEM EXIST';
666: x_msg_data:=l_msg_data;
667: END IF;

Line 664: asn_debug.put_line(l_module_name||'OPSM INTEGRATED EXIST'||p_opsmexist);

660:
661: IF l_count1 > 0 THEN
662: p_opsmexist:='Y';
663: IF g_asn_debug='Y' THEN
664: asn_debug.put_line(l_module_name||'OPSM INTEGRATED EXIST'||p_opsmexist);
665: l_msg_data:='OPSM ITEM EXIST';
666: x_msg_data:=l_msg_data;
667: END IF;
668:

Line 671: IF g_asn_debug='Y' THEN

667: END IF;
668:
669: ELSE
670: p_opsmexist:='N';
671: IF g_asn_debug='Y' THEN
672: asn_debug.put_line(l_module_name||'OPSM INTEGRATED NOT EXIST'||p_opsmexist);
673: l_msg_data:='OPSM ITEM NOT EXIST';
674: x_msg_data:=l_msg_data;
675:

Line 672: asn_debug.put_line(l_module_name||'OPSM INTEGRATED NOT EXIST'||p_opsmexist);

668:
669: ELSE
670: p_opsmexist:='N';
671: IF g_asn_debug='Y' THEN
672: asn_debug.put_line(l_module_name||'OPSM INTEGRATED NOT EXIST'||p_opsmexist);
673: l_msg_data:='OPSM ITEM NOT EXIST';
674: x_msg_data:=l_msg_data;
675:
676:

Line 688: IF g_asn_debug<>'Y' THEN

684: WHEN OTHERS THEN
685: l_count:=0;
686: p_opsmexist:='N';
687:
688: IF g_asn_debug<>'Y' THEN
689: asn_debug.put_line(l_module_name||'OPSM INTEGRATED EXIST'||p_opsmexist);
690: asn_debug.put_line(l_module_name||'Unexpected error has occured. Oracle error message is '||substr(SQLERRM,1,200)||fnd_log.level_error);
691: END IF;
692:

Line 689: asn_debug.put_line(l_module_name||'OPSM INTEGRATED EXIST'||p_opsmexist);

685: l_count:=0;
686: p_opsmexist:='N';
687:
688: IF g_asn_debug<>'Y' THEN
689: asn_debug.put_line(l_module_name||'OPSM INTEGRATED EXIST'||p_opsmexist);
690: asn_debug.put_line(l_module_name||'Unexpected error has occured. Oracle error message is '||substr(SQLERRM,1,200)||fnd_log.level_error);
691: END IF;
692:
693: x_return_status := rcv_error_pkg.G_RET_STS_UNEXP_ERROR;

Line 690: asn_debug.put_line(l_module_name||'Unexpected error has occured. Oracle error message is '||substr(SQLERRM,1,200)||fnd_log.level_error);

686: p_opsmexist:='N';
687:
688: IF g_asn_debug<>'Y' THEN
689: asn_debug.put_line(l_module_name||'OPSM INTEGRATED EXIST'||p_opsmexist);
690: asn_debug.put_line(l_module_name||'Unexpected error has occured. Oracle error message is '||substr(SQLERRM,1,200)||fnd_log.level_error);
691: END IF;
692:
693: x_return_status := rcv_error_pkg.G_RET_STS_UNEXP_ERROR;
694: