DBA Data[Home] [Help]

APPS.OKL_CS_WF dependencies on FND_MSG_PUB

Line 35: l_temp_msg := fnd_msg_pub.get(fnd_msg_pub.g_next, fnd_api.g_true);

31: and lng.language_id = x_lang_id;
32: BEGIN
33: FOR l_count in 1..p_message_count LOOP
34:
35: l_temp_msg := fnd_msg_pub.get(fnd_msg_pub.g_next, fnd_api.g_true);
36: fnd_message.parse_encoded(l_temp_msg, l_appl_short_name, l_message_name);
37: OPEN Get_Appl_Id (l_appl_short_name);
38: FETCH Get_Appl_Id into l_id;
39: CLOSE Get_Appl_Id;

Line 50: l_temp_msg := fnd_msg_pub.get(fnd_msg_pub.g_previous, fnd_api.g_true);

46: FETCH Get_Message_Num into l_message_num;
47: CLOSE Get_Message_Num;
48: END IF;
49:
50: l_temp_msg := fnd_msg_pub.get(fnd_msg_pub.g_previous, fnd_api.g_true);
51:
52: IF NVL(l_message_num, 0) <> 0
53: THEN
54: l_temp_msg := 'APP-' || to_char(l_message_num) || ': ';

Line 62: fnd_msg_pub.get(fnd_msg_pub.g_first, fnd_api.g_false);

58:
59: IF l_count = 1
60: THEN
61: l_msg_list := l_msg_list || l_temp_msg ||
62: fnd_msg_pub.get(fnd_msg_pub.g_first, fnd_api.g_false);
63: ELSE
64: l_msg_list := l_msg_list || l_temp_msg ||
65: fnd_msg_pub.get(fnd_msg_pub.g_next, fnd_api.g_false);
66: END IF;

Line 65: fnd_msg_pub.get(fnd_msg_pub.g_next, fnd_api.g_false);

61: l_msg_list := l_msg_list || l_temp_msg ||
62: fnd_msg_pub.get(fnd_msg_pub.g_first, fnd_api.g_false);
63: ELSE
64: l_msg_list := l_msg_list || l_temp_msg ||
65: fnd_msg_pub.get(fnd_msg_pub.g_next, fnd_api.g_false);
66: END IF;
67:
68: l_msg_list := l_msg_list || '';
69:

Line 112: FND_MSG_PUB.ADD;

108: EXCEPTION
109: WHEN OTHERS THEN
110: FND_MESSAGE.SET_NAME('OKL', 'OKL_API_OTHERS_EXCEP');
111: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
112: FND_MSG_PUB.ADD;
113: ROLLBACK TO raise_equipment_exchange_event;
114: END raise_equipment_exchange_event;
115:
116:

Line 509: FND_MSG_PUB.ADD;

505: EXCEPTION
506: WHEN OTHERS THEN
507: FND_MESSAGE.SET_NAME('OKL', 'OKL_API_OTHERS_EXCEP');
508: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
509: FND_MSG_PUB.ADD;
510: ROLLBACK TO raise_transferasu_event;
511: END raise_transferAsu_event;
512:
513:

Line 838: FND_MSG_PUB.Count_And_Get

834: x_msg_count => l_msg_count,
835: x_msg_data => l_msg_data);
836:
837: IF l_return_status <> 'S' THEN
838: FND_MSG_PUB.Count_And_Get
839: ( p_count => l_msg_count,
840: p_data => l_msg_data);
841: Get_Messages(l_msg_count,l_error);
842:

Line 910: FND_MSG_PUB.Count_And_Get

906: x_return_status => l_return_status,
907: x_msg_count => l_msg_count,
908: x_msg_data => l_msg_data);
909: IF l_return_status <> 'S' THEN
910: FND_MSG_PUB.Count_And_Get
911: ( p_count => l_msg_count,
912: p_data => l_msg_data);
913: Get_Messages(l_msg_count,l_error);
914:

Line 1125: FND_MSG_PUB.Count_And_Get

1121: x_msg_count => lx_msg_count,
1122: x_msg_data => lx_msg_data);
1123:
1124: IF lx_return_status <> 'S' THEN
1125: FND_MSG_PUB.Count_And_Get
1126: ( p_count => lx_msg_count,
1127: p_data => lx_msg_data);
1128: Get_Messages(lx_msg_count,l_error);
1129:

Line 1247: FND_MSG_PUB.Count_And_Get

1243: x_msg_count => lx_msg_count,
1244: x_msg_data => lx_msg_data);
1245:
1246: IF lx_return_status <> 'S' THEN
1247: FND_MSG_PUB.Count_And_Get
1248: ( p_count => lx_msg_count,
1249: p_data => lx_msg_data);
1250: Get_Messages(lx_msg_count,l_error);
1251:

Line 1339: FND_MSG_PUB.Count_And_Get

1335: x_tcnv_rec => lx_tcnv_rec,
1336: x_tclv_tbl => lx_tclv_tbl);
1337:
1338: IF l_return_status <> 'S' THEN
1339: FND_MSG_PUB.Count_And_Get
1340: ( p_count => l_msg_count,
1341: p_data => l_msg_data);
1342: Get_Messages(l_msg_count,l_error);
1343:

Line 1438: FND_MSG_PUB.Count_And_Get

1434: x_tcnv_rec => lx_tcnv_rec,
1435: x_tclv_tbl => lx_tclv_tbl);
1436:
1437: IF l_return_status <> 'S' THEN
1438: FND_MSG_PUB.Count_And_Get
1439: ( p_count => l_msg_count,
1440: p_data => l_msg_data);
1441: Get_Messages(l_msg_count,l_error);
1442:

Line 1550: FND_MSG_PUB.Count_And_Get

1546: x_tclv_tbl => lx_tclv_tbl);
1547:
1548:
1549: IF l_return_status <> 'S' THEN
1550: FND_MSG_PUB.Count_And_Get
1551: ( p_count => l_msg_count,
1552: p_data => l_msg_data);
1553: Get_Messages(l_msg_count,l_error);
1554:

Line 1687: FND_MSG_PUB.Count_And_Get

1683: x_tclv_tbl => lx_tclv_tbl);
1684:
1685:
1686: IF l_return_status <> 'S' THEN
1687: FND_MSG_PUB.Count_And_Get
1688: ( p_count => l_msg_count,
1689: p_data => l_msg_data);
1690: Get_Messages(l_msg_count,l_error);
1691:

Line 1880: FND_MSG_PUB.Count_And_Get

1876: avalue => l_batch_id );
1877: resultout := 'COMPLETE:YES';
1878:
1879: ELSE
1880: FND_MSG_PUB.Count_And_Get
1881: ( p_count => l_msg_count,
1882: p_data => l_msg_data);
1883: Get_Messages(l_msg_count,l_error);
1884:

Line 2056: FND_MSG_PUB.Count_And_Get

2052: x_msg_data => lx_msg_data);
2053:
2054:
2055: IF lx_return_status <> 'S' THEN
2056: FND_MSG_PUB.Count_And_Get
2057: ( p_count => lx_msg_count,
2058: p_data => lx_msg_data);
2059: Get_Messages(lx_msg_count,l_error);
2060:

Line 2158: FND_MSG_PUB.Count_And_Get

2154: x_tclv_tbl => lx_tclv_tbl);
2155:
2156:
2157: IF l_return_status <> 'S' THEN
2158: FND_MSG_PUB.Count_And_Get
2159: ( p_count => l_msg_count,
2160: p_data => l_msg_data);
2161: Get_Messages(l_msg_count,l_error);
2162:

Line 2201: FND_MSG_PUB.Count_And_Get

2197: aname => 'BATCH_ID',
2198: avalue => l_batch_id );
2199:
2200: ELSE
2201: FND_MSG_PUB.Count_And_Get
2202: ( p_count => l_msg_count,
2203: p_data => l_msg_data);
2204: Get_Messages(l_msg_count,l_error);
2205:

Line 2331: FND_MSG_PUB.Count_And_Get

2327: x_tclv_tbl => lx_tclv_tbl);
2328:
2329:
2330: IF l_return_status <> 'S' THEN
2331: FND_MSG_PUB.Count_And_Get
2332: ( p_count => l_msg_count,
2333: p_data => l_msg_data);
2334: Get_Messages(l_msg_count,l_error);
2335:

Line 3033: FND_MSG_PUB.ADD;

3029: EXCEPTION
3030: WHEN OTHERS THEN
3031: FND_MESSAGE.SET_NAME('OKL', 'OKL_API_OTHERS_EXCEP');
3032: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3033: FND_MSG_PUB.ADD;
3034: ROLLBACK TO raise_lease_renewal_event;
3035: END raise_lease_renewal_event;
3036:
3037:

Line 3351: FND_MSG_PUB.ADD;

3347: EXCEPTION
3348: WHEN OTHERS THEN
3349: FND_MESSAGE.SET_NAME('OKL', 'OKL_API_OTHERS_EXCEP');
3350: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3351: FND_MSG_PUB.ADD;
3352: ROLLBACK TO raise_principal_paydown_event;
3353: END raise_principal_paydown_event;
3354:
3355:

Line 3604: FND_MSG_PUB.Count_And_Get

3600: p_khr_id => l_khr_id,
3601: p_req_id => l_request_id);
3602:
3603: IF l_return_status <> 'S' THEN
3604: FND_MSG_PUB.Count_And_Get
3605: ( p_count => l_msg_count,
3606: p_data => l_msg_data
3607: );
3608: Get_Messages(l_msg_count,l_error);

Line 3711: FND_MSG_PUB.Count_And_Get

3707:
3708:
3709:
3710: IF l_return_status <> 'S' THEN
3711: FND_MSG_PUB.Count_And_Get
3712: ( p_count => l_msg_count,
3713: p_data => l_msg_data
3714: );
3715: Get_Messages(l_msg_count,l_error);

Line 3806: FND_MSG_PUB.ADD;

3802: EXCEPTION
3803: WHEN OTHERS THEN
3804: FND_MESSAGE.SET_NAME('OKL', 'OKL_API_OTHERS_EXCEP');
3805: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3806: FND_MSG_PUB.ADD;
3807: ROLLBACK TO raise_credit_memo_event;
3808: END raise_credit_memo_event;
3809:
3810:

Line 3974: FND_MSG_PUB.Count_And_Get

3970: --I think if the api is not a success we should log the error in a
3971: --table.
3972:
3973: IF l_return_status <> 'S' THEN
3974: FND_MSG_PUB.Count_And_Get
3975: ( p_count => l_msg_count,
3976: p_data => l_msg_data
3977: );
3978: Get_Messages(l_msg_count,l_error);

Line 4078: FND_MSG_PUB.Count_And_Get

4074:
4075:
4076:
4077: IF l_return_status <> 'S' THEN
4078: FND_MSG_PUB.Count_And_Get
4079: ( p_count => l_msg_count,
4080: p_data => l_msg_data
4081: );
4082: Get_Messages(l_msg_count,l_error);

Line 4178: FND_MSG_PUB.Count_And_Get

4174:
4175:
4176:
4177: IF l_return_status <> 'S' THEN
4178: FND_MSG_PUB.Count_And_Get
4179: ( p_count => l_msg_count,
4180: p_data => l_msg_data
4181: );
4182: Get_Messages(l_msg_count,l_error);

Line 4286: FND_MSG_PUB.Count_And_Get

4282:
4283:
4284:
4285: IF l_return_status <> 'S' THEN
4286: FND_MSG_PUB.Count_And_Get
4287: ( p_count => l_msg_count,
4288: p_data => l_msg_data
4289: );
4290: Get_Messages(l_msg_count,l_error);

Line 4385: FND_MSG_PUB.Count_And_Get

4381:
4382:
4383:
4384: IF l_return_status <> 'S' THEN
4385: FND_MSG_PUB.Count_And_Get
4386: ( p_count => l_msg_count,
4387: p_data => l_msg_data
4388: );
4389: Get_Messages(l_msg_count,l_error);