72: l_system_flag VARCHAR2(256);
73: l_x_mailer VARCHAR2(256);
74:
75: BEGIN
76: -- Standard Start of API savepoint
77: SAVEPOINT create_item_tag_PVT;
78:
79: -- Standard call to check for call compatibility.
80:
75: BEGIN
76: -- Standard Start of API savepoint
77: SAVEPOINT create_item_tag_PVT;
78:
79: -- Standard call to check for call compatibility.
80:
81: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
82: p_api_version_number,
83: l_api_name,
172: sysdate,
173: decode(G_LAST_UPDATE_LOGIN,null,-1,G_LAST_UPDATE_LOGIN)
174: );
175:
176: -- Standard Check Of p_commit.
177: IF FND_API.To_Boolean(p_commit) THEN
178: COMMIT WORK;
179: END IF;
180: x_ref_key := l_seq_id;
178: COMMIT WORK;
179: END IF;
180: x_ref_key := l_seq_id;
181:
182: -- Standard callto get message count and if count is 1, get message info.
183: FND_MSG_PUB.Count_And_Get
184: ( p_count => x_msg_count,
185: p_data => x_msg_data
186: );
253: --l_value VARCHAR2(256);
254: l_type VARCHAR2(100);
255:
256: BEGIN
257: -- Standard Start of API savepoint
258: SAVEPOINT create_sender_recipient_PVT;
259:
260: -- Standard call to check for call compatibility.
261:
256: BEGIN
257: -- Standard Start of API savepoint
258: SAVEPOINT create_sender_recipient_PVT;
259:
260: -- Standard call to check for call compatibility.
261:
262: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
263: p_api_version_number,
264: l_api_name,
313: decode(G_LAST_UPDATE_LOGIN,null,-1,G_LAST_UPDATE_LOGIN)
314: );
315: end loop;
316:
317: -- Standard Check Of p_commit.
318: IF FND_API.To_Boolean(p_commit) THEN
319: COMMIT WORK;
320: END IF;
321:
318: IF FND_API.To_Boolean(p_commit) THEN
319: COMMIT WORK;
320: END IF;
321:
322: -- Standard callto get message count and if count is 1, get message info.
323: FND_MSG_PUB.Count_And_Get
324: ( p_count => x_msg_count,
325: p_data => x_msg_data
326: );
389: l_type VARCHAR2(30);
390:
391: l_EMCMSG_PART_ID number;
392: BEGIN
393: -- Standard Start of API savepoint
394: SAVEPOINT create_sender_recipient_PVT;
395:
396: -- Standard call to check for call compatibility.
397:
392: BEGIN
393: -- Standard Start of API savepoint
394: SAVEPOINT create_sender_recipient_PVT;
395:
396: -- Standard call to check for call compatibility.
397:
398: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
399: p_api_version_number,
400: l_api_name,
445: decode(G_LAST_UPDATE_LOGIN,null,-1,G_LAST_UPDATE_LOGIN)
446: );
447: end loop;
448:
449: -- Standard Check Of p_commit.
450: IF FND_API.To_Boolean(p_commit) THEN
451: COMMIT WORK;
452: END IF;
453:
450: IF FND_API.To_Boolean(p_commit) THEN
451: COMMIT WORK;
452: END IF;
453:
454: -- Standard callto get message count and if count is 1, get message info.
455: FND_MSG_PUB.Count_And_Get
456: ( p_count => x_msg_count,
457: p_data => x_msg_data
458: );
517:
518: l_received_date DATE := sysdate;
519:
520: BEGIN
521: -- Standard Start of API savepoint
522: SAVEPOINT insert_preproc_wrapper_PVT;
523:
524: -- Standard call to check for call compatibility.
525:
520: BEGIN
521: -- Standard Start of API savepoint
522: SAVEPOINT insert_preproc_wrapper_PVT;
523:
524: -- Standard call to check for call compatibility.
525:
526: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
527: p_api_version_number,
528: l_api_name,
558: x_return_status => l_return_status,
559: x_msg_count => l_msg_count,
560: x_msg_data => l_msg_data);
561:
562: -- Standard Check Of p_commit.
563: IF FND_API.To_Boolean(p_commit) THEN
564: COMMIT WORK;
565: END IF;
566:
563: IF FND_API.To_Boolean(p_commit) THEN
564: COMMIT WORK;
565: END IF;
566:
567: -- Standard callto get message count and if count is 1, get message info.
568: FND_MSG_PUB.Count_And_Get
569: ( p_count => x_msg_count,
570: p_data => x_msg_data
571: );
634:
635: l_received_date DATE := sysdate;
636:
637: BEGIN
638: -- Standard Start of API savepoint
639: SAVEPOINT insert_preproc_wrapper_PVT;
640:
641: -- Standard call to check for call compatibility.
642:
637: BEGIN
638: -- Standard Start of API savepoint
639: SAVEPOINT insert_preproc_wrapper_PVT;
640:
641: -- Standard call to check for call compatibility.
642:
643: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
644: p_api_version_number,
645: l_api_name,
677: WHERE MESSAGE_ID=p_msg_id AND PART_ID=p_part_id AND PART_TYPE =p_part_type
678: AND PART_NAME = p_part_name;
679:
680:
681: -- Standard Check Of p_commit.
682: IF FND_API.To_Boolean(p_commit) THEN
683: COMMIT WORK;
684: END IF;
685:
682: IF FND_API.To_Boolean(p_commit) THEN
683: COMMIT WORK;
684: END IF;
685:
686: -- Standard callto get message count and if count is 1, get message info.
687: FND_MSG_PUB.Count_And_Get
688: ( p_count => x_msg_count,
689: p_data => x_msg_data
690: );