DBA Data[Home] [Help]

APPS.OKL_STY_PVT dependencies on OKL_API

Line 890: IF (l_found <> OKL_API.G_TRUE ) THEN

886: l_found := okl_accounting_util.validate_lookup_code(p_lookup_type => 'OKL_STREAM_TYPE_SCOPE',
887: p_lookup_code => p_styv_rec.stream_type_scope);
888:
889:
890: IF (l_found <> OKL_API.G_TRUE ) THEN
891: OKC_API.set_message(G_OKC_APP, G_INVALID_VALUE,G_COL_NAME_TOKEN,'Stream_Type_Scope');
892: x_return_status := Okc_Api.G_RET_STS_ERROR;
893: -- raise the exception as there's no matching foreign key value
894: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 1069: IF (l_found <> OKL_API.G_TRUE ) THEN

1065: p_app_id => 0,
1066: p_view_app_id => 0);
1067:
1068:
1069: IF (l_found <> OKL_API.G_TRUE ) THEN
1070: OKC_API.set_message(G_OKC_APP, G_INVALID_VALUE,G_COL_NAME_TOKEN,'Billable_YN');
1071: x_return_status := Okc_Api.G_RET_STS_ERROR;
1072: -- raise the exception as there's no matching foreign key value
1073: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 1140: IF (l_found <> OKL_API.G_TRUE ) THEN

1136: p_app_id => 0,
1137: p_view_app_id => 0);
1138:
1139:
1140: IF (l_found <> OKL_API.G_TRUE ) THEN
1141: OKC_API.set_message(G_OKC_APP, G_INVALID_VALUE,G_COL_NAME_TOKEN,'Taxable_Default_YN');
1142: x_return_status := Okc_Api.G_RET_STS_ERROR;
1143: -- raise the exception as there's no matching foreign key value
1144: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 1208: IF (l_found <> OKL_API.G_TRUE ) THEN

1204: l_found := okl_accounting_util.validate_lookup_code(p_lookup_type => 'OKL_STY_CUSTOMIZATION_LEVEL',
1205: p_lookup_code => p_styv_rec.customization_level);
1206:
1207:
1208: IF (l_found <> OKL_API.G_TRUE ) THEN
1209: OKC_API.set_message(G_OKC_APP, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_display_col_name);
1210: x_return_status := Okc_Api.G_RET_STS_ERROR;
1211: -- raise the exception as there's no matching foreign key value
1212: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 1275: IF (l_found <> OKL_API.G_TRUE ) THEN

1271: --Check if stream_type_class exists in the fnd_common_lookups or not
1272: l_found := okl_accounting_util.validate_lookup_code(p_lookup_type => 'OKL_STREAM_TYPE_CLASS',
1273: p_lookup_code => p_styv_rec.stream_type_class);
1274:
1275: IF (l_found <> OKL_API.G_TRUE ) THEN
1276: OKC_API.set_message(G_OKC_APP, G_INVALID_VALUE,G_COL_NAME_TOKEN,'Stream_Type_Class');
1277: x_return_status := Okc_Api.G_RET_STS_ERROR;
1278: -- raise the exception as there's no matching foreign key value
1279: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 1343: IF (l_found <> OKL_API.G_TRUE ) THEN

1339: --Check if stream_type_subclass exists in the fnd_common_lookups or not
1340: l_found := okl_accounting_util.validate_lookup_code(p_lookup_type => 'OKL_STREAM_TYPE_SUBCLASS',
1341: p_lookup_code => p_styv_rec.stream_type_subclass);
1342:
1343: IF (l_found <> OKL_API.G_TRUE ) THEN
1344: OKC_API.set_message(G_OKC_APP, G_INVALID_VALUE,G_COL_NAME_TOKEN,'Stream_Type_SubClass');
1345: x_return_status := Okc_Api.G_RET_STS_ERROR;
1346: -- raise the exception as there's no matching foreign key value
1347: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 1521: IF (l_found <> OKL_API.G_TRUE ) THEN

1517: ELSE
1518: l_found := okl_accounting_util.validate_lookup_code(p_lookup_type =>
1519: 'OKL_STREAM_TYPE_CASH_BASIS',
1520: p_lookup_code => p_styv_rec.accrual_yn);
1521: IF (l_found <> OKL_API.G_TRUE ) THEN
1522: -- Modified by RGOOTY
1523: OKC_API.set_message(G_OKC_APP, G_INVALID_VALUE,G_COL_NAME_TOKEN,'REVENUE_RECOGNITION_BASIS');
1524: x_return_status := Okc_Api.G_RET_STS_ERROR;
1525: -- raise the exception as there's no matching foreign key value

Line 1647: IF (l_found <> OKL_API.G_TRUE ) THEN

1643: (p_styv_rec .Allocation_Factor <> Okc_Api.G_MISS_CHAR) THEN
1644: l_found := okl_accounting_util.validate_lookup_code(p_lookup_type => 'OKL_STY_ALLOCATION_BASIS',
1645: p_lookup_code => p_styv_rec.Allocation_Factor);
1646:
1647: IF (l_found <> OKL_API.G_TRUE ) THEN
1648: OKC_API.set_message(G_OKC_APP, G_INVALID_VALUE,G_COL_NAME_TOKEN,'Allocation_Factor');
1649: x_return_status := Okc_Api.G_RET_STS_ERROR;
1650: -- raise the exception as there's no matching foreign key value
1651: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 1705: IF (l_found <> OKL_API.G_TRUE ) THEN

1701: (p_styv_rec.stream_type_purpose <> Okc_Api.G_MISS_CHAR) THEN
1702: l_found := okl_accounting_util.validate_lookup_code(p_lookup_type => 'OKL_STREAM_TYPE_PURPOSE',
1703: p_lookup_code => p_styv_rec.stream_type_purpose);
1704:
1705: IF (l_found <> OKL_API.G_TRUE ) THEN
1706: -- Modified by RGOOTY
1707: OKC_API.set_message(G_OKC_APP, G_INVALID_VALUE,G_COL_NAME_TOKEN,'PURPOSE');
1708: x_return_status := Okc_Api.G_RET_STS_ERROR;
1709: -- raise the exception as there's no matching foreign key value

Line 5006: l_return_status varchar2(1) := okl_api.g_ret_sts_success;

5002: -- Added by SNANDIKO for Bug 6744584 End
5003:
5004: l_api_version CONSTANT number := 1;
5005: l_api_name CONSTANT varchar2(30) := 'LOAD_SEED_ROW';
5006: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
5007: l_msg_count number;
5008: l_msg_data varchar2(4000);
5009: l_init_msg_list VARCHAR2(1):= 'T';
5010: l_styv_rec styv_rec_type;