DBA Data[Home] [Help]

APPS.PSP_ADJ_DRIVER dependencies on FND_GLOBAL

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

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 -------------------------------

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

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: --------------------------------------------------------------------

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

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:

Line 2142: fnd_global.user_id,

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;

Line 2143: fnd_global.login_id,

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:

Line 2144: fnd_global.user_id,

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

Line 2207: fnd_global.user_id,

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,

Line 2208: fnd_global.login_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,

Line 2209: fnd_global.user_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

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

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.

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

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: ---------------------------------------------------------------------------------

Line 2434: fnd_global.user_id,

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,

Line 2435: fnd_global.login_id,

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,

Line 2436: fnd_global.user_id,

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,

Line 2519: fnd_global.user_id,

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,

Line 2520: fnd_global.login_id,

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,

Line 2521: fnd_global.user_id,

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,

Line 3225: fnd_global.user_id,

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,

Line 3226: fnd_global.login_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,
3230: ptds.attribute_category, -- Introduced DFF columns for bug fix 2908859

Line 3227: fnd_global.user_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
3231: ptds.attribute1,

Line 3403: fnd_global.user_id,

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,

Line 3404: fnd_global.login_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,
3408: dest.attribute_category, --Introduced DFF columns for bug fix 2908859

Line 3405: fnd_global.user_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
3409: dest.attribute1,

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

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:

Line 4095: fnd_global.user_id,

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;

Line 4096: fnd_global.login_id,

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:

Line 4097: fnd_global.user_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:
4101: EXCEPTION

Line 4128: LAST_UPDATED_BY = fnd_global.user_id,

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

Line 4129: LAST_UPDATE_LOGIN = fnd_global.login_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;