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.GMP_CALENDAR_PKG dependencies on GMP_CALENDAR_PKG

Line 1: PACKAGE BODY GMP_CALENDAR_PKG as

1: PACKAGE BODY GMP_CALENDAR_PKG as
2: /* $Header: GMPDCALB.pls 120.25.12010000.2 2008/11/01 22:17:05 rpatangy ship $ */
3:
4: invalid_string_value EXCEPTION;
5: v_cp_enabled BOOLEAN := FALSE;

Line 129: IF gmp_calendar_pkg.org_string(p_instance_id) THEN

125: v_cp_enabled := FALSE;
126: END IF;
127:
128: /* populate the org_string */
129: IF gmp_calendar_pkg.org_string(p_instance_id) THEN
130: NULL ;
131: ELSE
132: RAISE invalid_string_value ;
133: END IF;

Line 230: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN

226: || ' AND r.planning_exception_set = mrp.exception_set_name '
227: || ' AND p.organization_id = mrp.organization_id '
228: || ' AND p.process_enabled_flag = '||''''||'Y'||'''' ;
229:
230: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN
231: ins_dept_res := ins_dept_res
232: ||' AND p.organization_id ' || gmp_calendar_pkg.g_in_str_org ;
233: END IF;
234: /*sowsubra - ME changes - End*/

Line 232: ||' AND p.organization_id ' || gmp_calendar_pkg.g_in_str_org ;

228: || ' AND p.process_enabled_flag = '||''''||'Y'||'''' ;
229:
230: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN
231: ins_dept_res := ins_dept_res
232: ||' AND p.organization_id ' || gmp_calendar_pkg.g_in_str_org ;
233: END IF;
234: /*sowsubra - ME changes - End*/
235:
236: ins_dept_res := ins_dept_res

Line 291: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN

287: || ' AND nvl(hr.date_to,sysdate) >= sysdate '
288: || ' AND p.process_enabled_flag = '||''''||'Y'||''''
289: || ' AND r.delete_mark = 0 ' ;
290:
291: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN
292: ins_dept_res := ins_dept_res
293: ||' AND p.organization_id ' || gmp_calendar_pkg.g_in_str_org ;
294: END IF;
295: /*sowsubra - ME changes - end*/

Line 293: ||' AND p.organization_id ' || gmp_calendar_pkg.g_in_str_org ;

289: || ' AND r.delete_mark = 0 ' ;
290:
291: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN
292: ins_dept_res := ins_dept_res
293: ||' AND p.organization_id ' || gmp_calendar_pkg.g_in_str_org ;
294: END IF;
295: /*sowsubra - ME changes - end*/
296: EXECUTE IMMEDIATE ins_dept_res USING p_instance_id, p_instance_id;
297:

Line 330: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN

326: || ' AND crd.resources = crm.resources '
327: || ' AND crd.group_resource = crm.resources '
328: || ' AND crd.delete_mark = 0 ';
329:
330: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN
331: ins_res_group := ins_res_group
332: ||' AND EXISTS ( SELECT 1 FROM mtl_system_items'||p_db_link||' msi'
333: ||' WHERE msi.organization_id = p.organization_id )' ;
334: END IF;

Line 383: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN

379: ||' AND m.process_enabled_flag = '||''''||'Y'||''''
380: ||' AND gri.inactive_ind = 0 '
381: ||' AND c.delete_mark = 0 ';
382:
383: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN
384: ins_res_instance := ins_res_instance
385: ||' AND m.organization_id ' || gmp_calendar_pkg.g_in_str_org ;
386: END IF;
387:

Line 385: ||' AND m.organization_id ' || gmp_calendar_pkg.g_in_str_org ;

381: ||' AND c.delete_mark = 0 ';
382:
383: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN
384: ins_res_instance := ins_res_instance
385: ||' AND m.organization_id ' || gmp_calendar_pkg.g_in_str_org ;
386: END IF;
387:
388: EXECUTE IMMEDIATE ins_res_instance USING p_instance_id;
389:

Line 397: log_message('NO_DATA_FOUND exception raised in Procedure: Gmp_calendar_pkg.Rsrc_extract ' );

393: WHEN invalid_string_value THEN
394: log_message('APS string is Invalid, check for Error condition' );
395: return_status := FALSE;
396: WHEN NO_DATA_FOUND THEN /* B3577871 */
397: log_message('NO_DATA_FOUND exception raised in Procedure: Gmp_calendar_pkg.Rsrc_extract ' );
398: return_status := TRUE;
399: WHEN OTHERS THEN
400: log_message('Error in department/Res Group Insert: '||p_instance_id);
401: log_message(sqlerrm);

Line 529: IF gmp_calendar_pkg.org_string(p_instance_id) THEN

525: EXECUTE IMMEDIATE inst_stmt INTO v_icode USING p_instance_id ;
526: stmt_no := 10;
527:
528: /* populate the org_string */
529: IF gmp_calendar_pkg.org_string(p_instance_id) THEN
530: NULL ;
531: ELSE
532: RAISE invalid_string_value ;
533: END IF;

Line 556: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN

552: || ' AND crd.organization_id = mp.organization_id '
553: || ' AND NVL(crd.calendar_code,mp.calendar_code)=cal.calendar_code'
554: || ' AND crd.delete_mark = 0 ' ;
555:
556: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN
557: sql_allcal := sql_allcal
558: ||' AND mp.organization_id ' || gmp_calendar_pkg.g_in_str_org ;
559: END IF;
560: sql_allcal := sql_allcal

Line 558: ||' AND mp.organization_id ' || gmp_calendar_pkg.g_in_str_org ;

554: || ' AND crd.delete_mark = 0 ' ;
555:
556: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN
557: sql_allcal := sql_allcal
558: ||' AND mp.organization_id ' || gmp_calendar_pkg.g_in_str_org ;
559: END IF;
560: sql_allcal := sql_allcal
561: || ' ORDER BY 1,4 ';
562:

Line 592: ||' gmp_calendar_pkg.insert_gmp_resource_avail'||p_db_link

588: /* REGENERATE THE CALENDAR AND THEN INSERT IT INTO MSC TABLE */
589: res_passed := 'DONOT_RETRIEVE_CALENDAR' ;
590:
591: sql_regen := sql_regen ||' begin '
592: ||' gmp_calendar_pkg.insert_gmp_resource_avail'||p_db_link
593: ||' (:p1, '
594: ||' :p2, '
595: ||' :p3, '
596: ||' :p4, '

Line 677: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN

673: || ' AND gra.resource_id = crd.resource_id '
674: || ' AND m.process_enabled_flag = '||''''||'Y'||''''
675: || ' AND crd.delete_mark = 0 ';
676:
677: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN
678: ins_res_avl := ins_res_avl
679: ||' AND gra.organization_id ' || gmp_calendar_pkg.g_in_str_org ;
680: END IF;
681:

Line 679: ||' AND gra.organization_id ' || gmp_calendar_pkg.g_in_str_org ;

675: || ' AND crd.delete_mark = 0 ';
676:
677: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN
678: ins_res_avl := ins_res_avl
679: ||' AND gra.organization_id ' || gmp_calendar_pkg.g_in_str_org ;
680: END IF;
681:
682: EXECUTE IMMEDIATE ins_res_avl USING p_instance_id, simulation_set;
683: log_message('Resource Calendar Insertion Is Done' );

Line 726: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN

722: || ' AND gra.resource_id = crd.resource_id '
723: || ' AND m.process_enabled_flag = '||''''||'Y'||''''
724: || ' AND crd.delete_mark = 0 ';
725:
726: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN
727: inst_resavl := inst_resavl
728: ||' AND gra.organization_id ' || gmp_calendar_pkg.g_in_str_org ;
729: END IF;
730:

Line 728: ||' AND gra.organization_id ' || gmp_calendar_pkg.g_in_str_org ;

724: || ' AND crd.delete_mark = 0 ';
725:
726: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN
727: inst_resavl := inst_resavl
728: ||' AND gra.organization_id ' || gmp_calendar_pkg.g_in_str_org ;
729: END IF;
730:
731: EXECUTE IMMEDIATE inst_resavl USING p_instance_id;
732: log_message('Resource Calendar Instance Insertion Is Done' );

