[Home] [Help]
74: AMV_I_CONTENT_TYPES_B_S.nextval, sysdate
75: from dual;
76: --
77: BEGIN
78: -- Standard call to check for call compatibility.
79: SAVEPOINT Add_ContentType_Pvt;
80: IF NOT FND_API.Compatible_API_Call (
81: l_api_version,
82: p_api_version,
168: X_LAST_UPDATE_DATE => l_current_date,
169: X_LAST_UPDATED_BY => l_current_user_id,
170: X_LAST_UPDATE_LOGIN => l_current_login_id
171: );
172: --Standard check of commit
173: IF FND_API.To_Boolean ( p_commit ) THEN
174: COMMIT WORK;
175: END IF;
176: --Standard call to get message count and if count=1, get the message
172: --Standard check of commit
173: IF FND_API.To_Boolean ( p_commit ) THEN
174: COMMIT WORK;
175: END IF;
176: --Standard call to get message count and if count=1, get the message
177: FND_MSG_PUB.Count_And_Get (
178: p_encoded => FND_API.G_FALSE,
179: p_count => x_msg_count,
180: p_data => x_msg_data
182: EXCEPTION
183: WHEN FND_API.G_EXC_ERROR THEN
184: ROLLBACK TO Add_ContentType_Pvt;
185: x_return_status := FND_API.G_RET_STS_ERROR;
186: -- Standard call to get message count and if count=1, get the message
187: FND_MSG_PUB.Count_And_Get (
188: p_encoded => FND_API.G_FALSE,
189: p_count => x_msg_count,
190: p_data => x_msg_data
191: );
192: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
193: ROLLBACK TO Add_ContentType_Pvt;
194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
195: -- Standard call to get message count and if count=1, get the message
196: FND_MSG_PUB.Count_And_Get (
197: p_encoded => FND_API.G_FALSE,
198: p_count => x_msg_count,
199: p_data => x_msg_data
203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
204: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
205: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
206: END IF;
207: -- Standard call to get message count and if count=1, get the message
208: FND_MSG_PUB.Count_And_Get (
209: p_encoded => FND_API.G_FALSE,
210: p_count => x_msg_count,
211: p_data => x_msg_data
243: From jtf_amv_items_b
244: Where content_type_id = p_ContentType_id;
245: --
246: BEGIN
247: -- Standard call to check for call compatibility.
248: SAVEPOINT Delete_ContentType_Pvt;
249: IF NOT FND_API.Compatible_API_Call (
250: l_api_version,
251: p_api_version,
357: AMV_I_CONTENT_TYPES_PKG.DELETE_ROW
358: (
359: X_CONTENT_TYPE_ID => l_content_type_id
360: );
361: --Standard check of commit
362: IF FND_API.To_Boolean ( p_commit ) THEN
363: COMMIT WORK;
364: END IF;
365: --Standard call to get message count and if count=1, get the message
361: --Standard check of commit
362: IF FND_API.To_Boolean ( p_commit ) THEN
363: COMMIT WORK;
364: END IF;
365: --Standard call to get message count and if count=1, get the message
366: FND_MSG_PUB.Count_And_Get (
367: p_encoded => FND_API.G_FALSE,
368: p_count => x_msg_count,
369: p_data => x_msg_data
371: EXCEPTION
372: WHEN FND_API.G_EXC_ERROR THEN
373: ROLLBACK TO Delete_ContentType_Pvt;
374: x_return_status := FND_API.G_RET_STS_ERROR;
375: -- Standard call to get message count and if count=1, get the message
376: FND_MSG_PUB.Count_And_Get (
377: p_encoded => FND_API.G_FALSE,
378: p_count => x_msg_count,
379: p_data => x_msg_data
380: );
381: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
382: ROLLBACK TO Delete_ContentType_Pvt;
383: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
384: -- Standard call to get message count and if count=1, get the message
385: FND_MSG_PUB.Count_And_Get (
386: p_encoded => FND_API.G_FALSE,
387: p_count => x_msg_count,
388: p_data => x_msg_data
392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
393: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
394: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
395: END IF;
396: -- Standard call to get message count and if count=1, get the message
397: FND_MSG_PUB.Count_And_Get (
398: p_encoded => FND_API.G_FALSE,
399: p_count => x_msg_count,
400: p_data => x_msg_data
435: where content_type_id = p_ctype_id;
436: --
437: --
438: BEGIN
439: -- Standard call to check for call compatibility.
440: SAVEPOINT Update_ContentType_Pvt;
441: IF NOT FND_API.Compatible_API_Call (
442: l_api_version,
443: p_api_version,
561: X_LAST_UPDATE_DATE => sysdate,
562: X_LAST_UPDATED_BY => l_current_user_id,
563: X_LAST_UPDATE_LOGIN => l_current_login_id
564: );
565: --Standard check of commit
566: IF FND_API.To_Boolean ( p_commit ) THEN
567: COMMIT WORK;
568: END IF;
569: --Standard call to get message count and if count=1, get the message
565: --Standard check of commit
566: IF FND_API.To_Boolean ( p_commit ) THEN
567: COMMIT WORK;
568: END IF;
569: --Standard call to get message count and if count=1, get the message
570: FND_MSG_PUB.Count_And_Get (
571: p_encoded => FND_API.G_FALSE,
572: p_count => x_msg_count,
573: p_data => x_msg_data
575: EXCEPTION
576: WHEN FND_API.G_EXC_ERROR THEN
577: ROLLBACK TO Update_ContentType_Pvt;
578: x_return_status := FND_API.G_RET_STS_ERROR;
579: -- Standard call to get message count and if count=1, get the message
580: FND_MSG_PUB.Count_And_Get (
581: p_encoded => FND_API.G_FALSE,
582: p_count => x_msg_count,
583: p_data => x_msg_data
584: );
585: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
586: ROLLBACK TO Update_ContentType_Pvt;
587: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
588: -- Standard call to get message count and if count=1, get the message
589: FND_MSG_PUB.Count_And_Get (
590: p_encoded => FND_API.G_FALSE,
591: p_count => x_msg_count,
592: p_data => x_msg_data
596: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
597: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
598: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
599: END IF;
600: -- Standard call to get message count and if count=1, get the message
601: FND_MSG_PUB.Count_And_Get (
602: p_encoded => FND_API.G_FALSE,
603: p_count => x_msg_count,
604: p_data => x_msg_data
648: --
649: l_content_type_rec Get_CntTypeRecord_csr%ROWTYPE;
650: --
651: BEGIN
652: -- Standard call to check for call compatibility.
653: IF NOT FND_API.Compatible_API_Call (
654: l_api_version,
655: p_api_version,
656: l_api_name,
761: );
762: */
763: END IF;
764: CLOSE Get_CntTypeRecord_csr;
765: --Standard call to get message count and if count=1, get the message
766: FND_MSG_PUB.Count_And_Get (
767: p_encoded => FND_API.G_FALSE,
768: p_count => x_msg_count,
769: p_data => x_msg_data
770: );
771: EXCEPTION
772: WHEN FND_API.G_EXC_ERROR THEN
773: x_return_status := FND_API.G_RET_STS_ERROR;
774: -- Standard call to get message count and if count=1, get the message
775: FND_MSG_PUB.Count_And_Get (
776: p_encoded => FND_API.G_FALSE,
777: p_count => x_msg_count,
778: p_data => x_msg_data
778: p_data => x_msg_data
779: );
780: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
781: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
782: -- Standard call to get message count and if count=1, get the message
783: FND_MSG_PUB.Count_And_Get (
784: p_encoded => FND_API.G_FALSE,
785: p_count => x_msg_count,
786: p_data => x_msg_data
789: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
790: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
791: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
792: END IF;
793: -- Standard call to get message count and if count=1, get the message
794: FND_MSG_PUB.Count_And_Get (
795: p_encoded => FND_API.G_FALSE,
796: p_count => x_msg_count,
797: p_data => x_msg_data
843: l_last_updated_by NUMBER;
844: l_last_update_login NUMBER;
845: --
846: BEGIN
847: -- Standard call to check for call compatibility.
848: IF NOT FND_API.Compatible_API_Call (
849: l_api_version,
850: p_api_version,
851: l_api_name,
1002: l_total_record_count
1003: );
1004: */
1005:
1006: --Standard call to get message count and if count=1, get the message
1007: FND_MSG_PUB.Count_And_Get (
1008: p_encoded => FND_API.G_FALSE,
1009: p_count => x_msg_count,
1010: p_data => x_msg_data
1011: );
1012: EXCEPTION
1013: WHEN FND_API.G_EXC_ERROR THEN
1014: x_return_status := FND_API.G_RET_STS_ERROR;
1015: -- Standard call to get message count and if count=1, get the message
1016: FND_MSG_PUB.Count_And_Get (
1017: p_encoded => FND_API.G_FALSE,
1018: p_count => x_msg_count,
1019: p_data => x_msg_data
1019: p_data => x_msg_data
1020: );
1021: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1022: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1023: -- Standard call to get message count and if count=1, get the message
1024: FND_MSG_PUB.Count_And_Get (
1025: p_encoded => FND_API.G_FALSE,
1026: p_count => x_msg_count,
1027: p_data => x_msg_data
1030: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1031: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1032: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1033: END IF;
1034: -- Standard call to get message count and if count=1, get the message
1035: FND_MSG_PUB.Count_And_Get (
1036: p_encoded => FND_API.G_FALSE,
1037: p_count => x_msg_count,
1038: p_data => x_msg_data