APPS.OKL_OPEN_INTERFACE_PVT dependencies on OKC_API

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

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

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

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

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

5295: RETURN;
5296: END IF;
5297:
5298: --IF (p_rgp_id IS NULL) THEN -- create rule group
5299: --Bug# 4284166 : Added check for p_rgp_id = OKC_API.G_MISS_NUM in if statement
5300: IF (p_rgp_id IS NULL or p_rgp_id = OKC_API.G_MISS_NUM) THEN -- create rule group
5301:
5302: OKL_RULE_PUB.create_rule_group(
5303: p_api_version => 1.0,

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

5296: END IF;
5297:
5298: --IF (p_rgp_id IS NULL) THEN -- create rule group
5299: --Bug# 4284166 : Added check for p_rgp_id = OKC_API.G_MISS_NUM in if statement
5300: IF (p_rgp_id IS NULL or p_rgp_id = OKC_API.G_MISS_NUM) THEN -- create rule group
5301:
5302: OKL_RULE_PUB.create_rule_group(
5303: p_api_version => 1.0,
5304: p_init_msg_list => OKL_API.G_FALSE,

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

5609: x_rulv_rec => x_rulv_rec
5610: );
5611: ELSE
5612: l_rulv_rec.id := l_sales_tax_rule_id;
5613: l_rulv_rec.created_by := OKC_API.G_MISS_NUM;
5614: l_rulv_rec.creation_date := OKC_API.G_MISS_DATE;
5615: OKL_RULE_PUB.update_rule(
5616: p_api_version => 1.0,
5617: p_init_msg_list => OKL_API.G_FALSE,

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

5610: );
5611: ELSE
5612: l_rulv_rec.id := l_sales_tax_rule_id;
5613: l_rulv_rec.created_by := OKC_API.G_MISS_NUM;
5614: l_rulv_rec.creation_date := OKC_API.G_MISS_DATE;
5615: OKL_RULE_PUB.update_rule(
5616: p_api_version => 1.0,
5617: p_init_msg_list => OKL_API.G_FALSE,
5618: x_return_status => x_return_status,

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

6279: x_rulv_rec => x_rulv_rec
6280: );
6281: ELSE
6282: l_rulv_rec.id := l_sales_tax_rule_id;
6283: l_rulv_rec.created_by := OKC_API.G_MISS_NUM;
6284: l_rulv_rec.creation_date := OKC_API.G_MISS_DATE;
6285: OKL_RULE_PUB.update_rule(
6286: p_api_version => 1.0,
6287: p_init_msg_list => OKL_API.G_FALSE,

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

6280: );
6281: ELSE
6282: l_rulv_rec.id := l_sales_tax_rule_id;
6283: l_rulv_rec.created_by := OKC_API.G_MISS_NUM;
6284: l_rulv_rec.creation_date := OKC_API.G_MISS_DATE;
6285: OKL_RULE_PUB.update_rule(
6286: p_api_version => 1.0,
6287: p_init_msg_list => OKL_API.G_FALSE,
6288: x_return_status => x_return_status,

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

6299: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
6300: raise line_rule_failed;
6301: END IF;
6302:
6303: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
6304: l_rgp_id := x_rgpv_rec.id;
6305: END IF;
6306:
6307: l_rulv_rec := NULL;

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

6364: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
6365: raise line_rule_failed;
6366: END IF;
6367:
6368: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
6369: l_rgp_id := x_rgpv_rec.id;
6370: END IF;
6371:
6372: l_rulv_rec := NULL;

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

6416: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
6417: raise line_rule_failed;
6418: END IF;
6419:
6420: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
6421: l_rgp_id := x_rgpv_rec.id;
6422: END IF;
6423:
6424: l_rulv_rec := NULL;

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

6448: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
6449: raise line_rule_failed;
6450: END IF;
6451:
6452: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
6453: l_rgp_id := x_rgpv_rec.id;
6454: END IF;
6455:
6456: l_rulv_rec := NULL;

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

6506: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
6507: raise line_rule_failed;
6508: END IF;
6509:
6510: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
6511: l_rgp_id := x_rgpv_rec.id;
6512: END IF;
6513: -- Added by rravikir (Fix for Bug 3947959)
6514: END IF;

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

6654: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
6655: raise line_rule_failed;
6656: END IF;
6657:
6658: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
6659: l_rgp_id := x_rgpv_rec.id;
6660: END IF;
6661:
6662: l_rulv_rec := NULL;

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

6761: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
6762: raise line_rule_failed;
6763: END IF;
6764:
6765: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
6766: l_rgp_id := x_rgpv_rec.id;
6767: END IF;
6768:
6769: END IF; -- line type

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

6807: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
6808: raise line_rule_failed;
6809: END IF;
6810:
6811: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
6812: l_rgp_id := x_rgpv_rec.id;
6813: END IF;
6814:
6815: l_rulv_rec := NULL;

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

6837: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
6838: raise line_rule_failed;
6839: END IF;
6840:
6841: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
6842: l_rgp_id := x_rgpv_rec.id;
6843: END IF;
6844:
6845: */

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

6885: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
6886: raise line_rule_failed;
6887: END IF;
6888:
6889: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
6890: l_rgp_id := x_rgpv_rec.id;
6891: END IF;
6892: END IF;
6893:

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

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

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

7019: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
7020: raise line_rule_failed;
7021: END IF;
7022:
7023: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
7024: l_rgp_id := x_rgpv_rec.id;
7025: END IF;
7026:
7027: END IF;

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

7320: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
7321: raise line_rule_failed;
7322: END IF;
7323:
7324: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
7325: l_rgp_id := x_rgpv_rec.id;
7326: END IF;
7327:
7328: END IF; -- line type USAGE

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

7417: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
7418: raise line_rule_failed;
7419: END IF;
7420:
7421: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
7422: l_rgp_id := x_rgpv_rec.id;
7423: END IF;
7424:
7425: IF (p_fee_frequency IS NOT NULL) THEN

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

7453: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
7454: raise line_rule_failed;
7455: END IF;
7456:
7457: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
7458: l_rgp_id := x_rgpv_rec.id;
7459: END IF;
7460: END IF;
7461:

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

7507: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
7508: raise line_rule_failed;
7509: END IF;
7510:
7511: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
7512: l_rgp_id := x_rgpv_rec.id;
7513: END IF;
7514:
7515: l_rulv_rec := NULL;

Line 7709: x_return_status := OKC_API.G_RET_STS_SUCCESS;

7705: function get_formula_id(p_name IN VARCHAR2,
7706: x_return_status OUT NOCOPY VARCHAR2) RETURN NUMBER IS
7707: l_formula_id number := 0;
7708: begin
7709: x_return_status := OKC_API.G_RET_STS_SUCCESS;
7710: select id
7711: INTO l_formula_id
7712: FROM OKL_FORMULAE_B
7713: WHERE NAME = p_name;

Line 7717: x_return_status := OKC_API.G_RET_STS_ERROR;

7713: WHERE NAME = p_name;
7714:
7715: return(l_formula_id);
7716: EXCEPTION WHEN OTHERS THEN
7717: x_return_status := OKC_API.G_RET_STS_ERROR;
7718: return(l_formula_id); -- 5024651
7719: end;
7720:
7721: ------------------------------------------------------------------------------

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

8273: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
8274: raise header_rule_failed;
8275: END IF;
8276:
8277: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
8278: l_rgp_id := x_rgpv_rec.id;
8279: END IF;
8280:
8281: END IF; -- x_customer_account_id

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

8346: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
8347: raise header_rule_failed;
8348: END IF;
8349:
8350: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
8351: l_rgp_id := x_rgpv_rec.id;
8352: END IF;
8353:
8354: END IF; -- rebook limit

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

8405: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
8406: raise header_rule_failed;
8407: END IF;
8408:
8409: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
8410: l_rgp_id := x_rgpv_rec.id;
8411: END IF;
8412:
8413: l_rulv_rec := NULL;

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

8446: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
8447: raise header_rule_failed;
8448: END IF;
8449:
8450: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
8451: l_rgp_id := x_rgpv_rec.id;
8452: END IF;
8453:
8454: --Not used currently - 05/20/2002

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

8544: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
8545: raise header_rule_failed;
8546: END IF;
8547:
8548: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
8549: l_rgp_id := x_rgpv_rec.id;
8550: END IF;
8551:
8552: debug_message('------>Rule: LASDEP/LASDEP processed');

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

8613: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
8614: raise header_rule_failed;
8615: END IF;
8616:
8617: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
8618: l_rgp_id := x_rgpv_rec.id;
8619: END IF;
8620:
8621: debug_message('------>Rule: LARNOP/LAREND processed');

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

8686: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
8687: raise header_rule_failed;
8688: END IF;
8689:
8690: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
8691: l_rgp_id := x_rgpv_rec.id;
8692: END IF;
8693:
8694: debug_message('------>Rule: LARNOP/LARNEW processed');

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

8757: raise header_rule_failed;
8758: END IF;
8759:
8760: -- IF (l_rgp_id IS NULL) THEN
8761: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- rviriyal bug #6310553
8762: l_rgp_id := x_rgpv_rec.id;
8763: END IF;
8764:
8765: debug_message('------>Rule: LALIGR/LAHUDT processed');

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

8818: raise header_rule_failed;
8819: END IF;
8820:
8821: --IF (l_rgp_id IS NULL) THEN
8822: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- rviriyal bug #6310553
8823: l_rgp_id := x_rgpv_rec.id;
8824: END IF;
8825:
8826: debug_message('------>Rule: LALIGR/LALIEX processed');

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

8900: raise header_rule_failed;
8901: END IF;
8902:
8903: --IF (l_rgp_id IS NULL) THEN
8904: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- rviriyal bug #6310553
8905: l_rgp_id := x_rgpv_rec.id;
8906: END IF;
8907:
8908: debug_message('------>Rule: LALIGR/LALCIN processed');

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

8969: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
8970: raise header_rule_failed;
8971: END IF;
8972:
8973: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- Bug 5085099
8974: l_rgp_id := x_rgpv_rec.id;
8975: END IF;
8976:
8977: debug_message('------>Rule: LALCGR/LAHUDT processed');

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

9051: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
9052: raise header_rule_failed;
9053: END IF;
9054:
9055: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- Bug 5085099
9056: l_rgp_id := x_rgpv_rec.id;
9057: END IF;
9058:
9059: debug_message('------>Rule: LALCGR/LALCPR processed');

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

9111: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
9112: raise header_rule_failed;
9113: END IF;
9114:
9115: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
9116: l_rgp_id := x_rgpv_rec.id;
9117: END IF;
9118:
9119: debug_message('------>Rule: LALCGR/LALCEX processed');

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

9179: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
9180: raise header_rule_failed;
9181: END IF;
9182:
9183: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
9184: l_rgp_id := x_rgpv_rec.id; --store rgp_id
9185: END IF;
9186:
9187: END IF; -- variable_rate

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: LAIIND/LAICON processed');

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

9452: x_return_status := OKL_API.G_RET_STS_ERROR;
9453: raise header_rule_failed;
9454: END IF;
9455:
9456: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
9457: l_rgp_id := x_rgpv_rec.id;
9458: END IF;
9459:
9460: debug_message('------>Rule: LAIIND/LAIVAR processed');

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

9563: x_return_status := OKL_API.G_RET_STS_ERROR;
9564: raise header_rule_failed;
9565: END IF;
9566:
9567: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
9568: l_rgp_id := x_rgpv_rec.id;
9569: END IF;
9570:
9571: debug_message('------>Rule: LAIIND/LAICLC processed');

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

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

Line 9731: p_init_msg_list => OKC_API.G_FALSE,

9727: l_tmpl_rate_rec.PRINCIPAL_BASIS_CODE;
9728: ELSE
9729: okl_k_rate_params_pvt.default_k_rate_params(
9730: p_api_version => 1,
9731: p_init_msg_list => OKC_API.G_FALSE,
9732: x_return_status => x_return_status,
9733: x_msg_count => x_msg_count,
9734: x_msg_data => x_msg_data,
9735: p_deal_type => G_DEAL_TYPE,

Line 9752: p_init_msg_list => OKC_API.G_FALSE,

9748: l_tmpl_rate_rec.DAYS_IN_A_MONTH_CODE;
9749: ELSE
9750: okl_k_rate_params_pvt.default_k_rate_params(
9751: p_api_version => 1,
9752: p_init_msg_list => OKC_API.G_FALSE,
9753: x_return_status => x_return_status,
9754: x_msg_count => x_msg_count,
9755: x_msg_data => x_msg_data,
9756: p_deal_type => G_DEAL_TYPE,

Line 9773: p_init_msg_list => OKC_API.G_FALSE,

9769: l_tmpl_rate_rec.DAYS_IN_A_YEAR_CODE;
9770: ELSE
9771: okl_k_rate_params_pvt.default_k_rate_params(
9772: p_api_version => 1,
9773: p_init_msg_list => OKC_API.G_FALSE,
9774: x_return_status => x_return_status,
9775: x_msg_count => x_msg_count,
9776: x_msg_data => x_msg_data,
9777: p_deal_type => G_DEAL_TYPE,

Line 9794: p_init_msg_list => OKC_API.G_FALSE,

9790: l_tmpl_rate_rec.INTEREST_BASIS_CODE;
9791: ELSE
9792: okl_k_rate_params_pvt.default_k_rate_params(
9793: p_api_version => 1,
9794: p_init_msg_list => OKC_API.G_FALSE,
9795: x_return_status => x_return_status,
9796: x_msg_count => x_msg_count,
9797: x_msg_data => x_msg_data,
9798: p_deal_type => G_DEAL_TYPE,

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

9827: debug_message('Var Rate 1.2');
9828: IF (p_header_rec.FORMULA_NAME IS NOT NULL) THEN
9829: l_formula_id := get_formula_id(p_header_rec.FORMULA_NAME,
9830: x_return_status);
9831: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
9832: --AKP: Todo: set message: Invalid formula name 5024651
9833: okl_api.set_message(
9834: G_APP_NAME,
9835: G_INVALID_VALUE,

Line 9866: p_init_msg_list => OKC_API.G_FALSE,

9862: l_tmpl_rate_rec.CATCHUP_BASIS_CODE;
9863: ELSE
9864: okl_k_rate_params_pvt.default_k_rate_params(
9865: p_api_version => 1,
9866: p_init_msg_list => OKC_API.G_FALSE,
9867: x_return_status => x_return_status,
9868: x_msg_count => x_msg_count,
9869: x_msg_data => x_msg_data,
9870: p_deal_type => G_DEAL_TYPE,

Line 9908: p_init_msg_list => OKC_API.G_FALSE,

9904: l_tmpl_rate_rec.RATE_CHANGE_FREQUENCY_CODE;
9905: ELSE
9906: okl_k_rate_params_pvt.default_k_rate_params(
9907: p_api_version => 1,
9908: p_init_msg_list => OKC_API.G_FALSE,
9909: x_return_status => x_return_status,
9910: x_msg_count => x_msg_count,
9911: x_msg_data => x_msg_data,
9912: p_deal_type => G_DEAL_TYPE,

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

9982: p_header_rec.CONVERT_TYPE IS NOT NULL
9983: )
9984: THEN
9985: -- Set error. Effective from date is missing
9986: OKC_API.set_message(p_app_name => G_APP_NAME,
9987: p_msg_name => G_REQUIRED_VALUE,
9988: p_token1 => G_COL_NAME_TOKEN,
9989: p_token1_value => 'Effective_From_Date');
9990: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 9990: x_return_status := OKC_API.G_RET_STS_ERROR;

9986: OKC_API.set_message(p_app_name => G_APP_NAME,
9987: p_msg_name => G_REQUIRED_VALUE,
9988: p_token1 => G_COL_NAME_TOKEN,
9989: p_token1_value => 'Effective_From_Date');
9990: x_return_status := OKC_API.G_RET_STS_ERROR;
9991: RAISE header_rule_failed;
9992: END IF;
9993:
9994: END IF;

Line 10114: p_init_msg_list => OKC_API.G_FALSE,

10110: l_tmpl_rate_rec.PRINCIPAL_BASIS_CODE;
10111: ELSE
10112: okl_k_rate_params_pvt.default_k_rate_params(
10113: p_api_version => 1,
10114: p_init_msg_list => OKC_API.G_FALSE,
10115: x_return_status => x_return_status,
10116: x_msg_count => x_msg_count,
10117: x_msg_data => x_msg_data,
10118: p_deal_type => G_DEAL_TYPE,

Line 10135: p_init_msg_list => OKC_API.G_FALSE,

10131: l_tmpl_rate_rec.DAYS_IN_A_MONTH_CODE;
10132: ELSE
10133: okl_k_rate_params_pvt.default_k_rate_params(
10134: p_api_version => 1,
10135: p_init_msg_list => OKC_API.G_FALSE,
10136: x_return_status => x_return_status,
10137: x_msg_count => x_msg_count,
10138: x_msg_data => x_msg_data,
10139: p_deal_type => G_DEAL_TYPE,

Line 10156: p_init_msg_list => OKC_API.G_FALSE,

10152: l_tmpl_rate_rec.DAYS_IN_A_YEAR_CODE;
10153: ELSE
10154: okl_k_rate_params_pvt.default_k_rate_params(
10155: p_api_version => 1,
10156: p_init_msg_list => OKC_API.G_FALSE,
10157: x_return_status => x_return_status,
10158: x_msg_count => x_msg_count,
10159: x_msg_data => x_msg_data,
10160: p_deal_type => G_DEAL_TYPE,

Line 10177: p_init_msg_list => OKC_API.G_FALSE,

10173: l_tmpl_rate_rec.INTEREST_BASIS_CODE;
10174: ELSE
10175: okl_k_rate_params_pvt.default_k_rate_params(
10176: p_api_version => 1,
10177: p_init_msg_list => OKC_API.G_FALSE,
10178: x_return_status => x_return_status,
10179: x_msg_count => x_msg_count,
10180: x_msg_data => x_msg_data,
10181: p_deal_type => G_DEAL_TYPE,

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

10209:
10210: IF (p_header_rec.INT_RATE_CON_FORMULA_NAME IS NOT NULL) THEN
10211: l_formula_id := get_formula_id(p_header_rec.INT_RATE_CON_FORMULA_NAME,
10212: x_return_status);
10213: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
10214: --AKP: Todo: set message: Invalid formula name 5024651
10215: okl_api.set_message(
10216: G_APP_NAME,
10217: G_INVALID_VALUE,

Line 10248: p_init_msg_list => OKC_API.G_FALSE,

10244: l_tmpl_rate_rec.CATCHUP_BASIS_CODE;
10245: ELSE
10246: okl_k_rate_params_pvt.default_k_rate_params(
10247: p_api_version => 1,
10248: p_init_msg_list => OKC_API.G_FALSE,
10249: x_return_status => x_return_status,
10250: x_msg_count => x_msg_count,
10251: x_msg_data => x_msg_data,
10252: p_deal_type => G_DEAL_TYPE,

Line 10290: p_init_msg_list => OKC_API.G_FALSE,

10286: l_tmpl_rate_rec.RATE_CHANGE_FREQUENCY_CODE;
10287: ELSE
10288: okl_k_rate_params_pvt.default_k_rate_params(
10289: p_api_version => 1,
10290: p_init_msg_list => OKC_API.G_FALSE,
10291: x_return_status => x_return_status,
10292: x_msg_count => x_msg_count,
10293: x_msg_data => x_msg_data,
10294: p_deal_type => G_DEAL_TYPE,

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

10338: p_header_rec.INT_RATE_CON_CHG_VALUE IS NOT NULL OR
10339: p_header_rec.INT_RATE_CON_CAT_FREQ_CODE IS NOT NULL )
10340: THEN
10341: -- Set error. Effective from date is missing
10342: OKC_API.set_message(p_app_name => G_APP_NAME,
10343: p_msg_name => G_REQUIRED_VALUE,
10344: p_token1 => G_COL_NAME_TOKEN,
10345: p_token1_value => 'Effective_From_Date_Con');
10346: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 10346: x_return_status := OKC_API.G_RET_STS_ERROR;

10342: OKC_API.set_message(p_app_name => G_APP_NAME,
10343: p_msg_name => G_REQUIRED_VALUE,
10344: p_token1 => G_COL_NAME_TOKEN,
10345: p_token1_value => 'Effective_From_Date_Con');
10346: x_return_status := OKC_API.G_RET_STS_ERROR;
10347: RAISE header_rule_failed;
10348:
10349: END IF;
10350:

Line 10357: p_init_msg_list => OKC_API.G_FALSE,

10353: debug_message('l_rate_counter=' || l_rate_counter);
10354: IF (l_rate_counter > 1) THEN
10355: OKL_K_RATE_PARAMS_PVT.validate_k_rate_params(
10356: p_api_version => 1 ,
10357: p_init_msg_list => OKC_API.G_FALSE,
10358: x_return_status => x_return_status,
10359: x_msg_count => x_msg_count,
10360: x_msg_data => x_msg_data,
10361: p_product_id => G_PRODUCT_ID,

Line 10370: p_init_msg_list => OKC_API.G_FALSE,

10366: FOR krpv_rec_cnt IN l_k_rate_tbl.FIRST..l_k_rate_tbl.LAST
10367: LOOP
10368: OKL_K_RATE_PARAMS_PVT.create_k_rate_params(
10369: p_api_version => 1 ,
10370: p_init_msg_list => OKC_API.G_FALSE,
10371: x_return_status => x_return_status,
10372: x_msg_count => x_msg_count,
10373: x_msg_data => x_msg_data,
10374: p_krpv_rec => l_k_rate_tbl(krpv_rec_cnt),

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

10471: x_return_status := OKL_API.G_RET_STS_ERROR;
10472: raise header_rule_failed;
10473: END IF;
10474:
10475: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
10476: l_rgp_id := x_rgpv_rec.id;
10477: END IF;
10478:
10479: debug_message('------>Rule: LAFCTG/LAFCTG processed');

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

10538: x_return_status := OKL_API.G_RET_STS_ERROR;
10539: raise header_rule_failed;
10540: END IF;
10541:
10542: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
10543: l_rgp_id := x_rgpv_rec.id;
10544: END IF;
10545:
10546: debug_message('------>Rule: LAEVEL/LAEVEL processed');

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

10609: x_return_status := OKL_API.G_RET_STS_ERROR;
10610: raise header_rule_failed;
10611: END IF;
10612:
10613: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
10614: l_rgp_id := x_rgpv_rec.id;
10615: END IF;
10616: debug_message('------>Rule: LAEVEL/LAEVPT processed');
10617: l_rulv_rec := NULL;

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: LABILL/BTO processed');

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

10808: x_return_status := OKL_API.G_RET_STS_ERROR;
10809: raise header_rule_failed;
10810: END IF;
10811:
10812: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
10813: l_rgp_id := x_rgpv_rec.id;
10814: END IF;
10815:
10816: END IF; --bank_account_id

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

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

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

11023: x_return_status := OKL_API.G_RET_STS_ERROR;
11024: raise header_rule_failed;
11025: END IF;
11026:
11027: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- Bug 5085099
11028: l_rgp_id := x_rgpv_rec.id;
11029: END IF;
11030:
11031: debug_message('------>Rule: LABILL/LAINVD processed');

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

11102: x_return_status := OKL_API.G_RET_STS_ERROR;
11103: raise header_rule_failed;
11104: END IF;
11105:
11106: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
11107: l_rgp_id := x_rgpv_rec.id;
11108: END IF;
11109:
11110: debug_message('------>Rule: LABILL/LAPMTH processed');

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

11167: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
11168: raise header_rule_failed;
11169: END IF;
11170:
11171: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
11172: l_rgp_id := x_rgpv_rec.id;
11173: END IF;
11174:
11175: END IF; -- capitalize

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

11234: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
11235: raise header_rule_failed;
11236: END IF;
11237:
11238: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
11239: l_rgp_id := x_rgpv_rec.id;
11240: END IF;
11241:
11242: END IF; -- non_notification

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

11406: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
11407: raise header_rule_failed;
11408: END IF;
11409:
11410: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
11411: l_rgp_id := x_rgpv_rec.id;
11412: END IF;
11413: END IF; -- if rvi_auto_calculate_flag = 'Y'
11414: -- Bug 4655611

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

11505: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
11506: raise header_rule_failed;
11507: END IF;
11508:
11509: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
11510: l_rgp_id := x_rgpv_rec.id;
11511: END IF;
11512:
11513: debug_message('------>Rule: LARVIN/LARVAM processed');

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

11570: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
11571: raise header_rule_failed;
11572: END IF;
11573:
11574: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
11575: l_rgp_id := x_rgpv_rec.id;
11576: END IF;
11577:
11578: END IF; -- tax_withholding_flag

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

11629: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
11630: raise header_rule_failed;
11631: END IF;
11632:
11633: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
11634: l_rgp_id := x_rgpv_rec.id;
11635: END IF;
11636:
11637: END IF; -- tax_calc_formula_name

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

11701: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
11702: raise header_rule_failed;
11703: END IF;
11704:
11705: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
11706: l_rgp_id := x_rgpv_rec.id;
11707: END IF;
11708:
11709: END IF; -- tax_owner

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

11851: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
11852: raise header_rule_failed;
11853: END IF;
11854:
11855: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
11856: l_rgp_id := x_rgpv_rec.id;
11857: END IF;
11858:
11859: debug_message('------>Rule: AMLARL/AMCFPR processed');

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

11932: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
11933: raise header_rule_failed;
11934: END IF;
11935:
11936: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
11937: l_rgp_id := x_rgpv_rec.id;
11938: END IF;
11939: debug_message('------>Rule: AMREPQ/AMARQC processed');
11940: l_rulv_rec := NULL;

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

12027: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
12028: raise header_rule_failed;
12029: END IF;
12030:
12031: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
12032: l_rgp_id := x_rgpv_rec.id;
12033: END IF;
12034:
12035: debug_message('------>Rule: AMREPQ/AMBSPR processed');

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

12123: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
12124: raise header_rule_failed;
12125: END IF;
12126:
12127: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
12128: l_rgp_id := x_rgpv_rec.id;
12129: END IF;
12130: debug_message('------>Rule: AMREPQ/AMCQDR processed');
12131: l_rulv_rec := NULL;

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

12218: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
12219: raise header_rule_failed;
12220: END IF;
12221:
12222: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
12223: l_rgp_id := x_rgpv_rec.id;
12224: END IF;
12225:
12226: debug_message('------>Rule: AMREPQ/AMCQFE processed');

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

12415: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
12416: raise header_rule_failed;
12417: END IF;
12418:
12419: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
12420: l_rgp_id := x_rgpv_rec.id;
12421: END IF;
12422:
12423: debug_message('------>Rule: AMTEOC/AMBPOC processed');

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

12612: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
12613: raise header_rule_failed;
12614: END IF;
12615:
12616: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
12617: l_rgp_id := x_rgpv_rec.id;
12618: END IF;
12619:
12620: debug_message('------>Rule: AMTFOC/AMBPOC processed');

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

12670: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
12671: raise header_rule_failed;
12672: END IF;
12673:
12674: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
12675: l_rgp_id := x_rgpv_rec.id;
12676: END IF;
12677:
12678: debug_message('------>Rule: AMTFOC/AMTINV processed');

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

12757: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
12758: raise header_rule_failed;
12759: END IF;
12760:
12761: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
12762: l_rgp_id := x_rgpv_rec.id;
12763: END IF;
12764: debug_message('------>Rule: AMTQPR/AMCTTA processed');
12765: l_rulv_rec := NULL;

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

12813: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
12814: raise header_rule_failed;
12815: END IF;
12816:
12817: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
12818: l_rgp_id := x_rgpv_rec.id;
12819: END IF;
12820:
12821: debug_message('------>Rule: AMTQPR/AMPTQA processed');

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

12883: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
12884: raise header_rule_failed;
12885: END IF;
12886:
12887: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
12888: l_rgp_id := x_rgpv_rec.id;
12889: END IF;
12890: debug_message('------>Rule: AMTQPR/AMQTEF processed');
12891: l_rulv_rec := NULL;

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

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

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

12999: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
13000: raise header_rule_failed;
13001: END IF;
13002:
13003: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
13004: l_rgp_id := x_rgpv_rec.id;
13005: END IF;
13006: debug_message('------>Rule: AMTQPR/AMFBOS processed');
13007:

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

13056: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
13057: raise header_rule_failed;
13058: END IF;
13059:
13060: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
13061: l_rgp_id := x_rgpv_rec.id;
13062: END IF;
13063: debug_message('------>Rule: AMTQPR/AMCMTQ processed');
13064:

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

13113: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
13114: raise header_rule_failed;
13115: END IF;
13116:
13117: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
13118: l_rgp_id := x_rgpv_rec.id;
13119: END IF;
13120: debug_message('------>Rule: AMTQPR/AMDFTD processed');
13121:

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

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

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

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

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

13306: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
13307: raise header_rule_failed;
13308: END IF;
13309:
13310: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
13311: l_rgp_id := x_rgpv_rec.id;
13312: END IF;
13313: debug_message('------>Rule: AMTGAL/AMAPRE processed');
13314: l_rulv_rec := NULL;

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

13454: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
13455: raise header_rule_failed;
13456: END IF;
13457:
13458: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
13459: l_rgp_id := x_rgpv_rec.id;
13460: END IF;
13461: debug_message('------>Rule: AMTGAL/AMGALO processed');
13462:

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

13520: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
13521: raise header_rule_failed;
13522: END IF;
13523:
13524: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
13525: l_rgp_id := x_rgpv_rec.id;
13526: END IF;
13527:
13528: debug_message('------>Rule: AMQR1R/AMLCRO processed');

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

13592: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
13593: raise header_rule_failed;
13594: END IF;
13595:
13596: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
13597: l_rgp_id := x_rgpv_rec.id;
13598: END IF;
13599:
13600: debug_message('------>Rule: AMQR1R/AMLCRP processed');

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

13659: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
13660: raise header_rule_failed;
13661: END IF;
13662:
13663: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
13664: l_rgp_id := x_rgpv_rec.id;
13665: END IF;
13666:
13667: debug_message('------>Rule: AMQR5A/AMLCAP processed');

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

13729: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
13730: raise header_rule_failed;
13731: END IF;
13732:
13733: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
13734: l_rgp_id := x_rgpv_rec.id;
13735: END IF;
13736:
13737: debug_message('------>Rule: AMQR5A/AMLCAV processed');

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

13796: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
13797: raise header_rule_failed;
13798: END IF;
13799:
13800: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
13801: l_rgp_id := x_rgpv_rec.id;
13802: END IF;
13803:
13804: debug_message('------>Rule: AMQR9F/AMLCCO processed');

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

13876: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
13877: raise header_rule_failed;
13878: END IF;
13879:
13880: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
13881: l_rgp_id := x_rgpv_rec.id;
13882: END IF;
13883: debug_message('------>Rule: AMTEWC/AMATQC processed');
13884: l_rulv_rec := NULL;

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

13971: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
13972: raise header_rule_failed;
13973: END IF;
13974:
13975: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
13976: l_rgp_id := x_rgpv_rec.id;
13977: END IF;
13978: debug_message('------>Rule: AMTEWC/AMBCOC processed');
13979: l_rulv_rec := NULL;

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

14066: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
14067: raise header_rule_failed;
14068: END IF;
14069:
14070: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
14071: l_rgp_id := x_rgpv_rec.id;
14072: END IF;
14073: debug_message('------>Rule: AMTEWC/AMCQDR processed');
14074: l_rulv_rec := NULL;

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

14161: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
14162: raise header_rule_failed;
14163: END IF;
14164:
14165: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
14166: l_rgp_id := x_rgpv_rec.id;
14167: END IF;
14168: debug_message('------>Rule: AMTEWC/AMCQFE processed');
14169: l_rulv_rec := NULL;

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

14256: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
14257: raise header_rule_failed;
14258: END IF;
14259:
14260: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
14261: l_rgp_id := x_rgpv_rec.id;
14262: END IF;
14263: debug_message('------>Rule: AMTEWC/AMCRFE processed');
14264: l_rulv_rec := NULL;

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

14351: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
14352: raise header_rule_failed;
14353: END IF;
14354:
14355: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
14356: l_rgp_id := x_rgpv_rec.id;
14357: END IF;
14358: debug_message('------>Rule: AMTEWC/AMCRIN processed');
14359: l_rulv_rec := NULL;

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

14446: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
14447: raise header_rule_failed;
14448: END IF;
14449:
14450: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
14451: l_rgp_id := x_rgpv_rec.id;
14452: END IF;
14453: debug_message('------>Rule: AMTEWC/AMCSDD processed');
14454: l_rulv_rec := NULL;

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

14580: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
14581: raise header_rule_failed;
14582: END IF;
14583:
14584: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
14585: l_rgp_id := x_rgpv_rec.id;
14586: END IF;
14587: debug_message('------>Rule: AMTEWC/AMCTPE processed');
14588: l_rulv_rec := NULL;

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

14675: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
14676: raise header_rule_failed;
14677: END IF;
14678:
14679: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
14680: l_rgp_id := x_rgpv_rec.id;
14681: END IF;
14682: debug_message('------>Rule: AMTEWC/AMPRTX processed');
14683: l_rulv_rec := NULL;

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

14731: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
14732: raise header_rule_failed;
14733: END IF;
14734:
14735: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
14736: l_rgp_id := x_rgpv_rec.id;
14737: END IF;
14738: debug_message('------>Rule: AMTEWC/AMYFEE processed');
14739: l_rulv_rec := NULL;

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

14787: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
14788: raise header_rule_failed;
14789: END IF;
14790:
14791: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
14792: l_rgp_id := x_rgpv_rec.id;
14793: END IF;
14794: debug_message('------>Rule: AMTEWC/AMYOUB processed');
14795: l_rulv_rec := NULL;

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

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

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

14916: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
14917: raise header_rule_failed;
14918: END IF;
14919:
14920: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
14921: l_rgp_id := x_rgpv_rec.id;
14922: END IF;
14923:
14924: debug_message('------>Rule: AMTEWC/AMAFEE processed');

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

14974: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
14975: raise header_rule_failed;
14976: END IF;
14977:
14978: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
14979: l_rgp_id := x_rgpv_rec.id;
14980: END IF;
14981:
14982: debug_message('------>Rule: AMTEWC/AMEFEE processed');

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

15032: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
15033: raise header_rule_failed;
15034: END IF;
15035:
15036: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
15037: l_rgp_id := x_rgpv_rec.id;
15038: END IF;
15039:
15040: debug_message('------>Rule: AMTEWC/AMFFEE processed');

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

15090: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
15091: raise header_rule_failed;
15092: END IF;
15093:
15094: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
15095: l_rgp_id := x_rgpv_rec.id;
15096: END IF;
15097:
15098: debug_message('------>Rule: AMTEWC/AMGFEE processed');

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

15148: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
15149: raise header_rule_failed;
15150: END IF;
15151:
15152: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
15153: l_rgp_id := x_rgpv_rec.id;
15154: END IF;
15155:
15156: debug_message('------>Rule: AMTEWC/AMIFEE processed');

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

15206: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
15207: raise header_rule_failed;
15208: END IF;
15209:
15210: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
15211: l_rgp_id := x_rgpv_rec.id;
15212: END IF;
15213:
15214: debug_message('------>Rule: AMTEWC/AMMFEE processed');

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

15264: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
15265: raise header_rule_failed;
15266: END IF;
15267:
15268: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
15269: l_rgp_id := x_rgpv_rec.id;
15270: END IF;
15271:
15272: debug_message('------>Rule: AMTEWC/AMPFEE processed');

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

15322: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
15323: raise header_rule_failed;
15324: END IF;
15325:
15326: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
15327: l_rgp_id := x_rgpv_rec.id;
15328: END IF;
15329:
15330: debug_message('------>Rule: AMTEWC/AMRFEE processed');

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

15404: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
15405: raise header_rule_failed;
15406: END IF;
15407:
15408: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
15409: l_rgp_id := x_rgpv_rec.id;
15410: END IF;
15411: debug_message('------>Rule: AMTFWC/AMATQC processed');
15412: l_rulv_rec := NULL;

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

15499: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
15500: raise header_rule_failed;
15501: END IF;
15502:
15503: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
15504: l_rgp_id := x_rgpv_rec.id;
15505: END IF;
15506: debug_message('------>Rule: AMTFWC/AMBCOC processed');
15507: l_rulv_rec := NULL;

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

15594: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
15595: raise header_rule_failed;
15596: END IF;
15597:
15598: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
15599: l_rgp_id := x_rgpv_rec.id;
15600: END IF;
15601: debug_message('------>Rule: AMTFWC/AMCQDR processed');
15602: l_rulv_rec := NULL;

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

15689: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
15690: raise header_rule_failed;
15691: END IF;
15692:
15693: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
15694: l_rgp_id := x_rgpv_rec.id;
15695: END IF;
15696: debug_message('------>Rule: AMTFWC/AMCQFE processed');
15697: l_rulv_rec := NULL;

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

15784: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
15785: raise header_rule_failed;
15786: END IF;
15787:
15788: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
15789: l_rgp_id := x_rgpv_rec.id;
15790: END IF;
15791: debug_message('------>Rule: AMTFWC/AMCRFE processed');
15792: l_rulv_rec := NULL;

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

15879: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
15880: raise header_rule_failed;
15881: END IF;
15882:
15883: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
15884: l_rgp_id := x_rgpv_rec.id;
15885: END IF;
15886: debug_message('------>Rule: AMTFWC/AMCRIN processed');
15887: l_rulv_rec := NULL;

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

15974: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
15975: raise header_rule_failed;
15976: END IF;
15977:
15978: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
15979: l_rgp_id := x_rgpv_rec.id;
15980: END IF;
15981: debug_message('------>Rule: AMTFWC/AMCSDD processed');
15982: l_rulv_rec := NULL;

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

16108: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
16109: raise header_rule_failed;
16110: END IF;
16111:
16112: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
16113: l_rgp_id := x_rgpv_rec.id;
16114: END IF;
16115: debug_message('------>Rule: AMTFWC/AMCTPE processed');
16116: l_rulv_rec := NULL;

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

16203: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
16204: raise header_rule_failed;
16205: END IF;
16206:
16207: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
16208: l_rgp_id := x_rgpv_rec.id;
16209: END IF;
16210: debug_message('------>Rule: AMTFWC/AMPRTX processed');
16211: l_rulv_rec := NULL;

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

16259: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
16260: raise header_rule_failed;
16261: END IF;
16262:
16263: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
16264: l_rgp_id := x_rgpv_rec.id;
16265: END IF;
16266: debug_message('------>Rule: AMTFWC/AMYFEE processed');
16267: l_rulv_rec := NULL;

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

16315: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
16316: raise header_rule_failed;
16317: END IF;
16318:
16319: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
16320: l_rgp_id := x_rgpv_rec.id;
16321: END IF;
16322: debug_message('------>Rule: AMTFWC/AMYOUB processed');
16323: l_rulv_rec := NULL;

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

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

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

16444: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
16445: raise header_rule_failed;
16446: END IF;
16447:
16448: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
16449: l_rgp_id := x_rgpv_rec.id;
16450: END IF;
16451:
16452: debug_message('------>Rule: AMTFWC/AMAFEE processed');

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

16502: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
16503: raise header_rule_failed;
16504: END IF;
16505:
16506: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
16507: l_rgp_id := x_rgpv_rec.id;
16508: END IF;
16509:
16510: debug_message('------>Rule: AMTFWC/AMEFEE processed');

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

16560: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
16561: raise header_rule_failed;
16562: END IF;
16563:
16564: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
16565: l_rgp_id := x_rgpv_rec.id;
16566: END IF;
16567:
16568: debug_message('------>Rule: AMTFWC/AMFFEE processed');

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

16618: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
16619: raise header_rule_failed;
16620: END IF;
16621:
16622: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
16623: l_rgp_id := x_rgpv_rec.id;
16624: END IF;
16625:
16626: debug_message('------>Rule: AMTFWC/AMGFEE processed');

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

16676: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
16677: raise header_rule_failed;
16678: END IF;
16679:
16680: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
16681: l_rgp_id := x_rgpv_rec.id;
16682: END IF;
16683:
16684: debug_message('------>Rule: AMTFWC/AMIFEE processed');

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

16734: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
16735: raise header_rule_failed;
16736: END IF;
16737:
16738: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
16739: l_rgp_id := x_rgpv_rec.id;
16740: END IF;
16741:
16742: debug_message('------>Rule: AMTFWC/AMMFEE processed');

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

16792: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
16793: raise header_rule_failed;
16794: END IF;
16795:
16796: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
16797: l_rgp_id := x_rgpv_rec.id;
16798: END IF;
16799:
16800: debug_message('------>Rule: AMTFWC/AMPFEE processed');

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

16850: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
16851: raise header_rule_failed;
16852: END IF;
16853:
16854: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
16855: l_rgp_id := x_rgpv_rec.id;
16856: END IF;
16857:
16858: debug_message('------>Rule: AMTFWC/AMRFEE processed');

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

17067: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
17068: raise header_rule_failed;
17069: END IF;
17070:
17071: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
17072: l_rgp_id := x_rgpv_rec.id;
17073: END IF;
17074: debug_message('------>Rule: LAAFLG/LAFLLN processed');
17075: l_rulv_rec := NULL;

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

17288: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
17289: raise header_rule_failed;
17290: END IF;
17291:
17292: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
17293: l_rgp_id := x_rgpv_rec.id;
17294: END IF;
17295: debug_message('------>Rule: LAAFLG/LAFLTL processed');
17296:

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

17361: END IF;
17362:
17363: debug_message('------>Rule: AMCOPO/AMAPRE processed');
17364:
17365: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
17366: l_rgp_id := x_rgpv_rec.id;
17367: END IF;
17368: l_rulv_rec := NULL;
17369:

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

17416: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
17417: raise header_rule_failed;
17418: END IF;
17419:
17420: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
17421: l_rgp_id := x_rgpv_rec.id;
17422: END IF;
17423: debug_message('------>Rule: AMCOPO/AMPRAG processed');
17424: l_rulv_rec := NULL;

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

17503: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
17504: raise header_rule_failed;
17505: END IF;
17506:
17507: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
17508: l_rgp_id := x_rgpv_rec.id;
17509: END IF;
17510: debug_message('------>Rule: AMCOPO/AMPRBA processed');
17511: l_rulv_rec := NULL;

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

17559: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
17560: raise header_rule_failed;
17561: END IF;
17562:
17563: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
17564: l_rgp_id := x_rgpv_rec.id;
17565: END IF;
17566: l_rulv_rec := NULL;
17567:

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

17614: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
17615: raise header_rule_failed;
17616: END IF;
17617:
17618: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
17619: l_rgp_id := x_rgpv_rec.id;
17620: END IF;
17621: debug_message('------>Rule: AMCOPO/AMPRST processed');
17622: l_rulv_rec := NULL;

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

17719: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
17720: raise header_rule_failed;
17721: END IF;
17722:
17723: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
17724: l_rgp_id := x_rgpv_rec.id;
17725: END IF;
17726: debug_message('------>Rule: LAHDTX/LAPRTX processed');
17727: l_rulv_rec := NULL;

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

17789: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
17790: raise header_rule_failed;
17791: END IF;
17792:
17793: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
17794: l_rgp_id := x_rgpv_rec.id;
17795: END IF;
17796: debug_message('------>Rule: LAHDTX/LAMETX processed');
17797: l_rulv_rec := NULL;

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

17845: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
17846: raise header_rule_failed;
17847: END IF;
17848:
17849: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
17850: l_rgp_id := x_rgpv_rec.id;
17851: END IF;
17852: debug_message('------>Rule: LAHDTX/LAAUTX processed');
17853: l_rulv_rec := NULL;

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

17980: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
17981: raise header_rule_failed;
17982: END IF;
17983:
17984: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
17985: l_rgp_id := x_rgpv_rec.id;
17986: END IF;
17987: debug_message('------>Rule: LAHDTX/LASTCL processed');
17988: l_rulv_rec := NULL;

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

18207: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
18208: raise header_rule_failed;
18209: END IF;
18210:
18211: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
18212: l_rgp_id := x_rgpv_rec.id;
18213: END IF;
18214: debug_message('------>Rule: LAHDTX/LASTPR processed');
18215: l_rulv_rec := NULL;

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

19618: END IF;
19619:
19620: debug_message('------>Rule: LAPSTH/LAPTR processed');
19621:
19622: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
19623: l_rgp_id := x_rgpv_rec.id;
19624: END IF;
19625:
19626: l_rulv_rec := NULL;

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

19652: raise party_role_failed;
19653: END IF;
19654:
19655: debug_message('------>Rule: LAPSTH/LAPTO processed');
19656: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
19657: l_rgp_id := x_rgpv_rec.id;
19658: END IF;
19659:
19660: l_rulv_rec := NULL;

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

19689: raise party_role_failed;
19690: END IF;
19691:
19692: debug_message('------>Rule: LAPSTH/LAVPMT processed');
19693: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
19694: l_rgp_id := x_rgpv_rec.id;
19695: END IF;
19696:
19697: l_rulv_rec := NULL;

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

19722: END IF;
19723:
19724: debug_message('------>Rule: LAPSTH/LAPTRP processed');
19725:
19726: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
19727: l_rgp_id := x_rgpv_rec.id;
19728: END IF;
19729:
19730: l_rulv_rec := NULL;

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

19753: raise party_role_failed;
19754: END IF;
19755:
19756: debug_message('------>Rule: LAPSTH/LAPTBC processed');
19757: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
19758: l_rgp_id := x_rgpv_rec.id;
19759: END IF;
19760: */
19761: END IF; -- service vendor

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

19889: raise party_role_failed;
19890: END IF;
19891:
19892: debug_message('------>Fee Rule: LAPSTH/LAPTR processed');
19893: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
19894: l_rgp_id := x_rgpv_rec.id;
19895: END IF;
19896: l_rulv_rec := NULL;
19897: --debug_message('Site: '||x_pay_site_id1);

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

19922: raise party_role_failed;
19923: END IF;
19924:
19925: debug_message('------>Fee Rule: LAPSTH/LAPTO processed');
19926: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
19927: l_rgp_id := x_rgpv_rec.id;
19928: END IF;
19929:
19930: l_rulv_rec := NULL;

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

19959: raise party_role_failed;
19960: END IF;
19961:
19962: debug_message('------>Fee Rule: LAPSTH/LAVPMT processed');
19963: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
19964: l_rgp_id := x_rgpv_rec.id;
19965: END IF;
19966:
19967: l_rulv_rec := NULL;

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

19991: raise party_role_failed;
19992: END IF;
19993:
19994: debug_message('------>Fee Rule: LAPSTH/LAPTPR processed');
19995: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
19996: l_rgp_id := x_rgpv_rec.id;
19997: END IF;
19998:
19999: l_rulv_rec := NULL;

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

20022: raise party_role_failed;
20023: END IF;
20024:
20025: debug_message('------>Fee Rule: LAPSTH/LAPTBC processed');
20026: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
20027: l_rgp_id := x_rgpv_rec.id;
20028: END IF;
20029: */
20030: END IF; -- Fees vendor

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

20170: raise party_role_failed;
20171: END IF;
20172:
20173: debug_message('------>Fee Rule: LAGRDT/LAGRNP processed');
20174: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
20175: l_rgp_id := x_rgpv_rec.id;
20176: END IF;
20177:
20178: IF (p_guarantor_type IS NOT NULL) THEN

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

20278: END IF;
20279:
20280: debug_message('------>Rule: LAGRDT/LAGRNT processed');
20281:
20282: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
20283: l_rgp_id := x_rgpv_rec.id;
20284: END IF;
20285:
20286: END IF; -- guarantor_id

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

20383: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
20384: raise party_role_failed;
20385: END IF;
20386:
20387: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
20388: l_rgp_id := x_rgpv_rec.id;
20389: END IF;
20390: l_rulv_rec := NULL;
20391:

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

20448: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
20449: raise party_role_failed;
20450: END IF;
20451:
20452: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
20453: l_rgp_id := x_rgpv_rec.id;
20454: END IF;
20455: l_rulv_rec := NULL;
20456: ELSE

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

20512: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
20513: raise party_role_failed;
20514: END IF;
20515:
20516: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
20517: l_rgp_id := x_rgpv_rec.id;
20518: END IF;
20519: l_rulv_rec := NULL;
20520: ELSE

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

20579: x_return_status := OKL_API.G_RET_STS_ERROR;
20580: raise party_role_failed;
20581: END IF;
20582:
20583: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
20584: l_rgp_id := x_rgpv_rec.id;
20585: END IF;
20586:
20587: l_rulv_rec := NULL;

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

20636: x_return_status := OKL_API.G_RET_STS_ERROR;
20637: raise party_role_failed;
20638: END IF;
20639:
20640: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
20641: l_rgp_id := x_rgpv_rec.id;
20642: END IF;
20643: l_rulv_rec := NULL;
20644:

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

20699: x_return_status := OKL_API.G_RET_STS_ERROR;
20700: raise party_role_failed;
20701: END IF;
20702:
20703: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
20704: l_rgp_id := x_rgpv_rec.id;
20705: END IF;
20706: l_rulv_rec := NULL;
20707:

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

20738: x_return_status := OKL_API.G_RET_STS_ERROR;
20739: raise party_role_failed;
20740: END IF;
20741:
20742: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
20743: l_rgp_id := x_rgpv_rec.id;
20744: END IF;
20745: l_rulv_rec := NULL;
20746:

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

21843: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
21844: raise term_failed;
21845: END IF;
21846:
21847: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
21848: l_rgp_id := x_rgpv_rec.id;
21849: END IF;
21850: */
21851: IF (p_bank_account_id IS NOT NULL

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

21895: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
21896: raise term_failed;
21897: END IF;
21898:
21899: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
21900: l_rgp_id := x_rgpv_rec.id;
21901: END IF;
21902:
21903: END IF; --bank_account

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

21975: END IF;
21976: */
21977: /* Bug# 4284166 : not required
21978:
21979: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
21980: l_rgp_id := x_rgpv_rec.id;
21981: END IF;
21982: */
21983:

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

22128: END IF;
22129: */
22130: /* Bug# 4284166 : not required
22131:
22132: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
22133: l_rgp_id := x_rgpv_rec.id;
22134: END IF;
22135: */
22136: --

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

22194: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
22195: raise term_failed;
22196: END IF;
22197:
22198: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136
22199: l_rgp_id := x_rgpv_rec.id;
22200: END IF;
22201:
22202: END IF; -- payment method id

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

22336: CLOSE get_rule_group_info;
22337: END IF;
22338: --Bug# 6112766: End
22339: -- IF (p_rg_id IS NULL) THEN
22340: IF (l_rgp_id IS NULL OR l_rgp_id = OKC_API.G_MISS_NUM) THEN -- cklee bug #7429136 --Bug# 6112766
22341: IF (p_line_number IS NOT NULL) THEN -- line level rule group
22342: l_rgpv_rec := NULL;
22343: l_rgpv_rec.rgd_code := 'LALEVL';
22344: l_rgpv_rec.chr_id := NULL;

Line 24985: p_draft_yn => Okc_Api.G_TRUE,

24981: p_init_msg_list => p_init_msg_list,
24982: p_commit => Okl_Api.G_FALSE,
24983: p_contract_id => p_chr_id,
24984: p_transaction_type => 'Booking',
24985: p_draft_yn => Okc_Api.G_TRUE,
24986: x_return_status => x_return_status,
24987: x_msg_count => x_msg_count,
24988: x_msg_data => x_msg_data
24989: );

Line 25013: p_draft_yn => Okc_Api.G_TRUE,

25009: p_init_msg_list => p_init_msg_list,
25010: p_commit => Okl_Api.G_FALSE,
25011: p_contract_id => p_chr_id,
25012: p_transaction_type => 'Booking',
25013: p_draft_yn => Okc_Api.G_TRUE,
25014: x_return_status => x_return_status,
25015: x_msg_count => x_msg_count,
25016: x_msg_data => x_msg_data
25017: );

Line 25060: p_draft_yn => Okc_Api.G_TRUE,

25056: p_init_msg_list => p_init_msg_list,
25057: p_commit => Okl_Api.G_FALSE,
25058: p_contract_id => p_chr_id,
25059: p_transaction_type => 'Booking',
25060: p_draft_yn => Okc_Api.G_TRUE,
25061: x_return_status => x_return_status,
25062: x_msg_count => x_msg_count,
25063: x_msg_data => x_msg_data
25064: );

Line 26698: p_init_msg_list => OKC_API.G_FALSE,

26694: l_cimv_tbl(1) := l_cimv_rec;
26695:
26696: okl_create_kle_pub.create_add_on_line(
26697: p_api_version => 1,
26698: p_init_msg_list => OKC_API.G_FALSE,
26699: x_return_status => x_return_status,
26700: x_msg_count => x_msg_count,
26701: x_msg_data => x_msg_data,
26702: p_new_yn => 'Y',

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

28506:
28507: CLOSE le_entity;
28508: IF (l_exists <>1 ) THEN
28509: debug_message('--->Legal entity is not valid for operating unit');
28510: Okc_Api.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'LEGAL_ENTITY_ID');
28511: RAISE item_not_found_error;
28512: END IF;
28513: END IF;
28514: l_khrv_rec.legal_entity_id := okl_header_rec.legal_entity_id ;

Line 31477: x_return_status := Okc_Api.G_RET_STS_ERROR;

31473: return;
31474:
31475: EXCEPTION
31476: WHEN item_not_found_error THEN
31477: x_return_status := Okc_Api.G_RET_STS_ERROR;
31478:
31479: WHEN OTHERS THEN
31480: okl_api.set_message(
31481: G_APP_NAME,

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

31543:
31544:
31545: IF x_request_id = 0 THEN
31546: -- Raise Error if the request has not been submitted successfully.
31547: Okc_Api.set_message(p_app_name => 'OFA',
31548: p_msg_name => 'FA_DEPRN_TAX_ERROR',
31549: p_token1 => 'REQUEST_ID',
31550: p_token1_value => x_request_id);
31551: