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

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

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

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

Line 572: FND_MSG_PUB.Add;

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

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

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

Line 582: FND_MSG_PUB.Add;

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

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

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

Line 608: FND_MSG_PUB.Add;

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

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

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

Line 618: FND_MSG_PUB.Add;

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

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

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

Line 697: FND_MSG_PUB.Add;

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

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

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

Line 737: FND_MSG_PUB.Add;

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

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

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

Line 767: FND_MSG_PUB.Add;

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

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

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

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

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

Line 934: FND_MSG_PUB.initialize;

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

Line 1034: FND_MSG_PUB.Count_And_Get

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

Line 1045: FND_MSG_PUB.Count_And_Get

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

Line 1055: FND_MSG_PUB.Count_And_Get

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

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

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

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

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

Line 1069: FND_MSG_PUB.Count_And_Get

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

Line 1125: FND_MSG_PUB.initialize;

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

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

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

Line 1143: fnd_msg_pub.add;

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

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

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

Line 1156: fnd_msg_pub.add;

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

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

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

Line 1168: fnd_msg_pub.add;

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

Line 1376: FND_MSG_PUB.Count_And_Get

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

Line 1387: FND_MSG_PUB.Count_And_Get

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

Line 1397: FND_MSG_PUB.Count_And_Get

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

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

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

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

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

Line 1411: FND_MSG_PUB.Count_And_Get

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

Line 1444: FND_MSG_PUB.initialize;

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

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

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

Line 1462: FND_MSG_PUB.Add;

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

Line 1485: FND_MSG_PUB.Count_And_Get

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

Line 1495: FND_MSG_PUB.Count_And_Get

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

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

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

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

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

Line 1508: FND_MSG_PUB.Count_And_Get

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

Line 1564: FND_MSG_PUB.initialize;

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

Line 1632: FND_MSG_PUB.Count_And_Get

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

Line 1643: FND_MSG_PUB.Count_And_Get

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

Line 1653: FND_MSG_PUB.Count_And_Get

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

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

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

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

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

Line 1667: FND_MSG_PUB.Count_And_Get

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

Line 1733: FND_MSG_PUB.initialize;

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

Line 1825: FND_MSG_PUB.Count_And_Get

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

Line 1836: FND_MSG_PUB.Count_And_Get

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

Line 1846: FND_MSG_PUB.Count_And_Get

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

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

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

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

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

Line 1860: FND_MSG_PUB.Count_And_Get

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

Line 1939: FND_MSG_PUB.initialize;

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

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

2107: x_return_status := l_return_status;
2108: x_loading_status := l_loading_status;
2109:
2110: ELSE
2111: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2112: FND_MESSAGE.Set_Name('CN', 'CN_SPP_UPDATE_NOT_ALLOWED');
2113: FND_MSG_PUB.Add;
2114: END IF;
2115: RAISE FND_API.G_EXC_ERROR;

Line 2113: FND_MSG_PUB.Add;

2109:
2110: ELSE
2111: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2112: FND_MESSAGE.Set_Name('CN', 'CN_SPP_UPDATE_NOT_ALLOWED');
2113: FND_MSG_PUB.Add;
2114: END IF;
2115: RAISE FND_API.G_EXC_ERROR;
2116: END IF;
2117:

Line 2189: FND_MSG_PUB.Count_And_Get

2185: COMMIT WORK;
2186: END IF;
2187:
2188: -- Standard call to get message count and if count is 1, get message info
2189: FND_MSG_PUB.Count_And_Get
2190: (
2191: p_count => x_msg_count ,
2192: p_data => x_msg_data ,
2193: p_encoded => FND_API.G_FALSE

Line 2200: FND_MSG_PUB.Count_And_Get

2196: EXCEPTION
2197: WHEN FND_API.G_EXC_ERROR THEN
2198: ROLLBACK TO Update_Mass_Asgn_Srp_Pmt_plan;
2199: x_return_status := FND_API.G_RET_STS_ERROR ;
2200: FND_MSG_PUB.Count_And_Get
2201: (
2202: p_count => x_msg_count ,
2203: p_data => x_msg_data ,
2204: p_encoded => FND_API.G_FALSE

Line 2210: FND_MSG_PUB.Count_And_Get

2206: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2207: ROLLBACK TO Update_Mass_Asgn_Srp_Pmt_plan;
2208: x_loading_status := 'UNEXPECTED_ERR';
2209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2210: FND_MSG_PUB.Count_And_Get
2211: (
2212: p_count => x_msg_count ,
2213: p_data => x_msg_data ,
2214: p_encoded => FND_API.G_FALSE

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

2216: WHEN OTHERS THEN
2217: ROLLBACK TO Update_Mass_Asgn_Srp_Pmt_plan;
2218: x_loading_status := 'UNEXPECTED_ERR';
2219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2220: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2221: THEN
2222: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
2223: END IF;
2224: FND_MSG_PUB.Count_And_Get

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

2218: x_loading_status := 'UNEXPECTED_ERR';
2219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2220: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2221: THEN
2222: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
2223: END IF;
2224: FND_MSG_PUB.Count_And_Get
2225: (
2226: p_count => x_msg_count ,

Line 2224: FND_MSG_PUB.Count_And_Get

2220: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2221: THEN
2222: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
2223: END IF;
2224: FND_MSG_PUB.Count_And_Get
2225: (
2226: p_count => x_msg_count ,
2227: p_data => x_msg_data ,
2228: p_encoded => FND_API.G_FALSE

Line 2301: FND_MSG_PUB.initialize;

2297: END IF;
2298:
2299: -- Initialize message list if p_init_msg_list is set to TRUE.
2300: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2301: FND_MSG_PUB.initialize;
2302: END IF;
2303:
2304: -- Initialize API return status to success
2305: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

2372: OR ((l_spp_rec.end_date IS NULL) AND (prd.end_date IS NULL))
2373: );
2374:
2375: IF l_dummy > 0 then
2376: -- IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2377: -- FND_MESSAGE.SET_NAME ('CN' , 'CN_SRP_PMT_PLAN_USED');
2378: -- FND_MSG_PUB.Add;
2379: update cn_srp_pmt_plans set srp_role_id = null, role_pmt_plan_id = null
2380: where srp_pmt_plan_id = l_srp_pmt_plan_id;

Line 2378: -- FND_MSG_PUB.Add;

2374:
2375: IF l_dummy > 0 then
2376: -- IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2377: -- FND_MESSAGE.SET_NAME ('CN' , 'CN_SRP_PMT_PLAN_USED');
2378: -- FND_MSG_PUB.Add;
2379: update cn_srp_pmt_plans set srp_role_id = null, role_pmt_plan_id = null
2380: where srp_pmt_plan_id = l_srp_pmt_plan_id;
2381:
2382: ElSIF l_dummy = 0 THEN

Line 2415: FND_MSG_PUB.Count_And_Get

2411: COMMIT WORK;
2412: END IF;
2413:
2414: -- Standard call to get message count and if count is 1, get message info
2415: FND_MSG_PUB.Count_And_Get
2416: (
2417: p_count => x_msg_count ,
2418: p_data => x_msg_data ,
2419: p_encoded => FND_API.G_FALSE

Line 2426: FND_MSG_PUB.Count_And_Get

2422: EXCEPTION
2423: WHEN FND_API.G_EXC_ERROR THEN
2424: ROLLBACK TO Delete_Mass_Asgn_Srp_Pmt_Plan;
2425: x_return_status := FND_API.G_RET_STS_ERROR ;
2426: FND_MSG_PUB.Count_And_Get
2427: (
2428: p_count => x_msg_count ,
2429: p_data => x_msg_data ,
2430: p_encoded => FND_API.G_FALSE

Line 2436: FND_MSG_PUB.Count_And_Get

2432: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2433: ROLLBACK TO Delete_Mass_Asgn_Srp_Pmt_Plan;
2434: x_loading_status := 'UNEXPECTED_ERR';
2435: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2436: FND_MSG_PUB.Count_And_Get
2437: (
2438: p_count => x_msg_count ,
2439: p_data => x_msg_data ,
2440: p_encoded => FND_API.G_FALSE

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

2442: WHEN OTHERS THEN
2443: ROLLBACK TO Delete_Mass_Asgn_Srp_Pmt_Plan;
2444: x_loading_status := 'UNEXPECTED_ERR';
2445: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2446: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2447: THEN
2448: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
2449: END IF;
2450: FND_MSG_PUB.Count_And_Get

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

2444: x_loading_status := 'UNEXPECTED_ERR';
2445: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2446: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2447: THEN
2448: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
2449: END IF;
2450: FND_MSG_PUB.Count_And_Get
2451: (
2452: p_count => x_msg_count ,

Line 2450: FND_MSG_PUB.Count_And_Get

2446: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2447: THEN
2448: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
2449: END IF;
2450: FND_MSG_PUB.Count_And_Get
2451: (
2452: p_count => x_msg_count ,
2453: p_data => x_msg_data ,
2454: p_encoded => FND_API.G_FALSE