DBA Data[Home] [Help]

APPS.CN_PMT_TRANS_PVT dependencies on CN_API

Line 565: IF cn_api.chk_payrun_status_paid (

561: --
562: -- API body
563: --
564: -- check the payrun status and valid payrun
565: IF cn_api.chk_payrun_status_paid (
566: p_payrun_id => p_payrun_id,
567: p_loading_status => x_loading_status,
568: x_loading_status => x_loading_status) = fnd_api.g_true
569: THEN

Line 574: IF cn_api.chk_srp_hold_status (p_salesrep_id => p_salesrep_id,

570: RAISE fnd_api.g_exc_error;
571: END IF;
572:
573: -- check the salesrep id is valid and not on HOLD
574: IF cn_api.chk_srp_hold_status (p_salesrep_id => p_salesrep_id,
575: --R12
576: p_org_id => p_org_id,
577: p_loading_status => x_loading_status,
578: x_loading_status => x_loading_status

Line 585: IF cn_api.chk_worksheet_status (p_payrun_id => p_payrun_id,

581: RAISE fnd_api.g_exc_error;
582: END IF;
583:
584: -- Check worksheet status
585: IF cn_api.chk_worksheet_status (p_payrun_id => p_payrun_id,
586: p_salesrep_id => p_salesrep_id,
587: --R12
588: p_org_id => p_org_id,
589: p_loading_status => x_loading_status,

Line 1038: IF ((cn_api.chk_miss_null_num_para (p_num_para => p_payrun_id,

1034: x_return_status := fnd_api.g_ret_sts_success;
1035: x_loading_status := 'CN_INSERTED';
1036:
1037: -- Mandatory parameters check for payrun_id, salesrep_id
1038: IF ((cn_api.chk_miss_null_num_para (p_num_para => p_payrun_id,
1039: p_obj_name => cn_api.get_lkup_meaning ('PAY_RUN_NAME', 'PAY_RUN_VALIDATION_TYPE'),
1040: p_loading_status => x_loading_status,
1041: x_loading_status => x_loading_status
1042: )

Line 1039: p_obj_name => cn_api.get_lkup_meaning ('PAY_RUN_NAME', 'PAY_RUN_VALIDATION_TYPE'),

1035: x_loading_status := 'CN_INSERTED';
1036:
1037: -- Mandatory parameters check for payrun_id, salesrep_id
1038: IF ((cn_api.chk_miss_null_num_para (p_num_para => p_payrun_id,
1039: p_obj_name => cn_api.get_lkup_meaning ('PAY_RUN_NAME', 'PAY_RUN_VALIDATION_TYPE'),
1040: p_loading_status => x_loading_status,
1041: x_loading_status => x_loading_status
1042: )
1043: ) = fnd_api.g_true

Line 1049: IF ((cn_api.chk_miss_null_num_para (p_num_para => p_salesrep_id,

1045: THEN
1046: RAISE fnd_api.g_exc_error;
1047: END IF;
1048:
1049: IF ((cn_api.chk_miss_null_num_para (p_num_para => p_salesrep_id,
1050: p_obj_name => cn_api.get_lkup_meaning ('SALES_PERSON', 'PAY_RUN_VALIDATION_TYPE'),
1051: p_loading_status => x_loading_status,
1052: x_loading_status => x_loading_status
1053: )

Line 1050: p_obj_name => cn_api.get_lkup_meaning ('SALES_PERSON', 'PAY_RUN_VALIDATION_TYPE'),

1046: RAISE fnd_api.g_exc_error;
1047: END IF;
1048:
1049: IF ((cn_api.chk_miss_null_num_para (p_num_para => p_salesrep_id,
1050: p_obj_name => cn_api.get_lkup_meaning ('SALES_PERSON', 'PAY_RUN_VALIDATION_TYPE'),
1051: p_loading_status => x_loading_status,
1052: x_loading_status => x_loading_status
1053: )
1054: ) = fnd_api.g_true

Line 1061: IF ((cn_api.chk_null_char_para (p_char_para => p_incentive_type_code,

1057: RAISE fnd_api.g_exc_error;
1058: END IF;
1059:
1060: -- check Incentive Type Code
1061: IF ((cn_api.chk_null_char_para (p_char_para => p_incentive_type_code,
1062: p_obj_name => cn_api.get_lkup_meaning ('INCENTIVE_TYPE', 'PAY_RUN_VALIDATION_TYPE'),
1063: p_loading_status => x_loading_status,
1064: x_loading_status => x_loading_status
1065: )

Line 1062: p_obj_name => cn_api.get_lkup_meaning ('INCENTIVE_TYPE', 'PAY_RUN_VALIDATION_TYPE'),

1058: END IF;
1059:
1060: -- check Incentive Type Code
1061: IF ((cn_api.chk_null_char_para (p_char_para => p_incentive_type_code,
1062: p_obj_name => cn_api.get_lkup_meaning ('INCENTIVE_TYPE', 'PAY_RUN_VALIDATION_TYPE'),
1063: p_loading_status => x_loading_status,
1064: x_loading_status => x_loading_status
1065: )
1066: ) = fnd_api.g_true

Line 1099: IF cn_api.chk_payrun_status_paid (

1095: RAISE fnd_api.g_exc_error;
1096: END IF;
1097:
1098: -- check the payrun status and valid payrun
1099: IF cn_api.chk_payrun_status_paid (
1100: p_payrun_id => p_payrun_id,
1101: p_loading_status => x_loading_status,
1102: x_loading_status => x_loading_status) = fnd_api.g_true
1103: THEN

Line 1108: IF cn_api.chk_srp_hold_status (p_salesrep_id => p_salesrep_id,

1104: RAISE fnd_api.g_exc_error;
1105: END IF;
1106:
1107: -- check the salesrep id is valid and not on HOLD
1108: IF cn_api.chk_srp_hold_status (p_salesrep_id => p_salesrep_id,
1109: --R12
1110: p_org_id => p_org_id,
1111: p_loading_status => x_loading_status,
1112: x_loading_status => x_loading_status

Line 1119: IF cn_api.chk_worksheet_status (p_payrun_id => p_payrun_id,

1115: RAISE fnd_api.g_exc_error;
1116: END IF;
1117:
1118: -- Check Worksheet Status
1119: IF cn_api.chk_worksheet_status (p_payrun_id => p_payrun_id,
1120: p_salesrep_id => p_salesrep_id,
1121: --R12
1122: p_org_id => p_org_id,
1123: p_loading_status => x_loading_status,

Line 1172: l_pay_element_type_id := cn_api.get_pay_element_id (p_quota_id, p_salesrep_id, p_org_id, l_pay_date);

1168:
1169: CLOSE get_payrun;
1170:
1171: -- Bug 2880233: manual adj has quota_id, use assigned quota_id
1172: l_pay_element_type_id := cn_api.get_pay_element_id (p_quota_id, p_salesrep_id, p_org_id, l_pay_date);
1173: -- Create the Record in cn_posting_batches
1174: cn_prepostbatches.get_uid (l_posting_batch_id);
1175: l_batch_rec.posting_batch_id := l_posting_batch_id;
1176: l_batch_rec.NAME := 'MANUAL_PAY_ADJ batch number:' || p_payrun_id || ':' || p_salesrep_id || ':' || l_posting_batch_id;

Line 1426: IF cn_api.chk_payrun_status_paid (p_payrun_id => trans_rec.payrun_id, p_loading_status => x_loading_status,

1422:
1423: -- check the payrun status
1424: -- check the payrun ID is valid
1425: -- if payrun status <> UNPAID you cannot delete Transactions
1426: IF cn_api.chk_payrun_status_paid (p_payrun_id => trans_rec.payrun_id, p_loading_status => x_loading_status,
1427: x_loading_status => x_loading_status) = fnd_api.g_true
1428: THEN
1429: RAISE fnd_api.g_exc_error;
1430: END IF;

Line 1432: IF cn_api.chk_worksheet_status (p_payrun_id => trans_rec.payrun_id,

1428: THEN
1429: RAISE fnd_api.g_exc_error;
1430: END IF;
1431:
1432: IF cn_api.chk_worksheet_status (p_payrun_id => trans_rec.payrun_id,
1433: p_salesrep_id => trans_rec.credited_salesrep_id,
1434: p_org_id => trans_rec.org_id,
1435: p_loading_status => x_loading_status,
1436: x_loading_status => x_loading_status