APPS.JTF_RS_CONC_RES_PUB dependencies on FND_LOG

Line 32: * 1 and 6 corresponding to FND_LOG's

28: * p_message Message you want to put in log.
29: * p_prefix Prefix of the message. Default value is
30: * DEBUG.
31: * p_msg_level Message Level.Default value is 1 and the value should be between
32: * 1 and 6 corresponding to FND_LOG's
33: * LEVEL_UNEXPECTED CONSTANT NUMBER := 6;
34: * LEVEL_ERROR CONSTANT NUMBER := 5;
35: * LEVEL_EXCEPTION CONSTANT NUMBER := 4;
36: * LEVEL_EVENT CONSTANT NUMBER := 3;

Line 51: p_msg_level IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,

47:
48: PROCEDURE debug (
49: p_message IN VARCHAR2,
50: p_prefix IN VARCHAR2 DEFAULT 'DEBUG',
51: p_msg_level IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
52: p_module_prefix IN VARCHAR2 DEFAULT 'JTF_RS_Package',
53: p_module IN VARCHAR2 DEFAULT 'JTF_RS_Module'
54: ) IS
55:

Line 69: if( p_msg_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

65: ELSE
66: l_message :=SUBSTRB(p_message,1,4000);
67: END IF;
68:
69: if( p_msg_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
70: FND_LOG.STRING(p_msg_level,l_module,l_message);
71: end if;
72:
73: END debug;

Line 70: FND_LOG.STRING(p_msg_level,l_module,l_message);

66: l_message :=SUBSTRB(p_message,1,4000);
67: END IF;
68:
69: if( p_msg_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
70: FND_LOG.STRING(p_msg_level,l_module,l_message);
71: end if;
72:
73: END debug;
74:

Line 1953: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1949: l_debug_prefix VARCHAR2(30) := ' ';
1950: l_role_relate_end_date_active date;
1951: BEGIN
1952:
1953: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1954: debug(p_message=>' update_job_roles (+)',
1955: p_prefix =>l_debug_prefix,
1956: p_msg_level=>fnd_log.level_statement);
1957: END IF;

Line 1956: p_msg_level=>fnd_log.level_statement);

1952:
1953: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1954: debug(p_message=>' update_job_roles (+)',
1955: p_prefix =>l_debug_prefix,
1956: p_msg_level=>fnd_log.level_statement);
1957: END IF;
1958:
1959: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1960: debug(p_message=>' Updating Job roles for Resource Id : '||p_resource_id||' Name '||l_ppf_rec.full_name,

Line 1959: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1955: p_prefix =>l_debug_prefix,
1956: p_msg_level=>fnd_log.level_statement);
1957: END IF;
1958:
1959: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1960: debug(p_message=>' Updating Job roles for Resource Id : '||p_resource_id||' Name '||l_ppf_rec.full_name,
1961: p_prefix =>l_debug_prefix,
1962: p_msg_level=>fnd_log.level_statement);
1963: END IF;

Line 1962: p_msg_level=>fnd_log.level_statement);

1958:
1959: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1960: debug(p_message=>' Updating Job roles for Resource Id : '||p_resource_id||' Name '||l_ppf_rec.full_name,
1961: p_prefix =>l_debug_prefix,
1962: p_msg_level=>fnd_log.level_statement);
1963: END IF;
1964:
1965: l_g_miss_date := trunc(to_date('31-12-4712','DD-MM-YYYY'));
1966: l_res_roles_enddated := 'N';

Line 1980: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1976: OPEN c_salesrep_check(p_resource_id);
1977: FETCH c_salesrep_check INTO l_salesrep_extsts;
1978: CLOSE c_salesrep_check;
1979:
1980: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1981: debug(p_message=>' Sales Rep existis flag for Resource Id : '||p_resource_id||' is : '||l_salesrep_extsts,
1982: p_prefix =>l_debug_prefix,
1983: p_msg_level=>fnd_log.level_statement);
1984: END IF;

Line 1983: p_msg_level=>fnd_log.level_statement);

1979:
1980: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1981: debug(p_message=>' Sales Rep existis flag for Resource Id : '||p_resource_id||' is : '||l_salesrep_extsts,
1982: p_prefix =>l_debug_prefix,
1983: p_msg_level=>fnd_log.level_statement);
1984: END IF;
1985:
1986:
1987:

Line 1998: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1994: OPEN c_job_roles(p_new_job_id);
1995: FETCH c_job_roles INTO l_job_roles_rec;
1996: IF c_job_roles%FOUND THEN
1997:
1998: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1999: debug(p_message=>' Job Roles found for New job Id '||p_new_job_id,
2000: p_prefix =>l_debug_prefix,
2001: p_msg_level=>fnd_log.level_statement);
2002: END IF;

Line 2001: p_msg_level=>fnd_log.level_statement);

1997:
1998: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1999: debug(p_message=>' Job Roles found for New job Id '||p_new_job_id,
2000: p_prefix =>l_debug_prefix,
2001: p_msg_level=>fnd_log.level_statement);
2002: END IF;
2003:
2004: l_asg_start_date := get_asg_start_date(p_new_job_id,p_person_id,p_new_job_assignment_id,p_assignment_type);
2005:

Line 2006: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

2002: END IF;
2003:
2004: l_asg_start_date := get_asg_start_date(p_new_job_id,p_person_id,p_new_job_assignment_id,p_assignment_type);
2005:
2006: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2007: debug(p_message=>' Assignment Start Date for New job : '||l_asg_start_date,
2008: p_prefix =>l_debug_prefix,
2009: p_msg_level=>fnd_log.level_statement);
2010: END IF;

Line 2009: p_msg_level=>fnd_log.level_statement);

2005:
2006: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2007: debug(p_message=>' Assignment Start Date for New job : '||l_asg_start_date,
2008: p_prefix =>l_debug_prefix,
2009: p_msg_level=>fnd_log.level_statement);
2010: END IF;
2011:
2012: ELSE
2013:

Line 2014: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

2010: END IF;
2011:
2012: ELSE
2013:
2014: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2015: debug(p_message=>' Job Roles NOT found for New job Id '||p_new_job_id,
2016: p_prefix =>l_debug_prefix,
2017: p_msg_level=>fnd_log.level_statement);
2018: END IF;

Line 2017: p_msg_level=>fnd_log.level_statement);

2013:
2014: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2015: debug(p_message=>' Job Roles NOT found for New job Id '||p_new_job_id,
2016: p_prefix =>l_debug_prefix,
2017: p_msg_level=>fnd_log.level_statement);
2018: END IF;
2019:
2020: l_asg_start_date := NULL;
2021: END IF;

Line 2032: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

2028: OPEN c_job_roles(p_old_job_id);
2029: FETCH c_job_roles INTO l_job_roles_rec;
2030: IF c_job_roles%FOUND THEN
2031:
2032: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2033: debug(p_message=>' Job Roles found for Old job Id '||p_old_job_id,
2034: p_prefix =>l_debug_prefix,
2035: p_msg_level=>fnd_log.level_statement);
2036: END IF;

Line 2035: p_msg_level=>fnd_log.level_statement);

2031:
2032: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2033: debug(p_message=>' Job Roles found for Old job Id '||p_old_job_id,
2034: p_prefix =>l_debug_prefix,
2035: p_msg_level=>fnd_log.level_statement);
2036: END IF;
2037:
2038: OPEN c_get_assignment_id(p_old_job_id,p_person_id);
2039: FETCH c_get_assignment_id INTO l_assignment_id;

Line 2042: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

2038: OPEN c_get_assignment_id(p_old_job_id,p_person_id);
2039: FETCH c_get_assignment_id INTO l_assignment_id;
2040: CLOSE c_get_assignment_id;
2041:
2042: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2043: debug(p_message=>' Job Assignment Id for Old job Id : '||l_assignment_id,
2044: p_prefix =>l_debug_prefix,
2045: p_msg_level=>fnd_log.level_statement);
2046: END IF;

Line 2045: p_msg_level=>fnd_log.level_statement);

2041:
2042: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2043: debug(p_message=>' Job Assignment Id for Old job Id : '||l_assignment_id,
2044: p_prefix =>l_debug_prefix,
2045: p_msg_level=>fnd_log.level_statement);
2046: END IF;
2047:
2048:
2049: l_asg_end_date := get_asg_end_date(p_old_job_id,p_person_id,l_assignment_id,p_assignment_type) + l_active_days;

Line 2051: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

2047:
2048:
2049: l_asg_end_date := get_asg_end_date(p_old_job_id,p_person_id,l_assignment_id,p_assignment_type) + l_active_days;
2050:
2051: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2052: debug(p_message=>' Job Assignment End Date for Old job Id : '||l_asg_end_date,
2053: p_prefix =>l_debug_prefix,
2054: p_msg_level=>fnd_log.level_statement);
2055: END IF;

Line 2054: p_msg_level=>fnd_log.level_statement);

2050:
2051: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2052: debug(p_message=>' Job Assignment End Date for Old job Id : '||l_asg_end_date,
2053: p_prefix =>l_debug_prefix,
2054: p_msg_level=>fnd_log.level_statement);
2055: END IF;
2056:
2057:
2058: IF (l_asg_start_date is NOT NULL AND l_asg_start_date <= l_asg_end_date) THEN

Line 2066: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

2062: END IF;
2063:
2064: LOOP
2065:
2066: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2067: debug(p_message=>' Getting role Relate info for Resource :'||p_resource_id ||' and Role Id :'||l_job_roles_rec.role_id,
2068: p_prefix =>l_debug_prefix,
2069: p_msg_level=>fnd_log.level_statement);
2070: END IF;

Line 2069: p_msg_level=>fnd_log.level_statement);

2065:
2066: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2067: debug(p_message=>' Getting role Relate info for Resource :'||p_resource_id ||' and Role Id :'||l_job_roles_rec.role_id,
2068: p_prefix =>l_debug_prefix,
2069: p_msg_level=>fnd_log.level_statement);
2070: END IF;
2071:
2072: OPEN c_job_role_relations(l_job_roles_rec.role_id, p_resource_id);
2073: FETCH c_job_role_relations INTO l_job_role_relations_rec;

Line 2076: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

2072: OPEN c_job_role_relations(l_job_roles_rec.role_id, p_resource_id);
2073: FETCH c_job_role_relations INTO l_job_role_relations_rec;
2074: IF c_job_role_relations%FOUND THEN
2075:
2076: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2077: debug(p_message=>' Old job Update role Relate call for Resource :'||p_resource_id ||' and Role Id :'||l_job_roles_rec.role_id,
2078: p_prefix =>l_debug_prefix,
2079: p_msg_level=>fnd_log.level_statement);
2080: END IF;

Line 2079: p_msg_level=>fnd_log.level_statement);

2075:
2076: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2077: debug(p_message=>' Old job Update role Relate call for Resource :'||p_resource_id ||' and Role Id :'||l_job_roles_rec.role_id,
2078: p_prefix =>l_debug_prefix,
2079: p_msg_level=>fnd_log.level_statement);
2080: END IF;
2081:
2082: -- Bug13682589
2083: -- Before passing end_date_active to update_resource_role_relate

Line 2121: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

2117: fnd_msg_pub.delete_msg;
2118: fnd_file.new_line(fnd_file.log,1);
2119: raise fnd_api.g_exc_error;
2120: ELSE -- r_return_status is success
2121: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2122: debug(p_message=>'Update role Relate is Success ',
2123: p_prefix =>l_debug_prefix,
2124: p_msg_level=>fnd_log.level_statement);
2125: END IF;

Line 2124: p_msg_level=>fnd_log.level_statement);

2120: ELSE -- r_return_status is success
2121: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2122: debug(p_message=>'Update role Relate is Success ',
2123: p_prefix =>l_debug_prefix,
2124: p_msg_level=>fnd_log.level_statement);
2125: END IF;
2126: END IF;
2127: END IF;
2128: CLOSE c_job_role_relations;

Line 2141: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

2137:
2138: OPEN c_job_roles(p_new_job_id);
2139: FETCH c_job_roles INTO l_job_roles_rec;
2140: IF c_job_roles%FOUND THEN
2141: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2142: debug(p_message=>' Job roles found for New job Id '||p_new_job_id,
2143: p_prefix =>l_debug_prefix,
2144: p_msg_level=>fnd_log.level_statement);
2145: END IF;

Line 2144: p_msg_level=>fnd_log.level_statement);

2140: IF c_job_roles%FOUND THEN
2141: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2142: debug(p_message=>' Job roles found for New job Id '||p_new_job_id,
2143: p_prefix =>l_debug_prefix,
2144: p_msg_level=>fnd_log.level_statement);
2145: END IF;
2146: /* l_asg_start_date is already derived above */
2147: -- l_asg_start_date := get_asg_start_date(p_new_job_id,p_person_id,p_new_job_assignment_id,p_assignment_type);
2148: l_res_roles_enddated := 'N'; /* Initializing the flag to N for every resource. */

Line 2160: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

2156: OPEN c_existing_role_relations(l_job_roles_rec.role_id,p_resource_id,l_asg_start_date,l_asg_new_end_date);
2157: FETCH c_existing_role_relations INTO l_existing_role_relations;
2158: IF c_existing_role_relations%FOUND THEN
2159:
2160: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2161: debug(p_message=>'Job changed blk Resource is having Role Relation in date overlap of Job Assignment Start and End date. Role Relate Id :'
2162: ||l_existing_role_relations.role_relate_id,
2163: p_prefix =>l_debug_prefix,
2164: p_msg_level=>fnd_log.level_statement);

Line 2164: p_msg_level=>fnd_log.level_statement);

2160: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2161: debug(p_message=>'Job changed blk Resource is having Role Relation in date overlap of Job Assignment Start and End date. Role Relate Id :'
2162: ||l_existing_role_relations.role_relate_id,
2163: p_prefix =>l_debug_prefix,
2164: p_msg_level=>fnd_log.level_statement);
2165: END IF;
2166:
2167: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2168: debug(p_message=>'Existing Role found for Role Id '||l_job_roles_rec.role_id||' Resource Id '||p_resource_id

Line 2167: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

2163: p_prefix =>l_debug_prefix,
2164: p_msg_level=>fnd_log.level_statement);
2165: END IF;
2166:
2167: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2168: debug(p_message=>'Existing Role found for Role Id '||l_job_roles_rec.role_id||' Resource Id '||p_resource_id
2169: ||' Assignment St Date '||l_asg_start_date||' and End Date '||l_asg_new_end_date,
2170: p_prefix =>l_debug_prefix,
2171: p_msg_level=>fnd_log.level_statement);

Line 2171: p_msg_level=>fnd_log.level_statement);

2167: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2168: debug(p_message=>'Existing Role found for Role Id '||l_job_roles_rec.role_id||' Resource Id '||p_resource_id
2169: ||' Assignment St Date '||l_asg_start_date||' and End Date '||l_asg_new_end_date,
2170: p_prefix =>l_debug_prefix,
2171: p_msg_level=>fnd_log.level_statement);
2172: END IF;
2173:
2174: IF ((least(l_asg_start_date,l_existing_role_relations.start_date_active)
2175: <> l_existing_role_relations.start_date_active )

Line 2217: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

2213: --Bug13682589 End
2214:
2215: ELSE -- c_job_role_relations%NOTFOUND THEN /* no active resource role */
2216:
2217: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2218: debug(p_message=>' Role Relations not found for Resource :'||p_resource_id ||' and Role Id :'||l_job_roles_rec.role_id,
2219: p_prefix =>l_debug_prefix,
2220: p_msg_level=>fnd_log.level_statement);
2221: END IF;

Line 2220: p_msg_level=>fnd_log.level_statement);

2216:
2217: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2218: debug(p_message=>' Role Relations not found for Resource :'||p_resource_id ||' and Role Id :'||l_job_roles_rec.role_id,
2219: p_prefix =>l_debug_prefix,
2220: p_msg_level=>fnd_log.level_statement);
2221: END IF;
2222:
2223: /* Below IF loop is added to Fix bug # 3300409 */
2224: /* This loop will execute only once for a particular resource */

Line 2230: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

2226: /* This cursor will get all the roles that has an end_date greater than or equal to the start date
2227: of the new role needs to be created */
2228: FOR i in c_res_roles_enddate(p_resource_id,l_asg_start_date) LOOP
2229:
2230: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2231: debug(p_message=>' New job Update role Relate call for Resource :'||p_resource_id ||' and Role Id :'||l_job_roles_rec.role_id,
2232: p_prefix =>l_debug_prefix,
2233: p_msg_level=>fnd_log.level_statement);
2234: END IF;

Line 2233: p_msg_level=>fnd_log.level_statement);

2229:
2230: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2231: debug(p_message=>' New job Update role Relate call for Resource :'||p_resource_id ||' and Role Id :'||l_job_roles_rec.role_id,
2232: p_prefix =>l_debug_prefix,
2233: p_msg_level=>fnd_log.level_statement);
2234: END IF;
2235: -- Bug13682589
2236: -- Before passing end_date_active to update_resource_role_relat
2237: -- verifying whether start_date is greater than current role assignment start date

Line 2257: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

2253: x_msg_count => r_msg_count,
2254: x_msg_data => r_msg_data
2255: );
2256: IF ( r_return_status <> fnd_api.g_ret_sts_success) THEN
2257: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2258: debug(p_message=>'Update role Relate is errored out',
2259: p_prefix =>l_debug_prefix,
2260: p_msg_level=>fnd_log.level_statement);
2261: END IF;

Line 2260: p_msg_level=>fnd_log.level_statement);

2256: IF ( r_return_status <> fnd_api.g_ret_sts_success) THEN
2257: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2258: debug(p_message=>'Update role Relate is errored out',
2259: p_prefix =>l_debug_prefix,
2260: p_msg_level=>fnd_log.level_statement);
2261: END IF;
2262: l_role_name := NULL;
2263: OPEN c_role_name (i.role_id);
2264: FETCH c_role_name INTO l_role_name;

Line 2278: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

2274: fnd_msg_pub.delete_msg;
2275: fnd_file.new_line(fnd_file.log,1);
2276: raise fnd_api.g_exc_error;
2277: ELSE -- r_return_status is success
2278: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2279: debug(p_message=>'Update role Relate is Success ',
2280: p_prefix =>l_debug_prefix,
2281: p_msg_level=>fnd_log.level_statement);
2282: END IF;

Line 2281: p_msg_level=>fnd_log.level_statement);

2277: ELSE -- r_return_status is success
2278: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2279: debug(p_message=>'Update role Relate is Success ',
2280: p_prefix =>l_debug_prefix,
2281: p_msg_level=>fnd_log.level_statement);
2282: END IF;
2283: END IF;
2284: END LOOP;
2285: l_res_roles_enddated := 'Y';

Line 2295: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

2291: OPEN c_get_role_type(l_job_roles_rec.role_id);
2292: FETCH c_get_role_type INTO l_role_type_code;
2293: CLOSE c_get_role_type;
2294:
2295: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2296: debug(p_message=>' Role Related Code for Role Id '||l_job_roles_rec.role_id||' is '||l_role_type_code,
2297: p_prefix =>l_debug_prefix,
2298: p_msg_level=>fnd_log.level_statement);
2299: END IF;

Line 2298: p_msg_level=>fnd_log.level_statement);

2294:
2295: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2296: debug(p_message=>' Role Related Code for Role Id '||l_job_roles_rec.role_id||' is '||l_role_type_code,
2297: p_prefix =>l_debug_prefix,
2298: p_msg_level=>fnd_log.level_statement);
2299: END IF;
2300:
2301: -- Check for Sales Comp Roles and salesrep exists
2302: -- Will create the SALES_COMP roles only if the resource is a salesperson.

Line 2308: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

2304:
2305: -- To get the end date of the new job
2306: l_asg_new_end_date := get_asg_end_date(p_new_job_id,p_person_id,p_new_job_assignment_id,p_assignment_type);
2307:
2308: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2309: debug(p_message=>' Assignment End date of the new job : '||to_char(l_asg_new_end_date,'DD/MM/YYYY'),
2310: p_prefix =>l_debug_prefix,
2311: p_msg_level=>fnd_log.level_statement);
2312: END IF;

Line 2311: p_msg_level=>fnd_log.level_statement);

2307:
2308: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2309: debug(p_message=>' Assignment End date of the new job : '||to_char(l_asg_new_end_date,'DD/MM/YYYY'),
2310: p_prefix =>l_debug_prefix,
2311: p_msg_level=>fnd_log.level_statement);
2312: END IF;
2313:
2314: -- If the end date of the new job is g_miss_date, replace the date with NULL.
2315: -- Else add profile dayes to the end date

Line 2322: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

2318: else
2319: l_asg_new_end_date := l_asg_new_end_date + l_active_days;
2320: end if;
2321:
2322: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2323: debug(p_message=>' Assignment End date of the new job after calculating as per active days profile '||to_char(l_asg_new_end_date,'DD/MM/YYYY'),
2324: p_prefix =>l_debug_prefix,
2325: p_msg_level=>fnd_log.level_statement);
2326: END IF;

Line 2325: p_msg_level=>fnd_log.level_statement);

2321:
2322: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2323: debug(p_message=>' Assignment End date of the new job after calculating as per active days profile '||to_char(l_asg_new_end_date,'DD/MM/YYYY'),
2324: p_prefix =>l_debug_prefix,
2325: p_msg_level=>fnd_log.level_statement);
2326: END IF;
2327:
2328: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2329: debug(p_message=>' Creating Role Relation for Resource Id : '||p_resource_id||' and Role Id :'||l_job_roles_rec.role_id,

Line 2328: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

2324: p_prefix =>l_debug_prefix,
2325: p_msg_level=>fnd_log.level_statement);
2326: END IF;
2327:
2328: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2329: debug(p_message=>' Creating Role Relation for Resource Id : '||p_resource_id||' and Role Id :'||l_job_roles_rec.role_id,
2330: p_prefix =>l_debug_prefix,
2331: p_msg_level=>fnd_log.level_statement);
2332: END IF;

Line 2331: p_msg_level=>fnd_log.level_statement);

2327:
2328: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2329: debug(p_message=>' Creating Role Relation for Resource Id : '||p_resource_id||' and Role Id :'||l_job_roles_rec.role_id,
2330: p_prefix =>l_debug_prefix,
2331: p_msg_level=>fnd_log.level_statement);
2332: END IF;
2333:
2334:
2335: JTF_RS_ROLE_RELATE_PVT.CREATE_RESOURCE_ROLE_RELATE(

Line 2350: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

2346: x_msg_data => r_msg_data,
2347: x_role_relate_id => l_role_relate_id
2348: );
2349: IF ( r_return_status <> fnd_api.g_ret_sts_success) THEN
2350: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2351: debug(p_message=>'Creat role Relate is errored out',
2352: p_prefix =>l_debug_prefix,
2353: p_msg_level=>fnd_log.level_statement);
2354: END IF;

Line 2353: p_msg_level=>fnd_log.level_statement);

2349: IF ( r_return_status <> fnd_api.g_ret_sts_success) THEN
2350: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2351: debug(p_message=>'Creat role Relate is errored out',
2352: p_prefix =>l_debug_prefix,
2353: p_msg_level=>fnd_log.level_statement);
2354: END IF;
2355: l_role_name := NULL;
2356: OPEN c_role_name (l_job_roles_rec.role_id);
2357: FETCH c_role_name INTO l_role_name;

Line 2371: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

2367: fnd_msg_pub.delete_msg;
2368: fnd_file.new_line(fnd_file.log,1);
2369: raise fnd_api.g_exc_error;
2370: ELSE --r_return_status is success
2371: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2372: debug(p_message=>'Create role Relate is Success and Role Relate Id is '||l_role_relate_id,
2373: p_prefix =>l_debug_prefix,
2374: p_msg_level=>fnd_log.level_statement);
2375: END IF;

Line 2374: p_msg_level=>fnd_log.level_statement);

2370: ELSE --r_return_status is success
2371: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2372: debug(p_message=>'Create role Relate is Success and Role Relate Id is '||l_role_relate_id,
2373: p_prefix =>l_debug_prefix,
2374: p_msg_level=>fnd_log.level_statement);
2375: END IF;
2376: END IF;
2377: end if; -- Check for Sales Comp Roles and salesrep exists
2378: END IF;

Line 2388: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

2384: CLOSE c_job_roles;
2385:
2386: ELSE /*Job not changed*/
2387:
2388: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2389: debug(p_message=>' Job not changed block',
2390: p_prefix =>l_debug_prefix,
2391: p_msg_level=>fnd_log.level_statement);
2392: END IF;

Line 2391: p_msg_level=>fnd_log.level_statement);

2387:
2388: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2389: debug(p_message=>' Job not changed block',
2390: p_prefix =>l_debug_prefix,
2391: p_msg_level=>fnd_log.level_statement);
2392: END IF;
2393:
2394:
2395: OPEN c_job_roles(p_new_job_id);

Line 2399: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

2395: OPEN c_job_roles(p_new_job_id);
2396: FETCH c_job_roles INTO l_job_roles_rec;
2397: IF c_job_roles%FOUND THEN /* all the roles from job roles */
2398:
2399: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2400: debug(p_message=>' Job Roles found for New job Id '||p_new_job_id,
2401: p_prefix =>l_debug_prefix,
2402: p_msg_level=>fnd_log.level_statement);
2403: END IF;

Line 2402: p_msg_level=>fnd_log.level_statement);

2398:
2399: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2400: debug(p_message=>' Job Roles found for New job Id '||p_new_job_id,
2401: p_prefix =>l_debug_prefix,
2402: p_msg_level=>fnd_log.level_statement);
2403: END IF;
2404:
2405:
2406: l_asg_start_date := get_asg_start_date(p_new_job_id,p_person_id,p_new_job_assignment_id,p_assignment_type);

Line 2409: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

2405:
2406: l_asg_start_date := get_asg_start_date(p_new_job_id,p_person_id,p_new_job_assignment_id,p_assignment_type);
2407: l_res_roles_enddated := 'N'; /* Initializing the flag to N for every resource. */
2408:
2409: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2410: debug(p_message=>' Assignment Start Date for new job id : '|| to_char(l_asg_start_date,'DD/MM/YYYY'),
2411: p_prefix =>l_debug_prefix,
2412: p_msg_level=>fnd_log.level_statement);
2413: END IF;

Line 2412: p_msg_level=>fnd_log.level_statement);

2408:
2409: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2410: debug(p_message=>' Assignment Start Date for new job id : '|| to_char(l_asg_start_date,'DD/MM/YYYY'),
2411: p_prefix =>l_debug_prefix,
2412: p_msg_level=>fnd_log.level_statement);
2413: END IF;
2414:
2415:
2416: LOOP

Line 2421: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

2417: OPEN c_job_role_relations(l_job_roles_rec.role_id,p_resource_id);
2418: FETCH c_job_role_relations INTO l_job_role_relations_rec;
2419: IF c_job_role_relations%NOTFOUND THEN /* no active resource role */
2420:
2421: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2422: debug(p_message=>' Job Role Relations not found for Resource :'||p_resource_id ||' and Role Id :'||l_job_roles_rec.role_id,
2423: p_prefix =>l_debug_prefix,
2424: p_msg_level=>fnd_log.level_statement);
2425: END IF;

Line 2424: p_msg_level=>fnd_log.level_statement);

2420:
2421: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2422: debug(p_message=>' Job Role Relations not found for Resource :'||p_resource_id ||' and Role Id :'||l_job_roles_rec.role_id,
2423: p_prefix =>l_debug_prefix,
2424: p_msg_level=>fnd_log.level_statement);
2425: END IF;
2426:
2427:
2428: -- Below cursor will retrive the role_type_code for a role id

Line 2433: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

2429: l_role_type_code := NULL;
2430: OPEN c_get_role_type(l_job_roles_rec.role_id);
2431: FETCH c_get_role_type INTO l_role_type_code;
2432: CLOSE c_get_role_type;
2433: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2434: debug(p_message=>' Role Type Code for Role Id '||l_job_roles_rec.role_id||' is '||l_role_type_code,
2435: p_prefix =>l_debug_prefix,
2436: p_msg_level=>fnd_log.level_statement);
2437: END IF;

Line 2436: p_msg_level=>fnd_log.level_statement);

2432: CLOSE c_get_role_type;
2433: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2434: debug(p_message=>' Role Type Code for Role Id '||l_job_roles_rec.role_id||' is '||l_role_type_code,
2435: p_prefix =>l_debug_prefix,
2436: p_msg_level=>fnd_log.level_statement);
2437: END IF;
2438:
2439:
2440: -- Check for Sales Comp Roles and salesrep exists

Line 2447: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

2443:
2444: -- To get the end date of the new job
2445: l_asg_new_end_date := get_asg_end_date(p_new_job_id,p_person_id,p_new_job_assignment_id,p_assignment_type);
2446:
2447: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2448: debug(p_message=>' Assignment End date of the new job : '||to_char(l_asg_new_end_date,'DD/MM/YYYY'),
2449: p_prefix =>l_debug_prefix,
2450: p_msg_level=>fnd_log.level_statement);
2451: END IF;

Line 2450: p_msg_level=>fnd_log.level_statement);

2446:
2447: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2448: debug(p_message=>' Assignment End date of the new job : '||to_char(l_asg_new_end_date,'DD/MM/YYYY'),
2449: p_prefix =>l_debug_prefix,
2450: p_msg_level=>fnd_log.level_statement);
2451: END IF;
2452:
2453:
2454: -- If the end date of the new job is g_miss_date, replace the date with NULL.

Line 2463: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

2459: l_asg_new_end_date := l_asg_new_end_date + l_active_days;
2460: end if;
2461:
2462:
2463: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2464: debug(p_message=>' Assignment End date of the new job after calculating as per active days profile : '||to_char(l_asg_new_end_date,'DD/MM/YYYY'),
2465: p_prefix =>l_debug_prefix,
2466: p_msg_level=>fnd_log.level_statement);
2467: END IF;

Line 2466: p_msg_level=>fnd_log.level_statement);

2462:
2463: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2464: debug(p_message=>' Assignment End date of the new job after calculating as per active days profile : '||to_char(l_asg_new_end_date,'DD/MM/YYYY'),
2465: p_prefix =>l_debug_prefix,
2466: p_msg_level=>fnd_log.level_statement);
2467: END IF;
2468: --Bug13682589 Start
2469:
2470: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 2470: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

2466: p_msg_level=>fnd_log.level_statement);
2467: END IF;
2468: --Bug13682589 Start
2469:
2470: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2471: debug(p_message=>'Data proceesing for Role Id '||l_job_roles_rec.role_id||' Resource Id '||p_resource_id
2472: ||' Job asg start date '||l_asg_start_date||' Job asg End Date '||l_asg_new_end_date,
2473: p_prefix =>l_debug_prefix,
2474: p_msg_level=>fnd_log.level_statement);

Line 2474: p_msg_level=>fnd_log.level_statement);

2470: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2471: debug(p_message=>'Data proceesing for Role Id '||l_job_roles_rec.role_id||' Resource Id '||p_resource_id
2472: ||' Job asg start date '||l_asg_start_date||' Job asg End Date '||l_asg_new_end_date,
2473: p_prefix =>l_debug_prefix,
2474: p_msg_level=>fnd_log.level_statement);
2475: END IF;
2476:
2477: OPEN c_existing_role_relations(l_job_roles_rec.role_id,p_resource_id,l_asg_start_date,l_asg_new_end_date);
2478: FETCH c_existing_role_relations INTO l_existing_role_relations;

Line 2481: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

2477: OPEN c_existing_role_relations(l_job_roles_rec.role_id,p_resource_id,l_asg_start_date,l_asg_new_end_date);
2478: FETCH c_existing_role_relations INTO l_existing_role_relations;
2479: IF c_existing_role_relations%FOUND THEN
2480:
2481: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2482: debug(p_message=>'Resource is having Role Relation in date overlap of Job Assignment Start and End date. Role Relate Id :'
2483: ||l_existing_role_relations.role_relate_id,
2484: p_prefix =>l_debug_prefix,
2485: p_msg_level=>fnd_log.level_statement);

Line 2485: p_msg_level=>fnd_log.level_statement);

2481: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2482: debug(p_message=>'Resource is having Role Relation in date overlap of Job Assignment Start and End date. Role Relate Id :'
2483: ||l_existing_role_relations.role_relate_id,
2484: p_prefix =>l_debug_prefix,
2485: p_msg_level=>fnd_log.level_statement);
2486: END IF;
2487:
2488: JTF_RS_ROLE_RELATE_PVT.UPDATE_RESOURCE_ROLE_RELATE(
2489: p_api_version => 1.0,

Line 2522: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

2518: --Bug13682589 End
2519:
2520: ELSE -- c_existing_role_relations Not Found
2521: -- No role relate found between job assignment Start and End Dates.
2522: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2523: debug(p_message=>' CREATE_RESOURCE_ROLE_RELATE call for Resource Id : '||p_resource_id||' and Role Id :'||l_job_roles_rec.role_id,
2524: p_prefix =>l_debug_prefix,
2525: p_msg_level=>fnd_log.level_statement);
2526: END IF;

Line 2525: p_msg_level=>fnd_log.level_statement);

2521: -- No role relate found between job assignment Start and End Dates.
2522: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2523: debug(p_message=>' CREATE_RESOURCE_ROLE_RELATE call for Resource Id : '||p_resource_id||' and Role Id :'||l_job_roles_rec.role_id,
2524: p_prefix =>l_debug_prefix,
2525: p_msg_level=>fnd_log.level_statement);
2526: END IF;
2527: JTF_RS_ROLE_RELATE_PVT.CREATE_RESOURCE_ROLE_RELATE(
2528: p_api_version => 1.0,
2529: p_init_msg_list => fnd_api.g_true,

Line 2542: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

2538: x_msg_data => r_msg_data,
2539: x_role_relate_id => l_role_relate_id
2540: );
2541: IF ( r_return_status <> fnd_api.g_ret_sts_success) THEN
2542: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2543: debug(p_message=>'Create role Relate Errored out.',
2544: p_prefix =>l_debug_prefix,
2545: p_msg_level=>fnd_log.level_statement);
2546: END IF;

Line 2545: p_msg_level=>fnd_log.level_statement);

2541: IF ( r_return_status <> fnd_api.g_ret_sts_success) THEN
2542: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2543: debug(p_message=>'Create role Relate Errored out.',
2544: p_prefix =>l_debug_prefix,
2545: p_msg_level=>fnd_log.level_statement);
2546: END IF;
2547: l_role_name := NULL;
2548: OPEN c_role_name (l_job_roles_rec.role_id);
2549: FETCH c_role_name INTO l_role_name;

Line 2563: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

2559: fnd_msg_pub.delete_msg;
2560: fnd_file.new_line(fnd_file.log,1);
2561: raise fnd_api.g_exc_error;
2562: ELSE
2563: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2564: debug(p_message=>'Create role Relate is Success and Role Relate Id is '||l_role_relate_id,
2565: p_prefix =>l_debug_prefix,
2566: p_msg_level=>fnd_log.level_statement);
2567: END IF;

Line 2566: p_msg_level=>fnd_log.level_statement);

2562: ELSE
2563: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2564: debug(p_message=>'Create role Relate is Success and Role Relate Id is '||l_role_relate_id,
2565: p_prefix =>l_debug_prefix,
2566: p_msg_level=>fnd_log.level_statement);
2567: END IF;
2568: END IF;
2569:
2570: END IF; --c_existing_role_relations

Line 2602: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

2598: IF c_get_assignment_id%ISOPEN THEN
2599: CLOSE c_get_assignment_id;
2600: END IF;
2601:
2602: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2603: debug(p_message=>' Update_job_roles (-)',
2604: p_prefix =>l_debug_prefix,
2605: p_msg_level=>fnd_log.level_statement);
2606: END IF;

Line 2605: p_msg_level=>fnd_log.level_statement);

2601:
2602: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2603: debug(p_message=>' Update_job_roles (-)',
2604: p_prefix =>l_debug_prefix,
2605: p_msg_level=>fnd_log.level_statement);
2606: END IF;
2607:
2608: END update_job_roles;
2609:

Line 2620: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

2616: l_activate_salesreps := 'N';
2617: l_user_id := nvl(FND_GLOBAL.USER_ID,-1);
2618: l_login := nvl(FND_GLOBAL.LOGIN_ID,-1);
2619:
2620: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2621: debug(p_message=>' update_employee (+)',
2622: p_prefix =>l_debug_prefix,
2623: p_msg_level=>fnd_log.level_statement);
2624: END IF;

Line 2623: p_msg_level=>fnd_log.level_statement);

2619:
2620: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2621: debug(p_message=>' update_employee (+)',
2622: p_prefix =>l_debug_prefix,
2623: p_msg_level=>fnd_log.level_statement);
2624: END IF;
2625:
2626: --Standard Start of API SAVEPOINT
2627:

Line 2638: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

2634: FOR l_c_resource IN c_resource LOOP
2635: BEGIN
2636: SAVEPOINT update_resource_sp;
2637:
2638: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2639: debug(p_message=>' Processing for Resource Id '||l_c_resource.resource_id,
2640: p_prefix =>l_debug_prefix,
2641: p_msg_level=>fnd_log.level_statement);
2642: END IF;

Line 2641: p_msg_level=>fnd_log.level_statement);

2637:
2638: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2639: debug(p_message=>' Processing for Resource Id '||l_c_resource.resource_id,
2640: p_prefix =>l_debug_prefix,
2641: p_msg_level=>fnd_log.level_statement);
2642: END IF;
2643:
2644:
2645: l_rehire_rev_emp_flag := 'N';