APPS.EGO_ITEM_BULKLOAD_PKG dependencies on FND_API

Line 415: IF (l_log_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

411: G_ERRFILE_PATH_AND_NAME := l_log_output_dir||'/'||G_ERROR_FILE_NAME;
412:
413: developer_debug(' Log file location --> '||l_log_output_dir||'/'||G_ERROR_FILE_NAME ||' created with status '|| l_log_return_status);
414:
415: IF (l_log_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
416: developer_debug('Unable to open error log file. Error => '||l_errbuff);
417: END IF;
418:
419: END IF;--IF c_get_utl_file_dir%FOUND THEN

Line 3146: -- AND NVL(MSI.ITEM_NUMBER,FND_API.G_MISS_CHAR) = NVL(MSII.ITEM_NUMBER,FND_API.G_MISS_CHAR)

3142: -- AND (EXISTS( -- there exists a row where item is being Created or updated in the same request
3143: -- SELECT 'X'
3144: -- FROM MTL_SYSTEM_ITEMS_INTERFACE MSI
3145: -- WHERE MSI.DESCRIPTION IS NOT NULL
3146: -- AND NVL(MSI.ITEM_NUMBER,FND_API.G_MISS_CHAR) = NVL(MSII.ITEM_NUMBER,FND_API.G_MISS_CHAR)
3147: -- AND SET_PROCESS_ID = p_set_process_id
3148: -- AND PROCESS_FLAG = G_PROCESS_STATUS
3149: -- )
3150: -- OR EXISTS(

Line 6026: p_commit IN VARCHAR2 DEFAULT FND_API.G_TRUE ,

6022: --------------------------------------------------------------------
6023: PROCEDURE process_netweights
6024: (
6025: p_resultfmt_usage_id IN NUMBER,
6026: p_commit IN VARCHAR2 DEFAULT FND_API.G_TRUE ,
6027: x_errbuff OUT NOCOPY VARCHAR2,
6028: x_retcode OUT NOCOPY VARCHAR2
6029: ) IS
6030:

Line 6120: IF (p_commit = FND_API.G_TRUE) THEN

6116:
6117: -------------------------------------------------------------
6118: -- Commit at the end.
6119: -------------------------------------------------------------
6120: IF (p_commit = FND_API.G_TRUE) THEN
6121: COMMIT;
6122: END IF;
6123:
6124: ------------------------------------------------------------

Line 6161: p_commit IN VARCHAR2 DEFAULT FND_API.G_TRUE ,

6157: p_user_id IN NUMBER,
6158: p_conc_request_id IN NUMBER,
6159: p_language_code IN VARCHAR2,
6160: p_caller_identifier IN VARCHAR2 DEFAULT EGO_ITEM_BULKLOAD_PKG.G_ITEM,
6161: p_commit IN VARCHAR2 DEFAULT FND_API.G_TRUE ,
6162: x_errbuff OUT NOCOPY VARCHAR2,
6163: x_retcode OUT NOCOPY VARCHAR2,
6164: p_start_upload IN VARCHAR2 DEFAULT FND_API.G_TRUE ,
6165: p_data_set_id IN NUMBER DEFAULT NULL

Line 6164: p_start_upload IN VARCHAR2 DEFAULT FND_API.G_TRUE ,

6160: p_caller_identifier IN VARCHAR2 DEFAULT EGO_ITEM_BULKLOAD_PKG.G_ITEM,
6161: p_commit IN VARCHAR2 DEFAULT FND_API.G_TRUE ,
6162: x_errbuff OUT NOCOPY VARCHAR2,
6163: x_retcode OUT NOCOPY VARCHAR2,
6164: p_start_upload IN VARCHAR2 DEFAULT FND_API.G_TRUE ,
6165: p_data_set_id IN NUMBER DEFAULT NULL
6166: ) IS
6167:
6168: -- Start OF comments

Line 6575: IF (p_commit = FND_API.G_TRUE) THEN

6571:
6572: -------------------------------------------------------------
6573: -- Commit at the end.
6574: -------------------------------------------------------------
6575: IF (p_commit = FND_API.G_TRUE) THEN
6576: COMMIT;
6577: Developer_Debug('COMMITing at the end.');
6578: END IF;
6579:

Line 6693: p_commit IN VARCHAR2 DEFAULT FND_API.G_TRUE,

6689:
6690: PROCEDURE Clear_Gtin_Attrs
6691: (
6692: p_resultfmt_usage_id IN NUMBER ,
6693: p_commit IN VARCHAR2 DEFAULT FND_API.G_TRUE,
6694: x_errbuff OUT NOCOPY VARCHAR2 ,
6695: x_ret_code OUT NOCOPY VARCHAR2
6696: )
6697: IS

Line 7082: IF (p_commit = FND_API.G_TRUE) THEN

7078:
7079: -------------------------------------------------------------
7080: -- Commit at the end.
7081: -------------------------------------------------------------
7082: IF (p_commit = FND_API.G_TRUE) THEN
7083: COMMIT;
7084: END IF;
7085:
7086: IF (l_is_debug) THEN

Line 7163: x_return_status := FND_API.G_RET_STS_SUCCESS;

7159: l_xset_id NUMBER;
7160:
7161: BEGIN
7162: Write_Debug (' started with params p_set_id: '||p_set_id||' p_org_id: '||p_org_id||' p_all_org: '||p_all_org);
7163: x_return_status := FND_API.G_RET_STS_SUCCESS;
7164: x_msg_count := 0;
7165: x_msg_data := NULL;
7166:
7167: --Only Item Row has p_set_id, setting batch id for the rest

Line 7377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

7373: END LOOP; -- for cc_row_identifier in 1..l_rows_processed
7374:
7375: EXCEPTION
7376: WHEN OTHERS THEN
7377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7378: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
7379: FND_MESSAGE.Set_Token('PKG_NAME', 'EGO_ITEM_BULKLOAD_PKG');
7380: FND_MESSAGE.Set_Token('API_NAME', 'Populate_Seq_Gen_Item_Nums');
7381: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

Line 7382: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

7378: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
7379: FND_MESSAGE.Set_Token('PKG_NAME', 'EGO_ITEM_BULKLOAD_PKG');
7380: FND_MESSAGE.Set_Token('API_NAME', 'Populate_Seq_Gen_Item_Nums');
7381: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
7382: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
7383: ,p_count => x_msg_count
7384: ,p_data => x_msg_data);
7385: END Populate_Seq_Gen_Item_Nums;
7386: