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.INV_PROJECT dependencies on FND_API

Line 98: (l_cur_mfg_org_id IS NOT NULL AND l_cur_mfg_org_id <> FND_API.G_MISS_NUM)

94: l_cur_mfg_org_id := TO_NUMBER(FND_PROFILE.VALUE('MFG_ORGANIZATION_ID'));
95:
96: IF ( (pa_expenditure_org_id IS NOT NULL) AND
97: ( (l_cur_mfg_org_id IS NULL) OR
98: (l_cur_mfg_org_id IS NOT NULL AND l_cur_mfg_org_id <> FND_API.G_MISS_NUM)
99: )
100: ) THEN
101: FND_PROFILE.put('MFG_ORGANIZATION_ID',pa_expenditure_org_id);
102: END IF;

Line 551: If X_return_status <> FND_API.G_RET_STS_SUCCESS

547: t_task_id,
548: Source_Id);
549:
550: End If;
551: If X_return_status <> FND_API.G_RET_STS_SUCCESS
552: Then
553: translated_mesg := fnd_message.get ;
554: error_code := '';
555: error_expl := substr(translated_mesg,1,240) ;

Line 869: x_return_status := FND_API.G_RET_STS_SUCCESS;

865: l_req_project_id Number;
866: l_req_task_id Number;
867:
868: Begin
869: x_return_status := FND_API.G_RET_STS_SUCCESS;
870:
871: SELECT project_id,task_id
872: INTO l_req_project_id,l_req_task_id
873: FROM po_req_distributions_all

Line 882: X_return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

878:
879: Exception
880: When Others Then
881:
882: X_return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
883: FND_MSG_PUB.Build_Exc_Msg(
884: p_pkg_name =>'Inv_Project',
885: p_procedure_name => 'Get_project_info_from_Req');
886:

Line 907: x_return_status := FND_API.G_RET_STS_SUCCESS;

903: l_req_project_id Number;
904: l_req_task_id Number;
905:
906: Begin
907: x_return_status := FND_API.G_RET_STS_SUCCESS;
908:
909: SELECT prd.project_id, prd.task_id
910: INTO l_req_project_id,l_req_task_id
911: FROM po_req_distributions_all prd,

Line 922: X_return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

918:
919: Exception
920: When Others Then
921:
922: X_return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
923: FND_MSG_PUB.Build_Exc_Msg(
924: p_pkg_name =>'Inv_Project',
925: p_procedure_name => 'Get_project_info_for_RcvTrx');
926:

Line 947: x_return_status := FND_API.G_RET_STS_SUCCESS;

943: l_Project_locator_id Number;
944: l_return_status Varchar2(1);
945:
946: Begin
947: x_return_status := FND_API.G_RET_STS_SUCCESS;
948: If P_Req_Line_Id is null Then
949: Return;
950: Else
951: Get_project_info_from_Req(

Line 956: If l_return_status <> FND_API.G_RET_STS_SUCCESS

952: l_return_status,
953: l_req_project_id,
954: l_req_task_id,
955: P_Req_Line_Id);
956: If l_return_status <> FND_API.G_RET_STS_SUCCESS
957: Then
958: Return;
959: End If;
960: If l_req_project_id is null

Line 977: X_return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

973:
974: Exception
975: When Others Then
976:
977: X_return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
978: FND_MSG_PUB.Build_Exc_Msg(
979: p_pkg_name =>'Inv_Project',
980: p_procedure_name => 'Get_project_loc_for_prj_Req');
981:

Line 991: x_return_status := FND_API.G_RET_STS_SUCCESS;

987: l_Org_Id Number;
988: l_conreq_id number :=0; --bugfix 4643461
989:
990: Begin
991: x_return_status := FND_API.G_RET_STS_SUCCESS;
992:
993: l_conreq_id := fnd_global.conc_request_id;
994:
995: IF nvl(g_organization_id,-999) <> nvl(P_Organization_Id,-999) THEN

Line 1035: X_return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

1031:
1032: EXCEPTION
1033: WHEN OTHERS THEN
1034:
1035: X_return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1036: FND_MSG_PUB.Build_Exc_Msg(
1037: p_pkg_name =>'Inv_Project',
1038: p_procedure_name => 'Set_Org_client_info');
1039:

Line 1054: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

1050: L_OPERATING_UNIT VARCHAR2(30);
1051:
1052: BEGIN
1053:
1054: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1055:
1056: FND_PROFILE.PUT('MFG_ORGANIZATION_ID', TO_CHAR(P_ORGANIZATION_ID));
1057:
1058: FND_PROFILE.GET('ORG_ID', L_OPERATING_UNIT);

Line 1069: WHEN FND_API.G_EXC_ERROR THEN

1065: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );
1066:
1067: EXCEPTION
1068:
1069: WHEN FND_API.G_EXC_ERROR THEN
1070:
1071: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1072: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );
1073:

Line 1071: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

1067: EXCEPTION
1068:
1069: WHEN FND_API.G_EXC_ERROR THEN
1070:
1071: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1072: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );
1073:
1074: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1075:

Line 1074: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1070:
1071: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1072: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );
1073:
1074: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1075:
1076: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1077: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );
1078:

Line 1076: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

1072: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );
1073:
1074: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1075:
1076: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1077: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );
1078:
1079: WHEN OTHERS THEN
1080:

Line 1081: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

1077: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );
1078:
1079: WHEN OTHERS THEN
1080:
1081: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1082: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1083: FND_MSG_PUB.ADD_EXC_MSG( g_pkg_name, 'SET_SESSION_PARAMETERS');
1084: END IF;
1085: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );

Line 1101: x_return_status := FND_API.G_RET_STS_SUCCESS;

1097: IS
1098: l_project_id NUMBER := NULL;
1099: l_task_id NUMBER := NULL;
1100: BEGIN
1101: x_return_status := FND_API.G_RET_STS_SUCCESS;
1102:
1103: SELECT mil.segment19, mil.segment20
1104: INTO l_project_id, l_task_id
1105: FROM mtl_item_locations mil, wms_license_plate_numbers wlpn

Line 1135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1131: x_task_id := NULL;
1132: WHEN OTHERS THEN
1133: x_project_id := NULL;
1134: x_task_id := NULL;
1135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1136: FND_MSG_PUB.Count_And_Get
1137: (p_encoded => FND_API.G_FALSE,
1138: p_count => x_msg_count,
1139: p_data => x_msg_data);

Line 1137: (p_encoded => FND_API.G_FALSE,

1133: x_project_id := NULL;
1134: x_task_id := NULL;
1135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1136: FND_MSG_PUB.Count_And_Get
1137: (p_encoded => FND_API.G_FALSE,
1138: p_count => x_msg_count,
1139: p_data => x_msg_data);
1140: END;
1141:

Line 1142: WHEN FND_API.G_EXC_ERROR THEN

1138: p_count => x_msg_count,
1139: p_data => x_msg_data);
1140: END;
1141:
1142: WHEN FND_API.G_EXC_ERROR THEN
1143: x_project_id := NULL;
1144: x_task_id := NULL;
1145: x_return_status := FND_API.G_RET_STS_ERROR ;
1146: FND_MSG_PUB.Count_And_Get

Line 1145: x_return_status := FND_API.G_RET_STS_ERROR ;

1141:
1142: WHEN FND_API.G_EXC_ERROR THEN
1143: x_project_id := NULL;
1144: x_task_id := NULL;
1145: x_return_status := FND_API.G_RET_STS_ERROR ;
1146: FND_MSG_PUB.Count_And_Get
1147: (p_encoded => FND_API.G_FALSE,
1148: p_count => x_msg_count,
1149: p_data => x_msg_data);

Line 1147: (p_encoded => FND_API.G_FALSE,

1143: x_project_id := NULL;
1144: x_task_id := NULL;
1145: x_return_status := FND_API.G_RET_STS_ERROR ;
1146: FND_MSG_PUB.Count_And_Get
1147: (p_encoded => FND_API.G_FALSE,
1148: p_count => x_msg_count,
1149: p_data => x_msg_data);
1150: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1151: x_project_id := NULL;

Line 1150: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1146: FND_MSG_PUB.Count_And_Get
1147: (p_encoded => FND_API.G_FALSE,
1148: p_count => x_msg_count,
1149: p_data => x_msg_data);
1150: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1151: x_project_id := NULL;
1152: x_task_id := NULL;
1153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1154: FND_MSG_PUB.Count_And_Get

Line 1153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1149: p_data => x_msg_data);
1150: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1151: x_project_id := NULL;
1152: x_task_id := NULL;
1153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1154: FND_MSG_PUB.Count_And_Get
1155: (p_encoded => FND_API.G_FALSE,
1156: p_count => x_msg_count,
1157: p_data => x_msg_data);

