22:
23: -----------------------------------------------------------------------
24: -- These are the Constants to generate a New Line Character. --
25: -----------------------------------------------------------------------
26: G_CARRIAGE_RETURN VARCHAR2(1) := FND_GLOBAL.LOCAL_CHR(13);
27: G_LINE_FEED VARCHAR2(1) := FND_GLOBAL.LOCAL_CHR(10);
28: -- Following prints ^M characters in the log file.
29: G_NEWLINE VARCHAR2(2) := G_LINE_FEED;
30:
23: -----------------------------------------------------------------------
24: -- These are the Constants to generate a New Line Character. --
25: -----------------------------------------------------------------------
26: G_CARRIAGE_RETURN VARCHAR2(1) := FND_GLOBAL.LOCAL_CHR(13);
27: G_LINE_FEED VARCHAR2(1) := FND_GLOBAL.LOCAL_CHR(10);
28: -- Following prints ^M characters in the log file.
29: G_NEWLINE VARCHAR2(2) := G_LINE_FEED;
30:
31:
829: VALUES
830: ( NULL
831: , NULL
832: , SYSDATE
833: , FND_GLOBAL.user_id
834: , SYSDATE
835: , FND_GLOBAL.user_id
836: , FND_GLOBAL.login_id
837: , p_error_table_name
831: , NULL
832: , SYSDATE
833: , FND_GLOBAL.user_id
834: , SYSDATE
835: , FND_GLOBAL.user_id
836: , FND_GLOBAL.login_id
837: , p_error_table_name
838: , p_error_msg_name
839: , p_error_table_name
832: , SYSDATE
833: , FND_GLOBAL.user_id
834: , SYSDATE
835: , FND_GLOBAL.user_id
836: , FND_GLOBAL.login_id
837: , p_error_table_name
838: , p_error_msg_name
839: , p_error_table_name
840: , FND_GLOBAL.conc_request_id
836: , FND_GLOBAL.login_id
837: , p_error_table_name
838: , p_error_msg_name
839: , p_error_table_name
840: , FND_GLOBAL.conc_request_id
841: , FND_GLOBAL.prog_appl_id
842: , FND_GLOBAL.conc_program_id
843: , SYSDATE
844: , SUBSTR(p_error_msg ,1, 2000)
837: , p_error_table_name
838: , p_error_msg_name
839: , p_error_table_name
840: , FND_GLOBAL.conc_request_id
841: , FND_GLOBAL.prog_appl_id
842: , FND_GLOBAL.conc_program_id
843: , SYSDATE
844: , SUBSTR(p_error_msg ,1, 2000)
845: , p_transaction_id
838: , p_error_msg_name
839: , p_error_table_name
840: , FND_GLOBAL.conc_request_id
841: , FND_GLOBAL.prog_appl_id
842: , FND_GLOBAL.conc_program_id
843: , SYSDATE
844: , SUBSTR(p_error_msg ,1, 2000)
845: , p_transaction_id
846: , p_error_entity_code
1236: l_dyn_sql := l_dyn_sql || ' INTF.ORGANIZATION_ID , ';
1237: l_dyn_sql := l_dyn_sql || ' NULL , ';
1238: l_dyn_sql := l_dyn_sql || ' INTF.TRANSACTION_ID , ';
1239: l_dyn_sql := l_dyn_sql || ' SYSDATE , ';
1240: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.user_id , ';
1241: l_dyn_sql := l_dyn_sql || ' SYSDATE , ';
1242: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.user_id , ';
1243: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.login_id , ';
1244: l_dyn_sql := l_dyn_sql || '''' ||l_intf_table(i) ||''', ' ;
1238: l_dyn_sql := l_dyn_sql || ' INTF.TRANSACTION_ID , ';
1239: l_dyn_sql := l_dyn_sql || ' SYSDATE , ';
1240: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.user_id , ';
1241: l_dyn_sql := l_dyn_sql || ' SYSDATE , ';
1242: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.user_id , ';
1243: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.login_id , ';
1244: l_dyn_sql := l_dyn_sql || '''' ||l_intf_table(i) ||''', ' ;
1245: l_dyn_sql := l_dyn_sql || ''''||l_error_msg_name|| ''', ';
1246: l_dyn_sql := l_dyn_sql || ' NULL , ';
1239: l_dyn_sql := l_dyn_sql || ' SYSDATE , ';
1240: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.user_id , ';
1241: l_dyn_sql := l_dyn_sql || ' SYSDATE , ';
1242: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.user_id , ';
1243: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.login_id , ';
1244: l_dyn_sql := l_dyn_sql || '''' ||l_intf_table(i) ||''', ' ;
1245: l_dyn_sql := l_dyn_sql || ''''||l_error_msg_name|| ''', ';
1246: l_dyn_sql := l_dyn_sql || ' NULL , ';
1247: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.conc_request_id , ';
1243: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.login_id , ';
1244: l_dyn_sql := l_dyn_sql || '''' ||l_intf_table(i) ||''', ' ;
1245: l_dyn_sql := l_dyn_sql || ''''||l_error_msg_name|| ''', ';
1246: l_dyn_sql := l_dyn_sql || ' NULL , ';
1247: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.conc_request_id , ';
1248: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.prog_appl_id, ';
1249: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.conc_program_id , ';
1250: l_dyn_sql := l_dyn_sql || ' SYSDATE , ';
1251: l_dyn_sql := l_dyn_sql || ''''||Escape_Single_Quote(l_error_msg_text)||''' , ' ;
1244: l_dyn_sql := l_dyn_sql || '''' ||l_intf_table(i) ||''', ' ;
1245: l_dyn_sql := l_dyn_sql || ''''||l_error_msg_name|| ''', ';
1246: l_dyn_sql := l_dyn_sql || ' NULL , ';
1247: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.conc_request_id , ';
1248: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.prog_appl_id, ';
1249: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.conc_program_id , ';
1250: l_dyn_sql := l_dyn_sql || ' SYSDATE , ';
1251: l_dyn_sql := l_dyn_sql || ''''||Escape_Single_Quote(l_error_msg_text)||''' , ' ;
1252: l_dyn_sql := l_dyn_sql || ''''||G_ERROR_ENTITY_CODE||''' , ' ;
1245: l_dyn_sql := l_dyn_sql || ''''||l_error_msg_name|| ''', ';
1246: l_dyn_sql := l_dyn_sql || ' NULL , ';
1247: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.conc_request_id , ';
1248: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.prog_appl_id, ';
1249: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.conc_program_id , ';
1250: l_dyn_sql := l_dyn_sql || ' SYSDATE , ';
1251: l_dyn_sql := l_dyn_sql || ''''||Escape_Single_Quote(l_error_msg_text)||''' , ' ;
1252: l_dyn_sql := l_dyn_sql || ''''||G_ERROR_ENTITY_CODE||''' , ' ;
1253: l_dyn_sql := l_dyn_sql || ''''||G_BO_IDENTIFIER||''', ' ;
3047: l_dyn_sql := l_dyn_sql || ' INTF.ORGANIZATION_ID , ';
3048: l_dyn_sql := l_dyn_sql || ' NULL , ';
3049: l_dyn_sql := l_dyn_sql || ' INTF.TRANSACTION_ID , ';
3050: l_dyn_sql := l_dyn_sql || ' SYSDATE , ';
3051: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.user_id , ';
3052: l_dyn_sql := l_dyn_sql || ' SYSDATE , ';
3053: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.user_id , ';
3054: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.login_id , ';
3055: l_dyn_sql := l_dyn_sql || '''' ||l_intf_table(i) ||''', ' ;
3049: l_dyn_sql := l_dyn_sql || ' INTF.TRANSACTION_ID , ';
3050: l_dyn_sql := l_dyn_sql || ' SYSDATE , ';
3051: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.user_id , ';
3052: l_dyn_sql := l_dyn_sql || ' SYSDATE , ';
3053: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.user_id , ';
3054: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.login_id , ';
3055: l_dyn_sql := l_dyn_sql || '''' ||l_intf_table(i) ||''', ' ;
3056: l_dyn_sql := l_dyn_sql || ' ''ENG_IMPT_CO_NOT_FOUND'', ';
3057: l_dyn_sql := l_dyn_sql || ' NULL , ';
3050: l_dyn_sql := l_dyn_sql || ' SYSDATE , ';
3051: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.user_id , ';
3052: l_dyn_sql := l_dyn_sql || ' SYSDATE , ';
3053: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.user_id , ';
3054: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.login_id , ';
3055: l_dyn_sql := l_dyn_sql || '''' ||l_intf_table(i) ||''', ' ;
3056: l_dyn_sql := l_dyn_sql || ' ''ENG_IMPT_CO_NOT_FOUND'', ';
3057: l_dyn_sql := l_dyn_sql || ' NULL , ';
3058: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.conc_request_id , ';
3054: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.login_id , ';
3055: l_dyn_sql := l_dyn_sql || '''' ||l_intf_table(i) ||''', ' ;
3056: l_dyn_sql := l_dyn_sql || ' ''ENG_IMPT_CO_NOT_FOUND'', ';
3057: l_dyn_sql := l_dyn_sql || ' NULL , ';
3058: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.conc_request_id , ';
3059: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.prog_appl_id, ';
3060: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.conc_program_id , ';
3061: l_dyn_sql := l_dyn_sql || ' SYSDATE , ';
3062: l_dyn_sql := l_dyn_sql || ''''||Escape_Single_Quote(l_error_msg)||''' , ' ;
3055: l_dyn_sql := l_dyn_sql || '''' ||l_intf_table(i) ||''', ' ;
3056: l_dyn_sql := l_dyn_sql || ' ''ENG_IMPT_CO_NOT_FOUND'', ';
3057: l_dyn_sql := l_dyn_sql || ' NULL , ';
3058: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.conc_request_id , ';
3059: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.prog_appl_id, ';
3060: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.conc_program_id , ';
3061: l_dyn_sql := l_dyn_sql || ' SYSDATE , ';
3062: l_dyn_sql := l_dyn_sql || ''''||Escape_Single_Quote(l_error_msg)||''' , ' ;
3063: l_dyn_sql := l_dyn_sql || ''''||G_ERROR_ENTITY_CODE||''' , ' ;
3056: l_dyn_sql := l_dyn_sql || ' ''ENG_IMPT_CO_NOT_FOUND'', ';
3057: l_dyn_sql := l_dyn_sql || ' NULL , ';
3058: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.conc_request_id , ';
3059: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.prog_appl_id, ';
3060: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.conc_program_id , ';
3061: l_dyn_sql := l_dyn_sql || ' SYSDATE , ';
3062: l_dyn_sql := l_dyn_sql || ''''||Escape_Single_Quote(l_error_msg)||''' , ' ;
3063: l_dyn_sql := l_dyn_sql || ''''||G_ERROR_ENTITY_CODE||''' , ' ;
3064: l_dyn_sql := l_dyn_sql || ''''||G_BO_IDENTIFIER||''' , ' ;
3121: -- Second it would then call CM Import API to process other entity (all entity)
3122: UPDATE EGO_IMPORT_OPTION_SETS
3123: SET CHANGE_NOTICE = p_change_number
3124: , LAST_UPDATE_DATE = SYSDATE
3125: , LAST_UPDATED_BY = FND_GLOBAL.user_id
3126: , LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
3127: WHERE BATCH_ID = p_batch_id ;
3128:
3129:
3122: UPDATE EGO_IMPORT_OPTION_SETS
3123: SET CHANGE_NOTICE = p_change_number
3124: , LAST_UPDATE_DATE = SYSDATE
3125: , LAST_UPDATED_BY = FND_GLOBAL.user_id
3126: , LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
3127: WHERE BATCH_ID = p_batch_id ;
3128:
3129:
3130: -- End of API body.
3450: l_dyn_sql := l_dyn_sql || ' INTF.ORGANIZATION_ID , ';
3451: l_dyn_sql := l_dyn_sql || ' NULL , ';
3452: l_dyn_sql := l_dyn_sql || ' INTF.TRANSACTION_ID , ';
3453: l_dyn_sql := l_dyn_sql || ' SYSDATE , ';
3454: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.user_id , ';
3455: l_dyn_sql := l_dyn_sql || ' SYSDATE , ';
3456: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.user_id , ';
3457: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.login_id , ';
3458: l_dyn_sql := l_dyn_sql || '''' ||l_intf_table(i) ||''', ' ;
3452: l_dyn_sql := l_dyn_sql || ' INTF.TRANSACTION_ID , ';
3453: l_dyn_sql := l_dyn_sql || ' SYSDATE , ';
3454: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.user_id , ';
3455: l_dyn_sql := l_dyn_sql || ' SYSDATE , ';
3456: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.user_id , ';
3457: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.login_id , ';
3458: l_dyn_sql := l_dyn_sql || '''' ||l_intf_table(i) ||''', ' ;
3459: l_dyn_sql := l_dyn_sql || ' ''ENG_IMPT_RI_NOT_FOUND'', ';
3460: l_dyn_sql := l_dyn_sql || ' NULL , ';
3453: l_dyn_sql := l_dyn_sql || ' SYSDATE , ';
3454: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.user_id , ';
3455: l_dyn_sql := l_dyn_sql || ' SYSDATE , ';
3456: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.user_id , ';
3457: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.login_id , ';
3458: l_dyn_sql := l_dyn_sql || '''' ||l_intf_table(i) ||''', ' ;
3459: l_dyn_sql := l_dyn_sql || ' ''ENG_IMPT_RI_NOT_FOUND'', ';
3460: l_dyn_sql := l_dyn_sql || ' NULL , ';
3461: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.conc_request_id , ';
3457: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.login_id , ';
3458: l_dyn_sql := l_dyn_sql || '''' ||l_intf_table(i) ||''', ' ;
3459: l_dyn_sql := l_dyn_sql || ' ''ENG_IMPT_RI_NOT_FOUND'', ';
3460: l_dyn_sql := l_dyn_sql || ' NULL , ';
3461: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.conc_request_id , ';
3462: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.prog_appl_id, ';
3463: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.conc_program_id , ';
3464: l_dyn_sql := l_dyn_sql || ' SYSDATE , ';
3465: l_dyn_sql := l_dyn_sql || ''''||Escape_Single_Quote(l_error_msg)||''' , ' ;
3458: l_dyn_sql := l_dyn_sql || '''' ||l_intf_table(i) ||''', ' ;
3459: l_dyn_sql := l_dyn_sql || ' ''ENG_IMPT_RI_NOT_FOUND'', ';
3460: l_dyn_sql := l_dyn_sql || ' NULL , ';
3461: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.conc_request_id , ';
3462: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.prog_appl_id, ';
3463: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.conc_program_id , ';
3464: l_dyn_sql := l_dyn_sql || ' SYSDATE , ';
3465: l_dyn_sql := l_dyn_sql || ''''||Escape_Single_Quote(l_error_msg)||''' , ' ;
3466: l_dyn_sql := l_dyn_sql || ''''||G_ERROR_ENTITY_CODE||''' , ' ;
3459: l_dyn_sql := l_dyn_sql || ' ''ENG_IMPT_RI_NOT_FOUND'', ';
3460: l_dyn_sql := l_dyn_sql || ' NULL , ';
3461: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.conc_request_id , ';
3462: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.prog_appl_id, ';
3463: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.conc_program_id , ';
3464: l_dyn_sql := l_dyn_sql || ' SYSDATE , ';
3465: l_dyn_sql := l_dyn_sql || ''''||Escape_Single_Quote(l_error_msg)||''' , ' ;
3466: l_dyn_sql := l_dyn_sql || ''''||G_ERROR_ENTITY_CODE||''' , ' ;
3467: l_dyn_sql := l_dyn_sql || ''''||G_BO_IDENTIFIER||''' , ' ;
3923: , p_default_seq_id => p_default_seq_id
3924: , p_revision_import_policy => p_revision_import_policy
3925: ) ;
3926:
3927: select FND_GLOBAL.CONC_REQUEST_ID INTO l_request_id from dual;
3928: if l_rev_item_seq_id is not NULL
3929: then
3930:
3931: UPDATE mtl_system_items_interface
5422: ( X_ROWID => l_dummy_rowid ,
5423: X_BATCH_ID => p_batch_id,
5424: X_CHANGE_ID => l_change_id ,
5425: X_CREATION_DATE => SYSDATE,
5426: X_CREATED_BY => FND_GLOBAL.user_id,
5427: X_LAST_UPDATE_DATE => SYSDATE,
5428: X_LAST_UPDATED_BY => FND_GLOBAL.user_id ,
5429: X_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id
5430: ) ;
5424: X_CHANGE_ID => l_change_id ,
5425: X_CREATION_DATE => SYSDATE,
5426: X_CREATED_BY => FND_GLOBAL.user_id,
5427: X_LAST_UPDATE_DATE => SYSDATE,
5428: X_LAST_UPDATED_BY => FND_GLOBAL.user_id ,
5429: X_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id
5430: ) ;
5431:
5432:
5425: X_CREATION_DATE => SYSDATE,
5426: X_CREATED_BY => FND_GLOBAL.user_id,
5427: X_LAST_UPDATE_DATE => SYSDATE,
5428: X_LAST_UPDATED_BY => FND_GLOBAL.user_id ,
5429: X_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id
5430: ) ;
5431:
5432:
5433: IF FND_API.to_Boolean(l_write_msg_to_intftbl)
5696: BEGIN
5697: null;
5698:
5699: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
5700: IF NVL(FND_GLOBAL.conc_request_id, -1) <> -1 THEN
5701:
5702: FND_FILE.put_line(which => FND_FILE.LOG
5703: ,buff => '[ENG_CHANGE_IMPORT_UTIL] '||msg);
5704: END IF;