DBA Data[Home] [Help]

APPS.AMW_LOAD_PROC_DATA dependencies on FND_API

Line 458: lx_return_status := FND_API.G_RET_STS_SUCCESS;

454: L_PROCESS_REC.START_DATE := SYSDATE;
455:
456: ---begin
457: --SET THESE VALUES APPROPRIATELY ....
458: lx_return_status := FND_API.G_RET_STS_SUCCESS;
459: LX_MSG_COUNT := NULL;
460: LX_MSG_DATA := NULL;
461:
462: INSERT_AMW_PROCESS(

Line 469: IF lx_return_status <> FND_API.G_RET_STS_SUCCESS then

465: ,X_MSG_COUNT => LX_MSG_COUNT
466: ,X_MSG_DATA => LX_MSG_DATA
467: );
468:
469: IF lx_return_status <> FND_API.G_RET_STS_SUCCESS then
470: v_err_msg := ' ';
471: FOR x IN 1..lx_msg_count LOOP
472: if(length(v_err_msg) < 1800) then
473: v_err_msg := v_err_msg||' '||substr(fnd_msg_pub.get(p_msg_index => x,

Line 474: p_encoded => fnd_api.g_false), 1,100);

470: v_err_msg := ' ';
471: FOR x IN 1..lx_msg_count LOOP
472: if(length(v_err_msg) < 1800) then
473: v_err_msg := v_err_msg||' '||substr(fnd_msg_pub.get(p_msg_index => x,
474: p_encoded => fnd_api.g_false), 1,100);
475: end if;
476: END LOOP;
477: update_interface_with_error (v_err_msg
478: ,'AMW_PROCESS_VL'

Line 496: lx_return_status := FND_API.G_RET_STS_SUCCESS;

492: --IT DOES NOT MATTER HERE WHAT IS THE USER ENTERED APPROVAL STATUS
493: --SINCE APPROVALS ARE TAKEN CARE OF TOWARDS THE END
494: L_PROCESS_REC.APPROVAL_STATUS := 'D';
495: --SET THESE VALUES APPROPRIATELY ....
496: lx_return_status := FND_API.G_RET_STS_SUCCESS;
497: LX_MSG_COUNT := NULL;
498: LX_MSG_DATA := NULL;
499:
500: l_has_access := 'T';

Line 529: IF lx_return_status <> FND_API.G_RET_STS_SUCCESS then

525: ,X_MSG_COUNT => LX_MSG_COUNT
526: ,X_MSG_DATA => LX_MSG_DATA
527: );
528:
529: IF lx_return_status <> FND_API.G_RET_STS_SUCCESS then
530: v_err_msg := ' ';
531: FOR x IN 1..lx_msg_count LOOP
532: if(length(v_err_msg) < 1800) then
533: v_err_msg := v_err_msg||' '||substr(fnd_msg_pub.get(p_msg_index => x,

Line 534: p_encoded => fnd_api.g_false), 1,100);

530: v_err_msg := ' ';
531: FOR x IN 1..lx_msg_count LOOP
532: if(length(v_err_msg) < 1800) then
533: v_err_msg := v_err_msg||' '||substr(fnd_msg_pub.get(p_msg_index => x,
534: p_encoded => fnd_api.g_false), 1,100);
535: end if;
536: END LOOP;
537: update_interface_with_error (v_err_msg
538: ,'AMW_PROCESS_VL'

Line 549: lx_return_status := FND_API.G_RET_STS_SUCCESS;

545: -- for a delete
546: ---03.02.2005 npanandi: added check in the IF condition for v_error_found
547: IF(L_PROCESS_ID IS NOT NULL AND L_PARENT_PROCESS_ID IS NOT NULL AND INSERT_REC.REVISE_PROCESS_FLAG='D' and not v_error_found) THEN
548: --SET THESE VALUES APPROPRIATELY ....
549: lx_return_status := FND_API.G_RET_STS_SUCCESS;
550: LX_MSG_COUNT := NULL;
551: LX_MSG_DATA := NULL;
552: AMW_RL_HIERARCHY_PKG.DELETE_CHILD(
553: P_PARENT_PROCESS_ID => L_PARENT_PROCESS_ID

Line 603: lx_return_status := FND_API.G_RET_STS_SUCCESS;

599: END;
600:
601: --CALLING BELOW PROCEDURE TO ADD LINKS
602: --SET THESE VALUES APPROPRIATELY ....
603: lx_return_status := FND_API.G_RET_STS_SUCCESS;
604: LX_MSG_COUNT := NULL;
605: LX_MSG_DATA := NULL;
606: --THE BELOW METHOD HAS BEEN ADDED BY NPANANDI
607: --IT IS THE SAME AS ADD_EXISTING_PROCESS_AS_CHILD ...

Line 1586: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

1582: l_attachment_rec.media_id := lx_media_id;
1583:
1584: x_msg_data := null;
1585: x_msg_count := 0;
1586: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1587: AMw_ATTACHMENT_PVT.CREATE_FND_ATTACHMENT(
1588: p_api_version_number => 1,
1589: p_init_msg_list => FND_API.G_TRUE,
1590: x_return_status => X_RETURN_STATUS,

Line 1589: p_init_msg_list => FND_API.G_TRUE,

1585: x_msg_count := 0;
1586: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1587: AMw_ATTACHMENT_PVT.CREATE_FND_ATTACHMENT(
1588: p_api_version_number => 1,
1589: p_init_msg_list => FND_API.G_TRUE,
1590: x_return_status => X_RETURN_STATUS,
1591: x_msg_count => X_MSG_COUNT,
1592: x_msg_data => X_MSG_DATA,
1593: p_Fnd_Attachment_rec => l_attachment_rec,

Line 1858: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

1854: l_attachment_rec.media_id := lx_media_id;
1855:
1856: x_msg_data := null;
1857: x_msg_count := 0;
1858: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1859: AMW_ATTACHMENT_PVT.CREATE_FND_ATTACHMENT(
1860: p_api_version_number => 1,
1861: p_init_msg_list => FND_API.G_TRUE,
1862: x_return_status => X_RETURN_STATUS,

Line 1861: p_init_msg_list => FND_API.G_TRUE,

1857: x_msg_count := 0;
1858: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1859: AMW_ATTACHMENT_PVT.CREATE_FND_ATTACHMENT(
1860: p_api_version_number => 1,
1861: p_init_msg_list => FND_API.G_TRUE,
1862: x_return_status => X_RETURN_STATUS,
1863: x_msg_count => X_MSG_COUNT,
1864: x_msg_data => X_MSG_DATA,
1865: p_Fnd_Attachment_rec => l_attachment_rec,