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 2105: -- Get total number of records in AK_LOADER_TEMP

2101: end if;
2102:
2103: --dbms_output.put_line(to_char(l_timestamp));
2104:
2105: -- Get total number of records in AK_LOADER_TEMP
2106: --
2107: select count(*) into G_UPL_TABLE_NUM
2108: from AK_LOADER_TEMP;
2109:

Line 2108: from AK_LOADER_TEMP;

2104:
2105: -- Get total number of records in AK_LOADER_TEMP
2106: --
2107: select count(*) into G_UPL_TABLE_NUM
2108: from AK_LOADER_TEMP;
2109:
2110: l_lines_read := 0;
2111:
2112: --

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

2127:
2128: --dbms_output.put_line('**** Processing pass # ' || to_char(l_index) || ' ****');
2129:
2130: -- Open Upload Loader Cursor
2131: OPEN l_upl_loader_cur FOR SELECT TBL_INDEX,LINE_CONTENT FROM ak_loader_temp
2132: where session_id = AK_ON_OBJECTS_PVT.G_SESSION_ID
2133: order by tbl_index;
2134:
2135: while (l_buffer is null and l_eof_flag = 'N' and l_tbl_index <= G_UPL_TABLE_NUM) loop

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

3361: G_TBL_INDEX := 0;
3362: end if;
3363:
3364: --
3365: -- Write all lines from buffer to ak_loader_temp table.
3366: -- And break long lines into mulitple lines in the file.
3367: --
3368: G_WRITE_MODE := p_write_mode;
3369:

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

3382: l_buffer := SUBSTR(p_buffer_tbl(l_index),
3383: l_buf_written + 1, l_char_to_write) ||
3384: '\';
3385: --
3386: -- write line to a physical temporary table (AK_LOADER_TEMP) in database
3387: --
3388: WRITE_TO_TABLE (
3389: p_buffer => l_buffer);
3390: else

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

3395: l_buffer := SUBSTR(p_buffer_tbl(l_index),
3396: l_buf_written + 1, l_char_to_write);
3397:
3398: --
3399: -- write line to a physical temporary table (AK_LOADER_TEMP) in database
3400: --
3401: WRITE_TO_TABLE (
3402: p_buffer => l_buffer);
3403: end if;

Line 3539: -- Insert into AK_LOADER_TEMP

3535: SUBSTR (SQLERRM, 1, 240) );
3536: end WRITE_LOG_FILE;
3537:
3538:
3539: -- Insert into AK_LOADER_TEMP
3540: --
3541: procedure WRITE_TO_TABLE (
3542: p_buffer IN VARCHAR2
3543: ) is

Line 3549: INSERT INTO ak_loader_temp (

3545: err_num NUMBER;
3546: err_msg VARCHAR2(100);
3547: l_api_name CONSTANT varchar2(30) := 'Write_To_Table';
3548: begin
3549: INSERT INTO ak_loader_temp (
3550: tbl_index,
3551: line_content,
3552: session_id
3553: ) values (

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

3556: AK_ON_OBJECTS_PVT.G_SESSION_ID
3557: );
3558:
3559: if SQL%ROWCOUNT = 0 then
3560: -- dbms_output.put_line('no rows has been inserted into ak_loader_temp');
3561: raise insert_err;
3562: elsif SQL%NOTFOUND then
3563: -- dbms_output.put_line('Error SQL%NOTFOUND');
3564: raise insert_err;

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

3567: -- commit;
3568:
3569: EXCEPTION
3570: WHEN insert_err THEN
3571: -- dbms_output.put_line('Exception insert_err ak_loader_temp');
3572: FND_MESSAGE.SET_NAME('AK','AK_LOADER_TEMP_EXCEPTION');
3573: FND_MSG_PUB.Add;
3574: WHEN OTHERS THEN
3575: FND_MESSAGE.SET_NAME('AK','AK_LOADER_TEMP_ERROR');

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

3568:
3569: EXCEPTION
3570: WHEN insert_err THEN
3571: -- dbms_output.put_line('Exception insert_err ak_loader_temp');
3572: FND_MESSAGE.SET_NAME('AK','AK_LOADER_TEMP_EXCEPTION');
3573: FND_MSG_PUB.Add;
3574: WHEN OTHERS THEN
3575: FND_MESSAGE.SET_NAME('AK','AK_LOADER_TEMP_ERROR');
3576: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

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

3571: -- dbms_output.put_line('Exception insert_err ak_loader_temp');
3572: FND_MESSAGE.SET_NAME('AK','AK_LOADER_TEMP_EXCEPTION');
3573: FND_MSG_PUB.Add;
3574: WHEN OTHERS THEN
3575: FND_MESSAGE.SET_NAME('AK','AK_LOADER_TEMP_ERROR');
3576: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
3577: SUBSTR (SQLERRM, 1, 240) );
3578: FND_MSG_PUB.Add;
3579: -- err_num := SQLCODE;

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

3577: SUBSTR (SQLERRM, 1, 240) );
3578: FND_MSG_PUB.Add;
3579: -- err_num := SQLCODE;
3580: -- err_msg := SUBSTR(SQLERRM, 1, 100);
3581: -- dbms_output.put_line('Other errors in inserting into ak_loader_temp');
3582: -- dbms_output.put_line(to_char(err_num)||' '||err_msg);
3583:
3584: end WRITE_TO_TABLE;
3585: