DBA Data[Home] [Help]

APPS.OKL_SSC_WF dependencies on FND_MSG_PUB

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

1260: EXCEPTION
1261:
1262: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1263: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1264: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
1265: p_data => x_msg_data);
1266:
1267: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1268: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

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

1265: p_data => x_msg_data);
1266:
1267: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1268: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1269: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
1270: p_data => x_msg_data);
1271:
1272: WHEN OTHERS THEN
1273: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

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

1270: p_data => x_msg_data);
1271:
1272: WHEN OTHERS THEN
1273: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1274: FND_MSG_PUB.ADD_EXC_MSG('OKL_SSC_ASST_LOC_SERNUM_PUB','Update_Serial_Number');
1275: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
1276: p_data => x_msg_data);
1277:
1278: END update_serial_number;

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

1271:
1272: WHEN OTHERS THEN
1273: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1274: FND_MSG_PUB.ADD_EXC_MSG('OKL_SSC_ASST_LOC_SERNUM_PUB','Update_Serial_Number');
1275: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
1276: p_data => x_msg_data);
1277:
1278: END update_serial_number;
1279:

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

1410: EXCEPTION
1411:
1412: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1413: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1414: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
1415: p_data => x_msg_data);
1416:
1417: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1418: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

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

1415: p_data => x_msg_data);
1416:
1417: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1418: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1419: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
1420: p_data => x_msg_data);
1421:
1422: WHEN OTHERS THEN
1423: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

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

1420: p_data => x_msg_data);
1421:
1422: WHEN OTHERS THEN
1423: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1424: FND_MSG_PUB.ADD_EXC_MSG('OKL_SSC_ASST_LOC_SERNUM_PUB','Update_Location');
1425: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
1426: p_data => x_msg_data);
1427:
1428: END update_location;

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

1421:
1422: WHEN OTHERS THEN
1423: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1424: FND_MSG_PUB.ADD_EXC_MSG('OKL_SSC_ASST_LOC_SERNUM_PUB','Update_Location');
1425: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
1426: p_data => x_msg_data);
1427:
1428: END update_location;
1429:

Line 1865: FND_MSG_PUB.Count_And_Get (

1861: end if;
1862:
1863: exception
1864: /*when api_exception then
1865: FND_MSG_PUB.Count_And_Get (
1866: p_encoded => FND_API.G_FALSE,
1867: p_count => lx_msg_count,
1868: p_data => lx_msg_data);*/
1869: when others then

Line 2493: FND_MSG_PUB.Count_And_Get (

2489:
2490: EXCEPTION
2491:
2492: when api_exception then
2493: FND_MSG_PUB.Count_And_Get (
2494: p_encoded => FND_API.G_FALSE,
2495: p_count => l_msg_count,
2496: p_data => l_msg_data);
2497:

Line 2805: FND_MSG_PUB.ADD;

2801: END IF;
2802:
2803: ELSE
2804: FND_MESSAGE.SET_NAME('OKL', 'OKL_NO_EVENT');
2805: FND_MSG_PUB.ADD;
2806: l_return_status := OKC_API.G_RET_STS_ERROR ;
2807:
2808: x_return_status := l_return_status ;
2809: x_msg_count := l_msg_count ;

Line 2821: FND_MSG_PUB.Count_And_Get (

2817: x_return_status := l_return_status;
2818: x_msg_count := l_msg_count ;
2819: x_msg_data := l_msg_data ;
2820:
2821: FND_MSG_PUB.Count_And_Get (
2822: p_encoded => FND_API.G_FALSE,
2823: p_count => x_msg_count,
2824: p_data => x_msg_data);
2825:

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

2828: x_return_status := l_return_status;
2829: x_msg_count := l_msg_count ;
2830: x_msg_data := l_msg_data ;
2831:
2832: --FND_MSG_PUB.ADD_EXC_MSG( 'OKL_SSC_WF' , 'cancel_ins_wrapper_wf', itemtype, itemkey, 'c','d');
2833: FND_MSG_PUB.count_and_get(
2834: p_count => x_msg_count
2835: ,p_data => x_msg_data);
2836: ROLLBACK TO cancel_insurance;

Line 2833: FND_MSG_PUB.count_and_get(

2829: x_msg_count := l_msg_count ;
2830: x_msg_data := l_msg_data ;
2831:
2832: --FND_MSG_PUB.ADD_EXC_MSG( 'OKL_SSC_WF' , 'cancel_ins_wrapper_wf', itemtype, itemkey, 'c','d');
2833: FND_MSG_PUB.count_and_get(
2834: p_count => x_msg_count
2835: ,p_data => x_msg_data);
2836: ROLLBACK TO cancel_insurance;
2837: END cancel_ins_wrapper_wf;

Line 2897: FND_MSG_PUB.ADD;

2893: fetch claim_info into l_policy_number,l_claim_number ;
2894:
2895: IF (claim_info%NOTFOUND) THEN
2896: FND_MESSAGE.SET_NAME('OKL', 'OKL_INVALID_VALUE');
2897: FND_MSG_PUB.ADD;
2898: raise api_exception;
2899: END IF ;
2900:
2901: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'POLICY_NUMBER', l_policy_number);

Line 2987: FND_MSG_PUB.ADD;

2983: l_parameter_list.DELETE;
2984:
2985: ELSE
2986: FND_MESSAGE.SET_NAME('OKL', 'OKL_NO_EVENT');
2987: FND_MSG_PUB.ADD;
2988: x_retrun_status := OKC_API.G_RET_STS_ERROR ;
2989: END IF;
2990: EXCEPTION
2991: WHEN OTHERS THEN

Line 2994: FND_MSG_PUB.ADD;

2990: EXCEPTION
2991: WHEN OTHERS THEN
2992: FND_MESSAGE.SET_NAME('OKL', 'OKL_API_OTHERS_EXCEP');
2993: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2994: FND_MSG_PUB.ADD;
2995: ROLLBACK TO create_claim_event;
2996: x_retrun_status := OKC_API.G_RET_STS_UNEXP_ERROR ;
2997:
2998: END create_claim_event;

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

3010: itemkey in varchar2) is
3011: i integer;
3012: j integer;
3013: begin
3014: j := NVL(FND_MSG_PUB.Count_Msg,0);
3015: if (j=0) then return; end if;
3016: if (j>9) then j:=9; end if;
3017: FOR I IN 1..J LOOP
3018: wf_engine.SetItemAttrText (itemtype => itemtype,

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

3017: FOR I IN 1..J LOOP
3018: wf_engine.SetItemAttrText (itemtype => itemtype,
3019: itemkey => itemkey,
3020: aname => 'MESSAGE'||i,
3021: avalue => FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
3022: END LOOP;
3023: end;
3024:
3025:

Line 3113: FND_MSG_PUB.Count_And_Get (

3109: EXCEPTION
3110:
3111: when api_exception then
3112:
3113: FND_MSG_PUB.Count_And_Get (
3114: p_encoded => FND_API.G_FALSE,
3115: p_count => x_msg_count,
3116: p_data => x_msg_data);
3117: raise;

Line 3210: FND_MSG_PUB.Count_And_Get (

3206: EXCEPTION
3207:
3208: when api_exception then
3209:
3210: FND_MSG_PUB.Count_And_Get (
3211: p_encoded => FND_API.G_FALSE,
3212: p_count => x_msg_count,
3213: p_data => x_msg_data);
3214: raise;

Line 3609: FND_MSG_PUB.Count_And_Get (

3605: x_return_status := l_return_status;
3606: x_msg_count := l_msg_count ;
3607: x_msg_data := l_msg_data ;
3608:
3609: FND_MSG_PUB.Count_And_Get (
3610: p_encoded => FND_API.G_FALSE,
3611: p_count => x_msg_count,
3612: p_data => x_msg_data);
3613:

Line 3620: FND_MSG_PUB.count_and_get(

3616: x_return_status := l_return_status;
3617: x_msg_count := l_msg_count ;
3618: x_msg_data := l_msg_data ;
3619:
3620: FND_MSG_PUB.count_and_get(
3621: p_count => x_msg_count
3622: ,p_data => x_msg_data);
3623:
3624: END validate_recipient_term_quote;

Line 3649: FND_MSG_PUB.ADD;

3645: FROM dual;
3646:
3647: IF l_yn = 'N' THEN
3648: FND_MESSAGE.SET_NAME('OKL', 'OKL_NO_EVENT');
3649: FND_MSG_PUB.ADD;
3650: l_return_status := OKC_API.G_RET_STS_ERROR;
3651: raise api_exception;
3652: ELSE
3653: WF_EVENT.raise2(l_event_name,

Line 3668: FND_MSG_PUB.Count_And_Get (

3664: x_return_status := l_return_status;
3665: x_msg_count := l_msg_count ;
3666: x_msg_data := l_msg_data ;
3667:
3668: FND_MSG_PUB.Count_And_Get (
3669: p_encoded => FND_API.G_FALSE,
3670: p_count => x_msg_count,
3671: p_data => x_msg_data);
3672:

Line 3679: FND_MSG_PUB.count_and_get(

3675: x_return_status := l_return_status;
3676: x_msg_count := l_msg_count ;
3677: x_msg_data := l_msg_data ;
3678:
3679: FND_MSG_PUB.count_and_get(
3680: p_count => x_msg_count
3681: ,p_data => x_msg_data);
3682:
3683: END create_termqt_raise_event_wf;