DBA Data[Home] [Help]

APPS.CN_PAYRUN_PVT dependencies on CN_API

Line 1858: IF ( (cn_api.chk_miss_null_char_para

1854: --Added for R12 payment security check end.
1855:
1856: -- Mandatory parameters check for name, pay group id, pay period id, pay date
1857:
1858: IF ( (cn_api.chk_miss_null_char_para
1859: (p_char_para => p_payrun_rec.name,
1860: p_obj_name =>
1861: cn_api.get_lkup_meaning('PAY_RUN_NAME', 'PAY_RUN_VALIDATION_TYPE'),
1862: p_loading_status => x_loading_status,

Line 1861: cn_api.get_lkup_meaning('PAY_RUN_NAME', 'PAY_RUN_VALIDATION_TYPE'),

1857:
1858: IF ( (cn_api.chk_miss_null_char_para
1859: (p_char_para => p_payrun_rec.name,
1860: p_obj_name =>
1861: cn_api.get_lkup_meaning('PAY_RUN_NAME', 'PAY_RUN_VALIDATION_TYPE'),
1862: p_loading_status => x_loading_status,
1863: x_loading_status => x_loading_status)) = FND_API.G_TRUE )
1864: THEN
1865: RAISE FND_API.G_EXC_ERROR ;

Line 1868: IF ( (cn_api.chk_miss_null_num_para

1864: THEN
1865: RAISE FND_API.G_EXC_ERROR ;
1866: END IF;
1867:
1868: IF ( (cn_api.chk_miss_null_num_para
1869: (p_num_para => p_payrun_rec.pay_group_id,
1870: p_obj_name =>
1871: cn_api.get_lkup_meaning('PAY_GROUP_NAME', 'PAY_RUN_VALIDATION_TYPE'),
1872: p_loading_status => x_loading_status,

Line 1871: cn_api.get_lkup_meaning('PAY_GROUP_NAME', 'PAY_RUN_VALIDATION_TYPE'),

1867:
1868: IF ( (cn_api.chk_miss_null_num_para
1869: (p_num_para => p_payrun_rec.pay_group_id,
1870: p_obj_name =>
1871: cn_api.get_lkup_meaning('PAY_GROUP_NAME', 'PAY_RUN_VALIDATION_TYPE'),
1872: p_loading_status => x_loading_status,
1873: x_loading_status => x_loading_status)) = FND_API.G_TRUE )
1874: THEN
1875: RAISE FND_API.G_EXC_ERROR ;

Line 1878: IF ( (cn_api.chk_miss_null_num_para

1874: THEN
1875: RAISE FND_API.G_EXC_ERROR ;
1876: END IF;
1877:
1878: IF ( (cn_api.chk_miss_null_num_para
1879: (p_num_para => p_payrun_rec.pay_period_id,
1880: p_obj_name =>
1881: cn_api.get_lkup_meaning('PAY_PERIOD', 'PAY_RUN_VALIDATION_TYPE'),
1882: p_loading_status => x_loading_status,

Line 1881: cn_api.get_lkup_meaning('PAY_PERIOD', 'PAY_RUN_VALIDATION_TYPE'),

1877:
1878: IF ( (cn_api.chk_miss_null_num_para
1879: (p_num_para => p_payrun_rec.pay_period_id,
1880: p_obj_name =>
1881: cn_api.get_lkup_meaning('PAY_PERIOD', 'PAY_RUN_VALIDATION_TYPE'),
1882: p_loading_status => x_loading_status,
1883: x_loading_status => x_loading_status)) = FND_API.G_TRUE )
1884: THEN
1885: RAISE FND_API.G_EXC_ERROR ;

Line 1888: IF ( (cn_api.chk_miss_null_date_para

1884: THEN
1885: RAISE FND_API.G_EXC_ERROR ;
1886: END IF;
1887:
1888: IF ( (cn_api.chk_miss_null_date_para
1889: (p_date_para => p_payrun_rec.pay_date,
1890: p_obj_name =>
1891: cn_api.get_lkup_meaning('PAY_DATE', 'PAY_RUN_VALIDATION_TYPE'),
1892: p_loading_status => x_loading_status,

Line 1891: cn_api.get_lkup_meaning('PAY_DATE', 'PAY_RUN_VALIDATION_TYPE'),

1887:
1888: IF ( (cn_api.chk_miss_null_date_para
1889: (p_date_para => p_payrun_rec.pay_date,
1890: p_obj_name =>
1891: cn_api.get_lkup_meaning('PAY_DATE', 'PAY_RUN_VALIDATION_TYPE'),
1892: p_loading_status => x_loading_status,
1893: x_loading_status => x_loading_status)) = FND_API.G_TRUE )
1894: THEN
1895: RAISE FND_API.G_EXC_ERROR ;

Line 2157: cn_api.get_lkup_meaning(cn_payruns.status,'PAYRUN_STATUS') statusmeaning

2153:
2154:
2155: CURSOR get_old_record IS
2156: SELECT status, payrun_id,name,object_version_number,
2157: cn_api.get_lkup_meaning(cn_payruns.status,'PAYRUN_STATUS') statusmeaning
2158: FROM cn_payruns
2159: WHERE payrun_id = p_payrun_id;
2160: l_old_record get_old_record%ROWTYPE;
2161:

Line 2818: ,name, cn_api.get_lkup_meaning(cn_payruns.status,'PAYRUN_STATUS') statusmeaning

2814: l_status_meaning cn_payruns.status%TYPE;
2815:
2816: CURSOR get_payrun IS
2817: SELECT pay_period_id, pay_date, accounting_period_id, org_id
2818: ,name, cn_api.get_lkup_meaning(cn_payruns.status,'PAYRUN_STATUS') statusmeaning
2819: FROM cn_payruns
2820: WHERE payrun_id = p_payrun_id;
2821:
2822: l_payrun_rec get_payrun%ROWTYPE;

Line 3006: IF ((cn_api.chk_miss_null_num_para

3002:
3003:
3004:
3005: --Validate if payrun is valid
3006: IF ((cn_api.chk_miss_null_num_para
3007: (p_num_para => p_payrun_id,
3008: p_obj_name =>
3009: cn_api.get_lkup_meaning('PAY_RUN_NAME', 'PAY_RUN_VALIDATION_TYPE'),
3010: p_loading_status => x_loading_status,

Line 3009: cn_api.get_lkup_meaning('PAY_RUN_NAME', 'PAY_RUN_VALIDATION_TYPE'),

3005: --Validate if payrun is valid
3006: IF ((cn_api.chk_miss_null_num_para
3007: (p_num_para => p_payrun_id,
3008: p_obj_name =>
3009: cn_api.get_lkup_meaning('PAY_RUN_NAME', 'PAY_RUN_VALIDATION_TYPE'),
3010: p_loading_status => x_loading_status,
3011: x_loading_status => x_loading_status)) = FND_API.G_TRUE)
3012: THEN
3013: RAISE FND_API.G_EXC_ERROR ;

Line 3276: cn_api.get_pay_element_id(-1001, wksht.salesrep_id, l_payrun_rec.org_id, l_payrun_rec.pay_date);

3272: THEN
3273: -- quota ID here actually refers to pay element type ID
3274: -- quota ID = -1001 for pmt_pln_rec(Bug 2880233)
3275: l_element_type_id :=
3276: cn_api.get_pay_element_id(-1001, wksht.salesrep_id, l_payrun_rec.org_id, l_payrun_rec.pay_date);
3277: END IF;
3278:
3279: IF nvl(l_adj_amount,0) <> 0
3280: THEN