3411: l_site_use_id:=p_site_use_id;
3412: END IF;
3413:
3414: -------------get profile values:
3415: l_source_org_id := FND_PROFILE.VALUE('ORG_ID');
3416: l_source_user_id := FND_PROFILE.VALUE ('USER_ID');
3417: l_source_resp_id := FND_PROFILE.VALUE ('RESP_ID');
3418: l_source_appln_id := FND_PROFILE.VALUE ('RESP_APPL_ID');
3419: l_source_security_group_id := FND_PROFILE.VALUE('SECURITY_GROUP_ID');
3412: END IF;
3413:
3414: -------------get profile values:
3415: l_source_org_id := FND_PROFILE.VALUE('ORG_ID');
3416: l_source_user_id := FND_PROFILE.VALUE ('USER_ID');
3417: l_source_resp_id := FND_PROFILE.VALUE ('RESP_ID');
3418: l_source_appln_id := FND_PROFILE.VALUE ('RESP_APPL_ID');
3419: l_source_security_group_id := FND_PROFILE.VALUE('SECURITY_GROUP_ID');
3420:
3413:
3414: -------------get profile values:
3415: l_source_org_id := FND_PROFILE.VALUE('ORG_ID');
3416: l_source_user_id := FND_PROFILE.VALUE ('USER_ID');
3417: l_source_resp_id := FND_PROFILE.VALUE ('RESP_ID');
3418: l_source_appln_id := FND_PROFILE.VALUE ('RESP_APPL_ID');
3419: l_source_security_group_id := FND_PROFILE.VALUE('SECURITY_GROUP_ID');
3420:
3421: IF G_debug_flag = 'Y'
3414: -------------get profile values:
3415: l_source_org_id := FND_PROFILE.VALUE('ORG_ID');
3416: l_source_user_id := FND_PROFILE.VALUE ('USER_ID');
3417: l_source_resp_id := FND_PROFILE.VALUE ('RESP_ID');
3418: l_source_appln_id := FND_PROFILE.VALUE ('RESP_APPL_ID');
3419: l_source_security_group_id := FND_PROFILE.VALUE('SECURITY_GROUP_ID');
3420:
3421: IF G_debug_flag = 'Y'
3422: THEN
3415: l_source_org_id := FND_PROFILE.VALUE('ORG_ID');
3416: l_source_user_id := FND_PROFILE.VALUE ('USER_ID');
3417: l_source_resp_id := FND_PROFILE.VALUE ('RESP_ID');
3418: l_source_appln_id := FND_PROFILE.VALUE ('RESP_APPL_ID');
3419: l_source_security_group_id := FND_PROFILE.VALUE('SECURITY_GROUP_ID');
3420:
3421: IF G_debug_flag = 'Y'
3422: THEN
3423: OE_DEBUG_PUB.Add('Calling Create_credit_request,
4220: l_site_use_id := c_site.site_use_id;
4221: END IF;
4222:
4223: -------------get profile values:
4224: l_source_org_id := p_header_rec.org_id; /* MOAC ORG_ID CHANGE */ --FND_PROFILE.VALUE('ORG_ID');
4225: l_source_user_id := FND_PROFILE.VALUE ('USER_ID');
4226: l_source_resp_id := FND_PROFILE.VALUE ('RESP_ID');
4227: l_source_appln_id := FND_PROFILE.VALUE ('RESP_APPL_ID');
4228: l_source_security_group_id :=
4221: END IF;
4222:
4223: -------------get profile values:
4224: l_source_org_id := p_header_rec.org_id; /* MOAC ORG_ID CHANGE */ --FND_PROFILE.VALUE('ORG_ID');
4225: l_source_user_id := FND_PROFILE.VALUE ('USER_ID');
4226: l_source_resp_id := FND_PROFILE.VALUE ('RESP_ID');
4227: l_source_appln_id := FND_PROFILE.VALUE ('RESP_APPL_ID');
4228: l_source_security_group_id :=
4229: FND_PROFILE.VALUE('SECURITY_GROUP_ID');
4222:
4223: -------------get profile values:
4224: l_source_org_id := p_header_rec.org_id; /* MOAC ORG_ID CHANGE */ --FND_PROFILE.VALUE('ORG_ID');
4225: l_source_user_id := FND_PROFILE.VALUE ('USER_ID');
4226: l_source_resp_id := FND_PROFILE.VALUE ('RESP_ID');
4227: l_source_appln_id := FND_PROFILE.VALUE ('RESP_APPL_ID');
4228: l_source_security_group_id :=
4229: FND_PROFILE.VALUE('SECURITY_GROUP_ID');
4230:
4223: -------------get profile values:
4224: l_source_org_id := p_header_rec.org_id; /* MOAC ORG_ID CHANGE */ --FND_PROFILE.VALUE('ORG_ID');
4225: l_source_user_id := FND_PROFILE.VALUE ('USER_ID');
4226: l_source_resp_id := FND_PROFILE.VALUE ('RESP_ID');
4227: l_source_appln_id := FND_PROFILE.VALUE ('RESP_APPL_ID');
4228: l_source_security_group_id :=
4229: FND_PROFILE.VALUE('SECURITY_GROUP_ID');
4230:
4231: IF G_debug_flag = 'Y'
4225: l_source_user_id := FND_PROFILE.VALUE ('USER_ID');
4226: l_source_resp_id := FND_PROFILE.VALUE ('RESP_ID');
4227: l_source_appln_id := FND_PROFILE.VALUE ('RESP_APPL_ID');
4228: l_source_security_group_id :=
4229: FND_PROFILE.VALUE('SECURITY_GROUP_ID');
4230:
4231: IF G_debug_flag = 'Y'
4232: THEN
4233: OE_DEBUG_PUB.Add('Calling Create_credit_request,