eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PSB_POSITION_CONTROL_PVT dependencies on FND_FILE

Line 2722: -- fnd_file.put_line(fnd_file.log, ' Position start date : '||l_pos_start_date); -- commented as part of fix 4507389

2718: WHERE psb_pos.position_id = p_source_DE_position_id;
2719: */
2720:
2721:
2722: -- fnd_file.put_line(fnd_file.log, ' Position start date : '||l_pos_start_date); -- commented as part of fix 4507389
2723:
2724: /* Bug 4060926 End */
2725:
2726: -- Now the SDE is containing the manipulated distributions. Fetch

Line 3002: FND_FILE.PUT_LINE(FND_FILE.LOG, l_debug_info);

2998:
2999: EXCEPTION
3000: WHEN FND_API.G_EXC_ERROR THEN
3001: /* Bug 4060926 Star */
3002: FND_FILE.PUT_LINE(FND_FILE.LOG, l_debug_info);
3003: /* Bug 4060926 End */
3004: ROLLBACK TO Upload_Salary_Position;
3005: x_return_status := FND_API.G_RET_STS_ERROR;
3006: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3008: FND_FILE.PUT_LINE(FND_FILE.LOG, l_debug_info);

3004: ROLLBACK TO Upload_Salary_Position;
3005: x_return_status := FND_API.G_RET_STS_ERROR;
3006: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3007: /* Bug 4060926 Star */
3008: FND_FILE.PUT_LINE(FND_FILE.LOG, l_debug_info);
3009: /* Bug 4060926 End */
3010: ROLLBACK TO Upload_Salary_Position;
3011: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3012: WHEN OTHERS THEN

Line 3014: FND_FILE.PUT_LINE(FND_FILE.LOG, l_debug_info);

3010: ROLLBACK TO Upload_Salary_Position;
3011: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3012: WHEN OTHERS THEN
3013: /* Bug 4060926 Star */
3014: FND_FILE.PUT_LINE(FND_FILE.LOG, l_debug_info);
3015: /* Bug 4060926 End */
3016: ROLLBACK TO Upload_Salary_Position;
3017: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3018: END Upload_Salary_Distribution;

Line 6175: PSB_MESSAGE_S.Print_Error (p_mode => FND_FILE.LOG,

6171:
6172: EXCEPTION
6173:
6174: when FND_API.G_EXC_ERROR then
6175: PSB_MESSAGE_S.Print_Error (p_mode => FND_FILE.LOG,
6176: p_print_header => FND_API.G_TRUE);
6177: retcode := 2;
6178:
6179: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 6180: PSB_MESSAGE_S.Print_Error (p_mode => FND_FILE.LOG,

6176: p_print_header => FND_API.G_TRUE);
6177: retcode := 2;
6178:
6179: when FND_API.G_EXC_UNEXPECTED_ERROR then
6180: PSB_MESSAGE_S.Print_Error (p_mode => FND_FILE.LOG,
6181: p_print_header => FND_API.G_TRUE);
6182: retcode := 2;
6183:
6184: when OTHERS then

Line 6190: PSB_MESSAGE_S.Print_Error (p_mode => FND_FILE.LOG,

6186: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
6187: l_api_name);
6188: end if;
6189:
6190: PSB_MESSAGE_S.Print_Error (p_mode => FND_FILE.LOG,
6191: p_print_header => FND_API.G_TRUE);
6192: retcode := 2;
6193:
6194: END Upload_Worksheet_CP;

Line 8915: fnd_file.put_line(fnd_file.log, ' Element : '||l_element_name||' , Position id : '|| l_hr_position_id);

8911:
8912: /* start bug 3666828 */
8913: l_hr_position_id := p_hr_position_id;
8914: l_element_name := l_dist.name(l_dist_index);
8915: fnd_file.put_line(fnd_file.log, ' Element : '||l_element_name||' , Position id : '|| l_hr_position_id);
8916: /* End bug 3666828 */
8917:
8918: FND_MSG_PUB.Add;
8919: raise FND_API.G_EXC_ERROR;

Line 9063: fnd_file.put_line(fnd_file.log, 'Element : '||l_element_name||' , Position id : '|| l_hr_position_id);

9059:
9060: /* start bug 3666828 */
9061: l_hr_position_id := p_hr_position_id;
9062: l_element_name := l_dist.name(l_dist_index);
9063: fnd_file.put_line(fnd_file.log, 'Element : '||l_element_name||' , Position id : '|| l_hr_position_id);
9064: /* End bug 3666828 */
9065:
9066: FND_MSG_PUB.Add;
9067: raise FND_API.G_EXC_ERROR;

Line 11037: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Position Name : '||l_position_name||' Position ID :'||l_positions.hr_position_id(l_position_index));

11033: p_end_date => p_end_date);
11034:
11035: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
11036: /* Start Bug 3666828 */
11037: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Position Name : '||l_position_name||' Position ID :'||l_positions.hr_position_id(l_position_index));
11038: /* End Bug 3666828 */
11039:
11040: raise FND_API.G_EXC_ERROR;
11041: end if;

Line 12003: FND_FILE.put_line(FND_FILE.LOG, 'Updating Table PSB_ATTRIBUTE_VALUES');

11999: if l_syscount >= l_usrcount then
12000: begin
12001:
12002: /* Number of system org attribute records more than user defined org attribute records */
12003: FND_FILE.put_line(FND_FILE.LOG, 'Updating Table PSB_ATTRIBUTE_VALUES');
12004: Update psb_attribute_values
12005: set attribute_id = l_sysorg_id
12006: where attribute_id = p_attribute_id;
12007:

Line 12008: FND_FILE.put_line(FND_FILE.LOG, 'Updating Table PSB_ATTRIBUTE_VALUES_I');

12004: Update psb_attribute_values
12005: set attribute_id = l_sysorg_id
12006: where attribute_id = p_attribute_id;
12007:
12008: FND_FILE.put_line(FND_FILE.LOG, 'Updating Table PSB_ATTRIBUTE_VALUES_I');
12009: Update psb_attribute_values_i
12010: set attribute_id = l_sysorg_id
12011: where attribute_id = p_attribute_id;
12012:

Line 12013: FND_FILE.put_line(FND_FILE.LOG, 'Updating Table PSB_ACCOUNT_POSITION_SET_LINES');

12009: Update psb_attribute_values_i
12010: set attribute_id = l_sysorg_id
12011: where attribute_id = p_attribute_id;
12012:
12013: FND_FILE.put_line(FND_FILE.LOG, 'Updating Table PSB_ACCOUNT_POSITION_SET_LINES');
12014: update psb_account_position_set_lines
12015: set attribute_id = l_sysorg_id
12016: where attribute_id = p_attribute_id;
12017:

Line 12018: FND_FILE.put_line(FND_FILE.LOG, 'Updating Table PSB_PARAMETER_FORMULAS');

12014: update psb_account_position_set_lines
12015: set attribute_id = l_sysorg_id
12016: where attribute_id = p_attribute_id;
12017:
12018: FND_FILE.put_line(FND_FILE.LOG, 'Updating Table PSB_PARAMETER_FORMULAS');
12019: Update psb_parameter_formulas
12020: set attribute_id = l_sysorg_id
12021: where attribute_id = p_attribute_id;
12022:

Line 12026: FND_FILE.put_line(FND_FILE.LOG, 'Updating Table PSB_DEFAULT_ASSIGNMENTS');

12022:
12023: -- Bug#4466903
12024: -- Removed call to update psb_dss_dimension_mappings.
12025:
12026: FND_FILE.put_line(FND_FILE.LOG, 'Updating Table PSB_DEFAULT_ASSIGNMENTS');
12027: Update psb_default_assignments
12028: set attribute_id = l_sysorg_id
12029: where attribute_id = p_attribute_id;
12030:

Line 12031: FND_FILE.put_line(FND_FILE.LOG, 'Updating Table PSB_POSITION_ASSIGNMENTS');

12027: Update psb_default_assignments
12028: set attribute_id = l_sysorg_id
12029: where attribute_id = p_attribute_id;
12030:
12031: FND_FILE.put_line(FND_FILE.LOG, 'Updating Table PSB_POSITION_ASSIGNMENTS');
12032: Update psb_position_assignments
12033: set attribute_id = l_sysorg_id
12034: where attribute_id = p_attribute_id;
12035:

Line 12036: FND_FILE.put_line(FND_FILE.LOG, 'Updating Table PSB_ATTRIBUTES_TL');

12032: Update psb_position_assignments
12033: set attribute_id = l_sysorg_id
12034: where attribute_id = p_attribute_id;
12035:
12036: FND_FILE.put_line(FND_FILE.LOG, 'Updating Table PSB_ATTRIBUTES_TL');
12037: Delete from psb_attributes_tl
12038: where attribute_id = p_attribute_id;
12039:
12040: FND_FILE.put_line(FND_FILE.LOG, 'Updating Table PSB_ATTRIBUTES');

Line 12040: FND_FILE.put_line(FND_FILE.LOG, 'Updating Table PSB_ATTRIBUTES');

12036: FND_FILE.put_line(FND_FILE.LOG, 'Updating Table PSB_ATTRIBUTES_TL');
12037: Delete from psb_attributes_tl
12038: where attribute_id = p_attribute_id;
12039:
12040: FND_FILE.put_line(FND_FILE.LOG, 'Updating Table PSB_ATTRIBUTES');
12041: Delete from psb_attributes
12042: where attribute_id = p_attribute_id;
12043:
12044: end;

Line 12049: FND_FILE.put_line(FND_FILE.LOG, 'Updating Table PSB_ATTRIBUTE_VALUES');

12045: else
12046: begin
12047:
12048: /* Number of system org attribute records less than user defined org attribute records */
12049: FND_FILE.put_line(FND_FILE.LOG, 'Updating Table PSB_ATTRIBUTE_VALUES');
12050: Update psb_attribute_values
12051: set attribute_id = p_attribute_id
12052: where attribute_id = l_sysorg_id;
12053:

Line 12054: FND_FILE.put_line(FND_FILE.LOG, 'Updating Table PSB_ATTRIBUTE_VALUES_I');

12050: Update psb_attribute_values
12051: set attribute_id = p_attribute_id
12052: where attribute_id = l_sysorg_id;
12053:
12054: FND_FILE.put_line(FND_FILE.LOG, 'Updating Table PSB_ATTRIBUTE_VALUES_I');
12055: Update psb_attribute_values_i
12056: set attribute_id = p_attribute_id
12057: where attribute_id = l_sysorg_id;
12058:

Line 12059: FND_FILE.put_line(FND_FILE.LOG, 'Updating Table PSB_ACCOUNT_POSITION_SET_LINES');

12055: Update psb_attribute_values_i
12056: set attribute_id = p_attribute_id
12057: where attribute_id = l_sysorg_id;
12058:
12059: FND_FILE.put_line(FND_FILE.LOG, 'Updating Table PSB_ACCOUNT_POSITION_SET_LINES');
12060: update psb_account_position_set_lines
12061: set attribute_id = p_attribute_id
12062: where attribute_id = l_sysorg_id;
12063:

Line 12064: FND_FILE.put_line(FND_FILE.LOG, 'Updating Table PSB_PARAMETER_FORMULAS');

12060: update psb_account_position_set_lines
12061: set attribute_id = p_attribute_id
12062: where attribute_id = l_sysorg_id;
12063:
12064: FND_FILE.put_line(FND_FILE.LOG, 'Updating Table PSB_PARAMETER_FORMULAS');
12065: Update psb_parameter_formulas
12066: set attribute_id = p_attribute_id
12067: where attribute_id = l_sysorg_id;
12068:

Line 12072: FND_FILE.put_line(FND_FILE.LOG, 'Updating Table PSB_DEFAULT_ASSIGNMENTS');

12068:
12069: -- Bug#4466903
12070: -- Removed call to update psb_dss_dimension_mappings.
12071:
12072: FND_FILE.put_line(FND_FILE.LOG, 'Updating Table PSB_DEFAULT_ASSIGNMENTS');
12073: Update psb_default_assignments
12074: set attribute_id = p_attribute_id
12075: where attribute_id = l_sysorg_id;
12076:

Line 12077: FND_FILE.put_line(FND_FILE.LOG, 'Updating Table PSB_POSITION_ASSIGNMENTS');

12073: Update psb_default_assignments
12074: set attribute_id = p_attribute_id
12075: where attribute_id = l_sysorg_id;
12076:
12077: FND_FILE.put_line(FND_FILE.LOG, 'Updating Table PSB_POSITION_ASSIGNMENTS');
12078: Update psb_position_assignments
12079: set attribute_id = p_attribute_id
12080: where attribute_id = l_sysorg_id;
12081:

Line 12082: FND_FILE.put_line(FND_FILE.LOG, 'Updating Table PSB_ATTRIBUTES_TL');

12078: Update psb_position_assignments
12079: set attribute_id = p_attribute_id
12080: where attribute_id = l_sysorg_id;
12081:
12082: FND_FILE.put_line(FND_FILE.LOG, 'Updating Table PSB_ATTRIBUTES_TL');
12083: Delete from psb_attributes_tl
12084: where attribute_id = p_attribute_id;
12085:
12086: Update psb_attributes_tl

Line 12090: FND_FILE.put_line(FND_FILE.LOG, 'Updating Table PSB_ATTRIBUTES');

12086: Update psb_attributes_tl
12087: set attribute_id = p_attribute_id
12088: where attribute_id = l_sysorg_id;
12089:
12090: FND_FILE.put_line(FND_FILE.LOG, 'Updating Table PSB_ATTRIBUTES');
12091: Delete from psb_attributes
12092: where attribute_id = p_attribute_id;
12093:
12094: Update psb_attributes

Line 12192: PSB_MESSAGE_S.Print_Error (p_mode => FND_FILE.LOG,

12188:
12189: EXCEPTION
12190:
12191: when FND_API.G_EXC_ERROR then
12192: PSB_MESSAGE_S.Print_Error (p_mode => FND_FILE.LOG,
12193: p_print_header => FND_API.G_TRUE);
12194: retcode := 2;
12195:
12196: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 12197: PSB_MESSAGE_S.Print_Error (p_mode => FND_FILE.LOG,

12193: p_print_header => FND_API.G_TRUE);
12194: retcode := 2;
12195:
12196: when FND_API.G_EXC_UNEXPECTED_ERROR then
12197: PSB_MESSAGE_S.Print_Error (p_mode => FND_FILE.LOG,
12198: p_print_header => FND_API.G_TRUE);
12199: retcode := 2;
12200:
12201: when OTHERS then

Line 12207: PSB_MESSAGE_S.Print_Error (p_mode => FND_FILE.LOG,

12203: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
12204: l_api_name);
12205: end if;
12206:
12207: PSB_MESSAGE_S.Print_Error (p_mode => FND_FILE.LOG,
12208: p_print_header => FND_API.G_TRUE);
12209: retcode := 2;
12210:
12211: END Convert_Organization_Attr_CP;