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_PAYGROUP_PUB dependencies on CN_SRP_PAYGROUP_PUB

Line 1: PACKAGE BODY CN_Srp_PayGroup_PUB as

1: PACKAGE BODY CN_Srp_PayGroup_PUB as
2: -- $Header: cnpspgpb.pls 120.12 2006/10/05 09:59:16 chanthon noship $
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_PayGroup_PUB';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'cnpspgpb.pls';

Line 297: 'cn.plsql.cn_srp_paygroup_pub.assign_salesreps.org_validate',

293: status => l_status);
294:
295: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
296: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
297: 'cn.plsql.cn_srp_paygroup_pub.assign_salesreps.org_validate',
298: 'Validated org_id = ' || l_org_id || ' status = ' || l_status);
299: end if;
300:
301: --

Line 398: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PAYGROUP_PUB',

394: --
395: -- User hooks
396: --
397:
398: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PAYGROUP_PUB',
399: 'ASSIGN_SALESREPS',
400: 'B',
401: 'C')
402: THEN

Line 403: cn_srp_paygroup_pub_cuhk.assign_salesreps_pre

399: 'ASSIGN_SALESREPS',
400: 'B',
401: 'C')
402: THEN
403: cn_srp_paygroup_pub_cuhk.assign_salesreps_pre
404: (p_api_version => p_api_version,
405: p_init_msg_list => fnd_api.g_false,
406: p_commit => fnd_api.g_false,
407: p_validation_level => p_validation_level,

Line 425: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PAYGROUP_PUB',

421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
422: END IF;
423: END IF;
424:
425: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PAYGROUP_PUB',
426: 'ASSIGN_SALESREPS',
427: 'B',
428: 'V')
429: THEN

Line 430: cn_srp_paygroup_pub_vuhk.assign_salesreps_pre

426: 'ASSIGN_SALESREPS',
427: 'B',
428: 'V')
429: THEN
430: cn_srp_paygroup_pub_vuhk.assign_salesreps_pre
431: (p_api_version => p_api_version,
432: p_init_msg_list => fnd_api.g_false,
433: p_commit => fnd_api.g_false,
434: p_validation_level => p_validation_level,

Line 500: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PAYGROUP_PUB',

496: -- Post processing hooks
497: --
498:
499:
500: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PAYGROUP_PUB',
501: 'ASSIGN_SALESREPS',
502: 'A',
503: 'V')
504: THEN

Line 505: cn_srp_paygroup_pub_vuhk.assign_salesreps_post

501: 'ASSIGN_SALESREPS',
502: 'A',
503: 'V')
504: THEN
505: cn_srp_paygroup_pub_vuhk.assign_salesreps_post
506: (p_api_version => p_api_version,
507: p_init_msg_list => fnd_api.g_false,
508: p_commit => fnd_api.g_false,
509: p_validation_level => p_validation_level,

Line 527: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PAYGROUP_PUB',

523: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
524: END IF;
525: END IF;
526:
527: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PAYGROUP_PUB',
528: 'ASSIGN_SALESREPS',
529: 'A',
530: 'C')
531: THEN

Line 532: cn_srp_paygroup_pub_cuhk.assign_salesreps_post

528: 'ASSIGN_SALESREPS',
529: 'A',
530: 'C')
531: THEN
532: cn_srp_paygroup_pub_cuhk.assign_salesreps_post
533: (p_api_version => p_api_version,
534: p_init_msg_list => fnd_api.g_false,
535: p_commit => fnd_api.g_false,
536: p_validation_level => p_validation_level,

Line 554: IF JTF_USR_HKS.Ok_to_execute('CN_SRP_PAYGROUP_PUB',

550: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
551: END IF;
552: END IF;
553:
554: IF JTF_USR_HKS.Ok_to_execute('CN_SRP_PAYGROUP_PUB',
555: 'ASSIGN_SALESREPS',
556: 'M',
557: 'M')
558: THEN

Line 559: IF cn_srp_paygroup_pub_cuhk.ok_to_generate_msg

555: 'ASSIGN_SALESREPS',
556: 'M',
557: 'M')
558: THEN
559: IF cn_srp_paygroup_pub_cuhk.ok_to_generate_msg
560: (p_paygroup_assign_rec => l_paygroup_assign_rec)
561: THEN
562:
563: -- Get a ID for workflow/ business object instance

Line 764: 'cn.plsql.cn_srp_paygroup_pub.update_srp_assignment.error',

760: Nvl(l_old_paygroup_assign_rec.org_id, -99) then
761: FND_MESSAGE.SET_NAME ('FND' , 'FND_MO_OU_CANNOT_UPDATE');
762: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
763: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
764: 'cn.plsql.cn_srp_paygroup_pub.update_srp_assignment.error',
765: true);
766: end if;
767:
768: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 783: 'cn.plsql.cn_srp_paygroup_pub.update_srp_assignment.org_validate',

779: status => l_status);
780:
781: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
782: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
783: 'cn.plsql.cn_srp_paygroup_pub.update_srp_assignment.org_validate',
784: 'Validated org_id = ' || l_org_id || ' status = ' || l_status);
785: end if;
786:
787: --

Line 1006: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PAYGROUP_PUB',

1002: --
1003: -- User hooks
1004: --
1005:
1006: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PAYGROUP_PUB',
1007: 'UPDATE_SRP_ASSIGNMENT',
1008: 'B',
1009: 'C')
1010: THEN

Line 1011: cn_srp_paygroup_pub_cuhk.update_srp_assignment_pre

1007: 'UPDATE_SRP_ASSIGNMENT',
1008: 'B',
1009: 'C')
1010: THEN
1011: cn_srp_paygroup_pub_cuhk.update_srp_assignment_pre
1012: (p_api_version => p_api_version,
1013: p_init_msg_list => fnd_api.g_false,
1014: p_commit => fnd_api.g_false,
1015: p_validation_level => p_validation_level,

Line 1034: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PAYGROUP_PUB',

1030: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1031: END IF;
1032: END IF;
1033:
1034: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PAYGROUP_PUB',
1035: 'UPDATE_SRP_ASSIGNMENT',
1036: 'B',
1037: 'V')
1038: THEN

Line 1039: cn_srp_paygroup_pub_vuhk.update_srp_assignment_pre

1035: 'UPDATE_SRP_ASSIGNMENT',
1036: 'B',
1037: 'V')
1038: THEN
1039: cn_srp_paygroup_pub_vuhk.update_srp_assignment_pre
1040: (p_api_version => p_api_version,
1041: p_init_msg_list => fnd_api.g_false,
1042: p_commit => fnd_api.g_false,
1043: p_validation_level => p_validation_level,

Line 1114: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PAYGROUP_PUB',

1110: -- Post processing hooks
1111: --
1112:
1113:
1114: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PAYGROUP_PUB',
1115: 'UPDATE_SRP_ASSIGNMENT',
1116: 'A',
1117: 'V')
1118: THEN

Line 1119: cn_srp_paygroup_pub_vuhk.update_srp_assignment_post

1115: 'UPDATE_SRP_ASSIGNMENT',
1116: 'A',
1117: 'V')
1118: THEN
1119: cn_srp_paygroup_pub_vuhk.update_srp_assignment_post
1120: (p_api_version => p_api_version,
1121: p_init_msg_list => fnd_api.g_false,
1122: p_commit => fnd_api.g_false,
1123: p_validation_level => p_validation_level,

Line 1142: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PAYGROUP_PUB',

1138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1139: END IF;
1140: END IF;
1141:
1142: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PAYGROUP_PUB',
1143: 'UPDATE_SRP_ASSIGNMENT',
1144: 'A',
1145: 'C')
1146: THEN

Line 1147: cn_srp_paygroup_pub_cuhk.update_srp_assignment_post

1143: 'UPDATE_SRP_ASSIGNMENT',
1144: 'A',
1145: 'C')
1146: THEN
1147: cn_srp_paygroup_pub_cuhk.update_srp_assignment_post
1148: (p_api_version => p_api_version,
1149: p_init_msg_list => fnd_api.g_false,
1150: p_commit => fnd_api.g_false,
1151: p_validation_level => p_validation_level,

Line 1170: IF JTF_USR_HKS.Ok_to_execute('CN_SRP_PAYGROUP_PUB',

1166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1167: END IF;
1168: END IF;
1169:
1170: IF JTF_USR_HKS.Ok_to_execute('CN_SRP_PAYGROUP_PUB',
1171: 'UPDATE_SRP_ASSIGNMENT',
1172: 'M',
1173: 'M')
1174: THEN

Line 1175: IF cn_srp_paygroup_pub_cuhk.ok_to_generate_msg

1171: 'UPDATE_SRP_ASSIGNMENT',
1172: 'M',
1173: 'M')
1174: THEN
1175: IF cn_srp_paygroup_pub_cuhk.ok_to_generate_msg
1176: (p_paygroup_assign_rec => l_paygroup_assign_rec)
1177: THEN
1178:
1179: -- Get a ID for workflow/ business object instance

Line 1290: newrec CN_SRP_PAYGROUP_PUB.PayGroup_assign_rec;

1286: l_count NUMBER;
1287: l_api_name CONSTANT VARCHAR2(30) := 'Create_Mass_Asgn_Srp_Pay';
1288: l_api_version CONSTANT NUMBER := 1.0;
1289: l_null_date CONSTANT DATE := to_date('31-12-9999','DD-MM-YYYY');
1290: newrec CN_SRP_PAYGROUP_PUB.PayGroup_assign_rec;
1291: l_salesrep_type cn_salesreps.type%TYPE;
1292: l_salesrep_id cn_salesreps.salesrep_id%TYPE;
1293: l_org_id cn_salesreps.org_id%TYPE;
1294: l_emp_num cn_salesreps.employee_number%TYPE;

Line 1334: 'cn.plsql.cn_srp_paygroup_pub.create_mass_asgn_srp_pay.org_validate',

1330: status => l_status);
1331:
1332: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1333: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1334: 'cn.plsql.cn_srp_paygroup_pub.create_mass_asgn_srp_pay.org_validate',
1335: 'Validated org_id = ' || l_org_id || ' status = ' || l_status);
1336: end if;
1337:
1338: select salesrep_id, start_date, end_date

Line 1504: newrec CN_SRP_PAYGROUP_PUB.PayGroup_assign_rec;

1500: l_ovn_old cn_srp_pay_groups.object_version_number%TYPE;
1501: l_srp_pay_group_id cn_srp_pay_groups.srp_pay_group_id%TYPE;
1502: l_org_id cn_srp_pay_groups.org_id%TYPE;
1503:
1504: newrec CN_SRP_PAYGROUP_PUB.PayGroup_assign_rec;
1505: oldrec CN_SRP_PAYGROUP_PUB.PayGroup_assign_rec;
1506:
1507: delrec CN_Srp_PayGroup_PVT.PayGroup_assign_rec;
1508: l_salesrep_type_new cn_salesreps.type%TYPE;

Line 1505: oldrec CN_SRP_PAYGROUP_PUB.PayGroup_assign_rec;

1501: l_srp_pay_group_id cn_srp_pay_groups.srp_pay_group_id%TYPE;
1502: l_org_id cn_srp_pay_groups.org_id%TYPE;
1503:
1504: newrec CN_SRP_PAYGROUP_PUB.PayGroup_assign_rec;
1505: oldrec CN_SRP_PAYGROUP_PUB.PayGroup_assign_rec;
1506:
1507: delrec CN_Srp_PayGroup_PVT.PayGroup_assign_rec;
1508: l_salesrep_type_new cn_salesreps.type%TYPE;
1509: l_salesrep_id_new cn_salesreps.salesrep_id%TYPE;

Line 1570: 'cn.plsql.cn_srp_paygroup_pub.update_mass_asgn_srp_pay.org_validate',

1566: status => l_status);
1567:
1568: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1569: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1570: 'cn.plsql.cn_srp_paygroup_pub.update_mass_asgn_srp_pay.org_validate',
1571: 'Validated org_id = ' || l_org_id || ' status = ' || l_status);
1572: end if;
1573:
1574: SELECT salesrep_id,role_id,start_date, end_date

Line 1837: END CN_Srp_PayGroup_PUB ;

1833: );
1834:
1835: End Update_Mass_Asgn_Srp_Pay;
1836:
1837: END CN_Srp_PayGroup_PUB ;