DBA Data[Home] [Help]

APPS.OKL_AM_WF dependencies on FND_API

Line 358: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

354: l_mesg_count NUMBER := 0;
355: l_mesg_text VARCHAR2(4000);
356: l_mesg_len NUMBER;
357:
358: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
359: l_msg_count NUMBER;
360: l_msg_data VARCHAR2(30000);
361:
362: l_status_message VARCHAR2(30000);

Line 429: , p_init_msg_list => FND_API.G_FALSE

425: aname => 'EMAIL_ADDRESS');
426:
427: OKL_AM_UTIL_PVT.EXECUTE_FULFILLMENT_REQUEST (
428: p_api_version => 1
429: , p_init_msg_list => FND_API.G_FALSE
430: , x_return_status => l_return_status
431: , x_msg_count => l_msg_count
432: , x_msg_data => l_msg_data
433: , p_ptm_code => l_process_code

Line 443: -- , p_commit => FND_API.G_FALSE

439: , p_pt_bind_names => l_mt_bind_names
440: , p_pt_bind_values => l_mt_bind_values
441: , p_pt_bind_types => l_mt_bind_types
442: , p_recipient_email => l_email_address
443: -- , p_commit => FND_API.G_FALSE
444: );
445: IF (is_debug_statement_on) THEN
446: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
447: 'after call to okl_am_util_pvt.execute_fulfillment_request :'||l_return_status);

Line 450: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

446: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
447: 'after call to okl_am_util_pvt.execute_fulfillment_request :'||l_return_status);
448: END IF;
449:
450: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
451:
452: l_status_message := ' ';
453: LOOP
454:

Line 457: p_encoded => FND_API.G_FALSE,

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);
460:
461: IF (lx_error_rec.msg_count IS NOT NULL) THEN

Line 504: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

500:
501: END IF;
502:
503:
504: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
505: resultout := 'COMPLETE:ERROR';
506: ELSE
507: resultout := 'COMPLETE:SUCCESS';
508: END IF;

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 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: