DBA Data[Home] [Help]

APPS.ENG_CHANGE_IMPORT_UTIL dependencies on FND_GLOBAL

Line 26: G_CARRIAGE_RETURN VARCHAR2(1) := FND_GLOBAL.LOCAL_CHR(13);

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:

Line 27: G_LINE_FEED VARCHAR2(1) := FND_GLOBAL.LOCAL_CHR(10);

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:

Line 829: , FND_GLOBAL.user_id

825: VALUES
826: ( NULL
827: , NULL
828: , SYSDATE
829: , FND_GLOBAL.user_id
830: , SYSDATE
831: , FND_GLOBAL.user_id
832: , FND_GLOBAL.login_id
833: , p_error_table_name

Line 831: , FND_GLOBAL.user_id

827: , NULL
828: , SYSDATE
829: , FND_GLOBAL.user_id
830: , SYSDATE
831: , FND_GLOBAL.user_id
832: , FND_GLOBAL.login_id
833: , p_error_table_name
834: , p_error_msg_name
835: , p_error_table_name

Line 832: , FND_GLOBAL.login_id

828: , SYSDATE
829: , FND_GLOBAL.user_id
830: , SYSDATE
831: , FND_GLOBAL.user_id
832: , FND_GLOBAL.login_id
833: , p_error_table_name
834: , p_error_msg_name
835: , p_error_table_name
836: , FND_GLOBAL.conc_request_id

Line 836: , FND_GLOBAL.conc_request_id

832: , FND_GLOBAL.login_id
833: , p_error_table_name
834: , p_error_msg_name
835: , p_error_table_name
836: , FND_GLOBAL.conc_request_id
837: , FND_GLOBAL.prog_appl_id
838: , FND_GLOBAL.conc_program_id
839: , SYSDATE
840: , SUBSTR(p_error_msg ,1, 2000)

Line 837: , FND_GLOBAL.prog_appl_id

833: , p_error_table_name
834: , p_error_msg_name
835: , p_error_table_name
836: , FND_GLOBAL.conc_request_id
837: , FND_GLOBAL.prog_appl_id
838: , FND_GLOBAL.conc_program_id
839: , SYSDATE
840: , SUBSTR(p_error_msg ,1, 2000)
841: , p_transaction_id

Line 838: , FND_GLOBAL.conc_program_id

834: , p_error_msg_name
835: , p_error_table_name
836: , FND_GLOBAL.conc_request_id
837: , FND_GLOBAL.prog_appl_id
838: , FND_GLOBAL.conc_program_id
839: , SYSDATE
840: , SUBSTR(p_error_msg ,1, 2000)
841: , p_transaction_id
842: , p_error_entity_code

Line 1236: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.user_id , ';

1232: l_dyn_sql := l_dyn_sql || ' INTF.ORGANIZATION_ID , ';
1233: l_dyn_sql := l_dyn_sql || ' NULL , ';
1234: l_dyn_sql := l_dyn_sql || ' INTF.TRANSACTION_ID , ';
1235: l_dyn_sql := l_dyn_sql || ' SYSDATE , ';
1236: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.user_id , ';
1237: l_dyn_sql := l_dyn_sql || ' SYSDATE , ';
1238: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.user_id , ';
1239: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.login_id , ';
1240: l_dyn_sql := l_dyn_sql || '''' ||l_intf_table(i) ||''', ' ;

Line 1238: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.user_id , ';

1234: l_dyn_sql := l_dyn_sql || ' INTF.TRANSACTION_ID , ';
1235: l_dyn_sql := l_dyn_sql || ' SYSDATE , ';
1236: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.user_id , ';
1237: l_dyn_sql := l_dyn_sql || ' SYSDATE , ';
1238: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.user_id , ';
1239: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.login_id , ';
1240: l_dyn_sql := l_dyn_sql || '''' ||l_intf_table(i) ||''', ' ;
1241: l_dyn_sql := l_dyn_sql || ''''||l_error_msg_name|| ''', ';
1242: l_dyn_sql := l_dyn_sql || ' NULL , ';

Line 1239: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.login_id , ';

1235: l_dyn_sql := l_dyn_sql || ' SYSDATE , ';
1236: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.user_id , ';
1237: l_dyn_sql := l_dyn_sql || ' SYSDATE , ';
1238: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.user_id , ';
1239: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.login_id , ';
1240: l_dyn_sql := l_dyn_sql || '''' ||l_intf_table(i) ||''', ' ;
1241: l_dyn_sql := l_dyn_sql || ''''||l_error_msg_name|| ''', ';
1242: l_dyn_sql := l_dyn_sql || ' NULL , ';
1243: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.conc_request_id , ';

Line 1243: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.conc_request_id , ';

1239: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.login_id , ';
1240: l_dyn_sql := l_dyn_sql || '''' ||l_intf_table(i) ||''', ' ;
1241: l_dyn_sql := l_dyn_sql || ''''||l_error_msg_name|| ''', ';
1242: l_dyn_sql := l_dyn_sql || ' NULL , ';
1243: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.conc_request_id , ';
1244: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.prog_appl_id, ';
1245: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.conc_program_id , ';
1246: l_dyn_sql := l_dyn_sql || ' SYSDATE , ';
1247: l_dyn_sql := l_dyn_sql || ''''||Escape_Single_Quote(l_error_msg_text)||''' , ' ;

Line 1244: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.prog_appl_id, ';

1240: l_dyn_sql := l_dyn_sql || '''' ||l_intf_table(i) ||''', ' ;
1241: l_dyn_sql := l_dyn_sql || ''''||l_error_msg_name|| ''', ';
1242: l_dyn_sql := l_dyn_sql || ' NULL , ';
1243: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.conc_request_id , ';
1244: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.prog_appl_id, ';
1245: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.conc_program_id , ';
1246: l_dyn_sql := l_dyn_sql || ' SYSDATE , ';
1247: l_dyn_sql := l_dyn_sql || ''''||Escape_Single_Quote(l_error_msg_text)||''' , ' ;
1248: l_dyn_sql := l_dyn_sql || ''''||G_ERROR_ENTITY_CODE||''' , ' ;

Line 1245: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.conc_program_id , ';

1241: l_dyn_sql := l_dyn_sql || ''''||l_error_msg_name|| ''', ';
1242: l_dyn_sql := l_dyn_sql || ' NULL , ';
1243: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.conc_request_id , ';
1244: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.prog_appl_id, ';
1245: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.conc_program_id , ';
1246: l_dyn_sql := l_dyn_sql || ' SYSDATE , ';
1247: l_dyn_sql := l_dyn_sql || ''''||Escape_Single_Quote(l_error_msg_text)||''' , ' ;
1248: l_dyn_sql := l_dyn_sql || ''''||G_ERROR_ENTITY_CODE||''' , ' ;
1249: l_dyn_sql := l_dyn_sql || ''''||G_BO_IDENTIFIER||''', ' ;

Line 2945: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.user_id , ';

2941: l_dyn_sql := l_dyn_sql || ' INTF.ORGANIZATION_ID , ';
2942: l_dyn_sql := l_dyn_sql || ' NULL , ';
2943: l_dyn_sql := l_dyn_sql || ' INTF.TRANSACTION_ID , ';
2944: l_dyn_sql := l_dyn_sql || ' SYSDATE , ';
2945: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.user_id , ';
2946: l_dyn_sql := l_dyn_sql || ' SYSDATE , ';
2947: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.user_id , ';
2948: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.login_id , ';
2949: l_dyn_sql := l_dyn_sql || '''' ||l_intf_table(i) ||''', ' ;

Line 2947: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.user_id , ';

2943: l_dyn_sql := l_dyn_sql || ' INTF.TRANSACTION_ID , ';
2944: l_dyn_sql := l_dyn_sql || ' SYSDATE , ';
2945: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.user_id , ';
2946: l_dyn_sql := l_dyn_sql || ' SYSDATE , ';
2947: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.user_id , ';
2948: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.login_id , ';
2949: l_dyn_sql := l_dyn_sql || '''' ||l_intf_table(i) ||''', ' ;
2950: l_dyn_sql := l_dyn_sql || ' ''ENG_IMPT_CO_NOT_FOUND'', ';
2951: l_dyn_sql := l_dyn_sql || ' NULL , ';

Line 2948: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.login_id , ';

2944: l_dyn_sql := l_dyn_sql || ' SYSDATE , ';
2945: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.user_id , ';
2946: l_dyn_sql := l_dyn_sql || ' SYSDATE , ';
2947: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.user_id , ';
2948: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.login_id , ';
2949: l_dyn_sql := l_dyn_sql || '''' ||l_intf_table(i) ||''', ' ;
2950: l_dyn_sql := l_dyn_sql || ' ''ENG_IMPT_CO_NOT_FOUND'', ';
2951: l_dyn_sql := l_dyn_sql || ' NULL , ';
2952: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.conc_request_id , ';

Line 2952: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.conc_request_id , ';

2948: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.login_id , ';
2949: l_dyn_sql := l_dyn_sql || '''' ||l_intf_table(i) ||''', ' ;
2950: l_dyn_sql := l_dyn_sql || ' ''ENG_IMPT_CO_NOT_FOUND'', ';
2951: l_dyn_sql := l_dyn_sql || ' NULL , ';
2952: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.conc_request_id , ';
2953: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.prog_appl_id, ';
2954: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.conc_program_id , ';
2955: l_dyn_sql := l_dyn_sql || ' SYSDATE , ';
2956: l_dyn_sql := l_dyn_sql || ''''||Escape_Single_Quote(l_error_msg)||''' , ' ;

Line 2953: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.prog_appl_id, ';

2949: l_dyn_sql := l_dyn_sql || '''' ||l_intf_table(i) ||''', ' ;
2950: l_dyn_sql := l_dyn_sql || ' ''ENG_IMPT_CO_NOT_FOUND'', ';
2951: l_dyn_sql := l_dyn_sql || ' NULL , ';
2952: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.conc_request_id , ';
2953: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.prog_appl_id, ';
2954: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.conc_program_id , ';
2955: l_dyn_sql := l_dyn_sql || ' SYSDATE , ';
2956: l_dyn_sql := l_dyn_sql || ''''||Escape_Single_Quote(l_error_msg)||''' , ' ;
2957: l_dyn_sql := l_dyn_sql || ''''||G_ERROR_ENTITY_CODE||''' , ' ;

Line 2954: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.conc_program_id , ';

2950: l_dyn_sql := l_dyn_sql || ' ''ENG_IMPT_CO_NOT_FOUND'', ';
2951: l_dyn_sql := l_dyn_sql || ' NULL , ';
2952: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.conc_request_id , ';
2953: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.prog_appl_id, ';
2954: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.conc_program_id , ';
2955: l_dyn_sql := l_dyn_sql || ' SYSDATE , ';
2956: l_dyn_sql := l_dyn_sql || ''''||Escape_Single_Quote(l_error_msg)||''' , ' ;
2957: l_dyn_sql := l_dyn_sql || ''''||G_ERROR_ENTITY_CODE||''' , ' ;
2958: l_dyn_sql := l_dyn_sql || ''''||G_BO_IDENTIFIER||''' , ' ;

Line 3019: , LAST_UPDATED_BY = FND_GLOBAL.user_id

3015: -- Second it would then call CM Import API to process other entity (all entity)
3016: UPDATE EGO_IMPORT_OPTION_SETS
3017: SET CHANGE_NOTICE = p_change_number
3018: , LAST_UPDATE_DATE = SYSDATE
3019: , LAST_UPDATED_BY = FND_GLOBAL.user_id
3020: , LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
3021: WHERE BATCH_ID = p_batch_id ;
3022:
3023:

Line 3020: , LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

3016: UPDATE EGO_IMPORT_OPTION_SETS
3017: SET CHANGE_NOTICE = p_change_number
3018: , LAST_UPDATE_DATE = SYSDATE
3019: , LAST_UPDATED_BY = FND_GLOBAL.user_id
3020: , LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
3021: WHERE BATCH_ID = p_batch_id ;
3022:
3023:
3024: -- End of API body.

Line 3348: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.user_id , ';

3344: l_dyn_sql := l_dyn_sql || ' INTF.ORGANIZATION_ID , ';
3345: l_dyn_sql := l_dyn_sql || ' NULL , ';
3346: l_dyn_sql := l_dyn_sql || ' INTF.TRANSACTION_ID , ';
3347: l_dyn_sql := l_dyn_sql || ' SYSDATE , ';
3348: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.user_id , ';
3349: l_dyn_sql := l_dyn_sql || ' SYSDATE , ';
3350: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.user_id , ';
3351: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.login_id , ';
3352: l_dyn_sql := l_dyn_sql || '''' ||l_intf_table(i) ||''', ' ;

Line 3350: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.user_id , ';

3346: l_dyn_sql := l_dyn_sql || ' INTF.TRANSACTION_ID , ';
3347: l_dyn_sql := l_dyn_sql || ' SYSDATE , ';
3348: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.user_id , ';
3349: l_dyn_sql := l_dyn_sql || ' SYSDATE , ';
3350: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.user_id , ';
3351: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.login_id , ';
3352: l_dyn_sql := l_dyn_sql || '''' ||l_intf_table(i) ||''', ' ;
3353: l_dyn_sql := l_dyn_sql || ' ''ENG_IMPT_RI_NOT_FOUND'', ';
3354: l_dyn_sql := l_dyn_sql || ' NULL , ';

Line 3351: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.login_id , ';

3347: l_dyn_sql := l_dyn_sql || ' SYSDATE , ';
3348: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.user_id , ';
3349: l_dyn_sql := l_dyn_sql || ' SYSDATE , ';
3350: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.user_id , ';
3351: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.login_id , ';
3352: l_dyn_sql := l_dyn_sql || '''' ||l_intf_table(i) ||''', ' ;
3353: l_dyn_sql := l_dyn_sql || ' ''ENG_IMPT_RI_NOT_FOUND'', ';
3354: l_dyn_sql := l_dyn_sql || ' NULL , ';
3355: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.conc_request_id , ';

Line 3355: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.conc_request_id , ';

3351: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.login_id , ';
3352: l_dyn_sql := l_dyn_sql || '''' ||l_intf_table(i) ||''', ' ;
3353: l_dyn_sql := l_dyn_sql || ' ''ENG_IMPT_RI_NOT_FOUND'', ';
3354: l_dyn_sql := l_dyn_sql || ' NULL , ';
3355: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.conc_request_id , ';
3356: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.prog_appl_id, ';
3357: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.conc_program_id , ';
3358: l_dyn_sql := l_dyn_sql || ' SYSDATE , ';
3359: l_dyn_sql := l_dyn_sql || ''''||Escape_Single_Quote(l_error_msg)||''' , ' ;

Line 3356: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.prog_appl_id, ';

3352: l_dyn_sql := l_dyn_sql || '''' ||l_intf_table(i) ||''', ' ;
3353: l_dyn_sql := l_dyn_sql || ' ''ENG_IMPT_RI_NOT_FOUND'', ';
3354: l_dyn_sql := l_dyn_sql || ' NULL , ';
3355: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.conc_request_id , ';
3356: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.prog_appl_id, ';
3357: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.conc_program_id , ';
3358: l_dyn_sql := l_dyn_sql || ' SYSDATE , ';
3359: l_dyn_sql := l_dyn_sql || ''''||Escape_Single_Quote(l_error_msg)||''' , ' ;
3360: l_dyn_sql := l_dyn_sql || ''''||G_ERROR_ENTITY_CODE||''' , ' ;

Line 3357: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.conc_program_id , ';

3353: l_dyn_sql := l_dyn_sql || ' ''ENG_IMPT_RI_NOT_FOUND'', ';
3354: l_dyn_sql := l_dyn_sql || ' NULL , ';
3355: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.conc_request_id , ';
3356: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.prog_appl_id, ';
3357: l_dyn_sql := l_dyn_sql || ' FND_GLOBAL.conc_program_id , ';
3358: l_dyn_sql := l_dyn_sql || ' SYSDATE , ';
3359: l_dyn_sql := l_dyn_sql || ''''||Escape_Single_Quote(l_error_msg)||''' , ' ;
3360: l_dyn_sql := l_dyn_sql || ''''||G_ERROR_ENTITY_CODE||''' , ' ;
3361: l_dyn_sql := l_dyn_sql || ''''||G_BO_IDENTIFIER||''' , ' ;

Line 3821: select FND_GLOBAL.CONC_REQUEST_ID INTO l_request_id from dual;

3817: , p_default_seq_id => p_default_seq_id
3818: , p_revision_import_policy => p_revision_import_policy
3819: ) ;
3820:
3821: select FND_GLOBAL.CONC_REQUEST_ID INTO l_request_id from dual;
3822: if l_rev_item_seq_id is not NULL
3823: then
3824:
3825: UPDATE mtl_system_items_interface

Line 5311: X_CREATED_BY => FND_GLOBAL.user_id,

5307: ( X_ROWID => l_dummy_rowid ,
5308: X_BATCH_ID => p_batch_id,
5309: X_CHANGE_ID => l_change_id ,
5310: X_CREATION_DATE => SYSDATE,
5311: X_CREATED_BY => FND_GLOBAL.user_id,
5312: X_LAST_UPDATE_DATE => SYSDATE,
5313: X_LAST_UPDATED_BY => FND_GLOBAL.user_id ,
5314: X_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id
5315: ) ;

Line 5313: X_LAST_UPDATED_BY => FND_GLOBAL.user_id ,

5309: X_CHANGE_ID => l_change_id ,
5310: X_CREATION_DATE => SYSDATE,
5311: X_CREATED_BY => FND_GLOBAL.user_id,
5312: X_LAST_UPDATE_DATE => SYSDATE,
5313: X_LAST_UPDATED_BY => FND_GLOBAL.user_id ,
5314: X_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id
5315: ) ;
5316:
5317:

Line 5314: X_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id

5310: X_CREATION_DATE => SYSDATE,
5311: X_CREATED_BY => FND_GLOBAL.user_id,
5312: X_LAST_UPDATE_DATE => SYSDATE,
5313: X_LAST_UPDATED_BY => FND_GLOBAL.user_id ,
5314: X_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id
5315: ) ;
5316:
5317:
5318: IF FND_API.to_Boolean(l_write_msg_to_intftbl)