DBA Data[Home] [Help]

APPS.PSP_ADJ_DRIVER dependencies on FND_GLOBAL

Line 1316: errbuf := l_msg_data || fnd_global.local_chr(10) || g_error_api_path;

1312: fnd_msg_pub.get(p_msg_index => FND_MSG_PUB.G_FIRST,
1313: p_encoded => FND_API.G_FALSE,
1314: p_data => l_msg_data,
1315: p_msg_index_out => l_msg_count);
1316: errbuf := l_msg_data || fnd_global.local_chr(10) || g_error_api_path;
1317: retcode := 2;
1318: END;
1319:
1320: ----------P R O C E D U R E: GET_APPROVAL_HEADER -------------------------------

Line 1467: errbuf := l_msg_data || fnd_global.local_chr(10) || g_error_api_path;

1463: fnd_msg_pub.get(p_msg_index => FND_MSG_PUB.G_FIRST,
1464: p_encoded => FND_API.G_FALSE,
1465: p_data => l_msg_data,
1466: p_msg_index_out => l_msg_count);
1467: errbuf := l_msg_data || fnd_global.local_chr(10) || g_error_api_path;
1468: retcode := 2;
1469:
1470: END;
1471: --------------------------------------------------------------------

Line 2004: errbuf := l_msg_data || fnd_global.local_chr(10) || g_error_api_path;

2000: fnd_msg_pub.get(p_msg_index => FND_MSG_PUB.G_FIRST,
2001: p_encoded => FND_API.G_FALSE,
2002: p_data => l_msg_data,
2003: p_msg_index_out => l_msg_count);
2004: errbuf := l_msg_data || fnd_global.local_chr(10) || g_error_api_path;
2005: retcode := 2;
2006: END;
2007: -------------------------------------------------------------
2008:

Line 2151: fnd_global.user_id,

2147: null,
2148: null,
2149: null,
2150: sysdate,
2151: fnd_global.user_id,
2152: fnd_global.login_id,
2153: fnd_global.user_id,
2154: sysdate);
2155: p_return_status := fnd_api.g_ret_sts_success;

Line 2152: fnd_global.login_id,

2148: null,
2149: null,
2150: sysdate,
2151: fnd_global.user_id,
2152: fnd_global.login_id,
2153: fnd_global.user_id,
2154: sysdate);
2155: p_return_status := fnd_api.g_ret_sts_success;
2156:

Line 2153: fnd_global.user_id,

2149: null,
2150: sysdate,
2151: fnd_global.user_id,
2152: fnd_global.login_id,
2153: fnd_global.user_id,
2154: sysdate);
2155: p_return_status := fnd_api.g_ret_sts_success;
2156:
2157: EXCEPTION

Line 2216: fnd_global.user_id,

2212: p_batch_name,
2213: p_batch_comments,
2214: p_gl_posting_override_date,
2215: sysdate,
2216: fnd_global.user_id,
2217: fnd_global.login_id,
2218: fnd_global.user_id,
2219: sysdate,
2220: p_person_id,

Line 2217: fnd_global.login_id,

2213: p_batch_comments,
2214: p_gl_posting_override_date,
2215: sysdate,
2216: fnd_global.user_id,
2217: fnd_global.login_id,
2218: fnd_global.user_id,
2219: sysdate,
2220: p_person_id,
2221: p_assignment_id,

Line 2218: fnd_global.user_id,

2214: p_gl_posting_override_date,
2215: sysdate,
2216: fnd_global.user_id,
2217: fnd_global.login_id,
2218: fnd_global.user_id,
2219: sysdate,
2220: p_person_id,
2221: p_assignment_id,
2222: --- p_element_type_id, commented for DA-ENH

Line 2271: approver_id = FND_GLOBAL.USER_ID, -- 1087529

2267: fnd_msg_pub.initialize;
2268: errbuf := '';
2269: update psp_adjustment_control_table
2270: set comments = p_comments,
2271: approver_id = FND_GLOBAL.USER_ID, -- 1087529
2272: approval_date = SYSDATE -- Added to fix bug 1661405. approval_date is a new column added to the table
2273: where adjustment_batch_name = p_batch_name;
2274:
2275: --Modified by Rashmi to update psp_payroll_control table.

Line 2290: errbuf := l_msg_data || fnd_global.local_chr(10) || g_error_api_path;

2286: fnd_msg_pub.get(p_msg_index => FND_MSG_PUB.G_FIRST,
2287: p_encoded => FND_API.G_FALSE,
2288: p_data => l_msg_data,
2289: p_msg_index_out => l_msg_count);
2290: errbuf := l_msg_data || fnd_global.local_chr(10) || g_error_api_path;
2291: retcode := 2;
2292:
2293: end;
2294: ---------------------------------------------------------------------------------

Line 2443: fnd_global.user_id,

2439: l_tot_dr,
2440: l_tot_cr,
2441: 'C',
2442: sysdate,
2443: fnd_global.user_id,
2444: fnd_global.login_id,
2445: fnd_global.user_id,
2446: sysdate,
2447: null,

Line 2444: fnd_global.login_id,

2440: l_tot_cr,
2441: 'C',
2442: sysdate,
2443: fnd_global.user_id,
2444: fnd_global.login_id,
2445: fnd_global.user_id,
2446: sysdate,
2447: null,
2448: p_gl_posting_override_date,

Line 2445: fnd_global.user_id,

2441: 'C',
2442: sysdate,
2443: fnd_global.user_id,
2444: fnd_global.login_id,
2445: fnd_global.user_id,
2446: sysdate,
2447: null,
2448: p_gl_posting_override_date,
2449: null,

Line 2528: fnd_global.user_id,

2524: l_tot_dr,
2525: l_tot_cr,
2526: 'C',
2527: sysdate,
2528: fnd_global.user_id,
2529: fnd_global.login_id,
2530: fnd_global.user_id,
2531: sysdate,
2532: null,

Line 2529: fnd_global.login_id,

2525: l_tot_cr,
2526: 'C',
2527: sysdate,
2528: fnd_global.user_id,
2529: fnd_global.login_id,
2530: fnd_global.user_id,
2531: sysdate,
2532: null,
2533: p_gl_posting_override_date,

Line 2530: fnd_global.user_id,

2526: 'C',
2527: sysdate,
2528: fnd_global.user_id,
2529: fnd_global.login_id,
2530: fnd_global.user_id,
2531: sysdate,
2532: null,
2533: p_gl_posting_override_date,
2534: null,

Line 3234: fnd_global.user_id,

3230: ptol.orig_line_id,
3231: p_business_group_id,
3232: ptds.adj_set_number,
3233: sysdate,
3234: fnd_global.user_id,
3235: fnd_global.login_id,
3236: fnd_global.user_id,
3237: sysdate,
3238: ptds.line_number,

Line 3235: fnd_global.login_id,

3231: p_business_group_id,
3232: ptds.adj_set_number,
3233: sysdate,
3234: fnd_global.user_id,
3235: fnd_global.login_id,
3236: fnd_global.user_id,
3237: sysdate,
3238: ptds.line_number,
3239: ptds.attribute_category, -- Introduced DFF columns for bug fix 2908859

Line 3236: fnd_global.user_id,

3232: ptds.adj_set_number,
3233: sysdate,
3234: fnd_global.user_id,
3235: fnd_global.login_id,
3236: fnd_global.user_id,
3237: sysdate,
3238: ptds.line_number,
3239: ptds.attribute_category, -- Introduced DFF columns for bug fix 2908859
3240: ptds.attribute1,

Line 3412: fnd_global.user_id,

3408: LINES.orig_line_id,
3409: p_business_group_id,
3410: DEST.adj_set_number,
3411: sysdate,
3412: fnd_global.user_id,
3413: fnd_global.login_id,
3414: fnd_global.user_id,
3415: sysdate,
3416: DEST.line_number,

Line 3413: fnd_global.login_id,

3409: p_business_group_id,
3410: DEST.adj_set_number,
3411: sysdate,
3412: fnd_global.user_id,
3413: fnd_global.login_id,
3414: fnd_global.user_id,
3415: sysdate,
3416: DEST.line_number,
3417: dest.attribute_category, --Introduced DFF columns for bug fix 2908859

Line 3414: fnd_global.user_id,

3410: DEST.adj_set_number,
3411: sysdate,
3412: fnd_global.user_id,
3413: fnd_global.login_id,
3414: fnd_global.user_id,
3415: sysdate,
3416: DEST.line_number,
3417: dest.attribute_category, --Introduced DFF columns for bug fix 2908859
3418: dest.attribute1,

Line 4048: errbuf := errbuf || l_msg_data || fnd_global.local_chr(10) || g_error_api_path;

4044: fnd_msg_pub.get(p_msg_index => FND_MSG_PUB.G_FIRST,
4045: p_encoded => FND_API.G_FALSE,
4046: p_data => l_msg_data,
4047: p_msg_index_out => l_msg_count);
4048: errbuf := errbuf || l_msg_data || fnd_global.local_chr(10) || g_error_api_path;
4049: retcode := 2;
4050:
4051: end generate_lines;
4052:

Line 4104: fnd_global.user_id,

4100: p_comments,
4101: p_business_group_id,
4102: p_set_of_books_id,
4103: sysdate,
4104: fnd_global.user_id,
4105: fnd_global.login_id,
4106: fnd_global.user_id,
4107: sysdate,
4108: p_payroll_id) RETURNING rowid into p_rowid;

Line 4105: fnd_global.login_id,

4101: p_business_group_id,
4102: p_set_of_books_id,
4103: sysdate,
4104: fnd_global.user_id,
4105: fnd_global.login_id,
4106: fnd_global.user_id,
4107: sysdate,
4108: p_payroll_id) RETURNING rowid into p_rowid;
4109:

Line 4106: fnd_global.user_id,

4102: p_set_of_books_id,
4103: sysdate,
4104: fnd_global.user_id,
4105: fnd_global.login_id,
4106: fnd_global.user_id,
4107: sysdate,
4108: p_payroll_id) RETURNING rowid into p_rowid;
4109:
4110: EXCEPTION

Line 4137: LAST_UPDATED_BY = fnd_global.user_id,

4133: comments = p_comments,
4134: business_group_id = p_business_group_id,
4135: set_of_books_id = p_set_of_books_id,
4136: LAST_UPDATE_DATE = sysdate,
4137: LAST_UPDATED_BY = fnd_global.user_id,
4138: LAST_UPDATE_LOGIN = fnd_global.login_id,
4139: payroll_id = p_payroll_id
4140: where business_group_id = p_business_group_id
4141: AND set_of_books_id = p_set_of_books_id

Line 4138: LAST_UPDATE_LOGIN = fnd_global.login_id,

4134: business_group_id = p_business_group_id,
4135: set_of_books_id = p_set_of_books_id,
4136: LAST_UPDATE_DATE = sysdate,
4137: LAST_UPDATED_BY = fnd_global.user_id,
4138: LAST_UPDATE_LOGIN = fnd_global.login_id,
4139: payroll_id = p_payroll_id
4140: where business_group_id = p_business_group_id
4141: AND set_of_books_id = p_set_of_books_id
4142: AND rowid = p_rowid;