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 76: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

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

Line 81: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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.

Line 86: IF FND_API.to_Boolean( p_init_msg_list )

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:

Line 92: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

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

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

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

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,

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

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,

Line 161: decode(p_reply_to_str, FND_API.G_MISS_CHAR, null, p_reply_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,

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

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),

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

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),

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

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),

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

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),

Line 168: decode(p_agent_id, FND_API.G_MISS_NUM, null, p_agent_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,

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

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),

Line 170: decode(p_ih_media_item_id, FND_API.G_MISS_NUM, null, p_ih_media_item_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),

Line 171: decode(p_customer_id, FND_API.G_MISS_NUM, null, p_customer_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),

Line 173: decode(p_contact_id, FND_API.G_MISS_NUM, null, p_contact_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),
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),

Line 174: decode(p_relationship_id, FND_API.G_MISS_NUM, null, p_relationship_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),
178: decode(p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),

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

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),

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

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),

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

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),

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

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),

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

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),

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

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),

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

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),

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

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),

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

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),

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

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),

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

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),

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

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),

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

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),

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

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

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

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),

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

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,

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

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),

Line 204: IF FND_API.To_Boolean(p_commit) THEN

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:

Line 217: WHEN FND_API.G_EXC_ERROR THEN

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:

Line 219: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 226: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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,

Line 228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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: );

Line 236: x_return_status := FND_API.G_RET_STS_ERROR;

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