DBA Data[Home] [Help]

APPS.JTF_RS_ROLE_RELATE_VUHK dependencies on FND_MSG_PUB

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

291: EXCEPTION
292: WHEN OTHERS THEN
293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
294: x_loading_status := 'UNEXPECTED_ERR';
295: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
296: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name );
297: END IF;
298: FND_MSG_PUB.Count_And_Get
299: (p_count => x_msg_count ,

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

292: WHEN OTHERS THEN
293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
294: x_loading_status := 'UNEXPECTED_ERR';
295: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
296: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name );
297: END IF;
298: FND_MSG_PUB.Count_And_Get
299: (p_count => x_msg_count ,
300: p_data => x_msg_data ,

Line 298: FND_MSG_PUB.Count_And_Get

294: x_loading_status := 'UNEXPECTED_ERR';
295: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
296: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name );
297: END IF;
298: FND_MSG_PUB.Count_And_Get
299: (p_count => x_msg_count ,
300: p_data => x_msg_data ,
301: p_encoded => FND_API.G_FALSE);
302: END ins_srp_intel_prd;

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

727:
728: -- Added by chanthon for bug 5525795 - User friendly error message requested
729: -- before throwing the vertical hook error.
730: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
731: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
732: THEN
733: fnd_message.set_name ('CN', 'CN_SRP_PG_WS');
734: FND_MSG_PUB.add;
735: END IF;

Line 734: FND_MSG_PUB.add;

730: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
731: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
732: THEN
733: fnd_message.set_name ('CN', 'CN_SRP_PG_WS');
734: FND_MSG_PUB.add;
735: END IF;
736: x_loading_status := 'CN_SRP_PG_WS';
737: ElSE */
738: -- End: Added by chanthon --

Line 1100: FND_MSG_PUB.ADD;

1096: l_usage = 'SALES_COMP' THEN
1097: FND_MESSAGE.SET_NAME('CN', 'CN_RES_MUST_BE_SRP');
1098: -- A sales compensation role cannot be assigned to a resource
1099: -- that is not a salesperson.
1100: FND_MSG_PUB.ADD;
1101: RAISE FND_API.G_EXC_ERROR;
1102: end if;
1103:
1104: IF p_role_resource_type = 'RS_INDIVIDUAL' THEN

Line 1125: FND_MSG_PUB.ADD;

1121:
1122: if l_count <> 0 then
1123: FND_MESSAGE.SET_NAME('CN', 'CN_SRP_CANNOT_HAVE_ANAL_ROLE');
1124: -- A salesperson cannot be assigned a payment analyst role.
1125: FND_MSG_PUB.ADD;
1126: RAISE FND_API.G_EXC_ERROR;
1127: end if;
1128: end if; -- l_usage = 'SALES_COMP_PAYMENT_ANALIST'
1129:

Line 1149: FND_MSG_PUB.ADD;

1145:
1146: if l_count <> 0 then
1147: FND_MESSAGE.SET_NAME('CN', 'CN_SRP_CANNOT_HAVE_ANAL_ROLE');
1148: -- A salesperson cannot be assigned a payment analyst role.
1149: FND_MSG_PUB.ADD;
1150: RAISE FND_API.G_EXC_ERROR;
1151: end if;
1152:
1153: -- check PAYEE role

Line 1169: FND_MSG_PUB.ADD;

1165: if l_count <> 0 then
1166: FND_MESSAGE.SET_NAME('CN', 'CN_PAYEE_CANNOT_HAVE_SC_ROLE');
1167: -- A salesperson cannot be assigned both the Payee role
1168: -- and another sales compensation role.
1169: FND_MSG_PUB.ADD;
1170: RAISE FND_API.G_EXC_ERROR;
1171: end if;
1172: ELSE -- p_role_id <> G_PAYEE_ROLE
1173: -- NON-payee cannot have payee role

Line 1185: FND_MSG_PUB.ADD;

1181: if l_count <> 0 then
1182: FND_MESSAGE.SET_NAME('CN', 'CN_PAYEE_CANNOT_HAVE_SC_ROLE');
1183: -- A salesperson cannot be assigned both the Payee role
1184: -- and another sales compensation role.
1185: FND_MSG_PUB.ADD;
1186: RAISE FND_API.G_EXC_ERROR;
1187: end if; -- l_count <> 0
1188: end if; -- payee role ck
1189: end if; -- l_usage = 'SALES_COMP' ok

