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

Line 51: -- If(p_opp_rec.lead_source_code is NOT NULL and p_opp_rec.lead_source_code <> FND_API.G_MISS_CHAR)

47: -- Value based parameters should be converted to their equivalent ids.
48: -- Each value should resolve into one and only one id.
49: -- If this condition is not satisfied, API must report an error and assign l_any_errors to TRUE.
50: -- Example: Process Lead Source/Lead Source Code
51: -- If(p_opp_rec.lead_source_code is NOT NULL and p_opp_rec.lead_source_code <> FND_API.G_MISS_CHAR)
52: -- THEN
53: -- p_pvt_opp_rec.lead_source_code := p_opp_rec.lead_source_code;
54: -- IF(p_opp_rec.lead_source is NOT NULL and p_opp_rec.lead_source <> FND_API.G_MISS_CHAR)
55: -- THEN

Line 54: -- IF(p_opp_rec.lead_source is NOT NULL and p_opp_rec.lead_source <> FND_API.G_MISS_CHAR)

50: -- Example: Process Lead Source/Lead Source Code
51: -- If(p_opp_rec.lead_source_code is NOT NULL and p_opp_rec.lead_source_code <> FND_API.G_MISS_CHAR)
52: -- THEN
53: -- p_pvt_opp_rec.lead_source_code := p_opp_rec.lead_source_code;
54: -- IF(p_opp_rec.lead_source is NOT NULL and p_opp_rec.lead_source <> FND_API.G_MISS_CHAR)
55: -- THEN
56: -- IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
57: -- THEN
58: -- FND_MESSAGE.Set_Name('AS','API_ATTRIBUTE_IGNORED');

Line 63: -- ELSIF(p_opp_rec.lead_source is NOT NULL and p_opp_rec.lead_source <> FND_API.G_MISS_CHAR)

59: -- FND_MESSAGE.Set_Token('COLUMN','LEAD_SOURCE',FALSE);
60: -- FND_MSG_PUB.Add;
61: -- END IF;
62: -- END IF;
63: -- ELSIF(p_opp_rec.lead_source is NOT NULL and p_opp_rec.lead_source <> FND_API.G_MISS_CHAR)
64: -- THEN
65: -- OPEN C_Get_Lookup_Code('LEAD_SOURCE', p_opp_rec.lead_source);
66: -- FETCH C_Get_Lookup_Code INTO l_val;
67: -- CLOSE C_Get_Lookup_Code;

Line 120: raise FND_API.G_EXC_ERROR;

116:
117: -- If there is an error in conversion precessing, raise an error.
118: IF l_any_errors
119: THEN
120: raise FND_API.G_EXC_ERROR;
121: END IF;
122:
123: END Convert_RCR_Values_To_Ids;
124:

Line 128: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

124:
125:
126: PROCEDURE Create_rs_cust_relation(
127: P_Api_Version_Number IN NUMBER,
128: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
129: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
130: P_RCR_Rec IN RCR_Rec_Type := G_MISS_RCR_REC,
131: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
132: X_RS_CUST_RELATION_ID OUT NOCOPY NUMBER,

Line 129: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

125:
126: PROCEDURE Create_rs_cust_relation(
127: P_Api_Version_Number IN NUMBER,
128: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
129: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
130: P_RCR_Rec IN RCR_Rec_Type := G_MISS_RCR_REC,
131: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
132: X_RS_CUST_RELATION_ID OUT NOCOPY NUMBER,
133: X_Return_Status OUT NOCOPY VARCHAR2,

Line 147: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

143: -- Standard Start of API savepoint
144: SAVEPOINT CREATE_RS_CUST_RELATION_PUB;
145:
146: -- Standard call to check for call compatibility.
147: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
148: p_api_version_number,
149: l_api_name,
150: G_PKG_NAME)
151: THEN

Line 152: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

148: p_api_version_number,
149: l_api_name,
150: G_PKG_NAME)
151: THEN
152: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
153: END IF;
154:
155:
156: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 157: IF FND_API.to_Boolean( p_init_msg_list )

153: END IF;
154:
155:
156: -- Initialize message list if p_init_msg_list is set to TRUE.
157: IF FND_API.to_Boolean( p_init_msg_list )
158: THEN
159: FND_MSG_PUB.initialize;
160: END IF;
161:

Line 169: x_return_status := FND_API.G_RET_STS_SUCCESS;

165:
166: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Start time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
167:
168: -- Initialize API return status to SUCCESS
169: x_return_status := FND_API.G_RET_STS_SUCCESS;
170:
171: --
172: -- API body
173: --

Line 189: P_Init_Msg_List => FND_API.G_FALSE,

185: -- Calling Private package: Create_RS_CUST_RELATION
186: -- Hint: Primary key needs to be returned
187: CSP_rs_cust_relation_PVT.Create_rs_cust_relation(
188: P_Api_Version_Number => 2.0,
189: P_Init_Msg_List => FND_API.G_FALSE,
190: P_Commit => FND_API.G_FALSE,
191: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
192: P_RCR_Rec => l_pvt_RCR_Rec ,
193: -- Hint: Add detail tables as parameter lists if it's master-detail relationship.

Line 190: P_Commit => FND_API.G_FALSE,

186: -- Hint: Primary key needs to be returned
187: CSP_rs_cust_relation_PVT.Create_rs_cust_relation(
188: P_Api_Version_Number => 2.0,
189: P_Init_Msg_List => FND_API.G_FALSE,
190: P_Commit => FND_API.G_FALSE,
191: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
192: P_RCR_Rec => l_pvt_RCR_Rec ,
193: -- Hint: Add detail tables as parameter lists if it's master-detail relationship.
194: X_RS_CUST_RELATION_ID => x_RS_CUST_RELATION_ID,

Line 191: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,

187: CSP_rs_cust_relation_PVT.Create_rs_cust_relation(
188: P_Api_Version_Number => 2.0,
189: P_Init_Msg_List => FND_API.G_FALSE,
190: P_Commit => FND_API.G_FALSE,
191: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
192: P_RCR_Rec => l_pvt_RCR_Rec ,
193: -- Hint: Add detail tables as parameter lists if it's master-detail relationship.
194: X_RS_CUST_RELATION_ID => x_RS_CUST_RELATION_ID,
195: X_Return_Status => x_return_status,

Line 202: IF x_return_status = FND_API.G_RET_STS_ERROR then

198:
199:
200:
201: -- Check return status from the above procedure call
202: IF x_return_status = FND_API.G_RET_STS_ERROR then
203: raise FND_API.G_EXC_ERROR;
204: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
205: raise FND_API.G_EXC_UNEXPECTED_ERROR;
206: END IF;

Line 203: raise FND_API.G_EXC_ERROR;

199:
200:
201: -- Check return status from the above procedure call
202: IF x_return_status = FND_API.G_RET_STS_ERROR then
203: raise FND_API.G_EXC_ERROR;
204: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
205: raise FND_API.G_EXC_UNEXPECTED_ERROR;
206: END IF;
207:

Line 204: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

200:
201: -- Check return status from the above procedure call
202: IF x_return_status = FND_API.G_RET_STS_ERROR then
203: raise FND_API.G_EXC_ERROR;
204: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
205: raise FND_API.G_EXC_UNEXPECTED_ERROR;
206: END IF;
207:
208: --

Line 205: raise FND_API.G_EXC_UNEXPECTED_ERROR;

201: -- Check return status from the above procedure call
202: IF x_return_status = FND_API.G_RET_STS_ERROR then
203: raise FND_API.G_EXC_ERROR;
204: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
205: raise FND_API.G_EXC_UNEXPECTED_ERROR;
206: END IF;
207:
208: --
209: -- End of API body.

Line 213: IF FND_API.to_Boolean( p_commit )

209: -- End of API body.
210: --
211:
212: -- Standard check for p_commit
213: IF FND_API.to_Boolean( p_commit )
214: THEN
215: COMMIT WORK;
216: END IF;
217:

Line 231: WHEN FND_API.G_EXC_ERROR THEN

227: p_data => x_msg_data
228: );
229:
230: EXCEPTION
231: WHEN FND_API.G_EXC_ERROR THEN
232: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
233: P_API_NAME => L_API_NAME
234: ,P_PKG_NAME => G_PKG_NAME
235: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 241: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

237: ,X_MSG_COUNT => X_MSG_COUNT
238: ,X_MSG_DATA => X_MSG_DATA
239: ,X_RETURN_STATUS => X_RETURN_STATUS);
240:
241: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
242: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
243: P_API_NAME => L_API_NAME
244: ,P_PKG_NAME => G_PKG_NAME
245: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 268: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

264:
265: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
266: PROCEDURE Update_rs_cust_relation(
267: P_Api_Version_Number IN NUMBER,
268: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
269: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
270: P_Identity_Salesforce_Id IN NUMBER := NULL,
271: P_RCR_Rec IN RCR_Rec_Type,
272: X_Return_Status OUT NOCOPY VARCHAR2,

Line 269: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

265: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
266: PROCEDURE Update_rs_cust_relation(
267: P_Api_Version_Number IN NUMBER,
268: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
269: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
270: P_Identity_Salesforce_Id IN NUMBER := NULL,
271: P_RCR_Rec IN RCR_Rec_Type,
272: X_Return_Status OUT NOCOPY VARCHAR2,
273: X_Msg_Count OUT NOCOPY NUMBER,

Line 286: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

282: -- Standard Start of API savepoint
283: SAVEPOINT UPDATE_RS_CUST_RELATION_PUB;
284:
285: -- Standard call to check for call compatibility.
286: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
287: p_api_version_number,
288: l_api_name,
289: G_PKG_NAME)
290: THEN

Line 291: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

287: p_api_version_number,
288: l_api_name,
289: G_PKG_NAME)
290: THEN
291: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
292: END IF;
293:
294:
295: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 296: IF FND_API.to_Boolean( p_init_msg_list )

292: END IF;
293:
294:
295: -- Initialize message list if p_init_msg_list is set to TRUE.
296: IF FND_API.to_Boolean( p_init_msg_list )
297: THEN
298: FND_MSG_PUB.initialize;
299: END IF;
300:

Line 308: x_return_status := FND_API.G_RET_STS_SUCCESS;

304:
305: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Start time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
306:
307: -- Initialize API return status to SUCCESS
308: x_return_status := FND_API.G_RET_STS_SUCCESS;
309:
310: --
311: -- API body
312: --

Line 326: P_Init_Msg_List => FND_API.G_FALSE,

322: );
323:
324: CSP_rs_cust_relation_PVT.Update_rs_cust_relation(
325: P_Api_Version_Number => 2.0,
326: P_Init_Msg_List => FND_API.G_FALSE,
327: P_Commit => p_commit,
328: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
329: P_Identity_Salesforce_Id => p_identity_salesforce_id,
330: P_RCR_Rec => l_pvt_RCR_Rec ,

Line 328: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,

324: CSP_rs_cust_relation_PVT.Update_rs_cust_relation(
325: P_Api_Version_Number => 2.0,
326: P_Init_Msg_List => FND_API.G_FALSE,
327: P_Commit => p_commit,
328: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
329: P_Identity_Salesforce_Id => p_identity_salesforce_id,
330: P_RCR_Rec => l_pvt_RCR_Rec ,
331: X_Return_Status => x_return_status,
332: X_Msg_Count => x_msg_count,

Line 338: IF x_return_status = FND_API.G_RET_STS_ERROR then

334:
335:
336:
337: -- Check return status from the above procedure call
338: IF x_return_status = FND_API.G_RET_STS_ERROR then
339: raise FND_API.G_EXC_ERROR;
340: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
341: raise FND_API.G_EXC_UNEXPECTED_ERROR;
342: END IF;

Line 339: raise FND_API.G_EXC_ERROR;

335:
336:
337: -- Check return status from the above procedure call
338: IF x_return_status = FND_API.G_RET_STS_ERROR then
339: raise FND_API.G_EXC_ERROR;
340: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
341: raise FND_API.G_EXC_UNEXPECTED_ERROR;
342: END IF;
343:

Line 340: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

336:
337: -- Check return status from the above procedure call
338: IF x_return_status = FND_API.G_RET_STS_ERROR then
339: raise FND_API.G_EXC_ERROR;
340: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
341: raise FND_API.G_EXC_UNEXPECTED_ERROR;
342: END IF;
343:
344: --

Line 341: raise FND_API.G_EXC_UNEXPECTED_ERROR;

337: -- Check return status from the above procedure call
338: IF x_return_status = FND_API.G_RET_STS_ERROR then
339: raise FND_API.G_EXC_ERROR;
340: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
341: raise FND_API.G_EXC_UNEXPECTED_ERROR;
342: END IF;
343:
344: --
345: -- End of API body

Line 349: IF FND_API.to_Boolean( p_commit )

345: -- End of API body
346: --
347:
348: -- Standard check for p_commit
349: IF FND_API.to_Boolean( p_commit )
350: THEN
351: COMMIT WORK;
352: END IF;
353:

Line 367: WHEN FND_API.G_EXC_ERROR THEN

363: p_data => x_msg_data
364: );
365:
366: EXCEPTION
367: WHEN FND_API.G_EXC_ERROR THEN
368: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
369: P_API_NAME => L_API_NAME
370: ,P_PKG_NAME => G_PKG_NAME
371: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 377: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

373: ,X_MSG_COUNT => X_MSG_COUNT
374: ,X_MSG_DATA => X_MSG_DATA
375: ,X_RETURN_STATUS => X_RETURN_STATUS);
376:
377: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
378: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
379: P_API_NAME => L_API_NAME
380: ,P_PKG_NAME => G_PKG_NAME
381: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 405: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

401: -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
402: -- The Master delete procedure may not be needed depends on different business requirements.
403: PROCEDURE Delete_rs_cust_relation(
404: P_Api_Version_Number IN NUMBER,
405: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
406: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
407: P_identity_salesforce_id IN NUMBER := NULL,
408: P_RCR_Rec IN RCR_Rec_Type,
409: X_Return_Status OUT NOCOPY VARCHAR2,

Line 406: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

402: -- The Master delete procedure may not be needed depends on different business requirements.
403: PROCEDURE Delete_rs_cust_relation(
404: P_Api_Version_Number IN NUMBER,
405: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
406: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
407: P_identity_salesforce_id IN NUMBER := NULL,
408: P_RCR_Rec IN RCR_Rec_Type,
409: X_Return_Status OUT NOCOPY VARCHAR2,
410: X_Msg_Count OUT NOCOPY NUMBER,

Line 423: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

419: -- Standard Start of API savepoint
420: SAVEPOINT DELETE_RS_CUST_RELATION_PUB;
421:
422: -- Standard call to check for call compatibility.
423: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
424: p_api_version_number,
425: l_api_name,
426: G_PKG_NAME)
427: THEN

Line 428: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

424: p_api_version_number,
425: l_api_name,
426: G_PKG_NAME)
427: THEN
428: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
429: END IF;
430:
431:
432: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 433: IF FND_API.to_Boolean( p_init_msg_list )

429: END IF;
430:
431:
432: -- Initialize message list if p_init_msg_list is set to TRUE.
433: IF FND_API.to_Boolean( p_init_msg_list )
434: THEN
435: FND_MSG_PUB.initialize;
436: END IF;
437:

Line 445: x_return_status := FND_API.G_RET_STS_SUCCESS;

441:
442: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Start time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
443:
444: -- Initialize API return status to SUCCESS
445: x_return_status := FND_API.G_RET_STS_SUCCESS;
446:
447: --
448: -- API body
449: --

Line 463: P_Init_Msg_List => FND_API.G_FALSE,

459: );
460:
461: CSP_rs_cust_relation_PVT.Delete_rs_cust_relation(
462: P_Api_Version_Number => 2.0,
463: P_Init_Msg_List => FND_API.G_FALSE,
464: P_Commit => p_commit,
465: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
466: P_Identity_Salesforce_Id => p_identity_salesforce_id,
467: P_RCR_Rec => l_pvt_RCR_Rec,

Line 465: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,

461: CSP_rs_cust_relation_PVT.Delete_rs_cust_relation(
462: P_Api_Version_Number => 2.0,
463: P_Init_Msg_List => FND_API.G_FALSE,
464: P_Commit => p_commit,
465: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
466: P_Identity_Salesforce_Id => p_identity_salesforce_id,
467: P_RCR_Rec => l_pvt_RCR_Rec,
468: X_Return_Status => x_return_status,
469: X_Msg_Count => x_msg_count,

Line 474: IF x_return_status = FND_API.G_RET_STS_ERROR then

470: X_Msg_Data => x_msg_data);
471:
472:
473: -- Check return status from the above procedure call
474: IF x_return_status = FND_API.G_RET_STS_ERROR then
475: raise FND_API.G_EXC_ERROR;
476: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
477: raise FND_API.G_EXC_UNEXPECTED_ERROR;
478: END IF;

Line 475: raise FND_API.G_EXC_ERROR;

471:
472:
473: -- Check return status from the above procedure call
474: IF x_return_status = FND_API.G_RET_STS_ERROR then
475: raise FND_API.G_EXC_ERROR;
476: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
477: raise FND_API.G_EXC_UNEXPECTED_ERROR;
478: END IF;
479:

Line 476: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

472:
473: -- Check return status from the above procedure call
474: IF x_return_status = FND_API.G_RET_STS_ERROR then
475: raise FND_API.G_EXC_ERROR;
476: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
477: raise FND_API.G_EXC_UNEXPECTED_ERROR;
478: END IF;
479:
480: --

Line 477: raise FND_API.G_EXC_UNEXPECTED_ERROR;

473: -- Check return status from the above procedure call
474: IF x_return_status = FND_API.G_RET_STS_ERROR then
475: raise FND_API.G_EXC_ERROR;
476: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
477: raise FND_API.G_EXC_UNEXPECTED_ERROR;
478: END IF;
479:
480: --
481: -- End of API body

Line 485: IF FND_API.to_Boolean( p_commit )

481: -- End of API body
482: --
483:
484: -- Standard check for p_commit
485: IF FND_API.to_Boolean( p_commit )
486: THEN
487: COMMIT WORK;
488: END IF;
489:

Line 504: WHEN FND_API.G_EXC_ERROR THEN

500: );
501:
502:
503: EXCEPTION
504: WHEN FND_API.G_EXC_ERROR THEN
505: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
506: P_API_NAME => L_API_NAME
507: ,P_PKG_NAME => G_PKG_NAME
508: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 514: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

510: ,X_MSG_COUNT => X_MSG_COUNT
511: ,X_MSG_DATA => X_MSG_DATA
512: ,X_RETURN_STATUS => X_RETURN_STATUS);
513:
514: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
515: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
516: P_API_NAME => L_API_NAME
517: ,P_PKG_NAME => G_PKG_NAME
518: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 540: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

536:
537:
538: PROCEDURE Get_rs_cust_relation(
539: P_Api_Version_Number IN NUMBER,
540: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
541: P_identity_salesforce_id IN NUMBER := NULL,
542: P_RCR_Rec IN CSP_rs_cust_relation_PUB.RCR_Rec_Type,
543: -- Hint: Add list of bind variables here
544: p_rec_requested IN NUMBER := G_DEFAULT_NUM_REC_FETCH,

Line 546: p_return_tot_count IN NUMBER := FND_API.G_FALSE,

542: P_RCR_Rec IN CSP_rs_cust_relation_PUB.RCR_Rec_Type,
543: -- Hint: Add list of bind variables here
544: p_rec_requested IN NUMBER := G_DEFAULT_NUM_REC_FETCH,
545: p_start_rec_prt IN NUMBER := 1,
546: p_return_tot_count IN NUMBER := FND_API.G_FALSE,
547: -- Hint: user defined record type
548: p_order_by_rec IN CSP_rs_cust_relation_PUB.RCR_sort_rec_type,
549: x_return_status OUT NOCOPY VARCHAR2,
550: x_msg_count OUT NOCOPY NUMBER,

Line 568: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

564: -- Standard Start of API savepoint
565: SAVEPOINT GET_RS_CUST_RELATION_PUB;
566:
567: -- Standard call to check for call compatibility.
568: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
569: p_api_version_number,
570: l_api_name,
571: G_PKG_NAME)
572: THEN

Line 573: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

569: p_api_version_number,
570: l_api_name,
571: G_PKG_NAME)
572: THEN
573: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
574: END IF;
575:
576:
577: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 578: IF FND_API.to_Boolean( p_init_msg_list )

574: END IF;
575:
576:
577: -- Initialize message list if p_init_msg_list is set to TRUE.
578: IF FND_API.to_Boolean( p_init_msg_list )
579: THEN
580: FND_MSG_PUB.initialize;
581: END IF;
582:

Line 590: x_return_status := FND_API.G_RET_STS_SUCCESS;

586:
587: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Start time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
588:
589: -- Initialize API return status to SUCCESS
590: x_return_status := FND_API.G_RET_STS_SUCCESS;
591:
592: --
593: -- API body
594: --

Line 600: P_Init_Msg_List => FND_API.G_FALSE,

596: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Public API: - Calling PVT.Get_RS_CUST_RELATION');
597: /*
598: CSP_rs_cust_relation_PVT.Get_rs_cust_relation(
599: P_Api_Version_Number => 2.0,
600: P_Init_Msg_List => FND_API.G_FALSE,
601: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
602: P_Identity_Salesforce_id => p_identity_salesforce_id,
603: P_RCR_Rec => P_RCR_Rec,
604: p_rec_requested => p_rec_requested,

Line 601: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

597: /*
598: CSP_rs_cust_relation_PVT.Get_rs_cust_relation(
599: P_Api_Version_Number => 2.0,
600: P_Init_Msg_List => FND_API.G_FALSE,
601: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
602: P_Identity_Salesforce_id => p_identity_salesforce_id,
603: P_RCR_Rec => P_RCR_Rec,
604: p_rec_requested => p_rec_requested,
605: p_start_rec_prt => p_start_rec_prt,

Line 623: IF x_return_status = FND_API.G_RET_STS_ERROR then

619:
620:
621:
622: -- Check return status from the above procedure call
623: IF x_return_status = FND_API.G_RET_STS_ERROR then
624: raise FND_API.G_EXC_ERROR;
625: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
626: raise FND_API.G_EXC_UNEXPECTED_ERROR;
627: END IF;

Line 624: raise FND_API.G_EXC_ERROR;

620:
621:
622: -- Check return status from the above procedure call
623: IF x_return_status = FND_API.G_RET_STS_ERROR then
624: raise FND_API.G_EXC_ERROR;
625: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
626: raise FND_API.G_EXC_UNEXPECTED_ERROR;
627: END IF;
628: */

Line 625: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

621:
622: -- Check return status from the above procedure call
623: IF x_return_status = FND_API.G_RET_STS_ERROR then
624: raise FND_API.G_EXC_ERROR;
625: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
626: raise FND_API.G_EXC_UNEXPECTED_ERROR;
627: END IF;
628: */
629: --

Line 626: raise FND_API.G_EXC_UNEXPECTED_ERROR;

622: -- Check return status from the above procedure call
623: IF x_return_status = FND_API.G_RET_STS_ERROR then
624: raise FND_API.G_EXC_ERROR;
625: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
626: raise FND_API.G_EXC_UNEXPECTED_ERROR;
627: END IF;
628: */
629: --
630: -- End of API body

Line 645: WHEN FND_API.G_EXC_ERROR THEN

641: p_data => x_msg_data
642: );
643:
644: EXCEPTION
645: WHEN FND_API.G_EXC_ERROR THEN
646: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
647: P_API_NAME => L_API_NAME
648: ,P_PKG_NAME => G_PKG_NAME
649: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 655: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

651: ,X_MSG_COUNT => X_MSG_COUNT
652: ,X_MSG_DATA => X_MSG_DATA
653: ,X_RETURN_STATUS => X_RETURN_STATUS);
654:
655: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
656: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
657: P_API_NAME => L_API_NAME
658: ,P_PKG_NAME => G_PKG_NAME
659: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR