DBA Data[Home] [Help]

APPS.OKL_AM_WF dependencies on FND_MSG_PUB

Line 232: FND_MSG_PUB.ADD;

228: EXCEPTION
229: WHEN OTHERS THEN
230: FND_MESSAGE.SET_NAME('OKL', 'OKL_API_OTHERS_EXCEP');
231: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
232: FND_MSG_PUB.ADD;
233:
234: IF okl_key_csr%ISOPEN THEN
235: CLOSE okl_key_csr;
236: END IF;

Line 388: FND_MSG_PUB.ADD;

384: EXCEPTION
385: WHEN OTHERS THEN
386: FND_MESSAGE.SET_NAME('OKL', 'OKL_API_OTHERS_EXCEP');
387: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
388: FND_MSG_PUB.ADD;
389:
390: IF okl_key_csr%ISOPEN THEN
391: CLOSE okl_key_csr;
392: END IF;

Line 441: l_msg_idx INTEGER := FND_MSG_PUB.G_FIRST;

437: l_mt_bind_types p_bind_type_tbl;
438:
439: l_email_address VARCHAR(100);
440: lx_error_rec OKL_API.error_rec_type;
441: l_msg_idx INTEGER := FND_MSG_PUB.G_FIRST;
442:
443: -- for debug logging
444: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'call_am_fulfillment';
445: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);

Line 523: fnd_msg_pub.get(

519:
520: l_status_message := ' ';
521: LOOP
522:
523: fnd_msg_pub.get(
524: p_msg_index => l_msg_idx,
525: p_encoded => FND_API.G_FALSE,
526: p_data => lx_error_rec.msg_data,
527: p_msg_index_out => lx_error_rec.msg_count);

Line 537: EXIT WHEN ((lx_error_rec.msg_count = FND_MSG_PUB.COUNT_MSG)

533: END IF;
534:
535: END IF;
536:
537: EXIT WHEN ((lx_error_rec.msg_count = FND_MSG_PUB.COUNT_MSG)
538: OR (lx_error_rec.msg_count IS NULL));
539:
540: l_msg_idx := FND_MSG_PUB.G_NEXT;
541:

Line 540: l_msg_idx := FND_MSG_PUB.G_NEXT;

536:
537: EXIT WHEN ((lx_error_rec.msg_count = FND_MSG_PUB.COUNT_MSG)
538: OR (lx_error_rec.msg_count IS NULL));
539:
540: l_msg_idx := FND_MSG_PUB.G_NEXT;
541:
542: END LOOP;
543:
544: wf_engine.SetItemAttrText ( itemtype=> itemtype,

Line 1549: l_mesg_count := fnd_msg_pub.count_msg;

1545: END IF;
1546:
1547: IF funcmode = 'RUN' THEN
1548:
1549: l_mesg_count := fnd_msg_pub.count_msg;
1550:
1551: IF l_mesg_count > 0 THEN
1552:
1553: l_mesg_text := substr(fnd_msg_pub.get (fnd_msg_pub.G_FIRST, fnd_api.G_FALSE),1, 512);

Line 1553: l_mesg_text := substr(fnd_msg_pub.get (fnd_msg_pub.G_FIRST, fnd_api.G_FALSE),1, 512);

1549: l_mesg_count := fnd_msg_pub.count_msg;
1550:
1551: IF l_mesg_count > 0 THEN
1552:
1553: l_mesg_text := substr(fnd_msg_pub.get (fnd_msg_pub.G_FIRST, fnd_api.G_FALSE),1, 512);
1554:
1555: --FOR i IN 1..2 LOOP -- (l_mesg_count - 1) loop -- SECHAWLA 03-DEC-04 4047159
1556: FOR i IN 1..(l_mesg_count - 1) loop -- SECHAWLA 03-DEC-04 4047159
1557: l_mesg_text := l_mesg_text || substr(fnd_msg_pub.get

Line 1557: l_mesg_text := l_mesg_text || substr(fnd_msg_pub.get

1553: l_mesg_text := substr(fnd_msg_pub.get (fnd_msg_pub.G_FIRST, fnd_api.G_FALSE),1, 512);
1554:
1555: --FOR i IN 1..2 LOOP -- (l_mesg_count - 1) loop -- SECHAWLA 03-DEC-04 4047159
1556: FOR i IN 1..(l_mesg_count - 1) loop -- SECHAWLA 03-DEC-04 4047159
1557: l_mesg_text := l_mesg_text || substr(fnd_msg_pub.get
1558: (fnd_msg_pub.G_NEXT, fnd_api.G_FALSE), 1, 512);
1559: END LOOP;
1560:
1561: fnd_msg_pub.delete_msg();

Line 1558: (fnd_msg_pub.G_NEXT, fnd_api.G_FALSE), 1, 512);

1554:
1555: --FOR i IN 1..2 LOOP -- (l_mesg_count - 1) loop -- SECHAWLA 03-DEC-04 4047159
1556: FOR i IN 1..(l_mesg_count - 1) loop -- SECHAWLA 03-DEC-04 4047159
1557: l_mesg_text := l_mesg_text || substr(fnd_msg_pub.get
1558: (fnd_msg_pub.G_NEXT, fnd_api.G_FALSE), 1, 512);
1559: END LOOP;
1560:
1561: fnd_msg_pub.delete_msg();
1562:

Line 1561: fnd_msg_pub.delete_msg();

1557: l_mesg_text := l_mesg_text || substr(fnd_msg_pub.get
1558: (fnd_msg_pub.G_NEXT, fnd_api.G_FALSE), 1, 512);
1559: END LOOP;
1560:
1561: fnd_msg_pub.delete_msg();
1562:
1563: l_mesg_len := length(l_mesg_text);
1564:
1565: FOR i IN 1..ceil(l_mesg_len/255) LOOP