eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IEM_ARCH_MSGDTLS_PVT dependencies on FND_API

Line 61: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;

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:

Line 73: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

69: SAVEPOINT create_arch_msgdtls_PVT;
70:
71: -- Standard call to check for call compatibility.
72:
73: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
74: p_api_version_number,
75: l_api_name,
76: G_PKG_NAME)
77: THEN

Line 78: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

74: p_api_version_number,
75: l_api_name,
76: G_PKG_NAME)
77: THEN
78: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
79: END IF;
80:
81:
82: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 83: IF FND_API.to_Boolean( p_init_msg_list )

79: END IF;
80:
81:
82: -- Initialize message list if p_init_msg_list is set to TRUE.
83: IF FND_API.to_Boolean( p_init_msg_list )
84: THEN
85: FND_MSG_PUB.initialize;
86: END IF;
87:

Line 89: x_return_status := FND_API.G_RET_STS_SUCCESS;

85: FND_MSG_PUB.initialize;
86: END IF;
87:
88: -- Initialize API return status to SUCCESS
89: x_return_status := FND_API.G_RET_STS_SUCCESS;
90:
91: --begins here
92:
93: --get next sequential number for msg_meta_id

Line 95: if (p_message_id = FND_API.G_MISS_NUM) then -- MAIL_TYPE = outbound

91: --begins here
92:
93: --get next sequential number for msg_meta_id
94:
95: if (p_message_id = FND_API.G_MISS_NUM) then -- MAIL_TYPE = outbound
96: SELECT IEM_MS_BASE_HEADERS_S1.nextval
97: INTO l_seq_id
98: FROM dual;
99: else

Line 152: decode(p_inbound_message_id, FND_API.G_MISS_NUM, null, p_inbound_message_id),

148: )
149: VALUES
150: (
151: l_seq_id,
152: decode(p_inbound_message_id, FND_API.G_MISS_NUM, null, p_inbound_message_id),
153: p_email_account_id,
154: p_mailproc_status,
155: decode(p_rt_classification_id, FND_API.G_MISS_NUM, null, p_rt_classification_id),
156: p_mail_type,

Line 155: decode(p_rt_classification_id, FND_API.G_MISS_NUM, null, p_rt_classification_id),

151: l_seq_id,
152: decode(p_inbound_message_id, FND_API.G_MISS_NUM, null, p_inbound_message_id),
153: p_email_account_id,
154: p_mailproc_status,
155: decode(p_rt_classification_id, FND_API.G_MISS_NUM, null, p_rt_classification_id),
156: p_mail_type,
157: p_from_str,
158: decode(p_reply_to_str, FND_API.G_MISS_CHAR, null, p_reply_to_str),
159: p_to_str,

Line 158: decode(p_reply_to_str, FND_API.G_MISS_CHAR, null, p_reply_to_str),

154: p_mailproc_status,
155: decode(p_rt_classification_id, FND_API.G_MISS_NUM, null, p_rt_classification_id),
156: p_mail_type,
157: p_from_str,
158: decode(p_reply_to_str, FND_API.G_MISS_CHAR, null, p_reply_to_str),
159: p_to_str,
160: decode(p_cc_str, FND_API.G_MISS_CHAR, null, p_cc_str),
161: decode(p_bcc_str, FND_API.G_MISS_CHAR, null, p_bcc_str),
162: p_sent_date,

Line 160: decode(p_cc_str, FND_API.G_MISS_CHAR, null, p_cc_str),

156: p_mail_type,
157: p_from_str,
158: decode(p_reply_to_str, FND_API.G_MISS_CHAR, null, p_reply_to_str),
159: p_to_str,
160: decode(p_cc_str, FND_API.G_MISS_CHAR, null, p_cc_str),
161: decode(p_bcc_str, FND_API.G_MISS_CHAR, null, p_bcc_str),
162: p_sent_date,
163: decode(p_received_date, FND_API.G_MISS_DATE, null, p_received_date),
164: decode(p_subject, FND_API.G_MISS_CHAR, null, p_subject),

Line 161: decode(p_bcc_str, FND_API.G_MISS_CHAR, null, p_bcc_str),

157: p_from_str,
158: decode(p_reply_to_str, FND_API.G_MISS_CHAR, null, p_reply_to_str),
159: p_to_str,
160: decode(p_cc_str, FND_API.G_MISS_CHAR, null, p_cc_str),
161: decode(p_bcc_str, FND_API.G_MISS_CHAR, null, p_bcc_str),
162: p_sent_date,
163: decode(p_received_date, FND_API.G_MISS_DATE, null, p_received_date),
164: decode(p_subject, FND_API.G_MISS_CHAR, null, p_subject),
165: decode(p_agent_id, FND_API.G_MISS_NUM, null, p_agent_id),

Line 163: decode(p_received_date, FND_API.G_MISS_DATE, null, p_received_date),

159: p_to_str,
160: decode(p_cc_str, FND_API.G_MISS_CHAR, null, p_cc_str),
161: decode(p_bcc_str, FND_API.G_MISS_CHAR, null, p_bcc_str),
162: p_sent_date,
163: decode(p_received_date, FND_API.G_MISS_DATE, null, p_received_date),
164: decode(p_subject, FND_API.G_MISS_CHAR, null, p_subject),
165: decode(p_agent_id, FND_API.G_MISS_NUM, null, p_agent_id),
166: decode(p_group_id, FND_API.G_MISS_NUM, null, p_group_id),
167: decode(p_ih_media_item_id, FND_API.G_MISS_NUM, null, p_ih_media_item_id),

Line 164: decode(p_subject, FND_API.G_MISS_CHAR, null, p_subject),

160: decode(p_cc_str, FND_API.G_MISS_CHAR, null, p_cc_str),
161: decode(p_bcc_str, FND_API.G_MISS_CHAR, null, p_bcc_str),
162: p_sent_date,
163: decode(p_received_date, FND_API.G_MISS_DATE, null, p_received_date),
164: decode(p_subject, FND_API.G_MISS_CHAR, null, p_subject),
165: decode(p_agent_id, FND_API.G_MISS_NUM, null, p_agent_id),
166: decode(p_group_id, FND_API.G_MISS_NUM, null, p_group_id),
167: decode(p_ih_media_item_id, FND_API.G_MISS_NUM, null, p_ih_media_item_id),
168: decode(p_customer_id, FND_API.G_MISS_NUM, null, p_customer_id),

Line 165: decode(p_agent_id, FND_API.G_MISS_NUM, null, p_agent_id),

161: decode(p_bcc_str, FND_API.G_MISS_CHAR, null, p_bcc_str),
162: p_sent_date,
163: decode(p_received_date, FND_API.G_MISS_DATE, null, p_received_date),
164: decode(p_subject, FND_API.G_MISS_CHAR, null, p_subject),
165: decode(p_agent_id, FND_API.G_MISS_NUM, null, p_agent_id),
166: decode(p_group_id, FND_API.G_MISS_NUM, null, p_group_id),
167: decode(p_ih_media_item_id, FND_API.G_MISS_NUM, null, p_ih_media_item_id),
168: decode(p_customer_id, FND_API.G_MISS_NUM, null, p_customer_id),
169: p_message_size,

Line 166: decode(p_group_id, FND_API.G_MISS_NUM, null, p_group_id),

162: p_sent_date,
163: decode(p_received_date, FND_API.G_MISS_DATE, null, p_received_date),
164: decode(p_subject, FND_API.G_MISS_CHAR, null, p_subject),
165: decode(p_agent_id, FND_API.G_MISS_NUM, null, p_agent_id),
166: decode(p_group_id, FND_API.G_MISS_NUM, null, p_group_id),
167: decode(p_ih_media_item_id, FND_API.G_MISS_NUM, null, p_ih_media_item_id),
168: decode(p_customer_id, FND_API.G_MISS_NUM, null, p_customer_id),
169: p_message_size,
170: decode(p_contact_id, FND_API.G_MISS_NUM, null, p_contact_id),

Line 167: decode(p_ih_media_item_id, FND_API.G_MISS_NUM, null, p_ih_media_item_id),

163: decode(p_received_date, FND_API.G_MISS_DATE, null, p_received_date),
164: decode(p_subject, FND_API.G_MISS_CHAR, null, p_subject),
165: decode(p_agent_id, FND_API.G_MISS_NUM, null, p_agent_id),
166: decode(p_group_id, FND_API.G_MISS_NUM, null, p_group_id),
167: decode(p_ih_media_item_id, FND_API.G_MISS_NUM, null, p_ih_media_item_id),
168: decode(p_customer_id, FND_API.G_MISS_NUM, null, p_customer_id),
169: p_message_size,
170: decode(p_contact_id, FND_API.G_MISS_NUM, null, p_contact_id),
171: decode(p_relationship_id, FND_API.G_MISS_NUM, null, p_relationship_id),

Line 168: decode(p_customer_id, FND_API.G_MISS_NUM, null, p_customer_id),

164: decode(p_subject, FND_API.G_MISS_CHAR, null, p_subject),
165: decode(p_agent_id, FND_API.G_MISS_NUM, null, p_agent_id),
166: decode(p_group_id, FND_API.G_MISS_NUM, null, p_group_id),
167: decode(p_ih_media_item_id, FND_API.G_MISS_NUM, null, p_ih_media_item_id),
168: decode(p_customer_id, FND_API.G_MISS_NUM, null, p_customer_id),
169: p_message_size,
170: decode(p_contact_id, FND_API.G_MISS_NUM, null, p_contact_id),
171: decode(p_relationship_id, FND_API.G_MISS_NUM, null, p_relationship_id),
172: decode(p_top_intent, FND_API.G_MISS_CHAR, null, p_top_intent),

Line 170: decode(p_contact_id, FND_API.G_MISS_NUM, null, p_contact_id),

166: decode(p_group_id, FND_API.G_MISS_NUM, null, p_group_id),
167: decode(p_ih_media_item_id, FND_API.G_MISS_NUM, null, p_ih_media_item_id),
168: decode(p_customer_id, FND_API.G_MISS_NUM, null, p_customer_id),
169: p_message_size,
170: decode(p_contact_id, FND_API.G_MISS_NUM, null, p_contact_id),
171: decode(p_relationship_id, FND_API.G_MISS_NUM, null, p_relationship_id),
172: decode(p_top_intent, FND_API.G_MISS_CHAR, null, p_top_intent),
173: decode(p_message_text, FND_API.G_MISS_CHAR, null, p_message_text),
174: decode(p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),

Line 171: decode(p_relationship_id, FND_API.G_MISS_NUM, null, p_relationship_id),

167: decode(p_ih_media_item_id, FND_API.G_MISS_NUM, null, p_ih_media_item_id),
168: decode(p_customer_id, FND_API.G_MISS_NUM, null, p_customer_id),
169: p_message_size,
170: decode(p_contact_id, FND_API.G_MISS_NUM, null, p_contact_id),
171: decode(p_relationship_id, FND_API.G_MISS_NUM, null, p_relationship_id),
172: decode(p_top_intent, FND_API.G_MISS_CHAR, null, p_top_intent),
173: decode(p_message_text, FND_API.G_MISS_CHAR, null, p_message_text),
174: decode(p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
175: decode(p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),

Line 172: decode(p_top_intent, FND_API.G_MISS_CHAR, null, p_top_intent),

168: decode(p_customer_id, FND_API.G_MISS_NUM, null, p_customer_id),
169: p_message_size,
170: decode(p_contact_id, FND_API.G_MISS_NUM, null, p_contact_id),
171: decode(p_relationship_id, FND_API.G_MISS_NUM, null, p_relationship_id),
172: decode(p_top_intent, FND_API.G_MISS_CHAR, null, p_top_intent),
173: decode(p_message_text, FND_API.G_MISS_CHAR, null, p_message_text),
174: decode(p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
175: decode(p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
176: decode(p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),

Line 173: decode(p_message_text, FND_API.G_MISS_CHAR, null, p_message_text),

169: p_message_size,
170: decode(p_contact_id, FND_API.G_MISS_NUM, null, p_contact_id),
171: decode(p_relationship_id, FND_API.G_MISS_NUM, null, p_relationship_id),
172: decode(p_top_intent, FND_API.G_MISS_CHAR, null, p_top_intent),
173: decode(p_message_text, FND_API.G_MISS_CHAR, null, p_message_text),
174: decode(p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
175: decode(p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
176: decode(p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
177: decode(p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),

Line 174: decode(p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),

170: decode(p_contact_id, FND_API.G_MISS_NUM, null, p_contact_id),
171: decode(p_relationship_id, FND_API.G_MISS_NUM, null, p_relationship_id),
172: decode(p_top_intent, FND_API.G_MISS_CHAR, null, p_top_intent),
173: decode(p_message_text, FND_API.G_MISS_CHAR, null, p_message_text),
174: decode(p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
175: decode(p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
176: decode(p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
177: decode(p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
178: decode(p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),

Line 175: decode(p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),

171: decode(p_relationship_id, FND_API.G_MISS_NUM, null, p_relationship_id),
172: decode(p_top_intent, FND_API.G_MISS_CHAR, null, p_top_intent),
173: decode(p_message_text, FND_API.G_MISS_CHAR, null, p_message_text),
174: decode(p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
175: decode(p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
176: decode(p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
177: decode(p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
178: decode(p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
179: decode(p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),

Line 176: decode(p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),

172: decode(p_top_intent, FND_API.G_MISS_CHAR, null, p_top_intent),
173: decode(p_message_text, FND_API.G_MISS_CHAR, null, p_message_text),
174: decode(p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
175: decode(p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
176: decode(p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
177: decode(p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
178: decode(p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
179: decode(p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
180: decode(p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),

Line 177: decode(p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),

173: decode(p_message_text, FND_API.G_MISS_CHAR, null, p_message_text),
174: decode(p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
175: decode(p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
176: decode(p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
177: decode(p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
178: decode(p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
179: decode(p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
180: decode(p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
181: decode(p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),

Line 178: decode(p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),

174: decode(p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
175: decode(p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
176: decode(p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
177: decode(p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
178: decode(p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
179: decode(p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
180: decode(p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
181: decode(p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
182: decode(p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),

Line 179: decode(p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),

175: decode(p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
176: decode(p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
177: decode(p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
178: decode(p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
179: decode(p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
180: decode(p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
181: decode(p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
182: decode(p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
183: decode(p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),

Line 180: decode(p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),

176: decode(p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
177: decode(p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
178: decode(p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
179: decode(p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
180: decode(p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
181: decode(p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
182: decode(p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
183: decode(p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
184: decode(p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),

Line 181: decode(p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),

177: decode(p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
178: decode(p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
179: decode(p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
180: decode(p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
181: decode(p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
182: decode(p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
183: decode(p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
184: decode(p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
185: decode(p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),

Line 182: decode(p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),

178: decode(p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
179: decode(p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
180: decode(p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
181: decode(p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
182: decode(p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
183: decode(p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
184: decode(p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
185: decode(p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
186: decode(p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),

Line 183: decode(p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),

179: decode(p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
180: decode(p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
181: decode(p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
182: decode(p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
183: decode(p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
184: decode(p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
185: decode(p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
186: decode(p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
187: decode(p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),

Line 184: decode(p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),

180: decode(p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
181: decode(p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
182: decode(p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
183: decode(p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
184: decode(p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
185: decode(p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
186: decode(p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
187: decode(p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
188: decode(p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),

Line 185: decode(p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),

181: decode(p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
182: decode(p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
183: decode(p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
184: decode(p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
185: decode(p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
186: decode(p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
187: decode(p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
188: decode(p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
189: decode(G_created_updated_by,null,-1,G_created_updated_by),

Line 186: decode(p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),

182: decode(p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
183: decode(p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
184: decode(p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
185: decode(p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
186: decode(p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
187: decode(p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
188: decode(p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
189: decode(G_created_updated_by,null,-1,G_created_updated_by),
190: sysdate,

Line 187: decode(p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),

183: decode(p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
184: decode(p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
185: decode(p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
186: decode(p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
187: decode(p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
188: decode(p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
189: decode(G_created_updated_by,null,-1,G_created_updated_by),
190: sysdate,
191: decode(G_created_updated_by,null,-1,G_created_updated_by),

Line 188: decode(p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),

184: decode(p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
185: decode(p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
186: decode(p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
187: decode(p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
188: decode(p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
189: decode(G_created_updated_by,null,-1,G_created_updated_by),
190: sysdate,
191: decode(G_created_updated_by,null,-1,G_created_updated_by),
192: sysdate,

Line 200: IF FND_API.To_Boolean(p_commit) THEN

196:
197: x_message_id := l_seq_id;
198:
199: -- Standard Check Of p_commit.
200: IF FND_API.To_Boolean(p_commit) THEN
201: COMMIT WORK;
202: END IF;
203:
204:

Line 213: WHEN FND_API.G_EXC_ERROR THEN

209: );
210:
211: EXCEPTION
212:
213: WHEN FND_API.G_EXC_ERROR THEN
214: ROLLBACK TO create_arch_msgdtls_PVT;
215: x_return_status := FND_API.G_RET_STS_ERROR ;
216: FND_MSG_PUB.Count_And_Get
217:

Line 215: x_return_status := FND_API.G_RET_STS_ERROR ;

211: EXCEPTION
212:
213: WHEN FND_API.G_EXC_ERROR THEN
214: ROLLBACK TO create_arch_msgdtls_PVT;
215: x_return_status := FND_API.G_RET_STS_ERROR ;
216: FND_MSG_PUB.Count_And_Get
217:
218: ( p_count => x_msg_count,
219: p_data => x_msg_data

Line 222: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

218: ( p_count => x_msg_count,
219: p_data => x_msg_data
220: );
221:
222: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
223: ROLLBACK TO create_arch_msgdtls_PVT;
224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
225: FND_MSG_PUB.Count_And_Get
226: ( p_count => x_msg_count,

Line 224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

220: );
221:
222: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
223: ROLLBACK TO create_arch_msgdtls_PVT;
224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
225: FND_MSG_PUB.Count_And_Get
226: ( p_count => x_msg_count,
227: p_data => x_msg_data
228: );

Line 232: x_return_status := FND_API.G_RET_STS_ERROR;

228: );
229:
230: WHEN OTHERS THEN
231: ROLLBACK TO create_arch_msgdtls_PVT;
232: x_return_status := FND_API.G_RET_STS_ERROR;
233: IF FND_MSG_PUB.Check_Msg_Level
234: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
235: THEN
236: FND_MSG_PUB.Add_Exc_Msg