5414:
5415: fnd_profile.get('OKC_EURO_DEFAULT_PRICELIST', g_pricelist);
5416:
5417: if (g_pricelist is NULL) then
5418: fnd_message.set_name('OKC','OKC_PROFILE_CHECK');
5419: fnd_message.set_token('PROFILE','OKC_EURO_DEFAULT_PRICELIST');
5420: FND_MSG_PUB.add;
5421: x_return_status := OKC_API.G_RET_STS_ERROR;
5422: RAISE G_EXCEPTION_HALT_VALIDATION;
5415: fnd_profile.get('OKC_EURO_DEFAULT_PRICELIST', g_pricelist);
5416:
5417: if (g_pricelist is NULL) then
5418: fnd_message.set_name('OKC','OKC_PROFILE_CHECK');
5419: fnd_message.set_token('PROFILE','OKC_EURO_DEFAULT_PRICELIST');
5420: FND_MSG_PUB.add;
5421: x_return_status := OKC_API.G_RET_STS_ERROR;
5422: RAISE G_EXCEPTION_HALT_VALIDATION;
5423: end if;
11574:
11575: IF l_no_of_cancel_lines <> 0 OR l_no_of_termn_lines <> 0 THEN
11576: IF (l_no_of_cancel_lines <> 0 AND l_no_of_termn_lines <> 0) AND (L_INCLUDE_CANCELLED_LINES = 'N' AND L_INCLUDE_TERMINATED_LINES = 'N') THEN
11577:
11578: fnd_message.set_name('OKC', 'OKC_NO_CANC_TERMN_LINE');
11579: FND_FILE.PUT_LINE (FND_FILE.LOG, fnd_message.get);
11580:
11581: ELSIF l_no_of_cancel_lines <> 0 AND L_INCLUDE_CANCELLED_LINES = 'N' THEN
11582: fnd_message.set_name('OKC', 'OKC_NO_CANCEL_LINE');
11575: IF l_no_of_cancel_lines <> 0 OR l_no_of_termn_lines <> 0 THEN
11576: IF (l_no_of_cancel_lines <> 0 AND l_no_of_termn_lines <> 0) AND (L_INCLUDE_CANCELLED_LINES = 'N' AND L_INCLUDE_TERMINATED_LINES = 'N') THEN
11577:
11578: fnd_message.set_name('OKC', 'OKC_NO_CANC_TERMN_LINE');
11579: FND_FILE.PUT_LINE (FND_FILE.LOG, fnd_message.get);
11580:
11581: ELSIF l_no_of_cancel_lines <> 0 AND L_INCLUDE_CANCELLED_LINES = 'N' THEN
11582: fnd_message.set_name('OKC', 'OKC_NO_CANCEL_LINE');
11583: FND_FILE.PUT_LINE (FND_FILE.LOG, fnd_message.get);
11578: fnd_message.set_name('OKC', 'OKC_NO_CANC_TERMN_LINE');
11579: FND_FILE.PUT_LINE (FND_FILE.LOG, fnd_message.get);
11580:
11581: ELSIF l_no_of_cancel_lines <> 0 AND L_INCLUDE_CANCELLED_LINES = 'N' THEN
11582: fnd_message.set_name('OKC', 'OKC_NO_CANCEL_LINE');
11583: FND_FILE.PUT_LINE (FND_FILE.LOG, fnd_message.get);
11584: ELSIF l_no_of_termn_lines <> 0 AND L_INCLUDE_TERMINATED_LINES = 'N' THEN
11585: fnd_message.set_name('OKC', 'OKC_NO_TERMN_LINE');
11586: FND_FILE.PUT_LINE (FND_FILE.LOG, fnd_message.get);
11579: FND_FILE.PUT_LINE (FND_FILE.LOG, fnd_message.get);
11580:
11581: ELSIF l_no_of_cancel_lines <> 0 AND L_INCLUDE_CANCELLED_LINES = 'N' THEN
11582: fnd_message.set_name('OKC', 'OKC_NO_CANCEL_LINE');
11583: FND_FILE.PUT_LINE (FND_FILE.LOG, fnd_message.get);
11584: ELSIF l_no_of_termn_lines <> 0 AND L_INCLUDE_TERMINATED_LINES = 'N' THEN
11585: fnd_message.set_name('OKC', 'OKC_NO_TERMN_LINE');
11586: FND_FILE.PUT_LINE (FND_FILE.LOG, fnd_message.get);
11587: END IF;
11581: ELSIF l_no_of_cancel_lines <> 0 AND L_INCLUDE_CANCELLED_LINES = 'N' THEN
11582: fnd_message.set_name('OKC', 'OKC_NO_CANCEL_LINE');
11583: FND_FILE.PUT_LINE (FND_FILE.LOG, fnd_message.get);
11584: ELSIF l_no_of_termn_lines <> 0 AND L_INCLUDE_TERMINATED_LINES = 'N' THEN
11585: fnd_message.set_name('OKC', 'OKC_NO_TERMN_LINE');
11586: FND_FILE.PUT_LINE (FND_FILE.LOG, fnd_message.get);
11587: END IF;
11588: END IF;
11589: END IF;
11582: fnd_message.set_name('OKC', 'OKC_NO_CANCEL_LINE');
11583: FND_FILE.PUT_LINE (FND_FILE.LOG, fnd_message.get);
11584: ELSIF l_no_of_termn_lines <> 0 AND L_INCLUDE_TERMINATED_LINES = 'N' THEN
11585: fnd_message.set_name('OKC', 'OKC_NO_TERMN_LINE');
11586: FND_FILE.PUT_LINE (FND_FILE.LOG, fnd_message.get);
11587: END IF;
11588: END IF;
11589: END IF;
11590:
11587: END IF;
11588: END IF;
11589: END IF;
11590:
11591: fnd_message.set_name('OKC', 'OKC_COPY_CONTRACT');
11592: fnd_message.set_token(token =>'KNUM', value => l_token);
11593: FND_FILE.PUT_LINE (FND_FILE.LOG, fnd_message.get);
11594:
11595: RETCODE := 0;
11588: END IF;
11589: END IF;
11590:
11591: fnd_message.set_name('OKC', 'OKC_COPY_CONTRACT');
11592: fnd_message.set_token(token =>'KNUM', value => l_token);
11593: FND_FILE.PUT_LINE (FND_FILE.LOG, fnd_message.get);
11594:
11595: RETCODE := 0;
11596: END IF;
11589: END IF;
11590:
11591: fnd_message.set_name('OKC', 'OKC_COPY_CONTRACT');
11592: fnd_message.set_token(token =>'KNUM', value => l_token);
11593: FND_FILE.PUT_LINE (FND_FILE.LOG, fnd_message.get);
11594:
11595: RETCODE := 0;
11596: END IF;
11597:
11678: CLOSE L_LINES_CSR;
11679:
11680: IF l_no_of_cancel_lines <> 0 OR l_no_of_termn_lines <> 0 THEN
11681: IF (l_no_of_cancel_lines <> 0 AND l_no_of_termn_lines <> 0) AND (L_INCLUDE_CANCELLED_LINES = 'N' AND L_INCLUDE_TERMINATED_LINES = 'N') THEN
11682: fnd_message.set_name('OKC', 'OKC_NO_CANC_TERMN_LINE');
11683: FND_FILE.PUT_LINE (FND_FILE.LOG, fnd_message.get);
11684:
11685: ELSIF l_no_of_cancel_lines <> 0 AND L_INCLUDE_CANCELLED_LINES = 'N' THEN
11686: fnd_message.set_name('OKC', 'OKC_NO_CANCEL_LINE');
11679:
11680: IF l_no_of_cancel_lines <> 0 OR l_no_of_termn_lines <> 0 THEN
11681: IF (l_no_of_cancel_lines <> 0 AND l_no_of_termn_lines <> 0) AND (L_INCLUDE_CANCELLED_LINES = 'N' AND L_INCLUDE_TERMINATED_LINES = 'N') THEN
11682: fnd_message.set_name('OKC', 'OKC_NO_CANC_TERMN_LINE');
11683: FND_FILE.PUT_LINE (FND_FILE.LOG, fnd_message.get);
11684:
11685: ELSIF l_no_of_cancel_lines <> 0 AND L_INCLUDE_CANCELLED_LINES = 'N' THEN
11686: fnd_message.set_name('OKC', 'OKC_NO_CANCEL_LINE');
11687: FND_FILE.PUT_LINE (FND_FILE.LOG, fnd_message.get);
11682: fnd_message.set_name('OKC', 'OKC_NO_CANC_TERMN_LINE');
11683: FND_FILE.PUT_LINE (FND_FILE.LOG, fnd_message.get);
11684:
11685: ELSIF l_no_of_cancel_lines <> 0 AND L_INCLUDE_CANCELLED_LINES = 'N' THEN
11686: fnd_message.set_name('OKC', 'OKC_NO_CANCEL_LINE');
11687: FND_FILE.PUT_LINE (FND_FILE.LOG, fnd_message.get);
11688: ELSIF l_no_of_termn_lines <> 0 AND L_INCLUDE_TERMINATED_LINES = 'N' THEN
11689: fnd_message.set_name('OKC', 'OKC_NO_TERMN_LINE');
11690: FND_FILE.PUT_LINE (FND_FILE.LOG, fnd_message.get);
11683: FND_FILE.PUT_LINE (FND_FILE.LOG, fnd_message.get);
11684:
11685: ELSIF l_no_of_cancel_lines <> 0 AND L_INCLUDE_CANCELLED_LINES = 'N' THEN
11686: fnd_message.set_name('OKC', 'OKC_NO_CANCEL_LINE');
11687: FND_FILE.PUT_LINE (FND_FILE.LOG, fnd_message.get);
11688: ELSIF l_no_of_termn_lines <> 0 AND L_INCLUDE_TERMINATED_LINES = 'N' THEN
11689: fnd_message.set_name('OKC', 'OKC_NO_TERMN_LINE');
11690: FND_FILE.PUT_LINE (FND_FILE.LOG, fnd_message.get);
11691: END IF;
11685: ELSIF l_no_of_cancel_lines <> 0 AND L_INCLUDE_CANCELLED_LINES = 'N' THEN
11686: fnd_message.set_name('OKC', 'OKC_NO_CANCEL_LINE');
11687: FND_FILE.PUT_LINE (FND_FILE.LOG, fnd_message.get);
11688: ELSIF l_no_of_termn_lines <> 0 AND L_INCLUDE_TERMINATED_LINES = 'N' THEN
11689: fnd_message.set_name('OKC', 'OKC_NO_TERMN_LINE');
11690: FND_FILE.PUT_LINE (FND_FILE.LOG, fnd_message.get);
11691: END IF;
11692: END IF;
11693: END IF;
11686: fnd_message.set_name('OKC', 'OKC_NO_CANCEL_LINE');
11687: FND_FILE.PUT_LINE (FND_FILE.LOG, fnd_message.get);
11688: ELSIF l_no_of_termn_lines <> 0 AND L_INCLUDE_TERMINATED_LINES = 'N' THEN
11689: fnd_message.set_name('OKC', 'OKC_NO_TERMN_LINE');
11690: FND_FILE.PUT_LINE (FND_FILE.LOG, fnd_message.get);
11691: END IF;
11692: END IF;
11693: END IF;
11694:
11691: END IF;
11692: END IF;
11693: END IF;
11694:
11695: fnd_message.set_name('OKC', 'OKC_COPY_CONTRACT');
11696: fnd_message.set_token(token =>'KNUM', value => l_token);
11697: FND_FILE.PUT_LINE (FND_FILE.LOG, fnd_message.get);
11698:
11699:
11692: END IF;
11693: END IF;
11694:
11695: fnd_message.set_name('OKC', 'OKC_COPY_CONTRACT');
11696: fnd_message.set_token(token =>'KNUM', value => l_token);
11697: FND_FILE.PUT_LINE (FND_FILE.LOG, fnd_message.get);
11698:
11699:
11700: RETCODE := 0;
11693: END IF;
11694:
11695: fnd_message.set_name('OKC', 'OKC_COPY_CONTRACT');
11696: fnd_message.set_token(token =>'KNUM', value => l_token);
11697: FND_FILE.PUT_LINE (FND_FILE.LOG, fnd_message.get);
11698:
11699:
11700: RETCODE := 0;
11701: END IF;