DBA Data[Home] [Help]

APPS.AMW_LOAD_AUDIT_PROCEDURE_DATA dependencies on FND_GLOBAL

Line 8: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

4:
5: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMW_LOAD_AUDIT_PROCEDURE_DATA';
6: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amwaprb.pls';
7:
8: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
9: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
10: v_error_msg VARCHAR2(2000);
11: v_err_msg VARCHAR2(2000);
12: v_error_found boolean;

Line 9: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

5: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMW_LOAD_AUDIT_PROCEDURE_DATA';
6: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amwaprb.pls';
7:
8: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
9: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
10: v_error_msg VARCHAR2(2000);
11: v_err_msg VARCHAR2(2000);
12: v_error_found boolean;
13:

Line 166: fnd_file.put_line (fnd_file.LOG, 'resp id: '||fnd_global.RESP_ID);

162:
163: -- To handle exceptions
164: BEGIN
165: -- Adding to the log file
166: fnd_file.put_line (fnd_file.LOG, 'resp id: '||fnd_global.RESP_ID);
167: fnd_file.put_line (fnd_file.LOG, 'resp appl id: '||fnd_global.RESP_APPL_ID);
168: fnd_file.put_line (fnd_file.LOG, 'Entered the Procedure');
169:
170: -- To fetch the party id

Line 167: fnd_file.put_line (fnd_file.LOG, 'resp appl id: '||fnd_global.RESP_APPL_ID);

163: -- To handle exceptions
164: BEGIN
165: -- Adding to the log file
166: fnd_file.put_line (fnd_file.LOG, 'resp id: '||fnd_global.RESP_ID);
167: fnd_file.put_line (fnd_file.LOG, 'resp appl id: '||fnd_global.RESP_APPL_ID);
168: fnd_file.put_line (fnd_file.LOG, 'Entered the Procedure');
169:
170: -- To fetch the party id
171: select aecv.party_id into v_party_id

Line 859: IF FND_GLOBAL.User_Id IS NULL

855: -- =========================================================================
856: -- Validate Environment
857: -- =========================================================================
858:
859: IF FND_GLOBAL.User_Id IS NULL
860: THEN
861: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
862: RAISE FND_API.G_EXC_ERROR;
863: END IF;

Line 877: X_created_by => FND_GLOBAL.USER_ID,

873: fnd_documents_pkg.insert_row(
874: X_rowid => l_row_id,
875: X_document_id => x_document_id,
876: X_creation_date => sysdate,
877: X_created_by => FND_GLOBAL.USER_ID,
878: X_last_update_date => sysdate,
879: X_last_updated_by => FND_GLOBAL.USER_ID,
880: X_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
881: X_datatype_id => p_Fnd_Attachment_rec.datatype_id,

Line 879: X_last_updated_by => FND_GLOBAL.USER_ID,

875: X_document_id => x_document_id,
876: X_creation_date => sysdate,
877: X_created_by => FND_GLOBAL.USER_ID,
878: X_last_update_date => sysdate,
879: X_last_updated_by => FND_GLOBAL.USER_ID,
880: X_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
881: X_datatype_id => p_Fnd_Attachment_rec.datatype_id,
882: X_category_id => p_Fnd_Attachment_rec.category_id,
883: X_security_type => p_Fnd_Attachment_rec.security_type,

Line 880: X_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,

876: X_creation_date => sysdate,
877: X_created_by => FND_GLOBAL.USER_ID,
878: X_last_update_date => sysdate,
879: X_last_updated_by => FND_GLOBAL.USER_ID,
880: X_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
881: X_datatype_id => p_Fnd_Attachment_rec.datatype_id,
882: X_category_id => p_Fnd_Attachment_rec.category_id,
883: X_security_type => p_Fnd_Attachment_rec.security_type,
884: X_publish_flag => p_Fnd_Attachment_rec.publish_flag,

Line 968: X_created_by => FND_GLOBAL.USER_ID,

964: ( x_rowid => l_row_id,
965: X_attached_document_id => l_attached_document_ID,
966: X_document_id => x_document_ID,
967: X_creation_date => sysdate,
968: X_created_by => FND_GLOBAL.USER_ID,
969: X_last_update_date => sysdate,
970: X_last_updated_by => FND_GLOBAL.USER_ID,
971: X_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
972: X_seq_num => l_seq_num,

Line 970: X_last_updated_by => FND_GLOBAL.USER_ID,

966: X_document_id => x_document_ID,
967: X_creation_date => sysdate,
968: X_created_by => FND_GLOBAL.USER_ID,
969: X_last_update_date => sysdate,
970: X_last_updated_by => FND_GLOBAL.USER_ID,
971: X_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
972: X_seq_num => l_seq_num,
973: X_entity_name => p_Fnd_Attachment_rec.entity_name,
974: x_column1 => null,

Line 971: X_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,

967: X_creation_date => sysdate,
968: X_created_by => FND_GLOBAL.USER_ID,
969: X_last_update_date => sysdate,
970: X_last_updated_by => FND_GLOBAL.USER_ID,
971: X_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
972: X_seq_num => l_seq_num,
973: X_entity_name => p_Fnd_Attachment_rec.entity_name,
974: x_column1 => null,
975: X_pk1_value => p_Fnd_Attachment_rec.pk1_value,