217:
218: /* B7609461 Rajesh Patangya 11-DEC-2008 */
219: gmd_p_fs_context.set_additional_attr;
220:
221: l_updt_offsets := nvl(FND_PROFILE.VALUE('GMP_UPDATE_ACTIVITY_OFFSETS'),0);/*B5148802*/
222: /* B7530107 Reset everything for GME so that
223: for every record it will go and set the org, calendar information */
224: gme_common_pvt.g_setup_done := FALSE ;
225:
538: l_new_plan_qty := 0;
539:
540:
541: /* B6994378, Rajesh Patangya GME does need intialization parameters */
542: u_user_id := FND_PROFILE.VALUE('user_id') ;
543: fnd_profile.initialize (u_user_id);
544: -- Line below required if formula security is used. It sets the security context.
545: fnd_global.apps_initialize (user_id => u_user_id,
546: resp_id => NULL,
539:
540:
541: /* B6994378, Rajesh Patangya GME does need intialization parameters */
542: u_user_id := FND_PROFILE.VALUE('user_id') ;
543: fnd_profile.initialize (u_user_id);
544: -- Line below required if formula security is used. It sets the security context.
545: fnd_global.apps_initialize (user_id => u_user_id,
546: resp_id => NULL,
547: resp_appl_id => NULL
545: fnd_global.apps_initialize (user_id => u_user_id,
546: resp_id => NULL,
547: resp_appl_id => NULL
548: );
549: fnd_profile.put ('AFLOG_LEVEL', '1');
550: /* B7577478 Rajesh Patangya 18-NOV-2008
551: 'S' -- if multiple product lines for the same items are present in formula details, APS
552: suggest the suggestion based on the product line quantity and hence GME should
553: be using the quantity passed as total quantity for the product (which is the
568: l_is_associated := 1;
569: END IF;
570:
571: IF l_is_associated = 1 THEN
572: l_profile := NVL(FND_PROFILE.VALUE('GMP_USE_MANUFACTURING_CAL'),'N');
573: ELSE
574: l_profile := 'N';
575: END IF;
576:
1035: p_organization_id,
1036: p_eff_id,
1037: 1, -- Action_type
1038: sysdate, -- Creation_date
1039: FND_PROFILE.VALUE('user_id'),
1040: FND_PROFILE.VALUE('user_id'),
1041: err_msg,
1042: ret_code) ;
1043:
1036: p_eff_id,
1037: 1, -- Action_type
1038: sysdate, -- Creation_date
1039: FND_PROFILE.VALUE('user_id'),
1040: FND_PROFILE.VALUE('user_id'),
1041: err_msg,
1042: ret_code) ;
1043:
1044: -- We shall add a check for return code also if negative means an error
1169: -- Bug: 8262503 Vpedarla
1170: v_scheduling_method := p_scheduling_method;
1171:
1172: -- Vpedarla Bug: 8348883
1173: l_update_due_date := nvl(FND_PROFILE.VALUE('GMP:UPDATE_DUE_DATE_FOR_BATCHES_RESCHEDULE_BY_ASCP'),0) ;
1174:
1175: /* { */
1176: OPEN Cur_get_batch_data;
1177: FETCH Cur_get_batch_data INTO
1199: l_is_associated := 1;
1200: END IF;
1201:
1202: IF l_is_associated = 1 THEN
1203: l_profile := NVL(FND_PROFILE.VALUE('GMP_USE_MANUFACTURING_CAL'),'N');
1204: ELSE
1205: l_profile := 'N';
1206: END IF;
1207:
1520: p_organization_id,
1521: p_eff_id,
1522: 3,
1523: sysdate,
1524: FND_PROFILE.VALUE('USER_ID'),
1525: FND_PROFILE.VALUE('USER_ID'),
1526: err_msg,
1527: ret_code) ;
1528: -- We shall add a check for return code also if negative means an error
1521: p_eff_id,
1522: 3,
1523: sysdate,
1524: FND_PROFILE.VALUE('USER_ID'),
1525: FND_PROFILE.VALUE('USER_ID'),
1526: err_msg,
1527: ret_code) ;
1528: -- We shall add a check for return code also if negative means an error
1529: -- Then show a message