924: END IF;
925:
926: --Bug# 15992711 : set global parameter before accounting call : mixed contract
927: IF l_acc_call_rel_flag = 'Y' THEN
928: okl_execute_formula_pub.g_additional_parameters(1).name := 'NEW_RELEASE_ASSET';
929: IF l_acct_trans_type = 'Booking' THEN
930: okl_execute_formula_pub.g_additional_parameters(1).value := 'NEW';
931: --ndani - 14-Mar-2013, Start,Bug# 16511024 - Rebook accounting fix
932: ELSIF l_acct_trans_type = 'Rebook' THEN
926: --Bug# 15992711 : set global parameter before accounting call : mixed contract
927: IF l_acc_call_rel_flag = 'Y' THEN
928: okl_execute_formula_pub.g_additional_parameters(1).name := 'NEW_RELEASE_ASSET';
929: IF l_acct_trans_type = 'Booking' THEN
930: okl_execute_formula_pub.g_additional_parameters(1).value := 'NEW';
931: --ndani - 14-Mar-2013, Start,Bug# 16511024 - Rebook accounting fix
932: ELSIF l_acct_trans_type = 'Rebook' THEN
933: okl_execute_formula_pub.g_additional_parameters(1).value := 'NEW';
934: --ndani - 14-Mar-2013, End,Bug# 16511024 - Rebook accounting fix
929: IF l_acct_trans_type = 'Booking' THEN
930: okl_execute_formula_pub.g_additional_parameters(1).value := 'NEW';
931: --ndani - 14-Mar-2013, Start,Bug# 16511024 - Rebook accounting fix
932: ELSIF l_acct_trans_type = 'Rebook' THEN
933: okl_execute_formula_pub.g_additional_parameters(1).value := 'NEW';
934: --ndani - 14-Mar-2013, End,Bug# 16511024 - Rebook accounting fix
935: END IF;
936: END IF;
937: --Bug# 15992711 , End
962:
963: IF l_acc_call_rel_flag = 'Y' THEN
964:
965: --reset global parameter after Booking accounting call : mixed contract
966: okl_execute_formula_pub.g_additional_parameters(1).name := NULL;
967: okl_execute_formula_pub.g_additional_parameters(1).value := NULL;
968:
969: --set global parameter before Release accounting call : mixed contract
970: okl_execute_formula_pub.g_additional_parameters(1).name := 'NEW_RELEASE_ASSET';
963: IF l_acc_call_rel_flag = 'Y' THEN
964:
965: --reset global parameter after Booking accounting call : mixed contract
966: okl_execute_formula_pub.g_additional_parameters(1).name := NULL;
967: okl_execute_formula_pub.g_additional_parameters(1).value := NULL;
968:
969: --set global parameter before Release accounting call : mixed contract
970: okl_execute_formula_pub.g_additional_parameters(1).name := 'NEW_RELEASE_ASSET';
971: okl_execute_formula_pub.g_additional_parameters(1).value := 'RELEASE';
966: okl_execute_formula_pub.g_additional_parameters(1).name := NULL;
967: okl_execute_formula_pub.g_additional_parameters(1).value := NULL;
968:
969: --set global parameter before Release accounting call : mixed contract
970: okl_execute_formula_pub.g_additional_parameters(1).name := 'NEW_RELEASE_ASSET';
971: okl_execute_formula_pub.g_additional_parameters(1).value := 'RELEASE';
972: --ndani - 14-Mar-2013, Start,Bug# 16511024 - Rebook accounting fix
973: IF l_acct_trans_type = 'Rebook' THEN
974: okl_la_je_pvt.generate_journal_entries (p_api_version,
967: okl_execute_formula_pub.g_additional_parameters(1).value := NULL;
968:
969: --set global parameter before Release accounting call : mixed contract
970: okl_execute_formula_pub.g_additional_parameters(1).name := 'NEW_RELEASE_ASSET';
971: okl_execute_formula_pub.g_additional_parameters(1).value := 'RELEASE';
972: --ndani - 14-Mar-2013, Start,Bug# 16511024 - Rebook accounting fix
973: IF l_acct_trans_type = 'Rebook' THEN
974: okl_la_je_pvt.generate_journal_entries (p_api_version,
975: p_init_msg_list,
1015: --ndani - 14-Mar-2013, Start,Bug#16511024 - Rebook accounting fix
1016: END IF;
1017: --ndani - 14-Mar-2013, End,Bug#16511024 - Rebook accounting fix
1018: --reset global parameter after Release accounting call : mixed contract
1019: okl_execute_formula_pub.g_additional_parameters(1).name := NULL;
1020: okl_execute_formula_pub.g_additional_parameters(1).value := NULL;
1021:
1022:
1023: END IF;
1016: END IF;
1017: --ndani - 14-Mar-2013, End,Bug#16511024 - Rebook accounting fix
1018: --reset global parameter after Release accounting call : mixed contract
1019: okl_execute_formula_pub.g_additional_parameters(1).name := NULL;
1020: okl_execute_formula_pub.g_additional_parameters(1).value := NULL;
1021:
1022:
1023: END IF;
1024: --Bug# 15992711 , End
4128:
4129: /*
4130: IF l_acc_call_rel_flag = 'Y' THEN
4131: --set global parameter before accounting call
4132: okl_execute_formula_pub.g_additional_parameters(1).name := 'NEW_RELEASE_ASSET';
4133: IF l_acct_trans_type = 'Rebook' THEN
4134: okl_execute_formula_pub.g_additional_parameters(1).value := 'NEW';
4135: END IF;
4136: END IF;
4130: IF l_acc_call_rel_flag = 'Y' THEN
4131: --set global parameter before accounting call
4132: okl_execute_formula_pub.g_additional_parameters(1).name := 'NEW_RELEASE_ASSET';
4133: IF l_acct_trans_type = 'Rebook' THEN
4134: okl_execute_formula_pub.g_additional_parameters(1).value := 'NEW';
4135: END IF;
4136: END IF;
4137: */
4138: --Bug# 16511024 , End
4161: IF l_acc_call_rel_flag = 'Y' THEN
4162:
4163: /*
4164: --reset global parameter after Booking accounting call : mixed contract
4165: okl_execute_formula_pub.g_additional_parameters(1).name := NULL;
4166: okl_execute_formula_pub.g_additional_parameters(1).value := NULL;
4167:
4168: --set global parameter before Release accounting call : mixed contract
4169: okl_execute_formula_pub.g_additional_parameters(1).name := 'NEW_RELEASE_ASSET';
4162:
4163: /*
4164: --reset global parameter after Booking accounting call : mixed contract
4165: okl_execute_formula_pub.g_additional_parameters(1).name := NULL;
4166: okl_execute_formula_pub.g_additional_parameters(1).value := NULL;
4167:
4168: --set global parameter before Release accounting call : mixed contract
4169: okl_execute_formula_pub.g_additional_parameters(1).name := 'NEW_RELEASE_ASSET';
4170: okl_execute_formula_pub.g_additional_parameters(1).value := 'RELEASE';
4165: okl_execute_formula_pub.g_additional_parameters(1).name := NULL;
4166: okl_execute_formula_pub.g_additional_parameters(1).value := NULL;
4167:
4168: --set global parameter before Release accounting call : mixed contract
4169: okl_execute_formula_pub.g_additional_parameters(1).name := 'NEW_RELEASE_ASSET';
4170: okl_execute_formula_pub.g_additional_parameters(1).value := 'RELEASE';
4171: */
4172:
4173: okl_la_je_pvt.generate_journal_entries
4166: okl_execute_formula_pub.g_additional_parameters(1).value := NULL;
4167:
4168: --set global parameter before Release accounting call : mixed contract
4169: okl_execute_formula_pub.g_additional_parameters(1).name := 'NEW_RELEASE_ASSET';
4170: okl_execute_formula_pub.g_additional_parameters(1).value := 'RELEASE';
4171: */
4172:
4173: okl_la_je_pvt.generate_journal_entries
4174: (l_api_version,
4186:
4187:
4188: /*
4189: --reset global parameter after Release accounting call : mixed contract
4190: okl_execute_formula_pub.g_additional_parameters(1).name := NULL;
4191: okl_execute_formula_pub.g_additional_parameters(1).value := NULL;
4192: */
4193:
4194: END IF;
4187:
4188: /*
4189: --reset global parameter after Release accounting call : mixed contract
4190: okl_execute_formula_pub.g_additional_parameters(1).name := NULL;
4191: okl_execute_formula_pub.g_additional_parameters(1).value := NULL;
4192: */
4193:
4194: END IF;
4195: --Bug# 16511024 , End
4263:
4264: --Bug# 15992711 , Start
4265: IF l_acc_call_rel_flag = 'Y' THEN
4266: --set global parameter before accounting call
4267: okl_execute_formula_pub.g_additional_parameters(1).name := 'NEW_RELEASE_ASSET';
4268: IF l_acct_trans_type = 'Booking' THEN
4269: okl_execute_formula_pub.g_additional_parameters(1).value := 'NEW';
4270: END IF;
4271: END IF;
4265: IF l_acc_call_rel_flag = 'Y' THEN
4266: --set global parameter before accounting call
4267: okl_execute_formula_pub.g_additional_parameters(1).name := 'NEW_RELEASE_ASSET';
4268: IF l_acct_trans_type = 'Booking' THEN
4269: okl_execute_formula_pub.g_additional_parameters(1).value := 'NEW';
4270: END IF;
4271: END IF;
4272: --Bug# 15992711 , End
4273:
4302:
4303: IF l_acc_call_rel_flag = 'Y' THEN
4304:
4305: --reset global parameter after Booking accounting call : mixed contract
4306: okl_execute_formula_pub.g_additional_parameters(1).name := NULL;
4307: okl_execute_formula_pub.g_additional_parameters(1).value := NULL;
4308:
4309: --set global parameter before Release accounting call : mixed contract
4310: okl_execute_formula_pub.g_additional_parameters(1).name := 'NEW_RELEASE_ASSET';
4303: IF l_acc_call_rel_flag = 'Y' THEN
4304:
4305: --reset global parameter after Booking accounting call : mixed contract
4306: okl_execute_formula_pub.g_additional_parameters(1).name := NULL;
4307: okl_execute_formula_pub.g_additional_parameters(1).value := NULL;
4308:
4309: --set global parameter before Release accounting call : mixed contract
4310: okl_execute_formula_pub.g_additional_parameters(1).name := 'NEW_RELEASE_ASSET';
4311: okl_execute_formula_pub.g_additional_parameters(1).value := 'RELEASE';
4306: okl_execute_formula_pub.g_additional_parameters(1).name := NULL;
4307: okl_execute_formula_pub.g_additional_parameters(1).value := NULL;
4308:
4309: --set global parameter before Release accounting call : mixed contract
4310: okl_execute_formula_pub.g_additional_parameters(1).name := 'NEW_RELEASE_ASSET';
4311: okl_execute_formula_pub.g_additional_parameters(1).value := 'RELEASE';
4312:
4313: okl_la_je_pvt.generate_journal_entries
4314: (l_api_version,
4307: okl_execute_formula_pub.g_additional_parameters(1).value := NULL;
4308:
4309: --set global parameter before Release accounting call : mixed contract
4310: okl_execute_formula_pub.g_additional_parameters(1).name := 'NEW_RELEASE_ASSET';
4311: okl_execute_formula_pub.g_additional_parameters(1).value := 'RELEASE';
4312:
4313: okl_la_je_pvt.generate_journal_entries
4314: (l_api_version,
4315: p_init_msg_list,
4331: RAISE okl_api.g_exception_error;
4332: END IF;
4333:
4334: --reset global parameter after Release accounting call : mixed contract
4335: okl_execute_formula_pub.g_additional_parameters(1).name := NULL;
4336: okl_execute_formula_pub.g_additional_parameters(1).value := NULL;
4337:
4338: END IF;
4339: --Bug# 15992711 , End
4332: END IF;
4333:
4334: --reset global parameter after Release accounting call : mixed contract
4335: okl_execute_formula_pub.g_additional_parameters(1).name := NULL;
4336: okl_execute_formula_pub.g_additional_parameters(1).value := NULL;
4337:
4338: END IF;
4339: --Bug# 15992711 , End
4340: