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.AK_ON_OBJECTS_PVT dependencies on AK_LOADER_TEMP

Line 2113: -- Get total number of records in AK_LOADER_TEMP

2109: end if;
2110:
2111: --dbms_output.put_line(to_char(l_timestamp));
2112:
2113: -- Get total number of records in AK_LOADER_TEMP
2114: --
2115: select count(*) into G_UPL_TABLE_NUM
2116: from AK_LOADER_TEMP;
2117:

Line 2116: from AK_LOADER_TEMP;

2112:
2113: -- Get total number of records in AK_LOADER_TEMP
2114: --
2115: select count(*) into G_UPL_TABLE_NUM
2116: from AK_LOADER_TEMP;
2117:
2118: l_lines_read := 0;
2119:
2120: --

Line 2139: OPEN l_upl_loader_cur FOR SELECT TBL_INDEX,LINE_CONTENT FROM ak_loader_temp

2135:
2136: --dbms_output.put_line('**** Processing pass # ' || to_char(l_index) || ' ****');
2137:
2138: -- Open Upload Loader Cursor
2139: OPEN l_upl_loader_cur FOR SELECT TBL_INDEX,LINE_CONTENT FROM ak_loader_temp
2140: where session_id = AK_ON_OBJECTS_PVT.G_SESSION_ID
2141: order by tbl_index;
2142:
2143: while (l_buffer is null and l_eof_flag = 'N' and l_tbl_index <= G_UPL_TABLE_NUM) loop

Line 3460: -- Write all lines from buffer to ak_loader_temp table.

3456: G_TBL_INDEX := 0;
3457: end if;
3458:
3459: --
3460: -- Write all lines from buffer to ak_loader_temp table.
3461: -- And break long lines into mulitple lines in the file.
3462: --
3463: G_WRITE_MODE := p_write_mode;
3464:

Line 3481: -- write line to a physical temporary table (AK_LOADER_TEMP) in database

3477: l_buffer := SUBSTR(p_buffer_tbl(l_index),
3478: l_buf_written + 1, l_char_to_write) ||
3479: '\';
3480: --
3481: -- write line to a physical temporary table (AK_LOADER_TEMP) in database
3482: --
3483: WRITE_TO_TABLE (
3484: p_buffer => l_buffer);
3485: else

Line 3494: -- write line to a physical temporary table (AK_LOADER_TEMP) in database

3490: l_buffer := SUBSTR(p_buffer_tbl(l_index),
3491: l_buf_written + 1, l_char_to_write);
3492:
3493: --
3494: -- write line to a physical temporary table (AK_LOADER_TEMP) in database
3495: --
3496: WRITE_TO_TABLE (
3497: p_buffer => l_buffer);
3498: end if;

Line 3634: -- Insert into AK_LOADER_TEMP

3630: SUBSTR (SQLERRM, 1, 240) );
3631: end WRITE_LOG_FILE;
3632:
3633:
3634: -- Insert into AK_LOADER_TEMP
3635: --
3636: procedure WRITE_TO_TABLE (
3637: p_buffer IN VARCHAR2
3638: ) is

Line 3644: INSERT INTO ak_loader_temp (

3640: err_num NUMBER;
3641: err_msg VARCHAR2(100);
3642: l_api_name CONSTANT varchar2(30) := 'Write_To_Table';
3643: begin
3644: INSERT INTO ak_loader_temp (
3645: tbl_index,
3646: line_content,
3647: session_id
3648: ) values (

Line 3655: -- dbms_output.put_line('no rows has been inserted into ak_loader_temp');

3651: AK_ON_OBJECTS_PVT.G_SESSION_ID
3652: );
3653:
3654: if SQL%ROWCOUNT = 0 then
3655: -- dbms_output.put_line('no rows has been inserted into ak_loader_temp');
3656: raise insert_err;
3657: elsif SQL%NOTFOUND then
3658: -- dbms_output.put_line('Error SQL%NOTFOUND');
3659: raise insert_err;

Line 3666: -- dbms_output.put_line('Exception insert_err ak_loader_temp');

3662: -- commit;
3663:
3664: EXCEPTION
3665: WHEN insert_err THEN
3666: -- dbms_output.put_line('Exception insert_err ak_loader_temp');
3667: FND_MESSAGE.SET_NAME('AK','AK_LOADER_TEMP_EXCEPTION');
3668: FND_MSG_PUB.Add;
3669: WHEN OTHERS THEN
3670: FND_MESSAGE.SET_NAME('AK','AK_LOADER_TEMP_ERROR');

Line 3667: FND_MESSAGE.SET_NAME('AK','AK_LOADER_TEMP_EXCEPTION');

3663:
3664: EXCEPTION
3665: WHEN insert_err THEN
3666: -- dbms_output.put_line('Exception insert_err ak_loader_temp');
3667: FND_MESSAGE.SET_NAME('AK','AK_LOADER_TEMP_EXCEPTION');
3668: FND_MSG_PUB.Add;
3669: WHEN OTHERS THEN
3670: FND_MESSAGE.SET_NAME('AK','AK_LOADER_TEMP_ERROR');
3671: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

Line 3670: FND_MESSAGE.SET_NAME('AK','AK_LOADER_TEMP_ERROR');

3666: -- dbms_output.put_line('Exception insert_err ak_loader_temp');
3667: FND_MESSAGE.SET_NAME('AK','AK_LOADER_TEMP_EXCEPTION');
3668: FND_MSG_PUB.Add;
3669: WHEN OTHERS THEN
3670: FND_MESSAGE.SET_NAME('AK','AK_LOADER_TEMP_ERROR');
3671: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
3672: SUBSTR (SQLERRM, 1, 240) );
3673: FND_MSG_PUB.Add;
3674: -- err_num := SQLCODE;

Line 3676: -- dbms_output.put_line('Other errors in inserting into ak_loader_temp');

3672: SUBSTR (SQLERRM, 1, 240) );
3673: FND_MSG_PUB.Add;
3674: -- err_num := SQLCODE;
3675: -- err_msg := SUBSTR(SQLERRM, 1, 100);
3676: -- dbms_output.put_line('Other errors in inserting into ak_loader_temp');
3677: -- dbms_output.put_line(to_char(err_num)||' '||err_msg);
3678:
3679: end WRITE_TO_TABLE;
3680: