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_ICJUMPSTART_PUB dependencies on FND_API

Line 18: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

14: ,p_ACD_AGENT_PASSWORD IN VARCHAR2 Default Null
15: ,p_acd_queue IN VARCHAR2 Default NULL
16: ,p_Resource_ID OUT nocopy NUMBER
17: ,x_Return_Status OUT nocopy VARCHAR2
18: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
19: ,p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
20: ,x_msg_count OUT nocopy NUMBER
21: ,x_message_data OUT nocopy VARCHAR2
22: ,x_user_password OUT nocopy VARCHAR2

Line 19: ,p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

15: ,p_acd_queue IN VARCHAR2 Default NULL
16: ,p_Resource_ID OUT nocopy NUMBER
17: ,x_Return_Status OUT nocopy VARCHAR2
18: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
19: ,p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
20: ,x_msg_count OUT nocopy NUMBER
21: ,x_message_data OUT nocopy VARCHAR2
22: ,x_user_password OUT nocopy VARCHAR2
23: ) IS

Line 44: IF FND_API.to_Boolean(p_init_msg_list) THEN

40: l_chgpwd_status Boolean;
41: Begin
42:
43: -- Init message list
44: IF FND_API.to_Boolean(p_init_msg_list) THEN
45: FND_MSG_PUB.initialize;
46: END IF;
47:
48: -- Init Return status

Line 49: x_Return_Status:=FND_API.G_RET_STS_SUCCESS;

45: FND_MSG_PUB.initialize;
46: END IF;
47:
48: -- Init Return status
49: x_Return_Status:=FND_API.G_RET_STS_SUCCESS;
50:
51:
52: -- Check if all the required parameters are not null
53: If (p_last_name is null) then

Line 54: x_Return_Status:=FND_API.G_RET_STS_ERROR;

50:
51:
52: -- Check if all the required parameters are not null
53: If (p_last_name is null) then
54: x_Return_Status:=FND_API.G_RET_STS_ERROR;
55: FND_MESSAGE.SET_NAME('CCT','CCT_JUMPSTART_NO_LAST_NAME');
56: FND_MSG_PUB.ADD;
57: FND_MSG_PUB.Count_AND_GET(
58: p_count => x_msg_count,

Line 60: p_encoded => FND_API.G_FALSE);

56: FND_MSG_PUB.ADD;
57: FND_MSG_PUB.Count_AND_GET(
58: p_count => x_msg_count,
59: p_data => x_message_data,
60: p_encoded => FND_API.G_FALSE);
61: raise FND_API.G_EXC_UNEXPECTED_ERROR;
62: End IF;
63:
64: -- Check if the Agent Sex is valid

Line 61: raise FND_API.G_EXC_UNEXPECTED_ERROR;

57: FND_MSG_PUB.Count_AND_GET(
58: p_count => x_msg_count,
59: p_data => x_message_data,
60: p_encoded => FND_API.G_FALSE);
61: raise FND_API.G_EXC_UNEXPECTED_ERROR;
62: End IF;
63:
64: -- Check if the Agent Sex is valid
65: If ((p_Agent_Sex<>'M') AND (p_Agent_Sex <>'F')) Then

Line 66: x_Return_Status:=FND_API.G_RET_STS_ERROR;

62: End IF;
63:
64: -- Check if the Agent Sex is valid
65: If ((p_Agent_Sex<>'M') AND (p_Agent_Sex <>'F')) Then
66: x_Return_Status:=FND_API.G_RET_STS_ERROR;
67: FND_MESSAGE.SET_NAME('CCT','CCT_JUMPSTART_INVALID_AGENT_SEX');
68: FND_MSG_PUB.ADD;
69: FND_MSG_PUB.Count_AND_GET(
70: p_count=>x_msg_count,

Line 72: p_encoded =>FND_API.G_FALSE);

68: FND_MSG_PUB.ADD;
69: FND_MSG_PUB.Count_AND_GET(
70: p_count=>x_msg_count,
71: p_data =>x_message_data,
72: p_encoded =>FND_API.G_FALSE);
73: raise FND_API.G_EXC_UNEXPECTED_ERROR;
74: ELSE
75: if (p_agent_Sex='M') then
76: l_agent_title:='MR.';

Line 73: raise FND_API.G_EXC_UNEXPECTED_ERROR;

69: FND_MSG_PUB.Count_AND_GET(
70: p_count=>x_msg_count,
71: p_data =>x_message_data,
72: p_encoded =>FND_API.G_FALSE);
73: raise FND_API.G_EXC_UNEXPECTED_ERROR;
74: ELSE
75: if (p_agent_Sex='M') then
76: l_agent_title:='MR.';
77: else

Line 91: x_Return_Status:=FND_API.G_RET_STS_ERROR;

87: into p_sql_Result
88: from fnd_user
89: where user_name=p_app_username;
90: If (p_sql_result=1) then
91: x_Return_Status:=FND_API.G_RET_STS_ERROR;
92: FND_MESSAGE.SET_NAME('CCT','CCT_JUMPSTART_USERNAME_ALREADY_EXISTS');
93: FND_MSG_PUB.ADD;
94: FND_MSG_PUB.Count_AND_GET(
95: p_count=>x_msg_count,

Line 97: p_encoded =>FND_API.G_FALSE);

93: FND_MSG_PUB.ADD;
94: FND_MSG_PUB.Count_AND_GET(
95: p_count=>x_msg_count,
96: p_data =>x_message_data,
97: p_encoded =>FND_API.G_FALSE);
98: raise FND_API.G_EXC_UNEXPECTED_ERROR;
99: End IF;
100: Exception
101: When no_data_found then

Line 98: raise FND_API.G_EXC_UNEXPECTED_ERROR;

94: FND_MSG_PUB.Count_AND_GET(
95: p_count=>x_msg_count,
96: p_data =>x_message_data,
97: p_encoded =>FND_API.G_FALSE);
98: raise FND_API.G_EXC_UNEXPECTED_ERROR;
99: End IF;
100: Exception
101: When no_data_found then
102: null;

Line 104: x_Return_Status:=FND_API.G_RET_STS_ERROR;

100: Exception
101: When no_data_found then
102: null;
103: When others then
104: x_Return_Status:=FND_API.G_RET_STS_ERROR;
105: FND_MESSAGE.SET_NAME('CCT','CCT_JUMPSTART_INVALID_USERNAME');
106: FND_MSG_PUB.ADD;
107: FND_MSG_PUB.Count_AND_GET(
108: p_count=>x_msg_count,

Line 110: p_encoded =>FND_API.G_FALSE);

106: FND_MSG_PUB.ADD;
107: FND_MSG_PUB.Count_AND_GET(
108: p_count=>x_msg_count,
109: p_data =>x_message_data,
110: p_encoded =>FND_API.G_FALSE);
111: raise FND_API.G_EXC_UNEXPECTED_ERROR;
112: End;
113: Else
114: x_Return_Status:=FND_API.G_RET_STS_ERROR;

Line 111: raise FND_API.G_EXC_UNEXPECTED_ERROR;

107: FND_MSG_PUB.Count_AND_GET(
108: p_count=>x_msg_count,
109: p_data =>x_message_data,
110: p_encoded =>FND_API.G_FALSE);
111: raise FND_API.G_EXC_UNEXPECTED_ERROR;
112: End;
113: Else
114: x_Return_Status:=FND_API.G_RET_STS_ERROR;
115: FND_MESSAGE.SET_NAME('CCT','CCT_JUMPSTART_INVALID_USERNAME');

Line 114: x_Return_Status:=FND_API.G_RET_STS_ERROR;

110: p_encoded =>FND_API.G_FALSE);
111: raise FND_API.G_EXC_UNEXPECTED_ERROR;
112: End;
113: Else
114: x_Return_Status:=FND_API.G_RET_STS_ERROR;
115: FND_MESSAGE.SET_NAME('CCT','CCT_JUMPSTART_INVALID_USERNAME');
116: FND_MSG_PUB.ADD;
117: FND_MSG_PUB.Count_AND_GET(
118: p_count=>x_msg_count,

Line 120: p_encoded =>FND_API.G_FALSE);

116: FND_MSG_PUB.ADD;
117: FND_MSG_PUB.Count_AND_GET(
118: p_count=>x_msg_count,
119: p_data =>x_message_data,
120: p_encoded =>FND_API.G_FALSE);
121: raise FND_API.G_EXC_UNEXPECTED_ERROR;
122: End IF;
123:
124:

Line 121: raise FND_API.G_EXC_UNEXPECTED_ERROR;

117: FND_MSG_PUB.Count_AND_GET(
118: p_count=>x_msg_count,
119: p_data =>x_message_data,
120: p_encoded =>FND_API.G_FALSE);
121: raise FND_API.G_EXC_UNEXPECTED_ERROR;
122: End IF;
123:
124:
125: -- Check if the Agent Role is valid

Line 127: x_Return_Status:=FND_API.G_RET_STS_ERROR;

123:
124:
125: -- Check if the Agent Role is valid
126: If ((p_ic_role<>'CALL_CENTER_AGENT') AND (p_ic_role<>'CALL_CENTER_MANAGER') AND (p_ic_Role <>'CALL_CENTER_SUPERVISOR')) Then
127: x_Return_Status:=FND_API.G_RET_STS_ERROR;
128: FND_MESSAGE.SET_NAME('CCT','CCT_JUMPSTART_INVALID_AGENT_ROLE');
129: FND_MSG_PUB.ADD;
130: FND_MSG_PUB.Count_AND_GET(
131: p_count=>x_msg_count,

Line 133: p_encoded =>FND_API.G_FALSE);

129: FND_MSG_PUB.ADD;
130: FND_MSG_PUB.Count_AND_GET(
131: p_count=>x_msg_count,
132: p_data =>x_message_data,
133: p_encoded =>FND_API.G_FALSE);
134: raise FND_API.G_EXC_UNEXPECTED_ERROR;
135: End IF;
136:
137: -- Check if the IC Server Group is valid

Line 134: raise FND_API.G_EXC_UNEXPECTED_ERROR;

130: FND_MSG_PUB.Count_AND_GET(
131: p_count=>x_msg_count,
132: p_data =>x_message_data,
133: p_encoded =>FND_API.G_FALSE);
134: raise FND_API.G_EXC_UNEXPECTED_ERROR;
135: End IF;
136:
137: -- Check if the IC Server Group is valid
138: Begin

Line 145: x_Return_Status:=FND_API.G_RET_STS_ERROR;

141: from IEO_SVR_GROUPS
142: where Server_Group_ID=p_IC_SERVER_GROUP_ID;
143: Exception
144: When others then
145: x_Return_Status:=FND_API.G_RET_STS_ERROR;
146: FND_MESSAGE.SET_NAME('CCT','CCT_JUMPSTART_INVALID_SERVER_GROUP_ID');
147: FND_MSG_PUB.ADD;
148: FND_MSG_PUB.Count_AND_GET(
149: p_count=>x_msg_count,

Line 151: p_encoded =>FND_API.G_FALSE);

147: FND_MSG_PUB.ADD;
148: FND_MSG_PUB.Count_AND_GET(
149: p_count=>x_msg_count,
150: p_data =>x_message_data,
151: p_encoded =>FND_API.G_FALSE);
152: raise FND_API.G_EXC_UNEXPECTED_ERROR;
153: End;
154:
155: -- Check if the Middleware_Config_ID is valid

Line 152: raise FND_API.G_EXC_UNEXPECTED_ERROR;

148: FND_MSG_PUB.Count_AND_GET(
149: p_count=>x_msg_count,
150: p_data =>x_message_data,
151: p_encoded =>FND_API.G_FALSE);
152: raise FND_API.G_EXC_UNEXPECTED_ERROR;
153: End;
154:
155: -- Check if the Middleware_Config_ID is valid
156: If (p_middleware_Config_id is not null) then

Line 166: x_Return_Status:=FND_API.G_RET_STS_ERROR;

162: and middleware_id=p_middleware_config_id
163: and nvl(f_deletedflag,'N') <> 'D';
164: Exception
165: When others then
166: x_Return_Status:=FND_API.G_RET_STS_ERROR;
167: FND_MESSAGE.SET_NAME('CCT','CCT_JUMPSTART_INVALID_MIDDLEWARE_CONFIG_ID');
168: FND_MSG_PUB.ADD;
169: FND_MSG_PUB.Count_AND_GET(
170: p_count=>x_msg_count,

Line 172: p_encoded =>FND_API.G_FALSE);

168: FND_MSG_PUB.ADD;
169: FND_MSG_PUB.Count_AND_GET(
170: p_count=>x_msg_count,
171: p_data =>x_message_data,
172: p_encoded =>FND_API.G_FALSE);
173: raise FND_API.G_EXC_UNEXPECTED_ERROR;
174: End;
175: End IF;
176:

Line 173: raise FND_API.G_EXC_UNEXPECTED_ERROR;

169: FND_MSG_PUB.Count_AND_GET(
170: p_count=>x_msg_count,
171: p_data =>x_message_data,
172: p_encoded =>FND_API.G_FALSE);
173: raise FND_API.G_EXC_UNEXPECTED_ERROR;
174: End;
175: End IF;
176:
177: -- Get the current date

Line 211: If (x_Return_Status=FND_API.G_RET_STS_ERROR) Then

207: );
208: -- rem dbms_output.put_line('Created resource='||p_last_name||', '||p_first_name);
209: x_user_password:=l_user_password;
210:
211: If (x_Return_Status=FND_API.G_RET_STS_ERROR) Then
212: -- rem dbms_output.put_line('Error in creating resource');
213: x_Return_Status:=FND_API.G_RET_STS_ERROR;
214: FND_MESSAGE.SET_NAME('CCT','CCT_JUMPSTART_ERROR_FROM_RS_API');
215: FND_MSG_PUB.ADD;

Line 213: x_Return_Status:=FND_API.G_RET_STS_ERROR;

209: x_user_password:=l_user_password;
210:
211: If (x_Return_Status=FND_API.G_RET_STS_ERROR) Then
212: -- rem dbms_output.put_line('Error in creating resource');
213: x_Return_Status:=FND_API.G_RET_STS_ERROR;
214: FND_MESSAGE.SET_NAME('CCT','CCT_JUMPSTART_ERROR_FROM_RS_API');
215: FND_MSG_PUB.ADD;
216: FND_MSG_PUB.Count_AND_GET(
217: p_count=>x_msg_count,

Line 219: p_encoded =>FND_API.G_FALSE);

215: FND_MSG_PUB.ADD;
216: FND_MSG_PUB.Count_AND_GET(
217: p_count=>x_msg_count,
218: p_data =>x_message_data,
219: p_encoded =>FND_API.G_FALSE);
220: raise FND_API.G_EXC_UNEXPECTED_ERROR;
221: END IF;
222:
223: Begin

Line 220: raise FND_API.G_EXC_UNEXPECTED_ERROR;

216: FND_MSG_PUB.Count_AND_GET(
217: p_count=>x_msg_count,
218: p_data =>x_message_data,
219: p_encoded =>FND_API.G_FALSE);
220: raise FND_API.G_EXC_UNEXPECTED_ERROR;
221: END IF;
222:
223: Begin
224: Update JTF_RS_RESOURCE_EXTNS

Line 230: x_Return_Status:=FND_API.G_RET_STS_ERROR;

226: where resource_id=p_resource_id;
227: Exception
228: When others then
229: -- rem dbms_output.put_line('Error in updating resource');
230: x_Return_Status:=FND_API.G_RET_STS_ERROR;
231: FND_MESSAGE.SET_NAME('CCT','CCT_JUMPSTART_ERROR_FROM_RS_SG');
232: FND_MSG_PUB.ADD;
233: FND_MSG_PUB.Count_AND_GET(
234: p_count=>x_msg_count,

Line 236: p_encoded =>FND_API.G_FALSE);

232: FND_MSG_PUB.ADD;
233: FND_MSG_PUB.Count_AND_GET(
234: p_count=>x_msg_count,
235: p_data =>x_message_data,
236: p_encoded =>FND_API.G_FALSE);
237: raise FND_API.G_EXC_UNEXPECTED_ERROR;
238: End;
239:
240: -- Add CCT Web Admin, Telesales Agent, Customer Care responsibilities to

Line 237: raise FND_API.G_EXC_UNEXPECTED_ERROR;

233: FND_MSG_PUB.Count_AND_GET(
234: p_count=>x_msg_count,
235: p_data =>x_message_data,
236: p_encoded =>FND_API.G_FALSE);
237: raise FND_API.G_EXC_UNEXPECTED_ERROR;
238: End;
239:
240: -- Add CCT Web Admin, Telesales Agent, Customer Care responsibilities to
241: -- agent

Line 253: p_encoded =>FND_API.G_FALSE);

249: when others then
250: FND_MSG_PUB.Count_AND_GET(
251: p_count=>x_msg_count,
252: p_data =>x_message_data,
253: p_encoded =>FND_API.G_FALSE);
254: --raise FND_API.G_EXC_UNEXPECTED_ERROR;
255: -- rem dbms_output.put_line('Error Creating Call Center Responsibility:'||x_message_data);
256: end;
257: Begin

Line 254: --raise FND_API.G_EXC_UNEXPECTED_ERROR;

250: FND_MSG_PUB.Count_AND_GET(
251: p_count=>x_msg_count,
252: p_data =>x_message_data,
253: p_encoded =>FND_API.G_FALSE);
254: --raise FND_API.G_EXC_UNEXPECTED_ERROR;
255: -- rem dbms_output.put_line('Error Creating Call Center Responsibility:'||x_message_data);
256: end;
257: Begin
258: fnd_user_pkg.addresp(upper(p_app_username),'AST','AST_TELEAGENT'

Line 268: p_encoded =>FND_API.G_FALSE);

264: when others then
265: FND_MSG_PUB.Count_AND_GET(
266: p_count=>x_msg_count,
267: p_data =>x_message_data,
268: p_encoded =>FND_API.G_FALSE);
269: --raise FND_API.G_EXC_UNEXPECTED_ERROR;
270: -- rem dbms_output.put_line('Error Creating Telesales Responsibility:'||x_message_data);
271: end;
272: Begin

Line 269: --raise FND_API.G_EXC_UNEXPECTED_ERROR;

265: FND_MSG_PUB.Count_AND_GET(
266: p_count=>x_msg_count,
267: p_data =>x_message_data,
268: p_encoded =>FND_API.G_FALSE);
269: --raise FND_API.G_EXC_UNEXPECTED_ERROR;
270: -- rem dbms_output.put_line('Error Creating Telesales Responsibility:'||x_message_data);
271: end;
272: Begin
273: fnd_user_pkg.addresp(upper(p_app_username),'CSS','ORACLE_SUPPORT'

Line 283: p_encoded =>FND_API.G_FALSE);

279: when others then
280: FND_MSG_PUB.Count_AND_GET(
281: p_count=>x_msg_count,
282: p_data =>x_message_data,
283: p_encoded =>FND_API.G_FALSE);
284: --raise FND_API.G_EXC_UNEXPECTED_ERROR;
285: -- rem dbms_output.put_line('Error Creating CCare Responsibility'||x_message_data);
286: end;
287: -- rem dbms_output.put_line('Added responsibilities for '||p_last_name||', '||p_first_name);

Line 284: --raise FND_API.G_EXC_UNEXPECTED_ERROR;

280: FND_MSG_PUB.Count_AND_GET(
281: p_count=>x_msg_count,
282: p_data =>x_message_data,
283: p_encoded =>FND_API.G_FALSE);
284: --raise FND_API.G_EXC_UNEXPECTED_ERROR;
285: -- rem dbms_output.put_line('Error Creating CCare Responsibility'||x_message_data);
286: end;
287: -- rem dbms_output.put_line('Added responsibilities for '||p_last_name||', '||p_first_name);
288:

Line 325: If (x_Return_Status=FND_API.G_RET_STS_ERROR) Then

321: );
322:
323: -- rem dbms_output.put_line('Added Call Center Resource Role for '||p_last_name||', '||p_first_name);
324:
325: If (x_Return_Status=FND_API.G_RET_STS_ERROR) Then
326: x_Return_Status:=FND_API.G_RET_STS_ERROR;
327: FND_MESSAGE.SET_NAME('CCT','CCT_JUMPSTART_ERROR_FROM_RS_ROLES_API');
328: FND_MSG_PUB.ADD;
329: FND_MSG_PUB.Count_AND_GET(

Line 326: x_Return_Status:=FND_API.G_RET_STS_ERROR;

322:
323: -- rem dbms_output.put_line('Added Call Center Resource Role for '||p_last_name||', '||p_first_name);
324:
325: If (x_Return_Status=FND_API.G_RET_STS_ERROR) Then
326: x_Return_Status:=FND_API.G_RET_STS_ERROR;
327: FND_MESSAGE.SET_NAME('CCT','CCT_JUMPSTART_ERROR_FROM_RS_ROLES_API');
328: FND_MSG_PUB.ADD;
329: FND_MSG_PUB.Count_AND_GET(
330: p_count=>x_msg_count,

Line 332: p_encoded =>FND_API.G_FALSE);

328: FND_MSG_PUB.ADD;
329: FND_MSG_PUB.Count_AND_GET(
330: p_count=>x_msg_count,
331: p_data =>x_message_data,
332: p_encoded =>FND_API.G_FALSE);
333: raise FND_API.G_EXC_UNEXPECTED_ERROR;
334: END IF;
335:
336: If (p_middleware_config_id is not null) then

Line 333: raise FND_API.G_EXC_UNEXPECTED_ERROR;

329: FND_MSG_PUB.Count_AND_GET(
330: p_count=>x_msg_count,
331: p_data =>x_message_data,
332: p_encoded =>FND_API.G_FALSE);
333: raise FND_API.G_EXC_UNEXPECTED_ERROR;
334: END IF;
335:
336: If (p_middleware_config_id is not null) then
337: -- rem dbms_output.put_line('Adding Agent Parameter Values for '||p_last_name||', '||p_first_name);

Line 367: If (x_Return_Status=FND_API.G_RET_STS_ERROR) Then

363: ,x_msg_count=>x_msg_count
364: ,x_msg_data=>x_message_data
365: ,x_resource_param_value_id=>l_agent_param_value_id
366: );
367: If (x_Return_Status=FND_API.G_RET_STS_ERROR) Then
368: x_Return_Status:=FND_API.G_RET_STS_ERROR;
369: FND_MESSAGE.SET_NAME('CCT','CCT_JUMPSTART_ERROR_FROM_RS_VALUES_API_'||l_agent_param_name);
370: FND_MSG_PUB.ADD;
371: FND_MSG_PUB.Count_AND_GET(

Line 368: x_Return_Status:=FND_API.G_RET_STS_ERROR;

364: ,x_msg_data=>x_message_data
365: ,x_resource_param_value_id=>l_agent_param_value_id
366: );
367: If (x_Return_Status=FND_API.G_RET_STS_ERROR) Then
368: x_Return_Status:=FND_API.G_RET_STS_ERROR;
369: FND_MESSAGE.SET_NAME('CCT','CCT_JUMPSTART_ERROR_FROM_RS_VALUES_API_'||l_agent_param_name);
370: FND_MSG_PUB.ADD;
371: FND_MSG_PUB.Count_AND_GET(
372: p_count=>x_msg_count,

Line 374: p_encoded =>FND_API.G_FALSE);

370: FND_MSG_PUB.ADD;
371: FND_MSG_PUB.Count_AND_GET(
372: p_count=>x_msg_count,
373: p_data =>x_message_data,
374: p_encoded =>FND_API.G_FALSE);
375: raise FND_API.G_EXC_UNEXPECTED_ERROR;
376: END IF;
377:
378: Exception

Line 375: raise FND_API.G_EXC_UNEXPECTED_ERROR;

371: FND_MSG_PUB.Count_AND_GET(
372: p_count=>x_msg_count,
373: p_data =>x_message_data,
374: p_encoded =>FND_API.G_FALSE);
375: raise FND_API.G_EXC_UNEXPECTED_ERROR;
376: END IF;
377:
378: Exception
379: When others then

Line 380: x_Return_Status:=FND_API.G_RET_STS_ERROR;

376: END IF;
377:
378: Exception
379: When others then
380: x_Return_Status:=FND_API.G_RET_STS_ERROR;
381: FND_MESSAGE.SET_NAME('CCT','CCT_JUMPSTART_ERROR_FROM_RS_VALUES_'||l_agent_param_name);
382: FND_MSG_PUB.ADD;
383: FND_MSG_PUB.Count_AND_GET(
384: p_count=>x_msg_count,

Line 386: p_encoded =>FND_API.G_FALSE);

382: FND_MSG_PUB.ADD;
383: FND_MSG_PUB.Count_AND_GET(
384: p_count=>x_msg_count,
385: p_data =>x_message_data,
386: p_encoded =>FND_API.G_FALSE);
387: raise FND_API.G_EXC_UNEXPECTED_ERROR;
388: End;
389: End If;
390:

Line 387: raise FND_API.G_EXC_UNEXPECTED_ERROR;

383: FND_MSG_PUB.Count_AND_GET(
384: p_count=>x_msg_count,
385: p_data =>x_message_data,
386: p_encoded =>FND_API.G_FALSE);
387: raise FND_API.G_EXC_UNEXPECTED_ERROR;
388: End;
389: End If;
390:
391: If (p_acd_agent_id is not null) then

Line 415: If (x_Return_Status=FND_API.G_RET_STS_ERROR) Then

411: ,x_msg_count=>x_msg_count
412: ,x_msg_data=>x_message_data
413: ,x_resource_param_value_id=>l_agent_param_value_id
414: );
415: If (x_Return_Status=FND_API.G_RET_STS_ERROR) Then
416: x_Return_Status:=FND_API.G_RET_STS_ERROR;
417: FND_MESSAGE.SET_NAME('CCT','CCT_JUMPSTART_ERROR_FROM_RS_VALUES_API_'||l_agent_param_name);
418: FND_MSG_PUB.ADD;
419: FND_MSG_PUB.Count_AND_GET(

Line 416: x_Return_Status:=FND_API.G_RET_STS_ERROR;

412: ,x_msg_data=>x_message_data
413: ,x_resource_param_value_id=>l_agent_param_value_id
414: );
415: If (x_Return_Status=FND_API.G_RET_STS_ERROR) Then
416: x_Return_Status:=FND_API.G_RET_STS_ERROR;
417: FND_MESSAGE.SET_NAME('CCT','CCT_JUMPSTART_ERROR_FROM_RS_VALUES_API_'||l_agent_param_name);
418: FND_MSG_PUB.ADD;
419: FND_MSG_PUB.Count_AND_GET(
420: p_count=>x_msg_count,

Line 422: p_encoded =>FND_API.G_FALSE);

418: FND_MSG_PUB.ADD;
419: FND_MSG_PUB.Count_AND_GET(
420: p_count=>x_msg_count,
421: p_data =>x_message_data,
422: p_encoded =>FND_API.G_FALSE);
423: raise FND_API.G_EXC_UNEXPECTED_ERROR;
424: END IF;
425:
426: Exception

Line 423: raise FND_API.G_EXC_UNEXPECTED_ERROR;

419: FND_MSG_PUB.Count_AND_GET(
420: p_count=>x_msg_count,
421: p_data =>x_message_data,
422: p_encoded =>FND_API.G_FALSE);
423: raise FND_API.G_EXC_UNEXPECTED_ERROR;
424: END IF;
425:
426: Exception
427: When others then

Line 428: x_Return_Status:=FND_API.G_RET_STS_ERROR;

424: END IF;
425:
426: Exception
427: When others then
428: x_Return_Status:=FND_API.G_RET_STS_ERROR;
429: FND_MESSAGE.SET_NAME('CCT','CCT_JUMPSTART_ERROR_FROM_RS_VALUES_'||l_agent_param_name);
430: FND_MSG_PUB.ADD;
431: FND_MSG_PUB.Count_AND_GET(
432: p_count=>x_msg_count,

Line 434: p_encoded =>FND_API.G_FALSE);

430: FND_MSG_PUB.ADD;
431: FND_MSG_PUB.Count_AND_GET(
432: p_count=>x_msg_count,
433: p_data =>x_message_data,
434: p_encoded =>FND_API.G_FALSE);
435: raise FND_API.G_EXC_UNEXPECTED_ERROR;
436: End;
437: End If;
438:

Line 435: raise FND_API.G_EXC_UNEXPECTED_ERROR;

431: FND_MSG_PUB.Count_AND_GET(
432: p_count=>x_msg_count,
433: p_data =>x_message_data,
434: p_encoded =>FND_API.G_FALSE);
435: raise FND_API.G_EXC_UNEXPECTED_ERROR;
436: End;
437: End If;
438:
439: If (p_acd_agent_password is not null) then

Line 463: If (x_Return_Status=FND_API.G_RET_STS_ERROR) Then

459: ,x_msg_count=>x_msg_count
460: ,x_msg_data=>x_message_data
461: ,x_resource_param_value_id=>l_agent_param_value_id
462: );
463: If (x_Return_Status=FND_API.G_RET_STS_ERROR) Then
464: x_Return_Status:=FND_API.G_RET_STS_ERROR;
465: FND_MESSAGE.SET_NAME('CCT','CCT_JUMPSTART_ERROR_FROM_RS_VALUES_API_'||l_agent_param_name);
466: FND_MSG_PUB.ADD;
467: FND_MSG_PUB.Count_AND_GET(

Line 464: x_Return_Status:=FND_API.G_RET_STS_ERROR;

460: ,x_msg_data=>x_message_data
461: ,x_resource_param_value_id=>l_agent_param_value_id
462: );
463: If (x_Return_Status=FND_API.G_RET_STS_ERROR) Then
464: x_Return_Status:=FND_API.G_RET_STS_ERROR;
465: FND_MESSAGE.SET_NAME('CCT','CCT_JUMPSTART_ERROR_FROM_RS_VALUES_API_'||l_agent_param_name);
466: FND_MSG_PUB.ADD;
467: FND_MSG_PUB.Count_AND_GET(
468: p_count=>x_msg_count,

Line 470: p_encoded =>FND_API.G_FALSE);

466: FND_MSG_PUB.ADD;
467: FND_MSG_PUB.Count_AND_GET(
468: p_count=>x_msg_count,
469: p_data =>x_message_data,
470: p_encoded =>FND_API.G_FALSE);
471: raise FND_API.G_EXC_UNEXPECTED_ERROR;
472: END IF;
473:
474: Exception

Line 471: raise FND_API.G_EXC_UNEXPECTED_ERROR;

467: FND_MSG_PUB.Count_AND_GET(
468: p_count=>x_msg_count,
469: p_data =>x_message_data,
470: p_encoded =>FND_API.G_FALSE);
471: raise FND_API.G_EXC_UNEXPECTED_ERROR;
472: END IF;
473:
474: Exception
475: When others then

Line 476: x_Return_Status:=FND_API.G_RET_STS_ERROR;

472: END IF;
473:
474: Exception
475: When others then
476: x_Return_Status:=FND_API.G_RET_STS_ERROR;
477: FND_MESSAGE.SET_NAME('CCT','CCT_JUMPSTART_ERROR_FROM_RS_VALUES_'||l_agent_param_name);
478: FND_MSG_PUB.ADD;
479: FND_MSG_PUB.Count_AND_GET(
480: p_count=>x_msg_count,

Line 482: p_encoded =>FND_API.G_FALSE);

478: FND_MSG_PUB.ADD;
479: FND_MSG_PUB.Count_AND_GET(
480: p_count=>x_msg_count,
481: p_data =>x_message_data,
482: p_encoded =>FND_API.G_FALSE);
483: raise FND_API.G_EXC_UNEXPECTED_ERROR;
484: End;
485: End If;
486:

Line 483: raise FND_API.G_EXC_UNEXPECTED_ERROR;

479: FND_MSG_PUB.Count_AND_GET(
480: p_count=>x_msg_count,
481: p_data =>x_message_data,
482: p_encoded =>FND_API.G_FALSE);
483: raise FND_API.G_EXC_UNEXPECTED_ERROR;
484: End;
485: End If;
486:
487: End If;

Line 498: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

