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_MSG_PUB

Line 127: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)

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');
130: FND_MESSAGE.Set_Token ('COLUMN', 'INTEREST_TYPE', FALSE);
131: FND_MSG_PUB.Add;

Line 131: FND_MSG_PUB.Add;

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');
130: FND_MESSAGE.Set_Token ('COLUMN', 'INTEREST_TYPE', FALSE);
131: FND_MSG_PUB.Add;
132: END IF;
133: END IF;
134:
135: ELSIF (p_interest_type is not NULL and

Line 144: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

140: CLOSE C_Get_Int_Type;
141:
142: IF (l_interest_type_id IS NULL)
143: THEN
144: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
145: THEN
146: FND_MESSAGE.Set_Name ('CSF', 'API_ATTRIBUTE_CONVERSION_ERROR');
147: FND_MESSAGE.Set_Token ('COLUMN', 'INTEREST_TYPE', FALSE);
148: FND_MESSAGE.Set_Token('VALUE', p_interest_type, FALSE);

Line 149: FND_MSG_PUB.Add;

145: THEN
146: FND_MESSAGE.Set_Name ('CSF', 'API_ATTRIBUTE_CONVERSION_ERROR');
147: FND_MESSAGE.Set_Token ('COLUMN', 'INTEREST_TYPE', FALSE);
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:

Line 161: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

157:
158: ELSE
159: -- If no interest type (value or id) exists, then this row is invalid
160: --
161: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
162: THEN
163: FND_MESSAGE.Set_Name ('CSF','API_MISSING_ID');
164: FND_MESSAGE.Set_Token ('COLUMN', 'INTEREST_TYPE', FALSE);
165: FND_MSG_PUB.Add;

Line 165: FND_MSG_PUB.Add;

161: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
162: THEN
163: FND_MESSAGE.Set_Name ('CSF','API_MISSING_ID');
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;

Line 182: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)

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');
185: FND_MESSAGE.Set_Token ('COLUMN', 'PRIMARY_INTEREST_CODE', FALSE);
186: FND_MSG_PUB.Add;

Line 186: FND_MSG_PUB.Add;

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');
185: FND_MESSAGE.Set_Token ('COLUMN', 'PRIMARY_INTEREST_CODE', FALSE);
186: FND_MSG_PUB.Add;
187: END IF;
188: END IF;
189:
190: ELSIF (p_primary_interest_code is not NULL and

Line 200: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

196: CLOSE C_Get_Int_Code;
197:
198: IF (l_interest_code_id IS NULL)
199: THEN
200: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
201: THEN
202: FND_MESSAGE.Set_Name ('CSF', 'API_ATTRIBUTE_CONVERSION_ERROR');
203: FND_MESSAGE.Set_Token ('COLUMN', 'PRIMARY_INTEREST_CODE', FALSE);
204: FND_MESSAGE.Set_Token('VALUE', p_primary_interest_code, FALSE);

Line 205: FND_MSG_PUB.Add;

201: THEN
202: FND_MESSAGE.Set_Name ('CSF', 'API_ATTRIBUTE_CONVERSION_ERROR');
203: FND_MESSAGE.Set_Token ('COLUMN', 'PRIMARY_INTEREST_CODE', FALSE);
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:

Line 226: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)

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');
229: FND_MESSAGE.Set_Token ('COLUMN', 'SECONDARY_INTEREST_CODE', FALSE);
230: FND_MSG_PUB.Add;

Line 230: FND_MSG_PUB.Add;

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');
229: FND_MESSAGE.Set_Token ('COLUMN', 'SECONDARY_INTEREST_CODE', FALSE);
230: FND_MSG_PUB.Add;
231: END IF;
232: END IF;
233:
234: ELSIF (p_secondary_interest_code is not NULL and

Line 244: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

240: CLOSE C_Get_Int_Code;
241:
242: IF (l_secondary_interest_code_id IS NULL)
243: THEN
244: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
245: THEN
246: FND_MESSAGE.Set_Name ('CSF', 'API_ATTRIBUTE_CONVERSION_ERROR');
247: FND_MESSAGE.Set_Token ('COLUMN', 'SECONDARY_INTEREST_CODE', FALSE);
248: FND_MESSAGE.Set_Token('VALUE', p_secondary_interest_code, FALSE);

Line 249: FND_MSG_PUB.Add;

245: THEN
246: FND_MESSAGE.Set_Name ('CSF', 'API_ATTRIBUTE_CONVERSION_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

Line 436: FND_MSG_PUB.initialize;

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:
439: -- Initialize API return status to SUCCESS
440: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 482: FND_MSG_PUB.Count_And_Get

478: THEN
479: COMMIT WORK;
480: END IF;
481:
482: FND_MSG_PUB.Count_And_Get
483: ( p_count => x_msg_count,
484: p_data => x_msg_data
485: );
486:

Line 493: FND_MSG_PUB.Count_And_Get (

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
497: ROLLBACK TO CREATE_DEBRIEF_PUB;

Line 500: FND_MSG_PUB.Count_And_Get (

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
504: ROLLBACK TO CREATE_DEBRIEF_PUB;

Line 507: IF FND_MSG_PUB.Check_Msg_Level

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 (
511: G_PKG_NAME

Line 508: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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 (
511: G_PKG_NAME
512: ,L_API_NAME );

Line 510: FND_MSG_PUB.Add_Exc_Msg (

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 (
511: G_PKG_NAME
512: ,L_API_NAME );
513: END IF;
514: FND_MSG_PUB.Count_And_Get (

Line 514: FND_MSG_PUB.Count_And_Get (

510: FND_MSG_PUB.Add_Exc_Msg (
511: G_PKG_NAME
512: ,L_API_NAME );
513: END IF;
514: FND_MSG_PUB.Count_And_Get (
515: P_COUNT => X_MSG_COUNT
516: ,P_DATA => X_MSG_DATA);
517:
518: End Create_debrief;

Line 549: FND_MSG_PUB.initialize;

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:
552: -- Initialize API return status to SUCCESS
553: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 586: FND_MSG_PUB.Count_And_Get

582: THEN
583: COMMIT WORK;
584: END IF;
585:
586: FND_MSG_PUB.Count_And_Get
587: ( p_count => x_msg_count,
588: p_data => x_msg_data
589: );
590:

Line 595: FND_MSG_PUB.Count_And_Get (

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:
599: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 602: FND_MSG_PUB.Count_And_Get (

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:
606: WHEN OTHERS THEN

Line 609: IF FND_MSG_PUB.Check_Msg_Level

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 (
613: G_PKG_NAME

Line 610: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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 (
613: G_PKG_NAME
614: ,L_API_NAME );

Line 612: FND_MSG_PUB.Add_Exc_Msg (

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 (
613: G_PKG_NAME
614: ,L_API_NAME );
615: END IF;
616:

Line 617: FND_MSG_PUB.Count_And_Get (

613: G_PKG_NAME
614: ,L_API_NAME );
615: END IF;
616:
617: FND_MSG_PUB.Count_And_Get (
618: P_COUNT => X_MSG_COUNT
619: ,P_DATA => X_MSG_DATA);
620:
621: End Update_debrief;

Line 657: THEN FND_MSG_PUB.initialize; END IF;

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;
661:

Line 701: FND_MSG_PUB.Count_And_Get

697: THEN
698: COMMIT WORK;
699: END IF;
700:
701: FND_MSG_PUB.Count_And_Get
702: ( p_count => x_msg_count,
703: p_data => x_msg_data
704: );
705:

Line 710: FND_MSG_PUB.Count_And_Get (

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:
714: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 717: FND_MSG_PUB.Count_And_Get (

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:
721: WHEN OTHERS THEN

Line 724: IF FND_MSG_PUB.Check_Msg_Level

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 (
728: G_PKG_NAME

Line 725: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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 (
728: G_PKG_NAME
729: ,L_API_NAME );

Line 727: FND_MSG_PUB.Add_Exc_Msg (

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 (
728: G_PKG_NAME
729: ,L_API_NAME );
730: END IF;
731:

Line 732: FND_MSG_PUB.Count_And_Get (

728: G_PKG_NAME
729: ,L_API_NAME );
730: END IF;
731:
732: FND_MSG_PUB.Count_And_Get (
733: P_COUNT => X_MSG_COUNT
734: ,P_DATA => X_MSG_DATA);
735:
736: End Create_debrief_lines;

Line 771: FND_MSG_PUB.initialize;

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');
774:
775: -- Initialize API return status to SUCCESS

Line 822: FND_MSG_PUB.Count_And_Get

818: THEN
819: COMMIT WORK;
820: END IF;
821:
822: FND_MSG_PUB.Count_And_Get
823: ( p_count => x_msg_count,
824: p_data => x_msg_data
825: );
826:

Line 831: FND_MSG_PUB.Count_And_Get (

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:
835: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 838: FND_MSG_PUB.Count_And_Get (

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:
842: WHEN OTHERS THEN

Line 845: IF FND_MSG_PUB.Check_Msg_Level

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 (
849: G_PKG_NAME

Line 846: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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 (
849: G_PKG_NAME
850: ,L_API_NAME );

Line 848: FND_MSG_PUB.Add_Exc_Msg (

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 (
849: G_PKG_NAME
850: ,L_API_NAME );
851: END IF;
852:

Line 853: FND_MSG_PUB.Count_And_Get (

849: G_PKG_NAME
850: ,L_API_NAME );
851: END IF;
852:
853: FND_MSG_PUB.Count_And_Get (
854: P_COUNT => X_MSG_COUNT
855: ,P_DATA => X_MSG_DATA);
856:
857: End Update_debrief_line;

Line 899: fnd_msg_pub.add;

895: fnd_message.set_token (
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;

Line 909: fnd_msg_pub.add;

905:
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;

Line 922: fnd_msg_pub.add;

918: WHEN OTHERS
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: