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

Line 73: raise FND_API.G_EXC_ERROR;

69: -- If there was an error in processing the row, then raise an error
70: --
71: IF l_any_errors
72: THEN
73: raise FND_API.G_EXC_ERROR;
74: END IF;
75:
76: END Convert_Debrief_Value_To_Id;
77:

Line 109: p_return_status := FND_API.G_RET_STS_SUCCESS;

105: l_interest_code_id NUMBER;
106: l_secondary_interest_code_id NUMBER;
107: BEGIN
108:
109: p_return_status := FND_API.G_RET_STS_SUCCESS;
110:
111: -- Initialize Out Variables
112: p_out_interest_type_id := NULL;
113: p_out_primary_interest_code_id := NULL;

Line 119: p_interest_type_id <> FND_API.G_MISS_NUM)

115:
116: -- Convert Interest Type
117: --
118: IF (p_interest_type_id is not NULL and
119: p_interest_type_id <> FND_API.G_MISS_NUM)
120: THEN
121: p_out_interest_type_id := p_interest_type_id;
122: l_interest_type_id := p_interest_type_id;
123:

Line 125: p_interest_type <> FND_API.G_MISS_CHAR)

121: p_out_interest_type_id := p_interest_type_id;
122: l_interest_type_id := p_interest_type_id;
123:
124: IF (p_interest_type is not NULL and
125: p_interest_type <> FND_API.G_MISS_CHAR)
126: THEN
127: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
128: THEN
129: FND_MESSAGE.Set_Name ('CSF', 'API_ATTRIBUTE_IGNORED');

Line 136: p_interest_type <> FND_API.G_MISS_CHAR)

132: END IF;
133: END IF;
134:
135: ELSIF (p_interest_type is not NULL and
136: p_interest_type <> FND_API.G_MISS_CHAR)
137: THEN
138: OPEN C_Get_Int_Type ( p_interest_type );
139: FETCH C_Get_Int_Type INTO l_interest_type_id;
140: CLOSE C_Get_Int_Type;

Line 152: raise FND_API.G_EXC_ERROR;

148: FND_MESSAGE.Set_Token('VALUE', p_interest_type, FALSE);
149: FND_MSG_PUB.Add;
150: END IF;
151:
152: raise FND_API.G_EXC_ERROR;
153:
154: ELSE
155: p_out_interest_type_id := l_interest_type_id;
156: END IF;

Line 168: raise FND_API.G_EXC_ERROR;

164: FND_MESSAGE.Set_Token ('COLUMN', 'INTEREST_TYPE', FALSE);
165: FND_MSG_PUB.Add;
166: END IF;
167:
168: raise FND_API.G_EXC_ERROR;
169: END IF;
170:
171: -- Convert Primary Code
172: --

Line 174: p_primary_interest_code_id <> FND_API.G_MISS_NUM)

170:
171: -- Convert Primary Code
172: --
173: IF (p_primary_interest_code_id is not NULL and
174: p_primary_interest_code_id <> FND_API.G_MISS_NUM)
175: THEN
176: p_out_primary_interest_code_id := p_primary_interest_code_id;
177: l_interest_code_id := p_primary_interest_code_id;
178:

Line 180: p_primary_interest_code <> FND_API.G_MISS_CHAR)

176: p_out_primary_interest_code_id := p_primary_interest_code_id;
177: l_interest_code_id := p_primary_interest_code_id;
178:
179: IF (p_primary_interest_code is not NULL and
180: p_primary_interest_code <> FND_API.G_MISS_CHAR)
181: THEN
182: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
183: THEN
184: FND_MESSAGE.Set_Name ('CSF','API_ATTRIBUTE_IGNORED');

Line 191: p_primary_interest_code <> FND_API.G_MISS_CHAR)

187: END IF;
188: END IF;
189:
190: ELSIF (p_primary_interest_code is not NULL and
191: p_primary_interest_code <> FND_API.G_MISS_CHAR)
192: THEN
193: OPEN C_Get_Int_Code ( p_primary_interest_code,
194: l_interest_type_id );
195: FETCH C_Get_Int_Code INTO l_interest_code_id;

Line 208: p_return_status := FND_API.G_RET_STS_ERROR;

204: FND_MESSAGE.Set_Token('VALUE', p_primary_interest_code, FALSE);
205: FND_MSG_PUB.Add;
206: END IF;
207:
208: p_return_status := FND_API.G_RET_STS_ERROR;
209:
210: ELSE
211: p_out_primary_interest_code_id := l_interest_code_id;
212: END IF;

Line 218: p_secondary_interest_code_id <> FND_API.G_MISS_NUM)

214:
215: -- Convert Secondary Code
216: --
217: IF (p_secondary_interest_code_id is not NULL and
218: p_secondary_interest_code_id <> FND_API.G_MISS_NUM)
219: THEN
220: p_out_second_interest_code_id := p_secondary_interest_code_id;
221: l_secondary_interest_code_id := p_secondary_interest_code_id;
222:

Line 224: p_secondary_interest_code <> FND_API.G_MISS_CHAR)

220: p_out_second_interest_code_id := p_secondary_interest_code_id;
221: l_secondary_interest_code_id := p_secondary_interest_code_id;
222:
223: IF (p_secondary_interest_code is not NULL and
224: p_secondary_interest_code <> FND_API.G_MISS_CHAR)
225: THEN
226: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
227: THEN
228: FND_MESSAGE.Set_Name ('CSF', 'API_ATTRIBUTE_IGNORED');

Line 235: p_secondary_interest_code <> FND_API.G_MISS_CHAR)

231: END IF;
232: END IF;
233:
234: ELSIF (p_secondary_interest_code is not NULL and
235: p_secondary_interest_code <> FND_API.G_MISS_CHAR)
236: THEN
237: OPEN C_Get_Int_Code ( p_secondary_interest_code,
238: l_interest_type_id );
239: FETCH C_Get_Int_Code INTO l_secondary_interest_code_id;

Line 251: p_return_status := FND_API.G_RET_STS_ERROR;

247: FND_MESSAGE.Set_Token ('COLUMN', 'SECONDARY_INTEREST_CODE', FALSE);
248: FND_MESSAGE.Set_Token('VALUE', p_secondary_interest_code, FALSE);
249: FND_MSG_PUB.Add;
250: END IF;
251: p_return_status := FND_API.G_RET_STS_ERROR;
252:
253: ELSE
254: p_out_second_interest_code_id := l_secondary_interest_code_id;
255:

Line 385: raise FND_API.G_EXC_ERROR;

381:
382:
383: IF l_any_errors
384: THEN
385: raise FND_API.G_EXC_ERROR;
386: END IF;
387:
388: EXCEPTION
389: WHEN OTHERS THEN

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

398: END Conv_DEBRIEF_LINE_ValToId;
399:
400: PROCEDURE Create_Debrief(
401: P_Api_Version_Number IN NUMBER,
402: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
403: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
404: P_DEBRIEF_Rec IN DEBRIEF_Rec_Type := G_MISS_DEBRIEF_REC,
405: P_DEBRIEF_LINE_tbl IN DEBRIEF_LINE_tbl_type ,
406: -- DEFAULT G_MISS_DEBRIEF_LINE_tbl,

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

399:
400: PROCEDURE Create_Debrief(
401: P_Api_Version_Number IN NUMBER,
402: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
403: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
404: P_DEBRIEF_Rec IN DEBRIEF_Rec_Type := G_MISS_DEBRIEF_REC,
405: P_DEBRIEF_LINE_tbl IN DEBRIEF_LINE_tbl_type ,
406: -- DEFAULT G_MISS_DEBRIEF_LINE_tbl,
407: X_DEBRIEF_HEADER_ID OUT NOCOPY NUMBER,

Line 425: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

421: BEGIN
422: SAVEPOINT CREATE_DEBRIEF_PUB;
423:
424: -- Standard call to check for call compatibility.
425: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
426: p_api_version_number,
427: l_api_name,
428: G_PKG_NAME)
429: THEN

Line 430: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 434: IF FND_API.to_Boolean( p_init_msg_list )

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

Line 440: x_return_status := FND_API.G_RET_STS_SUCCESS;

436: FND_MSG_PUB.initialize;
437: END IF;
438:
439: -- Initialize API return status to SUCCESS
440: x_return_status := FND_API.G_RET_STS_SUCCESS;
441:
442: -- API body
443: --
444: -- Convert the values to ids

Line 458: P_Init_Msg_List => FND_API.G_FALSE,

454:
455: -- Calling Private package: Create_DEBRIEF
456: CSF_DEBRIEF_PVT.Create_debrief(
457: P_Api_Version_Number => 1.0,
458: P_Init_Msg_List => FND_API.G_FALSE,
459: P_Commit => FND_API.G_FALSE,
460: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
461: P_DEBRIEF_Rec => l_pvt_DEBRIEF_Rec ,
462: P_DEBRIEF_LINE_tbl => l_pvt_DEBRIEF_LINE_tbl,

Line 459: P_Commit => FND_API.G_FALSE,

455: -- Calling Private package: Create_DEBRIEF
456: CSF_DEBRIEF_PVT.Create_debrief(
457: P_Api_Version_Number => 1.0,
458: P_Init_Msg_List => FND_API.G_FALSE,
459: P_Commit => FND_API.G_FALSE,
460: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
461: P_DEBRIEF_Rec => l_pvt_DEBRIEF_Rec ,
462: P_DEBRIEF_LINE_tbl => l_pvt_DEBRIEF_LINE_tbl,
463: X_DEBRIEF_HEADER_ID => x_DEBRIEF_HEADER_ID,

Line 460: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,

456: CSF_DEBRIEF_PVT.Create_debrief(
457: P_Api_Version_Number => 1.0,
458: P_Init_Msg_List => FND_API.G_FALSE,
459: P_Commit => FND_API.G_FALSE,
460: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
461: P_DEBRIEF_Rec => l_pvt_DEBRIEF_Rec ,
462: P_DEBRIEF_LINE_tbl => l_pvt_DEBRIEF_LINE_tbl,
463: X_DEBRIEF_HEADER_ID => x_DEBRIEF_HEADER_ID,
464: X_Return_Status => x_return_status,

Line 471: IF x_return_status = FND_API.G_RET_STS_ERROR then

467:
468:
469: -- End of API body.
470: --
471: IF x_return_status = FND_API.G_RET_STS_ERROR then
472: raise FND_API.G_EXC_ERROR;
473: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
474: raise FND_API.G_EXC_UNEXPECTED_ERROR;
475: END IF;

Line 472: raise FND_API.G_EXC_ERROR;

468:
469: -- End of API body.
470: --
471: IF x_return_status = FND_API.G_RET_STS_ERROR then
472: raise FND_API.G_EXC_ERROR;
473: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
474: raise FND_API.G_EXC_UNEXPECTED_ERROR;
475: END IF;
476:

Line 473: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

469: -- End of API body.
470: --
471: IF x_return_status = FND_API.G_RET_STS_ERROR then
472: raise FND_API.G_EXC_ERROR;
473: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
474: raise FND_API.G_EXC_UNEXPECTED_ERROR;
475: END IF;
476:
477: IF FND_API.to_Boolean( p_commit )

Line 474: raise FND_API.G_EXC_UNEXPECTED_ERROR;

470: --
471: IF x_return_status = FND_API.G_RET_STS_ERROR then
472: raise FND_API.G_EXC_ERROR;
473: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
474: raise FND_API.G_EXC_UNEXPECTED_ERROR;
475: END IF;
476:
477: IF FND_API.to_Boolean( p_commit )
478: THEN

Line 477: IF FND_API.to_Boolean( p_commit )

473: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
474: raise FND_API.G_EXC_UNEXPECTED_ERROR;
475: END IF;
476:
477: IF FND_API.to_Boolean( p_commit )
478: THEN
479: COMMIT WORK;
480: END IF;
481:

Line 489: WHEN FND_API.G_EXC_ERROR THEN

485: );
486:
487:
488: EXCEPTION
489: WHEN FND_API.G_EXC_ERROR THEN
490:
491: ROLLBACK TO CREATE_DEBRIEF_PUB;
492: x_return_status := FND_API.G_RET_STS_ERROR;
493: FND_MSG_PUB.Count_And_Get (

Line 492: x_return_status := FND_API.G_RET_STS_ERROR;

488: EXCEPTION
489: WHEN FND_API.G_EXC_ERROR THEN
490:
491: ROLLBACK TO CREATE_DEBRIEF_PUB;
492: x_return_status := FND_API.G_RET_STS_ERROR;
493: FND_MSG_PUB.Count_And_Get (
494: P_COUNT => X_MSG_COUNT
495: ,P_DATA => X_MSG_DATA);
496: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 496: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

492: x_return_status := FND_API.G_RET_STS_ERROR;
493: FND_MSG_PUB.Count_And_Get (
494: P_COUNT => X_MSG_COUNT
495: ,P_DATA => X_MSG_DATA);
496: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
497: ROLLBACK TO CREATE_DEBRIEF_PUB;
498:
499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
500: FND_MSG_PUB.Count_And_Get (

Line 499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

495: ,P_DATA => X_MSG_DATA);
496: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
497: ROLLBACK TO CREATE_DEBRIEF_PUB;
498:
499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
500: FND_MSG_PUB.Count_And_Get (
501: P_COUNT => X_MSG_COUNT
502: ,P_DATA => X_MSG_DATA);
503: WHEN OTHERS THEN

Line 506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

502: ,P_DATA => X_MSG_DATA);
503: WHEN OTHERS THEN
504: ROLLBACK TO CREATE_DEBRIEF_PUB;
505:
506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
507: IF FND_MSG_PUB.Check_Msg_Level
508: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
509: THEN
510: FND_MSG_PUB.Add_Exc_Msg (

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

518: End Create_debrief;
519:
520: PROCEDURE Update_debrief(
521: P_Api_Version_Number IN NUMBER,
522: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
523: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
524: P_DEBRIEF_Rec IN DEBRIEF_Rec_Type ,
525: X_Return_Status OUT NOCOPY VARCHAR2,
526: X_Msg_Count OUT NOCOPY NUMBER,

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

519:
520: PROCEDURE Update_debrief(
521: P_Api_Version_Number IN NUMBER,
522: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
523: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
524: P_DEBRIEF_Rec IN DEBRIEF_Rec_Type ,
525: X_Return_Status OUT NOCOPY VARCHAR2,
526: X_Msg_Count OUT NOCOPY NUMBER,
527: X_Msg_Data OUT NOCOPY VARCHAR2

Line 538: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

534: -- Standard Start of API savepoint
535: SAVEPOINT UPDATE_DEBRIEF_PUB;
536:
537: -- Standard call to check for call compatibility.
538: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
539: p_api_version_number,
540: l_api_name,
541: G_PKG_NAME)
542: THEN

Line 543: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

539: p_api_version_number,
540: l_api_name,
541: G_PKG_NAME)
542: THEN
543: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
544: END IF;
545:
546: -- Initialize message list if p_init_msg_list is set to TRUE.
547: IF FND_API.to_Boolean( p_init_msg_list )

Line 547: IF FND_API.to_Boolean( p_init_msg_list )

543: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
544: END IF;
545:
546: -- Initialize message list if p_init_msg_list is set to TRUE.
547: IF FND_API.to_Boolean( p_init_msg_list )
548: THEN
549: FND_MSG_PUB.initialize;
550: END IF;
551:

Line 553: x_return_status := FND_API.G_RET_STS_SUCCESS;

549: FND_MSG_PUB.initialize;
550: END IF;
551:
552: -- Initialize API return status to SUCCESS
553: x_return_status := FND_API.G_RET_STS_SUCCESS;
554:
555: -- API body
556: -- Convert the values to ids
557: --

Line 565: P_Init_Msg_List => FND_API.G_FALSE,

561: );
562:
563: CSF_DEBRIEF_PVT.Update_debrief(
564: P_Api_Version_Number => 1.0,
565: P_Init_Msg_List => FND_API.G_FALSE,
566: P_Commit => p_commit,
567: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
568: P_DEBRIEF_Rec => l_pvt_DEBRIEF_Rec ,
569: X_Return_Status => x_return_status,

Line 567: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,

563: CSF_DEBRIEF_PVT.Update_debrief(
564: P_Api_Version_Number => 1.0,
565: P_Init_Msg_List => FND_API.G_FALSE,
566: P_Commit => p_commit,
567: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
568: P_DEBRIEF_Rec => l_pvt_DEBRIEF_Rec ,
569: X_Return_Status => x_return_status,
570: X_Msg_Count => x_msg_count,
571: X_Msg_Data => x_msg_data);

Line 574: IF x_return_status = FND_API.G_RET_STS_ERROR then

570: X_Msg_Count => x_msg_count,
571: X_Msg_Data => x_msg_data);
572:
573: -- Check return status from the above procedure call
574: IF x_return_status = FND_API.G_RET_STS_ERROR then
575: raise FND_API.G_EXC_ERROR;
576: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
577: raise FND_API.G_EXC_UNEXPECTED_ERROR;
578: END IF;

Line 575: raise FND_API.G_EXC_ERROR;

571: X_Msg_Data => x_msg_data);
572:
573: -- Check return status from the above procedure call
574: IF x_return_status = FND_API.G_RET_STS_ERROR then
575: raise FND_API.G_EXC_ERROR;
576: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
577: raise FND_API.G_EXC_UNEXPECTED_ERROR;
578: END IF;
579: -- End of API body

Line 576: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

572:
573: -- Check return status from the above procedure call
574: IF x_return_status = FND_API.G_RET_STS_ERROR then
575: raise FND_API.G_EXC_ERROR;
576: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
577: raise FND_API.G_EXC_UNEXPECTED_ERROR;
578: END IF;
579: -- End of API body
580: --

Line 577: raise FND_API.G_EXC_UNEXPECTED_ERROR;

573: -- Check return status from the above procedure call
574: IF x_return_status = FND_API.G_RET_STS_ERROR then
575: raise FND_API.G_EXC_ERROR;
576: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
577: raise FND_API.G_EXC_UNEXPECTED_ERROR;
578: END IF;
579: -- End of API body
580: --
581: IF FND_API.to_Boolean( p_commit )

Line 581: IF FND_API.to_Boolean( p_commit )

577: raise FND_API.G_EXC_UNEXPECTED_ERROR;
578: END IF;
579: -- End of API body
580: --
581: IF FND_API.to_Boolean( p_commit )
582: THEN
583: COMMIT WORK;
584: END IF;
585:

Line 592: WHEN FND_API.G_EXC_ERROR THEN

588: p_data => x_msg_data
589: );
590:
591: EXCEPTION
592: WHEN FND_API.G_EXC_ERROR THEN
593: ROLLBACK TO UPDATE_DEBRIEF_PUB;
594: x_return_status := FND_API.G_RET_STS_ERROR;
595: FND_MSG_PUB.Count_And_Get (
596: P_COUNT => X_MSG_COUNT

Line 594: x_return_status := FND_API.G_RET_STS_ERROR;

590:
591: EXCEPTION
592: WHEN FND_API.G_EXC_ERROR THEN
593: ROLLBACK TO UPDATE_DEBRIEF_PUB;
594: x_return_status := FND_API.G_RET_STS_ERROR;
595: FND_MSG_PUB.Count_And_Get (
596: P_COUNT => X_MSG_COUNT
597: ,P_DATA => X_MSG_DATA);
598:

Line 599: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

595: FND_MSG_PUB.Count_And_Get (
596: P_COUNT => X_MSG_COUNT
597: ,P_DATA => X_MSG_DATA);
598:
599: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
600: ROLLBACK TO UPDATE_DEBRIEF_PUB;
601: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
602: FND_MSG_PUB.Count_And_Get (
603: P_COUNT => X_MSG_COUNT

Line 601: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

597: ,P_DATA => X_MSG_DATA);
598:
599: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
600: ROLLBACK TO UPDATE_DEBRIEF_PUB;
601: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
602: FND_MSG_PUB.Count_And_Get (
603: P_COUNT => X_MSG_COUNT
604: ,P_DATA => X_MSG_DATA);
605:

Line 608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

604: ,P_DATA => X_MSG_DATA);
605:
606: WHEN OTHERS THEN
607: ROLLBACK TO UPDATE_DEBRIEF_PUB;
608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
609: IF FND_MSG_PUB.Check_Msg_Level
610: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
611: THEN
612: FND_MSG_PUB.Add_Exc_Msg (

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

621: End Update_debrief;
622:
623: PROCEDURE Create_debrief_lines(
624: P_Api_Version_Number IN NUMBER,
625: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
626: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
627: P_Upd_tskassgnstatus IN VARCHAR2 ,
628: P_Task_Assignment_status IN VARCHAR2 ,
629: P_DEBRIEF_LINE_Tbl IN DEBRIEF_LINE_Tbl_Type := G_MISS_DEBRIEF_LINE_Tbl,

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

622:
623: PROCEDURE Create_debrief_lines(
624: P_Api_Version_Number IN NUMBER,
625: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
626: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
627: P_Upd_tskassgnstatus IN VARCHAR2 ,
628: P_Task_Assignment_status IN VARCHAR2 ,
629: P_DEBRIEF_LINE_Tbl IN DEBRIEF_LINE_Tbl_Type := G_MISS_DEBRIEF_LINE_Tbl,
630: P_DEBRIEF_HEADER_ID IN NUMBER,

Line 647: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

643: -- Standard Start of API savepoint
644: SAVEPOINT CREATE_DEBRIEF_LINE_PUB;
645:
646: -- Standard call to check for call compatibility.
647: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
648: p_api_version_number,
649: l_api_name,
650: G_PKG_NAME)
651: THEN

Line 652: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

648: p_api_version_number,
649: l_api_name,
650: G_PKG_NAME)
651: THEN
652: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
653: END IF;
654:
655: -- Initialize message list if p_init_msg_list is set to TRUE.
656: IF FND_API.to_Boolean( p_init_msg_list )

Line 656: IF FND_API.to_Boolean( p_init_msg_list )

652: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
653: END IF;
654:
655: -- Initialize message list if p_init_msg_list is set to TRUE.
656: IF FND_API.to_Boolean( p_init_msg_list )
657: THEN FND_MSG_PUB.initialize; END IF;
658:
659: -- Initialize API return status to SUCCESS
660: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 660: x_return_status := FND_API.G_RET_STS_SUCCESS;

656: IF FND_API.to_Boolean( p_init_msg_list )
657: THEN FND_MSG_PUB.initialize; END IF;
658:
659: -- Initialize API return status to SUCCESS
660: x_return_status := FND_API.G_RET_STS_SUCCESS;
661:
662: -- API body
663: --
664: -- Convert the values to ids

Line 675: P_Init_Msg_List => FND_API.G_FALSE,

671: -- Calling Private package: Create_DEBRIEF_LINE
672:
673: CSF_debrief_PVT.Create_debrief_lines(
674: P_Api_Version_Number => 1.0,
675: P_Init_Msg_List => FND_API.G_FALSE,
676: P_Commit => FND_API.G_FALSE,
677: P_Upd_tskassgnstatus => P_Upd_tskassgnstatus,
678: P_Task_Assignment_status => P_Task_Assignment_status ,
679: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,

Line 676: P_Commit => FND_API.G_FALSE,

672:
673: CSF_debrief_PVT.Create_debrief_lines(
674: P_Api_Version_Number => 1.0,
675: P_Init_Msg_List => FND_API.G_FALSE,
676: P_Commit => FND_API.G_FALSE,
677: P_Upd_tskassgnstatus => P_Upd_tskassgnstatus,
678: P_Task_Assignment_status => P_Task_Assignment_status ,
679: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
680: P_DEBRIEF_LINE_tbl => l_pvt_DEBRIEF_LINE_tbl,

Line 679: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,

675: P_Init_Msg_List => FND_API.G_FALSE,
676: P_Commit => FND_API.G_FALSE,
677: P_Upd_tskassgnstatus => P_Upd_tskassgnstatus,
678: P_Task_Assignment_status => P_Task_Assignment_status ,
679: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
680: P_DEBRIEF_LINE_tbl => l_pvt_DEBRIEF_LINE_tbl,
681: P_DEBRIEF_HEADER_ID => P_DEBRIEF_HEADER_ID,
682: P_SOURCE_OBJECT_TYPE_CODE => P_SOURCE_OBJECT_TYPE_CODE,
683: X_Return_Status => x_return_status,

Line 688: IF x_return_status = FND_API.G_RET_STS_ERROR then

684: X_Msg_Count => x_msg_count,
685: X_Msg_Data => x_msg_data);
686:
687: -- Check return status from the above procedure call
688: IF x_return_status = FND_API.G_RET_STS_ERROR then
689: raise FND_API.G_EXC_ERROR;
690: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
691: raise FND_API.G_EXC_UNEXPECTED_ERROR;
692: END IF;

Line 689: raise FND_API.G_EXC_ERROR;

685: X_Msg_Data => x_msg_data);
686:
687: -- Check return status from the above procedure call
688: IF x_return_status = FND_API.G_RET_STS_ERROR then
689: raise FND_API.G_EXC_ERROR;
690: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
691: raise FND_API.G_EXC_UNEXPECTED_ERROR;
692: END IF;
693:

Line 690: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

686:
687: -- Check return status from the above procedure call
688: IF x_return_status = FND_API.G_RET_STS_ERROR then
689: raise FND_API.G_EXC_ERROR;
690: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
691: raise FND_API.G_EXC_UNEXPECTED_ERROR;
692: END IF;
693:
694: -- End of API body.

Line 691: raise FND_API.G_EXC_UNEXPECTED_ERROR;

687: -- Check return status from the above procedure call
688: IF x_return_status = FND_API.G_RET_STS_ERROR then
689: raise FND_API.G_EXC_ERROR;
690: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
691: raise FND_API.G_EXC_UNEXPECTED_ERROR;
692: END IF;
693:
694: -- End of API body.
695: --

Line 696: IF FND_API.to_Boolean( p_commit )

692: END IF;
693:
694: -- End of API body.
695: --
696: IF FND_API.to_Boolean( p_commit )
697: THEN
698: COMMIT WORK;
699: END IF;
700:

Line 707: WHEN FND_API.G_EXC_ERROR THEN

703: p_data => x_msg_data
704: );
705:
706: EXCEPTION
707: WHEN FND_API.G_EXC_ERROR THEN
708: ROLLBACK TO CREATE_DEBRIEF_LINE_PUB;
709: x_return_status := FND_API.G_RET_STS_ERROR;
710: FND_MSG_PUB.Count_And_Get (
711: P_COUNT => X_MSG_COUNT

Line 709: x_return_status := FND_API.G_RET_STS_ERROR;

705:
706: EXCEPTION
707: WHEN FND_API.G_EXC_ERROR THEN
708: ROLLBACK TO CREATE_DEBRIEF_LINE_PUB;
709: x_return_status := FND_API.G_RET_STS_ERROR;
710: FND_MSG_PUB.Count_And_Get (
711: P_COUNT => X_MSG_COUNT
712: ,P_DATA => X_MSG_DATA);
713:

Line 714: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

710: FND_MSG_PUB.Count_And_Get (
711: P_COUNT => X_MSG_COUNT
712: ,P_DATA => X_MSG_DATA);
713:
714: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
715: ROLLBACK TO CREATE_DEBRIEF_LINE_PUB;
716: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
717: FND_MSG_PUB.Count_And_Get (
718: P_COUNT => X_MSG_COUNT

Line 716: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

712: ,P_DATA => X_MSG_DATA);
713:
714: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
715: ROLLBACK TO CREATE_DEBRIEF_LINE_PUB;
716: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
717: FND_MSG_PUB.Count_And_Get (
718: P_COUNT => X_MSG_COUNT
719: ,P_DATA => X_MSG_DATA);
720:

Line 723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

719: ,P_DATA => X_MSG_DATA);
720:
721: WHEN OTHERS THEN
722: ROLLBACK TO CREATE_DEBRIEF_LINE_PUB;
723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
724: IF FND_MSG_PUB.Check_Msg_Level
725: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
726: THEN
727: FND_MSG_PUB.Add_Exc_Msg (

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

736: End Create_debrief_lines;
737:
738: PROCEDURE Update_debrief_line(
739: P_Api_Version_Number IN NUMBER,
740: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
741: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
742: P_Upd_tskassgnstatus IN VARCHAR2 ,
743: P_Task_Assignment_status IN VARCHAR2 ,
744: P_DEBRIEF_LINE_Rec IN DEBRIEF_LINE_Rec_Type,

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

737:
738: PROCEDURE Update_debrief_line(
739: P_Api_Version_Number IN NUMBER,
740: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
741: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
742: P_Upd_tskassgnstatus IN VARCHAR2 ,
743: P_Task_Assignment_status IN VARCHAR2 ,
744: P_DEBRIEF_LINE_Rec IN DEBRIEF_LINE_Rec_Type,
745: X_Return_Status OUT NOCOPY VARCHAR2,

Line 760: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

756: -- Standard Start of API savepoint
757: SAVEPOINT UPDATE_DEBRIEF_LINE_PUB;
758:
759: -- Standard call to check for call compatibility.
760: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
761: p_api_version_number,
762: l_api_name,
763: G_PKG_NAME)
764: THEN

Line 765: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

761: p_api_version_number,
762: l_api_name,
763: G_PKG_NAME)
764: THEN
765: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
766: END IF;
767: -- dbms_output.put_line ( 'step 3 PUB');
768: -- Initialize message list if p_init_msg_list is set to TRUE.
769: IF FND_API.to_Boolean( p_init_msg_list )

Line 769: IF FND_API.to_Boolean( p_init_msg_list )

765: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
766: END IF;
767: -- dbms_output.put_line ( 'step 3 PUB');
768: -- Initialize message list if p_init_msg_list is set to TRUE.
769: IF FND_API.to_Boolean( p_init_msg_list )
770: THEN
771: FND_MSG_PUB.initialize;
772: END IF;
773: -- dbms_output.put_line ( 'step 4 PUB');

Line 776: x_return_status := FND_API.G_RET_STS_SUCCESS;

772: END IF;
773: -- dbms_output.put_line ( 'step 4 PUB');
774:
775: -- Initialize API return status to SUCCESS
776: x_return_status := FND_API.G_RET_STS_SUCCESS;
777: --
778: -- API body
779:
780: -- Convert the values to ids

Line 795: P_Init_Msg_List => FND_API.G_FALSE,

791: -- dbms_output.put_line ( 'step 1 PUB');
792:
793: CSF_DEBRIEF_PVT.Update_debrief_line(
794: P_Api_Version_Number => 1.0,
795: P_Init_Msg_List => FND_API.G_FALSE,
796: P_Commit => p_commit,
797: P_Upd_tskassgnstatus => P_Upd_tskassgnstatus ,
798: P_Task_Assignment_status => P_Task_Assignment_status ,
799: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,

Line 799: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,

795: P_Init_Msg_List => FND_API.G_FALSE,
796: P_Commit => p_commit,
797: P_Upd_tskassgnstatus => P_Upd_tskassgnstatus ,
798: P_Task_Assignment_status => P_Task_Assignment_status ,
799: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
800: P_DEBRIEF_LINE_Rec => l_pvt_DEBRIEF_LINE_tbl(1),
801: X_Return_Status => x_return_status,
802: X_Msg_Count => x_msg_count,
803: X_Msg_Data => x_msg_data);

Line 807: IF x_return_status = FND_API.G_RET_STS_ERROR then

803: X_Msg_Data => x_msg_data);
804:
805: -- dbms_output.put_line ( 'step 1 PUB');
806: -- Check return status from the above procedure call
807: IF x_return_status = FND_API.G_RET_STS_ERROR then
808:
809: raise FND_API.G_EXC_ERROR;
810: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
811:

Line 809: raise FND_API.G_EXC_ERROR;

805: -- dbms_output.put_line ( 'step 1 PUB');
806: -- Check return status from the above procedure call
807: IF x_return_status = FND_API.G_RET_STS_ERROR then
808:
809: raise FND_API.G_EXC_ERROR;
810: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
811:
812: raise FND_API.G_EXC_UNEXPECTED_ERROR;
813: END IF;

Line 810: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

806: -- Check return status from the above procedure call
807: IF x_return_status = FND_API.G_RET_STS_ERROR then
808:
809: raise FND_API.G_EXC_ERROR;
810: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
811:
812: raise FND_API.G_EXC_UNEXPECTED_ERROR;
813: END IF;
814: -- End of API body

Line 812: raise FND_API.G_EXC_UNEXPECTED_ERROR;

808:
809: raise FND_API.G_EXC_ERROR;
810: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
811:
812: raise FND_API.G_EXC_UNEXPECTED_ERROR;
813: END IF;
814: -- End of API body
815: --
816:

Line 817: IF FND_API.to_Boolean( p_commit )

813: END IF;
814: -- End of API body
815: --
816:
817: IF FND_API.to_Boolean( p_commit )
818: THEN
819: COMMIT WORK;
820: END IF;
821:

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 UPDATE_DEBRIEF_LINE_PUB;
830: x_return_status := FND_API.G_RET_STS_ERROR;
831: FND_MSG_PUB.Count_And_Get (
832: P_COUNT => X_MSG_COUNT

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 UPDATE_DEBRIEF_LINE_PUB;
830: x_return_status := FND_API.G_RET_STS_ERROR;
831: FND_MSG_PUB.Count_And_Get (
832: P_COUNT => X_MSG_COUNT
833: ,P_DATA => X_MSG_DATA);
834:

Line 835: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

831: FND_MSG_PUB.Count_And_Get (
832: P_COUNT => X_MSG_COUNT
833: ,P_DATA => X_MSG_DATA);
834:
835: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
836: ROLLBACK TO UPDATE_DEBRIEF_LINE_PUB;
837: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
838: FND_MSG_PUB.Count_And_Get (
839: P_COUNT => X_MSG_COUNT

Line 837: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

833: ,P_DATA => X_MSG_DATA);
834:
835: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
836: ROLLBACK TO UPDATE_DEBRIEF_LINE_PUB;
837: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
838: FND_MSG_PUB.Count_And_Get (
839: P_COUNT => X_MSG_COUNT
840: ,P_DATA => X_MSG_DATA);
841:

Line 844: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

840: ,P_DATA => X_MSG_DATA);
841:
842: WHEN OTHERS THEN
843: ROLLBACK TO UPDATE_DEBRIEF_LINE_PUB;
844: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
845: IF FND_MSG_PUB.Check_Msg_Level
846: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
847: THEN
848: FND_MSG_PUB.Add_Exc_Msg (

Line 879: x_return_status := fnd_api.g_ret_sts_success;

875: v_cursorid INTEGER;
876: v_blockstr VARCHAR2(2000);
877: v_dummy INTEGER;
878: BEGIN
879: x_return_status := fnd_api.g_ret_sts_success;
880:
881: FOR i IN c1
882: LOOP
883: v_cursorid := DBMS_SQL.open_cursor;

Line 892: IF NOT (x_return_status = fnd_api.g_ret_sts_success)

888: v_dummy := DBMS_SQL.execute (v_cursorid);
889: DBMS_SQL.variable_value (v_cursorid, ':1', x_return_status);
890: DBMS_SQL.close_cursor (v_cursorid);
891:
892: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
893: THEN
894: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_RETURN_STATUS');
895: fnd_message.set_token (
896: 'P_PROCEDURE',

Line 900: x_return_status := fnd_api.g_ret_sts_unexp_error;

896: 'P_PROCEDURE',
897: i.hook_package || '.' || i.hook_api
898: );
899: fnd_msg_pub.add;
900: x_return_status := fnd_api.g_ret_sts_unexp_error;
901: RAISE fnd_api.g_exc_unexpected_error;
902: x_return_status := fnd_api.g_ret_sts_unexp_error;
903: RAISE fnd_api.g_exc_unexpected_error;
904: END IF;

Line 901: RAISE fnd_api.g_exc_unexpected_error;

897: i.hook_package || '.' || i.hook_api
898: );
899: fnd_msg_pub.add;
900: x_return_status := fnd_api.g_ret_sts_unexp_error;
901: RAISE fnd_api.g_exc_unexpected_error;
902: x_return_status := fnd_api.g_ret_sts_unexp_error;
903: RAISE fnd_api.g_exc_unexpected_error;
904: END IF;
905:

Line 902: x_return_status := fnd_api.g_ret_sts_unexp_error;

898: );
899: fnd_msg_pub.add;
900: x_return_status := fnd_api.g_ret_sts_unexp_error;
901: RAISE fnd_api.g_exc_unexpected_error;
902: x_return_status := fnd_api.g_ret_sts_unexp_error;
903: RAISE fnd_api.g_exc_unexpected_error;
904: END IF;
905:
906: IF x_return_status IS NULL

Line 903: RAISE fnd_api.g_exc_unexpected_error;

899: fnd_msg_pub.add;
900: x_return_status := fnd_api.g_ret_sts_unexp_error;
901: RAISE fnd_api.g_exc_unexpected_error;
902: x_return_status := fnd_api.g_ret_sts_unexp_error;
903: RAISE fnd_api.g_exc_unexpected_error;
904: END IF;
905:
906: IF x_return_status IS NULL
907: THEN

Line 910: x_return_status := fnd_api.g_ret_sts_unexp_error;

906: IF x_return_status IS NULL
907: THEN
908: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_RETURN_STATUS');
909: fnd_msg_pub.add;
910: x_return_status := fnd_api.g_ret_sts_unexp_error;
911: RAISE fnd_api.g_exc_unexpected_error;
912: END IF;
913: END LOOP;
914: EXCEPTION

Line 911: RAISE fnd_api.g_exc_unexpected_error;

907: THEN
908: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_RETURN_STATUS');
909: fnd_msg_pub.add;
910: x_return_status := fnd_api.g_ret_sts_unexp_error;
911: RAISE fnd_api.g_exc_unexpected_error;
912: END IF;
913: END LOOP;
914: EXCEPTION
915: WHEN fnd_api.g_exc_unexpected_error

Line 915: WHEN fnd_api.g_exc_unexpected_error

911: RAISE fnd_api.g_exc_unexpected_error;
912: END IF;
913: END LOOP;
914: EXCEPTION
915: WHEN fnd_api.g_exc_unexpected_error
916: THEN
917: x_return_status := fnd_api.g_ret_sts_unexp_error;
918: WHEN OTHERS
919: THEN

Line 917: x_return_status := fnd_api.g_ret_sts_unexp_error;

913: END LOOP;
914: EXCEPTION
915: WHEN fnd_api.g_exc_unexpected_error
916: THEN
917: x_return_status := fnd_api.g_ret_sts_unexp_error;
918: WHEN OTHERS
919: THEN
920: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
921: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);

Line 923: x_return_status := fnd_api.g_ret_sts_unexp_error;

919: THEN
920: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
921: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
922: fnd_msg_pub.add;
923: x_return_status := fnd_api.g_ret_sts_unexp_error;
924: END;
925: End CSF_DEBRIEF_PUB;
926:
927: