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.CN_SRP_PMT_PLANS_PVT dependencies on FND_MSG_PUB

Line 166: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

162: OR
163: (p_srp_pmt_plan_id IS NULL));
164:
165: IF l_dummy > 0 THEN
166: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
167: FND_MESSAGE.Set_Name('CN', 'CN_SRP_PMT_PLAN_EXIST');
168: FND_MSG_PUB.Add;
169: END IF;
170: x_loading_status := 'CN_SRP_PMT_PLAN_EXIST';

Line 168: FND_MSG_PUB.Add;

164:
165: IF l_dummy > 0 THEN
166: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
167: FND_MESSAGE.Set_Name('CN', 'CN_SRP_PMT_PLAN_EXIST');
168: FND_MSG_PUB.Add;
169: END IF;
170: x_loading_status := 'CN_SRP_PMT_PLAN_EXIST';
171: RAISE FND_API.G_EXC_ERROR ;
172: END IF;

Line 185: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

181: WHERE salesrep_id = p_salesrep_id
182: AND org_id = p_org_id;
183:
184: IF l_srp_start_date IS NULL THEN
185: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
186: FND_MESSAGE.SET_NAME('CN','SRP_MUST_ACTIVATE_REP');
187: FND_MSG_PUB.Add;
188: END IF;
189: x_loading_status := 'SRP_MUST_ACTIVATE_REP';

Line 187: FND_MSG_PUB.Add;

183:
184: IF l_srp_start_date IS NULL THEN
185: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
186: FND_MESSAGE.SET_NAME('CN','SRP_MUST_ACTIVATE_REP');
187: FND_MSG_PUB.Add;
188: END IF;
189: x_loading_status := 'SRP_MUST_ACTIVATE_REP';
190: RAISE FND_API.G_EXC_ERROR ;
191: END IF;

Line 233: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

229:
230: ) -- end of IF
231:
232: THEN
233: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
234: FND_MESSAGE.SET_NAME ('CN' , 'CN_SPP_PRDS_NI_SRP_PRDS');
235: FND_MSG_PUB.Add;
236: END IF;
237: x_loading_status := 'CN_SPP_PRDS_NI_SRP_PRDS';

Line 235: FND_MSG_PUB.Add;

231:
232: THEN
233: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
234: FND_MESSAGE.SET_NAME ('CN' , 'CN_SPP_PRDS_NI_SRP_PRDS');
235: FND_MSG_PUB.Add;
236: END IF;
237: x_loading_status := 'CN_SPP_PRDS_NI_SRP_PRDS';
238: RAISE FND_API.G_EXC_ERROR ;
239: END IF;

Line 273: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

269: ) -- end of IF
270:
271:
272: THEN
273: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
274: FND_MESSAGE.SET_NAME ('CN' , 'CN_SPP_PRDS_NI_PMT_PRDS');
275: FND_MSG_PUB.Add;
276: END IF;
277: x_loading_status := 'CN_SPP_PRDS_NI_PMT_PRDS';

Line 275: FND_MSG_PUB.Add;

271:
272: THEN
273: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
274: FND_MESSAGE.SET_NAME ('CN' , 'CN_SPP_PRDS_NI_PMT_PRDS');
275: FND_MSG_PUB.Add;
276: END IF;
277: x_loading_status := 'CN_SPP_PRDS_NI_PMT_PRDS';
278: RAISE FND_API.G_EXC_ERROR ;
279: END IF;

Line 318: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

314: AND cpp.payment_group_code = l_payment_group_code
315: AND cspp.pmt_plan_id = cpp.pmt_plan_id;
316:
317: IF l_dummy > 0 then
318: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
319: FND_MESSAGE.SET_NAME ('CN' , 'CN_SRP_PMT_PLAN_OVERLAPS');
320: FND_MSG_PUB.Add;
321: END IF;
322: x_loading_status := 'CN_SRP_PMT_PLAN_OVERLAPS';

Line 320: FND_MSG_PUB.Add;

316:
317: IF l_dummy > 0 then
318: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
319: FND_MESSAGE.SET_NAME ('CN' , 'CN_SRP_PMT_PLAN_OVERLAPS');
320: FND_MSG_PUB.Add;
321: END IF;
322: x_loading_status := 'CN_SRP_PMT_PLAN_OVERLAPS';
323: RAISE FND_API.G_EXC_ERROR ;
324: END IF;

Line 345: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

341: END LOOP;
342:
343: IF l_dummy2 = 1 THEN
344: IF l_dummy = 0 THEN
345: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
346: FND_MESSAGE.SET_NAME ('CN' , 'CN_SRPPP_CT_MISMATCH');
347: FND_MSG_PUB.Add;
348: END IF;
349: x_loading_status := 'CN_SRPPP_CT_MISMATCH';

Line 347: FND_MSG_PUB.Add;

343: IF l_dummy2 = 1 THEN
344: IF l_dummy = 0 THEN
345: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
346: FND_MESSAGE.SET_NAME ('CN' , 'CN_SRPPP_CT_MISMATCH');
347: FND_MSG_PUB.Add;
348: END IF;
349: x_loading_status := 'CN_SRPPP_CT_MISMATCH';
350: RAISE FND_API.G_EXC_ERROR;
351: END IF;

Line 357: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

353: */
354:
355: -- either min amount or max amount needs to be populated
356: IF (p_minimum_amount IS NULL AND p_maximum_amount IS NULL) THEN
357: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
358: FND_MESSAGE.SET_NAME ('CN' , 'CN_SPP_MIN_MAX_NULL');
359: FND_MSG_PUB.Add;
360: END IF;
361: x_loading_status := 'CN_SPP_MIN_MAX_NULL';

Line 359: FND_MSG_PUB.Add;

355: -- either min amount or max amount needs to be populated
356: IF (p_minimum_amount IS NULL AND p_maximum_amount IS NULL) THEN
357: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
358: FND_MESSAGE.SET_NAME ('CN' , 'CN_SPP_MIN_MAX_NULL');
359: FND_MSG_PUB.Add;
360: END IF;
361: x_loading_status := 'CN_SPP_MIN_MAX_NULL';
362: RAISE FND_API.G_EXC_ERROR ;
363: END IF;

Line 368: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

364:
365: -- Check Max amount must > Min amount
366: IF (p_maximum_amount < p_minimum_amount)
367: THEN
368: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
369: FND_MESSAGE.SET_NAME ('CN' , 'CN_SPP_MAX_LT_MIN');
370: FND_MSG_PUB.Add;
371: END IF;
372: x_loading_status := 'CN_SPP_MAX_LT_MIN';

Line 370: FND_MSG_PUB.Add;

366: IF (p_maximum_amount < p_minimum_amount)
367: THEN
368: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
369: FND_MESSAGE.SET_NAME ('CN' , 'CN_SPP_MAX_LT_MIN');
370: FND_MSG_PUB.Add;
371: END IF;
372: x_loading_status := 'CN_SPP_MAX_LT_MIN';
373: RAISE FND_API.G_EXC_ERROR ;
374: END IF;

Line 560: FND_MSG_PUB.initialize;

556: * Same applies to shrinking. Can happen only till the period end date of the
557: * latest paid/unpaid worksheet.
558: -----------------------------------------------------------------------------*/
559: -- Initialize message list
560: FND_MSG_PUB.initialize;
561:
562: IF p_operation = 'DELETE' THEN
563: -- check payruns involved
564: OPEN get_paid_del_payruns;

Line 569: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

565: FETCH get_paid_del_payruns INTO paid_del_payruns_row;
566: CLOSE get_paid_del_payruns;
567:
568: IF paid_del_payruns_row.estatus = 'ERROR' then
569: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
570: FND_MESSAGE.Set_Name('CN', 'CN_SRP_PP_NO_DEL');
571: FND_MSG_PUB.Add;
572: END IF;
573: ELSE

Line 571: FND_MSG_PUB.Add;

567:
568: IF paid_del_payruns_row.estatus = 'ERROR' then
569: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
570: FND_MESSAGE.Set_Name('CN', 'CN_SRP_PP_NO_DEL');
571: FND_MSG_PUB.Add;
572: END IF;
573: ELSE
574: OPEN get_adj_del_payruns;
575: FETCH get_adj_del_payruns INTO adj_del_payruns_row;

Line 579: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

575: FETCH get_adj_del_payruns INTO adj_del_payruns_row;
576: CLOSE get_adj_del_payruns;
577:
578: IF adj_del_payruns_row.estatus = 'ERROR' then
579: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
580: FND_MESSAGE.Set_Name('CN', 'CN_SRP_PP_NO_DEL_ADJ');
581: FND_MSG_PUB.Add;
582: END IF;
583: /* ELSE

Line 581: FND_MSG_PUB.Add;

577:
578: IF adj_del_payruns_row.estatus = 'ERROR' then
579: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
580: FND_MESSAGE.Set_Name('CN', 'CN_SRP_PP_NO_DEL_ADJ');
581: FND_MSG_PUB.Add;
582: END IF;
583: /* ELSE
584: -- With latest update this should never be called as even if unpaid paysheets
585: -- with no payment plan adjustments are present, delete cannot happen.

Line 605: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

601: FETCH get_paid_upd_payruns INTO paid_upd_payruns_row;
602: CLOSE get_paid_upd_payruns;
603:
604: IF paid_upd_payruns_row.estatus = 'ERROR' then
605: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
606: FND_MESSAGE.Set_Name('CN', 'CN_SRP_PP_NO_UPD');
607: FND_MSG_PUB.Add;
608: END IF;
609: ELSE

Line 607: FND_MSG_PUB.Add;

603:
604: IF paid_upd_payruns_row.estatus = 'ERROR' then
605: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
606: FND_MESSAGE.Set_Name('CN', 'CN_SRP_PP_NO_UPD');
607: FND_MSG_PUB.Add;
608: END IF;
609: ELSE
610: OPEN get_adj_upd_payruns;
611: FETCH get_adj_upd_payruns INTO adj_upd_payruns_row;

Line 615: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

611: FETCH get_adj_upd_payruns INTO adj_upd_payruns_row;
612: CLOSE get_adj_upd_payruns;
613:
614: IF adj_upd_payruns_row.estatus = 'ERROR' then
615: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
616: FND_MESSAGE.Set_Name('CN', 'CN_SRP_PP_NO_UPD');
617: FND_MSG_PUB.Add;
618: END IF;
619: /* ELSE

Line 617: FND_MSG_PUB.Add;

613:
614: IF adj_upd_payruns_row.estatus = 'ERROR' then
615: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
616: FND_MESSAGE.Set_Name('CN', 'CN_SRP_PP_NO_UPD');
617: FND_MSG_PUB.Add;
618: END IF;
619: /* ELSE
620: -- With latest update this should never be called as even if unpaid paysheets
621: -- with no payment plan adjustments are present, shrink cannot happen.

Line 694: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

690: OR ((p_end_date IS NULL) AND (prd.end_date IS NULL))
691: );
692:
693: IF l_dummy > 0 then
694: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
695: FND_MESSAGE.SET_NAME ('CN' , 'CN_SRP_PMT_PLAN_USED');
696: FND_MSG_PUB.Add;
697: END IF;
698: x_loading_status := 'CN_SRP_PMT_PLAN_USED';

Line 696: FND_MSG_PUB.Add;

692:
693: IF l_dummy > 0 then
694: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
695: FND_MESSAGE.SET_NAME ('CN' , 'CN_SRP_PMT_PLAN_USED');
696: FND_MSG_PUB.Add;
697: END IF;
698: x_loading_status := 'CN_SRP_PMT_PLAN_USED';
699: RAISE FND_API.G_EXC_ERROR ;
700: END IF;

Line 734: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

730: ((prd.start_date > p_end_date) OR (prd.end_date > p_end_date)))
731: );
732:
733: IF l_dummy > 0 THEN
734: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
735: FND_MESSAGE.SET_NAME ('CN' , 'CN_SPP_CANNOT_SHORTEN_ED');
736: FND_MSG_PUB.Add;
737: END IF;
738: x_loading_status := 'CN_SPP_CANNOT_SHORTEN_ED';

Line 736: FND_MSG_PUB.Add;

732:
733: IF l_dummy > 0 THEN
734: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
735: FND_MESSAGE.SET_NAME ('CN' , 'CN_SPP_CANNOT_SHORTEN_ED');
736: FND_MSG_PUB.Add;
737: END IF;
738: x_loading_status := 'CN_SPP_CANNOT_SHORTEN_ED';
739: RAISE FND_API.G_EXC_ERROR ;
740: END IF;

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

759: OR ((p_old_end_date IS NULL) AND (prd.end_date IS NOT NULL)
760: AND (prd.end_date >= p_old_start_date))
761: );
762: IF l_dummy > 0 THEN
763: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
764: THEN
765: FND_MESSAGE.SET_NAME ('CN' , 'CN_SPP_UPDATE_NOT_ALLOWED');
766: FND_MSG_PUB.Add;
767: END IF;

Line 766: FND_MSG_PUB.Add;

762: IF l_dummy > 0 THEN
763: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
764: THEN
765: FND_MESSAGE.SET_NAME ('CN' , 'CN_SPP_UPDATE_NOT_ALLOWED');
766: FND_MSG_PUB.Add;
767: END IF;
768: x_loading_status := 'CN_SPP_UPDATE_NOT_ALLOWED';
769: RAISE FND_API.G_EXC_ERROR ;
770: END IF;

Line 786: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

782: WHEN OTHERS THEN
783: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
784: x_loading_status := 'UNEXPECTED_ERR';
785:
786: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
787: THEN
788: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
789: END IF;
790:

Line 788: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );

784: x_loading_status := 'UNEXPECTED_ERR';
785:
786: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
787: THEN
788: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
789: END IF;
790:
791: END check_operation_allowed;
792:

Line 933: FND_MSG_PUB.initialize;

929: END IF;
930:
931: -- Initialize message list if p_init_msg_list is set to TRUE.
932: IF FND_API.to_Boolean( p_init_msg_list ) THEN
933: FND_MSG_PUB.initialize;
934: END IF;
935:
936: -- Initialize API return status to success
937: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1033: FND_MSG_PUB.Count_And_Get

1029: COMMIT WORK;
1030: END IF;
1031:
1032: -- Standard call to get message count and if count is 1, get message info
1033: FND_MSG_PUB.Count_And_Get
1034: (
1035: p_count => x_msg_count ,
1036: p_data => x_msg_data ,
1037: p_encoded => FND_API.G_FALSE

Line 1044: FND_MSG_PUB.Count_And_Get

1040: EXCEPTION
1041: WHEN FND_API.G_EXC_ERROR THEN
1042: ROLLBACK TO Create_Srp_Pmt_Plan;
1043: x_return_status := FND_API.G_RET_STS_ERROR ;
1044: FND_MSG_PUB.Count_And_Get
1045: (
1046: p_count => x_msg_count ,
1047: p_data => x_msg_data ,
1048: p_encoded => FND_API.G_FALSE

Line 1054: FND_MSG_PUB.Count_And_Get

1050: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1051: ROLLBACK TO Create_Srp_Pmt_Plan;
1052: x_loading_status := 'UNEXPECTED_ERR';
1053: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1054: FND_MSG_PUB.Count_And_Get
1055: (
1056: p_count => x_msg_count ,
1057: p_data => x_msg_data ,
1058: p_encoded => FND_API.G_FALSE

Line 1064: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1060: WHEN OTHERS THEN
1061: ROLLBACK TO Create_Srp_Pmt_Plan;
1062: x_loading_status := 'UNEXPECTED_ERR';
1063: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1064: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1065: THEN
1066: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1067: END IF;
1068: FND_MSG_PUB.Count_And_Get

Line 1066: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );

1062: x_loading_status := 'UNEXPECTED_ERR';
1063: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1064: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1065: THEN
1066: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1067: END IF;
1068: FND_MSG_PUB.Count_And_Get
1069: (
1070: p_count => x_msg_count ,

Line 1068: FND_MSG_PUB.Count_And_Get

1064: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1065: THEN
1066: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1067: END IF;
1068: FND_MSG_PUB.Count_And_Get
1069: (
1070: p_count => x_msg_count ,
1071: p_data => x_msg_data ,
1072: p_encoded => FND_API.G_FALSE

Line 1124: FND_MSG_PUB.initialize;

1120: END IF;
1121:
1122: -- Initialize message list if p_init_msg_list is set to TRUE.
1123: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1124: FND_MSG_PUB.initialize;
1125: END IF;
1126:
1127: -- Initialize API return status to success
1128: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1139: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

1135:
1136: IF (l_oldrec.object_version_number <>
1137: p_pmt_plan_assign_rec.object_version_number) THEN
1138:
1139: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1140: THEN
1141: fnd_message.set_name('CN', 'CN_INVALID_OBJECT_VERSION');
1142: fnd_msg_pub.add;
1143: END IF;

Line 1142: fnd_msg_pub.add;

1138:
1139: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1140: THEN
1141: fnd_message.set_name('CN', 'CN_INVALID_OBJECT_VERSION');
1142: fnd_msg_pub.add;
1143: END IF;
1144:
1145: x_loading_status := 'CN_INVALID_OBJECT_VERSION';
1146: RAISE FND_API.G_EXC_ERROR;

Line 1152: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

1148: END IF;
1149:
1150: -- can't change lock flag from Y to N
1151: IF l_oldrec.lock_flag = 'Y' AND p_pmt_plan_assign_rec.lock_flag = 'N' THEN
1152: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1153: THEN
1154: fnd_message.set_name('CN', 'CN_CANNOT_UPDATE_LOCK');
1155: fnd_msg_pub.add;
1156: END IF;

Line 1155: fnd_msg_pub.add;

1151: IF l_oldrec.lock_flag = 'Y' AND p_pmt_plan_assign_rec.lock_flag = 'N' THEN
1152: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1153: THEN
1154: fnd_message.set_name('CN', 'CN_CANNOT_UPDATE_LOCK');
1155: fnd_msg_pub.add;
1156: END IF;
1157: x_loading_status := 'CN_CANNOT_UPDATE_LOCK';
1158: RAISE FND_API.G_EXC_ERROR;
1159: END IF;

Line 1164: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

1160:
1161: -- can't change lock from N to Y if it is manual assignment
1162: IF l_oldrec.lock_flag = 'N' AND p_pmt_plan_assign_rec.lock_flag = 'Y' AND
1163: p_pmt_plan_assign_rec.role_pmt_plan_id IS NULL THEN
1164: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1165: THEN
1166: fnd_message.set_name('CN', 'CN_CANNOT_UPDATE_LOCK');
1167: fnd_msg_pub.add;
1168: END IF;

Line 1167: fnd_msg_pub.add;

1163: p_pmt_plan_assign_rec.role_pmt_plan_id IS NULL THEN
1164: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1165: THEN
1166: fnd_message.set_name('CN', 'CN_CANNOT_UPDATE_LOCK');
1167: fnd_msg_pub.add;
1168: END IF;
1169: x_loading_status := 'CN_CANNOT_UPDATE_LOCK';
1170: RAISE FND_API.G_EXC_ERROR;
1171: END IF;

Line 1375: FND_MSG_PUB.Count_And_Get

1371: COMMIT WORK;
1372: END IF;
1373:
1374: -- Standard call to get message count and if count is 1, get message info
1375: FND_MSG_PUB.Count_And_Get
1376: (
1377: p_count => x_msg_count ,
1378: p_data => x_msg_data ,
1379: p_encoded => FND_API.G_FALSE

Line 1386: FND_MSG_PUB.Count_And_Get

1382: EXCEPTION
1383: WHEN FND_API.G_EXC_ERROR THEN
1384: ROLLBACK TO Update_Srp_Pmt_Plan;
1385: x_return_status := FND_API.G_RET_STS_ERROR ;
1386: FND_MSG_PUB.Count_And_Get
1387: (
1388: p_count => x_msg_count ,
1389: p_data => x_msg_data ,
1390: p_encoded => FND_API.G_FALSE

Line 1396: FND_MSG_PUB.Count_And_Get

1392: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1393: ROLLBACK TO Update_Srp_Pmt_Plan;
1394: x_loading_status := 'UNEXPECTED_ERR';
1395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1396: FND_MSG_PUB.Count_And_Get
1397: (
1398: p_count => x_msg_count ,
1399: p_data => x_msg_data ,
1400: p_encoded => FND_API.G_FALSE

Line 1406: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1402: WHEN OTHERS THEN
1403: ROLLBACK TO Update_Srp_Pmt_Plan;
1404: x_loading_status := 'UNEXPECTED_ERR';
1405: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1406: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1407: THEN
1408: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1409: END IF;
1410: FND_MSG_PUB.Count_And_Get

Line 1408: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );

1404: x_loading_status := 'UNEXPECTED_ERR';
1405: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1406: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1407: THEN
1408: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1409: END IF;
1410: FND_MSG_PUB.Count_And_Get
1411: (
1412: p_count => x_msg_count ,

Line 1410: FND_MSG_PUB.Count_And_Get

1406: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1407: THEN
1408: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1409: END IF;
1410: FND_MSG_PUB.Count_And_Get
1411: (
1412: p_count => x_msg_count ,
1413: p_data => x_msg_data ,
1414: p_encoded => FND_API.G_FALSE

Line 1443: FND_MSG_PUB.initialize;

1439:
1440: BEGIN
1441: -- Initialize message list if p_init_msg_list is set to TRUE.
1442: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1443: FND_MSG_PUB.initialize;
1444: END IF;
1445:
1446: -- Initialize API return status to success
1447: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1459: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1455: FETCH spp_csr INTO l_spp_rec;
1456: CLOSE spp_csr;
1457: /*
1458: IF (NVL(l_spp_rec.lock_flag, 'N') = 'Y') THEN
1459: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1460: FND_MESSAGE.Set_Name('CN', 'CN_SRP_PMT_PLAN_LOCKED');
1461: FND_MSG_PUB.Add;
1462: END IF;
1463: x_loading_status := 'CN_SRP_PMT_PLAN_LOCKED';

Line 1461: FND_MSG_PUB.Add;

1457: /*
1458: IF (NVL(l_spp_rec.lock_flag, 'N') = 'Y') THEN
1459: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1460: FND_MESSAGE.Set_Name('CN', 'CN_SRP_PMT_PLAN_LOCKED');
1461: FND_MSG_PUB.Add;
1462: END IF;
1463: x_loading_status := 'CN_SRP_PMT_PLAN_LOCKED';
1464: RAISE FND_API.G_EXC_ERROR ;
1465: END IF;

Line 1484: FND_MSG_PUB.Count_And_Get

1480: */
1481: EXCEPTION
1482: WHEN FND_API.G_EXC_ERROR THEN
1483: x_return_status := FND_API.G_RET_STS_ERROR ;
1484: FND_MSG_PUB.Count_And_Get
1485:
1486: (
1487: p_count => x_msg_count ,
1488: p_data => x_msg_data ,

Line 1494: FND_MSG_PUB.Count_And_Get

1490: );
1491: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1492: x_loading_status := 'UNEXPECTED_ERR';
1493: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1494: FND_MSG_PUB.Count_And_Get
1495: (
1496: p_count => x_msg_count ,
1497: p_data => x_msg_data ,
1498: p_encoded => FND_API.G_FALSE

Line 1503: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1499: );
1500: WHEN OTHERS THEN
1501: x_loading_status := 'UNEXPECTED_ERR';
1502: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1503: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1504: THEN
1505: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1506: END IF;
1507: FND_MSG_PUB.Count_And_Get

Line 1505: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );

1501: x_loading_status := 'UNEXPECTED_ERR';
1502: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1503: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1504: THEN
1505: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1506: END IF;
1507: FND_MSG_PUB.Count_And_Get
1508: (
1509: p_count => x_msg_count ,

Line 1507: FND_MSG_PUB.Count_And_Get

1503: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1504: THEN
1505: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1506: END IF;
1507: FND_MSG_PUB.Count_And_Get
1508: (
1509: p_count => x_msg_count ,
1510: p_data => x_msg_data ,
1511: p_encoded => FND_API.G_FALSE

Line 1563: FND_MSG_PUB.initialize;

1559: END IF;
1560:
1561: -- Initialize message list if p_init_msg_list is set to TRUE.
1562: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1563: FND_MSG_PUB.initialize;
1564: END IF;
1565:
1566: -- Initialize API return status to success
1567: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1631: FND_MSG_PUB.Count_And_Get

1627:
1628:
1629: -- Standard call to get message count and if count is 1, get message info.
1630:
1631: FND_MSG_PUB.Count_And_Get
1632: (
1633: p_count => x_msg_count ,
1634: p_data => x_msg_data ,
1635: p_encoded => FND_API.G_FALSE

Line 1642: FND_MSG_PUB.Count_And_Get

1638: EXCEPTION
1639: WHEN FND_API.G_EXC_ERROR THEN
1640: ROLLBACK TO Delete_Srp_Pmt_Plan;
1641: x_return_status := FND_API.G_RET_STS_ERROR ;
1642: FND_MSG_PUB.Count_And_Get
1643: (
1644: p_count => x_msg_count ,
1645: p_data => x_msg_data ,
1646: p_encoded => FND_API.G_FALSE

Line 1652: FND_MSG_PUB.Count_And_Get

1648: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1649: ROLLBACK TO Delete_Srp_Pmt_Plan;
1650: x_loading_status := 'UNEXPECTED_ERR';
1651: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1652: FND_MSG_PUB.Count_And_Get
1653: (
1654: p_count => x_msg_count ,
1655: p_data => x_msg_data ,
1656: p_encoded => FND_API.G_FALSE

Line 1662: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1658: WHEN OTHERS THEN
1659: ROLLBACK TO Delete_Srp_Pmt_Plan;
1660: x_loading_status := 'UNEXPECTED_ERR';
1661: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1662: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1663: THEN
1664: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1665: END IF;
1666: FND_MSG_PUB.Count_And_Get

Line 1664: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );

1660: x_loading_status := 'UNEXPECTED_ERR';
1661: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1662: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1663: THEN
1664: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1665: END IF;
1666: FND_MSG_PUB.Count_And_Get
1667: (
1668: p_count => x_msg_count ,

Line 1666: FND_MSG_PUB.Count_And_Get

1662: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1663: THEN
1664: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1665: END IF;
1666: FND_MSG_PUB.Count_And_Get
1667: (
1668: p_count => x_msg_count ,
1669: p_data => x_msg_data ,
1670: p_encoded => FND_API.G_FALSE

Line 1732: FND_MSG_PUB.initialize;

1728: END IF;
1729:
1730: -- Initialize message list if p_init_msg_list is set to TRUE.
1731: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1732: FND_MSG_PUB.initialize;
1733: END IF;
1734:
1735: -- Initialize API return status to success
1736: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1824: FND_MSG_PUB.Count_And_Get

1820: COMMIT WORK;
1821: END IF;
1822:
1823: -- Standard call to get message count and if count is 1, get message info
1824: FND_MSG_PUB.Count_And_Get
1825: (
1826: p_count => x_msg_count ,
1827: p_data => x_msg_data ,
1828: p_encoded => FND_API.G_FALSE

Line 1835: FND_MSG_PUB.Count_And_Get

1831: EXCEPTION
1832: WHEN FND_API.G_EXC_ERROR THEN
1833: ROLLBACK TO Create_Mass_Asgn_Srp_Pmt_Plan;
1834: x_return_status := FND_API.G_RET_STS_ERROR ;
1835: FND_MSG_PUB.Count_And_Get
1836: (
1837: p_count => x_msg_count ,
1838: p_data => x_msg_data ,
1839: p_encoded => FND_API.G_FALSE

Line 1845: FND_MSG_PUB.Count_And_Get

1841: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1842: ROLLBACK TO Create_Mass_Asgn_Srp_Pmt_Plan;
1843: x_loading_status := 'UNEXPECTED_ERR';
1844: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1845: FND_MSG_PUB.Count_And_Get
1846: (
1847: p_count => x_msg_count ,
1848: p_data => x_msg_data ,
1849: p_encoded => FND_API.G_FALSE

Line 1855: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1851: WHEN OTHERS THEN
1852: ROLLBACK TO Create_Mass_Asgn_Srp_Pmt_Plan;
1853: x_loading_status := 'UNEXPECTED_ERR';
1854: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1855: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1856: THEN
1857: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1858: END IF;
1859: FND_MSG_PUB.Count_And_Get

Line 1857: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );

1853: x_loading_status := 'UNEXPECTED_ERR';
1854: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1855: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1856: THEN
1857: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1858: END IF;
1859: FND_MSG_PUB.Count_And_Get
1860: (
1861: p_count => x_msg_count ,

Line 1859: FND_MSG_PUB.Count_And_Get

1855: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1856: THEN
1857: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1858: END IF;
1859: FND_MSG_PUB.Count_And_Get
1860: (
1861: p_count => x_msg_count ,
1862: p_data => x_msg_data ,
1863: p_encoded => FND_API.G_FALSE

Line 1938: FND_MSG_PUB.initialize;

1934: END IF;
1935:
1936: -- Initialize message list if p_init_msg_list is set to TRUE.
1937: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1938: FND_MSG_PUB.initialize;
1939: END IF;
1940:
1941: -- Initialize API return status to success
1942: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2085: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2081: x_return_status := l_return_status;
2082: x_loading_status := l_loading_status;
2083:
2084: ELSE
2085: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2086: FND_MESSAGE.Set_Name('CN', 'CN_SPP_UPDATE_NOT_ALLOWED');
2087: FND_MSG_PUB.Add;
2088: END IF;
2089: RAISE FND_API.G_EXC_ERROR;

Line 2087: FND_MSG_PUB.Add;

2083:
2084: ELSE
2085: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2086: FND_MESSAGE.Set_Name('CN', 'CN_SPP_UPDATE_NOT_ALLOWED');
2087: FND_MSG_PUB.Add;
2088: END IF;
2089: RAISE FND_API.G_EXC_ERROR;
2090: END IF;
2091:

Line 2163: FND_MSG_PUB.Count_And_Get

2159: COMMIT WORK;
2160: END IF;
2161:
2162: -- Standard call to get message count and if count is 1, get message info
2163: FND_MSG_PUB.Count_And_Get
2164: (
2165: p_count => x_msg_count ,
2166: p_data => x_msg_data ,
2167: p_encoded => FND_API.G_FALSE

Line 2174: FND_MSG_PUB.Count_And_Get

2170: EXCEPTION
2171: WHEN FND_API.G_EXC_ERROR THEN
2172: ROLLBACK TO Update_Mass_Asgn_Srp_Pmt_plan;
2173: x_return_status := FND_API.G_RET_STS_ERROR ;
2174: FND_MSG_PUB.Count_And_Get
2175: (
2176: p_count => x_msg_count ,
2177: p_data => x_msg_data ,
2178: p_encoded => FND_API.G_FALSE

Line 2184: FND_MSG_PUB.Count_And_Get

2180: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2181: ROLLBACK TO Update_Mass_Asgn_Srp_Pmt_plan;
2182: x_loading_status := 'UNEXPECTED_ERR';
2183: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2184: FND_MSG_PUB.Count_And_Get
2185: (
2186: p_count => x_msg_count ,
2187: p_data => x_msg_data ,
2188: p_encoded => FND_API.G_FALSE

Line 2194: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2190: WHEN OTHERS THEN
2191: ROLLBACK TO Update_Mass_Asgn_Srp_Pmt_plan;
2192: x_loading_status := 'UNEXPECTED_ERR';
2193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2194: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2195: THEN
2196: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
2197: END IF;
2198: FND_MSG_PUB.Count_And_Get

Line 2196: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );

2192: x_loading_status := 'UNEXPECTED_ERR';
2193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2194: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2195: THEN
2196: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
2197: END IF;
2198: FND_MSG_PUB.Count_And_Get
2199: (
2200: p_count => x_msg_count ,

Line 2198: FND_MSG_PUB.Count_And_Get

2194: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2195: THEN
2196: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
2197: END IF;
2198: FND_MSG_PUB.Count_And_Get
2199: (
2200: p_count => x_msg_count ,
2201: p_data => x_msg_data ,
2202: p_encoded => FND_API.G_FALSE

Line 2275: FND_MSG_PUB.initialize;

2271: END IF;
2272:
2273: -- Initialize message list if p_init_msg_list is set to TRUE.
2274: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2275: FND_MSG_PUB.initialize;
2276: END IF;
2277:
2278: -- Initialize API return status to success
2279: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2350: -- IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2346: OR ((l_spp_rec.end_date IS NULL) AND (prd.end_date IS NULL))
2347: );
2348:
2349: IF l_dummy > 0 then
2350: -- IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2351: -- FND_MESSAGE.SET_NAME ('CN' , 'CN_SRP_PMT_PLAN_USED');
2352: -- FND_MSG_PUB.Add;
2353: update cn_srp_pmt_plans set srp_role_id = null, role_pmt_plan_id = null
2354: where srp_pmt_plan_id = l_srp_pmt_plan_id;

Line 2352: -- FND_MSG_PUB.Add;

2348:
2349: IF l_dummy > 0 then
2350: -- IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2351: -- FND_MESSAGE.SET_NAME ('CN' , 'CN_SRP_PMT_PLAN_USED');
2352: -- FND_MSG_PUB.Add;
2353: update cn_srp_pmt_plans set srp_role_id = null, role_pmt_plan_id = null
2354: where srp_pmt_plan_id = l_srp_pmt_plan_id;
2355:
2356: ElSIF l_dummy = 0 THEN

Line 2389: FND_MSG_PUB.Count_And_Get

2385: COMMIT WORK;
2386: END IF;
2387:
2388: -- Standard call to get message count and if count is 1, get message info
2389: FND_MSG_PUB.Count_And_Get
2390: (
2391: p_count => x_msg_count ,
2392: p_data => x_msg_data ,
2393: p_encoded => FND_API.G_FALSE

Line 2400: FND_MSG_PUB.Count_And_Get

2396: EXCEPTION
2397: WHEN FND_API.G_EXC_ERROR THEN
2398: ROLLBACK TO Delete_Mass_Asgn_Srp_Pmt_Plan;
2399: x_return_status := FND_API.G_RET_STS_ERROR ;
2400: FND_MSG_PUB.Count_And_Get
2401: (
2402: p_count => x_msg_count ,
2403: p_data => x_msg_data ,
2404: p_encoded => FND_API.G_FALSE

Line 2410: FND_MSG_PUB.Count_And_Get

2406: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2407: ROLLBACK TO Delete_Mass_Asgn_Srp_Pmt_Plan;
2408: x_loading_status := 'UNEXPECTED_ERR';
2409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2410: FND_MSG_PUB.Count_And_Get
2411: (
2412: p_count => x_msg_count ,
2413: p_data => x_msg_data ,
2414: p_encoded => FND_API.G_FALSE

Line 2420: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2416: WHEN OTHERS THEN
2417: ROLLBACK TO Delete_Mass_Asgn_Srp_Pmt_Plan;
2418: x_loading_status := 'UNEXPECTED_ERR';
2419: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2420: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2421: THEN
2422: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
2423: END IF;
2424: FND_MSG_PUB.Count_And_Get

Line 2422: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );

2418: x_loading_status := 'UNEXPECTED_ERR';
2419: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2420: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2421: THEN
2422: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
2423: END IF;
2424: FND_MSG_PUB.Count_And_Get
2425: (
2426: p_count => x_msg_count ,

Line 2424: FND_MSG_PUB.Count_And_Get

2420: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2421: THEN
2422: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
2423: END IF;
2424: FND_MSG_PUB.Count_And_Get
2425: (
2426: p_count => x_msg_count ,
2427: p_data => x_msg_data ,
2428: p_encoded => FND_API.G_FALSE