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.CCT_SERVERDATAINPUT_PUB dependencies on FND_API

Line 17: Default = FND_API.G_FALSE

13: calls to its current version number, returns an unexpected error
14: if they are incompatible.
15:
16: :p_init_msg_list IN VARCHAR2 Optional
17: Default = FND_API.G_FALSE
18: The API message list must be initialized every time a program
19: calls an API.
20:
21: :p_commit IN VARCHAR2 Optional

Line 22: Default = FND_API.G_FALSE

18: The API message list must be initialized every time a program
19: calls an API.
20:
21: :p_commit IN VARCHAR2 Optional
22: Default = FND_API.G_FALSE
23: Before returning to its caller, an API should check the value
24: of p_commit. If it is set to TRUE it should commit its work.
25:
26: :p_validation_level IN NUMBER Optional

Line 27: Default = FND_API.G_VALID_LEVEL_FULL

23: Before returning to its caller, an API should check the value
24: of p_commit. If it is set to TRUE it should commit its work.
25:
26: :p_validation_level IN NUMBER Optional
27: Default = FND_API.G_VALID_LEVEL_FULL
28: Determins which validation steps should be executed and which
29: should be skipped. Public APIs by definition have to perform FULL
30: validation on all the data passed to them
31:

Line 227: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

223: end of comments */
224:
225: PROCEDURE Advanced_Outbound_Input
226: ( p_api_version IN NUMBER,
227: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
228: p_commit IN VARCHAR2 := FND_API.G_FALSE,
229: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
230: x_return_status OUT nocopy VARCHAR2,
231: x_msg_count OUT nocopy NUMBER,

Line 228: p_commit IN VARCHAR2 := FND_API.G_FALSE,

224:
225: PROCEDURE Advanced_Outbound_Input
226: ( p_api_version IN NUMBER,
227: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
228: p_commit IN VARCHAR2 := FND_API.G_FALSE,
229: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
230: x_return_status OUT nocopy VARCHAR2,
231: x_msg_count OUT nocopy NUMBER,
232: x_msg_data OUT nocopy VARCHAR2,

Line 229: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

225: PROCEDURE Advanced_Outbound_Input
226: ( p_api_version IN NUMBER,
227: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
228: p_commit IN VARCHAR2 := FND_API.G_FALSE,
229: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
230: x_return_status OUT nocopy VARCHAR2,
231: x_msg_count OUT nocopy NUMBER,
232: x_msg_data OUT nocopy VARCHAR2,
233:

Line 288: l_encoded VARCHAR2(1) := FND_API.G_FALSE;

284: ) IS
285:
286: l_api_name CONSTANT VARCHAR2(30) := 'Advanced_Outbound_Input';
287: l_api_version CONSTANT NUMBER := 1.0;
288: l_encoded VARCHAR2(1) := FND_API.G_FALSE;
289:
290: l_site_id NUMBER := -1;
291: l_campaign_id NUMBER := -1;
292: l_list_id NUMBER := -1;

Line 299: IF NOT FND_API.Compatible_API_Call ( l_api_version,

295: -- Standard Start of API savepoint
296: SAVEPOINT Advanced_Outbound_Input_PUB;
297:
298: -- Standard call to check for call compatibility
299: IF NOT FND_API.Compatible_API_Call ( l_api_version,
300: p_api_version,
301: l_api_name,
302: G_PKG_NAME)
303: THEN

Line 304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

300: p_api_version,
301: l_api_name,
302: G_PKG_NAME)
303: THEN
304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
305: END IF;
306:
307: -- initialize message list if p_init_msg_list is set to TRUE
308: IF FND_API.To_Boolean( p_init_msg_list ) THEN

Line 308: IF FND_API.To_Boolean( p_init_msg_list ) THEN

304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
305: END IF;
306:
307: -- initialize message list if p_init_msg_list is set to TRUE
308: IF FND_API.To_Boolean( p_init_msg_list ) THEN
309: FND_MSG_PUB.initialize;
310: END IF;
311:
312: -- Initialize the API return status to success

Line 313: x_return_status := FND_API.G_RET_STS_SUCCESS;

309: FND_MSG_PUB.initialize;
310: END IF;
311:
312: -- Initialize the API return status to success
313: x_return_status := FND_API.G_RET_STS_SUCCESS;
314:
315: -- API body
316:
317: -- Insert record if p_time is given

Line 429: RAISE FND_API.G_EXC_ERROR;

425: FND_MESSAGE.SET_NAME('CCT', 'CCT_SDI_AO_IN_INSERT_ERROR');
426: FND_MSG_PUB.Add;
427: END IF;
428:
429: RAISE FND_API.G_EXC_ERROR;
430: END;
431:
432: -- Signify Success
433: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 442: IF FND_API.To_Boolean( p_commit ) THEN

438:
439: -- End of API body
440:
441: -- Standard check of p_commit
442: IF FND_API.To_Boolean( p_commit ) THEN
443: COMMIT WORK;
444: END IF;
445:
446: -- Standard call to get message count and if count is 1, get message info

Line 454: WHEN FND_API.G_EXC_ERROR THEN

450: p_data => x_msg_data
451: );
452:
453: EXCEPTION
454: WHEN FND_API.G_EXC_ERROR THEN
455: ROLLBACK TO Advanced_Outbound_Input_PUB;
456: x_return_status := FND_API.G_RET_STS_ERROR;
457:
458: FND_MSG_PUB.Count_And_Get

Line 456: x_return_status := FND_API.G_RET_STS_ERROR;

452:
453: EXCEPTION
454: WHEN FND_API.G_EXC_ERROR THEN
455: ROLLBACK TO Advanced_Outbound_Input_PUB;
456: x_return_status := FND_API.G_RET_STS_ERROR;
457:
458: FND_MSG_PUB.Count_And_Get
459: ( p_encoded => l_encoded,
460: p_count => x_msg_count,

Line 464: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

460: p_count => x_msg_count,
461: p_data => x_msg_data
462: );
463:
464: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
465: ROLLBACK TO Advanced_Outbound_Input_PUB;
466: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
467:
468: FND_MSG_PUB.Count_And_Get

Line 466: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

462: );
463:
464: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
465: ROLLBACK TO Advanced_Outbound_Input_PUB;
466: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
467:
468: FND_MSG_PUB.Count_And_Get
469: ( p_encoded => l_encoded,
470: p_count => x_msg_count,

Line 476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

472: );
473:
474: WHEN OTHERS THEN
475: ROLLBACK TO Advanced_Outbound_Input_PUB;
476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
477:
478: IF FND_MSG_PUB.Check_Msg_Level
479: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
480:

