DBA Data[Home] [Help]

APPS.OKL_OPEN_INTERFACE_PVT dependencies on OKC_API

Line 97: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;

93: G_DEFAULT_CHAR CONSTANT VARCHAR2(1) := 'X';
94: G_DEFAULT_DATE CONSTANT DATE := TO_DATE('1111','YYYY');
95: G_FINAL_DATE CONSTANT DATE := TO_DATE('1','j') + 5300000;
96: -- end cklee 02/13/2004 bug# 3440442
97: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
98: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
99: G_PRODUCT_ID NUMBER;
100: G_REVENUE_RECOGNITION_METHOD okl_product_parameters_v.REVENUE_RECOGNITION_METHOD%TYPE;
101: G_INTEREST_CALCULATION_BASIS okl_product_parameters_v.INTEREST_CALCULATION_BASIS%TYPE;

Line 98: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;

94: G_DEFAULT_DATE CONSTANT DATE := TO_DATE('1111','YYYY');
95: G_FINAL_DATE CONSTANT DATE := TO_DATE('1','j') + 5300000;
96: -- end cklee 02/13/2004 bug# 3440442
97: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
98: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
99: G_PRODUCT_ID NUMBER;
100: G_REVENUE_RECOGNITION_METHOD okl_product_parameters_v.REVENUE_RECOGNITION_METHOD%TYPE;
101: G_INTEREST_CALCULATION_BASIS okl_product_parameters_v.INTEREST_CALCULATION_BASIS%TYPE;
102: G_DEAL_TYPE okl_product_parameters_v.DEAL_TYPE%TYPE;

Line 5467: --Bug# 4284166 : Added check for p_rgp_id = OKC_API.G_MISS_NUM in if statement

5463: RETURN;
5464: END IF;
5465:
5466: --IF (p_rgp_id IS NULL) THEN -- create rule group
5467: --Bug# 4284166 : Added check for p_rgp_id = OKC_API.G_MISS_NUM in if statement
5468: IF (p_rgp_id IS NULL or p_rgp_id = OKC_API.G_MISS_NUM) THEN -- create rule group
5469:
5470: OKL_RULE_PUB.create_rule_group(
5471: p_api_version => 1.0,

Line 5468: IF (p_rgp_id IS NULL or p_rgp_id = OKC_API.G_MISS_NUM) THEN -- create rule group

5464: END IF;
5465:
5466: --IF (p_rgp_id IS NULL) THEN -- create rule group
5467: --Bug# 4284166 : Added check for p_rgp_id = OKC_API.G_MISS_NUM in if statement
5468: IF (p_rgp_id IS NULL or p_rgp_id = OKC_API.G_MISS_NUM) THEN -- create rule group
5469:
5470: OKL_RULE_PUB.create_rule_group(
5471: p_api_version => 1.0,
5472: p_init_msg_list => OKL_API.G_FALSE,

Line 5781: l_rulv_rec.created_by := OKC_API.G_MISS_NUM;

5777: x_rulv_rec => x_rulv_rec
5778: );
5779: ELSE
5780: l_rulv_rec.id := l_sales_tax_rule_id;
5781: l_rulv_rec.created_by := OKC_API.G_MISS_NUM;
5782: l_rulv_rec.creation_date := OKC_API.G_MISS_DATE;
5783: OKL_RULE_PUB.update_rule(
5784: p_api_version => 1.0,
5785: p_init_msg_list => OKL_API.G_FALSE,

Line 5782: l_rulv_rec.creation_date := OKC_API.G_MISS_DATE;

5778: );
5779: ELSE
5780: l_rulv_rec.id := l_sales_tax_rule_id;
5781: l_rulv_rec.created_by := OKC_API.G_MISS_NUM;
5782: l_rulv_rec.creation_date := OKC_API.G_MISS_DATE;
5783: OKL_RULE_PUB.update_rule(
5784: p_api_version => 1.0,
5785: p_init_msg_list => OKL_API.G_FALSE,
5786: x_return_status => x_return_status,

Line 6451: l_rulv_rec.created_by := OKC_API.G_MISS_NUM;

6447: x_rulv_rec => x_rulv_rec
6448: );
6449: ELSE
6450: l_rulv_rec.id := l_sales_tax_rule_id;
6451: l_rulv_rec.created_by := OKC_API.G_MISS_NUM;
6452: l_rulv_rec.creation_date := OKC_API.G_MISS_DATE;
6453: OKL_RULE_PUB.update_rule(
6454: p_api_version => 1.0,
6455: p_init_msg_list => OKL_API.G_FALSE,

Line 6452: l_rulv_rec.creation_date := OKC_API.G_MISS_DATE;

6448: );
6449: ELSE
6450: l_rulv_rec.id := l_sales_tax_rule_id;
6451: l_rulv_rec.created_by := OKC_API.G_MISS_NUM;
6452: l_rulv_rec.creation_date := OKC_API.G_MISS_DATE;
6453: OKL_RULE_PUB.update_rule(
6454: p_api_version => 1.0,
6455: p_init_msg_list => OKL_API.G_FALSE,
6456: x_return_status => x_return_status,

Line 6471: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

6467: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
6468: raise line_rule_failed;
6469: END IF;
6470:
6471: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
6472: l_rgp_id := x_rgpv_rec.id;
6473: END IF;
6474:
6475: l_rulv_rec := NULL;

Line 6536: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

6532: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
6533: raise line_rule_failed;
6534: END IF;
6535:
6536: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
6537: l_rgp_id := x_rgpv_rec.id;
6538: END IF;
6539:
6540: l_rulv_rec := NULL;

Line 6588: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

6584: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
6585: raise line_rule_failed;
6586: END IF;
6587:
6588: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
6589: l_rgp_id := x_rgpv_rec.id;
6590: END IF;
6591:
6592: l_rulv_rec := NULL;

Line 6620: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

6616: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
6617: raise line_rule_failed;
6618: END IF;
6619:
6620: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
6621: l_rgp_id := x_rgpv_rec.id;
6622: END IF;
6623:
6624: l_rulv_rec := NULL;

Line 6678: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

6674: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
6675: raise line_rule_failed;
6676: END IF;
6677:
6678: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
6679: l_rgp_id := x_rgpv_rec.id;
6680: END IF;
6681: -- Added by rravikir (Fix for Bug 3947959)
6682: END IF;

Line 6826: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

6822: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
6823: raise line_rule_failed;
6824: END IF;
6825:
6826: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
6827: l_rgp_id := x_rgpv_rec.id;
6828: END IF;
6829:
6830: l_rulv_rec := NULL;

Line 6933: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

6929: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
6930: raise line_rule_failed;
6931: END IF;
6932:
6933: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
6934: l_rgp_id := x_rgpv_rec.id;
6935: END IF;
6936:
6937: END IF; -- line type

Line 6979: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

6975: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
6976: raise line_rule_failed;
6977: END IF;
6978:
6979: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
6980: l_rgp_id := x_rgpv_rec.id;
6981: END IF;
6982:
6983: l_rulv_rec := NULL;

Line 7009: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

7005: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
7006: raise line_rule_failed;
7007: END IF;
7008:
7009: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
7010: l_rgp_id := x_rgpv_rec.id;
7011: END IF;
7012:
7013: */

Line 7057: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

7053: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
7054: raise line_rule_failed;
7055: END IF;
7056:
7057: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
7058: l_rgp_id := x_rgpv_rec.id;
7059: END IF;
7060: END IF;
7061:

Line 7103: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

7099: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
7100: raise line_rule_failed;
7101: END IF;
7102:
7103: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
7104: l_rgp_id := x_rgpv_rec.id;
7105: END IF;
7106: END IF;
7107: END IF; -- line type

Line 7191: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

7187: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
7188: raise line_rule_failed;
7189: END IF;
7190:
7191: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
7192: l_rgp_id := x_rgpv_rec.id;
7193: END IF;
7194:
7195: END IF;

Line 7492: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

7488: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
7489: raise line_rule_failed;
7490: END IF;
7491:
7492: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
7493: l_rgp_id := x_rgpv_rec.id;
7494: END IF;
7495:
7496: END IF; -- line type USAGE

Line 7589: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

7585: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
7586: raise line_rule_failed;
7587: END IF;
7588:
7589: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
7590: l_rgp_id := x_rgpv_rec.id;
7591: END IF;
7592:
7593: IF (p_fee_frequency IS NOT NULL) THEN

Line 7625: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

7621: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
7622: raise line_rule_failed;
7623: END IF;
7624:
7625: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
7626: l_rgp_id := x_rgpv_rec.id;
7627: END IF;
7628: END IF;
7629:

Line 7679: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

7675: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
7676: raise line_rule_failed;
7677: END IF;
7678:
7679: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
7680: l_rgp_id := x_rgpv_rec.id;
7681: END IF;
7682:
7683: l_rulv_rec := NULL;

Line 7877: x_return_status := OKC_API.G_RET_STS_SUCCESS;

7873: function get_formula_id(p_name IN VARCHAR2,
7874: x_return_status OUT NOCOPY VARCHAR2) RETURN NUMBER IS
7875: l_formula_id number := 0;
7876: begin
7877: x_return_status := OKC_API.G_RET_STS_SUCCESS;
7878: select id
7879: INTO l_formula_id
7880: FROM OKL_FORMULAE_B
7881: WHERE NAME = p_name;

Line 7885: x_return_status := OKC_API.G_RET_STS_ERROR;

7881: WHERE NAME = p_name;
7882:
7883: return(l_formula_id);
7884: EXCEPTION WHEN OTHERS THEN
7885: x_return_status := OKC_API.G_RET_STS_ERROR;
7886: return(l_formula_id); -- 5024651
7887: end;
7888:
7889: ------------------------------------------------------------------------------

Line 8445: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

8441: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
8442: raise header_rule_failed;
8443: END IF;
8444:
8445: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
8446: l_rgp_id := x_rgpv_rec.id;
8447: END IF;
8448:
8449: END IF; -- x_customer_account_id

Line 8518: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

8514: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
8515: raise header_rule_failed;
8516: END IF;
8517:
8518: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
8519: l_rgp_id := x_rgpv_rec.id;
8520: END IF;
8521:
8522: END IF; -- rebook limit

Line 8577: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

8573: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
8574: raise header_rule_failed;
8575: END IF;
8576:
8577: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
8578: l_rgp_id := x_rgpv_rec.id;
8579: END IF;
8580:
8581: l_rulv_rec := NULL;

Line 8618: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

8614: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
8615: raise header_rule_failed;
8616: END IF;
8617:
8618: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
8619: l_rgp_id := x_rgpv_rec.id;
8620: END IF;
8621:
8622: --Not used currently - 05/20/2002

Line 8716: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

8712: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
8713: raise header_rule_failed;
8714: END IF;
8715:
8716: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
8717: l_rgp_id := x_rgpv_rec.id;
8718: END IF;
8719:
8720: debug_message('------>Rule: LASDEP/LASDEP processed');

Line 8785: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

8781: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
8782: raise header_rule_failed;
8783: END IF;
8784:
8785: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
8786: l_rgp_id := x_rgpv_rec.id;
8787: END IF;
8788:
8789: debug_message('------>Rule: LARNOP/LAREND processed');

Line 8858: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

8854: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
8855: raise header_rule_failed;
8856: END IF;
8857:
8858: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
8859: l_rgp_id := x_rgpv_rec.id;
8860: END IF;
8861:
8862: debug_message('------>Rule: LARNOP/LARNEW processed');

Line 8929: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- rviriyal bug #6310553

8925: raise header_rule_failed;
8926: END IF;
8927:
8928: -- IF (l_rgp_id IS NULL) THEN
8929: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- rviriyal bug #6310553
8930: l_rgp_id := x_rgpv_rec.id;
8931: END IF;
8932:
8933: debug_message('------>Rule: LALIGR/LAHUDT processed');

Line 8990: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- rviriyal bug #6310553

8986: raise header_rule_failed;
8987: END IF;
8988:
8989: --IF (l_rgp_id IS NULL) THEN
8990: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- rviriyal bug #6310553
8991: l_rgp_id := x_rgpv_rec.id;
8992: END IF;
8993:
8994: debug_message('------>Rule: LALIGR/LALIEX processed');

Line 9072: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- rviriyal bug #6310553

9068: raise header_rule_failed;
9069: END IF;
9070:
9071: --IF (l_rgp_id IS NULL) THEN
9072: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- rviriyal bug #6310553
9073: l_rgp_id := x_rgpv_rec.id;
9074: END IF;
9075:
9076: debug_message('------>Rule: LALIGR/LALCIN processed');

Line 9141: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- Bug 5085099

9137: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
9138: raise header_rule_failed;
9139: END IF;
9140:
9141: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- Bug 5085099
9142: l_rgp_id := x_rgpv_rec.id;
9143: END IF;
9144:
9145: debug_message('------>Rule: LALCGR/LAHUDT processed');

Line 9223: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- Bug 5085099

9219: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
9220: raise header_rule_failed;
9221: END IF;
9222:
9223: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- Bug 5085099
9224: l_rgp_id := x_rgpv_rec.id;
9225: END IF;
9226:
9227: debug_message('------>Rule: LALCGR/LALCPR processed');

Line 9283: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

9279: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
9280: raise header_rule_failed;
9281: END IF;
9282:
9283: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
9284: l_rgp_id := x_rgpv_rec.id;
9285: END IF;
9286:
9287: debug_message('------>Rule: LALCGR/LALCEX processed');

Line 9351: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

9347: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
9348: raise header_rule_failed;
9349: END IF;
9350:
9351: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
9352: l_rgp_id := x_rgpv_rec.id; --store rgp_id
9353: END IF;
9354:
9355: END IF; -- variable_rate

Line 9451: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

9447: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
9448: raise header_rule_failed;
9449: END IF;
9450:
9451: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
9452: l_rgp_id := x_rgpv_rec.id;
9453: END IF;
9454:
9455: debug_message('------>Rule: LAIIND/LAICON processed');

Line 9624: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

9620: x_return_status := OKL_API.G_RET_STS_ERROR;
9621: raise header_rule_failed;
9622: END IF;
9623:
9624: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
9625: l_rgp_id := x_rgpv_rec.id;
9626: END IF;
9627:
9628: debug_message('------>Rule: LAIIND/LAIVAR processed');

Line 9735: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

9731: x_return_status := OKL_API.G_RET_STS_ERROR;
9732: raise header_rule_failed;
9733: END IF;
9734:
9735: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
9736: l_rgp_id := x_rgpv_rec.id;
9737: END IF;
9738:
9739: debug_message('------>Rule: LAIIND/LAICLC processed');

Line 9794: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

9790: x_return_status := OKL_API.G_RET_STS_ERROR;
9791: raise header_rule_failed;
9792: END IF;
9793:
9794: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
9795: l_rgp_id := x_rgpv_rec.id;
9796: END IF;
9797:
9798: debug_message('------>Rule: LAIIND/LAFORM processed');

Line 9899: p_init_msg_list => OKC_API.G_FALSE,

9895: l_tmpl_rate_rec.PRINCIPAL_BASIS_CODE;
9896: ELSE
9897: okl_k_rate_params_pvt.default_k_rate_params(
9898: p_api_version => 1,
9899: p_init_msg_list => OKC_API.G_FALSE,
9900: x_return_status => x_return_status,
9901: x_msg_count => x_msg_count,
9902: x_msg_data => x_msg_data,
9903: p_deal_type => G_DEAL_TYPE,

Line 9920: p_init_msg_list => OKC_API.G_FALSE,

9916: l_tmpl_rate_rec.DAYS_IN_A_MONTH_CODE;
9917: ELSE
9918: okl_k_rate_params_pvt.default_k_rate_params(
9919: p_api_version => 1,
9920: p_init_msg_list => OKC_API.G_FALSE,
9921: x_return_status => x_return_status,
9922: x_msg_count => x_msg_count,
9923: x_msg_data => x_msg_data,
9924: p_deal_type => G_DEAL_TYPE,

Line 9941: p_init_msg_list => OKC_API.G_FALSE,

9937: l_tmpl_rate_rec.DAYS_IN_A_YEAR_CODE;
9938: ELSE
9939: okl_k_rate_params_pvt.default_k_rate_params(
9940: p_api_version => 1,
9941: p_init_msg_list => OKC_API.G_FALSE,
9942: x_return_status => x_return_status,
9943: x_msg_count => x_msg_count,
9944: x_msg_data => x_msg_data,
9945: p_deal_type => G_DEAL_TYPE,

Line 9962: p_init_msg_list => OKC_API.G_FALSE,

9958: l_tmpl_rate_rec.INTEREST_BASIS_CODE;
9959: ELSE
9960: okl_k_rate_params_pvt.default_k_rate_params(
9961: p_api_version => 1,
9962: p_init_msg_list => OKC_API.G_FALSE,
9963: x_return_status => x_return_status,
9964: x_msg_count => x_msg_count,
9965: x_msg_data => x_msg_data,
9966: p_deal_type => G_DEAL_TYPE,

Line 9999: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

9995: debug_message('Var Rate 1.2');
9996: IF (p_header_rec.FORMULA_NAME IS NOT NULL) THEN
9997: l_formula_id := get_formula_id(p_header_rec.FORMULA_NAME,
9998: x_return_status);
9999: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
10000: --AKP: Todo: set message: Invalid formula name 5024651
10001: okl_api.set_message(
10002: G_APP_NAME,
10003: G_INVALID_VALUE,

Line 10034: p_init_msg_list => OKC_API.G_FALSE,

10030: l_tmpl_rate_rec.CATCHUP_BASIS_CODE;
10031: ELSE
10032: okl_k_rate_params_pvt.default_k_rate_params(
10033: p_api_version => 1,
10034: p_init_msg_list => OKC_API.G_FALSE,
10035: x_return_status => x_return_status,
10036: x_msg_count => x_msg_count,
10037: x_msg_data => x_msg_data,
10038: p_deal_type => G_DEAL_TYPE,

Line 10077: p_init_msg_list => OKC_API.G_FALSE,

10073: /* Removed for Forwar port Bug 8614628
10074: ELSE
10075: okl_k_rate_params_pvt.default_k_rate_params(
10076: p_api_version => 1,
10077: p_init_msg_list => OKC_API.G_FALSE,
10078: x_return_status => x_return_status,
10079: x_msg_count => x_msg_count,
10080: x_msg_data => x_msg_data,
10081: p_deal_type => G_DEAL_TYPE,

Line 10156: OKC_API.set_message(p_app_name => G_APP_NAME,

10152: p_header_rec.CONVERT_TYPE IS NOT NULL
10153: )
10154: THEN
10155: -- Set error. Effective from date is missing
10156: OKC_API.set_message(p_app_name => G_APP_NAME,
10157: p_msg_name => G_REQUIRED_VALUE,
10158: p_token1 => G_COL_NAME_TOKEN,
10159: p_token1_value => 'Effective_From_Date');
10160: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 10160: x_return_status := OKC_API.G_RET_STS_ERROR;

10156: OKC_API.set_message(p_app_name => G_APP_NAME,
10157: p_msg_name => G_REQUIRED_VALUE,
10158: p_token1 => G_COL_NAME_TOKEN,
10159: p_token1_value => 'Effective_From_Date');
10160: x_return_status := OKC_API.G_RET_STS_ERROR;
10161: RAISE header_rule_failed;
10162: END IF;
10163:
10164: END IF;

Line 10284: p_init_msg_list => OKC_API.G_FALSE,

10280: l_tmpl_rate_rec.PRINCIPAL_BASIS_CODE;
10281: ELSE
10282: okl_k_rate_params_pvt.default_k_rate_params(
10283: p_api_version => 1,
10284: p_init_msg_list => OKC_API.G_FALSE,
10285: x_return_status => x_return_status,
10286: x_msg_count => x_msg_count,
10287: x_msg_data => x_msg_data,
10288: p_deal_type => G_DEAL_TYPE,

Line 10305: p_init_msg_list => OKC_API.G_FALSE,

10301: l_tmpl_rate_rec.DAYS_IN_A_MONTH_CODE;
10302: ELSE
10303: okl_k_rate_params_pvt.default_k_rate_params(
10304: p_api_version => 1,
10305: p_init_msg_list => OKC_API.G_FALSE,
10306: x_return_status => x_return_status,
10307: x_msg_count => x_msg_count,
10308: x_msg_data => x_msg_data,
10309: p_deal_type => G_DEAL_TYPE,

Line 10326: p_init_msg_list => OKC_API.G_FALSE,

10322: l_tmpl_rate_rec.DAYS_IN_A_YEAR_CODE;
10323: ELSE
10324: okl_k_rate_params_pvt.default_k_rate_params(
10325: p_api_version => 1,
10326: p_init_msg_list => OKC_API.G_FALSE,
10327: x_return_status => x_return_status,
10328: x_msg_count => x_msg_count,
10329: x_msg_data => x_msg_data,
10330: p_deal_type => G_DEAL_TYPE,

Line 10347: p_init_msg_list => OKC_API.G_FALSE,

10343: l_tmpl_rate_rec.INTEREST_BASIS_CODE;
10344: ELSE
10345: okl_k_rate_params_pvt.default_k_rate_params(
10346: p_api_version => 1,
10347: p_init_msg_list => OKC_API.G_FALSE,
10348: x_return_status => x_return_status,
10349: x_msg_count => x_msg_count,
10350: x_msg_data => x_msg_data,
10351: p_deal_type => G_DEAL_TYPE,

Line 10383: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

10379:
10380: IF (p_header_rec.INT_RATE_CON_FORMULA_NAME IS NOT NULL) THEN
10381: l_formula_id := get_formula_id(p_header_rec.INT_RATE_CON_FORMULA_NAME,
10382: x_return_status);
10383: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
10384: --AKP: Todo: set message: Invalid formula name 5024651
10385: okl_api.set_message(
10386: G_APP_NAME,
10387: G_INVALID_VALUE,

Line 10418: p_init_msg_list => OKC_API.G_FALSE,

10414: l_tmpl_rate_rec.CATCHUP_BASIS_CODE;
10415: ELSE
10416: okl_k_rate_params_pvt.default_k_rate_params(
10417: p_api_version => 1,
10418: p_init_msg_list => OKC_API.G_FALSE,
10419: x_return_status => x_return_status,
10420: x_msg_count => x_msg_count,
10421: x_msg_data => x_msg_data,
10422: p_deal_type => G_DEAL_TYPE,

Line 10460: p_init_msg_list => OKC_API.G_FALSE,

10456: l_tmpl_rate_rec.RATE_CHANGE_FREQUENCY_CODE;
10457: ELSE
10458: okl_k_rate_params_pvt.default_k_rate_params(
10459: p_api_version => 1,
10460: p_init_msg_list => OKC_API.G_FALSE,
10461: x_return_status => x_return_status,
10462: x_msg_count => x_msg_count,
10463: x_msg_data => x_msg_data,
10464: p_deal_type => G_DEAL_TYPE,

Line 10512: OKC_API.set_message(p_app_name => G_APP_NAME,

10508: p_header_rec.INT_RATE_CON_CHG_VALUE IS NOT NULL OR
10509: p_header_rec.INT_RATE_CON_CAT_FREQ_CODE IS NOT NULL )
10510: THEN
10511: -- Set error. Effective from date is missing
10512: OKC_API.set_message(p_app_name => G_APP_NAME,
10513: p_msg_name => G_REQUIRED_VALUE,
10514: p_token1 => G_COL_NAME_TOKEN,
10515: p_token1_value => 'Effective_From_Date_Con');
10516: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 10516: x_return_status := OKC_API.G_RET_STS_ERROR;

10512: OKC_API.set_message(p_app_name => G_APP_NAME,
10513: p_msg_name => G_REQUIRED_VALUE,
10514: p_token1 => G_COL_NAME_TOKEN,
10515: p_token1_value => 'Effective_From_Date_Con');
10516: x_return_status := OKC_API.G_RET_STS_ERROR;
10517: RAISE header_rule_failed;
10518:
10519: END IF;
10520:

Line 10527: p_init_msg_list => OKC_API.G_FALSE,

10523: debug_message('l_rate_counter=' || l_rate_counter);
10524: IF (l_rate_counter > 1) THEN
10525: OKL_K_RATE_PARAMS_PVT.validate_k_rate_params(
10526: p_api_version => 1 ,
10527: p_init_msg_list => OKC_API.G_FALSE,
10528: x_return_status => x_return_status,
10529: x_msg_count => x_msg_count,
10530: x_msg_data => x_msg_data,
10531: p_product_id => G_PRODUCT_ID,

Line 10540: p_init_msg_list => OKC_API.G_FALSE,

10536: FOR krpv_rec_cnt IN l_k_rate_tbl.FIRST..l_k_rate_tbl.LAST
10537: LOOP
10538: OKL_K_RATE_PARAMS_PVT.create_k_rate_params(
10539: p_api_version => 1 ,
10540: p_init_msg_list => OKC_API.G_FALSE,
10541: x_return_status => x_return_status,
10542: x_msg_count => x_msg_count,
10543: x_msg_data => x_msg_data,
10544: p_krpv_rec => l_k_rate_tbl(krpv_rec_cnt),

Line 10645: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

10641: x_return_status := OKL_API.G_RET_STS_ERROR;
10642: raise header_rule_failed;
10643: END IF;
10644:
10645: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
10646: l_rgp_id := x_rgpv_rec.id;
10647: END IF;
10648:
10649: debug_message('------>Rule: LAFCTG/LAFCTG processed');

Line 10712: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

10708: x_return_status := OKL_API.G_RET_STS_ERROR;
10709: raise header_rule_failed;
10710: END IF;
10711:
10712: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
10713: l_rgp_id := x_rgpv_rec.id;
10714: END IF;
10715:
10716: debug_message('------>Rule: LAEVEL/LAEVEL processed');

Line 10783: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

10779: x_return_status := OKL_API.G_RET_STS_ERROR;
10780: raise header_rule_failed;
10781: END IF;
10782:
10783: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
10784: l_rgp_id := x_rgpv_rec.id;
10785: END IF;
10786: debug_message('------>Rule: LAEVEL/LAEVPT processed');
10787: l_rulv_rec := NULL;

Line 10882: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

10878: x_return_status := OKL_API.G_RET_STS_ERROR;
10879: raise header_rule_failed;
10880: END IF;
10881:
10882: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
10883: l_rgp_id := x_rgpv_rec.id;
10884: END IF;
10885:
10886: debug_message('------>Rule: LABILL/BTO processed');

Line 10982: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

10978: x_return_status := OKL_API.G_RET_STS_ERROR;
10979: raise header_rule_failed;
10980: END IF;
10981:
10982: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
10983: l_rgp_id := x_rgpv_rec.id;
10984: END IF;
10985:
10986: END IF; --bank_account_id

Line 11055: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

11051: x_return_status := OKL_API.G_RET_STS_ERROR;
11052: raise header_rule_failed;
11053: END IF;
11054:
11055: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
11056: l_rgp_id := x_rgpv_rec.id;
11057: END IF;
11058:
11059: debug_message('------>Rule: LABILL/LAINPR processed');

Line 11208: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- Bug 5085099

11204: x_return_status := OKL_API.G_RET_STS_ERROR;
11205: raise header_rule_failed;
11206: END IF;
11207:
11208: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- Bug 5085099
11209: l_rgp_id := x_rgpv_rec.id;
11210: END IF;
11211:
11212: debug_message('------>Rule: LABILL/LAINVD processed');

Line 11287: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

11283: x_return_status := OKL_API.G_RET_STS_ERROR;
11284: raise header_rule_failed;
11285: END IF;
11286:
11287: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
11288: l_rgp_id := x_rgpv_rec.id;
11289: END IF;
11290:
11291: debug_message('------>Rule: LABILL/LAPMTH processed');

Line 11352: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

11348: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
11349: raise header_rule_failed;
11350: END IF;
11351:
11352: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
11353: l_rgp_id := x_rgpv_rec.id;
11354: END IF;
11355:
11356: END IF; -- capitalize

Line 11419: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

11415: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
11416: raise header_rule_failed;
11417: END IF;
11418:
11419: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
11420: l_rgp_id := x_rgpv_rec.id;
11421: END IF;
11422:
11423: END IF; -- non_notification

Line 11591: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

11587: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
11588: raise header_rule_failed;
11589: END IF;
11590:
11591: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
11592: l_rgp_id := x_rgpv_rec.id;
11593: END IF;
11594: END IF; -- if rvi_auto_calculate_flag = 'Y'
11595: -- Bug 4655611

Line 11690: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

11686: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
11687: raise header_rule_failed;
11688: END IF;
11689:
11690: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
11691: l_rgp_id := x_rgpv_rec.id;
11692: END IF;
11693:
11694: debug_message('------>Rule: LARVIN/LARVAM processed');

Line 11755: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

11751: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
11752: raise header_rule_failed;
11753: END IF;
11754:
11755: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
11756: l_rgp_id := x_rgpv_rec.id;
11757: END IF;
11758:
11759: END IF; -- tax_withholding_flag

Line 11814: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

11810: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
11811: raise header_rule_failed;
11812: END IF;
11813:
11814: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
11815: l_rgp_id := x_rgpv_rec.id;
11816: END IF;
11817:
11818: END IF; -- tax_calc_formula_name

Line 11886: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

11882: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
11883: raise header_rule_failed;
11884: END IF;
11885:
11886: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
11887: l_rgp_id := x_rgpv_rec.id;
11888: END IF;
11889:
11890: END IF; -- tax_owner

Line 12036: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

12032: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
12033: raise header_rule_failed;
12034: END IF;
12035:
12036: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
12037: l_rgp_id := x_rgpv_rec.id;
12038: END IF;
12039:
12040: debug_message('------>Rule: AMLARL/AMCFPR processed');

Line 12117: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

12113: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
12114: raise header_rule_failed;
12115: END IF;
12116:
12117: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
12118: l_rgp_id := x_rgpv_rec.id;
12119: END IF;
12120: debug_message('------>Rule: AMREPQ/AMARQC processed');
12121: l_rulv_rec := NULL;

Line 12212: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

12208: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
12209: raise header_rule_failed;
12210: END IF;
12211:
12212: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
12213: l_rgp_id := x_rgpv_rec.id;
12214: END IF;
12215:
12216: debug_message('------>Rule: AMREPQ/AMBSPR processed');

Line 12308: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

12304: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
12305: raise header_rule_failed;
12306: END IF;
12307:
12308: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
12309: l_rgp_id := x_rgpv_rec.id;
12310: END IF;
12311: debug_message('------>Rule: AMREPQ/AMCQDR processed');
12312: l_rulv_rec := NULL;

Line 12403: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

12399: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
12400: raise header_rule_failed;
12401: END IF;
12402:
12403: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
12404: l_rgp_id := x_rgpv_rec.id;
12405: END IF;
12406:
12407: debug_message('------>Rule: AMREPQ/AMCQFE processed');

Line 12600: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

12596: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
12597: raise header_rule_failed;
12598: END IF;
12599:
12600: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
12601: l_rgp_id := x_rgpv_rec.id;
12602: END IF;
12603:
12604: debug_message('------>Rule: AMTEOC/AMBPOC processed');

Line 12797: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

12793: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
12794: raise header_rule_failed;
12795: END IF;
12796:
12797: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
12798: l_rgp_id := x_rgpv_rec.id;
12799: END IF;
12800:
12801: debug_message('------>Rule: AMTFOC/AMBPOC processed');

Line 12855: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

12851: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
12852: raise header_rule_failed;
12853: END IF;
12854:
12855: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
12856: l_rgp_id := x_rgpv_rec.id;
12857: END IF;
12858:
12859: debug_message('------>Rule: AMTFOC/AMTINV processed');

Line 12942: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

12938: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
12939: raise header_rule_failed;
12940: END IF;
12941:
12942: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
12943: l_rgp_id := x_rgpv_rec.id;
12944: END IF;
12945: debug_message('------>Rule: AMTQPR/AMCTTA processed');
12946: l_rulv_rec := NULL;

Line 12998: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

12994: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
12995: raise header_rule_failed;
12996: END IF;
12997:
12998: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
12999: l_rgp_id := x_rgpv_rec.id;
13000: END IF;
13001:
13002: debug_message('------>Rule: AMTQPR/AMPTQA processed');

Line 13068: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

13064: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
13065: raise header_rule_failed;
13066: END IF;
13067:
13068: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
13069: l_rgp_id := x_rgpv_rec.id;
13070: END IF;
13071: debug_message('------>Rule: AMTQPR/AMQTEF processed');
13072: l_rulv_rec := NULL;

Line 13124: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

13120: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
13121: raise header_rule_failed;
13122: END IF;
13123:
13124: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
13125: l_rgp_id := x_rgpv_rec.id;
13126: END IF;
13127:
13128: debug_message('------>Rule: AMTQPR/AMTSET processed');

Line 13184: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

13180: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
13181: raise header_rule_failed;
13182: END IF;
13183:
13184: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
13185: l_rgp_id := x_rgpv_rec.id;
13186: END IF;
13187: debug_message('------>Rule: AMTQPR/AMFBOS processed');
13188:

Line 13241: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

13237: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
13238: raise header_rule_failed;
13239: END IF;
13240:
13241: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
13242: l_rgp_id := x_rgpv_rec.id;
13243: END IF;
13244: debug_message('------>Rule: AMTQPR/AMCMTQ processed');
13245:

Line 13298: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

13294: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
13295: raise header_rule_failed;
13296: END IF;
13297:
13298: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
13299: l_rgp_id := x_rgpv_rec.id;
13300: END IF;
13301: debug_message('------>Rule: AMTQPR/AMDFTD processed');
13302:

Line 13366: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

13362: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
13363: raise header_rule_failed;
13364: END IF;
13365:
13366: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
13367: l_rgp_id := x_rgpv_rec.id;
13368: END IF;
13369: debug_message('------>Rule: AMTPAR/AMAPRE processed');
13370: l_rulv_rec := NULL;

Line 13423: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

13419: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
13420: raise header_rule_failed;
13421: END IF;
13422:
13423: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
13424: l_rgp_id := x_rgpv_rec.id;
13425: END IF;
13426:
13427: debug_message('------>Rule: AMTPAR/AMPTQA processed');

Line 13491: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

13487: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
13488: raise header_rule_failed;
13489: END IF;
13490:
13491: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
13492: l_rgp_id := x_rgpv_rec.id;
13493: END IF;
13494: debug_message('------>Rule: AMTGAL/AMAPRE processed');
13495: l_rulv_rec := NULL;

Line 13639: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

13635: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
13636: raise header_rule_failed;
13637: END IF;
13638:
13639: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
13640: l_rgp_id := x_rgpv_rec.id;
13641: END IF;
13642: debug_message('------>Rule: AMTGAL/AMGALO processed');
13643:

Line 13705: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

13701: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
13702: raise header_rule_failed;
13703: END IF;
13704:
13705: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
13706: l_rgp_id := x_rgpv_rec.id;
13707: END IF;
13708:
13709: debug_message('------>Rule: AMQR1R/AMLCRO processed');

Line 13777: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

13773: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
13774: raise header_rule_failed;
13775: END IF;
13776:
13777: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
13778: l_rgp_id := x_rgpv_rec.id;
13779: END IF;
13780:
13781: debug_message('------>Rule: AMQR1R/AMLCRP processed');

Line 13844: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

13840: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
13841: raise header_rule_failed;
13842: END IF;
13843:
13844: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
13845: l_rgp_id := x_rgpv_rec.id;
13846: END IF;
13847:
13848: debug_message('------>Rule: AMQR5A/AMLCAP processed');

Line 13914: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

13910: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
13911: raise header_rule_failed;
13912: END IF;
13913:
13914: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
13915: l_rgp_id := x_rgpv_rec.id;
13916: END IF;
13917:
13918: debug_message('------>Rule: AMQR5A/AMLCAV processed');

Line 13981: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

13977: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
13978: raise header_rule_failed;
13979: END IF;
13980:
13981: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
13982: l_rgp_id := x_rgpv_rec.id;
13983: END IF;
13984:
13985: debug_message('------>Rule: AMQR9F/AMLCCO processed');

Line 14061: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

14057: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
14058: raise header_rule_failed;
14059: END IF;
14060:
14061: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
14062: l_rgp_id := x_rgpv_rec.id;
14063: END IF;
14064: debug_message('------>Rule: AMTEWC/AMATQC processed');
14065: l_rulv_rec := NULL;

Line 14156: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

14152: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
14153: raise header_rule_failed;
14154: END IF;
14155:
14156: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
14157: l_rgp_id := x_rgpv_rec.id;
14158: END IF;
14159: debug_message('------>Rule: AMTEWC/AMBCOC processed');
14160: l_rulv_rec := NULL;

Line 14251: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

14247: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
14248: raise header_rule_failed;
14249: END IF;
14250:
14251: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
14252: l_rgp_id := x_rgpv_rec.id;
14253: END IF;
14254: debug_message('------>Rule: AMTEWC/AMCQDR processed');
14255: l_rulv_rec := NULL;

Line 14346: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

14342: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
14343: raise header_rule_failed;
14344: END IF;
14345:
14346: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
14347: l_rgp_id := x_rgpv_rec.id;
14348: END IF;
14349: debug_message('------>Rule: AMTEWC/AMCQFE processed');
14350: l_rulv_rec := NULL;

Line 14441: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

14437: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
14438: raise header_rule_failed;
14439: END IF;
14440:
14441: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
14442: l_rgp_id := x_rgpv_rec.id;
14443: END IF;
14444: debug_message('------>Rule: AMTEWC/AMCRFE processed');
14445: l_rulv_rec := NULL;

Line 14536: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

14532: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
14533: raise header_rule_failed;
14534: END IF;
14535:
14536: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
14537: l_rgp_id := x_rgpv_rec.id;
14538: END IF;
14539: debug_message('------>Rule: AMTEWC/AMCRIN processed');
14540: l_rulv_rec := NULL;

Line 14631: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

14627: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
14628: raise header_rule_failed;
14629: END IF;
14630:
14631: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
14632: l_rgp_id := x_rgpv_rec.id;
14633: END IF;
14634: debug_message('------>Rule: AMTEWC/AMCSDD processed');
14635: l_rulv_rec := NULL;

Line 14765: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

14761: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
14762: raise header_rule_failed;
14763: END IF;
14764:
14765: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
14766: l_rgp_id := x_rgpv_rec.id;
14767: END IF;
14768: debug_message('------>Rule: AMTEWC/AMCTPE processed');
14769: l_rulv_rec := NULL;

Line 14860: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

14856: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
14857: raise header_rule_failed;
14858: END IF;
14859:
14860: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
14861: l_rgp_id := x_rgpv_rec.id;
14862: END IF;
14863: debug_message('------>Rule: AMTEWC/AMPRTX processed');
14864: l_rulv_rec := NULL;

Line 14916: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

14912: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
14913: raise header_rule_failed;
14914: END IF;
14915:
14916: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
14917: l_rgp_id := x_rgpv_rec.id;
14918: END IF;
14919: debug_message('------>Rule: AMTEWC/AMYFEE processed');
14920: l_rulv_rec := NULL;

Line 14972: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

14968: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
14969: raise header_rule_failed;
14970: END IF;
14971:
14972: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
14973: l_rgp_id := x_rgpv_rec.id;
14974: END IF;
14975: debug_message('------>Rule: AMTEWC/AMYOUB processed');
14976: l_rulv_rec := NULL;

Line 15042: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

15038: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
15039: raise header_rule_failed;
15040: END IF;
15041:
15042: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
15043: l_rgp_id := x_rgpv_rec.id;
15044: END IF;
15045:
15046: debug_message('------>Rule: AMTEWC/AMYSAM processed');

Line 15101: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

15097: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
15098: raise header_rule_failed;
15099: END IF;
15100:
15101: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
15102: l_rgp_id := x_rgpv_rec.id;
15103: END IF;
15104:
15105: debug_message('------>Rule: AMTEWC/AMAFEE processed');

Line 15159: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

15155: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
15156: raise header_rule_failed;
15157: END IF;
15158:
15159: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
15160: l_rgp_id := x_rgpv_rec.id;
15161: END IF;
15162:
15163: debug_message('------>Rule: AMTEWC/AMEFEE processed');

Line 15217: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

15213: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
15214: raise header_rule_failed;
15215: END IF;
15216:
15217: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
15218: l_rgp_id := x_rgpv_rec.id;
15219: END IF;
15220:
15221: debug_message('------>Rule: AMTEWC/AMFFEE processed');

Line 15275: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

15271: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
15272: raise header_rule_failed;
15273: END IF;
15274:
15275: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
15276: l_rgp_id := x_rgpv_rec.id;
15277: END IF;
15278:
15279: debug_message('------>Rule: AMTEWC/AMGFEE processed');

Line 15333: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

15329: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
15330: raise header_rule_failed;
15331: END IF;
15332:
15333: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
15334: l_rgp_id := x_rgpv_rec.id;
15335: END IF;
15336:
15337: debug_message('------>Rule: AMTEWC/AMIFEE processed');

Line 15391: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

15387: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
15388: raise header_rule_failed;
15389: END IF;
15390:
15391: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
15392: l_rgp_id := x_rgpv_rec.id;
15393: END IF;
15394:
15395: debug_message('------>Rule: AMTEWC/AMMFEE processed');

Line 15449: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

15445: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
15446: raise header_rule_failed;
15447: END IF;
15448:
15449: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
15450: l_rgp_id := x_rgpv_rec.id;
15451: END IF;
15452:
15453: debug_message('------>Rule: AMTEWC/AMPFEE processed');

Line 15507: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

15503: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
15504: raise header_rule_failed;
15505: END IF;
15506:
15507: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
15508: l_rgp_id := x_rgpv_rec.id;
15509: END IF;
15510:
15511: debug_message('------>Rule: AMTEWC/AMRFEE processed');

Line 15589: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

15585: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
15586: raise header_rule_failed;
15587: END IF;
15588:
15589: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
15590: l_rgp_id := x_rgpv_rec.id;
15591: END IF;
15592: debug_message('------>Rule: AMTFWC/AMATQC processed');
15593: l_rulv_rec := NULL;

Line 15684: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

15680: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
15681: raise header_rule_failed;
15682: END IF;
15683:
15684: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
15685: l_rgp_id := x_rgpv_rec.id;
15686: END IF;
15687: debug_message('------>Rule: AMTFWC/AMBCOC processed');
15688: l_rulv_rec := NULL;

Line 15779: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

15775: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
15776: raise header_rule_failed;
15777: END IF;
15778:
15779: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
15780: l_rgp_id := x_rgpv_rec.id;
15781: END IF;
15782: debug_message('------>Rule: AMTFWC/AMCQDR processed');
15783: l_rulv_rec := NULL;

Line 15874: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

15870: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
15871: raise header_rule_failed;
15872: END IF;
15873:
15874: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
15875: l_rgp_id := x_rgpv_rec.id;
15876: END IF;
15877: debug_message('------>Rule: AMTFWC/AMCQFE processed');
15878: l_rulv_rec := NULL;

Line 15969: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

15965: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
15966: raise header_rule_failed;
15967: END IF;
15968:
15969: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
15970: l_rgp_id := x_rgpv_rec.id;
15971: END IF;
15972: debug_message('------>Rule: AMTFWC/AMCRFE processed');
15973: l_rulv_rec := NULL;

Line 16064: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

16060: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
16061: raise header_rule_failed;
16062: END IF;
16063:
16064: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
16065: l_rgp_id := x_rgpv_rec.id;
16066: END IF;
16067: debug_message('------>Rule: AMTFWC/AMCRIN processed');
16068: l_rulv_rec := NULL;

Line 16159: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

16155: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
16156: raise header_rule_failed;
16157: END IF;
16158:
16159: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
16160: l_rgp_id := x_rgpv_rec.id;
16161: END IF;
16162: debug_message('------>Rule: AMTFWC/AMCSDD processed');
16163: l_rulv_rec := NULL;

Line 16293: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

16289: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
16290: raise header_rule_failed;
16291: END IF;
16292:
16293: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
16294: l_rgp_id := x_rgpv_rec.id;
16295: END IF;
16296: debug_message('------>Rule: AMTFWC/AMCTPE processed');
16297: l_rulv_rec := NULL;

Line 16388: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

16384: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
16385: raise header_rule_failed;
16386: END IF;
16387:
16388: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
16389: l_rgp_id := x_rgpv_rec.id;
16390: END IF;
16391: debug_message('------>Rule: AMTFWC/AMPRTX processed');
16392: l_rulv_rec := NULL;

Line 16444: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

16440: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
16441: raise header_rule_failed;
16442: END IF;
16443:
16444: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
16445: l_rgp_id := x_rgpv_rec.id;
16446: END IF;
16447: debug_message('------>Rule: AMTFWC/AMYFEE processed');
16448: l_rulv_rec := NULL;

Line 16500: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

16496: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
16497: raise header_rule_failed;
16498: END IF;
16499:
16500: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
16501: l_rgp_id := x_rgpv_rec.id;
16502: END IF;
16503: debug_message('------>Rule: AMTFWC/AMYOUB processed');
16504: l_rulv_rec := NULL;

Line 16570: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

16566: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
16567: raise header_rule_failed;
16568: END IF;
16569:
16570: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
16571: l_rgp_id := x_rgpv_rec.id;
16572: END IF;
16573:
16574: debug_message('------>Rule: AMTFWC/AMYSAM processed');

Line 16629: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

16625: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
16626: raise header_rule_failed;
16627: END IF;
16628:
16629: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
16630: l_rgp_id := x_rgpv_rec.id;
16631: END IF;
16632:
16633: debug_message('------>Rule: AMTFWC/AMAFEE processed');

Line 16687: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

16683: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
16684: raise header_rule_failed;
16685: END IF;
16686:
16687: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
16688: l_rgp_id := x_rgpv_rec.id;
16689: END IF;
16690:
16691: debug_message('------>Rule: AMTFWC/AMEFEE processed');

Line 16745: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

16741: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
16742: raise header_rule_failed;
16743: END IF;
16744:
16745: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
16746: l_rgp_id := x_rgpv_rec.id;
16747: END IF;
16748:
16749: debug_message('------>Rule: AMTFWC/AMFFEE processed');

Line 16803: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

16799: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
16800: raise header_rule_failed;
16801: END IF;
16802:
16803: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
16804: l_rgp_id := x_rgpv_rec.id;
16805: END IF;
16806:
16807: debug_message('------>Rule: AMTFWC/AMGFEE processed');

Line 16861: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

16857: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
16858: raise header_rule_failed;
16859: END IF;
16860:
16861: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
16862: l_rgp_id := x_rgpv_rec.id;
16863: END IF;
16864:
16865: debug_message('------>Rule: AMTFWC/AMIFEE processed');

Line 16919: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

16915: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
16916: raise header_rule_failed;
16917: END IF;
16918:
16919: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
16920: l_rgp_id := x_rgpv_rec.id;
16921: END IF;
16922:
16923: debug_message('------>Rule: AMTFWC/AMMFEE processed');

Line 16977: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

16973: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
16974: raise header_rule_failed;
16975: END IF;
16976:
16977: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
16978: l_rgp_id := x_rgpv_rec.id;
16979: END IF;
16980:
16981: debug_message('------>Rule: AMTFWC/AMPFEE processed');

Line 17035: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

17031: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
17032: raise header_rule_failed;
17033: END IF;
17034:
17035: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
17036: l_rgp_id := x_rgpv_rec.id;
17037: END IF;
17038:
17039: debug_message('------>Rule: AMTFWC/AMRFEE processed');

Line 17252: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

17248: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
17249: raise header_rule_failed;
17250: END IF;
17251:
17252: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
17253: l_rgp_id := x_rgpv_rec.id;
17254: END IF;
17255: debug_message('------>Rule: LAAFLG/LAFLLN processed');
17256: l_rulv_rec := NULL;

Line 17473: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

17469: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
17470: raise header_rule_failed;
17471: END IF;
17472:
17473: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
17474: l_rgp_id := x_rgpv_rec.id;
17475: END IF;
17476: debug_message('------>Rule: LAAFLG/LAFLTL processed');
17477:

Line 17546: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

17542: END IF;
17543:
17544: debug_message('------>Rule: AMCOPO/AMAPRE processed');
17545:
17546: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
17547: l_rgp_id := x_rgpv_rec.id;
17548: END IF;
17549: l_rulv_rec := NULL;
17550:

Line 17601: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

17597: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
17598: raise header_rule_failed;
17599: END IF;
17600:
17601: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
17602: l_rgp_id := x_rgpv_rec.id;
17603: END IF;
17604: debug_message('------>Rule: AMCOPO/AMPRAG processed');
17605: l_rulv_rec := NULL;

Line 17688: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

17684: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
17685: raise header_rule_failed;
17686: END IF;
17687:
17688: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
17689: l_rgp_id := x_rgpv_rec.id;
17690: END IF;
17691: debug_message('------>Rule: AMCOPO/AMPRBA processed');
17692: l_rulv_rec := NULL;

Line 17744: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

17740: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
17741: raise header_rule_failed;
17742: END IF;
17743:
17744: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
17745: l_rgp_id := x_rgpv_rec.id;
17746: END IF;
17747: l_rulv_rec := NULL;
17748:

Line 17799: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

17795: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
17796: raise header_rule_failed;
17797: END IF;
17798:
17799: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
17800: l_rgp_id := x_rgpv_rec.id;
17801: END IF;
17802: debug_message('------>Rule: AMCOPO/AMPRST processed');
17803: l_rulv_rec := NULL;

Line 17904: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

17900: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
17901: raise header_rule_failed;
17902: END IF;
17903:
17904: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
17905: l_rgp_id := x_rgpv_rec.id;
17906: END IF;
17907: debug_message('------>Rule: LAHDTX/LAPRTX processed');
17908: l_rulv_rec := NULL;

Line 17974: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

17970: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
17971: raise header_rule_failed;
17972: END IF;
17973:
17974: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
17975: l_rgp_id := x_rgpv_rec.id;
17976: END IF;
17977: debug_message('------>Rule: LAHDTX/LAMETX processed');
17978: l_rulv_rec := NULL;

Line 18030: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

18026: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
18027: raise header_rule_failed;
18028: END IF;
18029:
18030: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
18031: l_rgp_id := x_rgpv_rec.id;
18032: END IF;
18033: debug_message('------>Rule: LAHDTX/LAAUTX processed');
18034: l_rulv_rec := NULL;

Line 18165: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

18161: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
18162: raise header_rule_failed;
18163: END IF;
18164:
18165: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
18166: l_rgp_id := x_rgpv_rec.id;
18167: END IF;
18168: debug_message('------>Rule: LAHDTX/LASTCL processed');
18169: l_rulv_rec := NULL;

Line 18392: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

18388: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
18389: raise header_rule_failed;
18390: END IF;
18391:
18392: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
18393: l_rgp_id := x_rgpv_rec.id;
18394: END IF;
18395: debug_message('------>Rule: LAHDTX/LASTPR processed');
18396: l_rulv_rec := NULL;

Line 19804: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

19800: END IF;
19801:
19802: debug_message('------>Rule: LAPSTH/LAPTR processed');
19803:
19804: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
19805: l_rgp_id := x_rgpv_rec.id;
19806: END IF;
19807:
19808: l_rulv_rec := NULL;

Line 19838: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

19834: raise party_role_failed;
19835: END IF;
19836:
19837: debug_message('------>Rule: LAPSTH/LAPTO processed');
19838: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
19839: l_rgp_id := x_rgpv_rec.id;
19840: END IF;
19841:
19842: l_rulv_rec := NULL;

Line 19875: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

19871: raise party_role_failed;
19872: END IF;
19873:
19874: debug_message('------>Rule: LAPSTH/LAVPMT processed');
19875: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
19876: l_rgp_id := x_rgpv_rec.id;
19877: END IF;
19878:
19879: l_rulv_rec := NULL;

Line 19908: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

19904: END IF;
19905:
19906: debug_message('------>Rule: LAPSTH/LAPTRP processed');
19907:
19908: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
19909: l_rgp_id := x_rgpv_rec.id;
19910: END IF;
19911:
19912: l_rulv_rec := NULL;

Line 19939: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

19935: raise party_role_failed;
19936: END IF;
19937:
19938: debug_message('------>Rule: LAPSTH/LAPTBC processed');
19939: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
19940: l_rgp_id := x_rgpv_rec.id;
19941: END IF;
19942: */
19943: END IF; -- service vendor

Line 20075: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

20071: raise party_role_failed;
20072: END IF;
20073:
20074: debug_message('------>Fee Rule: LAPSTH/LAPTR processed');
20075: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
20076: l_rgp_id := x_rgpv_rec.id;
20077: END IF;
20078: l_rulv_rec := NULL;
20079: --debug_message('Site: '||x_pay_site_id1);

Line 20108: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

20104: raise party_role_failed;
20105: END IF;
20106:
20107: debug_message('------>Fee Rule: LAPSTH/LAPTO processed');
20108: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
20109: l_rgp_id := x_rgpv_rec.id;
20110: END IF;
20111:
20112: l_rulv_rec := NULL;

Line 20145: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

20141: raise party_role_failed;
20142: END IF;
20143:
20144: debug_message('------>Fee Rule: LAPSTH/LAVPMT processed');
20145: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
20146: l_rgp_id := x_rgpv_rec.id;
20147: END IF;
20148:
20149: l_rulv_rec := NULL;

Line 20177: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

20173: raise party_role_failed;
20174: END IF;
20175:
20176: debug_message('------>Fee Rule: LAPSTH/LAPTPR processed');
20177: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
20178: l_rgp_id := x_rgpv_rec.id;
20179: END IF;
20180:
20181: l_rulv_rec := NULL;

Line 20208: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

20204: raise party_role_failed;
20205: END IF;
20206:
20207: debug_message('------>Fee Rule: LAPSTH/LAPTBC processed');
20208: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
20209: l_rgp_id := x_rgpv_rec.id;
20210: END IF;
20211: */
20212: END IF; -- Fees vendor

Line 20356: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

20352: raise party_role_failed;
20353: END IF;
20354:
20355: debug_message('------>Fee Rule: LAGRDT/LAGRNP processed');
20356: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
20357: l_rgp_id := x_rgpv_rec.id;
20358: END IF;
20359:
20360: IF (p_guarantor_type IS NOT NULL) THEN

Line 20464: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

20460: END IF;
20461:
20462: debug_message('------>Rule: LAGRDT/LAGRNT processed');
20463:
20464: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
20465: l_rgp_id := x_rgpv_rec.id;
20466: END IF;
20467:
20468: END IF; -- guarantor_id

Line 20569: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

20565: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
20566: raise party_role_failed;
20567: END IF;
20568:
20569: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
20570: l_rgp_id := x_rgpv_rec.id;
20571: END IF;
20572: l_rulv_rec := NULL;
20573:

Line 20634: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

20630: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
20631: raise party_role_failed;
20632: END IF;
20633:
20634: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
20635: l_rgp_id := x_rgpv_rec.id;
20636: END IF;
20637: l_rulv_rec := NULL;
20638: ELSE

Line 20698: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

20694: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
20695: raise party_role_failed;
20696: END IF;
20697:
20698: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
20699: l_rgp_id := x_rgpv_rec.id;
20700: END IF;
20701: l_rulv_rec := NULL;
20702: ELSE

Line 20765: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

20761: x_return_status := OKL_API.G_RET_STS_ERROR;
20762: raise party_role_failed;
20763: END IF;
20764:
20765: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
20766: l_rgp_id := x_rgpv_rec.id;
20767: END IF;
20768:
20769: l_rulv_rec := NULL;

Line 20822: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

20818: x_return_status := OKL_API.G_RET_STS_ERROR;
20819: raise party_role_failed;
20820: END IF;
20821:
20822: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
20823: l_rgp_id := x_rgpv_rec.id;
20824: END IF;
20825: l_rulv_rec := NULL;
20826:

Line 20889: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

20885: x_return_status := OKL_API.G_RET_STS_ERROR;
20886: raise party_role_failed;
20887: END IF;
20888:
20889: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
20890: l_rgp_id := x_rgpv_rec.id;
20891: END IF;
20892: l_rulv_rec := NULL;
20893:

Line 20928: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

20924: x_return_status := OKL_API.G_RET_STS_ERROR;
20925: raise party_role_failed;
20926: END IF;
20927:
20928: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
20929: l_rgp_id := x_rgpv_rec.id;
20930: END IF;
20931: l_rulv_rec := NULL;
20932:

Line 22033: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

22029: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
22030: raise term_failed;
22031: END IF;
22032:
22033: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
22034: l_rgp_id := x_rgpv_rec.id;
22035: END IF;
22036: */
22037: IF (p_bank_account_id IS NOT NULL

Line 22085: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

22081: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
22082: raise term_failed;
22083: END IF;
22084:
22085: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
22086: l_rgp_id := x_rgpv_rec.id;
22087: END IF;
22088:
22089: END IF; --bank_account

Line 22165: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

22161: END IF;
22162: */
22163: /* Bug# 4284166 : not required
22164:
22165: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
22166: l_rgp_id := x_rgpv_rec.id;
22167: END IF;
22168: */
22169:

Line 22319: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

22315: END IF;
22316: */
22317: /* Bug# 4284166 : not required
22318:
22319: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
22320: l_rgp_id := x_rgpv_rec.id;
22321: END IF;
22322: */
22323: --

Line 22385: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136

22381: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
22382: raise term_failed;
22383: END IF;
22384:
22385: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
22386: l_rgp_id := x_rgpv_rec.id;
22387: END IF;
22388:
22389: END IF; -- payment method id

Line 22527: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136 --Bug# 6112766

22523: CLOSE get_rule_group_info;
22524: END IF;
22525: --Bug# 6112766: End
22526: -- IF (p_rg_id IS NULL) THEN
22527: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136 --Bug# 6112766
22528: IF (p_line_number IS NOT NULL) THEN -- line level rule group
22529: l_rgpv_rec := NULL;
22530: l_rgpv_rec.rgd_code := 'LALEVL';
22531: l_rgpv_rec.chr_id := NULL;

Line 25228: p_draft_yn => Okc_Api.G_TRUE,

25224: p_init_msg_list => p_init_msg_list,
25225: p_commit => Okl_Api.G_FALSE,
25226: p_contract_id => p_chr_id,
25227: p_transaction_type => 'Booking',
25228: p_draft_yn => Okc_Api.G_TRUE,
25229: x_return_status => x_return_status,
25230: x_msg_count => x_msg_count,
25231: x_msg_data => x_msg_data
25232: );

Line 25256: p_draft_yn => Okc_Api.G_TRUE,

25252: p_init_msg_list => p_init_msg_list,
25253: p_commit => Okl_Api.G_FALSE,
25254: p_contract_id => p_chr_id,
25255: p_transaction_type => 'Booking',
25256: p_draft_yn => Okc_Api.G_TRUE,
25257: x_return_status => x_return_status,
25258: x_msg_count => x_msg_count,
25259: x_msg_data => x_msg_data
25260: );

Line 25310: p_draft_yn => Okc_Api.G_TRUE,

25306: p_init_msg_list => p_init_msg_list,
25307: p_commit => Okl_Api.G_FALSE,
25308: p_contract_id => p_chr_id,
25309: p_transaction_type => 'Booking',
25310: p_draft_yn => Okc_Api.G_TRUE,
25311: x_return_status => x_return_status,
25312: x_msg_count => x_msg_count,
25313: x_msg_data => x_msg_data
25314: );

Line 26970: p_init_msg_list => OKC_API.G_FALSE,

26966: l_cimv_tbl(1) := l_cimv_rec;
26967:
26968: okl_create_kle_pub.create_add_on_line(
26969: p_api_version => 1,
26970: p_init_msg_list => OKC_API.G_FALSE,
26971: x_return_status => x_return_status,
26972: x_msg_count => x_msg_count,
26973: x_msg_data => x_msg_data,
26974: p_new_yn => 'Y',

Line 28808: Okc_Api.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'LEGAL_ENTITY_ID');

28804:
28805: CLOSE le_entity;
28806: IF (l_exists <>1 ) THEN
28807: debug_message('--->Legal entity is not valid for operating unit');
28808: Okc_Api.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'LEGAL_ENTITY_ID');
28809: RAISE item_not_found_error;
28810: END IF;
28811: END IF;
28812: l_khrv_rec.legal_entity_id := okl_header_rec.legal_entity_id ;

Line 31943: x_return_status := Okc_Api.G_RET_STS_ERROR;

31939: return;
31940:
31941: EXCEPTION
31942: WHEN item_not_found_error THEN
31943: x_return_status := Okc_Api.G_RET_STS_ERROR;
31944:
31945: WHEN OTHERS THEN
31946: okl_api.set_message(
31947: G_APP_NAME,

Line 32013: Okc_Api.set_message(p_app_name => 'OFA',

32009:
32010:
32011: IF x_request_id = 0 THEN
32012: -- Raise Error if the request has not been submitted successfully.
32013: Okc_Api.set_message(p_app_name => 'OFA',
32014: p_msg_name => 'FA_DEPRN_TAX_ERROR',
32015: p_token1 => 'REQUEST_ID',
32016: p_token1_value => x_request_id);
32017: