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

Line 36: AND ( (a.inventory_revision IS NULL AND c.inventory_revision IS NULL) OR (a.inventory_revision IS NULL AND c.inventory_revision = FND_API.G_MISS_CHAR) OR (a.inventory_revision = c.inventory_revision))

32: AND a.inventory_item_id = c.inventory_item_id
33: AND c.inst_interface_id = d.inst_interface_id
34: AND c.inst_interface_id = p_interface_id
35: AND a.instance_usage_code NOT IN ('IN_RELATIONSHIP','RETURNED')
36: AND ( (a.inventory_revision IS NULL AND c.inventory_revision IS NULL) OR (a.inventory_revision IS NULL AND c.inventory_revision = FND_API.G_MISS_CHAR) OR (a.inventory_revision = c.inventory_revision))
37: AND ( (a.lot_number IS NULL AND c.lot_number IS NULL) OR (a.lot_number IS NULL AND c.lot_number = FND_API.G_MISS_CHAR) OR (a.lot_number = c.lot_number))
38: AND a.inv_organization_id = c.inv_organization_id
39: AND a.inv_subinventory_name = c.inv_subinventory_name
40: AND ( (a.inv_locator_id IS NULL AND c.inv_locator_id IS NULL) OR (a.inv_locator_id IS NULL AND c.inv_locator_id = FND_API.G_MISS_NUM) OR (a.inv_locator_id = c.inv_locator_id))

Line 37: AND ( (a.lot_number IS NULL AND c.lot_number IS NULL) OR (a.lot_number IS NULL AND c.lot_number = FND_API.G_MISS_CHAR) OR (a.lot_number = c.lot_number))

33: AND c.inst_interface_id = d.inst_interface_id
34: AND c.inst_interface_id = p_interface_id
35: AND a.instance_usage_code NOT IN ('IN_RELATIONSHIP','RETURNED')
36: AND ( (a.inventory_revision IS NULL AND c.inventory_revision IS NULL) OR (a.inventory_revision IS NULL AND c.inventory_revision = FND_API.G_MISS_CHAR) OR (a.inventory_revision = c.inventory_revision))
37: AND ( (a.lot_number IS NULL AND c.lot_number IS NULL) OR (a.lot_number IS NULL AND c.lot_number = FND_API.G_MISS_CHAR) OR (a.lot_number = c.lot_number))
38: AND a.inv_organization_id = c.inv_organization_id
39: AND a.inv_subinventory_name = c.inv_subinventory_name
40: AND ( (a.inv_locator_id IS NULL AND c.inv_locator_id IS NULL) OR (a.inv_locator_id IS NULL AND c.inv_locator_id = FND_API.G_MISS_NUM) OR (a.inv_locator_id = c.inv_locator_id))
41: AND b.party_id = d.party_id

Line 40: AND ( (a.inv_locator_id IS NULL AND c.inv_locator_id IS NULL) OR (a.inv_locator_id IS NULL AND c.inv_locator_id = FND_API.G_MISS_NUM) OR (a.inv_locator_id = c.inv_locator_id))

36: AND ( (a.inventory_revision IS NULL AND c.inventory_revision IS NULL) OR (a.inventory_revision IS NULL AND c.inventory_revision = FND_API.G_MISS_CHAR) OR (a.inventory_revision = c.inventory_revision))
37: AND ( (a.lot_number IS NULL AND c.lot_number IS NULL) OR (a.lot_number IS NULL AND c.lot_number = FND_API.G_MISS_CHAR) OR (a.lot_number = c.lot_number))
38: AND a.inv_organization_id = c.inv_organization_id
39: AND a.inv_subinventory_name = c.inv_subinventory_name
40: AND ( (a.inv_locator_id IS NULL AND c.inv_locator_id IS NULL) OR (a.inv_locator_id IS NULL AND c.inv_locator_id = FND_API.G_MISS_NUM) OR (a.inv_locator_id = c.inv_locator_id))
41: AND b.party_id = d.party_id
42: AND b.party_source_table = d.party_source_table
43: AND b.relationship_type_code = 'OWNER';
44:

Line 54: l_fnd_unexpected := FND_API.G_RET_STS_UNEXP_ERROR;

50: and msi.organization_id = cii.inv_organization_id
51: and cii.inst_interface_id = p_interface_id;
52:
53: BEGIN
54: l_fnd_unexpected := FND_API.G_RET_STS_UNEXP_ERROR;
55: x_return_status := 'E'; --fnd_api.g_ret_sts_success;
56: x_error_message := NULL;
57: OPEN instance_id_cur(p_inst_interface_id);
58: FETCH instance_id_cur INTO l_instance_id;

Line 55: x_return_status := 'E'; --fnd_api.g_ret_sts_success;

51: and cii.inst_interface_id = p_interface_id;
52:
53: BEGIN
54: l_fnd_unexpected := FND_API.G_RET_STS_UNEXP_ERROR;
55: x_return_status := 'E'; --fnd_api.g_ret_sts_success;
56: x_error_message := NULL;
57: OPEN instance_id_cur(p_inst_interface_id);
58: FETCH instance_id_cur INTO l_instance_id;
59: CLOSE instance_id_cur;

Line 68: x_return_status := fnd_api.g_ret_sts_success;

64: x_instance_id := l_instance_id;
65: EXCEPTION
66: WHEN e_exists THEN
67: x_instance_id := l_instance_id;
68: x_return_status := fnd_api.g_ret_sts_success;
69: WHEN others THEN
70: fnd_message.set_name('CSI','CSI_ML_UNEXP_SQL_ERROR');
71: fnd_message.set_token('API_NAME','CSI_ML_INTERFACE_TXNS_PVT.INSTANCE_EXISTS');
72: fnd_message.set_token('SQL_ERROR',SQLERRM);

Line 407: l_commit := fnd_api.g_false;

403: END IF;
404: END UPDATE_INTERFACE_TBL;
405:
406: BEGIN
407: l_commit := fnd_api.g_false;
408: l_init_msg_list := fnd_api.g_true;
409: l_validation_level := fnd_api.g_valid_level_full;
410: l_fnd_success := FND_API.G_RET_STS_SUCCESS;
411: l_fnd_unexpected := FND_API.G_RET_STS_UNEXP_ERROR;

Line 408: l_init_msg_list := fnd_api.g_true;

404: END UPDATE_INTERFACE_TBL;
405:
406: BEGIN
407: l_commit := fnd_api.g_false;
408: l_init_msg_list := fnd_api.g_true;
409: l_validation_level := fnd_api.g_valid_level_full;
410: l_fnd_success := FND_API.G_RET_STS_SUCCESS;
411: l_fnd_unexpected := FND_API.G_RET_STS_UNEXP_ERROR;
412: l_fnd_g_char := FND_API.G_MISS_CHAR;

Line 409: l_validation_level := fnd_api.g_valid_level_full;

405:
406: BEGIN
407: l_commit := fnd_api.g_false;
408: l_init_msg_list := fnd_api.g_true;
409: l_validation_level := fnd_api.g_valid_level_full;
410: l_fnd_success := FND_API.G_RET_STS_SUCCESS;
411: l_fnd_unexpected := FND_API.G_RET_STS_UNEXP_ERROR;
412: l_fnd_g_char := FND_API.G_MISS_CHAR;
413: l_fnd_g_num := FND_API.G_MISS_NUM;

Line 410: l_fnd_success := FND_API.G_RET_STS_SUCCESS;

406: BEGIN
407: l_commit := fnd_api.g_false;
408: l_init_msg_list := fnd_api.g_true;
409: l_validation_level := fnd_api.g_valid_level_full;
410: l_fnd_success := FND_API.G_RET_STS_SUCCESS;
411: l_fnd_unexpected := FND_API.G_RET_STS_UNEXP_ERROR;
412: l_fnd_g_char := FND_API.G_MISS_CHAR;
413: l_fnd_g_num := FND_API.G_MISS_NUM;
414: l_fnd_g_date := FND_API.G_MISS_DATE;

Line 411: l_fnd_unexpected := FND_API.G_RET_STS_UNEXP_ERROR;

407: l_commit := fnd_api.g_false;
408: l_init_msg_list := fnd_api.g_true;
409: l_validation_level := fnd_api.g_valid_level_full;
410: l_fnd_success := FND_API.G_RET_STS_SUCCESS;
411: l_fnd_unexpected := FND_API.G_RET_STS_UNEXP_ERROR;
412: l_fnd_g_char := FND_API.G_MISS_CHAR;
413: l_fnd_g_num := FND_API.G_MISS_NUM;
414: l_fnd_g_date := FND_API.G_MISS_DATE;
415: l_fnd_g_true := FND_API.G_TRUE;

Line 412: l_fnd_g_char := FND_API.G_MISS_CHAR;

408: l_init_msg_list := fnd_api.g_true;
409: l_validation_level := fnd_api.g_valid_level_full;
410: l_fnd_success := FND_API.G_RET_STS_SUCCESS;
411: l_fnd_unexpected := FND_API.G_RET_STS_UNEXP_ERROR;
412: l_fnd_g_char := FND_API.G_MISS_CHAR;
413: l_fnd_g_num := FND_API.G_MISS_NUM;
414: l_fnd_g_date := FND_API.G_MISS_DATE;
415: l_fnd_g_true := FND_API.G_TRUE;
416:

Line 413: l_fnd_g_num := FND_API.G_MISS_NUM;

409: l_validation_level := fnd_api.g_valid_level_full;
410: l_fnd_success := FND_API.G_RET_STS_SUCCESS;
411: l_fnd_unexpected := FND_API.G_RET_STS_UNEXP_ERROR;
412: l_fnd_g_char := FND_API.G_MISS_CHAR;
413: l_fnd_g_num := FND_API.G_MISS_NUM;
414: l_fnd_g_date := FND_API.G_MISS_DATE;
415: l_fnd_g_true := FND_API.G_TRUE;
416:
417: IF(l_debug_level>1) THEN

Line 414: l_fnd_g_date := FND_API.G_MISS_DATE;

410: l_fnd_success := FND_API.G_RET_STS_SUCCESS;
411: l_fnd_unexpected := FND_API.G_RET_STS_UNEXP_ERROR;
412: l_fnd_g_char := FND_API.G_MISS_CHAR;
413: l_fnd_g_num := FND_API.G_MISS_NUM;
414: l_fnd_g_date := FND_API.G_MISS_DATE;
415: l_fnd_g_true := FND_API.G_TRUE;
416:
417: IF(l_debug_level>1) THEN
418:

Line 415: l_fnd_g_true := FND_API.G_TRUE;

411: l_fnd_unexpected := FND_API.G_RET_STS_UNEXP_ERROR;
412: l_fnd_g_char := FND_API.G_MISS_CHAR;
413: l_fnd_g_num := FND_API.G_MISS_NUM;
414: l_fnd_g_date := FND_API.G_MISS_DATE;
415: l_fnd_g_true := FND_API.G_TRUE;
416:
417: IF(l_debug_level>1) THEN
418:
419: FND_File.Put_Line(Fnd_File.LOG,'Process_iface_txns-P_Source_System_Name : '||p_source_system_name);

Line 1621: iparty_det_rec.contact_party_id <> fnd_api.g_miss_num

1617: -- Added the following code to handle contacts.
1618: -- If contact_party_id is passed then I assume
1619: -- a contact should be created for the party.
1620: IF iparty_det_rec.contact_party_id IS NOT NULL AND
1621: iparty_det_rec.contact_party_id <> fnd_api.g_miss_num
1622: THEN
1623: prty_idx:=prty_idx + 1;
1624: c_party_tbl(prty_idx).instance_party_id:=fnd_api.g_miss_num;
1625: c_party_tbl(prty_idx).instance_id:=fnd_api.g_miss_num;

Line 1624: c_party_tbl(prty_idx).instance_party_id:=fnd_api.g_miss_num;

1620: IF iparty_det_rec.contact_party_id IS NOT NULL AND
1621: iparty_det_rec.contact_party_id <> fnd_api.g_miss_num
1622: THEN
1623: prty_idx:=prty_idx + 1;
1624: c_party_tbl(prty_idx).instance_party_id:=fnd_api.g_miss_num;
1625: c_party_tbl(prty_idx).instance_id:=fnd_api.g_miss_num;
1626: c_party_tbl(prty_idx).party_source_table:=iparty_det_rec.party_source_table;
1627: c_party_tbl(prty_idx).party_id:=iparty_det_rec.contact_party_id;
1628: c_party_tbl(prty_idx).relationship_type_code:=iparty_det_rec.contact_party_rel_type;

Line 1625: c_party_tbl(prty_idx).instance_id:=fnd_api.g_miss_num;

1621: iparty_det_rec.contact_party_id <> fnd_api.g_miss_num
1622: THEN
1623: prty_idx:=prty_idx + 1;
1624: c_party_tbl(prty_idx).instance_party_id:=fnd_api.g_miss_num;
1625: c_party_tbl(prty_idx).instance_id:=fnd_api.g_miss_num;
1626: c_party_tbl(prty_idx).party_source_table:=iparty_det_rec.party_source_table;
1627: c_party_tbl(prty_idx).party_id:=iparty_det_rec.contact_party_id;
1628: c_party_tbl(prty_idx).relationship_type_code:=iparty_det_rec.contact_party_rel_type;
1629: c_party_tbl(prty_idx).contact_flag:='Y';

Line 2764: l_Error_Message := FND_MSG_PUB.GET(l_msg_index, FND_API.G_FALSE);

2760: THEN
2761: l_msg_index := 1;
2762: l_Error_Message := l_Msg_Data;
2763: WHILE l_msg_count > 0 LOOP
2764: l_Error_Message := FND_MSG_PUB.GET(l_msg_index, FND_API.G_FALSE);
2765: l_msg_index := l_msg_index + 1;
2766: l_Msg_Count := l_Msg_Count - 1;
2767: END LOOP;
2768: RAISE g_exc_error;

Line 2824: l_Error_Message := FND_MSG_PUB.GET(l_msg_index, FND_API.G_FALSE);

2820: l_msg_index := 1;
2821: l_Error_Message := l_Msg_Data;
2822: WHILE l_msg_count > 0
2823: LOOP
2824: l_Error_Message := FND_MSG_PUB.GET(l_msg_index, FND_API.G_FALSE);
2825: l_msg_index := l_msg_index + 1;
2826: l_Msg_Count := l_Msg_Count - 1;
2827: END LOOP;
2828: RAISE g_exc_error;

Line 3015: l_Error_Message := FND_MSG_PUB.GET(l_msg_index, FND_API.G_FALSE);

3011: THEN
3012: l_msg_index := 1;
3013: l_Error_Message := l_Msg_Data;
3014: WHILE l_msg_count > 0 LOOP
3015: l_Error_Message := FND_MSG_PUB.GET(l_msg_index, FND_API.G_FALSE);
3016: l_msg_index := l_msg_index + 1;
3017: l_Msg_Count := l_Msg_Count - 1;
3018: END LOOP;
3019: RAISE g_exc_error;

Line 3043: l_Error_Message := FND_MSG_PUB.GET(l_msg_index, FND_API.G_FALSE);

3039: THEN
3040: l_msg_index := 1;
3041: l_Error_Message := l_Msg_Data;
3042: WHILE l_msg_count > 0 LOOP
3043: l_Error_Message := FND_MSG_PUB.GET(l_msg_index, FND_API.G_FALSE);
3044: l_msg_index := l_msg_index + 1;
3045: l_Msg_Count := l_Msg_Count - 1;
3046: END LOOP;
3047: RAISE g_exc_error;

Line 3078: l_return_status := fnd_api.g_ret_sts_success;

3074: l_failure_count := l_failure_count +1;
3075: END;
3076: END LOOP;
3077:
3078: l_return_status := fnd_api.g_ret_sts_success;
3079:
3080: IF(l_debug_level>1) THEN
3081: FND_File.Put_Line(Fnd_File.LOG,'No of Transactions Processed :'||l_txn_count);
3082: FND_File.Put_Line(Fnd_File.LOG,'No of successful Transactions :'||l_success_count);

Line 3156: l_Error_Message := FND_MSG_PUB.GET(l_msg_index, FND_API.G_FALSE);

3152: THEN
3153: l_msg_index := 1;
3154: l_Error_Message := l_Msg_Data;
3155: WHILE l_msg_count > 0 LOOP
3156: l_Error_Message := FND_MSG_PUB.GET(l_msg_index, FND_API.G_FALSE);
3157: l_msg_index := l_msg_index + 1;
3158: l_Msg_Count := l_Msg_Count - 1;
3159: END LOOP;
3160: --RAISE g_exc_error;

Line 3297: l_Error_Message := FND_MSG_PUB.GET(l_msg_index, FND_API.G_FALSE);

3293: THEN
3294: l_msg_index := 1;
3295: l_Error_Message := l_Msg_Data;
3296: WHILE l_msg_count > 0 LOOP
3297: l_Error_Message := FND_MSG_PUB.GET(l_msg_index, FND_API.G_FALSE);
3298: l_msg_index := l_msg_index + 1;
3299: l_Msg_Count := l_Msg_Count - 1;
3300: END LOOP;
3301: --RAISE g_exc_error;