1420: VALUES
1421: (p_error_tbl(i).organization_id,
1422: mtl_system_items_interface_s.nextval,
1423: sysdate,
1424: FND_GLOBAL.USER_ID,
1425: sysdate,
1426: FND_GLOBAL.USER_ID,
1427: FND_GLOBAL.USER_ID,
1428: p_error_tbl(i).table_name,
1422: mtl_system_items_interface_s.nextval,
1423: sysdate,
1424: FND_GLOBAL.USER_ID,
1425: sysdate,
1426: FND_GLOBAL.USER_ID,
1427: FND_GLOBAL.USER_ID,
1428: p_error_tbl(i).table_name,
1429: p_error_tbl(i).message_name,
1430: FND_GLOBAL.CONC_REQUEST_ID,
1423: sysdate,
1424: FND_GLOBAL.USER_ID,
1425: sysdate,
1426: FND_GLOBAL.USER_ID,
1427: FND_GLOBAL.USER_ID,
1428: p_error_tbl(i).table_name,
1429: p_error_tbl(i).message_name,
1430: FND_GLOBAL.CONC_REQUEST_ID,
1431: FND_GLOBAL.PROG_APPL_ID,
1426: FND_GLOBAL.USER_ID,
1427: FND_GLOBAL.USER_ID,
1428: p_error_tbl(i).table_name,
1429: p_error_tbl(i).message_name,
1430: FND_GLOBAL.CONC_REQUEST_ID,
1431: FND_GLOBAL.PROG_APPL_ID,
1432: FND_GLOBAL.CONC_PROGRAM_ID,
1433: sysdate,
1434: p_error_tbl(i).error_message,
1427: FND_GLOBAL.USER_ID,
1428: p_error_tbl(i).table_name,
1429: p_error_tbl(i).message_name,
1430: FND_GLOBAL.CONC_REQUEST_ID,
1431: FND_GLOBAL.PROG_APPL_ID,
1432: FND_GLOBAL.CONC_PROGRAM_ID,
1433: sysdate,
1434: p_error_tbl(i).error_message,
1435: p_error_tbl(i).transaction_id);
1428: p_error_tbl(i).table_name,
1429: p_error_tbl(i).message_name,
1430: FND_GLOBAL.CONC_REQUEST_ID,
1431: FND_GLOBAL.PROG_APPL_ID,
1432: FND_GLOBAL.CONC_PROGRAM_ID,
1433: sysdate,
1434: p_error_tbl(i).error_message,
1435: p_error_tbl(i).transaction_id);
1436: ELSE
2988:
2989: -- INITIALIZE GLOBALS
2990: --dbms_output.put_line('Start Launch');
2991: stmt_num := 1;
2992: l_prog_appid := FND_GLOBAL.PROG_APPL_ID;
2993: l_prog_id := FND_GLOBAL.CONC_PROGRAM_ID;
2994: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
2995: l_user_id := FND_GLOBAL.USER_ID;
2996: l_login_id := FND_GLOBAL.LOGIN_ID;
2989: -- INITIALIZE GLOBALS
2990: --dbms_output.put_line('Start Launch');
2991: stmt_num := 1;
2992: l_prog_appid := FND_GLOBAL.PROG_APPL_ID;
2993: l_prog_id := FND_GLOBAL.CONC_PROGRAM_ID;
2994: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
2995: l_user_id := FND_GLOBAL.USER_ID;
2996: l_login_id := FND_GLOBAL.LOGIN_ID;
2997:
2990: --dbms_output.put_line('Start Launch');
2991: stmt_num := 1;
2992: l_prog_appid := FND_GLOBAL.PROG_APPL_ID;
2993: l_prog_id := FND_GLOBAL.CONC_PROGRAM_ID;
2994: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
2995: l_user_id := FND_GLOBAL.USER_ID;
2996: l_login_id := FND_GLOBAL.LOGIN_ID;
2997:
2998: g_all_org := p_all_org;
2991: stmt_num := 1;
2992: l_prog_appid := FND_GLOBAL.PROG_APPL_ID;
2993: l_prog_id := FND_GLOBAL.CONC_PROGRAM_ID;
2994: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
2995: l_user_id := FND_GLOBAL.USER_ID;
2996: l_login_id := FND_GLOBAL.LOGIN_ID;
2997:
2998: g_all_org := p_all_org;
2999: g_org_id := p_org_id;
2992: l_prog_appid := FND_GLOBAL.PROG_APPL_ID;
2993: l_prog_id := FND_GLOBAL.CONC_PROGRAM_ID;
2994: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
2995: l_user_id := FND_GLOBAL.USER_ID;
2996: l_login_id := FND_GLOBAL.LOGIN_ID;
2997:
2998: g_all_org := p_all_org;
2999: g_org_id := p_org_id;
3000:
6392: -- *************************** REVISED ITEM BUSINESS OBJECT **************************
6393: r := 0;
6394:
6395: stmt_num := 1;
6396: l_prog_appid := FND_GLOBAL.PROG_APPL_ID;
6397: l_prog_id := FND_GLOBAL.CONC_PROGRAM_ID;
6398: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
6399: l_user_id := FND_GLOBAL.USER_ID;
6400: l_login_id := FND_GLOBAL.LOGIN_ID;
6393: r := 0;
6394:
6395: stmt_num := 1;
6396: l_prog_appid := FND_GLOBAL.PROG_APPL_ID;
6397: l_prog_id := FND_GLOBAL.CONC_PROGRAM_ID;
6398: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
6399: l_user_id := FND_GLOBAL.USER_ID;
6400: l_login_id := FND_GLOBAL.LOGIN_ID;
6401:
6394:
6395: stmt_num := 1;
6396: l_prog_appid := FND_GLOBAL.PROG_APPL_ID;
6397: l_prog_id := FND_GLOBAL.CONC_PROGRAM_ID;
6398: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
6399: l_user_id := FND_GLOBAL.USER_ID;
6400: l_login_id := FND_GLOBAL.LOGIN_ID;
6401:
6402: g_all_org := p_all_org;
6395: stmt_num := 1;
6396: l_prog_appid := FND_GLOBAL.PROG_APPL_ID;
6397: l_prog_id := FND_GLOBAL.CONC_PROGRAM_ID;
6398: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
6399: l_user_id := FND_GLOBAL.USER_ID;
6400: l_login_id := FND_GLOBAL.LOGIN_ID;
6401:
6402: g_all_org := p_all_org;
6403: g_org_id := p_org_id;
6396: l_prog_appid := FND_GLOBAL.PROG_APPL_ID;
6397: l_prog_id := FND_GLOBAL.CONC_PROGRAM_ID;
6398: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
6399: l_user_id := FND_GLOBAL.USER_ID;
6400: l_login_id := FND_GLOBAL.LOGIN_ID;
6401:
6402: g_all_org := p_all_org;
6403: g_org_id := p_org_id;
6404: