57: l_api_name VARCHAR2(255):='create_arch_msgdtls';
58: l_api_version_number NUMBER:=1.0;
59: l_seq_id NUMBER;
60:
61: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;
62: l_msg_count NUMBER := 0;
63: l_msg_data VARCHAR2(2000);
64: i INTEGER;
65:
72: SAVEPOINT create_arch_msgdtls_PVT;
73:
74: -- Standard call to check for call compatibility.
75:
76: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
77: p_api_version_number,
78: l_api_name,
79: G_PKG_NAME)
80: THEN
77: p_api_version_number,
78: l_api_name,
79: G_PKG_NAME)
80: THEN
81: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
82: END IF;
83:
84:
85: -- Initialize message list if p_init_msg_list is set to TRUE.
82: END IF;
83:
84:
85: -- Initialize message list if p_init_msg_list is set to TRUE.
86: IF FND_API.to_Boolean( p_init_msg_list )
87: THEN
88: FND_MSG_PUB.initialize;
89: END IF;
90:
88: FND_MSG_PUB.initialize;
89: END IF;
90:
91: -- Initialize API return status to SUCCESS
92: x_return_status := FND_API.G_RET_STS_SUCCESS;
93:
94: --begins here
95:
96: --get next sequential number for msg_meta_id
94: --begins here
95:
96: --get next sequential number for msg_meta_id
97:
98: if (p_message_id = FND_API.G_MISS_NUM) then -- MAIL_TYPE = outbound
99: SELECT IEM_MS_BASE_HEADERS_S1.nextval
100: INTO l_seq_id
101: FROM dual;
102: else
151: )
152: VALUES
153: (
154: l_seq_id,
155: decode(p_inbound_message_id, FND_API.G_MISS_NUM, null, p_inbound_message_id),
156: p_email_account_id,
157: p_mailproc_status,
158: decode(p_rt_classification_id, FND_API.G_MISS_NUM, null, p_rt_classification_id),
159: p_mail_type,
154: l_seq_id,
155: decode(p_inbound_message_id, FND_API.G_MISS_NUM, null, p_inbound_message_id),
156: p_email_account_id,
157: p_mailproc_status,
158: decode(p_rt_classification_id, FND_API.G_MISS_NUM, null, p_rt_classification_id),
159: p_mail_type,
160: p_from_str,
161: decode(p_reply_to_str, FND_API.G_MISS_CHAR, null, p_reply_to_str),
162: p_to_str,
157: p_mailproc_status,
158: decode(p_rt_classification_id, FND_API.G_MISS_NUM, null, p_rt_classification_id),
159: p_mail_type,
160: p_from_str,
161: decode(p_reply_to_str, FND_API.G_MISS_CHAR, null, p_reply_to_str),
162: p_to_str,
163: decode(p_cc_str, FND_API.G_MISS_CHAR, null, p_cc_str),
164: decode(p_bcc_str, FND_API.G_MISS_CHAR, null, p_bcc_str),
165: p_sent_date,
159: p_mail_type,
160: p_from_str,
161: decode(p_reply_to_str, FND_API.G_MISS_CHAR, null, p_reply_to_str),
162: p_to_str,
163: decode(p_cc_str, FND_API.G_MISS_CHAR, null, p_cc_str),
164: decode(p_bcc_str, FND_API.G_MISS_CHAR, null, p_bcc_str),
165: p_sent_date,
166: decode(p_received_date, FND_API.G_MISS_DATE, null, p_received_date),
167: decode(p_subject, FND_API.G_MISS_CHAR, null, p_subject),
160: p_from_str,
161: decode(p_reply_to_str, FND_API.G_MISS_CHAR, null, p_reply_to_str),
162: p_to_str,
163: decode(p_cc_str, FND_API.G_MISS_CHAR, null, p_cc_str),
164: decode(p_bcc_str, FND_API.G_MISS_CHAR, null, p_bcc_str),
165: p_sent_date,
166: decode(p_received_date, FND_API.G_MISS_DATE, null, p_received_date),
167: decode(p_subject, FND_API.G_MISS_CHAR, null, p_subject),
168: decode(p_agent_id, FND_API.G_MISS_NUM, null, p_agent_id),
162: p_to_str,
163: decode(p_cc_str, FND_API.G_MISS_CHAR, null, p_cc_str),
164: decode(p_bcc_str, FND_API.G_MISS_CHAR, null, p_bcc_str),
165: p_sent_date,
166: decode(p_received_date, FND_API.G_MISS_DATE, null, p_received_date),
167: decode(p_subject, FND_API.G_MISS_CHAR, null, p_subject),
168: decode(p_agent_id, FND_API.G_MISS_NUM, null, p_agent_id),
169: decode(p_group_id, FND_API.G_MISS_NUM, null, p_group_id),
170: decode(p_ih_media_item_id, FND_API.G_MISS_NUM, null, p_ih_media_item_id),
163: decode(p_cc_str, FND_API.G_MISS_CHAR, null, p_cc_str),
164: decode(p_bcc_str, FND_API.G_MISS_CHAR, null, p_bcc_str),
165: p_sent_date,
166: decode(p_received_date, FND_API.G_MISS_DATE, null, p_received_date),
167: decode(p_subject, FND_API.G_MISS_CHAR, null, p_subject),
168: decode(p_agent_id, FND_API.G_MISS_NUM, null, p_agent_id),
169: decode(p_group_id, FND_API.G_MISS_NUM, null, p_group_id),
170: decode(p_ih_media_item_id, FND_API.G_MISS_NUM, null, p_ih_media_item_id),
171: decode(p_customer_id, FND_API.G_MISS_NUM, null, p_customer_id),
164: decode(p_bcc_str, FND_API.G_MISS_CHAR, null, p_bcc_str),
165: p_sent_date,
166: decode(p_received_date, FND_API.G_MISS_DATE, null, p_received_date),
167: decode(p_subject, FND_API.G_MISS_CHAR, null, p_subject),
168: decode(p_agent_id, FND_API.G_MISS_NUM, null, p_agent_id),
169: decode(p_group_id, FND_API.G_MISS_NUM, null, p_group_id),
170: decode(p_ih_media_item_id, FND_API.G_MISS_NUM, null, p_ih_media_item_id),
171: decode(p_customer_id, FND_API.G_MISS_NUM, null, p_customer_id),
172: p_message_size,
165: p_sent_date,
166: decode(p_received_date, FND_API.G_MISS_DATE, null, p_received_date),
167: decode(p_subject, FND_API.G_MISS_CHAR, null, p_subject),
168: decode(p_agent_id, FND_API.G_MISS_NUM, null, p_agent_id),
169: decode(p_group_id, FND_API.G_MISS_NUM, null, p_group_id),
170: decode(p_ih_media_item_id, FND_API.G_MISS_NUM, null, p_ih_media_item_id),
171: decode(p_customer_id, FND_API.G_MISS_NUM, null, p_customer_id),
172: p_message_size,
173: decode(p_contact_id, FND_API.G_MISS_NUM, null, p_contact_id),
166: decode(p_received_date, FND_API.G_MISS_DATE, null, p_received_date),
167: decode(p_subject, FND_API.G_MISS_CHAR, null, p_subject),
168: decode(p_agent_id, FND_API.G_MISS_NUM, null, p_agent_id),
169: decode(p_group_id, FND_API.G_MISS_NUM, null, p_group_id),
170: decode(p_ih_media_item_id, FND_API.G_MISS_NUM, null, p_ih_media_item_id),
171: decode(p_customer_id, FND_API.G_MISS_NUM, null, p_customer_id),
172: p_message_size,
173: decode(p_contact_id, FND_API.G_MISS_NUM, null, p_contact_id),
174: decode(p_relationship_id, FND_API.G_MISS_NUM, null, p_relationship_id),
167: decode(p_subject, FND_API.G_MISS_CHAR, null, p_subject),
168: decode(p_agent_id, FND_API.G_MISS_NUM, null, p_agent_id),
169: decode(p_group_id, FND_API.G_MISS_NUM, null, p_group_id),
170: decode(p_ih_media_item_id, FND_API.G_MISS_NUM, null, p_ih_media_item_id),
171: decode(p_customer_id, FND_API.G_MISS_NUM, null, p_customer_id),
172: p_message_size,
173: decode(p_contact_id, FND_API.G_MISS_NUM, null, p_contact_id),
174: decode(p_relationship_id, FND_API.G_MISS_NUM, null, p_relationship_id),
175: decode(p_top_intent, FND_API.G_MISS_CHAR, null, p_top_intent),
169: decode(p_group_id, FND_API.G_MISS_NUM, null, p_group_id),
170: decode(p_ih_media_item_id, FND_API.G_MISS_NUM, null, p_ih_media_item_id),
171: decode(p_customer_id, FND_API.G_MISS_NUM, null, p_customer_id),
172: p_message_size,
173: decode(p_contact_id, FND_API.G_MISS_NUM, null, p_contact_id),
174: decode(p_relationship_id, FND_API.G_MISS_NUM, null, p_relationship_id),
175: decode(p_top_intent, FND_API.G_MISS_CHAR, null, p_top_intent),
176: decode(p_message_text, FND_API.G_MISS_CHAR, null, p_message_text),
177: decode(p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
170: decode(p_ih_media_item_id, FND_API.G_MISS_NUM, null, p_ih_media_item_id),
171: decode(p_customer_id, FND_API.G_MISS_NUM, null, p_customer_id),
172: p_message_size,
173: decode(p_contact_id, FND_API.G_MISS_NUM, null, p_contact_id),
174: decode(p_relationship_id, FND_API.G_MISS_NUM, null, p_relationship_id),
175: decode(p_top_intent, FND_API.G_MISS_CHAR, null, p_top_intent),
176: decode(p_message_text, FND_API.G_MISS_CHAR, null, p_message_text),
177: decode(p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
178: decode(p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
171: decode(p_customer_id, FND_API.G_MISS_NUM, null, p_customer_id),
172: p_message_size,
173: decode(p_contact_id, FND_API.G_MISS_NUM, null, p_contact_id),
174: decode(p_relationship_id, FND_API.G_MISS_NUM, null, p_relationship_id),
175: decode(p_top_intent, FND_API.G_MISS_CHAR, null, p_top_intent),
176: decode(p_message_text, FND_API.G_MISS_CHAR, null, p_message_text),
177: decode(p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
178: decode(p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
179: decode(p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
172: p_message_size,
173: decode(p_contact_id, FND_API.G_MISS_NUM, null, p_contact_id),
174: decode(p_relationship_id, FND_API.G_MISS_NUM, null, p_relationship_id),
175: decode(p_top_intent, FND_API.G_MISS_CHAR, null, p_top_intent),
176: decode(p_message_text, FND_API.G_MISS_CHAR, null, p_message_text),
177: decode(p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
178: decode(p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
179: decode(p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
180: decode(p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
173: decode(p_contact_id, FND_API.G_MISS_NUM, null, p_contact_id),
174: decode(p_relationship_id, FND_API.G_MISS_NUM, null, p_relationship_id),
175: decode(p_top_intent, FND_API.G_MISS_CHAR, null, p_top_intent),
176: decode(p_message_text, FND_API.G_MISS_CHAR, null, p_message_text),
177: decode(p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
178: decode(p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
179: decode(p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
180: decode(p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
181: decode(p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
174: decode(p_relationship_id, FND_API.G_MISS_NUM, null, p_relationship_id),
175: decode(p_top_intent, FND_API.G_MISS_CHAR, null, p_top_intent),
176: decode(p_message_text, FND_API.G_MISS_CHAR, null, p_message_text),
177: decode(p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
178: decode(p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
179: decode(p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
180: decode(p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
181: decode(p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
182: decode(p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
175: decode(p_top_intent, FND_API.G_MISS_CHAR, null, p_top_intent),
176: decode(p_message_text, FND_API.G_MISS_CHAR, null, p_message_text),
177: decode(p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
178: decode(p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
179: decode(p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
180: decode(p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
181: decode(p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
182: decode(p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
183: decode(p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
176: decode(p_message_text, FND_API.G_MISS_CHAR, null, p_message_text),
177: decode(p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
178: decode(p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
179: decode(p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
180: decode(p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
181: decode(p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
182: decode(p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
183: decode(p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
184: decode(p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
177: decode(p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
178: decode(p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
179: decode(p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
180: decode(p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
181: decode(p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
182: decode(p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
183: decode(p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
184: decode(p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
185: decode(p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
178: decode(p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
179: decode(p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
180: decode(p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
181: decode(p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
182: decode(p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
183: decode(p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
184: decode(p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
185: decode(p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
186: decode(p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
179: decode(p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
180: decode(p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
181: decode(p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
182: decode(p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
183: decode(p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
184: decode(p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
185: decode(p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
186: decode(p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
187: decode(p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
180: decode(p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
181: decode(p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
182: decode(p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
183: decode(p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
184: decode(p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
185: decode(p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
186: decode(p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
187: decode(p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
188: decode(p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
181: decode(p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
182: decode(p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
183: decode(p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
184: decode(p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
185: decode(p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
186: decode(p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
187: decode(p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
188: decode(p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
189: decode(p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
182: decode(p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
183: decode(p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
184: decode(p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
185: decode(p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
186: decode(p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
187: decode(p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
188: decode(p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
189: decode(p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
190: decode(p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
183: decode(p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
184: decode(p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
185: decode(p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
186: decode(p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
187: decode(p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
188: decode(p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
189: decode(p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
190: decode(p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
191: decode(p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
184: decode(p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
185: decode(p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
186: decode(p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
187: decode(p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
188: decode(p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
189: decode(p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
190: decode(p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
191: decode(p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
192: --Changes for Bug no 7293941
185: decode(p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
186: decode(p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
187: decode(p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
188: decode(p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
189: decode(p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
190: decode(p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
191: decode(p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
192: --Changes for Bug no 7293941
193: decode(l_created_updated_by,null,-1,l_created_updated_by),
186: decode(p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
187: decode(p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
188: decode(p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
189: decode(p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
190: decode(p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
191: decode(p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
192: --Changes for Bug no 7293941
193: decode(l_created_updated_by,null,-1,l_created_updated_by),
194: sysdate,
187: decode(p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
188: decode(p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
189: decode(p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
190: decode(p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
191: decode(p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
192: --Changes for Bug no 7293941
193: decode(l_created_updated_by,null,-1,l_created_updated_by),
194: sysdate,
195: decode(l_created_updated_by,null,-1,l_created_updated_by),
200:
201: x_message_id := l_seq_id;
202:
203: -- Standard Check Of p_commit.
204: IF FND_API.To_Boolean(p_commit) THEN
205: COMMIT WORK;
206: END IF;
207:
208:
213: );
214:
215: EXCEPTION
216:
217: WHEN FND_API.G_EXC_ERROR THEN
218: ROLLBACK TO create_arch_msgdtls_PVT;
219: x_return_status := FND_API.G_RET_STS_ERROR ;
220: FND_MSG_PUB.Count_And_Get
221:
215: EXCEPTION
216:
217: WHEN FND_API.G_EXC_ERROR THEN
218: ROLLBACK TO create_arch_msgdtls_PVT;
219: x_return_status := FND_API.G_RET_STS_ERROR ;
220: FND_MSG_PUB.Count_And_Get
221:
222: ( p_count => x_msg_count,
223: p_data => x_msg_data
222: ( p_count => x_msg_count,
223: p_data => x_msg_data
224: );
225:
226: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
227: ROLLBACK TO create_arch_msgdtls_PVT;
228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
229: FND_MSG_PUB.Count_And_Get
230: ( p_count => x_msg_count,
224: );
225:
226: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
227: ROLLBACK TO create_arch_msgdtls_PVT;
228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
229: FND_MSG_PUB.Count_And_Get
230: ( p_count => x_msg_count,
231: p_data => x_msg_data
232: );
232: );
233:
234: WHEN OTHERS THEN
235: ROLLBACK TO create_arch_msgdtls_PVT;
236: x_return_status := FND_API.G_RET_STS_ERROR;
237: IF FND_MSG_PUB.Check_Msg_Level
238: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
239: THEN
240: FND_MSG_PUB.Add_Exc_Msg