494:
495: Procedure CreateServerGroup(
496: p_server_Group_Name In Varchar2
497: ,x_return_Status OUT nocopy VARCHAR2
498: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
499: ,p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
500: ,x_msg_count OUT nocopy NUMBER
501: ,x_message_data OUT nocopy VARCHAR2
502: ,x_Server_group_id Out nocopy Number

Line 499: ,p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

495: Procedure CreateServerGroup(
496: p_server_Group_Name In Varchar2
497: ,x_return_Status OUT nocopy VARCHAR2
498: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
499: ,p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
500: ,x_msg_count OUT nocopy NUMBER
501: ,x_message_data OUT nocopy VARCHAR2
502: ,x_Server_group_id Out nocopy Number
503: ) IS

Line 510: IF FND_API.to_Boolean(p_init_msg_list) THEN

506: l_server_group_id Number;
507: Begin
508:
509: -- Init message list
510: IF FND_API.to_Boolean(p_init_msg_list) THEN
511: FND_MSG_PUB.initialize;
512: END IF;
513:
514: -- Init Return status

Line 515: x_return_status:=FND_API.G_RET_STS_SUCCESS;

511: FND_MSG_PUB.initialize;
512: END IF;
513:
514: -- Init Return status
515: x_return_status:=FND_API.G_RET_STS_SUCCESS;
516:
517: -- Check if the Server Group already exists
518: Begin
519: Select 1

Line 524: x_return_status:=FND_API.G_RET_STS_ERROR;

520: into x_sql_Result
521: from ieo_svr_groups
522: where group_name=p_server_Group_name;
523: If (x_sql_result=1) then
524: x_return_status:=FND_API.G_RET_STS_ERROR;
525: FND_MESSAGE.SET_NAME('CCT','CCT_JUMPSTART_ERROR_SERVER_GROUP_EXISTS');
526: FND_MSG_PUB.ADD;
527: FND_MSG_PUB.Count_AND_GET(
528: p_count=>x_msg_count,

Line 530: p_encoded =>FND_API.G_FALSE);

526: FND_MSG_PUB.ADD;
527: FND_MSG_PUB.Count_AND_GET(
528: p_count=>x_msg_count,
529: p_data =>x_message_data,
530: p_encoded =>FND_API.G_FALSE);
531: raise FND_API.G_EXC_UNEXPECTED_ERROR;
532: End if;
533: Exception
534: When No_data_found then

Line 531: raise FND_API.G_EXC_UNEXPECTED_ERROR;

527: FND_MSG_PUB.Count_AND_GET(
528: p_count=>x_msg_count,
529: p_data =>x_message_data,
530: p_encoded =>FND_API.G_FALSE);
531: raise FND_API.G_EXC_UNEXPECTED_ERROR;
532: End if;
533: Exception
534: When No_data_found then
535: Select IEO_SVR_GROUPS_S1.nextval

Line 545: x_Return_Status:=FND_API.G_RET_STS_ERROR;

541: values(l_server_Group_id,p_server_group_name,p_server_group_name,p_server_group_name
542: ,1,sysdate,1,sysdate);
543: x_server_group_id:=l_server_group_id;
544: When others then
545: x_Return_Status:=FND_API.G_RET_STS_ERROR;
546: FND_MESSAGE.SET_NAME('CCT','CCT_JUMPSTART_ERROR_SERVER_GROUP_EXISTS');
547: FND_MSG_PUB.ADD;
548: FND_MSG_PUB.Count_AND_GET(
549: p_count=>x_msg_count,

Line 551: p_encoded =>FND_API.G_FALSE);

547: FND_MSG_PUB.ADD;
548: FND_MSG_PUB.Count_AND_GET(
549: p_count=>x_msg_count,
550: p_data =>x_message_data,
551: p_encoded =>FND_API.G_FALSE);
552: raise FND_API.G_EXC_UNEXPECTED_ERROR;
553: End;
554: Exception
555: When others then

Line 552: raise FND_API.G_EXC_UNEXPECTED_ERROR;

548: FND_MSG_PUB.Count_AND_GET(
549: p_count=>x_msg_count,
550: p_data =>x_message_data,
551: p_encoded =>FND_API.G_FALSE);
552: raise FND_API.G_EXC_UNEXPECTED_ERROR;
553: End;
554: Exception
555: When others then
556: x_Return_Status:=FND_API.G_RET_STS_ERROR;

Line 556: x_Return_Status:=FND_API.G_RET_STS_ERROR;

552: raise FND_API.G_EXC_UNEXPECTED_ERROR;
553: End;
554: Exception
555: When others then
556: x_Return_Status:=FND_API.G_RET_STS_ERROR;
557: FND_MESSAGE.SET_NAME('CCT','CCT_JUMPSTART_ERROR_SERVER_GROUP_EXISTS');
558: FND_MSG_PUB.ADD;
559: FND_MSG_PUB.Count_AND_GET(
560: p_count=>x_msg_count,

Line 562: p_encoded =>FND_API.G_FALSE);

558: FND_MSG_PUB.ADD;
559: FND_MSG_PUB.Count_AND_GET(
560: p_count=>x_msg_count,
561: p_data =>x_message_data,
562: p_encoded =>FND_API.G_FALSE);
563: raise FND_API.G_EXC_UNEXPECTED_ERROR;
564: End;
565:
566:

Line 563: raise FND_API.G_EXC_UNEXPECTED_ERROR;

559: FND_MSG_PUB.Count_AND_GET(
560: p_count=>x_msg_count,
561: p_data =>x_message_data,
562: p_encoded =>FND_API.G_FALSE);
563: raise FND_API.G_EXC_UNEXPECTED_ERROR;
564: End;
565:
566:
567: Procedure CreateAllServers(

Line 571: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

567: Procedure CreateAllServers(
568: p_server_group_id In Number
569: ,p_call_center_type IN VARCHAR2 DEFAULT NULL
570: ,x_return_Status OUT nocopy VARCHAR2
571: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
572: ,p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
573: ,x_msg_count OUT nocopy NUMBER
574: ,x_message_data OUT nocopy VARCHAR2
575: ,x_SERVERTYPEID_SERVERID OUT nocopy CCT_KEYVALUE_VARR

Line 572: ,p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

568: p_server_group_id In Number
569: ,p_call_center_type IN VARCHAR2 DEFAULT NULL
570: ,x_return_Status OUT nocopy VARCHAR2
571: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
572: ,p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
573: ,x_msg_count OUT nocopy NUMBER
574: ,x_message_data OUT nocopy VARCHAR2
575: ,x_SERVERTYPEID_SERVERID OUT nocopy CCT_KEYVALUE_VARR
576: )

Line 612: x_Return_Status:=FND_API.G_RET_STS_ERROR;

608: END LOOP;
609: x_servertypeid_serverid:=l_SERVERTYPEID_SERVERID;
610: Exception
611: When others then
612: x_Return_Status:=FND_API.G_RET_STS_ERROR;
613: FND_MESSAGE.SET_NAME('CCT','CCT_JUMPSTART_ERROR_CREATING_SERVERS');
614: FND_MSG_PUB.ADD;
615: FND_MSG_PUB.Count_AND_GET(
616: p_count=>x_msg_count,

Line 618: p_encoded =>FND_API.G_FALSE);

614: FND_MSG_PUB.ADD;
615: FND_MSG_PUB.Count_AND_GET(
616: p_count=>x_msg_count,
617: p_data =>x_message_data,
618: p_encoded =>FND_API.G_FALSE);
619: raise FND_API.G_EXC_UNEXPECTED_ERROR;
620: END;
621:
622: Procedure CreateServerParam(

Line 619: raise FND_API.G_EXC_UNEXPECTED_ERROR;

615: FND_MSG_PUB.Count_AND_GET(
616: p_count=>x_msg_count,
617: p_data =>x_message_data,
618: p_encoded =>FND_API.G_FALSE);
619: raise FND_API.G_EXC_UNEXPECTED_ERROR;
620: END;
621:
622: Procedure CreateServerParam(
623: p_server_id In Number

Line 625: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

621:
622: Procedure CreateServerParam(
623: p_server_id In Number
624: ,p_param_value IN CCT_KEYVALUE_VARR
625: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
626: ,p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
627: ,x_return_Status OUT nocopy VARCHAR2
628: ,x_msg_count OUT nocopy NUMBER
629: ,x_message_data OUT nocopy VARCHAR2

Line 626: ,p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

622: Procedure CreateServerParam(
623: p_server_id In Number
624: ,p_param_value IN CCT_KEYVALUE_VARR
625: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
626: ,p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
627: ,x_return_Status OUT nocopy VARCHAR2
628: ,x_msg_count OUT nocopy NUMBER
629: ,x_message_data OUT nocopy VARCHAR2
630: )

Line 678: x_Return_Status:=FND_API.G_RET_STS_ERROR;

674: End loop;
675:
676: Exception
677: When OTHERS then
678: x_Return_Status:=FND_API.G_RET_STS_ERROR;
679: FND_MESSAGE.SET_NAME('CCT','CCT_JUMPSTART_ERROR_CREATING_MWARE_PARAMS');
680: FND_MSG_PUB.ADD;
681: FND_MSG_PUB.Count_AND_GET(
682: p_count=>x_msg_count,

Line 684: p_encoded =>FND_API.G_FALSE);

680: FND_MSG_PUB.ADD;
681: FND_MSG_PUB.Count_AND_GET(
682: p_count=>x_msg_count,
683: p_data =>x_message_data,
684: p_encoded =>FND_API.G_FALSE);
685: raise FND_API.G_EXC_UNEXPECTED_ERROR;
686: End;
687:
688:

Line 685: raise FND_API.G_EXC_UNEXPECTED_ERROR;

681: FND_MSG_PUB.Count_AND_GET(
682: p_count=>x_msg_count,
683: p_data =>x_message_data,
684: p_encoded =>FND_API.G_FALSE);
685: raise FND_API.G_EXC_UNEXPECTED_ERROR;
686: End;
687:
688:
689:

Line 693: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

689:
690: Procedure CreateMiddlewareConfig(
691: p_server_group_id In Number
692: ,p_middleware_type IN Varchar2
693: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
694: ,p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
695: ,x_return_Status OUT nocopy VARCHAR2
696: ,x_msg_count OUT nocopy NUMBER
697: ,x_message_data OUT nocopy VARCHAR2

Line 694: ,p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

690: Procedure CreateMiddlewareConfig(
691: p_server_group_id In Number
692: ,p_middleware_type IN Varchar2
693: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
694: ,p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
695: ,x_return_Status OUT nocopy VARCHAR2
696: ,x_msg_count OUT nocopy NUMBER
697: ,x_message_data OUT nocopy VARCHAR2
698: ,x_middleware_id OUT nocopy Number

Line 726: x_Return_Status:=FND_API.G_RET_STS_ERROR;

722: where not exists (Select 1 from cct_middlewares
723: where server_group_id=p_server_Group_id and config_name=l_config_name);
724: Exception
725: When No_Data_Found then
726: x_Return_Status:=FND_API.G_RET_STS_ERROR;
727: FND_MESSAGE.SET_NAME('CCT','CCT_JUMPSTART_ERROR_CREATING_MWARE_CONFIG');
728: FND_MSG_PUB.ADD;
729: FND_MSG_PUB.Count_AND_GET(
730: p_count=>x_msg_count,

Line 732: p_encoded =>FND_API.G_FALSE);

728: FND_MSG_PUB.ADD;
729: FND_MSG_PUB.Count_AND_GET(
730: p_count=>x_msg_count,
731: p_data =>x_message_data,
732: p_encoded =>FND_API.G_FALSE);
733: raise FND_API.G_EXC_UNEXPECTED_ERROR;
734: End;
735:
736:

Line 733: raise FND_API.G_EXC_UNEXPECTED_ERROR;

729: FND_MSG_PUB.Count_AND_GET(
730: p_count=>x_msg_count,
731: p_data =>x_message_data,
732: p_encoded =>FND_API.G_FALSE);
733: raise FND_API.G_EXC_UNEXPECTED_ERROR;
734: End;
735:
736:
737: Procedure GetMiddlewareConfigInfo(

Line 766: x_return_status:=FND_API.G_RET_STS_SUCCESS;

762: where v.middleware_id=p_middleware_id
763: and nvl(v.f_deletedflag,'N')<>'D'
764: and v.middleware_param_id=p.middleware_param_id;
765: Begin
766: x_return_status:=FND_API.G_RET_STS_SUCCESS;
767: If p_server_group_name is not null THEN
768: Begin
769: Select server_group_id
770: into l_server_group_id

Line 775: x_Return_Status:=FND_API.G_RET_STS_ERROR;

771: from ieo_Svr_groups
772: where group_name =p_server_Group_name;
773: Exception
774: When No_Data_Found then
775: x_Return_Status:=FND_API.G_RET_STS_ERROR;
776: x_message_data:='SERVER_GROUP_NOT_FOUND';
777: -- rem dbms_output.put_line(x_message_data);
778: raise FND_API.G_EXC_UNEXPECTED_ERROR;
779: End;

Line 778: raise FND_API.G_EXC_UNEXPECTED_ERROR;

774: When No_Data_Found then
775: x_Return_Status:=FND_API.G_RET_STS_ERROR;
776: x_message_data:='SERVER_GROUP_NOT_FOUND';
777: -- rem dbms_output.put_line(x_message_data);
778: raise FND_API.G_EXC_UNEXPECTED_ERROR;
779: End;
780: End if;
781:
782: If (p_server_group_id is not null) Then

Line 801: x_Return_Status:=FND_API.G_RET_STS_ERROR;

797: and m.server_Group_id=s.member_svr_group_id
798: and m.middleware_type_id=t.middleware_type_id;
799: Exception
800: When no_data_found then
801: x_Return_Status:=FND_API.G_RET_STS_ERROR;
802: x_message_data:='NO_MWARE_FOR_OTAS';
803: -- rem dbms_output.put_line(x_message_data);
804: raise FND_API.G_EXC_UNEXPECTED_ERROR;
805: When others then

Line 804: raise FND_API.G_EXC_UNEXPECTED_ERROR;

800: When no_data_found then
801: x_Return_Status:=FND_API.G_RET_STS_ERROR;
802: x_message_data:='NO_MWARE_FOR_OTAS';
803: -- rem dbms_output.put_line(x_message_data);
804: raise FND_API.G_EXC_UNEXPECTED_ERROR;
805: When others then
806: x_Return_Status:=FND_API.G_RET_STS_ERROR;
807: x_message_data:='ERROR_IN_MWARE_FOR_OTAS';
808: -- rem dbms_output.put_line(x_message_data);

Line 806: x_Return_Status:=FND_API.G_RET_STS_ERROR;

802: x_message_data:='NO_MWARE_FOR_OTAS';
803: -- rem dbms_output.put_line(x_message_data);
804: raise FND_API.G_EXC_UNEXPECTED_ERROR;
805: When others then
806: x_Return_Status:=FND_API.G_RET_STS_ERROR;
807: x_message_data:='ERROR_IN_MWARE_FOR_OTAS';
808: -- rem dbms_output.put_line(x_message_data);
809: raise FND_API.G_EXC_UNEXPECTED_ERROR;
810:

Line 809: raise FND_API.G_EXC_UNEXPECTED_ERROR;

805: When others then
806: x_Return_Status:=FND_API.G_RET_STS_ERROR;
807: x_message_data:='ERROR_IN_MWARE_FOR_OTAS';
808: -- rem dbms_output.put_line(x_message_data);
809: raise FND_API.G_EXC_UNEXPECTED_ERROR;
810:
811: End;
812: End if;
813:

Line 838: x_Return_Status:=FND_API.G_RET_STS_ERROR;

834: Exit When c_param_value%NOTFOUND;
835: End loop;
836: x_param_value:=l_paramValue;
837: Else
838: x_Return_Status:=FND_API.G_RET_STS_ERROR;
839: x_message_data:='ERROR:MIDDLEWARE_CONFIG_PARAM_NOT_DEFINED';
840: -- rem dbms_output.put_line(x_message_data);
841: raise FND_API.G_EXC_UNEXPECTED_ERROR;
842: End if;

Line 841: raise FND_API.G_EXC_UNEXPECTED_ERROR;

837: Else
838: x_Return_Status:=FND_API.G_RET_STS_ERROR;
839: x_message_data:='ERROR:MIDDLEWARE_CONFIG_PARAM_NOT_DEFINED';
840: -- rem dbms_output.put_line(x_message_data);
841: raise FND_API.G_EXC_UNEXPECTED_ERROR;
842: End if;
843: Exception
844: When others then
845: x_Return_Status:=FND_API.G_RET_STS_ERROR;

Line 845: x_Return_Status:=FND_API.G_RET_STS_ERROR;

841: raise FND_API.G_EXC_UNEXPECTED_ERROR;
842: End if;
843: Exception
844: When others then
845: x_Return_Status:=FND_API.G_RET_STS_ERROR;
846: x_message_data:='ERROR:INVALID_MWARE';
847: -- rem dbms_output.put_line(x_message_data);
848: raise FND_API.G_EXC_UNEXPECTED_ERROR;
849: End;

Line 848: raise FND_API.G_EXC_UNEXPECTED_ERROR;

844: When others then
845: x_Return_Status:=FND_API.G_RET_STS_ERROR;
846: x_message_data:='ERROR:INVALID_MWARE';
847: -- rem dbms_output.put_line(x_message_data);
848: raise FND_API.G_EXC_UNEXPECTED_ERROR;
849: End;
850:
851: Procedure CreateTelesets(
852: p_middleware_id In Number

Line 860: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

856: ,p_number_of_Telesets In Number
857: ,p_line1 In Number Default Null
858: ,p_line2 In Number Default Null
859: ,p_line3 In Number Default 9999
860: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
861: ,p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
862: ,x_return_Status OUT nocopy VARCHAR2
863: ,x_msg_count OUT nocopy NUMBER
864: ,x_message_data OUT nocopy VARCHAR2

Line 861: ,p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

857: ,p_line1 In Number Default Null
858: ,p_line2 In Number Default Null
859: ,p_line3 In Number Default 9999
860: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
861: ,p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
862: ,x_return_Status OUT nocopy VARCHAR2
863: ,x_msg_count OUT nocopy NUMBER
864: ,x_message_data OUT nocopy VARCHAR2
865: )

Line 951: x_Return_Status:=FND_API.G_RET_STS_ERROR;

947: End loop;
948:
949: Exception
950: When OTHERS then
951: x_Return_Status:=FND_API.G_RET_STS_ERROR;
952: FND_MESSAGE.SET_NAME('CCT','CCT_JUMPSTART_ERROR_CREATING_TELESETS');
953: FND_MSG_PUB.ADD;
954: FND_MSG_PUB.Count_AND_GET(
955: p_count=>x_msg_count,

Line 957: p_encoded =>FND_API.G_FALSE);

953: FND_MSG_PUB.ADD;
954: FND_MSG_PUB.Count_AND_GET(
955: p_count=>x_msg_count,
956: p_data =>x_message_data,
957: p_encoded =>FND_API.G_FALSE);
958: raise FND_API.G_EXC_UNEXPECTED_ERROR;
959: End;
960:
961: Procedure CreateMwareParam(

Line 958: raise FND_API.G_EXC_UNEXPECTED_ERROR;

954: FND_MSG_PUB.Count_AND_GET(
955: p_count=>x_msg_count,
956: p_data =>x_message_data,
957: p_encoded =>FND_API.G_FALSE);
958: raise FND_API.G_EXC_UNEXPECTED_ERROR;
959: End;
960:
961: Procedure CreateMwareParam(
962: p_middleware_id In Number

Line 964: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

960:
961: Procedure CreateMwareParam(
962: p_middleware_id In Number
963: ,p_param_value IN CCT_KEYVALUE_VARR
964: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
965: ,p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
966: ,x_return_Status OUT nocopy VARCHAR2
967: ,x_msg_count OUT nocopy NUMBER
968: ,x_message_data OUT nocopy VARCHAR2

Line 965: ,p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

961: Procedure CreateMwareParam(
962: p_middleware_id In Number
963: ,p_param_value IN CCT_KEYVALUE_VARR
964: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
965: ,p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
966: ,x_return_Status OUT nocopy VARCHAR2
967: ,x_msg_count OUT nocopy NUMBER
968: ,x_message_data OUT nocopy VARCHAR2
969: ) IS

Line 1018: x_Return_Status:=FND_API.G_RET_STS_ERROR;

1014: End loop;
1015:
1016: Exception
1017: When OTHERS then
1018: x_Return_Status:=FND_API.G_RET_STS_ERROR;
1019: FND_MESSAGE.SET_NAME('CCT','CCT_JUMPSTART_ERROR_CREATING_MWARE_PARAMS');
1020: FND_MSG_PUB.ADD;
1021: FND_MSG_PUB.Count_AND_GET(
1022: p_count=>x_msg_count,

Line 1024: p_encoded =>FND_API.G_FALSE);

1020: FND_MSG_PUB.ADD;
1021: FND_MSG_PUB.Count_AND_GET(
1022: p_count=>x_msg_count,
1023: p_data =>x_message_data,
1024: p_encoded =>FND_API.G_FALSE);
1025: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1026: End;
1027:
1028: Procedure CreateRoutePoint(

Line 1025: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1021: FND_MSG_PUB.Count_AND_GET(
1022: p_count=>x_msg_count,
1023: p_data =>x_message_data,
1024: p_encoded =>FND_API.G_FALSE);
1025: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1026: End;
1027:
1028: Procedure CreateRoutePoint(
1029: p_middleware_id In Number

Line 1031: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

1027:
1028: Procedure CreateRoutePoint(
1029: p_middleware_id In Number
1030: ,p_route_point_number IN VARCHAR2
1031: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
1032: ,p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1033: ,x_return_Status OUT nocopy VARCHAR2
1034: ,x_msg_count OUT nocopy NUMBER
1035: ,x_message_data OUT nocopy VARCHAR2

Line 1032: ,p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

1028: Procedure CreateRoutePoint(
1029: p_middleware_id In Number
1030: ,p_route_point_number IN VARCHAR2
1031: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
1032: ,p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1033: ,x_return_Status OUT nocopy VARCHAR2
1034: ,x_msg_count OUT nocopy NUMBER
1035: ,x_message_data OUT nocopy VARCHAR2
1036: ,x_route_point_id OUT nocopy NUMBER

Line 1055: x_Return_Status:=FND_API.G_RET_STS_ERROR;

1051: and nvl(f_deletedflag,'N')<>'D');
1052: x_route_point_id:=l_route_point_id;
1053: Exception
1054: When OTHERS then
1055: x_Return_Status:=FND_API.G_RET_STS_ERROR;
1056: FND_MESSAGE.SET_NAME('CCT','CCT_JUMPSTART_ERROR_CREATING_ROUTE_POINT');
1057: FND_MSG_PUB.ADD;
1058: FND_MSG_PUB.Count_AND_GET(
1059: p_count=>x_msg_count,

Line 1061: p_encoded =>FND_API.G_FALSE);

1057: FND_MSG_PUB.ADD;
1058: FND_MSG_PUB.Count_AND_GET(
1059: p_count=>x_msg_count,
1060: p_data =>x_message_data,
1061: p_encoded =>FND_API.G_FALSE);
1062: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1063: End;
1064:
1065: Procedure CreateRoutePointParams(

Line 1062: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1058: FND_MSG_PUB.Count_AND_GET(
1059: p_count=>x_msg_count,
1060: p_data =>x_message_data,
1061: p_encoded =>FND_API.G_FALSE);
1062: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1063: End;
1064:
1065: Procedure CreateRoutePointParams(
1066: p_route_point_id In Number

Line 1068: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

1064:
1065: Procedure CreateRoutePointParams(
1066: p_route_point_id In Number
1067: ,p_param_value CCT_KEYVALUE_VARR
1068: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
1069: ,p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1070: ,x_return_Status OUT nocopy VARCHAR2
1071: ,x_msg_count OUT nocopy NUMBER
1072: ,x_message_data OUT nocopy VARCHAR2

Line 1069: ,p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

1065: Procedure CreateRoutePointParams(
1066: p_route_point_id In Number
1067: ,p_param_value CCT_KEYVALUE_VARR
1068: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
1069: ,p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1070: ,x_return_Status OUT nocopy VARCHAR2
1071: ,x_msg_count OUT nocopy NUMBER
1072: ,x_message_data OUT nocopy VARCHAR2
1073: )

Line 1115: x_Return_Status:=FND_API.G_RET_STS_ERROR;

1111: End loop;
1112:
1113: Exception
1114: When OTHERS then
1115: x_Return_Status:=FND_API.G_RET_STS_ERROR;
1116: FND_MESSAGE.SET_NAME('CCT','CCT_JUMPSTART_ERROR_CREATING_ROUTE_POINT_PARAMS');
1117: FND_MSG_PUB.ADD;
1118: FND_MSG_PUB.Count_AND_GET(
1119: p_count=>x_msg_count,

Line 1121: p_encoded =>FND_API.G_FALSE);

1117: FND_MSG_PUB.ADD;
1118: FND_MSG_PUB.Count_AND_GET(
1119: p_count=>x_msg_count,
1120: p_data =>x_message_data,
1121: p_encoded =>FND_API.G_FALSE);
1122: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1123: End;
1124:
1125: END CCT_ICJUMPSTART_PUB;

Line 1122: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1118: FND_MSG_PUB.Count_AND_GET(
1119: p_count=>x_msg_count,
1120: p_data =>x_message_data,
1121: p_encoded =>FND_API.G_FALSE);
1122: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1123: End;
1124:
1125: END CCT_ICJUMPSTART_PUB;