Line 513: Default = FND_API.G_FALSE

509: calls to its current version number, returns an unexpected error
510: if they are incompatible.
511:
512: :p_init_msg_list IN VARCHAR2 Optional
513: Default = FND_API.G_FALSE
514: The API message list must be initialized every time a program
515: calls an API.
516:
517: :p_commit IN VARCHAR2 Optional

Line 518: Default = FND_API.G_FALSE

514: The API message list must be initialized every time a program
515: calls an API.
516:
517: :p_commit IN VARCHAR2 Optional
518: Default = FND_API.G_FALSE
519: Before returning to its caller, an API should check the value
520: of p_commit. If it is set to TRUE it should commit its work.
521:
522: :p_validation_level IN NUMBER Optional

Line 523: Default = FND_API.G_VALID_LEVEL_FULL

519: Before returning to its caller, an API should check the value
520: of p_commit. If it is set to TRUE it should commit its work.
521:
522: :p_validation_level IN NUMBER Optional
523: Default = FND_API.G_VALID_LEVEL_FULL
524: Determins which validation steps should be executed and which
525: should be skipped. Public APIs by definition have to perform FULL
526: validation on all the data passed to them
527:

Line 617: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

613: end of comments */
614:
615: PROCEDURE Interaction_Blending_Input
616: ( p_api_version IN NUMBER,
617: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
618: p_commit IN VARCHAR2 := FND_API.G_FALSE,
619: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
620: x_return_status OUT nocopy VARCHAR2,
621: x_msg_count OUT nocopy NUMBER,

Line 618: p_commit IN VARCHAR2 := FND_API.G_FALSE,

614:
615: PROCEDURE Interaction_Blending_Input
616: ( p_api_version IN NUMBER,
617: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
618: p_commit IN VARCHAR2 := FND_API.G_FALSE,
619: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
620: x_return_status OUT nocopy VARCHAR2,
621: x_msg_count OUT nocopy NUMBER,
622: x_msg_data OUT nocopy VARCHAR2,

Line 619: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

615: PROCEDURE Interaction_Blending_Input
616: ( p_api_version IN NUMBER,
617: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
618: p_commit IN VARCHAR2 := FND_API.G_FALSE,
619: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
620: x_return_status OUT nocopy VARCHAR2,
621: x_msg_count OUT nocopy NUMBER,
622: x_msg_data OUT nocopy VARCHAR2,
623:

Line 648: l_encoded VARCHAR2(1) := FND_API.G_FALSE;

644: ) IS
645:
646: l_api_name CONSTANT VARCHAR2(30) := 'Interaction_Blending_Input';
647: l_api_version CONSTANT NUMBER := 1.0;
648: l_encoded VARCHAR2(1) := FND_API.G_FALSE;
649:
650: l_site_id NUMBER := -1;
651: l_media_type VARCHAR2(240) := '';
652: l_los_id NUMBER := -1;

Line 663: IF NOT FND_API.Compatible_API_Call ( l_api_version,

659: -- Standard Start of API savepoint
660: SAVEPOINT Interaction_Blending_Input_PUB;
661:
662: -- Standard call to check for call compatibility
663: IF NOT FND_API.Compatible_API_Call ( l_api_version,
664: p_api_version,
665: l_api_name,
666: G_PKG_NAME)
667: THEN

Line 668: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

664: p_api_version,
665: l_api_name,
666: G_PKG_NAME)
667: THEN
668: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
669: END IF;
670:
671: -- initialize message list if p_init_msg_list is set to TRUE
672: IF FND_API.To_Boolean( p_init_msg_list ) THEN

Line 672: IF FND_API.To_Boolean( p_init_msg_list ) THEN

668: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
669: END IF;
670:
671: -- initialize message list if p_init_msg_list is set to TRUE
672: IF FND_API.To_Boolean( p_init_msg_list ) THEN
673: FND_MSG_PUB.initialize;
674: END IF;
675:
676: -- Initialize the API return status to success

Line 677: x_return_status := FND_API.G_RET_STS_SUCCESS;

673: FND_MSG_PUB.initialize;
674: END IF;
675:
676: -- Initialize the API return status to success
677: x_return_status := FND_API.G_RET_STS_SUCCESS;
678:
679: -- API body
680:
681: -- Insert record if p_time is given

Line 803: RAISE FND_API.G_EXC_ERROR;

799: FND_MESSAGE.SET_NAME('CCT', 'CCT_SDI_IB_IN_INSERT_ERROR');
800: FND_MSG_PUB.Add;
801: END IF;
802:
803: RAISE FND_API.G_EXC_ERROR;
804: END;
805:
806: -- Signify Success
807: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 816: IF FND_API.To_Boolean( p_commit ) THEN

812:
813: -- End of API body
814:
815: -- Standard check of p_commit
816: IF FND_API.To_Boolean( p_commit ) THEN
817: COMMIT WORK;
818: END IF;
819:
820: -- Standard call to get message count and if count is 1, get message info

Line 828: WHEN FND_API.G_EXC_ERROR THEN

824: p_data => x_msg_data
825: );
826:
827: EXCEPTION
828: WHEN FND_API.G_EXC_ERROR THEN
829: ROLLBACK TO Interaction_Blending_Input_PUB;
830: x_return_status := FND_API.G_RET_STS_ERROR;
831:
832: FND_MSG_PUB.Count_And_Get

Line 830: x_return_status := FND_API.G_RET_STS_ERROR;

826:
827: EXCEPTION
828: WHEN FND_API.G_EXC_ERROR THEN
829: ROLLBACK TO Interaction_Blending_Input_PUB;
830: x_return_status := FND_API.G_RET_STS_ERROR;
831:
832: FND_MSG_PUB.Count_And_Get
833: ( p_encoded => l_encoded,
834: p_count => x_msg_count,

Line 838: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

834: p_count => x_msg_count,
835: p_data => x_msg_data
836: );
837:
838: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
839: ROLLBACK TO Interaction_Blending_Input_PUB;
840: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
841:
842: FND_MSG_PUB.Count_And_Get

Line 840: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

836: );
837:
838: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
839: ROLLBACK TO Interaction_Blending_Input_PUB;
840: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
841:
842: FND_MSG_PUB.Count_And_Get
843: ( p_encoded => l_encoded,
844: p_count => x_msg_count,

Line 850: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

846: );
847:
848: WHEN OTHERS THEN
849: ROLLBACK TO Interaction_Blending_Input_PUB;
850: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
851:
852: IF FND_MSG_PUB.Check_Msg_Level
853: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
854:

Line 887: Default = FND_API.G_FALSE

883: calls to its current version number, returns an unexpected error
884: if they are incompatible.
885:
886: :p_init_msg_list IN VARCHAR2 Optional
887: Default = FND_API.G_FALSE
888: The API message list must be initialized every time a program
889: calls an API.
890:
891: :p_commit IN VARCHAR2 Optional

Line 892: Default = FND_API.G_FALSE

888: The API message list must be initialized every time a program
889: calls an API.
890:
891: :p_commit IN VARCHAR2 Optional
892: Default = FND_API.G_FALSE
893: Before returning to its caller, an API should check the value
894: of p_commit. If it is set to TRUE it should commit its work.
895:
896: :p_validation_level IN NUMBER Optional

Line 897: Default = FND_API.G_VALID_LEVEL_FULL

893: Before returning to its caller, an API should check the value
894: of p_commit. If it is set to TRUE it should commit its work.
895:
896: :p_validation_level IN NUMBER Optional
897: Default = FND_API.G_VALID_LEVEL_FULL
898: Determins which validation steps should be executed and which
899: should be skipped. Public APIs by definition have to perform FULL
900: validation on all the data passed to them
901:

Line 1030: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1026: end of comments */
1027:
1028: PROCEDURE Multi_Channel_Manager_Input
1029: ( p_api_version IN NUMBER,
1030: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1031: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1032: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1033: x_return_status OUT nocopy VARCHAR2,
1034: x_msg_count OUT nocopy NUMBER,

Line 1031: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1027:
1028: PROCEDURE Multi_Channel_Manager_Input
1029: ( p_api_version IN NUMBER,
1030: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1031: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1032: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1033: x_return_status OUT nocopy VARCHAR2,
1034: x_msg_count OUT nocopy NUMBER,
1035: x_msg_data OUT nocopy VARCHAR2,

Line 1032: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1028: PROCEDURE Multi_Channel_Manager_Input
1029: ( p_api_version IN NUMBER,
1030: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1031: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1032: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1033: x_return_status OUT nocopy VARCHAR2,
1034: x_msg_count OUT nocopy NUMBER,
1035: x_msg_data OUT nocopy VARCHAR2,
1036:

Line 1072: l_encoded VARCHAR2(1) := FND_API.G_FALSE;

1068: ) IS
1069:
1070: l_api_name CONSTANT VARCHAR2(30) := 'Multi_Channel_Manager_Input';
1071: l_api_version CONSTANT NUMBER := 1.0;
1072: l_encoded VARCHAR2(1) := FND_API.G_FALSE;
1073:
1074: l_interaction_center_id NUMBER := -1;
1075: l_interaction_class_name VARCHAR2(240) := '';
1076:

Line 1082: IF NOT FND_API.Compatible_API_Call ( l_api_version,

1078: -- Standard Start of API savepoint
1079: SAVEPOINT MCM_Input_PUB;
1080:
1081: -- Standard call to check for call compatibility
1082: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1083: p_api_version,
1084: l_api_name,
1085: G_PKG_NAME)
1086: THEN

Line 1087: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1083: p_api_version,
1084: l_api_name,
1085: G_PKG_NAME)
1086: THEN
1087: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1088: END IF;
1089:
1090: -- initialize message list if p_init_msg_list is set to TRUE
1091: IF FND_API.To_Boolean( p_init_msg_list ) THEN

Line 1091: IF FND_API.To_Boolean( p_init_msg_list ) THEN

1087: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1088: END IF;
1089:
1090: -- initialize message list if p_init_msg_list is set to TRUE
1091: IF FND_API.To_Boolean( p_init_msg_list ) THEN
1092: FND_MSG_PUB.initialize;
1093: END IF;
1094:
1095: -- Initialize the API return status to success

Line 1096: x_return_status := FND_API.G_RET_STS_SUCCESS;

1092: FND_MSG_PUB.initialize;
1093: END IF;
1094:
1095: -- Initialize the API return status to success
1096: x_return_status := FND_API.G_RET_STS_SUCCESS;
1097:
1098: -- API body
1099:
1100: -- Insert record if p_time is given

Line 1179: RAISE FND_API.G_EXC_ERROR;

1175: FND_MESSAGE.SET_NAME('CCT', 'CCT_SDI_MCM_IN_INSERT_ERROR');
1176: FND_MSG_PUB.Add;
1177: END IF;
1178:
1179: RAISE FND_API.G_EXC_ERROR;
1180: END;
1181:
1182: -- Signify Success
1183: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 1192: IF FND_API.To_Boolean( p_commit ) THEN

1188:
1189: -- End of API body
1190:
1191: -- Standard check of p_commit
1192: IF FND_API.To_Boolean( p_commit ) THEN
1193: COMMIT WORK;
1194: END IF;
1195:
1196: -- Standard call to get message count and if count is 1, get message info

Line 1204: WHEN FND_API.G_EXC_ERROR THEN

1200: p_data => x_msg_data
1201: );
1202:
1203: EXCEPTION
1204: WHEN FND_API.G_EXC_ERROR THEN
1205: ROLLBACK TO MCM_Input_PUB;
1206: x_return_status := FND_API.G_RET_STS_ERROR;
1207:
1208: FND_MSG_PUB.Count_And_Get

Line 1206: x_return_status := FND_API.G_RET_STS_ERROR;

1202:
1203: EXCEPTION
1204: WHEN FND_API.G_EXC_ERROR THEN
1205: ROLLBACK TO MCM_Input_PUB;
1206: x_return_status := FND_API.G_RET_STS_ERROR;
1207:
1208: FND_MSG_PUB.Count_And_Get
1209: ( p_encoded => l_encoded,
1210: p_count => x_msg_count,

Line 1214: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1210: p_count => x_msg_count,
1211: p_data => x_msg_data
1212: );
1213:
1214: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1215: ROLLBACK TO MCM_Input_PUB;
1216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1217:
1218: FND_MSG_PUB.Count_And_Get

Line 1216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1212: );
1213:
1214: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1215: ROLLBACK TO MCM_Input_PUB;
1216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1217:
1218: FND_MSG_PUB.Count_And_Get
1219: ( p_encoded => l_encoded,
1220: p_count => x_msg_count,

Line 1226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1222: );
1223:
1224: WHEN OTHERS THEN
1225: ROLLBACK TO MCM_Input_PUB;
1226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1227:
1228: IF FND_MSG_PUB.Check_Msg_Level
1229: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1230: