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_PUB dependencies on CN_SRP_PMT_PLANS_PUB

Line 1: PACKAGE BODY CN_SRP_PMT_PLANS_PUB AS

1: PACKAGE BODY CN_SRP_PMT_PLANS_PUB AS
2: /* $Header: cnpsppab.pls 120.4 2005/10/27 16:03:49 mblum noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_SRP_PMT_PLANS_PUB';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'cnpsppab.pls';

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_SRP_PMT_PLANS_PUB';

1: PACKAGE BODY CN_SRP_PMT_PLANS_PUB AS
2: /* $Header: cnpsppab.pls 120.4 2005/10/27 16:03:49 mblum noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_SRP_PMT_PLANS_PUB';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'cnpsppab.pls';
6:
7: G_EMP_NUM CONSTANT VARCHAR2(80)
8: := cn_api.get_lkup_meaning('EMP_NUM','SRP_OBJECT_TYPE');

Line 330: 'cn.plsql.cn_srp_pmt_plans_pub.create_srp_pmt_plan.org_validate',

326: status => l_status);
327:
328: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
329: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
330: 'cn.plsql.cn_srp_pmt_plans_pub.create_srp_pmt_plan.org_validate',
331: 'Validated org_id = ' || l_org_id || ' status = ' || l_status);
332: end if;
333: l_spp_rec.org_id := l_org_id;
334:

Line 379: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PMT_PLANS_PUB',

375:
376: --
377: -- User hooks
378: --
379: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PMT_PLANS_PUB',
380: 'CREATE_SRP_PMT_PLAN',
381: 'B',
382: 'C')
383: THEN

Line 384: cn_srp_pmt_plans_pub_cuhk.create_srp_pmt_plan_pre

380: 'CREATE_SRP_PMT_PLAN',
381: 'B',
382: 'C')
383: THEN
384: cn_srp_pmt_plans_pub_cuhk.create_srp_pmt_plan_pre
385: (p_api_version => p_api_version,
386: p_init_msg_list => fnd_api.g_false,
387: p_commit => fnd_api.g_false,
388: p_validation_level => p_validation_level,

Line 406: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PMT_PLANS_PUB',

402: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
403: END IF;
404: END IF;
405:
406: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PMT_PLANS_PUB',
407: 'CREATE_SRP_PMT_PLAN',
408: 'B',
409: 'V')
410: THEN

Line 411: cn_srp_pmt_plans_pub_vuhk.create_srp_pmt_plan_pre

407: 'CREATE_SRP_PMT_PLAN',
408: 'B',
409: 'V')
410: THEN
411: cn_srp_pmt_plans_pub_vuhk.create_srp_pmt_plan_pre
412: (p_api_version => p_api_version,
413: p_init_msg_list => fnd_api.g_false,
414: p_commit => fnd_api.g_false,
415: p_validation_level => p_validation_level,

Line 470: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PMT_PLANS_PUB',

466:
467: --
468: -- Post processing hooks
469: --
470: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PMT_PLANS_PUB',
471: 'CREATE_SRP_PMT_PLAN',
472: 'A',
473: 'V')
474: THEN

Line 475: cn_srp_pmt_plans_pub_vuhk.create_srp_pmt_plan_post

471: 'CREATE_SRP_PMT_PLAN',
472: 'A',
473: 'V')
474: THEN
475: cn_srp_pmt_plans_pub_vuhk.create_srp_pmt_plan_post
476: (p_api_version => p_api_version,
477: p_init_msg_list => fnd_api.g_false,
478: p_commit => fnd_api.g_false,
479: p_validation_level => p_validation_level,

Line 497: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PMT_PLANS_PUB',

493: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
494: END IF;
495: END IF;
496:
497: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PMT_PLANS_PUB',
498: 'CREATE_SRP_PMT_PLAN',
499: 'A',
500: 'C')
501: THEN

Line 502: cn_srp_pmt_plans_pub_cuhk.create_srp_pmt_plan_post

498: 'CREATE_SRP_PMT_PLAN',
499: 'A',
500: 'C')
501: THEN
502: cn_srp_pmt_plans_pub_cuhk.create_srp_pmt_plan_post
503: (p_api_version => p_api_version,
504: p_init_msg_list => fnd_api.g_false,
505: p_commit => fnd_api.g_false,
506: p_validation_level => p_validation_level,

Line 527: IF JTF_USR_HKS.Ok_to_execute('CN_SRP_PMT_PLANS_PUB',

523:
524: --
525: -- Message enable hook
526: --
527: IF JTF_USR_HKS.Ok_to_execute('CN_SRP_PMT_PLANS_PUB',
528: 'CREATE_SRP_PMT_PLAN',
529: 'M',
530: 'M')
531: THEN

Line 532: IF cn_srp_pmt_plans_pub_cuhk.ok_to_generate_msg

528: 'CREATE_SRP_PMT_PLAN',
529: 'M',
530: 'M')
531: THEN
532: IF cn_srp_pmt_plans_pub_cuhk.ok_to_generate_msg
533: (p_srp_pmt_plans_rec => l_spp_rec)
534: THEN
535: -- Clear bind variables
536: -- XMLGEN.clearBindValues;

Line 697: 'cn.plsql.cn_srp_pmt_plans_pub.update_srp_pmt_plan.error',

693: Nvl(l_spp_rec.org_id, -99) then
694: FND_MESSAGE.SET_NAME ('FND' , 'FND_MO_OU_CANNOT_UPDATE');
695: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
696: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
697: 'cn.plsql.cn_srp_pmt_plans_pub.update_srp_pmt_plan.error',
698: true);
699: end if;
700:
701: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 716: 'cn.plsql.cn_srp_pmt_plans_pub.update_srp_pmt_plan.org_validate',

712: status => l_status);
713:
714: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
715: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
716: 'cn.plsql.cn_srp_pmt_plans_pub.update_srp_pmt_plan.org_validate',
717: 'Validated org_id = ' || l_org_id || ' status = ' || l_status);
718: end if;
719: l_old_spp_rec.org_id := l_org_id;
720: l_spp_rec.org_id := l_org_id;

Line 811: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PMT_PLANS_PUB',

807:
808: --
809: -- User hooks
810: --
811: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PMT_PLANS_PUB',
812: 'UPDATE_SRP_PMT_PLAN',
813: 'B',
814: 'C')
815: THEN

Line 816: cn_srp_pmt_plans_pub_cuhk.update_srp_pmt_plan_pre

812: 'UPDATE_SRP_PMT_PLAN',
813: 'B',
814: 'C')
815: THEN
816: cn_srp_pmt_plans_pub_cuhk.update_srp_pmt_plan_pre
817: (p_api_version => p_api_version,
818: p_init_msg_list => fnd_api.g_false,
819: p_commit => fnd_api.g_false,
820: p_validation_level => p_validation_level,

Line 838: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PMT_PLANS_PUB',

834: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
835: END IF;
836: END IF;
837:
838: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PMT_PLANS_PUB',
839: 'UPDATE_SRP_PMT_PLAN',
840: 'B',
841: 'V')
842: THEN

Line 843: cn_srp_pmt_plans_pub_vuhk.update_srp_pmt_plan_pre

839: 'UPDATE_SRP_PMT_PLAN',
840: 'B',
841: 'V')
842: THEN
843: cn_srp_pmt_plans_pub_vuhk.update_srp_pmt_plan_pre
844: (p_api_version => p_api_version,
845: p_init_msg_list => fnd_api.g_false,
846: p_commit => fnd_api.g_false,
847: p_validation_level => p_validation_level,

Line 902: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PMT_PLANS_PUB',

898:
899: --
900: -- Post processing hooks
901: --
902: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PMT_PLANS_PUB',
903: 'UPDATE_SRP_PMT_PLAN',
904: 'A',
905: 'V')
906: THEN

Line 907: cn_srp_pmt_plans_pub_vuhk.update_srp_pmt_plan_post

903: 'UPDATE_SRP_PMT_PLAN',
904: 'A',
905: 'V')
906: THEN
907: cn_srp_pmt_plans_pub_vuhk.update_srp_pmt_plan_post
908: (p_api_version => p_api_version,
909: p_init_msg_list => fnd_api.g_false,
910: p_commit => fnd_api.g_false,
911: p_validation_level => p_validation_level,

Line 929: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PMT_PLANS_PUB',

925: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
926: END IF;
927: END IF;
928:
929: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PMT_PLANS_PUB',
930: 'UPDATE_SRP_PMT_PLAN',
931: 'A',
932: 'C')
933: THEN

Line 934: cn_srp_pmt_plans_pub_cuhk.update_srp_pmt_plan_post

930: 'UPDATE_SRP_PMT_PLAN',
931: 'A',
932: 'C')
933: THEN
934: cn_srp_pmt_plans_pub_cuhk.update_srp_pmt_plan_post
935: (p_api_version => p_api_version,
936: p_init_msg_list => fnd_api.g_false,
937: p_commit => fnd_api.g_false,
938: p_validation_level => p_validation_level,

Line 959: IF JTF_USR_HKS.Ok_to_execute('CN_SRP_PMT_PLANS_PUB',

955:
956: --
957: -- Message enable hook
958: --
959: IF JTF_USR_HKS.Ok_to_execute('CN_SRP_PMT_PLANS_PUB',
960: 'CREATE_SRP_PMT_PLAN',
961: 'M',
962: 'M')
963: THEN

Line 964: IF cn_srp_pmt_plans_pub_cuhk.ok_to_generate_msg

960: 'CREATE_SRP_PMT_PLAN',
961: 'M',
962: 'M')
963: THEN
964: IF cn_srp_pmt_plans_pub_cuhk.ok_to_generate_msg
965: (p_srp_pmt_plans_rec => l_spp_rec)
966: THEN
967: -- Clear bind variables
968: -- XMLGEN.clearBindValues;

Line 1123: 'cn.plsql.cn_srp_pmt_plans_pub.delete_srp_pmt_plan.org_validate',

1119: status => l_status);
1120:
1121: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1122: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1123: 'cn.plsql.cn_srp_pmt_plans_pub.delete_srp_pmt_plan.org_validate',
1124: 'Validated org_id = ' || l_org_id || ' status = ' || l_status);
1125: end if;
1126: l_spp_rec.org_id := l_org_id;
1127:

Line 1172: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PMT_PLANS_PUB',

1168:
1169: --
1170: -- User hooks
1171: --
1172: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PMT_PLANS_PUB',
1173: 'DELETE_SRP_PMT_PLAN',
1174: 'B',
1175: 'C')
1176: THEN

Line 1177: cn_srp_pmt_plans_pub_cuhk.delete_srp_pmt_plan_pre

1173: 'DELETE_SRP_PMT_PLAN',
1174: 'B',
1175: 'C')
1176: THEN
1177: cn_srp_pmt_plans_pub_cuhk.delete_srp_pmt_plan_pre
1178: (p_api_version => p_api_version,
1179: p_init_msg_list => fnd_api.g_false,
1180: p_commit => fnd_api.g_false,
1181: p_validation_level => p_validation_level,

Line 1197: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PMT_PLANS_PUB',

1193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1194: END IF;
1195: END IF;
1196:
1197: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PMT_PLANS_PUB',
1198: 'DELETE_SRP_PMT_PLAN',
1199: 'B',
1200: 'V')
1201: THEN

Line 1202: cn_srp_pmt_plans_pub_vuhk.delete_srp_pmt_plan_pre

1198: 'DELETE_SRP_PMT_PLAN',
1199: 'B',
1200: 'V')
1201: THEN
1202: cn_srp_pmt_plans_pub_vuhk.delete_srp_pmt_plan_pre
1203: (p_api_version => p_api_version,
1204: p_init_msg_list => fnd_api.g_false,
1205: p_commit => fnd_api.g_false,
1206: p_validation_level => p_validation_level,

Line 1247: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PMT_PLANS_PUB',

1243:
1244: --
1245: -- Post processing hooks
1246: --
1247: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PMT_PLANS_PUB',
1248: 'DELETE_SRP_PMT_PLAN',
1249: 'A',
1250: 'V')
1251: THEN

Line 1252: cn_srp_pmt_plans_pub_vuhk.delete_srp_pmt_plan_post

1248: 'DELETE_SRP_PMT_PLAN',
1249: 'A',
1250: 'V')
1251: THEN
1252: cn_srp_pmt_plans_pub_vuhk.delete_srp_pmt_plan_post
1253: (p_api_version => p_api_version,
1254: p_init_msg_list => fnd_api.g_false,
1255: p_commit => fnd_api.g_false,
1256: p_validation_level => p_validation_level,

Line 1273: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PMT_PLANS_PUB',

1269: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1270: END IF;
1271: END IF;
1272:
1273: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PMT_PLANS_PUB',
1274: 'DELETE_SRP_PMT_PLAN',
1275: 'A',
1276: 'C')
1277: THEN

Line 1278: cn_srp_pmt_plans_pub_cuhk.delete_srp_pmt_plan_post

1274: 'DELETE_SRP_PMT_PLAN',
1275: 'A',
1276: 'C')
1277: THEN
1278: cn_srp_pmt_plans_pub_cuhk.delete_srp_pmt_plan_post
1279: (p_api_version => p_api_version,
1280: p_init_msg_list => fnd_api.g_false,
1281: p_commit => fnd_api.g_false,
1282: p_validation_level => p_validation_level,

Line 1301: IF JTF_USR_HKS.Ok_to_execute('CN_SRP_PMT_PLANS_PUB',

1297: END IF;
1298: --
1299: -- Message enable hook
1300: --
1301: IF JTF_USR_HKS.Ok_to_execute('CN_SRP_PMT_PLANS_PUB',
1302: 'DELETE_SRP_PMT_PLAN',
1303: 'M',
1304: 'M')
1305: THEN

Line 1306: IF cn_srp_pmt_plans_pub_cuhk.ok_to_generate_msg

1302: 'DELETE_SRP_PMT_PLAN',
1303: 'M',
1304: 'M')
1305: THEN
1306: IF cn_srp_pmt_plans_pub_cuhk.ok_to_generate_msg
1307: (p_srp_pmt_plans_rec => l_spp_rec)
1308: THEN
1309: -- Clear bind variables
1310: -- XMLGEN.clearBindValues;

Line 1491: END CN_SRP_PMT_PLANS_PUB;

1487: x_loading_status => x_loading_status);
1488:
1489: END Delete_Mass_Asgn_Srp_Pmt_Plan;
1490:
1491: END CN_SRP_PMT_PLANS_PUB;