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 446: FND_MSG_PUB.initialize;

442:
443: -- Initialize message list if p_init_msg_list is set to TRUE.
444: IF FND_API.to_Boolean( p_init_msg_list )
445: THEN
446: FND_MSG_PUB.initialize;
447: END IF;
448:
449: -- Initialize API return status to SUCCESS
450: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 492: FND_MSG_PUB.Count_And_Get

488: THEN
489: COMMIT WORK;
490: END IF;
491:
492: FND_MSG_PUB.Count_And_Get
493: ( p_count => x_msg_count,
494: p_data => x_msg_data
495: );
496:

Line 503: FND_MSG_PUB.Count_And_Get (

499: WHEN FND_API.G_EXC_ERROR THEN
500:
501: ROLLBACK TO CREATE_DEBRIEF_PUB;
502: x_return_status := FND_API.G_RET_STS_ERROR;
503: FND_MSG_PUB.Count_And_Get (
504: P_COUNT => X_MSG_COUNT
505: ,P_DATA => X_MSG_DATA);
506: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
507: ROLLBACK TO CREATE_DEBRIEF_PUB;

Line 510: FND_MSG_PUB.Count_And_Get (

506: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
507: ROLLBACK TO CREATE_DEBRIEF_PUB;
508:
509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
510: FND_MSG_PUB.Count_And_Get (
511: P_COUNT => X_MSG_COUNT
512: ,P_DATA => X_MSG_DATA);
513: WHEN OTHERS THEN
514: ROLLBACK TO CREATE_DEBRIEF_PUB;

Line 517: IF FND_MSG_PUB.Check_Msg_Level

513: WHEN OTHERS THEN
514: ROLLBACK TO CREATE_DEBRIEF_PUB;
515:
516: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
517: IF FND_MSG_PUB.Check_Msg_Level
518: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
519: THEN
520: FND_MSG_PUB.Add_Exc_Msg (
521: G_PKG_NAME

Line 518: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

514: ROLLBACK TO CREATE_DEBRIEF_PUB;
515:
516: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
517: IF FND_MSG_PUB.Check_Msg_Level
518: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
519: THEN
520: FND_MSG_PUB.Add_Exc_Msg (
521: G_PKG_NAME
522: ,L_API_NAME );

Line 520: FND_MSG_PUB.Add_Exc_Msg (

516: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
517: IF FND_MSG_PUB.Check_Msg_Level
518: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
519: THEN
520: FND_MSG_PUB.Add_Exc_Msg (
521: G_PKG_NAME
522: ,L_API_NAME );
523: END IF;
524: FND_MSG_PUB.Count_And_Get (

Line 524: FND_MSG_PUB.Count_And_Get (

520: FND_MSG_PUB.Add_Exc_Msg (
521: G_PKG_NAME
522: ,L_API_NAME );
523: END IF;
524: FND_MSG_PUB.Count_And_Get (
525: P_COUNT => X_MSG_COUNT
526: ,P_DATA => X_MSG_DATA);
527:
528: End Create_debrief;

Line 563: FND_MSG_PUB.initialize;

559: END IF;
560:
561: -- Initialize message list if p_init_msg_list is set to TRUE.
562: IF FND_API.to_Boolean( p_init_msg_list ) THEN
563: FND_MSG_PUB.initialize;
564: END IF;
565:
566: -- Initialize API return status to SUCCESS
567: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 698: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

694:
695: IF FND_API.to_Boolean( p_commit ) THEN
696: COMMIT WORK;
697: END IF;
698: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
699: EXCEPTION
700: WHEN FND_API.G_EXC_ERROR THEN
701: ROLLBACK TO CREATE_DEBRIEF_PUB;
702: x_return_status := FND_API.G_RET_STS_ERROR;

Line 703: FND_MSG_PUB.Count_And_Get ( P_COUNT => X_MSG_COUNT ,p_data => x_msg_data);

699: EXCEPTION
700: WHEN FND_API.G_EXC_ERROR THEN
701: ROLLBACK TO CREATE_DEBRIEF_PUB;
702: x_return_status := FND_API.G_RET_STS_ERROR;
703: FND_MSG_PUB.Count_And_Get ( P_COUNT => X_MSG_COUNT ,p_data => x_msg_data);
704: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
705: ROLLBACK TO CREATE_DEBRIEF_PUB;
706: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
707: FND_MSG_PUB.Count_And_Get ( P_COUNT => X_MSG_COUNT ,P_DATA => X_MSG_DATA);

Line 707: FND_MSG_PUB.Count_And_Get ( P_COUNT => X_MSG_COUNT ,P_DATA => X_MSG_DATA);

703: FND_MSG_PUB.Count_And_Get ( P_COUNT => X_MSG_COUNT ,p_data => x_msg_data);
704: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
705: ROLLBACK TO CREATE_DEBRIEF_PUB;
706: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
707: FND_MSG_PUB.Count_And_Get ( P_COUNT => X_MSG_COUNT ,P_DATA => X_MSG_DATA);
708: WHEN OTHERS THEN
709: ROLLBACK TO CREATE_DEBRIEF_PUB;
710: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
711: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 711: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

707: FND_MSG_PUB.Count_And_Get ( P_COUNT => X_MSG_COUNT ,P_DATA => X_MSG_DATA);
708: WHEN OTHERS THEN
709: ROLLBACK TO CREATE_DEBRIEF_PUB;
710: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
711: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
712: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME ,L_API_NAME );
713: END IF;
714: fnd_msg_pub.count_and_get ( p_count => x_msg_count ,p_data => x_msg_data);
715: END Create_Debrief_With_Dff_Vals;

Line 712: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME ,L_API_NAME );

708: WHEN OTHERS THEN
709: ROLLBACK TO CREATE_DEBRIEF_PUB;
710: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
711: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
712: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME ,L_API_NAME );
713: END IF;
714: fnd_msg_pub.count_and_get ( p_count => x_msg_count ,p_data => x_msg_data);
715: END Create_Debrief_With_Dff_Vals;
716:

Line 714: fnd_msg_pub.count_and_get ( p_count => x_msg_count ,p_data => x_msg_data);

710: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
711: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
712: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME ,L_API_NAME );
713: END IF;
714: fnd_msg_pub.count_and_get ( p_count => x_msg_count ,p_data => x_msg_data);
715: END Create_Debrief_With_Dff_Vals;
716:
717: PROCEDURE Update_debrief(
718: P_Api_Version_Number IN NUMBER,

Line 745: FND_MSG_PUB.initialize;

741:
742: -- Initialize message list if p_init_msg_list is set to TRUE.
743: IF FND_API.to_Boolean( p_init_msg_list )
744: THEN
745: FND_MSG_PUB.initialize;
746: END IF;
747:
748: -- Initialize API return status to SUCCESS
749: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 782: FND_MSG_PUB.Count_And_Get

778: THEN
779: COMMIT WORK;
780: END IF;
781:
782: FND_MSG_PUB.Count_And_Get
783: ( p_count => x_msg_count,
784: p_data => x_msg_data
785: );
786:

Line 791: FND_MSG_PUB.Count_And_Get (

787: EXCEPTION
788: WHEN FND_API.G_EXC_ERROR THEN
789: ROLLBACK TO UPDATE_DEBRIEF_PUB;
790: x_return_status := FND_API.G_RET_STS_ERROR;
791: FND_MSG_PUB.Count_And_Get (
792: P_COUNT => X_MSG_COUNT
793: ,P_DATA => X_MSG_DATA);
794:
795: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 798: FND_MSG_PUB.Count_And_Get (

794:
795: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
796: ROLLBACK TO UPDATE_DEBRIEF_PUB;
797: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
798: FND_MSG_PUB.Count_And_Get (
799: P_COUNT => X_MSG_COUNT
800: ,P_DATA => X_MSG_DATA);
801:
802: WHEN OTHERS THEN

Line 805: IF FND_MSG_PUB.Check_Msg_Level

801:
802: WHEN OTHERS THEN
803: ROLLBACK TO UPDATE_DEBRIEF_PUB;
804: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
805: IF FND_MSG_PUB.Check_Msg_Level
806: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
807: THEN
808: FND_MSG_PUB.Add_Exc_Msg (
809: G_PKG_NAME

Line 806: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

802: WHEN OTHERS THEN
803: ROLLBACK TO UPDATE_DEBRIEF_PUB;
804: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
805: IF FND_MSG_PUB.Check_Msg_Level
806: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
807: THEN
808: FND_MSG_PUB.Add_Exc_Msg (
809: G_PKG_NAME
810: ,L_API_NAME );

Line 808: FND_MSG_PUB.Add_Exc_Msg (

804: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
805: IF FND_MSG_PUB.Check_Msg_Level
806: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
807: THEN
808: FND_MSG_PUB.Add_Exc_Msg (
809: G_PKG_NAME
810: ,L_API_NAME );
811: END IF;
812:

Line 813: FND_MSG_PUB.Count_And_Get (

809: G_PKG_NAME
810: ,L_API_NAME );
811: END IF;
812:
813: FND_MSG_PUB.Count_And_Get (
814: P_COUNT => X_MSG_COUNT
815: ,P_DATA => X_MSG_DATA);
816:
817: End Update_debrief;

Line 853: THEN FND_MSG_PUB.initialize; END IF;

849: END IF;
850:
851: -- Initialize message list if p_init_msg_list is set to TRUE.
852: IF FND_API.to_Boolean( p_init_msg_list )
853: THEN FND_MSG_PUB.initialize; END IF;
854:
855: -- Initialize API return status to SUCCESS
856: x_return_status := FND_API.G_RET_STS_SUCCESS;
857:

Line 897: FND_MSG_PUB.Count_And_Get

893: THEN
894: COMMIT WORK;
895: END IF;
896:
897: FND_MSG_PUB.Count_And_Get
898: ( p_count => x_msg_count,
899: p_data => x_msg_data
900: );
901:

Line 906: FND_MSG_PUB.Count_And_Get (

902: EXCEPTION
903: WHEN FND_API.G_EXC_ERROR THEN
904: ROLLBACK TO CREATE_DEBRIEF_LINE_PUB;
905: x_return_status := FND_API.G_RET_STS_ERROR;
906: FND_MSG_PUB.Count_And_Get (
907: P_COUNT => X_MSG_COUNT
908: ,P_DATA => X_MSG_DATA);
909:
910: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 915: FND_MSG_PUB.Count_And_Get (

911: --dbms_output.put_line('sqlerr:'||sqlerrm);
912: --dbms_output.put_line('sqlcode:'||sqlcode);
913: ROLLBACK TO CREATE_DEBRIEF_LINE_PUB;
914: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
915: FND_MSG_PUB.Count_And_Get (
916: P_COUNT => X_MSG_COUNT
917: ,P_DATA => X_MSG_DATA);
918:
919: WHEN OTHERS THEN

Line 924: IF FND_MSG_PUB.Check_Msg_Level

920: --dbms_output.put_line('sqlerr:'||sqlerrm);
921: --dbms_output.put_line('sqlcode:'||sqlcode);
922: ROLLBACK TO CREATE_DEBRIEF_LINE_PUB;
923: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
924: IF FND_MSG_PUB.Check_Msg_Level
925: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
926: THEN
927: FND_MSG_PUB.Add_Exc_Msg (
928: G_PKG_NAME

Line 925: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

921: --dbms_output.put_line('sqlcode:'||sqlcode);
922: ROLLBACK TO CREATE_DEBRIEF_LINE_PUB;
923: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
924: IF FND_MSG_PUB.Check_Msg_Level
925: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
926: THEN
927: FND_MSG_PUB.Add_Exc_Msg (
928: G_PKG_NAME
929: ,L_API_NAME );

Line 927: FND_MSG_PUB.Add_Exc_Msg (

923: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
924: IF FND_MSG_PUB.Check_Msg_Level
925: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
926: THEN
927: FND_MSG_PUB.Add_Exc_Msg (
928: G_PKG_NAME
929: ,L_API_NAME );
930: END IF;
931:

Line 932: FND_MSG_PUB.Count_And_Get (

928: G_PKG_NAME
929: ,L_API_NAME );
930: END IF;
931:
932: FND_MSG_PUB.Count_And_Get (
933: P_COUNT => X_MSG_COUNT
934: ,P_DATA => X_MSG_DATA);
935:
936: End Create_debrief_lines;

Line 971: FND_MSG_PUB.initialize;

967: -- dbms_output.put_line ( 'step 3 PUB');
968: -- Initialize message list if p_init_msg_list is set to TRUE.
969: IF FND_API.to_Boolean( p_init_msg_list )
970: THEN
971: FND_MSG_PUB.initialize;
972: END IF;
973: -- dbms_output.put_line ( 'step 4 PUB');
974:
975: -- Initialize API return status to SUCCESS

Line 1022: FND_MSG_PUB.Count_And_Get

1018: THEN
1019: COMMIT WORK;
1020: END IF;
1021:
1022: FND_MSG_PUB.Count_And_Get
1023: ( p_count => x_msg_count,
1024: p_data => x_msg_data
1025: );
1026:

Line 1031: FND_MSG_PUB.Count_And_Get (

1027: EXCEPTION
1028: WHEN FND_API.G_EXC_ERROR THEN
1029: ROLLBACK TO UPDATE_DEBRIEF_LINE_PUB;
1030: x_return_status := FND_API.G_RET_STS_ERROR;
1031: FND_MSG_PUB.Count_And_Get (
1032: P_COUNT => X_MSG_COUNT
1033: ,P_DATA => X_MSG_DATA);
1034:
1035: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1038: FND_MSG_PUB.Count_And_Get (

1034:
1035: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1036: ROLLBACK TO UPDATE_DEBRIEF_LINE_PUB;
1037: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1038: FND_MSG_PUB.Count_And_Get (
1039: P_COUNT => X_MSG_COUNT
1040: ,P_DATA => X_MSG_DATA);
1041:
1042: WHEN OTHERS THEN

Line 1045: IF FND_MSG_PUB.Check_Msg_Level

1041:
1042: WHEN OTHERS THEN
1043: ROLLBACK TO UPDATE_DEBRIEF_LINE_PUB;
1044: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1045: IF FND_MSG_PUB.Check_Msg_Level
1046: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1047: THEN
1048: FND_MSG_PUB.Add_Exc_Msg (
1049: G_PKG_NAME

Line 1046: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1042: WHEN OTHERS THEN
1043: ROLLBACK TO UPDATE_DEBRIEF_LINE_PUB;
1044: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1045: IF FND_MSG_PUB.Check_Msg_Level
1046: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1047: THEN
1048: FND_MSG_PUB.Add_Exc_Msg (
1049: G_PKG_NAME
1050: ,L_API_NAME );

Line 1048: FND_MSG_PUB.Add_Exc_Msg (

1044: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1045: IF FND_MSG_PUB.Check_Msg_Level
1046: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1047: THEN
1048: FND_MSG_PUB.Add_Exc_Msg (
1049: G_PKG_NAME
1050: ,L_API_NAME );
1051: END IF;
1052:

Line 1053: FND_MSG_PUB.Count_And_Get (

1049: G_PKG_NAME
1050: ,L_API_NAME );
1051: END IF;
1052:
1053: FND_MSG_PUB.Count_And_Get (
1054: P_COUNT => X_MSG_COUNT
1055: ,P_DATA => X_MSG_DATA);
1056:
1057: End Update_debrief_line;

Line 1099: fnd_msg_pub.add;

1095: fnd_message.set_token (
1096: 'P_PROCEDURE',
1097: i.hook_package || '.' || i.hook_api
1098: );
1099: fnd_msg_pub.add;
1100: x_return_status := fnd_api.g_ret_sts_unexp_error;
1101: RAISE fnd_api.g_exc_unexpected_error;
1102: x_return_status := fnd_api.g_ret_sts_unexp_error;
1103: RAISE fnd_api.g_exc_unexpected_error;

Line 1109: fnd_msg_pub.add;

1105:
1106: IF x_return_status IS NULL
1107: THEN
1108: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_RETURN_STATUS');
1109: fnd_msg_pub.add;
1110: x_return_status := fnd_api.g_ret_sts_unexp_error;
1111: RAISE fnd_api.g_exc_unexpected_error;
1112: END IF;
1113: END LOOP;

Line 1122: fnd_msg_pub.add;

1118: WHEN OTHERS
1119: THEN
1120: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
1121: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
1122: fnd_msg_pub.add;
1123: x_return_status := fnd_api.g_ret_sts_unexp_error;
1124: END;
1125:
1126: PROCEDURE set_auto_debrief (p_auto_debrief boolean) IS