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.36.12020000.4 2012/11/08 08:46:23 vkinduri ship $ */
3:
4: invalid_string_value EXCEPTION;
5: v_cp_enabled BOOLEAN := FALSE;

Line 231: IF gmp_calendar_pkg.org_string(p_instance_id) THEN

227: v_cp_enabled := FALSE;
228: END IF;
229:
230: /* populate the org_string */
231: IF gmp_calendar_pkg.org_string(p_instance_id) THEN
232: NULL ;
233: ELSE
234: RAISE invalid_string_value ;
235: END IF;

Line 334: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN

330: || ' AND r.planning_exception_set = mrp.exception_set_name '
331: || ' AND p.organization_id = mrp.organization_id '
332: || ' AND p.process_enabled_flag = '||''''||'Y'||'''' ;
333:
334: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN
335: ins_dept_res := ins_dept_res
336: ||' AND p.organization_id ' || gmp_calendar_pkg.g_in_str_org ;
337: END IF;
338: /*sowsubra - ME changes - End*/

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

332: || ' AND p.process_enabled_flag = '||''''||'Y'||'''' ;
333:
334: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN
335: ins_dept_res := ins_dept_res
336: ||' AND p.organization_id ' || gmp_calendar_pkg.g_in_str_org ;
337: END IF;
338: /*sowsubra - ME changes - End*/
339:
340: ins_dept_res := ins_dept_res

Line 395: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN

391: || ' AND nvl(hr.date_to,sysdate) >= sysdate '
392: || ' AND p.process_enabled_flag = '||''''||'Y'||''''
393: || ' AND r.delete_mark = 0 ' ;
394:
395: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN
396: ins_dept_res := ins_dept_res
397: ||' AND p.organization_id ' || gmp_calendar_pkg.g_in_str_org ;
398: END IF;
399: /*sowsubra - ME changes - end*/

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

393: || ' AND r.delete_mark = 0 ' ;
394:
395: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN
396: ins_dept_res := ins_dept_res
397: ||' AND p.organization_id ' || gmp_calendar_pkg.g_in_str_org ;
398: END IF;
399: /*sowsubra - ME changes - end*/
400: EXECUTE IMMEDIATE ins_dept_res USING p_instance_id, p_instance_id;
401:

Line 435: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN

431: || ' AND crd.resources = crm.resources '
432: || ' AND crd.group_resource = crm.resources '
433: || ' AND crd.delete_mark = 0 ';
434:
435: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN
436: ins_res_group := ins_res_group
437: ||' AND EXISTS ( SELECT 1 FROM mtl_system_items'||p_db_link||' msi'
438: ||' WHERE msi.organization_id = p.organization_id )' ;
439: END IF; */

Line 497: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN

493: || ' AND crd.resources = crm.resources '
494: || ' AND crd.group_resource = crm.resources '
495: || ' AND crd.delete_mark = 0 ';
496:
497: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN
498: ins_res_group := ins_res_group
499: ||' AND EXISTS ( SELECT 1 FROM mtl_system_items'||p_db_link||' msi'
500: ||' WHERE msi.organization_id = p.organization_id )' ;
501: END IF;

Line 561: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN

557: ||' AND m.process_enabled_flag = '||''''||'Y'||''''
558: ||' AND gri.inactive_ind = 0 '
559: ||' AND c.delete_mark = 0 ';
560:
561: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN
562: ins_res_instance := ins_res_instance
563: ||' AND m.organization_id ' || gmp_calendar_pkg.g_in_str_org ;
564: END IF;
565:

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

559: ||' AND c.delete_mark = 0 ';
560:
561: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN
562: ins_res_instance := ins_res_instance
563: ||' AND m.organization_id ' || gmp_calendar_pkg.g_in_str_org ;
564: END IF;
565:
566: EXECUTE IMMEDIATE ins_res_instance USING p_instance_id;
567:

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

571: WHEN invalid_string_value THEN
572: log_message('APS string is Invalid, check for Error condition' );
573: return_status := FALSE;
574: WHEN NO_DATA_FOUND THEN /* B3577871 */
575: log_message('NO_DATA_FOUND exception raised in Procedure: Gmp_calendar_pkg.Rsrc_extract ' );
576: return_status := TRUE;
577: WHEN OTHERS THEN
578: log_message('Error in department/Res Group Insert: '||p_instance_id);
579: log_message(sqlerrm);

Line 733: IF gmp_calendar_pkg.org_string(p_instance_id) THEN

729: EXECUTE IMMEDIATE inst_stmt INTO v_icode USING p_instance_id ;
730: stmt_no := 10;
731:
732: /* populate the org_string */
733: IF gmp_calendar_pkg.org_string(p_instance_id) THEN
734: NULL ;
735: ELSE
736: RAISE invalid_string_value ;
737: END IF;

Line 760: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN

756: || ' AND crd.organization_id = mp.organization_id '
757: || ' AND NVL(crd.calendar_code,mp.calendar_code)=cal.calendar_code'
758: || ' AND crd.delete_mark = 0 ' ;
759:
760: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN
761: sql_allcal := sql_allcal
762: ||' AND mp.organization_id ' || gmp_calendar_pkg.g_in_str_org ;
763: END IF;
764: sql_allcal := sql_allcal

Line 762: ||' AND mp.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: sql_allcal := sql_allcal
762: ||' AND mp.organization_id ' || gmp_calendar_pkg.g_in_str_org ;
763: END IF;
764: sql_allcal := sql_allcal
765: || ' ORDER BY 1,4 ';
766:

Line 809: ' BEGIN apps.gmp_calendar_pkg.insert_gmp_resource_avail'||p_db_link||'(:p1, :p2, :p3, :p4, :p5, :p6); END ;' ;

805: log_message('REGENERATE THE CALENDAR insert_gmp_resource_avail call = ' || p_db_link );
806: log_message('Calendar_no= ' || cursor_rec.calendar_no ||' and org_id= '|| cursor_rec.organization_id || 'RSRC= '|| res_passed);
807:
808: sql_regen :=
809: ' BEGIN apps.gmp_calendar_pkg.insert_gmp_resource_avail'||p_db_link||'(:p1, :p2, :p3, :p4, :p5, :p6); END ;' ;
810:
811: EXECUTE IMMEDIATE sql_regen USING
812: OUT v_errbuf , OUT v_retcode,
813: in cursor_rec.organization_id ,

Line 906: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN

902: || ' AND gra.resource_id = crd.resource_id '
903: || ' AND m.process_enabled_flag = '||''''||'Y'||''''
904: || ' AND crd.delete_mark = 0 ';
905:
906: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN
907: ins_res_avl := ins_res_avl
908: ||' AND gra.organization_id ' || gmp_calendar_pkg.g_in_str_org ;
909: END IF;
910:

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

904: || ' AND crd.delete_mark = 0 ';
905:
906: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN
907: ins_res_avl := ins_res_avl
908: ||' AND gra.organization_id ' || gmp_calendar_pkg.g_in_str_org ;
909: END IF;
910:
911: EXECUTE IMMEDIATE ins_res_avl USING p_instance_id, simulation_set;
912: log_message('msc_st_net_resource_avail Insertion Is Done' );

Line 957: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN

953: || ' AND gra.resource_id = crd.resource_id '
954: || ' AND m.process_enabled_flag = '||''''||'Y'||''''
955: || ' AND crd.delete_mark = 0 ';
956:
957: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN
958: inst_resavl := inst_resavl
959: ||' AND gra.organization_id ' || gmp_calendar_pkg.g_in_str_org ;
960: END IF;
961:

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

955: || ' AND crd.delete_mark = 0 ';
956:
957: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN
958: inst_resavl := inst_resavl
959: ||' AND gra.organization_id ' || gmp_calendar_pkg.g_in_str_org ;
960: END IF;
961:
962: EXECUTE IMMEDIATE inst_resavl USING p_instance_id;
963: log_message('msc_st_net_res_inst_avail Insertion Is Done' );

Line 994: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN

990: || ' AND m.organization_id = crd.organization_id '
991: || ' AND m.process_enabled_flag = '||''''||'Y'||''''
992: || ' AND crd.delete_mark = 0 ';
993:
994: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN
995: ins_res_shft := ins_res_shft
996: ||' AND m.organization_id ' || gmp_calendar_pkg.g_in_str_org ;
997: END IF;
998:

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

992: || ' AND crd.delete_mark = 0 ';
993:
994: IF gmp_calendar_pkg.g_in_str_org IS NOT NULL THEN
995: ins_res_shft := ins_res_shft
996: ||' AND m.organization_id ' || gmp_calendar_pkg.g_in_str_org ;
997: END IF;
998:
999: EXECUTE IMMEDIATE ins_res_shft USING p_instance_id;
1000: log_message(' msc_st_resource_shifts Insertion Is Done' );

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

1028: WHEN invalid_string_value THEN
1029: log_message('APS string is Invalid, check for Error condition' );
1030: return_status := FALSE;
1031: WHEN NO_DATA_FOUND THEN /* B3577871 */
1032: log_message(' NO_DATA_FOUND exception : Gmp_calendar_pkg.Populate_rsrc_cal ' );
1033: return_status := TRUE;
1034: WHEN OTHERS THEN
1035: log_message('Error in Populate Rsrc cal construct: '||stmt_no);
1036: log_message('Error : '||v_icode);

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

2095: return_status := TRUE;
2096:
2097: EXCEPTION
2098: WHEN NO_DATA_FOUND THEN
2099: log_message('NO DATA FOUND exception: Gmp_calendar_pkg.net_rsrc_insert');
2100: return_status := TRUE;
2101: WHEN OTHERS THEN
2102: log_message('Error in Net Resource Insert: '||stmt_no);
2103: log_message(sqlerrm);

Line 3290: gmp_calendar_pkg.g_in_str_org := org_str ;

3286: We have to find the IN part in the string, otherwise have to raise
3287: Exception message for error condition */
3288:
3289: IF in_position > 0 THEN
3290: gmp_calendar_pkg.g_in_str_org := org_str ;
3291: return TRUE ;
3292: ELSE
3293: gmp_calendar_pkg.g_in_str_org := NULL ;
3294: return FALSE ;

Line 3293: gmp_calendar_pkg.g_in_str_org := NULL ;

3289: IF in_position > 0 THEN
3290: gmp_calendar_pkg.g_in_str_org := org_str ;
3291: return TRUE ;
3292: ELSE
3293: gmp_calendar_pkg.g_in_str_org := NULL ;
3294: return FALSE ;
3295: END IF;
3296: ELSE
3297: /* For older patchset This value should be TRUE */

Line 3298: gmp_calendar_pkg.g_in_str_org := NULL ;

3294: return FALSE ;
3295: END IF;
3296: ELSE
3297: /* For older patchset This value should be TRUE */
3298: gmp_calendar_pkg.g_in_str_org := NULL ;
3299: return TRUE ;
3300: END IF;
3301:
3302: EXCEPTION

Line 3306: gmp_calendar_pkg.g_in_str_org := NULL ;

3302: EXCEPTION
3303: WHEN OTHERS THEN
3304: log_message('Error in org_string ');
3305: log_message(sqlerrm);
3306: gmp_calendar_pkg.g_in_str_org := NULL ;
3307: return FALSE ;
3308: END ORG_STRING;
3309:
3310: /*

Line 3337: END gmp_calendar_pkg;

3333: log_message(sqlerrm);
3334: RAISE;
3335: END time_stamp ;
3336:
3337: END gmp_calendar_pkg;