DBA Data[Home] [Help]

APPS.OKL_SSC_WF dependencies on FND_MSG_PUB

Line 1178: FND_MSG_PUB.count_and_get(p_count => x_msg_count,

1174: EXCEPTION
1175:
1176: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1177: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1178: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
1179: p_data => x_msg_data);
1180:
1181: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1182: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 1183: FND_MSG_PUB.count_and_get(p_count => x_msg_count,

1179: p_data => x_msg_data);
1180:
1181: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1182: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1183: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
1184: p_data => x_msg_data);
1185:
1186: WHEN OTHERS THEN
1187: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 1188: FND_MSG_PUB.ADD_EXC_MSG('OKL_SSC_ASST_LOC_SERNUM_PUB','Update_Serial_Number');

1184: p_data => x_msg_data);
1185:
1186: WHEN OTHERS THEN
1187: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1188: FND_MSG_PUB.ADD_EXC_MSG('OKL_SSC_ASST_LOC_SERNUM_PUB','Update_Serial_Number');
1189: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
1190: p_data => x_msg_data);
1191:
1192: END update_serial_number;

Line 1189: FND_MSG_PUB.count_and_get(p_count => x_msg_count,

1185:
1186: WHEN OTHERS THEN
1187: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1188: FND_MSG_PUB.ADD_EXC_MSG('OKL_SSC_ASST_LOC_SERNUM_PUB','Update_Serial_Number');
1189: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
1190: p_data => x_msg_data);
1191:
1192: END update_serial_number;
1193:

Line 1328: FND_MSG_PUB.count_and_get(p_count => x_msg_count,

1324: EXCEPTION
1325:
1326: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1327: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1328: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
1329: p_data => x_msg_data);
1330:
1331: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1332: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 1333: FND_MSG_PUB.count_and_get(p_count => x_msg_count,

1329: p_data => x_msg_data);
1330:
1331: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1332: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1333: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
1334: p_data => x_msg_data);
1335:
1336: WHEN OTHERS THEN
1337: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 1338: FND_MSG_PUB.ADD_EXC_MSG('OKL_SSC_ASST_LOC_SERNUM_PUB','Update_Location');

1334: p_data => x_msg_data);
1335:
1336: WHEN OTHERS THEN
1337: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1338: FND_MSG_PUB.ADD_EXC_MSG('OKL_SSC_ASST_LOC_SERNUM_PUB','Update_Location');
1339: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
1340: p_data => x_msg_data);
1341:
1342: END update_location;

Line 1339: FND_MSG_PUB.count_and_get(p_count => x_msg_count,

1335:
1336: WHEN OTHERS THEN
1337: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1338: FND_MSG_PUB.ADD_EXC_MSG('OKL_SSC_ASST_LOC_SERNUM_PUB','Update_Location');
1339: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
1340: p_data => x_msg_data);
1341:
1342: END update_location;
1343:

Line 1779: FND_MSG_PUB.Count_And_Get (

1775: end if;
1776:
1777: exception
1778: /*when api_exception then
1779: FND_MSG_PUB.Count_And_Get (
1780: p_encoded => FND_API.G_FALSE,
1781: p_count => lx_msg_count,
1782: p_data => lx_msg_data);*/
1783: when others then

Line 2407: FND_MSG_PUB.Count_And_Get (

2403:
2404: EXCEPTION
2405:
2406: when api_exception then
2407: FND_MSG_PUB.Count_And_Get (
2408: p_encoded => FND_API.G_FALSE,
2409: p_count => l_msg_count,
2410: p_data => l_msg_data);
2411:

Line 2719: FND_MSG_PUB.ADD;

2715: END IF;
2716:
2717: ELSE
2718: FND_MESSAGE.SET_NAME('OKL', 'OKL_NO_EVENT');
2719: FND_MSG_PUB.ADD;
2720: l_return_status := OKC_API.G_RET_STS_ERROR ;
2721:
2722: x_return_status := l_return_status ;
2723: x_msg_count := l_msg_count ;

Line 2735: FND_MSG_PUB.Count_And_Get (

2731: x_return_status := l_return_status;
2732: x_msg_count := l_msg_count ;
2733: x_msg_data := l_msg_data ;
2734:
2735: FND_MSG_PUB.Count_And_Get (
2736: p_encoded => FND_API.G_FALSE,
2737: p_count => x_msg_count,
2738: p_data => x_msg_data);
2739:

Line 2746: --FND_MSG_PUB.ADD_EXC_MSG( 'OKL_SSC_WF' , 'cancel_ins_wrapper_wf', itemtype, itemkey, 'c','d');

2742: x_return_status := l_return_status;
2743: x_msg_count := l_msg_count ;
2744: x_msg_data := l_msg_data ;
2745:
2746: --FND_MSG_PUB.ADD_EXC_MSG( 'OKL_SSC_WF' , 'cancel_ins_wrapper_wf', itemtype, itemkey, 'c','d');
2747: FND_MSG_PUB.count_and_get(
2748: p_count => x_msg_count
2749: ,p_data => x_msg_data);
2750: ROLLBACK TO cancel_insurance;

Line 2747: FND_MSG_PUB.count_and_get(

2743: x_msg_count := l_msg_count ;
2744: x_msg_data := l_msg_data ;
2745:
2746: --FND_MSG_PUB.ADD_EXC_MSG( 'OKL_SSC_WF' , 'cancel_ins_wrapper_wf', itemtype, itemkey, 'c','d');
2747: FND_MSG_PUB.count_and_get(
2748: p_count => x_msg_count
2749: ,p_data => x_msg_data);
2750: ROLLBACK TO cancel_insurance;
2751: END cancel_ins_wrapper_wf;

Line 2811: FND_MSG_PUB.ADD;

2807: fetch claim_info into l_policy_number,l_claim_number ;
2808:
2809: IF (claim_info%NOTFOUND) THEN
2810: FND_MESSAGE.SET_NAME('OKL', 'OKL_INVALID_VALUE');
2811: FND_MSG_PUB.ADD;
2812: raise api_exception;
2813: END IF ;
2814:
2815: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'POLICY_NUMBER', l_policy_number);

Line 2901: FND_MSG_PUB.ADD;

2897: l_parameter_list.DELETE;
2898:
2899: ELSE
2900: FND_MESSAGE.SET_NAME('OKL', 'OKL_NO_EVENT');
2901: FND_MSG_PUB.ADD;
2902: x_retrun_status := OKC_API.G_RET_STS_ERROR ;
2903: END IF;
2904: EXCEPTION
2905: WHEN OTHERS THEN

Line 2908: FND_MSG_PUB.ADD;

2904: EXCEPTION
2905: WHEN OTHERS THEN
2906: FND_MESSAGE.SET_NAME('OKL', 'OKL_API_OTHERS_EXCEP');
2907: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2908: FND_MSG_PUB.ADD;
2909: ROLLBACK TO create_claim_event;
2910: x_retrun_status := OKC_API.G_RET_STS_UNEXP_ERROR ;
2911:
2912: END create_claim_event;

Line 2928: j := NVL(FND_MSG_PUB.Count_Msg,0);

2924: itemkey in varchar2) is
2925: i integer;
2926: j integer;
2927: begin
2928: j := NVL(FND_MSG_PUB.Count_Msg,0);
2929: if (j=0) then return; end if;
2930: if (j>9) then j:=9; end if;
2931: FOR I IN 1..J LOOP
2932: wf_engine.SetItemAttrText (itemtype => itemtype,

Line 2935: avalue => FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));

2931: FOR I IN 1..J LOOP
2932: wf_engine.SetItemAttrText (itemtype => itemtype,
2933: itemkey => itemkey,
2934: aname => 'MESSAGE'||i,
2935: avalue => FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
2936: END LOOP;
2937: end;
2938:
2939:

Line 3027: FND_MSG_PUB.Count_And_Get (

3023: EXCEPTION
3024:
3025: when api_exception then
3026:
3027: FND_MSG_PUB.Count_And_Get (
3028: p_encoded => FND_API.G_FALSE,
3029: p_count => x_msg_count,
3030: p_data => x_msg_data);
3031: raise;

Line 3124: FND_MSG_PUB.Count_And_Get (

3120: EXCEPTION
3121:
3122: when api_exception then
3123:
3124: FND_MSG_PUB.Count_And_Get (
3125: p_encoded => FND_API.G_FALSE,
3126: p_count => x_msg_count,
3127: p_data => x_msg_data);
3128: raise;

Line 3523: FND_MSG_PUB.Count_And_Get (

3519: x_return_status := l_return_status;
3520: x_msg_count := l_msg_count ;
3521: x_msg_data := l_msg_data ;
3522:
3523: FND_MSG_PUB.Count_And_Get (
3524: p_encoded => FND_API.G_FALSE,
3525: p_count => x_msg_count,
3526: p_data => x_msg_data);
3527:

Line 3534: FND_MSG_PUB.count_and_get(

3530: x_return_status := l_return_status;
3531: x_msg_count := l_msg_count ;
3532: x_msg_data := l_msg_data ;
3533:
3534: FND_MSG_PUB.count_and_get(
3535: p_count => x_msg_count
3536: ,p_data => x_msg_data);
3537:
3538: END validate_recipient_term_quote;

Line 3563: FND_MSG_PUB.ADD;

3559: FROM dual;
3560:
3561: IF l_yn = 'N' THEN
3562: FND_MESSAGE.SET_NAME('OKL', 'OKL_NO_EVENT');
3563: FND_MSG_PUB.ADD;
3564: l_return_status := OKC_API.G_RET_STS_ERROR;
3565: raise api_exception;
3566: ELSE
3567: WF_EVENT.raise2(l_event_name,

Line 3582: FND_MSG_PUB.Count_And_Get (

3578: x_return_status := l_return_status;
3579: x_msg_count := l_msg_count ;
3580: x_msg_data := l_msg_data ;
3581:
3582: FND_MSG_PUB.Count_And_Get (
3583: p_encoded => FND_API.G_FALSE,
3584: p_count => x_msg_count,
3585: p_data => x_msg_data);
3586:

Line 3593: FND_MSG_PUB.count_and_get(

3589: x_return_status := l_return_status;
3590: x_msg_count := l_msg_count ;
3591: x_msg_data := l_msg_data ;
3592:
3593: FND_MSG_PUB.count_and_get(
3594: p_count => x_msg_count
3595: ,p_data => x_msg_data);
3596:
3597: END create_termqt_raise_event_wf;