eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZPB_PERSONAL_AW dependencies on FND_API

Line 150: p_shared_rw => FND_API.G_FALSE);

146: x_msg_count => l_msgCnt,
147: x_msg_data => l_msgData,
148: p_business_area_id => p_business_area_id,
149: p_shadow_id => p_user,
150: p_shared_rw => FND_API.G_FALSE);
151: end if;
152:
153: get_aws(p_user);
154:

Line 326: p_shared_rw => FND_API.G_FALSE);

322: x_msg_count => l_msgCnt,
323: x_msg_data => l_msgData,
324: p_business_area_id => p_business_area_id,
325: p_shadow_id => p_user,
326: p_shared_rw => FND_API.G_FALSE);
327: end if;
328: get_aws(p_user);
329:
330: -- Fix for Bug: 5842827 - start ...

Line 462: if x_return_status <> FND_API.G_RET_STS_UNEXP_ERROR and p_read_only = FND_API.G_FALSE then

458: and OBJECT_USER_ID = p_user
459: and STATUS <> 'SUBMITTED_TO_SHARED';
460: end if;
461:
462: if x_return_status <> FND_API.G_RET_STS_UNEXP_ERROR and p_read_only = FND_API.G_FALSE then
463: -- reset metadata refresh state table
464: update ZPB_ACCOUNT_STATES
465: set METADATA_SCOPE = 0, READ_SCOPE = 0, WRITE_SCOPE = 0, OWNERSHIP = 0,
466: LAST_UPDATE_DATE = sysdate,

Line 499: FND_API.G_RET_STS_UNEXP_ERROR);

495: zpb_aw.execute('aw detach '||g_olapSchema||'.'||g_personalAW);
496: zpb_aw.execute('call PA.ATTACH.PERSONAL('''||p_user||''' '''||
497: g_attach_mode||''')');
498: ZPB_ERROR_HANDLER.MERGE_STATUS(x_return_status,
499: FND_API.G_RET_STS_UNEXP_ERROR);
500:
501: end;
502: end if;
503:

Line 722: FND_API.G_RET_STS_UNEXP_ERROR);

718: FND_GLOBAL.RESP_ID||''' '''||
719: g_personalAW||''' '''||g_sharedAW||''')');
720: if (l_value <> 'S') then
721: ZPB_ERROR_HANDLER.MERGE_STATUS(x_return_status,
722: FND_API.G_RET_STS_UNEXP_ERROR);
723: end if;
724:
725: zpb_log.write('zpb_personal_aw.measures_shared_update.end', 'Done');
726: return true;

Line 904: FND_API.G_RET_STS_UNEXP_ERROR);

