APPS.EGO_ITEM_BULKLOAD_PKG dependencies on FND_API

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

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

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

3057: -- AND (EXISTS( -- there exists a row where item is being Created or updated in the same request
3058: -- SELECT 'X'
3059: -- FROM MTL_SYSTEM_ITEMS_INTERFACE MSI
3060: -- WHERE MSI.DESCRIPTION IS NOT NULL
3061: -- AND NVL(MSI.ITEM_NUMBER,FND_API.G_MISS_CHAR) = NVL(MSII.ITEM_NUMBER,FND_API.G_MISS_CHAR)
3062: -- AND SET_PROCESS_ID = p_set_process_id
3063: -- AND PROCESS_FLAG = G_PROCESS_STATUS
3064: -- )
3065: -- OR EXISTS(

Line 5873: p_commit IN VARCHAR2 DEFAULT FND_API.G_TRUE ,

5869: --------------------------------------------------------------------
5870: PROCEDURE process_netweights
5871: (
5872: p_resultfmt_usage_id IN NUMBER,
5873: p_commit IN VARCHAR2 DEFAULT FND_API.G_TRUE ,
5874: x_errbuff OUT NOCOPY VARCHAR2,
5875: x_retcode OUT NOCOPY VARCHAR2
5876: ) IS
5877:

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

5963:
5964: -------------------------------------------------------------
5965: -- Commit at the end.
5966: -------------------------------------------------------------
5967: IF (p_commit = FND_API.G_TRUE) THEN
5968: COMMIT;
5969: END IF;
5970:
5971: ------------------------------------------------------------

Line 6008: p_commit IN VARCHAR2 DEFAULT FND_API.G_TRUE ,

6004: p_user_id IN NUMBER,
6005: p_conc_request_id IN NUMBER,
6006: p_language_code IN VARCHAR2,
6007: p_caller_identifier IN VARCHAR2 DEFAULT EGO_ITEM_BULKLOAD_PKG.G_ITEM,
6008: p_commit IN VARCHAR2 DEFAULT FND_API.G_TRUE ,
6009: x_errbuff OUT NOCOPY VARCHAR2,
6010: x_retcode OUT NOCOPY VARCHAR2,
6011: p_start_upload IN VARCHAR2 DEFAULT FND_API.G_TRUE ,
6012: p_data_set_id IN NUMBER DEFAULT NULL

Line 6011: p_start_upload IN VARCHAR2 DEFAULT FND_API.G_TRUE ,

6007: p_caller_identifier IN VARCHAR2 DEFAULT EGO_ITEM_BULKLOAD_PKG.G_ITEM,
6008: p_commit IN VARCHAR2 DEFAULT FND_API.G_TRUE ,
6009: x_errbuff OUT NOCOPY VARCHAR2,
6010: x_retcode OUT NOCOPY VARCHAR2,
6011: p_start_upload IN VARCHAR2 DEFAULT FND_API.G_TRUE ,
6012: p_data_set_id IN NUMBER DEFAULT NULL
6013: ) IS
6014:
6015: -- Start OF comments

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

6418:
6419: -------------------------------------------------------------
6420: -- Commit at the end.
6421: -------------------------------------------------------------
6422: IF (p_commit = FND_API.G_TRUE) THEN
6423: COMMIT;
6424: Developer_Debug('COMMITing at the end.');
6425: END IF;
6426:

Line 6540: p_commit IN VARCHAR2 DEFAULT FND_API.G_TRUE,

6536:
6537: PROCEDURE Clear_Gtin_Attrs
6538: (
6539: p_resultfmt_usage_id IN NUMBER ,
6540: p_commit IN VARCHAR2 DEFAULT FND_API.G_TRUE,
6541: x_errbuff OUT NOCOPY VARCHAR2 ,
6542: x_ret_code OUT NOCOPY VARCHAR2
6543: )
6544: IS

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

6925:
6926: -------------------------------------------------------------
6927: -- Commit at the end.
6928: -------------------------------------------------------------
6929: IF (p_commit = FND_API.G_TRUE) THEN
6930: COMMIT;
6931: END IF;
6932:
6933: IF (l_is_debug) THEN

Line 7010: x_return_status := FND_API.G_RET_STS_SUCCESS;

7006: l_xset_id NUMBER;
7007:
7008: BEGIN
7009: Write_Debug (' started with params p_set_id: '||p_set_id||' p_org_id: '||p_org_id||' p_all_org: '||p_all_org);
7010: x_return_status := FND_API.G_RET_STS_SUCCESS;
7011: x_msg_count := 0;
7012: x_msg_data := NULL;
7013:
7014: --Only Item Row has p_set_id, setting batch id for the rest

Line 7224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

7220: END LOOP; -- for cc_row_identifier in 1..l_rows_processed
7221:
7222: EXCEPTION
7223: WHEN OTHERS THEN
7224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7225: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
7226: FND_MESSAGE.Set_Token('PKG_NAME', 'EGO_ITEM_BULKLOAD_PKG');
7227: FND_MESSAGE.Set_Token('API_NAME', 'Populate_Seq_Gen_Item_Nums');
7228: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

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

7225: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
7226: FND_MESSAGE.Set_Token('PKG_NAME', 'EGO_ITEM_BULKLOAD_PKG');
7227: FND_MESSAGE.Set_Token('API_NAME', 'Populate_Seq_Gen_Item_Nums');
7228: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
7229: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
7230: ,p_count => x_msg_count
7231: ,p_data => x_msg_data);
7232: END Populate_Seq_Gen_Item_Nums;
7233: