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_HR_EXTRACT_DATA_PVT dependencies on FND_FILE

Line 611: FND_FILE.put_line(FND_FILE.LOG,'Invalid Segments HRMS Position: '||

607: tf := FND_FLEX_EXT.GET_SEGMENTS('PER', 'POS', l_pos_id_flex_num, position_rec.position_definition_id, nsegs, segs);
608: if (tf = FALSE) then
609:
610: l_msg := FND_MESSAGE.Get;
611: FND_FILE.put_line(FND_FILE.LOG,'Invalid Segments HRMS Position: '||
612: position_rec.position_id);
613: FND_FILE.put_line(FND_FILE.LOG,l_msg);
614: FND_MESSAGE.SET_NAME('PSB','PSB_POS_DEFN_VALUE_ERROR');
615: FND_MESSAGE.SET_TOKEN('POSITION_NAME',l_position_name );

Line 613: FND_FILE.put_line(FND_FILE.LOG,l_msg);

609:
610: l_msg := FND_MESSAGE.Get;
611: FND_FILE.put_line(FND_FILE.LOG,'Invalid Segments HRMS Position: '||
612: position_rec.position_id);
613: FND_FILE.put_line(FND_FILE.LOG,l_msg);
614: FND_MESSAGE.SET_NAME('PSB','PSB_POS_DEFN_VALUE_ERROR');
615: FND_MESSAGE.SET_TOKEN('POSITION_NAME',l_position_name );
616: FND_MESSAGE.SET_TOKEN('ERR_MESG',l_msg);
617: FND_MSG_PUB.Add;

Line 4272: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Last Status::'||l_debug_info);

4268: EXCEPTION
4269:
4270: when FND_API.G_EXC_ERROR then
4271: /* Bug 4075170 Start */
4272: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Last Status::'||l_debug_info);
4273: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Parameter Info::'||l_param_info);
4274: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error Type:: FND_API.G_EXC_EXC_ERROR');
4275: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Get_Attributes API '
4276: ||'failed due to the following error');

Line 4273: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Parameter Info::'||l_param_info);

4269:
4270: when FND_API.G_EXC_ERROR then
4271: /* Bug 4075170 Start */
4272: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Last Status::'||l_debug_info);
4273: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Parameter Info::'||l_param_info);
4274: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error Type:: FND_API.G_EXC_EXC_ERROR');
4275: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Get_Attributes API '
4276: ||'failed due to the following error');
4277: FND_FILE.PUT_LINE(FND_FILE.LOG, sqlerrm);

Line 4274: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error Type:: FND_API.G_EXC_EXC_ERROR');

4270: when FND_API.G_EXC_ERROR then
4271: /* Bug 4075170 Start */
4272: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Last Status::'||l_debug_info);
4273: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Parameter Info::'||l_param_info);
4274: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error Type:: FND_API.G_EXC_EXC_ERROR');
4275: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Get_Attributes API '
4276: ||'failed due to the following error');
4277: FND_FILE.PUT_LINE(FND_FILE.LOG, sqlerrm);
4278: /* Bug 4075170 End */

Line 4275: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Get_Attributes API '

4271: /* Bug 4075170 Start */
4272: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Last Status::'||l_debug_info);
4273: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Parameter Info::'||l_param_info);
4274: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error Type:: FND_API.G_EXC_EXC_ERROR');
4275: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Get_Attributes API '
4276: ||'failed due to the following error');
4277: FND_FILE.PUT_LINE(FND_FILE.LOG, sqlerrm);
4278: /* Bug 4075170 End */
4279:

Line 4277: FND_FILE.PUT_LINE(FND_FILE.LOG, sqlerrm);

4273: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Parameter Info::'||l_param_info);
4274: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error Type:: FND_API.G_EXC_EXC_ERROR');
4275: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Get_Attributes API '
4276: ||'failed due to the following error');
4277: FND_FILE.PUT_LINE(FND_FILE.LOG, sqlerrm);
4278: /* Bug 4075170 End */
4279:
4280: if C6%isopen then
4281: close C6;

Line 4301: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Last Status::'||l_debug_info);

4297: add_message('PSB', 'PSB_ATTRIBUTE_DETAILS');
4298:
4299: when FND_API.G_EXC_UNEXPECTED_ERROR then
4300: /* Bug 4075170 Start */
4301: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Last Status::'||l_debug_info);
4302: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Parameter Info::'||l_param_info);
4303: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error Type:: FND_API.G_EXC_UNEXPECTED_ERROR');
4304: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Get_Attributes API '
4305: ||'failed due to the following error');

Line 4302: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Parameter Info::'||l_param_info);

4298:
4299: when FND_API.G_EXC_UNEXPECTED_ERROR then
4300: /* Bug 4075170 Start */
4301: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Last Status::'||l_debug_info);
4302: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Parameter Info::'||l_param_info);
4303: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error Type:: FND_API.G_EXC_UNEXPECTED_ERROR');
4304: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Get_Attributes API '
4305: ||'failed due to the following error');
4306: FND_FILE.PUT_LINE(FND_FILE.LOG, sqlerrm);

Line 4303: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error Type:: FND_API.G_EXC_UNEXPECTED_ERROR');

4299: when FND_API.G_EXC_UNEXPECTED_ERROR then
4300: /* Bug 4075170 Start */
4301: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Last Status::'||l_debug_info);
4302: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Parameter Info::'||l_param_info);
4303: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error Type:: FND_API.G_EXC_UNEXPECTED_ERROR');
4304: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Get_Attributes API '
4305: ||'failed due to the following error');
4306: FND_FILE.PUT_LINE(FND_FILE.LOG, sqlerrm);
4307: /* Bug 4075170 End */

Line 4304: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Get_Attributes API '

4300: /* Bug 4075170 Start */
4301: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Last Status::'||l_debug_info);
4302: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Parameter Info::'||l_param_info);
4303: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error Type:: FND_API.G_EXC_UNEXPECTED_ERROR');
4304: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Get_Attributes API '
4305: ||'failed due to the following error');
4306: FND_FILE.PUT_LINE(FND_FILE.LOG, sqlerrm);
4307: /* Bug 4075170 End */
4308:

Line 4306: FND_FILE.PUT_LINE(FND_FILE.LOG, sqlerrm);

4302: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Parameter Info::'||l_param_info);
4303: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error Type:: FND_API.G_EXC_UNEXPECTED_ERROR');
4304: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Get_Attributes API '
4305: ||'failed due to the following error');
4306: FND_FILE.PUT_LINE(FND_FILE.LOG, sqlerrm);
4307: /* Bug 4075170 End */
4308:
4309: if C6%isopen then
4310: close C6;

Line 4330: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Last Status::'||l_debug_info);

4326: add_message('PSB', 'PSB_ATTRIBUTE_DETAILS');
4327:
4328: when OTHERS then
4329: /* Bug 4075170 Start */
4330: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Last Status::'||l_debug_info);
4331: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Parameter Info::'||l_param_info);
4332: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error Type:: WHEN OTHERS');
4333: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Get_Attributes API '
4334: ||'failed due to the following error');

Line 4331: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Parameter Info::'||l_param_info);

4327:
4328: when OTHERS then
4329: /* Bug 4075170 Start */
4330: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Last Status::'||l_debug_info);
4331: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Parameter Info::'||l_param_info);
4332: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error Type:: WHEN OTHERS');
4333: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Get_Attributes API '
4334: ||'failed due to the following error');
4335: FND_FILE.PUT_LINE(FND_FILE.LOG, sqlerrm);

Line 4332: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error Type:: WHEN OTHERS');

4328: when OTHERS then
4329: /* Bug 4075170 Start */
4330: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Last Status::'||l_debug_info);
4331: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Parameter Info::'||l_param_info);
4332: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error Type:: WHEN OTHERS');
4333: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Get_Attributes API '
4334: ||'failed due to the following error');
4335: FND_FILE.PUT_LINE(FND_FILE.LOG, sqlerrm);
4336: /* Bug 4075170 End */

Line 4333: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Get_Attributes API '

4329: /* Bug 4075170 Start */
4330: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Last Status::'||l_debug_info);
4331: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Parameter Info::'||l_param_info);
4332: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error Type:: WHEN OTHERS');
4333: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Get_Attributes API '
4334: ||'failed due to the following error');
4335: FND_FILE.PUT_LINE(FND_FILE.LOG, sqlerrm);
4336: /* Bug 4075170 End */
4337:

Line 4335: FND_FILE.PUT_LINE(FND_FILE.LOG, sqlerrm);

4331: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Parameter Info::'||l_param_info);
4332: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error Type:: WHEN OTHERS');
4333: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Get_Attributes API '
4334: ||'failed due to the following error');
4335: FND_FILE.PUT_LINE(FND_FILE.LOG, sqlerrm);
4336: /* Bug 4075170 End */
4337:
4338: if C6%isopen then
4339: close C6;

Line 5207: FND_FILE.PUT_LINE(FND_FILE.LOG, l_message_text);