900: zpb_aw.execute ('aw detach '||g_olapSchema||'.'||g_personalAW);
901: zpb_aw.execute ('call PA.ATTACH.PERSONAL('''||p_user||''' '''||
902: g_attach_mode||''')');
903: ZPB_ERROR_HANDLER.MERGE_STATUS(x_return_status,
904: FND_API.G_RET_STS_UNEXP_ERROR);
905: return null;
906: end METADATA_UPDATE;
907:
908: -------------------------------------------------------------------------------

Line 935: FND_API.G_RET_STS_UNEXP_ERROR);

931: ZPB_ERROR_HANDLER.HANDLE_EXCEPTION (G_PKG_NAME,
932: l_proc,
933: 'ZPB_STARTUP_SEC_ERR_MSG');
934: ZPB_ERROR_HANDLER.MERGE_STATUS(x_return_status,
935: FND_API.G_RET_STS_UNEXP_ERROR);
936:
937: end SECURITY_UPDATE;
938:
939: -------------------------------------------------------------------------------

Line 1000: if not FND_API.Compatible_API_Call (l_api_version,

996: --
997: -- Begin generic Apps PL/SQL API:
998: --
999:
1000: if not FND_API.Compatible_API_Call (l_api_version,
1001: p_api_version,
1002: l_api_name,
1003: G_PKG_NAME) then
1004: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1004: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1000: if not FND_API.Compatible_API_Call (l_api_version,
1001: p_api_version,
1002: l_api_name,
1003: G_PKG_NAME) then
1004: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1005: end if;
1006:
1007: if (FND_API.TO_BOOLEAN (p_init_msg_list)) then
1008: FND_MSG_PUB.INITIALIZE;

Line 1007: if (FND_API.TO_BOOLEAN (p_init_msg_list)) then

1003: G_PKG_NAME) then
1004: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1005: end if;
1006:
1007: if (FND_API.TO_BOOLEAN (p_init_msg_list)) then
1008: FND_MSG_PUB.INITIALIZE;
1009: end if;
1010:
1011: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1011: x_return_status := FND_API.G_RET_STS_SUCCESS;

1007: if (FND_API.TO_BOOLEAN (p_init_msg_list)) then
1008: FND_MSG_PUB.INITIALIZE;
1009: end if;
1010:
1011: x_return_status := FND_API.G_RET_STS_SUCCESS;
1012: zpb_log.write('zpb_personal_aw.startup', 'Begin startup for '||p_user);
1013:
1014: --dbms_output.put_line ('Start: '||to_char(sysdate, 'HH:MI:SS'));
1015:

Line 1037: -- if (x_return_status = FND_API.G_RET_STS_SUCCESS) then

1033: end if;
1034:
1035: get_aws(p_user);
1036:
1037: -- if (x_return_status = FND_API.G_RET_STS_SUCCESS) then
1038: --dbms_output.put_line ('End Attach: '||to_char(sysdate, 'HH:MI:SS'));
1039:
1040: --
1041: -- Attempt to attach the Personal AW:

Line 1043: if (p_read_only = FND_API.G_FALSE) then

1039:
1040: --
1041: -- Attempt to attach the Personal AW:
1042: --
1043: if (p_read_only = FND_API.G_FALSE) then
1044: g_attach_mode := 'rw';
1045: l_rw_mode := FND_API.G_TRUE;
1046: l_ro := 'N';
1047: else

Line 1045: l_rw_mode := FND_API.G_TRUE;

1041: -- Attempt to attach the Personal AW:
1042: --
1043: if (p_read_only = FND_API.G_FALSE) then
1044: g_attach_mode := 'rw';
1045: l_rw_mode := FND_API.G_TRUE;
1046: l_ro := 'N';
1047: else
1048: g_attach_mode := 'ro';
1049: l_rw_mode := FND_API.G_FALSE;

Line 1049: l_rw_mode := FND_API.G_FALSE;

1045: l_rw_mode := FND_API.G_TRUE;
1046: l_ro := 'N';
1047: else
1048: g_attach_mode := 'ro';
1049: l_rw_mode := FND_API.G_FALSE;
1050: l_ro := 'Y';
1051: end if;
1052:
1053: if (l_resp <> l_mgrResp) then

Line 1061: p_sync_shared => FND_API.G_FALSE,

1057: x_msg_count => x_msg_count,
1058: x_msg_data => x_msg_data,
1059: p_user => p_user,
1060: p_attach_readwrite => l_rw_mode,
1061: p_sync_shared => FND_API.G_FALSE,
1062: p_detach_all => FND_API.G_TRUE);
1063: --
1064: -- Run upgrade script:
1065: --

Line 1062: p_detach_all => FND_API.G_TRUE);

1058: x_msg_data => x_msg_data,
1059: p_user => p_user,
1060: p_attach_readwrite => l_rw_mode,
1061: p_sync_shared => FND_API.G_FALSE,
1062: p_detach_all => FND_API.G_TRUE);
1063: --
1064: -- Run upgrade script:
1065: --
1066: l_comm := DBMS_AW.EVAL_TEXT ('DB.UPGRADE ('''||g_olapSchema||'.'||

Line 1089: if (p_read_only = FND_API.G_FALSE) then

1085: end loop;
1086:
1087: MEASURES_APPROVER_UPDATE(p_user, x_return_status);
1088:
1089: if (p_read_only = FND_API.G_FALSE) then
1090: zpb_aw.execute ('upd');
1091: commit;
1092: end if;
1093: --dbms_output.put_line ('Update end: '||to_char(sysdate, 'HH:MI:SS'));

Line 1113: if (FND_API.TO_BOOLEAN (p_commit)) then

1109: end if;
1110:
1111: -- end if;
1112:
1113: if (FND_API.TO_BOOLEAN (p_commit)) then
1114: commit work;
1115: end if;
1116:
1117: --

Line 1153: when FND_API.G_EXC_ERROR then

1149: zpb_log.write('zpb_personal_aw.startup.end',
1150: 'Completed startup for '||p_user);
1151: /*
1152: exception
1153: when FND_API.G_EXC_ERROR then
1154: x_return_status := FND_API.G_RET_STS_ERROR;
1155: FND_MSG_PUB.COUNT_AND_GET
1156: (p_count => x_msg_count,
1157: p_data => x_msg_data);

Line 1154: x_return_status := FND_API.G_RET_STS_ERROR;

1150: 'Completed startup for '||p_user);
1151: /*
1152: exception
1153: when FND_API.G_EXC_ERROR then
1154: x_return_status := FND_API.G_RET_STS_ERROR;
1155: FND_MSG_PUB.COUNT_AND_GET
1156: (p_count => x_msg_count,
1157: p_data => x_msg_data);
1158:

Line 1159: when FND_API.G_EXC_UNEXPECTED_ERROR then

1155: FND_MSG_PUB.COUNT_AND_GET
1156: (p_count => x_msg_count,
1157: p_data => x_msg_data);
1158:
1159: when FND_API.G_EXC_UNEXPECTED_ERROR then
1160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1161: FND_MSG_PUB.COUNT_AND_GET
1162: (p_count => x_msg_count,
1163: p_data => x_msg_data);

Line 1160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1156: (p_count => x_msg_count,
1157: p_data => x_msg_data);
1158:
1159: when FND_API.G_EXC_UNEXPECTED_ERROR then
1160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1161: FND_MSG_PUB.COUNT_AND_GET
1162: (p_count => x_msg_count,
1163: p_data => x_msg_data);
1164:

Line 1166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1162: (p_count => x_msg_count,
1163: p_data => x_msg_data);
1164:
1165: when OTHERS then
1166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1167: if (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) then
1168: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
1169: end if;
1170: FND_MSG_PUB.COUNT_AND_GET

Line 1453: FND_API.G_RET_STS_UNEXP_ERROR);

1449: 'ZPB_STARTUP_MEAS_DLT_ERR_MSG',
1450: 'INST',
1451: del_meas.AC_INSTANCE_ID);
1452: ZPB_ERROR_HANDLER.MERGE_STATUS(x_return_status,
1453: FND_API.G_RET_STS_UNEXP_ERROR);
1454: end;
1455: end loop;
1456:
1457: for personal in pers_to_attach

Line 1476: FND_API.G_RET_STS_UNEXP_ERROR);

1472: 'ZPB_STARTUP_APP_MEAS_ERR_MSG',
1473: 'OBJ',
1474: personal.OBJECT_USER_ID);
1475: ZPB_ERROR_HANDLER.MERGE_STATUS(x_return_status,
1476: FND_API.G_RET_STS_UNEXP_ERROR);
1477: end;
1478: end loop;
1479:
1480: end MEASURES_APPROVER_UPDATE;