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_FLOW2_PVT dependencies on AK_ON_OBJECTS_PUB

Line 54: l_databuffer_tbl AK_ON_OBJECTS_PUB.Buffer_Tbl_Type;

50: and PAGE_CODE = p_page_code
51: and REGION_APPLICATION_ID = p_region_application_id
52: and REGION_CODE = p_region_code;
53: l_api_name CONSTANT varchar2(30) := 'Write_Items_to_buffer';
54: l_databuffer_tbl AK_ON_OBJECTS_PUB.Buffer_Tbl_Type;
55: l_index NUMBER;
56: l_items_rec AK_FLOW_PAGE_REGION_ITEMS%ROWTYPE;
57: l_return_status varchar2(1);
58: begin

Line 250: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';

246: nvl(to_char(l_items_rec.created_by),'') || '"';
247: l_index := l_index + 1;
248: l_databuffer_tbl(l_index) := ' CREATION_DATE = "' ||
249: to_char(l_items_rec.creation_date,
250: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';
251: l_index := l_index + 1;
252: -- CHANGED TO OWNER FOR R12
253: -- l_databuffer_tbl(l_index) := ' LAST_UPDATED_BY = "' ||
254: -- nvl(to_char(l_items_rec.last_updated_by),'') || '"';

Line 260: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';

256: FND_LOAD_UTIL.OWNER_NAME(l_items_rec.last_updated_by) || '"';
257: l_index := l_index + 1;
258: l_databuffer_tbl(l_index) := ' LAST_UPDATE_DATE = "' ||
259: to_char(l_items_rec.last_update_date,
260: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';
261: l_index := l_index + 1;
262: l_databuffer_tbl(l_index) := ' LAST_UPDATE_LOGIN = "' ||
263: nvl(to_char(l_items_rec.last_update_login),'') || '"';
264:

Line 283: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND

279: if (l_databuffer_tbl.count > 0) then
280: AK_ON_OBJECTS_PVT.WRITE_FILE (
281: p_return_status => l_return_status,
282: p_buffer_tbl => l_databuffer_tbl,
283: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND
284: );
285: -- If API call returns with an error status...
286: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
287: (l_return_status = FND_API.G_RET_STS_ERROR) then

Line 380: l_databuffer_tbl AK_ON_OBJECTS_PUB.Buffer_Tbl_Type;

376: and TO_PAGE_CODE = p_page_code
377: and TO_REGION_APPL_ID = region_appl_id_param
378: and TO_REGION_CODE = region_code_param;
379: l_api_name CONSTANT varchar2(30) := 'Write_Region_to_buffer';
380: l_databuffer_tbl AK_ON_OBJECTS_PUB.Buffer_Tbl_Type;
381: l_foreign_key_name VARCHAR2(30);
382: l_index NUMBER;
383: l_regions_rec AK_FLOW_PAGE_REGIONS%ROWTYPE;
384: l_return_status varchar2(1);

Line 609: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';

605: nvl(to_char(l_regions_rec.created_by),'') || '"';
606: l_index := l_index + 1;
607: l_databuffer_tbl(l_index) := ' CREATION_DATE = "' ||
608: to_char(l_regions_rec.creation_date,
609: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';
610: l_index := l_index + 1;
611: -- CHANGED TO OWNER FOR R12
612: -- l_databuffer_tbl(l_index) := ' LAST_UPDATED_BY = "' ||
613: -- nvl(to_char(l_regions_rec.last_updated_by),'') || '"';

Line 619: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';

615: FND_LOAD_UTIL.OWNER_NAME(l_regions_rec.last_updated_by) ||'"';
616: l_index := l_index + 1;
617: l_databuffer_tbl(l_index) := ' LAST_UPDATE_DATE = "' ||
618: to_char(l_regions_rec.last_update_date,
619: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';
620: l_index := l_index + 1;
621: l_databuffer_tbl(l_index) := ' LAST_UPDATE_LOGIN = "' ||
622: nvl(to_char(l_regions_rec.last_update_login),'') || '"';
623:

Line 629: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND

625: -- - Write flow page region data out to the specified file
626: AK_ON_OBJECTS_PVT.WRITE_FILE (
627: p_return_status => l_return_status,
628: p_buffer_tbl => l_databuffer_tbl,
629: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND
630: );
631: -- If API call returns with an error status...
632: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
633: (l_return_status = FND_API.G_RET_STS_ERROR) then

Line 671: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND

667: -- - Finish up writing object data out to the specified file
668: AK_ON_OBJECTS_PVT.WRITE_FILE (
669: p_return_status => l_return_status,
670: p_buffer_tbl => l_databuffer_tbl,
671: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND
672: );
673: -- If API call returns with an error status...
674: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
675: (l_return_status = FND_API.G_RET_STS_ERROR) then

Line 758: l_databuffer_tbl AK_ON_OBJECTS_PUB.Buffer_Tbl_Type;

754: and PAGE_APPLICATION_ID = page_appl_id_param
755: and PAGE_CODE = page_code_param
756: and LANGUAGE = p_nls_language;
757: l_api_name CONSTANT varchar2(30) := 'Write_Pages_to_buffer';
758: l_databuffer_tbl AK_ON_OBJECTS_PUB.Buffer_Tbl_Type;
759: l_index NUMBER;
760: l_pages_rec AK_FLOW_PAGES%ROWTYPE;
761: l_pages_tl_rec AK_FLOW_PAGES_TL%ROWTYPE;
762: l_return_status varchar2(1);

Line 943: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';

939: nvl(to_char(l_pages_rec.created_by),'') || '"';
940: l_index := l_index + 1;
941: l_databuffer_tbl(l_index) := ' CREATION_DATE = "' ||
942: to_char(l_pages_rec.creation_date,
943: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';
944: l_index := l_index + 1;
945: -- CHANGED TO OWNER FOR R12
946: -- l_databuffer_tbl(l_index) := ' LAST_UPDATED_BY = "' ||
947: -- nvl(to_char(l_pages_rec.last_updated_by),'') || '"';

Line 953: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';

949: FND_LOAD_UTIL.OWNER_NAME(l_pages_rec.last_updated_by) || '"';
950: l_index := l_index + 1;
951: l_databuffer_tbl(l_index) := ' LAST_UPDATE_DATE = "' ||
952: to_char(l_pages_rec.last_update_date,
953: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';
954: l_index := l_index + 1;
955: l_databuffer_tbl(l_index) := ' LAST_UPDATE_LOGIN = "' ||
956: nvl(to_char(l_pages_rec.last_update_login),'') || '"';
957:

Line 976: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND

972: -- - Write flow page data out to the specified file
973: AK_ON_OBJECTS_PVT.WRITE_FILE (
974: p_return_status => l_return_status,
975: p_buffer_tbl => l_databuffer_tbl,
976: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND
977: );
978: -- If API call returns with an error status...
979: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
980: (l_return_status = FND_API.G_RET_STS_ERROR) then

Line 1019: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND

1015: -- - Finish up writing flow page data out to the specified file
1016: AK_ON_OBJECTS_PVT.WRITE_FILE (
1017: p_return_status => l_return_status,
1018: p_buffer_tbl => l_databuffer_tbl,
1019: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND
1020: );
1021: -- If API call returns with an error status...
1022: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
1023: (l_return_status = FND_API.G_RET_STS_ERROR) then

Line 1097: l_databuffer_tbl AK_ON_OBJECTS_PUB.Buffer_Tbl_Type;

1093: and FLOW_CODE = p_flow_code
1094: and ( (FROM_PAGE_APPL_ID <> TO_PAGE_APPL_ID) or
1095: (FROM_PAGE_CODE <> TO_PAGE_CODE) );
1096: l_api_name CONSTANT varchar2(30) := 'Write_Relations_to_buffer';
1097: l_databuffer_tbl AK_ON_OBJECTS_PUB.Buffer_Tbl_Type;
1098: l_index NUMBER;
1099: l_relations_rec AK_FLOW_REGION_RELATIONS%ROWTYPE;
1100: l_return_status varchar2(1);
1101: begin

Line 1290: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';

1286: nvl(to_char(l_relations_rec.created_by),'') || '"';
1287: l_index := l_index + 1;
1288: l_databuffer_tbl(l_index) := ' CREATION_DATE = "' ||
1289: to_char(l_relations_rec.creation_date,
1290: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';
1291: l_index := l_index + 1;
1292: -- CHANGED TO OWNER FOR R12
1293: -- l_databuffer_tbl(l_index) := ' LAST_UPDATED_BY = "' ||
1294: -- nvl(to_char(l_relations_rec.last_updated_by),'') || '"';

Line 1300: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';

1296: FND_LOAD_UTIL.OWNER_NAME(l_relations_rec.last_updated_by) || '"';
1297: l_index := l_index + 1;
1298: l_databuffer_tbl(l_index) := ' LAST_UPDATE_DATE = "' ||
1299: to_char(l_relations_rec.last_update_date,
1300: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';
1301: l_index := l_index + 1;
1302: l_databuffer_tbl(l_index) := ' LAST_UPDATE_LOGIN = "' ||
1303: nvl(to_char(l_relations_rec.last_update_login),'') || '"';
1304:

Line 1321: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND

1317: if (l_databuffer_tbl.count > 0) then
1318: AK_ON_OBJECTS_PVT.WRITE_FILE (
1319: p_return_status => l_return_status,
1320: p_buffer_tbl => l_databuffer_tbl,
1321: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND
1322: );
1323: -- If API call returns with an error status...
1324: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
1325: (l_return_status = FND_API.G_RET_STS_ERROR) then

Line 1407: l_databuffer_tbl AK_ON_OBJECTS_PUB.Buffer_Tbl_Type;

1403: where flow_application_id = p_flow_application_id
1404: and flow_code = p_flow_code
1405: and LANGUAGE = p_nls_language;
1406: l_api_name CONSTANT varchar2(30) := 'Write_to_buffer';
1407: l_databuffer_tbl AK_ON_OBJECTS_PUB.Buffer_Tbl_Type;
1408: l_index NUMBER;
1409: l_flows_rec AK_FLOWS%ROWTYPE;
1410: l_flows_tl_rec AK_FLOWS_TL%ROWTYPE;
1411: l_return_status varchar2(1);

Line 1588: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';

1584: nvl(to_char(l_flows_rec.created_by),'') || '"';
1585: l_index := l_index + 1;
1586: l_databuffer_tbl(l_index) := ' CREATION_DATE = "' ||
1587: to_char(l_flows_rec.creation_date,
1588: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';
1589: l_index := l_index + 1;
1590: -- CHANGED TO OWNER FOR R12
1591: -- l_databuffer_tbl(l_index) := ' LAST_UPDATED_BY = "' ||
1592: -- nvl(to_char(l_flows_rec.last_updated_by),'') || '"';

Line 1598: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';

1594: FND_LOAD_UTIL.OWNER_NAME(l_flows_rec.last_updated_by) || '"';
1595: l_index := l_index + 1;
1596: l_databuffer_tbl(l_index) := ' LAST_UPDATE_DATE = "' ||
1597: to_char(l_flows_rec.last_update_date,
1598: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';
1599: l_index := l_index + 1;
1600: l_databuffer_tbl(l_index) := ' LAST_UPDATE_LOGIN = "' ||
1601: nvl(to_char(l_flows_rec.last_update_login),'') || '"';
1602:

Line 1622: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND

1618: -- - Write flow data out to the specified file
1619: AK_ON_OBJECTS_PVT.WRITE_FILE (
1620: p_return_status => l_return_status,
1621: p_buffer_tbl => l_databuffer_tbl,
1622: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND
1623: );
1624: -- dbms_output.put_line('after write file');
1625: -- If API call returns with an error status...
1626: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or

Line 1665: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND

1661: -- - Finish up writing flow data out to the specified file
1662: AK_ON_OBJECTS_PVT.WRITE_FILE (
1663: p_return_status => l_return_status,
1664: p_buffer_tbl => l_databuffer_tbl,
1665: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND
1666: );
1667: -- If API call returns with an error status...
1668: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
1669: (l_return_status = FND_API.G_RET_STS_ERROR) then

Line 1970: p_buffer IN AK_ON_OBJECTS_PUB.Buffer_Type,

1966: p_return_status OUT NOCOPY VARCHAR2,
1967: p_index IN OUT NOCOPY NUMBER,
1968: p_loader_timestamp IN DATE,
1969: p_line_num IN NUMBER := FND_API.G_MISS_NUM,
1970: p_buffer IN AK_ON_OBJECTS_PUB.Buffer_Type,
1971: p_line_num_out OUT NOCOPY NUMBER,
1972: p_buffer_out OUT NOCOPY AK_ON_OBJECTS_PUB.Buffer_Type,
1973: p_upl_loader_cur IN OUT NOCOPY AK_ON_OBJECTS_PUB.LoaderCurTyp,
1974: p_pass IN NUMBER := 1

Line 1972: p_buffer_out OUT NOCOPY AK_ON_OBJECTS_PUB.Buffer_Type,

1968: p_loader_timestamp IN DATE,
1969: p_line_num IN NUMBER := FND_API.G_MISS_NUM,
1970: p_buffer IN AK_ON_OBJECTS_PUB.Buffer_Type,
1971: p_line_num_out OUT NOCOPY NUMBER,
1972: p_buffer_out OUT NOCOPY AK_ON_OBJECTS_PUB.Buffer_Type,
1973: p_upl_loader_cur IN OUT NOCOPY AK_ON_OBJECTS_PUB.LoaderCurTyp,
1974: p_pass IN NUMBER := 1
1975: ) is
1976: l_api_version_number CONSTANT number := 1.0;

Line 1973: p_upl_loader_cur IN OUT NOCOPY AK_ON_OBJECTS_PUB.LoaderCurTyp,

1969: p_line_num IN NUMBER := FND_API.G_MISS_NUM,
1970: p_buffer IN AK_ON_OBJECTS_PUB.Buffer_Type,
1971: p_line_num_out OUT NOCOPY NUMBER,
1972: p_buffer_out OUT NOCOPY AK_ON_OBJECTS_PUB.Buffer_Type,
1973: p_upl_loader_cur IN OUT NOCOPY AK_ON_OBJECTS_PUB.LoaderCurTyp,
1974: p_pass IN NUMBER := 1
1975: ) is
1976: l_api_version_number CONSTANT number := 1.0;
1977: l_api_name CONSTANT varchar2(30) := 'Upload_Object';

Line 1978: l_buffer AK_ON_OBJECTS_PUB.Buffer_Type;

1974: p_pass IN NUMBER := 1
1975: ) is
1976: l_api_version_number CONSTANT number := 1.0;
1977: l_api_name CONSTANT varchar2(30) := 'Upload_Object';
1978: l_buffer AK_ON_OBJECTS_PUB.Buffer_Type;
1979: l_column varchar2(30);
1980: l_dummy NUMBER;
1981: l_eof_flag VARCHAR2(1);
1982: l_flow_index NUMBER := 0;

Line 2003: l_saved_token AK_ON_OBJECTS_PUB.Buffer_Type;

1999: l_region_tbl AK_FLOW_PUB.Page_Region_Tbl_Type;
2000: l_relation_index NUMBER := 0;
2001: l_relation_rec AK_FLOW_PUB.Region_Relation_Rec_Type;
2002: l_relation_tbl AK_FLOW_PUB.Region_Relation_Tbl_Type;
2003: l_saved_token AK_ON_OBJECTS_PUB.Buffer_Type;
2004: l_state NUMBER;
2005: l_return_status varchar2(1);
2006: l_token AK_ON_OBJECTS_PUB.Buffer_Type;
2007: l_value_count NUMBER; -- # of values read for current column

Line 2006: l_token AK_ON_OBJECTS_PUB.Buffer_Type;

2002: l_relation_tbl AK_FLOW_PUB.Region_Relation_Tbl_Type;
2003: l_saved_token AK_ON_OBJECTS_PUB.Buffer_Type;
2004: l_state NUMBER;
2005: l_return_status varchar2(1);
2006: l_token AK_ON_OBJECTS_PUB.Buffer_Type;
2007: l_value_count NUMBER; -- # of values read for current column
2008: l_copy_redo_flag BOOLEAN := FALSE;
2009: l_user_id1 NUMBER;
2010: l_user_id2 NUMBER;

Line 2209: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or

2205: --
2206: if (l_value_count = 2) then
2207: l_saved_token := l_token;
2208: end if;
2209: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or
2210: (l_value_count is null) then
2211: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2212: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2213: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

Line 2302: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);

2298: l_flow_rec.created_by := to_number(l_token);
2299: l_state := 10;
2300: elsif (l_column = 'CREATION_DATE') then
2301: l_flow_rec.creation_date := to_date(l_token,
2302: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);
2303: l_state := 10;
2304: elsif (l_column = 'LAST_UPDATED_BY') then
2305: l_flow_rec.last_updated_by := to_number(l_token);
2306: l_state := 10;

Line 2312: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);

2308: l_flow_rec.last_updated_by := FND_LOAD_UTIL.OWNER_ID(l_token);
2309: l_state := 10;
2310: elsif (l_column = 'LAST_UPDATE_DATE') then
2311: l_flow_rec.last_update_date := to_date(l_token,
2312: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);
2313: l_state := 10;
2314: elsif (l_column = 'LAST_UPDATE_LOGIN') then
2315: l_flow_rec.last_update_login := to_number(l_token);
2316: l_state := 10;

Line 2452: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or

2448: --
2449: if (l_value_count = 2) then
2450: l_saved_token := l_token;
2451: end if;
2452: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or
2453: (l_value_count is null) then
2454: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2455: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_BEFIELD');
2456: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

Line 2545: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);

2541: l_page_rec.created_by := to_number(l_token);
2542: l_state := 30;
2543: elsif (l_column = 'CREATION_DATE') then
2544: l_page_rec.creation_date := to_date(l_token,
2545: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);
2546: l_state := 30;
2547: elsif (l_column = 'LAST_UPDATED_BY') then
2548: l_page_rec.last_updated_by := to_number(l_token);
2549: l_state := 30;

Line 2555: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);

2551: l_page_rec.last_updated_by := FND_LOAD_UTIL.OWNER_ID(l_token);
2552: l_state := 30;
2553: elsif (l_column = 'LAST_UPDATE_DATE') then
2554: l_page_rec.last_update_date := to_date(l_token,
2555: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);
2556: l_state := 30;
2557: elsif (l_column = 'LAST_UPDATE_LOGIN') then
2558: l_page_rec.last_update_login := to_number(l_token);
2559: l_state := 30;

Line 2788: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or

2784: --
2785: if (l_value_count = 2) then
2786: l_saved_token := l_token;
2787: end if;
2788: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or
2789: (l_value_count is null) then
2790: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2791: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');
2792: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

Line 2857: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);

2853: elsif (l_column = 'CREATED_BY') then
2854: l_relation_rec.created_by := to_number(l_token);
2855: elsif (l_column = 'CREATION_DATE') then
2856: l_relation_rec.creation_date := to_date(l_token,
2857: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);
2858: elsif (l_column = 'LAST_UPDATED_BY') then
2859: l_relation_rec.last_updated_by := to_number(l_token);
2860: elsif (l_column = 'OWNER') then
2861: l_relation_rec.last_updated_by := FND_LOAD_UTIL.OWNER_ID(l_token);

Line 2864: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);

2860: elsif (l_column = 'OWNER') then
2861: l_relation_rec.last_updated_by := FND_LOAD_UTIL.OWNER_ID(l_token);
2862: elsif (l_column = 'LAST_UPDATE_DATE') then
2863: l_relation_rec.last_update_date := to_date(l_token,
2864: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);
2865: elsif (l_column = 'LAST_UPDATE_LOGIN') then
2866: l_relation_rec.last_update_login := to_number(l_token);
2867: else
2868: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 2977: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or

2973: --
2974: if (l_value_count = 2) then
2975: l_saved_token := l_token;
2976: end if;
2977: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or
2978: (l_value_count is null) then
2979: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2980: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_BEFIELD');
2981: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

Line 3079: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);

3075: l_region_rec.created_by := to_number(l_token);
3076: l_state := 110;
3077: elsif (l_column = 'CREATION_DATE') then
3078: l_region_rec.creation_date := to_date(l_token,
3079: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);
3080: l_state := 110;
3081: elsif (l_column = 'LAST_UPDATED_BY') then
3082: l_region_rec.last_updated_by := to_number(l_token);
3083: l_state := 110;

Line 3089: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);

3085: l_region_rec.last_updated_by := FND_LOAD_UTIL.OWNER_ID(l_token);
3086: l_state := 110;
3087: elsif (l_column = 'LAST_UPDATE_DATE') then
3088: l_region_rec.last_update_date := to_date(l_token,
3089: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);
3090: l_state := 110;
3091: elsif (l_column = 'LAST_UPDATE_LOGIN') then
3092: l_region_rec.last_update_login := to_number(l_token);
3093: l_state := 110;

Line 3227: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or

3223: --
3224: if (l_value_count = 2) then
3225: l_saved_token := l_token;
3226: end if;
3227: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or
3228: (l_value_count is null) then
3229: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3230: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');
3231: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

Line 3318: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);

3314: l_item_rec.created_by := to_number(l_token);
3315: l_state := 210;
3316: elsif (l_column = 'CREATION_DATE') then
3317: l_item_rec.creation_date := to_date(l_token,
3318: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);
3319: l_state := 210;
3320: elsif (l_column = 'LAST_UPDATED_BY') then
3321: l_item_rec.last_updated_by := to_number(l_token);
3322: l_state := 210;

Line 3328: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);

3324: l_item_rec.last_updated_by := FND_LOAD_UTIL.OWNER_ID(l_token);
3325: l_state := 210;
3326: elsif (l_column = 'LAST_UPDATE_DATE') then
3327: l_item_rec.last_update_date := to_date(l_token,
3328: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);
3329: l_state := 210;
3330: elsif (l_column = 'LAST_UPDATE_LOGIN') then
3331: l_item_rec.last_update_login := to_number(l_token);
3332: l_state := 210;