2909: END IF;
2910:
2911: -------------get profile values:
2912: l_source_org_id := p_header_rec.org_id; /* MOAC ORG_ID CHANGE */
2913: -- l_source_org_id := FND_PROFILE.VALUE('ORG_ID');
2914: l_source_user_id := FND_PROFILE.VALUE ('USER_ID');
2915: l_source_resp_id := FND_PROFILE.VALUE ('RESP_ID');
2916: l_source_appln_id := FND_PROFILE.VALUE ('RESP_APPL_ID');
2917: l_source_security_group_id
2910:
2911: -------------get profile values:
2912: l_source_org_id := p_header_rec.org_id; /* MOAC ORG_ID CHANGE */
2913: -- l_source_org_id := FND_PROFILE.VALUE('ORG_ID');
2914: l_source_user_id := FND_PROFILE.VALUE ('USER_ID');
2915: l_source_resp_id := FND_PROFILE.VALUE ('RESP_ID');
2916: l_source_appln_id := FND_PROFILE.VALUE ('RESP_APPL_ID');
2917: l_source_security_group_id
2918: := FND_PROFILE.VALUE('SECURITY_GROUP_ID');
2911: -------------get profile values:
2912: l_source_org_id := p_header_rec.org_id; /* MOAC ORG_ID CHANGE */
2913: -- l_source_org_id := FND_PROFILE.VALUE('ORG_ID');
2914: l_source_user_id := FND_PROFILE.VALUE ('USER_ID');
2915: l_source_resp_id := FND_PROFILE.VALUE ('RESP_ID');
2916: l_source_appln_id := FND_PROFILE.VALUE ('RESP_APPL_ID');
2917: l_source_security_group_id
2918: := FND_PROFILE.VALUE('SECURITY_GROUP_ID');
2919:
2912: l_source_org_id := p_header_rec.org_id; /* MOAC ORG_ID CHANGE */
2913: -- l_source_org_id := FND_PROFILE.VALUE('ORG_ID');
2914: l_source_user_id := FND_PROFILE.VALUE ('USER_ID');
2915: l_source_resp_id := FND_PROFILE.VALUE ('RESP_ID');
2916: l_source_appln_id := FND_PROFILE.VALUE ('RESP_APPL_ID');
2917: l_source_security_group_id
2918: := FND_PROFILE.VALUE('SECURITY_GROUP_ID');
2919:
2920: IF G_debug_flag = 'Y'
2914: l_source_user_id := FND_PROFILE.VALUE ('USER_ID');
2915: l_source_resp_id := FND_PROFILE.VALUE ('RESP_ID');
2916: l_source_appln_id := FND_PROFILE.VALUE ('RESP_APPL_ID');
2917: l_source_security_group_id
2918: := FND_PROFILE.VALUE('SECURITY_GROUP_ID');
2919:
2920: IF G_debug_flag = 'Y'
2921: THEN
2922: OE_DEBUG_PUB.Add('Calling Create_credit_request,