Line 1380: FND_MSG_PUB.Count_And_Get

1376: EXCEPTION
1377: WHEN FND_API.G_EXC_ERROR THEN
1378: P_RETURN_CODE := FND_API.G_RET_STS_ERROR ;
1379: restore_context(l_orig_acc_mode, l_orig_org_id);
1380: FND_MSG_PUB.Count_And_Get
1381: (p_count => p_count ,
1382: p_data => p_data ,
1383: p_encoded => FND_API.G_FALSE );
1384: WHEN OTHERS THEN

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

1383: p_encoded => FND_API.G_FALSE );
1384: WHEN OTHERS THEN
1385: p_return_code := fnd_api.g_ret_sts_unexp_error;
1386: restore_context(l_orig_acc_mode, l_orig_org_id);
1387: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1388: THEN
1389: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name );
1390: END IF;
1391: FND_MSG_PUB.count_and_get

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

1385: p_return_code := fnd_api.g_ret_sts_unexp_error;
1386: restore_context(l_orig_acc_mode, l_orig_org_id);
1387: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1388: THEN
1389: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name );
1390: END IF;
1391: FND_MSG_PUB.count_and_get
1392: (p_count => p_count ,
1393: p_data => p_data ,

Line 1391: FND_MSG_PUB.count_and_get

1387: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1388: THEN
1389: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name );
1390: END IF;
1391: FND_MSG_PUB.count_and_get
1392: (p_count => p_count ,
1393: p_data => p_data ,
1394: p_encoded => FND_API.g_false);
1395: END create_res_role_relate_post;

Line 1531: FND_MSG_PUB.ADD;

1527:
1528: if l_count <> 0 then
1529: FND_MESSAGE.SET_NAME('CN', 'CN_SRP_CANNOT_HAVE_ANAL_ROLE');
1530: -- A salesperson cannot be assigned a payment analyst role.
1531: FND_MSG_PUB.ADD;
1532: RAISE FND_API.G_EXC_ERROR;
1533: end if;
1534: ELSIF l_usage = 'SALES_COMP_PAYMENT_ANALIST' THEN
1535: -- Pmt Analyst role assignment may NOT everlap with Sales Comp role assignment

Line 1561: FND_MSG_PUB.ADD;

1557:
1558: if l_count <> 0 then
1559: FND_MESSAGE.SET_NAME('CN', 'CN_SRP_CANNOT_HAVE_ANAL_ROLE');
1560: -- A salesperson cannot be assigned a payment analyst role.
1561: FND_MSG_PUB.ADD;
1562: RAISE FND_API.G_EXC_ERROR;
1563: end if;
1564: END IF; -- l_usage = 'SALES_COMP_PAYMENT_ANALIST'
1565: END IF; -- RS_INDIVIDUAL

Line 1767: FND_MSG_PUB.Count_And_Get

1763: EXCEPTION
1764: WHEN FND_API.G_EXC_ERROR THEN
1765: P_RETURN_CODE := FND_API.G_RET_STS_ERROR ;
1766: restore_context(l_orig_acc_mode, l_orig_org_id);
1767: FND_MSG_PUB.Count_And_Get
1768: (p_count => p_count ,
1769: p_data => p_data ,
1770: p_encoded => FND_API.G_FALSE );
1771: WHEN OTHERS THEN

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

1770: p_encoded => FND_API.G_FALSE );
1771: WHEN OTHERS THEN
1772: p_return_code := fnd_api.g_ret_sts_unexp_error;
1773: restore_context(l_orig_acc_mode, l_orig_org_id);
1774: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1775: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name );
1776: END IF;
1777: FND_MSG_PUB.count_and_get
1778: (p_count => p_count ,

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

1771: WHEN OTHERS THEN
1772: p_return_code := fnd_api.g_ret_sts_unexp_error;
1773: restore_context(l_orig_acc_mode, l_orig_org_id);
1774: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1775: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name );
1776: END IF;
1777: FND_MSG_PUB.count_and_get
1778: (p_count => p_count ,
1779: p_data => p_data ,

Line 1777: FND_MSG_PUB.count_and_get

1773: restore_context(l_orig_acc_mode, l_orig_org_id);
1774: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1775: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name );
1776: END IF;
1777: FND_MSG_PUB.count_and_get
1778: (p_count => p_count ,
1779: p_data => p_data ,
1780: p_encoded => FND_API.g_false);
1781: END update_res_role_relate_post;

Line 1965: FND_MSG_PUB.ADD;

1961: and spa.start_date <= nvl(sr.end_date, spa.start_date);
1962:
1963: if l_count <> 0 then
1964: FND_MESSAGE.SET_NAME('CN', 'CN_PA_ASGN_DATE');
1965: FND_MSG_PUB.ADD;
1966: RAISE FND_API.G_EXC_ERROR;
1967: end if;
1968: end if;
1969:

Line 2127: FND_MSG_PUB.Count_And_Get

2123: EXCEPTION
2124: WHEN FND_API.G_EXC_ERROR THEN
2125: P_RETURN_CODE := FND_API.G_RET_STS_ERROR ;
2126: restore_context(l_orig_acc_mode, l_orig_org_id);
2127: FND_MSG_PUB.Count_And_Get
2128: (p_count => p_count ,
2129: p_data => p_data ,
2130: p_encoded => FND_API.G_FALSE );
2131: WHEN OTHERS THEN

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

2130: p_encoded => FND_API.G_FALSE );
2131: WHEN OTHERS THEN
2132: p_return_code := fnd_api.g_ret_sts_unexp_error;
2133: restore_context(l_orig_acc_mode, l_orig_org_id);
2134: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2135: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name );
2136: END IF;
2137: FND_MSG_PUB.count_and_get
2138: (p_count => p_count ,

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

2131: WHEN OTHERS THEN
2132: p_return_code := fnd_api.g_ret_sts_unexp_error;
2133: restore_context(l_orig_acc_mode, l_orig_org_id);
2134: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2135: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name );
2136: END IF;
2137: FND_MSG_PUB.count_and_get
2138: (p_count => p_count ,
2139: p_data => p_data ,

Line 2137: FND_MSG_PUB.count_and_get

2133: restore_context(l_orig_acc_mode, l_orig_org_id);
2134: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2135: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name );
2136: END IF;
2137: FND_MSG_PUB.count_and_get
2138: (p_count => p_count ,
2139: p_data => p_data ,
2140: p_encoded => FND_API.g_false);
2141: END;

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

2325: l_payee_assign_date_rec.start_date,
2326: l_payee_assign_date_rec.end_date) = true THEN
2327:
2328: -- Raise Error
2329: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2330: THEN
2331: fnd_message.set_name('CN', 'CN_PA_ASGN_DATE');
2332: fnd_msg_pub.add;
2333: END IF;

Line 2332: fnd_msg_pub.add;

2328: -- Raise Error
2329: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2330: THEN
2331: fnd_message.set_name('CN', 'CN_PA_ASGN_DATE');
2332: fnd_msg_pub.add;
2333: END IF;
2334: RAISE FND_API.G_EXC_ERROR;
2335: END IF;
2336: END LOOP;

Line 2518: FND_MSG_PUB.Count_And_Get

2514: EXCEPTION
2515: WHEN FND_API.G_EXC_ERROR THEN
2516: P_RETURN_CODE := FND_API.G_RET_STS_ERROR ;
2517: restore_context(l_orig_acc_mode, l_orig_org_id);
2518: FND_MSG_PUB.Count_And_Get
2519: (p_count => p_count ,
2520: p_data => p_data ,
2521: p_encoded => FND_API.G_FALSE );
2522: WHEN OTHERS THEN

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

2521: p_encoded => FND_API.G_FALSE );
2522: WHEN OTHERS THEN
2523: p_return_code := fnd_api.g_ret_sts_unexp_error;
2524: restore_context(l_orig_acc_mode, l_orig_org_id);
2525: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2526: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name );
2527: END IF;
2528: FND_MSG_PUB.count_and_get
2529: (p_count => p_count ,

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

2522: WHEN OTHERS THEN
2523: p_return_code := fnd_api.g_ret_sts_unexp_error;
2524: restore_context(l_orig_acc_mode, l_orig_org_id);
2525: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2526: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name );
2527: END IF;
2528: FND_MSG_PUB.count_and_get
2529: (p_count => p_count ,
2530: p_data => p_data ,

Line 2528: FND_MSG_PUB.count_and_get

2524: restore_context(l_orig_acc_mode, l_orig_org_id);
2525: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2526: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name );
2527: END IF;
2528: FND_MSG_PUB.count_and_get
2529: (p_count => p_count ,
2530: p_data => p_data ,
2531: p_encoded => FND_API.g_false);
2532: END update_res_role_relate_pre;