DBA Data[Home] [Help]

APPS.OKL_AM_WF dependencies on FND_MSG_PUB

Line 164: FND_MSG_PUB.ADD;

160: EXCEPTION
161: WHEN OTHERS THEN
162: FND_MESSAGE.SET_NAME('OKL', 'OKL_API_OTHERS_EXCEP');
163: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
164: FND_MSG_PUB.ADD;
165:
166: IF okl_key_csr%ISOPEN THEN
167: CLOSE okl_key_csr;
168: END IF;

Line 320: FND_MSG_PUB.ADD;

316: EXCEPTION
317: WHEN OTHERS THEN
318: FND_MESSAGE.SET_NAME('OKL', 'OKL_API_OTHERS_EXCEP');
319: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
320: FND_MSG_PUB.ADD;
321:
322: IF okl_key_csr%ISOPEN THEN
323: CLOSE okl_key_csr;
324: END IF;

Line 373: l_msg_idx INTEGER := FND_MSG_PUB.G_FIRST;

369: l_mt_bind_types p_bind_type_tbl;
370:
371: l_email_address VARCHAR(100);
372: lx_error_rec OKL_API.error_rec_type;
373: l_msg_idx INTEGER := FND_MSG_PUB.G_FIRST;
374:
375: -- for debug logging
376: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'call_am_fulfillment';
377: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);

Line 455: fnd_msg_pub.get(

451:
452: l_status_message := ' ';
453: LOOP
454:
455: fnd_msg_pub.get(
456: p_msg_index => l_msg_idx,
457: p_encoded => FND_API.G_FALSE,
458: p_data => lx_error_rec.msg_data,
459: p_msg_index_out => lx_error_rec.msg_count);

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

465: END IF;
466:
467: END IF;
468:
469: EXIT WHEN ((lx_error_rec.msg_count = FND_MSG_PUB.COUNT_MSG)
470: OR (lx_error_rec.msg_count IS NULL));
471:
472: l_msg_idx := FND_MSG_PUB.G_NEXT;
473:

Line 472: l_msg_idx := FND_MSG_PUB.G_NEXT;

468:
469: EXIT WHEN ((lx_error_rec.msg_count = FND_MSG_PUB.COUNT_MSG)
470: OR (lx_error_rec.msg_count IS NULL));
471:
472: l_msg_idx := FND_MSG_PUB.G_NEXT;
473:
474: END LOOP;
475:
476: wf_engine.SetItemAttrText ( itemtype=> itemtype,

Line 1466: l_mesg_count := fnd_msg_pub.count_msg;

1462: END IF;
1463:
1464: IF funcmode = 'RUN' THEN
1465:
1466: l_mesg_count := fnd_msg_pub.count_msg;
1467:
1468: IF l_mesg_count > 0 THEN
1469:
1470: l_mesg_text := substr(fnd_msg_pub.get (fnd_msg_pub.G_FIRST, fnd_api.G_FALSE),1, 512);

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

1466: l_mesg_count := fnd_msg_pub.count_msg;
1467:
1468: IF l_mesg_count > 0 THEN
1469:
1470: l_mesg_text := substr(fnd_msg_pub.get (fnd_msg_pub.G_FIRST, fnd_api.G_FALSE),1, 512);
1471:
1472: --FOR i IN 1..2 LOOP -- (l_mesg_count - 1) loop -- SECHAWLA 03-DEC-04 4047159
1473: FOR i IN 1..(l_mesg_count - 1) loop -- SECHAWLA 03-DEC-04 4047159
1474: l_mesg_text := l_mesg_text || substr(fnd_msg_pub.get

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

1470: l_mesg_text := substr(fnd_msg_pub.get (fnd_msg_pub.G_FIRST, fnd_api.G_FALSE),1, 512);
1471:
1472: --FOR i IN 1..2 LOOP -- (l_mesg_count - 1) loop -- SECHAWLA 03-DEC-04 4047159
1473: FOR i IN 1..(l_mesg_count - 1) loop -- SECHAWLA 03-DEC-04 4047159
1474: l_mesg_text := l_mesg_text || substr(fnd_msg_pub.get
1475: (fnd_msg_pub.G_NEXT, fnd_api.G_FALSE), 1, 512);
1476: END LOOP;
1477:
1478: fnd_msg_pub.delete_msg();

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

1471:
1472: --FOR i IN 1..2 LOOP -- (l_mesg_count - 1) loop -- SECHAWLA 03-DEC-04 4047159
1473: FOR i IN 1..(l_mesg_count - 1) loop -- SECHAWLA 03-DEC-04 4047159
1474: l_mesg_text := l_mesg_text || substr(fnd_msg_pub.get
1475: (fnd_msg_pub.G_NEXT, fnd_api.G_FALSE), 1, 512);
1476: END LOOP;
1477:
1478: fnd_msg_pub.delete_msg();
1479:

Line 1478: fnd_msg_pub.delete_msg();

1474: l_mesg_text := l_mesg_text || substr(fnd_msg_pub.get
1475: (fnd_msg_pub.G_NEXT, fnd_api.G_FALSE), 1, 512);
1476: END LOOP;
1477:
1478: fnd_msg_pub.delete_msg();
1479:
1480: l_mesg_len := length(l_mesg_text);
1481:
1482: FOR i IN 1..ceil(l_mesg_len/255) LOOP