1306: fnd_msg_pub.get(p_msg_index => FND_MSG_PUB.G_FIRST,
1307: p_encoded => FND_API.G_FALSE,
1308: p_data => l_msg_data,
1309: p_msg_index_out => l_msg_count);
1310: errbuf := l_msg_data || fnd_global.local_chr(10) || g_error_api_path;
1311: retcode := 2;
1312: END;
1313:
1314: ----------P R O C E D U R E: GET_APPROVAL_HEADER -------------------------------
1454: fnd_msg_pub.get(p_msg_index => FND_MSG_PUB.G_FIRST,
1455: p_encoded => FND_API.G_FALSE,
1456: p_data => l_msg_data,
1457: p_msg_index_out => l_msg_count);
1458: errbuf := l_msg_data || fnd_global.local_chr(10) || g_error_api_path;
1459: retcode := 2;
1460:
1461: END;
1462: --------------------------------------------------------------------
1991: fnd_msg_pub.get(p_msg_index => FND_MSG_PUB.G_FIRST,
1992: p_encoded => FND_API.G_FALSE,
1993: p_data => l_msg_data,
1994: p_msg_index_out => l_msg_count);
1995: errbuf := l_msg_data || fnd_global.local_chr(10) || g_error_api_path;
1996: retcode := 2;
1997: END;
1998: -------------------------------------------------------------
1999:
2138: null,
2139: null,
2140: null,
2141: sysdate,
2142: fnd_global.user_id,
2143: fnd_global.login_id,
2144: fnd_global.user_id,
2145: sysdate);
2146: p_return_status := fnd_api.g_ret_sts_success;
2139: null,
2140: null,
2141: sysdate,
2142: fnd_global.user_id,
2143: fnd_global.login_id,
2144: fnd_global.user_id,
2145: sysdate);
2146: p_return_status := fnd_api.g_ret_sts_success;
2147:
2140: null,
2141: sysdate,
2142: fnd_global.user_id,
2143: fnd_global.login_id,
2144: fnd_global.user_id,
2145: sysdate);
2146: p_return_status := fnd_api.g_ret_sts_success;
2147:
2148: EXCEPTION
2203: p_batch_name,
2204: p_batch_comments,
2205: p_gl_posting_override_date,
2206: sysdate,
2207: fnd_global.user_id,
2208: fnd_global.login_id,
2209: fnd_global.user_id,
2210: sysdate,
2211: p_person_id,
2204: p_batch_comments,
2205: p_gl_posting_override_date,
2206: sysdate,
2207: fnd_global.user_id,
2208: fnd_global.login_id,
2209: fnd_global.user_id,
2210: sysdate,
2211: p_person_id,
2212: p_assignment_id,
2205: p_gl_posting_override_date,
2206: sysdate,
2207: fnd_global.user_id,
2208: fnd_global.login_id,
2209: fnd_global.user_id,
2210: sysdate,
2211: p_person_id,
2212: p_assignment_id,
2213: --- p_element_type_id, commented for DA-ENH
2258: fnd_msg_pub.initialize;
2259: errbuf := '';
2260: update psp_adjustment_control_table
2261: set comments = p_comments,
2262: approver_id = FND_GLOBAL.USER_ID, -- 1087529
2263: approval_date = SYSDATE -- Added to fix bug 1661405. approval_date is a new column added to the table
2264: where adjustment_batch_name = p_batch_name;
2265:
2266: --Modified by Rashmi to update psp_payroll_control table.
2277: fnd_msg_pub.get(p_msg_index => FND_MSG_PUB.G_FIRST,
2278: p_encoded => FND_API.G_FALSE,
2279: p_data => l_msg_data,
2280: p_msg_index_out => l_msg_count);
2281: errbuf := l_msg_data || fnd_global.local_chr(10) || g_error_api_path;
2282: retcode := 2;
2283:
2284: end;
2285: ---------------------------------------------------------------------------------
2430: l_tot_dr,
2431: l_tot_cr,
2432: 'C',
2433: sysdate,
2434: fnd_global.user_id,
2435: fnd_global.login_id,
2436: fnd_global.user_id,
2437: sysdate,
2438: null,
2431: l_tot_cr,
2432: 'C',
2433: sysdate,
2434: fnd_global.user_id,
2435: fnd_global.login_id,
2436: fnd_global.user_id,
2437: sysdate,
2438: null,
2439: p_gl_posting_override_date,
2432: 'C',
2433: sysdate,
2434: fnd_global.user_id,
2435: fnd_global.login_id,
2436: fnd_global.user_id,
2437: sysdate,
2438: null,
2439: p_gl_posting_override_date,
2440: null,
2515: l_tot_dr,
2516: l_tot_cr,
2517: 'C',
2518: sysdate,
2519: fnd_global.user_id,
2520: fnd_global.login_id,
2521: fnd_global.user_id,
2522: sysdate,
2523: null,
2516: l_tot_cr,
2517: 'C',
2518: sysdate,
2519: fnd_global.user_id,
2520: fnd_global.login_id,
2521: fnd_global.user_id,
2522: sysdate,
2523: null,
2524: p_gl_posting_override_date,
2517: 'C',
2518: sysdate,
2519: fnd_global.user_id,
2520: fnd_global.login_id,
2521: fnd_global.user_id,
2522: sysdate,
2523: null,
2524: p_gl_posting_override_date,
2525: null,
3221: ptol.orig_line_id,
3222: p_business_group_id,
3223: ptds.adj_set_number,
3224: sysdate,
3225: fnd_global.user_id,
3226: fnd_global.login_id,
3227: fnd_global.user_id,
3228: sysdate,
3229: ptds.line_number,
3222: p_business_group_id,
3223: ptds.adj_set_number,
3224: sysdate,
3225: fnd_global.user_id,
3226: fnd_global.login_id,
3227: fnd_global.user_id,
3228: sysdate,
3229: ptds.line_number,
3230: ptds.attribute_category, -- Introduced DFF columns for bug fix 2908859
3223: ptds.adj_set_number,
3224: sysdate,
3225: fnd_global.user_id,
3226: fnd_global.login_id,
3227: fnd_global.user_id,
3228: sysdate,
3229: ptds.line_number,
3230: ptds.attribute_category, -- Introduced DFF columns for bug fix 2908859
3231: ptds.attribute1,
3399: LINES.orig_line_id,
3400: p_business_group_id,
3401: DEST.adj_set_number,
3402: sysdate,
3403: fnd_global.user_id,
3404: fnd_global.login_id,
3405: fnd_global.user_id,
3406: sysdate,
3407: DEST.line_number,
3400: p_business_group_id,
3401: DEST.adj_set_number,
3402: sysdate,
3403: fnd_global.user_id,
3404: fnd_global.login_id,
3405: fnd_global.user_id,
3406: sysdate,
3407: DEST.line_number,
3408: dest.attribute_category, --Introduced DFF columns for bug fix 2908859
3401: DEST.adj_set_number,
3402: sysdate,
3403: fnd_global.user_id,
3404: fnd_global.login_id,
3405: fnd_global.user_id,
3406: sysdate,
3407: DEST.line_number,
3408: dest.attribute_category, --Introduced DFF columns for bug fix 2908859
3409: dest.attribute1,
4035: fnd_msg_pub.get(p_msg_index => FND_MSG_PUB.G_FIRST,
4036: p_encoded => FND_API.G_FALSE,
4037: p_data => l_msg_data,
4038: p_msg_index_out => l_msg_count);
4039: errbuf := errbuf || l_msg_data || fnd_global.local_chr(10) || g_error_api_path;
4040: retcode := 2;
4041:
4042: end generate_lines;
4043:
4091: p_comments,
4092: p_business_group_id,
4093: p_set_of_books_id,
4094: sysdate,
4095: fnd_global.user_id,
4096: fnd_global.login_id,
4097: fnd_global.user_id,
4098: sysdate,
4099: p_payroll_id) RETURNING rowid into p_rowid;
4092: p_business_group_id,
4093: p_set_of_books_id,
4094: sysdate,
4095: fnd_global.user_id,
4096: fnd_global.login_id,
4097: fnd_global.user_id,
4098: sysdate,
4099: p_payroll_id) RETURNING rowid into p_rowid;
4100:
4093: p_set_of_books_id,
4094: sysdate,
4095: fnd_global.user_id,
4096: fnd_global.login_id,
4097: fnd_global.user_id,
4098: sysdate,
4099: p_payroll_id) RETURNING rowid into p_rowid;
4100:
4101: EXCEPTION
4124: comments = p_comments,
4125: business_group_id = p_business_group_id,
4126: set_of_books_id = p_set_of_books_id,
4127: LAST_UPDATE_DATE = sysdate,
4128: LAST_UPDATED_BY = fnd_global.user_id,
4129: LAST_UPDATE_LOGIN = fnd_global.login_id,
4130: payroll_id = p_payroll_id
4131: where business_group_id = p_business_group_id
4132: AND set_of_books_id = p_set_of_books_id
4125: business_group_id = p_business_group_id,
4126: set_of_books_id = p_set_of_books_id,
4127: LAST_UPDATE_DATE = sysdate,
4128: LAST_UPDATED_BY = fnd_global.user_id,
4129: LAST_UPDATE_LOGIN = fnd_global.login_id,
4130: payroll_id = p_payroll_id
4131: where business_group_id = p_business_group_id
4132: AND set_of_books_id = p_set_of_books_id
4133: AND rowid = p_rowid;