Line 1155: (p_encoded => FND_API.G_FALSE,

1151: x_project_id := NULL;
1152: x_task_id := NULL;
1153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1154: FND_MSG_PUB.Count_And_Get
1155: (p_encoded => FND_API.G_FALSE,
1156: p_count => x_msg_count,
1157: p_data => x_msg_data);
1158: WHEN OTHERS THEN
1159: x_project_id := NULL;

Line 1161: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1157: p_data => x_msg_data);
1158: WHEN OTHERS THEN
1159: x_project_id := NULL;
1160: x_task_id := NULL;
1161: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1162: FND_MSG_PUB.Count_And_Get
1163: (p_encoded => FND_API.G_FALSE,
1164: p_count => x_msg_count,
1165: p_data => x_msg_data);

Line 1163: (p_encoded => FND_API.G_FALSE,

1159: x_project_id := NULL;
1160: x_task_id := NULL;
1161: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1162: FND_MSG_PUB.Count_And_Get
1163: (p_encoded => FND_API.G_FALSE,
1164: p_count => x_msg_count,
1165: p_data => x_msg_data);
1166: END get_proj_task_from_lpn;
1167:

Line 1299: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

1295: X_DISPLAY := 'ALL'||L_RETURN;
1296: X_CONCATENATED := L_CONCAT;
1297:
1298: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );
1299: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1300:
1301: EXCEPTION
1302: WHEN OTHERS THEN
1303:

Line 1308: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

1304: IF (l_debug = 1) THEN
1305: MYDEBUG('EXCEPTION RAISED IN GET_LOCATOR_METADATA '||SQLERRM);
1306: END IF;
1307:
1308: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1309: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1310: FND_MSG_PUB.ADD_EXC_MSG( g_pkg_name, 'GET_LOCATOR_METADATA');
1311: END IF;
1312: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );

Line 1463: MYDEBUG('Using FND APIs to get locator, project and task info');

1459:
1460: --If any of the segments has a validation type other than 'N'
1461: ELSE
1462: IF (l_debug = 1) THEN
1463: MYDEBUG('Using FND APIs to get locator, project and task info');
1464: END IF;
1465: L_CC_ID_RET := FND_FLEX_KEYVAL.VALIDATE_CCID(
1466: APPL_SHORT_NAME => 'INV',
1467: KEY_FLEX_CODE => 'MTLL',

Line 1541: * Does not use FND API's.

1537: END GET_LOCSEGS;
1538:
1539: /*
1540: * This function returns the Project Number of the Project Id passed
1541: * Does not use FND API's.
1542: */
1543: FUNCTION GET_PROJECT_NUMBER(p_project_id IN NUMBER) RETURN VARCHAR2 IS
1544: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1545: BEGIN

Line 1739: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

1735: X_CONCATENATED := L_CONCAT;
1736:
1737:
1738: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );
1739: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1740:
1741: EXCEPTION
1742: WHEN OTHERS THEN
1743:

Line 1749: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

1745: MYDEBUG('EXCEPTION RAISED IN conc_loc_qry '||SQLERRM);
1746: END IF;
1747: X_CONCATENATED := null;
1748:
1749: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1750: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1751: FND_MSG_PUB.ADD_EXC_MSG( g_pkg_name, 'conc_loc_qry');
1752: END IF;
1753: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );

Line 1825: MYDEBUG('Using FND APIs to get locator, project and task info');

1821:
1822: --If any of the segments has a validation type other than 'N'
1823: ELSE
1824: IF (l_debug = 1) THEN
1825: MYDEBUG('Using FND APIs to get locator, project and task info');
1826: END IF;
1827: L_CC_ID_RET := FND_FLEX_KEYVAL.VALIDATE_CCID(
1828: APPL_SHORT_NAME => 'INV',
1829: KEY_FLEX_CODE => 'MTLL',

Line 1944: l_new_segments := fnd_api.g_miss_char;

1940: IF l_new_segments IS NULL THEN
1941: l_new_segments := l_buf;
1942: /*bug 3905395 */
1943: IF l_buf IS NULL THEN
1944: l_new_segments := fnd_api.g_miss_char;
1945: END IF;
1946: ELSE
1947: l_new_segments := l_new_segments || g_delimiter || l_buf;
1948: END IF;

Line 2077: l_new_segments := fnd_api.g_miss_char;

2073: IF l_new_segments IS NULL THEN
2074: l_new_segments := l_buf;
2075: /*bug 3905395 */
2076: IF l_buf IS NULL THEN
2077: l_new_segments := fnd_api.g_miss_char;
2078: END IF;
2079: ELSE
2080: l_new_segments := l_new_segments || g_delimiter || l_buf;
2081: END IF;