5203: IF (l_attr_link_type IS NULL) THEN
5204: FND_MESSAGE.SET_NAME('PSB','PSB_ATTR_MAPPING_NOT_FOUND');
5205: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', l_attribute_name);
5206: l_message_text := FND_MESSAGE.GET;
5207: FND_FILE.PUT_LINE(FND_FILE.LOG, l_message_text);
5208: RAISE FND_API.G_EXC_ERROR;
5209: END IF;
5210: /* End bug #4302946 */
5211:

Line 5350: FND_FILE.PUT_LINE(FND_FILE.LOG, l_message_text);

5346: IF (l_attr_link_type IS NULL) THEN
5347: FND_MESSAGE.SET_NAME('PSB','PSB_ATTR_MAPPING_NOT_FOUND');
5348: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', l_attribute_name);
5349: l_message_text := FND_MESSAGE.GET;
5350: FND_FILE.PUT_LINE(FND_FILE.LOG, l_message_text);
5351: RAISE FND_API.G_EXC_ERROR;
5352: END IF;
5353: /* End bug #4302946 */
5354:

Line 5516: FND_FILE.PUT_LINE(FND_FILE.LOG, l_message_text);

5512: IF (l_attr_link_type IS NULL) THEN
5513: FND_MESSAGE.SET_NAME('PSB','PSB_ATTR_MAPPING_NOT_FOUND');
5514: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', l_attribute_name);
5515: l_message_text := FND_MESSAGE.GET;
5516: FND_FILE.PUT_LINE(FND_FILE.LOG, l_message_text);
5517: RAISE FND_API.G_EXC_ERROR;
5518: END IF;
5519: /* End bug #4302946 */
5520:

Line 6185: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Last Status::>'||l_debug_info);

6181: EXCEPTION
6182:
6183: when FND_API.G_EXC_ERROR then
6184: /* Bug 4075170 Start */
6185: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Last Status::>'||l_debug_info);
6186: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Parameter Info::'||l_param_info);
6187: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error Type:: FND_API.G_EXC_ERROR');
6188: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Get_Employee_Attributes API '
6189: ||'failed due to the following error');

Line 6186: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Parameter Info::'||l_param_info);

6182:
6183: when FND_API.G_EXC_ERROR then
6184: /* Bug 4075170 Start */
6185: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Last Status::>'||l_debug_info);
6186: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Parameter Info::'||l_param_info);
6187: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error Type:: FND_API.G_EXC_ERROR');
6188: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Get_Employee_Attributes API '
6189: ||'failed due to the following error');
6190: FND_FILE.PUT_LINE(FND_FILE.LOG, sqlerrm);

Line 6187: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error Type:: FND_API.G_EXC_ERROR');

6183: when FND_API.G_EXC_ERROR then
6184: /* Bug 4075170 Start */
6185: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Last Status::>'||l_debug_info);
6186: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Parameter Info::'||l_param_info);
6187: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error Type:: FND_API.G_EXC_ERROR');
6188: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Get_Employee_Attributes API '
6189: ||'failed due to the following error');
6190: FND_FILE.PUT_LINE(FND_FILE.LOG, sqlerrm);
6191: /* Bug 4075170 End */

Line 6188: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Get_Employee_Attributes API '

6184: /* Bug 4075170 Start */
6185: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Last Status::>'||l_debug_info);
6186: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Parameter Info::'||l_param_info);
6187: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error Type:: FND_API.G_EXC_ERROR');
6188: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Get_Employee_Attributes API '
6189: ||'failed due to the following error');
6190: FND_FILE.PUT_LINE(FND_FILE.LOG, sqlerrm);
6191: /* Bug 4075170 End */
6192:

Line 6190: FND_FILE.PUT_LINE(FND_FILE.LOG, sqlerrm);

6186: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Parameter Info::'||l_param_info);
6187: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error Type:: FND_API.G_EXC_ERROR');
6188: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Get_Employee_Attributes API '
6189: ||'failed due to the following error');
6190: FND_FILE.PUT_LINE(FND_FILE.LOG, sqlerrm);
6191: /* Bug 4075170 End */
6192:
6193: if (dbms_sql.is_open(v_cursorid)) then
6194: dbms_sql.close_cursor(v_cursorid);

Line 6230: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Last Status::>'||l_debug_info);

6226: add_message('PSB', 'PSB_ATTRIBUTE_DETAILS');
6227:
6228: when FND_API.G_EXC_UNEXPECTED_ERROR then
6229: /* Bug 4075170 Start */
6230: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Last Status::>'||l_debug_info);
6231: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Parameter Info::'||l_param_info);
6232: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error Type:: FND_API.G_EXC_UNEXPECTED_ERROR');
6233: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Get_Employee_Attributes API '
6234: ||'failed due to the following error');

Line 6231: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Parameter Info::'||l_param_info);

6227:
6228: when FND_API.G_EXC_UNEXPECTED_ERROR then
6229: /* Bug 4075170 Start */
6230: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Last Status::>'||l_debug_info);
6231: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Parameter Info::'||l_param_info);
6232: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error Type:: FND_API.G_EXC_UNEXPECTED_ERROR');
6233: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Get_Employee_Attributes API '
6234: ||'failed due to the following error');
6235: FND_FILE.PUT_LINE(FND_FILE.LOG, sqlerrm);

Line 6232: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error Type:: FND_API.G_EXC_UNEXPECTED_ERROR');

6228: when FND_API.G_EXC_UNEXPECTED_ERROR then
6229: /* Bug 4075170 Start */
6230: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Last Status::>'||l_debug_info);
6231: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Parameter Info::'||l_param_info);
6232: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error Type:: FND_API.G_EXC_UNEXPECTED_ERROR');
6233: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Get_Employee_Attributes API '
6234: ||'failed due to the following error');
6235: FND_FILE.PUT_LINE(FND_FILE.LOG, sqlerrm);
6236: /* Bug 4075170 End */

Line 6233: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Get_Employee_Attributes API '

6229: /* Bug 4075170 Start */
6230: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Last Status::>'||l_debug_info);
6231: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Parameter Info::'||l_param_info);
6232: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error Type:: FND_API.G_EXC_UNEXPECTED_ERROR');
6233: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Get_Employee_Attributes API '
6234: ||'failed due to the following error');
6235: FND_FILE.PUT_LINE(FND_FILE.LOG, sqlerrm);
6236: /* Bug 4075170 End */
6237:

Line 6235: FND_FILE.PUT_LINE(FND_FILE.LOG, sqlerrm);

6231: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Parameter Info::'||l_param_info);
6232: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error Type:: FND_API.G_EXC_UNEXPECTED_ERROR');
6233: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Get_Employee_Attributes API '
6234: ||'failed due to the following error');
6235: FND_FILE.PUT_LINE(FND_FILE.LOG, sqlerrm);
6236: /* Bug 4075170 End */
6237:
6238: if (dbms_sql.is_open(v_cursorid)) then
6239: dbms_sql.close_cursor(v_cursorid);

Line 6275: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Last Status::>'||l_debug_info);

6271: add_message('PSB', 'PSB_ATTRIBUTE_DETAILS');
6272:
6273: when OTHERS then
6274: /* Bug 4075170 Start */
6275: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Last Status::>'||l_debug_info);
6276: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Parameter Info::'||l_param_info);
6277: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error Type:: WHEN OTHERS');
6278: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Get_Employee_Attributes API '
6279: ||'failed due to the following error');

Line 6276: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Parameter Info::'||l_param_info);

6272:
6273: when OTHERS then
6274: /* Bug 4075170 Start */
6275: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Last Status::>'||l_debug_info);
6276: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Parameter Info::'||l_param_info);
6277: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error Type:: WHEN OTHERS');
6278: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Get_Employee_Attributes API '
6279: ||'failed due to the following error');
6280: FND_FILE.PUT_LINE(FND_FILE.LOG, sqlerrm);

Line 6277: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error Type:: WHEN OTHERS');

6273: when OTHERS then
6274: /* Bug 4075170 Start */
6275: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Last Status::>'||l_debug_info);
6276: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Parameter Info::'||l_param_info);
6277: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error Type:: WHEN OTHERS');
6278: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Get_Employee_Attributes API '
6279: ||'failed due to the following error');
6280: FND_FILE.PUT_LINE(FND_FILE.LOG, sqlerrm);
6281: /* Bug 4075170 End */

Line 6278: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Get_Employee_Attributes API '

6274: /* Bug 4075170 Start */
6275: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Last Status::>'||l_debug_info);
6276: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Parameter Info::'||l_param_info);
6277: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error Type:: WHEN OTHERS');
6278: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Get_Employee_Attributes API '
6279: ||'failed due to the following error');
6280: FND_FILE.PUT_LINE(FND_FILE.LOG, sqlerrm);
6281: /* Bug 4075170 End */
6282:

Line 6280: FND_FILE.PUT_LINE(FND_FILE.LOG, sqlerrm);

6276: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Parameter Info::'||l_param_info);
6277: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error Type:: WHEN OTHERS');
6278: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Get_Employee_Attributes API '
6279: ||'failed due to the following error');
6280: FND_FILE.PUT_LINE(FND_FILE.LOG, sqlerrm);
6281: /* Bug 4075170 End */
6282:
6283: if (dbms_sql.is_open(v_cursorid)) then
6284: dbms_sql.close_cursor(v_cursorid);