Line 760: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN

756: || ' AND m.organization_id = crd.organization_id '
757: || ' AND m.process_enabled_flag = '||''''||'Y'||''''
758: || ' AND crd.delete_mark = 0 ';
759:
760: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN
761: ins_res_shft := ins_res_shft
762: ||' AND m.organization_id ' || gmp_calendar_pkg.g_in_str_org ;
763: END IF;
764:

Line 762: ||' AND m.organization_id ' || gmp_calendar_pkg.g_in_str_org ;

758: || ' AND crd.delete_mark = 0 ';
759:
760: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN
761: ins_res_shft := ins_res_shft
762: ||' AND m.organization_id ' || gmp_calendar_pkg.g_in_str_org ;
763: END IF;
764:
765: EXECUTE IMMEDIATE ins_res_shft USING p_instance_id;
766: log_message('Resource Shift Insertion Is Done' );

Line 790: log_message(' NO_DATA_FOUND exception : Gmp_calendar_pkg.Populate_rsrc_cal ' );

786: WHEN invalid_string_value THEN
787: log_message('APS string is Invalid, check for Error condition' );
788: return_status := FALSE;
789: WHEN NO_DATA_FOUND THEN /* B3577871 */
790: log_message(' NO_DATA_FOUND exception : Gmp_calendar_pkg.Populate_rsrc_cal ' );
791: return_status := TRUE;
792: WHEN OTHERS THEN
793: log_message('Error in Populate Rsrc cal construct: '||stmt_no);
794: log_message('Error : '||v_icode);

Line 1822: log_message('NO DATA FOUND exception: Gmp_calendar_pkg.net_rsrc_insert');

1818: return_status := TRUE;
1819:
1820: EXCEPTION
1821: WHEN NO_DATA_FOUND THEN
1822: log_message('NO DATA FOUND exception: Gmp_calendar_pkg.net_rsrc_insert');
1823: return_status := TRUE;
1824: WHEN OTHERS THEN
1825: log_message('Error in Net Resource Insert: '||stmt_no);
1826: log_message(sqlerrm);

Line 2840: gmp_calendar_pkg.g_in_str_org := org_str ;

2836: We have to find the IN part in the string, otherwise have to raise
2837: Exception message for error condition */
2838:
2839: IF in_position > 0 THEN
2840: gmp_calendar_pkg.g_in_str_org := org_str ;
2841: return TRUE ;
2842: ELSE
2843: gmp_calendar_pkg.g_in_str_org := NULL ;
2844: return FALSE ;

Line 2843: gmp_calendar_pkg.g_in_str_org := NULL ;

2839: IF in_position > 0 THEN
2840: gmp_calendar_pkg.g_in_str_org := org_str ;
2841: return TRUE ;
2842: ELSE
2843: gmp_calendar_pkg.g_in_str_org := NULL ;
2844: return FALSE ;
2845: END IF;
2846: ELSE
2847: /* For older patchset This value should be TRUE */

Line 2848: gmp_calendar_pkg.g_in_str_org := NULL ;

2844: return FALSE ;
2845: END IF;
2846: ELSE
2847: /* For older patchset This value should be TRUE */
2848: gmp_calendar_pkg.g_in_str_org := NULL ;
2849: return TRUE ;
2850: END IF;
2851:
2852: EXCEPTION

Line 2856: gmp_calendar_pkg.g_in_str_org := NULL ;

2852: EXCEPTION
2853: WHEN OTHERS THEN
2854: log_message('Error in org_string ');
2855: log_message(sqlerrm);
2856: gmp_calendar_pkg.g_in_str_org := NULL ;
2857: return FALSE ;
2858: END ORG_STRING;
2859:
2860: /*

Line 2887: END gmp_calendar_pkg;

2883: log_message(sqlerrm);
2884: RAISE;
2885: END time_stamp ;
2886:
2887: END gmp_calendar_pkg;