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 427: RAISE FND_API.G_EXC_ERROR;

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

Line 440: IF FND_API.To_Boolean( p_commit ) THEN

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

Line 452: WHEN FND_API.G_EXC_ERROR THEN

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

Line 454: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 462: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 464: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 474: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 511: Default = FND_API.G_FALSE

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

Line 516: Default = FND_API.G_FALSE

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

Line 521: Default = FND_API.G_VALID_LEVEL_FULL

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

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

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

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

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

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

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

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

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

Line 661: IF NOT FND_API.Compatible_API_Call ( l_api_version,

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

Line 666: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 670: IF FND_API.To_Boolean( p_init_msg_list ) THEN

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

Line 675: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 801: RAISE FND_API.G_EXC_ERROR;

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

Line 814: IF FND_API.To_Boolean( p_commit ) THEN

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

Line 826: WHEN FND_API.G_EXC_ERROR THEN

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

Line 828: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 836: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 838: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 848: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 885: Default = FND_API.G_FALSE

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

Line 890: Default = FND_API.G_FALSE

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

Line 895: Default = FND_API.G_VALID_LEVEL_FULL

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

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

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

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

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

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

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

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

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

Line 1080: IF NOT FND_API.Compatible_API_Call ( l_api_version,

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

Line 1085: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1089: IF FND_API.To_Boolean( p_init_msg_list ) THEN

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

Line 1094: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 1178: RAISE FND_API.G_EXC_ERROR;

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

Line 1191: IF FND_API.To_Boolean( p_commit ) THEN

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

Line 1203: WHEN FND_API.G_EXC_ERROR THEN

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

Line 1205: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1213: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1215: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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